INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','10:12:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','10:46:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','13:52:33');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01157','NITA','1','PLD','WEDDING RING','','','2.000','','10.00','1','1736000','250000','0','750000','1250000','zirkon 12butir','size 12 grf NH ?? THM 15.11.2025','krum putih glosy spt contoh','120000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0001','2025-09-28','2025-09-27 14:32:44','PESANAN : DP-01157','.','TBC','685000','685000');
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-250928-0002','D','2025-09-28','14:32:44','TBC','PESANAN','DP-01157','16712679414','685000','16713364414','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-01157','2025-09-28','2025-09-28','14:32:44','PLG0006619','NITA','2025-10-20','kasir','2025-09-27 14:32:44','2.000','0','0','0','685000','0','750000','1370000','1370000','685000');
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-250927-0001','kasir','1',' DP-01125BI','TOKO','BIPPSN','PSPLT-YIBE-39-0','CINCIN PALADIUM ','','2.830','1','15.00','932000','0','0','16700','2073500','0','0','0','2073500','HELMI','00038926','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIBE-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.830',berat_jual_asli=berat_jual_asli+'2.830',stock_jual='1',berat_akhir=berat_akhir-'2.830',berat_akhir_asli=berat_akhir_asli-'2.830',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPLT-YIBE-39-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-250927-0001','2025-09-28','2.830','2025-09-27','14:42:08','PLG0006620','2073500','2073500','0','2073500','0','kasir','2025-09-27 14:42:07','FJ-250927-0001','DP-01125','1075000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0001','2025-09-27','14:42:08','HELMI','2073500','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-250928-0002','2025-09-28','2025-09-27 14:42:07','PENJUALAN : FJ-250927-0001','.','TBC','998500','998500','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-250928-0003','D','2025-09-28','14:42:08','TBC','PENJUALAN','FJ-250927-0001','16713364414','998500','16714362914','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='998500' WHERE no_faktur_jual='FJ-250927-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0001';
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-01158','NITA','1','PER','WEDDING RING','','','5.000','','925.00','1','25000','0','700000','0','700000','zirkon 1 butir sz 205','grf NH ?? THM 15.11.2025','KRUM PTH DUFF SEMPROT','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-250928-0003','2025-09-28','2025-09-27 15:08:36','PESANAN : DP-01158','.','TBC','700000','700000');
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-250928-0004','D','2025-09-28','15:08:36','TBC','PESANAN','DP-01158','16714362914','700000','16715062914','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-01158','2025-09-28','2025-09-28','15:08:36','PLG0006621','NITA','2025-10-20','kasir','2025-09-27 15:08:36','5.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0002','kasir','1',' DP-01109BI','TOKO','BIPPSN','PSPRT-YIBE-29-0','CINCIN PERAK ','','0.950','1','100.00','25000','0','0','16700','700000','0','0','0','700000','SUL','00038916','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIBE-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIBE-29-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-250927-0002','2025-09-28','0.950','2025-09-27','15:41:50','PLG0006622','700000','700000','0','700000','0','kasir','2025-09-27 15:41:49','FJ-250927-0002','DP-01109','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0002','2025-09-27','15:41:50','SUL','700000','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-250927-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0002';
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-01159','HELMI','1','PLD','WEDDING RING','','','2.000','','10.00','1','1736000','250000','0','750000','1250000','zirkon 15butir','size 11 grf Gisela & Andri','krum putih spt contoh','150000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0004','2025-09-28','2025-09-27 16:11:46','PESANAN : DP-01159','.','TBC','700000','700000');
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-250928-0005','D','2025-09-28','16:11:46','TBC','PESANAN','DP-01159','16715062914','700000','16715762914','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-01159','2025-09-28','2025-09-28','16:11:46','PLG0006623','HELMI','2025-10-27','kasir','2025-09-27 16:11:46','2.000','0','0','0','700000','0','750000','1400000','1400000','700000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01160','HELMI','1','PLD','WEDDING RING','','','2.500','','10.00','1','1736000','250000','0','700000','1325000','size 14.5 grf Gisela & Andri','model seperti contoh','krum putih doff semprot','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-250928-0005','2025-09-28','2025-09-27 16:15:01','PESANAN : DP-01160','.','TBC','662500','662500');
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-250928-0006','D','2025-09-28','16:15:01','TBC','PESANAN','DP-01160','16715762914','662500','16716425414','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-01160','2025-09-28','2025-09-28','16:15:01','PLG0006624','HELMI','2025-10-27','kasir','2025-09-27 16:15:01','2.500','0','0','0','662500','0','700000','1325000','1325000','662500');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','16:31:40');
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-250927-0003','kasir','1',' 700K-21-15','TOKO','BIPPER','PBDG-YGBH-35-0','CINCIN SILVER 925 ','','4.630','1','100.00','95000','0','0','16700','700000','0','0','0','700000','NITA','00037617','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YGBH-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.630',berat_jual_asli=berat_jual_asli+'4.630',stock_jual='1',berat_akhir=berat_akhir-'4.630',berat_akhir_asli=berat_akhir_asli-'4.630',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBDG-YGBH-35-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-250927-0003','2025-09-28','4.630','2025-09-27','16:31:59','PLG0006625','700000','700000','0','700000','0','kasir','2025-09-27 16:31:58','FJ-250927-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0003','2025-09-27','16:31:59','NITA','700000','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-250928-0006','2025-09-28','2025-09-27 16:31:58','PENJUALAN : FJ-250927-0003','.','TBC','700000','700000','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-250928-0007','D','2025-09-28','16:31:59','TBC','PENJUALAN','FJ-250927-0003','16716425414','700000','16717125414','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='700000' WHERE no_faktur_jual='FJ-250927-0003' 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-01299','NISA','1','1 PCS CINCIN SLV','GRAFIR RISA','3.230','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-01299','2025-09-28','2025-09-28','16:32:43','PLG0006626','kasir','2025-09-29','kasir','2025-09-27 16:32:43','3.230','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0003';
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-250927-0004','kasir','1',' 500K-16-00','TOKO','MMPER','PMM-YFBX-14-0','CINCIN SILVER 925 ','','3.230','1','100.00','75000','0','0','16700','500000','0','0','0','500000','NIS','00036455','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-14-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='2025-09-28' AND kode_barang='PMM-YFBX-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0004','2025-09-28','3.230','2025-09-27','16:34:54','PLG0006627','500000','500000','0','500000','0','kasir','2025-09-27 16:34:54','FJ-250927-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0004','2025-09-27','16:34:54','NIS','500000','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-250928-0007','2025-09-28','2025-09-27 16:34:54','PENJUALAN : FJ-250927-0004','.','TBC','500000','500000','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-250928-0008','D','2025-09-28','16:34:54','TBC','PENJUALAN','FJ-250927-0004','16717125414','500000','16717625414','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='500000' WHERE no_faktur_jual='FJ-250927-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-01161','HELMI','1','GOLD','WEDDING RING','','','2.000','','75.00','1','2000000','1800000','0','750000','4350000','zirkon 10butir','size 12 grf Robby.J.S','MODEL SPT CONTOH KRUM PUTIH','100000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0008','2025-09-28','2025-09-27 16:38:22','PESANAN : DP-01161','.','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-250928-0009','D','2025-09-28','16:38:22','TBC','PESANAN','DP-01161','16717625414','3560000','16721185414','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-01161','2025-09-28','2025-09-28','16:38:22','PLG0006628','HELMI','2025-10-25','kasir','2025-09-27 16:38:22','2.000','0','0','0','3560000','0','750000','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-01162','HELMI','1','PER','WEDDING RING','','','5.000','','925.00','1','25000','0','700000','0','700000','size 20 grf Sephia Vira','model seperti contoh','krum kombinasi RG','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-250928-0009','2025-09-28','2025-09-27 16:42:10','PESANAN : DP-01162','.','TBC','700000','700000');
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-250928-0010','D','2025-09-28','16:42:10','TBC','PESANAN','DP-01162','16721185414','700000','16721885414','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-01162','2025-09-28','2025-09-28','16:42:10','PLG0006629','HELMI','2025-10-25','kasir','2025-09-27 16:42:10','5.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','17:06:10');
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-250927-0005','kasir','1',' 500K-16-16','TOKO','BIPPER','PBDG-YIAH-7-0','CINCIN SILVER 925 ','','1.890','1','100.00','49000','0','0','16700','400000','0','0','0','400000','HELMI','00038805','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIAH-7-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='2025-09-28' AND kode_barang='PBDG-YIAH-7-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-250927-0005','2025-09-28','1.890','2025-09-27','17:16:54','PLG0006630','400000','400000','0','400000','0','kasir','2025-09-27 17:16:53','FJ-250927-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('2025-09-28','FJ-250927-0005','2025-09-27','17:16:54','HELMI','400000','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-250928-0010','2025-09-28','2025-09-27 17:16:53','PENJUALAN : FJ-250927-0005','.','TBC','400000','400000','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-250928-0011','D','2025-09-28','17:16:54','TBC','PENJUALAN','FJ-250927-0005','16721885414','400000','16722285414','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='400000' WHERE no_faktur_jual='FJ-250927-0005' 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-250927-0006','kasir',' 1',' 700K-13-16','TOKO','BIPPER','PBDG-YIXI-13-0','CINCIN SILVER 925 ','','1.240','1','100.00','32000','0','0','16700','399000','0','0','0','399000','HELMI','00038655','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIXI-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBDG-YIXI-13-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-250927-0006','2025-09-28','1.240','2025-09-27','17:16:54','PLG0006631','399000','399000','0','399000','0','kasir','2025-09-27 17:16:53','FJ-250927-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('2025-09-28','FJ-250927-0006','2025-09-27','17:16:54','HELMI','399000','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-250928-0011','2025-09-28','2025-09-27 17:16:53','PENJUALAN : FJ-250927-0006','.','TBC','399000','399000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0012','D','2025-09-28','17:16:54','TBC','PENJUALAN','FJ-250927-0006','16722285414','399000','16722684414','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='799000' WHERE no_faktur_jual='FJ-250927-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','17:17:30');
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-01163','NAD','1','PLD','CINCIN NIKAH','','','3.000','','25.00','1','1736000','450000','','700000','2050000','grafir R A Size 18','krum putih full glosy','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0012','2025-09-28','2025-09-27 17:25:22','PESANAN : DP-01163','.','TBC','1640000','1640000');
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-250928-0013','D','2025-09-28','17:25:22','TBC','PESANAN','DP-01163','16722684414','1640000','16724324414','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-01163','2025-09-28','2025-09-28','17:25:22','PLG0006632','NAD','2025-10-12','kasir','2025-09-27 17:25:22','3.000','0','0','0','1640000','0','700000','2050000','2050000','410000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','18:18:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','18:20:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','18:23:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','19:00:32');
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-250927-0007','kasir','1',' DP-01097BI','TOKO','BIPPSN','PSPLT-YIBE-32-0','CINCIN PALADIUM ','','1.920','1','6.00','253000','0','0','16700','1180000','0','0','0','1180000','HELMI','00038919','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIBE-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPLT-YIBE-32-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-250927-0007','2025-09-28','1.920','2025-09-27','19:03:09','PLG0006633','1180000','1180000','0','1180000','0','kasir','2025-09-27 19:03:09','FJ-250927-0007','DP-01097','725000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0007','2025-09-27','19:03:09','HELMI','1180000','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-250928-0013','2025-09-28','2025-09-27 19:03:09','PENJUALAN : FJ-250927-0007','.','TBC','455000','455000','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-250928-0014','D','2025-09-28','19:03:09','TBC','PENJUALAN','FJ-250927-0007','16724324414','455000','16724779414','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='455000' WHERE no_faktur_jual='FJ-250927-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0008','kasir',' 1',' DP-01096BI','TOKO','BIPPSN','PSGT-YIBD-9-0','CINCIN EMAS ','','1.940','1','83.00','3277000','0','0','16700','4296200','0','0','0','4296200','HELMI','00038886','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YIBD-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSGT-YIBD-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250927-0008','2025-09-28','1.940','2025-09-27','19:03:09','PLG0006634','4296200','4296200','0','4296200','0','kasir','2025-09-27 19:03:09','FJ-250927-0007','DP-01096','4212000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0008','2025-09-27','19:03:09','HELMI','4296200','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-250928-0014','2025-09-28','2025-09-27 19:03:09','PENJUALAN : FJ-250927-0008','.','TBC','84200','84200','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-250928-0015','D','2025-09-28','19:03:09','TBC','PENJUALAN','FJ-250927-0008','16724779414','84200','16724863614','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='539200' WHERE no_faktur_jual='FJ-250927-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-01164','NAD','1','PER','CINCIN NIKAH','','','2.000','','925.00','1','25000','0','850000','','850000','size 13 krum kombinasi rosegold','grafir E W','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0015','2025-09-28','2025-09-27 19:08:01','PESANAN : DP-01164','.','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-250928-0016','D','2025-09-28','19:08:01','TBC','PESANAN','DP-01164','16724863614','850000','16725713614','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-01164','2025-09-28','2025-09-28','19:08:01','PLG0006635','NAD','2025-10-12','kasir','2025-09-27 19:08:01','2.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0008';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01300','NITA','1','CC SILVER','KRUM SPT ASAL FONT YESEVA ONE GRF','4.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-01300','2025-09-28','2025-09-28','19:44:48','PLG0006636','kasir','2025-09-08','kasir','2025-09-27 19:44:48','4.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01301','NISA','1','2 PCS CINCIN SLV','CEWE GRF FEBRI DAN COWO GRF SALSA RESIZE KE 14','4.480','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-01301','2025-09-28','2025-09-28','19:50:09','PLG0006637','kasir','2025-09-29','kasir','2025-09-27 19:50:09','4.480','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01302','NAD','1','2 PCS CINCIN SLV','RESIZE KE 14 DUA DUANYA','5.750','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-01302','2025-09-28','2025-09-28','19:51:08','PLG0006638','kasir','2025-09-29','kasir','2025-09-27 19:51:08','5.750','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','19:51:29');
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-250927-0009','kasir','1',' 700K-16-00','TOKO','MMPER','PMM-YFBX-81-0','CINCIN SILVER 925 ','','3.020','1','100.00','70000','0','0','16700','700000','0','0','0','700000','NAD','00036522','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YFBX-81-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0009','2025-09-28','3.020','2025-09-27','19:52:50','PLG0006639','700000','700000','0','700000','0','kasir','2025-09-27 19:52:50','FJ-250927-0009','','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('2025-09-28','FJ-250927-0009','2025-09-27','19:52:50','NAD','700000','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-250928-0016','2025-09-28','2025-09-27 19:52:50','PENJUALAN : FJ-250927-0009','.','TBC','700000','700000','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-250928-0017','D','2025-09-28','19:52:50','TBC','PENJUALAN','FJ-250927-0009','16725713614','700000','16726413614','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='700000' WHERE no_faktur_jual='FJ-250927-0009' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0010','kasir',' 1',' 850K-12-00','TOKO','MMPER','PMM-YGAX-27-0','CINCIN SILVER 925 ','','2.730','1','100.00','64000','0','0','16700','850000','0','0','0','850000','NAD','00037131','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAX-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.730',berat_jual_asli=berat_jual_asli+'2.730',stock_jual='1',berat_akhir=berat_akhir-'2.730',berat_akhir_asli=berat_akhir_asli-'2.730',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YGAX-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0010','2025-09-28','2.730','2025-09-27','19:52:50','PLG0006640','850000','850000','0','850000','0','kasir','2025-09-27 19:52:50','FJ-250927-0009','','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('2025-09-28','FJ-250927-0010','2025-09-27','19:52:50','NAD','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-250928-0017','2025-09-28','2025-09-27 19:52:50','PENJUALAN : FJ-250927-0010','.','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-250928-0018','D','2025-09-28','19:52:50','TBC','PENJUALAN','FJ-250927-0010','16726413614','850000','16727263614','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='1550000' WHERE no_faktur_jual='FJ-250927-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0010';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0011','kasir','1',' 800K-14-00','TOKO','MMPER','PMM-YFBX-36-0','CINCIN SILVER 925 ','','1.480','1','100.00','35000','0','0','16700','800000','0','0','0','800000','NIS','00036477','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-36-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='2025-09-28' AND kode_barang='PMM-YFBX-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0011','2025-09-28','1.480','2025-09-27','19:56:43','PLG0006641','800000','800000','0','800000','0','kasir','2025-09-27 19:56:43','FJ-250927-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('2025-09-28','FJ-250927-0011','2025-09-27','19:56:43','NIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0018','2025-09-28','2025-09-27 19:56:43','PENJUALAN : FJ-250927-0011','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0019','D','2025-09-28','19:56:43','TBC','PENJUALAN','FJ-250927-0011','16727263614','800000','16728063614','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='800000' WHERE no_faktur_jual='FJ-250927-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-250927-0012','kasir',' 1',' 700K-20-00','TOKO','MMPER','PMM-YGAX-13-0','CINCIN SILVER 925 ','','3.000','1','100.00','69000','0','0','16700','700000','0','0','0','700000','NIS','00037117','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAX-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YGAX-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0012','2025-09-28','3.000','2025-09-27','19:56:43','PLG0006642','700000','700000','0','700000','0','kasir','2025-09-27 19:56:43','FJ-250927-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('2025-09-28','FJ-250927-0012','2025-09-27','19:56:43','NIS','700000','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-250928-0019','2025-09-28','2025-09-27 19:56:43','PENJUALAN : FJ-250927-0012','.','TBC','700000','700000','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-250928-0020','D','2025-09-28','19:56:43','TBC','PENJUALAN','FJ-250927-0012','16728063614','700000','16728763614','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='1500000' WHERE no_faktur_jual='FJ-250927-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0012';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','20:14:52');
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-250927-0013','kasir','1',' 800K-12-00','TOKO','MMPER','PMM-YFBX-117-0','CINCIN SILVER 925 ','','1.830','1','100.00','43000','0','0','16700','800000','0','0','0','800000','NIS','00036558','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YFBX-117-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0013','2025-09-28','1.830','2025-09-27','20:16:47','PLG0006643','800000','800000','0','800000','0','kasir','2025-09-27 20:16:46','FJ-250927-0013','','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('2025-09-28','FJ-250927-0013','2025-09-27','20:16:47','NIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0020','2025-09-28','2025-09-27 20:16:46','PENJUALAN : FJ-250927-0013','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0021','D','2025-09-28','20:16:47','TBC','PENJUALAN','FJ-250927-0013','16728763614','800000','16729563614','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='800000' WHERE no_faktur_jual='FJ-250927-0013' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','20:20: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-250927-0014','kasir','1',' 750K-13-00','TOKO','BIPPER','PBSD-YGCX-7-0','CINCIN SILVER 925 ','','1.650','1','100.00','34000','0','0','16700','800000','0','0','0','800000','NITA','00037746','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGCX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBSD-YGCX-7-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-250927-0014','2025-09-28','1.650','2025-09-27','20:21:25','PLG0006644','800000','800000','0','800000','0','kasir','2025-09-27 20:21:25','FJ-250927-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('2025-09-28','FJ-250927-0014','2025-09-27','20:21:25','NITA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0021','2025-09-28','2025-09-27 20:21:25','PENJUALAN : FJ-250927-0014','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0022','D','2025-09-28','20:21:25','TBC','PENJUALAN','FJ-250927-0014','16729563614','800000','16730363614','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='800000' WHERE no_faktur_jual='FJ-250927-0014' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0015','kasir',' 1',' 500K-175-1','TOKO','BIPPER','PBDG-YIBF-8-0','CINCIN SILVER 925 ','','2.020','1','100.00','52000','0','0','16700','500000','0','0','0','500000','NITA','00038939','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIBF-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBDG-YIBF-8-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-250927-0015','2025-09-28','2.020','2025-09-27','20:21:25','PLG0006645','500000','500000','0','500000','0','kasir','2025-09-27 20:21:25','FJ-250927-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('2025-09-28','FJ-250927-0015','2025-09-27','20:21:25','NITA','500000','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-250928-0022','2025-09-28','2025-09-27 20:21:25','PENJUALAN : FJ-250927-0015','.','TBC','500000','500000','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-250928-0023','D','2025-09-28','20:21:25','TBC','PENJUALAN','FJ-250927-0015','16730363614','500000','16730863614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1300000' WHERE no_faktur_jual='FJ-250927-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0015';
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-250927-0016','kasir','1',' DP-01091BI','TOKO','BIPPSN','PSPRT-YIBC-15-0','CINCIN PERAK ','','4.940','1','100.00','127000','0','0','16700','700000','0','0','0','700000','SUL','00038847','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIBC-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.940',berat_jual_asli=berat_jual_asli+'4.940',stock_jual='1',berat_akhir=berat_akhir-'4.940',berat_akhir_asli=berat_akhir_asli-'4.940',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIBC-15-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-250927-0016','2025-09-28','4.940','2025-09-27','20:34:46','PLG0006646','700000','700000','0','700000','0','kasir','2025-09-27 20:34:45','FJ-250927-0016','DP-01091','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0016','2025-09-27','20:34:46','SUL','700000','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-250927-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0017','kasir',' 1',' DP-01092BI','TOKO','BIPPSN','PSPRT-YIBD-8-0','CINCIN PERAK ','','1.760','1','100.00','45000','0','0','16700','850000','0','0','0','850000','SUL','00038885','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIBD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIBD-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250927-0017','2025-09-28','1.760','2025-09-27','20:34:46','PLG0006647','850000','850000','0','850000','0','kasir','2025-09-27 20:34:45','FJ-250927-0016','DP-01092','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('2025-09-28','FJ-250927-0017','2025-09-27','20:34:46','SUL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-250927-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0017';
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-250927-0018','kasir','1',' DP-01114BI','TOKO','BIPPSN','PSPRT-YIBE-26-0','CINCIN PERAK ','','1.100','1','100.00','29000','0','0','16700','750000','0','0','0','750000','SUL','00038913','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIBE-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIBE-26-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-250927-0018','2025-09-28','1.100','2025-09-27','20:40:15','PLG0006648','750000','750000','0','750000','0','kasir','2025-09-27 20:40:14','FJ-250927-0018','DP-01114','750000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0018','2025-09-27','20:40:15','SUL','750000','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-250927-0018' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0019','kasir',' 1',' DP-01113BI','TOKO','BIPPSN','PSPRT-YIBE-30-0','CINCIN PERAK ','','2.190','1','100.00','57000','0','0','16700','700000','0','0','0','700000','SUL','00038917','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIBE-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIBE-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250927-0019','2025-09-28','2.190','2025-09-27','20:40:15','PLG0006649','700000','700000','0','700000','0','kasir','2025-09-27 20:40:14','FJ-250927-0018','DP-01113','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0019','2025-09-27','20:40:15','SUL','700000','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-250927-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0019';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-27 ','20:47: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-250927-0020','kasir','1',' 700K-13-00','TOKO','MMPER','PMM-YHAA-14-0','CINCIN SILVER 925 ','','1.240','1','100.00','32000','0','0','16700','299000','0','0','0','299000','NAD','00037925','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YHAA-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YHAA-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0020','2025-09-28','1.240','2025-09-27','20:49:34','PLG0006650','299000','299000','0','299000','0','kasir','2025-09-27 20:49:34','FJ-250927-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0020','2025-09-27','20:49:34','NAD','299000','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-250928-0023','2025-09-28','2025-09-27 20:49:34','PENJUALAN : FJ-250927-0020','.','TBC','299000','299000','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-250928-0024','D','2025-09-28','20:49:34','TBC','PENJUALAN','FJ-250927-0020','16730863614','299000','16731162614','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='299000' WHERE no_faktur_jual='FJ-250927-0020' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250927-0021','kasir',' 1',' 500K-16-00','TOKO','MMPER','PMM-YIAF-3-0','CINCIN SILVER 925 ','','1.900','1','100.00','49000','0','0','16700','500000','0','0','0','500000','NAD','00038748','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIAF-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YIAF-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-250927-0021','2025-09-28','1.900','2025-09-27','20:49:34','PLG0006651','500000','500000','0','500000','0','kasir','2025-09-27 20:49:34','FJ-250927-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250927-0021','2025-09-27','20:49:34','NAD','500000','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-250928-0024','2025-09-28','2025-09-27 20:49:34','PENJUALAN : FJ-250927-0021','.','TBC','500000','500000','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-250928-0025','D','2025-09-28','20:49:34','TBC','PENJUALAN','FJ-250927-0021','16731162614','500000','16731662614','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='799000' WHERE no_faktur_jual='FJ-250927-0021' LIMIT 1;