File: /home2/yenicep/www/_old/kasko.php
<? include 'header.php'; ?>
<? if(p('imeisorgula')==1){
$marka=p('marka');
$model=p('model');
$hafiza=p('hafiza');
$imei=p('imei');
$s = "select * from kasko where kasko_id='1'";
$q = $func->query($s);
$rs= $q->fetch();
if($rs->kasko_id){
$sorgusonuc=1;
}else{
$sorgusonuc=2;
}
}
if(p('kayit_olustur')==1){
$takip_no=$func->takip_no();
$tarih=gunceltarihsaat();
$s = "select * from kasko where kasko_id=1";
$q = $func->query($s);
$rs= $q->fetch();
$tutar= $rs->tutar;
$func->query("INSERT INTO `kaskolu_cihazlar`(`kasko_takipno`, `baslangic_tarih`, `tutar`, `cihaz_turu`, `marka`, `model`, `hafiza`, `imei`, `m_ad`, `m_soyad`, `m_gsm`, `m_eposta`, `m_tc`, `durum`, `bayi_id`, `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 (
'".$takip_no."', '".$tarih."', '$tutar', '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();
if($func->hdi_insert($kasko_id)==1){
echo $s = "select * from kaskolu_cihazlar where id='$kasko_id'";
$q = $func->query($s);
$kasko= $q->fetch();
$odeme=1;
$sorgusonuc=3;
}elseif($func->hdi_insert($kasko_id)==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;
}elseif($func->hdi_insert($kasko_id)==3){
$mesaj="CRM de kaydı bulunamadı. Garantili Teknoloji 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));
}
}
echo $sorgusonuc;
?>
<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-3 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; }?>
<?=$func->select(markalar,marka,"",$marka)?>
</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 order by model ASC");
$rows1 = $query1->fetchAll();
foreach($rows1 as $models){ ?>
<option data-chained="<?=$models->marka_id;?>" value="<?=$models->id;?>" <? if($model==$models->id){ echo "selected"; }?>>
<?=$models->model;?>
</option>
<?}?>
</select>
</div>
<div class="col-lg-3 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){ echo "selected"; }?>>
<?=$hafizas->hafiza;?> <?=$hafizas->tip;?>
</option>
<?}?>
</select>
</div>
<div class="col-sm-2">
<input type="hidden" name="imeisorgula" value="1">
<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->kasko_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>TEKLİF</th>
</tr>
<tr>
<td><?=$func->markagetir($marka)?></td>
<td> <?=$func->modelgetir($model)?> </td>
<td><?=$func->hafizagetir($hafiza)?> GB</td>
<td>#<?=$imei?></td>
<td><b><?=trfiyat($rs->tutar)?></b></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>
<div class="row">
<div class="col-12 col-lg-4 col-md-4">
<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-4 col-md-4">
<div class="form-group">
<label for="cardNumber">Cinsiyet</label>
<select name="MSCnsTp" class="medium-input bg-white margin-25px-bottom required" required>
<option value="" selected Disabled>Seçiniz</option>
<option value="K">Kadın</option>
<option value="E">Erkek</option>
</select>
</div>
</div>
<div class="col-12 col-lg-4 col-md-4">
<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" 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-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="form-group">
<label for="cardNumber">Taksit</label>
<select name="TaksitSekli" class="medium-input bg-white margin-25px-bottom required" required>
<option value="" selected Disabled>Seçiniz</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
</select>
</div>
</div>
</div>
<div class="col-md-6 col-lg-6 col-sm-12">
<div class="payment-content">
<div class="form-group">
<label for="cardNumber">Adres</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" placeholder="Adres" name="adres" required/>
</div>
<div class="form-group">
<label for="cardNumber">Semt</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" 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">Cadde</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" placeholder="Cadde" name="cadde" required/>
</div>
</div>
<div class="col-12 col-lg-6 col-md-6">
<div class="form-group">
<label for="cardNumber">Sokak</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" 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">Mahalle</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" placeholder="Mahalle" name="mahalle" required/>
</div>
</div>
<div class="col-12 col-lg-6 col-md-6">
<div class="form-group">
<label for="cardNumber">Apartman Adı</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" 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">Bina No</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" 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">Daire</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" 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">Kat</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" placeholder="Kat" name="kat" required/>
</div>
</div>
<div class="col-12 col-lg-6 col-md-6">
<div class="form-group">
<label for="cardNumber">Posta Kodu</label>
<input type="text" class="medium-input bg-white margin-25px-bottom required" placeholder="Posta Kodu" name="postaKodu" required/>
</div>
</div>
</div>
<input type="hidden" value="1" name="kayit_olustur">
<input type="hidden" name="marka" value="<?=$rs->marka_id?>">
<input type="hidden" name="model" value="<?=$rs->model_id?>">
<input type="hidden" name="hafiza" value="<?=$rs->hafiza_id?>">
<input type="hidden" name="imei" value="<?=p('imei')?>">
<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->kasko_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">Geçersiz IMEI..Tekrar deneyin</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){?>
<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>TEKLİF</th>
</tr>
<tr>
<td><?=$func->markagetir($kasko->marka)?></td>
<td> <?=$func->modelgetir($kasko->model)?> </td>
<td><?=$func->hafizagetir($kasko->hafiza)?> GB</td>
<td>#<?=$kasko->imei?></td>
<td><b><?=trfiyat($kasko->tutar)?></b></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();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://kasko.garantili.com.tr/sigorta/odeme/go',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS =>'{
"totalAmount": "'.$row->teminatTutar.'",
"taksitAdet": "'.$row->TaksitSekli.'",
"secure3d": "evet",
"customerId": "9763100001",
"customerName": "ekspar",
"email": "'.$kasko->m_eposta.'",
"phone": "'.$kasko->m_gsm.'"
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json'
),
));
$response = curl_exec($curl);
curl_close($curl);
$response = json_decode($response, TRUE);
$TransactionId=$response[GetTicketResponse][TransactionId][_text];
$MobilexpressID=$response[GetTicketResponse][MobilexpressID][_text];
$func->query("update kaskolu_cihazlar set TransactionId='$TransactionId', MobilexpressID='$MobilexpressID' where id='$kasko->id' ");
}
?>
<form action="<?=$response['GetTicketResponse']['RedirectURL']['_cdata']?>" 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'; ?>