public function perfAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$Model = new Model_City();
$cities = $Model->getAll();
foreach ($cities as $key => $city) {
Zend_Debug::dump($city->getName());
//$city->findParentState()->getName()
}
}
/**
* 导出
*/
public function explodeAction()
{
$uWhere = array();
$aParam = $this->getParams();
$userid = '';
if (!empty($aParam['sUserRealName'])) {
$uWhere['sRealName LIKE'] = '%' . $aParam['sUserRealName'] . '%';
$data_user = Model_User::getAll(array('where' => $uWhere));
$useridArr = array();
foreach ($data_user as $val) {
if ($val['iUserID'] != '') {
$useridArr[] = $val['iUserID'];
}
}
if (count($useridArr) > 0) {
$userid = implode(',', array_unique($useridArr));
}
}
$aWhere = array();
if (!empty($aParam['iUserID'])) {
$aWhere['iUserID'] = $aParam['iUserID'];
}
if ($userid != '') {
$aWhere['iUserID IN'] = $userid;
}
if (!empty($aParam['sAdName']) && $aParam['sAdName'] != '') {
$aWhere['sAdName LIKE'] = '%' . $aParam['sAdName'] . '%';
}
if (!empty($aParam['iMediaType']) && $aParam['iMediaType'] != '') {
$aWhere['iMediaType'] = $aParam['iMediaType'];
}
if (!empty($aParam['iAdType']) && $aParam['iAdType'] != '') {
$aWhere['iAdType'] = $aParam['iAdType'];
}
if (!empty($aParam['iPayStatus']) && $aParam['iPayStatus'] != '') {
$aWhere['iPayStatus'] = $aParam['iPayStatus'];
}
if (!empty($aParam['iStatus']) && $aParam['iStatus'] != '') {
$aWhere['iStatus'] = $aParam['iStatus'];
} else {
$aWhere['iStatus IN'] = '1,2,3,4,5';
}
$aList = Model_Ad::getAll(array('where', $aWhere));
foreach ($aList['aList'] as $key => $val) {
//媒体类型
if ($val['iMediaType'] == '1') {
$aList['aList'][$key]['iMediaType'] = '公众号';
} elseif ($val['iMediaType'] == '2') {
$aList['aList'][$key]['iMediaType'] = '朋友圈';
} elseif ($val['iMediaType'] == '3') {
$aList['aList'][$key]['iMediaType'] = '新浪微博';
} elseif ($val['iMediaType'] == '4') {
$aList['aList'][$key]['iMediaType'] = '新闻论坛';
}
//广告类型
if ($val['iAdType'] == '1') {
$aList['aList'][$key]['iAdType'] = '硬广';
} elseif ($val['iAdType'] == '2') {
$aList['aList'][$key]['iAdType'] = '软广';
} elseif ($val['iAdType'] == '3') {
$aList['aList'][$key]['iAdType'] = '全部';
}
//支付状态
if ($val['iPayStatus'] == '0') {
$aList['aList'][$key]['iPayStatus'] = '未付款';
} elseif ($val['iPayStatus'] == '1') {
$aList['aList'][$key]['iPayStatus'] = '已付款';
}
//状态
if ($val['iStatus'] == '1') {
$aList['aList'][$key]['iStatus'] = '待审核';
} elseif ($val['iStatus'] == '2') {
$aList['aList'][$key]['iStatus'] = '审核通过';
} elseif ($val['iStatus'] == '3') {
$aList['aList'][$key]['iStatus'] = '审核未通过';
} elseif ($val['iStatus'] == '4') {
$aList['aList'][$key]['iStatus'] = '完成';
} elseif ($val['iStatus'] == '5') {
$aList['aList'][$key]['iStatus'] = '全未填写完成';
}
//城市
if ($val['sCityID'] != '') {
$data_City = Model_City::getAll(array('where' => array('iCityID IN' => $val['sCityID'])));
$sCityID = '';
if (count($data_City) > 0) {
foreach ($data_City as $val_City) {
$sCityID .= ',' . $val_City['sCityName'];
}
}
$aList['aList'][$key]['sCityID'] = $sCityID;
}
//媒体分类
if ($val['sCatID'] != '') {
$data_Cat = Model_Domain::getAll(array('where' => array('iAutoID IN' => $val['sCatID'])));
$sCatID = '';
if (count($data_Cat) > 0) {
foreach ($data_Cat as $val_City) {
$sCatID .= ',' . $val_City['sName'];
}
}
$aList['aList'][$key]['sCatID'] = $sCatID;
}
//资源广告内容
$rowAd = array();
if ($val['iMediaType'] == Model_Media::TYPE_WEIXIN) {
$rowAd = Model_AdWeixin::getDetail($val['iAdID']);
$iPosID = $rowAd['iAdPos'];
} elseif ($val['iMediaType'] == Model_Media::TYPE_FRIEND) {
$rowAd = Model_AdFriend::getDetail($val['iAdID']);
$iPosID = $rowAd['iAdPos'];
} elseif ($val['iMediaType'] == Model_Media::TYPE_WEIBO) {
$rowAd = Model_AdWeibo::getDetail($val['iAdID']);
$iPosID = $rowAd['iAdPos'];
} elseif ($val['iMediaType'] == Model_Media::TYPE_NEWS) {
$rowAd = Model_AdNews::getDetail($val['iAdID']);
$iPosID = $rowAd['iAdPos'];
}
$aList['aList'][$key]['Media'] = $rowAd;
//广告位
$aTitle = array(Model_Media::TYPE_WEIXIN => array('1' => '单图文报价', '2' => '第一条报价', '3' => '第二条报价', '4' => '其它位置价'), Model_Media::TYPE_FRIEND => array('1' => '转发报价', '2' => '直发报价'), Model_Media::TYPE_WEIBO => array('1' => '转发报价', '2' => '直发报价'));
if ($val['iMediaType'] != '') {
$iPos = $aTitle[$val['iMediaType']][$iPosID];
$aList['aList'][$key]['sPos'] = $iPos;
}
}
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=广告_" . date('Y-m-d', time()) . ".xls");
$str_explode = "<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'><html xmlns='http://www.w3.org/1999/xhtml'><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8' /><title>导出</title><style>td{text-align:center;font-size:12px;font-family:Arial, Helvetica, sans-serif;border:#1C7A80 1px solid;color:#152122;width:100px;}table,tr{border-style:none;}.title{background:#7DDCF0;color:#FFFFFF;font-weight:bold;}</style></head><body>";
$str_explode .= '<table cellspacing="0" cellpadding="3" rules="rows" border="1" id="" style="border-style:None;width:100%;border-collapse:collapse;">
<tr>
<th scope="col">用户名称/th>
<th scope="col">广告名称</th>
<th scope="col">最小投放预算</th>
<th scope="col">最大投放预算</th>
<th scope="col">投放时间</th>
<th scope="col">媒体类型</th>
<th scope="col">广告类型</th>
<th scope="col">媒体分类</th>
<th scope="col">所在城市</th>
<th scope="col">总价</th>
<th scope="col">支付状态</th>
<th scope="col">状态</th>
<th scope="col">时间</th>
</tr>';
foreach ($aList as $key => $val) {
$row = Model_User::getDetail($val['iUserID']);
$sUserRealName = isset($row) && $row['sRealName'] != '' ? $row['sRealName'] : '';
$iCreateTime = date('Y-m-d H:i:s', $val['iCreateTime']);
$iPlanTime = isset($val['iPlanTime']) && $val['iPlanTime'] != '' ? date('Y-m-d H:i:s', $val['iPlanTime']) : '';
$str_explode .= '<tr>
<td align="left">' . $sUserRealName . '</td>
<td align="left">' . $val['sAdName'] . '</td>
<td align="left">' . $val['iPlanMinMoney'] . '</td>
<td align="left">' . $val['iPlanMaxMoney'] . '</td>
<td align="left">' . $val['iPlanTime'] . '</td>
<td align="left">' . $val['iMediaType'] . '</td>
<td align="left">' . $val['iAdType'] . '</td>
<td align="left">' . $val['sCatID'] . '</td>
<td align="left">' . $val['sCityID'] . '</td>
<td align="left">' . $val['iTotalMoney'] . '</td>
<td align="left">' . $val['iPayStatus'] . '</td>
<td align="left">' . $val['iStatus'] . '</td>
<td align="left">' . $iCreateTime . '</td>
</tr>';
}
$str_explode .= '</table>';
$str_explode .= "</body></html>";
echo $str_explode;
}
