tbl_home_content

INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Home Content', 'fa-users', '1', '3', 'y');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '3', 'Home Content', 'manage_home_content-nct', 'fa fa-cogs', '1', 'tbl_home_content', 'id', 'id', 'a', '1');

UPDATE `tbl_adminsection` SET `image` = 'far fa-image' WHERE `tbl_adminsection`.`id` = 3;
INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Contact Us', 'far fa-envelope', '1', '4', 'y');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '4', 'Contact Us', 'contactus-nct', 'fa fa-cogs', '1', 'tbl_contact_us', 'id', 'id', 'a', '1');


=========================================================================================
21-08-2025


tbl_how_it_works
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '3', 'How It Works', 'how_it_works-nct', 'fa fa-cogs', '1', 'tbl_how_it_works', 'id', 'id', 'a', '2');


=========================================================================================
22-08-2025

INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Service Parameters', 'fas fa-user-cog', '1', '5', 'y');

INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '3', 'Manage Services', 'services-nct', 'fas fa-cog', '1', 'tbl_services', 'id', 'id', 'a', '1');
UPDATE `tbl_adminrole` SET `sectionid` = '5' WHERE `tbl_adminrole`.`id` = 11;
UPDATE `tbl_adminrole` SET `pagenm` = 'manage_services-nct' WHERE `tbl_adminrole`.`id` = 11;

ALTER TABLE `tbl_services` ADD `image_name` VARCHAR(255) NOT NULL AFTER `service_type`;
ALTER TABLE `tbl_services` CHANGE `service_type` `service_type` ENUM('p','s') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Primary, Secondary';
ALTER TABLE `tbl_services` CHANGE `service_type` `service_type` ENUM('p','s') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 's' COMMENT 'Primary, Secondary';

=========================================================================================

25-08-2025

tbl_additional_services


INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Service Type', 'manage_service_type-nct', 'fas fa-cog', '2', 'tbl_service_type', 'id', 'id', 'a', '2');

tbl_service_type


tbl_service_film_quality
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Film Quality', 'manage_film_quality-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_service_film_quality', 'id', 'id', 'a', '3');


tbl_service_colors
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Colors', 'manage_color-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_service_colors', 'id', 'id', 'a', '4');

ALTER TABLE `tbl_service_colors` ADD `color_code` VARCHAR(200) NOT NULL AFTER `name`;


tbl_service_thickness
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Thickness', 'manage_thickness-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_service_thickness', 'id', 'id', 'a', '5');


tbl_service_tint_level
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Tint Level', 'manage_tint_level-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_service_tint_level', 'id', 'id', 'a', '6');


tbl_service_time_slot
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Time Slot', 'manage_time_slot-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_service_time_slot', 'id', 'id', 'a', '7');



UPDATE `tbl_adminrole` SET `table_name` = 'tbl_service_color_type' WHERE `tbl_adminrole`.`id` = 14;
RENAME TABLE `ridewrap_db`.`tbl_service_colors` TO `ridewrap_db`.`tbl_service_color_type`;

ALTER TABLE `tbl_service_color_type` DROP `color_code`;

tbl_service_colors



tbl_service_brands
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Brands', 'manage_brands-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_service_brands', 'id', 'id', 'a', '8');

tbl_wrap_type
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Wrap Type', 'manage_wrap_type-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_wrap_type', 'id', 'id', 'a', '9');




tbl_service_pricing
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '5', 'Manage Service Pricing', 'manage_service_pricing-nct', 'fas fa-cog', '1,2,3,4,5,6', 'tbl_service_pricing', 'id', 'id', 'a', '10');





RewriteRule ^booking-request/?$ modules-nct/booking_request-nct/index.php [L]
RewriteRule ^ajax-booking_request-nct/?$ modules-nct/booking_request-nct/ajax.booking_request-nct.php [L]




ALTER TABLE `tbl_service_requests` ADD `service_type_id` INT(11) NOT NULL AFTER `service_status`;
ALTER TABLE `tbl_wrap_type` ADD `service_id` INT(11) NOT NULL AFTER `id`;
ALTER TABLE `tbl_wrap_type` ADD FOREIGN KEY (`service_id`) REFERENCES `tbl_services`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE `tbl_service_requests` ADD `quality_id` INT(11) NOT NULL AFTER `service_type_id`, ADD `brand_id` INT(11) NOT NULL AFTER `quality_id`, ADD `color_type_id` INT(11) NOT NULL AFTER `brand_id`, ADD `colors_id` INT(11) NOT NULL AFTER `color_type_id`, ADD `wrap_type_id` INT(11) NOT NULL AFTER `colors_id`;





