php/app/common/repositories/movie/MovieRepository.php

<?php
/**
 * @package merchant
 * @Author: Qinii
 * @Date: 2020/5/8
 */

namespace app\common\repositories\movie;

use app\common\dao\movie\order\MovieOrderDao;
use app\common\model\movie\order\MovieOrder;
use app\common\repositories\BaseRepository;
use app\common\repositories\store\order\StoreOrderRepository;
use app\traits\HuiPay;
use crmeb\services\ApiResponseService;
use think\exception\ValidateException;
use think\facade\Db;
use think\facade\Log;

/**
 * Class MovieRepository
 * @package app\common\repositories\movie
 * @author xaboy
 * @mixin MovieOrderDao
 */
class MovieRepository extends BaseRepository
{
    use HuiPay;

    protected $dao;

    const premium_ratio = 0.2;//溢价比例
    const yanglaojin_ratio = 0.3;

    const pv_ratio = 0.7;

    /**
     * ProductRepository constructor.
     * @param MovieOrderDao $dao
     */
    public function __construct(MovieOrderDao $dao)
    {
        $this->dao = $dao;
    }

    /**
     * @param $page
     * @param $limit
     * @param $initial
     * @param $city_name
     * @return false|int|mixed
     */
    public function getMovieCity($page = 1, $limit = 10, $initial = '', $city_name = '')
    {
        return DouHuoMallFilmApiRequest::getMovieCity($page, $limit, $initial = '', $city_name);
    }

    /**
     * @param $city_sign
     * @return false|int|mixed
     */
    public function getMovieArea($city_sign = '')
    {
        return DouHuoMallFilmApiRequest::getMovieArea($city_sign);
    }

    /**
     * @param $page
     * @param $limit
     * @param $city_sign
     * @param $area_sign
     * @return false|int|mixed
     */
    public function getCinema($page = 1, $limit = 10, $city_sign = '', $area_sign = '')
    {
        return DouHuoMallFilmApiRequest::getCinema($page, $limit, $city_sign, $area_sign);
    }

    /**
     * @param $page
     * @param $limit
     * @param $cinema_sign
     * @param $film_sign
     * @return false|int|mixed
     */
    public function getFilm($page = 1, $limit = 10, $cinema_sign = '', $film_sign = '')
    {
        return DouHuoMallFilmApiRequest::getFilm($page, $limit, $cinema_sign, $film_sign);
    }

    /**
     * @param $film_sign
     * @param $cinema_sign
     * @return mixed|string
     */
    public function getCinemaSched($film_sign = '', $cinema_sign = '')
    {
        $result = DouHuoMallFilmApiRequest::getCinemaSched($film_sign, $cinema_sign);
        $cinemaSchedList = (isset($result['code']) && ($result['code'] == ApiResponseService::DEFAULT_SUCCESS_CODE))
            ? $result['data']['list'] : [];
        foreach ($cinemaSchedList as $dateDay => &$fileSchedValue) {
            foreach ($fileSchedValue as $key => $value) {
                $pcYanglaojinGongxian = static::getPvYanglaojinScore($value['cost_price']);

                $fileSchedValue[$key]['price'] = $pcYanglaojinGongxian['cost_price']; // 销售价
                $fileSchedValue[$key]['yanglaojin'] = $pcYanglaojinGongxian['yanglaojin'];
                $fileSchedValue[$key]['pv'] = $pcYanglaojinGongxian['pv'];
                $fileSchedValue[$key]['score'] = $pcYanglaojinGongxian['score'];
                $fileSchedValue[$key]['gongxian'] = $pcYanglaojinGongxian['gongxian'];

//                unset($fileSchedValue[$key]['channel_price']);
            }
        }

        return $cinemaSchedList;
    }

