private function addNormalUser($aRequest)
{
$aUser = array();
foreach ($this->aUserParams as $sParam) {
switch ($sParam) {
case "username":
$aUser[$sParam] = strtolower($aRequest[$sParam]);
break;
case "logo":
$aUser['photo'] = Backend::uploadPhotos($aRequest['logo'], 'logo');
break;
default:
$aUser[$sParam] = $aRequest[$sParam];
break;
}
}
$aUser['date_registered'] = date('Y-m-d h:i:s');
$aUser['age'] = $aRequest['date_of_birth'];
$aUser['user_mobile'] = $aRequest['telephone'];
$aUser['user_status'] = 'active';
unset($aUser['date_of_birth']);
unset($aUser['telephone']);
//Hashing the password to be saved encrypted
$aUser['password'] = Hash::make($aUser['password']);
DB::table('users')->insert($aUser);
$dIdUser = DB::table('users')->where(array('username' => $aUser['username']))->get(array('id_user'));
DB::table('user_rating')->insert(array('id_user' => $dIdUser[0]->id_user, 'likes_count' => 0));
echo "You've registered successfully!";
return redirect()->intended('/');
}
public function submitReview()
{
//Get the request from the submitted page
$aRequest = \Request::all();
//Get the Session
$aSession = \Session::all();
//GET RESTAURANT ID
$aRestaurant = DB::table('restaurants')->where(array('username' => $aRequest['username']))->get(array("id_restaurant"));
$oRestaurant = $aRestaurant[0];
$aReview['id_restaurant'] = $oRestaurant->id_restaurant;
$aReview['id_user'] = $aSession['id_user'];
$aReview['body'] = $aRequest['review'];
$aReview['rating'] = $aRequest['rating'];
$oImage = $aRequest['review-picture'];
//Uplaod the pociture of the review
$FullImagePath = Backend::uploadPhotos($oImage, 'review-picture');
$aReview['review_image'] = $FullImagePath;
$aReview['date_created'] = Date('Y-m-d h:i:s');
//Insert the data into Reviews Table and get it's id
$dReviewId = DB::table('reviews')->insertGetId($aReview);
//Add Activity to it's table
//save activity into the DB:
Backend::addActivity($aSession['id_user'], 'review', $dReviewId);
//Redirect the user to the restaurant's page.
return redirect('/p/' . $aRequest['username']);
}
