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