<?php

namespace App\Http\Controllers;

use App\SymbolicTicket;
use App\SymbolicTicketPrice;
use Datatables;
use DB;

use Illuminate\Http\Request;

class SymbolicTicketPriceController extends Controller
{

    public function index($id){
        $obj = SymbolicTicket::find($id);
        return view("symbolic_tickets_price.index_symbolic_tickets_prices", compact('obj'));
    }

    public function create($symbolic_ticket_id){
        return view("symbolic_tickets_price.add_symbolic_tickets_price", compact('symbolic_ticket_id'));
    }

    public function edit($id){
        $obj = SymbolicTicketPrice::find($id);

        return view("symbolic_tickets_price.edit_symbolic_tickets_price", compact('obj'));
    }

    public function add(Request $request){
        $obj = new SymbolicTicketPrice;
        $obj->price = $request['price'];
        $obj->comment = $request['comment'];
        $obj->symbolic_ticket_id = $request['symbolic_ticket_id'];

        $obj->save();

        return array('r' => true, 'm' => trans('messages.symbolic_tickets.to_create'), 'd' => $obj->id);
    }
    public function update(Request $request){

        $obj = SymbolicTicketPrice::find($request['id']);

        $obj->price = $request['price'];
        $obj->comment = $request['comment'];

        $obj->update();

        return array('r' => true, 'm' => trans('messages.symbolic_tickets.to_update'), 'd' => $obj->id);
    }


    public function tableFilterPrices(Request $request){
        $obj = $obj = DB::table('symbolic_ticket_prices')
        ->select('symbolic_ticket_prices.id', 'symbolic_ticket_prices.price', 'symbolic_ticket_prices.comment')
        ->where('symbolic_ticket_id', $request['id']);

    return Datatables::of($obj)
      ->addColumn('actions', function ($obj) {
            return
            '<i class="fa fa-pencil iconMini " onClick="clickEditSymbolicTicket(' . $obj->id . ')" data-id="' . $obj->id . '"  title="Editar"></i>';

        })
        ->rawColumns(['actions'])
        ->make(true);
    }
}