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
