--
-- Host: 127.0.0.1    Database: spgb
-- ------------------------------------------------------


--
-- Current Database: `spgb`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `spgb` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `spgb`;

--
-- Table structure for table `academic_years`
--

CREATE TABLE `academic_years` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `is_current` tinyint(1) NOT NULL DEFAULT '0',
  `school_id` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `academic_years_school_id_foreign` (`school_id`),
  CONSTRAINT `academic_years_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `academic_years`
--

INSERT INTO `academic_years` VALUES (1,'2025/2026','2025-03-01','2026-02-28',1,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40');

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_id` bigint unsigned DEFAULT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_id` bigint unsigned DEFAULT NULL,
  `attribute_changes` json DEFAULT NULL,
  `properties` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject_type`,`subject_id`),
  KEY `causer` (`causer_type`,`causer_id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_log`
--

INSERT INTO `activity_log` VALUES (1,'default','created','App\\Models\\DailyMonitoring',1,'created','App\\Models\\User',1,'{\"attributes\": {\"date\": \"2026-06-25T00:00:00.000000Z\", \"status\": \"draft\", \"day_name\": \"Khamis\"}}','[]','2026-06-25 04:53:21','2026-06-25 04:53:21'),(2,'default','updated','App\\Models\\DailyMonitoring',1,'updated','App\\Models\\User',1,'{\"old\": {\"status\": \"draft\"}, \"attributes\": {\"status\": \"submitted\"}}','[]','2026-06-25 05:10:36','2026-06-25 05:10:36'),(3,'default','created','App\\Models\\DailyMonitoring',2,'created','App\\Models\\User',1,'{\"attributes\": {\"date\": \"2026-06-27T00:00:00.000000Z\", \"status\": \"draft\", \"day_name\": \"Sabtu\"}}','[]','2026-06-27 07:04:09','2026-06-27 07:04:09'),(4,'default','updated','App\\Models\\School',1,'updated','App\\Models\\User',1,'{\"old\": {\"code\": \"SK001\", \"name\": \"SK Taman Seri Gombak\"}, \"attributes\": {\"code\": \"SKBP\", \"name\": \"Sekolah Kebangsaan Bukit Panau\"}}','[]','2026-06-27 07:21:31','2026-06-27 07:21:31'),(5,'default','created','App\\Models\\DailyMonitoring',3,'created','App\\Models\\User',1,'{\"attributes\": {\"date\": \"2026-06-27T00:00:00.000000Z\", \"status\": \"draft\", \"day_name\": \"Sabtu\"}}','[]','2026-06-27 07:32:43','2026-06-27 07:32:43'),(6,'default','created','App\\Models\\DailyMonitoring',4,'created','App\\Models\\User',1,'{\"attributes\": {\"date\": \"2026-07-05T00:00:00.000000Z\", \"status\": \"draft\", \"day_name\": \"Ahad\"}}','[]','2026-07-05 12:15:11','2026-07-05 12:15:11'),(7,'default','created','App\\Models\\DailyMonitoring',5,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-01T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Isnin\"}}','[]','2026-07-05 15:42:19','2026-07-05 15:42:19'),(8,'default','created','App\\Models\\DailyMonitoring',6,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-02T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Selasa\"}}','[]','2026-07-05 15:42:19','2026-07-05 15:42:19'),(9,'default','created','App\\Models\\DailyMonitoring',7,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-03T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Rabu\"}}','[]','2026-07-05 15:42:19','2026-07-05 15:42:19'),(10,'default','created','App\\Models\\DailyMonitoring',8,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-04T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Khamis\"}}','[]','2026-07-05 15:42:19','2026-07-05 15:42:19'),(11,'default','created','App\\Models\\DailyMonitoring',9,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-05T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Jumaat\"}}','[]','2026-07-05 15:42:19','2026-07-05 15:42:19'),(12,'default','created','App\\Models\\DailyMonitoring',10,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-08T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Isnin\"}}','[]','2026-07-05 15:42:19','2026-07-05 15:42:19'),(13,'default','created','App\\Models\\DailyMonitoring',11,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-09T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Selasa\"}}','[]','2026-07-05 15:42:19','2026-07-05 15:42:19'),(14,'default','created','App\\Models\\DailyMonitoring',12,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-10T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Rabu\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(15,'default','created','App\\Models\\DailyMonitoring',13,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-11T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Khamis\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(16,'default','created','App\\Models\\DailyMonitoring',14,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-12T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Jumaat\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(17,'default','created','App\\Models\\DailyMonitoring',15,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-15T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Isnin\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(18,'default','created','App\\Models\\DailyMonitoring',16,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-16T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Selasa\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(19,'default','created','App\\Models\\DailyMonitoring',17,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-17T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Rabu\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(20,'default','created','App\\Models\\DailyMonitoring',18,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-18T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Khamis\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(21,'default','created','App\\Models\\DailyMonitoring',19,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-19T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Jumaat\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(22,'default','created','App\\Models\\DailyMonitoring',20,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-22T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Isnin\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(23,'default','created','App\\Models\\DailyMonitoring',21,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-23T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Selasa\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(24,'default','created','App\\Models\\DailyMonitoring',22,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-24T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Rabu\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(25,'default','created','App\\Models\\DailyMonitoring',23,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-26T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Jumaat\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(26,'default','created','App\\Models\\DailyMonitoring',24,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-29T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Isnin\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(27,'default','created','App\\Models\\DailyMonitoring',25,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-06-30T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Selasa\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(28,'default','created','App\\Models\\DailyMonitoring',26,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-07-01T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Rabu\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(29,'default','created','App\\Models\\DailyMonitoring',27,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-07-02T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Khamis\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(30,'default','created','App\\Models\\DailyMonitoring',28,'created',NULL,NULL,'{\"attributes\": {\"date\": \"2026-07-03T00:00:00.000000Z\", \"status\": \"submitted\", \"day_name\": \"Jumaat\"}}','[]','2026-07-05 15:42:20','2026-07-05 15:42:20'),(31,'default','created','App\\Models\\DailyMonitoring',29,'created','App\\Models\\User',1,'{\"attributes\": {\"date\": \"2026-07-06T00:00:00.000000Z\", \"status\": \"draft\", \"day_name\": \"Isnin\"}}','[]','2026-07-05 17:50:49','2026-07-05 17:50:49'),(32,'default','updated','App\\Models\\BuildingArea',1,'updated','App\\Models\\User',1,'{\"old\": {\"is_active\": true}, \"attributes\": {\"is_active\": false}}','[]','2026-07-06 12:42:52','2026-07-06 12:42:52'),(33,'default','updated','App\\Models\\BuildingArea',1,'updated','App\\Models\\User',1,'{\"old\": {\"is_active\": false}, \"attributes\": {\"is_active\": true}}','[]','2026-07-06 12:42:54','2026-07-06 12:42:54'),(34,'default','updated','App\\Models\\User',1,'updated','App\\Models\\User',1,'{\"old\": {\"is_active\": true}, \"attributes\": {\"is_active\": false}}','[]','2026-07-06 12:43:16','2026-07-06 12:43:16'),(35,'default','updated','App\\Models\\User',1,'updated','App\\Models\\User',1,'{\"old\": {\"is_active\": false}, \"attributes\": {\"is_active\": true}}','[]','2026-07-06 12:43:19','2026-07-06 12:43:19'),(36,'default','deleted','App\\Models\\BuildingArea',1,'deleted','App\\Models\\User',1,'{\"old\": {\"name\": \"Aras Bawah Blok A\", \"is_active\": true}}','[]','2026-07-06 14:53:11','2026-07-06 14:53:11');

--
-- Table structure for table `building_areas`
--

CREATE TABLE `building_areas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `school_id` bigint unsigned NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `building_areas_school_id_foreign` (`school_id`),
  CONSTRAINT `building_areas_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `building_areas`
--

INSERT INTO `building_areas` VALUES (1,'Aras Bawah Blok A',1,1,1,'2026-07-06 14:53:11','2026-06-24 21:36:40','2026-07-06 14:53:11'),(2,'Aras Bawah Blok B',1,1,2,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(3,'Aras 1 Blok A',1,1,3,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(4,'Aras 1 Blok B',1,1,4,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(5,'Aras 2 Blok A',1,1,5,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(6,'Aras 2 Blok B',1,1,6,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(7,'Aras 3 Blok A',1,1,7,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(8,'Aras 3 Blok B',1,1,8,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(9,'Blok PPKI',1,1,9,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(10,'Blok Prasekolah',1,1,10,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40');

--
-- Table structure for table `building_monitorings`
--

CREATE TABLE `building_monitorings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `daily_monitoring_id` bigint unsigned NOT NULL,
  `building_area_id` bigint unsigned NOT NULL,
  `condition` enum('good','fair','need_attention') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `building_monitorings_daily_monitoring_id_foreign` (`daily_monitoring_id`),
  KEY `building_monitorings_building_area_id_foreign` (`building_area_id`),
  CONSTRAINT `building_monitorings_building_area_id_foreign` FOREIGN KEY (`building_area_id`) REFERENCES `building_areas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `building_monitorings_daily_monitoring_id_foreign` FOREIGN KEY (`daily_monitoring_id`) REFERENCES `daily_monitorings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `building_monitorings`
--

INSERT INTO `building_monitorings` VALUES (1,1,1,'fair',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(2,1,2,'good',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(3,1,3,'fair',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(4,1,4,'good',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(5,1,5,'good',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(6,1,6,'good',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(7,1,7,'fair',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(8,1,8,'fair',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(9,1,9,'good',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(10,1,10,'need_attention',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(31,4,1,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(32,4,2,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(33,4,3,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(34,4,4,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(35,4,5,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(36,4,6,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(37,4,7,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(38,4,8,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(39,4,9,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(40,4,10,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(41,5,1,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(42,5,2,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(43,5,3,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(44,5,4,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(45,5,5,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(46,5,6,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(47,5,7,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(48,5,8,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(49,5,9,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(50,5,10,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(51,6,1,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(52,6,2,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(53,6,3,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(54,6,4,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(55,6,5,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(56,6,6,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(57,6,7,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(58,6,8,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(59,6,9,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(60,6,10,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(61,7,1,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(62,7,2,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(63,7,3,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(64,7,4,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(65,7,5,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(66,7,6,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(67,7,7,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(68,7,8,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(69,7,9,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(70,7,10,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(71,8,1,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(72,8,2,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(73,8,3,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(74,8,4,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(75,8,5,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(76,8,6,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(77,8,7,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(78,8,8,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(79,8,9,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(80,8,10,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(81,9,1,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(82,9,2,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(83,9,3,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(84,9,4,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(85,9,5,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(86,9,6,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(87,9,7,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(88,9,8,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(89,9,9,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(90,9,10,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(91,10,1,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(92,10,2,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(93,10,3,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(94,10,4,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(95,10,5,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(96,10,6,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(97,10,7,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(98,10,8,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(99,10,9,'good',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(100,10,10,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(101,11,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(102,11,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(103,11,3,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(104,11,4,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(105,11,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(106,11,6,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(107,11,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(108,11,8,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(109,11,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(110,11,10,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(111,12,1,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(112,12,2,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(113,12,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(114,12,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(115,12,5,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(116,12,6,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(117,12,7,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(118,12,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(119,12,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(120,12,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(121,13,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(122,13,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(123,13,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(124,13,4,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(125,13,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(126,13,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(127,13,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(128,13,8,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(129,13,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(130,13,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(131,14,1,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(132,14,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(133,14,3,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(134,14,4,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(135,14,5,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(136,14,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(137,14,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(138,14,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(139,14,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(140,14,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(141,15,1,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(142,15,2,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(143,15,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(144,15,4,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(145,15,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(146,15,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(147,15,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(148,15,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(149,15,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(150,15,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(151,16,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(152,16,2,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(153,16,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(154,16,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(155,16,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(156,16,6,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(157,16,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(158,16,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(159,16,9,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(160,16,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(161,17,1,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(162,17,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(163,17,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(164,17,4,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(165,17,5,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(166,17,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(167,17,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(168,17,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(169,17,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(170,17,10,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(171,18,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(172,18,2,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(173,18,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(174,18,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(175,18,5,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(176,18,6,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(177,18,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(178,18,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(179,18,9,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(180,18,10,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(181,19,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(182,19,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(183,19,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(184,19,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(185,19,5,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(186,19,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(187,19,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(188,19,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(189,19,9,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(190,19,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(191,20,1,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(192,20,2,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(193,20,3,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(194,20,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(195,20,5,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(196,20,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(197,20,7,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(198,20,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(199,20,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(200,20,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(201,21,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(202,21,2,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(203,21,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(204,21,4,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(205,21,5,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(206,21,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(207,21,7,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(208,21,8,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(209,21,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(210,21,10,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(211,22,1,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(212,22,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(213,22,3,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(214,22,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(215,22,5,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(216,22,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(217,22,7,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(218,22,8,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(219,22,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(220,22,10,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(221,23,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(222,23,2,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(223,23,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(224,23,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(225,23,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(226,23,6,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(227,23,7,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(228,23,8,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(229,23,9,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(230,23,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(231,24,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(232,24,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(233,24,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(234,24,4,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(235,24,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(236,24,6,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(237,24,7,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(238,24,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(239,24,9,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(240,24,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(241,25,1,'need_attention','Terdapat retakan pada dinding.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(242,25,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(243,25,3,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(244,25,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(245,25,5,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(246,25,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(247,25,7,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(248,25,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(249,25,9,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(250,25,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(251,26,1,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(252,26,2,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(253,26,3,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(254,26,4,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(255,26,5,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(256,26,6,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(257,26,7,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(258,26,8,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(259,26,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(260,26,10,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(261,27,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(262,27,2,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(263,27,3,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(264,27,4,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(265,27,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(266,27,6,'fair','Cat dinding mulai pudar.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(267,27,7,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(268,27,8,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(269,27,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(270,27,10,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(271,28,1,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(272,28,2,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(273,28,3,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(274,28,4,'need_attention','Pintu rosak dan perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(275,28,5,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(276,28,6,'need_attention','Siling rosak perlu pembaikan segera.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(277,28,7,'fair','Lampu koridor perlu diganti.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(278,28,8,'fair','Paip air bocor perlu dibaiki.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(279,28,9,'good',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(280,28,10,'need_attention','Kipas tidak berfungsi.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(281,29,1,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(282,29,2,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(283,29,3,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(284,29,4,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(285,29,5,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(286,29,6,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(287,29,7,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(288,29,8,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(289,29,9,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(290,29,10,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46');

--
-- Table structure for table `class_monitorings`
--

CREATE TABLE `class_monitorings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `daily_monitoring_id` bigint unsigned NOT NULL,
  `class_id` bigint unsigned NOT NULL,
  `pdpc_status` enum('conducted','not_conducted','no_teacher') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cleanliness_status` enum('bersih_ceria','bersih','need_improvement') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `class_monitorings_daily_monitoring_id_foreign` (`daily_monitoring_id`),
  KEY `class_monitorings_class_id_foreign` (`class_id`),
  CONSTRAINT `class_monitorings_class_id_foreign` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `class_monitorings_daily_monitoring_id_foreign` FOREIGN KEY (`daily_monitoring_id`) REFERENCES `daily_monitorings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=987 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_monitorings`
--

INSERT INTO `class_monitorings` VALUES (1,1,1,'conducted','bersih_ceria',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(2,1,2,'conducted','bersih_ceria',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(3,1,3,'no_teacher','bersih_ceria',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(4,1,4,'no_teacher','bersih_ceria',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(5,1,5,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(6,1,6,'not_conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(7,1,7,'not_conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(8,1,8,'not_conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(9,1,9,'not_conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(10,1,10,NULL,NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(11,1,11,'conducted','bersih_ceria',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(12,1,12,'no_teacher',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(13,1,13,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(14,1,14,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(15,1,15,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(16,1,16,'no_teacher',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(17,1,17,'no_teacher',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(18,1,18,'no_teacher',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(19,1,19,NULL,NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(20,1,20,NULL,NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(21,1,21,NULL,NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(22,1,22,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(23,1,23,NULL,'bersih',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(24,1,24,NULL,'bersih_ceria',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(25,1,25,'no_teacher',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(26,1,26,'not_conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(27,1,27,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(28,1,28,'not_conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(29,1,29,'no_teacher',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(30,1,30,NULL,'bersih_ceria',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(31,1,31,NULL,'bersih',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(32,1,32,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(33,1,33,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(34,1,34,'conducted',NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(103,4,1,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(104,4,2,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(105,4,3,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(106,4,4,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(107,4,5,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(108,4,6,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(109,4,7,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(110,4,8,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(111,4,9,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(112,4,10,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(113,4,11,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(114,4,12,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(115,4,13,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(116,4,14,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(117,4,15,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(118,4,16,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(119,4,17,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(120,4,18,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(121,4,19,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(122,4,20,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(123,4,21,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(124,4,22,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(125,4,23,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(126,4,24,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(127,4,25,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(128,4,26,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(129,4,27,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(130,4,28,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(131,4,29,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(132,4,30,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(133,4,31,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(134,4,32,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(135,4,33,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(136,4,34,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(137,5,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(138,5,2,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(139,5,3,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(140,5,4,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(141,5,5,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(142,5,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(143,5,7,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(144,5,8,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(145,5,9,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(146,5,10,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(147,5,11,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(148,5,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(149,5,13,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(150,5,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(151,5,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(152,5,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(153,5,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(154,5,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(155,5,19,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(156,5,20,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(157,5,21,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(158,5,22,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(159,5,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(160,5,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(161,5,25,'not_conducted','bersih','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(162,5,26,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(163,5,27,'not_conducted','need_improvement','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(164,5,28,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(165,5,29,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(166,5,30,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(167,5,31,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(168,5,32,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(169,5,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(170,5,34,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(171,6,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(172,6,2,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(173,6,3,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(174,6,4,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(175,6,5,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(176,6,6,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(177,6,7,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(178,6,8,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(179,6,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(180,6,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(181,6,11,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(182,6,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(183,6,13,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(184,6,14,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(185,6,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(186,6,16,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(187,6,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(188,6,18,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(189,6,19,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(190,6,20,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(191,6,21,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(192,6,22,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(193,6,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(194,6,24,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(195,6,25,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(196,6,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(197,6,27,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(198,6,28,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(199,6,29,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(200,6,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(201,6,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(202,6,32,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(203,6,33,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(204,6,34,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(205,7,1,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(206,7,2,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(207,7,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(208,7,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(209,7,5,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(210,7,6,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(211,7,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(212,7,8,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(213,7,9,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(214,7,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(215,7,11,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(216,7,12,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(217,7,13,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(218,7,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(219,7,15,'not_conducted','bersih','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(220,7,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(221,7,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(222,7,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(223,7,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(224,7,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(225,7,21,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(226,7,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(227,7,23,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(228,7,24,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(229,7,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(230,7,26,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(231,7,27,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(232,7,28,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(233,7,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(234,7,30,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(235,7,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(236,7,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(237,7,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(238,7,34,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(239,8,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(240,8,2,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(241,8,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(242,8,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(243,8,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(244,8,6,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(245,8,7,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(246,8,8,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(247,8,9,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(248,8,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(249,8,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(250,8,12,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(251,8,13,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(252,8,14,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(253,8,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(254,8,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(255,8,17,'no_teacher','need_improvement','Guru pada cuti bersalin.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(256,8,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(257,8,19,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(258,8,20,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(259,8,21,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(260,8,22,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(261,8,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(262,8,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(263,8,25,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(264,8,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(265,8,27,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(266,8,28,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(267,8,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(268,8,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(269,8,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(270,8,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(271,8,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(272,8,34,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(273,9,1,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(274,9,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(275,9,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(276,9,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(277,9,5,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(278,9,6,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(279,9,7,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(280,9,8,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(281,9,9,'not_conducted','need_improvement','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(282,9,10,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(283,9,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(284,9,12,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(285,9,13,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(286,9,14,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(287,9,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(288,9,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(289,9,17,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(290,9,18,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(291,9,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(292,9,20,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(293,9,21,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(294,9,22,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(295,9,23,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(296,9,24,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(297,9,25,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(298,9,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(299,9,27,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(300,9,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(301,9,29,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(302,9,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(303,9,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(304,9,32,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(305,9,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(306,9,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(307,10,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(308,10,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(309,10,3,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(310,10,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(311,10,5,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(312,10,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(313,10,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(314,10,8,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(315,10,9,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(316,10,10,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(317,10,11,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(318,10,12,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(319,10,13,'no_teacher','need_improvement','Guru pada cuti bersalin.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(320,10,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(321,10,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(322,10,16,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(323,10,17,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(324,10,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(325,10,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(326,10,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(327,10,21,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(328,10,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(329,10,23,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(330,10,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(331,10,25,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(332,10,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(333,10,27,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(334,10,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(335,10,29,'conducted','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(336,10,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(337,10,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(338,10,32,'conducted','need_improvement',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(339,10,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(340,10,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(341,11,1,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(342,11,2,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(343,11,3,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(344,11,4,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(345,11,5,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(346,11,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(347,11,7,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(348,11,8,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(349,11,9,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(350,11,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(351,11,11,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(352,11,12,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(353,11,13,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(354,11,14,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(355,11,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(356,11,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(357,11,17,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(358,11,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(359,11,19,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(360,11,20,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(361,11,21,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(362,11,22,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(363,11,23,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(364,11,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(365,11,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(366,11,26,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(367,11,27,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(368,11,28,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(369,11,29,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(370,11,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(371,11,31,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(372,11,32,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(373,11,33,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(374,11,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(375,12,1,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(376,12,2,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(377,12,3,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(378,12,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(379,12,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(380,12,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(381,12,7,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(382,12,8,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(383,12,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(384,12,10,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(385,12,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(386,12,12,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(387,12,13,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(388,12,14,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(389,12,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(390,12,16,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(391,12,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(392,12,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(393,12,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(394,12,20,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(395,12,21,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(396,12,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(397,12,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(398,12,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(399,12,25,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(400,12,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(401,12,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(402,12,28,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(403,12,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(404,12,30,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(405,12,31,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(406,12,32,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(407,12,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(408,12,34,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(409,13,1,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(410,13,2,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(411,13,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(412,13,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(413,13,5,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(414,13,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(415,13,7,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(416,13,8,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(417,13,9,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(418,13,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(419,13,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(420,13,12,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(421,13,13,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(422,13,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(423,13,15,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(424,13,16,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(425,13,17,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(426,13,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(427,13,19,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(428,13,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(429,13,21,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(430,13,22,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(431,13,23,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(432,13,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(433,13,25,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(434,13,26,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(435,13,27,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(436,13,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(437,13,29,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(438,13,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(439,13,31,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(440,13,32,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(441,13,33,'not_conducted','need_improvement','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(442,13,34,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(443,14,1,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(444,14,2,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(445,14,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(446,14,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(447,14,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(448,14,6,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(449,14,7,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(450,14,8,'no_teacher','need_improvement','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(451,14,9,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(452,14,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(453,14,11,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(454,14,12,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(455,14,13,'not_conducted','need_improvement','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(456,14,14,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(457,14,15,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(458,14,16,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(459,14,17,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(460,14,18,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(461,14,19,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(462,14,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(463,14,21,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(464,14,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(465,14,23,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(466,14,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(467,14,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(468,14,26,'not_conducted','need_improvement','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(469,14,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(470,14,28,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(471,14,29,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(472,14,30,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(473,14,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(474,14,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(475,14,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(476,14,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(477,15,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(478,15,2,'not_conducted','bersih','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(479,15,3,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(480,15,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(481,15,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(482,15,6,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(483,15,7,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(484,15,8,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(485,15,9,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(486,15,10,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(487,15,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(488,15,12,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(489,15,13,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(490,15,14,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(491,15,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(492,15,16,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(493,15,17,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(494,15,18,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(495,15,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(496,15,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(497,15,21,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(498,15,22,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(499,15,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(500,15,24,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(501,15,25,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(502,15,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(503,15,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(504,15,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(505,15,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(506,15,30,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(507,15,31,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(508,15,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(509,15,33,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(510,15,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(511,16,1,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(512,16,2,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(513,16,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(514,16,4,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(515,16,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(516,16,6,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(517,16,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(518,16,8,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(519,16,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(520,16,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(521,16,11,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(522,16,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(523,16,13,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(524,16,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(525,16,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(526,16,16,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(527,16,17,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(528,16,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(529,16,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(530,16,20,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(531,16,21,'not_conducted','bersih','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(532,16,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(533,16,23,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(534,16,24,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(535,16,25,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(536,16,26,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(537,16,27,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(538,16,28,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(539,16,29,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(540,16,30,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(541,16,31,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(542,16,32,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(543,16,33,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(544,16,34,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(545,17,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(546,17,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(547,17,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(548,17,4,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(549,17,5,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(550,17,6,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(551,17,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(552,17,8,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(553,17,9,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(554,17,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(555,17,11,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(556,17,12,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(557,17,13,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(558,17,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(559,17,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(560,17,16,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(561,17,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(562,17,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(563,17,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(564,17,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(565,17,21,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(566,17,22,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(567,17,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(568,17,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(569,17,25,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(570,17,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(571,17,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(572,17,28,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(573,17,29,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(574,17,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(575,17,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(576,17,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(577,17,33,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(578,17,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(579,18,1,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(580,18,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(581,18,3,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(582,18,4,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(583,18,5,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(584,18,6,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(585,18,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(586,18,8,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(587,18,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(588,18,10,'no_teacher','need_improvement','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(589,18,11,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(590,18,12,'not_conducted','need_improvement','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(591,18,13,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(592,18,14,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(593,18,15,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(594,18,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(595,18,17,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(596,18,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(597,18,19,'not_conducted','need_improvement','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(598,18,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(599,18,21,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(600,18,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(601,18,23,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(602,18,24,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(603,18,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(604,18,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(605,18,27,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(606,18,28,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(607,18,29,'not_conducted','need_improvement','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(608,18,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(609,18,31,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(610,18,32,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(611,18,33,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(612,18,34,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(613,19,1,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(614,19,2,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(615,19,3,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(616,19,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(617,19,5,'not_conducted','bersih','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(618,19,6,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(619,19,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(620,19,8,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(621,19,9,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(622,19,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(623,19,11,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(624,19,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(625,19,13,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(626,19,14,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(627,19,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(628,19,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(629,19,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(630,19,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(631,19,19,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(632,19,20,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(633,19,21,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(634,19,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(635,19,23,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(636,19,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(637,19,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(638,19,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(639,19,27,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(640,19,28,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(641,19,29,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(642,19,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(643,19,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(644,19,32,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(645,19,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(646,19,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(647,20,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(648,20,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(649,20,3,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(650,20,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(651,20,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(652,20,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(653,20,7,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(654,20,8,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(655,20,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(656,20,10,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(657,20,11,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(658,20,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(659,20,13,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(660,20,14,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(661,20,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(662,20,16,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(663,20,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(664,20,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(665,20,19,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(666,20,20,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(667,20,21,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(668,20,22,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(669,20,23,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(670,20,24,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(671,20,25,'not_conducted','bersih_ceria','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(672,20,26,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(673,20,27,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(674,20,28,'no_teacher','need_improvement','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(675,20,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(676,20,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(677,20,31,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(678,20,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(679,20,33,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(680,20,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(681,21,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(682,21,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(683,21,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(684,21,4,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(685,21,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(686,21,6,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(687,21,7,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(688,21,8,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(689,21,9,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(690,21,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(691,21,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(692,21,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(693,21,13,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(694,21,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(695,21,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(696,21,16,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(697,21,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(698,21,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(699,21,19,'not_conducted','need_improvement','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(700,21,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(701,21,21,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(702,21,22,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(703,21,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(704,21,24,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(705,21,25,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(706,21,26,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(707,21,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(708,21,28,'not_conducted','need_improvement','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(709,21,29,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(710,21,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(711,21,31,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(712,21,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(713,21,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(714,21,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(715,22,1,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(716,22,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(717,22,3,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(718,22,4,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(719,22,5,'no_teacher','need_improvement','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(720,22,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(721,22,7,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(722,22,8,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(723,22,9,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(724,22,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(725,22,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(726,22,12,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(727,22,13,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(728,22,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(729,22,15,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(730,22,16,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(731,22,17,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(732,22,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(733,22,19,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(734,22,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(735,22,21,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(736,22,22,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(737,22,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(738,22,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(739,22,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(740,22,26,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(741,22,27,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(742,22,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(743,22,29,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(744,22,30,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(745,22,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(746,22,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(747,22,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(748,22,34,'not_conducted','bersih','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(749,23,1,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(750,23,2,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(751,23,3,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(752,23,4,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(753,23,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(754,23,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(755,23,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(756,23,8,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(757,23,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(758,23,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(759,23,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(760,23,12,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(761,23,13,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(762,23,14,'not_conducted','need_improvement','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(763,23,15,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(764,23,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(765,23,17,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(766,23,18,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(767,23,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(768,23,20,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(769,23,21,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(770,23,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(771,23,23,'not_conducted','need_improvement','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(772,23,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(773,23,25,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(774,23,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(775,23,27,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(776,23,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(777,23,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(778,23,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(779,23,31,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(780,23,32,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(781,23,33,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(782,23,34,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(783,24,1,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(784,24,2,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(785,24,3,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(786,24,4,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(787,24,5,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(788,24,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(789,24,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(790,24,8,'no_teacher','bersih','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(791,24,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(792,24,10,'not_conducted','need_improvement','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(793,24,11,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(794,24,12,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(795,24,13,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(796,24,14,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(797,24,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(798,24,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(799,24,17,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(800,24,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(801,24,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(802,24,20,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(803,24,21,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(804,24,22,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(805,24,23,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(806,24,24,'not_conducted','need_improvement','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(807,24,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(808,24,26,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(809,24,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(810,24,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(811,24,29,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(812,24,30,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(813,24,31,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(814,24,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(815,24,33,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(816,24,34,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(817,25,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(818,25,2,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(819,25,3,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(820,25,4,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(821,25,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(822,25,6,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(823,25,7,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(824,25,8,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(825,25,9,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(826,25,10,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(827,25,11,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(828,25,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(829,25,13,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(830,25,14,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(831,25,15,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(832,25,16,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(833,25,17,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(834,25,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(835,25,19,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(836,25,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(837,25,21,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(838,25,22,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(839,25,23,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(840,25,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(841,25,25,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(842,25,26,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(843,25,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(844,25,28,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(845,25,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(846,25,30,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(847,25,31,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(848,25,32,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(849,25,33,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(850,25,34,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(851,26,1,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(852,26,2,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(853,26,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(854,26,4,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(855,26,5,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(856,26,6,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(857,26,7,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(858,26,8,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(859,26,9,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(860,26,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(861,26,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(862,26,12,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(863,26,13,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(864,26,14,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(865,26,15,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(866,26,16,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(867,26,17,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(868,26,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(869,26,19,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(870,26,20,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(871,26,21,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(872,26,22,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(873,26,23,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(874,26,24,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(875,26,25,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(876,26,26,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(877,26,27,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(878,26,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(879,26,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(880,26,30,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(881,26,31,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(882,26,32,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(883,26,33,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(884,26,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(885,27,1,'no_teacher','bersih_ceria','Tiada guru ganti ditempatkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(886,27,2,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(887,27,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(888,27,4,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(889,27,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(890,27,6,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(891,27,7,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(892,27,8,'not_conducted','need_improvement','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(893,27,9,'no_teacher','bersih','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(894,27,10,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(895,27,11,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(896,27,12,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(897,27,13,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(898,27,14,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(899,27,15,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(900,27,16,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(901,27,17,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(902,27,18,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(903,27,19,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(904,27,20,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(905,27,21,'not_conducted','bersih_ceria','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(906,27,22,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(907,27,23,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(908,27,24,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(909,27,25,'no_teacher','need_improvement','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(910,27,26,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(911,27,27,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(912,27,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(913,27,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(914,27,30,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(915,27,31,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(916,27,32,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(917,27,33,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(918,27,34,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(919,28,1,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(920,28,2,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(921,28,3,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(922,28,4,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(923,28,5,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(924,28,6,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(925,28,7,'not_conducted','bersih','PdPC ditangguhkan kerana mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(926,28,8,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(927,28,9,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(928,28,10,'no_teacher','bersih_ceria','Guru menghadiri kursus.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(929,28,11,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(930,28,12,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(931,28,13,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(932,28,14,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(933,28,15,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(934,28,16,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(935,28,17,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(936,28,18,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(937,28,19,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(938,28,20,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(939,28,21,'no_teacher','bersih_ceria','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(940,28,22,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(941,28,23,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(942,28,24,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(943,28,25,'not_conducted','bersih_ceria','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(944,28,26,'no_teacher','bersih','Guru pada cuti bersalin.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(945,28,27,'conducted','need_improvement',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(946,28,28,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(947,28,29,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(948,28,30,'not_conducted','bersih','Guru tidak hadir hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(949,28,31,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(950,28,32,'not_conducted','need_improvement','Bilik kelas digunakan untuk ujian.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(951,28,33,'conducted','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(952,28,34,'conducted','bersih_ceria',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(953,29,1,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(954,29,2,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(955,29,3,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(956,29,4,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(957,29,5,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(958,29,6,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(959,29,7,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(960,29,8,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(961,29,9,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(962,29,10,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(963,29,11,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(964,29,12,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(965,29,13,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(966,29,14,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(967,29,15,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(968,29,16,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(969,29,17,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(970,29,18,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(971,29,19,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(972,29,20,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(973,29,21,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(974,29,22,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(975,29,23,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(976,29,24,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(977,29,25,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(978,29,26,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(979,29,27,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(980,29,28,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(981,29,29,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(982,29,30,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(983,29,31,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(984,29,32,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(985,29,33,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(986,29,34,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46');

--
-- Table structure for table `classes`
--

CREATE TABLE `classes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` tinyint unsigned NOT NULL,
  `stream` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_id` bigint unsigned NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `classes_school_id_foreign` (`school_id`),
  CONSTRAINT `classes_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` VALUES (1,'1 UTARID',1,'Utarid',1,1,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(2,'1 ZUHRAH',1,'Zuhrah',1,1,2,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(3,'1 BUMI',1,'Bumi',1,1,3,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(4,'1 DLP',1,'DLP',1,1,4,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(5,'2 UTARID',2,'Utarid',1,1,5,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(6,'2 ZUHRAH',2,'Zuhrah',1,1,6,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(7,'2 BUMI',2,'Bumi',1,1,7,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(8,'2 DLP',2,'DLP',1,1,8,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(9,'3 UTARID',3,'Utarid',1,1,9,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(10,'3 ZUHRAH',3,'Zuhrah',1,1,10,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(11,'3 BUMI',3,'Bumi',1,1,11,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(12,'3 DLP',3,'DLP',1,1,12,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(13,'4 UTARID',4,'Utarid',1,1,13,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(14,'4 ZUHRAH',4,'Zuhrah',1,1,14,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(15,'4 BUMI',4,'Bumi',1,1,15,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(16,'4 DLP',4,'DLP',1,1,16,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(17,'5 UTARID',5,'Utarid',1,1,17,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(18,'5 ZUHRAH',5,'Zuhrah',1,1,18,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(19,'5 BUMI',5,'Bumi',1,1,19,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(20,'5 MARIKH',5,'Marikh',1,1,20,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(21,'5 DLP',5,'DLP',1,1,21,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(22,'6 UTARID',6,'Utarid',1,1,22,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(23,'6 ZUHRAH',6,'Zuhrah',1,1,23,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(24,'6 BUMI',6,'Bumi',1,1,24,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(25,'6 MARIKH',6,'Marikh',1,1,25,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(26,'6 DLP',6,'DLP',1,1,26,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(27,'PPKi 1',0,'PPKI',1,1,27,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(28,'PPKi 2',0,'PPKI',1,1,28,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(29,'PPKi 3',0,'PPKI',1,1,29,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(30,'PPKi 4',0,'PPKI',1,1,30,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(31,'PRA BESTARI 1',0,'Pra Bestari',1,1,31,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(32,'PRA BESTARI 2',0,'Pra Bestari',1,1,32,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(33,'PRA BESTARI 3',0,'Pra Bestari',1,1,33,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(34,'PRA BESTARI 4',0,'Pra Bestari',1,1,34,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40');

--
-- Table structure for table `cocurriculum_monitorings`
--

CREATE TABLE `cocurriculum_monitorings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `daily_monitoring_id` bigint unsigned NOT NULL,
  `activity_conducted` enum('ada','tidak_ada') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cocurriculum_monitorings_daily_monitoring_id_foreign` (`daily_monitoring_id`),
  CONSTRAINT `cocurriculum_monitorings_daily_monitoring_id_foreign` FOREIGN KEY (`daily_monitoring_id`) REFERENCES `daily_monitorings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cocurriculum_monitorings`
--

INSERT INTO `cocurriculum_monitorings` VALUES (1,1,'ada',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(4,4,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(5,5,'ada','Kegiatan kelab dan persatuan berjalan lancar.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(6,6,'ada','Kelas muzik dan koir dijalankan seperti biasa.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(7,7,'ada','Sukan tahunan sedang dalam fasa persediaan.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(8,8,'tidak_ada','Tiada kegiatan kokurikulum pada hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(9,9,'ada','Sukan tahunan sedang dalam fasa persediaan.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(10,10,'tidak_ada','Tiada kegiatan kokurikulum pada hari ini.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(11,11,'ada','Sukan tahunan sedang dalam fasa persediaan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(12,12,'tidak_ada','Tiada kegiatan kokurikulum pada hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(13,13,'ada','Sukan tahunan sedang dalam fasa persediaan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(14,14,'tidak_ada','Tiada kegiatan kokurikulum pada hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(15,15,'ada','Kelas muzik dan koir dijalankan seperti biasa.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(16,16,'ada','Persatuan Bahasa Melayu mengadakan mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(17,17,'tidak_ada','Tiada kegiatan kokurikulum pada hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(18,18,'ada','Persatuan Bahasa Melayu mengadakan mesyuarat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(19,19,'ada','Latihan sukan permainan berlangsung pada petang.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(20,20,'ada','Kelas muzik dan koir dijalankan seperti biasa.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(21,21,'tidak_ada','Tiada kegiatan kokurikulum pada hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(22,22,'tidak_ada','Tiada kegiatan kokurikulum pada hari ini.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(23,23,'ada','Kelas muzik dan koir dijalankan seperti biasa.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(24,24,'ada','Kelas muzik dan koir dijalankan seperti biasa.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(25,25,'ada','Latihan sukan permainan berlangsung pada petang.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(26,26,'ada','Latihan sukan permainan berlangsung pada petang.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(27,27,'ada','Latihan sukan permainan berlangsung pada petang.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(28,28,'ada','Sukan tahunan sedang dalam fasa persediaan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(29,29,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46');

--
-- Table structure for table `daily_monitorings`
--

CREATE TABLE `daily_monitorings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `day_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `week_number` tinyint unsigned NOT NULL,
  `month` tinyint unsigned NOT NULL,
  `year` smallint unsigned NOT NULL,
  `status` enum('draft','submitted') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `is_test` tinyint(1) NOT NULL DEFAULT '0',
  `submitted_by` bigint unsigned DEFAULT NULL,
  `submitted_at` timestamp NULL DEFAULT NULL,
  `school_id` bigint unsigned NOT NULL,
  `academic_year_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `daily_monitorings_date_school_id_unique` (`date`,`school_id`),
  KEY `daily_monitorings_submitted_by_foreign` (`submitted_by`),
  KEY `daily_monitorings_school_id_foreign` (`school_id`),
  KEY `daily_monitorings_academic_year_id_foreign` (`academic_year_id`),
  CONSTRAINT `daily_monitorings_academic_year_id_foreign` FOREIGN KEY (`academic_year_id`) REFERENCES `academic_years` (`id`) ON DELETE SET NULL,
  CONSTRAINT `daily_monitorings_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE,
  CONSTRAINT `daily_monitorings_submitted_by_foreign` FOREIGN KEY (`submitted_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `daily_monitorings`
--

INSERT INTO `daily_monitorings` VALUES (1,'2026-06-25','Khamis',26,6,2026,'submitted',0,1,'2026-06-25 05:10:36',1,1,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(4,'2026-07-05','Ahad',27,7,2026,'draft',0,NULL,NULL,1,1,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(5,'2026-06-01','Isnin',23,6,2026,'submitted',0,1,'2026-06-01 01:11:00',1,1,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(6,'2026-06-02','Selasa',23,6,2026,'submitted',0,1,'2026-06-02 01:07:00',1,1,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(7,'2026-06-03','Rabu',23,6,2026,'submitted',0,1,'2026-06-03 01:25:00',1,1,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(8,'2026-06-04','Khamis',23,6,2026,'submitted',0,1,'2026-06-04 01:13:00',1,1,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(9,'2026-06-05','Jumaat',23,6,2026,'submitted',0,1,'2026-06-05 01:06:00',1,1,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(10,'2026-06-08','Isnin',24,6,2026,'submitted',0,1,'2026-06-08 01:30:00',1,1,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(11,'2026-06-09','Selasa',24,6,2026,'submitted',0,1,'2026-06-09 01:06:00',1,1,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(12,'2026-06-10','Rabu',24,6,2026,'submitted',0,1,'2026-06-10 01:26:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(13,'2026-06-11','Khamis',24,6,2026,'submitted',0,1,'2026-06-11 01:22:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(14,'2026-06-12','Jumaat',24,6,2026,'submitted',0,1,'2026-06-12 01:21:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(15,'2026-06-15','Isnin',25,6,2026,'submitted',0,1,'2026-06-15 01:26:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(16,'2026-06-16','Selasa',25,6,2026,'submitted',0,1,'2026-06-16 01:13:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(17,'2026-06-17','Rabu',25,6,2026,'submitted',0,1,'2026-06-17 01:26:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(18,'2026-06-18','Khamis',25,6,2026,'submitted',0,1,'2026-06-18 01:21:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(19,'2026-06-19','Jumaat',25,6,2026,'submitted',0,1,'2026-06-19 01:28:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(20,'2026-06-22','Isnin',26,6,2026,'submitted',0,1,'2026-06-22 01:07:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(21,'2026-06-23','Selasa',26,6,2026,'submitted',0,1,'2026-06-23 01:13:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(22,'2026-06-24','Rabu',26,6,2026,'submitted',0,1,'2026-06-24 01:19:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(23,'2026-06-26','Jumaat',26,6,2026,'submitted',0,1,'2026-06-26 01:15:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(24,'2026-06-29','Isnin',27,6,2026,'submitted',0,1,'2026-06-29 01:20:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(25,'2026-06-30','Selasa',27,6,2026,'submitted',0,1,'2026-06-30 01:15:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(26,'2026-07-01','Rabu',27,7,2026,'submitted',0,1,'2026-07-01 01:26:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(27,'2026-07-02','Khamis',27,7,2026,'submitted',0,1,'2026-07-02 01:21:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(28,'2026-07-03','Jumaat',27,7,2026,'submitted',0,1,'2026-07-03 01:19:00',1,1,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(29,'2026-07-06','Isnin',28,7,2026,'draft',0,NULL,NULL,1,1,NULL,'2026-07-05 17:50:49','2026-07-05 17:50:49');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `general_monitorings`
--

CREATE TABLE `general_monitorings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `daily_monitoring_id` bigint unsigned NOT NULL,
  `item_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` enum('bersih','sederhana','memuaskan') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `general_monitorings_daily_monitoring_id_foreign` (`daily_monitoring_id`),
  CONSTRAINT `general_monitorings_daily_monitoring_id_foreign` FOREIGN KEY (`daily_monitoring_id`) REFERENCES `daily_monitorings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_monitorings`
--

INSERT INTO `general_monitorings` VALUES (1,1,'Persekitaran Sekolah','sederhana',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(2,1,'Kantin','sederhana',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(3,1,'Padang Permainan','memuaskan',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(4,1,'Tandas','memuaskan',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(13,4,'Persekitaran Sekolah',NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(14,4,'Kantin',NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(15,4,'Padang Permainan',NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(16,4,'Tandas',NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(17,5,'Persekitaran Sekolah','bersih','Kawasan sekolah bersih dan terkawal','2026-07-05 15:42:19','2026-07-05 15:42:19'),(18,5,'Kantin','memuaskan','Pengusaha kantin mematuhi garis panduan','2026-07-05 15:42:19','2026-07-05 15:42:19'),(19,5,'Padang Permainan','memuaskan','Padang selamat digunakan','2026-07-05 15:42:19','2026-07-05 15:42:19'),(20,5,'Tandas','memuaskan',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(21,6,'Persekitaran Sekolah','sederhana','Perlu penjagaan rumput','2026-07-05 15:42:19','2026-07-05 15:42:19'),(22,6,'Kantin','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(23,6,'Padang Permainan','memuaskan','Rumput perlu dipotong','2026-07-05 15:42:19','2026-07-05 15:42:19'),(24,6,'Tandas','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(25,7,'Persekitaran Sekolah','sederhana','Perlu penjagaan rumput','2026-07-05 15:42:19','2026-07-05 15:42:19'),(26,7,'Kantin','memuaskan','Perlu pembersihan selepas rehat','2026-07-05 15:42:19','2026-07-05 15:42:19'),(27,7,'Padang Permainan','memuaskan','Rumput perlu dipotong','2026-07-05 15:42:19','2026-07-05 15:42:19'),(28,7,'Tandas','sederhana','Perlu penyelenggaraan paip','2026-07-05 15:42:19','2026-07-05 15:42:19'),(29,8,'Persekitaran Sekolah','sederhana',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(30,8,'Kantin','memuaskan','Kantin dalam keadaan baik','2026-07-05 15:42:19','2026-07-05 15:42:19'),(31,8,'Padang Permainan','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(32,8,'Tandas','memuaskan','Tandas bersih dan berfungsi','2026-07-05 15:42:19','2026-07-05 15:42:19'),(33,9,'Persekitaran Sekolah','bersih','Perlu penjagaan rumput','2026-07-05 15:42:19','2026-07-05 15:42:19'),(34,9,'Kantin','sederhana','Perlu pembersihan selepas rehat','2026-07-05 15:42:19','2026-07-05 15:42:19'),(35,9,'Padang Permainan','sederhana','Terdapat lubang di kawasan padang','2026-07-05 15:42:19','2026-07-05 15:42:19'),(36,9,'Tandas','bersih','Tandas bersih dan berfungsi','2026-07-05 15:42:19','2026-07-05 15:42:19'),(37,10,'Persekitaran Sekolah','memuaskan','Kawasan sekolah bersih dan terkawal','2026-07-05 15:42:19','2026-07-05 15:42:19'),(38,10,'Kantin','bersih',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(39,10,'Padang Permainan','memuaskan',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(40,10,'Tandas','bersih','Tandas bersih dan berfungsi','2026-07-05 15:42:19','2026-07-05 15:42:19'),(41,11,'Persekitaran Sekolah','bersih','Perlu penjagaan rumput','2026-07-05 15:42:19','2026-07-05 15:42:19'),(42,11,'Kantin','memuaskan',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(43,11,'Padang Permainan','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(44,11,'Tandas','memuaskan','Perlu penyelenggaraan paip','2026-07-05 15:42:20','2026-07-05 15:42:20'),(45,12,'Persekitaran Sekolah','sederhana','Terdapat sampah di kawasan pagar','2026-07-05 15:42:20','2026-07-05 15:42:20'),(46,12,'Kantin','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(47,12,'Padang Permainan','sederhana','Padang selamat digunakan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(48,12,'Tandas','memuaskan','Tandas bersih dan berfungsi','2026-07-05 15:42:20','2026-07-05 15:42:20'),(49,13,'Persekitaran Sekolah','bersih','Terdapat sampah di kawasan pagar','2026-07-05 15:42:20','2026-07-05 15:42:20'),(50,13,'Kantin','sederhana','Perlu pembersihan selepas rehat','2026-07-05 15:42:20','2026-07-05 15:42:20'),(51,13,'Padang Permainan','memuaskan',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(52,13,'Tandas','memuaskan','Tandas bersih dan berfungsi','2026-07-05 15:42:20','2026-07-05 15:42:20'),(53,14,'Persekitaran Sekolah','memuaskan',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(54,14,'Kantin','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(55,14,'Padang Permainan','memuaskan','Rumput perlu dipotong','2026-07-05 15:42:20','2026-07-05 15:42:20'),(56,14,'Tandas','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(57,15,'Persekitaran Sekolah','memuaskan',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(58,15,'Kantin','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(59,15,'Padang Permainan','memuaskan',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(60,15,'Tandas','bersih','Tandas bersih dan berfungsi','2026-07-05 15:42:20','2026-07-05 15:42:20'),(61,16,'Persekitaran Sekolah','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(62,16,'Kantin','bersih','Perlu pembersihan selepas rehat','2026-07-05 15:42:20','2026-07-05 15:42:20'),(63,16,'Padang Permainan','bersih','Padang selamat digunakan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(64,16,'Tandas','memuaskan','Bekalan air mencukupi','2026-07-05 15:42:20','2026-07-05 15:42:20'),(65,17,'Persekitaran Sekolah','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(66,17,'Kantin','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(67,17,'Padang Permainan','memuaskan','Padang selamat digunakan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(68,17,'Tandas','memuaskan','Perlu penyelenggaraan paip','2026-07-05 15:42:20','2026-07-05 15:42:20'),(69,18,'Persekitaran Sekolah','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(70,18,'Kantin','bersih','Pengusaha kantin mematuhi garis panduan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(71,18,'Padang Permainan','memuaskan','Terdapat lubang di kawasan padang','2026-07-05 15:42:20','2026-07-05 15:42:20'),(72,18,'Tandas','memuaskan',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(73,19,'Persekitaran Sekolah','memuaskan','Kawasan sekolah bersih dan terkawal','2026-07-05 15:42:20','2026-07-05 15:42:20'),(74,19,'Kantin','bersih','Perlu pembersihan selepas rehat','2026-07-05 15:42:20','2026-07-05 15:42:20'),(75,19,'Padang Permainan','sederhana','Terdapat lubang di kawasan padang','2026-07-05 15:42:20','2026-07-05 15:42:20'),(76,19,'Tandas','memuaskan','Bekalan air mencukupi','2026-07-05 15:42:20','2026-07-05 15:42:20'),(77,20,'Persekitaran Sekolah','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(78,20,'Kantin','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(79,20,'Padang Permainan','bersih','Padang selamat digunakan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(80,20,'Tandas','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(81,21,'Persekitaran Sekolah','bersih','Perlu penjagaan rumput','2026-07-05 15:42:20','2026-07-05 15:42:20'),(82,21,'Kantin','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(83,21,'Padang Permainan','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(84,21,'Tandas','bersih','Bekalan air mencukupi','2026-07-05 15:42:20','2026-07-05 15:42:20'),(85,22,'Persekitaran Sekolah','bersih','Kawasan sekolah bersih dan terkawal','2026-07-05 15:42:20','2026-07-05 15:42:20'),(86,22,'Kantin','memuaskan',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(87,22,'Padang Permainan','sederhana','Padang selamat digunakan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(88,22,'Tandas','sederhana','Perlu penyelenggaraan paip','2026-07-05 15:42:20','2026-07-05 15:42:20'),(89,23,'Persekitaran Sekolah','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(90,23,'Kantin','memuaskan','Pengusaha kantin mematuhi garis panduan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(91,23,'Padang Permainan','sederhana','Terdapat lubang di kawasan padang','2026-07-05 15:42:20','2026-07-05 15:42:20'),(92,23,'Tandas','sederhana','Perlu penyelenggaraan paip','2026-07-05 15:42:20','2026-07-05 15:42:20'),(93,24,'Persekitaran Sekolah','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(94,24,'Kantin','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(95,24,'Padang Permainan','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(96,24,'Tandas','bersih','Perlu penyelenggaraan paip','2026-07-05 15:42:20','2026-07-05 15:42:20'),(97,25,'Persekitaran Sekolah','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(98,25,'Kantin','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(99,25,'Padang Permainan','memuaskan','Padang selamat digunakan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(100,25,'Tandas','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(101,26,'Persekitaran Sekolah','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(102,26,'Kantin','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(103,26,'Padang Permainan','memuaskan','Rumput perlu dipotong','2026-07-05 15:42:20','2026-07-05 15:42:20'),(104,26,'Tandas','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(105,27,'Persekitaran Sekolah','memuaskan','Kawasan sekolah bersih dan terkawal','2026-07-05 15:42:20','2026-07-05 15:42:20'),(106,27,'Kantin','bersih','Perlu pembersihan selepas rehat','2026-07-05 15:42:20','2026-07-05 15:42:20'),(107,27,'Padang Permainan','memuaskan','Padang selamat digunakan','2026-07-05 15:42:20','2026-07-05 15:42:20'),(108,27,'Tandas','memuaskan',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(109,28,'Persekitaran Sekolah','memuaskan','Kawasan sekolah bersih dan terkawal','2026-07-05 15:42:20','2026-07-05 15:42:20'),(110,28,'Kantin','bersih',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(111,28,'Padang Permainan','sederhana','Rumput perlu dipotong','2026-07-05 15:42:20','2026-07-05 15:42:20'),(112,28,'Tandas','sederhana',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(113,29,'Persekitaran Sekolah',NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(114,29,'Kantin',NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(115,29,'Padang Permainan',NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46'),(116,29,'Tandas',NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46');

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` smallint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_06_25_043755_create_activity_log_table',1),(5,'2026_06_25_043755_create_permission_tables',1),(6,'2026_06_25_043800_create_schools_table',1),(7,'2026_06_25_043801_create_academic_years_table',1),(8,'2026_06_25_043802_create_classes_table',1),(9,'2026_06_25_043803_create_building_areas_table',1),(10,'2026_06_25_043804_create_monitoring_sections_table',1),(11,'2026_06_25_043805_create_monitoring_items_table',1),(12,'2026_06_25_043806_create_daily_monitorings_table',1),(13,'2026_06_25_043807_create_general_monitorings_table',1),(14,'2026_06_25_043808_create_student_monitorings_table',1),(15,'2026_06_25_043809_create_cocurriculum_monitorings_table',1),(16,'2026_06_25_043810_create_class_monitorings_table',1),(17,'2026_06_25_043811_create_building_monitorings_table',1),(18,'2026_06_25_043812_create_monitoring_notes_table',1),(19,'2026_06_25_043818_add_school_fields_to_users_table',1),(20,'2026_06_25_125223_create_notifications_table',2),(21,'2026_06_25_130000_add_is_test_to_daily_monitorings_table',3);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(3,'App\\Models\\User',3),(4,'App\\Models\\User',4);

--
-- Table structure for table `monitoring_items`
--

CREATE TABLE `monitoring_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `monitoring_section_id` bigint unsigned NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` json DEFAULT NULL,
  `is_required` tinyint(1) NOT NULL DEFAULT '0',
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `monitoring_items_monitoring_section_id_foreign` (`monitoring_section_id`),
  CONSTRAINT `monitoring_items_monitoring_section_id_foreign` FOREIGN KEY (`monitoring_section_id`) REFERENCES `monitoring_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `monitoring_items`
--

INSERT INTO `monitoring_items` VALUES (1,1,'Persekitaran Sekolah','rating','[\"bersih\", \"sederhana\", \"memuaskan\"]',1,1,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(2,1,'Kantin','rating','[\"bersih\", \"sederhana\", \"memuaskan\"]',1,2,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(3,1,'Padang Permainan','rating','[\"bersih\", \"sederhana\", \"memuaskan\"]',1,3,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(4,1,'Tandas','rating','[\"bersih\", \"sederhana\", \"memuaskan\"]',1,4,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(5,2,'% Kehadiran','percentage',NULL,1,1,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(6,2,'Disiplin','select','[\"ada_kes\", \"tiada_kes\"]',1,2,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(7,2,'Catatan Disiplin','text',NULL,0,3,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(8,3,'Kegiatan Kokurikulum / Sukan','select','[\"ada\", \"tidak_ada\"]',1,1,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(9,3,'Catatan Kokurikulum','text',NULL,0,2,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40');

--
-- Table structure for table `monitoring_notes`
--

CREATE TABLE `monitoring_notes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `daily_monitoring_id` bigint unsigned NOT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci,
  `follow_up_actions` text COLLATE utf8mb4_unicode_ci,
  `recommendations` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `monitoring_notes_daily_monitoring_id_foreign` (`daily_monitoring_id`),
  CONSTRAINT `monitoring_notes_daily_monitoring_id_foreign` FOREIGN KEY (`daily_monitoring_id`) REFERENCES `daily_monitorings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `monitoring_notes`
--

INSERT INTO `monitoring_notes` VALUES (1,1,NULL,NULL,NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(4,4,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(5,5,'Kebersihan kawasan sekolah secara keseluruhannya memuaskan. Beberapa kawasan perlu penambahbaikan.',NULL,NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(6,6,'Kebersihan kawasan sekolah secara keseluruhannya memuaskan. Beberapa kawasan perlu penambahbaikan.','Menempah pengusaha untuk pembersihan kantin.',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(7,7,'Kebersihan kawasan sekolah secara keseluruhannya memuaskan. Beberapa kawasan perlu penambahbaikan.','Menghubungi ibu bapa murid yang tidak hadir.','Meningkatkan kerja sama dengan PIBG untuk kemudahan sekolah.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(8,11,'Bangunan sekolah dalam keadaan baik secara keseluruhan. Penyelenggaraan berkala perlu diteruskan.','Mengadakan mesyuarat dengan guru kelas berkenaan.',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(9,12,'Aktiviti kokurikulum berjalan lancar. Kehadiran murid dalam aktiviti adalah memberangsangkan.',NULL,'Menambah baik sistem penyelenggaraan bangunan secara berkala.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(10,13,'Kebersihan kawasan sekolah secara keseluruhannya memuaskan. Beberapa kawasan perlu penambahbaikan.','Mengadakan mesyuarat dengan guru kelas berkenaan.','Menambah baik sistem penyelenggaraan bangunan secara berkala.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(11,14,'Kehadiran murid pada hari ini agak rendah. Pihak sekolah perlu memberi perhatian kepada isu ini.','Mengeluarkan surat amaran kepada murid terlibat.',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(12,16,'Pemantauan mendapati beberapa kelas tidak melaksanakan PDPC. Tindakan susulan perlu diambil.','Menempah pengusaha untuk pembersihan kantin.',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(13,17,'Aktiviti kokurikulum berjalan lancar. Kehadiran murid dalam aktiviti adalah memberangsangkan.','Menghubungi ibu bapa murid yang tidak hadir.','Memperketatkan penguatkuasaan peraturan disiplin sekolah.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(14,18,'Aktiviti kokurikulum berjalan lancar. Kehadiran murid dalam aktiviti adalah memberangsangkan.','Mengadakan mesyuarat dengan guru kelas berkenaan.','Memastikan semua guru hadir mengikut jadual yang ditetapkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(15,19,'Kebersihan kawasan sekolah secara keseluruhannya memuaskan. Beberapa kawasan perlu penambahbaikan.','Membaiki kemudahan yang rosak dalam tempoh seminggu.','Memastikan semua guru hadir mengikut jadual yang ditetapkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(16,21,'Bangunan sekolah dalam keadaan baik secara keseluruhan. Penyelenggaraan berkala perlu diteruskan.','Menghubungi ibu bapa murid yang tidak hadir.',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(17,22,'Bangunan sekolah dalam keadaan baik secara keseluruhan. Penyelenggaraan berkala perlu diteruskan.',NULL,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(18,23,'Kebersihan kawasan sekolah secara keseluruhannya memuaskan. Beberapa kawasan perlu penambahbaikan.','Menghubungi ibu bapa murid yang tidak hadir.','Meningkatkan kerja sama dengan PIBG untuk kemudahan sekolah.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(19,24,'Kebersihan kawasan sekolah secara keseluruhannya memuaskan. Beberapa kawasan perlu penambahbaikan.',NULL,NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(20,25,'Pemantauan mendapati beberapa kelas tidak melaksanakan PDPC. Tindakan susulan perlu diambil.',NULL,'Memastikan semua guru hadir mengikut jadual yang ditetapkan.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(21,26,'Aktiviti kokurikulum berjalan lancar. Kehadiran murid dalam aktiviti adalah memberangsangkan.','Mengadakan mesyuarat dengan guru kelas berkenaan.','Menambah baik sistem penyelenggaraan bangunan secara berkala.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(22,27,'Pemantauan harian dijalankan dengan baik. Kebanyakan kelas melaksanakan PDPC seperti biasa.',NULL,'Meningkatkan kerja sama dengan PIBG untuk kemudahan sekolah.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(23,29,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46');

--
-- Table structure for table `monitoring_sections`
--

CREATE TABLE `monitoring_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `sort_order` int unsigned NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `monitoring_sections_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `monitoring_sections`
--

INSERT INTO `monitoring_sections` VALUES (1,'Pemantauan Umum','pemantauan-umum','General school environment monitoring',1,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(2,'Hal Ehwal Murid','hal-ehwal-murid','Student affairs monitoring',2,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(3,'Kokurikulum / Sukan','kokurikulum-sukan','Cocurricular and sports monitoring',3,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(4,'Pemantauan Keberadaan Guru','pemantauan-keberadaan-guru','Teacher presence and classroom monitoring',4,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(5,'Pemantauan Bangunan','pemantauan-bangunan','Building and facility monitoring',5,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40'),(6,'Catatan Guru Besar','catatan-guru-besar','Principal notes and remarks',6,1,NULL,'2026-06-24 21:36:40','2026-06-24 21:36:40');

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`),
  KEY `notifications_notifiable_id_notifiable_type_index` (`notifiable_id`,`notifiable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'view_monitoring','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(2,'create_monitoring','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(3,'edit_monitoring','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(4,'delete_monitoring','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(5,'submit_monitoring','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(6,'reopen_monitoring','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(7,'manage_schools','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(8,'manage_classes','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(9,'manage_building_areas','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(10,'manage_templates','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(11,'manage_academic_years','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(12,'manage_users','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(13,'view_reports','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(14,'export_reports','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(15,'view_analytics','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(16,'view_audit_logs','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(17,'manage_notifications','web','2026-06-24 21:36:40','2026-06-24 21:36:40');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(1,2),(2,2),(3,2),(5,2),(8,2),(9,2),(13,2),(14,2),(15,2),(1,3),(2,3),(3,3),(5,3),(13,3),(15,3),(1,4),(13,4),(15,4);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'super_admin','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(2,'guru_besar','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(3,'penolong_kanan','web','2026-06-24 21:36:40','2026-06-24 21:36:40'),(4,'viewer','web','2026-06-24 21:36:40','2026-06-24 21:36:40');

--
-- Table structure for table `schools`
--

CREATE TABLE `schools` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `schools_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schools`
--

INSERT INTO `schools` VALUES (1,'Sekolah Kebangsaan Bukit Panau','SKBP','Sekolah Kebangsaan Bukit Panau, 17500 Tanah Merah Kelantan','03-61891234','skbp@moe.edu.my',1,NULL,NULL,'2026-06-24 21:36:40','2026-06-27 07:21:31');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('CPbisu8Q7hRJ045PMMSG53xD81IAspnH1JcREqg2',1,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Qoder/1.11.1 Chrome/138.0.7204.251 Electron/37.7.0 Safari/537.36','eyJfdG9rZW4iOiJDUndkdTZ2ZExIeXhkWjNpMzRqcGptVHdEYW1LdnlEMjJPRW9wUzVoIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwXC9kYXNoYm9hcmQiLCJyb3V0ZSI6ImRhc2hib2FyZCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sInVybCI6W10sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjoxLCJtb25pdG9yaW5nX3Rlc3RfbW9kZSI6ZmFsc2V9',1783378813),('scYPCLxvwpdvRW4bZBXyG1oJUAGPsGeF4TMeMmAc',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJIY1Rqeld6VEwzQ2Z5Z0MyU05IQlZDRG9JcWFvQ3llWjdCT2VsQkJZIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwMDBcL2Rhc2hib2FyZCJ9LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwMDBcL2xvZ2luIiwicm91dGUiOiJsb2dpbiJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19',1783378813);

--
-- Table structure for table `student_monitorings`
--

CREATE TABLE `student_monitorings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `daily_monitoring_id` bigint unsigned NOT NULL,
  `attendance_percentage` decimal(5,2) DEFAULT NULL,
  `discipline_cases` enum('ada_kes','tiada_kes') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discipline_remarks` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_monitorings_daily_monitoring_id_foreign` (`daily_monitoring_id`),
  CONSTRAINT `student_monitorings_daily_monitoring_id_foreign` FOREIGN KEY (`daily_monitoring_id`) REFERENCES `daily_monitorings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_monitorings`
--

INSERT INTO `student_monitorings` VALUES (1,1,50.00,'tiada_kes',NULL,'2026-06-25 04:53:21','2026-06-25 05:10:36'),(4,4,NULL,NULL,NULL,'2026-07-05 12:15:11','2026-07-05 12:15:11'),(5,5,96.30,'ada_kes','Murid tidak memakai lencana sekolah.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(6,6,92.90,'tiada_kes',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(7,7,93.40,'ada_kes','Murid tidak memakai lencana sekolah.','2026-07-05 15:42:19','2026-07-05 15:42:19'),(8,8,97.90,'tiada_kes',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(9,9,94.00,'tiada_kes',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(10,10,94.00,'tiada_kes',NULL,'2026-07-05 15:42:19','2026-07-05 15:42:19'),(11,11,94.60,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(12,12,98.80,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(13,13,94.70,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(14,14,93.30,'ada_kes','Murid tidak memakai lencana sekolah.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(15,15,91.30,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(16,16,92.00,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(17,17,94.30,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(18,18,86.40,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(19,19,86.00,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(20,20,95.80,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(21,21,91.80,'ada_kes','Kes ponteng kelas oleh 2 orang murid.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(22,22,95.30,'ada_kes','Kes ponteng kelas oleh 2 orang murid.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(23,23,87.90,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(24,24,98.50,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(25,25,87.90,'ada_kes','Terdapat kes buli di kawasan kantin, telah dirawat.','2026-07-05 15:42:20','2026-07-05 15:42:20'),(26,26,91.70,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(27,27,97.20,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(28,28,91.90,'tiada_kes',NULL,'2026-07-05 15:42:20','2026-07-05 15:42:20'),(29,29,NULL,NULL,NULL,'2026-07-05 17:50:49','2026-07-06 12:34:46');

--
-- Dumping routines for database 'spgb'
--


