<?php
|
|
namespace app\agent\model;
|
|
use app\common\model\agent\Store as StoreModel;
|
|
/**
|
* 超管后台门店模型
|
*/
|
class Store extends StoreModel
|
{
|
/**
|
* 获取全部
|
*/
|
public static function getAll()
|
{
|
$model = new static;
|
$agent_id=self::$agent_id;
|
|
$data = $model->with('agent')->where('agent_id', '=', $agent_id)->where('is_delete', '=', 0)->select();
|
$data->each(function($item,$key){
|
$item['expire_status'] = is_expire_status($item['end_date']);
|
$item['status_name'] = status($item['status']);
|
$item['date_value'] = [$item['register_date'],$item['end_date']];
|
|
$item['month_register'] = 0;
|
});
|
return $data;
|
}
|
/**
|
* 搜索指定数据--搜索
|
*/
|
public static function search($data)
|
{
|
$agent_id=self::$agent_id;
|
$model = new static;
|
|
$list = $model->where('is_delete', '=', 0)->where('agent_id', '=', $agent_id)
|
->where('store_name', 'like', '%'.$data[0].'%')
|
->where('store_type', 'like', '%'.$data[1].'%')
|
->where('status', 'like', '%'.$data[2].'%')
|
->where('store_app_name', 'like', '%'.$data[4].'%')
|
->select();
|
|
$list->each(function($item,$key){
|
$item['expire_status'] = is_expire_status($item['end_date']);
|
$item['status_name'] = status($item['status']);
|
$item['date_value'] = [$item['register_date'],$item['end_date']];
|
|
$item['month_register'] = '预留';
|
});
|
return $list;
|
}
|
/**
|
* 获取头部数据
|
*/
|
public static function gethead()
|
{
|
$agent_id=self::$agent_id;
|
$model = new static;
|
$newtime = strtotime(Date('Y-m-d'));//当日零点时间戳
|
$yetime = $newtime - 86400;//strtotime(date('Y-m-d',strtotime('-1 day')))
|
|
$list = $model->where('is_delete','=',0)->where('agent_id', '=', $agent_id)->select();//总数
|
$list2 = $model->where('is_delete','=',0)->where('agent_id', '=', $agent_id)->where('status','=',1)->select();//通过总数
|
$list3 = $model->where('is_delete','=',0)->where('agent_id', '=', $agent_id)
|
->where('create_time','<=',$newtime)
|
->where('create_time','>=',$yetime)
|
->select();//昨日新增总数
|
$list4 = $model->where('is_delete','=',0)->where('agent_id', '=', $agent_id)->where('end_date','<',date('Y-m-d H:i:s'))->select();//通过总数
|
|
$data = [];
|
$data[] = count($list);//总数
|
$data[] = count($list2);//正常使用总数
|
//$data[] = $date;
|
$data[] = count($list3);//昨日新增总数
|
$data[] = count($list4);//已过期总数
|
|
return $data;
|
}
|
|
|
/**
|
* 获取当前门店总数
|
*/
|
public function getStoreTotal($agent_id,$day = null)
|
{
|
$model = $this;
|
if (!is_null($day)) {
|
$startTime = strtotime($day);
|
$model = $model->where('create_time', '>=', $startTime)
|
->where('create_time', '<', $startTime + 86400);
|
}
|
return $model->where('agent_id', '=', $agent_id)->where('is_delete', '=', '0')->count();
|
}
|
|
/**
|
* 新增
|
*/
|
public function add($data)
|
{
|
$data['agent_id']=self::$agent_id;
|
return $this->save($data);
|
}
|
|
|
/**
|
* 软删除
|
*/
|
public function setDelete()
|
{
|
return $this->save(['is_delete' => 1]);
|
}
|
|
/**
|
* 更新记录
|
*/
|
public function edit($data)
|
{
|
return $this->save($data);
|
}
|
|
}
|
