<?php
session_start();
require_once "config.php";
require_once "time.php";
require_once "getters.php";
$db = loadDatabase();
$email = $_SESSION['user'];
$eventName = $_POST['eventName'];
$description = $_POST['description'];
$scheduleName = $_POST['scheduleName'];
$eventStartTime = $_POST['eventStartTime'];
$eventEndTime = $_POST['eventEndTime'];
$userId = getUserId($db, $scheduleName, $email);
$scheduleId = getScheduleId($db, $scheduleName, $userId);
$startTime = getStartTime($db, $scheduleName, $scheduleId);
$endTime = getEndTime($db, $scheduleName, $scheduleId);
$placeEvent = schedule($db, $scheduleId, $eventStartTime, $eventStartTime, $startTime, $endTime);
if ($placeEvent) {
addToDatabase($db, $eventName, $description, $eventStartTime, $eventEndTime, $scheduleId);
}
function schedule($db, $scheduleId, $eventStartTime, $eventEndTime, $startTime, $endTime)
{
$query = "SELECT startTime, endTime FROM scheduleEvent se JOIN event e WHERE scheduleId=:id AND eventId = e.id";
$query = $db->prepare($query);
$query->execute(array(':id' => $scheduleId));
$prevScheduledEnd;
$isFull = false;
foreach ($query->fetchAll() as $event) {
if (isset($prevScheduledEnd) && greaterThanOrEqualToTime($eventStartTime, $prevScheduledEnd) && greaterThanOrEqualToTime($event['startTime'], $eventEndTime)) {
return true;
function insertSchedule($user)
{
// should error check that all post fields are set
$name = $_POST["name"];
$description = $_POST["description"];
$contact = $_POST["contact"];
$start = $_POST["start"];
$end = $_POST["end"];
// $name,$description,$contact,$start,$end
// add to schedules if it doesnt' exist already
/*
if ( scheduleExists($name,$description,$contact,$start,$end) !== true)
if ( addSchedule($name,$description,$contact,$start,$end) !== true )
return "error adding to schedules";
*/
// return addSchedule($name,$description,$contact,$start,$end);
if (addSchedule($name, $description, $contact, $start, $end)) {
$scheduleId = getScheduleId($name, $description, $contact, $start, $end);
return $scheduleId;
$query = "insert into user_schedule ";
$query .= "(user,schedule) ";
$query .= "values ( {$user}, {$scheduleId}) ";
booleanReturn($query);
} else {
return "error inserting schedule";
}
// return "schedule id = " . $scheduleId;
// add to user_schedules if it doesn't already exist
/*
if ( userScheduleExists($user,$scheduleId) !== true)
{
// return "schedule $scheduleId exists";
if ( addUserSchedule($user,$scheduleId) !== true )
return "error adding to user_schedules";
else
return true;
}
else
{
return "existential problem. for $scheduleId";
}
*/
}
function parseInputs($user)
{
if (isset($_POST['func'])) {
$func = $_POST['func'];
// getters ===============================
if ($func === "getGoals") {
echo json_encode(getGoals($user));
}
if ($func === "getIndustries") {
echo json_encode(getIndustries($user));
}
if ($func === "getLocations") {
echo json_encode(getLocations($user));
}
if ($func === "getPostings") {
getPostings($user);
}
if ($func === "getContacts") {
echo json_encode(getContacts($user));
}
if ($func === "getSchedules") {
echo json_encode(getSchedules($user));
}
if ($func === "getCompanies") {
echo getCompanies($user);
}
if ($func === "getBlogId") {
echo json_encode(getBlogId($user, $_POST['title'], $_POST['text']));
}
if ($func === "getBlog") {
echo json_encode(getBlog($user));
}
if ($func === "getNotesOnPosting") {
$postingId = $_POST['postingId'];
echo json_encode(getNotesOnPosting($user, $postingId));
}
// inserters ===============================
if ($func === "insertGoal") {
if (isset($_POST["goal"]) && $_POST["goal"] !== '') {
echo json_encode(insertGoal($user, $_POST["goal"]));
}
}
if ($func === "insertIndustry") {
if (isset($_POST["industry"]) && $_POST["industry"] !== '') {
echo json_encode(insertIndustry($user, $_POST["industry"]));
}
}
if ($func === "insertCompany") {
$url = urldecode($_POST["url"]);
$companyName = $_POST["company"];
insertCompany($user, $companyName);
}
if ($func === "insertLocation") {
if (isset($_POST["location"]) && $_POST["location"] !== '') {
echo json_encode(insertLocation($user, $_POST["location"]));
}
}
if ($func === "insertPosting") {
echo json_encode(insertPosting($user));
}
if ($func === "insertContact") {
// more complex. will be responsible for getting $_POST
echo json_encode(insertContact($user));
}
if ($func === "insertSchedule") {
// more complex. will be responsible for getting $_POST
// echo json_encode(insertSchedule($user));
echo insertSchedule($user);
}
if ($func === "addSchedule") {
// more complex. will be responsible for getting $_POST
// echo json_encode(insertSchedule($user));
// echo "adding ZSchecdule";
$name = $_POST["name"];
$description = $_POST["description"];
$contact = $_POST["contact"];
$start = $_POST["start"];
$end = $_POST["end"];
// addSchedule($name,$description,$contact,$start,$end)
if (addSchedule($name, $description, $contact, $start, $end)) {
$scheduleId = getScheduleId($name, $description, $contact, $start, $end);
if ($scheduleId > 0) {
// echo $scheduleId;
// insert schedule id and user id to user_schedule
$query = "insert into user_schedule ";
$query .= "(user,schedule) ";
$query .= "values ( {$user}, ";
$query .= "{$scheduleId} ) ";
//return $query;
echo booleanEcho($query);
} else {
echo "error getting schedule id.";
}
} else {
echo "error inserting schedule.";
}
}
if ($func === "insertBlog") {
echo json_encode(insertBlog($user));
}
if ($func === "insertNotesPostingUser") {
// insertBlog, then insertNotesPostingUser
$noteId = insertBlog($user);
// $noteId = $_POST["noteId"];
$postingId = $_POST["postingId"];
echo json_encode(insertNotesPostingUser($noteId, $postingId, $user));
}
// removers ===============================
if ($func === "removeGoal") {
// url is the id for user_goals
if (isset($_POST["url"]) && $_POST["url"] !== '') {
echo json_encode(removeGoal($user, $_POST["url"]));
}
}
if ($func === "removeIndustry") {
// url is the id for user_industries
if (isset($_POST["url"]) && $_POST["url"] !== '') {
echo json_encode(removeIndustry($user, $_POST["url"]));
}
}
if ($func === "removeLocation") {
// url is the id for locations
if (isset($_POST["url"]) && $_POST["url"] !== '') {
echo json_encode(removeLocation($user, $_POST["url"]));
}
}
if ($func === "removeContact") {
// url is the id for user_contacts
if (isset($_POST["url"]) && $_POST["url"] !== '') {
echo json_encode(removeUserContact($user, $_POST["url"]));
}
}
if ($func === "removePosting") {
if (isset($_POST["url"]) && $_POST["url"] !== '') {
removePosting($user, $_POST["url"]);
}
}
if ($func === "removeCompany") {
$companyId = $_POST["url"];
// companyID is stored here
removeCompany($user, $companyId);
}
if ($func === "removeSchedule") {
$scheduleId = $_POST["url"];
// scheduleID is stored here
echo json_encode(removeSchedule($user, $scheduleId));
}
if ($func === "removeBlog") {
$userNoteId = $_POST["url"];
// need to get noteId from userNoteId
$noteId = getNoteIdFromUserNoteId($userNoteId);
if (removeNoteUser($user, $userNoteId) === true) {
if (removeNote($noteId) === true) {
echo json_encode(true);
} else {
echo json_encode("Error removing from notes.");
}
} else {
echo json_encode("Error removing from NoteUser.");
}
}
// updaters ===============================
if ($func === "updateGoal") {
echo json_encode(updateGoal($user));
}
if ($func === "updateIndustry") {
echo json_encode(updateIndustry($user));
}
if ($func === "updatePosting") {
updatePosting($user);
// returns on its own
}
if ($func === "updateContact") {
echo json_encode(updateContact($user));
}
}
}
/* Validating & Inserting the Data : Start */
if (strlen($msg) <= 0) {
try {
//$schStatus = validateSchedule($strCK_user_id, $strCk_user_client_id, '1');
$arrSchStatus = isAuthenticateScheduleUser($strCK_user_id, $strCk_user_client_id, $objDataHelper);
} catch (Exception $e) {
throw new Exception("createSchedule.php : validateSchedule Failed : " . $e->getMessage(), 1131);
}
if (is_array($arrSchStatus) && sizeof($arrSchStatus) > 0) {
try {
$voiceBridgeToken = voiceBridgeToken($objDataHelper);
} catch (Exception $e) {
throw new Exception("createSchedule.php : voiceBridgeToken Failed : " . $e->getMessage(), 1136);
}
try {
$schID = getScheduleId($objDataHelper);
} catch (Exception $e) {
throw new Exception("createSchedule.php : getScheduleId Failed : " . $e->getMessage(), 1138);
}
if (strlen($schID) > 0) {
try {
$meetingInstanceDtls = getLMInstanceByClientId($strCk_user_client_id, $objDataHelper);
//print_r($meetingInstanceDtls);
} catch (Exception $e) {
throw new Exception("Error in getLMInstanceByClientId." . $a->getMessage(), 312);
}
$LMInstanceURL = $meetingInstanceDtls[0]["rt_server_name"];
if (strlen($LMInstanceURL) > 0) {
$meetingInstance = $LMInstanceURL;
$meetingAttendeePWD = ATTENDEE_PWD;
$meetingModeratorPWD = MODERATOR_PWD;
