public function delete($table, $where) { UniteFunctionsBanner::validateNotEmpty($table, "table name"); UniteFunctionsBanner::validateNotEmpty($where, "where"); $query = "delete from {$table} where {$where}"; $this->wpdb->query($query); $this->checkForErrors("Delete query error"); }
public function updateSlidesOrderFromData($data) { $sliderID = UniteFunctionsBanner::getVal($data, "sliderID"); $arrIDs = UniteFunctionsBanner::getVal($data, "arrIDs"); UniteFunctionsBanner::validateNotEmpty($arrIDs, "slides"); $this->initByID($sliderID); foreach ($arrIDs as $index => $slideID) { $order = $index + 1; $arrUpdate = array("slide_order" => $order); $where = array("id" => $slideID); $this->db->update(GlobalsBannerRotator::$table_slides, $arrUpdate, $where); } }
public function updateSlideImageFromData($data) { $slideID = UniteFunctionsBanner::getVal($data, "slide_id"); $this->initByID($slideID); $urlImage = UniteFunctionsBanner::getVal($data, "url_image"); UniteFunctionsBanner::validateNotEmpty($urlImage); $imageID = UniteFunctionsBanner::getVal($data, "image_id"); $arrUpdate = array(); $arrUpdate["image"] = $urlImage; $arrUpdate["image_id"] = $imageID; $this->updateParamsInDB($arrUpdate); return $urlImage; }
public function loadXMLFile($filepath) { if (!file_exists($filepath)) { UniteFunctionsBanner::throwError("File: '{$filepath}' not exists!!!"); } $obj = simplexml_load_file($filepath); if (empty($obj)) { UniteFunctionsBanner::throwError("Wrong xml file format: {$filepath}"); } $fieldsets = $obj->fieldset; if (!@count($obj->fieldset)) { $fieldsets = array($fieldsets); } $this->addSection("Xml Settings"); foreach ($fieldsets as $fieldset) { //Add Section $attribs = $fieldset->attributes(); $sapName = (string) UniteFunctionsBanner::getVal($attribs, "name"); $sapLabel = (string) UniteFunctionsBanner::getVal($attribs, "label"); UniteFunctionsBanner::validateNotEmpty($sapName, "sapName"); UniteFunctionsBanner::validateNotEmpty($sapLabel, "sapLabel"); $this->addSap($sapLabel, $sapName); //Add fields $fieldset = (array) $fieldset; $fields = $fieldset["field"]; if (is_array($fields) == false) { $fields = array($fields); } foreach ($fields as $field) { $attribs = $field->attributes(); $fieldType = (string) UniteFunctionsBanner::getVal($attribs, "type"); $fieldName = (string) UniteFunctionsBanner::getVal($attribs, "name"); $fieldLabel = (string) UniteFunctionsBanner::getVal($attribs, "label"); $fieldDefaultValue = (string) UniteFunctionsBanner::getVal($attribs, "default"); //All other params will be added to "params array" $arrMustParams = array("type", "name", "label", "default"); $arrParams = array(); foreach ($attribs as $key => $value) { $key = (string) $key; $value = (string) $value; //Skip must params if (in_array($key, $arrMustParams)) { continue; } $arrParams[$key] = $value; } $options = $this->getOptionsFromXMLField($field, $fieldName); //Validate must fields UniteFunctionsBanner::validateNotEmpty($fieldType, "type"); //Validate name if ($fieldType != self::TYPE_HR && $fieldType != self::TYPE_CONTROL && $fieldType != "bulk_control_start" && $fieldType != "bulk_control_end") { UniteFunctionsBanner::validateNotEmpty($fieldName, "name"); } switch ($fieldType) { case self::TYPE_CHECKBOX: $fieldDefaultValue = UniteFunctionsBanner::strToBool($fieldDefaultValue); $this->addCheckbox($fieldName, $fieldDefaultValue, $fieldLabel, $arrParams); break; case self::TYPE_COLOR: $this->addColorPicker($fieldName, $fieldDefaultValue, $fieldLabel, $arrParams); break; case self::TYPE_HR: $this->addHr(); break; case self::TYPE_TEXT: $this->addTextBox($fieldName, $fieldDefaultValue, $fieldLabel, $arrParams); break; case self::TYPE_STATIC_TEXT: $this->addStaticText($fieldLabel, $fieldName, $arrParams); break; case self::TYPE_IMAGE: $this->addImage($fieldName, $fieldDefaultValue, $fieldLabel, $arrParams); break; case self::TYPE_SELECT: $this->addSelect($fieldName, $options, $fieldLabel, $fieldDefaultValue, $arrParams); break; case self::TYPE_CHECKBOX: $this->addChecklist($fieldName, $options, $fieldLabel, $fieldDefaultValue, $arrParams); break; case self::TYPE_RADIO: $this->addRadio($fieldName, $options, $fieldLabel, $fieldDefaultValue, $arrParams); break; case self::TYPE_TEXTAREA: $this->addTextArea($fieldName, $fieldDefaultValue, $fieldLabel, $arrParams); break; case self::TYPE_CUSTOM: $this->add($fieldName, $fieldDefaultValue, $fieldLabel, self::TYPE_CUSTOM, $arrParams); break; case self::TYPE_CONTROL: $parent = UniteFunctionsBanner::getVal($arrParams, "parent"); $child = UniteFunctionsBanner::getVal($arrParams, "child"); $ctype = UniteFunctionsBanner::getVal($arrParams, "ctype"); $value = UniteFunctionsBanner::getVal($arrParams, "value"); $this->addControl($parent, $child, $ctype, $value); break; case "bulk_control_start": $parent = UniteFunctionsBanner::getVal($arrParams, "parent"); $ctype = UniteFunctionsBanner::getVal($arrParams, "ctype"); $value = UniteFunctionsBanner::getVal($arrParams, "value"); $this->startBulkControl($parent, $ctype, $value); break; case "bulk_control_end": $this->endBulkControl(); break; default: UniteFunctionsBanner::throwError("wrong type: {$fieldType}"); break; } } } }