INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-11-09 ','08:34:29'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-09','106','0','-214300000','106','0','-214300000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-09'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-08'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-08'; 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-11-08' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-08'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-08'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-08'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-08'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-09' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-08' 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-261109-0001','D','2026-11-09','08:34:43','BCA','SALDO AWAL','SALDO AWAL','0','1414500107','1414500107'); 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-261109-0001','D','2026-11-09','08:34:43','','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-11-09'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-11-09 ','08:35:02'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-11-09 ','08:38:58'); 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-00009978','X-00009978','GL HL RT ANAK 14CM KKT PER SHB','GR','---','MTGL','BELI','BELI001','6672500','2026-11-09','4.190','1','sales','2026-11-09 09:49:28'); 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-00009978','X-00009978'); 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-261109-0001','FJ-260629-0003','2103','1','BELI','BELI001','MTGL', 'X-00009978', 'GL HL RT ANAK 14CM KKT PER SHB','4.190','4.190','100.00','7751500','6672500','1592482','1','6672500','6672500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.190',berat_beli_asli=berat_beli_asli+'4.190',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.190',berat_akhir_asli=berat_akhir_asli+'4.190',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-09' 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-261109-0001','2026-11-09','2026-11-09','09:49:28','2103','---','4.190','6672500','6672500','6672500','6672500','6672500','sales','2026-11-09 09:49:28','FB-261109-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261109-0001','RAHMAWATI','WONOKUSUMO DAMAI 4/11','','','','sales','2026-11-09 09:49:28'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-09' 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-261109-0002','K','2026-11-09','09:49:28','sales','PEMBELIAN UMUM','FB-261109-0001','244353965','6672500','237681465','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-11-09 ','09:50:06'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261109-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261109-0001'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-09 ','10:01:28'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-09 ','10:46:02'); 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-00009979','X-00009979','GL VANESSA VAR HT BTR 16CM KKT PER SHB','GR','---','MTGL','BELI','BELI001','5239000','2026-11-09','3.290','1','sales','2026-11-09 12:51:34'); 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-00009979','X-00009979'); 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-261109-0002','FJ-240629-0001','2602','1','BELI','BELI001','MTGL', 'X-00009979', 'GL VANESSA VAR HT BTR 16CM KKT PER SHB','3.390','3.290','100.00','3204000','5239000','1592401','1','5239000','5239000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.290',berat_beli_asli=berat_beli_asli+'3.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.290',berat_akhir_asli=berat_akhir_asli+'3.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-09' 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-261109-0002','2026-11-09','2026-11-09','12:51:33','2602','---','3.290','5239000','5239000','5239000','5239000','5239000','sales','2026-11-09 12:51:34','FB-261109-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261109-0002','NOVA','PASAR LOAK','','','083134907981','sales','2026-11-09 12:51:34'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-09' 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-261109-0003','K','2026-11-09','12:51:33','sales','PEMBELIAN UMUM','FB-261109-0002','237681465','5239000','232442465','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-00009980','X-00009980','CN COR BT MK','GR','---','MTCN','BELI','BELI001','2102000','2026-11-09','1.320','1','sales','2026-11-09 12:51:34'); 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-00009980','X-00009980'); 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-261109-0003','FJ-240629-0002','2602','2','BELI','BELI001','MTCN', 'X-00009980', 'CN COR BT MK','1.370','1.320','100.00','1295000','2102000','1592424','1','2102000','2102000','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.320',berat_beli_asli=berat_beli_asli+'1.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.320',berat_akhir_asli=berat_akhir_asli+'1.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-09' 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-261109-0003','2026-11-09','2026-11-09','12:51:33','2602','---','1.320','2102000','2102000','2102000','2102000','2102000','sales','2026-11-09 12:51:34','FB-261109-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261109-0003','NOVA','PASAR LOAK','','','083134907981','sales','2026-11-09 12:51:34'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-09' 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-261109-0004','K','2026-11-09','12:51:33','sales','PEMBELIAN UMUM','FB-261109-0003','232442465','2102000','230340465','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-00009981','X-00009981','CN COR BT SHB','GR','---','MTCN','BELI','BELI001','2595500','2026-11-09','1.630','1','sales','2026-11-09 12:51:34'); 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-00009981','X-00009981'); 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-261109-0004','FJ-230318-0016','2602','3','BELI','BELI001','MTCN', 'X-00009981', 'CN COR BT SHB','1.680','1.630','100.00','1218000','2595500','1592331','1','2595500','2595500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.630',berat_beli_asli=berat_beli_asli+'1.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.630',berat_akhir_asli=berat_akhir_asli+'1.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-09' 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-261109-0004','2026-11-09','2026-11-09','12:51:33','2602','---','1.630','2595500','2595500','2595500','2595500','2595500','sales','2026-11-09 12:51:34','FB-261109-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261109-0004','NOVA','PASAR LOAK','','','083134907981','sales','2026-11-09 12:51:34'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-09' 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-261109-0005','K','2026-11-09','12:51:33','sales','PEMBELIAN UMUM','FB-261109-0004','230340465','2595500','227744965','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261109-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261109-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261109-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261109-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261109-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261109-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-00009982','X-00009982','AT TINDIK PLS SHB','GR','---','MDAT','BELI','BELI001','449500','2026-11-09','0.480','1','sales','2026-11-09 15:43:47'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009982','X-00009982'); 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-261109-0005','FJ-250114-0005','2602','1','BELI','BELI001','MDAT', 'X-00009982', 'AT TINDIK PLS SHB','0.480','0.480','100.00','318000','449500','936458','1','449500','449500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDAT' 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-261109-0005','2026-11-09','2026-11-09','15:43:46','2602','---','0.480','449500','449500','449500','449500','449500','sales','2026-11-09 15:43:47','FB-261109-0005','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261109-0005','LULUK','ABIMANYU SEL 2/4A','','','','sales','2026-11-09 15:43:47'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-09' 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-261109-0006','K','2026-11-09','15:43:46','sales','PEMBELIAN UMUM','FB-261109-0005','227744965','449500','227295465','OPEN'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-11-09 ','15:45:32'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261109-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261109-0005';