ALTER TABLE `tbl_service_requests` ADD `is_brand_recommended` ENUM('y','n') NOT NULL DEFAULT 'n' AFTER `quality_id`;
ALTER TABLE `tbl_service_requests` ADD `days` VARCHAR(255) NOT NULL AFTER `wrap_type_id`, ADD `time_slot` VARCHAR(255) NOT NULL AFTER `days`;
ALTER TABLE `tbl_users` ADD `location` VARCHAR(255) NOT NULL AFTER `phone_no`;
ALTER TABLE `tbl_service_requests` ADD `customizations` TEXT NOT NULL AFTER `time_slot`, ADD `notes` TEXT NOT NULL AFTER `customizations`;

Insert User & booking details
Set last 2 step HTML



INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '1', 'Manage Car Make', 'manage_car_make-nct', 'fa-file', '1,2,3,4,5,6', 'tbl_car_make', 'id', 'id', 'a', '6');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '1', 'Manage Car Model', 'manage_car_model-nct', 'fa-file', '1,2,3,4,5,6', 'tbl_car_model', 'id', 'id', 'a', '7');



tbl_car_make
tbl_car_model
ALTER TABLE `tbl_service_requests` ADD `booking_date` DATE NULL AFTER `days`;
ALTER TABLE `tbl_service_requests` ADD `make_id` INT(11) NOT NULL AFTER `notes`, ADD `model_id` INT(11) NOT NULL AFTER `make_id`, ADD `year` VARCHAR(110) NOT NULL AFTER `model_id`, ADD `color` VARCHAR(255) NOT NULL AFTER `year`;


============================== 17-09-2025 ======================================


ALTER TABLE `tbl_service_requests` ADD `request_id` VARCHAR(50) NOT NULL AFTER `service_id`;


INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Bookings', 'fa fa-calendar', '1', '6', 'y');



INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '6', 'Booking Requests', 'manage_booking_requests-nct', 'fa-file', '1,2,3,4,5,6', 'tbl_service_requests', 'id', 'id', 'a', '1');
UPDATE `tbl_adminrole` SET `sectionid` = '5' WHERE `tbl_adminrole`.`id` = 22;
UPDATE `tbl_adminrole` SET `sectionid` = '5' WHERE `tbl_adminrole`.`id` = 21;
ALTER TABLE `tbl_service_requests` ADD `booking_amount` FLOAT(11,2) NOT NULL AFTER `booking_date`;



INSERT INTO `tbl_site_settings` (`id`, `label`, `type`, `constant`, `class`, `required`, `value`, `hint`, `updated_date`, `is_active`) VALUES (NULL, 'Phone No.', 'textBox', 'ADMIN_PHONE_NO', 'logintextbox-bg', '1', '8548548548', NULL, '2025-18-09 12:13:16', 'y');





C:\MAMP\htdocs\RideWrap\templates-nct\header-nct.tpl.php


ALTER TABLE `tbl_users` CHANGE `status` `is_active` ENUM('y','n') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'n' COMMENT 'y=active,n=deactive';
ALTER TABLE `tbl_users` CHANGE `email_verified` `email_active` ENUM('y','n') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'n';
ALTER TABLE `tbl_users` CHANGE `is_active` `isActive` ENUM('y','n') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'n' COMMENT 'y=active,n=deactive';

INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '1', 'Manage constant', 'constant-nct', 'fa-file', '1,2,3,4,5,6', 'tbl_constant', 'id', 'id', 'a', '6');

UPDATE `tbl_adminrole` SET `status` = 'd' WHERE `tbl_adminrole`.`id` = 24;
ALTER TABLE `tbl_users` ADD `password_reset_key` TEXT NOT NULL AFTER `activation_code`, ADD `prk_generated_on` DATETIME NULL DEFAULT NULL AFTER `password_reset_key`;


tbl_constant
tbl_language


ALTER TABLE `tbl_users` ADD `date_of_birth` DATE NOT NULL AFTER `location`;
ALTER TABLE `tbl_users` ADD `gender` ENUM('male','female','n') NOT NULL DEFAULT 'n' AFTER `date_of_birth`;
ALTER TABLE `tbl_users` CHANGE `is_deactived` `isDeactivated` ENUM('y','n') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'n';
ALTER TABLE `tbl_users` CHANGE `activation_code` `activation_code` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'used while create new account & user reactivate their account';

