REDROOM

Navigation

Breadcrumbs
/ / home / ankaservis / servis.ankaservis.com / muhasebe / sistem
Create

Create File | Create Folder | Upload Files | Run Command
Preview: ServisDuzen.php Size: 72.47 KB
/home/ankaservis/servis.ankaservis.com/muhasebe/sistem/ServisDuzen.php
		<div class="contentpanel">
		
				 
		<?php
		error_reporting(0);
		$IS = isset($_GET["IS"]) ? $_GET["IS"] : "";
		if($IS=="Sil")
		{
		$g_id = isset($_GET["ID"]) ? mysql_Real_escape_string($_GET["ID"]) : "";
		$m_id = isset($_GET["GiT"]) ? mysql_Real_escape_string($_GET["GiT"]) : "";

		$musteri_sil = "DELETE FROM girisler WHERE GID='$g_id'";
		$sil_sonuc = mysql_query($musteri_sil);	
		if($sil_sonuc)
		{
			$hareketi_sil = "DELETE FROM carihareket WHERE servisid='$g_id'";
				$hareketi_sil_sonuc = mysql_query($hareketi_sil);	
		echo'
		<div class="alert alert-success">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<strong>Servis Girişi Başarıyla Silindi..
		</strong>
		</div>
		<img src="images/loaders/loader13.gif">
		';
	echo "<meta http-equiv='refresh' content='0;URL=Musteri.php?GiT=$m_id'>";

		return;
		}

		else
		{
		echo"<img src='images/hata.png' /><stong> <span style='color:red;'>  Bir Sorun Oluştu Tekrar Deneyin!.</span></stong> ";
		echo "<meta http-equiv='refresh' content='4;URL=Musteri.php?GiT=$m_id'>";

		}
		}
		?>
		<?php 
		// G parametresi .htaccess'ten geliyor, giris parametresi form submit'ten gelebilir
		// Sayfanın başında tanımlanmalı ki hem guncelle hem de normal görüntüleme sırasında kullanılabilsin
		$G = isset($_GET["G"]) ? mysql_Real_escape_string($_GET["G"]) : (isset($_GET["giris"]) ? mysql_Real_escape_string($_GET["giris"]) : "");
		$ADI = isset($_GET["ADI"]) ? mysql_Real_escape_string($_GET["ADI"]) : "";
		
		// Debug: Parametreleri kontrol et (geçici - canlıda kaldırılabilir)
		// error_log("ServisDuzen Debug - G: " . $G . ", GiT: " . (isset($_GET['GiT']) ? $_GET['GiT'] : 'yok') . ", ADI: " . $ADI);
		// error_log("ServisDuzen Debug - GET: " . print_r($_GET, true));
		
		// G parametresi boşsa hata göster
		if(empty($G) && !isset($_GET["IS"])) {
			echo '<div class="alert alert-danger">
				<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
				<strong>Hata:</strong> Servis giriş numarası bulunamadı. Lütfen geçerli bir servis detay sayfasına gidin.<br>
				<small>Debug: G parametresi boş. GET parametreleri: ' . htmlspecialchars(print_r($_GET, true)) . '</small>
			</div>';
			echo "<meta http-equiv='refresh' content='5;URL=girisler.php'>";
			return;
		}
		
		$islem = isset($_GET['GiT']) ? mysql_Real_escape_string($_GET['GiT']) : "";


		if($islem=="guncelle")
		{
		$firmakodu =mysql_Real_escape_string($_POST["firmakodu"]);
		$onnot =mysql_Real_escape_string($_POST["onnot"]);
		$baslama_t =mysql_Real_escape_string($_POST["baslama_t"]);
		$baslama_s =mysql_Real_escape_string($_POST["baslama_s"]);
		$bitis_s =mysql_Real_escape_string($_POST["bitis_s"]);
		$teslim_s =mysql_Real_escape_string($_POST["teslim_s"]);
		$iscilik_s =mysql_Real_escape_string($_POST["iscilik_s"]);
		
				
		$tarihi =mysql_Real_escape_string($_POST["tarih"]);
		
		$personeli = isset($_POST["personel"]) && !empty($_POST["personel"]) ? intval($_POST["personel"]) : "NULL";
		$musteri =mysql_Real_escape_string($_POST["mid"]);
		$ss =mysql_Real_escape_string($_POST["ss"]);
		$uruncinsi =mysql_Real_escape_string($_POST["uruncinsi"]);
		$faturano =mysql_Real_escape_string($_POST["faturano"]);
	
		$ekipmanlar = mysql_Real_escape_string($_POST["ekipmanlar"]);
		$sikayeti = mysql_Real_escape_string($_POST["sikayeti"]);
		$garantisi = mysql_Real_escape_string($_POST["garantisi"]);
		$onarimmerkeziid = isset($_POST["onarimmerkezi"]) && !empty($_POST["onarimmerkezi"]) ? intval($_POST["onarimmerkezi"]) : "NULL";
		$merkezdonustarihi = isset($_POST["merkezdonustarihi"]) ? mysql_Real_escape_string($_POST["merkezdonustarihi"]) : "";
		$merkezgonderimtarihi = isset($_POST["merkezgonderimtarihi"]) ? mysql_Real_escape_string($_POST["merkezgonderimtarihi"]) : "";
		$takipnoyolla = isset($_POST["takipnoyolla"]) ? mysql_Real_escape_string($_POST["takipnoyolla"]) : "";
		$durum =mysql_Real_escape_string($_POST["durum"]);
		$btarih =mysql_Real_escape_string($_POST["btarih"]);
		if($btarih==""){
		$bitissaat	="";
		}else{
		date_default_timezone_set("Europe/Istanbul");
		$bitissaat	=date("H:i:s");
		}
		$islemler =isset($_POST["islemler"]) ? mysql_Real_escape_string($_POST["islemler"]) : "";
		$dservis =isset($_POST["dservis"]) ? mysql_Real_escape_string($_POST["dservis"]) : "";
		$ucret =isset($_POST["ucret"]) ? mysql_Real_escape_string($_POST["ucret"]) : "";
		$serino =mysql_Real_escape_string($_POST["serino"]);
		$markasi =mysql_Real_escape_string($_POST["marka"]);
		$turune = mysql_Real_escape_string($_POST["turu"]);
		$maili = mysql_Real_escape_string($_POST["mail"]);
		$mailadi = mysql_Real_escape_string($_POST["mailadi"]);
		$teslimtarihi = mysql_Real_escape_string($_POST["teslimtarihi"]);
		$sorumlupersonel = isset($_POST["sorumlupersonel"]) && !empty($_POST["sorumlupersonel"]) ? intval($_POST["sorumlupersonel"]) : "NULL";
		if($teslimtarihi==""){
		$teslimsaat	="";
		}else{
		date_default_timezone_set("Europe/Istanbul");
		$teslimsaat	=date("H:i:s");
		}
				$urundurumu = isset($_POST["urundurumu"]) ? mysql_Real_escape_string($_POST["urundurumu"]) : "";
				$ekipmanidin = isset($_POST["ekipmanid"]) ? $_POST["ekipmanid"] : array();
			if(empty($ekipmanidin)){
			$ekipmanid="";
					}else{
					$ekipmanid = implode(",", $ekipmanidin);
				}
			//parça idleri	
			$parcaid = isset($_POST["parcaid"]) ? $_POST["parcaid"] : array();
			if(empty($parcaid)){
			$parcaid="";
			}else{
			$parcaid = implode(",", $parcaid);
			}
			//parça idleri bitti
			
		// G ve ADI değişkenleri sayfanın başında zaten tanımlanmış
		function StrToBuyuk($islemler){
		$islemler=strtoupper( str_replace( "i", "İ", str_replace( "ı", "I", str_replace( "ç", "Ç", str_replace( "ş", "Ş", str_replace( "*", "<br/>", str_replace( "ğ", "Ğ", str_replace( "ö", "Ö", str_replace( "Ã¼", "Ãœ", str_replace( "Ü", "U", $islemler ) ) ) ) ) ) ) ) ) ) ;
		return $islemler;
		}
		$yis= StrToBuyuk($islemler);

		function StrToBuyuk2($sikayeti){
		$sikayeti=strtoupper( str_replace( "i", "İ", str_replace( "ı", "I", str_replace( "ç", "Ç", str_replace( "ş", "Ş", str_replace( "*", "<br/>", str_replace( "ğ", "Ğ", str_replace( "ö", "Ö", str_replace( "Ã¼", "Ãœ", str_replace( "Ü", "U", $sikayeti ) ) ) ) ) ) ) ) ) ) ;
		return $sikayeti;
		}
		$msikayet= StrToBuyuk2($sikayeti);
		
		




		$guncel = mysql_query("UPDATE girisler Set   
		GTarih				='$tarihi',
		HSikayet			='$msikayet',
		Gekipmanlar			='$ekipmanlar',
		uruncinsi			='$uruncinsi',
		garanti				='$garantisi',
		Gdurum				='$durum',
		BitisTarihi			='$btarih',
		Yapilanislemler		='$yis',
		DServis				='$dservis',
		Ucret				='$ucret',
		teslimtarihi		='$teslimtarihi',
		serino				='$serino',
		marka				='$markasi',
		turu				='$turune',
		ekipmanid			='$ekipmanid',
		urundurumu			='$urundurumu',
		parcaid				='$parcaid',
		teslimsaat			='$teslimsaat',
		bitissaat			='$bitissaat',
		onarimmerkezi		=" . ($onarimmerkeziid === "NULL" ? "NULL" : "'$onarimmerkeziid'") . ",
		merkezgonderimtarihi='$merkezgonderimtarihi',
		merkezdonustarihi	='$merkezdonustarihi',
		sorumlupersonel		=" . ($sorumlupersonel === "NULL" ? "NULL" : "'$sorumlupersonel'") . ",
		yeni_personel		=" . ($personeli === "NULL" ? "NULL" : "'$personeli'") . ",
		faturano			='$faturano',
		firmakodu			='$firmakodu',
		onnot				='$onnot',
		baslama_t			='$baslama_t',
		baslama_s			='$baslama_s',
		bitis_s				='$bitis_s',
		teslim_s			='$teslim_s',
		iscilik_s			='$iscilik_s'
		where GID='$musteri' ");

	
		
		if($guncel)
		{
			
			$ucreticin = isset($_POST["durum"]) ? mysql_Real_escape_string($_POST["durum"]) : "";
			//ücret bildir başa
		
			if($ucreticin=="54"){
		$smsidzm = isset($_POST["durum"]) ? mysql_Real_escape_string($_POST["durum"]) : "";
		$smsidiniverbanamaille_result = mysql_query("select * from servisDurumu where id='".$smsidzm."'", $baglanti);
		if($smsidiniverbanamaille_result && mysql_num_rows($smsidiniverbanamaille_result) > 0) {
			$smsidiniverbanamaille = mysql_fetch_array($smsidiniverbanamaille_result);
			$xyzmail	= isset($smsidiniverbanamaille["sms"]) ? $smsidiniverbanamaille["sms"] : '';
			$smsgonder2_result = mysql_query("select * from smssablon where id='".$xyzmail."'", $baglanti);
			if($smsgonder2_result && mysql_num_rows($smsgonder2_result) > 0) {
				$smsgonder2 = mysql_fetch_array($smsgonder2_result);
				$durumsord2	= isset($smsgonder2["id"]) ? $smsgonder2["id"] : '';
			} else {
				$smsgonder2 = null;
				$durumsord2 = '';
			}
		} else {
			$smsgonder2 = null;
			$durumsord2 = '';
		}
		
		
		
		
		//smsbaşla
			set_time_limit(0);
	
	ini_set('mysql.connect_timeout', 600);
	ini_set('default_socket_timeout', 600);
	

	
	function sendRequest2($site_name,$send_xml,$header_type=array('Content-Type: text/xml')) 
	{

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL,$site_name);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS,$send_xml);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST,2); // PHP 8.2+ için 2 kullanılmalı
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,0);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
        curl_setopt($ch, CURLOPT_HTTPHEADER,$header_type);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);
        curl_setopt($ch, CURLOPT_TIMEOUT, 120);

        $result2 = curl_exec($ch);

        return $result2;
    }
			
		
		
		
			$sqlon22 = $musteri;
								
									$kdv_ver2_result = mysql_query("select * from girisler where GID='".$musteri."'", $baglanti);
									if($kdv_ver2_result && mysql_num_rows($kdv_ver2_result) > 0) {
										$kdv_ver2 = mysql_fetch_array($kdv_ver2_result);
										$kdvdeger2 = isset($kdv_ver2["kdv"]) ? floatval($kdv_ver2["kdv"]) : 0;
										$telialucretle = isset($kdv_ver2["MID"]) ? intval($kdv_ver2["MID"]) : 0;
									
										if($telialucretle > 0) {
											$musteriteliicin2_result = mysql_query("select * from musteriler where ID='".$telialucretle."'", $baglanti);
											if($musteriteliicin2_result && mysql_num_rows($musteriteliicin2_result) > 0) {
												$musteriteliicin2 = mysql_fetch_array($musteriteliicin2_result);
												$ucretteli = isset($musteriteliicin2["Tel"]) ? $musteriteliicin2["Tel"] : "";
											} else {
												$ucretteli = "";
											}
										} else {
											$ucretteli = "";
										}
										
										$resultset_result = mysql_query("select sum(toplam) as toplam from parcamodul where girisid='$musteri'", $baglanti);
										if($resultset_result) {
											$resultset = mysql_fetch_assoc($resultset_result);
										} else {
											$resultset = array("toplam" => 0);
										}
									} else {
										$kdvdeger2 = 0;
										$telialucretle = 0;
										$ucretteli = "";
										$resultset = array("toplam" => 0);
									}

									 
									$kasa = isset($resultset["toplam"]) ? floatval($resultset["toplam"]) : 0; 
									$yuzdehesap = $kasa * $kdvdeger2 / 100;
									
									
									$tutarsms = ' ' . number_format($yuzdehesap + $kasa, 2) . ' TL';
									$smsyazgonder2_text = isset($smsgonder2["sms"]) ? $smsgonder2["sms"] : "";
									$smsyazgonder2 = $smsyazgonder2_text . " Verilen hizmet karsiliginda  " . $tutarsms . " odeme alinmistir. ";
		
		
		
		date_default_timezone_set("Europe/Istanbul");
		$bugun	=date("d/m/Y. H:i");

	$xml = "
	<SMS>
	   <oturum>
		  <kullanici>$apismsusername</kullanici>
		  <sifre>$apismspassword</sifre>
	   </oturum>
	   <mesaj>
		  <baslik>$apismsorgin_name</baslik>
		  <metin>$smsyazgonder2 TAKIP NUMARANIZ: $G</metin>
		  <alicilar>$ucretteli</alicilar>
	   </mesaj>
	</SMS>";


	$gonder2 = sendRequest2("http://www.dakiksms.com//api/xml_api.php",$xml);
	
	$degisken = var_export($gonder2,1);
		$islemBasarili2 = strstr($gonder2, "OK");
		$bakiyeYetersiz2 = strstr($gonder2, "ERR");
		if($islemBasarili2){
		$eklesmsi2 = mysql_query("INSERT INTO sms Set musteri='$telialucretle', tarih='$bugun', sms='$smsyazgonder2'");
		echo'
		<div class="alert alert-success">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<strong>Ücret Müşteriye SMS ile Bildirildi.
		</strong>
		</div>
		
		';
	
		}else if($bakiyeYetersiz2){
		}

		
		//smsbit
	
		}else{ }
		
		//ücret bildir bit
			
			
			
				date_default_timezone_set("Europe/Istanbul");
		$bugun	=date("d.m.Y");
			$shatirlat = isset($_POST["shatirlat"]) ? mysql_Real_escape_string($_POST["shatirlat"]) : "";
			$sql = "select * from musteriler where id='$ss'";
		$hatirlatmaekleyelim = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($hatirlatmaekleyelimal = mysql_fetch_array($hatirlatmaekleyelim)){ 
		$hatirlatmaadsoyad = isset($hatirlatmaekleyelimal["Ad_Soyad"]) ? $hatirlatmaekleyelimal["Ad_Soyad"] : "";
		$hatirlatmatel = isset($hatirlatmaekleyelimal["Tel"]) ? $hatirlatmaekleyelimal["Tel"] : "";	
		$hatirlatmaadres = isset($hatirlatmaekleyelimal["Adres"]) ? $hatirlatmaekleyelimal["Adres"] : "";
		$bilgi="Hatırlatma ".$musteri." takip numaralı servis girişine istinaden oluşturulmuştur.";
		if($shatirlat==""){}else{
		
		$hatirlatmaekle = mysql_query("INSERT INTO servis Set adsoyad='Servis hatırlatması - $hatirlatmaadsoyad', tel='$hatirlatmatel', adres='$hatirlatmaadres', gtarih='$bugun', mtarih='$shatirlat', bilgi='$bilgi', sikayet='$sikayeti', girisid='$musteri'");
		}
		}
		//mail başla
		$maille = isset($_POST["maille"]) ? mysql_Real_escape_string($_POST["maille"]) : "";
		if($maille=="1"){
		$smsidzm = isset($_POST["durum"]) ? mysql_Real_escape_string($_POST["durum"]) : "";
		$smsidiniverbanamaille = mysql_fetch_array(mysql_query("select * from servisDurumu where id='".$smsidzm."'", $baglanti));
		if($smsidiniverbanamaille) {
			$xyzmail	= $smsidiniverbanamaille["sms"] ?? '';
			$mailgon = mysql_fetch_array(mysql_query("select * from smssablon where id='".$xyzmail."'", $baglanti));
			$durumsormm	= isset($mailgon["id"]) ? $mailgon["id"] : '';
			$mailyazgonder	= isset($mailgon["sms"]) ? $mailgon["sms"] : '';
			$mailyazgonderadi	= isset($mailgon["adi"]) ? $mailgon["adi"] : '';
		} else {
			$mailgon = null;
			$durumsormm = '';
			$mailyazgonder = '';
			$mailyazgonderadi = '';
		}
		
		if(empty($durumsormm)){ 
		}else{
		

$gms_id = isset($_GET["ID"]) ? mysql_Real_escape_string($_GET["ID"]) : "";
	require_once("class.phpmailer.php");

	$mail = new PHPMailer();
	$mail->IsSMTP();
	$mail->Host = "$smtpgsunucu";
	$mail->SMTPAuth = true;
	$mail->Username = "$smtpkullaniciadi";
	$mail->Password = "$smtpsifrever";
	$mail->CharSet="UTF-8";
	$mail->IsHTML(true);
	$mail->From = "$smtpkullaniciadi";
	$mail->FromName = "$smtpgonderfrom";
	$mail->AddAddress("".$maili."","$smtpbaslik");
	$mail->Subject = "$smtpbaslik";
	$mail->Body ='
	
		Sayın <b>'.$mailadi.'</b> ;<p> <br>
			<p>'.$mailyazgonder.'</p>
			<p>&nbsp;</p>
			<p>Takip Numaranız <b>'.$G.'</b><br></p>
			<p><a href="'.$smtpsorguadresi.'" />Onarım Durumunu sorgulamak için Tıklayın </a></p>
';
if(!$mail->Send())
	{ }
	
}
}
		
		//mailbit
		
		
		
		
		
		$smsle = isset($_POST["smsle"]) ? mysql_Real_escape_string($_POST["smsle"]) : "";
		if($smsle=="1"){
		$smsidz = isset($_POST["durum"]) ? mysql_Real_escape_string($_POST["durum"]) : "";
		$smsidiniverbana = mysql_fetch_array(mysql_query("select * from servisDurumu where id='".$smsidz."'", $baglanti));
		if($smsidiniverbana) {
			$xyz	= $smsidiniverbana["sms"] ?? '';
			$smsgonder = mysql_fetch_array(mysql_query("select * from smssablon where id='".$xyz."'", $baglanti));
			$durumsord	= isset($smsgonder["id"]) ? $smsgonder["id"] : '';
		} else {
			$smsgonder = null;
			$durumsord = '';
		}
		
		if(empty($durumsord)){ 
		}else{
		
		
		//smsbaşla
			set_time_limit(0);
	
	ini_set('mysql.connect_timeout', 600);
	ini_set('default_socket_timeout', 600);
	

	
	function sendRequest($site_name,$send_xml,$header_type=array('Content-Type: text/xml')) 
	{

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL,$site_name);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS,$send_xml);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST,2); // PHP 8.2+ için 2 kullanılmalı
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,0);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
        curl_setopt($ch, CURLOPT_HTTPHEADER,$header_type);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);
        curl_setopt($ch, CURLOPT_TIMEOUT, 120);

        $result = curl_exec($ch);

        return $result;
    }
			
		
		$tel		= isset($_POST["tel"]) ? mysql_Real_escape_string($_POST["tel"]) : "";
		$durumidinialalim = isset($smsidiniverbana) && isset($smsidiniverbana["id"]) ? $smsidiniverbana["id"] : "";
		if($smsidz=="54"){
			$sqlon2 =$musteri;
								
									$kdv_ver2_result = mysql_query("select GID,kdv from girisler where GID='$sqlon2'", $baglanti);
									if($kdv_ver2_result && mysql_num_rows($kdv_ver2_result) > 0) {
										$kdv_ver2 = mysql_fetch_assoc($kdv_ver2_result);
										$kdvdeger2 = isset($kdv_ver2["kdv"]) ? floatval($kdv_ver2["kdv"]) : 0;
									} else {
										$kdvdeger2 = 0;
									}
									
									$resultset_result = mysql_query("select sum(toplam) as toplam from parcamodul where girisid='$sqlon2'", $baglanti);
									if($resultset_result) {
										$resultset = mysql_fetch_assoc($resultset_result);
									} else {
										$resultset = array("toplam" => 0);
									}

									 
									$kasa = isset($resultset["toplam"]) ? floatval($resultset["toplam"]) : 0; 
									$yuzdehesap = $kasa * $kdvdeger2 / 100;
									
									
									$tutarsms=' '.number_format($yuzdehesap+$kasa,2).' TL';
			$smsyazgonder	= isset($smsgonder["sms"]) ? "".$smsgonder["sms"]." Hizmet karsiliginda ".$tutarsms." odeme alinmistir." : "";
		
		}
		if($smsidz!="54"){
		$smsyazgonder	= isset($smsgonder) && isset($smsgonder["sms"]) ? $smsgonder["sms"] : "";
		}
		$musterim = isset($_POST["musteri"]) ? mysql_Real_escape_string($_POST["musteri"]) : "";
		date_default_timezone_set("Europe/Istanbul");
		$bugun	=date("d/m/Y. H:i");

	$xml = "
	<SMS>
	   <oturum>
		  <kullanici>$apismsusername</kullanici>
		  <sifre>$apismspassword</sifre>
	   </oturum>
	   <mesaj>
		  <baslik>$apismsorgin_name</baslik>
		  <metin>$smsyazgonder TAKIP NUMARANIZ: $G</metin>
		  <alicilar>$tel</alicilar>
	   </mesaj>
	</SMS>";


	$gonder = sendRequest("http://www.dakiksms.com//api/xml_api.php",$xml);
	
	$degisken = var_export($gonder,1);
		$islemBasarili = strstr($gonder, "OK");
		$bakiyeYetersiz = strstr($gonder, "ERR");
		if($islemBasarili){
		$eklesmsi = mysql_query("INSERT INTO sms Set musteri='$musterim', tarih='$bugun', sms='$smsyazgonder'");
		echo "<stong> <span style='color:green;'>Ayrıca SMS Gönderildi</span></stong>";
		}else if($bakiyeYetersiz){
		}

		
		//smsbit
		}
		}else{ }
		
		
		
		
		echo'
		<div class="alert alert-success">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<strong>Servis Girişi Başarıyla Güncellendi.
		</strong>
		</div>
		<img src="images/loaders/loader13.gif">
		';
		
		
		echo "<meta http-equiv='refresh' content='2;URL=ServisDuzen.php?GiT=$ss&G=$G&ADI=$ADI'>";

		return;
		}
		else
		{

		echo "Sorun oluştu Tekrar deneyin!";


		}

		}

		?>
		
            <div class="row">
		<?php
		$ilksms	= isset($_GET["kayit"]) ? $_GET["kayit"] : "";
		if($ilksms=="sms"){
		
		$smsidiniverbana = mysql_fetch_array(mysql_query("select * from servisDurumu where id='2'", $baglanti));
		if($smsidiniverbana) {
			$xyz	= $smsidiniverbana["sms"] ?? '';
			$smsgonder = mysql_fetch_array(mysql_query("select * from smssablon where id='".$xyz."'", $baglanti));
			$durumsord	= isset($smsgonder["id"]) ? $smsgonder["id"] : '';
			$smsbaslikadi	= isset($smsgonder["adi"]) ? $smsgonder["adi"] : '';
		} else {
			$smsgonder = null;
			$durumsord = '';
			$smsbaslikadi = '';
		}
		
		if(empty($durumsord)){ 
		}else{
		
		
		//smsbaşla
			set_time_limit(0);
	
	ini_set('mysql.connect_timeout', 600);
	ini_set('default_socket_timeout', 600);
	

	
	function sendRequest($site_name,$send_xml,$header_type=array('Content-Type: text/xml')) 
	{

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL,$site_name);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS,$send_xml);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST,2); // PHP 8.2+ için 2 kullanılmalı
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,0);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
        curl_setopt($ch, CURLOPT_HTTPHEADER,$header_type);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);
        curl_setopt($ch, CURLOPT_TIMEOUT, 120);

        $result = curl_exec($ch);

        return $result;
    }
		$smsyazgonder	= isset($smsgonder) && isset($smsgonder["sms"]) ? $smsgonder["sms"] : "";
		$musterim		= isset($_GET["GiT"]) ? mysql_Real_escape_string($_GET["GiT"]) : "";
		$G			= isset($_GET["G"]) ? mysql_Real_escape_string($_GET["G"]) : "";
		$telial = mysql_fetch_array(mysql_query("select * from musteriler where id='".$musterim."'", $baglanti));
		$tel		= isset($telial["Tel"]) ? $telial["Tel"] : "";
		date_default_timezone_set("Europe/Istanbul");
