| | |
| | | <label class="layui-form-label">ä¸å¡ç¶æ</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HStatus" lay-filter="HStatus" style="width:190px;"> |
| | | <option value="-1" selected="selected">å
¨é¨</option> |
| | | <option value="-1" selected>å
¨é¨</option> |
| | | <option value="1">æªåé
</option> |
| | | <option value="2">å·²åé
</option> |
| | | <option value="3">å·²åå¸</option> |
| | |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> |
| | | <div class="layui-colla-content"> |
| | | <div class="layui-inline"> |
| | | <!--<div class="layui-inline"> |
| | | <div class="layui-inline"> |
| | | <span>å
¶ä»æ¡ä»¶></span> |
| | | </div> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ®å·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="WorkCenter" id="WorkCenter"> |
| | | <input type="text" class="layui-input" name="HBillno" id="HBillno" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä¸å¡å</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HEmpName" id="HEmpName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ååç¶æ</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HXTStatus" lay-filter="HXTStatus" style="width:190px;"> |
| | | <option value="" selected>å
¨é¨</option> |
| | | <option value="æªç¡®è®¤">æªç¡®è®¤</option> |
| | | <option value="已确认">已确认</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åé¦ç¶æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æä»£ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æåç§°</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HMaterName" id="HMaterName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back"><i class="layui-icon layui-icon-close-fill"></i>æ¤é</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-yxj"><i class="layui-icon layui-icon-tips"></i>ä¼å
级</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>驳å</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详æ
</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>çæéè´§å</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>çæéè´§å</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | |
| | | </div> |
| | |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | var columns = [ |
| | | { type: 'checkbox', fixed: 'left', totalRowText: 'å计' } |
| | | ,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true } |
| | | , { field: 'hmainid', title: 'hmainid', sort: true, hide: true } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', width: 150 } |
| | | , { field: 'HBillType', title: 'HBillType', hide: true } |
| | | , { field: 'HSupID', title: 'HSupID', hide: true } |
| | | , { field: 'ä¸å¡ç¶æ', title: 'ä¸å¡ç¶æ', width: 100 } |
| | | , { field: 'ä¾åºåååç¶æ', title: 'ä¾åºåååç¶æ', width: 135 } |
| | | , { field: 'ä¾åºåååç¶æ', title: 'ä¾åºåååç¶æ', width: 135 }/*ç©æä»£ç ï¼ç©æåç§°ï¼è§æ ¼åå·ï¼æ¹å·ï¼æ°éï¼åä½ï¼æºååå·*/ |
| | | , { field: 'åé¦ç¶æ', title: 'ä¾åºååé¦ç¶æ', width: 135 } |
| | | , { field: 'ä¾åºå代ç ', title: 'ä¾åºå代ç ', width: 120} |
| | | , { field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 100 } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 100 } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 100 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 100 } |
| | | , { field: 'æ¹å·', title: 'æ¹å·', width: 100 } |
| | | , { field: 'æ°é', title: 'æ°é', width: 100 } |
| | | , { field: 'HUnitID', title: 'HUnitID', hide: true } |
| | | , { field: '计éåä½ä»£ç ', title: '计éåä½ä»£ç ', width: 120 } |
| | | , { field: '计éåä½', title: '计éåä½', width: 100 } |
| | | , { field: 'æºååå·', title: 'æºååå·', width: 100 } |
| | | , { field: 'ä¾åºå代ç ', title: 'ä¾åºå代ç ', width: 120 } |
| | | , { field: 'ä¾åºå', title: 'ä¾åºå', width: 100 } |
| | | , { field: 'ä¸å¡å代ç ', title: 'ä¸å¡å代ç ', width: 100 } |
| | | , { field: 'ä¸å¡å', title: 'ä¸å¡å', width: 100 } |
| | | , { field: 'HPriority', title: 'HPriority', width: 100, hide: true } |
| | | , { field: 'ä¼å
级', title: 'ä¼å
级', width: 100 } |
| | | , { field: '交货å°ç¹', title: '交货å°ç¹', width: 100} |
| | | , { field: '交货å°ç¹', title: '交货å°ç¹', width: 100 } |
| | | , { field: 'HPSStyleID', title: 'HPSStyleID', hide: true } |
| | | , { field: 'éè´æ¹å¼ä»£ç ', title: 'éè´æ¹å¼ä»£ç ', width: 120} |
| | | , { field: 'éè´æ¹å¼', title: 'éè´æ¹å¼', width: 100} |
| | | , { field: 'éè´æ¹å¼ä»£ç ', title: 'éè´æ¹å¼ä»£ç ', width: 120 } |
| | | , { field: 'éè´æ¹å¼', title: 'éè´æ¹å¼', width: 100 } |
| | | , { field: 'HSSID', title: 'HSSID', hide: true } |
| | | , { field: 'ç»ç®æ¹å¼ä»£ç ', title: 'ç»ç®æ¹å¼ä»£ç ', width: 120} |
| | | , { field: 'ç»ç®æ¹å¼', title: 'ç»ç®æ¹å¼', width: 100} |
| | | , { field: 'ç»ç®æ¹å¼ä»£ç ', title: 'ç»ç®æ¹å¼ä»£ç ', width: 120 } |
| | | , { field: 'ç»ç®æ¹å¼', title: 'ç»ç®æ¹å¼', width: 100 } |
| | | , { field: 'ç»ç®æ¥æ', title: 'ç»ç®æ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.ç»ç®æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'HCurID', title: 'HCurID', hide: true } |
| | | , { field: 'å¸å«ä»£ç ', title: 'å¸å«ä»£ç ', width: 100} |
| | | , { field: 'å¸å«', title: 'å¸å«', width: 100} |
| | | , { field: 'æ±ç', title: 'æ±ç', width: 100} |
| | | , { field: 'å¸å«ä»£ç ', title: 'å¸å«ä»£ç ', width: 100 } |
| | | , { field: 'å¸å«', title: 'å¸å«', width: 100 } |
| | | , { field: 'æ±ç', title: 'æ±ç', width: 100 } |
| | | , { field: 'HDeptID', title: 'HDeptID', hide: true } |
| | | , { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ', width: 100} |
| | | , { field: 'é¨é¨', title: 'é¨é¨', width: 100} |
| | | , { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ', width: 100 } |
| | | , { field: 'é¨é¨', title: 'é¨é¨', width: 100 } |
| | | , { field: 'HManagerID', title: 'HManagerID', hide: true } |
| | | , { field: '主管代ç ', title: '主管代ç ', width: 100} |
| | | , { field: '主管', title: '主管', width: 100} |
| | | , { field: '主管代ç ', title: '主管代ç ', width: 100 } |
| | | , { field: '主管', title: '主管', width: 100 } |
| | | , { field: 'HEmpID', title: 'HEmpID', hide: true } |
| | | , { field: 'æè¦', title: 'æè¦', width: 100} |
| | | , { field: 'è¡¨å¤´å¤æ³¨', title: 'è¡¨å¤´å¤æ³¨', width: 100} |
| | | , { field: 'æè¦', title: 'æè¦', width: 100 } |
| | | , { field: 'è¡¨å¤´å¤æ³¨', title: 'è¡¨å¤´å¤æ³¨', width: 100 } |
| | | , { field: 'hsubid', title: 'hsubid', hide: true } |
| | | , { field: 'HMaterID', title: 'HMaterID', hide: true } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 100} |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 100} |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 100} |
| | | , { field: 'æ¹å·', title: 'æ¹å·', width: 100} |
| | | , { field: 'HUnitID', title: 'HUnitID', hide: true } |
| | | , { field: '计éåä½ä»£ç ', title: '计éåä½ä»£ç ', width: 120} |
| | | , { field: '计éåä½', title: '计éåä½', width: 100} |
| | | , { field: 'æ°é', title: 'æ°é', width: 100} |
| | | , { field: 'åä»·', title: 'åä»·', width: 100} |
| | | , { field: 'éé¢', title: 'éé¢', width: 100} |
| | | , { field: 'ç¨ç', title: 'ç¨ç', width: 100} |
| | | , { field: 'ç¨é¢', title: 'ç¨é¢', width: 100} |
| | | , { field: 'ä»·ç¨å计', title: 'ä»·ç¨å计', width: 100} |
| | | , { field: 'åä»·', title: 'åä»·', width: 100 } |
| | | , { field: 'éé¢', title: 'éé¢', width: 100 } |
| | | , { field: 'ç¨ç', title: 'ç¨ç', width: 100 } |
| | | , { field: 'ç¨é¢', title: 'ç¨é¢', width: 100 } |
| | | , { field: 'ä»·ç¨å计', title: 'ä»·ç¨å计', width: 100 } |
| | | , { field: 'äº¤è´§æ¥æ', title: 'äº¤è´§æ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.äº¤è´§æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'æºååå·', title: 'æºååå·', width: 100} |
| | | , { field: '计åè·è¸ªå·', title: '计åè·è¸ªå·', width: 100} |
| | | , { field: '表ä½å¤æ³¨', title: '表ä½å¤æ³¨', width: 100} |
| | | , { field: 'å¶å人', title: 'å¶å人', width: 100} |
| | | , { field: '计åè·è¸ªå·', title: '计åè·è¸ªå·', width: 100 } |
| | | , { field: '表ä½å¤æ³¨', title: '表ä½å¤æ³¨', width: 100 } |
| | | , { field: 'å¶å人', title: 'å¶å人', width: 100 } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.å¶åæ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº', width: 100} |
| | | , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº', width: 100 } |
| | | , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.å®¡æ ¸æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº', width: 100} |
| | | , { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº', width: 100 } |
| | | , { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.ä¿®æ¹æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'å
³é人', title: 'å
³é人', width: 100} |
| | | , { field: 'å
³é人', title: 'å
³é人', width: 100 } |
| | | , { field: 'å
³éæ¥æ', title: 'å
³éæ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.å
³éæ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'ä½åºäºº', title: 'ä½åºäºº', width: 100} |
| | | , { field: 'ä½åºäºº', title: 'ä½åºäºº', width: 100 } |
| | | , { field: 'ä½åºæ¥æ', title: 'ä½åºæ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.ä½åºæ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | |
| | | ]; |
| | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | | var wait = layer.load();//é®ç½© |
| | | var HBeginDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'"; |
| | | } |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HEndDate + "'"; |
| | | if (sWhere == "") |
| | | { |
| | | var HBeginDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'"; |
| | | } |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HEndDate + "'"; |
| | | } |
| | | sWhere += " and ä¸å¡ç¶æ = 'æªåé
' and ä¾åºåååç¶æ ='æªç¡®è®¤' "; |
| | | } |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/WW_EntrustOrderBill/list', |
| | |
| | | |
| | | } |
| | | }); |
| | | |
| | | |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | |
| | | var HBeginDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HSupID = $("#HSupID").val(); //ä¾åºåä¿¡æ¯ |
| | | var HEmpName = $("#HEmpName").val(); |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | | var HMaterName = $("#HMaterName").val(); |
| | | var HXTStatus = $("select[name='HXTStatus']").val(); |
| | | var HXTFKStatus = $("#HXTFKStatus").val(); |
| | | |
| | | if (HStatus) { |
| | | switch (HStatus) { |
| | | case '-1': //å
¨é¨ |
| | |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HSupID) { |
| | | sWhere += " and HSupID = '" + HSupID + "'"; |
| | | if (HMaterNumber) { |
| | | sWhere += " and ç©æä»£ç like '%" + HMaterNumber + "%'"; |
| | | } |
| | | if (HMaterName) { |
| | | sWhere += " and ç©æåç§° like '%" + HMaterName + "%'"; |
| | | } |
| | | if (HEmpName) { |
| | | sWhere += " and ä¸å¡å like '%" + HEmpName + "%'"; |
| | | } |
| | | if (HXTStatus) { |
| | | sWhere += " and ä¾åºåååç¶æ like '%" + HXTStatus + "%'"; |
| | | |
| | | } |
| | | if (HXTFKStatus) { |
| | | sWhere += " and åé¦ç¶æ like '%" + HXTFKStatus + "%'"; |
| | | |
| | | } |
| | | var index = layer.load(0); |
| | | get_Display(sWhere); |
| | |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val(""); |
| | | $("#HSupName").val(""); |
| | | $("#HSupID").val(""); |
| | | $("#HEmpName").val(""); |
| | | $("#HMaterNumber").val(""); |
| | | $("#HMaterName").val(""); |
| | | sWhere = ""; |
| | | get_Display(sWhere); |
| | | } |