/**
* Create a aircraft
* @param array $params
* @return mixed
*/
public static function create($params)
{
if (!empty($params)) {
$aircraft = new Aircraft();
$aircraft->name = $params['name'];
$aircraft->type_id = $params['type_id'];
$aircraft->status_id = $params['status_id'];
$aircraft->save();
$aircraft->refresh();
return $aircraft->id;
}
return false;
}
function topAircraft()
{
$other = 0;
$result = array();
$names = array();
$chart = array();
$counter = $this->query()->select(DB::raw('aircraft_id, count(aircraft_id) as counter'))->groupBy('aircraft_id')->where('aircraft_id', '!=', '')->whereNotNull('aircraft_id')->orderBy('counter', 'DESC')->lists('counter', 'aircraft_id');
if (count($counter) > 0) {
$namesRaw = Aircraft::whereIn('code', array_slice(array_keys($counter), 0, 5))->get();
foreach ($namesRaw as $aircraft) {
$names[$aircraft->code][] = $aircraft;
}
$other = $this->_total - array_sum($counter);
}
foreach ($counter as $key => $flights) {
if (count($result) < 5 && array_key_exists($key, $names)) {
$percentage = $this->_total == 0 ? 0 : number_format($flights / $this->_total * 100, 1);
$result[] = array('data' => $names[$key], 'count' => $flights, 'percent' => $percentage, 'key' => $key);
if ($percentage > 0) {
$chart[] = [$key, $percentage];
}
} else {
$other += $flights;
}
}
$result['Other'] = array('count' => $other, 'percent' => $this->_total == 0 ? 0 : number_format($other / $this->_total * 100, 1), 'key' => 'Other');
$chart[] = ['Other', $result['Other']['percent']];
$piechartData = piechartData($chart);
return array('table' => $result, 'chart' => $piechartData['javascript'], 'colours' => $piechartData['colours']);
}
public function editAction()
{
$id = $this->_request->getParam("id");
$data = Aircraft::findById($id);
$form = new Form_AircraftEdit();
$form->name->setValue($data['name']);
$form->type_id->addMultiOptions(App_Utils::toList(AircraftType::findAll(), 'id', 'type'));
$form->status_id->setMultiOptions(App_Utils::toList(AircraftStatus::findAll(), 'id', 'status'));
$form->type_id->setValue($data['type_id']);
$form->aircraft_id->setValue($id);
$form->populate($data);
$options = array('title' => "Edit aircraft", 'url' => "/aircraft/edit/format/json/subaction/submit", 'button' => "Edit", 'success' => array("button" => array("title" => "Close", "action" => "close"), "redirect" => "/aircraft/index", "message" => "Aircraft {$form->name->getValue} modified correctly"), 'model' => array("class" => "Aircraft", "method" => "edit"));
$this->ajaxFormProcessor($form, $options);
}
public function editAction()
{
$id = $this->_request->getParam("id");
$data = User::findById($id);
$userAircrafts = App_Utils::toList($data['Aircraft'], "id", "id");
$form = new Form_UserEdit();
$form->role_id->addMultiOptions(App_Utils::toList(AclRole::findAll(), 'id', 'name'));
$form->aircraft->setMultiOptions(App_Utils::toList($data['Aircraft'], 'id', 'name'));
$form->aircraft_available->setMultiOptions(App_Utils::toList(Aircraft::findAll(array('exclude' => $userAircrafts)), 'id', 'name'));
$form->role_id->setValue($data['role_id']);
$form->user_id->setValue($id);
$form->populate($data);
$options = array('title' => "Edit User", 'url' => "/user/edit/format/json/subaction/submit", 'button' => "Edit", 'success' => array("button" => array("title" => "Close", "action" => "close"), "redirect" => "/user/list", "message" => "User {$form->first_name->getValue()} {$form->last_name->getValue()} modified correctly"), 'model' => array("class" => "User", "method" => "edit"));
$this->ajaxFormProcessor($form, $options);
}
/**
* Declares an association between this object and a Aircraft object.
*
* @param Aircraft $v
* @return MissionReport The current object (for fluent API support)
* @throws PropelException
*/
public function setAircraft(Aircraft $v = null)
{
if ($v === null) {
$this->setAircraftId(NULL);
} else {
$this->setAircraftId($v->getId());
}
$this->aAircraft = $v;
// Add binding for other direction of this n:n relationship.
// If this object has already been added to the Aircraft object, it will not be re-added.
if ($v !== null) {
$v->addMissionReport($this);
}
return $this;
}
/**
* Adds an object to the instance pool.
*
* Propel keeps cached copies of objects in an instance pool when they are retrieved
* from the database. In some cases -- especially when you override doSelect*()
* methods in your stub classes -- you may need to explicitly add objects
* to the cache in order to ensure that the same objects are always returned by doSelect*()
* and retrieveByPK*() calls.
*
* @param Aircraft $value A Aircraft object.
* @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally).
*/
public static function addInstanceToPool(Aircraft $obj, $key = null)
{
if (Propel::isInstancePoolingEnabled()) {
if ($key === null) {
$key = (string) $obj->getId();
}
// if key === null
self::$instances[$key] = $obj;
}
}
public function getAircraftName()
{
$aircraft = Aircraft::model()->findByAttributes(array('nIataCode' => strtolower($this->aircraftCode)));
if ($aircraft) {
return $aircraft->fullTitle;
}
return '';
}
public function indexAction()
{
$this->_addHeadTitle("Aircraft list");
$this->view->aircrafts = Aircraft::findAll();
}
/**
* Add or edit aircraft
* CODE:aircraft_create
*/
public function executeUpdate(sfWebRequest $request)
{
# security
if (!$this->getUser()->hasCredential(array('Administrator'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
sfContext::getInstance()->getConfiguration()->loadHelpers('Partial');
slot('nav_menu', array('reference', ''));
if ($request->getParameter('id')) {
$aircraft = AircraftPeer::retrieveByPK($request->getParameter('id'));
$this->forward404Unless($aircraft);
$this->title = 'Edit aircraft';
$success = 'Aircraft information has been successfully changed!';
} else {
$aircraft = new Aircraft();
$this->title = 'Add aircraft';
$success = 'Aircraft information has been successfully created!';
}
if ($request->getParameter('leg')) {
$this->leg_id = $request->getParameter('leg');
}
$this->form = new AircraftForm($aircraft);
if ($request->isMethod('post')) {
$this->referer = $request->getReferer();
$this->form->bind($request->getParameter('craft'));
if ($this->form->isValid() && $this->form->getValue('cost')) {
$aircraft->setMake($this->form->getValue('make'));
$aircraft->setModel($this->form->getValue('model'));
$aircraft->setName($this->form->getValue('name'));
$aircraft->setFaa($this->form->getValue('faa'));
if ($this->form->getValue('engines') == null) {
$aircraft->setEngines(0);
} else {
$aircraft->setEngines($this->form->getValue('engines'));
}
if ($this->form->getValue('def_seats') == null) {
$aircraft->setDefSeats(0);
} else {
$aircraft->setDefSeats($this->form->getValue('def_seats'));
}
$aircraft->setSpeed($this->form->getValue('speed'));
if ($this->form->getValue('pressurized') == null) {
$aircraft->setPressurized(0);
} else {
$aircraft->setPressurized($this->form->getValue('pressurized'));
}
$aircraft->setCost($this->form->getValue('cost'));
$aircraft->setRange($this->form->getValue('range'));
$aircraft->setAcLoad($this->form->getValue('ac_load'));
if ($aircraft->isNew()) {
$content = $this->getUser()->getName() . ' added new Aircraft: ' . $aircraft->getMakeModel();
ActivityPeer::log($content);
}
$aircraft->save();
$this->getUser()->setFlash('success', $success);
$back = '@aircraft';
if ($request->getParameter('leg_id')) {
$back = '@leg_edit?id=' . $request->getParameter('leg_id');
}
return $this->redirect($back);
}
} else {
# Set referer URL
$this->referer = $request->getReferer() ? $request->getReferer() : '@aircraft';
}
$this->aircraft = $aircraft;
}
public static function edit($params)
{
if (!empty($params)) {
$user = Doctrine::getTable("User")->findOneById($params['user_id']);
$user->id = $params['user_id'];
$user->first_name = $params['first_name'];
$user->last_name = $params['last_name'];
if (isset($params['role_id'])) {
$user->role_id = $params['role_id'];
}
$user->language = $params['language'];
if (!empty($params['aircraft']) || !empty($params['aircraft_available'])) {
$params['aircraft'] = isset($params['aircraft']) ? $params['aircraft'] : array();
$params['aircraft_available'] = isset($params['aircraft_available']) ? $params['aircraft_available'] : array();
Aircraft::deleteUserAircrafts($user->id, $params['aircraft']);
foreach ($params['aircraft_available'] as $aircraft) {
$user->Aircraft[] = Doctrine::getTable("Aircraft")->findOneById($aircraft);
}
}
$user->save();
return $user->id;
}
return false;
}
public function outputUnit()
{
$ac = new Aircraft();
$ac->build();
return $ac;
}
