Changeset 22065 for branches/version-2_12-dev/data/class/SC_Customer.php
- Timestamp:
- 2012/11/02 19:27:41 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/SC_Customer.php
r22062 r22065 55 55 } 56 56 return false; 57 }58 59 /**60 * 会員の登録住所を取得する.61 *62 * 配列の1番目に会員登録住所, 追加登録住所が存在する場合は2番目以降に63 * 設定される.64 *65 * @param integer $customer_id 会員ID66 * @return array 会員登録住所, 追加登録住所の配列67 */68 function getCustomerAddress($customer_id) {69 $objQuery =& SC_Query_Ex::getSingletonInstance();70 71 $from = <<< __EOS__72 (73 SELECT NULL AS other_deliv_id,74 customer_id,75 name01, name02,76 kana01, kana02,77 zip01, zip02,78 pref,79 addr01, addr02,80 email, email_mobile,81 tel01, tel02, tel03,82 fax01, fax02, fax0383 FROM dtb_customer84 WHERE customer_id = ?85 UNION ALL86 SELECT other_deliv_id,87 customer_id,88 name01, name02,89 kana01, kana02,90 zip01, zip02,91 pref,92 addr01, addr02,93 NULL AS email, NULL AS email_mobile,94 tel01, tel02, tel03,95 NULL AS fax01, NULL AS fax02, NULL AS fax0396 FROM dtb_other_deliv97 WHERE customer_id = ?98 ) AS addrs99 __EOS__;100 $objQuery->setOrder('other_deliv_id IS NULL DESC, other_deliv_id DESC');101 return $objQuery->select('*', $from, '', array($customer_id, $customer_id));102 57 } 103 58
Note: See TracChangeset
for help on using the changeset viewer.