Example #1
2
 /**
  * Delete
  * @param $CODE
  * @return array
  * @throws \Exception
  */
 public static function Delete($CODE)
 {
     $group = new \CGroup();
     $user = new \CUser();
     if (!empty($CODE)) {
         $by = "ID";
         $order = "asc";
         $dbGroup = $group->GetList($by, $order, array('STRING_ID' => $CODE));
         if ($arGroup = $dbGroup->Fetch()) {
             $arReturn = $arGroup;
         }
     } else {
         throw new BimException('Empty group code');
     }
     if (intval($arReturn['ID']) > 0) {
         $arUsers = $group->GetGroupUser($arReturn['ID']);
         foreach ($arUsers as $UserID) {
             $arGroup = $user->GetUserGroup($UserID);
             $arGroup[] = "3";
             $user->SetUserGroup($UserID, $arGroup);
         }
         $res = $group->Delete($arReturn['ID']);
         if (is_object($res)) {
             return $arReturn['ID'];
         } else {
             throw new BimException($group->LAST_ERROR);
         }
     } else {
         throw new BimException('Group not found');
     }
 }
Example #2
0
 /**
  * Получить список преподавателей кафедры.
  * @param mixed $kaf один или массив ID кафедры
  * @param bool $named брать ли имена вместе с numst
  * @return array [id_kaf=>[numst=>name]] или [id_kaf=>[numst]]
  */
 public static function prepsOfKaf($kaf, $named)
 {
     global $DB;
     $preps = array();
     $kaf = RPU::arr($kaf);
     $MsSQL1 = RPDB::connect();
     $STH = $MsSQL1->query("SELECT sh,id from kaf where id in(" . join(',', $kaf) . ")");
     $kafs = array();
     while ($row = $STH->fetch(PDO::FETCH_ASSOC)) {
         $kafs[$row['id']] = $row['sh'];
     }
     $MsSQL = RPDB::connect('iac');
     if ($kafs) {
         foreach ($kafs as $_id => $kaf) {
             $STH = $MsSQL1->query("SELECT id_group from roles_groups where id_role='{$kaf}_pr'");
             $gr_id = $STH->fetch(PDO::FETCH_ASSOC);
             if ($user_ids = CGroup::GetGroupUser($gr_id["id_group"])) {
                 foreach ($user_ids as $user_id) {
                     $rsUser = CUser::GetByID($user_id);
                     $arUser = $rsUser->Fetch();
                     if ($arUser['ACTIVE'] == 'Y') {
                         if (preg_match("/^[ut]?[0-9]{5,}/", trim($arUser['LOGIN']))) {
                             $numst = trim($arUser['LOGIN'], "ut");
                         } else {
                             $numst = -$user_id;
                         }
                         if ($named) {
                             $preps[$_id][$numst] = trim($arUser['LAST_NAME']) . ' ' . trim($arUser['NAME']) . ' ' . trim($arUser['SECOND_NAME']);
                         } else {
                             $preps[$_id][$numst] = $numst;
                         }
                     }
                 }
             }
         }
         $q = "select [Fam],[Name] as [Nam],[Otch],[Login] as [Numst],[NameEng] as gr FROM Students.dbo.RPK_Full_New ";
         $q_cond = array("[DepType]='Сотрудники'");
         $q_cond[] = " [NameEng] IN('" . join("','", $kafs) . "')";
         $q_cond[] = " [DepStatus]='У' ";
         if (count($q_cond) > 0) {
             $q .= " where " . join(' and ', $q_cond);
         }
         $q .= " order by [Fam],[Name],[Otch]";
         if ($STH = $MsSQL->query($q)) {
             $kafs = array_flip($kafs);
             while ($temp = $STH->fetch(PDO::FETCH_ASSOC)) {
                 $kaf = $kafs[$temp['gr']];
                 $numst = trim($temp['Numst']);
                 if (!isset($preps[$kaf])) {
                     $preps[$kaf] = array();
                 }
                 if ($named) {
                     $preps[$kaf][$numst] = trim($temp['Fam']) . ' ' . trim($temp['Nam']) . ' ' . trim($temp['Otch']);
                 } else {
                     $preps[$kaf][$numst] = $numst;
                 }
             }
         }
     }
     return $preps;
 }
Example #3
0
     $this->AbortResultCache();
     ShowError(GetMessage("IBLOCK_MODULE_NOT_INSTALLED"));
     return;
 }
 //Plug-in Blogs
 if (!CModule::IncludeModule("blog")) {
     $this->AbortResultCache();
     ShowError(GetMessage("BLOG_MODULE_NOT_INSTALLED"));
     return;
 }
 //Get the number of participants
 $participantsCount = CUser::GetCount();
 $arResult["PARTICIPANTS"] = $participantsCount;
 //Get the number of experts
 $groupId = $arParams["EXPERTS_GROUP"];
 $arExperts = CGroup::GetGroupUser($groupId);
 //Alternative CGroup::GetList with SHOW_USERS_AMOUNT
 $arResult["EXPERTS"] = count($arExperts);
 //Get the number of questions
 $arFilter = array("IBLOCK_ID" => $arParams["QUESTIONS_IBLOCK_ID"], "ACTIVE" => "Y");
 $arResult["QUESTIONS"] = CIBlockElement::GetList(array(), $arFilter, array(), false, array());
 //Get the number of categoties
 $arFilter = array("IBLOCK_ID" => $arParams["CATEGORIES_IBLOCK_ID"], "ACTIVE" => "Y", "DEPTH_LEVEL" => 1);
 $arResult["CATEGORIES"] = CIBlockSection::GetCount($arFilter);
 //Get the number of work
 $arFilter = array("IBLOCK_ID" => $arParams["WORK_IBLOCK_ID"], "ACTIVE" => "Y");
 $arResult["WORK"] = CIBlockElement::GetList(array(), $arFilter, array(), false, array());
 //Get the number of comments
 $arFilter = array("BLOG_ID" => $arParams["BLOG_ID"]);
 $arResult["COMMENTS"] = CBlogComment::GetList(array(), $arFilter, array(), false, array());
 //Plug-in tenplate