/**
* Return Nginx service Data
* @param array $params
* @return array
*/
public function getServiceDataDatabaseConnections(array $params)
{
$dataPostgresql = new \Cityware\Monitoring\Models\Services\DataPostgreSql($params);
$connectionsDatabases = $dataPostgresql->getDataPgSqlDatabasesConnections();
$return = array();
$geoipV1 = new \Cityware\Utility\GeoIpV1();
$geoipV1->geoip_open(DATA_PATH . 'GeoIp/GeoIPASNum.dat', GEOIP_STANDARD);
foreach ($connectionsDatabases as $key => $value) {
$desAsnIsp = !empty($value['client_addr']) ? \Cityware\Format\Text::convertString($geoipV1->geoip_name_by_addr($value['client_addr'])) : '';
$return[$key]['des_ip'] = $value['client_addr'];
$return[$key]['des_asn_isp'] = strtoupper(\Cityware\Format\Text::removeAccents($desAsnIsp));
$return[$key]['des_hash'] = hash('crc32b', $value['datname']);
$return[$key]['nam_database'] = $value['datname'];
$return[$key]['num_total_connections'] = $value['total_connections'];
}
return $return;
}
/**
* Função de geração dos dados de configuração da grid
* @return string
*/
private function genConfigDatagridIni()
{
$classTable = \Cityware\Format\Text::convertTableName($this->table);
$aliases = explode("_", $this->table);
$alias = '';
foreach ($aliases as $value) {
$alias .= strtolower($value[0]);
}
$return = "[gridconfig]\n\n";
$return .= "grid.module = \"{$this->module}\"\n";
$return .= "grid.controller = \"{$this->controller}\"\n";
if ($this->schema != null) {
$return .= "grid.schema = \"{$this->schema}\"\n";
}
$return .= "grid.table = \"{$this->table}\"\n";
$return .= "grid.tableAlias = \"{$alias}\"\n";
$return .= "grid.tableClass = \"{$classTable}\"\n";
$return .= "grid.orderdefault = \"ASC\"\n";
return $return;
}
/**
* Função de geração dos dados de configuração do formulário
* @return string
*/
private function genConfigFormIni()
{
$classTable = \Cityware\Format\Text::convertTableName($this->table);
$return = "[formconfig]\n\n";
$return .= "form.module = \"{$this->module}\"\n";
$return .= "form.controller = \"{$this->controller}\"\n";
$return .= "form.enctype = \"multipart/form-data\"\n";
$return .= "form.method = \"post\"\n";
if ($this->schema != null) {
$return .= "form.schema = \"{$this->schema}\"\n";
}
$return .= "form.destination = \"{$this->controller}\"\n";
$return .= "form.table = \"{$this->table}\"\n";
$return .= "form.tableClass = \"{$classTable}\"\n";
$return .= "form.pathfiles = \"{$this->controller}\"\n";
$return .= "form.id = \"form{$classTable}\"\n";
return $return;
}
