function lfGetWhereMember($col_date, $sdate, $edate, $type, $col_member = "customer_id")
{
if (DB_TYPE != 'sqlsrv') {
return parent::lfGetWhereMember($col_date, $sdate, $edate, $type, $col_member);
} else {
$where = "";
// 取得日付の指定
if ($sdate != "") {
if ($where != "") {
$where .= " AND ";
}
$where .= " {$col_date} >= '" . $sdate . "'";
}
if ($edate != "") {
if ($where != "") {
$where .= " AND ";
}
$edate = date("Y/m/d", strtotime("1 day", strtotime($edate)));
$where .= " {$col_date} < '" . $edate . "'";
}
// 会員、非会員の判定
switch ($type) {
// 全体
case 'all':
break;
case 'member':
if ($where != "") {
$where .= " AND ";
}
$where .= " {$col_member} <> 0";
break;
case 'nonmember':
if ($where != "") {
$where .= " AND ";
}
$where .= " {$col_member} = 0";
break;
default:
break;
}
return array($where, array());
}
}
