INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','10:45:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','10:45: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-251116-0001','kasir','1',' PBDG-00869','TOKO','BIPPER','PBDG-YBXF-36-0','CINCIN PERAK PBDG-00869 ','','1.730','1','100.00','213000','150000','0','16750','399000','0','0','0','399000','NITA','00033990','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YBXF-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PBDG-YBXF-36-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-251116-0001','2025-11-16','1.730','2025-11-16','10:48:55','PLG0007627','399000','399000','0','399000','0','kasir','2025-11-16 10:48:55','FJ-251116-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('2025-11-16','FJ-251116-0001','2025-11-16','10:48:55','NITA','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-251116-0001','2025-11-16','2025-11-16 10:48:55','PENJUALAN : FJ-251116-0001','.','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-251116-0002','D','2025-11-16','10:48:55','TBC','PENJUALAN','FJ-251116-0001','17984002814','399000','17984401814','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='399000' WHERE no_faktur_jual='FJ-251116-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-251116-0002','kasir',' 1',' 500K-205-1','TOKO','BIPPER','PBDG-YKXF-28-0','CINCIN SILVER 925 ','','2.020','1','100.00','124000','0','0','16750','500000','0','0','0','500000','NITA','00039505','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-28-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-11-16' AND kode_barang='PBDG-YKXF-28-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-251116-0002','2025-11-16','2.020','2025-11-16','10:48:55','PLG0007628','500000','500000','0','500000','0','kasir','2025-11-16 10:48:55','FJ-251116-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('2025-11-16','FJ-251116-0002','2025-11-16','10:48:55','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-251116-0002','2025-11-16','2025-11-16 10:48:55','PENJUALAN : FJ-251116-0002','.','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-251116-0003','D','2025-11-16','10:48:55','TBC','PENJUALAN','FJ-251116-0002','17984401814','500000','17984901814','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='899000' WHERE no_faktur_jual='FJ-251116-0002' 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-01405','NITA','1','PLD','1 CINCIN SILVER','','','4.000','','925.00','1','2260000','0','750000','0','750000','size 24 5 request tanpa permata','grf Sendi & firda font vitange rotter','krum full hitam glosy','0',' ','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0003','2025-11-16','2025-11-16 12:43:39','PESANAN : DP-01405','.','TBC','750000','750000');
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-251116-0004','D','2025-11-16','12:43:39','TBC','PESANAN','DP-01405','17984901814','750000','17985651814','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-01405','2025-11-16','2025-11-16','12:43:39','PLG0007629','NITA','2025-12-15','kasir','2025-11-16 12:43:39','4.000','0','0','0','750000','0','0','750000','750000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','13:03:23');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01406','NIS','1','PLD','CINCIN NIKAH','','','3.000','','25.00','1','2260000','450000','0','700000','2050000','size 13 pakai mata','krum putih dove sesuai cth','grf ?? dimas 281225','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0004','2025-11-16','2025-11-16 13:06:26','PESANAN : DP-01406','..','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-251116-0005','D','2025-11-16','13:06:26','TBC','PESANAN','DP-01406','17985651814','1640000','17987291814','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-01406','2025-11-16','2025-11-16','13:06:26','PLG0007630','NIS','2025-12-03','kasir','2025-11-16 13:06:26','3.000','0','0','0','1640000','0','700000','2050000','2050000','410000');
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-01407','NAD','1','PLD','CINCIN NIKAH','','','2.500','','25.00','1','2260000','450000','0','700000','1825000','size 15 krum putih dove sesuai cth','grf ?? agnes 281225','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0005','2025-11-16','2025-11-16 13:08:22','PESANAN : DP-01407','.','TBC','1460000','1460000');
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-251116-0006','D','2025-11-16','13:08:22','TBC','PESANAN','DP-01407','17987291814','1460000','17988751814','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-01407','2025-11-16','2025-11-16','13:08:22','PLG0007631','NAD','2025-11-30','kasir','2025-11-16 13:08:22','2.500','0','0','0','1460000','0','700000','1825000','1825000','365000');
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-251116-0003','kasir','1',' DP-01292BI','TOKO','BIPPSN','PSPRT-YKAA-10-0','CINCIN PERAK ','','1.410','1','100.00','87000','0','0','16750','850000','0','0','0','850000','NITA','00039562','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAA-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSPRT-YKAA-10-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-251116-0003','2025-11-16','1.410','2025-11-16','13:21:02','PLG0007632','850000','850000','0','850000','0','kasir','2025-11-16 13:21:01','FJ-251116-0003','DP-01292','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-11-16','FJ-251116-0003','2025-11-16','13:21:02','NITA','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-251116-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0003';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01462','HELMI','1','SEPASANG CC PLD DAN SLV','CEWE JD SIZE 10 5 COWO JD SIZE 18 5 KRUM SPT ASAL','5.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-01462','2025-11-16','2025-11-16','13:24:41','PLG0007633','kasir','2025-11-17','kasir','2025-11-16 13:24:41','5.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','13:24:57');
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-01408','NIS','1','GOLD','CINCIN NIKAH','','','3.000','','75.00','1','2230000','2100000','0','950000','7250000','size 13 grf joko','18 butir krum putih sesuai ch','','0','180000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0006','2025-11-16','2025-11-16 13:33:00','PESANAN : DP-01408','.','TBC','5920000','5920000');
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-251116-0007','D','2025-11-16','13:33:00','TBC','PESANAN','DP-01408','17988751814','5920000','17994671814','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-01408','2025-11-16','2025-11-16','13:33:00','PLG0007634','NIS','2025-12-03','kasir','2025-11-16 13:33:00','3.000','0','0','0','5920000','0','950000','7430000','7430000','1510000');
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-01409','NAD','1','PLD','CINCIN NIKAH','','','3.000','','10.00','1','2260000','300000','0','700000','1600000','size 16 grf rahma','krum putih dove sesuai cth','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0007','2025-11-16','2025-11-16 13:35:12','PESANAN : DP-01409','.','TBC','1280000','1280000');
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-251116-0008','D','2025-11-16','13:35:12','TBC','PESANAN','DP-01409','17994671814','1280000','17995951814','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-01409','2025-11-16','2025-11-16','13:35:12','PLG0007635','NAD','2025-12-03','kasir','2025-11-16 13:35:12','3.000','0','0','0','1280000','0','700000','1600000','1600000','320000');
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-01410','NITA ','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','799000','0','799000','cc wanita 17 5 grf Hadi 2812','cc pria 14 grf Vira 2812','font vintage','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0008','2025-11-16','2025-11-16 13:35:14','PESANAN : DP-01410','.','TBC','799000','799000');
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-251116-0009','D','2025-11-16','13:35:14','TBC','PESANAN','DP-01410','17995951814','799000','17996750814','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-01410','2025-11-16','2025-11-16','13:35:14','PLG0007636','NITA ','2025-12-09','kasir','2025-11-16 13:35:14','5.000','0','0','0','799000','0','0','799000','799000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','13:40:08');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01463','NITA','1','WEDDING RING','CC WANITA 14 CC PRIA 12 FONT YESEVA ONE','4.500','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-01463','2025-11-16','2025-11-16','13:42:25','PLG0007637','kasir','2025-11-20','kasir','2025-11-16 13:42:25','4.500','0','0','0','0','0','0','0','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-251116-0004','kasir','1',' DP-01242BI','TOKO','BIPPSN','PSPRT-YJBB-10-0','CINCIN PERAK ','','2.520','1','100.00','65000','0','0','16750','700000','0','0','0','700000','SUL','00039259','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJBB-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSPRT-YJBB-10-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-251116-0004','2025-11-16','2.520','2025-11-16','14:15:50','PLG0007638','700000','700000','0','700000','0','kasir','2025-11-16 14:15:50','FJ-251116-0004','DP-01242','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-11-16','FJ-251116-0004','2025-11-16','14:15:50','SUL','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-251116-0009','2025-11-16','2025-11-16 14:15:50','PENJUALAN : FJ-251116-0004','.','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-251116-0010','D','2025-11-16','14:15:50','TBC','PENJUALAN','FJ-251116-0004','17996750814','700000','17997450814','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-251116-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251116-0005','kasir',' 1',' DP-01241BI','TOKO','BIPPSN','PSGT-YKXF-1-0','CINCIN EMAS ','','2.970','1','83.00','5357000','0','0','16750','6830900','0','0','0','6830900','SUL','00039478','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKXF-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSGT-YKXF-1-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-251116-0005','2025-11-16','2.970','2025-11-16','14:15:50','PLG0007639','6830900','6830900','0','6830900','0','kasir','2025-11-16 14:15:50','FJ-251116-0004','DP-01241','5512000');
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-11-16','FJ-251116-0005','2025-11-16','14:15:50','SUL','6830900','0');
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-251116-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-251116-0006','kasir','1',' DP-01300BI','TOKO','BIPPSN','PSPRT-YKAA-2-0','CINCIN PERAK ','','3.900','1','100.00','239000','0','0','16750','700000','0','0','0','700000','HELMI','00039554','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAA-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.900',berat_jual_asli=berat_jual_asli+'3.900',stock_jual='1',berat_akhir=berat_akhir-'3.900',berat_akhir_asli=berat_akhir_asli-'3.900',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSPRT-YKAA-2-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-251116-0006','2025-11-16','3.900','2025-11-16','15:10:39','PLG0007640','700000','700000','0','700000','0','kasir','2025-11-16 15:10:38','FJ-251116-0006','DP-01300','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-11-16','FJ-251116-0006','2025-11-16','15:10:39','HELMI','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-251116-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251116-0007','kasir',' 1',' DP-01299BI','TOKO','BIPPSN','PSPLT-YKAC-3-0','CINCIN PALADIUM ','','1.910','1','6.00','286000','0','0','16750','1177500','0','0','0','1177500','HELMI','00039565','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKAC-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSPLT-YKAC-3-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-251116-0007','2025-11-16','1.910','2025-11-16','15:10:39','PLG0007641','1177500','1177500','0','1177500','0','kasir','2025-11-16 15:10:38','FJ-251116-0006','DP-01299','600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-16','FJ-251116-0007','2025-11-16','15:10:39','HELMI','1177500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251116-0010','2025-11-16','2025-11-16 15:10:38','PENJUALAN : FJ-251116-0007','.','TBC','577500','577500','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-251116-0011','D','2025-11-16','15:10:39','TBC','PENJUALAN','FJ-251116-0007','17997450814','577500','17998028314','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='577500' WHERE no_faktur_jual='FJ-251116-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0007';
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-01411','NAD','1','PER','CINCIN NIKAH','','','1.000','','925.00','1','60000','0','700000','','700000','krum kombinasi krum kuning grf fadiyah size 23','','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0011','2025-11-16','2025-11-16 15:31:00','PESANAN : DP-01411','.','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-251116-0012','D','2025-11-16','15:31:00','TBC','PESANAN','DP-01411','17998028314','700000','17998728314','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-01411','2025-11-16','2025-11-16','15:31:00','PLG0007642','NAD','2025-12-02','kasir','2025-11-16 15:31:00','1.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','15:35:10');
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-01412','NIS','1','PLD','CINCIN NIKAH','','','2.800','','25.00','1','2260000','450000','0','700000','1960000','size 19 grf nisa','krum putih sesuai cth dove alus','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0012','2025-11-16','2025-11-16 15:37:57','PESANAN : DP-01412','.','TBC','1568000','1568000');
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-251116-0013','D','2025-11-16','15:37:57','TBC','PESANAN','DP-01412','17998728314','1568000','18000296314','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-01412','2025-11-16','2025-11-16','15:37:57','PLG0007643','NIS','2025-12-02','kasir','2025-11-16 15:37:57','2.800','0','0','0','1568000','0','700000','1960000','1960000','392000');
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-251116-0008','kasir','1',' DP-01305BI','TOKO','BIPPSN','PSGT-YKAD-8-0','CINCIN EMAS ','','2.400','1','83.00','4593000','0','0','16750','5820000','0','0','0','5820000','HELMI','00039585','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKAD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSGT-YKAD-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-251116-0008','2025-11-16','2.400','2025-11-16','15:55:17','PLG0007644','5820000','5820000','0','5820000','0','kasir','2025-11-16 15:55:17','FJ-251116-0008','DP-01305','3200000');
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-11-16','FJ-251116-0008','2025-11-16','15:55:17','HELMI','5820000','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-251116-0013','2025-11-16','2025-11-16 15:55:17','PENJUALAN : FJ-251116-0008','.','TBC','2620000','2620000','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-251116-0014','D','2025-11-16','15:55:17','TBC','PENJUALAN','FJ-251116-0008','18000296314','2620000','18002916314','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='2620000' WHERE no_faktur_jual='FJ-251116-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251116-0009','kasir',' 1',' DP-01306BI','TOKO','BIPPSN','PSPLT-YKAC-10-0','CINCIN PALADIUM ','','2.560','1','6.00','383000','0','0','16750','1140000','0','0','0','1140000','HELMI','00039572','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKAC-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSPLT-YKAC-10-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-251116-0009','2025-11-16','2.560','2025-11-16','15:55:17','PLG0007645','1140000','1140000','0','1140000','0','kasir','2025-11-16 15:55:17','FJ-251116-0008','DP-01306','500000');
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-11-16','FJ-251116-0009','2025-11-16','15:55:17','HELMI','1140000','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-251116-0014','2025-11-16','2025-11-16 15:55:17','PENJUALAN : FJ-251116-0009','.','TBC','640000','640000','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-251116-0015','D','2025-11-16','15:55:17','TBC','PENJUALAN','FJ-251116-0009','18002916314','640000','18003556314','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='3260000' WHERE no_faktur_jual='FJ-251116-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0009';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251116-0010','kasir','1',' BDCM700K-5','TOKO','BIPCMP','BDCM-YFAG-8-0','BANDUNG CINCIN EMAS ','','1.610','1','83.00','3427000','0','0','16750','4131000','0','0','0','4131000','NITA','00036358','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YFAG-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='BDCM-YFAG-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251116-0010','2025-11-16','1.610','2025-11-16','16:43:46','PLG0007646','4131000','4131000','0','4131000','0','kasir','2025-11-16 16:43:46','FJ-251116-0010','','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-11-16','FJ-251116-0010','2025-11-16','16:43:46','NITA','4131000','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-251116-0015','2025-11-16','2025-11-16 16:43:46','PENJUALAN : FJ-251116-0010','.','TBC','4131000','4131000','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-251116-0016','D','2025-11-16','16:43:46','TBC','PENJUALAN','FJ-251116-0010','18003556314','4131000','18007687314','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='4131000' WHERE no_faktur_jual='FJ-251116-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251116-0011','kasir',' 1',' 500K-21-17','TOKO','BIPPER','PBDG-YKXF-17-0','CINCIN SILVER 925 ','','2.170','1','100.00','134000','0','0','16750','500000','0','0','0','500000','NITA','00039494','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PBDG-YKXF-17-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-251116-0011','2025-11-16','2.170','2025-11-16','16:43:46','PLG0007647','500000','500000','0','500000','0','kasir','2025-11-16 16:43:46','FJ-251116-0010','','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-11-16','FJ-251116-0011','2025-11-16','16:43:46','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-251116-0016','2025-11-16','2025-11-16 16:43:46','PENJUALAN : FJ-251116-0011','.','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-251116-0017','D','2025-11-16','16:43:46','TBC','PENJUALAN','FJ-251116-0011','18007687314','500000','18008187314','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='4631000' WHERE no_faktur_jual='FJ-251116-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0011';
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-01413','HELMI','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','850000','0','850000','zirkon 7butir size 14.5','grf Arief','krum putih glosy','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-251116-0017','2025-11-16','2025-11-16 16:50:50','PESANAN : DP-01413','.','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-251116-0018','D','2025-11-16','16:50:50','TBC','PESANAN','DP-01413','18008187314','850000','18009037314','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-01413','2025-11-16','2025-11-16','16:50:50','PLG0007648','HELMI','2025-12-06','kasir','2025-11-16 16:50:50','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01414','HELMI','1','PER','WEDDING RING','','','4.000','','925.00','1','60000','0','700000','0','700000','zirkon 1butir size 20','grf Melan','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-251116-0018','2025-11-16','2025-11-16 16:53:37','PESANAN : DP-01414','.','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-251116-0019','D','2025-11-16','16:53:37','TBC','PESANAN','DP-01414','18009037314','700000','18009737314','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-01414','2025-11-16','2025-11-16','16:53:37','PLG0007649','HELMI','2025-12-06','kasir','2025-11-16 16:53:37','4.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000324','X-00000324','CBRT00347','GR','---','CBRT','BELI','BELI001','6400000','2025-11-16','2.150','1','kasir','2025-11-16 17:14:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRT';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRT','X-00000324','X-00000324');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251116-0001','FJ-231122-0002','FIR','1','BELI','BELI001','CBRT', 'X-00000324', 'CBRT00347','2.150','2.150','83.00','8000000','6400000','2976744','1','6400000','6400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.150',berat_beli_asli=berat_beli_asli+'2.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.150',berat_akhir_asli=berat_akhir_asli+'2.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRT' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-251116-0001','2025-11-16','2025-11-16','17:14:14','FIR','---','2.150','6400000','6400000','6400000','6400000','6400000','kasir','2025-11-16 17:14:15','FB-251116-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251116-0001','NINA','-','','','.','kasir','2025-11-16 17:14:15');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0019','2025-11-16','2025-11-16 17:14:15','PEMBELIAN UMUM : FB-251116-0001','.','TBC','6400000','6400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-251116-0020','K','2025-11-16','17:14:14','TBC','PEMBELIAN UMUM','FB-251116-0001','18009737314','6400000','18003337314','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251116-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251116-0001';
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-251116-0012','kasir','1',' 800K-125-1','TOKO','BIPPER','PBDG-YKXF-41-0','CINCIN SILVER 925 ','','2.420','1','100.00','149000','0','0','16750','599000','0','0','0','599000','HELMI','00039518','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PBDG-YKXF-41-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-251116-0012','2025-11-16','2.420','2025-11-16','17:45:50','PLG0007650','599000','599000','0','599000','0','kasir','2025-11-16 17:45:50','FJ-251116-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-16','FJ-251116-0012','2025-11-16','17:45:50','HELMI','599000','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-251116-0020','2025-11-16','2025-11-16 17:45:50','PENJUALAN : FJ-251116-0012','.','TBC','599000','599000','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-251116-0021','D','2025-11-16','17:45:50','TBC','PENJUALAN','FJ-251116-0012','18003337314','599000','18003936314','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='599000' WHERE no_faktur_jual='FJ-251116-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0012';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','18:01:10');
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-01415','NAD','1','PLD','CINCIN NIKAH','','','4.000','','25.00','1','2260000','450000','0','700000','2500000','size 21','krum putih dove alus sesuai cth','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0021','2025-11-16','2025-11-16 18:09:22','PESANAN : DP-01415','.','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251116-0022','D','2025-11-16','18:09:22','TBC','PESANAN','DP-01415','18003936314','2000000','18005936314','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-01415','2025-11-16','2025-11-16','18:09:22','PLG0007651','NAD','2025-11-30','kasir','2025-11-16 18:09:22','4.000','0','0','0','2000000','0','700000','2500000','2500000','500000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01464','NITA','1','WEDDIN G RING','CC WANITA RESIZE 13 FONT COMIS SANS','2.710','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-01464','2025-11-16','2025-11-16','18:20:16','PLG0007652','kasir','2025-11-17','kasir','2025-11-16 18:20:16','2.710','0','0','0','0','0','0','0','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-251116-0013','kasir','1',' 700K-95-17','TOKO','BIPPER','PBDG-YKXF-11-0','CINCIN SILVER 925 ','','1.140','1','100.00','70000','0','0','16750','700000','0','0','0','700000','NITA','00039488','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PBDG-YKXF-11-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-251116-0013','2025-11-16','1.140','2025-11-16','18:34:33','PLG0007653','700000','700000','0','700000','0','kasir','2025-11-16 18:34:32','FJ-251116-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-11-16','FJ-251116-0013','2025-11-16','18:34:33','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-251116-0022','2025-11-16','2025-11-16 18:34:32','PENJUALAN : FJ-251116-0013','.','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-251116-0023','D','2025-11-16','18:34:33','TBC','PENJUALAN','FJ-251116-0013','18005936314','700000','18006636314','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-251116-0013' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01416','NAD','1','PLD','CINCIN NIKAH','','','3.000','','25.00','1','2260000','450000','0','500000','1850000','size 18 papanlis tipis','grf nabila 27-12-25','krum putih sesuai cth dove alus','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0023','2025-11-16','2025-11-16 18:46:40','PESANAN : DP-01416','.','TBC','1480000','1480000');
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-251116-0024','D','2025-11-16','18:46:40','TBC','PESANAN','DP-01416','18006636314','1480000','18008116314','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-01416','2025-11-16','2025-11-16','18:46:40','PLG0007654','NAD','2025-12-04','kasir','2025-11-16 18:46:40','3.000','0','0','0','1480000','0','500000','1850000','1850000','370000');
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-251116-0014','kasir','1',' DP-01330MM','TOKO','MMPSN','PSGT-YKAD-10-0','CINCIN EMAS ','','1.860','1','83.00','3552000','0','0','16750','4571200','0','0','0','4571200','NIS','00039587','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKAD-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2025-11-16' AND kode_barang='PSGT-YKAD-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251116-0014','2025-11-16','1.860','2025-11-16','18:55:06','PLG0007655','4571200','4571200','0','4571200','0','kasir','2025-11-16 18:55:06','FJ-251116-0014','DP-01330','3564000');
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-11-16','FJ-251116-0014','2025-11-16','18:55:06','NIS','4571200','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-251116-0024','2025-11-16','2025-11-16 18:55:06','PENJUALAN : FJ-251116-0014','.','TBC','1007200','1007200','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-251116-0025','D','2025-11-16','18:55:06','TBC','PENJUALAN','FJ-251116-0014','18008116314','1007200','18009123514','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='1007200' WHERE no_faktur_jual='FJ-251116-0014' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','18:57:27');
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-01417','NITA','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','850000','0','850000','zircon 20 krum putih glosy','size 12 5 grf M.Hedryan font vintage rotter','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0025','2025-11-16','2025-11-16 19:06:44','PESANAN : DP-01417','.','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-251116-0026','D','2025-11-16','19:06:44','TBC','PESANAN','DP-01417','18009123514','850000','18009973514','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-01417','2025-11-16','2025-11-16','19:06:44','PLG0007656','NITA','2025-12-16','kasir','2025-11-16 19:06:44','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01418','NITA','1','PER','WEDDING RING','','','4.000','','925.00','1','60000','0','700000','0','700000','size 13 5','keum doff semprot','grf Shara Ghea font vintage rotter','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-251116-0026','2025-11-16','2025-11-16 19:10:44','PESANAN : DP-01418','.','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-251116-0027','D','2025-11-16','19:10:44','TBC','PESANAN','DP-01418','18009973514','700000','18010673514','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-01418','2025-11-16','2025-11-16','19:10:44','PLG0007657','NITA','2025-12-16','kasir','2025-11-16 19:10:44','4.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','19:11:10');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0014';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01465','NITA','1','2 CC SILVER','CC WANITA RESIZE KE 6 5 KRUM GANTI KE FULL PYH GLOSY DAN UKIRNAMA TETAP ADA','5.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-251116-0027','2025-11-16','2025-11-16 19:22:57','SERVICE : SV-01465','.','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-251116-0028','D','2025-11-16','19:22:57','TBC','SERVICE','SV-01465','18010673514','100000','18010773514','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-01465','2025-11-16','2025-11-16','19:22:57','PLG0007658','kasir','2025-11-25','kasir','2025-11-16 19:22:57','5.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','19:23:29');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01466','NITA','1','2 CINCIN','CC PRIA DI SERVICE ADA BELAH DI CC','5.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-01466','2025-11-16','2025-11-16','19:29:42','PLG0007659','kasir','2025-11-25','kasir','2025-11-16 19:29:42','5.000','0','0','0','0','0','0','0','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-16';
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='2025-11-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-16' 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-251117-0001','D','2025-11-17','20:04:34','TBC','SALDO AWAL','SALDO AWAL','0','18010773514','18010773514');
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-251117-0001','D','2025-11-17','20:04:34','BCD','SALDO AWAL','SALDO AWAL','0','1334821000','1334821000');
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-251117-0001','D','2025-11-17','20:04:34','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251117-0001','D','2025-11-17','20:04:34','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-251117-0001','D','2025-11-17','20:04:34','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-251117-0001','D','2025-11-17','20:04:34','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-251117-0001','D','2025-11-17','20:04:34','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-251117-0001','D','2025-11-17','20:04:34','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-251117-0001','D','2025-11-17','20:04:34','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-251117-0001','D','2025-11-17','20:04:34','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-251117-0001','D','2025-11-17','20:04:34','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-11-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-16 ','20:11:49');
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-01419','NIS','1','GOLD','CINCIN NIKAH','','','3.000','','75.00','1','2230000','2100000','0','950000','7250000','size 13 prmt 16btr dan 1btr','grf arba 27-12-25','krum putih sesuai cth','160000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251116-0028','2025-11-16','2025-11-16 20:12:50','PESANAN : DP-01419','.','TBC','5928000','5928000');
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-251116-0001','D','2025-11-16','20:12:50','TBC','PESANAN','DP-01419','0','5928000','5928000','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-01419','2025-11-16','2025-11-16','20:12:50','PLG0007660','NIS','2025-11-30','kasir','2025-11-16 20:12:50','3.000','0','0','0','5928000','0','950000','7410000','7410000','1482000');
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-251116-0015','kasir','1',' 500K-22-00','TOKO','BIPPER','PMM-YKXF-24-0','CINCIN SILVER 925 ','','2.090','1','100.00','129000','0','0','16750','400000','0','0','0','400000','HELMI','00039501','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKXF-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2025-11-17' AND kode_barang='PMM-YKXF-24-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-251116-0015','2025-11-17','2.090','2025-11-16','20:12:58','PLG0007661','400000','400000','0','400000','0','kasir','2025-11-16 20:12:57','FJ-251116-0015','','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-11-17','FJ-251116-0015','2025-11-16','20:12:58','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-251117-0001','2025-11-17','2025-11-16 20:12:57','PENJUALAN : FJ-251116-0015','.','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-251117-0002','D','2025-11-17','20:12:58','TBC','PENJUALAN','FJ-251116-0015','18010773514','400000','18011173514','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-251116-0015' 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-251116-0016','kasir',' 1',' 700K-135-1','TOKO','BIPPER','PBDG-YKXF-6-0','CINCIN SILVER 925 ','','1.180','1','100.00','73000','0','0','16750','399000','0','0','0','399000','HELMI','00039483','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2025-11-17' AND kode_barang='PBDG-YKXF-6-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-251116-0016','2025-11-17','1.180','2025-11-16','20:12:58','PLG0007662','399000','399000','0','399000','0','kasir','2025-11-16 20:12:57','FJ-251116-0015','','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-11-17','FJ-251116-0016','2025-11-16','20:12:58','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-251117-0002','2025-11-17','2025-11-16 20:12:57','PENJUALAN : FJ-251116-0016','.','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-251117-0003','D','2025-11-17','20:12:58','TBC','PENJUALAN','FJ-251116-0016','18011173514','399000','18011572514','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-251116-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251116-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251116-0016';
INSERT INTO tt_service_batal_detail SELECT * FROM tt_service_detail WHERE no_service='SV-01465';
INSERT INTO tt_service_batal_head SELECT * FROM tt_service_head WHERE no_service='SV-01465';
UPDATE tt_service_head SET STATUS ='CANC' WHERE no_service='SV-01465';
UPDATE tt_service_detail SET STATUS ='CANC' WHERE no_service='SV-01465';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01467','HELMI','1','SEPASNG CC SLV','CEWE JD SIZE 17 KRUM SPT ASAL DUA DUANYA','5.000','1','100000','100000');
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-01467','2025-11-17','2025-11-17','20:18:20','PLG0007663','kasir','2025-11-18','kasir','2025-11-16 20:18:20','5.000','0','0','0','0','0','100000','100000','100000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01468','NITA','1','2 CC SILVER','CC WANITA RESIZE KE 6 5 KRUM GANTI FULL PTH GLOSY UKIRNAMA TETAP','5.000','1','100000','100000');
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-01468','2025-11-17','2025-11-17','20:22:39','PLG0007664','kasir','2025-11-25','kasir','2025-11-16 20:22:39','5.000','0','0','0','0','0','100000','100000','100000');
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-01420','NITA','1','PER','1 CC SILVER','','','5.000','','925.00','1','60000','0','750000','0','750000','krum doff semprot size 21','grf Nuria 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-251117-0003','2025-11-17','2025-11-16 20:28:20','PESANAN : DP-01420','.','TBC','750000','750000');
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-251117-0004','D','2025-11-17','20:28:20','TBC','PESANAN','DP-01420','18011572514','750000','18012322514','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-01420','2025-11-17','2025-11-17','20:28:20','PLG0007665','NITA','2025-12-15','kasir','2025-11-16 20:28:20','5.000','0','0','0','750000','0','0','750000','750000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01421','NITA','1','PER','1 CC SILVER','','','5.000','','925.00','1','60000','0','700000','0','700000','sz 21 krum doff semprot','grf Fika font vintage rotter','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251117-0004','2025-11-17','2025-11-16 21:48:42','PESANAN : DP-01421','.','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-251117-0005','D','2025-11-17','21:48:42','TBC','PESANAN','DP-01421','18012322514','700000','18013022514','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-01421','2025-11-17','2025-11-17','21:48:42','PLG0007666','NITA','2025-12-07','kasir','2025-11-16 21:48:42','5.000','0','0','0','700000','0','0','700000','700000','0');