$count = $model->alias("a")->
join('product on iss_prod=prod_id')->where($map)->count();
$Page = new Page($count,30);
$show = $Page->show();
$this->assign('page',$show);
$list = $model->alias("a")->
join("prod_cate as b on a.iss_cate=b.pdca_id")->
join('product on iss_prod=prod_id')->
join('store on iss_store=sto_id')->
join('instore_main on iss_mainid=ism_id')->group("iss_id")->
field("a.*,b.pdca_name,prod_name,ism_writer,sto_name,sum(iss_count) as `count`,sum(iss_price*iss_count) as jiage,sum(iss_total) as `total`")->
limit($Page->firstRow.','.$Page->listRows)->where($map)->select();
//echo $model->getlastsql();
$this->assign("list",$list);
$this->assign("action","index");
$this->display();这是一个搜索页面,现在可以在页面显示当前页面的总价格,但是可能符合条件的物品分好几页,我想在每一页 显示出所有符合条件的物品的总的价格。
sum(iss_price*iss_count) as jiage 这个是计算的单价和数量,得出jiage
用笨办法在HTML页面算的当前页面的总数
<input type="hidden" name="field_name" value="value">
<volist name="list" id="vo" >
<p hidden>
{$vv=$vv+$vo['jiage']}
</volist> </p>
我想显示出所有的,包括后面几页的总的价格。求助......
最佳答案