file_counts_pub.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

function getusername( $userid )
{
	global $connection;
	$sql = "SELECT USER_NAME FROM user WHERE USER_ID='".$userid."'";
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$name = $row['USER_NAME'];
	return $name;
}

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 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 fc.USER_ID";
$rs = exequery( $connection, $sql );
$key = 1;
$total = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$c_array[$key]['y'] = getusername( $row['USER_ID'] );
	$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( );
?>