<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Auth;
use Illuminate\Http\UploadedFile;
use RealRashid\SweetAlert\Facades\Alert;

use Illuminate\Http\Request;

use App\Institution;
use App\InstitutionZis;
use App\Transaction;
use App\Zis;
use App\City;
use App\Wakaf;
use App\WakafReport;
use App\ZisReport;
use App\Province;
use App\Last_education;
use App\Phone_prefix;
use App\WakafCategory;
use App\ExtraWakif;
use App\User;
use DB;
use DataTables;

class InstitutionController extends Controller
{
    protected $institution;

    public function __construct()
    {
        $this->middleware('auth:institution');

    }

    public function institution(){
      $institution = Institution::where('id', Auth::guard('institution')->user()->id)->first();
      return $institution;
    }

    public function index()
    {
      $institution = $this->institution();

      $role_id = $institution->role_id;

      if($role_id == '2'){
        $wakafs = $institution->wakaf;

        return view('institution.nazir.index', compact('institution', 'wakafs', 'role_id'));
      }
      else {
        if($role_id == '3'){
          $wakafs = $institution->wakaf;

          return view('institution.laz.index', compact('institution', 'wakafs', 'role_id','zis'));
        }
        else{
          $wakafs = $institution->wakaf;
          return view('institution.nazirlaz', compact('institution', 'wakafs', 'role_id'));
        }
      }

    }

    public function zisserverside(Request $request)
    {
      //inst id
      $institution_id = Auth::user()->id;

      if($request->ajax()){
        DB::statement(DB::raw('set @rownum=0'));
        $data = InstitutionZis::select([DB::raw('@rownum := @rownum + 1 AS rownum'),
        'institution_zis.zis_id as zis_id',
        'institution_zis.institution_id as ins_id',
        'institution_zis.id as id',
        'institution_zis.account as account',
        'institution_zis.name as detail_program',
        'institution_zis.description as detail_description',
        'institution_zis.is_submit as is_submit',
        'zis.name as program_name',
        'institution_zis.updated_at as updated_at' ])
          ->where([
            ['institution_zis.institution_id', $institution_id],
            ['zis.category', $request->category]
          ])
          ->orderBy('id', 'desc')
          ->join('zis','zis.id', 'institution_zis.zis_id')
          // ->join('institutions','institutions.id', 'institution_zis.institution_id')
          ->get();

        return DataTables::of($data)
        ->addColumn('action', function($data){
          return '<a href="#/" id="editZis" data-id="'.$data->id.'" data-zis_id="'.$data->zis_id.'" data-account="'.$data->account.'" data-detail_program="'.$data->detail_program.'" data-is_submit="'.$data->is_submit.'" data-detail_description="'.$data->detail_description.'" data-program_name="'.$data->program_name.'">Edit</a>
            <a onclick="return confirm(`Yakin akan menghapus data?`)" href="'.url('/institution/zis/delete/'.$data->id).'">Delete</a>';
        })
        ->make(true);

      }else{
        exit("Not an AJAX request");
      }
    }

