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;
}
}
}
}