UPDATE `tbl_site_settings` SET `label` = 'Instagram Link' WHERE `tbl_site_settings`.`id` = 12;
UPDATE `tbl_site_settings` SET `constant` = 'INSTAGRAM_LINK' WHERE `tbl_site_settings`.`id` = 12;


tbl_product_items

ALTER TABLE `tbl_product_items` ADD `type` ENUM('size','color','finish') NOT NULL DEFAULT 'size' AFTER `product_id`;

tbl_products_parameters


INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Products', 'fas fa-box', '1', '7', 'y');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '7', 'Products', 'manage_products-nct', 'fas fa-box', '1,2,3,4,5,6', 'tbl_products', 'id', 'id', 'a', '1');


ALTER TABLE `tbl_products` ADD `category_id` INT(11) NOT NULL AFTER `id`;


tbl_product_pricing
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '7', 'Product Pricing', 'manage_product_pricing-nct', 'fas fa-box', '1,2,3,4,5,6', 'tbl_product_pricing', 'id', 'id', 'a', '2');




tbl_orders
tbl_ordered_products

INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Orders', 'fas fa-box', '1', '8', 'y');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '8', 'Orders', 'manage_orders-nct', 'fas fa-box', '1,2,3,4,5,6', 'tbl_orders', 'id', 'id', 'a', '1');



<!-- Manage custom Quote -->
UPDATE `tbl_adminrole` SET `sectionid` = '7' WHERE `tbl_adminrole`.`id` = 27;
UPDATE `tbl_adminrole` SET `seq` = '3' WHERE `tbl_adminrole`.`id` = 27;

DELETE FROM tbl_adminsection WHERE `tbl_adminsection`.`id` = 8;

tbl_custom_quote
INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Custom Quote', 'fa-solid fa-quote-left', '1', '8', 'y');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '8', 'Custom Quotes', 'manage_custom_quote-nct', 'fas fa-box', '1,2,3,4,5,6', 'tbl_custom_quote', 'id', 'id', 'a', '1');
<!-- Manage custom Quote -->




tbl_notifications_list


### Notification Settings ###
RewriteRule ^notification-settings/$ /notification-settings [R=301,L]
RewriteRule ^notification-settings/?$ modules-nct/notification_settings-nct/index.php [L]
RewriteRule ^ajax-notification_settings-nct/?$ modules-nct/notification_settings-nct/ajax.notification_settings-nct.php [L]





### Orders list ###
RewriteRule ^my-orders/$ /my-orders [R=301,L]
RewriteRule ^my-orders/?$ modules-nct/my_orders-nct/index.php [L]
RewriteRule ^ajax-my_orders-nct/?$ modules-nct/my_orders-nct/ajax.my_orders-nct.php [L]


ALTER TABLE `tbl_service_pricing` ADD `service_type_id` INT(11) NOT NULL AFTER `service_id`;
ALTER TABLE `tbl_service_pricing` ADD FOREIGN KEY (`service_type_id`) REFERENCES `tbl_service_type`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `tbl_service_requests` CHANGE `service_status` `service_status` ENUM('open','booked','ongoing','completed','cancelled') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'open' COMMENT 'Open, Completed, Cancelled';
ALTER TABLE `tbl_service_requests` CHANGE `service_status` `service_status` ENUM('open','booked','ongoing','completed','cancelled') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'open' COMMENT 'Open,Booked,ongoing Completed, Cancelled';
ALTER TABLE `tbl_service_requests` CHANGE `service_status` `service_status` ENUM('booked','ongoing','completed','cancelled') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'booked' COMMENT 'Booked,ongoing Completed, Cancelled';
ALTER TABLE `tbl_orders` ADD `is_active` ENUM('y','n') NOT NULL DEFAULT 'y' AFTER `order_date`;


### Service Requests list ###
RewriteRule ^my-service-request/$ /my-service-request [R=301,L]
RewriteRule ^my-service-request/?$ modules-nct/my_booking_requests-nct/index.php [L]
RewriteRule ^ajax-my_booking_requests-nct/?$ modules-nct/my_booking_requests-nct/ajax.my_booking_requests-nct.php [L]


### Service Request detail page ###
RewriteRule ^service-request/([^./]+)/$ /service-request/([^./]+) [R=301,L]
RewriteRule ^service-request/([^./]+)?$ modules-nct/booking_request_detail-nct/index.php?id=$1 [QSA,L]

