<?php

#---------------------------------------------#
#             		各条件内クライアント数
#---------------------------------------------#
//$ST=SQL条件配列（ and ... ）
function  Shop_ASU($ST,$CONT_TABLE='',$CONT_QUERY_WHERE='') {

	if($CONT_TABLE=='') global $CONT_TABLE,$CONT_QUERY_WHERE;

	//case条件件数cell
	$p=0;$i=0;$ASU=array();
	foreach($ST as $key => $value){
		$CONT_QUERY_CELL.="sum(CASE WHEN (".$value.") THEN 1 ELSE 0 END) as V".$i." ";
		++$i;
		if(sizeof($ST)!=$i) $CONT_QUERY_CELL.=",";
	}
	$query="select ".$CONT_QUERY_CELL." from ".$CONT_TABLE." where ".$CONT_QUERY_WHERE;
	$GASU=loadsqldata($query,0,1);
	if($GASU[0]) foreach($GASU[0] as $key => $value){ $ASU[$p]=$value;$p++; };

	return $ASU;
}

#---------------------------------------------#
#             		各条件内コンパニオン数
#---------------------------------------------#
//$ST=SQL条件配列（ and ... ）
function  Girls_ASU($ST) {

	global $MEM_TABLE,$MEM_QUERY_WHERE;

	//case条件件数cell
	$p=0;$i=0;$ASU=array();
	foreach($ST as $key => $value){
		$MEM_QUERY_CELL.="sum(CASE WHEN (".$value.") THEN 1 ELSE 0 END) as V".$i." ";
		++$i;
		if(sizeof($ST)!=$i) $MEM_QUERY_CELL.=",";
	}
	$query="select ".$MEM_QUERY_CELL." from ".$MEM_TABLE." where ".$MEM_QUERY_WHERE;
	$GASU=loadsqldata($query,0,1);if(!$GASU[0]) $GASU[0]=array();
	foreach($GASU[0] as $key => $value){ $ASU[$p]=$value;$p++; };

	return $ASU;
}

#---------------------------------------------#
#             		その他条件内件数
#---------------------------------------------#
//$ST=SQL条件配列（ and ... ）
function  Cont_ASU($ST) {

	global $CONT_TABLE,$CONT_QUERY_WHERE;

	//case条件件数cell
	$p=0;$i=0;$ASU=array();
	foreach($ST as $key => $value){
		$CONT_QUERY_CELL.="sum(CASE WHEN (".$value.") THEN 1 ELSE 0 END) as V".$i." ";
		++$i;
		if(sizeof($ST)!=$i) $CONT_QUERY_CELL.=",";
	}
	$query="select ".$CONT_QUERY_CELL." from ".$CONT_TABLE." where ".$CONT_QUERY_WHERE;
	$GASU=loadsqldata($query,0,1);
	if($GASU[0]) foreach($GASU[0] as $key => $value){ $ASU[$p]=$value;$p++; };

	return $ASU;
}

?>