    public function wakafserverside(Request $request)
    {
      //inst id
      $institution_id = Auth::user()->id;

      if($request->ajax()){

        DB::statement(DB::raw('set @rownum=0'));

        $data = Wakaf::select([
        DB::raw('@rownum := @rownum + 1 AS rownum'),
        DB::raw('SUM(extra_wakifs.extra_donatur) as extra_donatur'),
        DB::raw('SUM(transactions.nominal) as total_donation_program'),
        DB::raw('count(transactions.user_id) as total_user'),
        'wakaf.name as name',
        'wakaf.id as id',
        'thumbnail',
        'description',
        'target_donation',
        'end_date',
        'time',
        'total_donation',
        'account',
        'wakaf.slug as slug',
        'is_draft',
        'is_submit',
        'is_approved',
        'wakaf.is_publish as is_publish',
        'institution_id',
        'wakaf.is_show as is_show',
        'coordinate',
        'target_donation_cur',
        'total_donation_cur',
        'total_wakif',
        'category_wakaf_id',
        'approved_by',
        'range_time',
        'institutions.id as institution_id',
        'institutions.city_id as city',
        'institutions.province_id as province',
        'institutions.province_id as province',
        'category_wakaf.category as category_name',
        'category_wakaf.name as program_name'
        ])
          ->where([
            ['transactions.table_name', 'wakaf'],
            ['category_wakaf.category', $request->category],
            ['wakaf.institution_id', $institution_id],
            ['transactions.type', 'debet'],
            ['extra_wakifs.table_name', 'wakaf']

          ])
          ->orderBy('wakaf.id', 'desc')
          ->join('category_wakaf','category_wakaf.id','=', 'wakaf.category_wakaf_id')
          ->join('institutions','institutions.id','=', 'wakaf.institution_id')
          ->leftJoin('transactions','transactions.table_id','=', 'wakaf.id')
          ->join('extra_wakifs','extra_wakifs.table_id','=', 'wakaf.id')
          ->get();

        return DataTables::of($data)
        ->addColumn('action', function($data){
          return '
            <a class="btn btn-warning btn-sm" href="#/"
            id="editWakaf" data-id="'.$data->id.'" data-name="'.$data->name.'" data-total-donation="'.$data->total_donation_program.'" data-total-user="'.$data->total_user.'" data-thumbnail="'.$data->thumbnail.'" data-description="'.$data->description.'" data-end_date="'.date("Y-m-d", strtotime($data->end_date)).'" data-time="'.$data->time.'"
             data-account="'.$data->account.'"data-is_submit="'.$data->is_submit.'"data-category_wakaf_id="'.$data->category_wakaf_id.'"data-city="'.$data->city.'" data-province="'.$data->province.'" data-target_donation="'.$data->target_donation.'"data-is_show="'.$data->is_show.'">Edit</a>
            <a class="btn btn-light btn-sm" href="#/"
            id="editDana" data-id="'.$data->id.'" data-name="'.$data->name.'" data-total-donation="'.$data->total_donation_program.'" data-account="'.$data->account.'" data-program_name="'.$data->program_name.'" data-category_wakaf_id="'.$data->category_wakaf_id.'" data-category_wakaf_id="'.$data->category_wakaf_id.'" data-target_donation="'.$data->target_donation.'" data-total_wakif="'.$data->total_user.'">Edit Dana</a>
            <a class="btn btn-danger btn-sm" onclick="return confirm(`Yakin akan menghapus data?`)" href="'.url('/institution/daftarwakaf/delete/'.$data->id).'">Delete</a>';
        })
        ->editColumn('total_user', function($data){
          return ($data->total_user + $data->extra_wakif);
        })
        ->make(true);

      }else{
        exit("Not an AJAX request");
      }
    }

    public function wakafuangserverside(Request $request)
    {
      //inst id
      $institution_id = Auth::user()->id;

      if($request->ajax()){
        DB::statement(DB::raw('set @rownum=0'));
        $data = Wakaf::select([DB::raw('@rownum := @rownum + 1 AS rownum'),
        'wakaf.name as name',
        'wakaf.id as id',
        'thumbnail',
        'description',
        'total_donation',
        'account',
        'wakaf.slug as slug',
        'is_draft',
        'is_submit',
        'is_approved',
        'wakaf.is_publish as is_publish',
        'institution_id',
        'wakaf.is_show as is_show',
        'total_wakif',
        'approved_by'])
          ->where('wakaf.institution_id', $institution_id)
          ->where('wakaf.category_wakaf_id', '1')
          ->orderBy('wakaf.id', 'desc')
          ->join('institutions','institutions.id','=', 'wakaf.institution_id')
          ->get();

        return DataTables::of($data)
        ->addColumn('action', function($data){
          return '<a href="#/"
            id="editWakaf" data-id="'.$data->id.'" data-name="'.$data->name.'" data-thumbnail="'.$data->thumbnail.'" data-description="'.$data->description.'" data-total_donation="'.$data->total_donation.'" data-account="'.$data->account.'"data-is_submit="'.$data->is_submit.'"data-is_show="'.$data->is_show.'">Edit</a>
            <a onclick="return confirm(`Yakin akan menghapus data?`)" href="'.url('/institution/daftarwakaf/delete/'.$data->id).'">Delete</a>';
        })
        ->make(true);

      }else{
        exit("Not an AJAX request");
      }
    }

