<?
ini_set("include_path", '/home/ngp/php:' . ini_get("include_path") );
//config domain

$is_secure=0;

if ($is_secure==1)
{
$domainname=strtolower(str_replace("www.","",$_SERVER['HTTP_HOST']));
$config_site_url='https://www.'.$domainname.'/';      //mandatory to end with /
$config_site_short_url='www.'.$domainname.'';
$config_domain_name='www.'.$domainname;
$config_admin_url='https://www.'.$domainname.'/admin';
}
else
{
$domainname=strtolower(str_replace("www.","",$_SERVER['HTTP_HOST']));
$config_site_url='http://'.$domainname.'/';      //mandatory to end with /
$config_site_short_url=''.$domainname.'';
$config_domain_name=''.$domainname;
$config_admin_url='http://'.$domainname.'/admin';


}
//end config domain


//admin

//database
$dbhost = 'localhost';
$dbname = 'rbw_softambient';
$dbuser = 'rbw_softambient';
$dbpass = '!QAZ2wsx3edc';

include 'connect.php';

if (@$_SESSION['refresh']!=date("Y-m-d H") or intval($_SESSION['template'])<1)
{
    $_SESSION['refresh']=date("Y-m-d H");
                       
    $result1=mysql_query("SELECT id,idtemplate,logo from siteuri where nume_domeniu='".strtolower($domainname)."' and status='1' LIMIT 1");
    if (mysql_num_rows($result1))
    {
    $_SESSION['template']=mysql_result($result1,0,'idtemplate');
    $_SESSION['idsite']=mysql_result($result1,0,'id');
    $_SESSION['logo']=mysql_result($result1,0,'logo');
    }
    $result2=mysql_query("SELECT * from setari where idsite='".$_SESSION['idsite']."' LIMIT 1");
    if (mysql_num_rows($result2))
    {
     $_SESSION['cotatva']=mysql_result($result2,0,'cotatva');
     $_SESSION['discount_general']=mysql_result($result2,0,'discount_general');

    }

    $x=0;
    $arr=array();
$rezu=mysql_query("SELECT promotii_categorii.id_categorie from promotii_categorii INNER JOIN promotii ON promotii.id=promotii_categorii.id_promotie where data_inceput<='".date("Y-m-d")."' and data_sfarsit>='".date("Y-m-d")."'");
if (mysql_num_rows($rezu))
 while ($row=mysql_fetch_array($rezu)) {
    $refu=mysql_query("SELECT idprodus from produse_categorii where idcategorie='".$row['id_categorie']."'");
        if (mysql_num_rows($refu))
            while ($rand=mysql_fetch_array($refu)) {$arr[$x]=$rand['idprodus']; $x++;}
 }

 $_SESSION['promotie']=$arr;
$_SESSION['discountpromotie']=0;
 if ($x>0)
 {
 $rez=mysql_query("SELECT * from promotii where data_inceput<='".date("Y-m-d")."' and data_sfarsit>='".date("Y-m-d")."' LIMIT 1");
 if (mysql_num_rows($rez)) $_SESSION['discountpromotie']=mysql_result($rez,0,'discount');

 }
}
$idsite=$_SESSION['idsite'];
$logo=$_SESSION['logo'];
//config denumire cat

$config_denumire_pagini='pg';
global $config_denumire_categorii;
$config_denumire_categorii='ca';
$config_denumire_produs='pr';
$config_tva_produs=20;


$config_site_name='Samsonite.ro';


//pages config
$catname='cat';
$subcatname='subcat';
$subsubname='ca';
$pagname='pg';
$prodname='produs';

//modalitate plata
//OP
$config_numerar_op_active=0; //1-activ 0-dezactivat;

//mobilpay
$config_mobilpay_active=1; //1-plata prin card DA; 0 - plata prin card NU
$config_mobilpay_privatekey=realpath('./').'/private.key';
$config_mobilpay_publiccer=realpath('./').'/public.cer';
$config_mobilpay_card_signature=' ';
$config_mobilpay_production=1; //1-productie, 0-test
$config_magazine_active=0;


