<?php
/*
 * @version $Id: infocom.function.php 3798 2006-08-22 15:12:55Z moyo $
 -------------------------------------------------------------------------
 GLPI - Gestionnaire Libre de Parc Informatique
 Copyright (C) 2003-2006 by the INDEPNET Development Team.

 http://indepnet.net/   http://glpi-project.org
 -------------------------------------------------------------------------

 LICENSE

 This file is part of GLPI.

 GLPI is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 GLPI is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with GLPI; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 --------------------------------------------------------------------------
 */

// ----------------------------------------------------------------------
// Original Author of file: Julien Dombre
// Purpose of file:
// ----------------------------------------------------------------------



function showInfocomForm ($target,$device_type,$dev_ID,$show_immo=1,$withtemplate='') {
	// Show Infocom or blank form

	global $cfg_glpi,$lang,$HTMLRel;
	if (!haveRight("contract_infocom","r")) return false;
	$date_fiscale=$cfg_glpi["date_fiscale"];

	$ic = new Infocom;

	$option="";
	if ($withtemplate==2)
		$option=" readonly ";

	if (!ereg("infocoms-show",$_SERVER["PHP_SELF"])&&($device_type==SOFTWARE_TYPE||$device_type==CARTRIDGE_TYPE||$device_type==CONSUMABLE_TYPE)){
		echo "<div align='center'>".$lang["financial"][84]."</div>";
	}

	echo "<br>";
	if (!$ic->getfromDBforDevice($device_type,$dev_ID)){
		if (haveRight("contract_infocom","w")&&$withtemplate!=2){
			echo "<div align='center'>";
			echo "<b><a href='$target?device_type=$device_type&amp;FK_device=$dev_ID&amp;add=add'>".$lang["financial"][68]."</a></b><br>";
			echo "</div>";
		}
	} else {
		if ($withtemplate!=2)
			echo "<form name='form_ic' method='post' action=\"$target\">";

		echo "<div align='center'>";
		echo "<table class='tab_cadre".(!ereg("infocoms-show",$_SERVER["PHP_SELF"])?"_fixe":"")."'>";

		echo "<tr><th colspan='4'><b>".$lang["financial"][3]."</b></th></tr>";

		echo "<tr class='tab_bg_1'><td>".$lang["financial"][26].":		</td>";
		echo "<td align='center'>";
		if ($withtemplate==2) 
			echo getDropdownName("glpi_enterprises",$ic->fields["FK_enterprise"]);
		else dropdownValue("glpi_enterprises","FK_enterprise",$ic->fields["FK_enterprise"]);

		echo "</td>";
		echo "<td>".$lang["financial"][82].":		</td>";
		echo "<td >";
		autocompletionTextField("facture","glpi_infocoms","facture",$ic->fields["facture"],25,$option);	
		echo "</td></tr>";

		echo "<tr class='tab_bg_1'><td>".$lang["financial"][18].":		</td>";
		echo "<td >";
		autocompletionTextField("num_commande","glpi_infocoms","num_commande",$ic->fields["num_commande"],25,$option);	
		echo "</td>";

		echo "<td>".$lang["financial"][19].":		</td><td>";
		autocompletionTextField("bon_livraison","glpi_infocoms","bon_livraison",$ic->fields["bon_livraison"],25,$option);	
		echo "</td></tr>";

		echo "<tr class='tab_bg_1'><td>".$lang["financial"][14].":	</td><td>";
		showCalendarForm("form_ic","buy_date",$ic->fields["buy_date"],$withtemplate);	
		echo "</td>";


		echo "<td>".$lang["financial"][76].":	</td><td>";
		showCalendarForm("form_ic","use_date",$ic->fields["use_date"],$withtemplate);	
		echo "</td>";
		echo "</tr>";

		if ($show_immo==1){

			echo "<tr class='tab_bg_1'><td>".$lang["financial"][15].":	</td><td>";
			if ($withtemplate==2)
				echo $ic->fields["warranty_duration"];
			else dropdownContractTime("warranty_duration",$ic->fields["warranty_duration"]);
			echo " ".$lang["financial"][57];
			echo "&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;".$lang["financial"][88];
			echo getWarrantyExpir($ic->fields["buy_date"],$ic->fields["warranty_duration"]);
			echo "</td>";

			echo "<td>".$lang["financial"][87].":	</td><td >";

			dropdownValue("glpi_dropdown_budget","budget",$ic->fields["budget"]);

			echo "</td></tr>";


			echo "<tr class='tab_bg_1'><td>".$lang["financial"][78].":		</td>";
			echo "<td ><input type='text' $option name='warranty_value' value=\"".number_format($ic->fields["warranty_value"],2,'.','')."\" size='10'></td>";


			echo "<td>".$lang["financial"][16].":		</td>";
			echo "<td >";
			autocompletionTextField("warranty_info","glpi_infocoms","warranty_info",$ic->fields["warranty_info"],25,$option);	

			echo "</td></tr>";
		}

		echo "<tr class='tab_bg_1'><td>".$lang["financial"][21].":		</td><td  ".($show_immo==1?"":" colspan='3'")."><input type='text' name='value' $option value=\"".number_format($ic->fields["value"],2,'.','')."\" size='10'></td>";
		if ($show_immo==1){
			echo "<td>".$lang["financial"][81]." :</td><td>";

			echo  TableauAmort($ic->fields["amort_type"],$ic->fields["value"],$ic->fields["amort_time"],$ic->fields["amort_coeff"],$ic->fields["buy_date"],$ic->fields["use_date"],$date_fiscale,"n");

			echo "</td>";
		}
		echo "</tr>";

		if ($show_immo==1){
			echo "<tr class='tab_bg_1'><td>".$lang["financial"][20]."*:		</td>";
			echo "<td >";
			$objectName = autoName($ic->fields["num_immo"], "num_immo", ($withtemplate==2), INFOCOM_TYPE);
			autocompletionTextField("num_immo","glpi_infocoms","num_immo",$objectName,25,$option); 
			//autocompletionTextField("num_immo","glpi_infocoms","num_immo",$ic->fields["num_immo"],25,$option);	

			echo "</td>";




			echo "<td>".$lang["financial"][22].":		</td><td >";
			if ($withtemplate==2)
				echo getAmortTypeName($ic->fields["amort_type"]);
			else dropdownAmortType("amort_type",$ic->fields["amort_type"]);

			echo "</td></tr>";

			echo "<tr class='tab_bg_1'><td>".$lang["financial"][23].":		</td><td>";
			if ($withtemplate==2)
				echo $ic->fields["amort_time"];
			else dropdownDuration("amort_time",$ic->fields["amort_time"]);
			echo " ".$lang["financial"][9];
			echo "</td>";

			echo "<td>".$lang["financial"][77].":		</td>";
			echo "<td >";
			autocompletionTextField("amort_coeff","glpi_infocoms","amort_coeff",$ic->fields["amort_coeff"],10,$option);	
			echo "</td></tr>";
		}
		//TCO
		if ($device_type!=SOFTWARE_TYPE&&$device_type!=CARTRIDGE_TYPE&&$device_type!=CONSUMABLE_TYPE&&$device_type!=CONSUMABLE_ITEM_TYPE&&$device_type!=LICENSE_TYPE&&$device_type!=CARTRIDGE_ITEM_TYPE){

			echo "<tr class='tab_bg_1'><td>";
			echo $lang["financial"][89]." : </td><td>";
			echo showTco($device_type,$dev_ID,$ic->fields["value"]);
			echo "</td><td>".$lang["financial"][90]." : 	</td><td>";
			echo  showTco($device_type,$dev_ID,$ic->fields["value"],$ic->fields["buy_date"]);
			echo "</td></tr>";
		}

		echo "<tr class='tab_bg_1'><td>".$lang["setup"][247].":		</td>";
		echo "<td>";
		echo "<select name=\"alert\">";
		echo "<option value=\"0\" ".($ic->fields["alert"]==0?" selected ":"")." >-----</option>";
		echo "<option value=\"".pow(2,ALERT_END)."\" ".($ic->fields["alert"]==pow(2,ALERT_END)?" selected ":"")." >".$lang["financial"][80]." </option>";
		echo "</select>";

		echo "</td>";


		echo "<td>&nbsp;</td>";
		echo "<td >&nbsp;";
		echo "</td></tr>";

		// commment
		echo "<tr class='tab_bg_1'><td valign='top'>";
		echo $lang["common"][25].":	</td>";
		echo "<td align='center' colspan='3'><textarea cols='80' $option rows='2' name='comments' >".$ic->fields["comments"]."</textarea>";
		echo "</td></tr>";
		if (haveRight("contract_infocom","w")&&$withtemplate!=2){
			echo "<tr>";

			echo "<td class='tab_bg_2' colspan='2' align='center'>";
			echo "<input type='hidden' name='ID' value=\"".$ic->fields['ID']."\">\n";
			echo "<input type='submit' name='update' value=\"".$lang["buttons"][7]."\" class='submit'>";
			echo "</td>\n\n";
			//			echo "</form>";
			//			echo "<form method='post' action=\"".$HTMLRel."front/infocom.form.php\"><div align='center'>";
			//			echo "<input type='hidden' name='ID' value=\"".$ic->fields['ID']."\">\n";
			echo "<td class='tab_bg_2' colspan='2' align='center'>\n";
			echo "<input type='submit' name='delete' value=\"".$lang["buttons"][6]."\" class='submit'>";

			echo "</td>";
			echo "</tr>";
		}

		echo "</table></div>";
		if ($withtemplate!=2) echo "</form>";

	}
}





