Example #1
0
 public function submitFormData($request)
 {
     $params = array('label', 'visible', 'width');
     // get data from class
     $obj = R3Controller::factory(array('on' => $this->module));
     $tableConfig = new R3BaseTableConfig(R3AuthInstance::get());
     $defaultConfig = $obj->getTableColumnConfig();
     $config = array();
     $positions = explode(',', $request['fields_position']);
     foreach ($defaultConfig as $key => $data) {
         foreach ($params as $param) {
             if (isset($request["{$key}_{$param}"])) {
                 if ($request["{$key}_{$param}"] == '' || $param == 'width' && strtoupper($request["{$key}_{$param}"]) == 'AUTO') {
                     $config[$key][$param] = null;
                 } else {
                     $config[$key][$param] = $request["{$key}_{$param}"];
                 }
             }
         }
     }
     foreach ($positions as $order => $key) {
         $config[$key]['position'] = $order + 1;
     }
     $tableConfig->setConfig($config, $this->module, $defaultConfig);
     R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
     return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneSetupTableColumn()");
 }
Example #2
0
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $errors = $this->checkFormData($request);
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $request['gps_id'] = $db->query("SELECT gps_id FROM global_plain_sum WHERE gp_id={$request['gp_id']} AND gc_id={$request['gc_id']}")->fetchColumn();
         if ($request['act'] != 'del') {
             if ($request['gps_id'] > 0) {
                 $request['act'] = $request['gps_expected_energy_saving'] == '' && $request['gps_expected_renewable_energy_production'] == '' && $request['gps_expected_co2_reduction'] == '' ? 'del' : 'mod';
             } else {
                 $request['act'] = 'add';
             }
         }
         $id = $this->applyData($request);
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneGlobalPlainSum({$id}, '{$this->kind}')");
     }
 }
Example #3
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     if ($this->act != 'add') {
         // Security check
         //R3Security::checkStreetLighting(@$request['id']);
     }
     $request['sl_id'] = $request['id'];
     if ($this->act != 'del') {
         $request['mu_id'] = $this->checkFormDataForMunicipality($request, $errors);
         $errors = $this->checkFormData($request, $errors);
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $db->beginTransaction();
         $id = $this->applyData($request);
         if (isset($request['geometryStatus']) && strtoupper($request['geometryStatus']) == 'CHANGED') {
             $session_id = session_id();
             $sql = "UPDATE street_lighting\r\n                        SET the_geom=foo.the_geom\r\n                        FROM (SELECT MULTI(ST_Force_2d(ST_union(ST_Buffer(the_geom, 0.0)))) AS the_geom FROM edit_tmp_polygon WHERE session_id='{$session_id}') AS foo\r\n                        WHERE sl_id={$id}";
             $db->exec($sql);
             // Remove cache
             $sql = "UPDATE cache SET ca_expire_time=CURRENT_TIMESTAMP\r\n                        WHERE ca_object_id={$id} AND cat_id=2";
             $db->exec($sql);
         }
         $db->commit();
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         R3EcoGisCacheHelper::resetMapPreviewCache(null);
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneStreetLighting({$id})");
     }
 }
