Changeset 17568
- Timestamp:
- 2008/08/28 09:33:38 (16 years ago)
- Location:
- branches/comu-ver2/data/class
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/SC_CustomerList.php
r17425 r17568 392 392 dtb_customer.tel03, 393 393 dtb_customer.pref, 394 dtb_customer.create_date, 394 395 dtb_customer.mailmaga_flg"; 395 396 -
branches/comu-ver2/data/class/SC_SendMail.php
r17484 r17568 112 112 function setSubject($subject) { 113 113 $this->subject = mb_encode_mimeheader($subject, "JIS", 'B', "\n"); 114 $this->subject = str_replace("\x0D\x0A", "\n", $this->subject); 115 $this->subject = str_replace("\x0D", "\n", $this->subject); 116 $this->subject = str_replace("\x0A", "\n", $this->subject); 114 117 } 115 118 -
branches/comu-ver2/data/class/helper/SC_Helper_CSV.php
r17294 r17568 236 236 switch($key) { 237 237 case 'order_pref': 238 case 'deliv_pref': 238 239 $tmp = $this->arrPref[$val]; 239 240 break; -
branches/comu-ver2/data/class/pages/admin/customer/LC_Page_Admin_Customer.php
r17369 r17568 310 310 //- 都道府県/職業の変換 311 311 for($i = 0; $i < count($this->search_data); $i ++) { 312 $this->search_data[$i]["pref"] = $ arrPref[ $this->search_data[$i]["pref"] ];313 $this->search_data[$i]["job"] = $ arrJob[ $this->search_data[$i]["job"] ];312 $this->search_data[$i]["pref"] = $this->arrPref[ $this->search_data[$i]["pref"] ]; 313 $this->search_data[$i]["job"] = $this->arrJob[ $this->search_data[$i]["job"] ]; 314 314 } 315 315 -
branches/comu-ver2/data/class/pages/admin/total/LC_Page_Admin_Total.php
- Property svn:mime-type set to text/x-httpd-php; charset=UTF-8
r17546 r17568 638 638 639 639 // 会員集計の取得 640 $col = "COUNT(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average, order_sex";640 $col = "COUNT(*) AS order_count, SUM(total) AS total, trunc(AVG(total)) AS total_average, order_sex"; 641 641 $from = "dtb_order"; 642 642 $objQuery = new SC_Query(); … … 704 704 /** 職業別集計 **/ 705 705 function lfGetOrderJob($type, $sdate, $edate, &$objPage, $graph = true) { 706 global $arrJob;707 708 706 list($where, $arrval) = $this->lfGetWhereMember('T2.create_date', $sdate, $edate, $type); 709 707 710 $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average ";708 $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, trunc(AVG(total)) AS total_average "; 711 709 $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 and T2.status <> " . ORDER_CANCEL; 712 710 $sql.= " GROUP BY job ORDER BY total DESC"; -
branches/comu-ver2/data/class/pages/frontparts/LC_Page_FrontParts_LoginCheck.php
r17137 r17568 91 91 if(count($arrErr) == 0) { 92 92 if($objCustomer->getCustomerDataFromEmailPass($arrForm['login_pass'], $arrForm['login_email'], true)) { 93 $this->sendRedirect($this->getLocation( $_POST['url'], array(), false));93 $this->sendRedirect($this->getLocation(URL_DIR, array(), false)); 94 94 exit; 95 95 } else { … … 119 119 $this->sendRedirect($this->getLocation(URL_DIR . "mypage/login.php", array(), false)); 120 120 }else{ 121 $this->sendRedirect($this->getLocation( $_POST['url'], array(), false));121 $this->sendRedirect($this->getLocation(URL_DIR, array(), false)); 122 122 } 123 123 exit;
Note: See TracChangeset
for help on using the changeset viewer.