</form>
</div>
<div style="clear: both;"></div><br />
<?php
//$tblEvent->omitPrimaryKey();
#Create custom display fields
$tblEvent->displayAs("pkEventID", "Event ID");
$tblEvent->displayAs("fldTitle", "Title");
$tblEvent->displayAs("fldDate", "Date");
$tblEvent->displayAs("fldTime", "Time");
$tblEvent->displayAs("fldLocation", "Location");
$tblEvent->displayAs("fldAdditionalInformation", "Additional Information");
$tblEvent->displayAs("fldImage", "Image");
$tblEvent->displayAs("fldType", "Public/Private?");
$tblEvent->disallowDelete();
$validValues = array("Public", "Private");
$tblEvent->defineAllowableValues("fldType", $validValues);
//$tblEvent->category_required['fldType'] = FALSE;
$tblEvent->addOrderBy("ORDER BY fldDate ASC");
#Add filter boxes (if i wanted them)
//$tblEvent->addAjaxFilterBox("fldFirstName");
//$tblEvent->addAjaxFilterBox("fldLastName");
//$tblEvent->addAjaxFilterBox("fldAttending");
$today = date("Y-m-d");
if (!$viewPastEvents) {
#Add Where clause - only show future events
$tblEvent->addWhereClause("WHERE (fldDate >= \"{$today}\") OR fldDate = \"0000-00-00\"");
$signupText = "Sign up for Event";
$tblEvent->setFileUpload("fldImage", "uploads/", "uploads/");
} else {
$tblEventAttendee->setAddFieldNote("fldWillBeLate", "If you will be arriving late, please enter the time in the next box.");
$tblEventAttendee->modifyFieldWithClass("fldTimeArriving", "time");
$tblEventAttendee->modifyFieldWithClass("fldLastName", "required");
$tblEventAttendee->modifyFieldWithClass("fldFirstName", "required");
$tblEventAttendee->formatFieldWithFunction("fldWillBeLate", "displayWillBeLate");
$tblEventAttendee->formatFieldWithFunctionAdvanced("fldTimeArriving", "displayArrivalTime");
$tblEventAttendee->emptyTableMessage = "No one has signed up yet! Press the '<b>Add Person</b>' button below to sign up for this event.";
$tblEventAttendee->addMessage = "You have been added to this event.";
$tblEventAttendee->setCSSFile("cuscosky.css");
//i liked this table feel; but any css can be used from http://icant.co.uk/csstablegallery
#implement a callback function on signing up to create cookie
$tblEventAttendee->onAddExecuteCallBackFunction("onAddCallBackFunction");
//if event expired, do not allow people to sign up for it or change who had attended
if ($eventExpired) {
$tblEventAttendee->disallowAdd();
$tblEventAttendee->disallowDelete();
$tblEventAttendee->turnOffAjaxEditing();
$tblEventAttendee->omitFieldCompletely("fldWillBeLate");
$tblEventAttendee->omitFieldCompletely("fldTimeArriving");
}
//this needs to be very low in the excution path to ensure the obj is loaded correctly with every other piece of logic
//typically doAction is called within the showTable() method, but i do not want to do that because i modify headers with my onAdd callback function
if (isset($_REQUEST['action']) && $_REQUEST['action'] != '') {
$tblEventAttendee->doAction($_REQUEST['action']);
}
include 'header.php';
if ($eventExpired) {
displayExpiration();
}
echo "<h3><u>{$fldType}</u> Event: {$fldTitle} - " . date("M d, Y", strtotime($fldDate)) . " @ {$fldTime}</h3>\n";
if ($fldType == "Public") {
//$tblDemo->setFileUpload("poster", "uploads/");
#i can have a field automatically populate with a certain value (eg the current timestamp)
//$tblDemo->addValueOnInsert("fldField1", "NOW()");
#i can use a where field to better-filter my table
//$tblDemo->addWhereClause("WHERE (fldField1 = 'test')");
#i can order my table by whatever i want
//$tblDemo->addOrderBy("ORDER BY fldField1 ASC");
#i can set certain fields to only allow certain values
#http://ajaxcrud.com/api/index.php?id=defineAllowableValues
//$allowableValues = array("Allowable Value1", "Allowable Value2", "Dropdown Value", "CRUD");
// $tblDemo->defineAllowableValues("fldCertainFields", $allowableValues);
//set field fldCheckbox to be a checkbox
//$tblDemo->defineCheckbox("fldCheckbox");
#i can disallow deleting of rows from the table
#http://ajaxcrud.com/api/index.php?id=disallowDelete
$tblDemo->disallowDelete();
#i can disallow adding rows to the table
#http://ajaxcrud.com/api/index.php?id=disallowAdd
//$tblDemo->disallowAdd();
#i can add a button that performs some action deleting of rows for the entire table
#http://ajaxcrud.com/api/index.php?id=addButtonToRow
//$tblDemo->addButtonToRow("Add", "add_item.php", "all");
#set the number of rows to display (per page)
$tblDemo->setLimit(100);
#set a filter box at the top of the table
//$tblDemo->addAjaxFilterBox('fldField1');
#if really desired, a filter box can be used for all fields
//style$tblDemo->addAjaxFilterBoxAllFields();
#i can set the size of the filter box
//$tblDemo->setAjaxFilterBoxSize('fldField1', 3);
#i can format the data in cells however I want with formatFieldWithFunction