Example #4
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $request = array_merge(array('ac_object_id' => null, 'gc_id' => null), $request);
     $request['wo_id'] = null;
     $request['ac_id'] = $request['id'];
     if (isset($request['mu_name'])) {
         $request['mu_id'] = R3EcoGisHelper::getMunicipalityIdByName($this->do_id, $request['mu_name'], $this->auth->getParam('mu_id'));
     }
     if ($this->act != 'del') {
         $request['ac_green_electricity_purchase'] = forceFloat($request['ac_green_electricity_purchase_mwh'], null, '.') * 1000;
         // Convert MWh to kWh
         $request['ac_co2_reduction'] = forceFloat($request['ac_co2_reduction_tco2'], null, '.') * 1000;
         // Convert tCO2 to kCO2
         $tmpGesIdConsumption = array();
         $tmpEsIdConsumption = array();
         $tmpUdmIdConsumption = array();
         $tmpAcExpectedEnergySaving = array();
         $tmpAcExpectedEnergySavingMwh = array();
         for ($i = 0; $i < count($request['es_id_consumption']); $i++) {
             if ($request['udm_id_consumption'][$i] != '' || $request['ac_expected_energy_saving'][$i] != '') {
                 $tmpGesIdConsumption[] = $request['ges_id_consumption'][$i];
                 $tmpEsIdConsumption[] = $request['es_id_consumption'][$i];
                 $tmpUdmIdConsumption[] = $request['udm_id_consumption'][$i];
                 $tmpAcExpectedEnergySaving[] = $request['ac_expected_energy_saving'][$i];
                 $tmpAcExpectedEnergySavingMwh[] = $request['ac_expected_energy_saving_mwh'][$i];
             }
         }
         $request['ges_id_consumption'] = $tmpGesIdConsumption;
         $request['es_id_consumption'] = $tmpEsIdConsumption;
         $request['udm_id_consumption'] = $tmpUdmIdConsumption;
         $request['ac_expected_energy_saving'] = $tmpAcExpectedEnergySaving;
         $request['ac_expected_energy_saving_mwh'] = $tmpAcExpectedEnergySavingMwh;
         $request['esu_id_consumption'] = R3EcoGisHelper::getMultipleEnergySourceUdmID($_SESSION['do_id'], $request['es_id_consumption'], $request['udm_id_consumption'], $request['mu_id']);
         $request['esu_id_production'] = R3EcoGisHelper::getEnergySourceUdmID($_SESSION['do_id'], $request['es_id_production'], $request['udm_id_production'], $request['mu_id'], true);
         $request['emo_id'] = self::getEnergyMeterObjectByID($request['mu_id'], $request['ac_object_id'], $request['gc_id']);
         if (isset($request['mu_name']) && $request['mu_name'] != '' && $request['mu_id'] == '') {
             $errors['mu_name'] = array('CUSTOM_ERROR' => _('Il comune immesso non è stato trovato'));
         }
         if (!isset($request['gc_id_parent']) || $request['gc_id_parent'] == '') {
             $errors['gc_id_parent'] = array('CUSTOM_ERROR' => _('Il campo "Macro-settore" è obbligatorio'));
         }
         $errors = $this->checkFormData($request, $errors);
         $selectedRelatedActions = array();
         if (isset($request['related_required_action_id'])) {
             for ($i = 0; $i < count($request['related_required_action_id']); $i++) {
                 if ($request['related_required_action_id'][$i] > 0 && in_array($request['related_required_action_id'][$i], $selectedRelatedActions)) {
                     $errors['related_required_action_' . $i] = array('CUSTOM_ERROR' => _("L'azione ") . $this->getActionName($request['related_required_action_id'][$i]) . _(" è già stata selezionata"));
                 }
                 array_push($selectedRelatedActions, $request['related_required_action_id'][$i]);
             }
         }
         if (isset($request['related_action_id'])) {
             for ($i = 0; $i < count($request['related_action_id']); $i++) {
                 if ($request['related_action_id'][$i] > 0 && in_array($request['related_action_id'][$i], $selectedRelatedActions)) {
                     $errors['related_action_' . $i] = array('CUSTOM_ERROR' => _("L'azione ") . $this->getActionName($request['related_action_id'][$i]) . _(" è già stata selezionata"));
                 }
                 array_push($selectedRelatedActions, $request['related_action_id'][$i]);
             }
         }
         if (isset($request['related_excluded_action_id'])) {
             for ($i = 0; $i < count($request['related_excluded_action_id']); $i++) {
                 if ($request['related_excluded_action_id'][$i] > 0 && in_array($request['related_excluded_action_id'][$i], $selectedRelatedActions)) {
                     $errors['related_required_action_' . $i] = array('CUSTOM_ERROR' => _("L'azione ") . $this->getActionName($request['related_excluded_action_id'][$i]) . _(" è già stata selezionata"));
                 }
                 array_push($selectedRelatedActions, $request['related_excluded_action_id'][$i]);
             }
         }
         if (isset($request['enable_benefit_year']) && $request['enable_benefit_year'] == 'T' && isset($request['benefit_year'])) {
             $startBenefitYear = (int) substr($request['ac_benefit_start_date'], 0, 4);
             $endBenefitYear = (int) substr($request['ac_benefit_end_date'], 0, 4);
             $lastBenefitPerc = 0;
             for ($i = 0; $i < count($request['benefit_year']); $i++) {
                 if ($request['benefit_year'][$i] != '' && $request['benefit_year'][$i] < $startBenefitYear) {
                     $errors['benefit_year_' . $i] = array('CUSTOM_ERROR' => sprintf(_("L'anno del beneficio \"%s\" è antecedente al %s (anno inizio beneficio)"), $request['benefit_year'][$i], $startBenefitYear));
                 } else {
                     if ($request['benefit_year'][$i] != '' && $request['benefit_year'][$i] > $endBenefitYear) {
                         $errors['benefit_year_' . $i] = array('CUSTOM_ERROR' => sprintf(_("L'anno del beneficio \"%s\" è oltre al %s (anno fine beneficio)"), $request['benefit_year'][$i], $endBenefitYear));
                     }
                 }
                 if ($request['benefit_benefit'][$i] != '' && $request['benefit_benefit'][$i] < 0 || $request['benefit_benefit'][$i] != '' && $request['benefit_benefit'][$i] > 100) {
                     $errors['benefit_benefit_' . $i] = array('CUSTOM_ERROR' => _("Il valore del beneficio deve essere compreso tra 0 e 100"));
                 }
             }
         }
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         setLocale(LC_ALL, 'C');
         $db->beginTransaction();
         $id = $this->applyData($request);
         $sql = "DELETE FROM ecogis.action_catalog_energy WHERE ac_id=" . $db->quote($id, PDO::PARAM_INT);
         $db->exec($sql);
         if ($this->act != 'del') {
             for ($i = 0; $i < count($request['esu_id_consumption']); $i++) {
                 $sql = "INSERT INTO ecogis.action_catalog_energy  (ac_id, esu_id, ace_expected_energy_saving) " . " VALUES (" . $db->quote($id, PDO::PARAM_INT) . ", " . $db->quote($request['esu_id_consumption'][$i], PDO::PARAM_INT) . ", " . $db->quote($request['ac_expected_energy_saving'][$i], PDO::PARAM_INT) . ")";
                 $db->exec($sql);
             }
         }
         $sql = "DELETE FROM ecogis.action_catalog_dependencies WHERE ac_id=" . $db->quote($id, PDO::PARAM_INT);
         $db->exec($sql);
         if ($this->act != 'del') {
             $relatedActions = array();
             if (isset($request['related_action_id'])) {
                 for ($i = 0; $i < count($request['related_action_id']); $i++) {
                     array_push($relatedActions, array('related_action_id' => $request['related_action_id'][$i], 'acd_required' => 'D'));
                 }
             }
             if (isset($request['related_required_action_id'])) {
                 for ($i = 0; $i < count($request['related_required_action_id']); $i++) {
                     array_push($relatedActions, array('related_action_id' => $request['related_required_action_id'][$i], 'acd_required' => 'R'));
                 }
             }
             if (isset($request['related_excluded_action_id'])) {
                 for ($i = 0; $i < count($request['related_excluded_action_id']); $i++) {
                     array_push($relatedActions, array('related_action_id' => $request['related_excluded_action_id'][$i], 'acd_required' => 'E'));
                 }
             }
             foreach ($relatedActions as $relatedAction) {
                 $sql = "INSERT INTO ecogis.action_catalog_dependencies  (ac_id, ac_related_id, acd_type) " . " VALUES (" . $db->quote($id, PDO::PARAM_INT) . ", " . $db->quote($relatedAction['related_action_id'], PDO::PARAM_INT) . ", " . $db->quote($relatedAction['acd_required'], PDO::PARAM_BOOL) . ")";
                 if ($relatedAction['related_action_id'] > 0) {
                     $db->exec($sql);
                 }
             }
         }
         $sql = "DELETE FROM ecogis.action_catalog_benefit_year WHERE ac_id=" . $db->quote($id);
         $db->exec($sql);
         if ($this->act != 'del') {
             if (isset($request['enable_benefit_year']) && $request['enable_benefit_year'] == 'T') {
                 for ($i = 0; $i < count($request['benefit_year']); $i++) {
                     $year = forceInteger($request['benefit_year'][$i]);
                     $benefit = forceFloat($request['benefit_benefit'][$i], null, '.');
                     if ($year > 1970 && $request['benefit_benefit'][$i] != '') {
                         $sql = "INSERT INTO ecogis.action_catalog_benefit_year  (ac_id, acby_year, acby_benefit) " . "VALUES ({$id}, {$year}, {$benefit})";
                         $db->exec($sql);
                     }
                 }
             }
         }
         $db->commit();
         R3EcoGisCacheHelper::resetMapPreviewCache(null);
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         if ($this->bu_id == '') {
             return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneActionCatalog({$id})");
         } else {
             return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneActionCatalogFromBuilding({$id})");
         }
     }
 }
