INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-27 ','11:48:42');
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-260527-0001','kasirbip','1',' DP-01959BI','TOKO','BIPPSN','PSPRT-ZEXD-9-0','CINCIN PERAK SR-04 YL-01 ','','3.080','1','100.00','315000','0','0','17800','850000','0','0','0','850000','SULIS','00043141','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEXD-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPRT-ZEXD-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-260527-0001','2026-05-27','3.080','2026-05-27','11:49:36','PLG0011403','850000','850000','0','850000','0','kasirbip','2026-05-27 11:49:36','FJ-260527-0001','DP-01959','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0001','2026-05-27','11:49:36','SULIS','850000','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-260527-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','12:22:11');
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-02234','DIL','1','GOLD','WEDDING RING','','','2.500','','37.50','1','2420000','1500000','0','900000','4650000','PERMATA ZIRCON 9 BUTIR','SIZE 12.5 GRF: Cholis (font vintage)','crom putih (emas putih)','90000','c','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260527-0001','2026-05-27','2026-05-27 12:27:39','PESANAN : DP-02234','-','TBC','3200000','3200000');
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-260527-0002','D','2026-05-27','12:27:39','TBC','PESANAN','DP-02234','22856363514','3200000','22859563514','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-02234','2026-05-27','2026-05-27','12:27:39','PLG0011404','DIL','2026-06-10','sby','2026-05-27 12:27:39','2.500','0','0','0','3200000','0','900000','4740000','4740000','1540000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','12:27:57');
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-02235','DIL','1','PLD','WEDDING RING','','','3.500','','25.00','1','1200000','550000','0','700000','2625000','SIZE 25 GRF: Windy (font vintage)','crom putih doff mix glossy','','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-260527-0002','2026-05-27','2026-05-27 12:35:37','PESANAN : DP-02235','-','TBC','1800000','1800000');
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-260527-0003','D','2026-05-27','12:35:37','TBC','PESANAN','DP-02235','22859563514','1800000','22861363514','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-02235','2026-05-27','2026-05-27','12:35:37','PLG0011405','DIL','2026-06-10','sby','2026-05-27 12:35:37','3.500','0','0','0','1800000','0','700000','2625000','2625000','825000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-27 ','12:35:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','12:35:53');
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-02236','PUT','1','PER','WEDD RING','','','3.000','','925.00','1','100000','0','950000','0','950000','exspress 200.000','sz 15 crom putih gllosy catalog LX 60','grf Gilang font Yeseva','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-260527-0003','2026-05-27','2026-05-27 12:51:57','PESANAN : DP-02236','.','TBC','950000','950000');
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-260527-0004','D','2026-05-27','12:51:57','TBC','PESANAN','DP-02236','22861363514','950000','22862313514','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-02236','2026-05-27','2026-05-27','12:51:57','PLG0011406','PUT','2026-06-09','kasirbip','2026-05-27 12:51:57','3.000','0','0','0','950000','0','0','950000','950000','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-02237','PUT','1','PER','WEDD RING','','','4.000','','925.00','1','100000','0','900000','0','900000','Sz 18 crom doff semprot','catalog LX 60','grf Ananda font yeseva','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-260527-0004','2026-05-27','2026-05-27 12:54:37','PESANAN : DP-02237','.','TBC','900000','900000');
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-260527-0005','D','2026-05-27','12:54:37','TBC','PESANAN','DP-02237','22862313514','900000','22863213514','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-02237','2026-05-27','2026-05-27','12:54:37','PLG0011407','PUT','2026-06-09','kasirbip','2026-05-27 12:54:37','4.000','0','0','0','900000','0','0','900000','900000','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-02238','SAL','1','PER','SEPASANG WED RING','','','3.000','','925.00','1','100000','0','1750000','0','1750000','putih glossy comb doff semprot dikeduanya','cwe sz 14 grf Oey Tjoe How cwo sz 21 grf Tjoa Mey Fung','font vladimir','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260527-0005','2026-05-27','2026-05-27 13:45:54','PESANAN : DP-02238','.','TBC','1750000','1750000');
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-260527-0006','D','2026-05-27','13:45:54','TBC','PESANAN','DP-02238','22863213514','1750000','22864963514','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-02238','2026-05-27','2026-05-27','13:45:54','PLG0011408','SAL','2026-06-27','kasirbip','2026-05-27 13:45:54','3.000','0','0','0','1750000','0','0','1750000','1750000','0');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-27',  status ='CLOS' WHERE no_service='SV-02036';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02036';
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-20260527-0001','1','PSPRT-ZEBF-13-0','1','3.320','3.320','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBF-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBF-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBF-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-27 14:10:21' WHERE kode_barang='PSPRT-ZEBF-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBF-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 ('2026-05-27 14:10:21','TOKO','DUPSN','PSPRT','PSPRT-ZEBF-13-0','1','3.320','3.320','1','3.320','3.320','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-ZEBF-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0001','1','PSPLT-ZEBF-14-0','1','2.790','2.790','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-27 14:10:21' WHERE kode_barang='PSPLT-ZEBF-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 14:10:21','TOKO','DUPSN','PSPLT','PSPLT-ZEBF-14-0','1','2.790','2.790','1','2.790','2.790','57.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-ZEBF-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0001','1','PSPLT-ZEBF-15-0','1','4.160','4.160','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-27 14:10:21' WHERE kode_barang='PSPLT-ZEBF-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 14:10:21','TOKO','DUPSN','PSPLT','PSPLT-ZEBF-15-0','1','4.160','4.160','1','4.160','4.160','57.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-ZEBF-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260527-0001','2026-05-27','14:09','10.270','kasirbip','2026-05-27 14:10:21');
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-02239','PUT','1','PLD','1 BUAH CINCIN','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','exspress 150.000','sz 18 crom doff semprot','grf DS ','','','');
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-02239','PUT','2','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-260527-0006','2026-05-27','2026-05-27 14:31:26','PESANAN : DP-02239','.','TBC','1580000','1580000');
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-260527-0007','D','2026-05-27','14:31:26','TBC','PESANAN','DP-02239','22864963514','1580000','22866543514','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-02239','2026-05-27','2026-05-27','14:31:26','PLG0011409','PUT','2026-06-02','kasirbip','2026-05-27 14:31:26','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000');
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-260527-0002','kasirbip','1',' DP-02058BI','TOKO','BIPPSN','PSPRT-ZEAH-3-0','CINCIN PERAK SR-03 YL-01 ','','3.020','1','100.00','309000','0','0','17800','950000','0','0','0','950000','SULIS','00043615','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEAH-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPRT-ZEAH-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260527-0002','2026-05-27','3.020','2026-05-27','14:40:50','PLG0011410','950000','950000','0','950000','0','kasirbip','2026-05-27 14:40:50','FJ-260527-0002','DP-02058','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0002','2026-05-27','14:40:50','SULIS','950000','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-260527-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260527-0003','kasirbip','1',' DP-02138DU','TOKO','DUPSN','PSPRT-ZEBE-29-0','CINCIN PERAK SR-05 YL-01 ','','3.050','1','100.00','336000','0','0','17800','950000','0','0','0','950000','PUT','00043790','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBE-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPRT-ZEBE-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260527-0003','2026-05-27','3.050','2026-05-27','14:52:53','PLG0011411','950000','950000','0','950000','0','kasirbip','2026-05-27 14:52:53','FJ-260527-0003','DP-02138','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0003','2026-05-27','14:52:53','PUT','950000','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-260527-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','15:40:39');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02240','PUT','1','PLD','WEDD RING','','','2.500','','10.00','1','1200000','350000','0','1000000','1875000','sirkon 19','sz 8 crom putih gllosy','grf Luthfi 108 1330.1"E','190000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260527-0007','2026-05-27','2026-05-27 15:46:58','PESANAN : DP-02240','.','TBC','1652000','1652000');
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-260527-0008','D','2026-05-27','15:46:58','TBC','PESANAN','DP-02240','22866543514','1652000','22868195514','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-02240','2026-05-27','2026-05-27','15:46:58','PLG0011412','PUT','2026-06-20','kasirbip','2026-05-27 15:46:58','2.500','0','0','0','1652000','0','1000000','2065000','2065000','413000');
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-02241','PUT','1','PLD','WEDD RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 19 crom putih doff semprot sprti cntoh','grf Levina 7 2016.6"S','Font Times new roman','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-260527-0008','2026-05-27','2026-05-27 15:51:26','PESANAN : DP-02241','.','TBC','1440000','1440000');
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-260527-0009','D','2026-05-27','15:51:26','TBC','PESANAN','DP-02241','22868195514','1440000','22869635514','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-02241','2026-05-27','2026-05-27','15:51:26','PLG0011413','PUT','2026-06-20','kasirbip','2026-05-27 15:51:26','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-02242','VAN','1','PLD','WEDDING RING','','','5.000','','25.00','1','1200000','550000','','800000','3550000','Tanpa permta','Putih doff mix glossy','Grafir Nama: Mei Carnes ??','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260527-0009','2026-05-27','2026-05-27 15:52:53','PESANAN : DP-02242','-','TBC','2400000','2400000');
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-260527-0010','D','2026-05-27','15:52:53','TBC','PESANAN','DP-02242','22869635514','2400000','22872035514','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-02242','2026-05-27','2026-05-27','15:52:53','PLG0011414','VAN','2026-06-24','sby','2026-05-27 15:52:53','5.000','0','0','0','2400000','0','800000','3550000','3550000','1150000');
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-20260527-0002','1','PSPRT-ZEBE-11-0','1','3.210','3.210','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-11-0','1','3.210','3.210','1','3.210','3.210','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-ZEBE-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBE-12-0','1','1.540','1.540','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-12-0','1','1.540','1.540','1','1.540','1.540','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-ZEBE-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBE-13-0','1','2.060','2.060','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-13-0','1','2.060','2.060','1','2.060','2.060','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-ZEBE-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBE-14-0','1','1.770','1.770','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBE-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBE-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBE-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBE-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPLT-ZEBE-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPLT','PSPLT-ZEBE-14-0','1','1.770','1.770','1','1.770','1.770','17.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-ZEBE-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBE-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBE-15-0','1','2.970','2.970','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-15-0','1','2.970','2.970','1','2.970','2.970','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-ZEBE-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBE-16-0','1','2.680','2.680','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-16-0','1','2.680','2.680','1','2.680','2.680','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-ZEBE-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBE-17-0','1','3.030','3.030','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-17-0','1','3.030','3.030','1','3.030','3.030','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-ZEBE-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBE-18-0','1','4.090','4.090','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-18-0','1','4.090','4.090','1','4.090','4.090','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-ZEBE-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBE-19-0','1','2.930','2.930','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBE-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBE-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBE-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBE-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBE-19-0','1','2.930','2.930','1','2.930','2.930','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-ZEBE-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBE-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSGT-ZEBE-20-0','1','1.230','1.230','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBE-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBE-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBE-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBE-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSGT-ZEBE-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSGT','PSGT-ZEBE-20-0','1','1.230','1.230','1','1.230','1.230','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZEBE-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBE-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBE-21-0','1','1.640','1.640','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBE-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBE-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBE-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBE-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPLT-ZEBE-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPLT','PSPLT-ZEBE-21-0','1','1.640','1.640','1','1.640','1.640','17.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-ZEBE-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBE-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSGT-ZEBE-22-0','1','1.440','1.440','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBE-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBE-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBE-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBE-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSGT-ZEBE-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSGT','PSGT-ZEBE-22-0','1','1.440','1.440','1','1.440','1.440','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZEBE-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBE-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBE-23-0','1','1.660','1.660','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBE-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBE-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBE-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBE-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPLT-ZEBE-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBE-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPLT','PSPLT-ZEBE-23-0','1','1.660','1.660','1','1.660','1.660','32.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-ZEBE-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBE-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBF-3-0','1','2.370','2.370','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPLT-ZEBF-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPLT','PSPLT-ZEBF-3-0','1','2.370','2.370','1','2.370','2.370','17.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-ZEBF-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBF-4-0','1','2.970','2.970','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBF-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBF-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBF-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPRT-ZEBF-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBF-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPRT','PSPRT-ZEBF-4-0','1','2.970','2.970','1','2.970','2.970','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-ZEBF-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBF-5-0','1','2.390','2.390','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:37' WHERE kode_barang='PSPLT-ZEBF-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 15:57:37','TOKO','BIPPSN','PSPLT','PSPLT-ZEBF-5-0','1','2.390','2.390','1','2.390','2.390','17.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-ZEBF-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBF-6-0','1','2.100','2.100','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBF-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBF-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBF-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:38' WHERE kode_barang='PSPRT-ZEBF-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBF-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 ('2026-05-27 15:57:38','TOKO','BIPPSN','PSPRT','PSPRT-ZEBF-6-0','1','2.100','2.100','1','2.100','2.100','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-ZEBF-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPRT-ZEBF-7-0','1','3.090','3.090','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBF-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBF-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBF-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:38' WHERE kode_barang='PSPRT-ZEBF-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBF-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 ('2026-05-27 15:57:38','TOKO','BIPPSN','PSPRT','PSPRT-ZEBF-7-0','1','3.090','3.090','1','3.090','3.090','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-ZEBF-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBF-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBF-8-0','1','4.080','4.080','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:38' WHERE kode_barang='PSPLT-ZEBF-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 15:57:38','TOKO','BIPPSN','PSPLT','PSPLT-ZEBF-8-0','1','4.080','4.080','1','4.080','4.080','17.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-ZEBF-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBF-9-0','1','2.090','2.090','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:38' WHERE kode_barang='PSPLT-ZEBF-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-27 15:57:38','TOKO','BIPPSN','PSPLT','PSPLT-ZEBF-9-0','1','2.090','2.090','1','2.090','2.090','17.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-ZEBF-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBF-10-0','1','0.910','0.910','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:38' WHERE kode_barang='PSPLT-ZEBF-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 15:57:38','TOKO','BIPPSN','PSPLT','PSPLT-ZEBF-10-0','1','0.910','0.910','1','0.910','0.910','17.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-ZEBF-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBF-11-0','1','2.970','2.970','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:38' WHERE kode_barang='PSPLT-ZEBF-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 15:57:38','TOKO','BIPPSN','PSPLT','PSPLT-ZEBF-11-0','1','2.970','2.970','1','2.970','2.970','17.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-ZEBF-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' 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-20260527-0002','1','PSPLT-ZEBF-12-0','1','2.580','2.580','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBF-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBF-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBF-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-27 15:57:38' WHERE kode_barang='PSPLT-ZEBF-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBF-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 ('2026-05-27 15:57:38','TOKO','BIPPSN','PSPLT','PSPLT-ZEBF-12-0','1','2.580','2.580','1','2.580','2.580','17.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-ZEBF-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBF-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-27' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260527-0002','2026-05-27','15:57','55.800','kasirbip','2026-05-27 15:57: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-260527-0004','kasirbip','1',' 750K-16-24','TOKO','BIPPER','PBDG-ZDAX-20-0','CINCIN SILVER 925 ','','3.610','1','100.00','369000','0','0','17800','850000','0','0','0','850000','GIN','00042457','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAX-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.610',berat_jual_asli=berat_jual_asli+'3.610',stock_jual='1',berat_akhir=berat_akhir-'3.610',berat_akhir_asli=berat_akhir_asli-'3.610',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PBDG-ZDAX-20-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-260527-0004','2026-05-27','3.610','2026-05-27','16:44:09','PLG0011415','850000','850000','0','850000','0','kasirbip','2026-05-27 16:44:08','FJ-260527-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0004','2026-05-27','16:44:09','GIN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260527-0010','2026-05-27','2026-05-27 16:44:08','PENJUALAN : FJ-260527-0004','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260527-0011','D','2026-05-27','16:44:09','TBC','PENJUALAN','FJ-260527-0004','22872035514','850000','22872885514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260527-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-260527-0005','kasirbip',' 1',' 700K-14-23','TOKO','BIPPER','PBDG-ZDXG-43-0','CINCIN SILVER 925 ','','2.790','1','100.00','285000','0','0','17800','800000','0','0','0','800000','GIN','00042358','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.790',berat_jual_asli=berat_jual_asli+'2.790',stock_jual='1',berat_akhir=berat_akhir-'2.790',berat_akhir_asli=berat_akhir_asli-'2.790',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PBDG-ZDXG-43-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-260527-0005','2026-05-27','2.790','2026-05-27','16:44:09','PLG0011416','800000','800000','0','800000','0','kasirbip','2026-05-27 16:44:08','FJ-260527-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0005','2026-05-27','16:44:09','GIN','800000','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-260527-0011','2026-05-27','2026-05-27 16:44:08','PENJUALAN : FJ-260527-0005','.','TBC','800000','800000','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-260527-0012','D','2026-05-27','16:44:09','TBC','PENJUALAN','FJ-260527-0005','22872885514','800000','22873685514','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='1650000' WHERE no_faktur_jual='FJ-260527-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','18:08:27');
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-02243','PUT','1','PER','WEDD RING CUSTOM','','','4.000','','925.00','1','100000','0','900000','0','900000','exspress 200.000','sz 21.5 crom putih gllosy sprti cntoh','grf Via font vintage','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-260527-0012','2026-05-27','2026-05-27 18:10:32','PESANAN : DP-02243','.','TBC','900000','900000');
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-260527-0013','D','2026-05-27','18:10:32','TBC','PESANAN','DP-02243','22873685514','900000','22874585514','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-02243','2026-05-27','2026-05-27','18:10:32','PLG0011417','PUT','2026-06-08','kasirbip','2026-05-27 18:10:32','4.000','0','0','0','900000','0','0','900000','900000','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-260527-0006','kasirbip','1',' DP-02157BI','TOKO','BIPPSN','PSPRT-ZEBF-7-0','CINCIN PERAK SR-05 YL-01 ','','3.090','1','100.00','316000','0','0','17800','950000','0','0','0','950000','SULIS','00043797','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBF-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.090',berat_jual_asli=berat_jual_asli+'3.090',stock_jual='1',berat_akhir=berat_akhir-'3.090',berat_akhir_asli=berat_akhir_asli-'3.090',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPRT-ZEBF-7-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-260527-0006','2026-05-27','3.090','2026-05-27','18:11:13','PLG0011418','950000','950000','0','950000','0','kasirbip','2026-05-27 18:11:12','FJ-260527-0006','DP-02157','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0006','2026-05-27','18:11:13','SULIS','950000','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-260527-0006' LIMIT 1;
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-02244','PUT','1','PLD','WEDD RING CUSTOM','','','3.000','','25.00','1','1200000','550000','0','1000000','2650000','exspress 200.000 Sz 16.5','sirkon 27 crom putih gllosy sprti cntoh','grf Al-Maqi font vintage','0','270000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260527-0013','2026-05-27','2026-05-27 18:15:00','PESANAN : DP-02244','.','TBC','2336000','2336000');
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-260527-0014','D','2026-05-27','18:15:00','TBC','PESANAN','DP-02244','22874585514','2336000','22876921514','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-02244','2026-05-27','2026-05-27','18:15:00','PLG0011419','PUT','2026-06-08','kasirbip','2026-05-27 18:15:00','3.000','0','0','0','2336000','0','1000000','2920000','2920000','584000');
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-02245','VAN','1','PLD','WEDDING RING','','','2.500','','10.00','1','1200000','350000','0','950000','1825000','permata zircon 25 butir','size 14.5 gfr : Dwiky ?? Hesna (font vintage)','crom putih','250000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260527-0014','2026-05-27','2026-05-27 18:25:13','PESANAN : DP-02245','-','TBC','1400000','1400000');
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-260527-0015','D','2026-05-27','18:25:13','TBC','PESANAN','DP-02245','22876921514','1400000','22878321514','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-02245','2026-05-27','2026-05-27','18:25:13','PLG0011420','VAN','2026-06-24','sby','2026-05-27 18:25:13','2.500','0','0','0','1400000','0','950000','2075000','2075000','675000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','18:35:04');
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-02246','SAL','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 11 putih glosy doff semprot sepinggang 1 zirkon','grf Billy font Vintage rotter','','0','0','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-02246','SAL','2','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','sz 17.5 putih glossy doff semprot sepinggang','dibuat tanpa permata','grf Irma font vintage rotter','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-260527-0015','2026-05-27','2026-05-27 18:35:27','PESANAN : DP-02246','.','TBC','3160000','3160000');
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-260527-0016','D','2026-05-27','18:35:27','TBC','PESANAN','DP-02246','22878321514','3160000','22881481514','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-02246','2026-05-27','2026-05-27','18:35:27','PLG0011421','SAL','2026-06-27','kasirbip','2026-05-27 18:35:27','7.000','0','0','0','3160000','0','1500000','3950000','3950000','790000');
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-260527-0007','kasirbip','1',' DP-02216DU','TOKO','DUPSN','PSPRT-ZEBF-13-0','CINCIN PERAK SR-03 YL-01 ','','3.320','1','100.00','339000','0','0','17800','950000','0','0','0','950000','PUT','00043803','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBF-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPRT-ZEBF-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260527-0007','2026-05-27','3.320','2026-05-27','18:37:23','PLG0011422','950000','950000','0','950000','0','kasirbip','2026-05-27 18:37:22','FJ-260527-0007','DP-02216','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0007','2026-05-27','18:37:23','PUT','950000','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-260527-0007' LIMIT 1;
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-02247','VAN','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','permata zirkon 1','size:27 GRF: Hasna ?? Dwiky (vintage)','putih','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260527-0016','2026-05-27','2026-05-27 18:40:42','PESANAN : DP-02247','-','TBC','1500000','1500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260527-0017','D','2026-05-27','18:40:42','TBC','PESANAN','DP-02247','22881481514','1500000','22882981514','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-02247','2026-05-27','2026-05-27','18:40:42','PLG0011423','VAN','2026-06-24','sby','2026-05-27 18:40:42','4.000','0','0','0','1500000','0','750000','2160000','2160000','660000');
UPDATE th_user_login SET tgl_logout = '2026-05-27', jam_logout = '18:41:50' WHERE user_id = 'kasirbip' AND tgl_login = '2026-05-27' AND jam_login= '11:48:42';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-27 ','18:42:18');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0007';
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02246';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02246';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02246';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260527-0002','K','2026-05-27','18:43:53','Nagatech','PESANAN BATAL','DP-02246','194200','0','194200');
UPDATE th_user_login SET tgl_logout = '2026-05-27', jam_logout = '18:44:23' WHERE user_id = 'Nagatech' AND tgl_login = '2026-05-27' AND jam_login= '18:42:18';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-27 ','18:44:35');
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-02248','SAL','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 11 putih glosy doff semprot 1 zirkon','font vintage rotter grf Billy','','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-260527-0017','2026-05-27','2026-05-27 18:46:31','PESANAN : DP-02248','.','TBC','1440000','1440000');
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-260527-0018','D','2026-05-27','18:46:31','TBC','PESANAN','DP-02248','22882981514','1440000','22884421514','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-02248','2026-05-27','2026-05-27','18:46:31','PLG0011424','SAL','2026-06-27','kasirbip','2026-05-27 18:46:31','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-02249','SAL','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','sz 17.5 puitih glosy doff semprot','dibuat tanpa permata','grf Irma font vintage rotter','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-260527-0018','2026-05-27','2026-05-27 18:48:11','PESANAN : DP-02249','.','TBC','1720000','1720000');
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-260527-0019','D','2026-05-27','18:48:11','TBC','PESANAN','DP-02249','22884421514','1720000','22886141514','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-02249','2026-05-27','2026-05-27','18:48:11','PLG0011425','SAL','2026-06-27','kasirbip','2026-05-27 18:48:11','4.000','0','0','0','1720000','0','750000','2150000','2150000','430000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0006';
UPDATE tt_service_head SET tgl_selesai='2026-05-27',  status ='DONE' WHERE no_service='SV-02062';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02062';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-27',  status ='CLOS' WHERE no_service='SV-02062';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02062';
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-260527-0008','kasirbip','1',' 900K-105-2','TOKO','BIPPER','PBDG-ZEAB-55-0','CINCIN SILVER 925 ','','2.120','1','100.00','217000','0','0','17800','1000000','0','0','0','1000000','GIN','00043522','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEAB-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PBDG-ZEAB-55-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-260527-0008','2026-05-27','2.120','2026-05-27','19:36:21','PLG0011426','1000000','1000000','0','1000000','0','kasirbip','2026-05-27 19:36:20','FJ-260527-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0008','2026-05-27','19:36:21','GIN','1000000','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-260527-0019','2026-05-27','2026-05-27 19:36:20','PENJUALAN : FJ-260527-0008','.','TBC','1000000','1000000','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-260527-0020','D','2026-05-27','19:36:21','TBC','PENJUALAN','FJ-260527-0008','22886141514','1000000','22887141514','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='1000000' WHERE no_faktur_jual='FJ-260527-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260527-0009','kasirbip',' 1',' 700K-13-00','TOKO','BIPPER','LXPER-ZBAH-24-0','CINCIN SILVER 925 ','','1.760','1','100.00','180000','0','0','17800','800000','0','0','0','800000','GIN','00041642','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='LXPER-ZBAH-24-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-260527-0009','2026-05-27','1.760','2026-05-27','19:36:21','PLG0011427','800000','800000','0','800000','0','kasirbip','2026-05-27 19:36:20','FJ-260527-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0009','2026-05-27','19:36:21','GIN','800000','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-260527-0020','2026-05-27','2026-05-27 19:36:20','PENJUALAN : FJ-260527-0009','.','TBC','800000','800000','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-260527-0021','D','2026-05-27','19:36:21','TBC','PENJUALAN','FJ-260527-0009','22887141514','800000','22887941514','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='1800000' WHERE no_faktur_jual='FJ-260527-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0009';
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-260527-0010','kasirbip','1',' DP-01995BI','TOKO','BIPPSN','PSPLT-ZEAE-4-0','CINCIN PALADIUM ','','3.280','1','32.00','1386000','0','0','17800','2340000','0','0','0','2340000','GIN','00043571','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAE-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPLT-ZEAE-4-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-260527-0010','2026-05-27','3.280','2026-05-27','20:04:48','PLG0011428','2340000','2340000','0','2340000','0','kasirbip','2026-05-27 20:04:47','FJ-260527-0010','DP-01995','2160000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0010','2026-05-27','20:04:48','GIN','2340000','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-260527-0021','2026-05-27','2026-05-27 20:04:47','PENJUALAN : FJ-260527-0010','.','TBC','180000','180000','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-260527-0022','D','2026-05-27','20:04:48','TBC','PENJUALAN','FJ-260527-0010','22887941514','180000','22888121514','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='180000' WHERE no_faktur_jual='FJ-260527-0010' 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-260527-0011','kasirbip',' 1',' DP-01994BI','TOKO','BIPPSN','PSPLT-ZEBE-23-0','CINCIN PALADIUM ','','1.660','1','32.00','702000','0','0','17800','1750000','0','0','0','1750000','GIN','00043784','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBE-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPLT-ZEBE-23-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-260527-0011','2026-05-27','1.660','2026-05-27','20:04:48','PLG0011429','1750000','1750000','0','1750000','0','kasirbip','2026-05-27 20:04:47','FJ-260527-0010','DP-01994','1536000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0011','2026-05-27','20:04:48','GIN','1750000','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-260527-0022','2026-05-27','2026-05-27 20:04:47','PENJUALAN : FJ-260527-0011','.','TBC','214000','214000','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-260527-0023','D','2026-05-27','20:04:48','TBC','PENJUALAN','FJ-260527-0011','22888121514','214000','22888335514','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='394000' WHERE no_faktur_jual='FJ-260527-0011' 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-260527-0012','kasirbip','1',' DP-02212BI','TOKO','BIPPSN','PSPLT-ZEBF-11-0','CINCIN PALADIUM ','','2.970','1','17.00','667000','0','0','17800','2029000','0','0','0','2029000','KUR','00043801','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPLT-ZEBF-11-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-260527-0012','2026-05-27','2.970','2026-05-27','20:07:17','PLG0011430','2029000','2029000','0','2029000','0','kasirbip','2026-05-27 20:07:17','FJ-260527-0012','DP-02212','1630000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0012','2026-05-27','20:07:17','KUR','2029000','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-260527-0023','2026-05-27','2026-05-27 20:07:17','PENJUALAN : FJ-260527-0012','.','TBC','399000','399000','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-260527-0024','D','2026-05-27','20:07:17','TBC','PENJUALAN','FJ-260527-0012','22888335514','399000','22888734514','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='399000' WHERE no_faktur_jual='FJ-260527-0012' 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-260527-0013','kasirbip',' 1',' DP-02213BI','TOKO','BIPPSN','PSPLT-ZEBF-8-0','CINCIN PALADIUM ','','4.080','1','17.00','916000','0','0','17800','2178000','0','0','0','2178000','KUR','00043798','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBF-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.080',berat_jual_asli=berat_jual_asli+'4.080',stock_jual='1',berat_akhir=berat_akhir-'4.080',berat_akhir_asli=berat_akhir_asli-'4.080',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPLT-ZEBF-8-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-260527-0013','2026-05-27','4.080','2026-05-27','20:07:17','PLG0011431','2178000','2178000','0','2178000','0','kasirbip','2026-05-27 20:07:17','FJ-260527-0012','DP-02213','1720000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0013','2026-05-27','20:07:17','KUR','2178000','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-260527-0024','2026-05-27','2026-05-27 20:07:17','PENJUALAN : FJ-260527-0013','.','TBC','458000','458000','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-260527-0025','D','2026-05-27','20:07:17','TBC','PENJUALAN','FJ-260527-0013','22888734514','458000','22889192514','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='857000' WHERE no_faktur_jual='FJ-260527-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0013';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','20:16:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','20:26:45');
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-260527-0014','kasirbip','1',' DP-02130BI','TOKO','BIPPSN','PSPRT-ZEBX-30-0','CINCIN PERAK SR-03 YL-01 ','','3.340','1','100.00','341000','0','0','17800','950000','0','0','0','950000','SULIS','00043675','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBX-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.340',berat_jual_asli=berat_jual_asli+'3.340',stock_jual='1',berat_akhir=berat_akhir-'3.340',berat_akhir_asli=berat_akhir_asli-'3.340',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='PSPRT-ZEBX-30-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-260527-0014','2026-05-27','3.340','2026-05-27','20:56:34','PLG0011432','950000','950000','0','950000','0','kasirbip','2026-05-27 20:56:34','FJ-260527-0014','DP-02130','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','FJ-260527-0014','2026-05-27','20:56:34','SULIS','950000','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-260527-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260527-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260527-0014';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','21:11:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','21:29:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-27 ','21:44:47');