Beispiel #1
0
 public static function clientByBranch($id)
 {
     $list = \Friends::where('parent_id', '=', $id)->get();
     return $list;
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     //transaction strats
     \DB::beginTransaction();
     //delete user in user table
     $userDel = \User::find($id);
     if (!$userDel->delete()) {
         \DB::rollback();
         return \Redirect::back()->with('error', 'Failed to delete');
     }
     //delete user from friends table
     $friendDel = \Friends::where('child_id', '=', $id)->first();
     if (!$friendDel->delete()) {
         \DB::rollback();
         return \Redirect::back()->with('error', 'Failed to delete');
     }
     //delete clients company
     $companyDel = \Company::where('user_id', '=', $id)->first();
     if (!$companyDel->delete()) {
         \DB::rollback();
         return \Redirect::back()->with('error', 'Failed to delete');
     } else {
         \DB::commit();
         return \Redirect::back()->with('success', 'Successfully deleted');
     }
 }
 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $uId = \Auth::user()->id;
     $month = \Input::get('month');
     $year = \Input::get('year');
     $emp_type = \Input::get('emp_type');
     $client = \Input::get('clientId');
     $empty = \User::where('id', '=', 0)->paginate(20);
     if (preg_match("/^(0[1-9]|1[0-2])\$/", $month) && preg_match("/^[0-9]{4}\$/", $year) && $emp_type) {
         $date = "{$year}-{$month}-01";
         if ($emp_type == 'outsource') {
             if (is_numeric($client)) {
                 $check = \Friends::where('child_id', '=', $client)->where('parent_id', '=', $uId)->first();
                 if ($check) {
                     $emps = \User::whereHas('empJobDetail', function ($q) use($client) {
                         $q->where('emp_type', '=', 'outsource');
                         $q->where('client_id', '=', $client);
                     })->get();
                     // get selected ids in array format
                     $ids = array_pluck($emps, 'id');
                     if ($ids) {
                         foreach ($ids as $id) {
                             if (\EmpAttendance::where('emp_id', '=', $id)->where('attend_date', '=', "{$date}")->first()) {
                                 // skip
                             } else {
                                 \EmpAttendance::insert(array('emp_id' => $id, 'attend_date' => $date));
                             }
                         }
                         $employees = \EmpAttendance::whereIn('emp_id', $ids)->where('attend_date', '=', "{$date}")->paginate(20);
                         return \View::make('branch/attendance.emp_attendance')->with('list', $employees)->with(\Input::flash());
                     } else {
                         return \View::make('branch/attendance.emp_attendance')->with('list', $empty)->with(\Input::flash());
                     }
                 } else {
                     return \View::make('branch/attendance.emp_attendance')->with('list', $empty)->with(\Input::flash());
                 }
             }
         } else {
             $emps = \User::whereHas('empJobDetail', function ($q) use($uId) {
                 $q->whereHas('branch', function ($s) use($uId) {
                     $s->where('branch_id', '=', $uId);
                 })->where('emp_type', '=', 'inhouse');
             })->get();
             $ids = array_pluck($emps, 'id');
             if ($ids) {
                 foreach ($ids as $id) {
                     if (\EmpAttendance::where('emp_id', '=', $id)->where('attend_date', '=', "{$date}")->first()) {
                         // skip
                     } else {
                         \EmpAttendance::insert(array('emp_id' => $id, 'attend_date' => $date));
                     }
                 }
                 $employees = \EmpAttendance::whereIn('emp_id', $ids)->where('attend_date', '=', "{$date}")->paginate(20);
                 return \View::make('branch/attendance.emp_attendance')->with('list', $employees)->with(\Input::flash());
             } else {
                 return \View::make('branch/attendance.emp_attendance')->with('list', $empty)->with(\Input::flash());
             }
         }
     } else {
         return \View::make('branch/attendance.emp_attendance')->with('list', $empty)->with(\Input::flash());
     }
 }
 public function clientByBranch()
 {
     $id = \Input::get('id');
     $list = \Friends::where('parent_id', '=', $id)->get();
     $option = "<option value=''>----Select Client-----</option><option value='in-house'>In House </option>";
     foreach ($list as $value) {
         $option .= "<option value='{$value->child_id}'>" . $value->user->company->company_name . "</option>";
         // $json[$value->child_id]=$value->user->company->company_name;
     }
     echo $option;
     return;
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $uId = \Auth::user()->id;
     $emp = \User::where('id', '=', $id)->first();
     if ($emp) {
         $dept = \Department::get();
         $client = \Friends::where('parent_id', '=', $uId)->get();
         return \View::make('branch/emp.edit')->with('dept', $dept)->with('emp', $emp)->with('client', $client);
     } else {
         \App::abort(404);
     }
 }