/** * 导出 */ 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; }
/** * 资源订单列表 */ public function listAction() { $iPage = intval($this->getParam('page')); $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; } $iAdID = ''; if (!empty($aParam['sAdName'])) { $uWhere['sAdName LIKE'] = '%' . $aParam['sAdName'] . '%'; $data_Ad = Model_Ad::getAll(array('where' => $uWhere)); $iAdIDArr = array(); foreach ($data_Ad as $val) { if ($val['iAdID'] != '') { $iAdIDArr[] = $val['iAdID']; } } if (count($iAdIDArr) > 0) { $iAdID = implode(',', array_unique($iAdIDArr)); } } if (!empty($aParam['iAdID'])) { $aWhere['iAdID'] = $aParam['iAdID']; } if ($iAdID != '') { $aWhere['iAdID IN'] = $iAdID; } if (!empty($aParam['iPayStatus']) && $aParam['iPayStatus'] != '') { $aWhere['iPayStatus'] = $aParam['iPayStatus']; } if (!empty($aParam['iStatus']) && $aParam['iStatus'] != '') { $aWhere['iStatus'] = $aParam['iStatus']; } $aList = Model_AdMedia::getList($aWhere, $iPage); $iAdIDArr = $useridArr = array(); foreach ($aList['aList'] as $val) { if ($val['iUserID'] != '') { $useridArr[] = $val['iUserID']; } if ($val['iAdID'] != '') { $iAdIDArr[] = $val['iAdID']; } } if (count($useridArr) > 0) { $whereU = array(); $whereU['iUserID IN'] = implode(',', array_unique($useridArr)); $userData = Model_User::getAll(array('where' => $whereU)); if (count($userData) > 0) { $data = array(); foreach ($userData as $val) { $row = array(); $row['iUserID'] = $val['iUserID']; $row['sRealName'] = $val['sRealName']; $data[$val['iUserID']] = $row; } $this->assign('aData', $data); } } $data = array(); if (count($iAdIDArr) > 0) { $whereAd = array(); $whereAd['iAdID IN'] = implode(',', array_unique($iAdIDArr)); $AdData = Model_Ad::getAll(array('where' => $whereAd)); if (count($AdData) > 0) { foreach ($AdData as $val) { $row = array(); $row['iAdID'] = $val['iAdID']; $row['sAdName'] = $val['sAdName']; $row['iMediaType'] = $val['iMediaType']; $data[$val['iAdID']] = $row; } $this->assign('AdData', $data); } } foreach ($aList['aList'] as $key => $val) { $iMediaType = ''; if (count($data) > 0 && isset($data[$val['iAdID']]['iMediaType']) && $data[$val['iAdID']]['iMediaType'] != '') { $iMediaType = $data[$val['iAdID']]['iMediaType']; } $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 ($iMediaType != '') { $aList['aList'][$key]['iPos'] = $aTitle[$iMediaType][$val['iPos']]; } $sMediaName = ''; $row_Media = Model_Media::getDetail($val['iMediaID']); if (isset($row_Media)) { $sMediaName = $row_Media['sMediaName']; } $aList['aList'][$key]['iMediaID'] = $sMediaName; 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'] = '拒绝接单'; } } $this->assign('aList', $aList); $this->assign('aParam', $aParam); }