| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä¸å¡ç¶æ</label> |
| | | <label class="layui-form-label">åé
ç¶æ</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HStatus" lay-filter="HStatus" style="width:190px;"> |
| | | <option value="-1" selected>å
¨é¨</option> |
| | | <option value="1">æªåé
</option> |
| | | <option value="2">å·²åé
</option> |
| | | <option value="3">å·²åå¸</option> |
| | | <option value="" selected="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"> |
| | | <select name="HStatus2" lay-filter="HStatus2" style="width:190px;"> |
| | | <option value="" selected="selected">å
¨é¨</option> |
| | | <option value="æªåå¸">æªåå¸</option> |
| | | <option value="å·²åå¸">å·²åå¸</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | |
| | | <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"> |
| | | <span>å
¶ä»æ¡ä»¶></span> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-inline"> |
| | | <span>å
¶ä»æ¡ä»¶></span> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ®å·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HBillno" id="HBillno" style="width:190px;"> |
| | | <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 class="layui-input-block" style="width:190px;"> |
| | | <select name="HEmpName" lay-filter="HEmpName" id="HEmpName"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | </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> |
| | | <label class="layui-form-label">ç©æç¼ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;"> |
| | | <input type="text" class="layui-input" name="HMaterShortNumber" id="HMaterShortNumber" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | <input type="text" class="layui-input" name="HMaterName" id="HMaterName" 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="HSupName" id="HSupName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline" style="margin-left:30px"> |
| | | <label class="layui-form-label">åé¦ç¶æ</label> |
| | | <div class="layui-input-block" style="width:190px;"> |
| | | <select name="HFeedback" lay-filter="HFeedback"> |
| | | <option value="" selected>å
¨é¨</option> |
| | | <option value="æ¥æ¶">æ¥æ¶</option> |
| | | <option value="夿">夿</option> |
| | | <option value="ç产">ç产</option> |
| | | <option value="åè´§">åè´§</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline" style="margin-left:30px"> |
| | | <label class="layui-form-label">å®æç¶æ</label> |
| | | <div class="layui-input-block" style="width:190px;"> |
| | | <select name="HFinishStatus" lay-filter="HFinishStatus"> |
| | | <option value="" selected>å
¨é¨</option> |
| | | <option value="æªå®æ" selected>æªå®æ</option> |
| | | <option value="已宿">已宿</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | <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="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <!--<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">鿰忥</button>--> |
| | | |
| | | </div> |
| | | </script> |
| | |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var Name = "MouldProdInHouseCellWidth"; |
| | | var HModName = "WW_EntrustOrderBillList"; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //å è½½æ°æ®å°ç½æ ¼ |
| | | get_Display(sWhere); |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | | |
| | | //#region ç¹å»äºä»¶å
æ¬on formäºä»¶ç |
| | |
| | | case 'btn-yxj': set_Yxj(); |
| | | break; |
| | | case 'btn-back': set_Back(); |
| | | break; |
| | | //å设置 |
| | | case 'set_HideColumn': get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | |
| | | }); |
| | | //#endregion |
| | | |
| | | |
| | | //#region æ¤é¡µé¢æææ¹æ³ |
| | | function set_ClearBill() { |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //ç´æ¥æ§è¡å表çé å è½½æ°æ®å°ç½æ ¼ |
| | | get_FastQuery(table, option) |
| | | //å è½½ä¸å¡å |
| | | get_HEmpName(); |
| | | //éèå¾éåæ®µ |
| | | DisPlay_HideColumn(); |
| | | } |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HBeginDate").val("2022-03-14"); |
| | | $("#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: 'ä¾åºå', title: 'ä¾åºå', width: 150 } |
| | | , { field: 'ä¸å¡å', title: 'ä¸å¡å', width: 100 } |
| | | , { field: 'HBillType', title: 'HBillType', hide: true } |
| | | , { field: 'HSupID', title: 'HSupID', hide: true } |
| | | , { field: 'ä¸å¡ç¶æ', title: 'ä¸å¡ç¶æ', width: 100 } |
| | | , { field: 'ä¾åºåååç¶æ', title: 'ä¾åºåååç¶æ', width: 135 } |
| | | , { field: 'ä¸å¡ç¶æ', title: 'ä¸å¡ç¶æ', width: 100 , hide: true } |
| | | , { field: 'åé
ç¶æ', title: 'åé
ç¶æ', width: 100 } |
| | | , { field: 'åå¸ç¶æ', title: 'åå¸ç¶æ', width: 100 } |
| | | , { 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: 'HPriority', title: 'HPriority', width: 100, hide: true } |
| | | , { field: 'ä¼å
级', title: 'ä¼å
级', width: 100 } |
| | | , { field: '交货å°ç¹', title: '交货å°ç¹', width: 100} |
| | | , { field: 'HPSStyleID', title: 'HPSStyleID', hide: true } |
| | | , { 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, 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: 'HDeptID', title: 'HDeptID', hide: true } |
| | | , { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ', width: 100} |
| | | , { field: 'é¨é¨', title: 'é¨é¨', width: 100} |
| | | , { field: 'HManagerID', title: 'HManagerID', hide: true } |
| | | , { field: '主管代ç ', title: '主管代ç ', width: 100} |
| | | , { field: '主管', title: '主管', width: 100} |
| | | , { field: 'HEmpID', title: 'HEmpID', hide: true } |
| | | , { 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: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 130 } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 130 } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 120 } |
| | | , { field: 'æ°é', title: 'è®¢åæ°é', width: 100} |
| | | , { field: 'æå°æ¡ç æ°é', title: 'æå°æ¡ç æ°é', width: 120} |
| | | , { field: 'å
³èæ°é', title: 'å·²åè´§æ°é', width: 120 } |
| | | , { field: 'æªå
³èæ°é', title: 'æªå·²åè´§æ°é', width: 120 } |
| | | , { 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: 120 } |
| | | , { field: '计éåä½', title: '计éåä½', width: 100 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 100 } |
| | | , { field: 'æ¹å·', title: 'æ¹å·', width: 100 } |
| | | , { field: 'æºååå·', title: 'æºååå·', width: 100 } |
| | | //, { field: 'ä¾åºå代ç ', title: 'ä¾åºå代ç ', width: 120, hide: true} |
| | | //, { field: 'ä¸å¡å代ç ', title: 'ä¸å¡å代ç ', width: 100, hide: true } |
| | | //, { field: 'HPriority', title: 'HPriority', width: 100, hide: true } |
| | | , { field: 'ä¼å
级', title: 'ä¼å
级', width: 100 } |
| | | , { field: '交货å°ç¹', title: '交货å°ç¹', width: 100 } |
| | | //, { field: 'HPSStyleID', title: 'HPSStyleID', hide: true } |
| | | , { 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, 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: 'HDeptID', title: 'HDeptID', hide: true } |
| | | , { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ', width: 100 } |
| | | , { field: 'é¨é¨', title: 'é¨é¨', width: 100 } |
| | | //, { field: 'HManagerID', title: 'HManagerID', hide: true } |
| | | , { field: '主管代ç ', title: '主管代ç ', width: 100 } |
| | | , { field: '主管', title: '主管', width: 100 } |
| | | //, { field: 'HEmpID', title: 'HEmpID', hide: true } |
| | | , { 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: 'ä»·ç¨å计', 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>" } |
| | | |
| | | ]; |
| | |
| | | , page: true |
| | | , cellMinWidth: 120 |
| | | , totalRow: true |
| | | , limit: 10 |
| | | , limit: 500 |
| | | , height: 'full-50' |
| | | , cols: [columns] |
| | | , limits: [50, 500, 1000, 5000] |
| | | , limits: [500, 5000, 20000] |
| | | , done: function (res, curr, count) { |
| | | |
| | | } |
| | |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery(table, option) { |
| | | var HStatus = $("select[name='HStatus']").val();//ç¶æ |
| | | var HStatus = $("select[name='HStatus']").val();// |
| | | var HStatus2 = $("select[name='HStatus2']").val();// |
| | | var HBeginDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HEmpID = $("#HEmpID").val(); |
| | | var HEmpName = $("#HEmpName").val(); |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | | var HMaterName = $("#HMaterName").val(); |
| | | var HXTStatus = $("select[name='HXTStatus']").val(); |
| | | var HXTFKStatus = $("#HXTFKStatus").val(); |
| | | //var HXTFKStatus = $("#HXTFKStatus").val(); |
| | | var HMaterShortNumber = $("#HMaterShortNumber").val(); |
| | | var HSupName = $("#HSupName").val();//ä¾åºå |
| | | var HFeedback = $("select[name='HFeedback']").val(); //ä¾åºååé¦ç¶æ |
| | | var HFinishStatus = $("select[name='HFinishStatus']").val(); //å®æç¶æ |
| | | |
| | | if (HStatus) { |
| | | switch (HStatus) { |
| | | case '-1': //å
¨é¨ |
| | | sWhere += ""; |
| | | break; |
| | | case '1': //æªåé
|
| | | sWhere += " and ä¸å¡ç¶æ='æªåé
'"; |
| | | break; |
| | | case '2': //å·²å®¡æ ¸ |
| | | sWhere += " and ä¸å¡ç¶æ='å·²åé
'"; |
| | | break; |
| | | case '3': //å·²å
³é |
| | | sWhere += " and ä¸å¡ç¶æ='å·²åå¸'"; |
| | | default: |
| | | |
| | | } |
| | | sWhere += " and åé
ç¶æ like '%" + HStatus + "%'"; |
| | | } |
| | | if (HStatus2) { |
| | | sWhere += " and åå¸ç¶æ like '%" + HStatus2 + "%'"; |
| | | } |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'"; |
| | |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HMaterShortNumber) { |
| | | sWhere += " and ç©æç¼ç like '%" + HMaterShortNumber + "%'"; |
| | | } |
| | | if (HMaterNumber) { |
| | | sWhere += " and ç©æä»£ç like '%" + HMaterNumber + "%'"; |
| | | } |
| | | if (HMaterName) { |
| | | sWhere += " and ç©æåç§° like '%" + HMaterName + "%'"; |
| | | } |
| | | if (HEmpID) { |
| | | sWhere += " and ä¸å¡å like '%" + HEmpID + "%'"; |
| | | if (HEmpName) { |
| | | sWhere += " and ä¸å¡å like '%" + HEmpName + "%'"; |
| | | } |
| | | if (HXTStatus) { |
| | | sWhere += " and ä¾åºåååç¶æ like '%" + HXTStatus + "%'"; |
| | | |
| | | } |
| | | if (HXTFKStatus) { |
| | | sWhere += " and åé¦ç¶æ like '%" + HXTFKStatus + "%'"; |
| | | //if (HXTFKStatus) { |
| | | // sWhere += " and åé¦ç¶æ like '%" + HXTFKStatus + "%'"; |
| | | |
| | | //} |
| | | if (HSupName) { |
| | | sWhere += " and ä¾åºå like '%" + HSupName + "%'"; |
| | | |
| | | } |
| | | if (HFeedback) { |
| | | sWhere += " and åé¦ç¶æ like '%" + HFeedback + "%'"; |
| | | |
| | | } |
| | | if (HFinishStatus) { |
| | | sWhere += " and å®æç¶æ like '%" + HFinishStatus + "%'"; |
| | | |
| | | } |
| | | var index = layer.load(0); |
| | |
| | | $("#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(""); |
| | | $("#HEmpID").val(""); |
| | | $("#HEmpName").val(""); |
| | | $("#HMaterNumber").val(""); |
| | | $("#HMaterName").val(""); |
| | | $("#HSupName").val("");//ä¾åºå |
| | | $("select[name='HFeedback']").val(""); //ä¾åºååé¦ç¶æ |
| | | sWhere = ""; |
| | | get_Display(sWhere); |
| | | } |
| | |
| | | function set_Refresh() { |
| | | $("#btnSearch").click(); |
| | | } |
| | | //è·åä¸å¡åæ°æ® |
| | | function get_HEmpName() { |
| | | var HEmpName = '<option value="">å
¨é¨</option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Web/GetEmployeeList_Json", |
| | | data: { "Employee": '', "HGroupID": 0 }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HEmpName += '<option value="' + data[i].HName + '">' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HEmpName").append(HEmpName); |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | var contentUrl = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ |
| | | var urlLen = urlStr.split('/'); |
| | | for (var i = 0; i < urlLen.length - 4; i++) { |
| | | contentUrl += "../"; |
| | | } |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | |
| | | contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName; |
| | | |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: [contentUrl, "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | type: "GET", |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | |
| | | |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = ["hmainid", "HBillType", "HSupID", "ä¸å¡ç¶æ", "HUnitID", "ä¾åºå代ç ", "ä¸å¡å代ç ", "HPriority", "HPSStyleID", "HSSID", "HCurID", "HDeptID", "HManagerID", "HEmpID", "hsubid","HMaterID"];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | //设置å宽 |
| | | if (dataCols[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //设置å
容åä½å¤§å° |
| | | if (data1.data[0].HFontSize != 0) { |
| | | option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; |
| | | } else { |
| | | option.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | //设置å宽 |
| | | //if (data1.data[0].HColumnWidth != 0) { |
| | | // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; |
| | | //} else { |
| | | // option.cols[0][i + 1]["width"] = ""; |
| | | //} |
| | | //æ¾ç¤ºå |
| | | if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | | option.cols[0][i + 1]["align"] = "left"; |
| | | break; |
| | | case "M": |
| | | option.cols[0][i + 1]["align"] = "center"; |
| | | break; |
| | | case "R": |
| | | option.cols[0][i + 1]["align"] = "right"; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | //åæ¶å»ç»å |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | if (option.cols[0][i]["fixed"] != null) { |
| | | option.cols[0][i]["fixed"] = null; |
| | | } |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | //å»ç»å |
| | | if (data1.data[0].HFixCols != 0) { |
| | | for (var i = 0; i < data1.data[0].HFixCols; i++) { |
| | | if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { |
| | | data1.data[0].HFixCols += 1; |
| | | } |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | } |
| | | table.render(option); |
| | | } else { |
| | | table.render(option); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }) |
| | | } |
| | | //以䏿¯layui模å |
| | | }); |
| | | </script> |