<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Rab;
use App\Models\RabDetail;
use App\Models\RabDetailMandor;
use App\Models\AhsKategori;
use Illuminate\Support\Facades\Auth;

class RabMandorController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return view('staff.rab-mandor');
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $rabs = Rab::whereDoesntHave('rabDetailsMandor')->where('status','approve')->get();
        return view('staff.rab-mandor-create',compact('rabs'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        if ($request->rab_details) {
            foreach ($request->rab_details as $key => $value) {
                $rd = RabDetail::where('id',$value)->first();
                if ($rd) {
                    $rdm = new RabDetailMandor;
                    $rdm->id_rab = $rd->rab->id;
                    $rdm->id_ahs = $rd->id_ahs;
                    $rdm->id_ahs_vendor = $rd->id_ahs_vendor;
                    $rdm->deskripsi = $rd->deskripsi;
                    $rdm->volume = $rd->volume;
                    $rdm->harga = $rd->harga;
                    $rdm->upah = str_replace(".","",$request->upah[$key]);
		    $rdm->subtotal = str_replace(".","",$request->total_upah[$key]);
                    $rdm->save();
                    
                    $rab = Rab::where('id', $rd->rab->id)->first();
                    $rab->id_user_rab_mandor = Auth::user()->id;
                    $rab->save();
                }
            }
        }
        return redirect()->route('rab_mandor.index')->with('msg','RAB Mandor berhasil dibuat');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show(Request $request,$id)
    {
        if (\Request::ajax()) {
            if (isset($_GET['act'])) {
               if ($_GET['act'] == 'rabmandordata') {
                    $columns = array(
                        0 => 'id',
                    );

                    $level = Auth::user()->level;
                    if (strtoupper($level) == 'SUPERADMIN' || strtoupper($level) == 'GENERAL MANAGER' || strtoupper($level) == 'FINANCE MANAGER' || strtoupper($level) == 'SUPPLY CHAIN MANAGER' || strtoupper($level) == 'MARKETING MANAGER' || strtoupper($level) == 'PROJECT MANAGER') { 

                        $totalData = Rab::whereHas('rabDetailsMandor')->count();

                        $totalFiltered = $totalData;

                        $limit = $request->input('length');
                        $start = $request->input('start');
                        $order = $columns[$request->input('order.0.column')];
                        $dir   = $request->input('order.0.dir');

                        if (empty($request->input('search.value'))) {
                            $rabs = Rab::whereHas('rabDetailsMandor')
                                ->offset($start)
                                ->limit($limit)
                                ->orderBy($order, $dir)
                                ->get();
                        }else{
                            $search        = $request->input('search.value');
                            $rabs = Rab::whereHas('rabDetailsMandor')
                                ->whereHas('client',function($q) use ($search){
                                    $q->where('fullname', 'LIKE', "%{$search}%");
                                })
                                ->offset($start)
                                ->limit($limit)
                                ->orderBy($order, $dir)
                                ->get();

                            $totalFiltered = Rab::whereHas('rabDetailsMandor')
                                ->whereHas('client',function($q) use ($search){
                                    $q->where('fullname', 'LIKE', "%{$search}%");
                                })
                                ->count();   
                        }
                    } else {
                        $totalData = Rab::whereHas('rabDetailsMandor')->where('id_user', Auth::user()->id)->count();

                        $totalFiltered = $totalData;

                        $limit = $request->input('length');
                        $start = $request->input('start');
                        $order = $columns[$request->input('order.0.column')];
                        $dir   = $request->input('order.0.dir');

                        if (empty($request->input('search.value'))) {
                            $rabs = Rab::whereHas('rabDetailsMandor')
                                ->where('id_user', Auth::user()->id)
                                ->offset($start)
                                ->limit($limit)
                                ->orderBy($order, $dir)
                                ->get();
                        }else{
                            $search        = $request->input('search.value');
                            $rabs = Rab::whereHas('rabDetailsMandor')
                                ->whereHas('client',function($q) use ($search){
                                    $q->where('fullname', 'LIKE', "%{$search}%");
                                })
                                ->where('id_user', Auth::user()->id)
                                ->offset($start)
                                ->limit($limit)
                                ->orderBy($order, $dir)
                                ->get();

                            $totalFiltered = Rab::whereHas('rabDetailsMandor')
                                ->whereHas('client',function($q) use ($search){
                                    $q->where('fullname', 'LIKE', "%{$search}%");
                                })
                                ->where('id_user', Auth::user()->id)
                                ->count();   
                        }
                    }
                    $data = array();
                    if (!empty($rabs)) {
                        foreach ($rabs as $row) {
                            $nestedData['client']       = $row->client->fullname;
                            if($row->id_user_rab_mandor == NULL) {
                            $nestedData['created_by'] = '';
                            } else {
                            $nestedData['created_by'] = $row->userRabMandor->fullname;
                            }
                            $nestedData['opsi'] = "<div style='display:inline-flex'>";
                            $nestedData['opsi'] .= "<a href=".route('rab_mandor.show',$row->id)." class='btn btn-primary btn-xs'>
                                    <i class='fa fa-link'></i>
                                    detail
                                </a>";
                               $nestedData['opsi'] .= "<a href=".route('rab_mandor.edit',$row->id)." class='btn btn-success btn-xs'>
                                    <i class='fa fa-edit'></i>
                                    edit
                                </a></div>";

                            $data[]                    = $nestedData;
                        }
                    }

                    $json_data = array(
                        "draw"            => intval($request->input('draw')),
                        "recordsTotal"    => intval($totalData),
                        "recordsFiltered" => intval($totalFiltered),
                        "data"            => $data,
                    );

                    echo json_encode($json_data);
               }elseif ($_GET['act'] == 'detail-rab') {
                    $rab = Rab::findOrFail($id);
                    $rabDetails = AhsKategori::with(['subkategoris.ahsS' => function($q) use ($id){
                        $q->whereHas('rabDetail',function($q2) use ($id){                        
                            $q2->where('id_rab',$id);
                        })->with(['rabDetail' => function($q2) use ($id){
                            $q2->where('id_rab',$id);
                        }]);
                    }])->with(['subkategoris.vendors' => function($q) use ($id){
                        $q->whereHas('rabDetail',function($q2) use ($id){                        
                            $q2->where('id_rab',$id);
                        })->with(['rabDetail' => function($q2) use ($id){
                            $q2->where('id_rab',$id);
                        }]);
                    }])->orderBy('urutan','asc')->get();
                    return view('staff.rab-mandor-create_rabdetail',compact('rab','rabDetails'));
               }
            }
        }else{

            $rab = Rab::findOrFail($id);
            $rabDetails = AhsKategori::with(['subkategoris.ahsS' => function($q) use ($id){
                    $q->whereHas('rabDetailMandor',function($q2) use ($id){                        
                        $q2->where('id_rab',$id);
                    })->with(['rabDetailMandor' => function($q2) use ($id){
                        $q2->where('id_rab',$id);
                    }])->with(['rabDetail' => function($q2) use ($id){
                        $q2->where('id_rab',$id);
                    }]);
                }])->with(['subkategoris.vendors' => function($q) use ($id){
                    $q->whereHas('rabDetailMandor',function($q2) use ($id){                        
                        $q2->where('id_rab',$id);
                    })->with(['rabDetailMandor' => function($q2) use ($id){
                        $q2->where('id_rab',$id);
                    }])->with(['rabDetail' => function($q2) use ($id){
                        $q2->where('id_rab',$id);
                    }]);;
                }])->orderBy('urutan','asc')->get();
            return view('staff.rab-mandor-detail',compact('rab','rabDetails'));
        }
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $rab = Rab::findOrFail($id);
        $rabDetails = AhsKategori::with(['subkategoris.ahsS' => function($q) use ($id){
            $q->whereHas('rabDetailMandor',function($q2) use ($id){                        
                $q2->where('id_rab',$id);
            })->with(['rabDetailMandor' => function($q2) use ($id){
                $q2->where('id_rab',$id);
            }])->with(['rabDetail' => function($q2) use ($id){
                $q2->where('id_rab',$id);
            }]);
        }])->with(['subkategoris.vendors' => function($q) use ($id){
            $q->whereHas('rabDetailMandor',function($q2) use ($id){                        
                $q2->where('id_rab',$id);
            })->with(['rabDetailMandor' => function($q2) use ($id){
                $q2->where('id_rab',$id);
            }])->with(['rabDetail' => function($q2) use ($id){
                $q2->where('id_rab',$id);
            }]);;
        }])->orderBy('urutan','asc')->get();

        return view('staff.rab-mandor-edit',compact('rab','rabDetails'));   
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        if ($request->rab_detail_mandor) {
            foreach ($request->rab_detail_mandor as $key => $value) {
                $rdm = RabDetailMandor::where('id',$value)->first();
                $rdm->upah = str_replace(".","",$request->upah[$key]);
                $rdm->subtotal = str_replace(".","",$request->total_upah[$key]);
                $rdm->save();
            }           
        }
        if ($request->removed_item) {
            foreach ($request->removed_item as $key => $value) {
                $rdm = RabDetailMandor::where('id',$value)->delete();
            }           
        }   
        return redirect()->route('rab_mandor.show',$id)->with('msg','Data berhasil diperbarui');
    }

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