tutos-commits Mailing List for TUTOS (Page 6)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Revision: 1217
          http://sourceforge.net/p/tutos/code/1217
Author:   gokohnert
Date:     2014-01-16 08:27:31 +0000 (Thu, 16 Jan 2014)
Log Message:
-----------
bug export CSV/EXCEL fixing long text

Modified Paths:
--------------
    trunk/php/bugtracking/bug.pinc
    trunk/php/bugtracking/bug_overview.php

Modified: trunk/php/bugtracking/bug.pinc
===================================================================

--- trunk/php/bugtracking/bug.pinc	2014-01-15 12:00:17 UTC (rev 1216)
+++ trunk/php/bugtracking/bug.pinc	2014-01-16 08:27:31 UTC (rev 1217)
@@ -624,12 +624,20 @@
                 $r .= $i->creation->getDateTime();
                 $r .= ' '. (is_object($i->creator) ? $i->creator->getFullName():'');
                 if ($this->parent->tutos['bug_use_revision'] == 1)
-                    $r .= '&#160;&#160;- '. $i->revision .' -';
-                $r .= "\n";
+                    $r .= '   - '. $i->revision .' -';
+                $r .= "\r\n";
                 if ($desc != $olddesc) {
-                    $r .= $desc ."\n";
+                    $d = $desc;
+                    $d = preg_replace('#&amp;#im','&',$d);
+                    $d = preg_replace('#&quot;#im','"',$d);
+                    $d = preg_replace('#<[biu]>#im','',$d);
+                    $d = preg_replace('#</[biu]>#im','',$d);
+                    $d = preg_replace('/&#8594;/im',' -> ',$d);
+                    $d = preg_replace('#<SPAN\s([a-z,0-9=_"]*)>#im','',$d);
+                    $d = preg_replace('#</SPAN>#im','',$d);
+                    $r .= $d ."\r\n";
                 }
-                $sep = "--------------------\n";
+                $sep = "--------------------\r\n";
             }
             $olddesc = $desc;
         }

Modified: trunk/php/bugtracking/bug_overview.php
===================================================================
--- trunk/php/bugtracking/bug_overview.php	2014-01-15 12:00:17 UTC (rev 1216)
+++ trunk/php/bugtracking/bug_overview.php	2014-01-16 08:27:31 UTC (rev 1217)
@@ -55,6 +55,100 @@
     }
 
     /**
+     * display the info as csv output
+     */
+    Function info_csv() {
+        global $lang;
+
+        Header("Content-Type: text/plain");
+        $r = '';
+        $r .= txt2csv('ID');
+        $r .= txt2csv($lang['BugID']);
+        $r .= txt2csv($lang['BugState']);
+        $r .= txt2csv($lang['BugTarget']);
+        $r .= txt2csv($lang['BugClass']);
+        $r .= txt2csv($lang['Date']);
+        $r .= txt2csv($lang['BugReference']);
+        $r .= txt2csv($lang['BugShort']);
+        $r .= txt2csv($lang['BugLong']);
+        $r .= txt2csv($lang['BugReportedFrom']);
+        $r .= txt2csv($lang['BugAssignedTo']);
+        $r .= txt2csv($lang['BugCreator']);
+        $r .= txt2csv('closed at');
+        // custom fields
+        foreach(get_custom_export_fields('bugtracking') as $ti => $tx) {
+            $r .= txt2csv($tx['lang']);
+        }
+        $r .= "\r\n";
+        foreach ($this->blist as $b) {
+            if (!is_object($b)) {
+                $id = $b;
+                $b = new bug($this->dbconn);
+                $b = $b->read($id,$b);
+            }
+            $b->read_bugHistory();
+            $r .= txt2csv($b->id);
+            $r .= txt2csv($b->name);
+            // State
+            $r .= txt2csv($b->getState());
+            // Target
+            if ( is_object($b->target) && $b->target->id > 0 ) {
+                $r .= txt2csv($b->target->getFullName());
+            } else {
+                $r.= txt2csv('');
+            }
+            // Class
+            $r .= txt2csv($lang['BugClasses'][$b->class]);
+            // Date
+            $r .= txt2csv($b->creation->getDateTime());
+            // Reference
+            if ( is_object($b->parent) && $b->parent->id > 0 ) {
+                $r .= txt2csv($b->parent->getFullName());
+            } else {
+                $r .= txt2csv($lang['HistoryDeleted']);
+            }
+            // Short
+            $r .= txt2csv($b->short);
+            // Long
+            if (count($b->bughist) > 0) {
+                $r.= txt2csv($b->getBugHistory(false,false));
+            } else {
+                $r.= txt2csv('');
+            }
+            // reporter
+            if ( is_object($b->reporter) && $b->reporter->id > 0 ) {
+                $r .= txt2csv($b->reporter->getFullName());
+            } else {
+                $r .= txt2csv($lang['HistoryDeleted']);
+            }
+            // solver
+            if ( is_object($b->solver) && $b->solver->id > 0 ) {
+                $r .= txt2csv($b->solver->getFullName());
+            } else {
+                $r .= txt2csv($lang['HistoryDeleted']);
+            }
+            // creator
+            if ( is_object($b->creator) && $b->creator->id > 0 ) {
+                $r .= txt2csv($b->creator->getFullName());
+            } else {
+                $r .= txt2csv($lang['HistoryDeleted']);
+            }
+            // SolveDate
+            $r .= txt2csv($b->solvedate->getDateTime());
+
+            // custom fields
+            foreach(get_custom_export_fields('bugtracking') as $ti => $tx) {
+                $f = '_fld_'.$ti;
+                $d = get_custom_field($tx,$b->$f,$b);
+                $r .= txt2csv($d);
+            }
+
+            $r .= "\r\n";
+        }
+        return $r;
+    }
+
+    /**
      * display the info as excel output
      */
     Function info_excel() {
@@ -142,6 +236,7 @@
                 $b = new bug($this->dbconn);
                 $b = $b->read($id,$b);
             }