    public function daftarwakaf(Request $request)
    {
      $user = Auth::user();
      $institution = $this->institution();
      $wakafs = $institution->wakaf;
      $role_id = $institution->role_id;
      $city  = City::all();
      $province = Province::all();
      $wakaf = WakafCategory::where('category', $request->get('category'))->get();

      return view('institution.nazir.daftarwakaf', compact('institution', 'wakafs','wakaf','city','province', 'role_id','user'));
    }

    public function wakafuang(Request $request)
    {
      $user = Auth::user();
      $institution = $this->institution();
      $wakafs = $institution->wakaf;
      $role_id = $institution->role_id;
      $category = $user->name;

      $datacount = Wakaf::select([DB::raw('@rownum := @rownum + 1 AS rownum'),
        'wakaf.name as name',
        'wakaf.id as id',
        'thumbnail',
        'description',
        'total_donation',
        'account',
        'wakaf.slug as slug',
        'is_draft',
        'is_submit',
        'is_approved',
        'wakaf.is_publish as is_publish',
        'institution_id',
        'wakaf.is_show as is_show',
        'total_wakif',
        'approved_by'])
          ->where('wakaf.institution_id', $institution->id)
          ->orderBy('wakaf.id', 'desc')
          ->join('institutions','institutions.id','=', 'wakaf.institution_id')
          ->get()->count();

      return view('institution.nazir.wakafuang', compact('institution', 'wakafs','wakaf', 'role_id','user','category', 'datacount'));
    }

    public function laporanwakaf(Request $request)
    {
      $institution = $this->institution();
      $role_id = $institution->role_id;
      $wakaf_datas = Wakaf::select('wakaf.*')
        ->join('category_wakaf', 'category_wakaf.id', '=', 'wakaf.category_wakaf_id')
        ->where('wakaf.institution_id', $institution->id)
        ->where('category_wakaf.category', $request->category)
        ->orderBy('wakaf.id','desc')
        ->get();

      return view('institution.nazir.laporanwakaf', compact('institution', 'wakaf_datas', 'role_id'));
    }

    // Store Wakaf Melalui Uang
    public function storewakaf(Request $request){
      $wakaf = request()->validate([
        'target_donation' => 'required|numeric',
      ]);
      $wakaf = new Wakaf;
      if($request-> hasFile('thumbnail'))
      {
      $file = $request['thumbnail'];
      $uploadPath = public_path('/images/wakaf');
      $extension = $file->getClientOriginalExtension();
      $fileName = str_random(6) .$request['name']. '.' . $extension;
      $file->move($uploadPath, $fileName);
      $wakaf->thumbnail = '/images/wakaf/' . $fileName;
      }


      $wakaf->category_wakaf_id = $request->category_wakaf_id;
      $wakaf->name = $request->name;
      $wakaf->account = $request->account;
      $wakaf->target_donation = $request->target_donation;
      $wakaf->city_id = $request->city_id;
      $wakaf->province_id = $request->province_id;
      $wakaf->end_date = $request->end_date;
      $wakaf->time = $request->time;
      $wakaf->description = $request->description;
      $wakaf->longitude = $request->longitude;
      $wakaf->latitude = $request->latitude;
      $wakaf->institution_id = Auth::user()->id;
      $wakaf->slug = str_slug($request->name);

      if($request->is_submit){
        $wakaf->is_submit = '1';
      }else{
        $wakaf->is_submit = '0';
      }

      $options_table = DB::table('options')->where(['name' => 'auto_publish_program', 'value' => '1']);
      if($options_table->first()){
        $wakaf->is_publish = '1';
      }

      $wakaf->save();

      return redirect()->back();
    }

