array.inc.php

CRM 不仅仅是一个管理名词和管理概念

<?
/**
  *
  * Package Monitor Page
  *
  * OsoonCRM Project
  * Copyright 2003-2004 (c)
  * http://osooncrm.cosoft.org.cn/
  */


//用到的数组

if (_ARRAY_INC_PHP_ != 1):
define(_ARRAY_INC_PHP_, 1);

	//项目关闭
	$array_crm_project_closed = array("0"=>"未关闭","1"=>"关闭");

	//项目结果
	$array_crm_project_successful = array("0"=>"<img src=images/False.gif>","1"=>"<img src=images/True.gif>");

	//性别
	$array_crm_sex = array("0"=>"女","1"=>"男");

	//国家
	$array_crm_country = array("1"=>"中国","2"=>"美国","3"=>"日本","4"=>"韩国","5"=>"加拿大");

	//人员规模
	$array_crm_account_human_scale = array();
	$sql_tmp = "select * from $tbl_crm_account_human_scale";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_account_human_scale[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//客户关系等级
	$array_crm_account_relationship = array();
	$sql_tmp = "select * from $tbl_crm_account_relationship";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_account_relationship[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//客户类别
	$array_crm_account_type = array();
	$sql_tmp = "select * from $tbl_crm_account_type";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_account_type[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//客户行业
	$array_crm_account_industry = array();
	$sql_tmp = "select * from $tbl_crm_account_industry";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_account_industry[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//客户年收入
	$array_crm_account_year_revenue = array();
	$sql_tmp = "select * from $tbl_crm_account_year_revenue";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_account_year_revenue[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//客户企业性质
	$array_crm_corp_kind = array();
	$sql_tmp = "select * from crm_corp_kind";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_corp_kind[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//项目阶段
	$array_crm_jieduan = array();
	$sql_tmp = "select * from $tbl_crm_jieduan";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_jieduan[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//项目状态
	$array_crm_project_state = array();
	$sql_tmp = "select * from $tbl_crm_project_state";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_project_state[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//项目来源
	$array_crm_source = array();
	$sql_tmp = "select * from $tbl_crm_source";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_source[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);
	
	//地域
	$array_crm_area = array();
	$sql_tmp = "select * from $tbl_crm_area";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_area[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);

	//费用大类
	$array_crm_expense_type = array();
	$sql_tmp = "select * from $tbl_crm_expense_type";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_expense_type[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);

	//费用小类
	$array_crm_expense_name = array();
	$sql_tmp = "select * from $tbl_crm_expense_name";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_expense_name[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);

	//用户ID转化为用户名
	$array_crm_id2user = array();
	$sql_tmp = "select uid,name from $tbl_crm_user";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_id2user[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);

	//部门ID转化为部门名
	$array_crm_id2dept = array();
	$sql_tmp = "select departmentid,departmentname from $tbl_crm_department";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_id2dept[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);

	//客户ID转化为客户名
	$array_crm_id2account = array();
	$sql_tmp = "select AccountID,AccountName from $tbl_crm_account";
	$res_tmp = mysql_query($sql_tmp);
	while ($row_tmp=@mysql_fetch_array($res_tmp))
	{
		$array_crm_id2account[$row_tmp[0]] = $row_tmp[1];
	}
	unset($sql_tmp);

endif;
?>