<? 
/**
* LetterBox Class
*
* Contains all the specific functions of Maarch LetterBox
*
* @package Maarch LetterBox 2.3
* @version 2.0
* @since 06/2007
* @license GPL
* @author  Claire Figueras  <dev@maarch.org>
* 
*/

/**
* Class LetterBox : Contains all the specific functions of Maarch LetterBox
*
* @author  Claire Figueras  <dev@maarch.org>
* @license GPL
* @package Maarch LetterBox 2.3
* @version 2.0
*/

class LetterBox extends dbquery
{
	/**
	*
    * @access private
    * @var integer
    */
	private $the_start;

	/**
	* Redefinition of the LetterBox object constructor
	*/
	function __construct()
	{
		// configure the sql argument order by
		if(isset($_GET['start']))
		{
			$this->the_start = strip_tags($_GET['start']);
		}
		else
		{
			$this->the_start = 0;
		}
	}
	
	/**
	* Configure the sql argument order by
	*
	*/
	public function define_order()
	{
		// configure the sql argument order by
		$orderby = "";
		
		if(isset($_GET['order']))
		{
		
			if($_GET['order'] == "arrivdesc")
			{
				$orderby = "order by CREATION_DATE desc";
			}
			elseif($_GET['order'] == "arrivasc")
			{
				$orderby = "order by CREATION_DATE asc";
			}
			if($_GET['order'] == "datedesc")
			{
				$orderby = "order by CREATION_DATE desc";
			}
			elseif($_GET['order'] == "dateasc")
			{
				$orderby = "order by CREATION_DATE asc";
			}
			if($_GET['order'] == "typedesc")
			{
				$orderby = "order by TYPE_ID desc";
			}
			elseif($_GET['order'] == "typeasc")
			{
				$orderby = "order by TYPE_ID asc";
			}
			if($_GET['order'] == "limdesc")
			{
				$orderby = "order by CUSTOM_D2 desc";
			}
			elseif($_GET['order'] == "limasc")
			{
				$orderby = "order by CUSTOM_D2 asc";
			}
			if($_GET['order'] == "expdesc")
			{
				$orderby = "order by AUTHOR desc";
			}
			elseif($_GET['order'] == "expasc")
			{
				$orderby = "order by AUTHOR asc";
			}
			if($_GET['order'] == "statusdesc")
			{
				$orderby = "order by AUTHOR desc";
			}
			elseif($_GET['order'] == "statusasc")
			{
				$orderby = "order by AUTHOR asc";
			}
			if($_GET['order'] == "residdesc")
			{
				$orderby = "order by RES_ID desc";
			}
			elseif($_GET['order'] == "residasc")
			{
				$orderby = "order by RES_ID asc";
			}
			if($_GET['order'] == "objdesc")
			{
				$orderby = "order by DESCRIPTION desc";
			}
			elseif($_GET['order'] == "objasc")
			{
				$orderby = "order by DESCRIPTION asc";
			}
			if($_GET['order'] == "destdesc")
			{
				$orderby = "order by DEST_USER desc";
			}
			elseif($_GET['order'] == "destasc")
			{
				$orderby = "order by DEST_USER asc";
			}
			if($_GET['order'] == "limdesc")
			{
				$orderby = "order by CUSTOM_D2 desc";
			}
			elseif($_GET['order'] == "limasc")
			{
				$orderby = "order by CUSTOM_D2 asc";
			}
			if($_GET['order'] == "priodesc")
			{
				$orderby = "order by PRIORITY desc";
			}
			elseif($_GET['order'] == "prioasc")
			{
				$orderby = "order by PRIORITY asc";
			}
			if($_GET['order'] == "servdesc")
			{
				$orderby = "order by DESTINATION desc";
			}
			elseif($_GET['order'] == "servasc")
			{
				$orderby = "order by DESTINATION asc";
			}
				if($_GET['order'] == "socidesc")
			{
				$orderby = "order by SOCIETE desc";
			}
			elseif($_GET['order'] == "sociasc")
			{
				$orderby = "order by SOCIETE asc";
			}
			
			
		}
		return $orderby;
	}
	
	/**
	* Show the list of mail to validate
	*
	* @param array $listarr array which contains all the data to show
	* @param int $nb_total number of element to show
	* @param string $title list title
	* @param string $name page name
	*/
	public function validate_list($listarr, $nb_total, $title, $name)
	{
		
		$_SESSION['diff'] = array();
		//$_SESSION['resultat'] = "";
		$_SESSION['error'] = '';
		// show the document list in result of the search
		$page_list1 = "";
		$page_list2 = "";

		//require_once("class_functions.php");
		$func = new functions();
		
		if(isset($_REQUEST['start']))
		{
			$start = strip_tags($_REQUEST['start']);
		}
		else
		{
			$start = 0;
		}
		
		if(isset($_GET['order']))
		{
			$orderby = strip_tags($_GET['order']);
		}
		else
		{
			$orderby = 0;
		}
		
		
			$link = "index.php?page=".$name;
			
		
		// define the defaults values
		$nb_show = $_SESSION['config']['nblinetoshow'];
		$nb_pages = ceil($nb_total/$nb_show);
		
		// if they are more than 1 page we do pagination with 2 forms
			if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form action="" name="newpage1" id="newpage1" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage1.startpage.value;">';
		
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($start == $next_start)
				{	
					$page_list1 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
						}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($start > 0)
			{
				$start_prev = $start - $nb_show;
				$previous = "< <a href=\"".$link."&amp;start=".$start_prev."&amp;order=".$orderby."\">"._PREVIOUS."</a> ";
			}
			
			if($start <> $lastpage)
			{
				$start_next = $start + $nb_show;
				$next = " <a href=\"".$link."&amp;start=".$start_next."&amp;order=".$orderby."\">"._NEXT."</a> >";
			}
			
			$page_list1 = $page_list1."</select>".$previous." ".$next."</p></form>";
			
		}
		?>
		
		<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_trait_b.gif"  align="middle" alt="" /><?php echo $title; ?></h1>
        <div id="inner_content" class="clearfix">
					<?php echo $page_list1;?>
				<form name="choose_mail" id="choose_mail" method="post" action="manage_redirection.php">
                  <input type="hidden" name="start" id="start" value="<? echo $start;?>" />
			<table cellpadding="0" cellspacing="0" border="0" class="listing">
				<thead>
					<tr>
                      <? if(!$_SESSION['current_basket']['no_action']){ ?><th>&nbsp;</th><? }?>
						<th class="date" >
							<? echo _RECEIPT_DATE;?><br/>
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivdesc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/>										</a> 
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivasc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/>										</a>
						</th>
						<th class="price">
							<? echo _GED_NUM;?><br/>
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residdesc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" border="0" />										</a> 
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residasc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" border="0" />										</a>
						</th>
						<th class="type2" >
							<? echo _DEPARTMENT;?><br/>
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=destdesc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" border="0" />										</a> 
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=destasc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" border="0" />										</a>
						</th>
						<th class="emetteur" >
							<?
							if($_SESSION['config']['corporate'] == "true")
							{
							echo _SOCIETY;?><br/>
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=socidesc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" border="0" />										</a> 
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=sociasc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" border="0" />										</a>
                            
                           <? }
						   else
						   {
						   echo _OBJECT;?><br/>
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objdesc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" border="0" />										</a> 
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objasc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" border="0" />										</a>
                            <? } ?>
						</th>
						<th>
							<? echo _SHIPPER;?><br/>
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expdesc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" border="0" />										</a> 
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expasc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" border="0" />										</a>
						</th>
						<th class="date">
							<? echo _LIMIT_DATE_PROCESS;?><br/>
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=limdesc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" border="0" />										</a> 
							<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=limasc">
							<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" border="0" />										</a>
						</th>
					</tr>
				</thead>
			<tbody>
		<?php		
			$color = "";
		
		for($theline = 0; $theline < count($listarr) ; $theline++)
		{
			// background color
			if($color == ' class="col"')
			{
				$color = '';
			}
			else
			{
				$color = ' class="col"';
			}
			?>
		<tr<?php echo $color; ?> >
        	 <? if(!$_SESSION['current_basket']['no_action']){ ?><td><input type="checkbox" name="mail[]" value="<?php echo $listarr[$theline]['ID']; ?>" /></td><? } ?>
			  <td class="date" onMouseOver="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('validation.php?id=<? echo $listarr[$theline]['ID']; ?>','Validation', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><?php if($listarr[$theline]['STATUS'] == "OUT")
					 {
						 echo $this->dateformat($listarr[$theline]['CREATION_DATE']);
					 }
					 else
					 {
						
					 	if("0000-00-00" == $listarr[$theline]['ARRIVEE'] || "00-00-0000" == $listarr[$theline]['ARRIVEE'])
						{
							echo $this->dateformat($listarr[$theline]['CREATION_DATE']);
						}
						else
						{
					 		echo $this->dateformat($listarr[$theline]['ARRIVEE']);
						}
					}  ?></td>
				<td class="price" onMouseOver="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('validation.php?id=<? echo $listarr[$theline]['ID']; ?>','Validation', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><? echo $listarr[$theline]['ID']; ?></td>
				
				<td class="type2"onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('validation.php?id=<? echo $listarr[$theline]['ID']; ?>','Validation', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><? 
				$this->query("select SERVICE from ".$_SESSION['tablename']['services']." where ID = '".$listarr[$theline]['SERVICE_ID']."'");
				$res3 = $this->fetch_object();
				echo str_replace('\\', '',$res3->SERVICE); ?></td>
				<td class="emetteur" onMouseOver="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('validation.php?id=<? echo $listarr[$theline]['ID']; ?>','Validation', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><?
				if($_SESSION['config']['corporate'] == "true")
				{
				 echo $listarr[$theline]['SOCIETE']; 
				 }
				 else
				 {
				 	echo $listarr[$theline]['OBJET'];
				 }
				 ?></td>
				<td ><? echo $listarr[$theline]['SHIPPER']; ?></td>
			    <td class="date" onMouseOver="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('validation.php?id=<? echo $listarr[$theline]['ID']; ?>','Validation', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><? echo $listarr[$theline]['LIMITE']; ?></td>
		     </tr>
		   
	
		<?php
			}
			
			?> 
		</tbody>
		  </table>
          
			<p><em><? echo _CLICK_LINE_VALID;?></em> </p>
              <br/>
          <? if(!$_SESSION['current_basket']['no_action'])
		  {
		  ?>
          <div>
          	<p>
            	<label><? echo _CHOOSE_ACTION;?> : </label>
                
                <select name="action" id="action">
  
                <? if($_SESSION['current_basket']['can_redirect'] == 'Y' )
				{
					?>
                    <option value="RED"><? echo _REDIRECTION;?></option>
                    <?
				}
				if($_SESSION['current_basket']['can_delete'] == true)
				{
				?>
                <option value="DEL"><? echo _DELETION;?></option>
                <?
				}
				?>
                </select>
                <input type="submit" name="valid" id="valid" value="<? echo _VALIDATE;?>" class="button" />
            </p>
          </div>
          <? } ?>
          </form>
				</div>
			 <?
	}
	
	/**
	* Build the alphabetic list of departments letters
	*
	* @param string $page page name
	*/
	public function servicelistletters($page = "liste")
	{
		// List all the alphabet letter to view the doc types who are starting with the letter
		if(isset($_GET['show']))
		{
			if($_GET['show'] == "false")
			{
				$show = "&amp;show=false";
			}
			else
			{
				$show = "";
			}
		}
		else
		{
			$show = "";
		}
		?>
		<form action="index.php" method="get" name="frmletters" id="frmletters">
			<fieldset>
				<p>
					<input name="what" type="text" class="textbox medium" value="" />
					<input name="Submit" type="submit" value="<?php echo _SEARCH; ?>" class="button" />
					<input name="page" type="hidden" value="<?php echo $page; ?>" />
					<?php if($show == "&amp;show=false") { ?><input name="show" type="hidden" value="false" /><? } ?>
				</p>
			</fieldset>
				<p><strong><?php echo _ALPHABETICAL_LIST; ?></strong> : 
		
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=A">A</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=B">B</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=C">C</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=D">D</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=E">E</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=F">F</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=G">G</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=H">H</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=I">I</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=J">J</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=K">K</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=L">L</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=M">M</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=N">N</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=O">O</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=P">P</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Q">Q</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=R">R</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=S">S</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=T">T</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=U">U</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=V">V</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=W">W</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=X">X</a>
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Y">Y</a>
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Z">Z</a>
				- <a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>"><? echo _ALL_DEPARTMENTS;?></a>
			
			</p>
	
				</form>

		<?php
	}
	
	/**
	* Build the alphabetic list of departments letters
	*
	* @param string $page page name
	*/
	public function emetlistletters($page = "emet")
	{
		// List all the alphabet letter to view the doc types who are starting with the letter
		if(isset($_GET['show']))
		{
			if($_GET['show'] == "false")
			{
				$show = "&amp;show=false";
			}
			else
			{
				$show = "";
			}
		}
		else
		{
			$show = "";
		}
		?>
		<form action="index.php" method="get" name="frmletters" id="frmletters">
			<fieldset>
				<p>
					<input name="what" type="text" class="textbox medium" value="" />
					<input name="Submit" type="submit" value="<?php echo _SEARCH; ?>" class="button" />
					<input name="page" type="hidden" value="<?php echo $page; ?>" />
					<?php if($show == "&amp;show=false") { ?><input name="show" type="hidden" value="false" /><? } ?>
				</p>
			</fieldset>
				<p><strong><?php echo _ALPHABETICAL_LIST; ?></strong> : 
		
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=A">A</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=B">B</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=C">C</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=D">D</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=E">E</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=F">F</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=G">G</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=H">H</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=I">I</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=J">J</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=K">K</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=L">L</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=M">M</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=N">N</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=O">O</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=P">P</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Q">Q</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=R">R</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=S">S</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=T">T</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=U">U</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=V">V</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=W">W</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=X">X</a>
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Y">Y</a>
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Z">Z</a>
				- <a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>"><? echo _ALL_SHIPPERS;?></a>
			
			</p>
	
				</form>

		<?php
	}
	
