<?
  /**********************
  * VERSIONE 3.0 READY
  **********************/
  include ("../common/public.php") ;
	
	$where_ag  = "and 1" ;
	$where_cl  = "and 1" ;
	$where_fo  = "and 1" ;
	$where_pro = "and 1" ;
	
	if ($agente != '' and $agente != 'tutti')
		$where_ag = " and O.idagente = $agente" ;
	
	if ($cliente != '' and $cliente != 'tutti')
		$where_cl = " and O.idcliente = $cliente" ;

	if ($fornitore != '' and $fornitore != 'tutti')
		$where_fo = " and O.idfornitore = $fornitore" ;
		
	if ($prodotto != '')
		$where_pro = " and P.nome like '%$prodotto%'" ;

  if ($profilo == 3)
  {
    $where_ag .= " and O.idagente != 4 and O.idagente != 5 and O.idagente != 9 and O.idagente != 10" ;
    $wagente = " O.idagente != 4 and O.idagente != 5 and O.idagente != 9 and O.idagente != 10" ;
  }
  else
  {
    $where_ag .= " and 1=1" ;
    $wagente = " 1=1" ;
  } 
	
	/********************************************************************************
	* Fab 6.10.2011: mi calcolo il totale dei clienti che hanno movimentato un certo
	* fornitore (o un certo articolo di un fornitore)
	*********************************************************************************/
	$qnumClienti = "
				select distinct 
						count(*) as NumeroOrdiniSingoloCliente,
						C.Nome
				from
						ordini O
							inner join clienti C on O.idcliente = C.idclienti
							inner join dettagli D on D.idordine = O.idordini
								inner join prodotti P on P.idprodotti = D.idprodotto and
                                         P.Anno = $anno
				where
            O.Anno = $anno 
						$where_pro
						$where_ag
						$where_cl
						$where_fo
				group by C.Nome
	               " ;
	list ($nNumCli, $arrNumCli) = $db->RecuperaDati($qnumClienti) ;
	$totClienti = count($arrNumCli['Nome']) ;

	/*********************************************************************************
	* per il calcolo del totale dei prodotti venduti e dei prodotti in sconto merce
	*********************************************************************************/

  $qtot = " 
				select 
						sum(TT.TotDettV) as TotBottV,
						sum(TT.TotDettSM) as TotBottSM
				from
						(select 
							sum(D.NumCartoni * D.ConfezioniDa) as TotDettV,
							0                                  as TotDettSM
						from 
							dettagli D
							  inner join ordini O on O.idordini = D.idordine
																	and O.idfornitore != $idsarzi
                                  and O.Anno = $anno
								inner join prodotti P on P.idprodotti = D.idprodotto
																				 $where_pro
																				 $where_ag
																				 $where_cl
																				 $where_fo
            where
              P.Anno = $anno and 
              D.Anno = $anno

						union 

						select
							0                                  as TotDettV,
							sum(D.NumCartoni * D.ConfezioniDa) as TotDettSM
						from 
							scontomerce D
								inner join ordini O on O.idordini = D.idordine
																	 and O.idfornitore != $idsarzi
                                   and O.Anno = $anno
								inner join prodotti P on P.idprodotti = D.idprodotto
																				 $where_pro
																				 $where_ag
																				 $where_cl
																				 $where_fo
            where
              P.Anno = $anno and 
              D.Anno = $anno
						) as TT
					" ;

	debug (0, $qtot) ;
	list ($nt, $d) = $db->RecuperaDati($qtot) ;

	$TotBottV  = nfl($d['TotBottV'][0]) ;
	$TotBottSM = nfl($d['TotBottSM'][0]) ;
	$TotBottGen = nfl($d['TotBottV'][0] + $d['TotBottSM'][0]) ;

  if (($d['TotBottV'][0] + $d['TotBottSM'][0]) > 0)
	  $TotPercSM  = nfp($d['TotBottSM'][0] / ($d['TotBottV'][0] + $d['TotBottSM'][0]) * 100) ;
  else
	  $TotPercSM  = nfp(0) ;
    
	$arrAgenti    = array() ;
	$arrClienti   = array() ;
	$arrFornitori = array() ;
	
	$qf = "
			select distinct
					A.idagenti    as IdAgente,
					A.nome        as NomeAgente,
					C.idclienti   as IdCliente,
					C.nome        as NomeCliente,
					F.idfornitori as IdFornitore,
					F.nome        as NomeFornitore
			from
					agenti A
					  inner join ordini O on O.idagente = A.idagenti and
                                   O.Anno = $anno
						inner join clienti C on C.idclienti = O.idcliente
						inner join fornitori F on F.idfornitori = O.idfornitore
      where
        $wagente
			order by
					A.nome	      
				" ;
  debug (0, "PUNTO = $qf") ;
	list($n, $d) = $db->RecuperaDati($qf) ;
	for ($i=0; $i<$n; $i++)
	{
		if (!@array_key_exists($d['IdAgente'][$i], $arrAgenti))
			$arrAgenti[$d['IdAgente'][$i]] = $d["NomeAgente"][$i] ;
		
		if (!@array_key_exists($d['IdCliente'][$i], $arrClienti))
			$arrClienti[$d['IdCliente'][$i]] = $d["NomeCliente"][$i] ;
		
		if (!@array_key_exists($d['IdFornitore'][$i], $arrFornitori))
			$arrFornitori[$d['IdFornitore'][$i]] = $d["NomeFornitore"][$i] ;
	}

  @asort($arrAgenti) ;
  @asort($arrClienti) ;
  @asort($arrFornitori) ;

	$header  = "AGENTE,CLIENTE,FORNITORE,PRODOTTO,Totale,Venduto,Sconto Merce,% SM" ;
  
  $label = explode(",", $header) ;

  $attHeaderStyle = "background-color:#ffffaa;border-bottom:1px solid silver;padding:2px 2px 0px 2px" ;

  $attH = "<div id='agente_flt'></div>,<div id='cliente_flt'></div>,<div id='fornitore_flt'></div>,<div id='prodotto_flt'></div>,&nbsp;,&nbsp;,&nbsp;,&nbsp;" ;
  
  $attHS  = "$attHeaderStyle,$attHeaderStyle,$attHeaderStyle,$attHeaderStyle,$attHeaderStyle,$attHeaderStyle,$attHeaderStyle,$attHeaderStyle" ;
  
 	$footer      = "TOTALI PARZIALI:-#cspan-#cspan-#cspan-<div id=generale></div>-<div id=totbottv></div>-<div id=totbottsm></div>-<div id=totpercsm></div>" ;

	$strSort = "str,,str,str,str,int,int,int,int" ;
  $iniWP    = "10,20,20,22,8,6,9,5" ;
  $setColType = "ro,ro,ro,ro,ro,ro,ro,ro" ;
  $setColAlign = "left,left,left,left,center,center,center,center" ;

	/*******************************************************************************
	* controllo se devo eseguire degli ordinamenti e qual è la colonna da ordinare
	*******************************************************************************/
	if (! isset($colToSort) or $colToSort == '')
		$colToSort = 1 ;
	
	if (! isset($direction) or $direction == '')
		$direction = "ASC" ;
	
	$strLoadXml = "LoadListaClientiProdotti.php?ordinaper=$colToSort&direction=$direction" ;

	/******************************************************************
	* controllo se provengo da una operazione di filtraggio. Questo si
	* verifica quando rag_sociale vale qualcosa
	******************************************************************/	
	if ($agente != '')
		$strLoadXml .= "&selage=$agente" ;
	
	if ($cliente != '')
		$strLoadXml .= "&selcli=$cliente" ;
	
	if ($fornitore != '')
		$strLoadXml .= "&selfor=$fornitore" ;
	
	if ($prodotto != '')
		$strLoadXml .= "&selpro=$prodotto" ;

  debug (0, $strLoadXml) ;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>
