<?php

include_once( "inc/conn.php" );
include_once( "inc/par.inc.php" );
$query = "SELECT COUNT(*) cnt, u.USER_NAME,c.CUSTOMER_TYPE,c.SCALE,c.PROVINCE FROM customer as c, USER as u WHERE 1 AND u.USER_ID=c.MANAGE_USER ";
$where_str = "";
if ( $_REQUEST['MANAGE_USER'] != "" )
{
	$where_str .= " and c.MANAGE_USER = '".$_REQUEST['MANAGE_USER']."'";
}
if ( $_REQUEST['CUSTOMER_NO'] != "" )
{
	$where_str .= " and c.CUSTOMER_NUMBER like '%".$_REQUEST['CUSTOMER_NO']."%'";
}
if ( 0 < $_REQUEST['DOOR_TYPE'] )
{
	$where_str .= " and c.CUSTOMER_TYPE = '".$_REQUEST['DOOR_TYPE']."'";
}
if ( $_REQUEST['CUSTOMER_NAME'] != "" )
{
	$where_str .= " and c.CUSTOMER_NAME like '%".$_REQUEST['CUSTOMER_NAME']."%'";
}
if ( $_REQUEST['TEL_NO'] != "" )
{
	$where_str .= " and c.TEL_NO like '%".$_REQUEST['TEL_NO']."%'";
}
if ( $_REQUEST['FAX_NO'] != "" )
{
	$where_str .= " and c.FAX_NO like '%".$_REQUEST['FAX_NO']."%'";
}
if ( $_REQUEST['CUSTOMER_WWW'] != "" )
{
	$where_str .= " and c.CUSTOMER_WWW like '%".$_REQUEST['CUSTOMER_WWW']."%'";
}
if ( $_REQUEST['EMAIL'] != "" )
{
	$where_str .= " and c.EMAIL like '%".$_REQUEST['EMAIL']."%'";
}
if ( $_REQUEST['CUSTOMER_ADD'] != "" )
{
	$where_str .= " and c.CUSTOMER_ADD like '%".$_REQUEST['CUSTOMER_ADD']."%'";
}
if ( $_REQUEST['POSTALCODE'] != "" )
{
	$where_str .= " and c.POSTALCODE like '%".$_REQUEST['POSTALCODE']."%'";
}
if ( $_REQUEST['MEMO'] != "" )
{
	$where_str .= " and c.MEMO like '%".$_REQUEST['MEMO']."%'";
}
$query .= $where_str;
$sql_manage = $query." GROUP BY c.MANAGE_USER";
$rs_manage = exequery( $connection, $sql_manage );
$count_mn = 0;
while ( $row_m = mysql_fetch_array( $rs_manage ) )
{
	$arrayDataMN[$count_mn]['FIELD_NAME'] = $row_m['USER_NAME'];
	$arrayDataMN[$count_mn]['FIELD_VALUE'] = $row_m['cnt'];
	++$count_mn;
}
$sql_c_type = $query." GROUP BY c.CUSTOMER_TYPE";
$rs_c_type = exequery( $connection, $sql_c_type );
$count_ct = 0;
while ( $row_c_type = mysql_fetch_array( $rs_c_type ) )
{
	$fieldname = $par_level_status[$row_c_type['CUSTOMER_TYPE']];
	$arrayDataCT[$count_ct]['FIELD_NAME'] = $fieldname;
	$arrayDataCT[$count_ct]['FIELD_VALUE'] = $row_c_type['cnt'];
	++$count_ct;
}
$sql_c_scale = $query." GROUP BY c.SCALE";
$rs_c_scale = exequery( $connection, $sql_c_scale );
$count_cs = 0;
while ( $row_c_scale = mysql_fetch_array( $rs_c_scale ) )
{
	$fieldname = $par_company_scale[$row_c_scale['SCALE']];
	$arrayDataCS[$count_cs]['FIELD_NAME'] = $fieldname;
	$arrayDataCS[$count_cs]['FIELD_VALUE'] = $row_c_scale['cnt'];
	++$count_cs;
}
$sql_c_area = $query." GROUP BY c.PROVINCE";
$rs_c_area = exequery( $connection, $sql_c_area );
$count_ca = 0;
while ( $row_c_area = mysql_fetch_array( $rs_c_area ) )
{
	$fieldname = $par_area_province[$row_c_area['PROVINCE']];
	$arrayDataCA[$count_ca]['FIELD_NAME'] = $fieldname;
	$arrayDataCA[$count_ca]['FIELD_VALUE'] = $row_c_area['cnt'];
	++$count_ca;
}
?>