INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','08:12:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','08:36:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','09:49:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-30 ','10:01:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','11:00:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','11:04:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','11:06:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','11:06:31');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0028';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-30','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-29';
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-07-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-29' 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-260730-0001','D','2026-07-30','11:07:22','TBC','SALDO AWAL','SALDO AWAL','0','25526410564','25526410564');
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-260730-0001','D','2026-07-30','11:07:22','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','','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-260730-0001','D','2026-07-30','11:07:22','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-260730-0001','D','2026-07-30','11:07:22','BCK','SALDO AWAL','SALDO AWAL','0','1996308000','1996308000');
UPDATE tp_system SET tgl_system='2026-07-30';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','11:07:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','11:10:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','11:12:20');
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-03155','PUT','1','PER','WEDRING PROMO','','','5.000','','925.00','1','100000','0','1400000','0','1400000','sz cwe 12 CP.10','sz cwo 20 CP.10','grf menyusul','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-260730-0001','2026-07-30','2026-07-30 11:16:08','PESANAN : DP-03155','.','TBC','1400000','1400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260730-0002','D','2026-07-30','11:16:08','TBC','PESANAN','DP-03155','25526410564','1400000','25527810564','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-03155','2026-07-30','2026-07-30','11:16:08','PLG0013765','PUT','2026-08-25','kasirbip','2026-07-30 11:16:08','5.000','0','0','0','1400000','0','0','1400000','1400000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','11:39:04');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260730-0001','1','PSPLT-ZGBI-17-0','1','2.450','2.450','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBI-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBI-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBI-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBI-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPLT-ZGBI-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBI-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-07-30 11:39:46','TOKO','MMPSN','PSPLT','PSPLT-ZGBI-17-0','1','2.450','2.450','1','2.450','2.450','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGBI-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBI-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSGT-ZGBI-18-0','1','1.970','1.970','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBI-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBI-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBI-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBI-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSGT-ZGBI-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBI-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-07-30 11:39:46','TOKO','MMPSN','PSGT','PSGT-ZGBI-18-0','1','1.970','1.970','1','1.970','1.970','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-ZGBI-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBI-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPLT-ZGBI-19-0','1','3.440','3.440','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBI-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBI-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBI-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBI-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPLT-ZGBI-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBI-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-07-30 11:39:46','TOKO','MMPSN','PSPLT','PSPLT-ZGBI-19-0','1','3.440','3.440','1','3.440','3.440','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-ZGBI-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBI-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPRT-ZGBI-20-0','1','5.130','5.130','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBI-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBI-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBI-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBI-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPRT-ZGBI-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBI-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-07-30 11:39:46','TOKO','MMPSN','PSPRT','PSPRT-ZGBI-20-0','1','5.130','5.130','1','5.130','5.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBI-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBI-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPRT-ZGBI-21-0','1','3.400','3.400','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBI-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBI-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBI-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBI-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPRT-ZGBI-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBI-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-30 11:39:46','TOKO','MMPSN','PSPRT','PSPRT-ZGBI-21-0','1','3.400','3.400','1','3.400','3.400','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-ZGBI-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBI-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPRT-ZGCX-5-0','1','1.980','1.980','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGCX-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGCX-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGCX-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPRT-ZGCX-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGCX-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-30 11:39:46','TOKO','MMPSN','PSPRT','PSPRT-ZGCX-5-0','1','1.980','1.980','1','1.980','1.980','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-ZGCX-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPRT-ZGCX-6-0','1','4.070','4.070','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGCX-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGCX-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGCX-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPRT-ZGCX-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGCX-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-07-30 11:39:46','TOKO','MMPSN','PSPRT','PSPRT-ZGCX-6-0','1','4.070','4.070','1','4.070','4.070','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-ZGCX-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPRT-ZGCX-7-0','1','2.290','2.290','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGCX-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGCX-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGCX-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPRT-ZGCX-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGCX-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-07-30 11:39:46','TOKO','MMPSN','PSPRT','PSPRT-ZGCX-7-0','1','2.290','2.290','1','2.290','2.290','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-ZGCX-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPRT-ZGCX-8-0','1','2.290','2.290','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGCX-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGCX-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGCX-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPRT-ZGCX-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGCX-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-30 11:39:46','TOKO','MMPSN','PSPRT','PSPRT-ZGCX-8-0','1','2.290','2.290','1','2.290','2.290','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-ZGCX-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0001','1','PSPRT-ZGCX-9-0','1','2.870','2.870','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGCX-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGCX-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGCX-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-30 11:39:46' WHERE kode_barang='PSPRT-ZGCX-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGCX-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-30 11:39:46','TOKO','MMPSN','PSPRT','PSPRT-ZGCX-9-0','1','2.870','2.870','1','2.870','2.870','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-ZGCX-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260730-0001','2026-07-30','11:39','29.890','kasir','2026-07-30 11:39:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-30 ','11:40:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','11:43:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','11:43:11');
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-20260730-0002','1','PSPRT-ZGCX-2-0','1','2.260','2.260','TOKO','PSNT','TOKO','TFPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGCX-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGCX-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGCX-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFPSN',tgl_last_beli='2026-07-30 11:45:04' WHERE kode_barang='PSPRT-ZGCX-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGCX-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-30 11:45:04','TOKO','TFPSN','PSPRT','PSPRT-ZGCX-2-0','1','2.260','2.260','1','2.260','2.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGCX-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' 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-20260730-0002','1','PSPRT-ZGCX-3-0','1','2.210','2.210','TOKO','PSNT','TOKO','TFPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGCX-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGCX-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGCX-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFPSN',tgl_last_beli='2026-07-30 11:45:04' WHERE kode_barang='PSPRT-ZGCX-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGCX-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-07-30 11:45:04','TOKO','TFPSN','PSPRT','PSPRT-ZGCX-3-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-ZGCX-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGCX-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260730-0002','2026-07-30','11:44','4.470','kasir','2026-07-30 11:45:03');
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-20260730-0003','1','TFKMP-ZGBI-9-0','1','2.050','2.050','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMP-ZGBI-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMP-ZGBI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMP-ZGBI-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMP-ZGBI-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-07-30 11:45:36' WHERE kode_barang='TFKMP-ZGBI-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMP-ZGBI-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-30 11:45:36','TOKO','TFKMP','TFKMP','TFKMP-ZGBI-9-0','1','2.050','2.050','1','2.050','2.050','76.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMP' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMP' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='TFKMP-ZGBI-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMP-ZGBI-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' WHERE no_faktur_beli='FB-260722-0001';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260730-0003','1','TFKMR-ZGBI-12-0','1','3.840','3.840','TOKO','KMPTF','TOKO','TFKMP');
DELETE FROM tm_barang WHERE kode_barang='TFKMR-ZGBI-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='TFKMR-ZGBI-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFKMR-ZGBI-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='TFKMR-ZGBI-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFKMP',tgl_last_beli='2026-07-30 11:45:36' WHERE kode_barang='TFKMR-ZGBI-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='TFKMR-ZGBI-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-07-30 11:45:36','TOKO','TFKMP','TFKMR','TFKMR-ZGBI-12-0','1','3.840','3.840','1','3.840','3.840','76.00');
DELETE FROM tm_dept WHERE kode_dept='TFKMR' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='TFKMR' 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='TFKMR-ZGBI-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='TFKMR-ZGBI-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-30' WHERE no_faktur_beli='FB-260724-0001';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260730-0003','2026-07-30','11:45','5.890','kasir','2026-07-30 11:45:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','12:05: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-260730-0001','kasir','1',' DP-02842MM','TOKO','MMPSN','PSGT-ZGBC-18-0','CINCIN EMAS ','','2.860','1','57.00','3792000','0','0','17800','5848000','0','0','0','5848000','ALIKA','00045565','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBC-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSGT-ZGBC-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260730-0001','2026-07-30','2.860','2026-07-30','12:06:48','PLG0013766','5848000','5848000','0','5848000','0','kasir','2026-07-30 12:06:48','FJ-260730-0001','DP-02842','4592000');
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-07-30','FJ-260730-0001','2026-07-30','12:06:48','ALIKA','5848000','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-260730-0002','2026-07-30','2026-07-30 12:06:48','PENJUALAN : FJ-260730-0001','.','TBC','1256000','1256000','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-260730-0003','D','2026-07-30','12:06:48','TBC','PENJUALAN','FJ-260730-0001','25527810564','1256000','25529066564','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='1256000' WHERE no_faktur_jual='FJ-260730-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-260730-0002','kasir',' 1',' DP-02843MM','TOKO','MMPSN','PSPRT-ZGBH-12-0','CINCIN PERAK ','','4.570','1','100.00','467000','0','0','17800','850000','0','0','0','850000','ALIKA','00045660','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.570',berat_jual_asli=berat_jual_asli+'4.570',stock_jual='1',berat_akhir=berat_akhir-'4.570',berat_akhir_asli=berat_akhir_asli-'4.570',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSPRT-ZGBH-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260730-0002','2026-07-30','4.570','2026-07-30','12:06:48','PLG0013767','850000','850000','0','850000','0','kasir','2026-07-30 12:06:48','FJ-260730-0001','DP-02843','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-07-30','FJ-260730-0002','2026-07-30','12:06:48','ALIKA','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1256000' WHERE no_faktur_jual='FJ-260730-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-30 ','12:26:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-30 ','12:28: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-260730-0003','sby','1',' DP-02850SB','TOKO','SBYPSN','PSPRT-ZGBH-46-0','CINCIN PERAK SR-01 YL-01 ','','3.120','1','100.00','319000','0','0','17800','1050000','0','0','0','1050000','VAN','00045694','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSPRT-ZGBH-46-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-260730-0003','2026-07-30','3.120','2026-07-30','12:29:34','PLG0013768','1050000','1050000','0','1050000','0','sby','2026-07-30 12:29:33','FJ-260730-0003','DP-02850','1050000');
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-07-30','FJ-260730-0003','2026-07-30','12:29:34','VAN','1050000','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-260730-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-260730-0004','kasirbip','1',' DP-02682BI','TOKO','BIPPSN','PSGT-ZGAD-46-0','CINCIN EMAS ','','1.660','1','45.00','1738000','0','0','17800','3240000','0','0','0','3240000','KUR','00045183','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGAD-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSGT-ZGAD-46-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-260730-0004','2026-07-30','1.660','2026-07-30','12:33:07','PLG0013769','3240000','3240000','0','3240000','0','kasirbip','2026-07-30 12:33:06','FJ-260730-0004','DP-02682','3000000');
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-07-30','FJ-260730-0004','2026-07-30','12:33:07','KUR','3240000','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-260730-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260730-0005','kasirbip',' 1',' DP-02683BI','TOKO','BIPPSN','PSPLT-ZGAG-40-0','CINCIN PALADIUM YL-01 ','','1.480','1','17.00','333000','0','0','17800','1268000','0','0','0','1268000','KUR','00045307','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSPLT-ZGAG-40-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-260730-0005','2026-07-30','1.480','2026-07-30','12:33:07','PLG0013770','1268000','1268000','0','1268000','0','kasirbip','2026-07-30 12:33:06','FJ-260730-0004','DP-02683','1300000');
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-07-30','FJ-260730-0005','2026-07-30','12:33:07','KUR','1268000','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-260730-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0005';
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-03156','NAD','1','PER','WEDRING PROMO','','','5.000','','925.00','1','100000','0','1600000','0','1600000','sz cwe 17 CP.11 grf Tanti ... Usnadi','sz cwo 19 CP.11 grf Usnadi ... Tanti','Font Berkshire','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0003','2026-07-30','2026-07-30 12:57:55','PESANAN : DP-03156','.','TBC','1600000','1600000');
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-260730-0004','D','2026-07-30','12:57:55','TBC','PESANAN','DP-03156','25529066564','1600000','25530666564','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-03156','2026-07-30','2026-07-30','12:57:55','PLG0013771','NAD','2026-08-25','kasirbip','2026-07-30 12:57:55','5.000','0','0','0','1600000','0','0','1600000','1600000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-30 ','13:03:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','13:36:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','13:44:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','13:59: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-260730-0006','kasir','1',' DP-02796MM','TOKO','MMPSN','PSPRT-ZGBX-71-0','1PS CINCIN PERAK ','','5.310','1','100.00','542000','0','0','17800','1400000','0','0','0','1400000','ALIKA','00045391','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBX-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.310',berat_jual_asli=berat_jual_asli+'5.310',stock_jual='1',berat_akhir=berat_akhir-'5.310',berat_akhir_asli=berat_akhir_asli-'5.310',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSPRT-ZGBX-71-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260730-0006','2026-07-30','5.310','2026-07-30','14:50:58','PLG0013772','1400000','1400000','0','1400000','0','kasir','2026-07-30 14:50:57','FJ-260730-0006','DP-02796','1400000');
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-07-30','FJ-260730-0006','2026-07-30','14:50:58','ALIKA','1400000','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-260730-0006' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','14:51:56');
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-260730-0007','kasirbip','1',' 750K-20-00','TOKO','DUPERBDG','LXPER-ZGXF-70-0','CINCIN SILVER 925 ','','1.690','1','100.00','173000','0','0','17800','850000','0','0','0','850000','PUT','00044998','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGXF-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.690',berat_jual_asli=berat_jual_asli+'1.690',stock_jual='1',berat_akhir=berat_akhir-'1.690',berat_akhir_asli=berat_akhir_asli-'1.690',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='LXPER-ZGXF-70-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-260730-0007','2026-07-30','1.690','2026-07-30','16:29:09','PLG0013773','850000','850000','0','850000','0','kasirbip','2026-07-30 16:29:09','FJ-260730-0007','','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-07-30','FJ-260730-0007','2026-07-30','16:29:09','PUT','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-260730-0004','2026-07-30','2026-07-30 16:29:09','PENJUALAN : FJ-260730-0007','.','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-260730-0005','D','2026-07-30','16:29:09','TBC','PENJUALAN','FJ-260730-0007','25530666564','850000','25531516564','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-260730-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-30 ','17:26:16');
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-03157','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','SIZE: 20','PUTIH GLOSSY','TANPA UKIR NAMA','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-260730-0005','2026-07-30','2026-07-30 17:28:59','PESANAN : DP-03157','-','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-260730-0006','D','2026-07-30','17:28:59','TBC','PESANAN','DP-03157','25531516564','2000000','25533516564','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-03157','2026-07-30','2026-07-30','17:28:59','PLG0013774','VAN','2026-08-23','sby','2026-07-30 17:28:59','4.000','0','0','0','2000000','0','800000','3000000','3000000','1000000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-30 ','18:00:47');
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-260730-0008','sby','1',' DP-02717SB','TOKO','SBYPSN','PSPLT-ZGBX-65-0','CINCIN PALADIUM YL-10 ','','3.890','1','32.00','1644000','0','0','17800','2840000','0','0','0','2840000','VAN','00045385','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBX-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.890',berat_jual_asli=berat_jual_asli+'3.890',stock_jual='1',berat_akhir=berat_akhir-'3.890',berat_akhir_asli=berat_akhir_asli-'3.890',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSPLT-ZGBX-65-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-260730-0008','2026-07-30','3.890','2026-07-30','18:03:48','PLG0013775','2840000','2840000','0','2840000','0','sby','2026-07-30 18:03:48','FJ-260730-0008','DP-02717','2000000');
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-07-30','FJ-260730-0008','2026-07-30','18:03:48','VAN','2840000','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-260730-0006','2026-07-30','2026-07-30 18:03:48','PENJUALAN : FJ-260730-0008','','TBC','840000','840000','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-260730-0007','D','2026-07-30','18:03:48','TBC','PENJUALAN','FJ-260730-0008','25533516564','840000','25534356564','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='840000' WHERE no_faktur_jual='FJ-260730-0008' 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-03158','PUT','1','GOLD','WEDRING','','','2.000','','50.00','1','2290000','1800000','0','900000','4500000','zircon 14','sz 12 crom putih gllosy','grf Rakhi & Yumna font Berkshire','140000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0007','2026-07-30','2026-07-30 18:08:41','PESANAN : DP-03158','.','TBC','3712000','3712000');
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-260730-0008','D','2026-07-30','18:08:41','TBC','PESANAN','DP-03158','25534356564','3712000','25538068564','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-03158','2026-07-30','2026-07-30','18:08:41','PLG0013776','PUT','2026-08-25','kasirbip','2026-07-30 18:08:41','2.000','0','0','0','3712000','0','900000','4640000','4640000','928000');
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-260730-0009','kasir','1',' DP-02825MM','TOKO','MMPSN','PSPRT-ZGBH-7-0','CINCIN PERAK SR-03 YL-01 ','','3.230','1','100.00','330000','0','0','17800','950000','0','0','0','950000','ALIKA','00045655','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSPRT-ZGBH-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260730-0009','2026-07-30','3.230','2026-07-30','18:08:55','PLG0013777','950000','950000','0','950000','0','kasir','2026-07-30 18:08:55','FJ-260730-0009','DP-02825','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-07-30','FJ-260730-0009','2026-07-30','18:08:55','ALIKA','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-260730-0009' 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-03159','PUT','1','PLD','WEDRING','','','7.000','','25.00','1','1200000','550000','0','750000','4600000','sz 28 crom putih doff amplas','grf Yumna & Rakhi font Berkshire','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0008','2026-07-30','2026-07-30 18:11:09','PESANAN : DP-03159','.','TBC','3680000','3680000');
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-260730-0009','D','2026-07-30','18:11:09','TBC','PESANAN','DP-03159','25538068564','3680000','25541748564','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-03159','2026-07-30','2026-07-30','18:11:09','PLG0013778','PUT','2026-08-25','kasirbip','2026-07-30 18:11:09','7.000','0','0','0','3680000','0','750000','4600000','4600000','920000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-30 ','18:12:11');
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-260730-0010','kasir','1',' DP-02737MM','TOKO','MMPSN','PSGT-ZGBI-18-0','CINCIN EMAS ','','1.970','1','83.00','3820000','0','0','17800','5553000','0','0','0','5553000','ELLA','00045719','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBI-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSGT-ZGBI-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260730-0010','2026-07-30','1.970','2026-07-30','18:14:04','PLG0013779','5553000','5553000','0','5553000','0','kasir','2026-07-30 18:14:03','FJ-260730-0010','DP-02737','4496000');
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-07-30','FJ-260730-0010','2026-07-30','18:14:04','ELLA','5553000','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-260730-0009','2026-07-30','2026-07-30 18:14:03','PENJUALAN : FJ-260730-0010','.','TBC','1057000','1057000','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-260730-0010','D','2026-07-30','18:14:04','TBC','PENJUALAN','FJ-260730-0010','25541748564','1057000','25542805564','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='1057000' WHERE no_faktur_jual='FJ-260730-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260730-0011','jogja','1',' 500K-165-0','TOKO','JOGPER','PJOG-ZFAA-50-0','CINCIN SILVER 925 YL-01 ','','1.890','1','100.00','193000','0','0','17800','600000','0','0','0','600000','SAB','00044249','PJOG','0','0','-','0','CINCIN PRIA');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PJOG-ZFAA-50-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-260730-0011','2026-07-30','1.890','2026-07-30','18:15:02','PLG0013780','600000','600000','0','600000','600000','jogja','2026-07-30 18:15:02','FJ-260730-0011','','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-07-30','FJ-260730-0011','2026-07-30','18:15:02','SAB','600000','0');
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 ('KM-260730-0002','D','2026-07-30','18:15:02','jogja','PENJUALAN','FJ-260730-0011','652300','600000','1252300','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260730-0011' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260730-0012','jogja',' 1',' 850K-10-00','TOKO','JOGPER','PJOG-ZFAA-112-0','CINCIN SILVER 925 ','','1.210','1','100.00','124000','0','0','17800','1000000','0','0','0','1000000','SAB','00044311','PJOG','0','0','-','0','CINCIN PRIA');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PJOG-ZFAA-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-260730-0012','2026-07-30','1.210','2026-07-30','18:15:02','PLG0013781','1000000','1000000','0','1000000','1000000','jogja','2026-07-30 18:15:02','FJ-260730-0011','','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-07-30','FJ-260730-0012','2026-07-30','18:15:02','SAB','1000000','0');
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 ('KM-260730-0003','D','2026-07-30','18:15:02','jogja','PENJUALAN','FJ-260730-0012','1252300','1000000','2252300','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260730-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0012';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','18:21:43');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03160','NAD','1','PER','WEDRING PROMO','','','5.000','','925.00','1','100000','0','1600000','0','1600000','sz cwe 8 CP.11 grf Linda','sz cwo 19 CP.11 grf Azreal','EXPRESS 100.000 Font Vladimir','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0010','2026-07-30','2026-07-30 18:27:58','PESANAN : DP-03160','.','TBC','1600000','1600000');
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-260730-0011','D','2026-07-30','18:27:58','TBC','PESANAN','DP-03160','25542805564','1600000','25544405564','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-03160','2026-07-30','2026-07-30','18:27:58','PLG0013782','NAD','2026-08-13','kasirbip','2026-07-30 18:27:58','5.000','0','0','0','1600000','0','0','1600000','1600000','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-03161','ALIKA','1','GOLD','WEDING RING','','','3.000','','375.00','1','2290000','1400000','0','700000','4900000','size 14.5 grf Heri','zircone 1 butir','crom putih doff semprot setengah','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-260730-0011','2026-07-30','2026-07-30 18:29:44','PESANAN : DP-03161','0','TBC','3920000','3920000');
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-260730-0012','D','2026-07-30','18:29:44','TBC','PESANAN','DP-03161','25544405564','3920000','25548325564','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-03161','2026-07-30','2026-07-30','18:29:44','PLG0013783','ALIKA','2026-08-31','kasir','2026-07-30 18:29:44','3.000','0','0','0','3920000','0','700000','4900000','4900000','980000');
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-03162','DIL','1','PLD','WEDD RING PRIA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','PERMATA 1 BUTIR','SIZE 20.5 GRF: A ?? R (BERKSHIRE)','CROM PUTIH GLOSSY MIX DOFF KANAN KIRI','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-260730-0012','2026-07-30','2026-07-30 18:33:17','PESANAN : DP-03162','-','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-260730-0013','D','2026-07-30','18:33:17','TBC','PESANAN','DP-03162','25548325564','2000000','25550325564','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-03162','2026-07-30','2026-07-30','18:33:17','PLG0013784','DIL','2026-08-09','sby','2026-07-30 18:33:17','4.000','0','0','0','2000000','0','800000','3010000','3010000','1010000');
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-03163','ALIKA','1','PER','WEDING RING','','','4.000','','925.00','1','100000','0','0','0','850000','size 26','grf Elis','crom putih doff semprot setengah','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0013','2026-07-30','2026-07-30 18:34:59','PESANAN : DP-03163','0','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-260730-0014','D','2026-07-30','18:34:59','TBC','PESANAN','DP-03163','25550325564','850000','25551175564','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-03163','2026-07-30','2026-07-30','18:34:59','PLG0013785','ALIKA','2026-08-31','kasir','2026-07-30 18:34:59','4.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-03164','DIL','1','PLD','WEDD RING WANITA','','','2.500','','25.00','1','1200000','550000','0','850000','2225000','PERMATA 9 BUTIR','SIZE 13 GRF: R ?? A (BERKSHIRE)','CROM PUTIH GLOSSY','90000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0014','2026-07-30','2026-07-30 18:35:16','PESANAN : DP-03164','-','TBC','1500000','1500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260730-0015','D','2026-07-30','18:35:16','TBC','PESANAN','DP-03164','25551175564','1500000','25552675564','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-03164','2026-07-30','2026-07-30','18:35:16','PLG0013786','DIL','2026-08-09','sby','2026-07-30 18:35:16','2.500','0','0','0','1500000','0','850000','2315000','2315000','815000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','19:08:00');
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-260730-0013','kasir','1',' DP-03053MM','TOKO','MMPSN','PSPLT-ZGBI-19-0','CINCIN PALADIUM ','','3.440','1','17.00','773000','0','0','17800','1954000','0','0','0','1954000','ELLA','00045720','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBI-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.440',berat_jual_asli=berat_jual_asli+'3.440',stock_jual='1',berat_akhir=berat_akhir-'3.440',berat_akhir_asli=berat_akhir_asli-'3.440',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='PSPLT-ZGBI-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260730-0013','2026-07-30','3.440','2026-07-30','19:24:44','PLG0013787','1954000','1954000','0','1954000','0','kasir','2026-07-30 19:24:43','FJ-260730-0013','DP-03053','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-07-30','FJ-260730-0013','2026-07-30','19:24:44','ELLA','1954000','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-260730-0015','2026-07-30','2026-07-30 19:24:43','PENJUALAN : FJ-260730-0013','.','TBC','234000','234000','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-260730-0016','D','2026-07-30','19:24:44','TBC','PENJUALAN','FJ-260730-0013','25552675564','234000','25552909564','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='234000' WHERE no_faktur_jual='FJ-260730-0013' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-30 ','19:24:37');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0013';
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-00000365','X-00000365','CINCIN KAWIN SIRKON','GR','---','CKS','BELI','BELI001','1200000','2026-07-30','1.500','1','kasir','2026-07-30 19:30:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-CKS';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CKS','X-00000365','X-00000365');
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-260730-0001','-','SULIS','1','BELI','BELI001','CKS', 'X-00000365', 'CINCIN KAWIN SIRKON','1.500','1.500','375.00','3000000','1200000','800000','1','1200000','1200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CKS' 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-260730-0001','2026-07-30','2026-07-30','19:30:51','SULIS','---','1.500','1200000','1200000','1200000','1200000','1200000','kasir','2026-07-30 19:30:52','FB-260730-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260730-0001','-','-','','','','kasir','2026-07-30 19:30:52');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0016','2026-07-30','2026-07-30 19:30:52','PEMBELIAN UMUM : FB-260730-0001','-','TBC','1200000','1200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260730-0017','K','2026-07-30','19:30:51','TBC','PEMBELIAN UMUM','FB-260730-0001','25552909564','1200000','25551709564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260730-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260730-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','19:47:39');
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-260730-0014','kasir','1',' TFAMR75-83','TOKO','TFAMP','TFAMR-ZGBA-13-0','THIFA ANTING MAS RG ','','1.300','1','83.00','2510000','0','0','17800','2560000','0','0','0','2560000','FIR','00045406','TFAMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFAMR-ZGBA-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='TFAMR-ZGBA-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFAMP' 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-260730-0014','2026-07-30','1.300','2026-07-30','19:52:30','PLG0013788','2560000','2560000','0','2560000','0','kasir','2026-07-30 19:52:30','FJ-260730-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-07-30','FJ-260730-0014','2026-07-30','19:52:30','FIR','2560000','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-260730-0017','2026-07-30','2026-07-30 19:52:30','PENJUALAN : FJ-260730-0014','.','TBC','2560000','2560000','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-260730-0018','D','2026-07-30','19:52:30','TBC','PENJUALAN','FJ-260730-0014','25551709564','2560000','25554269564','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='2560000' WHERE no_faktur_jual='FJ-260730-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260730-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260730-0014';
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-260730-0004','K','2026-07-30','19:59:44','kasir','KAS BESAR','AMBIL UANG','2252300','1600000','652300');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-30 ','20:31:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-30 ','20:31:53');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03165','VAN','1','PLD','WEDDRING WANITA','','','2.500','','10.00','1','1200000','350000','0','1000000','1875000','MOISONITE','PERMATA ZIRKON 32 PUTIH GLOSSY','GRF: T&C FONT: BRUSH SCRIPT','500000','320000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0018','2026-07-30','2026-07-30 20:36:02','PESANAN : DP-03165','-','TBC','1500000','1500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260730-0019','D','2026-07-30','20:36:02','TBC','PESANAN','DP-03165','25554269564','1500000','25555769564','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-03165','2026-07-30','2026-07-30','20:36:02','PLG0013789','VAN','2026-08-23','sby','2026-07-30 20:36:02','2.500','0','0','0','1500000','0','1000000','2695000','2695000','1195000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-30 ','21:01:25');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03166','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','37.50','1','2290000','1400000','0','950000','4450000','PERMATA 23','SIZE: 9 GRF: Dyan??Dzaki FONT: VINTAGE','PUTIH','230000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260730-0019','2026-07-30','2026-07-30 21:17:23','PESANAN : DP-03166','-','TBC','3000000','3000000');
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-260730-0020','D','2026-07-30','21:17:23','TBC','PESANAN','DP-03166','25555769564','3000000','25558769564','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-03166','2026-07-30','2026-07-30','21:17:23','PLG0013790','VAN','2026-08-22','sby','2026-07-30 21:17:23','2.500','0','0','0','3000000','0','950000','4680000','4680000','1680000');
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-03167','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','PERMATA 1','SIZE: 9.5 GRF: Dyan??Dzaki','FONT: VINTAGE PUTIH GLOSSY','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-260730-0020','2026-07-30','2026-07-30 21:20:02','PESANAN : DP-03167','-','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-260730-0021','D','2026-07-30','21:20:02','TBC','PESANAN','DP-03167','25558769564','2000000','25560769564','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-03167','2026-07-30','2026-07-30','21:20:02','PLG0013791','VAN','2026-08-22','sby','2026-07-30 21:20:02','4.000','0','0','0','2000000','0','800000','3010000','3010000','1010000');
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-03168','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','PERMATA 1','SIZE: 9.5 GRF: Dyan??Dzaki','FONT: VINTAGE PUTIH GLOSSY','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-260730-0021','2026-07-30','2026-07-30 21:20:48','PESANAN : DP-03168','-','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-260730-0022','D','2026-07-30','21:20:48','TBC','PESANAN','DP-03168','25560769564','2000000','25562769564','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-03168','2026-07-30','2026-07-30','21:20:48','PLG0013792','VAN','2026-08-22','sby','2026-07-30 21:20:48','4.000','0','0','0','2000000','0','800000','3010000','3010000','1010000');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-31','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-30';
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-07-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-30' 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-260731-0001','D','2026-07-31','21:24:57','TBC','SALDO AWAL','SALDO AWAL','0','25562769564','25562769564');
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-260731-0001','D','2026-07-31','21:24:57','BCK','SALDO AWAL','SALDO AWAL','0','1996308000','1996308000');
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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','','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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','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-260731-0001','D','2026-07-31','21:24:57','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
UPDATE tp_system SET tgl_system='2026-07-31';