<?
function convertToSEO($text) {
    $turkce = array("ı","İ","ç","Ç","ş","Ş","ğ","Ğ","ü","Ü","ö","Ö","/",".",",",";",":","!","&","(",")","[","]","_","*"," ",'"');
    $convert = array("i","i","c","c","s","s","g","g","u","u","o","o","-","-","-","-","-","-","-","-","-","-","-","-","-","-",'-');
    return strtolower(str_replace($turkce,$convert,trim(strip_tags($text))));      
}



function degerUret($a) {
//	 $md5 = md5(microtime()*time());
 	 $md5 = time();
	 $str = substr($md5,0,$a);
	     return $str;
}



function get_active_user() {
    $t = &get_instance();
    $user = $t->session->userdata("user");
 
    if($user)  
        return $user;
    else  
        return false;
}



function get_firma_bilgileri() {
    $t = &get_instance();
    $firma_bilgileri = $t->session->userdata("firma_bilgileri");
    if($firma_bilgileri)  
        return $firma_bilgileri;
    else  
        return false;
}



function send_email($toEmail="",$subject="",$message="") {
    $t = &get_instance();

    $t->load->model("ayarlar_model");
    $ayarlar_bilgi = $t->ayarlar_model->get(
        array(
            "value" => "_SITE_CONFIG_" 
        )
    );
    $email_settings =json_decode($ayarlar_bilgi->data);
    $config=array(
        "protocol"  => $email_settings->firma_smtp_protokol,
        "smtp_host" => $email_settings->firma_smtp_host, // gmail - ssl://smtp.gmail.com
        "smtp_port" => $email_settings->firma_smtp_port,   // gmail 465
        "smtp_user" => $email_settings->firma_smtp_mail,
        "smtp_pass" => $email_settings->firma_smtp_sifre,
		'smtp_crypto' => 'tls', 
		
        "starttls"  =>  true,   //güvenli kabul edilip spama düşmemesi için 
        "charset"   => "utf-8",
        "mailtype"  => "html",
        "wordwrap"  => true,  // kelime boşlukları olacakmı
        "newline"   => "\r\n",  // mailde enter tuşu varsa onu algılaması için 
    );

    $t->load->library("email",$config);
    $t->email->from($email_settings->firma_smtp_kimden,$email_settings->firma_smtp_mail_baslik);
    $t->email->to($toEmail);
    $t->email->subject($subject);
    $t->email->message($message);

    return $t->email->send();
}

 


function yetki_tanim() {
    $yetkiler = array(
        "ceviriler"     => "Çeviriler",
        "ayarlar"       => "Ayarlar",
        "yetkiler"      => "Yetkiler",
        "translate"     => "Translate",
        "diller"        => "Diller",
        "slider"        => "Slider",
        "sayfamoduller" => "Sayfa Modulleri",
        "icerik"        => "İcerik",
        "kategoriler"   => "Kategoriler",
        "urunler"       => "Ürunler",
        "kullanicilar"  => "Kullanicilar",
        "uyeler"        => "Üyeler", 
        "mesajlar"      => "Mesajlar", 
        "galleries"     => "Galeriler", 
        "moduller"      => "Modüller", 
        "tasarimayar"   => "Tasarım Ayarları", 
        "satis"         => "Satışlar", 
        "fileuploads"   => "File Upload", 
        "bayiler"       => "Bayiler", 
        "renksecenek"   => "renksecenek", 
        "pages"         => "Pages", 
        "markalar"      => "Markalar", 
        "maillist"      => "Mail Listesi", 
        "varyasyon"     => "Varyasyon", 
        "secenek"       => "Seçenek", 
        "bayi"          => "Bayiler", 
        "ciftci"        => "ciftci", 
        "bayisatis"     => "Bayi Satişları",
        "onaybekleyenurun"     => "Onay Bekleyen Ürünler",

    );



    return $yetkiler;
}



function get_user_yetki($deger) {
    $t = &get_instance();
     
    if(!$t->session->userdata("user_yetkileri")) {
    $yetki_id=$t->session->userdata("user")->yetki_id;
    $t->load->model("yetki_model");
    
        $item=$t->yetki_model->get(
            array(
                "id" => $yetki_id
            )
        );
        $t->session->set_userdata("user_yetkileri",$item);
     }
 
     $yetki=json_decode($t->session->userdata("user_yetkileri")->permissions);
     if(isset($yetki->$deger)) {
         return true;
     }
      return false;
}





function upload_picture($file,$uploadPath,$width,$height,$name) {
    $t = &get_instance();
    $t->load->library("simpleimagelib");
               
    $upload_error=false;
   try {
       $simpleimage=$t->simpleimagelib->get_simple_image_instance();
       $simpleimage
         ->fromFile($file)    
         ->thumbnail($width,$height,'center')                        
         ->toFile("{$uploadPath}/$name", "image/png");
     } catch(Exception $err) {
       $error = $err->getMessage();
       $upload_error=true;
     }

     if($upload_error) {
         echo $error;
     } else {
        return true;
     }

}





function urlKontrol($url,$id="" ) {
    $t=&get_instance();
    if(strlen($url)>1) { 
    $t->load->model("content_model");
    if($id)  { 
        $item=$t->content_model->count(
            array(
                "url" => $url,
               //  "parentId !=" => $id 
            )
            );
    
        } else {
            $item=$t->content_model->count(
                array(
                    "url" => $url 
                )
                );
        }
     
        if($item) {
            return true;
        } else {
            return false;
        }
    
    } else {
        return false;
    }
  

}<?

function validateHashKey($hashKey, $secretKey)
{
    $status = $currencyCode = "";
    $total = $invoiceId = $orderId = 0;

    if (!empty($hashKey)) {
        $hashKey = str_replace('__', '/', $hashKey);
        $password = sha1($secretKey);

        $components = explode(':', $hashKey);
        if (count($components) > 2) {
            $iv = isset($components[0]) ? $components[0] : "";
            $salt = isset($components[1]) ? $components[1] : "";
            $salt = hash('sha256', $password . $salt);
            $encryptedMsg = isset($components[2]) ? $components[2] : "";

            $decryptedMsg = openssl_decrypt($encryptedMsg, 'aes-256-cbc', $salt, null, $iv);

            if (strpos($decryptedMsg, '|') !== false) {
                $array = explode('|', $decryptedMsg);
                $status = isset($array[0]) ? $array[0] : 0;
                $total = isset($array[1]) ? $array[1] : 0;
                $invoiceId = isset($array[2]) ? $array[2] : '0';
                $orderId = isset($array[3]) ? $array[3] : 0;
                $currencyCode = isset($array[4]) ? $array[4] : '';
            }
        }
    }

    return [$status, $total, $invoiceId, $orderId, $currencyCode];
}




function start_func() {

  domainKontrol();
  $t = &get_instance();
  //  if(!isset($_SERVER['HTTPS'])) {redirect(base_url("")); die();}
    get_ayar("firma_logo");
    get_lang();
    get_diger_ayarlar();
    cerez_politika_sayfa();
    online();
    ziyaretKaydet();
    sepetTemizle();
  

   if($t->session->userdata("kullanici_giris") == null)  {
    $t->session->set_userdata("kullanici_indirim",0);
   
  }
 

	
   if (
    $t->session->userdata("kullanici_giris") == 1 &&
    $t->session->userdata("kullanici_bilgi")->sifredegistir == 1 &&
    current_url() != base_url("bilgilerim/sifreguncelle") &&
    current_url() != base_url("bilgilerim/sifreupdate")
    ) {
      redirect(base_url("bilgilerim/sifreguncelle"));
    }
 

   }



   function  bildirim_gonder($tur,$sifre="",$mail="") {
    $t = &get_instance();
    // uye_kayit
    // sifre_sifirla

     $t->load->model("bildirimsablon_model");
     $sablon = $t->bildirimsablon_model->get(
       array(
         "id" => 1
       )
       );



   if($tur=="uye_kayit") {
      if($t->session->userdata("bildirim_ayarlari")->uye_kayit_mail_gonder) {
        // üye kayıt mail bildirimi
        $mBaslik=sablonConvert($sablon->_UYE_KAYIT_MAIL_BASLIK);
        $mSablon=sablonConvert($sablon->_UYE_KAYIT_MAIL_SABLON);

         $send=send_email($t->session->userdata("kullanici_bilgi")->email,$mBaslik,$mSablon);
 
      }

      if(isset($t->session->userdata("bildirim_ayarlari")->uye_kayit_sms_gonder)) {
        // üye kayıt sms bildirimi
       // $sBaslik=sablonConvert($sablon->_UYE_KAYIT_MAIL_BASLIK);
       // $sSablon=sablonConvert($sablon->_UYE_KAYIT_MAIL_SABLON);
 
      }

   }



    if($tur=="sifre_sifirla") {

      if($t->session->userdata("bildirim_ayarlari")->uye_sifre_mail_gonder) {
          $sfBaslik=sablonConvert($sablon->_SIFRE_YENILEME_MAIL_BASLIK);
          $sfSablon=sablonConvert($sablon->_SIFRE_YENILEME_MAIL_SABLON);

          $sfSablon=str_replace("[kullanicisifre]",$sifre,trim($sfSablon));
          $sfSablon=str_replace("[kullanicimail]",$mail,trim($sfSablon));  

          $send=send_email($mail,$sfBaslik,$sfSablon);
 
      }

      

      if($t->session->userdata("bildirim_ayarlari")->uye_sifre_sms_gonder) {
       // $sfBaslik=sablonConvert($sablon->_SIFRE_YENILEME_MAIL_BASLIK);
       // $sfSablon=sablonConvert($sablon->_SIFRE_YENILEME_MAIL_SABLON);

      }
 
    }
  
   }

 

   function sablonConvert($text) {
    $t = &get_instance();
    $turkce = array("[siteadres]","[isim]","[firmaadi]");
    $convert = array(base_url(),$t->session->userdata("kullanici_bilgi")->full_name,$t->session->userdata("firma_bilgileri")->firma_adi);
    return str_replace($turkce,$convert,trim($text));

    }



   function domainKontrol() {
      
    // $t = &get_instance();
    // $deger = convertToSEO(base_url());

    // if( !$t->session->userdata("current_domain")) {
      // $t->session->set_userdata("current_domain",$deger);
    // }
 
 

    // if($t->session->userdata("current_domain")!== $deger) {
    
 
      // unset_modules_sessions();
      // $t->session->set_userdata("current_domain",$deger);
      // redirect(base_url(""));
      // die();
    
    // }
  
  
  
    }


    function dilleriGuncelle() {
      $t = &get_instance();


      $t->load->model("lang_model");
      $t->load->model("content_model");

      $langs= $t->lang_model->get_all( array() );
      $tumIcerik = $t->content_model->get_all(
       array(
         "lang" => "tr"
       )
       );

       foreach ($tumIcerik as $icerikler) {
       foreach ($langs as $diller) {
           $icerik_kontrol = $t->content_model->get(
             array(
               "parent" =>$icerikler->parent,
               "parentId" => $icerikler->parentId,
               "lang" => $diller->kod
             )
             );
             if(!$icerik_kontrol) {
               $icerikEkle = $t->content_model->add(
                 array(
                   "parent" =>$icerikler->parent,
                   "parentId" => $icerikler->parentId,
                   "baslik" => $icerikler->baslik,
                   "aciklama" => $icerikler->aciklama,
                   "url" => $icerikler->url,
                   "lang" => $diller->kod
                 )
               );
             }
          }
       }
    }

   function cerez_politika_sayfa() {
    $t = &get_instance();
    if( $t->session->userdata("cerez_politika_sayfa")!=="null") {
    $t->load->model("icerik_model");
    $cerez_sayfa =  $t->icerik_model->get_join(
      array(
       "icerik.durum"=>1,
       "icerik.categoryId"=>201,
       "content.lang"   => $t->session->userdata("lang"),
       "content.parent"   => "icerik"

      ),"sira asc"
  );

  if(isset($cerez_sayfa->url)) {
    $cerezyazi=$cerez_sayfa->url;
  } else {
    $cerezyazi="";
  }
  $t->session->set_userdata("cerez_politika_sayfa",$cerezyazi);
  }

   return $t->session->userdata("cerez_politika_sayfa");
   }

   function ziyaretKaydet() {
    $t = &get_instance();
   $t->load->library('user_agent');
    if ($t->agent->is_browser()){
      //  $agent = $t->agent->browser().' '.$t->agent->version();
            $agent = $t->agent->browser();
    }elseif ($t->agent->is_robot()){
            $agent = $t->agent->robot();
    }elseif ($t->agent->is_mobile()){
            $agent = $t->agent->mobile();
    }else{
            $agent = 'Tanımlanamayan tarayıcı';
    }

    $t->load->model("ziyaret_model");
    $REMOTE_ADDR = $t->input->ip_address();
      $t->ziyaret_model->add(
        array(
          "ip" =>$REMOTE_ADDR,
          "tarih"=>date("Y-m-d"),
          "saat"=>date("H:i:s"),
          "zaman"=>time(),
          "sayfa"=>current_url(),
          "platform"=>$t->agent->platform(),
          "tarayici"=>$agent,
        )
        );
   }



   function online() {
     $t = &get_instance();
     $t->load->model("online_model");

     $timeoutseconds = "300";
     $timestamp=time();
     $timeout=$timestamp-$timeoutseconds;
     $REMOTE_ADDR = $t->input->ip_address();

     $t->online_model->add(
       array(
         "timestamp" => $timestamp,
         "ip" => $REMOTE_ADDR,
         "file" => current_url()
       )
       );

       $t->online_model->delete(
         array(
          "timestamp <" => $timeout
         )
         );
       return  $t->online_model->groupBy();
    }

    function get_diger_ayarlar() {
      $t = &get_instance();

      $tasarimayar=$t->session->userdata("tasarim_ayarlari");
        if(!isset($tasarimayar)) {

        $t->load->model("ayarlar_model");
        $tasarim_ayarlari = $t->ayarlar_model->get(
        array(
          "value" => "_TASARIM_AYAR_"
        )
        );

        $tasarim_ayarlari =json_decode($tasarim_ayarlari->data);
        $t->session->set_userdata("tasarim_ayarlari",$tasarim_ayarlari);

        }




        $bildirim_ayarlari=$t->session->userdata("bildirim_ayarlari");
        if(!isset($bildirim_ayarlari)) {
          $t->load->model("ayarlar_model");
          $bildirim_ayarlari = $t->ayarlar_model->get(
            array(
              "value" => "_BILDIRIM_AYAR_"
            )
            );

            $bildirim_ayarlari =json_decode($bildirim_ayarlari->data);
            $t->session->set_userdata("bildirim_ayarlari",$bildirim_ayarlari);

        }

    }





   function get_ayar($veri) {
     $t = &get_instance();
     if($t->session->userdata("ayar_al")!=1) {

        $t->load->model("ayarlar_model");
        $data = $t->ayarlar_model->get(
            array(
              "value" => "_SITE_CONFIG_"
            )
          );
          $items = json_decode($data->data);
          $t->session->set_userdata("ayarlar",$items);
          $t->session->set_userdata("ayar_al",1);

      }
      $deger=$t->session->userdata("ayarlar");
      return $deger->$veri;
 }

 function get_lang() {
    $t = &get_instance();
    $t->load->model("lang_model");

    $defaultLang=$t->lang_model->get(
      array(
        "varsayilan" => 1
      ) );

    if($t->session->userdata("cevirigetir")!=1  ) {
    $ceviriler=array();
    if(!$t->session->userdata("lang")) {
      $lang =  $t->session->set_userdata("lang",$defaultLang->kod);

      } else {
        $lang =  $t->session->userdata("lang");
      }

      $t->load->model("content_model");
      $site_ceviri=$t->content_model->get_all(
      array(
          "lang"  =>$t->session->userdata("lang"),
          "parent" => "ceviriler"
      )
      );

      foreach($site_ceviri as $donustur) {
        $ceviriler[$donustur->url] = $donustur->baslik;
       }

       $t->session->set_userdata("ceviriler",$ceviriler);

      $langs=$t->lang_model->get_all(
        array(
          "durum" => 1
        ) );
      $t->session->set_userdata("langs",$langs);
      $t->session->set_userdata("cevirigetir",1);
    }
 }

 function translate($deger) {
    $t = &get_instance();
    $ceviriler =  $t->session->userdata("ceviriler");
    if(isset($ceviriler[$deger])) {
      $cevirideger=$ceviriler[$deger];
    } else {
      $cevirideger="";
    }
    return   $cevirideger;
 }



 function sepetSay() {
  $t=&get_instance();
  $t->load->model("sepet_model");
  $say=$t->sepet_model->count(
    array(
      "sessionid"  => session_id()
    )
    );
    return $say;
 }