Example #5
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     global $dbini, $dsn, $mdb2, $languages;
     if ($this->act == 'del') {
         $id = $this->deleteCustomer($request);
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneCustomer({$id})");
     }
     $errors = array();
     $errors = $this->checkFormData($request, $errors);
     if ($request['municipality'] == '') {
         $errors['municipality'] = array('CUSTOM_ERROR' => _("Almeno un comune deve essere selezionato"));
     }
     $catalog = R3DbCatalog::factory('pgsql', $mdb2);
     $data = $catalog->getUserData();
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         if ($request['cus_srid'] == '') {
             $request['cus_srid'] = 4326;
         }
         $db = ezcDbInstance::get();
         $do_id = R3EcoGisCustomerHelper::createDomain($request['dn_name'], $request['dn_name_alias']);
         R3EcoGisCustomerHelper::createCustomer($do_id, $request);
         R3EcoGisCustomerHelper::createUser($do_id, $request);
         R3EcoGisCustomerHelper::setMunicipality($do_id, explode(',', $request['municipality']));
         $dataPath = R3_UPLOAD_DATA_DIR . strtolower($request['dn_name']);
         $dataLogoPath = $dataPath . '/logo';
         $dataStylePath = $dataPath . '/style';
         $dataJSPath = $dataPath . '/js';
         if (!file_exists($dataPath)) {
             if (!@mkdir($dataPath)) {
                 throw new Exception("Can't create path {$dataPath}");
             }
         }
         if (!file_exists($dataLogoPath)) {
             if (!@mkdir($dataLogoPath)) {
                 throw new Exception("Can't create path {$dataLogoPath}");
             }
         }
         if (!file_exists($dataStylePath)) {
             if (!@mkdir($dataStylePath)) {
                 throw new Exception("Can't create path {$dataStylePath}");
             }
         }
         if (!file_exists($dataJSPath)) {
             if (!@mkdir($dataJSPath)) {
                 throw new Exception("Can't create path {$dataJSPath}");
             }
         }
         R3EcoGisCustomerHelper::saveImages($request['dn_name'], $request);
         R3EcoGisCustomerHelper::saveCSS($request['dn_name'], $request);
         if ($request['consumption_end_year'] > 0 && $request['consumption_start_year'] > 0) {
             $viewOpt = array('totYears' => $request['consumption_end_year'] - $request['consumption_start_year'] + 1);
         } else {
             $viewOpt = array('totYears' => 100);
         }
         $schema = R3EcoGisHelper::getGeoSchema($do_id);
         //'geo_' . strtolower($request['dn_name']);
         R3EcoGisCustomerHelper::createSchema($schema, $dsn['dbuser']);
         R3EcoGisCustomerHelper::createViews($schema, $dsn['dbuser'], $request['cus_srid'], $do_id, $viewOpt);
         R3EcoGisCustomerHelper::setLoggerTrigger();
         R3EcoGisCustomerHelper::grantTables($schema, $dsn['dbuser']);
         R3EcoGisCustomerHelper::applyConsumptionInterval($request['consumption_start_year'], $request['consumption_end_year']);
         if (R3_AUTO_POPULATE_GEOMETRY_COLUMNS && !isset($request['skip_geometry_check'])) {
             R3EcoGisCustomerHelper::populateGeometryColumns(R3_DB_SCHEMA);
             R3EcoGisCustomerHelper::populateGeometryColumns($schema);
         }
         R3EcoGisCustomerHelper::copyEnergySource($do_id);
         if ($this->isMultiDomain()) {
             R3EcoGisCustomerHelper::copySettings('SYSTEM', $request['dn_name']);
         }
         if ($this->act == 'add') {
             $sql = "INSERT INTO auth.settings (do_id, app_id, se_section, se_param, se_value, se_descr, se_type, se_type_ext, se_private, se_order)\r\n                        SELECT DISTINCT (SELECT do_id FROM auth.domains_name WHERE dn_type='N' and dn_name='{$request['dn_name']}'), s.app_id, se_section, se_param, se_value, se_descr, se_type, se_type_ext, se_private, se_order\r\n                        FROM auth.settings s\r\n                        INNER JOIN auth.domains_name dn on s.do_id=dn.do_id and dn_type='N' AND dn_name='{$request['do_template']}'\r\n                        INNER JOIN auth.applications app on s.app_id=app.app_id AND app_code='" . APPLICATION_CODE . "'\r\n                        WHERE us_id IS NULL \r\n                        ORDER BY se_section, se_param";
             $db->exec($sql);
         }
         //Salva dati nuovo ente (DBINI)
         $gridSize = forceInteger($request['do_grid_size'], 0, false, '.');
         if ($this->auth->getConfigValueFor($request['dn_name'], APPLICATION_CODE, null, 'APPLICATION', 'STAT_GRID_SIZE', 0) != $gridSize) {
             $this->create_grid(array('do_id' => $do_id, 'sg_size' => $request['do_grid_size']));
         }
         $dbini2 = clone $dbini;
         $dbini2->setDomainName($request['dn_name']);
         $dbini2->setValue('APPLICATION', 'NUM_LANGUAGES', $request['app_language']);
         $dbini2->setValue('APPLICATION', 'CATASTRAL_TYPE', $request['app_cat_type']);
         $dbini2->setValue('APPLICATION', 'BUILDING_CODE_TYPE', $request['do_building_code_type']);
         $dbini2->setValue('APPLICATION', 'BUILDING_CODE_REQUIRED', $request['do_building_code_required']);
         $dbini2->setValue('APPLICATION', 'CALCULATE_GLOBAL_PLAIN_TOTALS', $request['do_calculate_global_plain_totals']);
         $dbini2->setValue('APPLICATION', 'BUILDING_CODE_UNIQUE', $request['do_building_code_unique']);
         $dbini2->setValue('APPLICATION', 'BUILDING_EXTRA_DESCR', $request['do_building_extra_descr']);
         $dbini2->setValue('APPLICATION', 'PUBLIC_CSS_URL', $request['do_public_css_url']);
         $dbini2->setValue('APPLICATION', 'ENABLE_PUBLIC_SITE', $request['do_public_site']);
         $dbini2->setValue('APPLICATION', 'STAT_GRID_SIZE', $gridSize > 0 ? $gridSize : null);
         $dbini2->setValue('APPLICATION', 'BUILDING_SHOW_ID', $request['do_building_show_id']);
         $dbini2->setValue('APPLICATION', 'BUILDING_YEAR_TYPE', $request['do_build_year_type']);
         $dbini2->setValue('APPLICATION', 'BUILDING_RESTRUCTURE_YEAR_TYPE', $request['do_build_restructure_year_type']);
         $dbini2->setValue('APPLICATION', 'BUILDING_MUNICIPALITY_MODE', $request['do_municipality_mode']);
         $dbini2->setValue('APPLICATION', 'BUILDING_FRACTION_MODE', $request['do_fraction_mode']);
         $dbini2->setValue('APPLICATION', 'BUILDING_STREET_MODE', $request['do_street_mode']);
         $dbini2->setValue('APPLICATION', 'BUILDING_CATASTRAL_MODE', $request['do_catastral_mode']);
         $dbini2->setValue('APPLICATION', 'CONSUMPTION_START_YEAR', $request['consumption_start_year']);
         $dbini2->setValue('APPLICATION', 'CONSUMPTION_END_YEAR', $request['consumption_end_year']);
         if ($request['app_language'] == 1) {
             $dbini2->setValue('APPLICATION', 'LANG_NAME_SHORT_1', '');
             $dbini2->setValue('APPLICATION', 'LANG_NAME_SHORT_2', '');
         } else {
             $dbini2->setValue('APPLICATION', 'LANG_NAME_SHORT_1', sprintf(' (%s)', $languages[1]));
             $dbini2->setValue('APPLICATION', 'LANG_NAME_SHORT_2', sprintf(' (%s)', $languages[2]));
         }
         $dbini2->setValue('APPLICATION', 'LANG_NAME_SHORT_3', ' (en)');
         // Gisclient settings
         $dbini2->setValue('GISCLIENT', 'PROJECT', $request['do_gc_project']);
         $dbini2->setValue('GISCLIENT', 'MAPSET', $request['do_gc_mapset']);
         $dbini2->setValue('GISCLIENT', 'HAS_STREETVIEW', $request['do_gc_streeview']);
         $dbini2->setValue('GISCLIENT', 'HAS_QUICK_SEARCH', $request['do_gc_quick_search']);
         $dbini2->setValue('GISCLIENT', 'DIGITIZE_HAS_SELECTION', $request['do_gc_digitize_has_selection']);
         $dbini2->setValue('GISCLIENT', 'DIGITIZE_HAS_EDITING', $request['do_gc_digitize_has_editing']);
         if (R3_AUTO_SAVE_DATABASE_VERSION) {
             R3EcoGisCustomerHelper::updateDatabaseVersion(DATABASE_VERSION);
             // Setup database version
         }
         $id = 0;
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneCustomer({$id})");
     }
 }
