/home2/mshostin/public_html/app/Http/Controllers/ReferenceController.php
<?php

namespace App\Http\Controllers;

use App\Sale;
use App\Client;
use App\Refrence;
use App\Transaction;
use App\PaymentMethod;
use Illuminate\Http\Request;
use App\Http\Requests\ReferenceRequest;

class ReferenceController extends Controller
{
    //
    public function index()
    {
        $ref = Refrence::paginate(25);

        return view('reference.index', compact('ref'));
    }

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

    /**
     * Store a newly created resource in storage.
     *
     * @param  \App\Http\Request\ClientRequest  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request, Refrence $ref)
    {
        $ref->create($request->all());
        
        return redirect()->route('reference.index')->withStatus('Successfully registered customer.');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        $ref = Refrence::with('client')->find($id);
        return view('reference.show', compact('ref'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $ref = Refrence::find($id);
        // dd($ref->toArray());
        return view('reference.edit', compact('ref'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \App\Http\Request\ReferenceRequest  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Refrence $ref)
    {
        $ref->update($request->all());

        return redirect()
            ->route('reference.index')
            ->withStatus('Successfully modified customer.');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy(Refrence $ref)
    {
        $ref->delete();

        return redirect()
            ->route('reference.index')
            ->withStatus('Customer successfully removed.');
    }

    public function printReport($id)
    {
        $ref = Refrence::find($id);
        $trans = Transaction::with('client')->whereHas('client',function($query) use($id)
        {
            $query->where('reference_id',$id);
        })->latest()->get()->groupBy('client_id');
        // dd($trans->toArray());
        return view('reference.print', compact('ref','trans'));
    }
    public function printLedger($id)
    {
        $ref = Refrence::find($id);
        $trans = Transaction::with('client')->whereHas('client',function($query) use($id)
        {
            $query->where('reference_id',$id);
        })->latest()->get();
        // dd($trans->toArray());
        return view('reference.printLedger', compact('ref','trans'));
    }
}