field('G.*,A.name as appname,IFNULL(D.ds,0) as dnum,IFNULL(C.sc,0) as cnum')->JOIN('app', 'as A', 'G.appid=A.id')->JOIN("(SELECT gid,COUNT(*) AS sc FROM {$DP}goods_order where `state` = 2 GROUP BY gid) AS C", 'G.id=C.gid')->JOIN("(SELECT gid,COUNT(*) AS ds FROM {$DP}goods_order GROUP BY gid) AS D", 'G.id=D.gid'); if ($so) { $goods = $goods->where('G.name', 'like', "%{$so}%")->whereOr('G.jie', 'like', "%{$so}%")->whereOr('A.name', 'like', "%{$so}%")->order('id desc'); } else { $goods = $goods->order('id desc')->limit($bnums, $ENUMS); } $res = $goods->select(); // die(print_r($res)); foreach ($res as $k => $v) { $rows = $res[$k]; if (empty($rows['appname'])) continue; ?>

	ID	商品名称	应用名称	金额	类型	订单	售出	状态	管理
			应用不存在		积分会员			停售正常