<?php

namespace App\Model;

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

class UploadGoodsModel extends Model
{
    protected $table='upload_goods';
    public $timestamps = false;

    public function UploadGoods($data,$realPath,&$ID=0){
        DB::connection($this->connection)->beginTransaction();
        $data['update_time'] = time();
        $data['add_time'] = $data['update_time'];
        $result = $this->insertGetId($data);
        if(!$result)
            return false;
        $ID = $result;
        $Model = new ExcelModel();
        $result = $Model->HdExcel($realPath,$result);
        if($result !== true)
            return $result;
        DB::connection($this->connection)->commit();
        return true;
    }

    public function UploadGoodsList($map,$limit){
        $list = $this->where($map)->select('id','add_time','update_time','status','file_info','loginfo')
            ->orderBy('id','desc')
            ->paginate($limit)->toArray();
        if(!$list)
            return false;
        $status = config('config.upload_goods_status');
        foreach ($list['data'] as $k=>&$v){
            $v['status'] = $status[$v['status']];
            $v['add_time'] = date('Y-m-d H:i',$v['add_time']);
            $v['update_time'] = date('Y-m-d H:i',$v['update_time']);
            $v['file_info'] = json_decode($v['file_info'],true);
        }

        return $list;
    }
}