hrm_department_bar.php

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

<?php

include_once( "inc/img_bar.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 = "SELECT COUNT(*) AS cnt,DEPARTMENT FROM hrms GROUP BY DEPARTMENT";
$rs = exequery( $connection, $sql );
$key = 1;
$total = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$c_array[$key]['x'] = $row['DEPARTMENT'];
	$c_array[$key]['y'] = $row['cnt'];
	$total += $row['cnt'];
	++$key;
}
$charhead = $companyname."人事模块人事档案按部门报表";
$today = date( "Y-m-d H:i" );
$bottomnote = "报表生成日期时间".$today;
$subhead = "档案记录".$total."条";
$arrayCDScale = getxmaxval( $c_array );
$coordinateMax = $arrayCDScale[0];
$scale = $arrayCDScale[1];
$xtotal = count( $c_array );
$relp = new reportbarimg( );
$relp->definepic( "png", 500, 300 );
$relp->definepictinct( "gray02", "gray00", "gray01", "black" );
$relp->definecdpar( $xtotal, 1, "部门名称", $coordinateMax, $scale, "人员数" );
$relp->definelppar( false, true, true, 2, 10, true, "light" );
$relp->decorateimg( $charhead, $subhead, $bottomnote, $leftnote, $picname = "" );
$relp->drawbasiccoordinate( $c_array );
$relp->drawreportbar( $c_array, "blue" );
$relp->outimg( );
?>