file_counts_folder.php

来自「泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5」· PHP 代码 · 共 40 行

<?php

include_once( "inc/img_bar_col.inc.php" );
include_once( "inc/img_count.php" );
include_once( "inc/conn.php" );
$sql = "SELECT * FROM unit";
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$companyname = $row['UNIT_NAME'];
$sql = " \r\n\t\t\tSELECT COUNT(*) AS cnt,fc.USER_ID,fs.SORT_NAME FROM file_content fc,file_sort fs \r\n\t\t\tWHERE fc.SORT_ID=fs.SORT_ID AND fs.SORT_TYPE>0  \r\n\t\t\tGROUP BY fs.SORT_ID";
$rs = exequery( $connection, $sql );
$key = 1;
$total = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$c_array[$key]['y'] = $row['SORT_NAME'];
	$c_array[$key]['x'] = $row['cnt'];
	$total += $row['cnt'];
	++$key;
}
$charhead = $companyname."文档模块，公共文档各目录含有文档数量报表";
$today = date( "Y-m-d H:i" );
$bottomnote = "报表生成日期时间".$today;
$subhead = "文档记录".$total."条";
$arrayCDScale = getymaxval( $c_array );
$coordinateMax = $arrayCDScale[0];
$scale = $arrayCDScale[1];
$xtotal = count( $c_array );
$height = getpicheight( $xtotal );
$relp = new reportbarimg( );
$relp->definepic( "png", 500, $height );
$relp->definepictinct( "gray02", "gray00", "gray01", "black" );
$relp->definecdpar( $coordinateMax, $scale, "数量", $xtotal, 1, "姓名" );
$relp->definelppar( true, false, true, 5, 10, true, "alpha" );
$relp->decorateimg( $charhead, $subhead, $bottomnote, $leftnote, $picname = "" );
$relp->drawbasiccoordinate( $c_array );
$relp->drawreportbar( $c_array, "blue" );
$relp->outimg( );
?>