function handler_index($page)
{
if (Platal::globals()->merge->state == 'pending') {
$page->changeTpl('fusionax/index.tpl');
} elseif (Platal::globals()->merge->state == 'done') {
$issueList = array('name' => 'noms', 'job' => 'emplois', 'address' => 'adresses', 'promo' => 'promotions', 'deathdate' => 'dates de décès', 'phone' => 'téléphones', 'education' => 'formations');
$issues = XDB::rawFetchOneAssoc("SELECT COUNT(*) AS total,\n SUM(FIND_IN_SET('name', issues)) DIV 1 AS name,\n SUM(FIND_IN_SET('job', issues)) DIV 2 AS job,\n SUM(FIND_IN_SET('address', issues)) DIV 3 AS address,\n SUM(FIND_IN_SET('promo', issues)) DIV 4 AS promo,\n SUM(FIND_IN_SET('deathdate', issues)) DIV 5 AS deathdate,\n SUM(FIND_IN_SET('phone', issues)) DIV 6 AS phone,\n SUM(FIND_IN_SET('education', issues)) DIV 7 AS education\n FROM profile_merge_issues\n WHERE issues IS NOT NULL OR issues != ''");
$page->changeTpl('fusionax/issues.tpl');
$page->assign('issues', $issues);
$page->assign('issueList', $issueList);
}
}
