function select_test($table, $data, $condition)
{
include '../helpers/QueryGenrator.php';
$QueryGen = new QueryGenrator();
include '../Models/Database.php';
$DB = new DatabaseModel();
$Query = $QueryGen->select($table, $data, $condition);
$DBEntry = $DB->select($Query);
print_r($DBEntry);
}
/**
* Created by PhpStorm.
* User: sp
* Date: 25/11/15
* Time: 3:56 PM
*/
function GetUsername($Data)
{
$table = 'userinfo';
require_once '../common/Models/Database.php';
require_once '../common/helpers/QueryGenrator.php';
$QueryGen = new QueryGenrator();
$DB = new DatabaseModel();
$Username = $Data['Username'];
$Query = $QueryGen->select($table, $Data = "None", $Condition = "WHERE `Username` = '{$Username}'");
$DBEntry = $DB->select($Query);
return $DBEntry;
}
/**
* Created by PhpStorm.
* User: root
* Date: 21/11/15
* Time: 5:42 PM
*/
function GetUser($Data)
{
$table = 'userinfo';
include '../common/Models/Database.php';
include '../common/helpers/QueryGenrator.php';
$QueryGen = new QueryGenrator();
$DB = new DatabaseModel();
$Token = $Data['Token'];
$Query = $QueryGen->select($table, $Data = "None", $Condition = "WHERE `AccessToken` = '{$Token}'");
$DBEntry = $DB->select($Query);
return $DBEntry;
}
/**
* Created by PhpStorm.
* User: root
* Date: 21/11/15
* Time: 5:42 PM
*/
function AddToken($Data)
{
include '../common/Models/Database.php';
include '../common/helpers/QueryGenrator.php';
$table = 'userinfo';
$QueryGen = new QueryGenrator();
$DB = new DatabaseModel();
$data = array("AccessToken" => getGUID());
$Email = $Data['Email'];
$Password = $Data['Password'];
$condition = "WHERE Email = '{$Email}' AND Password = '******'";
$QueryCheck = $Query = $QueryGen->select($table, $DATA = "None", $condition);
$CheckInfo = $DB->select($QueryCheck);
if ($CheckInfo == ERROR_DATA_NOT_FOUND) {
return ERROR_DATA_NOT_FOUND;
}
$Query = $QueryGen->update($table, $data, $condition);
$DBEntry = $DB->update($Query);
return $data['AccessToken'];
}
/**
* Created by PhpStorm.
* User: root
* Date: 21/11/15
* Time: 5:42 PM
*/
function GetFile($Username)
{
$table = 'codes';
require_once '../common/Models/Database.php';
require_once '../common/helpers/QueryGenrator.php';
$QueryGen = new QueryGenrator();
$DB = new DatabaseModel();
$Query = $QueryGen->select($table, $Data = "None", $Condition = "WHERE `Username` = '{$Username}'");
$GetResponse = $DB->select($Query);
if ($GetResponse != 903) {
$Response["STATUS"] = "True";
$Response["STATUS CODE"] = 200;
$Response['Payloads'] = $GetResponse;
} else {
$Response["STATUS"] = "True";
$Response["STATUS CODE"] = 903;
$Response["Message"] = "No Data Found";
}
return $Response;
}