### Order detail page ###
RewriteRule ^order-detail/([^./]+)/$ /order-detail/([^./]+) [R=301,L]
RewriteRule ^order-detail/([^./]+)?$ modules-nct/order_detail-nct/index.php?id=$1 [QSA,L]


ALTER TABLE `tbl_ordered_products` ADD `pro_size_id` INT(11) NOT NULL AFTER `purchased_qty`, ADD `pro_color_id` INT(11) NOT NULL AFTER `pro_size_id`, ADD `pro_finish_id` INT(11) NOT NULL AFTER `pro_color_id`;

ALTER TABLE `tbl_custom_quote` CHANGE `type` `type` ENUM('product','service','both','n') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'n';
ALTER TABLE `tbl_custom_quote` DROP `global_id`;










### My Custom Quote ###
RewriteRule ^my-custom-quote/$ /my-custom-quote [R=301,L]
RewriteRule ^my-custom-quote/?$ modules-nct/my_custom_quotes-nct/index.php [L]
RewriteRule ^ajax-my_custom_quotes-nct/?$ modules-nct/my_custom_quotes-nct/ajax.my_custom_quotes-nct.php [L]



ALTER TABLE `tbl_custom_quote` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Details about the requirements';
ALTER TABLE `tbl_custom_quote` ADD `location` VARCHAR(255) NOT NULL AFTER `request_time`, ADD `remarks` TEXT NOT NULL AFTER `location`;




ALTER TABLE `tbl_service_requests` ADD `thickness_id` INT(11) NOT NULL COMMENT 'Only for PPF Service' AFTER `wrap_type_id`;
ALTER TABLE `tbl_service_requests` ADD `tint_level_id` INT(11) NOT NULL COMMENT 'Only for window tinting service' AFTER `thickness_id`;



### Product detail page ###
RewriteRule ^product-detail/([^./]+)/$ /product-detail/([^./]+) [R=301,L]
RewriteRule ^product-detail/([^./]+)?$ modules-nct/product_details-nct/index.php?id=$1 [QSA,L]
RewriteRule ^ajax-product_details-nct/?$ modules-nct/product_details-nct/ajax.product_details-nct.php [L]

### Review rating ###
RewriteRule ^reviews/$ /reviews [R=301,L]
RewriteRule ^reviews/?$ modules-nct/review_ratings-nct/index.php?id=$1 [QSA,L]
RewriteRule ^ajax-review_ratings-nct/?$ modules-nct/review_ratings-nct/ajax.review_ratings-nct.php [L]


### Cart ###
RewriteRule ^cart/$ /cart [R=301,L]
RewriteRule ^cart/?$ modules-nct/cart-nct/index.php?id=$1 [QSA,L]
RewriteRule ^ajax-cart-nct/?$ modules-nct/cart-nct/ajax.cart-nct.php [L]

ALTER TABLE `tbl_cart` ADD `price_id` INT(11) NOT NULL AFTER `qty`;


### Service detail page ###
RewriteRule ^service-detail/([^./]+)/$ /service-detail/([^./]+) [R=301,L]
RewriteRule ^service-detail/([^./]+)?$ modules-nct/service_detail-nct/index.php?id=$1 [QSA,L]
RewriteRule ^ajax-service_detail-nct/?$ modules-nct/service_detail-nct/ajax.service_detail-nct.php [L]

INSERT INTO `tbl_site_settings` (`id`, `label`, `type`, `constant`, `class`, `required`, `value`, `hint`, `updated_date`, `is_active`) VALUES ('13', 'Google Link', 'textbox', 'GOOGLE_LINK', 'logintextbox-bg', '1', 'https://google.com', NULL, '2015-10-24 15:37:58', 'y');


ALTER TABLE `tbl_reviews` CHANGE `review_type` `review_type` ENUM('product','service','custom_quote','n') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'n' COMMENT 'Product, Service, Custom Quote';
ALTER TABLE `tbl_reviews` ADD `order_id` INT(11) NOT NULL AFTER `global_id`;
ALTER TABLE `tbl_reviews` CHANGE `order_id` `order_id` INT(11) NOT NULL COMMENT 'use when review type is Product';



ALTER TABLE `tbl_home_content` ADD `product_info_title` VARCHAR(255) NOT NULL AFTER `video_description`, ADD `product_info_desc` TEXT NOT NULL AFTER `product_info_title`, ADD `product_info_image` VARCHAR(255) NOT NULL AFTER `product_info_desc`;