	/**
	* Draw the departments list
	*
	* @param 	string  $where sorting of the list (empty by default)
	* @param 	string  $what  first letter of the name (empty by default)
	*/
	public function serviceslist($where = "",$what = "")
	{
		// draw the services list
		$func = new functions();
		
		/* Configuration */
		$title = _DEPARTMENTS_LIST;
		$page_name = "liste";
		$table_name = $_SESSION['tablename']['services'];
		$res_table = "res_x";
		$nb_show = $_SESSION['config']['nblinetoshow'];
		
		
		if(!empty($what))
		{
			$what = "&what=".$what;
		}
		/***********************/
		
		$this->connect();
		$this->query("select count(*) as total from ".$table_name." where ENABLED = 'Y' ".$where);
		$nb_total_1 = $this->fetch_object();
		$nb_total = $nb_total_1->total;
		
		// define the defaults values
		$nb_pages = ceil($nb_total/$nb_show);
		
		$link = "index.php?page=".$page_name."&start=".$this->the_start."&order=".$this->orderby.$what;
		
		if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form name="newpage1" id="newpage1" method="get" action="index.php?page=groups" >
			<p>
				<label for="startpage">'._GO_TO_PAGE.'</label>
				<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;start=\'+document.newpage1.startpage.value;">';
			
			$page_list2 = '<form name="newpage2" id="newpage2" method="get" action="index.php?page=groups"  >
			<p>
				<label for="startpage">'._GO_TO_PAGE.'</label>
				<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;start=\'+document.newpage2.startpage.value;">';
			
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($this->the_start == $next_start)
				{
					$page_list1 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
				}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\">".$the_line."</option>";
				}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($this->the_start > 0)
			{
				$start_prev = $this->the_start - $nb_show;
				$previous = '<a href="'.$link.'&amp;start='.$start_prev.'" class="prev">'._PREVIOUS.'</a>';
			}
			
			if($this->the_start <> $lastpage)
			{
				$start_next = $this->the_start + $nb_show;
				$next = '<a href="'.$link.'&amp;start='.$start_next.'" class="next">'._NEXT.'</a>';
			}
			
			$page_list1 = $page_list1."</select>";
			$page_list2 = $page_list2."</select>";
				
