UIG020500.xrw 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <?xml-stylesheet type="text/css" href="../../css/body.css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>
  6. <![CDATA[炼钢作业 >> 炼钢作业实绩 >> 日炼钢计划及执行情况查询(UIG020500)]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <formData>
  12. <fromDate/>
  13. <toDate/>
  14. <insFromDate/>
  15. <insToDate/>
  16. <ordNo/>
  17. <ordSeq/>
  18. <searchInfo>
  19. <ORD_NO/>
  20. </searchInfo>
  21. <FROM_DEL_TO_DATE/>
  22. <TO_DEL_TO_DATE/>
  23. </formData>
  24. <reqData/>
  25. <resData/>
  26. <grid1/>
  27. <combData/>
  28. </root>
  29. </instance>
  30. </model>
  31. <script type="javascript" src="../../js/boaCommon.js"/>
  32. <script type="javascript" src="../../js/G02.js"/>
  33. <script type="javascript" src="../../js/boaMsg.js"/>
  34. <script type="javascript" src="../../js/mesCommon.js"/>
  35. <script type="javascript">
  36. <![CDATA[
  37. /*
  38. function Init(node)
  39. {
  40. InitParams(node);
  41. input1.value = commCurDate()
  42. input2.value = commCurDate();
  43. }
  44. */
  45. function excelExport(){
  46. return datagrid1;
  47. }
  48. function getOrdSeq(){
  49. commSendReq("/root/formData");
  50. commSubmit("UIG04COMBOX-service","ordSeq","glueAction.do");
  51. model.copyNode("root/combData","root/resData");
  52. datagrid1.refresh();
  53. }
  54. function find(){
  55. if(commDiffDay(input1.value,input2.value)>10)
  56. {
  57. window.alert("查询时间不能超过10天");
  58. return;
  59. }
  60. if(commDiffDay(input3.value,input4.value)>10)
  61. {
  62. window.alert("查询时间不能超过10天");
  63. return;
  64. }
  65. if(commDiffDay(input5.value,input6.value)>10)
  66. {
  67. window.alert("查询时间不能超过10天");
  68. return;
  69. }
  70. datagrid1.rebuildStyle();
  71. if((model.getValue("/root/formData/fromDate") == null || model.getValue("/root/formData/fromDate") == ""
  72. || model.getValue("/root/formData/toDate") == null || model.getValue("/root/formData/toDate") == "")&&
  73. (model.getValue("/root/formData/insFromDate") == null || model.getValue("/root/formData/insFromDate") == ""
  74. || model.getValue("/root/formData/insToDate") == null || model.getValue("/root/formData/insToDate") == "")&&
  75. ((model.getValue("/root/formData/ordNo") == null || model.getValue("/root/formData/ordNo") == "")
  76. && (model.getValue("/root/formData/ordSeq") == null || model.getValue("/root/formData/ordSeq") == ""))){
  77. var curDate = CurentDate();
  78. model.setValue("/root/formData/toDate",curDate);
  79. model.setValue("/root/formData/fromDate",curDate);
  80. }
  81. commSendReq("/root/formData");
  82. commSubmit("UIG020500-service","find","glueAction.do");
  83. commAppendData("/root/grid1/UIG020500_ERSULT_VO","/root/resData/UIG020500_ERSULT_VO");
  84. datagrid1.refresh();
  85. var inscnt = 0;
  86. var inswgt = 0 ;
  87. var longinscnt = 0;
  88. var shrtinscnt = 0;
  89. var actcnt = 0 ;
  90. var actwgt = 0 ;
  91. var debtcnt = 0 ;
  92. var debtwgt = 0 ;
  93. var ordcnt = 0 ;
  94. var ordwgt = 0 ;
  95. var lkcnt = 0 ;
  96. var lkwgt = 0 ;
  97. var dpcnt = 0 ;
  98. var dpwgt = 0 ;
  99. var nonordcnt = 0 ;
  100. var nonordwgt = 0 ;
  101. var ratecnt = 0 ;
  102. var ratewgt = 0 ;
  103. var nordratecnt = 0;
  104. var nordratewgt = 0;
  105. datagrid1.fixedRows
  106. for(var i = datagrid1.fixedRows ;i < datagrid1.rows; i++){
  107. inscnt = inscnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("PLAN_SLAB_CNT")));
  108. longinscnt = longinscnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("LONG_PLAN_SLAB_CNT")));
  109. shrtinscnt = shrtinscnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("SHRT_PLAN_SLAB_CNT")));
  110. inswgt = inswgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("PLAN_SLAB_WGT")));
  111. actcnt = actcnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("SLAB_CNT")));
  112. actwgt = actwgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("SLAB_WGT")));
  113. debtcnt = debtcnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("DEBT_SLAB_CNT")));
  114. debtwgt = debtwgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("DEBT_SLAB_WGT")));
  115. ordcnt = ordcnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("ORD_SLAB_CNT")));
  116. ordwgt = ordwgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("ORD_SLAB_WGT")));
  117. lkcnt = lkcnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("ORD2_SLAB_CNT")));
  118. lkwgt = lkwgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("ORD2_SLAB_WGT")));
  119. dpcnt = dpcnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("DP_SLAB_CNT")));
  120. dpwgt = dpwgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("DP_SLAB_WGT")));
  121. nonordcnt = nonordcnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("NORD_SLAB_CNT")));
  122. nonordwgt = nonordwgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("NORD_SLAB_CWGT")));
  123. ratecnt = ratecnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("SLAB_CNT_RATE")));
  124. ratewgt = ratewgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("SLAB_WGT_RATE")));
  125. nordratecnt = nordratecnt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("NORD_SLAB_CNT_RATE")));
  126. nordratewgt = nordratewgt + parseFloat(datagrid1.valueMatrix(i,datagrid1.colRef("NORD_SLAB_WGT_RATE")));
  127. if(datagrid1.valueMatrix(i,datagrid1.colRef("NORD_SLAB_CNT")) != "0"){
  128. datagrid1.rowstyle(i, "data", "background-color") = "#FFF000";
  129. }
  130. }
  131. ratecnt = ratecnt/datagrid1.rows;
  132. ratewgt = ratewgt/datagrid1.rows;
  133. nordratecnt = nordratecnt/(datagrid1.rows - datagrid1.fixedRows);
  134. nordratewgt = nordratewgt/(datagrid1.rows - datagrid1.fixedRows);
  135. datagrid1.addRow();
  136. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("PLAN_SLAB_CNT")) = inscnt;
  137. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("LONG_PLAN_SLAB_CNT")) = longinscnt;
  138. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("SHRT_PLAN_SLAB_CNT")) = shrtinscnt;
  139. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("PLAN_SLAB_WGT")) = inswgt;
  140. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("SLAB_CNT")) = actcnt;
  141. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("SLAB_WGT")) = actwgt;
  142. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("DEBT_SLAB_CNT")) = debtcnt;
  143. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("DEBT_SLAB_WGT")) = debtwgt;
  144. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("ORD_SLAB_CNT")) = ordcnt;
  145. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("ORD_SLAB_WGT")) = ordwgt;
  146. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("ORD2_SLAB_CNT")) = lkcnt;
  147. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("ORD2_SLAB_WGT")) = lkwgt;
  148. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("DP_SLAB_CNT")) = dpcnt;
  149. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("DP_SLAB_WGT")) = dpwgt;
  150. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("NORD_SLAB_CNT")) = nonordcnt;
  151. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("NORD_SLAB_CWGT")) = nonordwgt;
  152. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("SLAB_CNT_RATE")) = ratecnt;
  153. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("SLAB_WGT_RATE")) = ratewgt;
  154. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("NORD_SLAB_CNT_RATE")) = nordratecnt;
  155. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("NORD_SLAB_WGT_RATE")) = nordratewgt;
  156. datagrid1.valueMatrix(datagrid1.rows - 1,datagrid1.colRef("CHARGE_START_DTIME")) = "合计";
  157. datagrid1.rowstyle(datagrid1.rows - 1, "data", "background-color") = "#FFF000";
  158. datagrid1.refresh();
  159. }
  160. ]]>
  161. </script>
  162. </xhtml:head>
  163. <xhtml:body>
  164. <datagrid id="datagrid1" nodeset="/root/grid1/UIG020500_ERSULT_VO/UIG020500_ERSULT_Row" caption="计划炼钢日期^炼钢完成日期^交货期^炉号^钢种^浇次号^合同号^溢短装^是否出口^规格^计划量^计划量^计划量^计划量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^冶炼量^非计划率(%)^非计划率(%)^完成率(%)^完成率(%)|计划炼钢日期^炼钢完成日期^交货期^炉号^钢种^浇次号^合同号^溢短装^是否出口^规格^计划量^计划量^计划量^计划量^实际生产量^实际生产量^订单合格量^订单合格量^订单欠量^订单欠量^历库量^历库量^待判量^待判量^非计划量^非计划量^非计划率(%)^非计划率(%)^完成率(%)^完成率(%)|计划炼钢日期^炼钢完成日期^交货期^炉号^钢种^浇次号^合同号^溢短装^是否出口^规格^块数^重量(t)^长坯(块)^短坯(块)^块数^重量(t)^块数^重量(t)^块数^重量(t)^块数^重量(t)^块数^重量(t)^块数^重量(t)^块数^重量^块数^重量" colsep="^" colwidth="70, 70, 100, 70, 70, 59, 100, 60, 53, 100, 50, 60, 50, 50, 50, 60, 50, 60, 60, 60, 60, 60, 50, 60, 50, 60, 60, 60, 50, 50" explorerbar="sortshow" frozencols="4" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:55px; width:980px; height:545px; ">
  165. <col editable="false" ref="CHARGE_START_DTIME" type="input" format="yyyy-mm-dd"/>
  166. <col editable="false" ref="CHARGE_END_DTIME" type="input" format="yyyy-mm-dd"/>
  167. <col editable="false" ref="DEL_TO_DATE" type="input" format="yyyy-mm-dd"/>
  168. <col editable="false" ref="CHARGE_NO" type="input"/>
  169. <col editable="false" ref="STL_GRD" type="input"/>
  170. <col editable="false" ref="CAST_NO" type="input"/>
  171. <col editable="false" ref="ORD_NOS" type="input"/>
  172. <col editable="false" ref="YDZ_WGT"/>
  173. <col editable="false" ref="RCVORD_CLF"/>
  174. <col editable="false" ref="SLAB_SIZE" type="input"/>
  175. <col editable="false" ref="PLAN_SLAB_CNT" type="input"/>
  176. <col editable="false" ref="PLAN_SLAB_WGT" type="input"/>
  177. <col editable="false" ref="LONG_PLAN_SLAB_CNT" type="input"/>
  178. <col editable="false" ref="SHRT_PLAN_SLAB_CNT" type="input"/>
  179. <col editable="false" ref="SLAB_CNT" type="input"/>
  180. <col editable="false" ref="SLAB_WGT" type="input"/>
  181. <col editable="false" ref="ORD_SLAB_CNT" type="input"/>
  182. <col editable="false" ref="ORD_SLAB_WGT" type="input"/>
  183. <col editable="false" ref="DEBT_SLAB_CNT" type="input"/>
  184. <col editable="false" ref="DEBT_SLAB_WGT" type="input"/>
  185. <col editable="false" ref="ORD2_SLAB_CNT" type="input"/>
  186. <col editable="false" ref="ORD2_SLAB_WGT" type="input"/>
  187. <col editable="false" ref="DP_SLAB_CNT" type="input"/>
  188. <col editable="false" ref="DP_SLAB_WGT" type="input"/>
  189. <col editable="false" ref="NORD_SLAB_CNT" type="input"/>
  190. <col editable="false" ref="NORD_SLAB_CWGT" type="input"/>
  191. <col ref="NORD_SLAB_CNT_RATE"/>
  192. <col ref="NORD_SLAB_WGT_RATE"/>
  193. <col editable="false" ref="SLAB_CNT_RATE" type="input"/>
  194. <col editable="false" ref="SLAB_WGT_RATE" type="input"/>
  195. </datagrid>
  196. <input id="input1" ref="/root/formData/fromDate" class="input" inputtype="date" style="left:360px; top:0px; width:95px; height:20px; ">
  197. <script type="javascript" ev:event="xforms-value-changed">
  198. <![CDATA[
  199. if(model.getValue("/root/formData/toDate") == null || model.getValue("/root/formData/toDate") == ""||
  200. model.getValue("/root/formData/fromDate") > model.getValue("/root/formData/toDate")){
  201. model.setValue("/root/formData/toDate",model.getValue("/root/formData/fromDate"));
  202. input2.refresh();
  203. }
  204. ]]>
  205. </script>
  206. </input>
  207. <input id="input2" ref="/root/formData/toDate" class="input" inputtype="date" style="left:460px; top:0px; width:95px; height:20px; ">
  208. <script type="javascript" ev:event="xforms-value-changed">
  209. <![CDATA[
  210. if(model.getValue("/root/formData/fromDate") == null || model.getValue("/root/formData/fromDate") == ""||
  211. model.getValue("/root/formData/fromDate") > model.getValue("/root/formData/toDate")){
  212. model.setValue("/root/formData/fromDate",model.getValue("/root/formData/toDate"));
  213. input1.refresh();
  214. }
  215. ]]>
  216. </script>
  217. </input>
  218. <line id="line1" style="x1:455px; y1:10px; x2:460px; y2:10px; "/>
  219. <caption id="caption11" class="cell" style="left:280px; top:0px; width:80px; height:20px; font-weight:bold; border-color:#000000; ">生 产 时 间</caption>
  220. <caption id="caption1" class="cell" style="left:0px; top:0px; width:80px; height:20px; font-weight:bold; border-color:#000000; ">计 划 时 间</caption>
  221. <line id="line2" style="x1:175px; y1:10px; x2:180px; y2:10px; "/>
  222. <input id="input3" ref="/root/formData/insFromDate" class="input" inputtype="date" style="left:80px; top:0px; width:95px; height:20px; ">
  223. <script type="javascript" ev:event="xforms-value-changed">
  224. <![CDATA[
  225. if(model.getValue("/root/formData/insToDate") == null || model.getValue("/root/formData/insToDate") == ""||
  226. model.getValue("/root/formData/insFromDate") > model.getValue("/root/formData/insToDate")){
  227. model.setValue("/root/formData/insToDate",model.getValue("/root/formData/insFromDate"));
  228. input4.refresh();
  229. }
  230. ]]>
  231. </script>
  232. </input>
  233. <input id="input4" ref="/root/formData/insToDate" class="input" inputtype="date" style="left:180px; top:0px; width:95px; height:20px; ">
  234. <script type="javascript" ev:event="xforms-value-changed">
  235. <![CDATA[
  236. if(model.getValue("/root/formData/insFromDate") == null || model.getValue("/root/formData/insFromDate") == ""||
  237. model.getValue("/root/formData/insFromDate") > model.getValue("/root/formData/insToDate")){
  238. model.setValue("/root/formData/insFromDate",model.getValue("/root/formData/insToDate"));
  239. input3.refresh();
  240. }
  241. ]]>
  242. </script>
  243. </input>
  244. <input id="input101" ref="/root/formData/ordNo" maxlength="12" style="left:80px; top:25px; width:80px; height:20px; ">
  245. <script type="javascript" ev:event="xforms-value-changed">
  246. <![CDATA[
  247. getOrdSeq();
  248. ]]>
  249. </script>
  250. </input>
  251. <select1 id="combo101" ref="/root/formData/ordSeq" appearance="minimal" editmode="search" style="left:162px; top:25px; width:45px; height:20px; ">
  252. <choices>
  253. <itemset nodeset="/root/combData/ORD_SEQ_SELECT_VO/ORD_SEQ_SELECT_Row">
  254. <label ref="ORD_SEQ"/>
  255. <value ref="ORD_SEQ"/>
  256. </itemset>
  257. </choices>
  258. <script type="javascript" ev:event="onclick">
  259. <![CDATA[
  260. if (model.getXPathValue("count(/root/combData/ORD_SEQ_SELECT_VO/ORD_SEQ_SELECT_Row)") == 0) {
  261. getOrdSeq();
  262. }
  263. ]]>
  264. </script>
  265. </select1>
  266. <caption id="caption101" class="cell" style="left:0px; top:25px; width:80px; height:20px; ">合同号</caption>
  267. <caption id="caption2" class="cell" style="left:560px; top:0px; width:80px; height:20px; font-weight:bold; border-color:#000000; ">交 货 期</caption>
  268. <line id="line3" style="x1:735px; y1:10px; x2:740px; y2:10px; "/>
  269. <input id="input5" ref="/root/formData/FROM_DEL_TO_DATE" class="input" inputtype="date" style="left:640px; top:0px; width:95px; height:20px; ">
  270. <script type="javascript" ev:event="xforms-value-changed">
  271. <![CDATA[
  272. if(model.getValue("/root/formData/toDate") == null || model.getValue("/root/formData/toDate") == ""||
  273. model.getValue("/root/formData/fromDate") > model.getValue("/root/formData/toDate")){
  274. model.setValue("/root/formData/toDate",model.getValue("/root/formData/fromDate"));
  275. input2.refresh();
  276. }
  277. ]]>
  278. </script>
  279. </input>
  280. <input id="input6" ref="/root/formData/TO_DEL_TO_DATE" class="input" inputtype="date" style="left:740px; top:0px; width:95px; height:20px; ">
  281. <script type="javascript" ev:event="xforms-value-changed">
  282. <![CDATA[
  283. if(model.getValue("/root/formData/fromDate") == null || model.getValue("/root/formData/fromDate") == ""||
  284. model.getValue("/root/formData/fromDate") > model.getValue("/root/formData/toDate")){
  285. model.setValue("/root/formData/fromDate",model.getValue("/root/formData/toDate"));
  286. input1.refresh();
  287. }
  288. ]]>
  289. </script>
  290. </input>
  291. </xhtml:body>
  292. </xhtml:html>