public static function getDateSeparator()
{
$fmt = R3Locale::getPhpDateFormat();
if ($fmt == '') {
return null;
}
return $fmt[1];
}
public function convert2Locale($vlu)
{
if (!is_array($vlu)) {
return $vlu;
}
setLangInfo(array('thousands_sep' => "."));
foreach ($this->fields as $key => $field) {
if (isset($field['name'])) {
$key = $field['name'];
if (isset($field['dec']) && !isset($field['precision'])) {
$field['precision'] = $field['dec'];
}
if (array_key_exists($key, $vlu)) {
if ($vlu[$key] === null) {
$vlu[$key] = '';
} else {
$type = strToLower($field['type']);
switch ($field['type']) {
case 'real':
case 'double':
case 'number':
case 'float':
$vlu[$key] = R3NumberFormat($vlu[$key], isset($field['precision']) ? $field['precision'] : null, true);
break;
case 'integer':
$vlu[$key] = R3NumberFormat($vlu[$key], isset($field['precision']) ? $field['precision'] : 0, true);
break;
case 'date':
$vlu[$key] = SQLDateToStr($vlu[$key], R3Locale::getPhpDateFormat());
break;
case 'datetime':
case 'now':
$vlu[$key] = SQLDateToStr($vlu[$key], R3Locale::getPhpDateTimeFormat());
break;
case 'boolean':
if ($vlu[$key] === true) {
$vlu[$key] = 'T';
} else {
if ($vlu[$key] === false) {
$vlu[$key] = 'F';
}
}
}
}
}
}
}
return $vlu;
}
public function convert2Locale(array $vlu)
{
// Change to locale
$oldMessageLocale = setlocale(LC_MESSAGES, 0);
$oldNumericLocale = setlocale(LC_NUMERIC, 0);
setlocale(LC_NUMERIC, getLocaleInfo(R3Locale::getLanguageCode()));
setLangInfo(array('thousands_sep' => "."));
foreach ($this->fields as $key => $field) {
if (isset($field['name'])) {
$key = $field['name'];
if (isset($field['dec']) && !isset($field['precision'])) {
$field['precision'] = $field['dec'];
}
if (isset($field['is_primary_key']) && $field['is_primary_key'] === true) {
continue;
}
if (array_key_exists($key, $vlu)) {
if ($vlu[$key] === null) {
$vlu[$key] = '';
// IE Fix in json response
} else {
$type = strToLower($field['type']);
switch ($field['type']) {
case 'real':
case 'double':
case 'number':
case 'float':
$vlu[$key] = R3NumberFormat($vlu[$key], isset($field['precision']) ? $field['precision'] : null, true);
break;
case 'integer':
$vlu[$key] = R3NumberFormat($vlu[$key], isset($field['precision']) ? $field['precision'] : 0, true);
break;
case 'date':
$vlu[$key] = SQLDateToStr($vlu[$key], R3Locale::getPhpDateFormat());
break;
case 'datetime':
case 'now':
$vlu[$key] = SQLDateToStr($vlu[$key], R3Locale::getPhpDateTimeFormat());
break;
case 'boolean':
if ($vlu[$key] === true) {
$vlu[$key] = 'T';
} else {
if ($vlu[$key] === false) {
$vlu[$key] = 'F';
}
}
}
}
}
}
}
setlocale(LC_MESSAGES, $oldMessageLocale);
setlocale(LC_NUMERIC, $oldNumericLocale);
return $vlu;
}
/**
* Return the filter values (list form)
*/
public function getFilterValues()
{
$filters = array();
$filters = array();
if ($this->auth->getParam('mu_id') == '') {
$filters['pr_values'] = R3EcoGisHelper::getProvinceList($this->do_id, array('join_with_simulation' => true));
$filters['mu_values'] = R3EcoGisHelper::getMunicipalityAndMunicipalityCollectionList($this->do_id, null, null, array('join_with_simulation' => true));
} else {
$filters['mu_values'] = array($this->auth->getParam('mu_id') => '');
}
if (count($filters['mu_values']) == 1) {
$mu_id = key($filters['mu_values']);
$filters['fr_values'] = R3EcoGisHelper::getFractionList($this->do_id, $mu_id, array('used_by' => 'building'));
$filters['st_values'] = R3EcoGisHelper::getStreetList($this->do_id, $mu_id, array('used_by' => 'building'));
} else {
$mu_id = null;
}
$filters['do_id'] = $this->do_id;
$filters['pr_id'] = $this->pr_id;
$filters['mu_id'] = $this->mu_id;
$filters['mu_name'] = $this->mu_name;
$filters['sw_title'] = $this->sw_title;
$filters['sw_date_from'] = SQLDateToStr($this->sw_date_from, R3Locale::getPhpDateFormat());
$filters['sw_date_to'] = SQLDateToStr($this->sw_date_to, R3Locale::getPhpDateFormat());
return $filters;
}
