<?php
|
|
namespace app\agent\model;
|
|
use app\agent\model\page\Page as PageModel;
|
use app\common\model\agent\Client as ClientModel;
|
|
class Client extends ClientModel
|
{
|
/**
|
* 获取小程序列表
|
*/
|
public function getList($limit, $is_recycle = false)
|
{
|
$agent_id=self::$agent_id;
|
return $this->alias('client')->field(['client.*,agent.agent_name'])->where('client.is_recycle', '=', (int)$is_recycle)
|
->join('dl_agent agent', 'agent.agent_id = client.agent_id','left')
|
->with(['app','shopuser','role','roleaccess'])
|
->where('client.agent_id', '=', $agent_id)
|
->where('client.is_delete', '=', 0)
|
->order(['client.create_time' => 'asc'])
|
->paginate($limit);
|
}
|
|
/**
|
* 新增记录
|
*/
|
public function add($data)
|
{
|
$this->startTrans();
|
try {
|
// 添加小程序记录
|
$data['agent_id']=self::$agent_id;
|
$this->save($data);
|
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
|
/**
|
* 修改记录
|
*/
|
public function edit($data)
|
{
|
$this->startTrans();
|
try {
|
$save_data = [
|
'client_name' => $data['client_name'],
|
'company' => $data['company'],
|
'mark_manager' => $data['mark_manager'],
|
'handrate_wx'=>$data['handrate_wx'],
|
'commissionrate_wx' => $data['commissionrate_wx']
|
];
|
$this->save($save_data);
|
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
/**
|
* 移入移出回收站
|
*/
|
public function recycle($is_recycle = true)
|
{
|
return $this->save(['is_recycle' => (int)$is_recycle]);
|
}
|
|
/**
|
* 软删除
|
*/
|
public function setDelete()
|
{
|
return $this->save(['is_delete' => 1]);
|
}
|
|
//获取客户总数
|
public function getClinetTotal($agent_id){
|
$list = $this->where('agent_id','=',$agent_id)->where('is_delete', '=', 0)->select();
|
//dd($agent_id);
|
return count($list);
|
}
|
//获取客户今日昨日新增1634279501
|
public function getClinetByDay($agent_id){
|
$arr = [];
|
$today = strtotime(date('Y-m-d'));
|
|
$tday = $this->where('agent_id','=',$agent_id)
|
->where('is_delete', '=', 0)
|
->where('create_time', '>=', $today)
|
->select();
|
|
$ytd = $this->where('agent_id','=',$agent_id)
|
->where('is_delete', '=', 0)
|
->where('create_time', '<', $today)
|
->where('create_time', '>=', $today - 86400)
|
->select();
|
|
$arr['tday'] = number_format(count($tday));
|
$arr['ytd'] = number_format(count($ytd));
|
return $arr;
|
}
|
|
}
|
