INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-14 ','11:21:45');
UPDATE tt_service_head SET tgl_selesai='2026-02-14',  status ='DONE' WHERE no_service='SV-01793';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01793';
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-14',  status ='CLOS' WHERE no_service='SV-01793';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01793';
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-260214-0001','kasir','1',' DP-01634MM','TOKO','MMPSN','PSPLT-ZACX-54-0','CINCIN PALADIUM ','','4.270','1','57.00','3214000','0','0','17000','4543000','0','0','0','4543000','NIS','00041268','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZACX-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.270',berat_jual_asli=berat_jual_asli+'4.270',stock_jual='1',berat_akhir=berat_akhir-'4.270',berat_akhir_asli=berat_akhir_asli-'4.270',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='PSPLT-ZACX-54-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-260214-0001','2026-02-14','4.270','2026-02-14','12:30:06','PLG0009420','4543000','4543000','0','4543000','0','kasir','2026-02-14 12:30:05','FJ-260214-0001','DP-01634','3440000');
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-14','FJ-260214-0001','2026-02-14','12:30:06','NIS','4543000','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-260214-0005','2026-02-14','2026-02-14 12:30:05','PENJUALAN : FJ-260214-0001','','TBC','1103000','1103000','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-260214-0006','D','2026-02-14','12:30:06','TBC','PENJUALAN','FJ-260214-0001','20397474114','1103000','20398577114','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='1103000' WHERE no_faktur_jual='FJ-260214-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260214-0002','kasir',' 1',' DP-01633MM','TOKO','MMPSN','PSGT-ZBXF-59-0','CINCIN EMAS ','','2.970','1','58.00','4719000','0','0','17000','8358000','0','0','0','8358000','NIS','00041411','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBXF-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='PSGT-ZBXF-59-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-260214-0002','2026-02-14','2.970','2026-02-14','12:30:06','PLG0009421','8358000','8358000','0','8358000','0','kasir','2026-02-14 12:30:05','FJ-260214-0001','DP-01633','5688000');
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-14','FJ-260214-0002','2026-02-14','12:30:06','NIS','8358000','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-260214-0006','2026-02-14','2026-02-14 12:30:05','PENJUALAN : FJ-260214-0002','','TBC','2670000','2670000','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-260214-0007','D','2026-02-14','12:30:06','TBC','PENJUALAN','FJ-260214-0002','20398577114','2670000','20401247114','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='3773000' WHERE no_faktur_jual='FJ-260214-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-260214-0003','kasir','1',' 900K-12-75','TOKO','MMPER','PMM-ZAXI-45-0','CINCIN SILVER 925 ','','1.850','1','100.00','114000','0','0','17000','1000000','0','0','0','1000000','NIS','00040822','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXI-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='PMM-ZAXI-45-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-260214-0003','2026-02-14','1.850','2026-02-14','15:48:34','PLG0009422','1000000','1000000','0','1000000','0','kasir','2026-02-14 15:48:33','FJ-260214-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('2026-02-14','FJ-260214-0003','2026-02-14','15:48:34','NIS','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-260214-0007','2026-02-14','2026-02-14 15:48:33','PENJUALAN : FJ-260214-0003','.','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-260214-0008','D','2026-02-14','15:48:34','TBC','PENJUALAN','FJ-260214-0003','20401247114','1000000','20402247114','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-260214-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-260214-0004','kasir',' 1',' 500K-18-76','TOKO','MMPER','PMM-ZABX-10-0','CINCIN SILVER 925 ','','1.930','1','100.00','119000','0','0','17000','600000','0','0','0','600000','NIS','00041036','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZABX-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='PMM-ZABX-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-260214-0004','2026-02-14','1.930','2026-02-14','15:48:34','PLG0009423','600000','600000','0','600000','0','kasir','2026-02-14 15:48:33','FJ-260214-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('2026-02-14','FJ-260214-0004','2026-02-14','15:48:34','NIS','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-260214-0008','2026-02-14','2026-02-14 15:48:33','PENJUALAN : FJ-260214-0004','.','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-260214-0009','D','2026-02-14','15:48:34','TBC','PENJUALAN','FJ-260214-0004','20402247114','600000','20402847114','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-260214-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260214-0005','kasir','1',' 700K-17-00','TOKO','MMPER','PBSD-YGBI-86-0','CINCIN SILVER 925 ','','1.950','1','100.00','40000','0','0','17000','800000','0','0','0','800000','NIS','00037722','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='PBSD-YGBI-86-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-260214-0005','2026-02-14','1.950','2026-02-14','16:03:59','PLG0009424','800000','800000','0','800000','0','kasir','2026-02-14 16:03:59','FJ-260214-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-14','FJ-260214-0005','2026-02-14','16:03:59','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-260214-0009','2026-02-14','2026-02-14 16:03:59','PENJUALAN : FJ-260214-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-260214-0010','D','2026-02-14','16:03:59','TBC','PENJUALAN','FJ-260214-0005','20402847114','800000','20403647114','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-260214-0005' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-14 ','16:07:15');
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-01718','DE','1','PLD','CINCIN NIKAH','','','2.700','','25.00','1','1200000','500000','0','700000','2050000','PRIA SIZE 18 GRF UNI & AZIZ','PAKAI PERMATA 1 BTR','DICROM PUTIH SESUAI CTH PAKAI DOV','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-260214-0010','2026-02-14','2026-02-14 16:26:40','PESANAN : DP-01718','-','TBC','1640000','1640000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0011','D','2026-02-14','16:26:40','TBC','PESANAN','DP-01718','20403647114','1640000','20405287114','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-01718','2026-02-14','2026-02-14','16:26:40','PLG0009425','DE','2026-03-03','kasir','2026-02-14 16:26:40','2.700','0','0','0','1640000','0','700000','2050000','2050000','410000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-14 ','16:26:44');
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-260214-0006','kasir','1',' TFC-21295 ','TOKO','TFCBR','TFC-ZBXI-19-0','TFC-21295 GIA 6475609128 ','','2.330','1','75.00','14186000','8160000','480','17000','17500000','0','0','0','17500000','RISIANA','00041430','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-ZBXI-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='TFC-ZBXI-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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-260214-0006','2026-02-14','2.330','2026-02-14','16:27:32','PLG0009426','17500000','17500000','0','17500000','0','kasir','2026-02-14 16:27:31','FJ-260214-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-14','FJ-260214-0006','2026-02-14','16:27:32','RISIANA','17500000','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-260214-0011','2026-02-14','2026-02-14 16:27:31','PENJUALAN : FJ-260214-0006','.','TBC','17500000','17500000','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-260214-0012','D','2026-02-14','16:27:32','TBC','PENJUALAN BERLIAN','FJ-260214-0006','20405287114','17500000','20422787114','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='17500000' WHERE no_faktur_jual='FJ-260214-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0006';
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-01719','DE','1','PER','CINCIN NIKAH','','','1.000','','925.00','1','100000','850000','0','0','850000','WANIAN SIZE 17 GRF AGUNG','DICRM PUTIH GLOSSY','','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-260214-0012','2026-02-14','2026-02-14 16:47:59','PESANAN : DP-01719','-','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0013','D','2026-02-14','16:47:59','TBC','PESANAN','DP-01719','20422787114','850000','20423637114','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-01719','2026-02-14','2026-02-14','16:47:59','PLG0009427','DE','2026-03-03','kasir','2026-02-14 16:47:59','1.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01720','DE','1','PER','CINCIN NIKAH','','','1.000','','925.00','1','100000','800000','0','0','800000','PRIA SIZE 21 GRF JANNAH','DICROM PUTIH GLOSSY','','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-260214-0013','2026-02-14','2026-02-14 16:54:54','PESANAN : DP-01720','-','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260214-0014','D','2026-02-14','16:54:54','TBC','PESANAN','DP-01720','20423637114','800000','20424437114','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-01720','2026-02-14','2026-02-14','16:54:54','PLG0009428','DE','2026-03-03','kasir','2026-02-14 16:54:54','1.000','0','0','0','800000','0','0','800000','800000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-14 ','16:57:55');
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-260214-0007','kasir','1',' TFC-21259 ','TOKO','TFCBR','TFC-YEBI-16-0','CINCIN TFC-21259','','0.580','1','83.00','1978000','414500','24','17000','2250000','0','0','0','2250000','FIR','00036006','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-YEBI-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-02-14' AND kode_barang='TFC-YEBI-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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-260214-0007','2026-02-14','0.580','2026-02-14','16:59:35','PLG0009429','2250000','2250000','0','2250000','0','kasir','2026-02-14 16:59:34','FJ-260214-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-14','FJ-260214-0007','2026-02-14','16:59:35','FIR','2250000','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-260214-0014','2026-02-14','2026-02-14 16:59:34','PENJUALAN : FJ-260214-0007','.','TBC','2250000','2250000','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-260214-0015','D','2026-02-14','16:59:35','TBC','PENJUALAN BERLIAN','FJ-260214-0007','20424437114','2250000','20426687114','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='2250000' WHERE no_faktur_jual='FJ-260214-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260214-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260214-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-14 ','17:15:24');
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-01721','NIS','1','GOLD','CINCIN NIKAH','','','2.000','','75.00','1','2710000','2500000','0','750000','5750000','WANITA SIZE 13 GRF Z','DICROM PUTIH','ZIRKON 18 BTR','0','0','180000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260214-0015','2026-02-14','2026-02-14 17:19:25','PESANAN : DP-01721','-','TBC','4744000','4744000');
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-260214-0016','D','2026-02-14','17:19:25','TBC','PESANAN','DP-01721','20426687114','4744000','20431431114','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-01721','2026-02-14','2026-02-14','17:19:25','PLG0009430','NIS','2026-03-03','kasir','2026-02-14 17:19:25','2.000','0','0','0','4744000','0','750000','5930000','5930000','1186000');
UPDATE tt_service_head SET tgl_selesai='2026-02-14',  status ='DONE' WHERE no_service='SV-01795';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01795';
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-14',  status ='CLOS' WHERE no_service='SV-01795';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01795';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-14 ','19:27:02');
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-00000340','X-00000340','CINCIN TFC-21155','GR','---','TFC','BELI','BELI001','7320000','2026-02-14','2.910','1','kasir','2026-02-14 19:32:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFC';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFC','X-00000340','X-00000340');
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-260214-0001','FJ-241215-0003','FIR','1','BELI','BELI001','TFC', 'X-00000340', 'CINCIN TFC-21155','2.910','2.910','83.00','9900000','7320000','2515464','1','7320000','7320000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.910',berat_beli_asli=berat_beli_asli+'2.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.910',berat_akhir_asli=berat_akhir_asli+'2.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-14' 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-260214-0001','2026-02-14','2026-02-14','19:32:20','FIR','---','2.910','7320000','7320000','7320000','7320000','7320000','kasir','2026-02-14 19:32:21','FB-260214-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260214-0001','RENI','-','','','0','kasir','2026-02-14 19:32:21');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260214-0016','2026-02-14','2026-02-14 19:32:21','PEMBELIAN UMUM : FB-260214-0001','.','TBC','7320000','7320000');
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-260214-0017','K','2026-02-14','19:32:20','TBC','PEMBELIAN UMUM','FB-260214-0001','20431431114','7320000','20424111114','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260214-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260214-0001';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-14';
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-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-14';
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-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-14' 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-260215-0001','D','2026-02-15','20:03:02','TBC','SALDO AWAL','SALDO AWAL','0','20424111114','20424111114');
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-260215-0001','D','2026-02-15','20:03:02','BCD','SALDO AWAL','SALDO AWAL','0','1348483500','1348483500');
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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','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-260215-0001','D','2026-02-15','20:03:02','BCK','SALDO AWAL','SALDO AWAL','0','1962708000','1962708000');
UPDATE tp_system SET tgl_system='2026-02-15';