INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-17 ','08:03:47');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-16';
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-06-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-16' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-06-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-17 ','08:04:24');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0001','1','ABRE-ZFAF-6-0','1','1.190','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZFAF-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZFAF-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZFAF-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZFAF-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZFAF-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.190',berat_out_asli='1.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.190',berat_akhir_asli =berat_akhir_asli-'1.190' WHERE kode_barang='ABRE-ZFAF-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-260617-0001','2','ABRE-ZFAF-11-0','1','2.290','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZFAF-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZFAF-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZFAF-11-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZFAF-11-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZFAF-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.290',berat_out_asli='2.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.290',berat_akhir_asli =berat_akhir_asli-'2.290' WHERE kode_barang='ABRE-ZFAF-11-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-260617-0001','2026-06-17','2026-06-17','08:05','2.290','input','2026-06-17 08:05:50','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0002','1','AMK-ZFAF-5-0','1','1.790','TOKO','AMKE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='AMK-ZFAF-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='AMK-ZFAF-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='AMK-ZFAF-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='AMK-ZFAF-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='AMK' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='AMK' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='AMKE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='AMKE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='AMK-ZFAF-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.790',berat_out_asli='1.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.790',berat_akhir_asli =berat_akhir_asli-'1.790' WHERE kode_barang='AMK-ZFAF-5-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-260617-0002','2026-06-17','2026-06-17','08:06','1.790','input','2026-06-17 08:06:04','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0003','1','AMP-ZFAF-3-0','1','1.610','TOKO','AMPE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='AMP-ZFAF-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='AMP-ZFAF-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='AMP-ZFAF-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='AMP-ZFAF-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='AMP' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='AMP' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='AMPE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='AMPE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='AMP-ZFAF-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.610',berat_out_asli='1.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.610',berat_akhir_asli =berat_akhir_asli-'1.610' WHERE kode_barang='AMP-ZFAF-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-260617-0003','2026-06-17','2026-06-17','08:06','1.610','input','2026-06-17 08:06:14','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0004','1','CBRE-ZFAF-2-0','1','3.300','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZFAF-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZFAF-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZFAF-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZFAF-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZFAF-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.300',berat_out_asli='3.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.300',berat_akhir_asli =berat_akhir_asli-'3.300' WHERE kode_barang='CBRE-ZFAF-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-260617-0004','2','CBRE-ZFAF-4-0','1','3.250','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZFAF-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZFAF-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZFAF-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZFAF-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZFAF-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.250',berat_out_asli='3.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.250',berat_akhir_asli =berat_akhir_asli-'3.250' WHERE kode_barang='CBRE-ZFAF-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-260617-0004','3','CBRE-ZFAF-13-0','1','1.470','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZFAF-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZFAF-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZFAF-13-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZFAF-13-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZFAF-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.470',berat_out_asli='1.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.470',berat_akhir_asli =berat_akhir_asli-'1.470' WHERE kode_barang='CBRE-ZFAF-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-260617-0004','4','CBRE-ZFAF-14-0','1','2.640','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZFAF-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZFAF-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZFAF-14-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZFAF-14-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZFAF-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.640',berat_out_asli='2.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.640',berat_akhir_asli =berat_akhir_asli-'2.640' WHERE kode_barang='CBRE-ZFAF-14-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-260617-0004','2026-06-17','2026-06-17','08:06','2.640','input','2026-06-17 08:06:23','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0005','1','CKSE-ZFAF-7-0','1','2.970','TOKO','CKSE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAF-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAF-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAF-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAF-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKSE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKSE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAF-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.970',berat_out_asli='2.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.970',berat_akhir_asli =berat_akhir_asli-'2.970' WHERE kode_barang='CKSE-ZFAF-7-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-260617-0005','2026-06-17','2026-06-17','08:06','2.970','input','2026-06-17 08:06:31','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0006','1','CMK-ZFAF-15-0','1','4.160','TOKO','CMKE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CMK-ZFAF-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMK-ZFAF-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CMK-ZFAF-15-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMK-ZFAF-15-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CMK' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMK' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMKE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMKE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMK-ZFAF-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.160',berat_out_asli='4.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.160',berat_akhir_asli =berat_akhir_asli-'4.160' WHERE kode_barang='CMK-ZFAF-15-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-260617-0006','2026-06-17','2026-06-17','08:06','4.160','input','2026-06-17 08:06:40','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0007','1','LBRE-ZFAF-1-0','1','1.360','TOKO','LBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-ZFAF-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LBRE-ZFAF-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LBRE-ZFAF-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LBRE-ZFAF-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LBRE-ZFAF-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.360',berat_out_asli='1.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.360',berat_akhir_asli =berat_akhir_asli-'1.360' WHERE kode_barang='LBRE-ZFAF-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260617-0007','2026-06-17','2026-06-17','08:06','1.360','input','2026-06-17 08:06:53','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0008','1','KMR-ZFAF-9-0','1','2.990','TOKO','KMPE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KMR-ZFAF-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KMR-ZFAF-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KMR-ZFAF-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KMR-ZFAF-9-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='KMR' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='KMR' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='KMPE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KMPE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='KMR-ZFAF-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.990',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.990',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='KMR-ZFAF-9-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-260617-0008','2026-06-17','2026-06-17','08:07','2.990','input','2026-06-17 08:07:04','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0009','1','KLPR-ZFAF-10-0','1','14.950','TOKO','KLPE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KLPR-ZFAF-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KLPR-ZFAF-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KLPR-ZFAF-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KLPR-ZFAF-10-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='KLPR' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='KLPR' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='KLPE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KLPE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='KLPR-ZFAF-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='14.950',berat_out_asli='14.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'14.950',berat_akhir_asli =berat_akhir_asli-'14.950' WHERE kode_barang='KLPR-ZFAF-10-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-260617-0009','2026-06-17','2026-06-17','08:07','14.950','input','2026-06-17 08:07:13','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0010','1','TFG-ZFAF-12-0','1','8.450','TOKO','TFG.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='TFG-ZFAF-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFG-ZFAF-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFG-ZFAF-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFG-ZFAF-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TFG.BALIK';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TFG.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFG-ZFAF-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.450',berat_out_asli='8.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.450',berat_akhir_asli =berat_akhir_asli-'8.450' WHERE kode_barang='TFG-ZFAF-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-260617-0010','2','TFG-ZFAF-16-0','1','8.190','TOKO','TFG.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='TFG-ZFAF-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFG-ZFAF-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFG-ZFAF-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFG-ZFAF-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TFG.BALIK';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TFG.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFG-ZFAF-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.190',berat_out_asli='8.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.190',berat_akhir_asli =berat_akhir_asli-'8.190' WHERE kode_barang='TFG-ZFAF-16-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-260617-0010','2026-06-17','2026-06-17','08:07','8.190','input','2026-06-17 08:07:32','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0011','1','TFGKK-ZFAF-8-0','1','3.840','TOKO','GLKTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGKK-ZFAF-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGKK-ZFAF-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGKK-ZFAF-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGKK-ZFAF-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGKK' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGKK' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLKTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLKTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGKK-ZFAF-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.840',berat_out_asli='3.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.840',berat_akhir_asli =berat_akhir_asli-'3.840' WHERE kode_barang='TFGKK-ZFAF-8-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-260617-0011','2026-06-17','2026-06-17','08:07','3.840','input','2026-06-17 08:07:48','THIFA');
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='';
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 ('PMM-ZFAG-1-0','00044487','500K-165-1030 ','CINCIN SILVER 925 YL-01 ','','GR','---','PER','PMM','TOKO','MMPER','191000','2026-06-17','191000','1.910','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:29:14','1.910','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-1-0','00044487');
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-06-17','PMM-ZFAG-1-0','PMM','TOKO','MMPER','100.00','1.910','1.910','1','1.910','1.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-165-1030 ');
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='';
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 ('PMM-ZFAG-2-0','00044488','500K-145-1031 ','CINCIN SILVER 925 YL-01 ','','GR','---','PER','PMM','TOKO','MMPER','189000','2026-06-17','189000','1.890','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:29:39','1.890','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-2-0','00044488');
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-06-17','PMM-ZFAG-2-0','PMM','TOKO','MMPER','100.00','1.890','1.890','1','1.890','1.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-145-1031 ');
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='';
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 ('PMM-ZFAG-3-0','00044489','700K-115-1032 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','121000','2026-06-17','121000','1.210','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:30:45','1.210','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-3-0','00044489');
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-06-17','PMM-ZFAG-3-0','PMM','TOKO','MMPER','100.00','1.210','1.210','1','1.210','1.210','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','700K-115-1032 ');
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-02201';
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-ZFAG-4-0','00044490','DP-02201MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','2300500','2026-06-17','2300500','5.990','32.00','25','280000','1200000.00','1','0.14', 'input','2026-06-17 08:33:17','5.990','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02201MM','1','RS 28','','DP-02201');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAG-4-0','00044490');
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-06-17','PSPLT-ZFAG-4-0','PSPLT','TOKO','MMPSN','32.00','5.990','5.990','1','5.990','5.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02201MM ');
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='';
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 ('PMM-ZFAG-5-0','00044491','750K-20-1033 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','322000','2026-06-17','322000','3.220','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:34:39','3.220','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-5-0','00044491');
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-06-17','PMM-ZFAG-5-0','PMM','TOKO','MMPER','100.00','3.220','3.220','1','3.220','3.220','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-20-1033 ');
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='';
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 ('PMM-ZFAG-6-0','00044492','750K-11-1034 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','193000','2026-06-17','193000','1.930','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:35:04','1.930','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-6-0','00044492');
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-06-17','PMM-ZFAG-6-0','PMM','TOKO','MMPER','100.00','1.930','1.930','1','1.930','1.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-11-1034 ');
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='';
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 ('PMM-ZFAG-7-0','00044493','750K-11-1035 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','190000','2026-06-17','190000','1.900','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:35:32','1.900','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-7-0','00044493');
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-06-17','PMM-ZFAG-7-0','PMM','TOKO','MMPER','100.00','1.900','1.900','1','1.900','1.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-11-1035 ');
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='';
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 ('PMM-ZFAG-8-0','00044494','750K-185-1036 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','181000','2026-06-17','181000','1.810','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:36:05','1.810','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-8-0','00044494');
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-06-17','PMM-ZFAG-8-0','PMM','TOKO','MMPER','100.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-185-1036 ');
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='';
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 ('PMM-ZFAG-9-0','00044495','750K-9-1037 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','166000','2026-06-17','166000','1.660','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:36:29','1.660','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-9-0','00044495');
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-06-17','PMM-ZFAG-9-0','PMM','TOKO','MMPER','100.00','1.660','1.660','1','1.660','1.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-9-1037 ');
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='';
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 ('PMM-ZFAG-10-0','00044496','750K-165-1038 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','286000','2026-06-17','286000','2.860','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:36:51','2.860','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-10-0','00044496');
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-06-17','PMM-ZFAG-10-0','PMM','TOKO','MMPER','100.00','2.860','2.860','1','2.860','2.860','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-165-1038 ');
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='';
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 ('PMM-ZFAG-11-0','00044497','750K-18-1039 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','242000','2026-06-17','242000','2.420','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:37:14','2.420','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-11-0','00044497');
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-06-17','PMM-ZFAG-11-0','PMM','TOKO','MMPER','100.00','2.420','2.420','1','2.420','2.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-18-1039 ');
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='';
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 ('PMM-ZFAG-12-0','00044498','750K-215-1040 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','359000','2026-06-17','359000','3.590','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:37:40','3.590','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-12-0','00044498');
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-06-17','PMM-ZFAG-12-0','PMM','TOKO','MMPER','100.00','3.590','3.590','1','3.590','3.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-215-1040 ');
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='';
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 ('PMM-ZFAG-13-0','00044499','750K-175-1041 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','415500','2026-06-17','415500','4.150','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:38:20','4.150','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-13-0','00044499');
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-06-17','PMM-ZFAG-13-0','PMM','TOKO','MMPER','100.00','4.150','4.150','1','4.150','4.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-175-1041 ');
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='';
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 ('PMM-ZFAG-14-0','00044500','750K-17-1042 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','336000','2026-06-17','336000','3.360','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:38:56','3.360','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-14-0','00044500');
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-06-17','PMM-ZFAG-14-0','PMM','TOKO','MMPER','100.00','3.360','3.360','1','3.360','3.360','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-17-1042 ');
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='';
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 ('PMM-ZFAG-15-0','00044501','750K-21-1043 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','331000','2026-06-17','331000','3.310','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:39:30','3.310','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-15-0','00044501');
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-06-17','PMM-ZFAG-15-0','PMM','TOKO','MMPER','100.00','3.310','3.310','1','3.310','3.310','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-21-1043 ');
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='';
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 ('PMM-ZFAG-16-0','00044502','750K-19-1044 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','278000','2026-06-17','278000','2.780','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-17 08:40:06','2.780','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-16-0','00044502');
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-06-17','PMM-ZFAG-16-0','PMM','TOKO','MMPER','100.00','2.780','2.780','1','2.780','2.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-19-1044 ');
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='';
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 ('PMM-ZFAG-17-0','00044503','800K-195-1045 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','497000','2026-06-17','497000','4.970','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-17 08:40:44','4.970','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-17-0','00044503');
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-06-17','PMM-ZFAG-17-0','PMM','TOKO','MMPER','100.00','4.970','4.970','1','4.970','4.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','800K-195-1045 ');
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='';
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 ('PMM-ZFAG-18-0','00044504','800K-12-1046 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','246000','2026-06-17','246000','2.460','100.00','925','320000','100000.00','1','0.14', 'input','2026-06-17 08:41:22','2.460','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-18-0','00044504');
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-06-17','PMM-ZFAG-18-0','PMM','TOKO','MMPER','100.00','2.460','2.460','1','2.460','2.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','800K-12-1046 ');
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='';
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 ('PMM-ZFAG-19-0','00044505','850K-11-1047 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','204000','2026-06-17','204000','2.040','100.00','925','290000','100000.00','1','0.14', 'input','2026-06-17 08:42:06','2.040','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-19-0','00044505');
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-06-17','PMM-ZFAG-19-0','PMM','TOKO','MMPER','100.00','2.040','2.040','1','2.040','2.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','850K-11-1047 ');
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='';
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 ('PMM-ZFAG-20-0','00044506','900K-11-1048 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','196000','2026-06-17','196000','1.960','100.00','925','370000','100000.00','1','0.14', 'input','2026-06-17 08:42:35','1.960','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-20-0','00044506');
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-06-17','PMM-ZFAG-20-0','PMM','TOKO','MMPER','100.00','1.960','1.960','1','1.960','1.960','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','900K-11-1048 ');
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='';
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 ('PMM-ZFAG-21-0','00044507','900K-8-1049 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','174000','2026-06-17','174000','1.740','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-17 08:43:04','1.740','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZFAG-21-0','00044507');
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-06-17','PMM-ZFAG-21-0','PMM','TOKO','MMPER','100.00','1.740','1.740','1','1.740','1.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','900K-8-1049 ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0012','1','PSPLT-ZFAG-4-0','1','5.990','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAG-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAG-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAG-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAG-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFAG-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.990',berat_out_asli='5.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.990',berat_akhir_asli =berat_akhir_asli-'5.990' WHERE kode_barang='PSPLT-ZFAG-4-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-260617-0012','2026-06-17','2026-06-17','09:01','5.990','input','2026-06-17 09:01:44','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0013','1','PMM-ZFAG-1-0','1','1.910','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-1-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.910',berat_out_asli='1.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.910',berat_akhir_asli =berat_akhir_asli-'1.910' WHERE kode_barang='PMM-ZFAG-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-260617-0013','2','PMM-ZFAG-2-0','1','1.890','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-2-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.890',berat_out_asli='1.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.890',berat_akhir_asli =berat_akhir_asli-'1.890' WHERE kode_barang='PMM-ZFAG-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-260617-0013','3','PMM-ZFAG-3-0','1','1.210','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-3-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.210',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.210',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='PMM-ZFAG-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260617-0013','4','PMM-ZFAG-5-0','1','3.220','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.220',berat_out_asli='3.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.220',berat_akhir_asli =berat_akhir_asli-'3.220' WHERE kode_barang='PMM-ZFAG-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-260617-0013','5','PMM-ZFAG-6-0','1','1.930','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='PMM-ZFAG-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-260617-0013','6','PMM-ZFAG-7-0','1','1.900','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='PMM-ZFAG-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-260617-0013','7','PMM-ZFAG-8-0','1','1.810','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.810',berat_out_asli='1.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.810',berat_akhir_asli =berat_akhir_asli-'1.810' WHERE kode_barang='PMM-ZFAG-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-260617-0013','8','PMM-ZFAG-9-0','1','1.660','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.660',berat_out_asli='1.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.660',berat_akhir_asli =berat_akhir_asli-'1.660' WHERE kode_barang='PMM-ZFAG-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-260617-0013','9','PMM-ZFAG-10-0','1','2.860','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-10-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='PMM-ZFAG-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-260617-0013','10','PMM-ZFAG-11-0','1','2.420','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.420',berat_out_asli='2.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.420',berat_akhir_asli =berat_akhir_asli-'2.420' WHERE kode_barang='PMM-ZFAG-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-260617-0013','11','PMM-ZFAG-12-0','1','3.590','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.590',berat_out_asli='3.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.590',berat_akhir_asli =berat_akhir_asli-'3.590' WHERE kode_barang='PMM-ZFAG-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-260617-0013','12','PMM-ZFAG-13-0','1','4.150','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.150',berat_out_asli='4.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.150',berat_akhir_asli =berat_akhir_asli-'4.150' WHERE kode_barang='PMM-ZFAG-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-260617-0013','13','PMM-ZFAG-14-0','1','3.360','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.360',berat_out_asli='3.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.360',berat_akhir_asli =berat_akhir_asli-'3.360' WHERE kode_barang='PMM-ZFAG-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-260617-0013','14','PMM-ZFAG-15-0','1','3.310','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.310',berat_out_asli='3.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.310',berat_akhir_asli =berat_akhir_asli-'3.310' WHERE kode_barang='PMM-ZFAG-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-260617-0013','15','PMM-ZFAG-16-0','1','2.780','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.780',berat_out_asli='2.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.780',berat_akhir_asli =berat_akhir_asli-'2.780' WHERE kode_barang='PMM-ZFAG-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-260617-0013','16','PMM-ZFAG-17-0','1','4.970','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.970',berat_out_asli='4.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.970',berat_akhir_asli =berat_akhir_asli-'4.970' WHERE kode_barang='PMM-ZFAG-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-260617-0013','17','PMM-ZFAG-18-0','1','2.460','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.460',berat_out_asli='2.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.460',berat_akhir_asli =berat_akhir_asli-'2.460' WHERE kode_barang='PMM-ZFAG-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-260617-0013','18','PMM-ZFAG-19-0','1','2.040','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.040',berat_out_asli='2.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.040',berat_akhir_asli =berat_akhir_asli-'2.040' WHERE kode_barang='PMM-ZFAG-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-260617-0013','19','PMM-ZFAG-20-0','1','1.960','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='PMM-ZFAG-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-260617-0013','20','PMM-ZFAG-21-0','1','1.740','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFAG-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFAG-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFAG-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFAG-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='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFAG-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.740',berat_out_asli='1.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.740',berat_akhir_asli =berat_akhir_asli-'1.740' WHERE kode_barang='PMM-ZFAG-21-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-260617-0013','2026-06-17','2026-06-17','09:02','1.740','input','2026-06-17 09:02:01','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-17 ','11:25:50');
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-02278';
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-ZFAG-22-0','00044508','DP-02278MM ','CINCIN PERAK SR-01 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','324000','2026-06-17','324000','3.240','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-17 13:18:46','3.240','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02278MM','1','RS 11 5 RS 24','','DP-02278');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAG-22-0','00044508');
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-06-17','PSPRT-ZFAG-22-0','PSPRT','TOKO','MMPSN','100.00','3.240','3.240','1','3.240','3.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02278MM ');
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-02367';
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-ZFAG-23-0','00044509','DP-02367MM ','CINCIN PERAK SR-05 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','335000','2026-06-17','335000','3.350','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-17 13:20:47','3.350','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02367MM','1','RS 13 RS 23','','DP-02367');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAG-23-0','00044509');
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-06-17','PSPRT-ZFAG-23-0','PSPRT','TOKO','MMPSN','100.00','3.350','3.350','1','3.350','3.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02367MM ');
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-02255';
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-ZFAG-24-0','00044510','DP-02255BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','4578500','2026-06-17','4578500','2.270','83.00','75','350000','2430000.00','1','0.14', 'input','2026-06-17 13:22:55','2.270','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02255BIP','1','RS 17 5','','DP-02255');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZFAG-24-0','00044510');
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-06-17','PSGT-ZFAG-24-0','PSGT','TOKO','PSNB','83.00','2.270','2.270','1','2.270','2.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02255BIP ');
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-02312';
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-ZFAG-25-0','00044511','DP-02312BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','5083000','2026-06-17','5083000','2.520','83.00','75','450000','2430000.00','1','0.14', 'input','2026-06-17 13:25:04','2.520','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02313BIP','1','RS 16','','DP-02312');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZFAG-25-0','00044511');
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-06-17','PSGT-ZFAG-25-0','PSGT','TOKO','PSNB','83.00','2.520','2.520','1','2.520','2.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02312BIP ');
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-02360';
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-ZFAG-26-0','00044512','DP-02360BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','180000','2026-06-17','180000','1.800','100.00','925','340000','100000.00','1','0.14', 'input','2026-06-17 13:26:31','1.800','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02360BIP','1','RS 8','','DP-02360');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAG-26-0','00044512');
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-06-17','PSPRT-ZFAG-26-0','PSPRT','TOKO','PSNB','100.00','1.800','1.800','1','1.800','1.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02360BIP ');
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-02390';
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-ZFAG-27-0','00044513','DP-02390BIP ','CINCIN PERAK SR-03 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','341000','2026-06-17','341000','3.410','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-17 13:28:20','3.410','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02390BIP','1','RS 11 RS 20','','DP-02390');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAG-27-0','00044513');
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-06-17','PSPRT-ZFAG-27-0','PSPRT','TOKO','PSNB','100.00','3.410','3.410','1','3.410','3.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02390BIP ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-17 ','14:30:39');