function GetDevloper($Type = null, $status = null, $limit = null, $UserType = null) { App::import('Model', 'Advertise'); $objAdvertise = new Advertise(); $objAdvertise->bindModel(array('belongsTo' => array('User' => array('foreignKey' => 0, 'conditions' => 'Advertise.user_id = User.id'))), false); $condition = array('Advertise.category_type in (' . $Type . ')', "Advertise.status" => $status, 'User.user_type_id in (' . $UserType . ')'); $AdvertisearrData = $objAdvertise->find("all", array("conditions" => $condition, 'order' => array('Advertise.modified' => 'DESC'), 'limit' => $limit)); return $AdvertisearrData; }
public static function get_all_advertise($connection) { $statement = $connection->prepare("SELECT * FROM advertise"); $statement->execute(); $result = $statement->get_result(); $advertises = array(); while ($row = $result->fetch_assoc()) { $advertise = new Advertise(); $advertise->set_email($row["email"]); $advertise->set_title($row["title"]); $advertise->set_content($row["content"]); array_push($advertises, $advertise); } return $advertises; }
public function testMerge() { $adv = Advertise::model()->findByPk(23); $map = array(); foreach ($adv->advChannels as $advChannel) { $map[$advChannel->tag] = $advChannel; } }
private function getAdvId($name) { $model = Advertise::model()->findByAttributes(array('name' => $name)); if ($model) { return $model->id; } return 0; }
public function actionImport() { while ($row = fgets(STDIN)) { $row = trim($row); if (!$row) { continue; } $row = preg_replace('/\\s+/', "\t", $row); list($name, $income_price, $outcome_price) = explode("\t", $row); $advertise = new Advertise(); $advertise->cp_id = 100000; $advertise->name = $name; $advertise->income_price = $income_price; $advertise->outcome_price = $outcome_price; echo $name, ":", $advertise->save(), "\n"; } }
/** * This is the default 'index' action that is invoked * when an action is not explicitly requested by users. */ public function actionIndex() { $user = Yii::app()->user; if (Yii::app()->request->isPostRequest) { $type = $_POST['type']; if ($type == 'login') { $identity = new UserIdentity($_POST['LoginForm']['email'], $_POST['LoginForm']['password']); if ($identity->authenticate()) { $user->login($identity); $this->redirect('/'); } else { } } return; } // renders the view file 'protected/views/site/index.php' // using the default layout 'protected/views/layouts/main.php' if ($user->isGuest) { $this->render('login', array('userinput' => Yii::app()->request->isPostRequest ? $_POST['LoginForm'] : array())); } else { $criteria = new CDbCriteria(); if ($user->isChannel()) { if ($user->getChannelId()) { $criteria->compare('channel_id', Yii::app()->user->getChannelId()); } else { echo '此账户尚未开通,请联系管理员'; return; } } else { //管理员 $channel_id = $user->getChannelId(); if ($user->getChannelId()) { $criteria->compare('channel_id', Yii::app()->user->getChannelId()); } } //添加搜索条件 if ($_GET) { $tag = $_GET['tag']; $adv_name = $_GET['adv_name']; $adv_id = ""; if ($adv_name) { $advertise = Advertise::model(); $adv_id = $advertise->getAdvId($adv_name); } $startTime = $_GET['startTime']; $endTime = $_GET['endTime']; $criteria->compare('tag', $tag); $criteria->compare('adv_id', $adv_id); if ($startTime) { $criteria->addBetweenCondition('date', $startTime, $endTime); } } $criteria->order = "date desc"; $dataProvider = new CActiveDataProvider('AdvData', array('criteria' => $criteria, 'pagination' => array('pageSize' => 20, 'pageVar' => 'page'))); $this->render('index', array('attributes' => array('date', 'adv.name', 'tag', 'download_number', 'price', 'total_price', 'star_level'), 'current_channel_id' => $user->getChannelId(), 'channels' => Yii::app()->user->isAdmin() ? Channel::model()->findAll() : array(), 'dataProvider' => $dataProvider)); } }
/** * @return string * * 返回表的名字 */ public function getTableName() { $filters = $this->getFilterCondition(); if (isset($filters['adv_id'])) { $model = Advertise::model()->findByPk($filters['adv_id']); if ($model) { return $model->cp->name . '-' . $model->name . ' 渠道列表'; } } return '业务-渠道列表'; }
public function postUpdate() { $id = substr(Input::get('id'), 2); $advertise = Advertise::find($id); $advertise->caption = Input::get('caption'); $advertise->language_id = Input::get('language_id'); $advertise->client_id = Input::get('client_id'); $advertise->duration = Input::get('duration'); $advertise->brand_id = Input::get('brand_id'); $advertise->save(); return Response::json($advertise); }
public function actionUpload() { $filter = $this->getFilterCondition(); if (isset($filter['adv_channel_id'])) { $advertiseChannel = AdvertiseChannel::model()->findByPk($filter['adv_channel_id']); $advertise = $advertiseChannel->advertise; } else { if (isset($filter['adv_id'])) { $advertise = Advertise::model()->findByPk($filter['adv_id']); } } //$historyList = $adv_data->getDayDataForIn('',$startTime, $endTime, false); $this->render('upload', array('filters' => $this->getFilterCondition(), 'advertise' => $advertise, 'adv_channel_id' => $filter['adv_channel_id'])); }
public static function getAdvertise($position, $modelName = null, $modelId = null) { // Header & Footer if ($modelName == null && $modelId == null) { if (Cache::has('ad' . $position)) { $ad = Cache::get('ad' . $position); } else { $ad = Advertise::where(array('position' => $position, 'status' => ENABLED))->first(); Cache::put('ad' . $position, $ad, CACHETIME); } return $ad; } else { //check Common models if (Cache::has('common_model' . $modelName . $modelId)) { $common_model = Cache::get('common_model' . $modelName . $modelId); } else { $common_model = CommonModel::where(array('model_name' => $modelName, 'model_id' => $modelId))->first(); Cache::put('common_model' . $modelName . $modelId, $common_model, CACHETIME); } if ($common_model) { $common_model_id = $common_model->id; if (Cache::has('advertisement_id' . $common_model_id)) { $advertisement_id = Cache::get('advertisement_id' . $common_model_id); } else { $advertisement_id = AdvertisePosition::where(array('common_model_id' => $common_model_id, 'status' => ENABLED))->first(); Cache::put('advertisement_id' . $common_model_id, $advertisement_id, CACHETIME); } if ($advertisement_id) { if (Cache::has('ad' . $advertisement_id)) { $ad = Cache::get('ad' . $advertisement_id); } else { $advertisement_id = AdvertisePosition::where(array('common_model_id' => $common_model_id, 'status' => ENABLED))->first()->advertisement_id; $ad = Advertise::find($advertisement_id); Cache::put('ad' . $advertisement_id, $advertisement_id, CACHETIME); } return $ad; } return null; } else { return null; } } }
public function getDailyToTalData($date) { /* $db = Yii::app()->db; $sql = "select advertise.name as adv_name,sum(total_price) as prices,sum(download_number) as downloads from adv_data join advertise on advertise.id = adv_id where date = :date group by adv_id"; $command = $db->createCommand($sql); $command->bindParam(':date', $date); return $command->queryAll(); */ $criteria = new CDbCriteria(); $criteria->compare('ctime', ">= {$date}"); $criteria->order = 'date desc'; $data = array(); $advId2NameMap = array(); foreach (Advertise::model()->findAll() as $adv) { $advId2NameMap[$adv->id] = $adv->name; } foreach ($this->findAll($criteria) as $model) { if (!isset($data[$model->date])) { $data[$model->date] = array(); } if (!isset($data[$model->date][$model->adv_id])) { $data[$model->date][$model->adv_id] = array('adv_name' => $advId2NameMap[$model->adv_id], 'download_number' => 0, 'total_price' => 0); } $data[$model->date][$model->adv_id]['download_number'] += sprintf("%01.2f", floatval($model->download_number)); $data[$model->date][$model->adv_id]['total_price'] += sprintf("%01.2f", floatval($model->total_price)); } return $data; }
public function getTableName() { $filters = $this->getFilterCondition(); $conditions = array(); if (isset($filters['cp_id'])) { $model = CP::model()->findByPk($filters['cp_id']); if ($model) { $conditions[] = "CP:{$model->name}"; } } if (isset($filters['adv_id'])) { $model = Advertise::model()->findByPk($filters['adv_id']); if ($model) { $conditions[] = "业务:{$model->name}"; } } if (isset($filters['channel_id'])) { $model = Channel::model()->findByPk($filters['channel_id']); if ($model) { $conditions[] = "渠道:{$model->name}"; } } /*2014-11-17包名*/ if (isset($filters['adv_channel_id'])) { $model = AdvertiseChannel::model()->findByPk($filters['adv_channel_id']); if ($model) { $conditions[] = "包名:{$model->tag}"; } } /*end*/ if (isset($filters['begin_date']) && isset($filters['end_date'])) { $conditions[] = "从{$filters['begin_date']}到{$filters['end_date']}"; } if (isset($filters['date'])) { $conditions[] = "日期:{$filters['date']}"; } if (count($conditions)) { return $this->getTableBaseName() . '-(' . join('-', $conditions) . ')'; } else { return $this->getTableBaseName() . '-全部'; } }
public static function getAdvertise() { $data = Advertise::where('position', '=', 1)->where('status', '=', 1)->limit(5)->get(); return $data; }
/** * Returns the static model of the specified AR class. * @param string $className active record class name. * @return Advertise the static model class */ public static function model($className = __CLASS__) { return parent::model($className); }
public function index() { if (CNF_FRONT == 'false' && Session::get('uid') != 1) { if (!Auth::check()) { return Redirect::to('user/login'); } } $data['sp_banchay'] = Post::getPostNew(4); $data['sp_muanhieu'] = Post::getPostBuy(4); $data['adver_1'] = Advertise::getAdvertiseHome(1); $data['adver_2'] = Advertise::getAdvertiseHome(2); $this->data['pageTitle'] = 'Trang chu'; $this->data['pageNote'] = 'Welcome To Our Site'; //$this->data['breadcrumb'] = 'inactive'; $page = 'pages.template.home'; $page = SiteHelpers::renderHtml($page); $this->layout->nest('content', $page, $data)->with('menu', 'index'); }