{eyou:assign name="typeid" value="$eyou.field.typeid"} {eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE restric_type= 2 AND typeid=$typeid' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:assign name="typeid" value="$eyou.field.typeid"}//栏目页显示数量,列表显示的话改$field.typeid {eyou:sql sql='Select count(*) as AllNum from ey_arctype where parent_id = $typeid AND is_del = 0 AND status = 1' cachetime='-1'} {$field.AllNum} {/eyou:sql}
设置两个栏目,一个用来放设计师介绍,一个放案例,利用这两个栏目文章里的【其他选项】里的【作者】与作品相关联起来,注意:案例里的【作者】要和设计师介绍页的【作者】名称一致,然后通过SQL语句在作者详情页将作品列出,代码如下:
{eyou:assign name='writer' value='$eyou.field.author'/} <!-- 获取作者名称变量 --> {eyou:sql sql='SELECT aid,author,litpic FROM ey_archives WHERE author = "$writer" AND typeid="345" limit 10' cachetime='-1'} {eyou:arcview aid="$field.aid" id="field2"} <li><a href="{$field2.arcurl}"><img src="{$field2.litpic}">{$field2.title}</a></li> {/eyou:arcview} {/eyou:sql}
上面的语句意思是说,从archives表里取出typeid="345"(作品栏目id,改成你自已放作品的栏目ID)栏目里与作者名称一致的包括作品图片的文章。
{eyou:assign name="aid" value="$eyou.field.aid"} {eyou:sql sql='Select count(*) as AllNum from ey_weapp_zan where aid = $aid' cachetime='-1'} {$field.AllNum} {/eyou:sql}
{eyou:assign name="aid" value="$eyou.field.aid"} {eyou:sql sql='Select count(*) as AllNum from ey_download_log where aid = $aid' cachetime='-1'} {$field.AllNum} {/eyou:sql}
{eyou:assign name="keywords" value="$eyou.field.keywords"} <!--通过自定义变量assign获取关健词--> {eyou:sql sql='Select count(*) as AllNum from ey_archives where title like "%$keywords%" AND is_del = 0' cachetime='-1'} {$field.AllNum} <!--返回查询数量为allNum字段--> {/eyou:sql}
{eyou:sql sql='SELECT ul.product_name,um.order_amount,um.add_time,u.nickname,u.head_pic FROM __PREFIX__shop_order AS um LEFT JOIN __PREFIX__users AS u on um.users_id = u.users_id LEFT JOIN __PREFIX__shop_order_details AS ul on ul.order_id = um.order_id WHERE um.order_status = 3 ORDER BY um.moneyid DESC LIMIT 0,10' cachetime='-1'} <li> <img src="{$field.head_pic}"> <a><strong>{$field.nickname}</strong><em>¥{$field.order_amount}</em>购买了<span>{$field.product_name}</span><i>[{$field.add_time|MyDate='Y-m-d H:i:s',###}]</i></a> </li> {/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND FROM_UNIXTIME(ADD_TIME) BETWEEN DATE_SUB(now(),INTERVAL 6 month) and now() AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND FROM_UNIXTIME(ADD_TIME) BETWEEN DATE_SUB(now(),INTERVAL 6 month) and now() AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEARWEEK(date_format(FROM_UNIXTIME(ADD_TIME),"%Y-%m-%d")) = YEARWEEK(now())-1 AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEARWEEK(date_format(FROM_UNIXTIME(ADD_TIME),"%Y-%m-%d")) = YEARWEEK(now())-1 AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEARWEEK(date_format(FROM_UNIXTIME(ADD_TIME),"%Y-%m-%d")) = YEARWEEK(now()) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEARWEEK(date_format(FROM_UNIXTIME(ADD_TIME),"%Y-%m-%d")) = YEARWEEK(now()) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEAR(FROM_UNIXTIME(ADD_TIME))=YEAR(date_sub(now(),INTERVAL 1 YEAR)) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEAR(FROM_UNIXTIME(ADD_TIME))=YEAR(date_sub(now(),INTERVAL 1 YEAR)) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEAR(FROM_UNIXTIME(add_time))=YEAR(NOW()) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEAR(FROM_UNIXTIME(add_time))=YEAR(NOW()) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND QUARTER(FROM_UNIXTIME(add_time))=QUARTER(DATE_SUB(now(),interval 1 QUARTER)) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND QUARTER(FROM_UNIXTIME(add_time))=QUARTER(DATE_SUB(now(),interval 1 QUARTER)) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND QUARTER(FROM_UNIXTIME(add_time))=QUARTER(now()) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND QUARTER(FROM_UNIXTIME(add_time))=QUARTER(now()) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND PERIOD_DIFF( date_format( now() , "%Y%m" ) , date_format( FROM_UNIXTIME(add_time), "%Y%m" ) ) =1 AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND PERIOD_DIFF( date_format( now() , "%Y%m" ) , date_format( FROM_UNIXTIME(add_time), "%Y%m" ) ) =1 AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND DATE_FORMAT( FROM_UNIXTIME(add_time), "%Y%m") = DATE_FORMAT( CURDATE(), "%Y%m") AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND DATE_FORMAT( FROM_UNIXTIME(add_time), "%Y%m") = DATE_FORMAT( CURDATE(), "%Y%m") AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND date(FROM_UNIXTIME(add_time)) >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND date(FROM_UNIXTIME(add_time)) >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND date(FROM_UNIXTIME(add_time)) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND date(FROM_UNIXTIME(add_time)) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND TO_DAYS(FROM_UNIXTIME(add_time)) = TO_DAYS(now()) AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND TO_DAYS(now()) - TO_DAYS(FROM_UNIXTIME(add_time)) = 1 AND channel = 2' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND TO_DAYS(now()) - TO_DAYS(FROM_UNIXTIME(add_time)) = 1 AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND TO_DAYS(FROM_UNIXTIME(add_time)) = TO_DAYS(now()) AND channel = 1' cachetime='-1'}{$field.count}{/eyou:sql}
{eyou:sql sql='SELECT ul.level_name,um.money,um.add_time,u.nickname,u.head_pic FROM __PREFIX__users_money AS um LEFT JOIN __PREFIX__users AS u on um.users_id = u.users_id LEFT JOIN __PREFIX__users_level AS ul on ul.level_id = um.level_id WHERE um.cause_type = 0 AND um.status = 2 ORDER BY um.moneyid DESC LIMIT 0,10' cachetime='-1'} <li> <img src="{$field.head_pic}"> <a><strong>{$field.nickname}</strong><em>¥{$field.money}</em>升级了<span>{$field.level_name}</span><i>[{$field.add_time|MyDate='Y-m-d H:i:s',###}]</i></a> </li> {/eyou:sql}
{eyou:sql sql='SELECT count(users_id) AS count FROM __PREFIX__users WHERE is_activation = 1' cachetime='-1'}{$field.count}{/eyou:sql}