\n"; // DEVONLY
//----------------------------------------------------------------------
// Delete
//----------------------------------------------------------------------
if ($_REQUEST['Action'] == "Delete") {
if ( array_key_exists('people_id', $_REQUEST)) {
if ( isset($_REQUEST['people_id'] ) ) {
$people_id = stripslashes( $_REQUEST['people_id']);
}else{
die ("NO People ID in delete function.") ;
}
if ( ! is_numeric($people_id) ) {
die ("People ID ($people_id) is not an integer.") ;
}
}else{
die ("No People Id Set") ;
}
$dbh = jjn_pdo_connect();
if ($people_id < 101){
die("People ID out of range\n");
}
//
// Fetch Name
//
$sql = "SELECT full_name from people where people_id = $people_id";
echo "
$sql
\n"; // DEVONLY
$name = get_value($sql);
echo "
\n";
echo "
Deleting $name from all website accounts
\n";
echo "
\n";
$sql = "DELETE from people where people_id = $people_id";
echo "
$sql
\n"; // DEVONLY
run_sql($sql);
$sql = "DELETE from access where people_id = $people_id";
echo "
$sql
\n"; // DEVONLY
run_sql($sql);
$_REQUEST = array();
$_REQUEST['Action'] = "List";
}// Endsub Delete
//----------------------------------------------------------------------
// Insert New Entry
//----------------------------------------------------------------------
if ($_REQUEST['Action'] == "Insert New Entry With Website Login"
|| $_REQUEST['Action'] == "Insert New Entry" ) {
$dbh = jjn_pdo_connect();
echo "
The numbers from the captcha box do match those in the image.";
echo " Please press the back button and try again.\n";
echo "
";
}
}else{
echo "
No Data
";
spew_footer($FMT);
exit;
}
//
// Get list of fields for this table
//
$fieldlabel = get_field_labels('people','people',$JJNCFG['DBNAME']);
$fields = array_keys($fieldlabel);
$fieldlabel['dob'] = 'Birth Date (YYYY-MM-DD)';
$fieldlabel['people_height'] = 'Height in inches (6 feet is 72 inches)';
//
// Define default values
//
$Default = array (
'people_state' => 'New',
'people_status' => 'Active',
'people_type' => 'Dancer',
'home_state' => 'CA',
'home_country' => 'US',
'birth_year' => '1999',
'dob' => '1999-09-09',
'people_notes' => ' For Work: ...\n Family: ...\n Dancing Details: ...\n For Fun: ...\n My Mission: ...\n My Superpower: ...\n Favorite Vacations: ...\n Favorite Quote: ....\n',
'timezone' => 'PST-8',
);
$Default['full_name'] = $_REQUEST['first_name'] . ' ' . $_REQUEST['last_name'];
//
// Setup default values
//
foreach ($Default as $key => $val ) {
if ( ! isset ( $_REQUEST[$key]) ) {
$_REQUEST[$key] = $val;
echo " Setting default of $key to $val\n"; // DEVONLY
}
}
//
// Eliminate all keys that have invalid answers
// Overwrite open menu entries with NEW_.. entries
//
foreach ($fields as $f) {
$altkey = "NEW_" . $f;
if ( isset($_REQUEST[$altkey]) ) {
if (!in_array($_REQUEST[$altkey], $InValidChoice)) {
$_REQUEST[$f] = $_REQUEST[$altkey];
unset ($_REQUEST[$altkey]);
}
}
if (in_array($_REQUEST[$f], $InValidChoice)) {
unset ($_REQUEST[$f]);
}
}
//
// Delete auto_increment primary keys
//
unset ($_REQUEST['people_id']);
//
// Required fields gauntlet
//
foreach ( $RequiredField as $key => $val) {
if (! array_key_exists($key, $_REQUEST)) {
$err .= '
Please ' . $RequiredField[$key] . '.
';
}
}
//
// Data Quality Gauntlet
//
if ( ! empty($_REQUEST['birth_day'])){
if ( ! is_numeric($_REQUEST['birth_day'])){
$err .= "modify Birth Day to be a number in the range [1-31]";
}
if ( ($_REQUEST['birth_day'] > 31 || $_REQUEST['birth_day'] < 1 )){
$err .= "modify Birth Day to be a number in the range [1-31]";
}
}
if ( ! empty($_REQUEST['birth_month']) ){
if ( ! is_numeric($_REQUEST['birth_month']) ){
$err .= "modify Birth Month to be a number in the range [1-12]";
}
if ( ($_REQUEST['birth_month'] > 12 || $_REQUEST['birth_month'] < 1 )){
$err .= "modify Birth Month to be a number in the range [1-12]";
}
}
if ( ! empty($_REQUEST['birth_year'])){
if ( ! is_numeric($_REQUEST['birth_year'])){
$err .= "modify Birth Year to be a numeric and a 4 digit number > 1900";
}
if ( $_REQUEST['birth_year'] < 1900 ){
$err .= "modify Birth Year to be a 4 digit number > 1900";
}
}
if ( $err ) {
echo "
\n"; // DEVONLY
}
$_REQUEST['Action'] = 'View';
}
//----------------------------------------------------------------------
// Update Existing Entry
//----------------------------------------------------------------------
if ($_REQUEST['Action'] == "Update" ) {
spew_query_form();
if ( array_key_exists('people_id', $_REQUEST)) {
$people_id = $_REQUEST['people_id'];
if (! is_numeric( $people_id ) ) {
die ("ERROR: Attempt to update People requires people_id to be integer. It is not.");
}
}else{
die ("No People Id Set. Unable to update") ;
}
if ($_SESSION['access_level'] <= $PEOPLECFG['EDITLEVEL'] ) {
if ( $_SESSION['people_id'] != $_REQUEST['people_id'] ){
die("You only have permission to update your own information.\n");
}
}
echo "
\n"; // DEVONLY
print_r($Original); // DEVONLY
//
// Get list of fields for this table
//
$fieldlabel = get_field_labels('people','aaaaaaaaaa',$JJNCFG['DBNAME']);
print '
\n";
if ($event_attended){
echo "List for those who attended $event_attended. \n";
}
echo "Column entries that are links will "drill down" to refine your query.\n";
echo "Name links show contact details.\n";
echo " Green shading in Status column indicates valid email on record.\n";
echo " Query returned $rowcount " . ( $rowcount ==1 ? 'entry.' : 'entries.');
echo "
\n";
echo "Enter entries. Details on meanings and choice details available via help links in left column.\n";
echo "Asterisk (*) indicates field is required.\n";
echo "
\n";
echo "
\n";
echo "\n";
echo "
\n";
}//End if ($_REQUEST['Action'] == "New" )
//----------------------------------------------------------------------
// Show: My Info
//----------------------------------------------------------------------
if ($_REQUEST['Action'] == "Show") {
spew_query_form();
echo "
Entering Show Function with ID of $_REQUEST[people_id]
\n"; // DEVONLY
if ( array_key_exists('people_id', $_SESSION)) {
if ( isset ( $_SESSION['people_id'] ) ) {
$people_id = $_SESSION['people_id'];
}else{
die ("No People ID in Show function") ;
}
if ( ! is_numeric($people_id) ) {
die ("People ID ($people_id) is not an integer.") ;
}
}else{
die ("No People Id Set") ;
}
//
// Get People roster for partner id
//
$Who = array();
$sql = "SELECT people_id, full_name from people";
$Who = get_menu_array($sql);
$menulist = array();
$row = array();
$dbh = jjn_pdo_connect();
$sql = 'SELECT * FROM people WHERE people_id = ';
$sql .= $dbh->quote($people_id);
echo "
\n";
echo "Field explanation available via link in left column field labels.\n";
echo "Change them by clicking Edit button at bottom of page.\n";
echo "
\n"; // DEVONLY
if ( array_key_exists('people_id', $_REQUEST)) {
if ( isset($_REQUEST['people_id'] ) ) {
$people_id = stripslashes( $_REQUEST['people_id']);
}else{
die ("NO People ID in edit function.") ;
}
if ( ! is_numeric($people_id) ) {
die ("People ID ($people_id) is not an integer.") ;
}
if ( $people_id <= 100 ) {
die ("People ID ($people_id) belongs to a special admin group and can not be edited via website.") ;
}
}else{
die ("No People Id Set") ;
}
$dbh = jjn_pdo_connect();
//
// Hardwire to update my stuff unless I have admin privileges
//
if ( $_SESSION['access_level'] < $PEOPLECFG['EDITLEVEL'] ) {
echo "
You only have permission to edit your own information\n";
$_REQUEST['people_id'] = $_SESSION['people_id'];
$NoEdit[] = 'people_status';
$NoEdit[] = 'headshot_url';
$NoEdit[] = 'people_source';
$NoEdit[] = 'people_type';
$NoEdit[] = 'latitude';
$NoEdit[] = 'longitude';
$NoEdit[] = 'headshot_url';
$NoShow = array(
'headshot_url',
'vaccination_record',
'headshot_url',
'people_id',
'people_source',
'latitude',
'longitude',
'alternate_email',
'home_country',
);
}
$menulist = array();
$Me = array();
$sql = "SELECT * FROM people WHERE people_id = '$people_id'";
echo "
$sql
\n"; // DEVONLY
$result = $dbh->query($sql);
$Me = $row = $result->fetch(PDO::FETCH_ASSOC);
$Who = array();
$sql = "SELECT people_id, full_name from people where people_id > 100";
echo "
\n";
$row = array();
$sql = "SELECT * from people WHERE people_id = $_REQUEST[people_id] ";
$result = $dbh->query($sql);
$row = $result->fetch(PDO::FETCH_ASSOC);
$fieldlabel = get_field_labels('people','people',$JJNCFG['DBNAME']);
// Outer table
//echo "
\n";
echo "
\n";
//echo "
\n";
echo "
View Photos, Etc.
\n";
echo "
View Personal Information
\n";
//--------------------------------------------------------------
// Left Margin Column: Photos and Role Info
//--------------------------------------------------------------
echo "
";
//---------------
// Me
//---------------
echo "
" . $Me['full_name'] . "
\n";
if ( isset( $Me['headshot_url']) ){
//
// Is my photo in the library?
//
echo "
";
}
echo "
";
}else{
echo "
";
}
}
}else{
$headshot = strtolower($Me['full_name']) . '.jpg';
$headshot = preg_replace('/\s+/', '_' , $photo);
if ( in_array($headshot, $Photo) && in_array('headshot', $ALLFLD) ){
//if ( in_array($headshot, $Photo) ){
echo "
";
}else{
if ( $Me['gender'] == 'M' ){
echo "