php/app/controller/admin/order/ThirdOrder.php

<?php
namespace app\controller\admin\order;

use app\common\repositories\user\UserThirdRepository;
use crmeb\basic\BaseController;
use crmeb\services\SpreadsheetExcelService;
use think\App;

class ThirdOrder extends BaseController
{
    protected $repository;

    public function __construct(App $app, UserThirdRepository $repository)
    {
        parent::__construct($app);
        $this->repository = $repository;
    }


    /*京东订单*/
    public function  jdOrder(){

        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','status','keywords','bill_status']);
        return app('json')->success($this->repository->GetJdOrder($where, $page, $limit));
    }


    /*唯品会订单*/
    public function  wphOrder(){
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','order_status','keywords','bill_status','settled']);
        return app('json')->success($this->repository->GetVipOrder($where, $page, $limit));
    }


    /*拼多多订单*/
    public function  pddOrder(){
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','pin_order_status','keywords','bill_status']);
        return app('json')->success($this->repository->GetPddOrder($where, $page, $limit));
    }


    /*苏宁订单*/
    public function  suOrder(){
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','status','keywords','bill_status']);
        return app('json')->success($this->repository->GetSuOrder($where, $page, $limit));
    }

    /*淘宝订单*/
    public function  tbOrder(){
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','tk_status','keywords','bill_status']);
        return app('json')->success($this->repository->GetTbOrder($where, $page, $limit));
    }


    /*话费订单*/
    public function  hfOrder(){
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','status','keywords','bill_status']);
        return app('json')->success($this->repository->GetHfOrder($where, $page, $limit));
    }



    /*详情*/
    public function  detail($id){
        $table = $this->request->params(['table']);
        return app('json')->success($this->repository->GetThirdDetail($id,$table['table']));
    }

