From: Martin V. <mar...@us...> - 2006-03-11 17:32:57
|
Update of /cvsroot/outreach/opt/admin/info/projects In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5522/admin/info/projects Modified Files: index.php Log Message: Beautified source: Removed all ^M, created by DOS/Win editors Index: index.php =================================================================== RCS file: /cvsroot/outreach/opt/admin/info/projects/index.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** index.php 15 Aug 2002 20:42:17 -0000 1.1.1.1 --- index.php 11 Mar 2006 17:32:20 -0000 1.2 *************** *** 1,342 **** ! <? ! # ! # Projects info page ! # ! # Bogdan Stancescu <bo...@la...>, November 2001 ! # Revision 1.0 ! include "../../../include/OPT_lib.php"; ! auth_open(); ! ! if (($CRM_comp!=1) && !$CRM_guest) ! { ! echo("Page not found"); ! exit; ! } ! ! function make_stripes($col,$dark) ! { ! global $OPT_col_md, $OPT_col_dk; ! if ($dark) ! { ! if ($col=="bgcolor='$OPT_col_md'") ! { ! $the_col="bgcolor='$OPT_col_dk'"; ! } ! else ! { ! $the_col="bgcolor='$OPT_col_md'"; ! } ! } ! else ! { ! $the_col=$col; ! } ! return($the_col); ! } ! ?> ! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> ! <HTML> ! <HEAD> ! <TITLE>Projects Info</TITLE> ! <LINK REL=STYLESHEET TYPE="text/css" HREF="../../../include/opt_css.php"> ! <? echo $_OPT["head_xtra"]; ?> ! </HEAD> ! <? ! mainBody("../../../images"); ! make_main_title("Projects Info","../../../images"); ! $main_col="bgcolor='$OPT_col_md'"; ! startTables(); ! ?> ! <tr> ! <td <? echo make_stripes($main_col,0) ?> class="regular"> <strong>Title</strong></td> ! <td <? echo make_stripes($main_col,1) ?> class="regular" align="center"><strong>Active</strong></td> ! <td <? echo make_stripes($main_col,0) ?> class="regular" colspan="2" align="center"><strong>People<br>assigned</strong></td> ! <td <? echo make_stripes($main_col,1) ?> class="regular" align="center"><strong>Documents</strong></td> ! <td <? echo make_stripes($main_col,0) ?> class="regular" align="center"><strong>E-mail</strong></td> ! <td <? echo make_stripes($main_col,1) ?> class="regular" colspan="2" align="center"><strong>Tasks</strong></td> ! <td <? echo make_stripes($main_col,0) ?> class="regular" colspan="2" align="center"><strong>Requests</strong></td> ! </tr> ! <? ! $sql="select id, name, active ! from projects ! order by name"; ! $result=CRM_run_query($sql); ! $grey=0; ! while ($myrow=OPT_fetch_row($result)) ! { ! echo("<tr>\n"); // Start first row ! ! if ($grey) ! { ! $main_col="bgcolor='$OPT_col_md'"; ! } ! else ! { ! $main_col="bgcolor='$OPT_col_lt'"; ! } ! // Title ! $col=make_stripes($main_col,0); ! echo("<td class=\"regular\" $col rowspan='2'><a class=\"regular\" href=\"../../../projects/Proj_View/?proj=$myrow[0]\"><strong>$myrow[1]</strong></a> </td>\n"); ! ! // Active ! $col=make_stripes($main_col,1); ! if ($myrow[2]) ! { ! $active="<b>yes</b>"; ! } ! else ! { ! $active="<i>no</i>"; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$active</td>\n"); ! ! // People ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from people_proj where project=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! // Admin ! $sql="select count(*) from people,people_proj ! where people.id=people_proj.person and ! people_proj.project=$myrow[0] and ! people.company=1"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if ($myrow2[0]) ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! } ! else ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'> </td>\n"); ! } ! ! // Documents ! $col=make_stripes($main_col,1); ! $sql="select sum(asize),count(*) from documents where aproj=$myrow[0]"; ! $result2=CRM_run_query($sql); ! $asize=OPT_fetch_row($result2); ! $dcount=$asize[1]; ! $tot_doc_size=$asize[0]; ! if (!$dcount) ! { ! $dcount=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\">$dcount</td>\n"); ! ! // E-mails ! $col=make_stripes($main_col,0); ! $sql="select count(*) from email where project=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\">$myrow2[0]</td>\n"); ! ! // Tasks ! $col=make_stripes($main_col,1); ! // Total ! $sql="select count(*) from task where ProjectID=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! // Unresolved ! $sql="select count(*) from task where ProjectID=$myrow[0] and PercentComplete!=100"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if ($myrow2[0]) ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! } ! else ! { ! echo("<td class=\"regular\" $col rowspan='2'> </td>\n"); ! } ! ! // Requests ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from requests where aproj=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! // Unsolved ! $sql="select count(*) from requests where aproj=$myrow[0] and status!='resolved'"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if ($myrow2[0]) ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! } ! else ! { ! echo("<td class=\"regular\" $col rowspan='2'> </td>\n"); ! } ! ! echo("</tr>\n"); // End first row ! echo("<tr>\n"); // Start second row ! ! // Document size ! $col=make_stripes($main_col,1); ! echo("<td class=\"small\" $col align=\"center\">".niceSize($tot_doc_size)."</td>\n"); ! $grey=1-$grey; ! ! // E-mail size ! $col=make_stripes($main_col,0); ! $sql="select id, length(body) from email where project=$myrow[0]"; ! $result2=crm_run_query($sql); ! $mailsize=0; ! while ($myrow2=OPT_fetch_row($result2)) ! { ! $mailsize+=$myrow2[1]; ! $sql="select sum(size) from e_attach where e_mail=$myrow2[0]"; ! $result3=crm_run_query($sql); ! $myrow3=OPT_fetch_row($result3); ! $mailsize+=$myrow3[0]; ! } ! echo("<td class=\"small\" $col align=\"center\">".niceSize($mailsize)."</td>\n"); ! ! echo("</tr>\n"); // End second row ! } ! ! // TOTALS ! ! echo("<tr>\n"); // Start first row ! ! if ($grey) ! { ! $main_col="bgcolor='$OPT_col_md'"; ! } ! else ! { ! $main_col="bgcolor='$OPT_col_lt'"; ! } ! // Title ! $col=make_stripes($main_col,0); ! echo("<td class=\"regular\" $col rowspan='2'> <strong>TOTAL</strong></td>\n"); ! ! // Active ! $col=make_stripes($main_col,1); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>n/a</strong></td>\n"); ! ! // People ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from people"; ! $result=crm_run_query($sql); ! $myrow=OPT_fetch_row($result); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow[0]</strong></td>\n"); ! $sql="select count(*) from people where company=1"; ! $result=crm_run_query($sql); ! $myrow=OPT_fetch_row($result); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow[0]</strong></td>\n"); ! ! // Documents ! $col=make_stripes($main_col,1); ! $sql="select sum(asize),count(*) from documents"; ! $result2=CRM_run_query($sql); ! $asize=OPT_fetch_row($result2); ! $dcount=$asize[1]; ! $tot_doc_size=$asize[0]; ! if (!$dcount) ! { ! $dcount=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\"><strong>$dcount</strong></td>\n"); ! ! // E-mails ! $col=make_stripes($main_col,0); ! $sql="select count(*) from email"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\"><strong>$myrow2[0]</strong></td>\n"); ! ! // Tasks ! $col=make_stripes($main_col,1); ! // Total ! $sql="select count(*) from task"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! // Unsolved ! $sql="select count(*) from task where PercentComplete!=100"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! ! // Requests ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from requests"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! // Unsolved ! $sql="select count(*) from requests where status!='resolved'"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! ! echo("</tr>\n"); // End first row ! echo("<tr>\n"); // Start second row ! ! // Document size ! $col=make_stripes($main_col,1); ! echo("<td class=\"small\" $col align=\"center\"><strong>".niceSize($tot_doc_size)."</strong></td>\n"); ! ! // E-mail size ! $col=make_stripes($main_col,0); ! $sql="select id, length(body) from email"; ! $result2=crm_run_query($sql); ! $mailsize=0; ! while ($myrow2=OPT_fetch_row($result2)) ! { ! $mailsize+=$myrow2[1]; ! $sql="select sum(size) from e_attach where e_mail=$myrow2[0]"; ! $result3=crm_run_query($sql); ! $myrow3=OPT_fetch_row($result3); ! $mailsize+=$myrow3[0]; ! } ! echo("<td class=\"small\" $col align=\"center\"><b>".niceSize($mailsize)."</b></td>\n"); ! ! echo("</tr>\n"); // End second row ! ?> ! <tr> ! <td class="regular" colspan="10" bgcolor="<? echo $OPT_col_dk ?>" align="center"> ! The projects are ordered by title. ! </td> ! </tr> ! <tr> ! <td class="small" colspan="10" bgcolor="<? echo $OPT_col_dk ?>" align="center"> ! The second value for tasks and requests is the number of unresolved elements.<br> ! The second value for people is the number of administrators. ! </td> ! </tr> ! <tr> ! <td class="small" colspan="10" bgcolor="<? echo $OPT_col_dk ?>" align="center"> ! Please note that the people numbers in the bottom line is the total number of people ! registered in OPT and has nothing to do with the projects. ! </td> ! </tr> ! <? ! endTables(); ! auth_close(); ! ?> ! </BODY> ! </HTML> --- 1,342 ---- ! <? ! # ! # Projects info page ! # ! # Bogdan Stancescu <bo...@la...>, November 2001 ! # Revision 1.0 ! include "../../../include/OPT_lib.php"; ! auth_open(); ! ! if (($CRM_comp!=1) && !$CRM_guest) ! { ! echo("Page not found"); ! exit; ! } ! ! function make_stripes($col,$dark) ! { ! global $OPT_col_md, $OPT_col_dk; ! if ($dark) ! { ! if ($col=="bgcolor='$OPT_col_md'") ! { ! $the_col="bgcolor='$OPT_col_dk'"; ! } ! else ! { ! $the_col="bgcolor='$OPT_col_md'"; ! } ! } ! else ! { ! $the_col=$col; ! } ! return($the_col); ! } ! ?> ! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> ! <HTML> ! <HEAD> ! <TITLE>Projects Info</TITLE> ! <LINK REL=STYLESHEET TYPE="text/css" HREF="../../../include/opt_css.php"> ! <? echo $_OPT["head_xtra"]; ?> ! </HEAD> ! <? ! mainBody("../../../images"); ! make_main_title("Projects Info","../../../images"); ! $main_col="bgcolor='$OPT_col_md'"; ! startTables(); ! ?> ! <tr> ! <td <? echo make_stripes($main_col,0) ?> class="regular"> <strong>Title</strong></td> ! <td <? echo make_stripes($main_col,1) ?> class="regular" align="center"><strong>Active</strong></td> ! <td <? echo make_stripes($main_col,0) ?> class="regular" colspan="2" align="center"><strong>People<br>assigned</strong></td> ! <td <? echo make_stripes($main_col,1) ?> class="regular" align="center"><strong>Documents</strong></td> ! <td <? echo make_stripes($main_col,0) ?> class="regular" align="center"><strong>E-mail</strong></td> ! <td <? echo make_stripes($main_col,1) ?> class="regular" colspan="2" align="center"><strong>Tasks</strong></td> ! <td <? echo make_stripes($main_col,0) ?> class="regular" colspan="2" align="center"><strong>Requests</strong></td> ! </tr> ! <? ! $sql="select id, name, active ! from projects ! order by name"; ! $result=CRM_run_query($sql); ! $grey=0; ! while ($myrow=OPT_fetch_row($result)) ! { ! echo("<tr>\n"); // Start first row ! ! if ($grey) ! { ! $main_col="bgcolor='$OPT_col_md'"; ! } ! else ! { ! $main_col="bgcolor='$OPT_col_lt'"; ! } ! // Title ! $col=make_stripes($main_col,0); ! echo("<td class=\"regular\" $col rowspan='2'><a class=\"regular\" href=\"../../../projects/Proj_View/?proj=$myrow[0]\"><strong>$myrow[1]</strong></a> </td>\n"); ! ! // Active ! $col=make_stripes($main_col,1); ! if ($myrow[2]) ! { ! $active="<b>yes</b>"; ! } ! else ! { ! $active="<i>no</i>"; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$active</td>\n"); ! ! // People ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from people_proj where project=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! // Admin ! $sql="select count(*) from people,people_proj ! where people.id=people_proj.person and ! people_proj.project=$myrow[0] and ! people.company=1"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if ($myrow2[0]) ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! } ! else ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'> </td>\n"); ! } ! ! // Documents ! $col=make_stripes($main_col,1); ! $sql="select sum(asize),count(*) from documents where aproj=$myrow[0]"; ! $result2=CRM_run_query($sql); ! $asize=OPT_fetch_row($result2); ! $dcount=$asize[1]; ! $tot_doc_size=$asize[0]; ! if (!$dcount) ! { ! $dcount=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\">$dcount</td>\n"); ! ! // E-mails ! $col=make_stripes($main_col,0); ! $sql="select count(*) from email where project=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\">$myrow2[0]</td>\n"); ! ! // Tasks ! $col=make_stripes($main_col,1); ! // Total ! $sql="select count(*) from task where ProjectID=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! // Unresolved ! $sql="select count(*) from task where ProjectID=$myrow[0] and PercentComplete!=100"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if ($myrow2[0]) ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! } ! else ! { ! echo("<td class=\"regular\" $col rowspan='2'> </td>\n"); ! } ! ! // Requests ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from requests where aproj=$myrow[0]"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if (!$myrow2[0]) ! { ! $myrow2[0]=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! // Unsolved ! $sql="select count(*) from requests where aproj=$myrow[0] and status!='resolved'"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! if ($myrow2[0]) ! { ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'>$myrow2[0]</td>\n"); ! } ! else ! { ! echo("<td class=\"regular\" $col rowspan='2'> </td>\n"); ! } ! ! echo("</tr>\n"); // End first row ! echo("<tr>\n"); // Start second row ! ! // Document size ! $col=make_stripes($main_col,1); ! echo("<td class=\"small\" $col align=\"center\">".niceSize($tot_doc_size)."</td>\n"); ! $grey=1-$grey; ! ! // E-mail size ! $col=make_stripes($main_col,0); ! $sql="select id, length(body) from email where project=$myrow[0]"; ! $result2=crm_run_query($sql); ! $mailsize=0; ! while ($myrow2=OPT_fetch_row($result2)) ! { ! $mailsize+=$myrow2[1]; ! $sql="select sum(size) from e_attach where e_mail=$myrow2[0]"; ! $result3=crm_run_query($sql); ! $myrow3=OPT_fetch_row($result3); ! $mailsize+=$myrow3[0]; ! } ! echo("<td class=\"small\" $col align=\"center\">".niceSize($mailsize)."</td>\n"); ! ! echo("</tr>\n"); // End second row ! } ! ! // TOTALS ! ! echo("<tr>\n"); // Start first row ! ! if ($grey) ! { ! $main_col="bgcolor='$OPT_col_md'"; ! } ! else ! { ! $main_col="bgcolor='$OPT_col_lt'"; ! } ! // Title ! $col=make_stripes($main_col,0); ! echo("<td class=\"regular\" $col rowspan='2'> <strong>TOTAL</strong></td>\n"); ! ! // Active ! $col=make_stripes($main_col,1); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>n/a</strong></td>\n"); ! ! // People ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from people"; ! $result=crm_run_query($sql); ! $myrow=OPT_fetch_row($result); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow[0]</strong></td>\n"); ! $sql="select count(*) from people where company=1"; ! $result=crm_run_query($sql); ! $myrow=OPT_fetch_row($result); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow[0]</strong></td>\n"); ! ! // Documents ! $col=make_stripes($main_col,1); ! $sql="select sum(asize),count(*) from documents"; ! $result2=CRM_run_query($sql); ! $asize=OPT_fetch_row($result2); ! $dcount=$asize[1]; ! $tot_doc_size=$asize[0]; ! if (!$dcount) ! { ! $dcount=" "; ! } ! echo("<td class=\"regular\" $col align=\"center\"><strong>$dcount</strong></td>\n"); ! ! // E-mails ! $col=make_stripes($main_col,0); ! $sql="select count(*) from email"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\"><strong>$myrow2[0]</strong></td>\n"); ! ! // Tasks ! $col=make_stripes($main_col,1); ! // Total ! $sql="select count(*) from task"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! // Unsolved ! $sql="select count(*) from task where PercentComplete!=100"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! ! // Requests ! $col=make_stripes($main_col,0); ! // Total ! $sql="select count(*) from requests"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! // Unsolved ! $sql="select count(*) from requests where status!='resolved'"; ! $result2=crm_run_query($sql); ! $myrow2=OPT_fetch_row($result2); ! echo("<td class=\"regular\" $col align=\"center\" rowspan='2'><strong>$myrow2[0]</strong></td>\n"); ! ! echo("</tr>\n"); // End first row ! echo("<tr>\n"); // Start second row ! ! // Document size ! $col=make_stripes($main_col,1); ! echo("<td class=\"small\" $col align=\"center\"><strong>".niceSize($tot_doc_size)."</strong></td>\n"); ! ! // E-mail size ! $col=make_stripes($main_col,0); ! $sql="select id, length(body) from email"; ! $result2=crm_run_query($sql); ! $mailsize=0; ! while ($myrow2=OPT_fetch_row($result2)) ! { ! $mailsize+=$myrow2[1]; ! $sql="select sum(size) from e_attach where e_mail=$myrow2[0]"; ! $result3=crm_run_query($sql); ! $myrow3=OPT_fetch_row($result3); ! $mailsize+=$myrow3[0]; ! } ! echo("<td class=\"small\" $col align=\"center\"><b>".niceSize($mailsize)."</b></td>\n"); ! ! echo("</tr>\n"); // End second row ! ?> ! <tr> ! <td class="regular" colspan="10" bgcolor="<? echo $OPT_col_dk ?>" align="center"> ! The projects are ordered by title. ! </td> ! </tr> ! <tr> ! <td class="small" colspan="10" bgcolor="<? echo $OPT_col_dk ?>" align="center"> ! The second value for tasks and requests is the number of unresolved elements.<br> ! The second value for people is the number of administrators. ! </td> ! </tr> ! <tr> ! <td class="small" colspan="10" bgcolor="<? echo $OPT_col_dk ?>" align="center"> ! Please note that the people numbers in the bottom line is the total number of people ! registered in OPT and has nothing to do with the projects. ! </td> ! </tr> ! <? ! endTables(); ! auth_close(); ! ?> ! </BODY> ! </HTML> |