public function __create($bookmarkurl, $title, $tokenval)
{
global $CFG, $DB;
$response = new CliniqueServiceResponce();
$token_val = array('token' => $tokenval);
$userId = array_values($DB->get_records_sql('SELECT userid FROM {external_tokens} et WHERE et.token=?', $token_val));
if ($userId) {
$user_id = array('id' => $userId[0]->userid);
//if(confirm_sesskey()){
$user = array_values($DB->get_records_sql('SELECT * FROM {user} u WHERE u.id=?', $user_id));
Favorites::__fav_user_login($user['0']);
if (get_user_preferences('user_bookmarks')) {
$bookmarks = explode(',', get_user_preferences('user_bookmarks'));
if (in_array($bookmarkurl . ";" . $title, $bookmarks)) {
$response->response(true, 'You have already bookmarked');
die;
}
} else {
$bookmarks = array();
}
//adds the bookmark at end of array
$bookmarks[] = $bookmarkurl . ";" . $title;
$bookmarks = implode(',', $bookmarks);
//adds to preferences table
set_user_preference('user_bookmarks', $bookmarks);
global $CFG;
//header("Location: " . $CFG->wwwroot . "/");
//print "Added Favourite Successfully";
$response->response(false, 'Added Favourite Successfully');
die;
} else {
$response->response(false, 'Invalid user');
die;
}
}
public function __remove($bookmarkurl, $title, $tokenval)
{
global $CFG, $DB;
$bookmarkurl = htmlspecialchars_decode($bookmarkurl);
$title = htmlspecialchars_decode($title);
$response = new CliniqueServiceResponce();
$token_val = array('token' => $tokenval);
// Get user token
/**
* @get user id from external_tokens table
*
*/
$userId = array_values($DB->get_records_sql('SELECT userid FROM {external_tokens} et WHERE et.token=?', $token_val));
if ($userId) {
$user_id = array('id' => $userId[0]->userid);
//if(confirm_sesskey()){
$user = array_values($DB->get_records_sql('SELECT * FROM {user} u WHERE u.id=?', $user_id));
Favorites::__fav_user_login($user['0']);
$bookmarks = explode(',', get_user_preferences('user_bookmarks'));
$bookmarkremoved = false;
foreach ($bookmarks as $bookmark) {
// check the bookmarkurl and title given values to delete from preference
$tempBookmark = explode(';', $bookmark);
if ($tempBookmark[0] == $bookmarkurl && $tempBookmark[1] == $title) {
$keyToRemove = array_search($bookmark, $bookmarks);
unset($bookmarks[$keyToRemove]);
$bookmarkremoved = true;
}
}
if ($bookmarkremoved == false) {
$response->response(true, 'The bookmark you requested does not exist');
die;
}
$bookmarks = implode(',', $bookmarks);
set_user_preference('user_bookmarks', $bookmarks);
global $CFG;
//header("Location: " . $CFG->wwwroot . $bookmarkurl);
$response->response(false, 'Removed Favorite Successfully');
die;
} else {
$response->response(true, 'Invalid user');
die;
}
}
public function __favorites($tokenval)
{
global $CFG, $DB;
$response = new CliniqueServiceResponce();
//$username = "******";
//$password = "******";
$token_val = array('token' => $tokenval);
//$token_val = array('token'=>"64217bb7eea6f343a19f3af17104c49b");
$userId = array_values($DB->get_records_sql('SELECT userid FROM {external_tokens} et WHERE et.token=?', $token_val));
if ($userId) {
$user_id = array('id' => $userId[0]->userid);
//if(confirm_sesskey()){
$user = array_values($DB->get_records_sql('SELECT * FROM {user} u WHERE u.id=?', $user_id));
Favorites::__fav_user_login($user['0']);
$favourites_user = get_user_preferences('user_bookmarks');
$favourites_user = explode(',', get_user_preferences('user_bookmarks'));
/// Accessibility: markup as a list.
$favBookmark = array();
$incr = 0;
//print_r($favourites_user);
foreach ($favourites_user as $favourite_bookmark) {
//$favBookmark = explode(';', $favourite_bookmark);
//echo json_encode($favBookmark); // return json format
//$response->response(false, $favBookmark);
$data = explode(';', $favourite_bookmark);
$id = $data[0] ? $data[0] : null;
$fileDetails = explode("@", $data[1]);
$res[$incr]['url'] = $data[0];
$res[$incr]['id'] = $fileDetails[0] ? $fileDetails[0] : null;
$res[$incr]['course_type'] = $fileDetails[1] ? $fileDetails[1] : null;
$res[$incr]['file_name'] = $fileDetails[2] ? $fileDetails[2] : null;
$res[$incr]['file_type'] = $fileDetails[3] ? $fileDetails[3] : null;
$res[$incr]['fname_upload'] = $fileDetails[4] ? $fileDetails[4] : null;
$incr++;
}
$response->response(false, 'success', $res);
} else {
$response->response(true, 'Invalid user');
}
}
public function __favorites($tokenval)
{
global $CFG, $DB;
$response = new CliniqueServiceResponce();
//$username = "******";
//$password = "******";
$token_val = array('token' => $tokenval);
//$token_val = array('token'=>"64217bb7eea6f343a19f3af17104c49b");
$userId = array_values($DB->get_records_sql('SELECT userid FROM {external_tokens} et WHERE et.token=?', $token_val));
if ($userId) {
$user_id = array('id' => $userId[0]->userid);
//if(confirm_sesskey()){
$user = array_values($DB->get_records_sql('SELECT * FROM {user} u WHERE u.id=?', $user_id));
Favorites::__fav_user_login($user['0']);
$favourites_user = get_user_preferences('user_bookmarks');
$favourites_user = explode(',', get_user_preferences('user_bookmarks'));
/// Accessibility: markup as a list.
$favBookmark = array();
$incr = 0;
//print_r($favourites_user);
foreach ($favourites_user as $favourite_bookmark) {
//$favBookmark = explode(';', $favourite_bookmark);
//echo json_encode($favBookmark); // return json format
//$response->response(false, $favBookmark);
$data = explode(';', $favourite_bookmark);
$id = $data[0] ? $data[0] : null;
$fileDetails = explode("@", $data[1]);
if ($fileDetails[0]) {
$getModInfo = $DB->get_record('course_modules', array('id' => $fileDetails[0]));
} else {
$getModInfo = '';
}
if ($getModInfo) {
$res[$incr]['url'] = $data[0];
$res[$incr]['id'] = $fileDetails[0] ? $fileDetails[0] : null;
$res[$incr]['course_type'] = $fileDetails[1] ? $fileDetails[1] : null;
$res[$incr]['file_name'] = $fileDetails[2] ? $fileDetails[2] : null;
$res[$incr]['file_type'] = $fileDetails[3] ? $fileDetails[3] : null;
$res[$incr]['fname_upload'] = $fileDetails[4] ? $fileDetails[4] : null;
$incr++;
}
}
if ($incr == 0) {
$res[$incr]['url'] = "";
$res[$incr]['id'] = null;
$res[$incr]['course_type'] = null;
$res[$incr]['file_name'] = null;
$res[$incr]['file_type'] = null;
$res[$incr]['fname_upload'] = null;
}
$fav_comment_count_sql = 'SELECT COUNT(urc.id) AS comment_count
FROM mdl_user_resource_comments urc
JOIN mdl_course_modules cm ON cm.id = urc.coursemoduleid
JOIN mdl_course c ON cm.course = c.id
JOIN mdl_resource r ON cm.instance = r.id
WHERE urc.userid = ' . $user_id['id'];
$comments_count = current($DB->get_records_sql($fav_comment_count_sql));
$res['resource_comment_count'] = $comments_count->comment_count;
$response->response(false, 'success', $res);
} else {
$response->response(true, 'Invalid user');
}
}
private static function getFavouties($userid)
{
global $DB;
$user = $DB->get_record('user', array('id' => $userid));
Favorites::__fav_user_login($user);
$favourites_user = get_user_preferences('user_bookmarks');
$favourites_user = explode(',', get_user_preferences('user_bookmarks'));
$favBookmark = array();
$incr = 0;
foreach ($favourites_user as $favourite_bookmark) {
$data = explode(';', $favourite_bookmark);
$id = $data[0] ? $data[0] : null;
$fileDetails = explode("@", $data[1]);
if ($fileDetails[0]) {
$getModInfo = $DB->get_record('course_modules', array('id' => $fileDetails[0]));
} else {
$getModInfo = '';
}
if ($getModInfo) {
$res[$incr]['url'] = $data[0];
$res[$incr]['id'] = $fileDetails[0] ? $fileDetails[0] : null;
$res[$incr]['course_type'] = $fileDetails[1] ? $fileDetails[1] : null;
$res[$incr]['file_name'] = $fileDetails[2] ? $fileDetails[2] : null;
$res[$incr]['file_type'] = $fileDetails[3] ? $fileDetails[3] : null;
$res[$incr]['fname_upload'] = $fileDetails[4] ? $fileDetails[4] : null;
$incr++;
}
}
if ($incr == 0) {
$res[$incr]['url'] = "";
$res[$incr]['id'] = null;
$res[$incr]['course_type'] = null;
$res[$incr]['file_name'] = null;
$res[$incr]['file_type'] = null;
$res[$incr]['fname_upload'] = null;
}
return $res;
}