			if($previous <> '' || $next <> '')
			{
				if(empty($previous)) { $previous = "&nbsp;"; }
				if(empty($next)) { $next = "&nbsp;"; }
				
				$page_list1 .= $previous." ".$next.'</p></form>';
				$page_list2 .= $previous." ".$next.'</p></form>';
			}
		}
		
		$this->query("select distinct ID from ".$table_name." where ENABLED = 'Y' ".$where." order by ID asc limit ".$this->the_start.",".$nb_show);
			
			echo '<h1><img src="'.$_SESSION['config']['img'].'/picto_service_b.gif" alt="" /> '.$title.'</h1>
		
			<div id="inner_content" class="clearfix">';
			
		$this->servicelistletters();
		 echo $page_list1; 
		?>
		<table cellpadding="0" cellspacing="0" border="0" class="listing spec">
				<thead>
					<tr>
						<th class="id"><? echo _ID.' '._DEPARTMENT;?></th>
						<th class="title"><? echo _DESC;?> </th>
				   		<th colspan="3" align="right" class="price"><span class="add clearfix"><a  href="index.php?page=service_add"  ><span><? echo _ADD_DEPARTMENT;?></span></a></span></th>
				  </tr>
				</thead>
				<tfoot>
					<tr>
						<td colspan="7" class="price"><span class="add clearfix"><a  href="index.php?page=service_add"  ><span><? echo _ADD_DEPARTMENT;?></span></a></span></td>
					</tr>
				</tfoot>
				<tbody>
		
		<?php
		$db = new dbquery();
		$db->connect();
		
		$color = "line1";
		while($line = $this->fetch_object())
		{
			if($color == ' class="col"')
			{
				$color = '';
			}
			else
			{
				$color = ' class="col"';
			}
			$db->query("select ID, SERVICE from ".$table_name." where ID ='".$line->ID."'"); 		
			$desc = "";
			$line2 = $db->fetch_object();
			$desc = $line2->SERVICE;
			?>
			<tr <?php echo $color; ?>>
				<td class="id"><strong><?php echo $line->ID; ?></strong></td>
				<td class="descr"><?php echo str_replace('\\', '',$desc); ?></td>
				
				<td class="action">
                <a href="index.php?page=service_up&amp;id=<? echo $line->ID;?>" class="change"  ><?php echo _MODIFY; ?></a>
                </td>
				<td class="action">
					<a href="javascript://"  class="delete" onClick="window.open('service_del.php?id=<? echo $line->ID;?>', '', 'scrollbar=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=400,height=200');" ><? echo _DELETE;?></a>
				</td>	
			</tr>
				<?php
			}
			?>
			</tbody>
		</table>
		</div>

		<?php	
		$this->clearserviceinfos();
	}
	
	
	
	
	
	/**
	* Draw the departments list
	*
	* @param 	string  $where sorting of the list (empty by default)
	* @param 	string  $what  first letter of the name (empty by default)
	*/
	public function emetlist($where = "",$what = "")
	{
		// draw the services list
		$func = new functions();
		
		/* Configuration */
		$title = _SHIPPER_LIST;
		$page_name = "emet";
		$table_name = $_SESSION['tablename']['senders'];
		$res_table = $_SESSION['ressources'][0]['tablename'];
		$nb_show = $_SESSION['config']['nblinetoshow'];
		
		
		if(!empty($what))
		{
			$what = "&what=".$what;
		}
		/***********************/
		
		$this->connect();
		$this->query("select count(*) as total from ".$table_name." where (1=1) ".$where);
		//$this->show();
		$nb_total_1 = $this->fetch_object();
		$nb_total = $nb_total_1->total;
		
		// define the defaults values
		$nb_pages = ceil($nb_total/$nb_show);
		
		$link = "index.php?page=".$page_name."&start=".$this->the_start."&order=".$this->orderby.$what;
		
		if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form name="newpage1" id="newpage1" method="get" action="index.php?page=groups" >
			<p>
				<label for="startpage">'._GO_TO_PAGE.'</label>
				<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;start=\'+document.newpage1.startpage.value;">';
			
			$page_list2 = '<form name="newpage2" id="newpage2" method="get" action="index.php?page=groups"  >
			<p>
				<label for="startpage">'._GO_TO_PAGE.'</label>
				<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;start=\'+document.newpage2.startpage.value;">';
			
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($this->the_start == $next_start)
				{
					$page_list1 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
				}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\">".$the_line."</option>";
				}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($this->the_start > 0)
			{
				$start_prev = $this->the_start - $nb_show;
				$previous = '<a href="'.$link.'&amp;start='.$start_prev.'" class="prev">'._PREVIOUS.'</a>';
			}
			
			if($this->the_start <> $lastpage)
			{
				$start_next = $this->the_start + $nb_show;
				$next = '<a href="'.$link.'&amp;start='.$start_next.'" class="next">'._NEXT.'</a>';
			}
			
			$page_list1 = $page_list1."</select>";
			$page_list2 = $page_list2."</select>";
				
			if($previous <> '' || $next <> '')
			{
				if(empty($previous)) { $previous = "&nbsp;"; }
				if(empty($next)) { $next = "&nbsp;"; }
				
				$page_list1 .= $previous." ".$next.'</p></form>';
				$page_list2 .= $previous." ".$next.'</p></form>';
			}
		}
		
		$this->query("select distinct ID from ".$table_name." where (1=1) ".$where." order by ID asc limit ".$this->the_start.",".$nb_show);
			
			echo '<h1><img src="'.$_SESSION['config']['img'].'/liste_emetteurs_b.gif" alt="" /> '.$title.'</h1>
		
			<div id="inner_content" class="clearfix">';
			
		$this->emetlistletters();
		 echo $page_list1; 
		?>
		<table cellpadding="0" cellspacing="0" border="0" class="listing spec">
				<thead>
					<tr>
						<th class="id"><? echo _LASTNAME;?></th>
                        <th ><? echo _FIRSTNAME;?></th>
                         <th ><? echo _SOCIETY;?></th>
				   		<th colspan="3" align="right" class="price"><span class="add clearfix"><a  href="index.php?page=emet_add"  ><span><? echo _ADD_SHIPPER;?></span></a></span></th>
				  </tr>
				</thead>
				<tfoot>
					<tr>
						<td colspan="6" class="price"><span class="add clearfix"><a  href="index.php?page=emet_add"  ><span><? echo _ADD_SHIPPER;?></span></a></span></td>
					</tr>
				</tfoot>
				<tbody>
		
		<?php
		$db = new dbquery();
		$db->connect();
		
		$color = "line1";
		while($line = $this->fetch_object())
		{
			if($color == ' class="col"')
			{
				$color = '';
			}
			else
			{
				$color = ' class="col"';
			}
			
			$db->query("select ID, LASTNAME, FIRSTNAME, SOCIETY from ".$table_name." where ID ='".$line->ID."'"); 		
			$desc = "";
			$line2 = $db->fetch_object();
			$name = $line2->LASTNAME;
			$prenom = $line2->FIRSTNAME;
			$societe = $line2->SOCIETY;
			?>
			<tr <?php echo $color; ?>>
				<td class="id"><strong><?php echo $name; ?></strong></td>
                <td ><?php echo $prenom; ?></td>
                <td ><?php echo $societe; ?></td>
				<td class="action">
                <a href="index.php?page=emet_up&amp;id=<? echo $line->ID;?>" class="change"  ><?php echo _MODIFY; ?></a>
                </td>
				<td class="action">
					<a href="emet_del.php?id=<? echo $line->ID;?>" class="delete" onClick="return(confirm('<? echo ' '._REALLY_DELETE.' '.$name.'  ?\n'._DEFINITIVE_ACTION."!";?>'));" ><? echo _DELETE;?></a>
				</td>	
			</tr>
				<?php
			}
			?>
			</tbody>
		</table>
		</div>

		<?php	
		$this->clearemetinfos();
	}
	
	
	
	
	
	
	
	/**
	* Load the data of the letterbox.xml file into session
	*
	*/
	public function xmltosessionletterbox()
	{
		$xmlbezons = simplexml_load_file('xml/letterbox.xml')	;	
		$_SESSION['civilite'] = array();
		//$_SESSION['emetteur'] = array();
		$_SESSION['nature'] = array();
		$_SESSION['quartiers'] = array();
		$increment = 0;
		foreach($xmlbezons->CIVILITE as $CIVILITE)
		{
			foreach($CIVILITE-> CIV as $CIV)
			{
				$_SESSION['civilite'][$increment] = utf8_decode((string) $CIV);
				$increment++;
			}
		}
		
		$increment = 0;
			
		
		//foreach($xmlbezons->EMETTEUR as $EMETTEUR)
		//{
		//	foreach($EMETTEUR-> EME as $EME)
		//	{
		//		$_SESSION['emetteur'][$increment] = utf8_decode((string) $EME);
		//		$increment++;
		//	}
     	//}
	    //	$increment = 0;
		
		
		foreach($xmlbezons->NATURE as $NATURE)
		{
			foreach($NATURE-> NAT as $NAT)
			{
				$_SESSION['nature'][$increment] = utf8_decode((string) $NAT);
				$increment++;
			}
		}
		
		$increment = 0;
		foreach($xmlbezons->QUARTIERS as $QUARTIERS)
		{
			foreach($QUARTIERS->QUA as $QUA)
			{
				$_SESSION['quartiers'][$increment] = utf8_decode((string) $QUA);
				$increment++;
			}
		}
	
	}
	
	
	
	
	
	/**
	* Load the rights on the departments in the database (used in the class_usergroups.php file)
	*
	*/
	public function load_group_service()
	{
		if(count($_SESSION['services_choisis']) > 0)
		{
			$where = " DESTINATION IN ( ";
			for($i=0; $i < count($_SESSION['services_choisis']); $i++)
			{
				$where .= " \'".trim($_SESSION['services_choisis'][$i])."\', ";
			}
			$where = ereg_replace(", $", " )", $where);
		}
		else
		{
			$where = " (1=-1) ";
		}
		
		$this->connect();
		
		$this->query("DELETE FROM ".$_SESSION['tablename']['security'] ." where GROUP_ID = '".$_SESSION['m_admin']['groups']['GroupId']."'");

		$this->query("INSERT INTO ".$_SESSION['tablename']['security']." VALUES ('".$_SESSION['m_admin']['groups']['GroupId']."', '".$_SESSION['ressources'][0]['tablename']."', '".$where."', '', 'N' , 'N')");
	}
	
	/**
	* List of the mail process basket documents
	*
	* @param  array  $listarr contains the document index of the process basket
	* @param int  $nb_total  number of document
	* @param string  $title  title
	* @param string  $name  page name
	*/
	public function mail_process($listarr, $nb_total, $title, $name)
	{
		
			$_SESSION['diff'] = array();
			$_SESSION['error'] = '';
		
		// show the document list in result of the search
		$page_list1 = "";
		$page_list2 = "";

		$func = new functions();
		
		if(isset($_REQUEST['start']))
		{
			$start = strip_tags($_REQUEST['start']);
		}
		else
		{
			$start = 0;
		}
		
		if(isset($_GET['order']))
		{
			$orderby = strip_tags($_GET['order']);
		}
		else
		{
			$orderby = 0;
		}
		
		
			$link = "index.php?page=".$name;
			
		
		// define the defaults values
		$nb_show = $_SESSION['config']['nblinetoshow'];
		$nb_pages = ceil($nb_total/$nb_show);
		
		// if they are more than 1 page we do pagination with 2 forms
			if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form action="" name="newpage1" id="newpage1" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage1.startpage.value;">';
			$page_list2 = '<form action="" name="newpage2" id="newpage2" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage2.startpage.value;">';
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($start == $next_start)
				{	
					$page_list1 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
				}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\">".$the_line."</option>";
				}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($start > 0)
			{
				$start_prev = $start - $nb_show;
				$previous = "< <a href=\"".$link."&start=".$start_prev."&order=".$orderby."\">"._PREVIOUS."</a> ";
			}
			
			if($start <> $lastpage)
			{
				$start_next = $start + $nb_show;
				$next = " <a href=\"".$link."&start=".$start_next."&order=".$orderby."\">"._NEXT."</a> >";
			}
			
			$page_list1 = $page_list1."</select>".$previous." ".$next."</p></form>";
			$page_list2 = $page_list2."</select>".$previous." ".$next."</p></form>";
			
		}
		
		?>
		
			<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_post_b.gif" alt="" /> <? echo $title; ?></h1>
				
				<div id="inner_content" class="clearfix">
					<?php echo $page_list1;?>
					<form name="choose_mail" id="choose_mail" method="post" action="manage_redirection.php">
                      <input type="hidden" name="start" id="start" value="<? echo $start;?>" />
					<table cellpadding="0" cellspacing="0" border="0" class="listing">
						<thead>
							<tr>
                            <? if(!$_SESSION['current_basket']['no_action']){ ?><th>&nbsp;</th><? }?>
								<th class="picto"  ><? echo _STATUS;?> <br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=statusdesc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" /> </a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=statusasc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
                                <th class="picto"  ><? echo _PRIORITY;?> <br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=priodesc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/> </a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=prioasc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
								<th class="date"><? echo _DATE_START;?> <a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>	
								</th>
								<th class="price"><? echo _GED_NUM;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
							<!--	<th class="type2"><? echo _MAIL_TYPE;?><br/>
										<a href="<?php echo $link; ?>&start=<?php echo $start; ?>&order=typedesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" /></a> 
										<a href="<?php echo $link; ?>&start=<?php echo $start; ?>&order=typeasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" /></a>
								</th>-->
								<th ><? 
								if($_SESSION['config']['corporate'] == "true")
								{
								echo _SOCIETY;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=socidesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=sociasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>
                                 <?
								 }
								 else
								 {
									 echo _OBJECT;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>
								<? }?>
								</th>
 								<th class="emetteur"><? echo _SHIPPER;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>	
								</th>
							
								<th class="date"><? echo _LIMIT_DATE_PROCESS;?>
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=limdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=limasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>
								</th>
							</tr>
						</thead>
						<tbody>
		<?php		
		$color = "";
		$func =new functions();
		for($theline = 0; $theline < count($listarr) ; $theline++)
		{
			if($color == ' class="col"')
			{
				$color = '';
			}
			else
			{
				$color = ' class="col"';
			}
			?>
		<tr <?php echo $color; ?>>
					  <? if(!$_SESSION['current_basket']['no_action']){ ?><td><input type="checkbox" name="mail[]" value="<?php echo $listarr[$theline]['ID']; ?>" /></td><? } ?>
                    <td class="picto"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=no,menubar=no,toolbar=no,resizable=yes,status=no,width=1024,height=780');">
				<?php  if ($listarr[$theline]['STATUS']=="NEW") 
				{ ?>
				 <img src="<? echo $_SESSION['config']['img'];?>/mail_new.gif" alt="<? echo _TO_PROCESS;?>" title="<? echo _TO_PROCESS;?>"/>
				
				
			<?	}  else 
			{ ?>
				 <img src="<? echo $_SESSION['config']['img'];?>/mail.gif" alt="<?  echo _IN_PROGRESS;?>" title="<? echo _IN_PROGRESS;?>" />
				
				
			<?	}  ?></td>
             <td   onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=no,menubar=no,toolbar=no,resizable=yes,status=no,width=1024,height=780');">
				<?php  if ($listarr[$theline]['PRIORITY']==1) 
				{ 
					echo _HIGH;
				}  
				else if ($listarr[$theline]['PRIORITY']==2) 
				{ 
					echo _NORMAL;
				} 
				else
				{
					echo _LOW;
				} ?></td>
				<td class="date" onMouseOver="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=no,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><?  if($listarr[$theline]['STATUS'] == "OUT")
					 {
						 echo $this->dateformat($listarr[$theline]['CREATION_DATE']);
					 }
					 else
					 {
						
					 	if("0000-00-00" == $listarr[$theline]['ARRIVEE'] || "00-00-0000" == $listarr[$theline]['ARRIVEE'])
						{
							echo $this->dateformat($listarr[$theline]['CREATION_DATE']);
						}
						else
						{
					 		echo $this->dateformat($listarr[$theline]['ARRIVEE']);
						}
					} ?></td>
				<td class="price"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=no,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><? echo $listarr[$theline]['ID']; ?></td>
                <!--
				<td class="type2"  onmouseover="changeCouleur2(this,'#000000',true);" onmouseout="changeCouleur2(this,'#666',false);" onclick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><?php echo $listarr[$theline]['TYPE']; ?></td>-->
				<td class="emetteur"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=no,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><? if($_SESSION['config']['corporate']=="true"){ echo $func->show($listarr[$theline]['SOCIETE']);}else
				{ echo $func->show($listarr[$theline]['OBJET']); } ?></td>
				
				<td  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=no,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><?php echo $func->show($listarr[$theline]['EMETTEUR']); ?></td>
			 
			    <td class="date"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('process.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=no,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><? echo $listarr[$theline]['LIMITE']; ?></td>
		   </tr>
		   <?php
			}
			?>
		  </tbody>
		  </table> 
        
		  <p><em><? echo _CLICK_LINE_PROCESS;?></em> </p>
          <br/>
          <? if(!$_SESSION['current_basket']['no_action'])
		  {
		  ?>
          <div>
          	<p>
            	<label><? echo _CHOOSE_ACTION;?> : </label>
                
                <select name="action" id="action">
  
                <? if($_SESSION['current_basket']['can_redirect'] == 'Y' )
				{
					?>
                    <option value="RED"><? echo _REDIRECTION;?></option>
                    <?
				}
				if($_SESSION['current_basket']['can_delete'] == true)
				{
				?>
                <option value="DEL"><? echo _DELETION;?></option>
                <?
				}
				?>
                </select>
                <input type="submit" name="valid" id="valid" value="<? echo _VALIDATE;?>" class="button" />
            </p>
          </div>
          <? } ?>
            </form>
	</div>
		
		<?
	}
	
	
	/**
	* List of the mail process basket documents
	*
	* @param  array  $listarr contains the document index of the process basket
	* @param int  $nb_total  number of document
	* @param string  $title  title
	* @param string  $name  page name
	*/
	public function ending_process($listarr, $nb_total, $title, $name)
	{
		
			$_SESSION['diff'] = array();
			$_SESSION['error'] = '';
		
		// show the document list in result of the search
		$page_list1 = "";
		$page_list2 = "";

		$func = new functions();
		
		if(isset($_REQUEST['start']))
		{
			$start = strip_tags($_REQUEST['start']);
		}
		else
		{
			$start = 0;
		}
		
		if(isset($_GET['order']))
		{
			$orderby = strip_tags($_GET['order']);
		}
		else
		{
			$orderby = 0;
		}
		
		
			$link = "index.php?page=".$name;
			
		
		// define the defaults values
		$nb_show = $_SESSION['config']['nblinetoshow'];
		$nb_pages = ceil($nb_total/$nb_show);
		
		// if they are more than 1 page we do pagination with 2 forms
			if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form action="" name="newpage1" id="newpage1" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage1.startpage.value;">';
			$page_list2 = '<form action="" name="newpage2" id="newpage2" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage2.startpage.value;">';
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($start == $next_start)
				{	
					$page_list1 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
				}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\">".$the_line."</option>";
				}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($start > 0)
			{
				$start_prev = $start - $nb_show;
				$previous = "< <a href=\"".$link."&start=".$start_prev."&order=".$orderby."\">"._PREVIOUS."</a> ";
			}
			
			if($start <> $lastpage)
			{
				$start_next = $start + $nb_show;
				$next = " <a href=\"".$link."&start=".$start_next."&order=".$orderby."\">"._NEXT."</a> >";
			}
			
			$page_list1 = $page_list1."</select>".$previous." ".$next."</p></form>";
			$page_list2 = $page_list2."</select>".$previous." ".$next."</p></form>";
			
		}
		
		?>
		
			<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_post_b.gif" alt="" /> <? echo $title; ?></h1>
				
				<div id="inner_content" class="clearfix">
					<?php echo $page_list1;?>
					<form name="choose_mail" id="choose_mail" method="post" action="manage_redirection.php">
                      <input type="hidden" name="start" id="start" value="<? echo $start;?>" />
					<table cellpadding="0" cellspacing="0" border="0" class="listing">
						<thead>
							<tr>
                            <? if(!$_SESSION['current_basket']['no_action']){ ?><th>&nbsp;</th><? }?>
								<th class="picto"  ><? echo _STATUS;?> <br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=statusdesc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>" /> </a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=statusasc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
                                <th class="picto"  ><? echo _PRIORITY;?> <br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=priodesc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/> </a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=prioasc"> 
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
								<th class="date"><? echo _DATE_START;?> <a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>	
								</th>
								<th class="price"><? echo _GED_NUM;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
							<!--	<th class="type2"><? echo _MAIL_TYPE;?><br/>
										<a href="<?php echo $link; ?>&start=<?php echo $start; ?>&order=typedesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" /></a> 
										<a href="<?php echo $link; ?>&start=<?php echo $start; ?>&order=typeasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" /></a>
								</th>-->
								<th class="emetteur"><? echo _SHIPPER;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>
								</th>
								<th ><? echo _OBJECT;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>	
								</th>
							
								<th class="date"><? echo _LIMIT_DATE_PROCESS;?>
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=limdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=limasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>
								</th>
							</tr>
						</thead>
						<tbody>
		<?php		
		$color = "";
		for($theline = 0; $theline < count($listarr) ; $theline++)
		{
			if($color == ' class="col"')
			{
				$color = '';
			}
			else
			{
				$color = ' class="col"';
			}
			?>
		<tr <?php echo $color; ?>>
					  <? if(!$_SESSION['current_basket']['no_action']){ ?><td><input type="checkbox" name="mail[]" value="<?php echo $listarr[$theline]['ID']; ?>" /></td><? } ?>
                    <td class="picto"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');">
				<?php  if ($listarr[$theline]['STATUS']=="NEW") 
				{ ?>
				 <img src="<? echo $_SESSION['config']['img'];?>/mail_new.gif" alt="<? echo _TO_PROCESS;?>" title="<? echo _TO_PROCESS;?>"/>
				
				
			<?	}  else 
			{ ?>
				 <img src="<? echo $_SESSION['config']['img'];?>/mail.gif" alt="<?  echo _IN_PROGRESS;?>" title="<? echo _IN_PROGRESS;?>" />
				
				
			<?	}  ?></td>
             <td   onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');">
				<?php  if ($listarr[$theline]['PRIORITY']==1) 
				{ 
					echo _HIGH;
				}  
				else if ($listarr[$theline]['PRIORITY']==2) 
				{ 
					echo _NORMAL;
				} 
				else
				{
					echo _LOW;
				} ?></td>
				<td class="date" onMouseOver="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><? echo $listarr[$theline]['ARRIVEE']; ?></td>
				<td class="price"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><? echo $listarr[$theline]['ID']; ?></td>
                <!--
				<td class="type2"  onmouseover="changeCouleur2(this,'#000000',true);" onmouseout="changeCouleur2(this,'#666',false);" onclick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><?php echo $listarr[$theline]['TYPE']; ?></td>-->
				<td class="emetteur"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><? echo $listarr[$theline]['EMETTEUR']; ?></td>
				
				<td  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><?php echo $listarr[$theline]['OBJET']; ?></td>
			 
			    <td class="date"  onmouseover="changeCouleur2(this,'#000000',true);" onMouseOut="changeCouleur2(this,'#666',false);" onClick="changeCouleur2(this,'#CC3300',true);window.open('ending.php?id=<? echo $listarr[$theline]['ID']; ?>','Traitement', 'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,status=no,width=1020,height=780');"><? echo $listarr[$theline]['LIMITE']; ?></td>
		   </tr>
		   <?php
			}
			?>
		  </tbody>
		  </table> 
        
		  <p><em><? echo _CLICK_LINE_PROCESS;?></em> </p>
          <br/>
          <? if(!$_SESSION['current_basket']['no_action'])
		  {
		  ?>
          <div>
          	<p>
            	<label><? echo _CHOOSE_ACTION;?> : </label>
                
                <select name="action" id="action">
  
                <? if($_SESSION['current_basket']['can_redirect'] == 'Y' )
				{
					?>
                    <option value="RED"><? echo _REDIRECTION;?></option>
                    <?
				}
				if($_SESSION['current_basket']['can_delete'] == true)
				{
				?>
                <option value="DEL"><? echo _DELETION;?></option>
                <?
				}
				?>
                </select>
                <input type="submit" name="valid" id="valid" value="<? echo _VALIDATE;?>" class="button" />
            </p>
          </div>
          <? } ?>
            </form>
	</div>
		
		<?
	}
	
	
	
	
	
	/**
	* Form to modify a department
	*
	* @param  $string $mode up or add
	* @param int  $id  $id of the department to change
	*/
	public function formservice($mode,$id = "")
	{
		$func = new functions();
		
		$state = true;
		
		if(!isset($_SESSION['m_admin']['services']))
		{
			$this->clearserviceinfos();
		}
		
		if( $mode <> "add" && empty($_SESSION['error']))
		{
			$this->connect();
			$this->query("select * from ".$_SESSION['tablename']['services']." where ID = '".$id."'");
			
			if($this->nb_result() == 0)
			{
				$_SESSION['error'] = _DEPARTMENT.' '._ALREADY_EXISTS;
				$state = false;
			}
			else
			{
				$_SESSION['m_admin']['services'] = array();
				$line = $this->fetch_object();
				
				$_SESSION['m_admin']['services']['ID'] = $line->ID;
				$_SESSION['m_admin']['services']['LABEL'] = $line->SERVICE;
				$_SESSION['m_admin']['services']['VALIDATE'] = $line->ENABLED;
				
				
				$_SESSION['m_admin']['services']['listmodel'] = array();
				$this->query("select SEQUENCE, USER_ID from ".$_SESSION['tablename']['listmodel']." where RES_TABLE = 'res_x' and ID = '".$_SESSION['m_admin']['services']['ID']."' order by SEQUENCE asc ");
				 
				 while($line = $this->fetch_object())
				 {
				 	$_SESSION['m_admin']['services']['listmodel'][$line->SEQUENCE -1]['USER_ID'] = $line->USER_ID;
				 }
				 
				 for($i=0; $i < count($_SESSION['m_admin']['services']['listmodel']); $i++)
				 {
				 	$this->query("SELECT FIRSTNAME, LASTNAME, DEPARTMENT, MAIL FROM ".$_SESSION['tablename']['users']." WHERE USER_ID='".$_SESSION['m_admin']['services']['listmodel'][ $i]['USER_ID']."'");
					//$this->show();
					$line = $this->fetch_object();
					$_SESSION['m_admin']['services']['listmodel'][$i]['FIRSTNAME'] = $line->FIRSTNAME;
					$_SESSION['m_admin']['services']['listmodel'][$i]['LASTNAME'] = $line->LASTNAME;
					$_SESSION['m_admin']['services']['listmodel'][$i]['DEPARTMENT'] = $line->DEPARTMENT;
					$_SESSION['m_admin']['services']['listmodel'][$i]['MAIL'] = $line->MAIL;
				 }
			}
		}
		?>
		<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_add_b.gif" alt="" /> 
				<?php
				if($mode == "up")
				{
					echo _DEPARTMENT_MODIF;
				}
				elseif($mode == "add")
				{
					echo _DEPARTMENT_ADDITION;
				}
				?>
				</h1>
				
		
		<div id="inner_content" class="clearfix">
		
			<div id="type_box" class="bloc">
				<p><iframe name="types_liste_diff" id="types_liste_diff" src="types_liste_diff.php" class="frameform2"  frameborder="0"></iframe></p>
			</div>
			
			<?php
			if($state == false)
			{
				echo "<br /><br /><br /><br />"._DOCTYPE.' '._UNKOWN."<br /><br /><br /><br />";
			}
			else
			{
				?>
			
				<form name="frmservice" id="frmservice" method="post" action="service_up_db.php" class="forms addforms">
							
					<p>
						<label ><? echo _ID;?> : </label>
							<?php
								if($mode <> "prop" && $mode <> "add")
								{
									echo $func->show($_SESSION['m_admin']['services']['ID']);
								?>
									<input type="hidden" name="id" value="<?php echo $id; ?>" />
								<?php
								}
								else
								{
								?>
									<input name="id" type="text" id="id" class="textbox" value="<?php echo $func->show($_SESSION['m_admin']['services']['ID']); ?>" />
									<?php
								}
								?><span class="red_asterisk">*</span>
							<input  type="hidden" name="mode" value="<?php echo $mode; ?>" />
						</p>
                      
					 	 <p>		
					 	 	<label for="label"><?php echo _WORDING; ?> : </label>
							<textarea name="label"   id="label" ><?php echo $func->show($_SESSION['m_admin']['services']['LABEL']); ?></textarea><span class="red_asterisk">*</span>
					 	 </p>
					   <p>
                        <iframe name="manage_models" id="manage_models" src="manage_models.php" frameborder="0" width="400" height="200"></iframe>
                        </p>
						<p class="buttons">
									<?php
						
					/*	if($mode == "up")
						{
						?>
							<input class="button" type="submit" name="Submit" value="<?php echo _MODIFY_DEPARTMENT; ?>" />
						<?php
						}
					
						elseif($mode == "add")
						{
						?>
							<input type="submit" class="button"  name="Submit" value="<?php echo _ADD_DEPARTMENT; ?>" />
						<?
						}*/
						?>
                        <input type="submit" class="button"  name="Submit" value="<?php echo _VALIDATE; ?>" />
                        <input type="button" class="button"  name="cancel" value="<?php echo _CANCEL; ?>" onClick="javascript:window.location.href='index.php?page=liste';" />
								</p>
					</form >
			
			<?php
			}
			?>
	
		</div>
	<?php
	}
	/**
	* Return the user information in sessions vars
	*
	* @param string $mode add or up
	*/
	public function emetinfo($mode)
	{
		require_once("class_usergroup_content.php");
		// return the user information in sessions vars
		$func = new functions();
				
		$_SESSION['m_admin']['emet']['NAME'] = $func->wash($_REQUEST['name'], "no", _THE_LASTNAME.' ');
		
		if(isset($_REQUEST['prenom']) && !empty($_REQUEST['prenom']))
		{
			$_SESSION['m_admin']['emet']['PRENOM'] = $func->wash($_REQUEST['prenom'], "no", _THE_FIRSTNAME.' ');
		}
		$_SESSION['m_admin']['emet']['FONCTION'] = '';
		if(isset($_REQUEST['fonction']) && !empty($_REQUEST['fonction']))
		{
			$_SESSION['m_admin']['emet']['FONCTION'] = $func->wash($_REQUEST['fonction'], "no", _THE_FUNCTION.' ');
		}

		if ($_REQUEST['societe'] <> '')
		{
			$_SESSION['m_admin']['emet']['SOCIETE'] = $func->wash($_REQUEST['societe'], "no", _THE_SOCIETY." ");
		}
		else
		{
			$_SESSION['m_admin']['emet']['SOCIETE'] = '';
		}
		
		if ($_REQUEST['street'] <> '')
		{
			$_SESSION['m_admin']['emet']['STREET'] = $func->wash($_REQUEST['street'], "no", _ADDRESS.' ');
		}
		else
		{
			$_SESSION['m_admin']['emet']['STREET'] = '';
		}
		
		if ($_REQUEST['town'] <> '')
		{
			$_SESSION['m_admin']['emet']['TOWN'] = $func->wash($_REQUEST['town'], "no", _TOWN.' ');
		}
		else
		{
			$_SESSION['m_admin']['emet']['TOWN'] = '';
		}
		if ($_REQUEST['cp'] <> '')
		{
			$_SESSION['m_admin']['emet']['CP'] = $func->wash($_REQUEST['cp'], "no", _POSTAL_CODE.' ');
		}
		else
		{
			$_SESSION['m_admin']['emet']['CP'] = '';
		}
		if ($_REQUEST['phone'] <> '')
		{	
			$_SESSION['m_admin']['emet']['PHONE'] = $func->wash($_REQUEST['phone'], "num", _PHONE." ");
		}
		else
		{	
			$_SESSION['m_admin']['emet']['PHONE'] = '';
		}
		if ($_REQUEST['mail'] <> '')
		{	
			$_SESSION['m_admin']['emet']['MAIL'] = $func->wash($_REQUEST['mail'], "mail", _MAIL);
		}
		else
		{
			$_SESSION['m_admin']['emet']['MAIL'] = '';
		}
	/*	if ($_REQUEST['tocontact'] <> '')
		{	
			$_SESSION['m_admin']['emet']['TOCONTACT'] = $func->wash($_REQUEST['tocontact'], "no", "Contact privilegi�");
		}
		else
		{
			$_SESSION['m_admin']['emet']['TOCONTACT'] = '';
		}*/
	}
	
	/**
	* Add ou modify emett in the database
	*
	* @param string $mode up or add
	*/
	public function addupemet($mode)
	{
		// add ou modify users in the database
		$this->emetinfo($mode);
		
		if(!empty($_SESSION['error']))
		{
			if($mode == "up")
			{
				if(!empty($_SESSION['m_admin']['emet']['ID']))
				{
					header("location: index.php?page=emet_up&id=".$_SESSION['m_admin']['emet']['ID']);
					exit;
				}
				else
				{
					header("location: index.php?page=emet");
					exit;
				}
			}
			if($mode == "add")
			{
				header("location: index.php?page=emet_add");
				exit;			
			}
		}
		else
		{
			$this->connect();
			
			if($mode == "add")
			{
				
				
				$this->query("INSERT INTO `".$_SESSION['tablename']['senders']."` (  `ID` , LASTNAME , FIRSTNAME , SOCIETY, FUNCTION , STREET, TOWN, CP, PHONE, MAIL ) VALUES ( '', '".$_SESSION['m_admin']['emet']['NAME']."', '".$_SESSION['m_admin']['emet']['PRENOM']."', '".$_SESSION['m_admin']['emet']['SOCIETE']."', '".$_SESSION['m_admin']['emet']['FONCTION']."', '".$_SESSION['m_admin']['emet']['STREET']."', '".$_SESSION['m_admin']['emet']['TOWN']."', '".$_SESSION['m_admin']['emet']['CP']."', '".$_SESSION['m_admin']['emet']['PHONE']."', '".$_SESSION['m_admin']['emet']['MAIL']."' )");
				
				$this->clearemetinfos();
				
				$_SESSION['error'] = _SHIPPER_ADDED;
				header("location: index.php?page=emet");
				exit;
			
			}
			elseif($mode == "up")
			{
					
					$this->query("update `".$_SESSION['tablename']['senders']."` set `LASTNAME` = '".$_SESSION['m_admin']['emet']['NAME']."', `FIRSTNAME` = '".$_SESSION['m_admin']['emet']['PRENOM']."', `FUNCTION` = '".$_SESSION['m_admin']['emet']['FONCTION']."', `SOCIETY` = '".$_SESSION['m_admin']['emet']['SOCIETE']."', `STREET` = '".$_SESSION['m_admin']['emet']['STREET']."', `TOWN` = '".$_SESSION['m_admin']['emet']['TOWN']."', `CP` = '".$_SESSION['m_admin']['emet']['CP']."' , `PHONE` = '".$_SESSION['m_admin']['emet']['PHONE']."', `MAIL` = '".$_SESSION['m_admin']['emet']['MAIL']."' where ID = '".$_SESSION['m_admin']['emet']['ID']."'");
					
				$this->clearemetinfos();
				
				$_SESSION['error'] = _SHIPPER_UPDATED;
				header("location: index.php?page=emet");
				exit;
			}
		}
	}
	
	
	
	
	
	/**
	* Form to modify a emettor
	*
	* @param  $string $mode up or add
	* @param int  $id  $id of the department to change
	*/
	public function formemet($mode,$id = "")
	{
		$func = new functions();
		
		$state = true;
		
		if(!isset($_SESSION['m_admin']['emet']))
		{
			$this->clearemetinfos();
		}
		
		if( $mode <> "add" && empty($_SESSION['error']))
		{
			$this->connect();
			$this->query("select * from ".$_SESSION['tablename']['senders']." where ID = '".$id."'");
			
			if($this->nb_result() == 0)
			{
				$_SESSION['error'] = _THE_SHIPPER.' '._ALREADY_EXISTS;
				$state = false;
			}
			else
			{
				$_SESSION['m_admin']['emet'] = array();
				$line = $this->fetch_object();
				
				$_SESSION['m_admin']['emet']['ID'] = $line->ID;
				$_SESSION['m_admin']['emet']['NAME'] = $line->LASTNAME;
				$_SESSION['m_admin']['emet']['PRENOM'] = $line->FIRSTNAME;
				$_SESSION['m_admin']['emet']['SOCIETE'] = $line->SOCIETE;
				$_SESSION['m_admin']['emet']['FONCTION'] = $line->FUNCTION;
				$_SESSION['m_admin']['emet']['STREET'] = $line->STREET;
				$_SESSION['m_admin']['emet']['TOWN'] = $line->TOWN;
				$_SESSION['m_admin']['emet']['CP'] = $line->CP;
				$_SESSION['m_admin']['emet']['PHONE'] = $line->PHONE;
				$_SESSION['m_admin']['emet']['MAIL'] = $line->MAIL;
				$_SESSION['m_admin']['emet']['TOCONTACT'] = $line->TOCONTACT;				
				
			}
		}
		?>
		<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_add_b.gif" alt="" /> 
				<?php
				if($mode == "up")
				{
					echo _MODIFICATION_SHIPPER;
				}
				elseif($mode == "add")
				{
					echo _ADD_SHIPPER;
				}
				?>
				</h1>
				
		
		<div id="inner_content" class="clearfix">
		
		
			<?php
			if($state == false)
			{
				echo "<br /><br /><br /><br />"._SHIPPER." "._UNKOWN."<br /><br /><br /><br />";
			}
			else
			{
				?>
			
				<form name="frmemett" id="frmemett" method="post" action="emet_up_db.php" class="forms">
							                  
					 	 <p>		
					 	 	<label for="label"><?php echo _LASTNAME; ?> : </label>
							<input name="name" type="text" id="name" value="<?php echo $func->show($_SESSION['m_admin']['emet']['NAME']); ?>"/><span class="red_asterisk">*</span>
					 	 </p>
                          <p>		
					 	 	<label for="label"><?php echo _FIRSTNAME; ?> : </label>
							<input name="prenom" type="text" id="prenom" value="<?php echo $func->show($_SESSION['m_admin']['emet']['PRENOM']); ?>"/>
					 	 </p>
                          <p>		
					 	 	<label for="label"><? echo _SOCIETY;?> : </label>
							<input name="societe" type="text" id="societe" value="<?php echo $func->show($_SESSION['m_admin']['emet']['SOCIETE']); ?>"/>
					 	 </p>
                         <p>		
					 	 	<label for="label"><?php echo _FUNCTION; ?> : </label>
							<textarea name="fonction" id="fonction" ><?php echo $func->show($_SESSION['m_admin']['emet']['FONCTION']); ?></textarea>
					 	 </p>
                         <p>		
					 	 	<label for="label"><?php echo _ADDRESS; ?> : </label>
							<input name="street" type="text" class="textbox" id="label" value="<?php echo $func->show($_SESSION['m_admin']['emet']['STREET']); ?>"/>
					 	 </p>
					 	<p>		
					 	 	<label for="label"><?php echo _TOWN; ?> : </label>
							<input name="town" type="text" class="textbox" id="label" value="<?php echo $func->show($_SESSION['m_admin']['emet']['TOWN']); ?>"/>
					 	 </p>
                         <p>		
					 	 	<label for="label"><?php echo _POSTAL_CODE; ?> : </label>
							<input name="cp" type="text" class="textbox" id="label" value="<?php echo $func->show($_SESSION['m_admin']['emet']['CP']); ?>"/>
					 	 </p>
                         <p>		
					 	 	<label for="label"><?php echo _PHONE; ?> : </label>
							<input name="phone" type="text" class="textbox" id="label" value="<?php echo $func->show($_SESSION['m_admin']['emet']['PHONE']); ?>"/>
					 	 </p>
                         <p>		
					 	 	<label for="label"><?php echo _MAIL; ?> : </label>
							<input name="mail" type="text" class="textbox" id="label" value="<?php echo $func->show($_SESSION['m_admin']['emet']['MAIL']); ?>"/>
					 	 </p>
                      <!--   <p>		
					 	 	<label for="label"><?php echo "Contact"; ?> : </label>
							<input name="tocontact" type="text" class="textbox" id="label" value="<?php echo $func->show($_SESSION['m_admin']['emet']['TOCONTACT']); ?>"/>
					 	 </p>-->
                         
                         	<input name="mode" type="hidden" value="<? echo $mode; ?>" />
                         
                         
						<p class="buttons">
									<?php
						
					if($mode == "up")
						{
						?>
							<input class="button" type="submit" name="Submit" value="<? echo _VALIDATE;?>" />
						<?php
						}
					
						elseif($mode == "add")
						{
						?>
							<input type="submit" class="button"  name="Submit" value="<? echo _VALIDATE;?>" />
						<?
						}
						?>
                       <input type="button" class="button"  name="cancel" value="<?php echo _CANCEL; ?>" onClick="javascript:window.location.href='index.php?page=emet';" />
								
								</p>
					</form >
			
			<?php
			}
			?>
	
		</div>
	<?php
	}
	
	
	
	/**
	* Clear the session variables of the edmit 's administration
	*
	*/
	private function clearemetinfos()
	{
		// clear the session variable 
		$_SESSION['m_admin']['emet'] = array();
		$_SESSION['m_admin']['emet']['ID'] = "";
		$_SESSION['m_admin']['emet']['NAME'] = "";
		$_SESSION['m_admin']['emet']['PRENOM'] = "";
		$_SESSION['m_admin']['emet']['FONCTION'] = "";
		$_SESSION['m_admin']['emet']['SOCIETE'] = "";
		$_SESSION['m_admin']['emet']['STREET'] = "";
		$_SESSION['m_admin']['emet']['TOWN'] = "";
		$_SESSION['m_admin']['emet']['CP'] = "";
		$_SESSION['m_admin']['emet']['PHONE'] = "";
		$_SESSION['m_admin']['emet']['MAIL'] = "";
		//$_SESSION['m_admin']['emet']['TOCONTACT'] = "";
		//$_SESSION['m_admin']['emet']['listmodel'] = array();
	}
	
	
	/**
	* Clear the session variables of the department administration
	*
	*/
	private function clearserviceinfos()
	{
		// clear the session variable 
		$_SESSION['m_admin']['services'] = array();
		$_SESSION['m_admin']['services']['ID'] = "";
		$_SESSION['m_admin']['services']['LABEL'] = "";
		$_SESSION['m_admin']['services']['VALIDATE'] = "";
		
		$_SESSION['m_admin']['services']['listmodel'] = array();
	}
	
	/**
	* Verify the data of the department modification / addition form
	*
	*/
	private function servicesinfo()
	{		
		$func = new functions();
		
		if(!isset($_REQUEST['mode']))
		{
			$_SESSION['error'] = _UNKNOWN_PARAM."<br />";
		}
		
		$_SESSION['m_admin']['services']['LABEL'] = $func->wash($_REQUEST['label'], "no", _THE_WORDING);
		$_SESSION['m_admin']['services']['ID'] = $func->wash($_REQUEST['id'], "no", _ID);
	
	}
	
	/**
	* Update or insert trhe database with the department info
	*/
	public function upservices()
	{
		$this->servicesinfo();
		
		if(!empty($_SESSION['error']))
		{
			if($_REQUEST['mode'] == "up")
			{
				if(!empty($_SESSION['m_admin']['services']['ID']))
				{
					header("location: index.php?page=service_up&id=".$_SESSION['m_admin']['services']['ID']);
					exit;
				}
				else
				{
					header("location: index.php?page=liste");
					exit;
				}
			}
			
			elseif($_REQUEST['mode'] == "add" )
			{
				header("location: index.php?page=service_add");
				exit;
			}
		}
		else
		{
			$this->connect();
			
			if( $_REQUEST['mode'] <> "add")
			{
				
				$this->query("update `".$_SESSION['tablename']['services']."` set `SERVICE` = '".addslashes($_SESSION['m_admin']['services']['LABEL'])."' , `ENABLED` = 'Y' where ID = '".$_SESSION['m_admin']['services']['ID']."'");
					
				$this->query("Delete from ".$_SESSION['tablename']['listmodel']." where RES_TABLE ='res_x' and ID = '".$_SESSION['m_admin']['services']['ID']."'");
				
				for($i=0; $i < count($_SESSION['m_admin']['services']['listmodel']);$i++)
				{
					$seq = $i+1;
					$this->query("insert into ".$_SESSION['tablename']['listmodel']." ( RES_TABLE , ID, SEQUENCE, USER_ID  ) VALUES ('res_x', '".$_SESSION['m_admin']['services']['ID']."', ".$seq.", '".$_SESSION['m_admin']['services']['listmodel'][ $i]['USER_ID']."')");
				}
				
				if($_REQUEST['mode'] == "up")
				{
					$_SESSION['error'] = _DEPARTMENT_MODIF;
					if($_SESSION['history']['servicesup'] == "true")
					{
						require("class_history.php");
						$users = new history();
						$users->add($_SESSION['tablename']['services'], $_SESSION['m_admin']['services']['ID'],"UP",_DEPARTMENT_MODIF." : ".$_SESSION['m_admin']['services']['LABEL']);
					}
				}

				$this->clearserviceinfos();
				header("location: index.php?page=liste");
				exit;
			}
			else
			{
				$this->query("select ID from `".$_SESSION['tablename']['services']."` where ID = '".$_SESSION['m_admin']['services']['ID']."'");
				
				if($this->nb_result() > 0)
				{
					$_SESSION['error'] = _THE_DEPARTMENT.' '.$_SESSION['m_admin']['services']['ID'].' '._ALREADY_EXISTS;
					header("location: index.php?page=service_add&show=false");
					exit;
				}
				else
				{
					require("class_history.php");
					$users = new history();
					
				 if( $_REQUEST['mode'] == "add")
				 {
				 	$this->query("INSERT INTO `".$_SESSION['tablename']['services']."` ( `ID` , `SERVICE`,`ENABLED`  ) VALUES ('".$_SESSION['m_admin']['services']['ID']."', '".$_SESSION['m_admin']['services']['LABEL']."','Y')");
					if($_SESSION['history']['servicesadd'] == "true")
					{
						$users->add($_SESSION['tablename']['services'], $_SESSION['m_admin']['services']['ID'],"ADD", _DEPARTMENT_ADDED." : ".$_SESSION['m_admin']['services']['LABEL']);
				 	}
				 }
				
				 
				$this->query("Delete from ".$_SESSION['tablename']['listmodel']." where RES_TABLE ='res_x' and ID = '".$_SESSION['m_admin']['services']['ID']."'");
				
				for($i=0; $i < count($_SESSION['m_admin']['services']['listmodel']);$i++)
				{
					$seq = $i+1;
					$this->query("insert into ".$_SESSION['tablename']['listmodel']." ( RES_TABLE , ID, SEQUENCE, USER_ID  ) VALUES ('res_x', '".$_SESSION['m_admin']['services']['ID']."', ".$seq.", '".$_SESSION['m_admin']['services']['listmodel'][ $i]['USER_ID']."')");
				}
					$_SESSION['error'] = _DEPARTMENT_ADDED;
					
					
				}
				
				$_SESSION['error'] = "";
			}
			
			if ($_REQUEST['mode'] == "add")
			{
				$url = "index.php?page=liste";
			}
			
			$this->clearserviceinfos();
			header("location: ".$url);
			exit;
		}
	}
	
	/**
	* List of the mail in copy 
	*
	* @param  array  $listarr contains the document index of the mail in copy 
	* @param int  $nb_total  number of document
	* @param string  $title  title
	* @param string  $name  page name
	*/
	public function list_copy_mail($listarr, $nb_total, $title,$name )
	{
		$page_list1 = "";
		$page_list2 = "";

		$func = new functions();
		
		if(isset($_REQUEST['start']))
		{
			$start = strip_tags($_REQUEST['start']);
		}
		else
		{
			$start = 0;
		}
		
		if(isset($_GET['order']))
		{
			$orderby = strip_tags($_GET['order']);
		}
		else
		{
			$orderby = 0;
		}
		
		
			$link = "index.php?page=".$name;
			
		
		// define the defaults values
		$nb_show = $_SESSION['config']['nblinetoshow'];
		$nb_pages = ceil($nb_total/$nb_show);
		
		// if they are more 1 page we do pagination with 2 forms
		if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form action="" name="newpage1" id="newpage1" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage1.startpage.value;">';
			
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($start == $next_start)
				{	
					$page_list1 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
					}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
						}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($start > 0)
			{
				$start_prev = $start - $nb_show;
				$previous = "&lt; <a href=\"".$link."&amp;start=".$start_prev."&amp;order=".$orderby."\"&gt;"._PREVIOUS."</a> ";
			}
			
			if($start <> $lastpage)
			{
				$start_next = $start + $nb_show;
				$next = " <a href=\"".$link."&amp;start=".$start_next."&amp;order=".$orderby."\">"._NEXT."</a> >";
			}
			
			$page_list1 = $page_list1."</select>".$previous." ".$next."</p></form>";
			
		}
		?>
