wtf-tracker-cvs Mailing List for Work Tracking Facilitator
Brought to you by:
gryphonshafer
Menu
▾
▴
wtf-tracker-cvs — Automatic CVS Commit Notifications
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(8) |
Nov
(33) |
Dec
(50) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007 |
Jan
(17) |
Feb
|
Mar
(19) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Gryphon S. <gry...@us...> - 2007-03-28 22:57:21
|
Update of /cvsroot/wtf-tracker/wtf/util In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv13095/util Modified Files: update_db.pl Log Message: Fix minor bug (deref an arrayref) to make closing-out projects work based on config setting Index: update_db.pl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/util/update_db.pl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** update_db.pl 9 Mar 2007 22:56:59 -0000 1.2 --- update_db.pl 28 Mar 2007 22:56:55 -0000 1.3 *************** *** 63,67 **** b.product_id, b.bug_id AS bug, b.short_desc AS name, IF(b.bug_status NOT IN ( '} . ! join( q(','), WTF::Config::get('closed_states') ) . q{' ), 1, 0) AS active FROM bugs AS b --- 63,67 ---- b.product_id, b.bug_id AS bug, b.short_desc AS name, IF(b.bug_status NOT IN ( '} . ! join( q(','), @{ WTF::Config::get('closed_states') } ) . q{' ), 1, 0) AS active FROM bugs AS b |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 21:59:39
|
Update of /cvsroot/wtf-tracker/wtf/templates/pages/input In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv6944/templates/pages/input Modified Files: projects.tmpl Log Message: Feature add 1591668: Remember Last-Open Projects Group Index: projects.tmpl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/templates/pages/input/projects.tmpl,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** projects.tmpl 20 Dec 2006 00:04:32 -0000 1.5 --- projects.tmpl 21 Mar 2007 21:59:33 -0000 1.6 *************** *** 1,11 **** <tmpl_include name="header.tmpl"> ! <h4 class="iframe"><tmpl_var name="title"></h4> <tmpl_loop name="codelines"> <span class="codeline_header"> <a id="codeline_<tmpl_var name="id">_link" class="codeline_nav" ! href="javascript:expandCodelines('codeline_<tmpl_var ! name="id">','codeline_<tmpl_var name="id">_link')"><tmpl_var name="codeline" escape="html"></a> </span> --- 1,11 ---- <tmpl_include name="header.tmpl"> ! <h4 class="iframe" id="open_projects_h4"><tmpl_var name="title"></h4> <tmpl_loop name="codelines"> <span class="codeline_header"> <a id="codeline_<tmpl_var name="id">_link" class="codeline_nav" ! href="javascript:expandCodelines(<tmpl_var name="id">)" ! ><tmpl_var name="codeline" escape="html"></a> </span> |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 21:59:39
|
Update of /cvsroot/wtf-tracker/wtf/static In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv6944/static Modified Files: tracking.js Log Message: Feature add 1591668: Remember Last-Open Projects Group Index: tracking.js =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/static/tracking.js,v retrieving revision 1.15 retrieving revision 1.16 diff -C2 -d -r1.15 -r1.16 *** tracking.js 21 Mar 2007 18:30:16 -0000 1.15 --- tracking.js 21 Mar 2007 21:59:33 -0000 1.16 *************** *** 28,31 **** --- 28,43 ---- } } + + // if the page is the projects iframe, open any codelines + // that were previously open based on cookie data stored + if ( document.getElementById("open_projects_h4") ) { + var openCodelines = new Array(); + var cookie = getCookie("wtf_open_codelines"); + if (cookie) openCodelines = cookie.split(","); + + for ( var i in openCodelines ) { + expandCodelines( openCodelines[i], 1 ); + } + } } *************** *** 509,521 **** // expand/contract of specific codeline projects ! function expandCodelines( codeline_id, codeline_id_link ) { ! var codelineStyle = document.getElementById(codeline_id).style; // to open a codeline... ! if (codelineStyle.display == "none") { ! document.getElementById(codeline_id_link).className = "codeline_current"; // Internet Explorer requires display="block" whereas all good browsers understand "table" codelineStyle.display = ( document.all ) ? "block" : "table"; } --- 521,539 ---- // expand/contract of specific codeline projects ! function expandCodelines( id, noCookieWrite ) { ! var codelineStyle = document.getElementById( "codeline_" + id ).style; ! var openCodelines = new Array(); ! var cookie = getCookie("wtf_open_codelines"); ! if (cookie) openCodelines = cookie.split(","); // to open a codeline... ! if ( codelineStyle.display == "none" ) { ! document.getElementById( "codeline_" + id + "_link" ).className = "codeline_current"; // Internet Explorer requires display="block" whereas all good browsers understand "table" codelineStyle.display = ( document.all ) ? "block" : "table"; + + // add this codeline id to the list of open codelines + openCodelines.push(id); } *************** *** 523,528 **** else if ( codelineStyle.display == "block" || codelineStyle.display == "table" ) { codelineStyle.display = "none"; ! document.getElementById(codeline_id_link).className = "codeline_nav"; } } --- 541,558 ---- else if ( codelineStyle.display == "block" || codelineStyle.display == "table" ) { codelineStyle.display = "none"; ! document.getElementById( "codeline_" + id + "_link" ).className = "codeline_nav"; ! ! // remove instance of this codeline id from open codelines array ! for ( var i in openCodelines ) { ! if ( openCodelines[i] == id ) openCodelines.splice( i, 1 ); ! } } + + // set a cookie reprenting the open codeline ids + if ( ! noCookieWrite ) setCookie( + "wtf_open_codelines", + openCodelines.join(","), + new Date("October 25, 2073 03:15:00") + ); } *************** *** 671,676 **** "time from " + startDate + " through " + endDate + "?" ) ) { ! document.location.href = urlPath + ! "?date_start=" + startDate + "&date_end=" + endDate + "&action=delete"; } } --- 701,730 ---- "time from " + startDate + " through " + endDate + "?" ) ) { ! document.location.href = ! urlPath + "?date_start=" + startDate + "&date_end=" + endDate + "&action=delete"; } } + + function setCookie( name, value, expires, path, domain, secure ) { + var curCookie = name + "=" + escape(value) + + ( (expires) ? "; expires=" + expires.toGMTString() : "" ) + + ( (path) ? "; path=" + path : "" ) + + ( (domain) ? "; domain=" + domain : "" ) + + ( (secure) ? "; secure" : "" ); + document.cookie = curCookie; + } + + function getCookie(name) { + var dc = document.cookie; + var prefix = name + "="; + var begin = dc.indexOf( "; " + prefix ); + + if ( begin == -1 ) { + begin = dc.indexOf(prefix); + if (begin != 0) return null; + } else begin += 2; + + var end = document.cookie.indexOf( ";", begin ); + if ( end == -1 ) end = dc.length; + return unescape( dc.substring( begin + prefix.length, end ) ); + } |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 18:30:22
|
Update of /cvsroot/wtf-tracker/wtf/static In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv26609/static Modified Files: tracking.js Log Message: Bug fix 1640358: Copy Last Data function doesn't save correctly Index: tracking.js =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/static/tracking.js,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** tracking.js 9 Mar 2007 23:16:00 -0000 1.14 --- tracking.js 21 Mar 2007 18:30:16 -0000 1.15 *************** *** 316,319 **** --- 316,320 ---- function submitTrackingForm( trackingForm, verifyChanges ) { if ( skipFormDoubleSubmit == true ) return; + if ( trackingForm.copy_last_data_done.value == "on" ) trackingChange = true; // check to see whether the user made any changes on the form (in which case |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 18:30:20
|
Update of /cvsroot/wtf-tracker/wtf/templates/pages/input In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv26609/templates/pages/input Modified Files: tracking.tmpl Log Message: Bug fix 1640358: Copy Last Data function doesn't save correctly Index: tracking.tmpl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/templates/pages/input/tracking.tmpl,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** tracking.tmpl 2 Jan 2007 23:13:29 -0000 1.7 --- tracking.tmpl 21 Mar 2007 18:30:16 -0000 1.8 *************** *** 10,16 **** <input type="hidden" name="data" value="" /> <input type="hidden" name="copy_last_data" value="" /> ! <tmpl_unless name="show_copy_last_data"> ! <input type="hidden" name="copy_last_data_done" value="on" /> ! </tmpl_unless> <p> --- 10,15 ---- <input type="hidden" name="data" value="" /> <input type="hidden" name="copy_last_data" value="" /> ! <input type="hidden" name="copy_last_data_done" ! value="<tmpl_unless name="show_copy_last_data">on</tmpl_unless>" /> <p> |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 18:30:20
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv26609/lib/WTF Modified Files: SQL.pm Log Message: Bug fix 1640358: Copy Last Data function doesn't save correctly Index: SQL.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/SQL.pm,v retrieving revision 1.15 retrieving revision 1.16 diff -C2 -d -r1.15 -r1.16 *** SQL.pm 21 Mar 2007 17:26:31 -0000 1.15 --- SQL.pm 21 Mar 2007 18:30:15 -0000 1.16 *************** *** 367,373 **** 'max_work_day' => q{ ! SELECT IF( MAX(w.work_day) > MAX(n.work_day), MAX(w.work_day), MAX(n.work_day) ) AS last_date ! FROM work AS w, notes AS n ! WHERE w.employee_id = ? AND w.work_day < ? AND n.employee_id = ? AND n.work_day < ? }, --- 367,380 ---- 'max_work_day' => q{ ! SELECT IF( ! MAX(w.work_day) > MAX(n.work_day), ! IF( MAX(w.work_day) > MAX(s.work_day), MAX(w.work_day), MAX(s.work_day) ), ! IF( MAX(n.work_day) > MAX(s.work_day), MAX(n.work_day), MAX(s.work_day) ) ! ) AS last_date ! FROM work AS w, notes AS n, summary AS s ! WHERE ! w.employee_id = ? AND w.work_day < ? AND ! n.employee_id = ? AND n.work_day < ? AND ! s.employee_id = ? AND s.work_day < ? }, |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 18:30:19
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF/Pages In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv26609/lib/WTF/Pages Modified Files: Input.pm Log Message: Bug fix 1640358: Copy Last Data function doesn't save correctly Index: Input.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Input.pm,v retrieving revision 1.16 retrieving revision 1.17 diff -C2 -d -r1.16 -r1.17 *** Input.pm 9 Mar 2007 22:35:13 -0000 1.16 --- Input.pm 21 Mar 2007 18:30:16 -0000 1.17 *************** *** 157,160 **** --- 157,161 ---- $r->pnotes('user_id'), $display_date, $r->pnotes('user_id'), $display_date, + $r->pnotes('user_id'), $display_date, ) or die $dbh->errstr(); $data_date = $sth->{'max_work_day'}->fetchrow_array() || $display_date; |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 17:37:58
|
Update of /cvsroot/wtf-tracker/wtf/util In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv5822/util Modified Files: email_notify.pl Log Message: Bug fix for 1644793: need to not send reminder emails to inactive user accounts Index: email_notify.pl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/util/email_notify.pl,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** email_notify.pl 18 Oct 2006 16:52:50 -0000 1.1.1.1 --- email_notify.pl 21 Mar 2007 17:37:55 -0000 1.2 *************** *** 41,45 **** LEFT OUTER JOIN work AS w ON e.id = w.employee_id LEFT OUTER JOIN notes AS n ON e.id = n.employee_id ! WHERE a.name = 'email_notify' GROUP BY e.id HAVING --- 41,45 ---- LEFT OUTER JOIN work AS w ON e.id = w.employee_id LEFT OUTER JOIN notes AS n ON e.id = n.employee_id ! WHERE a.name = 'email_notify' AND e.active = 1 GROUP BY e.id HAVING |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 17:26:51
|
Update of /cvsroot/wtf-tracker/wtf/templates/pages/reports In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv1183/templates/pages/reports Modified Files: activity.tmpl Log Message: Feature add from bug 1656452: Activity Excel download Index: activity.tmpl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/templates/pages/reports/activity.tmpl,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** activity.tmpl 3 Dec 2006 23:03:44 -0000 1.4 --- activity.tmpl 21 Mar 2007 17:26:31 -0000 1.5 *************** *** 13,16 **** --- 13,22 ---- </tmpl_loop> </select> + + <input type="hidden" name="view" value="screen" /> + <input type="button" value="Download Data" onclick=" + this.form.view.value = 'excel'; + this.form.submit(); + " /> </p> </form> |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 17:26:46
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv1183/lib/WTF Modified Files: SQL.pm Log Message: Feature add from bug 1656452: Activity Excel download Index: SQL.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/SQL.pm,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** SQL.pm 9 Mar 2007 22:34:53 -0000 1.14 --- SQL.pm 21 Mar 2007 17:26:31 -0000 1.15 *************** *** 322,325 **** --- 322,326 ---- IF( DATE_FORMAT( work_day, '%Y-%m' ) = ?, 1, 0 ) AS selected FROM summary + WHERE vacation = 0 AND sick = 0 GROUP BY datestamp ORDER BY datestamp DESC *************** *** 410,413 **** --- 411,451 ---- }, + 'activity_xls_activities' => q{ + SELECT id, activity_id AS parent_id, name + FROM activity + WHERE id NOT IN ( + SELECT DISTINCT activity_id FROM activity + WHERE activity_id IS NOT NULL AND active = 1 + ) AND active = 1 + ORDER BY ordering + }, + + 'activity_xls_percentages' => q{ + SELECT + e.id AS employee_id, e.name AS employee_name, e.active, + a.id AS activity_id, AVG( acts.percentage ) AS avg_percentage + FROM employee AS e + LEFT JOIN summary AS s ON s.employee_id = e.id + LEFT JOIN activity_summary AS acts ON s.id = acts.summary_id + LEFT JOIN activity AS a ON acts.activity_id = a.id + WHERE ( + 1 NOT IN ( s.vacation, s.sick ) AND SUBSTRING( s.work_day, 1, 7 ) = ? AND + a.id NOT IN ( + SELECT DISTINCT activity_id FROM activity + WHERE activity_id IS NOT NULL AND active = 1 + ) + ) OR ( a.id IS NULL AND s.vacation IS NULL AND s.sick IS NULL ) + GROUP BY a.id, e.id + ORDER BY e.name, a.ordering + }, + + 'activity_xls_vacation_sick' => q{ + SELECT SUM( vacation ) AS vacation, SUM( sick ) AS sick + FROM summary + WHERE employee_id = ? AND SUBSTRING( work_day, 1, 7 ) = ? + }, + + 'parent_activity' => 'SELECT id, name FROM activity WHERE id = ?', + ); |
|
From: Gryphon S. <gry...@us...> - 2007-03-21 17:26:42
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF/Pages In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv1183/lib/WTF/Pages Modified Files: Reports.pm Log Message: Feature add from bug 1656452: Activity Excel download Index: Reports.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Reports.pm,v retrieving revision 1.15 retrieving revision 1.16 diff -C2 -d -r1.15 -r1.16 *** Reports.pm 9 Mar 2007 22:35:13 -0000 1.15 --- Reports.pm 21 Mar 2007 17:26:31 -0000 1.16 *************** *** 310,313 **** --- 310,317 ---- my $req = WTF::Utils::get_req($r); + # build and return an XLS if the user requested a download + return xls_activity_summary( $r, $req ) + if ( defined $req->param('view') and $req->param('view') eq 'excel' ); + # fetch data to populate the months drop-down select box $sth->{'activity_months'}->execute( $req->param('month') || '' ) or die $dbh->errstr(); *************** *** 396,399 **** --- 400,625 ---- } + sub xls_activity_summary { + my ( $r, $req ) = @_; + + # fetch activity (lowest-level) list + $sth->{'activity_xls_activities'}->execute() or die $dbh->errstr(); + my @activities = @{ $sth->{'activity_xls_activities'}->fetchall_arrayref({}) }; + $sth->{'activity_xls_activities'}->finish(); + + # fetch parent activity list + my ( $last_parent_id, @parent_activities ); + for (@activities) { + if ( @parent_activities and $_->{'parent_id'} eq $last_parent_id ) { + # increase the colspan (width in columns of the parent activity cell + $parent_activities[-1]->{'colspan'}++; + } + else { + $last_parent_id = $_->{'parent_id'}; + + $sth->{'parent_activity'}->execute( $_->{'parent_id'} ) or die $dbh->errstr(); + push @parent_activities, $sth->{'parent_activity'}->fetchrow_hashref(); + $parent_activities[-1]->{'colspan'} = 1; + $sth->{'parent_activity'}->finish(); + } + } + + # build employee data structure + my ( @employees, $index ); + $sth->{'activity_xls_percentages'}->execute( $req->param('month') ) or die $dbh->errstr(); + while ( my $row = $sth->{'activity_xls_percentages'}->fetchrow_hashref() ) { + + if ( not @employees or $employees[-1]{'employee_id'} != $row->{'employee_id'} ) { + push @employees, $row; + $index = 0; + } + + # include percentage data for the given employee + while ( $index < @activities ) { + push @{ $employees[-1]->{'percentages'} }, ( + exists $activities[$index]->{'id'} and + $row->{'activity_id'} and + $row->{'avg_percentage'} and + $row->{'activity_id'} == $activities[$index]->{'id'} + ) ? $row->{'avg_percentage'} : undef; + + $index++; + last if ( defined $employees[-1]->{'percentages'}[-1] ); + } + + } + $sth->{'activity_xls_percentages'}->finish(); + + # level the average percentages and add vacation and sick data + for my $employee (@employees) { + push @{ $employee->{'percentages'} }, undef + while ( scalar @{ $employee->{'percentages'} } < scalar @activities ); + + my $total_percentage = 0; + $total_percentage += $_ || 0 for ( @{ $employee->{'percentages'} } ); + + for ( @{ $employee->{'percentages'} } ) { + $_ = sprintf( "\%.5f", $_ / $total_percentage ) if ( defined $_ ); + } + + # include vacation and sick data + $sth->{'activity_xls_vacation_sick'}->execute( + $employee->{'employee_id'}, + $req->param('month'), + ) or die $dbh->errstr(); + ( + $employee->{'vacation'}, + $employee->{'sick'}, + ) = $sth->{'activity_xls_vacation_sick'}->fetchrow_array(); + $sth->{'activity_xls_vacation_sick'}->finish(); + } + + # build excel workbook + my $workbook = WTF::Utils::make_excel_workbook( $r, 'activity_' . $req->param('month') . '.xls' ); + my $formats = WTF::Utils::make_excel_formats($workbook); + my $worksheet = $workbook->add_worksheet( $req->param('month') ); + + $worksheet->freeze_panes( 4, 0 ); + $worksheet->write( 0, 0, 'Activity Summary for ' . $req->param('month'), $formats->{'title'} ); + $worksheet->set_column( 0, 0, 26 ); + $worksheet->set_column( 1, scalar @activities, 14 ); + + my @excel_bg_colors = ( 24, 29, 22, 26, 27, 31, 42, 50 .. 53, 2, 3, 5 .. 7 ); + my $column = 1; + my %activity_formats; + + my $get_header_format = sub { + return $workbook->add_format( + 'bg_color' => $_[0], + 'bold' => $_[1], + 'top' => 1, + 'bottom' => 1, + 'left' => 1, + 'right' => 1, + 'text_wrap' => 1, + 'align' => 'center', + ); + }; + my %picked_colors; + + # add parent activities + for (@parent_activities) { + $picked_colors{ $_->{'id'} } = shift @excel_bg_colors; + + if ( $_->{'colspan'} > 1 ) { + $worksheet->merge_range( + 2, $column, 2, $column + $_->{'colspan'} - 1, $_->{'name'}, + $get_header_format->( $picked_colors{ $_->{'id'} }, 1 ), + ); + } + else { + $worksheet->write( + 2, $column, $_->{'name'}, + $get_header_format->( $picked_colors{ $_->{'id'} }, 1 ), + ); + } + $column += $_->{'colspan'}; + } + + # add supplemental data (vacation and sick days) headers + $picked_colors{'supplemental'} = shift @excel_bg_colors; + $worksheet->merge_range( + 2, $column, 2, $column + 1, 'Other Events', + $get_header_format->( $picked_colors{'supplemental'}, 1 ), + ); + + # add activity headers + $column = 1; + for (@activities) { + $worksheet->write( + 3, $column, $_->{'name'}, + $get_header_format->( $picked_colors{ $_->{'parent_id'} }, 0 ) + ); + $column++; + } + + # add vacation and sick day headers + for ( 'Vacation Days', 'Sick Days' ) { + $worksheet->write( + 3, $column, $_, + $get_header_format->( $picked_colors{'supplemental'}, 0 ), + ); + $column++; + } + + $worksheet->write( 3, 0, 'Employee Name', $workbook->add_format( 'bold' => 1 ) ); + + my $row = 4; + my $format_percentage = $workbook->add_format( + 'left' => 1, + 'right' => 1, + ); + $format_percentage->set_num_format('0.0%'); + my $format_days = $workbook->add_format( + 'left' => 1, + 'right' => 1, + ); + + # add percentage and vacation/sick day data for each employee + for (@employees) { + $worksheet->write( + $row, 0, $_->{'employee_name'}, + ( not $_->{'active'} ) ? $workbook->add_format( 'italic' => 1 ) : undef, + ); + $worksheet->write_row( $row, 1, $_->{'percentages'}, $format_percentage ); + + $worksheet->write_row( $row, scalar @activities + 1, [ + $_->{'vacation'}, + $_->{'sick'}, + ], $format_days ); + + $row++; + } + + $worksheet->write( $row, 0, 'Weighted Average/Total', $workbook->add_format( + 'top' => 1, + 'right' => 1, + 'bold' => 1, + 'align' => 'right', + ) ); + + my $format_total_percent = $workbook->add_format( + 'top' => 1, + 'left' => 1, + 'right' => 1, + 'bottom' => 1, + 'bold' => 1, + ); + $format_total_percent->set_num_format('0.0%'); + + # setup the summary/totals row at the bottom of the spreadsheet + for ( 1 .. @activities ) { + $worksheet->write_formula( + $row, $_, + sprintf( + "=SUM(\%s5:\%s\%d)/SUM(B5:\%s\%d)", + chr( 65 + $_ ), chr( 65 + $_ ), $row, chr( 65 + scalar @activities ), $row, + ), + $format_total_percent, + ); + } + $worksheet->write_formula( + $row, scalar @activities + $_, + sprintf( + "=SUM(\%s5:\%s\%d)", + chr( 65 + @activities + $_ ), chr( 65 + @activities + $_ ), $row + ), + $workbook->add_format( + 'top' => 1, + 'bottom' => 1, + 'right' => 1, + 'bold' => 1, + ), + ) for ( 1, 2 ); + + $workbook->close(); + return; + } + sub xls_team_view_build { my ( $r, $filename, $title, $date_start, $date_end, $team_ids ) = @_; |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 23:16:05
|
Update of /cvsroot/wtf-tracker/wtf/static In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv9900/static Modified Files: tracking.js Log Message: Fix bug 1650064: occures -> occurs Index: tracking.js =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/static/tracking.js,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** tracking.js 2 Jan 2007 23:13:29 -0000 1.13 --- tracking.js 9 Mar 2007 23:16:00 -0000 1.14 *************** *** 648,652 **** if ( dateStart > dateEnd ) { alert( ! "It appears that you have entered a start date that occures\n" + "before the end date. Please change your date range and retry." ); --- 648,652 ---- if ( dateStart > dateEnd ) { alert( ! "It appears that you have entered a start date that occurs\n" + "before the end date. Please change your date range and retry." ); *************** *** 657,661 **** alert( "You cannot schedule vacation days that occure in the past.\n" + ! "Please re-enter a date range that occures in the future." ); return false; --- 657,661 ---- alert( "You cannot schedule vacation days that occure in the past.\n" + ! "Please re-enter a date range that occurs in the future." ); return false; |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 23:06:10
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv6152/lib/WTF Modified Files: Config.pm Log Message: Minor change to fix a bug with closed_states returning an array instead of an arrayref Index: Config.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Config.pm,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** Config.pm 9 Mar 2007 22:56:58 -0000 1.9 --- Config.pm 9 Mar 2007 23:06:07 -0000 1.10 *************** *** 48,52 **** # Bug state(s) considered to be "closed" projects # (i.e. will cause bugs to be hidden on a database update) ! 'closed_states' => qw( CLOSED VERIFIED ), # HTML::Template template file settings --- 48,52 ---- # Bug state(s) considered to be "closed" projects # (i.e. will cause bugs to be hidden on a database update) ! 'closed_states' => [ 'CLOSED', 'VERIFIED' ], # HTML::Template template file settings |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 22:57:04
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv1767/lib/WTF Modified Files: Config.pm Log Message: Changes to fix bug 1644788: Change bugzilla state trigger Index: Config.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Config.pm,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** Config.pm 3 Jan 2007 18:52:52 -0000 1.8 --- Config.pm 9 Mar 2007 22:56:58 -0000 1.9 *************** *** 1,4 **** package WTF::Config; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Config; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 46,49 **** --- 46,53 ---- }, + # Bug state(s) considered to be "closed" projects + # (i.e. will cause bugs to be hidden on a database update) + 'closed_states' => qw( CLOSED VERIFIED ), + # HTML::Template template file settings 'templates' => { *************** *** 80,84 **** # version number to display on navigation bar ! 'version' => '1.03a', }; --- 84,88 ---- # version number to display on navigation bar ! 'version' => '1.04', }; *************** *** 100,104 **** =head1 VERSION ! This document describes WTF::Config version 1.03 =head1 SYNOPSIS --- 104,108 ---- =head1 VERSION ! This document describes WTF::Config version 1.04 =head1 SYNOPSIS |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 22:57:04
|
Update of /cvsroot/wtf-tracker/wtf/util In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv1767/util Modified Files: update_db.pl Log Message: Changes to fix bug 1644788: Change bugzilla state trigger Index: update_db.pl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/util/update_db.pl,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** update_db.pl 18 Oct 2006 16:52:50 -0000 1.1.1.1 --- update_db.pl 9 Mar 2007 22:56:59 -0000 1.2 *************** *** 16,32 **** use WTF::Config; ! my $dbh_wtf = DBI->connect( ! WTF::Config::get( 'database', 'dsn' ), ! WTF::Config::get( 'database', 'user' ), ! WTF::Config::get( 'database', 'passwd' ), ! { RaiseError => 1, AutoCommit => 1 } ! ) or die $DBI::errstr; ! ! my $dbh_bz = DBI->connect( ! WTF::Config::get( 'bugzilla', 'dsn' ), ! WTF::Config::get( 'bugzilla', 'user' ), ! WTF::Config::get( 'bugzilla', 'passwd' ), ! { RaiseError => 1, AutoCommit => 1 } ! ) or die $DBI::errstr; sub copy_data { --- 16,27 ---- use WTF::Config; ! my ( $dbh_wtf, $dbh_bz ) = map { ! DBI->connect( ! WTF::Config::get( $_, 'dsn' ), ! WTF::Config::get( $_, 'user' ), ! WTF::Config::get( $_, 'passwd' ), ! { 'RaiseError' => 1, 'AutoCommit' => 1 }, ! ) or die $DBI::errstr ! } qw( database bugzilla ); sub copy_data { *************** *** 67,71 **** SELECT b.product_id, b.bug_id AS bug, b.short_desc AS name, ! IF(b.bug_status NOT IN ('CLOSED', 'VERIFIED'), 1, 0) AS active FROM bugs AS b INNER JOIN components AS c ON b.component_id = c.id --- 62,68 ---- SELECT b.product_id, b.bug_id AS bug, b.short_desc AS name, ! IF(b.bug_status NOT IN ( '} . ! join( q(','), WTF::Config::get('closed_states') ) ! . q{' ), 1, 0) AS active FROM bugs AS b INNER JOIN components AS c ON b.component_id = c.id |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 22:35:17
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF/Pages In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv25182/lib/WTF/Pages Modified Files: Admin.pm Input.pm Reports.pm Log Message: Updated version number for next release Index: Reports.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Reports.pm,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** Reports.pm 2 Jan 2007 23:39:16 -0000 1.14 --- Reports.pm 9 Mar 2007 22:35:13 -0000 1.15 *************** *** 1,4 **** package WTF::Pages::Reports; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Pages::Reports; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 617,621 **** =head1 VERSION ! This document describes WTF::Pages::Reports version 1.03 =head1 SYNOPSIS --- 617,621 ---- =head1 VERSION ! This document describes WTF::Pages::Reports version 1.04 =head1 SYNOPSIS Index: Admin.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Admin.pm,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** Admin.pm 2 Jan 2007 23:39:16 -0000 1.9 --- Admin.pm 9 Mar 2007 22:35:12 -0000 1.10 *************** *** 1,4 **** package WTF::Pages::Admin; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Pages::Admin; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 499,503 **** =head1 VERSION ! This document describes WTF::Pages::Admin version 1.03 =head1 SYNOPSIS --- 499,503 ---- =head1 VERSION ! This document describes WTF::Pages::Admin version 1.04 =head1 SYNOPSIS Index: Input.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Input.pm,v retrieving revision 1.15 retrieving revision 1.16 diff -C2 -d -r1.15 -r1.16 *** Input.pm 3 Jan 2007 21:28:43 -0000 1.15 --- Input.pm 9 Mar 2007 22:35:13 -0000 1.16 *************** *** 1,4 **** package WTF::Pages::Input; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Pages::Input; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 426,430 **** =head1 VERSION ! This document describes WTF::Pages::Input version 1.03 =head1 SYNOPSIS --- 426,430 ---- =head1 VERSION ! This document describes WTF::Pages::Input version 1.04 =head1 SYNOPSIS |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 22:35:17
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF/Apache In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv25182/lib/WTF/Apache Modified Files: Authen.pm Authz.pm Response.pm Log Message: Updated version number for next release Index: Authz.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Apache/Authz.pm,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** Authz.pm 2 Jan 2007 23:39:16 -0000 1.8 --- Authz.pm 9 Mar 2007 22:35:12 -0000 1.9 *************** *** 1,4 **** package WTF::Apache::Authz; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Apache::Authz; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 69,73 **** =head1 VERSION ! This document describes WTF::Apache::Authz version 1.03 =head1 DESCRIPTION --- 69,73 ---- =head1 VERSION ! This document describes WTF::Apache::Authz version 1.04 =head1 DESCRIPTION Index: Authen.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Apache/Authen.pm,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** Authen.pm 2 Jan 2007 23:39:16 -0000 1.5 --- Authen.pm 9 Mar 2007 22:35:12 -0000 1.6 *************** *** 1,4 **** package WTF::Apache::Authen; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Apache::Authen; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 107,111 **** =head1 VERSION ! This document describes WTF::Apache::Authen version 1.03 =head1 DESCRIPTION --- 107,111 ---- =head1 VERSION ! This document describes WTF::Apache::Authen version 1.04 =head1 DESCRIPTION Index: Response.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Apache/Response.pm,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** Response.pm 2 Jan 2007 23:39:16 -0000 1.3 --- Response.pm 9 Mar 2007 22:35:12 -0000 1.4 *************** *** 1,4 **** package WTF::Apache::Response; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Apache::Response; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 23,27 **** =head1 VERSION ! This document describes WTF::Apache::Response version 1.03 =head1 DESCRIPTION --- 23,27 ---- =head1 VERSION ! This document describes WTF::Apache::Response version 1.04 =head1 DESCRIPTION |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 22:35:00
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv24793/lib/WTF Modified Files: DBH.pm Data.pm Pages.pm SQL.pm Utils.pm Log Message: Updated version number for next release Index: SQL.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/SQL.pm,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** SQL.pm 2 Jan 2007 23:39:16 -0000 1.13 --- SQL.pm 9 Mar 2007 22:34:53 -0000 1.14 *************** *** 1,4 **** package WTF::SQL; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::SQL; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 433,437 **** =head1 VERSION ! This document describes WTF::SQL version 1.03 =head1 SYNOPSIS --- 433,437 ---- =head1 VERSION ! This document describes WTF::SQL version 1.04 =head1 SYNOPSIS Index: Pages.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages.pm,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** Pages.pm 2 Jan 2007 23:39:16 -0000 1.7 --- Pages.pm 9 Mar 2007 22:34:53 -0000 1.8 *************** *** 1,4 **** package WTF::Pages; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Pages; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 93,97 **** =head1 VERSION ! This document describes WTF::Pages version 1.03 =head1 SYNOPSIS --- 93,97 ---- =head1 VERSION ! This document describes WTF::Pages version 1.04 =head1 SYNOPSIS Index: Data.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Data.pm,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** Data.pm 2 Jan 2007 23:39:16 -0000 1.5 --- Data.pm 9 Mar 2007 22:34:53 -0000 1.6 *************** *** 1,4 **** package WTF::Data; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Data; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 120,124 **** =head1 VERSION ! This document describes WTF::Data version 1.03 =head1 SYNOPSIS --- 120,124 ---- =head1 VERSION ! This document describes WTF::Data version 1.04 =head1 SYNOPSIS *************** *** 171,175 **** { 'codeline' => 'Management Systems', ! 'hours' => '1.00', 'date' => '2006-10-02', 'project' => 'New Project X (Func. Spec. Review, Sign-off)', --- 171,175 ---- { 'codeline' => 'Management Systems', ! 'hours' => '1.04', 'date' => '2006-10-02', 'project' => 'New Project X (Func. Spec. Review, Sign-off)', *************** *** 216,220 **** { 'codeline' => 'Management Systems', ! 'hours' => '1.00', 'date' => '2006-10-02', 'project' => 'New Project X (Func. Spec.)', --- 216,220 ---- { 'codeline' => 'Management Systems', ! 'hours' => '1.04', 'date' => '2006-10-02', 'project' => 'New Project X (Func. Spec.)', Index: Utils.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Utils.pm,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** Utils.pm 2 Jan 2007 23:39:16 -0000 1.7 --- Utils.pm 9 Mar 2007 22:34:53 -0000 1.8 *************** *** 1,4 **** package WTF::Utils; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::Utils; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 292,296 **** =head1 VERSION ! This document describes WTF::Utils version 1.03 =head1 SYNOPSIS --- 292,296 ---- =head1 VERSION ! This document describes WTF::Utils version 1.04 =head1 SYNOPSIS Index: DBH.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/DBH.pm,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** DBH.pm 2 Jan 2007 23:39:16 -0000 1.2 --- DBH.pm 9 Mar 2007 22:34:53 -0000 1.3 *************** *** 1,4 **** package WTF::DBH; ! our $VERSION = 1.03; use strict; use warnings; --- 1,4 ---- package WTF::DBH; ! our $VERSION = 1.04; use strict; use warnings; *************** *** 18,22 **** Apache::DBI->connect_on_init( (CONNECT) ); ! Apache::DBI->setPingTimeOut( DSN, 120 ); sub connect { --- 18,22 ---- Apache::DBI->connect_on_init( (CONNECT) ); ! Apache::DBI->setPingTimeOut( DSN, 120 ); sub connect { *************** *** 34,38 **** =head1 VERSION ! This document describes WTF::DBH version 1.03 =head1 SYNOPSIS --- 34,38 ---- =head1 VERSION ! This document describes WTF::DBH version 1.04 =head1 SYNOPSIS |
|
From: Gryphon S. <gry...@us...> - 2007-03-09 22:32:45
|
Update of /cvsroot/wtf-tracker/wtf In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv23960 Modified Files: httpd.conf Log Message: Updated version number for next release Index: httpd.conf =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/httpd.conf,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** httpd.conf 11 Dec 2006 18:13:07 -0000 1.6 --- httpd.conf 9 Mar 2007 22:32:32 -0000 1.7 *************** *** 1,4 **** # Apache2/mod_perl2 configuration file for WTF ! # Version 1.02 # preload and cache CPAN modules --- 1,4 ---- # Apache2/mod_perl2 configuration file for WTF ! # Version 1.04 # preload and cache CPAN modules |
|
From: Gryphon S. <gry...@us...> - 2007-01-03 21:28:49
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF/Pages In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv31925/lib/WTF/Pages Modified Files: Input.pm Log Message: Add a line to fix (silence) undefined warnings from a conditional Index: Input.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Input.pm,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** Input.pm 2 Jan 2007 23:39:16 -0000 1.14 --- Input.pm 3 Jan 2007 21:28:43 -0000 1.15 *************** *** 333,336 **** --- 333,340 ---- my ( $vacation, $sick, @date_data ) = ( 0, 0 ); while ( $_ = $sth->{$query_name}->fetchrow_hashref() ) { + + # ...to fix undefined warnings from next conditional + $_->{'vacation'} = ( $_->{'vacation'} ) ? 1 : 0; + if ( @date_data and # is there a previous entry |
|
From: Gryphon S. <gry...@us...> - 2007-01-03 18:52:55
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv2610/lib/WTF Modified Files: Config.pm Log Message: Updated version number to 1.03a Index: Config.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Config.pm,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** Config.pm 2 Jan 2007 23:39:16 -0000 1.7 --- Config.pm 3 Jan 2007 18:52:52 -0000 1.8 *************** *** 80,84 **** # version number to display on navigation bar ! 'version' => '1.02', }; --- 80,84 ---- # version number to display on navigation bar ! 'version' => '1.03a', }; |
|
From: Gryphon S. <gry...@us...> - 2007-01-03 18:52:36
|
Update of /cvsroot/wtf-tracker/wtf/templates/pages/reports In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv2585/templates/pages/reports Modified Files: myweekly.tmpl team_view.tmpl Log Message: Removed the escape=html for notes because we need <br/>s to get interpretted by the browser. Index: myweekly.tmpl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/templates/pages/reports/myweekly.tmpl,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** myweekly.tmpl 20 Dec 2006 00:04:32 -0000 1.4 --- myweekly.tmpl 3 Jan 2007 18:52:32 -0000 1.5 *************** *** 53,57 **** </tmpl_if> <tmpl_if name="notes"> ! <p class="indent"><tmpl_var name="notes" escape="html"></p> </tmpl_if> </tmpl_loop> --- 53,57 ---- </tmpl_if> <tmpl_if name="notes"> ! <p class="indent"><tmpl_var name="notes"></p> </tmpl_if> </tmpl_loop> Index: team_view.tmpl =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/templates/pages/reports/team_view.tmpl,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** team_view.tmpl 20 Dec 2006 00:04:32 -0000 1.8 --- team_view.tmpl 3 Jan 2007 18:52:32 -0000 1.9 *************** *** 195,199 **** <tmpl_loop name="note_content"> <dt><tmpl_var name="work_day"></dt> ! <dd><tmpl_var name="notes" escape="html"></dd> </tmpl_loop> </dl> --- 195,199 ---- <tmpl_loop name="note_content"> <dt><tmpl_var name="work_day"></dt> ! <dd><tmpl_var name="notes"></dd> </tmpl_loop> </dl> |
|
From: Gryphon S. <gry...@us...> - 2007-01-02 23:39:20
|
Update of /cvsroot/wtf-tracker/wtf In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv28721 Modified Files: readme.txt Log Message: Minor changes (typically POD and version numbering) to bring code up to ready for a release Index: readme.txt =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/readme.txt,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** readme.txt 3 Dec 2006 00:05:15 -0000 1.2 --- readme.txt 2 Jan 2007 23:39:16 -0000 1.3 *************** *** 90,93 **** --- 90,107 ---- ------------------------------------------------------------------------------ + Upgrading + ------------------------------------------------------------------------------ + + In theory, the only thing you have to do when upgrading is: + + 1. Save any changes to the "./httpd.conf" and "./lib/WTF/Config.pm" files. + + 2. Uncompress the new release of WTF over the top of your current release. + + 3. Run the database migration scripts located in "./db/migration" in + order. + + + ------------------------------------------------------------------------------ Copyright, License, and Disclaimer of Warranty ------------------------------------------------------------------------------ |
|
From: Gryphon S. <gry...@us...> - 2007-01-02 23:39:19
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF/Pages In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv28721/lib/WTF/Pages Modified Files: Admin.pm Input.pm Reports.pm Log Message: Minor changes (typically POD and version numbering) to bring code up to ready for a release Index: Reports.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Reports.pm,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** Reports.pm 2 Jan 2007 23:13:28 -0000 1.13 --- Reports.pm 2 Jan 2007 23:39:16 -0000 1.14 *************** *** 1,4 **** package WTF::Pages::Reports; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::Pages::Reports; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 617,621 **** =head1 VERSION ! This document describes WTF::Pages::Reports version 1.02 =head1 SYNOPSIS --- 617,621 ---- =head1 VERSION ! This document describes WTF::Pages::Reports version 1.03 =head1 SYNOPSIS *************** *** 710,713 **** --- 710,720 ---- break-out of time by employee and task. + =head2 screen_ooo_calendar() + + This is a page generation method that generates the "OOO Calendar" page + using the "reports/ooo_calendar.tmpl" HTML::Template template. + This page displays the vacation and sick days recorded (or in the case + of vacation days only, scheduled) by employees across the company. + =head1 DEPENDENCIES Index: Admin.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Admin.pm,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** Admin.pm 21 Dec 2006 19:33:54 -0000 1.8 --- Admin.pm 2 Jan 2007 23:39:16 -0000 1.9 *************** *** 1,4 **** package WTF::Pages::Admin; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::Pages::Admin; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 499,503 **** =head1 VERSION ! This document describes WTF::Pages::Admin version 1.02 =head1 SYNOPSIS --- 499,503 ---- =head1 VERSION ! This document describes WTF::Pages::Admin version 1.03 =head1 SYNOPSIS Index: Input.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages/Input.pm,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** Input.pm 2 Jan 2007 23:13:28 -0000 1.13 --- Input.pm 2 Jan 2007 23:39:16 -0000 1.14 *************** *** 1,4 **** package WTF::Pages::Input; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::Pages::Input; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 422,426 **** =head1 VERSION ! This document describes WTF::Pages::Input version 1.02 =head1 SYNOPSIS --- 422,426 ---- =head1 VERSION ! This document describes WTF::Pages::Input version 1.03 =head1 SYNOPSIS *************** *** 483,486 **** --- 483,501 ---- users from the "Daily Timesheet" page under "screen_tracking()". + =head2 screen_myvacation() + + This is a page generation method that generates the + "My Vacation and Sick Days" page using the "input/myvacation.tmpl" + HTML::Template template. + This page allows users to view their past vacation and sick days and + their future (scheduled) vacation days. User can also add to and remove + entries from the future (scheduled) list of vacation days. + + =head2 action_save_new_vacation() + + This action method saves changes to future (scheduled) vacation days + for the current user based on form data (or an entry click) from the + page generated by "screen_myvacation()". + =head1 DEPENDENCIES |
|
From: Gryphon S. <gry...@us...> - 2007-01-02 23:39:19
|
Update of /cvsroot/wtf-tracker/wtf/lib/WTF In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv28721/lib/WTF Modified Files: Config.pm DBH.pm Data.pm Pages.pm SQL.pm Utils.pm Log Message: Minor changes (typically POD and version numbering) to bring code up to ready for a release Index: Pages.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Pages.pm,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** Pages.pm 2 Jan 2007 23:13:28 -0000 1.6 --- Pages.pm 2 Jan 2007 23:39:16 -0000 1.7 *************** *** 1,4 **** package WTF::Pages; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::Pages; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 93,97 **** =head1 VERSION ! This document describes WTF::Pages version 1.02 =head1 SYNOPSIS --- 93,97 ---- =head1 VERSION ! This document describes WTF::Pages version 1.03 =head1 SYNOPSIS Index: Data.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Data.pm,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** Data.pm 2 Dec 2006 00:09:09 -0000 1.4 --- Data.pm 2 Jan 2007 23:39:16 -0000 1.5 *************** *** 1,4 **** package WTF::Data; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::Data; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 120,124 **** =head1 VERSION ! This document describes WTF::Data version 1.02 =head1 SYNOPSIS --- 120,124 ---- =head1 VERSION ! This document describes WTF::Data version 1.03 =head1 SYNOPSIS Index: Utils.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Utils.pm,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** Utils.pm 2 Jan 2007 23:13:28 -0000 1.6 --- Utils.pm 2 Jan 2007 23:39:16 -0000 1.7 *************** *** 1,4 **** package WTF::Utils; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::Utils; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 292,296 **** =head1 VERSION ! This document describes WTF::Utils version 1.02 =head1 SYNOPSIS --- 292,296 ---- =head1 VERSION ! This document describes WTF::Utils version 1.03 =head1 SYNOPSIS Index: DBH.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/DBH.pm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** DBH.pm 18 Oct 2006 16:52:50 -0000 1.1.1.1 --- DBH.pm 2 Jan 2007 23:39:16 -0000 1.2 *************** *** 1,4 **** package WTF::DBH; ! our $VERSION = 1.01; use strict; use warnings; --- 1,4 ---- package WTF::DBH; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 34,38 **** =head1 VERSION ! This document describes WTF::DBH version 1.01 =head1 SYNOPSIS --- 34,38 ---- =head1 VERSION ! This document describes WTF::DBH version 1.03 =head1 SYNOPSIS Index: Config.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/Config.pm,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** Config.pm 5 Dec 2006 16:02:32 -0000 1.6 --- Config.pm 2 Jan 2007 23:39:16 -0000 1.7 *************** *** 1,4 **** package WTF::Config; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::Config; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 100,104 **** =head1 VERSION ! This document describes WTF::Config version 1.02 =head1 SYNOPSIS --- 100,104 ---- =head1 VERSION ! This document describes WTF::Config version 1.03 =head1 SYNOPSIS Index: SQL.pm =================================================================== RCS file: /cvsroot/wtf-tracker/wtf/lib/WTF/SQL.pm,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** SQL.pm 2 Jan 2007 23:13:28 -0000 1.12 --- SQL.pm 2 Jan 2007 23:39:16 -0000 1.13 *************** *** 1,4 **** package WTF::SQL; ! our $VERSION = 1.02; use strict; use warnings; --- 1,4 ---- package WTF::SQL; ! our $VERSION = 1.03; use strict; use warnings; *************** *** 433,437 **** =head1 VERSION ! This document describes WTF::SQL version 1.02 =head1 SYNOPSIS --- 433,437 ---- =head1 VERSION ! This document describes WTF::SQL version 1.03 =head1 SYNOPSIS |
