<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\MpPlanning;
use App\Models\Project;
use App\Models\Rab;
use App\Models\RabDetail;
use App\Models\AhsDetailUpah;
use App\Models\AhsKategori;
use App\Http\Controllers\RoleController;
use Illuminate\Support\Facades\Auth;

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

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
    	
    	if(Auth::user()->level == 'ARSITEK' || Auth::user()->level == 'DRAFTER' || Auth::user()->level == 'QUANTITY SURVEYOR' || Auth::user()->level == 'SUPERVISI - ALUMNI') {
        $rab = Rab::whereDoesntHave('mp_planning')->whereHas('client', function($q){
        	$q->where('id_user', Auth::user()->id);
        })->get();
        } else {
        $rab = Rab::whereDoesntHave('mp_planning')->get();
        }
        
        return view('staff.mp-planning-create', compact('rab'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
         $id = $request->get('id_rab');
        $mp_planning = MpPlanning::where('id_rab',$id)->first();
        if ($mp_planning) {
            $mp_planning->jumlah_tukang = $request->jumlah_tukang;
            $mp_planning->upah_tukang_rata_rata = str_replace('.', '', $request->upah_tukang_rata_rata);
            $mp_planning->save();
        }else{
            MpPlanning::create([
                'id_rab' => $id,
                'jumlah_tukang' => $request->jumlah_tukang,
                'upah_tukang_rata_rata' => str_replace('.', '', $request->upah_tukang_rata_rata),
                'id_user' => Auth::user()->id
            ]);
        }
        return redirect()->route('mp_planning.show',$id)->with('msg','MP Planning 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'] == 'mpplanningdata') {
                    $columns = array(
                        0 => 'id',
                    );

		if(Auth::user()->level == 'ARSITEK' || Auth::user()->level == 'DRAFTER' || Auth::user()->level == 'QUANTITY SURVEYOR' || Auth::user()->level == 'SUPERVISI - ALUMNI') {
			$totalData = MpPlanning::whereHas('rab.client', function($q) {
				$q->where('clients.id_user', Auth::user()->id);
			})->count();
		} else {
                    $totalData = MpPlanning::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'))) {
                        if(Auth::user()->level == 'ARSITEK' || Auth::user()->level == 'DRAFTER' || Auth::user()->level == 'QUANTITY SURVEYOR' || Auth::user()->level == 'SUPERVISI - ALUMNI') {
                            $rabs = MpPlanning::whereHas('rab.client', function($q) {
                                $q->where('clients.id_user', Auth::user()->id);
                            })
                            ->offset($start)
                            ->limit($limit)
                            ->orderBy($order, $dir)
                            ->get();
                        } else {
                            $rabs = MpPlanning::offset($start)
                                ->limit($limit)
                                ->orderBy($order, $dir)
                                ->get();
                        }
                    }else{
                        $search        = $request->input('search.value');
                        if(Auth::user()->level == 'ARSITEK' || Auth::user()->level == 'DRAFTER' || Auth::user()->level == 'QUANTITY SURVEYOR' || Auth::user()->level == 'SUPERVISI - ALUMNI') {
                            $rabs = MpPlanning::whereHas('rab.client', function($q) {
                                $q->where('clients.id_user', Auth::user()->id);
                            })->orWhereHas('rab', function($q) use($search) {
                                $q->where('nama_rab', 'LIKE', "%{$search}%");
                            })
                            ->offset($start)
                            ->limit($limit)
                            ->orderBy($order, $dir)
                            ->get();
    
                            $totalFiltered = MpPlanning::whereHas('rab.client', function($q) {
                                $q->where('clients.id_user', Auth::user()->id);
                            })->orWhereHas('rab', function($q) use($search) {
                                $q->where('nama_rab', 'LIKE', "%{$search}%");
                            })
                            ->count();
                        } else {
                            $rabs = MpPlanning::whereHas('rab', function($q) use($search) {
                                $q->where('nama_rab', 'LIKE', "%{$search}%");
                            })
                                ->offset($start)
                                ->limit($limit)
                                ->orderBy($order, $dir)
                                ->get();
    
                            $totalFiltered = MpPlanning::whereHas('rab', function($q) use($search) {
                                $q->where('nama_rab', 'LIKE', "%{$search}%");
                            })
                                ->count();   
                        }
                    }
                    $data = array();
                    if (!empty($rabs)) {
                        foreach ($rabs as $row) {
                            $nestedData['rab']       = $row->rab->nama_rab;
                            $nestedData['target']        = round(MpPlanningController::getTarget($row->id_rab),2).' hari';
                            $nestedData['jumlah_tukang'] = $row->jumlah_tukang;
                            $nestedData['upah'] = 'Rp' . number_format($row->upah_tukang_rata_rata,2,',','.');
                            if($row->id_user != NULL) {
                            $nestedData['created_by'] = $row->user->fullname;
                            } else {
                            	$nestedData['created_by'] = '';
                            }
                            $nestedData['opsi'] = '';
                            if(RoleController::access('mp_planning', 'edit') > 0) {
                            $nestedData['opsi'] .= "<a href=".route('mp_planning.edit',$row->id_rab)." class='btn btn-warning btn-xs'>
                                    <i class='fa fa-pencil'></i>
                                    edit
                                </a>";
                            }
                            if(RoleController::access('mp_planning', 'delete') > 0) {
                            $nestedData['opsi'] .= "
                              <form action=".route('mp_planning.destroy',$row->id)." method='POST'>
                                " . csrf_field() . "
                                " . method_field('delete') . "
                                <button class='btn btn-danger btn-xs'  onclick=\"return confirm('Hapus Data Mp Planning ".$row->rab->nama_rab." ?')\" type='submit'>
                                    <i class='fa fa-trash'></i>
                                    delete
                                </button>
                            </form>";
                        }
                        if(RoleController::access('mp_planning', 'view') > 0) {
                            $nestedData['opsi'] .= "<a href=".route('mp_planning.show',$row->id_rab)." class='btn btn-primary btn-xs'>
                                    <i class='fa fa-link'></i>
                                    detail
                                </a>";
                            }
                            $data[]                    = $nestedData;
                        }
                    }

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

                    echo json_encode($json_data);
               }
            }
        }else{
            $rab = Rab::findOrFail($id);
            $rabDetails = AhsKategori::with(['subkategoris.ahsS' => function($q) use ($rab){
                $q->whereHas('rabDetail',function($q2) use ($rab){                        
                    $q2->where('id_rab',$rab->id);
                })->with(['rabDetail' => function($q2) use ($rab){
                    $q2->where('id_rab',$rab->id);
                }]);
            }])->with(['subkategoris.vendors' => function($q) use ($rab){
                $q->whereHas('rabDetail',function($q2) use ($rab){                        
                    $q2->where('id_rab',$rab->id);
                })->with(['rabDetail' => function($q2) use ($rab){
                    $q2->where('id_rab',$rab->id);
                }]);
            }])->orderBy('urutan','asc')->get();
            return view('staff.mp-planning-detail',compact('rab','rabDetails'));
        }
    }
    public static function getTotalUpah($id_ahs,$id_rab)
    {
        $rab = Rab::where('id',$id_rab)->first();
        if ($rab) {
            $total_upah = AhsDetailUpah::selectRaw('sum(ahs_detail_upah.koefisien * upah.upah) as total')
            ->join('upah','ahs_detail_upah.id_upah','upah.id')
            ->where('id_ahs',$id_ahs)->first()->total;
            if ($rab->id) {
                $rab_detail = RabDetail::where([['id_ahs',$id_ahs],['id_rab',$rab->id]])->first();
                if ($rab_detail) {
                    return $total_upah * $rab_detail->volume;
                }else{
                    return 0;
                }
            }else{
                return 0;
            }
        }
    }
    public static function getMpPlanning($id_ahs,$id_rab)
    {
        $rab = Rab::where('id',$id_rab)->first();
        if ($rab) {
            $mp_planning = MpPlanning::where('id_rab',$rab->id)->first();
            if ($mp_planning) {
                $total_upah = MpPlanningController::getTotalUpah($id_ahs,$id_rab);
                return $total_upah / ($mp_planning->jumlah_tukang * $mp_planning->upah_tukang_rata_rata);
            }else{
                return 0;
            }
        }else{
            return '-';
        }
    }
    public static function getTarget($id_rab)
    {
        $rab = Rab::where('id',$id_rab)->first();
        $mp_planning = 0;
        foreach ($rab->rabDetails as $row) {
            $mp_planning += MpPlanningController::getMpPlanning($row->id_ahs,$rab->id);
        }   
        return $mp_planning;
    }
    /**
     * 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 ($rab){
                $q->whereHas('rabDetail',function($q2) use ($rab){                        
                    $q2->where('id_rab',$rab->id);
                })->with(['rabDetail' => function($q2) use ($rab){
                    $q2->where('id_rab',$rab->id);
                }]);
            }])->with(['subkategoris.vendors' => function($q) use ($rab){
                $q->whereHas('rabDetail',function($q2) use ($rab){                        
                    $q2->where('id_rab',$rab->id);
                })->with(['rabDetail' => function($q2) use ($rab){
                    $q2->where('id_rab',$rab->id);
                }]);
            }])->orderBy('urutan','asc')->get();
            return view('staff.mp-planning-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)
    {
        $mp_planning = MpPlanning::where('id_rab',$id)->first();
        if ($mp_planning) {
            $mp_planning->jumlah_tukang = $request->jumlah_tukang;
            $mp_planning->upah_tukang_rata_rata = str_replace('.', '', $request->upah_tukang_rata_rata);
            $mp_planning->save();
        }else{
            MpPlanning::create([
                'id_rab' => $id,
                'jumlah_tukang' => $request->jumlah_tukang,
                'upah_tukang_rata_rata' => str_replace('.', '', $request->upah_tukang_rata_rata),
            ]);
        }
        return redirect()->route('mp_planning.show',$id)->with('msg','MP Planning berhasil dibuat');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
       	MpPlanning::destroy($id);
       	return redirect()->route('mp_planning.index')->with('msg', 'Mp Planning Berhasil Dihapus');
    }

    public function getRab(Request $request) {
        $id_rab = $request->get('id_rab');

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

            $html = '';
            $html .= '<div class="form-group">
                	<div class="scroll">
                        <table id="table-data" class="table">';
                            $total =  0;
                            $total_planning = 0;
                            foreach($rabDetails as $row) {
	                            $tampilkan_kategori = false;
	                            foreach($row->subkategoris as $row2) {
	                                if($row2->ahsS->count() > 0 or $row2->vendors->count() > 0) {
	                                    $tampilkan_kategori = true;
                                    }
                                }
            $html .= '<thead>';
                            if($tampilkan_kategori) {
                            $html .= '<tr style="background-color: #ddd;font-weight: bold;">
                                    <td colspan="9" style="font-size: 17px;">'.
                                        $row->nama_kategori
                                    .'</td>
                                </tr>';
                            }
                            foreach($row->subkategoris as $row2) {
                                if($row2->ahsS->count() > 0 or $row2->vendors->count() > 0) {
                                $html .= '<tr style="background-color: #FBD232">
                                   <td colspan="9" style="font-size: 15px;font-weight: 600">'.
                                       $row2->nama_subkategori
                                   .'</td>     
                                </tr>
                                <tr>
                                    <th >Pekerjaan</th>
                                    <th >Dimensi & Spesifikasi</th> 
                                    <th>
                                        Deskripsi
                                    </th>
                                    <th >Volume</th>
                                    <th >Satuan</th>
                                    <th >Harga Satuan</th>
                                    <th class="text-right">Total Harga</th>
                                    <th>
                                    	Total Upah
                                    </th>
                                    <th>
                                        Target Hari
                                    </th>
                                </tr>
                            </thead>
                            <tbody>';
                        	$subtotal = 0;
                               	foreach($row2->ahsS as $row3) {
                            $html .= '<tr>
                                    <td>'.
                                       $row3->nama_pekerjaan
                                    .'</td>
                                    <td>'.
                                       $row3->dimensi_spesifikasi
                                    .'</td>
                                    <td>'.
                                        $row3->rabDetail->deskripsi
                                    .'</td>
                                    <td>'.
                                        $row3->rabDetail->volume
                                    .'</td>
                                    <td>'.
                                        $row3->satuan
                                    .'</td>
                                    <td>'.
                                        'Rp'. number_format($row3->rabDetail->harga,0,"",".")
                                    .'</td>
                                    <td class="text-right">'.
                                        'Rp'. number_format($row3->rabDetail->subtotal,0,"",".")
                                    .'</td>
                                    <td>
                                    	Rp'. number_format(MpPlanningController::getTotalUpah($row3->id,$rab->id),0,"",".")
                                    .'</td>
                                    <td>
                                    	<span class="mp_planning" total-upah="'. MpPlanningController::getTotalUpah($row3->id,$rab->id).'">'.
                                    		round(MpPlanningController::getMpPlanning($row3->id,$rab->id),2)
                                    	.'</span>
                                    </td>
                                </tr>';
                                $total_planning += MpPlanningController::getMpPlanning($row3->id,$rab->id);
                                $subtotal += $row3->rabDetail->subtotal;
                                   }
	                            foreach($row2->vendors as $row3) {
                                $html .= '<tr>
                                    <td>'.
                                       $row3->vendor->nama_pekerjaan
                                    .'</td>
                                    <td>'.
                                       $row3->vendor->dimensi_spesifikasi
                                    .'</td>
                                    <td>'.
                                        $row3->rabDetail->deskripsi
                                    .'</td>
                                    <td>'.
                                        $row3->rabDetail->volume
                                    .'</td>
                                    <td>'.
                                        $row3->vendor->satuan
                                    .'</td>
                                    <td>
                                        Rp'.number_format($row3->rabDetail->harga,0,"",".")
                                    .'</td>
                                    <td class="text-right">
                                        Rp'. number_format($row3->rabDetail->subtotal,0,"",".")
                                    .'</td>
                                    <td>
                                    	-
                                    </td>
                                    <td>
                                    	-
                                    </td>
                                </tr>';
                                $total_planning += MpPlanningController::getMpPlanning($row3->id,$rab->id);
                                $subtotal += $row3->rabDetail->subtotal;
                                }
                             $html .= '<tr>
                                    <th colspan="6" class="text-right">
                                        Subtotal : 
                                    </th>
                                    <td class="text-right">
                                        Rp'. number_format($subtotal,0,"",".")
                                    .'</td>
                                    <td colspan="2">&nbsp;</td>
                                </tr>';
                                $total += $subtotal;
                            }
                        }
                         $html .= '</tbody>';
                    }
                        $html .=  '<tr>
                                <th colspan="6" class="text-right">
                                    Total : 
                                </th>
                                <td class="text-right">
                                    Rp' .number_format($total,0,"",".")
                                .'</td>
                                <td >&nbsp;</td>
                                <td>
                                    <span id="total_planning">'.
                                        round(MpPlanningController::getTarget($rab->id),2)
                                    .'</span>
                                </td>
                            </tr>
                        </table>
                    </div>
                </div>
                <div class="ln_solid"></div>
                <div class="form-group text-right">
                <div class="form-group text-right">';
                    if (RoleController::access('mp_planning', 'create') > 0) {
                    $html .= '<button class="btn btn-primary" type="submit" >Save</button>
                    <button class="btn btn-danger" type="reset">
                        Cancel
                    </button>';
                    }
                $html .= '</div>';
                echo $html;
    }
}