| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>å¶é 卿æ¥è¡¨</title> |
| | |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | </head> |
| | | |
| | | <body> |
| | | <div class="layui-fluid"> |
| | | <div class="layui-col-md12"> |
| | |
| | | </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 ForFilteringSchemes" name="HSeOrderBillNo" id="HSeOrderBillNo"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HSeOrderBillNo" |
| | | id="HSeOrderBillNo"> |
| | | </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 ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" |
| | | id="HMaterNumber"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ç»ç»</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HOrgID" id="HOrgID" lay-verify="HOrgID" class="ForFilteringSchemes"> |
| | | <select name="HOrgID" id="HOrgID" lay-verify="HOrgID" |
| | | class="ForFilteringSchemes"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" |
| | | lay-filter="btnSearch" id="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</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-inline" style="margin-left:5px;"> |
| | | <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div> |
| | | <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" |
| | | id="HFilterScheme_Now"></div> |
| | | </div> |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;" class="ForFilteringSchemes"> |
| | | <select name="ColName" id="ColName" lay-filter="ColName" |
| | | style="width:190px;" class="ForFilteringSchemes"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;" class="ForFilteringSchemes"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" |
| | | style="width:190px;" class="ForFilteringSchemes"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="<="> |
| | | <=< /option> |
| | | <option value="<"> |
| | | << /option> |
| | | <option value="<>"> |
| | | <> |
| | | </option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" |
| | | name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style=" margin-top: 10px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;"> |
| | | <select name="ColName1" id="ColName1" class="ForFilteringSchemes" |
| | | lay-filter="ColName1" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;"> |
| | | <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" |
| | | lay-filter="Comparator1" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="<="> |
| | | <=< /option> |
| | | <option value="<"> |
| | | << /option> |
| | | <option value="<>"> |
| | | <> |
| | | </option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" |
| | | name="ColContent1" id="ColContent1"> |
| | | </div> |
| | | </div> |
| | | |
| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;"> |
| | | <select name="ColName2" id="ColName2" class="ForFilteringSchemes" |
| | | lay-filter="ColName2" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;"> |
| | | <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" |
| | | lay-filter="Comparator2" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="<="> |
| | | <=< /option> |
| | | <option value="<"> |
| | | << /option> |
| | | <option value="<>"> |
| | | <> |
| | | </option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" |
| | | name="ColContent2" id="ColContent2"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | } |
| | | }); |
| | | |
| | | //æ¥æé´é䏿å表çå¬ |
| | | 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); |
| | | } |
| | | }); |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | |
| | | |
| | | //#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); |
| | | } |
| | | |
| | | //æ ¹æ®æ¥æé´é设置å¼å§æ¶é´ä¸ç»ææ¶é´ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | //åå§åç»ç» |
| | | Organ(); |
| | | //åå§åè¡¨æ ¼ |
| | |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery(number) { |
| | | |
| | | var HBeginDate = $("#HBeginDate").val(); |
| | | var HEndDate = $("#HEndDate").val(); |
| | | var HSeOrderBillNo = $("#HSeOrderBillNo").val(); |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | | var HOrgID = ""; |
| | |
| | | sWhere += " and æåç©æç¼ç like '%" + HMaterNumber + "%'"; |
| | | } |
| | | |
| | | if (HBeginDate && HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),çäº§è®¢åæ¥æ, 23) between '" + HBeginDate + "' and '" + HEndDate + "'" |
| | | } |
| | | |
| | | sWhere += addSWhereByOpenType(); |
| | | |
| | | sWhere += getOrgIDByUser();//ç¨æ·å
³èç»ç»æ¥è¯¢è¿æ»¤ |
| | |
| | | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | 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")); //ç»ææ¥æ |
| | | $("#HSeOrderBillNo").val(""); |
| | | $("#HMaterNumber").val(""); |
| | | $("#HOrgID").val(sessionStorage["OrganizationID"]); |
| | |
| | | }) |
| | | } |
| | | |
| | | //#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("29"); |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | //#endregion |
| | | //以䏿¯layui模å |
| | | }); |
| | |
| | | </script> |
| | | |
| | | </body> |
| | | |
| | | </html> |