function paraBirim() {
    return " ₺ ";
}

 function sepeteEkle($urunId,$adet=1,$varyasyonlar="") {

  $t=&get_instance();
  $t->load->model("sepet_model");
  $t->load->model("product_model");

  $urunKontrol = $t->product_model->get(
    array(
      "id" => $urunId
    )
    );

  if($urunKontrol) {
  $kontrol=$t->sepet_model->get(
    array(
      "urunid"     => $urunId,
      "sessionid"  => session_id()
    )
    );

    // koli adedi eklenecek 

    if(isset($t->session->userdata("kullanici_bilgi")->id)) { $uyeninIdi=$t->session->userdata("kullanici_bilgi")->id; } else { $uyeninIdi=0; }
    if(!$kontrol) {
        $ekle = $t->sepet_model->add(
          array(
            "urunid" => $urunId,
            "uyeid" => $uyeninIdi,
            "varyasyon" => $varyasyonlar,
            "koliadet" =>  ($urunKontrol->koliadeti > 0 ? $urunKontrol->koliadeti : 1),
            "adet" => $adet,
            "birimFiyat" =>urunFiyat($urunKontrol),
            "sessionid"=>session_id(),
            "tarih" => gmdate("Y-m-d H:i:s"),
            "zaman"=>time()
          )
        );
    } else {
      $artir=$t->sepet_model->update(
        array(
          "sessionid"=>session_id(),
          "urunid" => $urunId,
        ),
        array(
          "adet" => $kontrol->adet+$adet,
          "varyasyon" => $varyasyonlar,
          "koliadet" =>  ($urunKontrol->koliadeti > 0 ? $urunKontrol->koliadeti : 1),
        )
        );
    }
       return true;
      } else {
        return false;
      }
 }



 function get_sliders() {
      $t=&get_instance();
      $t->load->model("slider_model");
      $sliders = $t->slider_model->get_all_join(
        array(
    "content.parent" =>"slider",
    "slider.durum" =>"1",
    "content.lang" => $t->session->userdata("lang")
    ),"sira ASC"
    );
    return $sliders;
    }
  
  
 function get_slidergiris() {
      $t=&get_instance();
      $t->load->model("slidergiris_model");
      $sliders = $t->slidergiris_model->get_all_join(
        array(
    "content.parent" =>"slidergiris",
    "slidergiris.durum" =>"1",
    "content.lang" => $t->session->userdata("lang")
    ),"sira ASC"
    );
    return $sliders;
    }
  
    function get_giris() {
      $t=&get_instance();
      $t->load->model("giris_model");
      $giris = $t->giris_model->get_all_join(
        array(
    "content.parent" =>"giris",
    "giris.durum" =>"1",
    "content.lang" => $t->session->userdata("lang")
    ),"sira ASC"
    );
    return $giris;
    }

    function get_menu() {
      $t=&get_instance();
      $t->load->model("menu_model");
      $menuler = $t->menu_model->get_all_join(
        array(
       // "menu.menu" => 1,
        "menu.durum" => 1,
        "content.parent" => "menu",
        "content.lang" =>  "tr",

    ),"sira ASC"
      );
       return $menuler;
    }



    function get_menu_id($id) {
      $t=&get_instance();
      $t->load->model("icerik_model");
      $menuler = $t->icerik_model->get_all_join(
        array(
        "icerik.categoryId" => $id,
        "icerik.durum" => 1,
        "content.parent" => "icerik",
        "content.lang" =>  $t->session->userdata("lang"),

    ),"sira ASC"
      );
       return $menuler;
    }


    function getIcerik($id) {
      $t=&get_instance();
      $t->load->model("icerik_model");
      $icerikler = $t->icerik_model->get_join(
        array(
        //"icerik.durum" => 1,
        "icerik.id" => $id,
        "content.parent" => "icerik",
        "content.lang" => $t->session->userdata("lang"),

        ),"sira ASC"
          );
          return $icerikler;
    }



    function getAllIcerik($id) {
      $t=&get_instance();
      $t->load->model("icerik_model");
      $icerikler = $t->icerik_model->get_all_join(
        array(
        "icerik.durum" => 1,
        "icerik.categoryId" => $id,
        "content.parent" => "icerik",
        "content.lang" => $t->session->userdata("lang"),

        ),"sira ASC"
          );
          return $icerikler;
    }



    function get_icerik() {
      $t=&get_instance();
      $t->load->model("icerik_model");
      $icerikler = $t->icerik_model->get_all_join(
        array(
        "icerik.durum" => 1,
        "content.parent" => "icerik",
        "content.lang" => $t->session->userdata("lang"),

        ),"sira ASC"
          );
          return $icerikler;
    }