$bugun	=date("d/m/Y. H:i");

	$xml = "
	<SMS>
	   <oturum>
		  <kullanici>$apismsusername</kullanici>
		  <sifre>$apismspassword</sifre>
	   </oturum>
	   <mesaj>
		  <baslik>$apismsorgin_name</baslik>
		  <metin>$smsyazgonder TAKIP NUMARANIZ: $G</metin>
		  <alicilar>$tel</alicilar>
	   </mesaj>
	</SMS>";


	$gonder = sendRequest("http://www.dakiksms.com//api/xml_api.php",$xml);
	
	$degisken = var_export($gonder,1);
		$islemBasarili = strstr($gonder, "OK");
		$bakiyeYetersiz = strstr($gonder, "ERR");
		if($islemBasarili){
		$eklesmsi = mysql_query("INSERT INTO sms Set musteri='$musterim', tarih='$bugun', sms='$smsyazgonder'");
		
		}else if($bakiyeYetersiz){
		}

		
		//smsbit
		}
		$girisal = isset($_GET["G"]) ? mysql_Real_escape_string($_GET["G"]) : ""; 
		if (!empty($girisal)) {
			$sqls = "select * from girisler where GID='$girisal'";
			$girismail = mysql_query($sqls, $baglanti) or die(mysql_error());
			while ($girismailver = mysql_fetch_array($girismail)){ 
				$takipnosuney = isset($girismailver["GID"]) ? $girismailver["GID"] : "";
				$mid = isset($_GET["GiT"]) ? mysql_Real_escape_string($_GET["GiT"]) : ""; 
				if (!empty($mid)) {
					$sqls = "select * from musteriler where id='$mid'";
					$musteris = mysql_query($sqls, $baglanti) or die(mysql_error());
					while ($musterigetirs = mysql_fetch_array($musteris)){ 
						$musteriadi_mail = isset($musterigetirs["Ad_Soyad"]) ? $musterigetirs["Ad_Soyad"] : "";
						$musterimail_mail = isset($musterigetirs["email"]) ? $musterigetirs["email"] : "";
	
		
		require_once("class.phpmailer.php");

	$mail = new PHPMailer();
	$mail->IsSMTP();
	$mail->Host = "$smtpgsunucu";
	$mail->SMTPAuth = true;
	$mail->Username = "$smtpkullaniciadi";
	$mail->Password = "$smtpsifrever";
	$mail->CharSet="UTF-8";
	$mail->IsHTML(true);
	$mail->From = "$smtpkullaniciadi";
	$mail->FromName = "$smtpgonderfrom";
	$mail->AddAddress("".$musterimail_mail."","$smtpbaslik");
		$mail->Subject = "$smtpbaslik";
	// Email için SMS mesajını al
	$smsyazgonder_mail = "";
	if(isset($smsyazgonder)) {
		$smsyazgonder_mail = $smsyazgonder;
	} elseif(isset($smsgonder) && isset($smsgonder["sms"])) {
		$smsyazgonder_mail = $smsgonder["sms"];
	}
	$mail->Body ='
	Sayın <b>'.$musteriadi_mail.'</b> ;<p> <br>
			<p>'.$smsyazgonder_mail.'</p>
			<p>&nbsp;</p>
		 <p>Takip Numaranız <b>'.$takipnosuney.'</b><br>	
		<a href="'.$smtpsorguadresi.'" />Onarım Durumunu sorgulamak için Tıklayın </a>
			
	</p>
	
';
if(!$mail->Send())
	{

	}
					} 
				}
			}
		}
			
}
		
		
		?>
		<?php 
		$islemi = isset($_GET['islem']) ? mysql_Real_escape_string($_GET['islem']) : "";

		if($islemi=="gorusmeEkle")
		{
		$tarih = isset($_POST["gorusmetarih"]) ? mysql_Real_escape_string($_POST["gorusmetarih"]) : "";
		$girisid = isset($_POST["gorusmegirisid"]) ? mysql_Real_escape_string($_POST["gorusmegirisid"]) : "";
		$not = isset($_POST["gorusmenot"]) ? mysql_Real_escape_string($_POST["gorusmenot"]) : "";
		$musteri = isset($_GET["GiT"]) ? mysql_Real_escape_string($_GET["GiT"]) : "";
		

		$ekle = mysql_query("INSERT INTO gorusmeler Set girisid='".$girisid."', tarih='".$tarih."', metin='".$not."' ");

		if($ekle)
		{
		echo'
		<div class="alert alert-success">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<strong>Notunuz</strong> Başarıyla eklendi...
		</div>
		';
	
		echo "<meta http-equiv='refresh' content='1;URL=ServisDuzen.php?GiT=".$musteri."&G=".$girisid."'>";


		return;
		}
		else
		{

		
		echo "<meta http-equiv='refresh' content='5;URL=ServisDuzen.php?GiT=".$musteri."&G=".$girisid."'>";

		}

	
		}
		?> 