Example #6
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     if (isset($_FILES['doc_file'])) {
         if (is_array($_FILES['doc_file']['name'])) {
             // Consider only the first file
             $files = array('name' => $_FILES['doc_file']['name'][0], 'type' => $_FILES['doc_file']['type'][0], 'tmp_name' => $_FILES['doc_file']['tmp_name'][0], 'error' => $_FILES['doc_file']['error'][0], 'size' => $_FILES['doc_file']['size'][0]);
         } else {
             $files = array('name' => $_FILES['doc_file']['name'], 'type' => $_FILES['doc_file']['type'], 'tmp_name' => $_FILES['doc_file']['tmp_name'], 'error' => $_FILES['doc_file']['error'], 'size' => $_FILES['doc_file']['size']);
         }
     } else {
         $files = array('name' => null, 'type' => null, 'tmp_name' => null, 'error' => UPLOAD_ERR_NO_FILE, 'size' => null);
     }
     $request['doc_id'] = forceInteger($request['id'], 0, false, '.');
     $request['type'] = strtoupper($request['type']);
     // Foreign key
     $file_info = $this->getDocFileInfo($request['doc_id']);
     if ($this->act == 'mod') {
         // Rimuove il campo: Evita lo spostamento di oggetti da una tipologia ad un altra
         $this->removeField('doc_object_id');
     } else {
         if (in_array($request['type'], array('BUILDING', 'BUILDING_PHOTO', 'BUILDING_THERMOGRAPHY', 'BUILDING_LABEL'))) {
             // Check foreign key per edifici
             $this->setFieldAttrib('doc_object_id', array('lookup' => array('table' => 'building', 'field' => 'bu_id')));
         } else {
             if (in_array($request['type'], array('STREET_LIGHTING'))) {
                 // Check foreign key per illuminazione pubblica
                 $this->setFieldAttrib('doc_object_id', array('lookup' => array('table' => 'street_lighting', 'field' => 'sl_id')));
             } else {
                 if (in_array($request['type'], array('GLOBAL_ENTRY'))) {
                     // Check foreign key per illuminazione pubblica
                     $this->setFieldAttrib('doc_object_id', array('lookup' => array('table' => 'global_entry', 'field' => 'ge_id')));
                 } else {
                     if (in_array($request['type'], array('GLOBAL_PLAIN'))) {
                         // Check foreign key per illuminazione pubblica
                         $this->setFieldAttrib('doc_object_id', array('lookup' => array('table' => 'global_plain', 'field' => 'gp_id')));
                     }
                 }
             }
         }
     }
     if ($files['error'] == 0) {
         $request['doc_file'] = $files['name'];
     }
     if ($this->act != 'del') {
         if ($this->act == 'add') {
             $request['doct_id'] = R3EcoGisHelper::getDocumentTypeIdByCode($request['type']);
         } else {
             $request['doct_id'] = R3EcoGisHelper::getDocumentTypeByDocumentId($request['doc_id']);
         }
         $errors = $this->checkFormData($request);
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $db = ezcDbInstance::get();
         $db->beginTransaction();
         if ($files['error'] == 0) {
             if ($this->hasVirus($files['tmp_name']) === true) {
                 // Verifica la presenza di un virus nel file da caricare
                 return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDocumentVirusError()");
             }
             if ($file_info !== false) {
                 //Remove the old file (Replacement)
                 $this->removeOldFile($file_info['doc_file'], 'document', '', $file_info['doc_file_id']);
             }
             $new_id = $this->getDocFileId($request['doc_id']);
             $request['doc_file_id'] = $new_id;
             $this->addFile($request['doc_file'], 'document', '', $request['doc_file_id'], $files['tmp_name']);
         } else {
             if ($this->act == 'del') {
                 $this->removeOldFile($file_info['doc_file'], 'document', '', $file_info['doc_file_id']);
             } else {
                 // Keey the old values
                 $request['doc_file'] = $file_info['doc_file'];
                 $request['doc_file_id'] = $file_info['doc_file_id'];
             }
         }
         $id = $this->applyData($request);
         $db->commit();
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneDocument({$id})");
     }
 }
Example #7
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $this->defFields();
     // Definisce i campi in base al parametro kind
     $request = $this->translateFields($request);
     // Converte i nomi generici della richiesta in nomi specifici (fr, st_cm)
     if (!R3EcoGisHelper::isValidMunicipality($request['mu_id'])) {
         die("INVALID MUNICIPALITY [{$request['mu_id']}]");
     }
     // Security trap
     $errors = $this->checkFormData($request);
     for ($langId = 1; $langId <= R3AuthInstance::get()->getConfigValue('APPLICATION', 'NUM_LANGUAGES', 1); $langId++) {
         if ($this->objectExistsByName($langId, $request['mu_id'], $request["{$this->prefix}_name_{$langId}"])) {
             $errors["popup_name_{$langId}"] = array('CUSTOM_ERROR' => sprintf(_("{$this->lookupName} con nome \"%s\" esiste già"), $request["{$this->prefix}_name_{$langId}"]));
         }
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $id = $this->applyData($request);
         if ($this->kind == 'fraction') {
             $jsFunc = 'addFractionDlgDone';
         } else {
             if ($this->kind == 'street') {
                 $jsFunc = 'addStreetDlgDone';
             } else {
                 if ($this->kind == 'catmunic') {
                     $jsFunc = 'addCatMunicDlgDone';
                 }
             }
         }
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "{$jsFunc}({$id})");
     }
 }
Example #8
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $data = R3EcoGisHelper::getBuildingData($this->bu_id);
     $this->mu_id = $data['mu_id'];
     $request = array_merge(array('us_id' => ''), $request);
     $request['em_id'] = forceInteger($request['id'], 0, false, '.');
     if ($this->act != 'del') {
         // Change required fields
         if ($request['em_is_production'] == 'T') {
             $request['up_id'] = null;
             $this->setFieldAttrib('esu_id', array('required' => true));
         } else {
             if ($request['us_id'] == '') {
                 $this->setFieldAttrib('esu_id', array('required' => true));
             } else {
                 $this->setFieldAttrib('up_id', array('required' => true));
             }
         }
         if ($request['us_id'] == '') {
             $request['esu_id'] = R3EcoGisHelper::getEnergySourceUdmID($this->do_id, $request['es_id'], $request['udm_id'], $this->mu_id);
         } else {
             $request['esu_id'] = '';
         }
         $request['emo_id'] = R3EcoGisHelper::getEnergyMeterObjectIdByCode('BUILDING');
         $request['em_object_id'] = $request['bu_id'];
         $errors = $this->checkFormData($request);
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $id = $this->applyData($request);
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneMeter({$id})");
     }
 }
Example #9
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $request['us_id'] = (int) $request['id'];
     $request['do_id'] = $this->do_id;
     if ($this->act != 'del') {
         $errors = $this->checkFormData($request);
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $oldLocale = getLocale();
         setLocale(LC_ALL, 'C');
         $db->beginTransaction();
         $oldIds = R3EcoGisUtilityHelper::getProductId($request['us_id']);
         if ($this->act == 'del') {
             // Cancella comuni vecchi
             R3EcoGisUtilityHelper::setMunicipality($request['us_id'], array());
             foreach ($db->query("SELECT up_id FROM utility_product WHERE us_id=" . (int) $request['us_id']) as $row) {
                 R3EcoGisUtilityHelper::deleteProduct(array('up_id' => $row['up_id']));
             }
         }
         $id = $this->applyData($request);
         $newIds = array(0, 1, 2);
         // valori nuovo
         $cantDelete = 'F';
         if ($this->act == 'add' || $this->act == 'mod') {
             $order = 0;
             R3EcoGisUtilityHelper::setMunicipality($id, explode(',', $request['municipality']));
             // Modifica valori vecchi
             foreach ($oldIds as $up_id) {
                 $order += 10;
                 if (isset($request["up_name_1_{$up_id}"]) && $request["up_name_1_{$up_id}"] != '') {
                     R3EcoGisUtilityHelper::updateProduct(array('up_id' => $up_id, 'up_name_1' => $request["up_name_1_{$up_id}"], 'up_name_2' => @$request["up_name_2_{$up_id}"], 'esu_co2_factor' => $request["esu_co2_factor_{$up_id}"], 'ges_id' => $request["ges_id_{$up_id}"], 'up_order' => $order));
                 } else {
                     try {
                         R3EcoGisUtilityHelper::deleteProduct(array('up_id' => $up_id));
                     } catch (Exception $e) {
                         $cantDelete = 'T';
                     }
                 }
             }
             // Aggiunge valori nuovi
             foreach ($newIds as $up_id) {
                 // echo $request["up_name_1_new_{$up_id}"];
                 $order += 10;
                 if (isset($request["up_name_1_new_{$up_id}"]) && $request["up_name_1_new_{$up_id}"] != '') {
                     R3EcoGisUtilityHelper::addProduct(array('do_id' => $this->do_id, 'us_id' => $id, 'up_name_1' => $request["up_name_1_new_{$up_id}"], 'up_name_2' => @$request["up_name_2_new_{$up_id}"], 'up_order' => $order, 'esu_co2_factor' => $request["esu_co2_factor_new_{$up_id}"], 'ges_id' => $request["ges_id_new_{$up_id}"], 'et_code' => $request["et_code_new_{$up_id}"]));
                 }
             }
         }
         $db->commit();
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         setLocale(LC_ALL, $oldLocale);
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataUtilityDone({$id}, '{$cantDelete}')");
     }
 }
