/** * Function that collects connection info * returns a Content list used for error handling (only on debugging mode) * * @return ContentList */ private function getDebuggingContentList() { $contents = new ContentList ( "Server", $this->host ); $contents->addContent ( "User", $this->user ); $contents->addContent ( "Password", $this->password ); $contents->addContent ( "Schema", $this->schema ); $contents->addContent ( "MySQL Error", mysql_error () ); return $contents; }
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 6))); $caseType = ContentList::getList($params); Template::assign('caseType', $caseType); Template::display('ht/module/case.tpl');
$msg = '操作成功'; global $currentUserInfo; $typeid = (int) $_REQUEST['typeid']; $id = (int) $_REQUEST['id']; switch ($act) { case 'update': $item = array('id' => $id, 'typeid' => $typeid, 'content' => stripslashes($_REQUEST['text']), 'title' => stripslashes($_REQUEST['title']), 'lang' => 'ch', 'itemtime' => time(), 'minimg' => stripslashes($_REQUEST['minimg']), 'maximg' => stripslashes($_REQUEST['maximg'])); if ($id) { ContentList::update($item); } else { ContentList::add($item); } break; case 'delete': if ($id) { $result = ContentList::del(array('id' => $id)); if ($result > 0) { $code = 0; $msg = "删除成功"; } else { $code = 1; $msg = "删除失败"; } } else { $code = 1; $msg = "无效的id"; } break; default: $code = 1; $msg = '没有这个操作';
public function actionSuggestContent() { ContentList::suggestContent(); }
<?php echo CHtml::ajax(array('url' => array('dynamicTerms'), 'data' => array('q' => 'js:$(\'#content_type_box\').val()', 'lang' => 'js:$(\'#content_lang_box\').val()', 'YII_CSRF_TOKEN' => Yii::app()->getRequest()->getCsrfToken()), 'type' => 'post', 'dataType' => 'html', 'success' => "function(data)\n {\n \$('#term_id').empty();\n \$('#term_id').append(data);\n\n } ")); ?> } </script> <?php echo $form->error($model, 'content_type'); ?> </div> <div class="left" style="margin-left:20px"> <?php echo $form->labelEx($model, 'terms'); ?> <?php echo $form->listBox($model, 'terms', ContentList::getTerms(), array('id' => 'term_id', 'multiple' => 'multiple', 'style' => 'width:250px; height:100px', 'class' => 'listbox')); ?> <?php echo $form->error($model, 'terms'); ?> </div> <div class="left"> <?php echo $form->labelEx($model, 'tags'); ?> <?php $this->widget('CAutoComplete', array('model' => $model, 'mustMatch' => true, 'attribute' => 'tags', 'url' => array('suggestTags'), 'multiple' => true, 'htmlOptions' => array('size' => 50, 'style' => 'width:300px'))); ?> <?php echo $form->error($model, 'tags');
public static function getContentList($content_list_id, $max = null, $pagination = null, $return_type = ConstantDefine::CONTENT_LIST_RETURN_ACTIVE_RECORD) { //Find the content list model first $model = ContentList::model()->findbyPk($content_list_id); $condition = 't.object_status = :status and t.object_date < :time'; $params = array(':status' => ConstantDefine::OBJECT_STATUS_PUBLISHED, ':time' => time()); if (isset($model)) { if ($model->type == ConstantDefine::CONTENT_LIST_TYPE_AUTO) { //auto $criteria_field = 'object_date DESC'; //object_type if (isset($model->content_type)) { $content_types = $model->content_type; if ($content_types[0] != 'all') { $condition .= ' AND (0'; foreach ($content_types as $type) { $condition .= ' or object_type="' . $type . '"'; } $condition .= ')'; } } //terms if (isset($model->terms)) { $content_terms = $model->terms; if ($content_terms[0] != '0') { $condition .= ' AND (0'; foreach ($content_terms as $term) { $condition .= ' or (ID in (select object_id from `{{object_term}}` where term_id=' . $term . '))'; } $condition .= ')'; } } //criteria not newest if ($model->criteria != ConstantDefine::CONTENT_LIST_CRITERIA_NEWEST) { $criteria_field = 'object_view DESC'; } if ($return_type == ConstantDefine::CONTENT_LIST_RETURN_DATA_PROVIDER && $model->number > 1) { $sort = new CSort('Object'); $sort->defaultOrder = 't.object_date DESC'; $sort->attributes = array('object_view' => array('asc' => 'object_view ASC', 'desc' => 'object_view DESC'), 'object_date' => array('asc' => 't.object_date ASC', 'desc' => 't.object_date DESC')); return new CActiveDataProvider('Object', array('criteria' => array('condition' => $condition, 'order' => $criteria_field, 'params' => $params, 'limit' => isset($max) ? $max : $model->number), 'pagination' => array('pageSize' => isset($max) ? $max : $model->number * $model->paging, 'pageVar' => 'page'), 'sort' => $sort)); } return Object::model()->findAll(array('condition' => $condition, 'params' => $params, 'order' => $criteria_field, 'limit' => isset($max) ? $max : $model->number)); } //manual if (isset($model->manual_list_id)) { $condition = ''; $manual_list = explode(',', $model->manual_list_id); $count = 0; foreach ($manual_list as $manual_id) { //$condition .= ' OR ID = '.$manual_id; if ($count == 0) { $condition = 'ID =' . $manual_id; } else { $condition .= ' union select * from {{object}} where id=' . $manual_id; } if (isset($max) && $count == $max) { break; } $count++; } if ($return_type == ConstantDefine::CONTENT_LIST_RETURN_DATA_PROVIDER && count($manual_list) > 1) { return new CActiveDataProvider('Object', array('criteria' => array('condition' => $condition, 'params' => $params), 'pagination' => array('pageSize' => isset($max) ? $max : $model->number * $model->paging, 'pageVar' => 'page'))); } return Object::model()->findAll(array('condition' => $condition, 'params' => $params)); } } return null; }
<?php //ini_set("display_errors" ,1 ); require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = 'zhao'; //搜索关键词 $indexSearch = ContentList::search($params); Template::assign('indexType', $indexSearch); Template::display('search.tpl');
<iframe id='contentlist_iframe' src="<?php echo Yii::app()->request->baseUrl; ?> /contentlist/create/embed/iframe" frameborder="0" onLoad="autoResize(this);" height="30px" width="100%"></iframe> </div> <script type="text/javascript"> <?php if (is_array($block_model->content_list) && !empty($block_model->content_list)) { ?> <?php $content_items = array(); foreach ($block_model->content_list as $obj_id) { $temp_object = ContentList::model()->findByPk($obj_id); if ($temp_object) { $content_items['item_' . $temp_object->content_list_id]['id'] = $temp_object->content_list_id; $content_items['item_' . $temp_object->content_list_id]['title'] = $temp_object->name; } } echo 'var manual_content_list = ' . json_encode($content_items) . ';'; ?> $.each(manual_content_list, function(k,v) { addContentList(v.title,v.id); }); <?php } ?>
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 4))); $honorType = ContentList::getList($params); Template::assign('honorType', $honorType); Template::display('ht/module/honor.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; Template::SetTitle('首页'); $params = array('condition' => array(), 'order' => array()); define('PAGE_SIZE', 1); $p = intval($_GET["p"]) ? intval($_GET["p"]) : "1"; $offset = PAGE_SIZE * ($p - 1); $indexType = ContentList::getList($params, $offset, PAGE_SIZE); $totalcount = $indexType['count']; $pager = new Pager(array('pageSize' => PAGE_SIZE, 'rowCount' => (int) $totalcount)); Template::assign('indexType', $indexType['list']); Template::assign('pager', $pager->genYuan()); Template::assign('usernames', $usernames); Template::display('pager.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 1))); //echo json_encode(ContentList::getList($params)); $indextype = ContentList::getList($params); ContentList::del($params); Template::assign('indextype', $indextype); Template::display('ht/module/index.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 8))); $contactType = ContentList::getList($params); Template::assign('contactType', $contactType); Template::display('ht/module/contact.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $caseid = $_REQUEST['id']; $params = array('condition' => array(array('id', $caseid))); $caseDetail = ContentList::getList($params); Template::assign('caseDetail', $caseDetail); Template::display('ht/module/casedetail.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 2))); $aboutType = ContentList::getList($params); Template::assign('aboutType', $aboutType); Template::display('ht/module/about.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 3))); $directorType = ContentList::getList($params); Template::assign('directorType', $directorType); Template::display('ht/module/director.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 5))); $brandType = ContentList::getList($params); Template::assign('brandType', $brandType); Template::display('ht/module/brand.tpl');
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $params = array('condition' => array(array('typeid', 7))); $worksType = ContentList::getList($params); Template::assign('worksType', $worksType); Template::display('ht/module/works.tpl');
/** * Function to get Object Content List **/ public static function getContentList($cl_id, $max = null, $paging = null, $return_type = ConstantDefine::CONTENT_LIST_RETURN_ACTIVE_RECORD) { $model = ContentList::model()->findByPk($cl_id); //Find the content list model first $condition = 't.object_status = :status and t.object_date < :time'; $params = array(':status' => ConstantDefine::OBJECT_STATUS_PUBLISHED, ':time' => time()); if ($paging == 0) { $page_number = 1; } else { $page_number = $model->paging; } if (isset($model)) { if ($model->type == ConstantDefine::CONTENT_LIST_TYPE_AUTO) { //auto $criteria_field = 'object_date DESC'; //object_type if (isset($model->content_type)) { $content_types = $model->content_type; if ($content_types[0] != 'all') { $condition .= ' AND (0'; foreach ($content_types as $type) { $condition .= ' or object_type="' . $type . '"'; } $condition .= ')'; } } //terms if (isset($model->terms)) { $content_terms = $model->terms; if ($content_terms[0] != '0') { $condition .= ' AND (0'; foreach ($content_terms as $term) { $condition .= ' or (object_id in (select object_id from `{{object_term}}` where term_id=' . $term . '))'; } $condition .= ')'; } } //tags if (isset($model->tags) && $model->tags != '') { $tags = $model->tags; $tag_list = explode(',', $tags); $tag_id_list = ''; foreach ($tag_list as $k => $tag_name) { if ($tag_name == ' ') { unset($tag_list[$k]); } } foreach ($tag_list as $k => $tag_name) { if ($tag_name != ' ') { $id = Yii::app()->db->createCommand()->select('id')->from('gxc_tag')->where('name=:name', array(':name' => trim($tag_name)))->queryRow(); $tag_id_list .= $id['id']; if ($k != sizeof($tag_list) - 1) { $tag_id_list .= ','; } } } $condition .= ' or (object_id in (select object_id from `{{tag_relationships}}` where tag_id in (' . $tag_id_list . ')))'; } //criteria not newest if ($model->criteria != ConstantDefine::CONTENT_LIST_CRITERIA_NEWEST) { $criteria_field = 'object_view DESC'; } if ($return_type == ConstantDefine::CONTENT_LIST_RETURN_DATA_PROVIDER && $model->number >= 1) { $sort = new CSort('Object'); $sort->defaultOrder = 't.object_date DESC'; $sort->attributes = array('object_view' => array('asc' => 'object_view ASC', 'desc' => 'object_view DESC'), 'object_date' => array('asc' => 't.object_date ASC', 'desc' => 't.object_date DESC')); return new CActiveDataProvider('Object', array('criteria' => array('condition' => $condition, 'order' => $criteria_field, 'params' => $params, 'limit' => isset($max) ? $max : $model->number), 'pagination' => array('pageSize' => isset($max) ? $max : $model->number * $page_number, 'pageVar' => 'page'), 'sort' => $sort)); } return Object::model()->findAll(array('condition' => $condition, 'params' => $params, 'order' => $criteria_field, 'limit' => isset($max) ? $max : $model->number)); } else { //manual if (isset($model->manual_list)) { $condition = ''; $manual_list = $model->manual_list; $count = 0; $max = count($manual_list); foreach ($manual_list as $manual_id) { if ($count == 0) { $condition_string = $manual_id; } else { $condition_string .= ',' . $manual_id; } if (isset($max) && $count == $max) { break; } $count++; } $condition = 'object_id IN (' . $condition_string . ')'; if ($return_type == ConstantDefine::CONTENT_LIST_RETURN_DATA_PROVIDER && count($manual_list) >= 1) { return new CActiveDataProvider('Object', array('criteria' => array('condition' => $condition, 'params' => $params, 'order' => 'FIELD(t.object_id, ' . $condition_string . ')'), 'pagination' => array('pageSize' => isset($max) ? $max : $model->number * $page_number, 'pageVar' => 'page'))); } return Object::model()->findAll(array('condition' => $condition, 'params' => $params, 'order' => 'FIELD(t.object_id, ' . $condition_string . ')')); } } } return null; }
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../init.inc.php'; $worksid = $_REQUEST['id']; $params = array('condition' => array(array('id', $worksid))); $worksDetail = ContentList::getList($params); Template::assign('worksDetail', $worksDetail); Template::display('ht/module/worksdetail.tpl');