INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-22 ','08:32:02');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-22','147','0','52900000','147','0','52900000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-21';
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-05-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-21' 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-260522-0001','D','2026-05-22','08:32:23','BCA','SALDO AWAL','SALDO AWAL','0','2055685276','2055685276');
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-260522-0001','D','2026-05-22','08:32:23','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-22 ','08:32:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-05-22 ','08:41:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-22 ','08:50:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-22 ','08:52:55');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260522-0001','1','X-00009491','BELI','BELI001','CN COR BT MK','1','1.070','1044000.00' ,'0.00','1044000','','1044000','1044000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-22 09:16:18' WHERE kode_barang='X-00009491' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009491' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009491' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.070',berat_hancur_asli=berat_hancur_asli+'1.070', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260522-0001','2','X-00009492','BELI','BELI001','CN CAP BANGKOK SLP SHB','1','1.000','976000.00' ,'0.00','976000','','976000','3064000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-22 09:16:18' WHERE kode_barang='X-00009492' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009492' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009492' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.000',berat_hancur_asli=berat_hancur_asli+'1.000', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260522-0001','3','X-00009493','BELI','BELI001','CN COR TDK BT SHB','1','0.850','829500.00' ,'0.00','829500','','829500','4869500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-22 09:16:18' WHERE kode_barang='X-00009493' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009493' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009493' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.850',berat_hancur_asli=berat_hancur_asli+'0.850', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260522-0001','4','X-00009494','BELI','BELI001','GL CAP HOLO 17CM SHB','1','10.730','10472000.00' ,'0.00','10472000','','10472000','16171000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-22 09:16:18' WHERE kode_barang='X-00009494' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009494' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009494' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'10.730',berat_hancur_asli=berat_hancur_asli+'10.730', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'10.730',berat_akhir_asli=berat_akhir_asli-'10.730' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260522-0001','5','X-00009495','BELI','BELI001','CN PLINTIR SHB','1','1.300','1268500.00' ,'0.00','1268500','','1268500','27911500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-22 09:16:18' WHERE kode_barang='X-00009495' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009495' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009495' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.300',berat_hancur_asli=berat_hancur_asli+'1.300', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260522-0001','6','X-00009496','BELI','BELI001','CN COR TDK BT SHB','1','1.250','1220000.00' ,'0.00','1220000','','1220000','30400000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-22 09:16:18' WHERE kode_barang='X-00009496' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009496' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009496' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.250',berat_hancur_asli=berat_hancur_asli+'1.250', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260522-0001','7','X-00009497','BELI','BELI001','CN PLINTIR SHB','1','1.940','1503000.00' ,'0.00','1503000','','1503000','33123000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-05-22 09:16:18' WHERE kode_barang='X-00009497' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009497' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009497' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.940',berat_hancur_asli=berat_hancur_asli+'1.940', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260522-0001','adminpusat','2026-05-22','2026-05-22','09:16:19','17313000','33123000', 'adminpusat','2026-05-22 09:16:18');
UPDATE tt_hutang_head SET byr_harus_rp='1000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'1075000',tgl_lunas='2026-05-22',status='CLOS',total_lunas='1075000' WHERE no_hutang='PI26-01707';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'1000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'1000000'  WHERE tanggal='2026-05-22';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260522-0002','D','2026-05-22','10:29:30','cashier1','HUTANG LUNAS','PI26-01707','132425564','1075000','133500564');
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-00009498','X-00009498','LT COR HURUF H BT SHB','GR','---','MTLT','BELI','BELI001','1563000','2026-05-22','0.940','1','sales','2026-05-22 10:54:30');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTLT','X-00009498','X-00009498');
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-260522-0001','FJ-220618-0013','2502','1','BELI','BELI001','MTLT', 'X-00009498', 'LT COR HURUF H BT SHB','1.010','0.940','100.00','711500','1563000','1662766','1','1563000','1563000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-22','BELI','BELI001','MTLT','MTLT','100.00','0.940','0.940','1','0.940','0.940','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) VALUES ('FB-260522-0001','2026-05-22','2026-05-22','10:54:29','2502','---','0.940','1563000','1563000','1563000','1563000','1563000','sales','2026-05-22 10:54:30','FB-260522-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0001','HANAN','JATISRONO TIMUR 1/8','','','','sales','2026-05-22 10:54:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260522-0003','K','2026-05-22','10:54:29','sales','PEMBELIAN UMUM','FB-260522-0001','133500564','1563000','131937564','OPEN');
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-00009499','X-00009499','KL MILLANO 42CM KKT PER BLT SHB','GR','---','MTKL','BELI','BELI001','7548000','2026-05-22','4.870','1','sales','2026-05-22 10:54:30');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00009499','X-00009499');
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-260522-0002','FJ-220618-0012','2502','2','BELI','BELI001','MTKL', 'X-00009499', 'KL MILLANO 42CM KKT PER BLT SHB','4.970','4.870','100.00','3499000','7548000','1549897','1','7548000','7548000','RONGSOK');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-22','BELI','BELI001','MTKL','MTKL','100.00','4.870','4.870','1','4.870','4.870','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) VALUES ('FB-260522-0002','2026-05-22','2026-05-22','10:54:29','2502','---','4.870','7548000','7548000','7548000','7548000','7548000','sales','2026-05-22 10:54:30','FB-260522-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0002','HANAN','JATISRONO TIMUR 1/8','','','','sales','2026-05-22 10:54:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260522-0004','K','2026-05-22','10:54:29','sales','PEMBELIAN UMUM','FB-260522-0002','131937564','7548000','124389564','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0002';
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) VALUES ('FJ-260522-0001','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZEAI-11-0','CN CAP BANGKOK CRT SMBR PTH MK ','','1.000','1','100.00','1135000','0','0','0','1135000','0','0','0','1135000','2501','00029653','MDCN','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZEAI-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='MDCN-ZEAI-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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) VALUES ('FJ-260522-0001','2026-05-22','1.000','2026-05-22','11:51:52','PLG0018823','1135000','1135000','0','1135000','1135000','sales','2026-05-22 11:51:52','FJ-260522-0001');
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-05-22','FJ-260522-0001','2026-05-22','11:51:52','2501','1135000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260522-0005','D','2026-05-22','11:51:52','sales','PENJUALAN','FJ-260522-0001','124389564','1135000','125524564');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260522-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260522-0002','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZBAB-9-0','CN COR BT MK ','','0.820','1','100.00','931000','0','0','0','931000','0','0','0','931000','2107','00028073','MDCN','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAB-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='MDCN-ZBAB-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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) VALUES ('FJ-260522-0002','2026-05-22','0.820','2026-05-22','12:20:26','PLG0018824','931000','931000','0','931000','931000','sales','2026-05-22 12:20:26','FJ-260522-0002');
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-05-22','FJ-260522-0002','2026-05-22','12:20:26','2107','931000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260522-0006','D','2026-05-22','12:20:26','sales','PENJUALAN','FJ-260522-0002','125524564','931000','126455564');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260522-0002';
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-00009500','X-00009500','KL ITALY ST 44CM KKT S SHB','GR','---','MTKL','BELI','BELI001','6169000','2026-05-22','3.980','1','sales','2026-05-22 12:50:38');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00009500','X-00009500');
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-260522-0003','FJ-250106-0002','2105','1','BELI','BELI001','MTKL', 'X-00009500', 'KL ITALY ST 44CM KKT S SHB','4.030','3.980','100.00','4252000','6169000','1550000','1','6169000','6169000','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.980',berat_beli_asli=berat_beli_asli+'3.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.980',berat_akhir_asli=berat_akhir_asli+'3.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTKL' 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) VALUES ('FB-260522-0003','2026-05-22','2026-05-22','12:50:38','2105','---','3.980','6169000','6169000','6169000','6169000','6169000','sales','2026-05-22 12:50:38','FB-260522-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0003','MUSLIMAH','JOHAR 3/23','','','','sales','2026-05-22 12:50:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260522-0007','K','2026-05-22','12:50:38','sales','PEMBELIAN UMUM','FB-260522-0003','126455564','6169000','120286564','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0003';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260522-0008','K','2026-05-22','13:06:31','cashier1','PENGELUARAN','IURAN APEPI BULAN APRIL 2026','120286564','250000','120036564');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-22 ','13:52:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-22 ','13:55:04');
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-00009501','X-00009501','GL FANCY VIGARU 17CM KKT PER BLT SHB','GR','---','MTGL','BELI','BELI001','2760500','2026-05-22','1.660','1','sales','2026-05-22 14:30:09');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009501','X-00009501');
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-260522-0004','FJ-260207-0005','2502','1','BELI','BELI001','MTGL', 'X-00009501', 'GL FANCY VIGARU 17CM KKT PER BLT SHB','1.660','1.660','100.00','3536000','2760500','1662952','1','2760500','2760500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-05-22','BELI','BELI001','MTGL','MTGL','100.00','1.660','1.660','1','1.660','1.660','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) VALUES ('FB-260522-0004','2026-05-22','2026-05-22','14:30:08','2502','---','1.660','2760500','2760500','2760500','2760500','2760500','sales','2026-05-22 14:30:09','FB-260522-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0004','PUTRI','SIMO GNNG KRMT TMR','','','081818421751','sales','2026-05-22 14:30:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260522-0009','K','2026-05-22','14:30:08','sales','PEMBELIAN UMUM','FB-260522-0004','120036564','2760500','117276064','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-22 ','14:53:04');
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) VALUES ('FJ-260522-0003','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZEAI-12-0','CN COR TDK BT DURIAN LC2 ','','3.120','1','100.00','3541500','0','0','0','3541500','0','0','0','3541500','2106','00029654','MDCN','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZEAI-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='MDCN-ZEAI-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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) VALUES ('FJ-260522-0003','2026-05-22','3.120','2026-05-22','15:22:45','PLG0018825','3541500','3541500','0','3541500','0','sales','2026-05-22 15:22:45','FJ-260522-0003');
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-05-22','FJ-260522-0003','2026-05-22','15:22:45','2106','3541500','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-260522-0001','2026-05-22','2026-05-22 15:22:45','PENJUALAN : FJ-260522-0003','bca','BCA','3541500','3541500','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-260522-0002','D','2026-05-22','15:22:45','BCA','PENJUALAN','FJ-260522-0003','2055685276','3541500','2059226776','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','NURUL QOMARIYAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3541500' WHERE no_faktur_jual='FJ-260522-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) VALUES ('FJ-260522-0004','sales',' 1',' ','TOKO','BTGLMD','MDGL-ZEAB-10-0','GL RANGKAIAN COR 18CM KKT PER SHB ','','6.170','1','100.00','7003000','0','0','0','7003000','0','0','0','7003000','2106','00029486','MDGL','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZEAB-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.170',berat_jual_asli=berat_jual_asli+'6.170',stock_jual='1',berat_akhir=berat_akhir-'6.170',berat_akhir_asli=berat_akhir_asli-'6.170',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='MDGL-ZEAB-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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) VALUES ('FJ-260522-0004','2026-05-22','6.170','2026-05-22','15:22:45','PLG0018826','7003000','7003000','0','7003000','0','sales','2026-05-22 15:22:45','FJ-260522-0003');
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-05-22','FJ-260522-0004','2026-05-22','15:22:45','2106','7003000','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-260522-0002','2026-05-22','2026-05-22 15:22:45','PENJUALAN : FJ-260522-0004','bca','BCA','7003000','7003000','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-260522-0003','D','2026-05-22','15:22:45','BCA','PENJUALAN','FJ-260522-0004','2059226776','7003000','2066229776','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','NURUL QOMARIYAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='7003000' WHERE no_faktur_jual='FJ-260522-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) VALUES ('FJ-260522-0005','sales',' 1',' EX ','TOKO','BTGLMD','MDGL-ZEAI-43-0','GL PAJERO DOLLAR 20CM KKT PER LC2 ','','13.140','1','100.00','14914000','0','0','0','14914000','0','0','0','14914000','2106','00029685','MDGL','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZEAI-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'13.140',berat_jual_asli=berat_jual_asli+'13.140',stock_jual='1',berat_akhir=berat_akhir-'13.140',berat_akhir_asli=berat_akhir_asli-'13.140',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='MDGL-ZEAI-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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) VALUES ('FJ-260522-0005','2026-05-22','13.140','2026-05-22','15:22:45','PLG0018827','14914000','14914000','0','14914000','0','sales','2026-05-22 15:22:45','FJ-260522-0003');
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-05-22','FJ-260522-0005','2026-05-22','15:22:45','2106','14914000','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-260522-0003','2026-05-22','2026-05-22 15:22:45','PENJUALAN : FJ-260522-0005','bca','BCA','14914000','14914000','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-260522-0004','D','2026-05-22','15:22:45','BCA','PENJUALAN','FJ-260522-0005','2066229776','14914000','2081143776','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','NURUL QOMARIYAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='14914000' WHERE no_faktur_jual='FJ-260522-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260522-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260522-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260522-0005';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260522-0006','sales','1',' ','TOKO','BTKLMD','MDKL-ZBXG-8-0','KL FORTUNE PJG 75CM KKT PER LC2 ','','49.610','1','100.00','56307500','0','0','0','56307500','0','0','0','56307500','2502','00027813','MDKL','159000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZBXG-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'49.610',berat_jual_asli=berat_jual_asli+'49.610',stock_jual='1',berat_akhir=berat_akhir-'49.610',berat_akhir_asli=berat_akhir_asli-'49.610',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='MDKL-ZBXG-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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) VALUES ('FJ-260522-0006','2026-05-22','49.610','2026-05-22','15:36:56','PLG0018828','56307500','56307500','0','56307500','31307500','sales','2026-05-22 15:36:55','FJ-260522-0006');
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-05-22','FJ-260522-0006','2026-05-22','15:36:56','2502','56307500','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260522-0010','D','2026-05-22','15:36:56','sales','PENJUALAN','FJ-260522-0006','117276064','31307500','148583564','OPEN');
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-260522-0004','2026-05-22','2026-05-22 15:36:55','PENJUALAN : FJ-260522-0006','bca','BCA','25000000','25000000','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-260522-0005','D','2026-05-22','15:36:56','BCA','PENJUALAN','FJ-260522-0006','2081143776','25000000','2106143776','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','NURUL QOMARIYAH');
UPDATE tt_jual_head SET dibayar_rp='31307500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='25000000' WHERE no_faktur_jual='FJ-260522-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260522-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260522-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-05-22 ','16:11:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-05-22 ','16:19:38');