PHP Dosya Yöneticisi

<?php

class crud {
	public $konum;
	public $db;
	public $ayarlar;
	public $host_adresi;
	public $port_numarasi;
	public $mail_adresiniz;
	public $mail_sifreniz;
	public $debug;
	function __construct($db)
	{
		$this->db=$db;
		$sql=$this->tumtablo("ayarlar");
		$this->ayarlar=$sql->fetch(PDO::FETCH_ASSOC);
		$this->host_adresi=@$this->ayarlar['host_adresi'];
		$this->port_numarasi=@$this->ayarlar['port_numarasi'];
		$this->mail_adresiniz=@$this->ayarlar['mail_adresi'];
		$this->mail_sifreniz=@$this->ayarlar['mail_sifre'];
		$this->konum=__DIR__."/../../img/";
		$this->debug=false;
	}

public function ayarkaydet($post,$file)
	{
		try {

$_FILES=$file;
			$_POST=$post;

unset($_POST['genelayarkaydet']);

$sorgu=$this->db->prepare("UPDATE ayarlar SET {$this->arrayislemi($_POST)} WHERE id='1'");
			$ekle=$sorgu->execute(array_values($_POST));

if ($_FILES['site_logo']["error"] == 0) {
				$sonuc=$this->tekdosya("sitelogoekle",$_FILES['site_logo'],"1");
				if (!$sonuc) {					
					throw new Exception("Dosya Yükleme Hatası: {$_SESSION['hata']}", 1);	
				}
			}

if ($_FILES['site_one_cikan']["error"] == 0) {
				$sonuc=$this->tekdosya("site_one_cikan",$_FILES['site_one_cikan'],"1");
				if (!$sonuc) {					
					throw new Exception("Dosya Yükleme Hatası: {$_SESSION['hata']}", 1);	
				}
			}
			
			if ($_FILES['site_sol_ust_logo']["error"] == 0) {
				$sonuc=$this->tekdosya("site_sol_ust_logo",$_FILES['site_sol_ust_logo'],"1");
				if (!$sonuc) {					
					throw new Exception("Dosya Yükleme Hatası: {$_SESSION['hata']}", 1);	
				}
			}

if ($ekle) {
				return  TRUE;
			} else {
				throw new Exception(implode($sorgu->errorInfo()), 1);	
			}
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return FALSE;
		}
	}

public function satirsayisi($tablo,$sutun,$id="",$islem="")
	{
		try {

/*$proje_biten_sayi_sor=$db->prepare("SELECT proje_durum FROM proje_kul_bag JOIN proje ON proje.proje_id=proje_kul_bag.proje_id WHERE kul_id={$_SESSION['kul_id']} AND proje.proje_durum='Bitti'");*/

if ($islem=="hepsi") {
				$sorgu=$this->db->prepare("SELECT $sutun FROM $tablo");
				$sorgu->execute();
			} else {
				$sorgu=$this->db->prepare("SELECT $sutun FROM $tablo WHERE $sutun=?");
				$sorgu->execute([$id]);
			}

if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}
			return $sorgu->rowcount();		
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return FALSE;
		}		
	}

public function satir_sayisi_sorgu($sql)
	{
		return sqlsorgu($sql);
	}

public function arrayislemi($deger)
	{
		$sonuc=implode(",", array_map(function ($deg){
			return $deg."=?";
		},array_keys($deger)));

return $sonuc;
	}

public function cok($sorgu)
	{
		try {
			$sorgu=$this->db->prepare($sorgu);
			$sorgu->execute();
			$say=$sorgu->rowcount();

if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}
			if ($say==0) {
				//throw new Exception(implode($sorgu->errorInfo()), 1);		
				return array();		
			} else {
				return $sorgu->fetchAll(PDO::FETCH_ASSOC);
			}		
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return FALSE;
		}		
	}

