Members Directory
Uniting and promoting women
in alternative dispute resolution
in alternative dispute resolution
Publication of any news on this page is at the discretion of the Board.
Publication of any news on this page is at the discretion of the Board.
{source raw="true"}
getIdentity();
// Obtém o objeto da base de dados
$db = Factory::getDbo();
// Monta a query, substituindo item_id pelo ID do usuário logado
$query = " SELECT CASE WHEN (cnt * 100.0 / 30) < 100 THEN ROUND((cnt * 100.0 / 30), 2) ELSE 100 END AS message FROM ( SELECT COUNT(Distinct(field_id)) AS cnt FROM trqi_fields_values WHERE field_id IN (13,14,15,17,25,27,33,37,47,48,66,67,68,78) AND item_id = " . (int) $user->id . " AND value IS NOT NULL AND TRIM(value) <> '' AND value <> '[]' ) t ";
// Define a query no objeto de banco de dados
$db->setQuery($query);
// Executa a query e carrega o resultado (a mensagem)
$result = $db->loadResult();
if ($result >= 0 && $result <= 25) {
$progress_color = 'bg-danger';
} elseif ($result >= 26 && $result <= 50) {
$progress_color = 'bg-warning';
} elseif ($result >= 51 && $result <= 90) {
$progress_color = 'bg-primary';
} elseif ($result == 100) {
$progress_color = 'bg-success';
} else {
// Caso o valor não se encaixe nas condições acima
$progress_color = '';
}
// Exibe a mensagem na página
echo ("Your profile is " . $result . " completed")
?>
{/source}
We note that you have not yet paid your membership fees. In order to complete your profile and feature in the ArbitralWomen Members Directory, we request you to pay your membership fees, click here to proceed.