Yii2.0 - 聚集函数
1 <?php 2 3 # 数据计算 4 $num=$model->find()->groupBy(['supplier_code','warehouse_code'])->where($map)->count(); 5 6 //获取运费 7 $pay_ship_amount = PurchaseOrderShip::find()->select('sum(freight)')->where(['pur_number'=>Yii::$app->request->post()['ast'][0]])->scalar(); 8 //统计金额 9 $price = PurchaseOrderItems::find()->select('items_totalprice')->where(['pur_number'=>Yii::$app->request->post()['ast'][0]])->asArray()->all(); 10 PurchaseOrderItems::find()->where(['pur_number'=>Yii::$app->request->post()['PurchaseOrderPay']['po_code']])->sum('items_totalprice') 11 --------------------------------------- 12 $sql="select `platform`, `sku`, `warehouse` , `sdate`, sum(`qty`) from `pur_platform_orders` where `sdate`='".$ntime."' group by `sku`, `platform`, `warehouse`"; 13 $countsales=Yii::$app->db->createCommand($sql)->queryAll(); 14 -------------------------------------------------------- 15 16 $price = ArrayHelper::getColumn($price,'items_totalprice'); 17 $price = array_sum($price); 18 19 ---------------------- 20 //?? 21 //$where=['and', 'audit_return=2',['!=','purchase_type','3'],['=','purchas_status','2']]; 22 //$where2=['and', 'audit_return=2',['!=','purchase_type','3'],['=','purchas_status','3']]; 23 24 //$leadsum=$countreview->where($where)->andWhere(['review_status'=>'0'])->count('id'); 25 //$supervissum=$countreview->where($where2)->andWhere(['review_status'=>'1'])->count('id'); 26 27 ========================================== 28 #数据库命令 29 #查看表结构 30 DESC table_name; 31 32 #修改字段名 33 ALTER TABLE 表名 CHANGE 旧字段 新字段 数据类型; //ALTER TABLE table_name CHANGE old_field new_field VARCHAR(30); 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 ==================================== 49 public function rules() 50 { 51 return [ 52 [['title','content'], 'required'], 53 [['id','bulletin_board_type'], 'integer'], 54 [['content','create_id'], 'string'], 55 [['create_time', 'update_time'], 'safe'], 56 [['title'], 'string', 'max' => 100], 57 [['create_id'], 'default', 'value' => Yii::$app->user->identity->username], 58 [['create_time'], 'default', 'value' => date('Y-m-d H:i:s',time())], 59 ]; 60 }
<?php
# 数据计算$num=$model->find()->groupBy(['supplier_code','warehouse_code'])->where($map)->count();
//获取运费$pay_ship_amount = PurchaseOrderShip::find()->select('sum(freight)')->where(['pur_number'=>Yii::$app->request->post()['ast'][0]])->scalar();//统计金额$price = PurchaseOrderItems::find()->select('items_totalprice')->where(['pur_number'=>Yii::$app->request->post()['ast'][0]])->asArray()->all();PurchaseOrderItems::find()->where(['pur_number'=>Yii::$app->request->post()['PurchaseOrderPay']['po_code']])->sum('items_totalprice')---------------------------------------$sql="select `platform`, `sku`, `warehouse` , `sdate`, sum(`qty`) from `pur_platform_orders` where `sdate`='".$ntime."' group by `sku`, `platform`, `warehouse`";$countsales=Yii::$app->db->createCommand($sql)->queryAll();--------------------------------------------------------
$price = ArrayHelper::getColumn($price,'items_totalprice');$price = array_sum($price);
----------------------//??//$where=['and', 'audit_return=2',['!=','purchase_type','3'],['=','purchas_status','2']];//$where2=['and', 'audit_return=2',['!=','purchase_type','3'],['=','purchas_status','3']];
//$leadsum=$countreview->where($where)->andWhere(['review_status'=>'0'])->count('id');//$supervissum=$countreview->where($where2)->andWhere(['review_status'=>'1'])->count('id');==========================================#数据库命令#查看表结构DESC table_name;
#修改字段名ALTER TABLE 表名 CHANGE 旧字段 新字段 数据类型; //ALTER TABLE table_name CHANGE old_field new_field VARCHAR(30);====================================public function rules(){return [[['title','content'], 'required'],[['id','bulletin_board_type'], 'integer'],[['content','create_id'], 'string'],[['create_time', 'update_time'], 'safe'],[['title'], 'string', 'max' => 100],[['create_id'], 'default', 'value' => Yii::$app->user->identity->username],[['create_time'], 'default', 'value' => date('Y-m-d H:i:s',time())],];}