/**
* getInstanceメソッド
*
* このクラスのオブジェクトを生成する。
* 既に生成されていたら、前回と同じものを返す。
*
* @return object $instance
*/
public static function getInstance()
{
if (!self::$_instance) {
self::$_instance = new self();
}
return self::$_instance;
}
/**
* salesReportDayGraph.php
*
* Copyright (c) 2009 Fraise, Inc.
* All rights reserved.
*/
/**
* 管理画面売り上げ集計(曜日ごと)リストグラフページ処理ファイル。
*
* @copyright 2009 Fraise, Inc.
* @author mitsuhiro nakamura
*/
require_once D_BASE_DIR . "/common/admin_common.php";
$param = $requestOBJ->getParameterExcept($exceptArray);
$AdmCalculationOBJ = AdmCalculation::getInstance();
// 売り上げ総金額
$columnArray = "";
$whereArray = "";
$otherArray = "";
$columnArray[] = "p.pay_type";
$columnArray[] = "SUM(p.receive_money) AS pay_total";
$columnArray[] = "CAST(p.create_datetime AS DATE) AS payment_date";
$whereArray[] = "o.disable = 0";
$whereArray[] = "o.is_paid = 1";
$whereArray[] = "o.is_cancel = 0";
$whereArray[] = "o.status IN (" . AdmOrdering::ORDERING_STATUS_PRE_COMPLETE . ", " . AdmOrdering::ORDERING_STATUS_COMPLETE . ", " . AdmOrdering::ORDERING_STATUS_REST . ")";
$otherArray[] = "GROUP BY payment_date, o.id ORDER BY payment_date";
if (ComValidation::isDate($param["date"])) {
$whereArray[] = "p.create_datetime >= '" . date("Y-m-01 00:00:00", strtotime($param["date"])) . "'";
$whereArray[] = "p.create_datetime <= '" . date("Y-m-t 23:59:59", strtotime($param["date"])) . "'";
