You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
63 lines
1.8 KiB
63 lines
1.8 KiB
<?php
|
|
namespace app\model;
|
|
|
|
/**
|
|
* @property int id
|
|
* @property int user_id
|
|
* @property int level_type
|
|
* @property int back_type
|
|
* @property int brokerage_num
|
|
* @property int service_fee
|
|
* @property string create_time
|
|
*/
|
|
class UserBrokerageModel extends BaseModel
|
|
{
|
|
protected $name = 'user_brokerage';
|
|
protected $pk = 'id';
|
|
|
|
public static function getUserBrokerageList(array $data):array
|
|
{
|
|
$where['user_id']=$data['user_id'];
|
|
$where['level_type']=$data['level_type'];
|
|
$count=self::where($where)->count();
|
|
if($data['page']<1){
|
|
$data['page']=1;
|
|
}
|
|
if($data['page_size']<1){
|
|
$data['page_size']=10;
|
|
}
|
|
$list = self::where($where)->field('user_id,back_type,brokerage_num,service_fee,create_time')->order('id desc')->page($data['page'],$data['page_size'])->select();
|
|
if(empty($list)){
|
|
return [];
|
|
}
|
|
$order_list=$list->toArray() ;
|
|
|
|
foreach ($order_list as $key=>$val){
|
|
$res=UserModel::where('user_id',$val['user_id'])->find()->toArray();
|
|
$order_list[$key]['user_no']=$res['user_no'];
|
|
}
|
|
return [
|
|
'total'=>$count,
|
|
'list'=>$order_list,
|
|
];
|
|
|
|
}
|
|
public static function getUserBrokerageNum(array $where,string $field)
|
|
{
|
|
$num=self::where($where)->sum($field);
|
|
return $num;
|
|
}
|
|
public static function InsertUserBrokerage(array $data)
|
|
{
|
|
$self = new self;
|
|
$self->user_id = $data['user_id'];
|
|
$self->level_type = $data['level_type'];
|
|
$self->back_type = $data['back_type'];
|
|
$self->brokerage_num = $data['brokerage_num'];
|
|
$self->service_fee = $data['service_fee'];
|
|
$self->create_time = $data['create_time'];
|
|
return $self->save();
|
|
}
|
|
|
|
|
|
}
|