INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-21 ','08:33:32');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-21','120','0','-172300000','120','0','-172300000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-20';
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-09-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-20' 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-260921-0001','D','2026-09-21','08:33:47','','SALDO AWAL','SALDO AWAL','0','0','0');
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-260921-0001','D','2026-09-21','08:33:47','BCA','SALDO AWAL','SALDO AWAL','0','1349604582','1349604582');
UPDATE tp_system SET tgl_system='2026-09-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-21 ','08:34:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-21 ','08:44:05');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260921-0001','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZIAH-31-0','CN COR BT SHB ','','0.920','1','100.00','1021500','0','0','0','1021500','0','0','0','1021500','2602','00031468','MDCN','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZIAH-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MDCN-ZIAH-31-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-260921-0001','2026-09-21','0.920','2026-09-21','09:09:13','PLG0019494','1021500','1021500','0','1021500','0','sales','2026-09-21 09:09:12','FJ-260921-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-09-21','FJ-260921-0001','2026-09-21','09:09:13','2602','1021500','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-260921-0001','2026-09-21','2026-09-21 09:09:12','PENJUALAN : FJ-260921-0001','bri','BCA','1021500','1021500','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-260921-0002','D','2026-09-21','09:09:13','BCA','PENJUALAN','FJ-260921-0001','1349604582','1021500','1350626082','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bri','RIZA UMAMI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1021500' WHERE no_faktur_jual='FJ-260921-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0001';
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-00009829','X-00009829','CN CAP BANGKOK LBG SHB','GR','---','MTCN','BELI','BELI001','1683500','2026-09-21','1.040','1','sales','2026-09-21 09:22:19');
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-00009829','X-00009829');
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-260921-0001','FJ-260610-0003','2105','1','BELI','BELI001','MTCN', 'X-00009829', 'CN CAP BANGKOK LBG SHB','1.040','1.040','100.00','1997000','1683500','1618750','1','1683500','1683500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.040',berat_beli_asli=berat_beli_asli+'1.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.040',berat_akhir_asli=berat_akhir_asli+'1.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-260921-0001','2026-09-21','2026-09-21','09:22:18','2105','---','1.040','1683500','1683500','1683500','1683500','1683500','sales','2026-09-21 09:22:19','FB-260921-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0001','KENZO','BLK JAYA 2','','','','sales','2026-09-21 09:22:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0002','K','2026-09-21','09:22:18','sales','PEMBELIAN UMUM','FB-260921-0001','137533539','1683500','135850039','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-21 ','09:24:26');
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-260921-0001','1','X-00009824','BELI','BELI001','AT TINDIK POLOS SHB','1','0.420','294000.00' ,'0.00','294000','','294000','294000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-21 09:55:33' WHERE kode_barang='X-00009824' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009824' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009824' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.420',berat_hancur_asli=berat_hancur_asli+'0.420', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' 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-260921-0001','2','X-00009825','BELI','BELI001','CN CAP ANAK TDK BT SHB','1','0.470','760500.00' ,'0.00','760500','','760500','1348500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-21 09:55:33' WHERE kode_barang='X-00009825' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009825' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009825' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.470',berat_hancur_asli=berat_hancur_asli+'0.470', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' 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-260921-0001','3','X-00009826','BELI','BELI001','GL BABY PLINTIR SHB','1','1.520','1200000.00' ,'0.00','1200000','','1200000','3309000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-21 09:55:33' WHERE kode_barang='X-00009826' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009826' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009826' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.520',berat_hancur_asli=berat_hancur_asli+'1.520', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MSGL' 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-260921-0001','4','X-00009827','BELI','BELI001','CN COR CAT BT BTG','1','0.780','744500.00' ,'0.00','744500','','744500','5253500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-21 09:55:33' WHERE kode_barang='X-00009827' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009827' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009827' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.780',berat_hancur_asli=berat_hancur_asli+'0.780', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780' 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-260921-0001','adminpusat','2026-09-21','2026-09-21','09:55:34','2999000','5253500', 'adminpusat','2026-09-21 09:55:33');
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-00009830','X-00009830','CN COR HT BT SHB','GR','---','MTCN','BELI','BELI001','1149000','2026-09-21','0.710','1','sales','2026-09-21 10:06:15');
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-00009830','X-00009830');
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-260921-0002','FJ-210501-0015','2502','1','BELI','BELI001','MTCN', 'X-00009830', 'CN COR HT BT SHB','0.810','0.710','100.00','531000','1149000','1618310','1','1149000','1149000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.710',berat_beli_asli=berat_beli_asli+'0.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.710',berat_akhir_asli=berat_akhir_asli+'0.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-260921-0002','2026-09-21','2026-09-21','10:06:14','2502','---','0.710','1149000','1149000','1149000','1149000','1149000','sales','2026-09-21 10:06:15','FB-260921-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0002','KOLILA','SUTIGANTI GG 1','','','087853882004','sales','2026-09-21 10:06:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0003','K','2026-09-21','10:06:14','sales','PEMBELIAN UMUM','FB-260921-0002','135850039','1149000','134701039','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-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-260921-0002','sales','1',' EX ','TOKO','BTKLMD','MDKL-ZGAE-85-0','KL FANCY 42CM KKT PER SHB ','','1.860','1','100.00','2065000','0','0','0','2065000','0','0','0','2065000','2105','00030837','MDKL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZGAE-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MDKL-ZGAE-85-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-260921-0002','2026-09-21','1.860','2026-09-21','10:22:19','PLG0019495','2065000','2065000','0','2065000','2065000','sales','2026-09-21 10:22:19','FJ-260921-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-09-21','FJ-260921-0002','2026-09-21','10:22:19','2105','2065000','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-260921-0004','D','2026-09-21','10:22:19','sales','PENJUALAN','FJ-260921-0002','134701039','2065000','136766039');
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-00009831','X-00009831','LT COR BOROBUDUR LC2','GR','---','MDLT','BELI','BELI001','6261500','2026-09-21','6.560','1','sales','2026-09-21 10:23:37');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDLT','X-00009831','X-00009831');
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-260921-0003','FJ-260507-0004','2502','1','BELI','BELI001','MDLT', 'X-00009831', 'LT COR BOROBUDUR LC2','6.560','6.560','100.00','7446000','6261500','954497','1','6261500','6261500','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-09-21','BELI','BELI001','MDLT','MDLT','100.00','6.560','6.560','1','6.560','6.560','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-260921-0003','2026-09-21','2026-09-21','10:23:37','2502','---','6.560','6261500','6261500','6261500','6261500','6261500','sales','2026-09-21 10:23:37','FB-260921-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0003','NUR','SRENGGANAN 1/9','','','','sales','2026-09-21 10:23:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0005','K','2026-09-21','10:23:37','sales','PEMBELIAN UMUM','FB-260921-0003','136766039','6261500','130504539','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-00009832','X-00009832','KL SATELIT PSR 49CM KKT PER SHB','GR','---','MDKL','BELI','BELI001','10308500','2026-09-21','10.800','1','sales','2026-09-21 10:23:37');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009832','X-00009832');
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-260921-0004','FJ-251118-0007','2502','2','BELI','BELI001','MDKL', 'X-00009832', 'KL SATELIT PSR 49CM KKT PER SHB','10.800','10.800','100.00','10908000','10308500','954491','1','10308500','10308500','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-09-21','BELI','BELI001','MDKL','MDKL','100.00','10.800','10.800','1','10.800','10.800','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-260921-0004','2026-09-21','2026-09-21','10:23:37','2502','---','10.800','10308500','10308500','10308500','10308500','10308500','sales','2026-09-21 10:23:37','FB-260921-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0004','MBAK NUR','SRENGGANAN 1 NO.9','','','087761670817','sales','2026-09-21 10:23:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0006','K','2026-09-21','10:23:37','sales','PEMBELIAN UMUM','FB-260921-0004','130504539','10308500','120196039','OPEN');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0004';
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-00009833','X-00009833','CN CAP TDK BT SHB','GR','---','MTCN','BELI','BELI001','1878000','2026-09-21','1.160','1','sales','2026-09-21 10:30:39');
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-00009833','X-00009833');
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-260921-0005','FJ-260304-0013','2106','1','BELI','BELI001','MTCN', 'X-00009833', 'CN CAP TDK BT SHB','1.160','1.160','100.00','2529000','1878000','1618966','1','1878000','1878000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.160',berat_beli_asli=berat_beli_asli+'1.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-260921-0005','2026-09-21','2026-09-21','10:30:38','2106','---','1.160','1878000','1878000','1878000','1878000','1878000','sales','2026-09-21 10:30:39','FB-260921-0005','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0005','NUR HAYANI','KARANG GAYAM WETAN 1A/5','','SBY','','sales','2026-09-21 10:30:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0007','K','2026-09-21','10:30:38','sales','PEMBELIAN UMUM','FB-260921-0005','120196039','1878000','118318039','OPEN');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-21 ','10:30: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-260921-0002','1','X-00009828','BELI','BELI001','AT TUSUK ITALY BL SLP SHB','1','1.130','1829000.00' ,'0.00','1829000','','1829000','1829000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-21 10:31:36' WHERE kode_barang='X-00009828' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009828' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009828' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.130',berat_hancur_asli=berat_hancur_asli+'1.130', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130' 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-260921-0002','adminpusat','2026-09-21','2026-09-21','10:31:37','1829000','1829000', 'adminpusat','2026-09-21 10:31:36');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0005';
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-00009834','X-00009834','CN COR BT MK','GR','---','MDCN','BELI','BELI001','1021000','2026-09-21','1.070','1','sales','2026-09-21 10:51:33');
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-00009834','X-00009834');
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-260921-0006','FJ-260628-0007','2107','1','BELI','BELI001','MDCN', 'X-00009834', 'CN COR BT MK','1.070','1.070','100.00','1193500','1021000','954206','1','1021000','1021000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' 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-260921-0006','2026-09-21','2026-09-21','10:51:33','2107','---','1.070','1021000','1021000','1021000','1021000','1021000','sales','2026-09-21 10:51:33','FB-260921-0006','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0006','KHOLIFAH','SIMOLAWANG 6/4E','','','','sales','2026-09-21 10:51:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0008','K','2026-09-21','10:51:33','sales','PEMBELIAN UMUM','FB-260921-0006','118318039','1021000','117297039','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-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-00009835','X-00009835','CN COR SETENGAH RT SHB','GR','---','MTCN','BELI','BELI001','2800500','2026-09-21','1.730','1','sales','2026-09-21 11:10:43');
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-00009835','X-00009835');
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-260921-0007','FJ-260506-0004','2106','1','BELI','BELI001','MTCN', 'X-00009835', 'CN COR SETENGAH RT SHB','1.730','1.730','100.00','3270000','2800500','1618786','1','2800500','2800500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.730',berat_beli_asli=berat_beli_asli+'1.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.730',berat_akhir_asli=berat_akhir_asli+'1.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-260921-0007','2026-09-21','2026-09-21','11:10:43','2106','---','1.730','2800500','2800500','2800500','2800500','2800500','sales','2026-09-21 11:10:43','FB-260921-0007','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0007','FADIL','WONOKUSUMO LOR 13/35','','','','sales','2026-09-21 11:10:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0009','K','2026-09-21','11:10:43','sales','PEMBELIAN UMUM','FB-260921-0007','117297039','2800500','114496539','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0007';
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-260921-0003','sales','1',' ','TOKO','BTCNMD','MDCN-ZFXE-13-0','CN COR BT SHB ','','0.880','1','100.00','977000','0','0','0','977000','0','0','0','977000','2402','00029911','MDCN','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZFXE-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MDCN-ZFXE-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-260921-0003','2026-09-21','0.880','2026-09-21','11:33:00','PLG0019496','977000','977000','0','977000','977000','sales','2026-09-21 11:33:00','FJ-260921-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-09-21','FJ-260921-0003','2026-09-21','11:33:00','2402','977000','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-260921-0010','D','2026-09-21','11:33:00','sales','PENJUALAN','FJ-260921-0003','114496539','977000','115473539','OPEN');
UPDATE tt_jual_head SET dibayar_rp='977000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260921-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-260921-0004','sales',' 1',' EX ','TOKO','BTCNMT','MTCN-ZHBI-46-0','CN PIPA BT AD MRH SHB ','','1.120','1','100.00','2061000','0','0','0','2061000','0','0','0','2061000','2402','00031218','MTCN','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZHBI-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MTCN-ZHBI-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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-260921-0004','2026-09-21','1.120','2026-09-21','11:33:00','PLG0019497','2061000','2061000','0','2061000','2061000','sales','2026-09-21 11:33:00','FJ-260921-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-09-21','FJ-260921-0004','2026-09-21','11:33:00','2402','2061000','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-260921-0011','D','2026-09-21','11:33:00','sales','PENJUALAN','FJ-260921-0004','115473539','2061000','117534539','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2061000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260921-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0004';
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-260921-0005','sales','1',' ','TOKO','BTGLMD','MDGL-YKXE-51-0','GL RANGKAIAN VC SLP BT BT 17CM KKT PER MK ','','3.030','1','100.00','3363500','0','0','0','3379500','16000','0','0','3379500','2502','00026763','MDGL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-YKXE-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MDGL-YKXE-51-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-260921-0005','2026-09-21','3.030','2026-09-21','11:37:43','PLG0019498','3379500','3379500','0','3379500','3379500','sales','2026-09-21 11:37:43','FJ-260921-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-09-21','FJ-260921-0005','2026-09-21','11:37:43','2502','3379500','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-260921-0012','D','2026-09-21','11:37:43','sales','PENJUALAN','FJ-260921-0005','117534539','3379500','120914039');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0005';
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-00009836','X-00009836','GL ITALY ST SRT BL PSR BL SLP 19CM KKT PER SHB','GR','---','MDGL','BELI','BELI001','2176000','2026-09-21','2.280','1','sales','2026-09-21 11:48:29');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00009836','X-00009836');
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-260921-0008','FJ-260831-0001','2106','1','BELI','BELI001','MDGL', 'X-00009836', 'GL ITALY ST SRT BL PSR BL SLP 19CM KKT PER SHB','2.280','2.280','100.00','2565000','2176000','954386','1','2176000','2176000','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-09-21','BELI','BELI001','MDGL','MDGL','100.00','2.280','2.280','1','2.280','2.280','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-260921-0008','2026-09-21','2026-09-21','11:48:28','2106','---','2.280','2176000','2176000','2176000','2176000','2176000','sales','2026-09-21 11:48:29','FB-260921-0008','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0008','RAMA','RANDU AGUNG 1/46','','SBY','','sales','2026-09-21 11:48:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0013','K','2026-09-21','11:48:28','sales','PEMBELIAN UMUM','FB-260921-0008','120914039','2176000','118738039','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0008';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-21 ','13:08:16');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01857','2602','1','AT JEPSY PLINTIR SMBR MAS PTH 750UBS','0','2','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'2',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'5000000', qty_akhir=qty_akhir+'2',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'5000000'  WHERE tanggal='2026-09-21'
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01857','2602','2','CN BKK PLS SHB16K PSK','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'5000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'5000000'  WHERE tanggal='2026-09-21'
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01857','2602','3','CN BOBA SG700','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'5000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'5000000'  WHERE tanggal='2026-09-21'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01857','2026-09-21','2026-09-21','14:01:55','PLG0019499','2602','90','2026-12-20','sales','2026-09-21 14:01:54','6.100','5000000','3.00','450000','5450000','0','OPEN','17.15','4','2026-12-20','0','5450000')
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-260921-0014','K','2026-09-21','14:01:55','sales','HUTANG','PI26-01857','118738039','5000000','113738039','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01857' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01857';
UPDATE tt_hutang_head SET byr_harus_rp='1700000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'1966000',tgl_lunas='2026-09-21',status='CLOS',total_lunas='1966000' WHERE no_hutang='PI26-01750';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'1700000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'1700000'  WHERE tanggal='2026-09-21';
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-260921-0015','D','2026-09-21','14:16:43','cashier1','HUTANG LUNAS','PI26-01750','113738039','1966000','115704039');
UPDATE tt_hutang_head SET byr_harus_rp='5000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'5655000',tgl_lunas='2026-09-21',status='CLOS',total_lunas='5655000' WHERE no_hutang='PI26-01768';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'5000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'5000000'  WHERE tanggal='2026-09-21';
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-260921-0016','D','2026-09-21','14:17:22','cashier1','HUTANG LUNAS','PI26-01768','115704039','5655000','121359039');
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-260921-0006','sales','1',' EX ','TOKO','BTGLMT','MTGL-ZEAH-48-0','GL RANGKAIAN BTR VAR BT MN6 17CM KKT PER HWT ','','7.580','1','100.00','13947500','0','0','0','13947500','0','0','0','13947500','2402','00029624','MTGL','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZEAH-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.580',berat_jual_asli=berat_jual_asli+'7.580',stock_jual='1',berat_akhir=berat_akhir-'7.580',berat_akhir_asli=berat_akhir_asli-'7.580',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MTGL-ZEAH-48-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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-260921-0006','2026-09-21','7.580','2026-09-21','14:28:33','PLG0019500','13947500','13947500','0','13947500','13947500','sales','2026-09-21 14:28:32','FJ-260921-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-09-21','FJ-260921-0006','2026-09-21','14:28:33','2402','13947500','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-260921-0017','D','2026-09-21','14:28:33','sales','PENJUALAN','FJ-260921-0006','121359039','13947500','135306539');
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-260921-0007','sales','1',' EX ','TOKO','BTATMT','MTAT-ZHBI-40-0','AT ITALY HT TDK BT SHB ','','1.650','1','100.00','3036000','0','0','0','3036000','0','0','0','3036000','2402','00031212','MTAT','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZHBI-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MTAT-ZHBI-40-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-260921-0007','2026-09-21','1.650','2026-09-21','14:29:27','PLG0019501','3036000','3036000','0','3036000','3036000','sales','2026-09-21 14:29:27','FJ-260921-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-09-21','FJ-260921-0007','2026-09-21','14:29:27','2402','3036000','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-260921-0018','D','2026-09-21','14:29:27','sales','PENJUALAN','FJ-260921-0007','135306539','3036000','138342539');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0007';
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-260921-0019','K','2026-09-21','15:23:40','cashier1','PENGELUARAN','BAYAR LANGGANAN MAINTANANE PT NAGATECH 7 SEPT 2026 SD 6 MARET 2026','138342539','5400000','132942539');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-21 ','15:44:29');
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-260921-0008','cashier1','1',' EX ','TOKO','BTATMT','MTAT-ZEAH-10-0','AT CAP VAR BT MK ','','1.740','1','100.00','3202000','0','0','0','3202000','0','0','0','3202000','2106','00029586','MTAT','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZEAH-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='MTAT-ZEAH-10-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-260921-0008','2026-09-21','1.740','2026-09-21','15:50:04','PLG0019502','3202000','3202000','0','3202000','3202000','cashier1','2026-09-21 15:50:04','FJ-260921-0008');
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-09-21','FJ-260921-0008','2026-09-21','15:50:04','2106','3202000','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-260921-0020','D','2026-09-21','15:50:04','cashier1','PENJUALAN','FJ-260921-0008','132942539','3202000','136144539');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-21 ','15:51:20');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0008';
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-00009837','X-00009837','CN CAP BANGKOK SLP SHB','GR','---','MTCN','BELI','BELI001','1619000','2026-09-21','1.000','1','cashier1','2026-09-21 15:59:14');
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-00009837','X-00009837');
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-260921-0009','FJ-260901-0001','2106','1','BELI','BELI001','MTCN', 'X-00009837', 'CN CAP BANGKOK SLP SHB','1.000','1.000','100.00','1840000','1619000','1619000','1','1619000','1619000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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-260921-0009','2026-09-21','2026-09-21','15:59:13','2106','---','1.000','1619000','1619000','1619000','1619000','1619000','cashier1','2026-09-21 15:59:14','FB-260921-0009','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0009','AL. FARIZKY','JL. KALIMAS BRU 2LBR/50','','','','cashier1','2026-09-21 15:59:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' 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-260921-0021','K','2026-09-21','15:59:13','cashier1','PEMBELIAN UMUM','FB-260921-0009','136144539','1619000','134525539','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-21 ','16:00:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-21 ','16:34:31');