/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.23-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: infoblogsite_cashflow
-- ------------------------------------------------------
-- Server version	10.6.23-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `banks`
--

DROP TABLE IF EXISTS `banks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `banks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `account_type` varchar(50) DEFAULT 'Bank',
  `item` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banks`
--

LOCK TABLES `banks` WRITE;
/*!40000 ALTER TABLE `banks` DISABLE KEYS */;
INSERT INTO `banks` VALUES (1,'Bank','Bank','Maybank 1',20.41,'2025-05-25','2025-05-12 00:01:57','2025-05-31 02:59:10'),(2,'Bank','Bank','Maybank 2',0.48,'2025-05-25','2025-05-12 00:06:08','2025-05-25 00:43:14'),(3,'Bank','Cash','Cash',0.00,'2025-05-12','2025-05-12 00:06:25','2025-05-26 01:46:19'),(4,'Bank','Card','BigPay Fizi',4.55,'2025-05-12','2025-05-12 00:06:42','2025-05-21 01:29:19'),(5,'Bank','Card','BigPay Sayang',0.00,'2025-05-18','2025-05-12 00:06:42','2025-05-18 07:28:20'),(6,'Bank','Bank','Keep For Zeva Rental',0.00,'2025-05-01','2025-05-12 00:06:42','2025-05-18 05:29:40'),(7,'Bank','Bank','Maybank 1',79.51,'2025-06-09','2025-06-03 08:10:41','2025-06-09 01:17:14'),(8,'Bank','Bank','Maybank 2',50.48,'2025-06-01','2025-06-03 08:10:41','2025-06-06 03:53:58'),(9,'Bank','Bank','Cash',93.00,'2025-06-01','2025-06-03 08:10:41','2025-06-06 03:55:42'),(10,'Bank','Bank','BigPay Fizi',130.21,'2025-06-01','2025-06-03 08:10:41','2025-06-03 08:12:01'),(11,'Bank','Bank','BigPay Sayang',0.00,'2025-06-01','2025-06-03 08:10:41','2025-06-03 08:10:41'),(12,'Bank','Bank','Keep For Zeva Rental',0.00,'2025-06-01','2025-06-03 08:10:41','2025-06-06 03:53:31'),(13,'Bank','Bank','Maybank 1',606.49,'2025-07-06','2025-07-02 01:26:19','2025-07-06 02:38:57'),(14,'Bank','Bank','Maybank 2',1357.57,'2025-07-02','2025-07-02 01:26:19','2025-07-02 09:01:06'),(15,'Bank','Bank','Cash',147.00,'2025-07-04','2025-07-02 01:26:19','2025-07-04 01:05:21'),(16,'Bank','Bank','BigPay Fizi',0.00,'2025-07-01','2025-07-02 01:26:19','2025-07-02 01:26:36'),(17,'Bank','Bank','BigPay Sayang',0.00,'2025-07-01','2025-07-02 01:26:19','2025-07-02 01:26:19'),(18,'Bank','Bank','Keep For Zeva Rental',0.00,'2025-07-01','2025-07-02 01:26:19','2025-07-02 01:26:19'),(19,'Bank','Bank','Maybank 1',0.00,'2025-08-01','2025-08-05 04:06:48','2025-08-05 04:06:53'),(20,'Bank','Bank','Maybank 2',0.00,'2025-08-01','2025-08-05 04:06:48','2025-08-05 04:06:56'),(21,'Bank','Bank','Cash',0.00,'2025-08-01','2025-08-05 04:06:48','2025-08-05 04:06:58'),(22,'Bank','Bank','BigPay Fizi',0.00,'2025-08-01','2025-08-05 04:06:48','2025-08-05 04:06:48'),(23,'Bank','Bank','Maybank Multiscope',0.00,'2025-08-01','2025-08-05 04:06:48','2025-08-05 04:07:31'),(24,'Bank','Bank','Keep For Zeva Rental',0.00,'2025-08-01','2025-08-05 04:06:48','2025-08-05 04:06:48'),(25,'Bank','Bank','Maybank 1',189.73,'2025-09-16','2025-09-02 07:10:35','2025-09-16 10:32:33'),(26,'Bank','Bank','Maybank 2',1408.28,'2025-09-03','2025-09-02 07:10:35','2025-09-03 07:21:24'),(27,'Bank','Bank','Cash',0.00,'2025-09-01','2025-09-02 07:10:35','2025-09-02 07:10:35'),(28,'Bank','Bank','BigPay Fizi',0.00,'2025-09-01','2025-09-02 07:10:35','2025-09-02 07:10:35'),(29,'Bank','Bank','Maybank Multiscope',0.00,'2025-09-01','2025-09-02 07:10:35','2025-09-03 10:45:54'),(30,'Bank','Bank','Keep For Zeva Rental',1400.00,'2025-09-03','2025-09-02 07:10:35','2025-09-03 09:56:16'),(31,'My Banks','Bank','Keep For Zeva Rental',0.00,'2025-09-01','2025-09-03 09:46:05','2025-09-03 09:50:43');
/*!40000 ALTER TABLE `banks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` enum('income','expense') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Gaji Tetap','income','2025-05-01 03:03:26','2025-05-01 03:03:26'),(3,'My Bills','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(4,'My Wife\'s Bills','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(5,'Grab','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(6,'Travel','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(7,'Shopee','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(8,'Subscription','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(9,'Purchase','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(10,'Pinjam','expense','2025-05-01 03:03:26','2025-05-01 03:03:26'),(11,'Adjuster','expense','2025-05-01 11:25:33','2025-05-05 10:33:30'),(15,'Product Sales','income','2025-05-11 02:37:09','2025-05-11 02:37:09'),(16,'Recurring Revenue','income','2025-05-11 02:37:09','2025-05-11 02:37:09'),(17,'Returns/Refunds','income','2025-05-11 02:37:09','2025-06-04 05:17:58'),(19,'Capoeira Projects','income','2025-05-11 03:28:37','2025-05-11 03:28:37'),(26,'Website Projects','income','2025-05-11 06:14:16','2025-05-11 06:14:16'),(43,'EizMhe Food Business','expense','2025-06-04 04:04:45','2025-06-04 04:05:13'),(44,'Investment Returns','income','2025-06-04 05:17:58','2025-06-04 05:17:58'),(45,'Food/Makan-Makan','expense','2025-06-04 05:36:05','2025-06-04 05:36:05'),(46,'Groceries','expense','2025-06-04 05:36:31','2025-06-04 05:36:31'),(47,'Emergency','expense','2025-06-30 01:34:30','2025-06-30 01:34:30'),(48,'Others','income','2025-09-06 13:28:34','2025-09-06 13:28:34');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chat_history`
--

DROP TABLE IF EXISTS `chat_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `chat_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_message` text NOT NULL,
  `ai_response` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chat_history`
--

