| | |
|---|
| | | opd.glass_id as glassId, |
|---|
| | | opd.project_no as engineerId, |
|---|
| | | opd.process_id as flowCardId, |
|---|
| | | opd.order_sort as orderNumber, |
|---|
| | | od.order_id as orderNumber, |
|---|
| | | opd.order_sort as productSortNumber, |
|---|
| | | IF(LOCATE('中空', ogd.process ) > 0, JSON_UNQUOTE(JSON_EXTRACT(pd.separation, "$.lowE")), 0) as hollowCombineDirection, |
|---|
| | | opd.o_width as width, |
|---|
| | | opd.o_height as height, |
|---|
| | | op.glass_thickness as thickness, |
|---|
| | |
|---|
| | | and ogd.technology_number = fc.technology_number |
|---|
| | | left join pp.optimize_heat_detail ohd on ohd.layout_id = opd.heat_layout_id |
|---|
| | | and ohd.sort = opd.heat_layout_sort and ohd.project_no=opd.project_no |
|---|
| | | left join sd.product_detail pd on od.product_id=pd.prod_id and opd.layer=pd.glass_sort |
|---|
| | | where |
|---|
| | | opd.project_no = #{projectNo} |
|---|
| | | </select> |
|---|
