Changeset 17162

Timestamp:

2008/03/17 22:54:44 (16 years ago)

Author:

Yammy

Message:

http://svn.ec-cube.net/open_trac/ticket/254
お気に入り商品登録機能 一式コミット

Location:

branches/comu-ver2

Files:

• data/Smarty/templates/default/detail.tpl (modified) (2 diffs)
• data/Smarty/templates/default/mypage/favorite.tpl (added)
• data/Smarty/templates/default/mypage/navi.tpl (modified) (1 diff)
• data/class/pages/mypage/LC_Page_Mypage_Favorite.php (added)
• data/class/pages/products/LC_Page_Products_Detail.php (modified) (4 diffs)
• data/class_extends/page_extends/mypage/LC_Page_Mypage_Favorite_Ex.php (added)
• data/mtb_constants_init.php (modified) (1 diff)
• html/install/sql/create_table_mysql.sql (modified) (1 diff)
• html/install/sql/create_table_pgsql.sql (modified) (1 diff)
• html/install/sql/insert_data.sql (modified) (1 diff)
• html/mypage/favorite.php (added)

branches/comu-ver2/data/Smarty/templates/default/detail.tpl

@@ -147 +147 @@
         <input type="hidden" name="mode" value="cart" />
         <input type="hidden" name="product_id" value="<!--{$tpl_product_id}-->" />
+        <input type="hidden" name="favorite_product_id" value="" />
         <!--{if $tpl_classcat_find1}-->
         <dl>
@@ -194 +195 @@
         <!--{if $tpl_stock_find}-->
         <p class="btn">
+          <!--{if $smarty.const.OPTION_FAVOFITE_PRODUCT == 1}-->
+            <!--{assign var=add_favorite value="add_favorite`$product_id`"}-->
+            <!--{if $arrErr[$add_favorite]}--><div class="attention"><!--{$arrErr[$add_favorite]}--></div><!--{/if}-->
+            <!--{if !$arrProduct.favorite_count}-->
+            <a href="javascript:fnModeSubmit('add_favorite','favorite_product_id','<!--{$arrProduct.product_id}-->');">[お気に入りに追加]</a><br />
+            <!--{else}-->
+            [お気に入り登録済]<br />
+            <!--{/if}-->
+          <!--{/if}-->
           <!--★カゴに入れる★-->
           <a href="javascript:void(document.form1.submit())" onmouseover="chgImg('<!--{$TPL_DIR}-->img/products/b_cartin_on.gif','cart');" onmouseout="chgImg('<!--{$TPL_DIR}-->img/products/b_cartin.gif','cart');">

branches/comu-ver2/data/Smarty/templates/default/mypage/navi.tpl

@@ -29 +29 @@
     <li><a href="./index.php" onmouseover="chgImg('<!--{$TPL_DIR}-->img/mypage/navi01_on.jpg','m_navi01');" onmouseout="chgImg('<!--{$TPL_DIR}-->img/mypage/navi01.jpg','m_navi01');"><img src="<!--{$TPL_DIR}-->img/mypage/navi01.jpg" width="170" height="30" alt="購入履歴一覧" border="0" name="m_navi01" /></a></li>
   <!--{/if}-->
+  <!--{if $smarty.const.OPTION_FAVOFITE_PRODUCT == 1}-->
+  <!--{if $tpl_mypageno == 'favorite'}-->
+    <li><a href="./favorite.php">お気に入り商品</a></li>
+  <!--{else}-->
+    <li><a href="./favorite.php">お気に入り商品</a></li>
+  <!--{/if}-->
+  <!--{/if}-->
   <!--{if $tpl_mypageno == 'change'}-->
     <li><a href="./change.php"><img src="<!--{$TPL_DIR}-->img/mypage/navi02_on.jpg" width="170" height="30" alt="会員登録内容変更" border="0" name="m_navi02" /></a></li>

branches/comu-ver2/data/class/pages/products/LC_Page_Products_Detail.php

@@ -84 +84 @@
         $helper->sfGetPageLayout($this, false, "products/detail.php");
 
+        if(isset($_POST['mode']) && $_POST['favorite_product_id'] != "" && $_POST['mode'] == "add_favorite") {
+            // 値の正当性チェック
+            if(!SC_Utils_Ex::sfIsInt($_POST['favorite_product_id']) || !$objDb->sfIsRecord("dtb_products", "product_id", $_POST['favorite_product_id'], "del_flg = 0 AND status = 1")) {
+                SC_Utils_Ex::sfDispSiteError(PRODUCT_NOT_FOUND);
+                exit;
+            } else {
+                $this->arrErr = $this->lfCheckError();
+                if(count($this->arrErr) == 0) {
+                    $customer_id = $objCustomer->getValue('customer_id');
+                    $this->lfRegistFavoriteProduct($customer_id, $_POST['favorite_product_id']);
+                }
+            }
+        }
+
         // パラメータ管理クラス
         $this->objFormParam = new SC_FormParam();
@@ -190 +204 @@
         $objQuery = new SC_Query();
         // DBから商品情報を取得する。
