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

}