| |
if(isset($_POST['Submit'])){
$timestamp = substr($_POST['startDate'],6,4) . substr($_POST['startDate'],0,2) . substr($_POST['startDate'],3,2) ;
$query = "SELECT COUNT(*) as TOTALFOUND FROM calendar WHERE timestamp = '$timestamp' AND busy = 1";
$result = mysqli_query($conn, $query);
//print $query;
if (mysqli_result($result,0,"TOTALFOUND") == 0) {
$message = "" . $_POST['subject'] . " " . $_POST['area'] . "\n";
$message .= "\n";
$message .= "I am requesting authorization the celebrate the following activity on Los Versalles:\n";
$message .= "\n";
$message .= "Activity: " . $_POST['activity'] . " (Residence " . $_POST['residence'] .")\n";
$message .= "Area: " . $_POST['area'] . "\n";
$message .= "Date: " . $_POST['startDate'] . "\n";
$message .= "From: " . $_POST['from_time'] . " To: " . $_POST['to_time'] . "\n";
$message .= "Number of People: " . $_POST['people'] . "\n";
$message .= "Comments: \n";
$message .= "" . $_POST['comments'] . "\n";
$message .= "\n";
$message .= "\n";
$message .= "Name: " . $_POST['firstname'] . " " . $_POST['lastname'] . " ";
if(isset($_POST['board']) && $_POST['board'] > 0) { $message .= "(Board Member)\n";} else {$message .= "\n";}
$message .= "Residence: " . $_POST['residence'] . "\n";
if(isset($_POST['user']) && $_POST['user'] != "") {$message .= "Username: " . $_POST['user'] . "\n";}
$message .= "E-mail: " . $_POST['email'] . "\n";
$message .= "\n";
if(isset($_POST['address1']) && $_POST['address1'] != "") {$message .= "Address: " . $_POST['address1'] . "\n"; }
if(isset($_POST['address2']) && $_POST['address2'] != "") { $message .= " " . $_POST['address2'] . "\n"; }
if(isset($_POST['city']) && isset($_POST['state']) && $_POST['city'] != "") {$message .= " " . $_POST['city'] . ", " . $_POST['state'] . " " . $_POST['zip'] . "\n"; }
$message .= "\n";
if(isset($_POST['home_phone']) && $_POST['home_phone'] != "") { $message .= "Home Phone: " . $_POST['home_phone'] . "\n"; }
if(isset($_POST['cell_phone']) && $_POST['cell_phone'] != "") { $message .= "Cell Phone: " . $_POST['cell_phone'] . "\n"; }
$message .= "\n";
$message .= "\n";
$message .= "I undertand that:\n";
$message .= " - The maximum number of people for the Le Chateu is 50 and the maximum time for the activity is 6 hours.\n";
$message .= " - Le Chateu's Hours are 10:00am to 9:00pm during weekdays and 10:00am to 12:00pm during weekends and holidays.\n";
$message .= " - The resident reserving the area will be responsible for cleaning the area AFTER the activity is over.\n";
$message .= " - There is a $250 required deposit.\n";
$message .= " - Resident will be responsible for the behavior of their guest and any damage that may occur.\n";
$message .= "\n";
$headers = "Return-Path: <" . $_POST['email'] . ">\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-type: text/plain; charset=iso-8859-1\n";
$headers .= "X-Priority: 3\n";
$headers .= "X-MSMail-Priority: Normal\n";
$headers .= "X-Mailer: PHP/" . phpversion() . "\n";
$headers .= "X-Sender: <" . $_POST['email'] . ">\n";
$headers .= "From: \n";
$headers .= "Reply-To: \"" . $_POST['firstname'] . " " . $_POST['lastname'] . "\" <" . $_POST['email'] . ">\n";
$headers .= "Cc: \"" . $_POST['firstname'] . " " . $_POST['lastname'] . "\" <" . $_POST['email'] . ">\n";
$mysubject = $_POST['subject'] . " " . $_POST['area'];
$toaddress = ",";
//$toaddress = "";
//mail($toaddress, $mysubject, $message, $headers);
$activity = "Activity: " . $_POST['activity'] . " (" . $_POST['residence'] . " - " . $_POST['firstname'] . " " . $_POST['lastname'] . ") \n";
$activity .= "Area: " . $_POST['area'] . " \n";
$activity .= "Date: " . $_POST['startDate'] . " \n";
$activity .= "From: " . $_POST['from_time'] . " To: " . $_POST['to_time'] . " \n";
$query = "INSERT INTO calendar VALUES (0, '$timestamp', '$activity', 1)";
$done = mysqli_query($conn, $query);
?>
Authorization Request: Submitted
Your Activity Celebration Request has been submitted to the Administrator.
echo ""; ?> echo str_replace("\n", " ", $message); ?> echo " "; ?>
Click here to return Home.
} else { // if busy
?>
Authorization Request: Denied
Your Activity Celebration Request has been denied since the date you have selected seem to be busy.
Please contact the Administrator if you believe this is a mistake or go back and select another day.
The following Activities are already schedule:
$day_id=$timestamp;
calendar_display_entries();
?>
}
} else { // if Submit
/**
* This is the page with the sign-up form, the names
* of the input fields are important and should not
* be changed.
*/
if ($logged_in) {
global $conn;
$q = "SELECT users.user_id ";
$q .= " , users.email ";
$q .= " , users.username ";
$q .= " , users.firstname ";
$q .= " , users.lastname ";
$q .= " , users.address1 ";
$q .= " , users.address2 ";
$q .= " , users.city ";
$q .= " , users.state ";
$q .= " , users.zip ";
$q .= " , users.board ";
$q .= " , users.status ";
$q .= " , users_houses.num ";
$q .= " FROM users, users_houses ";
$q .= " WHERE LOWER(username) LIKE '".strtolower($_SESSION['username'])."' ";
$q .= " AND users.user_id = users_houses.user_id";
$q .= " LIMIT 0, 1 ";
$result = mysqli_query($conn, $q);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
$form_user_id = $row["user_id"];
$form_email = $row["email"];
$form_username = $row["username"];
$form_firstname = $row["firstname"];
$form_lastname = $row["lastname"];
$form_address1 = $row["address1"];
$form_address2 = $row["address2"];
$form_city = $row["city"];
$form_state = $row["state"];
$form_zip = $row["zip"];
$form_private = $row["private"];
$form_board = $row["board"];
$form_status = $row["status"];
$form_num = $row["num"];
$q = "SELECT phone_type,phone,private FROM users_phones WHERE user_id = $form_user_id";
$phone = mysqli_query($conn, $q);
while ($phone_row = mysqli_fetch_array($phone,MYSQLI_ASSOC)) {
switch ($phone_row["phone_type"]) {
case "Cell":
$form_cellphone = $phone_row["phone"];
$form_cellprivate= $phone_row["private"];
break;
case "Home":
$form_homephone = $phone_row["phone"];
$form_homeprivate = $phone_row["private"];
break;
} // Switch
} // While
} // if ($logged_in)
?>
Activity Celebration Authorization Request
}
?> |
|
 |
 |
Calendar |
 |
| calendar_display_month(); ?> |
|
if ($logged_in && $board_member) { ?>
|
} ?>
|
|
|
 |
|