private static function runQueryWithView($query, $fields, $printArray)
{
$_SESSION['tableData'] = array();
$exec_time_row = array();
$records = '';
try {
// turn on query profiling
Flight::get('db')->query('SET profiling = 1;');
$stmt = Flight::get('db')->query($query);
// find out time above query was ran for
$exec_time_result = Flight::get('db')->query('SELECT query_id, SUM(duration) FROM information_schema.profiling GROUP BY query_id ORDER BY query_id DESC LIMIT 1;');
$exec_time_row = $exec_time_result->fetchAll(PDO::FETCH_NUM);
// run query and fetch array
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
// store table fields/columns + data rows in session for exporting later
$_SESSION['tableData'] = array_merge($fields, $data);
$records = Presenter::listTableData($data);
} catch (PDOException $e) {
setFlashMessage('Error: ' . $e->getMessage());
}
Flight::render('table', array('title' => Flight::get('lastSegment'), 'icon' => self::$icon, 'table_data' => $records, 'fields' => getOptions($fields), 'query' => SqlFormatter::format($query), 'printArray' => $printArray, 'timetaken' => $exec_time_row[0][1]));
}
/**
* Login page
*/
public function index()
{
if (isset($_SESSION['admin'])) {
F::redirect('/');
}
F::render('Admin/login.html');
}
public static function recommended()
{
$dbname = 'predictionio_appdata';
$mdb = Flight::mdb();
$db = $mdb->{$dbname};
$items = $db->items;
$client = Flight::prediction_client();
$recommended_movies = array();
try {
$user_id = $_SESSION['user_id'];
$client = new EngineClient('http://localhost:8000');
$recommended_movies_raw = $client->sendQuery(array('user' => $user_id, 'num' => 9));
$movie_iids = array_map(function ($item) {
return $item['item'];
}, $recommended_movies_raw['itemScores']);
$cursor = $items->find(array('itypes' => '1', '_id' => array('$in' => $movie_iids)));
$recommended_movies = array_values(iterator_to_array($cursor));
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
$_SESSION['movies_viewed'] = 0;
$_SESSION['user_id'] = '';
Flight::render('recommended', array('recommended_movies' => $recommended_movies), 'content');
Flight::render('layout', array('title' => 'Recommended', 'base_path' => '/movie_recommender'));
}
/**
* render_frame
* 渲染
*
* @var string
*/
public static function render_frame($title = '')
{
$sidebar = self::get_conf_data();
Flight::render('header', array('title' => $title), 'header_content');
Flight::render('navbar', array(), 'navbar_content');
Flight::render('sidebar', array('sidebar' => $sidebar), 'sidebar_content');
}
public static function recommended()
{
$dbname = 'predictionio_appdata';
$mdb = Flight::mdb();
$db = $mdb->{$dbname};
$items = $db->items;
$client = Flight::prediction_client();
$recommended_movies = array();
try {
$user_id = $_SESSION['user_id'];
$client->identify($user_id);
$command = $client->getCommand('itemrec_get_top_n', array('pio_engine' => 'movie-recommender', 'pio_n' => 9));
$recommended_movies_raw = $client->execute($command);
$movie_iids = $recommended_movies_raw['pio_iids'];
array_walk($movie_iids, function (&$movie_iid) {
$movie_iid = '4_' . $movie_iid;
});
$cursor = $items->find(array('itypes' => '1', '_id' => array('$in' => $movie_iids)));
$recommended_movies = array_values(iterator_to_array($cursor));
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
$_SESSION['movies_viewed'] = 0;
$_SESSION['user_id'] = '';
Flight::render('recommended', array('recommended_movies' => $recommended_movies), 'content');
Flight::render('layout', array('title' => 'Recommended', 'base_path' => '/movie_recommender'));
}
public static function _manage_platoon($div, $plt)
{
$division = Division::findByName(strtolower($div));
$platoonId = Platoon::getIdFromNumber($plt, $division->id);
if (!is_null($platoonId)) {
$user = User::find(intval($_SESSION['userid']));
$member = Member::find(intval($_SESSION['memberid']));
if ($member->platoon_id == $platoonId || $user->role > 2 || User::isDev()) {
$tools = Tool::find_all($user->role);
$divisions = Division::find_all();
$platoon = Platoon::findById($platoonId);
$unassignedMembers = Platoon::unassignedMembers($platoonId, true);
$squads = Squad::findByPlatoonId($platoonId);
$memberCount = count((array) Platoon::members($platoonId));
$js = 'manage';
Flight::render('manage/platoon', compact('division', 'platoon', 'squads', 'unassignedMembers', 'memberCount'), 'content');
Flight::render('layouts/application', compact('js', 'user', 'member', 'tools', 'divisions'));
} else {
// insufficient access
Flight::redirect('404/', 404);
}
} else {
// nonexistent platoon
Flight::redirect('404/', 404);
}
}
function renderTemplate($templateName, $selectedTab, $subTitle = '', $pageType = '')
{
Flight::render('partials/head', array('title' => $subTitle ? " - {$subTitle}" : ''), 'headContent');
Flight::render('partials/contactDetails', array(), 'contactDetails');
Flight::render('partials/socialList', array(), 'socialList');
Flight::render('partials/navigation', array('selectedTab' => $selectedTab), 'navigation');
Flight::render('partials/footer', array(), 'footer');
Flight::render($templateName, array('title' => $subTitle !== '' ? " - {$subTitle}" : '', 'subTitle' => $subTitle, 'pageType' => $pageType));
}
public static function majesteel()
{
$symfony = new Symfony();
$symfony->initRequirements();
$symfony->initOptionalRequirements();
$majesteel = new MajesTeel();
$majesteel->initRequirements();
$majesteel->initOptionalRequirements();
Flight::render('templates/majesteel.tpl', array('symfony' => $symfony, 'majesteel' => $majesteel));
}
public static function _doDivisionThreadCheck()
{
if (!empty($_POST['player'])) {
$player = trim($_POST['player']);
$member = Member::find(intval($_SESSION['memberid']));
$gameThreads = DivisionThread::find_all($member->game_id);
$js = 'check_threads';
Flight::render('recruiting/thread_check', compact('js', 'gameThreads', 'player'));
} else {
echo "<span class='text-muted'>A valid player was not provided!</span>";
}
}
public static function _authenticate()
{
if (User::isLoggedIn()) {
$user = User::find(intval($_SESSION['userid']));
$member = Member::find(intval($_SESSION['memberid']));
$tools = Tool::find_all($user->role);
$divisions = Division::find_all();
Flight::render('layouts/auth', [], 'content');
Flight::render('layouts/application', compact('user', 'member', 'tools', 'divisions'));
} else {
Flight::render('layouts/auth', [], 'content');
Flight::render('layouts/application', compact('user', 'member', 'tools', 'divisions'));
}
}
public static function _retentionNumbers()
{
$user = User::find(intval($_SESSION['userid']));
if ($user->role >= 3 || User::isDev()) {
$member = Member::find(intval($_SESSION['memberid']));
$tools = Tool::find_all($user->role);
$divisions = Division::find_all();
$recruited = Report::recruitedLast30days($member->game_id);
$removed = Report::removedLast30days($member->game_id);
$monthlyBreakdown = Report::recruitingWeekly($member->game_id);
$byTheMonth = Report::recruitingByTheMonth($member->game_id);
$js = 'report';
Flight::render('reports/retention', compact('recruited', 'removed', 'js', 'monthlyBreakdown', 'byTheMonth'), 'content');
Flight::render('layouts/application', array('user' => $user, 'member' => $member, 'tools' => $tools, 'divisions' => $divisions));
} else {
Flight::redirect('/404', 404);
}
}
public static function _edit()
{
$user = User::find(intval($_SESSION['userid']));
$member = Member::findByMemberId($_POST['member_id']);
$platoons = Platoon::find_all($member->game_id);
// if user role lower than plt ld, show only own platoon's squads
$platoon_id = $user->role >= 2 && !User::isDev() ? $member->platoon_id : false;
$squads = Squad::findAll($member->game_id, $platoon_id);
$positionsArray = Position::find_all();
$rolesArray = Role::find_all();
$memberGames = MemberGame::get($member->id);
if (User::isUser($member->id)) {
$userInfo = User::findByMemberId($member->id);
} else {
$userInfo = null;
}
Flight::render('modals/view_member', array('user' => $user, 'member' => $member, 'userInfo' => $userInfo, 'platoons' => $platoons, 'memberGames' => $memberGames, 'squads' => $squads, 'positionsArray' => $positionsArray, 'rolesArray' => $rolesArray));
}
/**
* Reading / Editing page
*/
public function page($params)
{
$mode = $params[0];
$pageinfos = F::get('pageinfos');
if (empty($pageinfos['cat'])) {
$pageTitle = F::get('config')['document'];
$url_view = '{$root}';
$url_edit = '{$root}.edit';
$path = 'docs/.home';
} else {
$pageTitle = Files::getPageTitle($pageinfos['cat'], $pageinfos['page']);
$url_view = '{$root}' . $pageinfos['cat'] . '/' . $pageinfos['page'];
$url_edit = '{$root}' . $pageinfos['cat'] . '/' . $pageinfos['page'] . '.edit';
$path = 'docs/' . $pageinfos['cat'] . '/' . $pageinfos['page'];
}
if (file_exists($path) && is_file($path) && is_readable($path)) {
$pageContent = file_get_contents($path);
# Edit mode
if ($mode == 'edit' && F::has('admin')) {
# Content submited
if (F::request()->method == 'POST') {
$pageContent = F::request()->data->pageContent;
file_put_contents($path, $pageContent);
$_SESSION['flashbag'] = '
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
The page has been saved
</div>';
F::redirect('/' . $pageinfos['cat'] . '/' . $pageinfos['page']);
} else {
$pageContent = file_get_contents($path);
F::render('Doc/page-edit.html', array('page_edit_url' => $url_edit, 'page_view_url' => $url_view, 'page_title' => $pageTitle, 'page_content' => $pageContent, 'edition_mode' => true));
}
} else {
F::render('Doc/page-view.html', array('page_edit_url' => $url_edit, 'page_title' => $pageTitle, 'page_content' => $pageContent, 'page_last_modif' => date('Y-m-d H:i:s', filemtime($path))));
}
} else {
F::render('Core/404.html');
}
}
public static function msg($msg)
{
Flight::render("common/handle", array("msg" => $msg));
die;
}
});
Flight::route('/projects', function () {
Flight::render('projects' . PREFIX, array('active' => 'projects', 'lang' => 'en'));
});
Flight::route('/works', function () {
Flight::render('projects' . PREFIX, array('active' => 'projects', 'lang' => 'en'));
});
Flight::route('/attorneys', function () {
Flight::render('home' . PREFIX, array('active' => 'team', 'lang' => 'en'));
});
Flight::route('/nuestrosabogados', function () {
Flight::render('home' . PREFIX, array('active' => 'team', 'lang' => 'es'));
});
Flight::route('/equipo', function () {
Flight::render('home' . PREFIX, array('active' => 'team', 'lang' => 'es'));
});
Flight::route('/team', function () {
Flight::render('home' . PREFIX, array('active' => 'team', 'lang' => 'es'));
});
Flight::route('/contacto', function () {
Flight::render('contact' . PREFIX . '.es', array('active' => 'contact', 'lang' => 'es'));
});
Flight::route('/contact', function () {
Flight::render('contact' . PREFIX . '.en', array('active' => 'contact', 'lang' => 'en'));
});
Flight::route('/admin', function () {
Flight::render('admin', array('active' => '', 'lang' => 'en'));
});
//Config
//Flight::set('flight.views.path', '/path/to/views');
Flight::start();
<?php
session_start();
$condicion = "idTipoServicioPadre>0 and servicio!='Otro'";
$servicio = seleccionarTodo("idTipoServicio,servicio,duracionEstimada", "cTipoServicio", $condicion);
$data = array('servicio' => $servicio);
Flight::render('administracion/duracion_servicios', $data);
<?php
Flight::route('/', function () {
Flight::render('index.php');
});
Flight::route('/shorten', function () {
$url = urldecode(Flight::request()->query['url']);
if ($url) {
$sha1 = sha1($url);
$store = Flight::get('db')->select('urls', ['id'], ['sha1' => $sha1]);
if (!$store) {
$id = Flight::get('db')->insert('urls', ['sha1' => $sha1, 'url' => $url, 'create_at' => time()]);
} else {
$id = $store[0]['id'];
}
$s_url = Flight::get('flight.base_url') . Flight::get('hash')->encode($id);
Flight::json(['status' => 1, 's_url' => $s_url]);
}
});
Flight::route('/expand', function () {
$s_url = Flight::request()->query['s_url'];
if ($s_url) {
$hash = str_replace(Flight::get('flight.base_url'), '', $s_url);
if (!preg_match('/^[' . Flight::get('alphabet') . ']+$/', $hash)) {
Flight::json(['status' => 0, 'msg' => '短址不正确']);
} else {
$id = Flight::get('hash')->decode($hash);
if (!$id) {
Flight::json(['status' => 0, 'msg' => '短址无法解析']);
} else {
$store = Flight::get('db')->select('urls', ['url'], ['id' => $id]);
<?php
session_start();
$empleado = isset($_SESSION['idEmpleado']) ? seleccionar('*', 'empleado', "idEmpleado=" . $_SESSION['idEmpleado']) : "";
$responsable = isset($_SESSION['idUAutoriza']) ? seleccionar('*', 'empleado', "idEmpleado=" . $_SESSION['idUAutoriza']) : "";
$area = isset($_SESSION['idUAutoriza']) ? seleccionar('area', 'cArea,puesto,empleado', 'cArea.idArea = puesto.idArea and puesto.estatus = 1 and puesto.idEmpleado=empleado.idEmpleado and empleado.idEmpleado = ' . $_SESSION['idUAutoriza']) : "";
$nomUsuario = seleccionarTodoSM('concat(gradoAcad," ",nombre," ",apellidoP," ",apellidoM) as nombreUsuario,idEmpleado as idNomUsuario', "empleado", "estatus=1 order by apellidoP asc");
$nomResponsable = $responsable['gradoAcad'] . " " . $responsable['nombre'] . " " . $responsable['apellidoP'] . " " . $responsable['apellidoM'];
$data = array('area' => $area, 'empleado' => $empleado, 'nomResponsable' => $nomResponsable, 'nomUsuario' => $nomUsuario);
Flight::render('servicios/sus', $data);
require_once 'controllers/reportes/mtosRealizadosPDF_controller.php';
});
Flight::route('/reportes/servicios-electricos/', function () {
Flight::render('reportes/servicios_electricos');
});
Flight::route('/reportes/servicios-electricos-pdf/', function () {
require_once 'controllers/reportes/serviciosElectricosPDF_controller.php';
});
Flight::route('/reportes/servicios-con-duraciones/', function () {
Flight::render('reportes/servicios_duracion');
});
Flight::route('/reportes/servicios-con-duraciones-pdf/', function () {
require_once 'controllers/reportes/serviciosDuracionPDF_controller.php';
});
Flight::route('/reportes/estadisticas-de-cancelacion/', function () {
Flight::render('reportes/estadisticas_cancelacion');
});
Flight::route('/reportes/estadisticas-de-cancelacion-pdf/', function () {
require_once 'controllers/reportes/estadisticasCancelacionPDF_controller.php';
});
/*Administración*/
Flight::route('/administracion/lista-de-usuarios/', function () {
require_once 'controllers/administracion/lista_usuarios_controller.php';
});
Flight::route('/listado-empleados/', function () {
require_once 'controllers/lista_empleados_controller.php';
});
Flight::route('/listado-firmas/', function () {
require_once 'controllers/lista_firmas_controller.php';
});
Flight::route('/administracion/editar-empleado/', function () {
public static function _createIssue()
{
Flight::render('modals/create_issue', array('js' => 'issue'));
}
<?php
require 'flight/Flight.php';
require 'extensions/Bcrypt.php';
// Register Bcrypt class to use later on
Flight::register('bcrypt', 'Bcrypt');
Flight::route('GET /', function () {
Flight::render('index.php', array('hashResult' => 'Waiting...'));
});
Flight::route('POST /', function () {
$bcrypt = Flight::bcrypt();
$hashResult = '';
$hashMatches = '';
$hashCheck = false;
switch ($_POST['method']) {
case 'hash':
$hashResult = $bcrypt->hash($_POST['stringToHash']);
break;
case 'check':
$hashMatches = $bcrypt->check($_POST['plainText'], $_POST['hashText']);
$hashCheck = true;
break;
}
Flight::render('index.php', array('hashResult' => $hashResult, 'hashMatches' => $hashMatches, 'hashCheck' => $hashCheck));
});
Flight::start();
public static function index()
{
Flight::jsrender('/public/js/admin/service.js');
Flight::render('service/index');
}
$request = Flight::request();
$track = json_decode(getTrack($id));
if (!isset($track->error)) {
Flight::render('editTRack', array('track' => $track), 'body_content');
Flight::render('layout', array('Titre' => 'Modifier le track ' . $track[0]->title));
} else {
Flight::redirect($request->referrer);
}
});
Flight::route('GET|POST /album/@id/edit', function ($id) {
$request = Flight::request();
if ($request->method == "GET") {
$album = json_decode(getAlbum($id));
if (!isset($album->error)) {
Flight::render('editAlbum', array('album' => $album), 'body_content');
Flight::render('layout', array('Titre' => 'Modifier un track à ' . $album[0]->title));
} else {
Flight::redirect($request->referrer);
}
} else {
if ($request->method == "POST") {
$album = json_encode($_POST);
$result = json_decode(editAlbum($album));
if (isset($result->ID)) {
Flight::redirect($request->referrer);
} else {
Flight::redirect('http://localhost/php/App/playlists');
}
}
}
});
protected static function set_view($view, $parameters)
{
Flight::render($view, $parameters, 'content');
Flight::render('base/template');
}
$nav = file_get_contents('./content/nav.md', FILE_USE_INCLUDE_PATH);
if ($nav === FALSE) {
$nav = 'Navigation file missing';
}
Flight::set('nav_contents', Markdown($nav));
//Site Title
Flight::set('site_title', 'Markdown Directory');
//ROUTES
Flight::route('/', function () {
$listing_content = file_get_contents("./content/home.md", FILE_USE_INCLUDE_PATH);
Flight::display('Welcome to Markdown Directory', $listing_content);
});
Flight::route('/@listing', function ($listing) {
$listing_content = file_get_contents("./content/listings/{$listing}.md", FILE_USE_INCLUDE_PATH);
$title = ucwords(str_replace("_", " ", $listing));
Flight::display($title, $listing_content);
});
//Render
Flight::map('display', function ($title, $list_content) {
$siteTitle = Flight::get('site_title');
$title = $title . ' - ' . $siteTitle;
if ($list_content === FALSE) {
$list_content = '<p>Listing cannot be found</p>';
} else {
$list_content = Markdown($list_content);
}
Flight::render('header', array('title' => $title), 'header_content');
Flight::render('footer', array(), 'footer_content');
Flight::render('layout', array('nav' => Flight::get('nav_contents'), 'listing' => $list_content, 'site_title' => $siteTitle));
});
Flight::start();
/**
* Renders an example view
*/
public static function welcome()
{
\Flight::render('welcomeView', array('name' => 'TBZSN'), 'body_content');
\Flight::render('layout');
}
<?php
/**
* Renders $page using the 'default' layout.
*/
Flight::map('render_page', function ($page, $data = null, $key = null) {
Flight::render('layouts/header', $data, 'header');
Flight::render($page, $data, 'body');
Flight::render('layouts/footer', $data, 'footer');
Flight::render('layouts/default', $data);
});
/**
* Creates the HTML for displaying a project's meta information (title/date).
* @param $project array An array containing a project's information
* @return string An HTML string
*/
function render_project_meta($project)
{
$p = '<h3 class="title">';
!$project['link'] ?: ($p .= '<a href="' . $project['link'] . '">');
$p .= $project['title'];
!$project['link'] ?: ($p .= '</a>');
$p .= '</h3><span class="date">';
$p .= date('F Y', strtotime($project['date']));
$p .= '</span>';
return $p;
}
/**
* Creates the HTML for displaying a project's tags.
* @param $project array An array containing a project's information
* @return string An HTML string
<?php
require_once 'vendor/autoload.php';
// Config views
Flight::set(array('flight.views.path' => './app', 'flight.views.extension' => '.html'));
class Api
{
public static function related($id)
{
$headers = array("Accept" => "application/json");
$url = "https://api.spotify.com/v1/artists/{$id}/related-artists";
$related_artists = Unirest\Request::get($url, $headers)->body->artists;
Flight::json($related_artists);
}
public static function toptrack($artist_id)
{
$headers = array("Accept" => "application/json");
$url = "https://api.spotify.com/v1/artists/{$artist_id}/top-tracks?country=US";
$artist_top_track = Unirest\Request::get($url, $headers)->body;
Flight::json($artist_top_track);
}
}
Flight::route('GET /', function () {
Flight::render('index');
});
Flight::route('GET /api/related/@id', array('Api', 'related'));
Flight::route('GET /api/toptrack/@artist_id', array('Api', 'toptrack'));
Flight::start();
<?php
session_start();
$contenido = 'documentos/folio_salida';
$header['js'][] = 'folio_salida';
$data = array('header' => $header, 'contenido' => $contenido);
Flight::render('template/layout', $data);
/**
* Create a short code to load a real time list of items from ArtMoi
* @param $args
* @return mixed
*/
public function getFeaturedCollection($args)
{
// Detect devices
$isMobile = false;
if (wp_is_mobile()) {
$isMobile = true;
}
wp_reset_postdata();
wp_enqueue_script('items', plugins_url('ArtMoiWP/scripts/collection.js'));
$this->artmoiwp_creationpage = get_option('artmoiwp_creationpage');
global $post;
$postId = $post->ID;
// the post ID in edit , not published
$artmoi = Flight::artmoi();
$controller = 'collection';
$action = $args['collection'];
$response = $artmoi->call($controller, $action);
$templateType = get_post_meta($postId, 'templateType', true);
if (!$templateType) {
$templateType = 'collection';
update_post_meta($postId, 'templateType', "collection");
}
$items = $response->itemResults();
Flight::render('frontend/modal', array('items' => $items, 'creationPostId' => $this->artmoiwp_creationpage, 'isMobile' => $isMobile), 'modal');
$output = Flight::view()->fetch('frontend/template/' . $templateType, array('items' => $items));
return $output;
}
