INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-07 ','08:42:08');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260807-0001','1','PSPLT-ZHXF-12-0','1','2.590','2.590','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZHXF-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZHXF-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZHXF-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-07 08:42:24' WHERE kode_barang='PSPLT-ZHXF-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZHXF-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-08-07 08:42:24','TOKO','MMPSN','PSPLT','PSPLT-ZHXF-12-0','1','2.590','2.590','1','2.590','2.590','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-ZHXF-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0001','1','PSPRT-ZHXF-13-0','1','6.770','6.770','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-07 08:42:24' WHERE kode_barang='PSPRT-ZHXF-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-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-08-07 08:42:24','TOKO','MMPSN','PSPRT','PSPRT-ZHXF-13-0','1','6.770','6.770','1','6.770','6.770','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-ZHXF-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0001','2026-08-07','08:42','9.360','kasir','2026-08-07 08:42:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-07 ','11:00:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-07 ','11:43:38');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02207','KUR','1','CINCIN SILVER','PASANG 1 MATA KROM PUTIH DOFF SEMPROT GRF JGN HILANG','2.000','1','60000','60000');
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-260807-0001','2026-08-07','2026-08-07 11:45:51','SERVICE : SV-02207','.','TBC','60000','60000','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-260807-0002','D','2026-08-07','11:45:51','TBC','SERVICE','SV-02207','25842965064','60000','25843025064','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-02207','2026-08-07','2026-08-07','11:45:51','PLG0014105','kasirbip','2026-08-20','kasirbip','2026-08-07 11:45:51','2.000','0','0','0','60000','0','60000','60000','0');
UPDATE tt_service_head SET tgl_selesai='2026-08-07',  status ='DONE' WHERE no_service='SV-02198';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02198';
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-20260807-0002','1','PSPRT-ZHXF-14-0','1','1.310','1.310','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPRT-ZHXF-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-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-08-07 12:01:40','TOKO','BIPPSN','PSPRT','PSPRT-ZHXF-14-0','1','1.310','1.310','1','1.310','1.310','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-ZHXF-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPLT-ZHXF-15-0','1','2.190','2.190','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZHXF-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZHXF-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZHXF-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPLT-ZHXF-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZHXF-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-08-07 12:01:40','TOKO','BIPPSN','PSPLT','PSPLT-ZHXF-15-0','1','2.190','2.190','1','2.190','2.190','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-ZHXF-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPRT-ZHXF-16-0','1','2.010','2.010','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPRT-ZHXF-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-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-08-07 12:01:40','TOKO','BIPPSN','PSPRT','PSPRT-ZHXF-16-0','1','2.010','2.010','1','2.010','2.010','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-ZHXF-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPRT-ZHXF-17-0','1','1.380','1.380','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPRT-ZHXF-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-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-08-07 12:01:40','TOKO','BIPPSN','PSPRT','PSPRT-ZHXF-17-0','1','1.380','1.380','1','1.380','1.380','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-ZHXF-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSGT-ZHXF-37-0','1','3.570','3.570','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZHXF-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZHXF-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZHXF-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZHXF-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSGT-ZHXF-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZHXF-37-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:01:40','TOKO','BIPPSN','PSGT','PSGT-ZHXF-37-0','1','3.570','3.570','1','3.570','3.570','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-ZHXF-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZHXF-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSGT-ZHXF-38-0','1','3.090','3.090','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZHXF-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZHXF-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZHXF-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZHXF-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSGT-ZHXF-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZHXF-38-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:01:40','TOKO','BIPPSN','PSGT','PSGT-ZHXF-38-0','1','3.090','3.090','1','3.090','3.090','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-ZHXF-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZHXF-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPRT-ZHXF-39-0','1','2.790','2.790','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPRT-ZHXF-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-39-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:01:40','TOKO','BIPPSN','PSPRT','PSPRT-ZHXF-39-0','1','2.790','2.790','1','2.790','2.790','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-ZHXF-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPLT-ZHXF-41-0','1','2.370','2.370','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZHXF-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZHXF-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZHXF-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPLT-ZHXF-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZHXF-41-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:01:40','TOKO','BIPPSN','PSPLT','PSPLT-ZHXF-41-0','1','2.370','2.370','1','2.370','2.370','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZHXF-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-41-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPRT-ZHXF-42-0','1','3.450','3.450','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPRT-ZHXF-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-42-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:01:40','TOKO','BIPPSN','PSPRT','PSPRT-ZHXF-42-0','1','3.450','3.450','1','3.450','3.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-ZHXF-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPRT-ZHXF-43-0','1','3.390','3.390','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPRT-ZHXF-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-43-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:01:40','TOKO','BIPPSN','PSPRT','PSPRT-ZHXF-43-0','1','3.390','3.390','1','3.390','3.390','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-ZHXF-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0002','1','PSPLT-ZHXF-44-0','1','3.000','3.000','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZHXF-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZHXF-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZHXF-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-08-07 12:01:40' WHERE kode_barang='PSPLT-ZHXF-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZHXF-44-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:01:40','TOKO','BIPPSN','PSPLT','PSPLT-ZHXF-44-0','1','3.000','3.000','1','3.000','3.000','57.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZHXF-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0002','2026-08-07','12:01','28.550','kasirbip','2026-08-07 12:01:40');
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-20260807-0003','1','BDCM-ZHXF-18-0','1','1.490','1.490','TOKO','CMBD','TOKO','BIPCMP');
DELETE FROM tm_barang WHERE kode_barang='BDCM-ZHXF-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='BDCM-ZHXF-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCM-ZHXF-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='BDCM-ZHXF-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPCMP',tgl_last_beli='2026-08-07 12:03:09' WHERE kode_barang='BDCM-ZHXF-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='BDCM-ZHXF-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-08-07 12:03:09','TOKO','BIPCMP','BDCM','BDCM-ZHXF-18-0','1','1.490','1.490','1','1.490','1.490','45.00');
DELETE FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='BDCM-ZHXF-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZHXF-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='FB-260730-0001';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0003','2026-08-07','12:01','1.490','kasirbip','2026-08-07 12:03:09');
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-20260807-0004','1','PBDG-ZHXF-3-0','1','1.910','1.910','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZHXF-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZHXF-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZHXF-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZHXF-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-08-07 12:03:44' WHERE kode_barang='PBDG-ZHXF-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZHXF-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:03:44','TOKO','BIPPER','PBDG','PBDG-ZHXF-3-0','1','1.910','1.910','1','1.910','1.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZHXF-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZHXF-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0004','2026-08-07','12:03','1.910','kasirbip','2026-08-07 12:03:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-07 ','12:20:17');
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-20260807-0005','1','PSPLT-ZHXF-6-0','1','2.220','2.220','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZHXF-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZHXF-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZHXF-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-08-07 12:23:25' WHERE kode_barang='PSPLT-ZHXF-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZHXF-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-08-07 12:23:25','TOKO','DUPSN','PSPLT','PSPLT-ZHXF-6-0','1','2.220','2.220','1','2.220','2.220','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-ZHXF-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0005','1','PSPRT-ZHXF-7-0','1','1.620','1.620','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-08-07 12:23:25' WHERE kode_barang='PSPRT-ZHXF-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-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-08-07 12:23:25','TOKO','DUPSN','PSPRT','PSPRT-ZHXF-7-0','1','1.620','1.620','1','1.620','1.620','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-ZHXF-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0005','1','PSPRT-ZHXF-19-0','1','1.800','1.800','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXF-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXF-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXF-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-08-07 12:23:25' WHERE kode_barang='PSPRT-ZHXF-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXF-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-08-07 12:23:25','TOKO','DUPSN','PSPRT','PSPRT-ZHXF-19-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-ZHXF-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXF-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0005','1','PSPLT-ZHXF-20-0','1','2.250','2.250','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZHXF-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZHXF-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZHXF-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-08-07 12:23:25' WHERE kode_barang='PSPLT-ZHXF-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZHXF-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-08-07 12:23:25','TOKO','DUPSN','PSPLT','PSPLT-ZHXF-20-0','1','2.250','2.250','1','2.250','2.250','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-ZHXF-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZHXF-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0005','2026-08-07','12:20','7.890','kasirbip','2026-08-07 12:23:25');
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-20260807-0006','1','LXPER-ZHXF-4-0','1','1.810','1.810','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZHXF-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZHXF-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZHXF-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZHXF-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-08-07 12:25:08' WHERE kode_barang='LXPER-ZHXF-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZHXF-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-07 12:25:08','TOKO','DUPERBDG','LXPER','LXPER-ZHXF-4-0','1','1.810','1.810','1','1.810','1.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZHXF-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZHXF-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0006','2026-08-07','12:24','1.810','kasirbip','2026-08-07 12:25: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-260807-0001','kasirbip','1',' 800K-11-00','TOKO','DUPERBDG','LXPER-ZEAB-24-0','CINCIN SILVER 925 ','','2.120','1','100.00','217000','0','0','17800','900000','0','0','0','900000','PUT','00043491','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAB-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='LXPER-ZEAB-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260807-0001','2026-08-07','2.120','2026-08-07','12:51:37','PLG0014106','900000','900000','0','900000','0','kasirbip','2026-08-07 12:51:37','FJ-260807-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-07','FJ-260807-0001','2026-08-07','12:51:37','PUT','900000','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-260807-0002','2026-08-07','2026-08-07 12:51:37','PENJUALAN : FJ-260807-0001','.','TBC','900000','900000','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-260807-0003','D','2026-08-07','12:51:37','TBC','PENJUALAN','FJ-260807-0001','25843025064','900000','25843925064','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='900000' WHERE no_faktur_jual='FJ-260807-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0002','kasirbip',' 1',' 800K-16-00','TOKO','DUPERBDG','LXPER-ZEBA-15-0','CINCIN SILVER 925 ','','2.670','1','100.00','273000','0','0','17800','900000','0','0','0','900000','PUT','00043694','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEBA-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='LXPER-ZEBA-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260807-0002','2026-08-07','2.670','2026-08-07','12:51:37','PLG0014107','900000','900000','0','900000','0','kasirbip','2026-08-07 12:51:37','FJ-260807-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-07','FJ-260807-0002','2026-08-07','12:51:37','PUT','900000','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-260807-0003','2026-08-07','2026-08-07 12:51:37','PENJUALAN : FJ-260807-0002','.','TBC','900000','900000','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-260807-0004','D','2026-08-07','12:51:37','TBC','PENJUALAN','FJ-260807-0002','25843925064','900000','25844825064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-260807-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0002';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0003','kasirbip','1',' 750K-11-25','TOKO','BIPPER','PBDG-ZDBA-20-0','CINCIN SILVER 925 ','','2.450','1','100.00','251000','0','0','17800','850000','0','0','0','850000','SAL','00042693','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDBA-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PBDG-ZDBA-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260807-0003','2026-08-07','2.450','2026-08-07','13:07:14','PLG0014108','850000','850000','0','850000','0','kasirbip','2026-08-07 13:07:14','FJ-260807-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-07','FJ-260807-0003','2026-08-07','13:07:14','SAL','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260807-0004','2026-08-07','2026-08-07 13:07:14','PENJUALAN : FJ-260807-0003','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260807-0005','D','2026-08-07','13:07:14','TBC','PENJUALAN','FJ-260807-0003','25844825064','850000','25845675064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260807-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-260807-0004','kasirbip',' 1',' 800K-195-2','TOKO','BIPPER','PBDG-ZHXD-44-0','CINCIN SILVER 925 ','','3.420','1','100.00','349000','0','0','17800','900000','0','0','0','900000','SAL','00045883','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.420',berat_jual_asli=berat_jual_asli+'3.420',stock_jual='1',berat_akhir=berat_akhir-'3.420',berat_akhir_asli=berat_akhir_asli-'3.420',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PBDG-ZHXD-44-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-260807-0004','2026-08-07','3.420','2026-08-07','13:07:14','PLG0014109','900000','900000','0','900000','0','kasirbip','2026-08-07 13:07:14','FJ-260807-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-07','FJ-260807-0004','2026-08-07','13:07:14','SAL','900000','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-260807-0005','2026-08-07','2026-08-07 13:07:14','PENJUALAN : FJ-260807-0004','.','TBC','900000','900000','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-260807-0006','D','2026-08-07','13:07:14','TBC','PENJUALAN','FJ-260807-0004','25845675064','900000','25846575064','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='1750000' WHERE no_faktur_jual='FJ-260807-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-07 ','13:21:49');
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-260807-0005','sby','1',' 750K-15-00','TOKO','SBYPER','PSBY-ZGXG-10-0','CINCIN SILVER 925 ','','2.340','1','100.00','239000','0','0','17800','850000','0','0','0','850000','VAN','00045023','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGXG-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSBY-ZGXG-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260807-0005','2026-08-07','2.340','2026-08-07','13:50:03','PLG0014110','850000','850000','0','850000','0','sby','2026-08-07 13:50:02','FJ-260807-0005','','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-08-07','FJ-260807-0005','2026-08-07','13:50:03','VAN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260807-0006','2026-08-07','2026-08-07 13:50:02','PENJUALAN : FJ-260807-0005','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260807-0007','D','2026-08-07','13:50:03','TBC','PENJUALAN','FJ-260807-0005','25846575064','850000','25847425064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260807-0005' 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-03278','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 14 putih komb rosegold glosy 1 zirkon','font vladimir grf N . . . E','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0007','2026-08-07','2026-08-07 14:14:32','PESANAN : DP-03278','.','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-260807-0008','D','2026-08-07','14:14:32','TBC','PESANAN','DP-03278','25847425064','850000','25848275064','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-03278','2026-08-07','2026-08-07','14:14:32','PLG0014111','SULIS','2026-08-17','kasirbip','2026-08-07 14:14:32','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0006','sby','1',' DP-02939SB','TOKO','SBYPSN','PSPRT-ZHXD-73-0','CINCIN PERAK ','','5.600','1','100.00','572000','0','0','17800','1200000','0','0','0','1200000','VAN','00045912','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHXD-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.600',berat_jual_asli=berat_jual_asli+'5.600',stock_jual='1',berat_akhir=berat_akhir-'5.600',berat_akhir_asli=berat_akhir_asli-'5.600',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPRT-ZHXD-73-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-260807-0006','2026-08-07','5.600','2026-08-07','14:18:38','PLG0014112','1200000','1200000','0','1200000','0','sby','2026-08-07 14:18:37','FJ-260807-0006','DP-02939','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-08-07','FJ-260807-0006','2026-08-07','14:18:38','VAN','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-260807-0006' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03279','SULIS','1','GOLD','WED RING','','','1.500','','37.50','1','2310000','1400000','0','850000','2950000','sz 11.5 putih komb rosegold glossy 17 zirkon','font vladimir grf N . . . E','berakt akhir jgn lebih dari 1.5gram','170000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0008','2026-08-07','2026-08-07 14:20:26','PESANAN : DP-03279','.','TBC','2500000','2500000');
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-260807-0009','D','2026-08-07','14:20:26','TBC','PESANAN','DP-03279','25848275064','2500000','25850775064','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-03279','2026-08-07','2026-08-07','14:20:26','PLG0014113','SULIS','2026-08-17','kasirbip','2026-08-07 14:20:26','1.500','0','0','0','2500000','0','850000','3120000','3120000','620000');
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-260807-0007','kasirbip','1',' DP-02621BI','TOKO','BIPPSN','PSPLT-ZGXH-27-0','CINCIN PALADIUM ','','3.210','1','17.00','721000','0','0','17800','1873500','0','0','0','1873500','KUR','00045072','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXH-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.210',berat_jual_asli=berat_jual_asli+'3.210',stock_jual='1',berat_akhir=berat_akhir-'3.210',berat_akhir_asli=berat_akhir_asli-'3.210',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPLT-ZGXH-27-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-260807-0007','2026-08-07','3.210','2026-08-07','14:36:53','PLG0014114','1873500','1873500','0','1873500','0','kasirbip','2026-08-07 14:36:53','FJ-260807-0007','DP-02621','1720000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-07','FJ-260807-0007','2026-08-07','14:36:53','KUR','1873500','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-260807-0009','2026-08-07','2026-08-07 14:36:53','PENJUALAN : FJ-260807-0007','.','TBC','153500','153500','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-260807-0010','D','2026-08-07','14:36:53','TBC','PENJUALAN','FJ-260807-0007','25850775064','153500','25850928564','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='153500' WHERE no_faktur_jual='FJ-260807-0007' 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-260807-0008','kasirbip',' 1',' DP-02622BI','TOKO','BIPPSN','PSPRT-ZGAX-28-0','CINCIN PERAK YL-10 ','','3.750','1','100.00','383000','0','0','17800','900000','0','0','0','900000','KUR','00045108','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.750',berat_jual_asli=berat_jual_asli+'3.750',stock_jual='1',berat_akhir=berat_akhir-'3.750',berat_akhir_asli=berat_akhir_asli-'3.750',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPRT-ZGAX-28-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-260807-0008','2026-08-07','3.750','2026-08-07','14:36:53','PLG0014115','900000','900000','0','900000','0','kasirbip','2026-08-07 14:36:53','FJ-260807-0007','DP-02622','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-08-07','FJ-260807-0008','2026-08-07','14:36:53','KUR','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='153500' WHERE no_faktur_jual='FJ-260807-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0008';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-07 ','15:37: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-260807-0009','kasirbip','1',' DP-03092BI','TOKO','BIPPSN','PSPRT-ZHXF-16-0','CINCIN PERAK YL01 ','','2.010','1','100.00','206000','0','0','17800','600000','0','0','0','600000','KUR','00045929','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHXF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPRT-ZHXF-16-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-260807-0009','2026-08-07','2.010','2026-08-07','15:39:29','PLG0014116','600000','600000','0','600000','0','kasirbip','2026-08-07 15:39:28','FJ-260807-0009','DP-03092','600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-07','FJ-260807-0009','2026-08-07','15:39:29','KUR','600000','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-260807-0009' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0010','kasirbip',' 1',' DP-03091BI','TOKO','BIPPSN','PSPRT-ZHXF-17-0','CINCIN PERAK ','','1.380','1','100.00','141000','0','0','17800','900000','0','0','0','900000','KUR','00045930','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHXF-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPRT-ZHXF-17-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-260807-0010','2026-08-07','1.380','2026-08-07','15:39:29','PLG0014117','900000','900000','0','900000','0','kasirbip','2026-08-07 15:39:28','FJ-260807-0009','DP-03091','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-08-07','FJ-260807-0010','2026-08-07','15:39:29','KUR','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-260807-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0010';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02208','SAL','1','CINCIN PALLADIUM','PATRI CINCIN','3.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02208','2026-08-07','2026-08-07','16:25:20','PLG0014118','kasirbip','2026-08-18','kasirbip','2026-08-07 16:25:20','3.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-07 ','16:25:33');
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-03280','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','950000','0','950000','cewe size 14 grf Dhavin SR-01 over size 100.000','cowo size 21.5 grf Tanjani YL-01 over size 100.000','font comic sans','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-260807-0010','2026-08-07','2026-08-07 16:41:11','PESANAN : DP-03280','.','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-260807-0011','D','2026-08-07','16:41:11','TBC','PESANAN','DP-03280','25850928564','950000','25851878564','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-03280','2026-08-07','2026-08-07','16:41:11','PLG0014119','KUR','2026-08-27','kasirbip','2026-08-07 16:41:11','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0011','kasirbip','1',' DP-03129BI','TOKO','BIPPSN','PSPRT-ZHXF-42-0','CINCIN PERAK ','','3.450','1','100.00','352000','0','0','17800','900000','0','0','0','900000','KUR','00045955','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHXF-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.450',berat_jual_asli=berat_jual_asli+'3.450',stock_jual='1',berat_akhir=berat_akhir-'3.450',berat_akhir_asli=berat_akhir_asli-'3.450',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPRT-ZHXF-42-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-260807-0011','2026-08-07','3.450','2026-08-07','16:46:46','PLG0014120','900000','900000','0','900000','0','kasirbip','2026-08-07 16:46:45','FJ-260807-0011','DP-03129','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-08-07','FJ-260807-0011','2026-08-07','16:46:46','KUR','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-260807-0011' 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-03281','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','800000','0','800000','SIZE: 19.5','GRF: Adel 06.09.2026 FONT VLADIMIR','PUTIH DOFF MIX ROSE GOLD','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-260807-0011','2026-08-07','2026-08-07 17:07:52','PESANAN : DP-03281','-','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260807-0012','D','2026-08-07','17:07:52','TBC','PESANAN','DP-03281','25851878564','800000','25852678564','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-03281','2026-08-07','2026-08-07','17:07:52','PLG0014121','VAN','2026-08-30','sby','2026-08-07 17:07:52','3.000','0','0','0','800000','0','0','800000','800000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-07 ','17:14:24');
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-260807-0012','kasirbip','1',' DP-02887DU','TOKO','DUPSN','PSPLT-ZHXD-11-0','CINCIN PALADIUM ','','4.110','1','17.00','923000','0','0','17800','2938500','0','0','0','2938500','NAD','00045850','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHXD-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.110',berat_jual_asli=berat_jual_asli+'4.110',stock_jual='1',berat_akhir=berat_akhir-'4.110',berat_akhir_asli=berat_akhir_asli-'4.110',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPLT-ZHXD-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-260807-0012','2026-08-07','4.110','2026-08-07','17:17:26','PLG0014122','2938500','2938500','0','2938500','0','kasirbip','2026-08-07 17:17:26','FJ-260807-0012','DP-02887','2320000');
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-08-07','FJ-260807-0012','2026-08-07','17:17:26','NAD','2938500','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-260807-0012','2026-08-07','2026-08-07 17:17:26','PENJUALAN : FJ-260807-0012','.','TBC','618500','618500','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-260807-0013','D','2026-08-07','17:17:26','TBC','PENJUALAN','FJ-260807-0012','25852678564','618500','25853297064','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='618500' WHERE no_faktur_jual='FJ-260807-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0013','kasirbip',' 1',' DP-02886DU','TOKO','DUPSN','PSPLT-ZHXD-10-0','CINCIN PALADIUM ','','3.010','1','17.00','676000','0','0','17800','2623500','0','0','0','2623500','NAD','00045849','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHXD-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPLT-ZHXD-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-260807-0013','2026-08-07','3.010','2026-08-07','17:17:26','PLG0014123','2623500','2623500','0','2623500','0','kasirbip','2026-08-07 17:17:26','FJ-260807-0012','DP-02886','2096000');
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-08-07','FJ-260807-0013','2026-08-07','17:17:26','NAD','2623500','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-260807-0013','2026-08-07','2026-08-07 17:17:26','PENJUALAN : FJ-260807-0013','.','TBC','527500','527500','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-260807-0014','D','2026-08-07','17:17:26','TBC','PENJUALAN','FJ-260807-0013','25853297064','527500','25853824564','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='1146000' WHERE no_faktur_jual='FJ-260807-0013' 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-03282','ELLA','1','PER','CINCIN PROMO SR05 SLV','','','2.000','','0.00','1','100000','0','0','0','950000','size cwe 16 grf Dedes zircone 1 btr','size cwo 16 grf Heri','warna putih sesuai model','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-260807-0014','2026-08-07','2026-08-07 17:18:44','PESANAN : DP-03282','0','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-260807-0015','D','2026-08-07','17:18:44','TBC','PESANAN','DP-03282','25853824564','950000','25854774564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-03282','2026-08-07','2026-08-07','17:18:44','PLG0014124','ELLA','2026-09-04','kasir','2026-08-07 17:18:44','2.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0014','sby','1',' 750K-175-0','TOKO','SBYPER','PSBY-ZGCA-9-0','CINCIN SILVER 925 ','','2.970','1','100.00','303000','0','0','17800','850000','0','0','0','850000','VAN','00045824','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGCA-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSBY-ZGCA-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260807-0014','2026-08-07','2.970','2026-08-07','17:25:43','PLG0014125','850000','850000','0','850000','0','sby','2026-08-07 17:25:42','FJ-260807-0014','','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-08-07','FJ-260807-0014','2026-08-07','17:25:43','VAN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260807-0015','2026-08-07','2026-08-07 17:25:42','PENJUALAN : FJ-260807-0014','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260807-0016','D','2026-08-07','17:25:43','TBC','PENJUALAN','FJ-260807-0014','25854774564','850000','25855624564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260807-0014' 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-260807-0015','sby',' 1',' 1.25K-135-','TOKO','SBYPER','PSBY-ZGCA-12-0','CINCIN SILVER 925 ','','2.500','1','100.00','255000','0','0','17800','1350000','0','0','0','1350000','VAN','00045827','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGCA-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSBY-ZGCA-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260807-0015','2026-08-07','2.500','2026-08-07','17:25:43','PLG0014126','1350000','1350000','0','1350000','0','sby','2026-08-07 17:25:42','FJ-260807-0014','','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-08-07','FJ-260807-0015','2026-08-07','17:25:43','VAN','1350000','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-260807-0016','2026-08-07','2026-08-07 17:25:42','PENJUALAN : FJ-260807-0015','','TBC','1350000','1350000','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-260807-0017','D','2026-08-07','17:25:43','TBC','PENJUALAN','FJ-260807-0015','25855624564','1350000','25856974564','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='2200000' WHERE no_faktur_jual='FJ-260807-0015' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-07 ','17:38:59');
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-20260807-0007','1','TFCMR-ZHXG-11-0','1','0.890','0.890','TOKO','CMPTF','TOKO','TFCINMAS');
DELETE FROM tm_barang WHERE kode_barang='TFCMR-ZHXG-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFCMR-ZHXG-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-ZHXG-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFCMR-ZHXG-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFCINMAS',tgl_last_beli='2026-08-07 17:39:22' WHERE kode_barang='TFCMR-ZHXG-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFCMR-ZHXG-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-08-07 17:39:22','TOKO','TFCINMAS','TFCMR','TFCMR-ZHXG-11-0','1','0.890','0.890','1','0.890','0.890','76.00');
DELETE FROM tm_dept WHERE kode_dept='TFCMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFCMR' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFCMR-ZHXG-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFCMR-ZHXG-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='FB-260803-0001';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0007','2026-08-07','17:39','0.890','kasir','2026-08-07 17:39:22');
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-20260807-0008','1','TFG-ZHXG-10-0','1','7.740','7.740','TOKO','TFG.BALIK','TOKO','TFGBR');
DELETE FROM tm_barang WHERE kode_barang='TFG-ZHXG-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFG-ZHXG-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFG-ZHXG-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFG-ZHXG-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFGBR',tgl_last_beli='2026-08-07 17:39:46' WHERE kode_barang='TFG-ZHXG-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFG-ZHXG-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-08-07 17:39:46','TOKO','TFGBR','TFG','TFG-ZHXG-10-0','1','7.740','7.740','1','7.740','7.740','103.00');
DELETE FROM tm_dept WHERE kode_dept='TFG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFG-ZHXG-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFG-ZHXG-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='FB-260802-0002';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0008','2026-08-07','17:39','7.740','kasir','2026-08-07 17:39:46');
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-20260807-0009','1','PSPRT-ZHXG-28-0','1','3.830','3.830','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXG-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXG-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXG-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXG-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-07 17:40:03' WHERE kode_barang='PSPRT-ZHXG-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXG-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-08-07 17:40:03','TOKO','MMPSN','PSPRT','PSPRT-ZHXG-28-0','1','3.830','3.830','1','3.830','3.830','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-ZHXG-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXG-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0009','1','PSPRT-ZHXG-29-0','1','2.210','2.210','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXG-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXG-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXG-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXG-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-07 17:40:03' WHERE kode_barang='PSPRT-ZHXG-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXG-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-08-07 17:40:03','TOKO','MMPSN','PSPRT','PSPRT-ZHXG-29-0','1','2.210','2.210','1','2.210','2.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZHXG-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXG-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0009','1','PSGT-ZHXG-30-0','1','3.040','3.040','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZHXG-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZHXG-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZHXG-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZHXG-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-07 17:40:03' WHERE kode_barang='PSGT-ZHXG-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZHXG-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-08-07 17:40:03','TOKO','MMPSN','PSGT','PSGT-ZHXG-30-0','1','3.040','3.040','1','3.040','3.040','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-ZHXG-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZHXG-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' 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-20260807-0009','1','PSPRT-ZHXG-31-0','1','3.770','3.770','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHXG-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXG-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHXG-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHXG-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-08-07 17:40:03' WHERE kode_barang='PSPRT-ZHXG-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHXG-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-08-07 17:40:03','TOKO','MMPSN','PSPRT','PSPRT-ZHXG-31-0','1','3.770','3.770','1','3.770','3.770','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-ZHXG-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHXG-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-07' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260807-0009','2026-08-07','17:39','12.850','kasir','2026-08-07 17:40:03');
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-03283','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','850000','3050000','PERMATA 1','SIZE: 19.5 GRF: Sherly Yunita??','FONTY: VINTAGE PUTIH','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0017','2026-08-07','2026-08-07 17:51:27','PESANAN : DP-03283','-','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260807-0018','D','2026-08-07','17:51:27','TBC','PESANAN','DP-03283','25856974564','2000000','25858974564','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-03283','2026-08-07','2026-08-07','17:51:27','PLG0014127','VAN','2026-08-30','sby','2026-08-07 17:51:27','4.000','0','0','0','2000000','0','850000','3060000','3060000','1060000');
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-03284','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','850000','3050000','PERMATA 1','SIZE: 19.5 GRF: Sherly Yunita ??','FONT: VINTAGE PUTIH','10000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0018','2026-08-07','2026-08-07 17:55:11','PESANAN : DP-03284','-','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260807-0019','D','2026-08-07','17:55:11','TBC','PESANAN','DP-03284','25858974564','2000000','25860974564','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-03284','2026-08-07','2026-08-07','17:55:11','PLG0014128','VAN','2026-08-30','sby','2026-08-07 17:55:11','4.000','0','0','0','2000000','0','850000','3060000','3060000','1060000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-08-07 ','18:11:08');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03283';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03283';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03283';
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-260807-0002','K','2026-08-07','18:12:59','Nagatech','PESANAN BATAL','DP-03283','13752300','0','13752300');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03168';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03168';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03168';
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-260807-0003','K','2026-08-07','18:15:58','Nagatech','PESANAN BATAL','DP-03168','13752300','0','13752300');
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-03285','KUR','1','PLD','WED RING','','','1.500','','10.00','1','1200000','350000','0','950000','1475000','sz 10 putih glossy 17 zirkon','font times new roman grf Agung 26.12.26','','170000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0019','2026-08-07','2026-08-07 18:37:50','PESANAN : DP-03285','.','TBC','1315000','1315000');
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-260807-0020','D','2026-08-07','18:37:50','TBC','PESANAN','DP-03285','25860974564','1315000','25862289564','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-03285','2026-08-07','2026-08-07','18:37:50','PLG0014129','KUR','2026-09-07','kasirbip','2026-08-07 18:37:50','1.500','0','0','0','1315000','0','950000','1645000','1645000','330000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-07 ','18:39:13');
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-03286','KUR','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','600000','1300000','YL-01 sz 15 putih doff semprot','font times new roman Pandji 26.12.26','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0020','2026-08-07','2026-08-07 18:39:28','PESANAN : DP-03286','.','TBC','1040000','1040000');
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-260807-0021','D','2026-08-07','18:39:28','TBC','PESANAN','DP-03286','25862289564','1040000','25863329564','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-03286','2026-08-07','2026-08-07','18:39:28','PLG0014130','KUR','2026-09-07','kasirbip','2026-08-07 18:39:28','2.000','0','0','0','1040000','0','600000','1300000','1300000','260000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-07 ','18:46:16');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260807-0016','sby','1',' DP-02950SB','TOKO','SBYPSN','PSPRT-ZHXD-16-0','CINCIN PERAK SR-03 YL-01 ','','3.270','1','100.00','334000','0','0','17800','950000','0','0','0','950000','VAN','00045855','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHXD-16-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-08-07' AND kode_barang='PSPRT-ZHXD-16-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-260807-0016','2026-08-07','3.270','2026-08-07','18:47:18','PLG0014131','950000','950000','0','950000','0','sby','2026-08-07 18:47:17','FJ-260807-0016','DP-02950','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-08-07','FJ-260807-0016','2026-08-07','18:47:18','VAN','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-260807-0016' 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-260807-0017','kasirbip','1',' 750K-105 ','TOKO','BIPCMP','BDCM-ZFAE-13-0','CINCIN EMAS ','','1.590','1','45.00','1738000','0','0','17800','2976000','0','0','0','2976000','SAL','00044420','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZFAE-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='BDCM-ZFAE-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260807-0017','2026-08-07','1.590','2026-08-07','19:05:37','PLG0014132','2976000','2976000','0','2976000','0','kasirbip','2026-08-07 19:05:36','FJ-260807-0017','','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-08-07','FJ-260807-0017','2026-08-07','19:05:37','SAL','2976000','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-260807-0021','2026-08-07','2026-08-07 19:05:36','PENJUALAN : FJ-260807-0017','.','TBC','2976000','2976000','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-260807-0022','D','2026-08-07','19:05:37','TBC','PENJUALAN','FJ-260807-0017','25863329564','2976000','25866305564','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='2976000' WHERE no_faktur_jual='FJ-260807-0017' 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-03287','VAN','1','PER','WEDDRING WANITA','','','2.000','','925.00','1','100000','0','850000','0','850000','SIZE: 14','GRF: Yusuf FONT: VINTAGE','PUTIH','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-260807-0022','2026-08-07','2026-08-07 19:09:23','PESANAN : DP-03287','-','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-260807-0023','D','2026-08-07','19:09:23','TBC','PESANAN','DP-03287','25866305564','850000','25867155564','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-03287','2026-08-07','2026-08-07','19:09:23','PLG0014133','VAN','2026-08-16','sby','2026-08-07 19:09:23','2.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-03288','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE: 27','GRF: Novita FONT: VINTAGE','PUTIH','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-260807-0023','2026-08-07','2026-08-07 19:12:02','PESANAN : DP-03288','-','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-260807-0024','D','2026-08-07','19:12:02','TBC','PESANAN','DP-03288','25867155564','850000','25868005564','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-03288','2026-08-07','2026-08-07','19:12:02','PLG0014134','VAN','2026-08-16','sby','2026-08-07 19:12:02','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0017';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000372','X-00000372','THIFA CINCIN MAS RG','GR','---','TFCMR','BELI','BELI001','1410000','2026-08-07','0.910','1','kasir','2026-08-07 19:19:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFCMR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFCMR','X-00000372','X-00000372');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260807-0001','-','FIR','1','BELI','BELI001','TFCMR', 'X-00000372', 'THIFA CINCIN MAS RG','0.910','0.910','75.00','1860000','1410000','1549451','1','1410000','1410000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFCMR' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260807-0001','2026-08-07','2026-08-07','19:19:08','FIR','---','0.910','1410000','1410000','1410000','1410000','1410000','kasir','2026-08-07 19:19:09','FB-260807-0001','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260807-0001','ANGGI','JKT','','JKT','','kasir','2026-08-07 19:19:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260807-0004','K','2026-08-07','19:19:08','kasir','PEMBELIAN UMUM','FB-260807-0001','13752300','1410000','12342300','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260807-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260807-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-07 ','19:31:38');
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-260807-0018','kasirbip','1',' DP-02933DU','TOKO','DUPSN','PSPRT-ZHXD-9-0','CINCIN PERAK ','','2.350','1','100.00','240000','0','0','17800','850000','0','0','0','850000','PUT','00045848','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHXD-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPRT-ZHXD-9-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-260807-0018','2026-08-07','2.350','2026-08-07','19:35:49','PLG0014135','850000','850000','0','850000','0','kasirbip','2026-08-07 19:35:49','FJ-260807-0018','DP-02933','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-08-07','FJ-260807-0018','2026-08-07','19:35:49','PUT','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-260807-0018' 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-260807-0019','kasirbip',' 1',' DP-02932DU','TOKO','DUPSN','PSPRT-ZHXF-19-0','CINCIN PERAK ','','1.800','1','100.00','184000','0','0','17800','950000','0','0','0','950000','PUT','00045932','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHXF-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSPRT-ZHXF-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-260807-0019','2026-08-07','1.800','2026-08-07','19:35:49','PLG0014136','950000','950000','0','950000','0','kasirbip','2026-08-07 19:35:49','FJ-260807-0018','DP-02932','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-08-07','FJ-260807-0019','2026-08-07','19:35:49','PUT','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260807-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0019';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-07 ','19:42:51');
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-260807-0020','sby','1',' 500K-15-00','TOKO','SBYPER','PSBY-ZGCA-5-0','CINCIN SILVER 925 YL01 ','','1.770','1','100.00','181000','0','0','17800','600000','0','0','0','600000','VAN','00045820','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGCA-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSBY-ZGCA-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260807-0020','2026-08-07','1.770','2026-08-07','20:17:37','PLG0014137','600000','600000','0','600000','0','sby','2026-08-07 20:17:36','FJ-260807-0020','','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-08-07','FJ-260807-0020','2026-08-07','20:17:37','VAN','600000','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-260807-0024','2026-08-07','2026-08-07 20:17:36','PENJUALAN : FJ-260807-0020','','TBC','600000','600000','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-260807-0025','D','2026-08-07','20:17:37','TBC','PENJUALAN','FJ-260807-0020','25868005564','600000','25868605564','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='600000' WHERE no_faktur_jual='FJ-260807-0020' 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-260807-0021','sby',' 1',' 900K-15-00','TOKO','SBYPER','PSBY-ZEXE-50-0','CINCIN SILVER 925 ','','1.760','1','100.00','180000','0','0','17800','1000000','0','0','0','1000000','VAN','00043246','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-08-07' AND kode_barang='PSBY-ZEXE-50-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260807-0021','2026-08-07','1.760','2026-08-07','20:17:37','PLG0014138','1000000','1000000','0','1000000','0','sby','2026-08-07 20:17:36','FJ-260807-0020','','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-08-07','FJ-260807-0021','2026-08-07','20:17:37','VAN','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260807-0025','2026-08-07','2026-08-07 20:17:36','PENJUALAN : FJ-260807-0021','','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260807-0026','D','2026-08-07','20:17:37','TBC','PENJUALAN','FJ-260807-0021','25868605564','1000000','25869605564','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='1600000' WHERE no_faktur_jual='FJ-260807-0021' 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-03289','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 9 putih glosy 1 zircon','font vladimir grf Septy','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0026','2026-08-07','2026-08-07 20:47:00','PESANAN : DP-03289','.','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-260807-0027','D','2026-08-07','20:47:00','TBC','PESANAN','DP-03289','25869605564','850000','25870455564','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-03289','2026-08-07','2026-08-07','20:47:00','PLG0014139','SULIS','2026-08-31','kasirbip','2026-08-07 20:47:00','2.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-03290','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1100000','0','1100000','sz 13 putih glosy','font vladimir grf Endaw','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260807-0027','2026-08-07','2026-08-07 20:48:05','PESANAN : DP-03290','.','TBC','1100000','1100000');
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-260807-0028','D','2026-08-07','20:48:05','TBC','PESANAN','DP-03290','25870455564','1100000','25871555564','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-03290','2026-08-07','2026-08-07','20:48:05','PLG0014140','SULIS','2026-08-31','kasirbip','2026-08-07 20:48:05','2.000','0','0','0','1100000','0','0','1100000','1100000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260807-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260807-0021';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-07';
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-08-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-07' 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-260808-0001','D','2026-08-08','21:04:25','TBC','SALDO AWAL','SALDO AWAL','0','25871555564','25871555564');
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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','','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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','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-260808-0001','D','2026-08-08','21:04:25','BCK','SALDO AWAL','SALDO AWAL','0','2007408000','2007408000');
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-260808-0001','D','2026-08-08','21:04:25','BCD','SALDO AWAL','SALDO AWAL','0','1448723500','1448723500');
UPDATE tp_system SET tgl_system='2026-08-08';