/**
  * 首页
  *
  */
 public function actionIndex()
 {
     $model = new Goods();
     $criteria = new CDbCriteria();
     $condition = "type = " . $this->_type;
     $goods_name = trim($this->_request->getParam('goods_name'));
     $catalogId = intval($this->_request->getParam('catalogId'));
     $goods_name && ($condition .= ' AND goods_name LIKE \'%' . $goods_name . '%\'');
     $catalogId && ($condition .= ' AND catalog_id= ' . $catalogId);
     $criteria->condition = $condition;
     $criteria->order = 't.id DESC';
     $criteria->with = array('catalog');
     $count = $model->count($criteria);
     $pages = new CPagination($count);
     $pages->pageSize = 10;
     //根据goods_name,catelogId查询
     $pageParams = $this->buildCondition($_GET, array('goods_name', 'catalogId'));
     $pages->params = is_array($pageParams) ? $pageParams : array();
     $criteria->limit = $pages->pageSize;
     $criteria->offset = $pages->currentPage * $pages->pageSize;
     $result = $model->findAll($criteria);
     //推荐位
     $recom_list = RecommendPosition::model()->findAll('type=:type', array(':type' => $this->_type), array('order' => 'id'));
     $this->render('index', array('datalist' => $result, 'pagebar' => $pages, 'recom_list' => $recom_list));
 }
Beispiel #2
0
    if (!$result) {
        flash();
    }
}
if (isset($_POST['del']) && !empty($_POST['id'])) {
    $result = $goods->del($_POST['id']);
}
if (isset($_GET['do'])) {
    $do = trim($_GET['do']);
    if (!empty($_GET['id'])) {
        $id = intval($_GET['id']);
    }
    if ($do == "del" && !empty($id)) {
        $result = $goods->del($_GET['id']);
    }
    if ($do == "edit") {
        if (!empty($id)) {
            $result = $goods->read("*", $id);
            setvar("item", $result);
        }
        $tpl_file = "goods.edit";
        template($tpl_file);
        exit;
    }
}
$amount = $goods->findCount();
$page->setPagenav($amount);
$result = $goods->findAll("*", null, $conditions, "id desc", $page->firstcount, $page->displaypg);
setvar("Items", $result);
setvar("ByPages", $page->pagenav);
template($tpl_file);
 function ceshi()
 {
     $model = new Goods();
     //$info = $model -> findAllByPk(10);
     //$info = $model -> findAllByPk(1,4,9);
     ///////////////////////////////////////////
     //findAll($condition ,$param);
     //$condition就是sql语句的where条件
     //$infos = $model -> findAll("goods_name like'诺%' and goods_price > 500");
     //////////////////////////////////////////
     //为了避免sql注入,使用占位符填充
     //$infos = $model -> findAll("goods_name like :name and goods_price > :price",array(":name"=>	'诺%',":price"=>500) );
     //$model -> goods_name = 'sanming';
     //$model -> save();
     //有时候我们查询信息
     //想要查询的"字段" select
     //想要查询的"条件" condition
     //想要查询的"排序" order
     //想要查询的"分组" group
     //想要查询的"限制" limit
     //想要查询的"偏移量" offset
     //$infos = $model -> findAll(array(
     //	'select'=>'goods_name,goods_price',
     //	'condition'=>"goods_name like '诺%'",
     //	'order'=>'goods_price desc',
     //	'limit'=>3,
     //	'offset'=>2,
     //));
     ///////////////////////////////////////////
     //通过criteria实现信息的查询
     $criteria = new CDbCriteria();
     $criteria->select = 'goods_name,goods_price';
     $criteria->condition = "goods_name like '诺%'";
     $criteria->limit = 3;
     $criteria->order = 'goods_price desc';
     $infos = $model->findAll($criteria);
 }