Vue3+ElementPlus+Koa2 Full stack development background system

v: ititit111222333

            select id,
                   sku_code,
                   sku_name,
                   sku_specs,
                   upc,
                   warehouse_id,
                   cargo_space_id,
                   batch_no,
                   production_date,
                   shelf_life,
                   shelf_life_unit,
                   expired_date,
                   IFNULL(SUM(quantity), 0)           as totalQuantity,
                   IFNULL(SUM(preempted_quantity), 0) as totalPreemptedQuantity,
                   IFNULL(SUM(available_quantity), 0) as totalAvailableQuantity,
                   quantity,
                   preempted_quantity,
                   available_quantity,
                   create_by,
                   create_time,
                   update_by,
                   update_time,
                   remove_flag
            from st_inventory as a
            where a.remove_flag = 0
Copy the code