INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','10:45:23');
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-251115-0001','kasir','1',' DP-01166BI','TOKO','BIPPSN','PSPRT-YJXI-3-0','CINCIN PERAK ','','3.360','1','100.00','86000','0','0','16750','700000','0','0','0','700000','HELMI','00039142','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJXI-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.360',berat_jual_asli=berat_jual_asli+'3.360',stock_jual='1',berat_akhir=berat_akhir-'3.360',berat_akhir_asli=berat_akhir_asli-'3.360',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PSPRT-YJXI-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-251115-0001','2025-11-15','3.360','2025-11-15','10:46:45','PLG0007589','700000','700000','0','700000','0','kasir','2025-11-15 10:46:44','FJ-251115-0001','DP-01166','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-15','FJ-251115-0001','2025-11-15','10:46:45','HELMI','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-251115-0004','2025-11-15','2025-11-15 10:46:44','PENJUALAN : FJ-251115-0001','.','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-251115-0005','D','2025-11-15','10:46:45','TBC','PENJUALAN','FJ-251115-0001','17949769814','700000','17950469814','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-251115-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-251115-0002','kasir',' 1',' DP-01165BI','TOKO','BIPPSN','PSGT-YJAD-12-0','CINCIN EMAS ','','1.770','1','83.00','3312000','0','0','16750','4126000','0','0','0','4126000','HELMI','00039206','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YJAD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PSGT-YJAD-12-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-251115-0002','2025-11-15','1.770','2025-11-15','10:46:45','PLG0007590','4126000','4126000','0','4126000','0','kasir','2025-11-15 10:46:44','FJ-251115-0001','DP-01165','2720000');
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-15','FJ-251115-0002','2025-11-15','10:46:45','HELMI','4126000','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-251115-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251114-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251114-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251114-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251114-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251114-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251114-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-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-01392','NITA','1','PLD','1 CINCIN PALLADIUM','','','3.000','','10.00','1','2260000','300000','0','500000','1400000','krum putih doff amplas','size 19','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251115-0005','2025-11-15','2025-11-15 11:03:05','PESANAN : DP-01392','.','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-251115-0006','D','2025-11-15','11:03:05','TBC','PESANAN','DP-01392','17950469814','700000','17951169814','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-01392','2025-11-15','2025-11-15','11:03:05','PLG0007591','NITA','2025-12-15','kasir','2025-11-15 11:03:05','3.000','0','0','0','700000','0','500000','1400000','1400000','700000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','11:34:36');
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-251115-0003','kasir','1',' 700K-23-17','TOKO','BIPPER','PBDG-YJBH-32-0','CINCIN SILVER 925 ','','2.670','1','100.00','164000','0','0','16750','700000','0','0','0','700000','NITA','00039340','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJBH-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PBDG-YJBH-32-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-251115-0003','2025-11-15','2.670','2025-11-15','11:46:38','PLG0007592','700000','700000','0','700000','0','kasir','2025-11-15 11:46:38','FJ-251115-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-11-15','FJ-251115-0003','2025-11-15','11:46:38','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-251115-0006','2025-11-15','2025-11-15 11:46:38','PENJUALAN : FJ-251115-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-251115-0007','D','2025-11-15','11:46:38','TBC','PENJUALAN','FJ-251115-0003','17951169814','700000','17951869814','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-251115-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','13:20: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-01393','NIS','1','PLD','CINCIN NIKAH','','','3.800','','50.00','1','2260000','850000','0','700000','3930000','size 17 grf khalifah.p ??','pakai mata 1butir','krum putih sesuai cth pakai 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-251115-0007','2025-11-15','2025-11-15 13:24:09','PESANAN : DP-01393','.','TBC','3930000','3930000');
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-251115-0008','D','2025-11-15','13:24:09','TBC','PESANAN','DP-01393','17951869814','3930000','17955799814','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-01393','2025-11-15','2025-11-15','13:24:09','PLG0007593','NIS','2025-12-05','kasir','2025-11-15 13:24:09','3.800','0','0','0','3930000','0','700000','3930000','3930000','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-251115-0004','kasir','1',' 700K-20-00','TOKO','MMPER','PMM-YIXH-31-0','CINCIN SILVER 925 ','','3.930','1','100.00','101000','0','0','16750','700000','0','0','0','700000','NAD','00038625','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIXH-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.930',berat_jual_asli=berat_jual_asli+'3.930',stock_jual='1',berat_akhir=berat_akhir-'3.930',berat_akhir_asli=berat_akhir_asli-'3.930',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PMM-YIXH-31-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-251115-0004','2025-11-15','3.930','2025-11-15','14:36:11','PLG0007594','700000','700000','0','700000','0','kasir','2025-11-15 14:36:10','FJ-251115-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-11-15','FJ-251115-0004','2025-11-15','14:36:11','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-251115-0008','2025-11-15','2025-11-15 14:36:10','PENJUALAN : FJ-251115-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-251115-0009','D','2025-11-15','14:36:11','TBC','PENJUALAN','FJ-251115-0004','17955799814','700000','17956499814','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-251115-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-251115-0005','kasir','1',' 500K-17-00','TOKO','MMPER','PBSD-YGBD-31-0','CINCIN SILVER 925 ','','2.570','1','100.00','53000','0','0','16750','500000','0','0','0','500000','NIS','00037493','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBD-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.570',berat_jual_asli=berat_jual_asli+'2.570',stock_jual='1',berat_akhir=berat_akhir-'2.570',berat_akhir_asli=berat_akhir_asli-'2.570',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PBSD-YGBD-31-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-251115-0005','2025-11-15','2.570','2025-11-15','14:37:34','PLG0007595','500000','500000','0','500000','0','kasir','2025-11-15 14:37:33','FJ-251115-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-11-15','FJ-251115-0005','2025-11-15','14:37:34','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-251115-0009','2025-11-15','2025-11-15 14:37:33','PENJUALAN : FJ-251115-0005','.','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-251115-0010','D','2025-11-15','14:37:34','TBC','PENJUALAN','FJ-251115-0005','17956499814','500000','17956999814','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-251115-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0005';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01394','HELMI','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','800000','0','800000','zirkon 7butir size 8','grf Andri ?? Novi','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-251115-0010','2025-11-15','2025-11-15 14:42:48','PESANAN : DP-01394','.','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251115-0011','D','2025-11-15','14:42:48','TBC','PESANAN','DP-01394','17956999814','800000','17957799814','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-01394','2025-11-15','2025-11-15','14:42:48','PLG0007596','HELMI','2025-12-06','kasir','2025-11-15 14:42:48','3.000','0','0','0','800000','0','0','800000','800000','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-01395','HELMI','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','700000','0','700000','zirkon 1butir size 14.5','grf Novi ?? Andri','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-251115-0011','2025-11-15','2025-11-15 14:44:36','PESANAN : DP-01395','.','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-251115-0012','D','2025-11-15','14:44:36','TBC','PESANAN','DP-01395','17957799814','700000','17958499814','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-01395','2025-11-15','2025-11-15','14:44:36','PLG0007597','HELMI','2025-12-06','kasir','2025-11-15 14:44:36','5.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01457','NAD','1','2 CINCIN SILVER','CC POLOS RESIZE KE 21 GRF DINDA TAUFIK CC PAKAI MATA GRF DINDA TAUFIK KRUM FULL PUTIH SESUAI CTH','6.500','1','50000','50000');
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-251115-0012','2025-11-15','2025-11-15 14:45:47','SERVICE : SV-01457','.','TBC','50000','50000','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-251115-0013','D','2025-11-15','14:45:47','TBC','SERVICE','SV-01457','17958499814','50000','17958549814','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-01457','2025-11-15','2025-11-15','14:45:47','PLG0007598','kasir','2025-11-16','kasir','2025-11-15 14:45:47','6.500','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','14:46:34');
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-251115-0006','kasir','1',' 500K-175-1','TOKO','BIPPER','PBDG-YKXF-27-0','CINCIN SILVER 925 ','','1.880','1','100.00','116000','0','0','16750','500000','0','0','0','500000','HELMI','00039504','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PBDG-YKXF-27-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-251115-0006','2025-11-15','1.880','2025-11-15','16:57:20','PLG0007599','500000','500000','0','500000','0','kasir','2025-11-15 16:57:19','FJ-251115-0006','','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-15','FJ-251115-0006','2025-11-15','16:57:20','HELMI','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-251115-0013','2025-11-15','2025-11-15 16:57:19','PENJUALAN : FJ-251115-0006','.','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-251115-0014','D','2025-11-15','16:57:20','TBC','PENJUALAN','FJ-251115-0006','17958549814','500000','17959049814','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-251115-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-251115-0007','kasir',' 1',' BDCK-00109','TOKO','BIPCKB','BDCK-YIAX-7-0','CINCIN KAWIN BDCK-00109','','1.280','1','83.00','3294000','614000','37','16750','5500000','0','0','0','5500000','HELMI','00038673','BDCK','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCK-YIAX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='BDCK-YIAX-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCKB' 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-251115-0007','2025-11-15','1.280','2025-11-15','16:57:20','PLG0007600','5500000','5500000','0','5500000','0','kasir','2025-11-15 16:57:19','FJ-251115-0006','','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-15','FJ-251115-0007','2025-11-15','16:57:20','HELMI','5500000','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-251115-0014','2025-11-15','2025-11-15 16:57:19','PENJUALAN : FJ-251115-0007','.','TBC','5500000','5500000','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-251115-0015','D','2025-11-15','16:57:20','TBC','PENJUALAN BERLIAN','FJ-251115-0007','17959049814','5500000','17964549814','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='6000000' WHERE no_faktur_jual='FJ-251115-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0007';
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-251115-0008','kasir','1',' 500K-19-17','TOKO','BIPPER','PBDG-YKXF-29-0','CINCIN SILVER 925 ','','2.030','1','100.00','125000','0','0','16750','500000','0','0','0','500000','NITA','00039506','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PBDG-YKXF-29-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-251115-0008','2025-11-15','2.030','2025-11-15','17:13:22','PLG0007601','500000','500000','0','500000','0','kasir','2025-11-15 17:13:22','FJ-251115-0008','','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-15','FJ-251115-0008','2025-11-15','17:13:22','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-251115-0015','2025-11-15','2025-11-15 17:13:22','PENJUALAN : FJ-251115-0008','.','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-251115-0016','D','2025-11-15','17:13:22','TBC','PENJUALAN','FJ-251115-0008','17964549814','500000','17965049814','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-251115-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-251115-0009','kasir',' 1',' 800K-13-00','TOKO','BIPPER','PMM-YGAX-23-0','CINCIN SILVER 925 ','','1.920','1','100.00','45000','0','0','16750','800000','0','0','0','800000','NITA','00037127','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAX-23-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-11-15' AND kode_barang='PMM-YGAX-23-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-251115-0009','2025-11-15','1.920','2025-11-15','17:13:22','PLG0007602','800000','800000','0','800000','0','kasir','2025-11-15 17:13:22','FJ-251115-0008','','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-15','FJ-251115-0009','2025-11-15','17:13:22','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-251115-0016','2025-11-15','2025-11-15 17:13:22','PENJUALAN : FJ-251115-0009','.','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-251115-0017','D','2025-11-15','17:13:22','TBC','PENJUALAN','FJ-251115-0009','17965049814','800000','17965849814','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-251115-0009' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01396','NIS','1','GOLD','CINCIN NIKAH','','','2.000','','75.00','1','2230000','2100000','0','950000','5150000','size 14 grf sahrul','krum putih 18butir','','0','180000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251115-0017','2025-11-15','2025-11-15 17:53:50','PESANAN : DP-01396','.','TBC','4264000','4264000');
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-251115-0018','D','2025-11-15','17:53:50','TBC','PESANAN','DP-01396','17965849814','4264000','17970113814','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-01396','2025-11-15','2025-11-15','17:53:50','PLG0007603','NIS','2025-12-03','kasir','2025-11-15 17:53:50','2.000','0','0','0','4264000','0','950000','5330000','5330000','1066000');
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-01397','NAD','1','PLD','CINCIN NIKAH','','','2.500','','10.00','1','2260000','300000','0','700000','1450000','size 20 grf nasella','krum putih full glosi','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251115-0018','2025-11-15','2025-11-15 17:55:32','PESANAN : DP-01397','.','TBC','1160000','1160000');
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-251115-0019','D','2025-11-15','17:55:32','TBC','PESANAN','DP-01397','17970113814','1160000','17971273814','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-01397','2025-11-15','2025-11-15','17:55:32','PLG0007604','NAD','2025-11-29','kasir','2025-11-15 17:55:32','2.500','0','0','0','1160000','0','700000','1450000','1450000','290000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01458','NAD','1','2PCS CINCIN NIKAH','CEWE GRF CEN 29 11 25 DAN COWO GRF GITA 29 11 25','7.050','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-01458','2025-11-15','2025-11-15','18:02:46','PLG0007605','kasir','2025-11-16','kasir','2025-11-15 18:02:46','7.050','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','18:02:59');
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-251115-0010','kasir','1',' 1.150K-145','TOKO','MMPER','PMM-YKAD-58-0','CINCIN SILVER 925 ','','2.820','1','100.00','173000','0','0','16750','1150000','0','0','0','1150000','NAD','00039635','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.820',berat_jual_asli=berat_jual_asli+'2.820',stock_jual='1',berat_akhir=berat_akhir-'2.820',berat_akhir_asli=berat_akhir_asli-'2.820',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PMM-YKAD-58-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-251115-0010','2025-11-15','2.820','2025-11-15','18:04:17','PLG0007606','1150000','1150000','0','1150000','0','kasir','2025-11-15 18:04:17','FJ-251115-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-15','FJ-251115-0010','2025-11-15','18:04:17','NAD','1150000','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-251115-0019','2025-11-15','2025-11-15 18:04:17','PENJUALAN : FJ-251115-0010','.','TBC','1150000','1150000','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-251115-0020','D','2025-11-15','18:04:17','TBC','PENJUALAN','FJ-251115-0010','17971273814','1150000','17972423814','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='1150000' WHERE no_faktur_jual='FJ-251115-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-251115-0011','kasir','1',' 700K-20-56','TOKO','MMPER','PMM-YKAD-48-0','CINCIN SILVER 925 ','','4.230','1','100.00','260000','0','0','16750','700000','0','0','0','700000','NIS','00039625','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.230',berat_jual_asli=berat_jual_asli+'4.230',stock_jual='1',berat_akhir=berat_akhir-'4.230',berat_akhir_asli=berat_akhir_asli-'4.230',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PMM-YKAD-48-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-251115-0011','2025-11-15','4.230','2025-11-15','18:05:53','PLG0007607','700000','700000','0','700000','0','kasir','2025-11-15 18:05:52','FJ-251115-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-11-15','FJ-251115-0011','2025-11-15','18:05:53','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-251115-0020','2025-11-15','2025-11-15 18:05:52','PENJUALAN : FJ-251115-0011','.','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-251115-0021','D','2025-11-15','18:05:53','TBC','PENJUALAN','FJ-251115-0011','17972423814','700000','17973123814','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-251115-0011' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01398','HELMI','1','PER','WEDDING RING','','','4.000','','925.00','1','60000','0','700000','0','700000','zirkon 1butir size 21','grf Ahmad & Rizka','krum RG 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-251115-0021','2025-11-15','2025-11-15 18:17:52','PESANAN : DP-01398','.','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-251115-0022','D','2025-11-15','18:17:52','TBC','PESANAN','DP-01398','17973123814','700000','17973823814','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-01398','2025-11-15','2025-11-15','18:17:52','PLG0007608','HELMI','2025-12-06','kasir','2025-11-15 18:17:52','4.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-251115-0012','kasir','1',' 800K-14-17','TOKO','BIPPER','PBDG-YKXF-38-0','CINCIN SILVER 925 ','','2.390','1','100.00','147000','0','0','16750','599000','0','0','0','599000','HELMI','00039515','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PBDG-YKXF-38-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-251115-0012','2025-11-15','2.390','2025-11-15','18:34:06','PLG0007609','599000','599000','0','599000','0','kasir','2025-11-15 18:34:06','FJ-251115-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-15','FJ-251115-0012','2025-11-15','18:34:06','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-251115-0022','2025-11-15','2025-11-15 18:34:06','PENJUALAN : FJ-251115-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-251115-0023','D','2025-11-15','18:34:06','TBC','PENJUALAN','FJ-251115-0012','17973823814','599000','17974422814','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-251115-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251115-0013','kasir',' 1',' 500K-17-00','TOKO','BIPPER','PMM-YKXF-22-0','CINCIN SILVER 925 ','','1.940','1','100.00','119000','0','0','16750','400000','0','0','0','400000','HELMI','00039499','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKXF-22-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-11-15' AND kode_barang='PMM-YKXF-22-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-251115-0013','2025-11-15','1.940','2025-11-15','18:34:06','PLG0007610','400000','400000','0','400000','0','kasir','2025-11-15 18:34:06','FJ-251115-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-15','FJ-251115-0013','2025-11-15','18:34:06','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-251115-0023','2025-11-15','2025-11-15 18:34:06','PENJUALAN : FJ-251115-0013','.','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-251115-0024','D','2025-11-15','18:34:06','TBC','PENJUALAN','FJ-251115-0013','17974422814','400000','17974822814','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='999000' WHERE no_faktur_jual='FJ-251115-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0013';
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-251115-0014','kasir','1',' DP-01324BI','TOKO','BIPPSN','PSPLT-YKAC-12-0','CINCIN PALADIUM ','','3.580','1','14.00','1247000','0','0','16750','2311000','0','0','0','2311000','HELMI','00039574','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKAC-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.580',berat_jual_asli=berat_jual_asli+'3.580',stock_jual='1',berat_akhir=berat_akhir-'3.580',berat_akhir_asli=berat_akhir_asli-'3.580',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PSPLT-YKAC-12-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-251115-0014','2025-11-15','3.580','2025-11-15','18:44:29','PLG0007611','2311000','2311000','0','2311000','0','kasir','2025-11-15 18:44:28','FJ-251115-0014','DP-01324','1137500');
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-15','FJ-251115-0014','2025-11-15','18:44:29','HELMI','2311000','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-251115-0024','2025-11-15','2025-11-15 18:44:28','PENJUALAN : FJ-251115-0014','.','TBC','1173500','1173500','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-251115-0025','D','2025-11-15','18:44:29','TBC','PENJUALAN','FJ-251115-0014','17974822814','1173500','17975996314','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='1173500' WHERE no_faktur_jual='FJ-251115-0014' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','18:51:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','18:51:39');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251115-0015','kasir','1',' DP-01314MM','TOKO','MMPSN','PSPLT-YKAD-1-0','CINCIN PALADIUM ','','2.430','1','13.00','786000','0','0','16750','1793500','0','0','0','1793500','NIS','00039578','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKAD-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PSPLT-YKAD-1-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-251115-0015','2025-11-15','2.430','2025-11-15','18:53:12','PLG0007612','1793500','1793500','0','1793500','0','kasir','2025-11-15 18:53:12','FJ-251115-0015','DP-01314','1460000');
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-15','FJ-251115-0015','2025-11-15','18:53:12','NIS','1793500','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-251115-0025','2025-11-15','2025-11-15 18:53:12','PENJUALAN : FJ-251115-0015','.','TBC','333500','333500','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-251115-0026','D','2025-11-15','18:53:12','TBC','PENJUALAN','FJ-251115-0015','17975996314','333500','17976329814','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='333500' WHERE no_faktur_jual='FJ-251115-0015' 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-01399','NITA','1','PLD','1 CINCIN PALLADIUM','','','5.000','','10.00','1','2260000','300000','0','700000','2200000','size 21 krum putih doff semprot lebar 4mm','grf Nuria font berkshire swash','request berat jangan lebih dari 5gr','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251115-0026','2025-11-15','2025-11-15 18:59:10','PESANAN : DP-01399','.','TBC','1100000','1100000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251115-0027','D','2025-11-15','18:59:10','TBC','PESANAN','DP-01399','17976329814','1100000','17977429814','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-01399','2025-11-15','2025-11-15','18:59:10','PLG0007613','NITA','2025-12-15','kasir','2025-11-15 18:59:10','5.000','0','0','0','1100000','0','700000','2200000','2200000','1100000');
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-251115-0016','kasir','1',' DP-01328MM','TOKO','MMPSN','PSGT-YKAD-16-0','CINCIN EMAS ','','2.900','1','83.00','5537000','0','0','16750','6758000','0','0','0','6758000','NIS','00039593','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKAD-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PSGT-YKAD-16-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-251115-0016','2025-11-15','2.900','2025-11-15','18:59:58','PLG0007614','6758000','6758000','0','6758000','0','kasir','2025-11-15 18:59:58','FJ-251115-0016','DP-01328','4484000');
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-15','FJ-251115-0016','2025-11-15','18:59:58','NIS','6758000','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-251115-0027','2025-11-15','2025-11-15 18:59:58','PENJUALAN : FJ-251115-0016','..','TBC','2274000','2274000','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-251115-0028','D','2025-11-15','18:59:58','TBC','PENJUALAN','FJ-251115-0016','17977429814','2274000','17979703814','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='2274000' WHERE no_faktur_jual='FJ-251115-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-251115-0017','kasir','1',' DP-01304BI','TOKO','BIPPSN','PSPRT-YKAA-8-0','CINCIN PERAK ','','1.350','1','100.00','83000','0','0','16750','850000','0','0','0','850000','SUL','00039560','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAA-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PSPRT-YKAA-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-251115-0017','2025-11-15','1.350','2025-11-15','19:16:48','PLG0007615','850000','850000','0','850000','0','kasir','2025-11-15 19:16:47','FJ-251115-0017','DP-01304','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-15','FJ-251115-0017','2025-11-15','19:16:48','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-251115-0017' 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-251115-0018','kasir',' 1',' DP-01303BI','TOKO','BIPPSN','PSPRT-YKAA-5-0','CINCIN PERAK ','','2.840','1','100.00','174000','0','0','16750','700000','0','0','0','700000','SUL','00039557','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YKAA-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PSPRT-YKAA-5-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-251115-0018','2025-11-15','2.840','2025-11-15','19:16:48','PLG0007616','700000','700000','0','700000','0','kasir','2025-11-15 19:16:47','FJ-251115-0017','DP-01303','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-15','FJ-251115-0018','2025-11-15','19:16:48','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-251115-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0018';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','19:39:14');
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-251115-0019','kasir','1',' 500K-21-17','TOKO','BIPPER','PBDG-YKXF-16-0','CINCIN SILVER 925 ','','2.130','1','100.00','131000','0','0','16750','400000','0','0','0','400000','HELMI','00039493','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PBDG-YKXF-16-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-251115-0019','2025-11-15','2.130','2025-11-15','19:47:14','PLG0007617','400000','400000','0','400000','0','kasir','2025-11-15 19:47:14','FJ-251115-0019','','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-15','FJ-251115-0019','2025-11-15','19:47:14','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-251115-0028','2025-11-15','2025-11-15 19:47:14','PENJUALAN : FJ-251115-0019','.','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-251115-0029','D','2025-11-15','19:47:14','TBC','PENJUALAN','FJ-251115-0019','17979703814','400000','17980103814','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-251115-0019' 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-251115-0020','kasir',' 1',' 800K-135-1','TOKO','BIPPER','PBDG-YKXF-46-0','CINCIN SILVER 925 ','','2.440','1','100.00','150000','0','0','16750','599000','0','0','0','599000','HELMI','00039523','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='PBDG-YKXF-46-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-251115-0020','2025-11-15','2.440','2025-11-15','19:47:14','PLG0007618','599000','599000','0','599000','0','kasir','2025-11-15 19:47:14','FJ-251115-0019','','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-15','FJ-251115-0020','2025-11-15','19:47:14','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-251115-0029','2025-11-15','2025-11-15 19:47:14','PENJUALAN : FJ-251115-0020','.','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-251115-0030','D','2025-11-15','19:47:14','TBC','PENJUALAN','FJ-251115-0020','17980103814','599000','17980702814','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='999000' WHERE no_faktur_jual='FJ-251115-0020' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0020';
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-01400','HELMI','1','GOLD','WEDDING RING','','','1.000','','75.00','1','2230000','2100000','0','750000','2850000','zirkon 1butir size 7','grf T ?? A 27.12.25','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-251115-0030','2025-11-15','2025-11-15 19:56:53','PESANAN : DP-01400','.','TBC','2100000','2100000');
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-251115-0031','D','2025-11-15','19:56:53','TBC','PESANAN','DP-01400','17980702814','2100000','17982802814','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-01400','2025-11-15','2025-11-15','19:56:53','PLG0007619','HELMI','2025-12-06','kasir','2025-11-15 19:56:53','1.000','0','0','0','2100000','0','750000','2850000','2850000','750000');
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-01401','HELMI','1','PER','WEDDING RING','','','2.000','','925.00','1','60000','0','700000','0','700000','zirkon 1butir size 11','grf W & R','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-251115-0031','2025-11-15','2025-11-15 20:05:58','PESANAN : DP-01401','.','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-251115-0032','D','2025-11-15','20:05:58','TBC','PESANAN','DP-01401','17982802814','700000','17983502814','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-01401','2025-11-15','2025-11-15','20:05:58','PLG0007620','HELMI','2025-12-06','kasir','2025-11-15 20:05:58','2.000','0','0','0','700000','0','0','700000','700000','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-01402','HELMI','1','PER','WEDDING RING','','','3.000','','925.00','1','60000','0','500000','0','500000','size 16 grf W & R','model ppn list tipis','krum putih doff amplas','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-251115-0032','2025-11-15','2025-11-15 20:08:31','PESANAN : DP-01402','.','TBC','500000','500000');
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-251115-0033','D','2025-11-15','20:08:31','TBC','PESANAN','DP-01402','17983502814','500000','17984002814','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-01402','2025-11-15','2025-11-15','20:08:31','PLG0007621','HELMI','2025-12-06','kasir','2025-11-15 20:08:31','3.000','0','0','0','500000','0','0','500000','500000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','20:15:39');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-15';
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-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-15';
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-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-15' 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-251116-0001','D','2025-11-16','20:16:08','TBC','SALDO AWAL','SALDO AWAL','0','17984002814','17984002814');
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-251116-0001','D','2025-11-16','20:16:08','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','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-251116-0001','D','2025-11-16','20:16:08','BCD','SALDO AWAL','SALDO AWAL','0','1334821000','1334821000');
UPDATE tp_system SET tgl_system='2025-11-16';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01459','HELMI','1','SEPASANG CC SLV','CEWE JD SIZE 7 COWO JD SIZE 20 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-01459','2025-11-15','2025-11-15','20:16:44','PLG0007622','kasir','2025-11-16','kasir','2025-11-15 20:16:44','5.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-01460','HELMI','1','CC SLV','JD SIZE 15 KRUM PUTIH DOFF SEMPROT','5.000','1','50000','50000');
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-251115-0033','2025-11-15','2025-11-15 20:21:53','SERVICE : SV-01460','.','TBC','50000','50000','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-251115-0001','D','2025-11-15','20:21:53','TBC','SERVICE','SV-01460','0','50000','50000','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-01460','2025-11-15','2025-11-15','20:21:53','PLG0007623','kasir','2025-11-16','kasir','2025-11-15 20:21:53','5.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01461','HELMI','1','CINCIN BERLIAN DAN SLV','CEWE JD SIZE 5 KRUM SPT ASAL DUA DUANYA','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-01461','2025-11-15','2025-11-15','20:25:16','PLG0007624','kasir','2025-11-16','kasir','2025-11-15 20:25:16','4.000','0','0','0','0','0','0','0','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-01403','NAD','1','GOLD','CINCIN NIKAH','','','3.000','','75.00','1','2230000','2100000','0','800000','7100000','size 11 krum putih sesuai cth','48butir dan 1butir bsr','expres jgn krg dari 3grm','0','530000','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251115-0034','2025-11-15','2025-11-15 20:46:18','PESANAN : DP-01403','.','TBC','6184000','6184000');
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-251115-0002','D','2025-11-15','20:46:18','TBC','PESANAN','DP-01403','50000','6184000','6234000','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-01403','2025-11-15','2025-11-15','20:46:18','PLG0007625','NAD','2025-11-24','kasir','2025-11-15 20:46:18','3.000','0','0','0','6184000','0','800000','7730000','7730000','1546000');
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-01404','NIS','1','PLD','CINCIN NIKAH','','','4.000','','25.00','1','2260000','450000','0','500000','2300000','size 25 krum putih sesuai cth','grf dwi ?? fitria','expres','0','0','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251115-0035','2025-11-15','2025-11-15 20:50:47','PESANAN : DP-01404','..','TBC','1920000','1920000');
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-251115-0003','D','2025-11-15','20:50:47','TBC','PESANAN','DP-01404','6234000','1920000','8154000','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-01404','2025-11-15','2025-11-15','20:50:47','PLG0007626','NIS','2025-11-24','kasir','2025-11-15 20:50:47','4.000','0','0','0','1920000','0','500000','2400000','2400000','480000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-15 ','21:37:47');