INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-04 ','09:12:32');
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-20251104-0001','1','TFGRR-YKXC-57-0','1','3.010','3.010','TOKO','GLRTF','TOKO','TFGLR');
DELETE FROM tm_barang WHERE kode_barang='TFGRR-YKXC-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFGRR-YKXC-57-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFGRR-YKXC-57-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFGRR-YKXC-57-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGLR',tgl_last_beli='2025-11-04 09:13:04' WHERE kode_barang='TFGRR-YKXC-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFGRR-YKXC-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-11-04 09:13:04','TOKO','TFGLR','TFGRR','TFGRR-YKXC-57-0','1','3.010','3.010','1','3.010','3.010','76.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-YKXC-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YKXC-57-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-04' WHERE no_faktur_beli='FB-251027-0001';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251104-0001','2025-11-04','09:12','3.010','kasir','2025-11-04 09:13:04');
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-20251104-0002','1','TFC-YKXC-4-0','1','1.090','1.090','TOKO','TFC.BALIK','TOKO','TFCBR');
DELETE FROM tm_barang WHERE kode_barang='TFC-YKXC-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-YKXC-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-YKXC-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-YKXC-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2025-11-04 09:13:19' WHERE kode_barang='TFC-YKXC-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-YKXC-4-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-11-04 09:13:19','TOKO','TFCBR','TFC','TFC-YKXC-4-0','1','1.090','1.090','1','1.090','1.090','85.00');
DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-YKXC-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFC-YKXC-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-04' WHERE no_faktur_beli='FB-251005-0001';
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-20251104-0002','1','TFC-YKXC-17-0','1','1.240','1.240','TOKO','TFC.BALIK','TOKO','TFCBR');
DELETE FROM tm_barang WHERE kode_barang='TFC-YKXC-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-YKXC-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-YKXC-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-YKXC-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2025-11-04 09:13:19' WHERE kode_barang='TFC-YKXC-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-YKXC-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-11-04 09:13:19','TOKO','TFCBR','TFC','TFC-YKXC-17-0','1','1.240','1.240','1','1.240','1.240','83.00');
DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-YKXC-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFC-YKXC-17-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-04' WHERE no_faktur_beli='FB-251010-0001';
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-20251104-0002','1','TFC-YKXC-18-0','1','1.960','1.960','TOKO','TFC.BALIK','TOKO','TFCBR');
DELETE FROM tm_barang WHERE kode_barang='TFC-YKXC-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFC-YKXC-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-YKXC-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFC-YKXC-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCBR',tgl_last_beli='2025-11-04 09:13:19' WHERE kode_barang='TFC-YKXC-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFC-YKXC-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-11-04 09:13:19','TOKO','TFCBR','TFC','TFC-YKXC-18-0','1','1.960','1.960','1','1.960','1.960','83.00');
DELETE FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFC-YKXC-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFC-YKXC-18-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-04' WHERE no_faktur_beli='FB-251010-0002';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251104-0002','2025-11-04','09:13','4.290','kasir','2025-11-04 09:13:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-04 ','11:04:57');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01410','NITA','1','CC SILVER','CROM PUTIH DOFF SEMPROT','2.000','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-251104-0003','2025-11-04','2025-11-04 11:09:03','SERVICE : SV-01410','.','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-251104-0004','D','2025-11-04','11:09:03','TBC','SERVICE','SV-01410','17756493814','50000','17756543814','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-01410','2025-11-04','2025-11-04','11:09:03','PLG0007371','kasir','2025-11-13','kasir','2025-11-04 11:09:03','2.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-04 ','11:23:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-04 ','11:31:50');
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-01346','NITA','1','PER','CC SILVER','','','4.000','','925.00','1','60000','0','750000','0','750000','zircon 1','sz 13 krum pth glosy','grf adyatna font vladimir','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-251104-0004','2025-11-04','2025-11-04 11:43:45','PESANAN : DP-01346','.','TBC','750000','750000');
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-251104-0005','D','2025-11-04','11:43:45','TBC','PESANAN','DP-01346','17756543814','750000','17757293814','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-01346','2025-11-04','2025-11-04','11:43:45','PLG0007372','NITA','2025-12-04','kasir','2025-11-04 11:43:45','4.000','0','0','0','750000','0','0','750000','750000','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-01347','SULIS','1','PER','WEDDING RING','','','2.000','','925.00','1','60000','0','800000','0','800000','model spt contoh. sz 15 crom putih glosy','font berkshire swash grf Winti & Lukman','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251104-0005','2025-11-04','2025-11-04 12:28:56','PESANAN : DP-01347','.','TBC','800000','800000');
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-251104-0006','D','2025-11-04','12:28:56','TBC','PESANAN','DP-01347','17757293814','800000','17758093814','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-01347','2025-11-04','2025-11-04','12:28:56','PLG0007373','SULIS','2025-11-24','kasir','2025-11-04 12:28:56','2.000','0','0','0','800000','0','0','800000','800000','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-01348','SULIS','1','PER','WEDDING RING','','','4.000','','925.00','1','60000','0','700000','0','700000','sz 10.5 crom putih doff amplass','font berkshire swash grf Lukman & Winti','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251104-0006','2025-11-04','2025-11-04 12:39:25','PESANAN : DP-01348','.','TBC','700000','700000');
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-251104-0007','D','2025-11-04','12:39:25','TBC','PESANAN','DP-01348','17758093814','700000','17758793814','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-01348','2025-11-04','2025-11-04','12:39:25','PLG0007374','SULIS','2025-11-24','kasir','2025-11-04 12:39:25','4.000','0','0','0','700000','0','0','700000','700000','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-251104-0001','kasir','1',' DP-01236BI','TOKO','BIPPSN','PSPLT-YJBD-20-0','CINCIN PALADIUM ','','1.240','1','5.00','155000','0','0','16600','1010000','0','0','0','1010000','HELMI','00039302','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJBD-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='PSPLT-YJBD-20-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-251104-0001','2025-11-04','1.240','2025-11-04','12:54:04','PLG0007375','1010000','1010000','0','1010000','0','kasir','2025-11-04 12:54:04','FJ-251104-0001','DP-01236','537500');
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-11-04','FJ-251104-0001','2025-11-04','12:54:04','HELMI','1010000','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-251104-0007','2025-11-04','2025-11-04 12:54:04','PENJUALAN : FJ-251104-0001','.','TBC','472500','472500','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-251104-0008','D','2025-11-04','12:54:04','TBC','PENJUALAN','FJ-251104-0001','17758793814','472500','17759266314','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='472500' WHERE no_faktur_jual='FJ-251104-0001' 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-251104-0002','kasir',' 1',' DP-01237BI','TOKO','BIPPSN','PSPRT-YJBB-9-0','CINCIN PERAK ','','2.750','1','100.00','71000','0','0','16600','700000','0','0','0','700000','HELMI','00039258','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJBB-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.750',berat_jual_asli=berat_jual_asli+'2.750',stock_jual='1',berat_akhir=berat_akhir-'2.750',berat_akhir_asli=berat_akhir_asli-'2.750',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='PSPRT-YJBB-9-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-251104-0002','2025-11-04','2.750','2025-11-04','12:54:04','PLG0007376','700000','700000','0','700000','0','kasir','2025-11-04 12:54:04','FJ-251104-0001','DP-01237','700000');
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-11-04','FJ-251104-0002','2025-11-04','12:54:04','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='472500' WHERE no_faktur_jual='FJ-251104-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251104-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251104-0002';
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-251104-0003','kasir','1',' 700K-18-17','TOKO','BIPPER','PBDG-YJBH-38-0','CINCIN SILVER 925 ','','2.180','1','100.00','134000','0','0','16600','700000','0','0','0','700000','SUL','00039346','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJBH-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='PBDG-YJBH-38-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-251104-0003','2025-11-04','2.180','2025-11-04','13:10:46','PLG0007377','700000','700000','0','700000','0','kasir','2025-11-04 13:10:46','FJ-251104-0003','','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-11-04','FJ-251104-0003','2025-11-04','13:10:46','SUL','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-251104-0008','2025-11-04','2025-11-04 13:10:46','PENJUALAN : FJ-251104-0003','.','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-251104-0009','D','2025-11-04','13:10:46','TBC','PENJUALAN','FJ-251104-0003','17759266314','700000','17759966314','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='700000' WHERE no_faktur_jual='FJ-251104-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251104-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-04 ','13:25:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-04 ','13:58:06');
DELETE FROM tm_berlian WHERE kode_barang='BDG-XKBH-34-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XKBH-34-0','BDG-XKBH-34-0','00032375','RD','1','0.400','1350');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XKBH-34-0','00032375','RD','1','0.400','1350','540')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XKBH-34-0','BDG-XKBH-34-0','00032375','RD','16','0.095','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XKBH-34-0','00032375','RD','16','0.095','400','38')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDG-XKBH-34-0','00032375','00032375','BDG-00011 GIA 6495498661','BDG-00011 GIA 6495498661','','','14600500','14600500',' 0','0','spv','2025-11-04 13:59:36');
UPDATE tm_barang SET nama_barang='BDG-00011 GIA 6495498661' ,nama_atribut='' ,kode_intern='BDG-00011 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='GIA 87 000 000',total_usd='578' WHERE kode_barang='BDG-XKBH-34-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-04 ','14:47:08');
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-20251104-0003','1','PBDG-YKXD-10-0','1','2.450','2.450','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-10-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-10-0','1','2.450','2.450','1','2.450','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-10-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-11-0','1','2.270','2.270','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-11-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-11-0','1','2.270','2.270','1','2.270','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-11-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-12-0','1','2.260','2.260','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-12-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-12-0','1','2.260','2.260','1','2.260','2.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-12-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-13-0','1','1.920','1.920','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-13-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-13-0','1','1.920','1.920','1','1.920','1.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-13-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-14-0','1','2.140','2.140','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-14-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-14-0','1','2.140','2.140','1','2.140','2.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-14-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-15-0','1','3.690','3.690','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-15-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-15-0','1','3.690','3.690','1','3.690','3.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-15-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-16-0','1','3.210','3.210','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-16-0','1','3.210','3.210','1','3.210','3.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-16-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-17-0','1','4.130','4.130','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-17-0','1','4.130','4.130','1','4.130','4.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-17-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-18-0','1','6.030','6.030','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-18-0','1','6.030','6.030','1','6.030','6.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-18-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-19-0','1','5.280','5.280','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-19-0','1','5.280','5.280','1','5.280','5.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-19-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-20-0','1','1.730','1.730','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-20-0','1','1.730','1.730','1','1.730','1.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-20-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-21-0','1','1.610','1.610','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-21-0','1','1.610','1.610','1','1.610','1.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-21-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-22-0','1','1.220','1.220','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-22-0','1','1.220','1.220','1','1.220','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-22-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','1','PBDG-YKXD-30-0','1','1.320','1.320','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKXD-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKXD-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKXD-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-04 14:47:39' WHERE kode_barang='PBDG-YKXD-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKXD-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-11-04 14:47:39','TOKO','BIPPER','PBDG','PBDG-YKXD-30-0','1','1.320','1.320','1','1.320','1.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKXD-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKXD-30-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0003','2025-11-04','14:47','39.260','kasir','2025-11-04 14:47:39');
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-20251104-0004','1','PLBDG-YKXD-24-0','1','4.320','4.320','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YKXD-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YKXD-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YKXD-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-11-04 14:48:47' WHERE kode_barang='PLBDG-YKXD-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YKXD-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-11-04 14:48:47','TOKO','BIPPLD','PLBDG','PLBDG-YKXD-24-0','1','4.320','4.320','1','4.320','4.320','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YKXD-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-24-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0004','1','PLBDG-YKXD-25-0','1','4.390','4.390','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YKXD-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YKXD-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YKXD-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-11-04 14:48:47' WHERE kode_barang='PLBDG-YKXD-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YKXD-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-11-04 14:48:47','TOKO','BIPPLD','PLBDG','PLBDG-YKXD-25-0','1','4.390','4.390','1','4.390','4.390','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YKXD-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-25-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0004','1','PLBDG-YKXD-26-0','1','4.450','4.450','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YKXD-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YKXD-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YKXD-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-11-04 14:48:47' WHERE kode_barang='PLBDG-YKXD-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YKXD-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-11-04 14:48:47','TOKO','BIPPLD','PLBDG','PLBDG-YKXD-26-0','1','4.450','4.450','1','4.450','4.450','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YKXD-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-26-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0004','1','PLBDG-YKXD-27-0','1','3.350','3.350','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YKXD-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YKXD-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YKXD-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-11-04 14:48:47' WHERE kode_barang='PLBDG-YKXD-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YKXD-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-11-04 14:48:47','TOKO','BIPPLD','PLBDG','PLBDG-YKXD-27-0','1','3.350','3.350','1','3.350','3.350','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YKXD-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-27-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0004','1','PLBDG-YKXD-28-0','1','2.500','2.500','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YKXD-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YKXD-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YKXD-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-11-04 14:48:47' WHERE kode_barang='PLBDG-YKXD-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YKXD-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-11-04 14:48:47','TOKO','BIPPLD','PLBDG','PLBDG-YKXD-28-0','1','2.500','2.500','1','2.500','2.500','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YKXD-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-28-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0004','1','PLBDG-YKXD-29-0','1','2.550','2.550','TOKO','PLBDG','TOKO','BIPPLD');
DELETE FROM tm_barang WHERE kode_barang='PLBDG-YKXD-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PLBDG-YKXD-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLBDG-YKXD-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPLD',tgl_last_beli='2025-11-04 14:48:47' WHERE kode_barang='PLBDG-YKXD-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PLBDG-YKXD-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-11-04 14:48:47','TOKO','BIPPLD','PLBDG','PLBDG-YKXD-29-0','1','2.550','2.550','1','2.550','2.550','6.00');
DELETE FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLBDG-YKXD-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-YKXD-29-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0004','2025-11-04','14:48','21.560','kasir','2025-11-04 14:48:47');
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-20251104-0005','1','PSPLT-YKXD-1-0','1','4.750','4.750','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKXD-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKXD-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKXD-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPLT-YKXD-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKXD-1-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-11-04 14:49:09','TOKO','BIPPSN','PSPLT','PSPLT-YKXD-1-0','1','4.750','4.750','1','4.750','4.750','6.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-YKXD-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPLT-YKXD-2-0','1','4.200','4.200','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKXD-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKXD-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKXD-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPLT-YKXD-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKXD-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-11-04 14:49:09','TOKO','BIPPSN','PSPLT','PSPLT-YKXD-2-0','1','4.200','4.200','1','4.200','4.200','6.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-YKXD-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPLT-YKXD-3-0','1','4.050','4.050','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKXD-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKXD-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKXD-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPLT-YKXD-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKXD-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-11-04 14:49:09','TOKO','BIPPSN','PSPLT','PSPLT-YKXD-3-0','1','4.050','4.050','1','4.050','4.050','6.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-YKXD-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-3-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPLT-YKXD-4-0','1','3.310','3.310','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKXD-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKXD-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKXD-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPLT-YKXD-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKXD-4-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-11-04 14:49:09','TOKO','BIPPSN','PSPLT','PSPLT-YKXD-4-0','1','3.310','3.310','1','3.310','3.310','6.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-YKXD-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPLT-YKXD-5-0','1','6.410','6.410','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKXD-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKXD-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKXD-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPLT-YKXD-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKXD-5-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-11-04 14:49:09','TOKO','BIPPSN','PSPLT','PSPLT-YKXD-5-0','1','6.410','6.410','1','6.410','6.410','6.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-YKXD-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-5-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPRT-YKXD-6-0','1','1.860','1.860','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YKXD-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YKXD-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YKXD-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YKXD-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPRT-YKXD-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YKXD-6-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-11-04 14:49:09','TOKO','BIPPSN','PSPRT','PSPRT-YKXD-6-0','1','1.860','1.860','1','1.860','1.860','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-YKXD-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKXD-6-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPLT-YKXD-7-0','1','3.430','3.430','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKXD-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKXD-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKXD-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPLT-YKXD-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKXD-7-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-11-04 14:49:09','TOKO','BIPPSN','PSPLT','PSPLT-YKXD-7-0','1','3.430','3.430','1','3.430','3.430','6.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-YKXD-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKXD-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPRT-YKXD-8-0','1','3.260','3.260','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YKXD-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YKXD-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YKXD-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YKXD-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPRT-YKXD-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YKXD-8-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-11-04 14:49:09','TOKO','BIPPSN','PSPRT','PSPRT-YKXD-8-0','1','3.260','3.260','1','3.260','3.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-YKXD-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKXD-8-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','1','PSPRT-YKXD-23-0','1','3.040','3.040','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YKXD-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YKXD-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YKXD-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YKXD-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-04 14:49:09' WHERE kode_barang='PSPRT-YKXD-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YKXD-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-11-04 14:49:09','TOKO','BIPPSN','PSPRT','PSPRT-YKXD-23-0','1','3.040','3.040','1','3.040','3.040','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-YKXD-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKXD-23-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-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-20251104-0005','2025-11-04','14:49','34.310','kasir','2025-11-04 14:49:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-04 ','15:59:17');
DELETE FROM tm_berlian WHERE kode_barang='CBRT-PKAE-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-PKAE-5-0','CBRT-PKAE-5-0','00018463','RD','1','0.050','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-PKAE-5-0','00018463','RD','1','0.050','480','24')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-PKAE-5-0','CBRT-PKAE-5-0','00018463','RD','18','0.520','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-PKAE-5-0','00018463','RD','18','0.520','420','218.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-PKAE-5-0','CBRT-PKAE-5-0','00018463','RD','30','0.355','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-PKAE-5-0','00018463','RD','30','0.355','420','149.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-PKAE-5-0','CBRT-PKAE-5-0','00018463','RD','53','0.345','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-PKAE-5-0','00018463','RD','53','0.345','400','138')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-PKAE-5-0','00018463','00018463','CINCIN CBRT-00263','CINCIN CBRT-00263','','','8313000','8313000',' 0','0','spv','2025-11-04 16:02:50');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00263' ,nama_atribut='' ,kode_intern='CBRT-00263 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1125',total_usd_ext='IDR 63 000 000',total_usd='529.5' WHERE kode_barang='CBRT-PKAE-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WECA-38-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WECA-38-0','CBRT-WECA-38-0','00022071','RD','37','0.430','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WECA-38-0','00022071','RD','37','0.430','420','180.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-WECA-38-0','00022071','00022071','CINCIN CBRT-00402','CINCIN CBRT-00402','','','4760500','4760500',' 0','0','spv','2025-11-04 16:04:58');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00402' ,nama_atribut='' ,kode_intern='CBRT-00402 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1271 11 5 1125',total_usd_ext='IDB 31 000 000',total_usd='180.6' WHERE kode_barang='CBRT-WECA-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-PJXE-32-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-PJXE-32-0','CBRT-PJXE-32-0','00017626','RD','48','0.330','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-PJXE-32-0','00017626','RD','48','0.330','420','138.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-PJXE-32-0','CBRT-PJXE-32-0','00017626','SP','1','0.405','50');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-PJXE-32-0','00017626','SP','1','0.405','50','20.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-PJXE-32-0','00017626','00017626','CINCIN CBRT-00156','CINCIN CBRT-00156','','','8064000','8064000',' 0','0','spv','2025-11-04 16:06:38');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00156' ,nama_atribut='' ,kode_intern='CBRT-00156 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1066 14 1125',total_usd_ext='IDR 45 000 000',total_usd='158.85' WHERE kode_barang='CBRT-PJXE-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-XGXC-23-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XGXC-23-0','TFC-XGXC-23-0','00029526','RD','61','0.430','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XGXC-23-0','00029526','RD','61','0.430','420','180.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFC-XGXC-23-0','00029526','00029526','CINCIN TFC-21378','CINCIN TFC-21378','','','8988000','8988000',' 0','0','spv','2025-11-04 16:08:17');
UPDATE tm_barang SET nama_barang='CINCIN TFC-21378' ,nama_atribut='' ,kode_intern='TFC-21378 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 11 5 1125',total_usd_ext='IDB 47 000 000',total_usd='180.6' WHERE kode_barang='TFC-XGXC-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WDAE-21-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WDAE-21-0','CBRT-WDAE-21-0','00021405','RD','44','0.300','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WDAE-21-0','00021405','RD','44','0.300','420','126')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WDAE-21-0','CBRT-WDAE-21-0','00021405','RD','1','0.295','1050');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WDAE-21-0','00021405','RD','1','0.295','1050','309.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WDAE-21-0','CBRT-WDAE-21-0','00021405','RD','16','0.050','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WDAE-21-0','00021405','RD','16','0.050','420','21')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-WDAE-21-0','00021405','00021405','CINCIN CBRT-00515','CINCIN CBRT-00515','','','7940000','7940000',' 0','0','spv','2025-11-04 16:11:32');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00515' ,nama_atribut='' ,kode_intern='CBRT-00515 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C620 RS 14 1125',total_usd_ext='IDR 57 000 000',total_usd='456.75' WHERE kode_barang='CBRT-WDAE-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-WHBC-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-16-0','TFC-WHBC-16-0','00023607','RD','31','0.285','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-16-0','00023607','RD','31','0.285','420','119.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-16-0','TFC-WHBC-16-0','00023607','RD','1','0.100','650');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-16-0','00023607','RD','1','0.100','650','65')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFC-WHBC-16-0','00023607','00023607','CINCIN TFC-21124','CINCIN TFC-21124','','','7384500','7384500',' 0','0','spv','2025-11-04 16:13:15');
UPDATE tm_barang SET nama_barang='CINCIN TFC-21124' ,nama_atribut='' ,kode_intern='TFC-21124 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 1125',total_usd_ext='IDR 39 000 000',total_usd='184.7' WHERE kode_barang='TFC-WHBC-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WHAE-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WHAE-6-0','CBRT-WHAE-6-0','00023490','RD','1','0.125','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WHAE-6-0','00023490','RD','1','0.125','750','93.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WHAE-6-0','CBRT-WHAE-6-0','00023490','RD','26','0.140','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WHAE-6-0','00023490','RD','26','0.140','420','58.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WHAE-6-0','CBRT-WHAE-6-0','00023490','RD','6','0.240','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WHAE-6-0','00023490','RD','6','0.240','420','100.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-WHAE-6-0','00023490','00023490','CINCIN CBRT-00652','CINCIN CBRT-00652','','','9645000','9645000',' 0','0','spv','2025-11-04 16:15:18');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00652' ,nama_atribut='' ,kode_intern='CBRT-00652 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1125',total_usd_ext='IDR 53 000 000',total_usd='253.35' WHERE kode_barang='CBRT-WHAE-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-XEBH-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XEBH-5-0','TFC-XEBH-5-0','00028682','RD','14','0.295','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XEBH-5-0','00028682','RD','14','0.295','420','123.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XEBH-5-0','TFC-XEBH-5-0','00028682','RD','6','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XEBH-5-0','00028682','RD','6','0.180','420','75.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XEBH-5-0','TFC-XEBH-5-0','00028682','RD','1','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XEBH-5-0','00028682','RD','1','0.060','450','27')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XEBH-5-0','TFC-XEBH-5-0','00028682','RD','32','0.185','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XEBH-5-0','00028682','RD','32','0.185','420','77.7')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFC-XEBH-5-0','00028682','00028682','CINCIN TFC-21366','CINCIN TFC-21366','','','5879500','5879500',' 0','0','spv','2025-11-04 16:17:17');
UPDATE tm_barang SET nama_barang='CINCIN TFC-21366' ,nama_atribut='' ,kode_intern='TFC-21366 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='803804 125 1025',total_usd_ext='IDB 42 000 000',total_usd='304.2' WHERE kode_barang='TFC-XEBH-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WEXF-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WEXF-5-0','CBRT-WEXF-5-0','00021503','RD','8','0.145','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WEXF-5-0','00021503','RD','8','0.145','420','60.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WEXF-5-0','CBRT-WEXF-5-0','00021503','RD','1','0.065','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WEXF-5-0','00021503','RD','1','0.065','450','29.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WEXF-5-0','CBRT-WEXF-5-0','00021503','RD','8','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WEXF-5-0','00021503','RD','8','0.025','420','10.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-WEXF-5-0','00021503','00021503','CINCIN CBRT-00529','CINCIN CBRT-00529','','','3708000','3708000',' 0','0','spv','2025-11-04 16:19:06');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00529' ,nama_atribut='' ,kode_intern='CBRT-00529 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1125',total_usd_ext='IDR 21 000 000',total_usd='100.65' WHERE kode_barang='CBRT-WEXF-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDC-XIAX-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDC-XIAX-4-0','BDC-XIAX-4-0','00031184','RD','41','0.240','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDC-XIAX-4-0','00031184','RD','41','0.240','400','96')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDC-XIAX-4-0','BDC-XIAX-4-0','00031184','RD','1','0.220','800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDC-XIAX-4-0','00031184','RD','1','0.220','800','176')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDC-XIAX-4-0','00031184','00031184','CINCIN BDC-00028','CINCIN BDC-00028','','','6833500','6833500',' 0','0','spv','2025-11-04 16:21:01');
UPDATE tm_barang SET nama_barang='CINCIN BDC-00028' ,nama_atribut='' ,kode_intern='BDC-00028 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1125',total_usd_ext='IDR 42 000 000',total_usd='272' WHERE kode_barang='BDC-XIAX-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-WHBC-18-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-18-0','TFC-WHBC-18-0','00023609','RD','4','0.065','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-18-0','00023609','RD','4','0.065','420','27.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-18-0','TFC-WHBC-18-0','00023609','RD','5','0.130','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-18-0','00023609','RD','5','0.130','420','54.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-18-0','TFC-WHBC-18-0','00023609','RD','22','0.110','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-18-0','00023609','RD','22','0.110','420','46.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFC-WHBC-18-0','00023609','00023609','CINCIN TFC-21126','CINCIN TFC-21126','','','6392500','6392500',' 0','0','spv','2025-11-04 16:22:59');
UPDATE tm_barang SET nama_barang='CINCIN TFC-21126' ,nama_atribut='' ,kode_intern='TFC-21126 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 1125',total_usd_ext='IDR 33 000 000',total_usd='128.1' WHERE kode_barang='TFC-WHBC-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-XLXI-9-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XLXI-9-0','TFC-XLXI-9-0','00032498','RD','12','0.220','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XLXI-9-0','00032498','RD','12','0.220','400','88')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XLXI-9-0','TFC-XLXI-9-0','00032498','RD','12','0.265','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XLXI-9-0','00032498','RD','12','0.265','400','106')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFC-XLXI-9-0','00032498','00032498','CINCIN TFC-21414','CINCIN TFC-21414','','','5968500','5968500',' 0','0','spv','2025-11-04 16:24:47');
UPDATE tm_barang SET nama_barang='CINCIN TFC-21414' ,nama_atribut='' ,kode_intern='TFC-21414 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='BTM025 13 1125',total_usd_ext='IDR 36 500 000',total_usd='194' WHERE kode_barang='TFC-XLXI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-WHBC-11-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-11-0','TFC-WHBC-11-0','00023602','RD','1','0.065','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-11-0','00023602','RD','1','0.065','420','27.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-11-0','TFC-WHBC-11-0','00023602','RD','2','0.030','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-11-0','00023602','RD','2','0.030','420','12.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-WHBC-11-0','TFC-WHBC-11-0','00023602','RD','18','0.090','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-WHBC-11-0','00023602','RD','18','0.090','420','37.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFC-WHBC-11-0','00023602','00023602','CINCIN TFC-21119','CINCIN TFC-21119','','','8905000','8905000',' 0','0','spv','2025-11-04 16:27:00');
UPDATE tm_barang SET nama_barang='CINCIN TFC-21119' ,nama_atribut='' ,kode_intern='TFC-21119 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1125',total_usd_ext='IDR 38 000 000',total_usd='77.7' WHERE kode_barang='TFC-WHBC-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WIXF-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIXF-16-0','CBRT-WIXF-16-0','00023857','RD','1','0.090','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIXF-16-0','00023857','RD','1','0.090','600','54')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIXF-16-0','CBRT-WIXF-16-0','00023857','RD','70','0.430','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIXF-16-0','00023857','RD','70','0.430','420','180.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIXF-16-0','CBRT-WIXF-16-0','00023857','RD','2','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIXF-16-0','00023857','RD','2','0.040','420','16.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIXF-16-0','CBRT-WIXF-16-0','00023857','RD','4','0.100','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIXF-16-0','00023857','RD','4','0.100','420','42')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-WIXF-16-0','00023857','00023857','CINCIN CBRT-00198','CINCIN CBRT-00198','','','5240000','5240000',' 0','0','spv','2025-11-04 16:29:15');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00198' ,nama_atribut='' ,kode_intern='CBRT-00198 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1146 14 1125',total_usd_ext='IDB 39 500 000',total_usd='293.4' WHERE kode_barang='CBRT-WIXF-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WIAF-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIAF-13-0','CBRT-WIAF-13-0','00024038','RD','32','0.155','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIAF-13-0','00024038','RD','32','0.155','400','62')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIAF-13-0','CBRT-WIAF-13-0','00024038','RD','4','0.045','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIAF-13-0','00024038','RD','4','0.045','420','18.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIAF-13-0','CBRT-WIAF-13-0','00024038','RD','6','0.110','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIAF-13-0','00024038','RD','6','0.110','420','46.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIAF-13-0','CBRT-WIAF-13-0','00024038','RD','1','0.075','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIAF-13-0','00024038','RD','1','0.075','480','36')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-WIAF-13-0','00024038','00024038','CINCIN CBRT-00539','CINCIN CBRT-00539','','','7627000','7627000',' 0','0','spv','2025-11-04 16:31:09');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00539' ,nama_atribut='' ,kode_intern='CBRT-00539 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1125',total_usd_ext='IDB 38 500 000',total_usd='163.1' WHERE kode_barang='CBRT-WIAF-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WEBC-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WEBC-4-0','CBRT-WEBC-4-0','00021844','BD','75','0.570','150');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WEBC-4-0','00021844','BD','75','0.570','150','85.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRT-WEBC-4-0','00021844','00021844','CINCIN CBRT-00573','CINCIN CBRT-00573','','','10924000','10924000',' 0','0','spv','2025-11-04 16:32:56');
UPDATE tm_barang SET nama_barang='CINCIN CBRT-00573' ,nama_atribut='' ,kode_intern='CBRT-00573 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1151 15 1125',total_usd_ext='IDR 54 000 000',total_usd='85.5' WHERE kode_barang='CBRT-WEBC-4-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251104-0004','kasir','1',' 700K-20-16','TOKO','BIPPER','PBDG-YJXC-5-0','CINCIN SILVER 925 ','','4.630','1','100.00','119000','0','0','16600','700000','0','0','0','700000','NITA','00038976','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJXC-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.630',berat_jual_asli=berat_jual_asli+'4.630',stock_jual='1',berat_akhir=berat_akhir-'4.630',berat_akhir_asli=berat_akhir_asli-'4.630',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='PBDG-YJXC-5-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-251104-0004','2025-11-04','4.630','2025-11-04','17:01:37','PLG0007378','700000','700000','0','700000','0','kasir','2025-11-04 17:01:36','FJ-251104-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-11-04','FJ-251104-0004','2025-11-04','17:01:37','NITA','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-251104-0009','2025-11-04','2025-11-04 17:01:36','PENJUALAN : FJ-251104-0004','.','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-251104-0010','D','2025-11-04','17:01:37','TBC','PENJUALAN','FJ-251104-0004','17759966314','700000','17760666314','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='700000' WHERE no_faktur_jual='FJ-251104-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-251104-0005','kasir',' 1',' 700K-165-1','TOKO','BIPPER','PBDG-YJBH-23-0','CINCIN SILVER 925 ','','2.890','1','100.00','177000','0','0','16600','700000','0','0','0','700000','NITA','00039331','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJBH-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='PBDG-YJBH-23-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-251104-0005','2025-11-04','2.890','2025-11-04','17:01:37','PLG0007379','700000','700000','0','700000','0','kasir','2025-11-04 17:01:36','FJ-251104-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-11-04','FJ-251104-0005','2025-11-04','17:01:37','NITA','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-251104-0010','2025-11-04','2025-11-04 17:01:36','PENJUALAN : FJ-251104-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-251104-0011','D','2025-11-04','17:01:37','TBC','PENJUALAN','FJ-251104-0005','17760666314','700000','17761366314','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='1400000' WHERE no_faktur_jual='FJ-251104-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251104-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251104-0005';
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-251104-0006','kasir','1',' DP-01282BI','TOKO','BIPPSN','PSPRT-YJCX-2-0','CINCIN PERAK ','','2.520','1','100.00','155000','0','0','16600','700000','0','0','0','700000','NITA','00039358','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJCX-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='PSPRT-YJCX-2-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-251104-0006','2025-11-04','2.520','2025-11-04','19:24:27','PLG0007380','700000','700000','0','700000','0','kasir','2025-11-04 19:24:27','FJ-251104-0006','DP-01282','700000');
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-11-04','FJ-251104-0006','2025-11-04','19:24:27','NITA','700000','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-251104-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251104-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-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-11-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-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-251105-0001','D','2025-11-05','20:04:45','TBC','SALDO AWAL','SALDO AWAL','0','17761366314','17761366314');
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-251105-0001','D','2025-11-05','20:04:45','BCD','SALDO AWAL','SALDO AWAL','0','1334821000','1334821000');
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-251105-0001','D','2025-11-05','20:04:45','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251105-0001','D','2025-11-05','20:04:45','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
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-251105-0001','D','2025-11-05','20:04:45','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
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-251105-0001','D','2025-11-05','20:04:45','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-251105-0001','D','2025-11-05','20:04:45','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-251105-0001','D','2025-11-05','20:04:45','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-251105-0001','D','2025-11-05','20:04:45','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-251105-0001','D','2025-11-05','20:04:45','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-251105-0001','D','2025-11-05','20:04:45','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-11-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-04 ','20:41:37');
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-251104-0007','kasir','1',' DP-01129BI','TOKO','BIPPSN','PSPLT-YJXB-13-0','CINCIN PALADIUM ','','2.980','1','15.00','1011000','0','0','16600','2041000','0','0','0','2041000','HELMI','00038969','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJXB-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PSPLT-YJXB-13-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-251104-0007','2025-11-05','2.980','2025-11-04','20:50:05','PLG0007381','2041000','2041000','0','2041000','0','kasir','2025-11-04 20:50:05','FJ-251104-0007','DP-01129','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-11-05','FJ-251104-0007','2025-11-04','20:50:05','HELMI','2041000','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-251105-0001','2025-11-05','2025-11-04 20:50:05','PENJUALAN : FJ-251104-0007','.','TBC','1016000','1016000','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-251105-0002','D','2025-11-05','20:50:05','TBC','PENJUALAN','FJ-251104-0007','17761366314','1016000','17762382314','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='1016000' WHERE no_faktur_jual='FJ-251104-0007' LIMIT 1;