    public function storewakafuang(Request $request){

      $wakaf = new Wakaf;
      if($request-> hasFile('thumbnail'))
      {
      $file = $request['thumbnail'];
      $uploadPath = public_path('/images/wakaf');
      $extension = $file->getClientOriginalExtension();
      $fileName = str_random(6) .$request['name']. '.' . $extension;
      $file->move($uploadPath, $fileName);
      $wakaf->thumbnail = '/images/wakaf/' . $fileName;
      }


      $wakaf->name = $request->name;
      $wakaf->account = $request->account;
      $wakaf->target_donation = 1;
      $wakaf->category_wakaf_id = 1;
      $wakaf->description = $request->description;
      $wakaf->institution_id = Auth::user()->id;
      $wakaf->slug = str_slug($request->name);

      if($request->is_submit){
        $wakaf->is_submit = '1';
      }else{
        $wakaf->is_submit = '0';
      }

      $options_table = DB::table('options')->where(['name' => 'auto_publish_program', 'value' => '1']);
      if($options_table->first()){
        $wakaf->is_publish = '1';
      }

      $wakaf->save();

      return redirect()->back();
    }

    public function updatewakaf(Request $request){
      $wakaf = Wakaf::find($request->id);

      if($request-> hasFile('thumbnail'))
      {
      $file = $request['thumbnail'];
      $uploadPath = public_path('/images/wakaf');
      $extension = $file->getClientOriginalExtension();
      $fileName = str_random(6) .$request['name']. '.' . $extension;
      $file->move($uploadPath, $fileName);
      $wakaf->thumbnail = '/images/wakaf/' . $fileName;
      }


      $wakaf->category_wakaf_id = $request->category_wakaf_id;
      $wakaf->name = $request->name;
      $wakaf->account = $request->account;
      $wakaf->target_donation = $request->target_donation;
      $wakaf->city_id = $request->city_id;
      $wakaf->province_id = $request->province_id;
      $wakaf->end_date = $request->end_date;
      $wakaf->time = $request->time;
      $wakaf->description = $request->description;


      if($request->is_submit){
        $wakaf->is_submit = '1';
      }else{
        $wakaf->is_submit = '0';
      }

      $wakaf->save();

      return redirect()->back();
    }
    public function updatewakafuang(Request $request){
      $wakaf = Wakaf::find($request->id);

      if($request-> hasFile('thumbnail'))
      {
      $file = $request['thumbnail'];
      $uploadPath = public_path('/images/wakaf');
      $extension = $file->getClientOriginalExtension();
      $fileName = str_random(6) .$request['name']. '.' . $extension;
      $file->move($uploadPath, $fileName);
      $wakaf->thumbnail = '/images/wakaf/' . $fileName;
      }



      $wakaf->account = $request->account;
      $wakaf->description = $request->description;


      if($request->is_submit){
        $wakaf->is_submit = '1';
      }else{
        $wakaf->is_submit = '0';
      }

      $wakaf->save();

      return redirect()->back();
    }

    public function updatedanawakaf_totalwakif(Request $request){

      $transaction = new Transaction;
      $transaction->nominal = $request->dana_extra;
      $transaction->type = 'debet';
      $transaction->table_name = 'wakaf';
      $transaction->table_id = $request->programId;
      $transaction->category_program = $request->category_program;
      $transaction->account_destination = $request->program_account;

      $extra_wakif = new ExtraWakif;
      $extra_wakif->table_name = 'wakaf';
      $extra_wakif->table_id = $request->programId;
      $extra_wakif->extra_donatur = $request->extraWakif;

      $transaction->save();
      $extra_wakif->save();
      Alert::success('BERHASIL', 'Transaksi Berhasil Dilakukan');
      return redirect()->back();
    }

    // ------ Zakat Infaq Shadaqah
    public function daftarzis(Request $request)
    {
      $institution = $this->institution();
      $role_id = $institution->role_id;
      $wakafs = $institution->wakaf;
      $zis = Zis::where('category', $request->get('category'))->get();

      return view('institution.laz.daftarzis', compact('institution', 'wakafs', 'role_id','zis'));
    }

