<?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();