From 852a9ee80fe79ac87854b8b46ad67ac857a56fc6 Mon Sep 17 00:00:00 2001
From: vince <757871790@qq.com>
Date: 星期四, 20 七月 2023 21:05:57 +0800
Subject: [PATCH] 出入库单据模板
---
igds-inout/src/main/java/com/ld/igds/inout/manager/InoutReportManager.java | 41 ++
igds-web/src/main/resources/static/img/aerial-5012_001.png | 0
igds-web/src/main/resources/static/img/logo-title-5012.png | 0
igds-web/src/main/resources/application-pro5012.yml | 81 ++++
igds-web/src/main/resources/static/img/logo-5012.png | 0
igds-inout/src/main/java/com/ld/igds/inout/dto/WeightBill.java | 3
igds-web/src/main/resources/application.yml | 4
igds-web/src/main/resources/static/img/logo-5005.png | 0
igds-inout/src/main/java/com/ld/igds/inout/InoutBill.java | 861 ++++++++++++++++++++++++++++++++++++++++++++++++++
9 files changed, 985 insertions(+), 5 deletions(-)
diff --git a/igds-inout/src/main/java/com/ld/igds/inout/InoutBill.java b/igds-inout/src/main/java/com/ld/igds/inout/InoutBill.java
index fa0b43a..318f665 100644
--- a/igds-inout/src/main/java/com/ld/igds/inout/InoutBill.java
+++ b/igds-inout/src/main/java/com/ld/igds/inout/InoutBill.java
@@ -138,5 +138,866 @@
*/
public static String OUT_WEIGHT_5322 = "<!DOCTYPE html><html lang='zh-cn'><head><meta http-equiv='Content-Type'content='text/html;charset=UTF-8'><title>鍑哄簱杩囩鍗�</title><style>body{text-align:center;padding:10px}.tit{margin:5px;font-size:24px;font-family:'瀹嬩綋';padding-top:10px}.div-tit{padding-top:6px}table{width:100%;border-right:1px solid;border-bottom:1px solid;font-size:14px}table td{border-left:1px solid;border-top:1px solid;height:32px}.sp1{width:33%;float:left;padding-bottom:5px}.sp2{width:25%;float:left;text-align:center}.txt-left{text-align:left}.txt-center{text-align:center}.txt-right{text-align:right}.bot{margin-bottom:10px}</style></head><body><h1 class='tit'>billTitle</h1><div class='div-tit'><span class='sp1 txt-left'>鐧昏鏃堕棿锛歳egisterTime</span><span class='sp1 txt-center'>瀹屾垚鏃堕棿锛歝ompleteTime</span><span class='sp1 txt-right'>鍗曞彿锛歴erId</span></div><table cellspacing='0'cellpadding='0'><tr><td>杞︾墝鍙�</td><td>plateNum</td><td>鐨噸(鍏枻)</td><td>emptyWeight</td></tr><tr><td>澶ч粍鍌ㄥ搴�</td><td>depotName</td><td>姣涢噸(鍏枻)</td><td>fullWeight</td></tr><tr><td>渚涜揣鍗曚綅</td><td>deptName</td><td>鍑�閲�(鍏枻)</td><td>netWeight</td></tr><tr><td>鏀惰揣鍗曚綅</td><td>customerName</td><td>鎬绘墸閲�</td><td>deSum</td></tr><tr><td>璐х墿鍚嶇О</td><td>foodVariety</td><td>鏉傝川(%)</td><td>impurity</td></tr><tr><td>鍖呰瑙勬牸</td><td></td><td>姘村垎(%)</td><td>wet</td></tr><tr><td>鍖呮暟</td><td></td><td>缁撶畻閲嶉噺(鍏枻)</td><td>settleWeight</td></tr><tr><td>椹鹃┒鍛�</td><td>driverName</td><td>鍗曚环(鍏�/鍏枻)</td><td>price</td></tr><tr><td>杩囩鏃堕棿</td><td>emptyTime</td><td>閲戦(鍏�)</td><td>settleMoney</td></tr><tr><td>澶囨敞</td><td colspan='3'>remark</td></tr></table><div class='div-tit'><span class='sp2 txt-left bot'>鍙哥鍛橈細</span><span class='sp2 txt-left bot'>淇濈鍛橈細</span><span class='sp2 txt-left bot'>浠樻鍛橈細</span><span class='sp2 txt-left bot'>鎵胯繍浜猴細</span></div><div class='div-tit'style=\"margin-top: 10px\"><span class='sp2'>1.浠撳簱锛堢櫧锛�</span><span class='sp2'>2.浠樻锛堢孩锛�</span><span class='sp2'>3.瀹㈡埛锛堣摑锛�</span><span class='sp2'>4.鍐滃彂琛岋紙榛勶級</span></div></body></html>";
+ /**
+ * 甯傚簱鍏ュ簱绉伴噸鍗�
+ */
+ public static String IN_WEIGHT_5005 = "<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><title>鍏ュ簱纾呭崟</title><style> .table1 {float:left;margin-left:20px }table,td,th {border: 1px solid black;border-style: solid;border-collapse: collapse;font-size:12px ;} .table1 td{height:20}</style></head><body><p><strong style=\"padding-left:50px;font-size: 24px;\">绗竴鑱�</strong><strong style=\"padding-left:200px;font-size: 24px;\">绗簩鑱�</strong><strong style=\"padding-left:200px;font-size: 24px;\">绗笁鑱�</strong></p><table class=\"table1\" border=\"1\" height=\"300px\"><tr ><td width = \"90px\">鍏ュ簱鏃堕棿锛�</td><td width = \"130px\">time</td></tr><tr ><td>娴佹按鍙凤細</td><td>serId</td></tr><tr ><td >杞︾墝鍙凤細</td><td>plateNum</td></tr><tr ><td>鍙戣揣鍗曚綅锛�</td><td>customerName</td></tr><tr ><td>鏀惰揣鍗曚綅锛�</td><td>unitName</td></tr><tr ><td>鍝佺锛�</td><td>foodVariety</td></tr><tr ><td>姣涢噸锛�</td><td>fullWeight</td></tr><tr ><td>鐨噸锛�</td><td>emptyWeight</td></tr><tr ><td>鍑�閲嶏細</td><td>netWeight</td></tr><tr ><td>鎬绘墸閲嶏細</td><td>deSum</td></tr><tr ><td>缁撶畻閲嶉噺锛�</td><td>settleWeight</td></tr><tr ><td>绉伴噸浜猴細</td><td>weightUser</td></tr><tr ><td >瀹㈡埛绛惧瓧锛�</td><td ></td></tr></table><table class=\"table1\" border=\"1\" height=\"300px\"><tr ><td width = \"90px\">鍏ュ簱鏃堕棿锛�</td><td width = \"130px\">time</td></tr><tr ><td>娴佹按鍙凤細</td><td>serId</td></tr><tr ><td >杞︾墝鍙凤細</td><td>plateNum</td></tr><tr ><td>鍙戣揣鍗曚綅锛�</td><td>customerName</td></tr><tr ><td>鏀惰揣鍗曚綅锛�</td><td>unitName</td></tr><tr ><td>鍝佺锛�</td><td>foodVariety</td></tr><tr ><td>姣涢噸锛�</td><td>fullWeight</td></tr><tr ><td>鐨噸锛�</td><td>emptyWeight</td></tr><tr ><td>鍑�閲嶏細</td><td>netWeight</td></tr><tr ><td>鎬绘墸閲嶏細</td><td>deSum</td></tr><tr ><td>缁撶畻閲嶉噺锛�</td><td>settleWeight</td></tr><tr ><td>绉伴噸浜猴細</td><td>weightUser</td></tr><tr ><td >瀹㈡埛绛惧瓧锛�</td><td ></td></tr></table><table class=\"table1\" border=\"1\" height=\"300px\"><tr ><td width = \"90px\">鍏ュ簱鏃堕棿锛�</td><td width = \"130px\">time</td></tr><tr ><td>娴佹按鍙凤細</td><td>serId</td></tr><tr ><td >杞︾墝鍙凤細</td><td>plateNum</td></tr><tr ><td>鍙戣揣鍗曚綅锛�</td><td>customerName</td></tr><tr ><td>鏀惰揣鍗曚綅锛�</td><td>unitName</td></tr><tr ><td>鍝佺锛�</td><td>foodVariety</td></tr><tr ><td>姣涢噸锛�</td><td>fullWeight</td></tr><tr ><td>鐨噸锛�</td><td>emptyWeight</td></tr><tr ><td>鍑�閲嶏細</td><td>netWeight</td></tr><tr ><td>鎬绘墸閲嶏細</td><td>deSum</td></tr><tr ><td>缁撶畻閲嶉噺锛�</td><td>settleWeight</td></tr><tr ><td>绉伴噸浜猴細</td><td>weightUser</td></tr><tr ><td >瀹㈡埛绛惧瓧锛�</td><td ></td></tr></table></body></html>";
+ /**
+ * 甯傚簱鍑哄簱绉伴噸鍗�
+ */
+ public static String OUT_WEIGHT_5005 = "<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><title>鍑哄簱纾呭崟</title><style> .table1 {float:left;margin-left:20px }table,td,th {border: 1px solid black;border-style: solid;border-collapse: collapse;font-size:12px ;} .table1 td{height:20}</style></head><body><p><strong style=\"padding-left:50px;font-size: 24px;\">绗竴鑱�</strong><strong style=\"padding-left:200px;font-size: 24px;\">绗簩鑱�</strong><strong style=\"padding-left:200px;font-size: 24px;\">绗笁鑱�</strong></p><table class=\"table1\" border=\"1\" height=\"300px\"><tr ><td width = \"90px\">鍑哄簱鏃堕棿锛�</td><td width = \"130px\">time</td></tr><tr ><td>娴佹按鍙凤細</td><td>serId</td></tr><tr ><td >杞︾墝鍙凤細</td><td>plateNum</td></tr><tr ><td>鍙戣揣鍗曚綅锛�</td><td>unitName</td></tr><tr ><td>鏀惰揣鍗曚綅锛�</td><td>customerName</td></tr><tr ><td>鍝佺锛�</td><td>foodVariety</td></tr><tr ><td>姣涢噸锛�</td><td>fullWeight</td></tr><tr ><td>鐨噸锛�</td><td>emptyWeight</td></tr><tr ><td>鍑�閲嶏細</td><td>netWeight</td></tr><tr ><td>鎬绘墸閲嶏細</td><td>deSum</td></tr><tr ><td>缁撶畻閲嶉噺锛�</td><td>settleWeight</td></tr><tr ><td>绉伴噸浜猴細</td><td>weightUser</td></tr><tr ><td >瀹㈡埛绛惧瓧锛�</td><td ></td></tr></table><table class=\"table1\" border=\"1\" height=\"300px\"><tr ><td width = \"90px\">鍑哄簱鏃堕棿锛�</td><td width = \"130px\">time</td></tr><tr ><td>娴佹按鍙凤細</td><td>serId</td></tr><tr ><td >杞︾墝鍙凤細</td><td>plateNum</td></tr><tr ><td>鍙戣揣鍗曚綅锛�</td><td>unitName</td></tr><tr ><td>鏀惰揣鍗曚綅锛�</td><td>customerName</td></tr><tr ><td>鍝佺锛�</td><td>foodVariety</td></tr><tr ><td>姣涢噸锛�</td><td>fullWeight</td></tr><tr ><td>鐨噸锛�</td><td>emptyWeight</td></tr><tr ><td>鍑�閲嶏細</td><td>netWeight</td></tr><tr ><td>鎬绘墸閲嶏細</td><td>deSum</td></tr><tr ><td>缁撶畻閲嶉噺锛�</td><td>settleWeight</td></tr><tr ><td>绉伴噸浜猴細</td><td>weightUser</td></tr><tr ><td >瀹㈡埛绛惧瓧锛�</td><td ></td></tr></table><table class=\"table1\" border=\"1\" height=\"300px\"><tr ><td width = \"90px\">鍑哄簱鏃堕棿锛�</td><td width = \"130px\">time</td></tr><tr ><td>娴佹按鍙凤細</td><td>serId</td></tr><tr ><td >杞︾墝鍙凤細</td><td>plateNum</td></tr><tr ><td>鍙戣揣鍗曚綅锛�</td><td>unitName</td></tr><tr ><td>鏀惰揣鍗曚綅锛�</td><td>customerName</td></tr><tr ><td>鍝佺锛�</td><td>foodVariety</td></tr><tr ><td>姣涢噸锛�</td><td>fullWeight</td></tr><tr ><td>鐨噸锛�</td><td>emptyWeight</td></tr><tr ><td>鍑�閲嶏細</td><td>netWeight</td></tr><tr ><td>鎬绘墸閲嶏細</td><td>deSum</td></tr><tr ><td>缁撶畻閲嶉噺锛�</td><td>settleWeight</td></tr><tr ><td>绉伴噸浜猴細</td><td>weightUser</td></tr><tr ><td >瀹㈡埛绛惧瓧锛�</td><td ></td></tr></table></body></html>";
+ /**
+ * 涓规１鍑哄簱绉伴噸鍗�
+ */
+ public static String OUT_WEIGHT_5012 = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\n" +
+ "xmlns:x=\"urn:schemas-microsoft-com:office:excel\"\n" +
+ "xmlns=\"http://www.w3.org/TR/REC-html40\">\n" +
+ "\n" +
+ "<head>\n" +
+ "<meta http-equiv=Content-Type content=\"text/html; charset=gb2312\">\n" +
+ "<meta name=ProgId content=Excel.Sheet>\n" +
+ "<meta name=Generator content=\"Microsoft Excel 15\">\n" +
+ "<link rel=File-List href=\"鍑哄簱鍗�.files/filelist.xml\">\n" +
+ "<style id=\"鍏ュ簱鍗昣28552_Styles\">\n" +
+ "<!--table\n" +
+ "\t{mso-displayed-decimal-separator:\"\\.\";\n" +
+ "\tmso-displayed-thousand-separator:\"\\,\";}\n" +
+ ".font528552\n" +
+ "\t{color:windowtext;\n" +
+ "\tfont-size:9.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;}\n" +
+ ".xl1528552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:11.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:general;\n" +
+ "\tvertical-align:bottom;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6328552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder-top:1.0pt solid windowtext;\n" +
+ "\tborder-right:.5pt solid windowtext;\n" +
+ "\tborder-bottom:none;\n" +
+ "\tborder-left:1.0pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6428552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder-top:none;\n" +
+ "\tborder-right:.5pt solid windowtext;\n" +
+ "\tborder-bottom:1.0pt solid windowtext;\n" +
+ "\tborder-left:1.0pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6528552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6628552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:6.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6728552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:general;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6828552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:12.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:bottom;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6928552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:12.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:bottom;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7028552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder-top:none;\n" +
+ "\tborder-right:.5pt solid windowtext;\n" +
+ "\tborder-bottom:none;\n" +
+ "\tborder-left:1.0pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7128552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder-top:1.0pt solid windowtext;\n" +
+ "\tborder-right:.5pt solid windowtext;\n" +
+ "\tborder-bottom:.5pt solid windowtext;\n" +
+ "\tborder-left:1.0pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7228552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder-top:.5pt solid windowtext;\n" +
+ "\tborder-right:.5pt solid windowtext;\n" +
+ "\tborder-bottom:.5pt solid windowtext;\n" +
+ "\tborder-left:1.0pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7328552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7428552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:6.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7528552\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder-top:none;\n" +
+ "\tborder-right:none;\n" +
+ "\tborder-bottom:1.0pt solid windowtext;\n" +
+ "\tborder-left:none;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ "ruby\n" +
+ "\t{ruby-align:left;}\n" +
+ "rt\n" +
+ "\t{color:windowtext;\n" +
+ "\tfont-size:9.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-char-type:none;}\n" +
+ "-->\n" +
+ "</style>\n" +
+ "</head>\n" +
+ "\n" +
+ "<body>\n" +
+ "<!--[if !excel]>銆�銆�<![endif]-->\n" +
+ "<!--涓嬪垪淇℃伅鐢� Microsoft Excel 鐨勫彂甯冧负缃戦〉鍚戝鐢熸垚銆�-->\n" +
+ "<!--濡傛灉鍚屼竴鏉＄洰浠� Excel 涓噸鏂板彂甯冿紝鍒欐墍鏈変綅浜� DIV 鏍囪涔嬮棿鐨勪俊鎭潎灏嗚鏇挎崲銆�-->\n" +
+ "<!----------------------------->\n" +
+ "<!--鈥滀粠 EXCEL 鍙戝竷缃戦〉鈥濆悜瀵煎紑濮�-->\n" +
+ "<!----------------------------->\n" +
+ "\n" +
+ "<div id=\"鍏ュ簱鍗昣28552\" align=center x:publishsource=\"Excel\">\n" +
+ "\n" +
+ "<table border=0 cellpadding=0 cellspacing=0 width=684 style='border-collapse:\n" +
+ " collapse;table-layout:fixed;width:517pt'>\n" +
+ " <col width=45 style='mso-width-source:userset;mso-width-alt:1440;width:34pt'>\n" +
+ " <col width=54 style='mso-width-source:userset;mso-width-alt:1728;width:41pt'>\n" +
+ " <col width=45 span=13 style='mso-width-source:userset;mso-width-alt:1440;\n" +
+ " width:34pt'>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=15 height=29 class=xl6828552 width=684 style='height:21.95pt;\n" +
+ " width:517pt'>鍥涘窛涓规１鍩庡叧鐪佺伯椋熷偍澶囧簱-绮补鍑哄簱鍗�</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=2 height=29 class=xl7528552 style='height:21.95pt'>娴佹按鍗曞彿锛�</td>\n" +
+ " <td colspan=3 class=xl7428552>serId</td>\n" +
+ " <td colspan=2 class=xl7328552>鍑哄簱鏃堕棿锛�</td>\n" +
+ " <td colspan=3 class=xl7428552>time</td>\n" +
+ " <td colspan=2 class=xl7328552>濉啓鍗曚綅锛�</td>\n" +
+ " <td colspan=3 class=xl7428552>unitName</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td rowspan=2 height=58 class=xl6328552 style='height:43.9pt'>鐧昏</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>鍙戣揣鍗曚綅</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>鏀惰揣鍗曚綅</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>鎵胯繍浜�</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>杞﹁埞鍙�</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>杩愯緭鏂瑰紡</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=3 height=29 class=xl6628552 style='height:21.95pt;border-left:\n" +
+ " none'>unitName</td>\n" +
+ " <td colspan=3 class=xl6628552 style='border-left:none'>customerName</td>\n" +
+ " <td colspan=3 class=xl6628552 style='border-left:none'>driverName</td>\n" +
+ " <td colspan=3 class=xl6628552 style='border-left:none'>plateNum</td>\n" +
+ " <td colspan=2 class=xl6628552 style='border-left:none'>姹借溅</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td rowspan=2 height=58 class=xl7128552 style='height:43.9pt'>淇℃伅</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>鍝佺</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>浜у湴</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>銆�</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td height=29 class=xl6628552 style='height:21.95pt;border-top:none;\n" +
+ " border-left:none'>foodVariety</td>\n" +
+ " <td class=xl6628552 style='border-top:none;border-left:none'>foodLocation</td>\n" +
+ " <td class=xl6628552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>銆�</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td height=29 class=xl6328552 style='height:21.95pt'>鍏ヤ粨</td>\n" +
+ " <td class=xl6528552 style='border-top:none;border-left:none'>鍑虹伯浠撳彿</td>\n" +
+ " <td colspan=2 class=xl6628552 style='border-left:none'>depotName</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>鍑轰粨寮�濮嬫椂闂�</td>\n" +
+ " <td colspan=2 class=xl6628552 style='border-left:none'>handleStart</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>鍑轰粨缁撴潫鏃堕棿</td>\n" +
+ " <td colspan=2 class=xl6628552 style='border-left:none'>handleEnd</td>\n" +
+ " <td class=xl6728552 style='border-top:none;border-left:none'>淇濈浜�<span\n" +
+ " style='display:none'>鍛�</span></td>\n" +
+ " <td colspan=2 class=xl6628552 style='border-left:none'>keeperName</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td rowspan=2 height=58 class=xl6328552 style='border-bottom:1.0pt solid black;\n" +
+ " height:43.9pt'>妫�鏂�</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>姣涢噸</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>鐨噸</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>鍑�閲�</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>鎬绘墸閲�</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>缁撶畻閲嶉噺</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>绉伴噸浜哄憳</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=2 height=29 class=xl6528552 style='height:21.95pt;border-left:\n" +
+ " none'>fullWeight</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>emptyWeight</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>netWeight</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>deSum</td>\n" +
+ " <td colspan=3 class=xl6528552 style='border-left:none'>settleWeight</td>\n" +
+ " <td colspan=2 class=xl6628552 style='border-left:none'>weightUser</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td height=29 class=xl6428552 style='height:21.95pt'>澶囨敞</td>\n" +
+ " <td colspan=8 class=xl6528552 style='border-left:none'>銆�</td>\n" +
+ " <td colspan=2 class=xl6528552 style='border-left:none'>瀹㈡埛绛惧瓧</td>\n" +
+ " <td colspan=4 class=xl6528552 style='border-left:none'>銆�</td>\n" +
+ " </tr>\n" +
+ " <![if supportMisalignedColumns]>\n" +
+ " <tr height=0 style='display:none'>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=54 style='width:41pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " </tr>\n" +
+ " <![endif]>\n" +
+ "</table>\n" +
+ "\n" +
+ "</div>\n" +
+ "\n" +
+ "\n" +
+ "<!----------------------------->\n" +
+ "<!--鈥滀粠 EXCEL 鍙戝竷缃戦〉鈥濆悜瀵肩粨鏉�-->\n" +
+ "<!----------------------------->\n" +
+ "</body>\n" +
+ "\n" +
+ "</html>\n";
+
+ /**
+ * 涓规１鍏ュ簱绉伴噸鍗�
+ */
+ public static String IN_WEIGHT_5012 = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\n" +
+ "xmlns:x=\"urn:schemas-microsoft-com:office:excel\"\n" +
+ "xmlns=\"http://www.w3.org/TR/REC-html40\">\n" +
+ "\n" +
+ "<head>\n" +
+ "<meta http-equiv=Content-Type content=\"text/html; charset=gb2312\">\n" +
+ "<meta name=ProgId content=Excel.Sheet>\n" +
+ "<meta name=Generator content=\"Microsoft Excel 15\">\n" +
+ "<link rel=File-List href=\"鍏ュ簱鍗�.files/filelist.xml\">\n" +
+ "<style id=\"鍏ュ簱鍗昣29464_Styles\">\n" +
+ "<!--table\n" +
+ "\t{mso-displayed-decimal-separator:\"\\.\";\n" +
+ "\tmso-displayed-thousand-separator:\"\\,\";}\n" +
+ ".font529464\n" +
+ "\t{color:windowtext;\n" +
+ "\tfont-size:9.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;}\n" +
+ ".xl1529464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:11.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:general;\n" +
+ "\tvertical-align:bottom;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6329464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:8.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6429464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:6.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6529464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:8.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:general;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6629464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:12.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6729464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:12.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6829464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:8.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl6929464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:6.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7029464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:8.0pt;\n" +
+ "\tfont-weight:700;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ ".xl7129464\n" +
+ "\t{padding-top:1px;\n" +
+ "\tpadding-right:1px;\n" +
+ "\tpadding-left:1px;\n" +
+ "\tmso-ignore:padding;\n" +
+ "\tcolor:black;\n" +
+ "\tfont-size:10.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-number-format:General;\n" +
+ "\ttext-align:center;\n" +
+ "\tvertical-align:middle;\n" +
+ "\tborder:.5pt solid windowtext;\n" +
+ "\tmso-background-source:auto;\n" +
+ "\tmso-pattern:auto;\n" +
+ "\twhite-space:nowrap;}\n" +
+ "ruby\n" +
+ "\t{ruby-align:left;}\n" +
+ "rt\n" +
+ "\t{color:windowtext;\n" +
+ "\tfont-size:9.0pt;\n" +
+ "\tfont-weight:400;\n" +
+ "\tfont-style:normal;\n" +
+ "\ttext-decoration:none;\n" +
+ "\tfont-family:绛夌嚎;\n" +
+ "\tmso-generic-font-family:auto;\n" +
+ "\tmso-font-charset:134;\n" +
+ "\tmso-char-type:none;}\n" +
+ "-->\n" +
+ "</style>\n" +
+ "</head>\n" +
+ "\n" +
+ "<body>\n" +
+ "<!--[if !excel]>銆�銆�<![endif]-->\n" +
+ "<!--涓嬪垪淇℃伅鐢� Microsoft Excel 鐨勫彂甯冧负缃戦〉鍚戝鐢熸垚銆�-->\n" +
+ "<!--濡傛灉鍚屼竴鏉＄洰浠� Excel 涓噸鏂板彂甯冿紝鍒欐墍鏈変綅浜� DIV 鏍囪涔嬮棿鐨勪俊鎭潎灏嗚鏇挎崲銆�-->\n" +
+ "<!----------------------------->\n" +
+ "<!--鈥滀粠 EXCEL 鍙戝竷缃戦〉鈥濆悜瀵煎紑濮�-->\n" +
+ "<!----------------------------->\n" +
+ "\n" +
+ "<div id=\"鍏ュ簱鍗昣29464\" align=center x:publishsource=\"Excel\">\n" +
+ "\n" +
+ "<table border=0 cellpadding=0 cellspacing=0 width=675 style='border-collapse:\n" +
+ " collapse;table-layout:fixed;width:510pt'>\n" +
+ " <col width=45 span=15 style='mso-width-source:userset;mso-width-alt:1440;\n" +
+ " width:34pt'>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=15 height=29 class=xl6629464 width=675 style='height:21.95pt;\n" +
+ " width:510pt'>鍥涘窛涓规１鍩庡叧鐪佺伯椋熷偍澶囧簱-绮补鍏ュ簱鍗�</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=2 height=29 class=xl6829464 style='height:21.95pt'>娴佹按鍗曞彿锛�</td>\n" +
+ " <td colspan=3 class=xl6929464>serId</td>\n" +
+ " <td colspan=2 class=xl6829464>鍏ュ簱鏃堕棿锛�</td>\n" +
+ " <td colspan=3 class=xl6929464>time</td>\n" +
+ " <td colspan=2 class=xl6829464>濉啓鍗曚綅锛�</td>\n" +
+ " <td colspan=3 class=xl6929464>unitName</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td rowspan=2 height=58 class=xl7029464 style='height:43.9pt'>鐧昏</td>\n" +
+ " <td colspan=3 class=xl6329464 style='border-left:none'>鍙戣揣鍗曚綅</td>\n" +
+ " <td colspan=3 class=xl6329464 style='border-left:none'>鏀惰揣鍗曚綅</td>\n" +
+ " <td colspan=3 class=xl6329464 style='border-left:none'>鎵胯繍浜�</td>\n" +
+ " <td colspan=3 class=xl6329464 style='border-left:none'>杞﹁埞鍙�</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>杩愯緭鏂瑰紡</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=3 height=29 class=xl6429464 style='height:21.95pt;border-left:\n" +
+ " none'>customerName</td>\n" +
+ " <td colspan=3 class=xl6429464 style='border-left:none'>unitName</td>\n" +
+ " <td colspan=3 class=xl6429464 style='border-left:none'>driverName</td>\n" +
+ " <td colspan=3 class=xl6429464 style='border-left:none'>plateNum</td>\n" +
+ " <td colspan=2 class=xl6429464 style='border-left:none'>姹借溅</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td rowspan=2 height=58 class=xl7029464 style='height:43.9pt;border-top:none'>淇℃伅</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>鍝佺</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>浜у湴</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>銆�</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td height=29 class=xl6429464 style='height:21.95pt;border-top:none;\n" +
+ " border-left:none'>foodVariety</td>\n" +
+ " <td class=xl6429464 style='border-top:none;border-left:none'>foodLocation</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>銆�</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>銆�</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td height=29 class=xl7029464 style='height:21.95pt;border-top:none'>鍏ヤ粨</td>\n" +
+ " <td class=xl6329464 style='border-top:none;border-left:none'>鍏ョ伯浠撳彿</td>\n" +
+ " <td colspan=2 class=xl6429464 style='border-left:none'>depotName</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>鍏ヤ粨寮�濮嬫椂闂�</td>\n" +
+ " <td colspan=2 class=xl6429464 style='border-left:none'>handleStart</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>鍏ヤ粨缁撴潫鏃堕棿</td>\n" +
+ " <td colspan=2 class=xl6429464 style='border-left:none'>handleEnd</td>\n" +
+ " <td class=xl6529464 style='border-top:none;border-left:none'>淇濈浜哄憳</td>\n" +
+ " <td colspan=2 class=xl6429464 style='border-left:none'>keeperName</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td rowspan=2 height=58 class=xl7029464 style='height:43.9pt;border-top:none'>妫�鏂�</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>姣涢噸</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>鐨噸</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>鍑�閲�</td>\n" +
+ " <td colspan=3 class=xl6329464 style='border-left:none'>鎬绘墸閲�</td>\n" +
+ " <td colspan=3 class=xl6329464 style='border-left:none'>缁撶畻閲嶉噺</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>绉伴噸浜哄憳</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td colspan=2 height=29 class=xl7129464 style='height:21.95pt;border-left:\n" +
+ " none'>fullWeight</td>\n" +
+ " <td colspan=2 class=xl7129464 style='border-left:none'>emptyWeight</td>\n" +
+ " <td colspan=2 class=xl7129464 style='border-left:none'>netWeight</td>\n" +
+ " <td colspan=3 class=xl7129464 style='border-left:none'>deSum</td>\n" +
+ " <td colspan=3 class=xl7129464 style='border-left:none'>settleWeight</td>\n" +
+ " <td colspan=2 class=xl6429464 style='border-left:none'>weightUser</td>\n" +
+ " </tr>\n" +
+ " <tr height=29 style='mso-height-source:userset;height:21.95pt'>\n" +
+ " <td height=29 class=xl7029464 style='height:21.95pt;border-top:none'>澶囨敞</td>\n" +
+ " <td colspan=8 class=xl6329464 style='border-left:none'>銆�</td>\n" +
+ " <td colspan=2 class=xl6329464 style='border-left:none'>瀹㈡埛绛惧瓧</td>\n" +
+ " <td colspan=4 class=xl6329464 style='border-left:none'>銆�</td>\n" +
+ " </tr>\n" +
+ " <![if supportMisalignedColumns]>\n" +
+ " <tr height=0 style='display:none'>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " <td width=45 style='width:34pt'></td>\n" +
+ " </tr>\n" +
+ " <![endif]>\n" +
+ "</table>\n" +
+ "\n" +
+ "</div>\n" +
+ "\n" +
+ "\n" +
+ "<!----------------------------->\n" +
+ "<!--鈥滀粠 EXCEL 鍙戝竷缃戦〉鈥濆悜瀵肩粨鏉�-->\n" +
+ "<!----------------------------->\n" +
+ "</body>\n" +
+ "\n" +
+ "</html>\n";
}
diff --git a/igds-inout/src/main/java/com/ld/igds/inout/dto/WeightBill.java b/igds-inout/src/main/java/com/ld/igds/inout/dto/WeightBill.java
index 44b2f13..36894db 100644
--- a/igds-inout/src/main/java/com/ld/igds/inout/dto/WeightBill.java
+++ b/igds-inout/src/main/java/com/ld/igds/inout/dto/WeightBill.java
@@ -39,6 +39,9 @@
private String unitName = "";
private String deptId = "";
+ private String weightUser = "";//绉伴噸浜�
+
+ private String keeperUser = "";//淇濈鍛�
//鎵胯繍浜�
private String driverName = "";
private String userId = "";
diff --git a/igds-inout/src/main/java/com/ld/igds/inout/manager/InoutReportManager.java b/igds-inout/src/main/java/com/ld/igds/inout/manager/InoutReportManager.java
index 9023442..1eadec8 100644
--- a/igds-inout/src/main/java/com/ld/igds/inout/manager/InoutReportManager.java
+++ b/igds-inout/src/main/java/com/ld/igds/inout/manager/InoutReportManager.java
@@ -84,6 +84,14 @@
if ("5322".equals(data.getCompanyId())) {
htmlStr = InoutBill.IN_WEIGHT_5322;
}
+ // 鐪夊北甯傚簱浣跨敤
+ if ("5005".equals(data.getCompanyId())) {
+ htmlStr = InoutBill.IN_WEIGHT_5005;
+ }
+ // 涓规１搴撲娇鐢�
+ if ("5012".equals(data.getCompanyId())) {
+ htmlStr = InoutBill.IN_WEIGHT_5012;
+ }
htmlStr = htmlStr.replace("billTitle", bill.getBillTitle());
@@ -104,6 +112,7 @@
htmlStr = htmlStr.replace("foodVariety", bill.getFoodVariety());
htmlStr = htmlStr.replace("depotName", bill.getDepotName());
htmlStr = htmlStr.replace("foodLocation", bill.getFoodLocation());
+
htmlStr = htmlStr.replace("plateNum", bill.getPlateNum());
htmlStr = htmlStr.replace("fullWeight",
@@ -135,8 +144,12 @@
htmlStr = htmlStr.replace("remark", bill.getRemark());
htmlStr = htmlStr.replace("moneyName", bill.getMoneyName());
- htmlStr = htmlStr.replace("handleUser", bill.getHandleUser());
-
+ htmlStr = htmlStr.replaceAll("weightUser",
+ bill.getWeightUser() == null ? "" : bill.getWeightUser());
+ htmlStr = htmlStr.replaceAll("handleUser",
+ bill.getHandleUser() == null ? "" : bill.getHandleUser());
+ htmlStr = htmlStr.replaceAll("keeperName",
+ bill.getKeeperUser() == null ? "" : bill.getKeeperUser());
return htmlStr;
}
@@ -182,7 +195,14 @@
if ("5322".equals(data.getCompanyId())) {
htmlStr = InoutBill.OUT_WEIGHT_5322;
}
-
+ // 鐪夊北甯傚簱浣跨敤
+ if ("5005".equals(data.getCompanyId())) {
+ htmlStr = InoutBill.OUT_WEIGHT_5005;
+ }
+ // 涓规１搴撲娇鐢�
+ if ("5012".equals(data.getCompanyId())) {
+ htmlStr = InoutBill.OUT_WEIGHT_5012;
+ }
htmlStr = htmlStr.replace("billTitle", bill.getBillTitle());
htmlStr = htmlStr.replace("registerTime", bill.getRegisterTime());
@@ -224,6 +244,12 @@
htmlStr = htmlStr.replace("wet", bill.getWet() + "");
htmlStr = htmlStr.replace("impurity", bill.getImpurity() + "");
+ htmlStr = htmlStr.replaceAll("weightUser",
+ bill.getWeightUser() == null ? "" : bill.getWeightUser());
+ htmlStr = htmlStr.replaceAll("handleUser",
+ bill.getHandleUser() == null ? "" : bill.getHandleUser());
+ htmlStr = htmlStr.replaceAll("keeperName",
+ bill.getKeeperUser() == null ? "" : bill.getKeeperUser());
return htmlStr;
}
@@ -322,6 +348,15 @@
bill.setSettleMoney(data.getSettleMoney() == null ? "" : data.getSettleMoney() + "");
bill.setRemark(data.getRemarks() == null ? "" : data.getRemarks());
+
+ if(InoutConstant.TYPE_IN.equals(data.getType())){
+ bill.setWeightUser(data.getFullWeightUser());
+ }
+ if(InoutConstant.TYPE_OUT.equals(data.getType())){
+ bill.setWeightUser(data.getEmptyWeightUser());
+ }
+ bill.setHandleUser(data.getHandleUser());
+ bill.setKeeperUser(depot.getStoreKeeperName());
return bill;
}
diff --git a/igds-web/src/main/resources/application-pro5012.yml b/igds-web/src/main/resources/application-pro5012.yml
new file mode 100644
index 0000000..c8ada6e
--- /dev/null
+++ b/igds-web/src/main/resources/application-pro5012.yml
@@ -0,0 +1,81 @@
+########################## 骞夸笢楂樺窞-閭︽捣鏅鸿兘 ##########################
+server:
+ port: 9999
+ context-path: /
+ connection-timeout: 5000
+ tomcat:
+ uri-encoding: UTF-8
+
+########################## datasourcec ##########################
+spring:
+ datasource:
+ db-base:
+ name: db-base
+ type: com.alibaba.druid.pool.DruidDataSource
+ url: jdbc:mysql://127.0.0.1:3306/igds_v4?useUnicode=true&characterEncoding=utf-8
+ driver-class-name: com.mysql.jdbc.Driver
+ username: root
+ password: ukJp12Qf+elyBvGHkJ5MQMa95pfVm0oFBHefdEgDFKoFSjbgYa9PYfv5vlem5nvoXjQsP9tIIo53DvSbsl160Q==
+ public-key:
+ config-decrypt: true
+ initial-size: 5
+ min-idle: 5
+ max-active: 50
+ max-wait: 60000
+ time-between-eviction-runs-millis: 60000
+ min-evictable-idle-time-millis: 300000
+ validation-query: select 1 from dual
+ test-whileIdle: true
+ test-on-borrow: false
+ test-on-return: false
+ pool-prepared-statements: true
+ max-pool-prepared-statement-per-connection-size: 20
+ filters: stat
+ connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
+ use-global-data-source-stat: true
+ removeAbandoned: true
+ removeAbandonedTimeout: 90
+ logAbandoned: true
+ poolPreparedStatements: true
+ maxPoolPreparedStatementPerConnectionSize: 20
+ db-sqlite:
+ name: db-sqlite
+ url: jdbc:sqlite:D:/app/igds/db/iot_cfg.db
+ driver-class-name: org.sqlite.JDBC
+ type: com.alibaba.druid.pool.DruidDataSource
+ username:
+ password:
+
+ # Redis鐩稿叧閰嶇疆
+ redis:
+ database: 0
+ host: 127.0.0.1
+ port: 6379
+ password:
+ # 杩炴帴姹犳渶澶ц繛鎺ユ暟锛堜娇鐢ㄨ礋鍊艰〃绀烘病鏈夐檺鍒讹級
+ pool:
+ max-active: 200
+ max-wait: -1
+ max-idle: 10
+ min-idle: 0
+ timeout: 6000
+
+#License 閰嶇疆绀轰緥
+license:
+ subject: ld_license
+ publicAlias: publicCert
+ storePass: PUBLICFZZYXXJSGFYXGS888888
+ licensePath: D:/license/license.lic
+ publicKeysStorePath: D:/license/publicCerts.keystore
+
+########################## IGDS ##########################
+## 绯荤粺鎺ュ彛璺敱閰嶇疆 娉ㄦ剰鏁板瓧濡傛灉浠�0寮�澶寸殑璇濓紝鍚庡彴浼氬嚭鐜拌浆涔夛紝璇锋坊鍔�""
+igds:
+ default:
+ companyId: 5012
+ sys-name: 鏅烘収绮簱绠＄悊绯荤粺
+ logo: logo-default.png
+ logo-title: logo-title-default.png
+ support: 椋庢鑷磋繙淇℃伅鎶�鏈偂浠芥湁闄愬叕鍙�
+ grian-add-point: N
+ file-path: D:/IGDS/FILE/
\ No newline at end of file
diff --git a/igds-web/src/main/resources/application.yml b/igds-web/src/main/resources/application.yml
index 31a4c91..d4fc45c 100644
--- a/igds-web/src/main/resources/application.yml
+++ b/igds-web/src/main/resources/application.yml
@@ -1,7 +1,7 @@
-########################## Server ##########################
+########################## Server ########################## 涓规１鍩庡叧鐪佺伯椋熷偍澶囧簱
spring:
profiles:
- active: dev
+ active: pro5012
application:
name: igds
main:
diff --git a/igds-web/src/main/resources/static/img/aerial-5012_001.png b/igds-web/src/main/resources/static/img/aerial-5012_001.png
new file mode 100644
index 0000000..559140e
--- /dev/null
+++ b/igds-web/src/main/resources/static/img/aerial-5012_001.png
Binary files differ
diff --git a/igds-web/src/main/resources/static/img/logo-5005.png b/igds-web/src/main/resources/static/img/logo-5005.png
index 1b2f138..6cf1ef9 100644
--- a/igds-web/src/main/resources/static/img/logo-5005.png
+++ b/igds-web/src/main/resources/static/img/logo-5005.png
Binary files differ
diff --git a/igds-web/src/main/resources/static/img/logo-5012.png b/igds-web/src/main/resources/static/img/logo-5012.png
index e2268f2..6cf1ef9 100644
--- a/igds-web/src/main/resources/static/img/logo-5012.png
+++ b/igds-web/src/main/resources/static/img/logo-5012.png
Binary files differ
diff --git a/igds-web/src/main/resources/static/img/logo-title-5012.png b/igds-web/src/main/resources/static/img/logo-title-5012.png
new file mode 100644
index 0000000..8aae54a
--- /dev/null
+++ b/igds-web/src/main/resources/static/img/logo-title-5012.png
Binary files differ
--
Gitblit v1.9.3