{"id":493,"date":"2008-10-02T01:12:16","date_gmt":"2008-10-01T16:12:16","guid":{"rendered":"http:\/\/www.bton.net46.net\/?p=493"},"modified":"2010-07-21T14:13:55","modified_gmt":"2010-07-21T05:13:55","slug":"%e3%80%90ec-cube%e3%80%91%e6%96%b0%e7%9d%80%e5%95%86%e5%93%81%e3%82%92%e3%83%96%e3%83%ad%e3%83%83%e3%82%af%e3%81%a7%e8%a1%a8%e7%a4%ba%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/bton.papalabs.net\/?p=493","title":{"rendered":"\u3010EC-CUBE\u3011\u65b0\u7740\u5546\u54c1\u3092\u30d6\u30ed\u30c3\u30af\u3067\u8868\u793a\u3059\u308b"},"content":{"rendered":"<p><strong>\uff11\uff09\u307e\u305a\u306f\u30aa\u30b9\u30b9\u30e1\u5546\u54c1\u306ePHP\u30bd\u30fc\u30b9\uff13\u3064\u3092\u30b3\u30d4\u30fc\u3057\u3066\u65b0\u7740\u5546\u54c1\u7528\u306b\u30d5\u30a1\u30a4\u30eb\u540d\u5909\u66f4\u3002<\/strong><\/p>\n<ul>\n<li>\/data\/class\/pages\/frontparts\/bloc\/LC_Page_FrontParts_Bloc_Best5.php<\/li>\n<li>\/data\/class_extends\/page_extends\/frontparts\/bloc\/LC_Page_FrontParts_Bloc_Best5_Ex.php<\/li>\n<li>\/frontparts\/bloc\/best5.php<\/li>\n<\/ul>\n<p>\u3092\u305d\u308c\u305e\u308c\u30b3\u30d4\u30fc\u3057\u3001Best5\u306e\u3068\u3053\u308d\u3092New\u306b\u5909\u66f4\u3059\u308b\u3002<\/p>\n<ul>\n<li>\/data\/class\/pages\/frontparts\/bloc\/LC_Page_FrontParts_Bloc_<span style=\"color: #ff00ff;\">New<\/span>.php<\/li>\n<li>\/data\/class_extends\/page_extends\/frontparts\/bloc\/LC_Page_FrontParts_Bloc_<span style=\"color: #ff00ff;\">New<\/span>_Ex.php<\/li>\n<li>\/frontparts\/bloc\/<span style=\"color: #ff00ff;\">new<\/span>.php<\/li>\n<\/ul>\n<p><strong>\uff12\uff09PHP\u30bd\u30fc\u30b9\u306e\u4e2d\u306e\u5909\u6570\u306a\u3069Best5\u2192New\u3078best5\u2192new\u3078\u7f6e\u304d\u63db\u3048\u3059\u308b\u3002\uff08\u6570\u7b87\u6240\u3042\u308b\uff09<\/strong><\/p>\n<p><strong>\uff13\uff09LC_Page_FrontParts_Bloc_New.php\u306e\u30bd\u30fc\u30b9\u3092\u5909\u66f4\u3002\uff08Ver.2.3RC1\u306e\u5834\u5408L55\uff5e\uff09<\/strong><\/p>\n<blockquote><p>\u00a0\u00a0\u00a0 function process() {<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if (defined(&#8220;MOBILE_SITE&#8221;) &amp;&amp; MOBILE_SITE) {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $objView = new SC_MobileView();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 } else {<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $objView = new SC_SiteView();<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $objSiteInfo = $objView-&gt;objSiteInfo;<\/p>\n<p>\uff5e(\u4e2d\u7565\uff1a\u3053\u306e\u4e2d\u8eab\u3092\u4e0b\u8a18\u30bd\u30fc\u30b9\u306b\u5165\u308c\u66ff\u3048\uff09<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $objView-&gt;display($this-&gt;tpl_mainpage);<br \/>\n\u00a0\u00a0\u00a0 }<\/p><\/blockquote>\n<p>&#8212;&#8212;&#8212;-(\u30e2\u30d0\u30a4\u30eb\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u308b\u2193\u3053\u306e\u624b\u524d\u307e\u3067\uff09<br \/>\n\u00a0\u00a0\u00a0 \/**<br \/>\n\u00a0\u00a0\u00a0\u00a0 * \u30e2\u30d0\u30a4\u30eb\u30da\u30fc\u30b8\u3092\u521d\u671f\u5316\u3059\u308b.<br \/>\n&#8212;&#8212;&#8212;-<\/p>\n<blockquote><p>\u00a0 function process() {<br \/>\nif (defined(&#8220;MOBILE_SITE&#8221;) &amp;&amp; MOBILE_SITE) {<br \/>\n$objView = new SC_MobileView();<br \/>\n} else {<br \/>\n$objView = new SC_SiteView();<br \/>\n}<br \/>\n$objSiteInfo = $objView-&gt;objSiteInfo;<\/p>\n<p>\/\/ \u57fa\u672c\u60c5\u5831\u3092\u6e21\u3059<br \/>\n$objSiteInfo = new SC_SiteInfo();<br \/>\n$this-&gt;arrInfo = $objSiteInfo-&gt;data;<br \/>\n$objQuery = new SC_Query();<\/p>\n<p>\/\/\u691c\u7d22\u3057\u305f\u3044\u5546\u54c1\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u8a2d\u5b9a<br \/>\n\/\/NEW\u21921, \u6b8b\u308a\u308f\u305a\u304b\u21922, \u30dd\u30a4\u30f3\u30c82\u500d\u21923, \u30aa\u30b9\u30b9\u30e1\u21924, \u9650\u5b9a\u54c1\u21925<br \/>\n$productFlag = 1;<\/p>\n<p>\/\/\u691c\u7d22\u3059\u308b\u5546\u54c1\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u30e9\u30f3\u30c0\u30e0\u306b\u6c7a\u5b9a\u3057\u3001\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u5916\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\/\/$id_count = $objQuery-&gt;count(mtb_status);<br \/>\n\/\/$productFlag = rand(1,$id_count);<\/p>\n<p>$this-&gt;statusName =$objQuery-&gt;get(&#8220;mtb_status_image&#8221;, &#8220;name&#8221;, &#8220;id={$productFlag}&#8221;);<\/p>\n<p>\/\/\u8868\u793a\u3059\u308b\u5546\u54c1\u306e\u4ef6\u6570<br \/>\n$listCount = 8;<\/p>\n<p>$ret = &#8220;&#8221;;<br \/>\n$arrTmp[$productFlag] = &#8220;1&#8221;;<\/p>\n<p>for($i = 1; $i &lt;= $productFlag; $i++) {<br \/>\nif($arrTmp[$i] == &#8220;1&#8221;) {<br \/>\n$ret.= &#8220;1&#8221;;<br \/>\n} else {<br \/>\n$ret.= &#8220;_&#8221;;<br \/>\n}<br \/>\n}<\/p>\n<p>if($ret != &#8220;&#8221;) {<br \/>\n$ret.= &#8220;%&#8221;;<br \/>\n}<br \/>\n\/\/$col = &#8220;dtb_products.product_id, dtb_products.name, dtb_products.main_image,<br \/>\n\/\/ MIN(dtb_products_class.price02) AS price02_min, MAX(dtb_products_class.price02) AS price02_max&#8221;;<br \/>\n\/\/$from = &#8220;dtb_products INNER JOIN dtb_products_class using(product_id)&#8221;;<br \/>\n\/\/$where = &#8220;product_flag LIKE \\&#8221;{$ret}\\&#8221;&#8221;;<br \/>\n\/\/$groupby = &#8220;product_id&#8221;;<br \/>\n\/\/$this-&gt;groupby=$objQuery-&gt;setgroupby($groupby);<br \/>\n\/\/\u5546\u54c1\u306e\u8868\u793a\u306fupdate_date\u304c\u65b0\u3057\u3044\u9806<br \/>\n\/\/$order = &#8220;dtb_products.update_date DESC&#8221;;<br \/>\n\/\/$this-&gt;order=$objQuery-&gt;setorder($order);<\/p>\n<p>$col = &#8220;DISTINCT price02_min, product_id, price02_max, main_list_image, status, product_flag, name&#8221;;<br \/>\n$from = &#8220;vw_products_allclass AS T1&#8221;;<br \/>\n$where = &#8220;del_flg = 0 AND\u00a0status =\u00a01 AND product_flag LIKE &#8216;{$ret}'&#8221;;<br \/>\n\/\/\u5546\u54c1\u306e\u8868\u793a\u306fproduct_id\u9006\u9806<br \/>\n$order = &#8220;product_id DESC&#8221;;<br \/>\n$this-&gt;order=$objQuery-&gt;setorder($order);<\/p>\n<p>$arrFlagList = $objQuery-&gt;select($col, $from, $where);<\/p>\n<p>\/\/\u5546\u54c1\u306e\u8868\u793a\u3092\u30e9\u30f3\u30c0\u30e0\u306b\u62bd\u51fa\u3059\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u5916\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\/\/srand((double)microtime()*1000000); \/\/\u4e71\u6570\u751f\u6210\u5668\u3092\u521d\u671f\u5316<br \/>\n\/\/shuffle($arrFlagList);<\/p>\n<p>$this-&gt;<span style=\"color: #ff00ff;\">arrFlagProducts<\/span> = array_slice($arrFlagList, 0, $listCount);<br \/>\n\/\/\u3053\u306e\u5909\u6570\u540d\u3092\u30c6\u30f3\u30d7\u30ec\u306e\u5024\u306e\u547c\u3073\u51fa\u3057\u306b\u4f7f\u3046\u306e\u3067\u6ce8\u610f\u3002<\/p>\n<p>$objSubView = new SC_SiteView();<br \/>\n$objSubView-&gt;assignobj($this);<br \/>\n$objSubView-&gt;display($this-&gt;tpl_mainpage);<br \/>\n}<\/p><\/blockquote>\n<p>\u5143\u306e\u30bd\u30fc\u30b9\u306e\u6700\u5f8c\u306e\u307b\u3046\u306e\u5546\u54c1\u691c\u7d22function\u306f\u4e0d\u8981\u306a\u306e\u3067\u3001\u524a\u9664\u3002<\/p>\n<p><strong>\uff14\uff09\u4e0a\u8a18\u306e3\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3002<\/strong><\/p>\n<p><strong>\uff15\uff09\u65b0\u7740\u5546\u54c1\u7528\u306e\u30d6\u30ed\u30c3\u30af\u3092\u4f5c\u308a\u3001DB\u3092\u4fee\u6b63\u3059\u308b\u3002<\/strong><\/p>\n<p>\u307e\u305a\u3001\u7ba1\u7406\u753b\u9762\u3067\u300c\u30c7\u30b6\u30a4\u30f3\u7ba1\u7406\u300d\u2192\u300c\u30d6\u30ed\u30c3\u30af\u7de8\u96c6\u300d\u3067\u30d6\u30ed\u30c3\u30af\u540d\u300c\u65b0\u7740\u5546\u54c1\u8868\u793a\u300d\/\u30d5\u30a1\u30a4\u30eb\u540d\u300cnew\uff08.tpl)\u300d\u3092\u4f5c\u6210\u3059\u308b\u3002<br \/>\n\u5185\u5bb9\u306f\u3001\u304a\u3059\u3059\u3081\u5546\u54c1\u7528\u30d6\u30ed\u30c3\u30af\uff08best5.tpl\uff09\u3092\u30b3\u30d4\u30fc\u3057\u3066\u4fdd\u5b58\u3002<\/p>\n<p>phpMyAdmin\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u958b\u3044\u3066\u3001\u300cdtb_bloc\u300d\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u3092\u898b\u308b\u3068\u3001\u65b0\u5546\u54c1\u7528\u30d6\u30ed\u30c3\u30af\u306e\u30c7\u30fc\u30bf\u3001NEW\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u305d\u306e\u4e2d\u306e\u3001php_path\uff08\u6700\u521d\u306fnull\u3068\u306a\u3063\u3066\u3044\u308b\uff09\u306b\u300cfrontparts\/bloc\/new.php\u300d\u3068\u5024\u3092\u30bb\u30c3\u30c8\u3002<\/p>\n<p>\u5404\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u3067\u5909\u6570\u540d\u304cEC-CUBE\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u306b\u3088\u3063\u3066\u5909\u66f4\u306b\u306a\u3063\u305f\u308a\u3059\u308b\u3053\u3068\u304c\u3042\u308b\u3002\u305d\u306e\u3068\u304d\u306f\u3001BEST5\u306e\u30bd\u30fc\u30b9\u3092\u53c2\u8003\u306b\u3057\u3066\u3001\u9069\u5b9c\u8abf\u6574\u3059\u308b\u3068\u3088\u3044\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001$arrBest5\u306f\u2192$arrFlagProducts\u3068\u306a\u308b\u3002<\/p>\n<p>\u3053\u308c\u3067OK\u3002\u30d6\u30ed\u30c3\u30af\u306e\u30ec\u30a4\u30a2\u30a6\u30c8\u306f\u8868\u793a\u3057\u305f\u3044\u3088\u3046\u306b\u9069\u5b9c\u5909\u66f4\u3002<\/p>\n<p>\u53c2\u8003\uff1a<a href=\"http:\/\/xoops.ec-cube.net\/modules\/newbb\/viewtopic.php?viewmode=flat&amp;order=ASC&amp;topic_id=1276&amp;forum=6\" target=\"_blank\">http:\/\/xoops.ec-cube.net\/modules\/newbb\/viewtopic.php?viewmode=flat&amp;order=ASC&amp;topic_id=1276&amp;forum=6<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff09\u307e\u305a\u306f\u30aa\u30b9\u30b9\u30e1\u5546\u54c1\u306ePHP\u30bd\u30fc\u30b9\uff13\u3064\u3092\u30b3\u30d4\u30fc\u3057\u3066\u65b0\u7740\u5546\u54c1\u7528\u306b\u30d5\u30a1\u30a4\u30eb\u540d\u5909\u66f4\u3002 \/data\/class\/pages\/frontparts\/bloc\/LC_Page_FrontParts_Bloc_Best5.php \/ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[183],"tags":[147,79,90,163,51],"_links":{"self":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/posts\/493"}],"collection":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=493"}],"version-history":[{"count":0,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/posts\/493\/revisions"}],"wp:attachment":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}