function getUserMandatoryFields($id_user)
{
$acl = new DoceboACL();
$user_groups = $acl->getUserGroupsST($id_user);
$output = array();
if (!empty($user_groups)) {
$query = "SELECT ft.id_common, ft.translation, ft.type_field, gft.useraccess, fet.user_entry " . " FROM (" . $this->getFieldTable() . " AS ft " . " JOIN " . $this->getGroupFieldsTable() . " AS gft " . " JOIN " . $this->getTypeFieldTable() . " AS ftt " . " ON (ft.id_common = gft.id_field AND ft.lang_code = '" . getLanguage() . "' AND ft.type_field = ftt.type_field)) " . " LEFT JOIN " . $this->getFieldEntryTable() . " AS fet " . " ON (fet.id_common = ft.id_common AND fet.id_user = "******") " . " WHERE gft.idst IN ('" . implode("','", $user_groups) . "') " . " AND gft.mandatory = 1 " . " ORDER BY ft.sequence";
$res = sql_query($query);
if ($res) {
while ($obj = sql_fetch_object($res)) {
$output[$obj->id_common] = array('translation' => $obj->translation, 'type_field' => $obj->type_field, 'useraccess' => $obj->useraccess, 'user_entry' => $obj->user_entry);
}
}
}
return $output;
}
