| | |
|---|
| | | import com.mes.uppattenusage.mapper.UpPattenUsageMapper; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | |
|---|
| | | List<Map> list = upPattenUsageMapper.selectJoinList( |
|---|
| | | Map.class, new MPJQueryWrapper<UpPattenUsage>().selectAll(UpPattenUsage.class) |
|---|
| | | .select("escd.glass_id", "escd.flow_card_id", "escd.width", "escd.height") |
|---|
| | | .select("gi.x_coordinate","gi.y_coordinate","gi.tempering_feed_sequence") |
|---|
| | | .leftJoin("glass_info gi on t.layout_sequence=gi.pattern_sequence and t.engineering_id=gi.engineer_id") |
|---|
| | | .leftJoin("edg_storage_cage_details escd on gi.id=escd.glass_id") |
|---|
| | | .eq("t.state", 1) |
|---|
