INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','08:12:20');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-23';
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-02-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-23' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-02-24';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','08:15:16');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZBBD-1-0','00041747','CBRE-06990 ','CBRE-06990 GIA 7478252865 ','','GR','---','DM','CBRE','TOKO','CBRE','2375500','2026-02-24','2375500','1.060','83.00','75','0','2700000.00','1','0.04', 'input','2026-02-24 08:23:24','1.060','412000','255.00','17000.00','','TOKO','FREETAG','','10','','','IDR 24 500 000','1','DVVS2 0226','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZBBD-1-0','00041747');
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-02-24','CBRE-ZBBD-1-0','CBRE','TOKO','CBRE','83.00','1.060','1.060','1','1.060','1.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06990 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBBD-1-0','00041747','RD','1','0.170 ','1500','255');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZBBD-2-0','00041748','700K-12-988 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','127000','2026-02-24','127000','1.270','100.00','925','250000','100000.00','1','0.04', 'input','2026-02-24 08:30:14','1.270','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZBBD-2-0','00041748');
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-02-24','CKPRE-ZBBD-2-0','CKPRE','TOKO','PER','100.00','1.270','1.270','1','1.270','1.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-12-988 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZBBD-3-0','00041749','700K-14-989 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','122000','2026-02-24','122000','1.220','100.00','925','250000','100000.00','1','0.04', 'input','2026-02-24 08:30:54','1.220','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZBBD-3-0','00041749');
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-02-24','CKPRE-ZBBD-3-0','CKPRE','TOKO','PER','100.00','1.220','1.220','1','1.220','1.220','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-14-989 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZBBD-4-0','00041750','700K-13-990 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','123000','2026-02-24','123000','1.230','100.00','925','250000','100000.00','1','0.04', 'input','2026-02-24 08:31:30','1.230','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZBBD-4-0','00041750');
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-02-24','CKPRE-ZBBD-4-0','CKPRE','TOKO','PER','100.00','1.230','1.230','1','1.230','1.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-13-990 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZBBD-5-0','00041751','700K-11-991 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','123000','2026-02-24','123000','1.230','100.00','925','250000','100000.00','1','0.04', 'input','2026-02-24 08:32:00','1.230','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZBBD-5-0','00041751');
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-02-24','CKPRE-ZBBD-5-0','CKPRE','TOKO','PER','100.00','1.230','1.230','1','1.230','1.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-11-991 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZBBD-6-0','00041752','700K-15-992 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','125000','2026-02-24','125000','1.250','100.00','925','250000','100000.00','1','0.04', 'input','2026-02-24 08:32:28','1.250','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZBBD-6-0','00041752');
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-02-24','CKPRE-ZBBD-6-0','CKPRE','TOKO','PER','100.00','1.250','1.250','1','1.250','1.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-15-992 ');
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-ZBBD-7-0','00041753','900K-13-813 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','157000','2026-02-24','157000','1.570','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 08:40:06','1.570','0','','17000.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-ZBBD-7-0','00041753');
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-02-24','PMM-ZBBD-7-0','PMM','TOKO','MMPER','100.00','1.570','1.570','1','1.570','1.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','900K-13-813 ');
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-ZBBD-8-0','00041754','900K-165-914 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','151000','2026-02-24','151000','1.510','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 08:40:32','1.510','0','','17000.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-ZBBD-8-0','00041754');
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-02-24','PMM-ZBBD-8-0','PMM','TOKO','MMPER','100.00','1.510','1.510','1','1.510','1.510','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','900K-165-914 ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0001','1','CBRE-ZBBD-1-0','1','1.060','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZBBD-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZBBD-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZBBD-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZBBD-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='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';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZBBD-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.060',berat_out_asli='1.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.060',berat_akhir_asli =berat_akhir_asli-'1.060' WHERE kode_barang='CBRE-ZBBD-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-260224-0001','2026-02-24','2026-02-24','08:43','1.060','input','2026-02-24 08:43:43','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0002','1','CKPDE-ZBBC-76-0','1','4.360','TOKO','CKPDE');
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-76-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-76-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-76-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-76-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZBBC-76-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.360',berat_out_asli='4.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.360',berat_akhir_asli =berat_akhir_asli-'4.360' WHERE kode_barang='CKPDE-ZBBC-76-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0002','2','CKPDE-ZBBC-77-0','1','4.550','TOKO','CKPDE');
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-77-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-77-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-77-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-77-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZBBC-77-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.550',berat_out_asli='4.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.550',berat_akhir_asli =berat_akhir_asli-'4.550' WHERE kode_barang='CKPDE-ZBBC-77-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0002','3','CKPDE-ZBBC-78-0','1','4.700','TOKO','CKPDE');
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-78-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-78-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-78-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-78-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZBBC-78-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.700',berat_out_asli='4.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.700',berat_akhir_asli =berat_akhir_asli-'4.700' WHERE kode_barang='CKPDE-ZBBC-78-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0002','4','CKPDE-ZBBC-79-0','1','4.770','TOKO','CKPDE');
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-79-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-79-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-79-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-79-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZBBC-79-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.770',berat_out_asli='4.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.770',berat_akhir_asli =berat_akhir_asli-'4.770' WHERE kode_barang='CKPDE-ZBBC-79-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0002','5','CKPDE-ZBBC-80-0','1','4.790','TOKO','CKPDE');
DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZBBC-80-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZBBC-80-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZBBC-80-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZBBC-80-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZBBC-80-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.790',berat_out_asli='4.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.790',berat_akhir_asli =berat_akhir_asli-'4.790' WHERE kode_barang='CKPDE-ZBBC-80-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-260224-0002','2026-02-24','2026-02-24','08:43','4.790','input','2026-02-24 08:43:56','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0003','1','CKPRE-ZBBD-2-0','1','1.270','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZBBD-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.270',berat_out_asli='1.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.270',berat_akhir_asli =berat_akhir_asli-'1.270' WHERE kode_barang='CKPRE-ZBBD-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-260224-0003','2','CKPRE-ZBBD-3-0','1','1.220','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZBBD-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.220',berat_out_asli='1.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.220',berat_akhir_asli =berat_akhir_asli-'1.220' WHERE kode_barang='CKPRE-ZBBD-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-260224-0003','3','CKPRE-ZBBD-4-0','1','1.230','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZBBD-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.230',berat_out_asli='1.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.230',berat_akhir_asli =berat_akhir_asli-'1.230' WHERE kode_barang='CKPRE-ZBBD-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-260224-0003','4','CKPRE-ZBBD-5-0','1','1.230','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZBBD-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.230',berat_out_asli='1.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.230',berat_akhir_asli =berat_akhir_asli-'1.230' WHERE kode_barang='CKPRE-ZBBD-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-260224-0003','5','CKPRE-ZBBD-6-0','1','1.250','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBBD-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZBBD-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBBD-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZBBD-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZBBD-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.250',berat_out_asli='1.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.250',berat_akhir_asli =berat_akhir_asli-'1.250' WHERE kode_barang='CKPRE-ZBBD-6-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-260224-0003','2026-02-24','2026-02-24','08:44','1.250','input','2026-02-24 08:44:13','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0004','1','PMM-ZBBC-82-0','1','1.100','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZBBC-82-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZBBC-82-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZBBC-82-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZBBC-82-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-ZBBC-82-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.100',berat_out_asli='1.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.100',berat_akhir_asli =berat_akhir_asli-'1.100' WHERE kode_barang='PMM-ZBBC-82-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0004','2','PMM-ZBBC-83-0','1','1.160','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZBBC-83-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZBBC-83-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZBBC-83-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZBBC-83-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-ZBBC-83-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.160',berat_out_asli='1.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.160',berat_akhir_asli =berat_akhir_asli-'1.160' WHERE kode_barang='PMM-ZBBC-83-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0004','3','PMM-ZBBC-84-0','1','1.180','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZBBC-84-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZBBC-84-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZBBC-84-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZBBC-84-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-ZBBC-84-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.180',berat_out_asli='1.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.180',berat_akhir_asli =berat_akhir_asli-'1.180' WHERE kode_barang='PMM-ZBBC-84-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0004','4','PMM-ZBBD-7-0','1','1.570','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZBBD-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZBBD-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZBBD-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZBBD-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-ZBBD-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.570' WHERE kode_barang='PMM-ZBBD-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-260224-0004','5','PMM-ZBBD-8-0','1','1.510','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZBBD-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZBBD-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZBBD-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZBBD-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-ZBBD-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.510',berat_out_asli='1.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.510',berat_akhir_asli =berat_akhir_asli-'1.510' WHERE kode_barang='PMM-ZBBD-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-260224-0004','2026-02-24','2026-02-24','08:44','1.510','input','2026-02-24 08:44:43','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 ('LXPER-ZBBD-9-0','00041755','850K-145-00112 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','253500','2026-02-24','253500','2.530','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:41:26','2.530','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-9-0','00041755');
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-02-24','LXPER-ZBBD-9-0','LXPER','TOKO','LXPER','100.00','2.530','2.530','1','2.530','2.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','850K-145-00112 ');
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 ('LXPER-ZBBD-10-0','00041756','850K-145-00113 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','253500','2026-02-24','253500','2.530','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:41:54','2.530','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-10-0','00041756');
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-02-24','LXPER-ZBBD-10-0','LXPER','TOKO','LXPER','100.00','2.530','2.530','1','2.530','2.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','850K-145-00113 ');
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 ('LXPER-ZBBD-11-0','00041757','1.3-13-00114 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','306000','2026-02-24','306000','3.060','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:42:39','3.060','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-11-0','00041757');
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-02-24','LXPER-ZBBD-11-0','LXPER','TOKO','LXPER','100.00','3.060','3.060','1','3.060','3.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.3-13-00114 ');
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 ('LXPER-ZBBD-12-0','00041758','950K-12-00115 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','156000','2026-02-24','156000','1.560','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:43:17','1.560','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-12-0','00041758');
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-02-24','LXPER-ZBBD-12-0','LXPER','TOKO','LXPER','100.00','1.560','1.560','1','1.560','1.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','950K-12-00115 ');
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 ('LXPER-ZBBD-13-0','00041759','950K-13-00116 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','148000','2026-02-24','148000','1.480','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:43:56','1.480','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-13-0','00041759');
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-02-24','LXPER-ZBBD-13-0','LXPER','TOKO','LXPER','100.00','1.480','1.480','1','1.480','1.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','950K-13-00116 ');
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 ('LXPER-ZBBD-14-0','00041760','950K-135-00117 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','181000','2026-02-24','181000','1.810','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:44:36','1.810','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-14-0','00041760');
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-02-24','LXPER-ZBBD-14-0','LXPER','TOKO','LXPER','100.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','950K-135-00117 ');
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 ('LXPER-ZBBD-15-0','00041761','1.0K-19-00118 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','363000','2026-02-24','363000','3.630','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:45:21','3.630','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-15-0','00041761');
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-02-24','LXPER-ZBBD-15-0','LXPER','TOKO','LXPER','100.00','3.630','3.630','1','3.630','3.630','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.0K-19-00118 ');
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 ('LXPER-ZBBD-16-0','00041762','1.0K-115-00119 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','262000','2026-02-24','262000','2.620','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:46:05','2.620','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-16-0','00041762');
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-02-24','LXPER-ZBBD-16-0','LXPER','TOKO','LXPER','100.00','2.620','2.620','1','2.620','2.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.0K-115-00119 ');
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 ('LXPER-ZBBD-17-0','00041763','700K-13-00120 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','264000','2026-02-24','264000','2.640','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:46:48','2.640','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-17-0','00041763');
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-02-24','LXPER-ZBBD-17-0','LXPER','TOKO','LXPER','100.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-13-00120 ');
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 ('LXPER-ZBBD-18-0','00041764','900K-16-00121 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','257500','2026-02-24','257500','2.570','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:47:38','2.570','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-18-0','00041764');
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-02-24','LXPER-ZBBD-18-0','LXPER','TOKO','LXPER','100.00','2.570','2.570','1','2.570','2.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','900K-16-00121 ');
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 ('LXPER-ZBBD-19-0','00041765','700K-18-00122 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','221000','2026-02-24','221000','2.210','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:48:15','2.210','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-19-0','00041765');
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-02-24','LXPER-ZBBD-19-0','LXPER','TOKO','LXPER','100.00','2.210','2.210','1','2.210','2.210','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-18-00122 ');
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 ('LXPER-ZBBD-20-0','00041766','700K-165-00123 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','174000','2026-02-24','174000','1.740','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:48:57','1.740','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-20-0','00041766');
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-02-24','LXPER-ZBBD-20-0','LXPER','TOKO','LXPER','100.00','1.740','1.740','1','1.740','1.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-165-00123 ');
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 ('LXPER-ZBBD-21-0','00041767','700K-13-00124 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','118000','2026-02-24','118000','1.180','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:49:37','1.180','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-21-0','00041767');
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-02-24','LXPER-ZBBD-21-0','LXPER','TOKO','LXPER','100.00','1.180','1.180','1','1.180','1.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-13-00124 ');
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 ('LXPER-ZBBD-22-0','00041768','900K-135-00125 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','214000','2026-02-24','214000','2.140','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:50:16','2.140','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-22-0','00041768');
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-02-24','LXPER-ZBBD-22-0','LXPER','TOKO','LXPER','100.00','2.140','2.140','1','2.140','2.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','900K-135-00125 ');
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 ('LXPER-ZBBD-23-0','00041769','1.0K-105-00126 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','134000','2026-02-24','134000','1.340','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:50:51','1.340','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-23-0','00041769');
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-02-24','LXPER-ZBBD-23-0','LXPER','TOKO','LXPER','100.00','1.340','1.340','1','1.340','1.340','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.0K-105-00126 ');
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 ('LXPER-ZBBD-24-0','00041770','700K-13-00127 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','170000','2026-02-24','170000','1.700','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:51:31','1.700','0','','17000.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-24-0','00041770');
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-02-24','LXPER-ZBBD-24-0','LXPER','TOKO','LXPER','100.00','1.700','1.700','1','1.700','1.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-13-00127 ');
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 ('LXPER-ZBBD-25-0','00041771','1.0K-11-00128 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','197000','2026-02-24','197000','1.970','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:52:08','1.970','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-25-0','00041771');
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-02-24','LXPER-ZBBD-25-0','LXPER','TOKO','LXPER','100.00','1.970','1.970','1','1.970','1.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.0K-11-00128 ');
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 ('LXPER-ZBBD-26-0','00041772','700K-15-00129 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','394000','2026-02-24','394000','3.940','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:52:41','3.940','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-26-0','00041772');
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-02-24','LXPER-ZBBD-26-0','LXPER','TOKO','LXPER','100.00','3.940','3.940','1','3.940','3.940','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-15-00129 ');
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 ('LXPER-ZBBD-27-0','00041773','700K-135-00130 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','96000','2026-02-24','96000','0.960','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:53:16','0.960','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-27-0','00041773');
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-02-24','LXPER-ZBBD-27-0','LXPER','TOKO','LXPER','100.00','0.960','0.960','1','0.960','0.960','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-135-00130 ');
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 ('LXPER-ZBBD-28-0','00041774','700K-20-00131 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','432000','2026-02-24','432000','4.320','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:53:53','4.320','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-28-0','00041774');
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-02-24','LXPER-ZBBD-28-0','LXPER','TOKO','LXPER','100.00','4.320','4.320','1','4.320','4.320','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-20-00131 ');
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 ('LXPER-ZBBD-29-0','00041775','700K-12-00132 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','155000','2026-02-24','155000','1.550','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:54:31','1.550','0','','17000.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-29-0','00041775');
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-02-24','LXPER-ZBBD-29-0','LXPER','TOKO','LXPER','100.00','1.550','1.550','1','1.550','1.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-12-00132 ');
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 ('LXPER-ZBBD-30-0','00041776','850K-14-00133 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','178000','2026-02-24','178000','1.780','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:55:08','1.780','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-30-0','00041776');
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-02-24','LXPER-ZBBD-30-0','LXPER','TOKO','LXPER','100.00','1.780','1.780','1','1.780','1.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','850K-14-00133 ');
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 ('LXPER-ZBBD-31-0','00041777','800K-17-00134 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','504000','2026-02-24','504000','5.040','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:55:47','5.040','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-31-0','00041777');
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-02-24','LXPER-ZBBD-31-0','LXPER','TOKO','LXPER','100.00','5.040','5.040','1','5.040','5.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','800K-17-00134 ');
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 ('LXPER-ZBBD-32-0','00041778','1.050K-14-00135 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','134000','2026-02-24','134000','1.340','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:56:25','1.340','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-32-0','00041778');
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-02-24','LXPER-ZBBD-32-0','LXPER','TOKO','LXPER','100.00','1.340','1.340','1','1.340','1.340','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.050K-14-00135 ');
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 ('LXPER-ZBBD-33-0','00041779','700K-12-00136 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','278000','2026-02-24','278000','2.780','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 09:57:01','2.780','0','','17000.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-33-0','00041779');
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-02-24','LXPER-ZBBD-33-0','LXPER','TOKO','LXPER','100.00','2.780','2.780','1','2.780','2.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','700K-12-00136 ');
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 ('LXPER-ZBBD-34-0','00041780','1.4K-13-00137 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','355000','2026-02-24','355000','3.550','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 10:03:14','3.550','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-34-0','00041780');
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-02-24','LXPER-ZBBD-34-0','LXPER','TOKO','LXPER','100.00','3.550','3.550','1','3.550','3.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.4K-13-00137 ');
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 ('LXPER-ZBBD-35-0','00041781','1.35K-145-00138 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','181000','2026-02-24','181000','1.810','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 10:03:56','1.810','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-35-0','00041781');
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-02-24','LXPER-ZBBD-35-0','LXPER','TOKO','LXPER','100.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.35K-145-00138 ');
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 ('LXPER-ZBBD-36-0','00041782','1.05K-145-00139 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','LXPER','150000','2026-02-24','150000','1.500','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 10:04:36','1.500','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZBBD-36-0','00041782');
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-02-24','LXPER-ZBBD-36-0','LXPER','TOKO','LXPER','100.00','1.500','1.500','1','1.500','1.500','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.05K-145-00139 ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','10:10:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','10:18:43');
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2798000',harga_beli ='2798000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5667000',harga_beli ='5667000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='220500',harga_beli ='220500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3206000',harga_beli ='3206000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7098000',harga_beli ='7098000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2543500',harga_beli ='2543500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2589500',harga_beli ='2589500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6173500',harga_beli ='6173500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='22796500',harga_beli ='22796500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3172000',harga_beli ='3172000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3143000',harga_beli ='3143000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2970000',harga_beli ='2970000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3085500',harga_beli ='3085500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3056500',harga_beli ='3056500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8579000',harga_beli ='8579000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3284500',harga_beli ='3284500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='11767000',harga_beli ='11767000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='4244500',harga_beli ='4244500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='4989500',harga_beli ='4989500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5125000',harga_beli ='5125000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6028000',harga_beli ='6028000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='4876500',harga_beli ='4876500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6976500',harga_beli ='6976500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8331000',harga_beli ='8331000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='10046500',harga_beli ='10046500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8127500',harga_beli ='8127500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='1693500',harga_beli ='1693500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3138500',harga_beli ='3138500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='4786500',harga_beli ='4786500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='4335000',harga_beli ='4335000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2483500',harga_beli ='2483500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2393500',harga_beli ='2393500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7337500',harga_beli ='7337500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8805000',harga_beli ='8805000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3928500',harga_beli ='3928500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7789000',harga_beli ='7789000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6186000',harga_beli ='6186000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3003000',harga_beli ='3003000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='2551500',harga_beli ='2551500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5802500',harga_beli ='5802500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='4064000',harga_beli ='4064000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6023500',harga_beli ='6023500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7766500',harga_beli ='7766500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='11762500',harga_beli ='11762500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='10611000',harga_beli ='10611000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3883500',harga_beli ='3883500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6050500',harga_beli ='6050500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8443500',harga_beli ='8443500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7698500',harga_beli ='7698500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7924500',harga_beli ='7924500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='9098500',harga_beli ='9098500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='18151500',harga_beli ='18151500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='1851500',harga_beli ='1851500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='1851500',harga_beli ='1851500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='1761000',harga_beli ='1761000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='1693500',harga_beli ='1693500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5599000',harga_beli ='5599000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='9617500',harga_beli ='9617500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='10995000',harga_beli ='10995000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='9346500',harga_beli ='9346500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8760000',harga_beli ='8760000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='9595000',harga_beli ='9595000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8556500',harga_beli ='8556500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='61249000',harga_beli ='61249000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='9527500',harga_beli ='9527500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8805000',harga_beli ='8805000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6524500',harga_beli ='6524500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='12530000',harga_beli ='12530000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='14540500',harga_beli ='14540500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='8353500',harga_beli ='8353500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6750500',harga_beli ='6750500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7405000',harga_beli ='7405000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5802500',harga_beli ='5802500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2720000','input','2026-02-24 10:32:43');
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='19074000',harga_beli ='19074000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='11190500',harga_beli ='11190500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5896000',harga_beli ='5896000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5942000',harga_beli ='5942000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='6895500',harga_beli ='6895500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='5234000',harga_beli ='5234000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='12999000',harga_beli ='12999000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='3990000',harga_beli ='3990000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='14960500',harga_beli ='14960500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='7111500',harga_beli ='7111500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2720000','input','2026-02-24 10:32:49');
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2720000','input','2026-02-24 10:32:53');
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2720000','input','2026-02-24 10:32:57');
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2720000','input','2026-02-24 10:33:00');
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2720000','input','2026-02-24 10:33:04');
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2720000','input','2026-02-24 10:33:09');
UPDATE tm_barang SET harga_skrg ='2720000',harga_jual='4109000',harga_beli ='4109000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2720000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2720000','input','2026-02-24 10:33:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-02-24 ','11:00:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','13:37:18');
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-01777';
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-ZBBD-37-0','00041783','DP-01777BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','406500','2026-02-24','406500','4.060','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-24 13:40:51','4.060','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','DP-01777');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBBD-37-0','00041783');
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-02-24','PSPRT-ZBBD-37-0','PSPRT','TOKO','PSNB','100.00','4.060','4.060','1','4.060','4.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01777BIP ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260224-0005','1','PSPRT-ZBBD-37-0','1','4.060','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZBBD-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZBBD-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZBBD-37-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZBBD-37-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZBBD-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.060',berat_out_asli='4.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.060',berat_akhir_asli =berat_akhir_asli-'4.060' WHERE kode_barang='PSPRT-ZBBD-37-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-260224-0005','2026-02-24','2026-02-24','13:41','4.060','input','2026-02-24 13:41:24','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','14:14:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','14:27:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','15:19:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','15:36:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-24 ','17:05:09');
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-01707';
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-ZBBD-38-0','00041784','DP-01707MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1144500','2026-02-24','1144500','2.980','32.00','25','300000','1200000.00','1','0.14', 'input','2026-02-24 17:08:29','2.980','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01707MM','1','RS 13','','DP-01707');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBBD-38-0','00041784');
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-02-24','PSPLT-ZBBD-38-0','PSPLT','TOKO','MMPSN','32.00','2.980','2.980','1','2.980','2.980','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01707MM ');
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-01708';
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-ZBBD-39-0','00041785','DP-01708MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1782000','2026-02-24','1782000','4.640','32.00','25','300000','1200000.00','1','0.14', 'input','2026-02-24 17:09:45','4.640','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01708MM','1','RS 19','','DP-01708');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBBD-39-0','00041785');
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-02-24','PSPLT-ZBBD-39-0','PSPLT','TOKO','MMPSN','32.00','4.640','4.640','1','4.640','4.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01708MM ');
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-01720';
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-ZBBD-40-0','00041786','DP-01720MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','338000','2026-02-24','338000','3.380','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-24 17:11:00','3.380','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01720MM','1','RS 21','','DP-01720');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBBD-40-0','00041786');
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-02-24','PSPRT-ZBBD-40-0','PSPRT','TOKO','MMPSN','100.00','3.380','3.380','1','3.380','3.380','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01720MM ');