    public function storezis(Request $request){
      $zis = new InstitutionZis;

      $zis->zis_id = $request->zis_id;
      $zis->name = $request->name;
      $zis->account = $request->account;
      $zis->description = $request->description;
      $zis->institution_id = Auth::user()->id;
      $zis->created_by = Auth::user()->id;

      if($request->is_submit){
        $zis->is_submit = '1';
      }else{
        $zis->is_submit = '0';
      }

      $options_table = DB::table('options')->where(['name' => 'auto_publish_program', 'value' => '1']);
      if($options_table->first()){
        $zis->is_publish = '1';
      }

      $zis->save();

      return redirect()->back();
    }

    public function updatezis(Request $request){
      $zis = InstitutionZis::find($request->id);

      $zis->zis_id = $request->zis_id;
      $zis->name = $request->name;
      $zis->account = $request->account;
      $zis->description = $request->description;


      if($request->is_submit){
        $zis->is_submit = '1';
      }else{
        $zis->is_submit = '0';
      }

      $zis->save();

      return redirect()->back();
    }



    public function laporanzis(Request $request)
    {
      $institution = $this->institution();
      $role_id = $institution->role_id;
      $zis_datas = InstitutionZis::select('zis.*', 'institution_zis.id as inszis_id', 'institution_zis.name as inszis_name')
        ->where('institution_zis.institution_id', $institution->id )
        ->where('zis.category', $request->category)
        ->join('zis', 'zis.id', '=', 'institution_zis.zis_id')
        ->get();

      // dd($zisreport);
      return view('institution.laz.laporanzis', compact('institution', 'role_id', 'zis_datas'));
    }

    public function getlaporanzis(Request $request)
    {
      $zis_id = $request->zis_id;
      $inszis_name = InstitutionZis::where(['zis_id' => $zis_id])->get();
      return response()->json($inszis_name);
    }

    public function laporanzis_serverside(Request $request){
      //inst id
      $institution_id = Auth::user()->id;

      $inszis_id = $request->inszis_id;

      if($request->ajax()){
        DB::statement(DB::raw('set @rownum=0'));

        if(is_null($inszis_id)){
            $data = ZisReport::select([DB::raw('@rownum := @rownum + 1 AS rownum'),
            'zis_reports.id',
            'zis_reports.title',
            'zis_reports.content',
            'zis_reports.list_account',
            'zis_reports.created_at',
          ])
            ->join('institution_zis','institution_zis.id', '=', 'zis_reports.inszis_id')
            ->join('zis','zis.id', '=', 'institution_zis.zis_id')
            ->where('zis.category', $request->category)
            ->where('institution_zis.institution_id', $institution_id)
            // ->where('zis_reports.inszis_id', $inszis_id)
            ->get();
        } else {
          $data = ZisReport::select([DB::raw('@rownum := @rownum + 1 AS rownum'),
          'zis_reports.id',
          'zis_reports.title',
          'zis_reports.content',
          'zis_reports.list_account',
          'zis_reports.created_at',
        ])
          ->join('institution_zis','institution_zis.id', '=', 'zis_reports.inszis_id')
          ->join('zis','zis.id', '=', 'institution_zis.zis_id')
          ->where('zis.category', $request->category)
          ->where('institution_zis.institution_id', $institution_id)
          ->where('zis_reports.inszis_id', $inszis_id)
          ->get();

        }



        return DataTables::of($data)
        ->addColumn('action', function($data){
          return '<a class="btn btn-warning btn-sm" href="#/" id="formReportEdit" data-id="'.$data->id.'" data-title="'.$data->title.'" data-content="'.htmlentities($data->content).'" data-list-account="'.$data->list_account.'" >Edit</a>
            <a class="btn btn-light btn-sm" href="#/" id="reportDetail" data-title="'.$data->title.'" data-description="'.htmlentities($data->content).'" data-list-account="'.$data->list_account.'" >Lihat Laporan</a>
            <a class="btn btn-danger btn-sm" onclick="return confirm(`Yakin akan menghapus data?`)" href="'.url('/institution/laporanzis/delete/'.$data->id).'">Delete</a>';
        })
        ->make(true);

      }else{
        exit("Not an AJAX request");
      }
    }

