/** * Return the data for a single customer */ public function getData($id = null) { $lang = R3Locale::getLanguageID(); if ($id === null) { $id = $this->id; } $db = ezcDbInstance::get(); if ($this->act == 'add') { $vlu = array(); $vlu['bu_id'] = $this->bu_id; $vlu['us_id'] = null; $vlu['es_id'] = null; $vlu['is_producer'] = 'F'; $vlu['em_is_production'] = 'F'; $vlu['devices'] = 0; $vlu['consumptions'] = 0; } else { $q = $db->createSelectQuery(); $q->select('*')->from('energy_meter_data')->where('em_id=' . (int) $id); $vlu = $db->query($q)->fetch(PDO::FETCH_ASSOC); $this->bu_id = $vlu['bu_id'] = $vlu['em_object_id']; $vlu['devices'] = $db->query('SELECT COUNT(*) FROM device WHERE em_id=' . (int) $id)->fetchColumn(); $vlu['consumptions'] = $db->query('SELECT COUNT(*) FROM consumption WHERE em_id=' . (int) $id)->fetchColumn(); if ($vlu['us_id'] > 0) { $vlu['es_id'] = null; } $vlu = array_merge($vlu, R3EcoGisHelper::getChangeLogData('energy_meter', $vlu['em_id'])); } $data = R3EcoGisHelper::getBuildingData($vlu['bu_id']); $this->mu_id = $data['mu_id']; $this->data = $vlu; // Save the data (prevent multiple sql) return $vlu; }
/** * Return the data for a single customer */ public function getData($id = null) { $lang = R3Locale::getLanguageID(); if ($id === null) { $id = $this->id; } $db = ezcDbInstance::get(); if ($this->act == 'add') { $vlu = array(); if ($this->kind == 'street_lighting') { $data = $this->getElectricityUDMData($_SESSION['do_id']); $vlu['em_data']['udm_name'] = $data["udm_name_{$lang}"]; } else { $vlu['em_data'] = R3EcoGisHelper::getMeterData($_SESSION['do_id'], $this->em_id); } } else { $q = $db->createSelectQuery(); $q->select('*')->from('consumption_data')->where('co_id=' . (int) $id); $vlu = $db->query($q)->fetch(PDO::FETCH_ASSOC); $this->em_id = $vlu['em_id']; $vlu['em_data'] = R3EcoGisHelper::getMeterData($_SESSION['do_id'], $vlu['em_id']); $vlu = array_merge($vlu, R3EcoGisHelper::getChangeLogData('consumption', $vlu['co_id'])); //em_is_production } $this->data = $vlu; // Save the data (prevent multiple sql) return $vlu; }
public function askDelGlobalPlainSum($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $gc_id = (int) $request['gc_id']; $name = $db->query("SELECT gc_name_{$lang} FROM global_category WHERE gc_id={$gc_id}")->fetchColumn(); return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler eliminare gli obiettivi per la categoria \"%s\"?"), $name)); }
/** * Return the sql to generate the list */ public function getListSQL() { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $q = $db->createSelectQuery(); $where = "emo_code='STREET_LIGHTING' AND em_object_id=" . (int) $this->sl_id; $q->select("em_object_id, co_id, co_start_date, co_end_date, co_value, co_value_tep, co_value_kwh, co_value_co2, co_bill, co_bill_specific")->from('consumption_data')->where($where); return $q; }
/** * Create the table header * param string $order The table order */ public function createListTableHeader(&$order) { $lang = R3Locale::getLanguageID(); $this->simpleTable->addSimpleField(_('Nome utente'), 'us_name', 'text', null, array('sortable' => true)); $this->simpleTable->addSimpleField(_('Email/login'), 'us_login', 'text', null, array('sortable' => true)); if ($this->auth->getConfigValue('PUBLIC_SITE', 'REGISTRATION_NEED_OPERATOR_CONFIRM', 'F') == 'T') { $this->simpleTable->addSimpleField(_('Stato'), 'us_status_text', 'text', 150, array('sortable' => true)); } $this->simpleTable->addSimpleField(_('Data registrazione'), 'us_ins_date', 'date', 80, array('sortable' => true, 'align' => 'center')); $this->simpleTable->addSimpleField(_('Azione'), '', 'link', 50); $this->tableHtml = $this->simpleTable->CreateTableHeader($order); }
public function __construct(array $request = array(), array $opt = array()) { parent::__construct($request, $opt); $this->kind = initVar('kind'); $this->act = initVar('act', 'add'); $this->mu_id = initVar('mu_id'); $this->mu_name = initVar('mu_name'); if ($this->mu_name != '') { // Convert municipality text into id $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $this->mu_id = (int) $db->query("SELECT mu_id FROM municipality WHERE mu_name_{$lang} ILIKE " . $db->quote($request['mu_name']))->fetchColumn(); } setLang(R3Locale::getLanguageCode()); $this->registerAjaxFunction('submitFormData'); }
/** * Return the sql to generate the list */ public function getListSQL() { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $q = $db->createSelectQuery(); $where = array(); $where[] = $q->expr->eq('do_id', $this->do_id); if (!$this->auth->hasPerm('SHOW', 'ALL_DOMAINS') && $this->auth->getParam('mu_id') != '') { $where[] = $q->expr->eq('mu_id', $db->quote((int) $this->auth->getParam('mu_id'))); } $where[] = $q->expr->eq('doct_code', "'SEAP'"); $q->select("doc_id, doc_file_id, mu_name_{$lang} AS mu_name, doc_file, doc_date")->from('ecogis.document_data doc')->innerJoin('ecogis.municipality mu', 'doc.doc_object_id=mu_id'); if (count($where) > 0) { $q->where($where); } // echo $q; return $q; }
public function askDelGlobalPlainGauge($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = forceInteger($request['id'], 0, false, '.'); $name = $db->query("SELECT gpg_name_{$lang} FROM ecogis.global_plain_gauge WHERE gpg_id={$id}")->fetchColumn(); if ($this->tryDeleteData($id)) { return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare l'indicatore \"%s\"?"), $name)); } else { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _('Impossibile cancellare questa voce dal catalogo azioni poichè vi sono dei dati ad esso legati')); } $name = $db->query("SELECT ac_name_{$lang} FROM action_catalog WHERE ac_id={$id}")->fetchColumn(); }
/** * Return the UDM * @param array $request the request * @return array the result data */ public function confirmDeleteStreetLighting($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = (int) $request['id']; $name = $db->query("SELECT sl_full_name_{$lang} AS sw_title FROM street_lighting_data WHERE sl_id={$id}")->fetchColumn(); $hasEnergyMeter = R3EcoGisHelper::hasEnergyMeter('STREET_LIGHTING', $id); $hasDocument = R3EcoGisHelper::hasDocument('STREET_LIGHTING', $id); if (!$hasEnergyMeter && !$hasDocument && $this->tryDeleteData($id)) { return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_('Sei sicuro di voler cancellare il tratto "%s"?'), $name)); } return array('status' => R3_AJAX_NO_ERROR, 'alert' => sprintf(_('Impossibile cancellare il tratto "%s", poichè vi sono dei dati ad esso associati'), $name)); }
/** * Return the data for a single customer */ public function getData($id = null) { global $mdb2, $dsn; $lang = R3Locale::getLanguageID(); $db = ezcDbInstance::get(); if ($this->act == 'add') { $vlu = array(); $vlu['do_template'] = DEFAULT_DOMAIN; // 'SYSTEM'; $vlu['gr_name'] = 'ADMIN'; $vlu['app_language'] = 1; $vlu['app_cat_type'] = 'IT'; $vlu['do_building_code_type'] = 'PROPOSED'; $vlu['do_building_code_required'] = 'F'; $vlu['do_calculate_global_plain_totals'] = 'T'; $vlu['do_building_code_unique'] = 'F'; $vlu['do_building_show_id'] = 'F'; $vlu['do_building_extra_descr'] = 'F'; $vlu['do_public_site'] = 'F'; $vlu['do_grid_size'] = 0; $vlu['do_build_year_type'] = 'TABLE'; $vlu['do_build_restructure_year_type'] = 'TABLE'; $vlu['do_gc_streeview'] = 'T'; $vlu['do_gc_quick_search'] = 'T'; $vlu['do_gc_digitize_has_selection'] = 'T'; $vlu['do_gc_digitize_has_editing'] = 'T'; } else { $sql = "SELECT dn.do_id AS do_id_org, dn_name, cus.*\r\n FROM auth.domains d\r\n INNER JOIN auth.domains_name dn on d.do_id=dn.do_id and dn_type='N'\r\n INNER JOIN auth.domains_applications da on da.do_id=d.do_id\r\n LEFT JOIN auth.applications app on da.app_id=app.app_id\r\n LEFT JOIN ecogis.customer cus on cus.do_id=d.do_id\r\n WHERE dn.do_id=" . $this->id; $vlu = $db->query($sql)->fetch(PDO::FETCH_ASSOC); $data = $this->auth->getDomainData($vlu['dn_name'], true); $alias = array(); foreach ($data['names'] as $name) { if ($vlu['dn_name'] != $name) { $alias[] = $name; } } $vlu['dn_name_alias'] = implode(',', $alias); $vlu['do_database_login'] = $dsn['dbuser']; $vlu['do_schema'] = R3EcoGisHelper::getGeoSchema($vlu['do_id']); $vlu['cus_srid_text'] = R3EcoGisCustomerHelper::getSRIDDesc($vlu['cus_srid']); $vlu['images'] = R3EcoGisCustomerHelper::getImagesList($vlu['dn_name']); $vlu['reference_image'] = R3EcoGisCustomerHelper::getReferenceImages($vlu['dn_name']); // Dati presi da gestione utenti $vlu['app_language'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'NUM_LANGUAGES'); $vlu['app_cat_type'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'CATASTRAL_TYPE'); $vlu['do_building_code_type'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_CODE_TYPE'); $vlu['do_building_code_required'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_CODE_REQUIRED'); $vlu['do_calculate_global_plain_totals'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'CALCULATE_GLOBAL_PLAIN_TOTALS'); $vlu['do_building_code_unique'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_CODE_UNIQUE'); $vlu['do_building_extra_descr'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_EXTRA_DESCR'); $vlu['do_public_site'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'ENABLE_PUBLIC_SITE', 'F'); $vlu['do_grid_size'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'STAT_GRID_SIZE', 0); $vlu['do_building_show_id'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_SHOW_ID'); $vlu['do_build_year_type'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_YEAR_TYPE'); $vlu['do_build_restructure_year_type'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_RESTRUCTURE_YEAR_TYPE'); $vlu['do_municipality_mode'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_MUNICIPALITY_MODE'); $vlu['do_fraction_mode'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_FRACTION_MODE'); $vlu['do_street_mode'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_STREET_MODE'); $vlu['do_catastral_mode'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'BUILDING_CATASTRAL_MODE'); $vlu['do_public_css_url'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'PUBLIC_CSS_URL'); $vlu['consumption_start_year'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'CONSUMPTION_START_YEAR'); $vlu['consumption_end_year'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'CONSUMPTION_END_YEAR'); $vlu['do_gc_project'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'GISCLIENT', 'PROJECT'); $vlu['do_gc_mapset'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'GISCLIENT', 'MAPSET'); $vlu['do_gc_streeview'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'GISCLIENT', 'HAS_STREETVIEW', 'T'); $vlu['do_gc_quick_search'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'GISCLIENT', 'HAS_QUICK_SEARCH', 'T'); $vlu['do_gc_digitize_has_selection'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'GISCLIENT', 'DIGITIZE_HAS_SELECTION', 'T'); $vlu['do_gc_digitize_has_editing'] = $this->auth->getConfigValueFor($vlu['dn_name'], APPLICATION_CODE, null, 'GISCLIENT', 'DIGITIZE_HAS_EDITING', 'T'); if ($vlu['do_grid_size'] == 0) { $vlu['do_grid_size'] = ''; } } $catalog = R3DbCatalog::factory('pgsql', $mdb2); $data = $catalog->getUserData(); $vlu['can_create_db_user'] = $data['rolsuper'] == 't' || $data['rolcreaterole'] == 't'; $vlu['do_database_version'] = DATABASE_VERSION; $this->data = $vlu; // Save the data (prevent multiple sql) return $vlu; }
public function askDelActionCatalog($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = forceInteger($request['id'], 0, false, '.'); $name = $db->query("SELECT ac_name_{$lang} FROM action_catalog WHERE ac_id={$id}")->fetchColumn(); $sql = "select count(acd_id) from ecogis.action_catalog_dependencies where ac_related_id=" . $db->quote($id, PDO::PARAM_INT); $num = $db->query($sql)->fetchColumn(0); if ($num > 0) { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _("Impossibile cancellare questa voce dal catalogo azioni poichè è un'azione correlata ad un'altra azione")); } if ($this->tryDeleteData($id)) { return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare la voce \"%s\" dal catalogo azioni?"), $name)); } else { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _('Impossibile cancellare questa voce dal catalogo azioni poichè vi sono dei dati ad esso legati')); } }
public function getData() { $lang = R3Locale::getLanguageID(); $db = ezcDbInstance::get(); $id = $this->id; $vlu = array(); if ($this->act != 'add') { $id = (int) $this->id; try { $this->checkLookupDomainSecurity($id, $this->act); } catch (Exception $e) { die('Security error'); } $pkName = $this->getPrimaryKeyName(); $q = "SELECT * FROM {$this->table} WHERE {$pkName}={$id}"; $vlu = $db->query($q)->fetch(PDO::FETCH_ASSOC); $vlu = array_merge($vlu, R3EcoGisHelper::getChangeLogData($this->table, $id)); } else { $vlu = array(); foreach ($this->fields as $key => $field) { if (isset($field['name'])) { $key = $field['name']; } if (isset($field['default'])) { $vlu[$key] = $field['default']; } } } $this->data = $vlu; // Save the data (prevent multiple sql) return $vlu; }
/** * Return the data for a single customer */ public function getData($id = null) { $lang = R3Locale::getLanguageID(); $db = ezcDbInstance::get(); $sql = "SELECT gc1.gc_id, gc2.gc_name_{$lang} AS gc_name_main, gc1.gc_name_{$lang} AS gc_name\r\n FROM global_category gc1\r\n INNER JOIN global_category gc2 ON gc1.gc_parent_id=gc2.gc_id\r\n WHERE gc1.gc_id=" . (int) $this->id; $vlu = $db->query($sql)->fetch(PDO::FETCH_ASSOC); $gpac_id = $db->query("SELECT gpac_id FROM ecogis.global_plain_action_category WHERE gc_id={$this->id} ORDER BY gpac_id LIMIT 1")->fetchColumn(); // Ricavo il primo record per determinare la data di modifica $vlu = array_merge($vlu, R3EcoGisHelper::getChangeLogData('global_plain_action_category', $gpac_id)); return $vlu; }
/** * Return the UDM * @param array $request the request * @return array the result data */ public function confirm_delete_device($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $name = $db->query("SELECT dev_name_{$lang} AS dev_name FROM device_data WHERE dev_id=" . (int) $request['id'])->fetchColumn(); return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare l'impianto \"%s\"?"), trim($name))); }
public function askDelUtility($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = forceInteger($request['id'], 0, false, '.'); $sql = "SELECT COUNT(*)\r\n FROM utility_product up\r\n INNER JOIN energy_meter em ON em.up_id=up.up_id\r\n WHERE us_id={$id}"; if ($db->query($sql)->fetchColumn() > 0) { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _('Impossibile cancellare questo produttore di servizi poichè vi sono dei dati ad esso legati')); } else { $name = $db->query("SELECT us_name_{$lang} FROM utility_supplier WHERE us_id={$id}")->fetchColumn(); return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare il produttore di servizi \"%s\"?"), $name)); } }
public function askDelESU($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = forceInteger($request['id'], 0, false, '.'); $data = $db->query("SELECT es_name_{$lang} AS es_name, udm_name_{$lang} AS udm_name, mu_id FROM energy_source_udm_data WHERE esu_id={$id}")->fetch(PDO::FETCH_ASSOC); if ($request['type'] == 'MUNICIPALITY') { $mu_name = R3EcoGisHelper::getMunicipalityName($data['mu_id']); return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare il fattore di conversione \"%s (%s)\" e ripristinare il valore standard per i consumi già inseriti nel comune di \"%s\"?"), $data['es_name'], $data['udm_name'], $mu_name)); } else { if ($this->tryDeleteData($id)) { return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare il fattore di conversione \"%s (%s)\"?"), $data['es_name'], $data['udm_name'])); } else { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _('Impossibile cancellare questo fattore di conversione poichè vi sono dei dati ad esso legati')); } } }
static function getStatGeneralData() { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $result = array(); $sql = "SELECT *, sg_title_{$lang} AS sg_title, sg_upper_text_{$lang} AS sg_upper_text, sg_lower_text_{$lang} AS sg_lower_text\r\n FROM ecogis.stat_general"; $vlu = $db->query($sql)->fetch(PDO::FETCH_ASSOC); if ($vlu === false) { $vlu = array(); } return $vlu; }
/** * Return the UDM * @param array $request the request * @return array the result data */ public function confirmDeleteMunicipalityCollection($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = (int) $request['id']; $name = $db->query("SELECT mu_name_{$lang} FROM municipality_collection_data WHERE mu_id={$id}")->fetchColumn(); return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare il raggruppamento \"%s\"?"), $name)); }
/** * Return the data for a single customer */ public function getData($id = null) { $lang = R3Locale::getLanguageID(); $db = ezcDbInstance::get(); $vlu = array(); if ($this->act != 'add') { $sql = "SELECT mu_type FROM ecogis.global_plain_data WHERE gp_id=" . (int) $this->gp_id; $vlu['mu_type'] = $db->query($sql)->fetchColumn(); $vlu['merge_municipality_data'] = $this->merge_municipality_data; $vlu['data'] = R3EcoGisGlobalPlainTableHelper::getData($this->do_id, $this->gp_id, $this->merge_municipality_data); $vlu['can_monitoring'] = R3EcoGisGlobalPlainTableHelper::canMonitoring($this->do_id, $this->gp_id); } $this->data = $vlu; // Save the data (prevent multiple sql) return $vlu; }
public function askDelSimulation($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = $request['id']; $name = $db->query("SELECT sw_title_{$lang} FROM simulation_work WHERE sw_id={$id}")->fetchColumn(); if ($this->tryDeleteData($id)) { return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare la simulazione \"%s\"?"), $name)); } else { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _('Impossibile cancellare questa simulazione poichè vi sono dei dati ad essa collegati')); } }
public function askDelGlobalResult($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = forceInteger($request['id'], 0, false, '.'); $name = $db->query("SELECT ge_name_{$lang} FROM global_entry WHERE ge_id={$id}")->fetchColumn(); if ($this->tryDeleteData($id)) { return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare l'inventario emissioni \"%s\"?"), $name)); } else { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _('Impossibile cancellare questo inventario emissioni poichè vi sono dei dati ad esso legati')); } }
public function askDelGlobalPlain($request) { $db = ezcDbInstance::get(); $id = (int) @$request['id']; R3Security::checkGlobalPlain($id); $lang = R3Locale::getLanguageID(); $name = $db->query("SELECT gp_name_{$lang} AS gp_name FROM global_plain_data WHERE gp_id=" . (int) $request['id'])->fetchColumn(); if (R3EcoGisHelper::hasGlobalPlainRowHasGauge($id)) { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _("Impossibile cancellare questo piano d'azione, poichè vi sono definiti degli indicatori ad esso legati")); } if (R3EcoGisHelper::hasDocument('GLOBAL_PLAIN', $id)) { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _("Impossibile cancellare questo piano d'azione, poichè vi sono dei documenti ad esso legati")); } return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare il piano di azione \"%s\"?"), $name)); }
/** * Return the data for a single customer */ public function getData($id = null) { $lang = R3Locale::getLanguageID(); if ($id === null) { $id = $this->id; } $db = ezcDbInstance::get(); $vlu = array(); if ($this->new_udm_divider != '') { $lastDivider = $this->auth->setConfigValue('SETTINGS', 'GLOBAL_RESULT_LAST_UDM_DIVIDER', $this->new_udm_divider, array('permanent' => true)); } $lastDivider = $this->auth->getConfigValue('SETTINGS', 'GLOBAL_RESULT_LAST_UDM_DIVIDER', 1); $this->udm_divider = initVar('udm_divider', $lastDivider); if ($this->act != 'add') { $sql = "SELECT mu_type FROM ecogis.global_entry_data WHERE ge_id=" . (int) $this->ge_id; $vlu['mu_type'] = $db->query($sql)->fetchColumn(); $vlu['udm_divider'] = $this->udm_divider; $vlu['merge_municipality_data'] = $this->merge_municipality_data; $vlu['header'] = R3EcoGisGlobalTableHelper::getParameterList($this->kind); $vlu['header']['parameter_count'] = R3EcoGisGlobalTableHelper::getParameterCount($this->kind); $vlu['data'] = R3EcoGisGlobalTableHelper::getCategoriesData($this->ge_id, $this->kind, $this->udm_divider, true, $this->gc_id, $this->merge_municipality_data); } else { $vlu = array(); } $this->data = $vlu; // Save the data (prevent multiple sql) return $vlu; }
public static function getCategoriesData($ge_id, $kind, $divider = 1, $returnAsLocale = false, $gc_id = null, $mergeMunicipalityCollection = true) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $sql = "SELECT mu_id, mu_type, ge_year FROM ecogis.global_entry_data WHERE ge_id=" . (int) $ge_id; $muData = $db->query($sql)->fetch(PDO::FETCH_ASSOC); if ($muData === false) { throw new Exception("Global entry #{$ge_id} not found"); } if ($muData['mu_type'] == 'C') { // Municipality collection // Get collection data and other municipality data $result = self::getCategoriesDataMunicipality($ge_id, $kind, $divider, false, $gc_id); if ($mergeMunicipalityCollection) { // Get all the other municipality inventory. Multiple inventory/year can be present. $sql = "SELECT ge_id, mu_name_{$lang} as mu_name\r\n FROM ecogis.municipality mu\r\n INNER JOIN ecogis.global_entry ge ON mu.mu_id=ge.mu_id AND ge_year={$muData['ge_year']} AND ge_exclude_from_collection IS FALSE\r\n WHERE mu_parent_id={$muData['mu_id']} \r\n ORDER BY mu_name_{$lang}"; foreach ($db->query($sql, PDO::FETCH_ASSOC) as $row) { $data = self::getCategoriesDataMunicipality($row['ge_id'], $kind, $divider, false, $gc_id); self::meregeCategoriesData($result, $data, $row['mu_name']); } } if ($returnAsLocale) { self::convertToLocale($result, $divider == 1 ? 0 : 1); } return $result; } else { // Single municipality return self::getCategoriesDataMunicipality($ge_id, $kind, $divider, $returnAsLocale, $gc_id); } }
public function loadGE_GS($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); if (isset($request['mu_name'])) { $request['mu_id'] = R3EcoGisHelper::getMunicipalityIdByName($this->do_id, $request['mu_name'], $this->auth->getParam('mu_id')); } $data = R3EcoGisGlobalStrategyHelper::getGlobalData($_SESSION['do_id'], $request['mu_id'], array('allow_empty' => true)); return array('status' => 0, 'data' => array('mu_id_selected' => (int) $request['mu_id'], 'ge_id' => array('options' => $data['ge_values']), 'ge_id_2' => array('options' => $data['ge_values']), 'gp_id' => array('options' => $data['gp_values']), 'info_text' => $data['info_text'])); }
/** * Return the UDM * @param array $request the request * @return array the result data */ public function confirm_delete_document($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $name = $db->query("SELECT doc_title_{$lang} AS doc_title FROM document WHERE doc_id=" . (int) $request['id'])->fetchColumn(); return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_('Sei sicuro di voler cancellare il documento "%s"?'), $name)); }
/** * Return the sql to generate the list */ public function getListSQL() { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $q = $db->createSelectQuery(); $where = array(); $where[] = $q->expr->eq('do_id', $this->do_id); if (!$this->auth->hasPerm('SHOW', 'ALL_DOMAINS') && $this->auth->getParam('mu_id') != '') { $where[] = $q->expr->eq('mu_id', $db->quote((int) $this->auth->getParam('mu_id'))); } if ($this->pr_id != '') { $where[] = $q->expr->eq('pr_id', $db->quote((int) $this->pr_id)); } if ($this->mu_id != '') { $where[] = $q->expr->eq('mu_id', $db->quote((int) $this->mu_id)); } if ($this->mu_name != '') { $where[] = "mu_name_{$lang} ILIKE " . $db->quote("%{$this->mu_name}%"); } if ($this->getFilterValue('gc_id_filter') != '') { $isMainCategory = substr($this->getFilterValue('gc_id_filter'), 0, 1) == 'M'; $gc_id = (int) substr($this->getFilterValue('gc_id_filter'), 1); if ($isMainCategory) { $where[] = "gc_parent_id={$gc_id}"; } else { $where[] = "gc_id={$gc_id}"; } } if ($this->getFilterValue('gpa_name') != '') { $gpa_name = $this->getFilterValue('gpa_name'); $where[] = "gpa_name_{$lang} ILIKE " . $db->quote("%{$gpa_name}%"); } /* * global_plain_action_list_data */ $q->select("gp_id, gpr_id, mu_name_{$lang} AS mu_name, gp_name_{$lang} AS gp_name, gc_name_main_{$lang} AS gc_name_main, gc_name_{$lang} AS gc_name,\r\n gpa_name_{$lang} AS gpa_name, gpr_start_date, gpr_end_date, gpr_estimated_cost, gpr_expected_energy_saving, gpr_expected_renewable_energy_production, \r\n gpr_imported_row, gauge_info,\r\n gpr_expected_co2_reduction, NULL AS progress_emission, NULL AS progress_energy")->from('global_plain_action_list_data'); if (count($where) > 0) { $q->where($where); } return $q; }
/** * Return the data for a single customer */ public function getData($id = null) { $lang = R3Locale::getLanguageID(); $db = ezcDbInstance::get(); // Ricavo nome macro categoria $categoryName = ''; if ($this->gc_id != '') { $sql = "SELECT gc_parent.gc_name_{$lang} AS gc_name\r\n FROM global_category gc\r\n INNER JOIN global_category gc_parent ON gc.gc_parent_id=gc_parent.gc_id\r\n WHERE gc.gc_id={$this->gc_id}"; $categoryName = $db->query($sql)->fetchColumn(); } if ($this->act == 'add') { $vlu['gc_id'] = $this->gc_id; $vlu['gp_id'] = $this->gp_id; } else { $sql = "SELECT grp.*, mu_id\r\n FROM global_plain_row_data grp\r\n INNER JOIN global_plain_data gp ON grp.gp_id=gp.gp_id\r\n WHERE gpr_id=" . (int) $this->gpr_id; $vlu = $db->query($sql)->fetch(PDO::FETCH_ASSOC); $this->gc_id = $vlu['gc_id']; $vlu['data'] = R3EcoGisGlobalPlainHelper::getGaugeData($this->gpr_id); $vlu = array_merge($vlu, R3EcoGisHelper::getChangeLogData('global_plain_row', $vlu['gpr_id'])); } $vlu['gc_name'] = $categoryName; $this->data = $vlu; // Save the data (prevent multiple sql) return $vlu; }
public function askDelBuilding($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $id = forceInteger($request['id'], 0, false, '.'); $name = $db->query("SELECT bu_name_{$lang} FROM building WHERE bu_id={$id}")->fetchColumn(); $hasEnergyMeter = R3EcoGisHelper::hasEnergyMeter('BUILDING', $id); $hasDocument = R3EcoGisHelper::hasDocument('BUILDING', $id); if (!$hasEnergyMeter && !$hasDocument && $this->tryDeleteData($id)) { return array('status' => R3_AJAX_NO_ERROR, 'confirm' => sprintf(_("Sei sicuro di voler cancellare l'edificio \"%s\"?"), $name)); } else { return array('status' => R3_AJAX_NO_ERROR, 'alert' => _('Impossibile cancellare questo edificio poichè vi sono dei dati ad esso legati')); } }
/** * Verifica che il comune inserito sia valido e dell'utente, altrimenti genera un errore * Attenzione: questa funzione viene usata anche in lib/custom.map.php * * @param array $formData I dati del submit * @param array $errors Array con altri errori * @return integer|null Il codice del comune o null */ public static function checkFormDataForMunicipality(array $formData, array &$errors) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $mu_id = ''; if (1 == 2 && $this->auth->getParam('mu_id') != '') { // TODO: PERMISSION $mu_id = $this->auth->getParam('mu_id'); } else { if (isset($formData['mu_name']) && $formData['mu_name'] != '') { $mu_id = $db->query("SELECT mu_id FROM municipality WHERE mu_name_{$lang} ILIKE " . $db->quote($formData['mu_name']))->fetchColumn(); if ($mu_id == '') { $errors['mu_id'] = array('CUSTOM_ERROR' => _('Il comune immesso non è stato trovato')); if (isset($this)) { $this->removeField('mu_id'); } return -1; } } else { if (isset($formData['mu_id']) && $formData['mu_id'] != '') { $mu_id = $formData['mu_id']; } } } if ($mu_id == '') { $errors['mu_id'] = array('CUSTOM_ERROR' => _("Il campo \"Comune\" è obbligatorio")); return -1; } return $mu_id; }