INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','10:33: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-251012-0001','kasir','1',' DP-01132BI','TOKO','BIPPSN','PSPLT-YJXH-35-0','CINCIN PALADIUM ','','4.510','1','6.00','626000','0','0','16600','1827500','0','0','0','1827500','SUL','00039124','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJXH-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.510',berat_jual_asli=berat_jual_asli+'4.510',stock_jual='1',berat_akhir=berat_akhir-'4.510',berat_akhir_asli=berat_akhir_asli-'4.510',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPLT-YJXH-35-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-251012-0001','2025-10-12','4.510','2025-10-12','10:37:13','PLG0006907','1827500','1827500','0','1827500','0','kasir','2025-10-12 10:37:12','FJ-251012-0001','DP-01132','975000');
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-10-12','FJ-251012-0001','2025-10-12','10:37:13','SUL','1827500','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-251012-0001','2025-10-12','2025-10-12 10:37:12','PENJUALAN : FJ-251012-0001','.','TBC','1827500','1827500','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-251012-0002','D','2025-10-12','10:37:13','TBC','PENJUALAN','FJ-251012-0001','17260096514','1827500','17261924014','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='1827500' WHERE no_faktur_jual='FJ-251012-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-251012-0002','kasir',' 1',' DP-01131BI','TOKO','BIPPSN','PSGT-YJXH-43-0','CINCIN EMAS ','','2.090','1','83.00','3716000','0','0','16600','4315700','0','0','0','4315700','SUL','00039132','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YJXH-43-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-10-12' AND kode_barang='PSGT-YJXH-43-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-251012-0002','2025-10-12','2.090','2025-10-12','10:37:13','PLG0006908','4315700','4315700','0','4315700','0','kasir','2025-10-12 10:37:12','FJ-251012-0001','DP-01131','3328000');
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-10-12','FJ-251012-0002','2025-10-12','10:37:13','SUL','4315700','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1827500' WHERE no_faktur_jual='FJ-251012-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0002';
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-251012-0003','kasir','1',' 900K-14-16','TOKO','BIPPER','PBDG-YIBC-21-0','CINCIN SILVER 925 ','','1.910','1','100.00','49000','0','0','16600','900000','0','0','0','900000','NITA','00038853','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIBC-21-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-10-12' AND kode_barang='PBDG-YIBC-21-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-251012-0003','2025-10-12','1.910','2025-10-12','10:40:11','PLG0006909','900000','900000','0','900000','0','kasir','2025-10-12 10:40:11','FJ-251012-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-10-12','FJ-251012-0003','2025-10-12','10:40:11','NITA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251012-0002','2025-10-12','2025-10-12 10:40:11','PENJUALAN : FJ-251012-0003','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251012-0003','D','2025-10-12','10:40:11','TBC','PENJUALAN','FJ-251012-0003','17261924014','900000','17262824014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-251012-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251012-0004','kasir',' 1',' 700K-23-16','TOKO','BIPPER','PBDG-YJXC-24-0','CINCIN SILVER 925 ','','4.910','1','100.00','126000','0','0','16600','700000','0','0','0','700000','NITA','00038995','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJXC-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.910',berat_jual_asli=berat_jual_asli+'4.910',stock_jual='1',berat_akhir=berat_akhir-'4.910',berat_akhir_asli=berat_akhir_asli-'4.910',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PBDG-YJXC-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-251012-0004','2025-10-12','4.910','2025-10-12','10:40:11','PLG0006910','700000','700000','0','700000','0','kasir','2025-10-12 10:40:11','FJ-251012-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-10-12','FJ-251012-0004','2025-10-12','10:40:11','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-251012-0003','2025-10-12','2025-10-12 10:40:11','PENJUALAN : FJ-251012-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-251012-0004','D','2025-10-12','10:40:11','TBC','PENJUALAN','FJ-251012-0004','17262824014','700000','17263524014','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='1600000' WHERE no_faktur_jual='FJ-251012-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','10:41: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-251012-0005','kasir','1',' 800K-14-12','TOKO','BIPPER','PBDG-YEBH-7-0','CINCIN SILVER 925 ','','1.960','1','100.00','46000','0','0','16600','800000','0','0','0','800000','NITA','00035927','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YEBH-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PBDG-YEBH-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251012-0005','2025-10-12','1.960','2025-10-12','11:15:14','PLG0006911','800000','800000','0','800000','0','kasir','2025-10-12 11:15:13','FJ-251012-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-10-12','FJ-251012-0005','2025-10-12','11:15:14','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-251012-0004','2025-10-12','2025-10-12 11:15:13','PENJUALAN : FJ-251012-0005','.','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-251012-0005','D','2025-10-12','11:15:14','TBC','PENJUALAN','FJ-251012-0005','17263524014','800000','17264324014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-251012-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-251012-0006','kasir',' 1',' 500K-19-16','TOKO','BIPPER','PBDG-YIAH-11-0','CINCIN SILVER 925 ','','2.000','1','100.00','51000','0','0','16600','500000','0','0','0','500000','NITA','00038809','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIAH-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PBDG-YIAH-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-251012-0006','2025-10-12','2.000','2025-10-12','11:15:14','PLG0006912','500000','500000','0','500000','0','kasir','2025-10-12 11:15:13','FJ-251012-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-10-12','FJ-251012-0006','2025-10-12','11:15:14','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-251012-0005','2025-10-12','2025-10-12 11:15:13','PENJUALAN : FJ-251012-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-251012-0006','D','2025-10-12','11:15:14','TBC','PENJUALAN','FJ-251012-0006','17264324014','500000','17264824014','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-251012-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0006';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01336','NITA','1','WEDDING RING','CC CEWE SZ 16 FONT BERKSHIRE SWASH','3.960','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-01336','2025-10-12','2025-10-12','11:45:09','PLG0006913','kasir','2025-10-21','kasir','2025-10-12 11:45:09','3.960','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','11:58:15');
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-251012-0007','kasir','1',' 850K-15-00','TOKO','MMPER','PMM-YGXI-25-0','CINCIN SILVER 925 ','','1.950','1','100.00','45000','0','0','16600','850000','0','0','0','850000','NIS','00037086','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXI-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PMM-YGXI-25-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-251012-0007','2025-10-12','1.950','2025-10-12','12:01:08','PLG0006914','850000','850000','0','850000','0','kasir','2025-10-12 12:01:08','FJ-251012-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','FJ-251012-0007','2025-10-12','12:01:08','NIS','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251012-0006','2025-10-12','2025-10-12 12:01:08','PENJUALAN : FJ-251012-0007','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251012-0007','D','2025-10-12','12:01:08','TBC','PENJUALAN','FJ-251012-0007','17264824014','850000','17265674014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-251012-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251012-0008','kasir','1',' DP-01191BI','TOKO','BIPPSN','PSPLT-YJAX-15-0','CINCIN PALADIUM ','','5.040','1','6.00','703000','0','0','16600','1760000','0','0','0','1760000','SUL','00039161','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJAX-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.040',berat_jual_asli=berat_jual_asli+'5.040',stock_jual='1',berat_akhir=berat_akhir-'5.040',berat_akhir_asli=berat_akhir_asli-'5.040',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPLT-YJAX-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251012-0008','2025-10-12','5.040','2025-10-12','12:03:46','PLG0006915','1760000','1760000','0','1760000','0','kasir','2025-10-12 12:03:46','FJ-251012-0008','DP-01191','875000');
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-10-12','FJ-251012-0008','2025-10-12','12:03:46','SUL','1760000','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-251012-0007','2025-10-12','2025-10-12 12:03:46','PENJUALAN : FJ-251012-0008','.','TBC','885000','885000','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-251012-0008','D','2025-10-12','12:03:46','TBC','PENJUALAN','FJ-251012-0008','17265674014','885000','17266559014','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='885000' WHERE no_faktur_jual='FJ-251012-0008' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01224','SULIS','1','GOLD','WEDDING RING','','','2.000','','75.00','1','2130000','1900000','0','750000','4550000','15 ZIRCON','model atas di buat 1 permata sz 5.5 crom putih glosy','font berkshire swash grf SAA ','','','');
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-01224','SULIS','2','0','','','','','','','','0','','','','','','','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0008','2025-10-12','2025-10-12 12:16:21','PESANAN : DP-01224','.','TBC','3760000','3760000');
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-251012-0009','D','2025-10-12','12:16:21','TBC','PESANAN','DP-01224','17266559014','3760000','17270319014','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-01224','2025-10-12','2025-10-12','12:16:21','PLG0006916','SULIS','2025-10-26','kasir','2025-10-12 12:16:21','2.000','0','0','0','3760000','0','750000','4700000','4700000','940000');
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-251012-0009','kasir','1',' BDCM1.010K','TOKO','BIPCMP','BDCM-YFAH-14-0','BANDUNG CINCIN EMAS ','','2.500','1','83.00','5083000','0','0','16600','5500000','0','0','0','5500000','HELMI','00036413','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YFAH-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='BDCM-YFAH-14-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-251012-0009','2025-10-12','2.500','2025-10-12','12:17:58','PLG0006917','5500000','5500000','0','5500000','0','kasir','2025-10-12 12:17:58','FJ-251012-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','FJ-251012-0009','2025-10-12','12:17:58','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-251012-0009','2025-10-12','2025-10-12 12:17:58','PENJUALAN : FJ-251012-0009','.','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-251012-0010','D','2025-10-12','12:17:58','TBC','PENJUALAN','FJ-251012-0009','17270319014','5500000','17275819014','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='5500000' WHERE no_faktur_jual='FJ-251012-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0009';
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-01225','SULIS','1','PLD','WEDDING RING','','','3.500','','10.00','1','2100000','250000','0','500000','1375000','model tanpa permata sz 12','crom putih doff amplass font berkshire swash','grf SAA ','','','');
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-01225','SULIS','2','0','','','','','','','','0','','','','','','','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0010','2025-10-12','2025-10-12 12:20:54','PESANAN : DP-01225','.','TBC','687500','687500');
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-251012-0011','D','2025-10-12','12:20:54','TBC','PESANAN','DP-01225','17275819014','687500','17276506514','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-01225','2025-10-12','2025-10-12','12:20:54','PLG0006918','SULIS','2025-10-26','kasir','2025-10-12 12:20:54','3.500','0','0','0','687500','0','500000','1375000','1375000','687500');
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-251012-0010','kasir','1',' DP-01139BI','TOKO','BIPPSN','PSPLT-YJXH-34-0','CINCIN PALADIUM ','','3.000','1','6.00','416000','0','0','16600','1450000','0','0','0','1450000','SUL','00039123','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJXH-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPLT-YJXH-34-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-251012-0010','2025-10-12','3.000','2025-10-12','12:30:59','PLG0006919','1450000','1450000','0','1450000','0','kasir','2025-10-12 12:30:59','FJ-251012-0010','DP-01139','787500');
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-10-12','FJ-251012-0010','2025-10-12','12:30:59','SUL','1450000','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-251012-0011','2025-10-12','2025-10-12 12:30:59','PENJUALAN : FJ-251012-0010','.','TBC','662500','662500','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-251012-0012','D','2025-10-12','12:30:59','TBC','PENJUALAN','FJ-251012-0010','17276506514','662500','17277169014','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='662500' WHERE no_faktur_jual='FJ-251012-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-251012-0011','kasir',' 1',' DP-01140BI','TOKO','BIPPSN','PSGT-YJXH-33-0','CINCIN EMAS ','','1.820','1','83.00','3236000','0','0','16600','4005000','0','0','0','4005000','SUL','00039122','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YJXH-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSGT-YJXH-33-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-251012-0011','2025-10-12','1.820','2025-10-12','12:30:59','PLG0006920','4005000','4005000','0','4005000','0','kasir','2025-10-12 12:30:59','FJ-251012-0010','DP-01140','3456000');
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-10-12','FJ-251012-0011','2025-10-12','12:30:59','SUL','4005000','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-251012-0012','2025-10-12','2025-10-12 12:30:59','PENJUALAN : FJ-251012-0011','.','TBC','549000','549000','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-251012-0013','D','2025-10-12','12:30:59','TBC','PENJUALAN','FJ-251012-0011','17277169014','549000','17277718014','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='1211500' WHERE no_faktur_jual='FJ-251012-0011' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251012-0012','kasir','1',' 1.150K-9-1','TOKO','BIPPER','PBDG-YIAG-35-0','CINCIN SILVER 925 ','','2.500','1','100.00','64000','0','0','16600','1150000','0','0','0','1150000','NITA','00038797','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIAG-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PBDG-YIAG-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251012-0012','2025-10-12','2.500','2025-10-12','13:05:34','PLG0006921','1150000','1150000','0','1150000','0','kasir','2025-10-12 13:05:34','FJ-251012-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-10-12','FJ-251012-0012','2025-10-12','13:05:34','NITA','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-251012-0013','2025-10-12','2025-10-12 13:05:34','PENJUALAN : FJ-251012-0012','.','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-251012-0014','D','2025-10-12','13:05:34','TBC','PENJUALAN','FJ-251012-0012','17277718014','1150000','17278868014','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-251012-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-251012-0013','kasir','1',' 700K-12-00','TOKO','MMPER','PMM-YFBX-71-0','CINCIN SILVER 925 ','','2.380','1','100.00','56000','0','0','16600','700000','0','0','0','700000','NIS','00036512','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PMM-YFBX-71-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-251012-0013','2025-10-12','2.380','2025-10-12','13:11:09','PLG0006922','700000','700000','0','700000','0','kasir','2025-10-12 13:11:08','FJ-251012-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-10-12','FJ-251012-0013','2025-10-12','13:11:09','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-251012-0014','2025-10-12','2025-10-12 13:11:08','PENJUALAN : FJ-251012-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-251012-0015','D','2025-10-12','13:11:09','TBC','PENJUALAN','FJ-251012-0013','17278868014','700000','17279568014','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-251012-0013' 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-251012-0014','kasir','1',' 700K-15-00','TOKO','MMPER','PMM-YGAE-20-0','CINCIN SILVER 925 ','','3.020','1','100.00','62000','0','0','16600','700000','0','0','0','700000','NAD','00037200','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAE-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PMM-YGAE-20-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-251012-0014','2025-10-12','3.020','2025-10-12','13:11:41','PLG0006923','700000','700000','0','700000','0','kasir','2025-10-12 13:11:41','FJ-251012-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-12','FJ-251012-0014','2025-10-12','13:11:41','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-251012-0015','2025-10-12','2025-10-12 13:11:41','PENJUALAN : FJ-251012-0014','.','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-251012-0016','D','2025-10-12','13:11:41','TBC','PENJUALAN','FJ-251012-0014','17279568014','700000','17280268014','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-251012-0014' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01337','NIS','1','2PCS CINCIN SLV','CEWE GRF FERIZA DAN COWO RESIZE KE 18 GRF MUTIARA','5.400','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-01337','2025-10-12','2025-10-12','13:14:40','PLG0006924','kasir','2025-10-13','kasir','2025-10-12 13:14:40','5.400','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-01226','NITA','1','PER','WEDDING RING','','','5.000','','925.00','1','25000','0','700000','0','700000','zircon 1','sz 11 grf Revita font vladimir','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0016','2025-10-12','2025-10-12 13:28:18','PESANAN : DP-01226','.','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-251012-0017','D','2025-10-12','13:28:18','TBC','PESANAN','DP-01226','17280268014','700000','17280968014','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-01226','2025-10-12','2025-10-12','13:28:18','PLG0006925','NITA','2025-11-09','kasir','2025-10-12 13:28:18','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-01338','NITA','1','WEDDING RING','FONT VLADIMIR KRUM SPT ASAL','2.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-01338','2025-10-12','2025-10-12','13:32:38','PLG0006926','kasir','2025-10-13','kasir','2025-10-12 13:32:38','2.500','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','13:33:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','14:30:53');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01227','SULIS','1','PER','WEDDING RINNG','','','2.000','','925.00','1','25000','0','700000','0','700000','1 zircon sz 14 crom putih glosy','font vintage rotter grf Luthfiah','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0017','2025-10-12','2025-10-12 14:53:57','PESANAN : DP-01227','.','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-251012-0018','D','2025-10-12','14:53:57','TBC','PESANAN','DP-01227','17280968014','700000','17281668014','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-01227','2025-10-12','2025-10-12','14:53:57','PLG0006927','SULIS','2025-11-12','kasir','2025-10-12 14:53:57','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-01228','SULIS','1','PER','WEDDING RING','','','2.000','','925.00','1','25000','0','850000','0','850000','sz 10 crom putih glosy','font vintage rotter grf Ginanjar','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0018','2025-10-12','2025-10-12 14:57:28','PESANAN : DP-01228','.','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-251012-0019','D','2025-10-12','14:57:28','TBC','PESANAN','DP-01228','17281668014','850000','17282518014','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-01228','2025-10-12','2025-10-12','14:57:28','PLG0006928','SULIS','2025-11-12','kasir','2025-10-12 14:57:28','2.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-01229','SULIS','1','GOLD','WEDDING RING','','','1.000','','75.00','1','2130000','1900000','0','750000','2650000','20 zircon','sz 14 crom putih glosy','font vintege rotter grf Bagas','200000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0019','2025-10-12','2025-10-12 14:59:53','PESANAN : DP-01229','.','TBC','2280000','2280000');
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-251012-0020','D','2025-10-12','14:59:53','TBC','PESANAN','DP-01229','17282518014','2280000','17284798014','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-01229','2025-10-12','2025-10-12','14:59:53','PLG0006929','SULIS','2025-11-01','kasir','2025-10-12 14:59:53','1.000','0','0','0','2280000','0','750000','2850000','2850000','570000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01339','HELMI','1','CC EMAS','KRUM SPT ASAL','2.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-01339','2025-10-12','2025-10-12','15:13:31','PLG0006930','kasir','2025-10-13','kasir','2025-10-12 15:13:31','2.500','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','15:13:51');
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-01230','HELMI','1','PLD','WEDDING RING','','','4.000','','10.00','1','2100000','250000','0','700000','1700000','zirkon 1butir size 22','grf Vina ?? Fauzan','krum kombinasi RG spt contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0020','2025-10-12','2025-10-12 15:26:21','PESANAN : DP-01230','.','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-251012-0021','D','2025-10-12','15:26:21','TBC','PESANAN','DP-01230','17284798014','850000','17285648014','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-01230','2025-10-12','2025-10-12','15:26:21','PLG0006931','HELMI','2025-11-05','kasir','2025-10-12 15:26:21','4.000','0','0','0','850000','0','700000','1700000','1700000','850000');
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-01231','HELMI','1','PLD','WEDDING RING','','','2.000','','25.00','1','2100000','450000','0','750000','1650000','zirkon 15butir','size 18 model seperti contoh','krum putih glosy','150000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0021','2025-10-12','2025-10-12 15:59:00','PESANAN : DP-01231','.','TBC','900000','900000');
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-251012-0022','D','2025-10-12','15:59:00','TBC','PESANAN','DP-01231','17285648014','900000','17286548014','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-01231','2025-10-12','2025-10-12','15:59:00','PLG0006932','HELMI','2025-11-12','kasir','2025-10-12 15:59:00','2.000','0','0','0','900000','0','750000','1800000','1800000','900000');
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-01232','HELMI','1','PLD','WEDDING RING','','','5.000','','25.00','1','2100000','450000','0','500000','2750000','size 19','krum putih doff amplas','model ppn list','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-251012-0022','2025-10-12','2025-10-12 16:03:54','PESANAN : DP-01232','.','TBC','1375000','1375000');
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-251012-0023','D','2025-10-12','16:03:54','TBC','PESANAN','DP-01232','17286548014','1375000','17287923014','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-01232','2025-10-12','2025-10-12','16:03:54','PLG0006933','HELMI','2025-11-12','kasir','2025-10-12 16:03:54','5.000','0','0','0','1375000','0','500000','2750000','2750000','1375000');
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-01233','NAD','1','PLD','CINCIN NIKAH','','','2.900','','25.00','1','2100000','450000','0','1000000','2305000','SIZE 16 GRF ARYA','16 BUTIR DAN 1 BUTIR BSR','KRUM PUTIH SESUAI CTH','0','210000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0023','2025-10-12','2025-10-12 16:06:43','PESANAN : DP-01233','.','TBC','2012000','2012000');
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-251012-0024','D','2025-10-12','16:06:43','TBC','PESANAN','DP-01233','17287923014','2012000','17289935014','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-01233','2025-10-12','2025-10-12','16:06:43','PLG0006934','NAD','2025-10-26','kasir','2025-10-12 16:06:43','2.900','0','0','0','2012000','0','1000000','2515000','2515000','503000');
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-01234','NIS','1','PLD','CINCIN NIKAH','','','3.100','','25.00','1','2100000','450000','0','700000','2095000','SIZE 25 GRF ALDA','PAKAI MATA 1 BUTIR','KRUM PUTIH SESUAI CTH DOVE ALUS','0','10000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0024','2025-10-12','2025-10-12 16:09:37','PESANAN : DP-01234','.','TBC','1684000','1684000');
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-251012-0025','D','2025-10-12','16:09:37','TBC','PESANAN','DP-01234','17289935014','1684000','17291619014','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-01234','2025-10-12','2025-10-12','16:09:37','PLG0006935','NIS','2025-10-26','kasir','2025-10-12 16:09:37','3.100','0','0','0','1684000','0','700000','2105000','2105000','421000');
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-251012-0015','kasir','1',' DP-01212BI','TOKO','BIPPSN','PSPRT-YJAX-31-0','CINCIN PERAK ','','2.410','1','100.00','62000','0','0','16600','700000','0','0','0','700000','HELMI','00039177','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJAX-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPRT-YJAX-31-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-251012-0015','2025-10-12','2.410','2025-10-12','16:28:28','PLG0006936','700000','700000','0','700000','0','kasir','2025-10-12 16:28:27','FJ-251012-0015','DP-01212','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-10-12','FJ-251012-0015','2025-10-12','16:28:28','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-251012-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0015';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251012-0016','kasir','1',' DP-01145BI','TOKO','BIPPSN','PSGT-YJXH-32-0','CINCIN EMAS ','','1.650','1','83.00','2934000','0','0','16600','3747500','0','0','0','3747500','HELMI','00039121','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YJXH-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSGT-YJXH-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251012-0016','2025-10-12','1.650','2025-10-12','16:57:04','PLG0006937','3747500','3747500','0','3747500','0','kasir','2025-10-12 16:57:04','FJ-251012-0016','DP-01145','2780000');
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-10-12','FJ-251012-0016','2025-10-12','16:57:04','HELMI','3747500','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-251012-0025','2025-10-12','2025-10-12 16:57:04','PENJUALAN : FJ-251012-0016','.','TBC','967500','967500','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-251012-0026','D','2025-10-12','16:57:04','TBC','PENJUALAN','FJ-251012-0016','17291619014','967500','17292586514','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='967500' WHERE no_faktur_jual='FJ-251012-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-251012-0017','kasir',' 1',' DP-01146BI','TOKO','BIPPSN','PSPLT-YJXH-31-0','CINCIN PALADIUM ','','4.460','1','6.00','619000','0','0','16600','1815000','0','0','0','1815000','HELMI','00039120','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJXH-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.460',berat_jual_asli=berat_jual_asli+'4.460',stock_jual='1',berat_akhir=berat_akhir-'4.460',berat_akhir_asli=berat_akhir_asli-'4.460',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPLT-YJXH-31-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-251012-0017','2025-10-12','4.460','2025-10-12','16:57:04','PLG0006938','1815000','1815000','0','1815000','0','kasir','2025-10-12 16:57:04','FJ-251012-0016','DP-01146','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-10-12','FJ-251012-0017','2025-10-12','16:57:04','HELMI','1815000','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-251012-0026','2025-10-12','2025-10-12 16:57:04','PENJUALAN : FJ-251012-0017','.','TBC','965000','965000','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-251012-0027','D','2025-10-12','16:57:04','TBC','PENJUALAN','FJ-251012-0017','17292586514','965000','17293551514','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='1932500' WHERE no_faktur_jual='FJ-251012-0017' 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-01235','NAD','1','PLD','CINCIN NIKAH','','','2.000','','10.00','1','2100000','250000','150000','750000','1400000','SIZE 13.5 KRUM FULL PUTIH','','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251012-0027','2025-10-12','2025-10-12 16:59:02','PESANAN : DP-01235','.','TBC','1120000','1120000');
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-251012-0028','D','2025-10-12','16:59:02','TBC','PESANAN','DP-01235','17293551514','1120000','17294671514','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-01235','2025-10-12','2025-10-12','16:59:02','PLG0006939','NAD','2025-10-26','kasir','2025-10-12 16:59:02','2.000','0','0','0','1120000','0','750000','1400000','1400000','280000');
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-251012-0018','kasir','1',' DP-01107MM','TOKO','MMPSN','PSPLT-YIBE-23-0','CINCIN PALADIUM ','','4.260','1','6.00','561000','0','0','16600','1765000','0','0','0','1765000','NIS','00038910','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIBE-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.260',berat_jual_asli=berat_jual_asli+'4.260',stock_jual='1',berat_akhir=berat_akhir-'4.260',berat_akhir_asli=berat_akhir_asli-'4.260',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPLT-YIBE-23-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-251012-0018','2025-10-12','4.260','2025-10-12','17:49:44','PLG0006940','1765000','1765000','0','1765000','0','kasir','2025-10-12 17:49:43','FJ-251012-0018','DP-01107','1560000');
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-10-12','FJ-251012-0018','2025-10-12','17:49:44','NIS','1765000','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-251012-0028','2025-10-12','2025-10-12 17:49:43','PENJUALAN : FJ-251012-0018','.','TBC','205000','205000','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-251012-0029','D','2025-10-12','17:49:44','TBC','PENJUALAN','FJ-251012-0018','17294671514','205000','17294876514','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='205000' WHERE no_faktur_jual='FJ-251012-0018' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251012-0019','kasir',' 1',' DP-01106MM','TOKO','MMPSN','PSPLT-YIBE-34-0','CINCIN PALADIUM ','','1.780','1','6.00','235000','0','0','16600','1195000','0','0','0','1195000','NIS','00038921','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIBE-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPLT-YIBE-34-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-251012-0019','2025-10-12','1.780','2025-10-12','17:49:44','PLG0006941','1195000','1195000','0','1195000','0','kasir','2025-10-12 17:49:43','FJ-251012-0018','DP-01106','1080000');
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-10-12','FJ-251012-0019','2025-10-12','17:49:44','NIS','1195000','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-251012-0029','2025-10-12','2025-10-12 17:49:43','PENJUALAN : FJ-251012-0019','.','TBC','115000','115000','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-251012-0030','D','2025-10-12','17:49:44','TBC','PENJUALAN','FJ-251012-0019','17294876514','115000','17294991514','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='320000' WHERE no_faktur_jual='FJ-251012-0019' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01340','NIS','1','2 PCS CINCIN PLD','KRUM PUTIH DUA DUANYA GRF JGN HILANG CEWE RESIZE KE 13','6.040','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-01340','2025-10-12','2025-10-12','17:57:29','PLG0006942','kasir','2025-10-13','kasir','2025-10-12 17:57:29','6.040','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','17:58:18');
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-251012-0020','kasir','1',' DP-01150BI','TOKO','BIPPSN','PSPRT-YJXG-38-0','CINCIN PERAK ','','2.480','1','100.00','64000','0','0','16600','700000','0','0','0','700000','SUL','00039088','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJXG-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.480',berat_jual_asli=berat_jual_asli+'2.480',stock_jual='1',berat_akhir=berat_akhir-'2.480',berat_akhir_asli=berat_akhir_asli-'2.480',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPRT-YJXG-38-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-251012-0020','2025-10-12','2.480','2025-10-12','18:02:08','PLG0006943','700000','700000','0','700000','0','kasir','2025-10-12 18:02:07','FJ-251012-0020','DP-01150','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-10-12','FJ-251012-0020','2025-10-12','18:02:08','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-251012-0020' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251012-0021','kasir',' 1',' DP-01151BI','TOKO','BIPPSN','PSPRT-YJXG-39-0','CINCIN PERAK ','','2.110','1','100.00','55000','0','0','16600','700000','0','0','0','700000','SUL','00039089','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJXG-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PSPRT-YJXG-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251012-0021','2025-10-12','2.110','2025-10-12','18:02:08','PLG0006944','700000','700000','0','700000','0','kasir','2025-10-12 18:02:07','FJ-251012-0020','DP-01151','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-10-12','FJ-251012-0021','2025-10-12','18:02:08','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-251012-0021' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0021';
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-251012-0022','kasir','1',' 700K-15 ','TOKO','BIPCMP','BDCM-YGAF-34-0','BANDUNG CINCIN EMAS ','','1.930','1','83.00','3481000','0','0','16600','4367000','0','0','0','4367000','NITA','00037253','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YGAF-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='BDCM-YGAF-34-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-251012-0022','2025-10-12','1.930','2025-10-12','18:31:34','PLG0006945','4367000','4367000','0','4367000','0','kasir','2025-10-12 18:31:34','FJ-251012-0022','','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-10-12','FJ-251012-0022','2025-10-12','18:31:34','NITA','4367000','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-251012-0030','2025-10-12','2025-10-12 18:31:34','PENJUALAN : FJ-251012-0022','.','TBC','4367000','4367000','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-251012-0031','D','2025-10-12','18:31:34','TBC','PENJUALAN','FJ-251012-0022','17294991514','4367000','17299358514','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='4367000' WHERE no_faktur_jual='FJ-251012-0022' 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-251012-0023','kasir',' 1',' PLBDG-0008','TOKO','BIPPLD','PLBDG-YJXH-39-0','CINCIN PALADIUM PLBDG-00088 ','','2.520','1','6.00','350000','0','0','16600','1330000','0','0','0','1330000','NITA','00039128','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-YJXH-39-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-10-12' AND kode_barang='PLBDG-YJXH-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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-251012-0023','2025-10-12','2.520','2025-10-12','18:31:34','PLG0006946','1330000','1330000','0','1330000','0','kasir','2025-10-12 18:31:34','FJ-251012-0022','','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-10-12','FJ-251012-0023','2025-10-12','18:31:34','NITA','1330000','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-251012-0031','2025-10-12','2025-10-12 18:31:34','PENJUALAN : FJ-251012-0023','.','TBC','1330000','1330000','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-251012-0032','D','2025-10-12','18:31:34','TBC','PENJUALAN','FJ-251012-0023','17299358514','1330000','17300688514','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='5697000' WHERE no_faktur_jual='FJ-251012-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0023';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01341','NITA','1','CINCIN PALLADIUM','SIZE 16 KRUM SEPERTI ASAL','2.250','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-01341','2025-10-12','2025-10-12','18:49:04','PLG0006947','kasir','2025-10-21','kasir','2025-10-12 18:49:04','2.250','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-251012-0024','kasir','1',' 800K-15-14','TOKO','BIPPER','PBDG-YGAE-14-0','CINCIN SILVER 925 ','','1.790','1','100.00','37000','0','0','16600','750000','0','0','0','750000','HELMI','00037194','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YGAE-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.790',berat_jual_asli=berat_jual_asli+'1.790',stock_jual='1',berat_akhir=berat_akhir-'1.790',berat_akhir_asli=berat_akhir_asli-'1.790',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PBDG-YGAE-14-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-251012-0024','2025-10-12','1.790','2025-10-12','18:56:29','PLG0006948','750000','750000','0','750000','0','kasir','2025-10-12 18:56:28','FJ-251012-0024','','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-10-12','FJ-251012-0024','2025-10-12','18:56:29','HELMI','750000','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-251012-0032','2025-10-12','2025-10-12 18:56:28','PENJUALAN : FJ-251012-0024','.','TBC','750000','750000','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-251012-0033','D','2025-10-12','18:56:29','TBC','PENJUALAN','FJ-251012-0024','17300688514','750000','17301438514','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='750000' WHERE no_faktur_jual='FJ-251012-0024' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0024';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','18:59:28');
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-251012-0025','kasir','1',' 850K-16-15','TOKO','BIPPER','PBDG-YHBI-12-0','CINCIN SILVER 925 ','','2.450','1','100.00','63000','0','0','16600','599000','0','0','0','599000','SUL','00038363','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHBI-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='PBDG-YHBI-12-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-251012-0025','2025-10-12','2.450','2025-10-12','19:06:34','PLG0006949','599000','599000','0','599000','0','kasir','2025-10-12 19:06:33','FJ-251012-0025','','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-10-12','FJ-251012-0025','2025-10-12','19:06:34','SUL','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-251012-0033','2025-10-12','2025-10-12 19:06:33','PENJUALAN : FJ-251012-0025','.','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-251012-0034','D','2025-10-12','19:06:34','TBC','PENJUALAN','FJ-251012-0025','17301438514','599000','17302037514','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-251012-0025' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0025';
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-251012-0026','kasir','1',' CKBT-00076','TOKO','TFCKB','CKBT-WBXG-20-0','CINCIN KAWIN CKBT-00076','','3.490','1','83.00','8014000','798500','48','16600','8880000','0','0','0','8880000','FIR','00020244','CKBT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKBT-WBXG-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.490',berat_jual_asli=berat_jual_asli+'3.490',stock_jual='1',berat_akhir=berat_akhir-'3.490',berat_akhir_asli=berat_akhir_asli-'3.490',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='CKBT-WBXG-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCKB' 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-251012-0026','2025-10-12','3.490','2025-10-12','19:50:44','PLG0006950','8880000','8880000','0','8880000','0','kasir','2025-10-12 19:50:43','FJ-251012-0026','','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-10-12','FJ-251012-0026','2025-10-12','19:50:44','FIR','8880000','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-251012-0034','2025-10-12','2025-10-12 19:50:43','PENJUALAN : FJ-251012-0026','','TBC','8880000','8880000','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-251012-0035','D','2025-10-12','19:50:44','TBC','PENJUALAN BERLIAN','FJ-251012-0026','17302037514','8880000','17310917514','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='8880000' WHERE no_faktur_jual='FJ-251012-0026' 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-251012-0027','kasir',' 1',' TFPLD-0000','TOKO','TFPLD','TFPLD-YEXI-28-0','CINCIN PALADIUM TFPLD-00001 ','','4.480','1','7.00','632000','0','0','16600','1620000','0','0','0','1620000','FIR','00035533','TFPLD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFPLD-YEXI-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.480',berat_jual_asli=berat_jual_asli+'4.480',stock_jual='1',berat_akhir=berat_akhir-'4.480',berat_akhir_asli=berat_akhir_asli-'4.480',stock_akhir='0' WHERE tanggal='2025-10-12' AND kode_barang='TFPLD-YEXI-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFPLD' 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-251012-0027','2025-10-12','4.480','2025-10-12','19:50:44','PLG0006951','1620000','1620000','0','1620000','0','kasir','2025-10-12 19:50:43','FJ-251012-0026','','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-10-12','FJ-251012-0027','2025-10-12','19:50:44','FIR','1620000','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-251012-0035','2025-10-12','2025-10-12 19:50:43','PENJUALAN : FJ-251012-0027','','TBC','1620000','1620000','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-251012-0036','D','2025-10-12','19:50:44','TBC','PENJUALAN','FJ-251012-0027','17310917514','1620000','17312537514','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='10500000' WHERE no_faktur_jual='FJ-251012-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0027';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','19:56:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','19:57:01');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-12';
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-10-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-12' 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-251013-0001','D','2025-10-13','20:24:47','TBC','SALDO AWAL','SALDO AWAL','0','17312537514','17312537514');
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-251013-0001','D','2025-10-13','20:24:47','BCD','SALDO AWAL','SALDO AWAL','0','1330221000','1330221000');
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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','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-251013-0001','D','2025-10-13','20:24:47','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
UPDATE tp_system SET tgl_system='2025-10-13';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-12 ','21:23:13');
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-251012-0028','kasir','1',' DP-01124BI','TOKO','BIPPSN','PSPLT-YJXH-36-0','CINCIN PALADIUM ','','5.240','1','6.00','727000','0','0','16600','2010000','0','0','0','2010000','HELMI','00039125','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJXH-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.240',berat_jual_asli=berat_jual_asli+'5.240',stock_jual='1',berat_akhir=berat_akhir-'5.240',berat_akhir_asli=berat_akhir_asli-'5.240',stock_akhir='0' WHERE tanggal='2025-10-13' AND kode_barang='PSPLT-YJXH-36-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-251012-0028','2025-10-13','5.240','2025-10-12','21:28:35','PLG0006952','2010000','2010000','0','2010000','0','kasir','2025-10-12 21:28:35','FJ-251012-0028','DP-01124','800000');
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-10-13','FJ-251012-0028','2025-10-12','21:28:35','HELMI','2010000','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-251013-0001','2025-10-13','2025-10-12 21:28:35','PENJUALAN : FJ-251012-0028','.','TBC','1210000','1210000','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-251013-0002','D','2025-10-13','21:28:35','TBC','PENJUALAN','FJ-251012-0028','17312537514','1210000','17313747514','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='1210000' WHERE no_faktur_jual='FJ-251012-0028' 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-251012-0029','kasir',' 1',' DP-01123BI','TOKO','BIPPSN','PSPLT-YJXH-37-0','CINCIN PALADIUM ','','1.930','1','6.00','268000','0','0','16600','1382500','0','0','0','1382500','HELMI','00039126','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJXH-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2025-10-13' AND kode_barang='PSPLT-YJXH-37-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-251012-0029','2025-10-13','1.930','2025-10-12','21:28:35','PLG0006953','1382500','1382500','0','1382500','0','kasir','2025-10-12 21:28:35','FJ-251012-0028','DP-01123','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-10-13','FJ-251012-0029','2025-10-12','21:28:35','HELMI','1382500','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-251013-0002','2025-10-13','2025-10-12 21:28:35','PENJUALAN : FJ-251012-0029','.','TBC','682500','682500','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-251013-0003','D','2025-10-13','21:28:35','TBC','PENJUALAN','FJ-251012-0029','17313747514','682500','17314430014','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='1892500' WHERE no_faktur_jual='FJ-251012-0029' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251012-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251012-0029';