function kategoriNumber($kategoriId) {
    $t = &get_instance();

    $t->load->model("categories_model");
    $items=$t->categories_model->get(
        array(
            "id"   =>$kategoriId
        )
    );

    if($items->categoryId == 0) {
        $number = 1;
    } else {

        $ustKnt = $t->categories_model->get(
            array(
                "id"   =>$items->categoryId
            )
        );

        $enUstKnt = $t->categories_model->get(
            array(
                "id"   =>$ustKnt->categoryId
            )
        );

        if(isset($enUstKnt)) {
            $dahaUstKnt = $t->categories_model->get(
                array(
                    "id"   =>$enUstKnt->categoryId
                )
            );
        }


 //      print_r($dahaUstKnt); die();

        if(isset($dahaUstKnt)) {
            $number = 4;
        } else  if(isset($enUstKnt)) {
            $number = 3;
        } else {
            $number = 2;
        }
    }
     return $number;

}
    function get_kategoriler(){
      $t = &get_instance();
      $t->load->model("categories_model");
      $kategoriler=$t->categories_model->get_all_join(
       array(
           "parent"  =>"categories",
           "content.lang"   => $t->session->userdata("lang"),
           "durum"   =>1
       ),"sira ASC"
       );
          return $kategoriler;

    }

    function get_Ustkategoriler(){
      $t = &get_instance();
      $t->load->model("categories_model");
      $kategoriler=$t->categories_model->get_all_join(
       array(
           "parent"  =>"categories",
           "content.lang"   => $t->session->userdata("lang"),
           "durum"   =>1,
         //  "menu"   =>1,
       ),"sira ASC"
       );
          return $kategoriler;

    }



    function get_kategorilerMain(){
      $t = &get_instance();
      $t->load->model("categories_model");
      $kategoriler=$t->categories_model->get_all_join(
       array(
           "parent"  =>"categories",
           "categories.categoryId"  =>0,
           "content.lang"   => $t->session->userdata("lang"),
           "durum"   =>1
       ),"sira ASC"
       );
          return $kategoriler;

    }

    function get_markalar(){
      $t = &get_instance();
      $t->load->model("brands_model");
      $markalar=$t->brands_model->get_all_join(
       array(
           "parent"  =>"markalar",
           "content.lang"   => $t->session->userdata("lang"),
           "durum"   =>1
       ),"sira ASC"
       );
          return $markalar;

    }

    function get_kategorilerAlt(){
      $t = &get_instance();
      $t->load->model("categories_model");
      $kategoriler=$t->categories_model->get_all_join(
       array(
           "parent"  =>"categories",
           "categories.categoryId > "  =>0,
           "content.lang"   => $t->session->userdata("lang"),
           "durum"   =>1
       ),"sira ASC"
       );
          return $kategoriler;

    }



    function get_kategorilerAl($id){
      $t = &get_instance();
      $t->load->model("categories_model");
      $kategoriler=$t->categories_model->get_all_join(
       array(
           "categories.categoryId  "  =>$id,
           "parent"  => "categories",
           "content.lang"   => $t->session->userdata("lang"),
           "durum"   =>1
       ),"sira ASC"
       );
          return $kategoriler;

    }



    function getUrun($id){

      $t = &get_instance();
      $t->load->model("product_model");
      $urunler=$t->product_model->get_join(
        array(
        "product.id"  => $id,
        "product.durum"  => 1,
        "content.parent" =>"product",
        //"content.lang"   => $t->session->userdata("lang"),
        ),"sira ASC"
        );


       return  $urunler;

    }

    



    function get_urunler(){
      $t = &get_instance();
      $t->load->model("product_model");
      $urunler=$t->product_model->get_all_join(
        array(
        "product.durum"  => 1,
        "content.parent" =>"product",
        "content.lang"   => $t->session->userdata("lang"),
        ),"sira ASC"
        );

        return  $urunler;

    }



    function get_urun_resimler(){
      $t = &get_instance();
      $t->load->model("image_model");
      $urunResimleri=$t->image_model->get_all(
        array(
            "parent"  =>"product",
            "durum"   =>1,
            "isCover" =>1
        )
        );

        $resimler=array();
        foreach($urunResimleri as $urunres) {
            $resimler[$urunres->parentId]=$urunres->img_url;
        }

        return  $resimler;

    }





    function haberlistesi_listesi_imaj() {
      $t = &get_instance();
      $t->load->model("popup_model");

      $resim=$t->popup_model->get(
        array(
            "tur"  =>"haberlistesi",
        )
        );
        return $resim->resim;

    }



    function solalt_popup() {
      $t = &get_instance();
      $t->load->model("popup_model");

        $items = $t->popup_model->get_join(
        array(
        "popup.durum" =>1,
        "content.parent" =>"popup",
        "content.lang" => $t->session->userdata("lang")
        ),"sira ASC"
        );

        return $items;

    }

 


    function image_popup_imaj() {
      $t = &get_instance();
      $t->load->model("popup_model");

      $resim=$t->popup_model->get(
        array(
            "tur"  =>"imagepopup",
        )
        );
        return $resim->resim;

    }



    function urunAciklama($aciklama,$id) {

      $degarr=explode("[+]",$aciklama);
      $degCount=count($degarr);

      $kisaaciklama="";
      $aciklama="";

      if($degCount==1) {
        $aciklama=$degarr[0];
      } else if($degCount==2) {
        $kisaaciklama=$degarr[0];
        $aciklama=$degarr[1];
      }

      if($id==1) { $deger=$kisaaciklama;}
      else if($id==2) {$deger=$aciklama; }
           return $deger;
    }



      function sepetTemizle() {
        $t = &get_instance();

        $t->load->model("karsilastir_model");
        $t->load->model("sepet_model");

        $timeoutseconds = 1*60*60;
        $timestamp=time();
        $timeout=$timestamp-$timeoutseconds;

        $t->sepet_model->delete(
          array(
          "zaman <" => $timeout
          )
        );

        $t->karsilastir_model->delete(
          array(
          "zaman <" => $timeout
          )
        );




      }


      


      function urunFiyatyyy($urun=array()) {   
        $t = &get_instance();
          
		 $indirim_orani = 0;
		if($t->session->userdata("kullanici_indirim") !== null) { 
		  $indirim_orani = $t->session->userdata("kullanici_indirim");
		}

 

          if ($indirim_orani == 7) { 
              $fiyat = number_format($urun->bayi_fiyati, 2, ',', '.');
			 // echo "aaaa";
          } else {
              $fiyat = number_format($urun->fiyat, 2, ',', '.');
			   // echo "eee";
          }
 
          return $fiyat;
 
      }
	  
	  

  function urunFiyat($urun=array()) {   
       $t = &get_instance();
     $fiyat = 0.00;
               $indirim_orani = 0;
		if ($t->session->userdata("kullanici_indirim") !== null) { 
			$indirim_orani = $t->session->userdata("kullanici_indirim");
		}


		if ($indirim_orani == 7) {  // toptan  
      $fiyat = ($urun->bayi_fiyati_indirim > 0) ? $urun->bayi_fiyati_indirim : $urun->bayi_fiyati;
		} else if ($indirim_orani == 11 ) {  // toptan üstü   
      $fiyat = ($urun->toptanustu_fiyati_indirim > 0) ? $urun->toptanustu_fiyati_indirim : $urun->toptanustu_fiyati;
		} else {   
      $fiyat = ($urun->fiyat_indirim > 0) ? $urun->fiyat_indirim : $urun->fiyat;
		}

		return $fiyat;
 
  } 



  function getUrunFiyat($urun=array()) {
    $t = &get_instance();
    $fiyat = 0.00;
              $indirim_orani = 0;
   if ($t->session->userdata("kullanici_indirim") !== null) { 
     $indirim_orani = $t->session->userdata("kullanici_indirim");
   }



   if ($indirim_orani == 7) {  // toptan  
     $fiyat =  $urun->bayi_fiyati;
   } else if ($indirim_orani == 11 ) {  // toptan üstü   
     $fiyat =  $urun->toptanustu_fiyati;
   } else {   
     $fiyat =  $urun->fiyat;
   }

   return $fiyat;
              
    
  }
	
  

  function getUrunIndirimliFiyat($urun=array()) {
      $t = &get_instance();
      $fiyat = 0.00;
                $indirim_orani = 0;
    if ($t->session->userdata("kullanici_indirim") !== null) { 
      $indirim_orani = $t->session->userdata("kullanici_indirim");
    }


    if ($indirim_orani == 7) {  // toptan  
      $fiyat =  $urun->bayi_fiyati_indirim;
    } else if ($indirim_orani == 11 ) {  // toptan üstü   
      $fiyat = $urun->toptanustu_fiyati_indirim;
    } else {   
      $fiyat =  $urun->fiyat_indirim;
    }

    return $fiyat;
  }
	
  



      function getUrunBaslik($baslik) {
        
        $sinir = 32;
        $ekle =  '';
        if (strlen($baslik) > $sinir) {
          $ekle =  '...';
        }

         $baslik = substr($baslik,0,$sinir);

          return $baslik.$ekle;
      }


      function urunFiyatKDV($urun=array()) {

        if(isset($urun)) {

            if($urun->kdv>0) {
                $fiyat = $urun->fiyat + (($urun->fiyat*$urun->kdv)/100);

            } else {
                $fiyat = $urun->fiyat;
            }

            return  $fiyat;
        } else {
            return  0;
        }


      }



      function urunFiyat_arr($urun=array(),$urunid) {
        $t = &get_instance();


          if (isset($t->session->userdata("kullanici_bilgi")->statu)) {
          if($t->session->userdata("kullanici_bilgi")->statu=="user" ) {
            $fiyat= $urun[$urunid]["fiyat"];
          } else  if($t->session->userdata("kullanici_bilgi")->statu=="bayi" ) {
            $fiyat= $urun[$urunid]["bayi_fiyati"];

          }
          } else {
            $fiyat= $urun[$urunid]["fiyat"];
          }

          return $fiyat;
      }



  function  googleLogin($uyeId,$isim,$mail) {
    $t = &get_instance();
    $t->load->model("uyeler_model");

    $userVarmi = $t->uyeler_model->get(
      array(
      //  "googleId" => $uyeId,
        "email" => $mail,
      )
      );

     if(empty($userVarmi)) {
      $userVarmi = $t->uyeler_model->add(
        array(
          "googleId" => $uyeId,
          "full_name" => $isim,
          "email" => $mail,
          "isActive" => 1,
          "createdAt"    => gmdate("Y-m-d H:i:s")
        )
        );
     }

     $getUser = $t->uyeler_model->get(
      array(
        "googleId" => $uyeId,
      )
      );

      $t->session->set_userdata("kullanici_giris",1);
      $t->session->set_userdata("kullanici_bilgi",$getUser);

    return true;
    //  print_r($getUser);

  }

 


  function  facebookLogin($uyeId,$isim,$mail=null) {
    $t = &get_instance();
    $t->load->model("uyeler_model");
    $IdGiris=false;
    $MailGiris=false;

    $userVarmi1 = $t->uyeler_model->get(
      array(
        "email" => $mail,
      )
      );


      if(!isset($userVarmi1)) {
          $userVarmi2 = $t->uyeler_model->get(
        array(
          "facebookId" => $uyeId,
        )
        );

        if(isset($userVarmi2)) {  $IdGiris=true;  }

      } else {
        $MailGiris=true;
      }


     if(!$IdGiris && !$MailGiris ) {
      $userAdd = $t->uyeler_model->add(
        array(
          "facebookId" => $uyeId,
          "full_name" => $isim,
          "email" => $mail,
          "isActive" => 1,
          "createdAt"    => gmdate("Y-m-d H:i:s")
        )
        );
     }


     $getUser = $t->uyeler_model->get(
      array(
        "facebookId" => $uyeId,
      )
      );

      $t->session->set_userdata("kullanici_giris",1);
      $t->session->set_userdata("kullanici_bilgi",$getUser);

    return true;
    //  print_r($getUser);

  }


function sepetUserUpdt() {
  $t = &get_instance();
  $t->load->model("sepet_model");


  if($t->session->userdata("kullanici_giris")==1) {
     $t->sepet_model->update(
      array(
         "sessionid" => session_id()
      ),
      array(
         "uyeid" => $t->session->userdata("kullanici_bilgi")->id
      )
      );

  }

}





function getSepet() {

  $t = &get_instance();
  $t->load->model("sepet_model");
  $sepet = $t->sepet_model->get_all_join2(
    array(
       "sepet.sessionid" => session_id(),
       "content.lang" => "tr",
       "content.parent" => "product",
    )
    );

     return $sepet;

}


function getSepetb() {

  $t = &get_instance();
  $t->load->model("sepet_model");
  $sepet = $t->sepet_model->get_all(
    array(
       "sepet.sessionid" => session_id(), 
    )
    );

     return $sepet;

}



function csrfName() {
  $t = &get_instance();
  return $t->security->get_csrf_token_name();
}


function csrfHash() {
  $t = &get_instance();
  return $t->security->get_csrf_hash();
}


function RFormat($sayi) {

  $sayi = number_format($sayi,2,",",".");
return $sayi;
}





function KdvEksi($deger) {
$sonuc =  $deger/(1 + 0.18);
// $sonuc = number_format($sonuc,2,",",".");
return  $sonuc;
}



function get_icerik_resimler(){
  $t = &get_instance();
  $t->load->model("image_model");
  $urunResimleri=$t->image_model->get_all(
    array(
        "parent"  =>"icerik",
        "durum"   =>1,
        "isCover" =>1
    )
    );

    $resimler=array();
    foreach($urunResimleri as $urunres) {
        $resimler[$urunres->parentId]=$urunres->img_url;
    }

    return  $resimler;

}





function exportExcel($filename='Exportexcel',$columns=array(),$data=array(),$replaceDotCol=array()){
   header('Content-Encoding: UTF-8');
   header('Content-Type: text/plain; charset=utf-8');
   header("Content-type: application/x-msexcel; charset=utf-8");
   header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
   header("Content-disposition: attachment; filename=".$filename.".xls");
  // header("Cache-Control: max-age=0");

   echo "\xEF\xBB\xBF"; // UTF-8 BOM

  $say=count($columns);

  echo '<table ><tr>';
  foreach($columns as $v){
      echo '<th >'.trim($v).'</th>';
  }

  echo '</tr>';

  foreach($data as $val){
      echo '<tr>';
      for($i=0; $i < $say; $i++){

          if(in_array($i,$replaceDotCol)){
              echo '<td>'.str_replace('.',',',$val[$i]).'</td>';
          }else{
              echo '<td>'.$val[$i].'</td>';
          }
      }
      echo '</tr>';
  }

  echo '</tr>';
  echo '</table>';


}



function indirimYuzde($oncekiFiyat,$fiyat) {
    return  number_format(100-($fiyat*100/$oncekiFiyat),0);

}



function trYap($sonuc) {
 return iconv(mb_detect_encoding($sonuc, mb_detect_order(), true), "UTF-8", $sonuc);
}


