public function load_client_details_by_enrolled_name($client_details) { //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) { $container->show_failure_message = true; $container->error_message = "Failed to connect to MySQL: (" . $mysqli_connection->connect_errno . ") " . $mysqli_connection->connect_error; return $container; } $client_details_array = array(); $access = new ClientDetailsAccess($mysqli_connection); $client_details_array = $access->load_client_details_by_enrolled_name($client_details->client_enrolled_by); //Validate whether order loading is successful or not. if ($access->m_status == false) { $container->show_failure_message = true; $container->error_message = "No Record found"; //Close the connection $mysqli_connection->close(); return $container; } $container->success = true; $container->client_details_array = $client_details_array; return $container; }
public function load_client_details_by_phone_number($phone_number) { //$client_details = array("Error"=> "Data Not Found", "status"=>"false"); //return $client_details; //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; return $container; } //Set auto-commit to FALSE explicitly if (!$mysqli_connection->autocommit(FALSE)) { return; } $access = new ClientDetailsAccess($mysqli_connection); $client_details = $access->load_by_client_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) { $container->show_failure_message = true; //Close the connection $mysqli_connection->close(); $client_details = array("Error" => "Data Not Found", "status" => "false"); } return $client_details; }
public function load_client_details_by_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; $client_details = array("Error" => "Database error occured", "status" => "false"); return $client_details; } //Set auto-commit to FALSE explicitly if (!$mysqli_connection->autocommit(FALSE)) { return; } $access = new ClientDetailsAccess($mysqli_connection); $client_details = $access->load_by_client_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(); //$client_details = array("Error"=> "Data Not Found", "status"=>"false"); } return $client_details; }
public function update_client_details($client_details) { //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; return $container; } //Set auto-commit to FALSE explicitly if (!$mysqli_connection->autocommit(FALSE)) { return; } $client_details_do = new ClientDetailsDO(); $client_details_do->m_client_id = $client_details->client_id; $client_details_do->m_status = $client_details->client_status; $access = new ClientDetailsAccess($mysqli_connection); $success = $access->update_client_details($client_details_do); //Validate whether order loading is successful or not. if ($success == false) { $container->show_failure_message = true; //Close the connection $mysqli_connection->close(); return $container; } if (!$mysqli_connection->commit()) { $container->show_failure_message = true; $container->failure_message = "Sorry for the Inconvenience. We are unable to cancel this Order."; $mysqli_connection->close(); return $container; } $container->success = true; return $container; }