Example #10
0
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $request['gpr_id'] = (int) $request['id'];
     //R3Security::checkGlobalPlainRow(@$request['gc_id'], @$request['gp_id']);
     if ($this->act != 'add') {
         $isImportedRow = $this->isImportedRow($request['gpr_id']);
     } else {
         $isImportedRow = false;
     }
     if ($this->is_paes_action && empty($request['gpr_id'])) {
         // Ricava il paes dal comune
         if (empty($request['mu_id'])) {
             $errors['mu_id'] = array('CUSTOM_ERROR' => _("Il campo \"Comune\" è obbligatorio. Se il comune non è presente, verificare un PAES sia associato al comune"));
         }
         $sql = "SELECT gp_id FROM ecogis.global_strategy WHERE gp_id IS NOT NULL AND mu_id=" . (int) $request['mu_id'];
         $gp_id = $db->query($sql)->fetchColumn();
         if (empty($gp_id)) {
             $errors['mu_id'] = array('CUSTOM_ERROR' => _("Per poter inserire un azione assicurarsi di aver associato il PAES al comune nei parametri principali"));
         }
         $request['gp_id'] = $gp_id;
     }
     if ($this->act != 'del') {
         if (!$isImportedRow) {
             $errors = array_merge($errors, $this->checkFormData($request));
         }
         $errors = array_merge($errors, $this->checkFormDataDetail($request, $errors));
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     }
     $db->beginTransaction();
     if ($this->hasGauge($request['gpr_id'])) {
         $request['gpr_gauge_type'] = 'G';
     }
     if ($isImportedRow) {
         // Only update and delete
         if ($this->act == 'del') {
             $errors['gpr_imported_row'] = array('CUSTOM_ERROR' => _("Impossibile cancellare i dati importati"));
             return $this->getAjaxErrorResult($errors);
         }
         $id = $request['gpr_id'];
         $this->updateGaugeType($id, $request['gpr_gauge_type']);
         if (isset($request['gpr_descr_1'])) {
             $this->updateDescription($id, $request);
         }
         $this->submitFormDataDetail($request);
     } else {
         // Standard
         $id = $this->applyData($request);
         $this->submitFormDataDetail($request);
     }
     $db->Commit();
     R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
     return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneGlobalPlainRow({$id})");
 }
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $db->beginTransaction();
     $id = (int) $request['id'];
     R3EcoGisGlobalActionHelper::setGlobalAction($id, explode(',', $request['gpa_id_list']));
     $db->commit();
     R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
     return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneGlobalActionBuilder({$id})");
 }
Example #12
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     if ($this->act != 'add') {
         // Security check
         // R3Security::checkDevice(@$request['id']);
     }
     $request['dev_id'] = $request['id'];
     if ($this->act != 'del') {
         $errors = $this->checkFormData($request);
     } else {
         $request['dt_extradata'] = null;
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $db = ezcDbInstance::get();
         $id = $this->applyData($request);
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneDevice({$id})");
     }
 }
Example #13
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $request['gp_id'] = $request['id'];
     if ($this->act != 'del') {
         if (isset($request['mu_name'])) {
             $request['mu_id'] = R3EcoGisHelper::getMunicipalityIdByName($this->do_id, $request['mu_name'], $this->auth->getParam('mu_id'));
         }
         $request['gp_url_1'] = $this->adjURL($request["gp_url_1"]);
         if (isset($request["gp_url_2"])) {
             $request['gp_url_2'] = $this->adjURL($request["gp_url_2"]);
         }
         $errors = $this->checkFormData($request);
         if (isset($request['mu_name']) && $request['mu_name'] != '' & $request['mu_id'] == '') {
             $errors['mu_name'] = array('CUSTOM_ERROR' => _('Il comune immesso non è stato trovato'));
         }
         if ($request['gp_url_1'] != '' && !$this->isValidURL($request['gp_url_1'])) {
             $errors['gp_url_1'] = array('CUSTOM_ERROR' => _("L'indirizzo immesso non è valido"));
         }
         if (isset($request["gp_url_2"]) && $request['gp_url_2'] != '' && !$this->isValidURL($request['gp_url_2'])) {
             $errors['gp_url_2'] = array('CUSTOM_ERROR' => _("L'indirizzo immesso non è valido"));
         }
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $this->act == 'add' ? R3Security::checkMunicipality($request['mu_id']) : R3Security::checkGlobalPlain(@$request['id']);
         if ($this->act == 'del') {
             $sql = "DELETE FROM global_plain_row WHERE gp_id={$request['gp_id']}";
             $db->exec($sql);
             $sql = "DELETE FROM global_plain_sum WHERE gp_id={$request['gp_id']}";
             $db->exec($sql);
         }
         $id = $this->applyData($request);
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneGlobalPlain({$id})");
     }
 }
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     setLocale(LC_ALL, 'C');
     setLangInfo(array('thousands_sep' => "."));
     $request['gs_id'] = forceInteger($request['id'], 0, false, '.');
     if ($this->act == 'mod') {
         $sql = "SELECT ge_id, gc_id FROM global_subcategory WHERE gs_id={$request['gs_id']}";
         list($request['ge_id'], $request['gc_id']) = $db->query($sql)->fetch(PDO::FETCH_NUM);
     }
     if ($this->act != 'del') {
         $errors = $this->checkFormData($request, $request['kind']);
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $db->beginTransaction();
         // Remove consumption
         $em_list = $this->getEnergyMeterList($request['gs_id']);
         if (count($em_list) > 0) {
             $sql = "DELETE FROM consumption WHERE em_id IN (" . implode(', ', $em_list) . ")";
             // Remove consumption
             $db->exec($sql);
             $sql = "DELETE FROM energy_meter WHERE em_id IN (" . implode(', ', $em_list) . ")";
             // Remove energy_meter
             $db->exec($sql);
         }
         $sql = "DELETE FROM global_data WHERE gs_id=" . $request['gs_id'];
         $db->exec($sql);
         if ($this->act == 'del') {
             $sql = "DELETE FROM global_subcategory WHERE gs_id=" . $request['gs_id'];
             $db->exec($sql);
         } else {
             if (isset($request['gs_tot_value'])) {
                 $request['gs_tot_value'] = $request['gs_tot_value'] * 1000;
             }
             if (isset($request['gs_tot_production_value'])) {
                 $request['gs_tot_production_value'] = $request['gs_tot_production_value'] * 1000;
             }
             if (isset($request['gs_tot_emission_value'])) {
                 $request['gs_tot_emission_value'] = $request['gs_tot_emission_value'] * 1000;
             }
             if (isset($request['gs_tot_emission_factor'])) {
                 $request['gs_tot_emission_factor'] = $request['gs_tot_emission_factor'] * 1000;
             }
             $id = $this->applyData($request);
             $geData = $db->query("SELECT mu_id, ge_year FROM global_entry WHERE ge_id={$request['ge_id']}")->fetch(PDO::FETCH_ASSOC);
             $year = $geData['ge_year'];
             $mu_id = $geData['mu_id'];
             $totalOnly = $db->query("SELECT gc_total_only FROM global_category WHERE gc_id=" . (int) $request['gc_id'])->fetchColumn() == true;
             if (!$totalOnly) {
                 foreach ($request['ges_id_consumption'] as $key => $value) {
                     if (empty($request['ac_expected_energy_saving'][$key])) {
                         continue;
                     }
                     $ges_id = $this->getGlobalEnergySource($request['es_id_consumption'][$key], $request['udm_id_consumption'][$key]);
                     if (empty($ges_id)) {
                         throw new Exception("getGlobalEnergySource(" . $request['es_id_consumption'][$key] . ', ' . $request['udm_id_consumption'][$key] . ") key={$key} faild");
                     }
                     $sql = "INSERT INTO global_data (ges_id, gs_id) VALUES ({$ges_id}, {$id})";
                     $db->exec($sql);
                     $gd_id = $db->lastInsertId('global_data_gd_id_seq');
                     $esu_id = R3EcoGisHelper::getEnergySourceUdmID($this->do_id, $request['es_id_consumption'][$key], $request['udm_id_consumption'][$key], $mu_id, false);
                     if (!empty($esu_id)) {
                         $em_id = R3EcoGisHelper::addDummyEnergyMeter(array('esu_id' => $esu_id, 'em_object_id' => $gd_id), 'GLOBAL_ENERGY');
                         $data = array();
                         $data['co_start_date'] = "'{$year}-01-01'";
                         $data['co_end_date'] = "'{$year}-12-31'";
                         $data['co_value'] = forceFloat($request['ac_expected_energy_saving'][$key], null, '.');
                         $data['co_bill'] = 0;
                         $data['em_id'] = $em_id;
                         if (in_array($this->kind, array('ENERGY_PRODUCTION', 'HEATH_PRODUCTION'))) {
                             $data['co_production_co2_factor'] = (double) forceFloat($request['co_production_co2_factor'][$key], null, '.');
                         }
                         $sql = "INSERT INTO consumption (" . implode(', ', array_keys($data)) . ") VALUES (" . implode(', ', $data) . ")";
                         $db->exec($sql);
                     } else {
                         throw new Exception("Unknown esu [es_id={$request['es_id_consumption'][$key]}; udm_id={$request['udm_id_consumption'][$key]}; do_id={$this->do_id}; mu_id={$mu_id}]");
                     }
                 }
             }
             if (isset($request['geometryStatus']) && strtoupper($request['geometryStatus']) == 'CHANGED') {
                 $session_id = session_id();
                 $sql = "UPDATE global_subcategory\r\n                            SET the_geom=foo.the_geom\r\n                            FROM (SELECT MULTI(ST_Force_2d(ST_union(ST_Buffer(the_geom, 0.0)))) AS the_geom FROM edit_tmp_polygon WHERE session_id='{$session_id}') AS foo\r\n                            WHERE gs_id={$id}";
                 $db->exec($sql);
             }
         }
         $db->commit();
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneEnergySourceRow({$id}, '{$this->kind}')");
     }
 }
