function lfGetOrderTerm($type, $sdate, $edate)
{
if (DB_TYPE != 'sqlsrv') {
return parent::lfGetOrderTerm($type, $sdate, $edate);
} else {
$objQuery = SC_Query_Ex::getSingletonInstance();
list($where, $arrval) = $this->lfGetWhereMember('create_date', $sdate, $edate);
$where .= " AND del_flg = 0 AND status <> " . ORDER_CANCEL;
switch ($type) {
case 'month':
$xtitle = "(月別)";
$ytitle = "(売上合計)";
$format = '%m';
break;
case 'year':
$xtitle = "(年別)";
$ytitle = "(売上合計)";
$format = '%Y';
break;
case 'wday':
$xtitle = "(曜日別)";
$ytitle = "(売上合計)";
$format = '%a';
break;
case 'hour':
$xtitle = "(時間別)";
$ytitle = "(売上合計)";
$format = '%H';
break;
default:
$xtitle = "(日別)";
$ytitle = "(売上合計)";
$format = '%Y-%m-%d';
break;
}
// TODO リファクタリング
switch ($type) {
case 'month':
$format = 'datepart(mm, create_date)';
break;
case 'year':
$format = 'datepart(yyyy, create_date)';
break;
case 'wday':
$format = 'datename(weekday, create_date)';
break;
case 'hour':
$format = 'datepart(hh, create_date)';
break;
default:
$format = 'convert(varchar(10), create_date, 111)';
break;
}
$dbFactory = SC_DB_DBFactory_Ex::getInstance();
// todo postgres
$col = $dbFactory->getOrderTotalDaysWhereSql($format);
$objQuery->setGroupBy($format);
$objQuery->setOrder($format);
// 検索結果の取得
$arrTotalResults = $objQuery->select($col, 'dtb_order', $where);
$arrTotalResults = $this->lfAddBlankLine($arrTotalResults, $type, $sdate, $edate);
// todo GDない場合の処理
$tpl_image = $this->lfGetGraphLine($arrTotalResults, 'str_date', "term_" . $type, $xtitle, $ytitle, $sdate, $edate);
$arrTotalResults = $this->lfAddTotalLine($arrTotalResults);
return array($arrTotalResults, $tpl_image);
}
}