    /**
     * 导出第三方订单
     */
    public function getJdOrder()
    {
        $where = $this->request->params(['date','order_sn','status','keywords','bill_status']);//筛选条件
        $page = 1;
        $limit = 9999999;
        $temporaryData = $this->repository->GetJdOrder($where,$page,$limit);
        $data = $temporaryData['list'];
        $arr = [];
        foreach ($data as $item) {
            $arr[] = [
                $item['order_jd_id'] ?? '',       // 订单表ID
                $item['uid'] ?? '',               // 用户ID
                $item['commission'] ?? '',        // 佣金 actualFee
                $item['commission_share'] ?? '',  // 佣金比例 finalRate
                $item['jd_id'] ?? '',             // 订单id
                $item['order_sn'] ?? '',          // 订单号
                $item['pay_money'] ?? '',         // 实际计算佣金的金额
                $item['create_time'] ?? '',       // 创建时间
                $item['finish_time'] ?? '',       // 完成时间
                $item['modify_time'] ?? '',       // 更新时间
                $item['sku_num'] ?? '',           // 数量
                $item['sku_id'] ?? '',            // 商品id
                $item['sku_name'] ?? '',          // 商品名称
                $item['price'] ?? '',             // 单价
                $item['sub_union_id'] ?? '',      // 子渠道id-用户pid
                $item['image_url'] ?? '',         // 商品图片
                $item['shop_name'] ?? '',         // 店铺名称
                $item['shop_id'] ?? '',           // 店铺id
                $item['status'] ?? '',            // 订单状态 validCode
                $item['bill_status'] ?? '',       // 结算状态
                $item['bill_create_time'] ?? '',  // 平台结算时间
                $item['bill_end_time'] ?? '',     // 可结算日期
                $item['gzc'] ?? '',               // 公证处标记
                $item['user_address_ids'] ?? '',  // 详细地址串
                $item['type'] ?? '',              // 订单类型
                $item['pv'] ?? '',                // PV值
            ];
        }
        $header = [
            '订单表ID',
            '用户ID',
            '佣金 (actualFee)',
            '佣金比例 (finalRate)',
            '订单ID',
            '订单号',
            '实际计算佣金的金额',
            '创建时间',
            '完成时间',
            '更新时间',
            '数量',
            '商品ID',
            '商品名称',
            '单价',
            '子渠道ID (用户PID)',
            '商品图片',
            '店铺名称',
            '店铺ID',
            '订单状态 (validCode)',
            '0平台未结算1已结算2失效',
            '平台结算时间',
            '可结算日期',
            '公证处IN10是否发起0否1是',
            '详细地址串',
            '1京推推订单 2京东联盟订单',
            'PV值',
        ];
        $filename = '京东订单导出_' . date('YmdHis') . '_' . rand(10000,99999);
        $_instance = SpreadsheetExcelService::instance_xin();
        $_path = $_instance
            ->createOrActive()
            ->setExcelHeader($header)
            ->setExcelTile('京东订单明细', $filename, '生成时间: ' . date('Y-m-d H:i:s'))
            ->setExcelContent($arr)
            ->excelSave($filename, 'xlsx', 'extract');
        $domain = request()->domain();
        return [
            'name' => $filename . '.xlsx',
            'status' => 200,
            'path' => $domain . '/' . $_path
        ];
    }
    public function  getWphOrder()
    {
        $where = $this->request->params(['date','order_sn','order_status','keywords','bill_status','settled']);
        $page = 1;
        $limit = 9999999;
        $temporaryData = $this->repository->GetVipOrder($where,$page,$limit);
        $data = $temporaryData['list'];
        $arr = [];
        foreach ($data as $item) {
            $arr[] = [
                $item['order_vip_id'],
                $item['uid'],
                $item['pid'],
                $item['order_sn'],
                $item['pay_money'],
                $item['status'],
                $item['new_customer'],
                $item['order_time'],
                $item['sign_time'],
                $item['settled_time'],
                $item['goods_id'],
                $item['goods_name'],
                $item['goods_thumb'],
                $item['goods_count'],
                $item['commission_total'],
                $item['commission_rate'],
                $item['commission'],
                $item['commission_time'],
                $item['order_source'],
                $item['last_update_time'],
                $item['settled'],
                $item['self_buy'],
                $item['order_status'],
                $item['after_commission'],
                $item['after_count'],
                $item['bill_status'],
                $item['bill_end_time'],
                $item['create_time'],
                $item['gzc'],
                $item['bill_create_time'],
                $item['user_address_ids'],
                $item['pv'],
            ];
        }
        $header = [
            '订单表ID',
            '用户ID',
            '关联PID',
            '订单号',
            '订单支付金额',
            '订单状态(0不合格1待定2已完结)',
            '新老客(0待定1新客2老客)',
            '下单时间',
            '签收时间',
            '结算时间',
            '商品ID',
            '商品名称',
            '商品缩略图',
            '商品数量',
            '商品计佣金额',
            '商品佣金比例(%)',
            '商品佣金金额',
            '入账时间',
            '订单来源',
            '上次更新时间',
            '结算状态(0未结算1已结算)',
            '是否自推自买(0否1是)',
            '订单子状态',
            '售后佣金变动',
            '售后数量变动',
            '结算标记(0未结算1已结算2失效)',
            '可结算日期(时间戳)',
            '订单创建时间',
            '公证处标记(0否1是)',
            '平台结算时间',
            '详细地址串',
            'PV值',
        ];
        $filename = '唯品会订单导出_' . date('YmdHis') . '_' . rand(10000,99999);
        $_instance = SpreadsheetExcelService::instance_xin();
        $_path = $_instance
            ->createOrActive()
            ->setExcelHeader($header)
            ->setExcelTile('唯品会订单明细', $filename, '生成时间: ' . date('Y-m-d H:i:s'))
            ->setExcelContent($arr)
            ->excelSave($filename, 'xlsx', 'extract');
        $domain = request()->domain();
        return [
            'name' => $filename . '.xlsx',
            'status' => 200,
            'path' => $domain . '/' . $_path
        ];
    }
    public function  getPddOrder()
    {
        $where = $this->request->params(['date','order_sn','pin_order_status','keywords','bill_status']);
        $page = 1;
        $limit = 9999999;
        $temporaryData = $this->repository->GetPddOrder($where,$page,$limit);
        $data = $temporaryData['list'];
        $arr = [];
        foreach ($data as $item) {
            $arr[] = [
                $item['order_pdd_id'],
                $item['uid'],
                $item['goods_id'],
                $item['goods_sign'],
                $item['order_sn'],
                $item['goods_num'],
                $item['goods_img'],
                $item['goods_name'],
                $item['goods_price'],
                $item['order_type'],
                $item['pin_order_status'],
                $item['pin_order_status_desc'],
                $item['order_money'],
                $item['pay_money'],
                $item['create_time'],
                $item['group_time'],
                $item['pay_time'],
                $item['receive_time'],
                $item['settle_time'],
                $item['last_modify_time'],
                $item['p_id'],
                $item['commission_rate'],
                $item['commission'],
                $item['bill_status'],
                $item['bill_create_time'],
                $item['bill_end_time'],
                $item['gzc'],
                $item['user_address_ids'],
                $item['pv'],
            ];
        }
        $header = [
            '订单ID',
            '用户ID',
            '商品ID',
            '商品sign',
            '订单号',
            '商品数量',
            '商品图片',
            '商品名称',
            '商品单价',
            '订单类型',
            '订单状态码',
            '订单状态描述',
            '订单金额',
            '实付金额',
            '创建时间',
            '成团时间',
            '支付时间',
            '收货时间',
            '结算时间',
            '最后更新时间',
            'PID',
            '佣金比例',
            '佣金金额',
            '结算状态',
            '平台结算时间',
            '可结算日期',
            '公证处IN10是否发起0否1是',
            '地址详情',
            'PV值',
        ];
        $filename = '拼多多订单导出_' . date('YmdHis') . '_' . rand(10000,99999);
        $_instance = SpreadsheetExcelService::instance_xin();
        $_path = $_instance
            ->createOrActive()
            ->setExcelHeader($header)
            ->setExcelTile('拼多多订单明细', $filename, '生成时间: ' . date('Y-m-d H:i:s'))
            ->setExcelContent($arr)
            ->excelSave($filename, 'xlsx', 'extract');
        $domain = request()->domain();
        return [
            'name' => $filename . '.xlsx',
            'status' => 200,
            'path' => $domain . '/' . $_path
        ];
    }
    public function getSuOrder()
    {
        $where = $this->request->params(['date','order_sn','status','keywords','bill_status']);
        $page = 1;
        $limit = 9999999;
        $temporaryData = $this->repository->GetSuOrder($where,$page,$limit);
        $data = $temporaryData['list'];
        $arr = [];
        foreach ($data as $item) {
            $arr[] = [
                $item['uid'],
                $item['order_sn'],
                $item['pid'],
                $item['status'],
                $item['goods_id'],
                $item['goods_name'],
                $item['goods_thumb'],
                $item['goods_count'],
                $item['cust_no'],
                $item['order_time'],
                $item['pay_time'],
                $item['change_time'],
                $item['settled_time'],
                $item['refund_time'],
                $item['total_amount'],
                $item['pay_amount'],
                $item['commission_rate'],
                $item['commission'],
                $item['pre_commission'],
                $item['bill_status'],
                $item['bill_create_time'],
                $item['bill_end_time'],
                $item['create_time'],
                $item['gzc'],
                $item['user_address_ids'],
                $item['pv'],
            ];
        }
        $header = [
            '用户ID',
            '订单行号',
            '第三方标示',
            '订单状态名称',
            '商品ID',
            '商品名称',
            '商品图片',
            '数量',
            '推广会员编码',
            '下单时间',
            '支付时间',
            '变动时间',
            '结算时间',
            '退款时间',
            '订单金额',
            '实付金额',
            '佣金比例',
            '佣金金额',
            '预估佣金',
            '结算状态',
            '平台结算时间',
            '可结算日期',
            '创建时间',
            '公证处IN10是否发起0否1是',
            '详细地址串',
            'PV值',
        ];
        $filename = '苏宁订单导出_' . date('YmdHis') . '_' . rand(10000,99999);
        $_instance = SpreadsheetExcelService::instance_xin();
        $_path = $_instance
            ->createOrActive()
            ->setExcelHeader($header)
            ->setExcelTile('苏宁订单明细', $filename, '生成时间: ' . date('Y-m-d H:i:s'))
            ->setExcelContent($arr)
            ->excelSave($filename, 'xlsx', 'extract');
        $domain = request()->domain();
        return [
            'name' => $filename . '.xlsx',
            'status' => 200,
            'path' => $domain . '/' . $_path
        ];
    }
    public function getTbOrder()
    {
        $where = $this->request->params(['date','order_sn','tk_status','keywords','bill_status']);
        $page = 1;
        $limit = 9999999;
        $temporaryData = $this->repository->GetTbOrder($where,$page,$limit);
        $data = $temporaryData['list'];
        $arr = [];
        foreach ($data as $item) {
            $arr[] = [
                $item['order_tb_id'],
                $item['uid'],
                $item['pid'],
                $item['type'],
                $item['order_sn'],
                $item['trade_id'],
                $item['pub_id'],
                $item['item_id'],
                $item['item_img'],
                $item['item_title'],
                $item['item_num'],
                $item['item_price'],
                $item['seller_shop_title'],
                $item['pay_price'],
                $item['alipay_total_price'],
                $item['tk_status'],
                $item['create_time'],
                $item['tk_earning_time'],
                $item['pub_share_rate'],
                $item['tk_total_rate'],
                $item['income_rate'],
                $item['commission_rate'],
                $item['commission'],
                $item['bill_status'],
                $item['bill_create_time'],
                $item['bill_end_time'],
                $item['gzc'],
                $item['user_address_ids'],
                $item['pv'],
            ];
        }
        $header = [
            '订单表ID',
            '用户ID',
            'PID',
            '类型',
            '订单号',
            '交易号',
            '推广者ID',
            '商品ID',
            '商品图片',
            '商品名称',
            '数量',
            '单价',
            '店铺名称',
            '支付金额',
            '拍下付款金额',
            '订单状态',
            '下单时间',
            '订单确认收货后且商家完成佣金支付的时间',
            '从结算佣金中分得的收益比率',
            '提成=收入比率*分成比率。指实际获得收益的比率',
            '订单结算的佣金比率+平台的补贴比率',
            '佣金比率',
            '佣金金额=结算金额*佣金比率',
            '0平台未结算1已结算2失效',
            '平台结算时间',
            '平台可结算日期',
            '公证处IN10是否发起0否1是',
            '详细地址串',
            'PV值',
        ];
        $filename = '淘宝订单导出_' . date('YmdHis') . '_' . rand(10000,99999);
        $_instance = SpreadsheetExcelService::instance_xin();
        $_path = $_instance
            ->createOrActive()
            ->setExcelHeader($header)
            ->setExcelTile('淘宝订单明细', $filename, '生成时间: ' . date('Y-m-d H:i:s'))
            ->setExcelContent($arr)
            ->excelSave($filename, 'xlsx', 'extract');
        $domain = request()->domain();
        return [
            'name' => $filename . '.xlsx',
            'status' => 200,
            'path' => $domain . '/' . $_path
        ];
    }
    public function getHfOrder()
    {
        $where = $this->request->params(['date','order_sn','status','keywords','bill_status']);
        $page = 1;
        $limit = 9999999;
        $temporaryData = $this->repository->GetHfOrder($where,$page,$limit);
        $data = $temporaryData['list'];
        $arr = [];
        foreach ($data as $item) {
            $arr[] = [
                $item['order_huafei_id'],
                $item['uid'],
                $item['mobile'],
                $item['commission'],
                $item['commission_share'],
                $item['order_number'],
                $item['order_sn'],
                $item['amount_price'],
                $item['fanli_price'],
                $item['cost_price'],
                $item['arrived_amount'],
                $item['pay_money'],
                $item['create_time'],
                $item['finish_time'],
                $item['modify_time'],
                $item['status'],
                $item['bill_status'],
                $item['bill_create_time'],
                $item['bill_end_time'],
                $item['gzc'],
                $item['pv'],
                $item['is_independentaccount'],
            ];
        }
        $header = [
            '订单ID',
            '用户ID',
            '充值手机号',
            '佣金',
            '佣金比例',
            '平台订单号',
            '本地订单号',
            '充值金额',
            '返利金额',
            '成本金额',
            '到账金额',
            '实际金额',
            '创建时间',
            '完成时间',
            '更新时间',
            '订单状态',
            '结算状态',
            '平台结算时间',
            '可结算日期',
            '公证处IN10是否发起0否1是',
            'PV值',
            '是否分账0否1是',
        ];
        $filename = '话费订单导出_' . date('YmdHis') . '_' . rand(10000,99999);
        $_instance = SpreadsheetExcelService::instance_xin();
        $_path = $_instance
            ->createOrActive()
            ->setExcelHeader($header)
            ->setExcelTile('话费订单明细', $filename, '生成时间: ' . date('Y-m-d H:i:s'))
            ->setExcelContent($arr)
            ->excelSave($filename, 'xlsx', 'extract');
        $domain = request()->domain();
        return [
            'name' => $filename . '.xlsx',
            'status' => 200,
            'path' => $domain . '/' . $_path
        ];
    }
}