/** * @return Array|null */ public function fetch() { $result = null; if ($this->resource) { $result = $this->resource->fetch(); } elseif ($this->resourceCDBResult) { $result = $this->resourceCDBResult->Fetch(); } if ($result) { $result = $this->fetchModifierFields($result); } return $result && count($result) > 0 ? $result : null; }
public function GetNotifyList($arParams) { global $DB; $iNumPage = 1; if (isset($arParams['PAGE']) && intval($arParams['PAGE']) > 0) { $iNumPage = intval($arParams['PAGE']); } $bTimeZone = isset($arParams['USE_TIME_ZONE']) && $arParams['USE_TIME_ZONE'] == 'N' ? false : true; $sqlStr = "\n\t\t\tSELECT COUNT(M.ID) as CNT\n\t\t\tFROM b_im_relation R\n\t\t\tINNER JOIN b_im_message M ON M.NOTIFY_READ = 'Y' AND M.CHAT_ID = R.CHAT_ID\n\t\t\tWHERE R.USER_ID = " . $this->user_id . " AND R.MESSAGE_TYPE = '" . IM_MESSAGE_SYSTEM . "'\n\t\t"; $res_cnt = $DB->Query($sqlStr); $res_cnt = $res_cnt->Fetch(); $cnt = $res_cnt["CNT"]; $arNotify = array(); if ($cnt > 0) { if (!$bTimeZone) { CTimeZone::Disable(); } $strSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tM.ID,\n\t\t\t\t\tM.CHAT_ID,\n\t\t\t\t\tM.MESSAGE,\n\t\t\t\t\tM.MESSAGE_OUT,\n\t\t\t\t\t" . $DB->DateToCharFunction('M.DATE_CREATE') . " DATE_CREATE,\n\t\t\t\t\tM.NOTIFY_TYPE,\n\t\t\t\t\tM.NOTIFY_MODULE,\n\t\t\t\t\tM.NOTIFY_TITLE,\n\t\t\t\t\tM.NOTIFY_BUTTONS,\n\t\t\t\t\tM.NOTIFY_TAG,\n\t\t\t\t\tM.NOTIFY_SUB_TAG,\n\t\t\t\t\tM.NOTIFY_READ,\n\t\t\t\t\tR.LAST_ID,\n\t\t\t\t\tR.USER_ID TO_USER_ID,\n\t\t\t\t\tM.AUTHOR_ID FROM_USER_ID\n\t\t\t\tFROM b_im_relation R\n\t\t\t\tINNER JOIN b_im_message M ON M.NOTIFY_READ = 'Y' AND M.CHAT_ID = R.CHAT_ID\n\t\t\t\tWHERE R.USER_ID = " . $this->user_id . " AND R.MESSAGE_TYPE = '" . IM_MESSAGE_SYSTEM . "'\n\t\t\t\tORDER BY M.DATE_CREATE DESC, ID DESC\n\t\t\t"; if (!$bTimeZone) { CTimeZone::Enable(); } $dbRes = new CDBResult(); $dbRes->NavQuery($strSql, $cnt, array('iNumPage' => $iNumPage, 'nPageSize' => 20)); while ($arRes = $dbRes->Fetch()) { if ($this->bHideLink) { $arRes['HIDE_LINK'] = 'Y'; } $arNotify[$arRes['ID']] = self::GetFormatNotify($arRes); } } return $arNotify; }
/** * Gets array with one row of selected data. * Calls CDBResult->Fetch() * * @return array|false */ public function fetch() { if (is_null($this->selectResult)) { $this->getResult(); } return $this->selectResult->Fetch(); }
/** * Returns HTML multiple "select" * * @param string $strBoxName Input name * @param CDBResult $a DB result with items * @param array $arr Selected values * @param string $strDetText Empty item text * @param bool $strDetText_selected Allow to choose an empty item * @param string $size Size attribute * @param string $field1 Additional attributes * @return string */ function SelectBoxM($strBoxName, $a, $arr, $strDetText = "", $strDetText_selected = false, $size = "5", $field1 = "class=\"typeselect\"") { $strReturnBox = "<select " . $field1 . " multiple name=\"" . $strBoxName . "\" id=\"" . $strBoxName . "\" size=\"" . $size . "\">"; if ($strDetText != '') { $strReturnBox = $strReturnBox . "<option "; if ($strDetText_selected) { $strReturnBox = $strReturnBox . " selected "; } $strReturnBox = $strReturnBox . " value='NOT_REF'>" . $strDetText . "</option>"; } while ($ar = $a->Fetch()) { $reference_id = $ar["REFERENCE_ID"]; $reference = $ar["REFERENCE"]; if ($reference_id == '') { $reference_id = $ar["reference_id"]; } if ($reference == '') { $reference = $ar["reference"]; } $sel = is_array($arr) && in_array($reference_id, $arr) ? "selected" : ""; $strReturnBox = $strReturnBox . "<option " . $sel; $strReturnBox = $strReturnBox . " value=\"" . htmlspecialcharsbx($reference_id) . "\">" . htmlspecialcharsbx($reference) . "</option>"; } return $strReturnBox . "</select>"; }
function Fetch() { static $arSite = array(); $r = parent::Fetch(); if ($r) { $site_id = $r["SITE_ID"]; if (!isset($arSite[$site_id])) { $rsSite = CSite::GetList($b, $o, array("ID" => $site_id)); $arSite[$site_id] = $rsSite->Fetch(); } $r["DIR"] = $arSite[$site_id]["DIR"]; $r["SERVER_NAME"] = $arSite[$site_id]["SERVER_NAME"]; if (strlen($r["SITE_URL"]) > 0) { $r["URL"] = $r["SITE_URL"]; } if (substr($r["URL"], 0, 1) == "=") { foreach (GetModuleEvents("search", "OnSearchGetURL", true) as $arEvent) { $r["URL"] = ExecuteModuleEventEx($arEvent, array($r)); } } $r["URL"] = str_replace(array("#LANG#", "#SITE_DIR#", "#SERVER_NAME#"), array($r["DIR"], $r["DIR"], $r["SERVER_NAME"]), $r["URL"]); $r["URL"] = preg_replace("'(?<!:)/+'s", "/", $r["URL"]); unset($r["SITE_URL"]); } return $r; }
public static function Fetch() { global $DB; $res = parent::Fetch(); if (!is_object($this)) { return $res; } if ($res) { if (isset($res["USER_ID"])) { $USER_ID = intval($res["USER_ID"]); } elseif (isset($res["LAST_USER_ID"])) { $USER_ID = intval($res["LAST_USER_ID"]); } else { $USER_ID = 0; } if ($USER_ID > 0 && !isset($res["LOGIN"])) { $rsUser = $DB->Query("\n\t\t\t\t\tSELECT LOGIN, " . $DB->Concat($DB->IsNull("NAME", "''"), "' '", $DB->IsNull("LAST_NAME", "''")) . " USER_NAME\n\t\t\t\t\tFROM b_user\n\t\t\t\t\tWHERE ID = " . $USER_ID . "\n\t\t\t\t"); $arUser = $rsUser->Fetch(); if (is_array($arUser)) { $res["LOGIN"] = $arUser["LOGIN"]; $res["USER_NAME"] = $arUser["USER_NAME"]; } else { $res["LOGIN"] = ""; $res["USER_NAME"] = " "; } } } return $res; }
function getList($blockId, $fields, $order, $filers) { $entity_requests_data_class = connectToBlock($blockId); $main_query_requests = new Entity\Query($entity_requests_data_class); $main_query_requests->setSelect($fields); //$main_query_requests->setSelect(array('ID','UF_TITLE')); if (!empty($order)) { $main_query_requests->setOrder($order); } if (!empty($filers)) { $main_query_requests->setFilter($filers); /*$main_query_requests->setFilter( array( 'UF_NAME'=>'Александр', ) );*/ } $result_requests = $main_query_requests->exec(); $result_requests = new CDBResult($result_requests); $requests = array(); while ($row_requests = $result_requests->Fetch()) { $requests[] = $row_requests; //массив выбранных элементов } return $requests; }
function Fetch() { $a = parent::Fetch(); if ($a && defined("BX_COMP_MANAGED_CACHE")) { $GLOBALS["CACHE_MANAGER"]->RegisterTag("iblock_property_enum_" . $a["PROPERTY_ID"]); } return $a; }
function Fetch() { $r = parent::Fetch(); if($r) { $r["ID"] = $r["CITY_ID"]; $r["NAME"] = $r["CITY_NAME"]; } return $r; }
public function Fetch() { $r = parent::Fetch(); if($r) { if(strlen($r["SITE_URL"])>0) $r["URL"] = $r["SITE_URL"]; if(substr($r["URL"], 0, 1)=="=") { $events = GetModuleEvents("search", "OnSearchGetURL"); while ($arEvent = $events->Fetch()) $r["URL"] = ExecuteModuleEventEx($arEvent, array($r)); } $r["URL"] = str_replace( array("#LANG#", "#SITE_DIR#", "#SERVER_NAME#"), array($r["DIR"], $r["DIR"], $r["SERVER_NAME"]), $r["URL"] ); $r["URL"] = preg_replace("'(?<!:)/+'s", "/", $r["URL"]); $r["NAME"] = htmlspecialcharsex($r["TITLE"]); $preg_template = "/(^|[^".$this->_arStemFunc["pcre_letters"]."])(".str_replace("/", "\\/", implode("|", array_map('preg_quote', array_keys($this->_arPhrase)))).")/i".BX_UTF_PCRE_MODIFIER; if(preg_match_all($preg_template, ToUpper($r["NAME"]), $arMatches, PREG_OFFSET_CAPTURE)) { $c = count($arMatches[2]); if(defined("BX_UTF")) { for($j = $c-1; $j >= 0; $j--) { $prefix = mb_substr($r["NAME"], 0, $arMatches[2][$j][1], 'latin1'); $instr = mb_substr($r["NAME"], $arMatches[2][$j][1], mb_strlen($arMatches[2][$j][0], 'latin1'), 'latin1'); $suffix = mb_substr($r["NAME"], $arMatches[2][$j][1] + mb_strlen($arMatches[2][$j][0], 'latin1'), mb_strlen($r["NAME"], 'latin1'), 'latin1'); $r["NAME"] = $prefix."<b>".$instr."</b>".$suffix; } } else { for($j = $c-1; $j >= 0; $j--) { $prefix = substr($r["NAME"], 0, $arMatches[2][$j][1]); $instr = substr($r["NAME"], $arMatches[2][$j][1], strlen($arMatches[2][$j][0])); $suffix = substr($r["NAME"], $arMatches[2][$j][1]+strlen($arMatches[2][$j][0])); $r["NAME"] = $prefix."<b>".$instr."</b>".$suffix; } } } } return $r; }
/** * Convert CDBResult to array. * */ public static function CDBResultToArray(CDBResult $CDBResult) { if ($CDBResult->SelectedRowsCount() == 0) { return array(); } $ret = array(); while ($row = $CDBResult->Fetch()) { $ret[] = $row; } return $ret; }
public static function Fetch() { global $DB; $ar = parent::Fetch(); if ($ar) { if (isset($ar["Tables_in_" . $DB->DBName])) { $ar = array("TABLE_NAME" => $ar["Tables_in_" . $DB->DBName], "ENGINE_TYPE" => "", "NUM_ROWS" => "", "BYTES" => ""); } else { $ar = array("TABLE_NAME" => $ar["Name"], "ENGINE_TYPE" => $ar["Comment"] === "VIEW" ? "VIEW" : $ar["Engine"], "NUM_ROWS" => $ar["Rows"], "BYTES" => $ar["Data_length"]); } } return $ar; }
function elemGetEx($elemId = false) { $hlHandler = $this->hlHandler; $getList = new Entity\Query($hlHandler); $getList->setSelect(array('*')); $getList->setOrder(array("ID" => "ASC")); if (!empty($elemId)) { $getList->setFilter(array("ID" => $elemId)); } $result = $getList->exec(); $result = new CDBResult($result); $arRes = array(); while ($row = $result->Fetch()) { $arRes[] = $row; } return $arRes; }
function Fetch() { $res = parent::Fetch(); if ($res && $res["USER_TYPE"] != "") { $arUserType = CIBlockProperty::GetUserType($res["USER_TYPE"]); if (array_key_exists("ConvertFromDB", $arUserType)) { if (array_key_exists("VALUE", $res)) { $value = array("VALUE" => $res["VALUE"], "DESCRIPTION" => ""); $value = call_user_func_array($arUserType["ConvertFromDB"], array($res, $value)); $res["VALUE"] = $value["VALUE"]; } if (array_key_exists("DEFAULT_VALUE", $res)) { $value = array("VALUE" => $res["DEFAULT_VALUE"], "DESCRIPTION" => ""); $value = call_user_func_array($arUserType["ConvertFromDB"], array($res, $value)); $res["DEFAULT_VALUE"] = $value["VALUE"]; } } if (strlen($res["USER_TYPE_SETTINGS"])) { $res["USER_TYPE_SETTINGS"] = unserialize($res["USER_TYPE_SETTINGS"]); } } return $res; }
public static function GetCityList() { $arResult = array(); $rsData = \Bitrix\Highloadblock\HighloadBlockTable::getList(array('filter'=>array('NAME'=>CITY_LIST_HLB))); if ( !($arData = $rsData->fetch()) ){ echo 'Инфоблок не найден'; } else { $Entity = \Bitrix\Highloadblock\HighloadBlockTable::compileEntity($arData); $Query = new \Bitrix\Main\Entity\Query($Entity); $Query->setSelect(array('*')); $result = $Query->exec(); $result = new CDBResult($result); while ($row = $result->Fetch()){ $arResult[$row['UF_CITY_CODE']] = $row['UF_CITY_NAME']; } } return $arResult; }
function GetMoreChatMessage($pageId, $chatId, $bTimeZone = true) { global $DB; $iNumPage = 1; if (intval($pageId) > 0) { $iNumPage = intval($pageId); } $chatId = IntVal($chatId); $limitById = ''; $ar = \CIMChat::GetRelationById($chatId, $this->user_id); if ($ar && $ar['START_ID'] > 0) { $limitById = 'AND M.ID >= ' . intval($ar['START_ID']); } $strSql = "\n\t\t\tSELECT COUNT(M.ID) as CNT\n\t\t\tFROM b_im_message M\n\t\t\tINNER JOIN b_im_relation R1 ON M.CHAT_ID = R1.CHAT_ID\n\t\t\tWHERE R1.CHAT_ID = " . $chatId . " AND R1.USER_ID = " . $this->user_id . " " . $limitById . "\n\t\t"; $res_cnt = $DB->Query($strSql); $res_cnt = $res_cnt->Fetch(); $cnt = $res_cnt["CNT"]; $arMessages = array(); $arMessageFiles = array(); $arMessageId = array(); $usersMessage = array(); if ($cnt > 0 && ceil($cnt / 20) >= $iNumPage) { if (!$bTimeZone) { CTimeZone::Disable(); } $strSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tM.ID,\n\t\t\t\t\tM.CHAT_ID,\n\t\t\t\t\tM.MESSAGE,\n\t\t\t\t\t" . $DB->DatetimeToTimestampFunction('M.DATE_CREATE') . " DATE_CREATE,\n\t\t\t\t\tM.AUTHOR_ID\n\t\t\t\tFROM b_im_message M\n\t\t\t\tINNER JOIN b_im_relation R1 ON M.CHAT_ID = R1.CHAT_ID\n\t\t\t\tWHERE R1.CHAT_ID = " . $chatId . " AND R1.USER_ID = " . $this->user_id . " " . $limitById . "\n\t\t\t\tORDER BY M.DATE_CREATE DESC, M.ID DESC\n\t\t\t"; if (!$bTimeZone) { CTimeZone::Enable(); } $dbRes = new CDBResult(); $dbRes->NavQuery($strSql, $cnt, array('iNumPage' => $iNumPage, 'nPageSize' => 20)); $CCTP = new CTextParser(); $CCTP->MaxStringLen = 200; $CCTP->allow = array("HTML" => "N", "ANCHOR" => $this->bHideLink ? "N" : "Y", "BIU" => "Y", "IMG" => "N", "QUOTE" => "N", "CODE" => "N", "FONT" => "N", "LIST" => "N", "SMILES" => $this->bHideLink ? "N" : "Y", "NL2BR" => "Y", "VIDEO" => "N", "TABLE" => "N", "CUT_ANCHOR" => "N", "ALIGN" => "N"); while ($arRes = $dbRes->Fetch()) { $arMessages[$arRes['ID']] = array('id' => $arRes['ID'], 'chatId' => $arRes['CHAT_ID'], 'senderId' => $arRes['AUTHOR_ID'], 'recipientId' => $arRes['CHAT_ID'], 'date' => $arRes['DATE_CREATE'], 'system' => $arRes['AUTHOR_ID'] > 0 ? 'N' : 'Y', 'text' => $CCTP->convertText(htmlspecialcharsbx($arRes['MESSAGE']))); $usersMessage[$arRes['CHAT_ID']][] = $arRes['ID']; $arMessageId[] = $arRes['ID']; } $params = CIMMessageParam::Get($arMessageId); $arFiles = array(); foreach ($params as $messageId => $param) { $arMessages[$messageId]['params'] = $param; if (isset($param['FILE_ID'])) { foreach ($param['FILE_ID'] as $fileId) { $arFiles[$fileId] = $fileId; } } } $arMessageFiles = CIMDisk::GetFiles($chatId, $arFiles); } return array('chatId' => $chatId, 'message' => $arMessages, 'usersMessage' => $usersMessage, 'files' => $arMessageFiles); }
function Fetch() { $res = parent::Fetch(); if ($res) { if (array_key_exists("DOCUMENT_TYPE", $res)) { $res["DOCUMENT_TYPE"] = array($res["MODULE_ID"], $res["ENTITY"], $res["DOCUMENT_TYPE"]); } if (array_key_exists("TEMPLATE", $res)) { $res["TEMPLATE"] = $this->GetFromSerializedForm($res["TEMPLATE"]); } if (array_key_exists("VARIABLES", $res)) { $res["VARIABLES"] = $this->GetFromSerializedForm($res["VARIABLES"]); } if (array_key_exists("CONSTANTS", $res)) { $res["CONSTANTS"] = $this->GetFromSerializedForm($res["CONSTANTS"]); } if (array_key_exists("PARAMETERS", $res)) { $res["PARAMETERS"] = $this->GetFromSerializedForm($res["PARAMETERS"]); $arParametersKeys = array_keys($res["PARAMETERS"]); foreach ($arParametersKeys as $parameterKey) { $res["PARAMETERS"][$parameterKey]["Type"] = $res["PARAMETERS"][$parameterKey]["Type"]; } } } return $res; }
/** * @param \CDBResult $dbResultList * @return array */ protected function makeItemsFromDbResult(\CDBResult $dbResultList) { $arItemsResult = $arProductIds = array(); while ($arItem = $dbResultList->Fetch()) { if ($arItem['TYPE'] != 'S') { $arProductIds[] = $arItem['ID']; $arItem['PROPERTIES'] = $this->getItemProperies($arItem['ID']); } $arItemsResult[$arItem['ID']] = $arItem; } if (!empty($arProductIds)) { $dbCatalogProduct = \CCatalogProduct::GetList(array(), array("ID" => $arProductIds)); while ($arCatalogProduct = $dbCatalogProduct->fetch()) { $arItemsResult[$arCatalogProduct["ID"]]['PRODUCT'] = $arCatalogProduct; } $offersExistsIds = \CCatalogSKU::getExistOffers($arProductIds, $this->getIblockId()); $noOffersIds = array(); if ($offersExistsIds === false) { $noOffersIds = $arProductIds; } else { $this->loadAllSku(array_keys(array_filter($offersExistsIds))); foreach ($offersExistsIds as $id => $bExists) { $arItem =& $arItemsResult[$id]; if ($bExists) { $arItem['SKU_ITEMS'] = $this->getProductSku($arItem); } else { $noOffersIds[] = $id; } } } if (!empty($noOffersIds)) { $priceIds = $this->getVisiblePrices(); foreach ($priceIds as $priceId) { $dbPrice = \CPrice::GetList(array(), array('PRODUCT_ID' => $noOffersIds, 'CATALOG_GROUP_ID' => $priceId), false, false, array('PRODUCT_ID', 'PRICE', 'CURRENCY')); while ($arPrice = $dbPrice->fetch()) { $arItemsResult[$arPrice["PRODUCT_ID"]]['PRICES'][$priceId] = array('PRICE' => $arPrice['PRICE'], 'CURRENCY' => $arPrice['CURRENCY']); } } if ($this->getStoreId()) { $dbStoreProduct = \CCatalogStoreProduct::GetList(array(), array("PRODUCT_ID" => $noOffersIds, "STORE_ID" => $this->getStoreId())); while ($arStoreProduct = $dbStoreProduct->Fetch()) { $arItemsResult[$arStoreProduct["PRODUCT_ID"]]['PRODUCT']['STORE_AMOUNT'] = $arStoreProduct["AMOUNT"]; } } $groupsIterator = CCatalogProductSet::getList(array(), array('OWNER_ID' => $noOffersIds, 'SET_ID' => 0, 'TYPE' => \CCatalogProductSet::TYPE_GROUP), false, false, array('ID', 'OWNER_ID', 'ITEM_ID', 'SET_ID', 'TYPE')); while ($group = $groupsIterator->Fetch()) { if ($group['OWNER_ID'] == $group['ITEM_ID']) { $arItemsResult[$group['OWNER_ID']]['PRODUCT']['IS_GROUP'] = true; } } } } return $arItemsResult; }
function Fetch() { $arr = array(); $arr_lid = array(); $arr_lids = array(); if ($res = parent::Fetch()) { if ($this->type != "none") { $db_res_ = CEventType::GetList(array("EVENT_NAME" => $res["EVENT_NAME"])); if ($db_res_ && ($res_ = $db_res_->Fetch())) { do { $arr[$res_["ID"]] = $res_; $arr_lid[] = $res_["LID"]; $arr_lids[$res_["LID"]] = $res_; } while ($res_ = $db_res_->Fetch()); } $res["ID"] = array_keys($arr); $res["LID"] = $arr_lid; $res["NAME"] = empty($arr_lids[$this->LID]["NAME"]) ? $arr_lids["en"]["NAME"] : $arr_lids[$this->LID]["NAME"]; $res["SORT"] = empty($arr_lids[$this->LID]["SORT"]) ? $arr_lids["en"]["SORT"] : $arr_lids[$this->LID]["SORT"]; $res["DESCRIPTION"] = empty($arr_lids[$this->LID]["DESCRIPTION"]) ? $arr_lids["en"]["DESCRIPTION"] : $arr_lids[$this->LID]["DESCRIPTION"]; $res["TYPE"] = $arr; if ($this->type != "type") { $arr = array(); $db_res_ = CEventMessage::GetList($sort = "sort", $by = "asc", array("EVENT_NAME" => $res["EVENT_NAME"])); if ($db_res_ && ($res_ = $db_res_->Fetch())) { do { $arr[$res_["ID"]] = $res_; } while ($res_ = $db_res_->Fetch()); } $res["TEMPLATES"] = $arr; } } } return $res; }
} use Bitrix\Highloadblock as HL; use Bitrix\Main\Entity; global $USER_FIELD_MANAGER; // hlblock info $hlblock_id = $arParams['BLOCK_ID']; if (empty($hlblock_id)) { ShowError(GetMessage('HLBLOCK_VIEW_NO_ID')); return 0; } $hlblock = HL\HighloadBlockTable::getById($hlblock_id)->fetch(); if (empty($hlblock)) { ShowError('404'); return 0; } $entity = HL\HighloadBlockTable::compileEntity($hlblock); // row data $main_query = new Entity\Query($entity); $main_query->setSelect(array('*')); $main_query->setFilter(array('=ID' => $arParams['ROW_ID'])); $result = $main_query->exec(); $result = new CDBResult($result); $row = $result->Fetch(); $fields = $USER_FIELD_MANAGER->getUserFieldsWithReadyData('HLBLOCK_' . $hlblock['ID'], $row, LANGUAGE_ID); if (empty($row)) { ShowError(sprintf(GetMessage('HLBLOCK_VIEW_NO_ROW'), $arParams['ROW_ID'])); return 0; } $arResult['fields'] = $fields; $arResult['row'] = $row; $this->IncludeComponentTemplate();
/** * @return array */ public static function Fetch() { $res = parent::Fetch(); if (!empty($res)) { if (array_key_exists('MEASURE_TITLE', $res) && $res["MEASURE_TITLE"] == '') { $tmpTitle = CCatalogMeasureClassifier::getMeasureTitle($res["CODE"], 'MEASURE_TITLE'); $res["MEASURE_TITLE"] = $tmpTitle == '' ? $res["SYMBOL_INTL"] : $tmpTitle; } if (array_key_exists('SYMBOL_RUS', $res) && $res["SYMBOL_RUS"] == '') { $tmpSymbol = CCatalogMeasureClassifier::getMeasureTitle($res["CODE"], 'SYMBOL_RUS'); $res["SYMBOL_RUS"] = $tmpSymbol == '' ? $res["SYMBOL_INTL"] : $tmpSymbol; } } return $res; }
public static function Fetch() { if ($res = parent::Fetch()) { $res["ADMIN_PASSWORD"] = CLdapUtil::Decrypt($res["ADMIN_PASSWORD"]); $res["FIELD_MAP"] = unserialize($res["FIELD_MAP"]); if (!is_array($res["FIELD_MAP"])) { $res["FIELD_MAP"] = array(); } } return $res; }
function Fetch() { /** @global CCacheManager $CACHE_MANAGER */ global $CACHE_MANAGER; /** @global CDatabase $DB */ global $DB; $res = parent::Fetch(); if (!is_object($this)) { return $res; } $arUpdate = array(); if ($res) { if (is_array($this->arIBlockLongProps)) { foreach ($res as $k => $v) { if (preg_match("#^ALIAS_(\\d+)_(.*)\$#", $k, $match)) { $res[$this->arIBlockLongProps[$match[1]] . $match[2]] = $v; unset($res[$k]); } } } if (isset($res["IBLOCK_ID"]) && defined("BX_COMP_MANAGED_CACHE") && $res["IBLOCK_ID"] != $this->_LAST_IBLOCK_ID) { CIBlock::registerWithTagCache($res["IBLOCK_ID"]); $this->_LAST_IBLOCK_ID = $res["IBLOCK_ID"]; } if (isset($res["ID"]) && $res["ID"] != "" && is_array($this->arIBlockMultProps)) { foreach ($this->arIBlockMultProps as $field_name => $db_prop) { if (array_key_exists($field_name, $res)) { if (is_object($res[$field_name])) { $res[$field_name] = $res[$field_name]->load(); } if (preg_match("/(_VALUE)\$/", $field_name)) { $descr_name = preg_replace("/(_VALUE)\$/", "_DESCRIPTION", $field_name); } else { $descr_name = preg_replace("/^(PROPERTY_)/", "DESCRIPTION_", $field_name); } if (strlen($res[$field_name]) <= 0) { $strSql = "\n\t\t\t\t\t\t\t\tSELECT VALUE,DESCRIPTION\n\t\t\t\t\t\t\t\tFROM b_iblock_element_prop_m" . $db_prop["IBLOCK_ID"] . "\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tIBLOCK_ELEMENT_ID = " . intval($res["ID"]) . "\n\t\t\t\t\t\t\t\t\tAND IBLOCK_PROPERTY_ID = " . intval($db_prop["ORIG_ID"]) . "\n\t\t\t\t\t\t\t\tORDER BY ID\n\t\t\t\t\t\t\t"; $rs = $DB->Query($strSql); $res[$field_name] = array(); $res[$descr_name] = array(); while ($ar = $rs->Fetch()) { $res[$field_name][] = $ar["VALUE"]; $res[$descr_name][] = $ar["DESCRIPTION"]; } $arUpdate["b_iblock_element_prop_s" . $db_prop["IBLOCK_ID"]]["PROPERTY_" . $db_prop["ORIG_ID"]] = serialize(array("VALUE" => $res[$field_name], "DESCRIPTION" => $res[$descr_name])); } else { $tmp = unserialize($res[$field_name]); $res[$field_name] = $tmp["VALUE"]; $res[$descr_name] = $tmp["DESCRIPTION"]; } if (is_array($res[$field_name]) && $db_prop["PROPERTY_TYPE"] == "L") { $arTemp = array(); foreach ($res[$field_name] as $key => $val) { $arEnum = CIBlockPropertyEnum::GetByID($val); if ($arEnum !== false) { $arTemp[$val] = $arEnum["VALUE"]; } } $res[$field_name] = $arTemp; } } } foreach ($arUpdate as $strTable => $arFields) { $strUpdate = $DB->PrepareUpdate($strTable, $arFields); if ($strUpdate != "") { $strSql = "UPDATE " . $strTable . " SET " . $strUpdate . " WHERE IBLOCK_ELEMENT_ID = " . intval($res["ID"]); $DB->QueryBind($strSql, $arFields); } } } if (is_array($this->arIBlockConvProps)) { foreach ($this->arIBlockConvProps as $strFieldName => $arCallback) { if (is_array($res[$strFieldName])) { foreach ($res[$strFieldName] as $key => $value) { $arValue = call_user_func_array($arCallback["ConvertFromDB"], array($arCallback["PROPERTY"], array("VALUE" => $value, "DESCRIPTION" => ""))); $res[$strFieldName][$key] = $arValue["VALUE"]; } } else { $arValue = call_user_func_array($arCallback["ConvertFromDB"], array($arCallback["PROPERTY"], array("VALUE" => $res[$strFieldName], "DESCRIPTION" => ""))); $res[$strFieldName] = $arValue["VALUE"]; } } } if (is_array($this->arIBlockNumProps)) { foreach ($this->arIBlockNumProps as $field_name => $db_prop) { if (strlen($res[$field_name]) > 0) { $res[$field_name] = htmlspecialcharsex(CIBlock::NumberFormat($res[$field_name])); } } } if (isset($res["UC_ID"])) { $res["CREATED_BY_FORMATTED"] = CUser::FormatName($this->nameTemplate, array("NAME" => $res["UC_NAME"], "LAST_NAME" => $res["UC_LAST_NAME"], "SECOND_NAME" => $res["UC_SECOND_NAME"], "EMAIL" => $res["UC_EMAIL"], "ID" => $res["UC_ID"], "LOGIN" => $res["UC_LOGIN"]), true, false); unset($res["UC_NAME"]); unset($res["UC_LAST_NAME"]); unset($res["UC_SECOND_NAME"]); unset($res["UC_EMAIL"]); unset($res["UC_ID"]); unset($res["UC_LOGIN"]); } } elseif (defined("BX_COMP_MANAGED_CACHE") && $this->_LAST_IBLOCK_ID == "" && count($this->_FILTER_IBLOCK_ID)) { foreach ($this->_FILTER_IBLOCK_ID as $iblock_id => $t) { CIBlock::registerWithTagCache($iblock_id); } } return $res; }
function Fetch() { static $index = false; $r = parent::Fetch(); if ($r) { if (strlen($r["SITE_URL"]) > 0) { $r["URL"] = $r["SITE_URL"]; } if (substr($r["URL"], 0, 1) == "=") { foreach ($this->m_events as $arEvent) { $r["URL"] = ExecuteModuleEventEx($arEvent, array($r)); } } $r["URL"] = str_replace(array("#LANG#", "#SITE_DIR#", "#SERVER_NAME#"), array($r["DIR"], $r["DIR"], $r["SERVER_NAME"]), $r["URL"]); $r["URL"] = preg_replace("'(?<!:)/+'s", "/", $r["URL"]); if (defined("BX_DISABLE_INDEX_PAGE") && BX_DISABLE_INDEX_PAGE) { if (!$index) { $index = "#/(" . str_replace(" ", "|", preg_quote(implode(" ", GetDirIndexArray()), "#")) . ")\$#"; } $r["URL"] = preg_replace($index, "/", $r["URL"]); } //Remove anchor otherwise Google will ignore this link $p = strpos($r["URL"], "#"); if ($p !== false) { $r["URL"] = substr($r["URL"], 0, $p); } } return $r; }
public static function Fetch() { if ($res = parent::Fetch()) { if ($res["LAMP"] == "yellow" && !empty($res["CHANNEL_ID"])) { $res["LAMP"] = $res["ID"] == CVote::GetActiveVoteId($res["CHANNEL_ID"]) ? "green" : "red"; } } return $res; }
function Fetch() { if($arr_log = parent::Fetch()) return CMailLog::ConvertRow($arr_log); return false; }
public function GetNotifyList($arParams) { global $DB; $iNumPage = 1; if (isset($arParams['PAGE']) && intval($arParams['PAGE']) >= 0) $iNumPage = intval($arParams['PAGE']); $bTimeZone = isset($arParams['USE_TIME_ZONE']) && $arParams['USE_TIME_ZONE'] == 'N'? false: true; $sqlStr = " SELECT COUNT(M.ID) as CNT, M.CHAT_ID FROM b_im_relation R INNER JOIN b_im_message M ON M.CHAT_ID = R.CHAT_ID WHERE R.USER_ID = ".$this->user_id." AND R.MESSAGE_TYPE = '".IM_MESSAGE_SYSTEM."' GROUP BY M.CHAT_ID "; $res_cnt = $DB->Query($sqlStr); $res_cnt = $res_cnt->Fetch(); $cnt = $res_cnt["CNT"]; $chatId = $res_cnt["CHAT_ID"]; $arNotify = Array(); if ($cnt > 0) { if (!$bTimeZone) CTimeZone::Disable(); $strSql =" SELECT M.ID, M.CHAT_ID, M.MESSAGE, M.MESSAGE_OUT, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, M.NOTIFY_TYPE, M.NOTIFY_MODULE, M.NOTIFY_EVENT, M.NOTIFY_TITLE, M.NOTIFY_BUTTONS, M.NOTIFY_TAG, M.NOTIFY_SUB_TAG, M.NOTIFY_READ, $this->user_id TO_USER_ID, M.AUTHOR_ID FROM_USER_ID FROM b_im_message M WHERE M.CHAT_ID = ".$chatId." #LIMIT# ORDER BY M.DATE_CREATE DESC, ID DESC "; if (!$bTimeZone) CTimeZone::Enable(); if ($iNumPage == 0) { $dbType = strtolower($DB->type); if ($dbType== "mysql") $sqlLimit = " AND M.DATE_CREATE > DATE_SUB(NOW(), INTERVAL 30 DAY)"; else if ($dbType == "mssql") $sqlLimit = " AND M.DATE_CREATE > dateadd(day, -30, getdate())"; else if ($dbType == "oracle") $sqlLimit = " AND M.DATE_CREATE > SYSDATE-30"; $strSql = $DB->TopSql($strSql, 20); $dbRes = $DB->Query(str_replace("#LIMIT#", $sqlLimit, $strSql), false, "File: ".__FILE__."<br>Line: ".__LINE__); } else { $dbRes = new CDBResult(); $dbRes->NavQuery(str_replace("#LIMIT#", "", $strSql), $cnt, Array('iNumPage' => $iNumPage, 'nPageSize' => 20)); } $arGetUsers = Array(); while ($arRes = $dbRes->Fetch()) { if ($this->bHideLink) $arRes['HIDE_LINK'] = 'Y'; $arNotify[$arRes['ID']] = $arRes; $arGetUsers[] = $arRes['FROM_USER_ID']; } if (empty($arNotify)) return $arNotify; $arUsers = CIMContactList::GetUserData(Array('ID' => $arGetUsers, 'DEPARTMENT' => 'N', 'USE_CACHE' => 'Y', 'CACHE_TTL' => 86400)); $arGetUsers = $arUsers['users']; foreach ($arNotify as $key => $value) { $value['FROM_USER_DATA'] = $arGetUsers; $arNotify[$key] = self::GetFormatNotify($value); } } return $arNotify; }
/** * Функция Fetch. * * <p>Десериализует поле SETTINGS.</p> * @return array возвращает false в случае последней записи выборки. */ function Fetch() { $res = parent::Fetch(); if($res && strlen($res["SETTINGS"])>0) { $res["SETTINGS"] = unserialize($res["SETTINGS"]); } return $res; }
function Fetch() { global $DB; if ($res = parent::Fetch()) { $res["~TIMESTAMP_X"] = $res["TIMESTAMP_X"]; $res["TIMESTAMP_X"] = ConvertTimeStamp($res["~TIMESTAMP_X"], "FULL"); } return $res; }
function Fetch() { if ($result = parent::Fetch()) { if (array_key_exists('SETTINGS', $result)) { $result['SETTINGS'] = is_string($result['SETTINGS']) ? unserialize($result['SETTINGS']) : array(); } if ($this->selectCommunications) { $result['COMMUNICATIONS'] = CCrmActivity::GetCommunications($result['ID']); } } return $result; }