示例#1
0
 /**
  * Return the filter values (list form)
  */
 public function getFilterValues()
 {
     $filters = array();
     $filters['st_parent_id_values'] = R3EcogisHelper::getStatisticMainList($this->do_id);
     $filters['st_parent_id'] = $this->st_parent_id;
     $filters['st_name'] = $this->st_name;
     return $filters;
 }
示例#2
0
 public function fetch_eneryClassLimit($request)
 {
     return R3EcogisHelper::getEnergyClassLimitList($request['ez_id'], $request['ec_id'], $this->do_id, array('allow_empty' => true));
 }
示例#3
0
 /**
  * Return the UDM
  * @param array $request    the request
  * @return array            the result data
  */
 public function fetchUDM($request)
 {
     return array('status' => R3_AJAX_NO_ERROR, 'data' => R3EcoGisHelper::forceJSonArray(R3EcogisHelper::getEnergyUDMListByEnergySource($this->do_id, $request['kind'], $request['es_id'], array('constraints' => 'esu_allow_in_building IS TRUE'))));
 }
示例#4
0
 public function defFields()
 {
     $mu_id = R3EcogisHelper::getDefaultMunicipality();
     $fields = array(array('name' => 'st_id', 'type' => 'number', 'is_primary_key' => true), array('name' => 'mu_id', 'type' => 'lookup', 'width' => 200, 'label' => _('Comune'), 'kind' => $this->act != 'add' ? 'readonly' : null, 'required' => true, 'lookup' => array('table' => 'municipality', 'list_field' => 'mu_name_<LANG>'), 'filter' => array('type' => 'select', 'fields' => array('mu_id', 'mu_name_<LANG>'), 'where' => 'do_id=<DOMAIN_ID>', 'cond_where' => array('mu_id' => $mu_id)), 'visible' => $mu_id == '', 'default' => $mu_id), array('name' => 'st_code', 'type' => 'text', 'label' => _('Codice'), 'filter' => array('type' => 'text', 'label' => 'Codice/nome', 'mask' => "(%s ILIKE '%%%2\$s%%') OR (st_name_1 ILIKE '%%%2\$s%%') OR (st_name_2 ILIKE '%%%2\$s%%')"), 'width' => 200, 'attr' => array('sortable' => true, 'order_fields' => 'st_code_pad, st_name_1, st_name_2, st_id')), array('name' => 'st_name_1', 'type' => 'text', 'required' => true, 'label' => _('Nome') . getLangNameShort(1), 'delete_name' => true), array('name' => 'st_name_2', 'type' => 'text', 'required' => R3AuthInstance::get()->getConfigValue('APPLICATION', 'NUM_LANGUAGES', 1) > 1, 'visible' => R3AuthInstance::get()->getConfigValue('APPLICATION', 'NUM_LANGUAGES', 1) > 1, 'label' => _('Nome') . getLangNameShort(2)), array('name' => 'st_lkp_name_1', 'type' => 'text', 'required' => false, 'label' => _('Nome lookup') . getLangNameShort(1)), array('name' => 'st_lkp_name_2', 'type' => 'text', 'required' => false, 'visible' => R3AuthInstance::get()->getConfigValue('APPLICATION', 'NUM_LANGUAGES', 1) > 1, 'label' => _('Nome lookup') . getLangNameShort(2)), array('name' => 'st_visible', 'type' => 'boolean', 'default' => true, 'label' => _('Visibile')));
     return $fields;
 }
示例#5
0
 public function getStreetList($request)
 {
     $db = ezcDbInstance::get();
     $lang = R3Locale::getLanguageID();
     $like = isset($request['term']) ? $request['term'] : null;
     $limit = isset($request['limit']) ? $request['limit'] : null;
     if (isset($request['mu_name'])) {
         $request['mu_id'] = (int) $db->query("SELECT mu_id FROM municipality WHERE mu_name_{$lang} ILIKE " . $db->quote($request['mu_name']))->fetchColumn();
     }
     if (isset($request['autocomplete'])) {
         return R3EcogisHelper::getStreetList($_SESSION['do_id'], $request['mu_id'], array('like' => $like, 'limit' => $limit, 'allow_empty' => false));
     }
     return array('status' => R3_AJAX_NO_ERROR, 'data' => R3EcoGisHelper::forceJSonArray(R3EcogisHelper::getStreetList($_SESSION['do_id'], $request['mu_id'], array('allow_empty' => true))));
 }
示例#6
0
 /**
  * Return the UDM
  * @param array $request    the request
  * @return array            the result data
  */
 public function fetch_udm($request)
 {
     return array('status' => R3_AJAX_NO_ERROR, 'data' => R3EcogisHelper::getEnergyUDMListByEnergySource($_SESSION['do_id'], $request['kind'], $request['es_id']));
 }
示例#7
0
 public function defFields()
 {
     $mu_id = R3EcogisHelper::getDefaultMunicipality();
     $fields = array(array('name' => 'cm_id', 'type' => 'number', 'is_primary_key' => true), array('name' => 'mu_id', 'type' => 'lookup', 'width' => 200, 'label' => _('Comune'), 'required' => true, 'lookup' => array('table' => 'municipality', 'list_field' => 'mu_name_<LANG>'), 'filter' => array('type' => 'select', 'fields' => array('mu_id', 'mu_name_<LANG>'), 'where' => 'do_id=<DOMAIN_ID>', 'cond_where' => array('mu_id' => $mu_id)), 'visible' => $mu_id == '', 'default' => $mu_id), array('name' => 'cm_code', 'type' => 'text', 'label' => _('Codice'), 'width' => 200), array('name' => 'cm_name_1', 'type' => 'text', 'required' => true, 'label' => _('Nome') . getLangNameShort(1), 'delete_name' => true), array('name' => 'cm_name_2', 'type' => 'text', 'required' => R3AuthInstance::get()->getConfigValue('APPLICATION', 'NUM_LANGUAGES', 1) > 1, 'visible' => R3AuthInstance::get()->getConfigValue('APPLICATION', 'NUM_LANGUAGES', 1) > 1, 'label' => _('Nome') . getLangNameShort(2)), array('name' => 'cm_visible', 'type' => 'boolean', 'default' => true, 'label' => _('Visibile')));
     return $fields;
 }