/**
* Constructor
*
* Create the class
*
* @param mixed MDB2 class
* @param array options (?)
* @return void
*/
public function __construct(MDB2_Driver_Common $db, $options = array())
{
$defaultOptions = array('schema' => 'public', 'dbtype' => 'pgsql');
$this->options = array_merge($defaultOptions, $options);
$this->dbUtils = R3DbCatalog::factory($this->options['dbtype'], $db, $this->options);
$this->db = $db;
$this->db->loadModule('Extended');
}
/**
* Return the UDM
* @param array $request the request
* @return array the result data
*/
public function confirmDeleteCustomer($request)
{
global $mdb2;
$db = ezcDbInstance::get();
$catalog = R3DbCatalog::factory('pgsql', $mdb2);
$data = $this->auth->getDomainData($request['id']);
if ($this->isMultiDomain()) {
$schema = 'geo_' . $data['dn_name'];
} else {
$schema = 'geo';
}
$check = array('fraction_data' => 'frazioni', 'street_data' => 'strade', 'cat_munic_data' => 'comuni catastali', 'building_data' => 'edifici', 'action_catalog_data' => 'catalogo azioni', 'simulation_work_data' => 'simulazioni', 'global_plain_data' => 'parametri generali PAES', 'global_entry_data' => 'inventario emissioni', 'global_strategy_data' => 'PAES', 'utility_supplier' => 'Fornitori di energia');
$do_id = (int) $data['do_id'];
foreach ($check as $table => $text) {
if ($db->query("SELECT COUNT(*) FROM {$table} WHERE do_id={$do_id}")->fetchColumn() > 0) {
return array('status' => R3_AJAX_NO_ERROR, 'alert' => _("Impossibile cancellare l'ente {$data['dn_name']} perchè esistono {$text}"));
}
}
return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare definitivamente l'ente \"{$data['dn_name']}\" e tutti i dati ad esso associato?"), 'name'));
}
public static function set($instance)
{
return R3DbCatalog::$instance = $instance;
}
