public function goods_report()
{
$seller_id = $this->seller['seller_id'];
$condition = Util::search(IFilter::act(IReq::get('search'), 'strict'));
$where = 'go.seller_id=' . $seller_id;
$where .= $condition ? " and " . $condition : "";
$goodHandle = new IQuery('goods as go');
$goodHandle->order = "go.id desc";
$goodHandle->fields = "go.*";
$goodHandle->where = $where;
$goodList = $goodHandle->find();
//构建 Excel table;
$strTable = '<table width="500" border="1">';
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;">商品名称</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 .= '</tr>';
foreach ($goodList 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 .= '</tr>';
}
$strTable .= '</table>';
unset($goodList);
$reportObj = new report();
$reportObj->setFileName('goods');
$reportObj->toDownload($strTable);
exit;
}
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;
}
