public static function AddRequest($requester_account_id, $requested_account_id)
{
$sqlCommand = "INSERT INTO accounts_network(requester_account_id, requested_account_id, created_datetime)" . "VALUES (?,?, NOW())";
$paramTypeSpec = "ii";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $stmt->errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param($paramTypeSpec, $requester_account_id, $requested_account_id)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$stmt->close();
$insertedID = $mysqli->insert_id;
$retrievedRecord = da_account::GetAccountNetworkEntry($insertedID);
return $retrievedRecord;
}
/**
* Returns the list of all content documents
* @param N/A
* return Array
*/
public static function GetListOfContents()
{
$sqlCommand = "SELECT document_id,title,description,Content FROM docs_and_drivers";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
if (!$stmt->execute()) {
echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}
$contentEntry = new be_content();
$stmt->bind_result($contentEntry->content_id, $contentEntry->title, $contentEntry->description, $contentEntry->Content);
$arrayResult = [];
while ($stmt->fetch()) {
$arrayResult[] = json_decode(json_encode($contentEntry));
}
$stmt->close();
return $arrayResult;
}
/**
*
* @param int $widget_id
* @return \be_widget
*/
public static function RemoveWidget($widget_id)
{
$sqlCommand = "UPDATE widgets " . " SET deleted_datetime = NOW() " . " WHERE widget_id = ? ";
$paramTypeSpec = "i";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $mysqli->connect_errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param($paramTypeSpec, widget_id)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$stmt->close();
$retrievedWidget = da_widgets::GetWidget($widget_id);
return $retrievedWidget;
}
public static function GetWidgetConfigListByID($widget_id)
{
$sqlCommand = "SELECT widget_config_id, widget_id, vse_label, simple_object_property, friendly_label, options_json" . " FROM widget_config " . " WHERE widget_id = ?" . " AND deleted_datetime IS NULL";
$paramTypeSpec = "i";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $stmt->errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param($paramTypeSpec, $widget_id)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$result = new be_widget_config();
$stmt->bind_result($result->widget_config_id, $result->widget_id, $result->vse_label, $result->simple_object_property, $result->friendly_label, $result->options_json);
$arrayResult = [];
while ($stmt->fetch()) {
$arrayResult[] = json_decode(json_encode($result));
}
// if (!$stmt->fetch()) {
// $result = NULL;
// }
$stmt->close();
return $arrayResult;
}
/**
*
*
* @return \be_widgettype
*/
public static function GetWidgetsTypes()
{
$sqlCommand = "SELECT widget_type_id, widget_type_name, description" . " FROM widget_types " . " WHERE deleted_datetime is null ";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $mysqli->connect_errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$widgetTypeEntry = new be_widgettype();
$stmt->bind_result($widgetTypeEntry->widget_type_id, $widgetTypeEntry->widget_type_name, $widgetTypeEntry->description);
$arrayResult = [];
while ($stmt->fetch()) {
$arrayResult[] = json_decode(json_encode($widgetTypeEntry));
}
$stmt->close();
return $arrayResult;
}
/**
*
* @param int $entry_id
* @return \be_vse_data
*/
private static function getSpecificEntry($entry_id)
{
$sqlCommand = "SELECT entry_id,app_id,vse_label,vse_value,vse_type,vse_annotations,captured_datetime,created_datetime " . " FROM vse_data WHERE entry_id = ? ";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $mysqli->connect_errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param("i", $entry_id)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$result = new be_vse_data();
$stmt->bind_result($result->entry_id, $result->app_id, $result->vse_label, $result->vse_value, $result->vse_type, $result->vse_annotations, $result->captured_datetime, $result->created_datetime);
if (!$stmt->fetch()) {
$result = NULL;
}
$stmt->close();
return $result;
}
public static function GetInvitationAvailability($account_id)
{
$sqlCommand = "SELECT COUNT(DISTINCT app_registry.app_id) AS app_number" . "FROM app_registry" . "INNER JOIN vse_data ON vse_data.app_id = app_registry.app_id" . "WHERE account_id=?";
$paramTypeSpec = "i";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $stmt->errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param($paramTypeSpec, $invitation_id)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$app_count = 0;
$result = false;
$stmt->bind_result($app_count);
if (!$stmt->fetch()) {
$result = false;
} else {
if ($app_count > 0) {
$result = true;
}
}
$stmt->close();
return $result;
}
/**
*
* @param be_generic_value_entry $valueEntry
* @return be_generic_value_entry
*/
public static function AddNewEntry($valueEntry)
{
$created_datetime = DA_Helper::GetServerDate();
$sqlCommand = "INSERT INTO generic_value_log (" . "app_id," . "value_label," . "value," . "value_type_code," . "captured_datetime," . "created_datetime " . ")" . " VALUES(?,?,?,?,?,?)";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
if (!$stmt->bind_param("isssss", $valueEntry->app_id, $valueEntry->value_label, $valueEntry->value, $valueEntry->value_type_code, $valueEntry->captured_datetime, $created_datetime)) {
echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
}
if (!$stmt->execute()) {
echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}
$insertedID = $mysqli->insert_id;
$stmt->close();
$retrievedValue = da_generic_value::GetEntry($insertedID);
print_r($retrievedValue);
return $retrievedValue;
}
/**
* Deletes a app by updating its deleted_datetime
* @param int $app_id
* @return be_app
*/
public static function DeleteApp($app_id)
{
$sqlCommand = "UPDATE app_registry " . " SET deleted_datetime = NOW() " . " WHERE app_id = ? ";
$paramTypeSpec = "i";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $mysqli->errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param($paramTypeSpec, $app_id)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$stmt->close();
$retrievedApp = da_apps_registry::GetApp($app_id);
return $retrievedApp;
}
/**
* Updates the data of an account
* @param be_account $account
* @return be_account
*/
public static function UpdateAccount($account)
{
$sqlCommand = "UPDATE accounts " . " SET confirmation_guid = ?," . " confirmed = ?," . " deleted_datetime = ?," . " email = ?," . " nickname = ?," . " pwd_hash = ?" . " WHERE account_id = ? ";
$paramTypeSpec = "sissssi";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $mysqli->connect_errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param($paramTypeSpec, $account->confirmation_guid, $account->confirmed, $account->deleted_datetime, $account->email, $account->nickname, $account->pwd_hash, $account->account_id)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$stmt->close();
$savedAccount = da_account::GetAccount($account->email);
return $savedAccount;
}
private static function getValidSession($account_id, $token)
{
$sqlCommand = "SELECT s.account_id, s.token, s.expiration_datetime, s.created_datetime, s.modified_datetime " . " FROM sessions s " . " WHERE s.account_id=? AND s.token=? AND NOW() < s.expiration_datetime ";
$mysqli = DA_Helper::mysqli_connect();
if ($mysqli->connect_errno) {
$msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
throw new Exception($msg, $mysqli->errno);
}
if (!($stmt = $mysqli->prepare($sqlCommand))) {
$msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->bind_param("is", $account_id, $token)) {
$msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
if (!$stmt->execute()) {
$msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
throw new Exception($msg, $stmt->errno);
}
$result = new be_session();
$stmt->bind_result($result->account_id, $result->token, $result->expiration_datetime, $result->created_datetime, $result->modified_datetime);
if (!$stmt->fetch()) {
$result = NULL;
}
$stmt->close();
return $result;
}
