<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: demandes_actions.class.php,v 1.12.2.1 2015-09-24 15:48:15 dgoron Exp $

if (stristr($_SERVER['REQUEST_URI'], ".class.php")) die("no access");

require_once($class_path."/demandes_notes.class.php");
require_once($class_path."/demandes.class.php");
require_once($class_path."/explnum_doc.class.php");
require_once($class_path."/workflow.class.php");
require_once($class_path."/audit.class.php");
require_once($include_path."/templates/demandes_actions.tpl.php");

class demandes_actions{
	
	var $id_action = 0;
	var $type_action = 0;
	var $statut_action = 0;
	var $sujet_action = '';
	var $detail_action = '';
	var $time_elapsed = 0;
	var $date_action = '0000-00-00';
	var $deadline_action = '0000-00-00';
	var $progression_action = 0;
	var $prive_action = 0;
	var $cout = 0;
	var $num_demande = 0;
	var $libelle_demande = '';
	var $actions_num_user = 0;
	var $actions_type_user = 0;
	var $createur_action ="";
	var $list_type = array();
	var $list_statut = array();
	var $workflow = array();
	var $notes = array();
	var $actions_read_gestion = 0; // alerte sur la lecture de l'action en gestion par l'utilisateur
	var $actions_read_opac = 0; // alerte sur la lecture de l'action en opac par le lecteur
	var $last_modified=0;
	/*
	 * Constructeur
	 */
	function demandes_actions($id=0,$lazzy_load=true){
		global $base_path, $dbh, $iddemande;
		
		$this->fetch_data($id,$lazzy_load);
	}
	
	function fetch_data($id=0,$lazzy_load=true){
		global $base_path, $dbh, $iddemande;
		
		if($this->id_action && !$id){
			$id=$this->id_action;
		}elseif(!$this->id_action && $id){
			$this->id_action=$id;
		}
		
		if($this->id_action){
			$req = "select id_action,type_action,statut_action, sujet_action,
			detail_action,date_action,deadline_action,temps_passe, cout, progression_action, prive_action, num_demande, titre_demande,
			actions_num_user,actions_type_user,actions_read_gestion,actions_read_opac 
			from demandes_actions
			join demandes on num_demande=id_demande
			where id_action='".$this->id_action."'";
			$res=pmb_mysql_query($req,$dbh);
			if(pmb_mysql_num_rows($res)){
				$obj = pmb_mysql_fetch_object($res);
				$this->type_action = $obj->type_action;
				$this->date_action = $obj->date_action;
				$this->deadline_action = $obj->deadline_action;
				$this->sujet_action = $obj->sujet_action;
				$this->detail_action = $obj->detail_action;
				$this->cout = $obj->cout;
				$this->progression_action = $obj->progression_action;
				$this->time_elapsed = $obj->temps_passe;
				$this->num_demande = $obj->num_demande;
				$this->statut_action = $obj->statut_action;
				$this->libelle_demande = $obj->titre_demande;
				$this->prive_action = $obj->prive_action;
				$this->actions_num_user = $obj->actions_num_user;
				$this->actions_type_user =  $obj->actions_type_user;
				$this->actions_read_gestion =  $obj->actions_read_gestion;
				$this->actions_read_opac =  $obj->actions_read_opac;
			} else{
				$this->id_action = 0;
				$this->type_action = 0;
				$this->date_action = '0000-00-00';
				$this->deadline_action = '0000-00-00';
				$this->sujet_action = '';
				$this->detail_action = '';
				$this->cout = 0;
				$this->progression_action = 0;
				$this->time_elapsed = 0;
				$this->num_demande = 0;
				$this->statut_action =	0;
				$this->libelle_demande = '';
				$this->prive_action = 0;
				$this->actions_num_user = 0;
				$this->actions_type_user =  0;
				$this->actions_read_gestion =  0;
				$this->actions_read_opac = 0;
			}
		} else {
			$this->id_action = 0;
			$this->type_action = 0;
			$this->date_action = '0000-00-00';
			$this->deadline_action = '0000-00-00';
			$this->sujet_action = '';
			$this->detail_action = '';
			$this->cout = 0;
			$this->progression_action = 0;
			$this->time_elapsed = 0;
			$this->num_demande = 0;
			$this->statut_action =	0;
			$this->libelle_demande = '';
			$this->prive_action = 0;
			$this->actions_num_user = 0;
			$this->actions_type_user =  0;
			$this->actions_read_gestion =  0;
			$this->actions_read_opac = 0;
		}
		
		if(!sizeof($this->workflow)){
			$this->workflow = new workflow('ACTIONS','INITIAL');
			$this->list_type = $this->workflow->getTypeList();
			$this->list_statut = $this->workflow->getStateList();
		}
		
		if($iddemande) {
			$this->num_demande = $iddemande;
			$req = "select titre_demande from demandes where id_demande='".$iddemande."'";
			$res = pmb_mysql_query($req,$dbh);
			$this->libelle_demande = pmb_mysql_result($res,0,0);
		}
		
		
		//On remonte les notes
		if($this->id_action){
			$this->notes=array();
			//On charge la liste d'id des notes
			$query='SELECT id_note,date_note FROM demandes_notes WHERE num_action='.$this->id_action.' AND prive!=1 ORDER BY id_note ASC';
			$result=pmb_mysql_query($query);
			
			while($note=pmb_mysql_fetch_array($result,MYSQL_ASSOC)){
				if($lazzy_load){
					$this->notes[$note['id_note']]=new stdClass();
					$this->notes[$note['id_note']]->id_note=$note['id_note'];
					$this->notes[$note['id_note']]->date_note=$note['date_note'];
					$this->notes[$note['id_note']]->id_action=$this->id_action;
				}else{
					$this->notes[$note['id_note']]=new demandes_notes($note['id_note'],$this->id_action);
				}
				
				
			}
			$this->last_modified=self::get_last_modified_note($this->notes);
		}
	}
	
