/** * tries to create a new view */ public function testCreate() { $viewObj = View::model()->findByPk(array('TABLE_SCHEMA' => 'viewtest', 'TABLE_NAME' => 'view1')); $createView = $viewObj->getCreateView(); $this->assertType('string', $createView); $this->assertType('string', $viewObj->delete()); $cmd = View::$db->createCommand($createView); $this->assertEquals(0, $cmd->execute()); $viewObj = View::model()->findByPk(array('TABLE_SCHEMA' => 'viewtest', 'TABLE_NAME' => 'view1')); $this->assertType('View', $viewObj); }
public function actionDelete() { if (isset($_POST['img'])) { $model = View::model()->findByAttributes(array('uid' => Yii::app()->user->id, 'photo' => $_POST['img'])); if (is_object($model)) { if ($model->delete()) { return true; } } else { return false; } } else { echo 'false'; } }
public function preFilter($filter_chain) { if (is_null($this->model_id)) { throw new CException('Required model_id attribute!'); } if (!Yii::app()->user->isGuest && ($id = Yii::app()->request->getParam('id'))) { $attributes = array('user_id' => Yii::app()->user->id, 'object_id' => $id, 'model_id' => $this->model_id); $exist = View::model()->existsByAttributes($attributes); if (!$exist) { $view = new View(); $view->attributes = $attributes; if (!$view->save()) { throw new CException("Can't save views"); } } } return true; }
<?php $this->widget('application.extensions.tooltipster.tooltipster', array('identifier' => '#show_tooltip', 'options' => array('position' => 'bottom'))); foreach ($model as $item) { $c = StudioHals::model()->findByPk($item->portfolio_id); if ($c->picture == $item->file) { $chk = 'checked'; } else { $chk = ''; } $top = View::model()->findByAttributes(array('uid' => Yii::app()->user->id, 'photo' => $item->file)); if (is_object($top)) { if ($top->photo == $item->file) { $class = 'cabinet__photo__item-selected'; $del = 'yes'; } else { $class = 'cabinet__photo__item-select'; $del = 'no'; } } else { $class = 'cabinet__photo__item-select'; $del = 'no'; } ?> <div class="data_<?php echo $item->id; ?> "> <figure class="cabinet__photo__item2"> <a href="/users/<?php echo Yii::app()->user->id;
<?php } else { ?> <a href="/id<?php echo $data->id; ?> /prices">Стоимость услуг</a> <?php } ?> </div> <div class="clfx"></div> <?php $top = View::model()->countByAttributes(array('uid' => $data->id)); if ($top >= 4) { $top = View::model()->findAllBySql('select * from {{view}} where uid=' . $data->id . ' ORDER BY RAND() limit 4'); $i = 1; foreach ($top as $file) { $img = $file->photo; $link_data = Files::model()->findBySql('select id, portfolio_id from {{files}} where uid=' . $data->id . ' and type="photo" and source="portfolio" and visible=1 and file="' . $img . '"'); $img_link = $this->createUrl('/user/album', array('id' => $link_data->portfolio_id)) . '?photo=photo' . $link_data->id; if ($i == 4) { if ($file->photo != '') { //echo '<a href="/id'.$data->id.'" class="cat-photo-img__link last"><img class="cat-photo-img" src="/users/'.$data->id.'/370_'.$img.'" alt="'.$data->name.' - '.Occupation::getName($data->occupation_id).'"></a>'; echo '<a href="' . $img_link . '" class="cat-photo-img__link last"><img class="cat-photo-img" src="/users/' . $data->id . '/370_' . $img . '" alt="' . $data->name . ' - ' . Occupation::getName($data->occupation_id) . '"></a>'; } else { echo '<a href="/id' . $data->id . '" class="cat-photo-img__link last"><img class="cat-photo-img" src="/img/zaglushka.png" alt="' . $data->name . ' - ' . Occupation::getName($data->occupation_id) . '"></a>'; } } else { if ($file->photo != '') { //echo '<a href="/id'.$data->id.'" class="cat-photo-img__link"><img class="cat-photo-img" src="/users/'.$data->id.'/370_'.$img.'" alt="'.$data->name.' - '.Occupation::getName($data->occupation_id).'"></a>';
public function actionVKatagorys($pk) { $Katagory = Katagory::model()->findByPk($pk); $Views = View::model()->findAll(); $Menus = Menu::model()->findAll(); if (isset($_POST['Katagory'])) { $Katagory->attributes = $_POST['Katagory']; if ($Katagory->save()) { $this->redirect(array('vkatagorys', 'pk' => $Katagory->id_katagory)); } } $this->render('vkatagorys', array('Katagory' => $Katagory, 'Views' => $Views, 'Menus' => $Menus)); }
/** * Exports all views of the given array and writes the dump to the output buffer. * * @param array list of views */ private function exportViews($views) { // Get DbConnection object $db = Yii::app()->db; // Escape all view names $viewNames = array(); foreach ($views as $view) { $viewNames[] = Yii::app()->db->quoteValue($view); } // Find all views $views = View::model()->findAll('TABLE_NAME IN (' . implode(',', $viewNames) . ') ' . 'AND TABLE_SCHEMA = ' . Yii::app()->db->quoteValue($this->schema)); foreach ($views as $view) { $this->comment('View ' . $db->quoteTableName($view->TABLE_NAME)); echo "\n\n"; // Structure if ($this->settings['addDropObject']) { echo 'DROP VIEW IF EXISTS ', $db->quoteTableName($view->TABLE_NAME), ";\n"; } echo $view->getCreateView(), ";\n\n"; } }
/** * Loads the current view. * * @return View */ public function loadView() { if (is_null($this->_view)) { $pk = array('TABLE_SCHEMA' => $this->schema, 'TABLE_NAME' => $this->view); $this->_view = View::model()->findByPk($pk); $this->_view->columns = Column::model()->findAllByAttributes($pk); if (is_null($this->_view)) { throw new CHttpException(500, 'The requested view does not exist.'); } } return $this->_view; }
/** * Lists all views. */ public function actionViews() { $schema = $this->loadSchema(); // Criteria $criteria = new CDbCriteria(); $criteria->condition = 'TABLE_SCHEMA = :schema'; $criteria->params = array(':schema' => $this->schema); if ($this->request->getParam('sideBar')) { $views = array(); foreach (View::model()->findAll($criteria) as $view) { $views[] = array('viewName' => $view->TABLE_NAME); } $this->sendJSON($views); } else { // Pagination $pages = new Pagination(View::model()->count($criteria)); $pages->setupPageSize('pageSize', 'schema.views'); $pages->applyLimit($criteria); $pages->route = '#views'; // Sort $sort = new CSort('View'); $sort->attributes = array('name' => 'TABLE_NAME', 'updatable' => 'IS_UPDATABLE'); $sort->route = '#views'; $sort->applyOrder($criteria); // Load data $schema->views = View::model()->findAll($criteria); // Render $this->render('views', array('schema' => $schema, 'viewCount' => count($schema->views), 'pages' => $pages, 'sort' => $sort)); } }
/** * Loads the current table. * * @return Table */ public function loadTable() { if (is_null($this->_table) && !is_null($this->table)) { $pk = array('TABLE_SCHEMA' => $this->schema, 'TABLE_NAME' => $this->table); $this->_table = Table::model()->findByPk($pk); if ($this->_table->TABLE_TYPE == "VIEW") { $this->_table = View::model()->findByPk($pk); } $this->_table->columns = Column::model()->findAllByAttributes($pk); if (is_null($this->_table)) { throw new CHttpException(500, 'The requested table does not exist.'); } } return $this->_table; }
<main class="cabinet__portfolio"> <header class="cabinet__portfolio__title clfx"> <div class="col-4 albom-name"><a href="/my/video">все альбомы</a></div> <div class="col-4"><h3><?php echo $model->title; ?> </h3></div> <div class="col-4 albom-edit"><!--i></i><a href="/my/portfolio/update/id/<?php echo $model->id; ?> ">Редактировать альбом</a--></div> </header> <div class="col-9 cabinet__portfolio__select4-photo"> <?php $top = View::model()->countByAttributes(array('uid' => Yii::app()->user->id)); if ($top < 4) { ?> <a href="#">Выберите любые 4-е фотографии из любых альбомов для главной страницы</a> <?php } ?> </div> <div class="col-3 cabinet__portfolio__add-photo cabinet__portfolio__add-photo"> <div class="col-12 global__plus__btn-container"> <a href="#" class="global__plus__btn add_video" data-toggle="modal" data-target="#__accaunt_video"><i></i><span>Добавить видео</span></a> <div class="modal fade" id="__accaunt_video" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content" style="text-align: center;">
} }); </script> </figure> <?php } elseif ($str['host'] == 'vimeo.com') { if (isset($path[3])) { $code = $path[3]; } else { $code = $path[1]; } if ($xml = simplexml_load_file('http://vimeo.com/api/v2/video/' . $code . '.xml')) { //$image = $xml->video->thumbnail_large ? (string) $xml->video->thumbnail_large: (string) $xml->video->thumbnail_medium; $image = $xml->video->thumbnail_medium; } $top = View::model()->findByAttributes(array('uid' => Yii::app()->user->id, 'photo' => 'video_' . $code . '.jpg')); if (is_object($top)) { if ($top->photo == 'video_' . $code . '.jpg') { $class = 'cabinet__video__item-selected'; $del = 'yes'; } else { $class = 'cabinet__photo__item-select'; $del = 'no'; } } else { $class = 'cabinet__video__item-select'; $del = 'no'; } ?> <figure class="cabinet__video__item data_<?php echo $data->id;
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return View the loaded model * @throws CHttpException */ public function loadModel($id) { $model = View::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function actionVisible($id) { $m = $this->loadModel($id); if ($m->uid == Yii::app()->user->id) { if ($m->visible == 1) { $m->visible = 0; View::model()->deleteAllByAttributes(array('uid' => $m->uid, 'photo' => $m->file)); $cover = Portfolio::model()->findBySql('select id from {{portfolio}} where uid=:uid and picture=:pic', array('uid' => $m->uid, 'pic' => $m->file)); Portfolio::model()->updateByPk($cover->id, array('picture' => '')); } elseif ($m->visible == 0) { $m->visible = 1; } if ($m->save()) { $this->redirect($_GET['back']); } } else { throw new CHttpException(404, 'The requested album does not exist.'); } }