<?php
/**
* @author: xaboy<365615158@qq.com>
* @day: 2017/11/11
*/
namespace app\models\many;
use app\admin\model\system\SystemConfig;
use app\models\user\User;
use app\models\user\UserBill;
use crmeb\services\PHPExcelService;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
/**
* Class StoreCategory
* @package app\admin\model\store
*/
class ManyOrder extends BaseModel
{
/**
* 数据表主键
* @var string
*/
protected $pk = 'id';
/**
* 模型名称
* @var string
*/
protected $name = 'many_order';
use ModelTrait;
protected $autoWriteTimestamp = true;
public static function list($where)
{
$model = self::alias('a')
->order('a.id DESC')
->field('a.*,b.name,u.nickname')
->leftJoin('many b', 'b.id = a.many_id')
->leftJoin('user u', 'u.uid = a.uid')
->where('a.uid', $where['uid']);
// if ($where['status'] == 0 or $where['status']) $model->where('a.status', '=', $where['status']);
$data['count'] = $model->count();
if ($where['page'] && $where['limit']) {
$model->page($where['page'], $where['limit']);
} else {
$model->page(20, 1);
}
$list = $model->select()->toArray();
$data['data'] = $list;
return $data;
}
/**
* 众筹成功订单返还
* @return void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
*/
public static function suc_return()
{
$order = self::where('is_return', 1)->where('status', 0)->select(); // 查询需要返还的订单
if ($order) {
foreach ($order as $item) {
$many = Many::where('id', $item['many_id'])->find();
$user = User::where('uid', $item['uid'])->find();//用户
$user1 = [];
$user2 = [];
if ($user['spread_uid'] > 0) {
$user1 = User::where('uid', $user['spread_uid'])->find();//用户
if ($user1['spread_uid'] > 0) $user2 = User::where('uid', $user1['spread_uid'])->find();//用户
}
$purple_integral = round($item['price'] * 0.07, 2);// 奖励紫积分积分
$frozen = $item['frozen'];
$business_integral = round($item['price'] * 0.03, 2);// 奖励商家积分
$user['white_integral'] += ($purple_integral + $frozen);
$user['integral'] += $business_integral;
if ($user1) {
// 直推收益的百分之十
$sy1 = $item['price'] * 0.015;
$user1['white_integral'] += round($sy1 * 0.7, 2);
$user1['integral'] += round($sy1 * 0.3, 2);
}
if ($user2) {
// 间推收益的百分之五
$sy2 = $item['price'] * 0.01;
$user2['white_integral'] += round($sy2 * 0.7, 2);
$user2['integral'] += round($sy2 * 0.3, 2);
}
self::where('id', $item['id'])->update(['status' => 1, 'return_time' => time()]);
$user->save();
UserBill::income('种树成功补贴肥料', $user['uid'], 'white_integral', 'zccg_white_integral', $purple_integral, $user['spread_uid'], $user['white_integral'], '种树成功补贴' . $many['name'] . '-第' . $item['stage'] . '期肥料');
UserBill::income('种树成功解冻', $user['uid'], 'white_integral', 'fr_white_integral', $frozen, $user['spread_uid'], $user['white_integral'], '种树成功解冻' . $many['name'] . '-第' . $item['stage'] . '期'.$frozen.'肥料');
UserBill::income('种树成功补贴阳光', $user['uid'], 'integral', 'zccg_integral', $business_integral, $user['spread_uid'], $user['integral'], '种树成功补贴' . $many['name'] . '-第' . $item['stage'] . '期阳光');
ManyOrder::push($item['uid'], $item);
if ($user1) {
UserBill::income('直推奖励肥料', $user1['uid'], 'white_integral', 'zt_white_integral', $sy1 * 0.7, $user1['spread_uid'], $user1['white_integral'], '直推奖励肥料');
UserBill::income('直推奖励阳光', $user1['uid'], 'integral', 'zt_integral', $sy1 * 0.3, $user1['spread_uid'], $user1['integral'], '直推奖励阳光');
$user1->save();
}
if ($user2) {
UserBill::income('间推奖励肥料', $user2['uid'], 'white_integral', 'jt_white_integral', $sy2 * 0.7, $user2['spread_uid'], $user2['white_integral'], '间推奖励肥料');
UserBill::income('间推奖励阳光', $user2['uid'], 'integral', 'jt_integral', $sy2 * 0.3, $user2['spread_uid'], $user2['integral'], '间推奖励阳光');
$user2->save();
}
}
}
}
/**
* 团队奖励
* @return void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
*/
public static function push($uid, $order)
{
$user = User::select();
$find = User::where('uid', $uid)->find();
$many = Many::where('id', $order['many_id'])->find();
$price = $order['price'];
if ($find['spread_uid'] > 0 and $price > 0){
$spread = getParent($uid, $user->toArray());// 找到所有上级
$v1 = 0;
$v2 = 0;
$v3 = 0;
$one = SystemConfig::getConfigValue('v1')/100; // v1比例
$tow = SystemConfig::getConfigValue('v2')/100;// v2比例
$three = SystemConfig::getConfigValue('v3')/100;// v3比例
foreach ($spread as $value) {
$details = User::where('uid', $value)->find();
if ($details['level'] == 1){
if ($v2 == 0 and $v3 == 0){
// 没有发放v2和v3的奖励
if ($v1 == 0) { // 没有发放v1的奖励
$jl = $price * $one;
$details['white_integral'] += $jl * 0.7; // 百分之70的紫积分
$details['integral'] += $jl * 0.3; // 百分之30的商家积分
$v1++;
}
}
}elseif ($details['level'] == 2){
if ($v3 == 0){
// 没有发放v3的奖励
if ($v1 == 0 and $v2 == 0) { // 没有发放v1和v2的奖励的奖励
$jl = $price * $tow; // 拿到流水的百分之八
$details['white_integral'] += $jl * 0.7; // 百分之70的紫积分
$details['integral'] += $jl * 0.3; // 百分之30的商家积分
$v2++;
}elseif ($v1 > 0 and $v2 == 0){// 发放v1奖励，没有发放v2的奖励
$jl = $price * ($tow - $one); // 拿到流水减掉v1的百分之五
$details['white_integral'] += $jl * 0.7; // 百分之70的紫积分
$details['integral'] += $jl * 0.3; // 百分之30的商家积分
$v2++;
}
}
}elseif ($details['level'] == 3){
if ($v1 == 0 and $v2 == 0 and $v3 == 0) { // 没有发放v1和v2v3的奖励的奖励
$jl = $price * $three; // 拿到流水的百分之11
$details['white_integral'] += $jl * 0.7; // 百分之70的紫积分
$details['integral'] += $jl * 0.3; // 百分之30的商家积分
$v3++;
}elseif ($v1 > 0 and $v2 == 0 and $v3 == 0){// 发放v1奖励，没有发放v2v3的奖励
$jl = $price * ($three - $one); // 拿到流水减掉v1的百分之五
$details['white_integral'] += $jl * 0.7; // 百分之70的紫积分
$details['integral'] += $jl * 0.3; // 百分之30的商家积分
$v3++;
}elseif ($v1 == 0 and $v2 > 0 and $v3 == 0){// 发放v1奖励，发放v2的奖励,没有发放v3的奖励
$jl = ($price * ($three - $tow)); // 拿到平级的百分之五
$details['white_integral'] += $jl * 0.7; // 百分之70的紫积分
$details['integral'] += $jl * 0.3; // 百分之30的商家积分
$v3++;
}elseif ($v1 > 0 and $v2 > 0 and $v3 == 0){// 发放v1奖励，发放v2的奖励,发放v3的奖励
$jl = ($price * ($three - $tow)); // 拿到平级的百分之五
$details['white_integral'] += $jl * 0.7; // 百分之70的紫积分
$details['integral'] += $jl * 0.3; // 百分之30的商家积分
$v3++;
}
}else{
$jl = 0;
}
if ($jl > 0){
$details->save();
UserBill::income('团队奖励肥料', $details['uid'], 'white_integral', 'td_white_integral', $jl * 0.7, 0,$details['white_integral'], '种树成功补贴'.$many['name'].'-第'.$order['stage'].'期团队v'.$details['level'].'奖励肥料');
UserBill::income('团队奖励阳光', $details['uid'], 'integral', 'td_integral', $jl * 0.3, 0,$details['integral'], '种树成功补贴'.$many['name'].'-第'.$order['stage'].'期期团队v'.$details['level'].'奖励阳光');
}
$jl = 0;
}
}
}
/**
* 流水分红
* @return void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
*/
public static function flowing_water()
{
if (!Push::where('add_time', strtotime('today'))->find()) {
$user = User::where('flowing_water', '>', 0)->select();
if ($user) {
foreach ($user as $item) {
$price = ManyOrder::whereBetweenTime('return_time', strtotime('yesterday'), strtotime('today'))->sum('price');// 昨天众筹成功返还的流水
if ($price > 0) {
$details = User::where('uid', $item['uid'])->find();
$details['white_integral'] += ($price * ($details['flowing_water'] / 100)) * 0.7; // 百分之70的紫积分
$details['integral'] += ($price * ($details['flowing_water'] / 100)) * 0.3; // 百分之30的商家积分
$details->save();
UserBill::income('分红流水奖励肥料', $details['uid'], 'white_integral', 'team_white_integral', ($price * ($details['flowing_water'] / 100)) * 0.7, 0, $details['purple_integral'], '分红流水奖励肥料');
UserBill::income('分红流水奖励阳光', $details['uid'], 'integral', 'team_integral', ($price * ($details['flowing_water'] / 100)) * 0.3, 0, $details['integral'], '分红流水奖励阳光');
}
}
}
}
}
/**
* 更新推送时间
* @return void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
*/
public static function time()
{
if (!Push::where('add_time', strtotime('today'))->find()) {
Push::create(['add_time' => strtotime('today')]); //存入数据库信息
}
}
/**
* 种树成功返还70%肥料
* @param $many
* @return void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
*/
public static function order_return($many)
{
$order = self::where([['many_id', '=', $many['id']], ['stage', '=', $many['stage']], ['frozen', '<=', 0]])->select();
if ($order)
{
foreach ($order as &$item)
{
$price = round($item['price'] * 0.7, 2);// 返还金额
$item['frozen'] = round($item['price'] * 0.3, 2);// 冻结金额
$user = User::where('uid', $item['uid'])->find();
$user['white_integral'] += $price;
$user->save();
UserBill::income('返还肥料', $user['uid'], 'white_integral', 'fh_white_integral', $price, 0, $user['white_integral'], '种树成功返回' . $many['name'] . '-第' . $item['stage'] .'期70%肥料');
self::where('id', $item['id'])->update(['frozen' => $item['frozen']]);
}
}
}
}