| | |
|---|
| | | .select("b.process_id,t.glass_type,b.o_width,b.o_height,t.glass_thickness,b.order_sort,b.p_width,b.p_height,b.layer, b.total_layer, b.stock_id,b.heat_layout_id,b.heat_layout_sort,c.x_axis,c.y_axis,b.project_no,b.glass_id,c.rotate_angle,d.merge") |
|---|
| | | .leftJoin("optimize_detail b on t.project_no=b.project_no") |
|---|
| | | .leftJoin("optimize_heat_detail c on c.project_no=t.project_no and b.heat_layout_id=c.layout_id and b.heat_layout_sort=c.sort") |
|---|
| | | .leftJoin("flow_card d on d.process_id=b.process_id and d.layers_number=b.layer") |
|---|
| | | .leftJoin("flow_card d on d.process_id=b.process_id and d.technology_number=b.layer and d.order_number=b.order_sort ") |
|---|
| | | //.eq("t.state",100) |
|---|
| | | .eq("t.project_no", engineeringId)); |
|---|
| | | } |
|---|
