| | |
| | | @TableField("take_none") |
| | | private String takeNone; |
| | | |
| | | /** |
| | | * 呼叫agv 1.准备呼叫,2.已呼叫 |
| | | */ |
| | | @ApiModelProperty(value = "呼叫agv 1.准备呼叫,2.已呼叫") |
| | | @TableField("call_agv") |
| | | private Integer callAgv; |
| | | |
| | | public WrkMast() { |
| | | } |
| | | |
| | |
| | | return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.ymd); |
| | | } |
| | | |
| | | public String getCallAgv$() { |
| | | switch (this.callAgv) { |
| | | case 0: return "未呼叫"; |
| | | case 1: return "准备呼叫"; |
| | | case 2: return "已呼叫"; |
| | | default: |
| | | } |
| | | return ""; |
| | | } |
| | | |
| | | public String getWrkSts$() { |
| | | BasWrkStatusService service = SpringUtils.getBean(BasWrkStatusService.class); |
| | | BasWrkStatus basWrkStatus = service.selectById(this.wrkSts); |
| | |
| | | @TableField("take_none") |
| | | private String takeNone; |
| | | |
| | | /** |
| | | * 呼叫agv 1.准备呼叫,2.已呼叫 |
| | | */ |
| | | @ApiModelProperty(value = "呼叫agv 1.准备呼叫,2.已呼叫") |
| | | @TableField("call_agv") |
| | | private Integer callAgv; |
| | | |
| | | public WrkMastLog() { |
| | | } |
| | | |
| | | public String getCallAgv$() { |
| | | switch (this.callAgv) { |
| | | case 0: return "未呼叫"; |
| | | case 1: return "准备呼叫"; |
| | | case 2: return "已呼叫"; |
| | | default: |
| | | } |
| | | return ""; |
| | | } |
| | | |
| | | public String getWrkNo$() { |
| | | WrkMastService service = SpringUtils.getBean(WrkMastService.class); |
| | | WrkMast wrkMast = service.selectById(this.wrkNo); |
| | |
| | | <result column="full_plt" property="fullPlt" /> |
| | | <result column="pre_have" property="preHave" /> |
| | | <result column="take_none" property="takeNone" /> |
| | | <result column="call_agv" property="callAgv" /> |
| | | </resultMap> |
| | | <sql id="queryWhere"> |
| | | <where> |
| | |
| | | <result column="full_plt" property="fullPlt" /> |
| | | <result column="pre_have" property="preHave" /> |
| | | <result column="take_none" property="takeNone" /> |
| | | <result column="call_agv" property="callAgv" /> |
| | | </resultMap> |
| | | |
| | | <select id="selectToBeCompleteData" resultMap="BaseResultMap"> |
| | |
| | | select * from asr_wrk_mast |
| | | where wrk_sts=5 |
| | | or (wrk_sts=15 and ove_mk='Y' and wrk_no not in (select wrk_no from asr_bas_devp)) |
| | | or (wrk_sts=15 and dateadd(mi,3,crn_end_time) <= getdate() and wrk_no not in (select wrk_no from asr_bas_devp)) |
| | | or (wrk_sts=15 and dateadd(mi,1,crn_end_time) <= getdate() and wrk_no not in (select wrk_no from asr_bas_devp)) |
| | | or (wrk_sts=15 and crn_end_time is null and wrk_no not in (select wrk_no from asr_bas_devp)) |
| | | order by io_time,wrk_no asc |
| | | </select> |
| | |
| | | ,{field: 'takeNone', align: 'center',title: '空操作', hide: true} |
| | | ,{field: 'modiUser$', align: 'center',title: '修改人员', hide:true} |
| | | ,{field: 'modiTime$', align: 'center',title: '修改时间', hide:true, width: 160} |
| | | ,{field: 'callAgv$', align: 'center',title: '呼叫agv', hide:true} |
| | | ,{fixed: 'right', title:'操作', align: 'center', toolbar: '#operate', width:300} |
| | | ]], |
| | | request: { |
| | |
| | | // html += ">"; |
| | | // return html; |
| | | // }} |
| | | |
| | | ,{field: 'callAgv$', align: 'center',title: '呼叫agv', hide:true} |
| | | ,{fixed: 'right', title:'操作', align: 'center', toolbar: '#operate', width: 80} |
| | | ]], |
| | | request: { |