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 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 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 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 getVikladachOnlyGrupa($id_predmet)
{
$criteria = new CDbCriteria();
$modelPracivnuk = new Pracivnuku();
$fakult_id = Group::getIdFacultWherePracivnuk($modelPracivnuk->getUserIdGroupa());
$criteria->condition = "fakult_id='{$fakult_id}' and student_predmet_id='{$id_predmet}'";
$criteria->with = array('pracivnuku');
$model = new PracivnukuHasStudentPredmet();
$obj = $model->model()->findAll($criteria);
$array = array();
foreach ($obj as $arr) {
$array[$arr->pracivnuku->id] = $arr->pracivnuku->surname . " " . $arr->pracivnuku->name . " " . $arr->pracivnuku->middle_name;
}
return $array;
}
/**
*вертає масив працівнмків яким вже на поточний день відзвітовано
*/
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 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 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 static function getPracivnukuArrayThis()
{
$group_id == Pracivnuku::getUserIdGroupa();
$obj = self::model()->findAll("group_id='{$group_id}'");
$array = array();
foreach ($obj as $a) {
$array[] = $a->surname . " " . $a->name . " " . $a->middle_name;
}
return $array;
}
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 getFacultId()
{
$id_group = Pracivnuku::getUserIdGroupa();
return Group::isFacult($id_group);
}
