private static function _postProcess($filepath, $nbLines, $uid)
{
if (!isset(self::$_database['id'])) {
return false;
}
$filename = md5(file_get_contents($filepath));
if (!rename($filepath, dirname(__FILE__) . '/files/import/' . $filename)) {
throw new \Exception("Unable to move \"{$filepath}\".");
}
\mod\arkeogis\ArkeoGIS::updateDatabase(self::$_database['id'], array('lines' => $nbLines, 'sites' => self::$_nbSites, 'period_start' => \mod\arkeogis\ArkeoGIS::getPeriodIdFromPath(self::$_temporalBounds['start']), 'period_end' => \mod\arkeogis\ArkeoGIS::getPeriodIdFromPath(self::$_temporalBounds['end'])));
\mod\arkeogis\ArkeoGIS::deleteLastCsv(self::$_database['id'], $filename);
\mod\arkeogis\ArkeoGIS::writeDatabaseLog(self::$_database['id'], $uid, $filename);
}
public static function deleteDatabase($params)
{
if (!\mod\user\Main::userIsLoggedIn() || !\mod\user\Main::userBelongsToGroup('Admin') || !$params['id']) {
return false;
}
\mod\arkeogis\ArkeoGIS::deleteDatabase($params['id']);
return true;
}
public static function hook_mod_arkeogis_export_database($hookname, $userdata, $matches)
{
$dbId = (int) $matches[1];
if (!\mod\user\Main::userIsLoggedIn() || (!\mod\user\Main::userBelongsToGroup('Admin') && !\mod\arkeogis\ArkeoGIS::isDatabaseOwner($dbId, \mod\user\Main::getUserId($_SESSION['login'])) || !$dbId)) {
return false;
}
$q = "SELECT 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
$q .= ", da_name, da_description, da_creation, da_modification";
// ark_database
$q .= ", sp_id, sp_knowledge_type, sp_comment, sp_bibliography";
// ark_site_period
$q .= ", (SELECT node_path FROM ark_period WHERE pe_id=sp_period_start) AS period_start";
$q .= ", (SELECT node_path FROM ark_period WHERE pe_id=sp_period_end) AS period_end";
$q .= " FROM ark_site s LEFT JOIN ark_database d ON s.si_database_id = d.da_id LEFT JOIN ark_site_period sp ON s.si_id = sp.sp_site_id";
$q .= " WHERE da_id = ?";
$q .= " GROUP BY si_id, sp_id, da_id";
$q .= " ORDER BY si_code, si_id, sp_id";
$infos = \mod\arkeogis\ArkeoGIS::getFullDatabaseInfos($dbId);
$name = str_replace(' ', '_', \core\Tools::removeAccents($infos[0]['name']));
$author = str_replace(' ', '_', \core\Tools::removeAccents($infos[0]['author']));
$filename = 'ArkeoGIS-export-' . date("d-m-Y-H-i") . '-' . $name . '-' . $author;
\mod\arkeogis\ArkeoGIS::sitesToCsv(\core\Core::$db->fetchAll($q, array((int) $dbId)), $filename);
}