<?php

$pre = \Phpcmf\Service::M()->dbprefix(SITE_ID.'_store');
$sql = 'select c.*,b.stime,b.etime,b.type as ptype,b.title as pname from `'.$pre.'_goods_promotion_item` as `a` left join `'.$pre.'_goods_promotion` as `b` on a.pid=b.id left join `'.$pre.'` as `c` on a.cid=c.id where b.status=1 and c.is_sale=1 and (b.stime < '.SYS_TIME.' and b.etime > '.SYS_TIME.') order by c.updatetime';
$query_sql = urlencode($sql);
?>
{sql sql='$query_sql' num=5 urlrule=$urlrule}
                {php $t.thumb=dr_string2array($t.thumb);$price_sku=dr_string2array($t.price_sku);}
     <li {if $key==0} class="w199" {/if}>
      <div class="gylpic"><a href="{$t.url}"><img src="{dr_thumb($t['thumb']['file'][0], 200, 160)}" ></a></div>
      <div class="gylinfo">
       <div class="gylname"><a href="{$t.url}">{dr_strcut($t.title, 28)}</a></div>
       <div class="gylprice"><i>￥</i>{if $price_sku}{dr_sku_price($price_sku, 2, ' ~ ')}{else}{number_format($t.price, 2)}{/if}</div>
      </div>
     </li>
     {/sql}