| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403 |
- <!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>
- <link rel="shortcut icon" href="/img/logo.png" />
- <link rel="bookmark" href="/img/logo.png" />
- <link rel="stylesheet" type="text/css" href="/plugins/easyui/themes/dongke/easyui.css">
- <link rel="stylesheet" type="text/css" href="/plugins/easyui/themes/icon.css">
- <link rel="stylesheet" type="text/css" href="/plugins/xeasyui/xuwell.css">
- <script type="text/javascript" src="/plugins/easyui/jquery.min.js"></script>
- <script type="text/javascript" src="/plugins/easyui/jquery.easyui.min.js"></script>
- <script type="text/javascript" src="/plugins/easyui/locale/easyui-lang-zh_CN.js"></script>
- <script type="text/javascript" src="/plugins/xeasyui/xuwell.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 id="tb" style="overflow: hidden;" class="i-toolbar" data-options="border:false,region:'north',title:'',iconCls:'icon-grid',height:210">
- <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="btnReload" title="刷新" class="easyui-linkbutton" iconcls="icon-reload" plain="true" onclick="tbReload()">刷新</a>
- <div id="tbSearchDiv" style="display: block; padding: 10px;">
- <form id="ffMaster">
- <div>
- 产成品交接时间:
- <input class="easyui-datetimebox" id="datebeginMasterS" name="datebeginMasterS" data-options="required:false,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
- -
- <input class="easyui-datetimebox" id="datebeginMasterD" name="datebeginMasterD" data-options="required:false,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
- 注浆日期:
- <input class="easyui-datebox" id="datebeginMasterG" name="datebeginMasterG" data-options="required:false,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
- - <input class="easyui-datebox" id="dateendMasterG" name="dateendMasterG" data-options="required:false,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
- 车间:
- <input class="easyui-combobox" id="workshop" name="workshop" data-options="required:false,valueField:'value',textField:'text',editable:true,multiple:true,
- data:[{'text': '1车间', 'value': '1'},{'text': '2车间', 'value': '2'},{'text': '3车间', 'value': '3'}]"
- style=" width: 160px; height: 32px;">产品类型:
- <input class="easyui-combotree" id="goodstypecode" name="goodstypecode" data-options="required:false,prompt:'',tipPosition:'top',url:'../../list.ashx?m=getGoodsType',method:'get',panelHeight:'200px',editable:true" style="width: 160px; height: 32px;"></span>
- 产品条码/外箱码:<input class="easyui-textbox" id="barcode" name="barcode" data-options="required:false,prompt:'',tipPosition:'top',required:false" style="width: 120px; height: 32px;"></span>
- 组件条码:<input class="easyui-textbox" id="IDNRKONLYCODE" name="IDNRKONLYCODE" data-options="required:false,prompt:'',tipPosition:'top',required:false" style="width: 120px; height: 32px;"></span>
- <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="$('#ffMaster').form('clear')">清空</a>
- <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
- </div>
- </form>
- </div>
- </div>
- </div>
- <div data-options="border:false,region:'center',title:'',iconCls:'icon-grid'">
- <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,onDblClickCell: dgDblclickcelldetail">
- <thead>
- <tr>
- <th data-options="field:'注浆日期',title:'注浆日期',align:'center',sortable:false"></th>
- <th data-options="field:'交接时间',title:'交接时间',align:'center',sortable:false"></th>
- <th data-options="field:'车间',title:'车间',align:'center',sortable:false"></th>
- <th data-options="field:'产品类型',title:'产品类型',align:'center',sortable:false"></th>
- <th data-options="field:'产品型号',title:'产品型号',align:'center',sortable:false"></th>
- <th data-options="field:'产品名称',title:'产品名称',align:'center',sortable:false"></th>
- <th data-options="field:'产品条码',title:'产品条码',align:'center',sortable:false"></th>
- <th data-options="field:'产品外箱码',title:'产品外箱码',align:'center',sortable:false"></th>
- <th data-options="field:'生产入库单号',title:'生产入库单号',align:'center',sortable:false,styler:stylerSet"></th>
- <th data-options="field:'LOGIDLINK',title:'LOGIDLINK',align:'center',sortable:false,hidden:true"></th>
- </tr>
- </thead>
- </table>
- </div>
- <div title="产品跟踪表">
- <div class="easyui-layout" data-options="fit:true">
- <div data-options="border:false,region:'north',title:'',split:true,iconCls:'icon-grid'" style="width:100%; height: 110px">
- <table class="easyui-datagrid"
- id="PropertyGridDetail"
- data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
- <thead>
- <tr>
- <th data-options="field:'当前条码',title:'当前条码',align:'center',sortable:false"></th>
- <th data-options="field:'产品商标',title:'产品商标',align:'center',sortable:false"></th>
- <th data-options="field:'产品类别',title:'产品类别',align:'center',sortable:false"></th>
- <th data-options="field:'产品型号',title:'产品型号',align:'center',sortable:false"></th>
- <th data-options="field:'产品名称',title:'产品名称',align:'center',sortable:false"></th>
- <th data-options="field:'物料编码',title:'物料编码',align:'center',sortable:false"></th>
- <th data-options="field:'包装条码',title:'包装条码',align:'center',sortable:false"></th>
- <th data-options="field:'产品规格',title:'产品规格',align:'center',sortable:false"></th>
- <th data-options="field:'釉色类别',title:'釉色类别',align:'center',sortable:false"></th>
- <th data-options="field:'成型线编码',title:'成型线编码',align:'center',sortable:false"></th>
- <th data-options="field:'模具编号',title:'模具编号',align:'center',sortable:false"></th>
- <th data-options="field:'注浆次数',title:'注浆次数',align:'center',sortable:false"></th>
- <th data-options="field:'成型工号',title:'成型工号',align:'center',sortable:false"></th>
- <th data-options="field:'注浆日期',title:'注浆日期',align:'center',sortable:false,formatter:getdate"></th>
- <th data-options="field:'注浆批次',title:'注浆批次',align:'center',sortable:false"></th>
- <th data-options="field:'产品状态',title:'产品状态',align:'center',sortable:false"></th>
- <th data-options="field:'产品等级',title:'产品等级',align:'center',sortable:false"></th>
- <th data-options="field:'干补标识',title:'干补标识',align:'center',sortable:false"></th>
- <th data-options="field:'损坯标识',title:'损坯标识',align:'center',sortable:false"></th>
- <th data-options="field:'公坯标识',title:'公坯标识',align:'center',sortable:false"></th>
- <th data-options="field:'防伪码',title:'防伪码',align:'center',sortable:false"></th>
- <th data-options="field:'喷釉房号',title:'喷釉房号',align:'center',sortable:false"></th>
- </tr>
- </thead>
- </table>
- </div>
- <div title="产品信息表" data-options="border:false,region:'center',title:'',split:true,iconCls:'icon-grid'" style="width:100%; height: 100%">
- <!--表格-->
- <table class="easyui-datagrid"
- id="DataGridMaster"
- data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
- <thead>
- <tr>
- <!--<th data-options="field:'公司',title:'公司',align:'center',sortable:false"></th>-->
- <th data-options="field:'工厂',title:'工厂',align:'center',sortable:false"></th>
- <th data-options="field:'车间',title:'车间',align:'center',sortable:false"></th>
- <th data-options="field:'工作中心',title:'工作中心',align:'center',sortable:false"></th>
- <th data-options="field:'产线',title:'产线',align:'center',sortable:false"></th>
- <th data-options="field:'工序',title:'工序',align:'center',sortable:false"></th>
- <th data-options="field:'生产工号',title:'生产工号',align:'center',sortable:false"></th>
- <th data-options="field:'产品分级',title:'产品分级',align:'center',sortable:false"></th>
- <th data-options="field:'操作者',title:'操作者',align:'center',sortable:false"></th>
- <th data-options="field:'操作时间',title:'操作时间',align:'center',sortable:false"></th>
- </tr>
- </thead>
- </table>
- </div>
- </div>
- </div>
- <!--<div title="产品信息表">
- <table class="easyui-datagrid"
- id="PropertyGridDetail"
- data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
- </table>
- </div>-->
- <div title="物料信息表">
- <!--表格-->
- <table class="easyui-datagrid"
- id="DataGridMateriel"
- data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
- <thead><tr>
- <th data-options="field:'物料',title:'物料',align:'center',sortable:false"></th>
- <th data-options="field:'项目',title:'项目',align:'center',sortable:false"></th>
- <th data-options="field:'条目类别',title:'条目类别',align:'center',sortable:false"></th>
- <th data-options="field:'组件',title:'组件',align:'center',sortable:false"></th>
- <th data-options="field:'名称',title:'名称',align:'left',sortable:false"></th>
- <th data-options="field:'组件数量',title:'组件数量',align:'center',sortable:false"></th>
- <th data-options="field:'组件单位',title:'组件单位',align:'center',sortable:false"></th>
- <th data-options="field:'组件报废率',title:'组件报废率',align:'center',sortable:false"></th>
- <th data-options="field:'工序报废率',title:'工序报废率',align:'center',sortable:false"></th>
- <th data-options="field:'组件条码',title:'组件条码',align:'center',sortable:false"></th>
- </tr>
- </thead>
- </table>
- </div>
- </div>
- </div>
- <script type="text/javascript">
- var pgColumns = [[
- { field: 'name', title: '属性', width: '150px', sortable: true, align: 'left' },
- { field: 'value', title: '值', width: '150px', resizable: false, align: 'left' }
- ]];
- function formatterUA(value, row, index) {
- return Math.round(value * 10000) / 100 + '%';
- }
- function getdate(value, row, index) {
- return new Date(value).getFullYear() + "-" + (new Date(value).getMonth() + 1) + "-" + new Date(value).getDate();
- }
- function stylerSet(value, row, index) {
- if (value != '') {
- return 'color:#00BBFF;text-decoration:underline;';
- }
- }
- $(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";
- $("#datebeginMasterS").datetimebox("setValue", beginDate);
- $("#datebeginMasterD").datetimebox("setValue", endDate);
- //var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
- //var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
- //$("#datebeginMasterG").datebox("setValue", beginDate);
- //$("#dateendMasterG").datebox("setValue", endDate);
- //tbSearchSubmit();
- });
- function dgDblclickcelldetail(index, field, value) {
- var row = $('#DataGrid').datagrid('getSelected', index);
- if (field == '生产入库单号' && value != '') {
- $.tabs.open({
- title: '生产入库单[' + value + ']',
- url: '/mes/pc/wmslog/wmslog_index.html?ss={LOGIDLINK:' + row["LOGIDLINK"] + '}'
- });
- }
- }
- //主表双击事件
- function dgDblclickrow(index, row) {
- $("#tableTabs").tabs("select", 1);
- LoadDataGridDetail(index, row);
- }
- //加载子表数据
- function LoadDataGridDetail(index, row) {
- var barcode = row["产品条码"];
- //产品追踪表
- $('#DataGridMaster').datagridLoad({
- title: '',
- idField: 'SID',
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=master&id=' + request('id') + '&barcodeDB=' + barcode,
- fixWidth: 160,
- mergeWidth: 100,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true,
- pagination: false
- });
- //产品属性表
- $('#PropertyGridDetail').datagridLoad({
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=property&barcodeDB=' + barcode,
- fixWidth: 160,
- mergeWidth: 100,
- //pageSize: 10,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true,
- pagination: false
- //method: 'get',
- //columns: pgColumns,
- //border: false,
- //showGroup: false,
- //scrollbarSize: 0
- });
- //物料信息表
- $('#DataGridMateriel').datagrid({
- title: '',
- idField: 'SID',
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=materiel&id=' + request('id') + '&barcodeDB=' + barcode,
- fixWidth: 160,
- mergeWidth: 100,
- Pagination: false,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true
- });
- }
- //搜索提交
- function tbSearchSubmit() {
- var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
- var barcode = $('#barcode').textbox('getValue');
- var IDNRKONLYCODE = $('#IDNRKONLYCODE').textbox('getValue');
- if (barcode.length > 0 || IDNRKONLYCODE.length > 0
- || ($("#datebeginMasterS").datetimebox("getValue") != "" && $("#datebeginMasterD").datetimebox("getValue") != "")
- || ($("#datebeginMasterG").datebox("getValue") != "" && $("#dateendMasterG").datebox("getValue") != "")) {
- if ($('#ffMaster').form("validate")) {
- if (index == 0) {
- $('#DataGrid').datagridLoad({
- title: '',
- idField: 'SID',
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=goods&id=' + request('id'),
- fixWidth: 160,
- mergeWidth: 100,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true
- });
- }
- if (index == 2 && (IDNRKONLYCODE.length > 0)) {
- //物料信息表
- $('#DataGridMateriel').datagrid({
- title: '',
- idField: 'SID',
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=materiel&id=' + request('id'),
- fixWidth: 160,
- mergeWidth: 100,
- Pagination: false,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true
- });
- }
- if ((index == 1 || index == 2 || index == 3) && barcode.length > 0) {
- //产品追踪表
- $('#DataGridMaster').datagridLoad({
- title: '',
- idField: 'SID',
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=master&id=' + request('id'),
- fixWidth: 160,
- mergeWidth: 100,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true
- });
- //产品属性表
- $('#PropertyGridDetail').datagridLoad({
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=property',
- fixWidth: 160,
- mergeWidth: 100,
- //pageSize: 10,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true,
- pagination: false
- //method: 'get',
- //columns: pgColumns,
- //border: false,
- //showGroup: false,
- //scrollbarSize: 0
- });
- //物料信息表
- $('#DataGridMateriel').datagridLoad({
- title: '',
- idField: 'SID',
- queryParams: $('#ffMaster').serializeJson(),
- url: 'rpt.ashx?m=materiel&id=' + request('id'),
- fixWidth: 160,
- mergeWidth: 100,
- pagination: false,
- splitChar: '_',
- columnMenu: '#btnColumnMenu',
- columnMoving: true
- });
- }
- }
- }
- else {
- $.messager.alert('搜索', "请填写交接时间或注浆日期范围", 'warning');
- return;
- }
- }
- //导出
- function tbExport() {
- var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
- var title = $('#tableTabs').tabs('getTab', index).panel('options').title;//表格名称
- var id = "DataGridMaster";
- if (index == 1) {
- id = "PropertyGridDetail";
- }
- //加载表头
- var fields = $('#' + id).datagrid('getColumnFields');
- var headers = [];
- for (var i = 0; i < fields.length; i++) {
- //headers.push($('#DataGridMaster').datagrid('getColumnOption', fields[i])['title']);
- headers.push(fields[i]);
- }
- $('#' + id).datagridExport({
- headers: headers,
- fileName: '导出数据(' + title + ').xls',
- workSheet: '导出数据(' + title + ')'
- });
- //导出多sheet
- //$.dataGridToExcel(
- // ['DataGridMaster', 'PropertyGridDetail'],
- // ['产品跟踪表', '产品信息'],
- // "导出数据(产品跟踪表).xls"
- //);
- }
- //搜索按钮
- function tbSearch() {
- $('#tbSearchDiv').toggle();
- $('#toolbarLayout').panel('resize', { height: 'auto' });
- $('body').layout('resize');
- $('#tableTabs').tabs('resize');
- }
- //刷新
- function tbReload() {
- tbSearchSubmit();
- }
- </script>
- </body>
- </html>
|