";
$btn_suppr = "";
}
if(!$last_modified){
$list_actions = str_replace('!!last_modified!!','',$list_actions);
}
$list_actions = str_replace('!!iddemande!!',$id_demande,$list_actions);
$list_actions = str_replace('!!btn_suppr!!',$btn_suppr,$list_actions);
$list_actions = str_replace('!!liste_action!!',$liste,$list_actions);
if($from_ajax) {
$list_actions = str_replace('!!change_action_form!!','this.form.action="./demandes.php?categ=action";',$list_actions);
} else {
$list_actions = str_replace('!!change_action_form!!','',$list_actions);
}
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));
}
";
} else {
$script="";
}
$list_actions = str_replace('!!script_expand!!',$script,$list_actions);
return $list_actions;
}
/*
* Suppression d'une action
*/
public static function delete(demandes_actions $action) {
if (!empty($action->id_action)) {
$action->fetch_data($action->id_action, false);
if (!empty($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);
$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);
audit::delete_audit(AUDIT_ACTION, $action->id_action);
}
}
/*
* Ferme toutes les discussions en cours
*/
public function close_fil(){
global $chk;
$nb_fil = 0;
if (is_array($chk)) {
$nb_fil = count($chk);
}
for ($i = 0; $i < $nb_fil; $i++) {
$req = "update demandes_actions set statut_action=3 where id_action='".$chk[$i]."'";
pmb_mysql_query($req);
}
}
/*
* Annule tous les RDV
*/
public function close_rdv(){
global $chk;
$nb_rdv = 0;
if (is_array($chk)) {
$nb_rdv = count($chk);
}
for ($i = 0; $i < $nb_rdv; $i++) {
$req = "update demandes_actions set statut_action=3 where id_action='".$chk[$i]."'";
pmb_mysql_query($req);
}
}
/*
* Valide tous les RDV
*/
public function valider_rdv(){
global $chk;
$nb_rdv = 0;
if (is_array($chk)) {
$nb_rdv = count($chk);
}
for ($i = 0; $i < $nb_rdv; $i++) {
$req = "update demandes_actions set statut_action=1 where id_action='".$chk[$i]."'";
pmb_mysql_query($req);
}
}
public function get_demande() {
if(!isset($this->demande)) {
$this->demande = new demandes($this->num_demande);
}
return $this->demande;
}
/*
* Retourne le nom de celui qui a créé l'action
*/
public function getCreateur($id_createur,$type_createur=0){
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);
if(pmb_mysql_num_rows($res)){
$createur = pmb_mysql_fetch_object($res);
return (trim($createur->nom) ? $createur->nom : $createur->username );
}
return "";
}
public function get_id() {
return $this->id_action;
}
/*
* fonction qui renvoie un booléen indiquant si une action a été lue ou pas
*/
public static function read($action,$side="_gestion"){
$read = false;
$query = "SELECT actions_read".$side." FROM demandes_actions WHERE id_action=".$action->id_action;
$result = pmb_mysql_query($query);
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
*/
public static function change_read($action,$side="_gestion"){
$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)){
return true;
} else {
return false;
}
}
/*
* changement forcé de la mention "lue" ou "pas lue" de l'action
* true => action est déjà lue doc pas d'alerte
* false => alerte
*/
public static function action_read($id_action,$booleen=true,$side="_gestion"){
$value = "";
if($booleen){
$value = 0;
} else {
$value = 1;
}
$query = "UPDATE demandes_actions SET actions_read".$side."=".$value." WHERE id_action=".$id_action;
if(pmb_mysql_query($query)){
return true;
} else {
return false;
}
}
/*
* Met à jour les alertes sur l'action et la demande dont dépend la note
*/
public static function action_majParentEnfant($id_action,$id_demande,$side="_gestion"){
$ok = false;
if($id_action){
$select = "SELECT actions_read".$side." FROM demandes_actions WHERE id_action=".$id_action;
$result = pmb_mysql_query($select);
$read = pmb_mysql_result($result,0,0);
if($read == 1){
if(demandes::demande_read($id_demande,false)){
$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)){
// 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);
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;
}
}
?>