/** * Get Last Client PCs to session * @return array */ public static function getLastClientsPCs() { $lastPCs = array(); $pcsCl = new Pcs(); $condition = new CDbCriteria(); $condition->join = "LEFT JOIN documents ON documents.Document_ID=t.Document_ID"; $condition->addCondition("documents.Client_ID='" . Yii::app()->user->clientID . "'"); if (is_numeric(Yii::app()->user->projectID)) { $condition->addCondition("documents.Project_ID= '" . Yii::app()->user->projectID . "'"); } $condition->order = "t.Employee_Name ASC"; $condition->limit = 50; $pcs = $pcsCl->findAll($condition); $i = 1; foreach ($pcs as $pc) { $lastPCs[$i] = $pc->Document_ID; $i++; } return $lastPCs; }