当前位置: 首页>>代码示例>>PHP>>正文


PHP User::findBySql方法代码示例

本文整理汇总了PHP中common\models\User::findBySql方法的典型用法代码示例。如果您正苦于以下问题:PHP User::findBySql方法的具体用法?PHP User::findBySql怎么用?PHP User::findBySql使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在common\models\User的用法示例。


在下文中一共展示了User::findBySql方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: actionCreate

 /**
  * Creates a new Ruta model.
  * If creation is successful, the browser will be redirected to the 'view' page.
  * @return mixed
  */
 public function actionCreate()
 {
     $model = new Ruta();
     if ($model->load(Yii::$app->request->post()) && $model->save()) {
         return $this->redirect(['view', 'id' => $model->id]);
     } else {
         $connection = \Yii::$app->db;
         $sql = 'SELECT * FROM user WHERE id in (Select user_id FROM auth_assignment WHERE item_name = "relevador")';
         $modelo = \common\models\User::findBySql($sql)->all();
         $dataUsuarios = ArrayHelper::map($modelo, 'id', 'username');
         $rutarel = new RutaRelevador();
         return $this->render('create', ['model' => $model, 'users' => $dataUsuarios, 'rutarel' => $rutarel]);
     }
 }
开发者ID:no7kpo,项目名称:denm,代码行数:19,代码来源:RutaController.php

示例2: actionView

 public function actionView($id)
 {
     $sql = "SELECT u.id, u.username, u.email, u.status, u.full_name, u.business_name, u.phone_number, u.business_address, u.status, s.store_name as store_name FROM `user` u join user_store us on us.user_id = u.id join store s on s.store_id = us.store_id";
     return $this->render('view', ['model' => User::findBySql($sql)->one()]);
 }
开发者ID:syedmaaz,项目名称:marxmall-,代码行数:5,代码来源:StoreOwnerController.php

示例3:

/* @var $this yii\web\View */
/* @var $model backend\modules\user\models\ActivityHistorySearch */
/* @var $form yii\widgets\ActiveForm */
?>

<div class="activity-history-search">

    <?php 
$form = ActiveForm::begin(['action' => ['log'], 'method' => 'get']);
?>

    <?php 
if (Yii::$app->user->usermode != 'developer') {
    $dataSql = User::findBySql('SELECT DISTINCT username FROM user WHERE usermode !="developer"')->asArray()->all();
} else {
    $dataSql = User::findBySql('SELECT DISTINCT username FROM user')->asArray()->all();
}
foreach ($dataSql as $row) {
    $CT_IDS[] = $row['username'];
}
?>

    <?php 
echo $form->field($model, 'username')->widget(TypeaheadBasic::classname(), ['data' => $CT_IDS, 'pluginOptions' => ['highlight' => true], 'options' => ['placeholder' => 'All']]);
?>
    <?php 
echo $form->field($model, 'start_date', ['addon' => ['prepend' => ['content' => '<i class="glyphicon glyphicon-calendar"></i>']], 'options' => ['class' => 'drp-container form-group', 'readonly' => 'readonly']])->widget(DateRangePicker::classname(), ['useWithAddon' => true, 'convertFormat' => true, 'pluginOptions' => ['locale' => ['format' => 'Y-m-d']]]);
?>
    
     
    <div class="form-group">
开发者ID:budipratama,项目名称:admin_lte,代码行数:31,代码来源:_search_log.php


注:本文中的common\models\User::findBySql方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。