public function add($pageType, $iPage)
{
$db = Zend_Db_Table::getDefaultAdapter();
$values = $values_key = '';
$metadata_pageType = $db->describeTable($pageType);
foreach ($metadata_pageType as $k => $v) {
//if(@$_POST[$k] && $_POST[$k] !== false)
if (@$_POST[$k]) {
if ($_POST[$k] == "on") {
$_POST[$k] = 1;
}
if ($values) {
$values .= ",";
}
$_POST[$k] = str_replace("'", "\"", $_POST[$k]);
if (strlen($_POST[$k]) > 10000) {
$this->flag = 1;
}
$values .= "'" . $_POST[$k] . "'";
if ($values_key) {
$values_key .= ",";
}
$values_key .= $k;
}
}
if ($_FILES && @(!$return['message']) && $pageType != 'news') {
// var_dump($_FILES); die();
$resize = 0;
if ($iPage['resize'] != 0) {
$resize = 1;
}
$AddFiles = new Core_Controller_Action_Helper_AddFiles();
$files_array = $AddFiles->checkFiles($pageType, $resize);
if (@$files_array['message']) {
$return['message'] = $files_array['message'];
}
}
if ($pageType == 'top') {
$exist = $db->fetchRow("SELECT t.id FROM top t WHERE t.film_id=" . $_POST['film_id']);
if ($exist != false) {
$return['message'] = 'Фильм уже существует';
}
}
if (@(!$return['message'])) {
$row = $db->fetchRow("SELECT MAX(position) as position\n\t\t\t\tFROM\n\t\t\t\t " . $pageType . " AS p\n\t\t\t\tWHERE\n\t\t\t\t p.page_id = " . $iPage['menu_activ']);
if ($row['position'] != '') {
$values_key .= ",position";
$values .= ",'" . ($row['position'] + 1) . "'";
}
if ($pageType == 'films') {
$storages = $db->fetchRow('select name from storages where isactive = "1"');
$values_key .= ",storages";
$values .= ",'" . $storages['name'] . "'";
}
// if($this->flag == 1)
// {
// $sql = "INSERT INTO ".$pageType.
// "(".$values_key.") ".
// "VALUES ".
// "(".$values.")";
// $isklucheniedb = new Core_Controller_Action_Helper_isklucheniedb();
// $isklucheniedb->iskluchenie_db($sql);
// }
// else
$db->query("INSERT INTO " . $pageType . " (" . $values_key . ") VALUES (" . $values . ")");
$return['id_row'] = $db->lastInsertId();
if ($_FILES && $pageType != 'news') {
// var_dump($_FILES); die();
$AddFiles->workings_files($resize, $pageType, $return['id_row']);
}
if ($pageType == 'banners') {
$update = '';
$return['id_row'] = $db->lastInsertId();
$img_link = 'http://' . $_SERVER['SERVER_NAME'] . '/public/' . $pageType . '/' . $_GET['menu_id'] . '/' . $return['id_row'] . '/banner' . $_FILES['banner']['name'];
// var_dump($img_link);die();
// $values_key .=",img";
// $values .=",'".$img_link."'";
$db->query("UPDATE " . $pageType . " SET img='" . $img_link . "' WHERE id = " . $return['id_row']);
}
}
return @$return;
}
public function update($pageType, $iPage)
{
// var_dump($_GET);die();
$return['id_row'] = $_GET['pages_id'];
$db = Zend_Db_Table::getDefaultAdapter();
$update = $files_array = '';
$metadata_pageType = $db->describeTable($pageType);
// echo '<pre>';
//// var_dump($metadata_pageType);die();
// var_dump($_POST);die();
// echo '</pre>';
foreach ($metadata_pageType as $k => $v) {
/* if($_POST[$k])
{*/
if (isset($_POST[$k]) || $metadata_pageType[$k]['NULLABLE'] == 1 && (strpos($metadata_pageType[$k]['DATA_TYPE'], 'text') !== false || $metadata_pageType[$k]['DATA_TYPE'] == 'varchar')) {
if ($update) {
$update .= ",";
}
$_POST[$k] = str_replace("'", "\"", $_POST[$k]);
if ($_POST[$k] == "on") {
$_POST[$k] = 1;
}
if (strlen($v) > 10000) {
$this->flag = 1;
}
$update .= "`" . $k . "`='" . $_POST[$k] . "'";
}
// }
}
// var_dump($update);die();
if ($_FILES && @(!$return['message']) && $pageType != 'news') {
$resize = 0;
if ($iPage['resize'] != 0) {
$resize = 1;
}
$AddFiles = new Core_Controller_Action_Helper_AddFiles();
$files_array = $AddFiles->checkFiles($pageType, $resize);
if (@$files_array['message']) {
$return['message'] = $files_array['message'];
}
}
if ($pageType == 'top') {
$exist = $db->fetchRow("SELECT t.id FROM top t WHERE t.film_id=" . $_POST['film_id']);
if ($exist != false) {
$return['message'] = 'Фильм уже существует';
}
}
if (($pageType == 'comment' || $pageType == 'commentnews') && $_GET['moderate'] == '1') {
$db->query("UPDATE {$pageType} SET moderate = '0' WHERE id=" . $_GET['pages_id']);
}
// var_dump($return);die();
if (@(!$return['message'])) {
if ($update) {
if ($pageType == 'banners') {
$img_link = 'http://' . $_SERVER['SERVER_NAME'] . '/public/' . $pageType . '/' . $_GET['menu_id'] . '/' . $return['id_row'] . '/banner' . $_FILES['banner']['name'];
// var_dump($img_link);die();
$update .= ",`" . img . "`='" . $img_link . "'";
}
// if($this->flag == 1)
// {
// $sql = "UPDATE ".$pageType. " SET ".$update." WHERE id = ".$_GET['pages_id'];
// $isklucheniedb = new Core_Controller_Action_Helper_isklucheniedb();
// $isklucheniedb->iskluchenie_db($sql);
// }
// else
// var_dump($update); die();
$db->query("UPDATE " . $pageType . " SET " . $update . " WHERE id = " . $_GET['pages_id']);
}
if ($_FILES && $pageType != 'news') {
// echo '<pre>';
// var_dump($_FILES); die();
// echo '</pre>';
$storages['name'] = '';
if ($pageType == 'films') {
$storages = $db->fetchRow('select storages as name from films where id = ' . $_GET['pages_id']);
}
$AddFiles->workings_files($resize, $pageType, $return['id_row'], $storages['name']);
}
}
return @$return;
}