    /**
     * @param $relation_id
     * @param $sched_sign
     * @return mixed|string
     */
    public function getSchedSeat($relation_id = '', $sched_sign = '')
    {
        $result = DouHuoMallFilmApiRequest::getSchedSeat($relation_id, $sched_sign);

        $seat = [];
        $schedSeatList = (isset($result['code']) && ($result['code'] == ApiResponseService::DEFAULT_SUCCESS_CODE)) ? $result['data'] : [];
        foreach ($schedSeatList as $key => $value) {
            $tmpprice = [];
            foreach ($value['price'] as $pKey => $pValue) {
                $tmpprice[$pKey] = ['channel_type' => $pKey, 'price' => $pValue];
            }

            $channel_price = [];
            if (isset($tmpprice['P2'])) {
                $channel_price = $tmpprice['P2'];
            } elseif (isset($tmpprice['P1'])) {
                $channel_price = $tmpprice['P1'];
            } elseif (isset($tmpprice['P0'])) {
                $channel_price = $tmpprice['P0'];
            }
            unset($schedSeatList[$key]['price']);

            $pcYanglaojinGongxian = self::getPvYanglaojinScore($channel_price['price']);
            $schedSeatList[$key]['channel_sn'] = base64_encode(json_encode($channel_price, JSON_FORCE_OBJECT));
            $schedSeatList[$key]['price'] = $pcYanglaojinGongxian['cost_price'];
            $schedSeatList[$key]['yanglaojin'] = $pcYanglaojinGongxian['yanglaojin'];
            $schedSeatList[$key]['pv'] = $pcYanglaojinGongxian['pv'];
            $schedSeatList[$key]['score'] = $pcYanglaojinGongxian['score'];
            $schedSeatList[$key]['gongxian'] = $pcYanglaojinGongxian['gongxian'];
            $schedSeatList[$key]['relation_id'] = $relation_id; // 场次ID
            $schedSeatList[$key]['sched_sign'] = $sched_sign; // 场次编码

            $seat[$value['rowNo']][] = $schedSeatList[$key];
        }
        if ($seat) ksort($seat);

        return array_values($seat);
    }

    /**
     * 锁座订单
     *
     * @param $userinfo
     * @param $params
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function submitOrder($userinfo, $params)
    {
        /** @var StoreOrderRepository $storeOrder */
        $storeOrder = app()->make(StoreOrderRepository::class);
        $order_sn = $storeOrder->getNewOrderId() . '0';

        /** @var CinemaSchedRepository $cinemaSchedRepository */
        $cinemaSchedRepository = app()->make(CinemaSchedRepository::class);
        $sched = $cinemaSchedRepository->getCinemaSchedInfo($params['relation_id'], $params['sched_sign']);
        if (empty($sched)) throw new ValidateException('观影场次不存在');

        $channel_sn = json_decode(base64_decode($params['channel_sn']), true);
        if (empty($channel_sn) || !isset($channel_sn['channel_type']) || empty($channel_sn['channel_type']) || !isset($channel_sn['price'])
            || empty($channel_sn['price']) || json_last_error()) {
            throw new ValidateException('请选择观影场次');
        }

        $sched_seat = json_decode($params['sched_seat'], true);
        if (json_last_error()) throw new ValidateException('锁座下单失败');

