INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-12 ','08:12:27');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-11';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-11' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-12';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-12 ','08:13:05');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0001','1','CBRE-YLAA-12-0','1','4.930','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAA-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAA-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAA-12-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAA-12-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YLAA-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.930',berat_out_asli='4.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.930',berat_akhir_asli =berat_akhir_asli-'4.930' WHERE kode_barang='CBRE-YLAA-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251212-0001','2025-12-12','2025-12-12','08:25','4.930','input','2025-12-12 08:25:16','ELCO');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-12 ','08:30:49');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01465';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YLAB-1-0','00040558','DP-01465MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','878500','2025-12-12','878500','2.800','14.00','25','300000','2240000.00','1','0.14', 'input','2025-12-12 08:48:12','2.800','0','','16750.00','','TOKO','FREETAG','','10','','','PSN01465MM','1','RS 21','','DP-01465');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YLAB-1-0','00040558');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','PSPLT-YLAB-1-0','PSPLT','TOKO','MMPSN','14.00','2.800','2.800','1','2.800','2.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01465MM ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01457';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YLAB-2-0','00040559','DP-01457MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1784500','2025-12-12','1784500','2.950','27.00','50','300000','2240000.00','1','0.14', 'input','2025-12-12 08:49:54','2.950','0','','16750.00','','TOKO','FREETAG','','10','','','PSN01457MM','1','RS 19 5','','DP-01457');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YLAB-2-0','00040559');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','PSPLT-YLAB-2-0','PSPLT','TOKO','MMPSN','27.00','2.950','2.950','1','2.950','2.950','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01457MM ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01456';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YLAB-3-0','00040560','DP-01456MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1155500','2025-12-12','1155500','1.910','27.00','50','300000','2240000.00','1','0.14', 'input','2025-12-12 08:52:47','1.910','0','','16750.00','','TOKO','FREETAG','','10','','','PSN01456MM','1','RS 12','','DP-01456');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YLAB-3-0','00040560');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','PSPLT-YLAB-3-0','PSPLT','TOKO','MMPSN','27.00','1.910','1.910','1','1.910','1.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01456MM ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0002','1','PSPLT-YLAB-1-0','1','2.800','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YLAB-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YLAB-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YLAB-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YLAB-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YLAB-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.800',berat_out_asli='2.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.800',berat_akhir_asli =berat_akhir_asli-'2.800' WHERE kode_barang='PSPLT-YLAB-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0002','2','PSPLT-YLAB-2-0','1','2.950','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YLAB-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YLAB-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YLAB-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YLAB-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YLAB-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.950',berat_out_asli='2.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.950',berat_akhir_asli =berat_akhir_asli-'2.950' WHERE kode_barang='PSPLT-YLAB-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0002','3','PSPLT-YLAB-3-0','1','1.910','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YLAB-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YLAB-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YLAB-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YLAB-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YLAB-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.910',berat_out_asli='1.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.910',berat_akhir_asli =berat_akhir_asli-'1.910' WHERE kode_barang='PSPLT-YLAB-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251212-0002','2025-12-12','2025-12-12','09:21','1.910','input','2025-12-12 09:21:08','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-12 ','10:08:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-12 ','10:23:54');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','1','CKPRE-YLAX-26-0','1','2.810','2.810','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-26-0','100.00','1','2.810','2.810','1','2.810','2.810');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.810',berat_out_asli=berat_out_asli+'2.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','2','CKPRE-YLAX-6-0','1','1.910','1.910','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-6-0','100.00','1','1.910','1.910','1','1.910','1.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.910',berat_out_asli=berat_out_asli+'1.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','3','CKPRE-YLAX-21-0','1','2.870','2.870','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-21-0','100.00','1','2.870','2.870','1','2.870','2.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.870',berat_out_asli=berat_out_asli+'2.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','4','CKPRE-YLAX-5-0','1','1.960','1.960','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-5-0','100.00','1','1.960','1.960','1','1.960','1.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.960',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','5','CKPRE-YLAX-13-0','1','1.600','1.600','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-13-0','100.00','1','1.600','1.600','1','1.600','1.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','6','CKPRE-YLAX-25-0','1','2.360','2.360','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-25-0','100.00','1','2.360','2.360','1','2.360','2.360');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.360',berat_out_asli=berat_out_asli+'2.360',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','7','CKPRE-YLAX-2-0','1','3.540','3.540','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-2-0','100.00','1','3.540','3.540','1','3.540','3.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.540',berat_out_asli=berat_out_asli+'3.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','8','CKPRE-YLAX-15-0','1','2.460','2.460','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-15-0','100.00','1','2.460','2.460','1','2.460','2.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.460',berat_out_asli=berat_out_asli+'2.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','9','CKPRE-YLAX-31-0','1','2.520','2.520','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-31-0','100.00','1','2.520','2.520','1','2.520','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.520',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','10','CKPRE-YLAX-28-0','1','1.670','1.670','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-28-0','100.00','1','1.670','1.670','1','1.670','1.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.670',berat_out_asli=berat_out_asli+'1.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','11','CKPRE-YLAX-4-0','1','1.600','1.600','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-4-0','100.00','1','1.600','1.600','1','1.600','1.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','12','CKPRE-YLAX-9-0','1','2.520','2.520','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-9-0','100.00','1','2.520','2.520','1','2.520','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.520',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','13','CKPRE-YLAX-10-0','1','1.750','1.750','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-10-0','100.00','1','1.750','1.750','1','1.750','1.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.750',berat_out_asli=berat_out_asli+'1.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','14','CKPRE-YLAX-33-0','1','3.780','3.780','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-33-0','100.00','1','3.780','3.780','1','3.780','3.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.780',berat_out_asli=berat_out_asli+'3.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','15','CKPRE-YLAX-47-0','1','2.750','2.750','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-47-0','100.00','1','2.750','2.750','1','2.750','2.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.750',berat_out_asli=berat_out_asli+'2.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','16','CKPRE-YLAX-18-0','1','1.820','1.820','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-18-0','100.00','1','1.820','1.820','1','1.820','1.820');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.820',berat_out_asli=berat_out_asli+'1.820',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','17','CKPRE-YLAX-29-0','1','1.780','1.780','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-29-0','100.00','1','1.780','1.780','1','1.780','1.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.780',berat_out_asli=berat_out_asli+'1.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','18','CKPRE-YLAX-27-0','1','2.610','2.610','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-27-0','100.00','1','2.610','2.610','1','2.610','2.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.610',berat_out_asli=berat_out_asli+'2.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','19','CKPRE-YLAX-42-0','1','2.510','2.510','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-42-0','100.00','1','2.510','2.510','1','2.510','2.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.510',berat_out_asli=berat_out_asli+'2.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','20','CKPRE-YLAX-17-0','1','1.410','1.410','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-17-0','100.00','1','1.410','1.410','1','1.410','1.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.410',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','21','CKPRE-YLAX-38-0','1','2.330','2.330','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-38-0','100.00','1','2.330','2.330','1','2.330','2.330');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.330',berat_out_asli=berat_out_asli+'2.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','22','CKPRE-YLAX-32-0','1','2.030','2.030','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-32-0','100.00','1','2.030','2.030','1','2.030','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','23','CKPRE-YLAX-36-0','1','2.030','2.030','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-36-0','100.00','1','2.030','2.030','1','2.030','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','24','CKPRE-YLAX-3-0','1','1.670','1.670','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-3-0','100.00','1','1.670','1.670','1','1.670','1.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.670',berat_out_asli=berat_out_asli+'1.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','25','CKPRE-YLAX-49-0','1','1.460','1.460','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-49-0','100.00','1','1.460','1.460','1','1.460','1.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.460',berat_out_asli=berat_out_asli+'1.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','26','CKPRE-YLAX-45-0','1','2.350','2.350','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-45-0','100.00','1','2.350','2.350','1','2.350','2.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.350',berat_out_asli=berat_out_asli+'2.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','27','CKPRE-YLAX-34-0','1','1.800','1.800','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-34-0','100.00','1','1.800','1.800','1','1.800','1.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.800',berat_out_asli=berat_out_asli+'1.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','28','CKPRE-YLAX-19-0','1','1.390','1.390','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-19-0','100.00','1','1.390','1.390','1','1.390','1.390');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.390',berat_out_asli=berat_out_asli+'1.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','29','CKPRE-YLAX-8-0','1','2.850','2.850','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-8-0','100.00','1','2.850','2.850','1','2.850','2.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.850',berat_out_asli=berat_out_asli+'2.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','30','CKPRE-YLAX-1-0','1','1.410','1.410','TOKO','SEM-PERAK','TOKO','PER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PER' WHERE kode_barang='CKPRE-YLAX-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-12','TOKO','PER','CKPRE','CKPRE-YLAX-1-0','100.00','1','1.410','1.410','1','1.410','1.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.410',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-12' AND kode_barang='CKPRE-YLAX-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251212-0001','2025-12-12','2025-12-12','15:05','65.55','input','2025-12-12 15:09:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-12 ','16:37:24');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','1','CKPRE-YLAX-1-0','1','1.410','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.410',berat_out_asli='1.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.410',berat_akhir_asli =berat_akhir_asli-'1.410' WHERE kode_barang='CKPRE-YLAX-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','2','CKPRE-YLAX-2-0','1','3.540','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.540',berat_out_asli='3.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.540',berat_akhir_asli =berat_akhir_asli-'3.540' WHERE kode_barang='CKPRE-YLAX-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','3','CKPRE-YLAX-3-0','1','1.670','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.670',berat_out_asli='1.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.670',berat_akhir_asli =berat_akhir_asli-'1.670' WHERE kode_barang='CKPRE-YLAX-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','4','CKPRE-YLAX-4-0','1','1.600','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.600' WHERE kode_barang='CKPRE-YLAX-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','5','CKPRE-YLAX-5-0','1','1.960','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='CKPRE-YLAX-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','6','CKPRE-YLAX-6-0','1','1.910','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.910',berat_out_asli='1.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.910',berat_akhir_asli =berat_akhir_asli-'1.910' WHERE kode_barang='CKPRE-YLAX-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','7','CKPRE-YLAX-8-0','1','2.850','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-8-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.850',berat_out_asli='2.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.850',berat_akhir_asli =berat_akhir_asli-'2.850' WHERE kode_barang='CKPRE-YLAX-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','8','CKPRE-YLAX-9-0','1','2.520','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-9-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.520',berat_out_asli='2.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.520',berat_akhir_asli =berat_akhir_asli-'2.520' WHERE kode_barang='CKPRE-YLAX-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','9','CKPRE-YLAX-10-0','1','1.750','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-10-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.750',berat_out_asli='1.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.750',berat_akhir_asli =berat_akhir_asli-'1.750' WHERE kode_barang='CKPRE-YLAX-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','10','CKPRE-YLAX-13-0','1','1.600','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-13-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-13-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.600' WHERE kode_barang='CKPRE-YLAX-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','11','CKPRE-YLAX-15-0','1','2.460','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-15-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-15-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.460',berat_out_asli='2.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.460',berat_akhir_asli =berat_akhir_asli-'2.460' WHERE kode_barang='CKPRE-YLAX-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','12','CKPRE-YLAX-17-0','1','1.410','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-17-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-17-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.410',berat_out_asli='1.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.410',berat_akhir_asli =berat_akhir_asli-'1.410' WHERE kode_barang='CKPRE-YLAX-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','13','CKPRE-YLAX-18-0','1','1.820','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-18-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-18-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.820',berat_out_asli='1.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.820',berat_akhir_asli =berat_akhir_asli-'1.820' WHERE kode_barang='CKPRE-YLAX-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','14','CKPRE-YLAX-19-0','1','1.390','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-19-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-19-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.390',berat_out_asli='1.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.390',berat_akhir_asli =berat_akhir_asli-'1.390' WHERE kode_barang='CKPRE-YLAX-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','15','CKPRE-YLAX-21-0','1','2.870','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-21-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-21-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.870',berat_out_asli='2.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.870',berat_akhir_asli =berat_akhir_asli-'2.870' WHERE kode_barang='CKPRE-YLAX-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','16','CKPRE-YLAX-25-0','1','2.360','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-25-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-25-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.360',berat_out_asli='2.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.360',berat_akhir_asli =berat_akhir_asli-'2.360' WHERE kode_barang='CKPRE-YLAX-25-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','17','CKPRE-YLAX-26-0','1','2.810','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-26-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-26-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.810',berat_out_asli='2.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.810',berat_akhir_asli =berat_akhir_asli-'2.810' WHERE kode_barang='CKPRE-YLAX-26-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','18','CKPRE-YLAX-27-0','1','2.610','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-27-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-27-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.610',berat_out_asli='2.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.610',berat_akhir_asli =berat_akhir_asli-'2.610' WHERE kode_barang='CKPRE-YLAX-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','19','CKPRE-YLAX-28-0','1','1.670','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-28-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-28-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.670',berat_out_asli='1.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.670',berat_akhir_asli =berat_akhir_asli-'1.670' WHERE kode_barang='CKPRE-YLAX-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','20','CKPRE-YLAX-29-0','1','1.780','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-29-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-29-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.780',berat_out_asli='1.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.780',berat_akhir_asli =berat_akhir_asli-'1.780' WHERE kode_barang='CKPRE-YLAX-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','21','CKPRE-YLAX-31-0','1','2.520','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-31-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-31-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.520',berat_out_asli='2.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.520',berat_akhir_asli =berat_akhir_asli-'2.520' WHERE kode_barang='CKPRE-YLAX-31-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','22','CKPRE-YLAX-32-0','1','2.030','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-32-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-32-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-32-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-32-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='CKPRE-YLAX-32-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','23','CKPRE-YLAX-33-0','1','3.780','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-33-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-33-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-33-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-33-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.780',berat_out_asli='3.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.780',berat_akhir_asli =berat_akhir_asli-'3.780' WHERE kode_barang='CKPRE-YLAX-33-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','24','CKPRE-YLAX-34-0','1','1.800','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-34-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-34-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.800',berat_out_asli='1.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.800',berat_akhir_asli =berat_akhir_asli-'1.800' WHERE kode_barang='CKPRE-YLAX-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','25','CKPRE-YLAX-36-0','1','2.030','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-36-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-36-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='CKPRE-YLAX-36-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','26','CKPRE-YLAX-38-0','1','2.330','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-38-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-38-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-38-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-38-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.330',berat_out_asli='2.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.330',berat_akhir_asli =berat_akhir_asli-'2.330' WHERE kode_barang='CKPRE-YLAX-38-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','27','CKPRE-YLAX-42-0','1','2.510','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-42-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-42-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-42-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-42-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.510',berat_out_asli='2.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.510',berat_akhir_asli =berat_akhir_asli-'2.510' WHERE kode_barang='CKPRE-YLAX-42-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','28','CKPRE-YLAX-45-0','1','2.350','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-45-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-45-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-45-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-45-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.350',berat_out_asli='2.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.350',berat_akhir_asli =berat_akhir_asli-'2.350' WHERE kode_barang='CKPRE-YLAX-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','29','CKPRE-YLAX-47-0','1','2.750','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-47-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-47-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-47-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-47-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.750',berat_out_asli='2.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.750',berat_akhir_asli =berat_akhir_asli-'2.750' WHERE kode_barang='CKPRE-YLAX-47-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0003','30','CKPRE-YLAX-49-0','1','1.460','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YLAX-49-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-YLAX-49-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-YLAX-49-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-YLAX-49-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-YLAX-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.460',berat_out_asli='1.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.460',berat_akhir_asli =berat_akhir_asli-'1.460' WHERE kode_barang='CKPRE-YLAX-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251212-0003','2025-12-12','2025-12-12','16:37','1.460','input','2025-12-12 16:37:37','ELCO');