+            $b->read_bugHistory();
             $c = 0;
 
             if (strpos($baseUrl, "bugtracking") === false) {
@@ -171,7 +266,7 @@
             }
             $worksheet1->write_string($x,$c++, myiconv($b->short),$format2);
             if (count($b->bughist) > 0) {
-                $worksheet1->write_string($x,$c++,myiconv($b->bughist[0]->description),$format2);
+                $worksheet1->write_string($x,$c++,myiconv($b->getBugHistory(false,false)),$format2);
             } else {
                 $c++;
             }
@@ -239,6 +334,8 @@
             return $r;
         } else if ($this->format == "excel") {
             return $this->info_excel();
+        } else if ($this->format == "csv") {
+            return $this->info_csv();
         } else if ( $this->format == "stat") {
             return $this->statinfo();
         }
@@ -1292,6 +1389,15 @@
                 );
             $this->addMenu($x);
         }
+        $ll = addUrlParameter($this->link1,'format=csv');
+        $ll = addUrlParameter($ll,'ss='.$this->ss);
+        $x = array( url => $ll,
+                    text => $lang['Export'] ."(CSV)",
+                    info => $lang['ExportInfo'],
+                    category => array('excel',bug::getType(),'view',usebugtracking)
+            );
+        $this->addMenu($x);
+
         $ll = addUrlParameter($this->link1,'format=excel');
         $ll = addUrlParameter($ll,'ss='.$this->ss);
         $x = array( url => $ll,

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





2001	Jan	Feb	Mar	Apr	May	Jun	Jul (13)	Aug (214)	Sep (144)	Oct (22)	Nov (22)	Dec (93)
2002	Jan (25)	Feb (31)	Mar (92)	Apr (70)	May (103)	Jun (130)	Jul (265)	Aug (325)	Sep (233)	Oct (244)	Nov (261)	Dec (157)
2003	Jan (101)	Feb (135)	Mar (148)	Apr (164)	May (53)	Jun (116)	Jul (149)	Aug (126)	Sep (45)	Oct (109)	Nov (36)	Dec (61)
2004	Jan (131)	Feb (236)	Mar (278)	Apr (259)	May (92)	Jun (110)	Jul (150)	Aug (64)	Sep (141)	Oct (141)	Nov (146)	Dec (65)
2005	Jan (70)	Feb (77)	Mar (129)	Apr (153)	May (161)	Jun (63)	Jul (42)	Aug (16)	Sep (30)	Oct (3)	Nov (8)	Dec (40)
2006	Jan (114)	Feb (16)	Mar (12)	Apr (15)	May (4)	Jun (9)	Jul (69)	Aug (27)	Sep (12)	Oct (80)	Nov (62)	Dec (41)
2007	Jan (34)	Feb (2)	Mar (38)	Apr (82)	May (61)	Jun (37)	Jul (16)	Aug (64)	Sep (7)	Oct (52)	Nov (18)	Dec (28)
2008	Jan (168)	Feb (26)	Mar (27)	Apr (19)	May (10)	Jun (58)	Jul (58)	Aug (91)	Sep (14)	Oct (23)	Nov (56)	Dec (38)
2009	Jan (58)	Feb (90)	Mar (204)	Apr (90)	May (27)	Jun (177)	Jul (116)	Aug (53)	Sep (42)	Oct (120)	Nov (51)	Dec (58)
2010	Jan (117)	Feb (231)	Mar (163)	Apr (90)	May (40)	Jun (139)	Jul (49)	Aug (118)	Sep (25)	Oct (80)	Nov (102)	Dec (99)
2011	Jan (176)	Feb (42)	Mar (60)	Apr (52)	May (30)	Jun (29)	Jul (27)	Aug (16)	Sep (51)	Oct (70)	Nov (63)	Dec (58)
2012	Jan (28)	Feb (26)	Mar (7)	Apr (12)	May (41)	Jun (61)	Jul (59)	Aug (38)	Sep (30)	Oct (28)	Nov (14)	Dec (31)
2013	Jan (24)	Feb (54)	Mar (45)	Apr (22)	May (35)	Jun (8)	Jul (18)	Aug (38)	Sep (11)	Oct (8)	Nov (19)	Dec (20)
2014	Jan (20)	Feb (22)	Mar (4)	Apr (6)	May (13)	Jun	Jul	Aug (1)	Sep	Oct	Nov	Dec (6)
2015	Jan	Feb (1)	Mar (4)	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (1)	Dec (1)
2016	Jan (4)	Feb	Mar	Apr (1)	May	Jun	Jul (2)	Aug (4)	Sep (1)	Oct (1)	Nov (1)	Dec
2017	Jan	Feb	Mar	Apr	May	Jun (3)	Jul (8)	Aug (13)	Sep (12)	Oct	Nov	Dec
2018	Jan	Feb	Mar (1)	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2019	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (1)	Dec
2020	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec (2)
2021	Jan	Feb (1)	Mar (1)	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

tutos-commits Mailing List for TUTOS (Page 6)

Projects / CRM / PLM / Calendar / Tasks / SCRUM / Test / Inventory

tutos-commits — SVN commits