function dropdownDuration($name,$value=0){
	global $lang;

	echo "<select name='$name'>";
	for ($i=0;$i<=10;$i+=1)
		echo "<option value='$i' ".($value==$i?" selected ":"").">$i</option>";	
	echo "</select>";	
}

function dropdownAmortType($name,$value=0){
	global $lang;

	echo "<select name='$name'>";
	echo "<option value='0' ".($value==0?" selected ":"").">-------------</option>";
	echo "<option value='2' ".($value==2?" selected ":"").">".$lang["financial"][47]."</option>";
	echo "<option value='1' ".($value==1?" selected ":"").">".$lang["financial"][48]."</option>";
	echo "</select>";	
}
function getAmortTypeName($value){
	global $lang;

	switch ($value){
		case 2 :
			return $lang["financial"][47];
			break;
		case 1 :
			return $lang["financial"][48];
			break;
		case 0 :
			return "";
			break;

	}	
}

function dropdownInfocoms($name){

	global $db;
	$query="SELECT glpi_infocoms.buy_date as buy_date, glpi_infocoms.ID as ID, glpi_enterprises.name as name ";
	$query.= " from glpi_infocoms LEFT JOIN glpi_enterprises ON glpi_infocoms.FK_enterprise = glpi_enterprises.ID ";
	$query.= " WHERE glpi_infocoms.deleted = 'N' order by glpi_infocoms.buy_date DESC";
	$result=$db->query($query);
	echo "<select name='$name'>";
	while ($data=$db->fetch_array($result)){

		echo "<option value='".$data["ID"]."'>";
		echo $data["buy_date"]." - ".$data["name"];
		echo "</option>";
	}

	echo "</select>";	



}