function indirimKat() {

  $t = &get_instance();
  $t->load->model("product_model");
  $t->load->model("categories_model");
  $urunler=$t->product_model->get_all_join(
    array(
    "product.durum"  => 1,
    "content.parent" =>"product",
    "content.lang"   => $t->session->userdata("lang"),
    ),"sira ASC"
    );


    $katlar=array();
  foreach ($urunler as $urun) {
      if($urun->onceki_fiyat>0) {
          $katlar[$urun->categoryId]=true;
      }


  }

 $kategoriler = array();
   foreach ($katlar as $key => $value) {
      //  echo $key."+++++++++";

     $itemsCatc = $t->categories_model->get(
      array(
        "id" =>$key,
        )
      );
      if(isset($itemsCatc->categoryId)) {

        $kategoriler[$itemsCatc->categoryId][$itemsCatc->id]=1;
      }



   }

   $tumKategoriler = array();
   foreach ($kategoriler as $key => $value) {
    $tumKategoriler[$key] = true;
    foreach ($kategoriler[$key] as $keyb => $valueb) {
          $tumKategoriler[$keyb] = true;

        }
   }


  // print_r($kategoriler);


  return  $tumKategoriler;




}



function taksit($taksitSayisi,$tutar) {



  switch ($taksitSayisi) {
    case 1:
       $oran = 1.95;
      break;
    case 2:
       $oran = 3.49;
      break;
    case 3:
       $oran = 4.48;
      break;

    case 4:
       $oran = 5.47;
      break;

    case 5:
       $oran = 6.46;
      break;

    case 6:
       $oran = 7.45;
      break;

    case 7:
       $oran = 8.44;
      break;

    case 8:
       $oran = 9.43;
      break;

    case 9:
       $oran = 10.42;
      break;

    case 10:
       $oran = 11.41;
      break;

    case 11:
       $oran = 12.4;
      break;

    case 12:
       $oran = 13.39;
      break;

    default:
    $oran = 1.95;
      break;
  }

    $toplam = $tutar + (($tutar*$oran)/100);
    $toplam = RFormat($toplam);

  return $toplam;
}

function isAdmin() {
    $t = &get_instance();
//     print_r($t->session->userdata("user"));
     if($t->session->userdata("user")->yetki_id < 11 ) {
         return true;
     } else {
         return false;
     }

}


function hadchild($id) {
    $t = &get_instance();
    $t->load->model("categories_model");


    $itemsCatc = $t->categories_model->get_all(
        array(
            "categoryId" =>$id,
        )
    );

        if(empty($itemsCatc)) {
            return false;
        } else {
            return true;
        }


}
 function getkategorilerCatArray(){
        $t = &get_instance();
        $t->load->model("categories_model");
        $items=$t->categories_model->get_all_join(
            array(
                "parent"  => "categories",
                "content.lang"   => $t->session->userdata("lang"),
                "durum"   => 1
            ),"sira ASC"
        );



        $catLar=array();
        foreach ($items as $item) {
            //if($item->categoryId==0) {
            $catLar[$item->categoryId][]=$item;
            //  }
        }


        return $catLar;

    }


    function kategoriAl($id){
      $t = &get_instance();
      $t->load->model("categories_model");
      $kategoriler=$t->categories_model->get_join(
       array(
           "categories.id  "  =>$id,
           "content.parent"  => "categories",
           "content.lang"   => $t->session->userdata("lang"),
           "categories.durum"   =>1
       )
       );

        return $kategoriler;

    }


      function urunFiyatKDV_($urun=array()) {

             $fiyat = urunFiyat($urun);
		     $yuzde=20;
		

        if(isset($urun)) {

            if($urun->kdv >0) {
         //    $fiyat = $fiyat + (($fiyat*$urun->kdv)/100);
   $fiyat = floatval($fiyat) + ((floatval($fiyat) * floatval($urun->kdv)) / 100);

            } else {
                $fiyat = ($sayi * $yuzde) / 100;


            }

            return  $fiyat;
        } else {

            return  0;
        }


      }
function priceArtir($tutar) {
    $t = &get_instance();
     $indirimOrani = $t->session->userdata("kullanici_indirim");
//     if($indirimOrani>0 ) {
//       //  500 - (500 x 20 / 100)
//         return $tutar+(($tutar*$indirimOrani/100));
//     } else {
//         return $tutar;
//     }
    return $tutar;
}

 function ustFiyat() {
     return 10000;
 }

    function favoriSay() {
     $t=&get_instance();
     $t->load->model("product_model");
     $t->load->model("favoriler_model");

     $urunleri = $t->product_model->get_all_join(
         array(
             "product.durum" => 1,
            // "product.stok >" => 0,
             "content.parent" => "product",
             "content.lang" => $t->session->userdata("lang"),
         ), "sira ASC"
     );

     if(isset($t->session->userdata("kullanici_bilgi")->id)) {
         $uyeidi=$t->session->userdata("kullanici_bilgi")->id;
     } else {
         $uyeidi=0;
     }
     
     $favoriler = $t->favoriler_model->get_all_join(
         array(
             "favoriler.uyeid" => $uyeidi
         )
     );
     
     $say=0;
          foreach ($favoriler as $favo) { 
           foreach ($urunleri as $urun) { 
           if($favo->urunid==$urun->id) {
                 $say++;
           }}}
  return $say;
 

 }

 function indirimOran($tutar) {
    $t = &get_instance();
     $indirimOrani = $t->session->userdata("kullanici_indirim");
     if($indirimOrani>0 ) {
         return true;
     } else {
         return false;
     }
}

function tumResimler() {

    $t = &get_instance();
    $tumResimler = $t->image_model->get_all(
        array(
            "parent" => "product",
            "durum" => 1,
        )," isCover desc "
    );

    $tumResim = array();
    foreach ($tumResimler as $tumRes) {
        $tumResim[$tumRes->parentId][] = $tumRes->img_url;
    }

    return $tumResim;

}
function isUser() {
    $t = &get_instance();
    if($t->session->userdata("kullanici_giris")!=1) {
        return false;
    } else {
        return true;
    }
}



 function siparisDurum() {

     $t = &get_instance();
     $t->load->model("siparisdurumlar_model");

     $items = $t->siparisdurumlar_model->get_all(
         array(  "durum" => 1  ), "sira ASC"
     );
     return  $items;

 }

  

 function getUye($id){

    $t = &get_instance();

    $t->load->model("uyeler_model");

    $user = $t->uyeler_model->get(array(

        "id"=>$id

    ));

    return $user;

}
function getFavoriSay() {

  $t = &get_instance();
  $t->load->model("favoriler_model");

  if($t->session->userdata("kullanici_bilgi")!==null) {
      $favoriler = $t->favoriler_model->get_all(
          array(
              "uyeid" => $t->session->userdata("kullanici_bilgi")->id
          ), "eklenmetarihi desc"
      );

      $say=0;
      foreach ($favoriler as $favo) {
          $say++;
      }

      return $say;
  } else {
      return 0;
  }

}

     

function ikiUst($kategoriId) {
  $t = &get_instance();
  $t->load->model("categories_model");

  $items=$t->categories_model->get(
      array(
          "id"   =>$kategoriId
      )
  );

  $ustKnt = $t->categories_model->get(
      array(
          "id"   =>$items->categoryId
      )
  ); 

  if(!empty( $ustKnt)) {
      $enUstKnt = $t->categories_model->get(
          array(
              "id"   =>$ustKnt->categoryId
          )
      ); 

      if(isset($enUstKnt)) {
          return $enUstKnt->id;
      } else {
          return false;
      } 


  } else { 
      return false;
  }

}



function birUst($kategoriId) {
  $t = &get_instance();
  $t->load->model("categories_model");

  $items=$t->categories_model->get(
      array(
          "id"   =>$kategoriId
      )
  );

  $ustKnt = $t->categories_model->get(
      array(
          "id"   =>$items->categoryId
      )
  );

  if(isset($ustKnt)) {
      return $ustKnt->id;
  } else {
      return false;
  }

}

  function indirimler() {


         $t = &get_instance();
         $t->load->model("indirim_model");

         $tum = $t->indirim_model->get_all(
             array(   )," baslik desc "
         );


       return  $tum;

     }
function getResim($resim,$klasor) {
    $t = &get_instance();
    $resArr = explode(".", $resim);
    $dilRes = $resArr[0] . "_" . $t->session->userdata("lang") . "." . $resArr[1];

    if (file_exists("uploads/".$klasor."/".$dilRes)) {
        $resm = $dilRes;
    } else {
        $resm = $resim;
    }

     return $resm;
}

    function getIndirimOran($id) {

         $t = &get_instance();
         $t->load->model("indirim_model");

         $tum = $t->indirim_model->get(
             array(
                 "id" => $id
             )
         );
         return $tum->oran;

     }

    function indirim(){
      $t = &get_instance();
      $t->load->model("indirim_model");
 
      $indirim = $t->indirim_model->get_all(
            array(
            )
        );

        return $indirim;
 
    }

    function indirimliFiyat($tutar) {
    $t = &get_instance();
     $indirimOrani = $t->session->userdata("kullanici_indirim");
     if($indirimOrani>0 ) {
         return $tutar-(($tutar*$indirimOrani)/100);
       
     } else {
         return $tutar;
     }
}

function indirimliKategori($tutar) {

  $t = &get_instance();
  $seciliindirim = explode(",",$t->session->userdata("kullanici_bilgi")->indirim );
  $indirimDeg = array();
  foreach($seciliindirim as $indirim){
      $indirimDeg[] = str_replace(array('[',']'),array('',''),trim($indirim));
      }
     

      foreach( get_urunler() as $urun){ 
       

       foreach(indirimler() as $indirim){ 
        
          foreach($indirimDeg as $ind) {                                                       
            if($indirim->id == $ind){
            if ($urun->categoryId == $indirim->categoryId){ 
              return $tutar-(($tutar*$indirim->oran)/100);
            }
          }else {
         
              return $tutar;
            }
          
        }
          
        }
      }
                
   
}

function indirimOranBul($id) {
  $t = &get_instance();

      $t->load->model("categories_model");
  $kategoriler=$t->categories_model->get_all_join(
          array(
              "parent"  => "categories",
              "content.lang"   => $t->session->userdata("lang"),
              "durum"   => 1
          ),"sira ASC"
      );


 $katDeger=array();
 foreach ($kategoriler as $anakat) {
      if($anakat->categoryId == 0) {
        $katDeger[$anakat->url] = $anakat->url;
               foreach ($kategoriler as $altKat) {
                   if($anakat->id==$altKat->categoryId) {
                       $katDeger[$altKat->url] = $anakat->url;
                               foreach ($kategoriler as $enAltKat) {
                                   if($altKat->id==$enAltKat->categoryId) {
                                       $katDeger[$enAltKat->url] = $anakat->url;
                                   }
                               }
                   }
               }
     }
 }



 $url = $katDeger[$id];
 $indirimOran = $t->session->userdata($url);
    if($indirimOran>0) {
       $indirimi = $indirimOran;
    } else {
        $indirimi =  0;
    }
//  print_r($katDeger[$id]); die();
  return $indirimi;

}

 





function postKontrol() {
  if(!$_POST) {
      hataVar();

  }
}

function hataVar() {
  redirect(base_url("hata"));
  die();
}


function getToken() {
  $userName = "atomedya";
  $password = "846EU++7a.*";
  $anahtar  = date("Ymd");
  $token    = base64_encode(hash_hmac('sha256',$userName.$password,$anahtar,true));
  $token = stripslashes($token);
  return $token;
}




function checkToken($token) {
  $token = stripslashes($token);
   if($token==getToken()) {
       return true;
   } else {
       hataVar();
        die();
   }

}



function telDuzelt($tel) {
  $tel = str_replace(" ", "", trim($tel));
  return $tel;
}