public function coklu($tablo,$sutun,$deger,$cekilecek="*")
	{
		try {
			$sorgu=$this->db->prepare("SELECT $cekilecek FROM $tablo WHERE $sutun=?");
			$sorgu->execute([$deger]);
			$say=$sorgu->rowcount();
			if ($say==0) {
				throw new Exception(implode($sorgu->errorInfo()), 1);		
				//return ["sonuc"=> FALSE, "hata" => $sorgu->errorInfo()];				
			} else {
				return $sorgu->fetchAll(PDO::FETCH_ASSOC);
			}		
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return FALSE;
		}		
	}

public function tek($sorgu)
	{
		try {
			$sorgu=$this->db->prepare($sorgu);
			$sorgu->execute();
			$say=$sorgu->rowcount();

if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}

if ($say==0) {
				//throw new Exception(implode($sorgu->errorInfo()), 1);		
				return array();		
			} else {
				return $sorgu->fetch(PDO::FETCH_ASSOC);
			}		
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return FALSE;
		}		
	}

public function tekil($tablo,$sutun,$deger,$cekilecek="*")
	{
		try {
			$sorgu=$this->db->prepare("SELECT $cekilecek FROM $tablo WHERE $sutun=?");
			$sorgu->execute([$deger]);
			$say=$sorgu->rowcount();
			if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}
			if ($say==0) {
				throw new Exception(implode($sorgu->errorInfo()), 1);		
				//return ["sonuc"=> FALSE, "hata" => $sorgu->errorInfo()];				
			} else {
				return $sorgu->fetch(PDO::FETCH_ASSOC);
			}		
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return ["sonuc"=> FALSE, "hata" => $e->getMessage()];
		}		
	}

public function tumtablo($tablo,$sutunlar="*")
	{
		try {

$sorgu=$this->db->prepare("SELECT $sutunlar FROM $tablo");
			$sorgu->execute();

if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}
			return $sorgu;

} catch (Exception $e) {

$_SESSION['hata']=$e->getMessage();
			return ["sonuc"=> FALSE, "hata" => $e->getMessage()];

}		
	}

public function sip_log($liste,$tur=e)
	{
		if ($this->ayarlar['log_onay']==1) {

if ($tur==e) {
				$mesaj="Sipariş Oluşturuldu";
				$detay=$_SESSION['kul_isim']." kullanıcısı ".date('Y.m.d H:i:s')." tarihinde <b>".@$liste['sip_baslik']."</b> başlıklı bir sipariş oluşturdu.";
				$this->log("e",$detay);
			} elseif ($tur==d) {
				$mesaj="Sipariş Güncellendi";
				$detay=$_SESSION['kul_isim']." kullanıcısı ".date('Y.m.d H:i:s')." tarihinde <b>".@$_POST['sip_baslik']."</b> başlıklı siparişi güncelledi.";
				$this->log("d",$detay);
			}
			$this->direktekle("sip_log",
				[
					'log_sip'=> $liste['log_sip'],
					'log_kul' => $_SESSION['kul_id'],
					'log_mesaj' => $mesaj
				]
			);

}
	}

public function log($tur,$detay)
	{
		try {	
			if ($this->ayarlar['log_onay']==1) {				
				$sorgu=$this->db->prepare("INSERT INTO log SET yapilan_islem=:yapilan_islem, kullanici=:kullanici, islem_tur=:islem_tur ");
				$ekle=$sorgu->execute(array(
					'yapilan_islem' => $detay,
					'kullanici' => @$_SESSION['kul_id'],
					'islem_tur' => $tur
				));

if ($ekle) {
					return TRUE;
				} else {
					throw new Exception(implode($sorgu->errorInfo()), 1);	
				}
			} else {
				return TRUE;
			}
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return FALSE;
		}
	}

