Changeset 18770 for branches/version-2_5-dev/data/class/SC_Customer.php
- Timestamp:
- 2010/08/03 14:06:25 (14 years ago)
- bzr:base-revision:
- ohkouchi@loop-az.jp-20100803024346-cpwzialqa7f40fo9
- bzr:committer:
- Kentaro Ohkouchi <ohkouchi@loop-az.jp>
- bzr:file-ids:
data/class/SC_Customer.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Customer.php
data/class/helper/SC_Helper_Mobile.php 15277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_Mobile.php
data/class/pages/LC_Page_Sitemap.php 16385@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2FLC_Page_Sitemap.php
data/class/pages/admin/contents/LC_Page_Admin_Contents.php 15659@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php 16449@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_CsvSql.php
data/class/pages/admin/design/LC_Page_Admin_Design.php 15680@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design.php
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php 15687@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_Bloc.php
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php 15682@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_MainEdit.php
data/class/pages/admin/mail/LC_Page_Admin_Mail_Sendmail.php 16321@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail_Sendmail.php
data/class/pages/admin/system/LC_Page_Admin_System_Rank.php 16829@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fsystem%2FLC_Page_Admin_System_Rank.php
data/class/pages/entry/LC_Page_Entry.php 15141@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fentry%2FLC_Page_Entry.php
data/class/pages/mypage/LC_Page_Mypage_Change.php 16070@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Change.php
data/class/pages/mypage/LC_Page_Mypage_Favorite.php 17162@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Favorite.php
data/class/pages/products/LC_Page_Products_Detail.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_Detail.php- bzr:mapping-version:
- v4
- bzr:repository-uuid:
- 1e3b908f-19a9-db11-a64c-001125224ba8
- bzr:revision-id:
- ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
- bzr:revno:
- 2253
- bzr:revprop:branch-nick:
- branches/version-2_5-dev
- bzr:root:
- branches/version-2_5-dev
- bzr:text-parents:
data/class/SC_Customer.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/helper/SC_Helper_Mobile.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/LC_Page_Sitemap.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/contents/LC_Page_Admin_Contents.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/design/LC_Page_Admin_Design.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/mail/LC_Page_Admin_Mail_Sendmail.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/system/LC_Page_Admin_System_Rank.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/entry/LC_Page_Entry.php ohkouchi@loop-az.jp-20100623032937-dhwktuevjyk0jv13
data/class/pages/mypage/LC_Page_Mypage_Change.php ohkouchi@loop-az.jp-20100623032937-dhwktuevjyk0jv13
data/class/pages/mypage/LC_Page_Mypage_Favorite.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/products/LC_Page_Products_Detail.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m- bzr:timestamp:
- 2010-08-03 14:06:21.516999960 +0900
- bzr:user-agent:
- bzr2.1.2+bzr-svn1.0.2
- svn:original-date:
- 2010-08-03T05:06:21.517000Z
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/SC_Customer.php
r18701 r18770 27 27 class SC_Customer { 28 28 29 var $conn;30 var $email;31 29 var $customer_data; // 会員情報 32 30 33 function SC_Customer( $conn = '', $email = '', $pass = '' ) { 34 // セッション開始 35 /* startSessionから移動 2005/11/04 中川 */ 36 SC_Utils_Ex::sfDomainSessionStart(); 37 38 // DB接続オブジェクト生成 39 $DB_class_name = "SC_DbConn"; 40 if ( is_object($conn)){ 41 if ( is_a($conn, $DB_class_name)){ 42 // $connが$DB_class_nameのインスタンスである 43 $this->conn = $conn; 44 } 45 } else { 46 if (class_exists($DB_class_name)){ 47 //$DB_class_nameのインスタンスを作成する 48 $this->conn = new SC_DbConn(); 49 } 50 } 51 52 if ( is_object($this->conn) ) { 53 // 正常にDBに接続できる 54 if ( $email ){ 55 // emailから顧客情報を取得する 56 // $this->setCustomerDataFromEmail( $email ); 57 } 58 } else { 59 echo "DB接続オブジェクトの生成に失敗しています"; 60 exit; 61 } 62 63 if ( strlen($email) > 0 && strlen($pass) > 0 ){ 64 $this->getCustomerDataFromEmailPass( $email, $pass ); 65 } 31 function SC_Customer() { 66 32 } 67 33 … … 76 42 // 本登録された会員のみ 77 43 $sql = "SELECT * FROM dtb_customer WHERE (email = ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2"; 78 $result = $this->conn->getAll($sql, $arrValues); 44 $objQuery = new SC_Query(); 45 $result = $objQuery->getAll($sql, $arrValues); 79 46 if (empty($result)) { 80 47 return false; … … 110 77 // 携帯端末IDが一致し、本登録された会員を検索する。 111 78 $sql = 'SELECT count(*) FROM dtb_customer WHERE mobile_phone_id = ? AND del_flg = 0 AND status = 2'; 112 $result = $this->conn->getOne($sql, array($_SESSION['mobile']['phone_id'])); 79 $objQuery = new SC_Query(); 80 $result = $objQuery->count("dtb_customer", "mobile_phone_id = ? AND del_flg = 0 AND status = 2", array($_SESSION['mobile']['phone_id'])); 113 81 return $result > 0; 114 82 } … … 134 102 // 携帯端末IDが一致し、本登録された会員を検索する。 135 103 $sql = 'SELECT * FROM dtb_customer WHERE mobile_phone_id = ? AND del_flg = 0 AND status = 2'; 136 @list($data) = $this->conn->getAll($sql, array($_SESSION['mobile']['phone_id'])); 104 $objQuery = new SC_Query(); 105 @list($data) = $objQuery->getAll($sql, array($_SESSION['mobile']['phone_id'])); 137 106 138 107 // パスワードが合っている場合は、顧客情報をcustomer_dataに格納してtrueを返す。 … … 171 140 // 本登録された会員のみ 172 141 $sql = "SELECT * FROM dtb_customer WHERE (email = ? OR email_mobile = ?) AND del_flg = 0 AND status = 2"; 173 $result = $this->conn->getAll($sql, array($email, $email)); 142 $objQuery = new SC_Query(); 143 $result = $objQuery->getAll($sql, array($email, $email)); 174 144 $data = isset($result[0]) ? $result[0] : ""; 175 145 $this->customer_data = $data; … … 181 151 $sql = "SELECT * FROM dtb_customer WHERE customer_id = ? AND del_flg = 0"; 182 152 $customer_id = $this->getValue('customer_id'); 183 $arrRet = $this->conn->getAll($sql, array($customer_id)); 153 $objQuery = new SC_Query(); 154 $arrRet = $objQuery->getAll($sql, array($customer_id)); 184 155 $this->customer_data = isset($arrRet[0]) ? $arrRet[0] : ""; 185 156 $_SESSION['customer'] = $this->customer_data;
Note: See TracChangeset
for help on using the changeset viewer.