public static function showEditDatabase($params)
{
if (!\mod\user\Main::userIsLoggedIn() || (!\mod\user\Main::userBelongsToGroup('Admin') && !\mod\arkeogis\ArkeoGIS::isDatabaseOwner((int) $params['id'], \mod\user\Main::getUserId($_SESSION['login'])) || !$params['id'])) {
return false;
}
$scaleTranslations = array('site' => 'Site', 'watershed' => 'Bassin versant', 'micro-region' => 'Micro-région', 'region' => 'Région', 'country' => 'Pays', 'europe' => 'Europe');
$databaseInfos = array();
$ret = ArkeoGIS::getFullDatabaseInfos((int) $params['id']);
$smarty = \mod\smarty\Main::newSmarty();
$ret[0]['published'] = $ret[0]['published'] ? 1 : 0;
$smarty->assign('infos', $ret[0]);
$response = array('title' => \mod\lang\Main::ch_t('arkeogis', 'Edition of the base') . ' ' . $ret[0]['name'], 'content' => $smarty->fetch('arkeogis/databasesEdit'));
$response['footer'] = '<input type="button" class="btn btn-primary" value="' . \mod\lang\Main::ch_t('arkeogis', 'Modifier') . '" onclick="editDatabase(' . $ret[0]['id'] . ')" />';
$response['footer'] .= '<input type="button" class="btn" value="' . \mod\lang\Main::ch_t('arkeogis', 'Fermer') . '" onclick="modalWin.hide()" />';
return $response;
}
public static function yesno($val)
{
return $val ? \mod\lang\Main::ch_t('arkeogis', 'oui') : \mod\lang\Main::ch_t('arkeogis', 'non');
}
public static function hook_mod_arkeogis_export_sheet($hookname, $userdata, $urlmatches)
{
if (!\mod\user\Main::userIsLoggedIn()) {
return self::hook_mod_arkeogis_public($hookname, $userdata);
}
if (!\mod\user\Main::userBelongsToGroup('Admin') && !\mod\user\Main::userBelongsToGroup('Chercheur')) {
return self::display_html_error(\mod\lang\Main::ch_t('arkeogis', "Vous n'avez pas la permission de télécharger au format csv"));
}
$q = json_decode(urldecode($urlmatches[1]), true);
$columns = "ark_site.si_id, si_code, si_name, si_description, si_city_name, si_city_code, ST_AsGeoJSON(si_geom) as coords, si_centroid, si_occupation, si_creation, si_modification";
// ark_site
$columns .= ", da_name, da_description, da_creation, da_modification";
// ark_database
$columns .= ", ark_site_period.sp_id, sp_knowledge_type, sp_comment, sp_bibliography";
// ark_site_period
$columns .= ", (SELECT node_path FROM ark_period WHERE pe_id=sp_period_start) AS period_start";
$columns .= ", (SELECT node_path FROM ark_period WHERE pe_id=sp_period_end) AS period_end";
$res = ArkeoGIS::search_sites($q, $columns, array('ark_city' => false, 'ark_database' => true), false, 'ark_site.si_id, ark_site_period.sp_id, da_id', '', 'ark_site.si_code, ark_site.si_id, ark_site_period.sp_id', false, false);
\mod\arkeogis\ArkeoGIS::sitesToCsv($res['sites']);
}