	/*
	 * Cherche la note la plus récente grace à l'audit
	 */
	static function get_last_modified_note($notes){
		$temp=0;
		foreach($notes as $id_note=>$note){
			//On cherche la derniere note modifiée
			if(!$temp){
				$temp=$note;
			}
			
			$dateLast_modified= new DateTime($temp->date_note);
			$dateNote= new DateTime($note->date_note);
			
			if($dateLast_modified->format('U') < $dateNote->format('U')){
				$temp = $note;
			}
		}
		
		if($temp){
			return $temp;
		}
	}
	
	/*
	 * Affichage du formulaire de création/modification
	 */
	function show_modif_form(){
		
		global $form_modif_action,$msg, $charset,$type_action,$iddemande;
		
		
		if($this->id_action){
			$form_modif_action = str_replace('!!form_title!!',htmlentities(sprintf($msg['demandes_action_modif'],' : '.$this->sujet_action),ENT_QUOTES,$charset),$form_modif_action);
			$form_modif_action = str_replace('!!sujet!!',htmlentities($this->sujet_action,ENT_QUOTES,$charset),$form_modif_action);
			$form_modif_action = str_replace('!!detail!!',htmlentities($this->detail_action,ENT_QUOTES,$charset),$form_modif_action);
			$form_modif_action = str_replace('!!cout!!',htmlentities($this->cout,ENT_QUOTES,$charset),$form_modif_action);
			$form_modif_action = str_replace('!!time_elapsed!!',htmlentities($this->time_elapsed,ENT_QUOTES,$charset),$form_modif_action);
			$form_modif_action = str_replace('!!progression!!',htmlentities($this->progression_action,ENT_QUOTES,$charset),$form_modif_action);
			$form_modif_action = str_replace('!!select_type!!',$this->workflow->getTypeCommentById($this->type_action),$form_modif_action);
			$type_hide = "<input type='hidden' name='idtype' id='idtype' value='$this->type_action' />";
			$form_modif_action = str_replace('!!type_action!!',$type_hide,$form_modif_action);
			$form_modif_action = str_replace('!!select_statut!!',$this->getStatutSelector($this->statut_action),$form_modif_action);
			
			$form_modif_action = str_replace('!!date_fin_btn!!',formatdate($this->deadline_action),$form_modif_action);
			$form_modif_action = str_replace('!!date_debut_btn!!',formatdate($this->date_action),$form_modif_action);
			$form_modif_action = str_replace('!!date_debut!!',htmlentities($this->date_action,ENT_QUOTES,$charset),$form_modif_action);
			$form_modif_action = str_replace('!!date_fin!!',htmlentities($this->deadline_action,ENT_QUOTES,$charset),$form_modif_action);
			
			$btn_suppr = "<input type='submit' class='bouton' value='$msg[63]' onclick='this.form.act.value=\"suppr_action\"; return confirm_delete();' />";	
			$form_modif_action = str_replace('!!btn_suppr!!',$btn_suppr,$form_modif_action);
			$form_modif_action = str_replace('!!idaction!!',$this->id_action,$form_modif_action);
			$form_modif_action = str_replace('!!iddemande!!',$this->num_demande,$form_modif_action);
			if($this->prive_action)
				$form_modif_action = str_replace('!!ck_prive!!','checked',$form_modif_action);
			else $form_modif_action = str_replace('!!ck_prive!!','',$form_modif_action);
			
		} else {
			$form_modif_action = str_replace('!!idaction!!','',$form_modif_action);
			$form_modif_action = str_replace('!!iddemande!!',$this->num_demande,$form_modif_action);
			
			$form_modif_action = str_replace('!!sujet!!','',$form_modif_action);
			$form_modif_action = str_replace('!!detail!!','',$form_modif_action);
			$date = formatdate(today());
			$date_debut=date("Y-m-d",time());
			$form_modif_action = str_replace('!!date_fin_btn!!',$date,$form_modif_action);
			$form_modif_action = str_replace('!!date_debut_btn!!',$date,$form_modif_action);
			$form_modif_action = str_replace('!!date_debut!!',$date_debut,$form_modif_action);
			$form_modif_action = str_replace('!!date_fin!!',$date_debut,$form_modif_action);
			
			$type=$this->getType($type_action);
			$form_modif_action = str_replace('!!libelle_type!!',$type['comment'],$form_modif_action);
			$form_modif_action = str_replace('!!idtype!!',$type['id'],$form_modif_action);
			
			$statut=$this->getStatut();
			$form_modif_action = str_replace('!!libelle_statut!!',$statut['comment'],$form_modif_action);
			$form_modif_action = str_replace('!!idstatut!!',$statut['id'],$form_modif_action);
			
			$form_modif_action = str_replace('!!time_elapsed!!','',$form_modif_action);
			$form_modif_action = str_replace('!!progression!!','',$form_modif_action);
			$form_modif_action = str_replace('!!ck_prive!!','',$form_modif_action);
			$form_modif_action = str_replace('!!cout!!','',$form_modif_action);
			
		}
		
		$form_modif_action = str_replace('!!form_action!!',"./empr.php?tab=request&lvl=list_dmde&sub=save_action",$form_modif_action);
		$form_modif_action = str_replace('!!cancel_action!!',"document.location='./empr.php?tab=request&lvl=list_dmde&sub=open_demande&iddemande=$this->num_demande#fin'",$form_modif_action);
		
		print $form_modif_action;
	}
	
	function getStatut($idstatut=0){
		foreach($this->list_statut as $key=>$value){
			if($idstatut){
				if($value['id']==$idstatut){
					return $value;
				}
			}else{				
				if($value['default']==true){
					return $value;
				}
			}
		}	
	}
	
