public static function connection($username = null, $password = null, $environment = 'dev', $connection = null)
{
// se não for passado o usuário ou a senha, então busca pelo arquivo de configuração.
if (!$username || !$password) {
$config = autoload_config();
$connection = is_null($connection) ? $config['database']['DB_DEFAULT_CONN'] : $connection;
foreach ($config['database']['connections'][$environment] as $key) {
if ($key['connection'] === $connection) {
$username = $key['username'];
$password = $key['password'];
}
}
}
Session::destroy();
Session::set('s_username', $username);
Session::set('s_password', base64_encode($password));
Session::set('s_environment', $environment);
$database = new \Database\Database();
if ($error = $database->getInstance()->getError()) {
return $error;
} else {
Session::set('s_loggedIn', Session::get('s_token') . md5($username . $password));
return false;
}
}
public static function send($to = [], $subject = '', $message = '', $attach = [])
{
$config = autoload_config();
if (self::$server === 'smtp') {
self::getInstance()->isSMTP();
self::getInstance()->SMTPSecure = $config['mailer'][self::$server]['secure'];
self::getInstance()->SMTPDebug = $config['mailer'][self::$server]['debug'];
self::getInstance()->SMTPAuth = $config['mailer'][self::$server]['auth'];
}
self::getInstance()->Host = $config['mailer'][self::$server]['host'];
self::getInstance()->Port = $config['mailer'][self::$server]['port'];
self::getInstance()->Username = $config['mailer'][self::$server]['username'];
self::getInstance()->Password = $config['mailer'][self::$server]['password'];
self::getInstance()->SetFrom($config['mailer'][self::$server]['email'], $config['mailer'][self::$server]['name']);
self::getInstance()->AddReplyTo($config['mailer'][self::$server]['email'], $config['mailer'][self::$server]['name']);
self::getInstance()->isHTML(true);
self::getInstance()->Subject = $subject;
self::getInstance()->Body = $message;
self::getInstance()->AltBody = $config['mailer'][Session::get('s_locale')]['app']['mailer.altbody'] . '\\r\\n\\n\\n' . $message;
foreach ($to as $address) {
self::getInstance()->AddAddress($address);
}
foreach ($attach as $file) {
self::getInstance()->AddAttachment($file);
}
if (!self::getInstance()->Send()) {
return self::getInstance()->ErrorInfo;
}
return false;
}
public static function dbConnection()
{
$config = autoload_config();
if (!self::$db) {
self::$db = new Database();
}
!self::$connection ? self::$connection = $config['database']['DB_DEFAULT_CONN'] : false;
return self::$db;
}
/**
* Método público para inicializar a classe de sessão.
*
* @method init()
*
* @param none
*
* @return none
*/
public static function getInstance()
{
if (self::$instance == false) {
self::$config = autoload_config();
ini_set('session.cookie_httponly', self::$config['app']['SESSION_COOKIE_HTTPONLY']);
self::$instance = self::generateToken();
@session_name(self::$instance);
@session_cache_expire(self::$config['app']['SESSION_EXPIRE']);
@session_start();
self::set('s_token', self::$instance);
}
return self::$instance;
}
public function __construct()
{
$this->config = autoload_config();
$this->model = new Model();
if ($_GET['lang']) {
$languages = scandir(DOC_ROOT . 'app/Language');
if (in_array($_GET['lang'], $languages)) {
Session::set('s_locale', $_GET['lang']);
} else {
\Service\Debug\Debug::message('não foi possível localizar o idioma ' . $_GET['lang'] . '. Seu idioma não foi alterado.');
}
}
}
public function connect($connection, $database, $host, $port, $username, $password)
{
self::$config = autoload_config();
// rename
$current = $connection;
try {
$this->connection[$current] = new \PDO("mysql:host={$host};dbname={$database};charset=UTF8", $username, $password);
$this->connection[$current]->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
Debug::collectorPDO($this->connection[$current]);
} catch (PDOException $e) {
self::$error[] = $e->getMessage();
Debug::getInstance('exceptions')->addException($e);
}
return $this;
}
public static function init()
{
$config = autoload_config();
self::setBaseUrl(URL . $config['app']['DEBUGBAR_RESOURCES']);
self::setBaseDir(DOC_ROOT . $config['app']['DEBUGBAR_RESOURCES']);
self::$instance = new \DebugBar\StandardDebugBar();
foreach (glob(DOC_ROOT . 'app/Config/*.php') as $file) {
if (file_exists($file)) {
$name = explode('/', $file);
$name = end($name);
$name = str_replace('.php', '', $name);
self::collectorConfig(require $file, 'Config-' . $name);
}
}
self::collectorTimeLine('teste', 'Teste de timeline', null);
}
public static function formSearch($id, $url, $actions = [], $validate = true)
{
// carrega as configurações do frame para pegar o idioma
$language = autoload_config();
$name[0] = $id ? 'search-' . $id : 'search';
$name[1] = $id ? 'form-fields-' . $id : 'form-fields';
$form = "\n <div class='row'>\n <div class='container'>\n <div class='form-horizontal' role='form'>\n\n <div class='row row-header'>\n <div class='col-md-4 left'>";
if (in_array('new', $actions)) {
if ($validate) {
$form .= "\n <a href='{$url}' class='btn btn-success'>\n <span class='glyphicon glyphicon-plus' aria-hidden='true'></span> " . $language[Session::get('s_locale')]['app']['new'] . "\n </a>";
}
}
if (in_array('print', $actions)) {
$form .= "\n\n <a id='imprimir' class='btn btn-primary'>\n <span class='glyphicon glyphicon-print' aria-hidden='true'></span> " . $language[Session::get('s_locale')]['app']['print'] . "\n </a>";
}
$form .= "\n </div>\n\n <div class='clearfix visible-xs visible-sm right mobile-search'>\n <form class='{$name['1']}'>\n <div class='form-group'>\n <div class='input-group right' style='width:300px; margin-right:15px;'>\n <input type='text' class='form-control Enter' id='TX_PESQUISA' name='TX_PESQUISA' placeholder='" . $language[Session::get('s_locale')]['app']['search_'] . "'>\n <div class='input-group-btn'>\n <div class='btn-group' role='group'>\n <button type='button' class='btn btn-primary {$name['0']}'>\n <span class='glyphicon glyphicon-search' aria-hidden='true'></span>\n </button>\n </div>\n </div>\n </div>\n </div>\n </form>\n </div>\n </div>\n </div>\n </div>\n </div>";
echo $form;
}
public function connect($connection, $database, $host, $port, $username, $password)
{
self::$config = autoload_config();
// rename
$current = $connection;
try {
$tns = "(DESCRIPTION =\n (ADDRESS_LIST =\n (ADDRESS = (PROTOCOL = TCP)(HOST = {$host})(PORT = {$port}))\n )\n (CONNECT_DATA =\n (SERVICE_NAME = {$database})\n )\n )";
$this->connection[$current] = new \PDO("oci:dbname={$tns};charset=UTF8", $username, $password);
$this->connection[$current]->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
if ($nls = self::$config['database']['DB_OCI_NLS']) {
foreach ($nls as $key => $value) {
self::$config['database']['DB_OCI_NLS'][$key] ? $this->connection[$current]->exec("ALTER SESSION set {$key}='{$value}'") : false;
}
}
Debug::collectorPDO($this->connection[$current]);
} catch (PDOException $e) {
self::$error[] = $e->getMessage();
Debug::getInstance('exceptions')->addException($e);
}
return $this;
}
function autoload_machines()
{
foreach (autoload_config()['machines'] as $env => $array) {
foreach ($array as $machine) {
if (in_array(gethostname(), autoload_config()['machines'][$env])) {
Session::set('s_environment', $env);
return $env != 'dev' ? true : false;
}
}
}
return false;
}
public static function Rows($options = [], $data, $actions = [], $pkey = [], $config = [])
{
// carrega as configurações do frame para pegar o idioma
$language = autoload_config();
// se houver registros
if ($data) {
// prepara os dados para paginação, se solicitado.
if (self::$paginate) {
$paginator = new Paginator();
$paginator->paginate($data);
}
// mostra uma mensagem de alerta se existir.
if (self::$message) {
self::$table .= "<tr>\n <td colspan='100'>" . self::$message . "</td>\n </tr>";
}
$name[0] = $options['id'] ? 'edit-' . $options['id'] : 'edit';
$name[1] = $options['id'] ? 'del-' . $options['id'] : 'delete';
// prepara o conteudo dos campos para cada linha
foreach ($data as $index => $row) {
// prepara atributos para os elementos tr e td, se solicitado.
if ($config) {
//dd($config);
foreach ($config as $key => $configure) {
$k = explode(':', $key);
//
// switch($k[0]) {
// case 'td':
//
//
//
//
// foreach($configure as $cfg_key => $cfg_val) {
// if($k[1]) {
//
// $attr_td = $cfg_key.'="'.$cfg_val.'" ';
// } else {
// $attr_td = $cfg_key.'="'.$cfg_val.'" ';
// }
// }
// //dd($attr_td);
//
// break;
// }
// switch($key) {
// case 'tr':
// foreach($configure as $tr_key => $tr_value) {
// $attr_tr .= $tr_key.'="'.$tr_value.'" ';
// }
// break;
//
// case 'td':
// //dd($configure);
// foreach($configure as $td_key => $td_value) {
// //dd($td_key);
// if(is_array($td_value)) {
// //dd($td_value);
// }
// else {
// $attr_td .= $td_key.'="'.$td_value.'" ';
// }
//
// }
// break;
// }
}
}
// seta atributo para o elemento tr
self::$table .= "<tr {$attr_tr}>";
// pega o conteudo de cada campo
foreach ($row as $field => $value) {
// verifica se existe campos para serem eliminados
if (self::$ignore) {
// remove os campos ignorados
if (in_array($field, self::$ignore)) {
continue;
}
} else {
if (self::$only) {
// remove todos os campos que nao forem passados
if (!in_array($field, self::$only)) {
continue;
}
}
}
// retorna nome do campo limpo
$fname = explode('_', $field)[1];
if ($v[1]) {
if ($field === $v[1]) {
self::$table .= "<td data-label='{$fname}' {$attr_td}>{$value}</td>";
unset($attr_td);
} else {
self::$table .= "<td data-label='{$fname}'>{$value}</td>";
}
} else {
self::$table .= "<td data-label='{$fname}' {$attr_td} class='{$field}'>{$value}</td>";
}
}
// se houver botoes de acoes
if ($actions) {
// verifica se foi passado as chaves da tabela
if ($pkey) {
// pega todas as chaves passadas
foreach ($pkey as $pk) {
$arr[] = $row[$pk];
}
// cria uma string separando por ífen
$pk = implode('-', $arr);
// limpa o array
unset($arr);
}
// seta o atributo para o elemento td
self::$table .= "<td {$attr_td}>";
$validarAcesso = true;
$link = URL . \Routing\Router::getControllerName();
// verifica quais os botoes serao adicionados
foreach ($actions as $k => $action) {
if (!is_numeric($k)) {
if (is_bool($action)) {
$validarAcesso = $action;
}
$action = $k;
}
switch ($action) {
case 'detail':
if ($validarAcesso) {
self::$table .= "<a href='{$link}/detail/{$pk}' class='btn btn-primary' alt='" . $language[Session::get('s_locale')]['app']['details'] . "' title='" . $language[Session::get('s_locale')]['app']['details'] . "'>\n <span class='glyphicon glyphicon-list' aria-hidden='true'></span>\n " . $language[Session::get('s_locale')]['app']['details'] . "\n </a> ";
}
break;
case 'edit':
if ($validarAcesso) {
self::$table .= "<a href='{$pk}' class='btn btn-warning {$name['0']}' alt='" . $language[Session::get('s_locale')]['app']['edit'] . "' title='" . $language[Session::get('s_locale')]['app']['edit'] . "'>\n <span class='glyphicon glyphicon-edit' aria-hidden='true'></span>\n </a> ";
}
break;
case 'delete':
if ($validarAcesso) {
self::$table .= "<a href='{$pk}' class='btn btn-danger {$name['1']}' alt='" . $language[Session::get('s_locale')]['app']['delete'] . "' title='" . $language[Session::get('s_locale')]['app']['delete'] . "'>\n <span class='glyphicon glyphicon-trash' aria-hidden='true'></span>\n </a> ";
}
break;
case 'print':
if ($validarAcesso) {
self::$table .= "<a href='{$pk}' class='btn btn-default' alt='" . $language[Session::get('s_locale')]['app']['print'] . "' title='" . $language[Session::get('s_locale')]['app']['print'] . "'>\n <span class='glyphicon glyphicon-print' aria-hidden='true'></span>\n </a> ";
}
break;
default:
self::$table .= "<a href='{$pk}' class='btn btn-default' alt='" . $language[Session::get('s_locale')]['app']['btnUnknow'] . "' title='" . $language[Session::get('s_locale')]['app']['btnUnknow'] . "'>\n <span class='glyphicon' aria-hidden='true'>?</span>\n </a> ";
}
}
// fecha a coluna dos botoes
self::$table .= '</td>';
}
// finaliza a linha
self::$table .= '</tr>';
}
if (self::$paginate) {
self::$table .= "<tr class='tfoot'><td colspan='100' class='nohover'>" . $paginator->pages() . "</td></tr>";
}
} else {
self::$table .= "<tr>\n <td colspan='100' align='center' class='nohover' style='padding:30px; font-size:15px'>\n <span class='glyphicon glyphicon-exclamation-sign'></span> " . $language[Session::get('s_locale')]['app']['searchnotfound'] . "\n </td>\n </tr>";
}
}
public static function getInstance()
{
self::$config = autoload_config();
if (!self::$instance) {
try {
$controller = Router::getControllerName();
$loader = new \Twig_Loader_Filesystem([self::$config['app']['TWIG_VIEWS']]);
$loader->addPath(self::$config['app']['TWIG_VIEWS'], 'view');
$loader->addPath(__DIR__ . DS . '../Support/Templates/', 'stemplates');
$loader->addPath(DOC_ROOT . 'app/Support/Templates/', 'templates');
self::$instance = new \Twig_Environment($loader, ['cache' => self::$config['app']['TWIG_CACHE'], 'auto_reload' => self::$config['app']['TWIG_AUTO_RELOAD'], 'autoescape' => self::$config['app']['TWIG_AUTO_ESCAPE'], 'debug' => self::$config['app']['DEBUG']]);
Debug::collectorTwig(self::$instance);
self::$functions[] = new \Twig_SimpleFunction('load_modals', function () {
foreach (glob(DOC_ROOT . 'app/Http/Views/_modals/modal.*.twig') as $modal) {
if (file_exists($modal)) {
require $modal;
}
}
});
self::$functions[] = new \Twig_SimpleFunction('table', function ($id, $fields = [], $actions = []) {
//NOME:TABELA.CAMPO:TIPO_PESQUISA
foreach ($fields as $key) {
$k = explode(':', $key);
$arr[$k[0]] = $k[1] . ':' . $k[2];
}
\Service\HTML\Table::Open();
\Service\HTML\Table::Header([], $id, $arr, $actions);
if ($id != 'tabela') {
$id = 'tabela-' . $id;
}
\Service\HTML\Table::Body(['id' => $id]);
return \Service\HTML\Table::Close();
});
self::$functions[] = new \Twig_SimpleFunction('formSearch', function ($id = null, $url = null, $actions = [], $validate = true) {
return \Service\HTML\Form::formSearch($id, $url, $actions, $validate);
});
self::$functions[] = new \Twig_SimpleFunction('alert', function ($message, $alert = 'info') {
return XHR::alert($message, $alert);
});
self::$functions[] = new \Twig_SimpleFunction('dd', function ($var) {
return dd($var);
});
self::$functions[] = new \Twig_SimpleFunction('validate', function ($array, $key) {
if (in_array($key, $array)) {
return '<span style="color:red">' . self::$config[Session::get('s_locale')]['app']['requiredMsg'] . '</span>';
}
});
self::$functions[] = new \Twig_SimpleFunction('select2_options', function ($array, $var = null) {
$options = "<option value=''></option>";
foreach ($array as $index) {
$selected = $index['ID'] == $var ? ' selected="selected" ' : false;
$options .= "<option value='{$index['ID']}' {$selected}>{$index['TEXT']}</option>";
}
return $options;
});
foreach (self::$functions as $key => $function) {
self::$instance->addFunction($function);
}
foreach (self::$filters as $key => $filter) {
self::$instance->addFilter($filter);
}
$lexer = new \Twig_Lexer(self::$instance, ['tag_block' => self::$config['app']['TWIG_TAG_BLOCK'], 'tag_variable' => self::$config['app']['TWIG_TAG_VARIABLE'], 'tag_comment' => self::$config['app']['TWIG_TAG_COMMENT'], 'interpolation' => self::$config['app']['TWIG_TAG_INTERPOLATION']]);
self::$instance->setLexer($lexer);
/*
* Linguagem da aplicação!
*
* Se existir um script de idioma para o controlador ativado, carregará na memória!
*/
// global
self::$instance->addGlobal('langApp', self::$config[Session::get('s_locale')]['app']);
// do programa
self::$instance->addGlobal('lang', self::$config[Session::get('s_locale')][$controller]);
/*
* Variáveis Globais
*
* São essenciais para o funcionamento basico da aplicação.
*/
self::$instance->addGlobal('hostname', gethostname());
self::$instance->addGlobal('URL', URL);
self::$instance->addGlobal('bower_dir', URL . self::$config['app']['BOWER_COMPONENTS']);
self::$instance->addGlobal('app_name', self::$config['app']['APP_NAME']);
self::$instance->addGlobal('app_title', self::$config['app']['APP_TITLE']);
self::$instance->addGlobal('app_version', self::$config['app']['APP_VERSION']);
self::$instance->addGlobal('theme', self::$config['app']['DEFAULT_THEME']);
self::$instance->addGlobal('page_lang', self::$config['app']['TWIG_PAGE_LANG']);
self::$instance->addGlobal('page_charset', self::$config['app']['TWIG_PAGE_CHARSET']);
self::$instance->addGlobal('debug', autoload_machines() ? false : self::$config['app']['DEBUG']);
self::$instance->addGlobal('configure', self::$config);
$app_js = DOC_ROOT . 'public/app/js/' . $controller . '.js';
if (file_exists($app_js)) {
self::$instance->addGlobal('app_js', "<script type='text/javascript' src='" . URL . 'app/js/' . $controller . ".js'></script>");
}
$app_css = DOC_ROOT . 'public/app/css/' . $controller . '.css';
if (file_exists($app_css)) {
self::$instance->addGlobal('app_css', "<link rel='stylesheet' href='" . URL . 'app/css/' . $controller . ".css' type='text/css'/>");
}
switch (Session::get('s_environment')) {
case 'dev':
$env = self::$config[Session::get('s_locale')]['app']['development'];
break;
case 'hom':
$env = self::$config[Session::get('s_locale')]['app']['statement'];
break;
case 'pro':
$env = self::$config[Session::get('s_locale')]['app']['production'];
break;
}
self::$instance->addGlobal('environment_current', $env);
self::$instance->addGlobal('server', $_SERVER);
self::$instance->addGlobal('session', $_SESSION);
self::$instance->addGlobal('post', $_POST);
self::$instance->addGlobal('get', $_GET);
self::$instance->addGlobal('request', $_REQUEST);
self::$instance->addGlobal('flash', Session::get('flash') ? Session::flash() : false);
self::$instance->addGlobal('token', Session::get('s_token'));
self::$instance->addGlobal('controller', $controller);
self::$instance->addGlobal('method', Router::getMethod());
self::$instance->addGlobal('debugbar_header', Debug::render()->renderHead());
self::$instance->addGlobal('debugbar_body', Debug::render()->render());
} catch (Exception $e) {
echo $e->getMessage();
}
}
return self::$instance;
}
public function __construct()
{
self::$config = autoload_config();
return $this;
}
