CUI: RO 36285740
J40/9241/2016
Sediul: Str. Barbu Vacarescu, nr. 119, Sector 2, Bucuresti
IBAN: RO12 RZBR 0000 0600 1875 1344
Banca: Raiffeisen Bank
Cap. Social: 200 RON
';
$config_furnizor_company_details_md='Freeways Global M
IDNO: 1019600042203
Sediul: MD-2075, Bd. Mircea cel Batran, nr.48, Chisinau, Republica Moldova
IBAN: MD02ML000000022519301751
';
//other
$dir=$config_site_url;
$config_tva_comisioane='19';
//facebook
$config_facebook_site_name='Freeways';
$config_facebook_logo=$dir.'files/logo.png';
$app_id = '589299127805458';
$app_secret = '2a395dc68ef7b5de9cf51afd07bfbec5';
$config_facebook_page='';
//mails
$config_email_from='Freeways';
$config_contact_email='office@'.$domainname;
$config_reports_email='office@'.$domainname;
$config_newsletter_email='office@'.$domainname;
$config_newsletter_email='office@freewaysintl.com';
//default meta tags
$config_keywords='Freeways';
$config_title='Freeways';
$config_description='Freeways';
//analytics
$config_analytics="";
?>0)
{
$sup=intval(strrev($expl[$i]));
echo ' '.$sup.' ';
break;
}
}
return $sup;
}
function tothetop($idUtilizator)
{
echo ' Idutilizator='.$idUtilizator.' ';
//calculeaza reteaua din adancime catre top si returneaza array
global $con;
$top=0;
$arr[]=$idUtilizator;
$alfa=0;
while ($top!=1)
{
$resultzz=mysqli_query($con,"SELECT ierarhie from utilizatorii where id='$idUtilizator'");
if (mysqli_num_rows($resultzz))
{
while ($rowi=mysqli_fetch_array($resultzz))
{
$arr[]=lastierarhie($rowi['ierarhie']);
$top=lastierarhie($rowi['ierarhie']);
if ($top>0)
$idUtilizator=$top;
// echo '$top='.$top.' ';
$alfa++;
if ($alfa>1000) {$top=1; echo 'break1'; break; }
}
} else break;
if ($alfa>1000) {$top=1; echo 'break2'; break; }
}
return $arr;
}
?>
'.$rand['numebut'].'
';
}
}
return ''.$men.'';
}
//end afisare categorii
?>=30";
$resu=mysqli_query($con,"SELECT * from puncte_cariera_bani_lunar where idutilizator='".$idUtilizator."' and punctePersonale>=30");
if (mysqli_num_rows($resu))
while ($rzz=mysqli_fetch_array($resu))
{
$aduna=1;
if (date("j")<16 and $rzz['anul']==date("Y") and $rzz['luna']==date('n',strtotime("- 1 month")) and date('n')!=1) $aduna=0;
if (date("j")<16 and $rzz['anul']==(date("Y")-1) and $rzz['luna']==12 and date('n')==1) $aduna=0;
if ($_GET['aduna']=='1') $aduna=1;
if ($aduna==1)
{
$comisionPlanCariera+=round($rzz['platestePuncte']*3.8,2);
$punctePlanCariera=$rzz['punctePersonale'];
$baniPersonalPlanCariera+=round(3.8*$rzz['punctePersonale']*$rzz['procentPersonal']/100,2);
// if ($rzz['punctePersonale']<30) { $comisionPlanCariera=0; $baniPersonalPlanCariera=0; }
}
}
//adaugam aici si extrabonus
$extrabonus=0;
$result=mysqli_query($con,"SELECT * from puncte_3x3_acordate where idutilizator='".$_SESSION['login']."'");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
{
if ($row['anul3']==date("Y",strtotime("- 1 month")) and $row['luna3']==date('n',strtotime("- 1 month")))
{
if (date("d")>15) $extrabonus+=$row['puncte']*3.8;
}
else
{
$extrabonus+=$row['puncte']*3.8;
}
}
//adaugam aici si extrabonus
return ($baniPersonalPlanCariera+$comisionPlanCariera+$extrabonus);
}
function puncteFolositeComenzi()
{
global $con;
$puncte=0;
$result=mysqli_query($con,"SELECT SUM(banidinpuncte) as suma from comenzi_antet where statuslivrare!=3 and idutilizator='".$_SESSION['login']."'");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result)) $puncte=$row['suma'];
return $puncte;
}
function comisioaneNeincasate15z()
{
global $con,$config_tva_comisioane;
$datadereferinta=date("Y-m",strtotime("-1 month"))."-01";
if (date("Y-m-d")>date("Y-m-d",strtotime(date("Y-m")."-15"))) $datadereferinta=date("Y-m")."-01";
$comisioane_neincasate=0;
if ($_SESSION['tara']!='md')
{
$rezz=mysqli_query($con,"SELECT sum(valoare) as suma from puncte_bani where idutilizator='".$_SESSION['login']."' and status=0 and data<'$datadereferinta'");
if (mysqli_num_rows($rezz))
while ($randul=mysqli_fetch_array($rezz))
{
$comisioane_neincasate+=$randul['suma'];
}
}
if ($_SESSION['tara']=='md')
{
$rezz=mysqli_query($con,"SELECT * from puncte_bani where idutilizator='".$_SESSION['login']."' and status=0 and data<'".date("Y-m")."-01'");
if (mysqli_num_rows($rezz))
while ($randul=mysqli_fetch_array($rezz))
{
if ($randul['detaliiManuale']=='Acordate la inscriere partener nou' or $randul['detaliiManuale']=='Insert Client MD')
$comisioane_neincasate+=round($randul['valoare'],2);
else
$comisioane_neincasate+=round($randul['valoare']/4.4,2);
}
}
$rezz=mysqli_query($con,"SELECT sum(puncte) as suma from puncte where idutilizator='".$_SESSION['login']."' and status=0 and data<'$datadereferinta'");
if (mysqli_num_rows($rezz))
while ($randul=mysqli_fetch_array($rezz))
{
if ($_SESSION['tara']=='ro')
$comisioane_neincasate+=$randul['suma']*3.8;
else
if ($_SESSION['tara']=='md') $comisioane_neincasate+=$randul['suma']*15;
else
$comisioane_neincasate+=$randul['suma']*3.8*0.8;
}
//echo round($comisioane_neincasate,2).'-'.puncteFolositeComenzi().'+'.puncteBaniCariera($_SESSION['login'])*1.19;
$punctebanicariera=puncteBaniCariera($_SESSION['login']);
if ($_SESSION['tara']=='md') $punctebanicariera=round($punctebanicariera*15/3.8,2);
return round($comisioane_neincasate,2)-puncteFolositeComenzi()+$punctebanicariera;
}
function puncteFolositeLunaCurenta()
{
global $con;
$puncte=0;
$result=mysqli_query($con,"SELECT SUM(banidinpuncte) as suma from comenzi_antet where data>='".date("Y-m")."-01' and data<='".date("Y-m-t")."' and statuslivrare!=3 and idutilizator='".$_SESSION['login']."'");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result)) $puncte=$row['suma'];
return $puncte;
}
?> afisare produs - pentru afisarea item-ului produs - recomandat pentru afisarea in categorii, home, search
pentru a nu incarca baza si a face multe query-uri
*/
class produse
{
function afisareprodusmagazin($id,$numebut,$imaginefata,$imaginespate,$pret,$pretinitial,$moneda,$autoship=0,$culoare='000000',$textculoare='',$ambalare='',$tippachet=0,$eshoponline=0)
{
global $dir,$prodname,$con,$segment,$lng;
$result=mysqli_query($con,"SELECT id from produse where id='$id' and afisare=0 and numebut$lng!='' LIMIT 1");
if (mysqli_num_rows($result))
{
if (strlen($_SESSION['pjuridica'])<1 and $id==1) return '';
$tip=0; //daca tip=1 e magazin de haine
$puncteprodus=0;
$unuplusunu=0;
$result=mysqli_query($con,"SELECT pretnologin, puncte,1plus1,tip_pachet,indisponibil,textPromotie$lng, culoarePromotie,culoareTextPromotie from produse where id='$id'LIMIT 1");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result)) {
$indisponibil=$row['indisponibil'];
$tipPachetProdus=$row['tip_pachet'];
$textPromotie=$row['textPromotie'.$lng];
$culoarePromotie=$row['culoarePromotie'];
$culoareTextPromotie=$row['culoareTextPromotie'];
$pret=$row['pretnologin'];
$puncteprodus=$row['puncte'];
if ($_SESSION['fondator']==1)
$unuplusunu=$row['1plus1'];
}
$text='';
if ($autoship==1) $clasa='autoship';
else $clasa='noautoship';
$text.='
';
if ($pretinitial>0) $text.=' '.$pretinitial.' RON ';
else $text.=' ';
$text.=cnv($pret,$moneda,$_SESSION['moneda']).' RON '.$mypoints.'
';
if ($tip==1)
$text.='
';
else {
$afisCos=0;
// if ($tippachet!=2 and $tipPachetProdus==2) $afisCos=1;
if ($eshoponline==1)
{
if ($indisponibil==0)
{
$text.='';
}
else $text.='
'.traducere(334,1).'
';
}
}
$text.='
';
if ($_SESSION['pentrucomanda']>0) return $text;
else $rez=mysqli_query($con,"SELECT id from produse where id='$id' and primacomanda=0");
if (mysqli_num_rows($rez)) return '
'.$text.'
';
}
}
function afisareprodus($id,$numebut,$imaginefata,$imaginespate,$pret,$pretinitial,$moneda,$autoship=0,$culoare='000000',$textculoare='',$ambalare='',$tippachet=0,$p50=0)
{
global $dir,$prodname,$con,$lng,$afis7;
if ($_GET['p50']==1) $p50=1;
$afisam=1;
if ($id==845) $afisam=0;
if ($afisam==0)
{
// if ($_GET['test']=='z') echo "SELECT id from utilizatorii where id='".$_SESSION['login']."' and abonamentvalabil>='".date("Y-m-d",strtotime(" + 2 weeks"))."' LIMIT 1";
$resultx=mysqli_query($con,"SELECT id from utilizatorii where id='".$_SESSION['login']."' and abonamentvalabil>='".date("Y-m-d",strtotime(" + 2 weeks"))."' LIMIT 1");
if (intval(mysqli_num_rows($resultx))>0) $afisam=0;
else $afisam=1;
}
if ($id==845 and $_SESSION['login']<1) $afisam=0;
if ($afisam==1)
{
if ($_SESSION['pachetseminar']>0) $packet=' and pachetSeminar=1';
if ($_SESSION['pachetseminar']>0 and date("Y-m-d")<='20-04-20') $supliment='_bkp13apr2020_ok';
// if ($id==845) echo "SELECT * from produse$supliment where id='$id' and afisare=0 and numebut$lng!='' $packet LIMIT 1";
if ($_SESSION['tara']=='ro')
{ $result=mysqli_query($con,"SELECT * from produse$supliment where id='$id' and afisare=0 and numebut$lng!='' $packet and p50=$p50 LIMIT 1");
}
if ($_SESSION['tara']=='md')
{
$result=mysqli_query($con,"SELECT * from produse$supliment where id='$id' and afisare=0 and numebut$lng!='' and pret_mdl>0 and afisareMD=0 $packet and p50='$p50' LIMIT 1");
}
if ($_SESSION['tara']!='ro' and $_SESSION['tara']!='md')
{ $result=mysqli_query($con,"SELECT * from produse$supliment where id='$id' and afisare=0 and pret_en>0 and numebut$lng!='' and p50='$p50' $packet LIMIT 1");
}
if (@mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
{
$textPromotie=$row['textPromotie'.$lng];
$culoarePromotie=$row['culoarePromotie'];
$culoareTextPromotie=$row['culoareTextPromotie'];
$indisponibil=$row['indisponibil'];
if ($_SESSION['tara']=='md') $indisponibil=$row['indisponibilMD'];
$numebut=$row['numebut'.$lng];
if (strlen($_SESSION['pjuridica'])<1 and $id==1) return '';
$tip=0; //daca tip=1 e magazin de haine
$puncteprodus=0;
$unuplusunu=0;
{
$tipPachetProdus=$row['tip_pachet'];
if ($_SESSION['login']<1 or $_SESSION['client']==1)
{
$pret=$row['pretnologin'];
}
if ($_SESSION['pentrucomanda']>0)
{
$rtg=mysqli_query($con,"SELECT client from utilizatorii where id='".$_SESSION['pentrucomanda']."' and client=1");
if (mysqli_num_rows($rtg)) $pret=$row['pretnologin'];
}
if ($_SESSION['pachetinscriere']==1)
$puncteprodus=$row['punctajinscriere'];
else
$puncteprodus=$row['puncte'];
if ($_SESSION['fondator']==1)
$unuplusunu=$row['1plus1'];
}
$text='';
if ($autoship==1) $clasa='autoship';
else $clasa='noautoship';
$text.='
';
if ($pretinitial>0) $text.=' '.$pretinitial.' RON ';
else $text.=' ';
if ($_SESSION['tara']!='ro' and $_SESSION['tara']!='md') {$text.=$row['pret_en'].' EUR '.$mypoints.'
';}
else if ($_SESSION['tara']=='md') {
{
if ($_SESSION['client']==1)
$text.=$row['pretnologin_mdl'].' MDL '.$mypoints.'
';
else
{
if ($_SESSION['pentrucomanda']>0 and $cosh->total()<3300 and $_SESSION['tara']=='md')
$text.=$row['pretnologin_mdl'].' MDL '.$mypoints.'
';
else
{
if ($_SESSION['login']>0)
$text.=$row['pret_mdl'].' MDL '.$mypoints.'
';
else
$text.=$row['pretnologin_mdl'].' MDL '.$mypoints.'';
}
}
}
}
else $text.=cnv($pret,$moneda,$_SESSION['moneda']).' RON '.$mypoints.'';
if ($tip==1)
$text.='
';
else {
$afisCos=0;
if ($tippachet!=2 and $tipPachetProdus==2) $afisCos=1;
if ($_GET['customtest']==1) $_SESSION['customtest']=1;
if ($_SESSION['login']<1 and $indisponibil==1)
{
$text.='
'.traducere(334,1).'
';
}
if ($textPromotie!='' and $indisponibil==0)
$text.='
'.$textPromotie.'
';
if ($_SESSION['login']>0 and $afisCos==0)
if ($_SESSION['fondator']==1 or $puncteprodus>0 or $id==1 or ($tipPachetProdus=7 and date("d")>=16 and $afis7==1) or $_SESSION['customtest']==1 )
{
if ($indisponibil==0)
{
$cart=new cosh();
$text.='';
}
else
{$text.='
'.traducere(334,1).'
';
}
}
}
$text.='';
if ($_SESSION['pentrucomanda']>0 and $pret>0) return '
'.$text.'
';
else $rez=mysqli_query($con,"SELECT id from produse where id='$id' and primacomanda=0");
if (mysqli_num_rows($rez) and $pret>0) return '
'.$text.'
';
}
}
}
function toateproduselepaginate($tippachet=0,$categorie=0)
{
if ($_GET['debugz']==1) echo 'zzz';
global $con,$afis7;
$afis7=1;
if ($tippachet==7)
{
$result=mysqli_query($con,"SELECT * from puncte_3x3_acordate where idutilizator='".$_SESSION['login']."' and statusAcordareProduse=0");
if (!mysqli_num_rows($result)) $afis7=0;
}
if ($_GET['categorie']>0)
{
$rasu=mysqli_query($con,"SELECT * from produse_filtre where idfiltru='".mysqli_real_escape_string($con,$_GET['categorie'])."' ");
if (mysqli_num_rows($rasu))
while ($rand2=mysqli_fetch_array($rasu))
{
$arr[]=$rand2['idprodus'];
$alfa++;
}
}
$prds=new produse();
if ($tippachet==3)
{
if ($_SESSION['pachetseminar']>0 and date("Y-m-d")<='2020-04-20')
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse_bkp13apr2020_ok where tip_pachet='$tippachet' or tip_pachet=2 order by pozitie");
else
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' or tip_pachet=2 order by pozitie");
}else
{
if ($_GET['test']==1) echo "SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' order by pozitie";
// echo "SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' order by pozitie";
if ($tippachet==4)
{
if ($_POST['step']=='tosearchpromo' and $_POST['search']!='') $newq=" and numebut REGEXP '".mysqli_real_escape_string($con,$_POST['search'])."'";
}
if ($_SESSION['pachetseminar']>0 and date("Y-m-d")<='2020-04-20')
{
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse_bkp13apr2020_ok where tip_pachet='$tippachet' $newq order by pozitie");
}
else
{
if ($_GET['categorie']!=55 and $_GET['p50']!=1)
{
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' and produsFood=0 $newq order by pozitie");
}
else
if ($_GET['p50']==1)
{
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' and p50=1 $newq order by pozitie");
}
else
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' $newq order by pozitie");
if ($_GET['test']==1) echo "SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' and produsFood=0 $newq order by pozitie";
}
}
if ($tippachet==5 and $_SESSION['tara']=='ro')
{
if ($_SESSION['pachetseminar']>0 and date("Y-m-d")<='2020-04-20')
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse_bkp13apr2020_ok where tip_pachet='$tippachet' and pret_en=0 order by pozitie");
else
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' and pret_en=0 order by pozitie");
}
if ($tippachet==5 and $_SESSION['tara']!='ro')
{
if ($_SESSION['pachetseminar']>0 and date("Y-m-d")<='2020-04-20')
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse_bkp13apr2020_ok where tip_pachet='$tippachet' and pret_en>0 order by pozitie");
else
{
if ($_SESSION['tara']=='md')
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' and pret_mdl>0 order by pozitie");
else
$result=mysqli_query($con,"SELECT id,numebut,pret,pretinitial,copertafata,autoship,culoarebulina,textbulina,ambalare from produse where tip_pachet='$tippachet' and pret_en>0 order by pozitie");
}
}
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
if ($_GET['categorie']>0)
{
if (in_array($row['id'],$arr))
$text.=$prds->afisareprodus($row['id'],$row['numebut'],$row['copertafata'],$coperta2,$row['pret'],$row['pretinitial'],'Lei',$row['autoship'],$row['culoarebulina'],$row['textbulina'],$row['ambalare'],$tippachet,intval(mysqli_real_escape_string($con,$_GET['p50'])));
}
else $text.=$prds->afisareprodus($row['id'],$row['numebut'],$row['copertafata'],$coperta2,$row['pret'],$row['pretinitial'],'Lei',$row['autoship'],$row['culoarebulina'],$row['textbulina'],$row['ambalare'],$tippachet,intval(mysqli_real_escape_string($con,$_GET['p50'])));
// if ($afis7==0) $text=traducere(309);
return $text;
}
function paginaprodus($idp)
{
global $metas,$keywords,$description,$title,$continut,$scriptimag,$stilimag,$dir,$pozitionariabs,$scriptheader,$galerie,$config_facebook_page,$con,$lng,$imagineprodus;
$scriptheader.=' ';
if ($_SESSION['pachetseminar']>0 and date("Y-m-d")<='2020-04-20') $supliment='_bkp13apr2020_ok';
if ($_SESSION['pachetseminar']>0)
$result=mysqli_query($con,"SELECT * FROM produse$supliment where id='$idp' and lacerere=0 and afisare=0 and pret>0 and pachetSeminar=1 LIMIT 1");
else
$result=mysqli_query($con,"SELECT * FROM produse$supliment where id='$idp' and lacerere=0 and afisare=0 and pret>0 LIMIT 1");
if(mysqli_num_rows($result)!=NULL)
while ($rowi=mysqli_fetch_array($result))
{
$indisponibil=$rowi['indisponibil'];
if ($_SESSION['tara']=='md') $indisponibil=$rowi['indisponibilMD'];
$tipPachetProdus=$rowi['tip_pachet'];
$resultr=mysqli_query($con,"SELECT * from utilizatorii where id='".$_SESSION['login']."'");
if (mysqli_num_rows($result))
while ($rowr=mysqli_fetch_array($resultr))
{
if (date("Y-m")==date("Y-m",strtotime($rowr['datainregistrare'])))
{
$rez=mysqli_query($con,"SELECT * from comenzi_antet where idutilizator='".$_SESSION['login']."' LIMIT 1");
if (!mysqli_num_rows($rez)) $tippachet=2;
}
}
$afisCos=0;
if ($tippachet!=2 and $tipPachetProdus==2) $afisCos=1;
// $galerie.='';
$keywords=$rowi['keywords'.$lng];
$description=$rowi['description'.$lng];
$title=str_replace(' '," ",$rowi['titlu'.$lng]);
$continut.='
';
$continut.='
'.$rowi['numebut'.$lng];
if ($rowi['ambalare']!='')
$continut.=' - '.$rowi['ambalare'];
$continut.='
';
$continut.='
';
$alfa=0;
if ($rowi['copertafata']!='') {
$continut.=''; $alfa++;}
if ($rowi['copertaspate']!='') {
$continut.=''; $alfa++;}
if ($rowi['continut1']!='') {
$continut.=''; $alfa++;}
if ($rowi['continut2']!='') {
$continut.=''; $alfa++;}
if ($rowi['continut3']!='') {
$continut.=''; $alfa++;}
if ($rowi['continut4']!='') {
$continut.=''; $alfa++;}
if ($rowi['continut5']!='') {
$continut.=''; $alfa++;}
$continut.='
';
$imagineprodus=$rowi['copertafata'];
if ($alfa<3) $alfa=3;
$continut.='';
$continut.='
';
if ($rowi['textPromotie'.$lng]!='') $continut.='
'.$rowi['textPromotie'.$lng].'
';
$continut.='';
$continut.='
';
if ($idp!=982) $continut.=traducere(397);
$continut.='
';
if ($_SESSION['pentrucomanda']>0)
{
$rtg=mysqli_query($con,"SELECT client from utilizatorii where id='".$_SESSION['pentrucomanda']."' and client=1");
if (mysqli_num_rows($rtg)) $comandaClient=1;
}
$continut.='
'.$rowi['numebut'.$lng];
if ($rowi['ambalare']!='')
$continut.=' - '.$rowi['ambalare'];
$continut.='
';
if ($idp!=982){
if ($rowi['indisponibil']==0)
$continut.='
'.traducere(392,1).'
';
else $continut.='
'.traducere(393,1).'
';
} else $continut.=' ';
$continut.='
';
if ($rowi['cod']!='')
$continut.='
SKU: '.$rowi['cod'].'
';
$continut.='
';
if ($_SESSION['tara']=='ro')
{
if ($rowi['pretinitial']>0)
$continut.=' Pret vechi: '.$rowi['pretinitial'].' RON ';
if ($_SESSION['login']<1 or $_SESSION['client']==1 or $comandaClient==1) $continut.=' '.cnv($rowi['pretnologin'],$rowi['moneda'],$_SESSION['moneda']).' RON '.traducere(295,1).' ';
else
{
if ($_SESSION['pachetinscriere']==1)
$continut.=''.cnv($rowi['pretinscriere'],$rowi['moneda'],$_SESSION['moneda']).' RON '.traducere(295,1).'';
else
$continut.=''.cnv($rowi['pret'],$rowi['moneda'],$_SESSION['moneda']).' RON '.traducere(295,1).'';
}
}
if ($_SESSION['tara']!='ro' and $_SESSION['tara']!='md')
$continut.=' '.$rowi['pret_en'].' EUR '.$rowi['pret_en_fara_tva'].' EUR '.traducere(167,1).'';
if ($_SESSION['tara']=='md')
{
if ($rowi['pretinitial']>0)
$continut.=' Pret vechi: '.$rowi['pretinitial'].' MDL ';
if ($_SESSION['login']<1 or $_SESSION['client']==1 or $comandaClient==1) $continut.=' '.cnv($rowi['pretnologin_mdl'],$rowi['moneda'],$_SESSION['moneda']).' MDL '.traducere(295,1).' ';
else
{
if ($_SESSION['pachetinscriere']==1)
$continut.=''.cnv($rowi['pretinscriere_mdl'],$rowi['moneda'],$_SESSION['moneda']).' MDL '.traducere(295,1).'';
else
$continut.=''.cnv($rowi['pret_mdl'],$rowi['moneda'],$_SESSION['moneda']).' MDL '.traducere(295,1).'';
}
}
$continut.='
';
if ($_SESSION['login']>0)
if ($rowi['puncte']>0)
{
if ($_SESSION['client']!=1 and $_SESSION['fondator']!=1 and $comandaClient!=1)
{
if ($_SESSION['pachetinscriere']==1)
$continut.='
';
}
return $cont;
}
function produserecomandate($idp)
{
global $con;
$result=mysqli_query($con,"SELECT produse.id, produse.pret,produse.pretinitial,produse.numebut,produse.copertafata,produse.copertaspate from produse
INNER JOIN produse_recomandate on produse_recomandate.idasemanator=produse.id
WHERE produse_recomandate.idprodus='$idp'");
if (mysqli_num_rows($result))
{
$cont.='
';
$prds=new produse();
$alfa=0;
while ($row=mysqli_fetch_array($result))
{
$cont.=''.$prds->afisareprodus($row['id'],$row['numebut'],$row['copertafata'],$row['copertaspate'],$row['pret'],$row['pretinitial'],'ron').'';
$alfa++;
if ($alfa==4) {$continut.='
'; $alfa=0;}
}
$cont.='
';
}
return $cont;
}
}
?> data2ro - convertire data in format romanesc zz-ll-aaaa
-> checkEmail - functie pentru verificarea format-ului unui email
*/
function data2ro($text)
{
$exp=explode("-",$text);
return $exp[2].'-'.$exp[1].'-'.$exp[0];
}
function checkEmail($email)
{
if(eregi("^[a-zA-Z0-9_]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-\.]+$]", $email))
{
return FALSE;
}
else return TRUE;
}
function galeriejshome($id_sc_client)
{
//trebuie inclus jquery v.1.9.1
global $dir,$scriptheader,$con;
$scriptheader.='
';
$continut.='
';
$result=mysqli_query($con,"SELECT * FROM flash order by pozitie");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
{
if ($row['animatie']==0) $animatie='cube';
if ($row['animatie']==1) $animatie='cubeRandom';
if ($row['animatie']==2) $animatie='block';
if ($row['animatie']==3) $animatie='cubeStop';
$text='';
if (strlen($row['text'])>1) $text='
'.$row['text'].'
';
$link="#cube";
if (strlen($row['link'])>5) $link=$row['link'];
$continut.='
'.$text.'
';
}
$continut.='
';
return $continut;
}
?>inregistrare
*/
function nivelinregistrare($cui,$useractual,$cnp=1)
{
global $con;
$gasit=0;
$result=mysqli_query($con,"SELECT * from utilizatorii where id='$useractual' LIMIT 1");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
{
if ($gasit==0)
{
$rez=mysqli_query($con,"SELECT * from utilizatorii where cui_cnp='$cui'");
if (mysqli_num_rows($rez)) {$gasit=-1; }
}
if ($gasit==-1)
{
$expl=explode(';',$row['ierarhie']);
$n=count($expl);
for ($i=$n-1;$i>=0;$i--)
if ($expl[$i]>0)
{
$rez=mysqli_query($con,"SELECT * from utilizatorii where (cui_cnp='$cui') and id='".$expl[$i]."'");
if (!mysqli_num_rows($rez)) {$gasit++; }
else break;
}
}
if ($row['cui']==$cui and strlen($row['cui'])>1) $gasit=-1;
}
return $gasit;
}
function inretea($undeseinregistreaza,$cnp)
{
$gasit=-1;
global $con;
$arr=array();
$result=mysqli_query($con,"SELECT * from utilizatori_nivel where sub='$undeseinregistreaza'");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
{
$arr[$i]=$row['idutilizator'];
$i++;
}
$rez=mysqli_query($con,"SELECT * from utilizatorii where cui_cnp='$cnp'");
if (mysqli_num_rows($rez))
while ($row=mysqli_fetch_array($rez))
if (!in_array($row['id'],$arr)) $gasit=1;
// echo 'gasit1: '.$gasit.' ';
return $gasit;
}
function nivelinregistrarecnp($cnp,$useractual)
{
global $con;
$gasit=0;
$result=mysqli_query($con,"SELECT * from utilizatorii where id='$useractual' LIMIT 1");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
{
if ($gasit==0)
{
$rez=mysqli_query($con,"SELECT * from utilizatorii where cui_cnp='$cnp'");
if (mysqli_num_rows($rez)) {$gasit=-1;
$gasit=inretea($useractual,$cnp);
}
}
if ($gasit==-1)
{
$expl=explode(';',$row['ierarhie']);
$n=count($expl);
for ($i=$n-1;$i>=0;$i--)
{
if ($expl[$i]>0)
{
// echo "SELECT * from utilizatorii where cui_cnp='$cnp' and id='".$expl[$i]."' ";
$rez=mysqli_query($con,"SELECT * from utilizatorii where cui_cnp='$cnp' and id='".$expl[$i]."'");
if (!mysqli_num_rows($rez)) {
$gasit++;
// echo $gasit.'
';
}
else {
// echo mysqli_num_rows($rez).'
';
if ($gasit<3) $gasit=-1;
break;
}
}
}
}
if ($row['cui_cnp']==$cnp) $gasit=-1;
}
return $gasit;
}
function validCNP($p_cnp) {
// CNP must have 13 characters
if(strlen($p_cnp) != 13) {
return false;
}
$cnp = str_split($p_cnp);
unset($p_cnp);
$hashTable = array( 2 , 7 , 9 , 1 , 4 , 6 , 3 , 5 , 8 , 2 , 7 , 9 );
$hashResult = 0;
// All characters must be numeric
for($i=0 ; $i<13 ; $i++) {
if(!is_numeric($cnp[$i])) {
return false;
}
$cnp[$i] = (int)$cnp[$i];
if($i < 12) {
$hashResult += (int)$cnp[$i] * (int)$hashTable[$i];
}
}
unset($hashTable, $i);
$hashResult = $hashResult % 11;
if($hashResult == 10) {
$hashResult = 1;
}
// Check Year
$year = ($cnp[1] * 10) + $cnp[2];
switch( $cnp[0] ) {
case 1 : case 2 : { $year += 1900; } break; // cetateni romani nascuti intre 1 ian 1900 si 31 dec 1999
case 3 : case 4 : { $year += 1800; } break; // cetateni romani nascuti intre 1 ian 1800 si 31 dec 1899
case 5 : case 6 : { $year += 2000; } break; // cetateni romani nascuti intre 1 ian 2000 si 31 dec 2099
case 7 : case 8 : case 9 : { // rezidenti si Cetateni Straini
$year += 2000;
if($year > (int)date('Y')-14) {
$year -= 100;
}
} break;
default : {
return false;
} break;
}
return ($year > 1800 && $year < 2099 && $cnp[12] == $hashResult);
}
function validCIF($cif){
if (!is_numeric($cif)) return false;
if ( strlen($cif)>10 ) return false;
$cifra_control=substr($cif, -1);
$cif=substr($cif, 0, -1);
while (strlen($cif)!=9){
$cif='0'.$cif;
}
$suma=$cif[0] * 7 + $cif[1] * 5 + $cif[2] * 3 + $cif[3] * 2 + $cif[4] * 1 + $cif[5] * 7 + $cif[6] * 5 + $cif[7] * 3 + $cif[8] * 2;
$suma=$suma*10;
$rest=fmod($suma, 11);
if ( $rest==10 ) $rest=0;
if ($rest==$cifra_control) return true;
else return false;
}
class utilizatori
{
function logout()
{
global $dir,$scriptheader;
unset($_SESSION['calculatvplunaprecedenta']);
unset($_SESSION['afisatMessage']);
unset($_SESSION['pachetinscriere']);
unset($_SESSION['banidinpuncte']);
unset ($_SESSION['login']);
unset ($_SESSION['numelogin']);
unset ($_SESSION['idtara']);
unset ($_SESSION['cos']);
unset ($_SESSION['cant']);
unset ($_SESSION['culoare']);
unset ($_SESSION['idprodus']);
unset($_SESSION['client']);
unset ($_SESSION['marime']);
unset ($_SESSION['xcosttransport']);
unset($_SESSION['detaliinivel']);
unset ($_SESSION['fadresa']);
unset ($_SESSION['fobs']);
unset ($_SESSION['fpayment']);
unset ($_SESSION['fidtara']);
unset ($_SESSION['voucher']);
unset ($_SESSION['codvoucher']);
unset ($_SESSION['idvoucher']);
unset($_SESSION['hour']);
unset($_SESSION['hp']);
unset($_SESSION['localitate']);
unset($_SESSION['pentrucomanda']);
unset($_SESSION['pentrucomanda']);
unset($_SESSION['iscompany']);
unset($_SESSION['forcom']);
unset($_SESSION['vp']);
unset($_SESSION['vr']);
unset($_SESSION['vr2']);
unset($_SESSION['linii']);
unset($_SESSION['top']);
unset($_SESSION['reftip']);
unset($_SESSION['ref']);
unset($_SESSION['clasacomisionare']);
unset($_SESSION['fondator']);
unset($_SESSION['pjuridica']);
unset($_SESSION['numecompanie']);
unset($_SESSION['pachetseminar']);
unset($_SESSION['unread']);
unset($_SESSION);
header("Location: ".$dir);
/* $scriptheader.='';*/
}
function inregistrare()
{
global $dir,$con,$scriptheader,$config_email_from,$config_contact_email,$config_site_name,$config_adancime_retea,$client_register,$config_comanda_minima,$lng;
// if ($_SESSION['login']>-1)
{
$scriptheader.=' ';
$err=0;
if ($_POST['step']=='newregister')
{
if ($_POST['inrgg']==0) {
$emailfinal=$_POST['email3'];
if (strlen($_POST['email3'])<6) {$err=1; $ermesaj.=''.traducere(121,1).' '; $erremail=' style="border:1px solid red"';}
if (strlen($_POST['nume'])<3) {$err=1; $ermesaj.=''.traducere(122,1).' '; $errnume=' style="border:1px solid red"';}
if (strlen($_POST['prenume'])<3) {$err=1; $ermesaj.=''.traducere(123,1).' '; $errprenume=' style="border:1px solid red"';}
// if ($_SESSION['tara']=='ro')
// if (strlen($_POST['cnp'])!=13 or validCNP($_POST['cnp'])!=1) {$err=1; $ermesaj.=''.traducere(124,4).' '; $errcnp=' style="border:1px solid red"';}
if ($_SESSION['tara']!='ro')
{
// if (strlen($_POST['cnp'])<3) {$err=1; $ermesaj.=''.traducere(125,1).' '; $errcnp=' style="border:1px solid red"';}
if (strlen($_POST['codpostalpflivrare'])<3) {$err=1; $ermesaj2.=''.traducere(222,1).' ';$errcui=' style="border:1px solid red"';}
}
if (strlen($_POST['str'])<3) {$err=1; $ermesaj.=''.traducere(126,1).' '; $errstr=' border:1px solid red';}
if (strlen($_POST['telefon'])<10) {$err=1; $ermesaj.=''.traducere(127,1).' '; $errtel=' style="border:1px solid red"';}
if ($_POST['accept']!=1) {$err=1; $ermesaj.=''.traducere(128,1).' '; $errterms=' style="border:1px solid red"'; }
if ($_POST['acceptcolab']!=1 and $_POST['client']==0) {$err=1; $ermesaj.=''.traducere(129,1).' '; $errterms=' style="border:1px solid red"'; }
if ($_POST['gdpr1']!=1 and $_POST['client']==0) {$err=1; $ermesaj.=''.traducere(219,1).' '; $errterms=' style="border:1px solid red"'; }
if ($_POST['gdpr2']!=1 and $_POST['client']==0) {$err=1; $ermesaj.=''.traducere(220,1).' '; $errterms=' style="border:1px solid red"'; }
if ($_POST['identicpf']!=1)
{
// if (strlen($_POST['pfnume'])<3) {$err=1; $ermesaj.=''.traducere(130,1).' '; $errconfirmnume=' style="border:1px solid red"';}
// if (strlen($_POST['pfprenume'])<3) {$err=1; $ermesaj.=''.traducere(131,1).' '; $errconfirmprenume=' style="border:1px solid red"';}
if (strlen($_POST['pfstr'])<3) {$err=1; $ermesaj.=''.traducere(132,1).' '; $errconfirmstr=' border:1px solid red';}
if (strlen($_POST['telefon'])<10) {$err=1; $ermesaj.=''.traducere(133,1).' '; $errconfirmtel=' style="border:1px solid red"';}
}
}
if ($_POST['inrgg']==1)
{
$emailfinal=$_POST['email2'];
if (strlen($_POST['companie'])<3) {$err=1; $ermesaj2.=''.traducere(134,1).' '; $errcompanie=' style="border:1px solid red"';}
if (strlen($_POST['prenume2'])<3) {$err=1; $ermesaj2.=''.traducere(135,1).' '; $errprenume2=' style="border:1px solid red"';}
if (strlen($_POST['nume2'])<3) {$err=1; $ermesaj2.=''.traducere(136,1).' '; $errnume2=' style="border:1px solid red"';}
if ($_SESSION['tara']=='ro')
if ($_POST['cui']=='' or validCIF($_POST['cui'])!=true) {$err=1; $ermesaj2.=''.traducere(137,1).' ';$errcui=' style="border:1px solid red"';}
if ($_SESSION['tara']!='ro')
{
if (strlen($_POST['cui'])<3) {$err=1; $ermesaj2.=''.traducere(138,1).' ';$errcui=' style="border:1px solid red"';}
if (strlen($_POST['codpostalpjlivrare'])<3) {$err=1; $ermesaj2.=''.traducere(222,1).' ';$errcui=' style="border:1px solid red"';}
}
if (strlen($_POST['regcom'])<7 and $_SESSION['tara']=='ro') {$err=1; $ermesaj2.=''.traducere(139,1).' ';$errreg=' style="border:1px solid red"';}
if (strlen($_POST['pjstr'])<3) {$err=1; $ermesaj2.=''.traducere(140,1).' ';$errsediu=' border:1px solid red';}
if (strlen($_POST['email2'])<10) {$err=1; $ermesaj2.=''.traducere(141,1).' ';$erremail2=' style="border:1px solid red"';}
if (strlen($_POST['pjtelefon'])<10) {$err=1; $ermesaj2.=''.traducere(142,1).' ';$errpjtel=' style="border:1px solid red"';}
if (strlen($_POST['pjiban'])<24) {$err=1; $ermesaj2.=''.traducere(143,1).' ';$erriban=' style="border:1px solid red"';}
if ($_POST['identicpj']!=1)
{
//if (strlen($_POST['pjlivrarenume'])<3) {$err=1; $ermesaj2.=''.traducere(130,1).' '; $errconfirmnume2=' style="border:1px solid red"';}
//if (strlen($_POST['pjlivrareprenume'])<3) {$err=1; $ermesaj2.=''.traducere(131,1).' '; $errconfirmprenume2=' style="border:1px solid red"';}
if (strlen($_POST['pjlivrarestr'])<3) {$err=1; $ermesaj2.=''.traducere(132,1).' ';$errconfirmstr2=' border:1px solid red';}
if (strlen($_POST['pjlivraretelefon'])<10) {$err=1; $ermesaj2.=''.traducere(133,1).' ';$errconfirmtel2=' style="border:1px solid red"';}
}
if ($_POST['pjaccept']!=1) {$err=1; $ermesaj2.=''.traducere(128,1).' '; $errterms=' style="border:1px solid red"';}
if ($_POST['gdpr1']!=1) {$err=1; $ermesaj.=''.traducere(219,1).' '; $errterms=' style="border:1px solid red"'; }
if ($_POST['gdpr2']!=1) {$err=1; $ermesaj.=''.traducere(220,1).' '; $errterms=' style="border:1px solid red"'; }
if ($_POST['pjacceptcolab']!=1 and $_POST['client']==0 ) {$err=1; $ermesaj2.=''.traducere(129,1).' '; $errterms=' style="border:1px solid red"';}
}
if ($err==0) {
if ($_POST['inrgg']==0)
{
$result=mysqli_query($con,"SELECT * FROM utilizatorii where LOWER(email)='".strtolower(mysqli_escape_string($con,$_POST['email3']))."' LIMIT 1");
$emailtemporar=strtolower(mysqli_escape_string($con,$_POST['email3']));
if ($_POST['email3']!=$_POST['confirmemail3'])
{
$errstylenume=" style: border:1px solid red"; $err=1; $ermesaj=''.traducere(144,1).'';
$errconfirm=' style="border:1px solid red"';
}
}
if ($_POST['inrgg']==1)
{
$result=mysqli_query($con,"SELECT * FROM utilizatorii where LOWER(email)='".strtolower(mysqli_escape_string($con,$_POST['email2']))."' LIMIT 1");
$emailtemporar=strtolower(mysqli_escape_string($con,$_POST['email2']));
if ($_POST['email2']!=$_POST['confirmemail2'])
{
$errstylenume=" style: border:1px solid red"; $err=1; $ermesaj=''.traducere(144,1).'';
$errconfirm2=' style="border:1px solid red"';
}
}
if (mysqli_num_rows($result)!=NULL) {
while ($raq=mysqli_fetch_array($result))
if ($raq['temporar']==1) {
mysqli_query($con,"DELETE from utilizatorii where LOWER(email)='$emailtemporar'");}
else {
$errstylenume=" style: border:1px solid red"; $err=1; $ermesaj=''.traducere(145).'';
$erremail= ' style: "border:1px solid red"';
}
}
if ($err==0)
{
if ($_SESSION['login']<1)
if ($_POST['idpartenerajax']!='') {
$_SESSION['ref']=substr($_POST['idpartenerajax'],1,strlen($_POST['idpartenerajax']));
if (strtolower(substr($_POST['idpartenerajax'],0,1))=='c' and $client_register==1) $_SESSION['reftip']='client';
if (strtolower(substr($_POST['idpartenerajax'],0,1))=='p') $_SESSION['reftip']='colaborator';
}
if ($_SESSION['reftip']=='client' and $client_register==1) $ultimamodificare=1;
if ($_SESSION['ref']<1) $_SESSION['ref']=$_SESSION['login'];
if ($_POST['cui']!='' and $_SESSION['ref']>0)
{
$nivregister=nivelinregistrarecnp(mysqli_real_escape_string($con,$_POST['cui']),$_SESSION['ref']);
} else
if ($_POST['cnp']!='' and $_SESSION['ref']>0)
{
$nivregister=nivelinregistrarecnp(mysqli_real_escape_string($con,$_POST['cnp']),$_SESSION['ref']);
}
if ($nivregister==-1) {$err=1; $ermesaj2.=''.traducere(146).' ';}
if ($nivregister>0 and $nivregister<3) {$err=1; $ermesaj2.=''.traducere(147).' ';}
if ($_SESSION['ref']>0 and $err==0)
{
$rez=mysqli_query($con,"SELECT ierarhie from utilizatorii where id='".mysqli_real_escape_string($con,$_SESSION['ref'])."' LIMIT 1");
if (mysqli_num_rows($rez))
while ($row=mysqli_fetch_array($rez)) $vecheaierarhie=explode(';',$row['ierarhie']);
$ierarhie=$_SESSION['ref'].';';
$alfa=1;
$n=count($vecheaierarhie);
for ($i=$n-1;$i>=0;$i--)
if ($vecheaierarhie[$i]>0)
{
$ierarhie=$vecheaierarhie[$i].';'.$ierarhie;
$alfa++;
//if ($alfa==$config_adancime_retea) break;
}
}
if (strlen($ierarhie)<2) { $err=1; $ermesaj=''.traducere(148).' - office@freewaysintl.com';}
if ($err==0)
{
$pass=$_POST['pass'];
if ($pass=='') {$pass=''.rand(100,999).''.rand(0,9).''.rand(100,999).'';
$subject = ''.traducere(149,1).' ';
// Mesajul
$message = '
'.traducere(150,1).'
'.traducere(151).'
ID: '.$_POST['email'].'
'.traducere(152,1).' '.$pass.'
'.traducere(153).'
';
// Pentru a trimite mesaje HTML, trebuie stabilit antetul Content-type
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
// Antete suplimentare
$headers .= 'From: '.$config_email_from.' <'.$config_contact_email.'>' . "\r\n";
// Trimiterea mesajului
//mail(strtolower($emailfinal), $subject, $message, $headers);
}
if ($_POST['client']==1) {$ultimamodificare=1; $_SESSION['client']=1; $_SESSION['clientinreg']=1;}
if ($_POST['inrgg']==0) { $emailinreg=mysqli_escape_string($con,strtolower($_POST['email3'])); $datanasterii=$_POST['an'].'-'.$_POST['luna'].'-'.$_POST['zi'];}
if ($_POST['inrgg']==1) {$emailinreg=mysqli_escape_string($con,strtolower($_POST['email2'])); $datanasterii=$_POST['anj'].'-'.$_POST['lunaj'].'-'.$_POST['zij'];}
if ($_POST['inrgg']==0)
{ $act=md5($emailinreg.rand(0,100).date('Y-m-d h:i:s'));
$numecomplet=ucwords(mysqli_escape_string($con,strtolower($_POST['nume'])))." ".ucwords(mysqli_escape_string($con,strtolower($_POST['prenume'])));
mysqli_query($con,"INSERT into utilizatorii(genul,act,gdpr1,gdpr2,indicativtara,datanasterii,datainregistrare,
email,
parola,
nume,
prenume,
cnp,
telefon,
numebanca,
iban,
numecompanie,
codfiscal,
inmatriculare,
pjemail,
pjtelefon,
pjbanca,
pjiban,
tva,
ierarhie,
client,salariat,temporar,cui_cnp)
VALUES ('".ucwords(mysqli_escape_string($con,strtolower($_POST['genul'])))."','$act',1,1,'".$_SESSION['tara']."', '$datanasterii', '".date("Y-m-d")."',
'".$emailinreg."',
'".mysqli_escape_string($con,$pass)."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['nume'])))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['prenume'])))."',
'".mysqli_escape_string($con,$_POST['cnp'])."',
'".mysqli_escape_string($con,strtolower($_POST['telefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['banca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['iban']))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['companie'])))."',
'".mysqli_escape_string($con,strtolower($_POST['cui']))."',
'".mysqli_escape_string($con,strtolower($_POST['regcom']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjemail']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjtelefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjbanca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['pjiban']))."',
'".mysqli_escape_string($con,strtoupper($_POST['tva']))."',
'$ierarhie','".mysqli_escape_string($con,$ultimamodificare)."','".mysqli_escape_string($con,$_POST['salariat'])."','$config_comanda_minima','".mysqli_escape_string($con,$_POST['cnp'])."'
)");
$idutilizator=mysqli_insert_id($con);
mysqli_query($con,"INSERT into utilizatoriiComplet(genul,act,gdpr1,gdpr2,indicativtara,datanasterii,datainregistrare,
email,
parola,
nume,
prenume,
cnp,
telefon,
numebanca,
iban,
numecompanie,
codfiscal,
inmatriculare,
pjemail,
pjtelefon,
pjbanca,
pjiban,
tva,
ierarhie,
client,salariat,temporar,cui_cnp)
VALUES ('".ucwords(mysqli_escape_string($con,strtolower($_POST['genul'])))."','$act',1,1,'".$_SESSION['tara']."', '$datanasterii', '".date("Y-m-d")."',
'".$emailinreg."',
'".mysqli_escape_string($con,$pass)."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['nume'])))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['prenume'])))."',
'".mysqli_escape_string($con,$_POST['cnp'])."',
'".mysqli_escape_string($con,strtolower($_POST['telefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['banca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['iban']))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['companie'])))."',
'".mysqli_escape_string($con,strtolower($_POST['cui']))."',
'".mysqli_escape_string($con,strtolower($_POST['regcom']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjemail']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjtelefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjbanca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['pjiban']))."',
'".mysqli_escape_string($con,strtoupper($_POST['tva']))."',
'$ierarhie','".mysqli_escape_string($con,$ultimamodificare)."','".mysqli_escape_string($con,$_POST['salariat'])."','$config_comanda_minima','".mysqli_escape_string($con,$_POST['cnp'])."'
)");
$_SESSION['gdpr']='1-1';
}
if ($_POST['inrgg']==1)
{
$numecomplet=ucwords(mysqli_escape_string($con,strtolower($_POST['nume2'])))." ".ucwords(mysqli_escape_string($con,strtolower($_POST['prenume2'])));
$act=md5($emailinreg.rand(0,100).date('Y-m-d h:i:s'));
mysqli_query($con,"INSERT into utilizatorii(genul,act,gdpr1,gdpr2,indicativtara,datanasterii,datainregistrare,
email,
parola,
nume,
prenume,
cnp,
telefon,
numebanca,
iban,
numecompanie,
codfiscal,
inmatriculare,
pjemail,
pjtelefon,
pjbanca,
pjiban,
tva,
ierarhie,
client,temporar,cui_cnp)
VALUES ('".ucwords(mysqli_escape_string($con,strtolower($_POST['genul'])))."', '$act',1,1,'".$_SESSION['tara']."', '$datanasterii', '".date("Y-m-d")."',
'".$emailinreg."',
'".mysqli_escape_string($con,$pass)."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['nume2'])))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['prenume2'])))."',
'".mysqli_escape_string($con,$_POST['cnp'])."',
'".mysqli_escape_string($con,strtolower($_POST['telefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['banca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['iban']))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['companie'])))."',
'".mysqli_escape_string($con,strtolower($_POST['cui']))."',
'".mysqli_escape_string($con,strtolower($_POST['regcom']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjemail']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjtelefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjbanca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['pjiban']))."',
'".mysqli_escape_string($con,strtoupper($_POST['tva']))."',
'$ierarhie','".mysqli_escape_string($con,$_POST['client'])."','$config_comanda_minima','".mysqli_escape_string($con,strtolower($_POST['cui']))."'
)");
$idutilizator=mysqli_insert_id($con);
/*
Backup pentru conturile temporare
*/
mysqli_query($con,"INSERT into utilizatoriiComplet(genul,act,gdpr1,gdpr2,indicativtara,datanasterii,datainregistrare,
email,
parola,
nume,
prenume,
cnp,
telefon,
numebanca,
iban,
numecompanie,
codfiscal,
inmatriculare,
pjemail,
pjtelefon,
pjbanca,
pjiban,
tva,
ierarhie,
client,temporar,cui_cnp)
VALUES ('".ucwords(mysqli_escape_string($con,strtolower($_POST['genulj'])))."', '$act',1,1,'".$_SESSION['tara']."', '$datanasterii', '".date("Y-m-d")."',
'".$emailinreg."',
'".mysqli_escape_string($con,$pass)."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['nume2'])))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['prenume2'])))."',
'".mysqli_escape_string($con,$_POST['cnp'])."',
'".mysqli_escape_string($con,strtolower($_POST['telefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['banca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['iban']))."',
'".ucwords(mysqli_escape_string($con,strtolower($_POST['companie'])))."',
'".mysqli_escape_string($con,strtolower($_POST['cui']))."',
'".mysqli_escape_string($con,strtolower($_POST['regcom']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjemail']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjtelefon']))."',
'".mysqli_escape_string($con,strtolower($_POST['pjbanca']))."',
'".mysqli_escape_string($con,strtoupper($_POST['pjiban']))."',
'".mysqli_escape_string($con,strtoupper($_POST['tva']))."',
'$ierarhie','".mysqli_escape_string($con,$_POST['client'])."','$config_comanda_minima','".mysqli_escape_string($con,strtolower($_POST['cui']))."'
)");
$_SESSION['gdpr']='1-1';
}
$_SESSION['clientinreg']=mysqli_escape_string($con,$_POST['client']);
$_SESSION['pentrucomanda']=$idutilizator;
//relogare
if ($idutilizator>0)
{
$resultmx=mysqli_query($con,"SELECT * FROM utilizatorii where id='$idutilizator' and temporar=0 LIMIT 1");
if (@mysqli_num_rows($resultmx)!=NULL)
while ($rowi=mysqli_fetch_array($resultmx))
{
if ($rowi['status']==0)
{
$_SESSION['login']=$rowi['id'];
$_SESSION['numelogin']=$rowi['nume'].' '.$rowi['prenume'];
$_SESSION['prenumeclient']=$rowi['prenume'];
$_SESSION['idtara']=$rowi['idtara'];
$_SESSION['client']=$rowi['client'];
$_SESSION['clasacomisionare']=$rowi['clasacomisionare'];
$_SESSION['pjuridica']=$rowi['codfiscal'];
}
}
}
//end relogare
// $_SESSION['numelogin'].=$_POST['prenume'].' '.$_POST['nume'];
// $_SESSION['idtara']=$_POST['tara'];
if ($_POST['inrgg']==0) {
mysqli_query($con,"INSERT into utilizatori_adrese(codpostal,localitateitalia,regiuneitalia,indicativtara,idutilizator,idlocalitate,str,nrstr,bl,sc,ap,et,telefon,nume,prenume)
VALUES('".$_POST['codpostal']."','".$_POST['localitateitalia']."','".$_POST['regiuneitalia']."','".$_SESSION['tara']."','".$idutilizator."'
,'".mysqli_escape_string($con,$_POST['idlocalitate'])."'
,'".mysqli_escape_string($con,$_POST['str'])."'
,'".mysqli_escape_string($con,$_POST['nrstr'])."'
,'".mysqli_escape_string($con,$_POST['bl'])."'
,'".mysqli_escape_string($con,$_POST['sc'])."'
,'".mysqli_escape_string($con,$_POST['ap'])."'
,'".mysqli_escape_string($con,$_POST['et'])."'
,'".mysqli_escape_string($con,$_POST['telefon'])."'
,'".ucwords(strtolower(mysqli_escape_string($con,$_POST['nume'])))."'
,'".ucwords(strtolower(mysqli_escape_string($con,$_POST['prenume'])))."')");
$idfacturare=mysqli_insert_id($con);
mysqli_query($con,"INSERT into utilizatori_adrese(tipAdresa,codpostal,localitateitalia,regiuneitalia,indicativtara,idutilizator,idlocalitate,str,nrstr,bl,sc,ap,et,telefon,nume,prenume)
VALUES(1,'".$_POST['codpostalpflivrare']."','".$_POST['pflocalitateitalia']."','".$_POST['pfregiuneitalia']."','".$_POST['taralivrarepf']."','".$idutilizator."'
,'".mysqli_escape_string($con,$_POST['pflocalitate'])."'
,'".mysqli_escape_string($con,$_POST['pfstr'])."'
,'".mysqli_escape_string($con,$_POST['pfnrstr'])."'
,'".mysqli_escape_string($con,$_POST['pfbl'])."'
,'".mysqli_escape_string($con,$_POST['pfsc'])."'
,'".mysqli_escape_string($con,$_POST['pfap'])."'
,'".mysqli_escape_string($con,$_POST['pfet'])."'
,'".mysqli_escape_string($con,$_POST['pftelefon'])."'
,'".ucwords(strtolower(mysqli_escape_string($con,$_POST['pfnume'])))."'
,'".ucwords(strtolower(mysqli_escape_string($con,$_POST['pfprenume'])))."')");
$idlivrare=mysqli_insert_id($con);
}
if ($_SESSION['login']<1 and $config_comanda_minima==1) $_SESSION['login']=$idutilizator;
if ($idutilizator>0 and $config_comanda_minima==0)
{
$ruzz=mysqli_query($con,"SELECT * from utilizatorii where id='".$idutilizator."' LIMIT 1");
if (mysqli_num_rows($ruzz))
while ($randuzz=mysqli_fetch_array($ruzz))
{
$subject = ''.traducere(149,1).' ';
$zeros='';
for ($i=0;$i<(6-strlen($idutilizator));$i++)
$zeros.='0';
// Mesajul
if ($_POST['client']!=1)
$message = '
'.traducere(150,1).'
'.antetMail('www.freewaysintl.com').'
'.traducere(335).' '.footerMail().'
';
else $message = '
'.traducere(150,1).'
'.antetMail('www.freewaysintl.com').'
'.traducere(336).' '.footerMail().'
';
$idreplace=$zeros.''.$idutilizator;
$message=str_replace('{id}',$idreplace,$message);
$message=str_replace('{numecomplet}',$numecomplet,$message);
$message=str_replace('{clickhere}',$dir.'newpass/'.$act,$message);
// Pentru a trimite mesaje HTML, trebuie stabilit antetul Content-type
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
// Antete suplimentare
$headers .= 'From: '.$config_email_from.' <'.$config_contact_email.'>' . "\r\n";
// Trimiterea mesajului
mail($randuzz['email'], $subject, $message, $headers);
}
}
if ($_POST['inrgg']==1)
{
mysqli_query($con,"INSERT into utilizatori_adrese(codpostal,localitateitalia,regiuneitalia,indicativtara,idutilizator,idlocalitate,str,nrstr,bl,sc,ap,et,telefon,nume,prenume)
VALUES('".$_POST['codpostalpjlivrare']."','".$_POST['pjlocalitateitalia']."','".$_POST['pjregiuneitalia']."','".$_SESSION['tara']."','".$idutilizator."'
,'".mysqli_escape_string($con,$_POST['pjidlocalitate'])."'
,'".mysqli_escape_string($con,$_POST['pjstr'])."'
,'".mysqli_escape_string($con,$_POST['pjnrstr'])."'
,'".mysqli_escape_string($con,$_POST['pjbl'])."'
,'".mysqli_escape_string($con,$_POST['pjsc'])."'
,'".mysqli_escape_string($con,$_POST['pjap'])."'
,'".mysqli_escape_string($con,$_POST['pjet'])."'
,'".mysqli_escape_string($con,$_POST['pjtelefon'])."'
,'".mysqli_escape_string($con,$_POST['companie'])."'
,'".ucwords(strtolower(mysqli_escape_string($con,$_POST['pjprenume'])))."')");
$idpjfacturare=mysqli_insert_id($con);
mysqli_query($con,"INSERT into utilizatori_adrese(tipAdresa,codpostal,localitateitalia,regiuneitalia,indicativtara,idutilizator,idlocalitate,str,nrstr,bl,sc,ap,et,telefon,nume,prenume)
VALUES(1,'".$_POST['codpostalpjlivrare']."','".$_POST['pjlivrareidlocalitateitalia']."','".$_POST['regiuneitaliapjlivrare']."','".$_POST['tarapj']."', '".$idutilizator."'
,'".mysqli_escape_string($con,$_POST['pjlivrareidlocalitate'])."'
,'".mysqli_escape_string($con,$_POST['pjlivrarestr'])."'
,'".mysqli_escape_string($con,$_POST['pjlivrarenrstr'])."'
,'".mysqli_escape_string($con,$_POST['pjlivrarebl'])."'
,'".mysqli_escape_string($con,$_POST['pjlivraresc'])."'
,'".mysqli_escape_string($con,$_POST['pjlivrareap'])."'
,'".mysqli_escape_string($con,$_POST['pjlivrareet'])."'
,'".mysqli_escape_string($con,$_POST['pjlivraretelefon'])."'
,'".ucwords(strtolower(mysqli_escape_string($con,$_POST['pjlivrarenume'])))."'
,'".ucwords(strtolower(mysqli_escape_string($con,$_POST['pjlivrareprenume'])))."')");
$idpjlivrare=mysqli_insert_id($con);
mysqli_query($con,"UPDATE utilizatorii set idlivrare='$idlivrare',idfacturare='$idfacturare',idpjlivrare='$idpjlivrare',idpjfacturare='$idpjfacturare' where id='$idutilizator' LIMIT 1");
}
$insierarhie=explode(';',$ierarhie);
$n=count($insierarhie);
for ($i=$n-1;$i>=0;$i--)
if ($insierarhie[$i]>0)
{
mysqli_query($con,"INSERT into utilizatori_nivel(idutilizator,sub,nivel) VALUES ('".mysqli_real_escape_string($con,$insierarhie[$i])."','".$idutilizator."','".($n-$i-1)."')");
}
$actnow=md5(mysqli_insert_id($con).date("Y-m-d-H:i:s"));
mysqli_query($con,"INSERT into newsletter_emails(email,act) VALUES('".mysqli_escape_string($con,strtolower($_POST['email']))."','$actnow')");
if ($tip=='cart') header('Location: '.$dir.'cart/');
else
if ($_SESSION['login']>0)
{
if ($_SESSION['login']==$idutilizator) {
if ($config_comanda_minima==1)
{
if ($_SESSION['tara']=='ro')
{
if ($_SESSION['client']!=1)
$continut.='
';
if ($_SESSION['tara']!='ro' or $_SESSION['client']==1)
{
}
} else
{
$continut.='
'.traducere(157,1).'
';
if ($_SESSION['tara']!='ro' or $_SESSION['client']==1)
{ $continut.='
'.traducere(156,1).'
';
}
}
}
else {
if ($_SESSION['clientinreg']!=1)
{
if ($config_comanda_minima==1)
{
if ($_SESSION['tara']=='ro')
$continut.='
'.traducere(154).'
';
if ($_SESSION['tara']=='it')
$continut.='
'.traducere(155,1).'
';
}
else $continut.='
'.traducere(157,1).'
';
if ($_SESSION['tara']!='ro' or $_SESSION['client']==1)
{
$continut.='
'.traducere(156,1).'
';
$scriptheader.='';
}
}
else {
if ($config_comanda_minima==1)
$continut.='
'.traducere(155,1).'
';
else $continut.='
'.traducere(157,1).'
';
$continut.='
'.traducere(156,1).'
';
$scriptheader.='';
}
}
}
else {$err=1; $ermesaj.=''.traducere(148,1).' '; }
}
} }
}
if ($_POST['step']!='newregister') $err=1;
if ($err==1)
{
$scriptheader.=' ';
if ($_SESSION['login']<1)
{
if ($_POST['taranew']!='')
{
$result=mysqli_query($con,"SELECT * from steaguri where lower(indicativ)='".mysqli_real_escape_string($con,strtolower($_POST['taranew']))."' LIMIT 1");
if (mysqli_num_rows($result))
{
$_SESSION['tara']=strtolower($_POST['taranew']);
while ($row=mysqli_fetch_array($result)) $_SESSION['denumiretara']=$row['denumire'];
}
}
if (intval(substr($_POST['idpartenerajax'],1,strlen($_POST['idpartenerajax'])))<1) {$idpartenerajax=$_SESSION['ref']; $antecod=$_SESSION['reftip'];}
else {$idpartenerajax=substr($_POST['idpartenerajax'],1,strlen($_POST['idpartenerajax'])); $_SESSION['ref']=substr($_POST['idpartenerajax'],1,strlen($_POST['idpartenerajax']));
if (strtolower(substr($_POST['idpartenerajax'],0,1))=='c') $_SESSION['reftip']='client';
if (strtolower(substr($_POST['idpartenerajax'],0,1))=='p') $_SESSION['reftip']='colaborator';
}
if ($_SESSION['reftip']=='client') $antecod='C';
if ($_SESSION['reftip']=='colaborator') $antecod='P';
/*
Persoanele fizice nu pot inregistra clienti
if (strlen(checkfiscal($idpartenerajax))<3 and $_SESSION['reftip']=='client')
{
unset($_SESSION['ref']); unset($_SESSION['reftip']);
$idpartenerajax='';
$antecod='';
} */
if ($_SESSION['reftip']!='client' and $_SESSION['reftip']!='colaborator')
{
unset($_SESSION['ref']); unset($_SESSION['reftip']);
$idpartenerajax='';
$antecod='';
}
$_SESSION['ref']=intval($_SESSION['ref']);
$idpartenerajax= $_SESSION['ref'];
$rty=mysqli_query($con,"SELECT * from utilizatorii where id='$idpartenerajax' and client=0 and temporar=0 LIMIT 1");
if (!mysqli_num_rows($rty)) $clienterr=1;
if ( $clienterr==1)
{
unset($_SESSION['ref']); unset($_SESSION['reftip']);
$idpartenerajax='';
$antecod='';
}
if (strlen($antecod.$idpartenerajax)<2)
{
$continut.='
'.traducere(1,1).'
Freeways
';
}
$scriptheader.='';
if ($_POST['step']=='verifpartner' or $_SESSION['ref']>0)
{
include 'classes/checkpartner.php';
if (check_partner($antecod.$_SESSION['ref'])>0)
$scriptheader.=' ';
else {
$scriptheader.='
';
}
}
}
if ($_POST['step']=='newregister')
{
if ($_POST['client']==1)
{
$scriptheader.='
';
}
if ($_POST['inrgg']==0)
$scriptheader.='';
else $scriptheader.='';
}
else {
$scriptheader.='';
}
$rty=mysqli_query($con,"SELECT * from utilizatorii where id='$idpartenerajax' and client=0 and temporar=0 LIMIT 1");
if (mysqli_num_rows($rty))
{
while ($row=mysqli_fetch_array($rty)) $continut.='
';
$continut.='
';
if ($_SESSION['tara']=='ro')
{
$continut.='
';
}
if ($_SESSION['tara']!='ro')
{
$continut.='
';
}
$scriptheader.='';
$continut.='
';
if ($_SESSION['tara']=='ro')
$continut.=' ';
if ($_SESSION['tara']!='ro')
$continut.=' ';
$continut.='
';
$continut.='
'.traducere(91,1).' *
'.traducere(92,1).' *
'.traducere(93,1).'
'.traducere(94,1).'
'.traducere(95,1).'
'.traducere(96,1).'
'.traducere(601,1).'
';
if ($_SESSION['tara']=='ro')
$continut.='
'.traducere(602).'
';
$continut.='
';
$continut.='
'.traducere(404,1).'
';
/*
$continut.='
';
*/
$continut.='
'.traducere(103,1).'
';
// if ($_SESSION['tara']=='ro' or $_GET['testz']==1)
{
if ($_POST['identicpf']==1)
$continut.=' '.traducere(104,1).'';
else $continut.=' '.traducere(104,1).'';
}
$continut.='
';
$continut.='
';
/*
*/
$continut.='
';
$continut.='
';
$continut.='
';
$continut.='
';
$scriptheader.='';
$continut.='
';
$continut.='';
$continut.='
';
$continut.='
'.traducere(91,1).'
'.traducere(92,1).'
'.traducere(93,1).'
'.traducere(94,1).'
'.traducere(95,1).'
'.traducere(96,1).'
';
$continut.='
';
$continut.='
';
$continut.='
'.traducere(528,1).'
'.traducere(216).'
'.traducere(217).'
'.traducere(218).'
'.traducere(108).'
'.traducere(109).'
';
$continut.='
'.traducere(112,1).'
';
if ($_POST['tva']==1)
$continut.='
'.traducere(114,1).'
'.traducere(115,1).'
';
else $continut.='
'.traducere(114,1).'
'.traducere(115,1).'
';
$continut.='
'.traducere(117,1).'
';
$continut.='
';
$continut.='
';
if ($_SESSION['tara']=='ro')
{
$continut.='
';
}
if ($_SESSION['tara']!='ro')
{
$continut.='
';
}
$scriptheader.='';
$continut.='
';
if ($_SESSION['tara']=='ro')
$continut.='';
if ($_SESSION['tara']!='ro')
$continut.='';
$continut.='
';
$continut.='
'.traducere(91,1).'
'.traducere(92,1).'
'.traducere(93,1).'
'.traducere(94,1).'
'.traducere(95,1).'
'.traducere(96,1).'
'.traducere(601,1).'
';
if ($_SESSION['tara']=='ro')
$continut.='
'.traducere(602).'
';
$continut.='
';
$continut.='
'.traducere(404,1).'
'.traducere(120,1).'
';
/*
';
*/
$continut.='
'.traducere(87,1).':
'.traducere(88,1).':
'.traducere(89,1).':
'.traducere(103,1).'
';
// if ($_SESSION['tara']=='ro' or $_GET['testz']==1)
$continut.=' '.traducere(104,1).'
';
$continut.='
';
$continut.='
';
/*
*/
$continut.='
';
$continut.=' ';
$continut.=' ';
$continut.='
';
$scriptheader.='';
$continut.='
';
$continut.='
';
$continut.='
';
$continut.='
';
$continut.='
'.traducere(91,1).'
'.traducere(92,1).'
'.traducere(93,1).'
'.traducere(94,1).'
'.traducere(95,1).'
'.traducere(96,1).'
';
if ($_SESSION['tara']=='ro')
$continut.='
'.traducere(602).'
';
$continut.='
'.traducere(528,1).'
'.traducere(216).'
'.traducere(217).'
'.traducere(218).'
'.traducere(108).'
'.traducere(109).'
';
if ($_POST['step']=='verifpartner' or $_SESSION['ref']>0)
$continut.='
'.traducere(110,1).'
';
$continut.='
';
$scriptheader.='';
}
}
return $continut.'';
}
}
?>='".date("Y-m")."-01'");
if (mysqli_num_rows($rez))
{
while ($rand=mysqli_fetch_array($rez))
{
$idutilizator=$rand['idutilizator'];
$data=$rand['data'];
if ($_SESSION['admindate']!='') $data=$_SESSION['admindate'];
$pachetSeminar=$rand['pachetSeminar'];
$result=mysqli_query($con,"SELECT * from utilizatorii where id='$idutilizator'");
if (mysqli_num_rows($result))
while ($rand2=mysqli_fetch_array($result))
{
$tipuser=$rand2['client'];
$clasacomisionare=$rand2['clasacomisionare'];
$ierarhie=explode(';',$rand2['ierarhie']);
}
}
// pentru rezolvare bug - la calcul puncte se ia implicit clasa comisionare =1
$clasacomisionare=1;
//
$result=mysqli_query($con,"SELECT * from comenzi_linii where idcomanda='$idcomanda'");
if (mysqli_num_rows($result))
while ($row=mysqli_fetch_array($result))
{
$sumapuncte+=$row['puncte']*$row['cantitate'];
}
// echo 'Suma puncte: '.$sumapuncte.'
';
mysqli_query($con,"DELETE from puncte where idcomanda='$idcomanda'");
$n=count($ierarhie);
if ($pachetSeminar==1 or $_SESSION['pachetseminar']==1) $sumapuncte=20;
if ($pachetSeminar==2 or $_SESSION['pachetseminar']==2) $sumapuncte=50;
if ( $tipuser==0 )
{$puncteinsert=$sumapuncte*$config_procent_linii[$clasacomisionare][0]/100;
$idierarhie=$idutilizator;
$myalfa=0;
}
else {$puncteinsert=$sumapuncte*$config_procent_linii[$clasacomisionare][-1000]/100;
$idierarhie=$ierarhie[$n-2];
$myalfa=-1000;
}
if ($puncteinsert>0)
{
mysqli_query($con,"INSERT into puncte(puncte,idutilizator,primitedela,idcomanda,data,procentprimit,valoarepunct,nivel,puncteclient)
VALUES('$puncteinsert','".$idierarhie."', '$idutilizator','$idcomanda','$data','".$config_procent_linii[$clasacomisionare][$myalfa]."','1.5','0','$tipuser')");
}
$alfa=1;
for ($i=$n-(2+$tipuser);$i>=0;$i--)
if ($ierarhie[$i]>0)
{
$puncteinsert=$sumapuncte*$config_procent_linii[$clasacomisionare][$alfa]/100;
//echo $ierarhie[$i].': '.$config_procent_linii[$clasacomisionare][$alfa].'%='.$puncteinsert.' ';
if ($puncteinsert>0)
{
//corectare bug cu clasa comisionare
$clasacomisionarecustom=0;
$resultz=mysqli_query($con,"SELECT * from utilizatorii where id='".$ierarhie[$i]."'");
if (mysqli_num_rows($resultz))
while ($rand2=mysqli_fetch_array($resultz))
{
$clasacomisionarecustom=$rand2['clasacomisionare'];
}
//end corectare bug cu clasa comisionare
if ($config_procent_linii[$clasacomisionarecustom][$alfa]>0)
mysqli_query($con,"INSERT into puncte(puncte,idutilizator,primitedela,idcomanda,data,procentprimit,valoarepunct,nivel)
VALUES('$puncteinsert','".$ierarhie[$i]."', '$idutilizator','$idcomanda','$data','".$config_procent_linii[$clasacomisionare][$alfa]."','1.5','$alfa')");
}
$alfa++;
}
} }
?>
'.traducere(169,1).'
'.traducere(170,1).'
'.traducere(171,1).'
'.traducere(172,1).'
';
$resultpr=mysqli_query($con,"SELECT * from comenzi_linii where idcomanda='".$comenzi['id']."'");
if (mysqli_num_rows($resultpr))
while ($linii=mysqli_fetch_array($resultpr))
{
$result=mysqli_query($con,"SELECT * FROM produse where id='".$linii['idprodus']."' LIMIT 1");
if (mysqli_num_rows($result)!=NULL)
{
while ($rowi=mysqli_fetch_array($result))
{ $discountpaf=0;
$pretafisat=$linii['pret'];
$cnt.='
'.$rowi['numebut'].' ';
if ($_SESSION['fondator']==1 and $rowi['1plus1']==1) $cnt.='(1+1)';
if ($_SESSION['client']!=1 and $_SESSION['fondator']!=1 and $pachetSeminar==0) $cnt.='Puncte: '.$linii['puncte'].' ';
else $cnt.=' ';
$cnt.='
';
$cnt.=$linii['cantitate'];
if ($comenzi['tara']=='ro')
$cnt.='
'.formatbani($pretafisat).' RON
'.formatbani($pretafisat*$linii['cantitate']).' RON
'.$linii['numeprodus'].' ';
if ($_SESSION['fondator']==1 and $rowi['1plus1']==1) $cnt.='(1+1)';
// if ($_SESSION['client']!=1 and $_SESSION['fondator']!=1) $cnt.='Puncte: '.$linii['puncte'].' ';
// else
$cnt.=' ';
$cnt.='
';
$cnt.=$linii['cantitate'];
if ($comenzi['tara']=='ro')
$cnt.='
'.formatbani($pretafisat).' RON
'.formatbani($pretafisat*$linii['cantitate']).' RON
'.formatbani($comenzi['valoare']-$redvoucher-$valfinaladisc+$xcosttransport).' RON
';
/*
if ($_SESSION['client']==0 and $_SESSION['fondator']!=1)
{
if (($_SESSION['client']!=1 or $_SESSION['clientinreg']!=1) and checkclient($_SESSION['pentrucomanda'])!=1)
$cnt.='
';
/*
if ($_SESSION['client']==0 and $_SESSION['fondator']!=1)
{
if (($_SESSION['client']!=1 or $_SESSION['clientinreg']!=1) and checkclient($_SESSION['pentrucomanda'])!=1)
$cnt.='
Puncte
'.$comenzi['puncte'].'
';
} */
}
$rga=mysqli_query($con,"SELECT afisare from afisare where id=2 limit 1");
if (mysqli_num_rows($rga))
while ($rowi=mysqli_fetch_array($rga))
if ($rowi['afisare']==1)
{
$rtr=mysqli_query($con,"SELECT * FROM discounturi where id=1 limit 1");
if (mysqli_num_rows($rtr))
while ($rowiz=mysqli_fetch_array($rga))
$costmintransport=$rowiz['sumatransportgratis'];
}
$cnt.='
';
/*
$cnt.='
';
if ($comenzi['valoare']<$sumatransportgratis) $cnt.='Comandati de inca '.round($sumatransportgratis-$comenzi['valoare'],2).' RON si beneficiati de transport gratis';
*/
}
return $cnt;
}
function mailcomanda($act)
{
global $prodname,$dir,$con,$scriptheader,$lng;
$resultcm=mysqli_query($con,"SELECT * from comenzi_antet where act='$act' LIMIT 1");
if (mysqli_num_rows($resultcm))
while ($comenzi=mysqli_fetch_array($resultcm))
{
$pachetSeminar=$comenzi['pachetSeminar'];
$antetmesaj=traducere(348);
$antetmesaj=str_replace('{id}',$comenzi['idutilizator'],$antetmesaj);
$antetmesaj=str_replace('{numarcomanda}',$comenzi['id'],$antetmesaj);
$rezzz=mysqli_query($con,"SELECT * from utilizatorii where id='".$comenzi['idutilizator']."' LIMIT 1");
if(mysqli_num_rows($rezzz))
while ($rand=mysqli_fetch_array($rezzz))
$antetmesaj=str_replace('{numecomplet}',$rand['prenume'].' '.$rand['nume'],$antetmesaj);
$cnt.=$antetmesaj.'
'.traducere(169,1).'
'.traducere(170,1).'
'.traducere(171,1).'
'.traducere(172,1).'
';
$resultpr=mysqli_query($con,"SELECT * from comenzi_linii where idcomanda='".$comenzi['id']."'");
if (mysqli_num_rows($resultpr))
while ($linii=mysqli_fetch_array($resultpr))
{
$result=mysqli_query($con,"SELECT * FROM produse where id='".$linii['idprodus']."' LIMIT 1");
if (mysqli_num_rows($result)!=NULL)
{
while ($rowi=mysqli_fetch_array($result))
{ $discountpaf=0;
$pretafisat=$linii['pret'];
$cnt.='
'.$rowi['numebut'].' ';
if ($_SESSION['fondator']==1 and $rowi['1plus1']==1) $cnt.='(1+1)';
if ($_SESSION['client']!=1 and $_SESSION['fondator']!=1 and $pachetSeminar==0) $cnt.='Puncte: '.$linii['puncte'].' ';
else $cnt.=' ';
$cnt.='
';
$cnt.=$linii['cantitate'];
if ($comenzi['tara']=='ro')
$cnt.='
'.formatbani($pretafisat).' RON
'.formatbani($pretafisat*$linii['cantitate']).' RON
'.$linii['numeprodus'].' ';
if ($_SESSION['fondator']==1 and $rowi['1plus1']==1) $cnt.='(1+1)';
// if ($_SESSION['client']!=1 and $_SESSION['fondator']!=1) $cnt.='Puncte: '.$linii['puncte'].' ';
// else
$cnt.=' ';
$cnt.='
';
$cnt.=$linii['cantitate'];
if ($comenzi['tara']=='ro')
$cnt.='
'.formatbani($pretafisat).' RON
'.formatbani($pretafisat*$linii['cantitate']).' RON
'.formatbani($comenzi['valoare']-$redvoucher-$valfinaladisc+$xcosttransport).' RON
';
/*
if ($_SESSION['client']==0 and $_SESSION['fondator']!=1)
{
if (($_SESSION['client']!=1 or $_SESSION['clientinreg']!=1) and checkclient($_SESSION['pentrucomanda'])!=1)
$cnt.='
';
/*
if ($_SESSION['client']==0 and $_SESSION['fondator']!=1)
{
if (($_SESSION['client']!=1 or $_SESSION['clientinreg']!=1) and checkclient($_SESSION['pentrucomanda'])!=1)
$cnt.='
Puncte
'.$comenzi['puncte'].'
';
} */
if ($_SESSION['client']==0)
$cnt.='
'.traducere(363,1).'
'.$comenzi['puncte'].'
';
}
if ($comenzi['tara']!='ro' and $comenzi['tara']!='md')
{
$cnt.='
';
/*
if ($_SESSION['client']==0 and $_SESSION['fondator']!=1)
{
if (($_SESSION['client']!=1 or $_SESSION['clientinreg']!=1) and checkclient($_SESSION['pentrucomanda'])!=1)
$cnt.='
Puncte
'.$comenzi['puncte'].'
';
} */
if ($_SESSION['client']==0)
$cnt.='
'.traducere(363,1).'
'.$comenzi['puncte'].'
';
}
$rga=mysqli_query($con,"SELECT afisare from afisare where id=2 limit 1");
if (mysqli_num_rows($rga))
while ($rowi=mysqli_fetch_array($rga))
if ($rowi['afisare']==1)
{
$rtr=mysqli_query($con,"SELECT * FROM discounturi where id=1 limit 1");
if (mysqli_num_rows($rtr))
while ($rowiz=mysqli_fetch_array($rga))
$costmintransport=$rowiz['sumatransportgratis'];
}
$cnt.='
'.traducere(349).'
';
/*
$cnt.='
';
if ($comenzi['valoare']<$sumatransportgratis) $cnt.='Comandati de inca '.round($sumatransportgratis-$comenzi['valoare'],2).' RON si beneficiati de transport gratis';
*/
}
return $cnt;
}
?>
FreewaysIntl
