function userVerileriEkle($dbOrc, $juser)
{
$user_id = $dbOrc->getNextVal(USER_SEQ);
$fileName = FormFactory::getNormalFilename($_POST[$ekAd . ($updated + $j + 1)]);
//Prepare sql statement
$sql = "INSERT INTO " . DB_PREFIX . ".tg_user \n\t\t\t\t(user_id, user_name, email_address, display_name) \n\t\t\t\tvalues( ?, ?, ?, ?)";
$params = array($user_id, $juser->username, $juser->email, $juser->name);
if ($dbOrc->prep_exec_insert($sql, $params)) {
return $user_id;
} else {
return -1;
}
}
$path3 = FormFactory::normalizeVariable($rev_bilgi["SEKTOR_KOMITESI_ONCESI_PDF"]);
$path4 = FormFactory::normalizeVariable($rev_bilgi["YONETIM_KURULU_ONCESI_PDF"]);
$path5 = FormFactory::normalizeVariable($rev_bilgi["SON_TASLAK_PDF"]);
//3
}
//echo "paths[0] = '".$path1."';";
echo "paths[0] = '" . $path2 . "';";
echo "paths[1] = '" . $path3 . "';";
echo "paths[2] = '" . $path4 . "';";
echo "paths[3] = '" . $path5 . "';";
//4
//echo "fileNames [0] = '".FormFactory::getNormalFilename(basename ($path1))."';";
echo "fileNames [0] = '" . FormFactory::getNormalFilename(basename($path2)) . "';";
echo "fileNames [1] = '" . FormFactory::getNormalFilename(basename($path3)) . "';";
echo "fileNames [2] = '" . FormFactory::getNormalFilename(basename($path4)) . "';";
echo "fileNames [3] = '" . FormFactory::getNormalFilename(basename($path5)) . "';";
//5
?>
var id = tableName + "_0";
for (var i = 0; i < 4; i++){//6
if (paths[i] != null && paths[i] != ''){
var sira = i+1;
var resultDiv = document.getElementById(id + "_result_div_" + sira);
var inputPath = '<input type="hidden" value="'+paths[i]+'" name="path_'+tableName+'_0_'+sira +'">' +
'<input type="hidden" value="" name="filename_'+tableName+'_0_'+sira +'">';
var result = inputPath + '<br><div id="success_'+tableName+'_0_'+sira+'" class="up_success">'+fileNames[i]+' yüklendi!</div><div> <input type="button" value="İndir / Oku" onclick="window.location.href=\'index.php?option=com_yeterlilik_taslak_yeni&view=taslak_revizyon&task=indir&id='+sira+'&yeterlilik_id=<?php
echo $this->yeterlilik_id;
?>
&revize_no=<?php
//FILE UPLOAD
dTables.protokolDosya = new Array(new Array("upload"));
function createTables(){
tableName = "protokolDosya";
createTable(tableName, new Array(''));
satirEkleKaldir (tableName);
satirSilKaldir (tableName, 0);
addProtokolDosya (tableName);
}
function addProtokolDosya (tableName){
<?php
$path = $dosya;
echo "var path = '" . FormFactory::normalizeVariable($path) . "';";
echo "var fileName = '" . FormFactory::getNormalFilename(basename($path)) . "';";
?>
if (path != null && path != ''){
var id = tableName + "_0";
var sira = 1;
var resultDiv = document.getElementById(id + "_result_div_" + sira);
var inputPath = '<input type="hidden" value="'+path+'" name="path_'+id+'_'+sira +'">' +
'<input type="hidden" value="" name="filename_'+id+'_'+sira +'">';
var result = inputPath + '<div class="up_success">'+fileName+' yüklendi!';
result += '<input type="button" value="İndir" onclick="window.location.href=\'index.php?option=com_yetkilendirme_yet&task=indir&protokolID=<?php
echo $protokolID;
?>
\'" class="up_submitbtn" style="float:none;"> <\/div>';
result += '<div><input type="button" value="Değiştir" onclick="removeUploaded(\''+id+'\',\''+sira+'\')" /><\/div>';
//3
$path6 = FormFactory::normalizeVariable($yet_bilgi["YAYINLANMIS_YETERLILIK_PDF"]);
//3
//echo "paths[0] = '".$path1."';";
echo "paths[0] = '" . $path2 . "';";
echo "paths[1] = '" . $path3 . "';";
echo "paths[2] = '" . $path4 . "';";
echo "paths[3] = '" . $path5 . "';";
//4
echo "paths[4] = '" . $path6 . "';";
//4
$filename2 = FormFactory::getNormalFilename(basename($path2));
$filename3 = FormFactory::getNormalFilename(basename($path3));
$filename4 = FormFactory::getNormalFilename(basename($path4));
$filename5 = FormFactory::getNormalFilename(basename($path5));
$filename6 = FormFactory::getNormalFilename(basename($path6));
//echo "fileNames [0] = '".FormFactory::getNormalFilename(basename ($path1))."';";
echo "fileNames [0] = '" . (strlen($filename2) > 10 ? substr($filename2, 0, 10) . "...." . substr($filename2, -3) : $filename2) . "';";
echo "fileNames [1] = '" . (strlen($filename3) > 10 ? substr($filename3, 0, 10) . "...." . substr($filename3, -3) : $filename3) . "';";
echo "fileNames [2] = '" . (strlen($filename4) > 10 ? substr($filename4, 0, 10) . "...." . substr($filename4, -3) : $filename4) . "';";
echo "fileNames [3] = '" . (strlen($filename5) > 10 ? substr($filename5, 0, 10) . "...." . substr($filename5, -3) : $filename5) . "';";
//5
echo "fileNames [4] = '" . (strlen($filename6) > 10 ? substr($filename6, 0, 10) . "...." . substr($filename6, -3) : $filename6) . "';";
//5
?>
var id = tableName + "_0";
for (var i = 0; i < 5; i++){//6
if (paths[i] != null && paths[i] != ''){
var sira = i+1;
var resultDiv = document.getElementById(id + "_result_div_" + sira);
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>
<form method="POST" action="index.php?option=com_denetim_duzenle"
id="denetim_form" onSubmit="return validate('denetim_form')">
<input type="hidden" name="gorev" value="kaydet"></input>
<input type="hidden" name="denetimId" value="<?php
echo $denetimRow['DENETIM_ID'];
?>
"></input>
<table>
<tr>
<td>Denetim Yapılan Kuruluş</td>
<td><select name="kurulus">
<option value="Seçiniz">Seçiniz</option>
<?php
echo $kuruluslar;
?>
</select></td>
</tr>
<tr>
<td>Denetim Tarihi</td>
<td><input type="text" id="inputdenetim_tarihi" name="denetim_tarihi"
size="10" value="<?php
echo $denetimRow['DENETIM_TARIHI_F'];
?>
" class="required date"> <input type="button" value="..."
id="denetim_tarihi_button"></input>(GG.AA.YYYY)</td>
</tr>
<tr>
<td>Denetim Süresi</td>
<td><input type="text" name="denetimSuresi" value="<?php
echo $denetimRow['DENETIM_SURESI'];
?>
" size="10"></td>
</tr>
<tr>
<td>DENETİM EKİBİ</td>
<td>
<div id="denetimEkibi_div"></div>
</td>
</tr>
<tr>
<td>DENETİM MASRAF KARŞILIĞI /HESAP NUMARASI</td>
<td><input type="text" value="<?php
echo $denetimRow['DENETIM_HESAP_NO'];
?>
" name="hesapNo"></input></td>
</tr>
<tr>
<td>MASRAF YATIRILDI MI?</td>
<td><select name="yatirildimi">
<option value="Seçiniz">Seçiniz</option>
<option value="0" <?php
echo $denetimRow['DENETIM_UCRETI_YATTI_MI'] == '0' ? 'selected="selected"' : '';
?>
>Hayır</option>
<option value="1" <?php
echo $denetimRow['DENETIM_UCRETI_YATTI_MI'] == '1' ? 'selected="selected"' : '';
?>
>Evet</option>
</select></td>
</tr>
<tr>
<td>DENETİM RAPORU</td>
<td>
<div id="rapor_div"></div>
</td>
</tr>
<tr>
<td>DENETİM SONUCU</td>
<td><select name="sonuc">
<option value="Seçiniz">Seçiniz</option>
<?php
echo $denetimSonuc;
?>
</select></td>
</tr>
<tr>
<td>DENETİM SONUCU AÇIKLAMA</td>
<td><input type="text" name="sonucAciklama" value="<?php
echo $denetimRow['DENETIM_SONUC_ACIKLAMA'];
?>
"></input></td>
</tr>
</table>
<br />
<input type="submit" value="Kaydet"></input></form>
<script type="text/javascript">
function createTables(){
createTable('denetimEkibi',new Array ('Personel Adı', 'Soyadı'));
personelleriEkle();
tableName = "rapor";
createTable(tableName, new Array(''));
satirEkleKaldir (tableName);
satirSilKaldir (tableName, 0);
addRapor (tableName);
}
function addRapor (tableName){
<?php
$path = $denetimRow["DENETIM_RAPOR_PATH"];
echo "var path = '" . FormFactory::normalizeVariable($path) . "';";
echo "var fileName = '" . FormFactory::getNormalFilename(basename($path)) . "';";
?>
if (path != null && path != ''){
var id = tableName + "_0";
var resultDiv = document.getElementById(id + "_result_div_1");
var inputPath = '<input type="hidden" value="'+path+'" name="path_'+id+'_1">' +
'<input type="hidden" value="" name="filename_'+id+'_1">';
var result = inputPath + '<div class="up_success">'+fileName+' yüklendi!<\/div>';
result += '<div><input type="button" value="Değiştir" onclick="removeUploaded(\''+id+'\',\'1\')" /></div>';
resultDiv.innerHTML = result;
var uploadSpan = document.getElementById(id + "_upload_form_span_1");
uploadSpan.style.visibility = 'hidden';
uploadSpan.style.height = 0;
}
}
</script>
<?php
}
var paths = new Array();
var fileNames = new Array();
<?php
$path2 = FormFactory::normalizeVariable($standartBilgi["RESMI_GORUS_ONCESI_PDF"]);
$path3 = FormFactory::normalizeVariable($standartBilgi["SEKTOR_KOMITESI_ONCESI_PDF"]);
$path4 = FormFactory::normalizeVariable($standartBilgi["YONETIM_KURULU_ONCESI_PDF"]);
$path5 = FormFactory::normalizeVariable($standartBilgi["SON_TASLAK_PDF"]);
//echo "paths[0] = '".$path1."';";
echo "paths[0] = '" . $path2 . "';";
echo "paths[1] = '" . $path3 . "';";
echo "paths[2] = '" . $path4 . "';";
echo "paths[3] = '" . $path5 . "';";
$filename2 = FormFactory::getNormalFilename(basename($path2));
$filename3 = FormFactory::getNormalFilename(basename($path3));
$filename4 = FormFactory::getNormalFilename(basename($path4));
$filename5 = FormFactory::getNormalFilename(basename($path5));
//echo "fileNames [0] = '".FormFactory::getNormalFilename(basename ($path1))."';";
echo "fileNames [0] = '" . (strlen($filename2) > 10 ? substr($filename2, 0, 10) . "...." . substr($filename2, -3) : $filename2) . "';";
echo "fileNames [1] = '" . (strlen($filename3) > 10 ? substr($filename3, 0, 10) . "...." . substr($filename3, -3) : $filename3) . "';";
echo "fileNames [2] = '" . (strlen($filename4) > 10 ? substr($filename4, 0, 10) . "...." . substr($filename4, -3) : $filename4) . "';";
echo "fileNames [3] = '" . (strlen($filename5) > 10 ? substr($filename5, 0, 10) . "...." . substr($filename5, -3) : $filename5) . "';";
//5
?>
var id = tableName + "_0";
for (var i = 0; i < 5; i++) {//6
if (paths[i] != null && paths[i] != '') {
var sira = i + 1;
var resultDiv = document.getElementById(id + "_result_div_" + sira);
var inputPath = '<input type="hidden" value="' + paths[i] + '" name="path_' + tableName + '_0_' + sira + '">' +
'<input type="hidden" value="" name="filename_' + tableName + '_0_' + sira + '">';
}
function addAkreditasyonValues (params, name){
var arr = new Array ();
var pathName = new Array ();
var fileName = new Array ();
var ekId = new Array ();
<?php
$data = $this->akreditasyon;
$tableCount = count($data);
$c = 0;
for ($i = 0; $i < $tableCount; $i++) {
$arr = $data[$i];
echo 'ekId[' . $i . ']= "' . $arr["AKREDITASYON_ID"] . '";';
echo 'pathName[' . $i . ']= "' . FormFactory::normalizeVariable($arr["AKREDITASYON_PATH"]) . '";';
echo 'fileName[' . $i . ']= "' . FormFactory::getNormalFilename(basename($arr["AKREDITASYON_PATH"])) . '";';
echo 'arr[' . $c++ . ']= "' . FormFactory::normalizeVariable($arr["AKREDITASYON_ADI"]) . '";';
echo 'arr[' . $c++ . ']= "' . FormFactory::normalizeVariable($arr["AKREDITASYON_ACIKLAMA"]) . '";';
// echo 'arr['.$c++.']= "'. FormFactory::normalizeVariable ($arr["AKREDITASYON_SEVIYE"]) .'";';
// echo 'arr['.$c++.']= "'. FormFactory::normalizeVariable ($arr["AKREDITASYON_STANDARDI"]) .'";';
// echo 'arr['.$c++.']= "'. FormFactory::normalizeVariable ($arr["AKREDITASYON_BASLANGIC"]) .'";';
// echo 'arr['.$c++.']= "'. FormFactory::normalizeVariable ($arr["AKREDITASYON_BITIS"]) .'";';
// echo 'arr['.$c++.']= "'. FormFactory::normalizeVariable ($arr["AKREDITASYON_DENETIM"]) .'";';
// echo 'arr['.$c++.']= "'. FormFactory::normalizeVariable ($arr["AKREDITASYON_KAPSAM"]) .'";';
}
?>
if (isset (arr)){
addTableValues (arr, new Array (), params, name);
for (var i = 0; i < pathName.length; i++){
var path = pathName[i];
public function basvuruEkleriKaydet($evrak_pk, $tableName, $posted, $tip = null, $aciklamaKolon = 1)
{
$aciklamalar = $posted["input" . $tableName . "-" . $aciklamaKolon];
$ekId = "ek_id_";
$ekAd = "filename_" . $tableName . "_0_";
$ekPath = "path_" . $tableName . "_0_";
$updated = 0;
for ($i = 1; isset($posted[$ekId . $i]); $i++) {
$inpFileName = $ekAd . $i;
$ek_id = $posted[$ekId . $i];
if ($ek_id != -1) {
if (isset($posted[$inpFileName])) {
// GUNCELLE
$aciklama = $aciklamalar[$updated];
$file = $posted[$inpFileName];
$path = $posted[$ekPath . $i];
$normalFile = FormFactory::getNormalFilename($file);
if (!FormFactory::basvuruEkiGuncelle($ek_id, $aciklama, $path, $normalFile)) {
return JText::_("VERI_GUNCELLE_HATA");
}
$updated++;
} else {
// SIL
if (!FormFactory::basvuruEkiSil($ek_id)) {
return JText::_("VERI_SIL_HATA");
}
}
} else {
//Belgelendirme Basvuru Formu (ek2) / Aradaki ekleri ekle
if (isset($posted[$inpFileName])) {
$aciklama = $aciklamalar[$updated + $j];
if (isset($posted[$ekPath . ($updated + $j + 1)])) {
$filePath = $posted[$ekPath . ($updated + $j + 1)];
$fileName = FormFactory::getNormalFilename($posted[$ekAd . ($updated + $j + 1)]);
if (is_array($tip)) {
$ek_tip = $tip[$updated + $j];
} else {
$ek_tip = $tip;
}
if (!FormFactory::basvuruEkiEkle($evrak_pk, $aciklama, $fileName, $filePath, $ek_tip)) {
return JText::_("VERI_EKLE_HATA");
}
}
}
$updated++;
}
}
// GERISINI EKLE
for ($j = 0; isset($posted["input" . $tableName . "-1"][$updated + $j]); $j++) {
$aciklama = $aciklamalar[$updated + $j];
if (isset($posted[$ekPath . ($updated + $j + 1)])) {
$filePath = $posted[$ekPath . ($updated + $j + 1)];
$fileName = FormFactory::getNormalFilename($posted[$ekAd . ($updated + $j + 1)]);
if (is_array($tip)) {
$ek_tip = $tip[$updated + $j];
} else {
$ek_tip = $tip;
}
if (!FormFactory::basvuruEkiEkle($evrak_pk, $aciklama, $fileName, $filePath, $ek_tip)) {
return JText::_("VERI_EKLE_HATA");
}
}
}
return JText::_("VERI_KAYDI_BASARILI");
}
