guoyuji
2024-10-18 eef4b7ca66cc2fb34d2d2cb0a4a8643f2bb0f838
Merge branch 'master' of http://10.153.19.25:10101/r/ERP_override
18个文件已修改
146 ■■■■■ 已修改文件
north-glass-erp/northglass-erp/src/components/pp/TagStyle.vue 3 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/components/sd/delivery/PrintSheet1.vue 24 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/components/sd/delivery/PrintSheet2.vue 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/lang/en.js 23 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/lang/ru.js 42 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/lang/zh.js 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/mm/ingredient/SelectIngredients.vue 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/mm/ingredientStock/CreateOutBound.vue 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/mm/ingredientStock/ReturnToStorageCreate.vue 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/mm/productStock/CreateProductStock.vue 8 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/mm/productStock/FinishedProductOut.vue 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/pp/processCard/AddProcessCard.vue 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/pp/processCard/PrintProjectDetails.vue 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/sd/delivery/CreateDelivery.vue 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/sd/delivery/SelectDelivery.vue 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/views/sd/order/CreateOrder.vue 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/src/main/resources/mapper/sd/OrderMapper.xml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
north-glass-erp/northglass-erp/src/components/pp/TagStyle.vue
@@ -52,7 +52,8 @@
  filmNumber:'产品备注',
  bendRadius:'order.bendRadius',
  glassChild:'reportingWorks.glassChild',
  glassAddress:'replenish.sliceMarking'
  glassAddress:'replenish.sliceMarking',
  quantity:'工程用数量'
north-glass-erp/northglass-erp/src/components/sd/delivery/PrintSheet1.vue
@@ -206,10 +206,10 @@
            <tr class="day-in">
              <td style="text-align: left;border-width: 0 1px 0 0; border-style: solid; border-color: #d3dce6" colspan="4">
                <div style="display: flex;font-size: 10px;text-align: center;">
                  <div style="width: 25%">加工费用</div>
                  <div  style="width: 25%">单价</div>
                  <div  style="width: 25%">数量</div>
                  <div  style="width: 25%">金额</div>
                  <span style="width: 25%">加工费用</span>&nbsp;
                  <span  style="width: 25%">单价</span>&nbsp;
                  <span  style="width: 25%">数量</span>&nbsp;
                  <span  style="width: 25%">金额</span>
                </div>
              </td>
              <td style="text-align: left;border:none;font-size: 15px;" colspan="5">总金额:&nbsp;&nbsp;&nbsp;&nbsp;{{delivery.money}}</td>
@@ -217,16 +217,16 @@
            <tr class="day-in">
              <td style="text-align: left;border-width: 0 1px 0 0; border-style: solid; border-color: #d3dce6;" colspan="4" >
                <div style="display: flex;font-size: 10px;text-align: center" v-for="(item, index2) in otherMoney1" :key="index2">
                  <div style="width: 25%">{{item.DeliveryDetailOtherMoney.alias}}</div>
                  <div  style="width: 25%">{{item.DeliveryDetailOtherMoney.price}}</div>
                  <div  style="width: 25%">{{item.DeliveryDetailOtherMoney.count}}</div>
                  <div  style="width: 25%">{{parseFloat(item.DeliveryDetailOtherMoney.monery.toFixed(2))}}</div>
                  <span style="width: 25%">{{item.DeliveryDetailOtherMoney.alias}}</span>&nbsp;
                  <span  style="width: 25%">{{item.DeliveryDetailOtherMoney.price}}</span>&nbsp;
                  <span  style="width: 25%">{{item.DeliveryDetailOtherMoney.count}}</span>&nbsp;
                  <span  style="width: 25%">{{parseFloat(item.DeliveryDetailOtherMoney.monery.toFixed(2))}}</span>
                </div>
                <div style="display: flex;font-size: 10px;text-align: center" v-if="delivery.freight>0">
                  <div style="width: 25%">运费</div>
                  <div  style="width: 25%">{{delivery.freightPrice}}</div>
                  <div  style="width: 25%">{{delivery.freightQuantity}}</div>
                  <div  style="width: 25%">{{delivery.freight}}</div>
                  <span style="width: 25%">运费</span>&nbsp;
                  <span  style="width: 25%">{{delivery.freightPrice}}</span>&nbsp;
                  <span  style="width: 25%">{{delivery.freightQuantity}}</span>&nbsp;
                  <span  style="width: 25%">{{delivery.freight}}</span>
                </div>
              </td>
              <td style="text-align: left;border:none;font-size: 15px;" colspan="5">大写金额:&nbsp;&nbsp;&nbsp;&nbsp;{{money}}</td>