//company details
$config_furnizor_bank=' ING Bank ';
$config_furnizor_company_details='';

//other
$dir=$config_site_url;


//facebook

$config_facebook_site_name='';
$config_facebook_logo=$dir.'files/logo.png';
$app_id     = '';
$app_secret = '';
$config_facebook_page='';

//mails
$config_email_from='';

$config_contact_email='darius.d@infinite.ro';
$config_reports_email='darius.d@infinite.ro';
$config_newsletter_email='darius.d@infinite.ro';
$config_newsletter_email='darius.d@infinite.ro';

//default meta tags
$config_keywords='Samsonite.ro';
$config_title='Samsonite.ro';
$config_description='Samsonite.ro';

//analytics

$config_analytics="";

//other scripts

$configHtmlBottom='  ';

/* example succes sale script

$configSuccesSale=' <img src="http://www.example.com/salesuccess.php?valoareComanda={totalComanda}&emailComanda={emailComanda}&totalTransport={totalTransport}"  /> ';

unde cele 3 variabile cerute sunt {totalComanda}, {emailComanda}, {totalTransport} ( cu tot cu {} )

*/
$configSuccesSale='  ';
$configtrimiteremail=1;


?><?


function detectandextractid($text)
{

$text=strrev($text);
$ax=explode('~',$text);
$text=strrev($ax[0]);
/*
if (substr($text,0,1)=='f' or substr($text,0,1)=='v') return trim(str_replace('f','',str_replace('v','',$text)));
else return 0;
  */

return $text;

}

function detectfiltru($idfiltru)
{
    $idfiltru=str_replace('/','',$idfiltru);
    $ax=explode('/',$_GET['var1']);
    $gasitfiltru=0;
    $vector=array();


    for ($i=2;$i<count($ax);$i++)
        {
        $amz=explode(',',urldecode($ax[$i]));
        $catFiltru=detectandextractid($amz[0]);
        for ($j=1;$j<count($amz);$j++)
            {
            if (detectandextractid($amz[$j])!=$idfiltru) $vector[$catFiltru].=detectandextractid($amz[$j]).',';
                else $gasitfiltru=1;
            }
        }


//echo $idfiltru.'-'.$gasitfiltru.'<br>';
return $gasitfiltru;
}

function linkfiltre($idfiltru,$addfiltru=0)
{
                 $idfiltru=str_replace('/','',$idfiltru);
/*
formatul filtrului va fi  /denumire-parinte-f$id,denumire-filtru-v$idfiltru
*/
$ax=explode('/',$_GET['var1']);
$gasitfiltru=0;
  $vector=array();
for ($i=2;$i<count($ax);$i++)
{

$amz=explode(',',$ax[$i]);

$catFiltru=detectandextractid($amz[0]);
for ($j=1;$j<count($amz);$j++)
{
    if (detectandextractid(urldecode($amz[$j]))!=$idfiltru) $vector[$catFiltru].=detectandextractid(urldecode($amz[$j])).',';
    else $gasitfiltru=1;
}
}


if ($gasitfiltru==0)
{
$result=mysql_query("SELECT id,idparinte,denumire from categorii_filtre where denumire='$idfiltru' or REPLACE(denumire,'/','')='$idfiltru'");
if (mysql_num_rows($result))
{
    $rezrez=mysql_query("SELECT * from categorii_filtre where id='".mysql_result($result,0,'idparinte')."'");
    if (mysql_num_rows($rezrez))
$vector[str_replace('/','',mysql_result($rezrez,0,'denumire'))].=str_replace('/','',mysql_result($result,0,'denumire'));

}
}


asort($vector);

foreach ($vector as $key=>$value)
{

$rez=mysql_query("SELECT * from categorii_filtre where denumire='$key' or REPLACE(denumire,'/','')='$key' LIMIT 1");
if (mysql_num_rows($rez))
{

    $restlink.='/'.urlencode(mysql_result($rez,0,'denumire'));
    $toarr=explode(',',$value);
    for ($i=0;$i<count($toarr);$i++)
    {
        $rezu=mysql_query("SELECT * from categorii_filtre where denumire='".$toarr[$i]."' or REPLACE(denumire,'/','')='".$toarr[$i]."' LIMIT 1");
        if (mysql_num_rows($rezu))
         $restlink.=','.urlencode(str_replace('/','',mysql_result($rezu,0,'denumire')));
    }
}

}

 for ($i=0;$i<2;$i++)
{

if ($i<2)
{
    if ($i==0) $initlink=$ax[$i];
    else $initlink.='/'.$ax[$i];
}
else
{
if (strlen($ax[$i])<2) $initlink.='/'.$ax[$i];

 }
}

   for ($i=2;$i<count($ax);$i++)
{
   if (stristr($ax[$i],'pret,')!='') $pretul='/'.$ax[$i];
}


return str_replace('Pret/','',$initlink.$restlink.$pretul);
}