function getWarrantyExpir($from,$addwarranty){
	if ($from==NULL || $from=='0000-00-00')
		return "";
	else return convDate(date("Y-m-d", strtotime("$from+$addwarranty month ")));

}

function getExpir($begin,$duration,$notice="0"){
	if ($begin==NULL || $begin=='0000-00-00'){
		return "";
	} else {
		$diff=strtotime("$begin+$duration month -$notice month")-time();
		$diff_days=floor($diff/60/60/24);
		if($diff_days>0){
			return $diff_days." Jours";
		}else{
			return "<span class='red'>".$diff_days." Jours</span>";
		}
	}

}

/**
 * Calculate amortissement for an item
 *
 * 
 *
 *@param $type_amort
 *@param $va
 *@param $duree
 *@param $coef
 *@param $date_achat
 *@param $date_use
 *@param $date_fiscale
 *@param $view
 *
 *@return float or array
 *
 **/

function TableauAmort($type_amort,$va,$duree,$coef,$date_achat,$date_use,$date_fiscale,$view="n") {
	// By Jean-Mathieu Dol�ns qui s'est un peu pris le chou :p

	// $type_amort = "lineaire=2" ou "degressif=1"
	// $va = valeur d'acquisition
	// $duree = duree d'amortissement
	// $coef = coefficient d'amortissement
	// $date_achat= Date d'achat
	// $date_use = Date d'utilisation
	// $date_fiscale= date du d�ut de l'ann� fiscale
	// $view = "n" pour l'ann� en cours ou "all" pour le tableau complet

	// Attention date mise en service/dateachat ->amort lin�ire  et $prorata en jour !!
	// amort degressif au prorata du nombre de mois. Son point de d�art est le 1er jour du mois d'acquisition et non date de mise en service

	if ($type_amort=="2"){

		if ($date_use!="0000-00-00") $date_achat=$date_use;

	}

	$prorata=0;
	$ecartfinmoiscourant=0;
	$ecartmoisexercice=0;

	sscanf($date_achat, "%4s-%2s-%2s %2s:%2s:%2s",
			$date_Y, $date_m, $date_d,
			$date_H, $date_i, $date_s); // un traitement sur la date mysql pour r�up�er l'ann�

	// un traitement sur la date mysql pour les infos necessaires	
	sscanf($date_fiscale, "%4s-%2s-%2s %2s:%2s:%2s",
			$date_Y2, $date_m2, $date_d2,
			$date_H2, $date_i2, $date_s2); 
	$date_Y2=date("Y");

	//if ($type_amort=="2") { 

	switch ($type_amort) {

		case "2" :

########################### Calcul amortissement lin�ire ###########################

			if($va>0 &&$duree>0  &&$date_achat!="0000-00-00") {

## calcul du prorata temporis en jour ##	


				$ecartfinmoiscourant=(30-$date_d); // calcul ecart entre jour  date acquis ou mise en service et fin du mois courant

				// en lin�ire on calcule en jour

				if ($date_d2<30) {$ecartmoisexercice=(30-$date_d2); }	


				if ($date_m>$date_m2) {$date_m2=$date_m2+12;} // si l'ann� fiscale d�ute au del�de l'ann� courante


				$ecartmois=(($date_m2-$date_m)*30); // calcul ecart etre mois d'acquisition et debut ann� fiscale


				$prorata=$ecartfinmoiscourant+$ecartmois-$ecartmoisexercice;


## calcul tableau d'amortissement ##

				$txlineaire = (100/$duree); // calcul du taux lin�ire

				$annuite = ($va*$txlineaire)/100; // calcul de l'annuit�

				$mrt=$va; //


				// si prorata temporis la derni�e annnuit�cours sur la dur� n+1
				if ($prorata>0){$duree=$duree+1;}

				for($i=1;$i<=$duree;$i++) {


					$tab['annee'][$i]=$date_Y+$i-1;

					$tab['annuite'][$i]=$annuite;

					$tab['vcnetdeb'][$i]=$mrt; // Pour chaque ann� on calcul la valeur comptable nette  de debut d'exercice

					$tab['vcnetfin'][$i]=abs(($mrt - $annuite)); // Pour chaque ann� on calcul la valeur comptable nette  de fin d'exercice


					// calcul de la premi�e annuit�si prorata temporis
					if ($prorata>0){
						$tab['annuite'][1]=$annuite*($prorata/360);

						$tab['vcnetfin'][1]=abs($va - $tab['annuite'][1]);
					}

					$mrt=$tab['vcnetfin'][$i];

				} // end for

				// calcul de la derni�e annuit�si prorata temporis
				if ($prorata>0){
					$tab['annuite'][$duree]=$tab['vcnetdeb'][$duree];

					$tab['vcnetfin'][$duree]=$tab['vcnetfin'][$duree-1]- $tab['annuite'][$duree];
				}

			}else{ return "-"; break; }	

		break;	

		//}else{	
		case "1" :
########################### Calcul amortissement d�ressif ###########################

			if($va>0 &&$duree>0  &&$coef>1 &&$date_achat!="0000-00-00") {

## calcul du prorata temporis en mois ##

				// si l'ann� fiscale d�ute au del�de l'ann� courante

				if ($date_m>$date_m2) {	$date_m2=$date_m2+12;	}

				$ecartmois=($date_m2-$date_m)+1; // calcul ecart etre mois d'acquisition et debut ann� fiscale

				$prorata=$ecartfinmoiscourant+$ecartmois-$ecartmoisexercice;



## calcul tableau d'amortissement ##



				$txlineaire = (100/$duree); // calcul du taux lin�ire virtuel
				$txdegressif=$txlineaire*$coef; // calcul du taux degressif
				$dureelineaire= (int) (100/$txdegressif); // calcul de la dur� de l'amortissement en mode lin�ire
				$dureedegressif=$duree-$dureelineaire;// calcul de la dur� de l'amortissement en mode degressif
				$mrt=$va; //

				// amortissement degressif pour les premi�es ann�s

				for($i=1;$i<=$dureedegressif;$i++) {

					$tab['annee'][$i]=$date_Y+$i-1;

					$tab['vcnetdeb'][$i]=$mrt; // Pour chaque ann� on calcul la valeur comptable nette  de debut d'exercice

					$tab['annuite'][$i]=$tab['vcnetdeb'][$i]*$txdegressif/100;

					$tab['vcnetfin'][$i]=$mrt - $tab['annuite'][$i]; // Pour chaque ann� on calcul la valeur comptable nette  de fin d'exercice

					// calcul de la premi�e annuit�si prorata temporis
					if ($prorata>0){

						$tab['annuite'][1]=($va*$txdegressif/100)*($prorata/12);

						$tab['vcnetfin'][1]=$va - $tab['annuite'][1];

					}

					$mrt=$tab['vcnetfin'][$i];

				} // end for



				// amortissement en lin�ire pour les derni�es ann�s 	 


				if ($dureelineaire!=0)
					$txlineaire = (100/$dureelineaire); // calcul du taux lin�ire
				else $txlineaire = 100;
				$annuite = ($tab['vcnetfin'][$dureedegressif]*$txlineaire)/100; // calcul de l'annuit�
				$mrt=$tab['vcnetfin'][$dureedegressif];


				for($i=$dureedegressif+1;$i<=$dureedegressif+$dureelineaire;$i++) {

					$tab['annee'][$i]=$date_Y+$i-1;

					$tab['annuite'][$i]=$annuite;

					$tab['vcnetdeb'][$i]=$mrt; // Pour chaque ann� on calcul la valeur comptable nette  de debut d'exercice

					$tab['vcnetfin'][$i]=abs(($mrt - $annuite)); // Pour chaque ann� on calcul la valeur comptable nette  de fin d'exercice

					$mrt=$tab['vcnetfin'][$i];

				} // end for

				// calcul de la derni�e annuit�si prorata temporis
				if ($prorata>0){

					$tab['annuite'][$duree]=$tab['vcnetdeb'][$duree];

					if (isset($tab['vcnetfin'][$duree-1]))
						$tab['vcnetfin'][$duree]=$tab['vcnetfin'][$duree-1]- $tab['annuite'][$duree];
					else $tab['vcnetfin'][$duree]=0;

				}

			}else{ return "-"; break; }	

		break;


	default :
		return "-"; break;


}



// le return


if ($view=="all") {

	// on retourne le tableau complet

	return $tab;

}else{

	// on retourne juste la valeur r�iduelle


	// si on ne trouve pas l'ann� en cours dans le tableau d'amortissement dans le tableau, le mat�iel est amorti
	if (!array_search(date("Y"),$tab["annee"]))
	{
		$vnc=0;

	}elseif (mktime(0 , 0 , 0, $date_m2, $date_d2, date("Y"))  - mktime(0 , 0 , 0 , date("m") , date("d") , date("Y")) < 0 ){

		// on a d�ass�la fin d'exercice de l'ann� en cours

		//on prend la valeur r�iduelle de l'ann� en cours

		$vnc= $tab["vcnetfin"][array_search(date("Y"),$tab["annee"])];

	}else {

		// on se situe avant la fin d'exercice
		// on prend la valeur r�iduelle de l'ann� n-1



		$vnc=$tab["vcnetdeb"][array_search(date("Y"),$tab["annee"])];




	}

	return number_format($vnc,2,".","");

}





}


