protected function insertExecute() { parent::insertExecute(); $queryListIP = "INSERT INTO `FeedbacksListIP` SET "; $queryListIP .= "`ip` = '" . $this->insertValue['alias'] . "', "; $queryListIP .= "`status` = '" . $this->insertValue['status'] . "', "; $queryListIP .= "`comment` = " . InputValueHelper::mayByNull($this->insertValue['comment']) . "; "; $this->SQL_HELPER->insert($queryListIP); // echo var_dump($queryListIP). '<hr>'; }
/** * Генерация форм ввода зависимых от языка */ protected function getInputLangBlocks($lang) { $html = parent::getInputLangBlocks($lang); // name $title = $this->inputHelper->textBox('name[' . $lang . ']', 'name', 'name', 200, false, $this->originalInsertValue['name'][$lang]); $html .= $this->inputHelper->createFormRow($title, false, 'Название'); // description $text = $this->inputHelper->textarea('description[' . $lang . ']', 'description', 'description', 50000, false, $this->originalInsertValue['description'][$lang]); $html .= $this->inputHelper->createFormRow($text, false, 'Описание'); return $html; }
protected function getInputLangBlocks($lang) { $html = parent::getInputLangBlocks($lang); // typeName $typeName = $this->inputHelper->textBox('typeName[' . $lang . ']', 'typeName', 'typeName', 200, false, $this->originalInsertValue['typeName'][$lang]); $html .= $this->inputHelper->createFormRow($typeName, false, 'Название'); // topText $topText = $this->inputHelper->textarea('topText[' . $lang . ']', 'topText', 'topText', 50000, false, $this->originalInsertValue['topText'][$lang]); $html .= $this->inputHelper->createFormRow($topText, false, 'Верхний текст'); // bottomText $bottomText = $this->inputHelper->textarea('bottomText[' . $lang . ']', 'bottomText', 'bottomText', 50000, false, $this->originalInsertValue['bottomText'][$lang]); $html .= $this->inputHelper->createFormRow($bottomText, false, 'Нижний текст'); return $html; }
protected function insertExecute() { parent::insertExecute(); $queryContactsWorkers = "INSERT INTO `ContactsWorkers` SET "; $queryContactsWorkers .= "`worker`='" . $this->insertValue['alias'] . "', "; $queryContactsWorkers .= "`post`='" . $this->insertValue['post'] . "', "; $queryContactsWorkers .= "`email1`='" . $this->insertValue['email1'] . "', "; $queryContactsWorkers .= "`email2`=" . InputValueHelper::mayByNull($this->insertValue['email2']) . ", "; $queryContactsWorkers .= "`phoneText1`=" . InputValueHelper::mayByNull($this->insertValue['phoneText1']) . ", "; $queryContactsWorkers .= "`phoneText2`=" . InputValueHelper::mayByNull($this->insertValue['phoneText2']) . ", "; $queryContactsWorkers .= "`phone1`=" . InputValueHelper::mayByNull($this->insertValue['phone1']) . ", "; $queryContactsWorkers .= "`phone2`=" . InputValueHelper::mayByNull($this->insertValue['phone2']) . ", "; $queryContactsWorkers .= "`additional1`=" . InputValueHelper::mayByNull($this->insertValue['additional1']) . ", "; $queryContactsWorkers .= "`additional2`=" . InputValueHelper::mayByNull($this->insertValue['additional2']) . "; "; $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; } } $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)) { foreach ($queryContactsWorkers_Lang as $queryContactsWorkers_Lg) { $this->SQL_HELPER->insert($queryContactsWorkers_Lg); } foreach ($queryContactsUnitsWokers as $queryContactsUnitsWoker) { $this->SQL_HELPER->insert($queryContactsUnitsWoker); } } else { echo 'Данные не были добавлены. Попробуйте позже.'; } }
protected function insertExecute() { parent::insertExecute(); $queryWorkersPosts = "INSERT INTO `ContactsWorkersPosts` SET "; $queryWorkersPosts .= "`post`='" . $this->insertValue['alias'] . "', "; $queryWorkersPosts .= "`sequence`=" . InputValueHelper::mayByNull($this->insertValue['sequence']) . ";"; $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['post'][$langData['lang']] . "',"; $queryLang .= "`lang`='" . $this->insertValue['lang'][$langData['lang']] . "',"; $queryLang .= "`postName`='" . $this->insertValue['postName'][$langData['lang']] . "';"; $queryWorkersPosts_Lang[] = $queryLang; } } if ($this->SQL_HELPER->insert($queryWorkersPosts)) { foreach ($queryWorkersPosts_Lang as $queryWorkersPosts_Lg) { $this->SQL_HELPER->insert($queryWorkersPosts_Lg); } } else { echo 'Данные не были добавлены. Попробуйте позже.'; } }
protected function insertExecute() { parent::insertExecute(); $queryFeedbacks = "INSERT INTO `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` = '" . $this->insertValue['rating'] . "', "; $queryFeedbacks .= "`show` = '" . $this->insertValue['show'] . "', "; $queryFeedbacks .= "`like` = '" . $this->insertValue['like'] . "', "; $queryFeedbacks .= "`dislike` = '" . $this->insertValue['dislike'] . "'; "; // 8(910)567-58-98 // sokolovka@apelsin.ru $ip = $this->getDataListIP($this->insertValue['ip']); if ($ip == null) { $queryListIP = "INSERT INTO `FeedbacksListIP` SET "; $queryListIP .= "`ip` = '" . $this->insertValue['ip'] . "', "; $queryListIP .= "`status` = 'default';"; $this->SQL_HELPER->insert($queryListIP); // echo var_dump($queryListIP). '<hr>'; $this->SQL_HELPER->insert($queryFeedbacks); $this->insertValue['alias'] = $this->SQL_HELPER->lastInsertID(); // echo var_dump($this->id). '<hr>'; // echo var_dump($queryFeedbacks). '<hr>'; } else { $this->SQL_HELPER->insert($queryFeedbacks); // echo var_dump($queryFeedbacks). '<hr>'; $this->insertValue['alias'] = $this->SQL_HELPER->lastInsertID(); } }
private function setDayTime($day) { $keyHS = $day . 'H_s'; $keyMS = $day . 'M_s'; $keyHE = $day . 'H_e'; $keyME = $day . 'M_e'; $this->insertValue[$keyHS] = parent::getPostValue($keyHS); $this->insertValue[$keyMS] = parent::getPostValue($keyMS); $this->insertValue[$keyHE] = parent::getPostValue($keyHE); $this->insertValue[$keyME] = parent::getPostValue($keyME); if ($this->insertValue[$keyHS] != null && $this->insertValue[$keyHE] != null) { $this->insertValue[$keyMS] = "0"; $this->insertValue[$keyME] = "0"; } }
/** * Выполнение вставки в таблицы */ protected function insertExecute() { parent::insertExecute(); $queryList = "INSERT INTO `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_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; } } $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 getInputLangBlocks($lang) { $html = parent::getInputLangBlocks($lang); // title $title = $this->inputHelper->textBox('title[' . $lang . ']', 'title', 'title', 200, false, $this->originalInsertValue['title'][$lang]); $html .= $this->inputHelper->createFormRow($title, false, 'Заголовок'); // text $text = $this->inputHelper->textarea('text[' . $lang . ']', 'text', 'text', 50000, false, $this->originalInsertValue['text'][$lang]); $html .= $this->inputHelper->createFormRow($text, false, 'Текст'); return $html; }