public function goods_report()
{
//搜索条件
$search = IFilter::act(IReq::get('search'), 'strict');
//条件筛选处理
list($join, $where) = goods_class::getSearchCondition($search);
//拼接sql
$goodsHandle = new IQuery('goods as go');
$goodsHandle->order = "go.sort asc,go.id desc";
$goodsHandle->distinct = "go.id";
$goodsHandle->fields = "go.id, go.name,go.sell_price,go.store_nums,go.sale,go.is_del,go.create_time,seller.true_name";
$goodsHandle->join = $join;
$goodsHandle->where = $where;
$goodsHandle->limit = 'all';
$goodsList = $goodsHandle->find();
//构建 Excel table;
$strTable = '<table width="500" border="1">';
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">商品名称</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="160">分类</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">售价</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">库存</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">销量</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">发布时间</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">状态</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">隶属商户</td>';
$strTable .= '</tr>';
foreach ($goodsList as $k => $val) {
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;"> ' . $val['name'] . '</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . goods_class::getGoodsCategory($val['id']) . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['sell_price'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['store_nums'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['sale'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['create_time'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . goods_class::statusText($val['is_del']) . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['true_name'] . ' </td>';
$strTable .= '</tr>';
}
$strTable .= '</table>';
unset($goodsList);
$reportObj = new report();
$reportObj->setFileName('goods');
$reportObj->toDownload($strTable);
exit;
}
echo join(',', $catName);
?>
</td>
<td><?php
echo isset($item['sell_price']) ? $item['sell_price'] : "";
?>
</td>
<td><?php
echo isset($item['store_nums']) ? $item['store_nums'] : "";
?>
</td>
<td class="<?php
echo $item['is_del'] == 0 ? "green" : "red";
?>
"><?php
echo goods_class::statusText($item['is_del']);
?>
</td>
<td><input class="tiny" type="text" value="<?php
echo isset($item['sort']) ? $item['sort'] : "";
?>
" onchange="changeSort(<?php
echo isset($item['id']) ? $item['id'] : "";
?>
,this);" /></td>
<td>
<a href="<?php
echo IUrl::creatUrl("/seller/goods_edit/id/" . $item['id'] . "");
?>
"><img src="<?php
echo IUrl::creatUrl("") . "views/" . $this->theme . "/skin/" . $this->skin . "/images/main/icn_edit.png";
