INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-15 ','10:22:10');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260215-0001','kasir','1',' DP-01628MM','TOKO','MMPSN','PSPRT-ZACX-9-0','CINCIN PERAK ','','1.200','1','100.00','123000','0','0','17000','599000','0','0','0','599000','NIS','00041223','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZACX-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PSPRT-ZACX-9-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-260215-0001','2026-02-15','1.200','2026-02-15','10:25:06','PLG0009431','599000','599000','0','599000','0','kasir','2026-02-15 10:25:06','FJ-260215-0001','DP-01628','599000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0001','2026-02-15','10:25:06','NIS','599000','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-260215-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-15 ','10:52:58');
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-260215-0002','kasir','1',' DP-01629BI','TOKO','BIPPSN','PSPRT-ZBXE-27-0','CINCIN PERAK ','','4.810','1','100.00','492000','0','0','17000','1650000','0','0','0','1650000','HELMI','00041350','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZBXE-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.810',berat_jual_asli=berat_jual_asli+'4.810',stock_jual='1',berat_akhir=berat_akhir-'4.810',berat_akhir_asli=berat_akhir_asli-'4.810',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PSPRT-ZBXE-27-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-260215-0002','2026-02-15','4.810','2026-02-15','10:54:01','PLG0009432','1650000','1650000','0','1650000','0','kasir','2026-02-15 10:54:00','FJ-260215-0002','DP-01629','1650000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0002','2026-02-15','10:54:01','HELMI','1650000','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-260215-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-15 ','11:03:53');
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-260215-0003','kasir','1',' DP-01623BI','TOKO','BIPPSN','PSGT-ZBXI-24-0','CINCIN EMAS ','','2.340','1','83.00','5409000','0','0','17000','6105000','0','0','0','6105000','SUL','00041435','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBXI-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PSGT-ZBXI-24-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-260215-0003','2026-02-15','2.340','2026-02-15','11:30:11','PLG0009433','6105000','6105000','0','6105000','0','kasir','2026-02-15 11:30:11','FJ-260215-0003','DP-01623','5172000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0003','2026-02-15','11:30:11','SUL','6105000','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-260215-0001','2026-02-15','2026-02-15 11:30:11','PENJUALAN : FJ-260215-0003','','TBC','933000','933000','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-260215-0002','D','2026-02-15','11:30:11','TBC','PENJUALAN','FJ-260215-0003','20424111114','933000','20425044114','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='933000' WHERE no_faktur_jual='FJ-260215-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-260215-0004','kasir',' 1',' DP-01624BI','TOKO','BIPPSN','PSPLT-ZACX-3-0','CINCIN PALADIUM ','','4.870','1','17.00','1094000','0','0','17000','1949000','0','0','0','1949000','SUL','00041217','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZACX-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.870',berat_jual_asli=berat_jual_asli+'4.870',stock_jual='1',berat_akhir=berat_akhir-'4.870',berat_akhir_asli=berat_akhir_asli-'4.870',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PSPLT-ZACX-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260215-0004','2026-02-15','4.870','2026-02-15','11:30:11','PLG0009434','1949000','1949000','0','1949000','0','kasir','2026-02-15 11:30:11','FJ-260215-0003','DP-01624','1000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0004','2026-02-15','11:30:11','SUL','1949000','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-260215-0002','2026-02-15','2026-02-15 11:30:11','PENJUALAN : FJ-260215-0004','','TBC','949000','949000','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-260215-0003','D','2026-02-15','11:30:11','TBC','PENJUALAN','FJ-260215-0004','20425044114','949000','20425993114','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='1882000' WHERE no_faktur_jual='FJ-260215-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-15 ','13:46:02');
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-260215-0005','kasir','1',' 700K-24-22','TOKO','BIPPER','PBDG-ZBAA-18-0','CINCIN SILVER 925 ','','3.730','1','100.00','381000','0','0','17000','800000','0','0','0','800000','AND','00041507','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.730',berat_jual_asli=berat_jual_asli+'3.730',stock_jual='1',berat_akhir=berat_akhir-'3.730',berat_akhir_asli=berat_akhir_asli-'3.730',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-ZBAA-18-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-260215-0005','2026-02-15','3.730','2026-02-15','13:49:21','PLG0009435','800000','800000','0','800000','0','kasir','2026-02-15 13:49:21','FJ-260215-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('2026-02-15','FJ-260215-0005','2026-02-15','13:49:21','AND','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-260215-0003','2026-02-15','2026-02-15 13:49:21','PENJUALAN : FJ-260215-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-260215-0004','D','2026-02-15','13:49:21','TBC','PENJUALAN','FJ-260215-0005','20425993114','800000','20426793114','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-260215-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0005';
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-260215-0006','kasir','1',' 700K-18-22','TOKO','BIPPER','PBDG-ZBAA-15-0','CINCIN SILVER 925 ','','2.390','1','100.00','244000','0','0','17000','800000','0','0','0','800000','ILU','00041504','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-ZBAA-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-260215-0006','2026-02-15','2.390','2026-02-15','13:54:38','PLG0009436','800000','800000','0','800000','0','kasir','2026-02-15 13:54:38','FJ-260215-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0006','2026-02-15','13:54:38','ILU','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-260215-0004','2026-02-15','2026-02-15 13:54:38','PENJUALAN : FJ-260215-0006','','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-260215-0005','D','2026-02-15','13:54:38','TBC','PENJUALAN','FJ-260215-0006','20426793114','800000','20427593114','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-260215-0006' 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-01801','ILU','1','CINCIN KAWIN SILVER','JD NO 19 GRF AUREL EVAN CROM PUTIH DOF SEMPROT','2.390','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-01801','2026-02-15','2026-02-15','13:58:52','PLG0009437','kasir','2026-02-22','kasir','2026-02-15 13:58:52','2.390','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0006';
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-260215-0007','kasir','1',' PLDMM-0001','TOKO','MMPLD','PLDMM-ZAAE-39-0','CINCIN PALADIUM PLDMM-00019 ','','2.040','1','5.00','278000','0','0','17000','1772000','0','0','0','1772000','DE','00040924','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZAAE-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PLDMM-ZAAE-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' 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-260215-0007','2026-02-15','2.040','2026-02-15','14:47:52','PLG0009438','1772000','1772000','0','1772000','0','kasir','2026-02-15 14:47:52','FJ-260215-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('2026-02-15','FJ-260215-0007','2026-02-15','14:47:52','DE','1772000','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-260215-0005','2026-02-15','2026-02-15 14:47:52','PENJUALAN : FJ-260215-0007','','TBC','1772000','1772000','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-260215-0006','D','2026-02-15','14:47:52','TBC','PENJUALAN','FJ-260215-0007','20427593114','1772000','20429365114','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='1772000' WHERE no_faktur_jual='FJ-260215-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-260215-0008','kasir',' 1',' 500K-17-77','TOKO','MMPER','PMM-ZABX-13-0','CINCIN SILVER 925 ','','2.030','1','100.00','125000','0','0','17000','600000','0','0','0','600000','DE','00041039','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZABX-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PMM-ZABX-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-260215-0008','2026-02-15','2.030','2026-02-15','14:47:52','PLG0009439','600000','600000','0','600000','0','kasir','2026-02-15 14:47:52','FJ-260215-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('2026-02-15','FJ-260215-0008','2026-02-15','14:47:52','DE','600000','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-260215-0006','2026-02-15','2026-02-15 14:47:52','PENJUALAN : FJ-260215-0008','','TBC','600000','600000','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-260215-0007','D','2026-02-15','14:47:52','TBC','PENJUALAN','FJ-260215-0008','20429365114','600000','20429965114','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='2372000' WHERE no_faktur_jual='FJ-260215-0008' 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-01802','DE','1','2 PCS CC SLV','WANITA SIZE 14 GRF VAS DAN PRIA GRF FM CROM ULG DUA2 NYA JGN DI UBAH','4.070','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-01802','2026-02-15','2026-02-15','14:53:12','PLG0009440','kasir','2026-02-16','kasir','2026-02-15 14:53:12','4.070','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-260215-0009','kasir','1',' 1.0K-16-22','TOKO','BIPPER','PBDG-ZBXE-15-0','CINCIN SILVER 925 ','','2.250','1','100.00','230000','0','0','17000','1000000','0','0','0','1000000','ILU','00041338','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBXE-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-ZBXE-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-260215-0009','2026-02-15','2.250','2026-02-15','14:54:20','PLG0009441','1000000','1000000','0','1000000','0','kasir','2026-02-15 14:54:19','FJ-260215-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('2026-02-15','FJ-260215-0009','2026-02-15','14:54:20','ILU','1000000','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-260215-0007','2026-02-15','2026-02-15 14:54:19','PENJUALAN : FJ-260215-0009','','TBC','1000000','1000000','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-260215-0008','D','2026-02-15','14:54:20','TBC','PENJUALAN','FJ-260215-0009','20429965114','1000000','20430965114','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='1000000' WHERE no_faktur_jual='FJ-260215-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-260215-0010','kasir',' 1',' 500K-17-21','TOKO','BIPPER','PBDG-ZABA-1-0','CINCIN SILVER 925 ','','2.030','1','100.00','125000','0','0','17000','600000','0','0','0','600000','ILU','00041048','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZABA-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-ZABA-1-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-260215-0010','2026-02-15','2.030','2026-02-15','14:54:20','PLG0009442','600000','600000','0','600000','0','kasir','2026-02-15 14:54:19','FJ-260215-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('2026-02-15','FJ-260215-0010','2026-02-15','14:54:20','ILU','600000','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-260215-0008','2026-02-15','2026-02-15 14:54:19','PENJUALAN : FJ-260215-0010','','TBC','600000','600000','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-260215-0009','D','2026-02-15','14:54:20','TBC','PENJUALAN','FJ-260215-0010','20430965114','600000','20431565114','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-260215-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0010';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01803','NIS','1','1 PCS CC SLV','BNER IN GRF NYA JADI NANDO JESSICA','1.270','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-01803','2026-02-15','2026-02-15','14:55:03','PLG0009443','kasir','2026-02-16','kasir','2026-02-15 14:55:03','1.270','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01804','ILU','1','CINCIN KAWIN SILVER','CEW GRF DIKI WIDYA CROM PUTIH DAN CWO GRF WIDYA DIKI CROM PUTIH DOF AMPLAS','4.280','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-01804','2026-02-15','2026-02-15','14:57:04','PLG0009444','kasir','2026-02-22','kasir','2026-02-15 14:57:04','4.280','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01805','AND','1','CINCIN KAWIN SILVER','CWE GRF B M 26 04 26 CROM PUTIH DOF SEMPROT DAN CWO GRF M B 26 04 26 CROM PUTIH DOF AMPLAS','6.600','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-01805','2026-02-15','2026-02-15','15:32:54','PLG0009445','kasir','2026-02-22','kasir','2026-02-15 15:32:54','6.600','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-260215-0011','kasir','1',' 700K-15-22','TOKO','BIPPER','PBDG-ZBAA-11-0','CINCIN SILVER 925 ','','1.830','1','100.00','187000','0','0','17000','800000','0','0','0','800000','AND','00041500','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-ZBAA-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-260215-0011','2026-02-15','1.830','2026-02-15','15:34:15','PLG0009446','800000','800000','0','800000','0','kasir','2026-02-15 15:34:15','FJ-260215-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('2026-02-15','FJ-260215-0011','2026-02-15','15:34:15','AND','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-260215-0009','2026-02-15','2026-02-15 15:34:15','PENJUALAN : FJ-260215-0011','','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260215-0010','D','2026-02-15','15:34:15','TBC','PENJUALAN','FJ-260215-0011','20431565114','800000','20432365114','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-260215-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-260215-0012','kasir',' 1',' 700K-19-21','TOKO','BIPPER','PBDG-ZAAI-40-0','CINCIN SILVER 925 ','','4.770','1','100.00','293000','0','0','17000','800000','0','0','0','800000','AND','00041022','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAAI-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.770',berat_jual_asli=berat_jual_asli+'4.770',stock_jual='1',berat_akhir=berat_akhir-'4.770',berat_akhir_asli=berat_akhir_asli-'4.770',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-ZAAI-40-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-260215-0012','2026-02-15','4.770','2026-02-15','15:34:15','PLG0009447','800000','800000','0','800000','0','kasir','2026-02-15 15:34:15','FJ-260215-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('2026-02-15','FJ-260215-0012','2026-02-15','15:34:15','AND','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-260215-0010','2026-02-15','2026-02-15 15:34:15','PENJUALAN : FJ-260215-0012','','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-260215-0011','D','2026-02-15','15:34:15','TBC','PENJUALAN','FJ-260215-0012','20432365114','800000','20433165114','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-260215-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0012';
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-260215-0013','kasir','1',' 700K-13-13','TOKO','BIPPER','PBDG-YFXD-47-0','CINCIN SILVER 925 ','','3.680','1','100.00','86000','0','0','17000','800000','0','0','0','800000','AND','00036137','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFXD-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.680',berat_jual_asli=berat_jual_asli+'3.680',stock_jual='1',berat_akhir=berat_akhir-'3.680',berat_akhir_asli=berat_akhir_asli-'3.680',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-YFXD-47-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-260215-0013','2026-02-15','3.680','2026-02-15','15:51:47','PLG0009448','800000','800000','0','800000','0','kasir','2026-02-15 15:51:47','FJ-260215-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('2026-02-15','FJ-260215-0013','2026-02-15','15:51:47','AND','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-260215-0011','2026-02-15','2026-02-15 15:51:47','PENJUALAN : FJ-260215-0013','','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260215-0012','D','2026-02-15','15:51:47','TBC','PENJUALAN','FJ-260215-0013','20433165114','800000','20433965114','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-260215-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0013';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01806','AND','1','CINCIN KAWIN SILVER','JD NO 14 GRF N G CROM PUTIH GLOSI','3.680','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-01806','2026-02-15','2026-02-15','15:53:18','PLG0009449','kasir','2026-02-22','kasir','2026-02-15 15:53:18','3.680','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-01722','NIS','1','PLD','CINCIN NIKAH','','','3.000','','25.00','1','1200000','500000','0','700000','2200000','size 25 grf N','krum putih dove sesuai cth','polos tanpa mata','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260215-0012','2026-02-15','2026-02-15 16:09:14','PESANAN : DP-01722','.','TBC','1760000','1760000');
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-260215-0013','D','2026-02-15','16:09:14','TBC','PESANAN','DP-01722','20433965114','1760000','20435725114','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-01722','2026-02-15','2026-02-15','16:09:14','PLG0009450','NIS','2026-03-01','kasir','2026-02-15 16:09:14','3.000','0','0','0','1760000','0','700000','2200000','2200000','440000');
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-260215-0014','kasir','1',' 750K-22-22','TOKO','BIPPER','PBDG-ZBXE-5-0','CINCIN SILVER 925 ','','3.790','1','100.00','387000','0','0','17000','850000','0','0','0','850000','AND','00041328','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBXE-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.790',berat_jual_asli=berat_jual_asli+'3.790',stock_jual='1',berat_akhir=berat_akhir-'3.790',berat_akhir_asli=berat_akhir_asli-'3.790',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PBDG-ZBXE-5-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-260215-0014','2026-02-15','3.790','2026-02-15','17:04:18','PLG0009451','850000','850000','0','850000','0','kasir','2026-02-15 17:04:18','FJ-260215-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('2026-02-15','FJ-260215-0014','2026-02-15','17:04:18','AND','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-260215-0013','2026-02-15','2026-02-15 17:04:18','PENJUALAN : FJ-260215-0014','','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-260215-0014','D','2026-02-15','17:04:18','TBC','PENJUALAN','FJ-260215-0014','20435725114','850000','20436575114','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-260215-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0014';
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-01723','KUR','1','GOLD','CINCINKAWIN EMAS','','','2.500','','75.00','1','2710000','2500000','0','800000','7050000','SIZE 12','MATA SIRKON 11BUTIR','GRAFIR G.N KROM FULLPUTIH','0','110000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260215-0014','2026-02-15','2026-02-15 17:27:39','PESANAN : DP-01723','-','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-260215-0015','D','2026-02-15','17:27:39','TBC','PESANAN','DP-01723','20436575114','3500000','20440075114','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-01723','2026-02-15','2026-02-15','17:27:39','PLG0009452','KUR','2026-03-08','kasir','2026-02-15 17:27:39','2.500','0','0','0','3500000','0','800000','7160000','7160000','3660000');
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-01724','NIS','1','GOLD','CINCIN NIKAH','','','3.500','','75.00','1','2710000','2500000','0','700000','9450000','size 17 grf berliando','pakai mata 1butir','krum putih dov sesuai cth','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260215-0015','2026-02-15','2026-02-15 17:32:15','PESANAN : DP-01724','.','TBC','7560000','7560000');
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-260215-0016','D','2026-02-15','17:32:15','TBC','PESANAN','DP-01724','20440075114','7560000','20447635114','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-01724','2026-02-15','2026-02-15','17:32:15','PLG0009453','NIS','2026-03-05','kasir','2026-02-15 17:32:15','3.500','0','0','0','7560000','0','700000','9450000','9450000','1890000');
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-01725','NIS','1','PLD','CINCIN NIKAH','','','3.800','','25.00','1','1200000','500000','0','700000','2600000','size 25 grf anisya','krum putih sesuai cth','polos pakai dove','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260215-0016','2026-02-15','2026-02-15 17:36:25','PESANAN : DP-01725','.','TBC','2080000','2080000');
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-260215-0017','D','2026-02-15','17:36:25','TBC','PESANAN','DP-01725','20447635114','2080000','20449715114','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-01725','2026-02-15','2026-02-15','17:36:25','PLG0009454','NIS','2026-03-05','kasir','2026-02-15 17:36:25','3.800','0','0','0','2080000','0','700000','2600000','2600000','520000');
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-260215-0015','kasir','1',' DP-01649T ','TOKO','TFPSN','PSGT-ZBAC-21-0','CINCIN EMAS ','','4.590','1','83.00','10570000','0','0','17000','12935000','0','0','0','12935000','FIR','00041550','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBAC-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.590',berat_jual_asli=berat_jual_asli+'4.590',stock_jual='1',berat_akhir=berat_akhir-'4.590',berat_akhir_asli=berat_akhir_asli-'4.590',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PSGT-ZBAC-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFPSN' 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-260215-0015','2026-02-15','4.590','2026-02-15','18:37:28','PLG0009455','12935000','12935000','0','12935000','0','kasir','2026-02-15 18:37:27','FJ-260215-0015','DP-01649','9675000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0015','2026-02-15','18:37:28','FIR','12935000','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-260215-0017','2026-02-15','2026-02-15 18:37:27','PENJUALAN : FJ-260215-0015','.','TBC','3260000','3260000','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-260215-0018','D','2026-02-15','18:37:28','TBC','PENJUALAN','FJ-260215-0015','20449715114','3260000','20452975114','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3260000' WHERE no_faktur_jual='FJ-260215-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0015';
UPDATE tt_service_head SET tgl_selesai='2026-02-15',  status ='DONE' WHERE no_service='SV-01730';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01730';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-02-15',  status ='CLOS' WHERE no_service='SV-01730';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01730';
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-260215-0016','kasir','1',' DP-01610BI','TOKO','BIPPSN','PSPLT-ZBXE-16-0','CINCIN PALADIUM ','','2.290','1','17.00','515000','0','0','17000','1387000','0','0','0','1387000','SUL','00041339','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBXE-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PSPLT-ZBXE-16-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-260215-0016','2026-02-15','2.290','2026-02-15','19:02:29','PLG0009456','1387000','1387000','0','1387000','0','kasir','2026-02-15 19:02:28','FJ-260215-0016','DP-01610','750000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0016','2026-02-15','19:02:29','SUL','1387000','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-260215-0018','2026-02-15','2026-02-15 19:02:28','PENJUALAN : FJ-260215-0016','','TBC','637000','637000','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-260215-0019','D','2026-02-15','19:02:29','TBC','PENJUALAN','FJ-260215-0016','20452975114','637000','20453612114','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='637000' WHERE no_faktur_jual='FJ-260215-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-260215-0017','kasir',' 1',' DP-01609BI','TOKO','BIPPSN','PSPLT-ZBXC-3-0','CINCIN PALADIUM ','','1.740','1','17.00','391000','0','0','17000','1482000','0','0','0','1482000','SUL','00041297','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBXC-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-02-15' AND kode_barang='PSPLT-ZBXC-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260215-0017','2026-02-15','1.740','2026-02-15','19:02:29','PLG0009457','1482000','1482000','0','1482000','0','kasir','2026-02-15 19:02:28','FJ-260215-0016','DP-01609','750000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-15','FJ-260215-0017','2026-02-15','19:02:29','SUL','1482000','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-260215-0019','2026-02-15','2026-02-15 19:02:28','PENJUALAN : FJ-260215-0017','','TBC','732000','732000','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-260215-0020','D','2026-02-15','19:02:29','TBC','PENJUALAN','FJ-260215-0017','20453612114','732000','20454344114','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='1369000' WHERE no_faktur_jual='FJ-260215-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260215-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260215-0017';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-15';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-02-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-15' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260216-0001','D','2026-02-16','20:03:16','TBC','SALDO AWAL','SALDO AWAL','0','20454344114','20454344114');
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-260216-0001','D','2026-02-16','20:03:16','BCK','SALDO AWAL','SALDO AWAL','0','1962708000','1962708000');
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-260216-0001','D','2026-02-16','20:03:16','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
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-260216-0001','D','2026-02-16','20:03:16','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-260216-0001','D','2026-02-16','20:03:16','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-260216-0001','D','2026-02-16','20:03:16','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-260216-0001','D','2026-02-16','20:03:16','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-260216-0001','D','2026-02-16','20:03:16','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-260216-0001','D','2026-02-16','20:03:16','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260216-0001','D','2026-02-16','20:03:16','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
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-260216-0001','D','2026-02-16','20:03:16','BCD','SALDO AWAL','SALDO AWAL','0','1348483500','1348483500');
UPDATE tp_system SET tgl_system='2026-02-16';