    public function laporanzis_store(Request $request){
      $ZisReport = new ZisReport;
      $ZisReport->inszis_id = $request->inszisid;
      $ZisReport->title = $request->title;
      $ZisReport->content = $request->content;
      // $ZisReport->list_account = $request->list_account;
      $ZisReport->save();

      return redirect()->back();
    }

    public function laporanzis_update(Request $request){
      $ZisReport = ZisReport::find($request->id);
      $ZisReport->title = $request->title;
      $ZisReport->content = $request->content;
      $ZisReport->list_account = $request->list_account;
      $ZisReport->save();

      return redirect()->back();
    }
    public function laporanzis_delete($id){
      $ZisReport = ZisReport::find($id)->delete();
      return redirect()->back();
    }

    public function edit()
    {
      $institution = $this->institution();
      $role_id = $institution->role_id;
      $cities = City::all();
      $p_prefixes = Phone_prefix::all();
      $provinces = Province::all();
      return view('institution.editprofile', compact('institution', 'cities', 'provinces', 'p_prefixes', 'role_id'));
    }

    public function update(Request $request, $id)
    {
      $institution = Institution::find($id);
      // dd($institution);
      $institution->name = ucwords($request->input('name'));
      $institution->address = $request->input('address');
      $institution->phone = $request->input('prefix') .'-'. $request->input('phone');
      $institution->province_id = $request->input('province_id');
      $institution->fax = $request->input('fax');
      $institution->city_id = $request->input('city_id');
      $institution->email = $request->input('email');
      $institution->website_url = $request->input('website_url');
      $institution->password = bcrypt($request->input('password'));

      $institution->save();
      return redirect()->route('institution.dashboard');
    }

    public function updatethumbnail(Request $request, $id)
    {
      // dd($institution);
      $institution = Institution::find($id);
      $file = $request->file('photo');
      $path = public_path('nazir\thumbnails');
      $filename = $institution->name. '.' . $file->extension();

      $file->move($path, $filename);

      $institution->photo = $file;
      $institution = Institution::find($id)->update(['photo' => $filename]);

      return redirect()->route('institution.dashboard');
    }


    public function datadonatur(Request $request)
    {
      $institution = $this->institution();
      $role_id = $institution->role_id;
      $wakafs = $institution->wakaf;
      $zis = Zis::where('category', $request->get('category'))->get();

      return view('institution.laz.datadonatur', compact('institution', 'wakafs', 'role_id','zis'));
    }

    public function datadonatur_serverside_zakat(Request $request)
    {

      if($request->ajax()){

        $data = Transaction::select(
          'transactions.created_at as created_at',
          'institution_zis.name as program_name',
          'institution_zis.zis_id as zis_id',
          'transactions.nominal',
          'zis.name as category_name',
          'users.name as name')
        ->where([
            ['table_name', '=', 'institution_zis'],
            ['institution_zis.institution_id', '=', $request->get('id')],
            ['zis.category', '=', 'zakat']
        ])
        ->join('institution_zis','institution_zis.id', 'transactions.table_id')
        ->join('zis','zis.id', 'zis_id')
        ->join('users', 'users.id', '=', 'transactions.user_id')->get();

        return DataTables::of($data)->make(true);


      }else{
        exit("Not an AJAX request");
      }

     }

     public function datadonatur_serverside(Request $request)
    {

      if($request->ajax()){

        $data = Transaction::select(
          'transactions.created_at as created_at',
          'institution_zis.name as program_name',
          'institution_zis.zis_id as zis_id',
          'transactions.nominal',
          'zis.name as category_name',
          'users.name as name')
        ->where([
            ['table_name', '=', 'institution_zis'],
            ['institution_zis.institution_id', '=', $request->get('id')],
            ['zis.category', '=', $request->get('category')]
        ])
        ->join('institution_zis','institution_zis.id', 'transactions.table_id')
        ->join('zis','zis.id', 'zis_id')
        ->join('users', 'users.id', '=', 'transactions.user_id')->get();

        return DataTables::of($data)->make(true);


      }else{
        exit("Not an AJAX request");
      }
     }

