public function doLogin() { $rules = ['username' => 'required', 'userpassword' => 'required']; $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { $username = Input::get('username'); $userpassword = Input::get('userpassword'); $list = MembersModel::whereRaw('username = ? and password = md5(?)', array($username, $userpassword))->get(); if (count($list) > 0) { Session::set('user_id', $list[0]->id); return Redirect::route('user.dashboard'); } else { $listEmail = MembersModel::whereRaw('email = ? and password = md5(?)', array($username, $userpassword))->get(); if (count($listEmail) > 0) { Session::set('user_id', $listEmail[0]->id); return Redirect::route('user.dashboard'); } else { $alert['msg'] = 'UserName or Email or Password is incorrect'; $alert['type'] = 'danger'; return Redirect::route('user.login')->with('alert', $alert); } } } }
public function index() { if ($alert = Session::get('alert')) { $param['alert'] = $alert; } $param['pageNo'] = 12; $param['members'] = MembersModel::whereRaw(true)->orderBy('first_name', 'asc')->get(); /****note base*******/ $param['noteType'] = NoteTypeModel::whereRaw(true)->orderBy('notesType', 'asc')->get(); $param['noteCommType'] = NoteCommTypeModel::whereRaw(true)->orderBy('noteCommType', 'asc')->get(); $param['noteAssign'] = NoteAssignModel::whereRaw(true)->orderBy('noteAssign', 'asc')->get(); $param['noteStatus'] = NoteStatusModel::whereRaw(true)->orderBy('notesStatus', 'asc')->get(); $param['noteTypeDetails'] = NoteTypeDetailsModel::whereRaw(true)->orderBy('noteTypeDetails', 'asc')->get(); /****note ***/ $param['note'] = NoteModel::paginate(10); return View::make('admin.note.index')->with($param); }
public function quote($peopleId, $projectId, $quoteId) { if ($alert = Session::get('alert')) { $param['alert'] = $alert; } $param['pageNo'] = 61; $user_id = Session::get('user_id'); $param['member'] = MembersModel::find($user_id); $param['people'] = PeopleModel::find($peopleId); $param['project'] = ProjectModel::find($projectId); $param['quote'] = QuoteModel::whereRaw('projectId = ? ', array($projectId))->get(); $param['members'] = MembersModel::whereRaw(true)->orderBy('first_name', 'asc')->get(); $param['payment'] = PaymentModel::whereRaw(true)->orderBy('payment', 'asc')->get(); $param['quoteItem'] = QuoteModel::find($quoteId); return View::make('admin.contact.quote')->with($param); }
public function noteContact() { $param['pageNo'] = 6; $user_id = Session::get('user_id'); $param['member'] = MembersModel::find($user_id); $param['noteType'] = NoteTypeModel::whereRaw(true)->orderBy('notesType', 'asc')->get(); $param['noteCommType'] = NoteCommTypeModel::whereRaw(true)->orderBy('noteCommType', 'asc')->get(); $param['noteAssign'] = NoteAssignModel::whereRaw(true)->orderBy('noteAssign', 'asc')->get(); $param['noteStatus'] = NoteStatusModel::whereRaw(true)->orderBy('notesStatus', 'asc')->get(); $param['noteTypeDetails'] = NoteTypeDetailsModel::whereRaw(true)->orderBy('noteTypeDetails', 'asc')->get(); $param['members'] = MembersModel::whereRaw(true)->orderBy('first_name', 'asc')->get(); return View::make('user.contact.note')->with($param); }