Beispiel #1
0
<?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">&nbsp;
		</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;
    }
}