/**
* Pilots::index()
*
* @return
*/
public function index()
{
// Get all of our hubs, and list pilots by hub
$allhubs = OperationsData::GetAllHubs();
if (!$allhubs) {
$allhubs = array();
}
foreach ($allhubs as $hub) {
$this->set('title', $hub->name);
$this->set('icao', $hub->icao);
$pilot_list = PilotData::findPilots(array('p.hub' => $hub->icao));
$this->set('allpilots', $pilot_list);
# deprecated
$this->set('pilot_list', $pilot_list);
$this->render('pilots_list.tpl');
}
$nohub = PilotData::findPilots(array('p.hub' => ''));
if (!$nohub) {
return;
}
$this->set('title', 'No Hub');
$this->set('icao', '');
$this->set('allpilots', $nohub);
# deprecated
$this->set('pilot_list', $nohub);
$this->render('pilots_list.tpl');
}
public function sendmail()
{
$this->checkPermission(EMAIL_PILOTS);
echo '<h3>Sending email</h3>';
if ($this->post->subject == '' || trim($this->post->message) == '') {
$this->set('message', 'You must enter a subject and message!');
$this->render('core_error.php');
return;
}
if (count($this->post->groups) == 0) {
$this->set('message', 'You must select groups to send to!');
$this->render('core_error.php');
return;
}
echo 'Sending email...<br />';
$pilotarray = array();
//Begin the nice long assembly of e-mail addresses
foreach ($this->post->groups as $groupid) {
if ($groupid == 'all') {
$all_pilots = PilotData::findPilots(array());
foreach ($all_pilots as $pilot) {
$pilotarray[$pilot->pilotid] = $pilot;
}
break;
} else {
$tmp = PilotGroups::getUsersInGroup($groupid);
if (count($tmp) == 0 || !is_array($tmp)) {
continue;
}
foreach ($tmp as $pilot) {
$pilotarray[$pilot->pilotid] = $pilot;
}
}
}
$subject = DB::escape($this->post->subject);
$message = stripslashes($this->post->message) . PHP_EOL . PHP_EOL;
# Do some quick fixing of obvious formatting errors
$message = str_replace('<br>', '<br />', $message);
foreach ($pilotarray as $pilot) {
echo 'Sending for ' . $pilot->firstname . ' ' . $pilot->lastname . '<br />';
# Variable replacements
$send_message = str_replace('{PILOT_FNAME}', $pilot->firstname, $message);
$send_message = str_replace('{PILOT_LNAME}', $pilot->lastname, $send_message);
$send_message = str_replace('{PILOT_ID}', PilotData::GetPilotCode($pilot->code, $pilot->pilotid), $send_message);
$send_message = utf8_encode($send_message);
Util::SendEmail($pilot->email, $subject, $send_message);
}
echo 'Complete!';
LogData::addLog(Auth::$userinfo->pilotid, 'Sent pass mail');
return;
}
/**
* Maintenance::changepilotid()
*
* @return
*/
public function changepilotid()
{
CodonModule::checkPermission(MAINTENANCE);
CodonModule::checkPermission(EDIT_PILOTS);
echo '<h3>Change Pilot ID</h3>';
if (isset($this->post->submit)) {
$error = false;
if (!is_numeric($this->post->new_pilotid)) {
$error = true;
$this->set('message', 'The pilot ID isn\'t numeric!');
$this->render('core_error.php');
return;
}
if ($this->post->new_pilotid < 1) {
$error = true;
$this->set('message', 'You cannot have an ID less than 1');
$this->render('core_error.php');
return;
}
if (empty($this->post->new_pilotid)) {
$error = true;
$this->set('message', 'The pilot ID is blank!');
$this->render('core_error.php');
return;
}
if (empty($this->post->old_pilotid) || $this->post->old_pilotid == 0) {
$error = true;
$this->set('message', 'No pilot selected');
$this->render('core_error.php');
return;
}
$pilot = PilotData::getPilotData($this->post->new_pilotid);
if (is_object($pilot)) {
$error = true;
$this->set('message', 'This ID is already used!');
$this->render('core_error.php');
return;
}
if ($error === false) {
PilotData::changePilotID($this->post->old_pilotid, $this->post->new_pilotid);
$this->set('message', "Pilot ID changed from {$this->post->old_pilotid} to {$this->post->new_pilotid}");
$this->render('core_success.php');
}
}
$this->set('allpilots', PilotData::findPilots(array()));
$this->render('maintenance_changepilotid.php');
}
public function changepilotid()
{
echo '<h3>Change Pilot ID</h3>';
if (isset($this->post->submit)) {
$error = false;
if (!is_numeric($this->post->new_pilotid)) {
$error = true;
$this->set('message', 'The pilot ID isn\'t numeric!');
$this->render('core_error.tpl');
return;
}
if ($this->post->new_pilotid < 1) {
$error = true;
$this->set('message', 'You cannot have an ID less than 1');
$this->render('core_error.tpl');
return;
}
if (empty($this->post->new_pilotid)) {
$error = true;
$this->set('message', 'The pilot ID is blank!');
$this->render('core_error.tpl');
return;
}
if (empty($this->post->old_pilotid) || $this->post->old_pilotid == 0) {
$error = true;
$this->set('message', 'No pilot selected');
$this->render('core_error.tpl');
return;
}
$pilot = PilotData::getPilotData($this->post->new_pilotid);
if (is_object($pilot)) {
$error = true;
$this->set('message', 'This ID is already used!');
$this->render('core_error.tpl');
return;
}
if ($error === false) {
PilotData::changePilotID($this->post->old_pilotid, $this->post->new_pilotid);
CodonEvent::Dispatch('pilotid_changed', 'Maintenance', array('old_pilotid' => $this->post->old_pilotid, 'new_pilotid' => $this->post->new_pilotid));
$this->set('message', "Pilot ID changed from {$this->post->old_pilotid} to {$this->post->new_pilotid}");
$this->render('core_success.tpl');
}
}
$this->set('allpilots', PilotData::findPilots(array()));
$this->render('maintenance_changepilotid.tpl');
}
<?php
include dirname(__FILE__) . '/bootstrap.inc.php';
echo '<pre>';
$pilot = PilotData::findPilots(array('p.totalflights > 0'));
$idx = rand(0, count($pilot) - 1);
$pilot = $pilot[$idx];
RanksData::calculateUpdatePilotRank($pilot->pilotid);
public function getpilotsjson()
{
$page = $this->get->page;
// get the requested page
$limit = $this->get->rows;
// get how many rows we want to have into the grid
$sidx = $this->get->sidx;
// get index row - i.e. user click to sort
$sord = $this->get->sord;
// get the direction
if (!$sidx) {
$sidx = 1;
}
/* Do the search using jqGrid */
$where = array();
if ($this->get->_search == 'true') {
$searchstr = jqgrid::strip($this->get->filters);
$where_string = jqgrid::constructWhere($searchstr);
# Append to our search, add 1=1 since it comes with AND
# from above
$where[] = "1=1 {$where_string}";
}
Config::Set('PILOT_ORDER_BY', "{$sidx} {$sord}");
# Do a search without the limits so we can find how many records
$count = count(PilotData::findPilots($where));
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
// do not put $limit*($page - 1)
if ($start < 0) {
$start = 0;
}
# And finally do a search with the limits
$allpilots = PilotData::findPilots($where, $limit, $start);
if (!$allpilots) {
$allpilots = array();
}
# Form the json header
$json = array('page' => $page, 'total' => $total_pages, 'records' => $count, 'rows' => array());
# Add each row to the above array
foreach ($allpilots as $row) {
$pilotid = PilotData::getPilotCode($row->code, $row->pilotid);
$status = $row->retired == 0 ? 'Active' : 'Retired';
$location = '<img src="' . Countries::getCountryImage($row->location) . '" alt="' . $row->location . '" />';
$edit = '<a href="' . adminurl('/pilotadmin/viewpilots?action=viewoptions&pilotid=' . $row->pilotid) . '">Edit</a>';
$tmp = array('id' => $row->id, 'cell' => array($row->id, $pilotid, $row->firstname, $row->lastname, $row->email, $location, $status, $row->rank, $row->totalflights, $row->totalhours, $row->lastip, $edit));
$json['rows'][] = $tmp;
}
header("Content-type: text/x-json");
echo json_encode($json);
}