Notice: Undefined index: YEAR in C:\Server\data\htdocs\api\application\controller\master\StationAPIController.php on line 1457
{"status":500,"request":{"\/master\/Station\/getWQIStatusGroupByQuater\/":"","\/front\/main\/Home\/getRpt42Data":""},"totalPage":0,"message":"SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type date: \"-10-01\"\nLINE 15: WHERE ((wq.\"DATE\" >= '-10-01') AND (wq.\"DAT...\n ^#0 C:\\Server\\data\\htdocs\\libraries\\database\\jdatabase.php(74): PDOStatement->execute()\n#1 C:\\Server\\data\\htdocs\\libraries\\database\\jdatabase.php(94): JDatabase->executeQuery(' SELECT ws.\"WAT...', NULL)\n#2 C:\\Server\\data\\htdocs\\api\\application\\query\\QUERY_STATION.php(253): JDatabase->query(' SELECT ws.\"WAT...', NULL, 1, 100000)\n#3 C:\\Server\\data\\htdocs\\libraries\\apicontroller.php(319): QUERY_STATION->getStationWithWQIGroupBySubBasin('array', 'WHERE ((wq.\"DA...', ' ORDER BY ws.\"W...', 1, 100000)\n#4 C:\\Server\\data\\htdocs\\api\\application\\controller\\master\\StationAPIController.php(1527): MAPIController->getListAPI_method('WHERE ((wq.\"DA...', 'STATION', 'getStationWithW...', '', Object(JDatabase))\n#5 C:\\Server\\data\\htdocs\\api\\index.php(79): StationAPIController->getWQIStatusGroupByQuater()\n#6 {main} \/ SQL IS SELECT ws.\"WATER_SOURCE_ID\" AS \"DATA_ID\", ws.\"WATER_SOURCE_NAME\" AS \"DATA_NAME\", AVG(wq.\"WQI\") AS \"WQI\", CEIL(AVG(wq.\"WQI_STATUS\")) AS \"WQI_STATUS\", AVG(wq.\"WQI_STATUS\") AS \"AVG_WQI_STATUS\"\r\n FROM \"WATER_QUALITY\" wq \r\n JOIN \"STATION\" tbl\r\n ON tbl.\"STATION_ID\" = wq.\"STATION_ID\"\r\n LEFT JOIN \"ORGANIZATION\" o\r\n ON tbl.\"ORGANIZATION_ID\" = o.\"ORGANIZATION_ID\"\r\n LEFT JOIN \"SUB_BASIN\" sb\r\n ON tbl.\"SUB_BASIN_ID\" = sb.\"SUB_BASIN_ID\"\r\n LEFT JOIN \"WATER_SOURCE\" ws\r\n ON tbl.\"WATER_SOURCE_ID\" = ws.\"WATER_SOURCE_ID\"\r\n LEFT JOIN \"PROVINCE\" province\r\n ON province.\"PROVINCE_ID\" = tbl.\"PROVINCE_ID\"\r\n LEFT JOIN \"ORGANIZATION_PROVINCE\" op\r\n ON province.\"PROVINCE_ID\" = op.\"PROVINCE_ID\"\r\n WHERE ((wq.\"DATE\" >= '-10-01') AND (wq.\"DATE\" <= '-12-31'))\r\n GROUP BY ws.\"WATER_SOURCE_ID\", ws.\"WATER_SOURCE_NAME\" \r\n ORDER BY ws.\"WATER_SOURCE_NAME\" LIMIT 100000 OFFSET 0 ","data":[{"name":"\u0e14\u0e35\u0e21\u0e32\u0e01
(91-100)","data":["","","",""]},{"name":"\u0e14\u0e35
(71-90)","data":["","","",""]},{"name":"\u0e1e\u0e2d\u0e43\u0e0a\u0e49
(61-70)","data":["","","",""]},{"name":"\u0e40\u0e2a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e17\u0e23\u0e21
(31-60)","data":["","","",""]},{"name":"\u0e40\u0e2a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e17\u0e23\u0e21\u0e21\u0e32\u0e01
(0-30)","data":["","","",""]}]}URL : https://rwater.mnre.go.th/api/master/Station/getWQIStatusGroupByQuater/
Notice: Undefined index: YEAR in C:\Server\data\htdocs\api\application\controller\master\StationAPIController.php on line 1457
{"status":500,"request":{"\/master\/Station\/getWQIStatusGroupByQuater\/":"","\/front\/main\/Home\/getRpt42Data":""},"totalPage":0,"message":"SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type date: \"-10-01\"\nLINE 15: WHERE ((wq.\"DATE\" >= '-10-01') AND (wq.\"DAT...\n ^#0 C:\\Server\\data\\htdocs\\libraries\\database\\jdatabase.php(74): PDOStatement->execute()\n#1 C:\\Server\\data\\htdocs\\libraries\\database\\jdatabase.php(94): JDatabase->executeQuery(' SELECT ws.\"WAT...', NULL)\n#2 C:\\Server\\data\\htdocs\\api\\application\\query\\QUERY_STATION.php(253): JDatabase->query(' SELECT ws.\"WAT...', NULL, 1, 100000)\n#3 C:\\Server\\data\\htdocs\\libraries\\apicontroller.php(319): QUERY_STATION->getStationWithWQIGroupBySubBasin('array', 'WHERE ((wq.\"DA...', ' ORDER BY ws.\"W...', 1, 100000)\n#4 C:\\Server\\data\\htdocs\\api\\application\\controller\\master\\StationAPIController.php(1527): MAPIController->getListAPI_method('WHERE ((wq.\"DA...', 'STATION', 'getStationWithW...', '', Object(JDatabase))\n#5 C:\\Server\\data\\htdocs\\api\\index.php(79): StationAPIController->getWQIStatusGroupByQuater()\n#6 {main} \/ SQL IS SELECT ws.\"WATER_SOURCE_ID\" AS \"DATA_ID\", ws.\"WATER_SOURCE_NAME\" AS \"DATA_NAME\", AVG(wq.\"WQI\") AS \"WQI\", CEIL(AVG(wq.\"WQI_STATUS\")) AS \"WQI_STATUS\", AVG(wq.\"WQI_STATUS\") AS \"AVG_WQI_STATUS\"\r\n FROM \"WATER_QUALITY\" wq \r\n JOIN \"STATION\" tbl\r\n ON tbl.\"STATION_ID\" = wq.\"STATION_ID\"\r\n LEFT JOIN \"ORGANIZATION\" o\r\n ON tbl.\"ORGANIZATION_ID\" = o.\"ORGANIZATION_ID\"\r\n LEFT JOIN \"SUB_BASIN\" sb\r\n ON tbl.\"SUB_BASIN_ID\" = sb.\"SUB_BASIN_ID\"\r\n LEFT JOIN \"WATER_SOURCE\" ws\r\n ON tbl.\"WATER_SOURCE_ID\" = ws.\"WATER_SOURCE_ID\"\r\n LEFT JOIN \"PROVINCE\" province\r\n ON province.\"PROVINCE_ID\" = tbl.\"PROVINCE_ID\"\r\n LEFT JOIN \"ORGANIZATION_PROVINCE\" op\r\n ON province.\"PROVINCE_ID\" = op.\"PROVINCE_ID\"\r\n WHERE ((wq.\"DATE\" >= '-10-01') AND (wq.\"DATE\" <= '-12-31'))\r\n GROUP BY ws.\"WATER_SOURCE_ID\", ws.\"WATER_SOURCE_NAME\" \r\n ORDER BY ws.\"WATER_SOURCE_NAME\" LIMIT 100000 OFFSET 0 ","data":[{"name":"\u0e14\u0e35\u0e21\u0e32\u0e01
(91-100)","data":["","","",""]},{"name":"\u0e14\u0e35
(71-90)","data":["","","",""]},{"name":"\u0e1e\u0e2d\u0e43\u0e0a\u0e49
(61-70)","data":["","","",""]},{"name":"\u0e40\u0e2a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e17\u0e23\u0e21
(31-60)","data":["","","",""]},{"name":"\u0e40\u0e2a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e17\u0e23\u0e21\u0e21\u0e32\u0e01
(0-30)","data":["","","",""]}]}
Error - Send Data is Array ( [/front/main/Home/getRpt42Data] => )