Changeset 20507 for branches/version-2_5-dev/data/class/SC_Customer.php
- Timestamp:
- 2011/03/04 23:24:33 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/SC_Customer.php
r20495 r20507 42 42 // 本登録された会員のみ 43 43 $sql = "SELECT * FROM dtb_customer WHERE (email = ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2"; 44 $objQuery = new SC_Query ();44 $objQuery = new SC_Query_Ex(); 45 45 $result = $objQuery->getAll($sql, $arrValues); 46 46 if (empty($result)) { … … 69 69 */ 70 70 function getCustomerAddress($customer_id) { 71 $objQuery =& SC_Query ::getSingletonInstance();71 $objQuery =& SC_Query_Ex::getSingletonInstance(); 72 72 73 73 $from = <<< __EOS__ … … 121 121 // 携帯端末IDが一致し、本登録された会員を検索する。 122 122 $sql = 'SELECT count(*) FROM dtb_customer WHERE mobile_phone_id = ? AND del_flg = 0 AND status = 2'; 123 $objQuery = new SC_Query ();123 $objQuery = new SC_Query_Ex(); 124 124 $result = $objQuery->count("dtb_customer", "mobile_phone_id = ? AND del_flg = 0 AND status = 2", array($_SESSION['mobile']['phone_id'])); 125 125 return $result > 0; … … 146 146 // 携帯端末IDが一致し、本登録された会員を検索する。 147 147 $sql = 'SELECT * FROM dtb_customer WHERE mobile_phone_id = ? AND del_flg = 0 AND status = 2'; 148 $objQuery = new SC_Query ();148 $objQuery = new SC_Query_Ex(); 149 149 @list($data) = $objQuery->getAll($sql, array($_SESSION['mobile']['phone_id'])); 150 150 … … 172 172 } 173 173 174 $objQuery = new SC_Query ;174 $objQuery = new SC_Query_Ex(); 175 175 $sqlval = array('mobile_phone_id' => $_SESSION['mobile']['phone_id']); 176 176 $where = 'customer_id = ? AND del_flg = 0 AND status = 2'; … … 184 184 // 本登録された会員のみ 185 185 $sql = "SELECT * FROM dtb_customer WHERE (email = ? OR email_mobile = ?) AND del_flg = 0 AND status = 2"; 186 $objQuery = new SC_Query ();186 $objQuery = new SC_Query_Ex(); 187 187 $result = $objQuery->getAll($sql, array($email, $email)); 188 188 $data = isset($result[0]) ? $result[0] : ""; … … 195 195 $sql = "SELECT * FROM dtb_customer WHERE customer_id = ? AND del_flg = 0"; 196 196 $customer_id = $this->getValue('customer_id'); 197 $objQuery = new SC_Query ();197 $objQuery = new SC_Query_Ex(); 198 198 $arrRet = $objQuery->getAll($sql, array($customer_id)); 199 199 $this->customer_data = isset($arrRet[0]) ? $arrRet[0] : ""; … … 226 226 && SC_Utils_Ex::sfIsInt($_SESSION['customer']['customer_id'])) { 227 227 228 $objQuery = new SC_Query ();228 $objQuery = new SC_Query_Ex(); 229 229 $email = $objQuery->get("email", "dtb_customer", "customer_id = ?", array($_SESSION['customer']['customer_id'])); 230 230 if($email == $_SESSION['customer']['email']) {
Note: See TracChangeset
for help on using the changeset viewer.