Skip to content

Instantly share code, notes, and snippets.

@zurivy-myval

zurivy-myval/slimwine_showcase

Created May 11, 2015 17:38
Show Gist options
  • Save zurivy-myval/db0bf7ad09420acdc71c to your computer and use it in GitHub Desktop.
Save zurivy-myval/db0bf7ad09420acdc71c to your computer and use it in GitHub Desktop.
Download ZIP
Slimwine - class_customer.php
Raw
slimwine_showcase
<?
require ($_SESSION['absolute_path'] . 'class_customer.php');
class customer extends customer_basic
/*contains all functions which can be performed by customer in this e-shop*/
{ // BEGIN class customer
function create_cart()
{ //BEGIN function create_cart
/*by the law, all visitors must get unique id_session, which will be stored with IP adress in table SESSIONS and added to order, if processed*/
if ($_SESSION['id']<>"")
{return false;break;} //if alredy inicialized
$id=$this->generate_session_id(); //generates unique (checks if not used) id_session
$ip=$_SERVER['REMOTE_ADDR']; //gets IP adress
//save session into database and crate a cart
$query = 'INSERT INTO '.$_SESSION['database'].'_sessions(id_session, IP, date) values ("' . $id . '", "' . $ip . '", NOW())';
//$result = mysql_query($query, $this->link);
$_SESSION['id']=$id;
$_SESSION['price']=0.0;
$_SESSION['ct_rate']=1;
$_SESSION['ct_name']='standard';
$_SESSION['ct_color']='#121212';
$_SESSION['payment_cost']=0;
$_SESSION['spedition_cost']=0;
$_SESSION['id_payment']=0;
$_SESSION['id_spedition']=0;
$_SESSION['show_state']='all';
$_SESSION['show_name']=VSECHNY;
$_SESSION['show_dph']=$this->get_const('SHOP_DPH');//Zobrazování DPH v celém e-shopu
$m_query='SELECT id_module FROM eshops_modules WHERE id_eshop='.$_SESSION['id_eshop'].' AND module_name="store" AND (expiration>="'.date('Y-m-d').'" OR expiration="0000-00-00")';
$m_result=mysql_query($m_query,$this->link);
if(mysql_num_rows($m_result)>0):
$_SESSION['store_module']=1;
else:
$_SESSION['store_module']=0;
endif;
$m_query='SELECT id_module FROM eshops_modules WHERE id_eshop='.$_SESSION['id_eshop'].' AND module_name="paypal" AND (expiration>="'.date('Y-m-d').'" OR expiration="0000-00-00")';
$m_result=mysql_query($m_query,$this->link);
if(mysql_num_rows($m_result)>0):
$_SESSION['paypal_module']=1;
else:
$_SESSION['paypal_module']=0;
endif;
$m_query='SELECT id_module FROM eshops_modules WHERE id_eshop='.$_SESSION['id_eshop'].' AND module_name="filters" AND (expiration>="'.date('Y-m-d').'" OR expiration="0000-00-00")';
$m_result=mysql_query($m_query,$this->link);
if(mysql_num_rows($m_result)>0):
$_SESSION['filter_module']=1;
else:
$_SESSION['filter_module']=0;
endif;
if ($result) return true;
else return false;
} //END function create_cart
/*Funkce referalů*/
function set_referal($jmeno){
$c_query = 'SELECT id_customer,jmeno_f,prijmeni_f,nazev_f FROM '.$_SESSION['database'].'_customers WHERE LOWER(id_customer)="' . strtolower($jmeno) . '" OR LOWER(login_customer)="' . strtolower($jmeno) . '" OR LOWER(email1)="' . strtolower($jmeno) . '"';
$c_result = mysql_query($c_query, $this->link);
if (mysql_num_rows($c_result)<>1):
return('<div id="error">'.SPATNY_REFERAL.'</div>');
endif;
$customer = mysql_fetch_assoc($c_result);
$referal_name=$customer['jmeno_f'] . ' ' . $customer['prijmeni_f'];
if ($customer['nazev_f']<>''):
$referal_name.='('.$customer['nazev_f'].')';
endif;
$_COOKIE['referal']=$jmeno;
$_COOKIE['referal_name']=$referal_name;
$_COOKIE['id_referal']=$customer['id_customer'];
setcookie('referal', $jmeno, time()+60*60*24*30,'/');//Nastavíme na 30 dní
setcookie('referal_name', $referal_name, time()+60*60*24*30,'/');//Nastavíme na 30 dní
setcookie('id_referal', $customer['id_customer'], time()+60*60*24*30,'/');//Nastavíme na 30 dní
return('uspech');
}
function insert_referal($new_id_customer,$id_new_parent){
//if ($id_new_parent>0):
$ch_query='SELECT id_customer FROM '.$_SESSION['database'].'_customers WHERE id_customer="' . $id_new_parent . '"';
$ch_result=mysql_query($ch_query,$this->link);
if (mysql_num_rows($ch_result)==1)://Referal existuje
$id_parent=mysql_result($ch_result, 0, 'id_customer');
$i_query='INSERT INTO `'.$_SESSION['database'].'_affiliate_backup` (`id_customer`,`id_parent`) VALUES ('.$new_id_customer.', '.$id_parent.')';
$i_result=mysql_query($i_query,$this->link);
/*Zde vložíme do tabulky affiliate pro snazší dotazy na databázi*/
$max_level_query='SELECT max(id_level) as max FROM '.$_SESSION['database'].'_levels';
$max_level_result=mysql_query($max_level_query,$this->link);
$max_level=mysql_result($max_level_result, 0, 'max');
$il_query='INSERT INTO `'.$_SESSION['database'].'_affiliate` (`id_customer`,`id_parent`,`id_level`) VALUES ('.$new_id_customer.', '.$id_parent.', 1)';
$il_result=mysql_query($il_query,$this->link);
for($level=2;$level<=$max_level;$level++):
$ch_l_query='SELECT id_parent FROM '.$_SESSION['database'].'_affiliate WHERE id_customer='.$id_parent.' AND id_level='.($level-1);
$ch_l_result=mysql_query($ch_l_query,$this->link);
if (mysql_num_rows($ch_l_result)==1):
$level_parent=mysql_result($ch_l_result,0,'id_parent');
$ilx_query='INSERT INTO `'.$_SESSION['database'].'_affiliate` (`id_customer`,`id_parent`,`id_level`) VALUES ('.$new_id_customer.', '.$level_parent.', '.$level.')';
$ilx_result=mysql_query($ilx_query,$this->link);
endif;
endfor;
endif;
$u_query='UPDATE '.$_SESSION['database'].'_customers SET id_parent='.$id_parent.' WHERE id_customer='.$new_id_customer;
$u_result=mysql_query($u_query,$this->link);
//endif;
}
function show_my_referal(){
if (!$this->check_login()):return('<div id="error">'.AFF_PRIHLASENI.'</div>');endif;
$seznam_referalu='';
$min_vyplata=200;
$total_num=0;
$total_sum=0;
$total_sum_clenstvi=0;
$total_sum_provize=0;
$total_vyplaty=0;
$max_level_query='SELECT max(id_level) as max FROM '.$_SESSION['database'].'_levels';
$max_level_result=mysql_query($max_level_query,$this->link);
$max_level=mysql_result($max_level_result, 0, 'max');
if ($_SESSION['expiration']<=date('Y-m-d')):
$return.='<div style="text-align:center;">
<br /><br /><h1>'.AFF_H1.'</h1><br /><br />
<br />
<a href="'.$this->create_href('objednat-clenstvi').'" style="display:inline-block;width:270px;margin-left:0px;background-color:#66CC00;border-radius:10px;font-size:40px;color:#fff;padding:15px 15px 15px 15px;position:relative;">'.AFF_ROK.'</a>
<a href="'.$this->create_href('eshop',1,1,1).'" style="display:inline-block;width:270px;margin-left:50px;background-color:#FF3333;border-radius:10px;font-size:40px;color:#fff;padding:15px 15px 15px 15px;position:relative;">'.AFF_JEDN.'</a>
<br /><br /><br />
<p style="font-size: 40px">SLIM WINE</p>
<p style="font-size: 18px">'.AFF_T1.'</p>
<strong style="font-size: 22px">'.AFF_T2.'</strong>
<br /><br />
<img src="img/aff_logo.png" alt="SLIM WINE" style="height:180px" />
<br /><br /><br />
<strong style="font-size: 22px">'.AFF_T3.'</strong>
<br /><br />
<p style="font-size:22px">
'.AFF_T4.'
</p>
<br />
<a href="'.$this->create_href('objednat-clenstvi').'"><img src="img/slimwine_party.jpg" alt="SLIM WINE" style="width:300px" /></a>
</div>';
$return.='';
return($return);
endif;
$return='<h1>'.BK_T1.'</h1>';
$return.='<p style="font-size:20px;">'.BK_CLENSTVI_DO.' ' . date('j.n.Y',strtotime($_SESSION['expiration'])) . '</p>';
$return.='<div class="spacer" style="height:10px">&nbsp;</div>';
$return.='
<p style="font-size:20px;">'.BK_T2.'</p>
<p style="margin:15px;font-size:22px;color:#66CC00;text-align:center;">http://www.slimwine.cz/?ref='.$_SESSION['id_customer'].'</p>
<p>'.BK_VASE_ID.' <strong style="font-size:36px;color:#ff3300;">'.$_SESSION['id_customer'].'</strong></p>';
$return.='<div class="spacer" style="height:15px">&nbsp;</div>';
$return.='<table cellpadding="5" cellspacing="0" style="width:600px;float:left;">
<tr><th colspan="4" style="text-align:center;"><h2 style="color:#FACC17;">'.BK_PROVIZE.'</h2></th></tr>
<tr><th style="padding-right:5px" colspan="2">Level</th><th style="padding:5px" align="center">'.BK_LIDI.'</th><th style="padding-left:5px" align="right">'.BK_PROVIZE_CLENSTVI.'</th><th style="padding-left:5px" align="right">'.BK_PROVIZE_NAKUPY.'</th></tr>';
for($level=1;$level<=$max_level;$level++):
$ref_query='SELECT COUNT(*) AS pocet,l.provize,l.provize_clenstvi FROM '.$_SESSION['database'].'_levels AS l,'.$_SESSION['database'].'_affiliate AS a WHERE a.id_level=l.id_level AND a.id_parent='.$_SESSION['id_customer'].' AND l.id_level='.$level;
$ref_result=mysql_query($ref_query,$this->link);
$referal_data=mysql_fetch_assoc($ref_result);
$p_query='SELECT SUM(castka) AS soucet,sum(lahvi) as pocet FROM '.$_SESSION['database'].'_provize AS p WHERE p.id_level='.$level.' AND p.id_customer='.$_SESSION['id_customer'] . ' AND p.provize>0';
$p_result=mysql_query($p_query,$this->link);
$pc_query='SELECT SUM(castka) AS soucet FROM '.$_SESSION['database'].'_provize AS p WHERE p.id_level='.$level.' AND p.id_customer='.$_SESSION['id_customer'] . ' AND p.provize_clenstvi>0';
$pc_result=mysql_query($pc_query,$this->link);
$c_query='SELECT c.id_customer,c.login_customer,c.jmeno_f,c.prijmeni_f,c.expiration,c.lahvi FROM '.$_SESSION['database'].'_customers AS c,'.$_SESSION['database'].'_affiliate AS a WHERE c.id_customer=a.id_customer AND a.id_parent='.$_SESSION['id_customer'].' AND a.id_level='.$level . ' ORDER BY (c.expiration>NOW()) DESC,c.id_customer';
$c_result=mysql_query($c_query,$this->link);
$provize=mysql_result($p_result,0,'soucet');
$provize_lahvi=mysql_result($p_result,0,'pocet');
$provize_clenstvi=mysql_result($pc_result,0,'soucet');
$total_num+=$referal_data['pocet'];
$total_sum_clenstvi+=$provize_clenstvi;
$total_sum_provize+=$provize;
$return.='<tr><td colspan="2">'.$level.'</td><td style="text-align:center;">'.$referal_data['pocet'].'</td><td style="text-align:right;">'.$this->format_admin_price($provize_clenstvi).' ('.($referal_data['provize_clenstvi']*100).'%)</td><td style="text-align:right;">'.$this->format_admin_price($provize).' ('.($referal_data['provize']*100).'%)</td></tr>';
if (mysql_num_rows($c_result)>0):
$seznam_referalu.='<tr><th align="center" colspan="14" style="font-size:22px;margin-top:20px;">'.$level.'. Level</th></tr>';
$seznam_referalu.='<tr><td>'.JMENO.'</td>';
$year=date('Y');
$month=date('m');
for($i=11;$i>=0;$i--):
$month_curr=$month-$i;
if ($month_curr<1):$month_curr+=12;$year_curr=$year-1;else:$year_curr=$year;endif;
$seznam_referalu.='<td>'.$month_curr.'/'.$year_curr.'</td>';
endfor;
$seznam_referalu.='<td>'.BK_LAHVI.'</td></tr>';
$seznam_level='';
while($customer=mysql_fetch_assoc($c_result)):
$seznam_level.='<tr><td class="jmeno"><span style="background-color:';if($customer['expiration']>=date('Y-m-d')):$seznam_level.='#CCFFCC';else:$seznam_level.='#FFDDDD';endif;$seznam_level.='"><strong>' . $customer['id_customer']. '</strong>';
if ($level==1 || $level==2):
$seznam_level.=' - ' . $customer['jmeno_f'] . ' ' . iconv('cp1250', 'utf-8',substr(iconv('utf-8', 'cp1250', $customer['prijmeni_f']), 0, 1)) . '.';
else:
$seznam_level.=' - ' . $customer['jmeno_f'] . '';
endif;
$seznam_level.='</span></td>'.$this->show_lahvi($customer['id_customer'],$level).'<td>'.$customer['lahvi'].'</td></tr> ' . "\n";
endwhile;
$seznam_level=substr($seznam_level, 0, -2);
$seznam_referalu.=$seznam_level;
$seznam_referalu.='';
endif;
endfor;
$return.='<tr><td style="border-top:1px solid black;font-weight:bold;" colspan="2">'.BK_TOTAL.':</td><td style="border-top:1px solid black;text-align:center;font-weight:bold;">'.$total_num.'</td><td style="border-top:1px solid black;text-align:right;font-weight:bold;">'.$this->format_admin_price($total_sum_clenstvi).'</td><td style="border-top:1px solid black;text-align:right;font-weight:bold;">'.$this->format_admin_price($total_sum_provize).'</td></tr>';
$return.='</table>';
$return.='<table cellpadding="5" cellspacing="0" style="width:400px;float:right;padding-right:20px;">
<tr><th colspan="3"style="text-align:center;"><h2 style="color:#FACC17;">'.BK_VYPLATY.'</h2></th></tr>
<tr><th style="padding:5px">'.BK_DATUM.'</th><th align="center">'.BK_STAV.'</th><th style="padding-left:5px;text-align:center;">'.BK_UCET.'</th><th style="padding-left:5px;text-align:right;">'.BK_VYPLATA.'</th></tr>';
$v_query='SELECT * FROM '.$_SESSION['database'].'_vyplaty WHERE id_customer='.$_SESSION['id_customer'];
$v_result=mysql_query($v_query,$this->link);
while ($vyplata=mysql_fetch_assoc($v_result)):
if ($vyplata['vyplacena']==1):
$total_vyplaty+=$vyplata['castka'];
$vyplacena='<span style="color:#009900;">'.BK_VYPLACENA.'</span>';
else:
$total_nevyplaceno+=$vyplata['castka'];
$vyplacena='<span style="color:#D6000F;">'.BK_NEVYPLACENA.'</span>';
endif;
$return.='<tr><td>'.date('j.n.Y', strtotime($vyplata['datum'])) .'</td><td align="center">'.$vyplacena.'</td><td style="text-align:center;">'.$vyplata['ucet'].'</td><td style="text-align:right;">'.$this->format_admin_price($vyplata['castka']).'</td></tr>';
endwhile;
if (mysql_num_rows($v_result)>0):
$return.='<tr><td style="border-top:1px solid black;font-weight:bold;" colspan="2">Celkem výplaty:</td><td style="border-top:1px solid black;text-align:right;" colspan="2">'.$this->format_admin_price($total_vyplaty).'</td><td></td></tr>';
else:
$return.='<td><td colspan="3" style="color:#009900;">'.BK_NO_VYPLATY.'</td></tr>';
endif;
$return.='</table>';
$cekem_plus=$total_sum_clenstvi+$total_sum_provize;
$return.='<div class="spacer" style="height:15px">&nbsp;</div>';
$return.='<h2>'.BK_CELKOVY_STAV.': '.$this->format_admin_price($cekem_plus-$total_vyplaty);
if ($total_nevyplaceno>0):
$return.=' (možno požádat o: '.$this->format_admin_price($cekem_plus-$total_vyplaty-$total_nevyplaceno).')';
endif;
$return.='</h2>';
/*if (($cekem_plus-$total_vyplaty-$total_nevyplaceno)>=$min_vyplata):
$c_query='SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='.$_SESSION['id_customer'];
$c_result=mysql_query($c_query,$this->link);
$customer=mysql_fetch_assoc($c_result);
$return.='<form action="'.$this->create_href('vyplatit').'" method="post">
<table>
<tr><td>Vyplatit částku:</td><td><input type="text" name="castka" size="25" value="'.round($cekem_plus-$total_vyplaty-$total_nevyplaceno,2).'" /></td></tr>
<tr><td>Na účet (nebo název Paypal účtu):</td><td><input type="text" name="ucet" size="25" value="'.$customer['bank_ucet'].'" /></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="Podat žádost" /></td></tr>
</table>
</form>';
else:
$return.='O vyplacení částky je možné požádat při překročení '.$min_vyplata.'Kč.';
endif;*/
if ($seznam_referalu<>''):
$return.='<div class="spacer" style="height:10px;">&nbsp;</div>';
$return.='<table class="lahve">';
$return.='<tr><th align="center" colspan="14">'.BK_MOJE_LAHVE.'</th></tr>';
$return.='<tr><td>'.JMENO.'</td>';
$year=date('Y');
$month=date('m');
for($i=11;$i>=0;$i--):
$month_curr=$month-$i;
if ($month_curr<1):$month_curr+=12;$year_curr=$year-1;else:$year_curr=$year;endif;
$return.='<td>'.$month_curr.'/'.$year_curr.'</td>';
endfor;
$return.='<td>'.BK_LAHVI.'</td></tr>';
$c_query='SELECT c.id_customer,c.login_customer,c.jmeno_f,c.prijmeni_f,c.expiration,c.lahvi FROM '.$_SESSION['database'].'_customers AS c WHERE c.id_customer='.$_SESSION['id_customer'];
$c_result=mysql_query($c_query,$this->link);
while($customer=mysql_fetch_assoc($c_result)):
$return.='<tr><td class="jmeno"><span style="background-color:';if($customer['expiration']>=date('Y-m-d')):$return.='#CCFFCC';else:$return.='#FFDDDD';endif;$return.='"><strong>' . $customer['id_customer']. '</strong>';
$return.=' - ' . $customer['jmeno_f'] . ' ' . $customer['prijmeni_f'] . '';
$return.='</span></td>'.$this->show_lahvi($customer['id_customer'],$level).'<td>'.$customer['lahvi'].'</td></tr> ' . "\n";
endwhile;
$return.=$seznam_referalu;
$return.='</table>';
endif;
//Kontrolní nápočet počtu láhví k jednotlivým provizím
/*$ch_query='SELECT distinct o.id_order from slimwine_orders o
left join '.$_SESSION['database'].'_order_states os on o.id_state=os.id_state
where os.in_stats=1 and o.expiration_end<"1000-00-00"';
$ch_result=mysql_query($ch_query,$this->link);
while ($ch=mysql_fetch_assoc($ch_result)):
$o_sum_query='SELECT SUM(oi.quantity) as pocet FROM '.$_SESSION['database'].'_ordered_items as oi left join '.$_SESSION['database'].'_orders as o on oi.id_order=o.id_order
where o.id_order='.$ch['id_order'];
$o_sum_result=mysql_query($o_sum_query,$this->link);
$sum=mysql_fetch_assoc($o_sum_result);
$u_query='update slimwine_provize set lahvi = ' . $sum['pocet'] . ' where id_order='.$ch['id_order'];
$u_result=mysql_query($u_query,$this->link);
endwhile;*/
$return.='<br /><br />
<a href="'.$this->create_href('objednat-clenstvi').'" style="text-align:center;display:block;width:270px;margin-left:-150px;background-color:#66CC00;border-radius:10px;font-size:40px;color:#fff;padding:15px 15px 15px 15px;position:relative;left:50%;" onclick="return(confirm(\''.BK_PRODLOUZIT_POTVRDIT.'\'))">'.BK_PRODLOUZIT.'</a>';
return($return);
}
function show_lahvi($id_customer,$level){
$year=date('Y');
$month=date('m');
for($i=11;$i>=0;$i--):
$month_curr=$month-$i;
if ($month_curr<1):$month_curr+=12;$year_curr=$year-1;else:$year_curr=$year;endif;
if ($month_curr<10):$month_curr='0'. $month_curr;endif;
$o_sum_query='SELECT SUM(oi.quantity) as pocet FROM '.$_SESSION['database'].'_ordered_items as oi left join '.$_SESSION['database'].'_orders as o on oi.id_order=o.id_order left join '.$_SESSION['database'].'_order_states os on o.id_state=os.id_state
where os.in_stats=1 and o.id_customer='.$id_customer.' and o.expiration_end<"1000-00-00"
and o.order_date LIKE ("'.$year_curr.'-'.$month_curr.'%")';
//if ($id_customer==34):echo $o_sum_query;endif;
$o_sum_result=mysql_query($o_sum_query,$this->link);
$lahvi=mysql_fetch_assoc($o_sum_result);
$o_cle_query='SELECT id_order FROM '.$_SESSION['database'].'_orders as o left join '.$_SESSION['database'].'_order_states os on o.id_state=os.id_state
where os.in_stats=1 and o.id_customer='.$id_customer.' and o.expiration_end>"2010-00-00"
and o.order_date LIKE ("'.$year_curr.'-'.$month_curr.'%")';
$o_cle_result=mysql_query($o_cle_query,$this->link);
if($lahvi['pocet']>=2):$class='ok';else:$class='n';endif;
if (mysql_num_rows($o_cle_result)>0):
$return.='<td class="'.$class.'" title="'.BK_ZAPLATIL_CLENSTVI.'">'.round($lahvi['pocet']).'<span class="clenstvi_ok">*</span></td>';
else:
$return.='<td class="'.$class.'">'.round($lahvi['pocet']).'</td>';
endif;
endfor;
/*echo $o_sum_query='SELECT o.id_order,o.castka,p.* FROM '.$_SESSION['database'].'_provize as p left join '.$_SESSION['database'].'_orders as o on p.id_order=o.id_order left join '.$_SESSION['database'].'_order_states os on o.id_state=os.id_state
where os.in_stats=1 and o.id_customer='.$id_customer.' and o.expiration_end<"1000-00-00" and p.level='.$level;
echo '<br /><br />';*/
$o_sum_query='SELECT SUM(oi.quantity) as pocet FROM '.$_SESSION['database'].'_ordered_items as oi left join '.$_SESSION['database'].'_orders as o on oi.id_order=o.id_order left join '.$_SESSION['database'].'_order_states os on o.id_state=os.id_state
where os.in_stats=1 and o.id_customer='.$id_customer.' and o.expiration_end<"1000-00-00"';
$o_sum_result=mysql_query($o_sum_query,$this->link);
$lahvi=mysql_fetch_assoc($o_sum_result);
$u_query='UPDATE '.$_SESSION['database'].'_customers SET lahvi="'.$lahvi['pocet'].'" WHERE id_customer='.$id_customer;
$u_result=mysql_query($u_query,$this->link);
return ($return);
}
function zadost_o_vyplatu($castka,$ucet){
$v_query='SELECT SUM(castka) AS total_vyplaty FROM '.$_SESSION['database'].'_vyplaty WHERE id_customer='.$_SESSION['id_customer'];
$v_result=mysql_query($v_query,$this->link);
$vyplaty=mysql_result($v_result,0,'total_vyplaty');
$p_query='SELECT SUM(castka) AS soucet FROM '.$_SESSION['database'].'_provize AS p WHERE p.id_customer='.$_SESSION['id_customer'];
$p_result=mysql_query($p_query,$this->link);
$provize=mysql_result($p_result,0,'soucet');
if (($provize-$vyplaty+0.01)>=$castka):
$i_query='INSERT INTO `'.$_SESSION['database'].'_vyplaty` (`id_customer`, `vyplacena`, `castka`, `ucet`) VALUES ('.$_SESSION['id_customer'].', 0, '.$castka.',"'.$ucet.'")';
$i_result=mysql_query($i_query,$this->link);
$return='<div id="error" style="color:#33CC00;border-color:#33CC00;">'.BK_VYPLATA_POZADAVEK_OK.'</div>';
else:
$return='<div id="error">'.BK_VYPLATA_POZADAVEK_NOOK.'</div>';
endif;
return($return);
}
function login ($login, $password)
{ //BEGIN function login
//finds user in a database and if valid then start session and log user in
$query = 'select * from '.$_SESSION['database'].'_customers where (id_customer="' . $login . '" OR login_customer="' . $login . '" OR email1="'.$login.'") AND (password_customer="'.sha1($password).'" OR password_customer="'.$password.'")';
//$query = 'select * from '.$_SESSION['database'].'_customers where (id_customer="' . $login . '" OR login_customer="' . $login . '" OR email1="'.$login.'") AND (password_customer="'.sha1($password).'")';
$result = mysql_query($query, $this->link);
if (mysql_num_rows($result)<>1):return('<div id="error">Kombinace ID a hesla nebyla v databázi nalezena. Prosíme zkontrolujte zadané údaje a zkuste to prosím znovu.</div>');endif;
$customer=mysql_fetch_array($result);
//if ($customer['password_customer']<>sha1($password)):return ('<div id="error">' . SPATNE_HESLO . '</div>');endif;
$_SESSION['id_customer']=$customer['id_customer']; //stores id_customer in session (to reduce database connections)
/*V závislosti na typu zákazníka mu přiřadíme modifikátor cen v e-shopu*/
/*$ct_query='SELECT * FROM '.$_SESSION['database'].'_customer_types WHERE id_ct=' . $customer['id_ct'];
$ct_result=mysql_query($ct_query,$this->link);
if ($ct_result):
$ct=mysql_fetch_assoc($ct_result);
$_SESSION['ct_rate']=$ct['ct_rate'];
$_SESSION['ct_name']=$ct['ct_name'];
$_SESSION['ct_color']=$ct['ct_color'];
endif;*/
/*Konec přiřazení modifikátoru cen*/
if ($customer['nazev_f']<>""):
$_SESSION['name']=$customer['nazev_f'];
else:
$_SESSION['name']=$customer['jmeno_f'] . ' ' . $customer['prijmeni_f'];
endif;
$_SESSION['login_customer']=$customer['login_customer'];
$_SESSION['expiration']=$customer['expiration'];
if ($_SESSION['expiration']>=date('Y-m-d')):
$_SESSION['clen']=1;
$_SESSION['ct_rate']=1;
else:
$_SESSION['clen']=0;
if (($customer['id_parent']>3 && is_numeric($customer['id_parent'])) || $customer['id_parent']==1):
$_SESSION['ct_rate']=0.85;
else:
$_SESSION['ct_rate']=1;
endif;
endif;
if ($customer['platce_dph']==1):$_SESSION['show_dph']=0;else:$_SESSION['show_dph']=1;endif;
//store login in table login
$query = "insert into ".$_SESSION['database']."_logins(ip, id_customer) values ('".$_SERVER['REMOTE_ADDR']."', '$_SESSION[id_customer]')";
$result = mysql_query($query, $this->link);
//uložení aktuálního obsahu košíku, pokud existuje do databáze a následně se načte obsah košíku do session
if(is_array($_SESSION['cart'])):
$cart = $_SESSION['cart'];
foreach($cart as $id_item=>$array)
{
$quantity=$array['quantity'];
if ($quantity!=0):
/*Ověříme, zda tam již daná věc není, když ne, tak ji přidáme, když ano, tak pouze upravíme množství*/
$check_query = 'SELECT * FROM '.$_SESSION['database'].'_preorder WHERE id_item=' . $id_item . ' AND id_specific="' . $id_specific . '" AND id_customer=' . $_SESSION['id_customer'];
$check_result = mysql_query($check_query, $this->link);
if (mysql_num_rows($check_result)==0): //pokud je již v databázi, upraví se pouze množství, jinak se vloží nový řádek
$insert='INSERT INTO '.$_SESSION['database'].'_preorder (`id_customer`,`id_item`,`quantity`,`interni_kod`) values ("' . $_SESSION['id_customer'] . '","' . $id_item . '","' . $id_specific . '","' . $quantity . '","' . $_SESSION[$id_item]['kod'] . '")';
$i_result=mysql_query($insert, $this->link);
else:
$update = 'UPDATE '.$_SESSION['database'].'_preorder SET quantity="' . $quantity . '" WHERE id_item="' . $id_item . '" AND id_customer="' . $_SESSION['id_customer'] . '"';
$u_result = mysql_query($update, $this->link);
endif;
endif;
}
endif;
/*A nyní načteme všechny záznamy z databáze a uložíme je do SESSION a přepočteme celkovou cenu*/
$load_query = 'SELECT * FROM '.$_SESSION['database'].'_preorder WHERE id_customer=' . $_SESSION['id_customer'];
$load_result = mysql_query($load_query,$this->link);
while ($load=mysql_fetch_array($load_result)):
//echo 'Přidávám produkt číslo:' . $load['id_item'];
$this->add_cart($load['id_item'],$load['quantity']);
/* $_SESSION['cart'][$load['id_item']]['quantity']=$load['quantity'];
$_SESSION['cart'][$load['id_item']]['kod']=$load['interni_kod'];*/
endwhile;
$this->calculate_price();
$return='<div id="error" style="color:#339933;border-color:#339933;text-align:center;border-radius:6px;font-size: 26px;">'.LOGIN_WELCOME.'</div>';
return ($return);
} //END function login
function show_registration_form($error=0,$login_customer="",$newsletter="on",$podminky="",$nazev_f="", $jmeno_f="", $prijmeni_f="" ,$ulice_f="",$psc_f="",$obec_f="",$stat_f="",$nazev_p="",$jmeno_p="",$prijmeni_p="",$ulice_p="",$psc_p="",$obec_p="",$stat_p="",$ico="",$dic="",$platce_dph="",$bank_ucet="",$bank_kod="",$bank_variable="",$spec_symb="",$kategorie="",$email1="",$email2="",$telef1="",$telef2="",$mobil1="",$mobil2="",$fax1="",$fax2="")
{//BEGIN function show_registration_form
/*Na základě vstupních údajů vypíše buď prázdný nebo již předvyplněný formulář na registraci. Chybné vyplnění je kontrolováno ve funkci registration.*/
$return = '
<h2 style="color:#33CC33;margin: 10px 0 10px 0;text-align:center;font-size: 26px;">'.SLIMWINE_REGISTRACE.'</h2>
<h1>'.SLIMWINE_NOVY_CLEN.'</h1>
<div>' . REGISTRACE_INFORMACE . '</div><br />
<form id="registration" action="' . $this->create_href('registruj') . '" method="post" enctype="multipart/form-data">
<table>
<tr><td colspan="4" title="' . FAKTURACNI_INFO . '"><h2>' . FAKTURACNI_ADRESA . ':</h2></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long" title="" maxlength="100" type="text" placeholder="'.NEPOVINNE.'" name="nazev_f" value="' . $nazev_f . '" /></td></tr>
<tr><td class="required">' . JMENO . ':</td><td><input class="required" type="text" maxlength="50" name="jmeno_f" value="' . $jmeno_f . '" /></td><td class="required">' . PRIJMENI . ':</td><td><input type="text" class="required right" maxlength="50" name="prijmeni_f" value="' . $prijmeni_f . '" /></td></tr>
<tr><td class="required">' . ULICE . ':</td><td><input class="required" type="text" maxlength="50" name="ulice_f" value="' . $ulice_f . '" /></td><td class="required">' . MESTO . ':</td><td><input type="text" class="required right" maxlength="50" name="obec_f" value="' . $obec_f . '" /></td></tr>
<tr><td class="required">' . PSC . ':</td><td><input class="required" type="text" maxlength="6" name="psc_f" value="' . $psc_f . '" /></td><td class="required">' . STAT . ':</td><td><select name="stat_f" class="required right" onchange="platce(this.value);" id="stat_select">' . $this->states_options() . '</select></td></tr>
<tr><td>' . IC . ':</td><td><input type="text" maxlength="12" name="ico" placeholder="'.NEPOVINNE.'" value="' . $ico . '" /></td><td>' . DIC . ':</td><td><input class="right" type="text" maxlength="50" name="dic" placeholder="'.NEPOVINNE.'" value="' . $dic . '" /></td></tr>
';
if ($platce_dph==1):
$return.='<tr id="platce_note"><td>'.PLATCE_DPH.'</td><td><select name="platce_dph"><option value="0">'.PLATCE_NE.'</option><option value="1" selected="selected">'.PLATCE_ANO.'</option></select></td><td colspan="2">'.PLATCE_NOTE.'</td></tr>';
else:
$return.='<tr id="platce_note" style="display:none;"><td>'.PLATCE_DPH.'</td><td><select name="platce_dph"><option value="0">'.PLATCE_NE.'</option><option value="1">'.PLATCE_ANO.'</option></select></td><td colspan="2">'.PLATCE_NOTE.'</td></tr>';
endif;
$return.='
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4" title="' . DODACI_ADRESA_LONG . '"><h2>' . DODACI_ADRESA . ':</h2></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long" maxlength="100" type="text" name="nazev_p" placeholder="'.NEPOVINNE.'" value="' . $nazev_p . '" /></td></tr>
<tr><td>' . JMENO . ':</td><td><input maxlength="50" type="text" name="jmeno_p" value="' . $jmeno_p . '" /></td><td>' . PRIJMENI . ':</td><td><input class="right" maxlength="50" type="text" name="prijmeni_p" value="' . $prijmeni_p . '" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input maxlength="50" type="text" name="ulice_p" value="' . $ulice_p . '" /></td><td>' . MESTO . ':</td><td><input class="right" maxlength="50" type="text" name="obec_p" value="' . $obec_p . '" /></td></tr>
<tr><td>' . PSC . ':</td><td><input maxlength="6" type="text" name="psc_p" value="' . $psc_p . '" /></td><td>' . STAT . ':</td><td><select class="right" name="stat_p">' . $this->states_options(0,$stat_p) . '</select></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>' . OSTATNI_UDAJE . ':</h2></td></tr>
<tr><td class="required">' . EMAIL . ':</td><td><input class="required" type="text" maxlength="40" name="email1" value="' . $email1 . '" /></td><td>' . MOBIL . ':</td><td><input type="text" class="right" maxlength="20" name="mobil1" value="' . $mobil1 . '" /></td></tr>';
if($newsletter=="on"):
$return.= '<tr><td>' . NOVINKY_AKCE . ':</td><td><input type="checkbox" name="newsletter" checked="checked" /></td><td>&nbsp;</td><td>&nbsp;</td></tr>';
else: $return.= '<tr><td>' . NOVINKY_AKCE . ':</td><td><input type="checkbox" name="newsletter" /></td><td>&nbsp;</td><td>&nbsp;</td></tr>';
endif;
$return.= '<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>'.REG_BKSW.':</h2></td></tr>
<tr><td class="required" style="width:30%;">'.REG_ID_DOP.':</td><td colspan="3"><input class="long required" type="text" maxlength="50" name="affiliate" value="' . $_COOKIE['id_referal'] . '" /></td></tr>
<tr><td class="required">'.REG_CISLO_UCTU.':</td><td colspan="3"><input class="long required" type="text" maxlength="50" name="bank_ucet" value="'.$_POST['bank_ucet'].'" /></td></tr>
';
$return.= '<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>' . PRIHLASOVACI_UDAJE . ':</h2></td></tr>
<tr><td class="required">' . LOGIN_PASS_LONG . ':</td><td colspan="3"><input class="long required" type="password" name="password_customer1" maxlength="20" value="" /></td></tr>
<tr><td class="required">' . LOGIN_POTVRZENI . ':</td><td colspan="3"><input class="long required" type="password" name="password_customer2" maxlength="20" value="" /></td></tr>
<tr><td colspan="4" style="height:12px;">&nbsp;</td></tr>';
if($podminky=="on"):
$return.= '<tr><td colspan="4" class="required"><input type="checkbox" name="podminky" checked="checked" style="width:auto;" /> <a href="'.$this->create_href('obchodni-podminky').'" onclick="this.target=\'_blank\'">&larr; ' . SOUHLAS . '</a></td></tr>';
else: $return.= '<tr><td colspan="4" class="required"><input type="checkbox" name="podminky" checked="checked" style="width:auto;" /> <a href="'.$this->create_href('obchodni-podminky').'" onclick="this.target=\'_blank\'">&larr; ' . SOUHLAS . '</a></td></tr>';
endif;
$return.= '
<tr><td colspan="4" style="height:12px;">&nbsp;</td></tr>
<tr><td colspan="4"><input type="submit" name="' . REGISTROVAT . '" value="' . REGISTROVAT . '" /></td></tr>
</table>
</form>
<script type="text/javascript">
function platce(value){
if (value=="Česká republika"){
document.getElementById("platce_note").style.display="none";
}
else{
document.getElementById("platce_note").style.display="table-row";
}
}
</script>
';
return $return;
}//END function show_registration_form
function register($login_customer,$password_customer1,$password_customer2,$newsletter, $podminky,$nazev_f,$jmeno_f,$prijmeni_f,$ulice_f,$psc_f,$obec_f,$stat_f,$nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$psc_p,$obec_p,$stat_p,$ico,$dic,$platce_dph,$bank_ucet,$bank_kod,$var_symbol,$spec_symb,$kategorie,$email1,$email2,$telef1,$telef2,$mobil1,$mobil2,$fax1,$fax2)
{//BEGIN function register
/*Nejprve zkontroluje, zda byli zadány správné údaje. Pokud ne, tak zavolá funkci show registration form s příslušnými
parametry. Pokud je vše v pořádku, zapíše zákazníka do databáza a na jeho adresu odešle uvítací e-mail a volitelně také
na adresu provozovatele e-shopu. Nakonec daného uživatele přihlásí do systému.*/
/*Kontrola zaslaných informací*/
$psc_f=str_replace(' ', '', $psc_f);
$psc_p=str_replace(' ', '', $psc_p);
$name='<span style="color:red;">';
$error=0;
$login_customer=$email1;
//ověření jedinečnosti loginu
$query = 'select * from '.$_SESSION['database'].'_customers where login_customer="'. $login_customer . '"';
$result = mysql_query($query, $this->link);
if (mysql_num_rows($result)<>0):$error=6; $name.= POUZITE_JMENO . '<br />';endif;
$query = 'select * from '.$_SESSION['database'].'_customers where email1="'. $email1 . '"';
$result = mysql_query($query, $this->link);
if (mysql_num_rows($result)<>0):$error=9; $name.= REG_E1.'<br />';endif;
//konec ověření jedinešnosti loginu
//if (strlen($login_customer)<5):$error=1;$name.= KRATKE_JMENO . '<br />';endif; //krátké přihlašovací jméno
if (strlen($password_customer1)<5):$error=2;$name.=KRATKE_HESLO . '<br />';endif; //krátké heslo
if ($password_customer1<>$password_customer2):$error=3;$name.= RUZNA_HESLA . '<br />';endif; //hesla nejsou stejná
if ($jmeno_f=="" || $prijmeni_f=="" || $ulice_f=="" || $psc_f=="" || $obec_f==""):$error=4;$name.= NEKOMPLETNI_FAKTURACNI_ADRESA . '<br />';endif; //nezadaná fakturační adresa
if ($email1=="" && $email2==""):$error=5;$name.=NO_EMAIL . '<br />';endif; //nazadán žádný e-mail
/*if (!filter_var($email1, FILTER_VALIDATE_EMAIL)):
$error=6;$name.=REG_E2.'<br />';
endif; */
if ($podminky<>on):$error=7;$name.=NO_SOUHLAS . '<br />';endif; //Nesouhlasí s obchodními podmínkami
if (strlen($bank_ucet)<5):$error=9;$name.='Prosíme vyplňte číslo účtu pro výplatu provizí<br />';endif; //Nesouhlasí s obchodními podmínkami
if ($nazev_f<>"" && $ico==""):$error=8;$name.= NO_IC . '<br />';endif; //Firma, která nezadala svoje IČ
if ($_POST['affiliate']=="" || !is_numeric($_POST['affiliate'])):
$error=8;$name.= REG_E3.'<br />';
else:
$this->set_referal($_POST['affiliate']);
/*print_r($_COOKIE);
echo '<br /><br />'.$_POST['affiliate'];*/
endif; //Firma, která nezadala svoje IČ
$name.='</span><br />';
//V případě chyby se navrátí příslušné chyby a zobrazí se znovu registrační formulář
if ($error<>0): return ('<div id="error">' . $name . '</div>' . $this->show_registration_form($name,$login_customer,$newsletter,$podminky,$nazev_f,$jmeno_f, $prijmeni_f,$ulice_f,$psc_f,$obec_f,$stat_f,$nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$psc_p,$obec_p,$stat_p,$ico,$dic,$platce_dph,$bank_ucet,$bank_kod,$bank_variable,$spec_symb,$kategorie,$email1,$email2,$telef1,$telef2,$mobil1,$mobil2,$fax1,$fax2));endif;
/*Konec kontroly informací*/
/*Převod informací z select a checkbox na formát pro vložení do databáze*/
//if ($platce_dph==on): $platce_dph=1; else:$platce_dph=0; endif;
if ($newsletter==on): $newsletter=1; else:$newsletter=0; endif;
$psc_f=str_replace(' ', '', $psc_f);
$psc_p=str_replace(' ', '', $psc_p);
if ($stat_f=='Česká republika'):
$platce_dph=0;
endif;
/*Konec převodu informací*/
/*Zápis do databáze*/
$insert='INSERT INTO `'.$_SESSION['database'].'_customers` ( registration_date_true, `login_customer` , `password_customer` , `newsletter` , `nazev_f` , `jmeno_f`, `prijmeni_f`, `ulice_f` , `psc_f` , `obec_f` , `stat_f` , `nazev_p` , `jmeno_p`, `prijmeni_p`, `ulice_p` , `psc_p` , `obec_p` , `stat_p` , `ico` , `dic` , `platce_dph` , `bank_ucet` , `bank_kod` , `var_symbol` , `spec_symb` , `kategorie` , `email1` , `email2` , `active`, `telef1` , `telef2` , `mobil1` , `mobil2` , `fax1` , `fax2` )
VALUES(NOW(), "' . $login_customer . '","' . sha1($password_customer1) . '","' . $newsletter. '","' . $nazev_f . '","' . $jmeno_f . '","' . $prijmeni_f . '","' . $ulice_f . '","' . $psc_f . '","' . $obec_f . '","' . $stat_f . '","' . $nazev_p . '","' . $jmeno_p . '","' . $prijmeni_p . '","' . $ulice_p . '","' . $psc_p . '","' . $obec_p . '","' . $stat_p . '","' . $ico . '","' . $dic . '","' . $platce_dph . '","' . $bank_ucet . '","' . $bank_kod . '","' . $var_symbol . '","' . $spec_symb . '","' . $kategorie . '","' . $email1 . '","' . $email2 . '","' . 1 . '","' . $telef1 . '","' . $telef2 . '","' . $mobil1 . '","' . $mobil2 . '","' . $fax1 . '","' . $fax2 . '")';
//echo $insert; //V případě nutné kontroly tohodle jeblýho příkazu
$i_result = mysql_query($insert, $this->link);
$id_customer=mysql_insert_id($this->link);
if ($i_result):
else: return '<div id="error">' . CHYBA_DATABAZE . '</div>';endif;
/*Konec zápisu do databáze*/
/*Přihlášení*/
$c_a_query = 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE LOWER(id_customer)="' . strtolower($_POST['affiliate']) . '" OR LOWER(login_customer)="' . strtolower($_POST['affiliate']) . '" OR LOWER(email1)="' . strtolower($_POST['affiliate']) . '"';
$c_a_result = mysql_query($c_a_query, $this->link);
if (mysql_num_rows($c_a_result)>0):
$customer_a = mysql_fetch_assoc($c_a_result);
$this->insert_referal($id_customer,$customer_a['id_customer']);
else:
$this->insert_referal($id_customer,3);
endif;
/*Konec přihlášení*/
$update='UPDATE '.$_SESSION['database'].'_customers SET active=1 WHERE id_customer='.$_SESSION['id_customer'];
$u_result=mysql_query($update,$this->link);
$this->login($login_customer,$password_customer1);
/*$return='
<h1>Vítejte v BONUSOVÉM KLUBU SLIM WINE!</h1>
<p>Děkujeme za Vaší registraci. Výhody budete moci využívat, až po obdržení ročního poplatku na náš účet.</p><br />
<p>Nejpozději následující pracovní den od nás obdržíte fakturu k zaplacení tohoto ročního poplatku BONUSOVÉHO KLUBU SLIM WINE.</p><br />
<p>Těšíme se na společnou spolupráci a přejeme Vám pěkný den.</p><br />
<p>Podpora: V případě jakéhokoliv dotazu ohledně SLIM WINE nás můžete kdykoliv kontaktovat na emailu: <a href="mailto:info@SlimWine.cz">info@SlimWine.cz</a>.</p><br />
<p><strong>Tým SLIM WINE!</strong></p><br />
';*/
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: " . $this->get_const('ROBOT_MAIL') . "\n";
$message= 'Doporučil: <strong>'.$customer_a['id_customer'].'</strong> '.$customer_a['jmeno_f'].' '.$customer_a['prijmeni_f'].'<br />Číslo: '.$_SESSION['id_customer'].'<br />
'.NAME.': ' . $jmeno_f .' ' .$prijmeni_f. ' ('.$nazev_f.')<br />Email: '.$email1;
mail($this->get_const('ORDER_EMAIL'), $this->zakoduj_predmet('Slimwine: Nová registrace'),$message , $headers);
return $this->show_my_referal();
}//END function register
function order_onetime($podminky,$nazev_f,$jmeno_f,$prijmeni_f,$ulice_f,$psc_f,$obec_f,$stat_f,$nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$psc_p,$obec_p,$stat_p,$ico,$dic,$email1,$telef1)
{//BEGIN function order_onetime
/*Nejprve zkontroluje, zda byli zadány správné údaje. Pokud ne, tak zavolá funkci show registration form s příslušnými
parametry. Pokud je vše v pořádku, zapíše zákazníka do databáza a na jeho adresu odešle uvítací e-mail a volitelně také
na adresu provozovatele e-shopu. Nakonec daného uživatele přihlásí do systému.*/
/*Kontrola zaslaných informací*/
$_SESSION['onetime']=1;//Zapneme tuto možnost
$name='<span style="color:red;">';
$error=0;
$rand1=rand(6, 10);
$rand2=rand(0, 30);
$rand3=rand(1,1000000);
$rand_hash=sha1($rand3);
$login_customer= substr($rand_hash, $rand2, $rand1);
$password_customer1=$password_customer2=$login_customer;
//ověření jedinečnosti loginu
$query = 'select * from '.$_SESSION['database'].'_customers where login_customer="'. $login_customer . '"';
$result = mysql_query($query, $this->link);
if (mysql_num_rows($result)<>0):$error=6; $name.= POUZITE_JMENO . '<br />';endif;
//konec ověření jedinešnosti loginu
$psc_f=str_replace(' ', '', $psc_f);
$psc_p=str_replace(' ', '', $psc_p);
if (strlen($login_customer)<5):$error=1;$name.= KRATKE_JMENO . '<br />';endif; //krátké přihlašovací jméno
if (strlen($password_customer1)<5):$error=2;$name.=KRATKE_HESLO . '<br />';endif; //krátké heslo
if ($password_customer1<>$password_customer2):$error=3;$name.= RUZNA_HESLA . '<br />';endif; //hesla nejsou stejná
if ($jmeno_f=="" || $prijmeni_f=="" || $ulice_f=="" || $psc_f=="" || $obec_f==""):$error=4;$name.= NEKOMPLETNI_FAKTURACNI_ADRESA . '<br />';endif; //nezadaná fakturační adresa
if ($email1=="" && $email2==""):$error=5;$name.=NO_EMAIL . '<br />';endif; //nazadán žádný e-mail
if ($telef1==""):$error=6;$name.=OT_E1 . '<br />';endif; //nazadán žádný e-mail
if ($podminky<>on):$error=7;$name.=NO_SOUHLAS . '<br />';endif; //Nesouhlasí s obchodními podmínkami
if ($nazev_f<>"" && $ico==""):$error=8;$name.= NO_IC . '<br />';endif; //Firma, která nezadala svoje IČ
$name.='</span><br />';
//V případě chyby se navrátí příslušné chyby a zobrazí se znovu registrační formulář
if ($error<>0): return ('<div id="error">' . $name . '</div>' .
$this->show_cart('','',0).
$this->show_onetime_form($podminky,$nazev_f,$jmeno_f,$prijmeni_f,$ulice_f,$psc_f,$obec_f,$stat_f,$nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$psc_p,$obec_p,$stat_p,$ico,$dic,$email1,$telef1));
endif;
/*Konec kontroly informací*/
/*Převod informací z select a checkbox na formát pro vložení do databáze*/
if ($platce_dph==on): $platce_dph=1; else:$platce_dph=0; endif;
if ($newsletter==on): $newsletter=1; else:$newsletter=0; endif;
$psc_f=str_replace(' ', '', $psc_f);
$psc_p=str_replace(' ', '', $psc_p);
/*Konec převodu informací*/
/*Zápis do databáze*/
$insert='INSERT INTO `'.$_SESSION['database'].'_customers` ( registration_date_true, `login_customer` , `password_customer` , `newsletter` , `nazev_f` , `jmeno_f`, `prijmeni_f`, `ulice_f` , `psc_f` , `obec_f` , `stat_f` , `nazev_p` , `jmeno_p`, `prijmeni_p`, `ulice_p` , `psc_p` , `obec_p` , `stat_p` , `ico` , `dic` , `bank_ucet` , `bank_kod` , `var_symbol` , `spec_symb` , `kategorie` , `email1` , `email2` , `active`, `telef1` , `telef2` , `mobil1` , `mobil2` , `fax1` , `fax2` )
VALUES(NOW(),"' . $login_customer . '","' . sha1($password_customer1) . '","' . $newsletter. '","' . $nazev_f . '","' . $jmeno_f . '","' . $prijmeni_f . '","' . $ulice_f . '","' . $psc_f . '","' . $obec_f . '","' . $stat_f . '","' . $nazev_p . '","' . $jmeno_p . '","' . $prijmeni_p . '","' . $ulice_p . '","' . $psc_p . '","' . $obec_p . '","' . $stat_p . '","' . $ico . '","' . $dic . '","' . $bank_ucet . '","' . $bank_kod . '","' . $var_symbol . '","' . $spec_symb . '","' . $kategorie . '","' . $email1 . '","' . $email2 . '","' . 1 . '","' . $telef1 . '","' . $telef2 . '","' . $mobil1 . '","' . $mobil2 . '","' . $fax1 . '","' . $fax2 . '")';
//echo $insert; //V případě nutné kontroly tohodle jeblýho příkazu
$i_result = mysql_query($insert, $this->link);
$id_customer=mysql_insert_id($this->link);
if ($i_result):
else: return '<div id="error">' . CHYBA_DATABAZE . '</div>';endif;
/*Konec zápisu do databáze*/
/*Odeslání informací o účtu*/
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: " . $this->get_const('ROBOT_MAIL') . "\n";
/*Odeslání emailu*/
$message= OT_EMAIL1.' '.NAME.': ' . $login_customer . '<br />'.HESLO.':' . $login_customer . '<br />*************************<br /><br />'.OT_EMAIL2;
mail($email1, $this->zakoduj_predmet(OT_EMAIL_HEADER),$message , $headers);
/*Konec odesílání*/
/*Přihlášení*/
$c_a_query = 'SELECT id_customer FROM '.$_SESSION['database'].'_customers WHERE LOWER(id_customer)="' . strtolower($_POST['affiliate']) . '" OR LOWER(login_customer)="' . strtolower($_POST['affiliate']) . '" OR LOWER(email1)="' . strtolower($_POST['affiliate']) . '"';
$c_a_result = mysql_query($c_a_query, $this->link);
if (mysql_num_rows($c_a_result)>0):
$customer_a = mysql_fetch_assoc($c_a_result);
$this->insert_referal($id_customer,$customer_a['id_customer']);
else:
$this->insert_referal($id_customer,3);
endif;
$this->login($login_customer,$password_customer1);
/*Konec přihlášení*/
$update='UPDATE '.$_SESSION['database'].'_customers SET active=1 WHERE id_customer='.$_SESSION['id_customer'];
$u_result=mysql_query($update,$this->link);
/*Uvítací text-přesměrování na dokončení objednávky*/
return $this->adresa_dodani();
/*Konec uvítacího textu*/
}//END function register
/*******************************************************************************/
function get_page($name){//Načte stránku z databáze a navrátí jí s BBcodem
if ($name=='uvod'):
return('<img src="img/slimwine-flirtwine.jpg" alt="" />');
endif;
$query_page='SELECT * FROM '.$_SESSION['database'].'_pages WHERE page_name="' . $name . '" AND id_lang=' . $_SESSION['id_lang'];
$result_page=mysql_query($query_page, $this->link);
$page=mysql_fetch_array($result_page);
$page=$this->bbcode($page['content']);
/*if ($name=='pro-partnery'):
$page.=$this->show_posting_form('');
endif;*/
if ($page==''):
return(false);
else:
return($page);
endif;
}//End of function get_page
function show_posting_form($email,$name="",$phone="",$subject="",$note=""){
$return='<form action="'.$this->create_href('odeslat-dotaz').'" method="post" enctype="multipart/form-data">
<br /><br /><br />
<table cellpadding="2" style="width:100%;">
<tr><td>'.JMENO.':</td><td><input type="text" name="name" maxlength="40" size="25" value="' . $name . '" /></td></tr>
<tr><td>'.EMAIL.':</td><td><input type="text" name="email" maxlength="40" size="25" value="' . $email . '" /></td></tr>
<tr><td>'.TELEFON.':</td><td><input type="text" name="phone" maxlength="20" size="25" value="' . $phone . '" /></td></tr>
<tr><td>'.MESTO.':</td><td><input type="text" name="subject" maxlength="40" size="25" value="' . $subject . '" /></td></tr>
<tr><td>'.CONTACT_FORM_JAK.':</td><td><textarea name="note" rows="5" cols="21" onFocus="this.value=\'\';">' . $note . '</textarea></td></tr>';
if(!$this->check_login()):
$check1=sha1(rand(0,10000000));
$check_code=substr($check1, rand(0,30), rand(4,6));
$return.='<tr><td>'.CONTACT_FORM_KOD.':*</td><td><input type="text" name="overeni" maxlength="40" size="25" value="" /><input type="hidden" name="overeni_hash" maxlength="40" size="25" value="'.sha1($check_code).'" /></td></tr>';
$return.='<tr><td>'.CONTACT_FORM_OPISTE_KOD.':</td><td>'.$check_code.'</td></tr>';
endif;
$return.='
<tr><td></td><td><input style="margin-top:10px;" type="submit" value="'.CONTACT_FORM_ODESLAT.'" /></td></tr>
</table>
</form>';
$return=$this->get_page('pro-partnery').$return;
return($return);
}//end of show_posting_form
function send_posting_form($email,$name,$phone,$subject,$note){
$b_query='SELECT * FROM filter_ban WHERE ip="'.$_SERVER['REMOTE_ADDR'].'"';
$b_result=mysql_query($b_query,$this->link);
if (mysql_num_rows($b_result)>0):
$ban=mysql_fetch_assoc($b_result);
if ($ban['level']>=10):
return('<div id="error"><span style="color: red;">Vaše adresa byla zablokována pro opakovanou snahu odeslat zprávy se zakázaným obsahem.<br /><br />V případě, že chcete Vaši adresu odblokovat, tak kontaktujte správce eshopu.</span></div>' . $this->show_posting_form($email,$name,$phone,$subject,$note));
endif;
endif;
if(!$this->check_login()):
if ($_POST['overeni_hash']<>sha1($_POST['overeni'])):
return('<div id="error"><span style="color: red;">'.CONTACT_FORM_E1.'</span></div>' . $this->show_posting_form($email,$name,$phone,$subject,$note));
endif;
endif;
if ($_POST['email']=="" || $_POST['name']=="" || $_POST['phone']=="" || $_POST['note']==""):
return('<div id="error"><span style="color: red;">'.CONTACT_FORM_E2.'.</span></div>' . $this->show_posting_form($email,$name,$phone,$subject,$note));
endif;
$phone=str_replace('+', '', $phone);
if (!is_numeric($phone) || strlen($phone)<9 || strlen($phone)>20):
return('<div id="error"><span style="color: red;">'.CONTACT_FORM_E3.'.</span></div>' . $this->show_posting_form($email,$name,$phone,$subject,$note));
endif;
$spam_words=array('order','viagra','buy','cialis','cheap','shipping','today','here','available','fingertips','online','erectile','dysfunction','drugs','myriad','pills','samples','free','great','issues','trial','want','need','meds','here','erotic','branded','ready','performance','trial','discreet','pharmacy','avaible','browse','discount','vicodin','prompt','selection','tried','reliable','sildenafil','ogaysyfsuuas','levitra','casino','gzvafyayogsyg','uzabgsuihsiuhs','ogaysyjsuus');
$count = 0;
foreach ($spam_words as $substring):
if ($count>0):continue;endif;
$count += substr_count(strtolower($name), $substring);
$count += substr_count(strtolower($email), $substring);
$count += substr_count(strtolower($subject), $substring);
$count += substr_count(strtolower($note), $substring);
endforeach;
if ($count>0):
if ($ban['level']>0):
$bi_query='UPDATE filter_ban SET level="'.($ban['level']+1).'" WHERE id="'.$ban['id'].'" LIMIT 1';
if ($ban['level']>7):
$ban_message='<div id="error">Pokud budete pokračovat v odesílání zpráv se zakázaným obsahem, tak bude váše adresa zablokována. Zakázaná slova jsou:<br />' . implode('<br />', $spam_words).'</div>';
elseif ($ban['level']>4):
$ban_message='<div id="error">Pokud budete pokračovat v odesílání zpráv se zakázaným obsahem, tak bude váše adresa zablokována.</div>';
endif;
else:
$bi_query='INSERT INTO filter_ban (ip,level) VALUES ("'.$_SERVER['REMOTE_ADDR'].'",1)';
endif;
$bi_result=mysql_query($bi_query,$this->link);
$url=$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
$email_insert_query='INSERT INTO filter_email (ip,email,name,header,url,send)
VALUES("'.$_SERVER['REMOTE_ADDR'].'","'.$email.'","'.$name.'","'.$subject.'","'.$url.'",0)';
$email_insert_result=mysql_query($email_insert_query,$this->link);
return('
<h1>Zpráva nebyla odeslána</h1>
<p>Některý z údajů obsahuje slova, která nejsou povolena systémem kontroly obsahu.</p>'.
$ban_message.
$this->show_posting_form($email,$name,$phone,$subject,$note)
);
endif;
/*Odešleme*/
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= 'From:' . $email . "\n";
$message_admin = '<h3>Byl odeslán dotaz ze SlimWine</h3>
<table style="border:none;">
<tr><td>Jméno:</td><td>' . $name . '</td></tr>
<tr><td>Telefoní spojení:</td><td>' . $phone . '</td></tr>
<tr><td>E-mail: </td><td>' . $email . '</td></tr>
<tr><td>Město: </td><td>' . $subject . '</td></tr>
<tr><td>Jak se o nás dozvěděli: </td><td>' . $note . '</td></tr>
</table>';
$admin2 = 'stepanek@microdesign.cz';
if (mail($this->get_const('ORDER_EMAIL'), $this->zakoduj_predmet('Dotaz Slim Wine'),$message_admin , $headers)):
//mail($admin2, $this->zakoduj_predmet($subject),$message_admin , $headers);
$url=$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
$email_insert_query='INSERT INTO filter_email (ip,email,name,header,url,send)
VALUES("'.$_SERVER['REMOTE_ADDR'].'","'.$email.'","'.$name.'","'.$subject.'","'.$url.'",1)';
$email_insert_result=mysql_query($email_insert_query,$this->link);
$return='<div id="error"><span style="color: red;">Váš dotaz byl odeslán, budeme se jím neprodleně zabývat.</span></div>';
else:
$return='<div id="error"><span style="color: red;">'.CONTACT_FORM_E4.'.</span></div>';
endif;
return($return);
}//End of function send_posting_form
function get_cms_page($name){//Načte stránku z databáze a navrátí jí s BBcodem
if ($name==''):
$query_page='SELECT * FROM '.$_SESSION['database'].'_pages WHERE id_lang=' . $_SESSION['id_lang'] . ' ORDER BY ordering LIMIT 1';
else:
$query_page='SELECT * FROM '.$_SESSION['database'].'_pages WHERE seo_name="' . $name . '" AND id_lang=' . $_SESSION['id_lang'];
endif;
$result_page=mysql_query($query_page, $this->link);
$page=mysql_fetch_array($result_page);
$page=$this->bbcode($page['content']);
if ($page==''):
return(false);
else:
return($page);
endif;
}//End of function get_page
/*Zobrazování výrobků*/
function show_paging($id_category,$id_section,$order,$direction,$page,$limit)
{//Zobrazí odkazy a formuláře pro pohyb v zobrazení sekce
/*Zjistíme počet položek v dané kategorii/sekci a počet stránek*/
if ($id_section==0):/*Decides if show only one section or all sections in category*/
$query_items = 'SELECT i.id_item FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_sections as s,'.$_SESSION['database'].'_stock as st WHERE s.show_section=1 AND st.id_stock=i.id_stock AND st.show=1 AND i.id_section=s.id_section AND s.id_category='. $id_category;
else: $query_items = 'SELECT i.id_item FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_sections as s,'.$_SESSION['database'].'_stock as st WHERE s.show_section=1 AND st.id_stock=i.id_stock AND st.show=1 AND s.id_section=i.id_section AND i.id_section='. $id_section;
endif;
$result_items=mysql_query($query_items, $this->link);
$count=mysql_num_rows($result_items);
$count=mysql_num_rows($result_items);
$rounding=$count/$limit+0.4999;
$pages=round($rounding);
/*Konec zjišťování počtu produktů*/
$return='<div class="paging">';
/*Šipky*/
if ($page>1):
$return.= '<a class="imgpag" href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section,'','radit=' . $order . '&amp;stranka=1') . '"><img src="./img/arrow-first.jpg" alt="První stránka" title="První stránka" /></a> ';
$return.= '<a class="imgpag" style="margin-right:10px;" href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section,'','radit=' . $order . '&amp;stranka=' . ($page-1)) . '"><img src="./img/arrow-previous.jpg" alt="Předchozí stránka" title="Předchozí stránka" /></a> ';
else:
$return.= '<img src="./img/arrow-first-inactive.jpg" alt="" title="" /> ';
$return.= '<img style="margin-right:10px;" src="./img/arrow-previous-inactive.jpg" alt="" title="" /> ';
endif;
/*Čísla*/
if ($page>=4):
$return.='<a ';
if ($page==$i):
$return.='class="cur" ';
endif;
$return.='';
if ($id_section<>0):
$return.= 'href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section,'','radit=' . $order . '&amp;stranka=1') . '">1</a> ';
else:
$return.= 'href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,'','','radit=' . $order . '&amp;stranka=1') . '">1</a> ';
endif;
endif;
if ($page>=5): $return.= ' ... ';endif;
/*Hlavní for-cyklus*/
for ($i=($page-2);(($i-1)*$limit<$count && ($i<=$page+2));$i+=1)
{
if ($i<1):continue;endif;
$return.='<a ';
if ($page==$i):
$return.='class="cur" ';
endif;
if ($id_section<>0):
$return.= 'href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section,'','radit=' . $order . '&amp;stranka=' . $i) . '">' . $i . '</a> ';
else:
$return.= 'href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,'','','radit=' . $order . '&amp;stranka=' . $i) . '">' . $i . '</a> ';
endif;
}
/*Konec hlavního cyklu*/
if ($pages>=($page+4)): $return.= ' ... ';endif;
if ($pages>=($page+3)):
$return.='<a ';
if ($page==$i):
$return.='class="cur" ';
endif;
if ($id_section<>0):
$return.= 'href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section,'','radit=' . $order . '&amp;stranka=' . $pages) . '">' . $pages . '</a> ';
else:
$return.= 'href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,'','','radit=' . $order . '&amp;stranka=' . $pages) . '">' . $pages . '</a> ';
endif;
endif;
/*Konec čísílek (stránek)*/
/*Šipečky*/
if ($page<$pages):
$return.= '<a class="imgpag" style="margin-left:10px;" href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section,'','radit=' . $order . '&amp;stranka=' . ($page+1)) . '"><img src="./img/arrow-next.jpg" alt="Další stránka" title="Další stránka" /></a> ';
$return.= '<a class="imgpag" href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section,'','radit=' . $order . '&amp;stranka='.$pages) . '"><img src="./img/arrow-last.jpg" alt="Poslední stránka" title="Poslední stránka" /></a> ';
else:
$return.= '<img style="margin-left:10px;" src="./img/arrow-next-inactive.jpg" alt="" title="" /> ';
$return.= '<img src="./img/arrow-last-inactive.jpg" alt="" title="" /> ';
endif;
$return.='</div>';//end of div paging
return ($return);
}//End of function show_paging
function show_category($id_category,$id_section=0,$order="id", $direction="",$page=1,$limit=0)
{//BEGIN function show_category
//conects with database, display category name and all items in this category or section with preset limit and start for query
if ($limit==0):$limit=$this->get_const('LIMIT');endif;
$query = 'select * from '.$_SESSION['database'].'_categories where show_category=1 AND id_category=' . $id_category;
$result = mysql_query($query, $this->link);
$return ='';
//$return .=$this->show_ordering($id_category,$id_section,$order,$direction,$page,$limit);
if ($result && mysql_num_rows($result)>0):
// if category exist then display it
/*Shows the entire category or just one section*/
/*Řazení*/
switch ($order):
case "id": $razeni="ordering";break;
case "cena": $razeni="item_price";break;
case "nazev": $razeni="item_name";break;
case "popularita": $razeni="id_item";break;
endswitch;
//směr řazení
if ($direction=="vzestupne"):
$desc='';
else: $desc='DESC';
endif;
if ($razeni=="ordering")://je nutné otočit :(
if ($desc=="DESC"):$desc="";else:$desc="DESC";endif;
endif;
/*Konec řazení*/
if ($razeni=="item_name")://Jméno je nutné řadit podle tabulky item_names
if ($id_section==0):/*Decides if show only one section or all sections in category*/
$query_items = 'SELECT * FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_sections as s,'.$_SESSION['database'].'_stock as st,'.$_SESSION['database'].'_items_names as iname WHERE i.id_item=iname.id_item AND iname.id_lang="' . $_SESSION['id_lang'] . '" AND s.show_section=1 AND st.id_stock=i.id_stock AND st.show=1 AND i.id_section=s.id_section AND s.id_category='. $id_category . ' ORDER BY iname.' . $razeni . ' ' . $desc . ' LIMIT '. (($page-1)*$limit) . ',' . $limit;
else: $query_items = 'SELECT * FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_sections as s,'.$_SESSION['database'].'_stock as st,'.$_SESSION['database'].'_items_names as iname WHERE i.id_item=iname.id_item AND iname.id_lang="' . $_SESSION['id_lang'] . '" AND s.show_section=1 AND st.id_stock=i.id_stock AND st.show=1 AND s.id_section=i.id_section AND i.id_section='. $id_section . ' ORDER BY iname.' . $razeni . ' ' . $desc . ' LIMIT '. (($page-1)*$limit) . ',' . $limit;
endif;
else:
if ($id_section==0):/*Decides if show only one section or all sections in category*/
$query_items = 'SELECT * FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_sections as s,'.$_SESSION['database'].'_stock as st WHERE s.show_section=1 AND st.id_stock=i.id_stock AND st.show=1 AND i.id_section=s.id_section AND s.id_category='. $id_category . ' ORDER BY i.' . $razeni . ' ' . $desc . ' LIMIT '. (($page-1)*$limit) . ',' . $limit;
else: $query_items = 'SELECT * FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_sections as s,'.$_SESSION['database'].'_stock as st WHERE s.show_section=1 AND st.id_stock=i.id_stock AND st.show=1 AND s.id_section=i.id_section AND i.id_section='. $id_section . ' ORDER BY i.' . $razeni . ' ' . $desc . ' LIMIT '. (($page-1)*$limit) . ',' . $limit;
endif;
endif;
//echo $query_items;/*Pouze pro případnou kontrolu dotazu v okně prohlížeče*/
$result_items = mysql_query($query_items, $this->link);
/*Chybové ukončení*/ if (mysql_num_rows($result_items)==0):return('<div id="error">' .PRAZDNA_KATEGORIE . '</div>');endif;
$c=0;
while ($item=mysql_fetch_array($result_items)):/*Pro každou vypisovanou položku*/
$return.=$this->show_small_item($item,$c);
$c++;
endwhile;
$return .='<div class="spacer">&nbsp;</div>';
$return .=$this->show_paging($id_category,$id_section,$order,$direction,$page,$limit);
else:
$return = '<div id="error">' . KATEGORIE_NEEXISTUJE . '</div>';
endif;
return $return;
}//END function show_category
function show_action_items($limit=6){//Navrátí v divu 4 akční výrobky
$return='<div class="spacer">&nbsp;</div>';
$query_items = 'SELECT * FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_sections as s,'.$_SESSION['database'].'_stock as st WHERE s.show_section=1 AND st.id_stock=i.id_stock AND st.show=1 AND s.id_section=i.id_section AND i.action=1 ORDER BY i.action DESC,RAND() LIMIT ' . $limit;
$result_items = mysql_query($query_items, $this->link);
$c=0;
while ($item=mysql_fetch_array($result_items)):
$return.=$this->show_small_item($item,$c);
$c++;
endwhile;
$return .='<div class="spacer">&nbsp;</div>';
return($return);
}//End of function show_action_items
function fulltext($co_hleda)
{/*Rozdělí hledaný výraz na jednotlivá slova, zmenší písmenka a odstraní diakritiku. Pak se pokusí
najít dané výrazy v databázi pomocí příkazu LIKE*/
$return='<h1>' . VYSLEDEK_HLEDANI . ': ' . $co_hleda . '</h1>';
/*Hledání dle kódu*/
$kod_query='SELECT id_item FROM '.$_SESSION['database'].'_items as i,'.$_SESSION['database'].'_stock as st WHERE i.id_stock=st.id_stock AND st.show=1 AND i.interni_kod="' . $co_hleda . '"';
$kod_result=mysql_query($kod_query,$this->link);
/*Fulltext*/
$co_hleda=strtolower($co_hleda); //převod na malá písmena
$co_hleda=$this->odstran_diakritiku($co_hleda); //funkce na odstranění diakritiky z řetězce
$query='SELECT i.id_item FROM '.$_SESSION['database'].'_items_names AS iname,'.$_SESSION['database'].'_items AS i,'.$_SESSION['database'].'_stock as st
WHERE i.id_stock=st.id_stock AND st.show=1 AND i.interni_kod<>"' . $co_hleda . '" AND i.id_item=iname.id_item AND (i.interni_kod="' . $co_hleda . '" OR (id_lang=' . $_SESSION['id_lang'] . ' AND MATCH(item_name_f,item_description_short_f,item_description_f) AGAINST ("' . $co_hleda . '" IN BOOLEAN MODE)))
ORDER BY MATCH(item_name_f) AGAINST ("' . $co_hleda . '" IN BOOLEAN MODE) + MATCH(item_name_f,item_description_short_f,item_description_f) AGAINST ("' . $co_hleda . '" IN BOOLEAN MODE) DESC';
//echo $query;
$result = mysql_query($query,$this->link);
$c=0;
if ((mysql_num_rows($result)+mysql_num_rows($kod_result))>0):
$count=1;//počítadlo - určí, zda je řádek sudý či lichý
/*Výpis dle kódu*/
while ($id=mysql_fetch_array($kod_result))://Výpis odpovídající záznamů
$return.=$this->show_small_item('nic neposílám',$c,$id['id_item']);
$c++;
endwhile;
/*Výpis fulltextu*/
while ($id=mysql_fetch_array($result))://Výpis odpovídající záznamů
$return.=$this->show_small_item('nic neposílám',$c,$id['id_item']);
$c++;
endwhile;
else:
$return.='<div id="error">' . ZADNY_VYSLEDEK . '</div>';
endif;
mysql_free_result($result);
return ($return);
}//End of function fulltext
function show_small_item($item,$c,$id_item=0){//Zobrazí jeden malý item
if ($id_item<>0):
$i_query = 'SELECT * FROM '.$_SESSION['database'].'_items as i WHERE i.id_item='. $id_item;
$i_result=mysql_query($i_query,$this->link);
$item=mysql_fetch_assoc($i_result);
endif;
$id_category=$this->get_category_by_id_section($item['id_section']);
/*Úprava ceny dle sekce*/
if($this->check_login()):
$psection_query='SELECT * FROM '.$_SESSION['database'].'_sections WHERE id_section=' . $item['id_section'];
$psection_result=mysql_query($psection_query,$this->link);
$psection=mysql_fetch_assoc($psection_result);
$pcategory_query='SELECT * FROM '.$_SESSION['database'].'_categories WHERE id_category=' . $psection['id_category'];
$pcategory_result=mysql_query($pcategory_query,$this->link);
$pcategory=mysql_fetch_assoc($pcategory_result);
$item['item_price']*=$psection['section_rate']*$pcategory['category_rate'];
//$item['common_price']*=$psection['section_rate']*$pcategory['category_rate'];
endif;
/*Nalezení obrázku*/
$query_image = 'select id_image,small_height,big_height,small_width,big_width from '.$_SESSION['database'].'_images where id_item="' . $item['id_item'] . '" ORDER BY RAND()';
$result_image = mysql_query($query_image, $this->link);
$image = mysql_fetch_array($result_image);
if ($image['id_image']):
$image_adress = '../../img/small.php?id_image='.$_SESSION['database'].'-' . $image['id_image'];
$style='top:' . (95+((90-$image['small_height'])/2)) . 'px;left:' . (40+((90-$image['small_width'])/2)) . 'px';
$class='tooltip';
else: $image_adress = './img/default.jpg';
$style='top:95px;left:40px;';
$class='small';
endif;
/*Zjištění sazby DPH*/
$dph_query='SELECT * FROM '.$_SESSION['database'].'_dph WHERE id_dph=' . $item['id_dph'];
$dph_result=mysql_query($dph_query,$this->link);
$dph=mysql_fetch_array($dph_result);//Sazba DPH
/*Příprava krátkého popisu*/
$item_names=$this->get_item_names($item['id_item']);
$item_description_short=$item_names['item_description_short']; //nutno zacHovat původní proměnou, aby se mohla dát jako alt k obrázkům
if ((strlen($item_names['item_description_short']))>55):
$item_description_short=substr($item_names['item_description_short'], 0, 51);
$item_description_short.='&hellip;';
endif;
/*Konec přípravy krátkého popisu*/
$return .= '<div class="small_item">'.
/*Nadpis*/
'<h2><a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$item['id_section'],$item['id_item']) . '">
' . $item_names["item_name"] . '</a></h2>';
/*Vložení obrázku*/
$return .= '<a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$item['id_section'],$item['id_item']) . '">
<img style="' . $style . '" id="'.$_SESSION['database'].'-' . $image['id_image'] . '" class="' . $class . '" src="' . $image_adress . '" alt="' . $this->clean_alt($item_names['item_description_short']) . '" title="' . $this->clean_alt($item_names['item_description_short']) . '" />
</a>';
$return .= '<a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$item['id_section'],$item['id_item']) . '">
<img class="handglass" src="./img/handglass.jpg" alt="' . $this->clean_alt($item_names['item_description_short']) . '" title="' . $this->clean_alt($item_names['item_description_short']) . '" />
</a>';
if ($item['action']==1):
$return .= '<img class="action" src="./img/action.gif" alt="' . $this->clean_alt($item_names['item_description_short']) . '" title="' . $this->clean_alt($item_names['item_description_short']) . '" />';
endif;
$return .= '<h2 class="description">' . $this->bbcode($item_names['item_description_short']) . '</h2>';
$id_item=$item['id_item'];
/*Formulář pro obědnávky*/
$return.='<form name="form' . $item['id_item'] . '" action="" method="post"><input type="hidden" name="id_item" value="' . $item['id_item'] .'"/><table><tr>';
// $return.='<form name="form' . $item['id_item'] . '" onsubmit="return (check(' ."'form" . $item['id_item'] . "'," . $item['minimum'] . ",'" . $item_names["item_name"] . "'" . '));" action="" method="post"><input type="hidden" name="id_item" value="' . $item['id_item'] .'"/>';
if ($_SESSION['clen']==1):
$return .= '<td><select name="quantity" style="width:25px;">
<option value="2"';if($_SESSION['cart'][$id_item]['quantity']==2):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="6"';if($_SESSION['cart'][$id_item]['quantity']==6):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="12"';if($_SESSION['cart'][$id_item]['quantity']==12):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="24"';if($_SESSION['cart'][$id_item]['quantity']==24):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="36"';if($_SESSION['cart'][$id_item]['quantity']==36):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="48"';if($_SESSION['cart'][$id_item]['quantity']==48):$return.=' selected="selected"';endif;$return.='>2</option>
</select></td>';
else:
$return .= '<td><input name="quantity" style="width:25px;">
<option value="2"';if($_SESSION['cart'][$id_item]['quantity']==2):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="6"';if($_SESSION['cart'][$id_item]['quantity']==6):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="12"';if($_SESSION['cart'][$id_item]['quantity']==12):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="24"';if($_SESSION['cart'][$id_item]['quantity']==24):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="36"';if($_SESSION['cart'][$id_item]['quantity']==36):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="48"';if($_SESSION['cart'][$id_item]['quantity']==48):$return.=' selected="selected"';endif;$return.='>2</option>
</select></td>';
endif;
$return.='
<td><input type="image" alt="Objednat" title="Objednat" src="./img/arrow-6.jpg" /></td>';
$return.='</tr></table></form>';
/*konec formuláře pro objednávky*/
/*Zobrazení slevy*/
$return .='<h3 class="cena">' . $this->format_price($item['item_price']*(100+$dph['dph'])/100*$_SESSION['ct_rate']) . '</h3>';
if (($item['item_price']<$item['common_price']) && ($this->get_const('SHOW_COMMON_PRICE')==1)):$return .='<h4 class="bezna_cena">' . $this->format_price($item['common_price']*$_SESSION['ct_rate']*(100+($dph['dph']*$_SESSION['show_dph']))/100) . '</h4>';endif;
$return .='</div>';
return($return);
}//End of function show_small_item
function show_category_header($id_category,$id_section,$id_item=0)
{//BEGIN function category_header
$cat_header = "";
$query = 'select * from '.$_SESSION['database'].'_categories where id_category=' . $id_category;
$result = mysql_query($query, $this->link);
$cnames_query='SELECT * FROM '.$_SESSION['database'].'_categories_names WHERE id_category="' . $id_category . '" AND id_lang=' . $_SESSION['id_lang'];
$cnames_result=mysql_query($cnames_query,$this->link);
$cnames=mysql_fetch_assoc($cnames_result);
$category = mysql_fetch_assoc($result);
$category['category_name']=$this->get_category_name($category['id_category']);//Načteme správné jméno kategorie v závislosti na jazyku
if ($id_section==0):
$cat_header .= '<h2 class="navigation"><a class="navhome" href="' . $this->create_href('') . '"><img src="./img/navigation-home.jpg" alt="" title="" /></a> <a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category) . '">' . $category['category_name'] . '</a> </h2>'; //category header
else: $query_sec = 'select * from '.$_SESSION['database'].'_sections where id_section=' . $id_section;
$result_sec = mysql_query($query_sec, $this->link);
$section = mysql_fetch_assoc($result_sec);
$section['section_name']=$this->get_section_name($section['id_section']);
$cat_header .= '<h2 class="navigation"><a class="navhome" href="' . $this->create_href('') . '"><img src="./img/navigation-home.jpg" alt="" title="" /></a> <a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category) . '">' . $category['category_name'] . '</a> <a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$id_section) . '">' . $section['section_name'] . '</a> ';
if ($id_item<>0):
$item = $this->get_item_names($id_item);
$cat_header .= ' <span>' . $item['item_name'] .'</span>';
endif;
$cat_header .= '</h2>'; //category header
endif;
if ($cnames['category_description']<>''):
$cat_header.='<div id="sections">'.$this->bbcode(stripslashes($cnames['category_description'])).'</div>';
endif;
/*Div with sections in category
$query_sections = 'select * from '.$_SESSION['database'].'_sections WHERE show_section=1 AND id_category=' . $id_category . ' ORDER BY ordering';
$result_sections = mysql_query($query_sections, $this->link);
if ($result_sections && mysql_num_rows($result_sections)>1):
$cat_header .='<div id="sections"><ul>';
while ($section=mysql_fetch_assoc($result_sections))
{
$section['section_name']=$this->get_section_name($section['id_section']);
if ($id_section <>$section['id_section']):
$cat_header .='<li><h2><a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$section['id_section']) . '">' . $section['section_name'] . '</a></h2></li>';
else: $cat_header .='<li><h2><a class="current" href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$id_category,$section['id_section']) . '">' . $section['section_name'] . '</a></h2></li>';
endif;
}
$cat_header .='</ul><div class="spacer"></div></div>';
endif;*/
return $cat_header;
}//END function category_header
function show_item($id_category,$id_section,$id_item)
{//BEGIN function show_item
//conects with database and display item with order form
//$return = $this->show_category_header($id_category,$id_section,$id_item);
$return='';
$query = 'select * from '.$_SESSION['database'].'_items where id_item='. $id_item;
$result = mysql_query($query, $this->link);
$query_image = 'select * from '.$_SESSION['database'].'_images where id_item='. $id_item;
$result_image = mysql_query($query_image, $this->link);
$item = mysql_fetch_assoc($result);
$item_names= $this->get_item_names($item['id_item']);
$item['item_name']=$item_names['item_name'];
$item['item_description_short']=$item_names['item_description_short'];
$item['item_description']=$item_names['item_description'];
/*Úprava ceny dle sekce*/
if($this->check_login()):
$psection_query='SELECT * FROM '.$_SESSION['database'].'_sections WHERE id_section=' . $item['id_section'];
$psection_result=mysql_query($psection_query,$this->link);
$psection=mysql_fetch_assoc($psection_result);
$pcategory_query='SELECT * FROM '.$_SESSION['database'].'_categories WHERE id_category=' . $psection['id_category'];
$pcategory_result=mysql_query($pcategory_query,$this->link);
$pcategory=mysql_fetch_assoc($pcategory_result);
$item['item_price']*=$psection['section_rate']*$pcategory['category_rate'];
//$item['common_price']*=$psection['section_rate']*$pcategory['category_rate'];
endif;
if ($_SESSION['clen']==1):
$item['item_price']=$item['common_price'];
endif;
if ($result && mysql_num_rows($result)>0)
{
$dph_query='SELECT * FROM '.$_SESSION['database'].'_dph WHERE id_dph=' . $item['id_dph'];
$dph_result=mysql_query($dph_query,$this->link);
$dph=mysql_fetch_array($dph_result);//Sazba DPH
$stock_query='SELECT * FROM '.$_SESSION['database'].'_stock WHERE id_stock=' . $item['id_stock'];
$stock_result=mysql_query($stock_query,$this->link);
$stock=mysql_fetch_array($stock_result);
/*Modul skladu či pouze stock*/
$item['store']=$item['store']-$_SESSION['cart'][$id_item]['quantity'];
/*if ($item['store']>0): //Měníme pouze, když máme zboží skladem
$stock['stock_color']='#339933';
if ($item['store']<=1) $stock['stock_name']=POSLEDNI_KUS;
elseif ($item['store']>=2 && $item['store']<=5) $stock['stock_name']=SKLADEM . ' 2-5 ' . KS;
elseif ($item['store']>=6 && $item['store']<=10) $stock['stock_name']=SKLADEM . ' 5-10 ' . KS;
elseif ($item['store']>=11 && $item['store']<=100) $stock['stock_name']=SKLADEM . ' 10< ' . KS;
elseif ($item['store']>=101) $stock['stock_name']=SKLADEM . ' 100< ' . KS;
endif;*/
if ($item['interni_kod']<>""):$kod=$item['interni_kod'];else:$kod=$id_category . '.' . $item['id_section'] . '.' . $id_item;endif;
//printing item if exists
$return .= "\n" .
'<div id="item">
<h1 id="item_name">' . $item['item_name'] . '</h1>';
$return .='
<div id="itemobrazky">';
/*Nalezení obrázku*/
$query_image = 'select * from '.$_SESSION['database'].'_images where id_item="' . $item['id_item'].'"';
$result_image = mysql_query($query_image, $this->link);
$image = mysql_fetch_array($result_image);
if ($image['id_image']):
$max_big_width=$max_big_height=236;
$width=$image['big_width'];
$height=$image['big_height'];
$big_x_ratio=$max_big_width/$width; //poměr šířek obrázku a maximálního rozměru big image
$big_y_ratio=$max_big_height/$height; //poměr výšek obrázku a maximálního rozměru big image
if (($width<=$max_big_width) && ($height<=$max_big_height)): //Když je dostatečně malý v obou rozměrech
$new_big_width=$width;
$new_big_height=$height;
else: if (($big_x_ratio * $height)<=$max_big_height): //Když přetéká na výšku
$new_big_width=$max_big_width;
$new_big_height=round($big_x_ratio * $height);
else: //Když přetéká na šířku
$new_big_width=round($big_y_ratio * $width);
$new_big_height=$max_big_height;
endif;
endif;
$left_px=125-($new_big_width*0.5);
$top_px=125-($new_big_height*0.5);
$image_adress = '../../img/big.php?id_image='.$_SESSION['database'].'-' . $image['id_image'];
$style='width:'.$new_big_width.'px;height:'.$new_big_height.'px;left:'.$left_px.'px;top:'.$top_px.'px;';
$class='tooltip';
else: $image_adress = './img/default.jpg';
$style='top:80px;left:80px;';
$class='small';
endif;
//Vložení hlavního obrázku
$return .= '<img style="' . $style . '" src="' . $image_adress . '" alt="' . $this->clean_alt($item_names['item_description_short']) . '" title="' . $this->clean_alt($item_names['item_description_short']) . '" />';
/*Vkládání dalších obrázků*/
$return.='<div id="obrazky">';
if (mysql_num_rows($result_image)>0):
$i_count=0;
while ($image = mysql_fetch_assoc($result_image)):
$left_px=63-($image['small_width']*0.5);
$top_px=63-($image['small_height']*0.5);
$style='left:'.$left_px.'px;top:'.$top_px.'px;';
$return.='<div';if ($i_count%2==1):$return.=' style="float:right;"';endif;$return.='><a href="../../img/big.php?id_image='.$_SESSION['database'].'-' . $image['id_image'] . '" onclick=" return new_window(this.href,\'' . $item['item_name'] . '\',' . $image['big_width'] . ',' . ($image['big_height']+60) . ');" target="_blank"><img style="'.$style.'" src="../../img/small.php?id_image='.$_SESSION['database'].'-' . $image['id_image'] . '" alt="' . $this->clean_alt($item["item_name"]) . '" title="' . KLIKNETE_ZVETSENI . '" /></a></div>';
$i_count++;
endwhile;
endif;
$return .='</div>';//end of div obrazky
/*Konec vkládání obrázků*/
$return.='</div>';//End of div itemobrazky
/*Hlavní část okna - text od zákazníka*/
$return.='<div id="long_description">' . $this->bbcode($item['item_description']);
if (!$_SESSION['id_customer'] || $_SESSION['clen']==0):
$return.='<p style="color:#33CC33;font-size:24px;text-align:center;font-weight:bold;">'.SW_JEDN_OBJ.'</p>';
endif;
$return.= '</div>';
/*Pravá část okna produktu*/
$return.='<div id="itemceny">
<form name="form' . $item['id_item'] . '" action="" method="post"><input type="hidden" name="id_item" value="' . $item['id_item'] .'"/>
<table id="ceny" cellspacing="0" cellpadding="0">';
$return.= '<tr id="koupit"><td style="border-right: none;">'.I_MNOZSTVI.': </td>
<td style="border-left: none;">';
if ($_SESSION['clen']==1):
if($_SESSION['id_lang']==1):
$return.='
<select name="quantity" style="width:80px;font-size: 24px;">
<option value="2"';if($_SESSION['cart'][$id_item]['quantity']==2):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="6"';if($_SESSION['cart'][$id_item]['quantity']==6):$return.=' selected="selected"';endif;$return.='>6</option>
<option value="12"';if($_SESSION['cart'][$id_item]['quantity']==12):$return.=' selected="selected"';endif;$return.='>12</option>
<option value="24"';if($_SESSION['cart'][$id_item]['quantity']==24):$return.=' selected="selected"';endif;$return.='>24</option>
<option value="36"';if($_SESSION['cart'][$id_item]['quantity']==36):$return.=' selected="selected"';endif;$return.='>36</option>
<option value="48"';if($_SESSION['cart'][$id_item]['quantity']==48):$return.=' selected="selected"';endif;$return.='>48</option>
</select>';
else:
$return.='
<select name="quantity" style="width:80px;font-size: 24px;">
<option value="2"';if($_SESSION['cart'][$id_item]['quantity']==2):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="6"';if($_SESSION['cart'][$id_item]['quantity']==6):$return.=' selected="selected"';endif;$return.='>6</option>
<option value="12"';if($_SESSION['cart'][$id_item]['quantity']==12):$return.=' selected="selected"';endif;$return.='>12</option>
</select>';
endif;
else:
if (!$_SESSION['cart'][$id_item]['quantity']):$q=1;else:$q=$_SESSION['cart'][$id_item]['quantity'];endif;
$return .= '<input name="quantity" style="width:80px;font-size: 24px;float:right;padding:6px;" value="'.$q.'" />';
endif;
if (!$_SESSION['id_customer']):
$return.='
</td></tr><tr><td class="separator"></td></tr>
<tr id="koupit"><td colspan="2" style="">';
if ($_COOKIE['referal_name']<>''):
$return.='
<strong>'.I_SLEVA.'!</strong>
'.I_DOPORUCIL.' <strong>'.$_COOKIE['referal_name'].'</strong>.<br />';
else:$return.='
<strong>'.I_SLEVA_Q.'?</strong>
'.I_SLEVA_CLEN.':<br />';
endif;
$return.='<input name="id_referal" style="width:80px;font-size: 24px;float:right;padding:6px;" value="'.$_SESSION['id_referal'].'" />
</td>
</tr>';
endif;
$return.='
<tr><td colspan="2"><input type="image" alt="'.I_DO_KOSIKU.'" title="Vložit do košíku" src="./img/arrow-6.jpg" /></td></tr><tr><td class="separator"></td></tr>';
/*Zobrazení tabulky s cenama a slevou*/
$return.='<tr id="kod"><td style="border-right: none;">' . KOD_ZBOZI . ': </td><td class="bunka_s_cenou" >' . $kod . '</td></tr><tr><td class="separator"></td></tr>';
if ($item['common_price']>$item['item_price']):
$return .='<tr id="vase_cena"><td style="border-right: none;">' . VASE_CENA . ': </td><td class="bunka_s_cenou">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']*(100+$dph['dph'])/100) . '</td></tr><tr><td class="separator"></td></tr>';
if ($_SESSION['show_dph']==1):
$return .='<tr id="vase_cena_dph"><td style="border-right: none;">' . BEZ_DPH . ': </td><td class="bunka_s_cenou">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']) . '</td></tr><tr><td class="separator"></td></tr>';
endif;
$return .='<tr id="sleva"><td style="border-right: none;">' . SLEVA . ': </td><td align="right" style="border-left: none;">' . round((($item['common_price']-($item['item_price']*$_SESSION['ct_rate']))*100/$item['common_price']),2) . ' %</td></tr><tr><td class="separator"></td></tr>';
$return .='<tr id="bezne"><td style="border-right: none;">' . BEZNA_CENA . ': </td><td id="cross" class="bunka_s_cenou" align="right"> ' . $this->format_price($item['common_price']*(100+($dph['dph']*$_SESSION['show_dph']))/100) . '</td></tr><tr><td class="separator"></td></tr>';
$return .='<tr id="usetrite"><td style="border-right: none;">' . USETRITE . ': </td><td align="right" style="border-left: none;">' . $this->format_price(($item['common_price']-($item['item_price']*$_SESSION['ct_rate']))*(100+($dph['dph']*$_SESSION['show_dph']))/100) . '</td></tr><tr><td class="separator"></td></tr>';
//Vypsání vhodného popisku
$return .='<tr id="dostupnost"><td colspan="2" style="color:' . $stock['stock_color'] . ';">' . $stock['stock_name'] . '</td></tr><tr><td class="separator"></td></tr>';
/*Konec modulu skladu*/
else:
/* Přepíše cenu pro jazykovou mutaci*/
if($_SESSION['id_lang']==4 || $_SESSION['id_lang']==2){
$user_price = $this->format_price(($item['eur_price2']*27.44));
} else {
$user_price = $this->format_price(($item['item_price']*$_SESSION['ct_rate'])+((($item['item_price']*$_SESSION['ct_rate'])*0.21)*$_SESSION['show_dph']));
}
$return .='<tr id="vase_cena"><td style="border-right: none;">' . VASE_CENA . ': </td><td class="bunka_s_cenou">' . $user_price . '</td></tr><tr><td class="separator"></td></tr>';
if ($_SESSION['show_dph']==1):
if($_SESSION['id_lang']==4 || $_SESSION['id_lang']==2){
$user_price = $this->format_price(($item['eur_price2']*27.44)-(($item['eur_price2']*27.44)*0.19));
} else {
$user_price = $this->format_price($item['item_price']*$_SESSION['ct_rate']);
}
$return .='<tr id="vase_cena_dph"><td style="border-right: none;">' . BEZ_DPH . ': </td><td class="bunka_s_cenou">' . $user_price . '</td></tr><tr><td class="separator"></td></tr>';
endif;
$return .='<tr id="dostupnost"><td style="border-right: none;">' . DOSTUPNOST . ': </td><td class="bunka_s_cenou" style="color:' . $stock['stock_color'] . ';" align="right">' . $stock['stock_name'] . '</td></tr><tr><td class="separator"></td></tr>';
endif;
$return .='</table>';//end of table ceny
/*Formulář pro obědnávky*/
$return.='</form>';
/*konec formuláře pro objednávky*/
$return .='</div>';//end of div itemceny
$return.='<div class="spacer">&nbsp;</div>';//Ukončení floatování
$return.='</div>'; //end of item
/*if (!$_SESSION['id_customer']):
$return.=$this->show_cart();
endif;*/
}
else
{
//$return = $this->show_category_header($id_category,$id_section,$id_item);
$return .= '<div id="error">' . PRODUKT_NENALEZEN . '</div>';
}
return $return; //return item informations with order form
}//END function show_item
/*Konec funkcí zobrazování výrobků*/
function set_onetime_referal(){
$ch_query='SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='.$_POST['id_referal'];
$ch_result=mysql_query($ch_query,$this->link);
if (mysql_num_rows($ch_result)==1):
$_SESSION['ct_rate']=0.85;
$_SESSION['id_referal']=$_POST['id_referal'];
else:
$_SESSION['ct_rate']=1;
$_SESSION['id_referal']=0;
endif;
}
function send_recomandation($name,$email,$page){
if ($name=='' || $email==''):
return('<h1>Doporučení neodesláno</h1><p>Nevyplnil jste email nebo Vaše jméno. Prosím zkuste to znovu.</p>');
endif;
$headers .= "Content-Type: text/html; charset=utf-8;\n";
$headers .= "From: " . $this->get_const('ROBOT_MAIL') . ";\n";
/*Odeslání emailu*/
$message= 'Dobrý den,<br />'.$name.' Vám doporučil stránku:<br /><br /><a href="'.$page.'">'.$page.'</a><br /><br />Těšíme se na Vaši návštěvu.';
mail($email, $this->zakoduj_predmet($name. ' - Doporučení e-shopu'),$message , $headers);
$return='<h1>Doporučení odesláno</h1><p>Děkujeme Vám, že jste doporučili náš eshop.</p>';
return($return);
}
function order_clenstvi(){
$ch_query='SELECT * FROM '.$_SESSION['database'].'_orders WHERE expiration_end>NOW() AND id_state in (1,2,6,8) AND id_customer='.$_SESSION['id_customer'];
$ch_result=mysql_query($ch_query,$this->link);
if (mysql_num_rows($ch_result)>0):
$ch=mysql_fetch_assoc($ch_result);
return '<div id="error">'.F_CLENSTVI_UZ_JE.'</div>'
. $this->show_order($ch['id_order']);
endif;
/*Nejprve si načteme všechny údaje o zákazníkovi do pole $customer*/
$c_query = 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='.$_SESSION['id_customer'];
$c_result = mysql_query($c_query,$this->link);
$customer = mysql_fetch_array($c_result);
$cur_query='SELECT * FROM '.$_SESSION['database'].'_currencies WHERE id_currency=1';
$cur_result=mysql_query($cur_query,$this->link);
$currency=mysql_fetch_array($cur_result);
$s_query='SELECT * FROM '.$_SESSION['database'].'_speditions WHERE id_spedition=1';
$s_result=mysql_query($s_query,$this->link);
$spedition=mysql_fetch_assoc($s_result);
$spedition['spedition_cost']=0;
$p_query='SELECT * FROM '.$_SESSION['database'].'_payments WHERE id_payment=3';
$p_result=mysql_query($p_query,$this->link);
$payment=mysql_fetch_assoc($p_result);
$payment['payment_cost']=0;
$total_price=1000;
if ($customer['expiration']>'2000-01-01'):
$expiration_start=$customer['expiration'];
$expiration_end=date('Y-m-d',strtotime($customer['expiration'].' +1year'));
else:
$expiration_start=date('Y-m-d',strtotime('-1days'));
$expiration_end=date('Y-m-d',strtotime('+1year'));
endif;
/*Konec načítání*/
/*Uložení objednávky*/
$insert='INSERT INTO `'.$_SESSION['database'].'_orders` ( `id_customer` , `id_session` , ip , `ct_rate` , `ct_name` , `ct_color` , `total_price` , `id_currency` , `currency_rate`, `order_date`, `nazev_f` , `jmeno_f`, `prijmeni_f`, `ulice_f` , `psc_f` , `obec_f` , `stat_f` , `ico` , `dic` , `platce_dph` , `nazev_p` , `jmeno_p`, `prijmeni_p`, `ulice_p` , `psc_p` , `obec_p` , `stat_p` , `phone` , `email` , `cislo_faktury` , `datum_faktury`,`datum_splatnosti` , `var_symbol` , `spec_symb` , `payment_cost` , `payment_name` , `spedition_cost` , `spedition_name` , `id_state` , `poznamka`, expiration_start,expiration_end)
VALUES("' . $_SESSION['id_customer'] . '","' . $_SESSION['id'] . '","' . $_SERVER['REMOTE_ADDR'] . '","1","' . $_SESSION['ct_name'] . '","' . $_SESSION['ct_color'] . '", "' . $total_price . '","' . $currency['id_currency'] . '","' . $currency['rate'] . '", NOW() ,"' . $customer['nazev_f'] . '","' . $customer['jmeno_f'] . '","' . $customer['prijmeni_f'] . '","' . $customer['ulice_f'] . '","' . $customer['psc_f'] . '","' . $customer['obec_f'] . '","' . $customer['stat_f'] . '","' . $customer['ico'] . '","' . $customer['dic'] . '","' . $customer['platce_dph'] . '","' . $customer['nazev_p'] . '","' . $customer['jmeno_p'] . '","' . $customer['prijmeni_p'] . '","' . $customer['ulice_p'] . '","' . $customer['psc_p'] . '","' . $customer['obec_p'] . '","' . $customer['stat_p'] . '","' . $customer['phone'] . '","' . $customer['email1'] . '","' . $_SESSION['id'] . '", NOW() , NOW() ,"' . $_SESSION['id'] . '","' . $spec_symb . '","' . $payment['payment_cost'] . '","' . $payment['payment_name'] . '","' . $spedition['spedition_cost'] . '", "' . $spedition['spedition_name'] . '", "1","' . addslashes($poznamka) . '","'.$expiration_start.'","'.$expiration_end.'")';
//echo $insert; //V případě nutné kontroly tohodle jeblýho příkazu
$i_result = mysql_query($insert, $this->link);
if ($i_result)://pokud se to povede, tak pokračujem, když ne tak to oznámíme
else: return '<div id="error">' . CHYBA_DATABAZE . '</div>';endif;
/*Konec uložení objednávky*/
/*Zapsání jednotlivých položek to tabulky ordered_items a jejich vymazání ze session a databáze pomocí funkce add_cart s nastavením quantity=0*/
//podle id_session najdeme id_order
$o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_session='.$_SESSION['id'] . ' ORDER BY id_order DESC LIMIT 1';
$o_result = mysql_query($o_query,$this->link);
$order = mysql_fetch_array($o_result);
$in_query = 'INSERT INTO `'.$_SESSION['database'].'_ordered_items` (`id_order`,`id_item`,`id_specific`,`item_name`,`kod`,`price`,`dph`,`quantity`) VALUES ("' . $order['id_order'] . '","0","' . $id_specific . '","Roční členský poplatek BONUSOVÉHO KLUBU SLIM WINE / 1 rok","SW1","826.4462809917355371900826446281","21", "1")';
$in_result = mysql_query($in_query,$this->link);
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: " . $this->get_const('ROBOT_MAIL') . "\n";
$text= CLENSTVI_EMAIL;
$this->confirm_order($id_session,sha1($id_session),$text);
$text.=$this->show_send_order($order['id_order']);
$subject=$_SESSION['eshop_name'] . ':: '.CLENSTVI_EMAIL_HEADER;
if ($customer['email1']<>""):
mail($customer['email1'],$this->zakoduj_predmet($subject),$text,$headers);
endif;
if ($customer['email2']<>""):
mail($customer['email2'],$this->zakoduj_predmet($subject),$text,$headers);
endif;
mail($this->get_const('ORDER_EMAIL'),$this->zakoduj_predmet($subject),$text,$headers);
return '<div id="error">'.CLENSTVI_OBJEDNANO.'</div>' . $this->show_order($order['id_order']);
/*Vypsání informací na obrazovku a jejich odeslání na email*/
/*Konec vypsání a odesílání infomací*/
}//End of function order
function zpusob_platby_dodani($id_payment=0,$id_spedition=0){
/*Dostane informace o způsobu platby a uloží je do session*/
if ($id_payment<>0):$_SESSION['id_payment']=$id_payment;
$p_query='SELECT * FROM '.$_SESSION['database'].'_payments WHERE id_payment=' . $id_payment;
$p_result=mysql_query($p_query, $this->link);
$payment=mysql_fetch_array($p_result);
//echo "cena objednaných položek:" . $_SESSION['price'];
if ($_SESSION['price']>=$this->get_const("PLATBA_ZDARMA")): $_SESSION['payment_cost']=0;
else: $_SESSION['payment_cost']=round($payment['payment_cost']);
endif;
endif;
if ($id_spedition<>0):$_SESSION['id_spedition']=$id_spedition;
$s_query='SELECT * FROM '.$_SESSION['database'].'_speditions WHERE id_spedition=' . $id_spedition;
$s_result=mysql_query($s_query, $this->link);
$spedition=mysql_fetch_array($s_result);
if($id_spedition==1 || $id_spedition==2)://Členové
$_SESSION['spedition_cost']=0;
elseif ($_SESSION['price']>=$this->get_const("DOPRAVA_ZDARMA") && $_SESSION['clen']==0 && $id_spedition==3):
$_SESSION['spedition_cost']=0;
elseif ($_SESSION['clen']==0 && $id_spedition==3):
$_SESSION['spedition_cost']=99;
elseif($id_spedition==3)://Členové
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=500;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=210;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=190;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=160;
else:
$_SESSION['spedition_cost']=130;
endif;
elseif($id_spedition==4)://Členové SK
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=800;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=560;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=360;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=260;
else:
$_SESSION['spedition_cost']=160;
endif;
elseif($id_spedition==5)://Dodání do Polska
$cur_query='SELECT * FROM '.$_SESSION['database'].'_currencies WHERE id_currency=4';
$cur_result=mysql_query($cur_query,$this->link);
$currency=mysql_fetch_assoc($cur_result);
/*2 lahve 20 ZLOTÝCH
6 lahví 25 ZLOTÝCH
12 lahví 35 ZLOTÝCH*/
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=35*$currency['rate'];;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=25*$currency['rate'];;
else:
$_SESSION['spedition_cost']=20*$currency['rate'];
endif;
elseif($id_spedition==8)://Dodání do Polska EN
$cur_query='SELECT * FROM '.$_SESSION['database'].'_currencies WHERE id_currency=4';
$cur_result=mysql_query($cur_query,$this->link);
$currency=mysql_fetch_assoc($cur_result);
/*2 lahve 20 ZLOTÝCH
6 lahví 25 ZLOTÝCH
12 lahví 35 ZLOTÝCH*/
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=35*$currency['rate'];;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=25*$currency['rate'];;
else:
$_SESSION['spedition_cost']=20*$currency['rate'];
endif;
endif;
endif;
}//END of function zpusob_platby_dodani
function show_cart($id_payment=0,$id_spedition=0,$onetime=1) //displays content of the shopping cart with editation form returns string output
{//BEGIN function show_cart
if (($_SESSION['payment_cost'] + $_SESSION['spedition_cost'] + $_SESSION['price'])==0)
return '<div id="error">' . PRAZDNY_KOSIK . '</div>'; //cart doesn't exist
else
$this->zpusob_platby_dodani($_SESSION['id_payment'],$_SESSION['id_spedition']);//Refreshing shipment and payment costs
$cart = $_SESSION['cart'];
$return .= '<h1>' . VAS_KOSIK . '</h1>';
$return .= '<form name="kosik_form" action="'.$this->create_href('nakupni-kosik').'" method="post" id="nakkosik">
<input type="hidden" name="update" value="1" />
<table id="kosik" cellspacing="0"><tr><th style="width:80px;" >' . KOD . '</th><th>' . NAZEV_ZBOZI . '</th><th align="right">' . CENA_ZA_KS . '</th><th align="right">' . MNOZSTVI . '</th><th></th>';if($_SESSION['show_dph']==1):$return.='<th align="right">' . BEZ_DPH . '</th><th style="width:45px;" align="center">' . DPH . '</th><th style="width:" align="right">' . S_DPH . '</th>'; else:$return.='<th align="right">' . CENA_CELKEM . '</th>'; endif; $return.='</tr>';
$counter=1;
foreach($cart as $id_item=>$array):
$quantity=$array['quantity'];
//echo 'Čísla:' . $id_item . 'Specific:' . $id_specific . 'Původní:' . $id_item_specific;
if ($quantity!=0):
$query = 'SELECT * FROM '.$_SESSION['database'].'_items WHERE id_item=' . $id_item;
//echo $query;
$result = mysql_query($query,$this->link);
$item = mysql_fetch_array($result);
$item_names= $this->get_item_names($item['id_item']);
$item['item_name']=$item_names['item_name'];
$item['item_description_short']=strip_tags($item_names['item_description_short']);
$item['item_description']=$item_names['item_description'];
if ($array['price']<>0):
$item['item_price']=$array['price'];
endif;
if ($_SESSION['clen']==1):
$item['item_price']=$item['common_price'];
endif;
$c_query = 'SELECT id_category FROM '.$_SESSION['database'].'_sections WHERE id_section=' . $item['id_section'];
$c_result = mysql_query($c_query,$this->link);
/*if ($quantity<=$item['store'])://Pokud je zboží skladem nastavíme příslušnou barvu buňky množství a title
$color='background-color:#5FC95F;';
$title=JE_SKLADEM;
else:
$color='background-color:#cc3400;';
$title=NENI_SKLADEM;
endif;
*/
if ($c_result):
$category = mysql_fetch_array($c_result);
else: $return .= '<div id="error">' . PRODUKT . ' ' . $id_item . ' ' . PRODUKT_ODEBRAN . '</div>';
$_SESSION['cart'][$id_item]['quantity']=0;
if ($this->check_login())://Smazání věci z databáze v případě přihlášeného uživatele
$delete = 'DELETE FROM '.$_SESSION['database'].'_preorder WHERE id_item=' . $id_item . ' AND id_customer=' . $_SESSION['id_customer'];
$d_result = mysql_query($delete, $this->link);
endif;
$this->add_cart($id_item,0);break;
endif;
$dph_query='SELECT * FROM '.$_SESSION['database'].'_dph WHERE id_dph=' . $item['id_dph'];
$dph_result=mysql_query($dph_query,$this->link);
if ($dph_result):
$dph=mysql_fetch_array($dph_result);
else:
$dph['dph']=0;
endif;
/*Pro každou věc v databázi vytvoří jednu řádku tabulky košíku*/
if ($coutner%2==1):$suda_licha='licha';else:$suda_licha='suda';endif;
$coutner+=1;
$return .= '<tr class="' . $suda_licha . '" onmouseover="xxx=this.style.backgroundColor;this.style.backgroundColor=\'#DEECF9\';" onmouseout="this.style.backgroundColor=xxx;">
<td>' . $_SESSION['cart'][$id_item]['kod'] .'</td>
<td><a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$category['id_category'],$item['id_section'],$item['id_item']) . '">'
. $item['item_name'];
$return .= '</a></td>
<td align="right" style="padding-right:5px;">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']) . '</td>
<td align="right">';
/*if ($_SESSION['clen']==1):
$return.='
<select name="in' . $id_item . '" style="width:80px;font-size:24px;" onchange="this.form.submit();">
<option value="2"';if($_SESSION['cart'][$id_item]['quantity']==2):$return.=' selected="selected"';endif;$return.='>2</option>
<option value="6"';if($_SESSION['cart'][$id_item]['quantity']==6):$return.=' selected="selected"';endif;$return.='>6</option>
<option value="12"';if($_SESSION['cart'][$id_item]['quantity']==12):$return.=' selected="selected"';endif;$return.='>12</option>
<option value="24"';if($_SESSION['cart'][$id_item]['quantity']==24):$return.=' selected="selected"';endif;$return.='>24</option>
<option value="36"';if($_SESSION['cart'][$id_item]['quantity']==36):$return.=' selected="selected"';endif;$return.='>36</option>
<option value="48"';if($_SESSION['cart'][$id_item]['quantity']==48):$return.=' selected="selected"';endif;$return.='>48</option>
</select>';
else:*/
$return .= '<input name="in' . $id_item . '" style="width:80px;font-size: 24px;" value="'.$_SESSION['cart'][$id_item]['quantity'].'" />';
//endif;
$return.='
</td>
<td nowrap="nowrap"><input style="width:14px;height:14px;margin-right:5px;" type="image" title="' . ODESLAT_UPRAVY . '" alt="' . ODESLAT_UPRAVY . '" value="' . ODESLAT_UPRAVY . '" src="img/update.gif" /><a href="' . $this->create_href('odstran-z-kosiku','','','','vyrobek=' . $item['id_item']) . '" onclick="return(confirm(\'' . OPRAVDU_ODSTRANIT . '\'))"><img src="img/delete.gif" title="' . OSTRANIT_Z_KOSIKU . '" alt="' . $this->clean_alt($item['item_description_short']) . '" /></a></td>';
if($_SESSION['show_dph']==1):
$return .='<td align="right">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']*$quantity) . '</td>
<td align="center" style="color:' . $dph['dph_color'] . ';">' . $dph['dph'] . '%</td>
<td align="right">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']*(100+($dph['dph']*$_SESSION['show_dph']))/100*$quantity) . '</td>
</tr>'."\n";
else:
$return .='<td align="right">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']*(100+($dph['dph']*$_SESSION['show_dph']))/100*$quantity) . '</td>
</tr>'."\n";
endif;
endif;
endforeach;/*konec zobrazování produktů v košíku*/
$return .= '<tr><td colspan="2"><input style="width:92px; height:17px;margin-top:10px;" type="image" alt="' . PROVED_ZMENY . '" value="' . PROVED_ZMENY . '" title="' . PROVED_ZMENY . '" src="img/button-ulozit-zmeny-' . $_SESSION['lang'] . '.gif" /></td><td colspan="' . (4+2*$_SESSION['show_dph']) .'" align="right" style="font-size:115%;font-weight: bold;">' . SOUCET . ': <span style="color:#442d02;font-weight: bold;">' . $this->calculate_price() . '</span></td></tr>';//součet všech položek
$return .= '</table></form><br />';
//$return .= '<tr><td colspan="6"><hr /></td></tr>';//součet všech položek
if ($_SESSION['price']>0): //Pouze při neprázdném košíku
/*Výběr způsobu platby.*/
/*Zakázané kombinace payment/spedition pomocí idéček*/
$disabled_payment=array(); //základně je zakázána platba e-Bankou
$disabled_spedition=array();
if ($_SESSION['id_payment']==0): //Když ještě není zvolen způsob platby je nutné některé zakázat
if ($_SESSION['id_spedition']==1):$disabled_payment=array(2,4,5);endif; //v případě osobního odběru nelze zaplatit dobírkou + e-bankou
if ($_SESSION['id_spedition']==2):$disabled_payment=array(1,4,5);endif; //PPL - nelze zaplatit hotově + e-bankou
if ($_SESSION['id_spedition']==3):$disabled_payment=array(1,4,5);endif; //Messenger - nelze zaplatit hotově + e-bankou
if ($_SESSION['id_spedition']==4):$disabled_payment=array(1,4,5);endif; //Česká pošta - nelze zaplatit hotově + e-bankou
endif;
/*Způsob platby lze změnit vždy*/
if ($_SESSION['id_payment']==1):$disabled_spedition=array(2,3,4);endif; //v případě hotovostní platby nutný osobní odběr
if ($_SESSION['id_payment']==2):$disabled_spedition=array();endif; //v případě dobírky nelze odebrat osobně
/*V případě zakázané kombinace se vynuluje $_SESSION['id_payment']*/
if (in_array($_SESSION['id_spedition'],$disabled_spedition)):
$_SESSION['id_spedition']=0;
$_SESSION['spedition_cost']=0;
endif;
/*Konec nastavení zakázaných kombinací*/
$p_query='SELECT * FROM '.$_SESSION['database'].'_payments WHERE id_lang="'.$_SESSION['id_lang'].'" AND active="Ano" ORDER BY id_payment';
$p_result=mysql_query($p_query, $this->link);
$return .= '<table><form action="'.$this->create_href('zpusob-platby-dodani').'#platba-dodani" method="post"><table id="platba-dodani" cellspacing="0" cellpadding="5">';
$return .= '<tr><td colspan="2"><h2 class="nadpis_kosik">' . ZPUSOB_PLATBY . '</h2></td></tr>';
$counter=1;
while ($payment=mysql_fetch_array($p_result)):
$return.='<tr class="';
if (($counter%2)==1): $return.= 'licha'; else: $return.= 'suda';endif;
$return.='"><td><input onclick="this.form.submit()" type="radio" name="id_payment" value="' . $payment['id_payment'] . '"';
if ($_SESSION['id_payment']==$payment['id_payment']): $return.= 'checked="checked"';endif;
if (in_array ($payment['id_payment'],$disabled_payment)): $return.= 'disabled="disabled"';endif;
$return.=' /><td class="name_payment_spedition">' . $payment['payment_name'] . '</td><td>' . $payment['payment_description'] . '</td></tr>' . "\n";
$counter+=1;
endwhile;
$return .= '<tr><td colspan="3" align="right"><h2 style="font-weight:bold;">' . ZA_PLATBU . ': <span style="color:#442d02;">' . $this->format_price($_SESSION['payment_cost']) . '</span></h2></td></tr>';
//Ověříme, zda je způsob dodání podporován daným jazykem, když ne, tak ho vynulujem
$ch_query='SELECT id_lang FROM '.$_SESSION['database'].'_speditions WHERE id_spedition=' . $_SESSION['id_spedition'];
$ch_result=mysql_query($ch_query,$this->link);
$check=mysql_fetch_assoc($ch_result);
if ($check['id_lang']<>$_SESSION['id_lang']):
$_SESSION['id_spedition']=0;
$_SESSION['spedition_cost']=0;
$id_spedition=$_SESSION['id_spedition'];
endif;
/*Výběr způsobu dodání*/
$s_query='SELECT * FROM '.$_SESSION['database'].'_speditions WHERE id_lang=' . $_SESSION['id_lang'] . ' AND active="Ano" ORDER BY id_spedition';
$s_result=mysql_query($s_query, $this->link);
$return .= '<tr><td colspan="3"><h2 class="nadpis_kosik">' . ZPUSOB_DODANI . '</h2></td></tr>';
$counter=1;
while ($spedition=mysql_fetch_array($s_result)):
$return.='<tr class="';
if (($counter%2)==1): $return.= 'licha'; else: $return.= 'suda';endif;
$return.='"><td><input onclick="this.form.submit()" type="radio" name="id_spedition" value="' . $spedition['id_spedition'] . '"';
if ($_SESSION['id_spedition']==$spedition['id_spedition']): $return.= ' checked="checked"';endif;
if (in_array ($spedition['id_spedition'],$disabled_spedition)): $return.= ' disabled="disabled"';endif;
$return.=' /><td class="name_payment_spedition">' . $spedition['spedition_name'] . '</td><td>' . $spedition['spedition_description'] . '</td></tr>' . "\n";
$counter+=1;
endwhile;
$return .= '<tr><td colspan="3" align="right"><h2 style="font-weight:bold;padding:5px;">' . ZA_DOPRAVU . ': <span style="color:#442d02;">' . $this->format_price($_SESSION['spedition_cost']) . '</span></h2></td></tr>';
//$return .= '<tr><td colspan="3"><div id="pament_spedition_footer"><h2>' . CENA_VCETNE . ': <span style="color:#442d02;font-size:125%;position:absolute;right:8px;">' . $this->format_price($_SESSION['price']+$_SESSION['payment_cost']+$_SESSION['spedition_cost']) . '</span></h2></div></td></tr>';
if ($this->check_login()):
$return .= '<tr><td colspan="3" align="right"><a href="' . $this->create_href('adresa-dodani') . '"><img style="margin-top:15px;margin-bottom:15px;" src="img/button-pokracovat-' . $_SESSION['lang'] . '.gif" alt="' . POKRACOVAT . '" title="' . POKRACOVAT . '" /></a></td></tr>';
$return .= '</table></form>';
else:
$return .= '</table></form>';
/*$return.='<h2 class="nadpis_kosik">Přihlaste se</h2>
<div class="login_menu">
<form action="" method="post">
<table style="width:100%;">
<tr><td> ' . UZIVATEL . ': </td><td><input class="form_cell" type="text" name="username" value="" size="12" maxlength="25" /></td>
<td> ' . HESLO . ': </td><td><input class="form_cell" type="password" name="password" value="" size="12" maxlength="35" /></td>
<td><input type="image" value="' . PRIHLASIT . '" title="' . PRIHLASIT . '" src="img/login-button-ok.jpg" /></td>
<td style="text-align:right;"><a href="'.$this->create_href('registrace').'">Založit nový účet</a></td></tr>
</table>
</form>
</div>';*/
if($this->get_const('ONETIME_ORDER')==1 && $onetime==1):
$return .= $this->show_onetime_form();
endif;
endif;
endif;
//$return .= '<div style="padding: 12px; text-align: center; border: 1px solid #bbb; border-radius: 12px; margin: 12px 0;"><strong>Peníze na nákup v našem eshopu již zítra na Vašem účtu</strong> &mdash; <a href="http://forms.cgonline.cz/homecredit#a_aid=503dbb55e7376&amp;a_bid=68942c19" target="_top"><strong>Zažádat online &raquo;</strong></a><img style="border:0" src="http://affiliate-program.crescogroup.org/scripts/imp.php?a_aid=503dbb55e7376&amp;a_bid=68942c19" width="1" height="1" alt="" /></div>';
return $return;
}//END function show_cart
function show_onetime_form($podminky='',$nazev_f='',$jmeno_f='',$prijmeni_f='',$ulice_f='',$psc_f='',$obec_f='',$stat_f='',$nazev_p='',$jmeno_p='',$prijmeni_p='',$ulice_p='',$psc_p='',$obec_p='',$stat_p='',$ico='',$dic='',$email1='',$telef1='') {//BEGIN function show_onetime_form
/*Na základě vstupních údajů vypíše buď prázdný nebo již předvyplněný formulář na registraci. Chybné vyplnění je kontrolováno ve funkci registration.*/
$return = '
<form id="registration" action="'. $this->create_href('objednavka-bez-registrace') . '" method="post">
<table id="onetime" style="margin-top:12px;">
<tr><td colspan="4"><h2 class="nadpis_kosik">Jednorázová objednávka bez registrace</h2></td></tr>
<tr><td colspan="4"title="' . FAKTURACNI_INFO . '"><h2>' . FAKTURACNI_ADRESA . ':</h2></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long" title="" maxlength="100" type="text" placeholder="'.NEPOVINNE.'" name="nazev_f" value="' . $nazev_f . '"></td></tr>
<tr><td class="required">' . JMENO . ':</td><td><input type="text" maxlength="50" name="jmeno_f" value="' . $jmeno_f . '" /></td><td class="required">' . PRIJMENI . ':</td><td><input type="text" class="right" maxlength="50" name="prijmeni_f" value="' . $prijmeni_f . '" /></td></tr>
<tr><td class="required">' . ULICE . ':</td><td><input type="text" maxlength="50" name="ulice_f" value="' . $ulice_f . '" /></td><td class="required">' . MESTO . ':</td><td><input type="text" class="right" maxlength="50" name="obec_f" value="' . $obec_f . '" /></td></tr>
<tr><td class="required">' . PSC . ':</td><td><input type="text" maxlength="6" name="psc_f" value="' . $psc_f . '" /></td><td class="required">' . STAT . ':</td><td><select name="stat_f" class="right">' . $this->states_options() . '</select></td></tr>
<tr><td >' . IC . ':</td><td><input type="text" maxlength="12" name="ico" placeholder="'.NEPOVINNE.'" value="' . $ico . '" /></td><td>' . DIC . ':</td><td><input class="right" type="text" maxlength="50" name="dic" placeholder="'.NEPOVINNE.'" value="' . $dic . '" /></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4" title="' . DODACI_ADRESA_LONG . '"><h2>' . DODACI_ADRESA . ':</h2></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long" maxlength="100" type="text" name="nazev_p" placeholder="'.NEPOVINNE.'" value="' . $nazev_p . '" /></td></tr>
<tr><td>' . JMENO . ':</td><td><input maxlength="50" type="text" name="jmeno_p" value="' . $jmeno_p . '" /></td><td>' . PRIJMENI . ':</td><td><input class="right" maxlength="50" type="text" name="prijmeni_p" value="' . $prijmeni_p . '" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input maxlength="50" type="text" name="ulice_p" value="' . $ulice_p . '" /></td><td>' . MESTO . ':</td><td><input class="right" maxlength="50" type="text" name="obec_p" value="' . $obec_p . '" /></td></tr>
<tr><td>' . PSC . ':</td><td><input maxlength="6" type="text" name="psc_p" value="' . $psc_p . '" /></td><td>' . STAT . ':</td><td><select class="right" name="stat_p">' . $this->states_options() . '</select></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>' . OSTATNI_UDAJE . ':</h2></td></tr>
<tr><td class="required">' . TELEFON . ':</td><td><input type="text" maxlength="20" name="telef1" value="' . $telef1 . '" /></td><td class="required">' . EMAIL . ':</td><td><input type="text" maxlength="40" name="email1" value="' . $email1 . '" /></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>'.SLEVA.':</h2></td></tr>
<tr><td colspan="2" style="font-size:16px;"><strong>'.I_SLEVA_Q.'?</strong> '.I_SLEVA_CLEN.':</td><td>
<input name="affiliate" style="width:80px;font-size: 26px;" value="'.$_SESSION['id_referal'].'" />
</td>
</tr>
<tr><td colspan="4" style="height:18px;">&nbsp;</td></tr>
';
if($podminky=="on"):
$return.= '<tr><td colspan="3" class="required" style="text-align:right;"><input type="checkbox" name="podminky" checked="checked" style="width:auto;" /> &larr; ' . SOUHLAS . '</td><td style="text-align:center;"><input style="width:auto;border:none;" type="image" src="./img/button-pokracovat-' . $_SESSION['lang'] . '.gif" name="' . POKRACOVAT . '" value="' . POKRACOVAT . '" /></td></tr>';
else: $return.= '<tr><td colspan="3" class="required" style="text-align:right;"><input type="checkbox" name="podminky" style="width:auto;" /> &larr; ' . SOUHLAS . '</td><td style="text-align:center;"><input style="width:auto;border:none;" type="image" src="./img/button-pokracovat-' . $_SESSION['lang'] . '.gif" name="' . POKRACOVAT . '" value="' . POKRACOVAT . '" /></td></tr>';
endif;
$return.= '
<!--tr><td colspan="4" align="right";><input style="width:auto;" type="image" src="./img/button-pokracovat-' . $_SESSION['lang'] . '.gif" name="' . POKRACOVAT . '" value="' . POKRACOVAT . '" /></td></tr-->
</table>
</form>';
return $return;
}
function adresa_dodani($nazev_p="",$jmeno_p="",$prijmeni_p="",$ulice_p="",$obec_p="",$psc_p="",$stat_p=""){//Zpracuje data z košíku do tabulky, fakturační údaje a je-li to potřeba, tak se dotáže na doručovací adresu
$id_payment=$_SESSION['id_payment'];
$id_spedition=$_SESSION['id_spedition'];
$cur_query='SELECT * FROM '.$_SESSION['database'].'_currencies as c,'.$_SESSION['database'].'_langs as l WHERE l.id_currency=c.id_currency AND l.id_lang=' . $_SESSION['id_lang'];
$cur_result=mysql_query($cur_query,$this->link);
$currency=mysql_fetch_assoc($cur_result);
$id_currency=$currency['id_currency'];
$return="";//příprava proměnné
$error=false;
/*Ověření poslaných údajů - jsou-li špatné, zobrazí kosik a vypise chybu*/
$return.='<div id="error">';
if ($_SESSION['price']<=0):$return.= NIC_OBJEDNANEHO . '<br />';$error=true;endif;
//if ($id_payment==0):$return.= NENI_ZPUSOB_PLATBY . '<br />';$error=true;endif;
if ($id_spedition==0):$return.= NENI_ZPUSOB_DOPRAVY . '<br />';$error=true;endif;
if (!$this->check_login()):$return.= NEJSTE_PRIHLASEN . ' <a href="javascript:void(0);" onclick="MM_swapVisibility' . "('login');" . '">' . PRIHLASTE_SE . '</a>. ' . POKUD_NEREGISTROVAN . ' <a href="' . $this->create_href('registrace') . '">' . REGISTRUJTE . '</a><br />';$error=true;endif;
if ($_POST['username']):$error=true;endif;//Když se zrovna přihlašuje, tak aby zůstal na stejné stránce!
$return.='</div>';
if ($error==true):return ($return . $this->show_cart($id_payment,$id_spedition));endif;
/*Konec kontroli údajů*/
/*Výpis objdednávkového formuláře. Nejprve vypíše všechny údaje o uživateli,
pak ho nechá vyplnit dodací adresu a nakonec ukáže objednané zboží.*/
$return="";//vynulování proměnné
$c_query = 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='.$_SESSION['id_customer'];
$c_result = mysql_query($c_query,$this->link);
$customer = mysql_fetch_array($c_result);//Získání infomací o uživateli
/*Pokud už byl tento formulář nesprávně vyplňěn a odeslán budou nepovinné parametry této funkce neprázdné, tudíž je použijeme
a přepíšeme takto dodanými údaji proměnné v poli $customer*/
if ($nazev_p<>""):$customer['nazev_p']=$nazev_p;endif;
if ($jmeno_p<>""):$customer['jmeno_p']=$jmeno_p;endif;
if ($prijmeni_p<>""):$customer['prijmeni_p']=$prijmeni_p;endif;
if ($ulice_p<>""):$customer['ulice_p']=$ulice_p;endif;
if ($obec_p<>""):$customer['obec_p']=$obec_p;endif;
if ($psc_p<>""):$customer['psc_p']=$psc_p;endif;
if ($stat_p<>""):$customer['stat_p']=$stat_p;endif;
/*Konec přepisování údajů*/
/*Nalezneme nějaký telefon*/
if($customer['telef2']<>''): $phone=$customer['telef2'];endif;
if($customer['telef1']<>''): $phone=$customer['telef1'];endif;
if($customer['mobil2']<>''): $phone=$customer['mobil2'];endif;
if($customer['mobil1']<>''): $phone=$customer['mobil1'];endif;
/*Konec nalézání telefonu*/
/*Plus označíme aktuální stát*/
$state_query='SELECT * FROM '.$_SESSION['database'].'_countries WHERE country="' . $customer['stat_p'] . '"';
$state_result=mysql_query($state_query,$this->link);
if ($state_result):
$state=mysql_fetch_assoc($state_result);
$customer['id_stat_p']=$state['id_country'];
endif;
/*Konec vybírání státu*/
$return .= '<h1>' . DODACI_FAKTURACNI . '</h1>
<div>' . ZKONTROLUJTE_DOPLNTE . '</div><br />
<form id="registration" action="'.$this->create_href('objednano').'" method="post">
<table>
<input type="hidden" name="id_payment" value="' . $id_payment . '" />
<input type="hidden" name="id_spedition" value="' . $id_spedition . '" />
<input type="hidden" name="id_currency" value="' . $id_currency . '" />
<tr><td colspan="4"title="' . FAKTURACNI_INFO . '"><h2>' . FAKTURACNI_ADRESA . ':</h2></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long readonly" readonly="readonly" title="" maxlength="100" type="text" name="nazev_f" value="' . $customer['nazev_f'] . '"></td></tr>
<tr><td>' . JMENO . ':</td><td><input class="readonly" maxlength="50" type="text" readonly="readonly" name="jmeno_f" value="' . $customer['jmeno_f'] . '" /></td><td>' . PRIJMENI . ':</td><td><input class="right readonly" maxlength="50" type="text" readonly="readonly" name="prijmeni_f" value="' . $customer['prijmeni_f'] . '" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input class="readonly" type="text" readonly="readonly" maxlength="50" name="ulice_f" value="' . $customer['ulice_f'] . '" /></td><td>' . MESTO . ':</td><td><input class="right readonly" type="text" readonly="readonly" maxlength="50" name="obec_f" value="' . $customer['obec_f'] . '" /></td></tr>
<tr><td>' . PSC . ':</td><td><input class="readonly" type="text" readonly="readonly" maxlength="5" name="psc_f" value="' . $customer['psc_f'] . '" /></td><td>' . STAT . ':</td><td><select class="right readonly" readonly="readonly" name="stat_f"><option value="' . $customer['stat_f'] . '">' . $customer['stat_f'] . '</option></select></td></tr>
<tr><td>' . IC . ':</td><td><input class="readonly" type="text" readonly="readonly" maxlength="5" name="ico" value="' . $customer['ico'] . '" /></td><td>' . DIC . ':</td><td><input class="right readonly" type="text" maxlength="50" readonly="readonly" name="dic" value="' . $customer['dic'] . '" /></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4" title="' . VYPLNTE_DODACI_UDAJE . '"><h2>' . DODACI_ADRESA_SHORT . ':</h2></td></tr>';
/*Pokud existuje poštovní adresa, tak ji vypíše, pokud ne tak tam doplní údaje z fakturační adresy. K odeslání objednávky bude vyžadována kompletní dodací adresa.*/
$return.='<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long" maxlength="100" type="text" name="nazev_p" value="';if($customer['nazev_p']<>""):$return.=$customer['nazev_p'];else:$return.=$customer['nazev_f'];endif;$return.='" /></td></tr>
<tr><td>' . JMENO . ':</td><td><input maxlength="50" type="text" name="jmeno_p" value="'; if($customer['jmeno_p']<>""):$return.=$customer['jmeno_p'];else:$return.=$customer['jmeno_f'];endif;$return.='" /></td><td>' . PRIJMENI . ':</td><td><input class="right" maxlength="50" type="text" name="prijmeni_p" value="'; if($customer['prijmeni_p']<>""):$return.=$customer['prijmeni_p'];else:$return.=$customer['prijmeni_f'];endif;$return.='" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input maxlength="50" type="text" name="ulice_p" value="'; if($customer['ulice_p']<>""):$return.=$customer['ulice_p'];else:$return.=$customer['ulice_f'];endif;$return.='" /></td><td>' . MESTO . ':</td><td><input class="right" maxlength="50" type="text" name="obec_p" value="'; if($customer['obec_p']<>""):$return.=$customer['obec_p'];else:$return.=$customer['obec_f'];endif;$return.='" /></td></tr>';
$return.='<tr><td>' . PSC . ':</td><td><input maxlength="5" type="text" name="psc_p" value="'; if($customer['psc_p']<>""):$return.=$customer['psc_p'];else:$return.=$customer['psc_f'];endif;$return.='" /></td>';
$return.='<td>' . STAT . ':</td><td><select class="right" name="stat_p">';
/*Výpis možných států*/
if ($customer['stat_p']<>$customer['stat_f'] && (($customer['psc_p']=='' || $customer['psc_p']==$customer['psc_f']) || ($customer['ulice_p']=='' || $customer['ulice_p']==$customer['ulice_f']) || ($customer['obec_p']=='' || $customer['obec_p']==$customer['obec_f']))):
$customer['stat_p']=$customer['stat_f'];
endif;
$return.=$this->states_options(0,$customer['stat_p']);
/*Konec výpisu možných států*/
$return.='</select></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4" title="' . PO_OBJEDNANI . '"><h2>' . KONTAKTNI_UDAJE . ':</h2></td></tr>
<tr><td>' . KONTAKTNI_TELEFON . ':</td><td><input type="text" maxlength="13" name="phone" value="' . $phone . '" /></td><td>' . EMAIL . ':</td><td><input class="readonly right" readonly="readonly" style="width:140px;" type="text" maxlength="40" name="email" value="' . $customer['email1'] . '" /></td></tr>
<!--tr><td>' . SPEC_SYMBOL . ':</td><td><input type="text" maxlength="4" name="spec_symb" value="' . $customer['spec_symb'] . '" /></td><td>' . CISLO_OBJEDNAVKY . ':</td><td><input class="readonly right" style="width:140px;" type="text" readonly="readonly" maxlength="10" name="var_symbol" value="' . $_SESSION['id'] . '" /></td></tr-->
<tr><td>'.OBJ_POZNAMKA.':</td><td colspan="3"><textarea style="heigt:75px;width:100%;" name="poznamka" value=""></textarea></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>' . OBJEDNANE_POLOZKY . ':</h2></td></tr>';
/*Vypsání přehledu nákupního košíku od tabulky v jedné buňce nadřazené tabulky*/
$cart = $_SESSION['cart'];
$return .= ' <tr><td colspan="4">
<table id="kosik" cellspacing="0"><tr><th style="width:60px;" >' . KOD . '</th><th style="width:120px;">' . NAZEV_ZBOZI . '</th><th align="right">' . CENA_ZA_KS . '</th><th align="right">' . MNOZSTVI . '</th>';if($_SESSION['show_dph']==1):$return.='<th align="right">' . BEZ_DPH . '</th><th style="width:45px;" align="center">' . DPH . '</th><th style="width:" align="center">' . S_DPH . '</th>'; else:$return.='<th align="right">' . CENA_CELKEM . '</th>'; endif; $return.='</tr>';
$count=1;
foreach($cart as $id_item=>$array)
{
$quantity=$array['quantity'];
if ($quantity!=0):
$query = 'select * from '.$_SESSION['database'].'_items where id_item='.$id_item;
$result = mysql_query($query,$this->link);
$item=mysql_fetch_array($result);
if ($array['price']<>0):
$item['item_price']=$array['price'];
endif;
if ($_SESSION['clen']==1):
$item['item_price']=$item['common_price'];
endif;
$item_names= $this->get_item_names($item['id_item']);
$item['item_name']=$item_names['item_name'];
$item['item_description_short']=$item_names['item_description_short'];
$item['item_description']=$item_names['item_description'];
$dph_query='SELECT * FROM '.$_SESSION['database'].'_dph WHERE id_dph=' . $item['id_dph'];
$dph_result=mysql_query($dph_query,$this->link);
if ($dph_result):
$dph=mysql_fetch_array($dph_result);
else:
$dph['dph']=0;
endif;
/*$specific_query='SELECT * FROM item_specifics WHERE id_specific=' . $id_specific;
$specific_result=mysql_query($specific_query,$this->link);
if (mysql_num_rows($specific_result)==1)://Když existuje specific, tak to přidáme k názvu věci
$item['item_name'].=' (' . mysql_result($specific_result, 0, 'specific_name') . ')';
endif;*/
/*Pro každou věc v databázi vytvoří jednu řádku tabulky*/
if ($count%2==1):$class="licha";else:$class="suda";endif;
$return .= '<tr class="' . $class . '" onmouseover="xxx=this.style.backgroundColor;this.style.backgroundColor=\'#DEECF9\';" onmouseout="this.style.backgroundColor=xxx;">
<td>' . $_SESSION['cart'][$id_item]['kod'] .'</td>
<td><a href="' . $this->create_href($this->get_const('SORTIMENT_NAME'),$this->get_category_by_id_section($item['id_section']),$item['id_section'],$item['id_item']) . '">' . $item['item_name'];
$return.='</a></td>
<td align="right" style="padding-right:5px;">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']) . '</td>
<td align="right"><input readonly="readonly" type="text" size="5" name="in' . $id_item .'" value="' . $quantity .'" /></td>';
if($_SESSION['show_dph']==1):
$return .='<td align="right">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']*$quantity) . '</td>
<td align="center" style="color:' . $dph['dph_color'] . ';">' . $dph['dph'] . '%</td>
<td align="right">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']*(100+($dph['dph']*$_SESSION['show_dph']))/100*$quantity) . '</td>
</tr>'."\n";
else:
$return .='<td align="right">' . $this->format_price($item['item_price']*$_SESSION['ct_rate']*(100+($dph['dph']*$_SESSION['show_dph']))/100*$quantity) . '</td>
</tr>'."\n";
endif;
$count+=1;
endif;
}
$return .= '</table></td></tr>';//ukončení přehledu nákupního košíku
/*Vypsání způsobu dodání a způsobu platby a celkové ceny*/
$p_query='SELECT * FROM '.$_SESSION['database'].'_payments WHERE id_payment=' . $id_payment;
$p_result=mysql_query($p_query, $this->link);
$payment=mysql_fetch_array($p_result);
$s_query='SELECT * FROM '.$_SESSION['database'].'_speditions WHERE id_spedition=' . $id_spedition;
$s_result=mysql_query($s_query, $this->link);
$spedition=mysql_fetch_array($s_result);
/*Zjistíme a uložíme, zda platí dopravu a platbu*/
$paying_payment=1;
$paying_spedition=1;
$return .= '<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>' . PREHLED_OBJEDNAVKY . ':</h2></td></tr>';
$return .= '<tr><td colspan="3">' . ZPUSOB_PLATBY . ': <strong>' . $payment['payment_name'] . '</strong></td><td align="right"><strong>' . $this->format_price($_SESSION['payment_cost']*$paying_payment) . '</strong></td></tr>';
$return .= '<tr><td colspan="3">' . ZPUSOB_DODANI . ': <strong>' . $spedition['spedition_name'] . '</strong></td><td align="right"><strong>' . $this->format_price($_SESSION['spedition_cost']*$paying_spedition) . '</strong></td></tr>';
$return .= '<tr><td colspan="3">' . CENA_OBJEDNANEHO_ZBOZI . '</td><td align="right"><strong>' . $this->format_price($_SESSION['price']) . '</strong></td></tr>';
$return .= '<tr><td colspan="4"><hr /></td></tr>';
$total_price=($_SESSION['payment_cost']*$paying_payment) + ($_SESSION['spedition_cost']*$paying_spedition) + $_SESSION['price'];
$return .= '<tr style="font-size:110%"><td colspan="3">' . CELKOVA_CENA_OBJEDNAVKY . '</td><td align="right"><strong>' . $this->format_price($total_price) . '</strong></td></tr>
<tr><td colspan="4" align="right">';
$return.='<input type="image" style="margin-top:10px;" value="' . ODESLAT_OBJEDNAVKU . '" title="' . ODESLAT_OBJEDNAVKU . '" src="img/button-objednat-' . $_SESSION['lang'] . '.gif" />';
$return .= '</td></tr>
</table>
</form>';
return $return;
}//End of function adresa_dodani
function order($id_payment,$id_spedition,$id_currency,$nazev_f="", $jmeno_f="",$prijmeni_f="", $ulice_f="", $obec_f="", $psc_f="",$stat_f="",$nazev_p="", $jmeno_p="",$prijmeni_p="", $ulice_p="", $obec_p="", $psc_p="",$stat_p="",$phone="",$email="",$spec_symb="",$poznamka=""){
/*Funkce získá jako parametry hodnoty z formuláře z funkce adresa_dodani, zkontroluje platnost údajů.
V případě chyby ji vypíše na stránce s formulařem adresa_dodani. Pokud je vše v pořádku, tak zapíše
objednávku do databáze a informuje uživatele o všech potřebných skutečnostech a dále také vyprázní
obsah košíku a vymaže údaje o věcech v košíku z databáze. Nakonec odešle zákazníkovi e-mail s infomacemi.*/
/*Ověřování poslaných infomací-fakturační údaje jsou jasné. Dále je potřeba*/
if ($jmeno_p=="" || $prijmeni_p=="" || $ulice_p=="" || $obec_p=="" || $psc_p==""): return ('<div id="error">' . NEKOMPLETNI_ADRESA . '</div>' . $this->adresa_dodani($nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$obec_p,$psc_p,$stat_p));endif;
if (($_SESSION['payment_cost'] + $_SESSION['spedition_cost'] + $_SESSION['price'])==0): return ('<div id="error">' . ZADNA_OBJEDNAVKA . '</div>' . $this->moje_objednavky());endif;
if ($id_payment==0):return ('<div id="error">' . NENI_ZPUSOB_PLATBY . '</div>' . $this->adresa_dodani($id_payment,$id_spedition,$nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$obec_p,$psc_p));endif;
if ($id_spedition==0):return ('<div id="error">' . NENI_ZPUSOB_DOPRAVY . '</div>' . $this->adresa_dodani($nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$obec_p,$psc_p,$stat_p));endif;
/*Konec ověřování údajů*/
/*Nejprve si načteme všechny údaje o zákazníkovi do pole $customer*/
$c_query = 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='.$_SESSION['id_customer'];
$c_result = mysql_query($c_query,$this->link);
$customer = mysql_fetch_array($c_result);
$cur_query='SELECT * FROM '.$_SESSION['database'].'_currencies WHERE id_currency=' . $id_currency;
$cur_result=mysql_query($cur_query,$this->link);
$currency=mysql_fetch_array($cur_result);
$s_query='SELECT * FROM '.$_SESSION['database'].'_speditions WHERE id_spedition=' . $id_spedition;
$s_result=mysql_query($s_query,$this->link);
$spedition=mysql_fetch_assoc($s_result);
if($id_spedition==1 || $id_spedition==2)://Členové
$_SESSION['spedition_cost']=0;
elseif ($_SESSION['price']>=$this->get_const("DOPRAVA_ZDARMA") && $_SESSION['clen']==0):
$_SESSION['spedition_cost']=0;
elseif ($_SESSION['clen']==0):
$_SESSION['spedition_cost']=99;
elseif($id_spedition==3)://Členové
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=500;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=210;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=190;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=160;
else:
$_SESSION['spedition_cost']=130;
endif;
elseif($id_spedition==4)://Členové SK
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=800;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=560;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=360;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=260;
else:
$_SESSION['spedition_cost']=160;
endif;
elseif($id_spedition==5)://Dodání do Polska
$cur_query='SELECT * FROM '.$_SESSION['database'].'_currencies WHERE id_currency=4';
$cur_result=mysql_query($cur_query,$this->link);
$currency=mysql_fetch_assoc($cur_result);
/*2 lahve 20 ZLOTÝCH
6 lahví 25 ZLOTÝCH
12 lahví 35 ZLOTÝCH*/
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=35*$currency['rate'];;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=25*$currency['rate'];;
else:
$_SESSION['spedition_cost']=20*$currency['rate'];
endif;
elseif($id_spedition==8)://Dodání do Polska EN
$cur_query='SELECT * FROM '.$_SESSION['database'].'_currencies WHERE id_currency=4';
$cur_result=mysql_query($cur_query,$this->link);
$currency=mysql_fetch_assoc($cur_result);
/*2 lahve 20 ZLOTÝCH
6 lahví 25 ZLOTÝCH
12 lahví 35 ZLOTÝCH*/
if ($_SESSION['price']>=4600)://25+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif ($_SESSION['price']>=2300)://13+
$_SESSION['spedition_cost']=50*$currency['rate'];;
elseif($_SESSION['price']>=1200)://7+
$_SESSION['spedition_cost']=35*$currency['rate'];;
elseif($_SESSION['price']>=500)://3+
$_SESSION['spedition_cost']=25*$currency['rate'];;
else:
$_SESSION['spedition_cost']=20*$currency['rate'];
endif;
endif;
//if ($id_spedition==3):
$spedition['spedition_cost']=$_SESSION['spedition_cost'];
//endif;
$p_query='SELECT * FROM '.$_SESSION['database'].'_payments WHERE id_payment=' . $id_payment;
$p_result=mysql_query($p_query,$this->link);
$payment=mysql_fetch_assoc($p_result);
if ($_SESSION['price']>$this->get_const('PLATBA_ZDARMA')):
$payment['payment_cost']=0;
endif;
$total_price=$_SESSION['price']+($spedition['spedition_cost'])+($payment['payment_cost']);
/*Konec načítání*/
/*Uložení objednávky*/
$insert='INSERT INTO `'.$_SESSION['database'].'_orders` ( `id_customer` , `id_session` , ip , `ct_rate` , `ct_name` , `ct_color` , `total_price` , `id_currency` , `currency_rate`, `order_date`, `nazev_f` , `jmeno_f`, `prijmeni_f`, `ulice_f` , `psc_f` , `obec_f` , `stat_f` , `ico` , `dic` , `platce_dph` , `nazev_p` , `jmeno_p`, `prijmeni_p`, `ulice_p` , `psc_p` , `obec_p` , `stat_p` , `phone` , `email` , `cislo_faktury` , `datum_faktury`,`datum_splatnosti` , `var_symbol` , `spec_symb` , `payment_cost` , `payment_name` , `spedition_cost` , `spedition_name` , `id_state` , `poznamka`)
VALUES("' . $_SESSION['id_customer'] . '","' . $_SESSION['id'] . '","' . $_SERVER['REMOTE_ADDR'] . '","1","' . $_SESSION['ct_name'] . '","' . $_SESSION['ct_color'] . '", "' . $total_price . '","' . $currency['id_currency'] . '","' . $currency['rate'] . '", NOW() ,"' . $nazev_f . '","' . $jmeno_f . '","' . $prijmeni_f . '","' . $ulice_f . '","' . $psc_f . '","' . $obec_f . '","' . $stat_f . '","' . $customer['ico'] . '","' . $customer['dic'] . '","' . $customer['platce_dph'] . '","' . $nazev_p . '","' . $jmeno_p . '","' . $prijmeni_p . '","' . $ulice_p . '","' . $psc_p . '","' . $obec_p . '","' . $stat_p . '","' . $phone . '","' . $email . '","' . $_SESSION['id'] . '", NOW() , NOW() ,"' . $_SESSION['id'] . '","' . $spec_symb . '","' . $payment['payment_cost'] . '","' . $payment['payment_name'] . '","' . $spedition['spedition_cost'] . '", "' . $spedition['spedition_name'] . '", "2","' . addslashes($poznamka) . '")';
//echo $insert; //V případě nutné kontroly tohodle jeblýho příkazu
$i_result = mysql_query($insert, $this->link);
if ($i_result)://pokud se to povede, tak pokračujem, když ne tak to oznámíme
else: return '<div id="error">' . CHYBA_DATABAZE . '</div>';endif;
/*Konec uložení objednávky*/
/*Zapsání jednotlivých položek to tabulky ordered_items a jejich vymazání ze session a databáze pomocí funkce add_cart s nastavením quantity=0*/
//podle id_session najdeme id_order
$o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_session='.$_SESSION['id'] . ' ORDER BY id_order DESC LIMIT 1';
$o_result = mysql_query($o_query,$this->link);
$order = mysql_fetch_array($o_result);
$cart = $_SESSION['cart'];
foreach($cart as $id_item=>$array)
{ $quantity=$array['quantity'];
if ($quantity!=0):
$query = 'SELECT * FROM '.$_SESSION['database'].'_items WHERE id_item=' . $id_item; //nacteme si vec
$result = mysql_query($query,$this->link);
$item = mysql_fetch_array($result);
if ($array['price']<>0):
$item['item_price']=$array['price'];
else:
$psection_query='SELECT * FROM '.$_SESSION['database'].'_sections WHERE id_section=' . $row['id_section'];
$psection_result=mysql_query($psection_query,$this->link);
$psection=mysql_fetch_assoc($psection_result);
$pcategory_query='SELECT * FROM '.$_SESSION['database'].'_categories WHERE id_category=' . $section['id_category'];
$pcategory_result=mysql_query($pcategory_query,$this->link);
$pcategory=mysql_fetch_assoc($pcategory_result);
$row['item_price']*=$psection['section_rate']*$pcategory['category_rate'];
$row['common_price']*=$psection['section_rate']*$pcategory['category_rate'];
endif;
if ($_SESSION['clen']==1):
$item['item_price']=$item['common_price'];
endif;
$c_query = 'SELECT id_category FROM '.$_SESSION['database'].'_sections WHERE id_section=' . $item['id_section'];
$c_result = mysql_query($c_query,$this->link);
$category = mysql_fetch_array($c_result);
$dph_query='SELECT * FROM '.$_SESSION['database'].'_dph WHERE id_dph=' . $item['id_dph'];
$dph_result=mysql_query($dph_query,$this->link);
$specific_query='SELECT * FROM '.$_SESSION['database'].'_item_specifics WHERE id_specific=' . $id_specific;
$specific_result=mysql_query($specific_query,$this->link);
if ($specific_result && mysql_num_rows($specific_result)==1):
$specific_name=mysql_fetch_assoc($specific_result);
$specific_name=$specific_name['specific_name'];
else:
$specific_name='--není--';
endif;
if ($dph_result):
$dph=mysql_fetch_array($dph_result);
else:
$dph['dph']=0;
endif;
if ($customer['platce_dph']==1):$dph['dph']=0;endif;
/*Úprava kódu*/
if ($item['interni_kod']):
$_SESSION['cart'][$id_item]['kod']=$item['interni_kod'];
endif;
/*Vkládání*/
$item_names= $this->get_item_names($item['id_item']);
$heureka_items_array[]=$item_names['item_name'];
$in_query = 'INSERT INTO `'.$_SESSION['database'].'_ordered_items` (`id_order`,`id_item`,`id_specific`,`specific_name`,`kod`,`price`,`dph`,`quantity`) VALUES ("' . $order['id_order'] . '","' . $id_item . '","' . $id_specific . '","' . $specific_name . '","' . $_SESSION['cart'][$id_item]['kod'] . '","' . $item['item_price']*$_SESSION['ct_rate'] .'","' . $dph['dph'] .'", "' . $quantity . '")';
//echo $in_query;
/*Úprava skladu*/
//$sk_query = 'UPDATE items set store=store-' . $quantity . ' WHERE id_item=' . $id_item . ' LIMIT 1';
//$sk_result = mysql_query($sk_query,$this->link);
$in_result = mysql_query($in_query,$this->link);
/*vložíme specifikace do tabulky ordered_specifics*/
$ioi_query='SELECT id_ordered_item FROM '.$_SESSION['database'].'_ordered_items WHERE id_item=' . $id_item . ' AND id_order=' . $order['id_order'];//zjistíme číslo objednané věci
$ioi_result=mysql_query($ioi_query,$this->link);
$id_ordered_item=mysql_fetch_assoc($ioi_result);
$id_ordered_item=$id_ordered_item['id_ordered_item'];
/*Konec vkládání specifikácí*/
if ($in_result)://pokud se to povede, tak pokračujem, když ne tak to oznámíme
else: return '<div id="error">' . CHYBA_DATABAZE . '</div>';endif;
/*Vymažeme to pomocí funkce add_cart*/
$this->add_cart($id_item,"0");
endif;
}
/*Ještě je nuné vymazat všechny ceny a vytvořit novou session, neboť její číslo bylo použito jako číslo objednávky*/
$id_session=$_SESSION['id'];
$_SESSION['id']="";//zničí starou session
$ct_rate=$_SESSION['ct_rate'];//Musíme zachovat tuto část session
$this->create_cart();//vytvoří novou session
$_SESSION['ct_rate']=$ct_rate;
$query = "insert into ".$_SESSION['database']."_logins(ip, id_customer) values ('".$_SERVER['REMOTE_ADDR']."', '$_SESSION[id_customer]')";
$l_result = mysql_query($l_query, $this->link); //vloží další řádek do tabulky logins s novým id_session
/*Konec předělávání session*/
/*Konec zapisování a mazání jednotlivých položek*/
/*Odešleme informace do Heureka.cz
require_once ('heureka/HeurekaOvereno.php');
try {
$overeno = new HeurekaOvereno('ec07f7269a87fe3ac78a3aeb6a579e1a');
$overeno->setEmail($customer['email1']);
//print_r($heureka_items_array);
foreach ($heureka_items_array as $key=>$produkt):
$overeno->addProduct($produkt);
endforeach;
$overeno->send();
} catch (Exception $e) {
print $e->getMessage();
}
/*Odešleme e-mail s upozorněním na objednávku*/
/*$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8;\n";
$headers .= "From: " . $email . "\n";
$text='Zákazník ' . $nazev_f . '( ' . $jmeno_f . ' ' . $prijmeni_f . ' ) odeslal objednávku.';
$text.=$this->show_order($order['id_order']);
mail($this->get_const('ORDER_EMAIL'), $this->zakoduj_predmet('Nová objednávka'),$text,$headers);
/*Odešleme email zákazníkovi s žádostí o potvrzení*/
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: " . $this->get_const('ROBOT_MAIL') . "\n";
$text= OBJ_EMAIL;
$this->confirm_order($id_session,sha1($id_session),$text);
$text.=$this->show_send_order($order['id_order']);
$subject=$_SESSION['eshop_name'] . ':: '.OBJ_EMAIL_HEADER;
if ($customer['email1']<>""):
mail($customer['email1'],$this->zakoduj_predmet($subject),$text,$headers);
endif;
if ($customer['email2']<>""):
mail($customer['email2'],$this->zakoduj_predmet($subject),$text,$headers);
endif;
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: " . $customer['email1'] . "\n";
$subject=$_SESSION['eshop_name'] . ':: Nová objednávka';
$text='Zákazník ' . $customer['nazev_f'] . '( ' . $customer['jmeno_f'] . ' ' . $customer['prijmeni_f'] . ' ) odeslal objednávku.<br /><br />'.$text;
$text.=$this->show_send_order($order['id_order']);
mail($this->get_const('ORDER_EMAIL'), $this->zakoduj_predmet($subject),$text,$headers);
mail('stepanek@microdesign.cz', $this->zakoduj_predmet($subject),$text,$headers);
return '<div id="error">' . USPESNE_OBJEDNANO . '</div>' . $this->moje_objednavky();
/*Vypsání informací na obrazovku a jejich odeslání na email*/
/*Konec vypsání a odesílání infomací*/
}//End of function order
function confirm_order($id_session,$hash_num,$text)
{//Po kliknutí na odkaz v emailu se potvrdí objednávka
$query='SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_session=' . $id_session;
$result=mysql_query($query,$this->link);
$order=mysql_fetch_assoc($result);
//if ($hash_num<>sha1($order['id_session'])):return('<div id="error">' . KOD_NEODPOVIDA . '</div>');endif;
if ($order['id_state']>1):
return('<div id="error">' . OBJEDNAVKA_JIZ_POTVRZENA . '</div>');
else:
$u_query='UPDATE '.$_SESSION['database'].'_orders SET id_state=2 WHERE id_order=' . $order['id_order'] . ' LIMIT 1';
$u_result=mysql_query($u_query,$this->link);
if ($u_result):
/*Odešleme zprávu s objednávkou na adresu obchodu */
$c_query = 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='. $order['id_customer'];
$c_result = mysql_query($c_query,$this->link);
$customer = mysql_fetch_array($c_result);
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: " . $customer['email1'] . "\n";
$subject=$_SESSION['eshop_name'] . ':: Nová objednávka';
$text='Zákazník ' . $customer['nazev_f'] . '( ' . $customer['jmeno_f'] . ' ' . $customer['prijmeni_f'] . ' ) odeslal objednávku.<br /><br />'.$text;
$text.=$this->show_send_order($order['id_order']);
mail($this->get_const('ORDER_EMAIL'), $this->zakoduj_predmet($subject),$text,$headers);
mail('stepanek@microdesign.cz', $this->zakoduj_predmet($subject),$text,$headers);
return('<div id="error">' . OBJEDNAVKA_POTVRZENA . '</div>');
else:
return('<div id="error">' . CHYBA_DATABAZE . '</div>');
endif;
endif;
}//End of function confirm_order
function states_options($id_country=0,$country_name=''){//Vrátí všechny možné státy jako select
$return='';
$query='SELECT * FROM '.$_SESSION['database'].'_countries ORDER BY id_country';
$result=mysql_query($query,$this->link);
while ($country=mysql_fetch_assoc($result)):
$return.='<option '; if($id_country==$country['id_country'] || $country_name==$country['country']):$return.='selected="selected" ';endif; $return.='value="' . $country['country'] . '">' . $country['country'] . '</option>';
endwhile;
return($return);
}//End of function states_options
function moje_udaje($newsletter="", $nazev_p="",$jmeno_p="",$prijmeni_p="",$ulice_p="",$psc_p="",$obec_p="",$stat_p="",$bank_ucet="",$bank_iban="",$bank_kod="",$spec_symb="",$email1="",$email2="",$telef1="",$telef2="",$mobil1="",$mobil2="",$fax1="",$fax2="")
{/*Tato funkce slouží pro změnu údajů o uživateli*/
//Nejprve načteme údaje o uživateli a případně vracíme error
if (!$_SESSION['id_customer']): return('<div id="error">' . PRO_ZMENU_NUTNE_PRIHLASENI . '</div>');endif;
$c_query = 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='.$_SESSION['id_customer'];
$c_result = mysql_query($c_query,$this->link);
$customer = mysql_fetch_assoc($c_result);
//Pokud jde o navrácený formulář, tak přepíšeme všechny proměnné na krátké názvy
foreach ($customer as $key => $value):
if ($$key<>"" && isset($$key)):
else: $$key=$value;
//echo ' Neznámá ' . $key . ' má hodnotu ' . $$key;
endif;
endforeach;
//Pak zapíšeme formulář
$return = '
<h1>' . ZMENA_UDAJU . '</h1>
<div>' . ZMENA_TEXT . '</div><br />
<form id="registration" action="'. $this->create_href('zmen-udaje') .'#odeslani" method="post">
<table>
<tr><td colspan="4"title="' . FAKTURACNI_INFO . '"><h2>' . FAKTURACNI_ADRESA . ':</h2></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long" title="" maxlength="100" type="text" name="nazev_f" value="' . $nazev_f . '"></td></tr>
<tr><td>' . JMENO . ':</td><td><input class="" type="text" maxlength="50" name="jmeno_f" value="' . $jmeno_f . '" /></td><td>' . PRIJMENI . ':</td><td><input class=" right" type="text" class="right" maxlength="50" name="prijmeni_f" value="' . $prijmeni_f . '" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input class="" type="text" maxlength="50" name="ulice_f" value="' . $ulice_f . '" /></td><td>' . MESTO . ':</td><td><input class=" right" type="text" class="right" maxlength="50" name="obec_f" value="' . $obec_f . '" /></td></tr>
<tr><td>' . PSC . ':</td><td><input class="" type="text" maxlength="5" name="psc_f" value="' . $psc_f . '" /></td><td>' . STAT . ':</td><td><select class=" right" name="stat_f" class="right">' . $this->states_options(0,$stat_f) . '</select></td></tr>
<tr><td>' . IC . ':</td><td><input class="" type="text" maxlength="12" name="ico" value="' . $ico . '" /></td><td>' . DIC . ':</td><td><input class=" right" class="right" type="text" maxlength="50" name="dic" value="' . $dic . '" /></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4" title="' . DODACI_ADRESA_LONG . '"><h2>' . DODACI_ADRESA . '</h2></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long" maxlength="100" type="text" name="nazev_p" value="' . $nazev_p . '" /></td></tr>
<tr><td>' . JMENO . ':</td><td><input maxlength="50" type="text" name="jmeno_p" value="' . $jmeno_p . '" /></td><td>' . PRIJMENI . ':</td><td><input class="right" maxlength="50" type="text" name="prijmeni_p" value="' . $prijmeni_p . '" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input maxlength="50" type="text" name="ulice_p" value="' . $ulice_p . '" /></td><td>' . MESTO . ':</td><td><input class="right" maxlength="50" type="text" name="obec_p" value="' . $obec_p . '" /></td></tr>
<tr><td>' . PSC . ':</td><td><input maxlength="5" type="text" name="psc_p" value="' . $psc_p . '" /></td><td>' . STAT . ':</td><td><select class="right" name="stat_p">' . $this->states_options(0,$stat_p) . '</select></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>' . OSTATNI_UDAJE . ':</h2></td></tr>
<tr><td>' . TELEFON . '1:</td><td><input type="text" maxlength="13" name="telef1" value="' . $telef1 . '" /></td><td></td><td><!--<input class="right" type="text" maxlength="10" name="ico" value="' . $ico . '" />--></td></tr>
<tr><td class="required">' . EMAIL . '1:</td><td><input type="text" maxlength="40" name="email1" value="' . $email1 . '" /></td><td>' . MOBIL . '1:</td><td><input type="text" class="right" maxlength="13" name="mobil1" value="' . $mobil1 . '" /></td></tr>
<tr><td>' . EMAIL . '2:</td><td><input type="text" maxlength="40" name="email2" value="' . $email2 . '" /></td><td>' . MOBIL . '2:</td><td><input type="text" class="right" maxlength="13" name="mobil2" value="' . $mobil2 . '" /></td></tr>
<tr><td>' . BANKOVNI_UCET . ':</td><td><input type="text" maxlength="50" name="bank_ucet" value="' . $bank_ucet . '" /></td><td>IBAN: </td><td><input type="text" class="right" maxlength="99" name="iban" value="' . $bank_iban . '" /></td></tr>';
if($newsletter=="1"):
$return.= '<tr><td>' . NOVINKY_AKCE . ':</td><td><input type="checkbox" name="newsletter" checked="checked" /></td><td>&nbsp;</td><td>&nbsp;</td></tr>';
else: $return.= '<tr><td>' . NOVINKY_AKCE . ':</td><td><input type="checkbox" name="newsletter" /></td><td>&nbsp;</td><td>&nbsp;</td></tr>';
endif;
$return.= '<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h2>' . ZMENA_HESLA . ':</h2></td></tr>
<tr><td colspan="3" class="required">Potvrzení současného hesla:</td><td><input class="right" type="password" name="pass" maxlength="20" value="" /></td></tr>
<tr><td colspan="3">' . NOVE_HESLO . ':</td><td><input class="right" type="password" name="password_customer1" maxlength="20" value="" /></td></tr>
<tr><td colspan="3">' . NOVE_HESLO_P . ':</td><td><input class="right" type="password" name="password_customer2" maxlength="20" value="" /></td></tr>';
$return.= ' <tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><input id="odeslani" type="submit" name="' . ZMENIT_UDAJE . '" value="' . ZMENIT_UDAJE . '" /></td></tr>
</table>
</form><br />';
return $return;
}//End of function moje údaje
function zmen_udaje($pass,$password_customer1="",$password_customer2="",$newsletter="", $nazev_p="",$jmeno_f="",$prijmeni_f="",$ulice_f="",$psc_f="",$obec_f="",$stat_f="",$nazev_p="",$jmeno_p="",$prijmeni_p="",$ulice_p="",$psc_p="",$obec_p="",$stat_p="",$bank_ucet="",$iban="",$bank_kod="",$spec_symb="",$email1="",$email2="",$telef1="",$telef2="",$mobil1="",$mobil2="",$fax1="",$fax2="",$ico='',$dic="")
{//Změní údaje a nakonec vypíše znovu formulář moje_udaje s novými inforcemi a se zprávou, zda změna proběhla úspěšně
//Kontrola údajů
if ($newsletter==on):$newsletter=1;else:$newsletter=0;endif; //Příprava proměnné na vložení do databáze
$name='<span style="color:red;">';
$error=false;
$c_query = 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer='.$_SESSION['id_customer'];
$c_result = mysql_query($c_query,$this->link);
$customer = mysql_fetch_array($c_result);
//echo $customer['password_customer'] . '=' . sha1($pass); //ladění
//if ($customer['password_customer']<>sha1($pass)):$error=true;$name.= SPATNE_KONTROLNI_HESLO . '<br />';endif; //špatné kontrolní heslo
if ((strlen($password_customer1)<5) && ($password_customer1<>"")):$error=true;$name.= NOVA_KRATKE . '<br />';endif; //krátké heslo
if ($password_customer1<>$password_customer2):$error=true;$name.= NOVA_RUZNA . '<br />';endif; //hesla nejsou stejná
if ($email1=="" && $email2==""):$error=true;$name.= NO_EMAIL . '<br />';endif; //nazadán žádný e-mail
$name.='</span><br />';
if ($error==true):
//Zobrazíme formulář pro změnu a vypíšeme chybu
$return= $this->moje_udaje($newsletter, $nazev_p,$jmeno_p,$prijmeni_p,$ulice_p,$psc_p,$obec_p,$stat_p,$bank_ucet,$iban,$bank_kod,$spec_symb,$email1,$email2,$telef1,$telef2,$mobil1,$mobil2,$fax1,$fax2);
$return.='<div id="error">' . $name . '</div>';
return($return);//V případě chyby se to vypíše uživateli a nic se nemění
endif;
/*Konec kontroly informací*/
$return='<div id="error">';
/*Změna hesla, pouze když jsou odeslány nová hesla*/
if ($customer['password_customer']==sha1($pass) && ($password_customer1==$password_customer2) && (strlen($password_customer1)>4) && ($password_customer1<>"")):
$update_pass='UPDATE '.$_SESSION['database'].'_customers SET password_customer="' . sha1(trim($password_customer1)) . '" WHERE id_customer=' . $_SESSION['id_customer'];
$result_pass=mysql_query($update_pass, $this->link);
if ($result_pass):
$return.= ZMENA_HESLA_U . '<br />';
endif;
endif;
/*Konec změny hesla*/
/*Úprava ostatních údajů - vždy*/
$update='UPDATE '.$_SESSION['database'].'_customers SET newsletter="' . $newsletter . '", nazev_f="' . $nazev_f . '", jmeno_f="' . $jmeno_f . '", prijmeni_f="' . $prijmeni_f . '", ulice_f="' . $ulice_f . '", psc_f="' . $psc_f . '", obec_f="' . $obec_f . '", stat_f="' . $stat_f . '", nazev_p="' . $nazev_p . '", jmeno_p="' . $jmeno_p . '", prijmeni_p="' . $prijmeni_p . '", ulice_p="' . $ulice_p . '", psc_p="' . $psc_p . '", obec_p="' . $obec_p . '", stat_p="' . $stat_p . '", bank_ucet="' . $bank_ucet . '", bank_iban="' . $iban . '", bank_kod="' . $bank_kod . '", spec_symb="' . $spec_symb . '", email1="' . $email1 . '", email2="' . $email2 . '", telef1="' . $telef1 . '", telef2="' . $telef2 . '", mobil1="' . $mobil1 . '", mobil2="' . $mobil2 . '", fax1="' . $fax1 . '", fax2="' . $fax2 . '", ico="' . $ico . '", dic="' . $dic . '" WHERE id_customer=' . $_SESSION['id_customer'];
$u_result=mysql_query($update, $this->link);
if ($u_result):
$return.= ZMENA_UDAJU_U;
else:
$return.=ZMENA_UDAJU_N;
endif;
/*Konec úpravy ostatních údajů*/
$return.='</div>';
return($this->moje_udaje() . $return);
}//End of function zmen_udaje
function moje_objednavky()
{//Zobrazí uživateli přehled jeho objednávek a také stav těchto objednávek
if (!$_SESSION['id_customer']): return('<div id="error">' . OBJEDNAVKY_PRIHLASENI . '</div>');endif;
$return='';
if ($_GET['error']==1):
$return.='<div id="error" style="color:red;">'.OBJ_CISLO.' '.$_GET['objednavka'].' '.OBJ_NEBYLA_UHRAZENA.'!!!</div>';
endif;
if ($_GET['error']==2):
$uo_query='UPDATE '.$_SESSION['database'].'_orders SET id_state="8" WHERE cislo_faktury="' . $_GET['objednavka'] . '" LIMIT 1';
$uo_result=mysql_query($uo_query,$this->link);
$return.='<div id="error"">'.OBJ_CISLO.' '.$_GET['objednavka'].' '.OBJ_BYLA_UHRAZENA.'!</div>';
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: " . $this->get_const('ROBOT_MAIL') . "\n";
$text= OBJ_PAY_EMAIL. $this->show_send_order($_GET['objednavka']);
$text.=$this->show_send_order($order['id_order']);
$subject=$_SESSION['eshop_name'] . '::'.OBJ_PAY_EMAIL_HEADER;
mail($this->get_const('ORDER_EMAIL'),$this->zakoduj_predmet($subject),$text,$headers);
endif;
$state_query='SELECT * FROM '.$_SESSION['database'].'_order_states';
$state_result=mysql_query($state_query, $this->link);
$return.='<div class="spacer"></div>
<div id="odkazy" style="position:relative;top:0px;left:0px;float:right;">
<table><tr><td>
' . ZOBRAZIT . ':</td><td>
<form id="show_states" action="'.$this->create_href('moje-objednavky').'" method="post">
<input type="hidden" name="action" value="update_show_state" \>
<select name="show_state" onchange="this.form.submit()">
<optgroup label="' . OBECNE . '">
<option name="show_state" value="all" ';if ($_SESSION['show_state']=='all'):$return.='selected="selected" ';endif;$return.='>' . VSECHNY . '</option>
<option name="show_state" value="done" ';if ($_SESSION['show_state']=='done'):$return.='selected="selected" ';endif;$return.='>' . VYRIZENE . '</option>
<option name="show_state" value="undone" ';if ($_SESSION['show_state']=='undone'):$return.='selected="selected" ';endif;$return.='>' . NEVYRIZENE . '</option>
</optgroup>
<optgroup label="' . STAVY . '">';
while ($state=mysql_fetch_assoc($state_result)):
//Zvolíme správný jazyk stavu objednávky
if ($_SESSION['lang']):
$col='state_name_'. $_SESSION['lang'];
$state['state_name']=$state[$col];
endif;
$return.='<option name="show_state" value="' . $state['id_state'] . '" ';if ($_SESSION['show_state']==$state['id_state']):$return.='selected="selected" ';endif;$return.='>';
$return.=$state['state_name'];
$return.='</option>';
endwhile;
$return.=' </optgroup>
</select>
</form></td></tr></table>
</div>
<h1>' . VASE_OBJEDNAVKY . ' :: ' . $_SESSION['show_name'] . '</h1>
<div class="spacer"></div><br />';
/*Vybere správný dotaz (filtr)*/
if ($_SESSION['show_state']>0): $o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_state=' . $_SESSION['show_state'] . ' AND id_customer=' . $_SESSION['id_customer'] . ' ORDER BY id_order DESC';endif;
if ($_SESSION['show_state']=='done'): $o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders AS o, '.$_SESSION['database'].'_order_states AS os WHERE o.id_state=os.id_state AND os.finished=1 AND o.id_customer=' . $_SESSION['id_customer'] . ' ORDER BY id_order DESC';endif;
if ($_SESSION['show_state']=='undone'): $o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders AS o, '.$_SESSION['database'].'_order_states AS os WHERE o.id_state=os.id_state AND os.finished=0 AND o.id_customer=' . $_SESSION['id_customer'] . ' ORDER BY id_order DESC';endif;
if ($_SESSION['show_state']=='all'): $o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_customer=' . $_SESSION['id_customer'] . ' ORDER BY id_order DESC';endif;
$o_result = mysql_query($o_query, $this->link);
if ((mysql_num_rows($o_result)==0) && ($_SESSION['show_state']=='all')): $return.='<div id="error">' . NO_OBJEDNAVKY . '</div>'; return ($return);endif; //Nejsou-li žádné objednávky, vrátí se toto
if (mysql_num_rows($o_result)==0): $return.='<div id="error">' . NO_IN_FILTER . '</div>'; return ($return);endif; //Nejsou-li žádné objednávky, vrátí se toto
$prevday = time() - (24 * 60 * 60);
$prevday=date("Y-m-d H:m:s", $prevday);
$return.= CHANGE_ORDER;
$return.='<br /><br /><table id="table_orders" class="full_width" cellspacing="0" cellpading="0">
<tr><th>' . CISLO_OBJEDNAVKY . '</th><th>' . CASTKA . '</th><th>' . STAV_OBJEDNAVKY . '</th><th>' . OBJEDNANO . '</th><th>' . POSLEDNI_ZMENA . '</th><th></th></tr>';
/*Pro každou objednávku vytvoříme vlastní řádek tabulky*/
$count=1;
while ($order=mysql_fetch_array($o_result)):
$c_query='SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer=' . $order['id_customer'];
$c_result=mysql_query($c_query,$this->link);
$customer=mysql_fetch_array($c_result);
$state_query='SELECT * FROM '.$_SESSION['database'].'_order_states WHERE id_state=' . $order['id_state'];
$state_result=mysql_query($state_query, $this->link);
$state=mysql_fetch_array($state_result);
//Zvolíme správný jazyk stavu objednávky
if ($_SESSION['lang']):
$col='state_name_'. $_SESSION['lang'];
$state['state_name']=$state[$col];
endif;
$return.='<tr';
if (($count%2)==1): $return.=' class="licha"'; else: $return.=' class="suda"'; endif;$return.=' onmouseover="xxx=this.style.backgroundColor;this.style.backgroundColor=\'#F2CCBF\';" onmouseout="this.style.backgroundColor=xxx;">';
//údaje o objednávce
$return.='<td>' . $order['cislo_faktury'] . '</td>
<td align="right">' . $this->format_price($order['total_price'],$order['id_currency'],$order['rate']) . '</td>
<td align="center" style="font-weight:bold;color:' . $state['state_color'] .';">' . $state['state_name'] . '</td>
<td>' . $order['order_date'] . '</td>
<td>' . $order['last_change'] .'</td>
<td>';
if ($state['in_stats']==0 && $state['finished']==0):
$return.='<a href="'.$this->create_href('zaplatit-objednavku','','','','objednavka='.$order['id_order']).'">'.OBJ_ZAPLATIT_DOKONCIT.'</a> | ';
elseif($state['in_stats']==1 && $state['finished']==1):
$return.='<a href="https://www.azeshop.cz/admin/res/slimwine/faktura.php?objednavka='.$order['id_order'].'&amp;check='.sha1($order['id_order']).'">'.OBJ_TISK_F.'</a>';
endif;
/*if($order['order_date']>$prevday && $this->get_const('STORNOVANI24')=="1")://Pokud je možno objednávku stornovat, tak zobrazíme tlačítko...
$return.=' | <a href="' . $this->create_href('stornovat-objednavku','','','','objednavka='. $order['id_order']) . '" onclick="return(confirm(\'' . REALY_STORNO . '\'))">' . STORNO . '</a>';
endif;*/
$return.='<a href="' . $this->create_href('ukaz-objednavku','','','','objednavka='. $order['id_order']) . '">'.OBJ_DETAIL.'</a></td>
</tr>';
$count+=1;
endwhile;
$return.='</table>';
return ($return);
}//End of function moje_objednavky
function show_send_order($id_order){//Zobrazí vybranou objednávku ve tvaru k odeslání
/*Načítání údajů z databáze*/
$o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_order=' . $id_order;
$o_result = mysql_query($o_query, $this->link);
$order=mysql_fetch_array($o_result);//Obsahuje informace o objednávce
$c_query= 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer=' . $order['id_customer'];
$c_result=mysql_query($c_query);
$customer=mysql_fetch_array($c_result);//Obsahuje údaje o zákazníkovi
$oi_query = 'SELECT * FROM '.$_SESSION['database'].'_ordered_items WHERE id_order=' . $order['id_order'];
$oi_result = mysql_query($oi_query, $this->link);//Obsahuje seznam objednaných položek
$state_query='SELECT * FROM '.$_SESSION['database'].'_order_states WHERE id_state=' . $order['id_state'];
$state_result=mysql_query($state_query, $this->link);
$state=mysql_fetch_array($state_result);//Obsahuje stav objednávky
//Zvolíme správný jazyk stavu objednávky
if ($_SESSION['lang']):
$col='state_name_'. $_SESSION['lang'];
$state['state_name']=$state[$col];
endif;
/*Konec načítání údajů z databáze*/
if ($_SESSION['id_customer']<>$order['id_customer']):return('<div id="error">' . NO_OPRAVNENI . '</div>');endif;
$return='<h1>' . OBJEDNAVKA_CISLO . ':: '.substr('000000000000'.$order['id_order'],-10,10).'</h1>';
$return.='<table>
<tr><td colspan="4"title="' . OBECNE_INFORMACE . '"><h3>' . OBECNE_INFORMACE . ':</h3></td></tr>
<tr><td>' . ZPUSOB_DODANI . ':</td><td colspan="3"><strong>' . $order['spedition_name'] . ' ( ' . $this->format_price($order['spedition_cost'],$order['id_currency'],$order['rate']) . ')</strong></td></tr>
<tr><td>' . ZPUSOB_PLATBY . ':</td><td colspan="3"><strong>' . $order['payment_name'] . ' ( ' . $this->format_price($order['payment_cost'],$order['id_currency'],$order['rate']) . ')</strong></td></tr>';
$return.='<tr><td>' . STAV_OBJEDNAVKY . ':</td><td colspan="3"><span style="color:' . $state['state_color'] .';">' . $state['state_name'] . '</span></td></tr>
<tr><td>' . CELKOVA_CENA . ':</td><td align="right"><strong>' . $this->format_price($order['total_price'],$order['id_currency'],$order['rate']) . '</strong></td><td></td><td></td></tr>
<tr><td>'.OBJ_CU.':</td><td align="right"><strong>'.$this->get_const('CISLO_UCTU').'</strong></td></tr>
'.OBJ_DETAIL_PLATBY.'
<tr><td>'.OBJ_VS.':</td><td align="right"><strong>'.substr('000000000000'.$order['id_order'],-10,10).'</strong></td></tr>
<tr><td>'.OBJ_SS.':</td><td align="right"><strong>'.substr('000000000000'.$order['id_customer'],-10,10).'</strong></td></tr>
<tr><td colspan="4">'.OBJ_PAY_INFO.'</td></tr>
<tr><td colspan="4">';
$return.='<h4>' . OBJEDNANE_POLOZKY . '</h4>';
$return.='<table id="table_ordered_items" cellspacing="0" cellpading="3">
<tr><tr><th style="width:70px;" >' . KOD . '</th><th style="width:120px;">' . NAZEV_ZBOZI . '</th><th align="right">' . CENA_ZA_KS . '</th><th align="right">' . MNOZSTVI . '</th>';if($_SESSION['show_dph']==1):$return.='<th align="right">' . BEZ_DPH . '</th><th style="width:45px;" align="center">' . DPH . '</th><th align="center">' . S_DPH . '</th>'; else:$return.='<th align="right">' . CENA_CELKEM . '</th>'; endif; $return.='</tr>';
/*Pro každou položku vytvoříme vlastní řádek tabulky*/
$count=1;
while ($ordered_item=mysql_fetch_array($oi_result)):
$item_name=$this->get_item_names($ordered_item['id_item']);
$return.='<tr';
if (($count%2)==1): $return.=' class="licha"'; else: $return.=' class="suda"'; endif;$return.=' onmouseover="xxx=this.style.backgroundColor;this.style.backgroundColor=\'#F2CCBF\';" onmouseout="this.style.backgroundColor=xxx;">
<td>' . $ordered_item['kod'] . '</td>
<td>' . $item_name['item_name'];
/*přidání vlastností*/
$or_att_query='SELECT * FROM '.$_SESSION['database'].'_ordered_specifics WHERE id_ordered_item =' . $ordered_item['id_ordered_item'];//Nalezneme attributy a pro každý uložíme do databáze hodnotu
$or_att_result=mysql_query($or_att_query,$this->link);
while ($attribute=mysql_fetch_assoc($or_att_result)):
$return.='<br />' . $attribute['specific_name'] .': ' . $attribute['specific_value'];
endwhile;
/*Konec přidávání vlastností*/
$return.='</td>
<td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate'],$order['id_currency'],$order['rate']) . '</td>
<td align="center">' . $ordered_item['quantity'] . '</td>';
if($_SESSION['show_dph']==1):$return.='<td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate']*$ordered_item['quantity'],$order['id_currency'],$order['rate']) . '</td><td align="center">' . $ordered_item['dph'] . '</td><td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate']*(100+$ordered_item['dph'])/100*$ordered_item['quantity'],$order['id_currency'],$order['rate']) . '</td>'; else:$return.='<td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate']*$ordered_item['quantity'],$order['id_currency'],$order['rate']) . '</td>';endif;
$return.='</tr>';
$count+=1;
endwhile;
$return.='</table>';
$return.='</td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"title="' . FAKTRURACNI_UDAJE . '"><h3>' . FAKTRURACNI_UDAJE . ':</h3></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3">' . $order['nazev_f'] . '</td></tr>
<tr><td>' . JMENO . ':</td><td>' . $order['jmeno_f'] . '</td><td>' . PRIJMENI . ':</td><td>' . $order['prijmeni_f'] . '</td></tr>
<tr><td>' . ULICE . ':</td><td>' . $order['ulice_f']. '</td><td>' . MESTO . ':</td><td>' . $order['obec_f'] . '</td></tr>
<tr><td>' . PSC . ':</td><td>' . $order['psc_f'] . '</td><td>' . STAT . ':</td><td>' . $order['stat_f'] . '</td></tr>
<tr><td>' . IC . ':</td><td>' . $order['ico'] . '</td><td>' . DIC . ':</td><td>' . $order['dic'] . '</td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4" title="' . DODACI_ADRESA_SHORT . '"><h4>' . DODACI_ADRESA_SHORT . ':</h4></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3">' . $order['nazev_p'] . '</td></tr>
<tr><td>' . JMENO . ':</td><td>' . $order['jmeno_p'] . '</td><td>' . PRIJMENI . ':</td><td>' . $order['prijmeni_p'] . '</td></tr>
<tr><td>' . ULICE . ':</td><td>' . $order['ulice_p'] . '</td><td>' . MESTO . ':</td><td>' . $order['obec_p'] . '</td></tr>
<tr><td>' . PSC . ':</td><td>' . $order['psc_p'] . '</td><td>' . STAT . ':</td><td>' . $order['stat_p'] . '</td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h4>' . OSTATNI_UDAJE . ':</h4></td></tr>
<tr><td>' . TELEFON . ':</td><td>' . $order['phone'] . '</td><td>' . EMAIL . ':</td><td>' . $order['email'] . '</td></tr>
<tr><td>' . BANKOVNI_UCET . ':</td><td>' . $order['bank_ucet'] . ' / ' . $order['bank_kod'] . '</td><td>' . SPEC_SYMBOL . ':</td><td>' . $order['spec_symb'] . '</td></tr>
<tr><td>' . OBJ_POZNAMKA . ':</td><td colspan="3">' . $order['poznamka'] . '</td></tr>';
$return.='</table>';
return($return);
}//End of function show_order
function zaplat_objednavku($id_order){//Zobrazí informace o platně pomocí převodu a odkaz na platební bránu paypal
$o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_order='.$id_order;
$o_result = mysql_query($o_query,$this->link);
$order = mysql_fetch_array($o_result);
if ($order['id_currency']==3):
$pay_price=round($order['total_price']/$order['currency_rate'],2);
$symbol='EUR';
elseif ($order['id_currency']==4):
$pay_price=round($order['total_price']/$order['currency_rate'],2);
$symbol='PLN';
else:
$pay_price=round($order['total_price']/$order['currency_rate'],2);
$symbol='CZK';
endif;
$paypal.= '
<h1>'.PAYPAL_PLATBA_OBJ.': '.substr('000000000000'.$order['id_order'],-10,10).'</h1>
<p>'.PAYPAL_T1.'</p>
<h2 style="color:#cc0000;font-size:16px;">'.PAYPAL_CC.'</h2>
<form id="paypal" action="https://www.paypal.com/cz/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick" />
<input type="hidden" name="business" value="director@dietfitness.cz" />
<input type="hidden" name="no_shipping" value="1" />
<input type="hidden" name="image_url" value="http://www.slimwine.cz/res/slimwine/Logo-Slimwine-Pecet.png" />
<input type="hidden" name="return" value="'.$this->create_href('moje-objednavky').'?error=2&amp;objednavka=' . $order['var_symbol'] . '" />
<input type="hidden" name="cancel_return" value="'.$this->create_href('moje-objednavky').'?error=1&amp;objednavka=' . $order['var_symbol'] . '" />
<input type="hidden" name="amount" value="'.$pay_price.'" style="width: 77px;" />
<input type="hidden" name="currency_code" value="'.$symbol.'" />
<input type="hidden" name="item_name" value="' . substr('000000000000'.$order['id_order'],-10,10) . '" />
<p>'.PAYPAL_T2.'</p>
<br /><p>'.PAYPAL_T3.' <a href="http://www.paypal.com/" target="_blank">'.PAYPAL_CLICK.'</a>.</p>
<br /><br /><p style="text-align: center;"><input type="image" src="./img/pay-button.png" value="'.POKRACOVAT.' &rsaquo;" /><br /><br /><br /></p>
</form>';
$paypal.= '
<h2 style="color:#cc0000;font-size:16px;">'.PAYPAL_PREVODEM.'</h2>
<p>'.PAYPAL_PREVODEM_INFO.'</p><br />
<table border="0" cellspacing="3" style="width:350px;">
<tr><td>'.OBJ_CU.':</td><td align="right"><strong>'.$this->get_const('CISLO_UCTU').'</strong></td></tr>
'.OBJ_DETAIL_PLATBY.'
<tr><td>'.OBJ_VS.':</td><td align="right"><strong>'.substr('000000000000'.$order['id_order'],-10,10).'</strong></td></tr>
<tr><td>'.OBJ_SS.':</td><td align="right"><strong>'.substr('000000000000'.$order['id_customer'],-10,10).'</strong></td></tr>
<tr><td>'.CASTKA.':</td><td align="right"><strong>'.$this->format_price($order['total_price'],$order['id_currency'],$order['rate']).'</strong></td></tr>
</table>
<p style="text-align:center;"><br />
<a class="paypal_next_button" href="'.$this->create_href('moje-objednavky').'" style="color:#fff;width:300px;margin:10px auto 10px auto;">'.PAYPAL_ZPET_NA_PREHLED.'</a>
<br /></p>
<div class="spacer" style="height:25px;">&nbsp;</div>
';
//$paypal=$error;
return($paypal);
}//End of function zaplat_objednavku
function show_order($id_order){//Zobrazí vybranou objednávku
/*Načítání údajů z databáze*/
$o_query = 'SELECT * FROM '.$_SESSION['database'].'_orders WHERE id_order=' . $id_order;
$o_result = mysql_query($o_query, $this->link);
$order=mysql_fetch_array($o_result);//Obsahuje informace o objednávce
$c_query= 'SELECT * FROM '.$_SESSION['database'].'_customers WHERE id_customer=' . $order['id_customer'];
$c_result=mysql_query($c_query);
$customer=mysql_fetch_array($c_result);//Obsahuje údaje o zákazníkovi
$oi_query = 'SELECT * FROM '.$_SESSION['database'].'_ordered_items WHERE id_order=' . $order['id_order'];
$oi_result = mysql_query($oi_query, $this->link);//Obsahuje seznam objednaných položek
$state_query='SELECT * FROM '.$_SESSION['database'].'_order_states WHERE id_state=' . $order['id_state'];
$state_result=mysql_query($state_query, $this->link);
$state=mysql_fetch_array($state_result);//Obsahuje stav objednávky
//Zvolíme správný jazyk stavu objednávky
if ($_SESSION['lang']):
$col='state_name_'. $_SESSION['lang'];
$state['state_name']=$state[$col];
endif;
/*Konec načítání údajů z databáze*/
if ($_SESSION['id_customer']<>$order['id_customer']):return('<div id="error">' . NO_OPRAVNENI . '</div>');endif;
if ($state['in_stats']==0 && $state['finished']==0):
$return.=$this->zaplat_objednavku($order['id_order']);
elseif($state['in_stats']==1 && $state['finished']==1):
$return.='<a href="https://www.azeshop.cz/admin/res/slimwine/faktura.php?objednavka='.$order['id_order'].'&amp;check='.sha1($order['id_order']).'">Tisk faktury</a>';
endif;
$return.='<h1>' . OBJEDNAVKA_CISLO . ':: '.substr('000000000000'.$order['id_order'],-10,10).'</h1>
<div id="odkazy"><a href="' . $this->create_href('moje-objednavky') . '">[' . ZPET . ']</a></div>';
$return.='<form id="registration" action="#" method="post"><table>
<tr><td colspan="4"title="' . OBECNE_INFORMACE . '"><h3>' . OBECNE_INFORMACE . ':</h3></td></tr>
<tr><td>' . ZPUSOB_DODANI . ':</td><td colspan="3"><strong>' . $order['spedition_name'] . ' ( ' . $this->format_price($order['spedition_cost'],$order['id_currency'],$order['rate']) . ')</strong></td></tr>
<tr><td>' . ZPUSOB_PLATBY . ':</td><td colspan="3"><strong>' . $order['payment_name'] . ' ( ' . $this->format_price($order['payment_cost'],$order['id_currency'],$order['rate']) . ')</strong></td></tr>';
$return.='<tr><td>' . STAV_OBJEDNAVKY . ':</td><td colspan="3"><span style="color:' . $state['state_color'] .';">' . $state['state_name'] . '</span></td></tr>
<tr><td>' . CELKOVA_CENA . ':</td><td align="right"><strong>' . $this->format_price($order['total_price'],$order['id_currency'],$order['rate']) . '</strong></td><td></td><td></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4">';
$return.='<h4>' . OBJEDNANE_POLOZKY . '</h4>';
$return.='<table id="table_ordered_items" cellspacing="0" cellpading="3">
<tr><tr><th style="width:70px;" >' . KOD . '</th><th style="width:120px;">' . NAZEV_ZBOZI . '</th><th align="right">' . CENA_ZA_KS . '</th><th align="right">' . MNOZSTVI . '</th>';if($_SESSION['show_dph']==1):$return.='<th align="right">' . BEZ_DPH . '</th><th style="width:45px;" align="center">' . DPH . '</th><th align="center">' . S_DPH . '</th>'; else:$return.='<th align="right">' . CENA_CELKEM . '</th>'; endif; $return.='</tr>';
/*Pro každou položku vytvoříme vlastní řádek tabulky*/
$count=1;
while ($ordered_item=mysql_fetch_array($oi_result)):
$item_name=$this->get_item_names($ordered_item['id_item']);
$return.='<tr';
if (($count%2)==1): $return.=' class="licha"'; else: $return.=' class="suda"'; endif;$return.=' onmouseover="xxx=this.style.backgroundColor;this.style.backgroundColor=\'#F2CCBF\';" onmouseout="this.style.backgroundColor=xxx;">
<td>' . $ordered_item['kod'] . '</td>
<td>' . $item_name['item_name'];
$return.='</td>
<td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate'],$order['id_currency'],$order['rate']) . '</td>
<td align="center">' . $ordered_item['quantity'] . '</td>';
if($_SESSION['show_dph']==1):$return.='<td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate']*$ordered_item['quantity'],$order['id_currency'],$order['rate']) . '</td><td align="center">' . $ordered_item['dph'] . '</td><td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate']*(100+$ordered_item['dph'])/100*$ordered_item['quantity'],$order['id_currency'],$order['rate']) . '</td>'; else:$return.='<td align="right">' . $this->format_price($ordered_item['price']*$order['ct_rate']*$ordered_item['quantity'],$order['id_currency'],$order['rate']) . '</td>';endif;
$return.='</tr>';
$count+=1;
endwhile;
$return.='</table>';
$return.='</td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"title="' . FAKTRURACNI_UDAJE . '"><h3>' . FAKTRURACNI_UDAJE . ':</h3></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long readonly" readonly="readonly" title="" maxlength="100" type="text" name="nazev_f" value="' . $order['nazev_f'] . '"></td></tr>
<tr><td>' . JMENO . ':</td><td><input class="readonly" readonly="readonly" type="text" maxlength="50" name="jmeno_f" value="' . $order['jmeno_f'] . '" /></td><td>' . PRIJMENI . ':</td><td><input class="readonly right" readonly="readonly" type="text" maxlength="50" name="prijmeni_f" value="' . $order['prijmeni_f'] . '" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input class="readonly" readonly="readonly" type="text" maxlength="50" name="ulice_f" value="' . $order['ulice_f']. '" /></td><td>' . MESTO . ':</td><td><input type="text" class="readonly right" readonly="readonly" maxlength="50" name="obec_f" value="' . $order['obec_f'] . '" /></td></tr>
<tr><td>' . PSC . ':</td><td><input class="readonly" readonly="readonly" type="text" maxlength="5" name="psc_f" value="' . $order['psc_f'] . '" /></td><td>' . STAT . ':</td><td><input class="readonly right" readonly="readonly" type="text" value="' . $order['stat_f'] . '" /></td></tr>
<tr><td>' . IC . ':</td><td><input class="readonly" readonly="readonly" type="text" maxlength="12" name="ico" value="' . $order['ico'] . '" /></td><td>' . DIC . ':</td><td><input class="readonly right" readonly="readonly" type="text" maxlength="50" name="dic" value="' . $order['dic'] . '" /></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4" title="' . DODACI_ADRESA_SHORT . '"><h4>' . DODACI_ADRESA_SHORT . ':</h4></td></tr>
<tr><td>' . NAZEV_FIRMY . ':</td><td colspan="3"><input class="long readonly" readonly="readonly" maxlength="100" type="text" name="nazev_p" value="' . $order['nazev_p'] . '" /></td></tr>
<tr><td>' . JMENO . ':</td><td><input class="readonly" readonly="readonly" maxlength="50" type="text" name="jmeno_p" value="' . $order['jmeno_p'] . '" /></td><td>' . PRIJMENI . ':</td><td><input class="readonly right" readonly="readonly" maxlength="50" type="text" name="prijmeni_p" value="' . $order['prijmeni_p'] . '" /></td></tr>
<tr><td>' . ULICE . ':</td><td><input class="readonly" readonly="readonly" maxlength="50" type="text" name="ulice_p" value="' . $order['ulice_p'] . '" /></td><td>' . MESTO . ':</td><td><input class="readonly right" readonly="readonly" maxlength="50" type="text" name="obec_p" value="' . $order['obec_p'] . '" /></td></tr>
<tr><td>' . PSC . ':</td><td><input class="readonly" readonly="readonly" maxlength="5" type="text" name="psc_p" value="' . $order['psc_p'] . '" /></td><td>' . STAT . ':</td><td><input class="readonly right" readonly="readonly" type="text" name="stat_p" value="' . $order['stat_p'] . '" /></td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td colspan="4"><h4>' . OSTATNI_UDAJE . ':</h4></td></tr>
<tr><td>' . TELEFON . ':</td><td><input class="readonly" readonly="readonly" type="text" maxlength="13" name="telef" value="' . $order['phone'] . '" /></td><td>' . EMAIL . ':</td><td><input class="readonly right" readonly="readonly" type="text" maxlength="40" name="email" value="' . $order['email'] . '" /></td></tr>
<tr><td>' . BANKOVNI_UCET . ':</td><td><input class="readonly" readonly="readonly" style="width:89px;" type="text" maxlength="20" name="bank_ucet" value="' . $order['bank_ucet'] . '" /> / <input class="readonly" readonly="readonly" style="width:35px;" type="text" maxlength="4" name="bank_kod" value="' . $order['bank_kod'] . '" /></td><td>' . SPEC_SYMBOL . ':</td><td><input class="readonly right" readonly="readonly" type="text" maxlength="4" name="spec_symb" value="' . $order['spec_symb'] . '" /></td></tr>
<tr><td>' . OBJ_POZNAMKA . ':</td><td colspan="3">' . $order['poznamka'] . '</td></tr>';
$return.='</form></table>';
return($return);
}//End of function show_order
function zapomenute_heslo(){
$return='';
if ($_POST['email']):
/*Odešleme nové heslo a zobrazíme výsledek*/
$c_query='SELECT * FROM '.$_SESSION['database'].'_customers WHERE email1="'.$_POST['email'].'"';
$c_result=mysql_query($c_query,$this->link);
$c=0;
if (mysql_num_rows($c_result)==0):
return('<div id="error"><strong>'.ZAP_NOEMAIL.'</strong></div>');
endif;
while ($customer=mysql_fetch_assoc($c_result)):
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= "Content-Type: text/html; charset=utf-8\n";
$headers .= "From: ".$this->get_const('ORDER_EMAIL')."\n";
$rand1=rand(6, 10);$rand2=rand(0, 30); $rand3=rand(1,1000000); $rand_hash=sha1($rand3);
$heslo=substr($rand_hash, $rand2, $rand1);
$text=ZAP_EMAIL1.' <a href="'.$_SESSION['url'].'">'.str_replace('http://', '', $_SESSION['url']).'</a> '.ZAP_EMAIL2.'<br /><br />';
$text.=ZAP_EMAIL3.': '.$customer['id_customer'] . '<br />';
$text.=ZAP_EMAIL4.': '.$heslo;
mail($customer['email1'],$this->zakoduj_predmet(ZAP_EMAIL_HEADER),$text,$headers);
$u_query='UPDATE '.$_SESSION['database'].'_customers SET password_customer="'.sha1($heslo).'" WHERE id_customer=' . $customer['id_customer'];
$u_result=mysql_query($u_query,$this->link);
$c++;
endwhile;
$return.='<div id="error">';
if ($c>1):
$return.=ZAP_T1;
else:
$return.=ZAP_T2;
endif;
$return.='</div>';
else:
/*Zobrazíme formulář pro zapomenuté heslo*/
$return.='<h1>'.ZAP_HESLO.'</h1>
<p>'.ZAP_T3.'</p><br />
<form action="'.$this->create_href('zapomenute-heslo').'" method="post"><table><tr><td>'.ZAP_ZADEJTE_EMAIL.': </td><td><input type="text" name="email" style="width:160px;" value="" /></td><td><input type="submit" value="'.ZAP_ODESLAT.'" /></td></tr></table></form>';
endif;
return($return);
}
} // END class customer
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment