Esempio n. 1
0
$arSelect = array("ID", "IBLOCK_ID", "*");
$property_enums = CIBlockPropertyEnum::GetList(array("SORT" => "ASC"), array("IBLOCK_ID" => 2, "XML_ID" => "FOR_USERS"));
while ($enum_fields = $property_enums->GetNext()) {
    $enums_id[] = $enum_fields["ID"];
}
if (empty($_GET["filter"])) {
    if (date("U", strtotime($start_date)) < date("U", strtotime(date("j.n.Y", time())))) {
        $start_date = date("j.n.Y", strtotime(date("j.n.Y", time()) . " Monday"));
    }
    $arFilter = array("IBLOCK_ID" => 2, array("LOGIC" => "OR", array("IBLOCK_ID" => 2, "PROPERTY_ANC_ID" => $myID)), array("LOGIC" => "AND", array(">=PROPERTY_START_DATE" => trim(CDatabase::CharToDateFunction(ConvertTimeStamp(strtotime($start_date), 'FULL')), "\\'")), array("<=PROPERTY_START_DATE" => trim(CDatabase::CharToDateFunction(ConvertTimeStamp(strtotime($end_date), 'FULL')), "\\'"))));
} elseif (substr($_GET["filter"], 0, 4) == "next") {
    $arFilter = array("IBLOCK_ID" => 2, ">=PROPERTY_START_DATE" => trim(CDatabase::CharToDateFunction(ConvertTimeStamp(strtotime($start_date), 'FULL')), "\\'"), "<=PROPERTY_START_DATE" => trim(CDatabase::CharToDateFunction(ConvertTimeStamp(strtotime($end_date), 'FULL')), "\\'"));
} elseif (substr($_GET["filter"], 0, 4) == "prev") {
    $arFilter = array("IBLOCK_ID" => 2, "<=PROPERTY_START_DATE" => trim(CDatabase::CharToDateFunction(ConvertTimeStamp(strtotime($end_date), 'FULL')), "\\'"));
    if (!empty($_GET["s"])) {
        $arFilter[">=PROPERTY_START_DATE"] = trim(CDatabase::CharToDateFunction(ConvertTimeStamp(strtotime($start_date), 'FULL')), "\\'");
    }
}
if (!empty($_GET["place"]) && empty($_GET["s"])) {
    $arFilter = array();
    $arFilter["IBLOCK_ID"] = 2;
    $arFilter["PROPERTY_CITY"] = $_GET["place"];
    if (empty($_GET["filter"])) {
        $arFilter["PROPERTY_ANC_ID"] = $myID;
    }
}
if ($_GET["q"]) {
    $arFilter["%NAME"] = $_GET["q"];
}
$res = CIBlockElement::GetList(array("PROPERTY_START_DATE" => "DESC"), $arFilter, false, false, $arSelect);
$numPeriod = 0;
Esempio n. 2
0
 public function PrepareUpdateBind($strTableName, $arFields, $strFileDir, $lang, &$arBinds, $strTableAlias = "")
 {
     $arBinds = array();
     if ($strTableAlias != "") {
         $strTableAlias .= ".";
     }
     $strUpdate = "";
     $arColumns = $this->GetTableFields($strTableName);
     foreach ($arColumns as $strColumnName => $arColumnInfo) {
         $type = $arColumnInfo["TYPE"];
         if (isset($arFields[$strColumnName])) {
             $value = $arFields[$strColumnName];
             if ($value === false) {
                 $strUpdate .= ", {$strTableAlias}`" . $strColumnName . "` = NULL";
             } else {
                 switch ($type) {
                     case "int":
                         $value = intval($value);
                         break;
                     case "real":
                         $value = doubleval($value);
                         break;
                     case "datetime":
                     case "timestamp":
                         if (strlen($value) <= 0) {
                             $value = "NULL";
                         } else {
                             $value = CDatabase::CharToDateFunction($value, "FULL", $lang);
                         }
                         break;
                     case "date":
                         if (strlen($value) <= 0) {
                             $value = "NULL";
                         } else {
                             $value = CDatabase::CharToDateFunction($value, "SHORT", $lang);
                         }
                         break;
                     default:
                         $value = "'" . $this->ForSql($value) . "'";
                 }
                 $strUpdate .= ", {$strTableAlias}`" . $strColumnName . "` = " . $value;
             }
         } elseif (is_set($arFields, "~" . $strColumnName)) {
             $strUpdate .= ", {$strTableAlias}`" . $strColumnName . "` = " . $arFields["~" . $strColumnName];
         }
     }
     if ($strUpdate != "") {
         $strUpdate = substr($strUpdate, 2);
     }
     return $strUpdate;
 }
Esempio n. 3
0
CModule::IncludeModule("iblock");
$group_id = isset($arGroup["id"]) ? $arGroup["id"] : $_GET["GROUP_ID"];
$iblock_id = 2;
$arPosts = array();
// Постраничная пагинация / Сессия прописывается в init.php
if (($nPageSize = $_GET["page"]) && !$_GET["PAGEN_1"]) {
    $nPageSizePhoto = $nPageSize * 9;
} else {
    $nPageSizePhoto = 9;
}
$arFilter = array("IBLOCK_ID" => $iblock_id, "ACTIVE_DATE" => "Y", "PROPERTY_SOCIAL_GROUP_ID" => $group_id, "PROPERTY_ANC_TYPE" => 26, "PROPERTY_CREATED_USER_ID" => false);
if ($_GET["filter"] == "next" || empty($_GET["filter"])) {
    $arFilter[">=PROPERTY_START_DATE"] = trim(CDatabase::CharToDateFunction(ConvertTimeStamp(time(), 'FULL')), "\\'");
}
if ($_GET["filter"] == "prev") {
    $arFilter["<PROPERTY_END_DATE"] = trim(CDatabase::CharToDateFunction(ConvertTimeStamp(time(), 'FULL')), "\\'");
}
if ($_GET["filter"] == "my") {
    $arFilter["PROPERTY_ANC_ID"] = $USER->GetID();
}
if ($_GET["q"]) {
    $arFilter["%NAME"] = $_GET["q"];
}
$res = CIBlockElement::GetList(array("ACTIVE_FROM" => "DESC"), $arFilter, false, array("nPageSize" => $nPageSizePhoto));
while ($arItemObj = $res->GetNextElement()) {
    $arItem = $arItemObj->GetFields();
    $arItem["PROPERTIES"] = $arItemObj->GetProperties();
    $arPosts[$arItem["ID"]] = $arItem;
    /*if($USER->GetID() == 2) {
    		echo '<pre>'; print_r($arItem["PROPERTIES"]["START_DATE"]["VALUE"].' '.trim(CDatabase::CharToDateFunction(ConvertTimeStamp(time(),'FULL')),"\'")); echo '<pre>';
    		}*/