function score_entry_display()
{
global $dbh;
$sth = $dbh->prepare('SELECT * FROM score_entry WHERE team_id = ? AND game_id = ?');
$sth->execute(array($this->game->home_team, $this->game->game_id));
$home = $sth->fetch();
if (!$home) {
$home = array('score_for' => 'not entered', 'score_against' => 'not entered', 'defaulted' => 'no');
} else {
$entry_person = Person::load(array('user_id' => $home['entered_by']));
$home['entered_by'] = l($entry_person->fullname, "person/view/{$entry_person->user_id}");
}
$sth->execute(array($this->game->away_team, $this->game->game_id));
$away = $sth->fetch();
if (!$away) {
$away = array('score_for' => 'not entered', 'score_against' => 'not entered', 'defaulted' => 'no');
} else {
$entry_person = Person::load(array('user_id' => $away['entered_by']));
$away['entered_by'] = l($entry_person->fullname, "person/view/{$entry_person->user_id}");
}
$header = array(" ", $this->game->home_name . ' (home)', $this->game->away_name . ' (away)');
$rows = array();
$rows[] = array("Home Score:", $home['score_for'], $away['score_against']);
$rows[] = array("Away Score:", $home['score_against'], $away['score_for']);
$rows[] = array("Defaulted?", $home['defaulted'], $away['defaulted']);
$rows[] = array("Entered By:", $home['entered_by'], $away['entered_by']);
$rows[] = array("Entry time:", $home['entry_time'], $away['entry_time']);
return '<div class="listtable">' . table($header, $rows) . "</div>";
}
public function _new()
{
parent::_new();
$this->setTemplateName('calls_new');
$projects = $opportunities = $activities = null;
if (isset($this->_data['person_id'])) {
$person = new Person();
$person->load($this->_data['person_id']);
$this->_data['company_id'] = $person->company_id;
$projects = $person->projects;
$opportunities = $person->opportunities;
$activities = $person->activities;
$this->view->set('person', $person->fullname);
}
if (isset($this->_data['company_id'])) {
$company = new Company();
$company->load($this->_data['company_id']);
$projects = DataObjectCollection::Merge($company->projects, $projects);
$opportunities = DataObjectCollection::Merge($company->opportunities, $opportunities);
$activities = DataObjectCollection::Merge($company->activities, $activities);
$this->view->set('company', $company->name);
}
if (isset($this->_data['project_id'])) {
$project = new Project();
$project->load($this->_data['project_id']);
$this->_data['company_id'] = $project->company_id;
}
$this->view->set('projects', $projects);
$this->view->set('opportunities', $opportunities);
$this->view->set('activities', $activities);
}
function load()
{
global $dbh;
$returnValue = false;
if (parent::load()) {
$query = '
SELECT
`IDNumber`
, `KRAPIN`
, `dateOfEmployment`
FROM
`employeeDetails`
WHERE
`uniqueID` = "' . mysql_escape_string($this->getUniqueID()) . '"
';
try {
$statement = $dbh->prepare($query);
$statement->execute();
$row = $statement->fetch();
$this->setIDNumber(mysql_escape_string($row["IDNumber"]));
$this->setKRAPIN(mysql_escape_string($row["KRAPIN"]));
$this->setDateOfEmployment(mysql_escape_string($row["dateOfEmployment"]));
$returnValue = true;
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die;
}
$returnValue = true;
}
return $returnValue;
}
public static function GetRecipients($ticket)
{
$recipients = array();
if ($ticket->originator_person_id != null) {
// If this ticket has a person, attempt to send mail to them
$person = new Person();
$person->load($ticket->originator_person_id);
$contact = $person->email->contactmethod;
if (!empty($contact)) {
$recipients[] = $contact;
} else {
// If no contact found then reiterate but for company contacts this time
if ($ticket->originator_company_id != null) {
$contact = $ticket->getCompanyEmail($ticket->originator_company_id);
if (!empty($contact)) {
$recipients[] = $contact;
}
}
}
}
// Last ditch effort.
if (count($recipients) == 0) {
if (!is_null($ticket->originator_email_address)) {
$recipients[] = $ticket->originator_email_address;
}
}
return $recipients;
}
function user()
{
if (!$this->user_id) {
return null;
}
return Person::load(array('user_id' => $this->user_id));
}
function perform($edit = array())
{
$fields = array();
if (validate_nonblank($edit['username'])) {
$fields['username'] = $edit['username'];
}
if (validate_nonblank($edit['email'])) {
$fields['email'] = $edit['email'];
}
if (count($fields) < 1) {
error_exit("You must supply at least one of username or email address");
}
/* Now, try and find the user */
$user = Person::load($fields);
/* Now, we either have one or zero users. Regardless, we'll present
* the user with the same output; that prevents them from using this
* to guess valid usernames.
*/
if ($user) {
/* Generate a password */
$pass = generate_password();
$user->set_password($pass);
if (!$user->save()) {
error_exit("Error setting password");
}
/* And fire off an email */
$rc = send_mail($user, false, false, _person_mail_text('password_reset_subject', array('%site' => variable_get('app_name', 'Leaguerunner'))), _person_mail_text('password_reset_body', array('%fullname' => "{$user->firstname} {$user->lastname}", '%username' => $user->username, '%password' => $pass, '%site' => variable_get('app_name', 'Leaguerunner'))));
if ($rc == false) {
error_exit("System was unable to send email to that user. Please contact system administrator.");
}
}
}
public function systemCompany(&$do, &$errors)
{
$user = getCurrentUser();
$person = new Person();
$person->load($user->person_id);
$format = new xmlrpcmsg('elgg.user.newCommunity', array(new xmlrpcval($person->firstname . ' ' . $person->surname, "string"), new xmlrpcval($person->email, "string"), new xmlrpcval($do->company, "string")));
$client = new xmlrpc_client("_rpc/RPC2.php", "tech2.severndelta.co.uk", 8091);
$request = $client->send($format);
if (!$request->faultCode()) {
$response = $request->value();
if ($response->structmemexists('owner') && $response->structmemexists('community')) {
$person->published_username = $response->structmem('owner')->scalarval();
$person->save();
$do->published = true;
$do->published_username = $response->structmem('community')->scalarval();
$do->published_owner_id = $person->id;
$do->save();
} else {
$errors[] = 'Failed to publish company';
}
} else {
$errors[] = "Code: " . $request->faultCode() . " Reason '" . $request->faultString();
return false;
}
return true;
}
public function viewperson()
{
$view = new Newsletterview();
$view->load($this->_data['id']) or sendBack();
$person = new Person();
$person->load($view->person_id);
sendTo('persons', 'view', 'contacts', array('id' => $person->id));
}
function __construct($id, $player_id = null)
{
parent::__construct($id);
if ($player_id) {
$this->player = Person::load(array('user_id' => $player_id));
}
$this->template_name = 'pages/team/roster.tpl';
}
function __construct($id)
{
$this->person = Person::load(array('user_id' => $id));
if (!$this->person) {
error_exit("That user does not exist");
}
person_add_to_menu($this->person);
}
function __construct($id)
{
global $lr_session;
if ($id) {
$this->person = Person::load(array('user_id' => $id));
}
if (!$this->person) {
$this->person =& $lr_session->user;
}
}
function __construct($event_id, $registrant_id = null)
{
global $lr_session;
if ($lr_session->is_admin() && !is_null($registrant_id)) {
$this->registrant_id = $registrant_id;
if ($this->registrant_id != 'choose') {
$this->registrant = Person::load(array('user_id' => $registrant_id));
}
} else {
$this->registrant_id = $lr_session->user->user_id;
$this->registrant = $lr_session->user;
}
parent::__construct($event_id, $this->registrant);
}
function check_input_errors($edit = array())
{
$errors = parent::check_input_errors($edit);
if (!validate_name_input($edit['username'])) {
$errors[] = "You can only use letters, numbers, spaces, and the characters - ' and . in usernames";
}
$existing_user = Person::load(array('username' => $edit['username']));
if ($existing_user) {
$errors[] = "A user with that username already exists; please choose another";
}
if ($edit['password_once'] != $edit['password_twice']) {
$errors[] = error_exit("First and second entries of password do not match");
}
return $errors;
}
function load($id)
{
$res = parent::load($id);
// Load restrictions
$sql = 'SELECT congregationid, NULL as groupid
FROM account_congregation_restriction
WHERE personid = ' . (int) $id . '
UNION
SELECT NULL as congregationid, groupid
FROM account_group_restriction
WHERE personid = ' . (int) $id;
$res = $GLOBALS['db']->queryAll($sql);
check_db_result($res);
foreach ($res as $row) {
$type = empty($row['congregationid']) ? 'group' : 'congregation';
$this->_restrictions[$type][] = $row[$type . 'id'];
}
return $res;
}
function process()
{
global $lr_session;
$this->title = "{$this->league->fullname} » Member Status";
if (!$this->player_id) {
$new_handler = new person_search();
$new_handler->smarty =& $this->smarty;
$new_handler->initialize();
$new_handler->ops['Add to ' . $this->league->fullname] = 'league/member/' . $this->league->league_id;
$new_handler->extra_where = "(class = 'administrator' OR class = 'volunteer')";
$new_handler->process();
$this->template_name = $new_handler->template_name;
return true;
}
if (!$lr_session->is_admin() && $this->player_id == $lr_session->attr_get('user_id')) {
error_exit("You cannot add or remove yourself as league coordinator");
}
$player = Person::load(array('user_id' => $this->player_id));
switch ($_GET['edit']['status']) {
case 'remove':
if (!$this->league->remove_coordinator($player)) {
error_exit("Failed attempting to remove coordinator from league");
}
break;
default:
if ($player->class != 'administrator' && $player->class != 'volunteer') {
error_exit("Only volunteer-class players can be made coordinator");
}
if (!$this->league->add_coordinator($player)) {
error_exit("Failed attempting to add coordinator to league");
}
break;
}
if (!$this->league->save()) {
error_exit("Failed attempting to modify coordinators for league");
}
local_redirect(url("league/view/" . $this->league->league_id));
}
function load($returnType = RETURN_BOOLEAN)
{
global $dbh;
$query = '
SELECT
`schoolID`
, `dateOfAdmission`
, `yearOfStudyAtAdmission`
, `gender`
, `entryScore`
FROM
`studentDetails`
WHERE
`uniqueID` = "' . mysql_escape_string($this->getUniqueID()) . '"
';
$query_subjects = '
SELECT
`subjectCode`
FROM
`studentSubjects`
WHERE
`studentID` = "' . $this->getUniqueID() . '"';
if ($returnType == 0) {
$returnValue = false;
if (parent::load()) {
try {
$statement = $dbh->prepare($query);
$statement->execute();
$row = $statement->fetch();
$this->setSchoolID($row["schoolID"]);
$this->setDateOfAdmission($row["dateOfAdmission"]);
$this->setYearOfStudyAtAdmission($row["yearOfStudyAtAdmission"]);
$this->setGender($row["gender"]);
$this->setEntryScore($row["entryScore"]);
$returnValue = true;
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die;
}
$returnValue = true;
}
} else {
$returnType = $query;
}
return $returnValue;
}
private function notifyQueueOwner($ticket, $data)
{
// Needs to be Assigned To if present
// otherwise Queue Owner
$plateout = TicketingUtils::StatusPlate($ticket);
$to = '';
if (!is_null($ticket->assigned_to)) {
$user = new User();
$user->loadBy('username', $ticket->assigned_to);
if (!is_null($user->person_id)) {
$person = new Person();
$person->load($user->person_id);
$to = $person->email->contactmethod;
}
if (empty($to)) {
$to = $user->email;
}
}
if (empty($to)) {
$queue = new TicketQueue();
$queue->load($ticket->ticket_queue_id);
if ($queue->isLoaded() && !is_null($queue->email_address)) {
$to = $queue->email_address;
}
}
if (!empty($to)) {
$headers = array('From' => TicketingUtils::getReplyAddress($ticket), 'Reply-To' => $data['reply_address']);
$header_string = "";
foreach ($headers as $header => $value) {
$header_string .= $header . ': ' . $value . "\r\n";
}
$body = $plateout . "\n" . $data['message'] . "\n";
mail($to, 're: [' . $ticket->ticket_queue_id . '-' . $ticket->id . '] ' . $ticket->summary, $body, $header_string, '-r ' . $to);
}
}
/**
* Create the user session from the given username and password
*
* @return boolean status of session creation
*/
function create_from_login($username, $password, $client_ip)
{
if (!isset($username)) {
return false;
}
if (!isset($password)) {
return false;
}
$user = Person::load(array('username' => $username));
if (!$user) {
return false;
}
# Check password
if (!$user->check_password($password)) {
return false;
}
/* Ok, the user is good. Now we need to save the user
* and generate a session key.
*/
$this->user = $user;
$this->session_key = session_id();
if (!$this->user->log_in($this->session_key, $client_ip, $password)) {
return false;
}
return true;
}
public function save()
{
// Fill client hidden sections
$user = new User();
$person = new Person();
$user->load(EGS_USERNAME);
if (!is_null($user->person_id)) {
$person->load($user->person_id);
}
// Is this quick entry?
if ($this->_data['TicketResponse']['type'] == 'quick') {
$this->_data['TicketResponse']['type'] = 'site';
$config = new TicketConfigurationCollection(new TicketConfiguration());
$sh = new SearchHandler($config);
$sh->AddConstraint(new Constraint('usercompanyid', '=', EGS_COMPANY_ID));
$config->load($sh);
$config = $config->getContents();
if (count($config) !== 1) {
// Make one.
$newConfig['usercompanyid'] = EGS_COMPANY_ID;
$priority = self::findDefault(new TicketPriorityCollection(new TicketPriority()));
$newConfig['client_ticket_priority_default'] = $priority->id;
$newConfig['internal_ticket_priority_default'] = $priority->id;
$severity = self::findDefault(new TicketSeverityCollection(new TicketSeverity()));
$newConfig['client_ticket_severity_default'] = $severity->id;
$newConfig['internal_ticket_severity_default'] = $severity->id;
$queue = self::findDefault(new TicketQueueCollection(new TicketQueue()));
$newConfig['ticket_queue_default'] = $queue->id;
$category = self::findDefault(new TicketCategoryCollection(new TicketCategory()));
$newConfig['ticket_category_default'] = $category->id;
$status = self::findDefault(new TicketStatusCollection(new TicketStatus()));
$newConfig['client_ticket_status_default'] = $status->id;
$newConfig['internal_ticket_status_default'] = $status->id;
$config = TicketConfiguration::Factory($newConfig);
} else {
$config = $config[0];
}
$this->_data['Ticket']['client_ticket_priority_id'] = $config->client_ticket_priority_default;
$this->_data['Ticket']['ticket_queue_id'] = $config->ticket_queue_default;
}
$this->_data['Ticket']['originator_person_id'] = $user->username;
$this->_data['Ticket']['originator_company_id'] = $user->lastcompanylogin;
$this->_data['Ticket']['internal_ticket_severity_id'] = $this->_data['Ticket']['client_ticket_severity_id'];
$this->_data['Ticket']['internal_ticket_priority_id'] = $this->_data['Ticket']['client_ticket_priority_id'];
if (!isset($this->_data['Ticket']['id'])) {
// Force 'new' status initialy
$ts = new TicketStatusCollection(new TicketStatus());
$sh = new SearchHandler($ts);
$sh->addConstraint(new Constraint('usercompanyid', '=', EGS_COMPANY_ID));
$sh->addConstraint(new Constraint('status_code', '=', 'NEW'));
$ts->load($sh);
$statuses = $ts->getContents();
$status = $statuses[0];
// Should only ever be one status, this should be regulated by earlier validation
$this->_data['Ticket']['client_ticket_status_id'] = $status->id;
$this->_data['Ticket']['internal_ticket_status_id'] = $status->id;
}
if (isset($this->_data['Ticket']['id'])) {
$originalTicket = new Ticket();
$originalTicket->load($this->_data['Ticket']['id']);
$changes = array(array('param' => 'client_ticket_status_id', 'friendly' => 'Status', 'object' => 'TicketStatus'), array('param' => 'client_ticket_priority_id', 'friendly' => 'Priority', 'object' => 'TicketPriority'), array('param' => 'client_ticket_severity_id', 'friendly' => 'Severity', 'object' => 'TicketSeverity'), array('param' => 'ticket_queue_id', 'friendly' => 'Queue', 'object' => 'TicketQueue'));
$changeText = array();
foreach ($changes as $change) {
if ($this->_data['Ticket'][$change['param']] != $originalTicket->{$change}['param']) {
$was = new $change['object']();
$now = new $change['object']();
$was->load($originalTicket->{$change}['param']);
$now->load($this->_data['Ticket'][$change['param']]);
$changeText[] = $change['friendly'] . ': was ' . $was->name . ' now ' . $now->name . '.';
}
}
if (count($changeText) > 0) {
$errors = array();
$ticketResponse = TicketResponse::Factory(array('ticket_id' => $this->_data['Ticket']['id'], 'internal' => 'false', 'body' => implode("\n", $changeText), 'type' => 'status', 'owner' => EGS_USERNAME), $errors, 'TicketResponse');
$ticketResponse->save();
$queue = new TicketQueue();
$queue->load($originalTicket->ticket_queue_id);
// Send mail
$headers = array('From' => $queue->email_address);
$header_string = "";
foreach ($headers as $header => $value) {
$header_string .= $header . ': ' . $value . "\r\n";
}
$body = TicketingUtils::StatusPlate($originalTicket) . implode("\n", $changeText);
$recipients = TicketingUtils::GetRecipients($originalTicket);
foreach ($recipients as $recipient) {
mail($recipient, 're: [' . $originalTicket->ticket_queue_id . '-' . $originalTicket->id . '] ' . $originalTicket->summary, $body, $header_string);
}
}
}
parent::save('Ticket');
$ticket_id = $this->_data['id'];
$this->_data['Ticket']['id'] = $this->_data['id'];
if (isset($this->_data['id'])) {
$this->_data['TicketResponse']['ticket_id'] = $ticket_id;
parent::save('TicketResponse');
}
sendTo('Client', 'view', array('ticketing'), array('id' => $ticket_id));
}
function check_input_errors($edit = array())
{
global $lr_session;
$errors = array();
if ($lr_session->has_permission('person', 'edit', $this->person->user_id, 'name')) {
if (!validate_name_input($edit['firstname']) || !validate_name_input($edit['lastname'])) {
$errors[] = "You can only use letters, numbers, spaces, and the characters - ' and . in first and last names";
}
}
if ($lr_session->has_permission('person', 'edit', $this->person->user_id, 'username')) {
if (!validate_name_input($edit['username'])) {
$errors[] = "You can only use letters, numbers, spaces, and the characters - ' and . in usernames";
}
$user = Person::load(array('username' => $edit['username']));
# TODO: BUG: need to check that $user->user_id != current id
if ($user && !$lr_session->is_admin()) {
$errors[] = "A user with that username already exists; please choose another";
}
}
if (!validate_email_input($edit['email'])) {
$errors[] = "You must supply a valid email address";
}
if (!validate_nonblank($edit['home_phone']) && !validate_nonblank($edit['work_phone']) && !validate_nonblank($edit['mobile_phone'])) {
$errors[] = "You must supply at least one valid telephone number. Please supply area code, number and (if any) extension.";
}
if (validate_nonblank($edit['home_phone']) && !validate_telephone_input($edit['home_phone'])) {
$errors[] = "Home telephone number is not valid. Please supply area code, number and (if any) extension.";
}
if (validate_nonblank($edit['work_phone']) && !validate_telephone_input($edit['work_phone'])) {
$errors[] = "Work telephone number is not valid. Please supply area code, number and (if any) extension.";
}
if (validate_nonblank($edit['mobile_phone']) && !validate_telephone_input($edit['mobile_phone'])) {
$errors[] = "Mobile telephone number is not valid. Please supply area code, number and (if any) extension.";
}
$address_errors = validate_address($edit['addr_street'], $edit['addr_city'], $edit['addr_prov'], $edit['addr_postalcode'], $edit['addr_country']);
if (count($address_errors) > 0) {
$errors = array_merge($errors, $address_errors);
}
if (!preg_match("/^[mf]/i", $edit['gender'])) {
$errors[] = "You must select either male or female for gender.";
}
if (!validate_yyyymmdd_input($edit['birthdate'])) {
$errors[] = "You must provide a valid birthdate";
}
if (validate_nonblank($edit['height'])) {
if (!$lr_session->is_admin() && ($edit['height'] < 36 || $edit['height'] > 84)) {
$errors[] = "Please enter a reasonable and valid value for your height.";
}
}
if ($edit['skill_level'] < 1 || $edit['skill_level'] > 10) {
$errors[] = "You must select a skill level between 1 and 10. You entered " . $edit['skill_level'];
}
$current = localtime(time(), 1);
$this_year = $current['tm_year'] + 1900;
if ($edit['year_started'] > $this_year) {
$errors[] = "Year started must be before current year.";
}
if ($edit['year_started'] < 1986) {
$errors[] = "Year started must be after 1986. For the number of people who started playing before then, I don't think it matters if you're listed as having played 17 years or 20, you're still old. :)";
}
$birth_year = substr($edit['birthdate'], 0, 4);
$yearDiff = $edit['year_started'] - $birth_year;
if ($yearDiff < 8) {
$errors[] = "You can't have started playing when you were {$yearDiff} years old! Please correct your birthdate, or your starting year";
}
return $errors;
}
function assoc_obj()
{
if (!$this->assoc_obj) {
if ($this->assoc_type == 'person') {
$this->assoc_obj = Person::load(array('user_id' => $this->assoc_id));
} elseif ($this->assoc_type == 'team') {
$this->assoc_obj = Team::load(array('team_id' => $this->assoc_id));
} else {
die("Invalid assoc_type of " . $this->assoc_type);
}
}
return $this->assoc_obj;
}
$person = new Person();
$data = array('name' => 'Tommy', 'age' => '20', 'citizenship' => 'American');
$person->bind($data);
$person->add();
// Select les users par l'âge et l'id
$person = new Person();
$person->age = '20';
// $person->id='558';
$personlist = $person->loadMultiple();
foreach ($personlist as $person) {
var_dump("{$person->name} {$person->age} {$person->citizenship} \r\n");
}
// Pour filtrer les recherches
$dbo->select('id', 'name', 'age')->from('person')->where('age=20')->limit(2)->result();
$personlist = $dbo->loadObjectList();
foreach ($personlist as $person) {
echo "<br><br>";
echo " Username: {$person['name']} <br> Age: {$person['age']} <br> Id: {$person['id']} ";
}
$dbo->orderby('id');
// Remplace le USER dans la base de données par un autre
$person = new Person();
$person->age = '20';
$person->load();
$data = array('name' => 'Laure-Ashley', 'age' => '21', 'citizenship' => 'french');
$person->bind($data);
$person->update();
//Supprimer un user par l'id
$person = new Person();
$person->id = '611';
$person->remove();
public function testDeleteBypassTrash()
{
// Cleanup
Person::deleteAll();
// Insert
$person = new Person();
$person->first_name = 'John';
$person->last_name = 'Doe';
$person->email = '*****@*****.**';
$person->post_title = 'John Doe';
$post_id = $person->save();
// Delete to trash
$person = new Person();
$this->assertTrue($person->load($post_id));
$this->assertTrue(is_object($person->delete(true)));
// Load shouldn't work
$person = new Person();
$this->assertFalse($person->load($post_id));
}
function person_permissions(&$user, $action, $arg1 = NULL, $arg2 = NULL)
{
$all_view_fields = array('name', 'gender', 'willing_to_volunteer');
if (variable_get('dog_questions', 1)) {
$all_view_fields[] = 'dog';
}
$restricted_contact_fields = array('email', 'home_phone', 'work_phone', 'mobile_phone');
$captain_view_fields = array('height', 'skill', 'shirtsize');
$self_edit_fields = array_merge($all_view_fields, $captain_view_fields, $restricted_contact_fields, array('birthdate', 'address', 'height', 'shirtsize'));
$create_fields = array_merge($self_edit_fields, array('username'));
$self_view_fields = array('username', 'birthdate', 'address', 'last_login', 'member_id', 'height', 'shirtsize');
$self_view_fields = array_merge($all_view_fields, $restricted_contact_fields, $self_view_fields);
switch ($action) {
case 'create':
return true;
break;
case 'edit':
if ('new' == $arg1) {
// Almost all fields can be edited for new players
if ($arg2) {
return in_array($arg2, $create_fields);
} else {
return true;
}
}
if (!$user || !$user->is_active()) {
return false;
}
if ($user->user_id == $arg1) {
if ($arg2) {
return in_array($arg2, $self_edit_fields);
} else {
return true;
}
}
break;
case 'password_change':
// User can change own password
if (is_numeric($arg1)) {
if ($user->user_id == $arg1) {
return true;
}
}
break;
case 'view':
if (!($user && $user->is_active())) {
return false;
}
if (is_numeric($arg1)) {
if ($user->user_id == $arg1) {
// Viewing yourself allowed, most fields
if ($arg2) {
return in_array($arg2, $self_view_fields);
} else {
return true;
}
} elseif (!$user->is_player()) {
// Name only
if ($arg2) {
return in_array($arg2, array('name'));
} else {
return true;
}
} else {
// Other user. Now comes the hard part
$player = Person::load(array('user_id' => $arg1));
// New or locked players cannot be viewed.
if ($player->status == 'new' || $player->status == 'locked') {
return false;
}
$sess_user_teams = implode(",", array_keys($user->teams));
$viewable_fields = $all_view_fields;
/* If player is a captain, their email is viewable */
if ($player->is_a_captain) {
// Plus, can view email
$viewable_fields[] = 'email';
}
if ($user->is_a_captain) {
/* If the current user is a team captain, and the requested user is on
* their team, they are allowed to view email/phone
*/
foreach ($player->teams as $team) {
if ($user->is_captain_of($team->team_id) && $team->position != 'captain_request') {
/* They are, so publish email and phone */
$viewable_fields = array_merge($all_view_fields, $restricted_contact_fields, $captain_view_fields);
break;
}
}
/* If the current user is a team captain, and the requested user is
* captain for a "nearby" team, they are allowed to view email/phone
*/
if ($player->is_a_captain) {
foreach ($player->teams as $player_team) {
if ($player->is_captain_of($player_team->team_id)) {
foreach ($user->teams as $user_team) {
if ($user->is_captain_of($user_team->team_id) && $player_team->league_id == $user_team->league_id) {
$viewable_fields = array_merge($all_view_fields, $restricted_contact_fields);
}
}
}
}
}
}
/* Coordinator info is viewable */
if ($player->is_a_coordinator) {
$viewable_fields = array_merge($all_view_fields, $restricted_contact_fields);
}
/* Coordinators get to see phone numbers of the captains they handle */
if ($user->is_a_coordinator && $player->is_a_captain) {
foreach ($player->teams as $team) {
if ($player->is_captain_of($team->team_id) && $user->coordinates_league_containing($team->team_id)) {
$viewable_fields = array_merge($all_view_fields, $restricted_contact_fields);
}
}
}
// Finally, perform the check and return
if ($arg2) {
return in_array($arg2, $viewable_fields);
} else {
return true;
}
}
}
break;
case 'list':
case 'search':
if (!($user && $user->is_active())) {
return false;
}
if ($arg1) {
// Specific searches require admin access
return false;
}
return $user->class != 'visitor';
case 'approve':
// administrator-only
// administrator-only
case 'delete':
// administrator-only
// administrator-only
case 'listnew':
// administrator-only
// administrator-only
default:
return false;
}
return false;
}
<?php // require_once 'common.php'; // $id = 1; // $name = Person::load($id, 'surname'); // var_dump($name);
public function getEmail($_person_id = '', $_company_id = '')
{
/*
* We only want to override the function parameters if the call has come from
* an ajax request, simply overwriting them as we were leads to a mix up in
* values
*/
if (isset($this->_data['person_id'])) {
if (!empty($this->_data['person_id'])) {
$_person_id = $this->_data['person_id'];
}
if (!empty($this->_data['company_id'])) {
$_company_id = $this->_data['company_id'];
}
}
// Used by Ajax to return the person's email address
// If no person is supplied, or they have no email address
// look for the company technical email address
// if still no email address is found, use the logged in user details
$person = new Person();
$email = '';
if (!empty($_person_id)) {
$person->load($_person_id);
if ($person->isLoaded() && !is_null($person->email->contactmethod)) {
$email = $person->email->contactmethod;
}
}
if (empty($email) && !empty($_company_id)) {
$email = Ticket::getCompanyEmail($_company_id);
}
if (empty($email)) {
$user = getCurrentUser();
if ($user) {
$email = $user->email;
if (!is_null($user->person_id)) {
$person->load($user->person_id);
if ($person->isLoaded() && !is_null($person->email->contactmethod)) {
$email = $person->email->contactmethod;
}
}
}
}
if (isset($this->_data['ajax'])) {
$this->view->set('value', $email);
$this->setTemplateName('text_inner');
} else {
return $email;
}
}
function entered_by_name()
{
if (!$this->entered_by_user) {
$this->entered_by_user = Person::load(array('user_id' => $this->entered_by));
}
return $this->entered_by_user->fullname;
}
$course->save();
$s->addCourses($course);
$p = new Person();
$p->setCity($c);
$p->setEmail('*****@*****.**');
$p->setName('Other Person');
$p->save();
$b = new Book();
$b->setAuthor($p);
$b->setTitle('PHP Book');
$b->save();
Hypersistence::commit();
//LOAD
$p = new Person();
$p->setId(1);
$p->load();
echo $p->getName() . "\n";
$books = $p->getBooks()->execute();
foreach ($books as $b) {
echo $b->getTitle() . "\n";
}
$s = new Student();
$s->setId(1);
$s->load();
echo $s->getName() . "\n";
$courses = $s->getCourses();
foreach ($courses as $c) {
echo $c->getDescription() . "\n";
$course = $c;
}
$s->deleteCourses($course);
<?php
//
require_once 'common.php';
/*
* Update database record without load by id
\*/
// ---------
// WRONG WAY
// ---------
//
echo '<h2>WRONG WAY</h2>';
//
$Id = 1;
//
$Item = Person::load($Id);
//
$Item->age = 31;
//
$Item->store();
// ---------
// RIGHT WAY
// ---------
//
echo '<h2>RIGHT WAY</h2>';
//
$Id = 1;
//
Person::update($Id, array('age' => 31));
function get_captains()
{
global $dbh;
$sth = $dbh->prepare("SELECT user_id\n\t\t\t\t\tFROM person p\n\t\t\t\t\t\tLEFT JOIN teamroster r ON p.user_id = r.player_id\n\t\t\t\t\tWHERE r.team_id IN (?,?)\n\t\t\t\t\t\tAND r.status IN ( 'captain', 'assistant', 'coach')");
$sth->execute(array($this->home_id, $this->away_id));
$captains = array();
while ($user = $sth->fetch(PDO::FETCH_OBJ)) {
$captains[] = Person::load(array('user_id' => $user->user_id));
}
return $captains;
}
