$say++; // Ücret Hesabı $Odenecek = 0; $Hesap = 0; if ($row['ITIRAZ_DURUM'] == null || $row['ITIRAZ_DURUM'] == -1) { foreach ($UcretBilgi[$row['BELGENO']] as $cow) { $Hesap += $cow['ucret']; } } else { $Hesap = UcretDuzenle($row['ITIRAZ_UCRET']); } $anaPara = UcretDuzenle($Hesap / $KurKdv); // $ParaKdv = $Hesap-$anaPara; if ($anaPara > UcretDuzenle($maxUcret)) { $kdvli = UcretDuzenle($maxUcret) + $maxKDV; $kdvsiz = UcretDuzenle($maxUcret); } else { $kdvli = $Hesap; $kdvsiz = $anaPara; } $classDez = ""; if ($row['DEZAV'] != null) { $classDez = "classDez"; } // Ücret Hesabı SON echo '<tr>'; echo '<td><input type="checkbox" class="AdayCheck ' . $classDez . '" name="adays[]" value="' . $row['BELGENO'] . '" id="aday_' . $row['TCKIMLIKNO'] . '" checked="checked"/></td>'; echo '<td>' . $row['ADI'] . ' ' . $row['SOYADI'] . '</td>'; echo '<td>' . $row['TCKIMLIKNO'] . '</td>'; echo '<td>' . $row['BELGENO'] . '</td>'; echo '<td>' . $row['BELGE_DUZENLEME_TARIHI'] . '</td>';
// $html .= '<td width="18%">Türkiye İnşaat Sanayicileri İşveren Sendikası Mesleki Yeterlilik ve Belgelendirme Merkezi İktisadi İşletmesi</td>'; $html .= '<td width="6%" align="center">' . $row['BK_KARAR_SAYI'] . '</td>'; $html .= '<td width="6%" align="center">' . number_format(UcretDuzenle($row['BK_UCRET']), 2, ',', '.') . '</td>'; $uc = UcretDuzenle($row['SINAV_UCRET']); $TopSinav += $uc; $html .= '<td width="6%" align="center">' . number_format($uc, 2, ',', '.') . '</td>'; $html .= '<td width="6%" align="center">' . number_format(UcretDuzenle($row['DAMGALI_UCRET']), 2, ',', '.') . '</td>'; $FonBürüt += UcretDuzenle($row['DAMGALI_UCRET']); $FonNet += UcretDuzenle($row['DAMGASIZ_UCRET']); if ($row['BELGE_MASRAF'] == 1) { $html .= '<td width="6%" align="center">0,00</td>'; $temmuzOncesi += UcretDuzenle($row['BELGE_UCRET']); $temSay++; } else { $html .= '<td width="6%" align="center">' . number_format(UcretDuzenle($row['BELGE_UCRET']), 2, ',', '.') . '</td>'; $TopBelgeMasraf += UcretDuzenle($row['BELGE_UCRET']); } $html .= '<td width="13%">' . trim(str_replace(' ', '', $row['IBAN'])) . '</td>'; // $html .= '<td width="13%" align="center">TR888888888889999999999999999999</td>'; $html .= '<td width="7%">' . str_replace(' ', '', $row['TELEFON']) . '</td>'; // $html .= '<td width="6%" align="center">+905438888888</td>'; $html .= '</tr>'; } $html .= '<tr>'; $html .= '<td align="center"><strong>' . $say . '</strong></td>'; $html .= '<td colspan="6" align="center"><strong>TOPLAM</strong></td>'; $html .= '<td align="center"><strong>' . number_format($TopSinav, 2, ',', '.') . '-TL</strong></td>'; $html .= '<td align="center"><strong>' . number_format($FonBürüt, 2, ',', '.') . '-TL</strong></td>'; // $html .= '<td align="center"><strong>'.number_format($FonNet,2,',','.').'-TL</strong></td>'; $html .= '<td align="center"><strong>' . number_format($TopBelgeMasraf, 2, ',', '.') . '-TL</strong></td>'; $html .= '<td colspan="2"></td>';
<th width="50%">Kuruluş</th> <th width="10%">Protokol</th> <th width="20%">Hibe</th> <th width="10%">Düzenle</th> </tr> </thead> <tbody class="text-center fontBold tdPad5"> <?php foreach ($ProKur as $row) { echo '<tr>'; echo '<td>' . $row['USER_ID'] . '</td>'; echo '<td>' . $row['KURULUS_ADI'] . '</td>'; echo '<td>' . $row['PRO_TARIH'] . '</td>'; if (!empty($row['UCRET'])) { echo '<td>' . Hesapla($row['UCRET']) . ' €</td>'; $topHibe += UcretDuzenle($row['UCRET']); } else { echo '<td class="text-warning">0</td>'; } echo '<td><a target="_blank" class="btn btn-xs btn-primary" href="index.php?option=com_profile&view=abuzman&layout=abdonem&kId=' . $row['USER_ID'] . '">Düzenle</a></td>'; echo '</tr>'; } ?> </tbody> </table> </div> <div class="anaDiv"> <div class="div30 hColor font18 fontBold"> Toplam Hibe: </div> <div class="div70 font18 fontBold">
$kdvli = UcretDuzenle($maxUcret); $kdvsiz = UcretDuzenle($maxUcret); } else { $kdvli = $Hesap; $kdvsiz = $anaPara; } // Ücret Hesabı SON echo '<tr>'; echo '<td>' . $say . '</td>'; echo '<td>' . $row['ADI'] . ' ' . $row['SOYADI'] . '</td>'; echo '<td>' . $row['TCKIMLIKNO'] . '</td>'; echo '<td>' . $row['BELGENO'] . '</td>'; echo '<td>' . $row['BELGE_DUZENLEME_TARIHI'] . '</td>'; echo '<td>' . $row['YETERLILIK_KODU'] . '/' . $row['REVIZYON'] . ' ' . $row['YETERLILIK_ADI'] . '</td>'; echo '<td>' . Hesapla(UcretDuzenle($kdvli)) . ' TL</td>'; echo '<td>' . Hesapla(UcretDuzenle($kdvsiz)) . ' TL</td>'; if ($row['DEZAV'] != null) { $dosyaType = strtolower(pathinfo($row['DEZAV'], PATHINFO_EXTENSION)); if ($dosyaType == 'pdf' || $dosyaType == 'doc' || $dosyaType == 'docx' || $dosyaType == 'zip' || $dosyaType == 'rar') { echo '<td><a target="_blank" href="index.php?dl=abhibe/dezavantaj/' . $row['DEZSINAV'] . '/' . $row['DEZAV'] . '" class="btn btn-sm btn-primary">İndir</a></td>'; } else { if ($dosyaType == 'jpg' || $dosyaType == 'jpeg' || $dosyaType == 'png' || $dosyaType == 'gif' || $dosyaType == 'pjpeg') { echo '<td><a target="_blank" href="index.php?img=abhibe/dezavantaj/' . $row['DEZSINAV'] . '/' . $row['DEZAV'] . '" class="btn btn-sm btn-primary">İndir</a></td>'; } } } else { echo '<td>Yok</td>'; } echo '<td><a target="_blank" class="btn btn-xs btn-primary" href="index.php?dl=abhibe/basvuru/' . $row['BASSINAV'] . '/' . $row['BASDOK'] . '">İndir</a></td>'; echo '<td class="font15 fontBold">' . $row['BASIBAN'] . '</td>'; echo '</tr>';
$BelgeMasraf = $BelgeUcretBilgi[$row['BELGENO']]['BelgeMasraf']; foreach ($UcretBilgi[$row['BELGENO']] as $cow) { $hesap += UcretDuzenle($cow['ucret']); } if ($hesap >= UcretDuzenle($row['ITIRAZ_UCRET'])) { echo '<tr class="bg-success text-white fontBold">'; } else { echo '<tr class="bg-danger text-white fontBold">'; } echo '<td>' . $say . '</td>'; echo '<td>' . $row['BELGENO'] . '</td>'; echo '<td>' . $row['TC_KIMLIK'] . '</td>'; echo '<td>' . $row['ADI'] . ' ' . $row['SOYADI'] . '</td>'; echo '<td>' . $kurulus[$row['BELGENO']]['KURULUS_ADI'] . '</td>'; echo '<td>' . UcretHesapla($hesap) . ' TL</td>'; echo '<td>' . UcretHesapla(UcretDuzenle($row['ITIRAZ_UCRET'])) . ' TL</td>'; if ($this->dId == 0) { echo '<td><a href="index.php?option=com_tesvik_abhibe&view=tesvik&layout=itiraz_belgeno&belgeno=' . urlencode($row['BELGENO']) . '" class="btn btn-xs btn-default">Düzenle</a></td>'; } echo '</tr>'; $say++; } ?> </tbody> </table> </div> <script type="text/javascript"> jQuery(document).ready(function(){ var oTables = jQuery('#kurTable').dataTable({ // "aaSorting": [[ 1, "asc" ]],
if ($Hesap > UcretDuzenle($YetUcret[$row['BELGENO']]['UCRET'])) { $Odenecek = UcretDuzenle($YetUcret[$row['BELGENO']]['UCRET']); } else { $Odenecek = $Hesap; } // Ücret Hesabı SON echo '<tr>'; echo '<td><input type="checkbox" name="adays[]" value="' . $row['BELGENO'] . '" checked="checked"/></td>'; echo '<td>' . $row['ADI'] . ' ' . $row['SOYADI'] . '</td>'; echo '<td>' . $row['TCKIMLIKNO'] . '</td>'; echo '<td>' . $row['BELGENO'] . '</td>'; echo '<td>' . $row['BELGE_DUZENLEME_TARIHI'] . '</td>'; echo '<td>' . $row['YETERLILIK_KODU'] . '/' . $row['REVIZYON'] . ' ' . $row['YETERLILIK_ADI'] . '</td>'; echo '<td>' . Hesapla($Odenecek) . ' TL</td>'; echo '<td>' . UcretDuzenle($BelgeMasraf[$row['BELGENO']]) . ' TL</td>'; echo '<td>' . Hesapla($Odenecek + UcretDuzenle($BelgeMasraf[$row['BELGENO']])) . ' TL</td>'; echo '</tr>'; } ?> </tbody> </table> </div> <div class="anaDiv"> <div class="div50"> <a href="index.php?option=com_belgelendirme_tesvik&view=belgelendirme_tesvik" class="btn btn-sm btn-danger">İptal</a> </div> <div class="div50 text-right"> <button type="button" class="btn btn-sm btn-success" id="TesvikKaydet">Kaydet</button> </div> </div>
$html .= '<td width="6%" align="center">' . number_format(UcretDuzenle($YetUcret[$row['BELGENO']]['UCRET']), 2, ',', '.') . '</td>'; $alinacak = UcretDuzenle($YetUcret[$row['BELGENO']]['UCRET']); } $FonBürüt += $alinacak; $FonNet += DamgasizHesapla($alinacak); // $html .= '<td width="6%" align="center">'.DamgasizHesapla($alinacak).'</td>'; // $TemTarihArr = explode('/', $row['BELGE_DUZENLEME_TARIHI']); // $TemTarih = $TemTarihArr[2].$TemTarihArr[1].$TemTarihArr[0]; // if($TemTarih <= '20150719'){ if ($row['BELGE_MASRAF'] == 1) { $html .= '<td width="6%" align="center">0,00</td>'; $temmuzOncesi += UcretDuzenle($BelgeMasraf[$row['BELGENO']]); $temSay++; } else { $html .= '<td width="6%" align="center">' . number_format(UcretDuzenle($BelgeMasraf[$row['BELGENO']]), 2, ',', '.') . '</td>'; $TopBelgeMasraf += UcretDuzenle($BelgeMasraf[$row['BELGENO']]); } $html .= '<td width="13%">' . trim(str_replace(' ', '', $row['IBAN'])) . '</td>'; // $html .= '<td width="13%" align="center">TR888888888889999999999999999999</td>'; $html .= '<td width="7%">' . str_replace(' ', '', $row['TELEFON']) . '</td>'; // $html .= '<td width="6%" align="center">+905438888888</td>'; $html .= '</tr>'; } $html .= '<tr>'; $html .= '<td align="center"><strong>' . $say . '</strong></td>'; $html .= '<td colspan="6" align="center"><strong>TOPLAM</strong></td>'; $html .= '<td align="center"><strong>' . number_format($TopSinav, 2, ',', '.') . '-TL</strong></td>'; $html .= '<td align="center"><strong>' . number_format($FonBürüt, 2, ',', '.') . '-TL</strong></td>'; // $html .= '<td align="center"><strong>'.number_format($FonNet,2,',','.').'-TL</strong></td>'; $html .= '<td align="center"><strong>' . number_format($TopBelgeMasraf, 2, ',', '.') . '-TL</strong></td>'; $html .= '<td colspan="2"></td>';
$adayCount = $this->TesvikIstekleri['adayCount']; $istekUcret = $this->TesvikIstekleri['istekUcret']; // Kota Bilgileri $KurPro = $this->ABKurPro; $doviz = $this->doviz; $TopKota = UcretDuzenle($this->ABKurKota); $TopKullanilan = UcretDuzenle($this->ABKurKullanilanKota); $TopKulDez = UcretDuzenle($this->ABKurKullanilanDezKota); $ABKurBekKota = UcretDuzenle($this->ABKurBekKota); $ABKurBekDezKota = UcretDuzenle($this->ABKurBekDezKota); $TopDezKota = 0; if ($KurPro['DEZAVANTAJ']) { $TopDezKota = $TopKota / 10; } $TopDezsiz = $TopKota - $TopDezKota; $dovizKuru = UcretDuzenle($doviz['alis']); function UcretDuzenle($ucret) { return str_replace(',', '.', $ucret); } function Hesapla($alinacak) { $dat = floor($alinacak * 100) / 100; return number_format($dat, '2', ',', '.'); } ?> <div class="anaDiv hColor font20 text-center text-underline fontBold"> AB Hibesi Ücret İadesi Talepleri </div> <form action="index.php?option=com_belgelendirme_abhibe&view=belgelendirme_abhibe&layout=tesvik_adaylar" enctype="multipart/form-data" method="post">
foreach ($UcretBilgi[$row['BELGENO']] as $cow) { $Hesap += $cow['ucret']; } } else { $Hesap = UcretDuzenle($row['ITIRAZ_UCRET']); } if ($Hesap >= UcretDuzenle($YetUcret[$row['BELGENO']]['UCRET'])) { $Odenecek = UcretDuzenle($YetUcret[$row['BELGENO']]['UCRET']); } else { $Odenecek = $Hesap; } // Ücret Hesabı SON $toplam += $Odenecek + UcretDuzenle($BelgeMasraf[$row['BELGENO']]); $html .= '<td width="8%">' . Hesapla($Odenecek) . ' TL</td>'; $html .= '<td width="9%">' . UcretDuzenle($BelgeMasraf[$row['BELGENO']]) . ' TL</td>'; $html .= '<td width="9%">' . Hesapla($Odenecek + UcretDuzenle($BelgeMasraf[$row['BELGENO']])) . ' TL</td>'; $html .= '</tr>'; } $html .= '<tr>'; $html .= '<td colspan="7" align="center"><strong>TOPLAM</strong></td>'; $html .= '<td align="center"><strong>' . Hesapla($toplam) . ' TL</strong></td>'; $html .= '</tr>'; $html .= '</tbody> </table> <br><br>'; } // $pdf->Cell(30, 0, 'Top-Center', 1, $ln=0, 'C', 0, '', 0, false, 'C', 'C'); // writeHTMLCell($w, $h, $x, $y, $html='', $border=0, $ln=0, $fill=0, $reseth=true, $align='', $autopadding=true) $pdf->writeHTMLCell(0, 0, '', '', $html, 0, 1, 0, true, 'L', true); $pdf->SetFont('DejaVuSans', '', 11, '', true); $html = "<p>Yukarıda ismi geçen kişilerden belirtilen MYK Mesleki Yeterlilik Belgesi sınav ücretlerin tahsil edildiğini, iş bu ücretlerin doğruluğunu ve kayıt altına alındığını taahhüt ederim.</p><br><br>";
<a style="margin-top:5px;" target="_blank" class="btn btn-xs btn-danger" href="index.php?dl=abhibe/adaypdf/' . $row['ID'] . '/' . $row['DOSYA'] . '">PDF <small>(Talep Edilen)</small></a><br>'; echo '</td>'; echo '<td><button type="button" class="btn btn-xs btn-primary" onclick="FuncGetFatura(' . $row['ID'] . ')">Fatura</button></td>'; echo '<td>'; echo '<a style="margin-top:5px;" target="_blank" class="btn btn-xs btn-primary" href="index.php?dl=abhibe/ekstre/' . $row['ID'] . '/' . $row['EKSTRE'] . '">Ekstre</a><br>'; echo '</td>'; } } } } } echo '<td><a href="index.php?option=com_belgelendirme_abhibe&view=yonetici&layout=aday_basvuru&IstekId=' . $row['ID'] . '" target="_blank" class="btn btn-xs btn-primary">İndir</a></td>'; echo '<td>' . Hesapla(UcretDuzenle($istekUcret[$row['ID']]['kdvli'])) . ' TL</td>'; echo '<td>' . Hesapla(UcretDuzenle($istekUcret[$row['ID']]['kdvsiz'])) . ' TL</td>'; if ($this->dId == 5) { echo '<td>' . Hesapla(UcretDuzenle($row['ODENEN'])) . ' €</td>'; } echo '</tr>'; $say++; } ?> </tbody> </table> </div> <!-- Teşvik Talebi (Teşvik talebinden bulununan adaylar son) --> <script type="text/javascript"> jQuery(document).ready(function(){ var oTables = jQuery('#kurTable').dataTable({ // "aaSorting": [[ 1, "asc" ]], "aLengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
<th width="10%">Düzenle</th> <?php } ?> </tr> </thead> <tbody class="text-center"> <?php $say = 1; foreach ($itirazlar as $row) { $hesap = 0; $UcretBilgi = $BelgeUcretBilgi[$row['BELGE_NO']]['UcretBilgi']; $YetUcret = $BelgeUcretBilgi[$row['BELGE_NO']]['YetUcret']; $BelgeMasraf = $BelgeUcretBilgi[$row['BELGE_NO']]['BelgeMasraf']; foreach ($UcretBilgi[$row['BELGE_NO']] as $cow) { $hesap += UcretDuzenle($cow['ucret']); } echo '<td>' . $say . '</td>'; echo '<td>' . $row['BELGE_NO'] . '</td>'; echo '<td>' . $row['TC_KIMLIK'] . '</td>'; echo '<td>' . $row['ADI'] . ' ' . $row['SOYADI'] . '</td>'; echo '<td>' . $kurulus[$row['BELGE_NO']]['KURULUS_ADI'] . '</td>'; echo '<td>' . UcretHesapla($hesap) . ' TL</td>'; $dosyaType = strtolower(pathinfo($row['DOKUMAN'], PATHINFO_EXTENSION)); if ($dosyaType == 'pdf' || $dosyaType == 'doc' || $dosyaType == 'docx' || $dosyaType == 'zip' || $dosyaType == 'rar') { echo '<td><a target="_blank" href="index.php?dl=abhibe/dezavantaj/' . $row['SINAV_ID'] . '/' . $row['DOKUMAN'] . '" class="btn btn-sm btn-info">İndir</a></td>'; } else { if ($dosyaType == 'jpg' || $dosyaType == 'jpeg' || $dosyaType == 'png' || $dosyaType == 'gif' || $dosyaType == 'pjpeg') { echo '<td><a target="_blank" href="index.php?img=abhibe/dezavantaj/' . $row['SINAV_ID'] . '/' . $row['DOKUMAN'] . '" class="btn btn-sm btn-info">İndir</a></td>'; } }
$Odenecek = 0; $Hesap = 0; if ($row['ITIRAZ_DURUM'] == null || $row['ITIRAZ_DURUM'] == -1) { foreach ($UcretBilgi[$row['BELGENO']] as $cow) { $Hesap += $cow['ucret']; } } else { $Hesap = UcretDuzenle($row['ITIRAZ_UCRET']); } $anaPara = UcretDuzenle($Hesap / $KurKdv); $kdvli = $Hesap; $kdvsiz = $anaPara; // Ücret Hesabı SON $tt += $Hesap; $ttSiz += $anaPara; $toplam += UcretDuzenle($kdvli); $html .= '<td width="8%" style="text-align:center">' . Hesapla($Hesap) . ' TL</td>'; $html .= '<td width="8%" style="text-align:center">' . Hesapla($anaPara) . ' TL</td>'; if ($row['DEZAV'] != null) { $html .= '<td width="8%" style="text-align:center">Dezavantajlı</td>'; } else { $html .= '<td width="8%" style="text-align:center"></td>'; } $html .= '<td width="8%">MYK onayı ile belirlenecektir</td>'; $html .= '<td width="8%">MYK onayı ile belirlenecektir</td>'; $html .= '</tr>'; } $html .= '<tr>'; $html .= '<td colspan="7" align="center"><strong>TOPLAM:</strong></td>'; $html .= '<td align="center"><strong>' . Hesapla($tt) . ' TL</strong></td>'; $html .= '<td align="center"><strong>' . Hesapla($ttSiz) . ' TL</strong></td>';
<th>Başvuru Dosyası</th> </tr> </thead> <tbody> <?php $say = 0; foreach ($AdayBilgi as $row) { $say++; echo '<tr>'; echo '<td>' . $say . '</td>'; echo '<td>' . $row['ADI'] . ' ' . $row['SOYADI'] . '</td>'; echo '<td>' . $row['TCKIMLIKNO'] . '</td>'; echo '<td>' . $row['BELGENO'] . '</td>'; echo '<td>' . $row['BELGE_DUZENLEME_TARIHI'] . '</td>'; echo '<td>' . $row['YETERLILIK_KODU'] . '/' . $row['REVIZYON'] . ' ' . $row['YETERLILIK_ADI'] . '</td>'; echo '<td>' . Hesapla(UcretDuzenle($row['KDVLI'])) . ' TL</td>'; echo '<td>'; $varStyle = ""; $yokStyle = ""; $odemeLink = "#"; $odeVal = 0; if ($row['ODEME_DOSYASI'] == null) { $varStyle = "display:none"; } else { $odeVal = 1; $yokStyle = "display:none"; $odemeLink = "index.php?dl=abhibe/odeme/" . $row['ISTEK_ID'] . "/" . urlencode($row['ODEME_DOSYASI']); } // Ödeme pdf'i echo '<input type="hidden" class="odemefiledurum ofd_' . $row['MATID'] . '" name="odemefile[' . $row['BELGENO'] . ']" id="' . $row['BELGENO'] . '" value="' . $odeVal . '">'; echo '<div style="' . $yokStyle . '" class="OF_' . $row['MATID'] . '">';
<?php echo Hesapla($ABKurBekKota - $ABKurBekDezKota) . ' €'; ?> </div> </div> </div> </div> <div class="anaDiv"> <div class="div50"> <div class="anaDiv"> <div class="div60 font16 fontBold hColor"> Geri Ödemesi Beklenen Dezavantajlı Ücret <span class="font16">(TL)</span>: </div> <div class="div40 fontBold font16"> <?php echo Hesapla($ABKurBekDezKota * UcretDuzenle($dovizKuru)) . 'TL'; ?> </div> </div> </div> <div class="div50"> <div class="anaDiv"> <div class="div60 font16 fontBold hColor"> Geri Ödemesi Beklenen Dezavantajlı Ücret <span class="font16">(EURO)</span>: </div> <div class="div40 fontBold font16"> <?php echo Hesapla($ABKurBekDezKota) . ' €'; ?> </div> </div>