function siparisDurumDegisikligindeSmsGonder($uye,$fatura,$SiparisDurum) {
  /*  Onay Bekliyor, Onaylandı,  Ödeme Bekliyor,  Paketleniyor, Kargoya Verildi, Teslim Edildi, İptal Edildi, İade Edildi  */
  
     $smsGonderilsinMi = false;
   
      if($durum = "Sipariş Alındı") { $smsGonderilsinMi = true;  }
      if($durum = "Onay Bekliyor") { $smsGonderilsinMi = true;  }
      if($durum = "Onaylandı") { $smsGonderilsinMi = true;  }
      if($durum = "Kargoya Verildi") { $smsGonderilsinMi = true;  }
      if($durum = "Ödeme Bekliyor") { $smsGonderilsinMi = true;  }
      if($durum = "Paketleniyor") { $smsGonderilsinMi = true;  }
      if($durum = "Kargoya Verildi") { $smsGonderilsinMi = true;  }
      if($durum = "Teslim Edildi") { $smsGonderilsinMi = true;  }
      if($durum = "İptal Edildi") { $smsGonderilsinMi = true;  }
      if($durum = "İade Edildi") { $smsGonderilsinMi = true;  }
      
      $mesg ="$fatura->siparisid id siparişin durumu $SiparisDurum olarak güncellendi";  
    
     // sendSMS( $mesg,  "5056851443","");
    
     
  }



//  sendSMS(  "DENEME SMS ",  "5056851443","17/10/2023 11:30");
function sendSMS( $messageText, $recipientNumber,$tarih="") {
  $url = 'http://api.iletimerkezi.com/v1/send-sms';
  $api_key = '';
  $api_hash = '';
  $sender = '';
  // $tarih Formatı GG/AA/YYYY SS:DD şeklindedir.


  $recipientNumber = telDuzelt($recipientNumber);
 
  $xml = <<<EOS
<request>
<authentication>
  <key>{$api_key}</key>
  <hash>{$api_hash}</hash>
</authentication>
<order>
  <sender>{$sender}</sender>
  <sendDateTime>{$tarih}</sendDateTime>
  <message>
    <text><![CDATA[{$messageText}]]></text>
    <receipents>
      <number>{$recipientNumber}</number>
    </receipents>
  </message>
</order>
</request>
EOS;

  $ch = curl_init();
  curl_setopt($ch, CURLOPT_URL, $url);
  curl_setopt($ch, CURLOPT_POST, 1);
  curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
  curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
  curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: text/xml']);
  curl_setopt($ch, CURLOPT_HEADER, 0);
  curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
  curl_setopt($ch, CURLOPT_TIMEOUT, 120);

  $result = curl_exec($ch);
  curl_close($ch);

 return $result;
}

    

function getSmsCode($xml) {
  $response = simplexml_load_string($xml);
  $code = (string)$response->status->code;
  return $code;
}



function getSmsMessage($xml) {
  $response = simplexml_load_string($xml);
  $message = (string)$response->status->message;
  return $message;
}

function getTur() { 
  $t = &get_instance();

    $t->load->model("tur_model");

    $turler=$t->tur_model->get_all (
        array(   ),"baslik ASC"
    );

   return $turler;
 
}



function getBirim() {
    $t = &get_instance();

    $t->load->model("birim_model");

    $birim=$t->birim_model->get_all (
        array(   ),"baslik ASC"
    );

  return $birim;

}


 
function getUrunlerFromMsSql($offset,$limit) { 
	  $t = &get_instance();
	   $t->load->model("logouruntmp_model");
		
	$serverName = "88.225.217.215,1433";

	$connectionOptions = array(
		"Database" => "GO3",
		"Uid" => "sa",
		"PWD" => "Hilal153",
		"TrustServerCertificate" => true
	); 
	   
	$conn = sqlsrv_connect($serverName, $connectionOptions);
	   
	if ($conn === false) {  
	 
	 //   echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true); 
		 
	} else { 
		  
	 
	 $query = "SELECT * FROM LG_001_ITEMS WHERE LOGICALREF IN (SELECT TOP $limit LOGICALREF FROM LG_001_ITEMS ORDER BY NEWID());";
				 
		 $result = sqlsrv_query($conn, $query); 
					
		if ($result === false) { 
			echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true); 
		} else {
			echo "<h3>  tablosundaki kayıtlar:</h3><table border='1'><tr>"; 
	 
			$metadata = sqlsrv_field_metadata($result); 
			
				echo " 
				<th>LOGICALREF </th> 
				<th>CODE </th>
				<th>Başlık </th>
				<th>Adet </th> 
				<th>Fiyat </th>";
			 
			echo "</tr>"; 
	    
			while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
				
				$baslik = $row['NAME'];
				$adet = $row['SALESLIMITQUANTITY'];
				$CODE = $row['CODE'];
				$LOGICALREF = $row['LOGICALREF'];
				$fiyat = $row['FACOSTKEYS'];
				  
				echo "<tr>   
				<td>  $LOGICALREF   </td>    
				<td>  $CODE   </td>    
				<td>  $baslik   </td>    
				<td>  $adet   </td>  
				<td>  $fiyat   </td>	";   

			 $ekle = $t->logouruntmp_model->add(
				array(
				"baslik" => $baslik,
				"code" => $CODE,
				"logicalref" => $LOGICALREF, 
				"fiyat" => $fiyat, 
				)
			 );
			   
				echo "</tr>";
			}
			echo "</table>";
		}

		sqlsrv_free_stmt($result);
		sqlsrv_close($conn);
		 
	   
	   }

 
}



function getAdet($STOCKREF) {
 $t = &get_instance();
 $t->load->model("logourun_model");
	$adet =0;
	$serverName = "88.225.217.215,1433";
$connectionOptions = array(
	
    "Database" => "GO3",
    "Uid" => "sa",
    "PWD" => "Hilal153",
	"TrustServerCertificate" => true
);

$conn = sqlsrv_connect($serverName, $connectionOptions);
	
if ($conn === false) {
    // Bağlantı hatası durumunda hata mesajını yazdır
    echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true);
} else {
   // echo "Bağlantı başarılı!..<br>";
      
     $query = "SELECT STITOTS.STOCKREF, STITOTS.INVENNO, SUM(STITOTS.ONHAND) AS TOTAL_ONHAND FROM LV_001_01_STINVTOT STITOTS  WHERE STITOTS.STOCKREF = $STOCKREF AND  STITOTS.INVENNO = '1' GROUP BY STITOTS.STOCKREF, STITOTS.INVENNO; ";  
 
     $result = sqlsrv_query($conn, $query);
 
    if ($result === false) { 
        echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true);
    } else {
         
        $metadata = sqlsrv_field_metadata($result); 
          
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
            
         //   print_r($row['TOTAL_ONHAND'] );  
           //  echo $row['TOTAL_ONHAND'];
			
			/*	$ekle = $t->logourun_model->update(
						array(
							"logicalref" => $STOCKREF,  
						),
						array(
							"adet" => $row['TOTAL_ONHAND'],  
						),
						
					);
					*/

			$adet = $row['TOTAL_ONHAND'];
			 
        }
       
    }

    sqlsrv_free_stmt($result);
    sqlsrv_close($conn);
	return $adet;
	  
}
	 	 
}







 



function getUrunlerFromMsSqlb( ) { 
	    $t = &get_instance();
	    $t->load->model("logouruntmp_model");
		
	  
$serverName = "88.225.217.215,1433";
$connectionOptions = array(
	
    "Database" => "GO3",
    "Uid" => "sa",
    "PWD" => "Hilal153",
	"TrustServerCertificate" => true
);

$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
    // Bağlantı hatası durumunda hata mesajını yazdır
    echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true);
} else {
    echo "Bağlantı başarılı!..<br>";
     
	
      $query = "SELECT * FROM  LG_001_PRCLIST   ";
      $result = sqlsrv_query($conn, $query);
 
    if ($result === false) { 
        echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true);
    } else {
        echo "<h3>  tablosundaki kayıtlar:</h3><table border='1'><tr>";

        // Sütun başlıklarını yazdır  
        $metadata = sqlsrv_field_metadata($result); 
        foreach ($metadata as $field) {
          //  echo "<th>" . $field["Name"] . "</th>"; 
        }
        

        // Kayıtları yazdır  
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
            $deger = "";
            foreach ($row as $value) { 
              
				//print_r($value);  
				if (is_string($value)) {
				 	// Dizi değilse ve string ise, doğrudan ata
					 $deger .= $value . " * "; 
					 } elseif (is_array($value)) {
					 // Eğer dizi ise, implode ile string'e dönüştür
					 	$deger .= implode(', ', $value) . " * "; 
					 } elseif ($value instanceof DateTime) {
				     // Eğer $value bir DateTime nesnesi ise, uygun formatta string'e çevir
					 $deger .= " * "; 
						 } else {
						 // Dizi ya da string değilse, boş ekle
						 $deger .= $value . " * "; 
					 	}
 			 
            }
			
				$ekle = $t->logouruntmp_model->add(
						array(
							"baslik" => $deger,  
						)
					);
			 
        }
       
    }

    sqlsrv_free_stmt($result);
    sqlsrv_close($conn);
	 
   
   
}


 
}


 



function getTotalUrunCount() { 
  $serverName = "88.225.217.215,1433";
  $connectionOptions = array(
      "Database" => "GO3",
      "Uid" => "sa",
      "PWD" => "Hilal153",
      "TrustServerCertificate" => true
  );

  $conn = sqlsrv_connect($serverName, $connectionOptions);

  if ($conn === false) {
    //  echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true);
      return null;  
  }
 
   
  $countQuery = "SELECT COUNT(*) AS TotalCount FROM LG_001_ITEMS";
  $countResult = sqlsrv_query($conn, $countQuery);



  if ($countResult === false) {
    //  echo "Toplam kayıt sayısını alma hatası: " . print_r(sqlsrv_errors(), true);
      sqlsrv_close($conn);
      return null;
  }



  $totalCountRow = sqlsrv_fetch_array($countResult, SQLSRV_FETCH_ASSOC);
  $totalCount = $totalCountRow['TotalCount'];

  
  sqlsrv_free_stmt($countResult);
  sqlsrv_close($conn);

  return $totalCount;  
}





function getTotalCariCount() { 
  $serverName = "88.225.217.215,1433";
  $connectionOptions = array(
      "Database" => "GO3",
      "Uid" => "sa",
      "PWD" => "Hilal153",
      "TrustServerCertificate" => true
  );

  $conn = sqlsrv_connect($serverName, $connectionOptions);

  if ($conn === false) {
    //  echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true);
      return null;  
  }
 
   
  $countQuery = "SELECT COUNT(*) AS TotalCount FROM LG_010_CLCARD";
  $countResult = sqlsrv_query($conn, $countQuery);



  if ($countResult === false) {
    //  echo "Toplam kayıt sayısını alma hatası: " . print_r(sqlsrv_errors(), true);
      sqlsrv_close($conn);
      return null;
  }



  $totalCountRow = sqlsrv_fetch_array($countResult, SQLSRV_FETCH_ASSOC);
  $totalCount = $totalCountRow['TotalCount'];


  
  sqlsrv_free_stmt($countResult);
  sqlsrv_close($conn);
      
  return $totalCount;  
}


 


function fiyatGuncelle() {
	
	
	   $t = &get_instance();
	    $t->load->model("logouruntmp_model");
		
	  
$serverName = "88.225.217.215,1433";
$connectionOptions = array(
	
    "Database" => "GO3",
    "Uid" => "sa",
    "PWD" => "Hilal153",
	"TrustServerCertificate" => true
);

$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
    // Bağlantı hatası durumunda hata mesajını yazdır
    echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true);
} else {
    echo "Bağlantı başarılı!..<br>";
     
	
	$field = array();
      $query = "SELECT * FROM  LG_001_PRCLIST   ";
 
     $result = sqlsrv_query($conn, $query);
 
    if ($result === false) { 
        echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true);
    } else {
          
      
        $metadata = sqlsrv_field_metadata($result); 
		$i=0;
        

 
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
	       	$i++;
            $deger = "";
            foreach ($row as $value) { 
              
				  $field[$row["LOGICALREF"]] = $row["PRICE"];
			 
            }
			
				   $guncelle = $t->logourun_model->update(
						  array(
						   "logicalref" =>$row["CARDREF"],  
						   ),
						   array(
						   "fiyat" => $row["PRICE"],  
						   ) 
						   
			     );
				 
				 
				 if($i>1000) { 
				   $i=0;
				 sleep(10);
				  }
				 
			
           
        }
       
    }

    sqlsrv_free_stmt($result);
    sqlsrv_close($conn);
	
        print_r(count($field ));
	 
   
   
}

	
	
}





