<?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();
                if (strtotime($item['create_time'])+(86400*7) < time()){
                    $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'] * 1.07, 2);// 奖励紫积分积分
                    $business_integral = round($item['price'] * 0.03, 2);// 奖励商家积分
                    $user['purple_integral'] += $purple_integral;
                    $user['integral'] += $business_integral;
                    if ($user1){
                        // 直推收益的百分之十
                        $sy1 = $item['price'] * 0.005;
                        $user1['purple_integral'] += round($sy1 * 0.7, 2);
                        $user1['integral'] += round($sy1 * 0.3, 2);
                    }
                    if ($user2){
                        // 间推收益的百分之五
                        $sy2 = $item['price'] * 0.01;
                        $user2['purple_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'], 'purple_integral', 'zccg_purple_integral', $purple_integral, $user['spread_uid'], $user['purple_integral'], '打怪胜利补贴'.$many['name'].'-第'.$item['stage'].'期阳光积分');
                    UserBill::income('打怪胜利补贴商城积分', $user['uid'], 'integral', 'zccg_integral', $business_integral, $user['spread_uid'], $user['integral'], '打怪胜利补贴'.$many['name'].'-第'.$item['stage'].'期商家积分');
                    if ($user1){
                        UserBill::income('直推奖励阳光积分', $user1['uid'], 'purple_integral', 'zt_purple_integral', $sy1*0.7, $user1['spread_uid'], $user1['purple_integral'], '直推奖励阳光积分');
                        UserBill::income('直推奖励商城积分', $user1['uid'], 'integral', 'zt_integral', $sy1*0.3, $user1['spread_uid'], $user1['integral'], '直推奖励商家积分');
                        $user1->save();
                    }
                    if ($user2){
                        UserBill::income('间推奖励阳光积分', $user2['uid'], 'purple_integral', 'jt_purple_integral', $sy2*0.7, $user2['spread_uid'], $user2['purple_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()
    {
        if (!Push::where('add_time', strtotime('today'))->where('type', 1)->find()){
            $user = User::select();
            foreach ($user as $item)
            {
                $price = ManyOrder::whereBetweenTime('return_time', strtotime('yesterday'), strtotime('today'))->where('status', 1)->where('uid', $item['uid'])->sum('price');// 昨天众筹成功返还的金额流水
                if ($item['spread_uid'] > 0 and $price > 0){
                    $spread = getParent($item['spread_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['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                    $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                    $v1++;
                                }elseif ($v1 == 1){// 发放v1奖励1次
                                    $jl = ($price*$one)*0.05;//平级的百分之五
                                    $details['purple_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['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                    $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                    $v2++;
                                }elseif($v1 == 0 and $v2 == 1) { // 没有发放v1和v2的奖励的奖励
                                    $jl = ($price * $tow)*0.05; // 拿到流水的百分之八
                                    $details['purple_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['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                    $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                    $v2++;
                                }elseif ($v1 > 0 and $v2 == 1){// 发放v1奖励，发放v2的奖励一次
                                    $jl = ($price * ($tow - $one))*0.05; // 拿到平级的百分之五
                                    $details['purple_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['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                $v3++;
                            }elseif ($v1 == 0 and $v2 == 0 and $v3 == 1) {// 没有发放v1和v2的奖励的奖励
                                $jl = ($price * $three) * 0.05; // 拿到平级的百分之五
                                $details['purple_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['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                $v3++;
                            }elseif ($v1 > 0 and $v2 == 0 and $v3 == 1){// 发放v1奖励，没有发放v2v3的奖励
                                $jl = ($price * ($three - $one)) * 0.05; // 拿到平级的百分之五
                                $details['purple_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['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                $v3++;
                            }elseif ($v1 == 0 and $v2 > 0 and $v3 == 1){// 发放v1奖励，发放v2的奖励,发放v3的奖励
                                $jl = ($price * ($three - $tow)) * 0.05; // 拿到平级的百分之五
                                $details['purple_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['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                $v3++;
                            }elseif ($v1 > 0 and $v2 > 0 and $v3 == 1){// 发放v1奖励，发放v2的奖励,发放v3的奖励
                                $jl = ($price * ($three - $tow)) * 0.05; // 拿到平级的百分之五
                                $details['purple_integral'] += $jl * 0.7; // 百分之70的紫积分
                                $details['integral'] += $jl * 0.3; // 百分之30的商家积分
                                $v3++;
                            }
                        }else{
                            $jl = 0;
                        }
                        if ($jl > 0){
                            $details->save();
                            UserBill::income('团队奖励阳光积分', $details['uid'], 'purple_integral', 'td_purple_integral', $jl * 0.7, 0,$details['purple_integral'], 'v'.$details['level'].'团队奖励阳光积分');
                            UserBill::income('团队奖励商城积分', $details['uid'], 'integral', 'td_integral', $jl * 0.3, 0,$details['integral'], 'v'.$details['level'].'团队奖励商城积分');
                        }
                        $jl = 0;
                    }
                }
            }
            Push::create(['add_time' => strtotime('today'), 'type' => 1]); //存入数据库信息

        }
    }

    /**
     * 流水分红
     * @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'))->where('status', 1)->sum('price');// 昨天众筹成功返还的流水
                    if ($price > 0){
                        $details = User::where('uid', $item['uid'])->find();

                        $details['purple_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'], 'purple_integral', 'team_purple_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')]); //存入数据库信息
        }
    }


}