duanju_manage/modules/Channel/Services/Order/OrderService.php

<?php
/**
 *
 * @file:OrderService.php
 * @Date: 2023/5/23
 * @Time: 13:40
 */


namespace Modules\Channel\Services\Order;

use Illuminate\Support\Facades\DB;
use Modules\Channel\Models\Order;
use Modules\Channel\Models\UserHasMiniprograms;
use Modules\Manage\Models\Miniprogram;
use Modules\User\Models\User;

class OrderService
{

    /**
     *  订单列表查询
     * name: getOrderList
     * @param array $param
     * date 2023/05/23 13:45
     */
    public static function getOrderList(array $param, $isAll = false)
    {
        $list = self::getOrderQuerySql($param)->select("orders.*",'orders_refund_verify.id as refund_id', 'pay_merchants.name as pay_merchant_name', 'pay_merchants.payee_name', 'pay_merchants.pay_appid', 'miniprogram.play_name', "miniprogram.name as xcx_name", 'promotions.name as promotion_title')->orderBy("orders.id", 'desc');

        if ($isAll) {
            $list = $list->get();
        } else {
            $list = $list->paginate(getProp($param, 'limit', 15));
        }

        if (!$list->isEmpty()) {
            $status = array_column(self::getOrderPayType(), null, 'value');
            $types = array_column(self::getOrderType(), null, 'value');
            foreach ($list as $val) {
                $val->username = $val->user_id > 0 ? User::where('id', $val->user_id)->value('username') : "";
                $val->company_name = $val->puser_id > 0 ? DB::table('users')->where('id', $val->puser_id)->value("username") : "-";
                $val->total_count = Order::where('uid', $val->uid)->where('id', "<=", $val->id)->count();
                if ($val->user_id > 0) {
                    $val->caompany_count = Order::where('uid', $val->uid)->where('status','<>', 'UNPAID')->where('puser_id', '>', 0)->where('puser_id', $val->puser_id)->where('id', "<=", $val->id)->count();
                    $val->promotion_count = Order::where('uid', $val->uid)->where('status','<>', 'UNPAID')->where('puser_id', '>', 0)->where('puser_id', $val->puser_id)->where('user_id', ">", 0)->where('user_id', $val->user_id)->where('id', "<=", $val->id)->count();
                } else {
                    $val->caompany_count = Order::where('uid', $val->uid)->where('status','<>', 'UNPAID')->where('puser_id', '>', 0)->count();
                    $val->promotion_count = Order::where('uid', $val->uid)->where('status','<>', 'UNPAID')->where('user_id', '>', 0)->count();
                }
                $val->pay_appid = $val->pay_appid ?: '-';
                $val->pay_merchant_name = $val->pay_merchant_name ?: '-';
                $val->payee_name = $val->payee_name ?: '-';
                $val->xcx_name = $val->xcx_name ?: '-';
                $val->play_name = $val->play_name ?: '-';
                $val->promotion_title = $val->promotion_title ?: '-';
                $val->tip_text = $types[$val->order_type]['name'] ?? "-";
                $val->status_txt = $status[$val->status]['name'] ?? "-";
                $val->can_apply = $val->refund_id < 1 && $val->status == 'PAID';
                $val->pay_name = '微信支付';
                unset($val->refund_id);
            }
        }

        return $list;
    }


    /**
     *  充值类型
     * name: getOrderType
     * @return \string[][]
     * date 2023/06/02 09:56
     */
    public static function getOrderType()
    {
        return [
            ["value" => "COIN", "name" => "普通充值"],
            ["value" => 'MONTH', "name" => '包月'],
            ["value" => 'QUARTER', "name" => '包季'],
            ["value" => 'YEAR', "name" => '包年'],
            ["value" => "FIRST_COIN", "name" => "首充"]
        ];
    }

    /**
     *  订单状态
     * name: getOrderPayType
     * @return \string[][]
     * date 2023/06/02 09:57
     */
    public static function getOrderPayType()
    {
        return [
            ["value" => "PAID", "name" => "已支付"],
            ["value" => 'REFUND', "name" => '已退款'],
            ["value" => 'UNPAID', "name" => '未支付'],
        ];
    }

