首页 > 代码库 > lll

lll

SELECT reg.id,reg.name,flo.id,flo.name
FROM gt_resource.res_region AS reg LEFT JOIN gt_resource.res_floor AS flo ON reg.parent_id = flo.id
WHERE flo.id = 2;

UPDATE gt_lighting.res_lights
SET purpose = 5;

UPDATE gt_lighting.res_lights
SET purpose = 1
WHERE id IN (111,113,108,107,93,96,100,90,89,88,91,92,75,76,77,78,79,80,81,82,74,73,130,127,128,117,134,162,148,151,155,141,142,147,154,153,144,158,156,157,120,163,170,172,178,169,137,136,182,119,122,123,207,206,198,201,202,51,47,43,21,29,30,39,44,45,52,53,54,55,56,46,48,49,50,23);

UPDATE gt_lighting.res_lights
SET purpose = 2
WHERE id IN (43,61,34,6,7,8,9,10,11,12,13,15,16,17,18,199,203,204,114,101,94,102,72,67,64,116,118,149,150,143,152,146,145,121,187,177,171,168,174,180,181,184);

UPDATE gt_lighting.res_lights
SET purpose = 3
WHERE id IN (106,112,109,97,98,99,95,70,66,65,71,63,132,131,133,126,138,176,173,179,205,25,26,31,33,60,19,28);

UPDATE gt_lighting.res_lights
SET purpose = 4
WHERE id IN (41,57,24,27,37,59,14,200,140,167);

SELECT lig.id,lig.name,lig.fid,flo.name,lig.rid,reg.name,lig.purpose,lig.icon
FROM gt_lighting.res_lights AS lig LEFT JOIN gt_resource.res_floor AS flo ON lig.fid = flo.id LEFT JOIN gt_resource.res_region AS reg ON lig.rid = reg.id
ORDER BY lig.id;

UPDATE gt_lighting.res_lights
SET icon = e620
WHERE `name` LIKE %花灯 OR `name` LIKE %柜灯;


UPDATE gt_lighting.res_lights
SET icon = e624
WHERE `name` LIKE %筒灯;


UPDATE gt_lighting.res_lights
SET icon = e64b
WHERE `name` LIKE %射灯;

UPDATE gt_lighting.res_lights
SET icon = e64c
WHERE `name` LIKE %灯带 OR `name` LIKE %壁灯;


UPDATE gt_lighting.res_lights
SET icon = e621
WHERE `name` LIKE %窗帘;

UPDATE gt_lighting.res_lights
SET icon = e643
WHERE `name` LIKE %夜灯;


UPDATE gt_lighting.res_lights
SET icon = e696
WHERE `name` LIKE %LOGO%;

 

lll