public function direktekle($tablo,$deger,$silinecek="")
	{
		try {
			if (strlen($silinecek)!=0) {
				unset($deger["$silinecek"]);
			}

if (isset($deger['files'])) {
				unset($deger["files"]);
			}		
			
			$sorgu=$this->db->prepare("INSERT INTO $tablo SET {$this->arrayislemi($deger)} ");
			$ekle=$sorgu->execute(array_values($deger));

if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}
			
			if ($ekle) {
				return ["sonuc"=> TRUE];
			} else {
				throw new Exception(implode($sorgu->errorInfo()), 1);	
			}
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return ["sonuc"=> FALSE, "hata" => $e->getMessage()];
		}
	}

public function direktguncelle($tablo,$sutun,$id,$silinecek1="",$silinecek2="",$deger)
	{
		
		unset($deger["$silinecek1"]);
		unset($deger["$silinecek2"]);
		if (isset($deger['files'])) {
			unset($deger["files"]);
		}

try {		
			$sorgu=$this->db->prepare("UPDATE $tablo SET {$this->arrayislemi($deger)} WHERE $sutun=$id");
			$ekle=$sorgu->execute(array_values($deger));

if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}
			if ($ekle) {
				return  TRUE;
			} else {
				throw new Exception(implode($sorgu->errorInfo()), 1);	
			}
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return FALSE;
		}
	}

public function silme($tablo,$sutun,$id,$secenekler=[])
	{
		try {
			$sorgu=$this->db->prepare("DELETE FROM $tablo WHERE $sutun=?");
			$kontrol=$sorgu->execute([$id]);

if ($this->debug) {
				pre($sorgu->errorInfo());
				pre($sorgu->debugDumpParams());
			}
			if ($kontrol) {
				return ["sonuc"=> TRUE];
			} else {
				throw new Exception(implode($sorgu->errorInfo()), 1);	
			}
		} catch (Exception $e) {
			return ["sonuc"=> FALSE, "hata" => $e->getMessage()];
		}
	}

public function sonid($tablo, $sutunismi)
	{
		try {
			$sorgu=$this->db->prepare("SELECT $sutunismi FROM $tablo ORDER BY $sutunismi DESC LIMIT 0, 1");
			$sorgu->execute();
			$sonuc=$sorgu->fetch(PDO::FETCH_ASSOC);
			return $sonuc["{$sutunismi}"];
		} catch (Exception $e) {
			return $_SESSION['hata']=["sonuc"=> FALSE, "hata" => $e->getMessage()];
		}
	}

