48343d2f673bdc210858b73b3f3ccbae64f57730.svn-base 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <?xml-stylesheet href="../../css/body.css" type="text/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>公司非计划品率及命中率统计报表</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <datagrid1/>
  10. <time/>
  11. </root>
  12. </instance>
  13. <script type="javascript" ev:event="xforms-ready">
  14. <![CDATA[
  15. if(window.parent==null) Init();
  16. var d, s = "";
  17. d = new Date();
  18. s += d.getYear()+ "年";
  19. s += (d.getMonth() +1) + "月";
  20. s += d.getDate() + "日";
  21. caption10.text=s;
  22. ]]>
  23. </script>
  24. </model>
  25. <script type="javascript" src="../../js/boaCommon.js"/>
  26. <script type="javascript" src="../../js/b01.js"/>
  27. <script type="javascript" src="../../js/mesCommon.js">
  28. <![CDATA[
  29. function Init(node)
  30. {
  31. find();
  32. }
  33. function excelExport() {
  34. return datagrid1;
  35. }
  36. function find()
  37. {
  38. model.removenode("/root/reqData");
  39. model.makeValue("/root/reqData/Time" , input1.value);
  40. commSubmit("UIG070030-service", "find", "glueAction.do");
  41. model.copyNode("/root/datagrid1" , "/root/resData/NoPlaned_VO");
  42. model.refresh();
  43. tongji();
  44. }
  45. function tongji()
  46. {
  47. datagrid1.rebuildStyle();
  48. datagrid1.rebuild();
  49. datagrid1.subtotalposition = "below";
  50. datagrid1.subtotal("sum",-1, datagrid1.colRef("DPL"), "#,###", "background-color:#99ff99", 0, "合计");
  51. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHXSL_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  52. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHXSL_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  53. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHKCL_XY90"), "#,###", "background-color:#99ff99", 0, "合计");
  54. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHKCL_DY90"), "#,###", "background-color:#99ff99", 0, "合计");
  55. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHKCL_HJ"), "#,###", "background-color:#99ff99", 0, "合计");
  56. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHBJKCL_XY90"), "#,###", "background-color:#99ff99", 0, "合计");
  57. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHBJKCL_DY90"), "#,###", "background-color:#99ff99", 0, "合计");
  58. datagrid1.subtotal("sum",-1, datagrid1.colRef("JHPKCL"), "#,###", "background-color:#99ff99", 0, "合计");
  59. datagrid1.subtotal("sum",-1, datagrid1.colRef("CPKCL"), "#,###", "background-color:#99ff99", 0, "合计");
  60. datagrid1.subtotal("sum",-1, datagrid1.colRef("YLKC"), "#,###", "background-color:#99ff99", 0, "合计");
  61. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHPLZX_DQ"), "#,###", "background-color:#99ff99", 0, "合计");
  62. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHPLZX_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  63. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHPLZX_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  64. datagrid1.subtotal("sum",-1, datagrid1.colRef("MZLZX_DQ"), "#,###", "background-color:#99ff99", 0, "合计");
  65. datagrid1.subtotal("sum",-1, datagrid1.colRef("MZLZX_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  66. datagrid1.subtotal("sum",-1, datagrid1.colRef("MZLZX_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  67. datagrid1.subtotal("sum",-1, datagrid1.colRef("RKLMX_DQ"), "#,###", "background-color:#99ff99", 0, "合计");
  68. datagrid1.subtotal("sum",-1, datagrid1.colRef("RKLMX_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  69. datagrid1.subtotal("sum",-1, datagrid1.colRef("RKLMX_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  70. }
  71. ]]>
  72. </script>
  73. </xhtml:head>
  74. <xhtml:body pagewidth="980" pageheight="620" guideline="1,307;1,113;">
  75. <datagrid id="datagrid1" nodeset="/root/datagrid1/NoPlaned_Row" caption="产线^考核指标(年累)^考核指标(年累)^非计划品率%^非计划品率%^非计划品率%^命中率%^命中率%^命中率%^待判量^非计划品销售量^非计划品销售量^非计划品库存量^非计划品库存量^非计划品库存量^非计划品库存量^非计划品库存量^计划品库存^成品库存合计^板坯库存^铸机^铸机^铸机^铸机^非计划品量(子项)^非计划品量(子项)^非计划品量(子项)^不命中量(子项)^不命中量(子项)^不命中量(子项)^钢材入库量(母项)^钢材入库量(母项)^钢材入库量(母项)|产线^非计划品率^命中率^当期^月累^年累^当期^月累^年累^待判量^月累^年累^库龄&lt;=90天^库龄&gt;90天^合计^其中板加库龄&lt;=90天^其中板加库龄&gt;90天^计划品库存^成品库存合计^板坯库存^铸机1^铸机2^铸机3^铸机4^当前^月累^年累^当前^月累^年累^当前^月累^年累|产线^非计划品率^命中率^当期^月累^年累^当期^月累^年累^待判量^月累^年累^库龄&lt;=90天^库龄&gt;90天^合计^其中板加库龄&lt;=90天^其中板加库龄&gt;90天^计划品库存^成品库存合计^板坯库存^铸机1^铸机2^铸机3^铸机4^当前^月累^年累^当前^月累^年累^当前^月累^年累" colsep="^" colwidth="45, 67, 45, 45, 45, 45, 45, 45, 55, 65, 45, 55, 80, 80, 50, 80, 80, 70, 50, 60, 45, 45, 45, 45, 45, 45, 50, 45, 45, 50, 60, 70, 85" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:40px; width:975px; height:275px; ">
  76. <col ref="CX"/>
  77. <col ref="GSKHFJHPL"/>
  78. <col ref="GSKHMZL"/>
  79. <col ref="FJHPL_DQ"/>
  80. <col ref="FJHPL_YL"/>
  81. <col ref="FJHPL_NL"/>
  82. <col ref="MZL_DQ"/>
  83. <col ref="MZL_YL"/>
  84. <col ref="MZL_NL"/>
  85. <col ref="DPL"/>
  86. <col ref="FJHXSL_YL"/>
  87. <col ref="FJHXSL_NL"/>
  88. <col ref="FJHKCL_XY90"/>
  89. <col ref="FJHKCL_DY90"/>
  90. <col ref="FJHKCL_HJ"/>
  91. <col ref="FJHBJKCL_XY90"/>
  92. <col ref="FJHBJKCL_DY90"/>
  93. <col ref="JHPKCL"/>
  94. <col ref="CPKCL"/>
  95. <col ref="YLKC"/>
  96. <col ref="GPKCL_1"/>
  97. <col ref="GPKCL_2"/>
  98. <col ref="GPKCL_3"/>
  99. <col ref="GPKCL_4"/>
  100. <col ref="FJHPLZX_DQ"/>
  101. <col ref="FJHPLZX_YL"/>
  102. <col ref="FJHPLZX_NL"/>
  103. <col ref="MZLZX_DQ"/>
  104. <col ref="MZLZX_YL"/>
  105. <col ref="MZLZX_NL"/>
  106. <col ref="RKLMX_DQ"/>
  107. <col ref="RKLMX_YL"/>
  108. <col ref="RKLMX_NL"/>
  109. </datagrid>
  110. <caption id="caption1" style="left:830px; top:15px; width:100px; height:20px; ">计量单位: 吨</caption>
  111. <caption id="caption2" style="left:15px; top:335px; width:100px; height:20px; ">说明:</caption>
  112. <caption id="caption3" style="left:25px; top:360px; width:379px; height:20px; ">1、统计期:当期为上一工作日00:00:00到23:59:59的数据。</caption>
  113. <caption id="caption4" style="left:25px; top:385px; width:415px; height:20px; ">2、统计表生成时间:每日02:00</caption>
  114. <caption id="caption5" style="left:25px; top:410px; width:490px; height:20px; ">3、钢材入库量:指统计期内生产工艺完成可取样及判定的重量。</caption>
  115. <caption id="caption6" style="left:25px; top:435px; width:695px; height:20px; ">4、非计划品量:指统计期内本产线原因造成的非计划品量,含后道工序发现的但不含销售质量异议产生的。</caption>
  116. <caption id="caption7" style="left:25px; top:460px; width:590px; height:20px; ">5、非计划品库存量:指统计期内成品材含板加,连铸坯库存含各产线原料库的物料重量。</caption>
  117. <caption id="caption8" style="left:25px; top:485px; width:524px; height:20px; ">6、中厚板非计划品库存量已包含板加非计划品库存量。</caption>
  118. <caption id="caption9" style="left:13px; top:15px; width:100px; height:20px; vertical-align:middle; ">报表日期:</caption>
  119. <caption id="caption10" style="left:655px; top:15px; width:100px; height:20px; vertical-align:middle; "/>
  120. <caption id="caption11" style="left:25px; top:510px; width:355px; height:20px; ">7、非计划品销售量中含后道工序销售的本产线的原因非计划品。</caption>
  121. <caption id="caption12" style="left:25px; top:535px; width:536px; height:20px; ">8、表中非计划品率、一次命中率、非计划品量与不命中量的统计口径与公司绩效考核统计口径一致。</caption>
  122. <caption id="caption13" style="left:32px; top:560px; width:530px; height:20px; ">
  123. <![CDATA[其中的当期数据与公司绩效考核统计界面的实时计算的当期数据会有出入,但月累与年累数据一致。
  124. ]]>
  125. </caption>
  126. <input id="input1" ref="/root/time" inputtype="date" format="yyyy-mm-dd" style="left:75px; top:15px; width:90px; height:20px; ">
  127. <script type="javascript" ev:event="xforms-value-changed">
  128. <![CDATA[
  129. find();
  130. ]]>
  131. </script>
  132. </input>
  133. <caption id="caption14" style="left:590px; top:15px; width:100px; height:20px; ">当前时间:</caption>
  134. </xhtml:body>
  135. </xhtml:html>