INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-08 ','08:12:22');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-07';
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='2026-07-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-07' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-07-08';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-08 ','08:13:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-08 ','08:25:30');
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-03060';
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 ('PSPRE-ZGXH-1-0','00045046','DP-03060 ','CINCIN PERAK YL-10 ','','GR','---','PSPRE','PSPRE','TOKO','PSN','474000','2026-07-08','474000','4.740','100.00','925','200000','100000.00','1','0.04', 'input','2026-07-08 08:38:00','4.740','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03060','1','RS 30 5','','DP-03060');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZGXH-1-0','00045046');
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 ('2026-07-08','PSPRE-ZGXH-1-0','PSPRE','TOKO','PSN','100.00','4.740','4.740','1','4.740','4.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03060 ');
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-03051';
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 ('PSGE-ZGXH-2-0','00045047','DP-03051 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','3114500','2026-07-08','3114500','2.920','45.00','375','370000','2370000.00','1','0.04', 'input','2026-07-08 08:42:28','2.920','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03051','1','RS 11','','DP-03051');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZGXH-2-0','00045047');
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 ('2026-07-08','PSGE-ZGXH-2-0','PSGE','TOKO','PSN','45.00','2.920','2.920','1','2.920','2.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-03051 ');
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-03052';
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 ('PSPRE-ZGXH-3-0','00045048','DP-03052 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','304000','2026-07-08','304000','3.040','100.00','925','200000','100000.00','1','0.04', 'input','2026-07-08 08:44:09','3.040','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03052','1','RS 15 5','','DP-03052');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZGXH-3-0','00045048');
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 ('2026-07-08','PSPRE-ZGXH-3-0','PSPRE','TOKO','PSN','100.00','3.040','3.040','1','3.040','3.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03052 ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0001','1','PSPRE-ZGXH-1-0','1','4.740','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZGXH-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZGXH-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZGXH-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZGXH-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' 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='PSPRE-ZGXH-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.740',berat_out_asli='4.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.740',berat_akhir_asli =berat_akhir_asli-'4.740' WHERE kode_barang='PSPRE-ZGXH-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-260708-0001','2','PSGE-ZGXH-2-0','1','2.920','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-ZGXH-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGE-ZGXH-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGE-ZGXH-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGE-ZGXH-2-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-ZGXH-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.920',berat_out_asli='2.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.920',berat_akhir_asli =berat_akhir_asli-'2.920' WHERE kode_barang='PSGE-ZGXH-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-260708-0001','3','PSPRE-ZGXH-3-0','1','3.040','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZGXH-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZGXH-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZGXH-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZGXH-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' 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='PSPRE-ZGXH-3-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='PSPRE-ZGXH-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-260708-0001','2026-07-08','2026-07-08','08:47','3.040','input','2026-07-08 08:47:20','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0002','1','PSGT-ZGXG-24-0','1','2.410','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXG-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXG-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXG-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXG-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' 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='PSGT-ZGXG-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.410',berat_out_asli='2.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.410',berat_akhir_asli =berat_akhir_asli-'2.410' WHERE kode_barang='PSGT-ZGXG-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0002','2','PSGT-ZGXG-25-0','1','2.110','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXG-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXG-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXG-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXG-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' 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='PSGT-ZGXG-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='PSGT-ZGXG-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-260708-0002','3','PSGT-ZGXG-26-0','1','3.000','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXG-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXG-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXG-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXG-26-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' 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='PSGT-ZGXG-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='PSGT-ZGXG-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-260708-0002','4','PSPRT-ZGXG-27-0','1','4.640','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXG-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXG-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXG-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXG-27-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-ZGXG-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.640',berat_out_asli='4.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.640',berat_akhir_asli =berat_akhir_asli-'4.640' WHERE kode_barang='PSPRT-ZGXG-27-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-260708-0002','2026-07-08','2026-07-08','08:47','4.640','input','2026-07-08 08:47:44','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-08 ','10:31:32');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260624-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260624-0002';
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 ('CBRE-ZGXH-4-0','00045049','CBRE-01525 ','CINCIN CBRE-01525 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2702000','2026-07-08','2702000','1.520','75.00','75','0','2370000.00','1','0.04', 'input','2026-07-08 11:04:05','1.520','0','96.40','18100.00','','TOKO','FREETAG','','10','','0','IDB 17 500 000','3','RS15 3B75 0626','BE-260624-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-4-0','00045049');
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 ('2026-07-08','CBRE-ZGXH-4-0','CBRE','TOKO','CBRE.BALIK','75.00','1.520','1.520','1','1.520','1.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01525 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-4-0','00045049','RD','1','0.140 ','620','86.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-4-0','00045049','RD','8','0.030 ','320','9.6');
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-260708-0001','1','CBRE-ZGXH-4-0','1','1.520','1.520','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-4-0','75.00','1','1.520','1.520','1','1.520','1.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.520',berat_out_asli=berat_out_asli+'1.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-260708-0001','2026-07-08','2026-07-08','11:04','1.52','input','2026-07-08 11:04:23');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260630-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260630-0002';
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 ('CBRE-ZGXH-5-0','00045050','CBRE-07053 ','CBRE-07053 GIA 5453189227 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','3580500','2026-07-08','3580500','1.820','83.00','75','0','2370000.00','1','0.14', 'input','2026-07-08 11:07:08','1.820','687000','329.25','18100.00','','TOKO','FREETAG','','10','','','GDR 37 500 000','1','DVVS2 10B4 0626','BE-260630-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-5-0','00045050');
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 ('2026-07-08','CBRE-ZGXH-5-0','CBRE','TOKO','SEM-BALIK','83.00','1.820','1.820','1','1.820','1.820','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07053 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-5-0','00045050','RD','1','0.170 ','1500','255');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-5-0','00045050','RD','35','0.165 ','450','74.25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260630-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260630-0001';
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 ('CBRE-ZGXH-6-0','00045051','CBRE-07054 ','CBRE-07054 GIA 2468965314 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','4550500','2026-07-08','4550500','2.560','75.00','75','0','2370000.00','1','0.14', 'input','2026-07-08 11:09:10','2.560','0','532.20','18100.00','','TOKO','FREETAG','','10','','','GDR 51 500 000','1','DVVS2 12B35 062','BE-260630-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-6-0','00045051');
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 ('2026-07-08','CBRE-ZGXH-6-0','CBRE','TOKO','SEM-BALIK','75.00','2.560','2.560','1','2.560','2.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07054 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-6-0','00045051','RD','1','0.300 ','1550','465');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-6-0','00045051','RD','60','0.210 ','320','67.2');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260701-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260701-0002';
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 ('CBRE-ZGXH-7-0','00045052','CBRE-04122 ','CINCIN CBRE-04122 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','6363500','2026-07-08','6363500','3.580','75.00','75','0','2370000.00','1','0.04', 'input','2026-07-08 11:11:33','3.580','0','224.20','18100.00','','TOKO','FREETAG','','10','','0','IDB 37 500 000','5','RS17 10B4 0726','BE-260701-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-7-0','00045052');
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 ('2026-07-08','CBRE-ZGXH-7-0','CBRE','TOKO','CBRE.BALIK','75.00','3.580','3.580','1','3.580','3.580','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04122 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-7-0','00045052','RD','4','0.075 ','420','31.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-7-0','00045052','RD','11','0.295 ','420','123.9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-7-0','00045052','RD','40','0.215 ','320','68.8');
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-260708-0002','1','CBRE-ZGXH-7-0','1','3.580','3.580','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-7-0','75.00','1','3.580','3.580','1','3.580','3.580');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.580',berat_out_asli=berat_out_asli+'3.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-260708-0002','2026-07-08','2026-07-08','11:11','3.58','input','2026-07-08 11:11:47');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260701-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260701-0001';
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 ('CBRE-ZGXH-8-0','00045053','CBRE-06783 ','CINCIN CBRE-06783 ','','GR','---','DM','CBRE','TOKO','CBRE','4996500','2026-07-08','4996500','2.540','83.00','75','0','2370000.00','1','0.04', 'input','2026-07-08 11:13:09','2.540','0','63.00','18100.00','','TOKO','FREETAG','','10','','0','IDB 23 000 000','2','RS125 6B0 0726','BE-260701-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-8-0','00045053');
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 ('2026-07-08','CBRE-ZGXH-8-0','CBRE','TOKO','CBRE','83.00','2.540','2.540','1','2.540','2.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06783 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-8-0','00045053','RD','26','0.140 ','450','63');
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-260708-0003','1','CBRE-ZGXH-8-0','1','2.540','2.540','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-8-0','83.00','1','2.540','2.540','1','2.540','2.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.540',berat_out_asli=berat_out_asli+'2.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-260708-0003','2026-07-08','2026-07-08','11:13','2.54','input','2026-07-08 11:13:24');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260701-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260701-0001';
UPDATE db_nagagold_elco2.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 ('TFCMR-ZGXH-9-0','00045054','TFCMR75-76% ','THIFA CINCIN MAS RG ','','GR','---','GOLD','TFCMR','TOKO','SEM-EMAS','1351000','2026-07-08','1351000','0.750','76.00','75','0','2370000.00','1','0.14', 'input','2026-07-08 11:15:03','0.750','0','','18100.00','','TOKO','FREETAG','','2','','','','2','','FB-260701-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFCMR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFCMR','TFCMR-ZGXH-9-0','00045054');
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 ('2026-07-08','TFCMR-ZGXH-9-0','TFCMR','TOKO','SEM-EMAS','76.00','0.750','0.750','1','0.750','0.750','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFCMR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFCMR','TFCMR75-76% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260702-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260702-0001';
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 ('CBRE-ZGXH-10-0','00045055','CBRE-04236 ','CBRE-04236 GIA 2436049066 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5030500','2026-07-08','5030500','2.830','75.00','75.00','0','2370000.00','1','0.04', 'input','2026-07-08 11:19:09','2.830','100000','315.80','18100.00','0','TOKO','FREETAG','','10','','0','GDR 39 000 000','3','EVVS1 10B9 0726','BE-260702-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-10-0','00045055');
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 ('2026-07-08','CBRE-ZGXH-10-0','CBRE','TOKO','CBRE.BALIK','75.00','2.830','2.830','1','2.830','2.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04236 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-10-0','00045055','RD','1','0.170 ','1500','255');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-10-0','00045055','RD','22','0.170 ','320','54.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-10-0','00045055','RD','8','0.020 ','320','6.4');
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-260708-0004','1','CBRE-ZGXH-10-0','1','2.830','2.830','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-10-0','75.00','1','2.830','2.830','1','2.830','2.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.830',berat_out_asli=berat_out_asli+'2.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-260708-0004','2026-07-08','2026-07-08','11:19','2.83','input','2026-07-08 11:19:24');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260705-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260705-0002';
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 ('ABRE-ZGXH-11-0','00045056','ABRE-00321 ','GIWANG ABRE-00321 ','','GR','---','DM','ABRE','TOKO','ABRE','8745500','2026-07-08','8745500','4.920','75.00','75.00','0','2370000.00','1','0.04', 'input','2026-07-08 11:22:56','4.920','0','415.60','18100.00','','TOKO','FREETAG','','10','','0','IDB 56 000 000','2','12B7 0726','BE-260705-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZGXH-11-0','00045056');
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 ('2026-07-08','ABRE-ZGXH-11-0','ABRE','TOKO','ABRE','75.00','4.920','4.920','1','4.920','4.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00321 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZGXH-11-0','00045056','RD','2','0.360 ','750','270');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZGXH-11-0','00045056','RD','30','0.170 ','320','54.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZGXH-11-0','00045056','RD','42','0.285 ','320','91.2');
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-260708-0005','1','ABRE-ZGXH-11-0','1','4.920','4.920','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZGXH-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
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('2026-07-08','TOKO','SEM-BALIK','ABRE','ABRE-ZGXH-11-0','75.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='2026-07-08' AND kode_barang='ABRE-ZGXH-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' 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-260708-0005','2026-07-08','2026-07-08','11:23','4.92','input','2026-07-08 11:23:10');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260705-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260705-0001';
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 ('CBRE-ZGXH-12-0','00045057','CBRE-02225 ','CINCIN CBRE-02225 ','','GR','---','DM','CBRE','TOKO','CBRE','2933000','2026-07-08','2933000','1.650','75.00','75','0','2370000.00','1','0.04', 'input','2026-07-08 11:24:40','1.650','0','104.00','18100.00','','TOKO','FREETAG','','10','','0','IDB 19 000 000','2','RS135 3B95 0726','BE-260705-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-12-0','00045057');
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 ('2026-07-08','CBRE-ZGXH-12-0','CBRE','TOKO','CBRE','75.00','1.650','1.650','1','1.650','1.650','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02225 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-12-0','00045057','RD','11','0.325 ','320','104');
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-260708-0006','1','CBRE-ZGXH-12-0','1','1.650','1.650','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-12-0','75.00','1','1.650','1.650','1','1.650','1.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.650',berat_out_asli=berat_out_asli+'1.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-260708-0006','2026-07-08','2026-07-08','11:24','1.65','input','2026-07-08 11:24:55');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260704-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260704-0001';
UPDATE db_nagagold_elco2.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 ('TFC-ZGXH-13-0','00045058','TFC-21515 ','CINCIN TFC-21515 ','','GR','---','DM','TFC','TOKO','SEM-BALIK','3537500','2026-07-08','3537500','1.990','75.00','75','0','2370000.00','1','0.14', 'input','2026-07-08 11:28:26','1.990','0','220.50','18100.00','','TOKO','FREETAG','','10','','','IDB 28 000 000','1','RS14 7B0 0726','FB-260704-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZGXH-13-0','00045058');
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 ('2026-07-08','TFC-ZGXH-13-0','TFC','TOKO','SEM-BALIK','75.00','1.990','1.990','1','1.990','1.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21515 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZGXH-13-0','00045058','RD','1','0.245 ','900','220.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260706-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260706-0004';
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 ('CBRE-ZGXH-14-0','00045059','CBRE-06353 ','CBRE-06353 GIA 1498018633 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2880000','2026-07-08','2880000','1.620','75.00','75','0','2370000.00','1','0.04', 'input','2026-07-08 11:30:27','1.620','0','375.00','18100.00','','TOKO','FREETAG','','10','','0','GDR 36 500 000','3','DVS1 9B6 0726','BE-260706-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-14-0','00045059');
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 ('2026-07-08','CBRE-ZGXH-14-0','CBRE','TOKO','CBRE.BALIK','75.00','1.620','1.620','1','1.620','1.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06353 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-14-0','00045059','RD','1','0.300 ','1250','375');
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-260708-0007','1','CBRE-ZGXH-14-0','1','1.620','1.620','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-14-0','75.00','1','1.620','1.620','1','1.620','1.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.620',berat_out_asli=berat_out_asli+'1.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-260708-0007','2026-07-08','2026-07-08','11:30','1.62','input','2026-07-08 11:30:41');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260706-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260706-0001';
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 ('AMP-ZGXH-15-0','00045060','AMPE75-76% ','ANTING MAS PUTIH ','','GR','---','GOLD','AMP','TOKO','SEM-EMAS','3332500','2026-07-08','3332500','1.850','76.00','75','0','2370000.00','1','0.14', 'input','2026-07-08 11:32:25','1.850','0','','18100.00','','TOKO','FREETAG','','2','','','','3','','BE-260706-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'AMP' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('AMP','AMP-ZGXH-15-0','00045060');
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 ('2026-07-08','AMP-ZGXH-15-0','AMP','TOKO','SEM-EMAS','76.00','1.850','1.850','1','1.850','1.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='AMP';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('AMP','AMPE75-76% ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-08 ','13:11:25');
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2355500',harga_beli ='2355500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4771000',harga_beli ='4771000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='186000',harga_beli ='186000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2699500',harga_beli ='2699500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2239000',harga_beli ='2239000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2141500',harga_beli ='2141500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2180500',harga_beli ='2180500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5197500',harga_beli ='5197500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='19193000',harga_beli ='19193000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2670500',harga_beli ='2670500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2646000',harga_beli ='2646000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2500500',harga_beli ='2500500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2597500',harga_beli ='2597500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2573500',harga_beli ='2573500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7223000',harga_beli ='7223000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2765500',harga_beli ='2765500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='9907000',harga_beli ='9907000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3573500',harga_beli ='3573500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4201000',harga_beli ='4201000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4315000',harga_beli ='4315000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5075000',harga_beli ='5075000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4106000',harga_beli ='4106000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5873500',harga_beli ='5873500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7014000',harga_beli ='7014000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='8458500',harga_beli ='8458500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6843000',harga_beli ='6843000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='1426000',harga_beli ='1426000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2642000',harga_beli ='2642000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4030000',harga_beli ='4030000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3649500',harga_beli ='3649500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2091000',harga_beli ='2091000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2015000',harga_beli ='2015000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6177500',harga_beli ='6177500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7413000',harga_beli ='7413000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3307500',harga_beli ='3307500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6557500',harga_beli ='6557500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5208000',harga_beli ='5208000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2148000',harga_beli ='2148000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4885000',harga_beli ='4885000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3421500',harga_beli ='3421500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5071500',harga_beli ='5071500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6538500',harga_beli ='6538500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='9903000',harga_beli ='9903000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='8933500',harga_beli ='8933500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3269500',harga_beli ='3269500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5094000',harga_beli ='5094000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7109000',harga_beli ='7109000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6481500',harga_beli ='6481500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6671500',harga_beli ='6671500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7660000',harga_beli ='7660000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='15282000',harga_beli ='15282000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='1559000',harga_beli ='1559000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='1559000',harga_beli ='1559000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='1483000',harga_beli ='1483000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='1426000',harga_beli ='1426000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4714000',harga_beli ='4714000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='8097500',harga_beli ='8097500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='9256500',harga_beli ='9256500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7869000',harga_beli ='7869000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7375000',harga_beli ='7375000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='8078500',harga_beli ='8078500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7204000',harga_beli ='7204000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4296000',harga_beli ='4296000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='51566500',harga_beli ='51566500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='8021000',harga_beli ='8021000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7413000',harga_beli ='7413000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5493500',harga_beli ='5493500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='10549000',harga_beli ='10549000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='12242000',harga_beli ='12242000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='7033000',harga_beli ='7033000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5683500',harga_beli ='5683500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6234500',harga_beli ='6234500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4885000',harga_beli ='4885000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2611000',harga_beli ='2611000' WHERE kode_barcode='00045049' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='00045050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4397000',harga_beli ='4397000' WHERE kode_barcode='00045051' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='6149000',harga_beli ='6149000' WHERE kode_barcode='00045052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4828000',harga_beli ='4828000' WHERE kode_barcode='00045053' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4861000',harga_beli ='4861000' WHERE kode_barcode='00045055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='8450500',harga_beli ='8450500' WHERE kode_barcode='00045056' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2834000',harga_beli ='2834000' WHERE kode_barcode='00045057' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3418000',harga_beli ='3418000' WHERE kode_barcode='00045058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='2782500',harga_beli ='2782500' WHERE kode_barcode='00045059' LIMIT 1;
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2290000','input','2026-07-08 13:37:16');
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='16059000',harga_beli ='16059000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='9421500',harga_beli ='9421500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4964000',harga_beli ='4964000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5003000',harga_beli ='5003000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5805500',harga_beli ='5805500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='4406500',harga_beli ='4406500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='10944000',harga_beli ='10944000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3359000',harga_beli ='3359000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='12595000',harga_beli ='12595000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5987500',harga_beli ='5987500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='1305500',harga_beli ='1305500' WHERE kode_barcode='00045054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3220000',harga_beli ='3220000' WHERE kode_barcode='00045060' LIMIT 1;
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2290000','input','2026-07-08 13:37:22');
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2290000','input','2026-07-08 13:37:29');
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2290000','input','2026-07-08 13:37:34');
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2290000','input','2026-07-08 13:37:37');
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2290000','input','2026-07-08 13:37:40');
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2290000','input','2026-07-08 13:37:44');
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='3459500',harga_beli ='3459500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2290000',harga_jual='5759500',harga_beli ='5759500' WHERE kode_barcode='00045041' LIMIT 1;
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2290000','input','2026-07-08 13:37:48');
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-02550';
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-ZGXH-16-0','00045061','DP-02550BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','290000','2026-07-08','290000','1.420','17.00','10','310000','1200000.00','1','0.14', 'input','2026-07-08 13:40:26','1.420','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02550BIP','1','RS 10 5','','DP-02550');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-16-0','00045061');
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 ('2026-07-08','PSPLT-ZGXH-16-0','PSPLT','TOKO','PSNB','17.00','1.420','1.420','1','1.420','1.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02550BIP ');
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-02603';
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-ZGXH-17-0','00045062','DP-02603DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','157000','2026-07-08','157000','1.570','100.00','925','280000','100000.00','1','0.14', 'input','2026-07-08 13:43:27','1.570','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02603DU','1','RS 11','','DP-02603');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXH-17-0','00045062');
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 ('2026-07-08','PSPRT-ZGXH-17-0','PSPRT','TOKO','DUPSN','100.00','1.570','1.570','1','1.570','1.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02603DU ');
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-02605';
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-ZGXH-18-0','00045063','DP-02605DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','440500','2026-07-08','440500','4.400','100.00','925','210000','100000.00','1','0.14', 'input','2026-07-08 13:45:10','4.400','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02605DU','1','RS 21 5','','DP-02605');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXH-18-0','00045063');
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 ('2026-07-08','PSPRT-ZGXH-18-0','PSPRT','TOKO','DUPSN','100.00','4.400','4.400','1','4.400','4.400','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02605DU ');
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-02566';
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-ZGXH-19-0','00045064','DP-02566DU ','CINCIN PERAK SR-02 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','348000','2026-07-08','348000','3.480','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-08 13:47:13','3.480','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02566DU','1','RS 125 RS 225','','DP-02566');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXH-19-0','00045064');
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 ('2026-07-08','PSPRT-ZGXH-19-0','PSPRT','TOKO','DUPSN','100.00','3.480','3.480','1','3.480','3.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02566DU ');
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-02641';
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-ZGXH-20-0','00045065','DP-02641SBY ','CINCIN PREAK YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','311000','2026-07-08','311000','3.110','100.00','925','410000','100000.00','1','0.014', 'input','2026-07-08 13:50:21','3.110','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02641SBY','1','RS 10 RS 165','','DP-02641');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXH-20-0','00045065');
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 ('2026-07-08','PSPRT-ZGXH-20-0','PSPRT','TOKO','SBYPSN','100.00','3.110','3.110','1','3.110','3.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02641SBY ');
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-02495';
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-ZGXH-21-0','00045066','DP-02495SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1792500','2026-07-08','1792500','2.620','57.00','50','300000','1200000.00','1','0.014', 'input','2026-07-08 13:51:55','2.620','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02495SBY','1','RS 15','','DP-02495');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-21-0','00045066');
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 ('2026-07-08','PSPLT-ZGXH-21-0','PSPLT','TOKO','SBYPSN','57.00','2.620','2.620','1','2.620','2.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02495SBY ');
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-02509';
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-ZGXH-22-0','00045067','DP-02509SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1359500','2026-07-08','1359500','3.540','32.00','25','250000','1200000.00','1','0.014', 'input','2026-07-08 13:54:03','3.540','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02509SBY','1','RS 21','','DP-02509');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-22-0','00045067');
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 ('2026-07-08','PSPLT-ZGXH-22-0','PSPLT','TOKO','SBYPSN','32.00','3.540','3.540','1','3.540','3.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02509SBY ');
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-02492';
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-ZGXH-23-0','00045068','DP-02492SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1459500','2026-07-08','1459500','3.800','32.00','25','250000','1200000.00','1','0.014', 'input','2026-07-08 13:55:29','3.800','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02492SBY','1','RS 23','','DP-02492');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-23-0','00045068');
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 ('2026-07-08','PSPLT-ZGXH-23-0','PSPLT','TOKO','SBYPSN','32.00','3.800','3.800','1','3.800','3.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02492SBY ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260629-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260629-0004';
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 ('CBRE-ZGXH-24-0','00045069','CBRE-00419 ','CINCIN CBRE-00419 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','14891000','2026-07-08','14891000','8.670','75.00','75.00','0','2290000.00','1','0.04', 'input','2026-07-08 15:05:19','8.670','0','323.20','18100.00','','TOKO','FREETAG','','10','','0','IDB 72 000 000','2','RS18 15B7 0626','BE-260629-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-24-0','00045069');
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 ('2026-07-08','CBRE-ZGXH-24-0','CBRE','TOKO','CBRE.BALIK','75.00','8.670','8.670','1','8.670','8.670','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00419 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-24-0','00045069','RD','37','0.510 ','320','163.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-24-0','00045069','RD','99','0.500 ','320','160');
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-260708-0008','1','CBRE-ZGXH-24-0','1','8.670','8.670','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-24-0','75.00','1','8.670','8.670','1','8.670','8.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.670',berat_out_asli=berat_out_asli+'8.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-260708-0008','2026-07-08','2026-07-08','15:05','8.67','input','2026-07-08 15:05:37');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260706-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260706-0003';
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 ('CBRE-ZGXH-25-0','00045070','CBRE-06530 ','CINCIN CBRE-06530 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1178500','2026-07-08','1178500','0.620','83.00','75','0','2290000.00','1','0.04', 'input','2026-07-08 15:10:22','0.620','200000','49.50','18100.00','','TOKO','FREETAG','','10','','0','IDB 8 500 000','3','RS10 2B25 0726','BE-260706-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-25-0','00045070');
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 ('2026-07-08','CBRE-ZGXH-25-0','CBRE','TOKO','CBRE.BALIK','83.00','0.620','0.620','1','0.620','0.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06530 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-25-0','00045070','RD','18','0.110 ','450','49.5');
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-260708-0009','1','CBRE-ZGXH-25-0','1','0.620','0.620','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZGXH-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2026-07-08','TOKO','SEM-BALIK','CBRE','CBRE-ZGXH-25-0','83.00','1','0.620','0.620','1','0.620','0.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.620',berat_out_asli=berat_out_asli+'0.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-260708-0009','2026-07-08','2026-07-08','15:10','0.62','input','2026-07-08 15:10:38');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260706-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260706-0002';
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 ('CBRE-ZGXH-26-0','00045071','CBRE-07055 ','CBRE-07055 GIA 7408632408 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','5891500','2026-07-08','5891500','3.430','75.00','75','0','2290000.00','1','0.14', 'input','2026-07-08 15:16:42','3.430','0','341.40','18100.00','','TOKO','FREETAG','','10','','','GDR 44 000 000','1','DVVS1 11B2 0726','BE-260706-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZGXH-26-0','00045071');
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 ('2026-07-08','CBRE-ZGXH-26-0','CBRE','TOKO','SEM-BALIK','75.00','3.430','3.430','1','3.430','3.430','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07055 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-26-0','00045071','RD','1','0.170 ','1500','255');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZGXH-26-0','00045071','RD','59','0.270 ','320','86.4');
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-260708-0010','1','ABRE-ZGXH-11-0','1','4.920','4.920','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZGXH-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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('2026-07-08','TOKO','ABRE.BALIK','ABRE','ABRE-ZGXH-11-0','75.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='2026-07-08' AND kode_barang='ABRE-ZGXH-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0010','2026-07-08','2026-07-08','15:33','4.92','input','2026-07-08 15:34:06');
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-260708-0011','1','AMP-ZGXH-15-0','1','1.850','1.850','TOKO','SEM-EMAS','TOKO','AMPE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='AMPE.BALIK' WHERE kode_barang='AMP-ZGXH-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
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('2026-07-08','TOKO','AMPE.BALIK','AMP','AMP-ZGXH-15-0','76.00','1','1.850','1.850','1','1.850','1.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.850',berat_out_asli=berat_out_asli+'1.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='AMP-ZGXH-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260708-0011','2026-07-08','2026-07-08','15:34','1.85','input','2026-07-08 15:34:21');
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-260708-0012','1','TFC-ZGXH-13-0','1','1.990','1.990','TOKO','SEM-BALIK','TOKO','TFC.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFC.BALIK' WHERE kode_barang='TFC-ZGXH-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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('2026-07-08','TOKO','TFC.BALIK','TFC','TFC-ZGXH-13-0','75.00','1','1.990','1.990','1','1.990','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.990',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='TFC-ZGXH-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0012','2026-07-08','2026-07-08','15:34','1.99','input','2026-07-08 15:34:37');
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-260708-0013','1','TFCMR-ZGXH-9-0','1','0.750','0.750','TOKO','SEM-EMAS','TOKO','CMPTF');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMPTF' WHERE kode_barang='TFCMR-ZGXH-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
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('2026-07-08','TOKO','CMPTF','TFCMR','TFCMR-ZGXH-9-0','76.00','1','0.750','0.750','1','0.750','0.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.750',berat_out_asli=berat_out_asli+'0.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='TFCMR-ZGXH-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260708-0013','2026-07-08','2026-07-08','15:34','0.75','input','2026-07-08 15:34: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-260708-0014','1','CBRE-ZGXH-10-0','1','2.830','2.830','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.830',berat_in_asli=berat_in_asli+'2.830',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.830',berat_akhir_asli=berat_akhir_asli+'2.830' WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.830',berat_out_asli=berat_out_asli+'2.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','2','CBRE-ZGXH-14-0','1','1.620','1.620','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.620',berat_in_asli=berat_in_asli+'1.620',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.620',berat_akhir_asli=berat_akhir_asli+'1.620' WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.620',berat_out_asli=berat_out_asli+'1.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','3','CBRE-ZGXH-5-0','1','1.820','1.820','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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('2026-07-08','TOKO','CBRE.BALIK','CBRE','CBRE-ZGXH-5-0','83.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='2026-07-08' AND kode_barang='CBRE-ZGXH-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','4','CBRE-ZGXH-6-0','1','2.560','2.560','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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('2026-07-08','TOKO','CBRE.BALIK','CBRE','CBRE-ZGXH-6-0','75.00','1','2.560','2.560','1','2.560','2.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.560',berat_out_asli=berat_out_asli+'2.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','5','CBRE-ZGXH-26-0','1','3.430','3.430','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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('2026-07-08','TOKO','CBRE.BALIK','CBRE','CBRE-ZGXH-26-0','75.00','1','3.430','3.430','1','3.430','3.430');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.430',berat_out_asli=berat_out_asli+'3.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','6','CBRE-ZGXH-24-0','1','8.670','8.670','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'8.670',berat_in_asli=berat_in_asli+'8.670',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'8.670',berat_akhir_asli=berat_akhir_asli+'8.670' WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.670',berat_out_asli=berat_out_asli+'8.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','7','CBRE-ZGXH-4-0','1','1.520','1.520','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.520',berat_in_asli=berat_in_asli+'1.520',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.520',berat_akhir_asli=berat_akhir_asli+'1.520' WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.520',berat_out_asli=berat_out_asli+'1.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','8','CBRE-ZGXH-12-0','1','1.650','1.650','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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('2026-07-08','TOKO','CBRE.BALIK','CBRE','CBRE-ZGXH-12-0','75.00','1','1.650','1.650','1','1.650','1.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.650',berat_out_asli=berat_out_asli+'1.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','9','CBRE-ZGXH-7-0','1','3.580','3.580','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.580',berat_in_asli=berat_in_asli+'3.580',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.580',berat_akhir_asli=berat_akhir_asli+'3.580' WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.580',berat_out_asli=berat_out_asli+'3.580',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','10','CBRE-ZGXH-25-0','1','0.620','0.620','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.620',berat_in_asli=berat_in_asli+'0.620',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.620',berat_akhir_asli=berat_akhir_asli+'0.620' WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.620',berat_out_asli=berat_out_asli+'0.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','11','CBRE-ZGXH-8-0','1','2.540','2.540','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZGXH-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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('2026-07-08','TOKO','CBRE.BALIK','CBRE','CBRE-ZGXH-8-0','83.00','1','2.540','2.540','1','2.540','2.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.540',berat_out_asli=berat_out_asli+'2.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-08' AND kode_barang='CBRE-ZGXH-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-260708-0014','2026-07-08','2026-07-08','15:35','30.84','input','2026-07-08 15:36:20');
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-02621';
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-ZGXH-27-0','00045072','DP-02621BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','655000','2026-07-08','655000','3.210','17.00','10','260000','1200000.00','1','0.14', 'input','2026-07-08 15:46:06','3.210','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02621BIP','1','RS 12','','DP-02621');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-27-0','00045072');
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 ('2026-07-08','PSPLT-ZGXH-27-0','PSPLT','TOKO','PSNB','17.00','3.210','3.210','1','3.210','3.210','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02621BIP ');
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-02608';
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-ZGXH-28-0','00045073','DP-02608BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','439000','2026-07-08','439000','2.150','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-08 15:47:32','2.150','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02608BIP','1','RS 18','','DP-02608');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-28-0','00045073');
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 ('2026-07-08','PSPLT-ZGXH-28-0','PSPLT','TOKO','PSNB','17.00','2.150','2.150','1','2.150','2.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02608BIP ');
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-02677';
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-ZGXH-29-0','00045074','DP-02677BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','502000','2026-07-08','502000','2.460','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-08 15:49:05','2.460','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02677BIP','1','RS 19','','DP-02677');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-29-0','00045074');
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 ('2026-07-08','PSPLT-ZGXH-29-0','PSPLT','TOKO','PSNB','17.00','2.460','2.460','1','2.460','2.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02677BIP ');
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-02581';
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 ('PSGT-ZGXH-30-0','00045075','DP-02581BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','1237000','2026-07-08','1237000','1.200','45.00','375','480000','2290000.00','1','0.14', 'input','2026-07-08 15:56:40','1.200','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02581BIP','1','RS 9','','DP-02581');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGXH-30-0','00045075');
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 ('2026-07-08','PSGT-ZGXH-30-0','PSGT','TOKO','PSNB','45.00','1.200','1.200','1','1.200','1.200','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02581BIP ');
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-02701';
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-ZGXH-31-0','00045076','DP-02701DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','524500','2026-07-08','524500','2.570','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-08 15:58:27','2.570','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02701DU','1','RS 12 5','','DP-02701');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-31-0','00045076');
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 ('2026-07-08','PSPLT-ZGXH-31-0','PSPLT','TOKO','DUPSN','17.00','2.570','2.570','1','2.570','2.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02701DU ');
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-02702';
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-ZGXH-32-0','00045077','DP-02702DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','618500','2026-07-08','618500','3.030','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-08 15:59:46','3.030','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02702DU','1','RS 19','','DP-02702');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-32-0','00045077');
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 ('2026-07-08','PSPLT-ZGXH-32-0','PSPLT','TOKO','DUPSN','17.00','3.030','3.030','1','3.030','3.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02702DU ');
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-02734';
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-ZGXH-33-0','00045078','DP-02734SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1859000','2026-07-08','1859000','4.840','32.00','25','260000','1200000.00','1','0.014', 'input','2026-07-08 16:01:27','4.840','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02734SBY','1','RS 15','','DP-02734');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXH-33-0','00045078');
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 ('2026-07-08','PSPLT-ZGXH-33-0','PSPLT','TOKO','SBYPSN','32.00','4.840','4.840','1','4.840','4.840','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02734SBY ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-08 ','16:16:32');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0003','1','PSBY-ZGXG-4-0','1','2.960','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.960',berat_out_asli='2.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.960',berat_akhir_asli =berat_akhir_asli-'2.960' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','2','PSBY-ZGXG-5-0','1','2.150','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-5-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.150' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','3','PSBY-ZGXG-6-0','1','3.170','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.170',berat_out_asli='3.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.170',berat_akhir_asli =berat_akhir_asli-'3.170' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','4','PSBY-ZGXG-7-0','1','1.940','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.940',berat_out_asli='1.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.940',berat_akhir_asli =berat_akhir_asli-'1.940' WHERE kode_barang='PSBY-ZGXG-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0003','5','PSBY-ZGXG-8-0','1','1.840','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-8-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='PSBY-ZGXG-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-260708-0003','6','PSBY-ZGXG-9-0','1','2.370','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.370',berat_out_asli='2.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.370',berat_akhir_asli =berat_akhir_asli-'2.370' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','7','PSBY-ZGXG-10-0','1','2.340','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.340',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.340',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','8','PSBY-ZGXG-11-0','1','2.250','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.250',berat_out_asli='2.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.250',berat_akhir_asli =berat_akhir_asli-'2.250' WHERE kode_barang='PSBY-ZGXG-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0003','9','PSBY-ZGXG-12-0','1','1.700','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.700',berat_out_asli='1.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.700',berat_akhir_asli =berat_akhir_asli-'1.700' WHERE kode_barang='PSBY-ZGXG-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0003','10','PSBY-ZGXG-13-0','1','2.430','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.430',berat_out_asli='2.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.430',berat_akhir_asli =berat_akhir_asli-'2.430' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','11','PSBY-ZGXG-14-0','1','3.160','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','12','PSBY-ZGXG-15-0','1','2.860','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.860',berat_out_asli='2.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.860',berat_akhir_asli =berat_akhir_asli-'2.860' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','13','PSBY-ZGXG-16-0','1','1.130','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.130',berat_out_asli='1.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.130',berat_akhir_asli =berat_akhir_asli-'1.130' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','14','PSBY-ZGXG-17-0','1','2.120','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-17-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.120',berat_out_asli='2.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.120',berat_akhir_asli =berat_akhir_asli-'2.120' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','15','PSBY-ZGXG-18-0','1','1.090','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-18-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.090',berat_out_asli='1.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.090',berat_akhir_asli =berat_akhir_asli-'1.090' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','16','PSBY-ZGXG-19-0','1','1.310','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.310',berat_out_asli='1.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.310',berat_akhir_asli =berat_akhir_asli-'1.310' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','17','PSBY-ZGXG-20-0','1','2.610','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-20-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='PSBY-ZGXG-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-260708-0003','18','PSBY-ZGXG-21-0','1','1.860','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.860',berat_out_asli='1.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.860',berat_akhir_asli =berat_akhir_asli-'1.860' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','19','PSBY-ZGXG-22-0','1','1.490','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-22-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.490',berat_out_asli='1.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.490',berat_akhir_asli =berat_akhir_asli-'1.490' WHERE kode_barang='PSBY-ZGXG-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-260708-0003','20','PSBY-ZGXG-23-0','1','2.530','TOKO','SBYPER');
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGXG-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZGXG-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZGXG-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZGXG-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZGXG-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.530',berat_out_asli='2.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.530',berat_akhir_asli =berat_akhir_asli-'2.530' WHERE kode_barang='PSBY-ZGXG-23-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-260708-0003','2026-07-08','2026-07-08','16:21','2.530','input','2026-07-08 16:21:58','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260708-0004','1','PSPRT-ZGXH-20-0','1','3.110','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXH-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXH-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXH-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXH-20-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZGXH-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.110',berat_out_asli='3.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.110',berat_akhir_asli =berat_akhir_asli-'3.110' WHERE kode_barang='PSPRT-ZGXH-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-260708-0004','2','PSPLT-ZGXH-21-0','1','2.620','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXH-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXH-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXH-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXH-21-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZGXH-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.620',berat_out_asli='2.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.620',berat_akhir_asli =berat_akhir_asli-'2.620' WHERE kode_barang='PSPLT-ZGXH-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-260708-0004','3','PSPLT-ZGXH-22-0','1','3.540','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXH-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXH-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXH-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXH-22-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZGXH-22-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='PSPLT-ZGXH-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-260708-0004','4','PSPLT-ZGXH-23-0','1','3.800','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXH-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXH-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXH-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXH-23-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZGXH-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.800',berat_out_asli='3.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.800',berat_akhir_asli =berat_akhir_asli-'3.800' WHERE kode_barang='PSPLT-ZGXH-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-260708-0004','5','PSPLT-ZGXH-33-0','1','4.840','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXH-33-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXH-33-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXH-33-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXH-33-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZGXH-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.840',berat_out_asli='4.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.840',berat_akhir_asli =berat_akhir_asli-'4.840' WHERE kode_barang='PSPLT-ZGXH-33-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-260708-0004','2026-07-08','2026-07-08','16:22','4.840','input','2026-07-08 16:22:13','THIFA');