/** 会員別集計 **/
public function lfGetOrderMember($type, $sdate, $edate)
{
if (DB_TYPE != 'sqlsrv') {
return parent::lfGetOrderMember($type, $sdate, $edate);
}
$objQuery = SC_Query_Ex::getSingletonInstance();
list($where, $arrWhereVal) = $this->lfGetWhereMember('create_date', $sdate, $edate, $type);
$where .= ' AND del_flg = 0 AND status <> ?';
$arrWhereVal[] = ORDER_CANCEL;
// 会員集計の取得
$col = <<<__EOS__
COUNT(order_id) AS order_count,
SUM(total) AS total,
AVG(total) AS total_average,
member,
order_sex
__EOS__;
$from = '(
SELECT order_id,total,order_sex,create_date,del_flg,status,customer_id,
CASE
WHEN customer_id <> 0 THEN 1
ELSE 0
END AS member
FROM dtb_order
) as t1';
$objQuery->setGroupBy('member, order_sex');
$arrTotalResults = $objQuery->select($col, $from, $where, $arrWhereVal);
foreach ($arrTotalResults as $key => $value) {
$arrResult =& $arrTotalResults[$key];
$member_key = $arrResult['order_sex'];
if ($member_key != '') {
$arrResult['member_name'] = ($arrResult['member'] ? '会員' : '非会員') . $this->arrSex[$member_key];
} else {
$arrResult['member_name'] = '未回答';
}
}
$tpl_image = $this->lfGetGraphPie($arrTotalResults, 'member_name', 'member', '(売上比率)', $sdate, $edate);
return array($arrTotalResults, $tpl_image);
}
