HEX
Server: Apache
System: Linux srv4.garantili.com.tr 4.18.0-477.21.1.lve.1.el8.x86_64 #1 SMP Tue Sep 5 23:08:35 UTC 2023 x86_64
User: yenicep (1023)
PHP: 7.4.33
Disabled: exec,passthru,shell_exec,system
Upload Files
File: /home2/yenicep/www/kasko.php
<? include 'header.php'; 
 
?>

<? 

if(!p('sigorta_bedeli')){
    header("location: urunlerimiz");die();
}

if(p('imeisorgula')==1){ 
    
    $marka=p('marka');
    $model=p('model');
    $hafiza=p('hafiza');
    $imei=p('imei');
     $telefon_yas=p('telefon_yas');
    
  
    $s = "select * from a_satis_fiyatlandirma_sabitleri limit 1";
    $q = $func->query($s);
    $rs= $q->fetch(); 
    
     
    
     $tutar_dolar=p('sigorta_bedeli');
     $tutar=$tutar_dolar*$func->gunceldolarkurgetir('dolar');

 
        $sorgusonuc=1;
       
} 

if(p('kayit_olustur')==1){
  
    $telefon_yas=p('telefon_yas');
    $takip_no=$func->takip_no();
    $tarih=gunceltarihsaat();
 
        
         $tutar= p('sigorta_bedeli')*$func->gunceldolarkurgetir('dolar');
    
    
    if(p('sigorta_bedeli')==55){
       $odenecek_tutar=55; 
       
    $virtual=1.56;
    $helmet=1.56;
    $garantili=1.56;
    $tamir_organizasyonu=0;
    $ekspar=0.94;
    $satis_yonetimi=1.87;
    $sanal_kanal=7.50;
    
    
    }elseif(p('sigorta_bedeli')==124){
    $odenecek_tutar=124; 
         
    $virtual=3.44;
    $helmet=3.44; 
    $garantili=3.44;
    $tamir_organizasyonu=0;
    $ekspar=2.07;
    $satis_yonetimi=4.12;
    $sanal_kanal=16.5;
    
    }elseif(p('sigorta_bedeli')==196){
    
    $odenecek_tutar=196;  
        
    $virtual=5.42;
    $helmet=5.42;
    $garantili=5.42;
    $tamir_organizasyonu=0;
    $ekspar=3.26;
    $satis_yonetimi=6.5;
    $sanal_kanal=26;
    
    
    }elseif(p('sigorta_bedeli')==259){
    
    $odenecek_tutar=259; 
        
    $virtual=7.19;
    $helmet=7.19;
    $garantili=7.19;
    $tamir_organizasyonu=0;
    $ekspar=4.32;
    $satis_yonetimi=8.62;
    $sanal_kanal=34.49;
    
    
    }elseif($tutar>=2001 and $tutar<=2500){
    
    $odenecek_tutar=327; 
        
    $virtual=9.06;
    $helmet=9.06;
    $garantili=9.06;
    $tamir_organizasyonu=0;
    $ekspar=5.45;
    $satis_yonetimi=10.87;
    $sanal_kanal=43.49;
    
    
    }elseif(p('sigorta_bedeli')==385){
    
    $odenecek_tutar=383; 
        
    $virtual=10.62;
    $helmet=10.62;
    $garantili=10.62;
    $tamir_organizasyonu=0;
    $ekspar=6.39;
    $satis_yonetimi=12.75;
    $sanal_kanal=50.99;
    
    
    }elseif(p('sigorta_bedeli')==436){
    
    $odenecek_tutar=436; 
    
    $virtual=12.08;
    $helmet=12.08;
    $garantili=12.08;
    $tamir_organizasyonu=0;
    $ekspar=7.27;
    $satis_yonetimi=14.49;
    $sanal_kanal=57.99;
        
    }
    
    
    $tutar= p('sigorta_bedeli')*$func->gunceldolarkurgetir('dolar');
    
    
     $virtual=$virtual*$func->gunceldolarkurgetir('dolar');
     $helmet= $helmet*$func->gunceldolarkurgetir('dolar');
     $garantili=$garantili*$func->gunceldolarkurgetir('dolar');
     $tamir_organizasyonu=$tamir_organizasyonu*$func->gunceldolarkurgetir('dolar');
     $ekspar=$ekspar*$func->gunceldolarkurgetir('dolar');
     $satis_yonetimi=$satis_yonetimi*$func->gunceldolarkurgetir('dolar');
     $sanal_kanal=$sanal_kanal*$func->gunceldolarkurgetir('dolar');
    
    
     
      $tutar=$odenecek_tutar ;
 
 
   $func->query("INSERT INTO `kaskolu_cihazlar`(`dolar_kur`,`cihaz_satis_fiyati`,`bayi_id`,`telefon_yas`,`virtual`,`helmet`,`garantili`, `tamir_organizasyonu`, `ekspar` , `satis_yonetimi`, `sanal_kanal`,`bayi`,`kasko_takipno`, `baslangic_tarih`, `tutar`, `tutar_dolar`, `cihaz_turu`, `marka`, `model`, `hafiza`, `imei`, `m_ad`, `m_soyad`, `m_gsm`, `m_eposta`, `m_tc`, `durum`, `bayi_text`, `mst_odeme_yapti`, `odeme_tarih`,  `MSCnsTp`,`MSDogYL`,`OzelTuzel`,`Adres`,`Cadde`,`Sokak`,`Semt`,`BinaNo`,`HanApartmanAd`,`Daire`,`KoyMahalle`,`PostaKod`  ,`Ilce`  ,`IlKod` ,`Kat`, `m_pasaportno` , `basTar` , `bitTar`, `TaksitSekli` , `teminatTutar`) 
    
    
    VALUES (
        
       '".$func->gunceldolarkurgetir('dolar')."','".$tutar."','".p('bayi')."', '$telefon_yas','$virtual','$helmet','$garantili','$tamir_organizasyonu','$ekspar','$satis_yonetimi','$sanal_kanal','".$func->policebayigetir(p('bayi'))."','".$takip_no."', '".$tarih."', '$tutar', '$tutar_dolar','1','".p('marka')."', '".p('model')."', '".p('hafiza')."',  '".p('imei')."', '".p('m_ad')."' , '".p('m_soyad')."',  '".p('m_gsm')."'  ,  '".p('m_eposta')."' , '".p('m_tc')."' ,  '1' ,   '".$uye_id."' ,  '".p('mst_odeme_yapti')."' ,  '".p('odeme_tarih')."' ,  '".p('MSCnsTp')."',   '".p('MSDogYL')."',  '".p('OzelTuzel')."',  '".p('adres')."' , '".p('cadde')."',  '".p('sokak')."' ,  '".p('semt')."' , '".p('binaNo')."'  ,  '".p('aptAdi')."'  ,   '".p('daire')."'  ,   '".p('mahalle')."'  ,   '".p('postaKodu')."'  ,  '".p('ilce')."' ,  '".p('ilKod')."'  ,  '".p('kat')."' ,  '".p('m_pasaportno')."'   ,  '".date('Y-m-d')."'  ,  '".date("Ymd", strtotime(date('Y-m-d') . '+1 years'))."' ,  '".p('TaksitSekli')."'  ,  '".$tutar."'  )");
   
     $kasko_id  = $func->db->lastInsertId();  
    
    
   	$return=$func->hdi_insert($kasko_id);
 
	
   if($return==1){
    
      $s = "select * from kaskolu_cihazlar where id='$kasko_id'";
    $q = $func->query($s);
    $kasko= $q->fetch();
    
    
    $odeme=1;
    $sorgusonuc=3;
    
       
    }elseif($return==2){
        
        $s = "select * from kaskolu_cihazlar where id='$kasko_id'";
        $q = $func->query($s);
        $kasko= $q->fetch();
    
    
        $mesaj=$kasko->hdi_DurumAciklama;
        $mesaj=$mesaj."HDI ile iletişime geçin";
        $sorgusonuc=4;
        
    } 
}

if(p('odeme_yonlendir')==1){
    
        $s = "select * from kaskolu_cihazlar where id='".p('kasko_id')."'";
        $q = $func->query($s);
        $rs= $q->fetch();
        
        if($rs->id){
            echo var_dump($func->mobilexpressodeme($rs->id));
        }
}



?>	
  

		<section>
			
			<!-- Container -->
			    <div class="container">
			        <form action="" method="POST">
				    <div class="row">
                        <div class="col-sm-12">  
                                        <h5>Akıllı Telefon Formu</h5>
                                        <p>Aşağıdaki bilgileri doldurarak Akıllı Telefon Sigortası teklifini hızlıca ve güvenle alabilirsiniz!</p>
                                        <hr>
                                    </div>
                    </div>
                    <? //if($odeme!=1){?> 
                    <div class="row">
                        <div class="col-lg-2 col-sm-12" style="padding:20px 5px;">
                             <input type="text" name="imei" value="<?=p('imei')?>" class="medium-input bg-white margin-25px-bottom required"  placeholder="IMEI numarasını yazın" onkeypress="return event.charCode >= 48 && event.charCode <= 57"  required>
                               
                                   
                        </div>
                        <div class="col-lg-2 col-sm-12" style="padding:20px 5px;">
                            <select class="medium-input bg-white margin-25px-bottom required" data-dropdown-css-class="select2-danger" style="width: 100%;" data-select2-id="12" tabindex="-1" aria-hidden="true" name="marka" id="marka" required>
								<option disabled selected value style="display:none">Marka</option>
								<? if(!$marka){ $marka=0; }?>
									<?php
									$query1 = $func->query("select * from markalar where tur=1 and aktif=1 order by marka ASC");
									$rows1 = $query1->fetchAll();
									foreach($rows1 as $markas){ ?>
									<option   value="<?=$markas->id;?>" <? if($marka==$markas->id or $kasko->marka==$markas->id){ echo "selected"; }?>>
									<?=$markas->marka;?> 	  
									</option>
							    <?}?>
							</select>
                        </div>
                        <div class="col-lg-2 col-sm-12" style="padding:20px 5px;">
                            <select class="medium-input bg-white margin-25px-bottom required"  data-dropdown-css-class="select2-danger" style="width: 100%;" data-select2-id="12" tabindex="-1" aria-hidden="true" name="model" id="model" required>
							    <option disabled selected value style="display:none">Model</option>
									<?php
									$query1 = $func->query("select * from modeller where cihaz_turu=1 and aktif=1 order by model ASC");
									$rows1 = $query1->fetchAll();
									foreach($rows1 as $models){ ?>
									<option  data-chained="<?=$models->marka_id;?>" value="<?=$models->id;?>" <? if($model==$models->id or $kasko->model==$models->id){ echo "selected"; }?>>
									<?=$models->model;?> 	  
									</option>
							    <?}?>
							</select>     
                        </div>
                        <div class="col-lg-2 col-sm-12" style="padding:20px 5px;">
                            <select class="medium-input bg-white margin-25px-bottom required" name="hafiza" id="hafiza" required>
							    <option disabled selected value style="display:none">Hafıza</option> 
									<?
									$query1 = $func->query("select * from hafiza where id!=8 order by id ASC");
									$rows1 = $query1->fetchAll();
									foreach($rows1 as $hafizas){ ?>
									<option value="<?=$hafizas->id;?>" <? if($hafiza==$hafizas->id or $kasko->hafiza==$hafizas->id){ echo "selected"; }?>>
									<?=$hafizas->hafiza;?> <?=$hafizas->tip;?> 	  
									</option>
							    <?}?>
							</select>     
                        </div>
                        <div class="col-lg-2 col-sm-12" style="padding:20px 5px;">
                            <select class="medium-input bg-white margin-25px-bottom required" name="telefon_yas" id="telefon_yas" required>
							    <option disabled selected value style="display:none">Cihaz Yaş</option> 
									<?
								 
									for($i=1;$i<=5;$i++){ ?>
									<option value="<?=$i;?>" <? if($telefon_yas==$i or $kasko->telefon_yas==$i){ echo "selected"; }?>>
									<?=$i?>	  
									</option>
							    <?}?>
							</select>     
                        </div>
                        <div class="col-sm-2">
                            <input type="hidden" name="imeisorgula" value="1">
                            <input type="hidden" name="sigorta_bedeli" value="<?=p('sigorta_bedeli')?>">
                            <button type="submit" id="contact-submit" name="send" class="align-self-center align-self-md-start btn btn-fancy btn-round-edge-small btn-large btn-gradient-garantili margin-1-half-rem-top">Sorgula</button>
                        </div>  
                    </div>      
                    <?//}?>
			    </form>
			    
			    
			<? if($sorgusonuc==1 and $rs->id){?>
			 <form  method="post" action="">
			        <div class="row">
			            <div class="col-md-12 col-lg-12 col-sm-12">
			            <div class="panel-body">
			             <div class="panel panel-default">
                            <div class="panel-heading">
                            <h6 class="panel-title" style="padding:35px 0;">CİHAZ BİLGİLERİ</h6>
                            </div>
                        </div>
    			            <table style="table-layout: fixed;width: 100%;" class="responsive table table-bordered">
    			                <tr style="font-weight:bold">
    			                    <th>MARKA</th>
    			                    <th>MODEL</th>
    			                    <th>HAFIZA</th>
    			                    <th>IMEI</th>
    			                     <th>CIHAZ YAS</th>
    			                    <th>TEKLİF</th>
    			                </tr>
    			                <tr>
    			                    <td><?=$func->markagetir($marka)?></td>
    			                    <td> <?=$func->modelgetir($model)?> </td>
    			                    <td><?=$func->hafizagetir($hafiza)?> <?=$func->hafizaturgetir($hafiza)?> </td>
    			                    <td>#<?=$imei?></td>
    			                    <td>#<?=$telefon_yas?></td>
    			                    <td><?=dolarfiyat($tutar_dolar)?></td>
    			                </tr>
    			            </table>
			            </div>
			        </div>
			        
			            <div class="col-md-12 col-lg-12 col-sm-12">
                            <div class="panel panel-default">
                                <div class="panel-heading">
                                    <h6 class="panel-title" style="padding:25px 0;">KİŞİSEL BİLGİLER</h6>
                                </div>
                            </div>
                        </div>
                            
    			        <div class="col-md-6 col-lg-6 col-sm-12">
                             
                            <div class="panel-body">
                                
                                <div class="form-group">
                                    <label for="cardNumber">Ad</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  placeholder="Ad"  name="m_ad" required/>
                                </div>
                                <div class="form-group">
                                    <label for="cardNumber">Soyad</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  placeholder="Soyad"  name="m_soyad" required/>
                                </div>
                                
                                 
                                 <div class="form-group">
                                    <label for="cardNumber">Telefon</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  placeholder="Telefon"  name="m_gsm" required/>
                                </div>
                                <div class="form-group">
                                    <label for="cardNumber">Eposta</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  placeholder="Eposta"  name="m_eposta" required/>
                                </div>
                            
                              
                                        
                                        
                                                    
                                                    <input type="hidden" name="TaksitSekli" value="1">
                                                     
                                </div>
                                    
                                  
                            </div>
    			        
    			        <div class="col-md-6 col-lg-6 col-sm-12"> 
                                <div class="payment-content"> 
                                <div class="form-group">
                                    <label for="cardNumber" style="display:none">Adres</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  value="." hidden placeholder="Adres"  name="adres" required/>
                                </div>
                                
                                <div class="form-group">
                                    <label for="cardNumber" style="display:none">Semt</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  value="." hidden placeholder="Semt"  name="semt" required/>
                                </div>
                                
                                <div class="row">
                                        <div class="col-12 col-lg-6 col-md-6"> 
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Cadde</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required" value="." hidden  placeholder="Cadde"  name="cadde" required/>
                                            </div>
                                        </div>
                                        <div class="col-12 col-lg-6 col-md-6">           
                                            
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Sokak</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required" value="." hidden  placeholder="sokak"  name="sokak" required/>
                                            </div>
                                        </div>
                                </div>
                                
                                <div class="row">
                                        <div class="col-12 col-lg-6 col-md-6"> 
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Mahalle</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required" value="." hidden  placeholder="Mahalle"  name="mahalle" required/>
                                            </div> 
                                        </div>
                                        <div class="col-12 col-lg-6 col-md-6">       
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Apartman Adı</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required" value="." hidden  placeholder="Apartman Adı"  name="aptAdi" required/>
                                            </div>
                                        </div>
                                </div>
                                
                                <div class="row">
                                        <div class="col-12 col-lg-6 col-md-6"> 
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Bina No</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required" value="." hidden  placeholder="Bina No"  name="binaNo" required/>
                                            </div>
                                        </div>
                                        <div class="col-12 col-lg-6 col-md-6">  
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Daire</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required"  value="." hidden placeholder="Daire"  name="daire" required/>
                                            </div>
                                        </div>
                                </div>
                                  
                                <div class="row">
                                        <div class="col-12 col-lg-6 col-md-6"> 
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Kat</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required"  value="." hidden placeholder="Kat"  name="kat" required/>
                                            </div>
                                            </div>
                                            <div class="col-12 col-lg-6 col-md-6"> 
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Posta Kodu</label>
                                                    <input type="text" class="medium-input bg-white margin-25px-bottom required" value="." hidden  placeholder="Posta Kodu"  name="postaKodu" required/>
                                            </div>
                                        </div>
                                </div>
                                  <div class="row">
                                        <div class="col-12 col-lg-4 col-md-4">
                                            <div class="form-group">
                                                <label for="cardNumber">İl</label>
                                                   <select class="medium-input bg-white margin-25px-bottom required" name="ilKod" id="il">
                                                    <option value="" disabled selected>Seçiniz</option>
                                                    <?php
                                                        					$query1 = $func->query("select * from il order by il ASC");
                                                        					$rows1 = $query1->fetchAll();
                                                        					foreach($rows1 as $il){?>
                                                        					<option  value="<?=$il->id;?>">
                                                        					<?=$il->il;?> 	  
                                                        					</option>
                                                    <?}?>
                                                    </select>  
                                            </div>
                                        </div>
                                        <div class="col-12 col-lg-4 col-md-4"> 
                                            <div class="form-group">
                                                <label for="cardNumber">İlçe</label>
                                                                        <select class="medium-input bg-white margin-25px-bottom required"  name="ilce" id="ilce">
                                                                            <option>İlçe</option>
                                                                            <?php
                                                        					$query1 = $func->query("select * from ilce order by ilce ASC");
                                                        					$rows1 = $query1->fetchAll();
                                                        					foreach($rows1 as $ilce){?>
                                                        					<option <?=$bn1?> data-chained="<?=$ilce->il;?>" value="<?=$ilce->id;?>">
                                                        					<?=$ilce->ilce;?> 	  
                                                        					</option>
                                                        					<?}?>
                                                                        </select>
                                            </div> 
                                        </div>
                                        <div class="col-12 col-lg-4 col-md-4"> 
                                        <div class="form-group">
                                                <label for="cardNumber">Özel Tuzel</label>
                                                    
                                                    <select name="OzelTuzel" class="medium-input bg-white margin-25px-bottom required"  required>
                                                        <option value="" selected Disabled>Seçiniz</option>
                                                        
                                                        <option value="O">Özel</option>
                                                        <option value="T">Tüzel</option>  
                                                    </select>
                                            </div>
                                        </div>
                                        
                                        </div>
                                        
                                        
                                        
                                            <div class="row">
                                    <div class="col-12 col-lg-6 col-md-6"> 
                                            <div class="form-group">
                                                <label for="cardNumber">Uyruk</label>
                                                    <select name="uyruk"  id="uyruk" class="medium-input bg-white margin-25px-bottom required" required>
                                                        <option value="" selected Disabled>Seçiniz</option>
                                                        <option value="0">T.C. vatandaşı</option>
                                                        <option value="1">Yabancı</option>
                                                    </select>
                                            </div>
                                        </div>
                                        <div class="col-12 col-lg-6 col-md-6"> 
                                            <div class="form-group">
                                                <label for="cardNumber">Doğum Yılı</label>
                                                    
                                                     <input type="date" name="MSDogYL" class="medium-input bg-white margin-25px-bottom required" required>
                                                        
                                            </div>
                                        </div>
                                    </div>
                                
                                        
                                            <div class="form-group">
                                                <label for="cardNumber" style="display:none">Cinsiyet</label>
                                                    <select name="MSCnsTp" class="medium-input bg-white margin-25px-bottom required" hidden required>
                                                       <option value=""  Disabled>Seçiniz</option>
                                                       <option value="K">Kadın</option>
                                                       <option value="E" selected>Erkek</option>
                                                    </select>
                                                     
                                            </div>
                                        
                                
                                <div class="form-group"  id='m_tc' style="display:none">
                                    <label for="cardNumber">TC Kimlik No</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  placeholder="TC Kimlik No" maxlength="11" minlength="11" name="m_tc" id="m_tc"  />
                                </div>
                                
                                <div class="form-group"  id='m_pasaportno' style="display:none">
                                    <label for="cardNumber">Pasaport No</label>
                                        <input type="text" class="medium-input bg-white margin-25px-bottom required"  placeholder="Pasaport No" maxlength="15" minlength="15"  name="m_pasaportno" id="m_pasaportno"  />
                                </div>
                                 
                                 
                                 
                                <div class="row">
                                        <div class="col-12 col-lg-12 col-md-12"> 
                                            <div class="form-group">
                                                <label for="cardNumber" >Bayi&Firma</label>
                                                
                                                <select class="medium-input bg-white margin-25px-bottom "  name="bayi" required>
                                                    <option>Bayi</option> 
                                                    <?php
                                                    $query1 = $func->query("select * from kasko_police_bayiler order by bayi ASC");
                                                    $bayiler = $query1->fetchAll();
                                                     
                                                    foreach($bayiler as $bayi){
                                                    ?>
                                                    <option value="<?=$bayi->id?>"><?=$bayi->bayi?></option>
                                                    <?
                                                    }
                                                    ?>
                                            </div> 
                                        </div>
                                </div>
                                
                                 <div class="col text-start sm-margin-25px-bottom">
                                    <input type="checkbox" name="terms_condition" id="terms_condition" value="1"
                                        class="terms-condition d-inline-block align-top w-auto mb-0 margin-5px-top margin-10px-right" required>
                                    <label for="terms_condition"
                                        class="text-small d-inline-block align-top w-85 md-w-90 xs-w-85">Koşulları
                                        kabul ediyorum ve verilerimin gizlilik politikasına uygun olarak güvenli
                                        bir şekilde tutulacağını anlıyorum.<a href="https://yenicep.net/kvkk">Daha Fazla Bilgi</a></label>
                                </div>
                                 <input type="hidden" value="1" name="kayit_olustur">
                			        <input type="hidden" name="marka" value="<?=p('marka')?>">
                			        <input type="hidden" name="model" value="<?=p('model')?>">
                			        <input type="hidden" name="hafiza" value="<?=p('hafiza')?>">
                			        <input type="hidden" name="imei" value="<?=p('imei')?>">
                			        <input type="hidden" name="sigorta_bedeli" value="<?=p('sigorta_bedeli')?>">
                			         <input type="hidden" name="telefon_yas" value="<?=p('telefon_yas')?>">
    			                <button type="submit" id="contact-submit" name="send" class="align-self-center align-self-md-start btn btn-fancy btn-round-edge-small btn-large btn-gradient-garantili margin-1-half-rem-top" style="float:right">Teklifi Onayla</button>
                        </div>
                    </div>
                    
                    </div>
            </form>
			 
			<?}elseif($sorgusonuc==1 and !$rs->id){?>
			    <div class="row">
			        <div class="col-sm-12">
			            <h5 class="text-center" style="font-weigth:bold;color:#000">Telefonunuzun marka ve modeli kasko için uygun değildir.</h5>
			        </div>
			    </div>
			<?}?>
			
			<? if($sorgusonuc==2){?>
			    <div class="row">
			        <div class="col-sm-12">
			            <h5 class="text-center" style="font-weigth:bold;color:#000">Kasko fiyatlandırması yapılamadı..</h5>
			        </div>
			    </div>
			<?}?>
			
			<? if($sorgusonuc==4){?>
			    <div class="row">
			        <div class="col-sm-12">
			            <h5 class="text-center" style="font-weigth:bold;color:#000"><?=$mesaj?></h5>
			        </div>
			    </div>
			<?}?>
			
			 
			
			      	<? if($odeme==1 and $sorgusonuc==3){
			      	
			      	    $s = "select * from kaskolu_cihazlar where id='$kasko->id' ";
                		$q = $func->query($s);
                		$row=$q->fetch();
			      	
			      	
			      	?> 
			        <div class="row">
			            
			            <div class="col-md-12 col-lg-12 col-sm-12">
			            <div class="panel-body">
			             <div class="panel panel-default">
                            <div class="panel-heading">
                            <h6 class="panel-title" style="padding:20px 0;">CİHAZ BİLGİLERİ</h6>
                            </div>
                        </div>
    			            <table style="table-layout: fixed;width: 100%;" class="responsive table table-bordered">
    			                <tr style="font-weight:bold">
    			                    <th>MARKA</th>
    			                    <th>MODEL</th>
    			                    <th>HAFIZA</th>
    			                    <th>IMEI</th>
    			                    <th>TELEFON YAS</th>
    			                    <th>TEKLİF</th>
    			                </tr>
    			                <tr>
    			                    <td><?=$func->markagetir($kasko->marka)?></td>
    			                    <td> <?=$func->modelgetir($kasko->model)?> </td>
    			                    <td><?=$func->hafizagetir($kasko->hafiza)?> <?=$func->hafizaturgetir($kasko->hafiza)?></td>
    			                    <td>#<?=$kasko->imei?></td>
    			                     <td>#<?=$kasko->telefon_yas?></td>
    			                     <td><b><?=trfiyat($row->dovizTLBrut)?> </b><small>(<?=dolarfiyat($tutar_dolar)?>)</small></td>
    			                </tr>
    			            </table>
			            </div>
			        </div>
			        
    			        
                    
    			        <div class="col-md-12  col-lg-12 col-sm-12">
                            <div class="panel panel-default">
                                <div class="panel-heading">
                                <h6 class="panel-title" style="padding:10px 0;">KİŞİSEL BİLGİLER</h6>
                                </div>
                            </div>
                            <div class="panel-body">
                              
                              <div class="form-group">
                                <table style="table-layout: fixed;width: 100%;" class="responsive table table-bordered">
                                     <tr style="font-weight:bold">
                                          <td>Ad Soyad</td>
                                           <td>TC</td>
                                           <td>Telefon</td>
                                           <td>Eposta</td>
                                     </tr>
                                     <tr> 
                                          <td><?=$kasko->m_ad?> <?=$kasko->m_soyad?></td> 
                                          <td><?=$kasko->m_tc?></td>
                                          <td><?=$kasko->m_gsm?></td>
                                          <td><?=$kasko->m_eposta?></td>
                                     </tr>
                                 </table>
                            </div>
                        </div>
                       
                        <div class="col-md-12  col-lg-12 col-sm-12">
                        <li>Müşteriye ödeme linki ile devam edildiğinde müşteri telefon numarasına sms olarak link gönderilir ve ödemesini kendisinin yapması beklenir.</li>    
                         <li>Ödeme yap linki ile ödemeye yetkili ile devam edilerek ödeme sayfasına yönlendirilir.</li> 
                        </div>
                        
                         <div class="row" style="margin:50px 0">
                              
    			        
    			        
    			        
                      
                        <div class="col-md-12  col-lg-12 col-sm-12">
                            
                            
                            
                            
                            
                            
                       <?
                       
                        $s = "select * from kaskolu_cihazlar where id='$kasko->id' ";
                		$q = $func->query($s);
                		$row=$q->fetch();
                		
                		if($row->id){
                		  $curl = curl_init();
                		  
                		 $user="WS97630000";
                         $pwd="fGHj71YH"; 
                		  
               	 
                	  	  
                		  $TotalAmount=$row->dovizTLBrut;
                		  
                             $xml='http://srv.hdisigorta.com.tr:1080/cgi-bin/MOBTICPROD.pgm?User='.$user.'&Password='.$pwd.'&TaksitAdet=1&TotalAmount='.$TotalAmount.'&zorunlu3D=evet&CustomerID=9763100001&CustomerName='.$kasko->ad_soyad.'&Email='.$kasko->m_eposta.'&Phone='.$kasko->m_gsm.'&ReturnURL=https://yenicep.net/odeme-return.php?id='.$row->id;
                	      
                    
                             $xml=str_replace(" ", "%20", $xml);
                             
                             
                                $func->query("insert into kasko_response(`tarih`,`sorgu`,`aciklama`) values('".gunceltarihsaat()."','$xml','odeme linki alma')");
                         
                                 $curl = curl_init();
                                
                                curl_setopt_array($curl, array(
                                  CURLOPT_URL => $xml,
                                  CURLOPT_RETURNTRANSFER => true,
                                  CURLOPT_ENCODING => '',
                                  CURLOPT_MAXREDIRS => 10,
                                  CURLOPT_TIMEOUT => 0,
                                  CURLOPT_FOLLOWLOCATION => true,
                                  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                                  CURLOPT_CUSTOMREQUEST => 'GET',
                                ));
                                
                                  $response = curl_exec($curl); 
                             
                             $func->query("insert into kasko_response(`tarih`,`sorgu`,`aciklama`) values('".gunceltarihsaat()."','$response','odeme linki donen')");
                               
                                $response = simplexml_load_string($response, 'SimpleXMLElement', LIBXML_NOCDATA); 
                                
                               $response = json_encode($response, JSON_PRETTY_PRINT); 
                               $response = json_decode($response, true); 
                                 
                          //    echo var_dump($response);     
                                
                                curl_close($curl);
                            
                         
                               $TransactionId=$response[TransactionId];
                               $MobilexpressID=$response[MobilexpressID]; 
                            
                            $func->query("update kaskolu_cihazlar set TransactionId='$TransactionId', MobilexpressID='$MobilexpressID' where id='$kasko->id' ");
                		}
                		
                		
                		
                		
                       
                       ?>  
                        <form action="<?=$response[RedirectURL]?>" method="POST" accept-charset="iso-8859-9">      
                            <button type="submit" value="Ödeme Yap" class="align-self-center align-self-md-start btn btn-fancy btn-round-edge-small btn-large btn-gradient-garantili margin-1-half-rem-top" id="contact-submit" style="float:right;background:green"> Ödeme Yap</button>    
                        </form>  
    			        
    			        </div>
    			        
    			        
    			        </div>
    			        
            
			</div> 
         
            
	
	
	
	
	
</div>	
                <?}?>
                
                
			</div>
		</section>


 

<? include 'footer.php'; ?>