        $order_price = bcmul((string)$channel_sn['price'], (string)count($sched_seat), 2);
        $submitOrder = DouHuoMallFilmApiRequest::submitOrder($userinfo->phone, $channel_sn['channel_type'], $params['sched_sign'], array_column($sched_seat, 'seat_sign'), $order_sn, $order_price);
        if (!empty($submitOrder) && isset($submitOrder['code']) && ($submitOrder['code'] == ApiResponseService::DEFAULT_SUCCESS_CODE) && isset($submitOrder['data']['plat_order'])) {
            /** @var CinemaRepository $cinemaRepository */
            $cinemaRepository = app()->make(CinemaRepository::class);
            $cinema = $cinemaRepository->getCinemaInfo($sched['cinema_sign']);

            $_order = [
                'uid' => $userinfo->uid,
                'mobile' => $userinfo->phone,
                'order_sn' => $order_sn,
                'plat_order' => $submitOrder['data']['plat_order'],
                'price' => $order_price,
                'number' => count($sched_seat),
                'order_price' => bcadd((string)$order_price, bcmul((string)$order_price, (string)self::premium_ratio, 2), 2),
                'channel_type' => $channel_sn['channel_type'],
                'city_sign' => $cinema['city_sign'],
                'city_name' => $cinema['city_name'],
                'area_code' => $cinema['area_sign'],
                'area_name' => $cinema['area_name'],
                'cinema_sign' => $cinema['cinema_sign'],
                'cinema_name' => $cinema['cinema_name'],
                'address' => $cinema['address'],
                'longitude' => $cinema['longitude'],
                'latitude' => $cinema['latitude'],
                'hall_sign' => $sched['hall_sign'],
                'hall_name' => $sched['hall_name'],
                'relation_id' => $sched['relation_id'],
                'sched_sign' => $sched['sched_sign'],
                'film_sign' => $sched['film_sign'],
                'film_name' => $sched['film_name'],
                'show_date' => $sched['show_date'],
                'show_time' => $sched['show_time'],
                'sched_seat' => $params['sched_seat'], // 场次座位
                'create_time' => time()
            ];
            $order_sn = Db::transaction(function () use ($userinfo, $_order) {
                $_order = $this->dao->create($_order);
                if ($_order) return $_order['order_sn'];
                throw new ValidateException('锁座下单失败');
            });
            return $order_sn;
        } else {
            throw new ValidateException('锁座下单失败');
        }
    }

    /**
     * @param $userinfo
     * @param $order_sn
     * @param $pay_type
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function confirmOrder($userinfo, $order_sn, $pay_type)
    {
        $orderinfo = $this->dao->getWhere(['order_sn' => $order_sn, 'uid' => $userinfo->uid])->find();
        if (empty($orderinfo)) throw new ValidateException('订单不存在');
        if ($orderinfo['paid'] == 0 && $orderinfo['status'] == 2) throw new ValidateException('订单已超时');
        if ($orderinfo['paid'] == 0 && $orderinfo['status'] == 3) throw new ValidateException('订单已取消');
        if ($orderinfo['paid'] == 1) throw new ValidateException('订单已支付');

        $res = $this->pay($pay_type, $userinfo->wechat_user_id, $orderinfo, $orderinfo['film_name'], env('APP_URL') . "/api/hf_notify/movie", 'delay');
        Db::name('log')->insert(['data' => '汇付电影票订单支付--- 返回参数' . json_encode($res)]);
        if (isset($res['id'])) {
            $type = 0;
            if ($pay_type == 'wx') $type = 2;
            if (strtolower($pay_type) == 'ali') $type = 1;

            $orderinfo->pay_type = $type;
            $orderinfo->update_time = time();
            $orderinfo->save();

            return app('json')->success($res);
        }
        throw new ValidateException('支付失败');
    }

    /**
     * 支付
     *
     * @param $payType
     * @param $openid
     * @param $_order
     * @param $title
     * @param $notify_url
     * @param $pay_mode
     * @param $appid
     * @return array|mixed
     */
    private function pay($payType, $openid, $_order, $title, $notify_url, $pay_mode = null, $appid = '')
    {
        switch ($payType) {
            case 'wx':
                $pay_wx = systemConfig('pay_wx');
                if ($pay_wx == 2) {
                    $appid = env('WECHAT_MP.APPID');
                    $new_secret = env('WECHAT_MP.SECRET');

                    $app_id = 'app_0827b960-b932-45ec-b800-4e850091b419';
                    $key = 'api_live_90ef02e4-54ac-41ee-adf1-e4927d23d58f';
                } elseif ($pay_wx == 3) {
                    $appid = env('WECHAT_TDYL.APPID');
                    $new_secret = env('WECHAT_TDYL.SECRET');

                    $app_id = 'app_383a75dd-c03d-44ab-8f58-92c60fe9b9d0';
                    $key = 'api_live_b0a687ec-5450-4ada-a0e4-65bac0f46871';
                }

                $type = '2';
                $params = [
                    'order_no' => $_order['order_sn'],
                    'app_id' => $app_id,
                    'pay_channel' => 'wx_lite',
                    'pay_amt' => (string)$_order['order_price'],
                    'goods_title' => strlen($title) > 64 ? mb_substr($title, 0, 64, 'utf-8') : $title,// 解决因为太长不能支付问题
                    'goods_desc' => strlen($title) > 42 ? mb_substr($title, 0, 127, 'utf-8') : $title,// 解决因为太长不能支付问题
                    'device_info' => [
                        'device_ip' => app('request')->ip()
                    ],
                    'expend' => json_encode(['open_id' => $openid, 'wx_app_id' => $appid]),
                    'fee_mode' => 'I',
                    'notify_url' => $notify_url,
                    'pay_mode' => $pay_mode
                ];
                break;
            case 'ALI':
            case 'ali':
                $type = '1';
                // 天地博爱科技通道
                $app_id = 'app_44108546-d27a-48ee-88c1-84b45b75114f';
                $key = 'api_live_b23537ed-64b8-45d6-832e-fb228aa9e0a9';

                $params = [
                    'order_no' => $_order['order_sn'],
                    'app_id' => $app_id,
                    'pay_channel' => 'alipay_qr',
                    'pay_amt' => (string)$_order['order_price'],
                    'goods_title' => strlen($title) > 64 ? mb_substr($title, 0, 64, 'utf-8') : $title,// 解决因为太长不能支付问题
                    'goods_desc' => strlen($title) > 42 ? mb_substr($title, 0, 127, 'utf-8') : $title,// 解决因为太长不能支付问题
                    'device_info' => [
                        'device_ip' => app('request')->ip()
                    ],
                    'fee_mode' => 'I',
                    'notify_url' => $notify_url
                ];
                break;
            default:
                throw new ValidateException('请选择支付方式');
                break;
        }

        return $this->Payment_create_traits_a($params, $type, $key);
    }

    /**
     * @param $userinfo
     * @param $order_sn
     * @return mixed|string
     */
    public function getOrderInfo($userinfo, $order_sn)
    {
        $orderinfo = $this->dao->getWhere(['order_sn' => $order_sn, 'uid' => $userinfo->uid])->find();
        if (empty($orderinfo)) throw new ValidateException('订单不存在');

        $result = DouHuoMallFilmApiRequest::getOrderInfo($order_sn);
        if (!empty($result) && ($result['code'] == ApiResponseService::DEFAULT_SUCCESS_CODE)) return $result['data'];
        throw new ValidateException('订单不存在');
    }

    /**
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getLocalMovieCity()
    {
        $city_name = [];

        $city = Db::name('movie_city')->field('city_sign,city_name,initial')->where('is_show', 1)->order('id asc')->select();
        foreach ($city as $key => $value) {
            $city_name[$value['initial']][] = ['city_sign' => $value['city_sign'], 'city_name' => $value['city_name']];
        }

        $initial = !empty($city) ? array_values(array_column($city->toArray(), 'initial', 'initial')) : [];

        return compact('city_name', 'initial');
    }

    /**
     * 获取pv、养老金、售价、积分
     *
     * @param $cost_price
     * @return array
     */
    public static function getPvYanglaojinScore($cost_price)
    {
        $premium = round($cost_price * self::premium_ratio, 2);
        $cost_price = bcadd((string)$cost_price, (string)$premium, 2);
        $pv = $gongxian = $score = bcmul((string)$premium, self::pv_ratio, 2);
        $yanglaojin = bcmul((string)$premium, self::yanglaojin_ratio, 2);

        return compact('premium', 'cost_price', 'pv', 'yanglaojin', 'gongxian', 'score');
    }

    /**
     * 计算佣金分佣奖励
     *
     * @param $pay_type
     * @param $order_sn
     * @param $post_data
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function updateMovieOrderAndcalculationCommissionDividendAward($pay_type, $order_sn, $post_data)
    {
        $orderinfo = $this->dao->getWhere(['order_sn' => $order_sn])->find();
        if ($orderinfo) throw new ValidateException('订单不存在');
        Db::startTrans();
        $orderinfo->paid = 1;
        $orderinfo->pay_time = time();
        $orderinfo->pay_type = $pay_type;
        $orderinfo->status = 1;
        $orderinfo->channel_trade_no = $post_data['id'];
        $orderinfo->pay_open_id = $post_data['expend']['open_id'];
        $orderinfo->update_time = time();
        // 支付方式 1支付宝 2微信
        if ($pay_type == 1) {
            $orderinfo->alipay_no = $post_data['out_trans_id'];
        }
        if ($pay_type == 2) {
            $orderinfo->weixin_no = $post_data['out_trans_id'];
        }
        $res = $orderinfo->save();
        if ($res) {
            $confirmOrder = DouHuoMallFilmApiRequest::confirmOrder($orderinfo['order_sn'], $orderinfo['price']);
            if (!empty($confirmOrder) && isset($confirmOrder['code']) && ($confirmOrder['code'] == ApiResponseService::DEFAULT_SUCCESS_CODE)) {
                // 提交事务
                Db::commit();
            } else {
                Db::name('log')->insert(['data' => '电影票订单支付回调向【微唯宝】--- 告知电影订单已支付失败，订单编号：' . $order_sn]);
                // 回滚事务
                Db::rollback();
            }
        } else {
            Db::name('log')->insert(['data' => '汇付电影票订单支付回调--- 更新电影订单表失败，订单编号：' . $order_sn]);
            // 回滚事务
            Db::rollback();
        }
    }
}