ALTER TABLE `tbl_services` ADD `icon_name` VARCHAR(255) NOT NULL AFTER `image_name`, ADD `description` TEXT NOT NULL AFTER `icon_name`;
ALTER TABLE `tbl_services` ADD `title` VARCHAR(255) NOT NULL COMMENT 'for detail page' AFTER `description`;

INSERT INTO `tbl_site_settings` (`id`, `label`, `type`, `constant`, `class`, `required`, `value`, `hint`, `updated_date`, `is_active`) VALUES (NULL, 'Show Review On Home Page', 'radio', 'SHOW_REVIEW_ON_HOME_PAGE', 'logintextbox-bg', '1', 'y', NULL, '2025-10-26 18:06:05', 'y');
INSERT INTO `tbl_site_settings` (`id`, `label`, `type`, `constant`, `class`, `required`, `value`, `hint`, `updated_date`, `is_active`) VALUES (NULL, 'Deposit Amount (%)', 'textBox', 'DEPOSIT_AMOUNT', 'logintextbox-bg', '1', '5', NULL, '2025-10-26 18:08:29', 'y');
ALTER TABLE `tbl_products` ADD `wrap_type_id` INT(11) NOT NULL AFTER `category_id`;


INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '3', 'Why Choose', 'why_choose-nct', 'fa fa-cogs', '1,2,3,4,5,6', 'tbl_why_choose', 'id', 'id', 'a', '3');

ALTER TABLE `tbl_service_requests` CHANGE `booking_amount` `booking_amount` FLOAT(11,2) NOT NULL COMMENT 'Final Cost';
ALTER TABLE `tbl_service_requests` ADD `deposit_amount` FLOAT(11,2) NOT NULL AFTER `booking_amount`;
ALTER TABLE `tbl_service_request_additional` ADD `amount` FLOAT(11,2) NOT NULL AFTER `tint_level_id`;
### invoice ###
RewriteRule ^invoice/([^./]+)?$ includes-nct/invoice-nct.php?id=$1 [L]

ALTER TABLE `tbl_services` ADD `slug` VARCHAR(255) NOT NULL AFTER `service_name`;
ALTER TABLE `tbl_wrap_type` ADD `slug` VARCHAR(255) NOT NULL AFTER `name`;



ALTER TABLE `tbl_service_pricing` ADD `make_id` INT(11) NOT NULL AFTER `service_id`, ADD `model_id` INT(11) NOT NULL AFTER `make_id`;
ALTER TABLE `tbl_service_pricing` ADD FOREIGN KEY (`make_id`) REFERENCES `tbl_car_make`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `tbl_service_pricing` ADD FOREIGN KEY (`model_id`) REFERENCES `tbl_car_model`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `tbl_service_pricing` CHANGE `service_type_id` `service_type_id` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE `tbl_service_pricing` CHANGE `model_id` `model_id` INT(11) NOT NULL DEFAULT '0';



ALTER TABLE `tbl_service_pricing` CHANGE `service_type_id` `service_type_id` INT(11) NULL;
ALTER TABLE `tbl_service_pricing` CHANGE `model_id` `model_id` INT(11) NULL;
ALTER TABLE `tbl_service_pricing` CHANGE `make_id` `make_id` INT(11) NULL;
ALTER TABLE `tbl_service_pricing` CHANGE `service_id` `service_id` INT(11) NULL;


tbl_partners
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '3', 'Manage Partners', 'manage_partners-nct', 'fa fa-cogs', '1', 'tbl_partners', 'id', 'id', 'a', '4');


ALTER TABLE `tbl_service_requests` CHANGE `service_status` `service_status` ENUM('pending','booked','ongoing','completed','cancelled') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'booked' COMMENT 'Pending,Booked,ongoing Completed, Cancelled';
ALTER TABLE `tbl_service_requests` CHANGE `service_status` `service_status` ENUM('pending','booked','ongoing','completed','cancelled') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'pending' COMMENT 'Pending,Booked,ongoing Completed, Cancelled';
ALTER TABLE `tbl_product_items` ADD `slug` VARCHAR(255) NOT NULL AFTER `name`;

### Search Product ###
RewriteRule ^search/$ /search [R=301,L]
RewriteRule ^search/?$ modules-nct/search_products-nct/index.php [L]
RewriteRule ^ajax-search_products-nct/?$ modules-nct/search_products-nct/ajax.search_products-nct.php [L]


