<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Rab;
use App\Models\RabDetail;
use App\Models\RabDetailMaterial;
use App\Models\RabDetailUpah;
use App\Models\Crap;
use App\Models\Ahs;
use Illuminate\Support\Facades\Auth;

class CrapController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $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' || strtoupper($level) == 'SUPPLY CHAIN STAFF') {
        $rabs = Rab::where([['status','approve'],['id_project','<>',null]])->get();
        } else {
            $rabs = Rab::where([['status','approve'],['id_project','<>',null],['id_user', Auth::user()->id]])->get();
        }
        return view('staff.c-rap',compact('rabs'));      
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }
    public static function totalAnggaran($id)
    {
        $totalAnggaran = Crap::join('materials','crap.id_material','materials.id')
        ->selectRaw('sum(materials.harga * crap.qty_anggaran) as totalAnggaran')->where([['id_rab',$id],['id_material','<>',null]])->first()->totalAnggaran;
        $totalAnggaran += Crap::join('vendor','crap.id_vendor','vendor.id')
        ->selectRaw('sum(vendor.harga_modal * crap.qty_anggaran) as totalAnggaran')->where([['id_rab',$id],['id_vendor','<>',null]])->first()->totalAnggaran;
        return $totalAnggaran;
    }
    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        if (isset($_GET['act'])) {
            if ($_GET['act'] == 'crapData') {
                $craps = Crap::where([['id_rab',$id],['id_material','<>',null]])->get();
                return view('staff.c-rap-rabdata',compact('craps'));
            }elseif ($_GET['act'] == 'vendorData') {
                $vendors = Crap::where([['id_rab',$id],['id_vendor','<>',null]])->get();
                return view('staff.c-rap-rabdatav',compact('vendors'));
            }elseif ($_GET['act'] == 'pekerjaanDetail') {
                $id_material = $_GET['id_material'];
                $pekerjaans = Ahs::join('rab_detail','ahs.id','rab_detail.id_ahs')
                ->select('ahs.id','ahs.nama_pekerjaan','rab_detail_materials.qty','materials.satuan')
                ->join('rab_detail_materials','rab_detail.id','rab_detail_materials.id_rab_detail')
                ->join('materials','rab_detail_materials.id_material','materials.id')
                ->where([['rab_detail.id_rab',$id],['materials.id',$id_material]])
                ->groupBy('ahs.id','ahs.nama_pekerjaan','rab_detail_materials.qty','materials.satuan')
                ->get();
                return response()->json(['pekerjaans' => $pekerjaans]);
            }

        }else{
            $craps = Crap::where([['id_rab',$id],['id_material','<>',null]])->get();
            $vendors = Crap::where([['id_rab',$id],['id_vendor','<>',null]])->get();
            return view('staff.c-rap-rabdata',compact('craps','vendors'));
            
        }
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * 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->act == 'update-qty-material') {
            $m = RabDetailMaterial::findOrFail($id);
            $m->qty = $request->qty;
            $m->save();
            return response()->json(['msg' => 'success']);
        }elseif ($request->act == 'update-qty-upah') {
            $m = RabDetailUpah::findOrFail($id);
            $m->qty = $request->qty;
            $m->save();
            return response()->json(['msg' => 'success']);
        }
    }

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