INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-01 ','10:50:39');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260201-0001','kasir','1',' 500K-17-78','TOKO','MMPER','PMM-ZABF-18-0','CINCIN SILVER 925 ','','2.070','1','100.00','127000','0','0','17100','500000','0','0','0','500000','NIS','00041156','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZABF-18-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='2026-02-01' AND kode_barang='PMM-ZABF-18-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-260201-0001','2026-02-01','2.070','2026-02-01','10:51:43','PLG0009173','500000','500000','0','500000','0','kasir','2026-02-01 10:51:43','FJ-260201-0001','','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-01','FJ-260201-0001','2026-02-01','10:51:43','NIS','500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260201-0005','2026-02-01','2026-02-01 10:51:43','PENJUALAN : FJ-260201-0001','.','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-260201-0006','D','2026-02-01','10:51:43','TBC','PENJUALAN','FJ-260201-0001','20018169814','500000','20018669814','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-260201-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-260201-0002','kasir',' 1',' 700K-12-59','TOKO','MMPER','PMM-YKBD-46-0','CINCIN SILVER 925 ','','1.060','1','100.00','66000','0','0','17100','299000','0','0','0','299000','NIS','00039818','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKBD-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PMM-YKBD-46-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-260201-0002','2026-02-01','1.060','2026-02-01','10:51:43','PLG0009174','299000','299000','0','299000','0','kasir','2026-02-01 10:51:43','FJ-260201-0001','','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-01','FJ-260201-0002','2026-02-01','10:51:43','NIS','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-260201-0006','2026-02-01','2026-02-01 10:51:43','PENJUALAN : FJ-260201-0002','.','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-260201-0007','D','2026-02-01','10:51:43','TBC','PENJUALAN','FJ-260201-0002','20018669814','299000','20018968814','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-260201-0002' 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-01753','NIS','1','2PC CCN SLV','CEWE GRF DHUHAL MEGA DAN COWO BENERIN YA SOALNYA PENYOK GRF MEGA DHUHAL KRUM ULANG DUADUANYA','3.040','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01753','2026-02-01','2026-02-01','11:01:11','PLG0009175','kasir','2026-02-02','kasir','2026-02-01 11:01:11','3.040','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-01 ','12:39:08');
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-01673','SULIS','1','GOLD','WED RING','','','2.000','','75.00','1','2690000','2500000','0','750000','5750000','18 zircon putih glosy','sz 9 font vintage rotter','grf Gilang . . . Nia','180000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260201-0007','2026-02-01','2026-02-01 12:40:52','PESANAN : DP-01673','.','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-260201-0008','D','2026-02-01','12:40:52','TBC','PESANAN','DP-01673','20018968814','4744000','20023712814','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-01673','2026-02-01','2026-02-01','12:40:52','PLG0009176','SULIS','2026-02-17','kasir','2026-02-01 12:40:52','2.000','0','0','0','4744000','0','750000','5930000','5930000','1186000');
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-01674','SULIS','1','PER','WED RING','','','3.000','','925.00','1','60000','100000','0','700000','1000000','sz 17 putih doff amplass','fon vintage rotter grf Nia . . . Gilang','model spt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260201-0008','2026-02-01','2026-02-01 12:42:27','PESANAN : DP-01674','.','TBC','500000','500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260201-0009','D','2026-02-01','12:42:27','TBC','PESANAN','DP-01674','20023712814','500000','20024212814','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-01674','2026-02-01','2026-02-01','12:42:27','PLG0009177','SULIS','2026-02-17','kasir','2026-02-01 12:42:27','3.000','0','0','0','500000','0','700000','1000000','1000000','500000');
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-01675','SULIS','1','PER','WED RING','','','2.000','','925.00','1','60000','100000','0','400000','600000','sz 21 putih glosy grf Ismi','font arial','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260201-0009','2026-02-01','2026-02-01 12:44:25','PESANAN : DP-01675','.','TBC','400000','400000');
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-260201-0010','D','2026-02-01','12:44:25','TBC','PESANAN','DP-01675','20024212814','400000','20024612814','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-01675','2026-02-01','2026-02-01','12:44:25','PLG0009178','SULIS','2026-02-21','kasir','2026-02-01 12:44:25','2.000','0','0','0','400000','0','400000','600000','600000','200000');
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-260201-0003','kasir','1',' DP-01619BI','TOKO','BIPPSN','PSPRT-ZACX-7-0','CINCIN PERAK ','','4.130','1','100.00','422000','0','0','17100','700000','0','0','0','700000','HELMI','00041221','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZACX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.130',berat_jual_asli=berat_jual_asli+'4.130',stock_jual='1',berat_akhir=berat_akhir-'4.130',berat_akhir_asli=berat_akhir_asli-'4.130',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PSPRT-ZACX-7-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-260201-0003','2026-02-01','4.130','2026-02-01','13:15:16','PLG0009179','700000','700000','0','700000','0','kasir','2026-02-01 13:15:15','FJ-260201-0003','DP-01619','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('2026-02-01','FJ-260201-0003','2026-02-01','13:15:16','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260201-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-01 ','13:37:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-01 ','13:49:07');
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-260201-0004','kasir','1',' DP-01569BI','TOKO','BIPPSN','PSPLT-ZABA-11-0','CINCIN PALADIUM ','','2.700','1','5.00','393000','0','0','17100','1510000','0','0','0','1510000','SUL','00041058','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZABA-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PSPLT-ZABA-11-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-260201-0004','2026-02-01','2.700','2026-02-01','13:49:31','PLG0009180','1510000','1510000','0','1510000','0','kasir','2026-02-01 13:49:31','FJ-260201-0004','DP-01569','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-01','FJ-260201-0004','2026-02-01','13:49:31','SUL','1510000','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-260201-0010','2026-02-01','2026-02-01 13:49:31','PENJUALAN : FJ-260201-0004','.','TBC','760000','760000','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-260201-0011','D','2026-02-01','13:49:31','TBC','PENJUALAN','FJ-260201-0004','20024612814','760000','20025372814','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='760000' WHERE no_faktur_jual='FJ-260201-0004' LIMIT 1;
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-02-01 13:51:11' WHERE id_card = '-';
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-260201-0005','kasir','1',' TFC-21482 ','TOKO','TFCBR','TFC-YIAI-5-0','TFC-21482 GIA 6301636169','','1.940','1','83.00','19362000','13270000','776','17100','22500000','0','0','0','22500000','ILU','00038823','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-YIAI-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='TFC-YIAI-5-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-260201-0005','2026-02-01','1.940','2026-02-01','13:51:14','PLG0009181','22500000','22500000','0','22500000','0','kasir','2026-02-01 13:51:13','FJ-260201-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-01','FJ-260201-0005','2026-02-01','13:51:14','ILU','22500000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-260201-0001','2026-02-01','2026-02-01 13:51:13','PENJUALAN : FJ-260201-0005','','BCK','22500000','22500000','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-260201-0002','D','2026-02-01','13:51:14','BCK','PENJUALAN BERLIAN','FJ-260201-0005','1940208000','22500000','1962708000','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='22500000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260201-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0005';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01676','SULIS','1','GOLD','WED RING','','','2.500','','50.00','1','2690000','2200000','0','750000','6250000','15 zircon putih glosy','sz 15 font arial','grf Ikhsan','150000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260201-0011','2026-02-01','2026-02-01 13:55:09','PESANAN : DP-01676','.','TBC','5120000','5120000');
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-260201-0012','D','2026-02-01','13:55:09','TBC','PESANAN','DP-01676','20025372814','5120000','20030492814','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-01676','2026-02-01','2026-02-01','13:55:09','PLG0009182','SULIS','2026-02-21','kasir','2026-02-01 13:55:09','2.500','0','0','0','5120000','0','750000','6400000','6400000','1280000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01754','NIS','1','1PC CCN SLV','RESIZE KE 27 HRGA KONFIRMASI','2.670','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-01754','2026-02-01','2026-02-01','14:14:33','PLG0009183','kasir','2026-02-02','kasir','2026-02-01 14:14:33','2.670','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-01 ','14:17:13');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260201-0006','kasir','1',' TFC-21494 ','TOKO','TFCBR','TFC-ZABA-51-0','CINCIN TFC-21494 ','','1.880','1','83.00','7890000','2974000','174','17100','10000000','0','0','0','10000000','FAISAL','00041098','TFC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFC-ZABA-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='TFC-ZABA-51-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-260201-0006','2026-02-01','1.880','2026-02-01','14:33:55','PLG0009184','10000000','10000000','0','10000000','0','kasir','2026-02-01 14:33:55','FJ-260201-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-01','FJ-260201-0006','2026-02-01','14:33:55','FAISAL','10000000','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-260201-0012','2026-02-01','2026-02-01 14:33:55','PENJUALAN : FJ-260201-0006','','TBC','10000000','10000000','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-260201-0013','D','2026-02-01','14:33:55','TBC','PENJUALAN BERLIAN','FJ-260201-0006','20030492814','10000000','20040492814','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='10000000' WHERE no_faktur_jual='FJ-260201-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0006';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01755','NIS','1','2PC CCN SLV','CEWE RESIZE KE 17 GRF GAGAH DAN COWO RESIZE KE 17 5 GRF CHINTYA','3.140','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-01755','2026-02-01','2026-02-01','14:50:55','PLG0009185','kasir','2026-02-02','kasir','2026-02-01 14:50:55','3.140','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-260201-0007','kasir','1',' 1.150K-16-','TOKO','MMPER','PMM-ZAXI-50-0','CINCIN SILVER 925 ','','2.670','1','100.00','164000','0','0','17100','1647000','0','0','0','1647000','NIS','00040827','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXI-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PMM-ZAXI-50-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-260201-0007','2026-02-01','2.670','2026-02-01','14:57:18','PLG0009186','1647000','1647000','0','1647000','0','kasir','2026-02-01 14:57:17','FJ-260201-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-01','FJ-260201-0007','2026-02-01','14:57:18','NIS','1647000','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-260201-0013','2026-02-01','2026-02-01 14:57:17','PENJUALAN : FJ-260201-0007','.','TBC','1647000','1647000','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-260201-0014','D','2026-02-01','14:57:18','TBC','PENJUALAN','FJ-260201-0007','20040492814','1647000','20042139814','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='1647000' WHERE no_faktur_jual='FJ-260201-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-260201-0008','kasir','1',' 700K-15-72','TOKO','MMPER','PMM-ZAXG-6-0','CINCIN SILVER 925 ','','1.240','1','100.00','76000','0','0','17100','299000','0','0','0','299000','NIS','00040769','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXG-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PMM-ZAXG-6-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-260201-0008','2026-02-01','1.240','2026-02-01','14:58:02','PLG0009187','299000','299000','0','299000','0','kasir','2026-02-01 14:58:02','FJ-260201-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-01','FJ-260201-0008','2026-02-01','14:58:02','NIS','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-260201-0014','2026-02-01','2026-02-01 14:58:02','PENJUALAN : FJ-260201-0008','.','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-260201-0015','D','2026-02-01','14:58:02','TBC','PENJUALAN','FJ-260201-0008','20042139814','299000','20042438814','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='299000' WHERE no_faktur_jual='FJ-260201-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260201-0009','kasir',' 1',' 500K-16-63','TOKO','MMPER','PMM-YLXD-129-0','CINCIN SILVER 925 ','','1.900','1','100.00','117000','0','0','17100','500000','0','0','0','500000','NIS','00040309','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLXD-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PMM-YLXD-129-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-260201-0009','2026-02-01','1.900','2026-02-01','14:58:02','PLG0009188','500000','500000','0','500000','0','kasir','2026-02-01 14:58:02','FJ-260201-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-01','FJ-260201-0009','2026-02-01','14:58:02','NIS','500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260201-0015','2026-02-01','2026-02-01 14:58:02','PENJUALAN : FJ-260201-0009','.','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-260201-0016','D','2026-02-01','14:58:02','TBC','PENJUALAN','FJ-260201-0009','20042438814','500000','20042938814','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-260201-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-260201-0010','kasir','1',' 700K-185-0','TOKO','MMPER','PMM-YFBX-100-0','CINCIN SILVER 925 ','','1.680','1','100.00','40000','0','0','17100','868000','0','0','0','868000','FIR','00036541','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PMM-YFBX-100-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-260201-0010','2026-02-01','1.680','2026-02-01','15:25:48','PLG0009189','868000','868000','0','868000','0','kasir','2026-02-01 15:25:47','FJ-260201-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-01','FJ-260201-0010','2026-02-01','15:25:48','FIR','868000','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-260201-0016','2026-02-01','2026-02-01 15:25:47','PENJUALAN : FJ-260201-0010','.','TBC','868000','868000','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-260201-0017','D','2026-02-01','15:25:48','TBC','PENJUALAN','FJ-260201-0010','20042938814','868000','20043806814','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='868000' WHERE no_faktur_jual='FJ-260201-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260201-0011','kasir','1',' 700K-18-19','TOKO','BIPPER','PBDG-YKBE-131-0','CINCIN SILVER 925 ','','2.080','1','100.00','128000','0','0','17100','858000','0','0','0','858000','HELMI','00039963','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PBDG-YKBE-131-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-260201-0011','2026-02-01','2.080','2026-02-01','16:03:19','PLG0009190','858000','858000','0','858000','0','kasir','2026-02-01 16:03:19','FJ-260201-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-01','FJ-260201-0011','2026-02-01','16:03:19','HELMI','858000','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-260201-0017','2026-02-01','2026-02-01 16:03:19','PENJUALAN : FJ-260201-0011','.','TBC','858000','858000','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-260201-0018','D','2026-02-01','16:03:19','TBC','PENJUALAN','FJ-260201-0011','20043806814','858000','20044664814','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='858000' WHERE no_faktur_jual='FJ-260201-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-260201-0012','kasir',' 1',' PLBDG-0014','TOKO','BIPPLD','PLBDG-ZACX-46-0','CINCIN PALADIUM PLBDG-00149 ','','1.970','1','17.00','443000','0','0','17100','1291000','0','0','0','1291000','HELMI','00041260','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZACX-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PLBDG-ZACX-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260201-0012','2026-02-01','1.970','2026-02-01','16:03:19','PLG0009191','1291000','1291000','0','1291000','0','kasir','2026-02-01 16:03:19','FJ-260201-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-01','FJ-260201-0012','2026-02-01','16:03:19','HELMI','1291000','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-260201-0018','2026-02-01','2026-02-01 16:03:19','PENJUALAN : FJ-260201-0012','.','TBC','1291000','1291000','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-260201-0019','D','2026-02-01','16:03:19','TBC','PENJUALAN','FJ-260201-0012','20044664814','1291000','20045955814','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='2149000' WHERE no_faktur_jual='FJ-260201-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0012';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01756','HELMI','1','CC SLV DAN PLD','CEWE JD SIZE 12 COWO TETAP','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01756','2026-02-01','2026-02-01','16:08:59','PLG0009192','kasir','2026-02-02','kasir','2026-02-01 16:08:59','5.000','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-260201-0013','kasir','1',' 700K-21-21','TOKO','BIPPER','PBDG-ZAAF-2-0','CINCIN SILVER 925 ','','2.230','1','100.00','137000','0','0','17100','923000','0','0','0','923000','SUL','00040939','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAAF-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PBDG-ZAAF-2-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-260201-0013','2026-02-01','2.230','2026-02-01','16:25:47','PLG0009193','923000','923000','0','923000','0','kasir','2026-02-01 16:25:47','FJ-260201-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-01','FJ-260201-0013','2026-02-01','16:25:47','SUL','923000','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-260201-0019','2026-02-01','2026-02-01 16:25:47','PENJUALAN : FJ-260201-0013','.','TBC','923000','923000','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-260201-0020','D','2026-02-01','16:25:47','TBC','PENJUALAN','FJ-260201-0013','20045955814','923000','20046878814','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='923000' WHERE no_faktur_jual='FJ-260201-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0013';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260201-0014','kasir','1',' 700K-19-00','TOKO','MMPER','PMM-YFBX-134-0','CINCIN SILVER 925 ','','2.900','1','100.00','67000','0','0','17100','990000','0','0','0','990000','FIR','00036575','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-134-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PMM-YFBX-134-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-260201-0014','2026-02-01','2.900','2026-02-01','17:26:01','PLG0009194','990000','990000','0','990000','0','kasir','2026-02-01 17:26:00','FJ-260201-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-01','FJ-260201-0014','2026-02-01','17:26:01','FIR','990000','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-260201-0020','2026-02-01','2026-02-01 17:26:00','PENJUALAN : FJ-260201-0014','.','TBC','990000','990000','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-260201-0021','D','2026-02-01','17:26:01','TBC','PENJUALAN','FJ-260201-0014','20046878814','990000','20047868814','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='990000' WHERE no_faktur_jual='FJ-260201-0014' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01757','FIR','1','1PC CCN SLV','GRAFIR MILA NURULOH KRUM ULANG','2.900','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-01757','2026-02-01','2026-02-01','17:33:17','PLG0009195','kasir','2026-02-02','kasir','2026-02-01 17:33:17','2.900','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-01677','FIR','1','PLD','CINCIN NIKAH','','','2.000','','10.00','1','1200000','300000','0','900000','1500000','size 12 krum putih','grf nuruloh mila','15butir dan 1butir','0','0','150000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260201-0021','2026-02-01','2026-02-01 17:40:49','PESANAN : DP-01677','.','TBC','1320000','1320000');
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-260201-0022','D','2026-02-01','17:40:49','TBC','PESANAN','DP-01677','20047868814','1320000','20049188814','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-01677','2026-02-01','2026-02-01','17:40:49','PLG0009196','FIR','2026-02-15','kasir','2026-02-01 17:40:49','2.000','0','0','0','1320000','0','900000','1650000','1650000','330000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0014';
UPDATE tt_service_head SET tgl_selesai='2026-02-01',  status ='DONE' WHERE no_service='SV-01724';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01724';
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-01',  status ='CLOS' WHERE no_service='SV-01724';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01724';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01758','SULIS','1','CC SILVER','SERVICE CCN PUTIH DOFF SEMPROT FONT VINTAGE ROTTER SZ 14','2.000','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260201-0022','2026-02-01','2026-02-01 18:27:51','SERVICE : SV-01758','.','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-260201-0023','D','2026-02-01','18:27:51','TBC','SERVICE','SV-01758','20049188814','50000','20049238814','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-01758','2026-02-01','2026-02-01','18:27:51','PLG0009197','kasir','2026-02-09','kasir','2026-02-01 18:27:51','2.000','0','0','0','50000','0','50000','50000','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-260201-0015','kasir','1',' 850K-9-212','TOKO','BIPPER','PBDG-ZAXF-8-0','CINCIN SILVER 925 ','','1.470','1','100.00','91000','0','0','17100','897000','0','0','0','897000','SUL','00040754','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAXF-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PBDG-ZAXF-8-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-260201-0015','2026-02-01','1.470','2026-02-01','19:30:59','PLG0009198','897000','897000','0','897000','0','kasir','2026-02-01 19:30:58','FJ-260201-0015','','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-01','FJ-260201-0015','2026-02-01','19:30:59','SUL','897000','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-260201-0023','2026-02-01','2026-02-01 19:30:58','PENJUALAN : FJ-260201-0015','.','TBC','897000','897000','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-260201-0024','D','2026-02-01','19:30:59','TBC','PENJUALAN','FJ-260201-0015','20049238814','897000','20050135814','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='897000' WHERE no_faktur_jual='FJ-260201-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-260201-0016','kasir',' 1',' 700K-165-1','TOKO','BIPPER','PBDG-YLXB-15-0','CINCIN SILVER 925 ','','2.720','1','100.00','167000','0','0','17100','972000','0','0','0','972000','SUL','00040087','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLXB-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2026-02-01' AND kode_barang='PBDG-YLXB-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-260201-0016','2026-02-01','2.720','2026-02-01','19:30:59','PLG0009199','972000','972000','0','972000','0','kasir','2026-02-01 19:30:58','FJ-260201-0015','','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-01','FJ-260201-0016','2026-02-01','19:30:59','SUL','972000','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-260201-0024','2026-02-01','2026-02-01 19:30:58','PENJUALAN : FJ-260201-0016','.','TBC','972000','972000','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-260201-0025','D','2026-02-01','19:30:59','TBC','PENJUALAN','FJ-260201-0016','20050135814','972000','20051107814','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='1869000' WHERE no_faktur_jual='FJ-260201-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0016';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-01';
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-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-01';
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-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-01' 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-260202-0001','D','2026-02-02','20:12:05','TBC','SALDO AWAL','SALDO AWAL','0','20051107814','20051107814');
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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','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-260202-0001','D','2026-02-02','20:12:05','BCD','SALDO AWAL','SALDO AWAL','0','1348483500','1348483500');
UPDATE tp_system SET tgl_system='2026-02-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-02-01 ','20:24:05');
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-260201-0017','kasir','1',' PLBDG-0011','TOKO','BIPPLD','PLBDG-YLAE-9-0','CINCIN PALADIUM PLBDG-00115 ','','4.940','1','6.00','751000','0','0','17100','1982000','0','0','0','1982000','HELMI','00040569','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-YLAE-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.940',berat_jual_asli=berat_jual_asli+'4.940',stock_jual='1',berat_akhir=berat_akhir-'4.940',berat_akhir_asli=berat_akhir_asli-'4.940',stock_akhir='0' WHERE tanggal='2026-02-02' AND kode_barang='PLBDG-YLAE-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260201-0017','2026-02-02','4.940','2026-02-01','20:25:52','PLG0009200','1982000','1982000','0','1982000','0','kasir','2026-02-01 20:25:51','FJ-260201-0017','','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-02','FJ-260201-0017','2026-02-01','20:25:52','HELMI','1982000','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-260202-0001','2026-02-02','2026-02-01 20:25:51','PENJUALAN : FJ-260201-0017','.','TBC','1982000','1982000','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-260202-0002','D','2026-02-02','20:25:52','TBC','PENJUALAN','FJ-260201-0017','20051107814','1982000','20053089814','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='1982000' WHERE no_faktur_jual='FJ-260201-0017' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260201-0018','kasir',' 1',' PLBDG-0015','TOKO','BIPPLD','PLBDG-ZACX-48-0','CINCIN PALADIUM PLBDG-00151 ','','1.870','1','17.00','421000','0','0','17100','1311000','0','0','0','1311000','HELMI','00041262','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-02-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZACX-48-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='2026-02-02' AND kode_barang='PLBDG-ZACX-48-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260201-0018','2026-02-02','1.870','2026-02-01','20:25:52','PLG0009201','1311000','1311000','0','1311000','0','kasir','2026-02-01 20:25:51','FJ-260201-0017','','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-02','FJ-260201-0018','2026-02-01','20:25:52','HELMI','1311000','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-260202-0002','2026-02-02','2026-02-01 20:25:51','PENJUALAN : FJ-260201-0018','.','TBC','1311000','1311000','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-260202-0003','D','2026-02-02','20:25:52','TBC','PENJUALAN','FJ-260201-0018','20053089814','1311000','20054400814','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='3293000' WHERE no_faktur_jual='FJ-260201-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260201-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260201-0018';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01759','HELMI','1','SEPASANG PLD','CEWE JD SIZE 13 COWO JD SIZE 21 5 KRUM SPT ASAL','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01759','2026-02-02','2026-02-02','20:48:06','PLG0009202','kasir','2026-02-03','kasir','2026-02-01 20:48:06','5.000','0','0','0','0','0','0','0','0');