wpfw_ewei_shopv2/pcsite/controller/home.php

<?php
if (!defined('ES_PATH')) {
	exit('Access Denied');
}

class HomeController extends Controller
{
	protected $type = 'set';
	protected $site;

	public function __construct()
	{
		$this->init();
	}

	public function init()
	{
		$set = pdo_fetch('select * from ' . tablename('ewei_shop_system_site') . ' where `type`=:type', array(':type' => $this->type));

		if (empty($set)) {
			exit('请先到【系统设置】->【网站】->【基础设置】 配置网站数据.');
		}

		if (!empty($set['content']) && !is_array($set['content'])) {
			if (strexists($set['content'], '{"')) {
				$data = json_decode($set['content'], true);
            } else {
				$data = unserialize($set['content']);
			}
		}

		if (!is_array($data)) {
			$data = array();
		}

		$this->site = $data;

		if (empty($data['status'])) {
			$this->shutdown($data);
		}
	}

	public function index()
	{
		global $_W;
		$site = $this->site;
		$banner = $this->banner(1);
		$casus = $this->casus(1);
		$link = $this->link(1);
		$article = $this->article(1);
		$companyArticle = $this->companyArticle();
		$basicset = $this->basicset();
		$title = $basicset['title'];
		include $this->template('index');
	}

	public function ajaxguestbook()
	{
		global $_GPC;
		$guestbookform['nickname'] = trim($_GPC['nickname']);
		$guestbookform['mobile'] = trim($_GPC['mobile']);
		$guestbookform['email'] = trim($_GPC['email']);
		$guestbookform['content'] = trim($_GPC['content']);

		if (empty($guestbookform['nickname'])) {
			exit(json_encode(array('status' => 'error', 'message' => '姓名不能为空!', 'type' => 'nickname')));
		}

		if (empty($guestbookform['mobile'])) {
			exit(json_encode(array('status' => 'error', 'message' => '电话不能为空!', 'type' => 'mobile')));
		}

		if (empty($guestbookform['email'])) {
			exit(json_encode(array('status' => 'error', 'message' => '邮箱不能为空!', 'type' => 'email')));
		}

		if (empty($guestbookform['content'])) {
			exit(json_encode(array('status' => 'error', 'message' => '内容不能为空!', 'type' => 'content')));
		}

		$guestbook = pdo_fetch('SELECT * FROM' . tablename('ewei_shop_system_guestbook') . ' WHERE clientip=:clientip ORDER BY createtime DESC LIMIT 1', array(':clientip' => ES_CLIENT_IP));
		if (!empty($guestbook) && TIMESTAMP <= $guestbook['createtime'] + 60) {
			exit(json_encode(array('status' => 'error', 'message' => '距离上次留言时间小于1分钟!')));
		}

		$guestbookform['createtime'] = TIMESTAMP;
		$guestbookform['clientip'] = ES_CLIENT_IP;
		pdo_insert('ewei_shop_system_guestbook', $guestbookform);

		if (pdo_insertid()) {
			echo json_encode(array('status' => 'success', 'message' => '留言成功!'));
        } else {
			echo json_encode(array('status' => 'error', 'message' => '留言失败!'));
		}
	}

	protected function shutdown(array $data)
	{
		$url = $this->site['closeurl'];

		if (empty($url)) {
			exit('网站已经关闭');
        } else {
			header('location: ' . $url);
            exit;
		}
	}

	protected function banner($status = 'all')
	{
		$statusSql = $this->statusSql($status);
		$result = pdo_fetchall('SELECT * FROM ' . tablename('ewei_shop_system_banner') . (' WHERE 1 ' . $statusSql['sql'] . '  ORDER BY displayorder DESC'), $statusSql['param']);
		return $result;
	}

	protected function casus($status = 'all')
	{
		$statusSql = $this->statusSql($status);
		$result = pdo_fetchall('SELECT * FROM ' . tablename('ewei_shop_system_case') . (' WHERE 1 ' . $statusSql['sql'] . '  ORDER BY displayorder DESC'), $statusSql['param']);
		return $result;
	}

	protected function link($status = 'all')
	{
		$statusSql = $this->statusSql($status);
		$result = pdo_fetchall('SELECT * FROM ' . tablename('ewei_shop_system_link') . (' WHERE 1 ' . $statusSql['sql'] . '  ORDER BY displayorder DESC'), $statusSql['param']);
		return $result;
	}

	protected function article($status = 'all', $limit = 6)
	{
		$statusSql = $this->statusSql($status);
		$statusSql['sql'] = str_replace(' status ', ' a.status ', $statusSql['sql']);
		$result = pdo_fetchall('SELECT a.id,a.title,a.content,a.createtime,c.name FROM ' . tablename('ewei_shop_system_article') . ' AS a LEFT JOIN ' . tablename('ewei_shop_system_category') . (' AS c ON a.cate = c.id WHERE 1 ' . $statusSql['sql'] . '  ORDER BY a.displayorder DESC LIMIT ' . $limit), $statusSql['param']);
		return $result;
	}

	protected function companyArticle($status = 'all', $limit = 6)
	{
		$statusSql = $this->statusSql($status);
		$statusSql['sql'] = str_replace(' status ', ' a.status ', $statusSql['sql']);
		$result = pdo_fetchall('SELECT a.*,c.id as cid,c.name FROM ' . tablename('ewei_shop_system_company_article') . ' AS a LEFT JOIN ' . tablename('ewei_shop_system_company_category') . (' AS c ON a.cate = c.id WHERE 1 ' . $statusSql['sql'] . '  ORDER BY a.displayorder DESC LIMIT ' . $limit), $statusSql['param']);
		return $result;
	}

	/**
     * 拼接sql status语句
     * @param $status
     * @return array
     */
	protected function statusSql($status)
	{
		$condition = '';
		$param = array();

		if ($status != 'all') {
			$status = intval($status);
			$condition .= 'AND status = :status';
			$param[':status'] = $status;
		}

		return array('sql' => $condition, 'param' => $param);
	}
}

?>