Beispiel #1
0
 public function GetNext()
 {
     if ($arRes = $this->Fetch()) {
         return TildaArray($arRes);
     }
     return $arRes;
 }
Beispiel #2
0
 public static function GetParameterHTML($sName, $arParameter, $existingValue, $bShowInTable = true)
 {
     $html = '';
     $arParameter = TildaArray($arParameter);
     if ($bShowInTable) {
         $html .= '<tr><td>';
     }
     $parameterValue = empty($existingValue) ? $arParameter['DEFAULT'] : $existingValue;
     switch ($sName) {
         case 'AJAX_MODE':
             break;
         case 'CACHE_TIME':
             break;
         default:
             $html .= $arParameter['NAME'] . '</td><td>';
             switch ($arParameter['TYPE']) {
                 case 'CHECKBOX':
                     $html .= '<input type="checkbox" name="' . $sName . '" value="' . $parameterValue . '"';
                     if ($parameterValue == "Y") {
                         $html .= ' checked=checked';
                     }
                     if ($arParameter['REFRESH'] == 'Y') {
                         $html .= ' onChange="RefreshParamsDialog({\'key\': \'' . $sName . '\', \'value\': this.checked == true ? \'Y\' : \'N\'})"';
                     }
                     $html .= '/>';
                     break;
                 case 'LIST':
                     if (is_array($arParameter['VALUES'])) {
                         $html .= '<select name="' . $sName . '"';
                         if ($arParameter['MULTIPLE'] == 'Y') {
                             $html .= ' multiple="multiple" size="5"';
                         }
                         if ($arParameter['REFRESH'] == 'Y') {
                             $html .= ' onChange="RefreshParamsDialog({\'key\': \'' . $sName . '\', \'value\': this.value})"';
                         }
                         $html .= '>';
                         foreach ($arParameter['VALUES'] as $key => $value) {
                             $html .= '<option value="' . $key . '"';
                             if ($parameterValue == $key) {
                                 $html .= ' selected=selected';
                             }
                             $html .= '>' . $value . '</option>';
                         }
                         $html .= '</select>';
                     }
                     break;
                 case 'STRING':
                 default:
                     $html .= '<input type="text" name="' . $sName . '" value="' . $parameterValue . '"/>';
                     break;
             }
             if ($bShowInTable) {
                 $html .= '</td></tr>';
             }
             break;
     }
     return $html;
 }
 public function GetProperties($arOrder = false, $arFilter = array())
 {
     global $DB;
     if (!$arOrder) {
         $order = "ORDER BY PROPS.ID ASC";
     } else {
         $cnt = 0;
         foreach ($arOrder as $f => $t) {
             $cnt++;
             $order = " ORDER BY PROPS." . $f . " " . $t;
             if ($cnt != count($arOrder)) {
                 $order .= ",";
             }
         }
     }
     if (!empty($arFilter)) {
         if (!empty($arFilter["CODE"])) {
             $where = "AND PROPS.CODE = '" . $arFilter["CODE"] . "' ";
         }
     } else {
         $where = "";
     }
     $sql = "SELECT * FROM " . "`" . $this->table_props . "` AS PROPS, " . "`" . $this->table_props_values . "` AS PROP_VALUES " . "WHERE " . "PROP_VALUES.CATALOG_PROPERTY_ID = PROPS.ID AND " . "PROP_VALUES.CATALOG_ELEMENT_ID = '" . intVal($this->elementID) . "' " . $where . $order . ";";
     $DB->Query($sql);
     while ($ar_res = $DB->fetchAssoc()) {
         $arPreResult[$ar_res["CODE"]] = TildaArray($ar_res);
     }
     if (count($arPreResult) == 1) {
         $arResult = current($arPreResult);
     } else {
         $arResult = $arPreResult;
     }
     return $arResult;
 }
 function GetSectionInfo()
 {
     global $DB;
     $sql = "SELECT * FROM `" . $this->table_catalog_section . "` WHERE `ID` = " . intVal($this->fields['CATALOG_SECTION_ID']) . ";";
     $DB->Query($sql);
     if ($ar_res = $DB->fetchAssoc()) {
         $this->fields["SECTION"] = TildaArray($ar_res);
     }
     //d($this->fields);
 }