<?php namespace App\Model; use Illuminate\Database\Eloquent\Model; use Request; use Excel; use DB; class OrderItemsTrackModel extends Model { protected $connection = 'order'; protected $table = 'lie_order_items_track'; protected $primaryKey = 'track_items_id'; protected $guarded = ['amount_id']; public $timestamps = true; const CREATED_AT = 'create_time'; public function fromDateTime($value) { return strtotime(parent::fromDateTime($value)); } // 获取最新的明细跟踪 public function getLastItemTrack($rec_id) { return $this->where('rec_id', $rec_id)->select('track_items_id', 'order_id', 'track_content', 'track_num', 'create_name', 'create_time')->orderBy('create_time', 'desc')->first(); } // 获取所有明细跟踪 public function getOrderItemsTrack($rec_id) { return $this->where('rec_id', $rec_id)->select('track_items_id', 'order_id', 'track_content', 'track_num', 'create_name', 'create_time')->orderBy('create_time', 'desc')->get(); } }