INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-20 ','08:28:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-20 ','08:29:15');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-20','131','0','-128750000','131','0','-128750000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-19';
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-07-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-19' 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-260720-0001','D','2026-07-20','08:29:40','BCA','SALDO AWAL','SALDO AWAL','0','1902289255','1902289255');
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-260720-0001','D','2026-07-20','08:29:40','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-20';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-20 ','08:30:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-07-20 ','08:43:35');
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-00009660','X-00009660','CN COR BT MK','GR','---','MTCN','BELI','BELI001','2012500','2026-07-20','1.250','1','sales','2026-07-20 09:17:32');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009660','X-00009660');
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-260720-0001','FJ-241031-0004','2402','1','BELI','BELI001','MTCN', 'X-00009660', 'CN COR BT MK','1.300','1.250','100.00','1371500','2012500','1610000','1','2012500','2012500','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-07-20','BELI','BELI001','MTCN','MTCN','100.00','1.250','1.250','1','1.250','1.250','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-260720-0001','2026-07-20','2026-07-20','09:17:31','2402','---','1.250','2012500','2012500','2012500','2012500','2012500','sales','2026-07-20 09:17:32','FB-260720-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0001','NAURA','PRAGOTO 2/7A','','','089529782112','sales','2026-07-20 09:17:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0002','K','2026-07-20','09:17:31','sales','PEMBELIAN UMUM','FB-260720-0001','193083650','2012500','191071150','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-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-260720-0001','sales','1',' ','TOKO','BTCNMD','MDCN-ZGAD-7-0','CN COR DB SHB','','1.300','1','100.00','1436500','0','0','0','1436500','0','0','0','1436500','2501','00030725','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZGAD-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MDCN-ZGAD-7-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-260720-0001','2026-07-20','1.300','2026-07-20','09:30:28','PLG0019187','1436500','1436500','0','1436500','1436500','sales','2026-07-20 09:30:28','FJ-260720-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-07-20','FJ-260720-0001','2026-07-20','09:30:28','2501','1436500','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-260720-0003','D','2026-07-20','09:30:28','sales','PENJUALAN','FJ-260720-0001','191071150','1436500','192507650');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-20 ','09:31:12');
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-260720-0001','1','X-00009655','BELI','BELI001','GL ITALY ST SRT VC HTM 19CM KKT PER MK','1','2.550','1851000.00' ,'0.00','1851000','','1851000','1851000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-20 09:31:39' WHERE kode_barang='X-00009655' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009655' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009655' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.550',berat_hancur_asli=berat_hancur_asli+'2.550', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550' 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-260720-0001','2','X-00009656','BELI','BELI001','KL VIGARU FANCY 44CM KKT PER SHB','1','2.950','4749500.00' ,'0.00','4749500','','4749500','8451500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-20 09:31:39' WHERE kode_barang='X-00009656' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009656' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009656' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.950',berat_hancur_asli=berat_hancur_asli+'2.950', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' 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-260720-0001','3','X-00009657','BELI','BELI001','LT COR BT HURUF M SHB','1','1.010','1626000.00' ,'0.00','1626000','','1626000','14827000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-20 09:31:39' WHERE kode_barang='X-00009657' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009657' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009657' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.010',berat_hancur_asli=berat_hancur_asli+'1.010', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTLT' 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-260720-0001','4','X-00009658','BELI','BELI001','GL PIPA BT UBS','1','4.900','7105000.00' ,'0.00','7105000','','7105000','23558000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-20 09:31:39' WHERE kode_barang='X-00009658' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009658' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009658' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.900',berat_hancur_asli=berat_hancur_asli+'4.900', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-260720-0001','5','X-00009659','BELI','BELI001','AT JEPSI DEWI 5 SHB','1','1.000','1450000.00' ,'0.00','1450000','','1450000','32113000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-20 09:31:39' WHERE kode_barang='X-00009659' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009659' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009659' 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='MTAT' 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-260720-0001','adminpusat','2026-07-20','2026-07-20','09:31:39','16781500','32113000', 'adminpusat','2026-07-20 09:31:39');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-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-260720-0002','sales','1',' EX ','TOKO','BTATMT','MTAT-ZGAE-1-0','AT TINDIK TALI AIR MK ','','0.500','1','100.00','915000','0','0','0','915000','0','0','0','915000','2501','00030753','MTAT','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZGAE-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MTAT-ZGAE-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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-260720-0002','2026-07-20','0.500','2026-07-20','10:14:24','PLG0019188','915000','915000','0','915000','915000','sales','2026-07-20 10:14:23','FJ-260720-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-07-20','FJ-260720-0002','2026-07-20','10:14:24','2501','915000','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-260720-0004','D','2026-07-20','10:14:24','sales','PENJUALAN','FJ-260720-0002','192507650','915000','193422650','OPEN');
UPDATE tt_jual_head SET dibayar_rp='915000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260720-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260720-0003','sales',' 1',' EX ','TOKO','BTGLMD','MDGL-ZEAI-54-0','GL PIPA ANAK TDK BT LC2 ','','1.830','1','100.00','2022500','0','0','0','2022500','0','0','0','2022500','2501','00029696','MDGL','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZEAI-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MDGL-ZEAI-54-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-260720-0003','2026-07-20','1.830','2026-07-20','10:14:24','PLG0019189','2022500','2022500','0','2022500','2022500','sales','2026-07-20 10:14:23','FJ-260720-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-07-20','FJ-260720-0003','2026-07-20','10:14:24','2501','2022500','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-260720-0005','D','2026-07-20','10:14:24','sales','PENJUALAN','FJ-260720-0003','193422650','2022500','195445150','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2022500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260720-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-260720-0004','sales',' 1',' EX ','TOKO','BTGLMS','MSGL-ZFAB-33-0','GL BABY PLINTIR 1 BEL SHB','','2.410','1','100.00','2663500','0','0','0','2663500','0','0','0','2663500','2501','00030192','MSGL','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MSGL-ZFAB-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MSGL-ZFAB-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMS' 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-260720-0004','2026-07-20','2.410','2026-07-20','10:14:24','PLG0019190','2663500','2663500','0','2663500','2663500','sales','2026-07-20 10:14:23','FJ-260720-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-07-20','FJ-260720-0004','2026-07-20','10:14:24','2501','2663500','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-260720-0006','D','2026-07-20','10:14:24','sales','PENJUALAN','FJ-260720-0004','195445150','2663500','198108650','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2663500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260720-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-20 ','10:45:11');
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-260720-0005','sales','1',' EX ','TOKO','BTGLMS','MSGL-YKXC-8-0','GL FANCY DB MN 5 17CM KKT PER SHB ','','2.950','1','100.00','3260000','0','0','0','3260000','0','0','0','3260000','2502','00026396','MSGL','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MSGL-YKXC-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MSGL-YKXC-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMS' 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-260720-0005','2026-07-20','2.950','2026-07-20','12:06:40','PLG0019191','3260000','3260000','0','3260000','3260000','sales','2026-07-20 12:06:40','FJ-260720-0005');
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-07-20','FJ-260720-0005','2026-07-20','12:06:40','2502','3260000','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-260720-0007','D','2026-07-20','12:06:40','sales','PENJUALAN','FJ-260720-0005','198108650','3260000','201368650');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-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-260720-0006','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZBXF-83-0','CN COR BT SHB ','','0.940','1','100.00','1039000','0','0','0','1039000','0','0','0','1039000','2402','00027729','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBXF-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.940',berat_jual_asli=berat_jual_asli+'0.940',stock_jual='1',berat_akhir=berat_akhir-'0.940',berat_akhir_asli=berat_akhir_asli-'0.940',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MDCN-ZBXF-83-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-260720-0006','2026-07-20','0.940','2026-07-20','12:53:28','PLG0019192','1039000','1039000','0','1039000','1039000','sales','2026-07-20 12:53:28','FJ-260720-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-07-20','FJ-260720-0006','2026-07-20','12:53:28','2402','1039000','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-260720-0008','D','2026-07-20','12:53:28','sales','PENJUALAN','FJ-260720-0006','201368650','1039000','202407650');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0006';
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-00009661','X-00009661','CN COR BT SHB','GR','---','MDCN','BELI','BELI001','988000','2026-07-20','1.040','1','sales','2026-07-20 12:56:25');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009661','X-00009661');
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-260720-0002','FJ-260708-0001','2403','1','BELI','BELI001','MDCN', 'X-00009661', 'CN COR BT SHB','1.040','1.040','100.00','1160000','988000','950000','1','988000','988000','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-07-20','BELI','BELI001','MDCN','MDCN','100.00','1.040','1.040','1','1.040','1.040','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-260720-0002','2026-07-20','2026-07-20','12:56:25','2403','---','1.040','988000','988000','988000','988000','988000','sales','2026-07-20 12:56:25','FB-260720-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0002','AISYAH','IRAWATI','','','','sales','2026-07-20 12:56:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0009','K','2026-07-20','12:56:25','sales','PEMBELIAN UMUM','FB-260720-0002','202407650','988000','201419650','OPEN');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-20 ','12:56:50');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-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-260720-0007','sales','1',' EX ','TOKO','BTATMD','MDAT-ZBBX-56-0','AT COR KLP BT AD HIJAU MK ','','1.540','1','100.00','1702000','0','0','0','1702000','0','0','0','1702000','2106','00028604','MDAT','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZBBX-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MDAT-ZBBX-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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-260720-0007','2026-07-20','1.540','2026-07-20','13:43:36','PLG0019193','1702000','1702000','0','1702000','1702000','sales','2026-07-20 13:43:35','FJ-260720-0007');
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-07-20','FJ-260720-0007','2026-07-20','13:43:36','2106','1702000','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-260720-0010','D','2026-07-20','13:43:36','sales','PENJUALAN','FJ-260720-0007','201419650','1702000','203121650','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1702000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260720-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) VALUES ('FJ-260720-0008','sales',' 1',' ','TOKO','BTCNMD','MDCN-ZDAX-20-0','CN COR LBG CAT LC2 ','','2.180','1','100.00','2409000','0','0','0','2409000','0','0','0','2409000','2106','00029050','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZDAX-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MDCN-ZDAX-20-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-260720-0008','2026-07-20','2.180','2026-07-20','13:43:36','PLG0019194','2409000','2409000','0','2409000','2409000','sales','2026-07-20 13:43:35','FJ-260720-0007');
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-07-20','FJ-260720-0008','2026-07-20','13:43:36','2106','2409000','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-260720-0011','D','2026-07-20','13:43:36','sales','PENJUALAN','FJ-260720-0008','203121650','2409000','205530650','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2409000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260720-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0008';
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-260720-0009','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZEAI-13-0','CN COR TDK BT SHB ','','1.750','1','100.00','1934000','0','0','0','1934000','0','0','0','1934000','2502','00029655','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZEAI-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='MDCN-ZEAI-13-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-260720-0009','2026-07-20','1.750','2026-07-20','14:05:21','PLG0019195','1934000','1934000','0','1934000','1934000','sales','2026-07-20 14:05:20','FJ-260720-0009');
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-07-20','FJ-260720-0009','2026-07-20','14:05:21','2502','1934000','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-260720-0012','D','2026-07-20','14:05:21','sales','PENJUALAN','FJ-260720-0009','205530650','1934000','207464650');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0009';
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-00009662','X-00009662','GL VIGARO VC 17CM KKT PER MK','GR','---','MTGL','BELI','BELI001','5441500','2026-07-20','3.380','1','sales','2026-07-20 14:27:42');
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-00009662','X-00009662');
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-260720-0003','FJ-250915-0005','2502','1','BELI','BELI001','MTGL', 'X-00009662', 'GL VIGARO VC 17CM KKT PER MK','3.380','3.380','100.00','5003000','5441500','1609911','1','5441500','5441500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.380',berat_beli_asli=berat_beli_asli+'3.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.380',berat_akhir_asli=berat_akhir_asli+'3.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGL' 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-260720-0003','2026-07-20','2026-07-20','14:27:42','2502','---','3.380','5441500','5441500','5441500','5441500','5441500','sales','2026-07-20 14:27:42','FB-260720-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0003','HIKMAH','PETEMON SIDOMULYO 4A/67','','','087754959513','sales','2026-07-20 14:27:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0013','K','2026-07-20','14:27:42','sales','PEMBELIAN UMUM','FB-260720-0003','207464650','5441500','202023150','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-20 ','15:08:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-20 ','16:13:22');