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";