    private static function getOrderQuerySql(array $param)
    {
        $sql = DB::table('orders')->leftJoin('orders_refund_verify','orders.id','=','orders_refund_verify.order_id')->leftJoin('miniprogram', 'miniprogram.id', '=', 'orders.miniprogram_id')->leftJoin('promotions', 'promotions.id', '=', 'orders.promotion_id')->leftJoin('pay_merchants', 'pay_merchants.id', '=', 'orders.pay_merchant_id');
        // 优化师查询
        if (!empty(getProp($param, 'user_id'))) {
            $sql->where('orders.user_id', $param['user_id']);
        }
        // 公司查询
        if (!empty(getProp($param, 'puser_id'))) {
            $sql->where('orders.puser_id', $param['puser_id']);
        }
        // 小程序
        if (!empty(getProp($param, 'miniprogram_id'))) {
            $sql->where('orders.miniprogram_id', $param['miniprogram_id']);
        }

        // 推广id
        if (!empty(getProp($param, 'promotion_id'))) {
            $sql->where('orders.promotion_id', $param['promotion_id']);
        }
        // 订单状态查询
        if (!empty(getProp($param, 'status'))) {
            $sql->where('orders.status', $param['status']);
        }

        // 充值项类型
        if (!empty(getProp($param, 'order_type'))) {
            $sql->where('orders.order_type', $param['order_type']);
        }
        // 用户
        if (!empty(getProp($param, 'uid'))) {
            $sql->where('orders.uid', $param['uid']);
        }
        // 订单号查询
        if (!empty(getProp($param, 'trade_no'))) {
            $sql->where('orders.trade_no', "like", "%" . $param['trade_no'] . "%");
            // $sql->where('orders.trade_no',  $param['trade_no']);
        }
        if (!empty(getProp($param, 'trade_no'))) {
            // $sql->where('orders.trade_no', "like", "%" . $param['trade_no'] . "%");
            $sql->where('orders.trade_no', $param['trade_no']);
        }
        // 支付时间
        if (!empty(getProp($param, 'pay_end_at_start'))) {
            $sql->where('orders.pay_end_at', ">=", $param['pay_end_at_start']);
        }
        if (!empty(getProp($param, 'pay_end_at_end'))) {
            $end = $param['pay_end_at_end'];
            if ($end == getProp($param, 'pay_end_at_start', '')) {
                $end = date("Y-m-d", strtotime($end)) . " 23:59:59";
            }
            $sql->where('orders.pay_end_at', "<=", $end);
        }
        // 创建时间
        if (!empty(getProp($param, 'created_at_start'))) {
            $sql->where('orders.created_at', '>=', $param['created_at_start']);
        }

        if (!empty(getProp($param, 'created_at_end'))) {
            $end = $param['created_at_end'];
            if ($end == getProp($param, 'created_at_start', '')) {
                $end = date("Y-m-d", strtotime($end)) . " 23:59:59";
            }
            $sql->where('orders.created_at', "<=", $end);
        }

        // 支付配置信息查询
        if (getProp($param, 'pay_merchant_name', '')) {
            // 支付名称
            $sql->where("pay_merchants.name", $param['pay_merchant_name']);
        }
        if (getProp($param, 'payee_name', '')) {
            // 收款主体
            $sql->where("pay_merchants.payee_name", "like", "%" . $param['payee_name'] . "%");
        }
        if (getProp($param, 'pay_appid', '')) {
            // 商户号
            $sql->where("pay_merchants.pay_appid", $param['pay_appid']);
        }
        return $sql;
    }

