Ejemplo n.º 1
0
    /**
     * 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;
    }