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');
 }
 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');
 }