<?php
		$IS = isset($_GET["islem"]) ? $_GET["islem"] : "";
		if($IS=="gorusmeSil")
		{
		$musteri = isset($_GET["GiT"]) ? mysql_Real_escape_string($_GET["GiT"]) : "";
		$silid = isset($_GET["ID"]) ? mysql_Real_escape_string($_GET["ID"]) : "";
		$G = isset($_GET["G"]) ? mysql_Real_escape_string($_GET["G"]) : "";

		$musteri_sil = "DELETE FROM gorusmeler WHERE id='$silid'";
		$sil_sonuc = mysql_query($musteri_sil);	
		if($sil_sonuc)
		{
		echo'
		<div class="alert alert-success">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<strong>Görüşme Notu Başarıyla Silindi..
		</strong>
		</div>
		<img src="images/loaders/loader13.gif">
		';
	echo "<meta http-equiv='refresh' content='0;URL=ServisDuzen.php?GiT=$musteri&G=$G'>";

		return;
		}

		else
		{
		echo "<meta http-equiv='refresh' content='0;URL=ServisDuzen.php?GiT=$musteri&G=$G'>";

		}
		}
		?>	
<?php
		$apdurum = isset($_GET["apdurum"]) ? mysql_Real_escape_string($_GET["apdurum"]) : "";
		if($apdurum=="degistir")
		{
		$G = isset($_GET["G"]) ? mysql_Real_escape_string($_GET["G"]) : "";
		$deger = isset($_GET["deger"]) ? mysql_Real_escape_string($_GET["deger"]) : "";
		$musteri = isset($_GET["GiT"]) ? mysql_Real_escape_string($_GET["GiT"]) : "";
		
		$durumdegis = mysql_query("update girisler Set sonlandir='$deger' where GID='$G'", $baglanti) or die(mysql_error());	
	
	
		}
		?>		
		<div class="btn-list">
									

									 <div class="btn-group mr5">
									<a href="Musteri.php?GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>"><button  class="btn btn-primary">Müşteri Profili</button></a>
									 </div>
									 <div class="btn-group mr5">
									<button type="button" class="btn btn-success dropdown-toggle" data-toggle="dropdown">
                                          Yeni Servis Girişi <span class="caret"></span>
                                        </button>
                                        <ul class="dropdown-menu" role="menu">
                                          <li><a href="servisekle.php?GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>" style="color:#ffffff"><button style="cursor:pointer; width:150px" class="btn btn-success">Müşteri için </button></a></li>
                                          <li>
										<?php 
										// $G değişkeni sayfanın başında tanımlanmış
										$idin = $G;
										$sql = "select * from girisler Where GID='$idin' ";
										$giris = mysql_query($sql, $baglanti) or die(mysql_error());
										while ($girisler = mysql_fetch_array($giris)){ 

										?>
										<form  method="post" action="servisekle.php?GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>&cihaz=yeni" class="form_container left_label">
										<?php 
										$turuall	=$girisler['turu'];

										$sql = "select * from urunturu where id='$turuall'";
										$turugel = mysql_query($sql, $baglanti) or die(mysql_error());
										while ($turugel_ver = mysql_fetch_array($turugel)){


										?>

										<input name="turu" type="hidden" value=" <?php echo $turugel_ver['id']; ?>" maxlength="50" class="large"/> 
										<?php } ?>



										<?php 
										$markaal	=$girisler['marka'];

										$sql = "select * from marka where id='$markaal'";
										$marka = mysql_query($sql, $baglanti) or die(mysql_error());
										while ($marka_ver = mysql_fetch_array($marka)){


										?>

										<input name="marka" type="hidden" value=" <?php echo $marka_ver['id']; ?>" maxlength="50" class="large"/> 
										<?php } ?>


										<input name="serino" type="hidden" value=" <?php echo $girisler['serino']; ?>" maxlength="50" class="large"/> 
										<input id="uruncinsi" name="uruncinsi" type="hidden" value="<?php echo $girisler['uruncinsi']; ?>" style="width:295px;" maxlength="50"/> 

										<center><button style="cursor:pointer; width:150px" class="btn btn-success" >Bu ürün için</button></center>
										</form>
										<?php }?>
										  
										  </li>
                                          
                                        </ul>
										</div>

									 <div class="btn-group mr5">
									<a href="ServisDuzen.php?GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>&ID=<?php echo mysql_Real_escape_string($_GET["G"]); ?>&IS=Sil" onClick="return confirm('Servis Girişini Silmek Üzeresiniz. Onaylıyor musunuz?');"><button  class="btn btn-danger">Girişi Sil</button></a>
									</div>
									<div class="btn-group mr5">
                                        <button type="button" class="btn btn-warning dropdown-toggle" data-toggle="dropdown">
                                          Yazdır  <span class="caret"></span>
                                        </button>
                                        <ul class="dropdown-menu" role="menu">
                                          <li><a href="yazdir.php?GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>&G=<?php echo mysql_Real_escape_string($_GET["G"]); ?>" target="azfis"><button  class="btn btn-warning" style="width:150px">Servis Formu</button></a></li>
                                          <li><a href="fis.php?GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>&G=<?php echo mysql_Real_escape_string($_GET["G"]); ?>" target="azfis"><button  class="btn btn-warning" style="width:150px">Müşteri Fişi</button></a></li>
                                          
                                        </ul>
                                      </div><!-- btn-group -->
									  <?php
		$mid	= mysql_Real_escape_string($_GET["GiT"]); 
		$sql = "select * from musteriler where id='$mid'";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 

		?>
		<?php 
		// $G değişkeni sayfanın başında tanımlanmış
		$idin = $G;
		$sql = "select * from girisler Where GID='$idin' ";
		$giris = mysql_query($sql, $baglanti) or die(mysql_error());
		if(mysql_num_rows($giris) == 0) {
			echo '<div class="alert alert-danger">
				<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
				<strong>Hata:</strong> Servis girişi bulunamadı. GID: ' . htmlspecialchars($idin) . '
			</div>';
			echo "<meta http-equiv='refresh' content='3;URL=girisler.php'>";
			return;
		}
		while ($girisler = mysql_fetch_array($giris)){ 

		?>
<div class="btn-group mr5">

<?php
		$girisonay	= $girisler['sonlandir'];
		if($girisonay=="0"){


		?>
		<a href="ServisDuzen.php?apdurum=degistir&GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>&G=<?php echo mysql_Real_escape_string($_GET["G"]); ?>&deger=1" onClick="return confirm('Servis Pasif hale Getirilecek Teknik Personel Ekranında GÖRÜNMEYECEKTİR. Onaylıyormusunuz?');" class="btn btn-warning mr5">
		
		<b>Pasif Yap</b></a>
		<?php }else{ ?>
		
		<a href="ServisDuzen.php?apdurum=degistir&GiT=<?php echo mysql_Real_escape_string($_GET["GiT"]); ?>&G=<?php echo mysql_Real_escape_string($_GET["G"]); ?>&deger=0" onClick="return confirm('Servis AKTİF hale Getirilecek Teknik Personel Ekranında görünecektir. Onaylıyormusunuz?');" class="btn btn-success mr5">
		
		<b>Aktif Yap</b></a>
		
		<?php } ?>
</div>
									 
									
									</div>	


		<?php
				//YAZ GÖNDER SMS 
	$islem = isset($_GET["mnsms"]) ? mysql_Real_escape_string($_GET["mnsms"]) : "";
		if($islem=="gondersms")
		{

	set_time_limit(0);
	
	ini_set('mysql.connect_timeout', 600);
	ini_set('default_socket_timeout', 600);
	

	
	function sendRequest($site_name,$send_xml,$header_type=array('Content-Type: text/xml')) 
	{

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL,$site_name);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS,$send_xml);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST,2); // PHP 8.2+ için 2 kullanılmalı
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,0);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
        curl_setopt($ch, CURLOPT_HTTPHEADER,$header_type);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);
        curl_setopt($ch, CURLOPT_TIMEOUT, 120);

        $result = curl_exec($ch);

        return $result;
    }
		$tel		= mysql_Real_escape_string($_POST["tel"]);
		$sms		= mysql_Real_escape_string($_POST["sms"]);
		$musteri		= mysql_Real_escape_string($_POST["musteri"]);
		$gg		= mysql_Real_escape_string($_GET["G"]);
		date_default_timezone_set("Europe/Istanbul");
