kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = :tableName AND kcu.table_name = :tableName SQL; try { $rows = $this->db->createCommand($sql, [':tableName' => $table->name])->queryAll(); $constraints = []; foreach ($rows as $row) { $constraints[$row['constraint_name']]['referenced_table_name'] = $row['referenced_table_name']; $constraints[$row['constraint_name']]['columns'][$row['column_name']] = $row['referenced_column_name']; } $table->foreignKeys = []; foreach ($constraints as $constraint) { $table->foreignKeys[] = array_merge( [$constraint['referenced_table_name']], $constraint['columns'] ); }
SQL; try { $rows = $this->db->createCommand($sql, [':tableName' => $table->name])->queryAll(); $constraints = []; foreach ($rows as $row) { $constraints[$row['constraint_name']]['referenced_table_name'] = $row['referenced_table_name']; $constraints[$row['constraint_name']]['columns'][$row['column_name']] = $row['referenced_column_name']; } $table->foreignKeys = []; foreach ($constraints as $constraint) { $table->foreignKeys[] = array_merge( [$constraint['referenced_table_name']],
protected function loadTableSchema($name) { $table = new TableSchema; $this->resolveTableNames($table, $name); if ($this->findColumns($table)) { $this->findConstraints($table); return $table; } else { return null; } }
} return $this->_tables[$name]; } } return $this->_tables[$name] = $this->loadTableSchema($realName); } /** * Returns the cache key for the specified table name. * @param string $name the table name * @return mixed the cache key
* @throws InvalidConfigException if the table for the AR class does not exist. */ public static function getTableSchema() { $schema = static::getDb() ->getSchema() ->getTableSchema(static::tableName()); if ($schema === null) { throw new InvalidConfigException('The table does not exist: ' . static::tableName()); } return $schema;
/** * @inheritdoc */ public static function populateRecord($record, $row) { $columns = static::getTableSchema()->columns; foreach ($row as $name => $value) { if (isset($columns[$name])) { $row[$name] = $columns[$name]->phpTypecast($value); } } parent::populateRecord($record, $row);
/* @var $class ActiveRecord */ $class = $this->modelClass; if ($this->indexBy === null) { foreach ($rows as $row) { $model = $class::instantiate($row); $modelClass = get_class($model); $modelClass::populateRecord($model, $row); $models[] = $model; } } else { foreach ($rows as $row) { $model = $class::instantiate($row); $modelClass = get_class($model);
public function populate($rows) { if (empty($rows)) { return []; } $models = $this->createModels($rows); if (!empty($this->join) && $this->indexBy === null) { $models = $this->removeDuplicatedModels($models); } if (!empty($this->with)) { $this->findWith($this->with, $models); }
* If this parameter is not given, the `db` application component will be used. * @return array the query results. If the query results in nothing, an empty array will be returned. */ public function all($db = null) { $rows = $this->createCommand($db)->queryAll(); return $this->populate($rows); } /** * Converts the raw query results into the format as specified by this query. * This method is internally used to convert the data fetched from database * into the format as required by this query.
* @param Connection $db the DB connection used to create the DB command. * If null, the DB connection returned by [[modelClass]] will be used. * @return array|ActiveRecord[] the query results. If the query results in nothing, an empty array will be returned. */ public function all($db = null) { return parent::all($db); } /** * @inheritdoc */ public function prepare($builder)
} public static function getListItemAboutus() { $cat = Category::findOne(1); $order = $cat->order_by.' '.$cat->order_type; $datas = Item::find()->where('category_id = 1 and actived = 1')->orderBy($order)->all(); return $datas; } public static function getListItem($id = null,$limit=100,$condition =[]) { $cat = Category::findOne($id);
} $cPersonnal = Personnel::find()->where(['actived' => 1])->count(); if ($cPersonnal > 0) { array_push($other, ['name' => Yii::t('app', 'Staff'), 'url' => Yii::$app->getUrlManager()->getBaseUrl() . '/about-us/staff', 'type' => 'full']); } $items = Item::getListItemAboutus(); // @Return $object foreach ($items as $value_items) { $tmp_itemp = []; $tmp_itemp['created_date'] = $value_items->created_date;
} public static function _navMenu() { $where = "nav-menu"; $res = ""; $content = Theme::getLayoutsValue($where); $model = new self(); if (is_array($content)) { foreach ($content as $value) { if (count($value['items']) != 0) { $count = count($value['items']); if ($count > 0) {
<div id="navbar" class="navbar-collapse collapse"> <ul class="nav navbar-nav main_nav"> <li class="active"> <a href="<?= Url::to(['/']) ?>"><span class="fa fa-home desktop-home "></span> <span class="mobile-show">หน้าแรก</span></a> </li> <?= Feed::_navMenu() ?> </div> </nav> <?php echo $this->render('_breadcrumbs') ?> </section>
*/ public function renderPhpFile($_file_, $_params_ = []) { ob_start(); ob_implicit_flush(false); extract($_params_, EXTR_OVERWRITE); require($_file_); return ob_get_clean(); } /** * Renders dynamic content returned by the given PHP statements.
$this->renderers[$ext] = Yii::createObject($this->renderers[$ext]); } /* @var $renderer ViewRenderer */ $renderer = $this->renderers[$ext]; $output = $renderer->render($this, $viewFile, $params); } else { $output = $this->renderPhpFile($viewFile, $params); } $this->afterRender($viewFile, $params, $output); } array_pop($this->_viewFiles); $this->context = $oldContext;
* @throws InvalidParamException if the view cannot be resolved or the view file does not exist. * @see renderFile() */ public function render($view, $params = [], $context = null) { $viewFile = $this->findViewFile($view, $context); return $this->renderFile($viewFile, $params, $context); } /** * Finds the view file based on the given view name. * @param string $view the view name or the path alias of the view file. Please refer to [[render()]] * on how to specify this parameter.
<div id="status"> </div> </div>--> <!--<a class="scrollToTop" href="#"><i class="fa fa-angle-up"></i></a>--> <div class="container"> <?php $this->beginBody() ?> <?= $this->render('_header.php') ?> <?= $content ?> <?= $this->render('_footer.php') ?>
*/ public function renderPhpFile($_file_, $_params_ = []) { ob_start(); ob_implicit_flush(false); extract($_params_, EXTR_OVERWRITE); require($_file_); return ob_get_clean(); } /** * Renders dynamic content returned by the given PHP statements.
$this->renderers[$ext] = Yii::createObject($this->renderers[$ext]); } /* @var $renderer ViewRenderer */ $renderer = $this->renderers[$ext]; $output = $renderer->render($this, $viewFile, $params); } else { $output = $this->renderPhpFile($viewFile, $params); } $this->afterRender($viewFile, $params, $output); } array_pop($this->_viewFiles); $this->context = $oldContext;
* @since 2.0.1 */ public function renderContent($content) { $layoutFile = $this->findLayoutFile($this->getView()); if ($layoutFile !== false) { return $this->getView()->renderFile($layoutFile, ['content' => $content], $this); } else { return $content; } } /**
* @return string the rendering result. * @throws InvalidParamException if the view file or the layout file does not exist. */ public function render($view, $params = []) { $content = $this->getView()->render($view, $params, $this); return $this->renderContent($content); } /** * Renders a static string by applying a layout. * @param string $content the static string being rendered * @return string the rendering result of the layout with the given static string as the `$content` variable.
Yii::$app->session->setFlash('error', Yii::t('app', 'There was an error sending email.')); } return $this->refresh(); } else { return $this->render('contact', [ 'model' => $model, ]); } } public function actionPage($id, $title = null) {
$args = $this->controller->bindActionParams($this, $params); Yii::trace('Running action: ' . get_class($this->controller) . '::' . $this->actionMethod . '()', __METHOD__); if (Yii::$app->requestedParams === null) { Yii::$app->requestedParams = $args; } return call_user_func_array([$this->controller, $this->actionMethod], $args); } }
} $result = null; if ($runAction && $this->beforeAction($action)) { // run the action $result = $action->runWithParams($params); $result = $this->afterAction($action, $result); // call afterAction on modules foreach ($modules as $module) { /* @var $module Module */
$parts = $this->createController($route); if (is_array($parts)) { /* @var $controller Controller */ list($controller, $actionID) = $parts; $oldController = Yii::$app->controller; Yii::$app->controller = $controller; $result = $controller->runAction($actionID, $params); Yii::$app->controller = $oldController; return $result; } else { $id = $this->getUniqueId(); throw new InvalidRouteException('Unable to resolve the request "' . ($id === '' ? $route : $id . '/' . $route) . '".');
$params = $this->catchAll; unset($params[0]); } try { Yii::trace("Route requested: '$route'", __METHOD__); $this->requestedRoute = $route; $result = $this->runAction($route, $params); if ($result instanceof Response) { return $result; } else { $response = $this->getResponse(); if ($result !== null) { $response->data = $result;
try { $this->state = self::STATE_BEFORE_REQUEST; $this->trigger(self::EVENT_BEFORE_REQUEST); $this->state = self::STATE_HANDLING_REQUEST; $response = $this->handleRequest($this->getRequest()); $this->state = self::STATE_AFTER_REQUEST; $this->trigger(self::EVENT_AFTER_REQUEST); $this->state = self::STATE_SENDING_RESPONSE; $response->send();
require(__DIR__ . '/common/config/main-local.php'), require(__DIR__ . '/frontend/config/main.php'), require(__DIR__ . '/frontend/config/main-local.php') ); $application = new yii\web\Application($config); $application->run();
$_SESSION = [ '__flash' => [], '__captcha/site/captcha' => 'zxkixaj', '__captcha/site/captchacount' => 1, ];