| 1 | <?php |
|---|
| 2 | /* |
|---|
| 3 | * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved. |
|---|
| 4 | * |
|---|
| 5 | * http://www.lockon.co.jp/ |
|---|
| 6 | */ |
|---|
| 7 | |
|---|
| 8 | //¶¦ÄÌÉôÉʤÎÆɤ߹þ¤ß |
|---|
| 9 | require_once("../require.php"); |
|---|
| 10 | |
|---|
| 11 | class LC_Page{ |
|---|
| 12 | function LC_Page(){ |
|---|
| 13 | $this->tpl_mainpage = "rss/product.tpl"; |
|---|
| 14 | $this->encode = "UTF-8"; |
|---|
| 15 | ($_GET['product_id'] == "") ? $this->title = "¾¦ÉÊ°ìÍ÷¾ðÊó" : $this->title = "¾¦ÉʾܺپðÊó"; |
|---|
| 16 | } |
|---|
| 17 | } |
|---|
| 18 | |
|---|
| 19 | $objQuery = new SC_Query(); |
|---|
| 20 | $objPage = new LC_Page(); |
|---|
| 21 | $objView = new SC_SiteView(); |
|---|
| 22 | $objSiteInfo = new SC_SiteInfo(); |
|---|
| 23 | |
|---|
| 24 | //¾¦ÉÊID¤ò¼èÆÀ |
|---|
| 25 | $product_id = $_GET['product_id']; |
|---|
| 26 | |
|---|
| 27 | if($product_id != ""){ |
|---|
| 28 | //¾¦Éʾܺ٤ò¼èÆÀ |
|---|
| 29 | $arrProduct = lfGetProductsDetail($objQuery, $product_id); |
|---|
| 30 | }else{ |
|---|
| 31 | //¾¦ÉÊ°ìÍ÷¤ò¼èÆÀ |
|---|
| 32 | $arrProduct = $objQuery->getall("SELECT * FROM dtb_products"); |
|---|
| 33 | } |
|---|
| 34 | |
|---|
| 35 | //ŹÊÞ¾ðÊó¤ò¥»¥Ã¥È |
|---|
| 36 | $objPage->arrSiteInfo = $objSiteInfo->data; |
|---|
| 37 | |
|---|
| 38 | //¾¦ÉʾðÊó¤ò¥»¥Ã¥È |
|---|
| 39 | $objPage->arrProduct = $arrProduct; |
|---|
| 40 | |
|---|
| 41 | //¥»¥Ã¥È¤·¤¿¥Ç¡¼¥¿¤ò¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎÏ |
|---|
| 42 | $objView->assignobj($objPage); |
|---|
| 43 | |
|---|
| 44 | //¥¥ã¥Ã¥·¥å¤·¤Ê¤¤(Ç°¤Î¤¿¤á) |
|---|
| 45 | header("Paragrama: no-cache"); |
|---|
| 46 | |
|---|
| 47 | //XML¥Æ¥¥¹¥È(¤³¤ì¤¬¤Ê¤¤¤ÈÀµ¾ï¤ËRSS¤È¤·¤Æǧ¼±¤·¤Æ¤¯¤ì¤Ê¤¤¥Ä¡¼¥ë¤¬¤¢¤ë¤¿¤á) |
|---|
| 48 | header("Content-type: application/xml"); |
|---|
| 49 | |
|---|
| 50 | //²èÌÌɽ¼¨ |
|---|
| 51 | $objView->display($objPage->tpl_mainpage, true); |
|---|
| 52 | |
|---|
| 53 | //--------------------------------------------------------------------------------------------------------------------- |
|---|
| 54 | /************************************************************************************************************** |
|---|
| 55 | * ´Ø¿ô̾:lfGetProducts |
|---|
| 56 | * ÀâÌÀ¡¡:¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë |
|---|
| 57 | * °ú¿ô£±:$objQuery DBÁàºî¥¯¥é¥¹ |
|---|
| 58 | * °ú¿ô£²:$product_id ¾¦ÉÊID |
|---|
| 59 | * Ìá¤êÃÍ:$arrProduct ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹ |
|---|
| 60 | **************************************************************************************************************/ |
|---|
| 61 | function lfGetProductsDetail($objQuery, $product_id){ |
|---|
| 62 | $sql = ""; |
|---|
| 63 | $sql .= "SELECT |
|---|
| 64 | prod.product_id |
|---|
| 65 | ,prod.name AS product_name |
|---|
| 66 | ,prod.category_id |
|---|
| 67 | ,prod.point_rate |
|---|
| 68 | ,prod.comment3 |
|---|
| 69 | ,prod.main_list_comment |
|---|
| 70 | ,prod.main_list_image |
|---|
| 71 | ,prod.main_comment |
|---|
| 72 | ,prod.main_image |
|---|
| 73 | ,prod.main_large_image |
|---|
| 74 | ,cls.price01 |
|---|
| 75 | ,cls.price02 |
|---|
| 76 | ,cls.classcategory_id1 |
|---|
| 77 | ,cls.classcategory_id2 |
|---|
| 78 | ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id1) AS classcategory_name1 |
|---|
| 79 | ,(SELECT name FROM dtb_classcategory AS clscat WHERE clscat.classcategory_id = cls.classcategory_id2) AS classcategory_name2 |
|---|
| 80 | ,(SELECT category_name FROM dtb_category AS cat WHERE cat.category_id = prod.category_id) AS category_name |
|---|
| 81 | FROM dtb_products AS prod, dtb_products_class AS cls |
|---|
| 82 | WHERE prod.product_id = cls.product_id AND prod.del_flg = 0 AND prod.status = 1 AND prod.product_id = ? |
|---|
| 83 | ORDER BY prod.product_id, cls.classcategory_id1, cls.classcategory_id2 |
|---|
| 84 | "; |
|---|
| 85 | $arrProduct = $objQuery->getall($sql, array($product_id)); |
|---|
| 86 | return $arrProduct; |
|---|
| 87 | } |
|---|
| 88 | |
|---|
| 89 | ?> |
|---|
