$where = $where0 . "user_code='{$user_code}'"; } else { $where = $where0 . "user_code='{$user_code}' AND order_status={$status}"; } if ($stardate && $enddate) { $stardate = (int) strtotime($stardate); $enddate = (int) strtotime($enddate); $enddate = date('Y-m-d 23:59:59', $enddate); $enddate = (int) strtotime($enddate); if ($enddate > 0 && $stardate > 0 && $enddate >= $stardate) { $where = $where0 . "user_code='{$user_code}' AND create_time>={$stardate} AND create_time<={$enddate}"; } } if (!$keyword) { //DB::Debug(); $order = Orders::paging($page, $page_size, $where, "id DESC", "*"); } else { if ('bh' == $keyword) { //DB::Debug(); $ordertable = Orders::table(); $orderproducttable = OrdersProducts::table(); $sql = " SELECT a.* FROM {$ordertable} AS a, {$orderproducttable} AS b WHERE RIGHT(a.order_code,2)='BH' AND a.order_code=b.order_code AND a.user_code='{$user_code}' ORDER BY a.id DESC"; $order = Paging::bySQL($sql, $page, $page_size, 'a'); } else { //DB::Debug(); $ordertable = Orders::table(); $orderproducttable = OrdersProducts::table(); $sql = " SELECT a.* FROM {$ordertable} AS a, {$orderproducttable} AS b WHERE (RIGHT(a.order_code,2)='SK' OR LEFT(a.order_code,4)='FXAD') AND a.order_code=b.order_code AND a.user_code='{$user_code}' AND (a.order_code LIKE '%{$keyword}%' OR b.product_sku LIKE '%{$keyword}%') GROUP BY a.order_code ORDER BY a.id DESC"; $order = Paging::bySQL($sql, $page, $page_size, 'a'); } }