<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_search_b.gif" alt="" /> <? echo $title; ?></h1>
	<div id="inner_content" class="clearfix">
	<?php echo $page_list1;?>


			<form name="choose_mail" id="choose_mail" method="post" action="index.php?page=copy_mail">	
             <input type="hidden" name="start" id="start" value="<? echo $start;?>" />
             	<table cellpadding="0" cellspacing="0" border="0" class="listing">
	<thead>				
				<tr>
                    <th class="picto"><?php echo _STATUS; ?><br/><br/>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=statdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=statasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
                      <th ><?php echo _PRIORITY; ?><br/><br/>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=priodesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=prioasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
                      <th class="date"><?php echo _DATE_START; ?>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=datedesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=dateasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
					 <th class="price"><? echo _GED_NUM;?><br/><br/>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=residdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>" /></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=residasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
					<th class="emetteur"><?php echo _SHIPPER; ?><br/><br/>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=autdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=auttasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
                      <th>
					  <? if($_SESSION['config']['corporate'] == "true")
					  {  echo _SOCIETY; ?><br/><br/>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=socidesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=sociasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a>
                      <? } 
					  else
					  {
					   echo _OBJECT; ?><br/><br/>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=objdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=objasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a><?
					  }?>
                      </th>
					<th><?php echo _RECIPIENT; ?><br/><br/>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=destdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'&amp;start='.$start.'&amp;order=destasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
	  				<th class="picto">&nbsp;</th>
					
					 
				</tr>
				</thead>
		<? if(count($listarr) > 0)
		{
        	echo '<tbody>';
		}		
