<?php

namespace App\Http\Controllers;

use App\Extensions\MongoSessionHandler;
use Illuminate\Support\Facades\Session;
use Illuminate\Support\ServiceProvider;
use Illuminate\Pagination\LengthAwarePaginator as Paginator;
use Illuminate\Http\Request;
use App\ModifiedDppr;
use App\ModifiedDppr_2018;
use DB;

class FiltersController extends Controller
{
    
    public function filter(){
        $data = DB::table('md')->paginate(50);
        return view('pages.custom', ['data' => $data]);
        
}


public function age(Request $request)
{
    $age1 = [];

    if($request->has('q')){
        $search = $request->q;
        $age1 = DB::table("md")
                ->select("id","Umur")
                ->where('Umur','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($age1);
    
}

public function age2(Request $request)
{
    $age2 = [];

    if($request->has('q')){
        $search = $request->q;
        $age2 = DB::table("md")
                ->select("id","Umur")
                ->where('Umur','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($age2);
    
}

public function gender(Request $request)
{
    $dataGender = [];

    if($request->has('q')){
        $search = $request->q;
        $dataGender = DB::table("md")
                ->select("id","Jantina")
                ->where('Jantina','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($dataGender);
}

public function ethnicity(Request $request)
{
    $ethnicity = [];

    if($request->has('q')){
        $search = $request->q;
        $ethnicity = DB::table("md")
                ->select("id","Bangsa_updated")
                ->where('Bangsa_updated','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($ethnicity);
}

public function area(Request $request)
{
    $area = [];

    if($request->has('q')){
        $search = $request->q;
        $area = DB::table("md")
                ->select("id","Taman_area")
                ->where('Taman_area','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($area);
}

public function state(Request $request)
{
    $state = [];

    if($request->has('q')){
        $search = $request->q;
        $state = DB::table("md")
                ->select("id","Negeri")
                ->where('Negeri','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($state);
}

public function namaDUN(Request $request)
{
    $namaDUN = [];

    if($request->has('q')){
        $search = $request->q;
        $namaDUN = DB::table("md")
                ->select("id","namaDUN")
                ->where('namaDUN','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($namaDUN);
}

public function income(Request $request)
{
    $income = [];

    if($request->has('q')){
        $search = $request->q;
        $income = DB::table("modified_dppr2018_algorithm")
                ->select("id","income_latest")
                ->where('income_latest','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($income);
}

public function education(Request $request)
{
    $education = [];

    if($request->has('q')){
        $search = $request->q;
        $education = DB::table("modified_dppr2018_algorithm")
                ->select("id","Education")
                ->where('Education','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($education);
}

public function digitalInclination(Request $request)
{
    $digitalInclination = [];

    if($request->has('q')){
        $search = $request->q;
        $digitalInclination = DB::table("modified_dppr2018_algorithm")
                ->select("id","digital_inclination")
                ->where('digital_inclination','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($digitalInclination); 
}

public function houseOwnership(Request $request)    //KIV first from system
{
    $houseOwnership = [];

    if($request->has('q')){
        $search = $request->q;
        $houseOwnership = DB::table("modified_dppr2018_algorithm")
                ->select("id","namaDUN")
                ->where('namaDUN','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($houseOwnership); 
}

public function employment(Request $request)
{
    $employment = [];

    if($request->has('q')){
        $search = $request->q;
        $employment = DB::table("modified_dppr2018_algorithm")
                ->select("id","Employment")
                ->where('Employment','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($employment); 
}

public function carOwnership(Request $request)
{
    $carOwnership = [];

    if($request->has('q')){
        $search = $request->q;
        $carOwnership = DB::table("modified_dppr2018_algorithm")
                ->select("id","prob_owncar")
                ->where('prob_owncar','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($carOwnership); 
}

public function carOwnership2(Request $request)
{
    $carOwnership2 = [];

    if($request->has('q')){
        $search = $request->q;
        $carOwnership2 = DB::table("modified_dppr2018_algorithm")
                ->select("id","prob_owncar")
                ->where('prob_owncar','LIKE',"%$search%")
                ->first();           
    }
    return response()->json($carOwnership2); 
}

// Controller for Datatable Custom Audience (Features)

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;

    $income = $request->income;
    $education = $request->education;
    $digitalInclination = $request->digitalInclination;
    $employment = $request->employment;
    $carOwnership = $request->carOwnership;
    $carOwnership2 = $request->carOwnership2;
    

     // $data = DB::table('modified_dpprs')
    //  ->where('Jantina', 'L');

    // if(!empty($request->age)){
    //     $data = ModifiedDppr::where('Jantina',$dataGender)->get();
    //  }
 
     //join table by IC as PK
    $query = ModifiedDppr::query();
    $query->join('modified_dppr2018_algorithm', 'modified_dppr2018_algorithm.IC', '=', 'md.IC');
        

    //from table = modified_dpprs
    if(!empty($request->age)){
        $query->where('md.Umur','>=',$age);
    }

    if(!empty($request->age2)){
        $query->where('md.Umur','<=',$age2);
    }

    if(!empty($request->dataGender)){
        $query->whereIn('md.Jantina',$dataGender); //multiselect whereIn
    }

    if(!empty($request->ethnicity)){
        $query->whereIn('md.Bangsa_updated',$ethnicity);
    }

    if(!empty($request->area)){
        $query->whereIn('md.Taman_area',$area);
    }

    if(!empty($request->state)){
        $query->whereIn('md.Negeri',$state);
    }

    if(!empty($request->namaDUN)){
        $query->whereIn('md.namaDUN',$namaDUN);
    }

    if(!empty($request->income)){
        $query->whereIn('modified_dppr2018_algorithm.income_latest',$income);
    }

    if(!empty($request->education)){
        $query->whereIn('modified_dppr2018_algorithm.Education',$education);
    }

    if(!empty($request->digitalInclination)){
        $query->whereIn('modified_dppr2018_algorithm.digital_inclination',$digitalInclination);
    }

    if(!empty($request->employment)){
        $query->whereIn('modified_dppr2018_algorithm.Employment',$employment);
    }

    if(!empty($request->carOwnership)){
        $query->where('modified_dppr2018_algorithm.prob_owncar','>=',$carOwnership);
    }

    $records_per_page = 50;
    $data = $query->select('md.id','md.First_name', 'md.Last_name', 
    'md.Umur', 'md.Phonenum', 'md.TarikhLahir','md.Negeri', 'md.postcode',  'md.Jantina')->paginate($records_per_page);

        

    return datatables()->of($data)->make(true);
}




}