$bugun	=date("d/m/Y. H:i");

	$xml = "
	<SMS>
	   <oturum>
		  <kullanici>$apismsusername</kullanici>
		  <sifre>$apismspassword</sifre>
	   </oturum>
	   <mesaj>
		  <baslik>$apismsorgin_name</baslik>
		  <metin>$sms</metin>
		  <alicilar>$tel</alicilar>
	   </mesaj>
	</SMS>";


	$gonder = sendRequest("http://www.dakiksms.com//api/xml_api.php",$xml);
	
	$degisken = var_export($gonder,1);
		$islemBasarili = strstr($gonder, "OK");
		$bakiyeYetersiz = strstr($gonder, "ERR");
		if($islemBasarili){
		$ekle = mysql_query("INSERT INTO sms Set musteri='$musteri', tarih='$bugun', sms='$sms'");
		echo'
		<div class="alert alert-success">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<i class="fa fa-envelope-o"></i> <strong>SMS Başarıyla Gönderildi.
		</strong>
		</div>
		<img src="images/loaders/loader13.gif">
		';
		echo "<meta http-equiv='refresh' content='1;URL=ServisDuzen.php?GiT=".$musteri."&G=".$gg."'>";
		}else if($bakiyeYetersiz){
		echo 'gönderilemedi';

		echo $degisken;
		}
	
}else{}
		//YAZ GÖNDER SMS BİTTİ
?>
<?php
			//YAZ GÖNDER EPOSTA 
						
	$mailgonderelim = isset($_GET["epostala"]) ? $_GET["epostala"] : "";
		if($mailgonderelim=="emailposta")
		{
		$mailadresi		= mysql_Real_escape_string($_POST["email"]);
		$posta		= mysql_Real_escape_string($_POST["posta"]);
		$musteri	= mysql_Real_escape_string($_POST["musteri"]);
		$gg			= mysql_Real_escape_string($_GET["G"]);
		$idi			= mysql_Real_escape_string($_GET["GiT"]);
		
		
require_once("class.phpmailer.php");
	$mail = new PHPMailer();
	$mail->IsSMTP();
	$mail->Host = "$smtpgsunucu";
	$mail->SMTPAuth = true;
	$mail->Username = "$smtpkullaniciadi";
	$mail->Password = "$smtpsifrever";
	$mail->CharSet="UTF-8";
	$mail->IsHTML(true);
	$mail->From = "$smtpkullaniciadi";
	$mail->FromName = "$smtpgonderfrom";
	$mail->AddAddress("".$mailadresi."","$smtpbaslik");
		$mail->Subject = "$smtpbaslik";
	$mail->Body ='
	
			'.$posta.'
';
if($mail->Send())
	{
echo'
		<div class="alert alert-success">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<i class="fa fa-envelope-o"></i> <strong>EPOSTA Başarıyla Gönderildi.
		</strong>
		</div>
		<img src="images/loaders/loader13.gif">
		';
		echo "<meta http-equiv='refresh' content='1;URL=ServisDuzen.php?GiT=".$idi."&G=".$gg."'>";
	}else{}
	
}

		//YAZ GÖNDER EPOSTA BİTTİ
