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); }