?>
		<?php		
		$color  = 'class="col"';
		for($theline = 0; $theline < count($listarr) ; $theline++)
		{
			// background color
			if($color == 'class="col"')
			{
			
				$color = "";
			}
			else
			{
				$color = 'class="col"';
			
			}
				?>
			<tr <?php echo $color; ?> >
            		
                    <td class="picto"  onmouseover="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('view.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=yes, width=1020, height=780');">
                    <? 	if(($listarr[$theline]['STATUS'] == "NEW"))
					{ ?>
					<img src="<? echo $_SESSION['config']['img'];?>/mail_new.gif" alt="<? echo _TO_PROCESS;?>" title="<? echo _TO_PROCESS;?>" />
					<?
					}
					elseif(($listarr[$theline]['STATUS'] == "COU"))
					{ ?>
					<img src="<? echo $_SESSION['config']['img'];?>/mail.gif" alt="<? echo _IN_PROGRESS;?>" title="<? echo _IN_PROGRESS;?>" />
					<?					
					}
					elseif(($listarr[$theline]['STATUS'] == "END"))
					{ ?>
					<img src="<? echo $_SESSION['config']['img'];?>/mail_end.gif" alt="<? echo _CLOSED;?>" title="<? echo _CLOSED;?>" />
					<?					
					}
					elseif(($listarr[$theline]['STATUS'] == "OUT"))
					{ ?>
					<img src="<? echo $_SESSION['config']['img'];?>/status_out.gif" alt="<? echo _ONGOING;?>" title="<? echo _ONGOING;?>"/>
					<?					
					}
					
					?>
				 </td>
                   <td   onmouseover="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('view.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=yes, width=1020, height=780');">
                    <? 	if(($listarr[$theline]['PRIORITY'] == 1))
					{ ?>
					<!--<img src="<? echo $_SESSION['config']['img'];?>/mail_new.gif" alt="<? echo _TO_PROCESS;?>" title="<? echo _TO_PROCESS;?>" />--><? echo _HIGH;?>
					<?
					}
					elseif(($listarr[$theline]['PRIORITY'] == 2))
					{ ?>
					<!--<img src="<? echo $_SESSION['config']['img'];?>/mail.gif" alt="<? echo _IN_PROGRESS;?>" title="<? echo _IN_PROGRESS;?>" />--><? echo _NORMAL;?>
					<?					
					}
					elseif(($listarr[$theline]['PRIORITY'] == 3))
					{ ?>
					<!--<img src="<? echo $_SESSION['config']['img'];?>/mail_end.gif" alt="<? echo _CLOSED;?>" title="<? echo _CLOSED;?>" />--><? echo _LOW;?>
					<?					
					}
					
					?>
				 </td>
                  <td class="date"  onmouseover="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('view.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><?php  if(			$listarr[$theline]['STATUS'] == "OUT")
					 {
						 echo $this->dateformat($listarr[$theline]['CREATION_DATE']);
					 }
					 else
					 {
					 	if("0000-00-00" == $listarr[$theline]['ARRIVEE'] || "00-00-0000" == $listarr[$theline]['ARRIVEE'])
						{
							
							echo $this->dateformat($listarr[$theline]['CREATION_DATE']);
						}
						else
						{
							
					 		echo $this->dateformat($listarr[$theline]['ARRIVEE']);
						}
					}?></td>
					 <td class="price" onMouseOver="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('view.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><?php echo $func->show($listarr[$theline]['ID']); ?></td>
				 	 <td class="emetteur"  onmouseover="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('view.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><?php echo $func->show($listarr[$theline]['NOM']); ?></td>
                       	<td  onmouseover="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('view.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><?php echo $func->show($listarr[$theline]['OBJET']); ?></td>
					 <td  onmouseover="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('view.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=yes, width=1020, height=780');"><?php echo $func->show($listarr[$theline]['DEST']); ?></td>
					
			<td class="picto"><a href="index.php?page=details&amp;id=<? echo $listarr[$theline]['ID']; ?>"><img src="<? echo $_SESSION['config']['img'];?>/picto_infos.gif"  alt=" <? echo _DETAILS; ?>"/></a></td>		
				 
                    
				  	

			</tr>
		<?php
			}
			if(count($listarr) > 0)
		{
        	echo '</tbody>';
		}		

			   	echo "</table></form>";
		        echo "</div>";
	}
	
	/**
	* List of the mail in the autorized departments
	*
	* @param  array  $listarr contains the document index 
	* @param int  $nb_total  number of document
	* @param string  $title  title
	* @param string  $name  page name
	*/
	public function dep_mail_list($listarr, $nb_total, $title, $service, $status )
	{
		$page_list1 = "";
		$page_list2 = "";

		$func = new functions();
		
		if(isset($_REQUEST['start']))
		{
			$start = strip_tags($_REQUEST['start']);
		}
		else
		{
			$start = 0;
		}
		
		if(isset($_GET['order']))
		{
			$orderby = strip_tags($_GET['order']);
		}
		else
		{
			$orderby = 0;
		}
		
		
			$link = "dep_result.php";
			
		
		// define the defaults values
		$nb_show = $_SESSION['config']['nblinetoshow'];
		$nb_pages = ceil($nb_total/$nb_show);
		
		// if they are more 1 page we do pagination with 2 forms
		if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form action="" name="newpage1" id="newpage1" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'?order='.$orderby.'&amp;start=\'+document.newpage1.startpage.value;">';
			$page_list2 = '<form action="" name="newpage2" id="newpage2" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'?order='.$orderby.'&amp;start=\'+document.newpage2.startpage.value;">';
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($start == $next_start)
				{	
					$page_list1 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
				}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\">".$the_line."</option>";
				}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($start > 0)
			{
				$start_prev = $start - $nb_show;
				$previous = "< <a href=\"".$link."?start=".$start_prev."&order=".$orderby."\">"._PREVIOUS."</a> ";
			}
			
			if($start <> $lastpage)
			{
				$start_next = $start + $nb_show;
				$next = " <a href=\"".$link."?start=".$start_next."&order=".$orderby."\">"._NEXT."</a> >";
			}
			
			$page_list1 = $page_list1."</select>".$previous." ".$next."</p></form>";
			$page_list2 = $page_list2."</select>".$previous." ".$next."</p></form>";
			
		}
		?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<? echo $_SESSION['config']['lang'] ?>" lang="<? echo $_SESSION['config']['lang'] ?>">
