v_endoscope_status 数据重复问题 —— ect_meta_endoscope 数据录入问题！ #334

New Issue

Open

opened 2026-01-02 15:38:19 +08:00 by bigtran · 2 comments

bigtran commented 2026-01-02 15:38:19 +08:00

Owner

Copy Link

Copy Source

一条内镜(物理世界)绑了两张以上卡片的时候，并且这些卡片在系统里都刷过卡，有数据，再用现在的v_endoscope_status就会出现重复数据。

一条内镜(物理世界)绑了两张以上卡片的时候，并且这些卡片在系统里都刷过卡，有数据，再用现在的v_endoscope_status就会出现重复数据。 

image.png

443 KiB

bigtran changed title from v_endoscope_status 数据重复问题 to v_endoscope_status 数据重复问题 —— 重复绑卡的问题 2026-01-02 15:38:29 +08:00

bigtran commented 2026-01-02 15:41:21 +08:00

Author

Owner

Copy Link

Copy Source

义乌妇幼 原始数据就有问题，没法弄，改不了

select endoscope_steel_no,count(*) from ect_meta_endoscope group by endoscope_steel_no;

东莞东华，字段是乱的，现在还不能改，涉及到 pacs接口等修改

# 义乌妇幼 原始数据就有问题，没法弄，改不了 ``` select endoscope_steel_no,count(*) from ect_meta_endoscope group by endoscope_steel_no; ```  # 东莞东华，字段是乱的，现在还不能改，涉及到 pacs接口等修改 

image.png

498 KiB

image.png

414 KiB

bigtran commented 2026-01-02 15:44:26 +08:00

Author

Owner

Copy Link

Copy Source


image.png

58 KiB

bigtran changed title from v_endoscope_status 数据重复问题 —— 重复绑卡的问题 to v_endoscope_status 数据重复问题 —— ect_meta_endoscope 数据录入问题！ 2026-01-02 15:44:51 +08:00

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

No results found.

No results found.

Labels

Clear labels

1-feature

2-bug

Something is not working

3-enhancement

New feature

4-document

5-bloody-version-diff

搞死人的版本差异

6-now-commit-to-fix

下定决心解决，用行动证明，用结果证明

duplicate

This issue or pull request already exists

invalid

Something is wrong

wontfix

This won't be fixed

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

bigtran (张大川) chenyingjie fanjc huangyanxue liuning panzs qilisong yanyanyan

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: temp-tickets/tickets#334