public function addLink($module_id, $page_id) { $mIPage = new ModulesInPages(); $mIPage->page_id = $page_id; $mIPage->module_id = $module_id; if ($mIPage->save()) { return true; } else { return false; } }
function showTree(&$data, $page_id, $role_id) { foreach ($data as $key => $value) { if ($role_id == 7 && $key != 1) { continue; } if ($page_id == $key) { $link = '<span style="color:#F15A22">' . $value['name'] . ' (' . $key . ')</span>'; } else { $link = '<a href="' . Yii::app()->request->baseUrl . '/admin.php?r=pages/update&id=' . $key . '">' . $value['name'] . '</a> (' . $key . ')'; } if ($value['active'] == '0') { $link = '<span style="color:#CCC;">' . $link . '</span>'; } if (ModulesInPages::model()->find('page_id = ' . $key)) { $link = '<b>' . $link . '</b>'; } if (count($value['child']) > 0) { echo '<li>' . $link . ' <a href="' . Yii::app()->request->baseUrl . '/admin.php?r=pages/delete&id=' . $key . '" onclick="return confirm(\'Вы действительно хотите удалить страницу ?\')"><img src=\'/admin/pics/i/del-small.png\' alt="Удалить раздел" class="deletePage"></a></li>'; echo '<ul class="lvl2">'; showTree($value['child'], $page_id, $role_id); echo '</ul>'; } else { echo '<li>' . $link . ' <a href="' . Yii::app()->request->baseUrl . '/admin.php?r=pages/delete&id=' . $key . '" onclick="return confirm(\'Вы действительно хотите удалить страницу ?\')"><img src=\'/admin/pics/i/del-small.png\' alt="Удалить раздел" class="deletePage"></a></li></li>'; } } }
public function activation($page_id = null) { if (!is_null($page_id)) { $module_id = Modules::model()->getModuleIdByCode($this->id); ModulesInPages::model()->addLink($module_id, $page_id); } }
public function create_item($page_id = null, $model) { $controller = Yii::app()->getController(); if (isset($_POST['ModuleList3'])) { $_POST['ModuleList3']['mpage_id'] = ModulesInPages::model()->getLink($page_id, $this->module_id); $model->attributes = $_POST['ModuleList3']; if ((int) $_POST['ModuleList3']['img_id']) { Files::model()->saveTempFile((int) $_POST['ModuleList3']['img_id']); } if ($model->save()) { $item_id = $model->primaryKey; // обработка input-параметров if (isset($_POST['ModuleList3Values']) && is_array($_POST['ModuleList3Values']) && count($_POST['ModuleList3Values'])) { foreach ($_POST['ModuleList3Values'] as $key => $value) { if (is_array($value) && count($value)) { foreach ($value as $key2 => $value2) { $params_value = new ModuleList3Values(); $params_value->attributes = array('param_id' => (int) $key, 'item_id' => $item_id, 'value' => $value2); $params_value->save(); } } else { $params_value = new ModuleList3Values(); $params_value->attributes = array('param_id' => (int) $key, 'item_id' => $item_id, 'value' => $value); $params_value->save(); } } } Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:green;">Добавлено</p>'); $controller->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_' . $this->module_id); } else { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:red;">Ошибка</p>'); } } }
public function actionUnlinked($link_id = 0, $page_id = 1) { $role_id = Users::model()->findByPk(Yii::app()->user->id)->role_id; if ($role_id != 7) { if ($link_id > 0) { ModulesInPages::model()->deleteLink($link_id); } $this->redirect(YII::app()->baseUrl . '/admin.php?r=pages/update&id=' . $page_id); } else { $this->redirect(Yii::app()->baseUrl . '/admin.php?r=pages/access'); } }
public function actionActivation($page_id = null) { $result = false; if (!is_null($page_id)) { $result = ModulesInPages::model()->addLink($this->module_id, $page_id); if ($result) { $this->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id); } $this->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id); } $this->redirect(Yii::app()->request->scriptUrl); }
public function deactivation($page_id = null) { $result = false; // доступно дл¤ пользователей первой роли (например, Ђ–еактивуї) $role_id = Users::model()->findByPk(Yii::app()->user->id)->role_id; if ($role_id < 2 && !is_null($page_id) && Pages::model()->existsPage($page_id)) { $link_id = ModulesInPages::model()->getLink($page_id, $this->id); if ($link_id) { $result = ModuleGallery::model()->deactivation($link_id, $this->id); } } return $result; }
protected function create_item($page_id = null, $model) { $controller = Yii::app()->getController(); if (isset($_POST['ModuleList'])) { $_POST['ModuleList']['mpage_id'] = ModulesInPages::model()->getLink($page_id, $this->module_id); $model->attributes = $_POST['ModuleList']; if ($model->save()) { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:green;">Добавлено</p>'); $controller->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_' . $this->module_id); } else { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:red;">Ошибка</p>'); } } }
public function getActiveModule($id = 0) { $id = $id == null ? 0 : $id; $data = array(); foreach ($this->findAll() as $value) { if (ModulesInPages::model()->find('page_id = ' . $id . ' and module_id = ' . $value->id)) { $data[$value->id]['id'] = $value->id; $data[$value->id]['name'] = $value->name; $data[$value->id]['code'] = $value->code; $data[$value->id]['active'] = 1; $data[$value->id]['description'] = $value->description; $data[$value->id]['link_id'] = ModulesInPages::model()->find('page_id = ' . $id . ' and module_id = ' . $value->id)->id; } } return $data; }
public function deactivation($link_id) { $result = false; $criteria = new CDbCriteria(); $criteria->select = 'id'; $criteria->condition = 'mpage_id = :id'; $criteria->params = array('id' => $link_id); foreach ($this->findAll($criteria) as $value) { $this->deleteCategory($value->id); } if ($this->count($criteria) == 0) { if (ModulesInPages::model()->deleteLink($link_id)) { $result = true; } } return $result; }
public function actionDeactivation($page_id = null) { $result = false; // доступно для пользователей первой роли (например, «Реактиву») $role_id = Users::model()->findByPk(Yii::app()->user->id)->role_id; if ($role_id < 2 && !is_null($page_id) && Pages::model()->existsPage($page_id)) { $link_id = ModulesInPages::model()->getLink($page_id, $this->module->id); if ($link_id) { $result = ModuleFieldsFiles::model()->deactivation($link_id, $this->module->id); } } if ($result) { $this->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_fourth'); } else { $this->redirect(Yii::app()->request->baseUrl . '/admin.php'); } }
public function actionIndex($page_id = null) { $role_id = Users::model()->findByPk(Yii::app()->user->id)->role_id; if ($role_id < 2 && !is_null($page_id) && Pages::model()->existsPage($page_id)) { $mpage_id = ModulesInPages::model()->getLink((int) $page_id, $this->module->id); if ($mpage_id > 0) { $model = ModuleList4Settings::model()->findByAttributes(array('mpage_id' => $mpage_id)); if (!is_null($model)) { if (isset($_POST['ModuleList4Settings'])) { $model->attributes = $_POST['ModuleList4Settings']; if ($model->save()) { Yii::app()->user->setFlash('message', '<p style="color:green;">Сохранено</p>'); $this->redirect(Yii::app()->baseUrl . '?r=' . $this->module->id . '/msettings/index&page_id=' . $page_id); } else { Yii::app()->user->setFlash('message', '<p style="color:red;">Ошибка</p>'); } } $model = ModuleList4Settings::model()->findByAttributes(array('mpage_id' => $mpage_id)); $module_settings = ModuleList4Settings::model()->getItem($mpage_id); $this->pageTitle = $module_settings->title . ' — Настройки модуля'; $this->render('index', array('model' => $model, 'module_settings' => $module_settings, 'page_id' => $page_id)); } else { $model = new ModuleList4Settings(); $model->attributes = array('mpage_id' => $mpage_id); if ($model->save()) { $this->redirect(Yii::app()->baseUrl . '?r=' . $this->module->id . '/msettings/index&page_id=' . $page_id); } else { $this->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_' . $this->module->id); } } } else { $this->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_' . $this->module->id); } } else { $this->redirect(Yii::app()->request->scriptUrl); } }
public function activation($page_id = null, $settings = array()) { if (!is_null($page_id)) { $module_id = Modules::model()->getModuleIdByCode($this->id); ModulesInPages::model()->addLink($module_id, $page_id); $link_id = ModulesInPages::model()->getLink($page_id, $this->id); $model = new ModuleList4Settings(); $settings['mpage_id'] = $link_id; $settings['title'] = Pages::model()->findByPk($page_id)->name; $model->attributes = $settings; $model->save(); } }
public function create_item($page_id = null, $model) { $controller = Yii::app()->getController(); if (isset($_POST['ModuleFiles'])) { $_POST['ModuleFiles']['mpage_id'] = ModulesInPages::model()->getLink($page_id, $this->module_id); if ((int) $_POST['ModuleFiles']['file_id']) { $file_name = Files::model()->findByPk($_POST['ModuleFiles']['file_id'])->file_name; $_POST['ModuleFiles']['link'] = '/upload/' . md5($this->module_id) . '/' . $file_name; $_POST['ModuleFiles']['extension'] = explode('.', $file_name); $_POST['ModuleFiles']['extension'] = $_POST['ModuleFiles']['extension'][count($_POST['ModuleFiles']['extension']) - 1]; $_POST['ModuleFiles']['size'] = round(filesize($_SERVER['DOCUMENT_ROOT'] . rawurldecode($_POST['ModuleFiles']['link'])) / 1024); Files::model()->saveTempFile((int) $_POST['ModuleFiles']['file_id']); } if (isset($_POST['ModuleFiles']['group_id']) && empty($_POST['ModuleFiles']['group_id'])) { $_POST['ModuleFiles']['group_id'] = NULL; } $model->attributes = $_POST['ModuleFiles']; if ($model->save()) { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:green;">Добавлено</p>'); $controller->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_' . $this->module_id); } else { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:red;">Ошибка</p>'); } } }
public function create_item($page_id = null, $model) { $controller = Yii::app()->getController(); if (isset($_POST['ModuleQuotes'])) { $_POST['ModuleQuotes']['mpage_id'] = ModulesInPages::model()->getLink($page_id, $this->module_id); foreach (array('usd_purchase', 'usd_selling', 'eur_purchase', 'eur_selling') as $value) { $_POST['ModuleQuotes'][$value] = str_replace(',', '.', $_POST['ModuleQuotes'][$value]); } $model->attributes = $_POST['ModuleQuotes']; if ($model->save()) { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:green;">Добавлено</p>'); $controller->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_' . $this->module_id); } else { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:red;">Ошибка</p>'); } } }
public function actionImport_csv($page_id = null, $id = null) { if (!is_null($page_id) && Pages::model()->existsPage($page_id)) { die; $mpage_id = ModulesInPages::model()->getLink($page_id, $this->module->id); $params = ModuleYmaps::model()->getList(3); foreach ($params as $k => $v) { $model = new ModuleList4(); $model->attributes = array('date' => date('Y-m-d'), 'title' => $v->title, 'latitude' => $v->latitude, 'longitude' => $v->longitude, 'active' => $v->active, 'order_id' => $v->order_id, 'mpage_id' => $mpage_id); $model->save(); $new_id = $model->id; // адрес if (ModuleYmapsValues::model()->existsItem(24, $v->id)) { $old_value = ModuleYmapsValues::model()->getItem(24, $v->id); $value = new ModuleList4Values(); $value->attributes = array('param_id' => 287, 'item_id' => $new_id, 'value' => $old_value->value); $value->save(); } // время раюоты if (ModuleYmapsValues::model()->existsItem(1, $v->id)) { $old_value = ModuleYmapsValues::model()->getItem(1, $v->id); $value = new ModuleList4Values(); $value->attributes = array('param_id' => 288, 'item_id' => $new_id, 'value' => $old_value->value); $value->save(); } // фото if (ModuleYmapsValues::model()->existsItem(25, $v->id)) { $old_value = ModuleYmapsValues::model()->getItem(25, $v->id); $value = new ModuleList4Values(); $value->attributes = array('param_id' => 289, 'item_id' => $new_id, 'value' => $old_value->value); $value->save(); $img_id = (int) $old_value->value; if ($img_id > 0 && Files::model()->existsFile($img_id)) { $file = Files::model()->findByPk($img_id); $file->attributes = array('module' => 'list4'); $file->save(); } } // схема if (ModuleYmapsValues::model()->existsItem(26, $v->id)) { $old_value = ModuleYmapsValues::model()->getItem(26, $v->id); $value = new ModuleList4Values(); $value->attributes = array('param_id' => 290, 'item_id' => $new_id, 'value' => $old_value->value); $value->save(); $img_id = (int) $old_value->value; if ($img_id > 0 && Files::model()->existsFile($img_id)) { $file = Files::model()->findByPk($img_id); $file->attributes = array('module' => 'list4'); $file->save(); } } } echo 'done'; /* // перенос видео // $youtube = file_get_contents('http://gdata.youtube.com/feeds/api/videos?max-results=50&alt=json&author=permopera'); $youtube = file_get_contents('http://gdata.youtube.com/feeds/api/videos?max-results=50&start-index=51&alt=json&author=permopera'); $youtube = json_decode($youtube); echo '<pre>'; print_r($youtube->feed->entry); $i = 0; foreach($youtube->feed->entry as $value){ $url = ''; foreach($value->id as $key2 => $value2){ $value2 = explode('/',$value2); $value2 = $value2[count($value2)-1]; $url = 'https://www.youtube.com/watch?v='.$value2; } // echo ', '; $date = date('Y-m-d'); foreach($value->published as $key2 => $value2){ $value2 = explode('T',$value2); $value2 = $value2[0]; $date = $value2; } // echo ', '; $title = ''; foreach($value->title as $key2 => $value2){ $title = $value2; break; } // echo ', '; $content = ''; foreach($value->content as $key2 => $value2){ $content = $value2; break; } // echo '<br>'; $criteria = new CDbCriteria(); $criteria->condition = 'mpage_id = :mpage_id AND video = :video'; $criteria->params = array('mpage_id' => 15, 'video' => $url); if(ModuleVideo::model()->count($criteria)==0){ $video = new ModuleVideo(); $video->attributes = array( 'date' => $date, 'title' => $title, 'video' => $url, 'preview' => $content, 'active' => 1, 'mpage_id' => 15 ); print_r(array( 'date' => $date, 'title' => $title, 'video' => $url, 'preview' => $content, 'active' => 1, 'mpage_id' => 15 )); $video->save(); $i++; } } echo '</pre>'; echo $i; */ die; $mpage_id = ModulesInPages::model()->getLink($page_id, $this->module->id); $host = '192.168.0.2'; $user = '******'; $pwd = ''; $db = mysql_connect($host, $user, $pwd); mysql_select_db("operaold", $db); // $spektakl_id_where_people_with_more_than_1_id = array(); $sql = "\n\t\t\t\tSELECT id, type, published, scenario, director, notes FROM ds_performances\n\t\t\t"; $sqlres = mysql_query($sql) or die("Query failed: " . $sql); while ($row = mysql_fetch_array($sqlres)) { /* // обновление данных о репертуаре $reper = ModuleList4::model()->findByAttributes(array( 'old_info_1' => $row['id'], 'mpage_id' => $mpage_id )); $id = $reper->id; if($row['published']=='n'){ $reper->attributes = array('active' => 0); $reper->save(); } $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 79, 'item_id' => $id, 'value' => iconv('cp1251', 'utf-8', $row['scenario']) ); $model->save(); $director = iconv('cp1251', 'utf-8', $row['director']); $director = explode(',', $director); foreach($director as $k => $d){ $director[$k] = trim($d); } foreach($director as $k => $d){ $people_id = array(); $criteria = new CDbCriteria(); $criteria->condition = 'title = :title'; $criteria->params = array('title' => $d); foreach(ModuleList4::model()->findAll($criteria) as $value){ $people_id[] = $value->id; } if(count($people_id)){ if(count($people_id)>1){ $spektakl_id_where_people_with_more_than_1_id[] = $id; } foreach($people_id as $value){ // сохраняем постановщика для существующих людей в БД $model = new ModuleList4List4(); $model->attributes = array( 'id_1' => $id, 'id_2' => $value ); $model->save(); } unset($director[$k]); } } if(count($director)){ $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 93, 'item_id' => $id, 'value' => implode(', ', $director) ); $model->save(); }else{ $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 93, 'item_id' => $id, 'value' => '' ); $model->save(); } $value_old = $row['type']; if($value_old>2){ $sql2 = "SELECT * FROM ds_perfom_types WHERE id = $value_old"; $sqlres2 = mysql_query($sql2) or die("Query failed: ".$sql2); while ($row2 = mysql_fetch_array($sqlres2)){ $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 101, 'item_id' => $id, 'value' => iconv('cp1251', 'utf-8', $row2['type_name']) ); $model->save(); } } */ /* // перенос афиши $mpage_id_spek = ModulesInPages::model()->getLink(50, $this->module->id); $mpage_id_afi = ModulesInPages::model()->getLink(8, $this->module->id); $mpage_id_rep = 17; $sql = " SELECT * FROM ds_playbill ORDER BY date ASC, timeb ASC "; $sqlres = mysql_query($sql) or die("Query failed: ".$sql); $spektakl_id_where_people_with_more_than_1_id = array(); while ($playbill = mysql_fetch_array($sqlres)){ $repertuar = ModuleList4::model()->findByAttributes(array( 'old_info_1' => iconv('cp1251', 'utf-8', $playbill['category_id']), 'mpage_id' => $mpage_id_rep, )); $repertuar_id = $repertuar->id; $date = new DateTime($playbill['date']); // echo $repertuar->title,' (',$date->format('d.m.Y'),' в ',$playbill['timeb'],')<br><ul>'; // сохраняем спектакль $spektakl = new ModuleList4(); $spektakl->attributes = array( 'date' => $playbill['date'], 'title' => $repertuar->title.' ('.$date->format('d.m.Y').' в '.$playbill['timeb'].')', 'old_info_1' => iconv('cp1251', 'utf-8', $playbill['id']), 'old_info_2' => iconv('cp1251', 'utf-8', $playbill['category_id']), 'old_info_3' => iconv('cp1251', 'utf-8', $playbill['page_id']), 'active' => 1, 'mpage_id' => $mpage_id_spek ); $spektakl->save(); $spektakl_id = $spektakl->id; // связь с репертуаром $model = new ModuleList4List4(); $model->attributes = array( 'id_1' => $spektakl_id, 'id_2' => $repertuar_id ); $model->save(); $sql2 = " SELECT * FROM ds_roles_playbill WHERE category_id = ".$playbill['id']." "; $sqlres2 = mysql_query($sql2) or die("Query failed: ".$sql2); $role_arr = array(); while ($role_playbill = mysql_fetch_array($sqlres2)){ $sql3 = " SELECT * FROM ds_truppa WHERE id = ".$role_playbill['actor_id']." "; $sqlres3 = mysql_query($sql3) or die("Query failed: ".$sql3); while ($actor = mysql_fetch_array($sqlres3)){ $actor_fio = trim(iconv('cp1251', 'utf-8', $actor['fio'])); if(!isset($role_arr[$actor_fio])){ $role_arr[$actor_fio] = array( 'text' => array(), 'people_id' => array() ); $criteria = new CDbCriteria(); $criteria->condition = 'title = :title'; $criteria->params = array('title' => $actor_fio); foreach(ModuleList4::model()->findAll($criteria) as $value){ $role_arr[$actor_fio]['people_id'][] = $value->id; } } } $sql3 = " SELECT * FROM ds_roles WHERE id = ".$role_playbill['rep_id']." "; $sqlres3 = mysql_query($sql3) or die("Query failed: ".$sql3); while ($role = mysql_fetch_array($sqlres3)){ $role_arr[$actor_fio]['text'][] = iconv('cp1251', 'utf-8', $role['name']); } } $others = array(); foreach($role_arr as $actor_fio => $value){ // echo '<li>',implode(', ',$value['people_id']),' : ',$actor_fio,' - ',implode(', ',$value['text']),'</li>'; if(count($value['people_id'])){ if(count($value['people_id'])>1){ $spektakl_id_where_people_with_more_than_1_id[] = $spektakl_id; } foreach($value['people_id'] as $people_id){ // сохраняем роли для существующих людей в БД $model = new ModuleList4List4(); $model->attributes = array( 'id_1' => $spektakl_id, 'id_2' => $people_id, 'text1' => implode(', ',$value['text']) ); $model->save(); } }else{ $others[] = $actor_fio.' — '.implode(', ',$value['text']); } } // сохраняем других людей $others = implode("\r\n",$others); $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 96, 'item_id' => $spektakl_id, 'value' => $others ); $model->save(); // echo '<li>',$others,'</li>'; // echo '</ul>'; // сохраняем афишу $afisha = new ModuleList4(); $afisha->attributes = array( 'date' => $playbill['date'], 'title' => $repertuar->title, 'old_info_1' => iconv('cp1251', 'utf-8', $playbill['id']), 'old_info_2' => iconv('cp1251', 'utf-8', $playbill['category_id']), 'old_info_3' => iconv('cp1251', 'utf-8', $playbill['page_id']), 'active' => 1, 'mpage_id' => $mpage_id_afi ); $afisha->save(); $afisha_id = $afisha->id; // время начала $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 86, 'item_id' => $afisha_id, 'value' => $playbill['timeb'] ); $model->save(); // время окончания $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 87, 'item_id' => $afisha_id, 'value' => $playbill['timee'] ); $model->save(); // связь со спектаклем $model = new ModuleList4List4(); $model->attributes = array( 'id_1' => $afisha_id, 'id_2' => $spektakl_id ); $model->save(); */ /* // перенос репертуара $model = new ModuleList4(); $model->attributes = array( 'date' => date('Y-m-d'), 'title' => iconv('cp1251', 'utf-8', $row['name']), 'short' => iconv('cp1251', 'utf-8', $row['desc']), 'text' => iconv('cp1251', 'utf-8', $row['notes']), 'old_info_1' => iconv('cp1251', 'utf-8', $row['id']), 'old_info_2' => iconv('cp1251', 'utf-8', $row['type']), 'old_info_3' => iconv('cp1251', 'utf-8', $row['page_id']), 'active' => 1, 'mpage_id' => $mpage_id ); $model->save(); $id = $model->id; $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 93, 'item_id' => $id, 'value' => iconv('cp1251', 'utf-8', $row['scenario'])."\r\n".iconv('cp1251', 'utf-8', $row['director']) ); $model->save(); $value_old = iconv('cp1251', 'utf-8', $row['type']); if(in_array($value_old, array(1,4,6,10,13,15))) $value = 57; elseif(in_array($value_old, array(2,7,8,9))) $value = 58; else $value = 0; if($value>0){ //тип постановки 57 опера /58 балет $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 80, 'item_id' => $id, 'value' => $value ); $model->save(); } if($value_old>2){ $sql2 = "SELECT * FROM ds_perfom_types WHERE id = $value_old"; $sqlres2 = mysql_query($sql2) or die("Query failed: ".$sql2); while ($row2 = mysql_fetch_array($sqlres2)){ $model = new ModuleList4Values(); $model->attributes = array( 'param_id' => 101, 'item_id' => $id, 'value' => $row2['type_name'] ); $model->save(); } } */ /* // перенос подписчиков $model = new ModuleList4(); $model->attributes = array( 'date' => iconv('cp1251', 'utf-8', $row['date']), 'title' => iconv('cp1251', 'utf-8', $row['tel']), 'short' => iconv('cp1251', 'utf-8', $row['fio']), 'active' => 1, 'mpage_id' => $mpage_id_sms ); $model->save(); $id_1 = $model->id; $model = new ModuleList4(); $model->attributes = array( 'date' => iconv('cp1251', 'utf-8', $row['date']), 'title' => iconv('cp1251', 'utf-8', $row['mail']), 'short' => iconv('cp1251', 'utf-8', $row['fio']), 'active' => 1, 'mpage_id' => $mpage_id_mail ); $model->save(); $id_2 = $model->id; $model = new ModuleList4List4(); $model->attributes = array( 'id_1' => $id_1, 'id_2' => $id_2 ); $model->save(); */ // $sugar_name = iconv('cp1251', 'utf-8', $row['name']); /* echo iconv('cp1251', 'utf-8', $row['fio']); echo iconv('cp1251', 'utf-8', $row['tel']); echo iconv('cp1251', 'utf-8', $row['mail']); echo iconv('cp1251', 'utf-8', $row['date']); */ } /* // перенос афиши $spektakl_id_where_people_with_more_than_1_id = array_unique($spektakl_id_where_people_with_more_than_1_id); foreach($spektakl_id_where_people_with_more_than_1_id as $id){ echo '<a href="/admin.php?r=/list4/main/update&page_id=9&id='.$id.'#!/tab_second">Репертуар ID: '.$id.'</a><br>'; } */ mysql_close(); } else { $this->redirect(Yii::app()->request->scriptUrl); } }
</div> <?php echo $form->error($model, 'title'); ?> </div> <?php if (Yii::app()->user->hasFlash($this->module->id . '_add_message')) { echo Yii::app()->user->getFlash($this->module->id . '_add_message'); } ?> <div style="display: none;"> <?php echo $form->textField($model, 'mpage_id', array('value' => ModulesInPages::model()->getLink($page_id, $this->module->id))); ?> </div> <div class="row buttons" style="margin-top: 10px;"> <?php echo CHtml::submitButton($model->isNewRecord ? 'Добавить' : 'Сохранить'); ?> </div> <?php $this->endWidget(); ?> </div> </div>
р. <i class="<?php echo $quotes_1->eur_selling > $quotes_2->eur_selling ? 'up' : ''; ?> <?php echo $quotes_1->eur_selling < $quotes_2->eur_selling ? 'down' : ''; ?> "></i></td> </tr> </table> <?php } ?> <h2>История изменений курса валют, установленных Банком</h2> <?php $quotes_mapge_id = ModulesInPages::model()->getLink(1, 'quotes'); $quotes_by_id = ModuleQuotes::model()->getList($quotes_mapge_id, 0, 31, 1); $quotes = array(); foreach ($quotes_by_id as $value) { $quotes[] = $value; } $count = count($quotes); if ($count == 31) { $count = 30; } if (count($quotes) > 0) { ?> <table> <tr> <th></th> <th>Покупка, $</th>
public function checkLinkToModule($id = null) { if (!is_null($id)) { $modInPages = new ModulesInPages(); $modLinkPage = $modInPages->getAllLinkPages(); $data = array($id => $this->findByPk($id)->name); $result = array(); $data = $this->getIdArray($id, $data); foreach ($data as $key => $value) { foreach ($modLinkPage as $key_m => $value_m) { if ($key == $key_m) { $result[$key] = $value_m; } } } if (count($result) > 0) { return $result; } else { return false; } } }
protected function moduleMfiles($data) { $pages = $data['pages']; $mpage_id = ModulesInPages::model()->getLink($data['doc_id_last'], 'mfiles'); $records_on_page = 10; // количество новостей на странице $data['group_of_files'] = 0; $data['table_of_files'] = 0; $fields_mpage_id = ModulesInPages::model()->getLink($data['doc_id_last'], 'fields'); if ($fields_mpage_id > 0) { $fields = ModuleFields::model()->getListByCode($fields_mpage_id); if (isset($fields['items_on_page']) && (int) $fields['items_on_page']->value > 0) { $records_on_page = (int) $fields['items_on_page']->value; } if (isset($fields['items_on_page']) && $fields['items_on_page']->value == '0') { $records_on_page = 0; } if (isset($fields['group_of_files'])) { $data['group_of_files'] = (int) $fields['group_of_files']->value; } if (isset($fields['table_of_files'])) { $data['table_of_files'] = (int) $fields['table_of_files']->value; } } $type = explode($pages->make_url($data['doc_id_last']), '/' . Yii::app()->request->pathInfo); $type = explode('/', $type[1]); $type = $type[0]; if (substr($type, 0, 5) == 'page_' || empty($type)) { // выбор страницы $page = 1; $lenta = new ModuleFiles(); if (!empty($type)) { $page = floor(substr($type, 5)); } if ($page < 1) { $page = 1; } $url = $pages->make_url($data['doc_id_last']) . 'page_'; $data['year'] = $lenta->get_years($mpage_id, 1); $in_years = false; $year_count = count($data['year']); $get_year = 0; if (isset($_GET['y'])) { $get_year = (int) $_GET['y']; } for ($i = 0; $i < $year_count; $i++) { if ($get_year == $data['year'][$i]->year) { $in_years = true; } } if (!$in_years) { $get_year = 0; } $data['get_year'] = $get_year; $news_count = $lenta->getCount($mpage_id, 1, $get_year); if ($records_on_page > 0) { $data['pagination'] = $this->pagination($url, $news_count, $page, $records_on_page); } $offset = ($page - 1) * $records_on_page; $limit = $records_on_page; //$data['lenta'] = $pages->getModuleNews($data['doc_id_last'],$offset,$limit); $data['page_num'] = $page; $data['list'] = ModuleFiles::model()->getList($mpage_id, $offset, $limit, 1, $get_year, $data['group_of_files']); if ($records_on_page > 0) { $data['year_pagination'] = $this->year_pagination($pages->make_url($data['doc_id_last']), $news_count, $page, $records_on_page, $data['year']); } $data['url_for_menu'] = substr(substr($data['pages']->make_url($data['doc_id_last']), 0, -1), 1); $data['records_on_page'] = $records_on_page; $this->render('mfiles', $data); } else { // неизвестный тип отображения $this->redirect($pages->make_url($data['doc_id_last'])); } }
protected function update_value_of_item($id, $file_id, $page_id) { $out = true; $data = array('file_id' => $file_id); if (!is_null($page_id) && Pages::model()->existsPage($page_id)) { $link_id = ModulesInPages::model()->getLink((int) $page_id, $this->module_id); if (!is_null($id) && ModuleFieldsFiles::model()->existsItem($link_id, $id)) { $model = ModuleFieldsFiles::model()->findByPk($id); if (isset($data)) { $old_file_id = $model->file_id; if ($data['file_id'] == 'NULL') { $data['file_id'] = ''; } if ((int) $old_file_id && (int) $old_file_id != (int) $data['file_id']) { $data['link'] = NULL; $data['extension'] = NULL; $data['size'] = 0; } if ((int) $data['file_id']) { $file_name = Files::model()->findByPk($data['file_id'])->file_name; $data['link'] = '/upload/' . md5($this->module_id) . '/' . $file_name; $data['extension'] = explode('.', $file_name); $data['extension'] = $data['extension'][count($data['extension']) - 1]; $data['size'] = round(filesize($_SERVER['DOCUMENT_ROOT'] . rawurldecode($data['link'])) / 1024); } $data['date_time'] = date('Y-m-d H:i:s'); $model->attributes = $data; if ($model->save()) { if ((int) $old_file_id && (int) $old_file_id != (int) $data['file_id']) { Files::model()->deleteFile($old_file_id, $this->module_id); } Files::model()->saveTempFile((int) $data['file_id']); } else { $out = false; } } else { $out = false; } } else { $out = false; } } else { $out = false; } return $out; }
public function create_item($page_id = null, $model) { $controller = Yii::app()->getController(); if (isset($_POST['ModuleList4'])) { $mpage_id = ModulesInPages::model()->getLink($page_id, $this->module_id); $_POST['ModuleList4']['mpage_id'] = $mpage_id; if (!isset($_POST['ModuleList4']['date'])) { $_POST['ModuleList4']['date'] = date('Y-m-d'); } $model->attributes = $_POST['ModuleList4']; if ((int) $_POST['ModuleList4']['img_id']) { Files::model()->saveTempFile((int) $_POST['ModuleList4']['img_id']); } if ($model->save()) { $item_id = $model->primaryKey; // обработка input-параметров if (isset($_POST['ModuleList4Values']) && is_array($_POST['ModuleList4Values']) && count($_POST['ModuleList4Values'])) { foreach ($_POST['ModuleList4Values'] as $key => $value) { if (is_array($value) && count($value)) { foreach ($value as $key2 => $value2) { $params_value = new ModuleList4Values(); $params_value->attributes = array('param_id' => (int) $key, 'item_id' => $item_id, 'value' => $value2); $params_value->save(); } } else { $params_value = new ModuleList4Values(); $params_value->attributes = array('param_id' => (int) $key, 'item_id' => $item_id, 'value' => $value); $params_value->save(); } } } // активация (создание) альбомов для параметров типа «Фотогалерея» $params_list = ModuleList4Params::model()->getList($mpage_id); if (count($params_list)) { foreach ($params_list as $key => $value) { if ($value['data_type_id'] == 8) { $param_id = $value['id']; $id = $item_id; $param_value = ModuleList4Values::model()->getItem($id, $param_id); if (count($param_value) == 0 || is_null(ModuleGallery::model()->findByPk((int) $param_value['value']))) { $gallery = new ModuleGallery(); $gallery->attributes = array('title' => 'list4 # param_id = ' . $param_id . ', item_id = ' . $id, 'date' => date('Y-m-d'), 'active' => 1); if ($gallery->save()) { if (count($param_value) == 0) { $model = new ModuleList4Values(); $model->attributes = array('param_id' => $param_id, 'item_id' => $id, 'value' => $gallery->primaryKey); $model->save(); } else { ModuleList4Values::model()->new_value($id, $param_id, $gallery->primaryKey); } } } } } } Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:green;">Добавлено</p>'); $controller->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_' . $this->module_id); } else { Yii::app()->user->setFlash($this->module_id . '_add_message', '<p style="color:red;">Ошибка</p>'); } } return $model; }
</span></a></li> <?php $active_class = ''; ?> <?php } ?> </ul> <img class="rose2" src="/pics/i/rose2.png"> </nav> <?php $active_class = 'active'; foreach ($t['child'] as $tch_id => $tch) { $active_modules = Modules::model()->getActiveModule($tch_id); if (count($active_modules) == 1 && array_key_exists(9, $active_modules)) { $mpage_id = ModulesInPages::model()->getLink($tch_id, 'gallery'); $gallery = ModuleGallery::model()->getListPhotos($mpage_id, 1); if (count($gallery)) { ?> <section class="gallery view <?php echo $active_class; ?> " data-gal="<?php echo $tch_id; ?> "> <div class="bigImage"> <a href="javascript:void(0)" class="cLeft"><span class="arrow"></span></a> <a href="javascript:void(0)" class="cRight"><span class="arrow"></span></a> <div class="imgC"> <?php
?> " data-view="<?php echo implode('||', $data_view); ?> ">Отправить заявку на эту квартиру</a> </div> </div> <h3 class="planHeader">Планировка</h3> <p class="planText">Вы можете посмотреть планировки соседних квартир, кликнув на маркер (подсолнух)</p> <div id="plan"> <div class="navigator"> <div class="navContainer"><a href="javascript:void(0)" class="brd"><i class="u"></i><i class="d"></i><i class="l"></i><i class="r"></i></a></div> </div> <div class="imgContainer"> <?php $mpage_id = ModulesInPages::model()->getLink($doc_id_last, 'flats'); $flats_floor = ModuleFlats::model()->getList($mpage_id, NULL, $item->floor); $left_top = array(array(array(1300, 140), array(1353, 327), array(1147, 369), array(1166, 593), array(1354, 617), array(1354, 778), array(1371, 901), array(1297, 1044), array(1411, 1155), array(1413, 1305), array(980, 1205), array(800, 1307), array(680, 1411), array(593, 1155), array(355, 1155), array(315, 1400), array(65, 1210)), array(array(1297, 125), array(1355, 177), array(1353, 335), array(1147, 369), array(1166, 610), array(1362, 586), array(1413, 761), array(1371, 925), array(1297, 1044), array(1411, 1180), array(1396, 1275), array(1339, 1455), array(1151, 1435), array(1027, 1339), array(818, 1339), array(677, 1445), array(571, 1339), array(365, 1335), array(292, 1452), array(201, 1452), array(109, 1335)), array(array(1297, 125), array(1355, 177), array(1353, 335), array(1147, 369), array(1166, 610), array(1362, 586), array(1413, 761), array(1371, 925), array(1297, 1044), array(1411, 1180), array(1396, 1275), array(1339, 1455), array(1151, 1435), array(1027, 1339), array(818, 1339), array(677, 1445), array(571, 1339), array(365, 1335), array(292, 1452), array(201, 1452), array(109, 1335))); if ($item->floor == 1) { $left_top = $left_top[0]; } elseif ($item->floor >= 2 && $item->floor <= 7) { $left_top = $left_top[1]; } else { $left_top = $left_top[2]; } $i = 0; foreach ($flats_floor as $flat) { if ($flat->floor == $item->floor) { $active = ''; if ($flat->id == $item->id) { $active = 'active';
$role_id = Users::model()->findByPk(Yii::app()->user->id)->role_id; ?> <div class="form"> <div class="tabs"> <!-- Это сами вкладки --> <ul class="cf tabNavigation"> <?php if (!$model->isNewRecord && count($active) > 0) { ?> <?php foreach ($active as $value) { ?> <?php if ($value['code'] == 'list4') { $page_id = $model->id; $mpage_id = ModulesInPages::model()->getLink($page_id, $value['code']); $module_settings = ModuleList4Settings::model()->getItem($mpage_id); if (!is_null($module_settings)) { $title = $module_settings->title; } else { $title = $value['name']; } } else { $title = $value['name']; } ?> <?php if ($role_id == 7 && $value['code'] != 'quotes') { continue; } ?>
/** * Активация модуля * @param integer $page_id ID страницы */ public function actionActivation($page_id = 0) { $page_id = (int) $page_id; // доступно для пользователей первой роли (например, «Реактиву») $role_id = Users::model()->findByPk(Yii::app()->user->id)->role_id; if ($role_id < 2 && $page_id > 0) { ModulesInPages::model()->addLink($this->module_id, $page_id); } if ($page_id > 0) { $this->redirect(Yii::app()->baseUrl . '?r=pages/update&id=' . $page_id . '&/#!/tab_fourth'); } else { $this->redirect(Yii::app()->request->baseUrl . '/admin.php'); } }
public function actionDelete_value($page_id = null, $param_id = null, $id = null) { if (!is_null($page_id) && Pages::model()->existsPage($page_id)) { $mpage_id = ModulesInPages::model()->getLink((int) $page_id, $this->module->id); if ($mpage_id == 5) { $mpage_id = 4; } if ($mpage_id == 54) { $mpage_id = 4; } if ($mpage_id == 56) { $mpage_id = 4; } if ($mpage_id == 58) { $mpage_id = 4; } if (ModuleList3Params::model()->existsItem($mpage_id, $param_id) && ModuleList3ParamsValues::model()->deleteItem($param_id, $id)) { Yii::app()->user->setFlash($this->module->id . '_delete_message', '<p style="color:green;">Удалено</p>'); } else { Yii::app()->user->setFlash($this->module->id . '_delete_message', '<p style="color:red;">Ошибка удаления</p>'); } $this->redirect(Yii::app()->baseUrl . '?r=' . $this->module->id . '/params/update&page_id=' . $page_id . '&id=' . $param_id); } else { $this->redirect(Yii::app()->request->scriptUrl); } }
echo CHtml::submitButton($model->isNewRecord ? 'Создать' : 'Сохранить'); ?> </div> <?php if (Yii::app()->user->hasFlash($this->module_id . '_add_message')) { echo Yii::app()->user->getFlash($this->module_id . '_add_message'); } ?> <?php $this->endWidget(); ?> </div> </div> <div class="catalog"> <?php $mpage_id = ModulesInPages::model()->getLink($page_id, $this->module_id); $data = ModuleList3::model()->getList($mpage_id); if (count($data) > 0) { ?> <h3>Список</h3> <ul class="<?php echo count($data) > 1 ? 'sortable' : ''; ?> type_1"> <?php foreach ($data as $item_id => $item) { ?> <li data-id="<?php echo $item->id; ?> " class="link ids">
<div class="edit_line"> <?php echo $form->labelEx($model, 'title'); ?> <div class="inpC"> <?php echo $form->textField($model, 'title', array('class' => 'inp', 'size' => 60, 'maxlength' => 255)); ?> </div> <?php echo $form->error($model, 'title'); ?> </div> <?php $list4_mpage_id = ModulesInPages::model()->getLink($page_id, 'list4'); if ($list4_mpage_id > 0) { $ModuleList4 = ModuleList4::model()->getList($list4_mpage_id); if (count($ModuleList4)) { $dropdown = array(0 => 'Без группы'); foreach ($ModuleList4 as $k => $v) { $dropdown[$k] = $v->title; } ?> <div class="edit_line"> <?php echo $form->labelEx($model, 'group_id'); ?> <div class="inpC"> <?php