<?php
namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use Request;
use Excel;
use DB;

class PayLogModel extends Model
{
	protected $connection = 'order';
    protected $table = 'lie_pay_log';
    protected $primaryKey = 'pay_log_id';
    public $timestamps = false;

   	// 获取联营、自营线上支付记录 (过滤尽调订单、测试账号)
    public function getPayLog($start_time, $end_time)
    {
    	$field = ['p.pay_log_id', 'p.order_id', 'p.order_sn', 'p.user_id', 'p.pay_type', 'p.is_paid', 'p.pay_amount', 'p.pay_time', 'o.currency']; 
        $data = $this->from('lie_pay_log as p')
                ->leftJoin('lie_order as o', 'p.order_id', '=', 'o.order_id')
                ->leftJoin('lie_user_main as u', 'p.user_id', '=', 'u.user_id')
                ->where('p.is_paid', 1)
                ->whereBetween('p.pay_time', [$start_time, $end_time])
                ->where('o.status', '>', 2)
                ->where('o.is_type', 0)
                ->where('u.is_test', 0)
                ->select($field)
                // ->select('user_id', DB::raw('sum(pay_amount) as pay_amount'))
                ->orderBy('p.pay_time', 'desc')
                // ->groupBy('user_id')
                ->get()
                ->toArray();

        return $data;
    }

}