-- ===================================================================== -- Fill `menu`.`LinkLaravel` and `menu`.`Icon` in PRODUCTION (bukanmain2) -- from the values held in the development database. -- -- Target : bukanmain2.menu (437 rows, ID 1-437, AUTO_INCREMENT=438) -- source dump: two db/menu/menu.sql, generated 2026-08-14 10:20 -- Source : colorindochemtrainertia.menu (632 rows), read 2026-08-14 -- Written : 2026-08-14 -- -- --------------------------------------------------------------------- -- RUN THIS AFTER migrate_bukanmain_to_63.sql -- NOT BEFORE -- --------------------------------------------------------------------- -- `menu`.`LinkLaravel`, `menu`.`Icon` and `menu`.`Path` do not exist in production until -- migrate_bukanmain_to_63.sql adds them (its "ALTER TABLE `menu` ADD COLUMN" block). Run -- this file first and every statement below fails with ERROR 1054 Unknown column. -- -- Order on production: -- 1. audit_bukanmain_before_migrate.sql (reads only) -- 2. migrate_bukanmain_to_63.sql (adds the three columns) -- 3. this file -- -- deploy.sh ships all three into the destination root, flat, on every deploy. -- -- --------------------------------------------------------------------- -- WHY THE `WHERE ID` VALUES ARE NOT THE DEV IDs -- --------------------------------------------------------------------- -- The two menu tables are NOT ID-aligned. IDs agree for 1-99 and 101-281; -- from 282 upward the two databases grew apart and the same ID denotes a -- different menu on each side. Examples: -- -- createbudgetandtarget.php production ID 299 dev ID 310 -- listcompanyrebate.php production ID 377 dev ID 346 -- liststockopname.php production ID 320 dev ID 334 -- -- So `WHERE ID = ` would write the wrong route onto 107 of the -- 253 rows below. Each row is matched on IDENTITY instead: -- -- 1. Rows with a legacy `Link` are matched on that `Link` -- the PHP page a -- menu opens is what makes it that menu. Ties broken by Name, then -- IsShow, then IsDeleted. -- 2. Group rows (empty `Link`) are matched on `Name` AND on their parent -- already having been matched to the candidate's parent, iterated to a -- fixpoint. Name alone is not enough: production 243 'Feedback' lives -- under 225 Complain & Returns, while dev 1689/1777 'Feedback' live under -- Quotation and LWR. Same name, three different menus. -- (dev ParentID NULL is treated as production ParentID 0.) -- -- Every statement carries the dev ID and the legacy Link it was matched on, -- so each line can be checked by hand. -- -- --------------------------------------------------------------------- -- SCOPE AND DECISIONS -- --------------------------------------------------------------------- -- * Source rows: all 388 dev rows carrying a LinkLaravel and/or an Icon, -- soft-deleted ones included (your choice). 319 matched a production row, -- landing on 253 distinct production rows. -- * 66 production rows were claimed by more than one dev row. 65 of those -- are a live row and its soft-deleted twin holding IDENTICAL values, so -- there was nothing to decide; the live row was used. The one real -- conflict was production 373 -- your decision, recorded below. -- * `Path` is NOT written: all 632 dev rows have an empty Path, so there is -- nothing to copy. -- * Icon is copied verbatim, NULL included, so the two tables end up equal. -- * Production LinkLaravel/Icon/Path are empty on all 437 rows today, so -- nothing here overwrites an existing value. -- -- Rolls back as a unit: START TRANSACTION ... COMMIT. -- ===================================================================== SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET NAMES utf8mb4 */; START TRANSACTION; -- --------------------------------------------------------------------- -- RESOLVED CONFLICT -- --------------------------------------------------------------------- -- production 373 (createcompanyrebate.php, Name='Create Request Company Rebate') -- [dropped] dev 348 IsDeleted=0 IsShow=0 Name='Create Company Rebate' LinkLaravel='/company-rebates/create-own' -- [CHOSEN ] dev 436 IsDeleted=0 IsShow=1 Name='Create Request Company Rebate' LinkLaravel='/company-rebates/create' -- reason: dev 436 carries the same Name as the production row and is the visible one. -- --------------------------------------------------------------------- -- 253 UPDATE statements, ordered by production ID -- --------------------------------------------------------------------- UPDATE `menu` SET `LinkLaravel` = '/user-logins', `Icon` = '' WHERE `ID` = 3; -- listuserlogin.php (dev 3) UPDATE `menu` SET `LinkLaravel` = '/role-menus', `Icon` = NULL WHERE `ID` = 4; -- listrolemenu.php (dev 4) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Building' WHERE `ID` = 8; -- group 'Company' (dev 8) UPDATE `menu` SET `LinkLaravel` = '/companies', `Icon` = 'Building' WHERE `ID` = 9; -- listcompany.php (dev 9) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Settings' WHERE `ID` = 11; -- group 'Pengelolaan' (dev 11) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Box' WHERE `ID` = 21; -- group 'Stock Sample' (dev 21) UPDATE `menu` SET `LinkLaravel` = '/stock-samples', `Icon` = NULL WHERE `ID` = 22; -- listbarangs.php (dev 22) UPDATE `menu` SET `LinkLaravel` = '/stock-samples/create', `Icon` = NULL WHERE `ID` = 23; -- listsamplesinserts.php (dev 23) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Package' WHERE `ID` = 24; -- group 'Sample Order' (dev 24) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/create', `Icon` = 'Plus' WHERE `ID` = 25; -- createsampleorder.php (dev 25) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/approval-pm', `Icon` = 'List' WHERE `ID` = 26;-- listsamplerequestapprovalpm.php (dev 26) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/approval-sm', `Icon` = 'List' WHERE `ID` = 27;-- listsamplerequestapprovalsm.php (dev 27) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/packing', `Icon` = 'List' WHERE `ID` = 28; -- listsamplerequestpacking.php (dev 28) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/surat-jalan', `Icon` = 'List' WHERE `ID` = 29;-- listsamplerequestsuratjalan.php (dev 29) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/good-issue', `Icon` = 'List' WHERE `ID` = 30; -- listsamplerequestgoodissue.php (dev 30) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/feedback', `Icon` = 'List' WHERE `ID` = 31; -- listsamplerequestfeedback.php (dev 31) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-request', `Icon` = 'List' WHERE `ID` = 32;-- listsamplerequest.php (dev 32) UPDATE `menu` SET `LinkLaravel` = '/sample-orders', `Icon` = 'List' WHERE `ID` = 33; -- listallsamplerequest.php (dev 33) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'FileText' WHERE `ID` = 34; -- group 'Quotation' (dev 34) UPDATE `menu` SET `LinkLaravel` = '/quotations/create', `Icon` = 'Plus' WHERE `ID` = 35; -- createquotation.php (dev 35) UPDATE `menu` SET `LinkLaravel` = '/menus', `Icon` = NULL WHERE `ID` = 39; -- listmenu.php (dev 39) UPDATE `menu` SET `LinkLaravel` = '/quotations/approval-pm', `Icon` = 'ClipboardCheck' WHERE `ID` = 40;-- listquotationapprovalpm.php (dev 40) UPDATE `menu` SET `LinkLaravel` = '/roles', `Icon` = NULL WHERE `ID` = 41; -- listrole.php (dev 41) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-surat-jalan', `Icon` = 'List' WHERE `ID` = 42;-- listsamplerequestreprintsuratjalan.php (dev 42) UPDATE `menu` SET `LinkLaravel` = '/stock-samples/all', `Icon` = NULL WHERE `ID` = 43; -- listsamplesall.php (dev 43) UPDATE `menu` SET `LinkLaravel` = '/stock-samples/details', `Icon` = NULL WHERE `ID` = 44; -- listsamples.php (dev 44) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-details', `Icon` = 'List' WHERE `ID` = 45;-- listsampledetails.php (dev 45) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-details-pm', `Icon` = 'List' WHERE `ID` = 46;-- listsampledetailspm.php (dev 46) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-details-sm', `Icon` = 'List' WHERE `ID` = 47;-- listsampledetailssm.php (dev 47) UPDATE `menu` SET `LinkLaravel` = '/departments', `Icon` = '' WHERE `ID` = 48; -- listdepartment.php (dev 48) UPDATE `menu` SET `LinkLaravel` = '/marital-statuses', `Icon` = '' WHERE `ID` = 49; -- listmaritalstatus.php (dev 49) UPDATE `menu` SET `LinkLaravel` = '/employees', `Icon` = '' WHERE `ID` = 50; -- listuser.php (dev 50) UPDATE `menu` SET `LinkLaravel` = '/quotations/approval-sm', `Icon` = 'ClipboardCheck' WHERE `ID` = 60;-- listquotationapprovalsm.php (dev 60) UPDATE `menu` SET `LinkLaravel` = '/quotations/feedback', `Icon` = 'MessageSquare' WHERE `ID` = 62;-- listquotationfeedback.php (dev 62) UPDATE `menu` SET `LinkLaravel` = '/quotations', `Icon` = NULL WHERE `ID` = 63; -- listquotation.php (dev 63) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-all', `Icon` = 'Grid' WHERE `ID` = 64; -- listquotationall.php (dev 64) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-details', `Icon` = 'ListMenu' WHERE `ID` = 66;-- listquotationdetailslists.php (dev 66) UPDATE `menu` SET `LinkLaravel` = '/documents/principal', `Icon` = '' WHERE `ID` = 67; -- listdocument.php (dev 67) UPDATE `menu` SET `LinkLaravel` = '/documents/principal/download', `Icon` = '' WHERE `ID` = 68; -- listdocumentprincipaldownload.php (dev 68) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-vs-stock', `Icon` = 'List' WHERE `ID` = 70;-- listsampledetailsvsstock.php (dev 70) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-details-pm', `Icon` = 'ListMenu' WHERE `ID` = 73;-- listquotationdetailspm.php (dev 73) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-details-sm', `Icon` = 'ListMenu' WHERE `ID` = 74;-- listquotationdetailssm.php (dev 74) UPDATE `menu` SET `LinkLaravel` = '/companies/all', `Icon` = 'Building' WHERE `ID` = 76; -- listcompanyall.php (dev 76) UPDATE `menu` SET `LinkLaravel` = '/companies/sm', `Icon` = 'Building' WHERE `ID` = 77; -- listcompanyallsm.php (dev 77) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Route' WHERE `ID` = 79; -- group 'Visit Report' (dev 79) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/create', `Icon` = '' WHERE `ID` = 80; -- createvisitplan.php (dev 80) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/create-report', `Icon` = '' WHERE `ID` = 82; -- listvisitplanreport.php?StatusID=1 (dev 82) UPDATE `menu` SET `LinkLaravel` = '/visit-plans', `Icon` = '' WHERE `ID` = 83; -- listvisitplanreport.php (dev 83) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/view-all', `Icon` = '' WHERE `ID` = 84; -- listvisitplanreportall.php (dev 84) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/view-sm', `Icon` = '' WHERE `ID` = 85; -- listvisitplanreportallsm.php (dev 85) UPDATE `menu` SET `LinkLaravel` = '/market-surveys', `Icon` = '' WHERE `ID` = 86; -- listmarketsurvey.php (dev 86) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/calendar', `Icon` = '' WHERE `ID` = 88; -- listvisitplancalendar.php (dev 88) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/calendar/all', `Icon` = '' WHERE `ID` = 89; -- listvisitplancalendarall.php (dev 89) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/calendar/sm', `Icon` = '' WHERE `ID` = 92; -- listvisitplancalendarsm.php (dev 92) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/calendar/pm', `Icon` = '' WHERE `ID` = 94; -- listvisitplanbydate.php (dev 94) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/approval-pm', `Icon` = '' WHERE `ID` = 95; -- listvisitplanreportallpm.php (dev 95) UPDATE `menu` SET `LinkLaravel` = '/visit-report-actions', `Icon` = '' WHERE `ID` = 96; -- listvraction1.php (dev 96) UPDATE `menu` SET `LinkLaravel` = '/quotations/create-for-others', `Icon` = NULL WHERE `ID` = 97;-- createquotationsalesadmin.php (dev 97) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/create-sales-admin', `Icon` = '' WHERE `ID` = 98;-- createsampleordersalesadmin.php (dev 98) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'FileText' WHERE `ID` = 99; -- group 'Document' (dev 99) UPDATE `menu` SET `LinkLaravel` = '/market-surveys/pm', `Icon` = '' WHERE `ID` = 101; -- listmarketsurveypm.php (dev 101) UPDATE `menu` SET `LinkLaravel` = '/market-surveys/sm', `Icon` = '' WHERE `ID` = 102; -- listmarketsurveysm.php (dev 102) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'FlaskConical' WHERE `ID` = 103; -- group 'Lab Work Request' (dev 103) UPDATE `menu` SET `LinkLaravel` = '/lwrs/create', `Icon` = 'Plus' WHERE `ID` = 104; -- createlabworkrequest.php (dev 104) UPDATE `menu` SET `LinkLaravel` = '/lwrs/create-for-others', `Icon` = NULL WHERE `ID` = 105; -- createlwr2.php (dev 105) UPDATE `menu` SET `LinkLaravel` = '/lwrs/approval-pm', `Icon` = 'ClipboardCheck' WHERE `ID` = 106;-- listlwrapprovalpm.php (dev 106) UPDATE `menu` SET `LinkLaravel` = '/lwrs/approval-sm', `Icon` = 'ClipboardCheck' WHERE `ID` = 107;-- listlwrapprovalsm.php (dev 107) UPDATE `menu` SET `LinkLaravel` = '/lwrs/pengerjaan-lab', `Icon` = 'FlaskConical' WHERE `ID` = 108;-- listlwrpengerjaanlab.php (dev 108) UPDATE `menu` SET `LinkLaravel` = '/lwrs/feedback', `Icon` = 'MessageSquare' WHERE `ID` = 109; -- listlwrfeedback.php (dev 109) UPDATE `menu` SET `LinkLaravel` = '/lwrs', `Icon` = 'ListChecks' WHERE `ID` = 110; -- listlwr.php (dev 110) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-all', `Icon` = 'List' WHERE `ID` = 111; -- listlwrall.php (dev 111) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-details', `Icon` = 'List' WHERE `ID` = 112; -- listlwrdetailslists.php (dev 112) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-details-pm', `Icon` = 'List' WHERE `ID` = 113; -- listlwrdetailspm.php (dev 113) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-details-sm', `Icon` = 'List' WHERE `ID` = 114; -- listlwrdetailssm.php (dev 114) UPDATE `menu` SET `LinkLaravel` = '/documents/internal', `Icon` = '' WHERE `ID` = 115; -- listdocumentuploadinternal.php (dev 115) UPDATE `menu` SET `LinkLaravel` = '/documents/internal/download', `Icon` = '' WHERE `ID` = 116; -- listdocumentinternaldownload.php (dev 116) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-details-mm', `Icon` = 'List' WHERE `ID` = 118;-- listsampledetailsmm.php (dev 118) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-details-mm', `Icon` = 'ListMenu' WHERE `ID` = 119;-- listquotationdetailsmm.php (dev 119) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-details-cs', `Icon` = 'ListMenu' WHERE `ID` = 120;-- listquotationdetailslistcs.php?page=1&StatusID=3,6,7# (dev 120) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/view-mm', `Icon` = '' WHERE `ID` = 121; -- listvisitplanreportallmm.php (dev 121) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-details-mm', `Icon` = 'List' WHERE `ID` = 122; -- listlwrdetailsmm.php (dev 122) UPDATE `menu` SET `LinkLaravel` = '/stock-samples/pm', `Icon` = NULL WHERE `ID` = 123; -- listbarangspm.php (dev 123) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/calendar/mm', `Icon` = '' WHERE `ID` = 124; -- listvisitplanbydatemm.php (dev 124) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-all-lab', `Icon` = 'Microscope' WHERE `ID` = 125; -- listlwrlab.php (dev 125) UPDATE `menu` SET `LinkLaravel` = '/group-divisions', `Icon` = NULL WHERE `ID` = 126; -- listgroupdivision.php (dev 126) UPDATE `menu` SET `LinkLaravel` = '/lwr-feedback-statuses', `Icon` = NULL WHERE `ID` = 136; -- listlwrfeedbackstatus.php (dev 136) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Trophy' WHERE `ID` = 137; -- group 'Success Story' (dev 137) UPDATE `menu` SET `LinkLaravel` = '/success-stories/create', `Icon` = '' WHERE `ID` = 138; -- createsuccessstory.php (dev 138) UPDATE `menu` SET `LinkLaravel` = '/success-stories/create-for-others', `Icon` = '' WHERE `ID` = 139;-- createsuccessstorysalesadmin.php (dev 139) UPDATE `menu` SET `LinkLaravel` = '/success-stories', `Icon` = '' WHERE `ID` = 140; -- listsuccessstory.php (dev 140) UPDATE `menu` SET `LinkLaravel` = '/success-stories/all', `Icon` = '' WHERE `ID` = 141; -- listsuccessstoryall.php (dev 141) UPDATE `menu` SET `LinkLaravel` = '/divisions', `Icon` = NULL WHERE `ID` = 147; -- listdivision.php (dev 147) UPDATE `menu` SET `LinkLaravel` = '/credit-ceilings/review-cs', `Icon` = NULL WHERE `ID` = 155; -- listcreditceilingapprovalcs.php (dev 155) UPDATE `menu` SET `LinkLaravel` = '/credit-ceilings/review-finance', `Icon` = NULL WHERE `ID` = 156;-- listcreditceilingapprovalfinance.php (dev 156) UPDATE `menu` SET `LinkLaravel` = '/credit-ceilings/approval-sm', `Icon` = NULL WHERE `ID` = 157;-- listcreditceilingapprovalsm.php (dev 157) UPDATE `menu` SET `LinkLaravel` = '/credit-ceilings/approval-ceo', `Icon` = NULL WHERE `ID` = 158;-- listcreditceilingapprovalceo.php (dev 158) UPDATE `menu` SET `LinkLaravel` = '/credit-ceilings/input-ast', `Icon` = NULL WHERE `ID` = 159; -- listcreditceilinginputast.php (dev 159) UPDATE `menu` SET `LinkLaravel` = '/credit-ceilings/view-all', `Icon` = NULL WHERE `ID` = 160; -- listcreditceilingall.php (dev 160) UPDATE `menu` SET `LinkLaravel` = '/credit-ceilings/view-request', `Icon` = NULL WHERE `ID` = 161;-- listcreditceilingrequest.php (dev 161) UPDATE `menu` SET `LinkLaravel` = '/banks', `Icon` = NULL WHERE `ID` = 172; -- listbank.php (dev 172) UPDATE `menu` SET `LinkLaravel` = '/bank-divisions', `Icon` = NULL WHERE `ID` = 173; -- listbankdivision.php (dev 173) UPDATE `menu` SET `LinkLaravel` = '/branches', `Icon` = '' WHERE `ID` = 174; -- listbranch.php (dev 174) UPDATE `menu` SET `LinkLaravel` = '/structure-tree', `Icon` = '' WHERE `ID` = 177; -- structuretree.php (dev 177) UPDATE `menu` SET `LinkLaravel` = '/principal-analysis', `Icon` = 'List' WHERE `ID` = 213; -- astlistpm.php (dev 213) UPDATE `menu` SET `LinkLaravel` = '/principal-analysis/all', `Icon` = 'List' WHERE `ID` = 214; -- astlistallpm.php (dev 214) UPDATE `menu` SET `LinkLaravel` = '/quotations/process-to-order', `Icon` = 'Package' WHERE `ID` = 218;-- listquotationprocesstororder.php?IsOrder=on (dev 218) UPDATE `menu` SET `LinkLaravel` = '/quotations/good-receive', `Icon` = 'ClipboardCheck' WHERE `ID` = 219;-- listquotationgoodreceive.php (dev 219) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'BarChart' WHERE `ID` = 220; -- group 'Principal' (dev 220) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'ShieldAlert' WHERE `ID` = 225; -- group 'Complain & Returns' (dev 225) UPDATE `menu` SET `LinkLaravel` = '/complaints/create', `Icon` = NULL WHERE `ID` = 226; -- createcomplain.php (dev 226) UPDATE `menu` SET `LinkLaravel` = '/complaints/review/pm', `Icon` = NULL WHERE `ID` = 228; -- listreviewcomplainpm.php (dev 228) UPDATE `menu` SET `LinkLaravel` = '/complaints/review/sm', `Icon` = NULL WHERE `ID` = 229; -- listreviewcomplainsm.php (dev 229) UPDATE `menu` SET `LinkLaravel` = '/complaints/review/cs', `Icon` = NULL WHERE `ID` = 230; -- listreviewcomplaincs.php (dev 230) UPDATE `menu` SET `LinkLaravel` = '/complaints/review/finance', `Icon` = NULL WHERE `ID` = 231; -- listreviewcomplainfinance.php (dev 231) UPDATE `menu` SET `LinkLaravel` = '/complaints/review/accounting', `Icon` = NULL WHERE `ID` = 233;-- listreviewcomplainaccounting.php (dev 233) UPDATE `menu` SET `LinkLaravel` = '/complaints/review/logistic', `Icon` = NULL WHERE `ID` = 234;-- listreviewcomplainlogistic.php (dev 234) UPDATE `menu` SET `LinkLaravel` = '/complaints/ceo', `Icon` = NULL WHERE `ID` = 235; -- listcomplainceo.php (dev 235) UPDATE `menu` SET `LinkLaravel` = '/complaints/complete/pm', `Icon` = NULL WHERE `ID` = 237; -- listassigncomplainpm.php (dev 237) UPDATE `menu` SET `LinkLaravel` = '/complaints/complete/sm', `Icon` = NULL WHERE `ID` = 238; -- listassigncomplainsm.php (dev 238) UPDATE `menu` SET `LinkLaravel` = '/complaints/complete/cs', `Icon` = NULL WHERE `ID` = 239; -- listassigncomplaincs.php (dev 239) UPDATE `menu` SET `LinkLaravel` = '/complaints/complete/finance', `Icon` = NULL WHERE `ID` = 240;-- listassigncomplainfinance.php (dev 240) UPDATE `menu` SET `LinkLaravel` = '/complaints/complete/accounting', `Icon` = NULL WHERE `ID` = 241;-- listassigncomplainaccounting.php (dev 241) UPDATE `menu` SET `LinkLaravel` = '/complaints/complete/logistic', `Icon` = NULL WHERE `ID` = 242;-- listassigncomplainlogistic.php (dev 242) UPDATE `menu` SET `LinkLaravel` = '/complaints', `Icon` = NULL WHERE `ID` = 250; -- listcomplain.php (dev 250) UPDATE `menu` SET `LinkLaravel` = '/complaints/all', `Icon` = NULL WHERE `ID` = 251; -- listcomplainall.php (dev 251) UPDATE `menu` SET `LinkLaravel` = '/complain-types', `Icon` = NULL WHERE `ID` = 253; -- listcomplaintype.php (dev 253) UPDATE `menu` SET `LinkLaravel` = '/complaints/close', `Icon` = NULL WHERE `ID` = 256; -- listclosecomplain.php (dev 256) UPDATE `menu` SET `LinkLaravel` = '/vehicle-colors', `Icon` = '' WHERE `ID` = 258; -- listvehiclecolor.php (dev 258) UPDATE `menu` SET `LinkLaravel` = '/vehicle-fuel-types', `Icon` = '' WHERE `ID` = 259; -- listvehiclefueltype.php (dev 259) UPDATE `menu` SET `LinkLaravel` = '/vehicle-brands', `Icon` = '' WHERE `ID` = 260; -- listvehiclebrand.php (dev 260) UPDATE `menu` SET `LinkLaravel` = '/vehicle-brand-types', `Icon` = '' WHERE `ID` = 261; -- listvehiclebrandtype.php (dev 261) UPDATE `menu` SET `LinkLaravel` = '/vehicles', `Icon` = '' WHERE `ID` = 262; -- listvehicle.php (dev 262) UPDATE `menu` SET `LinkLaravel` = '/vehicle-service-types', `Icon` = NULL WHERE `ID` = 263; -- listvehicleservicetype.php (dev 263) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Route' WHERE `ID` = 264; -- group 'General Affair' (dev 264) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/create', `Icon` = NULL WHERE `ID` = 266; -- createvehicleservicerequest.php (dev 266) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/create-all', `Icon` = NULL WHERE `ID` = 267;-- createvehicleservicerequestall.php (dev 267) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/review-ga', `Icon` = NULL WHERE `ID` = 268; -- listvehiclerequestreviewga.php (dev 268) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/approval-ga', `Icon` = NULL WHERE `ID` = 269;-- listvehiclerequestapprovalga.php (dev 269) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/finance-dp', `Icon` = NULL WHERE `ID` = 270;-- listvehiclerequestfinancedp.php (dev 270) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/ga-processing', `Icon` = NULL WHERE `ID` = 271;-- listvehiclerequestassignmentga.php (dev 271) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/finance-payment', `Icon` = NULL WHERE `ID` = 272;-- listvehiclerequestfinancepayment.php (dev 272) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/ga-completion', `Icon` = NULL WHERE `ID` = 273;-- listvehiclerequestgaclose.php (dev 273) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/my-request', `Icon` = NULL WHERE `ID` = 274;-- listvehiclerequest.php (dev 274) UPDATE `menu` SET `LinkLaravel` = '/general-affairs/view-all', `Icon` = NULL WHERE `ID` = 275; -- listvehiclerequestall.php (dev 275) UPDATE `menu` SET `LinkLaravel` = '/vehicle-types', `Icon` = '' WHERE `ID` = 276; -- listvehicletype.php (dev 276) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'FlaskConical' WHERE `ID` = 280; -- group 'Sample Order Import' (dev 280) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import', `Icon` = NULL WHERE `ID` = 281;-- createsampleorderimport.php (dev 281) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/review', `Icon` = NULL WHERE `ID` = 282;-- listsamplerequestimportreviewimport.php (dev 297 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/companies/change', `Icon` = 'Building' WHERE `ID` = 284; -- changecompany.php (dev 285 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/companies/others', `Icon` = 'Building' WHERE `ID` = 287; -- listcompanyothers.php (dev 300 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/documents/principal/download-all', `Icon` = '' WHERE `ID` = 288;-- listdocumentprincipaldownloadisview.php (dev 301 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/approval-pm', `Icon` = NULL WHERE `ID` = 289;-- listsamplerequestimportapprovalpm.php (dev 282 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/approval-mm', `Icon` = NULL WHERE `ID` = 290;-- listsamplerequestimportapprovalmm.php (dev 286 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/goods-receipt', `Icon` = NULL WHERE `ID` = 291;-- listsamplerequestimportgoodsreceipt.php (dev 288 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/view', `Icon` = NULL WHERE `ID` = 292;-- listsamplerequestimport.php (dev 287 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/all', `Icon` = NULL WHERE `ID` = 293;-- listsamplerequestimportall.php (dev 290 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/view-all-pm', `Icon` = NULL WHERE `ID` = 294;-- listsamplerequestimportpm.php (dev 298 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'BarChart' WHERE `ID` = 298; -- group 'Budget and Target' (dev 308 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/create', `Icon` = NULL WHERE `ID` = 299; -- createbudgetandtarget.php (dev 310 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/approval-pm', `Icon` = NULL WHERE `ID` = 300;-- listapprovalpmbudgetandtarget.php (dev 311 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/approval-sm', `Icon` = NULL WHERE `ID` = 301;-- listapprovalsmbudgetandtarget.php (dev 316 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets', `Icon` = NULL WHERE `ID` = 302; -- listbudgetandtarget.php (dev 312 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/all', `Icon` = NULL WHERE `ID` = 303; -- listbudgetandtargetall.php (dev 313 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/pm', `Icon` = NULL WHERE `ID` = 304; -- listbudgetandtargetpm.php (dev 317 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/sm', `Icon` = NULL WHERE `ID` = 305; -- listbudgetandtargetsm.php (dev 318 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-target-periodes', `Icon` = NULL WHERE `ID` = 307;-- listbudgetandtargetperiode.php (dev 315 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/visit-report-link-with', `Icon` = '' WHERE `ID` = 308; -- listvisitplanlinkwith.php (dev 319 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/cancel-pm', `Icon` = NULL WHERE `ID` = 309;-- listapprovalpmcancelbnt.php (dev 320 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/cancel-sm', `Icon` = NULL WHERE `ID` = 310;-- listapprovalsmcancelbnt.php (dev 321 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/approval-mm', `Icon` = NULL WHERE `ID` = 311;-- listapprovalmmbudgetandtarget.php (dev 322 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/cancel-mm', `Icon` = NULL WHERE `ID` = 312;-- listapprovalmmcancelbnt.php (dev 324 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/mm', `Icon` = NULL WHERE `ID` = 313; -- listbudgetandtargetmm.php (dev 323 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaints/create-others', `Icon` = NULL WHERE `ID` = 314; -- createcomplainothers.php (dev 325 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaints/all-readonly', `Icon` = NULL WHERE `ID` = 315; -- listcomplainallreadonly.php (dev 326 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/companies/cs', `Icon` = 'Building' WHERE `ID` = 331; -- listcompanyall.php?cs=1 (dev 342 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Plug' WHERE `ID` = 332; -- group 'Netsuite Integration' (dev 355 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/netsuite/stock-barang', `Icon` = NULL WHERE `ID` = 333; -- listnetsuitestockbarang.php (dev 360 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'MessageSquare' WHERE `ID` = 334; -- group 'Complain Handling' (dev 363 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/create-pm', `Icon` = NULL WHERE `ID` = 335;-- createcomplainitempm.php (dev 364 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/review/mm', `Icon` = NULL WHERE `ID` = 337;-- listcomplaintosupplierreviewmm.php (dev 366 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/review/purchasing', `Icon` = NULL WHERE `ID` = 338;-- listcomplaintosupplierreviewpurchasing.php (dev 367 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/review/finance', `Icon` = NULL WHERE `ID` = 339;-- listcomplaintosupplierreviewfinance.php (dev 368 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/review/accounting', `Icon` = NULL WHERE `ID` = 340;-- listcomplaintosupplierreviewaccounting.php (dev 369 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/review/logistic', `Icon` = NULL WHERE `ID` = 341;-- listcomplaintosupplierreviewlogistic.php (dev 370 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/approval-ceo', `Icon` = NULL WHERE `ID` = 342;-- listcomplaintosupplierapprovalceo.php (dev 372 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/complete/mm', `Icon` = NULL WHERE `ID` = 344;-- listcomplaintosuppliercompletemm.php (dev 374 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/complete/purchasing', `Icon` = NULL WHERE `ID` = 345;-- listcomplaintosuppliercompletepurchasing.php (dev 375 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/complete/finance', `Icon` = NULL WHERE `ID` = 346;-- listcomplaintosuppliercompletefinance.php (dev 376 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/complete/accounting', `Icon` = NULL WHERE `ID` = 347;-- listcomplaintosuppliercompleteaccounting.php (dev 377 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/complete/logistic', `Icon` = NULL WHERE `ID` = 348;-- listcomplaintosuppliercompletelogistic.php (dev 378 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/close', `Icon` = NULL WHERE `ID` = 349; -- listcomplaintosupplierclose.php (dev 379 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/view', `Icon` = NULL WHERE `ID` = 350; -- listcomplaintosupplier.php (dev 371 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/view-all', `Icon` = NULL WHERE `ID` = 351;-- listcomplaintosupplierall.php (dev 380 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects/create', `Icon` = NULL WHERE `ID` = 354; -- createcompanyproject.php (dev 382 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects', `Icon` = NULL WHERE `ID` = 355; -- listproject.php (dev 383 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaints/all-report', `Icon` = NULL WHERE `ID` = 365; -- listcomplainallreportreadonly.php (dev 385 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/create', `Icon` = '' WHERE `ID` = 373; -- createcompanyrebate.php (dev 436 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/create-others', `Icon` = '' WHERE `ID` = 374;-- createcompanyrebatesalesadmin.php (dev 412 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/approval-sm', `Icon` = '' WHERE `ID` = 375; -- listcompanyrebateapprovalsm.php (dev 344 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/approval-ceo', `Icon` = '' WHERE `ID` = 376;-- listcompanyrebateapprovalceo.php (dev 345 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/view-request', `Icon` = '' WHERE `ID` = 377;-- listcompanyrebate.php (dev 346 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/view-request-sm', `Icon` = '' WHERE `ID` = 378;-- listcompanyrebatesm.php (dev 354 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/view-all', `Icon` = '' WHERE `ID` = 379; -- listcompanyrebateall.php (dev 347 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/cancel-approval-sm', `Icon` = '' WHERE `ID` = 380;-- listcompanyrebatecancelapprovalsm.php (dev 415 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/cancel-approval-ceo', `Icon` = '' WHERE `ID` = 381;-- listcompanyrebatecancelapprovalceo.php (dev 416 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/generate', `Icon` = '' WHERE `ID` = 383;-- companyrebatewitharhistory.php (dev 404 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/approval-finance', `Icon` = '' WHERE `ID` = 384;-- listinvoicecompanyrebateapprovalfinance.php (dev 405 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/approval-sm', `Icon` = '' WHERE `ID` = 385;-- listinvoicecompanyrebateapprovalsm.php (dev 406 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/approval-ceo', `Icon` = '' WHERE `ID` = 386;-- listinvoicecompanyrebateapprovalceo.php (dev 407 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/bill', `Icon` = '' WHERE `ID` = 387;-- listinvoicecompanyrebatebill.php (dev 408 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/view-request', `Icon` = '' WHERE `ID` = 388;-- listinvoicecompanyrebate.php (dev 409 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/view-creator', `Icon` = '' WHERE `ID` = 389;-- listinvoicecompanyrebatecreator.php (dev 413 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/view-sm', `Icon` = '' WHERE `ID` = 390;-- listinvoicecompanyrebatesm.php (dev 414 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/view-all', `Icon` = '' WHERE `ID` = 391;-- listinvoicecompanyrebateall.php (dev 410 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/budget-and-targets/head-dept', `Icon` = NULL WHERE `ID` = 392;-- listbudgetandtargetheaddept.php (dev 421 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaints/head-dept', `Icon` = NULL WHERE `ID` = 393; -- listcomplainheaddept.php (dev 422 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-head', `Icon` = 'List' WHERE `ID` = 394; -- listheaddeptsamplerequest.php (dev 424 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-details-head-dept', `Icon` = 'List' WHERE `ID` = 395;-- listsampledetailsheaddept.php (dev 423 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-details-head-dept', `Icon` = 'List' WHERE `ID` = 396;-- listlwrdetailsheaddept.php (dev 426 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/calendar/head', `Icon` = '' WHERE `ID` = 397; -- listvisitplancalendarheaddept.php (dev 428 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-details-head-dept', `Icon` = 'ListMenu' WHERE `ID` = 398;-- listquotationdetailsheaddept.php (dev 425 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sales-rebates', `Icon` = '' WHERE `ID` = 399; -- salesrebatewitharhistory.php (dev 463 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/generate-company-rebates/view-all-readonly', `Icon` = '' WHERE `ID` = 400;-- listinvoicecompanyrebateallreadonly.php (dev 430 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/view-head', `Icon` = '' WHERE `ID` = 401; -- listvisitplanreportallheaddept.php (dev 429 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/companies/head-dept', `Icon` = 'Building' WHERE `ID` = 402; -- listcompanyheaddept.php (dev 431 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/quotations/view-head', `Icon` = 'Eye' WHERE `ID` = 403; -- listquotationheaddept.php (dev 468 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-head-dept', `Icon` = 'Users' WHERE `ID` = 404; -- listlwrheaddept.php (dev 433 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/create-sm', `Icon` = '' WHERE `ID` = 405; -- createcompanyrebatesm.php (dev 343 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-rebates/view-all-readonly', `Icon` = '' WHERE `ID` = 406;-- listcompanyrebateallreadonly.php (dev 420 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/create-logistic', `Icon` = NULL WHERE `ID` = 408;-- createcomplainitemlogistic.php (dev 440 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-all-readonly', `Icon` = 'List' WHERE `ID` = 409;-- listallsamplerequestviewall.php (dev 444 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/netsuite/stock-barang-logistik', `Icon` = NULL WHERE `ID` = 410;-- listnetsuitestockbaranglogistic.php (dev 442 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/netsuite/print-sj', `Icon` = NULL WHERE `ID` = 411; -- listnetsuiteprintsj.php (dev 447 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/review/pm', `Icon` = NULL WHERE `ID` = 412;-- listcomplaintosupplierreviewpm.php (dev 443 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/complete/pm', `Icon` = NULL WHERE `ID` = 413;-- listcomplaintosuppliercompletepm.php (dev 445 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/read-only', `Icon` = NULL WHERE `ID` = 414;-- listcomplaintosupplierallreadonly.php (dev 386 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/complaint-handling/view-pm', `Icon` = NULL WHERE `ID` = 415;-- listcomplaintosupplierpm.php (dev 446 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-pengerjaan-lab', `Icon` = 'FlaskConical' WHERE `ID` = 417;-- listlwrlabworkgd.php (dev 454 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/lwrs/view-all-lab-div', `Icon` = 'LayoutList' WHERE `ID` = 418;-- listlwrlabgd.php (dev 452 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects/approval-pm', `Icon` = NULL WHERE `ID` = 420;-- listprojectapprovalpm.php (dev 459 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects/approval-sm', `Icon` = NULL WHERE `ID` = 421;-- listprojectapprovalsm.php (dev 460 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects/all', `Icon` = NULL WHERE `ID` = 422; -- listprojectall.php (dev 456 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects/pm', `Icon` = NULL WHERE `ID` = 423; -- listprojectpm.php (dev 419 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects/sm', `Icon` = NULL WHERE `ID` = 424; -- listprojectsm.php (dev 457 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-projects/mm', `Icon` = NULL WHERE `ID` = 425; -- listprojectmm.php (dev 458 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '', `Icon` = 'Tag' WHERE `ID` = 426; -- group 'Print Label CC Product' (dev 465 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/print-label/relabel', `Icon` = NULL WHERE `ID` = 427; -- printlabelnsproduct.php (dev 466 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/print-label/history', `Icon` = NULL WHERE `ID` = 428; -- printlabelnsproducthistory.php (dev 461 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/print-label/barcode', `Icon` = NULL WHERE `ID` = 429; -- printbarcodeitemns.php (dev 467 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/company-categories', `Icon` = NULL WHERE `ID` = 432; -- listcompanycategory.php (dev 480 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/lwrs/create-for-others-pm', `Icon` = NULL WHERE `ID` = 433; -- createlwr.php (dev 500 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/visit-plans/create-for-others', `Icon` = '' WHERE `ID` = 434;-- createvisitplananothersales.php (dev 100 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/view-sm', `Icon` = 'List' WHERE `ID` = 435; -- listsmsamplerequest.php (dev 402 <-- different ID) UPDATE `menu` SET `LinkLaravel` = '/sample-orders/request-import/view-all', `Icon` = NULL WHERE `ID` = 436;-- listsamplerequestimportallreadonly.php (dev 449 <-- different ID) COMMIT; -- ===================================================================== -- NOT WRITTEN: dev rows with no production counterpart -- ===================================================================== -- These menus exist only in the development database, so there is no -- production row to update. They would need INSERTs (production -- AUTO_INCREMENT is at 438) with a ParentID resolved per row -- left out -- deliberately, as agreed. -- -- LIVE in dev (IsDeleted=0) -- 11 rows. These are the ones worth a look: -- -- dev ID Name LinkLaravel Icon -- 280 Sample Ordder Import (none) FlaskConical -- 464 Export Company ex-Sales /sales-rebates/export-company-ex-sales (empty) -- 469 View Head - Company Project /company-projects/head NULL -- 1301 Dashboard /dashboard Grid -- 1692 Change Status /quotations/change-status (empty) -- 1693 Cancel Quotation /quotations/cancel (empty) -- 1723 Change Status LWR /lwrs/change-status RefreshCw -- 1724 Cancel LWR /lwrs/cancel Ban -- 3453 Change Status - Credit Ceiling /credit-ceilings/change-status (empty) -- 5923 Principals /principals (empty) -- 10191 Create Company /companies/create Plus -- -- SOFT-DELETED in dev (IsDeleted=1) -- 58 rows, listed for completeness: -- -- 1297 Quotations /quotations FileText -- 1298 Approval PM /quotations/approval-pm ClipboardCheck -- 1556 Create Sample Order /sample-orders/create Plus -- 1577 Approval SM /quotations/approval-sm ClipboardCheck -- 1578 View Head /quotations/view-head Eye -- 1579 Process to Order /quotations/process-to-order Package -- 1580 Good Receive /quotations/good-receive ClipboardCheck -- 1665 Surat Jalan - Sample Order /sample-orders/surat-jalan List -- 1689 Feedback /quotations/feedback MessageSquare -- 1690 View All /quotations/view-all Grid -- 1691 View Details /quotations/view-details ListMenu -- 1739 View Details PM /quotations/view-details-pm ListMenu -- 1740 View Details Head Dept /quotations/view-details-head-dept ListMenu -- 1741 View Details SM /quotations/view-details-sm ListMenu -- 1742 View Details CS /quotations/view-details-cs ListMenu -- 1743 View Details MM /quotations/view-details-mm ListMenu -- 1744 View All /lwrs/view-all List -- 1745 View Head Dept /lwrs/view-head-dept Users -- 1746 View Pengerjaan Lab /lwrs/view-pengerjaan-lab FlaskConical -- 1747 View All (Lab) /lwrs/view-all-lab Microscope -- 1748 View All Lab (Div) /lwrs/view-all-lab-div LayoutList -- 1770 View Details /lwrs/view-details List -- 1771 View Details PM /lwrs/view-details-pm List -- 1772 View Details Head Dept /lwrs/view-details-head-dept List -- 1773 View Details SM /lwrs/view-details-sm List -- 1774 View Details MM /lwrs/view-details-mm List -- 1775 Approval SM /lwrs/approval-sm ClipboardCheck -- 1776 Pengerjaan Lab /lwrs/pengerjaan-lab FlaskConical -- 1777 Feedback /lwrs/feedback MessageSquare -- 2255 View Company /companies Building -- 2256 View Company Others /companies/others Building -- 2257 View Company All /companies/all Building -- 3028 View Details /sample-orders/view-details List -- 3029 View Details PM /sample-orders/view-details-pm List -- 3030 View Details Head Dept /sample-orders/view-details-head-dept List -- 3031 View Details SM /sample-orders/view-details-sm List -- 3032 View Details MM /sample-orders/view-details-mm List -- 3359 View Sample DO /sample-orders/view-surat-jalan List -- 3434 View Company Head Dept /companies/head-dept Building -- 3435 View Company SM /companies/sm Building -- 3436 View Company CS /companies/cs Building -- 3438 View Market Survey /market-surveys (empty) -- 3439 View Market Survey PM /market-surveys/pm (empty) -- 3440 View Market Survey SM /market-surveys/sm (empty) -- 3441 Create Request Company Rebate /company-rebates/create (empty) -- 3442 Create Request Company Rebate - Own /company-rebates/create-own (empty) -- 3443 Create Request Company Rebate for Others /company-rebates/create-others (empty) -- 3444 Create Request Company Rebate SM /company-rebates/create-sm (empty) -- 3484 Create Sample Order Sales Admin /sample-orders/create-sales-admin (empty) -- 3494 Visit Plans Create /visit-plans/create (empty) -- 3512 Visit Plans Create For Others /visit-plans/create-for-others (empty) -- 3571 a /dashboard Grid -- 3970 Visit Plans Calendar MM /visit-plans/calendar/mm (empty) -- 3971 Visit Plans Calendar PM /visit-plans/calendar/pm (empty) -- 5913 Principal Analysis /principal-analysis List -- 5914 All Principal Analysis /principal-analysis/all List -- 10190 Create Quotation /quotations/create Plus -- 10203 Export Company ex-Sales - Sales Rebate /sales-rebates/export-company-ex-sales (empty) -- ===================================================================== -- VERIFY (run after COMMIT) -- ===================================================================== -- Expect exactly 253 rows with a non-empty LinkLaravel or Icon: -- -- SELECT COUNT(*) FROM `menu` -- WHERE (`LinkLaravel` IS NOT NULL AND `LinkLaravel` <> '') -- OR (`Icon` IS NOT NULL AND `Icon` <> ''); -- -- Spot-check that the routes landed on the right pages: -- -- SELECT `ID`, `Name`, `Link`, `LinkLaravel`, `Icon` FROM `menu` -- WHERE `LinkLaravel` <> '' ORDER BY `ID`;