73 lines
1.0 KiB
Markdown
73 lines
1.0 KiB
Markdown
|
플루터 캡쳐
|
||
|
|
https://deque.tistory.com/135
|
||
|
|
|
||
|
|
|
||
|
|
공유기능
|
||
|
|
https://pub.dev/packages/share_plus
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
청주공장
|
||
|
|
조립작지 : 202202180009001
|
||
|
|
barcode : 4700935303/50/220307/0006/M21508K
|
||
|
|
간판 : JS#4700935303#M21508K#TS180511A#CY#220218#9#950$
|
||
|
|
|
||
|
|
4700935303#M21508K#220305#0004
|
||
|
|
4700935303#M21508K#220302#0044
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
|
||
|
|
select *
|
||
|
|
from shpact_comb_scan
|
||
|
|
where lotno like 'M21508K%'
|
||
|
|
and shpjpno not in (
|
||
|
|
select shpjpno from shpact_comb )
|
||
|
|
|
||
|
|
|
||
|
|
insert into shpact_comb_scan
|
||
|
|
select *
|
||
|
|
from tmp_shpact_comb_scan
|
||
|
|
where shpjpno = '202203070001001'
|
||
|
|
and seqno < 147
|
||
|
|
order by seqno
|
||
|
|
|
||
|
|
edit tmp_shpact_comb_scan
|
||
|
|
where shpjpno = '202203070001001'
|
||
|
|
and seqno >= 147
|
||
|
|
order by seqno
|
||
|
|
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
create table tmp_shpact_comb as
|
||
|
|
select *
|
||
|
|
from shpact_comb
|
||
|
|
where pordno = '202202180009001'
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
select *
|
||
|
|
from tmp_shpact_comb
|
||
|
|
where shpjpno = '202203070001001'
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
select *
|
||
|
|
from shpact_comb
|
||
|
|
where pordno = '202202180009001'
|
||
|
|
|
||
|
|
|
||
|
|
---
|
||
|
|
|
||
|
|
|
||
|
|
insert into shpact_comb_scan
|
||
|
|
select *
|
||
|
|
from tmp_shpact_comb_scan
|
||
|
|
|
||
|
|
insert into shpact_comb
|
||
|
|
select *
|
||
|
|
from tmp_shpact_comb
|
||
|
|
where shpjpno = '202203070001001'
|