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.
54 lines
1.6 KiB
54 lines
1.6 KiB
2 months ago
|
<?php
|
||
|
|
namespace app\model;
|
||
|
|
/**
|
||
|
|
* @property int id
|
||
|
|
* @property int user_id
|
||
|
|
* @property int stock_id
|
||
|
|
* @property float change_type
|
||
|
|
* @property float change_num
|
||
|
|
* @property float before_num
|
||
|
|
* @property string create_time
|
||
|
|
* @property string update_time
|
||
|
|
* @property string order_id
|
||
|
|
*/
|
||
|
|
class UserStockHkdLogModel extends BaseModel
|
||
|
|
{
|
||
|
|
protected $name = 'user_stock_hkd_log';
|
||
|
|
protected $pk = 'id';
|
||
|
|
public static function getUserBalanceLog(array $data):array
|
||
|
|
{
|
||
|
|
$where['user_id']=$data['user_id'];
|
||
|
|
$where['stock_id']='HKD';
|
||
|
|
$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('change_type,stock_id as name,change_num,create_time,order_id')->order('id desc')->page($data['page'],$data['page_size'])->select();
|
||
|
|
if(empty($list)){
|
||
|
|
return [];
|
||
|
|
}
|
||
|
|
return [
|
||
|
|
'total'=>$count,
|
||
|
|
'list'=>$list->toArray(),
|
||
|
|
];
|
||
|
|
}
|
||
|
|
public static function InsertUserBalanceLog(array $data)
|
||
|
|
{
|
||
|
|
$self = new self;
|
||
|
|
$self->user_id = $data['user_id'];
|
||
|
|
$self->stock_id = $data['stock_id'];
|
||
|
|
$self->change_type = $data['change_type'];
|
||
|
|
$self->change_num = $data['change_num'];
|
||
|
|
if(isset($data['order_id'])){
|
||
|
|
$self->order_id = $data['order_id'];
|
||
|
|
}
|
||
|
|
$self->before_num = $data['before_num'];
|
||
|
|
$self->create_time = date('Y-m-d H:i:s');
|
||
|
|
$self->update_time = date('Y-m-d H:i:s');
|
||
|
|
return $self->save();
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|