Notice: Undefined index: YEAR in C:\Server\data\htdocs\api\application\controller\master\StationAPIController.php on line 1964

Notice: Undefined index: pageNo-group in C:\Server\data\htdocs\api\application\controller\master\StationAPIController.php on line 1972
{"status":500,"request":{"\/master\/Station\/getCountManualWaterQualityStatusGroupBySubBasin\/":"","\/front\/main\/Home\/getRpt2Data":""},"totalRecord":0,"recordPerPage":100000,"totalPage":0,"message":"SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type date: \"-01-01\"\nLINE 10: AND ((q.\"DATE\" >= '-01-01') AND (q.\"D...\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 sb.\"WAT...', NULL)\n#2 C:\\Server\\data\\htdocs\\api\\application\\query\\QUERY_STATION.php(398): JDatabase->query(' SELECT sb.\"WAT...', NULL, 1, 100000)\n#3 C:\\Server\\data\\htdocs\\libraries\\apicontroller.php(319): QUERY_STATION->getCountManualWaterQualityStatusGroupBySubBasin('array', 'AND ((q.\"DATE...', ' ORDER BY sb.\"W...', 1, 100000)\n#4 C:\\Server\\data\\htdocs\\api\\application\\controller\\master\\StationAPIController.php(1967): MAPIController->getListAPI_method('WHERE ((q.\"DAT...', 'STATION', 'getCountManualW...', '', Object(JDatabase))\n#5 C:\\Server\\data\\htdocs\\api\\index.php(79): StationAPIController->getCountManualWaterQualityStatusGroupBySubBasin()\n#6 {main} \/ SQL IS SELECT sb.\"WATER_SOURCE_ID\", sb.\"WATER_SOURCE_NAME\", q.\"WATER_QUALITY_STATUS\", COUNT(q.\"WATER_QUALITY_ID\") as \"COUNT_OF_DATA\"\r\n FROM \"STATION\" tbl\r\n JOIN \"WATER_SOURCE\" sb\r\n ON tbl.\"WATER_SOURCE_ID\" = sb.\"WATER_SOURCE_ID\"\r\n JOIN \"WATER_QUALITY\" q\r\n ON tbl.\"STATION_ID\" = q.\"STATION_ID\"\r\n\t\t\t\t\tLEFT JOIN \"PROVINCE\" province\r\n\t\t\t\t\tON tbl.\"PROVINCE_ID\" = province.\"PROVINCE_ID\"\r\n WHERE ((tbl.\"STATION_AUTO_FLAG\" = '0') OR (tbl.\"STATION_AUTO_FLAG\" IS NULL) )\r\n AND ((q.\"DATE\" >= '-01-01') AND (q.\"DATE\" <= '-12-31'))\r\n GROUP BY sb.\"WATER_SOURCE_ID\", sb.\"WATER_SOURCE_NAME\", q.\"WATER_QUALITY_STATUS\" ORDER BY sb.\"WATER_SOURCE_NAME\" LIMIT 100000 OFFSET 0 ","data":[]}URL : https://rwater.mnre.go.th/api/master/Station/getCountManualWaterQualityStatusGroupBySubBasin/
Notice: Undefined index: YEAR in C:\Server\data\htdocs\api\application\controller\master\StationAPIController.php on line 1964

Notice: Undefined index: pageNo-group in C:\Server\data\htdocs\api\application\controller\master\StationAPIController.php on line 1972
{"status":500,"request":{"\/master\/Station\/getCountManualWaterQualityStatusGroupBySubBasin\/":"","\/front\/main\/Home\/getRpt2Data":""},"totalRecord":0,"recordPerPage":100000,"totalPage":0,"message":"SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type date: \"-01-01\"\nLINE 10: AND ((q.\"DATE\" >= '-01-01') AND (q.\"D...\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 sb.\"WAT...', NULL)\n#2 C:\\Server\\data\\htdocs\\api\\application\\query\\QUERY_STATION.php(398): JDatabase->query(' SELECT sb.\"WAT...', NULL, 1, 100000)\n#3 C:\\Server\\data\\htdocs\\libraries\\apicontroller.php(319): QUERY_STATION->getCountManualWaterQualityStatusGroupBySubBasin('array', 'AND ((q.\"DATE...', ' ORDER BY sb.\"W...', 1, 100000)\n#4 C:\\Server\\data\\htdocs\\api\\application\\controller\\master\\StationAPIController.php(1967): MAPIController->getListAPI_method('WHERE ((q.\"DAT...', 'STATION', 'getCountManualW...', '', Object(JDatabase))\n#5 C:\\Server\\data\\htdocs\\api\\index.php(79): StationAPIController->getCountManualWaterQualityStatusGroupBySubBasin()\n#6 {main} \/ SQL IS SELECT sb.\"WATER_SOURCE_ID\", sb.\"WATER_SOURCE_NAME\", q.\"WATER_QUALITY_STATUS\", COUNT(q.\"WATER_QUALITY_ID\") as \"COUNT_OF_DATA\"\r\n FROM \"STATION\" tbl\r\n JOIN \"WATER_SOURCE\" sb\r\n ON tbl.\"WATER_SOURCE_ID\" = sb.\"WATER_SOURCE_ID\"\r\n JOIN \"WATER_QUALITY\" q\r\n ON tbl.\"STATION_ID\" = q.\"STATION_ID\"\r\n\t\t\t\t\tLEFT JOIN \"PROVINCE\" province\r\n\t\t\t\t\tON tbl.\"PROVINCE_ID\" = province.\"PROVINCE_ID\"\r\n WHERE ((tbl.\"STATION_AUTO_FLAG\" = '0') OR (tbl.\"STATION_AUTO_FLAG\" IS NULL) )\r\n AND ((q.\"DATE\" >= '-01-01') AND (q.\"DATE\" <= '-12-31'))\r\n GROUP BY sb.\"WATER_SOURCE_ID\", sb.\"WATER_SOURCE_NAME\", q.\"WATER_QUALITY_STATUS\" ORDER BY sb.\"WATER_SOURCE_NAME\" LIMIT 100000 OFFSET 0 ","data":[]}
Error - Send Data is Array ( [/front/main/Home/getRpt2Data] => )