    /**
     *  用户订单小程选择列表
     * name: userUseProgramsList
     * @param mixed $uid
     * @return \Illuminate\Database\Eloquent\Builder[]|\Illuminate\Database\Eloquent\Collection|\Illuminate\Support\Collection
     * date 2023/05/23 17:51
     */
    public static function userUseProgramsList(mixed $uid, $name = "", $limit = 20)
    {

        $operateUser = User::find($uid);
        $operateUserRoles = $operateUser->roles->pluck('identify');
        if ($operateUserRoles->contains('company') || $operateUserRoles->contains('optimizer')) {
            $list = UserHasMiniprograms::query()->join('miniprogram', 'miniprogram.id', '=', 'user_has_miniprograms.miniprogram_id')
                ->where('uid', $uid)
                ->groupBy("user_has_miniprograms.miniprogram_id")
                ->select('user_has_miniprograms.miniprogram_id', 'miniprogram.name', 'miniprogram.play_name');
            if ($name) {
                $list->where('name', "like", "%" . $name . "%");
            }
            return $list->orderBy('miniprogram.id', 'desc')->limit($limit)->get();
        } else {
            if ($name) {
                return DB::table('miniprogram')->where('name', "like", "%" . $name . "%")->select("id as miniprogram_id", "name", "play_name")->limit($limit)->get();
            }
            return DB::table('miniprogram')->select("id as miniprogram_id", "name", "play_name")->orderBy('id', 'desc')->limit($limit)->get();

        }

    }

    /**
     *  推广列表选择项
     * name: promotionsOptions
     * @param mixed $uid
     * @param mixed $title
     * @return \Illuminate\Support\Collection
     * date 2023/05/23 18:13
     */
    public static function promotionsOptions(mixed $uid, mixed $title, mixed $miniprogram_id, mixed $limit = 10)
    {
        $operateUser = User::find($uid);
        $operateUserRoles = $operateUser->roles->pluck('identify');
        $list = DB::table('promotions')->select('id as promotion_id', 'name');
        if ($operateUserRoles->contains('optimizer')) {
            if ($miniprogram_id) {
                $list->where('miniprogram_id', $miniprogram_id);
            }
            if ($title) {
                $list->where('name', 'like', "%" . $title . "%");
            }

            return $list->where('uid', $uid)->orderBy('id', 'desc')->limit($limit)->get();
        } else if ($operateUserRoles->contains('company')) {
            $list = DB::table('promotions')->join('users', 'users.id', "promotions.uid")
                ->where('users.pid', $uid)->orWhere("promotions.uid", $uid)->select('promotions.id as promotion_id', 'promotions.name');
            if ($title) {
                $list->where('promotions.name', 'like', "%" . $title . "%");
            }
            if ($miniprogram_id) {
                $list->where('promotions.miniprogram_id', $miniprogram_id);
            }
            return $list->orderBy('promotions.id', 'desc')->limit($limit)->get();

        } else {
            if ($miniprogram_id) {
                $list->where('miniprogram_id', $miniprogram_id);
            }
            if ($title) {
                $list->where('name', 'like', "%" . $title . "%");
            }
            return $list->orderBy('id', 'desc')->limit($limit)->get();
        }
    }

    /***
     * 订单列表优化师选择项
     * name: promotionsUsers
     * @param mixed $pid
     * @param mixed $name
     * @param mixed $limit
     * date 2023/05/26 09:22
     */
    public static function promotionsUsers(mixed $pid, mixed $name, mixed $miniprogram_id, mixed $limit = 10)
    {
        if ($pid > 0) {
            $list = DB::table('users')->where('pid', $pid)->select('users.id as user_id', 'users.username as  name');
            if ($name) {
                $list->where('username', 'like', "%" . $name . "%");
            }
            if ($miniprogram_id > 0) {
                $list->join('user_has_miniprograms', 'user_has_miniprograms.uid', 'users.id')
                    ->where('user_has_miniprograms.miniprogram_id', $miniprogram_id);
            }

            return $list->orderBy('users.id', 'desc')->limit($limit)->get();
        }

        $list = DB::table('users')->join('user_has_roles', 'users.id', "user_has_roles.user_id")->join('roles', 'roles.id', 'user_has_roles.role_id')
            ->select('users.id as user_id', 'users.username as  name')->where('roles.identify', 'optimizer');
        if ($miniprogram_id > 0) {
            $list->join('user_has_miniprograms', 'user_has_miniprograms.uid', 'users.id')
                ->where('user_has_miniprograms.miniprogram_id', $miniprogram_id);
        }
        if ($name) {
            $list->where('users.username', 'like', "%" . $name . "%");
        }
        return $list->orderBy('users.id', 'desc')->limit($limit)->get();
    }
}