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()
}
}
if ($this->bCheckLogin) {
// 当前用户
$aCookie = Util_Cookie::get(Yaf_G::getConf('authkey', 'cookie'));
if (empty($aCookie)) {
return $this->redirect('/admin/login');
}
$this->aCurrUser = $aCookie;
// 当前城市
$this->iCurrCityID = Util_Cookie::get('city');
if (empty($this->iCurrCityID)) {
$this->iCurrCityID = $this->aCurrUser['iCityID'];
}
$this->aCurrCity = Model_City::getDetail($this->iCurrCityID);
}
$this->assign('sStaticRoot', 'http://' . Yaf_G::getConf('static', 'domain'));
}
/**
* 执行Action后的操作
*
* @see Yaf_Controller::actionAfter()
*/
public function actionAfter()
{
if ($this->autoRender() == true) {
if (!empty($this->aCurrUser)) {
$this->assign('aCurrUser', $this->aCurrUser);
public function buscaPadrao($filter = array())
{
$City = new Model_City();
$Neighborhood = new Model_Neighborhood();
$request = $this->view->request();
$this->view->controller = $request->getControllerName();
$this->view->action = $request->getActionName();
$this->view->filter = $filter;
if (isset($filter['state_id']) and !empty($filter['state_id'])) {
$this->view->getAllCities = $City->getAllCityByStateId($filter['state_id']);
}
if (isset($filter['city_id']) and !empty($filter['city_id'])) {
$this->view->getAllNeighborhoods = $Neighborhood->getAllNeighborhoodByCityId($filter['city_id']);
}
return $this->setModuleScriptPath('default')->render('busca-padrao/form.phtml');
}
public static function getCitiesByAdmin($iAdminID)
{
$aAdmin = self::getDetail($iAdminID);
if (!empty($aAdmin)) {
if ($aAdmin['sCityID'] == "-1") {
return Model_City::getPairCitys();
}
$aAdminCityID = explode(',', $aAdmin['sCityID']);
return Model_City::getPairCitysByAdmin($aAdminCityID);
}
}
/**
* 更换城市
*/
public function changeAction()
{
// 当前用户
$aCookie = Util_Cookie::get(Yaf_G::getConf('authkey', 'cookie'));
if (empty($aCookie)) {
return $this->redirect('/admin/login');
}
$this->aCurrUser = $aCookie;
$iCityID = $this->getParam('id');
$aCity = Model_City::getDetail($iCityID);
if (empty($aCity) || $aCity['iBackendShow'] == 0 || $aCity['iStatus'] == 0) {
return $this->showMsg('城市不存在或未开放！', false);
}
$aUser = Model_Admin::getDetail($this->aCurrUser['iAdminID']);
$aCityID = explode(',', $aUser['sCityID']);
if ($aUser['sCityID'] != '-1' && !in_array($iCityID, $aCityID)) {
return $this->showMsg('您没有访问该城市的权限，请联系管理员！', false);
}
Util_Cookie::set('city', $iCityID);
return $this->showMsg('城市切换成功!', true);
}
<?php
/* TODO: Add code here */
require 'config/globalconfig.php';
include_once 'class/model_store.php';
include_once 'class/model_articletype.php';
include_once 'class/model_storecategory.php';
include_once 'class/model_city.php';
include_once 'class/model_district.php';
$objArticleType = new Model_ArticleType($objConnection);
$objCity = new Model_City($objConnection);
$objDistrict = new Model_District($objConnection);
$objStore = new Model_Store($objConnection);
$objStoreCategory = new Model_Storecategory($objConnection);
$folder = global_common::FOLDER_FILES_OTHER . '/Foody/';
$fileCat = $folder . 'All_Foody_Categories.txt';
if ($_pgR["act"] == "import") {
echo $fileCat;
echo '<br>';
$jsonCats = global_common::readFromFile($fileCat);
$rootCats = json_decode($jsonCats, true);
$cats = $rootCats['allCategories'];
//print_r($cats);
$createdBy = 11111;
$updatedBy = 11111;
foreach ($cats as $cat) {
//print_r($cat);
//return;
$catName = $cat['Name'];
$checkExisted = $objArticleType->getArticleTypeByName($catName);
//print_r($checkExisted); ;
public function filterAddressToInsertRegional($data)
{
$cityModel = new Model_City();
$stateModel = new Model_State();
$dbTable_City = new DbTable_City();
$neighborhoodModel = new Model_Neighborhood();
$filter = array('getAllStates' => null, 'getAllCities' => null, 'getAllNeighborhoods' => null);
switch ($data['indice']) {
case 'StateId':
$filter['allStateId'] = $data['dados'];
$filter['getAllStates'] = $stateModel->getAll();
break;
case 'CityId':
$filter['allCityId'] = $data['dados'];
$city = $dbTable_City->getById($data['dados'][0]['CityId']);
$stateId = $city->getStateId();
$filter['allStateId'] = array(0 => array('StateId' => $stateId));
$localData['uf'] = $city->getUf();
break;
case 'NeighborhoodId':
$filter['allNeighborhoodId'] = $data['dados'];
$neighborhood = $neighborhoodModel->getNeighborhoodById($data['dados'][0]['NeighborhoodId']);
$cityId = $neighborhood->getCityId();
$state = $stateModel->getStateByUf($neighborhood->getUf());
$filter['allCityId'] = array(0 => array('CityId' => $cityId));
$filter['allStateId'] = array(0 => array('StateId' => $state->getId()));
$localData['uf'] = $neighborhood->getUf();
$localData['city_id'] = $cityId;
break;
default:
break;
}
$filter['getAllStates'] = $stateModel->getAll();
if (isset($localData['uf'])) {
$filter['getAllCities'] = $cityModel->getAllCityByUf($localData['uf']);
}
if (isset($localData['city_id'])) {
$filter['getAllNeighborhoods'] = $neighborhoodModel->getAllNeighborhoodByCityId($localData['city_id']);
}
return $filter;
}
/**
* 增加自媒体
*/
public function addAction()
{
if ($this->_request->isPost()) {
$aMedia = $this->_checkData('add');
if (empty($aMedia)) {
return null;
}
// if (Model_Media::getCityByName($aMedia['sCityName'])) {
// return $this->showMsg('自媒体已经存在！', false);
// }
//标签
$sTagID = $aMedia['sTagID'];
unset($aMedia['sTagID']);
//所属类目
$sCategoryID = $aMedia['sCategoryID'];
unset($aMedia['sCategoryID']);
//行业圈子
$sCricleID = $aMedia['sCricleID'];
unset($aMedia['sCricleID']);
//城市
$sCityID = $aMedia['sCityID'];
unset($aMedia['sCityID']);
if (Model_Media::addData($aMedia) > 0) {
//标签
if ($sTagID != '') {
$sTagID = explode(',', $sTagID);
$add = array();
$add['iMediaID'] = $aMedia['iMediaID'];
$add['iStatus'] = 1;
$add['iCreateTime'] = time();
$add['iUpdateTime'] = time();
foreach ($sTagID as $val) {
$add['iTagID'] = $val;
Model_MediaTag::addData($add);
}
}
//所属类目
if ($sCategoryID != '') {
$sCategoryID = explode(',', $sCategoryID);
$add = array();
$add['iMediaID'] = $aMedia['iMediaID'];
$add['iStatus'] = 1;
$add['iCreateTime'] = time();
$add['iUpdateTime'] = time();
foreach ($sCategoryID as $val) {
$add['iCategoryID'] = $val;
Model_MediaCategory::addData($add);
}
}
//行业圈子
if ($sCricleID != '') {
$sCricleID = explode(',', $sCricleID);
$add = array();
$add['iMediaID'] = $aMedia['iMediaID'];
$add['iStatus'] = 1;
$add['iCreateTime'] = time();
$add['iUpdateTime'] = time();
foreach ($sCricleID as $val) {
$add['iCricleID'] = $val;
Model_MediaCricle::addData($add);
}
}
//城市
if ($sCityID != '') {
$sCityID = explode(',', $sCityID);
$add = array();
$add['iMediaID'] = $aMedia['iMediaID'];
$add['iStatus'] = 1;
$add['iCreateTime'] = time();
$add['iUpdateTime'] = time();
foreach ($sCityID as $val) {
$add['iCityID'] = $val;
Model_MediaCity::addData($add);
}
}
return $this->showMsg('自媒体增加成功！', true);
} else {
return $this->showMsg('自媒体增加失败！', false);
}
}
$iMediaType = $this->getParam('iMediaType');
$this->assign('iMediaType', $iMediaType);
//属性
if ($iMediaType == Model_Media::TYPE_WEIXIN) {
// 微信公众号
$this->assign('aAttribute', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIXIN_ATTRIBUTE));
} else {
if ($iMediaType == Model_Media::TYPE_FRIEND) {
// 微信朋友圈
$this->assign('aAttribute', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_FRIEND_ATTRIBUTE));
} else {
if ($iMediaType == Model_Media::TYPE_WEIBO) {
// 新浪微博
$this->assign('aAttribute', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIBO_ATTRIBUTE));
} else {
if ($iMediaType == Model_Media::TYPE_NEWS) {
// 新闻&论坛
$this->assign('aAttribute', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_NEWS_ATTRIBUTE));
}
}
}
}
//分类
if ($iMediaType == Model_Media::TYPE_WEIXIN) {
// 微信公众号
$this->assign('aTypeInfo', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIXIN_CATEGORY));
} else {
if ($iMediaType == Model_Media::TYPE_FRIEND) {
// 微信朋友圈
$this->assign('aTypeInfo', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_FRIEND_CATEGORY));
} else {
if ($iMediaType == Model_Media::TYPE_WEIBO) {
// 新浪微博
$this->assign('aTypeInfo', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIBO_CATEGORY));
} else {
if ($iMediaType == Model_Media::TYPE_NEWS) {
// 新闻&论坛
$this->assign('aTypeInfo', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_NEWS_CATEGORY));
}
}
}
}
//合作等级
if ($iMediaType == Model_Media::TYPE_WEIXIN) {
// 微信公众号
$this->assign('aCooperateLevel', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIXIN_COOPERATELEVEL));
} else {
if ($iMediaType == Model_Media::TYPE_FRIEND) {
// 微信朋友圈
$this->assign('aCooperateLevel', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_FRIEND_COOPERATELEVEL));
} else {
if ($iMediaType == Model_Media::TYPE_WEIBO) {
// 新浪微博
$this->assign('aCooperateLevel', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIBO_COOPERATELEVEL));
} else {
if ($iMediaType == Model_Media::TYPE_NEWS) {
// 新闻&论坛
$this->assign('aCooperateLevel', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_NEWS_COOPERATELEVEL));
}
}
}
}
//行业圈子
if ($iMediaType == Model_Media::TYPE_WEIXIN) {
// 微信公众号
$this->assign('aIndustryCircle', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIXIN_INDUSTRY));
} else {
if ($iMediaType == Model_Media::TYPE_FRIEND) {
// 微信朋友圈
$this->assign('aIndustryCircle', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_FRIEND_INDUSTRY));
} else {
if ($iMediaType == Model_Media::TYPE_WEIBO) {
// 新浪微博
$this->assign('aIndustryCircle', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIBO_INDUSTRY));
} else {
if ($iMediaType == Model_Media::TYPE_NEWS) {
// 新闻&论坛
$this->assign('aIndustryCircle', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_NEWS_INDUSTRY));
}
}
}
}
//认证
if ($iMediaType == Model_Media::TYPE_WEIXIN) {
// 微信公众号
$this->assign('aVerifyState', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIXIN_VERIFY));
} else {
if ($iMediaType == Model_Media::TYPE_WEIBO) {
// 新浪微博
$this->assign('aVerifyState', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIBO_VERIFY));
}
}
//标签
if ($iMediaType == Model_Media::TYPE_WEIXIN) {
// 微信公众号
$this->assign('aTag', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIXIN_TAG));
} else {
if ($iMediaType == Model_Media::TYPE_FRIEND) {
// 微信朋友圈
$this->assign('aTag', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_FRIEND_TAG));
} else {
if ($iMediaType == Model_Media::TYPE_WEIBO) {
// 新浪微博
$this->assign('aTag', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_WEIBO_TAG));
} else {
if ($iMediaType == Model_Media::TYPE_NEWS) {
// 新闻&论坛
$this->assign('aTag', Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_NEWS_TAG));
}
}
}
}
//资源推荐
$aRecommend = Model_Domain::getPairDomain(Model_Domain::TYPE_MEDIA_RECOMMEND);
$this->assign('aRecommend', $aRecommend);
//后台管理用户
$adminData = Model_Admin::getAll(array('where' => array('iStatus' => 1)));
$this->assign('adminData', $adminData);
//城市
$this->assign('aCity', Model_City::getPairCitys());
}
/**
* 导出
*/
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 addAction()
{
if ($this->isPost()) {
$iAdID = (int) $this->getParam('id');
$aAd = null;
if ($iAdID > 0) {
$aAd = Model_Ad::getDetail($iAdID);
if ($aAd['iUserID'] != $this->aCurrUser['iUserID']) {
return $this->showMsg('不要乱改别人的数据', false);
}
}
$aData = array();
$aData['iUserID'] = $this->aCurrUser['iUserID'];
$aData['iMediaType'] = (int) $this->getParam('iMediaType');
$aData['iAdType'] = (int) $this->getParam('iAdType');
$aData['sAdName'] = $this->getParam('sAdName');
$aData['iPlanMinMoney'] = (int) $this->getParam('iPlanMinMoney');
$aData['iPlanMaxMoney'] = (int) $this->getParam('iPlanMaxMoney');
$aData['sCatID'] = (int) $this->getParam('sCatID');
$aAdType = $this->getParam('aAdType');
$aCityID = $this->getParam('aCityID');
$aErr = array();
if (!Util_Validate::isLength($aData['sAdName'], 2, 50)) {
$aErr['sAdName'] = '请输入推广名称';
}
if ($aData['iPlanMinMoney'] > $aData['iPlanMaxMoney']) {
$aErr['iPlanMoney'] = '后者数字必须大于前者数字';
}
/*
* if (empty($aAdType)) { $aErr['aAdType'] = '请选择广告类型'; } if (empty($aCatID)) { $aErr['aCatID'] = '请选择媒体类别'; }
*/
/*
* if (empty($aCityID)) { $aErr['aCityID'] = '请选择城市/地区'; }
*/
if (!empty($aCityID) && count($aCityID) > 3) {
$aErr['aCityID'] = '最多选择3个城市/地区';
}
// 判断该自媒是否已经存在
if (!empty($aData['sAdName'])) {
$aOtherAd = Model_Ad::getAdByName($aData['iUserID'], $aData['sAdName'], $iAdID);
if (!empty($aOtherAd) && $aOtherAd['iStatus'] != Model_Ad::STATUS_DELETE) {
$aErr['sAdName'] = '该推广计划已经存在！';
}
}
if (!empty($aErr)) {
return $this->showMsg($aErr, false);
}
/*
* if (count($aAdType) == 2) { $aData['iAdType'] = 3; } else { $aData['iAdType'] = array_pop($aAdType); }
*/
$aData['sCityID'] = empty($aCityID) ? '' : join(',', $aCityID);
$aData['iStatus'] = Model_Ad::STATUS_WRITING;
if (empty($aAd)) {
$iAdID = Model_Ad::addData($aData);
} else {
$aData['iAdID'] = $aAd['iAdID'];
Model_Ad::updData($aData);
}
Model_User::updData(array('iUserID' => $this->aCurrUser['iUserID'], 'iFirst' => 'iFirst + 1'));
if ($iAdID > 0) {
return $this->showMsg($iAdID, true);
} else {
$aErr['sAdName'] = '添加失败，请稍后再试';
return $this->showMsg($aErr, false);
}
} else {
$iAdID = intval($this->getParam('id'));
$aAd = null;
if ($iAdID > 0) {
$aAd = Model_Ad::getDetail($iAdID);
}
if (empty($aAd)) {
$iType = intval($this->getParam('type', Model_Media::TYPE_WEIXIN));
} else {
$iType = $aAd['iMediaType'];
$aAd['aCityID'] = explode(',', $aAd['sCityID']);
$aAd['aCatID'] = explode(',', $aAd['sCatID']);
}
$aData = array();
switch ($iType) {
case Model_Media::TYPE_WEIXIN:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIXIN_CATEGORY);
// $aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIXIN_TAG);
break;
case Model_Media::TYPE_FRIEND:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_FRIEND_CATEGORY);
// $aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_FRIEND_TAG);
break;
case Model_Media::TYPE_WEIBO:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIBO_CATEGORY);
// $aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIBO_TAG);
break;
case Model_Media::TYPE_NEWS:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_NEWS_CATEGORY);
// $aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_NEWS_TAG);
break;
}
$aData['aAdType'] = array(1 => '软广', 2 => '硬广');
$aData['aCity'] = Model_City::getPairCitys(Model_City::TYPE_FRONT);
$aType = Model_Media::$aType;
unset($aType[Model_Media::TYPE_NEWS]);
$this->assign('iType', $iType);
$this->assign('aType', $aType);
$this->assign('aData', $aData);
$this->assign('aAd', $aAd);
$this->assign('aUser', Model_User::getDetail($this->aCurrUser['iUserID']));
$this->assign('sTopMenu', 'aadd');
$this->setMeta('ad_add', array('sTitle' => '添加推广计划'));
}
}
* This file was automatically generated By Code Smith
* Modifications will be overwritten when code smith is run
*
* PLEASE DO NOT MAKE MODIFICATIONS TO THIS FILE
* Date Created 5/6/2012
*
*/
/// <summary>
/// Implementations of slcitys represent a City
///
/// </summary>
chdir("..");
/* TODO: Add code here */
require 'config/globalconfig.php';
include_once 'class/model_city.php';
$objCity = new Model_City($objConnection);
if ($_pgR["act"] == model_City::ACT_ADD) {
if (global_common::isCLogin()) {
//get user info
//$c_userInfo = $_SESSION[consts::SES_C_USERINFO];
//if ($objMenu->getMenuByName($_pgR['name'])) {
// echo global_common::convertToXML($arrHeader, array("rs",'info'), array(0,global_common::STRING_NAME_EXIST), array(0,1));
// return;
//}
$cityID = $_pgR['CityID'];
$cityID = global_editor::rteSafe(html_entity_decode($cityID, ENT_COMPAT, 'UTF-8'));
$cityName = $_pgR['CityName'];
$cityName = global_editor::rteSafe(html_entity_decode($cityName, ENT_COMPAT, 'UTF-8'));
$status = $_pgR['Status'];
$status = global_editor::rteSafe(html_entity_decode($status, ENT_COMPAT, 'UTF-8'));
//$strName = $_pgR['name'];
public function actionAfter()
{
parent::actionAfter();
$aCurrentCity = Model_City::getCityByID($this->iCurrCityID);
$this->assign('aCurrentCity', $aCurrentCity);
$this->_assignUrl();
}
/**
* 请求数据检测
*
* @return mixed
*/
public function _checkData($sType = 'add')
{
$sAdminName = $this->getParam('sAdminName');
$sPassword = $this->getParam('sPassword');
$sMobile = $this->getParam('sMobile');
$sEmail = $this->getParam('sEmail');
$sRealName = $this->getParam('sRealName');
$iCityID = $this->getParam('iCityID');
$aCityID = $this->getParam('aCityID');
$sAllCityID = $this->getParam('sAllCityID');
$aRoleID = $this->getParam('aRoleID');
$sAdminID = $this->getParam('sAdminID');
if (!Util_Validate::isLength($sAdminName, 3, 50)) {
return $this->showMsg('用户名长度范围为3到30个字！', false);
}
if (($sType == 'add' || !empty($sPassword)) && !Util_Validate::isLength($sPassword, 6, 20)) {
return $this->showMsg('登录密码长度范围为6到20字符！', false);
}
if (!Util_Validate::isMobile($sMobile)) {
return $this->showMsg('输入的手机号码不合法！', false);
}
if (!Util_Validate::isEmail($sEmail)) {
return $this->showMsg('输入的邮箱地址不合法！', false);
}
if (!Util_Validate::isLength($sRealName, 2, 20)) {
return $this->showMsg('真实姓名长度范围为2到20字符！', false);
}
$aCity = Model_City::getPairCitys();
if (!isset($aCity[$iCityID])) {
return $this->showMsg('选择的城市不存在！', false);
}
// 将默认城市加入到城市权限中
if ($sAllCityID == '1') {
$aCityID = array(-1);
} elseif (empty($aCityID) || !in_array($iCityID, $aCityID)) {
$aCityID[] = $iCityID;
}
// 将默认城市加入到城市权限中
if ($sAdminID == '1') {
$aRoleID = array(-1);
} elseif (empty($aRoleID)) {
return $this->showMsg('请至少选择一个角色!', false);
}
$aRow = array('sAdminName' => $sAdminName, 'sMobile' => $sMobile, 'sEmail' => $sEmail, 'sRealName' => $sRealName, 'iCityID' => $iCityID, 'sCityID' => join(',', $aCityID), 'sRoleID' => join(',', $aRoleID));
if (!empty($sPassword)) {
$aRow['sPassword'] = md5(Yaf_G::getConf('cryptkey', 'cookie') . $sPassword);
}
return $aRow;
}
public function getRetailerByID($objID, $selectField = '*')
{
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_RETAILER, 'WHERE RetailerID = \'' . $objID . '\' '));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get sl_retailer ByID:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$retailer = $arrResult[0];
$objStatus = new Model_Status($this->_objConnection);
$objCity = new Model_City($this->_objConnection);
$city = $objCity->getCityByID($retailer[global_mapping::CityID]);
$retailer[global_mapping::CityName] = $city[global_mapping::CityName];
$status = $objStatus->getStatusByID($retailer[global_mapping::ProductStatusID]);
$retailer[global_mapping::StatusName] = $status[global_mapping::StatusName];
//print_r($arrResult);
return $retailer;
}
public function editAction()
{
$Acl = Zend_Registry::get('acl');
$auth = Zend_Auth::getInstance();
$State = new Model_State();
$City = new Model_City();
$Neighborhood = new Model_Neighborhood();
$Appraiser = new Model_Appraiser();
$appraiserId = $this->_getParam('id');
$appraiserRow = $this->modelUser->getUserById($appraiserId);
if (!$appraiserRow) {
throw new Exception('invalid appraiser.');
}
$this->view->appraiserRow = $appraiserRow;
$listAdmin = false;
$userLoggedRow = $this->userAuth;
$userLocality = $this->modelUserLocality->getUserLocalityByUserId($userLoggedRow->getUserId());
$roleRow = $this->aclModel->getRoleById($userLoggedRow->getRoleId(), false);
$page = $this->_getParam('page', 1);
$count = $this->_getParam('count', 10);
$this->view->page = $page;
$this->view->itensPage = $count;
$filter = $this->_getParam('filter', null);
$this->view->filter = $filter;
$this->view->getAllStates = $State->getAll();
if (isset($filter['state_id']) and !empty($filter['state_id'])) {
$this->view->getAllCities = $City->getAllCityByStateId($filter['state_id']);
}
if (isset($filter['city_id']) and !empty($filter['city_id'])) {
$this->view->getAllNeighborhoods = $Neighborhood->getAllNeighborhoodByCityId($filter['city_id']);
}
// Listagem dos Avaliadores pelo admin
if ($roleRow->getIsSystemAdmin() == 1) {
// eh admin
// lista Empresas
$getAllEnterprise = $this->Enterprise->getAllWithRa($this->autoavaliacaoId, $count, $page, $filter);
$this->view->getAllEnterpriseByRegionalServiceArea = $getAllEnterprise;
//--
$getAllRegional = $this->modelRegional->getAll();
$this->view->getAllRegional = $getAllRegional;
$listAdmin = true;
}
// Listagem dos Avaliadores pelo gestor
if ($Acl->isAllowed($auth->getIdentity()->getRole(), 'management:appraiser', 'list-appraiser-by-regional-service-area')) {
if (!$listAdmin) {
$userLocality = $this->modelUserLocality->getUserLocalityByUserId($userLoggedRow->getUserId());
//$regionalId = ($filter['regional_id'])?$filter['regional_id']:$userLocality->getRegionalId();
$regionalIdUserLogged = $userLocality->getRegionalId();
$this->view->getAllRegional = $this->dbTable_Regional->getAllRegionalByOneRegionalServiceArea($this->roleAppraiserId, $regionalIdUserLogged, 'all', $filter);
// Listar Empresas por RegionalSA
$getAllEnterpriseByRegionalServiceArea = $this->Enterprise->getAllEnterpriseByRegionalServiceArea($regionalIdUserLogged, $count, $page, $filter);
$this->view->getAllEnterpriseByRegionalServiceArea = $getAllEnterpriseByRegionalServiceArea;
//--
}
}
if ($filter) {
return;
}
if (!$this->getRequest()->isPost()) {
return;
}
}
public function getUserByID($objID, $selectField = '*')
{
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_USER, 'WHERE UserID = \'' . $objID . '\' '));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get sl_user ByID:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$objCity = new Model_City($this->_objConnection);
$city = $objCity->getCityByID($arrResult[0][global_mapping::CityID]);
$arrResult[0][global_mapping::CityName] = $city[global_mapping::CityName];
//print_r($arrResult);
if (!$arrResult[0][global_mapping::Avatar]) {
if ($arrResult[0][global_mapping::Sex]) {
$arrResult[0][global_mapping::Avatar] = global_common::DEFAUTL_MALE_AVATAR;
} else {
$arrResult[0][global_mapping::Avatar] = global_common::DEFAUTL_FEMALE_AVATAR;
}
}
return $arrResult[0];
}
/**
* 增加城市
*/
public function addAction()
{
if ($this->_request->isPost()) {
//修改密码验证
$aCookie = Util_Cookie::get(Yaf_G::getConf('authkey', 'cookie'));
$iAdminID = $aCookie['iAdminID'];
$aUser = Model_Admin::getDetail($iAdminID);
$pwd = $this->getParam('pwd');
if (!isset($pwd) || $pwd == '') {
return $this->showMsg('修改密码不可以为空', false);
}
if ($aUser['sEditPassword'] != md5($pwd)) {
return $this->showMsg('修改密码不正确', false);
}
$aCity = $this->_checkData('add');
if (empty($aCity)) {
return null;
}
if (Model_City::getCityByName($aCity['sCityName'])) {
return $this->showMsg('城市已经存在！', false);
}
if (Model_City::addData($aCity) > 0) {
return $this->showMsg('城市增加成功！', true);
} else {
return $this->showMsg('城市增加失败！', false);
}
}
}
/**
* 添加自媒体
*/
public function addAction()
{
if ($this->isPost()) {
$aUser = $this->getCurrUser(Model_User::TYPE_MEDIA);
if (empty($aUser)) {
return $this->showMsg('请先登录！', false);
}
$iMediaID = (int) $this->getParam('iMediaID');
$aMedia = null;
if ($iMediaID > 0) {
$aMedia = Model_Media::getDetail($iMediaID);
if ($aMedia['iUserID'] != $aUser['iUserID']) {
return $this->showMsg('不要乱改别人的数据', false);
}
}
$aData = array();
$aData['iUserID'] = $aUser['iUserID'];
$aData['iMediaType'] = (int) $this->getParam('iMediaType');
$aData['sMediaName'] = $this->getParam('sMediaName');
$aData['sOpenName'] = $this->getParam('sOpenName');
$aData['iFollowerNum'] = (int) $this->getParam('iFollowerNum');
$aData['sFollowerImg'] = $this->getParam('sFollowerImg');
$aData['sAvatar'] = $this->getParam('sAvatar');
$aData['sQRCode'] = $this->getParam('sQRCode');
$aErr = array();
switch ($aData['iMediaType']) {
case Model_Media::TYPE_WEIXIN:
if ($aData['iFollowerNum'] == 0) {
$aErr['iFollowerNum'] = '请输入丝粉数量';
}
if (!Util_Validate::isLength($aData['sMediaName'], 2, 50)) {
$aErr['sMediaName'] = '请输入微信名称';
}
if (!preg_match('/[a-z][0-9a-z_\\-]{5,19}/i', $aData['sOpenName'])) {
$aErr['sOpenName'] = '请输入正确的微信帐号';
}
if (empty($aData['sFollowerImg'])) {
$aErr['sFollowerImg'] = '请上传粉丝数截图';
}
if (empty($aData['sAvatar'])) {
$aErr['sAvatar'] = '请上传微信头像';
}
if (empty($aData['sQRCode'])) {
$aErr['sQRCode'] = '请上传二维码';
}
$aOtherMedia = Model_Media::getMediaByOpenName($aData['iMediaType'], $aData['sOpenName'], $iMediaID);
if (!empty($aOtherMedia)) {
$aErr['sOpenName'] = '该自媒体已经存在！';
}
break;
case Model_Media::TYPE_FRIEND:
if (empty($aData['sMediaName'])) {
$aErr['sMediaName'] = '请输入账号名称';
}
if ($aData['iFollowerNum'] == 0) {
$aErr['iFollowerNum'] = '请输入好友数量';
}
if (empty($aData['sFollowerImg'])) {
$aErr['sFollowerImg'] = '请上传好友数截图';
}
if (empty($aData['sAvatar'])) {
$aErr['sAvatar'] = '请上传你微信头像';
}
// 判断该自媒是否已经存在
$aOtherMedia = Model_Media::getMediaByName($aData['iMediaType'], $aData['sMediaName'], $iMediaID);
if (!empty($aOtherMedia)) {
$aErr['sMediaName'] = '该微信帐号已经存在！';
}
break;
case Model_Media::TYPE_WEIBO:
if (empty($aData['sMediaName'])) {
$aErr['sMediaName'] = '请输入账号名称';
}
if ($aData['iFollowerNum'] == 0) {
$aErr['iFollowerNum'] = '请输入好友数量';
}
if (empty($aData['sFollowerImg'])) {
$aErr['sFollowerImg'] = '请上传好友数截图';
}
if (empty($aData['sAvatar'])) {
$aErr['sAvatar'] = '请上传你微博头像';
}
$aData['sUrl'] = $this->getParam('sUrl');
if (!Util_Validate::isAbsoluteUrl($aData['sUrl'])) {
$aErr['sUrl'] = '请输入正确的微博地址';
}
// 判断该自媒是否已经存在
$aOtherMedia = Model_Media::getMediaByName($aData['iMediaType'], $aData['sMediaName'], $iMediaID);
if (!empty($aOtherMedia)) {
$aErr['sMediaName'] = '该微博帐号已经存在！';
}
break;
}
$aCatID = $this->getParam('aCatID');
$aCityID = $this->getParam('aCityID');
$aTagID = $this->getParam('aTagID');
// if (empty($aCatID)) {
// $aErr['aCatID'] = '请选择媒体类别';
// }
// if (! empty($aCatID) && count($aCatID) > 3) {
// $aErr['aCatID'] = '最多选择3个媒体类别';
// }
if (empty($aTagID)) {
$aErr['aTagID'] = '请选择媒体标签';
}
if (!empty($aTagID) && count($aTagID) > 6) {
$aErr['aTagID'] = '最多选择6个媒体标签';
}
if (empty($aCityID)) {
$aErr['aCityID'] = '请选择城市/地区';
}
if (!empty($aCityID) && count($aCityID) > 3) {
$aErr['aCityID'] = '最多选择3个城市/地区';
}
if (!empty($aErr)) {
return $this->showMsg($aErr, false);
}
if (empty($aMedia)) {
$aData['iStatus'] = 3;
$aData['sVerifyCode'] = strtoupper(Util_Tools::passwdGen(32));
$iMediaID = Model_Media::addData($aData);
} else {
$aData['iStatus'] = 2;
$aData['iMediaID'] = $aMedia['iMediaID'];
Model_Media::updData($aData);
}
Model_User::updData(array('iUserID' => $this->aCurrUser['iUserID'], 'iFirst' => 'iFirst + 1'));
if ($iMediaID > 0) {
//Model_Media::updCategory($iMediaID, $aCatID);
Model_Media::updCity($iMediaID, $aCityID);
Model_Media::updTag($iMediaID, $aTagID);
return $this->showMsg($iMediaID, true);
} else {
$aErr['sMediaName'] = '添加失败，请稍后再试';
return $this->showMsg($aErr, false);
}
} else {
$aUser = $this->getCurrUser(Model_User::TYPE_MEDIA);
if (empty($aUser)) {
return $this->redirect('/user/login/type/' . Model_User::TYPE_MEDIA . '.html?ret=' . Util_Uri::getCurrUrl());
}
$iMediaID = intval($this->getParam('id'));
$aMedia = null;
if ($iMediaID > 0) {
$aMedia = Model_Media::getFullDetail($iMediaID);
}
if (empty($aMedia)) {
$iType = intval($this->getParam('type', Model_Media::TYPE_WEIXIN));
} else {
$iType = $aMedia['iMediaType'];
}
$aData = array();
switch ($iType) {
case Model_Media::TYPE_WEIXIN:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIXIN_CATEGORY);
$aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIXIN_TAG);
break;
case Model_Media::TYPE_FRIEND:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_FRIEND_CATEGORY);
$aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_FRIEND_TAG);
break;
case Model_Media::TYPE_WEIBO:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIBO_CATEGORY);
$aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_WEIBO_TAG);
break;
case Model_Media::TYPE_NEWS:
$aData['aCategory'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_NEWS_CATEGORY);
$aData['aTag'] = Model_Domain::getOption(Model_Domain::TYPE_MEDIA_NEWS_TAG);
break;
}
$aData['aCity'] = Model_City::getPairCitys(Model_City::TYPE_FRONT);
// array_unshift($aData['aCategory'], '不限');
// array_unshift($aData['aCity'], '不限');
// array_unshift($aData['aTag'], '不限');
$aType = Model_Media::$aType;
unset($aType[Model_Media::TYPE_NEWS]);
$this->assign('iType', $iType);
$this->assign('aType', $aType);
$this->assign('aData', $aData);
$this->assign('aMedia', $aMedia);
$this->assign('aUser', Model_User::getDetail($this->aCurrUser['iUserID']));
$this->assign('sTopMenu', 'madd');
$sRandCode = Util_Tools::passwdGen(8, Util_Tools::FLAG_ALPHANUMERIC);
Util_Cookie::set('media_verify_code', $sRandCode);
$this->assign('sRandCode', $sRandCode);
$this->setMeta('media_add', array('sTitle' => '添加媒体'));
}
}
public function indexAction()
{
if (!isset($this->tipoRelatorio)) {
$this->tipoRelatorio = 'inscricoes';
}
$State = new Model_State();
$City = new Model_City();
$model_Metier = new Model_Metier();
$dbTable_Regional = new DbTable_Regional();
$modelUserLocality = new Model_UserLocality();
$modelRegional = new Model_Regional();
$Neighborhood = new Model_Neighborhood();
$Regiao = new Model_Regiao();
$Configuration = new Model_Configuration();
$modelEnterpriseCategoryAward = new Model_EnterpriseCategoryAward();
$enterprise = new Model_Enterprise();
$ApeEvaluationVerificador = new Model_ApeEvaluationVerificador();
// Sandra - acessar ciclo atual
$currentYearRow = $Configuration->getConfigurationByConfKey('competitionIdKey');
$this->view->ciclo = $currentYearRow->getConfValue();
$this->view->cicloAnt = $this->view->ciclo - 1;
$format = $this->_getParam('format');
$this->view->getAllEducations = $this->Education->getAll();
if ($format == 'csv') {
//$this->view->getAllPosition = $this->modelPosition->getAll();
$this->_dorelatorio();
$this->incluirJoinPontuacao = '1';
$this->incluirJoinRegional = '1';
}
set_time_limit(720);
//6 minutos
$ns = new Zend_Session_Namespace('respond');
$ns->enterpriseUserId = null;
//constroi url para CSV
$this->view->urlParaGerarCsv = $this->_construirUrlParaCsv();
$this->view->getAllEnterpriseCategoryAward = $modelEnterpriseCategoryAward->getAll();
//finalistas estaduais
$this->view->getAllApeEvaluationVerificador = $ApeEvaluationVerificador->getAll();
//$this->view->getAllAnswerVerificador = $modelAnswerVerificador->getAllScore();
$this->view->getAllRegiao = $Regiao->getAll();
$this->view->getAllMetier = $model_Metier->getAll();
$this->view->isRanking = isset($this->view->isRanking) ? $this->view->isRanking : false;
$this->filterAdditional = isset($this->filterAdditional) ? $this->filterAdditional : $this->_getParam('filter');
$filter = $this->filterAdditional;
$this->view->filter = $filter;
$this->view->hasFilterRegional = true;
$this->view->hasFilterStatus = true;
$this->view->getAllStates = $State->getAll();
if (isset($filter['state_id']) and !empty($filter['state_id'])) {
$this->view->getAllCities = $City->getAllCityByStateId($filter['state_id']);
}
if (isset($filter['city_id']) and !empty($filter['city_id'])) {
$this->view->getAllNeighborhoods = $Neighborhood->getAllNeighborhoodByCityId($filter['city_id']);
}
$this->view->competitionId = Zend_Registry::get('configDb')->competitionId;
$this->view->getAllCompetition = $this->modelCompetition->getAllCompetition();
$userLoggedRow = $this->userAuth;
//$roleRow = $this->aclModel->getRoleById($userLoggedRow->getRoleId(), false);
$page = $this->_getParam('page');
$count = $this->_getParam('count', 10);
$this->orderBy = isset($this->orderBy) ? $this->orderBy : null;
$orderBy = $this->view->orderBy = $this->_getParam('orderBy', $this->orderBy);
$filter['appraiser_id'] = isset($filter['appraiser_id']) ? $filter['appraiser_id'] : null;
$filter['incluir_join_pontuacao'] = isset($this->incluirJoinPontuacao) ? $this->incluirJoinPontuacao : '0';
$filter['incluir_join_regional'] = isset($this->incluirJoinRegionalForce) ? $this->incluirJoinRegionalForce : (isset($this->incluirJoinRegional) ? $this->incluirJoinRegional : '0');
$this->view->regionalOption = 'Minha';
// List Coop by Regional
$regionalId = $modelUserLocality->getUserLocalityByUserId($userLoggedRow->getUserId())->getRegionalId();
$this->view->getAllRegional = $getAllRegional = $dbTable_Regional->getAllRegionalByOneRegionalServiceArea(null, $regionalId, 'all', $filter);
// $this->roleAppraiserId
if (isset($filter['regional_id']) and $filter['regional_id']) {
$regionalId = $filter['regional_id'];
}
if ($this->showAppraisersFilter) {
//$filterAp['status'] = 'A'; ,$filterAp
$this->view->getAllAppraisers = $this->dbTableUser->getAllAppraiserByRegionalServiceArea(null, $regionalId, array('appraiser_status' => 'able'));
}
if (!$format) {
return;
}
$groupBy = in_array($this->tipoRelatorio, array('inscricoes', 'ranking', 'classificadas', 'finalistas', 'finalistas-nacional', 'candidatas-nacional', 'classificadas-nacional')) ? 'enterprise_id' : null;
$this->regionalId = $regionalId;
$this->filter = $filter;
$this->paramsBuscaServiceArea = $regionalId ? $modelRegional->getServiceAreaByRegionalId($regionalId) : array(0 => null, 1 => null);
$fetchReturn = isset($this->fetchReturnForce) ? $this->fetchReturnForce : (isset($this->fetchReturn) ? $this->fetchReturn : 'paginator');
if ($this->tipoRelatorio != 'inscricoes' || $format == 'csv') {
$this->view->getAllEnterprise = $this->Enterprise->getAllByColAE($this->paramsBuscaServiceArea[0], $this->paramsBuscaServiceArea[1], $this->autoavaliacaoId, $count, $page, $filter, $orderBy, $format, $fetchReturn, $this->tipoRelatorio, $groupBy);
} else {
$loggedUserId = $this->userAuth->getUserId();
$this->view->getAllEnterprise = $this->Enterprise->getPaginatorForSubscriptions($loggedUserId, $filter, $count, $page);
}
$this->view->modelEntCategoryAward = new Model_EnterpriseCategoryAwardCompetition();
}
public function cityAction()
{
$results = Model_City::search($this->_getParam('term'));
$this->_helper->json(array_values($results));
}
/* TODO: Add code here */
require 'config/globalconfig.php';
include_once 'class/model_articletype.php';
include_once 'class/model_product.php';
include_once 'class/model_user.php';
include_once 'class/model_article.php';
include_once 'class/model_manufactory.php';
include_once 'class/model_property.php';
include_once 'class/model_productproperty.php';
include_once 'class/model_propertygroup.php';
include_once 'class/model_datatype.php';
include_once 'class/model_adtype.php';
include_once 'class/model_city.php';
//get catId from _article.inc
//$catID = $_pgR['cid'];
$objCity = new Model_City($objConnection);
$allCities = $objCity->getAllCity();
$page = $_pgR["p"] ? $_pgR["p"] : 1;
if (!$_pgR["cid"]) {
global_common::redirectByScript("index.php");
}
$keyword = $_pgR['kw'];
$objArticleType = new model_ArticleType($objConnection);
$objProduct = new Model_Product($objConnection);
$objProductProperty = new Model_ProductProperty($objConnection);
$objManufactory = new Model_Manufactory($objConnection);
$catID = $_pgR['cid'];
//Just get from "article_list.php"
//$district = $_pgR['ds'];
$keyword = $_pgR['kw'];
$manu = $_pgR['manu'];
public function getStoreByIDs($arrIDs)
{
$arrIDs = global_common::splitString($arrIDs);
$strQueryIN = global_common::convertToQueryIN($arrIDs);
if ($strQueryIN) {
$strQueryIN = global_mapping::StoreID . ' IN (' . $strQueryIN . ')';
} else {
$strQueryIN = '1=1';
}
$whereClause = 'WHERE ' . $strQueryIN;
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', self::TBL_SL_STORE, $whereClause . ' ' . ' limit 0,' . self::NUM_PER_PAGE));
//echo $strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get getProductByIDs:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$objCity = new Model_City($this->_objConnection);
$objDistrict = new Model_District($this->_objConnection);
$tempVarCities = $objCity->getAllCity();
$allCities = null;
foreach ($tempVarCities as $key => $info) {
$allCities[$info[global_mapping::CityID]] = $info;
unset($tempVarCities[$key]);
}
$tempDistricts = $objDistrict->getAllDistrict();
$allDistricts = null;
foreach ($tempDistricts as $key => $info) {
$allDistricts[$info[global_mapping::DistrictID]] = $info;
unset($tempDistricts[$key]);
}
// print_r($allDistricts);
// return;
$count = count($arrResult);
$objArticle = new Model_Article($this->_objConnection);
for ($i = 0; $i < $count; $i++) {
//echo $arrResult;
//print_r( $allCities);
//$arrResult[$i][global_mapping::CityID] = $allCities[$arrResult[$i][global_mapping::CityID]];
$arrResult[$i][global_mapping::CityName] = $allCities[$arrResult[$i][global_mapping::CityID]][global_mapping::CityName];
// print_r($arrResult[$i]);
//return;
// print_r($allCities[$arrResult[$i][global_mapping::CityID]]);
//break;
$arrResult[$i][global_mapping::DistrictName] = $allDistricts[$arrResult[$i][global_mapping::DistrictID]][global_mapping::DistrictName];
$arrResult[$i][global_mapping::Latitude] = global_common::convertToDecimal($arrResult[$i][global_mapping::Latitude]);
$arrResult[$i][global_mapping::Longitude] = global_common::convertToDecimal($arrResult[$i][global_mapping::Longitude]);
$arrArticle = $objArticle->getArticleByStoreID($arrResult[$i][global_mapping::StoreID]);
$shortDescription = global_common::formatPlanText($arrArticle[0][global_mapping::Content]);
$arrResult[$i][global_mapping::Content] = global_common::cutString2($shortDescription, 0, 16);
// print_r($arrResult[$i]);
//echo $arrResult[$i][global_mapping::DistrictID];
//echo $allDistricts[$arrResult[$i][global_mapping::DistrictID]][global_mapping::DistrictName];
//print_r($allDistricts);
//return ;
}
//print_r($stores);
return $arrResult;
}
