INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','10:35:23');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01303','GES','1','2PCS SLV','KRUM FULL PUTIH GRF JANGAN HILANG','4.920','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-01303','2025-09-28','2025-09-28','10:36:20','PLG0006652','kasir','2025-09-29','kasir','2025-09-28 10:36:20','4.920','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','11:01:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','12:39:06');
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-250928-0001','kasir','1',' DP-01103BI','TOKO','BIPPSN','PSPRT-YIBE-25-0','1PS CINCIN PERAK ','','3.450','1','100.00','89000','0','0','16700','1450000','0','0','0','1450000','HELMI','00038912','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIBE-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.450',berat_jual_asli=berat_jual_asli+'3.450',stock_jual='1',berat_akhir=berat_akhir-'3.450',berat_akhir_asli=berat_akhir_asli-'3.450',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIBE-25-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-250928-0001','2025-09-28','3.450','2025-09-28','12:39:41','PLG0006653','1450000','1450000','0','1450000','0','kasir','2025-09-28 12:39:41','FJ-250928-0001','DP-01103','1450000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0001','2025-09-28','12:39:41','HELMI','1450000','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-250928-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250927-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250927-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250928-0002','kasir','1',' LMB1-115% ','TOKO','BIPLM','LMB1-YFBD-43-0','LOGAM MULIA BANDUNG 1 GR ','','1.000','1','115.00','2300000','0','0','16700','2400000','0','0','0','2400000','HELMI','00036706','LMB1','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMB1-YFBD-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='LMB1-YFBD-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPLM' 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-250928-0002','2025-09-28','1.000','2025-09-28','12:51:36','PLG0006654','2400000','2400000','0','2400000','0','kasir','2025-09-28 12:51:36','FJ-250928-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0002','2025-09-28','12:51:36','HELMI','2400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0025','2025-09-28','2025-09-28 12:51:36','PENJUALAN : FJ-250928-0002','.','TBC','2400000','2400000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0026','D','2025-09-28','12:51:36','TBC','PENJUALAN','FJ-250928-0002','16731662614','2400000','16734062614','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='2400000' WHERE no_faktur_jual='FJ-250928-0002' 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-250928-0003','kasir','1',' LMB1-115% ','TOKO','BIPLM','LMB1-YFBD-38-0','LOGAM MULIA BANDUNG 1 GR ','','1.000','1','115.00','2300000','0','0','16700','2400000','0','0','0','2400000','HELMI','00036701','LMB1','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMB1-YFBD-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='LMB1-YFBD-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPLM' 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-250928-0003','2025-09-28','1.000','2025-09-28','12:53:07','PLG0006655','2400000','2400000','0','2400000','0','kasir','2025-09-28 12:53:06','FJ-250928-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0003','2025-09-28','12:53:07','HELMI','2400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0026','2025-09-28','2025-09-28 12:53:06','PENJUALAN : FJ-250928-0003','.','TBC','2400000','2400000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0027','D','2025-09-28','12:53:07','TBC','PENJUALAN','FJ-250928-0003','16734062614','2400000','16736462614','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='2400000' WHERE no_faktur_jual='FJ-250928-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-250928-0004','kasir',' 1',' LMB1-115% ','TOKO','BIPLM','LMB1-YFBD-37-0','LOGAM MULIA BANDUNG 1 GR ','','1.000','1','115.00','2300000','0','0','16700','2400000','0','0','0','2400000','HELMI','00036700','LMB1','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMB1-YFBD-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='LMB1-YFBD-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPLM' 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-250928-0004','2025-09-28','1.000','2025-09-28','12:53:07','PLG0006656','2400000','2400000','0','2400000','0','kasir','2025-09-28 12:53:06','FJ-250928-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0004','2025-09-28','12:53:07','HELMI','2400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0027','2025-09-28','2025-09-28 12:53:06','PENJUALAN : FJ-250928-0004','.','TBC','2400000','2400000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0028','D','2025-09-28','12:53:07','TBC','PENJUALAN','FJ-250928-0004','16736462614','2400000','16738862614','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='4800000' WHERE no_faktur_jual='FJ-250928-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0004';
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-250928-0005','kasir','1',' 500K-21-00','TOKO','MMPER','PMM-YIAF-10-0','CINCIN SILVER 925 ','','2.140','1','100.00','55000','0','0','16700','500000','0','0','0','500000','NAD','00038755','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIAF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YIAF-10-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-250928-0005','2025-09-28','2.140','2025-09-28','13:19:41','PLG0006657','500000','500000','0','500000','0','kasir','2025-09-28 13:19:41','FJ-250928-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0005','2025-09-28','13:19:41','NAD','500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0028','2025-09-28','2025-09-28 13:19:41','PENJUALAN : FJ-250928-0005','.','TBC','500000','500000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0029','D','2025-09-28','13:19:41','TBC','PENJUALAN','FJ-250928-0005','16738862614','500000','16739362614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='500000' WHERE no_faktur_jual='FJ-250928-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-250928-0006','kasir',' 1',' 700K-12-00','TOKO','MMPER','PMM-YHAA-16-0','CINCIN SILVER 925 ','','1.170','1','100.00','31000','0','0','16700','299000','0','0','0','299000','NAD','00037927','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YHAA-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YHAA-16-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-250928-0006','2025-09-28','1.170','2025-09-28','13:19:41','PLG0006658','299000','299000','0','299000','0','kasir','2025-09-28 13:19:41','FJ-250928-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0006','2025-09-28','13:19:41','NAD','299000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0029','2025-09-28','2025-09-28 13:19:41','PENJUALAN : FJ-250928-0006','.','TBC','299000','299000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0030','D','2025-09-28','13:19:41','TBC','PENJUALAN','FJ-250928-0006','16739362614','299000','16739661614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='799000' WHERE no_faktur_jual='FJ-250928-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250928-0007','kasir','1',' 500K-20-16','TOKO','BIPPER','PBDG-YIBF-9-0','CINCIN SILVER 925 ','','2.070','1','100.00','54000','0','0','16700','400000','0','0','0','400000','HELMI','00038940','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIBF-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBDG-YIBF-9-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-250928-0007','2025-09-28','2.070','2025-09-28','14:21:21','PLG0006659','400000','400000','0','400000','0','kasir','2025-09-28 14:21:20','FJ-250928-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-09-28','FJ-250928-0007','2025-09-28','14:21:21','HELMI','400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0030','2025-09-28','2025-09-28 14:21:20','PENJUALAN : FJ-250928-0007','.','TBC','400000','400000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0031','D','2025-09-28','14:21:21','TBC','PENJUALAN','FJ-250928-0007','16739661614','400000','16740061614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='400000' WHERE no_faktur_jual='FJ-250928-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-250928-0008','kasir',' 1',' 700K-17-15','TOKO','BIPPER','PBDG-YHXA-9-0','CINCIN SILVER 925 ','','1.260','1','100.00','27000','0','0','16700','399000','0','0','0','399000','HELMI','00037832','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHXA-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBDG-YHXA-9-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-250928-0008','2025-09-28','1.260','2025-09-28','14:21:21','PLG0006660','399000','399000','0','399000','0','kasir','2025-09-28 14:21:20','FJ-250928-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-09-28','FJ-250928-0008','2025-09-28','14:21:21','HELMI','399000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0031','2025-09-28','2025-09-28 14:21:20','PENJUALAN : FJ-250928-0008','.','TBC','399000','399000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0032','D','2025-09-28','14:21:21','TBC','PENJUALAN','FJ-250928-0008','16740061614','399000','16740460614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='799000' WHERE no_faktur_jual='FJ-250928-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0008';
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-250928-0009','kasir','1',' 700K-15-16','TOKO','BIPPER','PBDG-YIXI-15-0','CINCIN SILVER 925 ','','1.230','1','100.00','32000','0','0','16700','399000','0','0','0','399000','HELMI','00038657','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIXI-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBDG-YIXI-15-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-250928-0009','2025-09-28','1.230','2025-09-28','14:56:26','PLG0006661','399000','399000','0','399000','0','kasir','2025-09-28 14:56:26','FJ-250928-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0009','2025-09-28','14:56:26','HELMI','399000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0032','2025-09-28','2025-09-28 14:56:26','PENJUALAN : FJ-250928-0009','.','TBC','399000','399000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0033','D','2025-09-28','14:56:26','TBC','PENJUALAN','FJ-250928-0009','16740460614','399000','16740859614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='399000' WHERE no_faktur_jual='FJ-250928-0009' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250928-0010','kasir',' 1',' 500K-21-16','TOKO','BIPPER','PBDG-YIBF-11-0','CINCIN SILVER 925 ','','2.050','1','100.00','53000','0','0','16700','400000','0','0','0','400000','HELMI','00038942','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YIBF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PBDG-YIBF-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-250928-0010','2025-09-28','2.050','2025-09-28','14:56:26','PLG0006662','400000','400000','0','400000','0','kasir','2025-09-28 14:56:26','FJ-250928-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0010','2025-09-28','14:56:26','HELMI','400000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0033','2025-09-28','2025-09-28 14:56:26','PENJUALAN : FJ-250928-0010','.','TBC','400000','400000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0034','D','2025-09-28','14:56:26','TBC','PENJUALAN','FJ-250928-0010','16740859614','400000','16741259614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='799000' WHERE no_faktur_jual='FJ-250928-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0010';
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-01165','NITA','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2000000','1800000','0','750000','5250000','zircon 19','sz 105 krum pth semprot','grf Irfan 17.01.26 font by wa','190000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0034','2025-09-28','2025-09-28 15:10:52','PESANAN : DP-01165','.','TBC','2720000','2720000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0035','D','2025-09-28','15:10:52','TBC','PESANAN','DP-01165','16741259614','2720000','16743979614','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-01165','2025-09-28','2025-09-28','15:10:52','PLG0006663','NITA','2025-10-25','kasir','2025-09-28 15:10:52','2.500','0','0','0','2720000','0','750000','5440000','5440000','2720000');
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-01166','NITA','1','PER','WEDDING','','','5.000','','925.00','1','25000','0','700000','0','700000','sz 18 krun pth duff amplas','grf Riri 17.01.26 font by wa','model 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-250928-0035','2025-09-28','2025-09-28 15:38:26','PESANAN : DP-01166','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0036','D','2025-09-28','15:38:26','TBC','PESANAN','DP-01166','16743979614','700000','16744679614','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-01166','2025-09-28','2025-09-28','15:38:26','PLG0006664','NITA','2025-10-25','kasir','2025-09-28 15:38:26','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-01304','NIS','1','2PCS CINCIN SLV','CEWE RESIZE KE 10 GRF OPAN DAN COWO RESIZE KE 13 GRF ECHA','4.310','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-01304','2025-09-28','2025-09-28','16:05:53','PLG0006665','kasir','2025-09-29','kasir','2025-09-28 16:05:53','4.310','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-250928-0011','kasir','1',' 700K-17-00','TOKO','MMPER','PMM-YFBX-103-0','CINCIN SILVER 925 ','','2.440','1','100.00','57000','0','0','16700','700000','0','0','0','700000','NIS','00036544','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YFBX-103-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-250928-0011','2025-09-28','2.440','2025-09-28','16:08:14','PLG0006666','700000','700000','0','700000','0','kasir','2025-09-28 16:08:14','FJ-250928-0011','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0011','2025-09-28','16:08:14','NIS','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0036','2025-09-28','2025-09-28 16:08:14','PENJUALAN : FJ-250928-0011','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0037','D','2025-09-28','16:08:14','TBC','PENJUALAN','FJ-250928-0011','16744679614','700000','16745379614','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-250928-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-250928-0012','kasir',' 1',' 700K-15-00','TOKO','MMPER','PMM-YFBX-69-0','CINCIN SILVER 925 ','','1.870','1','100.00','44000','0','0','16700','700000','0','0','0','700000','NIS','00036510','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YFBX-69-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-250928-0012','2025-09-28','1.870','2025-09-28','16:08:14','PLG0006667','700000','700000','0','700000','0','kasir','2025-09-28 16:08:14','FJ-250928-0011','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0012','2025-09-28','16:08:14','NIS','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0037','2025-09-28','2025-09-28 16:08:14','PENJUALAN : FJ-250928-0012','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0038','D','2025-09-28','16:08:14','TBC','PENJUALAN','FJ-250928-0012','16745379614','700000','16746079614','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='1400000' WHERE no_faktur_jual='FJ-250928-0012' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','17:35:11');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000315','X-00000315','CINCIN TFC-21197','GR','---','TFC','BELI','BELI001','10400000','2025-09-28','5.140','1','kasir','2025-09-28 17:37:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFC';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFC','X-00000315','X-00000315');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250928-0001','FJ-231230-0001','BARY','1','BELI','BELI001','TFC', 'X-00000315', 'CINCIN TFC-21197','5.140','5.140','83.00','13000000','10400000','2023346','1','10400000','10400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.140',berat_beli_asli=berat_beli_asli+'5.140',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.140',berat_akhir_asli=berat_akhir_asli+'5.140',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFC' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-250928-0001','2025-09-28','2025-09-28','17:37:39','BARY','---','5.140','10400000','10400000','10400000','10400000','10400000','kasir','2025-09-28 17:37:40','FB-250928-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250928-0001','SUYANTI','-','','','-','kasir','2025-09-28 17:37:40');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0038','2025-09-28','2025-09-28 17:37:40','PEMBELIAN UMUM : FB-250928-0001','.','TBC','10400000','10400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-250928-0039','K','2025-09-28','17:37:39','TBC','PEMBELIAN UMUM','FB-250928-0001','16746079614','10400000','16735679614','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250928-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250928-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250928-0013','kasir','1',' DP-01013BI','TOKO','BIPPSN','PSPLT-YIXD-8-0','CINCIN PALADIUM ','','2.410','1','7.00','344000','0','0','16700','1302500','0','0','0','1302500','HELMI','00038526','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIXD-8-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-09-28' AND kode_barang='PSPLT-YIXD-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250928-0013','2025-09-28','2.410','2025-09-28','18:10:10','PLG0006668','1302500','1302500','0','1302500','0','kasir','2025-09-28 18:10:10','FJ-250928-0013','DP-01013','600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0013','2025-09-28','18:10:10','HELMI','1302500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0039','2025-09-28','2025-09-28 18:10:10','PENJUALAN : FJ-250928-0013','.','TBC','702500','702500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0040','D','2025-09-28','18:10:10','TBC','PENJUALAN','FJ-250928-0013','16735679614','702500','16736382114','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='702500' WHERE no_faktur_jual='FJ-250928-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-250928-0014','kasir',' 1',' DP-01014BI','TOKO','BIPPSN','PSPRT-YIXD-5-0','CINCIN PERAK ','','4.400','1','100.00','113000','0','0','16700','700000','0','0','0','700000','HELMI','00038523','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIXD-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.400',berat_jual_asli=berat_jual_asli+'4.400',stock_jual='1',berat_akhir=berat_akhir-'4.400',berat_akhir_asli=berat_akhir_asli-'4.400',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIXD-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250928-0014','2025-09-28','4.400','2025-09-28','18:10:10','PLG0006669','700000','700000','0','700000','0','kasir','2025-09-28 18:10:10','FJ-250928-0013','DP-01014','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0014','2025-09-28','18:10:10','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='702500' WHERE no_faktur_jual='FJ-250928-0014' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250928-0015','kasir','1',' DP-01099MM','TOKO','MMPSN','PSPLT-YIBB-4-0','CINCIN PALADIUM ','','3.740','1','15.00','1191000','0','0','16700','2383000','0','0','0','2383000','NIS','00038832','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIBB-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.740',berat_jual_asli=berat_jual_asli+'3.740',stock_jual='1',berat_akhir=berat_akhir-'3.740',berat_akhir_asli=berat_akhir_asli-'3.740',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPLT-YIBB-4-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-250928-0015','2025-09-28','3.740','2025-09-28','18:17:26','PLG0006670','2383000','2383000','0','2383000','0','kasir','2025-09-28 18:17:26','FJ-250928-0015','DP-01099','1928000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0015','2025-09-28','18:17:26','NIS','2383000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0040','2025-09-28','2025-09-28 18:17:26','PENJUALAN : FJ-250928-0015','.','TBC','455000','455000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0041','D','2025-09-28','18:17:26','TBC','PENJUALAN','FJ-250928-0015','16736382114','455000','16736837114','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='455000' WHERE no_faktur_jual='FJ-250928-0015' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250928-0016','kasir',' 1',' DP-01098MM','TOKO','MMPSN','PSPLT-YIBF-14-0','CINCIN PALADIUM ','','2.260','1','30.00','1489000','0','0','16700','2841000','0','0','0','2841000','NIS','00038945','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YIBF-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPLT-YIBF-14-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-250928-0016','2025-09-28','2.260','2025-09-28','18:17:26','PLG0006671','2841000','2841000','0','2841000','0','kasir','2025-09-28 18:17:26','FJ-250928-0015','DP-01098','2232000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0016','2025-09-28','18:17:26','NIS','2841000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0041','2025-09-28','2025-09-28 18:17:26','PENJUALAN : FJ-250928-0016','.','TBC','609000','609000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0042','D','2025-09-28','18:17:26','TBC','PENJUALAN','FJ-250928-0016','16736837114','609000','16737446114','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='1064000' WHERE no_faktur_jual='FJ-250928-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0016';
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-250928-0017','kasir','1',' DP-01112BI','TOKO','BIPPSN','PSPRT-YIBE-31-0','CINCIN PERAK ','','3.340','1','100.00','86000','0','0','16700','700000','0','0','0','700000','SUL','00038918','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YIBE-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.340',berat_jual_asli=berat_jual_asli+'3.340',stock_jual='1',berat_akhir=berat_akhir-'3.340',berat_akhir_asli=berat_akhir_asli-'3.340',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PSPRT-YIBE-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-250928-0017','2025-09-28','3.340','2025-09-28','18:51:45','PLG0006672','700000','700000','0','700000','0','kasir','2025-09-28 18:51:44','FJ-250928-0017','DP-01112','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0017','2025-09-28','18:51:45','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-250928-0017' 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-01305','NIS','1','2 PCS CINCIN SLV','CEWE GRF 150698 DAN COWO RESIZE KE 20 KRUM ROSEGOLD GRF 300803','3.900','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0042','2025-09-28','2025-09-28 19:03:35','SERVICE : SV-01305','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0043','D','2025-09-28','19:03:35','TBC','SERVICE','SV-01305','16737446114','50000','16737496114','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01305','2025-09-28','2025-09-28','19:03:35','PLG0006673','kasir','2025-09-29','kasir','2025-09-28 19:03:35','3.900','0','0','0','50000','0','50000','50000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01306','NAD','1','1PC CINCIN EMAS','GRAFIR KIO','1.580','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-01306','2025-09-28','2025-09-28','19:04:26','PLG0006674','kasir','2025-09-29','kasir','2025-09-28 19:04:26','1.580','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-250928-0018','kasir','1',' 800K-14-00','TOKO','MMPER','PMM-YGXD-19-0','CINCIN SILVER 925 ','','1.330','1','100.00','32000','0','0','16700','800000','0','0','0','800000','NIS','00036965','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXD-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YGXD-19-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-250928-0018','2025-09-28','1.330','2025-09-28','19:06:13','PLG0006675','800000','800000','0','800000','0','kasir','2025-09-28 19:06:13','FJ-250928-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0018','2025-09-28','19:06:13','NIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0043','2025-09-28','2025-09-28 19:06:13','PENJUALAN : FJ-250928-0018','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0044','D','2025-09-28','19:06:13','TBC','PENJUALAN','FJ-250928-0018','16737496114','800000','16738296114','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-250928-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-250928-0019','kasir',' 1',' 700K-15-00','TOKO','MMPER','PMM-YGXI-3-0','CINCIN SILVER 925 ','','2.570','1','100.00','60000','0','0','16700','700000','0','0','0','700000','NIS','00037064','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXI-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.570',berat_jual_asli=berat_jual_asli+'2.570',stock_jual='1',berat_akhir=berat_akhir-'2.570',berat_akhir_asli=berat_akhir_asli-'2.570',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YGXI-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250928-0019','2025-09-28','2.570','2025-09-28','19:06:13','PLG0006676','700000','700000','0','700000','0','kasir','2025-09-28 19:06:13','FJ-250928-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0019','2025-09-28','19:06:13','NIS','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0044','2025-09-28','2025-09-28 19:06:13','PENJUALAN : FJ-250928-0019','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0045','D','2025-09-28','19:06:13','TBC','PENJUALAN','FJ-250928-0019','16738296114','700000','16738996114','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1500000' WHERE no_faktur_jual='FJ-250928-0019' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250928-0020','kasir','1',' 700K-12 5 ','TOKO','MMCM','CMMM-YGXA-24-0','CINCIN MAS MM ','','1.580','1','83.00','2886000','0','0','16700','3544000','0','0','0','3544000','NAD','00036856','CMMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMMM-YGXA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='CMMM-YGXA-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMCM' 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-250928-0020','2025-09-28','1.580','2025-09-28','19:08:57','PLG0006677','3544000','3544000','0','3544000','0','kasir','2025-09-28 19:08:56','FJ-250928-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0020','2025-09-28','19:08:57','NAD','3544000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0045','2025-09-28','2025-09-28 19:08:56','PENJUALAN : FJ-250928-0020','.','TBC','3544000','3544000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0046','D','2025-09-28','19:08:57','TBC','PENJUALAN','FJ-250928-0020','16738996114','3544000','16742540114','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='3544000' WHERE no_faktur_jual='FJ-250928-0020' 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-01167','NAD','1','PLD','CINCIN NIKAH','','','2.500','','25.00','1','1736000','450000','0','700000','1825000','SIZE 19 GRF AMI','KRUM PUTIH SESUAI CTH DOVE ALUS','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250928-0046','2025-09-28','2025-09-28 19:14:09','PESANAN : DP-01167','.','TBC','1460000','1460000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0047','D','2025-09-28','19:14:09','TBC','PESANAN','DP-01167','16742540114','1460000','16744000114','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-01167','2025-09-28','2025-09-28','19:14:09','PLG0006678','NAD','2025-10-12','kasir','2025-09-28 19:14:09','2.500','0','0','0','1460000','0','700000','1825000','1825000','365000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01307','NAD','1','2 CINCIN NIKAH','CEWEK RESIZE 11 GRF YUNUS CEWOK RESIZE 21 GRF LIANAH KRUM PUTIH SESUAI CTH','4.760','2','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-01307','2025-09-28','2025-09-28','19:41:09','PLG0006679','kasir','2025-09-29','kasir','2025-09-28 19:41:09','4.760','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','19:41:50');
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-250928-0021','kasir','1',' 750K-9-003','TOKO','MMPER','PMM-YGAF-13-0','CINCIN SILVER 925 ','','1.770','1','100.00','37000','0','0','16700','750000','0','0','0','750000','NIS','00037232','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAF-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YGAF-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250928-0021','2025-09-28','1.770','2025-09-28','19:48:17','PLG0006680','750000','750000','0','750000','0','kasir','2025-09-28 19:48:16','FJ-250928-0021','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-28','FJ-250928-0021','2025-09-28','19:48:17','NIS','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-250928-0047','2025-09-28','2025-09-28 19:48:16','PENJUALAN : FJ-250928-0021','.','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-250928-0048','D','2025-09-28','19:48:17','TBC','PENJUALAN','FJ-250928-0021','16744000114','750000','16744750114','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-250928-0021' 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-250928-0022','kasir','1',' 700K-185-0','TOKO','MMPER','PMM-YIXH-34-0','CINCIN SILVER 925 ','','2.990','1','100.00','77000','0','0','16700','700000','0','0','0','700000','NAD','00038628','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIXH-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2025-09-28' AND kode_barang='PMM-YIXH-34-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-250928-0022','2025-09-28','2.990','2025-09-28','19:48:45','PLG0006681','700000','700000','0','700000','0','kasir','2025-09-28 19:48:45','FJ-250928-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-09-28','FJ-250928-0022','2025-09-28','19:48:45','NAD','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250928-0048','2025-09-28','2025-09-28 19:48:45','PENJUALAN : FJ-250928-0022','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250928-0049','D','2025-09-28','19:48:45','TBC','PENJUALAN','FJ-250928-0022','16744750114','700000','16745450114','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-250928-0022' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','20:20:54');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250928-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250928-0022';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-28';
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-09-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-28' 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-250929-0001','D','2025-09-29','20:21:52','TBC','SALDO AWAL','SALDO AWAL','0','16745450114','16745450114');
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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','BCD','SALDO AWAL','SALDO AWAL','0','1329371000','1329371000');
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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','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-250929-0001','D','2025-09-29','20:21:52','KET','SALDO AWAL','SALDO AWAL','0','148563000','148563000');
UPDATE tp_system SET tgl_system='2025-09-29';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','20:40:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-28 ','21:54:48');
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-01168','HELMI','1','GOLD','WEDDING RING','','','2.000','','75.00','1','2000000','1800000','0','750000','4350000','zirkon 7butir','size 11 grf DW font yeseva one','krum putih glosy','70000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250929-0001','2025-09-29','2025-09-28 21:57:43','PESANAN : DP-01168','.','TBC','3500000','3500000');
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-250929-0002','D','2025-09-29','21:57:43','TBC','PESANAN','DP-01168','16745450114','3500000','16748950114','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-01168','2025-09-29','2025-09-29','21:57:43','PLG0006682','HELMI','2025-10-28','kasir','2025-09-28 21:57:43','2.000','0','0','0','3500000','0','750000','4420000','4420000','920000');
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-01169','HELMI','1','PLD','WEDDING RING','','','3.000','','10.00','1','1736000','250000','0','500000','1250000','tanpa permata size 17.5','grf JHP font yeseva one','krum putih doff semprot bagian garis tengahnya','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-250929-0002','2025-09-29','2025-09-28 22:01:38','PESANAN : DP-01169','.','TBC','625000','625000');
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-250929-0003','D','2025-09-29','22:01:38','TBC','PESANAN','DP-01169','16748950114','625000','16749575114','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-01169','2025-09-29','2025-09-29','22:01:38','PLG0006683','HELMI','2025-10-28','kasir','2025-09-28 22:01:38','3.000','0','0','0','625000','0','500000','1250000','1250000','625000');