?>

			<?php
if($girisler['serino']!=""){
$serninokontrol = mysql_num_rows(mysql_query("select * from girisler where  serino='".$girisler['serino']."' and GID!='".$girisler['GID']."'"));

if($serninokontrol>"0"){
echo'
<div class="col-md-12">

<div class="row">
		<div class="alert alert-danger">
		<button aria-hidden="true" data-dismiss="alert" class="close" type="button">&times;</button>
		<strong>'.$girisler['serino'].'</strong> Bu seri numaralı cihaz daha önce <strong>'.$serninokontrol.'</strong> kez geldi! .
		
		</div>
		</div>
		</div>
		';
}else{}
}
?>
		<ul class="nav nav-tabs">
<li class="active"><a href="#anapanel" data-toggle="tab"><strong>Servis Detayları</strong></a></li>
<li><a href="#parcamodultab" data-toggle="tab"><strong>Parça ve Hizmet Bedeli</strong></a></li>
<li><a href="#" data-toggle="tab"><strong>#</strong></a></li>


</ul>
        
<!-- İşlem Ve detaylar Başla -->
<div class="tab-content mb30">
<div class="tab-pane active" id="anapanel">
<form id="basicForm" method="post" action="ServisDuzen.php?GiT=guncelle&giris=<?php echo isset($_GET["G"]) ? mysql_Real_escape_string($_GET["G"]) : ""; ?>&ADI=<?php echo isset($_GET["ADI"]) ? mysql_Real_escape_string($_GET["ADI"]) : ""; ?>">
			<input id="mid" name="mid" type="hidden" value="<?php echo $musterigetir["ID"];?>">
			<div class="col-md-6">

			<div class="panel panel-default">
			<div class="panel-heading">
			<div class="panel-btns">

			</div><!-- panel-btns -->
			<h4 class="panel-title">Servis Giriş Detayları - Takip NO: <b><?php echo $girisler['GID']; ?></b></h4>


			</div><!-- panel-heading -->
			<div class="panel-body">
			<div class="form-group">
			<label class="col-sm-3 control-label">MÜŞTERİ ADI</label>
			<div class="input-group mb20" style="padding-left:10px">
			<?php echo $musterigetir["Ad_Soyad"];?><br>
			<?php echo $musterigetir["firma"];?><br>
			<?php echo $musterigetir["Tel"];?><br>
			<?php echo $musterigetir["sabittel"];?><br>
			<?php echo $musterigetir["Adres"];?>

		<input id="ss" name="ss" type="hidden" value="<?php echo $musterigetir["ID"];?>" >
		<input  name="mailadi" type="hidden" value="<?php echo $musterigetir["Ad_Soyad"];?>" >
		<input  name="mail" type="hidden" value="<?php echo $musterigetir["email"];?>" >
		<input  name="tel" type="hidden" value="<?php echo $musterigetir["Tel"];?>" >
		<input  name="musteri" type="hidden" value="<?php echo $musterigetir["ID"];?>">
			</div>
			</div>
			<div class="form-group">
			<label class="col-sm-3 control-label">Giriş Tarihi</label>
			<div class="input-group mb20" style="padding-left:10px">
			<input id="tarih" name="tarih" type="text" value="<?php echo $girisler['GTarih']; ?>" class="form-control">
			<input id="mid" name="mid" type="hidden" value="<?php echo $girisler["GID"];?>" >
			</div>
			</div>
			<div class="form-group">
			<label class="col-sm-3 control-label">Ürün Cinsi</label>
			<div class="col-sm-9">
		<select name="turu" data-placeholder="Ürün Cinsi Seçin" id="select-basic" class="form-control">
		<?php 
		$turuall	=$girisler['turu'];

		$sql = "select * from urunturu where id='$turuall'";
		$turugel = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($turugel_ver = mysql_fetch_array($turugel)){


		?>

		<option value="<?php echo $turugel_ver['id']; ?>"><?php echo $turugel_ver['turu']; ?></option>
		<?php } ?>
		<option value=""></option>
		<?php 
		$sql = "select * from urunturu order by turu ASC";
		$turugel2 = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($turugel_ver2 = mysql_fetch_array($turugel2)){
		$durumned	=$girisler['turu'];
		$varsa_listeleme	=$turugel_ver2['id'];
		if($durumned=="$varsa_listeleme"){}else{

		?>

		<option value="<?php echo $turugel_ver2['id']; ?>"><?php echo $turugel_ver2['turu']; ?></option>
		<?php } } ?>
	</select>
		
		</div>
		</div>
		<div class="form-group">
			<label class="col-sm-3 control-label">Marka</label>
		<div class="col-sm-9">
		<select name="marka" data-placeholder="Marka Seçin" id="select-basic" class="form-control">
		<?php 
		$markaal	=$girisler['marka'];

		$sql = "select * from marka where id='$markaal'";
		$marka = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($marka_ver = mysql_fetch_array($marka)){


		?>

		<option value="<?php echo $marka_ver['id']; ?>"><?php echo $marka_ver['marka']; ?></option>
		<?php } ?>
		<option value=""></option>
		<?php 
		$sql = "select * from marka order by marka ASC";
		$marka2 = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($marka_ver2 = mysql_fetch_array($marka2)){
		$durumned	=$girisler['marka'];
		$varsa_listeleme	=$marka_ver2['id'];
		if($durumned=="$varsa_listeleme"){}else{

		?>

		<option value="<?php echo $marka_ver2['id']; ?>"><?php echo $marka_ver2['marka']; ?></option>
		<?php } } ?>
	</select>
		
		</div>
		</div>

			
			<div class="form-group">
			<label class="col-sm-3 control-label">Model<span class="asterisk">*</span></label>
			<div class="col-sm-9">
			<input id="uruncinsi" name="uruncinsi" type="text" value="<?php echo $girisler['uruncinsi']; ?>" class="form-control"/> 
			
			</div>
			</div>
			<div class="form-group">
			<label class="col-sm-3 control-label">SeriNo</label>
			<div class="col-sm-9">
			<input name="serino" type="text" value="<?php echo $girisler['serino']; ?>" class="form-control"/> 
			
			</div>
			</div>
			<div class="form-group">
			<label class="col-sm-3 control-label">Firma Kodu</label>
			<div class="col-sm-9">
			<input  name="firmakodu" type="text" value="<?php echo $girisler['firmakodu']; ?>" class="form-control"/>
			
			</div>
			</div>
		<div class="form-group">
			<label class="col-sm-3 control-label">Personel Ata</label>
			<div class="col-sm-9">
			<select name="personel" data-placeholder="Personel Seçin" id="select-basic" class="form-control">
		<?php 
		$pers	=$girisler['yeni_personel'];

		$sql = "select * from yonetici where id='$pers'";
		$persa = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($pers_ver = mysql_fetch_array($persa)){


		?>

		<option value="<?php echo $pers_ver['id']; ?>"><?php echo $pers_ver['adi']; ?></option>
		<?php } ?>
		<option value=""></option>
		
		<option value="">-- Personel Seçin --</option>
		<?php 
		$psql = "select * from yonetici where durum='6' and pasif='0' order by adi ASC";
		$personelver = mysql_query($psql, $baglanti) or die(mysql_error());
		while ($personelAl = mysql_fetch_array($personelver)){
		$durumned	=$girisler['yeni_personel'];
		$varsa_listeleme	=$personelAl['id'];
		if($durumned=="$varsa_listeleme"){}else{

		?>

		<option value="<?php echo $personelAl['id']; ?>"><?php echo $personelAl['adi']; ?></option>
		<?php } } ?>
		</select>
			</div>

			</div><!-- form-group -->
			<div class="form-group">
			<label class="col-sm-3 control-label">Ekipmanlar</label>
			<div class="col-sm-9">
			<?php 
			$girisekip	= mysql_Real_escape_string($_GET["G"]);

			$ekipmanSql = mysql_query("select * from ekipmanlar order by ekipman ASC");
			while($ekipman = mysql_fetch_Array($ekipmanSql)){

			$veri = mysql_query("select * from girisler where GID='$girisekip' and ekipmanid LIKE '%".$ekipman["id"]."%'");


			if(mysql_num_rows($veri) == 1){
			echo'<div class="ckbox ckbox-success">
						<input type="checkbox" id="checkboxSuccess'.$ekipman["id"].'" name="ekipmanid[]" value="'.$ekipman["id"].'"  checked="checked" />
						<label for="checkboxSuccess'.$ekipman["id"].'">'.$ekipman["ekipman"].'</label>
						</div>
			';
			

			}else{
						echo'<div class="ckbox ckbox-success">
						<input type="checkbox" id="checkboxSuccess'.$ekipman["id"].'" name="ekipmanid[]" value="'.$ekipman["id"].'" />
						<label for="checkboxSuccess'.$ekipman["id"].'">'.$ekipman["ekipman"].'</label>
						</div>
			';
			}


			}

			?>
			
		<br>
		Listede olmayanları buraya yazın...
		<input name="ekipmanlar" id="tags3" class="form-control" value="<?php echo $girisler['Gekipmanlar']; ?>" />
		<span>ENTER ile ayırın</span>

		
			</div>

			</div><!-- form-group -->
			<div class="form-group">
			<label class="col-sm-3 control-label">Ürün Durumu</label>
			<div class="col-sm-9">
			<input name="urundurumu" id="tags2" class="form-control" value="<?php echo $girisler['urundurumu']; ?>" />
		<span>ENTER ile ayırın</span>
			</div>

			</div><!-- form-group -->
			
			
			 <div class="form-group">
			<label class="col-sm-3 control-label">Müşteri Şikayeti </label>
			<div class="col-sm-9">
			<input name="sikayeti" id="tags" class="form-control" value="<?php echo $girisler['HSikayet']; ?>" />

			<span>ENTER ile ayırın</span>
			
			</div>
			</div><!-- form-group -->
			<div class="form-group">
			<label class="col-sm-3 control-label">Garanti Durumu</label>
			<div class="col-sm-9">
			<select name="garantisi" id="select-search-hide" data-placeholder="Garanti Durumu Seçin" class="width300" required >
			<?php $gr = $girisler['garanti']; 
		if($gr=="1"){
		echo' <option value="1">Garantili Ürün</option>';
		}else{
		echo'
		<option value="2">Garantisi Yok</option>';
		}
		?>
		<option value="0"></option>
		<option value="1">Garantili Ürün</option>
		<option value="2">Garantisi Yok</option>
		</select>
			</div>

			</div><!-- form-group -->
			<div class="form-group">
					<label class="col-sm-3 control-label">Şu tarihte hatırlat</label>
					<div class="input-group mb20" style="padding-left:10px">
					
					<?php
					$hatırlatmavarmi = mysql_Real_escape_string($_GET['G']);
					$hatirlatmasay = mysql_num_rows(mysql_query("select * from servis where girisid='$hatırlatmavarmi'"));
					if($hatirlatmasay=="0"){
						echo'<span class="input-group-addon" ><i class="glyphicon glyphicon-calendar" ></i></span>
						<input type="text" name="shatirlat" id="sorgu6" class="form-control" style="width:97%" />';
					}else{
					$sql =  "select * from servis where girisid='$hatırlatmavarmi'";
					$girishatirla = mysql_query($sql, $baglanti) or die(mysql_error());
					while ($girishatirlaver = mysql_fetch_array($girishatirla)){ 
					$hatirlatmabitis	= $girishatirlaver['mtarih'];
					$hatirlatmaidal	= $girishatirlaver['id'];
					echo'Bu servis '.$hatirlatmabitis.' tarihinde hatırlatılmak üzere ayarlandı. Hatırlatmayı düzenlemek için <b><a href="hatirlatma_duzen.php?GiT='.$hatirlatmaidal.'">tıklayın</a></b>';
					} }
					?>
					
					
					
                 
					</div>


					</div><!-- form-group -->
		 <div class="form-group">
			<label class="col-sm-3 control-label">Servis girişi yapan</label>
			<div class="col-sm-9">
			<span style="color:red"><b><?php echo $girisler['teslimalan']; ?></b></span>
			</div>
			</div><!-- form-group -->
			
			</div><!-- panel-body -->
			
		


		



		
		
			</div>
			</div>
		
                              
             						<div class="col-md-6">

						<!-- Nav tabs -->
						<ul class="nav nav-tabs">
						<li class="active"><a href="#islemler" data-toggle="tab"><strong>Servis İşlem Detayları</strong></a></li>
						<li><a href="#gorseller" data-toggle="tab"><strong>Ürün Görselleri</strong></a></li>
						<li><a href="#gorusme" data-toggle="tab"><strong>Görüşmeler</strong></a></li>
						<!--<li><a href="#eposta" data-toggle="tab"><strong>E-posta Gönder</strong></a></li>-->


						</ul>

						<!-- Tab panes -->
						<div class="tab-content mb30">
						
							<div class="tab-pane active"  id="islemler">

							
						
                                   
                                    <div class="panel-body">
                                        <div class="row">
                                            
                                            
				
					<div class="form-group">
					<label class="col-sm-3 control-label">Yapılan İşlemler</label>
					<div class="col-sm-9">
					<input name="islemler" id="tags4" class="form-control" value="<?php echo $girisler['Yapilanislemler']; ?>" />
					<span>ENTER ile ayırın</span>
					</div>
					</div><!-- form-group -->
					<div class="form-group">
			<label class="col-sm-3 control-label">Önemli Not</label>
			<div class="col-sm-9">
			<textarea rows="5" name="onnot" class="form-control" ><?php echo $girisler['onnot']; ?></textarea>
			
			
			</div>
			</div>
					
					<div class="form-group">
					<label class="col-sm-3 control-label">Servis Durumu</label>
					<div class="col-sm-9">
					<select name="durum" id="select-basic" class="form-control" >
		<?php 
		$durumne	=$girisler['Gdurum'];

		$sql = "select * from servisDurumu where id='$durumne'";
		$durumu = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($durumual = mysql_fetch_array($durumu)){


		?>

		<option value="<?php echo $durumual['id']; ?>"><?php echo $durumual['servisdurum']; ?></option>
		<?php } ?>
		<option value=""></option>
		<?php 
		$sql = "select * from servisDurumu order by sira ASC";
		$durumu2 = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($durumual2 = mysql_fetch_array($durumu2)){
		$varsa_listeleme	=$durumual2['id'];
		

		?>

		<option value="<?php echo $durumual2['id']; ?>"><?php echo $durumual2['servisdurum']; ?></option>
		<?php }  ?>
		</select>
		<?php 
		$smsicin	=$girisler['Gdurum'];

		$sql = "select * from servisDurumu where id='$durumne'";
		$smsicindurum = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($smsicindurumver = mysql_fetch_array($smsicindurum)){
		$smsicindurumsms	= $smsicindurumver["sms"];
		$sql = "select * from smssablon where id='$smsicindurumsms'";
		$smsmetni = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($smsmetniyaz = mysql_fetch_array($smsmetni)){
		

		?>		
		<input name="sms" type="hidden" value=" <?php echo $smsmetniyaz['sms']; ?>" maxlength="100" style="width:100px">
<?php } } ?>
					</div>
					</div><!-- form-group -->
					<div class="form-group">
					<label class="col-sm-3 control-label">Başlama Tarih/Saat</label>
					<div class="col-sm-4">			
					<input type="text" name="baslama_t" id="sorgu1"  class="form-control" value="<?php echo $girisler['baslama_t']; ?>" placeholder="Tarih Seçin" >
					</div>
					<div class="col-sm-3">
						  
					<input  name="baslama_s"  title="Saat Belirtiniz" type="text" value="<?php echo $girisler['baslama_s']; ?>" class="form-control"  />
				
					</div>


					</div>
					
					<div class="form-group">
					<label class="col-sm-3 control-label">Bitiş Tarih/Saat<span class="asterisk">*</span></label>
					<div class="col-sm-4">			
					<input type="text" name="btarih" id="sorgu2"  class="form-control" value="<?php echo $girisler['BitisTarihi']; ?>" placeholder="Tarih Seçin" >
					</div>
					<div class="col-sm-3">
						  
					<input  name="bitis_s"  title="Saat Belirtiniz" type="text" value="<?php echo $girisler['bitis_s']; ?>" class="form-control"  />
					
					</div>


					</div>
					<div class="form-group">
					<label class="col-sm-3 control-label">Net İşçilik Saati</label>
					<div class="col-sm-3">
						  
					<input  name="iscilik_s"  type="text" value="<?php echo $girisler['iscilik_s']; ?>" class="form-control"  />
					
					</div>
					</div><!-- form-group -->
					
					
					<div class="form-group">
					<label class="col-sm-3 control-label">Teslim Tarih/Saat<span class="asterisk">*</span></label>
					<div class="col-sm-4">			
					<input type="text" name="teslimtarihi" id="sorgu3"  class="form-control" value="<?php echo $girisler['teslimtarihi']; ?>" placeholder="Tarih Seçin" >
					</div>
					<div class="col-sm-3">
						  
					<input  name="teslim_s"  title="Saat Belirtiniz" type="text" value="<?php echo $girisler['teslim_s']; ?>" class="form-control"  />
					
					</div>


					</div>
					
					
					<div class="form-group" style="background:#323D57;">
			<label class="col-sm-3 control-label" style="color:#ffffff; margin-top:10px">Fatura No</label>
			<div class="col-sm-9">
			<input name="faturano" type="text" value="<?php echo $girisler['faturano']; ?>" class="form-control"/> 
			
			</div>
			</div>
					<div class="form-group">
					<label class="col-sm-3 control-label">Servis Notu</label>
					<div class="col-sm-9">
					<span>Servis notunu sadece siz görebilirsiniz herhangi bir yerde gözükmez</span>
					<textarea rows="5" name="dservis" class="form-control" ><?php echo $girisler['DServis']; ?></textarea>
					</div>
					</div><!-- form-group -->
					<hr>
					<div class="form-group">
			<label class="col-sm-3 control-label">Onarım Merkezi</label>
			<div class="col-sm-9">
			<select name="onarimmerkezi" data-placeholder="Onarım Merkezi Seçin" id="select-basic" class="form-control">
		<?php 
		$omerkez	=$girisler['onarimmerkezi'];

		$sqlon = "select * from onarimmerkezi where id='$omerkez'";
		$onarimmerkezia = mysql_query($sqlon, $baglanti) or die(mysql_error());
		while ($onarimmerkezi_ver = mysql_fetch_array($onarimmerkezia)){


		?>

		<option value="<?php echo $onarimmerkezi_ver['id']; ?>"><?php echo $onarimmerkezi_ver['adi']; ?></option>
		<?php } ?>
		<option value=""></option>
		<?php 
		$psqlon2 = "select * from onarimmerkezi order by adi ASC";
		$onarimmerkeziver = mysql_query($psqlon2, $baglanti) or die(mysql_error());
		while ($onarimmerkeziAl = mysql_fetch_array($onarimmerkeziver)){
		$durumned2	=$girisler['onarimmerkezi'];
		

		?>

		<option value="<?php echo $onarimmerkeziAl['id']; ?>"><?php echo $onarimmerkeziAl['adi']; ?></option>
		<?php } ?>
		</select>
			</div>

			</div><!-- form-group -->
			
			<div class="form-group">
					<label class="col-sm-3 control-label">Merkez Gönderim Tarihi</label>
					<div class="input-group mb20" style="padding-left:10px">
					<span class="input-group-addon" ><i class="glyphicon glyphicon-calendar" ></i></span>
					<input type="text" name="merkezgonderimtarihi" value="<?php echo $girisler['merkezgonderimtarihi']; ?>" id="sorgu4" class="form-control" style="width:97%" />
					

					</div>


					</div><!-- form-group -->
			<div class="form-group">
					<label class="col-sm-3 control-label">Merkez Dönüş Tarihi</label>
					<div class="input-group mb20" style="padding-left:10px">
					<span class="input-group-addon" ><i class="glyphicon glyphicon-calendar" ></i></span>
					<input type="text" name="merkezdonustarihi" value="<?php echo $girisler['merkezdonustarihi']; ?>" id="sorgu5" class="form-control" style="width:97%" />
					

					</div>


					</div><!-- form-group -->
				

			<hr>
			<div class="form-group">
			<label class="col-sm-3 control-label">Sorumlu Personel</label>
			<div class="col-sm-9">
			<select name="sorumlupersonel" data-placeholder="Onarım Merkezi Seçin" id="select-basic" class="form-control">
		<?php 
		$sorumlupers	=$girisler['sorumlupersonel'];

		$sqlon = "select * from yonetici where id='$sorumlupers'";
		$sorumlupersa = mysql_query($sqlon, $baglanti) or die(mysql_error());
		while ($sorumlupers_ver = mysql_fetch_array($sorumlupersa)){


		?>

		<option value="<?php echo $sorumlupers_ver['id']; ?>"><?php echo $sorumlupers_ver['adi']; ?></option>
		<?php } ?>
		<option value=""></option>
		<?php 
		$sorumlupers2 = "select * from yonetici order by adi ASC";
		$sorumlupersver = mysql_query($sorumlupers2, $baglanti) or die(mysql_error());
		while ($sorumlupersAl = mysql_fetch_array($sorumlupersver)){
		

		?>

		<option value="<?php echo $sorumlupersAl['id']; ?>"><?php echo $sorumlupersAl['adi']; ?></option>
		<?php } ?>
		</select>
			</div>

			</div><!-- form-group -->
				
			
			
			
			
					    </div><!-- row -->
                                    </div><!-- panel-body -->
                                    <div class="panel-footer">
                                      <div class="row">
                                        <div class="col-sm-9 col-sm-offset-3">
										<div class="ckbox ckbox-success">
				<input type="checkbox" id="checkboxSuccesssms" name="smsle" value="1"  />
				<label for="checkboxSuccesssms">Durumu SMS ile Gönder</label>
				</div>
				<?php if($musterigetir["email"]==""){}else{ ?>
				<div class="ckbox ckbox-success">
				<input type="checkbox" id="checkboxSuccessmail" name="maille" value="1" />
				<label for="checkboxSuccessmail">Durumu E-posta ile Gönder</label>
				</div>
				<?php } ?>
				<br>
                                          <button class="btn btn-primary mr5">Değişiklikleri Kaydet</button>
				
                                        </div>
                                      </div>
                                    </div><!-- panel-footer -->  
                 </form>          
							


							</div><!-- tab-pane işlemler -->

							<div class="tab-pane" id="gorseller">

								<div class="panel-body">
							<form name="yy" METHOD="POST" ACTION="resimyukleser.php?GiT=gorselEkle&id=<?php echo $_GET["G"]?>"  enctype="multipart/form-data" >
							<div class="form-group">
					<h4 style="padding-left:10px; padding-top:0px">Yeni Resim Yükle</h4>
					<div class="input-group mb20" style="padding-left:10px">
					<input name="musterinin" type="hidden"  id="urunadi" size="34" value="<?php echo mysql_Real_escape_string($_GET["GiT"])?>" />
		<input type="file" name="resimx[]" id="resimx[]" multiple="multiple" required class="form-control" style="width:280px; float:left"/>
		
		<button class="btn btn-primary mr5" style="left:10px; height:43px">Yükle</button>

					</div>
					</div><!-- form-group -->
		</form>	
						<hr>
						<h4 style="padding-left:10px; padding-top:0px">Ürün Görselleri</h4>
			
		
						<?php
		$idfr	= mysql_Real_escape_string($_GET["G"]); 

		$islemibitenler = mysql_num_rows(mysql_query("select * from gorseller where musteri='$idfr' "));
		$var	=$islemibitenler;
		if($var=="0"){
		echo" <br><b>Henüz Görsel Yüklenmedi...</b><br> <br>";
		}else{
		?>
		
		<?php

		$ideeee	= mysql_Real_escape_string($_GET["G"]); 


		$sql = "select * from gorseller where musteri='$ideeee'";
		$kurum = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($kurumsal = mysql_fetch_array($kurum)){ 
		?>	

		
		
                             
                                 
                                  
                                  <center>
                                    <a href="yuklenen/resim/<?php echo $kurumsal["resimlink"]; ?>" data-rel="prettyPhoto[urunresim]" rel="prettyPhoto[urunresim]">
                                      <img src="yuklenen/sresim/<?php echo $kurumsal["resimlink"]; ?>" class="img-responsive" alt="" style="max-width:300px"/>
									  <span><a href="resimyukleser.php?islem=silResim&ID=<?php echo $kurumsal["id"];?>&GiT=<?php echo mysql_Real_escape_string($_GET["GiT"])?>&G=<?php echo mysql_Real_escape_string($_GET["G"])?>"><i class="fa fa-trash-o"></i> Resmi SİL</a></span>
                                    </a>
									<hr>
									</center>
                                 
                                  
                                  
                              
                         

		<?php }?>
		
		<?php } ?>
		</div><!-- panel-body kapanışı -->

		<script>
            jQuery(document).ready(function(){
    
                jQuery('.thmb').hover(function() {
                    var t = jQuery(this);
                    t.find('.ckbox').show();
                    t.find('.fm-group').show();
                }, function() {
      
                    var t = jQuery(this);
                    if(!t.closest('.thmb').hasClass('checked')) {
                        t.find('.ckbox').hide();
                        t.find('.fm-group').hide();
                    }
                });
    
                jQuery('.ckbox').each(function(){
                    var t = jQuery(this);
                    var parent = t.parent();
                    if(t.find('input').is(':checked')) {
                        t.show();
                        parent.find('.fm-group').show();
                        parent.addClass('checked');
                    }
                });
    
    
                jQuery('.ckbox').click(function(){
                    var t = jQuery(this);
                    if(!t.find('input').is(':checked')) {
                        t.closest('.thmb').removeClass('checked');
                        enable_itemopt(false);
                    } else {
                        t.closest('.thmb').addClass('checked');
                        enable_itemopt(true);
                    }
                });
    
                jQuery('#selectAll').click(function() {
                    if(jQuery(this).hasClass('btn-default')) {
                        jQuery('.thmb').each(function() {
                            jQuery(this).find('input').attr('checked',true);
                            jQuery(this).addClass('checked');
                            jQuery(this).find('.ckbox, .fm-group').show();
                        });
                        enable_itemopt(true);
                        jQuery(this).removeClass('btn-default').addClass('btn-primary');
                        jQuery(this).text('Select None');
                    } else {
                        jQuery('.thmb').each(function(){
                            jQuery(this).find('input').attr('checked',false);
                            jQuery(this).removeClass('checked');
                            jQuery(this).find('.ckbox, .fm-group').hide();
                        });
                        enable_itemopt(false);
                        jQuery(this).removeClass('btn-primary').addClass('btn-default');
                        jQuery(this).text('Select All');
                    }
                });
    
                function enable_itemopt(enable) {
                    if(enable) {
                        jQuery('.media-options .btn.disabled').removeClass('disabled').addClass('enabled');
                    } else {
        
                        // check all thumbs if no remaining checks
                        // before we can disabled the options
                        var ch = false;
                        jQuery('.thmb').each(function(){
                            if(jQuery(this).hasClass('checked'))
                                ch = true;
                        });
        
                        if(!ch)
                            jQuery('.media-options .btn.enabled').removeClass('enabled').addClass('disabled');
                    }
                }
    
                jQuery("a[data-rel^='prettyPhoto']").prettyPhoto();
    
            });
        </script>
		
	

		</div><!-- tab-pane gorseller kapanışı -->

							
								<div class="tab-pane" id="gorusme">
								<div class="row">
								
								<h4 style="padding-left:10px">Görüşme Kayıtları</h4>
								<hr>
								<?php
								$gorusmeid	= mysql_Real_escape_string($_GET["G"]); 

								$gorusmevarmi = mysql_num_rows(mysql_query("select * from gorusmeler where girisid='$gorusmeid' "));
								$var	=$gorusmevarmi;
								if($var=="0"){
								echo' <center><p><strong class="subject">Kayıtlı görüşme notunuz bulunmuyor.</strong></p></center>';
								}else{
								?>
								<ul class="media-list msg-list">
								<?php 
								$gorusmeid	= mysql_Real_escape_string($_GET["G"]);
								$sql = "select * from gorusmeler where girisid='$gorusmeid'";
								$gorusmelersql = mysql_query($sql, $baglanti) or die(mysql_error());
								while ($gorusmeisle = mysql_fetch_array($gorusmelersql)){ 
								?>
								<li class="media unread">
                                       
                                       
                                        <div class="media-body">
                                            <div class="pull-right media-option">
                                            
                                                <small></small>
                                              
                                                <div class="btn-group">
                                                    <a class="btn btn-default dropdown-toggle" data-toggle="dropdown">
                                                        <i class="fa fa-cog"></i>
                                                    </a>
                                                    <ul class="dropdown-menu pull-right" role="menu">
                                                        
                                                       
                                                      
                                                        <li><a href="ServisDuzen.php?GiT=<?php echo $_GET["GiT"]?>&G=<?php echo $_GET["G"]?>&islem=gorusmeSil&ID=<?php echo $gorusmeisle['id']; ?>">Sil</a></li>
                                                       
                                                    </ul>
                                                </div>
                                            </div>
                                           <h5> <?php echo $gorusmeisle['tarih']; ?></h5>
                                            <p><strong class="subject"><?php echo $gorusmeisle['metin']; ?></strong></p>
                                        </div>
                                    </li>
									<li></li>
								<?php } ?>
								
                                    
                                 
                                </ul>
								<?php } ?>
								<hr>
								<form id="basicForm" method="post" action="ServisDuzen.php?GiT=<?php echo $_GET["GiT"]?>&G=<?php echo $_GET["G"]?>&islem=gorusmeEkle">
								
								<h4 style="padding-left:10px">Yeni Görüşme Ekle</h4>
								<hr>
								
								<div class="form-group">
								<label class="col-sm-3 control-label">Tarih</label>
								<div class="col-sm-9">
								<input type="text" name="gorusmetarih" value="<?php
								date_default_timezone_set("Europe/Istanbul");
								$bugun	=date("d.m.Y. H:i:s"); echo $bugun;?>" class="form-control" style="width:97%" required />
								<input type="hidden" name="gorusmegirisid" value="<?php echo $_GET["G"]?>" class="form-control" style="width:97%" />
								</div>
								</div><!-- form-group -->

								
								
								
								<textarea rows="3" id="wysiwyg2" name="gorusmenot" class="form-control" required ></textarea>
								<hr>
								
								
                               <button class="btn btn-primary mr5">Kaydet</button>
                                          
                                 
								</form>
								
								</div>
								


								</div><!-- tab-pane -->	
								</div>
						</div><!-- tab-content mb30 -->