     public function getDatadonatur(Request $request){
       $data = Transaction::select(
         'transactions.nominal')
       ->where([
           ['table_name', '=', 'institution_zis'],
           ['institution_zis.institution_id', '=', $request->get('id')],
           ['zis.category', '=', $request->get('category')]
       ])
       ->join('institution_zis','institution_zis.id', 'transactions.table_id')
       ->join('zis','zis.id', 'zis_id')
       ->join('users', 'users.id', '=', 'transactions.user_id')->get();

       $nominal = 0;
       foreach($data as $value){
         $nominal += $value->nominal;
       }

       return response()->json($nominal);

     }

    public function logout(Request $request)
    {
      Auth::logout();
      return view('auth.institution-login');
    }

    public function destroyzis($id){

      $zis = InstitutionZis::findOrFail($id);
        InstitutionZis::destroy($id);

      return redirect()->back();
    }

    public function destroywakaf($id){

      $wakaf = Wakaf::findOrFail($id);
        Wakaf::destroy($id);

      return redirect()->back();
    }

    public function destroywakafuang($id){

      $wakaf = Wakaf::findOrFail($id);
        Wakaf::destroy($id);

      return redirect()->back();
    }

    public function laporanwakaf_serverside(Request $request){
      //inst id
      $institution_id = Auth::user()->id;

      if($request->ajax()){
        DB::statement(DB::raw('set @rownum=0'));
        $data = WakafReport::select([DB::raw('@rownum := @rownum + 1 AS rownum'),
          'wakaf_report.id',
          'wakaf_report.title',
          'wakaf_report.content',
          'wakaf_report.created_at',
        ])
          ->join('wakaf','wakaf.id', '=', 'wakaf_report.wakaf_id')
          ->join('category_wakaf','category_wakaf.id', '=', 'wakaf.category_wakaf_id')
          ->where('category_wakaf.category', $request->category)
          ->where('wakaf.institution_id', $institution_id)
          ->where('wakaf_report.wakaf_id', $request->wakaf_id)
          ->get();

        return DataTables::of($data)
        ->addColumn('action', function($data){
          return '<a class="btn btn-warning btn-sm" href="#/" id="formReportEdit" data-id="'.$data->id.'" data-title="'.$data->title.'" data-content="'.htmlentities($data->content).'" >Edit</a>
            <a class="btn btn-light btn-sm" href="#/" id="reportDetail" data-title="'.$data->title.'" data-description="'.htmlentities($data->content).'" >Lihat Laporan</a>
            <a class="btn btn-danger btn-sm" onclick="return confirm(`Yakin akan menghapus data?`)" href="'.url('/institution/laporanwakaf/delete/'.$data->id).'">Delete</a>';
        })
        ->make(true);

      }else{
        exit("Not an AJAX request");
      }
    }

    public function report_store(Request $request){
      $WakafReport = new WakafReport;
      $WakafReport->wakaf_id = $request->wakaf_id;
      $WakafReport->title = $request->title;
      $WakafReport->content = $request->content;
      $WakafReport->save();

      return redirect()->back();
    }

    public function report_update(Request $request){
      $WakafReport = WakafReport::find($request->id);
      $WakafReport->title = $request->title;
      $WakafReport->content = $request->content;
      $WakafReport->save();

      return redirect()->back();
    }
    public function report_delete($id){
      $WakafReport = WakafReport::find($id)->delete();
      return redirect()->back();
    }

    public function getCity(Request $request)
    {

      $province_id = $request->input('province_id');
      $city = City::where(['province_id' => $province_id])->get();

      return response()->json(['data' => $city]);
    }

    public function editCity(Request $request)
    {

      $province_id = $request->input('province_id');
      $city = City::where(['province_id' => $province_id])->get();

      return response()->json(['data' => $city]);
    }
}