商城后臺供應商SQL · 遠豐API接口

INSERT INTO `yf_admin_menu` (`menu_id`, `menu_parent_id`, `menu_name`, `menu_icon`, `rights_id`, `menu_url_ctl`, `menu_url_met`, `menu_url_parem`, `menu_url_note`, `menu_order`, `menu_time`) VALUES (13022, 13100, '供應商管理', '', 17000, 'Supplier_Manage', 'indexs', '', '', 0, '0000-00-00 00:00:00'), (13024, 13100, '供應商入駐', '', 17100, 'Supplier_Help', 'help', '', '', 0, '0000-00-00 00:00:00'), (13100, 0, '供應商', 'icon-gongyingshang', 0, '', '', '', '', 1, '0000-00-00 00:00:00'); ### 更新權限，帶供應商 UPDATE `yf_admin_rights_group` SET `rights_group_rights_ids`='[3000,3110,3140,3130,3120,3170,3160,3190,3180,10400,3200,3230,3210,3220,3260,3270,3240,3250,3310,3300,3280,3290,10000,10900,3330,3320,3340,3350,3360,3370,3380,3390,3400,3371,11000,11200,3440,3430,3420,3410,3710,3700,14300,16020,16030,14400,16000,16010,3730,3820,3750,3810,3770,3780,3790,3720,3760,3830,3840,3850,3860,3740,3800,3870,3880,3910,3900,3940,3930,3920,3890,3970,3960,3950,3980,14500,14600,4040,4030,4020,4010,4000,3990,4060,4070,4050,4080,4090,4100,4110,4130,4120,14700,14800,16040,4160,4220,4210,4200,4190,4180,4170,4150,4140,4270,4260,4280,4290,4300,4310,4320,4330,4240,4230,4250,14900,13500,4410,4400,4390,4420,4380,4370,4360,4350,4340,11100,11600,8910,8900,8890,8880,5020,5000,5010,5030,9400,9500,5050,5040,5060,5070,5090,5130,5120,5080,5110,5100,5150,5140,9600,9700,5160,5170,5230,5220,5210,5200,5190,5180,9800,9900,12300,5240,5250,5300,5270,5290,5280,5260,15600,12400,5340,5310,5320,5330,5350,5390,5380,5360,5370,12600,12700,5400,8110,8120,8100,8090,8130,8140,8150,8160,8170,8180,8080,8070,8060,8000,8010,8020,8030,8040,8050,11700,11800,8230,8220,8210,8200,8190,8270,8260,8240,8250,11900,12000,8310,8300,8280,8290,12100,12200,8350,8340,8320,8330,8500,8510,13600,13700,8520,8530,8550,8540,13800,13900,8590,8600,8610,8620,8630,8580,8570,8560,8660,8650,8640,8670,14000,14100,8690,8700,8710,8680,8840,8790,8800,8810,8820,8830,8870,8860,8850,8780,8770,8760,8750,8740,8730,8720,14200,9000,9100,9200,9300,10100,10200,3010,3020,3040,3060,3070,3080,3090,3030,10300,10500,10600,10700,10800,11300,11400,11500,12500,12800,12900,15500,13000,13100,13200,13300,13400,15400,15000,15100,15200,15300]' WHERE `rights_group_id`=1; ### 更新權限，不帶供應商 UPDATE `yf_admin_rights_group` SET `rights_group_rights_ids`='[3320,3360,3370,3410,16030,14400,3850,3860,8110,8120,8100,8090,8130,8140,8150,8160,8170,8180,8080,8070,8060,8000,8010,8020,8030,8040,8050,11700,8240,8500,8510,13600,13700,8520,8530,8550,8540,13800,13900,8590,8600,8610,8620,8630,8580,8570,8560,8660,8650,8640,8670,14000,9200,10100,10800,12800,12900]' WHERE `rights_group_id`=2;