/**
 * Calculate TCO and TCO by month for an item
 *
 * 
 *
 *@param $item_type
 *@param $item
 *@param $value 
 *@param $date_achat
 *
 *@return float
 *
 **/


function showTco($item_type,$item,$value,$date_achat=""){
	// Affiche le TCO ou le TCO mensuel pour un matériel 
	//		
	global $db;
	$totalcost=0;

	$query="SELECT * FROM glpi_tracking WHERE (status = 'old_done') and (device_type = '$item_type' and computer = '$item')";


	$result = $db->query($query);

	$i = 0;
	$number = $db->numrows($result);

	if ($number > 0){

		while ($i < $number)
		{
			$ID = $db->result($result, $i, "ID");

			$totalcost=$totalcost+($db->result($result, $i, "realtime")*$db->result($result, $i, "cost_time"))+$db->result($result, $i, "cost_fixed")+$db->result($result, $i, "cost_material");

			$i++;
		}

	}

	if ($date_achat){ // on veut donc le TCO mensuel

		sscanf($date_achat, "%4s-%2s-%2s",$date_Y, $date_m, $date_d);

		$timestamp2 = mktime(0,0,0, $date_m, $date_d, $date_Y);
		$timestamp = mktime(0,0,0, date("m"), date("d"), date("Y"));

		$diff = floor(($timestamp - $timestamp2) / (MONTH_TIMESTAMP)); // Mois d'utilisation

		if ($diff)
			return number_format((($totalcost+$value)/$diff),2,"."," "); // TCO mensuel
		else return "";

	}else {
		return number_format(($totalcost+$value),2,"."," "); // TCO
	}

}// fin showTCO	








