Changeset 11611 for branches/dev/data
- Timestamp:
- 2007/03/08 15:59:54 (20 years ago)
- Location:
- branches/dev/data
- Files:
-
- 2 edited
-
class/SC_CustomerList.php (modified) (2 diffs)
-
lib/slib.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/data/class/SC_CustomerList.php
r11577 r11611 67 67 */ 68 68 // ÅÐÏ¿Æü¤ò¼¨¤¹¥«¥é¥à 69 $regdate_col = 'dtb_customer _mail.create_date';69 $regdate_col = 'dtb_customer.create_date'; 70 70 } 71 71 … … 301 301 } 302 302 303 function getListMailMagazineCount() {304 $this->select = "SELECT COUNT(*) FROM dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";305 return $this->getSql(0);306 }307 //¹ØÆþ¾¦ÉÊ¥³¡¼¥É¸¡º÷ÍÑSQL308 function getBuyList(){309 $this->select = "SELECT A.customer_id, A.name01, A.name02, A.kana01, A.kana02, A.sex, A.email, A.tel01, A.tel02, A.tel03, A.pref, A.mailmaga_flg, B.order_email, B.order_id, C.product_code310 FROM (dtb_customer LEFT OUTER JOIN dtb_customer_mail USING (email)) AS A LEFT OUTER JOIN dtb_order AS B ON311 A.email=B.order_email LEFT OUTER JOIN dtb_order_detail AS C ON B.order_id = C.order_id";312 }313 314 303 //¡¡¸¡º÷Áí¿ô¥«¥¦¥ó¥ÈÍÑSQL 315 304 function getListCount() { -
branches/dev/data/lib/slib.php
r11583 r11611 2283 2283 $arrRegist["update_date"] = "NOW()"; 2284 2284 2285 $sqlval["create_date"] = "NOW()";2286 $sqlval["update_date"] = "NOW()";2287 $sqlval['email'] = $array['email'];2288 $sqlval['mail_flag'] = $array['mail_flag'];2289 2285 //-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô 2290 2286 $objQuery->begin(); 2291 2287 $objQuery->update("dtb_customer", $arrRegist, "customer_id = ? ", array($array['customer_id'])); 2292 $objQuery->delete("dtb_customer_mail", "email = ?", array($array['email']));2293 $objQuery->insert("dtb_customer_mail", $sqlval);2294 2288 $objQuery->commit(); 2295 2289 }
Note: See TracChangeset
for help on using the changeset viewer.
