public function publishArticle($articleID)
{
//merge translated page content and create pdf
$sql = 'select * from pages where articleID= :articleID and language= :language';
$conn = dataObject::connect();
try {
$st = $conn->prepare($sql);
$st->bindValue(":articleID", $articleID, PDO::PARAM_INT);
$st->bindValue(":language", 'hindi', PDO::PARAM_STR);
$st->execute();
$rows = $st->fetchAll();
} catch (PDOException $e) {
dataObject::disconnect($conn);
die("failed to retrieve pages:" . $e->getMessage());
}
$str = '';
foreach ($rows as $row) {
$pageObj = new Page($row['file_path']);
$str .= $pageObj->loadContentTranslated();
}
//add to file
$handle = fopen("../translations/{$articleID}_translated.txt", 'w');
fwrite($handle, $str);
fclose($handle);
//Make entry into database
$sql = "insert into translations(articleID,language,file_size,file_name,file_path) values( :articleID, :language, :filesize, :filename, :filepath);";
try {
$st = $conn->prepare($sql);
$st->bindValue(":articleID", $articleID, PDO::PARAM_INT);
$st->bindValue(":language", 'hindi', PDO::PARAM_STR);
$st->bindValue(":filesize", filesize("../translations/{$articleID}_translated.txt"), PDO::PARAM_INT);
$st->bindValue(":filename", "{$articleID}_translated.txt", PDO::PARAM_STR);
$st->bindValue(":filepath", realpath("../translations/{$articleID}_translated.txt"), PDO::PARAM_STR);
$st->execute();
} catch (PDOException $e) {
dataObject::disconnect($conn);
die("failed to add translation:" . $e->getMessage());
}
$sql = "update articles set no_of_translations = no_of_translations+1 where articleID= :articleID";
try {
$st = $conn->prepare($sql);
$st->bindValue(":articleID", $articleID, PDO::PARAM_INT);
$st->execute();
} catch (PDOException $e) {
dataObject::disconnect($conn);
die("failed to update no-of-translations:" . $e->getMessage());
}
}
echo $formaction;
?>
' method='post'>
<div class='row'>
<div class='col-xs-6'>
<textarea name='englishContent' id='englishContent' rows='20' cols='40' readonly>
<?php
echo $EPageObj->loadContent();
?>
</textarea>
</div>
<div class='col-xs-6'>
<script language="javascript">
var val="<?php
echo $HPageObj->loadContentTranslated();
?>
";
CreateCustomHindiTextArea("hindiContent",val,80,20,true);
</script>
</div>
</div>
<div class='row'>
<input type='hidden' name='pagenewpath' value='<?php
echo $EPageObj->returnpath();
?>
'></input>
<input type='hidden' name='pagepath' value='<?php
echo $row['file_path'];
?>
'></input>
