<?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\Clo;
use App\Models\Ahs;
use App\Models\LabourOrder;
use App\Models\LabourOrderHarian;
use App\Models\LabourOrderBorongan;
use Illuminate\Support\Facades\Auth;

class CloController 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') { 
        $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-lo',compact('rabs'));     
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }
    public static function totalAnggaran($id)
    {
        $totalAnggaran = Clo::join('upah','clo.id_upah','upah.id')
        ->selectRaw('sum(upah.upah * clo.qty_anggaran) as totalAnggaran')->where('id_rab',$id)->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'] == 'pekerjaanDetail') {
                $id_upah = $_GET['id_upah'];
                $pekerjaans = Ahs::join('rab_detail','ahs.id','rab_detail.id_ahs')
                ->select('ahs.id','ahs.nama_pekerjaan','rab_detail_upahs.qty')
                ->join('rab_detail_upahs','rab_detail.id','rab_detail_upahs.id_rab_detail')
                ->join('upah','rab_detail_upahs.id_upah','upah.id')
                ->where([['rab_detail.id_rab',$id],['upah.id',$id_upah]])
                ->groupBy('ahs.id','ahs.nama_pekerjaan','rab_detail_upahs.qty')
                ->get();
                return response()->json(['pekerjaans' => $pekerjaans]);
            }

        }else{
            $los = LabourOrder::where([['id_project',$id],['status','closed']])->get();
            return view('staff.c-lo-detail',compact('los'));
        }
    }

    /**
     * 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)
    {
        //
    }

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

    public static function getUpahTerbayar($id)
    {
        $total = LabourOrderHarian::selectRaw('sum(total_upah) as total')
        ->join('labour_order','labour_order_harian.id_labour_order','labour_order.id')
        ->where([
            ['labour_order.id_project',$id],
            ['labour_order.status','closed']
        ])
        ->first()->total;

        $total += LabourOrderBorongan::selectRaw('sum(total_upah) as total')
        ->join('labour_order','labour_order_borongan.id_labour_order','labour_order.id')
        ->where([
            ['labour_order.id_project',$id],
            ['labour_order.status','closed']
        ])
        ->first()->total;

        return $total;
    }
}