-        $arrRet = $objQuery->select("*", "vw_products_allclass_detail AS alldtl", "product_id = ?", array($tmp_id));
+        $arrRet = $objQuery->select("*, (SELECT count(*) FROM dtb_customer_favorite_products WHERE product_id = alldtl.product_id AND customer_id = ?) AS favorite_count", "vw_products_allclass_detail AS alldtl", "product_id = ?", array($objCustomer->getValue('customer_id'), $tmp_id));
         $this->arrProduct = $arrRet[0];
 
@@ -725 +739 @@
     /* 入力内容のチェック */
     function lfCheckError() {
-        // 入力データを渡す。
-        $arrRet =  $this->objFormParam->getHashArray();
-        $objErr = new SC_CheckError($arrRet);
-        $objErr->arrErr = $this->objFormParam->checkError();
-
-        // 複数項目チェック
-        if ($this->tpl_classcat_find1) {
-            $objErr->doFunc(array("規格1", "classcategory_id1"), array("EXIST_CHECK"));
-        }
-        if ($this->tpl_classcat_find2) {
-            $objErr->doFunc(array("規格2", "classcategory_id2"), array("EXIST_CHECK"));
+        if ($_POST['mode'] == "add_favorite") {
+            $objCustomer = new SC_Customer();
+            $objErr = new SC_CheckError();
+            $customer_id = $objCustomer->getValue('customer_id');
+            if (SC_Helper_DB_Ex::sfDataExists('dtb_customer_favorite_products', 'customer_id = ? AND product_id = ?', array($customer_id, $favorite_product_id))) {
+                $objErr->arrErr['add_favorite'.$favorite_product_id] = "※ この商品は既にお気に入りに追加されています。<br />";
+            }
+        } else {
+            // 入力データを渡す。
+            $arrRet =  $this->objFormParam->getHashArray();
+            $objErr = new SC_CheckError($arrRet);
+            $objErr->arrErr = $this->objFormParam->checkError();
+
+            // 複数項目チェック
+            if ($this->tpl_classcat_find1) {
+                $objErr->doFunc(array("規格1", "classcategory_id1"), array("EXIST_CHECK"));
+            }
+            if ($this->tpl_classcat_find2) {
+                $objErr->doFunc(array("規格2", "classcategory_id2"), array("EXIST_CHECK"));
+            }
         }
 
@@ -838 +861 @@
         }
     }
+
+    /*
+     * お気に入り商品登録
+     */
+    function lfRegistFavoriteProduct($customer_id, $product_id) {
+        $objQuery = new SC_Query();
+        $objConn = new SC_DbConn();
+        $count = $objConn->getOne("SELECT COUNT(*) FROM dtb_customer_favorite_products WHERE customer_id = ? AND product_id = ?", array($customer_id, $product_id));
+
+        if ($count == 0) {
+            $sqlval['customer_id'] = $customer_id;
+            $sqlval['product_id'] = $product_id;
+
+            $objQuery->begin();
+            $objQuery->insert('dtb_customer_favorite_products', $sqlval);
+            $objQuery->commit();
+        }
+    }
+
 }
 ?>

branches/comu-ver2/data/mtb_constants_init.php

@@ -679 +679 @@
 /** オーナーズストア通信エラーコード */
 define('OSTORE_E_C_BATCH_ERR', '2010');
+/** お気に入り商品登録(有効:1 無効:0) */
+define('OPTION_FAVOFITE_PRODUCT','1');
 ?>

branches/comu-ver2/html/install/sql/create_table_mysql.sql

@@ -461 +461 @@
     create_date datetime NOT NULL,
     update_date datetime NOT NULL
+) TYPE=InnoDB ;
+
+CREATE TABLE dtb_customer_favorite_products (
+    customer_id int NOT NULL,
+    product_id int NOT NULL,
+    create_date datetime NOT NULL,
+    update_date datetime NOT NULL,
 ) TYPE=InnoDB ;
 

branches/comu-ver2/html/install/sql/create_table_pgsql.sql

@@ -461 +461 @@
     create_date timestamp NOT NULL,
     update_date timestamp NOT NULL DEFAULT NOW()
+);
+
+CREATE TABLE dtb_customer_favorite_products (
+    customer_id int4 NOT NULL,
+    product_id int4 NOT NULL,
+    create_date timestamp NOT NULL DEFAULT now(),
+    update_date timestamp NOT NULL DEFAULT now(),
+    PRIMARY KEY (customer_id, product_id)
 );
 

branches/comu-ver2/html/install/sql/insert_data.sql

@@ -1114 +1114 @@
 INSERT INTO mtb_constants VALUES ('OSTORE_E_C_PERMISSION', '"2009"', 521, 'オーナーズストア通信エラーコード');
 INSERT INTO mtb_constants VALUES ('OSTORE_E_C_BATCH_ERR', '"2010"', 522, 'オーナーズストア通信エラーコード');
+INSERT INTO mtb_constants VALUES ('OPTION_FAVOFITE_PRODUCT','1',523,'お気に入り商品登録(有効:1 無効:0)');
 
 INSERT INTO dtb_module (module_id,module_code,module_name,update_date,create_date)values(0,0,'patch',now(),now());