作为自己的周总结,平时遇到的问题,以及一不小心踩的坑,记录下来自己当复习:
public function rules()
{
return [
[['card_id', 'card_code'],
function ($attribute, $param) {
//两个参数中至少需要一个
if (empty($this->card_code) && empty($this->card_id)) {
$this->addError($attribute, 'card_id/card_code至少要填一个');
}
},
'skipOnEmpty' => false],
];
}
public function rules()
{
return [[title', 'content'],'trim']];
}
public function rules()
{
return [
...
[['user_id'], 'exist',
'targetClass' => User::className(),
'targetAttribute' => 'id',
'message' => '此{attribute}不存在。'
],
...
];
}
[['store_id', 'member_name'], 'unique', 'targetAttribute' => ['store_id', 'member_name'], 'message' => 'The combination of Store ID and Member Name has already been taken.'],
echo array_values($model->getFirstErrors())[0];exit;
var_dump($model->getErrors());die;
新建一个Behavior
use Yii;
use yii\base\Behavior;
use yii\web\Controller;
class NoCsrf extends Behavior
{
public $actions = [];
public $controller;
public function events()
{
return [Controller::EVENT_BEFORE_ACTION => 'beforeAction'];
}
public function beforeAction($event)
{
$action = $event->action->id;
if(in_array($action, $this->actions)){
$this->controller->enableCsrfValidation = false;
}
}
}
然后在Controller中添加Behavior
public function behaviors()
{
return [
'csrf' => [
'class' => NoCsrf::className(),
'controller' => $this,
'actions' => [
'action-name'
]
]
];
}
User::find()->where(['and', ['xxx' => 0, 'yyy' => 2], ['>', 'zzz', $time]]);
Topic::updateAll(
['last_comment_time' => new Expression('created_at')],
#['or', ['type' => Topic::TYPE, 'last_comment_username' => ''], ['type' => Topic::TYPE, 'last_comment_username' => null]]
['and', ['type' => Topic::TYPE], ['or', ['last_comment_username' => ''], ['last_comment_username' => null]]]
);
$subQuery = new Query();
$subQuery->from(PostComment::tableName())->where(['status' => PostComment::STATUS_ACTIVE])->orderBy(['created_at' => SORT_DESC]);
$comment = PostComment::find()->from(['tmpA' => $subQuery])
->groupBy('post_id')
->all();
生成的语句是
SELECT * FROM (SELECT * FROM `post_comment` WHERE `status`=1 ORDER BY `created_at` DESC) `tmpA` GROUP BY `post_id`
$query = static::find()
->select(['package_uuid', 'count(*) AS count', 'cost', 'package_shop_id'])
->groupBy('package_uuid');
->orderBy('count DESC')
->limit(10);
$quert = User::find()
->select([
new Expression('count(*) as count , count(distinct mobile) as mnumber')
])->asArray()
->all();
['like', 'name', 'tester'] 会生成 name LIKE '%tester%'。
['like', 'name', '%tester', false] => name LIKE '%tester'
$query = User::find()
->where(['LIKE', 'name', $id.'%', false]);
$query = new Query;
$query->select('ID, City,State,StudentName')
->from('student')
->where(['IsActive' => 1])
->andWhere(['not', ['State' => null]])
->orderBy(['rand()' => SORT_DESC])
->limit(10);
#想在where条件里加上c.type=b.type怎么加?
$res =self::find()
->select(['a.id','a.name'])
->join('LEFT JOIN','b','b.qid=a.id')
->join('LEFT JOIN','c','c.uid=b.uid')
->where(['a.state'=>0, 'b.state'=>0, 'c.state'=>0, 'c.uid'=>123456])
->asArray()->all();
#方法:
$query->andWhere(new \yii\db\Expression('c.type = b.type'));
$query->andWhere(['<', '`updated_at` + `duration`', time()])->all();
$query = Weibo::find()->joinWith('account')->where([
'and',
['is_forward' => 0],
['status' => Weibo::STATUS_NORMAL_WITH_STAT],
['account_open_id' => $account_list],
['read_limit_time' => null],
])->andWhere("`posted_at` BETWEEN {$now}-`account`.`scrape_time`*60 AND {$now}-`account`.`scrape_time`*60+60");
$commandQuery = clone $query;
// 输出SQL语句
echo $commandQuery->createCommand()->getRawSql();
$weibo = $query->all();
输出语句:
SELECT `weibo`.* FROM `weibo`
LEFT JOIN `account`
ON `weibo`.`account_open_id` = `account`.`open_id`
WHERE ((`is_forward`=0)
AND (`status`=1)
AND (`account_open_id` IN ('123456789', '987654321', '098765432', '234123455'))
AND (`read_limit_time` IS NULL))
AND (`posted_at` BETWEEN 1474946053-`account`.`scrape_time`*60 AND 1474946053-`account`.`scrape_time`*60+60)
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$dataProvider->query->andWhere(['pid' => 0]);
User::find()
->where(new Expression('FIND_IN_SET(:status, status)'))
->addParams([':status' => 1])
->all();
原因:yii 对数据表结构进行了缓存。
方法1. 清理掉runtime下的cache缓存之后也可以正常使用这个字段。
方法2. 修改完表字段后执行
# 清理指定表结构缓存数据
Yii::$app->db->getSchema()->refreshTableSchema($tableName);
或
# 清理所有表结构缓存数据
Yii::$app->db->getSchema()->refresh();
static::find()
->where([
'user_id' => $user_id,
])
->groupBy('uuid')
->all();
static::find()
->select(['uuid'])
->where([
'user_id' => $user_id,
])
->distinct()
->count();
static::find()->where([
'user_id' => $user_id,
])->count('distinct uuid');
$transaction = Yii::$app->db->beginTransaction();
try {
//... SQL executions
$transaction->commit();
} catch (Exception $e) {
$transaction->rollBack();
}
关于事务:
Yii::$app->db->transaction(function() {
$order = new Order($customer);
$order->save();
$order->addItems($items);
});
// 这相当于下列冗长的代码:
$transaction = Yii::$app->db->beginTransaction();
try {
$order = new Order($customer);
$order->save();
$order->addItems($items);
$transaction->commit();
} catch (\Exception $e) {
$transaction->rollBack();
throw $e;
}
// AuthItem.php 关键是 onCondition 方法
public function getAuthTimes()
{
return $this->hasOne(AuthTimes::className(), ['name' => 'name', ])->onCondition([AuthTimes::tableName() . '.type' => 1]);
}
// AuthTimes.php 文件
// ......
AuthItem::find()->joinWith('authTimes')->where([self::tableName() . '.name' => null])->all();
生成SQL:
SELECT `auth_item`.* FROM `auth_item` LEFT JOIN `auth_times` ON `auth_item`.`name` = `auth_times`.`name` AND `auth_times`.`type` = 1 WHERE `auth_times`.`name` IS NULL
$styleId = Yii::$app->request->get('style');
$collection = Yii::$app->db->cache(function($db) use($styleId){
return Collection::findOne(['style_id'=>$styleId]);
}, self::SECONDS_IN_MINITUE * 10);
$model = new User();
foreach($data as $attributes)
{
$_model = clone $model;
$_model->setAttributes($attributes);
$_model->save();
}
第二种方法
$model = new User();
foreach($data as $attributes)
{
$model->isNewRecord = true;
$model->setAttributes($attributes);
$model->save() && $model->id = 0;
}
假设我们当前页面的访问地址是:http://localhost/public/index...
# http://localhost
Yii::$app->request->getHostInfo()
Yii::$app->request->getPathInfo()
# /public/index.php?r=news&id=1
Yii::$app->request->url
或者
Yii::$app->request->requestUri
Yii::$app->request->getHostInfo() . Yii::app()->request->url
# r=news&id=1
Yii::$app->getRequest()->queryString
Yii::$app->getRequest()->getQuery('id'); //get parameter 'id'
# /public/index.php
Yii::$app->user->returnUrl;
Yii::$app->request->headers['Referer']
或者
Yii::$app->getRequest()->getReferrer()
当GridView和DetailView列表中的某一条内容为连续的英文或数字(比如网站链接等)时,该内容会不换行,导致该列宽度被顶的特别长,甚至超出div的宽度。
在全局Css中添加以下样式:
word-break:break-all; //只对英文起作用,以字母作为换行依据
eg:
html,
body {
height: 100%;
font-family: "Microsoft YaHei";
word-break: break-all;
}
css:
div.required label:after {
content: " *";
color: red;
}
#在控制器里面使用
$this->module->id;
$this->id;
$this->action->id;
#其他位置使用
\Yii::$app->controller->module->id;
\Yii::$app->controller->id;
\Yii::$app->controller->action->id;
use yii\log\Logger;
\Yii::getLogger()->log('User has been created', Logger::LEVEL_INFO);
\Yii::$app->request->rawBody;
方式一:
return \yii\helpers\ArrayHelper::getColumn(User::find()->all(), 'name');
方式二:
return User::find()->select('name')->asArray()->column();
use yii\helpers\Html;
use yii\helpers\HtmlPurifier;
echo Html::encode($view_hello_str) //可以原样显示<script></script>代码
echo HtmlPurifier::process($view_hello_str) //可以过滤掉<script></script>代码
// 引用命名空间
use yii\helpers\VarDumper;
// 使用
VarDumper::dump($var);
// 使用2 第二个参数是数组的深度 第三个参数是是否显示代码高亮(默认不显示)
VarDumper::dump($var, 10 ,true);die;
// post
Yii::$app->request->bodyParams
// get
Yii::$app->request->queryParams;
Html::a("链接1", \yii\helpers\Url::toRoute(['product/view', 'id' => 42]);
Html::a("链接2", Yii::$app->urlManager->createUrl(['mysql/chart', 'id' => 43,'time_interval' => '1800', 'end'=>'0']));
Yii::$app->runAction('new_controller/new_action', $params);
// 或者
return (new SecondController('second', Yii::$app->module))->runAction('index', $data);
public function actionDownload($id)
{
$model = $this->findModel($id);
if ($model) {
// do something
}
return \Yii::$app->response->setDownloadHeaders($model->downurl);
}
'mailer' => [
'class' => 'yii\swiftmailer\Mailer',
'useFileTransport' => false,
'transport' => [
'class' => 'Swift_SmtpTransport',
'host' => 'smtp.gmail.com',
'username' => 'admin@gmail.com',
'password' => 'password12345678',
'port' => 587,//or 25/587
'encryption' => 'tls',//tls or ssl
]
],
b.使用
Yii::$app->mailer->compose()
->setFrom(['admin@gmail.com' => Yii::$app->name])
->setTo('admin@gmail.com')
->setSubject('test subject')
->setTextBody('test body')
->send();
'user' => [
'class'=>'yii\web\User',
'identityClass' => 'common\models\User',
'loginUrl'=>['/user/sign-in/login'],
'authTimeout' => 1800,//登陆有效时间
'as afterLogin' => 'common\behaviors\LoginTimestampBehavior'
],
$result = array('code' => $code, 'msg' => $msg, 'data' => $data);
$callback = Yii::$app->request->get('callback',null);
$format = $callback ? Response::FORMAT_JSONP : Response::FORMAT_JSON;
Yii::$app->response->format = $format;
if($callback){
return array(
'callback' => $callback,
'data' => $result
);
}
return $result;
需求: 头像url需要通过域名http://b.com/作为基本url
目标: 提高代码复用
此处http://b.com/可以做成一个配置
示例:
User.php
class User extends \yii\db\ActiveRecord
{
...
public function extraFields()
{
$fields = parent::extraFields();
$fields['avatar_url'] = function () {
return empty($this->avatar_path) ? '可以设置一个默认的头像地址' : 'http://b.com/' . $this->avatar_path;
};
return $fields;
}
...
}
ExampleController.php
class ExampleController extends \yii\web\Controller
{
public function actionIndex()
{
$userModel = User::find()->one();
$userData = $userModel->toArray([], ['avatar_url']);
echo $userData['avatar_url']; // 输出内容: http://b.com/头像路径
}
}
要在订单(Order)视图的gridview中显示出客户(Customer)姓名,并使其具有与其它字段相同的排序和搜索功能。
数据库结构 订单表order含有字段customer_id 与 客户表customer的id字段关联
首先确保在Order Model中包含以下代码:
public function getCustomer()
{
return $this->hasOne(Customer::className(), ['id' => 'customer_id']);
}
用gii会自动生成此代码;
第一步: 在OrderSearch添加一个$customer_name变量
class OrderSearch extends Order
{
public $customer_name; //<=====就是加在这里
}
第二步: 修改OrderSearch中的search函数
public function search($params)
{
$query = Order::find();
$query->joinWith(['customer']);<=====加入这句
$dataProvider = new ActiveDataProvider([
'query' => $query,
]);
$dataProvider->setSort([
'attributes' => [
/* 其它字段不要动 */
/* 下面这段是加入的 */
/*=============*/
'customer_name' => [
'asc' => ['customer.customer_name' => SORT_ASC],
'desc' => ['customer.customer_name' => SORT_DESC],
'label' => 'Customer Name'
],
/*=============*/
]
]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere([
'id' => $this->id,
'user_id' => $this->user_id,
'customer_id' => $this->customer_id,
'order_time' => $this->order_time,
'pay_time' => $this->pay_time,
]);
$query->andFilterWhere(['like', 'status', $this->status]);
$query->andFilterWhere(['like', 'customer.customer_name', $this->customer_name]) ;//<=====加入这句
return $dataProvider;
}
第三步: 修改order/index视图的gridview
<?= GridView::widget([
'dataProvider' => $dataProvider,
'filterModel' => $searchModel,
'columns' => [
['class' => 'yii\grid\SerialColumn'],
'id',
'customer_id',
'status',
['label'=>'客户', 'attribute' => 'customer_name', 'value' => 'customer.customer_name' ],//<=====加入这句
['class' => 'yii\grid\ActionColumn'],
],
]); ?>
[
'attribute' => 'source',
'format' => 'raw',
'value' => function ($model) {
return '<pre>' . Json::encode(Json::decode($model->source), JSON_UNESCAPED_UNICODE|JSON_PRETTY_PRINT) . '</pre>';
}
],