public function afterStoreCallback() { if ($this->isDirty()) { //add notification to writer of review if (!$this->review['host_id'] && $this->review['user_id'] !== $this['user_id']) { PersonalNotifications::add($this->review['user_id'], URLHelper::getURL("plugins.php/lernmarktplatz/market/discussion/" . $this['review_id'] . "#comment_" . $this->getId()), sprintf(_("%s hat einen Kommentar zu Ihrem Review geschrieben."), $this['host_id'] ? LernmarktplatzUser::find($this['user_id'])->name : get_fullname($this['user_id'])), "comment_" . $this->getId(), Icon::create("support", "clickable")); } //add notification to all users of this servers who discussed this review but are neither the new //commentor nor the writer of the review $statement = DBManager::get()->prepare("\n SELECT user_id\n FROM lernmarktplatz_comments\n WHERE review_id = :review_id\n AND host_id IS NULL\n GROUP BY user_id\n "); $statement->execute(array('review_id' => $this->review->getId())); foreach ($statement->fetchAll(PDO::FETCH_COLUMN, 0) as $user_id) { if (!in_array($user_id, array($this->review['user_id'], $this['user_id']))) { PersonalNotifications::add($user_id, URLHelper::getURL("plugins.php/lernmarktplatz/market/discussion/" . $this['review_id'] . "#comment_" . $this->getId()), sprintf(_("%s hat auch einen Kommentar geschrieben."), $this['host_id'] ? LernmarktplatzUser::find($this['user_id'])->name : get_fullname($this['user_id'])), "comment_" . $this->getId(), Icon::create("support", "clickable")); } } //only push if the comment is from this server and the material-server is different if (!$this['host_id']) { $myHost = LernmarktplatzHost::thisOne(); $data = array(); $data['host'] = array('name' => $myHost['name'], 'url' => $myHost['url'], 'public_key' => $myHost['public_key']); $data['data'] = $this->toArray(); $data['data']['foreign_comment_id'] = $data['data']['comment_id']; unset($data['data']['comment_id']); unset($data['data']['id']); unset($data['data']['user_id']); unset($data['data']['host_id']); $user_description_datafield = DataField::find(get_config("LERNMARKTPLATZ_USER_DESCRIPTION_DATAFIELD")) ?: DataField::findOneBySQL("name = ?", array(get_config("LERNMARKTPLATZ_USER_DESCRIPTION_DATAFIELD"))); if ($user_description_datafield) { $datafield_entry = DatafieldEntryModel::findOneBySQL("range_id = ? AND datafield_id = ?", array($this['user_id'], $user_description_datafield->getId())); } $data['user'] = array('user_id' => $this['user_id'], 'name' => get_fullname($this['user_id']), 'avatar' => Avatar::getAvatar($this['user_id'])->getURL(Avatar::NORMAL), 'description' => $datafield_entry ? $datafield_entry['content'] : null); $statement = DBManager::get()->prepare("\n SELECT host_id\n FROM lernmarktplatz_comments\n WHERE review_id = :review_id\n AND host_id IS NOT NULL\n GROUP BY host_id\n "); $statement->execute(array('review_id' => $this->review->getId())); $hosts = $statement->fetchAll(PDO::FETCH_COLUMN, 0); if ($this->review['host_id'] && !in_array($this->review['host_id'], $hosts)) { $hosts[] = $this->review['host_id']; } if ($this->review->material['host_id'] && !in_array($this->review->material['host_id'], $hosts)) { $hosts[] = $this->review->material['host_id']; } foreach ($hosts as $host_id) { $remote = new LernmarktplatzHost($host_id); if (!$remote->isMe()) { $review_id = $this->review['foreign_review_id'] ?: $this->review->getId(); if ($this->review['foreign_review_id']) { if ($this->review->host_id === $remote->getId()) { $host_hash = null; } else { $host_hash = md5($this->review->host['public_key']); } } else { $host_hash = md5($myHost['public_key']); } $remote->pushDataToEndpoint("add_comment/" . $review_id . "/" . $host_hash, $data); } } } } }
public function fetchData() { if ($this['host_id']) { $host = new LernmarktplatzHost($this['host_id']); if ($host) { $data = $host->fetchItemData($this['foreign_material_id']); if (!$data) { return false; } if ($data['deleted']) { return "deleted"; } //user: $user = LernmarktplatzUser::findOneBySQL("foreign_user_id", array($data['user']['user_id'], $host->getId())); if (!$user) { $user = new LernmarktplatzUser(); $user['foreign_user_id'] = $data['user']['user_id']; $user['host_id'] = $host->getId(); } $user['name'] = $data['user']['name']; $user['avatar'] = $data['user']['avatar'] ?: null; $user['description'] = $data['user']['description'] ?: null; $user->store(); //material: $material_data = $data['data']; unset($material_data['material_id']); unset($material_data['user_id']); unset($material_data['mkdate']); $this->setData($material_data); $this->store(); //topics: $this->setTopics($data['topics']); foreach ((array) $data['reviews'] as $review_data) { $currenthost = LernmarktplatzHost::findOneByUrl(trim($review_data['host']['url'])); if (!$currenthost) { $currenthost = new LernmarktplatzHost(); $currenthost['url'] = trim($review_data['host']['url']); $currenthost['last_updated'] = time(); $currenthost->fetchPublicKey(); if ($currenthost['public_key']) { $currenthost->store(); } } if ($currenthost && $currenthost['public_key'] && !$currenthost->isMe()) { $review = LernmarktplatzReview::findOneBySQL("foreign_review_id = ? AND host_id = ?", array($review_data['foreign_review_id'], $currenthost->getId())); if (!$review) { $review = new LernmarktplatzReview(); $review['foreign_review_id'] = $review_data['foreign_review_id']; $review['material_id'] = $this->getId(); $review['host_id'] = $currenthost->getId(); } $review['review'] = $review_data['review']; $review['rating'] = $review_data['rating']; if ($review_data['chdate']) { $review['chdate'] = $review_data['chdate']; } if ($review_data['mkdate']) { $review['mkdate'] = $review_data['mkdate']; } $user = LernmarktplatzUser::findOneBySQL("foreign_user_id", array($review_data['user']['user_id'], $currenthost->getId())); if (!$user) { $user = new LernmarktplatzUser(); $user['foreign_user_id'] = $review_data['user']['user_id']; $user['host_id'] = $currenthost->getId(); } $user['name'] = $review_data['user']['name']; $user['avatar'] = $review_data['user']['avatar'] ?: null; $user['description'] = $review_data['user']['description'] ?: null; $user->store(); $review['user_id'] = $user->getId(); $review->store(); } } } } return true; }
public function fetchRemoteSearch($text, $tag = false) { $endpoint_url = $this['url'] . "search_items"; if ($tag) { $endpoint_url .= "?tag=" . urlencode(studip_utf8encode($text)); } else { $endpoint_url .= "?text=" . urlencode(studip_utf8encode($text)); } $output = @file_get_contents($endpoint_url); if ($output) { $output = studip_utf8decode(json_decode($output, true)); foreach ((array) $output['results'] as $material_data) { $host = LernmarktplatzHost::findOneBySQL("public_key = ?", array($material_data['host']['public_key'])); if (!$host) { $host = new LernmarktplatzHost(); $host['url'] = $material_data['host']['url']; $host->fetchPublicKey(); $host->store(); } if (!$host->isMe()) { //set user: $user = LernmarktplatzUser::findOneBySQL("foreign_user_id", array($material_data['user']['user_id'], $host->getId())); if (!$user) { $user = new LernmarktplatzUser(); $user['foreign_user_id'] = $material_data['user']['user_id']; $user['host_id'] = $host->getId(); } $user['name'] = $material_data['user']['name']; $user['avatar'] = $material_data['user']['avatar'] ?: null; $user->store(); //set material: $material_data['data']['foreign_material_id'] = $material_data['data']['id']; $material = LernmarktplatzMaterial::findOneBySQL("foreign_material_id = ? AND host_id = ?", array($material_data['data']['foreign_material_id'], $host->getId())); if (!$material) { $material = new LernmarktplatzMaterial(); } unset($material_data['data']['id']); $material->setData($material_data['data']); $material['host_id'] = $host->getId(); $material['user_id'] = $user->getId(); $material->store(); //set topics: $material->setTopics($material_data['topics']); } } } }