/**
*
* @param type $entry
* @return type $last_inserted_id (the ID generated in the last query)
*/
public function addEntry($entry)
{
$trm = new TranslationRequestManager();
$id = $entry->getEntryId();
$langid = $entry->getEntryLanguageId();
$text = $entry->getEntryText();
// 1
// TODO: create the verbatim of $text using the Bing translator
$verbatim = $entry->getEntryVerbatim();
// 2
// TODO: transliterate the value of $text using ...
$translit = $entry->getEntryTranslit();
// 3
$authen = $entry->getEntryAuthenStatusId();
// 4
$translOf = $entry->getEntryTranslOf();
// 5
$userId = $entry->getEntryUserId();
// 6
$mediaId = $entry->getEntryMediaId();
// 7
$commentId = $entry->getEntryCommentId();
// 8
$ratingId = $entry->getEntryRatingId();
// 9
$tags = $entry->getEntryTags();
//10
//$authorId = $entry->getEntryAuthorId(); // 11
$authors = $entry->getEntryAuthors();
$sourceId = $entry->getEntrySourceId();
// 12
$use = $entry->getEntryUse();
// 13
$link = $entry->getEntryHttpLink();
// 14
$date = $entry->getEntryCreationDate();
// 15
$query_insert = 'INSERT INTO ' . ENTRY . ' (' . '`ent_entry_language_id`, ' . '`ent_entry_text`, ' . '`ent_entry_verbatim`, ' . '`ent_entry_translit`, ' . '`ent_entry_authen_status_id`, ' . '`ent_entry_translation_of`, ' . '`ent_entry_creator_id`, ' . '`ent_entry_media_id`, ' . '`ent_entry_comment_id`, ' . '`ent_entry_rating_id`, ' . '`ent_entry_tags`, ' . '`ent_entry_authors`, ' . '`ent_entry_source_id`, ' . '`ent_entry_use`, ' . '`ent_entry_http_link`, ' . '`ent_entry_creation_date`)' . ' VALUES(' . '"' . $langid . '", "' . $text . '", "' . $verbatim . '", "' . $translit . '", ' . $authen . ', "' . $translOf . '", "' . $userId . '", "' . $mediaId . '", "' . $commentId . '", "' . $ratingId . '", "' . $tags . '", "' . $authors . '", "' . $sourceId . '", "' . $use . '", "' . $link . '", "' . $date . '")';
// 51
//echo "<br>eda::query_insert:<br>"; echo $query_insert;
$dbHelper = new DBHelper();
// 18
$last_inserted_id = $dbHelper->executeInsertQuery($query_insert);
// 17
//16
//..............................................................
// if this is a kid, delete the treq for its dad if exists
if (!null == $translOf) {
// if the entry being created has a dad (i.e. is a kid)
//echo "<br>eda::translOf = " . $translOf;
// look into the treq table, see if there's a treq for this entry and for this $langid
$treq = $trm->getTreqAllColumnsByEntryIdAndLangId($translOf, $langid);
$treq_id = $treq->getTreqId();
$treq_entry_id = $treq->getTreqEntryId();
//$treq_lang_id = $treq->getTreqLangId();
//echo "<br>eda::AddEntry - treq id = " . $treq_id;
//echo "<br>eda::AddEntry - treq entry id = " . $treq_entry_id;
//echo "<br>eda::AddEntry - treq lang id = " . $treq_lang_id;
// if there is/are, delete it/them
if (!null == $treq_entry_id) {
$treq_delete_sql = 'DELETE FROM ' . TRANS_REQUEST . ' WHERE treq_id = ' . $treq_id . ';';
//echo "<br>eda::AddEntry - treq delete sql = " . $treq_delete_sql;
$dbHelper->executeQuery($treq_delete_sql);
}
}
//..............................................................
return $last_inserted_id;
}
//LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
//require("search.php");
require_once BUSINESS_DIR_ENTRY . "EntryManager.php";
require_once BUSINESS_DIR_TRANSLREQ . "TranslationRequestManager.php";
require_once BUSINESS_DIR_SUBSCRIPTION . 'Subscription.php';
require_once BUSINESS_DIR_SUBSCRIPTION . 'SubscriptionManager.php';
require_once BUSINESS_DIR_USER . 'User.php';
require_once BUSINESS_DIR_USER_LOGIN . 'UserLoginManager.php';
//require DB_CONNECTION . 'DBHelper.php';
//require DB_CONNECTION . 'datainfo.php';
$lang = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2);
// 1
//$lang = 'ru';
//echo "the language: " . $lang;
$em = new EntryManager();
$trm = new TranslationRequestManager();
$aryOfEntry = $em->getListOfEntryBriefByLanguage($lang);
$aryOfTreq = $trm->getListOfTreqByLang($lang);
?>
<div id="index_table_container" align="center">
<!-- left column -->
<div>
<div id="LeftCol">
<object id="obj"
type="text/html"
data="views/entry/search_phrase_examples.html">
</object>
</div><!--LeftCol-->
<div id="MidCol">
<div>
<div class="container" style="border-collapse: inherit; width: 99%; font-size: 20px;">
<?php
include_once 'config.php';
require_once BUSINESS_DIR_TRANSLREQ . 'TranslationRequestManager.php';
require_once BUSINESS_DIR_TRANSLREQ . 'TranslationRequest.php';
require_once BUSINESS_DIR_LANG . 'LanguageManager.php';
date_default_timezone_set('America/Toronto');
$userid = intval($_GET['u']);
$entryid = intval($_GET['e']);
$langid = intval($_GET['l']);
$treq = new TranslationRequest();
$trm = new TranslationRequestManager();
$lm = new LanguageManager();
$treqLang = $lm->getLanguageById($langid);
// check if a treq for that entry for that language already exists
$existingTreqs = $trm->getListOfTreqByEntryIdAndLangId($entryid, $langid);
if (sizeof($existingTreqs) <= 1) {
// if there's just an empty array element
$treq->setTreqCreatorId($userid);
$treq->setTreqEntryId($entryid);
$treq->setTreqLang($langid);
$treq->setTreqDate(date('Y-m-d'));
//var_dump($treq);
$treq_id = $trm->createTreq($treq);
//echo "<br>treq_id " . $treq_id;
$treqbrief = $trm->getTreqBriefById($treq_id);
//var_dump($treqbrief);
echo "<span id='treqResp'><b>" . $treqbrief[0]->getTreqLang() . "</b> translation requested</span>";
} else {
echo "<span id='treqResp'><mark>" . "Sorry, a request for <b>" . $treqLang->getLangName() . "</b> was already created on " . $existingTreqs[0]->getTreqDate() . "</mark></span>";
}
require_once BUSINESS_DIR_TRANSLREQ . 'TranslationRequest.php';
require_once BUSINESS_DIR_LANG . "LanguageManager.php";
require_once BUSINESS_DIR_LANG . "Language.php";
//Check if user is logged in or not
if (!isset($_GET['id']) && !isset($_POST['id'])) {
echo "neither (GET['id']) nor (POST['id'])";
}
if (isset($_GET['id'])) {
// echo "we have GET[id], it is " . $_GET['id'] . "<br>";
$entryId = $_GET['id'];
} elseif (isset($_POST['id'])) {
echo "we have POST[id], it is " . $_POST['id'] . "<br>";
$entryId = $_POST['id'];
}
$em = new EntryManager();
$trm = new TranslationRequestManager();
$entry = $em->getEntryById($entryId);
// 1
$treqs = $trm->getTreqByEntryId($entry->getEntryId());
$lm = new LanguageManager();
$um = new UserManager();
//$userId = 3; // the id of the current logged-in user
$loggedIn_userId = "";
$loggedIn_userType = "";
$user_logged_in = true;
if (isset($_SESSION['user'])) {
$user = $_SESSION['user'];
$loggedIn_userId = $user->getUserId();
$loggedIn_userType = $user->getUserType();
//echo "logged in user id==".$loggedIn_userId;
} else {
<?php
include_once 'config.php';
require_once BUSINESS_DIR_TRANSLREQ . 'TranslationRequestManager.php';
require_once BUSINESS_DIR_TRANSLREQ . 'TranslationRequest.php';
date_default_timezone_set('America/Toronto');
$userid = intval($_GET['u']);
$entryid = intval($_GET['e']);
$langid = intval($_GET['l']);
$treq = new TranslationRequest();
$trm = new TranslationRequestManager();
$treq->setTreqCreatorId($userid);
$treq->setTreqEntryId($entryid);
$treq->setTreqLang($langid);
$treq->setTreqDate(date('Y-m-d'));
$treq_id = $trm->createTreq($treq);
$treqbrief = $trm->getTreqBriefById($treq_id);
echo "<span id='treqResp'><b>" . $treqbrief->getTreqLang() . "</b> translation requested</span>";
