/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Rota the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Rota::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public static function getListaRotas()
{
$criteria = new CDbCriteria();
$criteria->order = 'AeroportoOrigem.nome ASC';
$criteria->with = array('AeroportoOrigem', 'AeroportoDestino');
$criteria->addCondition('t.id_empresa = ' . Yii::app()->user->model->id_empresa);
$rotas = Rota::model()->findAll($criteria);
$listaRotas = array();
foreach ($rotas as $r) {
$listaRotas[$r->id] = "({$r->AeroportoOrigem->id}) {$r->AeroportoOrigem->nome} -> ({$r->AeroportoDestino->id}) {$r->AeroportoDestino->nome}";
}
return $listaRotas;
}
