Changeset 11983 for branches/comu/html/products/detail.php

Timestamp:

2007/03/28 14:59:15 (19 years ago)

Author:

uehara

Message:

 

File:

• branches/comu/html/products/detail.php (modified) (3 diffs)

branches/comu/html/products/detail.php

@@ -158 +158 @@
 
 // ¥µ¥Ö¥¿¥¤¥È¥ë¤ò¼èÆÀ
-$arrFirstCat = GetFirstCat($arrRet[0]['category_id']);
+$arrFirstCat = sfGetFirstCat($arrRet[0]['category_id']);
 $tpl_subtitle = $arrFirstCat['name'];
 $objPage->tpl_subtitle = $tpl_subtitle;
@@ -172 +172 @@
 //¥ì¥Ó¥å¡¼¾ðÊó¤Î¼èÆÀ
 $objPage->arrReview = lfGetReviewData($tmp_id);
+// ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤Î¼èÆÀ
+
+// ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½¤Î²ÔƯ¾õ¶·¥Á¥§¥Ã¥¯
+if (sfGetSiteControlFlg(SITE_CONTROL_TRACKBACK) != 1) {
+    $objPage->arrTrackbackView = "OFF";
+} else {
+    $objPage->arrTrackbackView = "ON";
+    $objPage->arrTrackback = lfGetTrackbackData($tmp_id);
+}
+$objPage->trackback_url = TRACKBACK_TO_URL . $tmp_id;
 // ¥¿¥¤¥È¥ë¤Ë¾¦ÉÊ̾¤òÆþ¤ì¤ë
 $objPage->tpl_title = "¾¦Éʾܺ٠". $objPage->arrProduct["name"];
@@ -421 +431 @@
     $col = "create_date, reviewer_url, reviewer_name, recommend_level, title, comment";
     $from = "dtb_review";
-    $where = "del_flg = 0 AND status = 1 AND product_id = ? ";
+    $where = "del_flg = 0 AND status = 1 AND product_id = ? ORDER BY create_date DESC LIMIT " . REVIEW_REGIST_MAX;
     $arrval[] = $id;
     $arrReview = $objQuery->select($col, $from, $where, $arrval);
     return $arrReview; 
+}
+
+/*
+ * ¾¦Éʤ´¤È¤Î¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤ò¼èÆÀ¤¹¤ë
+ * 
+ * @param $product_id
+ * @return $arrTrackback
+ */
+function lfGetTrackbackData($product_id) {
+
+    $arrTrackback = array();
+
+    $objQuery = new SC_Query;
+    //¾¦Éʤ´¤È¤Î¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤ò¼èÆÀ¤¹¤ë
+    $col = "blog_name, url, title, excerpt, title, create_date";
+    $from = "dtb_trackback";
+    $where = "del_flg = 0 AND status = 1 AND product_id = ? ORDER BY create_date DESC LIMIT " . TRACKBACK_VIEW_MAX;
+    $arrval[] = $product_id;
+    $arrTrackback = $objQuery->select($col, $from, $where, $arrval);
+    return $arrTrackback; 
 }