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 function setConnections() { foreach (self::$config['database']['connections'] as $environment => $connections) { // força o ambiente padrão de uma determinada maquina. autoload_machines(); $DB_DEFAULT_ENV = Session::get('s_environment') ? Session::get('s_environment') : self::$config['database']['DB_DEFAULT_ENV']; if ($DB_DEFAULT_ENV === $environment) { foreach ($connections as $instance) { if ($instance['autoload']) { if (self::$config['database']['DB_AUTH'] && self::$config['database']['DB_DEFAULT_CONN'] === $instance['connection']) { $username = Session::get('s_username') ? Session::get('s_username') : false; $password = Session::get('s_password') ? base64_decode(Session::get('s_password')) : false; } else { $username = $instance['username']; $password = $instance['password']; } switch ($instance['driver']) { case 'oci': $this->connections[$instance['connection']] = new \Database\Driver\Oci($instance['connection'], $instance['database'], $instance['host'], $instance['port'], $username, $password); break; case 'mysql': $this->connections[$instance['connection']] = new \Database\Driver\Mysql($instance['connection'], $instance['database'], $instance['host'], $instance['port'], $username, $password); break; } } } } } return $this; }
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; }
function translate($l = 'app', $k = null, $a = []) { foreach (glob(DOC_ROOT . 'app/Language/*/*') as $file) { $keys = explode('/', $file); $lang = $keys[sizeof($keys) - 2]; $key = $keys[sizeof($keys) - 1]; $key = strtolower(str_replace('.php', '', $key)); $array[$lang][$key] = (require $file); } $key = $array[\Service\Session::get('s_locale')][$l][$k]; if ($a) { foreach ($a as $index => $value) { $key = str_replace('{' . $index . '}', $value, $key); } } return $key; }
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 static function dispatch() { // Se tiver filtros, carrega todos aqui. autoload_filters(); // Se tiver, rotas carrega todos aqui. autoload_routes(); // Verifica e prepara a URL self::uri_prepare(); self::$method = $_SERVER['REQUEST_METHOD']; $searches = array_keys(static::$patterns); $replaces = array_values(static::$patterns); self::$routes = str_replace('//', '', self::$routes); $found_route = false; $query = ''; $q_arr = array(); if (strpos(self::$uri, '&') > 0) { $query = substr(self::$uri, strpos(self::$uri, '&') + 1); self::$uri = substr(self::$uri, 0, strpos(self::$uri, '&')); $q_arr = explode('&', $query); foreach ($q_arr as $q) { $qobj = explode('=', $q); $q_arr[] = array($qobj[0] => $qobj[1]); if (!isset($_GET[$qobj[0]])) { $_GET[$qobj[0]] = $qobj[1]; } } } if (in_array(self::$uri, self::$routes)) { $route_pos = array_keys(self::$routes, self::$uri); foreach ($route_pos as $route) { if (self::$methods[$route] == self::$method || self::$methods[$route] == 'ANY') { $found_route = true; if (!is_object(self::$callbacks[$route])) { self::invokeObject(self::$callbacks[$route]); if (self::$halts) { return; } } else { call_user_func(self::$callbacks[$route]); if (self::$halts) { return; } } } } } else { $pos = 0; foreach (self::$routes as $route) { $route = str_replace('//', '', $route); if (strpos($route, ':') !== false) { $route = str_replace($searches, $replaces, $route); } if (preg_match('#^' . $route . '$#', self::$uri, $matched)) { if (self::$methods[$pos] == self::$method || self::$methods[$pos] == 'ANY') { $found_route = true; array_shift($matched); if (!is_object(self::$callbacks[$pos])) { self::invokeObject(self::$callbacks[$pos], $matched); if (self::$halts) { return; } } else { call_user_func_array(self::$callbacks[$pos], $matched); if (self::$halts) { return; } } } } ++$pos; } } if (self::$fallback) { $found_route = self::autoDispatch(); } if (!$found_route) { if (!self::$errorCallback) { self::$errorCallback = function () { $method = explodeCamelCase(self::$method); if ($method[0] != 'xhr') { if (Session::get('s_loggedIn')) { header("{$_SERVER['SERVER_PROTOCOL']} 404 Not Found"); Response::error('404'); } else { Redirect::to("/"); } } }; } if (!is_object(self::$errorCallback)) { self::invokeObject(self::$errorCallback, null, 'No routes found.'); if (self::$halts) { return; } } else { call_user_func(self::$errorCallback); if (self::$halts) { return; } } } // verifica os filtros if (self::$filter) { foreach (self::$filters as $action => $name) { foreach ($name as $callback) { if (self::AFTER === $action) { $callback(); } } } } }
private function decodeTemplate($file) { $file = str_replace('{%arrayPkTable%}', $this->arrayPkTable(), $file); // controller $file = str_replace('{%Controller%}', ucwords(strtolower($this->program_name)), $file); $file = str_replace('{%controller_name%}', strtolower($this->program_name), $file); $file = str_replace('{%tablePk%}', $this->tablePk, $file); $file = str_replace('{%tablePk_var%}', $this->tablePk_var, $file); $file = str_replace('{%TABLE_NAME%}', strtoupper($this->table[0]), $file); $file = str_replace('{%ColumnsDB%}', $this->ColumnsDB, $file); // model $this->query = str_replace(',', ",\n", $this->query); $this->query = str_replace("\n\n\n\n", "\n", $this->query); $file = str_replace('{%QueryPesquisar%}', $this->query, $file); $file = str_replace('{%QueryCamposPesquisa%}', $this->search, $file); $file = str_replace('{%QueryBuscar%}', $this->queryBuscar, $file); // index.tpl $file = str_replace('{%tableHeader%}', $this->tableHeader, $file); // novo.tpl $file = str_replace('{%HTMLNew%}', $this->HTMLNew, $file); $file = str_replace('{%HTMLNewFields%}', $this->HTMLNewFields, $file); $file = str_replace('{%HTMLNew-valid%}', 'validar', $file); // editar.tpl $file = str_replace('{%HTMLEdit%}', $this->HTMLEdit, $file); $file = str_replace('{%HTMLEditFields%}', $this->HTMLEditFields, $file); $file = str_replace('{%HTMLEditFieldsID%}', $this->HTMLEditFieldsID, $file); $file = str_replace('{%HTMLEdit-valid%}', 'validar', $file); // detail.tpl $file = str_replace('{%HTMLDetail%}', $this->HTMLDetail, $file); $file = str_replace('{%HTMLDetailBtn%}', $this->HTMLDetailBtn, $file); //pdf $file = str_replace('{%HeaderClean%}', $this->HeaderClean, $file); $file = str_replace('{%FieldsPDF%}', $this->FieldsPDF, $file); //comentario $file = str_replace('{%GC_VERSION%}', '1.0', $file); $file = str_replace('{%GC_DATE%}', date('d/m/Y G:i:s'), $file); $file = str_replace('{%GC_DEVELOPER%}', Session::get('TX_LOGIN'), $file); $file = str_replace('{%GC_MACHINE%}', gethostname(), $file); return $file; }