public function index()
{
//
$title = "Departments";
$data = Department::orderBy('id', 'desc')->get();
return view('html.department.list', compact('data', 'title'));
}
/**
* Show the application registration form.
*
* @return \Illuminate\Http\Response
*/
public function getRegister()
{
$departmentList = Department::orderBy('created_at')->get();
$deptSelectValues = [];
foreach ($departmentList as $dept) {
$deptSelectValues[$dept['id']] = $dept['dept_name'];
}
return view('auth.register')->with(compact('deptSelectValues'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//::orderBy('orderByColumn')->
$departments = Department::orderBy('name')->get();
foreach ($departments as $dept) {
$fac = Faculty::where('id', '=', $dept->faculty_id)->firstOrFail();
$dept['faculty_name'] = $fac->name;
}
return view('department.index', compact('departments'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if ($id == 1) {
Flash::error('Il est interdit de modifier ce département.');
return Redirect::back();
}
$departments = Department::orderBy('name')->paginate(20);
$depToEdit = Department::where('id', $id)->first();
return view('admin.departments.edit', compact('departments', 'depToEdit'));
}
public function filter()
{
$city_id = Input::get('city');
$departments = Department::orderBy('city_id')->get();
if (isset($city_id)) {
if ($city_id == 0) {
$departments = Department::orderBy('city_id')->get();
} else {
$departments = Department::where('city_id', $city_id)->get();
}
}
return View::make('department.all', ['category' => 1, 'departments' => $departments, 'selectedCity' => $city_id]);
}
public function index(Request $request)
{
if ($request->bp) {
$currentBp = BusinessPlan::find($request->bp);
} else {
$currentBp = BusinessPlan::where('start', '<=', Carbon::now())->where('end', '>=', Carbon::now())->first();
if (!$currentBp) {
$currentBp = BusinessPlan::all()->last();
}
}
$sorted = Goat::where('bid', $currentBp->id)->where('type', 'G')->orderBy('goal_type')->orderBy('description')->get();
$bp = Goat::where('bid', $currentBp->id)->where('type', '<>', 'G')->orderByRaw("FIELD(type, 'O', 'A', 'T')")->orderBy('description', 'desc')->get();
foreach ($bp as $goat) {
if ($goat->type === 'G') {
$sorted->push($goat);
continue;
}
for ($i = 0, $len = $sorted->count(); $i < $len; $i++) {
if ($sorted[$i]->id == $goat->parent_id) {
// Hacky fix since when you splice $goat into $sorted,
// it converts the $goat into an array instead of
// keeping it as a Model object...
$sorted->splice($i + 1, 0, "temp");
$sorted->put($i + 1, $goat);
break;
}
}
}
$leadOf = array();
if (Auth::user()) {
foreach (Auth::user()->leadOf as $dept) {
array_push($leadOf, $dept->id);
}
}
$collaboratorGoals = array();
foreach ($leadOf as $dept_id) {
foreach (Department::find($dept_id)->collaboratorOn as $goat) {
array_push($collaboratorGoals, $goat->id);
}
}
return view('view_plan')->with(['bp' => $sorted, 'users' => User::orderBy('first_name')->get(), 'depts' => Department::orderBy('name')->get(), 'leadOf' => $leadOf, 'plans' => BusinessPlan::orderBy('id', 'desc')->get(), 'query' => $request, 'bp_id' => $currentBp->id, 'is_bplead' => Auth::user() && Auth::user()->is_bplead, 'collaboratorGoals' => $collaboratorGoals]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$this->AuthorizeAndRedirect('admin');
$departments = Department::orderBy('name')->lists('name', 'id');
$student = User::findOrFail($id);
return view('student.edit', compact('student', 'departments'));
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
if (\Schema::hasTable('positions')) {
$positions = Position::orderBy('name', 'ASC')->get();
$selectPositions = array();
$selectPositions[0] = "Select / All";
foreach ($positions as $position) {
$selectPositions[$position->slug] = $position->name;
}
\View::share('selectPositions', $selectPositions);
}
if (\Schema::hasTable('departments')) {
$departments = Department::orderBy('name', 'ASC')->get();
$selectDepartments = array();
$selectDepartments[0] = "Select / All";
foreach ($departments as $department) {
$selectDepartments[$department->slug] = $department->name;
}
\View::share('selectDepartments', $selectDepartments);
}
if (\Schema::hasTable('provinces')) {
$provinces = Province::all();
$selectProvinces = array();
$selectProvinces[0] = "Select / All";
foreach ($provinces as $Province) {
$selectProvinces[$Province->slug] = $Province->name;
}
\View::share('selectProvinces', $selectProvinces);
}
if (\Schema::hasTable('districts')) {
$districts = District::all();
$selectDistrict = array();
$selectDistricts[0] = "Select / All";
foreach ($districts as $district) {
$selectDistricts[$district->slug] = $district->name;
}
\View::share('selectDistricts', $selectDistricts);
}
if (\Schema::hasTable('municipalities')) {
$municipalities = Municipality::all();
$selectMunicipalities = array();
$selectMunicipalities[0] = "Select / All";
foreach ($municipalities as $municipality) {
$selectMunicipalities[$municipality->slug] = $municipality->name;
}
\View::share('selectMunicipalities', $selectMunicipalities);
}
if (\Schema::hasTable('categories')) {
$categories = Category::all();
$selectCategories = array();
$selectCategories[0] = "Select / All";
foreach ($categories as $category) {
$selectCategories[$category->slug] = $category->name;
}
\View::share('selectCategories', $selectCategories);
}
if (\Schema::hasTable('sub-categories')) {
$subCategories = SubCategory::all();
$selectSubCategories = array();
$selectSubCategories[0] = "Select / All";
foreach ($subCategories as $subCategory) {
$selectSubCategories[$subCategory->slug] = $subCategory->name;
}
\View::share('selectSubCategories', $selectSubCategories);
}
if (\Schema::hasTable('sub-sub-categories')) {
$subSubCategories = SubSubCategory::all();
$selectSubSubCategories = array();
$selectSubSubCategories[0] = "Select / All";
foreach ($subSubCategories as $subSubCategory) {
$selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name;
}
\View::share('selectSubSubCategories', $selectSubSubCategories);
}
if (\Schema::hasTable('relationships')) {
$relationships = Relationship::all();
$selectRelationships = array();
$selectRelationships[0] = "Select / All";
foreach ($relationships as $relationship) {
$selectRelationships[$relationship->id] = $relationship->name;
}
\View::share('selectRelationships', $selectRelationships);
}
if (\Schema::hasTable('cases')) {
$cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`FirstName`, ' ', `Surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get();
$reporters = array();
$reporters[0] = "Select / All";
foreach ($cases as $case) {
$reporters[$case->reporterName] = $case->reporterName;
}
\View::share('selectReporters', $reporters);
}
View()->composer('master', function ($view) {
$view->with('addressBookNumber', addressbook::all());
if (\Auth::check()) {
$number = addressbook::where('user', '=', \Auth::user()->id)->get();
$view->with('addressBookNumber', $number);
$allUsers = User::where('id', '<>', \Auth::user()->id)->get();
$view->with('loggedInUsers', $allUsers);
$noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('online', '=', 0)->get();
$view->with('noPrivateMessages', $noPrivateMessages);
$noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('online', '=', 0)->get();
$view->with('noInboxMessages', $noInboxMessages);
}
});
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$departments = Department::orderBy('created_at', 'desc')->paginate(10);
return view('admin.department.department', compact('departments'));
}
