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