function addInfocomOptionFieldsToResearch($option){
	global $lang;
	$option["glpi_infocoms.num_immo"]=$lang["financial"][20];
	$option["glpi_infocoms.num_commande"]=$lang["financial"][18];
	$option["glpi_infocoms.bon_livraison"]=$lang["financial"][19];
	$option["glpi_infocoms.facture"]=$lang["financial"][82];
	return $option;

}

function showDisplayInfocomLink($device_type,$device_id,$update=0){
	global $db,$HTMLRel,$lang;

	if (!haveRight("contract_infocom","r")) return false;

	$query="SELECT COUNT(ID) FROM glpi_infocoms WHERE FK_device='$device_id' AND device_type='$device_type'";

	$add="add";
	$text=$lang["buttons"][8];
	$result=$db->query($query);
	if ($db->result($result,0,0)>0) {
		$add="";
		$text=$lang["buttons"][23];
	}
	if (haveTypeRight($device_type,"w"))
		echo "<span onClick=\"window.open('".$HTMLRel."front/infocom.show.php?device_type=$device_type&amp;device_id=$device_id&amp;update=$update','infocoms','location=infocoms,width=1000,height=600,scrollbars=no')\" style='cursor:pointer'><img src=\"".$HTMLRel."/pics/dollar$add.png\" alt=\"$text\" title=\"$text\"></span>";
}


