<?php
|
|
namespace app\operations\model\branch;
|
|
use app\common\model\branch\Branch as BranchModel;
|
use app\common\model\branch\User as BranchUserModel;
|
use app\common\model\user\User as UserModel;
|
|
/**
|
* 后台管理员登录模型
|
*/
|
class Branch extends BranchModel
|
{
|
/**
|
* 获取列表数据
|
*/
|
public function getList($params)
|
{
|
$model = $this;
|
if (isset($params['search']) && $params['search']) {
|
$model = $model->where('name', 'like', '%' . $params['search'] . '%');
|
}
|
if(isset($params['branch_ids'])&&$params['branch_ids']){
|
$model = $model->where('branch_id', 'in', $params['branch_ids']);
|
}
|
if(isset($params['is_takeout']) && $params['is_takeout'] > -1){
|
$model = $model->where('is_takeout', '=', $params['is_takeout']);
|
}
|
// 查询列表数据
|
return $model->with(['superUser'])
|
->where('is_delete', '=', '0')
|
->order(['sort' => 'desc', 'create_time' => 'desc'])
|
->paginate($params);
|
}
|
|
/**
|
* 获取列表数据
|
*/
|
public static function getAll($params = [])
|
{
|
$model = new static();
|
if (!empty($params['branch_type'])) {
|
$model = $model->where('branch_type', '=', $params['branch_type']);
|
}
|
// 查询列表数据
|
return $model->field(['branch_id,name'])->where('is_delete', '=', '0')
|
->order(['create_time' => 'desc'])
|
->select();
|
}
|
|
/**
|
* 添加
|
*/
|
public function add($data)
|
{
|
// 开启事务
|
$this->startTrans();
|
try {
|
$branch = $data['branch'];
|
if (BranchModel::checkExist($branch['name'])) {
|
$this->error = '分会名称已存在，请更换';
|
return false;
|
}
|
if (BranchUserModel::checkExist($branch['user_name'])) {
|
$this->error = '登录账号已存在，请更换';
|
return false;
|
}
|
// $branch = $this->createData($branch);
|
// 添加分会
|
$branch['app_id'] = self::$app_id;
|
$this->save($branch);
|
// 添加登录用户
|
$user_model = new BranchUserModel();
|
$user_model->save([
|
'user_id' => $branch['user_id'],
|
'user_name' => $branch['user_name'],
|
'password' => salt_hash($branch['password']),
|
'real_name' => $branch['link_name'],
|
'branch_id' => $this['branch_id'],
|
'is_super' => 1,
|
'app_id' => self::$app_id,
|
]);
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
|
/**
|
* 创建数据
|
*/
|
private function createData($data)
|
{
|
$data['app_id'] = self::$app_id;
|
|
return $data;
|
}
|
|
/**
|
* 修改
|
*/
|
public function edit($data)
|
{
|
// 开启事务
|
$this->startTrans();
|
try {
|
$branch = $data['branch'];
|
if ($this['superUser'] && $branch['user_name'] != $this['superUser']['user_name'] && BranchUserModel::checkExist($branch['user_name'])) {
|
$this->error = '登录账号已存在';
|
return false;
|
}
|
|
// 修改分会
|
$this->save($branch);
|
|
// 修改登录用户
|
$user_model = $this['superUser'];
|
$user_data = [
|
'user_id' => $branch['user_id'],
|
'user_name' => $branch['user_name']
|
];
|
if (isset($branch['password']) && !empty($branch['password'])) {
|
$user_data['password'] = salt_hash($branch['password']);
|
}
|
$user_model->save($user_data);
|
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
|
/**
|
* 软删除
|
*/
|
public function setDelete()
|
{
|
return $this->save(['is_delete' => 1]);
|
}
|
/**
|
* 开启禁止
|
*/
|
public function setRecycle($is_recycle)
|
{
|
// 开启事务
|
$this->startTrans();
|
try {
|
//更改分会状态
|
$this->save(['is_recycle' => $is_recycle]);
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
|
|
}
|
|
/**
|
* 提现驳回：解冻资金
|
*/
|
public static function backFreezeMoney($branch_id, $money)
|
{
|
$model = self::detail($branch_id);
|
return $model->save([
|
'money' => $model['money'] + $money,
|
'freeze_money' => $model['freeze_money'] - $money,
|
]);
|
}
|
|
/**
|
* 提现打款成功：累积提现金额
|
*/
|
public static function totalMoney($branch_id, $money)
|
{
|
$model = self::detail($branch_id);
|
return $model->save([
|
'freeze_money' => $model['freeze_money'] - $money,
|
'cash_money' => $model['cash_money'] + $money,
|
]);
|
}
|
/**
|
* 获取分会数量
|
*/
|
public static function getTotal($where)
|
{
|
$model = new static;
|
return $model->where($where)->count();
|
}
|
|
/**
|
* 获取分会总数量
|
*/
|
public static function getBranchTotalByDay($day)
|
{
|
$startTime = strtotime($day);
|
return (new static())->where('create_time', '>=', $startTime)
|
->where('create_time', '<', $startTime + 86400)
|
->count();
|
}
|
|
/**
|
* 获取分会统计数量
|
*/
|
public function getBranchData($startDate = null, $endDate = null, $type)
|
{
|
$model = $this;
|
if(!is_null($startDate)){
|
$model = $model->where('create_time', '>=', strtotime($startDate));
|
}
|
if(is_null($endDate)){
|
$model = $model->where('create_time', '<', strtotime($startDate) + 86400);
|
}else{
|
$model = $model->where('create_time', '<', strtotime($endDate) + 86400);
|
}
|
if($type == 'branch_total' || $type == 'branch_add'){
|
return $model->count();
|
}
|
return 0;
|
}
|
|
/**
|
* 获取平台的总销售额
|
*/
|
public function getTotalMoney($type = 'total_money',$postData=[])
|
{
|
$model = $this;
|
if(!empty($postData["branch_name"])){
|
//获取商户id
|
$branch_id = BranchModel::getBranchIdByName($postData['branch_name']);
|
$model = $model->where('branch_id', '=', $branch_id);
|
}
|
if($type == 'total'){
|
return $model->sum('total_money');
|
} else if($type == 'money'){
|
return $model->sum('money');
|
} else if($type == 'freeze_money'){
|
return $model->sum('freeze_money');
|
} else if($type == 'cash_money'){
|
return $model->sum('cash_money');
|
} else if($type == 'deposit_money'){
|
return $model->sum('deposit_money');
|
}
|
return 0;
|
}
|
|
//判断用户是否申请
|
public function isApply($user_id)
|
{
|
return $this->where('user_id', '=', $user_id)->where('status', '=', 0)->count();
|
}
|
|
/**
|
* 获取列表数据
|
*/
|
public function getStatisticsList($params,$is_page = true)
|
{
|
$model = $this;
|
if (isset($params['search']) && $params['search']) {
|
$model = $model->where('name', 'like', '%' . $params['search'] . '%');
|
}
|
|
//搜索时间段
|
$create_time = empty($params['create_time']) ? 0 : $params['create_time'];
|
$model = $model->field("branch_id,name")
|
->where('is_delete', '=', '0')
|
->order(['create_time' => 'desc']);
|
|
// 查询列表数据
|
if($is_page){
|
$list = $model->paginate($params);
|
foreach ($list->toArray()["data"] as $key => $value) {
|
$list[$key]["coupon_money"] = orderModel::getCouponMoneyByBranch($value["branch_id"],$create_time);
|
$list[$key]["coupon_num"] = orderModel::getCouponNumByBranch($value["branch_id"],$create_time);
|
$list[$key]["store_coupon_money"] = StoreCouponModel::getCouponMoneyByBranch($value["branch_id"],$create_time);
|
$list[$key]["store_coupon_num"] = StoreCouponModel::getCouponNumByBranch($value["branch_id"],$create_time);
|
$list[$key]["total_coupon_money"] = $list[$key]["coupon_money"] + $list[$key]["store_coupon_money"];
|
}
|
}else{
|
$list = $model->select();
|
foreach ($list as $key => $value) {
|
$list[$key]["coupon_money"] = orderModel::getCouponMoneyByBranch($value["branch_id"],$create_time);
|
$list[$key]["coupon_num"] = orderModel::getCouponNumByBranch($value["branch_id"],$create_time);
|
$list[$key]["store_coupon_money"] = StoreCouponModel::getCouponMoneyByBranch($value["branch_id"],$create_time);
|
$list[$key]["store_coupon_num"] = StoreCouponModel::getCouponNumByBranch($value["branch_id"],$create_time);
|
$list[$key]["total_coupon_money"] = $list[$key]["coupon_money"] + $list[$key]["store_coupon_money"];
|
}
|
}
|
|
return $list;
|
}
|
|
/**
|
* 订单导出
|
*/
|
public function exportList($params)
|
{
|
// 获取订单列表
|
$list = $this->getStatisticsList($params,false);
|
// 导出excel文件
|
return (new Exportservice)->branchStatisticsList($list);
|
}
|
}
|