<link rel="stylesheet" href="../common/mystyle.css" type="text/css">
<link rel="stylesheet" type="text/css" href="../common/stili.css">
<link rel="stylesheet" type="text/css" href="../common/stilisv.css">
<link rel="stylesheet" type="text/css" href="../common/need_in_Grid.css">

<script language="JavaScript" src="../common/func_javascript.js"></script>
<script  src="../js/dhtmlXCommon.js"></script>
<script  src="../js/dhtmlXGrid.js"></script>
<script  src="../js/dhtmlXGrid_srnd.js"></script>
<script  src="../js/dhtmlXGridCell.js"></script>
<SCRIPT LANGUAGE="JavaScript">
<!--
// parent.sei_in.innerHTML = "Sei in: RICERCHE >> Lista Clienti / Prodotti Acquistati" ;
parent.sei_in_anno.innerHTML = "Anno " + <? echo $GLOBALS["anno"] ?> ;

var str = "<rows></rows>" ;
var mygrid ;
var codicecomposto = '0' ;

var lastColSorted = <? echo $colToSort ?> ;
var vis_msg = true ;

var ordina = 1 ;
var old_id_riga_in  = 0 ;

window.s_col = <? echo $colToSort ?> ;
window.a_direction = "<? echo $direction ?>" ;

