/**
* Display a listing of the resource.
* GET /ob
*
* @return Response
*/
public function index()
{
$leavecount = LeaveCounter::where('employee_id', Auth::user()->employee_id)->first();
$recentleave = LeaveWPay::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
$profile = UserDetails::where('employee_id', '=', Auth::user()->employee_id)->first();
$rleave = LeaveOB::where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
return View::make('dashboard.apply_ob')->with('countleave', $leavecount)->with('profile', $profile)->with('rleave', $rleave)->with('title', 'STI | Apply (OB)');
}
public function show_announce($id)
{
$post_comment = AnnouncementComments::where('post_id', $id)->orderBy('created_at', 'desc')->get();
$leavecount = LeaveCounter::where('employee_id', Auth::user()->employee_id)->first();
$announce = Announcements::with('user')->where('post_id', $id)->orderBy('created_at', 'desc')->first();
$profile = UserDetails::where('employee_id', '=', Auth::user()->employee_id)->first();
$recentleave = LeaveWPay::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
$recentwleave = LeaveWOPay::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
return View::make('dashboard.announcement')->with('post', $announce)->with('post_comment', $post_comment)->with('profile', $profile)->with('countleave', $leavecount)->with('rleave', $recentleave)->with('sleave', $recentwleave)->with('title', 'STI | Show Announcement');
}
/**
* Display a listing of the resource.
* GET /notification
*
* @return Response
*/
public function index()
{
$leavelog = UserLeaveLog::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
$leaveoblog = LeaveOB::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
$leavecount = LeaveCounter::where('employee_id', Auth::user()->employee_id)->first();
$profile = UserDetails::where('employee_id', '=', Auth::user()->employee_id)->first();
$recentleave = LeaveWPay::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
$recentwleave = LeaveWOPay::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
$obleave = LeaveOB::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
$awtleave = LeaveAWT::with('user')->where('employee_id', Auth::user()->employee_id)->orderBy('created_at', 'desc')->get();
return View::make('dashboard.notification_box')->with('profile', $profile)->with('leavelog', $leavelog)->with('rleave', $recentleave)->with('sleave', $recentwleave)->with('leaveob', $leaveoblog)->with('leaveawt', $awtleave)->with('countleave', $leavecount)->with('obleave', $obleave)->with('title', 'STI | Notification Box');
}
/**
* Show the form for editing the specified resource.
* GET /leavewopay/{id}/edit
*
* @param int $id
* @return Response
*/
public function edit($id)
{
//
$validate = LeaveWPay::validate(Input::all());
if ($validate->passes()) {
$count = LeaveCounter::where('employee_id', $id)->first();
if (Input::get('totalleaves') < 0 or Input::get('totalleaves') === 'NaN') {
$message = 'Please select correct date!';
return Redirect::to('leavewopay')->with('error_message', $message);
} elseif (Input::get('totalleaves') <= '0.0') {
$message = 'Date and time not allowed.Please try again.';
return Redirect::to('leavewopay')->with('error_message', $message);
} elseif (Input::get('totalleaves') > 10) {
$message = 'You rich maximum limit of leave!';
return Redirect::to('leavewopay')->with('error_message', $message);
} elseif (Input::get('totalleaves') > $count->remaining_leave_wopay) {
$message = 'Insufficient number of leave!';
return Redirect::to('leavewopay')->with('error_message', $message);
} else {
$leavecount = LeaveCounter::where('employee_id', $id)->first();
$leavecount->remaining_leave_wopay = $leavecount->remaining_leave_wopay - Input::get('totalleaves');
$leavecount->save();
$lastrow = LeaveWOPay::orderBy('created_at', 'desc')->first();
$userdata = new LeaveWOPay();
$userdata->employee_id = Auth::user()->employee_id;
if ($lastrow == null) {
$userdata->leave_id = Str::random(30);
} else {
$userdata->leave_id = Str::random(30) . $lastrow->id;
}
$userdata->days_of_leave = Input::get('totalleaves');
$userdata->wdays_of_leave = Input::get('totalleave');
$userdata->date_from = Input::get('date_from');
$userdata->time_from = Input::get('time_from');
$userdata->date_to = Input::get('date_to');
$userdata->time_to = Input::get('time_to');
$userdata->reason = Input::get('reason');
$userdata->save();
return Redirect::to('leavewopay')->with('message', 'Your Application for leave is successfully send.Please Check Your Notification box to see if your leave has been approved.');
}
} else {
return Redirect::to('leavewopay')->withErrors($validate);
}
}
public function status_options($id)
{
LeaveWPay::with('user')->where('leave_id', $id)->update(array('status' => Input::get('status')));
$approve = LeaveWPay::with('user')->where('leave_id', $id)->first();
$adminlog = new AdminLogWP();
$adminlog->employee_id = Input::get('employee_id');
$adminlog->leave_id = Input::get('leave_id');
$adminlog->days_of_leave = $approve->days_of_leave;
$adminlog->wdays_of_leave = $approve->wdays_of_leave;
$adminlog->date_from = $approve->date_from;
$adminlog->time_from = $approve->time_from;
$adminlog->date_to = $approve->date_to;
$adminlog->time_to = $approve->time_to;
$adminlog->reason = $approve->reason;
$adminlog->message = Input::get('message');
$adminlog->status = Input::get('status');
$adminlog->save();
$userlog = new UserLeaveLog();
$userlog->employee_id = Input::get('employee_id');
$userlog->leave_id = Input::get('leave_id');
$userlog->type_of_leave = 'Leave with pay';
$userlog->days_of_leave = $approve->days_of_leave;
$userlog->wdays_of_leave = $approve->wdays_of_leave;
$userlog->date_from = $approve->date_from;
$userlog->time_from = $approve->time_from;
$userlog->date_to = $approve->date_to;
$userlog->time_to = $approve->time_to;
$userlog->company = '';
$userlog->address = '';
$userlog->reason = $approve->reason;
$userlog->status = Input::get('status');
$userlog->save();
$approve = new Approval();
$approve->employee_id = Auth::user()->employee_id;
$approve->leave_id = Input::get('leave_id');
$approve->type_of_leave = 'Leave with pay';
$approve->message = Input::get('message');
$approve->status = Input::get('status');
$approve->save();
return Redirect::route('leavepay');
}
public function post_delete($id)
{
$d_login = UserLogin::where('employee_id', $id)->first();
$d_login->delete();
$userlog = UserLeaveLog::where('employee_id', $id)->delete();
LeaveWPay::where('employee_id', $id)->delete();
LeaveWOPay::where('employee_id', $id)->delete();
LeaveCounter::where('employee_id', $id)->delete();
LeaveAWT::where('employee_id', $id)->delete();
LeaveOB::where('employee_id', $id)->delete();
AdminLogWP::where('employee_id', $id)->delete();
AdminLogWOP::where('employee_id', $id)->delete();
AdminLogOB::where('employee_id', $id)->delete();
AdminLogAWT::where('employee_id', $id)->delete();
AnnouncementComments::where('employee_id', $id)->delete();
Approval::where('employee_id', $id)->delete();
$d_user = UserDetails::where('employee_id', $id)->first();
$d_user->delete();
return Redirect::route('view_users');
}
/**
* Remove the specified resource from storage.
* DELETE /leavepay/{id}
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
LeaveWPay::where('leave_id', $id)->delete();
return Redirect::route('dash');
}
