mods/ldap/admin/ldap_auth_log.php

   1 <?php\r
   2 /*\r
   3 Admin LDAP statistics page\r
   4 \r
   5 Maintainer smal (Serhiy Voyt)\r
   6 smalgroup@gmail.com\r
   7 \r
   8 Version 0.2\r
   9 10.11.2008\r
  10 \r
  11 Distributed under GPL (c)Sehiy Voyt 2005-2009\r
  12 */\r
  13 define('AT_INCLUDE_PATH', '../include/');\r
  14 require (AT_INCLUDE_PATH.'vitals.inc.php');\r
  15 if ($_SERVER['REQUEST_METHOD'] == 'POST'){\r
  16     /* Get POST variables from jqGrid request */\r
  17     $page  = intval($_POST['page']);\r
  18     $limit = intval($_POST['rows']);\r
  19     $sidx  = addslashes($_POST['sidx']);\r
  20     $sord  = addslashes($_POST['sord']);\r
  21     if(!$sidx) $sidx = 1;\r
  22     if ($sord == 'desc'){\r
  23         $sord = 'DESC';\r
  24     }else{\r
  25         $sord = 'ASC';\r
  26     }\r
  27     $sql = "SELECT COUNT(*) as count FROM ".TABLE_PREFIX."ldap_log";\r
  28     $result = mysql_query($sql, $db);\r
  29     $row = mysql_fetch_assoc($result);\r
  30     $count = $row['count'];\r
  31     if ($count > 0 ) {\r
  32         $total_pages = ceil($count/$limit);\r
  33     } else {\r
  34         $total_pages = 0;\r
  35     }\r
  36     if ($page > $total_pages) $page = $total_pages;\r
  37     $start = $limit*$page - $limit;\r
  38     if ($start < 0) $start = 0;\r
  39     $sql = "SELECT L.member_id, M.login, CONCAT(M.last_name, ' ', M.first_name, ' ', M.second_name) AS full_name, \r
  40     M.email, L.create_date, L.ldap_source FROM AT_ldap_log L LEFT JOIN AT_members M USING (member_id) ORDER BY ".$sidx." ".$sord. " \r
  41     LIMIT ".$start." , ".$limit;\r
  42     $result = mysql_query($sql, $db);\r
  43     // Construct the json data\r
  44     $response->page = $page; // current page\r
  45     $response->total = $total_pages; // total pages\r
  46     $response->records = $count; // total records\r
  47     $i=0;\r
  48     while($row = mysql_fetch_array($result)) {\r
  49         $response->rows[$i]['id']=$row[member_id]; //id \r
  50         $response->rows[$i]['cell']=array($row[member_id],\r
  51                                           $row[login],\r
  52                                           addslashes($row[full_name]),\r
  53                                           $row[email],\r
  54                                           $row[create_date],\r
  55                                           $row[ldap_source]);\r
  56         $i++;\r
  57     } \r
  58     echo json_encode($response);\r
  59     exit();\r
  60 }\r
  61 require (AT_INCLUDE_PATH.'header.inc.php');  \r
  62 ?>\r
  63 <link rel="stylesheet" type="text/css" media="screen" href="/jscripts/jqgrid/themes/basic/grid.css" />\r
  64 <link rel="stylesheet" type="text/css" media="screen" href="/jscripts/jqgrid/themes/jqModal.css" />\r
  65 <script src="/jscripts/jqgrid/jquery.js" type="text/javascript"></script>\r
  66 <script src="/jscripts/jqgrid/jquery.jqGrid.js" type="text/javascript"></script>\r
  67 <script src="/jscripts/jqgrid/js/jqModal.js" type="text/javascript"></script>\r
  68 <script src="/jscripts/jqgrid/js/jqDnR.js" type="text/javascript"></script>\r
  69 <script type="text/javascript"> \r
  70  jQuery(document).ready(function(){ \r
  71      jQuery("#ldapuserlist").jqGrid({ \r
  72              url:'/admin/ldap_auth_log.php', \r
  73              datatype: 'json', \r
  74              mtype: 'POST', \r
  75              colNames:[\r
  76                         '<?php echo(addslashes(_AT('ID')));?>',\r
  77                         '<?php echo(addslashes(_AT('login_name')));?>', \r
  78                         '<?php echo(addslashes(_AT('full_name')));?>',\r
  79                         '<?php echo(addslashes(_AT('email')));?>', \r
  80                         '<?php echo(addslashes(_AT('created_date')));?>',\r
  81                         '<?php echo(addslashes(_AT('ldap_source')));?>'], \r
  82              colModel :[ \r
  83                {name:'member_id', index:'member_id', width:30}, \r
  84                {name:'login', index:'login', width:85},\r
  85                {name:'last_name', index:'last_name', width:200},\r
  86                {name:'email', index:'email', width:130},\r
  87                {name:'create_date', index:'create_date', width:110},\r
  88                {name:'ldap_source', index:'ldap_source', width:90}], \r
  89              pager: jQuery('#pager'), \r
  90              rowNum:50, \r
  91              rowList:[50,100,150],\r
  92              sortname: 'create_date', \r
  93              sortorder: "desc", \r
  94              viewrecords: true, \r
  95              imgpath: '/jscripts/jqgrid/themes/basic/images', \r
  96              caption: 'LDAP Auth Log',\r
  97              width: 850,\r
  98              height: 'auto'\r
  99              }).navGrid('#pager',{\r
 100                 refresh:true,\r
 101                 edit: false,\r
 102                 add: false,\r
 103                 del: false,\r
 104                 search: false,\r
 105                 position: 'right'\r
 106                 } \r
 107              ); \r
 108  }); \r
 109 </script> \r
 110 <div>\r
 111 <table id="ldapuserlist" class="scroll"></table> \r
 112 <div id="pager" class="scroll" style="text-align:center;"></div>\r
 113 </div>\r
 114 <?php\r
 115 require (AT_INCLUDE_PATH.'footer.inc.php'); ?>\r