INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-03-02 ','08:45:56');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-03-02 ','09:05:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-03-02 ','10:46:49');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260302-0001','1','GBRE-YIAX-16-0','TOKO','GBR','GELANG GBRE-00177','1','5.510','AMBI');
UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-03-02 10:47:59',status_delete='5.510' WHERE kode_barang='GBRE-YIAX-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='GBRE-YIAX-16-0';
DELETE FROM tm_barang WHERE kode_barang='GBRE-YIAX-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.510,berat_hancur_asli=berat_hancur_asli+5.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='GBR' AND kode_barang='GBRE-YIAX-16-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-260302-0001','2026-03-02','owner','2026-03-02','10:47:59','owner','2026-03-02 10:47:59','AMBIL BANDROL ULANG TAMBAH PANJANG GBRE 01329');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-03-02 ','10:51:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-02 ','10:56:46');
DELETE FROM tm_berlian WHERE kode_barang='GBRE-YKXC-36-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('GBRE-YKXC-36-0','GBRE-YKXC-36-0','00039423','RD','81','0.970','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('GBRE-YKXC-36-0','00039423','RD','81','0.970','320','310.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('GBRE-YKXC-36-0','00039423','00039423','GELANG GBRE-00693','GELANG GBRE-00693','','','25945500','25945500',' 0','0','kasir','2026-03-02 11:08:52');
UPDATE tm_barang SET nama_barang='GELANG GBRE-00693' ,nama_atribut='' ,kode_intern='GBRE-00693 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='0126 19B2',total_usd_ext='IDB 111 500 000',total_usd='310.4' WHERE kode_barang='GBRE-YKXC-36-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260302-0001','kasir','1',' GBRE-00693','TOKO','GBR','GBRE-YKXC-36-0','GELANG GBRE-00693','','12.860','1','75.00','34379000','5308000','310','17100','45000000','0','0','0','45000000','ONLILUNG','00039423','GBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GBRE-YKXC-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'12.860',berat_jual_asli=berat_jual_asli+'12.860',stock_jual='1',berat_akhir=berat_akhir-'12.860',berat_akhir_asli=berat_akhir_asli-'12.860',stock_akhir='0' WHERE tanggal='2026-03-02' AND kode_barang='GBRE-YKXC-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='GBR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260302-0001','2026-03-02','12.860','2026-03-02','11:11:35','PLG0028128','45000000','45000000','0','45000000','0','kasir','2026-03-02 11:11:34','FE-260302-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-02','FE-260302-0001','2026-03-02','11:11:35','ONLILUNG','45000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260302-0001','2026-03-02','2026-03-02 11:11:34','PENJUALAN : FE-260302-0001','','TBC','45000000','45000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260302-0002','D','2026-03-02','11:11:35','TBC','PENJUALAN BERLIAN','FE-260302-0001','95576412885','45000000','95621412885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='45000000' WHERE no_faktur_jual='FE-260302-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260302-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-03-02 ','11:27:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-02 ','11:55:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('owner','2026-03-02 ','11:55:37');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260302-0002','1','CBRE-YDBB-2-0','TOKO','CBR','CINCIN CBRE-02530 ','1','0.450','AMBI');
UPDATE tm_barang SET deleted_by ='owner', deleted_date ='2026-03-02 11:56:34',status_delete='0.450' WHERE kode_barang='CBRE-YDBB-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='CBRE-YDBB-2-0';
DELETE FROM tm_barang WHERE kode_barang='CBRE-YDBB-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.450,berat_hancur_asli=berat_hancur_asli+0.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='CBR' AND kode_barang='CBRE-YDBB-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date,keterangan) VALUES ('BS-260302-0002','2026-03-02','owner','2026-03-02','11:56:34','owner','2026-03-02 11:56:34','AMBIL LISTRING TIPIS');
DELETE FROM tm_berlian WHERE kode_barang='AMK-TDXI-37';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('AMK-TDXI-37','A0000617','A0000617','ANTING MK','ANTING MK','','','5454500','5454500',' 0','0','kasir','2026-03-02 14:16:38');
UPDATE tm_barang SET nama_barang='ANTING MK' ,nama_atribut='' ,kode_intern='ELCO -77 -70%', kadar_cetak='70.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='AMK-TDXI-37' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KMK-TFAB-3';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KMK-TFAB-3','00000753','00000753','KALUNG MK','KALUNG MK','','','6714500','6714500',' 0','0','kasir','2026-03-02 14:17:08');
UPDATE tm_barang SET nama_barang='KALUNG MK' ,nama_atribut='' ,kode_intern='ELCO- 80', kadar_cetak='77.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='77',total_usd_ext='',total_usd='0' WHERE kode_barang='KMK-TFAB-3' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260302-0002','kasir','1',' ELCO -77 -','TOKO','AMK','AMK-TDXI-37','ANTING MK','','2.740','1','74.00','5510000','0','0','17100','6136000','0','0','0','6136000','BARY','A0000617','AMK','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='AMK-TDXI-37' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.740',berat_jual_asli=berat_jual_asli+'2.740',stock_jual='1',berat_akhir=berat_akhir-'2.740',berat_akhir_asli=berat_akhir_asli-'2.740',stock_akhir='0' WHERE tanggal='2026-03-02' AND kode_barang='AMK-TDXI-37' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='AMK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260302-0002','2026-03-02','2.740','2026-03-02','14:18:02','PLG0028129','6136000','6136000','0','6136000','0','kasir','2026-03-02 14:18:02','FE-260302-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-02','FE-260302-0002','2026-03-02','14:18:02','BARY','6136000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260302-0002','2026-03-02','2026-03-02 14:18:02','PENJUALAN : FE-260302-0002','','TBC','6136000','6136000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260302-0003','D','2026-03-02','14:18:02','TBC','PENJUALAN','FE-260302-0002','95621412885','6136000','95627548885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6136000' WHERE no_faktur_jual='FE-260302-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260302-0003','kasir',' 1',' ELCO- 80','TOKO','KMK','KMK-TFAB-3','KALUNG MK','','3.120','1','80.00','6782000','0','0','17100','6990000','0','0','0','6990000','BARY','00000753','KMK','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='KMK-TFAB-3' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-03-02' AND kode_barang='KMK-TFAB-3' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='KMK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260302-0003','2026-03-02','3.120','2026-03-02','14:18:02','PLG0028130','6990000','6990000','0','6990000','0','kasir','2026-03-02 14:18:02','FE-260302-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-02','FE-260302-0003','2026-03-02','14:18:02','BARY','6990000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260302-0003','2026-03-02','2026-03-02 14:18:02','PENJUALAN : FE-260302-0003','','TBC','6990000','6990000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260302-0004','D','2026-03-02','14:18:02','TBC','PENJUALAN','FE-260302-0003','95627548885','6990000','95634538885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='13126000' WHERE no_faktur_jual='FE-260302-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260302-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260302-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-260302-0004','kasir','1',' CBRE-06986','TOKO','CBR','CBRE-ZABI-4-0','CINCIN CBRE-06986','','1.860','1','83.00','6794000','2022500','118','17100','10000000','0','0','0','10000000','ONLILUNG','00041205','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZABI-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-03-02' AND kode_barang='CBRE-ZABI-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-260302-0004','2026-03-02','1.860','2026-03-02','14:21:08','PLG0028131','10000000','10000000','0','10000000','0','kasir','2026-03-02 14:21:08','FE-260302-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-02','FE-260302-0004','2026-03-02','14:21:08','ONLILUNG','10000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260302-0004','2026-03-02','2026-03-02 14:21:08','PENJUALAN : FE-260302-0004','','TBC','10000000','10000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260302-0005','D','2026-03-02','14:21:08','TBC','PENJUALAN BERLIAN','FE-260302-0004','95634538885','10000000','95644538885','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='10000000' WHERE no_faktur_jual='FE-260302-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260302-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260302-0004';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08057','ILU','1','CBRE06986','JD NO 19 CROM KOMBINASI HARGA KONFIRMASI','1.860','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08057','2026-03-02','2026-03-02','14:25:43','PLG0028132','kasir','2026-03-04','kasir','2026-03-02 14:25:43','1.860','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-03-02 ','15:05:00');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260302-0002','K','2026-03-02','15:09:52','kasir','KIRIM PAKET','JNE JAYAPURA','9666940','137000','9529940');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-02 ','16:31:37');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-60-0','1','2.470','2.470','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-60-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-60-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-60-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-60-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-60-0','1','2.470','2.470','1','2.470','2.470','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-60-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-61-0','1','4.220','4.220','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-61-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-61-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-61-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-61-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-61-0','1','4.220','4.220','1','4.220','4.220','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-61-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-62-0','1','3.960','3.960','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-62-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-62-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-62-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-62-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-62-0','1','3.960','3.960','1','3.960','3.960','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-62-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-63-0','1','4.290','4.290','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-63-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-63-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-63-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-63-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-63-0','1','4.290','4.290','1','4.290','4.290','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-63-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-64-0','1','2.750','2.750','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-64-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-64-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-64-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-64-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-64-0','1','2.750','2.750','1','2.750','2.750','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-64-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-65-0','1','3.050','3.050','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-65-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-65-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-65-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-65-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-65-0','1','3.050','3.050','1','3.050','3.050','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-65-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-66-0','1','4.580','4.580','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-66-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-66-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-66-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-66-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-66-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-66-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-66-0','1','4.580','4.580','1','4.580','4.580','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-66-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-66-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-67-0','1','1.960','1.960','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-67-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-67-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-67-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-67-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-67-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-67-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-67-0','1','1.960','1.960','1','1.960','1.960','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-67-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-67-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-68-0','1','4.260','4.260','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-68-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-68-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-68-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-68-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-68-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-68-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-68-0','1','4.260','4.260','1','4.260','4.260','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-68-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-68-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-69-0','1','3.320','3.320','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-69-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-69-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-69-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-69-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-69-0','1','3.320','3.320','1','3.320','3.320','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-69-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-70-0','1','5.180','5.180','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-70-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-70-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-70-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-70-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-70-0','1','5.180','5.180','1','5.180','5.180','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-70-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-71-0','1','4.330','4.330','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-71-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-71-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-71-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-71-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-71-0','1','4.330','4.330','1','4.330','4.330','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-71-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-72-0','1','2.180','2.180','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-72-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-72-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-72-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-72-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-72-0','1','2.180','2.180','1','2.180','2.180','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-72-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-73-0','1','1.610','1.610','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-73-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-73-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-73-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-73-0','1','1.610','1.610','1','1.610','1.610','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-73-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-74-0','1','3.360','3.360','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-74-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-74-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-74-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-74-0','1','3.360','3.360','1','3.360','3.360','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-74-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-75-0','1','1.980','1.980','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-75-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-75-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-75-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-75-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-75-0','1','1.980','1.980','1','1.980','1.980','103.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-75-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-76-0','1','1.800','1.800','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-76-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-76-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-76-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-76-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-76-0','1','1.800','1.800','1','1.800','1.800','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-76-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-77-0','1','4.570','4.570','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-77-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-77-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-77-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-77-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-77-0','1','4.570','4.570','1','4.570','4.570','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-77-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-78-0','1','2.420','2.420','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-78-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-78-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-78-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-78-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-78-0','1','2.420','2.420','1','2.420','2.420','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-78-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-79-0','1','3.110','3.110','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-79-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-79-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-79-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-79-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-79-0','1','3.110','3.110','1','3.110','3.110','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-79-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-80-0','1','2.510','2.510','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-80-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-80-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-80-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-80-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-80-0','1','2.510','2.510','1','2.510','2.510','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-80-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-81-0','1','2.010','2.010','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-81-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-81-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-81-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-81-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-81-0','1','2.010','2.010','1','2.010','2.010','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-81-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0001','1','CBRE-ZCXB-82-0','1','4.120','4.120','TOKO','CBRE','TOKO','CBR');
DELETE FROM tm_barang WHERE kode_barang='CBRE-ZCXB-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-82-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZCXB-82-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CBRE-ZCXB-82-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CBR',tgl_last_beli='2026-03-02 16:32:06' WHERE kode_barang='CBRE-ZCXB-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CBRE-ZCXB-82-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:32:06','TOKO','CBR','CBRE','CBRE-ZCXB-82-0','1','4.120','4.120','1','4.120','4.120','83.00');
DELETE FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CBRE-ZCXB-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZCXB-82-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260302-0001','2026-03-02','16:32','74.040','kasir','2026-03-02 16:32:05');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-51-0','1','3.030','3.030','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-51-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-51-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-51-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-51-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-51-0','1','3.030','3.030','1','3.030','3.030','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-51-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-52-0','1','2.300','2.300','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-52-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-52-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-52-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-52-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-52-0','1','2.300','2.300','1','2.300','2.300','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-52-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-53-0','1','1.300','1.300','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-53-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-53-0','1','1.300','1.300','1','1.300','1.300','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-53-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-54-0','1','2.130','2.130','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-54-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-54-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-54-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-54-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-54-0','1','2.130','2.130','1','2.130','2.130','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-54-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-55-0','1','2.570','2.570','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-55-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-55-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-55-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-55-0','1','2.570','2.570','1','2.570','2.570','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-55-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-56-0','1','2.580','2.580','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-56-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-56-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-56-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-56-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-56-0','1','2.580','2.580','1','2.580','2.580','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-56-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-57-0','1','2.300','2.300','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-57-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-57-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-57-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-57-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-57-0','1','2.300','2.300','1','2.300','2.300','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-57-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-58-0','1','2.360','2.360','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-58-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-58-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-58-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-58-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-58-0','1','2.360','2.360','1','2.360','2.360','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-58-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260302-0002','1','CKBE-ZCXB-59-0','1','2.300','2.300','TOKO','CKBE','TOKO','CKB');
DELETE FROM tm_barang WHERE kode_barang='CKBE-ZCXB-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-59-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKBE-ZCXB-59-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKBE-ZCXB-59-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='CKB',tgl_last_beli='2026-03-02 16:33:07' WHERE kode_barang='CKBE-ZCXB-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKBE-ZCXB-59-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-02 16:33:07','TOKO','CKB','CKBE','CKBE-ZCXB-59-0','1','2.300','2.300','1','2.300','2.300','83.00');
DELETE FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKBE-ZCXB-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZCXB-59-0';
UPDATE tt_beli_detail SET tgl_terima='2026-03-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260302-0002','2026-03-02','16:33','20.870','kasir','2026-03-02 16:33:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-02 ','18:44:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-02 ','19:24:48');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-02';
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-03-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-02' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','TBC','SALDO AWAL','SALDO AWAL','0','95644538885','95644538885');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','BCD','SALDO AWAL','SALDO AWAL','0','14993321700','14993321700');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','4000000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','3450000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','BCA','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','6000000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','','SALDO AWAL','SALDO AWAL','0','16885500','16885500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','BCK','SALDO AWAL','SALDO AWAL','0','16406107978.088','16406107978.088');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260303-0001','D','2026-03-03','20:14:31','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000');
UPDATE tp_system SET tgl_system='2026-03-03';