function getUrunBarkod($offset,$limit) {
	 
		  $t = &get_instance();
	   $t->load->model("logourun_model");
		
	$serverName = "88.225.217.215,1433";

	$connectionOptions = array(
		"Database" => "GO3",
		"Uid" => "sa",
		"PWD" => "Hilal153",
	    "TrustServerCertificate" => true
	); 
	       
	$conn = sqlsrv_connect($serverName, $connectionOptions);
	   
	if ($conn === false) {  
	  	 
	} else { 
		  
	 
	 $query = "SELECT * FROM LG_001_UNITBARCODE  WHERE LOGICALREF IN (SELECT TOP $limit LOGICALREF FROM LG_001_UNITBARCODE ORDER BY NEWID());";
				 
		 $result = sqlsrv_query($conn, $query); 
					
		if ($result === false) { 
			echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true); 
		} else {
			echo "<h3>  tablosundaki kayıtlar:</h3><table border='1'><tr>"; 
	 
			$metadata = sqlsrv_field_metadata($result); 
			
				echo " 
				<th>LOGICALREF </th> 
				<th>BARCODE </th> ";
			 
			echo "</tr>"; 
	    
			while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
				
				 // $baslik  = $row['NAME'];
				 // $adet    = $row['SALESLIMITQUANTITY'];
				 // $CODE    = $row['CODE'];
				 $LOGICALREF = $row['ITEMREF'];
				 $BARCODE = $row['BARCODE'];
				  
				echo "<tr>   
				<td>  $LOGICALREF   </td>    
				<td>  $BARCODE   </td>   ";   

                $guncelle = $t->logourun_model->update(
                    array(
                    "logicalref" =>$row["ITEMREF"],  
                    ),
                    array(
                    "barkod" => $row["BARCODE"],  
                    )
			          );
				  
				echo "</tr>";
			}
			echo "</table>";
		}

		sqlsrv_free_stmt($result);
		sqlsrv_close($conn);
		  
	   }
  
}



///////////////////////////////////////////////////////////////////////////////////// 

function getCari($limit,$offset) {
	 
    $t = &get_instance();
    $t->load->model("logocari_model");
		
	$serverName = "88.225.217.215,1433";

	$connectionOptions = array(
		"Database" => "GO3",
		"Uid" => "sa",
		"PWD" => "Hilal153",
	    "TrustServerCertificate" => true
	); 
	   
	$conn = sqlsrv_connect($serverName, $connectionOptions);
	   
	if ($conn === false) {  
	  	 
	} else { 
		   
	  $query = "SELECT * FROM LG_001_CLCARD  WHERE LOGICALREF IN (SELECT TOP $limit LOGICALREF FROM LG_001_CLCARD ORDER BY NEWID()  );";
	  // $query = "SELECT * FROM LG_001_CLCARD   WHERE LOGICALREF IN (SELECT TOP $limit LOGICALREF FROM LG_010_CLCARD ORDER BY LOGICALREF ASC  );";
				 
		 $result = sqlsrv_query($conn, $query); 
					
		if ($result === false) { 
			echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true); 
		} else {
			echo "<h3>  tablosundaki kayıtlar:</h3><table border='1'><tr>"; 
	 
			$metadata = sqlsrv_field_metadata($result); 
			 
		 echo " <th>LOGICALREF </th> 
				<th>ACTIVE </th>
				<th>CARDTYPE </th>
				<th>CODE </th>
				<th>DEFINITION_ </th>
				<th>ADDR1 </th>
				<th>ADDR2 </th>
				<th>CITY </th>
				<th>TOWN </th>
				<th>COUNTRY </th>
				<th>TELNRS1 </th>
				<th>TELNRS2 </th>
				<th>TAXOFFICE </th>
				<th>TAXNR </th>
				<th>INCHARGE </th>
				<th>EMAILADDR </th>";

				
	    
			while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
				
			 
				  
					echo "<tr>   
				<td>    ".$row['LOGICALREF']."   </td>    
				<td>   ".$row['ACTIVE']."   </td>  
				<td>   ".$row['CARDTYPE']."   </td>  
				<td>   ".$row['CODE']."  </td>  
				<td>   ".$row['DEFINITION_']."   </td>  
				<td>   ".$row['ADDR1'] ."  </td>  
				<td>   ".$row['ADDR2']." </td>  
				<td>   ".$row['CITY'] ."  </td>  
				<td>   ".$row['TOWN']."  </td>  
				<td>   ".$row['COUNTRY']."  </td>  
				<td>   ".$row['TELNRS1']."  </td>  
				<td>   ".$row['TELNRS2']."  </td>  
				<td>   ".$row['TAXOFFICE']."  </td>  
				<td>   ".$row['TAXNR']."  </td>  
				<td>   ".$row['INCHARGE']."   </td>  
				<td>   ".$row['EMAILADDR']."  </td> ";  
				  
			   
				echo "</tr>";
				
				  
				   $kontrol = $t->logocari_model->get(
				     array(
					  "code" =>$row["CODE"], 
					 )
				   );



			  if(empty( $kontrol)) { 
				    $guncelle = $t->logocari_model->add(
						  array(
						   "logicalref" =>$row["LOGICALREF"],  
						   "active" =>$row["ACTIVE"],  
						   "cardtype" =>$row["CARDTYPE"],  
						   "code" =>$row["CODE"],  
						   "adres1" =>$row["ADDR1"],  
						   "adres2" =>$row["ADDR2"],  
						   "baslik" =>$row["DEFINITION_"],  
						   "ulke" =>$row["COUNTRY"],  
						   "sehir" =>$row["CITY"],  
						   "ilce" =>$row["TOWN"],  
						   "tel1" =>$row["TELNRS1"],  
						   "tel2" =>$row["TELNRS2"],  
						   "vd" =>$row["TAXOFFICE"],  
						   "vn" =>$row["TAXNR"],  
						   "yetkili" =>$row["INCHARGE"],  
						   "email" =>$row["EMAILADDR"],   
						   )    
			        );
				  
			    }
			
			}
			echo "</table>";
		}

		sqlsrv_free_stmt($result);
		sqlsrv_close($conn);
		  
	   }
	   }
	   
	   
	   
	   

    function getCarixxx($limit,$offset) {
	 
		  $t = &get_instance();
	     $t->load->model("logocari_model");
		  
			
		$serverName = "88.225.217.215,1433";

		$connectionOptions = array(
			"Database" => "GO3",
			"Uid" => "sa",
			"PWD" => "Hilal153",
			"TrustServerCertificate" => true
		); 
		   
		$conn = sqlsrv_connect($serverName, $connectionOptions);
		   
		if ($conn === false) {  
			 
		} else { 
		  
	 
      // $query = "SELECT * FROM LG_010_CLCARD  WHERE  LOGICALREF IN (SELECT TOP $limit LOGICALREF FROM LG_010_CLCARD ORDER BY NEWID());";
	    // $query = "SELECT * FROM LG_010_CLCARD  WHERE  LOGICALREF IN (SELECT TOP $limit LOGICALREF FROM LG_010_CLCARD ORDER BY LOGICALREF ASC );";
      $query = " SELECT * FROM LG_001_CLCARD ORDER BY LOGICALREF OFFSET @offset ROWS FETCH NEXT @limit ROWS ONLY ORDER BY NEWID() ";
      

				 
		 $result = sqlsrv_query($conn, $query); 
					
		if ($result === false) { 
			echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true); 
		} else {
			echo "<h3>  tablosundaki kayıtlar:</h3><table border='1'><tr>"; 
	 
			$metadata = sqlsrv_field_metadata($result); 
			
				echo " 
				<th>LOGICALREF </th> 
				<th>ACTIVE </th>
				<th>CARDTYPE </th>
				<th>CODE </th>
				<th>DEFINITION_ </th>
				<th>ADDR1 </th>
				<th>ADDR2 </th>
				<th>CITY </th>
				<th>TOWN </th>
				<th>COUNTRY </th>
				<th>TELNRS1 </th>
				<th>TELNRS2 </th>
				<th>TAXOFFICE </th>
				<th>TAXNR </th>
				<th>INCHARGE </th>
				<th>EMAILADDR </th> ";
			 
			echo "</tr>"; 
	    
			while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
				 
				echo "<tr>   
				<td>    ".$row['LOGICALREF']."   </td>    
				<td>   ".$row['ACTIVE']."   </td>  
				<td>   ".$row['CARDTYPE']."   </td>  
				<td>   ".$row['CODE']."  </td>  
				<td>   ".$row['DEFINITION_']."   </td>  
				<td>   ".$row['ADDR1'] ."  </td>  
				<td>   ".$row['ADDR2']." </td>  
				<td>   ".$row['CITY'] ."  </td>  
				<td>   ".$row['TOWN']."  </td>  
				<td>   ".$row['COUNTRY']."  </td>  
				<td>   ".$row['TELNRS1']."  </td>  
				<td>   ".$row['TELNRS2']."  </td>  
				<td>   ".$row['TAXOFFICE']."  </td>  
				<td>   ".$row['TAXNR']."  </td>  
				<td>   ".$row['INCHARGE']."   </td>  
				<td>   ".$row['EMAILADDR']."  </td> ";  
                    
				   
				   $kontrol = $t->logocari_model->get(
				     array(
					  "logicalref" =>$row["LOGICALREF"],
					 )
				   );
 

              if(empty( $kontrol)) { 
			         
                $guncelle = $t->logocari_model->add(
						  array(
						   "logicalref" =>$row["LOGICALREF"],  
						   "active"     =>$row["ACTIVE"],  
						   "cardtype"   =>$row["CARDTYPE"],  
						   "code"       =>$row["CODE"],  
						   "adres1"     =>$row["ADDR1"],  
						   "adres2"     =>$row["ADDR2"],  
						   "baslik"     =>$row["DEFINITION_"],  
						   "ulke"       =>$row["COUNTRY"],  
						   "sehir"      =>$row["CITY"],  
						   "ilce"       =>$row["TOWN"],  
						   "tel1"       =>$row["TELNRS1"],  
						   "tel2"       =>$row["TELNRS2"],  
						   "vd"         =>$row["TAXOFFICE"],  
						   "vn"         =>$row["TAXNR"],  
						   "yetkili"    =>$row["INCHARGE"],  
						   "email"      =>$row["EMAILADDR"],   
						   )    
			     );
			  } 
				  
				echo "</tr>";
			}
			echo "</table>";
		}

		sqlsrv_free_stmt($result);
		sqlsrv_close($conn);
		 
}
 
	
}

 

// https://www.hilalcioglu.com/urunal/fromserverurunal
// https://www.hilalcioglu.com/urunal/urunupdate
// https://www.hilalcioglu.com/urunal/fiyatal
// https://www.hilalcioglu.com/urunal/barkodal
// https://www.hilalcioglu.com/urunal/adetguncelle
// https://www.hilalcioglu.com/urunal/carial
// https://www.hilalcioglu.com/urunal/cariekle
  




