/** * Return all categories. * * @author Kuldeep Dangi <*****@*****.**> */ public function actionGetALLCategories() { $this->result['success'] = true; $model = new Category(); $this->result['data'] = $model->findAll(); $this->sendResponse($this->result); }
public function getTree() { $criteria = new CDbCriteria(); $criteria->order = 't.lft'; $catRoot = new Category(); return $catRoot->findAll($criteria); }
public static function getcat($pid) { $model = new Category(); $criteria = new CDbCriteria(); $criteria->addCondition("is_show=1 and pid={$pid}"); $criteria->order = 'orderid ASC'; $cat = $model->findAll($criteria); return $cat; }
/** * Get a list of categories * * @param Request $request * @param string $params * @return void */ protected static function get($request, $params) { try { $categories = Category::query($request->get('queryParams'), $request->include); } catch (OutOfBoundsException $e) { $categories = Category::findAll($request->include); } static::response($categories, 200); }
public function __construct() { AuthUser::load(); if (!AuthUser::isLoggedIn()) { echo 'Please Login'; header('location:index.php?job=login'); } //首页最近文章 //$this->recent_post = Article::getPost(5, true); //侧栏分类 $this->categories = Category::findAll(); if (is_array($this->categories) && count($this->categories) > 0) { $temp = array(); foreach ($this->categories as $k => $v) { $temp[$v->id] = get_object_vars($v); } $this->cahce_categories = $temp; $temp = array(); } //Tags 后期改进为热词形式 $hot_tags = Tag::findAll(20); //mprint_r($hot_tags, '$hot_tags'); if (count($hot_tags) > 0) { $first = current($hot_tags); $last = end($hot_tags); foreach ($hot_tags as $k => $v) { $tags_list[$k]['word'] = $v->name; $tags_list[$k]['size'] = tagClouds($v->count, $first->count, $last->count); } } $this->tags_list = $tags_list; $tags = Tag::findAll(); //var_dump($tags); $content_tag = Record::findAllFrom('ContentTag'); //var_dump($content_tag); //关系表中存在的文章ID以及tag集合到一个数组中tag_cache 避免在遍历生成文章静态页时重复读取数据库 //遍历所有tag 组合出方便调用的形式 if (is_array($tags) && count($tags) > 0) { $temp_tags = array(); foreach ($tags as $k => $v) { $temp_tags[$v->id] = $v->name; } } //遍历关系表 if (is_array($content_tag) && count($content_tag) > 0) { $this->cahce_tags = array(); foreach ($content_tag as $k => $v) { if (isset($temp_tags[$v->tag_id])) { $this->cahce_tags[$v->content_id][] = $temp_tags[$v->tag_id]; } } } //清空临时数据 $tags = $content_tag = $temp_tags = array(); }
public function index($category_id) { //var_dump($_GET['search']); // Blogクラスから$Blogインスタンス生成 $Blog = new Blog($this->plural_resource); if (isset($_GET['search'])) { $sql = $Blog->findAll($category_id, $_GET['search']); } else { $sql = $Blog->findAll($category_id); // 'SELECT * FROM blogs'という文字列が返ってくる } //var_dump($sql); $blogs = mysqli_query($this->db, $sql) or die(mysqli_error($this->db)); //var_dump($blogs); //var_dump('test'); $Category = new Category('categories'); $cat_sql = $Category->findAll(); //var_dump($cat_sql); $categories = mysqli_query($this->db, $cat_sql) or die(mysqli_error($this->db)); //var_dump($categories); $return['blogs'] = $blogs; $return['categories'] = $categories; return $return; }
</tr> </thead> <tbody id="alter_rows"> <?php $count_record = Category::countCategory(0); if (!isset($_REQUEST['page'])) { $page = 1; } else { $page = $_GET[page]; } $pagination = new Pagination(); //for display $pg = $pagination->page_pagination(20, $count_record, $page, 20); //$result_prod = mysql_query($query_Recordset2.$pg[1]); $category = Category::findAll($pg[1], 0); ?> <? if($count_record == 0) { ?> <tr> <td colspan="3" align="center" style="font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#F00; font-weight:bold">No Record Found</td> </tr> <? } else { foreach($category as $categories) { ?> <tr> <td> <?php echo $categories->fldCategoryID; ?> </td>
<?php // create category list $category = new Category(); $categoryList = $category->findAll($connect); $connect->close(); ?> <form action='' id="productForm" method=post> <input type="hidden" name="id" id="id" value="<?php echo empty($product) ? '' : $product->id; ?> "/> <label> <span class="span">Product name</span> <input type='text' name='title' id='title' value="<?php echo empty($product) ? '' : $product->title; ?> "/> <span>*<?php echo !isset($validateResult['fieldsErrors']['title']['errorMsg']) ? '' : $validateResult['fieldsErrors']['title']['errorMsg']; ?> </span> </label> <br/> <label> <span class="span">Price</span> <input type='text' name='price' id='price' value="<?php echo empty($product) ? '' : $product->price; ?> "/> <span>*<?php
public static function getDropList($pid) { $model = new Category(); $criteria = new CDbCriteria(); $criteria->addCondition("pid={$pid}"); $criteria->order = 'orderid ASC'; $data = $model->findAll($criteria); if ($data) { foreach ($data as $key => $row) { $dropList[$row['id']] = $row['name']; } } return $dropList; }
public function __construct() { /* $cache = new FileCache(); $cache->cachePath = DATA_DIR.'cache/'; //侧栏分类 $categories = $cache->get('categories'); if($categories === false) { $categories = array(); //获得所有分类 $categories[0] = Category::findAll(); if(is_array($categories[0]) && count($categories[0]) > 0) { foreach($categories[0] as $k => $v) { //$this->categories[$v->id] = get_object_vars($v); $categories[1][$v->id] = $v; $categories[1][$v->slug] = $v; } } $cache->set('categories', $categories, 7200);//缓存2小时 del_cache(); } //Tags 热词 $hot_tags = $cache->get('hot_tags'); if($hot_tags === false) { $hot_tags = Tag::findAll(30); $cache->set('hot_tags', $hot_tags, 7200); } */ //-------------------------------- //首页最近文章 $this->recent_post = Article::getPost(5, true); //侧栏分类 $this->categories = Category::findAll(); if (is_array($this->categories) && count($this->categories) > 0) { $temp = array(); foreach ($this->categories as $k => $v) { $temp[$v->id] = get_object_vars($v); } $this->cahce_categories = $temp; $temp = array(); } //Tags 后期改进为热词形式 $this->tags_list = Tag::findAll(30); $tags = Tag::findAll(); $content_tag = Record::findAllFrom('ContentTag'); //遍历所有tag 组合出方便调用的形式 if (is_array($tags) && count($tags) > 0) { $temp_tags = array(); foreach ($tags as $k => $v) { $temp_tags[$v->id] = $v->name; } } //遍历关系表 if (is_array($content_tag) && count($content_tag) > 0) { $this->cahce_tags = array(); foreach ($content_tag as $k => $v) { if (isset($temp_tags[$v->tag_id])) { $this->cahce_tags[$v->content_id][] = $temp_tags[$v->tag_id]; } } } //清空临时数据 $tags = $content_tag = $temp_tags = array(); }
</div> <?php } ?> </div> </nav> <div class="wrapper wrapper--dropdownmenu"> <div class="container"> <ul class="header-menu-primary__dropdownmenu__container"> <li class="dropdownmenu__item"> <ul class="dropdownmenu__item__list"> <?php $data_cat = new Category(); $list = $data_cat->findAll(); $i = 1; foreach ($list as $k => $v) { //if($i%8==0) { // echo '</ul></li>'; // echo ' <li class="dropdownmenu__item"> // <ul class="dropdownmenu__item__list">'; //} echo '<li class="dropdownmenu__item__list__item"><h3 class="dropdownmenu__item__list__item__title">' . $v->name . '</h3></li>'; $model = new Occupation(); $list1 = $model->localized('ru')->findAll('cat_id=:cid', array(':cid' => $v->id)); $i = 1; foreach ($list1 as $k1 => $v1) { //echo '<li class="dropdownmenu__item__list__item"><a href="" class="dropdownmenu__item__list__item__link">Воздушные акробаты<span class="dropdown__link__col"> (25)</span></a></li>'; if ($v1->alias != '') { $alias = $v1->alias;
public function createPostHtml($obj = null) { global $tpl; if (is_object($obj) && DEBUG === false) { $post = clone $obj; $post->content = processContent($post->content); //上一篇文章 $previous = $obj->previous(); //下一篇文章 $next = $obj->next(); //首页最近文章 $recent_post = Article::getPost(5, false); //侧栏分类 $categories = Category::findAll(); //Tags $hot_tags = Tag::findAll(30); //mprint_r($hot_tags, '$hot_tags'); if (count($hot_tags) > 0) { $first = current($hot_tags); $last = end($hot_tags); foreach ($hot_tags as $k => $v) { $tags_list[$k]['word'] = $v->name; $tags_list[$k]['size'] = tagClouds($v->count, $first->count, $last->count); } } //smarty $tpl->assign('post', $post); $tpl->assign('next', $next); $tpl->assign('previous', $previous); $tpl->assign('recent_post', $recent_post); $tpl->assign('categories', $categories); $tpl->assign('tag_list', $tags_list); $filetpl = SYSTEM_ROOT . 'templates/' . DEFAULT_TEMPLATE . '/post.html'; $path = SYSTEM_ROOT . 'post/'; //$filename = !empty($obj->slug) ? str_replace(' ', '-', trim($obj->slug)) : $obj->id; $filename = $obj->id; $file = $path . $filename . '.html'; file_put_contents($file, $tpl->fetch($filetpl)); @chmod($file, 0777); } }
public function run() { $model = new Category(); $info = $model->findAll(); $this->render('menu', array('info' => $info)); }
public function __construct() { global $tpl, $app; $app->refresh(); $this->cache = new FileCache(); $this->cache->cachePath = DATA_DIR . 'cache/'; //侧栏分类 $categories = $this->cache->get('categories'); if ($categories === false) { $categories = array(); //获得所有分类 $categories[0] = Category::findAll(); if (is_array($categories[0]) && count($categories[0]) > 0) { foreach ($categories[0] as $k => $v) { $categories[0][$k]->url = SITE_URL . 'category/' . $v->slug . '/'; //$this->categories[$v->id] = get_object_vars($v); $categories[1][$v->id] = $v; $categories[1][$v->slug] = $v; } } if (DEBUG === false) { $this->cache->set('categories', $categories, 7200); //缓存2小时 del_cache(); } } //mprint_r($categories[0], 'a'); //分别以ID, slug为键值的分类组合 $this->categories = $categories[1]; //Tags 热词 $tags_list = $this->cache->get('hot_tags'); if ($tags_list === false) { $hot_tags = Tag::findAll(20); //mprint_r($hot_tags, '$hot_tags'); if (count($hot_tags) > 0) { $first = current($hot_tags); $last = end($hot_tags); foreach ($hot_tags as $k => $v) { $tags_list[$k]['word'] = $v->name; $tags_list[$k]['size'] = tagClouds($v->count, $first->count, $last->count); $tags_list[$k]['url'] = SITE_URL . 'tag/' . strtolower($v->name) . '/'; } } if (DEBUG === false) { $this->cache->set('hot_tags', $tags_list, 7200); } } //首页最近文章 $recent_post = $this->cache->get('recent_post'); if ($recent_post === false) { $recent_post = Article::getPost(5); if (is_array($recent_post) && count($recent_post) > 0) { foreach ($recent_post as $key => $val) { $recent_post[$key]->url = SITE_URL . 'post/' . $val->id . '.html'; } } if (DEBUG === false) { $this->cache->set('recent_post', $recent_post, 7200); //缓存2小时 del_cache(); } } //mprint_r($recent_post, '$recent_post'); $tpl->assign('recent_post', $recent_post); $tpl->assign('categories', $categories[0]); $tpl->assign('tag_list', $tags_list); }
public function editAction($args = null) { global $tpl; $data = isset($_POST['cat']) ? $_POST['cat'] : array(); if (isset($_POST['submit'])) { //var_dump($data); $category = new Category('id', $date['id']); //更新当前分类 $pid = (int) $data['pid']; if ($pid == 0) { //顶级分类, path为0,本身ID $category->path = '0,' . $category->id; $category->pid = 0; } elseif ($pid > 0) { //查询父ID的path $parent_category = new Category('id', $pid); $category->pid = $parent_category->id; $category->path = $parent_category->path . ',' . $category->id; } $category->save('category'); $_POST = array(); header('location:index.php?job=admin_category'); } else { $id = isset($args['id']) ? (int) $args['id'] : ''; $category = new Category('id', $id); //参数改进 //$category = get_object_vars($category); $tpl->assign('cat', $category); //查出所有分类 //$result = Category::findAll(); $result = Category::findAll(); //var_dump($result); $tpl->assign('cats', $result); $tpl->display('admin/categroy_edit.html'); } }