yii框架模型操作

命令行自动生成model模型类

php yii gii/model --ns=app\\modules\\v1\\models --tableName=SCM_tbInvBalance_new --modelClass=SCMTbInvBalanceNew

1、relation使用方法 
``` 
CategoryController： 

/** 
* @ hasMany 关系 
*/
public function actionGetproduct(){ 
$modelCategory = new Category(); 
$category = $modelCategory::find()->where(['cid'=>1])->one(); 
$product = $category->getProduct()->andWhere('status=1')->all(); 
var_dump($product); 
}

Category(Model): 

public function getProduct(){ 
return $this->hasMany(Product::className(), array('cid'=>'cid')); 
} 

``` 

2、Yii2.0 数据库查询 
``` 
User::find()->all(); 此方法返回所有数据； 

User::findOne($id); 此方法返回 主键 id=1 的一条数据(举个例子)； 

User::find()->where(['name' => '小伙儿'])->one(); 此方法返回 ['name' => '小伙儿'] 的一条数据； 

User::find()->where(['name' => '小伙儿'])->all(); 此方法返回 ['name' => '小伙儿'] 的所有数据； 

User::find()->orderBy('id DESC')->all(); 此方法是排序查询； 

User::findBySql('SELECT * FROM user')->all(); 此方法是用 sql 语句查询 user 表里面的所有数据； 

User::findBySql('SELECT * FROM user')->one(); 此方法是用 sql 语句查询 user 表里面的一条数据； 

User::find()->andWhere(['sex' => '男', 'age' => '24'])->count('id'); 统计符合条件的总条数； 

User::find()->andFilterWhere(['like', 'name', '小伙儿']); 此方法是用 like 查询 name 等于 小伙儿的 数据 

User::find()->one(); 此方法返回一条数据； 

User::find()->all(); 此方法返回所有数据； 

User::find()->count(); 此方法返回记录的数量； 

User::find()->average(); 此方法返回指定列的平均值； 

User::find()->min(); 此方法返回指定列的最小值 ； 

User::find()->max(); 此方法返回指定列的最大值 ； 

User::find()->scalar(); 此方法返回值的第一行第一列的查询结果； 

User::find()->column(); 此方法返回查询结果中的第一列的值； 

User::find()->exists(); 此方法返回一个值指示是否包含查询结果的数据行； 

User::find()->batch(10); 每次取 10 条数据 

User::find()->each(10); 每次取 10 条数据， 迭代查询 
查

$userModel = 'app\modules\v1\models\Tbuser';
$user = $userModel::find('fsShopGUID', 'fsUserId')->where(['fsUserId' => $userName, 'fsShopGUID' => $fsShopGUID])->asArray()->one()//查询获取一条记录
$userAll = $userModel::find('fsShopGUID', 'fsUserId')->where(['fsUserId' => $userName, 'fsShopGUID' => $fsShopGUID])->asArray()->all()//查询获取所有满足条件的记录

 

新增 
$connection->createCommand()->insert('SCM_tbParamValue', [ 'fsParamId' => $account_code, 'fsParamValue' => $set_status, 'fiStatus' => 1, 'fsCreateUserId' => $this->user['fsUserId'], 'fsCreateTime' => date('Y-m-d H:i:s'), 'fsCreateUserName' => $this->user['fsUserName'], 'fsShopGUID' => $this->user['fsShopGUID'],])->execute(); 
批量新增
 $connection->createCommand()->batchInsert('SCM_tbInvBalance', ['fsYYMM', "fsStorageId", 'fsMaterialId', "fsMaterialName", "fsModelno", "fsUnitId", "fiStatus", "fdBeginQty", "fdBeginBal","fdEndQty", "fdEndBal", "fsCreateTime", "fsCreateUserId", "fsCreateUserName", "fsShopGUID","fdBeginCost","fdEndCost"], $InvBalance )->execute(); 
更新
 $modify = [ 'fsParamValue' => $set_status, 'fsUpdateTime' => date('Y-m-d H:i:s'), 'fsUpdateUserId' => $this->user['fsUserId'], 'fsUpdateUserName' => $this->user['fsUserName'] ]; 
$connection->createCommand()->update('SCM_tbParamValue', $modify, '"fsParamId"=:fsParamId and "fsShopGUID"=:fsShopGUID', [':fsParamId' => $query['fsParamId'], ':fsShopGUID' => $this->user['fsShopGUID']])->execute(); 
删除 
$connection->createCommand()->delete('SCM_tbInvBalance', '"fsShopGUID" = \'' . $this->user['fsShopGUID'] . '\'')->execute();