Example #15
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $request = array_merge(array('us_id' => ''), $request);
     $request['ge_id'] = forceInteger($request['id'], 0, false, '.');
     if ($this->act != 'del') {
         $request['mu_id'] = $this->checkFormDataForMunicipality($request, $errors);
         $errors = $this->checkFormData($request, $errors);
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         if ($this->act == 'mod') {
             $this->removeField('mu_id');
             $this->removeField('ge_year');
         }
         // Convert from MWh to kWh
         if (isset($request['ge_green_electricity_purchase'])) {
             $request['ge_green_electricity_purchase'] = $request['ge_green_electricity_purchase'] * 1000;
         }
         $id = $this->applyData($request);
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneGlobalResult({$id})");
     }
 }
Example #16
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $request['esu_id'] = (int) $request['id'];
     $request['do_id'] = $this->do_id;
     $this->setMunicipalityForUser($request);
     if ($this->act == 'add' && $request['mu_id'] == '') {
         $errors['mu_id'] = array('CUSTOM_ERROR' => _("Indicare il comune su cui attivare questo fattore di conversione"));
     }
     if ($this->act != 'del') {
         $request['es_id'] = (int) $request['es_id'];
         $request['udm_id'] = (int) $request['udm_id'];
         $request['mu_id'] = (int) $request['mu_id'];
         $errors = $this->checkFormData($request, $errors);
         $sql = "SELECT COUNT(*) FROM energy_source_udm WHERE es_id={$request['es_id']} AND udm_id={$request['udm_id']} AND do_id={$request['do_id']} AND mu_id={$request['mu_id']}";
         if ($this->act == 'mod') {
             $sql .= " AND esu_id<>" . $request['esu_id'];
         }
         if ($db->query($sql)->fetchColumn() > 0) {
             $errors['es_id'] = array('CUSTOM_ERROR' => _("L'alimentazione e l'unità di misura immesse esistono già"));
         }
         $request['mu_id'] = $mu_id = (int) $request['mu_id'] > 0 ? (int) $request['mu_id'] : null;
         if ($mu_id == 0) {
             $request['mu_id'] = $mu_id = null;
         }
     } else {
         // Ricavo valori per spostamento fattori di conversione
         $data = $db->query("SELECT es_id, udm_id, mu_id FROM energy_source_udm WHERE esu_id={$request['esu_id']}")->fetch(PDO::FETCH_ASSOC);
         $request['es_id'] = $data['es_id'];
         $request['udm_id'] = $data['udm_id'];
         $mu_id = $data['mu_id'];
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $db->beginTransaction();
         $request['ges_id'] = R3EcoGisESUHelper::getGlobalEnergySource($this->do_id, $request['es_id'], $request['udm_id']);
         $changed = 0;
         if ($mu_id > 0 && $this->act == 'del') {
             // Converte la fonte del comune in fonte generica (del dominio)
             $changed = R3EcoGisESUHelper::updateEnergySourceUDM($this->do_id, $request['es_id'], $request['udm_id'], $mu_id, true);
         }
         $id = $this->applyData($request);
         if ($mu_id > 0 && $this->act == 'add') {
             // Converte la vecchia fonte con la nuova per tutto il comune
             $changed = R3EcoGisESUHelper::updateEnergySourceUDM($this->do_id, $request['es_id'], $request['udm_id'], $mu_id);
         }
         $db->commit();
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataEnergySourceUDMDone({$id}, " . ($changed ? 1 : 0) . ")");
     }
 }
