/** * 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; }