public function getAllFloras()
{
$db = new Db();
$floras = array();
$results = $db->select("SELECT\r\n research.rid AS 'rid',\r\n research.date AS 'date',\r\n research.weather AS 'weather',\r\n research.plantName AS 'plantName',\r\n research.location AS 'location',\r\n research.additionalNote AS 'additionalNote',\r\n soiltype.soilName AS 'soilType_idsoilType',\r\n research.users_user_id AS 'users_user_id',\r\n users.user_name as 'userName'\r\n FROM research\r\n INNER JOIN soiltype ON\r\n research.soilType_idsoilType = soiltype.idsoilType\r\n INNER JOIN users ON\r\n research.users_user_id = users.user_id\r\n ORDER BY rid DESC;");
foreach ($results as $result) {
$flora = new Flora();
$flora->hydrate($result);
$floras[] = $flora;
}
return $floras;
}
case 'add_flora':
$floraManager = new FloraManager();
$flora = new Flora();
include '../views/guest_flora_add_edit.php';
break;
case 'save_flora':
$floraManager = new FloraManager();
$arr = array();
$arr["rid"] = isset($_GET["rid"]) ? $_GET["rid"] : '';
$arr["users_user_id"] = 3;
$arr["date"] = isset($_GET["date"]) ? $_GET["date"] : '';
$arr["weather"] = isset($_GET["weather"]) ? $_GET["weather"] : '';
$arr["plantName"] = isset($_GET["plantName"]) ? $_GET["plantName"] : '';
$arr["location"] = isset($_GET["location"]) ? $_GET["location"] : '';
$arr["additionalNote"] = isset($_GET["additionalNote"]) ? $_GET["additionalNote"] : '';
$arr["soilType_idsoilType"] = isset($_GET["soilType"]) ? $_GET["soilType"] : '';
$flora = new Flora();
$flora->hydrate($arr);
$floraManager->save($flora);
include '../views/thank_you.php';
break;
default:
$floraManager = new FloraManager();
$flora = new Flora();
include '../views/guest_flora_add_edit.php';
break;
}
?>
</body>
</html>
