public function index() { $type = $_REQUEST['type']; $key = $_REQUEST['key']; if (!get_magic_quotes_gpc()) { $key = addslashes($key); } $sql = array(); if (!empty($key) && !empty($type)) { switch (true) { case $type == 'name': $sql['name'] = array('like', "%{$key}%"); //名称模糊查找 break; case $type == 'id': $sql['id'] = intval($key); //名称模糊查找 break; case $type == 'brand': $sql['brand'] = $key; //品牌查找 break; case $type == 'cateid': $sql['cateid'] = $key; //类别查找 break; case $type == 'pricelt': $sql['price'] = array('lt', $key); //价格小于 break; case $type == 'pricegt': $sql['price'] = array('gt', $key); //价格大于 break; } } elseif (!empty($key)) { $sql['name'] = array('like', "%{$key}%"); //名称模糊查找 $sql['serial'] = array('like', "%{$key}%"); //名称模糊查找 $sql['id'] = intval($key); $sql['_logic'] = 'or'; } $map['isdown'] = array('neq', '1'); parent::$Model = D("Products"); if (isset($_REQUEST['key'])) { $_SESSION['map'] = $sql; } elseif (isset($_REQUEST['map'])) { $sql = $_SESSION['map']; } $this->disp_text = "Search"; parent::$Model->_list($this->view, $sql, 'sort', false); $this->display(); }
function contact_us() { $article_cache = md5('article_conatct_us'); if (S($article_cache) == '') { parent::$Model = D('Article'); $map['title'] = 'Contact-us'; $list = parent::$Model->where($map)->find(); $list['title'] = str_replace("-", " ", $list['title']); S($article_cache, $list); } $list = S($article_cache); $this->assign($list); $this->pagetitle = $list['title']; $this->pagekeywords = $list['keywords']; $this->pagedesc = $list['description']; $this->display("Empty:contact_us"); }
function delProducts() { $id = intval($_REQUEST['id']); if ($id) { //获得所有子类 parent::$Model = D('Cate'); $cate_in_id = implode(',', parent::$Model->getChildren($id, $id)); if ($cate_in_id) { //获得所有产品 parent::$Model = D('Products'); $map['cateid'] = array('in', $cate_in_id); $count = parent::$Model->where($map)->count(); $j = $k = $l = 0; if ($count) { $list = parent::$Model->where($map)->select(); $products_ids = implode(',', array_map('reset', parent::$Model->field('id')->where($map)->select())); if ($products_ids) { //删除产品属性 parent::$Model = D('Products_attr'); parent::$Model->del_attrs($products_ids); } parent::$Model = D('Products_gallery'); foreach ($list as $v) { $v['bigimage'] = auto_charset($v['bigimage'], 'utf-8', 'gbk'); $v['smallimage'] = auto_charset($v['smallimage'], 'utf-8', 'gbk'); if (file_exists($v['bigimage'])) { $j++; unlink($v['bigimage']); } if (file_exists($v['smallimage'])) { unlink($v['smallimage']); } //删除产品相册 $g = parent::$Model->where(array('pid' => $v['id']))->find(); $g['img_url'] = auto_charset($v['img_url'], 'utf-8', 'gbk'); $g['thumb_url'] = auto_charset($v['thumb_url'], 'utf-8', 'gbk'); if (file_exists($v['img_url'])) { $k++; unlink($v['img_url']); } if (file_exists($v['thumb_url'])) { unlink($v['thumb_url']); } parent::$Model->where(array('pid' => $v['id']))->delete(); //删除关联产品数据 parent::$Model = D("Products_related"); parent::$Model->where(array("products_id" => $v['id']))->delete(); $l++; } //最后删除产品 parent::$Model = D('Products'); parent::$Model->where($map)->delete(); $str = "共删除了 " . $count . " 个产品,其中删除了" . $j . "个产品图片 " . $k . " 个相关图片 " . $l . " 个关联产品!"; $this->success($str); } else { $this->error('没有产品数据!'); } } else { $this->error('请选择类别!'); } } else { $this->error('请选择类别!'); } }
function doDelRelated() { parent::$Model = D('Products_related'); if ($_REQUEST['id']) { $map['id'] = array('in', $_REQUEST['id']); $j = parent::$Model->where($map)->delete(); $this->success('删除了' . $j . '个关联产品!'); } $this->error('删除失败!'); }