<?php

namespace App\Http\Controllers;

use App\MeasuringMachine;
use App\Package;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Gate;

class MeasureMonitorController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if(!Gate::allows('包裹信息-查询')){ return redirect(url('/'));  }
        /*$sql='SELECT a.* FROM packages a WHERE id = (SELECT MAX(id) FROM packages WHERE measuring_machine_id = a.measuring_machine_id) ORDER BY a.id';
        $packages=DB::table(DB::raw("($sql) as t"))->get();*/
        $measuring_machine_id=[];
        /*        for ($i=0;$i<count($measuringMachine);$i++){
            $measuring_machine_id[$i]=$measuringMachine[$i]->id;
        }
        dd($measuring_machine_id);*/
        $measuring_machine_id=$request->input('id');
        $measuringMachines=MeasuringMachine::select('id','name','code')->get();
        if (empty($measuringMachines)){
            dd($measuringMachines);
            if (!$measuring_machine_id){
                $package=Package::with('owner','paperBox','measuringMachine')->where('measuring_machine_id',$measuringMachines[0]->id)->orderBy('id','DESC')->first();
            }else{
                $package=Package::with('owner','paperBox','measuringMachine')->where('measuring_machine_id',$measuring_machine_id)->orderBy('id','DESC')->first();
                if (!$package){
                    $measuringMachine=MeasuringMachine::where('id',$measuring_machine_id)->first();
                    $package=new Package();
                    if ($measuringMachine)$package->measuringMachine=$measuringMachine;
                }
            }
        }
        return view('weigh.measureMonitor.index',['package'=>isset($package)?$package:null,'measuringMachines'=>$measuringMachines]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}