function doOnLoad()
{
  mygrid = new dhtmlXGridObject('gridbox');
  mygrid.setImagePath("../imgs/");

  mygrid.setHeader("<? echo $header ?>") ;
  mygrid.attachHeader("<? echo $attH ?>", "<? echo $attHS?>");
  mygrid.setInitWidthsP("<? echo $iniWP ?>") ;
  mygrid.setColTypes("<? echo $setColType ?>") ;
  mygrid.setColAlign("<? echo $setColAlign ?>") ;

	mygrid.setDelimiter("-") ;
  mygrid.attachFooter("<? echo $footer ?>") ;

	mygrid.SetPersonalColSorting = true ;       // Added By Fab
  
  if (mygrid.setOnColumnSort)
		mygrid.setOnColumnSort(customColumnSort) ;

  mygrid.setOnRowSelectHandler(doOnRowSelected) ;

  mygrid.init();
  
  mygrid.enableSmartRendering(true);
    
  try{
    mygrid.setOnLoadingEnd(setCounter)
  }
	catch(e){
  }
	
	document.getElementById("agente_flt").appendChild(document.getElementById("agente_flt_box").childNodes[0]) ;
  document.getElementById("cliente_flt").appendChild(document.getElementById("cliente_flt_box").childNodes[0]) ;
  document.getElementById("fornitore_flt").appendChild(document.getElementById("fornitore_flt_box").childNodes[0]) ;
  document.getElementById("prodotto_flt").appendChild(document.getElementById("prodotto_flt_box").childNodes[0]) ;

	mygrid.loadXML("<? echo $strLoadXml ?>") ;

	showLoading() ;
	
<? if ($agente != '' and $agente != 'tutti') : ?>
  document.getElementById('SelAge').value = "<? echo $agente ?>" ;
	changeFontColor('agente_flt', 0, 'AGENTE', 'color_grey') ;
<? endif ?>

<? if ($cliente != '' and $cliente != 'tutti') : ?>
  document.getElementById('SelCli').value = "<? echo $cliente ?>" ;
	changeFontColor('cliente_flt', 1, 'CLIENTE', 'color_grey') ;
<? endif ?>

<? if ($fornitore != '' and $fornitore != 'tutti') : ?>
  document.getElementById('SelFor').value = "<? echo $fornitore ?>" ;
	changeFontColor('fornitore_flt', 2, 'FORNITORE', 'color_grey') ;
<? endif ?>

<? if ($prodotto != '' and $prodotto != 'tutti') : ?>
  document.getElementById('SelPro').value = "<? echo $prodotto ?>" ;
	changeFontColor('prodotto_flt', 3, 'PRODOTTO', 'color_grey') ;
<? endif ?>

	mygrid.setSortImgState(true,window.s_col,window.a_direction); 

	return ;

}

