{
    "success": true,
    "message": "ENV Master SIM Register loaded successfully",
    "server_time": "2026-09-20 22:53:29",
    "summary": {
        "total_sims": 40,
        "active": 40,
        "expired": 1,
        "due_soon": 1,
        "valid": 38,
        "no_renewal_date": 0,
        "damaged": 0,
        "suspended": 0,
        "replaced": 0,
        "projects": 22,
        "duplicate_sims": 0,
        "databases_checked": 24,
        "databases_with_sim_table": 22
    },
    "records": [
        {
            "database": "envcctv_nus",
            "project_name": "NUS",
            "id": 1,
            "username": "envrh14",
            "ecm_no": "1",
            "sim_card_number": "896503012405052328",
            "phone_number": "87809361",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-09-01",
            "next_renewal_date": "2026-09-01",
            "days_left": -19,
            "renewal_status": "Expired",
            "renewal_color": "red",
            "remarks": "",
            "created_at": "2026-09-08 09:26:10",
            "updated_at": "2026-09-08 09:26:10"
        },
        {
            "database": "envcctv_kbgc3",
            "project_name": "KBGC3",
            "id": 1,
            "username": "envrh15",
            "ecm_no": "1",
            "sim_card_number": "896503012307098163",
            "phone_number": "87685203",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-10-06",
            "next_renewal_date": "2026-10-06",
            "days_left": 16,
            "renewal_status": "Due Soon",
            "renewal_color": "orange",
            "remarks": "",
            "created_at": "2026-09-08 09:12:38",
            "updated_at": "2026-09-08 09:12:38"
        },
        {
            "database": "envcctv_sscr112",
            "project_name": "CR112",
            "id": 1,
            "username": "envrh12",
            "ecm_no": "1",
            "sim_card_number": "896503012307098158",
            "phone_number": "87684303",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-11-10",
            "next_renewal_date": "2026-11-10",
            "days_left": 51,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:00:08",
            "updated_at": "2026-09-08 08:10:33"
        },
        {
            "database": "envcctv_sscr112",
            "project_name": "CR112",
            "id": 2,
            "username": "envrh12",
            "ecm_no": "2",
            "sim_card_number": "896503012307098159",
            "phone_number": "87689565",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-11-10",
            "next_renewal_date": "2026-11-10",
            "days_left": 51,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:12:09",
            "updated_at": "2026-09-08 08:12:09"
        },
        {
            "database": "envcctv_sscr112",
            "project_name": "CR112",
            "id": 4,
            "username": "envrh12",
            "ecm_no": "4",
            "sim_card_number": "896503012307098157",
            "phone_number": "87933921",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-11-10",
            "next_renewal_date": "2026-11-10",
            "days_left": 51,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:16:48",
            "updated_at": "2026-09-08 08:16:48"
        },
        {
            "database": "envcctv_sscr112",
            "project_name": "CR112",
            "id": 5,
            "username": "envrh12",
            "ecm_no": "5",
            "sim_card_number": "896503012307098161",
            "phone_number": "87425648",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-11-10",
            "next_renewal_date": "2026-11-10",
            "days_left": 51,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:19:02",
            "updated_at": "2026-09-08 08:19:02"
        },
        {
            "database": "envcctv_sscr112",
            "project_name": "CR112",
            "id": 6,
            "username": "envrh12",
            "ecm_no": "6",
            "sim_card_number": "896503012307098160",
            "phone_number": "87422093",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-11-10",
            "next_renewal_date": "2026-11-10",
            "days_left": 51,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:22:50",
            "updated_at": "2026-09-08 08:22:50"
        },
        {
            "database": "envcctv_sscr112",
            "project_name": "CR112",
            "id": 7,
            "username": "envrh12",
            "ecm_no": "7",
            "sim_card_number": "896503012405052323",
            "phone_number": "89237943",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-11-10",
            "next_renewal_date": "2026-11-10",
            "days_left": 51,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:25:27",
            "updated_at": "2026-09-08 08:33:54"
        },
        {
            "database": "envcctv_cr109",
            "project_name": "CR109",
            "id": 1,
            "username": "cr109ecm",
            "ecm_no": "1",
            "sim_card_number": "896503012307098156",
            "phone_number": "87938639",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-09-09",
            "next_renewal_date": "2026-11-22",
            "days_left": 63,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:56:50",
            "updated_at": "2026-09-08 08:56:50"
        },
        {
            "database": "envcctv_cr109",
            "project_name": "CR109",
            "id": 2,
            "username": "cr109ecm",
            "ecm_no": "2",
            "sim_card_number": "896503012307098164",
            "phone_number": "87921059",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-10-29",
            "next_renewal_date": "2026-11-22",
            "days_left": 63,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:58:34",
            "updated_at": "2026-09-08 08:58:34"
        },
        {
            "database": "envcctv_ktccr211",
            "project_name": "KTC CR211",
            "id": 1,
            "username": "envrh9",
            "ecm_no": "1",
            "sim_card_number": "896503012405052327",
            "phone_number": "87931465",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2025-12-27",
            "next_renewal_date": "2026-12-27",
            "days_left": 98,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 07:32:20",
            "updated_at": "2026-09-08 07:52:04"
        },
        {
            "database": "envcctv_ktcb202",
            "project_name": "KTC B202",
            "id": 2,
            "username": "envrh18",
            "ecm_no": "2",
            "sim_card_number": "896503012307098162",
            "phone_number": "87932745",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-01-31",
            "next_renewal_date": "2027-01-31",
            "days_left": 133,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:06:42",
            "updated_at": "2026-09-08 09:06:42"
        },
        {
            "database": "envcctv_ktccr206",
            "project_name": "KTC CR206",
            "id": 1,
            "username": "envrh16",
            "ecm_no": "1",
            "sim_card_number": "896503012405052322",
            "phone_number": "89235180",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-02-10",
            "next_renewal_date": "2027-02-10",
            "days_left": 143,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:20:53",
            "updated_at": "2026-09-08 09:20:53"
        },
        {
            "database": "envcctv_ssn106",
            "project_name": "N106",
            "id": 2,
            "username": "samsungn106",
            "ecm_no": "11",
            "sim_card_number": "896503012509082615",
            "phone_number": "88678569",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-02-12",
            "next_renewal_date": "2027-02-12",
            "days_left": 145,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:39:22",
            "updated_at": "2026-09-08 08:39:22"
        },
        {
            "database": "envcctv_ssn106",
            "project_name": "N106",
            "id": 3,
            "username": "samsungn106",
            "ecm_no": "16",
            "sim_card_number": "896503012509082614",
            "phone_number": "88674635",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-02-12",
            "next_renewal_date": "2027-02-12",
            "days_left": 145,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:40:36",
            "updated_at": "2026-09-08 08:40:36"
        },
        {
            "database": "envcctv_ssn106",
            "project_name": "N106",
            "id": 4,
            "username": "samsungn106",
            "ecm_no": "18",
            "sim_card_number": "896503012405052329",
            "phone_number": "89503721",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-02-12",
            "next_renewal_date": "2027-02-12",
            "days_left": 145,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:42:38",
            "updated_at": "2026-09-08 08:42:38"
        },
        {
            "database": "envcctv_ssn106",
            "project_name": "N106",
            "id": 5,
            "username": "samsungn106",
            "ecm_no": "22",
            "sim_card_number": "896503012509082613",
            "phone_number": "88671514",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-02-12",
            "next_renewal_date": "2027-02-12",
            "days_left": 145,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:44:02",
            "updated_at": "2026-09-08 08:44:02"
        },
        {
            "database": "envcctv_ssn106",
            "project_name": "N106",
            "id": 1,
            "username": "samsungn106",
            "ecm_no": "5",
            "sim_card_number": "896503012509082606",
            "phone_number": "88671906",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-02-12",
            "next_renewal_date": "2027-02-12",
            "days_left": 145,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:37:16",
            "updated_at": "2026-09-08 08:37:16"
        },
        {
            "database": "envcctv_ktcbul2",
            "project_name": "KTC BUL2",
            "id": 1,
            "username": "envrh17",
            "ecm_no": "11",
            "sim_card_number": "896503012509082612",
            "phone_number": "89236385",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-03-02",
            "next_renewal_date": "2027-03-02",
            "days_left": 163,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:33:58",
            "updated_at": "2026-09-08 09:33:58"
        },
        {
            "database": "envcctv_ktcb202",
            "project_name": "KTC B202",
            "id": 1,
            "username": "envrh18",
            "ecm_no": "1",
            "sim_card_number": "896503012509082611",
            "phone_number": "88675483",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-03-04",
            "next_renewal_date": "2027-03-04",
            "days_left": 165,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:04:30",
            "updated_at": "2026-09-08 09:04:30"
        },
        {
            "database": "envcctv_ktccr206",
            "project_name": "KTC CR206",
            "id": 2,
            "username": "envrh16",
            "ecm_no": "2",
            "sim_card_number": "896503012509082607",
            "phone_number": "88671492",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-03-13",
            "next_renewal_date": "2027-03-13",
            "days_left": 174,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:22:36",
            "updated_at": "2026-09-08 09:22:36"
        },
        {
            "database": "envcctv_ktccr211",
            "project_name": "KTC CR211",
            "id": 5,
            "username": "envrh9",
            "ecm_no": "6",
            "sim_card_number": "896503012405052324",
            "phone_number": "87680967",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-03-16",
            "next_renewal_date": "2027-03-16",
            "days_left": 177,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 07:39:21",
            "updated_at": "2026-09-08 07:53:13"
        },
        {
            "database": "envcctv_sscr112",
            "project_name": "CR112",
            "id": 3,
            "username": "envrh12",
            "ecm_no": "3",
            "sim_card_number": "896503012405052331",
            "phone_number": "87480236",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-03-22",
            "next_renewal_date": "2027-03-22",
            "days_left": 183,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 08:14:23",
            "updated_at": "2026-09-08 08:14:23"
        },
        {
            "database": "envcctv_ktccr211",
            "project_name": "KTC CR211",
            "id": 2,
            "username": "envrh9",
            "ecm_no": "2",
            "sim_card_number": "896503012509082608",
            "phone_number": "88670611",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-03-22",
            "next_renewal_date": "2027-03-22",
            "days_left": 183,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 07:34:36",
            "updated_at": "2026-09-08 07:52:24"
        },
        {
            "database": "envcctv_ktccr211",
            "project_name": "KTC CR211",
            "id": 3,
            "username": "envrh9",
            "ecm_no": "3",
            "sim_card_number": "896503012509082609",
            "phone_number": "88674258",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-04-08",
            "next_renewal_date": "2027-04-08",
            "days_left": 200,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 07:36:09",
            "updated_at": "2026-09-08 07:52:44"
        },
        {
            "database": "envcctv_ktccr211",
            "project_name": "KTC CR211",
            "id": 4,
            "username": "envrh9",
            "ecm_no": "5",
            "sim_card_number": "896503012509082862",
            "phone_number": "88678559",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-04-08",
            "next_renewal_date": "2027-04-08",
            "days_left": 200,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 07:37:43",
            "updated_at": "2026-09-08 07:52:57"
        },
        {
            "database": "envcctv_de195",
            "project_name": "DE195",
            "id": 1,
            "username": "gammonde195",
            "ecm_no": "1",
            "sim_card_number": "896503012509082859",
            "phone_number": "89957696",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-06-24",
            "next_renewal_date": "2027-06-24",
            "days_left": 277,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:38:03",
            "updated_at": "2026-09-08 09:38:03"
        },
        {
            "database": "envcctv_kimlykbgc3",
            "project_name": "KIMLY KBGC3",
            "id": 1,
            "username": "kbgc3wbgt",
            "ecm_no": "1",
            "sim_card_number": "896503012601033488",
            "phone_number": "80917842",
            "purpose": "WBGT",
            "status": "Active",
            "activation_date": "2026-06-30",
            "next_renewal_date": "2027-06-30",
            "days_left": 283,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 10:13:55",
            "updated_at": "2026-09-08 10:13:55"
        },
        {
            "database": "envcctv_tss1",
            "project_name": "TSS 1",
            "id": 1,
            "username": "envrh2",
            "ecm_no": "1",
            "sim_card_number": "896503012509082867",
            "phone_number": "88671703",
            "purpose": "TSS1-Redhorn",
            "status": "Active",
            "activation_date": "2026-07-03",
            "next_renewal_date": "2027-07-03",
            "days_left": 286,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:58:12",
            "updated_at": "2026-09-08 09:58:12"
        },
        {
            "database": "envcctv_de195",
            "project_name": "DE195",
            "id": 2,
            "username": "gammonde195",
            "ecm_no": "2",
            "sim_card_number": "896503012509082858",
            "phone_number": "88672501",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-07-06",
            "next_renewal_date": "2027-07-06",
            "days_left": 289,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:39:44",
            "updated_at": "2026-09-08 09:39:44"
        },
        {
            "database": "envcctv_tss2",
            "project_name": "TSS 2",
            "id": 1,
            "username": "envrh3",
            "ecm_no": "1",
            "sim_card_number": "896503012509082865",
            "phone_number": "89523995",
            "purpose": "TSS2-Redhorn",
            "status": "Active",
            "activation_date": "2026-07-10",
            "next_renewal_date": "2027-07-10",
            "days_left": 293,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:56:00",
            "updated_at": "2026-09-08 09:56:00"
        },
        {
            "database": "envcctv_daa3",
            "project_name": "DAA 3",
            "id": 1,
            "username": "envrh6",
            "ecm_no": "1",
            "sim_card_number": "896503012509082866",
            "phone_number": "89952502",
            "purpose": "DAA3-redhorn",
            "status": "Active",
            "activation_date": "2026-07-18",
            "next_renewal_date": "2027-07-18",
            "days_left": 301,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 10:02:33",
            "updated_at": "2026-09-08 10:02:33"
        },
        {
            "database": "envcctv_daa4",
            "project_name": "DAA 4",
            "id": 1,
            "username": "envrh7",
            "ecm_no": "1",
            "sim_card_number": "896503012509082863",
            "phone_number": "80268579",
            "purpose": "DAA4-Redhorn",
            "status": "Active",
            "activation_date": "2026-07-30",
            "next_renewal_date": "2027-07-30",
            "days_left": 313,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:49:09",
            "updated_at": "2026-09-08 09:49:09"
        },
        {
            "database": "envcctv_daa6",
            "project_name": "DAA 6",
            "id": 1,
            "username": "envrh10",
            "ecm_no": "1",
            "sim_card_number": "896503012509082860",
            "phone_number": "89952721",
            "purpose": "DAA 6-Redhorn ",
            "status": "Active",
            "activation_date": "2026-07-30",
            "next_renewal_date": "2027-07-30",
            "days_left": 313,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:43:48",
            "updated_at": "2026-09-08 09:43:48"
        },
        {
            "database": "envcctv_tss3",
            "project_name": "TSS 3",
            "id": 1,
            "username": "envrh4",
            "ecm_no": "1",
            "sim_card_number": "896503012509082864",
            "phone_number": "80262051",
            "purpose": "TSS3-Redhorn",
            "status": "Active",
            "activation_date": "2026-07-30",
            "next_renewal_date": "2027-07-30",
            "days_left": 313,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:52:02",
            "updated_at": "2026-09-08 09:52:02"
        },
        {
            "database": "envcctv_daa5",
            "project_name": "DAA 5",
            "id": 1,
            "username": "envrh8",
            "ecm_no": "1",
            "sim_card_number": "896503012509082861",
            "phone_number": "89952074",
            "purpose": "DAA5-Redhorn",
            "status": "Active",
            "activation_date": "2026-07-31",
            "next_renewal_date": "2027-07-31",
            "days_left": 314,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:46:54",
            "updated_at": "2026-09-08 09:46:54"
        },
        {
            "database": "envcctv_tss5",
            "project_name": "TSS 5",
            "id": 1,
            "username": "envrh5",
            "ecm_no": "1",
            "sim_card_number": "896503012603011180",
            "phone_number": "89992096",
            "purpose": "TSS5-Redhorn",
            "status": "Active",
            "activation_date": "2026-08-03",
            "next_renewal_date": "2027-08-03",
            "days_left": 317,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 10:00:39",
            "updated_at": "2026-09-08 10:00:39"
        },
        {
            "database": "envcctv_tss4",
            "project_name": "TSS 4",
            "id": 1,
            "username": "envrh4",
            "ecm_no": "2",
            "sim_card_number": "896503012603011179",
            "phone_number": "89998055",
            "purpose": "TSS4-Redhorn",
            "status": "Active",
            "activation_date": "2026-08-05",
            "next_renewal_date": "2027-08-05",
            "days_left": 319,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:53:29",
            "updated_at": "2026-09-08 09:53:29"
        },
        {
            "database": "envcctv_ktct313",
            "project_name": "KTC T313",
            "id": 1,
            "username": "envrh13",
            "ecm_no": "1",
            "sim_card_number": "896503012405052326",
            "phone_number": "87845695",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2024-12-20",
            "next_renewal_date": "2027-09-05",
            "days_left": 350,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 09:30:36",
            "updated_at": "2026-09-08 09:30:36"
        },
        {
            "database": "envcctv_qjn9c10",
            "project_name": "QJ N9C10",
            "id": 1,
            "username": "envrh19",
            "ecm_no": "1",
            "sim_card_number": "896503012603011181",
            "phone_number": "87521384",
            "purpose": "Auto silt stopper",
            "status": "Active",
            "activation_date": "2026-09-07",
            "next_renewal_date": "2027-09-07",
            "days_left": 352,
            "renewal_status": "Valid",
            "renewal_color": "green",
            "remarks": "",
            "created_at": "2026-09-08 10:16:29",
            "updated_at": "2026-09-08 10:16:29"
        }
    ],
    "database_errors": [
        {
            "database": "envcctv_ktcklj",
            "project": "KTC KLJ",
            "error": "Access denied for user 'envcctv_ktcklj'@'localhost' (using password: YES)"
        }
    ]
}