INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-05-04 ','08:03:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-05-04 ','08:20:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-05-04 ','08:44:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','09:56:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','10:02:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','10:07:47');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-03';
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-05-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-03' 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-260504-0001','D','2026-05-04','10:08:11','TBC','SALDO AWAL','SALDO AWAL','0','22132910514','22132910514');
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-260504-0001','D','2026-05-04','10:08:11','BCD','SALDO AWAL','SALDO AWAL','0','1361288500','1361288500');
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-260504-0001','D','2026-05-04','10:08:11','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-260504-0001','D','2026-05-04','10:08:11','','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-260504-0001','D','2026-05-04','10:08:11','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-260504-0001','D','2026-05-04','10:08:11','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-260504-0001','D','2026-05-04','10:08:11','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-260504-0001','D','2026-05-04','10:08:11','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-260504-0001','D','2026-05-04','10:08:11','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-260504-0001','D','2026-05-04','10:08:11','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-260504-0001','D','2026-05-04','10:08:11','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
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-260504-0001','D','2026-05-04','10:08:11','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
UPDATE tp_system SET tgl_system='2026-05-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','10:12: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-02059','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1550000','0','1550000','cwe sz 15 putih glosy gr H&D','cwo sz 27 putih dof amplass grf D&H','font berkshire swash','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260504-0001','2026-05-04','2026-05-04 10:15:04','PESANAN : DP-02059','.','TBC','1550000','1550000');
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-260504-0002','D','2026-05-04','10:15:04','TBC','PESANAN','DP-02059','22132910514','1550000','22134460514','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-02059','2026-05-04','2026-05-04','10:15:04','PLG0010836','SULIS','2026-05-05','kasirbip','2026-05-04 10:15:04','2.000','0','0','0','1550000','0','0','1550000','1550000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','10:40:12');
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-20260504-0001','1','PSPRT-ZEXD-3-0','1','5.080','5.080','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEXD-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEXD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEXD-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEXD-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-05-04 10:40:26' WHERE kode_barang='PSPRT-ZEXD-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEXD-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-04 10:40:26','TOKO','MMPSN','PSPRT','PSPRT-ZEXD-3-0','1','5.080','5.080','1','5.080','5.080','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-ZEXD-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEXD-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-05-04' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260504-0001','2026-05-04','10:40','5.080','kasir','2026-05-04 10:40:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','10:48:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','10:55:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','11:04:25');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-04',  status ='CLOS' WHERE no_service='SV-01973';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01973';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','11:41:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-05-04 ','11:42:47');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','11:52:03');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02020','GIN','1','SEPASANG','CWE PUTIH GLOSY CWO PUTIH DOFF AMPLASST SZ 14 GRF JGN HILANG','2.000','1','100000','100000');
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-260504-0002','2026-05-04','2026-05-04 12:03:12','SERVICE : SV-02020','.','TBC','100000','100000','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-260504-0003','D','2026-05-04','12:03:12','TBC','SERVICE','SV-02020','22134460514','100000','22134560514','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-02020','2026-05-04','2026-05-04','12:03:12','PLG0010837','kasirbip','2026-05-19','kasirbip','2026-05-04 12:03:12','2.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','12:03:42');
UPDATE tt_service_head SET tgl_selesai='2026-05-04',  status ='DONE' WHERE no_service='SV-01977';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01977';
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-260504-0001','kasirbip','1',' 750K-14-24','TOKO','BIPPER','PBDG-ZDAE-3-0','CINCIN SILVER 925 ','','2.850','1','100.00','291000','0','0','17000','850000','0','0','0','850000','SULIS','00042547','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAE-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.850',berat_jual_asli=berat_jual_asli+'2.850',stock_jual='1',berat_akhir=berat_akhir-'2.850',berat_akhir_asli=berat_akhir_asli-'2.850',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='PBDG-ZDAE-3-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-260504-0001','2026-05-04','2.850','2026-05-04','12:33:59','PLG0010838','850000','850000','0','850000','0','kasirbip','2026-05-04 12:33:59','FJ-260504-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-05-04','FJ-260504-0001','2026-05-04','12:33:59','SULIS','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-260504-0003','2026-05-04','2026-05-04 12:33:59','PENJUALAN : FJ-260504-0001','.','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-260504-0004','D','2026-05-04','12:33:59','TBC','PENJUALAN','FJ-260504-0001','22134560514','850000','22135410514','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-260504-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-260504-0002','kasirbip',' 1',' 700K-10-19','TOKO','BIPPER','PBDG-YKBE-90-0','CINCIN SILVER 925 ','','1.570','1','100.00','97000','0','0','17000','850000','0','0','0','850000','SULIS','00039922','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='PBDG-YKBE-90-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-260504-0002','2026-05-04','1.570','2026-05-04','12:33:59','PLG0010839','850000','850000','0','850000','0','kasirbip','2026-05-04 12:33:59','FJ-260504-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-05-04','FJ-260504-0002','2026-05-04','12:33:59','SULIS','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-260504-0004','2026-05-04','2026-05-04 12:33:59','PENJUALAN : FJ-260504-0002','.','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-260504-0005','D','2026-05-04','12:33:59','TBC','PENJUALAN','FJ-260504-0002','22135410514','850000','22136260514','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='1700000' WHERE no_faktur_jual='FJ-260504-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260504-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260504-0002';
UPDATE tt_service_head SET tgl_selesai='2026-05-04',  status ='DONE' WHERE no_service='SV-01992';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01992';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-04 ','13:36:19');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02021','ASRI','1','PLD','GRAFIR GANTI FONT DAN DIBUAT ATAS BAWAH','4.060','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-02021','2026-05-04','2026-05-04','13:41:45','PLG0010840','kasir','2026-05-07','kasir','2026-05-04 13:41:45','4.060','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','14:04:12');
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-02060','KUR','1','PER','CINCIN KAWIN SILVER','','','3.000','','92.50','1','100000','0','850000','0','850000','size 16 putih dof semprot sepinggang sirkon 1buah','font brush script grafir','bikin seperti contoh','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-260504-0005','2026-05-04','2026-05-04 14:09:29','PESANAN : DP-02060','.','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-260504-0006','D','2026-05-04','14:09:29','TBC','PESANAN','DP-02060','22136260514','850000','22137110514','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-02060','2026-05-04','2026-05-04','14:09:29','PLG0010841','KUR','2026-05-18','kasirbip','2026-05-04 14:09:29','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','14:12:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','14:12:57');
UPDATE tp_curr SET rp= '17400.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '17400.00', 'kasir','2026-05-04 14:35:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','14:37:17');
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-260504-0003','kasirbip','1',' DP-01883BI','TOKO','BIPPSN','PSPRT-ZDCX-7-0','CINCIN PERAK ','','2.940','1','100.00','300000','0','0','17400','900000','0','0','0','900000','SULIS','00042964','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZDCX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.940',berat_jual_asli=berat_jual_asli+'2.940',stock_jual='1',berat_akhir=berat_akhir-'2.940',berat_akhir_asli=berat_akhir_asli-'2.940',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='PSPRT-ZDCX-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260504-0003','2026-05-04','2.940','2026-05-04','14:42:58','PLG0010842','900000','900000','0','900000','0','kasirbip','2026-05-04 14:42:57','FJ-260504-0003','DP-01883','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-05-04','FJ-260504-0003','2026-05-04','14:42:58','SULIS','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-260504-0006','2026-05-04','2026-05-04 14:42:57','PENJUALAN : FJ-260504-0003','.','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-260504-0007','D','2026-05-04','14:42:58','TBC','PENJUALAN','FJ-260504-0003','22137110514','900000','22138010514','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-260504-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-260504-0004','kasirbip',' 1',' DP-01884BI','TOKO','BIPPSN','PSGT-ZDBG-28-0','CINCIN EMAS ','','3.930','1','83.00','8319000','0','0','17400','10132000','0','0','0','10132000','SULIS','00042803','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZDBG-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.930',berat_jual_asli=berat_jual_asli+'3.930',stock_jual='1',berat_akhir=berat_akhir-'3.930',berat_akhir_asli=berat_akhir_asli-'3.930',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='PSGT-ZDBG-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-260504-0004','2026-05-04','3.930','2026-05-04','14:42:58','PLG0010843','10132000','10132000','0','10132000','0','kasirbip','2026-05-04 14:42:57','FJ-260504-0003','DP-01884','8240000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-04','FJ-260504-0004','2026-05-04','14:42:58','SULIS','10132000','0');
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-260504-0004' 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-02061','KUR','1','PLD','CINCIN KAWIN','','','2.000','','10.00','1','1200000','300000','0','750000','1350000','size 10 font comic suns grafir','sirkon 13 putih kilat','bikin seperti contoh gambar','0','130000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260504-0007','2026-05-04','2026-05-04 15:27:08','PESANAN : DP-02061','.','TBC','1184000','1184000');
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-260504-0008','D','2026-05-04','15:27:08','TBC','PESANAN','DP-02061','22138010514','1184000','22139194514','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-02061','2026-05-04','2026-05-04','15:27:08','PLG0010844','KUR','2026-05-18','kasirbip','2026-05-04 15:27:08','2.000','0','0','0','1184000','0','750000','1480000','1480000','296000');
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-02062','KUR','1','PLD','CINCIN KAWIN','','','3.000','','10.00','1','1200000','300000','0','750000','1650000','size 15 font comic suns grafir','dof semprot sepinggang putih tanpa mata','bikin seoerti contoh gambar','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-260504-0008','2026-05-04','2026-05-04 15:34:17','PESANAN : DP-02062','.','TBC','1320000','1320000');
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-260504-0009','D','2026-05-04','15:34:17','TBC','PESANAN','DP-02062','22139194514','1320000','22140514514','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-02062','2026-05-04','2026-05-04','15:34:17','PLG0010845','KUR','2026-06-06','kasirbip','2026-05-04 15:34:17','3.000','0','0','0','1320000','0','750000','1650000','1650000','330000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260504-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260504-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260504-0004';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02022','KUR','1','1PS CINCN KAWIN','CINCIN CEWE PASANG MATA SIRKON1DAN CROM PUTIH DOFAMPLAS SEPINGGANG BULATIN CINCIN COWO KROM ULANG PUTIH DOF AMPLAS SEPINGGANG NAMA JANGAN ILANG','5.000','1','150000','150000');
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-260504-0009','2026-05-04','2026-05-04 16:11:00','SERVICE : SV-02022','.','TBC','150000','150000','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-260504-0010','D','2026-05-04','16:11:00','TBC','SERVICE','SV-02022','22140514514','150000','22140664514','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-02022','2026-05-04','2026-05-04','16:11:00','PLG0010846','kasirbip','2026-05-05','kasirbip','2026-05-04 16:11:00','5.000','0','0','0','150000','0','150000','150000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','16:14:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','16:36:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','17:48:42');
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-02063','SULIS ','1','GOLD','WED RING','','','2.500','','37.50','1','2500000','1500000','0','700000','4450000','kuning doff semprot 1 zikon','sz 12 font vintage rotter','grf Dion','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-260504-0010','2026-05-04','2026-05-04 18:06:49','PESANAN : DP-02063','.','TBC','3560000','3560000');
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-260504-0011','D','2026-05-04','18:06:49','TBC','PESANAN','DP-02063','22140664514','3560000','22144224514','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-02063','2026-05-04','2026-05-04','18:06:49','PLG0010847','SULIS ','2026-06-04','kasirbip','2026-05-04 18:06:49','2.500','0','0','0','3560000','0','700000','4450000','4450000','890000');
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-02064','SULIS ','1','GOLD','WED RING','','','3.000','','37.50','1','2500000','1500000','0','500000','5000000','putih doff amplas','sz 18 font vinatge rotter','grf Seni','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260504-0011','2026-05-04','2026-05-04 18:08:41','PESANAN : DP-02064','.','TBC','4000000','4000000');
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-260504-0012','D','2026-05-04','18:08:41','TBC','PESANAN','DP-02064','22144224514','4000000','22148224514','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-02064','2026-05-04','2026-05-04','18:08:41','PLG0010848','SULIS ','2026-06-04','kasirbip','2026-05-04 18:08:41','3.000','0','0','0','4000000','0','500000','5000000','5000000','1000000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-04 ','18:55:17');
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-260504-0005','kasir','1',' PLDMM-0000','TOKO','MMPLD','PLDMM-YLAA-2-0','CINCIN PALADIUM PLDMM-00007 ','','4.650','1','6.00','688000','0','0','17400','1395000','0','700000','0','2095000','ELLA','00040537','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-YLAA-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.650',berat_jual_asli=berat_jual_asli+'4.650',stock_jual='1',berat_akhir=berat_akhir-'4.650',berat_akhir_asli=berat_akhir_asli-'4.650',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='PLDMM-YLAA-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' 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-260504-0005','2026-05-04','4.650','2026-05-04','19:49:49','PLG0010849','1395000','1395000','700000','2095000','0','kasir','2026-05-04 19:49:48','FJ-260504-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-05-04','FJ-260504-0005','2026-05-04','19:49:49','ELLA','2095000','700000');
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-260504-0012','2026-05-04','2026-05-04 19:49:48','PENJUALAN : FJ-260504-0005','0','TBC','2095000','2095000','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-260504-0013','D','2026-05-04','19:49:49','TBC','PENJUALAN','FJ-260504-0005','22148224514','2095000','22150319514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2095000' WHERE no_faktur_jual='FJ-260504-0005' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02023','ELLA','1','PLD','SIZE 18 CROM ULANG SESUAI WARNA DI MODEL','4650.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-02023','2026-05-04','2026-05-04','19:52:48','PLG0010850','kasir','2026-05-05','kasir','2026-05-04 19:52:48','4650.000','0','0','0','0','0','0','0','0');