<!--işlem ve görseller bitti -->                  
                            

                                   
                                    
                                   

	
	<div class="col-md-6">
                              
                                 <!-- Nav tabs -->
                                <ul class="nav nav-tabs">
                                    <li class="active"><a href="#sms" data-toggle="tab"><strong>SMS Gönder</strong></a></li>
									<li><a href="#smsgecmis" data-toggle="tab"><strong>SMS Geçmişi</strong></a></li>
                                    <li><a href="#eposta" data-toggle="tab"><strong>E-posta Gönder</strong></a></li>
									
                                    
                                </ul>
        
                                <!-- Tab panes -->
                                <div class="tab-content mb30">
                                    <div class="tab-pane active" id="sms">
                                    <?php
								$mid	= mysql_Real_escape_string($_GET["GiT"]); 
								$sql = "select * from musteriler where id='$mid'";
								$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
								while ($musterigetir = mysql_fetch_array($musteri)){ 

								?>    
								<script type="text/javascript" src="js/jquery-latest.min.js"></script>
								<form  method="post" action="ServisDuzen.php?GiT=<?php echo $_GET["GiT"];?>&G=<?php echo $_GET["G"];?>&mnsms=gondersms" class="form_container left_label">
								<textarea id="smsfor" rows="5" name="sms" class="form-control smsfor" required></textarea>
								
								<input  name="tel" type="hidden" value="<?php echo $musterigetir["Tel"];?>" maxlength="100" class="large" >
								<input  name="musteri" type="hidden" value="<?php echo $musterigetir["ID"];?>" maxlength="100" class="large" >
								<input  name="giris" type="hidden" value="<?php echo $_GET["G"];?>" maxlength="100" class="large" >
								
								</pre>
								<br>
								<button class="btn btn-primary mr5">SMS Gönder</button>
								</form>
								<hr>
								<div>SMS Sayısı:&nbsp :<span class="adet" ><span class="badge">1</span></span></div>
								<div>Karakter Sayısı:&nbsp<span class="say" >0</span></div>

<script type="text/javascript">
$(function(){
var say = 0; 
var sinir = 480; 
$('.smsfor').bind('keydown keyup keypress change',function(){
if($(this).val().length > sinir) $(this).val($(this).val().substring(0,sinir));
var thisValueLength = $(this).val().length;
var saymax = (say)+(thisValueLength); 
$('.say').html(saymax);

if(saymax < 160){ 
$('.say').css({color:'#ff0000',fontWeight:'bold'});
$('.adet').html("<span class='badge'>1</span>");

}
else if(saymax > 160){ 
$('.say').css({color:'#ff0000',fontWeight:'bold'});
$('.adet').html("<span class='badge badge-warning'>2</span>");

} 		

if(saymax > 320){ 
$('.say').css({color:'#ff0000',fontWeight:'bold'});
$('.adet').html("<span class='badge badge-danger'>3</span>");

} 
if(saymax == 480){ 
$('.adet').css({color:'#ff0000'});
$('.adet').html("Maximum karakter sayısına ulaştınız. <span class='badge badge-danger'>3</span> sms gönderilecek");

} 

else { 
$('.say').css({color:'#000000',fontWeight:'bold'});

}
});
$(window).load(function(){
$('.say').html(say); // .say class yapısının olduğu yere yazdır
$('.adet').html(adet); 
});
});</script>
<?php } ?>
                                    </div><!-- tab-pane -->
									 <div class="tab-pane" id="smsgecmis">
									 
									  
									
                                      
                                        <div class="row">
                                        <div class="form-group">
                                        <table id="basicTable" class="table table-striped table-bordered responsive">
                                <thead class="">
                                    <tr>
                                        <th>ID </th>
										<th>Tarih </th>
										<th>SMS İçeriği </th>
		
                                        
                                    </tr>
                                </thead>
                         
                                <tbody>
								<?php 
		$idin	= mysql_Real_escape_string($_GET["GiT"]);
		$sql = "select * from sms Where musteri='$idin' order by id desc";
		$giris = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($girisler = mysql_fetch_array($giris)){ 

		?>

		<tr>
		<td><?php echo $girisler['id']; ?></td>
		<td><?php echo $girisler['tarih']; ?></td>
		<td><?php echo $girisler['sms']; ?></td>
		</tr>
		<?php }  ?> 
                                </tbody>
                            </table>
								</div>
								</div>
							
							
                                    </div><!-- tab-pane -->
                                  
                                    <div class="tab-pane" id="eposta">
									<form  method="post" action="ServisDuzen.php?GiT=<?php echo $_GET["GiT"];?>&G=<?php echo $_GET["G"];?>&epostala=emailposta" class="form_container left_label">
									<?php 
									$idin	= mysql_Real_escape_string($_GET["GiT"]);
									$sql = "select * from musteriler Where id='$idin' ";
									$maillgonder = mysql_query($sql, $baglanti) or die(mysql_error());
									while ($maillgonderr = mysql_fetch_array($maillgonder)){ 

									?>
                                       <?php if($maillgonderr["email"]==""){ ?>
									   <b>Öncelikle <?php echo $maillgonderr["Ad_Soyad"];?> için müşteri profilinden mail adresi eklemelisiniz.</b>
									   <?php }else{ ?> 
									   <div class="panel-body">
                                    <textarea id="wysiwyg" name="posta" class="form-control" rows="10" required >Sayın <b><?php echo $maillgonderr["Ad_Soyad"];?></b><br></textarea>
									<input  name="email" type="hidden" value="<?php echo $maillgonderr["email"];?>">
									<input  name="musteri" type="hidden" value="<?php echo $maillgonderr["Ad_Soyad"];?>">
									<input  name="giris" type="hidden" value="<?php echo $_GET["G"];?>">

									   </pre>
									   <br>
								<button class="btn btn-primary mr5">E-posta Gönder</button>
								</div>
								 
								<?php } // else kapanışı ?>
								<?php } // while maillgonderr kapanışı ?>
								<hr>
								</form>
                                    </div><!-- tab-pane eposta -->
                                  
                                    
                                </div><!-- tab-content -->
                                </div><!-- panel -->
                            
                                
                      
							<!--müşteri notu bitti -->
                            
						
		
		<iframe name="azfis"  style="height:1px; width:1px; z-index:99999999999" scrolling="no"  id="azfis" frameborder="0" marginheight="0" marginwidth="0"></iframe>									
