crm_scg.php

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

<?php

function getscalename( $scale )
{
	switch ( $scale )
	{
	case 0 :
		$name = "未知";
		break;
	case 1 :
		$name = "微型<10";
		break;
	case 2 :
		$name = "小型10-100";
		break;
	case 3 :
		$name = "中型500-1000";
		break;
	case 4 :
		$name = "中小型100-500";
		break;
	case 5 :
		$name = "大型>1000";
	}
	return $name;
}

include_once( "inc/img_pie.inc.php" );
include_once( "inc/conn.php" );
$sql = "SELECT * FROM unit";
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$companyname = $row['UNIT_NAME'];
$sql = "UPDATE customer SET SCALE=0 WHERE SCALE IS NULL";
exequery( $connection, $sql );
$sql = "UPDATE customer SET PROVINCE='' WHERE PROVINCE IS NULL";
exequery( $connection, $sql );
$sql = "UPDATE customer SET CUSTOMER_TYPE=0 WHERE CUSTOMER_TYPE IS NULL";
exequery( $connection, $sql );
$sql = "SELECT COUNT(*) AS cnt,SCALE FROM customer ";
$userid = $_REQUEST['userid'];
if ( $userid != "" )
{
	$sql .= " WHERE MANAGE_USER='".$userid."' ";
}
$sql .= "GROUP BY SCALE";
$rs = exequery( $connection, $sql );
$key = 1;
$total = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$c_array[$key]['x'] = getscalename( $row['SCALE'] );
	$c_array[$key]['y'] = $row['cnt'];
	$total += $row['cnt'];
	++$key;
}
$charhead = $companyname."商务模块客户公司规模报表";
$today = date( "Y-m-d H:i" );
$bottomnote = "报表生成日期时间".$today;
$subhead = "客户记录".$total."条";
$xtotal = count( $c_array );
$relp = new reportpieimg( );
$relp->definepic( "png", 500, 300 );
$relp->definepictinct( "gray02", "gray00", "gray01", "black" );
$relp->definecdpar( $xtotal, 1, "", 80, 10, "条客户" );
$relp->definelppar( true, true, 0.6, 100 );
$relp->decorateimg( $charhead = $charhead, $subhead = $subhead, $bottomnote = $bottomnote, $leftnote = "", $picname = "" );
$relp->drawbasiccoordinate( $c_array );
$relp->drawreportpie( $c_array );
$relp->outimg( );
?>