function filtreactive()
{

$ax=explode('/',$_GET['var1']);
$gasitfiltru=0;
  $vector=array();
  $alfa=0;
for ($i=2;$i<count($ax);$i++)
{

$amz=explode(',',$ax[$i]);

$catFiltru=detectandextractid($amz[0]);
for ($j=1;$j<count($amz);$j++)
{


$rez=mysql_query("SELECT * from categorii_filtre where denumire='".urldecode($amz[$j])."' or REPLACE(denumire,'/','')='".urldecode($amz[$j])."' ");
if (mysql_num_rows($rez)) $vector[$catFiltru].=mysql_result($rez,0,'id').',';

//   $vector[$catFiltru].=detectandextractid($amz[$j]).',';

}
}


return $vector;

}


function filtre($id_categorie,$idsite,$filtre=array())
{

global $dir,$scriptheader,$tip,$idp,$segment;

   /*
$scriptheader.='<script type="text/javascript">$(document).ready(function(){

$(".filtru").on("click",function(){

         $.post("'.$dir.'ajax.php", $("#filtrare").serialize(), function(data2) {

         $(".produsecategorie").html(data2);
           $(".product").hover(function(){
            $(".ascuns").hide();
            $(".ascuns").stop();
            $(this).find(".ascuns").slideDown();
        });

         });
       });


$(".vezifiltre").click(function() {
    var valoare=$(this).attr("val");
    $(this).hide();
    $(".filasc"+valoare).show();

});


}); </script>';

 */

//$rez=mysql_query("SELECT id from categorii where idparinte='$id_categorie' or idafisare='$id_categorie'");

$id_categorie=extractId($id_categorie);
$rez=mysql_query("SELECT id from categorii_sub ");
if (mysql_num_rows($rez))
while ($row=mysql_fetch_array($rez)) $cats.=" or produse_categorii.idcategorie='".$row['id']."'";


if (count($filtre)>0)
{    if ($segment[2]!='')    $text.='<a href="'.$dir.$tip.'/'.$idp.'" class="stergefiltre"><em class="glyphicon glyphicon-remove"></em> Sterge Toate Filtrele</a>';
         foreach ($filtre as $key=>$value)
    if ($value>0)
    {
     $query.=" produse.id='".$value."' or";
    }
    $query=substr($query,0,strlen($query)-2);

   $pr=0;
$interval=detectminmax($_GET['var1'],0,100000000000000000);
   if (strlen($interval)>3)
   {

   $am=explode(',',$interval);
   $query2.=" and produse.pret>='".trim($am[0])."' and produse.pret<='".trim($am[1])."'";

   }


$result=mysql_query("SELECT produse.id FROM produse INNER join produse_categorii on produse_categorii.idprodus=produse.id
where produse.afisare=0 and produse.pret>0 and produse.status=1 and ($query) $query2  group by produse.id");


} else
$result=mysql_query("SELECT produse.id FROM  produse   INNER join produse_categorii on produse_categorii.idprodus=produse.id
where  produse.afisare=0 and produse.status=1 and produse.pret>0 and (produse.idCategorie=0 $cats) group by produse.id");


$resultN=$result;

//pentru normal

$resultm=mysql_query("SELECT produse.id FROM  produse   INNER join produse_categorii on produse_categorii.idprodus=produse.id   where  produse.afisare=0 and produse.status=1 and produse.pret>0 and (produse.idCategorie=0 $cats) group by produse.id");
 if (mysql_num_rows($resultm))
while ($row=mysql_fetch_array($resultm))
{
    $filz.=" or idprodus='".$row['id']."' ";
}


$rezm=mysql_query("SELECT idfiltru from produse_filtre where id=0 ".$filz.' group by idfiltru');
if (mysql_num_rows($rezm))
    while ($row=mysql_fetch_array($rezm))
    {
    $fltz.=" or id='".$row['idfiltru']."'";
   // $arr[$n]=$row['idfiltru'];
    $n++;
    }

//end pentru normal

if (mysql_num_rows($result))
while ($row=mysql_fetch_array($result))
{
    $fil.=" or idprodus='".$row['id']."' ";
}

$rez=mysql_query("SELECT idfiltru from produse_filtre where id=0 ".$fil.' group by idfiltru');
if (mysql_num_rows($rez))
    while ($row=mysql_fetch_array($rez))
    {
    $flt.=" or id='".$row['idfiltru']."'";
    $arr[$n]=$row['idfiltru'];
    $n++;
    }

$rez=mysql_query("SELECT idparinte from categorii_filtre where id=0 $flt group by idparinte");
if (mysql_num_rows($rez))
    while ($row=mysql_fetch_array($rez))
         $klm.=" or id='".$row['idparinte']."'";
   $klm.=" or id='1'";


$result=mysql_query("SELECT * from categorii_filtre where (id=0 $klm) and idsite='$idsite' and idparinte=0 order by pozitie");
if (mysql_num_rows($result))
    while ($row=mysql_fetch_array($result))

    {
      //    echo "SELECT * from categorii_filtre where idparinte='".$row['id']."' and idsite='$idsite' and (id=0 $fltz) order by pozitie,denumire<br>";
        $rez=mysql_query("SELECT * from categorii_filtre where idparinte='".$row['id']."' and idsite='$idsite' and (id=0 $fltz) order by pozitie,denumire");
        if (mysql_num_rows($rez))
        {    $text1='';
       $text.='<h5>'.$row['afisareDenumire'].'</h5>';
             $min=0;$max=0;


        if (!is_array($arr)) $arr=array();

        while ($rand=mysql_fetch_array($rez))
        {
          if (in_array($rand['id'],$arr) or ($row['blocat']==1))

          {


            if ($row['tip']==0)
            {

              if ($row['id']>1)
          {
              if ($rand['afisare']==1)
              {
            $text1.='<div class="filtruascuns filasc'.$row['id'].'"><a href="'.$dir.linkfiltre($rand[denumire]).'">';
                if ( detectfiltru($rand['denumire'])) $text.='<img src="'.$dir.'files/checked.jpg" alt="ok"> ';
                else  $text.='<img src="'.$dir.'files/normal.jpg" alt="no"> ';

                 $text.=$rand['denumire'].' </a></div>';

            }
            else
            {
                $text.='<a href="'.$dir.linkfiltre($rand[denumire]).'">';
                if ( detectfiltru($rand['denumire'])) $text.='<img src="'.$dir.'files/checked.jpg" alt="ok"> ';
                else  $text.='<img src="'.$dir.'files/normal.jpg" alt="no"> ';

                 $text.=$rand['denumire'].'</a>';

            }
            }
            else
            {

               if (strtolower($rand['denumire'])=='print') $img=$dir.'culori/multicolor.png';
               if (strtolower($rand['denumire'])=='negru') $img=$dir.'culori/negru.png';
               if (strtolower($rand['denumire'])=='rosu') $img=$dir.'culori/rosu.png';
               if (strtolower($rand['denumire'])=='verde') $img=$dir.'culori/verde.png';
               if (strtolower($rand['denumire'])=='albastru') $img=$dir.'culori/albastru.png';
               if (strtolower($rand['denumire'])=='gri') $img=$dir.'culori/gri.png';
               if (strtolower($rand['denumire'])=='maro') $img=$dir.'culori/maro.png';
               if (strtolower($rand['denumire'])=='mov') $img=$dir.'culori/mov.png';
               if (strtolower($rand['denumire'])=='galben') $img=$dir.'culori/galben.png';
               if (strtolower($rand['denumire'])=='roz') $img=$dir.'culori/roz.png';
               if (strtolower($rand['denumire'])=='alb') $img=$dir.'culori/alb.png';
               if (strtolower($rand['denumire'])=='portocaliu') $img=$dir.'culori/portocaliu.png';
               if (strtolower($rand['denumire'])=='bej') $img=$dir.'culori/bej.png';
               if (strtolower($rand['denumire'])=='verde / verde inchis') $img=$dir.'culori/verdeinchis.png';
               if (strtolower($rand['denumire'])=='negru/ antracit') $img=$dir.'culori/negruantracit.png';
               if (strtolower($rand['denumire'])=='gri / antracit') $img=$dir.'culori/griantracit.png';


             $text.='<a href="'.$dir.linkfiltre($rand[denumire]).'" title="'.$rand['denumire'].'" style="display:inline; margin:0px;padding:0px;">';
                if ( detectfiltru($rand['denumire'])) $text.='<img src="'.$img.'" class="imgfil imgselected"> ';
                else  $text.='<img src="'.$img.'" class="imgfil"> ';

                 $text.='</a>';


            }
            }
           else
            {
               if (strtolower($row['denumire'])!='pret')
                {
              if ($min==0 and floatval($rand['denumire'])>0) $min=floatval($rand['denumire']);
              else if ($min>floatval($rand['denumire'])) $min=floatval($rand['denumire']);
              if ($max==0 and floatval($rand['denumire'])>0) $max=floatval($rand['denumire']);
              else if ($max<floatval($rand['denumire'])) $max=floatval($rand['denumire']);
              }

            }


            }
        }


         if ($row['tip']==0)
            {
           // if ($text1!='') $text1.='<a href="javascript:void(0)" class="vezifiltre" val="'.$row['id'].'">+ '.traducere(88,1).'</a>';
    //  $text.=$text1;
         }

       if ($filtruPretAfisat!=1)
         {

         $text.='<h5>Alege Interval Pret</h5>';
         $filtruPretAfisat=1;
         //  if (strtolower($row['denumire'])!='pret')
         if (1==2)
                {
         $text.='<p>
  <input type="text" id="amount'.$row['id'].'" name="fil['.$row['id'].'][0]" readonly style="border:0; color:#f6931f; font-weight:bold;">
</p>

<div id="slider-range'.$row['id'].'" class="slider-range"></div>';

$scriptheader.='

  <script>
  $(function() {
    $( "#slider-range'.$row['id'].'" ).slider({
      range: true,
      min: '.$min.',
      max: '.$max.',
      values: [ '.$min.', '.$max.' ],
      slide: function( event, ui ) {
        $( "#amount'.$row['id'].'" ).val( ui.values[ 0 ] + " - " + ui.values[ 1 ] );


         $.post("'.$dir.'ajax.php", $("#filtrare").serialize(), function(data2) {

         $(".produsecategorie").html(data2);
           $(".product").hover(function(){
            $(".ascuns").hide();
            $(".ascuns").stop();
            $(this).find(".ascuns").slideDown();
        });

         });

      }
    });
    $( "#amount'.$row['id'].'" ).val(  + $( "#slider-range'.$row['id'].'" ).slider( "values", 0 ) +
      " - " + $( "#slider-range'.$row['id'].'" ).slider( "values", 1 ) );
  });
  </script>  ';
        }

      //  else
        {
        //fitlru pret

        $max=0;$min=0;

        $resnew=mysql_query("SELECT max(pret) as pretmax, min(pret) as pretmin FROM produse
 INNER join produse_categorii on produse_categorii.idprodus=produse.id
where produse.afisare=0 and produse.pret>0 and produse.afisare=0 and produse.status=1 and (produse_categorii.id=0 $cats) ");


       if (mysql_num_rows($resnew))
       {
       $max=ceil(mysql_result($resnew,0,'pretmax'));
       $min=floor(mysql_result($resnew,0,'pretmin'));


       }

            $text.='<p>
  <input type="text" id="amount1000001" name="fil[1000001][0]" readonly style="border:0; color:#004b8d; font-weight:bold;">
</p>

<div id="slider-range1000001" class="slider-range"></div>';

$scriptheader.='

  <script>
  $(function() {
    $( "#slider-range1000001" ).slider({
      range: true,
      min: '.$min.',
      max: '.$max.',
      values: [ '.detectminmax($_GET['var1'],$min,$max).' ],
      slide: function( event, ui ) {
        $( "#amount1000001" ).val( ui.values[ 0 ] + "-" + ui.values[ 1 ] );


      },


           change: function( event, ui ) {
           var valoare=$("#amount1000001").val();
            window.location.href="'.$dir.scoate_pret_filtre($_GET['var1']).'/pret,"+valoare;
      }

    });
    $( "#amount1000001" ).val(  + $( "#slider-range1000001" ).slider( "values", 0 ) +
      "-" + $( "#slider-range1000001" ).slider( "values", 1 )  + " Lei" );
  });
  </script>  ';
        //end filtru pret


        }
         }

        }

    }

     /*
 $scriptheader.='
 <script type="text/javascript"> $(document).ready(function(){
 $("#orderby").change(function(){
 var valoare=$(this).val();
 $("#ordonare").val(valoare);
        $.post("'.$dir.'ajax.php", $("#filtrare").serialize(), function(data2) {

         $(".produsecategorie").html(data2);
           $(".product").hover(function(){
            $(".ascuns").hide();
            $(".ascuns").stop();
            $(this).find(".ascuns").slideDown();
        });

         });

 });


  }); </script>

   ';

       */


     $scriptheader.=' <script type="text/javascript">$(document).ready(function(){
     $(".afisfiltru").click(function(){
      $(".filtrare").toggle();
     });

      }); </script> ';

return '

<div class="col-md-12">
<div class="filtrare"><form id="filtrare"><input type="hidden" name="step" value="filtrare" />
<input type="hidden" name="ordonare" value="0" id="ordonare" />

<input type="hidden" name="categorie" value="'.$id_categorie.'" />'.$text.'</form></div></div>';


}

?><?

function antetMail()
{

return '<div style="width:600px; border: 8px solid #004b8d; padding:6px">
    <div style="width:588px; border:6px solid #e0e0e0; text-align: center; color: #555555"><Br><BR>
                                  <a href="https://www.samsonite.ro"><img src="https://www.samsonite.ro/_layout/default/assets/_images/samsonite-logo.png" alt="Samsonite.ro" /></a> <br>
                                  <a href="https://www.samsonite.ro" style="color:#004b8d;">www.samsonite.ro</a>
                                  <br><Br>
                                 <br><Br>';
}
function footerMail()
{
return '</div></div>';


}

?>