a79671a6986918fb9a219083181277f097053f6f.svn-base 7.8 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>Untitle</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <searchData>
  10. <P_SMS_YARD_EXT_DTIME/>
  11. </searchData>
  12. <grid/>
  13. <infoData>统计口径:</infoData>
  14. </root>
  15. </instance>
  16. <script type="javascript" ev:event="xforms-ready">
  17. <![CDATA[
  18. find();
  19. ]]>
  20. </script>
  21. </model>
  22. <script type="javascript" src="../../js/boaMsg.js"/>
  23. <script type="javascript" src="../../js/boaCommon.js"/>
  24. <script type="javascript" src="../../js/bCommon.js"/>
  25. <script type="javascript" src="../../js/dCommon.js"/>
  26. <script type="javascript" src="../../js/F.js"/>
  27. <script type="javascript" src="../../js/G02.js"/>
  28. <script type="javascript">
  29. <![CDATA[
  30. function excelExport(){
  31. return datagrid1;
  32. }
  33. function saveExcelScript(){
  34. if(datagrid1.rows<=3){
  35. window.alert("无数据源,请先查询.", "提示");
  36. return;
  37. }
  38. window.load("../../G/G10/_out.xrw", "modal", "", "left:350; top:240; width:400; height:220; sysmenu:visible; min:visible; max:true; resize:true; caption:visible;");
  39. var jsonMerges="[{'name':'y','x':0,'y':0,'cnt':3},{'name':'x','x':1,'y':0,'cnt':4},{'name':'x','x':1,'y':1,'cnt':2},{'name':'x','x':3,'y':1,'cnt':2},{'name':'y','x':5,'y':0,'cnt':4},{'name':'x','x':6,'y':0,'cnt':4},{'name':'x','x':6,'y':1,'cnt':2},{'name':'x','x':8,'y':1,'cnt':2},{'name':'x','x':10,'y':0,'cnt':16},{'name':'x','x':10,'y':1,'cnt':8},{'name':'x','x':18,'y':1,'cnt':8},{'name':'x','x':26,'y':0,'cnt':10},{'name':'x','x':31,'y':1,'cnt':5},{'name':'x','x':36,'y':1,'cnt':5},{'name':'y','x':37,'y':0,'cnt':3}]";
  40. var colRef = getVoColrefs("/root/resData/rs1_VO");
  41. var list = parseVoToStr("/root/resData/rs1_VO");//数据集
  42. commonOuterExcel('UIG070020',datagrid1.caption,colRef,list,'UIH090060-service',jsonMerges,input_outType.value);
  43. }
  44. function find(){
  45. // if(model.getValue("/root/searchData/P_SMS_YARD_EXT_DTIME") == null || model.getValue("/root/searchData/P_SMS_YARD_EXT_DTIME") == "" ){
  46. // var curDate = CurentDate();
  47. // model.setValue("/root/searchData/P_SMS_YARD_EXT_DTIME",curDate);
  48. // }
  49. commSendReq("/root/searchData");
  50. commSubmit("UIG070020-service","find","glueAction.do");
  51. model.refresh();
  52. }
  53. ]]>
  54. </script>
  55. </xhtml:head>
  56. <xhtml:body>
  57. <input id="input_outType" visibility="hidden" style="left:0px; top:10px; width:100px; height:20px; "/>
  58. <datagrid id="datagrid1" nodeset="/root/resData/rs1_VO/rs1_Row" caption="产线^正式订单量^正式订单量^正式订单量^正式订单量^手持订单量(t)^完成交货量^完成交货量^完成交货量^完成交货量^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^交货期内完成订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^超交货期订单天数分布^合同周期兑现率(%)|产线^合同个数^合同个数^合同重量(t)^合同重量(t)^手持订单量(t)^合同个数^合同个数^合同重量(t)^合同重量(t)^合同个数^合同个数^合同个数^合同个数^合同个数^合同个数^合同个数^合同个数^合同重量(t)^合同重量(t)^合同重量(t)^合同重量(t)^合同重量(t)^合同重量(t)^合同重量(t)^合同重量(t)^合同个数^合同个数^合同个数^合同个数^合同个数^合同重量(t)^合同重量(t)^合同重量(t)^合同重量(t)^合同重量(t)^合同周期兑现率(%)|产线^当日^月累^当日^月累^手持订单量(t)^当日^月累^当日^月累^&lt;5天^5 ~10天^10 ~15天^15 ~20天^20~25天^25~30天^30天&lt;^合计^&lt;5天^5 ~10天^10 ~15天^15~20天^20~25天^25~30天^30天&lt;^合计^&lt;3天^3~10天^10~20天^20天&lt;^合计^&lt;3天^3~10天^10~20天^20天&lt;^合计^合同周期兑现率(%)|产线^当日^月累^当日^月累^手持订单量(t)^当日^月累^当日^月累^&lt;5天^5 ~10天^10 ~15天^15 ~20天^20~25天^25~30天^30天&lt;^合计^&lt;5天^5 ~10天^10 ~15天^15~20天^20~25天^25~30天^30天&lt;^合计^&lt;3天^3~10天^10~20天^20天&lt;^合计^&lt;3天^3~10天^10~20天^20天&lt;^合计^合同周期兑现率(%)" colsep="^" colwidth="40, 31, 34, 47, 58, 72, 33, 38, 50, 51, 47, 67, 72, 77, 62, 60, 51, 35, 44, 64, 73, 60, 56, 63, 46, 44, 54, 62, 56, 51, 32, 48, 59, 59, 63, 37, 44" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:5px; width:960px; height:305px; ">
  59. <col ref="CX"/>
  60. <col ref="ZSHT_GS"/>
  61. <col ref="ZSHT_GS_MON"/>
  62. <col ref="ZSHT_ZL" format="#,###" style="text-align:right; "/>
  63. <col ref="ZSHT_ZL_MON" format="#,###" style="text-align:right; "/>
  64. <col ref="SZDDL" format="#,###" style="text-align:right; "/>
  65. <col ref="WCJH_GS"/>
  66. <col ref="WCJH_GS_MON"/>
  67. <col ref="WCJH_ZL" format="#,###" style="text-align:right; "/>
  68. <col ref="WCJH_ZL_MON" format="#,###" style="text-align:right; "/>
  69. <col ref="JHQN_GS_15"/>
  70. <col ref="JHQN_GS_5_10"/>
  71. <col ref="JHQN_GS_10_15"/>
  72. <col ref="JHQN_GS_15_20"/>
  73. <col ref="JHQN_GS_20"/>
  74. <col ref="JHQN_GS_20_25"/>
  75. <col ref="JHQN_GS_30"/>
  76. <col ref="JHQN_COUNT"/>
  77. <col ref="JHQN_ZL_15" format="#,###" style="text-align:right; "/>
  78. <col ref="JHQN_ZL_5_10" format="#,###" style="text-align:right; "/>
  79. <col ref="JHQN_ZL_10_15" format="#,###" style="text-align:right; "/>
  80. <col ref="JHQN_ZL_15_20" format="#,###" style="text-align:right; "/>
  81. <col ref="JHQN_ZL_20" format="#,###" style="text-align:right; "/>
  82. <col ref="JHQN_ZL_20_25" format="#,###" style="text-align:right; "/>
  83. <col ref="JHQN_ZL_30" format="#,###" style="text-align:right; "/>
  84. <col ref="JHQN_ZL" format="#,###" style="text-align:right; "/>
  85. <col ref="JHQW_GS_3"/>
  86. <col ref="JHQW_GS_3_10"/>
  87. <col ref="JHQW_GS_10_20"/>
  88. <col ref="JHQW_GS_20"/>
  89. <col ref="JHQW_COUNT"/>
  90. <col ref="JHQW_ZL_3" format="#,###" style="text-align:right; "/>
  91. <col ref="JHQW_ZL_3_10" format="#,###" style="text-align:right; "/>
  92. <col ref="JHQW_ZL_10_20" format="#,###" style="text-align:right; "/>
  93. <col ref="JHQW_ZL_20" format="#,###" style="text-align:right; "/>
  94. <col ref="JHQW_ZL" format="#,###" style="text-align:right; "/>
  95. <col ref="HTDXL"/>
  96. </datagrid>
  97. <caption id="caption2" class="cell" style="left:0px; top:355px; width:90px; height:20px; ">统计口径解释:</caption>
  98. <caption id="caption1" class="cell" style="left:0px; top:380px; width:595px; height:20px; text-align:left; ">1.统计数据截至查询当天之前一天</caption>
  99. <caption id="caption20" class="cell" style="left:895px; top:380px; width:50px; height:20px; vertical-align:middle; border-color:#000000; ">Export</caption>
  100. <button id="button1" visibility="hidden" style="left:895px; top:380px; width:50px; height:20px; border-color:#000000; ">
  101. <caption>Export</caption>
  102. <script type="javascript" ev:event="onclick">
  103. <![CDATA[
  104. saveExcelScript();
  105. ]]>
  106. </script>
  107. </button>
  108. </xhtml:body>
  109. </xhtml:html>