wlg/app/models/many/ManyOrder.php

<?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'] * 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.01;
                    $user1['purple_integral'] += round($sy1 * 0.7, 2);
                    $user1['integral'] += round($sy1 * 0.3, 2);
                }
                if ($user2) {
                    // 间推收益的百分之五
                    $sy2 = $item['price'] * 0.005;
                    $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('间推奖励阳光', $user1['uid'], 'purple_integral', 'jt_purple_integral', $sy2 * 0.7, $user2['spread_uid'], $user2['purple_integral'], '间推奖励阳光');
                    UserBill::income('间推奖励商城积分', $user1['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'))->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['uid']);// 找到所有上级
                    $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++;
                            }
                        }
                        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;
                    }
                }
            }
        }
    }

    /**
     * 流水分红
     * @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['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')]); //存入数据库信息
        }
    }


}