Symfony Profiler

<?php
namespace App\Controller;
use App\Entity\MobilBildirimler;
use App\Controller\BaseController;
use App\Entity\Basvurular;
use App\Entity\Bolgeler;
use App\Entity\Cihazlar;
use App\Entity\Il;
use App\Entity\Ilce;
use App\Entity\Sorumlular;
use App\Entity\Subeler;
use App\Entity\User;
use chillerlan\QRCode\QRCode;
use phpDocumentor\Reflection\Types\This;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Mailer\MailerInterface;
use Symfony\Component\Mime\Address;
use Symfony\Component\Mime\Email;
use Symfony\Component\Routing\Annotation\Route;
use FPDF;
use setasign\Fpdi\Fpdi;
class SiteDefaultController extends BaseController
{
/**
* @Route("/check/{qrHidden}", name="site_qrCheck")
*/
public function qrCheck($qrHidden):Response
{
$em = $this->getDoctrine()->getManager();
$qb = $em->createQueryBuilder();
$cihaz=$qb->select('c,sor.eposta as sorEposta,sor.adi,sor.soyadi,sor.tc,sor.dogumtarihi,sor.telefon,b.adi,b.kod,s.kullaniciAdSoyad,s.tcknVkn,s.vd,s.subeAdi,s.subeKodu,s.mahalleKoy,s.cadde,s.sokak,s.disKapiNo,s.icKapiNo,il.name as ilAdi,ilce.name as ilceAdi,s.gsmTelefon,s.eposta,s.telFaks')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->join('s.il','il')
->join('s.ilce','ilce')
->leftjoin('s.bolge','b')
->join('s.sorumlu','sor')
->where("c.qrHidden='$qrHidden'")
->getQuery()
->getScalarResult();
return $this->render('site/check.html.twig',array('cihaz'=>$cihaz));
}
/**
* @Route("/", name="site_homepage")
*/
public function index():Response
{
return $this->render('site/index.html.twig');
}
/**
* @Route("/basvuru-yap", name="site_basvuruYap")
*/
public function basvuruYap():Response
{
$em = $this->getDoctrine()->getManager();
if ($this->ayarlar('disBasvuru')!=1){
return $this->redirectToRoute('site_homepage');
}
$qb = $em->createQueryBuilder();
$iller = $qb->select('i.id,i.name')
->from('App:Il', 'i')
->getQuery()
->getScalarResult();
return $this->render('site/basvuruYap.html.twig',array('iller'=>$iller));
}
/**
* @Route("/yeniCihazAlan", name="yeniCihazAlan")
*/
public function yeniCihazAlan(Request $request): Response
{
$satir = $request->request->get('satir');
return $this->render('site/yeniCihazAlan.html.twig',array('satir'=>$satir));
}
/**
* @Route("/sorumluBul", name="sorumluBul")
*/
public function sorumluBul(Request $request): Response
{
$em = $this->getDoctrine()->getManager();
$tc = $request->request->get('tc');
$sorumlu = $em->getRepository(Sorumlular::class)->findOneBy(array('tc'=>$tc));
if (!empty($sorumlu)) {
return new Response($sorumlu->getDogumtarihi()->format('d.m.Y').'~'.$sorumlu->getAdi().'~'.$sorumlu->getSoyadi().'~'.$sorumlu->getTelefon().'~'.$sorumlu->getEposta());
}else{
return new Response('');
}
}
/**
* @Route("/basvuruKaydet1", name="basvuruKaydet1")
*/
public function basvuruKaydet1(Request $request, MailerInterface $mailer):Response
{
$em = $this->getDoctrine()->getManager();
$eposta = $request->request->get('email');
$telefon = $request->request->get('telefon');
$dogrulamaAraci = $request->request->get('dogrulamaAraci');
if ($dogrulamaAraci==1) {
$email = (new Email())
->from(new Address($this->ayarlar('sistemPosta'), $this->ayarlar('siteAdi')))
->to($eposta)
->priority(Email::PRIORITY_HIGH)
->subject($this->ayarlar('siteAdi').' Başvuru Doğrulama')
->html($this->renderView('mail/belgeDogrulama2.html.twig', array('dogrulamaKodu' => $this->get('session')->get('dogrulamaKodu'))));
$mailer->send($email);
}else{
$mesaj = 'Başvuru belgenizin doğrulama kodu: '.$this->get('session')->get('dogrulamaKodu').' - '.$this->ayarlar('siteAdi');
$this->smsGonder($telefon,$mesaj);
}
return new Response('');
}
/**
* @Route("/basvuruKaydet2", name="basvuruKaydet2")
*/
public function basvuruKaydet2(Request $request, MailerInterface $mailer):Response
{
$em = $this->getDoctrine()->getManager();
$dogrulamaKodu = $request->request->get('dogrulamaKodu');
$dogrulamaAraci = $request->request->get('dogrulamaAraci');
$basvuruTipi= $request->request->get('basvuruTipi');
if ($dogrulamaKodu!=$this->get('session')->get('dogrulamaKodu')){
return new Response('Doğrulama kodunu yanlış girdiniz. Tekrar deneyin.');
}
$kullaniciAdSoyad = $request->request->get('kullaniciAdSoyad');
$tcknVkn = $request->request->get('tcknVkn');
$vd = $request->request->get('vd');
$il = $request->request->get('il'); $il = $em->getReference(Il::class,$il);
$ilce = $request->request->get('ilce'); $ilce = $em->getReference(Ilce::class,$ilce);
$subeKodu = $request->request->get('subeKodu');
$subeAdi = $request->request->get('subeAdi');
if ($subeKodu==''){
$subeKodu = substr($subeAdi,0,1).'-'.rand(0,10000);
}
$mahalleKoy = $request->request->get('mahalleKoy');
$cadde = $request->request->get('cadde');
$sokak = $request->request->get('sokak');
$gsmTelefon = $request->request->get('gsmTelefon');
$icKapiNo = $request->request->get('icKapiNo');
$eposta = $request->request->get('eposta');
$disKapiNo = $request->request->get('disKapiNo');
$telFaks = $request->request->get('telFaks');
$aciklama = $request->request->get('aciklama');
$email = $request->request->get('email');
$ad = $request->request->get('ad');
$soyad = $request->request->get('soyad');
$telefon = $request->request->get('telefon');
$tc = $request->request->get('tc');
$dogumtarihi = explode('.',$request->request->get('dogumtarihi'));
$dogumtarihi = new \DateTime($dogumtarihi[2].'-'.$dogumtarihi[1].'-'.$dogumtarihi[0]);
$c_cihazId = $request->request->get('c_cihazId');
$c_tipi = $request->request->get('c_tipi');
$c_marka = $request->request->get('c_marka');
$c_model = $request->request->get('c_model');
$c_sinif = $request->request->get('c_sinif');
$c_kapasite = $request->request->get('c_kapasite');
$c_seriNo = $request->request->get('c_seriNo');
$c_uretimYili = $request->request->get('c_uretimYili');
$c_damgaYili = $request->request->get('c_damgaYili');
$c_dTaksir = $request->request->get('c_dTaksir');
$c_eMuayene = $request->request->get('c_eMuayene');
/* if ($silinenCihazlar!=''){
$silinenCihazlar = explode('~',$silinenCihazlar);
foreach ($silinenCihazlar as $silinen){
if (!empty($silinen)){
if (!in_array($silinen,$c_seriNo)){
$cihaz = $em->getRepository(Cihazlar::class)->findOneBy(array('seriNo'=>$silinen));
$em->remove($cihaz);
}
}
}
}*/
$sql1 = "";
/* if ($subeId!=''){
$sql1 = " and s.id not in($subeId)";
}*/
$qb = $em->createQueryBuilder();
$sube = $qb->select('s.id')
->from('App:Subeler', 's')
->where("s.subeKodu='$subeKodu'".$sql1)
->getQuery()
->getScalarResult();
if (@count($sube)>0){
return new Response('Tartı aleti kullanıcısı bu şube kodu ile daha önceden kaydedilmiş. Yeniden eklenemez!');
}
foreach ($c_tipi as $key=>$cTipi){
$sql2 = "";
/* if ($subeId!=''){
$sql2 = " and c.seriNo not in('$c_seriNo[$key]')";
}*/
$qb = $em->createQueryBuilder();
$cihaz = $qb->select('c.id')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->where("c.seriNo='$c_seriNo[$key]'".$sql1.$sql2)
->getQuery()
->getScalarResult();
if (@count($cihaz)>0){
return new Response($c_seriNo[$key].' seri numaralı tartı aleti başka tartı aleti kullanıcısı tarafından kullanılmaktadır. Yeniden eklenemez!');
}
}
$sorumlu = $em->getRepository(Sorumlular::class)->findOneBy(array('tc'=>$tc));
if (empty($sorumlu)){
$sorumlu = new Sorumlular();
$sorumlu->setTc($tc);
$sorumlu->setDogumtarihi($dogumtarihi);
$sorumlu->setAdi($ad);
$sorumlu->setSoyadi($soyad);
$sorumlu->setTelefon($telefon);
$sorumlu->setEposta($eposta);
$em->persist($sorumlu);
} else {
$sorumlu->setTc($tc);
$sorumlu->setDogumtarihi($dogumtarihi);
$sorumlu->setAdi($ad);
$sorumlu->setSoyadi($soyad);
$sorumlu->setTelefon($telefon);
$sorumlu->setEposta($eposta);
$em->persist($sorumlu);
}
// if ($subeId==''){
$sube = new Subeler();
/* }else{
$sube = $em->getRepository(Subeler::class)->find($subeId);
}*/
$sube->setSorumlu($sorumlu);
$sube->setKullaniciAdSoyad($kullaniciAdSoyad);
$sube->setTcknVkn($tcknVkn);
$sube->setVd($vd);
$sube->setIl($il);
$sube->setIlce($ilce);
$sube->setSubeKodu($subeKodu);
$sube->setSubeAdi($subeAdi);
$sube->setMahalleKoy($mahalleKoy);
$sube->setCadde($cadde);
$sube->setSokak($sokak);
$sube->setGsmTelefon($gsmTelefon);
$sube->setIcKapiNo($icKapiNo);
$sube->setEposta($eposta);
$sube->setDisKapiNo($disKapiNo);
$sube->setTelFaks($telFaks);
$sube->setAciklama($aciklama);
$sube->setKayitTarihi(new \DateTime('now'));
$em->persist($sube);
$cihazlar=[];
foreach ($c_tipi as $key=>$cTipi) {
$cihaz1 = $em->getRepository(Cihazlar::class)->findOneBy(array('seriNo'=>$c_seriNo[$key]));
$cihaz2 = $em->getRepository(Cihazlar::class)->find($c_cihazId[$key]);
if (empty($cihaz1)) {
if (empty($cihaz2)) {
$cihaz = new Cihazlar();
}else{
$cihaz = $cihaz2;
}
}else{
$cihaz = $cihaz1;
}
$cihaz->setSube($sube);
$cihaz->setTipi($cTipi);
$cihaz->setMarka($c_marka[$key]);
$cihaz->setModel($c_model[$key]);
$cihaz->setSinif($c_sinif[$key]);
$cihaz->setSeriNo($c_seriNo[$key]);
$cihaz->setKapasite($c_kapasite[$key]);
$cihaz->setDTaksir($c_dTaksir[$key]);
$cihaz->setEMuayene($c_eMuayene[$key]);
$cihaz->setUretimYili($c_uretimYili[$key]);
$cihaz->setDamgaYili($c_damgaYili[$key]);
$em->persist($cihaz);
$em->flush();
$cihazlar[] = $cihaz->getId();
}
$suan = new \DateTime('now');
$ilkTarih = $suan->format('Y').'-01-01 00:00:00';
$sonTarih = $suan->format('Y').'-12-31 23:59:59';
$veriler = [];
foreach ($cihazlar as $cihaz){
$cihazRef = $em->getReference(Cihazlar::class,$cihaz);
$qb = $em->createQueryBuilder();
$cihazBul=$qb->select('s.id,c.damgaYili')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->where("c.id=$cihaz")
->getQuery()
->getScalarResult();
if (($cihazBul[0]['damgaYili']+2)==$suan->format('Y')){
} else {
if ($basvuruTipi!='Tamir Sonrası'){
return new Response("Belirlenen tartı aletlerinden Muaayeneli olanlar bulunmaktadır. Muayeneli tartı aletlerini sadece 'Tamir Sonrası' olarak başvuru yapabilirsiniz.");
}
}
if ($basvuruTipi!='Tamir Sonrası') {
$qb = $em->createQueryBuilder();
$basvuruBulcan = $qb->select('b.id')
->from('App:Basvurular', 'b')
->join('b.cihaz', 'c')
->where("c.id=" . $cihaz . " and (b.basvuruTarihi >= '$ilkTarih' or b.basvuruTarihi <= '$sonTarih') and (b.kontrolNo is null or b.muayeneNo is not null)")
->getQuery()
->getScalarResult();
if (count(@$basvuruBulcan) > 0) {
return new Response("Belirlenen tartı aletlerinden başvurusu yapılmış olan bulunmaktadır. Başvuru tekrar yapılamaz.");
}
}
$sube = $em->getReference(Subeler::class,$cihazBul[0]['id']);
if (!@in_array($cihaz,$veriler[$cihazBul[0]['id']])){
$veriler[$cihazBul[0]['id']][] = $cihaz;
}
$basvuru = $em->getRepository(Basvurular::class)->findOneBy(array('sube'=>$cihazBul[0]['id'],'cihaz'=>$cihaz,'muayeneNo'=>null,'kontrolNo'=>null));
if (empty($basvuru)){
$basvuru = new Basvurular();
}
$basvuru->setTipi($basvuruTipi);
$basvuru->setSube($sube);
$basvuru->setCihaz($cihazRef);
$basvuru->setBasvuruNo('');
$basvuru->setBasvuruBelgesi('');
$basvuru->setBasvuruTarihi(new \DateTime('now'));
$em->persist($basvuru);
}
$em->flush();
$tarih = new \DateTime('now');
foreach ($veriler as $key=>$veri){
$qb = $em->createQueryBuilder();
$basBul=$qb->select('b.basvuruNo')
->from('App:Basvurular', 'b')
->join('b.sube','s')
->where("b.basvuruNo!='' and s.id=".$key)
->addOrderBy('b.id','desc')
->setMaxResults(1)
->getQuery()
->getScalarResult();
$x = @$basBul[0]['basvuruNo'];
$x = explode('-',$x);
$x = @intval(@$x[3])+1;
$basvuruNo = $tarih->format('Y').'-'.$key.'-1-'.$x;
$qb = $em->createQueryBuilder();
$sube=$qb->select('s,sor.tc,sor.dogumtarihi,sor.adi,sor.soyadi,sor.telefon,sor.eposta as sorMail,il.name as ilAdi,ilce.name as ilceAdi')
->from('App:Subeler', 's')
->join('s.il','il')
->join('s.ilce','ilce')
->leftjoin('s.bolge','b')
->join('s.sorumlu','sor')
->where("s.id=$key")
->getQuery()
->getScalarResult();
$pdf = new FPDF();
$pdf->AddPage();
$pdf->AddFont('arial_tr','','arial_tr.php');
$pdf->AddFont('arial_tr','B','arial_tr_bold.php');
$pdf->Image($this->ayarlar('siteYolu').'/pdf_logo.png',10,10,0,15,'PNG');
$pdf->Image($this->ayarlar('siteYolu').'/no.png',150,12,7,0,'PNG');
$pdf->SetFont('arial_tr','',16);
$pdf->setY(8);
$pdf->SetX(160);
$pdf->SetTextColor(235,29,70);
$pdf->Cell(85,14,$this->fpdf_turkce($basvuruNo),0,0,'left',false);
$pdf->SetFont('arial_tr','B',18);
$pdf->setY(28);
$pdf->SetX(10);
$pdf->SetFillColor(237,237,237);
$pdf->Cell(100,14,"",0,0,'left',true);
$pdf->SetTextColor(0,0,0);
$pdf->setY(28);
$pdf->SetX(33);
$pdf->Cell(85,14,$this->fpdf_turkce('Tartı Aleti Başvuru Formu'),0,0,'left',true);
$pdf->Image($this->ayarlar('siteYolu').'/STB.png',11,25,20,0,'PNG');
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(100,100,100);
$pdf->setY(30);
$pdf->SetX(127);
$pdf->Cell(100,4,$this->fpdf_turkce('Muayene Başvuru Tarihi'),0,0,'left',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(30);
$pdf->SetX(166);
$pdf->Cell(100,4,$this->fpdf_turkce(': '.$tarih->format('d/m/Y')),0,0,'left',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(36);
$pdf->SetX(127);
$pdf->Cell(100,4,$this->fpdf_turkce('Muayene Başvuru Tipi'),0,0,'left',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(36);
$pdf->SetX(166);
$pdf->Cell(100,4,$this->fpdf_turkce(': '.$basvuruTipi),0,0,'left',false);
$pdf->SetFont('arial_tr','',8);
$pdf->SetTextColor(100,100,100);
$pdf->setY(44);
$pdf->SetX(10);
$pdf->MultiCell(190,4,$this->fpdf_turkce('Aşağıdaki nitelikleri yazılı firmamızda kullanılmakta olan tartı aletlerinin ................... yılı periyodik muayenelerinin yapılması, mühürleme işlemlerinin gerçekleşmesi ve muayene raporlarının düzenlenerek tarafımıza iletilmesi hususunda gereğini rica ederiz.'),0,'left',false);
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(43);
$pdf->SetX(100);
$pdf->Cell(15,4,$this->fpdf_turkce($tarih->format('Y')),0,0,'C',false);
$pdf->setY(53);
$pdf->SetX(5);
$pdf->Cell(200,55,'',1,0,'L',false);
$pdf->SetFont('arial_tr','B',14);
$pdf->SetTextColor(0,0,0);
$pdf->setY(55);
$pdf->SetX(10);
$pdf->Cell(190,4,$this->fpdf_turkce('1 - Tartı Aleti Kullanıcı Bilgileri'),0,0,'L',false);
$pdf->SetFont('arial_tr','',12);
$pdf->SetTextColor(100,100,100);
$pdf->setY(62);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Tartı Aleti Kullanıcısı'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(62);
$pdf->SetX(50);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_kullaniciAdSoyad']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(67);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('TC / Vergi Numarası'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(67);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_tcknVkn']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(72);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('İl'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(72);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['ilAdi']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(77);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Şube Adı'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(77);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_subeAdi']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(82);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Mahalle / Köy Adı'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(82);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_mahalleKoy']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(87);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Cadde'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(87);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_cadde']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(92);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Gsm Telefon No'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(92);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_gsmTelefon']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(97);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('E-Posta Adresi'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(97);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_eposta']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(102);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Tel - Faks'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(102);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_telFaks']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(67);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('V.D.'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(67);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_vd']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(72);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('İlçe'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(72);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['ilceAdi']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(77);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('Şube Kodu'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(77);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_subeKodu']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(87);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('Sokak'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(87);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_sokak']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(92);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('İç Kapı No'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(92);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_icKapiNo']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(97);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('Dış Kapı No'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(97);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_disKapiNo']),0,0,'L',false);
$pdf->SetFont('arial_tr','B',14);
$pdf->SetTextColor(0,0,0);
$pdf->SetFillColor(237,237,237);
$pdf->setY(110);
$pdf->SetX(5);
$pdf->Cell(200,8,$this->fpdf_turkce('SORUMLU'),0,0,'C',true);
$pdf->SetFont('arial_tr','',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(5);
$pdf->Cell(25,6,$this->fpdf_turkce('T.C.'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(30);
$pdf->Cell(55,6,$this->fpdf_turkce('ADI SOYADI'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(85);
$pdf->Cell(25,6,$this->fpdf_turkce('D.TARİHİ'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(110);
$pdf->Cell(30,6,$this->fpdf_turkce('GSM NO'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(140);
$pdf->Cell(65,6,$this->fpdf_turkce('E-POSTA ADRESİ'),1,0,'C',false);
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(5);
$pdf->Cell(25,6,$this->fpdf_turkce($sube[0]['tc']),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(30);
$pdf->Cell(55,6,$this->fpdf_turkce($sube[0]['adi'].' '.$sube[0]['soyadi']),1,0,'C',false);
$dTarihi = new \DateTime($sube[0]['dogumtarihi']);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(85);
$pdf->Cell(25,6,$this->fpdf_turkce($dTarihi->format('d/m/Y')),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(110);
$pdf->Cell(30,6,$this->fpdf_turkce($sube[0]['telefon']),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(140);
$pdf->Cell(65,6,$this->fpdf_turkce($sube[0]['sorMail']),1,0,'C',false);
$pdf->SetFont('arial_tr','B',14);
$pdf->SetTextColor(0,0,0);
$pdf->SetFillColor(237,237,237);
$pdf->setY(132);
$pdf->SetX(5);
$pdf->Cell(200,8,$this->fpdf_turkce('2 - Tartı Aleti Bilgileri'),0,0,'L',true);
$pdf->SetFont('arial_tr','',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(5);
$pdf->Cell(30,6,$this->fpdf_turkce('Tartı Aleti Tipi'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(35);
$pdf->Cell(20,6,$this->fpdf_turkce('Marka'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(55);
$pdf->Cell(20,6,$this->fpdf_turkce('Model'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(75);
$pdf->Cell(15,6,$this->fpdf_turkce('Sınıf'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(90);
$pdf->Cell(20,6,$this->fpdf_turkce('Kapasite'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(110);
$pdf->Cell(35,6,$this->fpdf_turkce('Seri No'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(145);
$pdf->Cell(15,6,$this->fpdf_turkce('Ü.Yılı'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(160);
$pdf->Cell(20,6,$this->fpdf_turkce('d:Taksir'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(180);
$pdf->Cell(25,6,$this->fpdf_turkce('e:Muayene'),1,0,'C',false);
$veriSay = count($veri);
$pdf->SetFont('arial_tr','',7);
$x = 6;
foreach ($veri as $vv){
$qb = $em->createQueryBuilder();
$cc=$qb->select('c')
->from('App:Cihazlar', 'c')
->where("c.id=$vv")
->getQuery()
->getScalarResult();
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(5);
$pdf->Cell(30, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(5);
$pdf->MultiCell(30, 3, $this->fpdf_turkce($cc[0]['c_tipi']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(35);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(35);
$pdf->MultiCell(20, 3, $this->fpdf_turkce($cc[0]['c_marka']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(55);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(55);
$pdf->MultiCell(20, 3, $this->fpdf_turkce($cc[0]['c_model']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(75);
$pdf->Cell(15, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(75);
$pdf->MultiCell(15, 3, $this->fpdf_turkce($cc[0]['c_sinif']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(90);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(90);
$pdf->MultiCell(20, 3, $this->fpdf_turkce($cc[0]['c_kapasite']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(110);
$pdf->Cell(35, 6, $this->fpdf_turkce($cc[0]['c_seriNo']), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(145);
$pdf->Cell(15, 6, $this->fpdf_turkce($cc[0]['c_uretimYili']), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(160);
$pdf->Cell(20, 6, $this->fpdf_turkce($cc[0]['c_dTaksir']), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(180);
$pdf->Cell(25, 6, $this->fpdf_turkce($cc[0]['c_eMuayene']), 1, 0, 'C', false);
$x = $x + 6;
}
for ($i=0;$i<(12-$veriSay);$i++) {
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(5);
$pdf->Cell(30, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(35);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(55);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(75);
$pdf->Cell(15, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(90);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(110);
$pdf->Cell(35, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(145);
$pdf->Cell(15, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(160);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(180);
$pdf->Cell(25, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$x = $x + 6;
}
$pdf->SetFont('arial_tr','B',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(230);
$pdf->SetX(5);
$pdf->Cell(100,6,$this->fpdf_turkce('MÜŞTERİ ONAY'),0,0,'C',false);
$pdf->setY(235);
$pdf->SetX(5);
$pdf->Cell(100,40,'',1,0,'L',false);
$pdf->SetFont('arial_tr','B',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(240);
$pdf->SetX(10);
if ($dogrulamaAraci==1) {
$pdf->Cell(90, 6, $this->fpdf_turkce($eposta), 0, 0, 'C', false); // Sorumlu E-Posta
}else{
$pdf->Cell(90, 6, $this->fpdf_turkce($telefon), 0, 0, 'C', false); // Sorumlu E-Posta
}
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(255);
$pdf->SetX(10);
if ($dogrulamaAraci==1) {
$pdf->MultiCell(90, 6, $this->fpdf_turkce('Üstte yazılı sorumlu e-posta adresi tarafından doğrulama kodu ile doğrulanmıştır.'), 0, 'C', false); // Üstte yazılı sorumlu e-posta adresi tarafından doğrulama kodu ile doğrulanmıştır.
}else{
$pdf->MultiCell(90, 6, $this->fpdf_turkce('Üstte yazılı sorumlu telefon numarası tarafından doğrulama kodu ile doğrulanmıştır.'), 0, 'C', false); // Üstte yazılı sorumlu e-posta adresi tarafından doğrulama kodu ile doğrulanmıştır.
}
$pdf->SetFont('arial_tr','B',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(245);
$pdf->SetX(10);
$pdf->Cell(90,6,$this->fpdf_turkce('D.K. : '.$dogrulamaKodu),0,0,'C',false); // D.K. : 245 658 E-Posta doğrulama kodu
$pdf->SetFont('arial_tr','B',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(235);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce($this->firmaAyarlari('firmaAdi')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(235);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce('YMS:'.$this->firmaAyarlari('ymsKodu')),0,0,'R',false);
$pdf->SetFont('arial_tr','',11);
$pdf->SetTextColor(0,0,0);
$pdf->setY(240);
$pdf->SetX(110);
$pdf->Cell(95,6,$this->fpdf_turkce($this->firmaAyarlari('yetkiliAdSoyad')),0,0,'C',false);
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(245);
$pdf->SetX(110);
$pdf->Cell(95,6,$this->fpdf_turkce($this->firmaAyarlari('adres')),0,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(250);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce($this->firmaAyarlari('ilce').' / '.$this->firmaAyarlari('il')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(250);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce('Cep.: '.$this->firmaAyarlari('gsm')),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(255);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce('Tel.: '.$this->firmaAyarlari('tel')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(255);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce('Fax.: '.$this->firmaAyarlari('fax')),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(260);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce($this->firmaAyarlari('site')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(260);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce($this->firmaAyarlari('eposta')),0,0,'R',false);
$belge = 'basvuru_belgesi_'.$basvuruNo.'.pdf';
$pdf->Output('F', 'gecici_yukleme/'.$belge,true);
$this->deleteFile($belge);
$this->uploadFile($belge);
foreach ($veri as $vv){
$qb = $em->createQueryBuilder();
$q = $qb->update('App:Basvurular', 'b')
->set('b.basvuruNo', ':basvuruNo')
->set('b.basvuruBelgesi', ':basvuruBelgesi')
->set('b.basvuruDK', ':basvuruDK')
->set('b.basvuruBelgeDurum', ':basvuruBelgeDurum')
->where("b.sube = ".$key." and b.cihaz=".$vv." and b.kontrolNo is null and b.muayeneNo is null and b.tahsilatNo is null and (b.basvuruTarihi >= '$ilkTarih' or b.basvuruTarihi <= '$sonTarih')")
->setParameter('basvuruNo', $basvuruNo)
->setParameter('basvuruBelgesi', $belge)
->setParameter('basvuruDK', $dogrulamaKodu)
->setParameter('basvuruBelgeDurum', 1)
->getQuery()
->execute();
}
}
$mb = new MobilBildirimler();
$mb->setBaslik("Yeni bir başvuru yaoıldı!");
$mb->setMetin($sube[0]['s_kullaniciAdSoyad']." isimli tartı aleti kullanıcısı başvuruda bulundu.");
$mb->setKullanicilar( null);
$mb->setTarih(null);
$mb->setDurum(0);
$em->persist($mb);
$em->flush();
return new Response('');
}
/**
* @Route("/veriBul", name="veriBul")
*/
public function veriBul(Request $request): Response
{
$em = $this->getDoctrine()->getManager();
$hash = $request->request->get('hash');
$qb = $em->createQueryBuilder();
$subeBul=$qb->select('s.subeKodu')
->from('App:Subeler', 's')
->getQuery()
->getScalarResult();
$subeKodu = "";
foreach ($subeBul as $ss){
if (sha1($ss['subeKodu'])==$hash){
$subeKodu = $ss['subeKodu'];
}
}
if ($subeKodu==''){
return new Response('0');
}
$this->get('session')->set('subeKodu',$subeKodu);
$qb = $em->createQueryBuilder();
$iller = $qb->select('i.id,i.name')
->from('App:Il', 'i')
->getQuery()
->getScalarResult();
$qb = $em->createQueryBuilder();
$veri=$qb->select('s,il.id as ilId,ilce.id as ilceId,sor,b,k.id as kId')
->from('App:Subeler', 's')
->join('s.il','il')
->join('s.ilce','ilce')
->leftjoin('s.bolge','b')
->join('s.sorumlu','sor')
->leftjoin('b.kullanici','k')
->where("s.subeKodu='$subeKodu'")
->getQuery()
->getScalarResult();
$qb = $em->createQueryBuilder();
$cihazlar=$qb->select('c')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->where("s.subeKodu='$subeKodu'")
->getQuery()
->getScalarResult();
if (@count($veri)==0){
// return $this->redirectToRoute('ta-kullanici_homepage');
}
return $this->render('site/veriBul.html.twig',array('iller'=>$iller,'veri'=>$veri[0],'cihazlar'=>$cihazlar));
}
/**
* @Route("/veriBul2", name="veriBul2")
*/
public function veriBul2(Request $request): Response
{
$em = $this->getDoctrine()->getManager();
$kullaniciAdSoyad = $request->request->get('kullaniciAdSoyad');
$tcknVkn = $request->request->get('tcknVkn');
$vd = $request->request->get('vd');
$il = $request->request->get('il');
$ilce = $request->request->get('ilce');
$subeAdi = $request->request->get('subeAdi');
$subeBul = $em->getRepository(Subeler::class)->findOneBy(array('kullaniciAdSoyad'=>$kullaniciAdSoyad,'tcknVkn'=>$tcknVkn,'vd'=>$vd,'il'=>$il,'ilce'=>$ilce,'subeAdi'=>$subeAdi));
if (empty($subeBul)){
$subeKodu = "";
}else{
$subeKodu = $subeBul->getSubeKodu();
}
if ($subeKodu==''){
return new Response('0');
}
$this->get('session')->set('subeKodu',$subeKodu);
$qb = $em->createQueryBuilder();
$iller = $qb->select('i.id,i.name')
->from('App:Il', 'i')
->getQuery()
->getScalarResult();
$qb = $em->createQueryBuilder();
$veri=$qb->select('s,il.id as ilId,ilce.id as ilceId,sor,b,k.id as kId')
->from('App:Subeler', 's')
->join('s.il','il')
->join('s.ilce','ilce')
->leftjoin('s.bolge','b')
->join('s.sorumlu','sor')
->leftjoin('b.kullanici','k')
->where("s.subeKodu='$subeKodu'")
->getQuery()
->getScalarResult();
$qb = $em->createQueryBuilder();
$cihazlar=$qb->select('c')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->where("s.subeKodu='$subeKodu'")
->getQuery()
->getScalarResult();
if (@count($veri)==0){
// return $this->redirectToRoute('ta-kullanici_homepage');
}
return $this->render('site/veriBul.html.twig',array('iller'=>$iller,'veri'=>$veri[0],'cihazlar'=>$cihazlar));
}
/**
* @Route("/basvuruKaydet11", name="basvuruKaydet11")
*/
public function basvuruKaydet11(Request $request, MailerInterface $mailer):Response
{
$em = $this->getDoctrine()->getManager();
$id = $request->request->get('id');
$dogrulamaAraci = $request->request->get('dogrulamaAraci');
$sube = $em->getRepository(Subeler::class)->findOneBy(array('id'=>$id,'subeKodu'=>$this->get('session')->get('subeKodu')));
if (empty($sube)){
return new Response('Şube kodu ve şube bilgisi eşleşmiyor. Lütfen doğru bilgiler giriniz.');
}else {
if ($dogrulamaAraci == 1) {
$email = (new Email())
->from(new Address($this->ayarlar('sistemPosta'), $this->ayarlar('siteAdi')))
->to($sube->getSorumlu()->getEposta())
->priority(Email::PRIORITY_HIGH)
->subject($this->ayarlar('siteAdi').' Başvuru Doğrulama')
->html($this->renderView('mail/belgeDogrulama2.html.twig', array('dogrulamaKodu' => $this->get('session')->get('dogrulamaKodu'))));
$mailer->send($email);
} else {
$mesaj = 'Başvuru belgenizin doğrulama kodu: ' . $this->get('session')->get('dogrulamaKodu') . ' - '.$this->ayarlar('siteAdi');
$this->smsGonder($sube->getSorumlu()->getTelefon(), $mesaj);
}
}
return new Response('');
}
/**
* @Route("/basvuruKaydet22", name="basvuruKaydet22")
*/
public function basvuruKaydet22(Request $request, MailerInterface $mailer):Response
{
$em = $this->getDoctrine()->getManager();
$dogrulamaKodu = $request->request->get('dogrulamaKodu');
$dogrulamaAraci = $request->request->get('dogrulamaAraci');
$basvuruTipi= $request->request->get('basvuruTipi');
if ($dogrulamaKodu!=$this->get('session')->get('dogrulamaKodu')){
return new Response('Doğrulama kodunu yanlış girdiniz. Tekrar deneyin.');
}
$seciliCihazlar = $request->request->get('seciliCihazlar');
$seciliCihazlar = explode(',',$seciliCihazlar);
$silinenCihazlar = $request->request->get('silinenCihazlar');
$subeId = $request->request->get('subeId');
$kullaniciAdSoyad = $request->request->get('kullaniciAdSoyad');
$tcknVkn = $request->request->get('tcknVkn');
$vd = $request->request->get('vd');
$il = $request->request->get('il'); $il = $em->getReference(Il::class,$il);
$ilce = $request->request->get('ilce'); $ilce = $em->getReference(Ilce::class,$ilce);
$subeKodu = $request->request->get('subeKodu');
$subeAdi = $request->request->get('subeAdi');
$mahalleKoy = $request->request->get('mahalleKoy');
$cadde = $request->request->get('cadde');
$sokak = $request->request->get('sokak');
$gsmTelefon = $request->request->get('gsmTelefon');
$icKapiNo = $request->request->get('icKapiNo');
$eposta = $request->request->get('eposta');
$disKapiNo = $request->request->get('disKapiNo');
$telFaks = $request->request->get('telFaks');
$aciklama = $request->request->get('aciklama');
$email = $request->request->get('email');
$ad = $request->request->get('ad');
$soyad = $request->request->get('soyad');
$telefon = $request->request->get('telefon');
$tc = $request->request->get('tc');
$dogumtarihi = explode('.',$request->request->get('dogumtarihi'));
$dogumtarihi = new \DateTime($dogumtarihi[2].'-'.$dogumtarihi[1].'-'.$dogumtarihi[0]);
$c_cihazId = $request->request->get('c_cihazId');
$c_tipi = $request->request->get('c_tipi');
$c_marka = $request->request->get('c_marka');
$c_model = $request->request->get('c_model');
$c_sinif = $request->request->get('c_sinif');
$c_kapasite = $request->request->get('c_kapasite');
$c_seriNo = $request->request->get('c_seriNo');
$c_uretimYili = $request->request->get('c_uretimYili');
$c_damgaYili = $request->request->get('c_damgaYili');
$c_dTaksir = $request->request->get('c_dTaksir');
$c_eMuayene = $request->request->get('c_eMuayene');
if ($silinenCihazlar!=''){
$silinenCihazlar = explode('~',$silinenCihazlar);
foreach ($silinenCihazlar as $silinen){
if (!empty($silinen)){
if (!in_array($silinen,$c_seriNo)){
$cihaz = $em->getRepository(Cihazlar::class)->findOneBy(array('seriNo'=>$silinen));
$em->remove($cihaz);
}
}
}
}
$sql1 = " and s.id not in($subeId)";
$qb = $em->createQueryBuilder();
$sube = $qb->select('s.id')
->from('App:Subeler', 's')
->where("s.subeKodu='$subeKodu'".$sql1)
->getQuery()
->getScalarResult();
if (@count($sube)>0){
return new Response('Tartı aleti kullanıcısı bu şube kodu ile daha önceden kaydedilmiş. Yeniden eklenemez!');
}
foreach ($c_tipi as $key=>$cTipi){
if ($subeId!=''){
$sql2 = " and c.seriNo not in('$c_seriNo[$key]')";
}
$qb = $em->createQueryBuilder();
$cihaz = $qb->select('c.id')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->where("c.seriNo='$c_seriNo[$key]'".$sql1.$sql2)
->getQuery()
->getScalarResult();
if (@count($cihaz)>0){
return new Response($c_seriNo[$key].' seri numaralı tartı aleti başka tartı aleti kullanıcısı tarafından kullanılmaktadır. Yeniden eklenemez!');
}
}
$sorumlu = $em->getRepository(Sorumlular::class)->findOneBy(array('tc'=>$tc));
if (empty($sorumlu)){
$sorumlu = new Sorumlular();
$sorumlu->setTc($tc);
$sorumlu->setDogumtarihi($dogumtarihi);
$sorumlu->setAdi($ad);
$sorumlu->setSoyadi($soyad);
$sorumlu->setTelefon($telefon);
$sorumlu->setEposta($eposta);
$em->persist($sorumlu);
} else {
$sorumlu->setTc($tc);
$sorumlu->setDogumtarihi($dogumtarihi);
$sorumlu->setAdi($ad);
$sorumlu->setSoyadi($soyad);
$sorumlu->setTelefon($telefon);
$sorumlu->setEposta($eposta);
$em->persist($sorumlu);
}
$sube = $em->getRepository(Subeler::class)->find($subeId);
$sube->setSorumlu($sorumlu);
$sube->setKullaniciAdSoyad($kullaniciAdSoyad);
$sube->setTcknVkn($tcknVkn);
$sube->setVd($vd);
$sube->setIl($il);
$sube->setIlce($ilce);
$sube->setSubeKodu($subeKodu);
$sube->setSubeAdi($subeAdi);
$sube->setMahalleKoy($mahalleKoy);
$sube->setCadde($cadde);
$sube->setSokak($sokak);
$sube->setGsmTelefon($gsmTelefon);
$sube->setIcKapiNo($icKapiNo);
$sube->setEposta($eposta);
$sube->setDisKapiNo($disKapiNo);
$sube->setTelFaks($telFaks);
$sube->setAciklama($aciklama);
$sube->setKayitTarihi(new \DateTime('now'));
$em->persist($sube);
$cihazlar=[];
$x = 0;
foreach ($c_tipi as $key=>$cTipi) {
$cihaz1 = $em->getRepository(Cihazlar::class)->findOneBy(array('seriNo'=>$c_seriNo[$key]));
$cihaz2 = $em->getRepository(Cihazlar::class)->find($c_cihazId[$key]);
if (empty($cihaz1)) {
if (empty($cihaz2)) {
$cihaz = new Cihazlar();
$x = 1;
}else{
$cihaz = $cihaz2;
$x = 0;
}
}else{
$cihaz = $cihaz1;
$x = 0;
}
$cihaz->setSube($sube);
$cihaz->setTipi($cTipi);
$cihaz->setMarka($c_marka[$key]);
$cihaz->setModel($c_model[$key]);
$cihaz->setSinif($c_sinif[$key]);
$cihaz->setSeriNo($c_seriNo[$key]);
$cihaz->setKapasite($c_kapasite[$key]);
$cihaz->setDTaksir($c_dTaksir[$key]);
$cihaz->setEMuayene($c_eMuayene[$key]);
$cihaz->setUretimYili($c_uretimYili[$key]);
$cihaz->setDamgaYili($c_damgaYili[$key]);
$em->persist($cihaz);
$em->flush();
if ($x==0) {
if (in_array($cihaz->getId(), $seciliCihazlar)) {
$cihazlar[] = $cihaz->getId();
}
} else {
$cihazlar[] = $cihaz->getId();
}
}
$suan = new \DateTime('now');
$ilkTarih = $suan->format('Y').'-01-01 00:00:00';
$sonTarih = $suan->format('Y').'-12-31 23:59:59';
$veriler = [];
foreach ($cihazlar as $cihaz){
$cihazRef = $em->getReference(Cihazlar::class,$cihaz);
$qb = $em->createQueryBuilder();
$cihazBul=$qb->select('s.id,c.damgaYili')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->where("c.id=$cihaz")
->getQuery()
->getScalarResult();
if (($cihazBul[0]['damgaYili']+2)==$suan->format('Y')){
} else {
if ($basvuruTipi!='Tamir Sonrası'){
return new Response("Belirlenen tartı aletlerinden Muaayeneli olanlar bulunmaktadır. Muayeneli tartı aletlerini sadece 'Tamir Sonrası' olarak başvuru yapabilirsiniz.");
}
}
if ($basvuruTipi!='Tamir Sonrası') {
$qb = $em->createQueryBuilder();
$basvuruBulcan = $qb->select('b.id')
->from('App:Basvurular', 'b')
->join('b.cihaz', 'c')
->where("c.id=" . $cihaz . " and (b.basvuruTarihi >= '$ilkTarih' or b.basvuruTarihi <= '$sonTarih') and (b.kontrolNo is null or b.muayeneNo is not null)")
->getQuery()
->getScalarResult();
if (count(@$basvuruBulcan) > 0) {
return new Response("Belirlenen tartı aletlerinden başvurusu yapılmış olan bulunmaktadır. Başvuru tekrar yapılamaz.");
}
}
$sube = $em->getReference(Subeler::class,$cihazBul[0]['id']);
if (!@in_array($cihaz,$veriler[$cihazBul[0]['id']])){
$veriler[$cihazBul[0]['id']][] = $cihaz;
}
$basvuru = $em->getRepository(Basvurular::class)->findOneBy(array('sube'=>$cihazBul[0]['id'],'cihaz'=>$cihaz,'muayeneNo'=>null,'kontrolNo'=>null));
if (empty($basvuru)){
$basvuru = new Basvurular();
}
$basvuru->setTipi($basvuruTipi);
$basvuru->setSube($sube);
$basvuru->setCihaz($cihazRef);
$basvuru->setBasvuruNo('');
$basvuru->setBasvuruBelgesi('');
$basvuru->setBasvuruTarihi(new \DateTime('now'));
$em->persist($basvuru);
}
$em->flush();
$tarih = new \DateTime('now');
foreach ($veriler as $key=>$veri){
$qb = $em->createQueryBuilder();
$basBul=$qb->select('b.basvuruNo')
->from('App:Basvurular', 'b')
->join('b.sube','s')
->where("b.basvuruNo!='' and s.id=".$key)
->addOrderBy('b.id','desc')
->setMaxResults(1)
->getQuery()
->getScalarResult();
$x = @$basBul[0]['basvuruNo'];
$x = explode('-',$x);
$x = @intval(@$x[3])+1;
$basvuruNo = $tarih->format('Y').'-'.$key.'-1-'.$x;
$qb = $em->createQueryBuilder();
$sube=$qb->select('s,sor.tc,sor.dogumtarihi,sor.adi,sor.soyadi,sor.telefon,sor.eposta as sorMail,il.name as ilAdi,ilce.name as ilceAdi')
->from('App:Subeler', 's')
->join('s.il','il')
->join('s.ilce','ilce')
->leftjoin('s.bolge','b')
->join('s.sorumlu','sor')
->where("s.id=$key")
->getQuery()
->getScalarResult();
$pdf = new FPDF();
$pdf->AddPage();
$pdf->AddFont('arial_tr','','arial_tr.php');
$pdf->AddFont('arial_tr','B','arial_tr_bold.php');
$pdf->Image($this->ayarlar('siteYolu').'/pdf_logo.png',10,10,0,15,'PNG');
$pdf->Image($this->ayarlar('siteYolu').'/no.png',150,12,7,0,'PNG');
$pdf->SetFont('arial_tr','',16);
$pdf->setY(8);
$pdf->SetX(160);
$pdf->SetTextColor(235,29,70);
$pdf->Cell(85,14,$this->fpdf_turkce($basvuruNo),0,0,'left',false);
$pdf->SetFont('arial_tr','B',18);
$pdf->setY(28);
$pdf->SetX(10);
$pdf->SetFillColor(237,237,237);
$pdf->Cell(100,14,"",0,0,'left',true);
$pdf->SetTextColor(0,0,0);
$pdf->setY(28);
$pdf->SetX(33);
$pdf->Cell(85,14,$this->fpdf_turkce('Tartı Aleti Başvuru Formu'),0,0,'left',true);
$pdf->Image($this->ayarlar('siteYolu').'/STB.png',11,25,20,0,'PNG');
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(100,100,100);
$pdf->setY(30);
$pdf->SetX(127);
$pdf->Cell(100,4,$this->fpdf_turkce('Muayene Başvuru Tarihi'),0,0,'left',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(30);
$pdf->SetX(166);
$pdf->Cell(100,4,$this->fpdf_turkce(': '.$tarih->format('d/m/Y')),0,0,'left',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(36);
$pdf->SetX(127);
$pdf->Cell(100,4,$this->fpdf_turkce('Muayene Başvuru Tipi'),0,0,'left',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(36);
$pdf->SetX(166);
$pdf->Cell(100,4,$this->fpdf_turkce(': '.$basvuruTipi),0,0,'left',false);
$pdf->SetFont('arial_tr','',8);
$pdf->SetTextColor(100,100,100);
$pdf->setY(44);
$pdf->SetX(10);
$pdf->MultiCell(190,4,$this->fpdf_turkce('Aşağıdaki nitelikleri yazılı firmamızda kullanılmakta olan tartı aletlerinin ................... yılı periyodik muayenelerinin yapılması, mühürleme işlemlerinin gerçekleşmesi ve muayene raporlarının düzenlenerek tarafımıza iletilmesi hususunda gereğini rica ederiz.'),0,'left',false);
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(43);
$pdf->SetX(100);
$pdf->Cell(15,4,$this->fpdf_turkce($tarih->format('Y')),0,0,'C',false);
$pdf->setY(53);
$pdf->SetX(5);
$pdf->Cell(200,55,'',1,0,'L',false);
$pdf->SetFont('arial_tr','B',14);
$pdf->SetTextColor(0,0,0);
$pdf->setY(55);
$pdf->SetX(10);
$pdf->Cell(190,4,$this->fpdf_turkce('1 - Tartı Aleti Kullanıcı Bilgileri'),0,0,'L',false);
$pdf->SetFont('arial_tr','',12);
$pdf->SetTextColor(100,100,100);
$pdf->setY(62);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Tartı Aleti Kullanıcısı'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(62);
$pdf->SetX(50);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_kullaniciAdSoyad']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(67);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('TC / Vergi Numarası'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(67);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_tcknVkn']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(72);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('İl'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(72);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['ilAdi']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(77);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Şube Adı'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(77);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_subeAdi']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(82);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Mahalle / Köy Adı'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(82);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_mahalleKoy']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(87);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Cadde'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(87);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_cadde']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(92);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Gsm Telefon No'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(92);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_gsmTelefon']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(97);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('E-Posta Adresi'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(97);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_eposta']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(102);
$pdf->SetX(10);
$pdf->Cell(40,4,$this->fpdf_turkce('Tel - Faks'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(102);
$pdf->SetX(50);
$pdf->Cell(70,4,$this->fpdf_turkce(': '.$sube[0]['s_telFaks']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(67);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('V.D.'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(67);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_vd']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(72);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('İlçe'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(72);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['ilceAdi']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(77);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('Şube Kodu'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(77);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_subeKodu']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(87);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('Sokak'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(87);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_sokak']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(92);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('İç Kapı No'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(92);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_icKapiNo']),0,0,'L',false);
$pdf->SetTextColor(100,100,100);
$pdf->setY(97);
$pdf->SetX(125);
$pdf->Cell(30,4,$this->fpdf_turkce('Dış Kapı No'),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(97);
$pdf->SetX(156);
$pdf->Cell(40,4,$this->fpdf_turkce(': '.$sube[0]['s_disKapiNo']),0,0,'L',false);
$pdf->SetFont('arial_tr','B',14);
$pdf->SetTextColor(0,0,0);
$pdf->SetFillColor(237,237,237);
$pdf->setY(110);
$pdf->SetX(5);
$pdf->Cell(200,8,$this->fpdf_turkce('SORUMLU'),0,0,'C',true);
$pdf->SetFont('arial_tr','',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(5);
$pdf->Cell(25,6,$this->fpdf_turkce('T.C.'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(30);
$pdf->Cell(55,6,$this->fpdf_turkce('ADI SOYADI'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(85);
$pdf->Cell(25,6,$this->fpdf_turkce('D.TARİHİ'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(110);
$pdf->Cell(30,6,$this->fpdf_turkce('GSM NO'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(118);
$pdf->SetX(140);
$pdf->Cell(65,6,$this->fpdf_turkce('E-POSTA ADRESİ'),1,0,'C',false);
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(5);
$pdf->Cell(25,6,$this->fpdf_turkce($sube[0]['tc']),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(30);
$pdf->Cell(55,6,$this->fpdf_turkce($sube[0]['adi'].' '.$sube[0]['soyadi']),1,0,'C',false);
$dTarihi = new \DateTime($sube[0]['dogumtarihi']);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(85);
$pdf->Cell(25,6,$this->fpdf_turkce($dTarihi->format('d/m/Y')),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(110);
$pdf->Cell(30,6,$this->fpdf_turkce($sube[0]['telefon']),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(124);
$pdf->SetX(140);
$pdf->Cell(65,6,$this->fpdf_turkce($sube[0]['sorMail']),1,0,'C',false);
$pdf->SetFont('arial_tr','B',14);
$pdf->SetTextColor(0,0,0);
$pdf->SetFillColor(237,237,237);
$pdf->setY(132);
$pdf->SetX(5);
$pdf->Cell(200,8,$this->fpdf_turkce('2 - Tartı Aleti Bilgileri'),0,0,'L',true);
$pdf->SetFont('arial_tr','',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(5);
$pdf->Cell(30,6,$this->fpdf_turkce('Tartı Aleti Tipi'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(35);
$pdf->Cell(20,6,$this->fpdf_turkce('Marka'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(55);
$pdf->Cell(20,6,$this->fpdf_turkce('Model'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(75);
$pdf->Cell(15,6,$this->fpdf_turkce('Sınıf'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(90);
$pdf->Cell(20,6,$this->fpdf_turkce('Kapasite'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(110);
$pdf->Cell(35,6,$this->fpdf_turkce('Seri No'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(145);
$pdf->Cell(15,6,$this->fpdf_turkce('Ü.Yılı'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(160);
$pdf->Cell(20,6,$this->fpdf_turkce('d:Taksir'),1,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(140);
$pdf->SetX(180);
$pdf->Cell(25,6,$this->fpdf_turkce('e:Muayene'),1,0,'C',false);
$veriSay = count($veri);
$pdf->SetFont('arial_tr','',7);
$x = 6;
foreach ($veri as $vv){
$qb = $em->createQueryBuilder();
$cc=$qb->select('c')
->from('App:Cihazlar', 'c')
->where("c.id=$vv")
->getQuery()
->getScalarResult();
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(5);
$pdf->Cell(30, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(5);
$pdf->MultiCell(30, 3, $this->fpdf_turkce($cc[0]['c_tipi']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(35);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(35);
$pdf->MultiCell(20, 3, $this->fpdf_turkce($cc[0]['c_marka']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(55);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(55);
$pdf->MultiCell(20, 3, $this->fpdf_turkce($cc[0]['c_model']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(75);
$pdf->Cell(15, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(75);
$pdf->MultiCell(15, 3, $this->fpdf_turkce($cc[0]['c_sinif']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(90);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->setY(140+$x);
$pdf->SetX(90);
$pdf->MultiCell(20, 3, $this->fpdf_turkce($cc[0]['c_kapasite']), 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(110);
$pdf->Cell(35, 6, $this->fpdf_turkce($cc[0]['c_seriNo']), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(145);
$pdf->Cell(15, 6, $this->fpdf_turkce($cc[0]['c_uretimYili']), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(160);
$pdf->Cell(20, 6, $this->fpdf_turkce($cc[0]['c_dTaksir']), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(180);
$pdf->Cell(25, 6, $this->fpdf_turkce($cc[0]['c_eMuayene']), 1, 0, 'C', false);
$x = $x + 6;
}
for ($i=0;$i<(12-$veriSay);$i++) {
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(5);
$pdf->Cell(30, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(35);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(55);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(75);
$pdf->Cell(15, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(90);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(110);
$pdf->Cell(35, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(145);
$pdf->Cell(15, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(160);
$pdf->Cell(20, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$pdf->SetTextColor(0, 0, 0);
$pdf->setY(140+$x);
$pdf->SetX(180);
$pdf->Cell(25, 6, $this->fpdf_turkce(''), 1, 0, 'C', false);
$x = $x + 6;
}
$pdf->SetFont('arial_tr','B',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(230);
$pdf->SetX(5);
$pdf->Cell(100,6,$this->fpdf_turkce('MÜŞTERİ ONAY'),0,0,'C',false);
$pdf->setY(235);
$pdf->SetX(5);
$pdf->Cell(100,40,'',1,0,'L',false);
$pdf->SetFont('arial_tr','B',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(240);
$pdf->SetX(10);
if ($dogrulamaAraci==1) {
$pdf->Cell(90, 6, $this->fpdf_turkce($eposta), 0, 0, 'C', false); // Sorumlu E-Posta
}else{
$pdf->Cell(90, 6, $this->fpdf_turkce($telefon), 0, 0, 'C', false); // Sorumlu E-Posta
}
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(255);
$pdf->SetX(10);
if ($dogrulamaAraci==1) {
$pdf->MultiCell(90, 6, $this->fpdf_turkce('Üstte yazılı sorumlu e-posta adresi tarafından doğrulama kodu ile doğrulanmıştır.'), 0, 'C', false); // Üstte yazılı sorumlu e-posta adresi tarafından doğrulama kodu ile doğrulanmıştır.
}else{
$pdf->MultiCell(90, 6, $this->fpdf_turkce('Üstte yazılı sorumlu telefon numarası tarafından doğrulama kodu ile doğrulanmıştır.'), 0, 'C', false); // Üstte yazılı sorumlu e-posta adresi tarafından doğrulama kodu ile doğrulanmıştır.
}
$pdf->SetFont('arial_tr','B',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(245);
$pdf->SetX(10);
$pdf->Cell(90,6,$this->fpdf_turkce('D.K. : '.$dogrulamaKodu),0,0,'C',false); // D.K. : 245 658 E-Posta doğrulama kodu
$pdf->SetFont('arial_tr','B',12);
$pdf->SetTextColor(0,0,0);
$pdf->setY(235);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce($this->firmaAyarlari('firmaAdi')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(235);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce('YMS:'.$this->firmaAyarlari('ymsKodu')),0,0,'R',false);
$pdf->SetFont('arial_tr','',11);
$pdf->SetTextColor(0,0,0);
$pdf->setY(240);
$pdf->SetX(110);
$pdf->Cell(95,6,$this->fpdf_turkce($this->firmaAyarlari('yetkiliAdSoyad')),0,0,'C',false);
$pdf->SetFont('arial_tr','',10);
$pdf->SetTextColor(0,0,0);
$pdf->setY(245);
$pdf->SetX(110);
$pdf->Cell(95,6,$this->fpdf_turkce($this->firmaAyarlari('adres')),0,0,'C',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(250);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce($this->firmaAyarlari('ilce').' / '.$this->firmaAyarlari('il')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(250);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce('Cep.: '.$this->firmaAyarlari('gsm')),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(255);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce('Tel.: '.$this->firmaAyarlari('tel')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(255);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce('Fax.: '.$this->firmaAyarlari('fax')),0,0,'R',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(260);
$pdf->SetX(110);
$pdf->Cell(50,6,$this->fpdf_turkce($this->firmaAyarlari('site')),0,0,'L',false);
$pdf->SetTextColor(0,0,0);
$pdf->setY(260);
$pdf->SetX(170);
$pdf->Cell(35,6,$this->fpdf_turkce($this->firmaAyarlari('eposta')),0,0,'R',false);
$belge = 'basvuru_belgesi_'.$basvuruNo.'.pdf';
$pdf->Output('F', 'gecici_yukleme/'.$belge,true);
$this->deleteFile($belge);
$this->uploadFile($belge);
foreach ($veri as $vv){
$qb = $em->createQueryBuilder();
$q = $qb->update('App:Basvurular', 'b')
->set('b.basvuruNo', ':basvuruNo')
->set('b.basvuruBelgesi', ':basvuruBelgesi')
->set('b.basvuruDK', ':basvuruDK')
->set('b.basvuruBelgeDurum', ':basvuruBelgeDurum')
->where("b.sube = ".$key." and b.cihaz=".$vv." and b.kontrolNo is null and b.muayeneNo is null and b.tahsilatNo is null and (b.basvuruTarihi >= '$ilkTarih' or b.basvuruTarihi <= '$sonTarih')")
->setParameter('basvuruNo', $basvuruNo)
->setParameter('basvuruBelgesi', $belge)
->setParameter('basvuruDK', $dogrulamaKodu)
->setParameter('basvuruBelgeDurum', 1)
->getQuery()
->execute();
}
}
return new Response('');
}
/**
* @Route("/sorgula", name="site_sorgula")
*/
public function sorgula():Response
{
$em = $this->getDoctrine()->getManager();
if ($this->ayarlar('disSorgulama')!=1){
return $this->redirectToRoute('site_homepage');
}
$qb = $em->createQueryBuilder();
$iller = $qb->select('i.id,i.name')
->from('App:Il', 'i')
->getQuery()
->getScalarResult();
return $this->render('site/sorgula.html.twig',array('iller'=>$iller));
}
/**
* @Route("/sorgulaGetir", name="site_sorgulaGetir")
*/
public function sorgulaGetir(Request $request):Response
{
$em = $this->getDoctrine()->getManager();
$bolgeKodu = $request->request->get('bolgeKodu');
$subeKodu = $request->request->get('subeKodu');
$seriNo = $request->request->get('seriNo');
$tcknVkn = $request->request->get('tcknVkn');
$il = $request->request->get('il');
$ilce = $request->request->get('ilce');
$mahalleKoy = $request->request->get('mahalleKoy');
$cadde = $request->request->get('cadde');
$sokak = $request->request->get('sokak');
$sql="s.id is not null";
if ($bolgeKodu!=''){
$sql.=" and b.kod like '%$bolgeKodu%'";
}
if ($subeKodu!=''){
$sql.=" and s.subeKodu like '%$subeKodu%'";
}
if ($tcknVkn!=''){
$sql.=" and s.tcknVkn like '%$tcknVkn%'";
}
if ($il!=''){
$sql.=" and il.id=".$il;
}
if ($ilce!=''){
$sql.=" and ilce.id=".$ilce;
}
if ($mahalleKoy!=''){
$sql.=" and s.mahalleKoy like '%$mahalleKoy%'";
}
if ($cadde!=''){
$sql.=" and s.cadde like '%$cadde%'";
}
if ($sokak!=''){
$sql.=" and s.sokak like '%$sokak%'";
}
$qb = $em->createQueryBuilder();
$veriler=$qb->select('s.id,s.kullaniciAdSoyad,il.name as ilAdi,ilce.name as ilceAdi,s.mahalleKoy,s.cadde,s.sokak,s.icKapiNo,s.disKapiNo,k.adsoyad,s.subeKodu')
->from('App:Subeler', 's')
->join('s.il','il')
->join('s.ilce','ilce')
->leftjoin('s.bolge','b')
->leftjoin('b.kullanici','k')
->where($sql)
->addOrderBy('b.id','asc')
->addOrderBy('s.kayitTarihi','desc')
->getQuery()
->getScalarResult();
return $this->render('site/sorgulaGetir.html.twig',array('veriler'=>$veriler,'seriNo'=>$seriNo));
}
/**
* @Route("/sorgula/detay/{kod}", name="site_sorgulaDetay")
*/
public function sorgulaDetay($kod,Request $request):Response
{
$em = $this->getDoctrine()->getManager();
$qb = $em->createQueryBuilder();
$subeBul=$qb->select('s.subeKodu')
->from('App:Subeler', 's')
->getQuery()
->getScalarResult();
$subeKodu = "";
foreach ($subeBul as $ss){
if (sha1($ss['subeKodu'])==$kod){
$subeKodu = $ss['subeKodu'];
}
}
if ($subeKodu==''){
return $this->redirectToRoute('site_sorgula');
}
$qb = $em->createQueryBuilder();
$veri=$qb->select('s,il.name as ilAdi,ilce.name as ilceAdi,sor,b')
->from('App:Subeler', 's')
->join('s.il','il')
->join('s.ilce','ilce')
->leftjoin('s.bolge','b')
->join('s.sorumlu','sor')
->leftjoin('b.kullanici','k')
->where("s.subeKodu='$subeKodu'")
->getQuery()
->getScalarResult();
$qb = $em->createQueryBuilder();
$cihazlar=$qb->select('c')
->from('App:Cihazlar', 'c')
->join('c.sube','s')
->where("s.subeKodu='$subeKodu'")
->getQuery()
->getScalarResult();
$qb = $em->createQueryBuilder();
$basvurular=$qb->select('b.id,c.seriNo,b.basvuruNo,b.tipi,b.basvuruTarihi,b.basvuruBelgesi,b.basvuruBelgeDurum')
->from('App:Basvurular', 'b')
->join('b.sube','s')
->join('b.cihaz','c')
->where("s.subeKodu='$subeKodu'")
->orderBy('b.basvuruTarihi','desc')
->getQuery()
->getScalarResult();
$basvuruVeriler = [];
foreach ($basvurular as $basvuru){
$basvuruVeriler[$basvuru['basvuruNo']]['basvuruNo'] = $basvuru['basvuruNo'];
$basvuruVeriler[$basvuru['basvuruNo']]['tipi'] = $basvuru['tipi'];
$basvuruVeriler[$basvuru['basvuruNo']]['basvuruTarihi'] = $basvuru['basvuruTarihi'];
$basvuruVeriler[$basvuru['basvuruNo']]['basvuruBelgesi'] = $basvuru['basvuruBelgesi'];
$basvuruVeriler[$basvuru['basvuruNo']]['basvuruBelgeDurum'] = $basvuru['basvuruBelgeDurum'];
$basvuruVeriler[$basvuru['basvuruNo']]['seriNo'][] = $basvuru['seriNo'];
}
$qb = $em->createQueryBuilder();
$muayeneler=$qb->select('b.id,c.seriNo,b.muayeneNo,b.tipi,b.muayeneTarihi,b.muayeneBelgesi,b.muayeneBelgeDurum')
->from('App:Basvurular', 'b')
->join('b.sube','s')
->join('b.cihaz','c')
->where("s.subeKodu='$subeKodu' and b.muayeneNo is not null")
->orderBy('b.muayeneTarihi','desc')
->getQuery()
->getScalarResult();
$muayeneVeriler = [];
foreach ($muayeneler as $muayene){
$muayeneVeriler[$muayene['muayeneNo']]['muayeneNo'] = $muayene['muayeneNo'];
$muayeneVeriler[$muayene['muayeneNo']]['tipi'] = $muayene['tipi'];
$muayeneVeriler[$muayene['muayeneNo']]['muayeneTarihi'] = $muayene['muayeneTarihi'];
$muayeneVeriler[$muayene['muayeneNo']]['muayeneBelgesi'] = $muayene['muayeneBelgesi'];
$muayeneVeriler[$muayene['muayeneNo']]['muayeneBelgeDurum'] = $muayene['muayeneBelgeDurum'];
$muayeneVeriler[$muayene['muayeneNo']]['seriNo'][] = $muayene['seriNo'];
}
$qb = $em->createQueryBuilder();
$kontroller=$qb->select('b.id,c.seriNo,b.kontrolNo,b.tipi,b.kontrolTarihi,b.kontrolBelgesi,b.kontrolBelgeDurum')
->from('App:Basvurular', 'b')
->join('b.sube','s')
->join('b.cihaz','c')
->where("s.subeKodu='$subeKodu' and b.kontrolNo is not null")
->orderBy('b.kontrolTarihi','desc')
->getQuery()
->getScalarResult();
$kontrolVeriler = [];
foreach ($kontroller as $kontrol){
$kontrolVeriler[$kontrol['kontrolNo']]['kontrolNo'] = $kontrol['kontrolNo'];
$kontrolVeriler[$kontrol['kontrolNo']]['tipi'] = $kontrol['tipi'];
$kontrolVeriler[$kontrol['kontrolNo']]['kontrolTarihi'] = $kontrol['kontrolTarihi'];
$kontrolVeriler[$kontrol['kontrolNo']]['kontrolBelgesi'] = $kontrol['kontrolBelgesi'];
$kontrolVeriler[$kontrol['kontrolNo']]['kontrolBelgeDurum'] = $kontrol['kontrolBelgeDurum'];
$kontrolVeriler[$kontrol['kontrolNo']]['seriNo'][] = $kontrol['seriNo'];
}
$qb = $em->createQueryBuilder();
$tahsilatler=$qb->select('b.id,c.seriNo,b.tahsilatNo,b.tipi,b.tahsilatTarihi,b.tahsilatBelgesi,b.tahsilatBelgeDurum')
->from('App:Basvurular', 'b')
->join('b.sube','s')
->join('b.cihaz','c')
->where("s.subeKodu='$subeKodu' and b.tahsilatNo is not null")
->orderBy('b.tahsilatTarihi','desc')
->getQuery()
->getScalarResult();
$tahsilatVeriler = [];
foreach ($tahsilatler as $tahsilat){
$tahsilatVeriler[$tahsilat['tahsilatNo']]['tahsilatNo'] = $tahsilat['tahsilatNo'];
$tahsilatVeriler[$tahsilat['tahsilatNo']]['tipi'] = $tahsilat['tipi'];
$tahsilatVeriler[$tahsilat['tahsilatNo']]['tahsilatTarihi'] = $tahsilat['tahsilatTarihi'];
$tahsilatVeriler[$tahsilat['tahsilatNo']]['tahsilatBelgesi'] = $tahsilat['tahsilatBelgesi'];
$tahsilatVeriler[$tahsilat['tahsilatNo']]['tahsilatBelgeDurum'] = $tahsilat['tahsilatBelgeDurum'];
$tahsilatVeriler[$tahsilat['tahsilatNo']]['seriNo'][] = $tahsilat['seriNo'];
}
return $this->render('site/sorgulaDetay.html.twig',array('veri'=>$veri[0],'cihazlar'=>$cihazlar,'basvurular'=>$basvuruVeriler,'muayeneler'=>$muayeneVeriler,'kontroller'=>$kontrolVeriler,'tahsilatlar'=>$tahsilatVeriler));
}
/**
* @Route("/test", name="test")
*/
public function test(Request $request):Response
{
return new Response('');
}
}

src/Controller/SiteDefaultController.php line 57