INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-09 ','08:07:55');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-08';
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-10-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-08';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-08' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-09';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-09 ','08:09:05');
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-251009-0001','1','PSBRE-YJXH-47-0','1','4.920','4.920','TOKO','PSN','TOKO','SEM-PSN');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-PSN' WHERE kode_barang='PSBRE-YJXH-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PSN';
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-10-09','TOKO','SEM-PSN','PSBRE','PSBRE-YJXH-47-0','83.00','1','4.920','4.920','1','4.920','4.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.920',berat_out_asli=berat_out_asli+'4.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-09' AND kode_barang='PSBRE-YJXH-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PSN' 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-251009-0001','2025-10-09','2025-10-09','08:09','4.92','input','2025-10-09 08:09:40');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0001','1','PSPLE-YJXG-34-0','1','3.470','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-YJXG-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLE-YJXG-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLE-YJXG-34-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLE-YJXG-34-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLE-YJXG-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.470',berat_out_asli='3.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.470',berat_akhir_asli =berat_akhir_asli-'3.470' WHERE kode_barang='PSPLE-YJXG-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-251009-0001','2','PSBRE-YJXH-44-0','1','2.790','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSBRE-YJXH-44-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBRE-YJXH-44-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBRE-YJXH-44-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBRE-YJXH-44-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBRE-YJXH-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.790',berat_out_asli='2.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.790',berat_akhir_asli =berat_akhir_asli-'2.790' WHERE kode_barang='PSBRE-YJXH-44-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0001','3','PSBRE-YJXH-45-0','1','1.950','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSBRE-YJXH-45-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBRE-YJXH-45-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBRE-YJXH-45-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBRE-YJXH-45-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBRE-YJXH-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.950',berat_out_asli='1.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.950',berat_akhir_asli =berat_akhir_asli-'1.950' WHERE kode_barang='PSBRE-YJXH-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-251009-0001','4','PSPLE-YJXH-48-0','1','6.430','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-YJXH-48-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLE-YJXH-48-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLE-YJXH-48-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLE-YJXH-48-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLE-YJXH-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.430',berat_out_asli='6.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.430',berat_akhir_asli =berat_akhir_asli-'6.430' WHERE kode_barang='PSPLE-YJXH-48-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0001','5','PSGE-YJXH-49-0','1','4.030','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-YJXH-49-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGE-YJXH-49-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGE-YJXH-49-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGE-YJXH-49-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGE-YJXH-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.030',berat_out_asli='4.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.030',berat_akhir_asli =berat_akhir_asli-'4.030' WHERE kode_barang='PSGE-YJXH-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0001','6','PSPLE-YJXH-50-0','1','3.720','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-YJXH-50-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLE-YJXH-50-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLE-YJXH-50-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLE-YJXH-50-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLE-YJXH-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.720',berat_out_asli='3.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.720',berat_akhir_asli =berat_akhir_asli-'3.720' WHERE kode_barang='PSPLE-YJXH-50-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-251009-0001','2025-10-09','2025-10-09','08:13','3.720','input','2025-10-09 08:13:01','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0002','1','TFCMR-YJXH-15-0','1','1.900','TOKO','CMPTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YJXH-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFCMR-YJXH-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFCMR-YJXH-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFCMR-YJXH-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMPTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMPTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFCMR-YJXH-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='TFCMR-YJXH-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-251009-0002','2','TFCMR-YJXH-16-0','1','2.470','TOKO','CMPTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YJXH-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFCMR-YJXH-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFCMR-YJXH-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFCMR-YJXH-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMPTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMPTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFCMR-YJXH-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.470',berat_out_asli='2.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.470',berat_akhir_asli =berat_akhir_asli-'2.470' WHERE kode_barang='TFCMR-YJXH-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0002','3','TFCMR-YJXH-17-0','1','2.390','TOKO','CMPTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YJXH-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFCMR-YJXH-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFCMR-YJXH-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFCMR-YJXH-17-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMPTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMPTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFCMR-YJXH-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.390',berat_out_asli='2.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.390',berat_akhir_asli =berat_akhir_asli-'2.390' WHERE kode_barang='TFCMR-YJXH-17-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-251009-0002','2025-10-09','2025-10-09','08:13','2.390','input','2025-10-09 08:13:19','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0003','1','TFGKR-YJXH-18-0','1','8.660','TOKO','GLKTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGKR-YJXH-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGKR-YJXH-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGKR-YJXH-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGKR-YJXH-18-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGKR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGKR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLKTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLKTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGKR-YJXH-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.660',berat_out_asli='8.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.660',berat_akhir_asli =berat_akhir_asli-'8.660' WHERE kode_barang='TFGKR-YJXH-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-251009-0003','2','TFGKR-YJXH-19-0','1','5.970','TOKO','GLKTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGKR-YJXH-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGKR-YJXH-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGKR-YJXH-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGKR-YJXH-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGKR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGKR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLKTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLKTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGKR-YJXH-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.970',berat_out_asli='5.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.970',berat_akhir_asli =berat_akhir_asli-'5.970' WHERE kode_barang='TFGKR-YJXH-19-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-251009-0003','2025-10-09','2025-10-09','08:13','5.970','input','2025-10-09 08:13:31','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0004','1','TFGRR-YJXH-14-0','1','7.800','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YJXH-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-YJXH-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-YJXH-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-YJXH-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-YJXH-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.800',berat_out_asli='7.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.800',berat_akhir_asli =berat_akhir_asli-'7.800' WHERE kode_barang='TFGRR-YJXH-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0004','2','TFGRR-YJXH-20-0','1','1.840','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YJXH-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-YJXH-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-YJXH-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-YJXH-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-YJXH-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.840',berat_out_asli='1.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.840',berat_akhir_asli =berat_akhir_asli-'1.840' WHERE kode_barang='TFGRR-YJXH-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0004','3','TFGRR-YJXH-21-0','1','1.710','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YJXH-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-YJXH-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-YJXH-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-YJXH-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-YJXH-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.710',berat_out_asli='1.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.710',berat_akhir_asli =berat_akhir_asli-'1.710' WHERE kode_barang='TFGRR-YJXH-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-251009-0004','4','TFGRR-YJXH-22-0','1','2.090','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YJXH-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-YJXH-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-YJXH-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-YJXH-22-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-YJXH-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.090',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.090',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='TFGRR-YJXH-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0004','5','TFGRR-YJXH-23-0','1','3.850','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YJXH-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-YJXH-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-YJXH-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-YJXH-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-YJXH-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.850',berat_out_asli='3.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.850',berat_akhir_asli =berat_akhir_asli-'3.850' WHERE kode_barang='TFGRR-YJXH-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0004','6','TFGRR-YJXH-24-0','1','3.200','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YJXH-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-YJXH-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-YJXH-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-YJXH-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-YJXH-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.200',berat_out_asli='3.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.200',berat_akhir_asli =berat_akhir_asli-'3.200' WHERE kode_barang='TFGRR-YJXH-24-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-251009-0004','2025-10-09','2025-10-09','08:13','3.200','input','2025-10-09 08:13:42','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0005','1','PSPRT-YJXG-35-0','1','2.360','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJXG-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJXG-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJXG-35-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJXG-35-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' 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='PSPRT-YJXG-35-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='PSPRT-YJXG-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0005','2','PSPLT-YJXG-36-0','1','2.730','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YJXG-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YJXG-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YJXG-36-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YJXG-36-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-YJXG-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.730',berat_out_asli='2.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.730',berat_akhir_asli =berat_akhir_asli-'2.730' WHERE kode_barang='PSPLT-YJXG-36-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-251009-0005','2025-10-09','2025-10-09','08:13','2.730','input','2025-10-09 08:13:54','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-09 ','08:38:41');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('GBRE-YJXI-1-0','00039140','GBRE-01323 ','GELANG GBRE-01323 ','','GR','---','DM','GBRE','TOKO','GBRE','5299000','2025-10-09','5299000','3.040','83.00','75','0','2100000.00','1','0.04', 'input','2025-10-09 08:55:31','3.040','1110000','96.75','16600.00','','TOKO','FREETAG','','10','','','IDR 30 000 000','1','1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-YJXI-1-0','00039140');
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-10-09','GBRE-YJXI-1-0','GBRE','TOKO','GBRE','83.00','3.040','3.040','1','3.040','3.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-01323 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YJXI-1-0','00039140','RD','39','0.215 ','450','96.75');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251009-0006','1','GBRE-YJXI-1-0','1','3.040','TOKO','GBRE');
DELETE FROM tm_barang_export WHERE kode_barang='GBRE-YJXI-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='GBRE-YJXI-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='GBRE-YJXI-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='GBRE-YJXI-1-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='GBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='GBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='GBRE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='GBRE-YJXI-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.040',berat_out_asli='3.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.040',berat_akhir_asli =berat_akhir_asli-'3.040' WHERE kode_barang='GBRE-YJXI-1-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-251009-0006','2025-10-09','2025-10-09','08:57','3.040','input','2025-10-09 08:57:35','ELCO');
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-01170';
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-YJXI-2-0','00039141','DP-01170BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','255000','2025-10-09','255000','2.020','6.00','10','300000','2100000.00','1','0.14', 'input','2025-10-09 09:21:21','2.020','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01170BIP','1','RS 10','','DP-01170');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJXI-2-0','00039141');
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-10-09','PSPLT-YJXI-2-0','PSPLT','TOKO','PSNB','6.00','2.020','2.020','1','2.020','2.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01170BIP ');
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-01166';
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 ('PSPRT-YJXI-3-0','00039142','DP-01166BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','84000','2025-10-09','84000','3.360','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-09 09:22:48','3.360','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01166BIP','1','RS 18','','DP-01166');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJXI-3-0','00039142');
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-10-09','PSPRT-YJXI-3-0','PSPRT','TOKO','PSNB','100.00','3.360','3.360','1','3.360','3.360','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01166BIP ');
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-01169';
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-YJXI-4-0','00039143','DP-01169BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','483000','2025-10-09','483000','3.830','6.00','10','300000','2100000.00','1','0.14', 'input','2025-10-09 09:24:15','3.830','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01169BIP','1','RS 17 5','','DP-01169');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJXI-4-0','00039143');
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-10-09','PSPLT-YJXI-4-0','PSPLT','TOKO','PSNB','6.00','3.830','3.830','1','3.830','3.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01169BIP ');
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-01154';
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 ('PSPRT-YJXI-5-0','00039144','DP-01154BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','76500','2025-10-09','76500','3.060','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-09 09:26:14','3.060','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01154BIP','1','RS 17','','DP-01154');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJXI-5-0','00039144');
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-10-09','PSPRT-YJXI-5-0','PSPRT','TOKO','PSNB','100.00','3.060','3.060','1','3.060','3.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01154BIP ');
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-01173';
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-YJXI-6-0','00039145','DP-01173BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','867500','2025-10-09','867500','2.950','14.00','25','300000','2100000.00','1','0.14', 'input','2025-10-09 09:27:57','2.950','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01173BIP','1','RS 11','','DP-01173');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJXI-6-0','00039145');
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-10-09','PSPLT-YJXI-6-0','PSPLT','TOKO','PSNB','14.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-01173BIP ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02885';
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 ('PSPLE-YJXI-7-0','00039146','DP-02885 ','CINCIN PALADIUM ','','GR','---','PSPLE','PSPLE','TOKO','PSN','582500','2025-10-09','582500','4.620','6.00','10','300000','2100000.00','1','0.04', 'input','2025-10-09 09:29:41','4.620','0','','16600.00','','TOKO','FREETAG','','10','','','PSN02885','1','RS 25','','DP-02885');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLE','PSPLE-YJXI-7-0','00039146');
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-10-09','PSPLE-YJXI-7-0','PSPLE','TOKO','PSN','6.00','4.620','4.620','1','4.620','4.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLE','DP-02885 ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-09 ','10:41:59');