get_all();
if(count($audit->all_audit) == 1){
$all[0] = $audit->get_creation() ;
} else {
$all[0] = $audit->get_creation() ;
$all[1] = $audit->get_last() ;
}
break;
case '2':
$audit = new audit($type_obj, $object_id) ;
$audit->get_all() ;
$all = $audit->all_audit ;
break;
default:
case '0':
echo "" ;
break;
}
$audit_list = "
".$msg['audit_col_userid']." | ".$msg['audit_col_username']." | ".$msg['audit_col_type_action']." | ".$msg['audit_col_date_heure']." | ".$msg['audit_col_nom']." | ".$msg['audit_comment']." |
";
while(list($cle, $valeur) = each($all)) {
//user_id, user_name, type_modif, quand, concat(prenom, ' ', nom) as prenom_nom
$info=json_decode($valeur->info);
$info_display="";
if(is_object($info)){
if($info->comment)$info_display.=$info->comment."
";
if(count($info->fields)){
foreach($info->fields as $fieldname => $values){
if(is_object($values)){
$info_display.=$fieldname." : ".$values->old." => ".$values->new."
";
}
}
}
}else $info_display=$valeur->info;
$audit_list .= "
$valeur->user_id |
$valeur->user_name |
".$msg['audit_type'.$valeur->type_modif]." |
$valeur->aff_quand |
$valeur->prenom_nom |
".$info_display." |
";
}
$audit_list .= "
";
echo $audit_list ;
if ($type_obj == 1 || $type_obj == 3) { //Audit notices/notices de bulletin
if ($type_obj == 1) {
$requete = "SELECT * FROM notices WHERE notice_id='$object_id' LIMIT 1 ";
} else {
$requete = "SELECT * FROM notices, bulletins WHERE num_notice = notice_id AND bulletin_id='$object_id' LIMIT 1 ";
}
$result = pmb_mysql_query($requete, $dbh);
if(pmb_mysql_num_rows($result)) {
$notice = pmb_mysql_fetch_object($result);
$create_date = new DateTime($notice->create_date);
$update_date = new DateTime($notice->update_date);
echo "
";
echo htmlentities($msg["noti_crea_date"],ENT_QUOTES, $charset)." ".$create_date->format('d/m/Y H:i:s')."
";
echo htmlentities($msg["noti_mod_date"],ENT_QUOTES, $charset)." ".$update_date->format('d/m/Y H:i:s')."
";
}
}
pmb_mysql_close($dbh);