{"success":true,"summary":{"total_subscriptions":41,"overdue_count":23,"due_soon_count":0,"valid_count":17},"overdue":[{"id":"3","sim_card_no":"8024 2352","company_name":"Gamuda Berhad Singapore Branch","project_name":"DE142","system_name":"Auto silt stopper","system_sn":"ENV2026003","date_of_activation":"2024-03-18","next_renewal":"2025-03-18","days_left":"-393"},{"id":"2","sim_card_no":"80242352","company_name":"Gamuda Berhad Singapore Branch","project_name":"DE142","system_name":"Auto silt stopper","system_sn":"ENV2026002","date_of_activation":"2024-03-18","next_renewal":"2025-03-18","days_left":"-393"},{"id":"6","sim_card_no":"8911 5227","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026006","date_of_activation":"2024-07-08","next_renewal":"2025-07-08","days_left":"-281"},{"id":"5","sim_card_no":"8081 6521","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026005","date_of_activation":"2024-07-08","next_renewal":"2025-07-08","days_left":"-281"},{"id":"4","sim_card_no":"8903 4760","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026004","date_of_activation":"2024-07-08","next_renewal":"2025-07-08","days_left":"-281"},{"id":"12","sim_card_no":"8016 3985","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026012","date_of_activation":"2024-09-04","next_renewal":"2025-09-04","days_left":"-223"},{"id":"19","sim_card_no":"87938639","company_name":"China Communications Construction Company Limited (Singapore Branch)","project_name":"CR109","system_name":"Auto silt stopper","system_sn":"ENV2026019","date_of_activation":"2024-09-09","next_renewal":"2025-09-09","days_left":"-218"},{"id":"11","sim_card_no":"8834 8203","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026011","date_of_activation":"2024-09-12","next_renewal":"2025-09-12","days_left":"-215"},{"id":"13","sim_card_no":"80252925","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026013","date_of_activation":"2024-10-08","next_renewal":"2025-10-08","days_left":"-189"},{"id":"14","sim_card_no":"87685203-C","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026014","date_of_activation":"2024-10-22","next_renewal":"2025-10-22","days_left":"-175"},{"id":"18","sim_card_no":"87804651","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026018","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171"},{"id":"17","sim_card_no":"87680967","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026017","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171"},{"id":"16","sim_card_no":"89237943-C","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026016","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171"},{"id":"15","sim_card_no":"89235180-C","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026015","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171"},{"id":"20","sim_card_no":"87921059","company_name":"China Communications Construction Company Limited (Singapore Branch)","project_name":"CR109","system_name":"Auto silt stopper","system_sn":"ENV2026020","date_of_activation":"2024-10-29","next_renewal":"2025-10-29","days_left":"-168"},{"id":"21","sim_card_no":"87845695","company_name":"Samsung C&T Corporation","project_name":"T313","system_name":"Auto silt stopper","system_sn":"ENV2026021","date_of_activation":"2024-12-21","next_renewal":"2025-12-21","days_left":"-115"},{"id":"22","sim_card_no":"89503721","company_name":"QingJian International (South Pacific) Group Development Co., Pte Ltd","project_name":"WDL N9C10","system_name":"Auto silt stopper","system_sn":"ENV2026022","date_of_activation":"2024-12-31","next_renewal":"2025-12-31","days_left":"-105"},{"id":"23","sim_card_no":"87480236","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026023","date_of_activation":"2025-03-22","next_renewal":"2026-03-22","days_left":"-24"},{"id":"39","sim_card_no":"00000000","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 18","system_name":"PUB-SIDS CCTV","system_sn":"GK5109743","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15"},{"id":"38","sim_card_no":"88671514","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 22","system_name":"PUB-SIDS CCTV","system_sn":"GK5123645","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15"},{"id":"37","sim_card_no":"88674635","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 16","system_name":"PUB-SIDS CCTV","system_sn":"GK5123640","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15"},{"id":"36","sim_card_no":"88678569","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 11","system_name":"PUB-SIDS CCTV","system_sn":"GK5123690","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15"},{"id":"35","sim_card_no":"88671906","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 5","system_name":"PUB-SIDS CCTV","system_sn":"GK5124140","date_of_activation":"2026-12-12","next_renewal":"2026-03-31","days_left":"-15"}],"due_soon":[],"all_records":[{"id":"41","sim_card_no":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"BULIM PHASE2","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","system_sn":"","date_of_activation":"0000-00-00","next_renewal":"0000-00-00","days_left":null,"status":"Unknown","status_color":"gray"},{"id":"3","sim_card_no":"8024 2352","company_name":"Gamuda Berhad Singapore Branch","project_name":"DE142","system_name":"Auto silt stopper","system_sn":"ENV2026003","date_of_activation":"2024-03-18","next_renewal":"2025-03-18","days_left":"-393","status":"Overdue","status_color":"red"},{"id":"2","sim_card_no":"80242352","company_name":"Gamuda Berhad Singapore Branch","project_name":"DE142","system_name":"Auto silt stopper","system_sn":"ENV2026002","date_of_activation":"2024-03-18","next_renewal":"2025-03-18","days_left":"-393","status":"Overdue","status_color":"red"},{"id":"6","sim_card_no":"8911 5227","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026006","date_of_activation":"2024-07-08","next_renewal":"2025-07-08","days_left":"-281","status":"Overdue","status_color":"red"},{"id":"5","sim_card_no":"8081 6521","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026005","date_of_activation":"2024-07-08","next_renewal":"2025-07-08","days_left":"-281","status":"Overdue","status_color":"red"},{"id":"4","sim_card_no":"8903 4760","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026004","date_of_activation":"2024-07-08","next_renewal":"2025-07-08","days_left":"-281","status":"Overdue","status_color":"red"},{"id":"12","sim_card_no":"8016 3985","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026012","date_of_activation":"2024-09-04","next_renewal":"2025-09-04","days_left":"-223","status":"Overdue","status_color":"red"},{"id":"19","sim_card_no":"87938639","company_name":"China Communications Construction Company Limited (Singapore Branch)","project_name":"CR109","system_name":"Auto silt stopper","system_sn":"ENV2026019","date_of_activation":"2024-09-09","next_renewal":"2025-09-09","days_left":"-218","status":"Overdue","status_color":"red"},{"id":"11","sim_card_no":"8834 8203","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026011","date_of_activation":"2024-09-12","next_renewal":"2025-09-12","days_left":"-215","status":"Overdue","status_color":"red"},{"id":"13","sim_card_no":"80252925","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026013","date_of_activation":"2024-10-08","next_renewal":"2025-10-08","days_left":"-189","status":"Overdue","status_color":"red"},{"id":"14","sim_card_no":"87685203-C","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026014","date_of_activation":"2024-10-22","next_renewal":"2025-10-22","days_left":"-175","status":"Overdue","status_color":"red"},{"id":"18","sim_card_no":"87804651","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026018","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171","status":"Overdue","status_color":"red"},{"id":"17","sim_card_no":"87680967","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026017","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171","status":"Overdue","status_color":"red"},{"id":"16","sim_card_no":"89237943-C","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026016","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171","status":"Overdue","status_color":"red"},{"id":"15","sim_card_no":"89235180-C","company_name":"Samsung C&T Corporation","project_name":"N106","system_name":"Auto silt stopper","system_sn":"ENV2026015","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","days_left":"-171","status":"Overdue","status_color":"red"},{"id":"20","sim_card_no":"87921059","company_name":"China Communications Construction Company Limited (Singapore Branch)","project_name":"CR109","system_name":"Auto silt stopper","system_sn":"ENV2026020","date_of_activation":"2024-10-29","next_renewal":"2025-10-29","days_left":"-168","status":"Overdue","status_color":"red"},{"id":"21","sim_card_no":"87845695","company_name":"Samsung C&T Corporation","project_name":"T313","system_name":"Auto silt stopper","system_sn":"ENV2026021","date_of_activation":"2024-12-21","next_renewal":"2025-12-21","days_left":"-115","status":"Overdue","status_color":"red"},{"id":"22","sim_card_no":"89503721","company_name":"QingJian International (South Pacific) Group Development Co., Pte Ltd","project_name":"WDL N9C10","system_name":"Auto silt stopper","system_sn":"ENV2026022","date_of_activation":"2024-12-31","next_renewal":"2025-12-31","days_left":"-105","status":"Overdue","status_color":"red"},{"id":"23","sim_card_no":"87480236","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026023","date_of_activation":"2025-03-22","next_renewal":"2026-03-22","days_left":"-24","status":"Overdue","status_color":"red"},{"id":"39","sim_card_no":"00000000","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 18","system_name":"PUB-SIDS CCTV","system_sn":"GK5109743","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15","status":"Overdue","status_color":"red"},{"id":"38","sim_card_no":"88671514","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 22","system_name":"PUB-SIDS CCTV","system_sn":"GK5123645","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15","status":"Overdue","status_color":"red"},{"id":"37","sim_card_no":"88674635","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 16","system_name":"PUB-SIDS CCTV","system_sn":"GK5123640","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15","status":"Overdue","status_color":"red"},{"id":"36","sim_card_no":"88678569","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 11","system_name":"PUB-SIDS CCTV","system_sn":"GK5123690","date_of_activation":"2026-02-12","next_renewal":"2026-03-31","days_left":"-15","status":"Overdue","status_color":"red"},{"id":"35","sim_card_no":"88671906","company_name":"Samsung C&T Corporation","project_name":"N106-ECM 5","system_name":"PUB-SIDS CCTV","system_sn":"GK5124140","date_of_activation":"2026-12-12","next_renewal":"2026-03-31","days_left":"-15","status":"Overdue","status_color":"red"},{"id":"24","sim_card_no":"87809361","company_name":"KIMLY CONSTRUCTION PTE LTD","project_name":"NUS","system_name":"Solar Power Backup (60W/30Ah)","system_sn":"ENV2026024","date_of_activation":"2025-09-03","next_renewal":"2026-09-03","days_left":"141","status":"Valid","status_color":"green"},{"id":"25","sim_card_no":"87685203","company_name":"Kimly Construction Pte Ltd","project_name":"KBGC3","system_name":"Auto silt stopper","system_sn":"ENV2026025","date_of_activation":"2025-10-07","next_renewal":"2026-10-07","days_left":"175","status":"Valid","status_color":"green"},{"id":"26","sim_card_no":"89237943","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026026","date_of_activation":"2025-10-10","next_renewal":"2026-10-10","days_left":"178","status":"Valid","status_color":"green"},{"id":"10","sim_card_no":"87425648","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026010","date_of_activation":"2025-10-10","next_renewal":"2026-10-10","days_left":"178","status":"Valid","status_color":"green"},{"id":"9","sim_card_no":"87933921","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026009","date_of_activation":"2025-10-10","next_renewal":"2026-10-10","days_left":"178","status":"Valid","status_color":"green"},{"id":"8","sim_card_no":"87422093","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026008","date_of_activation":"2025-10-10","next_renewal":"2026-10-10","days_left":"178","status":"Valid","status_color":"green"},{"id":"7","sim_card_no":"87689565","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026007","date_of_activation":"2025-10-10","next_renewal":"2026-10-10","days_left":"178","status":"Valid","status_color":"green"},{"id":"1","sim_card_no":"87684303","company_name":"Samsung C&T Corporation","project_name":"CR112","system_name":"Auto silt stopper","system_sn":"ENV2026001","date_of_activation":"2025-07-27","next_renewal":"2026-10-10","days_left":"178","status":"Valid","status_color":"green"},{"id":"40","sim_card_no":"0000000","company_name":"BHCC Construction Pte Ltd","project_name":"KWC64","system_name":"WBGT-Heat Stress Monitoring","system_sn":"A865661070041002","date_of_activation":"2025-11-28","next_renewal":"2026-11-28","days_left":"227","status":"Valid","status_color":"green"},{"id":"27","sim_card_no":"87931465","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR211","system_name":"Auto silt stopper","system_sn":"ENV2026027","date_of_activation":"2025-12-27","next_renewal":"2026-12-27","days_left":"256","status":"Valid","status_color":"green"},{"id":"28","sim_card_no":"87932745","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"B202","system_name":"Auto silt stopper","system_sn":"ENV2026028","date_of_activation":"2026-01-31","next_renewal":"2027-01-31","days_left":"291","status":"Valid","status_color":"green"},{"id":"31","sim_card_no":"89236385","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"BUL2","system_name":"Auto silt stopper","system_sn":"ENV2026031","date_of_activation":"2026-03-02","next_renewal":"2027-03-02","days_left":"321","status":"Valid","status_color":"green"},{"id":"32","sim_card_no":"88675483","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"B202","system_name":"Auto silt stopper","system_sn":"ENV2026032","date_of_activation":"2026-03-12","next_renewal":"2027-03-12","days_left":"331","status":"Valid","status_color":"green"},{"id":"30","sim_card_no":"88671492","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR206","system_name":"Auto silt stopper","system_sn":"ENV2026030","date_of_activation":"2026-03-13","next_renewal":"2027-03-13","days_left":"332","status":"Valid","status_color":"green"},{"id":"29","sim_card_no":"88671492","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR206","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","system_sn":"ENV2026030","date_of_activation":"2026-03-13","next_renewal":"2027-03-13","days_left":"332","status":"Valid","status_color":"green"},{"id":"33","sim_card_no":"80917842","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR211","system_name":"Auto silt stopper","system_sn":"ENV2026033","date_of_activation":"2026-03-16","next_renewal":"2027-03-16","days_left":"335","status":"Valid","status_color":"green"},{"id":"34","sim_card_no":"88670611","company_name":"KTC Civil Engineering & Construction Pte Ltd","project_name":"CR211","system_name":"Auto silt stopper","system_sn":"ENV2026034","date_of_activation":"2026-03-22","next_renewal":"2027-03-22","days_left":"341","status":"Valid","status_color":"green"}]}