public function translate($language)
{
$source_arr = $this->getLanguage();
if (is_array($source_arr) && isset($source_arr['id'])) {
$source = $source_arr['id'];
}
$target_arr = explode('-', $language);
$target = $target_arr[0];
$translations = array();
$translations = $this->getAllTranslations();
$translator = new LanguageTranslator('AIzaSyBlwXdmxJZ__ZNScwe4zq5r3qh3ebXb26k');
if (count($translations)) {
foreach ($translations as $node) {
if ($node['language']['id'] == $target) {
$slide = new Slide();
$slide->slide_id = $node['id'];
$slide->createFromIDLite($slide->getLastRevisionID());
return $slide->id;
}
}
}
$old_slide_id = $this->slide_id;
//for questions
$this->symbolsToLatex();
$replace_array = array();
$replace_array = $this->filterTags();
$q = $this->content;
$content = '';
$translation = $translator->translate($q, $target, $source);
if ($translation != -1) {
$tags_back = $this->addTagsBack($translation, $replace_array);
$content = '<div lang="' . $target . '-x-mtfrom-' . $source . '">' . $tags_back . '</div>';
$this->language = $language;
$this->translated_from = $this->slide_id;
$translated_from_revision = $this->id;
$this->content = $content;
$this->description = $this->getDescription();
$this->latexToSymbols();
$based_on = NULL;
$this->slide_id = $this->dbInsert('slide', array('user_id' => $this->user->id, 'description' => $this->description, 'language' => $this->language, 'translated_from' => $this->translated_from, 'translated_from_revision' => $translated_from_revision));
$new_slide_id = $this->slide_id;
//for questions
$this->translateQuestions($old_slide_id, $new_slide_id, $source_arr, $language);
$this->based_on = NULL;
$this->id = $this->dbInsert('slide_revision', array('slide' => $this->slide_id, 'content' => $this->content, 'user_id' => $this->user->id, 'comment' => $this->comment, 'based_on' => $based_on, 'note' => $this->note, 'translation_status' => 'google', 'translated_from_revision' => $translated_from_revision));
return $this->id;
} else {
return -1;
}
}
function reportSlideChanges()
{
$this->_template->disableHeader();
$this->_template->disableFooter();
$id = @$_GET['slide'];
$compareTo = @$_GET['compareTo'];
if (!isset($id)) {
die("Error in receiving Slide id!");
}
$slide1 = new Slide();
$slide2 = new Slide();
$slide1->createFromIDLite($id);
if (!isset($compareTo)) {
$slide2->id = $slide1->getPreviousRevisionID();
} else {
$slide2->id = $compareTo;
}
$slide2->createFromIDLite($slide2->id);
//$slide2->content=$this->tidyhtml($slide2->content);
//$slide1->content=$this->tidyhtml($slide1->content);
$this->set('new_content', htmlspecialchars($slide1->content));
$this->set('old_content', htmlspecialchars($slide2->content));
$this->set('slide_id', $id);
//echo $this->htmlDiff($slide2->content, $slide1->content);
}
public function fetchDeckContentLite()
{
$this->initConnection();
$deck = null;
$slide = null;
$res = array();
// get content
$deckContent = $this->dbQuery('SELECT * FROM deck_content WHERE deck_revision_id=:id ORDER BY position', array('id' => $this->id));
/*if (! $deckContent)
die ( "error querying db for deck content: " . mysql_error () );*/
// parse content
foreach ($deckContent as $item) {
// if it's deck
if ($item['item_type'] == 'deck') {
$deck = new Deck();
$deck->createFromIDLite($item['item_id']);
$deck->content = $deck->fetchDeckContentLite();
$deck->position = $item['position'];
$res[] = $deck;
} else {
$slide = new Slide();
$slide->createFromIDLite($item['item_id']);
$slide->position = $item['position'];
$slide->deck = new Deck();
$slide->deck->id = $item['deck_revision_id'];
$slide->deck->title = $slide->deck->getTitle();
$slide->deck->slug_title = $slide->sluggify($slide->deck->title);
$res[] = $slide;
}
}
return $res;
}
public function getFollowedSlides()
{
$this->initConnection();
$res = array();
$res_array = $this->dbQuery('SELECT * FROM subscription WHERE item_type="slide" AND user_id=:id', array('id' => $this->id));
foreach ($res_array as $row) {
$slide = new Slide();
$slide->slide_id = $row['item_id'];
$slide->createFromIDLite($slide->getLastRevisionID());
$title = $slide->getTitle();
$slide->title = $slide->shortenTitle($title);
$res[] = $slide;
}
return $res;
}
public function getCreateQuestionRevision($user_id = false, $start, $end, $keywords = '')
{
if ($user_id) {
$user = new User();
$user->id = $user_id;
$user->getUsername();
$this->initConnection();
$activities = array();
$result = array();
if (strlen($keywords)) {
$result = $this->dbQuery('SELECT * FROM questions WHERE user_id=:user_id AND based_on IS NOT NULL AND MATCH (question) AGAINST (\'' . $keywords . '*\' IN BOOLEAN MODE)', array('user_id' => $user_id));
} else {
$result = $this->dbQuery('SELECT * FROM questions WHERE user_id=:user_id AND based_on IS NOT NULL AND timestamp >= "' . $start . '" AND timestamp < "' . $end . '"', array('user_id' => $user_id));
}
if (count($result)) {
foreach ($result as $row) {
$question = new Question();
$question->question = $row['question'];
$text = new Slide();
$text->slide_id = $row['item_id'];
$text->createFromIDLite($text->getLastRevisionID());
$text->title = $text->getTitle();
if ($text->title == "") {
$text->title = "Untitled";
}
$activity = new Activity($row['timestamp'], $user, 'created_question', $question, $text);
$activities[] = $activity;
}
}
if (count($activities)) {
foreach ($activities as $activity) {
$this->activities[] = $activity;
}
}
}
}
