<?php
namespace App\Model;

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

class ErpPayLogModel extends Model
{
	protected $connection = 'order';
    protected $table = 'lie_erp_pay_log';
    protected $primaryKey = 'log_id';
    public $timestamps = false;

    // 联营线下支付记录
    public function getErpPayLog($start_time, $end_time)
    {
    	$field = ['log_id', 'order_id', 'order_sn', 'user_id', 'receipt_sn', 'receipt_amount', 'currency', 'status', 'receipt_time', 'create_time'];
        $data = $this->where('status', 1)
                ->whereBetween('create_time', [$start_time, $end_time])
                ->select($field)
                ->orderBy('create_time', 'desc')
                ->get()
                ->toArray();

        return $data;
    }

}