public function getRangNamePrac($id)
{
$rangObject = new Rang();
$pracivnukuObject = new Pracivnuku();
$arr = $pracivnukuObject->returnArray($id);
$id_rang = $arr['rang'];
$array = array();
foreach ($rangObject->model()->findAll("id='{$id_rang}'") as $arr) {
foreach ($arr as $k => $v) {
$array[$k] = $v;
}
}
return $array;
}
public function getDegreeNamePrac($id)
{
$objectPracivnuku = new Pracivnuku();
$objectDegre = new Degree();
$arr = $objectPracivnuku->returnArray($id);
$id_degree = $arr['degree'];
$arrDegree = $objectDegre->model()->findAll("id='{$id_degree}'");
$arrayDegree = array();
foreach ($arrDegree as $arr) {
foreach ($arr as $k => $v) {
$arrayDegree[$k] = $v;
}
}
return $arrayDegree;
}
/**
*вертає масив працівнмків яким вже на поточний день відзвітовано
*/
public static function returnVnesPropusk()
{
$model = new PracivnukuWednesday();
$pracObj = new Pracivnuku();
$id_pidrozdil = $pracObj->getUserIdGroupa();
$date = date("Y-m-d");
$criteria = new CDbCriteria();
$criteria->condition = "id_pidrozdil='{$id_pidrozdil}' and data_vnesenya='{$date}'";
$obj = $model->model()->findAll($criteria);
$array = array();
foreach ($obj as $arr) {
$array[$arr->id_pracivnuk] = $arr->idTitlePropusk->title;
}
return $array;
}
/**
викладачі конкретного предмету
*/
public static function getVukladachPredmet($student_predmet_id, $fakult_id)
{
$model = new PracivnukuHasStudentPredmet();
$arrayObj = $model->model()->findAll("student_predmet_id='{$student_predmet_id}' and fakult_id='{$fakult_id}'");
$array = array();
foreach ($arrayObj as $arr) {
$pracivnuku_id = $arr->pracivnuku_id;
$array[$pracivnuku_id] = Pracivnuku::getOneNamePracivnuk($pracivnuku_id);
}
return $array;
}
public static function getGrupaOnlyThisFacultKurs($kurs_id)
{
$id = Pracivnuku::getUserIdGroupa();
$facultet_id = Group::getIdFacultWherePracivnuk($id);
$model = new StudentGrupa();
$arr = $model->model()->findAll("facultet_id='{$facultet_id}' and kurs_id='{$kurs_id}'");
$arrayGrupa = array();
foreach ($arr as $array) {
$arrayGrupa[$array->id] = $array->grupa_title;
}
return $arrayGrupa;
}
public static function returnOnlyKafedraFacult()
{
$id = Pracivnuku::getUserIdGroupa();
$fak_id = Group::getIdFacultWherePracivnuk($id);
$model = new Kafedra();
$arr = $model->model()->findAll("fak_id='{$fak_id}'");
$arrayKafedra = array();
foreach ($arr as $array) {
$arrayKafedra[$array->id] = $array->name;
}
return $arrayKafedra;
}
public static function returnOnlyPredmetFacult()
{
$id = Pracivnuku::getUserIdGroupa();
$fakult_id = Group::getIdFacultWherePracivnuk($id);
$model = new StudentPredmet();
$arr = $model->model()->findAll("fakult_id='{$fakult_id}'");
$arrayPredmet = array();
foreach ($arr as $array) {
$arrayPredmet[$array->id] = $array->title;
}
return $arrayPredmet;
}
public static function getNapryamFacult()
{
$id = Pracivnuku::getUserIdGroupa();
$facult_id = Group::getIdFacultWherePracivnuk($id);
$model = new NapryamPidg();
$arr = $model->model()->findAll("facult_id='{$facult_id}'");
$arrayGrupa = array();
foreach ($arr as $array) {
$arrayGrupa[$array->id] = $array->title . " / " . $array->kod;
}
return $arrayGrupa;
}
public function getDataProviderTabel()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$id_pidrozdil = Pracivnuku::getUserIdGroupa();
$week = date("W");
$criteria->compare("t.id_pidrozdil", $this->id_pidrozdil, true);
$criteria->compare("t.week", $this->week, true);
$criteria->condition = "t.id_pidrozdil='{$id_pidrozdil}' and t.week='{$week}'";
$criteria->with = array('idPidrozdil', 'pracivnukuWednesday', 'pracivnukuFriday', 'pracivnukuMonday', 'pracivnukuSaturday', 'pracivnukuSunday', 'pracivnukuThursday', 'pracivnukuTuesday');
return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 99)));
}
public function getDataProviderNoCloseKafedra()
{
$criteria = new CDbCriteria();
$kaf_id = Pracivnuku::getUserIdGroupa();
$criteria->compare('t.kaf_id', $this->kaf_id, true);
$criteria->condition = "data_paper='-' and t.kaf_id='{$kaf_id}' and del_z!='1'";
$criteria->with = array("kaf", "fnav0", "nazva_dis0", "fkon0", "fkon20", "vikl10", "vikl20", "grupa0", "operator0");
return new CActiveDataProvider("Vidomist", array('criteria' => $criteria));
}
public static function getCountNadisl()
{
$modelPracivnuku = new Pracivnuku();
$sender_pracivnuku_id = $modelPracivnuku->getUserId();
$arr = self::model()->findAll("sender_pracivnuku_id='{$sender_pracivnuku_id}'");
return count($arr);
}
public static function getFacultId()
{
$id_group = Pracivnuku::getUserIdGroupa();
return Group::isFacult($id_group);
}
public static function getOnePracivnukData($id)
{
$model = new Pracivnuku();
$array = $model->model()->find("id='{$id}'");
$arr = array();
foreach ($array as $k => $v) {
$arr[$k] = $v;
}
return $arr;
}
public static function getCountNewDocument($group_docs)
{
$id_group = Pracivnuku::getUserIdGroupa();
$model = new Esd();
$arr = $model->model()->findAll("id_group='{$id_group}' and data_view='-' and group_docs='{$group_docs}'");
return count($arr);
}
/**
*вертає масив працівнмків яким вже на поточний день відзвітовано
*/
public static function returnVnesPropusk()
{
switch (date("l")) {
case 'Sunday':
$idTitlePropusk = 'PracivnukuSunday';
break;
case 'Saturday':
$idTitlePropusk = 'PracivnukuSaturday';
break;
case 'Friday':
$idTitlePropusk = 'PracivnukuFriday';
break;
case 'Thursday':
$idTitlePropusk = 'PracivnukuThursday';
break;
case 'Wednesday':
$idTitlePropusk = 'PracivnukuWednesday';
break;
case 'Tuesday':
$idTitlePropusk = 'PracivnukuTuesday';
break;
case 'Monday':
$idTitlePropusk = 'PracivnukuMonday';
break;
}
$model = new $idTitlePropusk();
$pracObj = new Pracivnuku();
$id_pidrozdil = $pracObj->getUserIdGroupa();
$date = date("Y-m-d");
$criteria = new CDbCriteria();
$criteria->condition = "id_pidrozdil='{$id_pidrozdil}' and data_vnesenya='{$date}'";
$obj = $model->model()->findAll($criteria);
$array = array();
foreach ($obj as $arr) {
$array[$arr->id_pracivnuk] = $arr->idTitlePropusk->title;
}
return $array;
}
public static function arrQuestionPracivnuk()
{
$pracivnuk_id = Pracivnuku::getIdPracivnuk(Yii::app()->user->name);
return Contact::model()->findAll("pracivnuk_id='{$pracivnuk_id}'");
}
public static function returnAllPropusk()
{
$id_fakult = Facult::getFacultId();
$id_group = Pracivnuku::getUserIdGroupa();
$criteria = new CDbCriteria();
$criteria->condition = !empty($id_fakult) ? "id_fakult='{$id_fakult}' and propusk_god!=0" : "propusk_god!=0";
$criteria->with = array("idGrupa");
$criteria->group = "id_grupa";
return StudentPropusk::model()->findAll($criteria);
}
public function selectPermissionsPracivnuk()
{
$modelPrac = new Pracivnuku();
$id_pracivnuk = $modelPrac->getUserId();
$access = Permissions::model()->find("id_pracivnuk='{$id_pracivnuk}'");
if (is_object($access)) {
$permissionArray = array();
foreach ($access as $k => $v) {
$permissionArray[$k] = $v;
}
$_SESSION['permissions'] = $permissionArray;
}
}
