Merge branch 'master' of http://bore.pub:10439/r/ERP_override
| | |
| | | exportConfig: {}, |
| | | scrollY:{ enabled: true,gt:13 },//开启虚拟滚动 |
| | | //scrollX:{ enabled: true,gt:15 },//开启虚拟滚动 |
| | | |
| | | mouseConfig:{selected: true},//鼠标选中 |
| | | keyboardConfig:{ |
| | | isArrow: true, |
| | | isDel: true, |
| | | isEnter: true, |
| | | isTab: true, |
| | | isEdit: true, |
| | | isChecked: true |
| | | }, |
| | | columnConfig: { |
| | | resizable: true, |
| | | useKey: true |
| | |
| | | {field: 'orderDetail.remarks',width:120, title: t('basicData.remarks'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged}, |
| | | {field: 'orderDetail.edgingType',width:120, title: t('order.edgingType'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged} |
| | | ], |
| | | toolbarConfig: { |
| | | zoom: true, |
| | | custom: true |
| | | } |
| | | |
| | | |
| | | }) |
| | |
| | | xGrid.value.reloadData(res.data) |
| | | }) |
| | | }) |
| | | |
| | | const handleKeyDown = (evnt) =>{ |
| | | |
| | | if(evnt.$event.keyCode === 38 ){ |
| | | let nextRowIndex = xGrid.value.getRowIndex(xGrid.value.getCurrentRecord()) - 1; |
| | | if (nextRowIndex < xGrid.value.getTableData().fullData.length && nextRowIndex>=0) { |
| | | xGrid.value.setCurrentRow(xGrid.value.getTableData().fullData[nextRowIndex]); |
| | | } |
| | | |
| | | } |
| | | if(evnt.$event.keyCode === 40 ){ |
| | | let nextRowIndex = xGrid.value.getRowIndex(xGrid.value.getCurrentRecord()) + 1; |
| | | if (nextRowIndex < xGrid.value.getTableData().fullData.length) { |
| | | xGrid.value.setCurrentRow(xGrid.value.getTableData().fullData[nextRowIndex]); |
| | | } |
| | | |
| | | } |
| | | } |
| | | </script> |
| | | |
| | | <template> |
| | |
| | | class="mytable-scrollbar" |
| | | ref="xGrid" |
| | | v-bind="gridOptions" |
| | | @keydown="handleKeyDown" |
| | | > |
| | | <template #num1_filter="{ column, $panel }"> |
| | | <div> |
| | |
| | | customConfig: { |
| | | storage: true |
| | | }, |
| | | mouseConfig:{selected: true},//鼠标选中 |
| | | keyboardConfig:{ |
| | | isArrow: true, |
| | | isDel: true, |
| | | isEnter: true, |
| | | isTab: true, |
| | | isEdit: true, |
| | | isChecked: true |
| | | }, |
| | | |
| | | columns:[ |
| | | {type: 'seq', title: t('basicData.Number'), width: 80 }, |
| | |
| | | }) |
| | | } |
| | | |
| | | const handleKeyDown = (evnt) =>{ |
| | | |
| | | if(evnt.$event.keyCode === 38 ){ |
| | | let nextRowIndex = xGrid.value.getRowIndex(xGrid.value.getCurrentRecord()) - 1; |
| | | if (nextRowIndex < xGrid.value.getTableData().fullData.length && nextRowIndex>=0) { |
| | | xGrid.value.setCurrentRow(xGrid.value.getTableData().fullData[nextRowIndex]); |
| | | } |
| | | |
| | | } |
| | | if(evnt.$event.keyCode === 40 ){ |
| | | let nextRowIndex = xGrid.value.getRowIndex(xGrid.value.getCurrentRecord()) + 1; |
| | | if (nextRowIndex < xGrid.value.getTableData().fullData.length) { |
| | | xGrid.value.setCurrentRow(xGrid.value.getTableData().fullData[nextRowIndex]); |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | </script> |
| | |
| | | class="mytable-scrollbar" |
| | | ref="xGrid" |
| | | v-bind="gridOptions" |
| | | @keydown="handleKeyDown" |
| | | > |
| | | <template #num1_filter="{ column, $panel }"> |
| | | <div> |
| | |
| | | columns:[ |
| | | |
| | | ], |
| | | mergeCells:[] |
| | | mergeCells:[], |
| | | toolbarConfig: { |
| | | zoom: true, |
| | | custom: true |
| | | } |
| | | |
| | | |
| | | }) |
| | |
| | | |
| | | } |
| | | |
| | | const cellStyle = ({ row, column }) => { |
| | | if(company.longSide!=null){ |
| | | if (column.field === 'width') { |
| | | if (row.width > parseInt(company.longSide)) { |
| | | return { |
| | | backgroundColor: '#ec6969' |
| | | } |
| | | } |
| | | } |
| | | if (column.field === 'height') { |
| | | if (row.height > parseInt(company.longSide)) { |
| | | return { |
| | | backgroundColor: '#ec6969' |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | }; |
| | | |
| | | //误差面积计算方法 |
| | | const errorAreaComputed = () => { |
| | | const regex = /^(0(\.\d{1,2})?|([1-9]\d{0,4})(\.\d{1,2})?|99999(\.9{1,2})?)$/ |
| | |
| | | v-on="gridEvents" |
| | | @keydown="handleKeyDown" |
| | | @edit-closed="editClosedEvent" |
| | | :cell-style="cellStyle" |
| | | > |
| | | <template #num1_filter="{ column, $panel }"> |
| | | <div> |
| | |
| | | {field: 'processingNote',width:120, title: t('order.processingNote'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true} |
| | | |
| | | ], |
| | | |
| | | mouseConfig:{selected: true},//鼠标选中 |
| | | keyboardConfig:{ |
| | | isArrow: true |
| | | }, |
| | | //表头按钮 |
| | | toolbarConfig: { |
| | | buttons: [ |
| | |
| | | |
| | | } |
| | | |
| | | const handleKeyDown = (evnt) =>{ |
| | | |
| | | if(evnt.$event.keyCode === 38 ){ |
| | | let nextRowIndex = xGrid.value.getRowIndex(xGrid.value.getCurrentRecord()) - 1; |
| | | if (nextRowIndex < xGrid.value.getTableData().fullData.length && nextRowIndex>=0) { |
| | | xGrid.value.setCurrentRow(xGrid.value.getTableData().fullData[nextRowIndex]); |
| | | rowClickIndex.value = xGrid.value.getCurrentRecord() |
| | | } |
| | | |
| | | } |
| | | if(evnt.$event.keyCode === 40 ){ |
| | | let nextRowIndex = xGrid.value.getRowIndex(xGrid.value.getCurrentRecord()) + 1; |
| | | if (nextRowIndex < xGrid.value.getTableData().fullData.length) { |
| | | xGrid.value.setCurrentRow(xGrid.value.getTableData().fullData[nextRowIndex]); |
| | | rowClickIndex.value = xGrid.value.getCurrentRecord() |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | | </script> |
| | | |
| | | <template> |
| | |
| | | ref="xGrid" |
| | | v-bind="gridOptions" |
| | | v-on="gridEvents" |
| | | @keydown="handleKeyDown" |
| | | |
| | | > |
| | | <!-- 下拉显示所有信息插槽--> |
| | |
| | | <el-row style=""> |
| | | <el-col :span="4">{{$t('craft.TrademarkOptions')}}:</el-col> |
| | | <el-col :span="6"> |
| | | <el-select v-model="trademarkAttr.trademark" @change ="iconChange"> |
| | | <el-select v-model="trademarkAttr.trademark" @change ="iconChange" filterable> |
| | | <el-option :value="item.basicName" v-for="item in trademarkList" /> |
| | | </el-select> |
| | | </el-col> |
| | |
| | | public Result mergeFlowCard(@RequestBody Map<String, Object> object) { |
| | | return Result.seccess(flowCardService.mergeFlowCard(object)); |
| | | } |
| | | @ApiOperation("汉玻获取流程卡接口") |
| | | @PostMapping("/getProcessCardList/hanbo") |
| | | public Result getProcessCard() { |
| | | return Result.seccess(flowCardService.getProcessCard()); |
| | | } |
| | | |
| | | @ApiOperation("汉玻确认接收接口") |
| | | @PostMapping("/updateProcessCardState/hanbo") |
| | | public Result updateProcessCardState(@RequestBody Integer id) { |
| | | return Result.seccess(flowCardService.updateProcessCardState(id)); |
| | | } |
| | | } |
| | |
| | | //分架员 |
| | | private String founder; |
| | | //分架时间 |
| | | @TableField(value = "`splitFrame_time`") |
| | | private LocalDate splitFrameTime; |
| | | //排序 |
| | | private Integer sort; |
| | |
| | | |
| | | //查询用 |
| | | //报工编号 |
| | | @TableField(select = false,exist = false) |
| | | private String reportingWorkId; |
| | | //产品名称 |
| | | @TableField(select = false,exist = false) |
| | | private String glassChild; |
| | | //工艺流程 |
| | | @TableField(select = false,exist = false) |
| | | private String process; |
| | | //流程卡合并 |
| | | @TableField(select = false,exist = false) |
| | | private Integer merge; |
| | | |
| | | //外键订单表 |
| | |
| | | private LocalDate createTime; |
| | | |
| | | @TableField(select = false,exist = false) |
| | | private Integer thickness; |
| | | |
| | | @TableField(select = false,exist = false) |
| | | private Order order; |
| | | @TableField(select = false,exist = false) |
| | | private OrderDetail orderDetail; |
| | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.dynamic.datasource.annotation.DS; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | | import com.example.erp.entity.pp.FlowCard; |
| | | import com.example.erp.entity.sd.OrderGlassDetail; |
| | | import com.example.erp.entity.sd.OrderProcessDetail; |
| | |
| | | |
| | | |
| | | } |
| | | |
| | | public List<FlowCard> getProcessCard() { |
| | | List<FlowCard> flowCardList = flowCardMapper.selectList( |
| | | new QueryWrapper<FlowCard>().eq("termination_status", 0) |
| | | .orderByDesc("id") |
| | | ); |
| | | for (FlowCard flowCard : flowCardList) { |
| | | flowCard.setProcessId(flowCard.getProcessId()+'/'+flowCard.getTechnologyNumber()); |
| | | flowCard.setOrderGlassDetail( |
| | | orderGlassDetailMapper.selectOne( |
| | | new QueryWrapper<OrderGlassDetail>() |
| | | .eq("order_id", flowCard.getOrderId()) |
| | | .eq("order_number", flowCard.getOrderNumber()) |
| | | .eq("technology_number", flowCard.getTechnologyNumber()) |
| | | ) |
| | | ); |
| | | String str = flowCard.getOrderGlassDetail().getGlassChild(); |
| | | String delimiter = "mm"; |
| | | int index = str.indexOf(delimiter); |
| | | Integer subString = Integer.valueOf(str.substring(0, index).trim()); |
| | | flowCard.getOrderGlassDetail().setThickness(subString); |
| | | } |
| | | return flowCardList; |
| | | } |
| | | |
| | | public Boolean updateProcessCardState(Integer id) { |
| | | UpdateWrapper<FlowCard> updateWrapper = new UpdateWrapper<>(); |
| | | updateWrapper.eq("id", id) // 根据id更新 |
| | | .set("termination_status", 1); |
| | | return flowCardMapper.update(null, updateWrapper) > 0; |
| | | } |
| | | } |
| | | |
| | | |
| | |
| | | </select> |
| | | |
| | | <select id="getSelectShippingOrder"> |
| | | select * from sd.delivery d |
| | | select * from sd.delivery d left join sd.delivery_detail dd on d.delivery_id=dd.delivery_id |
| | | <where> |
| | | date(d.create_time)>=#{startDate} and date(d.create_time) <= #{endDate} |
| | | <if test="delivery.deliveryId != null and delivery.deliveryId != ''"> |
| | |
| | | and d.project regexp #{delivery.project} |
| | | </if> |
| | | <if test="delivery.orderId != null and delivery.orderId != ''"> |
| | | and d.order_id regexp #{delivery.orderId} |
| | | and dd.order_id regexp #{delivery.orderId} |
| | | </if> |
| | | <if test="delivery.payMethod != null and delivery.payMethod != ''"> |
| | | and d.pay_method regexp #{delivery.payMethod} |
| | |
| | | </if> |
| | | |
| | | </where> |
| | | group by d.delivery_id |
| | | order by d.id desc |
| | | limit #{offset},#{pageSize}; |
| | | </select> |