| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200 |
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8" />
- <meta name="keywords" content="dongke,mes,ibossmes">
- <meta name="description" content="制造企业生产过程执行管理系统">
- <meta name="author" content="xuwei">
- <title>东科软件</title>
- <script src="/plugins/xeasyui/xeasyui.min.js"></script>
- <link href="/plugins/xeasyui/toolbar.min.css" rel="stylesheet" />
- </head>
- <body class="easyui-layout">
- <!--上部工具条-->
- <div id="toolbarLayout" data-options="border:false,region:'north',title:'',iconCls:'icon-grid'">
- <div class="i-toolbar">
- <a href="javascript:void(0)" id="btnSearch" title="搜索" class="easyui-linkbutton" iconcls="icon-search" plain="true" toggle="true" onclick="tbSearch()">搜索</a>
- <a href="javascript:void(0)" id="btnExport" title="导出" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbExport()">导出</a>
- <!--<a href="javascript:void(0)" id="btnColumn" class="easyui-menubutton" data-options="menu:'#btnColumnMenu',iconCls:'icon-undo'">列显示</a>-->
- <!--<div id="btnColumnMenu" style="width:150px;" ></div>-->
- <a href="javascript:void(0)" id="btnReload" title="刷新" class="easyui-linkbutton" iconcls="icon-reload" plain="true" onclick="tbReload()">刷新</a>
-
- <a href="javascript:void(0)" id="btnHelp" title="帮助" class="easyui-linkbutton" iconcls="icon-help" plain="true" onclick="tbHelp()">帮助</a>
-
- <div id="tbSearchDiv" style="display:block;padding:10px;">
- <form id="ffMaster">
- <div>
- 开始日期:
- <input class="easyui-datetimebox" id="datebeginMaster" name="datebeginMaster" data-options="required:true,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
- 截止日期:
- <input class="easyui-datetimebox" id="dateendMaster" name="dateendMaster" data-options="required:true,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
- 高压标识:
- <input class="easyui-combobox" id="highFlagMaster" name="highFlagMaster" data-options="required:false,valueField:'value',textField:'text',
- data:[{'text': '普通', 'value': '0'}, {'text': '高压', 'value': '1'}]" style=" width: 120px; height: 32px;">
- 统计方式:
- <input class="easyui-combobox" id="totalMaster" name="totalMaster" data-options="required:true,value:'YYYY-MM-DD',valueField:'value',textField:'text',
- data:[{'text': '按日统计', 'value': 'YYYY-MM-DD'},{'text': '按月统计', 'value': 'YYYY-MM'}, {'text': '按年统计', 'value': 'YYYY'}]" style=" width: 120px; height: 32px;">
- 产品类别:
- <input class="easyui-combotree" id="goodstypecodeMaster" name="goodstypecodeMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getGoodsType',method:'get',panelHeight:'200px',editable:true" style="width:180px;height:32px;">
- 产品商标:
- <input class="easyui-combobox" id="LOGONAME" name="LOGONAME" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getLogoByGoods&select=1',method:'get',valueField:'ID',textField:'TEXT',panelHeight:'300px',multiple:true" style="width:165px;height:32px;">
- </div>
- <div style="padding-top:10px;">
- 产品编码:
- <input class="easyui-combobox" id="goodsMaster" name="goodsMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getGoods&select=1',method:'get',valueField:'GOODSID',textField:'GOODSCODE',panelHeight:'300px',editable:true,multiple:true" style="width:415px;height:32px;">
- 成型线号:
- <input class="easyui-combobox" id="groutinglineMaster" name="groutinglineMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getLine&select=1',method:'get',valueField:'GROUTINGLINEID',textField:'GROUTINGLINECODE',panelHeight:'300px',editable:true,multiple:true" style="width: 322px; height: 32px;">
- 成型工号:
- <input class="easyui-combobox" id="usercodeMaster" name="usercodeMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../rpt.ashx?m=getUser&select=1',method:'get',valueField:'USERCODE',textField:'USERCODE',panelHeight:'300px',editable:'true'" style="width:120px;height:32px;">
- 车间号:
- <input class="easyui-combobox" id="workshopcodeMaster" name="workshopcodeMaster" data-options="required:false,value:'0',valueField:'value',textField:'text',
- data:[{'value':'0','text':'全部'},{'value':'1','text':'一车间'},{'value':'2','text':'二车间'},{'value':'3','text':'三车间'}]" style=" width: 120px; height: 32px;">
- <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="tbSearchReset()">清空</a>
- <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
- </div>
- </form>
- </div>
- </div>
- </div>
- <!--中部-->
- <div id="tableLayout" data-options="border:false,region:'center',split:true,title:'',iconCls:'icon-grid'" title="East" style="width:700px;">
- <div id="tableTabs" class="easyui-tabs" data-options="border:false" style="width: 100%; height: 100%">
- <!--表格-->
- <div title="月度成品入库报表">
- <table class="easyui-datagrid"
- id="DataGrid"
- data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true,onDblClickRow: dgDblclickrow,rowStyler:rowStyle">
- <thead>
- </thead>
- </table>
- </div>
- </div>
- </div>
- <script type="text/javascript">
- function formatterUA(value, row, index) {
- return Math.round(value*10000) / 100 + '%';
- }
- $(document).ready(function () {
- var ctime = new Date();
- var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() +" 00:00:00";
- var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 23:59:59";
- $("#datebeginMaster").datetimebox("setValue", beginDate);
- $("#dateendMaster").datetimebox("setValue", endDate);
- //tbSearchSubmit();
- });
- //帮助事件
- function tbHelp() {
- $('#DataGrid0').datagridDialog({
- title: '帮助',
- width: 640,
- height: 480,
- url: 'rpt_help.html'
- });
- }
- //主表双击事件
- function dgDblclickrow(index, row) {
- }
- //清空条件
- function tbSearchReset() {
- $('#ffMaster').form('clear');
- var ctime = new Date();
- var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 00:00:00";
- var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 23:59:59";
- $("#datebeginMaster").datetimebox("setValue", beginDate);
- $("#dateendMaster").datetimebox("setValue", endDate);
- $('#workshopcodeMaster').selected('0');
- $('#totalMaster').selected('YYYY-MM-DD');
- }
- //搜索提交
- function tbSearchSubmit() {
- var line = $('#groutinglineMaster').val();
- var list = line.split(",");
- if (list != null && list.length > 0) {
- var newline = [];
- var i = 0;
- for (var i = 0; i < list.length; i++) {
- if (!isNaN(parseInt(list[i]))) {
- newline.push(list[i])
- }
- }
- $('#groutinglineMaster').combobox('setValues', newline);
- }
- var goods = $('#goodsMaster').val();
- var goodslist = goods.split(",");
- if (goodslist != null && goodslist.length > 0) {
- var newgoodslist = [];
- var i = 0;
- for (var i = 0; i < goodslist.length; i++) {
- if (!isNaN(parseInt(goodslist[i]))) {
- newgoodslist.push(goodslist[i])
- }
- }
- $('#goodsMaster').combobox('setValues', newgoodslist);
- }
-
- if ($('#ffMaster').form("validate")) {
- $('#DataGrid').datagridLoadRpt({
- title: '',
- idField: 'SID',
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=master',
- pageSize: 10,
- fixWidth: 140,
- mergeWidth: 140,
- splitChar: '_'
- });
- }
- }
- //导出
- function tbExport() {
- var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
- //加载表头
- var fields = $('#DataGrid').datagrid('getColumnFields');
- var headers = [];
- for (var i = 0; i < fields.length; i++) {
- headers.push(fields[i]);
- }
- $('#DataGrid').datagridExport({
- headers: headers,
- fileName: '导出数据(月度成品入库数据统计表).xls',
- workSheet: '导出数据(月度成品入库数据统计表)'
- });
- }
- //搜索按钮
- function tbSearch() {
- $('#tbSearchDiv').toggle();
- //$('#DataGridMaster').datagrid('resize');
- $('#toolbarLayout').panel('resize', { height: 'auto' });
- $('body').layout('resize');
- $('#tableTabs').tabs('resize');
- }
- //刷新
- function tbReload() {
- tbSearchSubmit();
- }
- function rowStyle(value, row, index) {
- if (row["产品名称"] == "总计" || row["产品名称"] == "合计【小件】" || row["产品名称"] == "合计【大件】") {
- return "background:red";
- }
- }
- </script>
- </body>
- </html>
|