| | |
| | | |
| | | import com.aps.common.core.web.controller.BaseController; |
| | | import com.aps.common.core.web.page.TableDataInfo; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsPlateOrderPlanManager; |
| | | import com.aps.core.domain.ApsPlateStandardRequire; |
| | | import com.aps.core.service.IApsPlateOrderPlanManagerService; |
| | |
| | | @Serial |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** 工单ID */ |
| | | @Excel(name = "工单ID") |
| | | private Long id; |
| | | |
| | | /** 需求ID */ |
| | | @Excel(name = "需求ID") |
| | | private Long requireId; |
| | |
| | | <mapper namespace="com.aps.core.mapper.ApsPlateOrderPlanManagerMapper"> |
| | | |
| | | <resultMap type="ApsPlateOrderPlanManager" id="ApsPlateOrderPlanManagerResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="require_id" column="requireId" /> |
| | | <result property="requireTrackId" column="require_track_id" /> |
| | | <result property="workOrderNo" column="doc_no" /> |
| | |
| | | plan.plan_start_day, |
| | | plan.plan_end_day, |
| | | plan.unmatched_quantity, |
| | | plan.has_risk |
| | | plan.has_risk, |
| | | plan.id |
| | | from aps_plate_standard_require_bom_order_detail detail |
| | | left join aps_plate_plan plan on detail.doc_no = plan.document_number |
| | | <where> |