require "{$PWD}/../inc/config.php";
$SQL = "SELECT \r\n * \r\n FROM `ppt` WHERE \r\n 1=1\r\n AND `pdf_status`='2' \r\n AND `png_status`='0' \r\n LIMIT 1";
$ra = selectSQL($SQL);
for ($i = 0, $max_i = count($ra); $i < $max_i; $i++) {
//狀態改成轉檔中
$m = array();
$m['png_status'] = '1';
updateSQL('ppt', $m, "`id`='{$ra[$i]['id']}'");
`rm -fr {$base_dir}/tmp/png/{$ra[$i]['id']}`;
`mkdir {$base_dir}/tmp/png/{$ra[$i]['id']} -p`;
`cp {$base_dir}/OUTPUT/pdf/{$ra[$i]['id']}.pdf {$base_dir}/tmp/png/{$ra[$i]['id']}/{$ra[$i]['id']}.pdf`;
`cd {$base_dir}/tmp/png/{$ra[$i]['id']} && convert {$ra[$i]['id']}.pdf {$ra[$i]['id']}.png`;
$files = glob("{$base_dir}/tmp/png/{$ra[$i]['id']}/*.png");
natcasesort($files);
$files = array_values($files);
deleteSQL("ppt_items", "`ppt_id`='{$ra[$i]['id']}'");
for ($j = 0; $j < count($files); $j++) {
$p = $j + 1;
`cd {$base_dir}/tmp/png/{$ra[$i]['id']} && /usr/bin/pdftotext -f {$p} -l {$p} {$ra[$i]['id']}.pdf {$j}.txt`;
$bn = basename($files[$j]);
$m = array();
$m['ppt_id'] = $ra[$i]['id'];
$m['filename'] = $bn;
$m['page'] = $j + 1;
$m['contents'] = file_get_contents("{$base_dir}/tmp/png/{$ra[$i]['id']}/{$j}.txt");
$m['keyword'] = "";
$m['kind'] = "";
$m['grades'] = "0";
insertSQL("ppt_items", $m);
}
`mkdir {$base_dir}/OUTPUT/png/{$ra[$i]['id']} -p`;
echo json_format(json_encode($ra));
exit;
break;
case 'del_ppt':
//刪除簡報
$POSTS_STRING = "id";
$POSTS = getGET_POST($POSTS_STRING, 'POST');
$SQL = "SELECT * FROM `ppt` WHERE `id`=? LIMIT 1";
$ra = selectSQL_SAFE($SQL, array($POSTS['id']));
if (count($ra) != 0) {
@unlink("{$base_dir}/upload/{$ra[0]['filename']}");
@unlink("{$base_dir}/OUTPUT/pdf/{$POSTS['id']}");
`rm -fr {$base_dir}/OUTPUT/png/{$POSTS['id']}`;
}
deleteSQL("ppt_items", "`ppt_id`='{$POSTS['id']}'");
deleteSQL("ppt", "`id`='{$POSTS['id']}'");
exit;
break;
case 'download':
$GETS_STRING = "ppt_id,id";
$GETS = getGET_POST($GETS_STRING, 'GET');
$SQL = "SELECT * FROM `ppt` WHERE `id`=? LIMIT 1";
$ra = selectSQL_SAFE($SQL, array($GETS['ppt_id']));
download_file("{$base_dir}/upload/{$ra[0]['filename']}", "{$ra[0]['orin_filename']}");
$ppt_info = pdo_get_assoc_from_id('ppt', $GETS['ppt_id']);
$m = array();
$m['grades'] = $ppt_info['grades'] + 1;
updateSQL('ppt', $m, "`id`='{$GETS['ppt_id']}'");
$ppt_items_info = pdo_get_assoc_from_id('ppt_items', $GETS['id']);
$m = array();
$m['grades'] = $ppt_info['grades'] + 1;
<?php
include '../../../include/IMPORTANT.php';
// connection à la base de donnée
if (connection($dbb)) {
$parametres = array("nomcouverture", "OU?" => "ID", "VALEUR?" => "" . $_GET['IDartcl'] . "");
$reponse = selectSQL($dbb, 'articles', $parametres);
$result = $reponse->fetch(PDO::FETCH_ASSOC);
if ($reponse != FALSE) {
echo $reponse->fetch(0);
if (deleteSQL($dbb, 'articles', 'ID', '' . $_GET['IDartcl'] . '') != FALSE) {
unlink($chemin . 'images/articles/couverture/' . $result["nomcouverture"]);
$reponse->closeCursor();
header('location: ../');
// puis redirection vers la page de rédaction
} else {
echo "error ma tête";
}
}
//header('location: ../'); // puis redirection vers la page de rédaction
} else {
echo $dbb;
}
