<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Project;
use App\Models\User;
use App\Models\Mandor;
use App\Models\DatabasePekerja;
use App\Http\Controllers\RoleController;

class DatabasePekerjaController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
    	$menu_master = '';
        return view('staff.database-pekerja', compact('menu_master'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $projects = Project::all();
        $pengawasS = User::where('level','SUPERVISI')->get();
        $mandors = Mandor::all();
        $menu_master = '';
        return view('staff.database-pekerja-create',compact('projects','pengawasS','mandors', 'menu_master'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $ktp = $request->ktp?$request->ktp->openFile()->fread($request->ktp->getSize()):null;
        $dbp = DatabasePekerja::create([
            'id_project' => $request->id_project,
            'id_user' => $request->id_user,
            'nama' => $request->nama,
            'no_hp' => $request->no_hp,
            'no_hp_keluarga' => $request->no_hp_keluarga,
            'keahlian' => $request->keahlian,
            'ktp' => $ktp
        ]);
        if ($request->id_mandor) {
            $dbp->id_mandor = $request->id_mandor;
            $dbp->save();
        }
        return redirect()->route('database_pekerja.index')->with('msg','data berhasil ditambahkan');
    }

    /**
     * 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'] == 'datapekerja') {
                    $columns = array(
                        0 => 'id',
                    );

                    $totalData = DatabasePekerja::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'))) {
                        $DatabasePekerjas = DatabasePekerja::offset($start)
                            ->limit($limit)
                            ->orderBy($order, $dir)
                            ->get();

                        $totalFiltered = DatabasePekerja::offset($start)
                            ->limit($limit)
                            ->orderBy($order, $dir)
                            ->count();
                    }else{
                        $search        = $request->input('search.value');
                        $DatabasePekerjas = DatabasePekerja::whereHas('project',function($q) use ($search){
                            $q->where('name', 'LIKE', "%{$search}%");
                        })
                        ->offset($start)
                        ->limit($limit)
                        ->orderBy($order, $dir)
                        ->get();

                        $totalFiltered = DatabasePekerja::whereHas('project',function($q) use ($search){
                            $q->where('name', 'LIKE', "%{$search}%");
                        })
                            ->offset($start)
                            ->limit($limit)
                            ->orderBy($order, $dir)
                            ->count();   
                    }
                    $data = array();
                    if (!empty($DatabasePekerjas)) {
                        foreach ($DatabasePekerjas as $row) {
                            $nestedData['project']       = $row->project->name;
                            $nestedData['pengawas']       = $row->pengawas->fullname;
                            $nestedData['nama']       = $row->nama;
                            $nestedData['nomer_hp']       = $row->no_hp;
                            $nestedData['nomer_hp_keluarga']       = $row->no_hp_keluarga;
                            
                            $nestedData['keahlian']       = $row->keahlian;
                            $nestedData['opsi'] = "<div style='display:inline-flex'>";
                            if(RoleController::access('database_pekerja', 'edit') > 0) {
                            $nestedData['opsi'] .= "<a href=".route('database_pekerja.edit',$row->id)." class='btn btn-success btn-xs'>
                                    <i class='fa fa-edit'></i>
                                    edit
                                </a></div>";
                            }
                            if(RoleController::access('database_pekerja', 'delete') > 0) {
                                $nestedData['opsi'] .= "
                                <form action=".route('database_pekerja.destroy',$row->id)." method='POST'>
                                    " . csrf_field() . "
                                    " . method_field('delete') . "
                                    <button class='btn btn-danger btn-xs'  onclick=\"return confirm('hapus data Pekerja ".$row->nama." ?')\" type='submit'>
                                        <i class='fa fa-trash'></i>
                                        delete
                                    </button>
                                </form>";
                            $data[]                    = $nestedData;
                        }
                        }
                    }

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

                    echo json_encode($json_data);
               }
            }
        }
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $projects = Project::all();
        $pekerja = DatabasePekerja::findOrFail($id);
        $pengawasS = User::where('level','SUPERVISI')->get();
        $mandors = Mandor::all();
        $menu_master = '';
        return view('staff.database-pekerja-edit',compact('projects','pekerja','pengawasS','mandors', 'menu_master'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        DatabasePekerja::where('id',$id)->update([
            'id_project' => $request->id_project,
            'id_user' => $request->id_user,
            'nama' => $request->nama,
            'no_hp' => $request->no_hp,
            'no_hp_keluarga' => $request->no_hp_keluarga,
            'keahlian' => $request->keahlian,
        ]);
        $dbp = DatabasePekerja::findOrFail($id);
        if ($request->id_mandor) {
            $dbp->id_mandor = $request->id_mandor;
            $dbp->save();
        }
        $ktp = $request->ktp?$request->ktp->openFile()->fread($request->ktp->getSize()):null;
        if ($ktp) {
            $dbp->ktp = $ktp;
            $dbp->save();
        }
        return redirect()->route('database_pekerja.index')->with('msg','data berhasil diperbarui');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        DatabasePekerja::destroy($id);
        return redirect()->route('database_pekerja.index')->with('msg','data berhasil dihapus');
    }
}