public function run()
{
$model = new MailLog();
//条件
$criteria = new CDbCriteria();
$accept = trim(Yii::app()->request->getParam('accept'));
//收件人
$subject = trim(Yii::app()->request->getParam('subject'));
//主题
$start_time = Yii::app()->request->getParam('start_time');
$end_time = Yii::app()->request->getParam('end_time');
$accept && $criteria->addSearchCondition('accept', $accept);
$subject && $criteria->addSearchCondition('subject', $subject);
$start_time && $criteria->compare('sendtime', '>=' . strtotime($start_time));
$end_time && $criteria->compare('sendtime', '<=' . strtotime($end_time));
$criteria->order = 't.id DESC';
$count = $model->count($criteria);
//分页
$pages = new CPagination($count);
$pages->pageSize = 20;
$pages->applyLimit($criteria);
//查询
$result = $model->findAll($criteria);
$this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages));
}
public function run()
{
$params = array();
$criteria = new CDbCriteria();
// $criteria->select = array('id,username,fullname,phone,address,status');
$criteria->select = '*';
if (isset($this->team_lear_id) and $this->team_lear_id != '') {
$criteria->addCondition('team_lear_id=' . $this->team_lear_id);
}
$criteria->params = $params;
$total = ATrainingTeam::model()->count($criteria);
$offset = $this->limit * ($this->page - 1);
$criteria->limit = $this->limit;
$criteria->offset = $offset;
$data = ATrainingTeam::model()->findAll($criteria);
$listTrainee = array();
if (!empty($data)) {
foreach ($data as $item) {
$listTrainee[] = CJSON::decode(CJSON::encode($item->pls_user));
}
}
$data = $listTrainee;
$pages = new CPagination($total);
$pages->pageSize = $this->limit;
$pages->applyLimit($criteria);
$this->render($this->view, array('data' => $data, 'pages' => $pages));
}
/**
* This function generates the products grid
* based on the criteria. It also generates the
* pagination object need for the users to navigate
* through products.
*
* @return void
*/
public function generateProductGrid()
{
$this->_numberOfRecords = Product::model()->count($this->_productGridCriteria);
$this->_pages = new CPagination($this->_numberOfRecords);
$this->_pages->setPageSize(CPropertyValue::ensureInteger(Yii::app()->params['PRODUCTS_PER_PAGE']));
$this->_pages->applyLimit($this->_productGridCriteria);
$this->_productsGrid = self::createBookends(Product::model()->findAll($this->_productGridCriteria));
}
public function actionMore()
{
Yii::app()->clientScript->registerCssFile(Yii::app()->theme->baseUrl . '/css/enjoy.css');
$city_id = Yii::app()->request->getQuery('city', 0);
$time_sort = Yii::app()->request->getQuery('time_sort', 'DESC');
$price_sort = Yii::app()->request->getQuery('lp_dol');
$criteria = new CDbCriteria();
$criteria->order = 'id DESC';
if (!empty($city_id)) {
$criteria->addCondition('city_id=' . $city_id);
}
if (!empty($time_sort)) {
$criteria->order = 'accessDate ' . $time_sort;
}
if (!empty($price_sort)) {
$criteria->order = 'lp_dol ' . $price_sort;
}
$criteria->addCondition('lp_dol>3000000');
$count = House::model()->count($criteria);
$pager = new CPagination($count);
$pager->pageSize = 10;
$pager->applyLimit($criteria);
$house_list = House::model()->findAll($criteria);
$subject_list = Subject::model()->findAll(array('order' => 'id DESC'));
$cur_city = City::model()->findByPk($city_id);
$data = array('house_list' => $house_list, 'subject_list' => $subject_list, 'cur_city' => $cur_city, 'count' => $count, 'time_sort' => $time_sort, 'price_sort' => $price_sort, 'pages' => $pager);
$this->render('more', $data);
}
public function actionList()
{
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$list = array();
$criteria = new CDbCriteria();
$criteria->select = 'sid,name';
$criteria->order = 'sid ASC';
$request = Yii::app()->getRequest();
$id = trim($request->getParam("id"));
if ($id) {
$criteria->addCondition("sid = {$id}");
}
$sites = new Site();
$count = $sites->count($criteria);
$pager = new CPagination($count);
$pager->pageSize = Yii::app()->params['postsPerPage'];
$pager->setCurrentPage($page - 1);
$pager->applyLimit($criteria);
$list = $sites->findAll($criteria);
$res = new Seo();
$seo = array();
foreach ($list as $key => $site) {
$row = $res->find('sid=:sid', array(':sid' => $site->sid));
$seo[$key] = $row;
}
$this->render('list', array('r' => Yii::app()->request->baseUrl . '/', 'pages' => $pager, 'list' => $list, 'seo' => $seo));
}
/**
* 展示所有或者某一类别同时还没有被读过的的信息
*/
public function actionIndex($cid = 0)
{
$criteria = new CDbCriteria();
// $criteria -> addCondition("uid =:uid "); //添加查询条件
// $criteria -> params[':uid'] = $UID; //绑定查询条件的参数
$criteria->addCondition("status=0");
$criteria->order = 'create_time desc';
if ($cid != 0) {
$criteria->addCondition("cid={$cid}");
}
$count = Advice::model()->count($criteria);
//统计查询结果集中记录总数
$pager = new CPagination($count);
//实例化CPagination类
$pager->pageSize = 10;
//设置一页显示记录数
// $pager->pageVar = 'p'; //自定义URL中页码的参数，可以不设置
$pager->applyLimit($criteria);
//将结果集进行过滤处理
$advice_list = Advice::model()->findAll($criteria);
if (count($advice_list) == 0) {
die('您现在没有未读邮件');
}
$this->render('index', array('advice_list' => $advice_list, 'pager' => $pager));
/*$criteria = new CDbCriteria ;
// $criteria -> select = 'aid, cid, create_time';
if($category != 0 ) $criteria -> addCondition("cid = $category");
$criteria -> addCondition("status = 0");
$criteria -> order = 'create_time desc';
$advice_list = Advice::model() -> findAll($criteria);
// header("charset=utf-8");
if( count($advice_list) == 0) die('您现在没有未读邮件');
$this -> render('index', array('advice_list' => $advice_list));*/
}
public function actionGetlogisticslist()
{
$organID = Commonmodel::getOrganID();
//获取机构ID
$criteria = new CDbCriteria();
$criteria->select = "*";
$criteria->order = "id DESC";
$criteria->addCondition("OrganID=" . $organID);
//查询条件：根据机构ID查询物流数据
$count = Logistics::model()->count($criteria);
$pages = new CPagination($count);
$pages->applyLimit($criteria);
$modeles = Logistics::model()->findAll($criteria);
foreach ($modeles as $key => $value) {
$data[$key]['ID'] = $value['ID'];
$data[$key]['OrganID'] = $value['OrganID'];
$data[$key]['Company'] = F::msubstr($value['LogisticsCompany']);
$data[$key]['Description'] = F::msubstr($value['LogisticsDescription']);
$data[$key]['LogisticsCompany'] = $value['LogisticsCompany'];
$data[$key]['LogisticsDescription'] = $value['LogisticsDescription'];
$data[$key]['CreateTime'] = date("Y-m-d H:i:s", $value['CreateTime']);
$data[$key]['UpdateTime'] = $value['UpdateTime'];
$data[$key]['Status'] = $value['Status'];
$address = $this->getAddress($value['ID']);
$data[$key]['Address'] = $address ? F::msubstr(substr($address, 0, -3)) : '';
$data[$key]['AddressDetail'] = $address ? substr($address, 0, -3) : '';
//$data[$key]['Address'] = Area::getCity($address['Province']) . Area::getCity($address['City']) . Area::getCity($address['Area']);
}
$rs = array('total' => $count, 'rows' => $data ? $data : array());
// var_dump($rs);exit;
echo json_encode($rs);
}
public function run()
{
$model = new Comment();
//条件
$criteria = new CDbCriteria();
$type = trim(Yii::app()->request->getParam('type'));
$type && $criteria->addColumnCondition(array('type' => $type));
$status = trim(Yii::app()->request->getParam('status'));
$status && $criteria->addColumnCondition(array('status' => $status));
$title = trim(Yii::app()->request->getParam('content'));
$title && $criteria->addSearchCondition('content', $title);
$criteria->order = 't.id DESC';
$count = $model->count($criteria);
//分页
$pages = new CPagination($count);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
//查询
$result = $model->findAll($criteria);
//全部类型
$model_types = ModelType::model()->findAll();
Yii::app()->clientScript->registerCssFile($this->controller->_static_public . "/js/kindeditor/code/prettify.css");
Yii::app()->clientScript->registerScriptFile($this->controller->_static_public . "/js/kindeditor/code/prettify.js", CClientScript::POS_END);
$this->controller->render('index', array('model' => $model, 'model_types' => $model_types, 'datalist' => $result, 'pagebar' => $pages));
}
public function actionGetstandardparamlists()
{
$organID = Commonmodel::getOrganID();
$criteria = new CDbCriteria();
$criteria->addCondition('organID=' . $organID);
$criteria->addCondition('mark="U" and ISdelete="N"');
$criteria->group = 'standard_id';
// //查询数据总数
// $sql='SELECT count(distinct standard_id) as count FROM `tbl_make_goods_template` where organID='.$organID.' and mark="U" and ISdelete="N"';
// $count=Yii::app()->db->createCommand($sql)->queryAll();
// $total=$count[0]['count'];sss
$count = MakeGoodsTemplate::model()->count($criteria);
$criteria->order = 'id desc';
//分页
$pages = new CPagination($count);
$pages->pageSize = isset($_GET['rows']) ? intval($_GET['rows']) : 10;
$pages->applyLimit($criteria);
$datas = MakeGoodsTemplate::model()->findAll($criteria);
$res = array();
foreach ($datas as $key => $data) {
//根据标准名称id查询标准名称
$res[$key]['id'] = $data['standard_id'];
$standard = Gcategory::model()->findByPk($data['standard_id']);
$res[$key]['name'] = $standard['name'];
$res[$key]['createtime'] = date('Y-m-d H:i:s', $data['createtime']);
//标准名称参数对应的商品数量
$sql = 'select count(b.standard_id) from tbl_make_goods a,tbl_make_goods_version b where a.ISdelete=0 and ' . 'a.NewVersion=b.version_name and a.id=b.goods_id and b.standard_id=' . $data['standard_id'] . ' and b.organID=' . $organID;
$result = Yii::app()->db->createCommand($sql)->queryRow();
$res[$key]['count'] = $result['count(b.standard_id)'];
}
echo json_encode(array('total' => $count, 'rows' => $res));
}
public function actionIndex()
{
$id = $_REQUEST['id'];
$this->data['cur_moduleid'] = $id;
$module = Yii::app()->cache->get("module_" . $id);
if ($module == false) {
$module = $this->connection->createCommand("select * from xm_module where module_id = " . $id)->queryRow();
Yii::app()->cache->set("module_" . $id, $module);
}
$this->data['module'] = $module;
/*右侧导航栏*/
$topid = $this->getTopIdFromIDEN($module['iden']);
$modulequeue = Yii::app()->cache->get("modulequeue_" . $topid);
if ($modulequeue == false) {
$modulequeue = $this->getQueueModulesById($topid);
Yii::app()->cache->set("modulequeue_" . $topid, $modulequeue);
}
$this->data['modulequeue'] = $modulequeue;
$criteria = new CDbCriteria();
$criteria->addCondition('module_id=' . $id, 'AND');
$criteria->order = "createtime desc";
$count = Message::model()->count($criteria);
$pager = new CPagination($count);
$pager->pageSize = 10;
$pager->applyLimit($criteria);
$articles = Message::model()->findAll($criteria);
$this->data['pages'] = $pager;
$this->data['list'] = $articles;
Yii::app()->params['TITLE'] = $module['category'];
Yii::app()->params['APPKEYWORDS'] = $module['category'];
Yii::app()->params['APPDESCRIPTION'] = $module['category'];
$this->render('index', $this->data);
}
public function run()
{
$this->controller->_seoTitle = '交易记录 - ' . $this->controller->_setting['site_name'];
$this->controller->loadModel();
$model = new UserTrade();
$criteria = new CDbCriteria();
//查询条件
$create_time_start = Yii::app()->request->getParam('create_time_start');
$create_time_end = Yii::app()->request->getParam('create_time_end');
$trade_type = Yii::app()->request->getParam('trade_type');
$trade_status = Yii::app()->request->getParam('trade_status');
$create_time_start && $criteria->addBetweenCondition('time_create', strtotime($create_time_start), strtotime($create_time_end));
if ($trade_type && $trade_type != 'all') {
$criteria->addColumnCondition(['type' => $trade_type]);
}
if ($trade_status && $trade_status != 'all') {
$criteria->addColumnCondition(['status' => $trade_status]);
}
$criteria->addColumnCondition(array('user_id' => Yii::app()->user->id));
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
$lists = $model->findAll($criteria);
//加载css js
Yii::app()->clientScript->registerScriptFile($this->controller->_static_public . "/js/jquery/jquery.js");
Yii::app()->clientScript->registerScriptFile($this->controller->_static_public . "/js/My97DatePicker/WdatePicker.js", CClientScript::POS_END);
$this->controller->render('list_trade', array('lists' => $lists, 'pages' => $pages, 'create_time_start' => $create_time_start, 'create_time_end' => $create_time_end, 'trade_type' => $trade_type, 'trade_status' => $trade_status));
}
public function run()
{
$params = array();
$criteria = new CDbCriteria();
$criteria->select = array('lecture_name,training_minute,id,lecture_type');
if (isset($this->lecture_name) and $this->lecture_name != '') {
$keyword = addcslashes($this->lecture_name, '%_');
$criteria->addCondition('lecture_name LIKE :keyword');
$params[':keyword'] = "%{$keyword}%";
}
if (isset($this->lecture_cat) and $this->lecture_cat != '') {
$criteria->addCondition('lecture_cat_id=' . $this->lecture_cat);
}
if (isset($this->trainer) and $this->trainer != '') {
$criteria->addCondition('created_by=' . $this->trainer);
}
if (!empty(Yii::app()->user->id) and Yii::app()->session['group_id'] == 1) {
$criteria->addCondition('created_by=' . Yii::app()->user->id);
}
$criteria->params = $params;
$criteria->order = 'created_date DESC';
$total = Lecture::model()->count($criteria);
$offset = $this->limit * ($this->page - 1);
$criteria->limit = $this->limit;
$criteria->offset = $offset;
$data = Lecture::model()->findAll($criteria);
if (!empty($data)) {
$data = CJSON::decode(CJSON::encode($data));
}
$pages = new CPagination($total);
$pages->pageSize = $this->limit;
$pages->applyLimit($criteria);
$this->render($this->view, array('data' => $data, 'pages' => $pages));
}
public function getWishListForWeb($user_id)
{
$criteria = new CDbCriteria();
$criteria->condition = "user_id = {$user_id}";
$wishlists = Wishlist::model()->findAll($criteria);
$wishlist_arr = array();
foreach ($wishlists as $wishlist) {
$wishlist_arr[] = $wishlist->post_id;
}
//var_dump($wishlist_arr); die;
$returnArr = array();
$criteria_post = new CDbCriteria();
$criteria_post->addInCondition('t.post_id', $wishlist_arr);
$count = Posts::model()->count($criteria_post);
$pages = new CPagination($count);
$pages->validateCurrentPage = FALSE;
$pages->pageSize = Yii::app()->params['RESULT_PER_PAGE'];
$pages->applyLimit($criteria_post);
$posts = Posts::model()->findAll($criteria_post);
$is_followed = User::model()->isFollowedByUser(Yii::app()->session['user_id'], $user_id, 'USER');
$profile = User::model()->findByPk($user_id);
foreach ($posts as $post) {
$itemArr = Posts::model()->getPostById($post->post_id, Yii::app()->session['user_id']);
$returnArr[] = $itemArr;
}
return array('data' => $returnArr, 'pages' => $pages, 'profile' => $profile, 'is_followed' => $is_followed);
// return FALSE;
}
/**
* 获取一定条件下的文章
* @param array $params = ('condition'=> '额外条件', 'order'=>'排序', 'with'=>'关联表', 'limit'=>'条数', 'page'=>'是否分页')
* @param $pages 分页widget
* @return array
*/
public static function getList($params = array(), &$pages = null)
{
$pages = array();
$params['condition'] = isset($params['condition']) ? $params['condition'] : '';
$params['order'] = isset($params['order']) ? $params['order'] : '';
$params['with'] = isset($params['with']) ? $params['with'] : '';
$params['limit'] = isset($params['limit']) ? $params['limit'] : '';
$params['page'] = isset($params['page']) ? $params['page'] : '';
//组合条件
$criteria = new CDbCriteria();
$criteria->condition = 't.status=:status';
$params['condition'] && ($criteria->condition .= $params['condition']);
$criteria->order = $params['order'] ? $params['order'] : 't.id DESC';
$criteria->with = array('catalog');
$criteria->select = "t.title, t.id,t.title_style, ";
$criteria->select .= " t.copy_from, t.copy_url, t.update_time,t.introduce, t.tags, t.view_count";
$criteria->params = array(':status' => 'Y');
$params['with'] && ($criteria->with = (array) $params['with']);
$limit = $params['limit'] > 0 ? intval($params['limit']) : 15;
//是否分页
if ($params['page']) {
//分页
$count = self::model()->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = $limit;
$pages->applyLimit($criteria);
} else {
$criteria->limit = $limit;
}
$data = self::model()->findAll($criteria);
return $data ? $data : array();
}
public function actionFind()
{
if (isset($_POST['flightNumber'])) {
$current = date('Y-m-d');
$flightNumber = $_POST['flightNumber'];
$criteria = new CDbCriteria();
$criteria->join = 'LEFT JOIN tbl_mry_user ON tbl_mry_plan.userId=tbl_mry_user.userId';
$criteria->addCondition('flightNumber=:flightNumber');
$criteria->params = array(':flightNumber' => $flightNumber);
$criteria->order = 'startDate DESC';
$UserModel = User::model();
$total = $UserModel->count($criteria);
$pager = new CPagination($total);
$pager->pageSize = 10;
$pager->applyLimit($criteria);
$UserList = $UserModel->findAll($criteria);
//删除PASSWORD相关的信息
$dataFormat = new DataFormat();
$format = $dataFormat->format($userList, null, null);
$clientFlash = new ClientFlash();
if ($total > 0) {
$clientFlash->pushMobile(0, $format);
} else {
_echo(3, 数据为空);
}
}
}
public function actionIndex()
{
$this->pageTitle = 'Управление переводом';
$criteria = new CDbCriteria();
$criteria->with = array();
$criteria->order = 't.created_at DESC';
$filter = array();
$checkBoxDefaultOn = TRUE;
$count = Translate::model()->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = TRANSLATES_PER_PAGE;
$pages->applyLimit($criteria);
$translates = Translate::model()->findAll($criteria);
$langs = Langs::model()->findAll();
$translatesLang = array();
foreach ($translates as $translate) {
$translatesLang[$translate->id] = array();
foreach ($translate->langs as $translateLang) {
foreach ($langs as $lang) {
if (!array_key_exists($lang->alias, $translatesLang[$translate->id])) {
$translatesLang[$translate->id][$lang->alias] = '';
}
if ($translateLang->lang == $lang->alias) {
$translatesLang[$translate->id][$lang->alias] = $translateLang->translate;
}
}
}
}
$model = new Translate();
$modelLang = new TranslateLang();
$this->include_jquery_form();
CHtml::asset(Yii::getPathOfAlias('application.modules.admin.modules.translate.css'));
$this->render('index', array('translates' => $translates, 'pages' => $pages, 'model' => $model, 'modelLang' => $modelLang, 'langs' => $langs, 'translatesLang' => $translatesLang, 'filter' => $filter, 'checkBoxDefaultOn' => $checkBoxDefaultOn));
}
/**
* Handles all incoming requests for the entire site that are not previous defined in CUrlManager
* Requests come in, are verified, and then pulled from the database dynamically
* Shows all blog posts for a particular category_id
* @param $id - The content ID that we want to pull from the database
* @return $this->render() - Render of page that we want to display
**/
public function actionIndex($id = NULL)
{
// Run a pre check of our data
$this->beforeCiiAction($id);
// Retrieve the data
$category = Categories::model()->findByPk($id);
$this->breadcrumbs = Categories::model()->getParentCategories($id);
// Parse Metadata
$meta = Categories::model()->parseMeta($category->metadata);
$this->setPageTitle(Yii::t('ciims.controllers.Categories', '{{app_name}} | {{label}}', array('{{app_name}}' => Cii::getConfig('name', Yii::app()->name), '{{label}}' => $category->name)));
$layout = isset($meta['layout']) ? $meta['layout']['value'] : 'default';
// Set the layout
$this->setLayout($layout);
$data = array();
$pages = array();
$itemCount = 0;
$pageSize = Cii::getConfig('categoryPaginationSize', 10);
$criteria = Content::model()->getBaseCriteria()->addCondition('type_id >= 2')->addCondition("category_id = " . $id)->addCondition('password = ""');
$criteria->limit = $pageSize;
$criteria->order = 'created DESC';
$itemCount = Content::model()->count($criteria);
$pages = new CPagination($itemCount);
$pages->pageSize = $pageSize;
$criteria->offset = $criteria->limit * $pages->getCurrentPage();
$data = Content::model()->findAll($criteria);
$pages->applyLimit($criteria);
$this->render('index', array('id' => $id, 'category' => $category, 'data' => $data, 'itemCount' => $itemCount, 'pages' => $pages, 'meta' => array('description' => $category->getDescription())));
}
public function actionShow()
{
// handle space visibility changes
if (isset($_POST['reputationUsers'])) {
$user = $this->getUser();
$userSpace = Yii::app()->request->getParam('reputationUsers');
foreach ($userSpace as $space) {
if (isset($_POST['reputationUser_' . $space])) {
$userSettings = Yii::app()->request->getParam('reputationUser_' . $space);
$reputationUser = ReputationUser::model()->findByAttributes(array('space_id' => $space, 'user_id' => $user->id));
if ($reputationUser != null) {
$reputationUser->visibility = isset($userSettings['visibility']) && $userSettings['visibility'] == 1 ? 1 : 0;
$reputationUser->save();
}
}
}
Yii::app()->user->setFlash('data-saved', Yii::t('SpaceModule.controllers_AdminController', 'Saved'));
}
$user = $this->getUser();
$criteria = new CDbCriteria();
$criteria->condition = 'user_id=:userId';
$criteria->order = 'space_id ASC';
$criteria->params = array(':userId' => $user->id);
$itemCount = ReputationUser::model()->count($criteria);
$pages = new CPagination($itemCount);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
$reputations = ReputationUser::model()->findAll($criteria);
$this->render('userReputation', array('user' => $user, 'reputations' => $reputations, 'pages' => $pages));
}
public function actionAll()
{
$model = Notify::model();
$user_id = Yii::app()->user->id;
$criteria = new CDbCriteria();
$criteria->with = ['status' => ['select' => ['status.id', 'status.notify_id', 'status.user_id', 'status.read_status', 'IF(status.date_showed, status.date_showed, "' . date('c') . '") as date_showed'], 'on' => 'status.user_id = :user_id']];
$criteria->params = [':user_id' => $user_id, ':all_users' => Notify::All_USERS, ':type' => Notify::TYPE_DEFAULT, ':today' => date('c'), ':user_date_create' => $model->getUserDateCreate($user_id)];
$criteria->addCondition('t.user_id=:user_id OR t.user_id=:all_users');
if ($model->isGroupSupport() && $model->getUserGroups($user_id)) {
$criteria->addInCondition('t.group_id', $model->getUserGroups($user_id), 'OR');
}
$criteria->addCondition('(t.date_create >= :user_date_create AND t.date_show<=:today) AND (IF(date_end, :today <= date_end, 1) OR status.user_id IS NOT NULL)');
$criteria->addCondition('t.type = :type');
$criteria->order = 'date_showed desc, t.date_show desc';
$count = Notify::model()->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = Yii::app()->notify->numberDisplayInAll;
$pages->applyLimit($criteria);
$notifications = Notify::model()->findAll($criteria);
$ids = array_keys(array_filter(CHtml::listData($notifications, 'id', 'status.read_status'), function ($var) {
return $var == 0;
}));
if ($ids) {
Notify::changeReadStatusByIds($ids, $user_id, Notify::READ);
$notifications = Notify::model()->findAll($criteria);
}
$this->render('all', ['notifications' => $notifications, 'pages' => $pages]);
}
public function run()
{
$model = new User();
//审核状态
$user_status = array('all' => '所有', User::STATUS_AUDIT => '待审核', User::STATUS_DISABLE => '禁用', User::STATUS_NORMAL => '正常');
//条件
$criteria = new CDbCriteria();
$groupid = intval(Yii::app()->request->getParam('groupid'));
$username = trim(Yii::app()->request->getParam('username'));
$status = Yii::app()->request->getParam('status', 'all');
$groupid > 0 && $criteria->addColumnCondition(array('groupid' => $groupid));
if ($status != 'all') {
$criteria->addSearchCondition('status', $status);
}
$criteria->addSearchCondition('username', $username);
$criteria->order = 'uid ASC';
$count = $model->count($criteria);
//分页
$pages = new CPagination($count);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
//查询
$result = $model->findAll($criteria);
$this->controller->render('index', array('datalist' => $result, 'pagebar' => $pages, 'status' => $status, 'user_status' => $user_status));
}
public function actionPosts($name)
{
$tag = urldecode($name);
$this->setSiteTitle(t('tag_posts', 'main', array('{name}' => $tag)));
// @todo 关键字的描述没有指定
$this->setPageKeyWords($tag);
$this->setPageDescription(t('tag_posts_page_description', 'main', array('{name}' => $tag)));
cs()->registerMetaTag('all', 'robots');
$cmd = app()->getDb()->createCommand()->select('p.id')->from(TABLE_TAG . ' t')->where('t.name = :tagname', array(':tagname' => $tag))->join(TABLE_POST_TAG . ' pt', 'pt.tag_id = t.id')->join(TABLE_POST . ' p', 'p.id = pt.post_id');
$ids = $cmd->queryColumn();
if (count($ids) > 0) {
$criteria = new CDbCriteria();
if (param('post_list_type') == POST_LIST_TYPE_TITLE) {
$criteria->select = array('t.id', 't.title', 't.visit_nums', 't.comment_nums', 't.create_time');
}
$criteria->order = 't.istop, t.create_time desc, t.id desc';
$criteria->addInCondition('t.id', $ids)->addCondition('t.state = :state');
$criteria->params += array(':state' => POST_STATE_ENABLED);
$count = Post::model()->count($criteria);
$pages = new CPagination($count);
$pages->setPageSize(param('postCountOfTitleListPage'));
$pages->applyLimit($criteria);
$posts = Post::model()->findAll($criteria);
}
$listType = param('post_list_type');
$view = $listType == POST_LIST_TYPE_SUMMARY ? '/post/_summary_list' : '/post/_title_list';
$blockTitle = t('tag_posts', 'main', array('{name}' => $tag));
$data = array('blockTitle' => $blockTitle, 'posts' => $posts, 'pages' => $pages);
$postListHtml = $this->renderPartial($view, $data, true);
$this->render('posts', array('postListHtml' => $postListHtml));
}
public function actionIndex($key)
{
$category = Category::model()->findByPk(3);
$model = $category->findByAttributes(array('url' => $key));
if ($model) {
$childs = $model->descendants()->findAll();
$ids = array($model->id);
foreach ($childs as $child) {
$ids[] = $child->id;
}
$cid = implode(',', $ids);
$criteria = new CDbCriteria(array('condition' => 'category_id in ( ' . $cid . ')', 'order' => 'item_id desc, sort_order desc'));
$count = Item::model()->count($criteria);
$pages = new CPagination($count);
// results per page
$pages->pageSize = 20;
$pages->applyLimit($criteria);
$items = Item::model()->findAll($criteria);
// $items = new CActiveDataProvider('Item', array(
// 'criteria' => $criteria
// ));
$criteria = new CDbCriteria(array('condition' => 'is_hot = 1 and category_id in ( ' . $cid . ')', 'limit' => '4', 'order' => 'item_id desc, sort_order desc'));
$hotItems = Item::model()->findAll($criteria);
$this->render('index', array('model' => $model, 'items' => $items, 'pages' => $pages, 'hotItems' => $hotItems, 'key' => $key));
} else {
$this->render('index');
}
}
public function actionIndex()
{
Yii::app()->clientScript->registerCssFile(Yii::app()->theme->baseUrl . '/css/post.css');
$left_news = Post::model()->findAll(array('select' => 'id, title, image, summary', 'condition' => 'catalog_id = :catalog_id', 'params' => array(':catalog_id' => 3), 'order' => 'id DESC', 'limit' => 3));
$special_ids = array();
foreach ($left_news as $row) {
array_push($special_ids, $row->id);
}
$criteria = new CDbCriteria();
$criteria->select = 'id, title, summary';
$criteria->order = 'id DESC';
$criteria->addCondition('catalog_id = 3');
$criteria->addNotInCondition('id', $special_ids);
$criteria->limit = 1;
$top_news = Post::model()->findAll($criteria);
array_push($special_ids, $top_news[0]->id);
$criteria = new CDbCriteria();
$criteria->order = 'id DESC';
$criteria->addCondition('catalog_id = 3');
$criteria->addNotInCondition('id', $special_ids);
$count = Post::model()->count($criteria);
$pager = new CPagination($count);
$pager->pageSize = 30;
$pager->applyLimit($criteria);
$more_news = Post::model()->findAll($criteria);
$data = array('left_news' => $left_news, 'top_news' => $top_news[0], 'more_news' => $more_news, 'pages' => $pager);
$this->render('index', $data);
}
public function actionFiltertest()
{
$kind_of_test = isset($_REQUEST['kind_of_test']) ? $_REQUEST['kind_of_test'] : '';
$criteria = new CDbCriteria();
if ($kind_of_test != '') {
$criteria->condition = 'created_by=:created_by and kind_of_test=:kind_of_test';
$criteria->params = array(':created_by' => Yii::app()->user->id, ':kind_of_test' => $kind_of_test);
} else {
$criteria->condition = 'created_by=:created_by';
$criteria->params = array(':created_by' => Yii::app()->user->id);
}
$criteria->order = 'created_date DESC';
$total = WTest::model()->count($criteria);
$limit = 6;
$page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1;
$offset = $limit * ($page - 1);
$criteria->limit = $limit;
$criteria->offset = $offset;
$data = WTest::model()->findAll($criteria);
if ($total > 0) {
$pages = new CPagination($total);
$pages->pageSize = $limit;
$pages->applyLimit($criteria);
} else {
$pages = NULL;
}
$html = $this->renderPartial('/wTest/_filter', array('data' => $data, 'pages' => $pages));
echo $html;
exit;
}
public function actionIndexdata()
{
$criteria = new CDbCriteria();
$criteria->select = '*';
//'BrandID,BrandName,Pinyin,Remarks';
$criteria->order = 'CreateTime desc';
$criteria->addCondition('OrganID=' . Commonmodel::getOrganID());
$res = MakeGoodsBrand::model()->findAll($criteria);
$count = count($res);
$page = new CPagination($count);
$page->pageSize = $_GET['rows'];
$page->applyLimit($criteria);
$res = MakeGoodsBrand::model()->findAll($criteria);
$data = array();
if (is_array($res)) {
foreach ($res as $key => $val) {
$data[$key] = $val->attributes;
$sQl = 'select count(b.goods_brand)as number from tbl_make_goods a,tbl_make_goods_version b where b.goods_brand=' . $val->BrandID . ' and b.organID=' . $val->OrganID . ' and a.IsSale=0 and a.ISdelete=0 and a.NewVersion=b.version_name and a.id=b.goods_id';
$query = Yii::app()->db->createCommand($sQl)->queryAll();
$data[$key]['Number'] = $query[0]['number'];
}
}
// var_dump($data);
echo json_encode(array('total' => $count, 'rows' => $data ? $data : array()));
}
public function actionList()
{
$_default_item_perpage = 10;
if (isset($_GET['limit']) && (int) $_GET['limit'] > 0) {
Yii::app()->session['current'] = $_GET['limit'];
$_default_item_perpage = Yii::app()->session['current'];
} else {
if (isset(Yii::app()->session['current'])) {
$_default_item_perpage = Yii::app()->session['current'];
} else {
Yii::app()->session['current'] = $_default_item_perpage;
}
}
$criteria = new CDbCriteria();
$criteria->addCondition('current=1 AND web=1');
$q = Yii::app()->getRequest()->getQuery('q');
if ($q) {
$criteria->addCondition('`title` LIKE "%' . $q . '%" OR `code` LIKE "%' . $q . '%" OR `description_short` LIKE "%' . $q . '%"');
}
$criteria->order = _xls_get_sort_order();
$item_count = Product::model()->count($criteria);
$pages = new CPagination($item_count);
$pages->setPageSize($_default_item_perpage);
$pages->applyLimit($criteria);
$model = Product::model()->findAll($criteria);
$this->render('list', array('model' => $model, 'item_count' => $item_count, 'page_size' => $_default_item_perpage, 'items_count' => $item_count, 'pages' => $pages));
}
public function actionIndex($is_product = 1)
{
if (!empty($_POST)) {
$is_new_product = $is_product;
$images = CUploadedFile::getInstancesByName('images');
if (isset($images) && count($images) > 0) {
// go through each uploaded image
foreach ($images as $image => $pic) {
$model = new Slides();
$imageType = explode('.', $pic->name);
$imageType = $imageType[count($imageType) - 1];
$imageName = md5(uniqid()) . '.' . $imageType;
if ($pic->saveAs(Yii::getPathOfAlias('webroot') . '/upload/images/' . $imageName)) {
$model->image = $imageName;
$model->name = $pic->name;
$model->is_product = $is_new_product;
$model->save();
Yii::app()->user->setFlash('success', translate('Thêm thành công.'));
}
// handle the errors here, if you want
}
}
PIUrl::createUrl('/admin/slides/index', array('is_product' => $is_product));
}
$criteria = new CDbCriteria();
$criteria->addCondition("is_product= {$is_product}");
$criteria->order = 'id DESC';
$count = Slides::model()->count($criteria);
$pages = new CPagination($count);
// results per page
$pages->pageSize = 6;
$pages->applyLimit($criteria);
$model = Slides::model()->findAll($criteria);
$this->render('index', compact('model', 'pages'));
}
public function actionIndex()
{
//include scripts and css
Yii::app()->getClientScript()->registerCoreScript('jquery');
$cs = Yii::app()->clientScript;
$cs->registerScriptFile('/js/' . 'books.js');
// register script file
//
//pager creation
$criteria = new CDbCriteria();
$count = Books::model()->count($criteria);
$pages = new CPagination($count);
// elements on page
$pages->pageSize = 5;
$pages->applyLimit($criteria);
$b_data = Books::model()->with('authors')->findAll($criteria);
//get Book with authors through many to many relation
foreach ($b_data as $item) {
//get only author lastname.
$tmp_auth = array();
foreach ($item->authors as $auth) {
$tmp_auth[] = $auth->firstname . ' ' . $auth->lastname;
}
$item->authors = $tmp_auth;
}
$this->render('index', array('b_data' => $b_data, 'pages' => $pages));
}
public function actionIndex()
{
$id = $_REQUEST['category_id'];
$price = $_REQUEST['price'];
$category = Category::model()->findByPk($id);
if ($id) {
$catmodel = new Category();
$ids = $catmodel->getMeChildsId($id);
$cid = implode(',', $ids);
$condition = $id ? 'is_show = 1 and category_id in (' . $cid . ')' : 'is_show = 1';
}
if ($price) {
if ($price && $id) {
$catmodel = new Category();
$ids = $catmodel->getMeChildsId($id);
$cid = implode(',', $ids);
$condition = $id ? 'is_show = 1 and shop_price=' . $price . ' and category_id in (' . $cid . ')' : 'is_show = 1';
}
}
$keyword = $_REQUEST['keyword'];
if ($keyword) {
$condition = $keyword ? 'is_show = 1 and title like' . "'%{$keyword}%'" . 'or sn like' . "'%{$keyword}%'" : 'is_show = 1';
}
$criteria = new CDbCriteria(array('condition' => $condition, 'order' => 'sort_order asc, item_id desc'));
$count = Item::model()->count($criteria);
$pages = new CPagination($count);
// results per page
$pages->pageSize = 20;
$pages->applyLimit($criteria);
$items = Item::model()->findAll($criteria);
$this->render('index', array('items' => $items, 'pages' => $pages, 'keyword' => $keyword, 'category' => $category));
}
/**
* 操作日志列表
*/
public function ActionOperationLogList()
{
$criteria = new CDbCriteria();
// 判断查询类型 (分页查询 / 条件查询)
$searchType = Yii::app()->request->getParam('searchType');
if ($searchType === 'page') {
$search_condition = unserialize(base64_decode(Yii::app()->request->getParam('search_condition')));
// 对分布传来的数据进行还原
} else {
// 如有搜索条件 则获取条件并过滤条件数组中的空格与空值
if (!empty($_POST['search'])) {
foreach ($_POST['search'] as $key => $val) {
$search_condition[$key] = trim($val);
}
$search_condition = array_filter($search_condition);
} else {
$search_condition = '';
}
}
// 增加搜索条件 [S]
// 搜索条件中包含时间 则添加时间查询条件
if (!empty($search_condition['start_time']) || !empty($search_condition['end_time'])) {
// 如起始时间与结束时间一致 则查询同一个时间点的数据
if (!empty($search_condition['start_time']) && !empty($search_condition['end_time']) && $search_condition['start_time'] == $search_condition['end_time']) {
$criteria->addSearchCondition('CreationDate', $search_condition['start_time']);
} else {
// 1.只按起始时间查询 2.只按结束时间查询 3.按起始+结束时间段查询
if (!empty($search_condition['start_time']) && empty($search_condition['end_time'])) {
$criteria->addCondition('CreationDate >= :start_time');
$criteria->params[':start_time'] = $search_condition['start_time'] . ' 23:59:59';
} else {
if (empty($search_condition['start_time']) && !empty($search_condition['end_time'])) {
$criteria->addCondition('CreationDate <= :end_time');
$criteria->params[':end_time'] = $search_condition['end_time'] . ' 23:59:59';
} else {
$criteria->addBetweenCondition('CreationDate', $search_condition['start_time'], $search_condition['end_time']);
}
}
}
}
// 搜索条件中包含真实姓名 则添加关联查询及条件
if (!empty($search_condition['real_name'])) {
$criteria->with = array('account' => array('joinType' => 'INNER JOIN', 'condition' => 'account.RealName="' . $search_condition['real_name'] . '"'));
}
//增加搜索条件 [E]
// 分页配置
$criteria->order = 't.ID DESC';
$count = OperationLog::model()->count($criteria);
$pager = new CPagination($count);
if (!empty($search_condition)) {
//判断是否存在搜索条件，并对搜索条件进行数据处理（便于url传输）
$pager->params = array('search_condition' => base64_encode(serialize($search_condition)), 'searchType' => 'page');
}
$pager->pageSize = 20;
$pager->applyLimit($criteria);
// 获取日志列表
$operation_log_list = OperationLog::model()->findAll($criteria);
// 跳转至用户操作日志页面
$this->render('list_operation_log', array('operation_log_list' => $operation_log_list, 'pages' => $pager, 'search_condition' => $search_condition));
}
