surveyor_indonesia_backend/app/Http/Controllers/ProjectMileStoneController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\ProjectMileStone;
use App\Models\Activity;

class ProjectMileStoneController extends Controller
{
    public function add(Request $request)
    {
        $this->validate($request, [
            'proyek_id'     => 'required',
            'status'        => 'required',
            'due_date'      => 'required',
            'deadline'      => 'required'
        ]);

        $data = $request->all();

        $data['created_by'] = $this->currentName;

        $result = ProjectMileStone::create($data);

        if($result){
            return response()->json(['status'=>'success','message'=>'add data project milestone successfully!','code'=>200], 200);
        }else{
            return response()->json(['status'=>'failed','message'=>'add data project milestone failed!','code'=>400], 400);
        }
    }

    public function edit($id){
        if(!$id || (int) $id < 0 || $id==""){
            return response()->json(['status'=>'failed','message'=>'id is required!','code'=>400], 400);
            die();
        }

        $result = ProjectMileStone::find($id);

        if($result){
            return response()->json(['status'=>'success','code'=>200,'data'=>$result], 200);
        }else{
            return response()->json(['status'=>'failed','message'=>'failed get data project milestone, please try again later!','code'=>400], 400);
        }
    }

    public function update(Request $request, $id)
    {
        if(!$id || (int) $id < 0 || $id==""){
            return response()->json(['status'=>'failed','message'=>'id is required!','code'=>400], 400);
        }

        $data = ProjectMileStone::find($id);

        if($data){
            $result = $data->update($request->all());
        }else{
            return response()->json(['status'=>'failed','message'=>'data project milestone not found!','code'=>400], 400);
            die();
        }
        
        
        if($result){
            return response()->json(['status'=>'success','message'=>'data project milestone successfully updated!','code'=>200], 200);
        }else{
            return response()->json(['status'=>'failed','message'=>'data project milestone failed updated!','code'=>400], 400);
        }
    }

    public function delete($id)
    {
        $data = ProjectMileStone::find($id);

        if($data){
            $delete = $data->delete();
        }else{
            return response()->json(['status'=>'failed','message'=>'data project milestone not found!','code'=>400], 400);
            die();
        }
        

        if($delete){
            return response()->json(['status'=>'success','message'=>'data project milestone successfully deleted!','code'=>200], 200);
        }else{
            return response()->json(['status'=>'failed','message'=>'data project milestone failed deleted!','code'=>400], 400);
        }
    }

    public function deleteByProyek($id)
    {
        $data = ProjectMileStone::where('proyek_id', $id)->delete();  

        if($data){
            return response()->json(['status'=>'success','message'=>'data project milestone successfully deleted!','code'=>200], 200);
        }else{
            return response()->json(['status'=>'success','message'=>'data project milestone failed deleted, because data not found!','code'=>200], 200);
        }
    }

    public function customWhere($where, $val)
    {
        $data = ProjectMileStone::where($where, $val)->orderBy('id', 'asc')->get();  

        if($data){
            return response()->json(['status'=>'success','data'=> $data,'code'=>200], 200);
        }else{
            return response()->json(['status'=>'success','message'=>'data project milestone not found!','code'=>400], 40);
        }
    }

    public function search(Request $request)
    {
        $payload = $request->all();
        $dataBuilder = $this->setUpPayload($payload, 'project_milestone');
        $builder = $dataBuilder['builder'];
        $countBuilder = $dataBuilder['count'];
        $dataGet = $builder->get();
        $totalRecord = $countBuilder->count();
        return response()->json(['status'=>'success','code'=>200,'data'=>$dataGet, 'totalRecord'=>$totalRecord], 200);
    }

    public function list()
    {
        $data = ProjectMileStone::all();
        $countData = $data->count();

        if($data){
            return response()->json(['status'=>'success','code'=>200,'data'=>$data, 'totalRecord'=>$countData], 200);
        }else{
            return response()->json(['status'=>'failed','message'=>'failed get list project milestone, please try again later!','code'=>400], 400);
        }
    }

    public function select(Request $request)
    {
        $search = $request->query('search');
        $idProject = (int)$request->query('idProject');
        $ganttId = (int)$request->query('idGantt');
        
        $forbidden = [];

        if($idProject && $idProject > 0 && $ganttId && $ganttId > 0){
            $dataF = Activity::select("name")->where("type_activity", "milestone")->where("version_gantt_id", $ganttId)->where("proyek_id", $idProject)->get();
            foreach($dataF as $val){
                $forbidden[] = $val->name;
            }
        }

        if($search && !empty($search)){
            $data = ProjectMileStone::where("proyek_id", $idProject)->where("status", 'like', '%'.$search.'%')->whereNotIn("status", $forbidden)->get();
        }else{
            $data = ProjectMileStone::where("proyek_id", $idProject)->whereNotIn("status", $forbidden)->get();
        }

        return response()->json($data);
    }
}