function doOnRowSelected(id)
{
  codicecomposto = id ;
	// alert (codicecomposto) ;
  return ;
}

function customColumnSort(ind)
{
	if (ordina == 0)
	{
		ordina = 1 ;
		return false ;
	}

	var a_state = mygrid.getSortingState();
  window.s_col=ind;

	if (lastColSorted != ind)
  {
    lastColSorted = ind ;
    a_state[1] = 'ASC' ;
  }
  
  if (a_state[1] == "ASC")
  {
    window.a_direction = "ASC" ;
    mygrid.setSortImgState(false,window.s_col,window.a_direction);
  }
  else if (a_state[1] == "DES")
	{
    window.a_direction = "DESC" ;
  }
	else
	{
		window.a_direction = "ASC" ;
	}

  reloadGrid();
  return true;
}

/**********************************************
* Parametri
*   idCol    = id del tag della colonna
*   iCol     = id colonna
*   labCol   = label colonna
*   classCol = class da aggiungere
***********************************************/
function changeFontColor(idCol, iCol, labCol, classCol)
{
  var sel = document.getElementById(idCol).childNodes[0] ;
  if (sel.type == "select-one")
  {
    if (sel.options[sel.options.selectedIndex].text == 'All')
      mygrid.addHeaderClass(iCol, labCol, '') ;
    else
      mygrid.addHeaderClass(iCol, labCol, classCol) ;
  }
  else if (sel.type == "text")
  {
    if (sel.value == '')
      mygrid.addHeaderClass(iCol, labCol, '') ;    
    else
      mygrid.addHeaderClass(iCol, labCol, classCol) ;
  }
}

function reloadGrid()
{
	var f             = document.forms.reload_grid ;
	f.cliente.value   = document.getElementById("SelCli").value ;
	f.agente.value    = document.getElementById("SelAge").value ;
	f.fornitore.value = document.getElementById("SelFor").value ;
	f.prodotto.value  = document.getElementById("SelPro").value ;
	
	f.colToSort.value = window.s_col ;
	f.direction.value = window.a_direction ;
	
	f.submit() ;
	return true ;  
}

function AzzeraFiltri()
{
	document.getElementById("SelAge").value = 'tutti' ;
	document.getElementById("SelCli").value = 'tutti' ;
  document.getElementById("SelFor").value = 'tutti' ;
	document.getElementById("SelPro").value = '' ;
  
	changeFontColor('agente_flt', 0, 'AGENTE', 'white') ;
	changeFontColor('cliente_flt', 1, 'CLIENTE', 'white') ;
	changeFontColor('fornitore_flt', 2, 'FORNITORE', 'white') ;
	changeFontColor('prodotto_flt', 3, 'PRODOTTO', 'white') ;

	window.s_col = 0 ;
	window.a_direction = "ASC" ;
  reloadGrid();
}

function setCounter()
{
	var tot = 0 ;
  var span         = document.getElementById("totbottv")
  span.style.color = "";
	span.innerHTML = '<? echo $TotBottV ?>' ;
  
	var span1         = document.getElementById("totbottsm")
  span1.style.color = "";
	span1.innerHTML = '<? echo $TotBottSM ?>' ;

	var span2         = document.getElementById("generale")
  span2.style.color = "";
	span2.innerHTML = '<? echo $TotBottGen ?>' ;
	
	var span3         = document.getElementById("totpercsm")
  span3.style.color = "";
	span3.innerHTML = '<? echo $TotPercSM ?>' ;

	return ;	
}

function showLoading()
{
  var span = document.getElementById("totbottv")
  span.style.color = "";
  span.innerHTML = "loading...";
	
	var span1         = document.getElementById("totbottsm")
  span1.style.color = "";
	span1.innerHTML = 'loading...' ;
	
	var span2         = document.getElementById("generale")
  span2.style.color = "";
	span2.innerHTML = 'loading...' ;

}

