public function Verification()
{
$mailaddress = Input::get('email');
if (Input::has('code')) {
$mailcode = Input::has('code');
} else {
return "code field is blanck";
}
$user_email = $mailaddress . "*manual";
//----------------------------------------------------------------------------code edit
$getdatabasecode = UserRegistrationModel::where('user_email', '=', $user_email)->pluck('user_code');
if ($getdatabasecode) {
$registration_result = array();
if ($getdatabasecode == $mailcode) {
$sql_update = UserRegistrationModel::where('user_email', '=', $user_email)->update(['user_validation_status' => 1]);
if ($sql_update) {
$tempdata = UserRegistrationModel::where('user_email', '=', $user_email)->first();
//"SELECT user_name,user_email,user_phone,user_pass,user_type FROM tbl_user_registration WHERE user_email='$mailaddress'";
//$insert_queary = "INSERT INTO tbl_user_info (user_name,user_email,user_phone,user_pass,user_type) VALUES ('$getdata[0]','$getdata[1]','$getdata[2]','$getdata[3]','$getdata[4]');";
$maininsert = new UserLoginModel();
$maininsert->user_name = $tempdata->user_name;
$maininsert->user_email = $tempdata->user_email;
$maininsert->user_phone = $tempdata->user_phone;
$maininsert->password = $tempdata->password;
$maininsert->user_type = $tempdata->user_type;
if ($maininsert->save()) {
$sql_delete = UserRegistrationModel::where('user_email', '=', $user_email)->delete();
if ($sql_delete) {
$sqldata = UserLoginModel::where('user_email', '=', $user_email)->first();
$this->update_status($user_email);
$registration_result['VerificationResult'] = ['Status' => 'Success', 'data' => ['id' => $sqldata->id, 'user_name' => $sqldata->user_name, 'user_email' => $sqldata->user_email, 'user_phone' => $sqldata->user_phone, 'user_type' => $sqldata->user_type]];
return json_encode($registration_result);
} else {
$registration_result['VerificationResult'] = ['Status' => 'Fail', 'data' => ""];
return json_encode($registration_result);
}
} else {
return "";
}
} else {
return "";
}
} else {
$registration_result['VerificationResult'] = ['Status' => 'Fail', 'data' => 'Verification Code Does Not Match'];
return json_encode($registration_result);
}
} else {
return "email address not registered";
}
}
public function RegistrationProcess()
{
$user_name = Input::get('user_name');
$user_mail = Input::get('email');
$user_phone = Input::get('mobile_no');
$user_password = Input::get('password');
$user_type = Input::get('reg_type');
$user_email = $user_mail . "*" . $user_type;
$maintablecheckreg = UserLoginModel::where('user_email', '=', $user_email)->exists();
$temptablecheck = UserRegistrationModel::where('user_email', '=', $user_email)->where('user_validation_status', '=', 0)->pluck('id');
if ($maintablecheckreg || $temptablecheck > 0) {
if ($maintablecheckreg) {
if (strcasecmp($user_type, "facebook") == 0 || strcasecmp($user_type, "google_plus") == 0 || strcasecmp($user_type, "twitter") == 0) {
$this->update_status($user_email);
$sql = UserLoginModel::where('user_email', '=', $user_email)->first();
return json_encode($sql);
} else {
return "already registered manual user";
}
} else {
return "user not verified";
}
} else {
if (strcasecmp($user_type, "manual") == 0) {
$generated_code = rand(50, 1000);
$starttime = new \DateTime();
$start_time = $starttime->format('Y-m-d H:i:s');
$endtime = new \DateTime('+1 days');
$end_time = $endtime->format('Y-m-d H:i:s');
$user_validation_status = 0;
$user_active_status = 0;
$insert = new UserRegistrationModel();
$insert->user_name = $user_name;
$insert->user_email = $user_email;
$insert->user_phone = $user_phone;
$insert->password = $user_password;
$insert->user_type = $user_type;
$insert->start_time = $start_time;
$insert->end_time = $end_time;
$insert->user_validation_status = $user_validation_status;
$insert->user_active_status = $user_active_status;
$insert->user_code = $generated_code;
try {
$insert->save();
if ($this->MailTransfer($user_mail, $user_name, $generated_code)) {
return "request for verify";
}
} catch (\Illuminate\Database\QueryException $e) {
return $e->getMessage();
}
} elseif (strcasecmp($user_type, "facebook") == 0 || strcasecmp($user_type, "google_plus") == 0 || strcasecmp($user_type, "twitter") == 0) {
$sinsert = new UserLoginModel();
$sinsert->user_name = $user_name;
$sinsert->user_email = $user_email;
$sinsert->user_phone = $user_phone;
$sinsert->password = $user_password;
//Hash::make($user_password);
$sinsert->user_type = $user_type;
if ($sinsert->save()) {
$this->update_status($user_email);
$sql = UserLoginModel::where('user_email', '=', $user_email)->first();
return json_encode($sql);
} else {
return "fail registration complete via" . $user_type;
}
}
return "";
}
}