protected function updateExecute()
{
parent::updateExecute();
$queryListIP = "UPDATE `FeedbacksListIP` SET ";
$queryListIP .= "`ip` = '" . $this->insertValue['alias'] . "', ";
$queryListIP .= "`status` = '" . $this->insertValue['status'] . "', ";
$queryListIP .= "`comment` = " . InputValueHelper::mayByNull($this->insertValue['comment']) . " ";
$queryListIP .= "WHERE `ip`='" . $this->editElement . "';";
$this->SQL_HELPER->insert($queryListIP);
// echo var_dump($queryListIP). '<hr>';
}
protected function updateExecute()
{
parent::updateExecute();
$queryContactsUnitsTypes = "UPDATE `ContactsUnitsTypes` SET ";
$queryContactsUnitsTypes .= "`type` = '" . $this->insertValue['alias'] . "', ";
$queryContactsUnitsTypes .= "`sequence` = '" . $this->insertValue['sequence'] . "', ";
$queryContactsUnitsTypes .= "`show` = '" . $this->insertValue['show'] . "'";
$queryContactsUnitsTypes .= " WHERE `type`='" . $this->editElement . "';";
$queryContactsUnitsTypes_Lang = array();
foreach ($this->langArray as $langData) {
if (isset($this->insertValue['typeName'][$langData['lang']]) && $this->insertValue['typeName'][$langData['lang']] != null && $this->insertValue['typeName'][$langData['lang']] != "") {
$query = "INSERT INTO `ContactsUnitsTypes_Lang` SET ";
$query .= "`type` = '" . $this->insertValue['alias'] . "', ";
$query .= "`lang` = '" . $langData['lang'] . "', ";
$query .= "`typeName` = '" . $this->insertValue['typeName'][$langData['lang']] . "', ";
$query .= "`topText` = " . InputValueHelper::mayByNull($this->insertValue['topText'][$langData['lang']]) . ", ";
$query .= "`bottomText` = " . InputValueHelper::mayByNull($this->insertValue['bottomText'][$langData['lang']]) . "; ";
$queryContactsUnitsTypes_Lang[] = $query;
}
}
$queryContactsUnitsTypes_LangDel = "DELETE FROM `ContactsUnitsTypes_Lang` WHERE `type` = '" . $this->editElement . "';";
if ($this->SQL_HELPER->insert($queryContactsUnitsTypes)) {
$this->SQL_HELPER->insert($queryContactsUnitsTypes_LangDel);
foreach ($queryContactsUnitsTypes_Lang as $queryContactsUnitsTypes_Lg) {
$this->SQL_HELPER->insert($queryContactsUnitsTypes_Lg);
}
$this->uploadImage();
} else {
echo 'Данные не были добавлены. Попробуйте позже.';
}
}
/**
* Выполнение изменения в таблице
*/
protected function updateExecute()
{
parent::updateExecute();
$queryMaterials = "UPDATE `Materials` SET ";
$queryMaterials .= "`alias`='" . $this->insertValue['alias'] . "', ";
$queryMaterials .= "`created`='" . $this->insertValue['created'] . "', ";
$queryMaterials .= "`lastChange`='" . $this->insertValue['lastChange'] . "', ";
$queryMaterials .= "`showTitle`='" . $this->insertValue['showTitle'] . "', ";
$queryMaterials .= "`showCreated`='" . $this->insertValue['showCreated'] . "', ";
$queryMaterials .= "`showChange`='" . $this->insertValue['showChange'] . "' ";
$queryMaterials .= "WHERE `alias`='" . $this->editElement . "';";
$queryMaterials_Lang = array();
foreach ($this->langArray as $langData) {
if (isset($this->insertValue['title'][$langData['lang']]) && $this->insertValue['title'][$langData['lang']] != null && $this->insertValue['title'][$langData['lang']] != "" && isset($this->insertValue['text'][$langData['lang']]) && $this->insertValue['text'][$langData['lang']] != null && $this->insertValue['text'][$langData['lang']] != "") {
$query = "INSERT INTO `Materials_Lang` SET ";
$query .= "`material`='" . $this->insertValue['alias'] . "', ";
$query .= "`lang`='" . $langData['lang'] . "', ";
$query .= "`title`='" . $this->insertValue['title'][$langData['lang']] . "', ";
$query .= "`text`='" . $this->insertValue['text'][$langData['lang']] . "';";
$queryMaterials_Lang[] = $query;
}
}
$queryMaterialsInCategories = array();
if ($this->insertValue['categories'] != null) {
foreach ($this->insertValue['categories'] as $category) {
$query = "INSERT INTO `MaterialsInCategories` SET ";
$query .= "`material`='" . $this->insertValue['alias'] . "', ";
$query .= "`category`='" . $category . "';";
$queryMaterialsInCategories[] = $query;
}
}
$queryMaterials_LangDel = "DELETE FROM `Materials_Lang` WHERE `material` = '" . $this->editElement . "';";
$this->SQL_HELPER->insert($queryMaterials_LangDel);
$queryMaterialsInCategoriesDel = "DELETE FROM `MaterialsInCategories` WHERE `material` = '" . $this->editElement . "';";
$this->SQL_HELPER->insert($queryMaterialsInCategoriesDel);
$this->SQL_HELPER->insert($queryMaterials);
foreach ($queryMaterials_Lang as $queryMaterials_Lg) {
$this->SQL_HELPER->insert($queryMaterials_Lg);
}
foreach ($queryMaterialsInCategories as $queryMaterialsInCategory) {
$this->SQL_HELPER->insert($queryMaterialsInCategory);
}
$this->uploadFile();
}
/**
* Выполнение изменения в таблице
*/
protected function updateExecute()
{
parent::updateExecute();
$querylist = "UPDATE `MaterialsCategoriesList` SET ";
$queryList .= "`name`='" . $this->insertValue['alias'] . "', ";
$queryList .= "`showFullMaterialsText`='" . $this->insertValue['showFullMaterialsText'] . "', ";
$queryList .= "`showShortMaterialsText`='" . $this->insertValue['showShortMaterialsText'] . "', ";
$queryList .= "`showCategories`='" . $this->insertValue['showCategories'] . "', ";
$queryList .= "`showCreated`='" . $this->insertValue['showCreated'] . "', ";
$queryList .= "`showChange`='" . $this->insertValue['showChange'] . "',";
$queryList .= "`categorialsAsURL`='" . $this->insertValue['categorialsAsURL'] . "', ";
$queryList .= "`titleAsURL`='" . $this->insertValue['titleAsURL'] . "', ";
$queryList .= "`showAllOnPage`='" . $this->insertValue['showAllOnPage'] . "', ";
$queryList .= "`onPage`='" . $this->insertValue['onPage'] . "', ";
$queryList .= "`maxPages`='" . $this->insertValue['maxPages'] . "'";
$querylist .= "WHERE `name`='" . $this->editElement . "';";
$queryList_Lang = array();
foreach ($this->langArray as $langData) {
if (isset($this->insertValue['name'][$langData['lang']]) && $this->insertValue['name'][$langData['lang']] != null && $this->insertValue['name'][$langData['lang']] != "" && isset($this->insertValue['description'][$langData['lang']]) && $this->insertValue['description'][$langData['lang']] != null && $this->insertValue['description'][$langData['lang']] != "") {
$query = "INSERT INTO `MaterialsCategoriesList_Lang` SET ";
$query .= "`list`='" . $this->insertValue['alias'] . "', ";
$query .= "`lang`='" . $langData['lang'] . "', ";
$query .= "`name`='" . $this->insertValue['name'][$langData['lang']] . "', ";
$query .= "`description`='" . $this->insertValue['description'][$langData['lang']] . "';";
$queryList_Lang[] = $query;
}
}
$queryCategoriesInList = array();
foreach ($this->insertValue['categories'] as $category => $sequence) {
if ($sequence != null && $sequence != '') {
$queryInList = "INSERT INTO `MaterialsCategoriesInList` SET ";
$queryInList .= "`category`='" . $category . "', ";
$queryInList .= "`list`='" . $this->insertValue['alias'] . "', ";
$queryInList .= "`sequence`='" . $sequence . "' ";
$queryInList .= ";";
$queryCategoriesInList[] = $queryInList;
}
}
$queryList_LangDel = "DELETE FROM `MaterialsList_Lang` WHERE `list` = '" . $this->editElement . "';";
$this->SQL_HELPER->insert($queryList_LangDel);
$queryCategoriesInListDel = "DELETE FROM `MaterialsCategoriesInList` WHERE `list` = '" . $this->editElement . "';";
$this->SQL_HELPER->insert($queryCategoriesInListDel);
$this->SQL_HELPER->insert($querylist);
foreach ($queryList_Lang as $queryList_Lg) {
$this->SQL_HELPER->insert($queryList_Lg);
}
foreach ($queryCategoriesInList as $queryCategoriesInL) {
$this->SQL_HELPER->insert($queryCategoriesInL);
}
}
protected function updateExecute()
{
parent::updateExecute();
$queryFeedbacks = "UPDATE `Feedbacks` SET ";
$queryFeedbacks .= "`ip` = '" . $this->insertValue['ip'] . "', ";
$queryFeedbacks .= "`fio` = '" . $this->insertValue['fio'] . "', ";
$queryFeedbacks .= "`title` = " . InputValueHelper::mayByNull($this->insertValue['title']) . ", ";
$queryFeedbacks .= "`text` = '" . $this->insertValue['text'] . "', ";
$queryFeedbacks .= "`email` = " . InputValueHelper::mayByNull($this->insertValue['email']) . ", ";
$queryFeedbacks .= "`phone` = " . InputValueHelper::mayByNull($this->insertValue['phone']) . ", ";
$queryFeedbacks .= "`date` = '" . date("Y-m-d h:i:s") . "', ";
$queryFeedbacks .= "`rating` = 'noRating', ";
$queryFeedbacks .= "`show` = '1', ";
$queryFeedbacks .= "`like` = '" . $this->insertValue['like'] . "', ";
$queryFeedbacks .= "`dislike` = '" . $this->insertValue['dislike'] . "' ";
$queryFeedbacks .= "WHERE `id`='" . $this->editElement . "';";
// 8(910)567-58-98
// sokolovka@apelsin.ru
$queryListIP = "INSERT INTO `FeedbacksListIP` SET ";
$queryListIP .= "`ip` = '" . $this->insertValue['ip'] . "', ";
$queryListIP .= "`status` = 'default';";
$queryIsComments = "UPDATE `FeedbacksIsComments` SET ";
$queryIsComments .= "`parentFeedback` = '" . $this->insertValue['parentFeedback'] . "' ";
$queryIsComments .= "WHERE `feedback`='" . $this->editElement . "';";
if ($this->getDataListIP($this->insertValue['ip']) == null) {
$this->SQL_HELPER->insert($queryListIP);
// echo var_dump($queryListIP). '<hr>';
$this->SQL_HELPER->insert($queryFeedbacks);
// echo var_dump($queryFeedbacks). '<hr>';
$this->SQL_HELPER->insert($queryIsComments);
// echo var_dump($queryIsComments). '<hr>';
} else {
$this->SQL_HELPER->insert($queryFeedbacks);
// echo var_dump($queryFeedbacks). '<hr>';
$this->SQL_HELPER->insert($queryIsComments);
// echo var_dump($queryIsComments). '<hr>';
}
}
protected function updateExecute()
{
parent::updateExecute();
$queryContactsWorkers = "UPDATE `ContactsWorkers` SET ";
$queryContactsWorkers .= "`worker` = '" . $this->insertValue['alias'] . "', ";
$queryContactsWorkers .= "`post` = '" . $this->insertValue['post'] . "', ";
$queryContactsWorkers .= "`email1` = '" . $this->insertValue['email1'] . "', ";
$queryContactsWorkers .= "`email2` = '" . $this->insertValue['email2'] . "', ";
$queryContactsWorkers .= "`phoneText1` = '" . $this->insertValue['phoneText1'] . "', ";
$queryContactsWorkers .= "`phone1` = '" . $this->insertValue['phone1'] . "', ";
$queryContactsWorkers .= "`phoneText2` = '" . $this->insertValue['phoneText2'] . "', ";
$queryContactsWorkers .= "`phone2` = '" . $this->insertValue['phone2'] . "', ";
$queryContactsWorkers .= "`additional1` = '" . $this->insertValue['additional1'] . "', ";
$queryContactsWorkers .= "`additional2` = '" . $this->insertValue['additional2'] . "' ";
$queryContactsWorkers .= " WHERE `worker`='" . $this->editElement . "';";
$queryContactsWorkers_LangDel = "DELETE FROM `ContactsWorkers_Lang` WHERE `worker` = '" . $this->editElement . "';";
$queryContactsWorkers_Lang = array();
foreach ($this->langArray as $langData) {
if (isset($this->insertValue['fio'][$langData['lang']]) && $this->insertValue['fio'][$langData['lang']] != null && $this->insertValue['fio'][$langData['lang']] != "") {
$queryLang = "INSERT INTO `ContactsWorkers_Lang` SET ";
$queryLang .= "`worker`='" . $this->insertValue['alias'] . "', ";
$queryLang .= "`lang`='" . $langData['lang'] . "', ";
$queryLang .= "`fio`='" . $this->insertValue['fio'][$langData['lang']] . "', ";
$queryLang .= "`info`='" . $this->insertValue['info'][$langData['lang']] . "';";
$queryContactsWorkers_Lang[] = $queryLang;
}
}
$queryContactsUnitsWokersDel = "DELETE FROM `ContactsUnitsWokers` WHERE `worker` = '" . $this->editElement . "';";
$queryContactsUnitsWokers = array();
if ($this->insertValue['units'] != null) {
foreach ($this->insertValue['units'] as $unit) {
$query = "INSERT INTO `ContactsUnitsWokers` SET ";
$query .= "`unit`='" . $unit . "', ";
$query .= "`worker`='" . $this->insertValue['alias'] . "';";
$queryContactsUnitsWokers[] = $query;
}
}
if ($this->SQL_HELPER->insert($queryContactsWorkers)) {
// echo var_dump($queryContactsWorkers) .'<hr>';
$this->SQL_HELPER->insert($queryContactsWorkers_LangDel);
// echo var_dump($queryContactsWorkers_LangDel) .'<hr>';
foreach ($queryContactsWorkers_Lang as $queryContactsWorkers_Lg) {
// echo var_dump($queryContactsWorkers_Lg) .'<hr>';
$this->SQL_HELPER->insert($queryContactsWorkers_Lg);
}
$this->SQL_HELPER->insert($queryContactsUnitsWokersDel);
// echo var_dump($queryContactsUnitsWokersDel) .'<hr>';
foreach ($queryContactsUnitsWokers as $queryContactsUnitsWoker) {
$this->SQL_HELPER->insert($queryContactsUnitsWoker);
// echo var_dump($queryContactsUnitsWoker) .'<hr>';
}
} else {
echo 'Данные не были добавлены. Попробуйте позже.';
}
}
protected function updateExecute()
{
parent::updateExecute();
$queryContactsUnits = "UPDATE `ContactsUnits` SET ";
$queryContactsUnits .= "`unit` = '" . $this->insertValue['alias'] . "', ";
$queryContactsUnits .= "`show` = '" . $this->insertValue['show'] . "', ";
$queryContactsUnits .= "`showOnMain` = '" . $this->insertValue['showOnMain'] . "', ";
$queryContactsUnits .= "`type` = '" . $this->insertValue['type'] . "', ";
$queryContactsUnits .= "`sequence` = '" . $this->insertValue['sequence'] . "', ";
$queryContactsUnits .= "`email` = '" . $this->insertValue['email'] . "', ";
$queryContactsUnits .= "`feedbackEmail` = '" . $this->insertValue['feedbackEmail'] . "', ";
$queryContactsUnits .= "`phoneText1` = '" . $this->insertValue['phoneText1'] . "', ";
$queryContactsUnits .= "`phone1` = '" . $this->insertValue['phone1'] . "', ";
$queryContactsUnits .= "`phoneText2` = '" . $this->insertValue['phoneText2'] . "', ";
$queryContactsUnits .= "`phone2` = '" . $this->insertValue['phone2'] . "', ";
$queryContactsUnits .= "`additional1` = '" . $this->insertValue['additional1'] . "', ";
$queryContactsUnits .= "`additional2` = '" . $this->insertValue['additional2'] . "', ";
$queryContactsUnits .= $this->setQueryDays('mon');
$queryContactsUnits .= $this->setQueryDays('tue');
$queryContactsUnits .= $this->setQueryDays('wed');
$queryContactsUnits .= $this->setQueryDays('thu');
$queryContactsUnits .= $this->setQueryDays('fri');
$queryContactsUnits .= $this->setQueryDays('sat');
$queryContactsUnits .= $this->setQueryDays('sun', false);
$queryContactsUnits .= " WHERE `unit`='" . $this->editElement . "';";
$queryContactsUnits_LangDel = "DELETE FROM `ContactsUnits_Lang` WHERE `unit` = '" . $this->editElement . "';";
$queryContactsUnitsMapsDel = "DELETE FROM `ContactsUnitsMaps` WHERE `unit` = '" . $this->editElement . "';";
$queryContactsUnitsMaps = "INSERT INTO `ContactsUnitsMaps` SET ";
$queryContactsUnitsMaps .= "`unit` = '" . $this->insertValue['alias'] . "', ";
$queryContactsUnitsMaps .= "`map` = '" . $this->insertValue['map'] . "', ";
$queryContactsUnitsMaps .= "`show` = '" . $this->insertValue['showMap'] . "'; ";
$queryContactsUnits_Lang = array();
foreach ($this->langArray as $langData) {
if (isset($this->insertValue['name'][$langData['lang']]) && $this->insertValue['name'][$langData['lang']] != null && $this->insertValue['name'][$langData['lang']] != "") {
$queryLang = "INSERT INTO `ContactsUnits_Lang` SET ";
$queryLang .= "`unit` = '" . $this->insertValue['alias'] . "', ";
$queryLang .= "`lang` = '" . $langData['lang'] . "', ";
$queryLang .= "`name` = '" . $this->insertValue['name'][$langData['lang']] . "', ";
$queryLang .= "`adress` = " . InputValueHelper::mayByNull($this->insertValue['adress'][$langData['lang']]) . ", ";
$queryLang .= "`postAdress` = " . InputValueHelper::mayByNull($this->insertValue['postAdress'][$langData['lang']]) . ", ";
$queryLang .= "`text` = " . InputValueHelper::mayByNull($this->insertValue['text'][$langData['lang']]) . "; ";
$queryContactsUnits_Lang[] = $queryLang;
}
}
$queryContactsUnitsWokers = array();
if ($this->insertValue['workers'] != null) {
foreach ($this->insertValue['workers'] as $worker) {
$query = "INSERT INTO `ContactsUnitsWokers` SET ";
$query .= "`unit`='" . $this->insertValue['alias'] . "', ";
$query .= "`worker`='" . $worker . "';";
$queryContactsUnitsWokers[] = $query;
}
}
$queryContactsUnitsWokersDel = "DELETE FROM `ContactsUnitsWokers` WHERE `unit` = '" . $this->editElement . "';";
if ($this->SQL_HELPER->insert($queryContactsUnits)) {
$this->SQL_HELPER->insert($queryContactsUnits_LangDel);
foreach ($queryContactsUnits_Lang as $queryContactsUnits_Lg) {
$this->SQL_HELPER->insert($queryContactsUnits_Lg);
}
$this->SQL_HELPER->insert($queryContactsUnitsMapsDel);
$this->SQL_HELPER->insert($queryContactsUnitsMaps);
$this->SQL_HELPER->insert($queryContactsUnitsWokersDel);
foreach ($queryContactsUnitsWokers as $queryContactsUnitsWoker) {
$this->SQL_HELPER->insert($queryContactsUnitsWoker);
}
$this->uploadImage();
} else {
echo 'Данные не были добавлены. Попробуйте позже.';
}
}
protected function updateExecute()
{
parent::updateExecute();
$queryWorkersPosts = "UPDATE `ContactsWorkersPosts` SET ";
$queryWorkersPosts .= "`post`='" . $this->insertValue['alias'] . "', ";
$queryWorkersPosts .= "`sequence`=" . InputValueHelper::mayByNull($this->insertValue['sequence']) . "";
$queryWorkersPosts .= " WHERE `post`='" . $this->editElement . "';";
$queryWorkersPosts_Lang = array();
foreach ($this->langArray as $langData) {
if (isset($this->insertValue['postName'][$langData['lang']]) && $this->insertValue['postName'][$langData['lang']] != null && $this->insertValue['postName'][$langData['lang']] != "") {
$queryLang = "INSERT INTO `ContactsWorkersPosts_Lang` SET ";
$queryLang .= "`post`='" . $this->insertValue['alias'] . "',";
$queryLang .= "`lang`='" . $langData['lang'] . "',";
$queryLang .= "`postName`='" . $this->insertValue['postName'][$langData['lang']] . "';";
$queryWorkersPosts_Lang[] = $queryLang;
}
}
$queryContactsUnitsTypes_LangDel = "DELETE FROM `ContactsWorkersPosts_Lang` WHERE `post` = '" . $this->editElement . "';";
if ($this->SQL_HELPER->insert($queryWorkersPosts)) {
$this->SQL_HELPER->insert($queryContactsUnitsTypes_LangDel);
foreach ($queryWorkersPosts_Lang as $queryWorkersPosts_Lg) {
$this->SQL_HELPER->insert($queryWorkersPosts_Lg);
}
} else {
echo 'Данные не были добавлены. Попробуйте позже.';
}
}
/**
* Выполнение изменения в таблице
*/
protected function updateExecute()
{
parent::updateExecute();
$queryCategories = "UPDATE `MaterialsCategories` SET ";
$queryCategories .= "`alias`='" . $this->insertValue['alias'] . "', ";
$queryCategories .= "`created`='" . $this->insertValue['created'] . "', ";
$queryCategories .= "`lastChange`='" . $this->insertValue['lastChange'] . "' ";
$queryCategories .= "WHERE `alias`='" . $this->editElement . "';";
$queryCategories_Lang = array();
foreach ($this->langArray as $langData) {
if (isset($this->insertValue['name'][$langData['lang']]) && $this->insertValue['name'][$langData['lang']] != null && $this->insertValue['name'][$langData['lang']] != "" && isset($this->insertValue['description'][$langData['lang']]) && $this->insertValue['description'][$langData['lang']] != null && $this->insertValue['description'][$langData['lang']] != "") {
$query = "INSERT INTO `MaterialsCategories_Lang` SET ";
$query .= "`category`='" . $this->insertValue['alias'] . "', ";
$query .= "`lang`='" . $langData['lang'] . "', ";
$query .= "`name`='" . $this->insertValue['name'][$langData['lang']] . "', ";
$query .= "`description`='" . $this->insertValue['description'][$langData['lang']] . "';";
$queryCategories_Lang[] = $query;
}
}
$queryCategoriesInLists = array();
if ($this->insertValue['list'] != null) {
$querySequence = "SELECT `sequence` FROM `MaterialsCategoriesInList` ;";
$sequence = $this->SQL_HELPER->select($querySequence);
$count = array();
foreach ($sequence as $seq) {
$count[] = $seq['sequence'];
}
if ($count != null) {
$sequenceFinal = max($count) + 1;
}
foreach ($this->insertValue['list'] as $list) {
$query = "INSERT INTO `MaterialsCategoriesInList` SET ";
$query .= "`category`='" . $this->insertValue['alias'] . "', ";
$query .= "`list`='" . $list . "',";
$query .= "`sequence`='" . $sequenceFinal . "';";
$queryCategoriesInLists[] = $query;
}
}
$queryCategories_LangDel = "DELETE FROM `MaterialsCategories_Lang` WHERE `category` = '" . $this->editElement . "'";
$this->SQL_HELPER->insert($queryCategories_LangDel);
$queryCategoriesInListDel = "DELETE FROM `MaterialsCategoriesInList` WHERE `category` = '" . $this->editElement . "'";
$this->SQL_HELPER->insert($queryCategoriesInListDel);
$this->SQL_HELPER->insert($queryCategories);
foreach ($queryCategories_Lang as $queryCategories_Lg) {
$this->SQL_HELPER->insert($queryCategories_Lg);
}
foreach ($queryCategoriesInLists as $queryCategoriesInList) {
$this->SQL_HELPER->insert($queryCategoriesInList);
}
}
