<?php
require_once 'model/client_details_info_access.php';
require_once 'controller/dbconfig.php';
//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 ClientFormDetailsAccess($mysqli_connection);
$access->getClientDetails();
public function load_all_client_form_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_form_details_array = array();
$access = new ClientFormDetailsAccess($mysqli_connection);
$client_form_details_array = $access->load_all_client_form_details();
//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;
foreach ($client_form_details_array as $row) {
// $json = json_decode($row['form_json_data'],true);
// $json['id'] = $row['id'];
// $json['status'] = $row['status'];
// $json['timestamp'] = $row['timestamp'];
$container->client_form_details_array[] = $row;
}
return $container;
}
public function create_client_form_details($client_form_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_form_details_do = new ClientFormDetailsDO();
$client_form_details_do->m_client_id = $client_form_details->client_id;
$client_form_details_do->m_form_json_data = $client_form_details->form_json_data;
$client_form_details_do->m_timestamp = $client_form_details->timestamp;
$client_form_details_do->m_status = $client_form_details->client_status;
$access = new ClientFormDetailsAccess($mysqli_connection);
$success = $access->create_client_form_details($client_form_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;
}
