Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

[2] Fix | Delete

namespace Nextend\SmartSlider3\Application\Model;

[3] Fix | Delete

[4] Fix | Delete

[5] Fix | Delete

use Exception;

[6] Fix | Delete

use Nextend\Framework\Database\Database;

[7] Fix | Delete

use Nextend\Framework\Model\AbstractModelTable;

[8] Fix | Delete

use Nextend\SmartSlider3\Application\Helper\HelperSliderChanged;

[9] Fix | Delete

use Nextend\SmartSlider3\SmartSlider3Info;

[10] Fix | Delete

[11] Fix | Delete

class ModelSlidersXRef extends AbstractModelTable {

[12] Fix | Delete

[13] Fix | Delete

protected function createConnectorTable() {

[14] Fix | Delete

[15] Fix | Delete

return Database::getTable('nextend2_smartslider3_sliders_xref');

[16] Fix | Delete

}

[17] Fix | Delete

[18] Fix | Delete

public function add($groupID, $sliderID) {

[19] Fix | Delete

try {

[20] Fix | Delete

$this->table->insert(array(

[21] Fix | Delete

'group_id' => $groupID,

[22] Fix | Delete

'slider_id' => $sliderID,

[23] Fix | Delete

'ordering' => $this->getMaximalOrderValue($groupID)

[24] Fix | Delete

));

[25] Fix | Delete

[26] Fix | Delete

$helper = new HelperSliderChanged($this);

[27] Fix | Delete

$helper->setSliderChanged($sliderID, 1);

[28] Fix | Delete

$helper->setSliderChanged($groupID, 1);

[29] Fix | Delete

[30] Fix | Delete

SmartSlider3Info::sliderChanged();

[31] Fix | Delete

[32] Fix | Delete

return true;

[33] Fix | Delete

} catch (Exception $e) {

[34] Fix | Delete

return false;

[35] Fix | Delete

}

[36] Fix | Delete

}

[37] Fix | Delete

[38] Fix | Delete

/**

[39] Fix | Delete

* @param int $groupID

[40] Fix | Delete

[41] Fix | Delete

* @return array the IDs of the deleted child sliders.

[42] Fix | Delete

[43] Fix | Delete

public function deleteGroup($groupID) {

[44] Fix | Delete

$sliders = $this->getSliders($groupID);

[45] Fix | Delete

[46] Fix | Delete

$deletedSliders = array();

[47] Fix | Delete

[48] Fix | Delete

$slidersModel = new ModelSliders($this);

[49] Fix | Delete

foreach ($sliders as $slider) {

[50] Fix | Delete

$relatedGroups = $this->getGroups($slider['slider_id']);

[51] Fix | Delete

if (count($relatedGroups) == 1) {

[52] Fix | Delete

if ($slidersModel->trashOrDelete($slider['slider_id'], $groupID) == 'delete') {

[53] Fix | Delete

$deletedSliders[] = $slider['slider_id'];

[54] Fix | Delete

}

[55] Fix | Delete

}

[56] Fix | Delete

}

[57] Fix | Delete

[58] Fix | Delete

$this->table->deleteByAttributes(array(

[59] Fix | Delete

'group_id' => $groupID

[60] Fix | Delete

));

[61] Fix | Delete

[62] Fix | Delete

SmartSlider3Info::sliderChanged();

[63] Fix | Delete

[64] Fix | Delete

return $deletedSliders;

[65] Fix | Delete

}

[66] Fix | Delete

[67] Fix | Delete

public function deleteSlider($sliderID) {

[68] Fix | Delete

[69] Fix | Delete

$helper = new HelperSliderChanged($this);

[70] Fix | Delete

$helper->setSliderChanged($sliderID, 1);

[71] Fix | Delete

[72] Fix | Delete

SmartSlider3Info::sliderChanged();

[73] Fix | Delete

[74] Fix | Delete

return $this->table->deleteByAttributes(array(

[75] Fix | Delete

'slider_id' => $sliderID

[76] Fix | Delete

));

[77] Fix | Delete

}

[78] Fix | Delete

[79] Fix | Delete

public function deleteXref($groupID, $sliderID) {

[80] Fix | Delete

[81] Fix | Delete

$helper = new HelperSliderChanged($this);

[82] Fix | Delete

$helper->setSliderChanged($sliderID, 1);

[83] Fix | Delete

$helper->setSliderChanged($groupID, 1);

[84] Fix | Delete

[85] Fix | Delete

SmartSlider3Info::sliderChanged();

[86] Fix | Delete

[87] Fix | Delete

return $this->table->deleteByAttributes(array(

[88] Fix | Delete

'group_id' => $groupID,

[89] Fix | Delete

'slider_id' => $sliderID

[90] Fix | Delete

));

[91] Fix | Delete

}

[92] Fix | Delete

[93] Fix | Delete

public function getSliders($groupID, $status = '*') {

[94] Fix | Delete

[95] Fix | Delete

if ($status !== '*') {

[96] Fix | Delete

$slidersModel = new ModelSliders($this);

[97] Fix | Delete

[98] Fix | Delete

return Database::queryAll("

[99] Fix | Delete

SELECT xref.slider_id

[100] Fix | Delete

FROM " . $this->getTableName() . " AS xref

[101] Fix | Delete

LEFT JOIN " . $slidersModel->getTableName() . " AS sliders ON sliders.id = xref.slider_id

[102] Fix | Delete

WHERE xref.group_id = '" . $groupID . "' AND sliders.slider_status LIKE " . Database::quote($status) . "

[103] Fix | Delete

ORDER BY xref.ordering ASC");

[104] Fix | Delete

}

[105] Fix | Delete

[106] Fix | Delete

return Database::queryAll("

[107] Fix | Delete

SELECT slider_id

[108] Fix | Delete

FROM " . $this->getTableName() . "

[109] Fix | Delete

WHERE group_id = '" . $groupID . "'

[110] Fix | Delete

ORDER BY ordering ASC");

[111] Fix | Delete

}

[112] Fix | Delete

[113] Fix | Delete

public function getGroupsIDs($sliderID) {

[114] Fix | Delete

$ids = array();

[115] Fix | Delete

[116] Fix | Delete

$result = Database::queryAll("

[117] Fix | Delete

SELECT group_id

[118] Fix | Delete

FROM " . $this->getTableName() . "

[119] Fix | Delete

WHERE slider_id = '" . $sliderID . "'

[120] Fix | Delete

ORDER BY ordering ASC");

[121] Fix | Delete

[122] Fix | Delete

foreach ($result as $row) {

[123] Fix | Delete

$ids[] = $row['group_id'];

[124] Fix | Delete

}

[125] Fix | Delete

[126] Fix | Delete

return $ids;

[127] Fix | Delete

}

[128] Fix | Delete

[129] Fix | Delete

public function getGroups($sliderID, $status = '*') {

[130] Fix | Delete

$slidersModel = new ModelSliders($this);

[131] Fix | Delete

[132] Fix | Delete

$wheres = array("xref.slider_id = '" . $sliderID . "'");

[133] Fix | Delete

[134] Fix | Delete

if ($status !== '*') {

[135] Fix | Delete

$wheres[] = "sliders.slider_status LIKE '" . $status . "'";

[136] Fix | Delete

}

[137] Fix | Delete

[138] Fix | Delete

$result = Database::queryAll("

[139] Fix | Delete

SELECT xref.group_id, sliders.title

[140] Fix | Delete

FROM " . $this->getTableName() . " AS xref

[141] Fix | Delete

LEFT JOIN " . $slidersModel->getTableName() . " AS sliders ON sliders.id = xref.group_id

[142] Fix | Delete

WHERE " . implode(' AND ', $wheres) . "

[143] Fix | Delete

ORDER BY xref.group_id ASC");

[144] Fix | Delete

[145] Fix | Delete

if (!empty($result)) {

[146] Fix | Delete

return $result;

[147] Fix | Delete

}

[148] Fix | Delete

[149] Fix | Delete

return array(

[150] Fix | Delete

array(

[151] Fix | Delete

"group_id" => 0,

[152] Fix | Delete

"title" => n2_('Dashboard')

[153] Fix | Delete

)

[154] Fix | Delete

);

[155] Fix | Delete

}

[156] Fix | Delete

[157] Fix | Delete

protected function getMaximalOrderValue($groupID) {

[158] Fix | Delete

[159] Fix | Delete

$query = "SELECT MAX(ordering) AS ordering FROM " . $this->getTableName() . " WHERE group_id = '" . intval($groupID) . "'";

[160] Fix | Delete

$result = Database::queryRow($query);

[161] Fix | Delete

[162] Fix | Delete

if (isset($result['ordering'])) return $result['ordering'] + 1;

[163] Fix | Delete

[164] Fix | Delete

return 0;

[165] Fix | Delete

}

[166] Fix | Delete

[167] Fix | Delete

/**

[168] Fix | Delete

* @param $sliderID

[169] Fix | Delete

[170] Fix | Delete

* @return bool

[171] Fix | Delete

[172] Fix | Delete

public function isSliderAvailableInAnyGroups($sliderID) {

[173] Fix | Delete

$allRelatedGroups = $this->getGroups($sliderID);

[174] Fix | Delete

[175] Fix | Delete

$slidersModel = new ModelSliders($this);

[176] Fix | Delete

[177] Fix | Delete

foreach ($allRelatedGroups as $group) {

[178] Fix | Delete

if ($group['group_id'] != 0) {

[179] Fix | Delete

[180] Fix | Delete

* It is a group

[181] Fix | Delete

[182] Fix | Delete

$sliderRow = $slidersModel->get($group['group_id']);

[183] Fix | Delete

if (isset($sliderRow['slider_status']) && $sliderRow['slider_status'] === 'published') {

[184] Fix | Delete

return true;

[185] Fix | Delete

}

[186] Fix | Delete

} else {

[187] Fix | Delete

[188] Fix | Delete

* It is a slider

[189] Fix | Delete

[190] Fix | Delete

$sliderRow = $slidersModel->get($sliderID);

[191] Fix | Delete

if (isset($sliderRow['slider_status']) && $sliderRow['slider_status'] === 'published') {

[192] Fix | Delete

return true;

[193] Fix | Delete

}

[194] Fix | Delete

}

[195] Fix | Delete

}

[196] Fix | Delete

[197] Fix | Delete

return false;

[198] Fix | Delete

}

[199] Fix | Delete

}

[200] Fix | Delete