north-glass-erp/northglass-erp/src/components/sd/delivery/PrintSheet2.vue
@@ -98,7 +98,7 @@
    <table >
      <thead>
      <tr class="title-s">
        <th colspan="13">
        <th colspan="9">
          <h1>
            {{company.companyName}}
          </h1>
north-glass-erp/northglass-erp/src/lang/en.js
@@ -92,6 +92,8 @@
            noProductDataInTheTable:'There is no product data in the table',
            tableDataExceedsMaximumLimit:'The table data exceeds the maximum limit',
            range9999Dec: "Please enter a four digit integer",
            quantityError: "数量错误,请刷新再保存",
            dataDoesNotExist: "数据不存在",
        }
    },
    product:{
@@ -218,6 +220,7 @@
        areaAmountPerPiece:'Area amount (single piece)',
        areaAmountAge:'Area amount (total area)',
        errorValue:'Error value',
        details:'Details',
        workmanship:'Technology',
        processCard:'Flow card',
@@ -244,6 +247,7 @@
        oneClickStorage:'One-click completion',
        quantityMount:'Quantity and Amount',
        msg:{
            productCheck:'Please select a product',
            tableLengthNot:'No table data',
@@ -335,7 +339,8 @@
    workOrder:{
        page:{
            selectWorkOrder:'Work order'
            selectWorkOrder:'Work order',
            addWorkOrder:'转生产订单'
        },
        productionId:'Production Order Number',
        convert:'Convert',
@@ -445,7 +450,9 @@
        labelPrinting2:'Label printing 2',
        addAutomatically:'Auto fill',
        selectFill:'Selected fill',
        engineeringPrinting:'Engineering Printing'
        engineeringPrinting:'Engineering Printing',
        mergeState:'合并状态',
    },
    reportingWorks:{
        page:{
@@ -554,7 +561,6 @@
        pleaseNumber9:'Correct number of completions or breakdowns',
    },
    productStock:{
        page:{
            productStockList:"Stock Inquiry",
@@ -641,7 +647,6 @@
        singlePieceArea:'Single Piece Area',
        perimeter:'Perimeter',
        returnToWarehouse:'Return To Warehouse',
        entryFailure:'Put in storage failure',
        entry:'Put in storage',
        failedToRetrieve:'Take out failure',
@@ -655,10 +660,12 @@
        staterOperationOrderNumber:'Transfer the sales order number',
        endOperationOrderNumber:'Transfer sequence number',
        typeClaim:'Take out type',
        pleaseEnterTheBoxNumber:'Please enter the box number',
        boxNumber:'箱号',
        msg1:'发货单已出库请刷新界面',
        msg2:'发货单库存数不存在',
        msg3:'入库数量不能超过订单总数'
    },
    customer:{
        page:{
@@ -733,7 +740,6 @@
        freightPrice:'Freight Price',
        freightQuantity:'Freight Quantity',
        freight:'Freight Money',
        pleaseMsg1:'订单存在其他金额单价没有填写',
    },
@@ -777,6 +783,7 @@
            roleList:'Role Home',
        },
        id:'ID',
        characterHomepage:'角色首页',
        role:'Character',
        roleAdd:'Role addition',
        menu:'Menu',
@@ -986,6 +993,7 @@
        films :'Coating Type',
        pleaseEnterData :'Please enter data',
        pleaseEnter :'Please enter',
        msg1 :'库存已存在此物料不能删除',
    },
    ingredientsStock:{
        page:{
@@ -1039,6 +1047,7 @@
        surplusMaterialManagement :'余料管理',
        additionOfSurplusMaterials :'余料新增',
        excessMaterialOutflow :'余料出库',
        pleaseSelectTheTypeOfReturnToStock:'请选择返库类型'
    },
    warehouseBasicData:{
        page:{
north-glass-erp/northglass-erp/src/lang/ru.js
@@ -64,6 +64,10 @@
        false:'否',
        computedSize:'科学计数',
        paste:'粘贴',
        selected:'选中',
        partiallySelected:'部分选中',
        unchecked :'未选中',
        msg:{
            max255:"Введите 255 символов.",
            range99999Dec2:
@@ -88,6 +92,8 @@
            noProductDataInTheTable:'Данные о продуктах отсутствуют в таблице',
            tableDataExceedsMaximumLimit:'Данные таблицы превышают максимальный лимит',
            range9999Dec: "Введите четыре целых числа.",
            quantityError: "数量错误,请刷新再保存",
            dataDoesNotExist: "数据不存在",
        }
    },
    product:{
@@ -241,6 +247,7 @@
        oneClickStorage:'一键完工',
        quantityMount:'数量金额',
        msg:{
            productCheck:'Пожалуйста, выберите продукт',
            tableLengthNot:'Нет данных таблицы',
@@ -332,7 +339,8 @@
    workOrder:{
        page:{
            selectWorkOrder:'Управление рабочей документацией'
            selectWorkOrder:'Управление рабочей документацией',
            addWorkOrder:'转生产订单'
        },
        productionId:'Номер производственного заказа',
        convert:'Переведено',
@@ -443,7 +451,9 @@
        labelPrinting2:'标签打印2',
        addAutomatically:'自动填充',
        selectFill:'自动填充',
        engineeringPrinting:'Инженерная печать'
        engineeringPrinting:'Инженерная печать',
        mergeState:'合并状态',
    },
    reportingWorks:{
        page:{
@@ -550,9 +560,7 @@
        pleaseNumber7:'*количество не может превышать количество процессов.',
        pleaseNumber8:'Введите серийный номер.',
        pleaseNumber9:'Правильное завершение и количество поврежденных',
    },
    productStock:{
        page:{
            productStockList:"Инвентаризация",
@@ -639,7 +647,6 @@
        singlePieceArea:'Площадь монолитного стекла',
        perimeter:'Внешний край',
        returnToWarehouse:'Отмена',
        entryFailure:'Ошибка входа в хранилище',
        entry:'Доступ на склад',
        failedToRetrieve:'Получить неудачу',
@@ -653,18 +660,18 @@
        staterOperationOrderNumber:'Номер продажаа на завершение операции',
        endOperationOrderNumber:'Номер заказа на завершение операции',
        typeClaim:'Тип получения',
        pleaseEnterTheBoxNumber:'请输入箱号',
        boxNumber:'箱号',
        msg1:'发货单已出库请刷新界面',
        msg2:'发货单库存数不存在',
        msg3:'入库数量不能超过订单总数'
    },
    customer:{
        page:{
            selectCustomer:'Главная страница Клиенты',
            createCustomer:'Увеличение числа клиентов',
            selectCustomerOrder:'Заказ клиента',
            createDelivery:'Создание отправки',
            deliveryReport:'Отчет о доставке',
        },
        pleaseEnterTheCustomerName:'Введите имя клиента',
        pleaseEnterCustomerLevel:'Введите уровень клиента.',
@@ -687,6 +694,14 @@
        pleaseEnterTheCustomerAbbreviation:'Пожалуйста, введите сокращение клиента.',
    },
    delivery:{
        page:{
            selectDelivery:'发货首页',
            selectOrderList:"订单发货 ",
            shipmentDetailsReport:"发货明细报表 ",
            shipmentProductClassificationReport:"发货产品分类报表 ",
            createDelivery:'发货创建',
            deliveryReport:'发货报表'
        },
        delivery:'Отправка',
        place :'Выписать заказ',
        technology:'Технология',
@@ -711,13 +726,9 @@
        shippingAddress:'Адрес доставки',
        deliveryReportDate:'Дата отгрузки',
        shipper:'Грузоотправитель',
        shippingHomepage:'Отправка Начальная страница',
        orderShipment:'Отправка заказов',
        deliveryNoteId:'Номер накладной',
        deliveryNoteNumber:'Номер отгрузки',
        deliveryDate:'Дата отгрузки',
        shipmentDetailsReport:'Спецификация отгрузки',
        shipmentProductClassificationReport:'Отчет о классификации отгруженной продукции',
        contacts:'Контактные лица',
        contactNumber:'Контактный телефон',
        salesman:'Продаж',
@@ -728,6 +739,7 @@
        freightPrice:'运费单价',
        freightQuantity:'运费数量',
        freight:'运费金额',
        pleaseMsg1:'订单存在其他金额单价没有填写',
    },
    replenish:{
@@ -736,6 +748,7 @@
            addReplenish:"Дополнительное стекло",
            printReplenishFlowCard:"Печать стеклянных пластин"
        },
        patchManagement:'Управление стеклянными пластинами',
        addPatches:'Дополнительное стекло',
        printPatches:'Печать стеклянных пластин',
@@ -919,6 +932,7 @@
        TaskCompletionStatus:'Ведомость выполнения мандата',
        rawMaterialRequisition:'Отчет о получении оригинального стекла',
        qualityReport:'Отчет о качестве',
        productionScheduling:'排产计划报表',
        yieldReport:'Отчет о готовой продукции',
        workingProcedure:'Операции',
        inventoryArea:'Складская площадь',
@@ -979,6 +993,7 @@
        films :'Тип покрытие',
        pleaseEnterData :'Введите данные.',
        pleaseEnter :'Введите',
        msg1 :'库存已存在此物料不能删除',
    },
    ingredientsStock:{
        page:{
@@ -1032,6 +1047,7 @@
        surplusMaterialManagement :'余料管理',
        additionOfSurplusMaterials :'余料新增',
        excessMaterialOutflow :'余料出库',
        pleaseSelectTheTypeOfReturnToStock:'请选择返库类型'
    },
    warehouseBasicData:{
        page:{
north-glass-erp/northglass-erp/src/lang/zh.js
@@ -92,6 +92,8 @@
            noProductDataInTheTable:'表格中无产品数据',
            tableDataExceedsMaximumLimit:'表格数据超过最大限制',
            range9999Dec: "请输入四位整数",
            quantityError: "数量错误,请刷新再保存",
            dataDoesNotExist: "数据不存在",
        }
    },
    product:{
@@ -659,7 +661,11 @@
        endOperationOrderNumber:'调拨序号',
        typeClaim:'领出类型',
        pleaseEnterTheBoxNumber:'请输入箱号',
        boxNumber:'箱号'
        boxNumber:'箱号',
        msg1:'发货单已出库请刷新界面',
        msg2:'发货单库存数不存在',
        msg3:'入库数量不能超过订单总数'
    },
    customer:{
        page:{
@@ -987,6 +993,7 @@
        films :'膜系',
        pleaseEnterData :'请输入数据',
        pleaseEnter :'请输入',
        msg1 :'库存已存在此物料不能删除',
    },
    ingredientsStock:{
        page:{
@@ -1040,6 +1047,7 @@
        surplusMaterialManagement :'余料管理',
        additionOfSurplusMaterials :'余料新增',
        excessMaterialOutflow :'余料出库',
        pleaseSelectTheTypeOfReturnToStock:'请选择返库类型'
    },
    warehouseBasicData:{
        page:{
north-glass-erp/northglass-erp/src/views/mm/ingredient/SelectIngredients.vue
@@ -30,7 +30,7 @@
          ElMessage.success(t('basicData.msg.deleteSuccess'))
          router.push({path:'/main/ingredients/SelectIngredients',query:{random:Math.random()}})
        }else if(res.data==="false1"){
          ElMessage.warning("库存已存在此物料不能删除")
          ElMessage.warning(t('ingredients.msg1'))
        }else{
          ElMessage.warning(t('basicData.msg.deleteFail'))
        }
north-glass-erp/northglass-erp/src/views/mm/ingredientStock/CreateOutBound.vue
@@ -321,7 +321,7 @@
              ElMessage.success(t('basicData.msg.saveSuccess'))
              router.push({path: '/main/ingredientsStock/MaterialOutbound', query:{random:Math.random()}})
            }else if(res.data==="false1"){
              ElMessage.warning("数量错误,请刷新再保存")
              ElMessage.warning(t('basicData.msg.quantityError'))
            }else{
              ElMessage.warning(t('basicData.msg.saveFail'))
            }
north-glass-erp/northglass-erp/src/views/mm/ingredientStock/ReturnToStorageCreate.vue
@@ -303,7 +303,7 @@
          //表头数据校验
          const returningType = titleUploadData.value.returningType
          if(returningType === null || returningType === undefined || returningType === ''){
            ElMessage.error("请选择返库类型")
            ElMessage.error(t('ingredientsStock.pleaseSelectTheTypeOfReturnToStock'))
            return
          }
          const materialRequisitionPersonnel = titleUploadData.value.materialRequisitionPersonnel
north-glass-erp/northglass-erp/src/views/mm/productStock/CreateProductStock.vue
@@ -284,9 +284,9 @@
                ElMessage.success(t('productStock.receivedSuccessfully'))
                router.push({path:'/main/productStock/CreateProductStock',query:{random:Math.random()}})
              }else if(res.data==="false1"){
                ElMessage.warning("库存数量不对请刷新界面")
                ElMessage.warning(t('basicData.msg.quantityError'))
              }else if(res.data==="false2"){
                ElMessage.warning("数据不存在")
                ElMessage.warning(t('basicData.msg.dataDoesNotExist'))
              }else{
                ElMessage.warning(t('productStock.entryFailure'))
              }
@@ -315,11 +315,11 @@
  "inventoryQuantity": [{
    validator (e) {
      if ((parseInt(e.row.inventoryQuantity) + e.row.receivedQuantity) > e.row.orderDetail.quantity) {
        return new Error('入库数量不能超过订单总数')
        return new Error(t('productStock.msg3'))
      }
      const regex = /^[1-9]\d*$/g
      if ( !regex.test(e.row.inventoryQuantity) ) {
        return new Error('输入不为0的数')
        return new Error(t('basicData.msg.greater0'))
      }
    }
north-glass-erp/northglass-erp/src/views/mm/productStock/FinishedProductOut.vue
@@ -290,9 +290,9 @@
                ElMessage.success(t('productStock.deliverySuccessful'))
                router.push({path: '/main/productStock/FinishedProductOut', query: {random: Math.random()}})
              }else if (res.data==="false1") {
                ElMessage.warning("发货单已出库请刷新界面")
                ElMessage.warning(t('productStock.msg1'))
              }else if (res.data==="false2") {
                ElMessage.warning("发货单库存数不存在")
                ElMessage.warning(t('productStock.msg2'))
              }else {
                ElMessage.warning(t('productStock.deliveryFailed'))
              }
north-glass-erp/northglass-erp/src/views/pp/processCard/AddProcessCard.vue
@@ -750,11 +750,13 @@
            let leftData = $tableRight.getTableData().fullData
            if (selectRecords.length === 0) {
              ElMessage.warning(t('processCard.pleaseSelectTheSavedDataFirst'))
              gridLeftOptions.toolbarConfig.buttons[0].disabled=false
              return
            }
            if (leftData.length > 0) {
              ElMessage.warning(t('processCard.pleaseFirstCreateAProcessCardForAllTheDataOnTheRightSideAndSaveIt'))
              gridLeftOptions.toolbarConfig.buttons[0].disabled=false
              return;
            }
            let flowCardData = ref({
north-glass-erp/northglass-erp/src/views/pp/processCard/PrintProjectDetails.vue
@@ -547,7 +547,7 @@
          }
          labelRow.value.list = JSON.stringify(selectRecords)
          labelRow.value.type = '恒鑫'
          labelRow.value.type = '恒鑫带数量'
          labelRow.value.dataType=3
          dialogTableVisibleLabelXJTwo.value = true
north-glass-erp/northglass-erp/src/views/sd/delivery/CreateDelivery.vue
@@ -435,9 +435,9 @@
             }else if(res.data==="false1"){
               ElMessage.warning(t('delivery.pleaseMsg1'))
             }else if(res.data==="false2"){
               ElMessage.warning("订单存在已发货请刷新界面")
               ElMessage.warning(t('basicData.msg.quantityError'))
             }else if(res.data==="false3"){
               ElMessage.warning("数据不存在")
               ElMessage.warning(t('basicData.msg.dataDoesNotExist'))
             }else{
               ElMessage.warning(t('basicData.msg.saveFail'))
             }
north-glass-erp/northglass-erp/src/views/sd/delivery/SelectDelivery.vue
@@ -14,6 +14,7 @@
import PrintSheet1 from "@/components/sd/delivery/PrintSheet1.vue";
import PrintSheet2 from "@/components/sd/delivery/PrintSheet2.vue";
import useOrderInfoStore from "@/stores/sd/order/orderInfo";
import { saveAs } from "file-saver"
//语言获取
const { t } = useI18n()
@@ -329,6 +330,12 @@
    })
}
const exportFile = ()=>{
  const html = document.getElementById("child").innerHTML // 获取需要导出的HTML内容
  const blob = new Blob([html], { type: 'application/vnd.ms-excel' }) // 创建Blob对象
  saveAs(blob, rowClickIndex.value.deliveryId+".xls");
}
@@ -436,6 +443,7 @@
    >
      <template #header="{ close, titleId, titleClass }">
        <el-button v-print="printContent" @click="printingNumber"  :icon="Printer" circle />
        <el-button @click="exportFile" :icon="Download" circle />
      </template>
      <print-sheet1 id="child"  v-if="sheetIndex===1" :deliveryId="rowClickIndex.deliveryId" />
      <print-sheet2 id="child"  v-if="sheetIndex===2" :deliveryId="rowClickIndex.deliveryId" />
north-glass-erp/northglass-erp/src/views/sd/order/CreateOrder.vue
@@ -159,6 +159,7 @@
    {field: 'grossArea',width:160,  title: t('order.trueGrossArea'),filters:[{ data: '' }],slots: { filter: 'num1_filter'}, sortable: true,filterMethod:filterChanged},
    {field: 'computeArea',width:180,  title: t('order.computeArea'),editRender: { name: 'input'},filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged},
    {field: 'computeGrossArea',width:200,  title: t('order.computeGrossArea'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged},
    {field: 'perimeter',width:200,  title: t('order.perimeter'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged},
    {field: 'shape',width:120,
      title: t('order.shape'),
      editRender: { name: 'input'},
north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml
@@ -736,7 +736,7 @@
        (select (@row_number := @row_number + 1) as id,process_id as process_id from (select process_id from pp.optimize_detail tt where project_no =#{projectNo} group by process_id) tt,(select @row_number := 0) as t) a
        on a.process_id=opd.process_id
        where opd.project_no = #{projectNo}
        order by opd.stock_id
        order by opd.stock_id,opd.polys_id
    </select>
    <select id="getPrintLabel2">
@@ -2114,7 +2114,8 @@
               '文本' as custom2,
               '文本' as custom3,
               '文本' as custom4,
               '文本' as custom5
               '文本' as custom5,
               od.quantity
        from sd.order as o
                 left join sd.order_detail as od on o.order_id = od.order_id
                 left join flow_card as fc on o.order_id = fc.order_id and
north-glass-erp/src/main/resources/mapper/sd/OrderMapper.xml
@@ -10,7 +10,7 @@
        from
            sd.`order` as o
        where
            o.quantity=#{order.quantity} and o.area=#{order.area} and o.project=#{order.project} and o.customer_id=#{order.customerId}
            o.quantity=#{order.quantity} and o.area=#{order.area} and trim(o.project)=trim(#{order.project}) and o.customer_id=#{order.customerId}
    </select>
    <select id="selectMaxOrderId">