Changeset 23512
- Timestamp:
- 2014/06/03 15:41:15 (12 years ago)
- Location:
- branches/version-2_13-dev/data/class
- Files:
-
- 2 edited
-
SC_Customer.php (modified) (1 diff)
-
pages/admin/total/LC_Page_Admin_Total.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/SC_Customer.php
r23503 r23512 291 291 { 292 292 $objQuery =& SC_Query_Ex::getSingletonInstance(); 293 $arrOrderSummary = $objQuery->getRow('SUM( payment_total) as buy_total, COUNT(order_id) as buy_times,MAX( create_date) as last_buy_date, MIN(create_date) as first_buy_date','dtb_order','customer_id = ? AND del_flg = 0 AND status <> ?', array($customer_id, ORDER_CANCEL));293 $arrOrderSummary = $objQuery->getRow('SUM( payment_total) as buy_total, COUNT(order_id) as buy_times,MAX( create_date) as last_buy_date, MIN(create_date) as first_buy_date','dtb_order','customer_id = ? AND del_flg = 0 AND status <> ?', array($customer_id, ORDER_CANCEL)); 294 294 $objQuery->update('dtb_customer', $arrOrderSummary, 'customer_id = ?', array($customer_id)); 295 295 } -
branches/version-2_13-dev/data/class/pages/admin/total/LC_Page_Admin_Total.php
r23503 r23512 439 439 { 440 440 if ($_POST['search_startyear_m'] != '') { 441 $pngname = sprintf('%s_%02d%02d.png', $keyname, substr($_POST['search_startyear_m'], 2), $_POST['search_startmonth_m']);441 $pngname = sprintf('%s_%02d%02d.png', $keyname, substr($_POST['search_startyear_m'], 2), $_POST['search_startmonth_m']); 442 442 } else { 443 $pngname = sprintf('%s_%02d%02d%02d_%02d%02d%02d.png', $keyname, substr($_POST['search_startyear'], 2), $_POST['search_startmonth'], $_POST['search_startday'], substr($_POST['search_endyear'], 2), $_POST['search_endmonth'], $_POST['search_endday']);443 $pngname = sprintf('%s_%02d%02d%02d_%02d%02d%02d.png', $keyname, substr($_POST['search_startyear'], 2), $_POST['search_startmonth'], $_POST['search_startday'], substr($_POST['search_endyear'], 2), $_POST['search_endmonth'], $_POST['search_endday']); 444 444 } 445 445 … … 463 463 $where.= ' AND '; 464 464 } 465 $edate = date('Y/m/d', strtotime('1 day', strtotime($edate)));465 $edate = date('Y/m/d', strtotime('1 day', strtotime($edate))); 466 466 $where.= " $col_date < date('" . $edate ."')"; 467 467 }
Note: See TracChangeset
for help on using the changeset viewer.
