crm_area_bar_down.php

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

<?php

function gettrovincename( $scale )
{
	$area_province = array( 2 => "北京", 3 => "上海", 4 => "天津", 5 => "河北", 6 => "山西", 7 => "内蒙", 8 => "辽宁", 9 => "吉林", 10 => "江苏", 11 => "浙江", 12 => "安徽", 13 => "福建", 14 => "江西", 15 => "山东", 16 => "河南", 17 => "湖北", 18 => "海南", 19 => "湖南", 20 => "广东", 21 => "广西", 22 => "重庆", 23 => "四川", 24 => "贵州", 25 => "云南", 26 => "西藏", 27 => "陕西", 28 => "甘肃", 29 => "青海", 30 => "宁夏", 31 => "新疆", 32 => "黑龙江", 47 => "台湾", 48 => "港澳" );
	if ( $scale )
	{
		$name = $area_province[$scale];
	}
	else
	{
		$name = "未知";
	}
	if ( $name == "" )
	{
		$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 = "SELECT COUNT(*) AS cnt,PROVINCE FROM customer ";
$userid = $_REQUEST['userid'];
if ( $userid != "" )
{
	$sql .= " WHERE MANAGE_USER='".$userid."' ";
}
$sql .= "GROUP BY PROVINCE";
$rs = exequery( $connection, $sql );
$key = 1;
$total = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$c_array[$key]['y'] = gettrovincename( $row['PROVINCE'] );
	$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, 0, 10, true, "alpha" );
$relp->decorateimg( $charhead, $subhead, $bottomnote, $leftnote, $picname = "" );
$relp->drawbasiccoordinate( $c_array );
$relp->drawreportbar( $c_array, "blue" );
$relp->outimg( );
?>