<?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; }
}