/**
*
* @return \models\API2ApplicationUserTokenModel
*/
public function loadByAppAndUserTokenAndUserSecret(API2ApplicationModel $app, $userToken, $userSecret)
{
global $DB;
$stat = $DB->prepare("SELECT api2_application_user_token_information.*, user_in_api2_application_information.is_editor " . " FROM api2_application_user_token_information" . " JOIN user_in_api2_application_information ON user_in_api2_application_information.is_in_app = '1' " . " AND user_in_api2_application_information.user_id = api2_application_user_token_information.user_id " . " AND user_in_api2_application_information.api2_application_id = api2_application_user_token_information.api2_application_id " . " WHERE api2_application_user_token_information.api2_application_id = :api2_application_id " . " AND api2_application_user_token_information.user_token = :user_token AND api2_application_user_token_information.user_secret = :user_secret");
$stat->execute(array('api2_application_id' => $app->getId(), 'user_token' => $userToken, 'user_secret' => $userSecret));
if ($stat->rowCount() > 0) {
$token = new API2ApplicationUserTokenModel();
$token->setFromDataBaseRow($stat->fetch());
return $token;
}
}
/**
*
* @return \models\API2ApplicationModel
*/
public function loadByAppAndRequestToken(API2ApplicationModel $app, $requestToken)
{
global $DB;
$stat = $DB->prepare("SELECT api2_application_request_token.* FROM api2_application_request_token" . " WHERE api2_application_id = :api2_application_id AND request_token = :request_token");
$stat->execute(array('api2_application_id' => $app->getId(), 'request_token' => $requestToken));
if ($stat->rowCount() > 0) {
$token = new API2ApplicationRequestTokenModel();
$token->setFromDataBaseRow($stat->fetch());
return $token;
}
}
/**
*
* @return \models\UserInAPI2ApplicationModel
*/
public function loadByUserAndApplication(UserAccountModel $user, API2ApplicationModel $app)
{
global $DB;
$stat = $DB->prepare("SELECT user_in_api2_application_information.* FROM user_in_api2_application_information " . "WHERE api2_application_id =:api2_application_id AND user_id =:user_id");
$stat->execute(array('api2_application_id' => $app->getId(), 'user_id' => $user->getId()));
if ($stat->rowCount() > 0) {
$app = new UserInAPI2ApplicationModel();
$app->setFromDataBaseRow($stat->fetch());
return $app;
}
}
public function fetchAll()
{
$this->buildStart();
$this->build();
$this->buildStat();
$results = array();
while ($data = $this->stat->fetch()) {
$area = new API2ApplicationModel();
$area->setFromDataBaseRow($data);
$results[] = $area;
}
return $results;
}
/**
*
* @return \models\API2ApplicationModel
*/
public function edit(API2ApplicationModel $app, UserAccountModel $user = null)
{
global $DB;
$stat = $DB->prepare("UPDATE api2_application_information SET " . "user_id = :user_id,title = :title,description = :description,is_editor = :is_editor," . "is_callback_url = :is_callback_url," . "is_callback_display = :is_callback_display,is_callback_javascript = :is_callback_javascript," . "allowed_callback_urls = :allowed_callback_urls,is_auto_approve = :is_auto_approve,is_all_sites = :is_all_sites," . "is_closed_by_sys_admin = :is_closed_by_sys_admin,closed_by_sys_admin_reason = :closed_by_sys_admin_reason" . " WHERE id=:id");
$stat->execute(array('user_id' => $app->getUserId(), 'title' => $app->getTitle(), 'description' => $app->getDescription(), 'is_editor' => $app->getIsEditor() ? 1 : 0, 'is_callback_url' => $app->getIsCallbackUrl() ? 1 : 0, 'is_callback_display' => $app->getIsCallbackDisplay() ? 1 : 0, 'is_callback_javascript' => $app->getIsCallbackJavascript() ? 1 : 0, 'allowed_callback_urls' => $app->getAllowedCallbackUrls(), 'is_auto_approve' => $app->getIsAutoApprove() ? 1 : 0, 'is_all_sites' => $app->getIsAllSites() ? 1 : 0, 'is_closed_by_sys_admin' => $app->getIsClosedBySysAdmin() ? 1 : 0, 'closed_by_sys_admin_reason' => $app->getClosedBySysAdminReason(), 'id' => $app->getId()));
}
/**
* @dataProvider dataForTtestCallbackURLMatches
*/
function testCallbackURLMatches($allowed_urls, $url, $result)
{
$app = new API2ApplicationModel();
$app->setAllowedCallbackUrls($allowed_urls);
$this->assertEquals($result, $app->isCallbackUrlAllowed($url));
}
public function setFromApp(API2ApplicationModel $app)
{
$this->is_editor = $app->getIsEditor() ? 1 : 0;
}
