require_once "libraries/joomla/utilities/browser_detection.php";
require_once 'libraries/form/captcha.php';
define('M_TASLAK_WHERE_STR', "YETERLILIK_SUREC_DURUM_ID = " . GORUSE_GONDERILMIS_YETERLILIK . " AND BASVURU_SEKLI_ID = " . KAYDEDILMIS_BASVURU_SEKLI_ID);
$document =& JFactory::getDocument();
$document->addScript(SITE_URL . '/templates/elegance/js/paginate.min.js');
$document->addScript(SITE_URL . '/templates/elegance/js/tablesort.min.js');
?>
<div class="sinavGirisBaslik">Yeterlilik Taslakları</div>
<?php
$gorev = isset($_POST['gorev']) ? $_POST['gorev'] : "goster";
$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") {
captcha::check("?option=com_yeterlilik_taslak_ara&gorev=goster&Itemid={$itemId}");
hepsiIleListele($itemIdStrOrj);
}
}
function formGoster($itemIdStr)
{
$db =& JFactory::getOracleDBO();
?>
<form action="?option=com_yeterlilik_taslak_ara<?php
echo $itemIdStr;
?>
" method="post">
<input type="hidden" value="hepsi" name="gorev" />
{
$sql = "SELECT PERSONEL_AD, PERSONEL_SOYAD FROM M_DENETIM_EKIP WHERE DENETIM_ID = ?";
$personeller = $db->prep_exec($sql, array($denetimId));
return $personeller;
}
$db =& JFactory::getOracleDBO();
$gorev = isset($_POST['gorev']) ? $_POST['gorev'] : "goster";
$denetimId = isset($_GET['denetimId']) ? $_GET['denetimId'] : "";
if ($gorev == "goster") {
$denetimRow = getDenetim($db, $denetimId);
//$personeller = getPersonel($db);
$kuruluslar = getKuruluslar($db, $denetimRow['DENETIM_KURULUS_ID']);
$denetimSonuc = getDenetimSonuclar($db, $denetimRow['DENETIM_SONUC_ID']);
$denetciler = getDenetciPersoneller($db, $denetimId);
//formGoster($kuruluslar, $personeller, $denetimSonuc, $denetimRow);
formGoster($kuruluslar, $denetimSonuc, $denetimRow);
} else {
if ($gorev == "kaydet") {
denetimKaydet($db, $_POST);
}
}
function formGoster($kuruluslar, $denetimSonuc, $denetimRow)
{
?>
<script type="text/javascript">
dTables.denetimEkibi = new Array(new Array("text","required", "30"), new Array("text","required", "30"));
dTables.rapor = new Array(new Array("upload"));
</script>
$document =& JFactory::getDocument();
$document->addScript(SITE_URL . '/templates/elegance/js/paginate.min.js');
$document->addScript(SITE_URL . '/templates/elegance/js/tablesort.min.js');
?>
<div class="sinavGirisBaslik"><?php
echo $baslik;
?>
</div>
<?php
$gorev = isset($_POST['gorev']) ? $_POST['gorev'] : "goster";
$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, $protokolStr, $gorusStr);
} else {
if ($gorev == "hepsi") {
captcha::check("index.php?option=com_meslek_std_taslak_ara&gorev=goster{$protokolStr}&Itemid={$itemId}");
hepsiIleListele($itemIdStrOrj, $isProtokol, $protokolStr, $isGorus, $gorusStr);
}
}
function formGoster($itemIdStr, $protokolStr, $gorusStr)
{
$db =& JFactory::getOracleDBO();
?>
<form
action="index.php?option=com_meslek_std_taslak_ara<?php
echo $protokolStr;
echo $gorusStr;
echo $itemIdStr;
<?php
defined('_JEXEC') or die('Restricted access');
require_once 'libraries/form/form_config.php';
require_once 'libraries/form/captcha.php';
$document =& JFactory::getDocument();
$document->addScript(SITE_URL . '/templates/elegance/js/paginate.min.js');
$document->addScript(SITE_URL . '/templates/elegance/js/tablesort.min.js');
$itemId = JRequest::getVar('prevItemId');
$itemIdStr = isset($itemId) ? '&Itemid=' . $itemId : '';
$gorev = isset($_POST['kimlik_no']) ? "ara" : "pdf";
if ($gorev == "ara") {
captcha::check("index.php?option=com_chronocontact&Itemid=194");
$kimlikNo = $_POST['kimlik_no'];
$sonuclar = kimlikNoIleAra($kimlikNo);
formGoster($sonuclar, $itemIdStr);
} else {
if ($gorev == "pdf") {
$sertifikaId = $_GET['sertifikaId'];
$sayfa = $_GET['sayfa'];
$sertifikaPath = getSertifikaPath($sertifikaId, $sayfa);
if ($sertifikaPath != NULL) {
pdfGoster($sertifikaPath);
}
}
}
function formGoster($sonuclar, $itemIdStr)
{
// echo '<pre>';
// print_r($sonuclar);
// echo '</pre>';
if (empty($sonuclar)) {
function listele($sonuclar, $itemIdStrOrj)
{
formGoster();
$db =& JFactory::getOracleDBO();
if (empty($sonuclar)) {
echo '<div class="sonucBulunamadi">Uygun sonuç bulunamadı.</div>';
echo '<br /><a href="index.php?option=com_mesleki_yeterlilik_belge_ara' . $itemIdStrOrj . '">Geri</a>';
} else {
?>
<div id="sorguSonuclariPopupDiv" style=" padding:10px; overflow:auto; display:none; background-color:white; width:1020px; height:500px;">
<div class="tableWrapper">
<table cellspacing="0" style="padding-bottom:10px; font-size: 11px;" class="paginate-100 sortable">
<tr class="tablo_header">
<th>#</th>
<!-- <th class="sortable-numeric">Standart Id</th> standart id ye gerek yok -->
<th class="sortable-text">T.C. Kimlik No</th>
<th class="sortable-text">Adı</th>
<th class="sortable-text">Soyadı</th>
<th class="sortable-text">Belge No</th>
<th class="sortable-text">Yeterlilik Adı</th>
<th class="sortable-text">Yeterlilik Seviyesi</th>
<th class="sortable-numeric">Sınav Tarihi</th>
<th class="sortable-numeric">Belge Düzenleme Tarihi</th>
<th class="sortable-numeric">Geçerlilik Tarihi</th>
<th class="sortable-numeric">Belgelendirme Kuruluşu</th>
</tr>
<?php
$user_browser = browser_detection('browser');
$rowCount = 1;
$rowClass = "";
foreach ($sonuclar as $satir) {
if ($rowCount % 2 == 0) {
$rowClass = "even_row";
} else {
$rowClass = "odd_row";
}
echo '<tr class="' . $rowClass . '">';
echo '<td>' . $rowCount . '</td>';
echo '<td>' . $satir['TCKIMLIKNO'] . '</td>';
echo '<td>' . $satir['AD'] . '</td>';
echo '<td>' . $satir['SOYAD'] . '</td>';
echo '<td>' . $satir['BELGENO'] . '</td>';
echo '<td>' . $satir['YETERLILIK_ADI'] . '</td>';
echo '<td>' . $satir['YETERLILIK_SEVIYESI'] . '</td>';
echo '<td>' . $satir['SINAV_TARIHI'] . '</td>';
echo '<td>' . $satir['BELGE_DUZENLEME_TARIHI'] . '</td>';
echo '<td>' . $satir['GECERLILIK_TARIHI'] . '</td>';
echo '<td>' . $satir['BELGELENDIRME_KURULUSU'] . '</td>';
echo '</tr>';
$rowCount++;
}
?>
</table>
</div>
<a href="index.php?option=com_mesleki_yeterlilik_belge_ara<?php
echo $itemIdStrOrj;
?>
">Geri</a>
</div>
<script>
jQuery.unblockUI({});
jQuery('#sorguSonuclariPopupDiv').lightbox_me({});
</script>
<?php
}
}
