Changeset 21527 for branches/version-2_12-dev/data/class/SC_Customer.php
- Timestamp:
- 2012/02/17 02:42:21 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/SC_Customer.php
r21515 r21527 73 73 74 74 $from = <<< __EOS__ 75 ( SELECT NULL AS other_deliv_id, 76 customer_id, 77 name01, name02, 78 kana01, kana02, 79 zip01, zip02, 80 pref, 81 addr01, addr02, 82 email, email_mobile, 83 tel01, tel02, tel03, 84 fax01, fax02, fax03 85 FROM dtb_customer 86 WHERE customer_id = ? 87 UNION ALL 75 ( 76 SELECT NULL AS other_deliv_id, 77 customer_id, 78 name01, name02, 79 kana01, kana02, 80 zip01, zip02, 81 pref, 82 addr01, addr02, 83 email, email_mobile, 84 tel01, tel02, tel03, 85 fax01, fax02, fax03 86 FROM dtb_customer 87 WHERE customer_id = ? 88 UNION ALL 88 89 SELECT other_deliv_id, 89 customer_id,90 name01, name02,91 kana01, kana02,92 zip01, zip02,93 pref,94 addr01, addr02,95 NULL AS email, NULL AS email_mobile,96 tel01, tel02, tel03,97 NULL AS fax01, NULL AS fax02, NULL AS fax0398 FROM dtb_other_deliv99 WHERE customer_id = ?90 customer_id, 91 name01, name02, 92 kana01, kana02, 93 zip01, zip02, 94 pref, 95 addr01, addr02, 96 NULL AS email, NULL AS email_mobile, 97 tel01, tel02, tel03, 98 NULL AS fax01, NULL AS fax02, NULL AS fax03 99 FROM dtb_other_deliv 100 WHERE customer_id = ? 100 101 ) AS addrs 101 102 __EOS__;
Note: See TracChangeset
for help on using the changeset viewer.
