| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æ¥æé´é</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" |
| | | lay-filter="HInitTimeCycle" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" |
| | | style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" |
| | | style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">å°è½¦ç¼ç </label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HCarBarCode" id="HCarBarCode"> |
| | |
| | | <label class="layui-form-label" style="width: 85px;">ä»åºåç§°</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HWHID" id="HWHID" value="0" style="display:none"> |
| | | <input type="text" class="layui-input" name="HWHName" id="HWHName" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" name="HWHName" id="HWHName" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHWHID" id="btnHWHID" style="padding: 0 10px; margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | |
| | | <label class="layui-form-label" style="width: 85px;">ä»ä½åç§°</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HSPID" id="HSPID" value="0" style="display:none"> |
| | | <input type="text" class="layui-input" name="HStockPlaceName" id="HStockPlaceName" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" name="HStockPlaceName" id="HStockPlaceName" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHStockPlaceID" id="btnHStockPlaceID" style="padding: 0 10px; margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | |
| | | //#region æ¤é¡µé¢æææ¹æ³ |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åæ¥æé´éãå¼å§æ¥æãç»ææ¥æ |
| | | setSelect_HInitTimeCycle(); |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | if (HInitTimeCycle != -1) { |
| | | $('#HBeginDate').prop('disabled', true); |
| | | $('#HEndDate').prop('disabled', true); |
| | | } else { |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | var today = new Date(); |
| | | var twoDaysAgo = new Date(); |
| | | twoDaysAgo.setDate(today.getDate() - 2); |
| | | //æ ¹æ®æ¥æé´é设置å¼å§æ¶é´ä¸ç»ææ¶é´ |
| | | $("#HBeginDate").val(Format(twoDaysAgo, "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | get_FastQuery(); |
| | |
| | | } |
| | | }); |
| | | |
| | | //#region åå§æ¥æé´é 䏿å表 |
| | | function setSelect_HInitTimeCycle() { |
| | | var valueList = [0, 1, 2, 3, 4, 5, 6, 29]; |
| | | var titleList = ["ä»å¤©", "è¿ä¸¤å¤©", "è¿ä¸å¤©", "è¿å天", "è¿äºå¤©", "è¿å
天", "è¿ä¸å¤©", "è¿30天"]; |
| | | |
| | | var HInitTimeCycle_ArrayList = '<option value="-1" selected="selected" >ä»»æé´é</option>'; |
| | | for (var i = 0; i < valueList.length; i++) { |
| | | HInitTimeCycle_ArrayList += '<option style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>'; |
| | | } |
| | | |
| | | $("#HInitTimeCycle").empty(); |
| | | $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList); |
| | | form.render('select'); |
| | | |
| | | $("#HInitTimeCycle").val("-1"); |
| | | } |
| | | //#endregion |
| | | //æ¥è¯¢ |
| | | function get_Display(HCarBarCode, HBillType, HProcExBillNo, HMaterNumber, HWHID, HSPID, sWhere) { |
| | | var index = layer.load(0, { shade: false }); |
| | |
| | | async:false, |
| | | data: { "HBillType": HBillType, "HCarBarCode": HCarBarCode, "HProcExBillNo": HProcExBillNo, "HMaterNumber": HMaterNumber, "HWHID": HWHID, "HSPID": HSPID, "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | if (data1.count >-1) { |
| | | var data = []; |
| | | var col = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | |
| | | |
| | | //å¿«éæ¥è¯¢ |
| | | function get_FastQuery() { |
| | | var HWHName = $("#HWHName").val(); |
| | | var HStockPlaceName = $("#HStockPlaceName").val(); |
| | | var HBeginDate = $("#HBeginDate").val(); |
| | | var HEndDate = $("#HEndDate").val(); |
| | | var HCarBarCode = $('#HCarBarCode').val() |
| | | var HBillType = $('#HBillType').val() |
| | | var HProcExBillNo = $('#HProcExBillNo').val() |
| | |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | if (HBeginDate && HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),æä½æ¶é´, 23) between '" + HBeginDate + "' and '" + HEndDate + "' " |
| | | } |
| | | if (HStockPlaceName) { |
| | | sWhere += "and åºä½åç§° like '%" + HStockPlaceName + "%'"; |
| | | |
| | | } |
| | | if (HWHName) sWhere += "and ä»åº like '%" + HWHName + "%'"; |
| | | get_Display(HCarBarCode, HBillType, HProcExBillNo, HMaterNumber, HWHID, HSPID, sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | |
| | |
| | | |
| | | //éç½®å¿«éæ¥è¯¢ |
| | | function set_ClearQuery() { |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); //ç»ææ¥æ |
| | | $('#HCarBarCode').val("") |
| | | $('#HBillType').val("") |
| | | $('#HProcExBillNo').val("") |
| | |
| | | $("#ColContent2").val(""); |
| | | $("#ColName2").val("0"); |
| | | $("#Comparator2").val("0"); |
| | | sWhere = ""; |
| | | get_FastQuery(); |
| | | } |
| | | |
| | |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } |
| | | //#endregion |
| | | //æ¥æé´é䏿å表çå¬ |
| | | form.on('select(HInitTimeCycle)', function (data) { |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | if (HInitTimeCycle != -1) { |
| | | $('#HBeginDate').prop('disabled', true); |
| | | $('#HEndDate').prop('disabled', true); |
| | | |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery(); |
| | | } else { |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | }); |
| | | //ä»åº |
| | | form.on('submit(btnHWHID)', function () { |
| | | //页é¢å±-èªå®ä¹ |