Example #17
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $db = ezcDbInstance::get();
     if ($this->act == 'del') {
         $id = (int) $request['id'];
         $mu_id = $db->query("SELECT mu_id\r\n                                 FROM ecogis.document_data doc\r\n                                 INNER JOIN ecogis.municipality mu ON doc.doc_object_id=mu_id AND doct_code='SEAP'\r\n                                 WHERE do_id={$this->do_id} AND doc_id={$id}")->fetchColumn();
         $db->beginTransaction();
         $this->deleteImportedData($mu_id);
         // Delete document
         $file_info = $this->getDocFileInfo($id);
         $this->removeOldFile($file_info['doc_file'], 'import_seap', '', $file_info['doc_file_id']);
         $request['doc_id'] = $id;
         $id = $this->applyData($request);
         $db->commit();
         die;
     }
     $files = R3EcoGisHelper::getUploadedFile('doc_file');
     $errors = array();
     if ($files['error'] != 0) {
         if ($files['error'] == UPLOAD_ERR_NO_FILE) {
             $errors['doc_file'] = array('CUSTOM_ERROR' => _('Bisogna indicare il file da caricare'));
         } else {
             $errors['doc_file'] = array('CUSTOM_ERROR' => _("Si è veificato un errore durante il caricamento del file. Si prega di riprovare. Errore #") . $files['error']);
         }
     }
     $mu_id = $this->auth->getParam('mu_id') != '' ? $this->auth->getParam('mu_id') : (int) $this->mu_id;
     $istat = $db->query("SELECT mu_istat FROM ecogis.municipality WHERE do_id={$this->do_id} AND mu_id={$mu_id}")->fetchColumn();
     if ($istat == '') {
         $errors['mu_id'] = array('CUSTOM_ERROR' => _("Indicare il comune per cui si intende importare i dati"));
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     }
     $db->beginTransaction();
     $result = $this->importDataFromTemplate($files['tmp_name'], $istat);
     if (!$result['done']) {
         $errors['doc_file'] = array('CUSTOM_ERROR' => $result['log']);
         return $this->getAjaxErrorResult($errors);
     }
     // Insert into document
     // Remove old document
     $doc_id = $db->query("SELECT doc_id\r\n                              FROM ecogis.document_data doc\r\n                              INNER JOIN ecogis.municipality mu ON mu_id=doc_object_id\r\n                              WHERE doct_code='SEAP' AND do_id={$this->do_id} AND doc_object_id={$mu_id}")->fetchColumn();
     if ($doc_id != '') {
         $file_info = $this->getDocFileInfo($doc_id);
         $this->removeOldFile($file_info['doc_file'], 'import_seap', '', $file_info['doc_file_id']);
         $db->exec("DELETE FROM ecogis.document WHERE doc_id={$doc_id}");
     }
     $request['doc_title_1'] = _('Import PAES');
     $request['doc_descr_1'] = json_encode($result['log']);
     $request['doc_object_id'] = $mu_id;
     $request['doc_file'] = $files['name'];
     $request['doc_file_id'] = $this->getDocFileId();
     $request['doct_id'] = R3EcoGisHelper::getDocumentTypeIdByCode('SEAP');
     $request['doc_date'] = date('Y-m-d');
     $this->addFile($request['doc_file'], 'import_seap', '', $request['doc_file_id'], $files['tmp_name']);
     $id = $this->applyData($request);
     $db->commit();
     R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
     return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneImportSeap({$id})");
 }
Example #18
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $default = array('ge_id' => null, 'ge_id_2' => null);
     $request = array_merge($default, $request);
     if ($this->auth->getParam('mu_id') != '') {
         // override the default action if it is a municipality user
         $sql = "SELECT gst_id FROM global_strategy WHERE mu_id=" . $db->quote($this->auth->getParam('mu_id'));
         $this->id = $db->query($sql)->fetchColumn();
         $this->act = $this->id > 0 ? 'mod' : 'add';
         $request['act'] = $this->act;
     }
     if ($this->act != 'add') {
         R3Security::checkGlobalStrategy(@$request['id']);
     }
     $request['gst_id'] = $request['id'];
     if (isset($request['mu_name'])) {
         $request['mu_id'] = R3EcoGisHelper::getMunicipalityIdByName($this->do_id, $request['mu_name'], $this->auth->getParam('mu_id'));
     }
     if ($this->act != 'del') {
         $errors = $this->checkFormData($request);
         if (isset($request['mu_name']) && $request['mu_name'] != '' & $request['mu_id'] == '') {
             $errors['mu_name'] = array('CUSTOM_ERROR' => _('Il comune immesso non è stato trovato'));
         }
         if ($request['gst_reduction_target'] < 20) {
             $errors['gst_reduction_target'] = array('CUSTOM_ERROR' => _("L'obiettivo previsto deve essere di almento 20%%"));
         }
         if ($request['gst_reduction_target_year'] != 2020) {
             $errors['gst_reduction_target_year'] = array('CUSTOM_ERROR' => _("L'anno dell'obiettivo deve essere 2020"));
         }
         if ($request['gst_reduction_target_long_term'] != '' && ($request['gst_reduction_target_year_long_term'] != '' xor $request['gst_reduction_target_citizen_long_term'] != '')) {
             $errors['gst_reduction_target_long_term'] = array('CUSTOM_ERROR' => _('I valori "Obiettivo a lungo termine", "Anno lungo termine" e "Abitanti lungo temine", (se indicati) devono essere presenti'));
         }
         if ($request['ge_id'] != '' && $request['ge_id_2'] != '' && $request['ge_id'] == $request['ge_id_2']) {
             $errors['ge_id_2'] = array('CUSTOM_ERROR' => _("L'inventario e l'inventario 2 devono essere diversi"));
         }
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $id = $this->applyData($request);
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneGlobalStrategy({$id})");
     }
 }
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $request['gt_id'] = $request['id'];
     if ($this->act != 'del') {
         $request['gt_code'] = strtoupper($request['gt_code']);
         $errors = $this->checkFormData($request);
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $db->beginTransaction();
         $id = $this->applyData($request);
         if ($this->act != 'del') {
             R3EcoGisGlobalResultTableHelper::setGlobalEnergySourceType($id, explode(',', $request['global_energy_source_type']));
             R3EcoGisGlobalResultTableHelper::setGlobalCategoryType($id, explode(',', $request['global_category']));
         }
         $db->commit();
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneGlobalResultTableBuilder({$id})");
     }
 }