<head>
	<title><?php echo $_SESSION['config']['applicationname']; ?></title>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<meta http-equiv="Content-Language" content="<? echo $_SESSION['config']['lang'] ?>" />
	<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['config']['css']; ?>" media="screen" />
	<!--[if lt IE 7.0]>  <link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['config']['css_IE']; ?>" media="screen" />  <![endif]-->
	<!--[if gte IE 7.0]>  <link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['config']['css_IE7']; ?>" media="screen" />  <![endif]-->
	<script type="text/javascript" src="js/functions.js"></script>
</head>
<body id="mes_services">
<br/>
<div class="error"><? echo $_SESSION['error']; $_SESSION['error'] = ""; ?></div>
<h2 class="title"><? echo $title; ?></h2>
	<div>
	<?php echo $page_list1;?>
	<form name="choose_mail" id="choose_mail" method="post" action="manage_redirection.php?frame=dep_result">
    <input type="hidden" name="start" id="start" value="<? echo $start;?>" />
<table cellpadding="0" cellspacing="0" border="0" class="listing" >
	<thead>				
				<tr>
					  <? if(!$_SESSION['current_basket']['no_action']){ ?><th class="picto">&nbsp;</th><? }?>
					 <th ><? echo _GED_NUM;?>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=residdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>" /></a>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=residasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
					 <th ><? echo _PRIORITY;?>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=priodesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>" /></a>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=prioasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
                    <th ><?php echo _SHIPPER; ?>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=expdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=expasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
                      <th class="type"><?php 
					  if($_SESSION['config']['corporate'] == "true")
					  {
					  	echo _SOCIETY; ?>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=socidesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=sociasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a>
                      <? }
					  else
					  {
					  echo _OBJECT; ?>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=objdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=objasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a><?
					  }?>
                      </th>
					<th><?php echo _RECIPIENT; ?>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=destdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=destasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
	  				<th><?php echo _LIMIT_DATE_PROCESS; ?>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=limdesc'; ?>" title="<? echo _DESC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif" alt="<? echo _DESC_SORT; ?>"/></a>
					  <a href="<?php echo $link.'?start='.$start.'&amp;service='.$service.'&amp;status='.$status.'&amp;order=limasc'; ?>" title="<? echo _ASC_SORT; ?>"><img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" alt="<? echo _ASC_SORT; ?>" /></a></th>
                      <th class="picto">&nbsp;</th>
				</tr>
				</thead>
			<tbody>
				

		<?php		
		$color  = 'class="col"';
		for($theline = 0; $theline < count($listarr) ; $theline++)
		{
			// background color
			if($color == 'class="col"')
			{
			
				$color = "";
			}
			else
			{
				$color = 'class="col"';
			
			}
				?>
			<tr <?php echo $color; ?> >
            	<? if(!$_SESSION['current_basket']['no_action']){ ?><td class="picto"><input type="checkbox" name="mail[]" value="<?php echo $listarr[$theline]['ID']; ?>" /></td><? } ?>
					 <td class="price" onMouseOver="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('show_folder_doc.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=no, width=1020, height=780');"><?php echo $func->show($listarr[$theline]['ID']); ?></td>
                     <td class="price" onMouseOver="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('show_folder_doc.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=no, width=1020, height=780');">
					 <? if($listarr[$theline]['PRIORITY'] == 1)
					 {
					 	echo _HIGH;
					 }
					 elseif($listarr[$theline]['PRIORITY'] == 2)
					 {
					 	echo _NORMAL;
					 }
					 else
					 {
					 	echo _LOW;
					 }
					 ?>
                     </td>
				 	 <td onMouseOver="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('show_folder_doc.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=no, width=1020, height=780');"><?php echo $func->show($listarr[$theline]['NOM']); ?></td>
                      <td class="type" onMouseOver="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('show_folder_doc.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=no, width=1020, height=780');"><?php if($_SESSION['config']['corporate'] == "true"){echo  $func->show($listarr[$theline]['SOCIETE']);}else{echo $func->show($listarr[$theline]['OBJET']);} ?></td>
					 <td onMouseOver="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('show_folder_doc.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=no, width=1020, height=780');"><?php echo $func->show($listarr[$theline]['DEST']); ?></td>
					
					 <td onMouseOver="javascript:changeCouleur2(this,'#000000',true);" onMouseOut="javascript:changeCouleur2(this,'#666',false);" onClick="javascript:changeCouleur2(this,'#CC3300',true);window.open('show_folder_doc.php?id=<? echo $listarr[$theline]['ID']; ?>','', 'scrollbars=yes, resizable=no, width=1020, height=780');"><?php echo $this->dateformat($listarr[$theline]['LIMITE']); ?></td>
				  <td class="picto"><a href="javascript://" onClick="javascript:window.parent.location='index.php?page=details&amp;id=<? echo $listarr[$theline]['ID'] ;?>';"><img src="<? echo $_SESSION['config']['img'];?>/picto_infos.gif"  alt=" <? echo _DETAILS; ?>"/></a></td>
			</tr>
		<?php
			}
			   ?></tbody></table>
                <p><em><? echo _CLICK_LINE_VIEW;?></em> </p>
          <br/>
          <? if(!$_SESSION['current_basket']['no_action'])
		  {
		  ?>
          <div>
          	<p>
            	<label><? echo _CHOOSE_ACTION;?> : </label>
                
                <select name="action" id="action">
  
                <? if($_SESSION['current_basket']['can_redirect'] == 'Y' )
				{
					?>
                    <option value="RED"><? echo _REDIRECTION;?></option>
                    <?
				}
				if($_SESSION['current_basket']['can_delete'] == true)
				{
				?>
                <option value="DEL"><? echo _DELETION;?></option>
                <?
				}
				?>
                </select>
                <input type="submit" name="valid" id="valid" value="<? echo _VALIDATE;?>" class="button" />
            </p>
          </div>
          <? } ?>
               </form>		
		        </div>
                </body>
                </html>
                <?
	}
	
	/**
	* Alphabetical list of the models
	*
	* @param string  $page  page name
	*/
	public function modelslistletters($page = "models")
	{
		// List all the alphabet letter to view the doc types who are starting with the letter
		if(isset($_GET['show']))
		{
			if($_GET['show'] == "false")
			{
				$show = "&show=false";
			}
			else
			{
				$show = "";
			}
		}
		else
		{
			$show = "";
		}
		?>
		<form action="index.php" method="get" name="frmletters" id="frmletters">
			<fieldset>
				<p>
					<input name="what" type="text" class="textbox medium" value="" />
					<input name="Submit" type="submit" value="<?php echo _SEARCH; ?>" class="button" />
					<input name="page" type="hidden" value="<?php echo $page; ?>" />
					<?php if($show == "&show=false") { ?><input name="show" type="hidden" value="false" /><? } ?>
				</p>
			</fieldset>
				<p><strong><?php echo _ALPHABETICAL_LIST; ?></strong> : 
		
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=A">A</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=B">B</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=C">C</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=D">D</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=E">E</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=F">F</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=G">G</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=H">H</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=I">I</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=J">J</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=K">K</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=L">L</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=M">M</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=N">N</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=O">O</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=P">P</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Q">Q</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=R">R</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=S">S</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=T">T</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=U">U</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=V">V</a> 
				<a href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=W">W</a> 
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=X">X</a>
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Y">Y</a>
				<a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>&amp;what=Z">Z</a>
				- <a  href="index.php?page=<?php echo $page; ?><?php echo $show; ?>"><? echo _ALL_DEPARTMENTS;?></a>
			
			</p>
	
				</form>

		<?php
	}
	
	/**
	* List of models
	*
	* @param string  $where $where clause
	* @param string  $what sort info
	*/
	public function modelslist($where = "",$what = "")
	{
		// draw the models list
		$func = new functions();
		
		/* Configuration */
		$title = _MODELS_LIST;
		$page_name = "models";
		$table_name = $_SESSION['tablename']['models'];
		$res_table = "res_x";
		$nb_show = $_SESSION['config']['nblinetoshow'];
		
		
		if(!empty($what))
		{
			$what = "&what=".$what;
		}
		
		if(!empty($where))
		{
			$where = " where ".$where;
		}
		/***********************/
		
		$this->connect();
		$this->query("select count(*) as total from ".$table_name." ".$where);
		$nb_total_1 = $this->fetch_object();
		$nb_total = $nb_total_1->total;
		
		// define the defaults values
		$nb_pages = ceil($nb_total/$nb_show);
		
		$link = "index.php?page=".$page_name."&start=".$this->the_start."&order=".$this->orderby.$what;
		
		if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form name="newpage1" id="newpage1" method="get" action="index.php?page=groups" >
			<p>
				<label for="startpage">'._GO_TO_PAGE.'</label>
				<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;start=\'+document.newpage1.startpage.value;">';
			
			$page_list2 = '<form name="newpage2" id="newpage2" method="get" action="index.php?page=groups"  >
			<p>
				<label for="startpage">'._GO_TO_PAGE.'</label>
				<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;start=\'+document.newpage2.startpage.value;">';
			
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($this->the_start == $next_start)
				{
					$page_list1 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\" selected=\"selected\">".$the_line."</option>";
				}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\">".$the_line."</option>";
				}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($this->the_start > 0)
			{
				$start_prev = $this->the_start - $nb_show;
				$previous = '<a href="'.$link.'&amp;start='.$start_prev.'" class="prev">'._PREVIOUS.'</a>';
			}
			
			if($this->the_start <> $lastpage)
			{
				$start_next = $this->the_start + $nb_show;
				$next = '<a href="'.$link.'&amp;start='.$start_next.'" class="next">'._NEXT.'</a>';
			}
			
			$page_list1 = $page_list1."</select>";
			$page_list2 = $page_list2."</select>";
				
			if($previous <> '' || $next <> '')
			{
				if(empty($previous)) { $previous = "&nbsp;"; }
				if(empty($next)) { $next = "&nbsp;"; }
				
				$page_list1 .= $previous." ".$next.'</p></form>';
				$page_list2 .= $previous." ".$next.'</p></form>';
			}
		}
		
		$this->query("select distinct ID from ".$table_name." ".$where." order by ID asc limit ".$this->the_start.",".$nb_show);
			
			echo '<h1><img src="'.$_SESSION['config']['img'].'/picto_types_b.gif" alt="" /> '.$title.'</h1>
		
			<div id="inner_content" class="clearfix">';
			
		$this->modelslistletters();
		 echo $page_list1; 
		?>
		<table cellpadding="0" cellspacing="0" border="0" class="listing spec">
				<thead>
					<tr>
						<th class="id"><? echo _ID.' '._MODEL;?></th>
						<th class="title"><? echo _DESC;?> </th>
                      
				   		<th colspan="3" align="right" class="price"><span class="add clearfix"><a  href="index.php?page=model_add"  ><span><? echo _ADD_MODEL;?></span></a></span></th>
				  </tr>
				</thead>
				<tfoot>
					<tr>
						<td colspan="7" class="price"><span class="add clearfix"><a  href="index.php?page=model_add"  ><span><? echo _ADD_MODEL;?></span></a></span></td>
					</tr>
				</tfoot>
				<tbody>
		
		<?php
		$db = new dbquery();
		$db->connect();
		
		$color = "line1";
		while($line = $this->fetch_object())
		{
			if($color == ' class="col"')
			{
				$color = '';
			}
			else
			{
				$color = ' class="col"';
			}
			$db->query("select ID, LABEL, COMMENT from ".$table_name." where ID ='".$line->ID."'"); 		
			$desc = "";
			$line2 = $db->fetch_object();
			$desc = $line2->LABEL;
			$comment = $line2->COMMENT;
			?>
			<tr <?php echo $color; ?>>
				<td class="id"><strong><?php echo $line->ID; ?></strong></td>
				<td class="descr"><?php echo $desc ?></td>
				
				<td class="action">
                <a href="index.php?page=model_up&amp;id=<? echo $line->ID;?>" class="change"  ><?php echo _MODIFY; ?></a>
                </td>
				<td class="action">
               
					<a href="model_del.php?id=<? echo $line->ID;?>" class="delete" onClick="return(confirm('<? echo ' '._REALLY_DELETE.' '.$line2->LABEL.' ('.$line->ID.') ?\n'._DEFINITIVE_ACTION."!";?>'));" ><? echo _DELETE;?></a>
				</td>	
			</tr>
				<?php
			}
			?>
			</tbody>
		</table>
		</div>

		<?php	
		$this->clearmodelinfos();
		$_SESSION['services'] = array();
		$this->query("select ID, SERVICE from ".$_SESSION['tablename']['services']." where ENABLED = 'Y'");
		
		while($line = $this->fetch_object())
		{
			array_push($_SESSION['services'], array("ID"=>$line->ID, "LABEL" => $line->SERVICE)); 
		}
		$_SESSION['chosen_services'] = array();
	}
	
	/**
	* Clear the session variables of the model administration
	*
	*/
	private function clearmodelinfos()
	{
		// clear the session variable for the models
		$_SESSION['m_admin']['model'] = array();
		$_SESSION['m_admin']['model']['ID'] = "";
		$_SESSION['m_admin']['model']['LABEL'] = "";
		$_SESSION['m_admin']['model']['COMMENT'] = "";
		$_SESSION['m_admin']['model']['DATE'] = "";
		$_SESSION['m_admin']['model']['CONTENT'] = "";
		$_SESSION['m_admin']['model']['SERVICES'] = array();
	
	}
	
	/**
	* Form to add or modify a model
	*
	* @param string  $mode  up or add
	* @param string  $id  identifier of the model to modify
	*/
	public function formmodel($mode,$id = "")
	{
		$func = new functions();
		
		$state = true;
		
		if(!isset($_SESSION['m_admin']['model']))
		{
			$this->clearmodelinfos();
		}
		
		if( $mode <> "add" && empty($_SESSION['error']))
		{
			$this->connect();
			$this->query("select * from ".$_SESSION['tablename']['models']." where ID = '".$id."'");
			
			if($this->nb_result() == 0)
			{
				$_SESSION['error'] = _MODEL.' '._UNKNOWN;
				$state = false;
			}
			else
			{
				$_SESSION['m_admin']['model'] = array();
				$line = $this->fetch_object();
				
				$_SESSION['m_admin']['model']['ID'] = $line->ID;
				$_SESSION['m_admin']['model']['LABEL'] = trim($line->LABEL);
				$_SESSION['m_admin']['model']['COMMENT'] = trim($line->COMMENT);
				$_SESSION['m_admin']['model']['DATE'] = $line->CREATION_DATE;
				$_SESSION['m_admin']['model']['CONTENT'] = stripslashes($line->CONTENT);
				
				//$_SESSION['m_admin']['model']['CONTENT'] = str_replace("\'", "'",$line->CONTENT);
				//$_SESSION['m_admin']['model']['CONTENT'] = str_replace('\"', '"' ,$line->CONTENT);
				//$_SESSION['m_admin']['model']['CONTENT'] = $line->CONTENT;
				
				$_SESSION['m_admin']['model']['SERVICES'] = array();
				$this->query("select s.ID, s.SERVICE from ".$_SESSION['tablename']['model_service']." ms, ".$_SESSION['tablename']['services']." s where ms.ID_MODEL = ".$_SESSION['m_admin']['model']['ID']." and s.ID = ms.ID_SERVICE");
				//$this->show();
				while($res = $this->fetch_object())
				{
					array_push($_SESSION['m_admin']['model']['SERVICES'] , array('ID' =>$res->ID, 'LABEL' => $res->SERVICE));
				}
	
			}
		}
		?>
		<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_add_b.gif" alt="" /> 
				<?php
				if($mode == "up")
				{
					echo _MODEL_MODIFICATION;
				}
				elseif($mode == "add")
				{
					echo _MODEL_ADDITION;
				}
				?>
				</h1>
				
		
		<div id="inner_content" class="clearfix">
		
			
			<?php
			if($state == false)
			{
			?>
            	<script language="javascript" type="text/javascript">window.document.location.href = 'index.php?page=models';</script>
            <?
			}
			else
			{
				?>
			
				<form name="frmmodel" id="frmmodel" method="post" action="model_up_db.php" class="forms">
				<input type="hidden" name="mode" id="mode" value="<? echo $mode;?>" />		
						<? if($mode == "up")
						{
						?>
							<input  type="hidden" name="model_id" id="model_id" value="<?php echo $_SESSION['m_admin']['model']['ID']; ?>"/>
						<?php
						}?>
                        <p>
                        	<label><? echo _MODEL_NAME;?> :</label>
                            <input type="text" name="model_name" id="model_name" value="<? echo $_SESSION['m_admin']['model']['LABEL'];?>"/><span class="red_asterisk">*</span>
                        </p>
                        <p>
                        	<label><? echo _COMMENTS;?> :</label>
                             <textarea name="model_comment" id="model_comment" rows="3" cols="15" ><? echo $_SESSION['m_admin']['model']['COMMENT'];?></textarea>
                        </p>
                        <p>	
                        <textarea name="model_content" style="width:100%" rows="15" cols="60"><? echo $_SESSION['m_admin']['model']['CONTENT'];?></textarea>
                        </p>
                        <div align="center">
                        	<iframe align="middle" name="associated_services" id="associated_services" src="associated_services.php" frameborder="0" height="180px" width="500px;"></iframe>
                        </div>
						<p class="buttons">
									<?php
						
					/*	if($mode == "up")
						{
						?>
							<input class="button" type="submit" name="Submit" value="<?php echo _MODIFY_DEPARTMENT; ?>"  />
						<?php
						}
					
						elseif($mode == "add")
						{
						?>
							<input type="submit" class="button"  name="Submit" value="<?php echo _ADD_MODEL; ?>" />
						<?
						}*/
						?>
                        <input type="submit" class="button"  name="Submit" value="<?php echo _VALIDATE; ?>" />
                        <input type="button" onClick="javascript:window.location.href='index.php?page=models';" class="button"  name="cancel" value="<?php echo _CANCEL; ?>" />
								</p>
                                
					</form >
			
			<?php
			}
			?>
	
		</div>
	<?php
	}
	
	/**
	* Verify the model informations
	*
	*/
	private function modelinfo()
	{		
		$func = new functions();
		
		if(!isset($_REQUEST['mode']))
		{
			$_SESSION['error'] = _UNKNOWN_PARAM."<br />";
		}
		$allowedTags='<p><strong><em><u><h1><h2><h3><h4><h5><h6><img>';
 		$allowedTags.='<li><ol><ul><span><div><br><ins><del><blockquote><font><strike><table><tr><td><th><tbody><thead><tfooter><caption>';

  		if($_REQUEST['model_content']!='')
		{
  		  $_SESSION['m_admin']['model']['CONTENT'] = strip_tags(addslashes(trim($_REQUEST['model_content'])),$allowedTags);
  		} 
		else
		{
		 $_SESSION['m_admin']['model']['CONTENT'] = '';
			//$_SESSION['error'] .= _MODEL_EMPTY.".<br/>";
		}
		$_SESSION['m_admin']['model']['LABEL'] = $func->wash($_REQUEST['model_name'], "no", _THE_WORDING);
		$_SESSION['m_admin']['model']['LABEL'] = trim(stripslashes($_SESSION['m_admin']['model']['LABEL']));
		
		$_SESSION['m_admin']['model']['COMMENT'] = "";
		if(!empty($_REQUEST['model_comment']) && isset($_REQUEST['model_comment']))
		{
			$_SESSION['m_admin']['model']['COMMENT'] = trim(stripslashes($_REQUEST['model_comment']));
		}
		if($_REQUEST['mode'] == "up")
		{
			$_SESSION['m_admin']['model']['ID'] = $func->wash($_REQUEST['model_id'], "no", _ID);
		}
		
		//if(count($_SESSION['m_admin']['model']['SERVICES']) < 1)
		//{
		//	$_SESSION['error'] .= _ATTACH_MODEL_TO_DEP.".<br/>";
		//}
		
	
	}
	
	/**
	* Update the database with the model data
	*
	*/
	public function upmodel()
	{
		$this->modelinfo();
		
		if(!empty($_SESSION['error']))
		{
			if($_REQUEST['mode'] == "up")
			{
				if(!empty($_SESSION['m_admin']['model']['ID']))
				{
					header("location: index.php?page=model_up&id=".$_SESSION['m_admin']['label']['ID']);
					exit;
				}
				else
				{
					header("location: index.php?page=models");
					exit;
				}
			}
			
			elseif($_REQUEST['mode'] == "add" )
			{
				header("location: index.php?page=model_add");
				exit;
			}
		}
		else
		{
			$this->connect();
			
			if( $_REQUEST['mode'] <> "add")
			{
				
				$this->query("update `".$_SESSION['tablename']['models']."` set LABEL = '".addslashes($_SESSION['m_admin']['model']['LABEL'])."' , COMMENT = '".addslashes($_SESSION['m_admin']['model']['COMMENT'])."', CONTENT = '".$_SESSION['m_admin']['model']['CONTENT']."' where ID = '".$_SESSION['m_admin']['model']['ID']."'");
					
				$this->query("Delete from ".$_SESSION['tablename']['model_service']." where ID_MODEL = '".$_SESSION['m_admin']['model']['ID']."'");
				
				for($i=0; $i < count($_SESSION['m_admin']['model']['SERVICES']);$i++)
				{
					$this->query("insert into ".$_SESSION['tablename']['model_service']." ( ID_SERVICE, ID_MODEL  ) VALUES ( '".$_SESSION['m_admin']['model']['SERVICES'][$i]['ID']."', ".$_SESSION['m_admin']['model']['ID'].")");
				}
				
				if($_REQUEST['mode'] == "up")
				{
					$_SESSION['error'] = _MODEL_MODIFICATION;
					if($_SESSION['history']['modelsup'] == "true")
					{
						require("class_history.php");
						$users = new history();
						$users->add($_SESSION['tablename']['models'], $_SESSION['m_admin']['model']['ID'],"UP",_MODEL_MODIFICATION." : ".$_SESSION['m_admin']['model']['LABEL']);
					}
				}

				$this->clearmodelinfos();
				header("location: index.php?page=models");
				exit;
			}
			else
			{
				$this->query("select LABEL from ".$_SESSION['tablename']['models']." where LABEL = '".addslashes($_SESSION['m_admin']['model']['LABEL'])."'");
				
				if($this->nb_result() > 0)
				{
					$_SESSION['error'] = _THE_MODEL.' '.$_SESSION['m_admin']['model']['LABEL'].' '._ALREADY_EXISTS;
					header("location: index.php?page=model_add");
					exit;
				}
				else
				{
					require("class_history.php");
					$users = new history();
					
				 if( $_REQUEST['mode'] == "add")
				 {
				 	$this->query("INSERT INTO ".$_SESSION['tablename']['models']." ( LABEL, CREATION_DATE, COMMENT, CONTENT  ) VALUES ( '".addslashes($_SESSION['m_admin']['model']['LABEL'])."', now(),'".addslashes($_SESSION['m_admin']['model']['COMMENT'])."', '".$_SESSION['m_admin']['model']['CONTENT']."')");
					$this->query("select ID from ".$_SESSION['tablename']['models']." where LABEL = '".addslashes($_SESSION['m_admin']['model']['LABEL'])."' and COMMENT = '".addslashes($_SESSION['m_admin']['model']['COMMENT'])."' and CONTENT = '".$_SESSION['m_admin']['model']['CONTENT']."'");
					$res = $this->fetch_object();
					$_SESSION['m_admin']['model']['ID'] = $res->ID;
					
					if($_SESSION['history']['modelsadd'] == "true")
					{
						$users->add($_SESSION['tablename']['models'], $_SESSION['m_admin']['model']['ID'],"ADD", _MODEL_ADDED." : ".$_SESSION['m_admin']['model']['LABEL']);
				 	}
				 }
				
				 
			//	$this->query("Delete from ".$_SESSION['tablename']['model_service']." where ID = ".$_SESSION['m_admin']['model']['ID']);
				
				for($i=0; $i < count($_SESSION['m_admin']['model']['SERVICES']);$i++)
				{
					$this->query("insert into ".$_SESSION['tablename']['model_service']." (ID_MODEL, ID_SERVICE  ) VALUES (".$_SESSION['m_admin']['model']['ID'].", '".$_SESSION['m_admin']['model']['SERVICES'][$i]['ID']."' )");
				}
					$_SESSION['error'] = _MODEL_ADDED;
					
					
				}
				
				$_SESSION['error'] = "";
			}
			
			if ($_REQUEST['mode'] == "add")
			{
				$url = "index.php?page=models";
			}
			
			$this->clearmodelinfos();
			header("location: ".$url);
			exit;
		}
	}
	
	/**
	* replace the defined fields in the instance of the model
	*
	* @param string  $content model content
	*/
	public function fields_replace($content)
	{
		$content = str_replace("[CIV_EMETTEUR]",  $_SESSION['courrier']['civ'], $content);
		$content = str_replace("[NOM_EMETTEUR]",  $_SESSION['courrier']['author'], $content);
		$content = str_replace("[PRENOM_EMETTEUR]",  $_SESSION['courrier']['prenom'], $content);
		$content = str_replace("[SOCIETE_EMETTEUR]", $_SESSION['courrier']['societe'], $content);
		$content = str_replace("[OBJET]",  $_SESSION['courrier']['description'], $content);
		$content = str_replace("[TYPE]",  $_SESSION['courrier']['type_id'], $content);
		$content = str_replace("[DATE_LIM]",  $_SESSION['courrier']['date_limite'], $content);
		$content = str_replace("[DATE_ARRIVEE]",  $_SESSION['courrier']['date_arrivee'], $content);
		$content = str_replace("[NATURE]",  $_SESSION['courrier']['nature'], $content);
		
		$this->query("select SERVICE from ".$_SESSION['tablename']['services']." where ID = '".$_SESSION['courrier']['service']."'");
		$res = $this->fetch_object();
		$content = str_replace("[SERVICE]",  $res->SERVICE, $content);
		
		$content = str_replace("[NEW_EMETTEUR]",  $_SESSION['user']['FirstName'].' '.$_SESSION['user']['LastName'], $content);
		$content = str_replace("[PHONE_EMETTEUR]",  $_SESSION['user']['Phone'], $content);
		$content = str_replace("[MAIL_EMETTEUR]",  $_SESSION['user']['Mail'], $content);
		$content = str_replace("[DEP_EMETTEUR]",  $_SESSION['user']['department'], $content);
		
		$content = str_replace("[REP_COURRIER_SIMPLE]",  $_SESSION['courrier']['rep_courrier_simple'], $content);
		$content = str_replace("[REP_DIRECT]",  $_SESSION['courrier']['rep_direct'], $content);
		$content = str_replace("[REP_MAIL]",  $_SESSION['courrier']['rep_mail'], $content);
		$content = str_replace("[REP_AR]", $_SESSION['courrier']['rep_AR'], $content);
		$content = str_replace("[REP_FAX]",  $_SESSION['courrier']['rep_fax'], $content);
		$content = str_replace("[REP_AUTRE]",  $_SESSION['courrier']['rep_autre'], $content);
		$content = str_replace("[NOTES_TRAIT]", $_SESSION['courrier']['notes'], $content);
		
		$content = str_replace("[QUALITE]", $_SESSION['courrier']['qualite'], $content);
		$content = str_replace("[NUM_RUE]",  $_SESSION['courrier']['num_rue'], $content);
		$content = str_replace("[RUE]",  $_SESSION['courrier']['rue'], $content);
		$content = str_replace("[VILLE]", $_SESSION['courrier']['ville'], $content);
		$content = str_replace("[CODE_POSTAL]",  $_SESSION['courrier']['code'], $content);
		
		$content = str_replace("[DATE_TODAY]",  date("d-m-Y"), $content);
	
		return $content;
	}
	
	/**
	* delete a model in the database
	*
	* @param string $id model identifier
	*/
	public function delmodel($id)
	{
		if(!empty($_SESSION['error']))
		{
			header("location: index.php?page=models");
			exit;
		}
		else
		{
			$this->connect();
			
			$this->query("select ID, LABEL from ".$_SESSION['tablename']['models']." where ID = ".$id);
			
			if($this->nb_result() == 0)
			{
				$_SESSION['error'] = _MODEL.' '._UNKNOWN;
				header("location: index.php?page=models");
				exit;
			}
			else
			{
				$res = $this->fetch_object();
				$label = $res->LABEL;
				$this->query("delete from ".$_SESSION['tablename']['models']." where ID = ".$id);
				$this->query("delete from ".$_SESSION['tablename']['model_service']." where ID_MODEL = ".$id);
				
				if($_SESSION['history']['modelsdel'])
				{	
					require("class_history.php");
					$users = new history();
					$users->add($_SESSION['tablename']['models'], $id,"DEL",_MODEL_DELETION." : ".$label);
				}
					$_SESSION['error'] = _DELETED_MODEL;	
					header("location: index.php?page=models");
					exit;	
			}
		}
	}
	
	/**
	* delete a model in the database
	*
	* @param string $id model identifier
	*/
	public function delemet($id)
	{
		if(!empty($_SESSION['error']))
		{
			header("location: index.php?page=emet");
			exit;
		}
		else
		{
			$this->connect();
			
			$this->query("select ID from ".$_SESSION['tablename']['senders']." where ID = ".$id);
			
			if($this->nb_result() == 0)
			{
				$_SESSION['error'] = _SHIPPER.' '._UNKNOWN;
				header("location: index.php?page=emet");
				exit;
			}
			else
			{
				$res = $this->fetch_object();
				$label = $res->LABEL;
				$this->query("delete from ".$_SESSION['tablename']['senders']." where ID = ".$id);
				
					$_SESSION['error'] = _SHIPPER." ".strtolower(_DELETED);	
					header("location: index.php?page=emet");
					exit;	
			}
		}
	}
	
	
	/**
	* List of the out mail basket 
	*
	* @param  array  $listarr contains the document index of the out basket
	* @param int  $nb_total  number of document
	* @param string  $title  title
	* @param string  $name  page name
	*/
	public function mail_out($listarr, $nb_total, $title, $name)
	{
		
			$_SESSION['diff'] = array();
			$_SESSION['error'] = '';
		
		// show the document list in result of the search
		$page_list1 = "";
		$page_list2 = "";

		$func = new functions();
		
		if(isset($_REQUEST['start']))
		{
			$start = strip_tags($_REQUEST['start']);
		}
		else
		{
			$start = 0;
		}
		
		if(isset($_GET['order']))
		{
			$orderby = strip_tags($_GET['order']);
		}
		else
		{
			$orderby = 0;
		}
		
		
			$link = "index.php?page=".$name;
			
		
		// define the defaults values
		$nb_show = $_SESSION['config']['nblinetoshow'];
		$nb_pages = ceil($nb_total/$nb_show);
		
		// if they are more than 1 page we do pagination with 2 forms
			if($nb_pages > 1)
		{
			$next_start = 0;
			
			$page_list1 = '<form action="" name="newpage1" id="newpage1" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage1.startpage.value;">';
			$page_list2 = '<form action="" name="newpage2" id="newpage2" class="smallforms" method="get">
				<p>
					<label for="startpage">'._GO_TO_PAGE.'</label>
					<select name="startpage" id="startpage" class="textbox small" onchange="window.location.href=\''.$link.'&amp;order='.$orderby.'&amp;start=\'+document.newpage2.startpage.value;">';
			$lastpage = 0;
			
			for($i = 0;$i <> $nb_pages; $i++)
			{
				$page_name = $i + 1;
				
				$the_line = $i + 1;
				if($start == $next_start)
				{	
					$page_list1 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\" selected>".$the_line."</option>";
				}
				else
				{
					$page_list1 .= "<option value=\"".$next_start."\">".$the_line."</option>";
					$page_list2 .= "<option value=\"".$next_start."\">".$the_line."</option>";
				}
				
				$next_start = $next_start + $nb_show;
				$lastpage = $next_start;
			}
			
			$lastpage = $lastpage - $nb_show;
			
			$previous = "";
			$next = "";
			
			if($start > 0)
			{
				$start_prev = $start - $nb_show;
				$previous = "< <a href=\"".$link."&start=".$start_prev."&order=".$orderby."\">"._PREVIOUS."</a> ";
			}
			
			if($start <> $lastpage)
			{
				$start_next = $start + $nb_show;
				$next = " <a href=\"".$link."&start=".$start_next."&order=".$orderby."\">"._NEXT."</a> >";
			}
			
			$page_list1 = $page_list1."</select>".$previous." ".$next."</p></form>";
			$page_list2 = $page_list2."</select>".$previous." ".$next."</p></form>";
			
		}
		
		?>
		
			<h1><img src="<? echo $_SESSION['config']['img'];?>/picto_post_b.gif" alt="" /> <? echo $title; ?></h1>
				
				<div id="inner_content" class="clearfix">
					<?php echo $page_list1;?>
					<form name="choose_mail" id="choose_mail" method="post" action="manage_redirection.php">
                      <input type="hidden" name="start" id="start" value="<? echo $start;?>" />
					<table cellpadding="0" cellspacing="0" border="0" class="listing">
						<thead>
							<tr>
                            <? if(!$_SESSION['current_basket']['no_action']){ ?><th>&nbsp;</th><? }?>
								<th class="price"><? echo _GED_NUM;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=residasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
                                <th class="date"><? echo _MAIL_DATE;?> <a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=arrivasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>	
								</th>
								
							
								<th class="emetteur"><? echo _SHIPPER2;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=expasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>
								</th>
								<th ><?
								if($_SESSION['config']['corporate'] == "true")
								{ echo _SOCIETY;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=socidesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=sociasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>	
                                  <? }
								  else
								  {
								  echo _OBJECT;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=objasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>"/></a>
                                    <? } ?>
								</th>
								<th ><? echo _DEPARTMENT;?><br/><a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=servdesc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_down.gif"  border="0" alt="<? echo _DESC_SORT;?>" title="<? echo _DESC_SORT;?>"/></a> 
										<a href="<?php echo $link; ?>&amp;start=<?php echo $start; ?>&amp;order=servasc">
										<img src="<? echo $_SESSION['config']['img'];?>/tri_up.gif" border="0" alt="<? echo _ASC_SORT;?>" title="<? echo _ASC_SORT;?>" /></a>
								</th>
                                <th>&nbsp;</th>
                                <th>&nbsp;</th>
							</tr>
						</thead>
						<tbody>
		<?php		
		$color = "";
		for($theline = 0; $theline < count($listarr) ; $theline++)
		{
			if($color == ' class="col"')
			{
				$color = '';
			}
			else
			{
				$color = ' class="col"';
			}
			?>
		<tr <?php echo $color; ?>>
					  <? if(!$_SESSION['current_basket']['no_action']){ ?><td><input type="checkbox" name="mail[]" value="<?php echo $listarr[$theline]['ID']; ?>" /></td><? } ?>
                  <td class="price"  ><? echo $listarr[$theline]['ID']; ?></td>
				<td class="date" ><? echo $listarr[$theline]['ARRIVEE']; ?></td>
				
             	<td class="emetteur" ><? echo $listarr[$theline]['EMETTEUR']; ?></td>
				<td ><?php if($_SESSION['config']['corporate'])
				{
					echo $listarr[$theline]['SOCIETE']; 
				}
				else
				{
					echo $listarr[$theline]['OBJET']; 
				}?></td>
				<td ><?php echo $listarr[$theline]['SERVICE']; ?></td>
                <td class="picto"><a href="index.php?page=details&id=<? echo $listarr[$theline]['ID'] ;?>"><img src="<? echo $_SESSION['config']['img'];?>/picto_infos.gif"  alt=" <? echo _DETAILS; ?>"/></a> </td>
                <td class="picto"><? echo "<a href='view.php?id=".$listarr[$theline]['ID']."' target=\"_blank\">
				  		<img src='".$_SESSION['config']['img']."/picto_dld.gif'alt='"._SHOW_MAIL."' border='0'/></a>"; ?></td>
                      
		   </tr>
		   <?php
			}
			?>
		  </tbody>
		  </table> 
        
		 
          <br/>
          <? if(!$_SESSION['current_basket']['no_action'])
		  {
		  ?>
          <div>
          	<p>
            	<label><? echo _CHOOSE_ACTION;?> : </label>
                
                <select name="action" id="action">
  
                <? if($_SESSION['current_basket']['can_redirect'] == 'Y' )
				{
					?>
                    <option value="RED"><? echo _REDIRECTION;?></option>
                    <?
				}
				if($_SESSION['current_basket']['can_delete'] == true)
				{
				?>
                <option value="DEL"><? echo _DELETION;?></option>
                <?
				}
				?>
                </select>
                <input type="submit" name="valid" id="valid" value="<? echo _VALIDATE;?>" class="button" />
            </p>
          </div>
          <? } ?>
            </form>
	</div>
		
		<?
	}
	
	public function manage_list($res_id, $user_id)
	{
		$this->query("select * from ".$_SESSION['tablename']['listinstance']." where res_id = ".$res_id);
		
		if($this->nb_result() < 1)
		{
			$this->query("insert into ".$_SESSION['tablename']['listinstance']." values ('res_x', ".$res_id.", 1, '".$user_id."')");
			$this->show();
		}
		else
		{
			$this->query("update ".$_SESSION['tablename']['listinstance']." set user_id = '".$user_id."' where res_id = ".$res_id." and res_table = 'res_x' and sequence = 1");
			$this->show();
		}
		//exit();
	}
	
	/**
	* delete a note in the database
	*
	* @param string $id note identifier
	*/
	public function delnote($id, $resid)
	{
		if(!empty($_SESSION['error']))
		{
		?>
			<script language="javascript" type="text/javascript">
			window.parent.document.location = "index.php?page=details&id=<? echo $resid; ?> ";
			</script>
		<?
			exit;
		}
		else
		{
			$this->connect();
			
			$this->query("select ID from ".$_SESSION['tablename']['notes']." where ID = ".$id." and USER_ID = '".$_SESSION['user']['UserId']."'");
			
			if($this->nb_result() == 0)
			{
				$_SESSION['error'] = _CANT_DELETE_NOTE;
				header("location: index.php?page=details&id=".$resid);
				exit;
			}
			else
			{
				$res = $this->fetch_object();
				$label = $res->LABEL;
				$this->query("delete from ".$_SESSION['tablename']['notes']." where ID = ".$id);
				
				//Mise � jour de l'historique
				if($_SESSION['history']['notesdel'])
				{
					require_once("class_history.php");
					$hist = new history();
										
					$hist->add($_SESSION['tablechoice'], $resid ,"DEL", _DELETION_NOTE);
					
				}
							
				header("location: notes_courrier.php?id=".$resid);
				exit;	
			}
		}
	}
}
?>