<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Chart_data;

class GetDepartment extends Controller
{
	public function getDepartment(Request $request)
	{
		if(isset($request->sub_division)) {
			$dept = Chart_data::select('department_n4')
			->distinct()
			->where('sub_division_n3', '=', $request->sub_division)
			->orderBy('department_n4')
			->get();

			return json_encode(array("department"=>$dept));
		} else {
			return null;
		}	
	}
}