function pdfGoster($protokolID)
{
$_db =& JFactory::getOracleDBO();
$sql = "SELECT DOSYA\n\t\t\t\tFROM M_PROTOKOL \n\t\t\t\tWHERE PROTOKOL_ID = ?";
$r = $_db->prep_exec_array($sql, array($protokolID));
$file = $r[0];
FormFactory::readFileFromDB($file);
}
function pdfGoster($yetkilendirmeID)
{
$_db =& JFactory::getOracleDBO();
$sql = "SELECT DOSYA\n\t\t\t\t FROM M_YETKI \n\t\t\t\t WHERE YETKI_ID = ?";
$r = $_db->prep_exec_array($sql, array($yetkilendirmeID));
$file = $r[0];
FormFactory::readFileFromDB($file);
}
function pdfGoster($yeterlilik_id, $id, $revize_no)
{
$_db =& JFactory::getOracleDBO();
switch ($id) {
// case 1:
// $select = "ILK_TASLAK_PDF";
// break;
case 1:
$select = "RESMI_GORUS_ONCESI_PDF";
break;
case 2:
$select = "SEKTOR_KOMITESI_ONCESI_PDF";
break;
case 3:
$select = "YONETIM_KURULU_ONCESI_PDF";
break;
case 4:
$select = "SON_TASLAK_PDF";
break;
}
if ($revize_no == "00" or $revize_no == "") {
$tablo = "M_TASLAK_YETERLILIK";
$sqlpart = "";
} else {
$tablo = "M_YETERLILIK_REVIZYON";
$sqlpart = "AND REVIZYON_NO=" . $revize_no;
}
$sql = "SELECT " . $select . " FROM " . $tablo . " \n\t\t\t WHERE YETERLILIK_ID = ? " . $sqlpart;
$r = $_db->prep_exec_array($sql, array($yeterlilik_id));
$file = $r[0];
FormFactory::readFileFromDB($file);
}
}
}
$itemId = JRequest::getVar('Itemid');
$itemId = isset($itemId) ? $itemId : JRequest::getVar('prevItemId');
$itemIdStr = isset($itemId) ? '&prevItemId=' . $itemId : '';
$itemIdStrOrj = isset($itemId) ? '&Itemid=' . $itemId : '';
if ($gorev == "goster") {
formGoster($itemIdStr);
} else {
if ($gorev == "hepsi") {
hepsiIleListele($itemIdStrOrj);
} else {
if ($gorev == "indir") {
$file = getFilePath(JRequest::getVar('denetimId'));
if ($file != -1) {
FormFactory::readFileFromDB($file);
}
}
}
}
function formGoster($itemIdStr)
{
$db =& JFactory::getOracleDBO();
?>
<form action="index.php?option=com_denetim_ara<?php
echo $itemIdStr;
?>
"
method="post"><input type="hidden" value="hepsi" name="gorev" />
<table>
<tr>