static function getSourceByDomain($Domain) { $appHost = parse_url($Domain); if (isset($appHost['host'])) { $criteria = new CDbCriteria(); $criteria->addSearchCondition('Domains', $appHost['host']); $source = Source::model()->find($criteria); if ($source) { return $source->ID; } } else { echo new ReturnInfo(RET_SUC, array('code' => -1, 'msg' => 'App链接有误,请参考填写规则')); Yii::app()->end(); } }
function sourcesValidatorRule($attribute) { $srcarr = json_decode($this->{$attribute}); if (!is_array($srcarr) || count($srcarr) < 1) { $this->addError($attribute, 'Must have at least a source'); return false; } foreach ($srcarr as $src) { if (Source::model()->findByPk($src) == null) { $this->addError($attribute, 'Invalid source detected'); return false; } } return true; }
public function actionList() { $os = Yii::app()->request->getParam('os', ''); $order = Yii::app()->request->getParam('order', 'DownLoadNum'); $where = 'b.Status = 0'; if ($os) { $where .= ' AND c.OS = "' . addslashes($os) . '"'; } $list = Yii::app()->db->createCommand()->select('a.PushId, b.IconUrl, b.AppName, b.PusherId, d.Name as MainCategory, ifnull(b.FileSize, "") as FileSize, c.OS, b.ProcessDate, max(a.CommentNum) as CommentNum, max(a.DownLoadNum) as DownLoadNum')->from('app_push_list_detail a')->join('app_push_list b', 'a.PushId = b.Id')->join('source c', 'b.SourceId = c.ID')->join('category d', 'b.MainCategory = d.ID')->group('a.PushId')->where($where)->order($order . ' desc')->queryAll(); $models = Source::model()->findAll(); $aPuhser = array(); foreach ($models as $m) { $aPuhser[$m->ID] = $m->ChnName; } $aPuhser[0] = ''; $new_list = array(); foreach ($list as $row) { $row['ChnName'] = $aPuhser[intval($row['PusherId'])]; $new_list[] = $row; } echo new ReturnInfo(0, $new_list); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = Source::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
/** *App详情页面 */ public function actionDetail() { $id = Yii::app()->request->getParam('id'); if (!isset($id) || empty($id)) { throw new THttpException('查看的App不存在'); } if (!is_int($id)) { $id = intval($id); } $link = AppPushList::model()->findByPk($id); if (!$link instanceof AppPushList) { throw new THttpException('查看的App信息不存在'); } $aInfo = array(); //app_push_list表的基本信息 $aInfo['Id'] = $link->Id; $aInfo['AppName'] = $link->AppName; $aInfo['IconUrl'] = $link->IconUrl; $aInfo['SourceId'] = $link->SourceId; $aInfo['AppUrl'] = $link->AppUrl; $aInfo['AppInfo'] = $link->AppInfo; $aInfo['ProcessDate'] = $link->ProcessDate; $aInfo['FileSize'] = $link->FileSize; //App市场名称 $aInfo['ChnName'] = Source::model()->findByPk($aInfo['SourceId'])->ChnName; if (empty($aInfo['ChnName'])) { $aInfo['ChnName'] = ''; } //App所属类型 $aInfo['CategoryName'] = Category::model()->findByPk($link->MainCategory)->Name; if (empty($aInfo['CategoryName'])) { $aInfo['CategoryName'] = ''; } //信息的轮播图片(link_info表) $aInfo['imgurl'] = array(); if (!empty($link->ScreenShoot)) { foreach (explode(',', $link->ScreenShoot) as $imageUrl) { $aImage = array(); $aImage['imgurl'] = $imageUrl; $aInfo['imgurl'][] = $aImage; } } //App的下载总量/评论总量 $modal_detail = AppPushListDetail::model()->findAll(array('select' => array('Id', 'AppId', 'ApkName', 'MAX(DownLoadNum) as DownLoadNum', 'MAX(CommentNum) as CommentNum', 'PushId'), 'condition' => 'PushId = :Id', 'params' => array(':Id' => $id))); foreach ($modal_detail as $num) { $aInfo['DownLoadNum'] = $num->DownLoadNum; $aInfo['CommentNum'] = $num->CommentNum; } //App评论内容 $aReply = array(); $modal_reply = AppPushListReviews::model()->findAll(array('select' => array('Id', 'PushId', 'Title', 'Content', 'UpdateTime', 'Status'), 'condition' => 'PushId = :Id', 'order' => 'UpdateTime desc', 'params' => array(':Id' => $id))); if (!empty($modal_reply)) { foreach ($modal_reply as $reply) { $aReply[] = array('Id' => $reply->Id, 'PushId' => $reply->PushId, 'Title' => $reply->Title, 'Content' => $reply->Content, 'UpdateTime' => $reply->UpdateTime, 'Status' => $reply->Status); } } //App 下载量/评论量 分析 $models_date = AppPushListDetail::model()->findAll(array('select' => array('PushId', 'DownLoadNum', 'CommentNum', 'Date'), 'condition' => 'PushId = :Id', 'order' => 'Date', 'params' => array(':Id' => $id))); $num = array(); foreach ($models_date as $row) { $num['Date'][] = $row->Date; $num['DownLoadNum'][] = intval($row->DownLoadNum); $num['CommentNum'][] = intval($row->CommentNum); } if (!empty($num['Date'])) { $Date_json = json_encode($num['Date']); } else { $Date_json = 0; } if (!empty($num['DownLoadNum'])) { $DownLoadNum_json = json_encode($num['DownLoadNum']); } else { $DownLoadNum_json = 0; } if (!empty($num['CommentNum'])) { $CommentNum_json = json_encode($num['CommentNum']); } else { $CommentNum_json = 0; } $this->render('detail', array('data' => $aInfo, 'Date_json' => $Date_json, 'DownLoadNum_json' => $DownLoadNum_json, 'CommentNum_json' => $CommentNum_json, 'aReply' => $aReply)); }
/* @var $form CActiveForm */ ?> <div class="wide form"> <?php $form = $this->beginWidget('CActiveForm', array('action' => Yii::app()->createUrl($this->route), 'method' => 'get')); ?> <div class="proper-lft"> <div class="txt-log"><?php echo $form->labelEx($model, 'enquiry_source'); ?> </div> <div class="txt-box"><?php echo $form->dropDownList($model, 'enquiry_source', CHtml::listData(Source::model()->findAll(), 's_tite', 's_tite'), array('empty' => '--Select Source--')); ?> <?php //echo $form->error($model,'enquiry_source'); ?> </div> </div> <div class="proper-rgt"> <div class="txt-log"><?php echo $form->labelEx($model, 'priority_source'); ?> </div> <div class="txt-box"><?php echo $form->dropDownList($model, 'priority_source', CHtml::listData(Priority::model()->findAll(), 'p_title', 'p_title'), array('empty' => '--Select Priority--')); ?>
public function actionGetSourceType() { $result = []; if (isset($_GET['parentType']) && $_GET['parentType']) { $parentType = $_GET['parentType']; $sources = Source::model()->getTypes($parentType); foreach ($sources as $source) { /** @var $source Source [ ] */ $result[$source->sou_id] = $source->sou_title; } } echo json_encode($result); }
</div> <?php echo $form->endControlGroup(); ?> <?php echo $form->beginControlGroup($model, 'cli_source'); ?> <label class="control-label" for="cli_source">Referrer</label> <div class="controls"> <?php if ($model->cli_source) { echo $model->source->getTitle(); } else { echo CHtml::dropDownList("Client[sourceParent]", "", CHtml::listData(Source::model()->getTypes(0), 'sou_id', 'sou_title'), ['id' => 'sourceParentType', 'empty' => '']); echo $form->dropDownList($model, "cli_source", [], ['id' => 'sourceType']); } ?> </div> <?php echo $form->endControlGroup(); ?> <?php echo $form->beginControlGroup($model, 'cli_neg'); ?> <label class="control-label" for="cli_neg">Assigned Negotiator</label> <div class="controls"> <?php