ALTER TABLE `tbl_service_requests` ADD `additional_service_ids` VARCHAR(255) NOT NULL COMMENT 'add comma speared ids of secondary services' AFTER `ip_address`;
ALTER TABLE `tbl_service_type` ADD `description` TEXT NOT NULL AFTER `type_name`;

ALTER TABLE `tbl_service_pricing` CHANGE `price` `price` FLOAT(11,2) NOT NULL DEFAULT '0';


RewriteRule ^get-quote/(.*)/$ /get-quote/(.*) [R=301,L]
RewriteRule ^get-quote/(.*)?$ modules-nct/get_quote-nct/index.php?service_type_id=$1 [L]
RewriteRule ^get-quote/(.*)/?$ modules-nct/get_quote-nct/index.php?service_type_id=$1 [L]
RewriteRule ^ajax-get_quote-nct/?$ modules-nct/get_quote-nct/ajax.get_quote-nct.php [L]

ALTER TABLE `tbl_orders` CHANGE `order_status` `order_status` ENUM('pending','placed','shipped','delivered','refunded','cancelled') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'pending' COMMENT 'pending,placed,shipped,delivered,refunded,cancelled';
ALTER TABLE `tbl_orders` CHANGE `order_date` `order_date` DATETIME NULL DEFAULT NULL;

ALTER TABLE `tbl_orders` ADD `sub_total` FLOAT(11,2) NOT NULL AFTER `total_amount`, ADD `shipping_charge` FLOAT(11,2) NOT NULL AFTER `sub_total`;

ALTER TABLE `tbl_service_requests` CHANGE `additional_service_ids` `additional_service_id` INT(11) NOT NULL;


ALTER TABLE `tbl_service_colors` ADD `file_name` VARCHAR(255) NULL AFTER `color_code`;

C:\MAMP\htdocs\ride_wrap\admin-nct\templates-nct\manage_color-nct\
C:\MAMP\htdocs\ride_wrap\admin-nct\modules-nct\manage_color-nct\

ALTER TABLE `tbl_service_requests` ADD `custom_color_image` VARCHAR(255) NOT NULL AFTER `colors_id`;



tbl_product_finish
tbl_product_type




INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '7', 'Manage Product Finish', 'manage_product_finish-nct', 'fas fa-box', '1,2,3,4,5,6', 'tbl_product_finish', 'id', 'id', 'a', '1');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '7', 'Manage Product Type', 'manage_product_type-nct', 'fas fa-box', '1,2,3,4,5,6', 'tbl_product_type', 'id', 'id', 'a', '2');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '7', 'Manage Product Colors', 'manage_product_colors-nct', 'fas fa-box', '1,2,3,4,5,6', 'tbl_product_colors', 'id', 'id', 'a', '3');
UPDATE `tbl_adminrole` SET `seq` = '3' WHERE `tbl_adminrole`.`id` = 25;
UPDATE `tbl_adminrole` SET `seq` = '4' WHERE `tbl_adminrole`.`id` = 26;
UPDATE `tbl_adminrole` SET `seq` = '5' WHERE `tbl_adminrole`.`id` = 27;
UPDATE `tbl_adminrole` SET `seq` = '4' WHERE `tbl_adminrole`.`id` = 25;
UPDATE `tbl_adminrole` SET `seq` = '5' WHERE `tbl_adminrole`.`id` = 26;
UPDATE `tbl_adminrole` SET `seq` = '6' WHERE `tbl_adminrole`.`id` = 27;
UPDATE `tbl_adminrole` SET `title` = 'Product Orders' WHERE `tbl_adminrole`.`id` = 27;



