cucu_YOS/src/custom/restcontroller/webmanage/sale/item/SQL/货品档案列表.sql

SELECT t1.itemid,
       t1.itemno,
       t1.itemname,
       t1.model,
       t1.spec,
       t1.marketprice,
       t2.unitname,
       t1.unitid,
       t1.createdate,
       t1.isonsale,
       t1.status,
       t1.orderaddqty,
       t1.orderminqty,
       t1.remarks,
       t1.barcode,
       t1.skucontrol,
       t1.batchcontrol,
       t1.grossweight,
       t1.weight,
       t1.height,
       t1.width,
       t1.length,
       t1.delivery,
       t1.istool,
       t1.ismodule,
       t1.packageqty,
       t1.iswoodproducts,
       t1.financeclasstype,
       t1.color,
       t1.cheek,
       t1.delistingstatus,
       t6.auxunitid,
       t6.	unitgroupname,
       t7.unitname axunitname,
       t8.caliber,
       t8.pressure,
       t8.material,
       t8.butterflyplatedrive,
       t8.connection,
       t8.valveplatematerial,
       t8.bodymaterial,
       t8.actuatortype,
       t8.actuatorbrand,
       t8.isbutterfly,
       t8.erpitemno,
       t8.erpitemname,
       t8.specalnote,
       t8.prodline,
       t8.device
FROM plm_item t1
         LEFT JOIN plm_unit t2 ON t2.unitid = t1.unitid AND t2.siteid = t1.siteid
         LEFT JOIN plm_unitgroup t6 ON t6.unitgroupid = t1.unitgroupid
         LEFT JOIN plm_unit t7 ON t7.unitid = t6.unitid AND t7.siteid = t6.siteid
         LEFT JOIN plm_itemextend t8 ON t8.itemid= t1.itemid AND t8.siteid = t1.siteid
WHERE t1.siteid = $siteid$
  and $where$