} else {
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// check to make sure form is filled out correctly
if (empty($_POST["username"])) {
apologize("You must provide your username.");
} else {
if (empty($_POST["password"])) {
apologize("You must provide your password.");
} else {
if ($_POST["password"] != $_POST["confirmation"]) {
apologize("Two passwords do not match!");
}
}
}
// check to make sure random uniqueID is actually unique
do {
$identifier = generateRandomID();
$checkuniqueID = CS50::query("SELECT * FROM users WHERE uniqueID = ?", $identifier);
} while (!empty($checkuniqueID));
// check to see username was unique
$test = CS50::query("INSERT IGNORE INTO users (username, hash, uniqueID, email) VALUES(?, ?, ?, ?)", $_POST["username"], password_hash($_POST["password"], PASSWORD_DEFAULT), $identifier, $_POST["email"]);
if ($test == 0) {
apologize("This username is taken!");
} else {
$rows = CS50::query("SELECT LAST_INSERT_ID() AS id");
$id = $rows[0]["id"];
$_SESSION = $id;
redirect("/");
}
}
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
// validate the info, create rules for the inputs
$rules = array('user_firstname' => 'required', 'user_gender' => 'required', 'user_joined_date' => 'required|date_format:"' . DATE_FORMAT_2, 'user_left_date' => 'date_format:"' . DATE_FORMAT_2, 'user_email' => 'required|email|unique:user,user_email,' . $id . ',user_key,deleted_at,NULL', 'country_key1' => 'required', 'user_contact_phone_number1' => 'required', 'user_status' => 'required');
// run the validation rules on the inputs from the form
$validator = Validator::make(Input::all(), $rules);
// if the validator fails, redirect back to the form
if ($validator->fails()) {
// redirect to list page
Session::flash('danger', UNABLE_TO_SAVE);
return Redirect::back()->withErrors($validator)->withInput();
} else {
// where condition
$user = User::userKey($id)->first();
// check if the record can be updated
if (empty($user->id)) {
// redirect to list page
Session::flash('danger', SOMETHING_WENT_WRONG);
return Redirect::to(strtolower(USER_TITLE));
}
// fields to be updated
$user->user_firstname = $this->getInput('user_firstname', '');
$user->user_middlename = $this->getInput('user_middlename', '');
$user->user_lastname = $this->getInput('user_lastname', '');
$user->user_alias = $this->getInput('user_alias', '');
$user->user_gender = $this->getInput('user_gender', '');
$user->user_civil_status = $this->getInput('user_civil_status', '');
$user->user_birth_date = \Carbon\Carbon::createFromFormat(DATE_FORMAT_1, $this->getInput('user_birth_date', DEFAULT_DATE))->format(DB_DATE_FORMAT);
$user->user_joined_date = $this->getInput('user_joined_date', '');
$user->user_left_date = $this->getInput('user_left_date', '');
$user->user_email = $this->getInput('user_email', '');
$user->user_hometown_address = $this->getInput('user_hometown_address', '');
$user->user_overseas_address = $this->getInput('user_overseas_address', '');
if (Session::has('user_photo')) {
$user->user_photo = Session::get('user_photo');
Session::forget('user_photo');
}
$user->user_status = $this->getInput('user_status', '');
$user->updated_by = Auth::user()->id;
// update record
$user->save();
for ($cnt = 1; $cnt <= $this->getInput('hdn_increment', ''); $cnt++) {
if ($this->getInput('hdn_index' . $cnt, '') == YES && $this->getInput('country_key' . $cnt, '') != EMPTY_STRING && $this->getInput('user_contact_phone_number' . $cnt, '') != EMPTY_STRING) {
if ($this->getInput('user_contact_key' . $cnt, '') == EMPTY_STRING) {
$data = array();
$data['user_contact_key'] = generateRandomID();
$data['user_id'] = $user->id;
$data['country_id'] = Country::countryKey($this->getInput('country_key' . $cnt, ''))->pluck('id');
$data['user_contact_phone_number'] = $this->getInput('user_contact_phone_number' . $cnt, '');
$data['created_by'] = Auth::user()->id;
// create record
UserContact::create($data);
} else {
// where condition
$user_contact = UserContact::UserContactKey($this->getInput('user_contact_key' . $cnt, ''))->first();
// check if the record can be updated
if (isset($user_contact->id)) {
$user_contact->country_id = Country::countryKey($this->getInput('country_key' . $cnt, ''))->pluck('id');
$user_contact->user_contact_phone_number = $this->getInput('user_contact_phone_number' . $cnt, '');
$user_contact->updated_by = Auth::user()->id;
// update record
$user_contact->save();
}
}
}
}
// where condition
$user_emergency = UserEmergency::userId($user->id)->first();
// check if the record can be updated
if (!empty($user_emergency->id)) {
// fields to be updated
$user_emergency->user_emergency_name = $this->getInput('user_emergency_name', '');
$user_emergency->user_emergency_relation = $this->getInput('user_emergency_relation', '');
$user_emergency->user_emergency_address = $this->getInput('user_emergency_address', '');
$user_emergency->country_id = Country::countryKey($this->getInput('emergency_country_key', ''))->pluck('id');
$user_emergency->user_emergency_phone = $this->getInput('user_emergency_phone', '');
$user_emergency->updated_by = Auth::user()->id;
// update record
$user_emergency->save();
}
// flag all approver template records
AccessUser::userId($user->id)->update(array('access_user_flag' => YES));
// create access record
if (is_array($this->getInput('access_user', array()))) {
foreach ($this->getInput('access_user', array()) as $access_id) {
$access_user = AccessUser::accessId($access_id)->userId($user->id)->first();
if (isset($access_user->id) && !empty($access_user->id)) {
// update record
$access_user->user_id = $user->id;
$access_user->access_id = $access_id;
$access_user->access_user_flag = NO;
$access_user->updated_by = Auth::user()->id;
$access_user->save();
} else {
// create record
$data = array();
$data['user_id'] = $user->id;
$data['access_id'] = $access_id;
$data['access_user_flag'] = NO;
$data['created_by'] = Auth::user()->id;
AccessUser::create($data);
}
}
// delete records set to yes
AccessUser::AccessUserFlag(YES)->UserId($user->id)->delete();
}
// redirect to list page
Session::flash('success', SUCCESS_UPDATE);
return Redirect::to($this->getPreviousListURL());
}
}
// Lock the myInfoTab table.
$query = "LOCK TABLES {$myInfoTab} WRITE";
if (!@mysql_query($query, $connection)) {
die("Couldn't lock.");
}
// We're updating.
// Get the referal id.
$query = "select referal_id from {$myInfoTab} where reg_id = '{$reg_id}'";
// Run the query.
$result = @mysql_query($query, $connection);
// Translate the output to an array.
$row = @mysql_fetch_array($result);
// Keep track of the referal id -- it gets printed out at the end.
$parameters['referal_id'] = $row['referal_id'];
if ($parameters['referal_id'] == "NULL" || $parameters['referal_id'] == "") {
$parameters['referal_id'] = generateRandomID($myHost, $myUser, $myPW, $myDB, $myReferTab, "referal_id");
if ($parameters['referal_id'] != null && $parameters['referal_id'] != "false") {
// Add the registrant's reg_id to the referal table.
// Lock the refer table.
// $query = "LOCK TABLES $myReferTab WRITE";
// if( !(@ mysql_query( $query, $connection) ) )
// die( "Couldn't lock." );
// Make the query to add the registrant's id to the referer table.
$query = "update {$myReferTab} set reg_id = '{$reg_id}' " . "where referal_id = '{$parameters['referal_id']}'";
} else {
// Unlock the table.
$query = "UNLOCK TABLES";
if (!@mysql_query($query, $connection)) {
die("Couldn't unlock.");
}
print "fail";
// Run the query.
$result = @ mysql_query( $query, $connection );
// Translate the output to an array.
$row = @ mysql_fetch_array( $result );
// If the row array is null, then we know the username hasn't been used
// yet.
$isValidUsername = ($row == null);
// if( !$isValidUsername )
// print "username already in use: " . $username . "<br>";
} while( !$isValidUsername );
*/
$username = generateRandomID($myHost, $myUser, $myPW, $myDB, $myInfoTab, "reg_id");
$referal_id = generateRandomID($myHost, $myUser, $myPW, $myDB, $myReferTab, "referal_id");
// Insert the name into the database.
$query = "update {$myInfoTab} set first_reg_date = '" . date("r") . "', referal_id = '{$referal_id}' where reg_id = '{$username}'";
if (!@mysql_query($query, $connection)) {
print "Error inserting into table.";
}
print "id:" . $username;
//print "In middle.<br>" ;
// Unlock the table.
$query = "UNLOCK TABLES";
if (!@mysql_query($query, $connection)) {
die("Couldn't unlock.");
}
//print "At end.<br>" ;
