其他出库、其他入库:子表件数可以输入为0
乔一客户物料即时库存报表:把米数和件数的合计加上去
(按生产订单)客户订单:过滤条件改为模糊查询
| | |
| | | data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck}, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var totalArray = []; |
| | | var totalArray = ["æ°é","ä»¶æ°"]; |
| | | var data = []; |
| | | var col = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | |
| | | sWhere = " and æ¥æ between ''" + HBeginDate + "'' and ''" + HEndDate + "'' "; |
| | | |
| | | if (HMaterNumber != "") { |
| | | sWhere += " and ç©æä»£ç =''" + HMaterNumber + "'' "; |
| | | sWhere += " and ç©æä»£ç like ''%" + HMaterNumber + "%'' "; |
| | | } |
| | | |
| | | if (HBillNo != "") { |
| | | sWhere += " and åæ®å·=''" + HBillNo + "'' "; |
| | | sWhere += " and åæ®å· like ''%" + HBillNo + "%'' "; |
| | | } |
| | | |
| | | if (HProductName != "") { |
| | | sWhere += " and ç©æåç§°=''" + HProductName + "'' "; |
| | | sWhere += " and ç©æåç§° like ''%" + HProductName + "%'' "; |
| | | } |
| | | |
| | | if (HProductModel != "") { |
| | | sWhere += " and è§æ ¼åå·=''" + HProductModel + "'' "; |
| | | sWhere += " and è§æ ¼åå· like ''%" + HProductModel + "%'' "; |
| | | } |
| | | |
| | | //ä»»æå段æ¡ä»¶è¿æ»¤ æ¡ä»¶æå |
| | |
| | | if (!ref1.test(temp)) { |
| | | layer.msg("第" + (i + 1) + "è¡ï¼ä»¶æ°è¯·è¾å
¥ä¸ä¸º0çæ´æ°ï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return; |
| | | } else if (temp * 1 == 0) { |
| | | layer.msg("第" + (i + 1) + "è¡ï¼ä»¶æ°è¯·è¾å
¥ä¸ä¸º0çæ´æ°ï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return false; |
| | | } |
| | | //else if (temp * 1 == 0) { |
| | | // layer.msg("第" + (i + 1) + "è¡ï¼ä»¶æ°è¯·è¾å
¥ä¸ä¸º0çæ´æ°ï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | // return false; |
| | | //} |
| | | } |
| | | |
| | | |
| | |
| | | if (!ref1.test(temp)) { |
| | | layer.msg("第" + (i + 1) + "è¡ï¼ä»¶æ°è¯·è¾å
¥ä¸ä¸º0çæ´æ°ï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return; |
| | | } else if (temp * 1 == 0) { |
| | | layer.msg("第" + (i + 1) + "è¡ï¼ä»¶æ°è¯·è¾å
¥ä¸ä¸º0çæ´æ°ï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return false; |
| | | } |
| | | //else if (temp * 1 == 0) { |
| | | // layer.msg("第" + (i + 1) + "è¡ï¼ä»¶æ°è¯·è¾å
¥ä¸ä¸º0çæ´æ°ï¼", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | // return false; |
| | | //} |
| | | } |
| | | |
| | | var num = []; |