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