function cron_infocom(){
	global $db,$cfg_glpi,$lang,$phproot;


	$message="";

	// Check notice
	$query="SELECT glpi_infocoms.* FROM glpi_infocoms LEFT JOIN glpi_alerts ON (glpi_infocoms.ID = glpi_alerts.FK_device AND glpi_alerts.device_type='".INFOCOM_TYPE."' AND glpi_alerts.type='".ALERT_END."') WHERE (glpi_infocoms.alert & ".pow(2,ALERT_END).") >0 AND glpi_infocoms.warranty_duration<>0 AND glpi_infocoms.buy_date<>'0000-00-00' AND DATEDIFF( ADDDATE(glpi_infocoms.buy_date, INTERVAL (glpi_infocoms.warranty_duration) MONTH),CURDATE() )<0 AND glpi_alerts.date IS NULL;";

	$result=$db->query($query);
	if ($db->numrows($result)>0){

		$ci=new CommonItem();
		$needed=array("computer","device","printer","networking","peripheral","monitor","software","infocom","phone","state","tracking","enterprise");
		foreach ($needed as $item){
			if (file_exists($phproot . "/inc/$item.class.php"))
				include_once ($phproot . "/inc/$item.class.php");
			if (file_exists($phproot . "/inc/$item.function.php"))
				include_once ($phproot . "/inc/$item.function.php");
		}

		while ($data=$db->fetch_array($result)){
			if ($ci->getFromDB($data["device_type"],$data["FK_device"])){
				// define message alert / Not for template items
				if (!isset($ci->obj->fields["is_template"])||!$ci->obj->fields["is_template"])
					$message.=$lang["mailing"][40]." ".$ci->getType()." - ".$ci->getName()."<br>\n";
			} 

			// Mark alert as done
			$alert=new Alert();
			//// add alert
			$input["type"]=ALERT_END;
			$input["device_type"]=INFOCOM_TYPE;
			$input["FK_device"]=$data["ID"];

			$alert->add($input);

		}

		if (!empty($message)){
			$mail=new MailingAlert("alertinfocom",$message);
			$mail->send();
			return 1;
		}

	}



	return 0;


}


?>