static function change_read($demande, $side = "_opac") { global $dbh; $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, $dbh)) { return true; } else { return false; } }
static function dmde_propageLu($id_demande, $side = "_gestion") { global $dbh; 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; $result1 = pmb_mysql_query($query1, $dbh); $query2 = "SELECT id_action FROM demandes_actions WHERE num_demande=" . $id_demande; $result2 = pmb_mysql_query($query2, $dbh); 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, $dbh); } } return "lu"; } else { return "nonlu"; } } }