处理出库为0，数据库操作流程 #377

New Issue

2026-01-06T10:33:02+08:00

fanjc commented

2026-01-06 10:33:02 +08:00

确认出库为0的出库批次

SELECT id,organ_name,scale,weight,dept_name,recl_name,hand_name,hand_time,comp_batch,in_ware_batch,out_ware_time,waste_status,recl_time,ribbon_code,waste_type,in_ware_name,in_ware_time,comp_recl_time,comp_recl_name,sort_name,deposit_name,out_ware_name,created_at FROM opm_mw_info_data WHERE organ_name = '昌吉回族自治州人民医院北院院区' AND created_at='2026-01-06' AND waste_status != '出库';

将该批次的状态从出库改为入库

SELECT id,organ_name,scale,weight,dept_name,recl_name,hand_name,hand_time,comp_batch,in_ware_batch,out_ware_time,waste_status,recl_time,ribbon_code,waste_type,in_ware_name,in_ware_time,comp_recl_time,comp_recl_name,sort_name,deposit_name,out_ware_name,created_at FROM opm_mw_info_data  WHERE organ_name = '昌吉回族自治州人民医院北院院区' AND waste_status != '误操作'  AND comp_batch = 'ck759851';

搜索设备列表，找到出入库设备，以特殊格式编码 11_[hospital_id位数]_[hospital_id]_[id位数]_[id]

SELECT * FROM opm_mw_raw_return_data WHERE scale='s00000a2go';

删除相关的操作日志(最近一天)


SELECT * FROM opm_mw_raw_data WHERE url LIKE '%113222%' AND ( url LIKE '%ot1%' OR url LIKE '%ot2%' ) AND link = '出入库' ORDER BY id DESC LIMIT 100;

1. 确认出库为0的出库批次 ```sql SELECT id,organ_name,scale,weight,dept_name,recl_name,hand_name,hand_time,comp_batch,in_ware_batch,out_ware_time,waste_status,recl_time,ribbon_code,waste_type,in_ware_name,in_ware_time,comp_recl_time,comp_recl_name,sort_name,deposit_name,out_ware_name,created_at FROM opm_mw_info_data WHERE organ_name = '昌吉回族自治州人民医院北院院区' AND created_at='2026-01-06' AND waste_status != '出库'; ``` 2. 将该批次的状态从出库改为入库 ```sql SELECT id,organ_name,scale,weight,dept_name,recl_name,hand_name,hand_time,comp_batch,in_ware_batch,out_ware_time,waste_status,recl_time,ribbon_code,waste_type,in_ware_name,in_ware_time,comp_recl_time,comp_recl_name,sort_name,deposit_name,out_ware_name,created_at FROM opm_mw_info_data WHERE organ_name = '昌吉回族自治州人民医院北院院区' AND waste_status != '误操作' AND comp_batch = 'ck759851'; ``` 3. 搜索设备列表，找到出入库设备，以特殊格式编码 `11_[hospital_id位数]_[hospital_id]_[id位数]_[id]` ```sql SELECT * FROM opm_mw_raw_return_data WHERE scale='s00000a2go'; ``` 4. 删除相关的操作日志(最近一天) ```sql SELECT * FROM opm_mw_raw_data WHERE url LIKE '%113222%' AND ( url LIKE '%ot1%' OR url LIKE '%ot2%' ) AND link = '出入库' ORDER BY id DESC LIMIT 100; ```

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: temp-tickets/tickets#377