/**
*
* delete rows
*/
public function delete($table, $where)
{
UniteFunctionsRev::validateNotEmpty($table, "table name");
UniteFunctionsRev::validateNotEmpty($where, "where");
$query = "delete from {$table} where {$where}";
$this->wpdb->query($query);
$this->checkForErrors("Delete query error");
}
/**
*
* delete rows
*/
public function delete($table, $where)
{
UniteFunctionsRev::validateNotEmpty($table, "table name");
UniteFunctionsRev::validateNotEmpty($where, "where");
list($field, $value) = explode('=', $where);
$collection = Mage::getModel('nwdrevslider/' . $table)->getCollection();
$collection->addFieldToFilter($field, trim($value, '"\''));
foreach ($collection as $_item) {
$_item->delete();
}
}
/**
*
* update slide image from data
*/
public function updateSlideImageFromData($data)
{
$sliderID = UniteFunctionsRev::getVal($data, "slider_id");
$slider = new RevSlider();
$slider->initByID($sliderID);
$slideID = UniteFunctionsRev::getVal($data, "slide_id");
$urlImage = UniteFunctionsRev::getVal($data, "url_image");
UniteFunctionsRev::validateNotEmpty($urlImage);
$imageID = UniteFunctionsRev::getVal($data, "image_id");
if ($slider->isSlidesFromPosts()) {
if (!empty($imageID)) {
UniteFunctionsWPRev::updatePostThumbnail($slideID, $imageID);
}
} else {
$this->initByID($slideID);
$arrUpdate = array();
$arrUpdate["image"] = $urlImage;
$arrUpdate["image_id"] = $imageID;
$this->updateParamsInDB($arrUpdate);
}
return $urlImage;
}
public function loadXMLFile($filepath)
{
if (!file_exists($filepath)) {
UniteFunctionsRev::throwError("File: '{$filepath}' not exists!!!");
}
$obj = simplexml_load_file($filepath);
if (empty($obj)) {
UniteFunctionsRev::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) UniteFunctionsRev::getVal($attribs, "name");
$sapLabel = (string) UniteFunctionsRev::getVal($attribs, "label");
if ($sapLabel != '' && isset(RevsliderPrestashop::$lang[$sapLabel])) {
$sapLabel = RevsliderPrestashop::$lang[$sapLabel];
}
$sapIcon = (string) UniteFunctionsRev::getVal($attribs, "icon");
UniteFunctionsRev::validateNotEmpty($sapName, "sapName");
UniteFunctionsRev::validateNotEmpty($sapLabel, "sapLabel");
$this->addSap($sapLabel, $sapName, false, $sapIcon);
//--- 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) UniteFunctionsRev::getVal($attribs, "type");
$fieldName = (string) UniteFunctionsRev::getVal($attribs, "name");
$fieldLabel = (string) UniteFunctionsRev::getVal($attribs, "label");
if ($fieldLabel != '' && isset(RevsliderPrestashop::$lang[$fieldLabel])) {
$fieldLabel = RevsliderPrestashop::$lang[$fieldLabel];
}
$fieldDefaultValue = (string) UniteFunctionsRev::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:
UniteFunctionsRev::validateNotEmpty($fieldType, "type");
//validate name
if ($fieldType != self::TYPE_HR && $fieldType != self::TYPE_CONTROL && $fieldType != "bulk_control_start" && $fieldType != "bulk_control_end") {
UniteFunctionsRev::validateNotEmpty($fieldName, "name");
}
switch ($fieldType) {
case self::TYPE_CHECKBOX:
$fieldDefaultValue = UniteFunctionsRev::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_MULTIPLE_TEXT:
$this->addMultipleTextBox($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_BUTTON:
$this->addButton($fieldName, $fieldDefaultValue, $arrParams);
break;
case self::TYPE_CONTROL:
$parent = UniteFunctionsRev::getVal($arrParams, "parent");
$child = UniteFunctionsRev::getVal($arrParams, "child");
$ctype = UniteFunctionsRev::getVal($arrParams, "ctype");
$value = UniteFunctionsRev::getVal($arrParams, "value");
$this->addControl($parent, $child, $ctype, $value);
break;
case "bulk_control_start":
$parent = UniteFunctionsRev::getVal($arrParams, "parent");
$ctype = UniteFunctionsRev::getVal($arrParams, "ctype");
$value = UniteFunctionsRev::getVal($arrParams, "value");
$this->startBulkControl($parent, $ctype, $value);
break;
case "bulk_control_end":
$this->endBulkControl();
break;
case "codemirror":
$this->addCodemirror($fieldName, $fieldDefaultValue, $fieldLabel, $arrParams);
break;
default:
UniteFunctionsRev::throwError("wrong type: {$fieldType}");
break;
}
}
}
}
/**
*
* replace image urls
*/
public function replaceImageUrlsFromData($data)
{
$sliderID = UniteFunctionsRev::getVal($data, "sliderid");
$urlFrom = UniteFunctionsRev::getVal($data, "url_from");
UniteFunctionsRev::validateNotEmpty($urlFrom, "url from");
$urlTo = UniteFunctionsRev::getVal($data, "url_to");
$this->initByID($sliderID);
$arrSildes = $this->getSlides();
foreach ($arrSildes as $slide) {
//$slide1 = new RevSlide();
$slide->replaceImageUrls($urlFrom, $urlTo);
}
}
/**
*
* update slide image from data
*/
public function updateSlideImageFromData($data)
{
$slideID = UniteFunctionsRev::getVal($data, "slide_id");
$this->initByID($slideID);
$urlImage = UniteFunctionsRev::getVal($data, "url_image");
UniteFunctionsRev::validateNotEmpty($urlImage);
$arrUpdate = array();
$arrUpdate["image"] = $urlImage;
$this->updateParamsInDB($arrUpdate);
return $urlImage;
}
/**
*
* duplicate slide in db
*/
public function duplicateSlide($slideID)
{
$slide = $this->getSlide($slideID);
$sliderID = $slide["sliderid"];
$order = $slide["ordering"];
$newOrder = $order + 1;
$this->shiftOrder($sliderID, $newOrder);
//do duplication
$sqlSelect = "select " . GlobalsUniteRev::FIELDS_SLIDE . " from " . GlobalsUniteRev::TABLE_SLIDES . " where id={$slideID}";
$sqlInsert = "insert into " . GlobalsUniteRev::TABLE_SLIDES . " (" . GlobalsUniteRev::FIELDS_SLIDE . ") ({$sqlSelect})";
$this->db->runSql($sqlInsert);
$lastID = $this->db->getLastInsertID();
UniteFunctionsRev::validateNotEmpty($lastID, "last insert id");
//update order
$arrUpdate = array("ordering" => $newOrder);
$this->db->update(GlobalsUniteRev::TABLE_SLIDES, $arrUpdate, "id={$lastID}");
return $lastID;
}
/**
*
* output slider body
*/
private function putBody()
{
$params = $this->params;
try {
$bannerWidth = $params->get("slider_width");
$bannerHeight = $params->get("slider_height");
UniteFunctionsRev::validateNotEmpty($bannerWidth, "banner width");
UniteFunctionsRev::validateNotEmpty($bannerHeight, "banner height");
$sliderType = $params->get("slider_type", "fixed");
//set wrapper height
$wrapperHeigh = $bannerHeight;
//add thumb height
if ($params->get("navigaion_type", "none") == "thumb") {
$wrapperHeigh += $params->get("thumb_height");
}
$this->sliderHtmlID = "rev_slider_" . $this->sliderID . "_" . self::$counter;
$this->sliderHtmlID_wrapper = $this->sliderHtmlID . "_wrapper";
$containerStyle = "";
//set position:
$sliderPosition = $params->get("position", "center");
switch ($sliderPosition) {
case "center":
default:
$containerStyle .= "margin:0px auto;";
break;
case "left":
$containerStyle .= "float:left;";
break;
case "right":
$containerStyle .= "float:right;";
break;
}
//add background color
$backgrondColor = trim($params->get("background_color"));
if (!empty($backgrondColor)) {
$containerStyle .= "background-color:{$backgrondColor};";
}
//set padding
$containerStyle .= "padding:" . $params->get("padding", "5") . "px;";
//set margin:
if ($sliderPosition != "center") {
$containerStyle .= "margin-left:" . $params->get("margin_left", "0") . "px;";
$containerStyle .= "margin-right:" . $params->get("margin_right", "0") . "px;";
}
$containerStyle .= "margin-top:" . $params->get("margin_top", "0") . "px;";
$containerStyle .= "margin-bottom:" . $params->get("margin_bottom", "0") . "px;";
//set height and width:
$bannerStyle = "display:none;";
//add background image (to banner style)
$showBackgroundImage = $params->get("show_background_image", "false");
if ($showBackgroundImage == "true") {
$backgroundImage = $params->get("background_image");
if (!empty($backgroundImage)) {
$bannerStyle .= "background-image:url({$backgroundImage});background-repeat:no-repeat;";
}
}
//set wrapper and slider class:
$sliderWrapperClass = "rev_slider_wrapper";
$sliderClass = "rev_slider";
switch ($sliderType) {
default:
case "fixed":
$bannerStyle .= "height:{$bannerHeight}px;width:{$bannerWidth}px;";
$containerStyle .= "height:{$bannerHeight}px;width:{$bannerWidth}px;";
break;
case "responsitive":
$this->putResponsitiveStyles();
break;
case "fullwidth":
$sliderWrapperClass .= " fullwidthbanner-container";
$sliderClass .= " fullwidthabanner";
$bannerStyle .= "max-height:{$bannerHeight}px;height:{$bannerHeight}px;";
$containerStyle .= "max-height:{$bannerHeight}px;";
break;
}
$htmlTimerBar = "";
if ($params->get("show_timerbar", "true") == "true") {
$timerPosition = $params->get("timebar_position", "top");
if ($timerPosition == "top") {
$htmlTimerBar = '<div class="tp-bannertimer"></div>';
} else {
$htmlTimerBar = '<div class="tp-bannertimer tp-bottom"></div>';
}
}
$containerStyle .= "direction:ltr;";
// put js in body
if ($this->putJSInBody == true) {
?>
<script type="text/javascript" src="<?php
echo $this->urlJsPlugins;
?>
"></script>
<script type="text/javascript" src="<?php
echo $this->urlJsRevolution;
?>
"></script>
<?php
}
?>
<!-- START REVOLUTION SLIDER ver. <?php
echo GlobalsUniteRev::$version;
?>
-->
<div id="<?php
echo $this->sliderHtmlID_wrapper;
?>
" class="<?php
echo $sliderWrapperClass;
?>
" style="<?php
echo $containerStyle;
?>
">
<div id="<?php
echo $this->sliderHtmlID;
?>
" class="<?php
echo $sliderClass;
?>
" style="<?php
echo $bannerStyle;
?>
">
<?php
$this->putSlides();
?>
<?php
echo $htmlTimerBar;
?>
</div>
</div>
<?php
$this->putJS();
?>
<!-- END REVOLUTION SLIDER -->
<?php
} catch (Exception $e) {
$message = $e->getMessage();
$this->putErrorMessage($message);
}
}
/**
*
* operate actions
*/
public function operate()
{
$this->operations = new HelperUniteOperationsRev();
$this->action = UniteFunctionsRev::getPostVariable("action");
if (empty($this->action)) {
$this->action = UniteFunctionsRev::getPostVariable("client_action");
}
$this->data = UniteFunctionsRev::getPostVariable("data", array());
try {
switch ($this->action) {
case "add_slide":
$slideID = $this->operations->addSlideFromData($this->data);
UniteFunctionsRev::ajaxResponseSuccess("");
break;
case "update_slider_duplicate":
$sliderID = $this->saveSlider();
$newSliderID = $this->operations->duplicateSlider($sliderID);
UniteFunctionsRev::ajaxResponseData(array("newSliderID" => $newSliderID));
break;
case "update_slider":
$sliderID = $this->saveSlider();
UniteFunctionsRev::ajaxResponseData(array("sliderID" => $sliderID));
break;
case "update_slide_close":
case "update_slide_new":
case "update_slide":
$slideID = $this->saveSlide();
UniteFunctionsRev::ajaxResponseData(array("slideID" => $slideID));
break;
case "update_slide_duplicate":
$slideID = $this->saveSlide();
$newSlideID = $this->operations->duplicateSlide($slideID);
UniteFunctionsRev::ajaxResponseData(array("slideID" => $newSlideID));
break;
case "get_captions_css":
$contentCSS = $this->operations->getCaptionsContent();
UniteFunctionsRev::ajaxResponseData($contentCSS);
break;
case "update_captions_css":
$arrCaptions = $this->operations->updateCaptionsContentData($this->data);
UniteFunctionsRev::ajaxResponseSuccess("CSS file saved succesfully!", array("arrCaptions" => $arrCaptions));
break;
case "restore_captions_css":
$this->operations->restoreCaptionsCss();
$contentCSS = $this->operations->getCaptionsContentOgirinal();
UniteFunctionsRev::ajaxResponseData($contentCSS);
break;
case "get_release_log":
$content = HelperUniteRev::getReleaseLogContent();
UniteFunctionsRev::ajaxResponseData($content);
break;
case "preview_slide":
$this->operations->putSlidePreviewByData($this->data);
break;
case "preview_slider":
$sliderID = UniteFunctionsRev::getPostVariable("sliderid");
UniteFunctionsRev::validateNotEmpty($sliderID, "SliderID");
$this->operations->previewOutput($sliderID);
break;
case "update_items_order":
$this->operations->updateSlidesOrderFromData($this->data);
UniteFunctionsRev::ajaxResponseSuccess("order updated");
break;
case "toggle_publish_state":
//publish / unpublish item
$newState = $this->operations->publishUnpublishItemFromData($this->data);
UniteFunctionsRev::ajaxResponseSuccess("state updated", array("newstate" => $newState));
break;
case "delete_slide":
$this->operations->deleteSlideFromData($this->data);
UniteFunctionsRev::ajaxResponseSuccess("Slide Deleted");
break;
case "duplicate_slide":
$this->operations->duplicateSlideFromData($this->data);
UniteFunctionsRev::ajaxResponseSuccess("Slide Duplicated");
break;
default:
UniteFunctionsRev::ajaxResponseError("ajax action not found: " . $this->action);
break;
}
} catch (Exception $e) {
$message = $e->getMessage();
UniteFunctionsRev::ajaxResponseError($message);
}
exit;
}
/**
*
* update slides order from data
*/
public function updateSlidesOrderFromData($data)
{
$sliderID = UniteFunctionsRev::getVal($data, "sliderID");
$arrIDs = UniteFunctionsRev::getVal($data, "arrIDs");
UniteFunctionsRev::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(GlobalsRevSlider::$table_slides, $arrUpdate, $where);
}
}
/**
*
* insert variables to some table
*/
public function update($tableName, $arrData, $where)
{
UniteFunctionsRev::validateNotEmpty($tableName, "table cannot be empty");
UniteFunctionsRev::validateNotEmpty($where, "where cannot be empty");
if (is_array($where)) {
$where = $this->getWhereString($where);
}
$strFields = "";
foreach ($arrData as $field => $value) {
$value = "'" . $this->escape($value) . "'";
if ($strFields != "") {
$strFields .= ",";
}
$strFields .= "{$field}={$value}";
}
$updateQuery = "update {$tableName} set {$strFields} where {$where}";
//$updateQuery = "update #__revslider_css set params='{\"font-size\":\"50px\",\"line-height\":\"67px\",\"font-weight\":\"700\",\"font-family\":\"\'Roboto\', sans-serif\",\"color\":\"#ffffff\",\"text-decoration\":\"none\",\"background-color\":\"rgba(141, 68, 173, 0.65)\",\"padding\":\"0px 15px 5px 15px\",\"border-width\":\"0px\",\"border-color\":\"rgb(34, 34, 34)\",\"border-style\":\"none\"}',hover='\"\"',settings='{\"hover\":\"false\"}' where handle = '.tp-caption.roboto'";
$numRows = $this->runSql($updateQuery, "update error");
//dmp($updateQuery);dmp($numRows);exit();
return $numRows;
}
/**
*
* insert variables to some table
*/
public function update($tableName, $arrData, $where)
{
UniteFunctionsRev::validateNotEmpty($tableName, "table cannot be empty");
UniteFunctionsRev::validateNotEmpty($where, "where cannot be empty");
$strFields = "";
foreach ($arrData as $field => $value) {
$value = "'" . $this->escape($value) . "'";
if ($strFields != "") {
$strFields .= ",";
}
$strFields .= "{$field}={$value}";
}
$updateQuery = "update {$tableName} set {$strFields} where {$where}";
$numRows = $this->runSql($updateQuery, "update error");
return $numRows;
}
/**
*
* pub bullets set html
* @param mixed $set - can be array or set name
*/
public static function getBulletsHtml($set, $num = 5)
{
if ($num < 3) {
$num = 3;
}
if (gettype($set) == "string") {
$set = HelperUniteRev::getBulletsSet($set);
}
$options = $set["options"];
$imgLeft = UniteFunctionsRev::getVal($set, "url_bgleft");
$imgRight = UniteFunctionsRev::getVal($set, "url_bgright");
$imgCenter = UniteFunctionsRev::getVal($set, "url_bgrepeat");
$idBackground = false;
if (!empty($imgCenter)) {
$idBackground = true;
//validate background fields
UniteFunctionsRev::validateArrayFieldExists($options, "bg_height,bg_left_width,bg_right_width,padding_top", "getBulletsHtml, background field not found in options");
UniteFunctionsRev::validateNotEmpty($imgRight, "right image");
UniteFunctionsRev::validateNotEmpty($imgLeft, "left image");
}
$space_middle = UniteFunctionsRev::getVal($options, "space_middle", 3);
$html = "";
//Width Background
if ($idBackground == true) {
$bgHeight = $options["bg_height"];
$bgWidthLeft = $options["bg_left_width"];
$bgWidthRight = $options["bg_right_width"];
$paddingTop = $options["padding_top"];
$styleLeft = "float:left;height:{$bgHeight}px;width:{$bgWidthLeft}px;background-image:url(\"{$imgLeft}\");background-repeat:no-repeat;";
$styleRight = "float:left;height:{$bgHeight}px;width:{$bgWidthLeft}px;background-image:url(\"{$imgRight}\");background-repeat:no-repeat;";
$styleCenter = "float:left;height:{$bgHeight}px;background-image:url(\"{$imgCenter}\");background-repeat:releat-x;";
$html .= "<div class='bullets_left' style='{$styleLeft}' ></div>";
$html .= "<div class='bullets_middle' style='{$styleCenter}'>";
$html .= "<div class='bullets_inner' style='padding-top:" . $paddingTop . "px;'>";
$html .= '<ul>';
for ($i = 0; $i < $num; $i++) {
$urlBullet = $set["url_normal"];
if ($i == 1) {
$urlBullet = $set["url_active"];
}
$styleLI = "";
if ($i > 0) {
$styleLI = "margin-left:" . $space_middle . "px";
}
$html .= "<li style='{$styleLI}'><img src='{$urlBullet}'/></li>";
}
$html .= '</ul>';
$html .= '</div>';
$html .= '</div>';
$html .= "<div class='bullets_right' style='{$styleRight}'></div>";
} else {
//no background:
$html .= '<ul>';
for ($i = 0; $i < $num; $i++) {
$urlBullet = $set["url_normal"];
if ($i == 1) {
$urlBullet = $set["url_active"];
}
$styleLI = "";
if ($i > 0) {
$styleLI = "margin-left:" . $space_middle . "px";
}
$html .= "<li style='{$styleLI}'><img src='{$urlBullet}'/></li>";
}
$html .= '</ul>';
}
$html .= '<div class="clear"></div>';
return $html;
}
