-- =====================================================================
-- 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 = <dev 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.
-- =====================================================================


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`;
