优化盘点逻辑

dengjunjie

4 天以前 1b8daa902b075c7cedee7bbcc13b914b7a5b4ad4

 н¨Îļþ¼Ð/WMS/src/views/stock/Dt_Inventory_Batch.vue

@@ -1,7 +1,15 @@
<template>
  <view-grid ref="grid" :columns="columns" :detail="detail" :editFormFields="editFormFields"
    :editFormOptions="editFormOptions" :searchFormFields="searchFormFields" :searchFormOptions="searchFormOptions"
    :table="table" :extend="extend">
  <view-grid
    ref="grid"
    :columns="columns"
    :detail="detail"
    :editFormFields="editFormFields"
    :editFormOptions="editFormOptions"
    :searchFormFields="searchFormFields"
    :searchFormOptions="searchFormOptions"
    :table="table"
    :extend="extend"
  >
  </view-grid>
</template>
<script>
@@ -30,6 +38,7 @@
      productionDate: "",
      validityPeriod: "",
      remark: "",
      availableQuantity: "",
    });
    const editFormOptions = ref([
      [
@@ -39,18 +48,14 @@
          field: "materielCode",
          type: "string",
        },
      ],
      [
        {
          title: "物料名称",
          required: true,
          field: "materielName",
          type: "string",
        },
        {
          title: "物料规格",
          required: true,
          field: "materielSpec",
          type: "string",
        }
      ],
      [
        {
@@ -59,61 +64,15 @@
          field: "batchNo",
          type: "string",
        },
      ],
      [
        {
          title: "库存数",
          title: "调拨数量",
          required: true,
          field: "stockQuantity",
          type: "number",
        },
        {
          title: "待出库数",
          required: true,
          field: "outboundQuantity",
          type: "number",
        }
      ],
      [
        {
          title: "盘点数",
          required: true,
          field: "supplyQuantity",
          type: "number",
        },
        {
          title: "ERP实际库存数",
          required: true,
          field: "erpStockQuantity",
          type: "number",
        },
        {
          title: "库存差异",
          field: "status",
          type: "select",
          bind: { key: "stockDifference", data: [] }
        }
      ],
      [
        {
          title: "生产日期",
          field: "productionDate",
          type: "date",
          span: 12
        },
        {
          title: "有效期至",
          field: "validityPeriod",
          type: "date",
          span: 12
        }
      ],
      [
        {
          title: "备注",
          field: "remark",
          type: "string",
          span: 24
        }
      ]
    ]);
    const searchFormFields = ref({
      materielCode: "",
@@ -122,9 +81,9 @@
    });
    const searchFormOptions = ref([
      [
        { title: "物料编号", field: "materielCode" },
        { title: "物料名称", field: "materielName" },
        { title: "批次号", field: "batchNo" },
        { title: "物料编号", field: "materielCode", type: "like" },
        { title: "物料名称", field: "materielName", type: "like" },
        { title: "批次号", field: "batchNo", type: "like" },
      ],
    ]);
    const columns = ref([
@@ -175,17 +134,34 @@
      },
      {
        field: "outboundQuantity",
        title: "待出库数",
        title: "待出库数数量",
        type: "number",
        width: 100,
        align: "left",
      },
      {
        field: "supplyQuantity",
        title: "盘点数",
        title: "盘点差异数",
        type: "number",
        width: 100,
        align: "left",
        cellStyle: (row) => {
          const value = row.supplyQuantity;
          if (value > 0) {
            return { color: "#00ff00" }; // ç»¿è‰²
          } else if (value < 0) {
            return { color: "#ff0000" }; // çº¢è‰²
          }
          // else {
          //   return { color: '#000000' }; // é»‘色
          // }
        },
      },
      {
        title: "可用库存数",
        required: true,
        field: "availableQuantity",
        type: "number",
      },
      {
        field: "erpStockQuantity",
@@ -194,21 +170,21 @@
        width: 120,
        align: "left",
      },
      {
        field: "status",
        title: "库存差异",
        type: "select",
        width: 100,
        align: "left",
        bind: { key: "stockDifference", data: [] },
      },
      {
        field: "productionDate",
        title: "生产日期",
        type: "date",
        width: 120,
        align: "left",
      },
      // {
      //   field: "status",
      //   title: "库存差异",
      //   type: "select",
      //   width: 100,
      //   align: "left",
      //   bind: { key: "stockDifference", data: [] },
      // },
      // {
      //   field: "productionDate",
      //   title: "生产日期",
      //   type: "date",
      //   width: 120,
      //   align: "left",
      // },
      {
        field: "validityPeriod",
        title: "有效期至",
@@ -236,7 +212,7 @@
        type: "string",
        width: 100,
        align: "left",
        hidden: true
        hidden: true,
      },
      {
        field: "modifyDate",
@@ -244,7 +220,7 @@
        type: "datetime",
        width: 160,
        align: "left",
        hidden: true
        hidden: true,
      },
      {
        field: "remark",
@@ -252,7 +228,7 @@
        type: "string",
        width: 100,
        align: "left",
        hidden: true
        hidden: true,
      },
    ]);
    const detail = ref({