| | |
| | | <!-- 分页查询所有信息 --> |
| | | <select id="queryViewStayTimeList" parameterType="com.zy.asrs.entity.ViewStayTimeBean" resultType="com.zy.asrs.entity.ViewStayTimeBean"> |
| | | select |
| | | * |
| | | a.*, |
| | | loc_no AS locNo, |
| | | supp_code AS suppCode, |
| | | appe_time AS appeTime, |
| | | modi_time AS modiTime, |
| | | stay_time AS stayTime, |
| | | box_type1 AS boxType1 |
| | | from ( |
| | | select |
| | | ROW_NUMBER() over (order by stay_time desc) as row |
| | |
| | | var pageCurr; |
| | | function getCol() { |
| | | var cols = [ |
| | | {field: 'appeTime$', title: '入库时间', align: 'center', width: 200} |
| | | ,{field: 'stay_time', align: 'center',title: '滞留天数'} |
| | | ,{field: 'loc_no', align: 'center',title: '库位号'} |
| | | {field: 'appeTime', title: '入库时间', align: 'center', width: 200} |
| | | ,{field: 'stayTime', align: 'center',title: '滞留天数'} |
| | | ,{field: 'locNo', align: 'center',title: '库位号'} |
| | | ]; |
| | | cols.push.apply(cols, detlCols); |
| | | return cols; |