UIG070060.xrw 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  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>
  6. <![CDATA[公司非计划攻关分项指标统计-周报表
  7. (UIG070060)]]>
  8. </xhtml:title>
  9. <model id="model1">
  10. <instance id="instance1">
  11. <root xmlns="">
  12. <datagrid1/>
  13. <time/>
  14. </root>
  15. </instance>
  16. <script type="javascript" ev:event="xforms-ready">
  17. <![CDATA[
  18. if(window.parent==null) Init();
  19. var d, s = "";
  20. d = new Date();
  21. s += d.getYear()+ "年";
  22. s += (d.getMonth() +1) + "月";
  23. s += d.getDate() + "日";
  24. caption10.text=s;
  25. ]]>
  26. </script>
  27. </model>
  28. <script type="javascript" src="../../js/boaCommon.js"/>
  29. <script type="javascript" src="../../js/b01.js"/>
  30. <script type="javascript" src="../../js/mesCommon.js">
  31. <![CDATA[
  32. function Init(node)
  33. {
  34. find();
  35. }
  36. function excelExport() {
  37. return datagrid1;
  38. }
  39. function find()
  40. {
  41. model.removenode("/root/reqData");
  42. model.makeValue("/root/reqData/Time" , input1.value);
  43. commSubmit("UIG070060-service", "find", "glueAction.do");
  44. model.copyNode("/root/datagrid1" , "/root/resData/NoPlaned_VO");
  45. model.refresh();
  46. //tongji();
  47. }
  48. function tongji()
  49. {
  50. datagrid1.rebuildStyle();
  51. datagrid1.rebuild();
  52. datagrid1.subtotalposition = "below";
  53. datagrid1.subtotal("sum",-1, datagrid1.colRef("DPL"), "#,###", "background-color:#99ff99", 0, "合计");
  54. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHXSL_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  55. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHXSL_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  56. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHKCL_XY90"), "#,###", "background-color:#99ff99", 0, "合计");
  57. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHKCL_DY90"), "#,###", "background-color:#99ff99", 0, "合计");
  58. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHKCL_HJ"), "#,###", "background-color:#99ff99", 0, "合计");
  59. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHBJKCL_XY90"), "#,###", "background-color:#99ff99", 0, "合计");
  60. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHBJKCL_DY90"), "#,###", "background-color:#99ff99", 0, "合计");
  61. datagrid1.subtotal("sum",-1, datagrid1.colRef("JHPKCL"), "#,###", "background-color:#99ff99", 0, "合计");
  62. datagrid1.subtotal("sum",-1, datagrid1.colRef("CPKCL"), "#,###", "background-color:#99ff99", 0, "合计");
  63. datagrid1.subtotal("sum",-1, datagrid1.colRef("YLKC"), "#,###", "background-color:#99ff99", 0, "合计");
  64. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHPLZX_DQ"), "#,###", "background-color:#99ff99", 0, "合计");
  65. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHPLZX_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  66. datagrid1.subtotal("sum",-1, datagrid1.colRef("FJHPLZX_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  67. datagrid1.subtotal("sum",-1, datagrid1.colRef("MZLZX_DQ"), "#,###", "background-color:#99ff99", 0, "合计");
  68. datagrid1.subtotal("sum",-1, datagrid1.colRef("MZLZX_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  69. datagrid1.subtotal("sum",-1, datagrid1.colRef("MZLZX_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  70. datagrid1.subtotal("sum",-1, datagrid1.colRef("RKLMX_DQ"), "#,###", "background-color:#99ff99", 0, "合计");
  71. datagrid1.subtotal("sum",-1, datagrid1.colRef("RKLMX_YL"), "#,###", "background-color:#99ff99", 0, "合计");
  72. datagrid1.subtotal("sum",-1, datagrid1.colRef("RKLMX_NL"), "#,###", "background-color:#99ff99", 0, "合计");
  73. }
  74. ]]>
  75. </script>
  76. </xhtml:head>
  77. <xhtml:body pagewidth="980" pageheight="620" guideline="1,290;1,138;">
  78. <datagrid id="datagrid1" nodeset="/root/datagrid1/NoPlaned_Row" caption="单位/产线^单位/产线^板、卷非计划^板、卷非计划^板、卷非计划^周统计^当月累计^当年累计^非计划量年累^入库量年累|单位/产线^单位/产线^现况率(含钢质)^攻关目标^攻关目标^周统计^当月累计^当年累计^非计划量年累^入库量年累|单位/产线^单位/产线^非计划率(含钢质%)^2014年非计划率(含钢质)%^2014年非计划率(含钢质)%^周统计^当月累计^当年累计^非计划量年累^入库量年累|单位/产线^单位/产线^非计划率(含钢质%)^一台阶(降30%)^二台阶(降50%)^周统计^当月累计^当年累计^非计划量年累^入库量年累" colsep="^" colwidth="74, 100, 119, 110, 110, 80, 80, 80, 100, 100" extendlastcol="false" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowsep="|" style="left:10px; top:40px; width:975px; height:450px; ">
  79. <col autonext="true" ref="SOURCEID"/>
  80. <col ref="CX"/>
  81. <col ref="FJH_GZL"/>
  82. <col ref="FJH_GZL_1"/>
  83. <col ref="FJH_GZL_2"/>
  84. <col ref="FJH_GZL_ZL"/>
  85. <col ref="FJH_GZL_YL"/>
  86. <col ref="FJH_GZL_NL"/>
  87. <col ref="FJH_RL_NL"/>
  88. <col ref="WEIGHT"/>
  89. </datagrid>
  90. <caption id="caption1" style="left:830px; top:15px; width:100px; height:20px; ">计量单位: 吨</caption>
  91. <caption id="caption2" style="left:15px; top:520px; width:100px; height:20px; ">说明:</caption>
  92. <caption id="caption4" style="left:25px; top:540px; width:415px; height:20px; ">1、统计表生成时间:每周一02 :00</caption>
  93. <caption id="caption9" style="left:13px; top:15px; width:100px; height:20px; vertical-align:middle; ">报表日期:</caption>
  94. <caption id="caption10" style="left:655px; top:15px; width:100px; height:20px; vertical-align:middle; "/>
  95. <input id="input1" ref="/root/time" inputtype="date" format="yyyy-mm-dd" style="left:75px; top:15px; width:90px; height:20px; ">
  96. <script type="javascript" ev:event="xforms-value-changed">
  97. <![CDATA[
  98. find();
  99. ]]>
  100. </script>
  101. </input>
  102. <caption id="caption14" style="left:590px; top:15px; width:100px; height:20px; ">当前时间:</caption>
  103. <caption id="caption3" style="left:25px; top:565px; width:415px; height:20px; ">2、周统计:本周的前一周统计</caption>
  104. </xhtml:body>
  105. </xhtml:html>