INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-22 ','08:01:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-22 ','08:16:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-22 ','08:28:41');
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-20260922-0001','1','PSPLT-ZIBA-21-0','1','4.960','4.960','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-09-22 08:28:56' WHERE kode_barang='PSPLT-ZIBA-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-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-09-22 08:28:56','TOKO','MMPSN','PSPLT','PSPLT-ZIBA-21-0','1','4.960','4.960','1','4.960','4.960','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-ZIBA-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0001','1','PSPRT-ZIBA-22-0','1','2.440','2.440','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-09-22 08:28:56' WHERE kode_barang='PSPRT-ZIBA-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 08:28:56','TOKO','MMPSN','PSPRT','PSPRT-ZIBA-22-0','1','2.440','2.440','1','2.440','2.440','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-ZIBA-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0001','1','PSPLT-ZIBA-23-0','1','4.610','4.610','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-09-22 08:28:56' WHERE kode_barang='PSPLT-ZIBA-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-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-09-22 08:28:56','TOKO','MMPSN','PSPLT','PSPLT-ZIBA-23-0','1','4.610','4.610','1','4.610','4.610','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-ZIBA-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260922-0001','2026-09-22','08:28','12.010','kasir','2026-09-22 08:28:56');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-22 ','09:04:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-22 ','09:56:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','09:59:06');
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-260922-0001','kasirbip','1',' DP-03578DU','TOKO','DUPSN','PSPRT-ZIAH-28-0','1PS CINCIN PERAK ','','3.970','1','100.00','405000','0','0','17800','1500000','0','0','0','1500000','PUT','00047357','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.970',berat_jual_asli=berat_jual_asli+'3.970',stock_jual='1',berat_akhir=berat_akhir-'3.970',berat_akhir_asli=berat_akhir_asli-'3.970',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPRT-ZIAH-28-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-260922-0001','2026-09-22','3.970','2026-09-22','10:21:22','PLG0016224','1500000','1500000','0','1500000','0','kasirbip','2026-09-22 10:21:22','FJ-260922-0001','DP-03578','1500000');
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-09-22','FJ-260922-0001','2026-09-22','10:21:22','PUT','1500000','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-260922-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','10:26:15');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','10:37:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260922-0002','1','PSPRT-ZIBA-15-0','1','4.260','4.260','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPRT-ZIBA-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 10:37:36','TOKO','DUPSN','PSPRT','PSPRT-ZIBA-15-0','1','4.260','4.260','1','4.260','4.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIBA-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSGT-ZIBA-16-0','1','2.600','2.600','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBA-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBA-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBA-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSGT-ZIBA-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBA-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-09-22 10:37:36','TOKO','DUPSN','PSGT','PSGT-ZIBA-16-0','1','2.600','2.600','1','2.600','2.600','57.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-ZIBA-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPRT-ZIBA-17-0','1','1.450','1.450','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPRT-ZIBA-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 10:37:36','TOKO','DUPSN','PSPRT','PSPRT-ZIBA-17-0','1','1.450','1.450','1','1.450','1.450','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-ZIBA-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPRT-ZIBA-18-0','1','1.800','1.800','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPRT-ZIBA-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 10:37:36','TOKO','DUPSN','PSPRT','PSPRT-ZIBA-18-0','1','1.800','1.800','1','1.800','1.800','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-ZIBA-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPRT-ZIBA-19-0','1','1.660','1.660','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPRT-ZIBA-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 10:37:36','TOKO','DUPSN','PSPRT','PSPRT-ZIBA-19-0','1','1.660','1.660','1','1.660','1.660','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-ZIBA-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPLT-ZIBA-28-0','1','3.110','3.110','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPLT-ZIBA-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 10:37:36','TOKO','DUPSN','PSPLT','PSPLT-ZIBA-28-0','1','3.110','3.110','1','3.110','3.110','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-ZIBA-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPLT-ZIBA-29-0','1','2.470','2.470','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPLT-ZIBA-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 10:37:36','TOKO','DUPSN','PSPLT','PSPLT-ZIBA-29-0','1','2.470','2.470','1','2.470','2.470','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-ZIBA-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPLT-ZIBA-30-0','1','2.710','2.710','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPLT-ZIBA-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 10:37:36','TOKO','DUPSN','PSPLT','PSPLT-ZIBA-30-0','1','2.710','2.710','1','2.710','2.710','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-ZIBA-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPLT-ZIBA-31-0','1','1.560','1.560','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPLT-ZIBA-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 10:37:36','TOKO','DUPSN','PSPLT','PSPLT-ZIBA-31-0','1','1.560','1.560','1','1.560','1.560','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-ZIBA-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0002','1','PSPRT-ZIBA-32-0','1','4.100','4.100','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-22 10:37:36' WHERE kode_barang='PSPRT-ZIBA-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 10:37:36','TOKO','DUPSN','PSPRT','PSPRT-ZIBA-32-0','1','4.100','4.100','1','4.100','4.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-ZIBA-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260922-0002','2026-09-22','10:35','25.720','kasirbip','2026-09-22 10:37: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-04174','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 18 putih doff semprot','model persis sprt contoh','font & grf menyusul','','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260922-0001','2026-09-22','2026-09-22 10:39:55','PESANAN : DP-04174','.','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-260922-0002','D','2026-09-22','10:39:55','TBC','PESANAN','DP-04174','28149048464','900000','28149948464','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-04174','2026-09-22','2026-09-22','10:39:55','PLG0016225','SAL','2026-10-15','kasirbip','2026-09-22 10:39:55','2.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-04175','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz 13 putih glossy 14 zirkon','model persis sprt contoh','font & grf menysul','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260922-0002','2026-09-22','2026-09-22 10:42:22','PESANAN : DP-04175','.','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-260922-0003','D','2026-09-22','10:42:22','TBC','PESANAN','DP-04175','28149948464','950000','28150898464','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-04175','2026-09-22','2026-09-22','10:42:22','PLG0016226','SAL','2026-10-15','kasirbip','2026-09-22 10:42:22','2.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','11:02:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-22 ','11:37:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-22 ','11:37:47');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-22 ','11:43:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','11:43:52');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260922-0003','1','PSPRT-ZIBA-6-0','1','3.750','3.750','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-6-0','1','3.750','3.750','1','3.750','3.750','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-ZIBA-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-7-0','1','5.160','5.160','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-7-0','1','5.160','5.160','1','5.160','5.160','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-ZIBA-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-8-0','1','2.130','2.130','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-8-0','1','2.130','2.130','1','2.130','2.130','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-ZIBA-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-9-0','1','1.850','1.850','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-9-0','1','1.850','1.850','1','1.850','1.850','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-ZIBA-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-10-0','1','3.190','3.190','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-10-0','1','3.190','3.190','1','3.190','3.190','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-ZIBA-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-11-0','1','3.180','3.180','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-11-0','1','3.180','3.180','1','3.180','3.180','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-ZIBA-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-12-0','1','3.490','3.490','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-12-0','1','3.490','3.490','1','3.490','3.490','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-ZIBA-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-13-0','1','3.640','3.640','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-13-0','1','3.640','3.640','1','3.640','3.640','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-ZIBA-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPRT-ZIBA-14-0','1','3.360','3.360','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIBA-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIBA-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIBA-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPRT-ZIBA-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPRT','PSPRT-ZIBA-14-0','1','3.360','3.360','1','3.360','3.360','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-ZIBA-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIBA-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPLT-ZIBA-20-0','1','1.650','1.650','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPLT-ZIBA-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-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-09-22 12:12:45','TOKO','BIPPSN','PSPLT','PSPLT-ZIBA-20-0','1','1.650','1.650','1','1.650','1.650','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-ZIBA-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPLT-ZIBA-24-0','1','2.390','2.390','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPLT-ZIBA-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 12:12:45','TOKO','BIPPSN','PSPLT','PSPLT-ZIBA-24-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-ZIBA-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' 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-20260922-0003','1','PSPLT-ZIBA-25-0','1','4.520','4.520','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-22 12:12:45' WHERE kode_barang='PSPLT-ZIBA-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 12:12:45','TOKO','BIPPSN','PSPLT','PSPLT-ZIBA-25-0','1','4.520','4.520','1','4.520','4.520','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-ZIBA-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260922-0003','2026-09-22','12:12','38.310','kasirbip','2026-09-22 12:12:44');
UPDATE tt_service_head SET tgl_selesai='2026-09-22',  status ='DONE' WHERE no_service='SV-02249';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02249';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-22 ','12:20:38');
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-09-22',  status ='CLOS' WHERE no_service='SV-02247';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02247';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','14:04:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','14:06:44');
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-260922-0002','kasirbip','1',' DP-03731DU','TOKO','DUPSN','PSPRT-ZIAH-38-0','CINCIN PERAK ','','3.270','1','100.00','334000','0','0','17800','850000','0','0','0','850000','NAD','00047367','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPRT-ZIAH-38-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-260922-0002','2026-09-22','3.270','2026-09-22','14:07:54','PLG0016227','850000','850000','0','850000','0','kasirbip','2026-09-22 14:07:54','FJ-260922-0002','DP-03731','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-09-22','FJ-260922-0002','2026-09-22','14:07:54','NAD','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-260922-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-260922-0003','kasirbip',' 1',' DP-03732DU','TOKO','DUPSN','PSPRT-ZIBA-19-0','CINCIN PERAK ','','1.660','1','100.00','170000','0','0','17800','900000','0','0','0','900000','NAD','00047417','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBA-19-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-09-22' AND kode_barang='PSPRT-ZIBA-19-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-260922-0003','2026-09-22','1.660','2026-09-22','14:07:54','PLG0016228','900000','900000','0','900000','0','kasirbip','2026-09-22 14:07:54','FJ-260922-0002','DP-03732','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-22','FJ-260922-0003','2026-09-22','14:07:54','NAD','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260922-0003' 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-260922-0004','kasirbip','1',' 750K-11 ','TOKO','DUCM','LXCM-ZIXH-28-0','CINCIN EMAS ','','1.240','1','45.00','1367000','0','0','17800','2486000','0','0','0','2486000','PUT','00047041','LXCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXCM-ZIXH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='LXCM-ZIXH-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUCM' 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-260922-0004','2026-09-22','1.240','2026-09-22','14:22:51','PLG0016229','2486000','2486000','0','2486000','0','kasirbip','2026-09-22 14:22:51','FJ-260922-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-09-22','FJ-260922-0004','2026-09-22','14:22:51','PUT','2486000','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-260922-0003','2026-09-22','2026-09-22 14:22:51','PENJUALAN : FJ-260922-0004','.','TBC','2486000','2486000','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-260922-0004','D','2026-09-22','14:22:51','TBC','PENJUALAN','FJ-260922-0004','28150898464','2486000','28153384464','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='2486000' WHERE no_faktur_jual='FJ-260922-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0004';
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-04176','KUR','1','PER','CINCIN KAWIN','','','2.000','','925.00','1','100000','0','900000','0','900000','size 14 grf Riri & Alfian','putih dof semprot sirkon 1','font berkshire swash','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-260922-0004','2026-09-22','2026-09-22 14:58:00','PESANAN : DP-04176','.','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-260922-0005','D','2026-09-22','14:58:00','TBC','PESANAN','DP-04176','28153384464','900000','28154284464','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-04176','2026-09-22','2026-09-22','14:58:00','PLG0016230','KUR','2026-10-15','kasirbip','2026-09-22 14:58:00','2.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-04177','PUT','1','PER','WEDRING','','','1.700','','925.00','1','100000','0','900000','0','900000','sz cwo 24.5 crom putih doff semprot','grf Syifa font Berkshire','','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-260922-0005','2026-09-22','2026-09-22 15:20:06','PESANAN : DP-04177','.','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-260922-0006','D','2026-09-22','15:20:06','TBC','PESANAN','DP-04177','28154284464','900000','28155184464','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-04177','2026-09-22','2026-09-22','15:20:06','PLG0016231','PUT','2026-10-20','kasirbip','2026-09-22 15:20:06','1.700','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-04178','PUY','1','PER','WEDRING','','','1.600','','925.00','1','100000','0','850000','0','850000','sz cwe 13 crom putih glosy','grf Fiqri font Berkshire','','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-260922-0006','2026-09-22','2026-09-22 15:22:30','PESANAN : DP-04178','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260922-0007','D','2026-09-22','15:22:30','TBC','PESANAN','DP-04178','28155184464','850000','28156034464','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-04178','2026-09-22','2026-09-22','15:22:30','PLG0016232','PUY','2026-10-10','kasirbip','2026-09-22 15:22:30','1.600','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','15:22:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','15:23: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-04179','PUT','1','PER','WEDRING','','','1.700','','925.00','1','100000','0','850000','0','850000','sz cwe 13 crom putih glosy','grf Fiqri font Berkshire','','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-260922-0007','2026-09-22','2026-09-22 15:24:32','PESANAN : DP-04179','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260922-0008','D','2026-09-22','15:24:32','TBC','PESANAN','DP-04179','28156034464','850000','28156884464','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-04179','2026-09-22','2026-09-22','15:24:32','PLG0016233','PUT','2026-10-10','kasirbip','2026-09-22 15:24:32','1.700','0','0','0','850000','0','0','850000','850000','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-04180','NAD','1','GOLD','WEDRING','','','2.000','','9.00','1','2300000','1400000','0','700000','3500000','size 13.5 crom putih doff semprot','EXPRESS 100.000','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260922-0008','2026-09-22','2026-09-22 15:27:40','PESANAN : DP-04180','.','TBC','2800000','2800000');
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-260922-0009','D','2026-09-22','15:27:40','TBC','PESANAN','DP-04180','28156884464','2800000','28159684464','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-04180','2026-09-22','2026-09-22','15:27:40','PLG0016234','NAD','2026-09-30','kasirbip','2026-09-22 15:27:40','2.000','0','0','0','2800000','0','700000','3500000','3500000','700000');
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-04181','NAD','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','size 16 crom putih doff semprot','Grf Billal .... Herviena Font Vladimir','EXPRESS 100.000','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-260922-0009','2026-09-22','2026-09-22 15:31:48','PESANAN : DP-04181','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260922-0010','D','2026-09-22','15:31:48','TBC','PESANAN','DP-04181','28159684464','850000','28160534464','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-04181','2026-09-22','2026-09-22','15:31:48','PLG0016235','NAD','2026-09-30','kasirbip','2026-09-22 15:31:48','3.000','0','0','0','850000','0','0','850000','850000','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-04182','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','cwo YL-01 sz 17 grf Melda 261026','cwe SR-04 sz 12 grf Firman 261026','font keduanya brush script','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260922-0010','2026-09-22','2026-09-22 15:37:29','PESANAN : DP-04182','.','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-260922-0011','D','2026-09-22','15:37:29','TBC','PESANAN','DP-04182','28160534464','950000','28161484464','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-04182','2026-09-22','2026-09-22','15:37:29','PLG0016236','KUR','2026-10-13','kasirbip','2026-09-22 15:37:29','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-04178';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-04178';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-04178';
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-260922-0002','K','2026-09-22','15:45:58','kasirbip','PESANAN BATAL','DP-04178','4140500','0','4140500');
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-260922-0005','kasirbip','1',' DP-03612DU','TOKO','DUPSN','PSPRT-ZIBA-32-0','1PS CINCIN PERAK ','','4.100','1','100.00','419000','0','0','17800','1200000','0','0','0','1200000','NAD','00047430','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBA-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.100',berat_jual_asli=berat_jual_asli+'4.100',stock_jual='1',berat_akhir=berat_akhir-'4.100',berat_akhir_asli=berat_akhir_asli-'4.100',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPRT-ZIBA-32-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-260922-0005','2026-09-22','4.100','2026-09-22','15:47:44','PLG0016237','1200000','1200000','0','1200000','0','kasirbip','2026-09-22 15:47:44','FJ-260922-0005','DP-03612','1200000');
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-09-22','FJ-260922-0005','2026-09-22','15:47:44','NAD','1200000','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-260922-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0005';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260922-0006','kasirbip','1',' DP-03101DU','TOKO','DUPSN','PSPLT-ZHBA-11-0','CINCIN PALADIUM ','','4.160','1','32.00','1758000','0','0','17800','3138000','0','0','0','3138000','PUT','00046297','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.160',berat_jual_asli=berat_jual_asli+'4.160',stock_jual='1',berat_akhir=berat_akhir-'4.160',berat_akhir_asli=berat_akhir_asli-'4.160',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPLT-ZHBA-11-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-260922-0006','2026-09-22','4.160','2026-09-22','17:16:45','PLG0016238','3138000','3138000','0','3138000','0','kasirbip','2026-09-22 17:16:45','FJ-260922-0006','DP-03101','2440000');
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-09-22','FJ-260922-0006','2026-09-22','17:16:45','PUT','3138000','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-260922-0011','2026-09-22','2026-09-22 17:16:45','PENJUALAN : FJ-260922-0006','.','TBC','698000','698000','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-260922-0012','D','2026-09-22','17:16:45','TBC','PENJUALAN','FJ-260922-0006','28161484464','698000','28162182464','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='698000' WHERE no_faktur_jual='FJ-260922-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260922-0007','kasirbip',' 1',' DP-03102DU','TOKO','DUPSN','PSPLT-ZHBA-10-0','CINCIN PALADIUM ','','3.150','1','32.00','1331000','0','0','17800','2482500','0','0','0','2482500','PUT','00046296','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPLT-ZHBA-10-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-260922-0007','2026-09-22','3.150','2026-09-22','17:16:45','PLG0016239','2482500','2482500','0','2482500','0','kasirbip','2026-09-22 17:16:45','FJ-260922-0006','DP-03102','2140000');
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-09-22','FJ-260922-0007','2026-09-22','17:16:45','PUT','2482500','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-260922-0012','2026-09-22','2026-09-22 17:16:45','PENJUALAN : FJ-260922-0007','.','TBC','342500','342500','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-260922-0013','D','2026-09-22','17:16:45','TBC','PENJUALAN','FJ-260922-0007','28162182464','342500','28162524964','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='1040500' WHERE no_faktur_jual='FJ-260922-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-04183','NAD','1','GOLD','WEDRING','','','2.000','','9.00','1','2300000','1400000','0','750000','3550000','size 14.5 crom putih glossy','Grf AL . W Font Berkshire','','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-260922-0013','2026-09-22','2026-09-22 17:27:36','PESANAN : DP-04183','.','TBC','2840000','2840000');
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-260922-0014','D','2026-09-22','17:27:36','TBC','PESANAN','DP-04183','28162524964','2840000','28165364964','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-04183','2026-09-22','2026-09-22','17:27:36','PLG0016240','NAD','2026-10-20','kasirbip','2026-09-22 17:27:36','2.000','0','0','0','2840000','0','750000','3550000','3550000','710000');
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-04184','NAD','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','900000','0','900000','size 19 crom putih doff amplas','Grf AL . W Font Berkshire','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260922-0014','2026-09-22','2026-09-22 17:29:30','PESANAN : DP-04184','.','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-260922-0015','D','2026-09-22','17:29:30','TBC','PESANAN','DP-04184','28165364964','900000','28166264964','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-04184','2026-09-22','2026-09-22','17:29:30','PLG0016241','NAD','2026-10-20','kasirbip','2026-09-22 17:29:30','3.000','0','0','0','900000','0','0','900000','900000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-22 ','17:45:34');
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-20260922-0004','1','PSGT-ZIBA-33-0','1','3.470','3.470','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBA-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBA-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBA-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-22 17:48:03' WHERE kode_barang='PSGT-ZIBA-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBA-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-22 17:48:03','TOKO','SBYPSN','PSGT','PSGT-ZIBA-33-0','1','3.470','3.470','1','3.470','3.470','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-ZIBA-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-22' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260922-0004','2026-09-22','17:46','3.470','sby','2026-09-22 17:48:03');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02257','SAL','1','CCN PALADIUM','REPARASI CCN BENGKOK PASANG 1 MATA KROM PUTIH GLOSSY GRF JGN HILANG','2.500','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260922-0015','2026-09-22','2026-09-22 18:03:06','SERVICE : SV-02257','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260922-0016','D','2026-09-22','18:03:06','TBC','SERVICE','SV-02257','28166264964','50000','28166314964','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02257','2026-09-22','2026-09-22','18:03:06','PLG0016242','kasirbip','2026-10-08','kasirbip','2026-09-22 18:03:06','2.500','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-22 ','18:03:28');
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-09-22',  status ='CLOS' WHERE no_service='SV-02249';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02249';
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-260922-0008','kasirbip','1',' DP-03874BI','TOKO','BIPPSN','PSPLT-ZIBA-25-0','CINCIN PALADIUM ','','4.520','1','17.00','1015000','0','0','17800','2382000','0','0','0','2382000','SAL','00047423','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBA-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.520',berat_jual_asli=berat_jual_asli+'4.520',stock_jual='1',berat_akhir=berat_akhir-'4.520',berat_akhir_asli=berat_akhir_asli-'4.520',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPLT-ZIBA-25-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-260922-0008','2026-09-22','4.520','2026-09-22','18:09:48','PLG0016243','2382000','2382000','0','2382000','0','kasirbip','2026-09-22 18:09:48','FJ-260922-0008','DP-03874','2040000');
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-09-22','FJ-260922-0008','2026-09-22','18:09:48','SAL','2382000','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-260922-0016','2026-09-22','2026-09-22 18:09:48','PENJUALAN : FJ-260922-0008','.','TBC','342000','342000','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-260922-0017','D','2026-09-22','18:09:48','TBC','PENJUALAN','FJ-260922-0008','28166314964','342000','28166656964','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='342000' WHERE no_faktur_jual='FJ-260922-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-260922-0009','kasirbip',' 1',' DP-03875BI','TOKO','BIPPSN','PSPLT-ZIBA-24-0','CINCIN PALADIUM ','','2.390','1','17.00','537000','0','0','17800','1756500','0','0','0','1756500','SAL','00047422','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPLT-ZIBA-24-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-260922-0009','2026-09-22','2.390','2026-09-22','18:09:48','PLG0016244','1756500','1756500','0','1756500','0','kasirbip','2026-09-22 18:09:48','FJ-260922-0008','DP-03875','1296000');
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-09-22','FJ-260922-0009','2026-09-22','18:09:48','SAL','1756500','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-260922-0017','2026-09-22','2026-09-22 18:09:48','PENJUALAN : FJ-260922-0009','.','TBC','460500','460500','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-260922-0018','D','2026-09-22','18:09:48','TBC','PENJUALAN','FJ-260922-0009','28166656964','460500','28167117464','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='802500' WHERE no_faktur_jual='FJ-260922-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-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-260922-0010','kasirbip','1',' DP-03796BI','TOKO','BIPPSN','PSPRT-ZIBA-13-0','CINCIN PERAK SR05 YL01 ','','3.640','1','100.00','372000','0','0','17800','950000','0','0','0','950000','SULIS','00047411','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBA-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.640',berat_jual_asli=berat_jual_asli+'3.640',stock_jual='1',berat_akhir=berat_akhir-'3.640',berat_akhir_asli=berat_akhir_asli-'3.640',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPRT-ZIBA-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260922-0010','2026-09-22','3.640','2026-09-22','18:20:25','PLG0016245','950000','950000','0','950000','0','kasirbip','2026-09-22 18:20:24','FJ-260922-0010','DP-03796','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-09-22','FJ-260922-0010','2026-09-22','18:20:25','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-260922-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0010';
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-260922-0011','kasirbip','1',' DP-03963BI','TOKO','BIPPSN','PSPLT-ZIBA-20-0','CINCIN PALADIUM YL01 ','','1.650','1','17.00','371000','0','0','17800','1177500','0','0','0','1177500','KUR','00047418','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBA-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPLT-ZIBA-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260922-0011','2026-09-22','1.650','2026-09-22','18:48:07','PLG0016246','1177500','1177500','0','1177500','0','kasirbip','2026-09-22 18:48:06','FJ-260922-0011','DP-03963','1040000');
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-09-22','FJ-260922-0011','2026-09-22','18:48:07','KUR','1177500','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-260922-0018','2026-09-22','2026-09-22 18:48:06','PENJUALAN : FJ-260922-0011','.','TBC','137500','137500','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-260922-0019','D','2026-09-22','18:48:07','TBC','PENJUALAN','FJ-260922-0011','28167117464','137500','28167254964','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='137500' WHERE no_faktur_jual='FJ-260922-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0011';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-22 ','19:00:43');
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-260922-0012','kasirbip','1',' 1.2K-12-29','TOKO','BIPPER','PBDG-ZHCA-49-0','CINCIN SILVER 925 ','','2.090','1','100.00','214000','0','0','17800','1300000','0','0','0','1300000','KUR','00046741','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHCA-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PBDG-ZHCA-49-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-260922-0012','2026-09-22','2.090','2026-09-22','19:59:19','PLG0016247','1300000','1300000','0','1300000','0','kasirbip','2026-09-22 19:59:18','FJ-260922-0012','','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-09-22','FJ-260922-0012','2026-09-22','19:59:19','KUR','1300000','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-260922-0019','2026-09-22','2026-09-22 19:59:18','PENJUALAN : FJ-260922-0012','.','TBC','1300000','1300000','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-260922-0020','D','2026-09-22','19:59:19','TBC','PENJUALAN','FJ-260922-0012','28167254964','1300000','28168554964','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='1300000' WHERE no_faktur_jual='FJ-260922-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0012';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-22 ','20:00:25');
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-04185','ADL','1','PLD','WEDDING RING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz cwo 15 mix yellowgoldsilver','ukirnama fn Yeseva : Dito..Dinda','YL10 express','0','0','200000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260922-0020','2026-09-22','2026-09-22 20:06:34','PESANAN : DP-04185','-','TBC','1680000','1680000');
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-260922-0021','D','2026-09-22','20:06:34','TBC','PESANAN','DP-04185','28168554964','1680000','28170234964','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-04185','2026-09-22','2026-09-22','20:06:34','PLG0016248','ADL','2026-09-25','jogja','2026-09-22 20:06:34','3.000','0','0','0','1680000','0','800000','2050000','2050000','370000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-22 ','20:13:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-22 ','20:14:07');
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-260922-0013','sby','1',' DP-03610SB','TOKO','SBYPSN','PSPLT-ZIAD-34-0','CINCIN PALADIUM ','','4.030','1','57.00','3033000','0','0','17800','4730000','0','0','0','4730000','DIL','00047200','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAD-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSPLT-ZIAD-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260922-0013','2026-09-22','4.030','2026-09-22','20:15:47','PLG0016249','4730000','4730000','0','4730000','0','sby','2026-09-22 20:15:46','FJ-260922-0013','DP-03610','3500000');
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-09-22','FJ-260922-0013','2026-09-22','20:15:47','DIL','4730000','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-260922-0021','2026-09-22','2026-09-22 20:15:46','PENJUALAN : FJ-260922-0013','','TBC','1230000','1230000','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-260922-0022','D','2026-09-22','20:15:47','TBC','PENJUALAN','FJ-260922-0013','28170234964','1230000','28171464964','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='1230000' WHERE no_faktur_jual='FJ-260922-0013' 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-260922-0014','sby','1',' DP-03611SB','TOKO','SBYPSN','PSGT-ZIAE-23-0','CINCIN EMAS ','','2.820','1','83.00','5730000','0','0','17800','7385000','0','0','0','7385000','DIL','00047232','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIAE-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.820',berat_jual_asli=berat_jual_asli+'2.820',stock_jual='1',berat_akhir=berat_akhir-'2.820',berat_akhir_asli=berat_akhir_asli-'2.820',stock_akhir='0' WHERE tanggal='2026-09-22' AND kode_barang='PSGT-ZIAE-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260922-0014','2026-09-22','2.820','2026-09-22','20:17:08','PLG0016250','7385000','7385000','0','7385000','0','sby','2026-09-22 20:17:07','FJ-260922-0014','DP-03611','4500000');
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-09-22','FJ-260922-0014','2026-09-22','20:17:08','DIL','7385000','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-260922-0022','2026-09-22','2026-09-22 20:17:07','PENJUALAN : FJ-260922-0014','','TBC','2885000','2885000','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-260922-0023','D','2026-09-22','20:17:08','TBC','PENJUALAN','FJ-260922-0014','28171464964','2885000','28174349964','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='2885000' WHERE no_faktur_jual='FJ-260922-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260922-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260922-0014';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-22';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','TBC','SALDO AWAL','SALDO AWAL','0','28174349964','28174349964');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','','SALDO AWAL','SALDO AWAL','0','250000','250000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260923-0001','D','2026-09-23','21:03:56','BCD','SALDO AWAL','SALDO AWAL','0','1461269500','1461269500');
UPDATE tp_system SET tgl_system='2026-09-23';
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-04186','DIL','1','PLD','WEDD RING PRIA','','','4.500','','25.00','1','1200000','550000','0','700000','3175000','SIZE 21 GRF: Tika (INFINITY) Candra (VINTAGE)','PUTIH GLOSSY MIX DOFF','','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-260922-0023','2026-09-22','2026-09-22 21:05:10','PESANAN : DP-04186','-','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-260922-0001','D','2026-09-22','21:05:10','TBC','PESANAN','DP-04186','0','1800000','1800000','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-04186','2026-09-22','2026-09-22','21:05:10','PLG0016251','DIL','2026-10-17','sby','2026-09-22 21:05:10','4.500','0','0','0','1800000','0','700000','3175000','3175000','1375000');
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-04187','DIL','1','PLD','WEDD RING WANITA','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','PERMATA 5 BUTIR','SIZE 13 GRF: Candra (INFINITY) Tika (VINTAGE)','PUTIH GLOSSY','50000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260922-0024','2026-09-22','2026-09-22 21:07:27','PESANAN : DP-04187','-','TBC','1200000','1200000');
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-260922-0002','D','2026-09-22','21:07:27','TBC','PESANAN','DP-04187','1800000','1200000','3000000','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-04187','2026-09-22','2026-09-22','21:07:27','PLG0016252','DIL','2026-10-17','sby','2026-09-22 21:07:27','3.000','0','0','0','1200000','0','800000','1900000','1900000','700000');