INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','08:28:38');
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-20250904-0001','1','PSPLT-YIXD-2-0','1','3.690','3.690','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YIXD-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YIXD-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YIXD-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YIXD-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-09-04 08:28:52' WHERE kode_barang='PSPLT-YIXD-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YIXD-2-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 ('2025-09-04 08:28:52','TOKO','MMPSN','PSPLT','PSPLT-YIXD-2-0','1','3.690','3.690','1','3.690','3.690','7.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YIXD-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YIXD-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0001','1','PSPRT-YIXD-3-0','1','2.260','2.260','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YIXD-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YIXD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YIXD-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YIXD-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-09-04 08:28:52' WHERE kode_barang='PSPRT-YIXD-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YIXD-3-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 ('2025-09-04 08:28:52','TOKO','MMPSN','PSPRT','PSPRT-YIXD-3-0','1','2.260','2.260','1','2.260','2.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YIXD-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YIXD-3-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0001','2025-09-04','08:28','5.950','kasir','2025-09-04 08:28:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','09:39:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','10:30:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','10:51:16');
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 ('FJ-250904-0001','kasir','1',' TFCMR75-85','TOKO','TFCINMAS','TFCMR-YIXA-73-0','THIFA CINCIN MAS RG ','','1.310','1','85.00','2102000','0','0','16500','2174000','0','0','0','2174000','FIR','00038443','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YIXA-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='TFCMR-YIXA-73-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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 ('FJ-250904-0001','2025-09-04','1.310','2025-09-04','13:25:42','PLG0006150','2174000','2174000','0','2174000','0','kasir','2025-09-04 13:25:41','FJ-250904-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('2025-09-04','FJ-250904-0001','2025-09-04','13:25:42','FIR','2174000','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-250904-0001','2025-09-04','2025-09-04 13:25:41','PENJUALAN : FJ-250904-0001','.','TBC','2174000','2174000','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-250904-0002','D','2025-09-04','13:25:42','TBC','PENJUALAN','FJ-250904-0001','16109567664','2174000','16111741664','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='2174000' WHERE no_faktur_jual='FJ-250904-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','13:28:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-04 ','13:57:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','14:13:32');
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 ('FJ-250904-0002','kasir','1',' DP-00977BI','TOKO','BIPPSN','PSPLT-YIXB-14-0','CINCIN PALADIUM ','','4.790','1','7.00','675000','0','0','16500','1897500','0','0','0','1897500','SUL','00038485','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIXB-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.790',berat_jual_asli=berat_jual_asli+'4.790',stock_jual='1',berat_akhir=berat_akhir-'4.790',berat_akhir_asli=berat_akhir_asli-'4.790',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='PSPLT-YIXB-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-250904-0002','2025-09-04','4.790','2025-09-04','14:15:00','PLG0006151','1897500','1897500','0','1897500','0','kasir','2025-09-04 14:14:59','FJ-250904-0002','DP-00977','912500');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-04','FJ-250904-0002','2025-09-04','14:15:00','SUL','1897500','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-250904-0002','2025-09-04','2025-09-04 14:14:59','PENJUALAN : FJ-250904-0002','.','TBC','985000','985000','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-250904-0003','D','2025-09-04','14:15:00','TBC','PENJUALAN','FJ-250904-0002','16111741664','985000','16112726664','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='985000' WHERE no_faktur_jual='FJ-250904-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 ('FJ-250904-0003','kasir',' 1',' DP-00978BI','TOKO','BIPPSN','PSPLT-YHBG-3-0','CINCIN PALADIUM ','','2.050','1','7.00','280000','0','0','16500','1212500','0','0','0','1212500','SUL','00038309','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YHBG-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='PSPLT-YHBG-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-250904-0003','2025-09-04','2.050','2025-09-04','14:15:00','PLG0006152','1212500','1212500','0','1212500','0','kasir','2025-09-04 14:14:59','FJ-250904-0002','DP-00978','600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-04','FJ-250904-0003','2025-09-04','14:15:00','SUL','1212500','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-250904-0003','2025-09-04','2025-09-04 14:14:59','PENJUALAN : FJ-250904-0003','.','TBC','612500','612500','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-250904-0004','D','2025-09-04','14:15:00','TBC','PENJUALAN','FJ-250904-0003','16112726664','612500','16113339164','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='1597500' WHERE no_faktur_jual='FJ-250904-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','14:24:39');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01061','DEWI','1','GOLD','WEDDING RING','','','4.000','','75.00','1','1850000','1675000','0','700000','7400000','size 17','krum kuning dof spt cth','grf Agatha AV','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250904-0004','2025-09-04','2025-09-04 14:39:33','PESANAN : DP-01061','-','TBC','5250000','5250000');
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-250904-0005','D','2025-09-04','14:39:33','TBC','PESANAN','DP-01061','16113339164','5250000','16118589164','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01061','2025-09-04','2025-09-04','14:39:33','PLG0006153','DEWI','2025-09-18','kasir','2025-09-04 14:39:33','4.000','0','0','0','5250000','0','700000','7400000','7400000','2150000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','14:45:43');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01062','DEWI','1','GOLD','WEDDING RING','','','3.000','','75.00','1','1850000','1675000','0','700000','5725000','size "nyusul tgl 10"','krum kuning dof spt cth','grf Yohanes BP','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250904-0005','2025-09-04','2025-09-04 14:53:18','PESANAN : DP-01062','-','TBC','5250000','5250000');
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-250904-0006','D','2025-09-04','14:53:18','TBC','PESANAN','DP-01062','16118589164','5250000','16123839164','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01062','2025-09-04','2025-09-04','14:53:18','PLG0006154','DEWI','2025-09-18','kasir','2025-09-04 14:53:18','3.000','0','0','0','5250000','0','700000','5725000','5725000','475000');
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 ('FJ-250904-0004','kasir','1',' 850K-13-14','TOKO','BIPPER','PBDG-YFAG-37-0','CINCIN SILVER 925 ','','2.450','1','100.00','57000','0','0','16500','850000','0','0','0','850000','HELMI','00036387','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFAG-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='PBDG-YFAG-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-250904-0004','2025-09-04','2.450','2025-09-04','15:29:14','PLG0006155','850000','850000','0','850000','0','kasir','2025-09-04 15:29:13','FJ-250904-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('2025-09-04','FJ-250904-0004','2025-09-04','15:29:14','HELMI','850000','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-250904-0006','2025-09-04','2025-09-04 15:29:13','PENJUALAN : FJ-250904-0004','.','TBC','850000','850000','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-250904-0007','D','2025-09-04','15:29:14','TBC','PENJUALAN','FJ-250904-0004','16123839164','850000','16124689164','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='850000' WHERE no_faktur_jual='FJ-250904-0004' 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 ('FJ-250904-0005','kasir',' 1',' 700K-17-00','TOKO','BIPPER','PMM-YGAX-10-0','CINCIN SILVER 925 ','','3.430','1','100.00','80000','0','0','16500','700000','0','0','0','700000','HELMI','00037114','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAX-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.430',berat_jual_asli=berat_jual_asli+'3.430',stock_jual='1',berat_akhir=berat_akhir-'3.430',berat_akhir_asli=berat_akhir_asli-'3.430',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='PMM-YGAX-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-250904-0005','2025-09-04','3.430','2025-09-04','15:29:14','PLG0006156','700000','700000','0','700000','0','kasir','2025-09-04 15:29:13','FJ-250904-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('2025-09-04','FJ-250904-0005','2025-09-04','15:29:14','HELMI','700000','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-250904-0007','2025-09-04','2025-09-04 15:29:13','PENJUALAN : FJ-250904-0005','.','TBC','700000','700000','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-250904-0008','D','2025-09-04','15:29:14','TBC','PENJUALAN','FJ-250904-0005','16124689164','700000','16125389164','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='1550000' WHERE no_faktur_jual='FJ-250904-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','15:40:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','15:51:48');
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-20250904-0002','1','TFAMP-YIXD-16-0','1','2.290','2.290','TOKO','AMPTF','TOKO','TFAMP');
DELETE FROM tm_barang WHERE kode_barang='TFAMP-YIXD-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFAMP-YIXD-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFAMP-YIXD-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFAMP-YIXD-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFAMP',tgl_last_beli='2025-09-04 15:52:26' WHERE kode_barang='TFAMP-YIXD-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFAMP-YIXD-16-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 ('2025-09-04 15:52:26','TOKO','TFAMP','TFAMP','TFAMP-YIXD-16-0','1','2.290','2.290','1','2.290','2.290','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFAMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFAMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFAMP-YIXD-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFAMP-YIXD-16-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0002','1','TFAMR-YIXD-17-0','1','2.080','2.080','TOKO','AMPTF','TOKO','TFAMP');
DELETE FROM tm_barang WHERE kode_barang='TFAMR-YIXD-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFAMR-YIXD-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFAMR-YIXD-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFAMR-YIXD-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFAMP',tgl_last_beli='2025-09-04 15:52:26' WHERE kode_barang='TFAMR-YIXD-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFAMR-YIXD-17-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 ('2025-09-04 15:52:26','TOKO','TFAMP','TFAMR','TFAMR-YIXD-17-0','1','2.080','2.080','1','2.080','2.080','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFAMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFAMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFAMR-YIXD-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFAMR-YIXD-17-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0002','2025-09-04','15:51','4.370','kasir','2025-09-04 15:52:26');
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-20250904-0003','1','TFCMP-YIXD-18-0','1','0.950','0.950','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMP-YIXD-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMP-YIXD-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-YIXD-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMP-YIXD-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-YIXD-18-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMP','TFCMP-YIXD-18-0','1','0.950','0.950','1','0.950','0.950','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMP-YIXD-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-18-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMP-YIXD-19-0','1','1.210','1.210','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMP-YIXD-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMP-YIXD-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-YIXD-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMP-YIXD-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-YIXD-19-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMP','TFCMP-YIXD-19-0','1','1.210','1.210','1','1.210','1.210','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMP-YIXD-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-19-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMP-YIXD-20-0','1','1.280','1.280','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMP-YIXD-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMP-YIXD-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-YIXD-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMP-YIXD-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-YIXD-20-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMP','TFCMP-YIXD-20-0','1','1.280','1.280','1','1.280','1.280','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMP-YIXD-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-20-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMP-YIXD-21-0','1','1.390','1.390','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMP-YIXD-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMP-YIXD-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-YIXD-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMP-YIXD-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-YIXD-21-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMP','TFCMP-YIXD-21-0','1','1.390','1.390','1','1.390','1.390','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMP-YIXD-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-21-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-22-0','1','1.720','1.720','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-22-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-22-0','1','1.720','1.720','1','1.720','1.720','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-22-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-23-0','1','2.660','2.660','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-23-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-23-0','1','2.660','2.660','1','2.660','2.660','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-23-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-24-0','1','1.230','1.230','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-24-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-24-0','1','1.230','1.230','1','1.230','1.230','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-24-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-25-0','1','0.900','0.900','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-25-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-25-0','1','0.900','0.900','1','0.900','0.900','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-25-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-26-0','1','1.080','1.080','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-26-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-26-0','1','1.080','1.080','1','1.080','1.080','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-26-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-27-0','1','0.900','0.900','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-27-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-27-0','1','0.900','0.900','1','0.900','0.900','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-27-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-28-0','1','1.080','1.080','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-28-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-28-0','1','1.080','1.080','1','1.080','1.080','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-28-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-29-0','1','1.000','1.000','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-29-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-29-0','1','1.000','1.000','1','1.000','1.000','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-29-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-30-0','1','0.970','0.970','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-30-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-30-0','1','0.970','0.970','1','0.970','0.970','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-30-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-31-0','1','1.300','1.300','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMR-YIXD-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-31-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-31-0','1','1.300','1.300','1','1.300','1.300','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-31-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMP-YIXD-35-0','1','2.870','2.870','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMP-YIXD-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMP-YIXD-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-YIXD-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:55' WHERE kode_barang='TFCMP-YIXD-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-YIXD-35-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 ('2025-09-04 15:52:55','TOKO','TFCINMAS','TFCMP','TFCMP-YIXD-35-0','1','2.870','2.870','1','2.870','2.870','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMP-YIXD-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-35-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMP-YIXD-36-0','1','2.740','2.740','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMP-YIXD-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMP-YIXD-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMP-YIXD-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:56' WHERE kode_barang='TFCMP-YIXD-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMP-YIXD-36-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 ('2025-09-04 15:52:56','TOKO','TFCINMAS','TFCMP','TFCMP-YIXD-36-0','1','2.740','2.740','1','2.740','2.740','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMP-YIXD-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMP-YIXD-36-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0003','1','TFCMR-YIXD-37-0','1','1.390','1.390','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-YIXD-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXD-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-YIXD-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:52:56' WHERE kode_barang='TFCMR-YIXD-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-YIXD-37-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 ('2025-09-04 15:52:56','TOKO','TFCINMAS','TFCMR','TFCMR-YIXD-37-0','1','1.390','1.390','1','1.390','1.390','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-YIXD-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-YIXD-37-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0003','2025-09-04','15:52','24.670','kasir','2025-09-04 15:52:55');
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-20250904-0004','1','TFGKP-YIXD-55-0','1','5.470','5.470','TOKO','GLKTF','TOKO','TFGLK');
DELETE FROM tm_barang WHERE kode_barang='TFGKP-YIXD-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGKP-YIXD-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGKP-YIXD-55-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGKP-YIXD-55-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLK',tgl_last_beli='2025-09-04 15:53:53' WHERE kode_barang='TFGKP-YIXD-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGKP-YIXD-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 ('2025-09-04 15:53:53','TOKO','TFGLK','TFGKP','TFGKP-YIXD-55-0','1','5.470','5.470','1','5.470','5.470','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGKP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGKP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGKP-YIXD-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGKP-YIXD-55-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0004','1','TFGKR-YIXD-56-0','1','5.710','5.710','TOKO','GLKTF','TOKO','TFGLK');
DELETE FROM tm_barang WHERE kode_barang='TFGKR-YIXD-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGKR-YIXD-56-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGKR-YIXD-56-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGKR-YIXD-56-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLK',tgl_last_beli='2025-09-04 15:53:53' WHERE kode_barang='TFGKR-YIXD-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGKR-YIXD-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 ('2025-09-04 15:53:53','TOKO','TFGLK','TFGKR','TFGKR-YIXD-56-0','1','5.710','5.710','1','5.710','5.710','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGKR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGKR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGKR-YIXD-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGKR-YIXD-56-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0004','1','TFGKR-YIXD-57-0','1','5.120','5.120','TOKO','GLKTF','TOKO','TFGLK');
DELETE FROM tm_barang WHERE kode_barang='TFGKR-YIXD-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGKR-YIXD-57-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGKR-YIXD-57-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGKR-YIXD-57-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLK',tgl_last_beli='2025-09-04 15:53:53' WHERE kode_barang='TFGKR-YIXD-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGKR-YIXD-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 ('2025-09-04 15:53:53','TOKO','TFGLK','TFGKR','TFGKR-YIXD-57-0','1','5.120','5.120','1','5.120','5.120','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGKR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGKR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGKR-YIXD-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGKR-YIXD-57-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0004','1','TFGKR-YIXD-58-0','1','9.010','9.010','TOKO','GLKTF','TOKO','TFGLK');
DELETE FROM tm_barang WHERE kode_barang='TFGKR-YIXD-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGKR-YIXD-58-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGKR-YIXD-58-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGKR-YIXD-58-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLK',tgl_last_beli='2025-09-04 15:53:53' WHERE kode_barang='TFGKR-YIXD-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGKR-YIXD-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 ('2025-09-04 15:53:53','TOKO','TFGLK','TFGKR','TFGKR-YIXD-58-0','1','9.010','9.010','1','9.010','9.010','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGKR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGKR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGKR-YIXD-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGKR-YIXD-58-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0004','2025-09-04','15:53','25.310','kasir','2025-09-04 15:53:52');
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-20250904-0005','1','TFGRR-YIXD-38-0','1','11.220','11.220','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-38-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-38-0','1','11.220','11.220','1','11.220','11.220','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-38-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRP-YIXD-39-0','1','1.970','1.970','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRP-YIXD-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRP-YIXD-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRP-YIXD-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRP-YIXD-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRP-YIXD-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRP-YIXD-39-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRP','TFGRP-YIXD-39-0','1','1.970','1.970','1','1.970','1.970','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRP-YIXD-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRP-YIXD-39-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRP-YIXD-40-0','1','3.060','3.060','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRP-YIXD-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRP-YIXD-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRP-YIXD-40-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRP-YIXD-40-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRP-YIXD-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRP-YIXD-40-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRP','TFGRP-YIXD-40-0','1','3.060','3.060','1','3.060','3.060','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRP-YIXD-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRP-YIXD-40-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-41-0','1','4.640','4.640','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-41-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-41-0','1','4.640','4.640','1','4.640','4.640','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-41-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-42-0','1','1.910','1.910','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-42-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-42-0','1','1.910','1.910','1','1.910','1.910','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-42-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-43-0','1','1.420','1.420','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-43-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-43-0','1','1.420','1.420','1','1.420','1.420','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-43-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-44-0','1','0.520','0.520','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-44-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-44-0','1','0.520','0.520','1','0.520','0.520','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-44-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-45-0','1','0.520','0.520','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-45-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-45-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-45-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-45-0','1','0.520','0.520','1','0.520','0.520','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-45-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-46-0','1','0.590','0.590','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-46-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-46-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-46-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-46-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-46-0','1','0.590','0.590','1','0.590','0.590','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-46-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-47-0','1','0.590','0.590','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-47-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-47-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-47-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-47-0','1','0.590','0.590','1','0.590','0.590','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-47-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-48-0','1','0.590','0.590','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-48-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-48-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-48-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-48-0','1','0.590','0.590','1','0.590','0.590','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-48-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0005','1','TFGRR-YIXD-54-0','1','3.660','3.660','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YIXD-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-54-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YIXD-54-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YIXD-54-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-09-04 15:54:20' WHERE kode_barang='TFGRR-YIXD-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YIXD-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 ('2025-09-04 15:54:20','TOKO','TFGLR','TFGRR','TFGRR-YIXD-54-0','1','3.660','3.660','1','3.660','3.660','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFGRR-YIXD-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIXD-54-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0005','2025-09-04','15:54','30.690','kasir','2025-09-04 15:54:20');
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-20250904-0006','1','TFKMP-YIXD-49-0','1','3.060','3.060','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-YIXD-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-49-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-YIXD-49-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-YIXD-49-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2025-09-04 15:54:46' WHERE kode_barang='TFKMP-YIXD-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-YIXD-49-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 ('2025-09-04 15:54:46','TOKO','TFKMP','TFKMP','TFKMP-YIXD-49-0','1','3.060','3.060','1','3.060','3.060','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFKMP-YIXD-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-49-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0006','1','TFKMP-YIXD-50-0','1','2.060','2.060','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-YIXD-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-50-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-YIXD-50-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-YIXD-50-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2025-09-04 15:54:46' WHERE kode_barang='TFKMP-YIXD-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-YIXD-50-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 ('2025-09-04 15:54:46','TOKO','TFKMP','TFKMP','TFKMP-YIXD-50-0','1','2.060','2.060','1','2.060','2.060','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFKMP-YIXD-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-50-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0006','1','TFKMP-YIXD-51-0','1','2.990','2.990','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-YIXD-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-51-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-YIXD-51-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-YIXD-51-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2025-09-04 15:54:46' WHERE kode_barang='TFKMP-YIXD-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-YIXD-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 ('2025-09-04 15:54:46','TOKO','TFKMP','TFKMP','TFKMP-YIXD-51-0','1','2.990','2.990','1','2.990','2.990','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFKMP-YIXD-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-51-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0006','1','TFKMP-YIXD-52-0','1','2.070','2.070','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-YIXD-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-52-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-YIXD-52-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-YIXD-52-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2025-09-04 15:54:46' WHERE kode_barang='TFKMP-YIXD-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-YIXD-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 ('2025-09-04 15:54:46','TOKO','TFKMP','TFKMP','TFKMP-YIXD-52-0','1','2.070','2.070','1','2.070','2.070','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFKMP-YIXD-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-52-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0006','1','TFKMP-YIXD-53-0','1','2.050','2.050','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-YIXD-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-YIXD-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-YIXD-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2025-09-04 15:54:46' WHERE kode_barang='TFKMP-YIXD-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-YIXD-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 ('2025-09-04 15:54:46','TOKO','TFKMP','TFKMP','TFKMP-YIXD-53-0','1','2.050','2.050','1','2.050','2.050','87.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFKMP-YIXD-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-YIXD-53-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0006','2025-09-04','15:54','12.230','kasir','2025-09-04 15:54:45');
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-20250904-0007','1','LMT25-YIXD-60-0','1','25.000','25.000','TOKO','LMT','TOKO','TFLM');
DELETE FROM tm_barang WHERE kode_barang='LMT25-YIXD-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LMT25-YIXD-60-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LMT25-YIXD-60-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LMT25-YIXD-60-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFLM',tgl_last_beli='2025-09-04 15:55:19' WHERE kode_barang='LMT25-YIXD-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LMT25-YIXD-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 ('2025-09-04 15:55:19','TOKO','TFLM','LMT25','LMT25-YIXD-60-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LMT25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LMT25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LMT25-YIXD-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='LMT25-YIXD-60-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0007','2025-09-04','15:54','25.000','kasir','2025-09-04 15:55:19');
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-20250904-0008','1','TFCKS-YIXD-32-0','1','1.870','1.870','TOKO','TFCKS','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCKS-YIXD-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCKS-YIXD-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCKS-YIXD-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCKS-YIXD-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:55:36' WHERE kode_barang='TFCKS-YIXD-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCKS-YIXD-32-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 ('2025-09-04 15:55:36','TOKO','TFCINMAS','TFCKS','TFCKS-YIXD-32-0','1','1.870','1.870','1','1.870','1.870','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCKS' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCKS' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCKS-YIXD-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCKS-YIXD-32-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0008','1','TFCKS-YIXD-33-0','1','1.930','1.930','TOKO','TFCKS','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCKS-YIXD-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCKS-YIXD-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCKS-YIXD-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCKS-YIXD-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:55:36' WHERE kode_barang='TFCKS-YIXD-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCKS-YIXD-33-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 ('2025-09-04 15:55:36','TOKO','TFCINMAS','TFCKS','TFCKS-YIXD-33-0','1','1.930','1.930','1','1.930','1.930','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCKS' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCKS' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCKS-YIXD-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCKS-YIXD-33-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0008','1','TFCKS-YIXD-34-0','1','2.170','2.170','TOKO','TFCKS','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCKS-YIXD-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCKS-YIXD-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCKS-YIXD-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCKS-YIXD-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2025-09-04 15:55:36' WHERE kode_barang='TFCKS-YIXD-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCKS-YIXD-34-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 ('2025-09-04 15:55:36','TOKO','TFCINMAS','TFCKS','TFCKS-YIXD-34-0','1','2.170','2.170','1','2.170','2.170','84.00');
DELETE FROM tm_dept WHERE kode_dept='TFCKS' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCKS' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCKS-YIXD-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCKS-YIXD-34-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0008','2025-09-04','15:55','5.970','kasir','2025-09-04 15:55:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','16:19: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-20250904-0009','1','PSGT-YIXB-17-0','1','4.080','4.080','TOKO','BSDPSN','TOKO','BSDPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YIXB-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YIXB-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YIXB-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YIXB-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BSDPSN',tgl_last_beli='2025-09-04 16:20:16' WHERE kode_barang='PSGT-YIXB-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YIXB-17-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 ('2025-09-04 16:20:16','TOKO','BSDPSN','PSGT','PSGT-YIXB-17-0','1','4.080','4.080','1','4.080','4.080','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YIXB-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YIXB-17-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0009','1','PSGT-YIXB-18-0','1','3.380','3.380','TOKO','BSDPSN','TOKO','BSDPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YIXB-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YIXB-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YIXB-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YIXB-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BSDPSN',tgl_last_beli='2025-09-04 16:20:16' WHERE kode_barang='PSGT-YIXB-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YIXB-18-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 ('2025-09-04 16:20:16','TOKO','BSDPSN','PSGT','PSGT-YIXB-18-0','1','3.380','3.380','1','3.380','3.380','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YIXB-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YIXB-18-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' 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-20250904-0009','1','PSGT-YIXD-62-0','1','2.720','2.720','TOKO','BSDPSN','TOKO','BSDPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YIXD-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YIXD-62-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YIXD-62-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YIXD-62-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BSDPSN',tgl_last_beli='2025-09-04 16:20:16' WHERE kode_barang='PSGT-YIXD-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YIXD-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 ('2025-09-04 16:20:16','TOKO','BSDPSN','PSGT','PSGT-YIXD-62-0','1','2.720','2.720','1','2.720','2.720','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YIXD-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YIXD-62-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250904-0009','2025-09-04','16:20','10.180','kasir','2025-09-04 16:20:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','16:22:49');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01219','NAD','1','1PCS CINCIN','RESIZE KE 19 5','4.230','1','50000','50000');
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-250904-0008','2025-09-04','2025-09-04 18:00:23','SERVICE : SV-01219','.','TBC','50000','50000','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-250904-0009','D','2025-09-04','18:00:23','TBC','SERVICE','SV-01219','16125389164','50000','16125439164','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
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-01219','2025-09-04','2025-09-04','18:00:23','PLG0006157','kasir','2025-09-05','kasir','2025-09-04 18:00:23','4.230','0','0','0','50000','0','50000','50000','0');
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 ('FJ-250904-0006','kasir','1',' DP-00972BI','TOKO','BIPPSN','PSPLT-YIXB-34-0','CINCIN PALADIUM ','','2.810','1','17.00','962000','0','0','16500','1964500','0','0','0','1964500','HELMI','00038505','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIXB-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.810',berat_jual_asli=berat_jual_asli+'2.810',stock_jual='1',berat_akhir=berat_akhir-'2.810',berat_akhir_asli=berat_akhir_asli-'2.810',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='PSPLT-YIXB-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-250904-0006','2025-09-04','2.810','2025-09-04','18:20:48','PLG0006158','1964500','1964500','0','1964500','0','kasir','2025-09-04 18:20:47','FJ-250904-0006','DP-00972','1025000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-04','FJ-250904-0006','2025-09-04','18:20:48','HELMI','1964500','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-250904-0009','2025-09-04','2025-09-04 18:20:47','PENJUALAN : FJ-250904-0006','.','TBC','939500','939500','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-250904-0010','D','2025-09-04','18:20:48','TBC','PENJUALAN','FJ-250904-0006','16125439164','939500','16126378664','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='939500' WHERE no_faktur_jual='FJ-250904-0006' 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 ('FJ-250904-0007','kasir',' 1',' DP-00971BI','TOKO','BIPPSN','PSGT-YIXB-19-0','CINCIN EMAS ','','2.190','1','58.00','2370000','0','0','16500','3762700','0','0','0','3762700','HELMI','00038490','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YIXB-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='PSGT-YIXB-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-250904-0007','2025-09-04','2.190','2025-09-04','18:20:48','PLG0006159','3762700','3762700','0','3762700','0','kasir','2025-09-04 18:20:47','FJ-250904-0006','DP-00971','3340000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-04','FJ-250904-0007','2025-09-04','18:20:48','HELMI','3762700','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-250904-0010','2025-09-04','2025-09-04 18:20:47','PENJUALAN : FJ-250904-0007','.','TBC','422700','422700','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-250904-0011','D','2025-09-04','18:20:48','TBC','PENJUALAN','FJ-250904-0007','16126378664','422700','16126801364','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='1362200' WHERE no_faktur_jual='FJ-250904-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0007';
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 ('FJ-250904-0008','kasir','1',' DP-00995BI','TOKO','BIPPSN','PSPRT-YIXB-5-0','CINCIN PERAK ','','1.960','1','100.00','50000','0','0','16500','900000','0','0','0','900000','HELMI','00038476','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIXB-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='PSPRT-YIXB-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-250904-0008','2025-09-04','1.960','2025-09-04','18:46:39','PLG0006160','900000','900000','0','900000','0','kasir','2025-09-04 18:46:39','FJ-250904-0008','DP-00995','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-04','FJ-250904-0008','2025-09-04','18:46:39','HELMI','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-250904-0008' 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 ('FJ-250904-0009','kasir','1',' BDC-00119 ','TOKO','BIPCBR','BDC-YFAI-17-0','CINCIN BDC-00119 ','','1.460','1','83.00','3993000','1230000','75','16500','5600000','0','0','0','5600000','HELMI','00036433','BDC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDC-YFAI-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='BDC-YFAI-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCBR' 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 ('FJ-250904-0009','2025-09-04','1.460','2025-09-04','19:07:50','PLG0006161','5600000','5600000','0','5600000','0','kasir','2025-09-04 19:07:50','FJ-250904-0009','','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('2025-09-04','FJ-250904-0009','2025-09-04','19:07:50','HELMI','5600000','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-250904-0011','2025-09-04','2025-09-04 19:07:50','PENJUALAN : FJ-250904-0009','.','TBC','5600000','5600000','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-250904-0012','D','2025-09-04','19:07:50','TBC','PENJUALAN BERLIAN','FJ-250904-0009','16126801364','5600000','16132401364','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='5600000' WHERE no_faktur_jual='FJ-250904-0009' 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 ('FJ-250904-0010','kasir',' 1',' BDCM-00002','TOKO','BIPCMP','BDCM-XIBF-6-0','CINCIN EMAS BDCM-00002 ','','3.560','1','83.00','6287000','0','0','16500','6663000','0','0','0','6663000','HELMI','00031468','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-XIBF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.560',berat_jual_asli=berat_jual_asli+'3.560',stock_jual='1',berat_akhir=berat_akhir-'3.560',berat_akhir_asli=berat_akhir_asli-'3.560',stock_akhir='0' WHERE tanggal='2025-09-04' AND kode_barang='BDCM-XIBF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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 ('FJ-250904-0010','2025-09-04','3.560','2025-09-04','19:07:50','PLG0006162','6663000','6663000','0','6663000','0','kasir','2025-09-04 19:07:50','FJ-250904-0009','','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('2025-09-04','FJ-250904-0010','2025-09-04','19:07:50','HELMI','6663000','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-250904-0012','2025-09-04','2025-09-04 19:07:50','PENJUALAN : FJ-250904-0010','.','TBC','6663000','6663000','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-250904-0013','D','2025-09-04','19:07:50','TBC','PENJUALAN','FJ-250904-0010','16132401364','6663000','16139064364','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='12263000' WHERE no_faktur_jual='FJ-250904-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250904-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250904-0010';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','19:21:17');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01063','HELMI','1','PER','SEPASANG WEDDING RING','','','5.000','','925.00','1','25000','0','1500000','0','1500000','cewe size 13 grf ?? Tasuku Maruoka','cowo size 16 grf Rika Aryanti','krum putih glosy dua duanya','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250904-0013','2025-09-04','2025-09-04 19:34:17','PESANAN : DP-01063','.','TBC','1500000','1500000');
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-250904-0014','D','2025-09-04','19:34:17','TBC','PESANAN','DP-01063','16139064364','1500000','16140564364','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01063','2025-09-04','2025-09-04','19:34:17','PLG0006163','HELMI','2025-09-30','kasir','2025-09-04 19:34:17','5.000','0','0','0','1500000','0','0','1500000','1500000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01064','HELMI','1','PER','SEPASANG WEDDING RING','','','5.000','','925.00','1','25000','0','1550000','0','1550000','cewe size 14.5 grf IL ?? ME','cowo size 20.5 grf IL ?? ME','krum putih seperti contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250904-0014','2025-09-04','2025-09-04 19:46:01','PESANAN : DP-01064','.','TBC','1550000','1550000');
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-250904-0015','D','2025-09-04','19:46:01','TBC','PESANAN','DP-01064','16140564364','1550000','16142114364','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01064','2025-09-04','2025-09-04','19:46:01','PLG0006164','HELMI','2025-09-30','kasir','2025-09-04 19:46:01','5.000','0','0','0','1550000','0','0','1550000','1550000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-04 ','19:56:42');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-01044';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-01044';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-01044';
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-250904-0002','K','2025-09-04','20:05:20','kasir','PESANAN BATAL','DP-01044','36600','0','36600');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-04';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-09-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-04' 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-250905-0001','D','2025-09-05','20:06:47','TBC','SALDO AWAL','SALDO AWAL','0','16142114364','16142114364');
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-250905-0001','D','2025-09-05','20:06:47','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
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-250905-0001','D','2025-09-05','20:06:47','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-250905-0001','D','2025-09-05','20:06:47','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-250905-0001','D','2025-09-05','20:06:47','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
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-250905-0001','D','2025-09-05','20:06:47','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-250905-0001','D','2025-09-05','20:06:47','KET','SALDO AWAL','SALDO AWAL','0','134183000','134183000');
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-250905-0001','D','2025-09-05','20:06:47','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
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-250905-0001','D','2025-09-05','20:06:47','BCD','SALDO AWAL','SALDO AWAL','0','1329371000','1329371000');
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-250905-0001','D','2025-09-05','20:06:47','MANDIRI','SALDO AWAL','SALDO AWAL','0','44680000','44680000');
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-250905-0001','D','2025-09-05','20:06:47','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
UPDATE tp_system SET tgl_system='2025-09-05';