";
$check = "";
$check_index = "";
}
$btn_attach = "";
$form_liste_docnum = str_replace('!!btn_attach!!',$btn_attach,$form_liste_docnum);
} else {
$liste = htmlentities($msg['demandes_no_docnum'],ENT_QUOTES,$charset);
$form_liste_docnum = str_replace('!!btn_attach!!','',$form_liste_docnum);
}
$form_liste_docnum = str_replace('!!liste_docnum!!',$liste,$form_liste_docnum);
$form_liste_docnum = str_replace('!!iddemande!!',$this->id_demande,$form_liste_docnum);
print $form_liste_docnum;
}
/*
* Attache les documents numériques à la notice
*/
public function attach_docnum(){
global $chk, $ck_index, $pmb_indexation_docnum;
for($i=0;$inum_notice."','".addslashes($expl->nom)."','".addslashes($expl->nom)."','".addslashes($expl->mime)."','".addslashes($expl->data)."','".addslashes($expl->ext)."')";
pmb_mysql_query($req);
$id_explnum = pmb_mysql_insert_id();
$req = "update explnum_doc_actions set num_explnum='".$id_explnum."' where num_explnum_doc='".$chk[$i]."'";
pmb_mysql_query($req);
if($ck_index[$i] && $pmb_indexation_docnum){
$expl = new explnum($id_explnum);
$expl->indexer_docnum();
}
}
}
//On désattache les autres
if($chk){
$req = "select id_explnum_doc from explnum_doc where id_explnum_doc not in ('".implode('\',\'',$chk)."')";
$res = pmb_mysql_query($req);
while(($expl = pmb_mysql_fetch_object($res))){
$req = "delete e from explnum e
join explnum_doc_actions on num_explnum=explnum_id
where num_explnum_doc='".$expl->id_explnum_doc."'";
pmb_mysql_query($req);
$req = "update explnum_doc_actions set num_explnum='0' where num_explnum_doc='".$expl->id_explnum_doc."'";
pmb_mysql_query($req);
}
} else {
$req ="select id_explnum_doc
from explnum_doc
join explnum_doc_actions on num_explnum_doc=id_explnum_doc
join demandes_actions on num_action=id_action
where num_explnum != 0
and num_demande='".$this->id_demande."'";
$res = pmb_mysql_query($req);
while(($expl = pmb_mysql_fetch_object($res))){
$req = "delete e from explnum e
join explnum_doc_actions on num_explnum=explnum_id
where num_explnum_doc='".$expl->id_explnum_doc."'";
pmb_mysql_query($req);
$req = "update explnum_doc_actions set num_explnum='0' where num_explnum_doc='".$expl->id_explnum_doc."'";
pmb_mysql_query($req);
}
}
}
/*
* Affiche le formulaire de création/modification d'une notice
*/
public function show_notice_form(){
// affichage du form de création/modification d'une notice
$myNotice = new notice($this->num_notice);
if(!$myNotice->id) {
$myNotice->tit1 = $this->titre_demande;
}
$myNotice->action = "./demandes.php?categ=gestion&act=upd_notice&iddemande=".$this->id_demande."&id=";
$myNotice->link_annul = $this->get_gestion_link();
print $myNotice->show_form();
}
/*
* Formulaire de validation de la suppression de notice
*/
public function suppr_notice_form(){
global $msg, $chk, $iddemande, $current_module;
$display = "
";
print $display;
}
public function attribuer(){
global $chk, $iduser;
for($i=0;$ititre_demande."',
n_contenu='".$this->sujet_demande."',
statut ='".$demandes_statut_notice."'
";
pmb_mysql_query($req);
$id_notice = pmb_mysql_insert_id();
notice::majNotices($id_notice);
if($pmb_type_audit) audit::insert_creation(AUDIT_NOTICE,$id_notice);
// mise à jour de la demande
$req = "UPDATE demandes SET num_notice=".$id_notice." WHERE id_demande=".$this->id_demande;
pmb_mysql_query($req);
$this->num_notice=$id_notice;
}
public function delete_notice(){
notice::del_notice($this->num_notice);
// mise à jour de la demande
$req = "UPDATE demandes SET num_notice=0 WHERE id_demande=".$this->id_demande;
pmb_mysql_query($req);
$this->num_notice=0;
}
// mise à jour de l'alerte en fonction des alertes présentes sur les actions de la demande en cours
public static function dmde_majRead($id_demande,$side="_gestion"){
// on teste s'il y a des actions non lues
$query = "SELECT id_action FROM demandes_actions WHERE num_demande=".$id_demande. " AND actions_read".$side."=1";
$result = pmb_mysql_query($query);
$value=0;
if(pmb_mysql_num_rows($result)){
$value=1;
} else {
// sinon, on teste si la demande est non lue et non validée en gestion et s'il n'y a aucune action de crée
$query = "SELECT id_action FROM demandes_actions WHERE num_demande=".$id_demande;
$res = pmb_mysql_query($query);
if(!pmb_mysql_num_rows($res)){
$query = "SELECT dmde_read".$side.", etat_demande FROM demandes WHERE id_demande=".$id_demande;
$res2 = pmb_mysql_query($query);
if(pmb_mysql_num_rows($res2)){
$etat = pmb_mysql_result($res2,0,"etat_demande");
$read = pmb_mysql_result($res2,0,"dmde_read".$side);
if($etat == 1 && $read == 1){
$value = 1;
}
}
}
}
$query2 = "UPDATE demandes SET dmde_read".$side."=".$value." WHERE id_demande=".$id_demande;
pmb_mysql_query($query2);
return $value;
}
// fonction qui renvoie un booléen indiquant si une demande a été lue ou pas
public static function read($demande,$side="_gestion"){
$read = false;
$query = "SELECT dmde_read".$side." FROM demandes WHERE id_demande=".$demande->id_demande;
$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 la demande : si elle est lue, elle passe en non lue et inversement
*/
public static function change_read($demande,$side="_gestion"){
$read = demandes::read($demande,$side);
$value = "";
if($read){
$value = 1;
} else {
$value = 0;
}
$query = "UPDATE demandes SET dmde_read".$side."=".$value." WHERE id_demande=".$demande->id_demande;
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 donc pas d'alerte
* false => alerte
*/
public static function demande_read($id_demande,$booleen=true,$side="_gestion"){
$value = "";
if($booleen){
$value = 0;
} else {
$value = 1;
}
$query = "UPDATE demandes SET dmde_read".$side."=".$value." WHERE id_demande=".$id_demande;
if(pmb_mysql_query($query)){
return true;
} else {
return false;
}
}
// mise à jour de l'alerte sur les actions et les notes de la demande
public static function dmde_propageLu($id_demande,$side="_gestion"){
if($id_demande){
$dmde = new demandes($id_demande);
$read = demandes::read($dmde,$side);
if($read){
$query1 = "UPDATE demandes_actions SET actions_read".$side."=0 WHERE num_demande=".$id_demande;
pmb_mysql_query($query1);
$query2 = "SELECT id_action FROM demandes_actions WHERE num_demande=".$id_demande;
$result2 = pmb_mysql_query($query2);
if(pmb_mysql_num_rows($result2)){
while($action = pmb_mysql_fetch_object($result2)){
$query3 = "UPDATE demandes_notes SET notes_read".$side."=0 WHERE num_action=".$action->id_action;
pmb_mysql_query($query3);
}
}
return "lu";
} else {
return "nonlu";
}
}
}
/*
* Formulaire de création d'une demande
*/
public function show_repfinale_form(){
global $form_reponse_final, $msg, $charset, $pmb_javascript_office_editor,$base_path;
if($pmb_javascript_office_editor){
print $pmb_javascript_office_editor;
print "";
}
$form_reponse_final = str_replace('!!titre_dmde!!',htmlentities($this->titre_demande,ENT_QUOTES,$charset),$form_reponse_final);
$form_reponse_final = str_replace('!!form_title!!',htmlentities($msg['demandes_reponse_finale'],ENT_QUOTES,$charset),$form_reponse_final);
$form_reponse_final = str_replace('!!theme_dmde!!',htmlentities($this->theme_libelle,ENT_QUOTES,$charset),$form_reponse_final);
$form_reponse_final = str_replace('!!type_dmde!!',htmlentities($this->type_libelle,ENT_QUOTES,$charset),$form_reponse_final);
$form_reponse_final = str_replace('!!sujet_dmde!!',htmlentities($this->sujet_demande,ENT_QUOTES,$charset),$form_reponse_final);
$form_reponse_final = str_replace('!!iddemande!!',htmlentities($this->id_demande,ENT_QUOTES,$charset),$form_reponse_final);
$act_cancel = "document.location='".$this->get_gestion_link()."'";
$act_form = "./demandes.php?categ=gestion";
if(!$this->reponse_finale){
$form_reponse_final = str_replace('!!reponse!!','',$form_reponse_final);
$form_reponse_final = str_replace('!!btn_suppr!!','',$form_reponse_final);
} else {
$form_reponse_final = str_replace('!!reponse!!',htmlentities($this->reponse_finale,ENT_QUOTES,$charset),$form_reponse_final);
$btn_suppr = "";
$form_reponse_final = str_replace('!!btn_suppr!!',$btn_suppr,$form_reponse_final);
}
$form_reponse_final = str_replace('!!form_action!!',$act_form,$form_reponse_final);
$form_reponse_final = str_replace('!!cancel_action!!',$act_cancel,$form_reponse_final);
print $form_reponse_final;
}
/*
* Formulaire de création d'une demande
*/
public function save_repfinale($id_note=0){
global $f_message;
$f_message=strip_tags($f_message);
if($this->id_demande){
$query = "UPDATE demandes SET reponse_finale='".$f_message."', demande_note_num=$id_note WHERE id_demande=".$this->id_demande;
pmb_mysql_query($query);
}
}
/*
* Formulaire de création d'une demande
*/
public function suppr_repfinale(){
if($this->id_demande){
$query = "UPDATE demandes SET reponse_finale='' WHERE id_demande=".$this->id_demande;
pmb_mysql_query($query);
}
}
/**
* Retourne l'identifiant de la notice liée
* @return int
*/
public function get_num_linked_notice() {
return $this->num_linked_notice;
}
/**
* Setter de l'identifiant de la notice liée à la demande
* @param int $num_linked_notice
*/
public function set_num_linked_notice($num_linked_notice) {
$this->num_linked_notice = $num_linked_notice;
}
public function get_gestion_link(){
global $base_path;
return $base_path.'/demandes.php?categ=gestion&act=see_dmde&iddemande='.$this->id_demande;
}
public function get_id() {
return $this->id_demande;
}
}
?>