function addTempTableProductId() { 
// fiyat eklenen ürünleri idini temp tablosuna ekle  
    $t = &get_instance();
	$t->load->model("logouruntmp_model");
	$t->load->model("general_model");
		
	$sil = $t->general_model->truncate_tablo("logo_urun_tmp"); 	  
	
$serverName = "88.225.217.215,1433";
$connectionOptions = array(
	
    "Database" => "GO3",
    "Uid" => "sa",
    "PWD" => "Hilal153",
	"TrustServerCertificate" => true
);

$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
     
    echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true);
} else {
    echo "Bağlantı başarılı!..<br>";
     $cardRefler=array();
	 
   //  $query = " SELECT * FROM LG_001_PRCLIST WHERE DEFINITION_ IS NOT NULL AND DEFINITION_ <> ''  ";
      $query = "  SELECT * FROM LG_001_PRCLIST WHERE  DEFINITION_ LIKE '%TOPTAN%'  OR DEFINITION_ LIKE '%ONLİNE%'  OR DEFINITION_ LIKE '%PERAKENDE%'   OR DEFINITION_ LIKE '%TOPTAN ÜSTÜ%'   OR DEFINITION_ LIKE '%KDV HARİÇ LİSTE%'  ORDER BY RAND() ";
  
	     $query = "  SELECT * FROM LG_001_PRCLIST WHERE   DEFINITION_ LIKE '%ONLİNE%' ORDER BY RAND() ";
	    //  $query = "  SELECT * FROM LG_001_PRCLIST WHERE   DEFINITION_ LIKE '%TOPTAN%'  OR DEFINITION_ LIKE '%ONLİNE%' ORDER BY RAND() ";
    $result = sqlsrv_query($conn, $query);
 
    if ($result === false) { 
        echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true);
    } else {
       
        $metadata = sqlsrv_field_metadata($result); 
        
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
            $deger = "";
            
               $cardRefler[$row["CARDREF"]]=true;
		       
        } 
		 
    }
     

     
    sqlsrv_free_stmt($result);
    sqlsrv_close($conn);
	
	foreach($cardRefler as $a => $b ) {
		echo " $a <br> ";
		  $ekle = $t->logouruntmp_model->add(
			  array(
					  "logicalref" => $a,  
			  )
				  );
		 
	}
	 
   
}
  
} 
 
  

function addLogoUrun() { 
// temp tablosundaki urunleri logo urun tablosuna yoksa ekle varsa işlem yapma 
    $t = &get_instance();
	$t->load->model("logouruntmp_model");
	$t->load->model("logourun_model");
 
	
  $templer = $t->logouruntmp_model->get_all(array());

  foreach ( $templer as $tmp  ) { 
    
    $varmi = $t->logourun_model->get(
	   array(
	    "logicalref" => $tmp->logicalref,  
	   )
	);
	 
	if(!isset($varmi)) { 
	
	     $ekle = $t->logourun_model->add(
		    array(
			   "logicalref" => $tmp->logicalref, 
			)
		 );
	
	} 
     
  }  
  
    
}

 

function getItem( $logicalref ) { 
	      $t = &get_instance();
	   $t->load->model("logouruntmp_model");
		
	$serverName = "88.225.217.215,1433";

	$connectionOptions = array(
		"Database" => "GO3",
		"Uid" => "sa",
		"PWD" => "Hilal153",
		  "TrustServerCertificate" => true
	); 
	   
	$conn = sqlsrv_connect($serverName, $connectionOptions);
	   
	if ($conn === false) {  
	 
	 //   echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true); 
		 
	} else { 
		  
	 $urun=array();
	 $query = "SELECT * FROM LG_001_ITEMS WHERE LOGICALREF = '$logicalref'  ";
				 
		 $result = sqlsrv_query($conn, $query); 
					
		if ($result === false) { 
			echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true); 
		} else {
			//echo "<h3>  tablosundaki kayıtlar:</h3><table border='1'><tr>"; 
	 
			$metadata = sqlsrv_field_metadata($result); 
			
				/* echo " 
				<th>LOGICALREF </th> 
				<th>CODE </th>
				<th>Başlık </th>
				<th>Adet </th> 
				<th>Fiyat </th>"; */
			 
			  // echo "</tr>"; 
	    
			while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
				
				$baslik = $row['NAME'];
				$aciklama3 = $row['NAME4'];
				$aciklama2 = $row['NAME3'];
				$CODE = $row['CODE'];
				$LOGICALREF = $row['LOGICALREF'];
				$fiyat = $row['FACOSTKEYS'];
			    $adet = $row['SALESLIMITQUANTITY'];
				
				
				$urun = array(
				  "logicalref" =>  $LOGICALREF,
				  "code" =>  $CODE,
				  "baslik" =>  $baslik,
				  "aciklama3" =>  $aciklama3,
				  "aciklama2" =>  $aciklama2,
			      "adet" =>  $adet,
				);
				  
				/* echo "<tr>   
				<td>  $LOGICALREF   </td>    
				<td>  $CODE   </td>    
				<td>  $baslik   </td>    
				<td>  $adet   </td>  
				<td>  $fiyat   </td>	";    */
                     
				 
			   
				// echo "</tr>";
			}
		//	echo "</table>";
		}

		sqlsrv_free_stmt($result);
		sqlsrv_close($conn);
		 return $urun;
	   
	   }


 
}

 


function getBarkod($logicalref) { 
	  
		      $t = &get_instance();
	   $t->load->model("logouruntmp_model");
	$BARCODE ="";	
	$serverName = "88.225.217.215,1433";

	$connectionOptions = array(
		"Database" => "GO3",
		"Uid" => "sa",
		"PWD" => "Hilal153",
		  "TrustServerCertificate" => true
	); 
	   
	$conn = sqlsrv_connect($serverName, $connectionOptions);
	   
	if ($conn === false) {  
	 
	 //   echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true); 
		 
	} else { 
		  
	 $urun=array();
		
	// $query = "SELECT * FROM LG_001_UNITBARCODE ";	
	 $query = "SELECT * FROM LG_001_UNITBARCODE  WHERE ITEMREF = '$logicalref'  ";
	 
				 
		 $result = sqlsrv_query($conn, $query); 
					
		if ($result === false) { 
			echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true); 
		} else {
			  
			$metadata = sqlsrv_field_metadata($result); 
			 
			while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
				
				$LOGICALREF = $row['ITEMREF'];
				$BARCODE = $row['BARCODE'];
				// echo  "$LOGICALREF *** $BARCODE  <br>";
				/*$urun = array(
				  "logicalref" =>  $LOGICALREF,
				  "code" =>  $CODE,
				  "baslik" =>  $baslik,
				  "aciklama3" =>  $aciklama3,
				  "aciklama2" =>  $aciklama2,
				); */ 
				 
			}
 
		}

		sqlsrv_free_stmt($result);
		sqlsrv_close($conn);
		 return $BARCODE;
	   
	   }
   
	
}





  function fiyatAl($turu,$logicalref) {
	// $turu - TOPTAN - ONLİNE - PERAKENDE - TOPTAN ÜSTÜ - KDV HARİÇ LİSTE
	
	 $t = &get_instance();
     $t->load->model("logouruntmp_model");
	$fiyat ="";	
	$serverName = "88.225.217.215,1433";

	$connectionOptions = array(
		"Database" => "GO3",
		"Uid" => "sa",
		"PWD" => "Hilal153",
		  "TrustServerCertificate" => true
	); 
	   
	$conn = sqlsrv_connect($serverName, $connectionOptions);
	   
	if ($conn === false) {  
	 
	 //   echo "Bağlantı hatası: " . print_r(sqlsrv_errors(), true); 
		 
	} else { 
		  
	 $urun=array();
		  
	 	
	 $query = "SELECT *  FROM LG_001_PRCLIST WHERE DEFINITION_   LIKE '$turu' AND  CARDREF = '$logicalref'  ";
	 
		 $result = sqlsrv_query($conn, $query); 
		 	 
		if ($result === false) { 
			echo "Kayıtları listeleme hatası: " . print_r(sqlsrv_errors(), true); 
		} else {
			  
			$metadata = sqlsrv_field_metadata($result); 
			
			while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) { 
					//echo "***";
				//	print_r($row['PRICE']); 
					
					
				//	echo "***";
					
				  $fiyat = $row['PRICE'];
			 
				  
			}
 
		}

		sqlsrv_free_stmt($result);
		sqlsrv_close($conn);
		 return $fiyat;
	   
	   }
   
 
	
	
	
}






function getItemBilgi() {
  //  ürünlerin bilgileri alıncak 

    $t = &get_instance();
    $t->load->model("logouruntmp_model");
    $t->load->model("logourun_model");	
	//	print_r(getItem( 216113 ));	
	
	
 
  $items = $t->logourun_model->get_all(array());
 
	
	foreach($items as $item ) {  
	   
	     //  echo " $item->logicalref <**> ";
		   $bilgi = getItem( $item->logicalref );
		   $barkod= getBarkod($item->logicalref);
		   $adet= getAdet($item->logicalref);
		   $perakendeFiyat =1; // fiyatAl("PERAKENDE",$item->logicalref);
	       $onlineFiyat = fiyatAl("ONLİNE",$item->logicalref);
		   $toptanFiyat = fiyatAl("TOPTAN",$item->logicalref);
			
		 
		
		  $guncelle = $t->logourun_model->update(
		     array(
			          "logicalref" => $item->logicalref
			        ),
          array(
            "code"      => $bilgi["code"],
            "baslik"    => $bilgi["baslik"],
            "aciklama2" => $bilgi["aciklama2"],
            "aciklama3" => $bilgi["aciklama3"],
            "adet" => $adet,
            "barkod"   =>  $barkod,
            "perakendefiyat"   =>  $perakendeFiyat,
            "onlinefiyat"   =>  $onlineFiyat,
            "toptanfiyat"   =>  $toptanFiyat,
        
        
          )
		  );
		  
		  sleep(3);
 	
	} 
  	
}

 

function onecikanurunler() {
	
	    $t = &get_instance();
    $t->load->model("product_model");
	
	 
	
	 $yeniUrunler = $t->product_model->get_all_join(
            array(
                "product.durum" => 1,
                "product.populer" => 1,
                "content.parent" => "product",
                "content.lang" => "tr",
            ), "eklenmetarihi DESC"
          );
	
	
	 return $yeniUrunler;
	
}

	function yuzdeHesapla($sayi) {
	$yuzde=20;
		return ($sayi * $yuzde) / 100;
	}



	function pythonurun() {
		
		$url = 'https://voiceless-christa-atomedya-6f075a5b.koyeb.app/sync-products';
						$apiKey = 'ATOSYNC-2025';

						$ch = curl_init($url);

						curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
						curl_setopt($ch, CURLOPT_POST, true);
						curl_setopt($ch, CURLOPT_HTTPHEADER, [
							"X-API-Key: $apiKey"
						]);

						$response = curl_exec($ch);

						if (curl_errno($ch)) {
							echo 'cURL Hatası: ' . curl_error($ch);
						} else {
							echo 'Yanıt: ' . $response;
						}

						curl_close($ch);
					 
	}



	function pythonmusteri () {
		
		$url = 'https://voiceless-christa-atomedya-6f075a5b.koyeb.app/sync-client';
						$apiKey = 'ATOSYNC-2025';

						$ch = curl_init($url);

						curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
						curl_setopt($ch, CURLOPT_POST, true);
						curl_setopt($ch, CURLOPT_HTTPHEADER, [
							"X-API-Key: $apiKey"
						]);

						$response = curl_exec($ch);

						if (curl_errno($ch)) {
							echo 'cURL Hatası: ' . curl_error($ch);
						} else {
							echo 'Yanıt: ' . $response;
						}

						curl_close($ch);
					 
	}
	
	
	
	
	      function sepetTemizleUye($id) {
        $t = &get_instance();
        $t->load->model("sepet_model");
        $t->sepet_model->delete(
          array(
          "uyeid" => $id
          )
        );

      }
	  
	 
      

	  
	  function getFatura($siparisid) {
		  $t = &get_instance();
        $t->load->model("fatura_model");
		  	$items = $t->fatura_model->get(
            array( 
                "siparisid" => $siparisid
			)
        );
		  return $items;
	  }


  
<?