	function getType($idtype=0){
		foreach($this->list_type as $key=>$value){
			if($idtype){
				if($value['id']==$idtype){
					return $value;
				}
			}else{				
				if($value['default']==true){
					return $value;
				}
			}
		}
	}
	
	/*
	 * Formulaire de consultation d'une action
	 */
	function show_consultation_form(){
		
		global $idetat,$form_consult_action, $msg, $charset, $pmb_gestion_devise, $dbh, $pmb_type_audit;
		
		$form_consult_action = str_replace('!!form_title!!',htmlentities($this->sujet_action,ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!idstatut!!',htmlentities($this->statut_action,ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!type_action!!',htmlentities($this->workflow->getTypeCommentById($this->type_action),ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!statut_action!!',htmlentities($this->workflow->getStateCommentById($this->statut_action),ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!detail_action!!',htmlentities($this->detail_action,ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!date_action!!',htmlentities(formatdate($this->date_action),ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!date_butoir_action!!',htmlentities(formatdate($this->deadline_action),ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!time_action!!',htmlentities($this->time_elapsed.$msg['demandes_action_time_unit'],ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!cout_action!!',htmlentities($this->cout,ENT_QUOTES,$charset).$pmb_gestion_devise,$form_consult_action);
		$form_consult_action = str_replace('!!progression_action!!',htmlentities($this->progression_action,ENT_QUOTES,$charset).'%',$form_consult_action);
		$form_consult_action = str_replace('!!idaction!!',htmlentities($this->id_action,ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!iddemande!!',htmlentities($this->num_demande,ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!createur!!',htmlentities($this->getCreateur($this->actions_num_user,$this->actions_type_user),ENT_QUOTES,$charset),$form_consult_action);
		$form_consult_action = str_replace('!!prive_action!!',htmlentities(($this->prive_action ? $msg[40] : $msg[39] ),ENT_QUOTES,$charset),$form_consult_action);
		
		$form_consult_action = str_replace('!!params_retour!!','&iddemande='.$this->num_demande,$form_consult_action);
		
		print $form_consult_action;
		
		//Notes
		print demandes_notes::show_dialog($this->notes,$this->id_action,$this->num_demande,'demandes-show_consultation_form');
		
		// Annulation de l'alerte sur l'action en cours après lecture des nouvelles notes si c'est la personne à laquelle est affectée l'action qui la lit
		$this->actions_read_opac = demandes_actions::action_read($this->id_action,true,"_opac");
		// Mise à jour de la demande dont est issue l'action
		demandes_actions::action_majParentEnfant($this->id_action,$this->num_demande,"_opac");
	}
	
	/*
	 * Formulaire d'ajout/modification d'un document numérique
	 */
	function show_docnum_form(){
		
		global $form_add_docnum, $msg,$dbh, $charset,$explnumdoc_id,$explnum_doc;
		
		if($explnumdoc_id){
			$rqt = "select prive, rapport from explnum_doc_actions where num_explnum_doc='".$explnumdoc_id."'";
			$res = pmb_mysql_query($rqt, $dbh);
			$expl = pmb_mysql_fetch_object($res);
			$prive = $expl->prive;
			$rapport = $expl->rapport;
			
			$explnum_doc = new explnum_doc($explnumdoc_id);
			$form_add_docnum = str_replace('!!idaction!!',$this->id_action, $form_add_docnum);
			$form_add_docnum = str_replace('!!url_doc!!',htmlentities($explnum_doc->explnum_doc_url,ENT_QUOTES,$charset), $form_add_docnum);
			$form_add_docnum = str_replace('!!nom!!',htmlentities($explnum_doc->explnum_doc_nomfichier,ENT_QUOTES,$charset), $form_add_docnum);
			$act_cancel = "document.location='./demandes.php?categ=action&act=see&idaction=$this->id_action'";
			$form_add_docnum = str_replace('!!cancel_action!!',$act_cancel, $form_add_docnum);
			$form_add_docnum = str_replace('!!form_title!!',htmlentities($msg['explnum_data_doc'],ENT_QUOTES,$charset),$form_add_docnum);
			$form_add_docnum = str_replace('!!iddocnum!!',$explnumdoc_id,$form_add_docnum);		
			$form_add_docnum = str_replace('!!ck_prive!!',($prive ? 'checked' :''),$form_add_docnum);
			$form_add_docnum = str_replace('!!ck_rapport!!',($rapport ? 'checked' :''),$form_add_docnum);		
			$btn_suppr= "<input type='submit' class='bouton' value='$msg[63]' onClick='this.form.act.value=\"suppr_docnum\" ; ' />";
		} else {
			$form_add_docnum = str_replace('!!idaction!!',$this->id_action, $form_add_docnum);
			$form_add_docnum = str_replace('!!url_doc!!',"", $form_add_docnum);
			$form_add_docnum = str_replace('!!nom!!','', $form_add_docnum);
			$act_cancel = "document.location='./demandes.php?categ=action&act=see&idaction=$this->id_action'";
			$form_add_docnum = str_replace('!!cancel_action!!',$act_cancel, $form_add_docnum);
			$form_add_docnum = str_replace('!!iddocnum!!','',$form_add_docnum);			
			$form_add_docnum = str_replace('!!form_title!!',htmlentities($msg['explnum_ajouter_doc'],ENT_QUOTES,$charset),$form_add_docnum);
			$form_add_docnum = str_replace('!!ck_prive!!','',$form_add_docnum);
			$form_add_docnum = str_replace('!!ck_rapport!!','',$form_add_docnum);
			$btn_suppr="";			
		}
		$form_add_docnum = str_replace('!!suppr_btn!!',$btn_suppr,$form_add_docnum);
		$act_cancel = "document.location='./demandes.php?categ=action&act=see&idaction=$this->id_action'";
		$form_add_docnum = str_replace('!!cancel_action!!',$act_cancel, $form_add_docnum);
		
		$path = "<a href=./demandes.php?categ=gestion&act=see_dmde&iddemande=$this->num_demande>".htmlentities($this->libelle_demande,ENT_QUOTES,$charset)."</a>";
		$path .= " > <a href=./demandes.php?categ=action&act=see&idaction=$this->id_action>".htmlentities($this->sujet_action,ENT_QUOTES,$charset)."</a>";
		$form_add_docnum = str_replace('!!path!!',$path,$form_add_docnum);
		
		print $form_add_docnum;
	}
	
	/*
	 * Retourne un sélecteur avec les types d'action
	 */
	function getTypeSelector($idtype=0){
		
		global $charset, $msg;
		
		$selector = "<select name='idtype'>";
		$select="";
		if($default) $selector .= "<option value='0'>".htmlentities($msg['demandes_action_all_types'],ENT_QUOTES,$charset)."</option>";
		for($i=1;$i<=count($this->list_type);$i++){
			if($idtype == $i) $select = "selected";
			$selector .= "<option value='".$this->list_type[$i]['id']."' $select>".htmlentities($this->list_type[$i]['comment'],ENT_QUOTES,$charset)."</option>";
			$select = "";
		}
		$selector .= "</select>";
		
		return $selector;
	}
	
	/*
	 * Affiche la liste des boutons correspondants au statut en cours
	*/
	function getDisplayStateBtn($list_statut=array(),$multi=0){
		global $charset,$msg;
		
		if($multi){
			$message = $msg['demandes_action_change_checked_states'];
		} else {
			$message = $msg['demandes_action_change_state'];
		}
		$display = "<label class='etiquette'>".$message." : </label>";
		
		for($i=0;$i<count($list_statut);$i++){
			$display .= "&nbsp;<input class='bouton' type='submit' name='btn_".$list_statut[$i]['id']."' value='".htmlentities($list_statut[$i]['comment'],ENT_QUOTES,$charset)."' onclick='this.form.idstatut.value=\"".$list_statut[$i]['id']."\"; this.form.act.value=\"change_statut\";'/>";
		}
	
		return $display;
	}
	
	/*
	 * Retourne un sélecteur avec les statuts d'action
	 */
	function getStatutSelector($idstatut=0,$ajax=false){
		
		global $charset;
		
		$selector = "<select ".($ajax ? "name='save_statut_".$this->id_action."' id='save_statut_".$this->id_action."'" : "name='idstatut'").">";
		$select="";
		for($i=1;$i<=count($this->list_statut);$i++){
			if($idstatut == $this->list_statut[$i]['id']) $select = "selected";
			$selector .= "<option value='".$this->list_statut[$i]['id']."' $select>".htmlentities($this->list_statut[$i]['comment'],ENT_QUOTES,$charset)."</option>";
			$select = "";
		}
		$selector .= "</select>";
		
		return $selector;
	}
	
	static function get_values_from_form(&$action){
		global $idaction,$sujet, $idtype, $idstatut;
		global $date_debut, $date_fin, $detail,$id_empr;
		global $time_elapsed, $progression,$cout,$iddemande, $ck_prive, $pmb_type_audit, $opac_demandes_no_action;
		
		if($opac_demandes_no_action) return;
		
		$action->id_action=$idaction;
		$action->num_demande=$iddemande;
		$action->sujet_action=$sujet;
		$action->type_action=$idtype;
		$action->statut_action=$idstatut;
		$action->date_action=$date_debut;
		$action->deadline_action=$date_fin;
		$action->detail_action=$detail;
		$action->time_elapsed=$time_elapsed;
		$action->progression_action=$progression;
		$action->cout=$cout;
		$action->prive_action=$ck_prive;
		$action->actions_type_user='1';
		$action->actions_num_user=$id_empr;
		
	}

	/*
	 * Insertion/Modification d'une action
	*/
	static function save(&$action){
		global $dbh, $pmb_type_audit, $opac_demandes_no_action;
		if($opac_demandes_no_action) return;
		
		if($action->id_action){
			//MODIFICATION
			$query = "UPDATE demandes_actions SET
			sujet_action='".$action->sujet_action."',
			type_action='".$action->type_action."',
			statut_action='".$action->statut_action."',
			detail_action='".$action->detail_action."',
			date_action='".$action->date_action."',
			deadline_action='".$action->deadline_action."',
			temps_passe='".$action->time_elapsed."',
			cout='".$action->cout."',
			progression_action='".$action->progression_action."',
			prive_action='".$action->prive_action."',
			num_demande='".$action->num_demande."',
			actions_read_gestion='1',
			actions_read_opac='1' 
			WHERE id_action='".$action->id_action."'";
			
			pmb_mysql_query($query,$dbh);
			//audit
			if($pmb_type_audit) audit::insert_modif(AUDIT_ACTION,$action->id_action);
				
		} else {
			//CREATION
			$query = "INSERT INTO demandes_actions SET
			sujet_action='".$action->sujet_action."',
			type_action='".$action->type_action."',
			statut_action='".$action->statut_action."',
			detail_action='".$action->detail_action."',
			date_action='".$action->date_action."',
			deadline_action='".$action->deadline_action."',
			temps_passe='".$action->time_elapsed."',
			cout='".$action->cout."',
			progression_action='".$action->progression_action."',
			prive_action='".$action->prive_action."',
			num_demande='".$action->num_demande."',
			actions_num_user='".$action->actions_num_user."',
			actions_type_user='".$action->actions_type_user."',
			actions_read_gestion='1',
			actions_read_opac='1' 
			";
			
			pmb_mysql_query($query,$dbh);
			$action->id_action = pmb_mysql_insert_id($dbh);
			$action->actions_num_user = $id_empr;
			$action->actions_type_user = 1;
			// audit
			if($pmb_type_audit) audit::insert_modif(AUDIT_ACTION,$action->id_action);
				
			//Création d'une note automatiquement
			if($action->detail_action && $action->detail_action!==""){
	
				$note=new demandes_notes();
				$note->num_action=$action->id_action;
				$note->date_note=date("Y-m-d h:i:s",time());
				$note->rapport=0;
				$note->contenu=$action->detail_action;
				$note->notes_type_user=$action->actions_type_user;
				$note->notes_num_user=$action->actions_num_user;
				demandes_notes::save($note);
				
			}
		}
	}
	
	/*
	 * Changement de statut d'une action
	*/
	static function change_statut($statut,$action){
		global $dbh, $pmb_type_audit , $PMBuserid;
	
		$query = "update demandes_actions set statut_action=$statut where id_action='".$action->id_action."'";
		pmb_mysql_query($query,$dbh);
		
		if($pmb_type_audit) audit::insert_modif(AUDIT_ACTION,$action->id_action);
	}
	
	
	
	/*
	 * Affichage de la liste des actions
	 */
	static function show_list_actions($actions,$id_demande,$last_modified=0,$allow_expand=true){
		
		global $form_liste_action, $dbh,$msg, $pmb_gestion_devise, $charset, $pmb_type_audit, $ck_vue,$form_see_docnum;
		
		$liste ="";
		if(sizeof($actions)){
			$parity=1;						
			foreach($actions as $id_action=>$action){
				
				if ($parity % 2) {
					$pair_impair = "even";
				} else {
					$pair_impair = "odd";
				}
				$parity += 1;
				$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" ";

				//On ouvre la derniere conversation
				if($last_modified==$action->id_action){
					$form_liste_action = str_replace('!!last_modified!!',$last_modified,$form_liste_action);
				}
				
				// affichage en gras si nouveauté pour l'opac du côté des notes ou des actions + icone
				$style =""; 
				if($action->actions_read_opac == 1){				
					$style=" style='cursor: pointer; font-weight:bold;width:100%;height:30px;margin:5px;border-radius: 6px;'";									
				} else {
					$style=" style='cursor: pointer;width:100%;margin:5px;border-radius: 6px;'";					
				}
				
				if($allow_expand){
					$onclick="onclick=\"expand_note('note".$action->id_action."','$action->id_action', true); return false;\"";
				}else{
					$onclick="onclick=\"document.location='./empr.php?tab=request&lvl=list_dmde&sub=open_demande&iddemande=$id_demande&last_modified=$action->id_action'\"";
				}
				
				
				$liste.="<div $onclick class='form-list-actions ".$pair_impair."' ".$tr_javascript.$style." >";
				$liste.="<div style=\"float:left;padding-top: 6px;\">";
				if($action->actions_read_opac == 1){
					$liste .= "<img hspace=\"3\" border=\"0\" ".$onclick." title=\"\" id=\"read".$action->id_action."Img1\" name=\"imRead\" class=\"img_plus\" src=\"".get_url_icon('notification_empty.png')."\" style='display:none;margin:0 5px'>
								<img style=\"margin:0 5px\" hspace=\"3\" border=\"0\" ".$onclick." title=\"\" id=\"read".$action->id_action."Img2\" name=\"imRead\" class=\"img_plus\" src=\"".get_url_icon('notification_new.png')."\">";
				} else {
					$liste .= "<img style=\";margin:0 5px\" hspace=\"3\" border=\"0\" ".$onclick." title=\"\" id=\"read".$action->id_action."Img1\" name=\"imRead\" class=\"img_plus\" src=\"".get_url_icon('notification_empty.png')."\" >
								<img hspace=\"3\" border=\"0\" ".$onclick." title=\"\" id=\"read".$action->id_action."Img2\" name=\"imRead\" class=\"img_plus\" src=\"".get_url_icon('notification_new.png')."\" style='display:none;margin:0 5px'>";
				}

				foreach($action->workflow->getTypeList() as $id=>$value){
					if($value['id']==$action->type_action && $value['image']){
						$liste.="<img hspace=\"3\" border=\"0\" title=\"".$value['comment']."\" src=\"./images/".$value['image']."\" style=\"height:16px;margin:0 5px\" />";
					}
				}
				$liste.="</div>";
				
				$liste.="<p style=\"padding-top: 8px;\">#".$action->getCreateur($action->actions_num_user,$action->actions_type_user)." : <i>".htmlentities($action->sujet_action,ENT_QUOTES,$charset)."</i> ".htmlentities($action->detail_action,ENT_QUOTES,$charset)."</p>";
				
				$liste.="</div>";
				
				if($allow_expand){
					//Le détail de l'action, contient les notes
					$liste .="<div id=\"note".$action->id_action."Child\" style=\"display:none\">
					
					<div id=\"note".$action->id_action."ChildTd\">";

					$liste .="</div>";
					
					$liste .= self::show_action_docnum($action);
					
					$liste .="</div>";
				}
			}	
		} else {
			$liste .= "<div>".$msg['demandes_action_liste_vide']."</div>";
		}
		
		if(!$last_modified){
			$form_liste_action = str_replace('!!last_modified!!','',$form_liste_action);
		}
		
		$form_liste_action = str_replace('!!iddemande!!',$id_demande,$form_liste_action);
		$form_liste_action = str_replace('!!liste_action!!',$liste,$form_liste_action);
		
		if($allow_expand){
			$script="
				if(document.getElementById('last_modified').value!=0){
					window.onload(expand_note('note'+document.getElementById('last_modified').value,document.getElementById('last_modified').value, true));
				}
			";
		}
		$form_liste_action = str_replace('!!script_expand!!',$script,$form_liste_action);
		
		return $form_liste_action;		
	}
	
	static function show_action_docnum($action){
		global $dbh,$msg,$form_see_docnum;
		
		
		//Documents Numériques
		$query = "SELECT * FROM explnum_doc 
		JOIN explnum_doc_actions ON num_explnum_doc=id_explnum_doc
		WHERE num_action='".$action->id_action."'";
		
		$result = pmb_mysql_query($query,$dbh);
		
		if(pmb_mysql_num_rows($result)){
			$tab_docnum = array();
			while(($docnums = pmb_mysql_fetch_array($result))){
				$tab_docnum[] = $docnums;
			}
			$explnum_doc = new explnum_doc();
			$liste_docnum = $explnum_doc->show_docnum_table($tab_docnum);
			$form_see_docnum = str_replace('!!list_docnum!!',$liste_docnum,$form_see_docnum);
		} else {
			$form_see_docnum = str_replace('!!list_docnum!!',htmlentities($msg['demandes_action_no_docnum'],ENT_QUOTES,$charset),$form_see_docnum);
		}
		$form_see_docnum = str_replace('!!idaction!!',$action->id_action,$form_see_docnum);
		
		return $form_see_docnum;
	}
	
	/*
	 * Suppression d'une action 
	 */
	static function delete(demandes_actions $action){
		
		global $dbh,$chk;
		
		if($action->id_action){
			$action->fetch_data($action->id_action,false);
			if(sizeof($action->notes)){
				foreach($action->notes as $note){
					demandes_notes::delete($note);
				}
			}
			
			$req = "delete from demandes_actions where id_action='".$action->id_action."'"; 
			pmb_mysql_query($req,$dbh);

			$q = "delete ed,eda from explnum_doc ed join explnum_doc_actions eda on ed.id_explnum_doc=eda.num_explnum_doc where eda.num_action=$action->id_action";
			pmb_mysql_query($q, $dbh);
			audit::delete_audit(AUDIT_ACTION,$action->id_action);
 		}		
	}
	
	/*
	 * Liste des actions Questions/Réponses ouverte ou en attente
	 */
	function show_com_form(){
		global $form_communication, $dbh, $charset, $msg;
		
		
		$req_dmde = "select id_demande, titre_demande from demandes
			join demandes_actions on num_demande=id_demande
			join demandes_users du on du.num_demande=id_demande
			and type_action=1 
			and (statut_action=1 or statut_action=2)
			and num_user='".SESSuserid."' group by id_demande";
		$res_dmde=pmb_mysql_query($req_dmde,$dbh);
		if(pmb_mysql_num_rows($res_dmde)){
			while(($dmde=pmb_mysql_fetch_object($res_dmde))){
				$dmde_action = "onclick=document.location='./demandes.php?categ=gestion&act=see_dmde&iddemande=".$dmde->id_demande."'";
				$list .= "<tr id='demande_$dmde->id_demande' $dmde_action style='cursor: pointer'>";
				$list .= "<td colspan=8>".htmlentities($dmde->titre_demande,ENT_QUOTES,$charset)."</td>";
				$list .= "</tr>";	
				$req_act="select id_action, sujet_action,detail_action,date_action, deadline_action, temps_passe, cout, progression_action, actions_read_gestion 
				from demandes_actions 
				where num_demande='".$dmde->id_demande."'
				and type_action=1 
				and (statut_action=1 or statut_action=2)"; 
				$res_act=pmb_mysql_query($req_act,$dbh);
				if(pmb_mysql_num_rows($res_act)){						
					$parity=1;						
					while(($com = pmb_mysql_fetch_object($res_act))){
						if ($parity % 2) {
							$pair_impair = "even";
						} else {
							$pair_impair = "odd";
						}
						$parity += 1;
						$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" ";
						$action = "onclick=document.location='./demandes.php?categ=action&act=see&idaction=".$com->id_action."'";
						$list .= 
						"<tr class='$pair_impair' id='act_$com->id_action' $tr_javascript style='cursor: pointer'>
					 		<td>&nbsp;</td>
					 		<td $action>".htmlentities($com->sujet_action,ENT_QUOTES,$charset)."</td>
							<td $action>".htmlentities($com->detail_action,ENT_QUOTES,$charset)."</td>				
							<td $action>".htmlentities(formatdate($com->date_action),ENT_QUOTES,$charset)."</td>
							<td $action>".htmlentities($com->temps_passe.$msg['demandes_action_time_unit'],ENT_QUOTES,$charset)."</td>
							<td $action><img src=\"./images/jauge.png\" height='15px' width=\"".$com->progression_action."%\" title='".$com->progression_action."%' /></td>
							<td><input type='checkbox' id='chk[".$com->id_action."]' name='chk[]' value='".$com->id_action."'></td>
						</tr>";
					}
				} else $list = "<tr><td>".htmlentities($msg['demandes_no_com'],ENT_QUOTES,$charset)."</td></tr>";
			}
		} else $list = "<tr><td>".htmlentities($msg['demandes_no_com'],ENT_QUOTES,$charset)."</td></tr>";
		
		$btn_action = "<input type='submit' class='bouton' name='close_fil' id='close_fil' value='".$msg['demandes_action_close_fil']."' onclick='this.form.act.value=\"close_fil\"'>";
		$form_communication=str_replace('!!btn_action!!',$btn_action,$form_communication);
		$form_communication=str_replace('!!form_title!!',$msg['demandes_action_com'],$form_communication);
		$form_communication=str_replace('!!liste_comm!!',$list,$form_communication);
		
		$form_communication=str_replace('!!action!!','demandes.php?categ=action&sub=com',$form_communication);
		
		print $form_communication;
	}
	
	/*
	 * Liste des RDV planifiés
	 */
	function show_planning_form(){
		global $form_communication, $dbh, $charset, $msg;
		
		
		$req_dmde = "select id_demande, titre_demande from demandes
			join demandes_actions on num_demande=id_demande
			join demandes_users du on du.num_demande=id_demande
			and type_action=4 
			and statut_action=1 
			and num_user='".SESSuserid."' group by id_demande";
		$res_dmde=pmb_mysql_query($req_dmde,$dbh);
		if(pmb_mysql_num_rows($res_dmde)){
			while(($dmde=pmb_mysql_fetch_object($res_dmde))){
				$dmde_action = "onclick=document.location='./demandes.php?categ=gestion&act=see_dmde&iddemande=".$dmde->id_demande."'";
				$list .= "<tr id='demande_$dmde->id_demande' $dmde_action style='cursor: pointer'>";
				$list .= "<td colspan=8>".htmlentities($dmde->titre_demande,ENT_QUOTES,$charset)."</td>";
				$list .= "</tr>";	
				$req_act="select id_action, sujet_action,detail_action,date_action, deadline_action, temps_passe, cout, progression_action, actions_read_gestion  
				from demandes_actions 
				where num_demande='".$dmde->id_demande."'
				and type_action=4 
				and statut_action=1"; 
				$res_act=pmb_mysql_query($req_act,$dbh);
				if(pmb_mysql_num_rows($res_act)){						
					$parity=1;						
					while(($com = pmb_mysql_fetch_object($res_act))){
						if ($parity % 2) {
							$pair_impair = "even";
						} else {
							$pair_impair = "odd";
						}
						$parity += 1;
						$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" ";
						$action = "onclick=document.location='./demandes.php?categ=action&act=see&idaction=".$com->id_action."'";
						$list .= 
						"<tr class='$pair_impair' id='act_$com->id_action' $tr_javascript style='cursor: pointer'>
					 		<td>&nbsp;</td>
					 		<td $action>".htmlentities($com->sujet_action,ENT_QUOTES,$charset)."</td>
							<td $action>".htmlentities($com->detail_action,ENT_QUOTES,$charset)."</td>				
							<td $action>".htmlentities(formatdate($com->date_action),ENT_QUOTES,$charset)."</td>
							<td $action>".htmlentities($com->temps_passe.$msg['demandes_action_time_unit'],ENT_QUOTES,$charset)."</td>
							<td $action><img src=\"./images/jauge.png\" height='15px' width=\"".$com->progression_action."%\" title='".$com->progression_action."%' /></td>
							<td><input type='checkbox' id='chk[".$com->id_action."]' name='chk[]' value='".$com->id_action."'></td>
						</tr>";
					}
				} else $list = "<tr><td>".htmlentities($msg['demandes_no_rdv_plan'],ENT_QUOTES,$charset)."</td></tr>";
			}
		} else $list = "<tr><td>".htmlentities($msg['demandes_no_rdv_plan'],ENT_QUOTES,$charset)."</td></tr>";
		
		$btn_action = "<input type='submit' class='bouton' name='close_rdv' id='close_rdv' value='".$msg['demandes_action_close_rdv']."'  onclick='this.form.act.value=\"close_rdv\"'>";
		$form_communication=str_replace('!!btn_action!!',$btn_action,$form_communication);
		$form_communication=str_replace('!!form_title!!',$msg['demandes_menu_rdv_planning'],$form_communication);
		$form_communication=str_replace('!!liste_comm!!',$list,$form_communication);
		$form_communication=str_replace('!!action!!','demandes.php?categ=action&sub=rdv_plan',$form_communication);
		print $form_communication;
	}
	
	/*
	 * Formulaire qui gère l'affichage des actions
	 */
	function show_rdv_val_form(){
		global $form_communication, $dbh, $charset, $msg;
		
		$req_dmde = "select id_demande, titre_demande from demandes
			join demandes_actions on num_demande=id_demande
			join demandes_users du on du.num_demande=id_demande
			and type_action=4 
			and statut_action=2 
			and num_user='".SESSuserid."' group by id_demande";
		$res_dmde=pmb_mysql_query($req_dmde,$dbh);
		if(pmb_mysql_num_rows($res_dmde)){
			while(($dmde=pmb_mysql_fetch_object($res_dmde))){
				$dmde_action = "onclick=document.location='./demandes.php?categ=gestion&act=see_dmde&iddemande=".$dmde->id_demande."'";
				$list .= "<tr id='demande_$dmde->id_demande' $dmde_action style='cursor: pointer'>";
				$list .= "<td colspan=8>".htmlentities($dmde->titre_demande,ENT_QUOTES,$charset)."</td>";
				$list .= "</tr>";	
				$req_act="select id_action, sujet_action,detail_action,date_action, deadline_action, temps_passe, cout, progression_action, actions_read_gestion 
				from demandes_actions 
				where num_demande='".$dmde->id_demande."'
				and type_action=4 
				and statut_action=2"; 
				$res_act=pmb_mysql_query($req_act,$dbh);
				if(pmb_mysql_num_rows($res_act)){						
					$parity=1;						
					while(($com = pmb_mysql_fetch_object($res_act))){
						if ($parity % 2) {
							$pair_impair = "even";
						} else {
							$pair_impair = "odd";
						}
						$parity += 1;
						$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" ";
						$action = "onclick=document.location='./demandes.php?categ=action&act=see&idaction=".$com->id_action."'";
						$list .= 
						"<tr class='$pair_impair' id='act_$com->id_action' $tr_javascript style='cursor: pointer'>
					 		<td>&nbsp;</td>
					 		<td $action>".htmlentities($com->sujet_action,ENT_QUOTES,$charset)."</td>
							<td $action>".htmlentities($com->detail_action,ENT_QUOTES,$charset)."</td>				
							<td $action>".htmlentities(formatdate($com->date_action),ENT_QUOTES,$charset)."</td>
							<td $action>".htmlentities($com->temps_passe.$msg['demandes_action_time_unit'],ENT_QUOTES,$charset)."</td>
							<td $action><img src=\"./images/jauge.png\" height='15px' width=\"".$com->progression_action."%\" title='".$com->progression_action."%' /></td>
							<td><input type='checkbox' id='chk[".$com->id_action."]' name='chk[]' value='".$com->id_action."'></td>
						</tr>";
					}
				} else $list = "<tr><td>".htmlentities($msg['demandes_no_rdv_val'],ENT_QUOTES,$charset)."</td></tr>";
			}
		} else $list = "<tr><td>".htmlentities($msg['demandes_no_rdv_val'],ENT_QUOTES,$charset)."</td></tr>";
		
		$btn_action = "<input type='submit' class='bouton' name='val_rdv' id='val_rdv' value='".$msg['demandes_action_valid_rdv']."' onclick='this.form.act.value=\"val_rdv\"'>";
		$form_communication=str_replace('!!btn_action!!',$btn_action,$form_communication);
		$form_communication=str_replace('!!form_title!!',$msg['demandes_menu_rdv_a_valide'],$form_communication);
		$form_communication=str_replace('!!liste_comm!!',$list,$form_communication);
		$form_communication=str_replace('!!action!!','demandes.php?categ=action&sub=rdv_val',$form_communication);
		print $form_communication;
	}
	
	/*
	 * Ferme toutes les discussions en cours
	 */
	function close_fil(){
		global $chk, $dbh;
		
		for($i=0;$i<count($chk);$i++){		
			$req = "update demandes_actions set statut_action=3 where id_action='".$chk[$i]."'";
			pmb_mysql_query($req,$dbh);
		}
	}
	
	/*
	 * Annule tous les RDV
	 */
	function close_rdv(){
		global $chk, $dbh;
		
		for($i=0;$i<count($chk);$i++){		
			$req = "update demandes_actions set statut_action=3 where id_action='".$chk[$i]."'";
			pmb_mysql_query($req,$dbh);
		}
	}
	
	/*
	 * Valide tous les RDV
	 */
	function valider_rdv(){
		global $chk, $dbh;
		
		for($i=0;$i<count($chk);$i++){		
			$req = "update demandes_actions set statut_action=1 where id_action='".$chk[$i]."'";
			pmb_mysql_query($req,$dbh);
		}
	}
	
	/*
	 * Retourne le nom de celui qui a créé l'action
	 */
	function getCreateur($id_createur,$type_createur=0){
		global $dbh;
		
		if(!$type_createur)
			$rqt = "select concat(prenom,' ',nom) as nom, username from users where userid='".$id_createur."'";
		else 
			$rqt = "select concat(empr_prenom,' ',empr_nom) as nom from empr where id_empr='".$id_createur."'";
		
		$res = pmb_mysql_query($rqt,$dbh);
		if(pmb_mysql_num_rows($res)){		
			$createur = pmb_mysql_fetch_object($res);			
			return (trim($createur->nom)  ? $createur->nom : $createur->username );
		}		
		return "";
	}
	
	/*
	 * fonction qui renvoie un booléen indiquant si une action a été lue ou pas
	*/
	static function read($action,$side="_opac"){
		global $dbh;
		$read  = false;
		$query = "SELECT actions_read".$side." FROM demandes_actions WHERE id_action=".$action->id_action;
		$result = pmb_mysql_query($query,$dbh);
		if($result){
			$tmp = pmb_mysql_result($result,0,0);
			if($tmp == 0){
				$read = true;
			}
		}
		return $read;
	}
	
	/*
	 * Change l'alerte de l'action : si elle est lue, elle passe en non lue et inversement
	*/
	static function change_read($action,$side="_opac"){
		global $dbh;
		
		$read = demandes_actions::read($action,$side);
		$value = "";
		if($read){
			$value = 1;
		} else {
			$value = 0;
		}
		$query = "UPDATE demandes_actions SET actions_read".$side."=".$value." WHERE id_action=".$action->id_action;
		if(pmb_mysql_query($query,$dbh)){
			return true;
		} else {
			return false;
		}
	}
	
	/*
	 * changement forcé de la mention "lue" ou "pas lue" de l'action
	*/
	static function action_read($id_action,$booleen=true, $side="_opac"){
		global $dbh;
		
		$value = "";
		if($booleen){
			$value = 0;
		} else {
			$value = 1;
		}
		$query = "UPDATE demandes_actions SET actions_read".$side."=".$value." WHERE id_action=".$id_action;
		pmb_mysql_query($query,$dbh);		
	}
	
	/*
	 * Met à jour les alertes sur l'action et la demande dont dépend la note
	*/
	static function action_majParentEnfant($id_action,$id_demande,$side="_opac"){
		global $dbh;
	
		$ok = false;
		if($id_action){
	
			$select = "SELECT actions_read".$side." FROM demandes_actions WHERE id_action=".$id_action;
			$result  = pmb_mysql_query($select,$dbh);
			$read = pmb_mysql_result($result,0,0);
	
			if($read == 1){
				if(demandes::demande_read($id_demande,false,$side)){
					$ok = true;
				}
			} else {
				// maj notes : si l'action est lue, on met à 0 toutes les notes
				$query = "UPDATE demandes_notes SET notes_read".$side." = 0 WHERE num_action=".$id_action;
				if(pmb_mysql_query($query,$dbh)){
					// maj demande : controle s'il existe des actions non lues pour la demande en cours
					$query = "SELECT actions_read".$side." FROM demandes_actions WHERE num_demande=".$id_demande." AND id_action != ".$id_action." AND actions_read".$side."=1";
					$result = pmb_mysql_query($query,$dbh);
					if(pmb_mysql_num_rows($result)){
						$ok = demandes::demande_read($id_demande,false,$side);
					} else {
						$ok = demandes::demande_read($id_demande,true,$side);
					}
				}
			}
		}
		return $ok;
	}
}
?>