Example #20
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $errors = array();
     $db = ezcDbInstance::get();
     $auth = R3AuthInstance::get();
     $this->setMunicipalityForUser($request);
     if ($this->act != 'add' && !defined('UNIT_TEST_MODE')) {
         // Security check
         R3Security::checkBuilding(@$request['id']);
     }
     $request['bu_id'] = $request['id'];
     if (isset($request['mu_name'])) {
         $request['mu_id'] = R3EcoGisHelper::getMunicipalityIdByName($this->do_id, $request['mu_name'], $this->auth->getParam('mu_id'));
     }
     if (isset($request['fr_name'])) {
         $request['fr_id'] = R3EcoGisHelper::getFractionIdByName($this->do_id, $request['mu_id'], $request['fr_name']);
     }
     if (isset($request['st_name'])) {
         $request['st_id'] = R3EcoGisHelper::getStreetIdByName($this->do_id, $request['mu_id'], $request['st_name']);
     }
     if ($this->act != 'del') {
         $errors = $this->checkFormData($request);
         if ($auth->getConfigValue('APPLICATION', 'BUILDING_CODE_REQUIRED') == 'T' && trim($request['bu_code']) == '') {
             $errors['bu_code'] = array('CUSTOM_ERROR' => _('Il campo "Codice edificio" è obbligatorio'));
         }
         if (isset($request['mu_name']) && $request['mu_name'] != '' && $request['mu_id'] == '') {
             $errors['mu_name'] = array('CUSTOM_ERROR' => _('Il comune immesso non è stato trovato'));
         }
         if (isset($request['fr_name']) && $request['fr_name'] != '' && $request['fr_id'] == '') {
             $errors['fr_name'] = array('CUSTOM_ERROR' => _('La frazione immessa non è stata trovata'));
         }
         if (isset($request['st_name']) && $request['st_name'] != '' && $request['st_id'] == '') {
             $errors['st_name'] = array('CUSTOM_ERROR' => _('La strada immessa non è stata trovata'));
         }
         if ($request['bu_usage_weeks'] > 52) {
             $errors['bu_usage_weeks'] = array('CUSTOM_ERROR' => _('Numero di settimane massimo inseribile: 52'));
         }
         if ($auth->getConfigValue('APPLICATION', 'BUILDING_CODE_UNIQUE') == 'T' && !$this->checkBuildingCodeUnique($request['mu_id'], $request['bu_code'], $request['id'])) {
             $errors['bu_code'] = array('CUSTOM_ERROR' => _('Il campo "Codice edificio" non è univoco'));
         }
         if ($this->act == 'mod') {
             // Check compatibility between action and building purpose use
             $this->checkBuildingPurposeUseCompatibility($request['id'], $request['bpu_id'], $errors);
         }
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         $deleteIDs = array();
         // Array che contiene l'elenco delle immagini da cancellare (processato dopo il commit per evitare perdita di dati!)
         $db->beginTransaction();
         if ($this->act != 'del') {
             $id = $this->applyData($request);
             // Update compatibility between action and building purpose use
             $this->updateBuildingPurposeUseCompatibility($request['id'], $request['bpu_id']);
             // Delete photo marked as delete
             foreach ($this->getOldImagesIDs($id, null) as $photoID) {
                 if (isset($request["photo_{$photoID}_delete"]) || isset($request["label_{$photoID}_delete"]) || isset($request["thermography_{$photoID}_delete"])) {
                     $deleteIDs[] = $photoID;
                 }
             }
             // Save images
             $uploads = array('bu_photo' => 'photo', 'bu_label' => 'label', 'bu_thermography' => 'thermography');
             foreach ($uploads as $upload => $kind) {
                 if (isset($_FILES[$upload])) {
                     $tot = count($_FILES[$upload]['name']);
                     for ($i = 0; $i < $tot; $i++) {
                         if ($_FILES[$upload]['error'][$i] == 0) {
                             $deleteIDs = array_merge($deleteIDs, $this->getOldImagesIDs($id, $kind));
                             $doc_file_id = $this->getDocFileId();
                             $this->addFile($_FILES[$upload]['name'][$i], 'building', $kind, $doc_file_id, $_FILES[$upload]['tmp_name'][$i]);
                             $doct_id = R3EcoGisHelper::getDocumentTypeIdByCode(strtoupper("BUILDING_{$kind}"));
                             $sql = "INSERT INTO document (doc_object_id, doct_id, doc_file_id, doc_file, doc_date) VALUES ({$id}, {$doct_id}, {$doc_file_id}, " . $db->quote($_FILES[$upload]['name'][$i]) . ", NOW()) ";
                             $db->exec($sql);
                         }
                     }
                 }
             }
             // Save map
             if (isset($request['geometryStatus']) && strtoupper($request['geometryStatus']) == 'CHANGED') {
                 $session_id = session_id();
                 $sql = "UPDATE building\n                            SET the_geom=foo.the_geom\n                            FROM (SELECT MULTI(ST_Force_2d(ST_union(ST_Buffer(the_geom, 0.0)))) AS the_geom FROM edit_tmp_polygon WHERE session_id='{$session_id}') AS foo\n                            WHERE bu_id={$id}";
                 $db->exec($sql);
             }
         } else {
             $id = $this->applyData($request);
             $deleteIDs = $this->getOldImagesIDs($id, null);
             // Delete old images
         }
         $db->commit();
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         $this->removeOldFilesByIDs(array_unique($deleteIDs));
         R3EcoGisCacheHelper::resetMapPreviewCache(null);
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneBuilding({$id})");
     }
 }
Example #21
0
 /**
  * Ajax request to submit data
  * @param array $request   the request
  * @return array           ajax format status
  */
 public function submitFormData($request)
 {
     $request = array_merge(array('insert_type' => 'free', 'reinsert' => ''), $request);
     $db = ezcDbInstance::get();
     $data = array();
     $errors = array();
     if ($request['kind'] == 'street_lighting' && $this->act == 'add') {
         // Valore finto per bypassare controlli automatici
         $request['em_id'] = '-1';
     }
     $checkDate = false;
     if ($this->act != 'del') {
         switch ($request['insert_type']) {
             case 'free':
                 $checkDate = true;
                 $data[] = array('act' => $request['act'], 'co_start_date' => forceISODate($request['co_start_date_free']), 'co_end_date' => forceISODate($request['co_end_date_free']), 'co_value' => forceFloat($request['co_value_free'], null, '.'), 'co_bill' => forceFloat($request['co_bill_free'], null, '.'), 'co_bill_is_calculated' => 'F', 'em_id' => $request['em_id'], 'co_id' => forceInteger($request['id'], 0, false, '.'));
                 break;
             case 'month':
                 for ($i = 0; $i < 12; $i++) {
                     if ($request['co_start_date_month'][$i] != '' && $request['co_end_date_month'][$i] != '' && $request['co_value_month'][$i] != '' && $request['co_bill_month'][$i] != '') {
                         $data[] = array('act' => $request['act'], 'co_start_date' => forceISODate($request['co_start_date_month'][$i]), 'co_end_date' => forceISODate($request['co_end_date_month'][$i]), 'co_value' => forceFloat($request['co_value_month'][$i], null, '.'), 'co_bill' => forceFloat($request['co_bill_month'][$i], null, '.'), 'co_bill_is_calculated' => 'F', 'em_id' => $request['em_id']);
                     }
                 }
                 if (count($data) == 0) {
                     $errors['dummy'] = array('CUSTOM_ERROR' => _('Impossibile salvare. Nessun dato valido inserito'));
                 }
                 break;
             case 'year':
                 $data[] = array('act' => $request['act'], 'co_start_date' => forceISODate($request['co_start_date_year']), 'co_end_date' => forceISODate($request['co_end_date_year']), 'co_value' => forceFloat($request['co_value_year'], null, '.'), 'co_bill' => forceFloat($request['co_bill_year'], null, '.'), 'co_bill_is_calculated' => 'F', 'em_id' => $request['em_id']);
                 break;
         }
         foreach ($data as $values) {
             $errors = $this->checkFormData($values, $errors);
         }
         if ($checkDate) {
             // Verifica data inserimento per bollette singole
             if (forceISODate($request['co_start_date_free']) > forceISODate($request['co_end_date_free'])) {
                 $errors['co_end_date_bis'] = array('CUSTOM_ERROR' => _("La data di fine periodo precedenta a quella di inizio"));
             }
         }
     }
     if (count($errors) > 0) {
         return $this->getAjaxErrorResult($errors);
     } else {
         if ($this->act == 'del') {
             $request['co_id'] = forceInteger($request['id'], 0, false, '.');
             if ($request['kind'] == 'street_lighting') {
                 // Ricavo contatore finto per cancellazione
                 $db->beginTransaction();
                 $em_id = $db->query("SELECT em_id FROM consumption WHERE co_id={$request['co_id']}")->fetchColumn();
                 $id = $this->applyData($request);
                 if ($db->query("SELECT COUNT(*) FROM consumption WHERE em_id={$em_id}")->fetchColumn() == 0) {
                     $db->exec("DELETE FROM energy_meter WHERE em_id={$em_id}");
                 }
                 $db->commit();
             } else {
                 $id = $this->applyData($request);
             }
         } else {
             $db->beginTransaction();
             if ($request['kind'] == 'street_lighting' && $this->act == 'add') {
                 $em_id = R3EcoGisHelper::getDummyEnergyMeter('STREET_LIGHTING', $request['sl_id']);
                 if ($em_id == '') {
                     // Aggiungo contatore finto per tratto stradale
                     $electricityData = $this->getElectricityUDMData($_SESSION['do_id']);
                     $em_id = R3EcoGisHelper::addDummyEnergyMeter(array('esu_id' => $electricityData['esu_id'], 'em_object_id' => $request['sl_id']), 'STREET_LIGHTING');
                 }
                 $data[0]['em_id'] = $em_id;
             }
             $id = array();
             foreach ($data as $values) {
                 $id[] = $this->applyData($values);
             }
             $db->commit();
         }
         R3EcoGisEventNotifier::notifyDataChanged($this, array('data_changed' => true));
         return array('status' => R3_AJAX_NO_ERROR, 'js' => "submitFormDataDoneConsumption(" . json_encode($id) . ", '{$request['reinsert']}')");
     }
 }