crm_status_bar.php

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

<?php

function gettypename( $scale )
{
	switch ( $scale )
	{
	case 1 :
		$name = "正式客户";
		break;
	case 2 :
		$name = "重要客户";
		break;
	case 3 :
		$name = "潜在客户";
		break;
	case 4 :
		$name = "无效客户";
		break;
	default :
		$name = "未知客户";
	}
	return $name;
}

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 = "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,CUSTOMER_TYPE FROM customer ";
$userid = $_REQUEST['userid'];
if ( $userid != "" )
{
	$sql .= " WHERE MANAGE_USER='".$userid."'";
}
$sql .= "GROUP BY CUSTOMER_TYPE";
$rs = exequery( $connection, $sql );
$key = 1;
$total = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	$c_array[$key]['x'] = gettypename( $row['CUSTOMER_TYPE'] );
	$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, 18, 10, true, "alpha" );
$relp->decorateimg( $charhead, $subhead, $bottomnote, $leftnote, $picname = "" );
$relp->drawbasiccoordinate( $c_array );
$relp->drawreportbar( $c_array, "blue" );
$relp->outimg( );
?>