/**
* Get years list
* @param $clientID
* @param $projectID
* @return CActiveRecord[]
*/
public static function getYearsList($clientID, $projectID)
{
// create condition
$condition = new CDbCriteria();
$condition->select = 'distinct Year';
$condition->condition = "(t.Created_By = '" . Yii::app()->user->userID . "' OR t.Access_Type = '" . self::HAS_ACCESS . "')";
$condition->addCondition("t.Client_ID = '" . $clientID . "'");
if ($projectID != 'all') {
$condition->addCondition("t.Project_ID = '" . $projectID . "'");
}
$condition->order = "t.Year DESC";
// get storages
$years = Storages::model()->findAll($condition);
return $years;
}
/**
* Get Shelf for folder Create
* @param $projectID
* @param $year
* @return CActiveRecord
*/
public static function getShelfForBinderCreate($projectID, $year)
{
// get shelf
$shelf = Storages::model()->findByAttributes(array(
'Storage_Type' => Storages::SHELF,
'Created_By' => '0',
'Project_ID' => $projectID,
'Year' => $year,
));
if (!$shelf) {
Storages::createProjectStorages($projectID, $year);
// get shelf
$shelf = Storages::model()->findByAttributes(array(
'Storage_Type' => Storages::SHELF,
'Created_By' => '0',
'Project_ID' => $projectID,
'Year' => $year,
));
}
return $shelf;
}