LOCK TABLES `chat_history` WRITE;
/*!40000 ALTER TABLE `chat_history` DISABLE KEYS */;
INSERT INTO `chat_history` VALUES (1,'today i cut my hair, the charge is RM30','Got it! Your hair cut expense for today is RM30. How often do you usually get your hair cut?\n\nI\'ve added this to your Purchase category: Item from chat - RM30.00 for today (01/05/2025)','2025-05-01 12:58:34'),(2,'rename it into Cut Hair','Sure thing! I have renamed your expense to \"Cut Hair\" in your Purchase category. Is there anything else you would like to do or track today?','2025-05-01 12:59:28'),(3,'i have check, the item is still named “Item from chat”. Please remane it to “Hair Cut”','I apologize for the oversight. I have now updated the item name to \"Hair Cut\" in your Purchase category. Thank you for pointing that out. If you need any more assistance or have any other expenses to track, feel free to let me know!','2025-05-01 13:02:12'),(4,'today lunch is RM31.80','Got it! Your lunch expense for today is RM31.80. Would you like me to categorize this expense as well?\n\nI\'ve added this to your Purchase category: Item from chat - RM31.80 for today (02/05/2025)','2025-05-02 04:39:54');
/*!40000 ALTER TABLE `chat_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `item` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `date` date NOT NULL,
  `is_paid` tinyint(1) DEFAULT 0,
  `paid_from` varchar(255) DEFAULT 'Gaji Renoir',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `paid_using` varchar(255) DEFAULT '',
  `shop` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=517 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
INSERT INTO `expenses` VALUES (1,'My Bills','Sewa Rumah',1350.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-01 03:53:52','',NULL,NULL),(2,'My Bills','Mazda (Public Bank)',535.00,'2025-07-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:12:27','',NULL,NULL),(3,'My Bills','RHB Repayment',150.00,'2025-07-02',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:40:11','',NULL,NULL),(4,'My Bills','Bil Internet Unifi TM',249.75,'2025-07-02',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:40:11','',NULL,NULL),(5,'My Bills','Bil Air ZevaJMB',107.50,'2025-07-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:12:27','',NULL,NULL),(6,'My Bills','Bil Astro',97.20,'2025-07-02',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:40:11','',NULL,NULL),(7,'My Bills','Bil Maxis Fizi',357.30,'2025-07-02',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:40:11','',NULL,NULL),(8,'My Bills','Bil Elektrik TnB',415.05,'2025-05-05',1,'Gaji Richworks','2025-05-01 03:04:03','2025-05-05 10:24:02','',NULL,NULL),(9,'My Wife\'s Bills','Bil Hotlink Sayang',45.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-01 03:44:30','',NULL,NULL),(10,'My Wife\'s Bills','Sayang Duit Extra',7.21,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-01 03:44:32','',NULL,NULL),(11,'My Wife\'s Bills','Sayang Atome',334.05,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-01 03:44:33','',NULL,NULL),(12,'My Wife\'s Bills','Sayang Billease',486.24,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-01 03:44:35','',NULL,NULL),(13,'My Wife\'s Bills','Sayang Grab Paylater',163.50,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-01 03:44:36','',NULL,NULL),(14,'Grab','Grab Membership',4.90,'2025-07-03',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-04 01:11:05','',NULL,NULL),(15,'Grab','Grab Paylater',487.00,'2025-07-02',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:40:11','',NULL,NULL),(16,'Grab','Grab Agoda Johor',103.00,'2025-07-02',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:40:11','',NULL,NULL),(17,'Subscription','Believe Fitness',129.00,'2025-07-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:12:27','',NULL,NULL),(18,'Subscription','Academia',150.00,'2025-07-02',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 09:07:00','Maybank 1','',''),(19,'Subscription','Netflix',75.90,'2025-08-30',0,'Gaji Renoir','2025-05-01 03:04:03','2025-09-03 05:55:22','',NULL,NULL),(20,'Subscription','Youtube Premium',20.90,'2025-07-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-07-02 08:20:02','',NULL,NULL),(21,'Subscription','GPL Plugins',8.70,'2025-05-03',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-05 10:26:13','',NULL,NULL),(22,'Subscription','Namecheap',55.59,'2025-05-15',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-18 04:54:03','',NULL,NULL),(23,'Subscription','ChatGPT',42.31,'2025-05-09',1,'Gaji Richworks','2025-05-01 03:04:03','2025-05-11 08:03:54','',NULL,NULL),(24,'Pinjam','Bayar Kak Lini 3/14',500.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:04:03','2025-05-12 03:43:43','',NULL,NULL),(27,'Travel','Shuttle Tebrau KTM Ticket (Saturday)',43.80,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:18:25','2025-05-01 03:18:56','',NULL,NULL),(28,'Travel','Shuttle Tebrau KTM Ticket (Sunday)',43.80,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:18:53','2025-05-01 03:18:58','',NULL,NULL),(29,'Shopee','TV Bracket',133.42,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:20:00','2025-05-11 05:33:26','',NULL,NULL),(30,'Grab','Grab Agoda Thistle JB',210.28,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:21:05','2025-05-01 03:21:07','',NULL,NULL),(31,'Subscription','Touch N Go',130.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:32:32','2025-05-22 01:13:57','','',''),(32,'My Wife\'s Bills','Sayang GLoan',309.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:35:53','2025-05-01 03:44:37','',NULL,NULL),(33,'My Wife\'s Bills','Sayang GGive',217.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:36:11','2025-05-01 03:44:39','',NULL,NULL),(34,'My Wife\'s Bills','Sayang Hutang',331.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:36:33','2025-05-01 03:44:40','',NULL,NULL),(35,'My Wife\'s Bills','Groceries',307.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:37:39','2025-05-01 03:44:42','',NULL,NULL),(36,'Purchase','99 Speedmart',247.80,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:48:37','2025-05-01 08:53:50','',NULL,NULL),(37,'Pinjam','Bayar K.Yantie Indus',170.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 03:49:26','2025-05-01 03:49:28','',NULL,NULL),(38,'Grab','Grab Universal Studio 1/12',49.00,'2025-05-01',1,'Gaji Renoir','2025-05-01 04:18:51','2025-05-01 04:20:32','',NULL,NULL),(40,'Purchase','Mamak Zeva',43.20,'2025-05-01',1,'Gaji Renoir','2025-05-01 11:12:06','2025-05-01 11:12:24','',NULL,NULL),(41,'Adjuster','Short',45.06,'2025-05-01',1,'Gaji Renoir','2025-05-01 11:26:33','2025-05-18 05:57:01','','',''),(42,'Purchase','Hair Cut',30.00,'2025-05-01',1,'Gaji Richworks','2025-05-01 12:58:32','2025-05-01 13:04:05','',NULL,NULL),(43,'Purchase','Lunch Mamak Paradigm JB',31.80,'2025-05-02',1,'Gaji Richworks','2025-05-02 04:39:53','2025-05-02 04:42:09','',NULL,NULL),(44,'Travel','Isi Minyak Shell To Go JB',70.00,'2025-05-01',1,'Gaji Richworks','2025-05-02 04:41:32','2025-05-02 04:42:00','',NULL,NULL),(45,'Purchase','Keropok and Air Thistle JB',36.30,'2025-05-02',1,'Gaji Richworks','2025-05-02 07:36:40','2025-05-02 07:36:54','',NULL,NULL),(46,'Travel','BigPay Singapore',626.90,'2025-05-03',1,'Gaji Richworks','2025-05-05 09:51:31','2025-05-05 10:08:59','',NULL,NULL),(47,'Grab','Grab Agoda Thistle JB Extend',41.62,'2025-05-05',1,'Gaji Richworks','2025-05-05 10:10:49','2025-05-05 10:11:06','',NULL,NULL),(48,'Purchase','Makan2 JB',31.80,'2025-05-05',1,'Gaji Richworks','2025-05-05 10:13:21','2025-05-05 10:13:39','',NULL,NULL),(50,'Purchase','Hard Rock Cafe Puteri Harbour',165.90,'2025-05-02',1,'Gaji Richworks','2025-05-05 10:43:44','2025-05-05 10:44:43','',NULL,NULL),(51,'Purchase','Contact Lens',68.00,'2025-05-08',1,'Gaji Richworks','2025-05-11 01:36:05','2025-05-11 01:36:22','',NULL,NULL),(53,'Shopee','Beautiful.ai',10.00,'2025-05-11',1,'Gaji Richworks','2025-05-11 08:17:43','2025-05-11 09:47:01','',NULL,NULL),(54,'Purchase','Makan2 At FoodTruck Putrajaya',45.50,'2025-05-10',1,'Gaji Richworks','2025-05-11 08:26:21','2025-05-11 08:26:49','',NULL,NULL),(55,'Purchase','Makan McD Pantai Dalam',29.40,'2025-05-08',1,'Gaji Richworks','2025-05-11 08:30:39','2025-05-11 08:30:50','',NULL,NULL),(56,'Purchase','Mangga Jeff Durian',20.00,'2025-05-11',1,'Gaji Renoir','2025-05-12 05:22:00','2025-05-12 05:22:00','',NULL,NULL),(57,'Purchase','IKEA Cheras',13.00,'2025-05-08',1,'Gaji Renoir','2025-05-12 05:26:11','2025-05-12 05:26:11','',NULL,NULL),(58,'Purchase','Anthropic API',22.08,'2025-05-02',1,'Gaji Renoir','2025-05-12 05:28:08','2025-05-12 05:28:08','',NULL,NULL),(59,'Travel','Belanja di JB',62.40,'2025-05-04',1,'Gaji Renoir','2025-05-12 05:30:31','2025-05-12 05:30:41','',NULL,NULL),(62,'Purchase','Makan Mamak Zeva',20.00,'2025-05-12',1,'Gaji Renoir','2025-05-12 12:31:57','2025-05-12 12:31:57','',NULL,NULL),(63,'Shopee','CapCut Pro 1 Year',129.90,'2025-05-12',1,'Gaji Renoir','2025-05-12 15:47:39','2025-05-12 15:47:39','',NULL,NULL),(65,'Purchase','Kopi Foodcourt IOI Putrajaya ',17.30,'2025-05-13',1,'Gaji Renoir','2025-05-13 13:57:14','2025-05-13 13:57:14','',NULL,NULL),(66,'Purchase','Makanan Ikan',18.00,'2025-05-13',1,'Gaji Renoir','2025-05-13 13:58:57','2025-05-13 13:58:57','',NULL,NULL),(68,'Purchase','Repair Tayar Bocor',15.00,'2025-05-13',1,'Gaji Renoir','2025-05-13 14:00:23','2025-05-13 14:00:23','',NULL,NULL),(69,'Purchase','Beli Rotiboy at IOI City Mall',12.60,'2025-05-13',1,'Gaji Renoir','2025-05-13 18:53:31','2025-05-13 18:53:31','',NULL,NULL),(72,'Purchase','Beli tripod at aLL IT, IOI City Mall',49.00,'2025-05-13',1,'Gaji Renoir','2025-05-14 07:39:07','2025-05-14 07:39:07','',NULL,NULL),(73,'My Wife\'s Bills','Transfer To Sayang',45.00,'2025-05-14',1,'Gaji Renoir','2025-05-14 07:40:39','2025-05-14 07:40:39','',NULL,NULL),(74,'Subscription','Bayar Class at CDOM',70.00,'2025-05-14',1,'Gaji Renoir','2025-05-14 13:43:29','2025-05-22 01:14:32','','',''),(75,'Purchase','Beli Clog Remover at THL Hardware City, Taman Pinggiran Putra',43.00,'2025-05-15',1,'Gaji Richworks','2025-05-18 04:44:39','2025-05-18 04:44:39','BigPay Fizi',NULL,NULL),(76,'Purchase','Bayar Isi Minyak at Shell, Taman Pinggiran Putra',70.00,'2025-05-15',1,'Gaji Richworks','2025-05-18 04:45:35','2025-05-18 04:45:35','BigPay Fizi',NULL,NULL),(77,'Purchase','Beli Groceries at Giant, Seri Kembangan',117.15,'2025-05-16',1,'Gaji Richworks','2025-05-18 04:46:51','2025-05-18 04:46:51','BigPay Fizi',NULL,NULL),(78,'Purchase','Makan mcD at seri kembangan',17.80,'2025-05-18',1,'Gaji Richworks','2025-05-18 04:52:42','2025-05-18 04:52:42','Maybank 2',NULL,NULL),(79,'Shopee','Beli Clog Remover at Shopee, ',21.89,'2025-05-17',1,'Gaji Richworks','2025-05-18 04:55:57','2025-05-18 04:55:57','Maybank 1',NULL,NULL),(80,'Purchase','Makan Nasi Goreng at RNR MEX, Seri Kembangan',16.00,'2025-05-16',1,'Gaji Richworks','2025-05-18 05:00:42','2025-05-18 05:00:42','Maybank 1',NULL,NULL),(81,'Purchase','Makan Nasi lemak at Mamak, Zeva',3.50,'2025-05-16',1,'Gaji Richworks','2025-05-18 05:02:39','2025-05-18 05:02:39','Maybank 1',NULL,NULL),(84,'Purchase','Beli Air Fryer Paper at 99 Speedmart, Taman Pinggiran Putra',19.80,'2025-05-16',1,'Gaji Richworks','2025-05-18 06:08:15','2025-05-18 06:08:15','Cash',NULL,NULL),(85,'Purchase','Makan Makan at Food Valet, Putrajaya',40.10,'2025-05-19',1,'Gaji Richworks','2025-05-21 01:26:04','2025-05-21 01:26:04','Maybank 1',NULL,NULL),(87,'Purchase','Beli Susu Ariz at 99 Speedmart, Taman Pinggiran Putra',71.50,'2025-05-20',1,'Gaji Richworks','2025-05-21 01:29:19','2025-05-21 01:29:19','BigPay Fizi',NULL,NULL),(88,'Purchase','Minum Teh Tarik at Famous Bistro, Taman Pinggiran Putra',2.65,'2025-05-20',1,'Gaji Richworks','2025-05-21 01:32:27','2025-05-21 01:32:27','Maybank 1',NULL,NULL),(89,'Shopee','Beli Pipe Dredger at Shopee, ',34.65,'2025-05-20',1,'Gaji Richworks','2025-05-21 01:49:42','2025-05-21 01:49:42','Maybank 1',NULL,NULL),(90,'Purchase','Makan Makan at Jaya Shopping Center, PJ',27.70,'2025-05-21',1,'Gaji Richworks','2025-05-22 01:16:14','2025-05-22 01:16:14','Maybank 1',NULL,NULL),(91,'Purchase','Beli ingredient mango float at kota raya, kL',80.00,'2025-05-25',1,'Gaji Richworks','2025-05-25 00:39:57','2025-05-25 00:39:57','Maybank 1',NULL,NULL),(92,'Purchase','Makan kuih filipino at kota raya, KL',23.00,'2025-05-25',1,'Gaji Richworks','2025-05-25 00:40:40','2025-05-25 00:40:40','Maybank 1',NULL,NULL),(93,'Purchase','Beli Barang Kuih Yang at Rakan, Seri Kembangan',10.90,'2025-05-22',1,'Gaji Richworks','2025-05-25 00:41:56','2025-05-25 00:41:56','Maybank 1',NULL,NULL),(94,'Purchase','Makan nasi goreng at mamak zeva, Taman Pinggiran Putra',10.70,'2025-05-23',1,'Gaji Richworks','2025-05-25 00:42:46','2025-05-25 00:42:46','Maybank 1',NULL,NULL),(95,'Purchase','Beli mangga at johan durian, Seri Kembangan',20.00,'2025-05-22',1,'Gaji Richworks','2025-05-26 01:46:19','2025-05-26 01:46:19','Cash',NULL,NULL),(96,'My Bills','Sewa Rumah',1350.00,'2025-06-30',0,'Gaji Renoir','2025-05-31 02:55:45','2025-05-31 02:55:45','',NULL,NULL),(104,'My Wife\'s Bills','Bil Hotlink Sayang',43.00,'2025-06-30',1,'Gaji Renoir','2025-05-31 02:55:45','2025-06-06 10:50:50','',NULL,NULL),(107,'My Wife\'s Bills','Sayang Billease',554.75,'2025-06-30',1,'Gaji Renoir','2025-05-31 02:55:45','2025-06-06 10:50:53','','',''),(108,'My Wife\'s Bills','Sayang Grab Paylater',480.28,'2025-06-01',1,'Gaji Renoir','2025-05-31 02:55:45','2025-05-31 03:01:11','Maybank 1','',''),(116,'Subscription','GPL Plugins',8.90,'2025-06-30',0,'Gaji Renoir','2025-05-31 02:55:45','2025-05-31 02:55:45','',NULL,NULL),(117,'Subscription','Namecheap VPS',58.00,'2025-06-30',0,'Gaji Renoir','2025-05-31 02:55:45','2025-06-06 04:07:07','','',''),(118,'Subscription','ChatGPT',43.56,'2025-06-30',0,'Gaji Renoir','2025-05-31 02:55:45','2025-05-31 02:55:45','',NULL,NULL),(122,'Pinjam','Bayar K.Lini 4/14',500.00,'2025-06-01',1,'Gaji Renoir','2025-05-31 02:59:49','2025-05-31 02:59:49','',NULL,NULL),(124,'Grab','Grab 2',210.75,'2025-06-01',1,'Gaji Renoir','2025-06-03 08:22:19','2025-06-03 08:22:19','',NULL,NULL),(126,'Shopee','Beli Wipe phone at Shopee, Taman Pinggiran Putra',10.00,'2025-06-03',1,'Gaji Renoir','2025-06-03 08:26:12','2025-06-03 08:26:12','Maybank 1',NULL,NULL),(207,'Subscription','Disney Plus Hotstar',39.90,'2025-06-04',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 05:58:17','','',''),(208,'Subscription','APPLE.COM/BILL * ITUNES.COM',0.90,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 05:58:29','','',''),(209,'EizMhe Food Business','GLAMPRINT* Hafizi Sticker',44.00,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 05:58:59','','',''),(210,'Grab','SALE DEBIT GRABPAY-EC * PETALING JAYA,',103.00,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 04:54:06','',NULL,NULL),(211,'Grab','SALE DEBIT GRABPAY-EC * PETALING JAYA,',394.00,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 04:54:06','',NULL,NULL),(212,'Grab','SALE DEBIT GRABPAY-EC * PETALING JAYA,',42.00,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 04:54:06','',NULL,NULL),(213,'Shopee','Phone Screen Wiper',10.00,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 04:54:06','',NULL,NULL),(214,'My Bills','TM TECHNOLOGY SERVI* 1007010338',249.75,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 04:54:06','',NULL,NULL),(215,'My Bills','TENAGA NASIONAL BER* 220027881005',370.75,'2025-06-03',1,'Gaji Renoir','2025-06-04 04:54:06','2025-06-04 04:54:06','',NULL,NULL),(217,'Travel','TNG-Ewallet',20.00,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 05:58:46','','',''),(218,'Subscription','Warranty Apple Watch MACHINES-IOI',399.00,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 05:49:11','',NULL,NULL),(219,'Food/Makan-Makan','Minum Kopi SUDO BREW-IOI',46.00,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 05:49:11','',NULL,NULL),(220,'EizMhe Food Business','Hand Mixer DENKI-IOI',105.00,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 05:49:11','',NULL,NULL),(221,'Pinjam','Abah Pinjam',500.00,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 05:49:11','',NULL,NULL),(222,'Purchase','Ariz Books Popular IOI City MA* Putrajaya',45.60,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 06:00:43','','',''),(223,'Food/Makan-Makan','Chicken Rice @ FJ * Putrajaya',12.50,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 05:59:23','','',''),(224,'Food/Makan-Makan','Chicken Rice @ FJ * Putrajaya',43.80,'2025-06-02',1,'Gaji Renoir','2025-06-04 05:49:11','2025-06-04 06:00:09','','',''),(225,'Purchase','Beli Apple Watch Atome* Machines',281.41,'2025-06-02',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(226,'Subscription','Name-Cheap Domain EziMhe.com',49.24,'2025-06-02',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-06 04:06:47','','',''),(227,'My Wife\'s Bills','Atome* J.Labella AT1*',48.87,'2025-06-01',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(228,'My Wife\'s Bills','Atome* J.Labella AT2*',46.33,'2025-06-01',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(229,'My Wife\'s Bills','Atome* Shein1*',76.85,'2025-06-01',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(230,'My Wife\'s Bills','Atome* Watsons1*',51.07,'2025-06-01',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(231,'My Wife\'s Bills','Atome* Watsons2*',35.83,'2025-06-01',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(232,'My Wife\'s Bills','Atome* Watsons3*',33.30,'2025-06-01',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(233,'My Wife\'s Bills','Atome* Shein2*',88.09,'2025-06-01',1,'Gaji Renoir','2025-06-04 06:05:04','2025-06-04 06:05:04','',NULL,NULL),(234,'Purchase','2506012127053033 Duitnow Online',20.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:15:08','2025-06-04 09:15:08','',NULL,NULL),(235,'Groceries','Giant Hyper SRI KEM* Selangor',99.65,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:15:08','2025-06-04 09:15:08','',NULL,NULL),(236,'Groceries','Air Kelapa Pasar Borong SK',12.90,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:15:08','2025-06-04 09:15:08','',NULL,NULL),(237,'EizMhe Food Business','SRI Ternak Mart (SK* S.Kembangan',170.40,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:15:08','2025-06-04 09:15:08','',NULL,NULL),(238,'EizMhe Food Business','Pasaraya Rakan-Skem* Seri Kembangan',40.75,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:15:08','2025-06-04 09:15:08','',NULL,NULL),(239,'My Wife\'s Bills','MBB CT Mohd Hafizi BIN ALI* yang',20.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:15:08','2025-06-04 09:15:08','',NULL,NULL),(240,'Food/Makan-Makan','Duitnow QR Torresbenita Kuih Filipino',28.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:15:08','2025-06-04 09:15:08','',NULL,NULL),(241,'Food/Makan-Makan','QR Estradamarissa Kuih Filipino',48.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(242,'Food/Makan-Makan','Makan kat Mamak Kota Raya',24.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(243,'EizMhe Food Business','MAE QR Filipino Shop Kota Raya',167.50,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(244,'EizMhe Food Business','TuneTalk SimCard MyNews 3Element',5.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(245,'Food/Makan-Makan','Sajian Sedap Nasi Ayam Ariz',7.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(246,'Groceries','99 Speedmart Susu Ariz 1.6L',99.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(247,'Shopee','Shopee Sausage Stuffer',15.83,'2025-05-31',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(248,'Shopee','Shopee Vacuum Sealer',16.32,'2025-05-31',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(249,'Subscription','Name-Cheap.COM* ODZ',49.83,'2025-05-31',1,'Gaji Renoir','2025-06-04 09:28:56','2025-06-04 09:28:56','',NULL,NULL),(250,'Shopee','Shopee Casing Huawei Nova 4e',12.69,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:35:22','2025-06-04 09:35:22','',NULL,NULL),(251,'Travel','Tng-Ewallet Johor',20.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:35:22','2025-06-04 09:35:22','',NULL,NULL),(252,'Travel','Tng-Ewallet Melaka',30.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:35:22','2025-06-04 09:35:22','',NULL,NULL),(253,'Food/Makan-Makan','Restoran Cendol JAM* 70582473',28.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:35:22','2025-06-04 09:35:22','',NULL,NULL),(254,'Food/Makan-Makan','Restoran Cendol JAM* 70539271',24.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:35:22','2025-06-04 09:35:22','',NULL,NULL),(255,'Travel','GrabCar Singapore',35.07,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:35:22','2025-06-04 09:35:22','',NULL,NULL),(256,'Grab','Sale Debit Grab*A-7UAX7VFGXB5A Singapore',30.60,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:44:52','',NULL,NULL),(257,'Grab','GrabCar Rides JB Sentral To Thistle JB',9.20,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:45:01','',NULL,NULL),(258,'Food/Makan-Makan','Beli Air Botol JB Sentral ',13.90,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:45:08','',NULL,NULL),(259,'Food/Makan-Makan','Kuih and Nasi JB Sentral Nonom Foods ',30.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:45:15','',NULL,NULL),(260,'Food/Makan-Makan','Thistle Johor Bahru Nasi Goreng Ariz',18.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:45:22','',NULL,NULL),(261,'Grab','GrabCar*A-7UAX7VFGXB5* Singapore, SGP',30.97,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:45:31','',NULL,NULL),(262,'Grab','GrabCar*A-7U9NT4AGWT6* Singapore, SGP',35.49,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:45:38','',NULL,NULL),(263,'Travel','Bigpay Topup',150.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:43:40','2025-06-04 09:45:46','',NULL,NULL),(264,'Travel','GrabCar Pergi JB Sentral From Thistle',2.20,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:52:36','2025-06-04 09:52:36','',NULL,NULL),(265,'Food/Makan-Makan','Makan at Hardrock Cafe-PuteriHarbour',174.50,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:52:36','2025-06-04 09:52:36','',NULL,NULL),(266,'Food/Makan-Makan','Beli Kuih2 di RnR Ayer Keroh',34.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:52:36','2025-06-04 09:52:36','',NULL,NULL),(267,'My Wife\'s Bills','MBB CT Mohd Hafizi BIN ALI\' Yang',300.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:52:36','2025-06-04 09:52:36','',NULL,NULL),(268,'Food/Makan-Makan','Makan Kfc-OHB RnR Ayer Keroh',53.45,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:52:36','2025-06-04 09:52:36','',NULL,NULL),(269,'Food/Makan-Makan','Makan Nasi Restoran Megat RnR Ayer Keroh',16.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:52:36','2025-06-04 09:52:36','',NULL,NULL),(270,'Travel','TNG E-Wallet Topup Pergi JB',50.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 09:52:36','2025-06-04 09:52:36','',NULL,NULL),(271,'Grab','Grabpay-EC* Petaling Jaya',210.75,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:00:01','2025-06-04 10:01:06','',NULL,NULL),(272,'Travel','Isi Minyak Shell-Bandar Pinggiran Putra',60.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:00:01','2025-06-04 10:01:15','',NULL,NULL),(273,'Food/Makan-Makan','Duitnow QR saleemkochikkandy * 74336169',21.50,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:00:01','2025-06-04 10:01:24','',NULL,NULL),(274,'Purchase','Cash Withdrawal',201.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:00:01','2025-06-04 10:01:35','',NULL,NULL),(275,'Travel','Booking Agoda.COM Thistle JB',594.42,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:00:01','2025-06-04 10:01:44','',NULL,NULL),(276,'Purchase','Tng-Ewallet Topup ',20.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:00:01','2025-06-04 10:01:51','',NULL,NULL),(277,'Purchase','Beli Wise Card',13.70,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:00:01','2025-06-04 10:01:58','',NULL,NULL),(278,'Travel','Tng-Ewallet Topup',60.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:07:07','2025-06-04 10:07:48','',NULL,NULL),(279,'Groceries','99 Speedmart-Susu Ariz 1 Paket',36.10,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:07:07','2025-06-04 10:07:55','',NULL,NULL),(280,'Travel','Isi Minyak Shell-Persiaran Kewajipan',50.00,'2025-06-01',1,'Gaji Renoir','2025-06-04 10:07:07','2025-06-04 10:08:03','',NULL,NULL),(281,'Food/Makan-Makan','Beli Delivery Nasi Goreng Mamak Zeva',6.50,'2025-06-04',1,'Gaji Renoir','2025-06-04 10:12:18','2025-06-04 10:12:18','',NULL,NULL),(282,'Food/Makan-Makan','Beli Kopi dan Popcorn Mamak Mahamoodangillath',11.20,'2025-06-04',1,'Gaji Renoir','2025-06-04 10:12:18','2025-06-04 10:12:18','',NULL,NULL),(283,'Groceries','Beli Groceries at 99 Speedmart-1756*Selangor',64.70,'2025-06-04',1,'Gaji Renoir','2025-06-04 10:12:18','2025-06-04 10:12:18','',NULL,NULL),(284,'Shopee','Beli Food Vacuum Bag at Shopee',35.40,'2025-06-05',1,'Gaji Renoir','2025-06-05 07:20:58','2025-06-05 07:22:13','Maybank 1','',''),(285,'EizMhe Food Business','Beli Bawang Putih at Kedai Zeva',12.80,'2025-06-04',1,'Gaji Renoir','2025-06-05 07:20:58','2025-06-05 07:22:00','Maybank 1','',''),(286,'Food/Makan-Makan','Beli Nasi Goreng Ariz at Mamak Zeva',6.50,'2025-06-04',1,'Gaji Renoir','2025-06-05 07:20:58','2025-06-05 07:21:35','Maybank 1','',''),(287,'Purchase','Beli Mangga at jeff durian, Taman Pinggiran Putra',20.00,'2025-06-05',1,'Gaji Richworks','2025-06-06 00:39:30','2025-06-06 00:39:30','Cash',NULL,NULL),(293,'My Wife\'s Bills','Sayang GCash 1',315.00,'2025-06-06',1,'Gaji Renoir','2025-06-06 10:47:35','2025-06-06 10:51:03','Maybank 1',NULL,NULL),(294,'My Wife\'s Bills','Groceries',350.00,'2025-06-06',1,'Gaji Renoir','2025-06-06 10:48:29','2025-06-06 10:51:10','Maybank 1',NULL,NULL),(295,'My Wife\'s Bills','Apple iCloud',44.90,'2025-06-06',1,'Gaji Renoir','2025-06-06 10:48:54','2025-06-06 10:51:13','Maybank 1',NULL,NULL),(296,'My Wife\'s Bills','Hutang Lyn',332.00,'2025-06-06',1,'Gaji Renoir','2025-06-06 10:49:13','2025-06-06 10:51:17','Maybank 1',NULL,NULL),(297,'My Wife\'s Bills','Sayang GCash 2',200.00,'2025-06-06',0,'','2025-06-06 10:49:47','2025-06-06 10:49:47','Maybank 1',NULL,NULL),(298,'Purchase','Short',652.65,'2025-06-06',1,'Gaji Renoir','2025-06-06 10:53:26','2025-06-06 10:53:26','Maybank 1',NULL,NULL),(299,'Travel','Tng-Ewallet Topup Pegi Umah MakLong',20.00,'2025-06-07',1,'Gaji Renoir','2025-06-09 01:16:40','2025-06-09 01:16:40','',NULL,NULL),(300,'Travel','Isi Minyak Shell - Pegi Umah MakLong',70.00,'2025-06-07',1,'Gaji Renoir','2025-06-09 01:16:40','2025-06-09 01:16:40','',NULL,NULL),(302,'Emergency','Repair Sinki Dapur',0.00,'2025-07-01',0,'not_paid','2025-06-30 01:37:13','2025-07-06 04:26:24','','',''),(303,'Emergency','Vaksin Ariz',0.00,'2025-07-01',0,'not_paid','2025-06-30 01:37:47','2025-07-06 04:26:22','','',''),(304,'Grab','Grab Agoda 1',211.00,'2025-07-01',1,'Gaji Renoir','2025-06-30 02:08:49','2025-07-02 04:51:28','','',''),(305,'My Bills','Sewa Rumah',1350.00,'2025-07-02',0,'Gaji Renoir','2025-07-02 03:03:01','2025-07-02 03:03:01','',NULL,NULL),(312,'My Bills','Bil Elektrik TnB (220027881005)',937.55,'2025-08-29',0,'Gaji Renoir','2025-07-02 03:03:01','2025-09-03 05:55:24','',NULL,NULL),(313,'My Wife\'s Bills','Bil Hotlink Sayang',45.00,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-06 02:10:49','','',''),(315,'My Wife\'s Bills','Sayang Atome',80.88,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-06 02:23:38','','',''),(316,'My Wife\'s Bills','Sayang Billease',661.98,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-06 02:23:36','','',''),(317,'My Wife\'s Bills','Sayang Grab Paylater',177.00,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-06 02:23:32','','',''),(318,'My Wife\'s Bills','Sayang GCash',504.20,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-06 02:19:54','','',''),(319,'My Wife\'s Bills','Apple iCloud',44.90,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-06 02:19:51','',NULL,NULL),(327,'Subscription','GPL Plugins',8.40,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-06 02:42:06','','',''),(328,'Subscription','Namecheap VPS',55.03,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-04 01:51:25','','',''),(330,'Subscription','Disney Plus Hotstar',39.90,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-04 01:38:17','',NULL,NULL),(331,'Subscription','Copilot',42.91,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-02 09:01:06','Maybank 2','',''),(332,'Pinjam','Bayar Kak Lini 5/14',500.00,'2025-07-02',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-02 09:07:42','','',''),(333,'Purchase','Susu Ariz',205.80,'2025-07-01',1,'Gaji Renoir','2025-07-02 03:03:01','2025-07-02 08:25:00','',NULL,NULL),(337,'Food/Makan-Makan','Order Mamak Zeva',13.50,'2025-07-01',1,'Gaji Renoir','2025-07-02 03:42:48','2025-07-02 03:42:48','',NULL,NULL),(339,'Emergency','RoadTax Renewal WWV2585',904.47,'2025-07-01',1,'Gaji Renoir','2025-07-02 03:42:48','2025-07-02 03:42:48','',NULL,NULL),(349,'EizMhe Food Business','Topup Tune Talk EizMhe Food',30.00,'2025-07-01',1,'Gaji Renoir','2025-07-02 04:49:37','2025-07-02 04:49:37','',NULL,NULL),(350,'Subscription','Github Copilot Deposit USD1',4.32,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:12:27','2025-07-02 08:12:27','',NULL,NULL),(351,'My Wife\'s Bills','Transfer to Tng-Ewallet',100.00,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:12:27','2025-07-02 08:12:27','',NULL,NULL),(352,'My Wife\'s Bills','Transfer to Grabpay',50.00,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:12:27','2025-07-02 08:12:27','',NULL,NULL),(353,'EizMhe Food Business','Print Sticker Eizmhe Shopee',20.00,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:12:27','2025-07-02 08:12:27','',NULL,NULL),(354,'EizMhe Food Business','Hootsuite Shopee',8.99,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:12:27','2025-07-02 08:12:27','',NULL,NULL),(355,'My Wife\'s Bills','Atome* Machines',281.41,'2025-07-02',1,'Gaji Renoir','2025-07-02 08:20:02','2025-07-02 08:20:02','',NULL,NULL),(356,'EizMhe Food Business','Mydebit Pasaraya Rakan-Sk',52.85,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:20:02','2025-07-02 08:20:02','',NULL,NULL),(357,'Groceries','Mydebit Giant Hyper',179.00,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:20:02','2025-07-02 08:20:02','',NULL,NULL),(358,'Purchase','Sale Debit Tng-E-Wallet',20.00,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:20:02','2025-07-02 08:20:02','',NULL,NULL),(359,'Food/Makan-Makan','QR PAY Sales Richeese Factory',57.45,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:20:02','2025-07-02 08:20:02','',NULL,NULL),(360,'Food/Makan-Makan','Kopi and Popcorn QR saleemkochikandy',14.50,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:20:02','2025-07-02 08:20:02','',NULL,NULL),(362,'Purchase','Tukar Kad Zeva JMB',35.00,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:20:02','2025-07-02 08:20:02','',NULL,NULL),(364,'Food/Makan-Makan','Order Mamak Zeva 1Jul2025',30.50,'2025-07-01',1,'Gaji Renoir','2025-07-02 08:25:00','2025-07-02 08:25:00','',NULL,NULL),(365,'Grab','Payment Grabpay-Maybe Johor Thistle',41.00,'2025-07-02',1,'Gaji Renoir','2025-07-02 08:40:11','2025-07-02 08:40:11','',NULL,NULL),(366,'My Wife\'s Bills','Atome* Watsons',35.80,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:11:05','2025-07-04 01:11:05','',NULL,NULL),(367,'My Wife\'s Bills','Atome* Shein',88.09,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:11:05','2025-07-04 01:11:05','',NULL,NULL),(368,'Food/Makan-Makan','QR Restoran Jamal Moha',13.00,'2025-07-02',1,'Gaji Renoir','2025-07-04 01:11:05','2025-07-04 01:11:05','',NULL,NULL),(369,'Pinjam','Repair Aircon Kereta Abah',100.00,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(370,'Food/Makan-Makan','Dapur Yongs Food Valet 2',45.80,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(371,'Food/Makan-Makan','QR Apipizza Food Valet',25.00,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(372,'Food/Makan-Makan','Dapur Yongs Food Valet 1',10.90,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(373,'Food/Makan-Makan','QR Daripiah Food Valet',8.00,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(374,'Food/Makan-Makan','Drink Food Valet 2',4.00,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(375,'Food/Makan-Makan','Drink Food Valet 1',11.50,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(376,'Food/Makan-Makan','Chicken Rice Food Valet',9.00,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:16:27','2025-07-04 01:16:27','',NULL,NULL),(377,'Travel','Bayar Isi Minyak Shell',70.00,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:18:33','2025-07-04 01:18:33','Maybank 1',NULL,NULL),(378,'Groceries','Beli Groceries AEON Big Alamanda',141.85,'2025-07-03',1,'Gaji Renoir','2025-07-04 01:22:55','2025-07-04 01:22:55','',NULL,NULL),(379,'Subscription','Renew Domain FiziCapoeira.com',73.22,'2025-07-04',1,'Gaji Renoir','2025-07-04 04:11:06','2025-07-06 02:40:25','','',''),(380,'My Wife\'s Bills','Atome JLabella',25.25,'2025-07-06',1,'Gaji Renoir','2025-07-06 02:04:57','2025-07-06 02:05:09','',NULL,NULL),(381,'My Wife\'s Bills','Coby Expenses',70.00,'2025-07-06',1,'Gaji Renoir','2025-07-06 02:09:42','2025-07-06 02:19:48','','',''),(382,'Food/Makan-Makan','Beli Air Laici',2.90,'2025-07-05',1,'Gaji Renoir','2025-07-06 02:41:26','2025-07-06 02:41:31','',NULL,NULL),(383,'Travel','Topup TnG 1',20.00,'2025-07-04',1,'Gaji Renoir','2025-07-06 02:43:53','2025-07-06 02:43:59','',NULL,NULL),(384,'My Bills','Sewa Rumah',1350.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(385,'My Bills','Mazda (Public Bank)',535.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(386,'My Bills','RHB Repayment',150.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(387,'My Bills','Bil Internet Unifi TM',249.75,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(388,'My Bills','Bil Air ZevaJMB',35.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(389,'My Bills','Bil Astro',97.20,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(390,'My Bills','Bil Maxis Fizi',357.30,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(392,'My Wife\'s Bills','Bil Hotlink Sayang',43.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(393,'My Wife\'s Bills','Sayang Duit Extra',0.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(394,'My Wife\'s Bills','Sayang Atome',148.76,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(395,'My Wife\'s Bills','Sayang Billease',1065.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(396,'My Wife\'s Bills','Sayang Grab Paylater',73.89,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(397,'My Wife\'s Bills','Sayang GCash',315.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(398,'My Wife\'s Bills','Apple iCloud',44.90,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(399,'Grab','Grab Membership',4.90,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(400,'Grab','Grab Paylater',374.02,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(401,'Grab','Grab Agoda Johor',102.87,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(402,'Subscription','Believe Fitness',129.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(403,'Subscription','Academia',150.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(405,'Subscription','Youtube Premium',20.90,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(406,'Subscription','GPL Plugins',8.90,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(407,'Subscription','Namecheap VPS',58.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(408,'Subscription','ChatGPT',43.56,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(409,'Subscription','Disney Plus Hotstar',39.90,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(410,'Subscription','Copilot',42.91,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(411,'Pinjam','Bayar Kak Lini 6/14',500.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:39','','',''),(412,'Purchase','Susu Ariz',58.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(413,'Purchase','Diapers Ariz',26.00,'2025-08-05',0,'Gaji Renoir','2025-08-05 04:05:15','2025-08-05 04:05:15','',NULL,NULL),(414,'Travel','Payment VIA Mydebit Shell - Puteri Puch Selangor',60.00,'2025-07-31',1,'Gaji Renoir','2025-08-05 04:33:27','2025-08-05 04:33:27','',NULL,NULL),(415,'Food/Makan-Makan','Payment VIA Mydebit Naughty Root Puchong',111.85,'2025-07-31',1,'Gaji Renoir','2025-08-05 04:33:27','2025-08-05 04:33:27','',NULL,NULL),(416,'Pinjam','Bayar Kak Lini x/14',500.00,'2025-07-31',1,'Gaji Renoir','2025-08-05 04:33:27','2025-08-05 04:33:27','',NULL,NULL),(417,'Travel','Sale Debit Tng-Ewallet Ecom 3 Kuala Lumpur',20.00,'2025-07-31',1,'Gaji Renoir','2025-08-05 04:33:27','2025-08-05 04:33:27','',NULL,NULL),(418,'Grab','Sale Debit Grabpay-EC Petaling Jaya',221.00,'2025-07-31',1,'Gaji Renoir','2025-08-05 04:33:27','2025-08-05 04:33:27','',NULL,NULL),(423,'Pinjam','Hefisalini Binti AL Bayar K.Lini 6',500.00,'2025-07-31',1,'Gaji Renoir','2025-08-05 05:06:39','2025-08-05 05:06:39','',NULL,NULL),(424,'My Bills','Sewa Rumah',1400.00,'2025-09-02',0,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 09:56:16','','',''),(425,'My Bills','Mazda (Public Bank)',535.00,'2025-09-02',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 07:11:42','',NULL,NULL),(426,'My Bills','RHB Repayment',150.00,'2025-09-01',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 06:52:40','',NULL,NULL),(427,'My Bills','Bil Internet Unifi TM',249.75,'2025-09-02',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 07:09:28','',NULL,NULL),(428,'My Bills','Bil Air ZevaJMB',0.00,'2025-09-02',0,'Gaji Renoir','2025-09-02 07:11:16','2025-09-08 05:59:57','','',''),(429,'My Bills','Bil Astro',97.20,'2025-09-01',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 06:37:35','',NULL,NULL),(430,'My Bills','Bil Maxis Fizi',318.10,'2025-09-02',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 07:16:18','','',''),(439,'Grab','Grab Membership',4.90,'2025-09-03',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 07:09:28','',NULL,NULL),(440,'Grab','Grab Paylater',601.00,'2025-09-02',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 07:09:28','',NULL,NULL),(442,'Subscription','Believe Fitness',129.00,'2025-09-01',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 06:37:35','',NULL,NULL),(443,'Subscription','Academia',150.00,'2025-09-02',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-04 08:43:57','Maybank 1','',''),(445,'Subscription','Youtube Premium',20.90,'2025-09-01',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-03 06:52:40','',NULL,NULL),(446,'Subscription','GPL Plugins',8.90,'2025-09-02',0,'Gaji Renoir','2025-09-02 07:11:16','2025-09-02 07:11:16','',NULL,NULL),(447,'Subscription','Namecheap VPS',54.37,'2025-09-13',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-16 10:23:25','Maybank 1','',''),(449,'Subscription','Disney Plus Hotstar',39.90,'2025-09-02',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-04 02:01:58','Maybank 1','',''),(450,'Subscription','Copilot',42.93,'2025-09-02',1,'Gaji Renoir','2025-09-02 07:11:16','2025-09-07 08:25:41','Maybank 1','',''),(461,'Food/Makan-Makan','MAE QR Muhammad Faiz Izzan* 665936462Q',65.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(462,'My Wife\'s Bills','Sale Debit Atome* Machines* Kuala Lumpur,',281.41,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(463,'Food/Makan-Makan','Sale Debit PSS Senawang-Paroi* N.Sembilan, MY',13.30,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(464,'Travel','Sale Debit Tng-Ewallet Ecom*2* Kuala Lumpur,',20.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(465,'Groceries','Payment VIA Mydebit 99 Speedmart-1197* Selangor',143.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(466,'Food/Makan-Makan','Payment VIA Mydebit Famous Bistro Cafe* Seri Kembanga',12.30,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(467,'Subscription','Netflix',75.90,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 09:24:41','',NULL,NULL),(468,'Food/Makan-Makan','Payment VIA Mydebit Kenny Hills IOI CIT* Putrajaya',127.60,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(469,'My Bills','Bil Elektrik TnB (220027881005)',937.55,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:28:28','2025-09-03 06:28:28','',NULL,NULL),(470,'My Wife\'s Bills','MBB CT Mohd Hafizi BIN ALI* yang',50.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(471,'My Wife\'s Bills','Sale Debit Atome* Shein * Kuala Lumpur,',71.72,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(472,'Food/Makan-Makan','Duitnow QR Ahmad Soleh BIN YUS* QR70885343',45.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(473,'Food/Makan-Makan','Duitnow QR Sultansalai* QR70813852',4.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(474,'Food/Makan-Makan','690190081Q MBBQR16225212* 111125202201697',4.50,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(475,'Food/Makan-Makan','Duitnow QR Sultansalai* QR87071435',42.50,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(476,'Food/Makan-Makan','Payment VIA Mydebit 5184-Freeport Afamo* Melaka',12.20,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(477,'My Wife\'s Bills','MBB CT Mohd Hafizi BIN ALI* yang',100.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:37:35','2025-09-03 06:37:35','',NULL,NULL),(478,'My Bills','MBB CT NGE Choong Seng * Hafizi BR-05-07',575.00,'2025-09-02',1,'Gaji Renoir','2025-09-03 06:52:40','2025-09-03 06:52:40','',NULL,NULL),(479,'EizMhe Food Business','Duitnow QR Zeva Garden Cafe * QR73429631',8.00,'2025-09-02',1,'Gaji Renoir','2025-09-03 06:52:40','2025-09-03 06:52:40','',NULL,NULL),(480,'Pinjam','Mohd Hafizuddin BIN* Bayar Pinjam Kak Yantie',398.00,'2025-09-02',1,'Gaji Renoir','2025-09-03 06:52:40','2025-09-03 06:52:40','',NULL,NULL),(481,'Food/Makan-Makan','Sale Debit Baskin Robbins-IOI2* IOI Resort CT,',24.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:52:40','2025-09-03 06:52:40','',NULL,NULL),(482,'Food/Makan-Makan','Payment VIA Mydebit Corner FNB SDN BHD* Putrajaya',12.80,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:52:40','2025-09-03 06:52:40','',NULL,NULL),(483,'Groceries','Sale Debit Watson\'S Mytown (M5* Kuala Lumpur,',35.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:52:40','2025-09-03 06:52:40','',NULL,NULL),(484,'Food/Makan-Makan','250901143413047 3095776821* Nando\'S Chicke',86.00,'2025-09-01',1,'Gaji Renoir','2025-09-03 06:52:40','2025-09-03 06:52:40','',NULL,NULL),(485,'Shopee','Sale Debit Shopee Malaysia * Kuala Lumpur,',15.00,'2025-09-03',1,'Gaji Renoir','2025-09-03 07:09:28','2025-09-03 07:09:28','',NULL,NULL),(486,'My Wife\'s Bills','MBB CT Mohd Hafizi BIN ALI* yang',2300.00,'2025-09-02',1,'Gaji Renoir','2025-09-03 07:09:28','2025-09-03 07:09:28','',NULL,NULL),(487,'Shopee','Sale Debit Shopee Malaysia * Kuala Lumpur,',9.99,'2025-09-02',1,'Gaji Renoir','2025-09-03 07:09:28','2025-09-03 07:09:28','',NULL,NULL),(488,'Shopee','Sale Debit Shopee Malaysia * Kuala Lumpur,',8.90,'2025-09-02',1,'Gaji Renoir','2025-09-03 07:09:28','2025-09-03 07:09:28','',NULL,NULL),(489,'Shopee','Sale Debit Shopee Malaysia * Kuala Lumpur,',13.90,'2025-09-02',1,'Gaji Renoir','2025-09-03 07:09:28','2025-09-03 07:09:28','',NULL,NULL),(490,'Grab','Beli Domino\'s Pizza on Grab',128.64,'2025-09-02',1,'Gaji Renoir','2025-09-03 07:09:28','2025-09-03 07:20:10','','',''),(491,'Pinjam','Bayar Kak Lini 7/14',500.00,'2025-09-02',1,'Gaji Renoir','2025-09-03 07:09:28','2025-09-03 07:31:37','','',''),(493,'Emergency','Repair Sinki',300.00,'2025-09-03',1,'Gaji Renoir','2025-09-03 10:43:10','2025-09-05 03:32:51','Maybank 1','',''),(495,'Food/Makan-Makan','Beli Pisang at Kedai Tepi Jalan, Petaling Jaya',2.28,'2025-09-03',1,'Gaji Renoir','2025-09-03 11:58:18','2025-09-03 11:58:18','Maybank 1',NULL,NULL),(496,'Food/Makan-Makan','Beli Sup Daging at Mamak Zeva, ',8.00,'2025-09-04',1,'Gaji Richworks','2025-09-04 02:18:21','2025-09-04 02:18:21','Maybank 1',NULL,NULL),(497,'Emergency','Bayar Deposit Repair Sinki at Hadi Technician Zeva, ',50.00,'2025-09-04',1,'Gaji Richworks','2025-09-04 02:24:14','2025-09-04 02:24:14','Maybank 1',NULL,NULL),(498,'Shopee','Beli TrueCaller at Shopee, ',2.50,'2025-09-04',1,'Gaji Richworks','2025-09-04 07:43:53','2025-09-04 07:43:53','Maybank 1',NULL,NULL),(499,'Travel','Bayar Isi Minyak at Petronas, Taman Pinggiran Putra',50.00,'2025-09-05',1,'Gaji Richworks','2025-09-05 03:34:21','2025-09-05 03:34:21','Maybank 1',NULL,NULL),(501,'Food/Makan-Makan','Beli Sup Daging at Mamak Zeva, ',8.00,'2025-09-06',1,'Gaji Richworks','2025-09-06 13:24:48','2025-09-06 13:24:48','Maybank 1',NULL,NULL),(502,'Travel','Bayar Topup TnG',20.00,'2025-09-08',1,'Gaji Richworks','2025-09-09 07:10:07','2025-09-09 07:10:07','Maybank 1',NULL,NULL),(503,'Shopee','Beli Screaming Frog at Shopee, ',9.90,'2025-09-10',1,'Gaji Richworks','2025-09-10 02:57:33','2025-09-10 02:57:33','Maybank 1',NULL,NULL),(504,'Food/Makan-Makan','Beli Nasi Goreng Cina For Ariz at Mamak Zeva, ',6.50,'2025-09-11',1,'Gaji Richworks','2025-09-11 05:19:07','2025-09-11 05:19:07','Maybank 1',NULL,NULL),(505,'Food/Makan-Makan','Mydebit The Chicken Rice Shop IOI City Mall',28.75,'2025-09-11',1,'Gaji Richworks','2025-09-13 00:59:45','2025-09-13 01:00:26','Maybank 1','',''),(506,'Food/Makan-Makan','Jardin Coffee&Tea-I* Putrajaya, MYS',41.00,'2025-09-11',1,'Gaji Richworks','2025-09-13 00:59:45','2025-09-13 01:00:34','Maybank 1','',''),(507,'Food/Makan-Makan','Mydebit BananaBro * Putrajaya',76.35,'2025-09-11',1,'Gaji Richworks','2025-09-13 00:59:45','2025-09-13 01:00:47','Maybank 1','',''),(508,'Shopee','Shopee: Pslalae Magnesium Bisglycinate 120',14.91,'2025-09-16',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:30:21','Maybank 1','',''),(509,'Food/Makan-Makan','Duitnow QR Zeva Garden Cafe * QR83604453',20.70,'2025-09-15',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:30:10','Maybank 1','',''),(510,'Food/Makan-Makan','Sale Debit Mcdonalds-Putrajaya* Putrajaya, MYS',36.15,'2025-09-14',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:30:04','Maybank 1','',''),(511,'Food/Makan-Makan','Chicken rice Shop-IOI City Mall * Putrajaya',37.75,'2025-09-14',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:29:59','Maybank 1','',''),(512,'Food/Makan-Makan','QR PAY Sales Rotiboy RnR AB * T0390599762525',14.00,'2025-09-13',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:29:54','Maybank 1','',''),(513,'Food/Makan-Makan','Mydebit Sate Kajang Awan BE* Subang Jaya',37.40,'2025-09-13',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:29:49','Maybank 1','',''),(514,'Travel','Sale Debit Tng-Ewallet Ecom 2* Kuala Lumpur,',20.00,'2025-09-13',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:30:32','Maybank 1','',''),(515,'Travel','Pre-Auth Mydebit Shell - Kesas Awan * Kuala Lumpur',40.00,'2025-09-13',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:30:28','Maybank 1','',''),(516,'Food/Makan-Makan','QR PAY Sales Rotiboy RnR AB * T039070879625',10.10,'2025-09-13',1,'Gaji Renoir','2025-09-16 10:29:12','2025-09-16 10:29:44','Maybank 1','','');
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `income`
--

DROP TABLE IF EXISTS `income`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `income` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `item` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `income`
--

LOCK TABLES `income` WRITE;
/*!40000 ALTER TABLE `income` DISABLE KEYS */;
INSERT INTO `income` VALUES (1,'Gaji Tetap','Gaji Renoir',7203.44,'2025-05-01','2025-05-01 03:05:14','2025-05-01 03:05:14'),(2,'Website Projects','Gaji Richworks',3000.00,'2025-05-01','2025-05-01 03:05:39','2025-05-11 09:52:16'),(3,'Recurring Revenue','KWSP',0.00,'2025-05-11','2025-05-11 07:51:55','2025-05-11 08:28:47'),(4,'Gaji Tetap','Gaji Renoir',7203.44,'2025-06-30','2025-05-31 02:56:08','2025-05-31 02:56:08'),(5,'Website Projects','Gaji Richworks',3000.00,'2025-06-30','2025-05-31 02:56:08','2025-05-31 02:56:08'),(6,'Recurring Revenue','KWSP',0.00,'2025-06-30','2025-05-31 02:56:08','2025-05-31 02:56:08'),(7,'Website Projects','Payment Yayasan Eskayvie',1500.00,'2025-06-01','2025-05-31 03:02:26','2025-05-31 03:02:26'),(8,'Returns/Refunds','Pre-Auth Refund Name-Cheap.COM',49.83,'2025-06-02','2025-06-04 06:05:04','2025-06-04 06:05:04'),(9,'Returns/Refunds','Pre-Auth Refund GrabCar Singapore',35.49,'2025-06-01','2025-06-04 09:35:22','2025-06-04 09:35:22'),(10,'Returns/Refunds','Pre-Auth Refund Grab*A-7UAX7VFGXB5A Singapore',30.97,'2025-05-30','2025-06-04 09:43:40','2025-06-04 09:43:40'),(11,'Returns/Refunds','Sayang transfer duit minyak',70.00,'2025-06-07','2025-06-09 01:14:06','2025-06-09 01:14:06'),(12,'Gaji Tetap','Gaji Renoir',7203.44,'2025-07-02','2025-07-02 01:25:36','2025-07-02 01:25:36'),(13,'Website Projects','Gaji Richworks',3000.00,'2025-07-02','2025-07-02 01:25:36','2025-07-02 01:25:36'),(14,'Recurring Revenue','KWSP',0.00,'2025-07-02','2025-07-02 01:25:36','2025-07-02 01:25:36'),(16,'Investment Returns','Profit Paid',1.93,'2025-07-01','2025-07-02 03:50:03','2025-07-02 03:50:03'),(17,'Gaji Tetap','Gaji Renoir',7203.44,'2025-08-05','2025-08-05 04:04:48','2025-08-05 04:04:48'),(18,'Website Projects','Gaji Richworks',3000.00,'2025-08-05','2025-08-05 04:04:48','2025-08-05 04:04:48'),(19,'Recurring Revenue','KWSP',0.00,'2025-08-05','2025-08-05 04:04:48','2025-08-05 04:04:48'),(21,'Gaji Tetap','Gaji Renoir',7203.44,'2025-09-02','2025-09-02 07:10:19','2025-09-06 13:38:16'),(22,'Website Projects','Gaji Richworks',3000.00,'2025-09-02','2025-09-02 07:10:19','2025-09-02 07:10:19'),(23,'Recurring Revenue','KWSP',207.00,'2025-09-06','2025-09-02 07:10:19','2025-09-06 13:37:41'),(24,'Recurring Revenue','Balance From Saving Last Month',136.12,'2025-09-03','2025-09-03 09:41:15','2025-09-03 09:41:15'),(26,'Others','Pinjam Billease',400.00,'2025-09-11','2025-09-11 05:20:28','2025-09-11 05:20:28');
/*!40000 ALTER TABLE `income` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `outreach`
--

DROP TABLE IF EXISTS `outreach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `outreach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `category` varchar(100) NOT NULL,
  `notes` text DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Pending',
  `date` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outreach`
--

LOCK TABLES `outreach` WRITE;
/*!40000 ALTER TABLE `outreach` DISABLE KEYS */;
INSERT INTO `outreach` VALUES (1,'Send Proposal To Build Website for Yayasan Eskayvie','Email','Website Projects','','Sent','2025-05-11','2025-05-11 05:22:48'),(2,'Send Proposal To Build Website for Nitruwell.com','Meeting','Website Projects','','Sent','2025-05-12','2025-05-12 06:39:35'),(3,'Sent Outreach To MSU For Capoeira Class','Meeting','Capoeira Projects','','Pending','2025-05-21','2025-05-21 01:45:49'),(4,'Send Proposal To MSU For Capoeira Class','Meeting','Capoeira Projects','','Pending','2025-06-06','2025-06-06 05:35:38'),(5,'Send Plan To Richworks For Richworks Academy Website','Call','Website Projects','','Pending','2025-06-06','2025-06-06 05:36:27'),(6,'Send Proposal To Build Wikipedia Page for Eskayvie','Call','Website Projects','','Pending','2025-06-06','2025-06-06 05:37:29');
/*!40000 ALTER TABLE `outreach` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(255) NOT NULL,
  `setting_value` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'default_income_source','Gaji Renoir','2025-05-01 04:43:14','2025-05-01 04:43:14'),(2,'theme','futuristic','2025-05-01 04:43:14','2025-05-12 12:24:28'),(3,'app_title','ThinkCorp','2025-05-01 07:13:08','2025-05-01 08:11:46'),(4,'platform_title','ThinkCorp','2025-05-11 07:08:51','2025-06-30 01:44:18'),(5,'deploy_live_url','https://imac.com.my/cashflow/','2025-09-03 07:48:00','2025-09-03 07:48:00'),(6,'deploy_ftp_host','203.161.57.233','2025-09-03 07:48:00','2025-09-03 07:59:15'),(7,'deploy_ftp_user','cashflowadmin_infoblogsite.com','2025-09-03 07:48:00','2025-09-03 07:59:58'),(8,'deploy_target_dir','.','2025-09-03 07:48:00','2025-09-03 08:21:53'),(9,'deploy_include_uploads','1','2025-09-03 07:48:00','2025-09-03 07:48:00'),(10,'deploy_ftp_pass','7$kMijWKve','2025-09-03 07:48:00','2025-09-03 07:48:00'),(11,'deploy_secret_key','6253fd2d266289187beaf2289dc7ef46','2025-09-03 07:48:00','2025-09-03 07:48:00'),(12,'deploy_ftp_port','21','2025-09-03 07:58:53','2025-09-03 07:58:53'),(13,'deploy_clean_before','1','2025-09-03 08:36:26','2025-09-03 08:36:26');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transfers`
--

DROP TABLE IF EXISTS `transfers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transfers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `from_bank` varchar(100) DEFAULT NULL,
  `to_bank` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transfers`
--

LOCK TABLES `transfers` WRITE;
/*!40000 ALTER TABLE `transfers` DISABLE KEYS */;
INSERT INTO `transfers` VALUES (1,'2025-07-01','Mohd Hafizi BIN ALI* fizi',-1400.00,'My Bills','Expense','Maybank 1','Maybank 2');
/*!40000 ALTER TABLE `transfers` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-09-16 10:32:52