ALTER TABLE `tbl_service_color_type` ADD `condition_name` VARCHAR(255) NOT NULL AFTER `name`;
ALTER TABLE `tbl_service_colors` ADD `updated_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `created_date`;
UPDATE `tbl_adminrole` SET `title` = 'Manage Service Colors' WHERE `tbl_adminrole`.`id` = 14;



tbl_product_color_type
tbl_product_colors


UPDATE `tbl_adminrole` SET `pagenm` = 'manage_color-nct' WHERE `tbl_adminrole`.`id` = 33;


ALTER TABLE `tbl_products` ADD `qty` INT(11) NOT NULL AFTER `description`, ADD `discounted_price` FLOAT(11,2) NOT NULL AFTER `qty`, ADD `price` FLOAT(11,2) NOT NULL AFTER `discounted_price`;
ALTER TABLE `tbl_product_items` CHANGE `type` `type` ENUM('size','color','finish','type') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'size' COMMENT 'size, color, finish, type';

ALTER TABLE `tbl_product_pricing` ADD `type_id` INT(11) NOT NULL AFTER `finish_id`;
ALTER TABLE `tbl_product_pricing` ADD FOREIGN KEY (`type_id`) REFERENCES `tbl_product_type`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `tbl_product_pricing` CHANGE `pro_color_id` `color_id` INT(11) NOT NULL;
ALTER TABLE `tbl_product_pricing` DROP FOREIGN KEY `tbl_product_pricing_ibfk_5`; ALTER TABLE `tbl_product_pricing` ADD CONSTRAINT `tbl_product_pricing_ibfk_5` FOREIGN KEY (`type_id`) REFERENCES `tbl_product_items`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `tbl_ordered_products` ADD `pro_type_id` INT(11) NOT NULL AFTER `pro_finish_id`;


ALTER TABLE `tbl_products` ADD `color_type_val` ENUM('n','plain_color','design') NOT NULL COMMENT 'Plain Colors, Designs, n = if no category' AFTER `price`;
ALTER TABLE `tbl_products` CHANGE `color_type_val` `color_type_val` ENUM('n','plain_color','design') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'n' COMMENT 'Plain Colors, Designs, n = if no category';

ALTER TABLE `tbl_product_type` ADD `slug` VARCHAR(255) NOT NULL AFTER `name`;
ALTER TABLE `tbl_product_finish` ADD `slug` VARCHAR(255) NOT NULL AFTER `name`;

ALTER TABLE `tbl_product_color_type` ADD `slug` VARCHAR(255) NOT NULL AFTER `name`;

ALTER TABLE `tbl_product_pricing` CHANGE `color_id` `color_id` INT(11) NOT NULL COMMENT 'This is color type id';
ALTER TABLE ridewrap_db.tbl_product_pricing DROP FOREIGN KEY tbl_product_pricing_ibfk_3;
ALTER TABLE `tbl_product_pricing` DROP INDEX `pro_color_id`;
ALTER TABLE `tbl_products` ADD `color_type_id` INT(11) NULL DEFAULT NULL AFTER `price`;

ALTER TABLE `tbl_cart` ADD `color_id` INT(11) NOT NULL AFTER `price_id`;
ALTER TABLE `tbl_ordered_products` ADD `pro_color_type_id` INT(11) NOT NULL AFTER `pro_size_id`;

ALTER TABLE `tbl_service_requests` CHANGE `color_type_id` `color_type_id` INT(11) NOT NULL COMMENT 'if value 0 then use select custom color';

ALTER TABLE `tbl_service_color_type` CHANGE `condition_name` `slug` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;



1. Cart >> Link On product Name
2. Product Detail page >> Single image then hide thumbnail
3. Search >> Apply button hide show
4. Booking Request >> Calender Condition
5. My Custom Quote >> Changes As pr discussion



<!-- google login -->


RewriteRule ^signin/google/$ /signin/google [R=301,L]
RewriteRule ^signin/google$ modules-nct/registration-nct/index.php?social_media=google [QSA,L]


ALTER TABLE `tbl_users` ADD `identifier` VARCHAR(255) NOT NULL AFTER `activation_code`;

D:\MAMP\htdocs\ride_wrap\templates-nct\login-nct\login-nct.tpl.php
D:\MAMP\htdocs\ride_wrap\templates-nct\registration-nct\registration-nct.tpl.php
D:\MAMP\htdocs\ride_wrap\modules-nct\registration-nct\index.php
D:\MAMP\htdocs\ride_wrap\modules-nct\registration-nct\class.registration-nct.php
D:\MAMP\htdocs\ride_wrap\themes-nct\css-nct\developer-nct.css
D:\MAMP\htdocs\ride_wrap\templates-nct\head-nct.tpl.php


Need to upload in staging =====================================================

ALTER TABLE `tbl_car_model` ADD `make_id` INT(11) NOT NULL AFTER `id`;
ALTER TABLE `tbl_car_model` ADD FOREIGN KEY (`make_id`) REFERENCES `tbl_car_make`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `tbl_home_content` ADD `is_youtube_link` VARCHAR(255) NOT NULL COMMENT 'Use this field to fetch if video is uploaded with youtube link or from gallery' AFTER `banner_description`;
ALTER TABLE `tbl_home_content` CHANGE `is_youtube_link` `is_youtube_link` ENUM('y','n') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'y' COMMENT 'Use this field to fetch if video is uploaded with youtube link or from gallery';
ALTER TABLE `tbl_home_content` CHANGE `video` `video` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'home page youtube video or video file name ';

tbl_banner_media
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '3', 'Manage Banner Media', 'manage_banner_media-nct', 'fa fa-cogs', '1', 'tbl_banner_media', 'id', 'id', 'a', '5');

INSERT INTO `tbl_site_settings` (`id`, `label`, `type`, `constant`, `class`, `required`, `value`, `hint`, `updated_date`, `is_active`) VALUES (NULL, 'Whatsapp No.', 'textBox', 'ADMIN_PHONE_NO', 'logintextbox-bg', '1', '+999-9-999-9999', 'Add Number with country code(Ex. +912152854582)', '2026-05-22 15:54:28', 'y');
INSERT INTO `tbl_site_settings` (`id`, `label`, `type`, `constant`, `class`, `required`, `value`, `hint`, `updated_date`, `is_active`) VALUES (NULL, 'Tiktok Link', 'textbox', 'TIKTOK_LINK', 'logintextbox-bg', '1', 'http://tiktok.com', NULL, '2026-05-22 15:37:58', 'y');
ALTER TABLE `tbl_site_settings` ADD `sequence` INT(11) NOT NULL DEFAULT '0' AFTER `is_active`;
UPDATE `tbl_site_settings` SET `constant` = 'WHATSAPP_NO' WHERE `tbl_site_settings`.`id` = 25;



D:\MAMP\htdocs\ride_wrap\admin-nct\templates-nct\manage_car_model-nct\form-nct.tpl.php
D:\MAMP\htdocs\ride_wrap\admin-nct\modules-nct\manage_car_model-nct\class.manage_car_model-nct.php
D:\MAMP\htdocs\ride_wrap\admin-nct\modules-nct\manage_car_model-nct\index.php
D:\MAMP\htdocs\ride_wrap\admin-nct\templates-nct\manage_car_model-nct\manage_car_model-nct.tpl.php


============================================= 11-08-2026 =========================================================

ALTER TABLE `tbl_services` ADD `min_price` FLOAT(11,2) NOT NULL AFTER `title`, ADD `max_price` FLOAT(11,2) NOT NULL AFTER `min_price`;


ALTER TABLE `tbl_custom_quote` ADD `time_slot` VARCHAR(255) NOT NULL AFTER `request_time`;

INSERT INTO `tbl_adminsection` (`id`, `section_name`, `image`, `type`, `order`, `isActive`) VALUES (NULL, 'Manage Reviews', 'fa fa-star', '1', '10', 'y');
INSERT INTO `tbl_adminrole` (`id`, `sectionid`, `title`, `pagenm`, `image`, `page_action`, `table_name`, `table_field`, `table_primary_field`, `status`, `seq`) VALUES (NULL, '1', 'Manage Reviews', 'manage_reviews-nct', 'fa-file', '1,2,3,4,5,6', 'tbl_reviews', 'id', 'id', 'a', '1');
UPDATE `tbl_adminrole` SET `sectionid` = '9' WHERE `tbl_adminrole`.`id` = 35;
ALTER TABLE `tbl_reviews` ADD `review_title` VARCHAR(255) NOT NULL AFTER `review`;



ALTER TABLE `tbl_reviews` CHANGE `review_title` `car_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `tbl_reviews` ADD `name` VARCHAR(255) NOT NULL AFTER `car_name`;
ALTER TABLE `tbl_reviews` CHANGE `name` `service_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'for admin added review';
ALTER TABLE `tbl_reviews` ADD `service_id` INT(11) NOT NULL COMMENT 'for admin review' AFTER `review_type`;
ALTER TABLE `tbl_reviews` ADD `is_added_by_admin` ENUM('y','n') NOT NULL DEFAULT 'n' AFTER `service_name`;
ALTER TABLE `tbl_reviews` DROP `service_id`;
ALTER TABLE `tbl_reviews` ADD `first_name` VARCHAR(255) NOT NULL AFTER `review`, ADD `last_name` VARCHAR(255) NOT NULL AFTER `first_name`;
ALTER TABLE `tbl_reviews` CHANGE `review_by` `review_by` INT(11) UNSIGNED NOT NULL DEFAULT '0';





1. Get Quote Form
2. Booking Form - Pricing & last step
3. Review Module - New Module
4. cart before & after login