public function republish($page_path)
{
//remove page from database
$pageObj = new Page($page_path);
$sql = "delete from pages where articleID= :articleID and language = :language and page_no = :page_no;";
$conn = dataObject::connect();
try {
$st = $conn->prepare($sql);
$st->bindValue(":articleID", $pageObj->getArticleID(), PDO::PARAM_INT);
$st->bindValue(":language", 'hindi', PDO::PARAM_STR);
$st->bindValue(":page_no", $pageObj->getPageNo(), PDO::PARAM_INT);
$st->execute();
} catch (PDOException $e) {
dataObject::disconnect($conn);
die("failed to remove page:" . $e->getMessage());
}
//remove page from directory
chmod("../translatedPages/{$pageObj->getFileName()}_translated.txt", 0777);
unlink("../translatedPages/{$pageObj->getFileName()}_translated.txt");
//add page to queue
$queueHandle = fopen("../pages/pageQueue.csv", 'a');
$record = array($pageObj->getArticleID(), $pageObj->getPageNo(), $page_path);
fputcsv($queueHandle, $record);
fclose($queueHandle);
}
public function submitTranslation($translated_content, $page_path)
{
$ourPage = new Page($page_path);
//remove first entry from queue csv
$queueHandle = fopen("../pages/pageQueue.csv", 'r');
$currpage = fgetcsv($queueHandle);
$newQueue = fopen("../pages/pageQueue2.csv", 'w');
while ($record = fgetcsv($queueHandle)) {
fputcsv($newQueue, $record);
}
fclose($queueHandle);
fclose($newQueue);
chmod("../pages/pageQueue.csv", 0777);
unlink("../pages/pageQueue.csv");
rename("../pages/pageQueue2.csv", "../pages/pageQueue.csv");
//save new page in directory
$pagehandle = fopen("../translatedPages/{$ourPage->getFileName()}_translated.txt", 'w');
fwrite($pagehandle, $translated_content);
fclose($pagehandle);
//make entry into database
$conn = dataObject::connect();
$sql = "insert into pages(articleID,page_no,language,file_name,file_size,file_path) values( :articleID, :page_no," . '"hindi",' . ":file_name, :file_size, :file_path);";
try {
$st = $conn->prepare($sql);
$st->bindValue(":articleID", $ourPage->getarticleID(), PDO::PARAM_INT);
$st->bindValue(":page_no", $ourPage->getpageNo(), PDO::PARAM_INT);
$st->bindValue(":file_name", "{$ourPage->getFileName()}_translated.txt", PDO::PARAM_STR);
$st->bindValue(":file_size", filesize("../translatedPages/{$ourPage->getFileName()}_translated.txt"), PDO::PARAM_STR);
$st->bindValue(":file_path", realpath("../translatedPages/{$ourPage->getFileName()}_translated.txt"), PDO::PARAM_STR);
$st->execute();
} catch (PDOException $e) {
dataObject::disconnect($conn);
die("failed to add page:" . $e->getMessage());
}
dataObject::disconnect($conn);
}