function get_modul() {
    
    $item = 
        array(
       "tema"                          => "site",
       "anasayfa_modul"                => "",
       "anasayfa_harita_modul"         => 1,
       "topbar_modul"                  => (get_modules("topbar")) ? get_modules("topbar") : "", 
       "ustbar_modul"                  => (get_modules("ustbar")) ? get_modules("ustbar") : "",  
       "ustmenu_modul"                 => (get_modules("ustmenu")) ? get_modules("ustmenu") : "",   
       "footer_modul"                  => (get_modules("footer")) ? get_modules("footer") : "",    
       "footerbar_modul"               => (get_modules("footerbar")) ? get_modules("footerbar") : "",    
       "slider_modul"                  => (get_modules("slidermodul")) ? get_modules("slidermodul") : "", 
       "iletisim_modul"                => (get_modules("iletisimmodul")) ? get_modules("iletisimmodul") : "", 
       "icerik_modul"                  => (get_modules("icerikmodul")) ? get_modules("icerikmodul") : "",     
       "bayiler_modul"                 => (get_modules("bayilermodul")) ? get_modules("bayilermodul") : "",     
       "multimedya_modul"              => (get_modules("multimedyamodul")) ? get_modules("multimedyamodul") : "",     
       "video_modul"                   => (get_modules("videomodul")) ? get_modules("videomodul") : "",          
       "urunler_modul"                 => (get_modules("urunlermodul")) ? get_modules("urunlermodul") : "",   
       "uyeol_modul"                   => (get_modules("uyeolmodul")) ? get_modules("uyeolmodul") : "",   
       "odemesayfa_modul"              => (get_modules("odemesayfamodul")) ? get_modules("odemesayfamodul") : "",   
       "odemebildir_modul"              => (get_modules("odemebildirmodul")) ? get_modules("odemebildirmodul") : "",   
       "bilgilerim_modul"              => (get_modules("bilgilerimmodul")) ? get_modules("bilgilerimmodul") : "",   
       "bilgilerimanasayfa_modul"      => (get_modules("bilgilerimanasayfamodul")) ? get_modules("bilgilerimanasayfamodul") : "",   
       "faturaadreslistele_modul"      => (get_modules("faturaadreslistelemodul")) ? get_modules("faturaadreslistelemodul") : "",   
       "faturaadresekle_modul"         => (get_modules("faturaadreseklemodul")) ? get_modules("faturaadreseklemodul") : "",   
       "faturaadresguncelle_modul"     => (get_modules("faturaadresguncellemodul")) ? get_modules("faturaadresguncellemodul") : "",   
       "karsilastirma_modul"           => (get_modules("karsilastirmamodul")) ? get_modules("karsilastirmamodul") : "",   
       "kargoadreslistele_modul"       => (get_modules("kargoadreslistelemodul")) ? get_modules("kargoadreslistelemodul") : "",   
       "kargoadresekle_modul"          => (get_modules("kargoadreseklemodul")) ? get_modules("kargoadreseklemodul") : "",   
       "kargoadresguncelle_modul"      => (get_modules("kargoadresguncellemodul")) ? get_modules("kargoadresguncellemodul") : "",   
       "favoriliste_modul"             => (get_modules("favorilistemodul")) ? get_modules("favorilistemodul") : "",   
       "girisyap_modul"                => (get_modules("girisyapmodul")) ? get_modules("girisyapmodul") : "",   
       "forget_modul"                  => (get_modules("forgetmodul")) ? get_modules("forgetmodul") : "",   
       "sifreguncelle_modul"           => (get_modules("sifreguncellemodul")) ? get_modules("sifreguncellemodul") : "",   
       "siparislerim_modul"           => (get_modules("siparislerimmodul")) ? get_modules("siparislerimmodul") : "",   
       "detay_modul"                   => (get_modules("detaymodul")) ? get_modules("detaymodul") : "",   
       "sepet_modul"                   => (get_modules("sepetmodul")) ? get_modules("sepetmodul") : "",   
       "arama_modul"                   => (get_modules("aramamodul")) ? get_modules("aramamodul") : "",   
       "haber_modul"                   => (get_modules("habermodul")) ? get_modules("habermodul") : "",   
       "haberdetay_modul"              => (get_modules("haberdetaymodul")) ? get_modules("haberdetaymodul") : "",   
       "kariyer_modul"                 => (get_modules("kariyermodul")) ? get_modules("kariyermodul") : "",   
       "icsayfaHeader_modul"           => (get_modules("icsayfaheadermodul")) ? get_modules("icsayfaheadermodul") : "",   
      // "odeme_modul"                   => "form_1",   
       "odeme_onay_modul"              => "onay_1",   
       "odeme_red_modul"               => "red_1",   
       
       );
        return $item;
} 

function get_modules($modulName) {
  $t = &get_instance();
  if(!$t->session->userdata("ses_get_{$modulName}_name")) {
  $t->load->model("moduller_model");
  $item = $t->moduller_model->get(
      array(
        "modul_name" => $modulName,
        "varsayilan" => 1
      ) 
    );
 
  $modul_adi = ($item) ? $item->path : "";  
  $modul_ozellik = ($item) ? json_decode($item->value) : "";  
  $t->session->set_userdata("ses_get_{$modulName}_name",$modul_adi);
  $t->session->set_userdata("ses_get_{$modulName}_properties",$modul_ozellik);
  } else {
  $modul_adi =$t->session->userdata("ses_get_{$modulName}_name");
  }
    return $modul_adi;
}
 

function unset_modules_sessions() {
    $t = &get_instance();

    $t->session->unset_userdata("ses_get_topbar_name");
    $t->session->unset_userdata("ses_get_topbar_properties");
    $t->session->unset_userdata("ses_get_ustbar_name");
    $t->session->unset_userdata("ses_get_ustbar_properties");
    $t->session->unset_userdata("ses_get_ustmenu_name");
    $t->session->unset_userdata("ses_get_ustmenu_properties");
    $t->session->unset_userdata("ses_get_footer_name");
    $t->session->unset_userdata("ses_get_footer_properties");
    $t->session->unset_userdata("ses_get_footerbar_name");
    $t->session->unset_userdata("ses_get_footerbar_properties");
    $t->session->unset_userdata("ses_get_iletisimmodul_name");
    $t->session->unset_userdata("ses_get_iletisimmodul_properties");
    $t->session->unset_userdata("ses_get_icerikmodul_name");
    $t->session->unset_userdata("ses_get_icerikmodul_properties");
    $t->session->unset_userdata("ses_get_videomodul_name");
    $t->session->unset_userdata("ses_get_videomodul_properties");
    $t->session->unset_userdata("ses_get_urunlermodul_name");
    $t->session->unset_userdata("ses_get_urunlermodul_properties");
    $t->session->unset_userdata("ses_get_detaymodul_name");
    $t->session->unset_userdata("ses_get_detaymodul_properties");
    $t->session->unset_userdata("ses_get_uyeolmodul_name");
    $t->session->unset_userdata("ses_get_uyeolmodul_properties");
    $t->session->unset_userdata("ses_get_girisyapmodul_name");
    $t->session->unset_userdata("ses_get_girisyapmodul_properties");
    $t->session->unset_userdata("ses_get_forgetmodul_name");
    $t->session->unset_userdata("ses_get_forgetmodul_properties");
    $t->session->unset_userdata("ses_get_sifreguncellemodul_name");
    $t->session->unset_userdata("ses_get_sifreguncellemodul_properties");
    $t->session->unset_userdata("ses_get_sepetmodul_name");
    $t->session->unset_userdata("ses_get_sepetmodul_properties");
    $t->session->unset_userdata("ses_get_slidermodul_name");
    $t->session->unset_userdata("ses_get_slidermodul_properties");
    $t->session->unset_userdata("ses_get_bilgilerimmodul_name");
    $t->session->unset_userdata("ses_get_bilgilerimmodul_properties");
    $t->session->unset_userdata("ses_get_bilgilerimanasayfamodul_name");
    $t->session->unset_userdata("ses_get_bilgilerimanasayfamodul_properties");
    $t->session->unset_userdata("ses_get_faturaadreslistelemodul_name");
    $t->session->unset_userdata("ses_get_faturaadreslistelemodul_properties");
    $t->session->unset_userdata("ses_get_faturaadreseklemodul_name");
    $t->session->unset_userdata("ses_get_faturaadreseklemodul_properties");
    $t->session->unset_userdata("ses_get_faturaadresguncellemodul_name");
    $t->session->unset_userdata("ses_get_faturaadresguncellemodul_properties");
    $t->session->unset_userdata("ses_get_kargoadreslistelemodul_name");
    $t->session->unset_userdata("ses_get_kargoadreslistelemodul_properties");
    $t->session->unset_userdata("ses_get_kargoadreseklemodul_name");
    $t->session->unset_userdata("ses_get_kargoadreseklemodul_properties");
    $t->session->unset_userdata("ses_get_kargoadresguncellemodul_name");
    $t->session->unset_userdata("ses_get_kargoadresguncellemodul_properties");
    $t->session->unset_userdata("ses_get_favorilistemodul_name");
    $t->session->unset_userdata("ses_get_favorilistemodul_properties");
    $t->session->unset_userdata("ses_get_aramamodul_name");
    $t->session->unset_userdata("ses_get_aramamodul_properties");
    $t->session->unset_userdata("ses_get_habermodul_name");
    $t->session->unset_userdata("ses_get_habermodul_properties");
    $t->session->unset_userdata("ses_get_haberdetaymodul_name");
    $t->session->unset_userdata("ses_get_haberdetaymodul_properties");
    $t->session->unset_userdata("ses_get_icsayfaheadermodul_name");
    $t->session->unset_userdata("ses_get_icsayfaheadermodul_properties");
    $t->session->unset_userdata("ses_get_kariyermodul_name");
    $t->session->unset_userdata("ses_get_kariyermodul_properties");
    $t->session->unset_userdata("ses_get_bayilermodul_name");
    $t->session->unset_userdata("ses_get_bayilermodul_properties");
    $t->session->unset_userdata("ses_get_multimedyamodul_name");
    $t->session->unset_userdata("ses_get_multimedyamodul_properties");
    $t->session->unset_userdata("ses_get_karsilastirmamodul_name");
    $t->session->unset_userdata("ses_get_karsilastirmamodul_properties");
    $t->session->unset_userdata("ses_get_odemesayfamodul_name");
    $t->session->unset_userdata("ses_get_odemesayfamodul_properties");
    $t->session->unset_userdata("ses_get_odemebildirmodul_name");
    $t->session->unset_userdata("ses_get_odemebildirmodul_properties");
    $t->session->unset_userdata("ses_get_siparislerimmodul_name");
    $t->session->unset_userdata("ses_get_siparislerimmodul_properties");
  

    $t->session->unset_userdata("cevirigetir");
    $t->session->unset_userdata("lang");
    $t->session->unset_userdata("langs");
    $t->session->unset_userdata("ayarlar");
    $t->session->unset_userdata("ayar_al");
    $t->session->unset_userdata("ceviriler");
 
    //  admin sessions
    $t->session->unset_userdata("firma_bilgileri");
    $t->session->unset_userdata("user");
    $t->session->unset_userdata("tasarim_ayarlari");
    $t->session->unset_userdata("kullanici_indirim");


    // çerez politikası sayfa urlsi
    $t->session->unset_userdata("cerez_politika_sayfa");
  
    session_destroy();

}

 function anasayfaModul() {
  $t = &get_instance();
  $t->load->model("anasayfamodul_model");
  $anasayfa_modul = $t->anasayfamodul_model->get(
    array(
     "durum"=>1
    ) 
);

  return $anasayfa_modul->path;


 }
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 282</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  session_set_cookie_params(): Cannot change session cookie parameters when headers already sent</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 294</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 304</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 314</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 315</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 316</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 317</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 375</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  ini_set(): Headers already sent. You cannot change the session module's ini settings at this time</p>
<p>Filename: drivers/Session_files_driver.php</p>
<p>Line Number: 108</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  session_set_save_handler(): Cannot change save handler when headers already sent</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 110</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  session_start(): Cannot start session when headers already sent</p>
<p>Filename: Session/Session.php</p>
<p>Line Number: 143</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php<br />
			Line: 12<br />
			Function: __construct			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Cannot modify header information - headers already sent by (output started at /var/www/vhosts/hilalcioglu.com/httpdocs/application/helpers/tools_helper.php:1)</p>
<p>Filename: core/Common.php</p>
<p>Line Number: 570</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
	
		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>An uncaught Exception was encountered</h4>

<p>Type: Error</p>
<p>Message: Call to undefined function start_func()</p>
<p>Filename: /var/www/vhosts/hilalcioglu.com/httpdocs/application/controllers/Urunler.php</p>
<p>Line Number: 14</p>


	<p>Backtrace:</p>
	
		
	
		
			<p style="margin-left:10px">
			File: /var/www/vhosts/hilalcioglu.com/httpdocs/index.php<br />
			Line: 323<br />
			Function: require_once			</p>
		
	

</div>