<?php
|
|
namespace app\shop\model\supplier;
|
|
use app\common\model\supplier\Supplier as SupplierModel;
|
use app\common\model\supplier\User as SupplierUserModel;
|
use app\common\model\user\User as UserModel;
|
use app\shop\model\product\Product as ProductModel;
|
use Lvht\GeoHash; // by yj
|
use app\shop\model\store\Store as StoreModel; // by yj
|
use app\shop\model\order\Order as OrderModel; // by yj
|
use app\shop\model\store\Coupon as StoreCouponModel; // by yj
|
use app\shop\service\order\ExportService;
|
|
/**
|
* 后台管理员登录模型
|
*/
|
class Supplier extends SupplierModel
|
{
|
/**
|
* 获取列表数据
|
*/
|
public function getList($params)
|
{
|
$model = $this;
|
if (isset($params['search']) && $params['search']) {
|
$model = $model->where('name', 'like', '%' . $params['search'] . '%');
|
}
|
if(isset($params['shop_supplier_ids'])&&$params['shop_supplier_ids']){
|
$model = $model->where('shop_supplier_id', 'in', $params['shop_supplier_ids']);
|
}
|
if(isset($params['is_takeout']) && $params['is_takeout'] > -1){
|
$model = $model->where('is_takeout', '=', $params['is_takeout']);
|
}
|
// 查询列表数据
|
return $model->with(['logo', 'superUser', 'business', 'qyQrcode'])
|
->where('is_delete', '=', '0')
|
->order(['create_time' => 'desc'])
|
->paginate($params);
|
}
|
|
/**
|
* 添加
|
*/
|
public function add($data)
|
{
|
// 开启事务
|
$this->startTrans();
|
try {
|
$supplier = $data['supplier'];
|
if (SupplierUserModel::checkExist($supplier['user_name'])) {
|
$this->error = '用户名已存在';
|
return false;
|
}
|
// 用户是否已绑定
|
$user = null;
|
if($supplier['user_id'] > 0){
|
$user = UserModel::detail($supplier['user_id']);
|
if ($user['user_type'] != 1) {
|
$this->error = '该用户已绑定';
|
return false;
|
}
|
$isApply = $this->isApply($supplier['user_id']);
|
if ($isApply) {
|
$this->error = '已经申请开店';
|
return false;
|
}
|
}
|
$supplier = $this->createData($supplier);
|
// 添加供应商
|
$supplier['app_id'] = self::$app_id;
|
$this->save($supplier);
|
// 添加登录用户
|
$user_model = new SupplierUserModel();
|
$user_model->save([
|
'user_id' => $supplier['user_id'],
|
'user_name' => $supplier['user_name'],
|
'password' => salt_hash($supplier['password']),
|
'real_name' => $supplier['user_name'],
|
'shop_supplier_id' => $this['shop_supplier_id'],
|
'is_super' => 1,
|
'app_id' => self::$app_id,
|
]);
|
// 后台添加的直接算审核通过
|
if($user){
|
$user->save([
|
'user_type' => 2
|
]);
|
}
|
// 同时添加门店 by lyzflash
|
$this->addStore($supplier);
|
$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;
|
// 格式化坐标信息
|
$coordinate = explode(',', $data['coordinate']);
|
$data['latitude'] = $coordinate[0];
|
$data['longitude'] = $coordinate[1];
|
|
// 生成geohash
|
$Geohash = new Geohash;
|
$data['geohash'] = $Geohash->encode($data['longitude'], $data['latitude']);
|
return $data;
|
}
|
|
/**
|
* 同时创建门店
|
*/
|
private function addStore($data)
|
{
|
$data['store_name'] = $data['name'];
|
$data['linkman'] = $data['link_name'];
|
$data['phone'] = $data['link_phone'];
|
$data['logo_image_id'] = $data['logo_id'];
|
$data['summary'] = $data['description'];
|
$data['shop_supplier_id'] = $this['shop_supplier_id'];
|
$data['status'] = 1;
|
return (new StoreModel)->save($data);
|
}
|
|
/**
|
* 修改
|
*/
|
public function edit($data)
|
{
|
// 开启事务
|
$this->startTrans();
|
try {
|
$supplier = $data['supplier'];
|
$old_user_id = 0;
|
if($this['superUser']){
|
$old_user_id = $this['superUser']['user_id'];
|
}
|
if ($this['superUser'] && $supplier['user_name'] != $this['superUser']['user_name'] && SupplierUserModel::checkExist($supplier['user_name'])) {
|
$this->error = '用户名已存在';
|
return false;
|
}
|
|
// 用户是否已绑定
|
$user = null;
|
$userChange = false;
|
if (!empty($supplier['user_id'])){
|
if($this['superUser'] && $supplier['user_id'] > 0 && $supplier['user_id'] != $this['superUser']['user_id']){
|
$user = UserModel::detail($supplier['user_id']);
|
if ($user['user_type'] != 1) {
|
$this->error = '该用户已绑定';
|
return false;
|
}
|
$isApply = $this->isApply($supplier['user_id']);
|
if ($isApply) {
|
$this->error = '已经申请开店';
|
return false;
|
}
|
$userChange = true;
|
}
|
$user=UserModel::detail($supplier['user_id']);
|
$supplier['referee_id'] = $user['referee_id'];
|
}
|
|
// 修改供应商
|
$this->save($supplier);
|
// 修改登录用户
|
$user_model = $this['superUser'];
|
$user_data = [
|
'user_id' => $supplier['user_id'],
|
'user_name' => $supplier['user_name']
|
];
|
if (isset($supplier['password']) && !empty($supplier['password'])) {
|
$user_data['password'] = salt_hash($supplier['password']);
|
}
|
$user_model->save($user_data);
|
// 后台添加的直接算审核通过
|
if($userChange){
|
$user->save([
|
'user_type' => 2
|
]);
|
//取消原来的
|
if ($old_user_id > 0){
|
(new UserModel())->where('user_id', '=', $old_user_id)->update([
|
'user_type' => 1
|
]);
|
}
|
}
|
$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 {
|
if($is_recycle==1){
|
//产品下架
|
(new ProductModel())->where('shop_supplier_id','=',$this['shop_supplier_id'])->update(['product_status' => 20]);
|
}
|
//更改店铺状态
|
$this->save(['is_recycle' => $is_recycle]);
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
|
|
}
|
/**
|
* 获取列表数据
|
*/
|
public static function getAll()
|
{
|
$model = new static();
|
// 查询列表数据
|
return $model->field(['shop_supplier_id,name'])->where('is_delete', '=', '0')
|
->order(['create_time' => 'desc'])
|
->select();
|
}
|
|
|
/**
|
* 提现驳回：解冻资金
|
*/
|
public static function backFreezeMoney($shop_supplier_id, $money)
|
{
|
$model = self::detail($shop_supplier_id);
|
return $model->save([
|
'money' => $model['money'] + $money,
|
'freeze_money' => $model['freeze_money'] - $money,
|
]);
|
}
|
|
/**
|
* 提现打款成功：累积提现金额
|
*/
|
public static function totalMoney($shop_supplier_id, $money)
|
{
|
$model = self::detail($shop_supplier_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 function getSupplierTotal()
|
{
|
return $this->where(['is_delete' => 0])->count();
|
}
|
|
/**
|
* 获取供应商总数量
|
*/
|
public static function getSupplierTotalByDay($day)
|
{
|
$startTime = strtotime($day);
|
return (new static())->where('create_time', '>=', $startTime)
|
->where('create_time', '<', $startTime + 86400)
|
->count();
|
}
|
|
/**
|
* 获取供应商统计数量
|
*/
|
public function getSupplierData($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 == 'supplier_total' || $type == 'supplier_add'){
|
return $model->count();
|
}
|
return 0;
|
}
|
|
/**
|
* 获取平台的总销售额
|
*/
|
public function getTotalMoney($type = 'total_money',$postData=[])
|
{
|
$model = $this;
|
if(!empty($postData["supplier_name"])){
|
//获取商户id
|
$shop_supplier_id = SupplierModel::getSupplierIdByName($postData['supplier_name']);
|
$model = $model->where('shop_supplier_id', '=', $shop_supplier_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("shop_supplier_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::getCouponMoneyBySupplier($value["shop_supplier_id"],$create_time);
|
$list[$key]["coupon_num"] = orderModel::getCouponNumBySupplier($value["shop_supplier_id"],$create_time);
|
$list[$key]["store_coupon_money"] = StoreCouponModel::getCouponMoneyBySupplier($value["shop_supplier_id"],$create_time);
|
$list[$key]["store_coupon_num"] = StoreCouponModel::getCouponNumBySupplier($value["shop_supplier_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::getCouponMoneyBySupplier($value["shop_supplier_id"],$create_time);
|
$list[$key]["coupon_num"] = orderModel::getCouponNumBySupplier($value["shop_supplier_id"],$create_time);
|
$list[$key]["store_coupon_money"] = StoreCouponModel::getCouponMoneyBySupplier($value["shop_supplier_id"],$create_time);
|
$list[$key]["store_coupon_num"] = StoreCouponModel::getCouponNumBySupplier($value["shop_supplier_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)->supplierStatisticsList($list);
|
}
|
}
|
