[Astlinux-commits] SF.net SVN: astlinux:[7124] branches/1.0/package/webinterface/altweb/admin/ cdrlog.php

[<abe...@us...>]

Revision: 7124
          http://sourceforge.net/p/astlinux/code/7124
Author:   abelbeck
Date:     2015-06-22 23:10:01 +0000 (Mon, 22 Jun 2015)
Log Message:
-----------
web interface, CDR Log tab, new 'Export CDR.csv' button

Modified Paths:
--------------
    branches/1.0/package/webinterface/altweb/admin/cdrlog.php

Modified: branches/1.0/package/webinterface/altweb/admin/cdrlog.php
===================================================================
--- branches/1.0/package/webinterface/altweb/admin/cdrlog.php	2015-06-19 18:03:15 UTC (rev 7123)
+++ branches/1.0/package/webinterface/altweb/admin/cdrlog.php	2015-06-22 23:10:01 UTC (rev 7124)
@@ -1,6 +1,6 @@
 <?php session_start();
 
-// Copyright (C) 2008-2009 Lonnie Abelbeck
+// Copyright (C) 2008-2015 Lonnie Abelbeck
 // This is free software, licensed under the GNU General Public License
 // version 3 as published by the Free Software Foundation; you can
 // redistribute it and/or modify it under the terms of the GNU
@@ -17,6 +17,7 @@
 // 10-02-2008, Add optional last column CDR value
 // 07-20-2009, Add David Kerr's code and ideas for multiple page support
 // 02-13-2010, Add multiple *.csv CDR Database suport
+// 06-22-2015, Add "Export CDR.csv" button
 //
 // cdr_custom.conf Master.csv definition for "Special cdr-custom" option
 // Master.csv => "${CDR(start)}","${CDR(clid)}","${CDR(dst)}","${CDR(dcontext)}","${CDR(billsec)}"
@@ -133,6 +134,49 @@
   return($cidtokens);
 }
 
+// Function: exportCDRline
+//
+function exportCDRline($data) {
+
+  $str  =  '"'.$data['time'].'"';
+  $str .= ',"'.$data['cidname'].'"';
+  $str .= ',"'.$data['cidnum'].'"';
+  $str .= ',"'.$data['ext'].'"';
+  $str .= ',"'.$data['context'].'"';
+  if (isset($data['channel'])) {
+    $str .= ',"'.$data['channel'].'"';
+  }
+  if (isset($data['dstchannel'])) {
+    $str .= ',"'.$data['dstchannel'].'"';
+  }
+  if (isset($data['disposition'])) {
+    $str .= ',"'.$data['disposition'].'"';
+  }
+  $str .= ',"['.secs2hourminsec($data['billsec']).']"';
+  $str .= ',"'.$data['billsec'].'"';
+
+  if (isset($data['lastapp'])) {
+    $str .= ',"'.$data['lastapp'].'"';
+  }
+  if (isset($data['lastdata'])) {
+    $str .= ',"'.$data['lastdata'].'"';
+  }
+  if (isset($data['amaflags'])) {
+    $str .= ',"'.$data['amaflags'].'"';
+  }
+  if (isset($data['accountcode'])) {
+    $str .= ',"'.$data['accountcode'].'"';
+  }
+  if (isset($data['uniqueid'])) {
+    $str .= ',"'.$data['uniqueid'].'"';
+  }
+  if (isset($data['userfield'])) {
+    $str .= ',"'.$data['userfield'].'"';
+  }
+
+  return($str);
+}
+
 // Function: parseCDRline
 //
 function parseCDRline($line, $format, $match, $map) {
@@ -507,6 +551,23 @@
         exit;
       }
     }
+  } elseif (isset($_POST['submit_export'])) {
+    if (($n = count($db['data'])) > 0) {
+      $search = isset($_POST['current_search']) ? $_POST['current_search'] : '';
+      $key = isset($_POST['current_key']) ? $_POST['current_key'] : '';
+      $name = 'CDR'.(($key === '') ? '' : '-'.$key).(($search === '') ? '' : '-'.rawurlencode($search)).'.csv';
+      header('Content-Type: application/octet-stream');             
+      header('Content-Disposition: attachment; filename="'.$name.'"');
+      header('Content-Transfer-Encoding: binary');                       
+      ob_clean();       
+      flush();                   
+      for ($i = 0; $i < $n; $i++) {
+        echo exportCDRline($db['data'][$i]), "\n";
+      }
+      exit;
+    } else {
+      $result = 0;
+    }
   } elseif (isset($_POST['submit_backup'])) {
     if (($fp = @fopen($db['logfile'],"rb")) === FALSE) {
       $result = 5;
@@ -675,6 +736,8 @@
 putHtml('<option value="channel"'.$sel.'>Match Src Channel:</option>');
 putHtml('</select>');
 putHtml('<input type="text" value="'.htmlspecialchars($search).'" size="18" maxlength="64" name="list_type_val" />');
+putHtml('<input type="hidden" name="current_search" value="'.htmlspecialchars($search).'" />');
+putHtml('<input type="hidden" name="current_key" value="'.$fkey.'" />');
 
 putHtml('</td><td style="text-align: center;">');
 putHtml('<select name="format_dl">');
@@ -711,6 +774,7 @@
   </select>
   </td></tr><tr><td style="text-align: center;">
   <input type="submit" value="Refresh CDR Display" name="submit_cdrlog" />
+  <input type="submit" value="Export CDR.csv" name="submit_export" />
   </td><td style="text-align: center;">
   <input type="submit" value="Download CDR.csv" name="submit_backup" />
   </td></tr>

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.