优化盘点逻辑

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,7 +38,7 @@
      productionDate: "",
      validityPeriod: "",
      remark: "",
      AvailableQuantity: "",
      availableQuantity: "",
    });
    const editFormOptions = ref([
      [
@@ -40,18 +48,14 @@
          field: "materielCode",
          type: "string",
        },
      ],
      [
        {
          title: "物料名称",
          required: true,
          field: "materielName",
          type: "string",
        },
        {
          title: "物料规格",
          required: true,
          field: "materielSpec",
          type: "string",
        }
      ],
      [
        {
@@ -60,67 +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: "availableQuantity",
          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: "",
@@ -129,9 +81,9 @@
    });
    const searchFormOptions = ref([
      [
        { title: "物料编号", field: "materielCode" ,type: "like" },
        { title: "物料名称", field: "materielName" ,type: "like"},
        { title: "批次号", field: "batchNo" ,type: "like"},
        { title: "物料编号", field: "materielCode", type: "like" },
        { title: "物料名称", field: "materielName", type: "like" },
        { title: "批次号", field: "batchNo", type: "like" },
      ],
    ]);
    const columns = ref([
@@ -189,17 +141,28 @@
      },
      {
        field: "supplyQuantity",
        title: "盘点数",
        title: "盘点差异数",
        type: "number",
        width: 100,
        align: "left",
      },
         {
          title: "可用库存数",
          required: true,
          field: "availableQuantity",
          type: "number",
        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",
        title: "ERP实际库存数",
@@ -249,7 +212,7 @@
        type: "string",
        width: 100,
        align: "left",
        hidden: true
        hidden: true,
      },
      {
        field: "modifyDate",
@@ -257,7 +220,7 @@
        type: "datetime",
        width: 160,
        align: "left",
        hidden: true
        hidden: true,
      },
      {
        field: "remark",
@@ -265,7 +228,7 @@
        type: "string",
        width: 100,
        align: "left",
        hidden: true
        hidden: true,
      },
    ]);
    const detail = ref({