function social_worker_login($login_container)
{
//Create a container object which will hold complete information required to display the complete order page
$container = new stdClass();
//Establish mysqli connection
$mysqli_connection = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if ($mysqli_connection->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli_connection->connect_errno . ") " . $mysqli_connection->connect_error;
$container->show_failure_message = true;
$container->destination_page = LOGIN_PAGE;
return $container;
}
//Set auto-commit to FALSE explicitly
if (!$mysqli_connection->autocommit(FALSE)) {
echo "Failed to turn off auto-commit to false";
}
$sw_details_info_do = new SocialWorkerDetailsDO();
$sw_details_info_access = new SocialWorkerDetailsAccess($mysqli_connection);
$sw_details_info_do = $sw_details_info_access->load_by_sw_details_phonenumber($login_container->login_username);
//Validate whether order loading is successful or not.
if ($sw_details_info_access->m_status == false || $sw_details_info_access->m_status_code == STATUS_FETCH_NO_DATA) {
echo "Failed to load Admin details for the Admin User Name - " . $admin_login_container->user_name;
$container->show_failure_message = true;
$container->destination_page = LOGIN_PAGE;
//Close the connection
$mysqli_connection->close();
return $container;
}
//Password Validation
if (!strcmp($sw_details_info_do->password, $login_container->password)) {
echo "User Authentication Successful.";
} else {
echo "User Authentication Failed. Password Mismatch.";
$container->show_failure_message = true;
$container->destination_page = ADMIN_LOGIN_PAGE;
//Close the connection
$mysqli_connection->close();
return $container;
}
$container->sw_user_loggedin = true;
$container->sw_user_name = $sw_details_info_do->m_name;
//everything is fine
$mysqli_connection->commit();
//Close the connection
$mysqli_connection->close();
return $container;
}
public function load_clients_by_sw_details_phone_number($phone_number)
{
//Establish mysqli connection
$mysqli_connection = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if ($mysqli_connection->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli_connection->connect_errno . ") " . $mysqli_connection->connect_error;
$sw_details = array("Error" => "Database error occured", "status" => "false");
return $sw_details;
}
//Set auto-commit to FALSE explicitly
if (!$mysqli_connection->autocommit(FALSE)) {
return;
}
$access = new SocialWorkerDetailsAccess($mysqli_connection);
$sw_details = $access->load_clients_by_sw_phone_number($phone_number);
//Validate whether order loading is successful or not.
if ($access->m_status == false || $access->m_status_code == STATUS_FETCH_NO_DATA) {
//Close the connection
$mysqli_connection->close();
}
return $sw_details;
}