public function actionTypeAhead($lookup) { $result = array(); // комиссии по защите дипломов. показываем только комиссии этого года $query = new CQuery(); $query->select("distinct(comm.id) as id, comm.title as name")->from(TABLE_SAB_COMMISSIONS . " as comm")->condition("comm.title like '%" . $lookup . "%' and year_id=" . CUtils::getCurrentYear()->getId())->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $comm = new CSABCommission(new CActiveRecord($item)); $value = $comm->title; if (!is_null($comm->manager)) { $value .= " " . $comm->manager->getName(); } if (!is_null($comm->secretar)) { $value .= " (" . $comm->secretar->getName() . ")"; } $diplom = CStaffManager::getDiplom(CRequest::getInt("diplom_id")); if (!is_null($diplom)) { $cnt = 0; foreach ($comm->diploms->getItems() as $d) { if (strtotime($diplom->date_act) == strtotime($d->date_act)) { $cnt++; } } $value .= " " . $cnt; } $result[$comm->getId()] = $value; } return $result; }
public function execute($contextObject) { $result = 0; if (!is_null($contextObject->terms)) { $terms = array(); foreach ($contextObject->terms->getItems() as $term) { $terms[] = $term->number; } } $termSectionsData = new CArrayList(); foreach ($contextObject->terms->getItems() as $term) { $query = new CQuery(); $query->select("sum(if(term.alias = 'lecture', l.value, 0)) as lecture")->from(TABLE_WORK_PLAN_CONTENT_SECTIONS . " as section")->innerJoin(TABLE_WORK_PLAN_CONTENT_LOADS . " as l", "l.section_id = section.id")->innerJoin(TABLE_TAXONOMY_TERMS . " as term", "term.id = l.load_type_id")->leftJoin(TABLE_WORK_PLAN_SELFEDUCATION . " as selfedu", "selfedu.load_id = l.id")->group("l.section_id")->condition("l.term_id = " . $term->getId()); $items = $query->execute(); if ($items->getCount() > 0) { $termSectionsData->add($term->getId(), $items); } } foreach ($termSectionsData->getItems() as $termId => $termData) { if (CBaseManager::getWorkPlanTerm($termId)->number == $terms[0]) { $result = 0; foreach ($termData as $row) { $result += $row["lecture"]; } } } return $result; }
public function execute($contextObject) { $result = array(); $terms = array(); $terms[] = "term.name"; $termIds = array(); foreach ($contextObject->terms->getItems() as $term) { $termIds[] = $term->getId(); $terms[] = "sum(if(l.term_id = " . $term->getId() . ", l.value, 0)) as t_" . $term->getId(); } if (count($termIds) > 0) { $terms[] = "sum(if(l.term_id in (" . join(", ", $termIds) . "), l.value, 0)) as t_sum"; } $query = new CQuery(); $query->select(join(", ", $terms))->from(TABLE_WORK_PLAN_CONTENT_LOADS . " as l")->innerJoin(TABLE_TAXONOMY_TERMS . " as term", "term.id = l.load_type_id")->innerJoin(TABLE_WORK_PLAN_CONTENT_SECTIONS . " as section", "l.section_id = section.id")->innerJoin(TABLE_WORK_PLAN_CONTENT_CATEGORIES . " as category", "section.category_id = category.id")->condition("category.plan_id = " . $contextObject->getId())->group("l.load_type_id")->order("term.name"); $objects = $query->execute(); foreach ($objects->getItems() as $key => $value) { $arr = array_values($value); $dataRow = array(); for ($i = 0; $i <= count($value) - 1; $i++) { $dataRow[$i] = $arr[$i]; } $result[] = $dataRow; } return $result; }
public function execute($contextObject) { $values = array(); $terms = array(); foreach ($contextObject->terms->getItems() as $term) { $terms[] = "sum(if(l.term_id = " . $term->getId() . ", l.value, 0)) as t_" . $term->getId(); } $query = new CQuery(); $query->select(join(", ", $terms))->from(TABLE_WORK_PLAN_CONTENT_LOADS . " as l")->innerJoin(TABLE_TAXONOMY_TERMS . " as term", "term.id = l.load_type_id")->innerJoin(TABLE_WORK_PLAN_CONTENT_SECTIONS . " as section", "l.section_id = section.id")->innerJoin(TABLE_WORK_PLAN_CONTENT_CATEGORIES . " as category", "section.category_id = category.id")->condition("category.plan_id = " . $contextObject->getId())->group("l.load_type_id")->order("term.name"); $objects = $query->execute(); $auditorTotal = 0; foreach ($objects->getItems() as $key => $value) { $arr = array_values($value); $dataRow = array(); for ($i = 0; $i <= count($value) - 1; $i++) { $dataRow[$i] = $arr[$i]; } foreach ($dataRow as $i) { $auditorTotal += $i; } } $selfWorkValueOfLoad = 0; foreach ($contextObject->corriculumDiscipline->labors->getItems() as $labor) { if ($labor->type->getAlias() == "self_work") { $selfWorkValueOfLoad = $labor->value; } } return $auditorTotal + $selfWorkValueOfLoad; }
public function actionGetViewData() { $result = array(); $query = new CQuery(); $query->select("term.id as id, term.name as name")->from(TABLE_WORK_PLAN_COMPETENTIONS . " as competention")->innerJoin(TABLE_TAXONOMY_TERMS . " as term", "term.id = competention.competention_id")->condition("competention.plan_id=" . CRequest::getInt("plan_id") . " AND competention.type=0")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { $result = array(); $query = new CQuery(); $query->select("distinct(stat.id) as id, stat.name as name")->from(TABLE_QUESTION_STATUS . " as stat"); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionTypeAhead($lookup) { $result = array(); $query = new CQuery(); $query->select("opinion.id as id, opinion.name as name")->from(TABLE_PROTOCOL_OPINIONS . " as opinion")->condition("opinion.name like '%" . $lookup . "%'")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { $result = array(); $query = new CQuery(); $query->select("taxonomy.id as id, taxonomy.name as name")->from(TABLE_TAXONOMY . " as taxonomy"); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { $result = array(); // выбор сотрудников $query = new CQuery(); $query->select("term.id as id, term.number as name")->from(TABLE_WORK_PLAN_TERMS . " as term")->condition("plan_id=" . CRequest::getInt("plan_id"))->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionTypeAhead($lookup) { $result = array(); // выбор пользователей $query = new CQuery(); $query->select("user.id as id, user.fio as name")->from(TABLE_USERS . " as user")->condition("user.fio like '%" . $lookup . "%'")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { $result = array(); // выбор сотрудников $query = new CQuery(); $query->select("category.id as id, category.title as name")->from(TABLE_WORK_PLAN_CONTENT_CATEGORIES . " as category")->condition("plan_id=" . CRequest::getInt("plan_id"))->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { // $result = array(); // выбор активных отчетов $query = new CQuery(); $query->select("report.id as id, report.title as name")->from(TABLE_REPORTS . " as report"); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { $result = array(); $plan = CWorkPlanManager::getWorkplan(CRequest::getInt("plan_id")); $query = new CQuery(); $query->select("parent.id as id, subject.name as name")->from(TABLE_CORRICULUM_DISCIPLINES . " as discipline")->innerJoin(TABLE_CORRICULUM_DISCIPLINES . " as parent", "parent.id = discipline.parent_id")->innerJoin(TABLE_DISCIPLINES . " as subject", "parent.discipline_id = subject.id")->condition("discipline.id = " . $plan->corriculum_discipline_id); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionTypeAhead($lookup) { $result = array(); // выбор студентов $query = new CQuery(); $query->select("distinct(student.id) as id, student.fio as name")->from(TABLE_STUDENTS . " as student")->condition("student.fio like '%" . $lookup . "%'")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { $result = array(); // показываем только должности, по которым нет ставок $query = new CQuery(); $query->select("distinct(post.id) as id, post.name as name")->from(TABLE_POSTS . " as post")->condition("id not in (select `dolgnost_id` from `hours_rate`)"); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionTypeAhead($lookup) { $result = array(); // выбор студенческих групп $query = new CQuery(); $query->select("distinct(gr.id) as id, gr.name as name")->from(TABLE_STUDENT_GROUPS . " as gr")->condition("gr.name like '%" . $lookup . "%'")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
/** * Все дисциплины учебного плана в алфавитном порядке * * @return CArrayList */ public function getDisciplines() { $disciplines = new CArrayList(); $query = new CQuery(); $query->select("d.*")->from(TABLE_CORRICULUM_DISCIPLINES . " as d")->innerJoin(TABLE_CORRICULUM_CYCLES . " as cycle", "d.cycle_id = cycle.id")->condition("cycle.corriculum_id = " . $this->getId())->innerJoin(TABLE_DISCIPLINES . " as discipline", "discipline.id = d.discipline_id")->order("discipline.name"); foreach ($query->execute() as $ar) { $discipline = new CCorriculumDiscipline(new CActiveRecord($ar)); $disciplines->add($discipline->getId(), $discipline); } return $disciplines; }
public function actionTypeAhead($lookup) { $result = array(); // выбор папок $query = new CQuery(); $query->select("folder.id as id, folder.title as name")->from(TABLE_DOCUMENT_FOLDERS . " as folder")->condition("folder.title like '%" . $lookup . "%'")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionGetViewData() { $result = array(); // выбор сотрудников $query = new CQuery(); $query->select("term.id as id, disc_term.title as name")->from(TABLE_WORK_PLAN_TERMS . " as term")->innerJoin(TABLE_CORRICULUM_DISCIPLINE_SECTIONS . " as disc_term", "disc_term.id = term.number")->condition("term.plan_id=" . CRequest::getInt("plan_id"))->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionTypeAhead($lookup) { $result = array(); // выбор сотрудников $query = new CQuery(); $query->select("person.id as id, person.fio as name")->from(TABLE_PERSON . " as person")->condition("person.fio like '%" . $lookup . "%'")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
/** * @param CTerm $year * @param $alias * @return CRate */ public static function getRateByAliasAndYear(CTerm $year, $alias) { if (!self::getCacheRates()->hasElement($year->getId() . "_" . $alias)) { $q = new CQuery(); $q->select("r.*")->from(TABLE_RATES . " as r")->condition("r.year_id = " . $year->getId() . " AND r.alias='" . $alias . "'"); foreach ($q->execute()->getItems() as $ar) { $rate = new CRate(new CActiveRecord($ar)); self::addToCache($rate); } } return self::getCacheRates()->getItem($year->getId() . "_" . $alias); }
/** * @return array */ public static function getCommissionsList() { $result = array(); $query = new CQuery(); $query->select("c.*")->from(TABLE_SAB_COMMISSIONS . " as c")->innerJoin(TABLE_YEARS . " as y", "c.year_id = y.id")->order("y.name desc"); foreach ($query->execute()->getItems() as $ar) { $commission = new CSABCommission(new CActiveRecord($ar)); $nv = $commission->title . " (" . $commission->year->getValue() . ")"; $result[$commission->getId()] = $nv; } return $result; }
public function actionGetViewData() { $result = array(); $plan = CWorkPlanManager::getWorkplan(CRequest::getInt("plan_id")); $discipline = CCorriculumsManager::getDiscipline($plan->corriculum_discipline_id); $query = new CQuery(); $query->select("term.id as id, term.title as name")->from(TABLE_CORRICULUM_DISCIPLINE_SECTIONS . " as term")->condition("discipline_id=" . $discipline->getId()); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function actionTypeAhead($lookup) { $result = array(); // унаследованная таксономия $taxonomy = CTaxonomyManager::getLegacyTaxonomy($this->taxonomy); $query = new CQuery(); $query->select("distinct(taxonomy.id) as id, taxonomy.name as name")->from($taxonomy->getTableName() . " as taxonomy")->condition("taxonomy.name like '%" . $lookup . "%'")->limit(0, 10); foreach ($query->execute()->getItems() as $item) { $result[$item["id"]] = $item["name"]; } return $result; }
public function save() { parent::save(); // берем все старые записи об участии и создаем их заново $q = new CQuery(); $q->remove(TABLE_EVENT_MEMBERSHIP)->condition("event_id=" . $this->getId())->execute(); // добавляем заново foreach ($this->getMembers()->getItems() as $item) { $q = new CQuery(); $q->insert(TABLE_EVENT_MEMBERSHIP, array("resource_id" => $item->getId(), "event_id" => $this->getId(), "calendar_id" => $this->getCalendar()->getId())); $q->execute(); } }
/** * Список пособий на портале * * @return CArrayList */ public function getManuals() { if (is_null($this->_manuals)) { $this->_manuals = new CArrayList(); $query = new CQuery(); $query->select("subj.*, doc.nameFolder as nameFolder, (select count(*) from files f where f.nameFolder = doc.nameFolder) as f_cnt")->from(TABLE_DISCIPLINES . " as subj")->leftJoin(TABLE_LIBRARY_DOCUMENTS . " as doc", "subj.id = doc.subj_id")->condition("doc.user_id=" . $this->id); foreach ($query->execute()->getItems() as $item) { $subject = new CDiscipline(new CActiveRecord($item)); $this->_manuals->add($subject->getId(), $subject); } } return $this->_manuals; }
public function actionSearch() { $res = array(); $term = CRequest::getString("query"); /** * Ищем группу по названию */ $query = new CQuery(); $query->select("st_group.id, st_group.name")->from(TABLE_STUDENT_GROUPS . " as st_group")->condition("LCASE(st_group.name) like '%" . mb_strtolower($term) . "%' and st_group.year_id =" . CUtils::getCurrentYear()->id)->limit(0, 5); foreach ($query->execute()->getItems() as $item) { $res[] = array("field" => "id", "value" => $item["id"], "label" => $item["name"], "class" => "CStudentGroup"); } echo json_encode($res); }
public function actionSearch() { $res = array(); $term = CRequest::getString("query"); /** * Поиск по ФИО сотрудника */ $query = new CQuery(); $query->select("distinct(person.id) as id, person.fio as name")->from(TABLE_PERSON . " as person")->condition("person.fio like '%" . $term . "%'")->limit(0, 5); foreach ($query->execute()->getItems() as $item) { $res[] = array("field" => "person.id", "value" => $item["id"], "label" => $item["name"], "class" => "CPerson"); } echo json_encode($res); }
public function actionEdit() { $query = new CQuery(); $query->select("user.*")->from(TABLE_USERS . " as user")->order("user.FIO asc"); $users = array(); foreach ($query->execute()->getItems() as $ar) { $user = new CUser(new CActiveRecord($ar)); $users[$user->getId()] = $user->FIO; } $quest = CQuestionManager::getQuestion(CRequest::getInt("id")); $this->setData("users", $users); $this->setData("quest", $quest); $this->renderView("__public/_question_add/edit.tpl"); }
public function execute($contextObject) { $terms = array(); $termIds = array(); foreach ($contextObject->terms->getItems() as $term) { $termIds[] = $term->getId(); } $query = new CQuery(); $query->select("sum(if(l.term_id in (" . join(", ", $termIds) . "), l.value, 0)) as t_sum")->from(TABLE_WORK_PLAN_CONTENT_LOADS . " as l")->innerJoin(TABLE_TAXONOMY_TERMS . " as term", "term.id = l.load_type_id")->innerJoin(TABLE_WORK_PLAN_CONTENT_SECTIONS . " as section", "l.section_id = section.id")->innerJoin(TABLE_WORK_PLAN_CONTENT_CATEGORIES . " as category", "section.category_id = category.id")->condition("category.plan_id = " . $contextObject->getId()); $objects = $query->execute(); $result = 0; foreach ($objects->getItems() as $key => $value) { $result += $value["t_sum"]; } return $result; }