';
$btns->addButton("Invia",$frm->name.".submit()");
}elseif($adata[stage]==2){
$descr="L'utente ".$user_data[nomecogn]." e stato notificato del nuovo stato del suo ordine.";
//email to the user
$mail['message']=stripslashes($_GPV[msg]);
$mail['subject']=$_GPV[sbj];
$mail['from'] =$_CCFG[_COMPANY_NAME].' <'.$_CCFG[_EMAIL].'>';
$mail['recip'] =$user_data[email];
$_ret=do_mail_basic($mail);
}
$btns->addButton("Visualizza ordini","window.location.href='".$_CCFG['_PKG_URL_BASE']."admin/orders.php?mode=list_orders'");
$btns->addButton("Torna a amministrazione","window.location.href='".$_CCFG['_PKG_URL_BASE']."admin/'");
$code=do_block($code,"block_corner");
$_out=do_page($title,$descr,$code,"",$btns);
return $_out;
}
function do_update_order($adata){
global $_CCFG;
$order_info=get_order_info($adata[id_order]);
$sql="UPDATE ordini SET destinatario='$adata[destinatario]',indirizzo_spedizione='$adata[indirizzo_spedizione]',CAP_spedizione='$adata[CAP_spedizione]',loc_spedizione='$adata[loc_spedizione]',prov_spedizione='$adata[prov_spedizione]',status='$adata[status]',pagamento='$adata[pagamento]',note='".str_replace("'","\'",stripslashes($adata[note]))."' WHERE id=".$adata[id_order];
$res1=db_query_execute($sql);
while (list ($id_prod, $quantita) = each ($adata[quantita])){
db_query_execute("DELETE FROM ordini_lista_prodotti WHERE id_order=".$adata[id_order]." AND id_prod=".$id_prod);
db_query_execute("INSERT INTO ordini_lista_prodotti VALUES($adata[id_order],$order_info[id_user],$id_prod,$quantita)");
}
$descr="Lo stato dell'ordine con l'ID=".$adata[id_order].($res1?"":" NON")." e stato aggiornato.";
$btns=new cToolbar();
$btns->addButton("Notifica utente","window.location.href='".$_CCFG['_PKG_URL_BASE']."admin/orders.php?mode=notify_user&id=".$adata[id_order]."'");
$btns->addButton("Visualizza ordini","window.location.href='".$_CCFG['_PKG_URL_BASE']."admin/orders.php?mode=list_orders'");
$btns->addButton("Torna a amministrazione","window.location.href='".$_CCFG['_PKG_URL_BASE']."admin/'");
$code=do_block($code,"block_corner");
$_out=do_page($title,$descr,$code,"",$btns);
return $_out;
}
function do_list_orders(){
global $_CCFG,$_GPV;
$descr="In questa sessione sono elencati gli ordini effettuati dai clienti, potrai vederne i dettagli, stamparli, modificare lo stato dell'ordine e inviare notifiche al cliente.";
$btns=new cToolbar();
$btns->addButton("Torna a amministrazione","window.location.href='".$_CCFG['_PKG_URL_BASE']."admin/'");
$code.='
'.$_nl;
$code.='
Codice
Nome Cognome
Importo
Nazione
Stato
'.$_nl;
$sql="SELECT COUNT(*) FROM ordini_lista_prodotti as t1,prodotti as t2,ordini as t3,utenti as t4 WHERE t1.id_prod=t2.id AND t1.id_order=t3.id AND t3.id_user=t4.id # GROUP BY t1.id_order";
$repl=$_SESSION[_sadmin_flg]==1?"":"AND t4.id=".$_SESSION[_suser_id];
$sql=str_replace("#",$repl,$sql);
$result = db_query_execute($sql);
$numrows= db_query_numrows($result);
$pg=new cPageRes($numrows,$_CCFG[_ORDERS_PER_PAGE],5);
$page_gf="#2";
$sql="SELECT *,SUM(quantita*prezzo) as total,t3.status as order_status FROM ordini_lista_prodotti as t1,prodotti as t2,ordini as t3,utenti as t4 WHERE t1.id_prod=t2.id AND t1.id_order=t3.id AND t3.id_user=t4.id # GROUP BY t1.id_order ORDER BY t3.date DESC LIMIT ".($_GET[page]*$_CCFG[_ORDERS_PER_PAGE]).",".$_CCFG[_ORDERS_PER_PAGE];
$sql=str_replace("#",$repl,$sql);
$result = db_query_execute($sql);
while($data=mysql_fetch_array($result)){
$info=getPriceFromZone($data[total],$data[nazione]);
$code.='
'.$data[id_order].'
'.$data[nomecogn].'
'.number_format($data[total]+$info[price],2).'
'.$data[nazione].'
'.$data[order_status].'
'.$_nl;
}
$code.='
'.$_nl;
$_CCFG['_EXTRA']='
'.$pg->displayPage($_GPV[page],$page_gf).'
';
$code=do_block($code,"block_corner");
$_out=do_page($title,$descr,$code,"",$btns);
return $_out;
}
function do_view_order($adata){
global $_CCFG,$_LANG;
if($adata[op]=="delete_from_order")db_query_execute("DELETE FROM ordini_lista_prodotti WHERE id_order=".$adata[id_order]." AND id_prod=".$adata[id_prod]);
$order_info=get_order_info($adata[id_order]);
$user_data=get_user_info($order_info[id_user]);
$cond=$_CCFG['IS_PRINT'] || !$_SESSION['_sadmin_flg'];
if($user_data!=-1 && $order_info!=-1){
$descr=$_CCFG['IS_PRINT']?"":"Dettagli dell'ordine con codice ".$adata[id_order].", pervenuto da ".$user_data[nomecogn]." in data ".date("d M Y",strtotime($order_info['date'])).".";
$btns=new cToolbar();
$code.='
'.$_nl;
$code=do_block($code,"block_corner");
if($_CCFG['IS_PRINT']){
$btns->addButton("Stampa","this.parentNode.parentNode.style.display='none';window.print();this.parentNode.parentNode.style.display='inline';");
}else{
if($_SESSION[_sadmin_flg])$btns->addButton("Salva l'ordine","recalculate();frm.submit()");
$btns->addButton("Stampa","window.location.href='".$_SERVER["REQUEST_URI"]."&print=1'");
$btns->addButton("Torna a amministrazione","window.location.href='".$_CCFG['_PKG_URL_BASE'].($_SESSION[_sadmin_flg]?"admin":"utenti")."/'");
}
}else $descr="Non hai i permessi di vissualizzare questo ordine.";
$_out=do_page($title,$descr,$code,"",$btns).'
';
return $_out;
}
function do_edit_settings($adata,$astage){
global $_CCFG,$_GPV,$_POST,$title,$_nl;
if(isset($_GPV[type]))$adata[type]=$_GPV[type];
if($astage==1 || !isset($astage)){
$descr="";
if(!is_array($_CCFG[_SHIPMENT_PRICE_LIST])){
$_CCFG[_SHIPMENT_PRICE_LIST]=array("10.00,14,20,25,25,25,35","10,14,20,25,25,25,35");
}
$_SHIPMENT_PRICE_LIST=array(split(",",$_CCFG[_SHIPMENT_PRICE_LIST][0]),split(",",$_CCFG[_SHIPMENT_PRICE_LIST][1]));
$code='
Le impostazioni sotto riportate sono predefinite, e possibile apportare modifiche in base alle proprie preferenze ed in base alla tipologia dei propri articoli.
Calcola le spese di trasporto in base al paese di destinazione.
';
$code=do_block($code,"block_corner");
$btns="";
}elseif($astage==2){
$descr="Salvataggio effettuato con successo.";
db_query_execute("UPDATE params SET value='$_GPV[_SHIPMENT_FIXED_PRICE]' WHERE name='[_SHIPMENT_FIXED_PRICE]'");
db_query_execute("UPDATE params SET value='".str_replace(",",".",$_GPV[_SHIPMENT_LOWEST_PRICE_LIMIT])."' WHERE name='[_SHIPMENT_LOWEST_PRICE_LIMIT]'");
$val=array();
for($i=0;$iaddButton("Home","window.location.href='".$_CCFG['_PKG_URL_BASE']."home.php'");
$btns->addButton("Amministra","window.location.href='".$_CCFG['_PKG_URL_BASE'].($_SESSION[_sadmin_flg]?"admin":"utenti")."/'");
}
$_out=do_page($title,$descr,$code,"",$btns);
return $_out;
}
# Get security vars
$_SEC = get_security_flags();
IF ( !$_SEC['_sadmin_flg'] && !$_SEC['_suser_flg']){
# Set login flag
$_login_flag = 1;
# Call function for clients listings
$_out = ''.$_nl;
$_out .= do_login($data, 'admin', '1').$_nl;
$title="Login";
}else{
$amode = $_GPV[mode];
$astage = $_GPV[stage];
if($amode=='list_orders'){
$title="Ordini";
$_out=do_list_orders($adata,$astage);
}elseif($amode=='settings' && $_SEC['_sadmin_flg']){
$title="Impostazioni spese di transporto";
$_out=do_edit_settings($adata,$astage);
}elseif($amode=='view_order'){
$title="Dettagli ordine";
$adata=$_GPV;
$adata[id_order]=$_GPV[id];
$_out=do_view_order($adata);
}elseif($amode=='update_order' && $_SEC['_sadmin_flg']){
$title="Modifica ordine";
$adata=$_GPV;
$_out=do_update_order($adata);
}elseif($amode=='notify_user' && $_SEC['_sadmin_flg']){
$title="Notifica utente";
$adata[id_order]=$_GPV[id];
$adata[stage]=$_GPV[stage];
$_out=do_notify_user($adata);
}
}
echo do_page_content($_out,$title);
?>