<?php
require_once 'init.php';
require_once LIB_PATH . 'functions.lib.php';
require_once LIB_PATH . 'paging.lib.php';
chkLicense();
chkSession();
$page_title = "Report";
$page_id = "12";
chkSecurity($page_id);
$ev_q = "SELECT e.id,\n\t\t\t\tCONCAT(u.fname,' ',u.lname) AS fullname,\n\t\t e.name AS evname,\n\t\t \t\te.ticker,\n\t\t\t\te.sdate,\n\t\t\t\te.edate,\n\t\t\t\te.createBy,\n\t\t\t\te.createDate,\n\t\t\t\te.qty_locket\n\t\t FROM events e\n\t\t INNER JOIN user u ON (u.id = e.createBy)\n\t WHERE e.createBy = '" . $_SESSION["uid"] . "' AND e.del = '0'\n\t\t ORDER BY e.sdate DESC ";
$pagingResult = new Pagination();
$pagingResult->setPageQuery($ev_q);
$pagingResult->paginate();
$this_page = $_SERVER['PHP_SELF'] . "?" . $pagingResult->getPageQString();
include THEME_DEFAULT . 'header.php';
?>
<//-----------------CONTENT-START-------------------------------------------------//>
<h1 class="page-header"><?php
echo $page_title;
?>
Page</h1>
<div class="sub-header">
<div class="panel panel-default">
<div class="panel-heading">
</div>
<div class="panel-body">
<?php
echo $pagingResult->pagingMenu();
function userData($db, $id, $ip, $mandant, $login, $pwd)
{
$rs = chkSession($db, $id, $ip);
if ($GLOBAS['log']) {
$GLOBALS['log']->write("chlS:{$id},{$ip},{$mandant},{$login},{$pwd}," . $rs);
}
if (!$rs) {
delSession($db, $id, $ip);
$sess = authuser($db, $mandant, $login, $pwd, $ip);
if ($GLOBAS['log']) {
$GLOBALS['log']->write("chlS2:{$sess}");
}
if (!$sess) {
return false;
}
} else {
$sess['sess'] = $id;
}
$sql = "SELECT * FROM auth.clients WHERE name = '{$mandant}'";
$rs = $db->getOne($sql);
if ($GLOBAS['log']) {
$GLOBALS['log']->write("chlS3:{$sql}");
}
if ($GLOBAS['log']) {
$GLOBALS['log']->write("chlS3:" . print_r($rs, true));
}
if ($rs) {
$sess["db"] = new myDB($rs);
if ($GLOBALS['log']) {
$sess['db']->log = true;
} else {
$sess['db']->log = false;
}
return $sess;
} else {
return false;
}
}