public function addUser($user)
{
$dbHelper = new DBHelper();
//All the data members are being passed through the escape string function
$uid = $dbHelper->EscapeString($user->getUserId());
$fname = $dbHelper->EscapeString($user->getFirstName());
$lname = $dbHelper->EscapeString($user->getLastName());
//First escape the string, and then change it to hash
$pwd = sha1($user->getPassword());
$loginid = $dbHelper->EscapeString($user->getLogin());
$email = $dbHelper->EscapeString($user->getEmail());
$dob = $dbHelper->EscapeString($user->getDOB());
$language = $dbHelper->EscapeString($user->getUserLanguage());
$usertype = $dbHelper->EscapeString($user->getUserType());
$regdate = $dbHelper->EscapeString($user->getRegistrationDate());
$location = $dbHelper->EscapeString($user->getLocation());
//Null for now, because we do not need it..
$mediaid = null;
//$dbHelper->EscapeString($user->getMediaId();
$ratingid = null;
//$dbHelper->EscapeString($user->getUserRatingId());
$emailsub = null;
//$dbHelper->EscapeString($user->getEmailSub());
$query_insert = "INSERT INTO " . USER . " VALUES('', '{$fname}', '{$lname}','{$loginid}','{$pwd}','{$ratingid}','{$mediaid}','{$email}','{$dob}','{$location}','{$regdate}','{$usertype}','{$language}','{$emailsub}')";
$result = $dbHelper->executeInsertQuery($query_insert);
//$last_inserted_id = mysql_insert_id();
return $result;
//which will return the last inserted id
}
public function addReport($report)
{
$id = $report->getId();
$reason = $report->getReason();
$entity_for_report = $report->getEntityForReport();
$entity_id = $report->getEntityId();
$reported_by = $report->getReportedBy();
$query_insert = "INSERT INTO " . REPORT . " (rep_reason, rep_entity_for_report, rep_entity_id, rep_reported_by, rep_reported_on) \n VALUES ('" . $reason . "', '" . $entity_for_report . "', '" . $entity_id . "', '" . $reported_by . "', NOW())";
$dbHelper = new DBHelper();
$last_inserted_id = $dbHelper->executeInsertQuery($query_insert);
return $last_inserted_id;
}
public function addRating($rating)
{
$id = $rating->getId();
$entity_id = $rating->getEntityId();
$like_user_id = $rating->getLikeUserId();
$dislike_user_id = $rating->getDislikeUserId();
//echo "RatingDataAccessor->addRating dislike_user_id: ".$dislike_user_id;
$query_insert = "INSERT INTO " . RATING . " (rat_entity_id, rat_like_user_id, rat_dislike_user_id, rat_created_on)\n VALUES ('" . $entity_id . "', '" . $like_user_id . "', '" . $dislike_user_id . "', NOW())";
//echo "RatingDataAccessor->addRating insert query: ".$query_insert."\n";
$dbHelper = new DBHelper();
$last_inserted_id = $dbHelper->executeInsertQuery($query_insert);
return $last_inserted_id;
}
public function AddProficient($ProfData)
{
$dbHelper = new DBHelper();
//All the data members are being passed through the escape string function
$userid = $dbHelper->EscapeString($ProfData->getUserId());
$langid = $dbHelper->EscapeString($ProfData->getLanguageId());
$prof = $dbHelper->EscapeString($ProfData->getProf());
$query_insert = "INSERT INTO " . LANGUAGE_PROF . " VALUES('', '{$userid}', '{$langid}','{$prof}')";
//echo $query_insert;
$result = $dbHelper->executeInsertQuery($query_insert);
//returns the last row inserted..
return $result;
}
public function addTreq($treq)
{
$creator_id = $treq->getTreqCreatorId();
$entry_id = $treq->getTreqEntryId();
$lang_id = $treq->getTreqLang();
$date = $treq->getTreqDate();
$insert_query = 'INSERT INTO
' . TRANS_REQUEST . ' (
treq_creator_id,
treq_entry_id,
treq_target_lang_id,
treq_date
)
VALUES (' . $creator_id . ',' . $entry_id . ',' . $lang_id . ',"' . $date . '");';
//echo "<br>trda::addTreq() insert_query:<br>" . $insert_query;
$dbHelper = new DBHelper();
$last_inserted_id = $dbHelper->executeInsertQuery($insert_query);
return $last_inserted_id;
}
public function addComment($comment)
{
//$id = $comment->getId();
$text = $comment->getText();
$rating_id = $comment->getRatingId();
$created_by = $comment->getCreatedBy();
$entry_id = $comment->getEntryId();
$rating_id = isset($rating_id) ? $rating_id : "";
//printf ("CommentDataAccess text: ". $text."<br/>");
//printf ("CommentDataAccess rating_id: ". $rating_id."<br/>");
//printf ("CommentDataAccess created_by: ". $created_by."<br/>");
//printf ("CommentDataAccess entry_id: ". $entry_id."<br/>");
if ($rating_id != "") {
$query_insert = "INSERT INTO " . COMMENT . " (com_text, com_rating_id, com_created_by, com_entry_id, com_created_on) \n VALUES ('" . $text . "', " . $rating_id . ", " . $created_by . ", '" . $entry_id . "', NOW())";
} else {
$query_insert = "INSERT INTO " . COMMENT . " (com_text, com_created_by, com_entry_id, com_created_on) \n VALUES ('" . $text . "', " . $created_by . ", '" . $entry_id . "', NOW())";
}
$dbHelper = new DBHelper();
$last_inserted_id = $dbHelper->executeInsertQuery($query_insert);
//printf ("CommentDataAccess mysqli_insert_id: ". $last_inserted_id);
return $last_inserted_id;
}
/**
*
* @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;
}
public function addLocation($location)
{
$countryname = $location->getCountryName();
$provincename = $location->getProvinceName();
$cityname = $location->getCityName();
$countrycode = $location->getCountryCode();
$query_insert = "INSERT INTO " . COUNTRY . " VALUES('', '" . $countryname . "','" . $countrycode . "')";
$dbHelper = new DBHelper();
$result_country = $dbHelper->executeInsertQuery($query_insert);
if ($result_country) {
echo "Data Inserted";
}
$country_id = $result_country;
//INSERTING DATA INTO THE PROVINCE TABLE
$query_insert = "INSERT INTO " . PROVINCE . " VALUES('', '" . $provincename . "','" . $country_id . "')";
$dbHelper = new DBHelper();
$result_province = $dbHelper->executeInsertQuery($query_insert);
$province_id = $result_province;
//INSERTING DATA INTO THE CITY TABLE
$query_insert = "INSERT INTO " . CITY . " VALUES('', '" . $cityname . "','" . $province_id . "')";
$dbHelper = new DBHelper();
$result_city = $dbHelper->executeInsertQuery($query_insert);
$city_id = $result_city;
//returns the city id
return $city_id;
}