Changeset 15642

Timestamp:

2007/09/07 15:24:34 (16 years ago)

Author:

nanasess

Message:

未定義変数の修正

File:

• branches/feature-module-update/data/class/SC_CustomerList.php (modified) (19 diffs)

branches/feature-module-update/data/class/SC_CustomerList.php

@@ -15 +15 @@
     function SC_CustomerList($array, $mode = '') {
         parent::SC_SelectSql($array);
+        $objDb = new SC_Helper_DB_Ex();
 
         if($mode == "") {
@@ -71 +72 @@
 
         // 顧客ID
+        if (!isset($this->arrSql['customer_id'])) $this->arrSql['customer_id'] = "";
         if ( strlen($this->arrSql['customer_id']) > 0 ) {
             $this->setWhere( "customer_id =  ?" );
@@ -77 +79 @@
 
         // 名前
+        if (!isset($this->arrSql['name'])) $this->arrSql['name'] = "";
         if ( strlen($this->arrSql['name']) > 0 ) {
             if(DB_TYPE == "pgsql"){
@@ -89 +92 @@
 
         //　名前（カナ）
+        if (!isset($this->arrSql['kana'])) $this->arrSql['kana'] = "";
         if ( strlen($this->arrSql['kana']) > 0 ) {
             if(DB_TYPE == "pgsql"){
@@ -100 +104 @@
 
         //　都道府県
+        if (!isset($this->arrSql['pref'])) $this->arrSql['pref'] = "";
         if ( strlen($this->arrSql['pref']) > 0 ) {
             $this->setWhere( "pref = ?" );
@@ -106 +111 @@
 
         //　電話番号
+        if (!isset($this->arrSql['tel'])) $this->arrSql['tel'] = "";
         if ( is_numeric( $this->arrSql['tel'] ) ) {
             if(DB_TYPE == "pgsql"){
@@ -141 +147 @@
 
         //　E-MAIL
+        if (!isset($this->arrSql['email'])) $this->arrSql['email'] = "";
         if (strlen($this->arrSql['email']) > 0) {
             //カンマ区切りで複数の条件指定可能に
@@ -168 +175 @@
 
         //　E-MAIL(mobile)
+        if (!isset($this->arrSql['email_mobile'])) $this->arrSql['email_mobile'] = "";
         if (strlen($this->arrSql['email_mobile']) > 0) {
             //カンマ区切りで複数の条件指定可能に
@@ -196 +204 @@
         //　配信メールアドレス種別
         if ( $mode == 'magazine' ){
+            if (!isset($this->arrSql['mail_type'])) $this->arrSql['mail_type'] = "";
             if ( strlen($this->arrSql['mail_type']) > 0 && $this->arrSql['mail_type'] == 2) {
                 $this->setWhere( " dtb_customer.email_mobile <> ''  ");
@@ -203 +212 @@
         //　HTML-mail
         if ( $mode == 'magazine' ){
+            if (!isset($this->arrSql['htmlmail'])) $this->arrSql['htmlmail'] = "";
             if ( strlen($this->arrSql['htmlmail']) > 0 ) {
                 $this->setWhere( " mailmaga_flg = ? ");
@@ -212 +222 @@
 
         // 購入金額指定
+        if (!isset($this->arrSql['buy_total_from'])) $this->arrSql['buy_total_from'] = "";
+        if (!isset($this->arrSql['buy_total_to'])) $this->arrSql['buy_total_to'] = "";
         if( is_numeric( $this->arrSql["buy_total_from"] ) || is_numeric( $this->arrSql["buy_total_to"] ) ) {
             $arrBuyTotal = $this->selectRange($this->arrSql["buy_total_from"], $this->arrSql["buy_total_to"], "buy_total");
@@ -220 +232 @@
 
         // 購入回数指定
+        if (!isset($this->arrSql['buy_times_from'])) $this->arrSql['buy_times_from'] = "";
+        if (!isset($this->arrSql['buy_times_to'])) $this->arrSql['buy_times_to'] = "";
         if( is_numeric( $this->arrSql["buy_times_from"] ) || is_numeric( $this->arrSql["buy_times_to"] ) ) {
             $arrBuyTimes = $this->selectRange($this->arrSql["buy_times_from"], $this->arrSql["buy_times_to"], "buy_times");
@@ -228 +242 @@
 
         // 誕生日期間指定
+        if (!isset($this->arrSql['b_start_year'])) $this->arrSql['b_start_year'] = "";
+        if (!isset($this->arrSql['b_start_month'])) $this->arrSql['b_start_month'] = "";
+        if (!isset($this->arrSql['b_start_day'])) $this->arrSql['b_start_day'] = "";
+        if (!isset($this->arrSql['b_end_year'])) $this->arrSql['b_end_year'] = "";
+        if (!isset($this->arrSql['b_end_month'])) $this->arrSql['b_end_month'] = "";
+        if (!isset($this->arrSql['b_end_day'])) $this->arrSql['b_end_day'] = "";
         if ( (strlen($this->arrSql['b_start_year']) > 0 && strlen($this->arrSql['b_start_month']) > 0 && strlen($this->arrSql['b_start_day']) > 0) ||
               strlen($this->arrSql['b_end_year']) > 0 && strlen($this->arrSql['b_end_month']) > 0 && strlen($this->arrSql['b_end_day']) > 0) {
@@ -241 +261 @@
 
         // 誕生月の検索
+        if (!isset($this->arrSql['birth_month'])) $this->arrSql['birth_month'] = "";
         if (is_numeric($this->arrSql["birth_month"])) {
             $this->setWhere(" EXTRACT(month from birth) = ?");
@@ -247 +268 @@
 
         // 登録期間指定
+        if (!isset($this->arrSql['start_year'])) $this->arrSql['start_year'] = "";
+        if (!isset($this->arrSql['start_month'])) $this->arrSql['start_month'] = "";
+        if (!isset($this->arrSql['start_day'])) $this->arrSql['start_day'] = "";
+        if (!isset($this->arrSql['end_year'])) $this->arrSql['end_year'] = "";
+        if (!isset($this->arrSql['end_month'])) $this->arrSql['end_month'] = "";
+        if (!isset($this->arrSql['end_day'])) $this->arrSql['end_day'] = "";
         if ( (strlen($this->arrSql['start_year']) > 0 && strlen($this->arrSql['start_month']) > 0 && strlen($this->arrSql['start_day']) > 0 ) ||
                 (strlen($this->arrSql['end_year']) > 0 && strlen($this->arrSql['end_month']) >0 && strlen($this->arrSql['end_day']) > 0) ) {
@@ -260 +287 @@
 
         // 最終購入日指定
+        if (!isset($this->arrSql['buy_start_year'])) $this->arrSql['buy_start_year'] = "";
+        if (!isset($this->arrSql['buy_start_month'])) $this->arrSql['buy_start_month'] = "";
+        if (!isset($this->arrSql['buy_start_day'])) $this->arrSql['buy_start_day'] = "";
+        if (!isset($this->arrSql['buy_end_year'])) $this->arrSql['buy_end_year'] = "";
+        if (!isset($this->arrSql['buy_end_month'])) $this->arrSql['buy_end_month'] = "";
+        if (!isset($this->arrSql['buy_end_day'])) $this->arrSql['buy_end_day'] = "";
+
         if ( (strlen($this->arrSql['buy_start_year']) > 0 && strlen($this->arrSql['buy_start_month']) > 0 && strlen($this->arrSql['buy_start_day']) > 0 ) ||
                 (strlen($this->arrSql['buy_end_year']) > 0 && strlen($this->arrSql['buy_end_month']) >0 && strlen($this->arrSql['buy_end_day']) > 0) ) {
@@ -272 +306 @@
 
         //購入商品コード
+        if (!isset($this->arrSql['buy_product_code'])) $this->arrSql['buy_product_code'] = "";
         if ( strlen($this->arrSql['buy_product_code']) > 0 ) {
             $this->setWhere( "customer_id IN (SELECT customer_id FROM dtb_order WHERE order_id IN (SELECT order_id FROM dtb_order_detail WHERE product_code LIKE ? ))");
@@ -279 +314 @@
 
         //購入商品名称
+        if (!isset($this->arrSql['buy_product_name'])) $this->arrSql['buy_product_name'] = "";
         if ( strlen($this->arrSql['buy_product_name']) > 0 ) {
             $this->setWhere( "customer_id IN (SELECT customer_id FROM dtb_order WHERE order_id IN (SELECT order_id FROM dtb_order_detail WHERE product_name LIKE ? ))");
@@ -286 +322 @@
 
         //カテゴリーを選択している場合のみ絞込検索を行う
+        if (!isset($this->arrSql['category_id'])) $this->arrSql['category_id'] = "";
         if ( strlen($this->arrSql['category_id']) != ""){
             //カテゴリーで絞込検索を行うSQL文生成
-            list($tmp_where, $tmp_arrval) = sfGetCatWhere(sfManualEscape($this->arrSql['category_id']));
+            list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere(SC_Utils_Ex::sfManualEscape($this->arrSql['category_id']));
 
             //カテゴリーで絞込みが可能の場合