YII2.0實戰開發小結

2019-11-11 04:50:47

字體：大中小

來源：轉載

供稿：網友

1、$applycar = Applycar::find()->where('{{%applycar}}.complete = 1')->joinWith('car')->joinWith('driver')->asArray()->orderBy('{{%applycar}}.id DESC');如上聯合中joinWith('driver')中的driver來自models/Applycar.php中public function getDriver() {return $this->hasOne(Adminer::className(), ['uid' => 'drid']);} public function getCar() {return $this->hasOne(Car::className(), ['id' => 'cid']);}Adminer表中的uid跟Applaycar表中drid相關聯 $param = array();if ($param['drname'] = trim($request->get('drname'))) {$applycar->andWhere('{{%adminer}}.truename = "'.$param['drname'].'"');}if ($param['carnumber'] = trim($request->get('carnumber'))) {$applycar->andWhere('{{%car}}.license = "'.$param['carnumber'].'"');}如上：{{%adminer}}指的是表ol_adminer，ol是表前綴car同上$applycar->andWhere用andWhere來連接條件語句if(!empty($param)){//定義獲取總公里數$totalkm = $applycar->sum('usekm');//定義獲取總加班小時$totalhour = $applycar->sum('overtime');//用sum方法來統計總數：參數為列名}//定義列表查詢 $applycar = $applycar->all();$typeArr = array('0'=>'司機','1'=>'自駕');foreach($applycar as $akey => &$aval){$aval['driver'] = Adminer::findOne($aval['drid']);}Adminer::findOne根據參數查詢一條語句 return $this->render('record',[ 'applycar' => $applycar,'typeArr' => $typeArr,'totalkm' => $totalkm,'totalhour' => $totalhour,'param' => $param, ]);render第一個參數是views下面的record.phpAjaxdelapplycar() {必須加前綴action訪問的時候是ajaxdelapplycar3、頁面跳轉的執行return $this->runAction('login');跳轉到login頁面4、數據的接收 $request = Yii::$app->request;//用對象的形式$applycar = Applycar::findOne($request->post('apid'));$applycar->usekm = $request->post('usekm');$applycar->overtime = $request->post('overtime');$applycar->complete = 1;$applycar->comptime = time();$result = $applycar->save();//保存更新都是save()5、新建控制器放在Controller下所有操作都在Controller下執行即可所有的models下面對應的Applycar.php實體化的表文件里面一般寫一些驗證聯合查詢等等views就是我們要存儲的模板文件以CarsController為例views下面對應的模板文件為cars/文件名對應的render中的第一個參數6、YII引入CSS和JS文件之公共文件路徑assets/AppAsset.php7、把變量傳遞給頁面，頁面結果作為content變量傳遞給布局文件 $this->render contoller控制器之間跳轉的方法$this->redirect return $this->render('index');//跳轉到當前控制器默認的方法 return $this->redirect(array('/cars/dispatch')); //跳轉到cars控制器的dispatch方法8、YII原生SQL語句//查詢 $connection = Yii::$app->db;$sql = "..."; $command = $connection->createCommand($sql); $result = $command->queryAll(); //更新、刪除$upsql = "..."; $command_update = $connection->createCommand($upsql); $result_update = $command_update->execute(); if($result_update){ ...}else{ ...} 9、YII模板原生SQL查詢 <?phpuse yii/helpers/Html;use yii/bootstrap/ActiveForm;$this->layout = 'XX管理';$this->position = 'XXXX';//查詢$result= (new /yii/db/Query())->select(['id' , 'email'])->from('user')->where(['mid' => $member['id']]) ->limit(10) ->all(); //->one();解析為：SELECT `id`, `email` FROM `user` WHERE `mid` = :mid LIMIT 10 ?>

上一篇：494. Target Sum

下一篇：File類常用方法