public function indexAction()
{
$practiceSchedule = new en\PracticeSchedule();
$practiceSchedule->setSportId($_POST["sport"]);
$practiceSchedule->setResourceId($_POST["location"]);
$practiceSchedule->setPractiseDate($_POST["date"] + "-" + $_POST["month"] + "2016");
$practiceSchedule->setPractiseStartTime($_POST["start_hour"] . ":" . $_POST["start_minutes"] . ":00");
$practiceSchedule->setPractiseEndTime($_POST["end_hour"] . ":" . $_POST["end_minutes"] . ":00");
$practiceSchedule->setAuthor($_POST["author"]);
$practiceSchedule->setStatus("Active");
$isEventAdded = cont\PracticeScheduleDBaccess::saveScheduledEvent($practiceSchedule);
if ($isEventAdded) {
return $this->render('SportBundle:Default:success.html.twig');
} else {
return $this->render('SportBundle:Default:success.html.twig');
}
}
public static function getAllLocationSchedule($resource_id)
{
$stm = null;
try {
$conn = connection::getConnectionObject();
$con = $conn->getConnection();
$stm = $con->stmt_init();
$stm->prepare("SELECT sport_id,practiceDate,practiceStartTime,locationName,author,status,practiceEndTime FROM practiceschedule NATURAL JOIN location where location.resource_id=?");
$stm->bind_param("s", $resource_id);
$stm->execute();
$result = $stm->get_result();
$practiceScheduleArray = array();
while ($row = $result->fetch_assoc()) {
$practiceSchedule = new PracticeSchedule();
$stm_sport = $con->stmt_init();
$stm_sport->prepare("SELECT name FROM sport where sport.sport_id=?");
$stm_sport->bind_param("s", $row["sport_id"]);
$stm_sport->execute();
$result_sport = $stm_sport->get_result();
$row_sport = $result_sport->fetch_assoc();
$practiceSchedule->setSportName($row_sport["name"]);
$practiceSchedule->setPractiseDate($row["practiceDate"]);
$practiceSchedule->setPractiseStartTime($row["practiceStartTime"]);
$practiceSchedule->setResourceName($row["locationName"]);
$practiceSchedule->setPractiseEndTime($row["practiceEndTime"]);
$practiceSchedule->setAuthor($row["author"]);
$practiceSchedule->setStatus($row["status"]);
$practiceScheduleArray[] = $practiceSchedule;
//array_push($practiceScheduleArray, );
}
return $practiceScheduleArray;
} catch (Exception $e) {
return "error";
} finally {
//$conn->close();
//$stm->close();
}
}
