Ecshop本身源碼寫得就有問題。打開order_status.php文件，翻到最下方，看function get_orderinfo($start_date, $end_date)的定義，其中所有的sql都用了下面的代碼：

function get_orderinfo($start_date, $end_date)

{

$order_info = array();

/* 未確認訂單數 */

$sql = 'SELECT COUNT(*) AS unconfirmed_num FROM ' .$GLOBALS['ecs']->table('order_info').

" WHERE order_status = '" .OS_UNCONFIRMED. "' AND add_time >= '$start_date'".

" AND add_time < '" . ($end_date + 86400) . "'";

很顯然，這里有個很明顯的邏輯錯誤，即$end_date+86400，除非這里用戶選擇的開始時間和結束時間是同一天，否則沒有必要加上86400(86400秒等于1天)，這個錯誤結果會導致最后的訂單統計數量已經不是在指定時間段內的數據，而是指定的時間后再加上一天。

將無用的已確認訂單統計代碼改成已支付的統計代碼：

/* 已確認訂單數 */

$sql = 'SELECT COUNT(*) AS confirmed_num FROM ' .$GLOBALS['ecs']->table('order_info').

" WHERE order_status = '" .OS_CONFIRMED. "' AND shipping_status NOT ". db_create_in(array(SS_SHIPPED, SS_RECEIVED)) . " AND pay_status NOT" . db_create_in(array(PS_PAYED, PS_PAYING)) ." AND add_time >= '$start_date'".

" AND add_time < '" . ($end_date + 86400) . "'";

$order_info['confirmed_num'] = $GLOBALS['db']->getOne($sql);

改成：

/* by zuimoban.com 已支付訂單數 */

$sql = 'SELECT COUNT(*) AS confirmed_num FROM ' .$GLOBALS['ecs']->table('order_info').

" WHERE pay_status =" . PS_PAYED ." AND shipping_status NOT" . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) ." AND add_time >= '$start_date'".

" AND add_time < $end_date";

$order_info['confirmed_num'] = $GLOBALS['db']->getOne($sql);

以上就是本文章的內容，希望對大家有所幫助