function Dettagli()
{
	var f = document.forms.dettagli ;
	if (codicecomposto == 0)
	{
		alert ('Nessuna riga selezionata') ;
		return false ;
	}
	f.cliente_back.value   = document.getElementById("SelCli").value ;
	f.agente_back.value    = document.getElementById("SelAge").value ;
	f.fornitore_back.value = document.getElementById("SelFor").value ;
	f.prodotto_back.value  = document.getElementById("SelPro").value ;
	
	f.colToSort_back.value = window.s_col ;
	f.direction_back.value = window.a_direction ;
	
	f.codicecomposto.value = codicecomposto ;
	f.submit() ;
	return ;
}

function Stampa() 
{
	var f = document.forms.stampa ;
	
	f.cliente.value   = document.getElementById("SelCli").value ;
	f.agente.value    = document.getElementById("SelAge").value ;
	f.fornitore.value = document.getElementById("SelFor").value ;
	f.prodotto.value  = document.getElementById("SelPro").value ;
	
	f.colToSort.value = window.s_col ;
	f.direction.value = window.a_direction ;
	f.submit() ;
	return ;
}

function StampaPDF() 
{
	var f = document.forms.stampaPDF ;
	var agente    = document.getElementById("SelAge").value ;
	var cliente   = document.getElementById("SelCli").value ;
  var fornitore = document.getElementById("SelFor").value ;

	f.cliente.value   = document.getElementById("SelCli").value ;
	f.agente.value    = document.getElementById("SelAge").value ;
	f.fornitore.value = document.getElementById("SelFor").value ;
	f.prodotto.value  = document.getElementById("SelPro").value ;
	
	if ((agente == 'tutti' ) || (cliente == 'tutti') || (fornitore == 'tutti'))
  {
    alert ('Per questa operazione devi selezionare un agente, un cliente e un fornitore') ;
    return false
  }
  // return ;
  f.cliente.value   = document.getElementById("SelCli").value ;
	f.agente.value    = document.getElementById("SelAge").value ;
	f.fornitore.value = document.getElementById("SelFor").value ;
	f.prodotto.value  = document.getElementById("SelPro").value ;

  f.colToSort.value = window.s_col ;
	f.direction.value = window.a_direction ;
	f.submit() ;
	return ;
}
//-->
</SCRIPT>

<? if ($nt == 0) : ?>

<body  topmargin="0" vlink="#336633" marginheight="0" bgcolor="#ffffaa" leftmargin="0" link="#006600" marginwidth="0"> 
<span class="boxdati_need"><BR><BR> Nessun elemento presente </span>

<? else : ?>

<body  topmargin="0" vlink="#336633" marginheight="0" bgcolor="#ffffaa" leftmargin="0" link="#006600" marginwidth="0" onload="doOnLoad(); CalcolaAltezzaDiv('gridbox')">
 
<!--************************** bottoni azione ***************************************-->
<div id="actions">
  <input type="button" class="input" onclick="Dettagli()"     value="Dettagli">
	<input type="button" class="input" onclick="reloadGrid()"   value="Applica Filtri">
	<input type="button" class="input" onclick="AzzeraFiltri()" value="Azzera Filtri">
	<input type="button" class="input" onclick="Stampa()" value="Stampa">
	<input type="button" class="input" onclick="StampaPDF()" value="Stampa PDF">
</div>

<div class="par_space">
  <span class="lbl8l dx_spaz">
  Totale Clienti = <span class="par_val"><? echo $totClienti ?></span>;
  <span class="lbl8l">(<I>Per selezionare un ordine clicca sulla riga corrispondente</I>)</span>
</div>

