INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-01 ','10:06:48');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-31';
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-03-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-04-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-31' 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-260401-0001','D','2026-04-01','10:09:54','TBC','SALDO AWAL','SALDO AWAL','0','21229663514','21229663514');
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-260401-0001','D','2026-04-01','10:09:54','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000');
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-260401-0001','D','2026-04-01','10:09:54','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-260401-0001','D','2026-04-01','10:09:54','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-260401-0001','D','2026-04-01','10:09:54','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-260401-0001','D','2026-04-01','10:09:54','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-260401-0001','D','2026-04-01','10:09:54','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-260401-0001','D','2026-04-01','10:09:54','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-260401-0001','D','2026-04-01','10:09:54','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-260401-0001','D','2026-04-01','10:09:54','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000');
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-260401-0001','D','2026-04-01','10:09:54','','SALDO AWAL','SALDO AWAL','0','250000','250000');
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-260401-0001','D','2026-04-01','10:09:54','BCD','SALDO AWAL','SALDO AWAL','0','1356733500','1356733500');
UPDATE tp_system SET tgl_system='2026-04-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-01 ','10:33:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-01 ','10:45:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-01 ','10:52:47');
UPDATE th_user_login SET tgl_logout = '2026-04-01', jam_logout = '11:32:00' WHERE user_id = 'kasir' AND tgl_login = '2026-04-01' AND jam_login= '10:33:30';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-04-01 ','11:32:28');
DELETE FROM tm_berlian WHERE kode_barang='PMM-YGAE-31-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PMM-YGAE-31-0','00037211','00037211','CINCIN SILVER 925 ','CINCIN SILVER 925','','','48500','48500',' 150000','150000','Nagatech','2026-04-01 11:34:07');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-10-00379 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-YGAE-31-0' LIMIT 1;
UPDATE th_user_login SET tgl_logout = '2026-04-01', jam_logout = '11:34:16' WHERE user_id = 'Nagatech' AND tgl_login = '2026-04-01' AND jam_login= '11:32:28';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-01 ','11:34: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-260401-0001','kasirbip','1',' 700K-16-21','TOKO','BIPPER','PBDG-ZABA-10-0','CINCIN SILVER 925 ','','4.290','1','100.00','263000','0','0','17000','900000','0','0','0','900000','MIA','00041057','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZABA-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.290',berat_jual_asli=berat_jual_asli+'4.290',stock_jual='1',berat_akhir=berat_akhir-'4.290',berat_akhir_asli=berat_akhir_asli-'4.290',stock_akhir='0' WHERE tanggal='2026-04-01' AND kode_barang='PBDG-ZABA-10-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-260401-0001','2026-04-01','4.290','2026-04-01','11:59:01','PLG0010214','900000','900000','0','900000','0','kasirbip','2026-04-01 11:59:00','FJ-260401-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-04-01','FJ-260401-0001','2026-04-01','11:59:01','MIA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260401-0001','2026-04-01','2026-04-01 11:59:00','PENJUALAN : FJ-260401-0001','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260401-0002','D','2026-04-01','11:59:01','TBC','PENJUALAN','FJ-260401-0001','21229663514','900000','21230563514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260401-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-260401-0002','kasirbip',' 1',' 850K-11-12','TOKO','BIPPER','PBDG-YEBG-30-0','CINCIN SILVER 925 ','','2.320','1','100.00','54000','0','0','17000','950000','0','0','0','950000','MIA','00035902','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YEBG-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-04-01' AND kode_barang='PBDG-YEBG-30-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-260401-0002','2026-04-01','2.320','2026-04-01','11:59:01','PLG0010215','950000','950000','0','950000','0','kasirbip','2026-04-01 11:59:00','FJ-260401-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-04-01','FJ-260401-0002','2026-04-01','11:59:01','MIA','950000','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-260401-0002','2026-04-01','2026-04-01 11:59:00','PENJUALAN : FJ-260401-0002','.','TBC','950000','950000','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-260401-0003','D','2026-04-01','11:59:01','TBC','PENJUALAN','FJ-260401-0002','21230563514','950000','21231513514','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='1850000' WHERE no_faktur_jual='FJ-260401-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260401-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260401-0002';
UPDATE th_user_login SET tgl_logout = '2026-04-01', jam_logout = '12:58:18' WHERE user_id = 'kasir' AND tgl_login = '2026-04-01' AND jam_login= '10:52:47';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-04-01 ','13:01:09');
DELETE FROM tm_berlian WHERE kode_barang='TFGRP-YIXA-77-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFGRP-YIXA-77-0','00038447','00038447','THIFA GELANG RANTAI PUTIH ','THIFA GELANG RANTAI PUTIH','','','8345000','8345000',' 0','0','Nagatech','2026-04-01 13:07:27');
UPDATE tm_barang SET nama_barang='THIFA GELANG RANTAI PUTIH' ,nama_atribut='' ,kode_intern='TFGRP75-85% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFGRP-YIXA-77-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-01 ','13:07:53');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260401-0003','kasir','1',' TFGRP75-85','TOKO','TFGLR','TFGRP-YIXA-77-0','THIFA GELANG RANTAI PUTIH','','3.850','1','85.00','8512000','0','0','17000','8580000','0','0','0','8580000','IQB','00038447','TFGRP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRP-YIXA-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.850',berat_jual_asli=berat_jual_asli+'3.850',stock_jual='1',berat_akhir=berat_akhir-'3.850',berat_akhir_asli=berat_akhir_asli-'3.850',stock_akhir='0' WHERE tanggal='2026-04-01' AND kode_barang='TFGRP-YIXA-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-260401-0003','2026-04-01','3.850','2026-04-01','13:08:42','PLG0010216','8580000','8580000','0','8580000','0','kasir','2026-04-01 13:08:41','FJ-260401-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-04-01','FJ-260401-0003','2026-04-01','13:08:42','IQB','8580000','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-260401-0003','2026-04-01','2026-04-01 13:08:41','PENJUALAN : FJ-260401-0003','.','TBC','8580000','8580000','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-260401-0004','D','2026-04-01','13:08:42','TBC','PENJUALAN','FJ-260401-0003','21231513514','8580000','21240093514','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='8580000' WHERE no_faktur_jual='FJ-260401-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260401-0003';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01917','GIN','1','SEPASANG PALLADIUM','RESIZE CC CWE MENJADI 9 5 FONT VLADIMIR GRAFIR','3.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-01917','2026-04-01','2026-04-01','16:45:51','PLG0010217','kasirbip','2026-04-29','kasirbip','2026-04-01 16:45:51','3.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-01 ','19:03:53');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260401-0004','kasirbip','1',' PLBDG-0011','TOKO','BIPPLD','PLBDG-YLAE-8-0','CINCIN PALADIUM PLBDG-00114 ','','5.130','1','6.00','779000','0','0','17000','2039000','0','0','0','2039000','GIN','00040568','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-YLAE-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.130',berat_jual_asli=berat_jual_asli+'5.130',stock_jual='1',berat_akhir=berat_akhir-'5.130',berat_akhir_asli=berat_akhir_asli-'5.130',stock_akhir='0' WHERE tanggal='2026-04-01' AND kode_barang='PLBDG-YLAE-8-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-260401-0004','2026-04-01','5.130','2026-04-01','19:19:57','PLG0010218','2039000','2039000','0','2039000','0','kasirbip','2026-04-01 19:19:57','FJ-260401-0004','','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-04-01','FJ-260401-0004','2026-04-01','19:19:57','GIN','2039000','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-260401-0004','2026-04-01','2026-04-01 19:19:57','PENJUALAN : FJ-260401-0004','.','TBC','2039000','2039000','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-260401-0005','D','2026-04-01','19:19:57','TBC','PENJUALAN','FJ-260401-0004','21240093514','2039000','21242132514','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='2039000' WHERE no_faktur_jual='FJ-260401-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260401-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-01 ','19:25: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-260401-0005','kasir','1',' 700K-8-672','TOKO','MMPER','PMM-YLAX-104-0','CINCIN SILVER 925 ','','1.820','1','100.00','112000','0','0','17000','850000','150000','0','0','850000','FIR','00040506','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLAX-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-04-01' AND kode_barang='PMM-YLAX-104-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-260401-0005','2026-04-01','1.820','2026-04-01','19:30:04','PLG0010219','850000','850000','0','850000','0','kasir','2026-04-01 19:30:03','FJ-260401-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-04-01','FJ-260401-0005','2026-04-01','19:30:04','FIR','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260401-0005','2026-04-01','2026-04-01 19:30:03','PENJUALAN : FJ-260401-0005','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260401-0006','D','2026-04-01','19:30:04','TBC','PENJUALAN','FJ-260401-0005','21242132514','850000','21242982514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260401-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260401-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260401-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-01 ','20:37:37');