| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113 |
- <?xml version="1.0" encoding="UTF-8"?>
- <?xml-stylesheet href="../../css/body.css" type="text/css" ?>
- <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">
- <xhtml:head>
- <xhtml:title>Untitle</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <searchData>
- <P_SMS_YARD_EXT_DTIME/>
- </searchData>
- <grid/>
- <infoData>统计口径:</infoData>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- find();
- ]]>
- </script>
- </model>
- <script type="javascript" src="../../js/boaMsg.js"/>
- <script type="javascript" src="../../js/boaCommon.js"/>
- <script type="javascript" src="../../js/bCommon.js"/>
- <script type="javascript" src="../../js/dCommon.js"/>
- <script type="javascript" src="../../js/F.js"/>
- <script type="javascript" src="../../js/G02.js"/>
- <script type="javascript">
- <![CDATA[
- function excelExport(){
- return datagrid1;
- }
-
- function saveExcelScript(){
- if(datagrid1.rows<=3){
- window.alert("无数据源,请先查询.", "提示");
- return;
- }
- 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;");
- 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}]";
- var colRef = getVoColrefs("/root/resData/rs1_VO");
- var list = parseVoToStr("/root/resData/rs1_VO");//数据集
- commonOuterExcel('UIG070020',datagrid1.caption,colRef,list,'UIH090060-service',jsonMerges,input_outType.value);
- }
-
- function find(){
- // if(model.getValue("/root/searchData/P_SMS_YARD_EXT_DTIME") == null || model.getValue("/root/searchData/P_SMS_YARD_EXT_DTIME") == "" ){
- // var curDate = CurentDate();
- // model.setValue("/root/searchData/P_SMS_YARD_EXT_DTIME",curDate);
- // }
-
- commSendReq("/root/searchData");
- commSubmit("UIG070020-service","find","glueAction.do");
- model.refresh();
- }
-
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body>
- <input id="input_outType" visibility="hidden" style="left:0px; top:10px; width:100px; height:20px; "/>
- <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)^当日^月累^当日^月累^<5天^5 ~10天^10 ~15天^15 ~20天^20~25天^25~30天^30天<^合计^<5天^5 ~10天^10 ~15天^15~20天^20~25天^25~30天^30天<^合计^<3天^3~10天^10~20天^20天<^合计^<3天^3~10天^10~20天^20天<^合计^合同周期兑现率(%)|产线^当日^月累^当日^月累^手持订单量(t)^当日^月累^当日^月累^<5天^5 ~10天^10 ~15天^15 ~20天^20~25天^25~30天^30天<^合计^<5天^5 ~10天^10 ~15天^15~20天^20~25天^25~30天^30天<^合计^<3天^3~10天^10~20天^20天<^合计^<3天^3~10天^10~20天^20天<^合计^合同周期兑现率(%)" 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; ">
- <col ref="CX"/>
- <col ref="ZSHT_GS"/>
- <col ref="ZSHT_GS_MON"/>
- <col ref="ZSHT_ZL" format="#,###" style="text-align:right; "/>
- <col ref="ZSHT_ZL_MON" format="#,###" style="text-align:right; "/>
- <col ref="SZDDL" format="#,###" style="text-align:right; "/>
- <col ref="WCJH_GS"/>
- <col ref="WCJH_GS_MON"/>
- <col ref="WCJH_ZL" format="#,###" style="text-align:right; "/>
- <col ref="WCJH_ZL_MON" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_GS_15"/>
- <col ref="JHQN_GS_5_10"/>
- <col ref="JHQN_GS_10_15"/>
- <col ref="JHQN_GS_15_20"/>
- <col ref="JHQN_GS_20"/>
- <col ref="JHQN_GS_20_25"/>
- <col ref="JHQN_GS_30"/>
- <col ref="JHQN_COUNT"/>
- <col ref="JHQN_ZL_15" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_ZL_5_10" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_ZL_10_15" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_ZL_15_20" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_ZL_20" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_ZL_20_25" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_ZL_30" format="#,###" style="text-align:right; "/>
- <col ref="JHQN_ZL" format="#,###" style="text-align:right; "/>
- <col ref="JHQW_GS_3"/>
- <col ref="JHQW_GS_3_10"/>
- <col ref="JHQW_GS_10_20"/>
- <col ref="JHQW_GS_20"/>
- <col ref="JHQW_COUNT"/>
- <col ref="JHQW_ZL_3" format="#,###" style="text-align:right; "/>
- <col ref="JHQW_ZL_3_10" format="#,###" style="text-align:right; "/>
- <col ref="JHQW_ZL_10_20" format="#,###" style="text-align:right; "/>
- <col ref="JHQW_ZL_20" format="#,###" style="text-align:right; "/>
- <col ref="JHQW_ZL" format="#,###" style="text-align:right; "/>
- <col ref="HTDXL"/>
- </datagrid>
- <caption id="caption2" class="cell" style="left:0px; top:355px; width:90px; height:20px; ">统计口径解释:</caption>
- <caption id="caption1" class="cell" style="left:0px; top:380px; width:595px; height:20px; text-align:left; ">1.统计数据截至查询当天之前一天</caption>
- <caption id="caption20" class="cell" style="left:895px; top:380px; width:50px; height:20px; vertical-align:middle; border-color:#000000; ">Export</caption>
- <button id="button1" visibility="hidden" style="left:895px; top:380px; width:50px; height:20px; border-color:#000000; ">
- <caption>Export</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- saveExcelScript();
- ]]>
- </script>
- </button>
- </xhtml:body>
- </xhtml:html>
|