public function cokludosya($islem,$gelenisim,$id)
	{	
		include_once 'class-upload.php';
		
		try {
			$files = array();
			foreach ($gelenisim as $k => $l) {
				foreach ($l as $i => $v) {
					if (!array_key_exists($i, $files))
						$files[$i] = array();
					$files[$i][$k] = $v;
				}
			}

foreach ($files as $file){

$handle = new Upload($file);

if ($handle->uploaded) {		
					$num=rand(100000, 999999);
					$handle->file_name_body_pre=$id."-".$num."-";
					$type=$handle->file_src_name_ext;
					$tmp_dosyaismi=turkce($handle->file_src_name_body);
					$handle->file_new_name_body=$tmp_dosyaismi;
					$handle->allowed = array('application/arj',
						'application/excel',
						'application/gnutar',
						'application/mspowerpoint',
						'application/msword',
						'application/octet-stream',
						'application/onenote',
						'application/pdf',
						'application/plain',
						'application/postscript',
						'application/powerpoint',
						'application/rar',
						'application/rtf',
						'application/vnd.ms-excel',
						'application/vnd.ms-excel.addin.macroEnabled.12',
						'application/vnd.ms-excel.sheet.binary.macroEnabled.12',
						'application/vnd.ms-excel.sheet.macroEnabled.12',
						'application/vnd.ms-excel.template.macroEnabled.12',
						'application/vnd.ms-office',
						'application/vnd.ms-officetheme',
						'application/vnd.ms-powerpoint',
						'application/vnd.ms-powerpoint.addin.macroEnabled.12',
						'application/vnd.ms-powerpoint.presentation.macroEnabled.12',
						'application/vnd.ms-powerpoint.slide.macroEnabled.12',
						'application/vnd.ms-powerpoint.slideshow.macroEnabled.12',
						'application/vnd.ms-powerpoint.template.macroEnabled.12',
						'application/vnd.ms-word',
						'application/vnd.ms-word.document.macroEnabled.12',
						'application/vnd.ms-word.template.macroEnabled.12',
						'application/vnd.oasis.opendocument.chart',
						'application/vnd.oasis.opendocument.database',
						'application/vnd.oasis.opendocument.formula',
						'application/vnd.oasis.opendocument.graphics',
						'application/vnd.oasis.opendocument.graphics-template',
						'application/vnd.oasis.opendocument.image',
						'application/vnd.oasis.opendocument.presentation',
						'application/vnd.oasis.opendocument.presentation-template',
						'application/vnd.oasis.opendocument.spreadsheet',
						'application/vnd.oasis.opendocument.spreadsheet-template',
						'application/vnd.oasis.opendocument.text',
						'application/vnd.oasis.opendocument.text-master',
						'application/vnd.oasis.opendocument.text-template',
						'application/vnd.oasis.opendocument.text-web',
						'application/vnd.openofficeorg.extension',
						'application/vnd.openxmlformats-officedocument.presentationml.presentation',
						'application/vnd.openxmlformats-officedocument.presentationml.slide',
						'application/vnd.openxmlformats-officedocument.presentationml.slideshow',
						'application/vnd.openxmlformats-officedocument.presentationml.template',
						'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
						'application/vnd.openxmlformats-officedocument.spreadsheetml.template',
						'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
						'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
						'application/vnd.openxmlformats-officedocument.wordprocessingml.template',
						'application/vocaltec-media-file',
						'application/wordperfect',
						'application/x-bittorrent',
						'application/x-bzip',
						'application/x-bzip2',
						'application/x-compressed',
						'application/x-excel',
						'application/x-gzip',
						'application/x-latex',
						'application/x-midi',
						'application/xml',
						'application/x-msexcel',
						'application/x-rar',
						'application/x-rar-compressed',
						'application/x-rtf',
						'application/x-shockwave-flash',
						'application/x-sit',
						'application/x-stuffit',
						'application/x-troff-msvideo',
						'application/x-zip',
						'application/x-zip-compressed',
						'application/zip',
						'audio/*',
						'image/*',
						'multipart/x-gzip',
						'multipart/x-zip',
						'text/plain',
						'text/rtf',
						'text/richtext',
						'text/xml',
						'video/*',
						'text/csv');

$dosyaturu=$handle->file_src_name_ext;
					if ($islem=="sikayet_dosya_ekle") {
						$handle->Process($this->konum."icerik");
					} else {
						$handle->Process($this->konum."genel");
					}
					
					$dosyaismi=$handle->file_dst_name;

if ($handle->processed) {

if ($islem=="kullanici_logo_ekle") {
							$sorgu=$this->db->prepare("UPDATE kullanicilar SET 
								kul_logo=:kul_logo WHERE kul_id=:kul_id
								");

$yukle=$sorgu->execute(array(
								'kul_id' => $id,
								'kul_logo' => $dosyaismi
							));
						}

if ($islem=="proje_dosya_ekle") {
							$sorgu=$this->db->prepare("INSERT INTO proje_galeri SET 
								dosya_yolu=:dosya_yolu, dosya_turu=:dosya_turu, proje_id=:proje_id
								");

$yukle=$sorgu->execute(array(
								'proje_id' => $id,
								'dosya_yolu' => $dosyaismi,
								'dosya_turu' => $dosyaturu
							));
						}

if ($islem=="siparis_dosya_ekle") {
							$sorgu=$this->db->prepare("INSERT INTO siparis_galeri SET 
								dosya_yolu=:dosya_yolu, dosya_turu=:dosya_turu, sip_id=:sip_id
								");

$yukle=$sorgu->execute(array(
								'sip_id' => $id,
								'dosya_yolu' => $dosyaismi,
								'dosya_turu' => $dosyaturu
							));
						}

if ($islem=="sikayet_dosya_ekle") {
							$sorgu=$this->db->prepare("INSERT INTO siparis_galeri SET 
								dosya_yolu=:dosya_yolu, dosya_turu=:dosya_turu, sip_id=:sip_id
								");

$yukle=$sorgu->execute(array(
								'sip_id' => $id,
								'dosya_yolu' => $dosyaismi,
								'dosya_turu' => $dosyaturu
							));
						}

} else {
						throw new Exception(implode($handle->error), 1);
					}

$handle-> Clean();

} else {
					throw new Exception(implode($handle->error), 1);
				}

}
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return ['sonuc' => FALSE, 'hata' => $e->getMessage()];
		}
	}

public function tekdosya($islem,$gelenisim,$id)
	{	
		try {
			if ($islem=="firma_logo_ekle") {
				$yuklemeklasoru = $this->konum.'firma';
			} elseif ($islem=="profil_logo_ekle") {
				$yuklemeklasoru = $this->konum.'profil';
			} else {
				$yuklemeklasoru = $this->konum.'genel';
			}

@$gecici_isim = $gelenisim["tmp_name"];
			@$dosya_ismi = $gelenisim["name"];
			$benzersizsayi1=rand(1000000,9999999);
			$isim=turkce($benzersizsayi1.$dosya_ismi);
			$resim_yolu=$isim;
			@move_uploaded_file($gecici_isim, "$yuklemeklasoru/$isim");

if ($islem=="kullanici_logo_ekle") {
				$sorgu=$this->db->prepare("UPDATE kullanicilar SET 
					kul_logo=:kul_logo WHERE kul_id=:kul_id
					");

$yukle=$sorgu->execute(array(
					'kul_id' => $id,
					'kul_logo' => $resim_yolu
				));
			}

if ($islem=="profil_logo_ekle") {
				$sorgu=$this->db->prepare("UPDATE kullanicilar SET 
					kul_logo=:kul_logo WHERE kul_id=:kul_id
					");

$yukle=$sorgu->execute(array(
					'kul_id' => $id,
					'kul_logo' => $resim_yolu
				));
				$_SESSION['kul_logo']=$resim_yolu;
			}

if ($islem=="sitelogoekle") {
				$sorgu=$this->db->prepare("UPDATE ayarlar SET 
					site_logo=:site_logo WHERE id=:id
					");

$yukle=$sorgu->execute(array(
					'id' => $id,
					'site_logo' => $resim_yolu
				));				
			}

if ($islem=="site_one_cikan") {
				$sorgu=$this->db->prepare("UPDATE ayarlar SET 
					site_one_cikan=:site_one_cikan WHERE id=:id
					");

$yukle=$sorgu->execute(array(
					'id' => $id,
					'site_one_cikan' => $resim_yolu
				));				
			}

if ($islem=="site_sol_ust_logo") {
				$sorgu=$this->db->prepare("UPDATE ayarlar SET 
					site_sol_ust_logo=:site_sol_ust_logo WHERE id=:id
					");

$yukle=$sorgu->execute(array(
					'id' => $id,
					'site_sol_ust_logo' => $resim_yolu
				));				
			}

if ($islem=="firma_logo_ekle") {
				$sorgu=$this->db->prepare("UPDATE firma SET 
					logo=:logo WHERE firma_id=:firma_id
					");

$yukle=$sorgu->execute(array(
					'firma_id' => $id,
					'logo' => $resim_yolu
				));
			}

if ($yukle) {
				return ["sonuc"=> TRUE];
			} else {
				throw new Exception(implode($sorgu->errorInfo()), 1);	
			}
			
		} catch (Exception $e) {
			$_SESSION['hata']=$e->getMessage();
			return ["sonuc"=> FALSE, "hata" => $e->getMessage()];
		}	
	}

public function mailkaydet($mailbaslik,$gonderenisim,$gonderilenmail,$mailicerigi,$mailtur)
	{
		$sorgu=$this->db->prepare("INSERT INTO mailler SET
			mail_baslik=:mail_baslik,
			gonderen_isim=:gonderen_isim,
			gonderilen_mail=:gonderilen_mail,
			mail_icerigi=:mail_icerigi,
			mail_tur=:mail_tur
			");

$ekle=$sorgu->execute(array(
			'mail_baslik' => $mailbaslik,
			'gonderen_isim' => $gonderenisim,
			'gonderilen_mail' => $gonderilenmail,
			'mail_icerigi' => $mailicerigi,
			'mail_tur' => $mailtur
		));

}

public function mailgonder($post,$tur="Tekli",$iletisim=false)
	{
		try {
			$_POST=$post;

$mailbasligi=$_POST['mail_baslik'];
			$isim=$_POST['mail_isim']; 
			$mailadresi=$_POST['mail_adres'];
			$mailicerigi=$_POST['mail_detay'];
			
			require_once 'phpmail/Exception.php';
			require_once 'phpmail/PHPMailer.php';
			require_once 'phpmail/SMTP.php';

$mail = new PHPMailer\PHPMailer\PHPMailer(); 
			$mail->IsSMTP();					
			$mail->SMTPAuth = true;
			$mail->SMTPSecure = 'ssl'; 
			$mail->Host = $this->host_adresi;
			$mail->Port = $this->port_numarasi; 
			$mail->IsHTML(true);
			$mail->Username = $this->mail_adresiniz;
			$mail->Password = $this->mail_sifreniz; 
			if ($iletisim) {
				$mail->AddReplyTo($_POST['gonderen'],  $isim);
			}
			$mail->SetFrom($mail->Username, $isim);	
			$mail->Subject = $mailbasligi;
			$mail->Body = $mailicerigi;		
			$mail->CharSet = 'UTF-8';
			$mail->AddAddress($mailadresi);

if($mail->Send()) {
				$this->mailkaydet($mailbasligi, $isim, $mailadresi, $mailicerigi,$tur);
				return TRUE;
			} else {				
				throw new Exception($mail->ErrorInfo, 1);
			}

} catch (Exception $e) {
			$_SESSION['hata'] = $e->getMessage();
			return FALSE;
		}

}

public function toplumailgonder($post,$tur="Toplu Mail")
	{
		try {

$_POST=$post;

if(isset($_POST['mail_isim'])) {
				$isim=$_POST['mail_isim'];
			} else {
				$isim=$this->ayarlar['site_baslik'];
			}

$mailbasligi=$_POST['mail_baslik'];
			$mailicerigi=$_POST['mail_detay'];

require_once 'phpmail/Exception.php';
			require_once 'phpmail/PHPMailer.php';
			require_once 'phpmail/SMTP.php';

$mail = new PHPMailer\PHPMailer\PHPMailer(); 
			$mail->IsSMTP();
			$mail->SMTPAuth = true;
			$mail->SMTPSecure = 'ssl'; 
			$mail->Host = $this->host_adresi;
			$mail->Port = $this->port_numarasi; 
			$mail->IsHTML(true);
			$mail->Username = $this->mail_adresiniz;
			$mail->Password = $this->mail_sifreniz; 
			$mail->SetFrom($mail->Username, $isim);	
			$mail->Subject = $mailbasligi;
			$mail->Body = $mailicerigi;		
			$mail->CharSet = 'UTF-8';
			$maillistesi=array();

if (isset($_POST['mail_kisi_adres'])) {
				foreach ($_POST['mail_kisi_adres'] as $deger) {			
					array_push($maillistesi, $deger);
				}
			}

$liste = array_unique($maillistesi);

foreach ($liste as $value) {
				$mail->AddBCC($value);
				if($mail->Send()) {
					$mail->clearBCCs();
					$this->mailkaydet($mailbasligi, $isim, $value, $mailicerigi,$tur);
				}
			}

return TRUE;

} catch (Exception $e) {
			$_SESSION['hata'] = $e->getMessage();
			return FALSE;
		}
	}

public function mailkoduret($mail,$id)
	{
		$onaykodu=sifreleme($mail.$id.date("Y-m-d"));
		return $onaykodu;
	}

public function maildogrula($kul_id)
	{
		try {
			$kullanici=$this->tekil("kullanicilar", "kul_id", $kul_id, "kul_id,kul_mail,mail_onay_durum");
			$onaykodu = $this->mailkoduret($kullanici['kul_mail'],$kullanici['kul_id']);
			$mailicerik='
			<center style="box-sizing: border-box; color: #212529; font-family: -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; font-size: 16px;">
			<div class="col-md-7" style="box-sizing: border-box; flex: 0 0 58.3333%; max-width: 100%; min-height: 1px; padding-left: 15px; padding-right: 15px; position: relative; width: 763.578px;">
			<div class="jumbotron" style="background-color: #d6f9ff; border-radius: 0.3rem; box-sizing: border-box; color: #3f4648; margin-bottom: 2rem; padding: 4rem 2rem;">
			<h1 style="box-sizing: border-box; font-family: inherit; font-size: 2.5rem; font-weight: 500; line-height: 1.2; margin-bottom: 0.5rem; margin-top: 0px;">
			E-Posta Doğrulama İşlemi</h1>
			<div class="lead" style="box-sizing: border-box; font-size: 1.25rem; margin-bottom: 1rem;">
			Sistemi Kullanabilmek İçin Lütfen E-Postanızı Onaylayın</div>
			<hr class="mr-3" style="border-bottom: 0px; border-image: initial; border-left: 0px; border-right: 0px; border-top-color: rgba(0, 0, 0, 0.1); border-top-style: solid; box-sizing: content-box; height: 0px; margin-bottom: 1rem; margin-right: 1rem !important; margin-top: 1rem; overflow: visible;" />

<a href="'.$this->ayarlar['site_link'].'/mailonayla/'.$onaykodu.'">
			<button class="btn btn-dark" style="background-color: #343a40; border-color: rgb(52, 58, 64); border-radius: 0.25rem; border-style: solid; border-width: 1px; color: white; cursor: pointer; font-family: inherit; font-size: 1rem; line-height: 1.5; margin: 0px; overflow: visible; padding: 0.375rem 0.75rem; transition: color 0.15s ease-in-out 0s, background-color 0.15s ease-in-out 0s, border-color 0.15s ease-in-out 0s, box-shadow 0.15s ease-in-out 0s; user-select: none; vertical-align: middle; white-space: nowrap;" type="button">E-Posta Adresini Onayla</button>
			</a>
			</div>
			</div>
			</center>';

if ($this->ayarlar['mail_onay']==1) {
				if ($kullanici['mail_onay_durum']==0) {
					$liste = array(
						'mail_onay_kod' => $onaykodu
					);

$this->direktguncelle("kullanicilar", "kul_id", $kul_id, "silinecek1", "silinecek2", $liste);

$onaymail=array(
						'mail_baslik' => "E-Posta Onaylama İşlemi | ".$this->ayarlar['site_baslik'],
						'mail_isim' => $this->ayarlar['site_baslik'],
						'mail_adres' => $kullanici['kul_mail'],
						'mail_detay' => $mailicerik
					);

$sonuc=$this->mailgonder($onaymail,"E-Posta Doğrulama");
					if ($sonuc) {
						return TRUE;
					}
				} else {
					throw new Exception("Mail Adresinizi Zaten Doğruladınız", 1);
				}
			} else {
				throw new Exception("Mail Onay İşlemi Kapalı", 1);
			}
		} catch (Exception $e) {
			$_SESSION['hata'] = $e->getMessage();
			return FALSE;
		}

}

public function cevaplandi_maili($sikayet_id)
	{
		
		$sikayet=$this->tek("SELECT sikayet.*,kullanicilar.kul_mail,kullanicilar.cevap_mail_onay FROM sikayet INNER JOIN kullanicilar ON kullanicilar.kul_id=sikayet.ekleyen WHERE sikayet.sikayet_id=$sikayet_id");
		
		if ($sikayet['tur']==0) {
			$tur="sikayet";
		} else {
			$tur="tesekkur";
		}

$mailicerigi='<center style="box-sizing: border-box; color: #212529; font-family: -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; font-size: 16px;">
		<div class="col-md-7" style="box-sizing: border-box; flex: 0 0 58.3333%; max-width: 100%; min-height: 1px; padding-left: 15px; padding-right: 15px; position: relative; width: 100%;">
		<div class="jumbotron" style="background-color: #2fd5c9;border-radius: 0.5rem;box-sizing: border-box;color: white;margin-bottom: 2rem;padding: 3rem 2rem;">
		<h1 style="box-sizing: border-box; font-family: inherit; font-size: 2.5rem; font-weight: 500; line-height: 1.2; margin-bottom: 0.5rem; margin-top: 0px;">
		Şikayetiniz Cevaplandı		
		</h1>
		<div class="lead" style="box-sizing: border-box; font-size: 1.25rem; margin-bottom: 1rem;">"'.$sikayet["baslik"].'" <br>Başlıklı Şikayetinize Firma Tarafından Cevap Verildi</div>
		<hr class="mr-3" style="border-bottom: 0px; border-image: initial; border-left: 0px; border-right: 0px; border-top-color: rgba(0, 0, 0, 0.1); border-top-style: solid; box-sizing: content-box; height: 0px; margin-bottom: 1rem; margin-right: 1rem !important; margin-top: 1rem; overflow: visible;">

<a href="'.$this->ayarlar["site_link"].'/'.$tur.'/'.$sikayet['link'].'">
		<button class="btn btn-dark" style="background-color: #ffffff; border-color: #1cbdb2; border-radius: 0.25rem; border-style: solid; border-width: 1px; color: #1cbdb2; cursor: pointer; font-family: inherit; font-size: 1rem; line-height: 1.5; margin: 0px; overflow: visible; padding: 0.375rem 0.75rem; transition: color 0.15s ease-in-out 0s, background-color 0.15s ease-in-out 0s, border-color 0.15s ease-in-out 0s, box-shadow 0.15s ease-in-out 0s; user-select: none; vertical-align: middle; white-space: nowrap;" type="button">Cevabı Görüntüle</button>
		</a>

<br><br>
		<div><a href="'.$this->ayarlar["site_link"].'" style="color:white; text-decoration:none">'.$this->ayarlar["site_baslik"].'</a></div>

</div>
		</div>

</center>';

$liste=[
			'mail_baslik' => "Şikayetiniz Cevaplandı | ".$this->ayarlar['site_baslik'],
			'mail_isim' => $this->ayarlar['site_baslik'],
			'mail_adres' => $sikayet['kul_mail'],
			'mail_detay' => $mailicerigi
		];
		
		
		if ($sikayet['cevap_mail_onay']==1 AND $this->ayarlar['cevap_mail_onay']) {
			$sonuc=$this->mailgonder($liste, "Şikayet Cevap Bildirme");
		}
		
		return $sonuc;

}

public function onesignal($mesaj,$baslik,$liste)
	{

return bildirim($mesaj,$baslik,$liste);

}

public function onesignal_web($mesaj,$baslik,$liste)
	{

return bildirim_web($mesaj,$baslik,$liste);

}

public function sms($mesaj,$kullanicilar)
	{
		return smsgonder($mesaj,$kullanicilar);
	}

}

İptal

📁 PHP Dosya Yöneticisi

📝 class-crud.php

📝 class-crud.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)