Merge branch 'master' of http://10.153.19.25:10101/r/ERP_override
# Conflicts:
# north-glass-erp/northglass-erp/package-lock.json
# north-glass-erp/northglass-erp/src/views/sd/product/CreateProduct.vue
| | |
| | | "version": "2.3.1", |
| | | "resolved": "https://registry.npmmirror.com/@element-plus/icons-vue/-/icons-vue-2.3.1.tgz", |
| | | "integrity": "sha512-XxVUZv48RZAd87ucGS48jPf6pKu0yV5UCg9f4FFwtrYxXOwWuVJo6wOvSLKEoMQKjv8GsX/mhP6UsC1lRwbUWg==", |
| | | "license": "MIT", |
| | | "peerDependencies": { |
| | | "vue": "^3.2.0" |
| | | } |
| | |
| | | "node_modules/dayjs": { |
| | | "version": "1.11.13", |
| | | "resolved": "https://registry.npmmirror.com/dayjs/-/dayjs-1.11.13.tgz", |
| | | "integrity": "sha512-oaMBel6gjolK862uaPQOVTA7q3TZhuSvuMQAAglQDOWYO9A91IrAOUJEyKVlqJlHE0vq5p5UXxzdPfMH/x6xNg==", |
| | | "license": "MIT" |
| | | "integrity": "sha512-oaMBel6gjolK862uaPQOVTA7q3TZhuSvuMQAAglQDOWYO9A91IrAOUJEyKVlqJlHE0vq5p5UXxzdPfMH/x6xNg==" |
| | | }, |
| | | "node_modules/debug": { |
| | | "version": "4.3.6", |
| | |
| | | "version": "2.9.3", |
| | | "resolved": "https://registry.npmmirror.com/element-plus/-/element-plus-2.9.3.tgz", |
| | | "integrity": "sha512-6tSLp5XytDS4TMZ0P3aGZnr7MXTagfNycepNfIDitd9IgwM9y01+Ssu6mglNi8RiXYhek6LBWNOd/cvpIO12+w==", |
| | | "license": "MIT", |
| | | "dependencies": { |
| | | "@ctrl/tinycolor": "^3.4.1", |
| | | "@element-plus/icons-vue": "^2.3.1", |
| | |
| | | faceOrientation:null,//å
å¤é¢ |
| | | type:null,//æ ç¾æ¨¡æ¿ |
| | | lableType:null,//æ ç¾ç±»å |
| | | switch:null//夿æ¯å¦ä¸ºæ°æå° |
| | | switch:null,//夿æ¯å¦ä¸ºæ°æå° |
| | | lastList:[], |
| | | }) |
| | | |
| | | const {currentRoute} = useRouter() |
| | |
| | | for (let i = 0; i < list.value.length; i++) { |
| | | let count = list.value[i].data.length |
| | | for (let j = 0; j < count; j++) { |
| | | for (let k = 0; k < list.value[i].data[j].quantity; k++) { |
| | | lastList.value.push(list.value[i].data[j]) |
| | | } |
| | | // for (let k = 0; k < list.value[i].data[j].quantity; k++) { |
| | | props.lastList.push(list.value[i].data[j]) |
| | | // } |
| | | } |
| | | } |
| | | } else { |
| | |
| | | } |
| | | |
| | | // éå lastList å¹¶æ´æ°å¯¹åºç屿§ |
| | | lastList.value.forEach(obj => { |
| | | props.lastList.forEach(obj => { |
| | | // è·ååç¼å orderId |
| | | const prefix = lastList.value[index].processId.substring(0, 11); |
| | | const prefix = props.lastList[id].processId.substring(0, 11); |
| | | const orderId = obj.orderId; |
| | | const glassNumber=lastList.value[index].glassNumber |
| | | const glassNumber=props.lastList[id].glassNumber |
| | | // æ ¹æ® propertyName æ´æ°å±æ§ |
| | | if (propertyName === 'productAbbreviation' && prefix === obj.processId.substring(0, 11)) { |
| | | obj.productAbbreviation = result; |
| | |
| | | if (propertyName === 'customerName' && orderId === obj.orderId){ |
| | | obj.customerName = result; |
| | | } |
| | | if (propertyName === 'orderId' && orderId === obj.orderId){ |
| | | obj.orderId = result; |
| | | } |
| | | if (propertyName === 'glassNumber' && glassNumber === obj.glassNumber){ |
| | | obj.glassNumber = result; |
| | | } |
| | | if (propertyName === 'width' && glassNumber === obj.glassNumber){ |
| | | obj.width = result; |
| | | } |
| | | if (propertyName === 'height' && glassNumber === obj.glassNumber){ |
| | | obj.height = result; |
| | | } |
| | | if (propertyName === 'custom1' && orderId === obj.orderId){ |
| | | obj.custom1 = result; |
| | | } |
| | | if (propertyName === 'custom2' && orderId === obj.orderId){ |
| | | obj.custom2 = result; |
| | | } |
| | | if (propertyName === 'custom3' && orderId === obj.orderId){ |
| | | obj.custom3 = result; |
| | | } |
| | | if (propertyName === 'custom4' && orderId === obj.orderId){ |
| | | obj.custom4 = result; |
| | | } |
| | | if (propertyName === 'custom5' && orderId === obj.orderId){ |
| | | obj.custom5 = result; |
| | | } |
| | | }); |
| | | } |
| | | |
| | |
| | | |
| | | <template> |
| | | <div id="print" :class="company.printLabel.className.semi.printFlowCardName()"> |
| | | <div v-for="(item1,id) in lastList" :class="company.printLabel.className.semi.entiretyName()"> |
| | | <div v-for="(item1,id) in props.lastList" :class="company.printLabel.className.semi.entiretyName()"> |
| | | <div class="row4">{{ faceOrientation }}</div> |
| | | <div v-for="(item,id) in labelList" :class="company.printLabel.className.semi.contentRowName()"> |
| | | <div contenteditable="true" v-if="item1[item.name] != null && item1[item.name] !== ''" class="row1" @input="updateProductName($event, id,index)">{{ item.title }}ï¼{{ item1[item.name] }}</div> |
| | |
| | | mergeTechnologyNumber:null |
| | | }) |
| | | |
| | | //æå°æ¶é´ |
| | | const currentTime = new Date(); |
| | | const formattedTime = currentTime.getFullYear() |
| | | + '-' + (currentTime.getMonth() + 1) + '-' |
| | | + currentTime.getDate() + ' ' + currentTime.getHours() + ':' |
| | | + currentTime.getMinutes();formattedTime |
| | | |
| | | const {currentRoute} = useRouter() |
| | | const route = currentRoute.value |
| | | const printMerge = props.printMerge |
| | |
| | | <div style="font-weight: bolder;display: flex;justify-content:space-between"> |
| | | <div> |
| | | è¡¥çåå·ï¼{{itemFlow.patch_id}} |
| | | æå°äººï¼{{user.user.userName}}</div> |
| | | æå°äººï¼{{user.user.userName}} |
| | | æ¶é´ï¼{{formattedTime}} |
| | | </div> |
| | | <div> |
| | | <span style="font-size: 10px">{{itemFlow.otherRemarks}}</span> |
| | | æµç¨å¡å·ï¼ {{ |
| | |
| | | longSide:null,//订åå建æé¿è¾¹æç¤ºé¢è² nullä¸æç¤ºé¢è² |
| | | showDeliveryCreator:true,//åè´§åå建人å
æ¾ç¤ºæè
åæ¾ç¤º falseåæ¾ç¤º |
| | | deliveryRemark: ['夿³¨:æ¬æ¹ç»ç为ä¼çåæ ¼åï¼è¯·å¨å¸è´§æ¶,å½é¢æ¶ç¹éªæ¶ãå¦æè´¨éé®é¢å¨ä¸å¨å
䏿¬å
¬å¸èç³»,å¦åæ¦ä¸è´è´£ï¼'], |
| | | deliveryOutbound: false,//åè´§é»è®¤åºåº |
| | | //天津 |
| | | printLabel: { |
| | | custom: (item1) => { |
| | |
| | | longSide:6500,//订åå建æé¿è¾¹æç¤ºé¢è² |
| | | showDeliveryCreator:true,//åè´§åå建人å
æ¾ç¤ºæè
åæ¾ç¤º falseåæ¾ç¤º |
| | | deliveryRemark: ['夿³¨:æ¬æ¹ç»ç为ä¼çåæ ¼åï¼è¯·å¨å¸è´§æ¶,å½é¢æ¶ç¹éªæ¶ãå¦æè´¨éé®é¢å¨ä¸å¨å
䏿¬å
¬å¸èç³»,å¦åæ¦ä¸è´è´£ï¼'], |
| | | deliveryOutbound: true,//åè´§é»è®¤åºåº |
| | | //天津 |
| | | printLabel: { |
| | | custom: (item1) => { |
| | |
| | | import {defineStore} from "pinia"; |
| | | import {filterChanged} from "@/hook"; |
| | | |
| | | export default defineStore('companyInfo', { |
| | | |
| | |
| | | longSide:null,//订åå建æé¿è¾¹æç¤ºé¢è² |
| | | showDeliveryCreator:true,//åè´§åå建人å
æ¾ç¤ºæè
åæ¾ç¤º falseåæ¾ç¤º |
| | | deliveryRemark: ['夿³¨:æ¬æ¹ç»ç为ä¼çåæ ¼åï¼è¯·å¨å¸è´§æ¶,å½é¢æ¶ç¹éªæ¶ãå¦æè´¨éé®é¢å¨ä¸å¨å
䏿¬å
¬å¸èç³»,å¦åæ¦ä¸è´è´£ï¼'], |
| | | deliveryOutbound: false,//åè´§é»è®¤åºåº |
| | | |
| | | //天津 |
| | | printLabel: { |
| | |
| | | deliveryRemark: ['温馨æç¤ºï¼è´§å°å·¥å°æå·¥ååï¼è¯·äºäºå¤©å
å®è£
宿¯ï¼å¦æªè½åæ¶å®è£
宿¯ï¼è¯·æ¾ç½®äºé´åå¹²ç¥å¤ï¼å¹¶å好鲿鲿·çæªæ½ï¼é²æ¢ç»çåéï¼ææåçéèç»ç请å¿ç¨å¸¦é
¸æ§æç¢±æ§çæ¶²ä½æ¸
æ´èé¢ã', |
| | | '声æï¼è´§å°å·¥å°æå·¥ååï¼å¦è¥è´µå¸ä¸åæ¶çå®è£
ææªå鲿鲿·æªæ½å¯¼è´çç»çåéï¼æå¸æ¦ä¸è´è´£ã', |
| | | 'æ¶è´§æ¶ééªæ¶äº§åæ°éãè§æ ¼åææ ç ´æï¼å¦åç°é®é¢éäºæ¶è´§ä¸æ¥å
ï¼ä»¥ä¹¦é¢éç¥å¹¶éä¸ç°åºè¯æææï¼å¦ç ´æç
§ççï¼ï¼ç¸å
³è¯æèµæä¸è¶³ï¼æå¨ä¸è¿°æ¥æå
æªæåºè´¨éå¼è®®çï¼é¾æè§ä¸ºäº§ååæ ¼ï¼æå¸å°ä¸äºæ¿æ
ä»»ä½è´£ä»»ãæ¬è¯·çæï¼'], |
| | | deliveryOutbound: false,//åè´§é»è®¤åºåº |
| | | //天津 |
| | | printLabel: { |
| | | custom: (item1) => { |
| | |
| | | import {ElMessage} from "element-plus"; |
| | | import {useRouter,useRoute,onBeforeRouteUpdate} from "vue-router"; |
| | | import { useI18n } from 'vue-i18n' |
| | | import companyInfo from "@/stores/sd/companyInfo"; |
| | | |
| | | //è¯è¨è·å |
| | | const { t } = useI18n() |
| | |
| | | |
| | | const router = useRouter() |
| | | const route = useRoute() |
| | | const company = companyInfo() |
| | | let indexFlag=$ref(1) |
| | | function changeRouter(index){ |
| | | indexFlag=index |
| | |
| | | <el-breadcrumb :separator-icon="ArrowRight"> |
| | | <el-breadcrumb-item @click="changeRouter(1)" :class="indexFlag===1?'indexTag':''" :to="{ path: '/main/productStock/productStockList' }" >{{$t('productStock.inventoryQuery')}}</el-breadcrumb-item> |
| | | <el-breadcrumb-item @click="changeRouter(2)" :class="indexFlag===2?'indexTag':''" :to="{ path: '/main/productStock/createProductStock' }">{{$t('productStock.finishedProductWarehousing')}}</el-breadcrumb-item> |
| | | <el-breadcrumb-item @click="changeRouter(3)" :class="indexFlag===3?'indexTag':''" :to="{ path: '/main/productStock/finishedProductOut' }">{{$t('productStock.finishedProductOutbound')}}</el-breadcrumb-item> |
| | | <el-breadcrumb-item @click="changeRouter(3)" v-if="company.deliveryOutbound===false" :class="indexFlag===3?'indexTag':''" :to="{ path: '/main/productStock/finishedProductOut' }">{{$t('productStock.finishedProductOutbound')}}</el-breadcrumb-item> |
| | | <!-- <el-breadcrumb-item @click="changeRouter(4)" :class="indexFlag===4?'indexTag':''" :to="{ path: '/main/productStock/FinishedProductReturn' }">{{$t('productStock.finishedProductOrderReturn')}}</el-breadcrumb-item>--> |
| | | <el-breadcrumb-item v-show="false" :to="{ path: '/main/order/orderReport' }">{{$t('productStock.reportForms')}}</el-breadcrumb-item> |
| | | <!-- <el-breadcrumb-item :to="{ path: '/main/productStock/OrderAllocation' }">订åè°æ¨</el-breadcrumb-item>--> |
| | |
| | | gridOptions.toolbarConfig.buttons = gridOptions.toolbarConfig.buttons.filter(button => { |
| | | // è¿éæ ¹æ® hidePrintLabels çå¼å³å®æ¯å¦éè printLabel å printLabel2 |
| | | if (hidePrintLabels == 'true') { |
| | | return button.code !== 'printLabel' && button.code !== 'printLabel2'; |
| | | return button.code !== 'printLabel' && button.code !== 'printLabel2' ; |
| | | } else { |
| | | return true && button.code !== 'printLike'; // æ¾ç¤ºè¯¥æé® |
| | | } |
| | |
| | | import companyInfo from "@/stores/sd/companyInfo" |
| | | import {CircleCheck, Download, Printer} from "@element-plus/icons-vue/global"; |
| | | import TagStyleDesigner from "@/components/pp/TagStyleDesigner.vue"; |
| | | import {hiprint} from "vue-plugin-hiprint"; |
| | | |
| | | const company = companyInfo() |
| | | |
| | |
| | | const data = ref({ |
| | | printList: [] |
| | | }) |
| | | |
| | | onMounted(async () => { |
| | | await getTags(); |
| | | await hiprint.init(); |
| | | }) |
| | | let hiprintTemplate = ref() |
| | | |
| | | const tags = ref([]) |
| | | |
| | | const tag = ref({ |
| | | id: null, |
| | | name: null, |
| | | type: 1, |
| | | tagWidth: null, |
| | | tagHeight: null, |
| | | value: null, |
| | | size: null |
| | | }) |
| | | |
| | | const changeTag = () => { |
| | | hiprintTemplate.value = new hiprint.PrintTemplate({}); |
| | | const json = JSON.parse(tag.value.value) |
| | | hiprintTemplate.value.update(json) |
| | | } |
| | | |
| | | const getTags = () => { |
| | | request.get('tagStyle/getTagList').then(res => { |
| | | tags.value = res.data |
| | | }) |
| | | } |
| | | const printObjectProcess = () => { |
| | | hiprintTemplate.value.print(lastList.value) |
| | | } |
| | | |
| | | const {currentRoute} = useRouter() |
| | | const route = currentRoute.value |
| | |
| | | } |
| | | } |
| | | if (lableTypes == 1) { |
| | | console.log(company.label) |
| | | labelRow.value.list = JSON.stringify(selectRecords) |
| | | labelRow.value.faceOrientation = faceOrientation |
| | | labelRow.value.type = type |
| | |
| | | ElMessage.warning(t('searchOrder.msgList.checkOrder')) |
| | | return |
| | | } |
| | | if (type === null || type === '' || type === undefined) { |
| | | if (tag.value.name === null || tag.value.name === '' || tag.value.name === undefined) { |
| | | ElMessage.warning(t('processCard.pleaseSelectCustomPrintLabelStyle')) |
| | | return |
| | | } |
| | |
| | | |
| | | labelRow.value.list = JSON.stringify(selectRecords) |
| | | labelRow.value.faceOrientation = faceOrientation |
| | | labelRow.value.type = type |
| | | labelRow.value.type = tag.value.name |
| | | labelRow.value.lableType = lableTypes |
| | | labelRow.value.dataType = 1 |
| | | let columnsLabel = company.printLabel.columnsLabel |
| | |
| | | gridOptions.toolbarConfig.buttons = gridOptions.toolbarConfig.buttons.filter(button => { |
| | | // è¿éæ ¹æ® hidePrintLabels çå¼å³å®æ¯å¦éè printLabel å printLabel2 |
| | | if (hidePrintLabels == 'true') { |
| | | return button.code !== 'printLabel' && button.code !== 'printLabel2'; |
| | | return button.code !== 'printLabel' && button.code !== 'printLabel2' && button.code !== 'customLabel'; |
| | | } else { |
| | | return true && button.code !== 'printLike' && button.code !== 'printLabel3' && button.code !== 'printTest'; // æ¾ç¤ºè¯¥æé® |
| | | } |
| | |
| | | style="width: 90px"></el-input> |
| | | |
| | | <label>{{ $t('processCard.labelStyle') }}ï¼</label> |
| | | <el-select v-model="printType" :placeholder="$t('processCard.pleaseSelect')" clearable default-value="default_city" |
| | | style="width: 120px"> |
| | | <el-select v-model="tag" :placeholder="$t('processCard.pleaseSelect')" style="width: 140px" @change="changeTag"> |
| | | <el-option |
| | | v-for="item in titleSelectJson['dataType']" |
| | | :key="item.id" |
| | | :label="item.name" |
| | | :value="item.name" |
| | | v-for="(tag,index) in tags" |
| | | :key="index" |
| | | :label="tag.name" |
| | | :value="tag" |
| | | /> |
| | | </el-select> |
| | | |
| | |
| | | destroy-on-close |
| | | style="width: 80%;height:75% "> |
| | | <template #header="{ close, titleId, titleClass }"> |
| | | <el-button v-print="printContentLabel" :icon="Printer" circle/> |
| | | <el-button :icon="Printer" circle @click="printObjectProcess"/> |
| | | </template> |
| | | <print-custom-label-x-j id="childLabel" |
| | | :faceOrientation="labelRow.faceOrientation" |
| | | :lableType="labelRow.lableType" |
| | | :list="labelRow.list" |
| | | :lastList='lastList' |
| | | :type="labelRow.type" |
| | | style="width: 100%;height: 100%"/> |
| | | </el-dialog> |
| | |
| | | labelRow.value.list = JSON.stringify(selectRecords) |
| | | labelRow.value.type = tag.value.name |
| | | labelRow.value.dataType = 3 |
| | | labelRow.value.lableType = lableTypes |
| | | labelRow.value.lableType = 2 |
| | | labelRow.value.switch = true |
| | | lastList.value = [] |
| | | dialogTableVisibleLabel.value = true |
| | |
| | | let column = [1,3,8] |
| | | //ç¹å»æ¥è¯¢ |
| | | const getWorkOrder = () => { |
| | | request.post(`/report/processCardProgress/${form.orderId}`,column).then((res) => { |
| | | request.post(`/report/processCardProgress/${form.orderId}`, column).then((res) => { |
| | | if (res.code == 200) { |
| | | if(res.data.data.length===0){ |
| | | if (res.data.data.length === 0) { |
| | | ElMessage.warning(t('report.noDataFoundForThisOrder')) |
| | | return |
| | | } |
| | | //gridOptions.columns = JSON.parse(JSON.stringify(columns)) |
| | | res.data.title.forEach(item =>{ |
| | | let column = {slots: { default: 'quantitySum' }, width: 90,title: item.process} |
| | | // å¨ææ·»å å |
| | | res.data.title.forEach((item, index) => { |
| | | let column = { |
| | | slots: { default: 'quantitySum' }, |
| | | width: 90, |
| | | title: item.process, |
| | | field: `dynamicColumn${index}` // ä¸ºå¨æåæ·»å å¯ä¸ç field |
| | | } |
| | | gridOptions.columns.push(column) |
| | | }) |
| | | res.data.data.forEach(item => { |
| | | item.reportWorkQuantity=JSON.parse(item.reportWorkQuantity) |
| | | item.reportWorkQuantityCount=JSON.parse(item.reportWorkQuantityCount) |
| | | item.reportWorkQuantity = JSON.parse(item.reportWorkQuantity) |
| | | item.reportWorkQuantityCount = JSON.parse(item.reportWorkQuantityCount) |
| | | }) |
| | | mergeCells.value = res.data.mergeCell |
| | | xGrid.value.loadData(res.data.data) |
| | |
| | | } |
| | | }) |
| | | } |
| | | |
| | | const footSumDynamic = (data, columnTitle) => { |
| | | let sum = 0; |
| | | data.forEach(item => { |
| | | const value = Number(item.reportWorkQuantity[columnTitle]) || 0; // ä» reportWorkQuantity 䏿åå¼å¹¶è½¬æ¢ä¸ºæ°å |
| | | sum += value; |
| | | }); |
| | | return sum.toFixed(2); |
| | | } |
| | | |
| | | const quantitySum = ( row,column )=>{ |
| | | const reportWorkQuantity = row.reportWorkQuantity[column.title] || 0 |
| | | const reportWorkQuantityCount = row.reportWorkQuantityCount[column.title] || 0 |
| | |
| | | data: [ |
| | | ],//table bodyå®é
æ°æ® |
| | | //è鍿±å |
| | | footerMethod ({ columns, data }) {//页è彿° |
| | | |
| | | return[ |
| | | footerMethod ({ columns, data }) { |
| | | return [ |
| | | columns.map((column, columnIndex) => { |
| | | if (columnIndex === 0) { |
| | | return t('basicData.total') |
| | | } |
| | | const List = ["quantity","broken_num","inventory",] |
| | | const List = ["quantity", "broken_num", "inventory", "inventoryArea"]; // éæåçæ±å |
| | | if (List.includes(column.field)) { |
| | | console.log(data) |
| | | console.log(column.field) |
| | | return footSum(data, column.field) |
| | | } |
| | | // 卿åçæ±å |
| | | if (column.field && column.field.startsWith('dynamicColumn')) { |
| | | return footSumDynamic(data, column.title) |
| | | } |
| | | return '' |
| | | }) |
| | | ] |
| | | }, |
| | | |
| | | } |
| | | }) |
| | | |
| | | |
| | |
| | | import {changeFilterEvent, filterChanged} from "@/hook" |
| | | |
| | | import { useI18n } from 'vue-i18n' |
| | | import footSum from "@/hook/footSum"; |
| | | //è¯è¨è·å |
| | | const { t } = useI18n() |
| | | let router=useRouter() |
| | |
| | | } |
| | | //gridOptions.columns = JSON.parse(JSON.stringify(columns)) |
| | | res.data.title.forEach((item, index) => { |
| | | let column = { slots: { default: 'quantitySum' }, width: 90, title: item.process }; |
| | | let column = { slots: { default: 'quantitySum' }, width: 90, title: item.process, |
| | | field: `dynamicColumn${index}` // ä¸ºå¨æåæ·»å å¯ä¸ç field |
| | | }; |
| | | const insertIndex = 5; // 设置æå
¥ä½ç½®çç´¢å¼ |
| | | gridOptions.columns = [ |
| | | ...gridOptions.columns.slice(0, insertIndex + index), // åæå
¥ä½ç½®ä¹åçé¨å |
| | |
| | | ElMessage.warning(res.msg) |
| | | } |
| | | }) |
| | | } |
| | | |
| | | const footSumDynamic = (data, columnTitle) => { |
| | | let sum = 0; |
| | | data.forEach(item => { |
| | | const value = Number(item.reportWorkQuantity[columnTitle]) || 0; // ä» reportWorkQuantity 䏿åå¼å¹¶è½¬æ¢ä¸ºæ°å |
| | | sum += value; |
| | | }); |
| | | return sum.toFixed(2); |
| | | } |
| | | const quantitySum = ( row,column )=>{ |
| | | const reportWorkQuantity = row.reportWorkQuantity[column.title] || 0 |
| | |
| | | data: [ |
| | | ],//table bodyå®é
æ°æ® |
| | | //è鍿±å |
| | | // footerMethod ({ columns, data }) {//页è彿° |
| | | // let footList=['7','8','9','10'] |
| | | // return[ |
| | | // columns.map((column, columnIndex) => { |
| | | // if (columnIndex === 0) { |
| | | // return 'å计:' |
| | | // } |
| | | // if (footList.includes(column.field)) { |
| | | // return sumNum(data, column.field) |
| | | // } |
| | | // return '' |
| | | // }) |
| | | // ] |
| | | // } |
| | | footerMethod ({ columns, data }) { |
| | | return [ |
| | | columns.map((column, columnIndex) => { |
| | | if (columnIndex === 0) { |
| | | return t('basicData.total') |
| | | } |
| | | const List = ["quantity", "inventoryNum", "inventoryArea"]; // éæåçæ±å |
| | | if (List.includes(column.field)) { |
| | | return footSum(data, column.field) |
| | | } |
| | | // 卿åçæ±å |
| | | if (column.field && column.field.startsWith('dynamicColumn')) { |
| | | return footSumDynamic(data, column.title) |
| | | } |
| | | return '' |
| | | }) |
| | | ] |
| | | } |
| | | |
| | | }) |
| | | |
| | |
| | | titleUploadData.value=deepClone(res.data.delivery) |
| | | titleUploadData.value.deliveryId=str |
| | | |
| | | //夿æ¯å¦åè´§åºåº |
| | | if(!company.deliveryOutbound){ |
| | | if(titleUploadData.value.stockState!==0){ |
| | | gridOptions.toolbarConfig.buttons[2].disabled = true |
| | | } |
| | | } |
| | | //æ ¹æ®å®¡æ ¸ç¶ææ¾ç¤ºå®¡æ ¸æé®æè
æ¯å审æé® |
| | | |
| | | if(titleUploadData.value.deliveryState!==0){ |
| | | gridOptions.toolbarConfig.buttons[1].disabled = true |
| | | gridOptions.toolbarConfig.buttons[0].disabled = true |
| | |
| | | if(titleUploadData.value.deliveryState===0){ |
| | | gridOptions.toolbarConfig.buttons[2].disabled = true |
| | | } |
| | | if(titleUploadData.value.stockState!==0){ |
| | | gridOptions.toolbarConfig.buttons[2].disabled = true |
| | | } |
| | | |
| | | pageNum=1 |
| | | produceList = deepClone(res.data.data) |
| | | |
| | |
| | | deliveryId: route.query.deliveryID, |
| | | type: 2, |
| | | userName:userStore.user.userName, |
| | | userId:userStore.user.userId |
| | | userId:userStore.user.userId, |
| | | deliveryOutbound:company.deliveryOutbound |
| | | |
| | | }) |
| | | request.post("/delivery/updateDeliveryToExamine", flowData.value).then((res) => { |
| | | if (res.code == 200 && res.data===true) { |
| | | if (res.code == 200 && res.data==="true") { |
| | | ElMessage.success(t('basicData.msg.ReviewSuccess')) |
| | | //router.push({path: '/main/delivery/selectDelivery', query:{random:Math.random()}}) |
| | | router.push({path:'/main/delivery/createDelivery',query:{ |
| | |
| | | deliveryId: route.query.deliveryID, |
| | | type: 0, |
| | | userName:userStore.user.userName, |
| | | userId:userStore.user.userId |
| | | userId:userStore.user.userId, |
| | | deliveryOutbound:company.deliveryOutbound |
| | | |
| | | }) |
| | | request.post("/delivery/updateDeliveryToExamine", flowData.value).then((res) => { |
| | | if (res.code == 200 && res.data===true) { |
| | | if (res.code == 200 && res.data==="true") { |
| | | ElMessage.success(t('basicData.msg.cancelReviewSuccess')) |
| | | //router.push({path: '/main/delivery/selectDelivery', query:{random:Math.random()}}) |
| | | router.push({path:'/main/delivery/createDelivery',query:{ |
| | |
| | | @Param("pageSize") Integer pageSize, |
| | | @Param("orderDetail") OrderDetail orderDetail); |
| | | |
| | | List<OrderDetail> getSelectDeliveryDetailDeliveryId(@Param("deliveryId") String deliveryId); |
| | | |
| | | Map<String,Integer> getSelectDeliveryDetailPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail); |
| | | |
| | | List<OrderDetail> getSelectAllocate(@Param("offset") Integer offset, |
| | |
| | | @Param("pageSize") Integer pageSize,String startDate, String endDate,String type, |
| | | @Param("finishedOperateLog") FinishedOperateLog finishedOperateLog); |
| | | |
| | | List<FinishedOperateLog> getSelectStorageRecordDeliveryId(@Param("deliveryId") String deliveryId,String type); |
| | | |
| | | Map<String,Integer> getSelectStorageRecordLogPageTotal(@Param("offset") Integer offset, |
| | | @Param("pageSize") Integer pageSize,String startDate, String endDate,String type, |
| | | @Param("finishedOperateLog") FinishedOperateLog finishedOperateLog); |
| | |
| | | |
| | | List<Map<String, Object>> getCustomLabelDetailMp(String name, String form, String id, FlowCard flowCard); |
| | | |
| | | List<Map<String, Object>> getPrintCustomData(String processId, String technologyNumber); |
| | | List<Map<String, Object>> getPrintCustomData(String processId, Integer orderNumber); |
| | | |
| | | Integer getPrintLabelCount(String processId, String technologyNumber); |
| | | |
| | |
| | | //è·å对象éå循ç¯è¿è¡æ°å¢ä¿®æ¹ |
| | | List<OrderDetail> orderDetaillist = JSONArray.parseArray(JSONObject.toJSONString(object.get("orderDetail")), OrderDetail.class); |
| | | if (!orderDetaillist.isEmpty()){ |
| | | for (OrderDetail orderDetail : orderDetaillist) { |
| | | //è·ååå· |
| | | String oddNumber= orderNumberSetting("åºåº"); |
| | | OrderDetail orderDetailNew= finishedGoodsInventoryMapper.findOrderDetailNumberd(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber()); |
| | | //æ·»å åºå
¥åºè®°å½ |
| | | finishedOperateLogMapper.insertOutFinishedOperateLog(orderDetail,userName,oddNumber); |
| | | Integer finishedGoodsInventorycount = finishedGoodsInventoryMapper.findOrderNumberdcount(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber()); |
| | | |
| | | |
| | | Integer ordersum = finishedGoodsInventoryMapper.findOrderQuantity(orderDetail.getDeliveryDetail().getOrderId()); |
| | | Integer orderNumberdsum = finishedGoodsInventoryMapper.findOrderNumberdsum(orderDetail.getDeliveryDetail().getOrderId()); |
| | | |
| | | Integer deliverysum = finishedGoodsInventoryMapper.findDeliveryQuantity(orderDetail.getDeliveryDetail().getDeliveryId()); |
| | | Integer deliverydetailsum = finishedGoodsInventoryMapper.findDeliverydetailsum(orderDetail.getDeliveryDetail().getDeliveryId(),0); |
| | | if(deliverydetailsum==null){ |
| | | deliverydetailsum=0; |
| | | } |
| | | |
| | | DeliveryDetail deliveryDetail=finishedGoodsInventoryMapper.findDeliverydetail(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getDeliveryId()); |
| | | /*System.out.println("è®¢åæ»æ°:" + ordersum + "订ååºåæ°ï¼" + orderNumberdsum + "åå¤åºåºæ°é" + |
| | | orderDetail.getWarehouseNum()+ "åè´§æ°é" + orderDetail.getDeliveryDetail().getQuantity()+ "åè´§æ»æ°" + |
| | | deliverysum+ "已忰é" + deliverydetailsum);*/ |
| | | //夿åè´§åçåºåæ¯å¦åå¨ |
| | | if (finishedGoodsInventorycount > 0) { |
| | | //夿åè´§åæ¯å¦å·²åºåº |
| | | if(deliveryDetail==null){ |
| | | if(orderDetailNew.getWarehouseNum()>=orderDetail.getDeliveryDetail().getQuantity()){ |
| | | //ä¿®æ¹åºå表åºåæ°é |
| | | finishedGoodsInventoryMapper.updateInventoryInventoryOut(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getQuantity()); |
| | | //ä¿®æ¹åè´§æç»è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDetailState(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getDeliveryId(),0); |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(orderDetail.getDeliveryDetail().getDeliveryId(),1); |
| | | //ä¿®æ¹è®¢åæç»è¡¨åè´§æ°é |
| | | finishedGoodsInventoryMapper.updateOutOrderNumberConut(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getQuantity()); |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(orderDetail.getDeliveryDetail().getOrderId(),1); |
| | | //å¤æè®¢åæ¯å¦å
¨é¨åè´§ |
| | | if (orderNumberdsum == orderDetail.getWarehouseNum()) { |
| | | //if (ordersum == (orderDeliveryQuantitySum + orderDetail.getWarehouseNum())) { |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(orderDetail.getDeliveryDetail().getOrderId(),2); |
| | | } |
| | | if (deliverysum==deliverydetailsum+orderDetail.getDeliveryDetail().getQuantity()) { |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(orderDetail.getDeliveryDetail().getDeliveryId(),2); |
| | | } |
| | | }else{ |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | return "false3"; |
| | | } |
| | | }else{ |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | return "false1"; |
| | | } |
| | | |
| | | |
| | | }else{ |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | return "false2"; |
| | | } |
| | | if(!Objects.equals(deliveryDetailLogic(orderDetaillist, savePoint, userName), "true")) { |
| | | return deliveryDetailLogic(orderDetaillist, savePoint, userName); |
| | | } |
| | | } |
| | | |
| | |
| | | //è·å对象éå循ç¯è¿è¡æ°å¢ä¿®æ¹ |
| | | List<FinishedOperateLog> finishedOperateLogslist = JSONArray.parseArray(JSONObject.toJSONString(object.get("orderDetail")), FinishedOperateLog.class); |
| | | if (!finishedOperateLogslist.isEmpty()){ |
| | | for (FinishedOperateLog finishedOperateLog : finishedOperateLogslist) { |
| | | Integer ordersum = finishedGoodsInventoryMapper.findOrderQuantity(finishedOperateLog.getOrderId()); |
| | | Integer ordernumbersum = finishedGoodsInventoryMapper.findOrderNumberdsum(finishedOperateLog.getOrderId()); |
| | | Integer deliverysum = finishedGoodsInventoryMapper.findDeliveryQuantity(finishedOperateLog.getOperationOrderNumber()); |
| | | Integer deliverydetailsum = finishedGoodsInventoryMapper.findDeliverydetailsum(finishedOperateLog.getOperationOrderNumber(),1); |
| | | |
| | | if(Objects.equals(finishedOperateLog.getOperateType(), "å
¥åº")){ |
| | | Delivery delivery = finishedGoodsInventoryMapper.findOrderDelivery(finishedOperateLog.getOrderId()); |
| | | if(delivery==null){ |
| | | //ä¿®æ¹è®°å½è¡¨ |
| | | finishedOperateLogMapper.updateFinishedOperateLogState(finishedOperateLog,"å·²ä½åº"); |
| | | //ä¿®æ¹åºå表å
¥åºæ°é |
| | | finishedGoodsInventoryMapper.updateInventoryOut(finishedOperateLog); |
| | | if(finishedOperateLog.getProcessId()!=null){ |
| | | //ä¿®æ¹æµç¨å¡è¡¨å
¥åºæ°é |
| | | finishedGoodsInventoryMapper.updateflowcardOut(finishedOperateLog); |
| | | } |
| | | |
| | | //ä¿®æ¹è®¢åæç»è¡¨å
¥åºæ°é |
| | | finishedGoodsInventoryMapper.updateOutOrderNumberConut(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(),finishedOperateLog.getQuantity()); |
| | | //å¤æè®¢åæ¯å¦å
¨é¨å
¥åº |
| | | if (Objects.equals(ordersum, ordernumbersum)) { |
| | | //ä¿®æ¹è®¢å表å
¥åºç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderWarehousingState(finishedOperateLog.getOrderId(),1); |
| | | } |
| | | if (ordernumbersum-finishedOperateLog.getQuantity()==0) { |
| | | //ä¿®æ¹è®¢å表å
¥åºç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderWarehousingState(finishedOperateLog.getOrderId(),0); |
| | | } |
| | | log.setFunction("cancelFinishedGoodsInventoryStorageå
¥åº"); |
| | | }else{ |
| | | return "false1"; |
| | | } |
| | | |
| | | |
| | | |
| | | }else if(Objects.equals(finishedOperateLog.getOperateType(), "åºåº")){ |
| | | //ä¿®æ¹è®°å½è¡¨ |
| | | finishedOperateLogMapper.updateFinishedOperateLogState(finishedOperateLog,"å·²ä½åº"); |
| | | //ä¿®æ¹åºå表åºåæ°é |
| | | finishedGoodsInventoryMapper.updateInventoryInventoryInt(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(),finishedOperateLog.getQuantity()); |
| | | //ä¿®æ¹åè´§æç»è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDetailState(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(),finishedOperateLog.getOperationOrderNumber(),1); |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(finishedOperateLog.getOperationOrderNumber(),1); |
| | | //ä¿®æ¹è®¢åæç»è¡¨åºå
æ°é |
| | | finishedGoodsInventoryMapper.updateIntOrderNumberConut(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(), Long.valueOf(finishedOperateLog.getQuantity())); |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(finishedOperateLog.getOrderId(),1); |
| | | //å¤æè®¢åæ¯å¦å
¨é¨åè´§ |
| | | if (ordersum==finishedOperateLog.getQuantity()+ordernumbersum){ |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(finishedOperateLog.getOrderId(),0); |
| | | |
| | | } |
| | | if (deliverysum==finishedOperateLog.getQuantity()+deliverydetailsum) { |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(finishedOperateLog.getOperationOrderNumber(),0); |
| | | } |
| | | log.setFunction("cancelFinishedGoodsInventoryStorageåºåº"); |
| | | |
| | | } |
| | | |
| | | if(!Objects.equals(cancelDeliveryDetailLogic(finishedOperateLogslist, savePoint, object.get("userName").toString(), log), "true")){ |
| | | return cancelDeliveryDetailLogic(finishedOperateLogslist,savePoint,object.get("userName").toString(),log); |
| | | } |
| | | } |
| | | logService.saveLog(log); |
| | |
| | | map.put("data", list); |
| | | return map; |
| | | } |
| | | |
| | | |
| | | public String deliveryDetailLogic(List<OrderDetail> list,Object savePoint,String userName) { |
| | | for (OrderDetail orderDetail : list) { |
| | | //è·ååå· |
| | | String oddNumber= orderNumberSetting("åºåº"); |
| | | OrderDetail orderDetailNew= finishedGoodsInventoryMapper.findOrderDetailNumberd(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber()); |
| | | //æ·»å åºå
¥åºè®°å½ |
| | | finishedOperateLogMapper.insertOutFinishedOperateLog(orderDetail,userName,oddNumber); |
| | | Integer finishedGoodsInventorycount = finishedGoodsInventoryMapper.findOrderNumberdcount(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber()); |
| | | |
| | | |
| | | Integer ordersum = finishedGoodsInventoryMapper.findOrderQuantity(orderDetail.getDeliveryDetail().getOrderId()); |
| | | Integer orderNumberdsum = finishedGoodsInventoryMapper.findOrderNumberdsum(orderDetail.getDeliveryDetail().getOrderId()); |
| | | |
| | | Integer deliverysum = finishedGoodsInventoryMapper.findDeliveryQuantity(orderDetail.getDeliveryDetail().getDeliveryId()); |
| | | Integer deliverydetailsum = finishedGoodsInventoryMapper.findDeliverydetailsum(orderDetail.getDeliveryDetail().getDeliveryId(),0); |
| | | if(deliverydetailsum==null){ |
| | | deliverydetailsum=0; |
| | | } |
| | | |
| | | DeliveryDetail deliveryDetail=finishedGoodsInventoryMapper.findDeliverydetail(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getDeliveryId()); |
| | | /*System.out.println("è®¢åæ»æ°:" + ordersum + "订ååºåæ°ï¼" + orderNumberdsum + "åå¤åºåºæ°é" + |
| | | orderDetail.getWarehouseNum()+ "åè´§æ°é" + orderDetail.getDeliveryDetail().getQuantity()+ "åè´§æ»æ°" + |
| | | deliverysum+ "已忰é" + deliverydetailsum);*/ |
| | | //夿åè´§åçåºåæ¯å¦åå¨ |
| | | if (finishedGoodsInventorycount > 0) { |
| | | //夿åè´§åæ¯å¦å·²åºåº |
| | | if(deliveryDetail==null){ |
| | | if(orderDetailNew.getWarehouseNum()>=orderDetail.getDeliveryDetail().getQuantity()){ |
| | | //ä¿®æ¹åºå表åºåæ°é |
| | | finishedGoodsInventoryMapper.updateInventoryInventoryOut(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getQuantity()); |
| | | //ä¿®æ¹åè´§æç»è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDetailState(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getDeliveryId(),0); |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(orderDetail.getDeliveryDetail().getDeliveryId(),1); |
| | | //ä¿®æ¹è®¢åæç»è¡¨åè´§æ°é |
| | | finishedGoodsInventoryMapper.updateOutOrderNumberConut(orderDetail.getDeliveryDetail().getOrderId(),orderDetail.getDeliveryDetail().getOrderNumber(),orderDetail.getDeliveryDetail().getQuantity()); |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(orderDetail.getDeliveryDetail().getOrderId(),1); |
| | | //å¤æè®¢åæ¯å¦å
¨é¨åè´§ |
| | | if (Objects.equals(orderNumberdsum, orderDetail.getWarehouseNum())) { |
| | | //if (ordersum == (orderDeliveryQuantitySum + orderDetail.getWarehouseNum())) { |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(orderDetail.getDeliveryDetail().getOrderId(),2); |
| | | } |
| | | if (deliverysum==deliverydetailsum+orderDetail.getDeliveryDetail().getQuantity()) { |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(orderDetail.getDeliveryDetail().getDeliveryId(),2); |
| | | } |
| | | }else{ |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | return "false3"; |
| | | } |
| | | }else{ |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | return "false1"; |
| | | } |
| | | |
| | | |
| | | }else{ |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | return "false2"; |
| | | } |
| | | } |
| | | return "true"; |
| | | } |
| | | |
| | | public String cancelDeliveryDetailLogic(List<FinishedOperateLog> finishedOperateLogslist,Object savePoint,String userName,Log log) { |
| | | for (FinishedOperateLog finishedOperateLog : finishedOperateLogslist) { |
| | | Integer ordersum = finishedGoodsInventoryMapper.findOrderQuantity(finishedOperateLog.getOrderId()); |
| | | Integer ordernumbersum = finishedGoodsInventoryMapper.findOrderNumberdsum(finishedOperateLog.getOrderId()); |
| | | Integer deliverysum = finishedGoodsInventoryMapper.findDeliveryQuantity(finishedOperateLog.getOperationOrderNumber()); |
| | | Integer deliverydetailsum = finishedGoodsInventoryMapper.findDeliverydetailsum(finishedOperateLog.getOperationOrderNumber(),1); |
| | | |
| | | if(Objects.equals(finishedOperateLog.getOperateType(), "å
¥åº")){ |
| | | Delivery delivery = finishedGoodsInventoryMapper.findOrderDelivery(finishedOperateLog.getOrderId()); |
| | | if(delivery==null){ |
| | | //ä¿®æ¹è®°å½è¡¨ |
| | | finishedOperateLogMapper.updateFinishedOperateLogState(finishedOperateLog,"å·²ä½åº"); |
| | | //ä¿®æ¹åºå表å
¥åºæ°é |
| | | finishedGoodsInventoryMapper.updateInventoryOut(finishedOperateLog); |
| | | if(finishedOperateLog.getProcessId()!=null){ |
| | | //ä¿®æ¹æµç¨å¡è¡¨å
¥åºæ°é |
| | | finishedGoodsInventoryMapper.updateflowcardOut(finishedOperateLog); |
| | | } |
| | | |
| | | //ä¿®æ¹è®¢åæç»è¡¨å
¥åºæ°é |
| | | finishedGoodsInventoryMapper.updateOutOrderNumberConut(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(),finishedOperateLog.getQuantity()); |
| | | //å¤æè®¢åæ¯å¦å
¨é¨å
¥åº |
| | | if (Objects.equals(ordersum, ordernumbersum)) { |
| | | //ä¿®æ¹è®¢å表å
¥åºç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderWarehousingState(finishedOperateLog.getOrderId(),1); |
| | | } |
| | | if (ordernumbersum-finishedOperateLog.getQuantity()==0) { |
| | | //ä¿®æ¹è®¢å表å
¥åºç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderWarehousingState(finishedOperateLog.getOrderId(),0); |
| | | } |
| | | log.setFunction("cancelFinishedGoodsInventoryStorageå
¥åº"); |
| | | }else{ |
| | | return "false1"; |
| | | } |
| | | |
| | | |
| | | |
| | | }else if(Objects.equals(finishedOperateLog.getOperateType(), "åºåº")){ |
| | | //ä¿®æ¹è®°å½è¡¨ |
| | | finishedOperateLogMapper.updateFinishedOperateLogState(finishedOperateLog,"å·²ä½åº"); |
| | | //ä¿®æ¹åºå表åºåæ°é |
| | | finishedGoodsInventoryMapper.updateInventoryInventoryInt(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(),finishedOperateLog.getQuantity()); |
| | | //ä¿®æ¹åè´§æç»è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDetailState(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(),finishedOperateLog.getOperationOrderNumber(),1); |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(finishedOperateLog.getOperationOrderNumber(),1); |
| | | //ä¿®æ¹è®¢åæç»è¡¨åºå
æ°é |
| | | finishedGoodsInventoryMapper.updateIntOrderNumberConut(finishedOperateLog.getOrderId(),finishedOperateLog.getOperationNumber(), Long.valueOf(finishedOperateLog.getQuantity())); |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(finishedOperateLog.getOrderId(),1); |
| | | //å¤æè®¢åæ¯å¦å
¨é¨åè´§ |
| | | if (ordersum==finishedOperateLog.getQuantity()+ordernumbersum){ |
| | | //ä¿®æ¹è®¢å表åè´§ç¶æ |
| | | finishedGoodsInventoryMapper.updateOrderDeliveryState(finishedOperateLog.getOrderId(),0); |
| | | |
| | | } |
| | | if (deliverysum==finishedOperateLog.getQuantity()+deliverydetailsum) { |
| | | //ä¿®æ¹åè´§è¡¨ç¶æ |
| | | finishedGoodsInventoryMapper.updateDeliveryDeliveryState(finishedOperateLog.getOperationOrderNumber(),0); |
| | | } |
| | | log.setFunction("cancelFinishedGoodsInventoryStorageåºåº"); |
| | | |
| | | } |
| | | |
| | | } |
| | | return "true"; |
| | | } |
| | | } |
| | |
| | | continue; |
| | | } |
| | | Map<String, Object> itemmap = new HashMap<>(); |
| | | itemmap.put("data", flowCardMapper.getPrintCustomData(flowCard.getProcessId(),flowCard.getTechnologyNumber())); |
| | | itemmap.put("data", flowCardMapper.getPrintCustomData(flowCard.getProcessId(),flowCard.getOrderNumber())); |
| | | list.add(itemmap); |
| | | |
| | | // å°è¯¥ processId å å
¥å·²å¤çéå |
| | |
| | | import com.example.erp.dto.mm.FinishedOperateLogDTO; |
| | | import com.example.erp.dto.sd.DeliveryDetailDTO; |
| | | import com.example.erp.dto.sd.DeliveryDetailProductDTO; |
| | | import com.example.erp.entity.mm.FinishedOperateLog; |
| | | import com.example.erp.entity.sd.*; |
| | | import com.example.erp.entity.userInfo.Log; |
| | | import com.example.erp.entity.userInfo.SysError; |
| | | import com.example.erp.mapper.mm.FinishedGoodsInventoryMapper; |
| | | import com.example.erp.mapper.mm.FinishedOperateLogMapper; |
| | | import com.example.erp.mapper.sd.*; |
| | | import com.example.erp.service.mm.FinishedGoodsInventoryService; |
| | | import com.example.erp.service.userInfo.LogService; |
| | | import com.example.erp.service.userInfo.SysErrorService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | |
| | | @Autowired |
| | | FinishedGoodsInventoryMapper finishedGoodsInventoryMapper; |
| | | @Autowired |
| | | FinishedOperateLogMapper finishedOperateLogMapper; |
| | | @Autowired |
| | | DeliveryOtherMoneyMapper deliveryOtherMoneyMapper; |
| | | @Autowired |
| | | LogService logService; |
| | | @Autowired |
| | | SysErrorService sysErrorService; |
| | | @Autowired |
| | | FinishedGoodsInventoryService finishedGoodsInventoryService; |
| | | |
| | | |
| | | public Map<String, Object> getSelectShippingOrder(Integer pageNum, Integer pageSize,List<String> selectDate, Delivery delivery) { |
| | |
| | | } |
| | | |
| | | |
| | | public Boolean updateDeliveryToExamine(Map<String,Object> object) { |
| | | Boolean isinsert=false; |
| | | String deliveryId = ""; |
| | | int type =3; |
| | | if (object.get("deliveryId") != null) { |
| | | deliveryId = object.get("deliveryId").toString(); |
| | | public String updateDeliveryToExamine(Map<String,Object> object) { |
| | | String saveState = "true"; |
| | | //è®¾ç½®åæ»ç¹ |
| | | Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint(); |
| | | try { |
| | | Log log = new Log(); |
| | | String deliveryId = ""; |
| | | int type =3; |
| | | if (object.get("deliveryId") != null) { |
| | | deliveryId = object.get("deliveryId").toString(); |
| | | } |
| | | |
| | | if (object.get("type") != null) { |
| | | type = Integer.parseInt(object.get("type").toString()); |
| | | } |
| | | |
| | | if(Boolean.parseBoolean(object.get("deliveryOutbound").toString())){ |
| | | if(type==2){ |
| | | List<OrderDetail> orderDetaillist=finishedGoodsInventoryMapper.getSelectDeliveryDetailDeliveryId(deliveryId); |
| | | if(!Objects.equals(finishedGoodsInventoryService.deliveryDetailLogic(orderDetaillist,savePoint,object.get("userName").toString()), "true")){ |
| | | return finishedGoodsInventoryService.deliveryDetailLogic(orderDetaillist,savePoint,object.get("userName").toString()); |
| | | } |
| | | }else{ |
| | | List<FinishedOperateLog> finishedOperateLogslist=finishedOperateLogMapper.getSelectStorageRecordDeliveryId(deliveryId,"åºåº"); |
| | | if(!Objects.equals(finishedGoodsInventoryService.cancelDeliveryDetailLogic(finishedOperateLogslist,savePoint,object.get("userName").toString(),log), "true")){ |
| | | return finishedGoodsInventoryService.cancelDeliveryDetailLogic(finishedOperateLogslist,savePoint,object.get("userName").toString(),log); |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | | |
| | | deliveryMapper.updateDeliveryToExamine(deliveryId,type); |
| | | |
| | | |
| | | log.setOperatorId(object.get("userId").toString()); |
| | | log.setOperator(object.get("userName").toString()); |
| | | log.setContent(object.toString()); |
| | | log.setFunction("updateDeliveryToExamineä¿®æ¹:"+deliveryId); |
| | | logService.saveLog(log); |
| | | } catch (Exception e) { |
| | | TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); |
| | | //å°å¼å¸¸ä¼ å
¥æ°æ®åº |
| | | SysError sysError = new SysError(); |
| | | sysError.setError(e+Arrays.toString(e.getStackTrace())); |
| | | sysError.setFunc("addDeliveryDetail"); |
| | | sysErrorService.insert(sysError); |
| | | saveState = "false"; |
| | | |
| | | } |
| | | |
| | | if (object.get("type") != null) { |
| | | type = Integer.parseInt(object.get("type").toString()); |
| | | } |
| | | |
| | | deliveryMapper.updateDeliveryToExamine(deliveryId,type); |
| | | |
| | | Log log = new Log(); |
| | | log.setOperatorId(object.get("userId").toString()); |
| | | log.setOperator(object.get("userName").toString()); |
| | | log.setContent(object.toString()); |
| | | log.setFunction("updateDeliveryToExamineä¿®æ¹:"+deliveryId); |
| | | logService.saveLog(log); |
| | | return true; |
| | | return saveState; |
| | | |
| | | |
| | | |
| | |
| | | |
| | | |
| | | |
| | | |
| | | private static final String[] NUMBERS = {"é¶", "壹", "è´°", "å", "è", "ä¼", "é", "æ", "æ", "ç"}; |
| | | |
| | | private static final String[] IUNIT = {"å
", "æ¾", "ä½°", "ä»", "ä¸", "æ¾", "ä½°", "ä»", "亿", "æ¾", "ä½°", "ä»"}; |
| | |
| | | where order_number=#{orderNumber} and order_id=#{orderId} and delivery_id=#{deliveryId} and delivery_detail_state=0 |
| | | </select> |
| | | |
| | | <select id="getSelectDeliveryDetailDeliveryId" resultMap="selectDelivery"> |
| | | select dd.delivery_id, |
| | | dd.order_number, |
| | | dd.order_id, |
| | | o.project, |
| | | od.product_id, |
| | | od.product_name, |
| | | d.customer_name, |
| | | od.width, |
| | | od.height, |
| | | dd.quantity as dd_quantity, |
| | | od.warehouse_num, |
| | | od.delivery_num, |
| | | d.area, |
| | | od.building_number, |
| | | d.creator, |
| | | dd.delivery_detail_remakes, |
| | | dd.create_time |
| | | from sd.delivery_detail dd |
| | | left join sd.delivery d on dd.delivery_id = d.delivery_id |
| | | left join sd.order_detail od on od.order_id = dd.order_id and dd.order_number = od.order_number |
| | | left join sd.`order` o on o.order_id = dd.order_id |
| | | |
| | | where dd.delivery_id= #{deliveryId} |
| | | |
| | | </select> |
| | | |
| | | |
| | | </mapper> |
| | |
| | | fol.operate_time DESC |
| | | |
| | | </select> |
| | | |
| | | <select id="getSelectStorageRecordDeliveryId" resultMap="selectFinishedGoodsInventory"> |
| | | select fol.id, |
| | | fol.operation_order_number, |
| | | fol.order_id, |
| | | fol.operate_type, |
| | | fol.process_id, |
| | | fol.operation_number, |
| | | fol.quantity, |
| | | fol.operator, |
| | | od.product_id, |
| | | od.product_name, |
| | | od.width, |
| | | od.height, |
| | | fol.operate_time, |
| | | fol.`status`, |
| | | fol.is_state, |
| | | fol.reviewed, |
| | | fol.reviewed_time, |
| | | fol.type, |
| | | fol.remarks |
| | | from (select * |
| | | from mm.finished_operate_log aa where aa.operate_type = #{type} and aa.status!='å·²ä½åº') fol |
| | | left join sd.order_detail od on fol.order_id = od.order_id and fol.operation_number = od.order_number |
| | | left join sd.`order` o on o.order_id=fol.order_id |
| | | where fol.operation_order_number=#{deliveryId} |
| | | </select> |
| | | </mapper> |
| | |
| | | if(a.layout_status=0,'ä¸å¯æç',if(a.layout_status=1,'坿ç','å·²æç')) as layout_status, |
| | | a.merge |
| | | from (select id,order_id,process_id,order_number, quantity,founder,max(layout_status) as layout_status,create_time,merge from flow_card |
| | | group by process_Id,order_number) as a left join sd.`order` as b on a.order_Id=b.order_id |
| | | group by process_Id,order_number) as a |
| | | left join sd.`order` as b on a.order_Id=b.order_id |
| | | left join sd.order_detail as c on a.order_Id=c.order_id and a.order_Number=c.order_number |
| | | where date(a.create_time)>=#{selectTime1} and date(a.create_time) <= #{selectTime2} |
| | | and b.create_order>0 |
| | | <if test="flowCard.orderId != null and flowCard.orderId != ''"> |
| | | and a.order_id regexp #{flowCard.orderId} |
| | | </if> |
| | |
| | | from flow_card as a left join sd.`order` as b on a.order_Id=b.order_id |
| | | left join sd.order_detail as c on a.order_Id=c.order_id and a.order_Number=c.order_number |
| | | where date(a.create_time)>=#{selectTime1} and date(a.create_time) <= #{selectTime2} |
| | | and b.create_order>0 |
| | | <if test="flowCard.orderId != null and flowCard.orderId != ''"> |
| | | and a.order_id regexp #{flowCard.orderId} |
| | | </if> |
| | |
| | | </select> |
| | | |
| | | <select id="selectPrintFlowCard"> |
| | | select project_no,glass_total,glass_total_area,labelPrintNum,processPrintNum |
| | | from pp.optimize_project |
| | | where date(create_time)>=#{selectTime1} and date(create_time) <= #{selectTime2} |
| | | and state >= 20 |
| | | order by create_time desc |
| | | select op.project_no,glass_total,glass_total_area,labelPrintNum,processPrintNum |
| | | from pp.optimize_project as op |
| | | left join pp.flow_card as fc on op.project_no=fc.project_no |
| | | left join sd.`order` as o on o.order_id=fc.order_id |
| | | where date(op.create_time)>=#{selectTime1} and date(op.create_time) <= #{selectTime2} |
| | | and state >= 20 and o.create_order>0 |
| | | GROUP BY op.project_no |
| | | order by op.create_time desc |
| | | </select> |
| | | |
| | | <select id="selectPrintMp"> |
| | |
| | | GROUP_CONCAT(pds.glass_sort SEPARATOR '') AS technology_number, |
| | | ogds.glass_child, |
| | | GROUP_CONCAT(ogds.glass_child SEPARATOR '+') AS concatenated_glass_child, |
| | | SUBSTRING(pds.process, LOCATE('ä¸ç©º', pds.process)) AS processed_part |
| | | SUBSTRING(ogds.process, LOCATE('ä¸ç©º', ogds.process)) AS processed_part |
| | | from sd.order_glass_detail as ogds |
| | | left join sd.order_detail as ods |
| | | on ods.order_id = ogds.order_id and ods.order_number = ogds.order_number |
| | |
| | | fc.quantity, |
| | | round(ogd.total_area, 2) as total_area, |
| | | od.perimeter, |
| | | if(od.shape=2,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04')),od.bend_radius) as bend_radius, |
| | | if(od.bend_radius!=null,od.bend_radius,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04'))) as bend_radius, |
| | | concat(IFNULL(od.processing_note, ''), IFNULL(od.remarks, '')) as remarks, |
| | | od.other_columns, |
| | | round(ogd.child_width) as width, |
| | |
| | | ogd.glass_child, |
| | | #{process} as process, |
| | | JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S01')) AS glassNumber, |
| | | od.bend_radius |
| | | if(od.shape=2,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04')),od.bend_radius) as bend_radius |
| | | FROM flow_card AS fc |
| | | LEFT JOIN sd.order_glass_detail AS ogd ON fc.order_id = ogd.order_id |
| | | AND fc.order_number = ogd.order_number |
| | |
| | | on ogd.order_id = fc.order_id and ogd.order_number = fc.order_number and |
| | | ogd.technology_number = fc.technology_number |
| | | where fc.process_id = #{processId} |
| | | and fc.technology_number = #{technologyNumber} |
| | | and fc.order_number = #{orderNumber} |
| | | group by od.order_number, width, height |
| | | order by fc.process_id |
| | | </select> |
| | |
| | | fc.quantity, |
| | | round(ogd.total_area, 2) as total_area, |
| | | od.perimeter, |
| | | if(od.shape=2,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04')),od.bend_radius) as bend_radius, |
| | | if(od.bend_radius!=null,od.bend_radius,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04'))) as bend_radius, |
| | | concat(IFNULL(od.processing_note, ''), IFNULL(od.remarks, '')) as remarks, |
| | | od.other_columns, |
| | | round(ogd.child_width) as width, |
| | |
| | | sum(pl.patch_num) as quantity, |
| | | round(ogd.total_area, 2) as total_area, |
| | | od.perimeter, |
| | | if(od.shape=2,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04')),od.bend_radius) as bend_radius, |
| | | if(od.bend_radius!=null,od.bend_radius,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04'))) as bend_radius, |
| | | concat(IFNULL(od.processing_note, ''), IFNULL(od.remarks, '')) as remarks, |
| | | od.other_columns, |
| | | round(ogd.child_width) as width, |
| | |
| | | ogd.glass_address as glassAddress, |
| | | JSON_UNQUOTE(JSON_EXTRACT(pd.separation, '$.color')) AS color, |
| | | CONCAT( |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(width AS CHAR))), |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(ogd.child_width AS CHAR))), |
| | | ' X ', |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(height AS CHAR))), |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(ogd.child_height AS CHAR))), |
| | | ' = ',pl.patch_num ) as size, |
| | | |
| | | CONCAT( |
| | | od.order_number,') ', |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(width AS CHAR))), |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(ogd.child_width AS CHAR))), |
| | | ' X ', |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(height AS CHAR))), |
| | | TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(ogd.child_height AS CHAR))), |
| | | ' = ',pl.patch_num ) as numberSize |
| | | from sd.order as o |
| | | left join sd.order_detail as od on o.order_id = od.order_id |
| | |
| | | on e.process_id = c.process_id |
| | | and e.technology_number = c.technology_number |
| | | and e.order_number = c.order_number |
| | | where a.order_id = #{orderId} |
| | | where a.order_id = #{orderId} and d.create_order>0 |
| | | group by c.order_number, |
| | | c.technology_number, |
| | | c.process_id |
| | |
| | | and dd.available = 0 |
| | | and reviewed_state != 2 |
| | | and rw.this_process != dd.responsible_process |
| | | and o.create_order>0 |
| | | <if test="crossProcessBreakingDTO.code != null and crossProcessBreakingDTO.code != ''"> |
| | | and JSON_UNQUOTE( JSON_EXTRACT( od.other_columns, '$.S01' )) regexp #{crossProcessBreakingDTO.code} |
| | | </if> |
| | |
| | | GROUP BY a.process_id,a.teams_groups_name,a.next_process,b.order_number,b.technology_number |
| | | ) as rws on rws.process_id=fc.process_id and rws.order_number=fc.order_number |
| | | and rws.technology_number=fc.technology_number and rws.next_process=#{selectProcesses} |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpds.reporting_work_num_count + ifnull(c.patchNumSum, 0) - odpd.reporting_work_num_count - |
| | | odpd.broken_num != 0 |
| | | and odpd.process = #{selectProcesses} |
| | |
| | | GROUP BY a.process_id,a.teams_groups_name,a.next_process,b.order_number,b.technology_number |
| | | ) as rws on rws.process_id=fc.process_id and rws.order_number=fc.order_number |
| | | and rws.technology_number=fc.technology_number and rws.next_process=#{selectProcesses} |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpds.reporting_work_num_count + ifnull(c.patchNumSum, 0) - odpd.reporting_work_num_count - |
| | | odpd.broken_num != 0 |
| | | and odpd.process = #{selectProcesses} |
| | |
| | | and odpd.process_id = fc.process_id |
| | | left join sd.`order` as o |
| | | on o.order_id = od.order_id |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpd.process = #{selectProcesses} |
| | | and o.create_time >= #{selectTime1} |
| | | AND o.create_time < #{selectTime2} |
| | |
| | | AND rw.reporting_work_time < #{selectTime2} |
| | | |
| | | AND dd.available = 0 |
| | | AND LENGTH( rw.process_id )= 14 |
| | | <if test="damageReportDTO.orderId != null and damageReportDTO.orderId != ''"> |
| | | and o.order_id regexp #{damageReportDTO.orderId} |
| | | </if> |
| | |
| | | rw.reporting_work_time >= #{selectTime1} |
| | | AND rw.reporting_work_time < #{selectTime2} |
| | | AND dd.available = 0 |
| | | AND LENGTH( rw.process_id )= 14 |
| | | <if test="damageReportDTO.orderId != null and damageReportDTO.orderId != ''"> |
| | | and o.order_id regexp #{damageReportDTO.orderId} |
| | | </if> |
| | |
| | | AND opd.technology_number = fc.technology_number |
| | | |
| | | WHERE DATE_FORMAT((o.create_time), '%Y-%m-%d') BETWEEN #{selectTime1} and #{selectTime2} |
| | | |
| | | and o.create_order>0 |
| | | GROUP BY o.order_id, |
| | | fc.order_number, |
| | | fc.technology_number |
| | |
| | | AND opd.order_number = fc.order_number |
| | | AND opd.technology_number = fc.technology_number |
| | | WHERE opd.reporting_work_num > 0 |
| | | and o.create_order>0 |
| | | and DATE_FORMAT((o.create_time), '%Y-%m-%d') BETWEEN #{selectTime1} and #{selectTime2} |
| | | AND position(#{selectProcesses} IN opd.process) |
| | | GROUP BY opd.process, o.order_id |
| | |
| | | and e.order_number=c.order_number |
| | | and e.technology_number = c.technology_number |
| | | left join sd.delivery_detail as dd on dd.order_id = a.order_id and dd.order_number = a.order_number |
| | | where a.order_id = #{orderId} |
| | | where a.order_id = #{orderId} and d.create_order>0 |
| | | group by c.order_number,c.technology_number |
| | | ORDER BY a.order_number |
| | | </select> |
| | |
| | | left join sd.delivery_detail as dd on dd.order_id = a.order_id and dd.order_number = a.order_number |
| | | where d.create_time >= #{selectTime1} |
| | | AND d.create_time < #{selectTime2} |
| | | and o.create_order>0 |
| | | and reportWorkQuantity is not null |
| | | GROUP BY a.order_id |
| | | ORDER BY a.order_id |
| | |
| | | AND rw.process_id = fc.process_id |
| | | WHERE o.create_time >= #{selectTime1} |
| | | AND o.create_time < #{selectTime2} |
| | | and o.create_order>0 |
| | | AND fc.create_time IS NOT NULL |
| | | GROUP BY o.order_id |
| | | </select> |
| | |
| | | WHERE date(rw.reporting_work_time) >= #{dates[0]} |
| | | and date(rw.reporting_work_time) <= #{dates[1]} |
| | | AND dd.available = 0 |
| | | AND LENGTH(rw.process_id) = 14 |
| | | GROUP BY dd.id |
| | | </select> |
| | | |
| | |
| | | AND rw.process_id = fc.process_id |
| | | WHERE date(o.create_time) >= #{dates[0]} |
| | | and date(o.create_time) <= #{dates[1]} |
| | | and o.create_order>0 |
| | | AND fc.create_time IS NOT NULL |
| | | GROUP BY o.order_id |
| | | </select> |
| | |
| | | and odpd.process_id = fc.process_id |
| | | left join sd.`order` as o |
| | | on o.order_id = od.order_id |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpd.process = #{process} |
| | | and date(o.create_time) >= #{date[0]} |
| | | and date(o.create_time) <= #{date[1]} |
| | |
| | | and c.technology_number = fc.technology_number |
| | | left join sd.`order` as o |
| | | on o.order_id = od.order_id |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpds.reporting_work_num_count + ifnull(c.patchNumSum, 0) - odpd.reporting_work_num_count - |
| | | odpd.broken_num != 0 |
| | | and odpd.process = #{process} |
| | |
| | | where d.create_time |
| | | and date(o.create_time) >= #{dates[0]} |
| | | and date(o.create_time) <= #{dates[1]} |
| | | and d.create_order>0 |
| | | and reportWorkQuantity is not null |
| | | GROUP BY a.order_id |
| | | ORDER BY a.order_id |
| | |
| | | |
| | | WHERE date(o.create_time) >= #{dates[0]} |
| | | and date(o.create_time) <= #{dates[1]} |
| | | and o.create_order>0 |
| | | GROUP BY o.order_id, |
| | | fc.order_number, |
| | | fc.technology_number |
| | |
| | | WHERE opd.reporting_work_num > 0 |
| | | and date(o.create_time) >= #{date[0]} |
| | | and date(o.create_time) <= #{date[1]} |
| | | and o.create_order>0 |
| | | AND position(#{process} IN opd.process) |
| | | GROUP BY opd.process, o.order_id |
| | | </select> |
| | |
| | | GROUP BY a.process_id,a.teams_groups_name,a.next_process,b.order_number,b.technology_number |
| | | ) as rws on rws.process_id=fc.process_id and rws.order_number=fc.order_number |
| | | and rws.technology_number=fc.technology_number and rws.next_process=#{selectProcesses} |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpds.reporting_work_num_count + ifnull(c.patchNumSum, 0) - odpd.reporting_work_num_count - |
| | | odpd.broken_num != 0 |
| | | and odpd.process = #{selectProcesses} |
| | |
| | | GROUP BY a.process_id,a.teams_groups_name,a.next_process,b.order_number,b.technology_number |
| | | ) as rws on rws.process_id=fc.process_id and rws.order_number=fc.order_number |
| | | and rws.technology_number=fc.technology_number and rws.next_process=#{selectProcesses} |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpds.reporting_work_num_count + ifnull(c.patchNumSum, 0) - odpd.reporting_work_num_count - |
| | | odpd.broken_num != 0 |
| | | and odpd.process = #{selectProcesses} |
| | |
| | | GROUP BY a.process_id,a.teams_groups_name,a.next_process,b.order_number,b.technology_number |
| | | ) as rws on rws.process_id=fc.process_id and rws.order_number=fc.order_number |
| | | and rws.technology_number=fc.technology_number and rws.next_process=#{selectProcesses} |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpds.reporting_work_num_count + ifnull(c.patchNumSum, 0) - odpd.reporting_work_num_count - |
| | | odpd.broken_num != 0 |
| | | and odpd.process = #{selectProcesses} |
| | |
| | | GROUP BY a.process_id,a.teams_groups_name,a.next_process,b.order_number,b.technology_number |
| | | ) as rws on rws.process_id=fc.process_id and rws.order_number=fc.order_number |
| | | and rws.technology_number=fc.technology_number and rws.next_process=#{selectProcesses} |
| | | where LENGTH(fc.process_id) = 14 |
| | | where o.create_order>0 |
| | | and odpds.reporting_work_num_count + ifnull(c.patchNumSum, 0) - odpd.reporting_work_num_count - |
| | | odpd.broken_num != 0 |
| | | and odpd.process = #{selectProcesses} |
| | |
| | | where processes = #{processes} |
| | | GROUP BY order_id, order_number) as ps |
| | | left join sd.`order` as o on o.order_id = ps.order_id |
| | | where ps.processes = #{processes} |
| | | where ps.processes = #{processes} and o.create_order>0 |
| | | and DATE_FORMAT((ps.scheduled_start_time), '%Y-%m-%d') between #{selectTime1} and #{selectTime2} |
| | | <if test="scheduleProductionScheduleDTO.orderId != null and scheduleProductionScheduleDTO.orderId != ''"> |
| | | and ps.order_id regexp #{scheduleProductionScheduleDTO.orderId} |
| | |
| | | where processes = #{processes} |
| | | GROUP BY order_id, order_number) as ps |
| | | left join sd.`order` as o on o.order_id = ps.order_id |
| | | where ps.processes = #{processes} |
| | | where ps.processes = #{processes} and o.create_order>0 |
| | | and DATE_FORMAT((ps.scheduled_start_time), '%Y-%m-%d') between #{selectTime1} and #{selectTime2} |
| | | <if test="scheduleProductionScheduleDTO.orderId != null and scheduleProductionScheduleDTO.orderId != ''"> |
| | | and ps.order_id regexp #{scheduleProductionScheduleDTO.orderId} |
| | |
| | | where processes = #{process} |
| | | GROUP BY order_id, order_number) as ps |
| | | left join sd.`order` as o on o.order_id = ps.order_id |
| | | where ps.processes = #{process} |
| | | where ps.processes = #{process} and o.create_order>0 |
| | | and date(scheduled_start_time) >= #{date[0]} |
| | | and date(scheduled_start_time) <= #{date[1]} |
| | | GROUP BY ps.order_id, ps.processes |
| | |
| | | where fc.process_id = #{processIdStr} |
| | | and POSITION(fc.technology_number in #{technologyStr}) |
| | | and if(#{reportType}=1,o.order_type!='æ ·å订å',o.order_id!='') |
| | | and o.create_order>0 |
| | | GROUP BY fc.process_id |
| | | </select> |
| | | |
| | |
| | | AND POSITION(fc.technology_number in #{technologyStr}) |
| | | AND odpd.process = #{process} |
| | | and if(#{reportType}=1,o.order_type!='æ ·å订å',o.order_id!='') |
| | | and o.create_order>0 |
| | | group by fc.order_number, |
| | | ogd.technology_number |
| | | order by fc.order_number |
| | |
| | | left join (select * from sd.order_glass_detail group by order_id,order_number) as ogd |
| | | on rw.order_id = ogd.order_id and dd.order_number = ogd.order_number |
| | | |
| | | where dd.breakage_quantity-dd.quantity>0 and dd.available=1 and o.create_order>0 order by dd.id desc |
| | | where dd.breakage_quantity-dd.quantity>0 and dd.available=1 and o.create_order>0 and rw.reviewed_state>=0 |
| | | order by dd.id desc |
| | | </select> |
| | | |
| | | |
| | |
| | | from sd.order_detail as od |
| | | left join `order` as o |
| | | on o.order_id=od.order_id |
| | | where o.production_order!=2 and o.order_review=2 |
| | | where o.production_order!=2 and o.order_review=2 and o.create_order>0 |
| | | |
| | | <if test="orderGlassDetail.orderId != null and orderGlassDetail.orderId != ''"> |
| | | and o.order_id regexp #{orderGlassDetail.orderId} |