join_table

public function filterQuery(Request $request){

    // // $item=$_GET['item'];
    // if(isset($_GET["item"])){
    //     windows.alert("hebat");
 // }

    $age = $request->age;
    $age2 = $request->age2;
    $dataGender = $request->dataGender;
    $ethnicity = $request->ethnicity;
    $area = $request->area;
    $state = $request->state;
    $namaDUN = $request->namaDUN;
    $income = $request->income;


     // $data = DB::table('modified_dpprs')
    //  ->where('Jantina', 'L');

    $query = ModifiedDppr::query();
    $query->join('modified_dpprs2018_algorithm', 'modified_dpprs2018_algorithm.IC', '=', 'modified_dpprs.IC');

    if(!empty($request->age)){
        $query->where('modified_dpprs.modified_dpprs.Umur','>=',$age );
    }

    if(!empty($request->age2)){
        $query->where('modified_dpprs.modified_dpprs.Umur','<=',$age2);
    }

    if(!empty($request->dataGender)){
        $query->where('modified_dpprs.Jantina',$dataGender);
    }

    if(!empty($request->ethnicity)){
        $query->where('modified_dpprs.Bangsa_updated',$ethnicity);
    }

    if(!empty($request->area)){
        $query->where('modified_dpprs.Taman_area',$area);
    }

    if(!empty($request->state)){
        $query->where('modified_dpprs.Negeri',$state);
    }

    if(!empty($request->namaDUN)){
        $query->where('modified_dpprs.namaDUN',$namaDUN);
    }

    if(!empty($request->income)){
        $query->where('modified_dpprs2018_algorithm.income_latest',$income);
    }

    $data = $query->get();

    // if(!empty($data)){
    //     $response["success"]=1;
    // }
    // return response()->json($response);

    // session(['Jantina' => $request->dataGender]);
    // session(['Bangsa_updated' => $request->ethnicity]);
    // session(['Taman_area' => $request->area]);
    // session(['Negeri' => $request->state]);
    // session(['namaDUN' => $request->namaDUN]);

    return datatables()->of($data)->make(true);