<!--**********************************************************
  * L I S T A  
  ***********************************************************-->
 <div id="gridbox"></div>
 
 <div style="display:none">

  <!-- AGENTE -->
  <div id="agente_flt_box"><select id="SelAge" class="input" style="width:100%" onclick="(arguments[0]||window.event).cancelBubble=true;">
      <option value="tutti">Tutti
<?                  
  foreach($arrAgenti as $id => $tt) {
?>
        <option value='<? echo $id ?>' <? echo $sel ?> ><? echo $tt ?></option>
<? } ?>
    </select>
	</div>

  <!-- CLIENTE -->
  <div id="cliente_flt_box"><select id="SelCli" class="input" style="width:100%" onclick="(arguments[0]||window.event).cancelBubble=true;">
      <option value="tutti">Tutti
<?                  
  foreach($arrClienti as $id => $tt) {
?>
        <option value='<? echo $id ?>' <? echo $sel ?> ><? echo $tt ?></option>
<? } ?>
    </select>
	</div>
  
  
  <!-- FORNITORE -->
  <div id="fornitore_flt_box"><select id="SelFor" class="input" style="width:100%" onclick="(arguments[0]||window.event).cancelBubble=true;">
      <option value="tutti">Tutti
<?                  
  foreach($arrFornitori as $id => $tt) {
?>
        <option value='<? echo $id ?>' <? echo $sel ?> ><? echo $tt ?></option>
<? } ?>
    </select>
	</div>

  <!-- PRODOTTO -->
  <div id="prodotto_flt_box"><input id="SelPro" size="40" class="input back_white" style="border:1px solid gray;" onclick="(arguments[0]||window.event).cancelBubble=true;" value="">
	</div>
 
 </div>

 <form name="reload_grid" method="post" action="./lista_clienti_bott_acquistate.php" style="display: none;">
	<INPUT TYPE="hidden" NAME="agente"    value="">
	<INPUT TYPE="hidden" NAME="cliente"   value="">
	<INPUT TYPE="hidden" NAME="fornitore" value="">
	<INPUT TYPE="hidden" NAME="prodotto"  value="">
	
	<INPUT TYPE="hidden" NAME="colToSort" value="">
	<INPUT TYPE="hidden" NAME="direction" value="">
</form>

<FORM METHOD=POST ACTION="./visricerche_clienti_bott_acquistate.php" name="dettagli">
	<INPUT TYPE="hidden" NAME="codicecomposto" value="">

	<INPUT TYPE="hidden" NAME="agente_back"    value="">
	<INPUT TYPE="hidden" NAME="cliente_back"   value="">
	<INPUT TYPE="hidden" NAME="fornitore_back" value="">
	<INPUT TYPE="hidden" NAME="prodotto_back"  value="">
	
	<INPUT TYPE="hidden" NAME="colToSort_back" value="">
	<INPUT TYPE="hidden" NAME="direction_back" value="">
</FORM>

<FORM METHOD=POST name="stampa" ACTION="./StampaListaClientiProdottiAcquistati.php"  target="_blank">
	<INPUT TYPE="hidden" NAME="agente"    value="">
	<INPUT TYPE="hidden" NAME="cliente"   value="">
	<INPUT TYPE="hidden" NAME="fornitore" value="">
	<INPUT TYPE="hidden" NAME="prodotto"  value="">
	
	<INPUT TYPE="hidden" NAME="colToSort" value="">
	<INPUT TYPE="hidden" NAME="direction" value="">
</FORM>

<FORM METHOD=POST name="stampaPDF" ACTION="./StampaListaClientiProdottiAcquistatiPDF.php"  target="_blank">
	<INPUT TYPE="hidden" NAME="agente"    value="">
	<INPUT TYPE="hidden" NAME="cliente"   value="">
	<INPUT TYPE="hidden" NAME="fornitore" value="">
	<INPUT TYPE="hidden" NAME="prodotto"  value="">
	
	<INPUT TYPE="hidden" NAME="colToSort" value="">
	<INPUT TYPE="hidden" NAME="direction" value="">
</FORM>

<? endif ?>

</BODY>
</HTML>