</div><!-- İşlem Ve detaylar Bitti -->

<!-- Parça Modülü Başla -->
<div class="tab-pane" id="parcamodultab">

 <iframe  src="parcamodul.php?G=<?php echo $_GET["G"]; ?>&sahip=<?php echo $_SESSION["kulid"]; ?>&durum=<?php echo $_SESSION["durum"]; ?>&depo=<?php echo $_SESSION["depo"]; ?>"  style="height:800px; width:100%;" frameborder="0" marginheight="0" marginwidth="0"></iframe>

</div><!-- Parça Modülü Biti-->
<!-- Yedek Tab Başla -->
<div class="tab-pane" id="yedektap">

</div><!-- Yedek Tab Bitti -->


</div><!-- tab-content -->


					
</div>
</div>
<?php } // girisler while döngüsü kapanışı (801. satır) ?>
<?php } // musterigetir while döngüsü kapanışı (785. satır) ?>
Directory Contents

Dirs: 4 × Files: 37
Sort:
Enable drag-to-move
Name	Size	Perms	Modified	Actions
kimlik DIR	-	drwxr-xr-x	2022-08-10 21:02:56	Edit Download recursive recursive
logo DIR	-	drwxr-xr-x	2022-08-10 21:02:56	Edit Download recursive recursive
profil DIR	-	drwxr-xr-x	2022-08-10 21:02:56	Edit Download recursive recursive
scopbin DIR	-	drwxr-xr-x	2022-08-10 21:02:56	Edit Download recursive recursive
api.php	7.18 KB	lrw-r--r--	2025-11-13 11:09:06	Edit Download recursive recursive
ayarlar.php	7.45 KB	lrw-r--r--	2025-11-14 06:36:36	Edit Download recursive recursive
bakiye.php	2.62 KB	lrw-r--r--	2025-11-14 06:45:44	Edit Download recursive recursive
cinsi.php	7.46 KB	lrw-r--r--	2025-11-13 13:10:30	Edit Download recursive recursive
defter_kat.php	7.81 KB	lrw-r--r--	2025-11-13 14:24:40	Edit Download recursive recursive
depo.php	7.56 KB	lrw-r--r--	2025-11-13 14:41:24	Edit Download recursive recursive
depo_analiz.php	9.51 KB	lrw-r--r--	2025-11-13 14:41:24	Edit Download recursive recursive
ekipman.php	7.33 KB	lrw-r--r--	2025-11-13 13:10:30	Edit Download recursive recursive
firma.php	6.76 KB	lrw-r--r--	2025-11-13 06:52:38	Edit Download recursive recursive
fonksiyon.php	1.23 KB	lrw-r--r--	2025-11-13 06:52:38	Edit Download recursive recursive
hatirlatmalar.php	11.55 KB	lrw-r--r--	2025-11-13 13:19:20	Edit Download recursive recursive
hatirlatma_duzen.php	14.60 KB	lrw-r--r--	2025-11-14 08:05:30	Edit Download recursive recursive
hedef_tanim.php	7.67 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
kimlikyukle.php	3.34 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
Logger.php	12.90 KB	lrw-r--r--	2025-11-13 13:23:40	Edit Download recursive recursive
logoyukle.php	2.40 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
marka.php	7.59 KB	lrw-r--r--	2025-11-13 13:10:30	Edit Download recursive recursive
onarimmerkezi.php	7.53 KB	lrw-r--r--	2025-11-13 13:05:12	Edit Download recursive recursive
parca.php	8.18 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
profilyukle.php	2.52 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
profil_resmim.php	2.51 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
renk.php	7.37 KB	lrw-r--r--	2025-11-13 14:52:58	Edit Download recursive recursive
serinoekle.php	8.34 KB	lrw-r--r--	2025-11-13 14:52:04	Edit Download recursive recursive
servisdurum.php	11.39 KB	lrw-r--r--	2025-11-14 07:11:36	Edit Download recursive recursive
ServisDuzen.php	72.47 KB	lrw-r--r--	2025-11-14 06:45:44	Edit Download recursive recursive
ServisDuzenpersonel.php	58.57 KB	lrw-r--r--	2025-11-14 08:00:22	Edit Download recursive recursive
servisekle.php	23.42 KB	lrw-r--r--	2025-11-14 06:45:44	Edit Download recursive recursive
servisgiris.php	6.82 KB	lrw-r--r--	2025-11-14 07:11:36	Edit Download recursive recursive
SessionManager.php	10.14 KB	lrw-r--r--	2025-11-14 08:02:42	Edit Download recursive recursive
session_helper.php	3.12 KB	lrw-r--r--	2025-11-14 05:43:34	Edit Download recursive recursive
simpleimage.php	3.71 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
sirala.php	504 B	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
sms.php	8.98 KB	lrw-r--r--	2025-11-13 06:52:38	Edit Download recursive recursive
sms_rapor.php	1.17 KB	lrw-r--r--	2025-11-14 06:45:44	Edit Download recursive recursive
stokguruplari.php	7.83 KB	lrw-r--r--	2025-11-13 14:52:04	Edit Download recursive recursive
yoneticiler.php	23.08 KB	lrw-r--r--	2025-11-14 05:00:16	Edit Download recursive recursive
yonetici_duzen.php	29.01 KB	lrw-r--r--	2025-11-14 05:07:12	Edit Download recursive recursive