inc 'common.zl';
inc 'helper.zl';

querys = rqtGetQuery();
action = querys['act'] ? querys['act'] : 'show';
if(action == 'show')
	Article.show();
elif(action == 'list')
	Article.list();
else
	print 'invalid act';
endif

class Article
	// 显示文章内容
	fun show()
		global querys, categories, db;
		id = bltInt(querys['id']);
		data = Mysql.fetchOne(db, "select * from article where id='"+id+"'");
		data['csses'] = bltArray('article-show.css');
		data['head_js'] = bltArray('jquery.yestop.js');
		Article.SetCurCate(categories, data, data['cid']);
		print bltMustacheFileRender("tpl/article_show.tpl", data);
	endfun

	// 显示文章列表
	fun list()
		global querys, categories, db;
		cid = bltInt(querys['cid']);
		where = " where cid=" + cid;
		tmp = Mysql.fetchOne(db, "select count(1) as cnt from article " + where);
		total = bltInt(tmp[cnt]);
		page = get_page(2, total, 10);
		for(i=page['start']; i <= page['end'];i++)
			cur = (page['curpage'] == i) ? ' class="active"' : '';
			pages[] = '<li'+cur+'><a href="'+page['link']+'page='+i+'">'+i+'</a></li>';
		endfor
		data['page'] = page;
		data['pages'] = pages;
		data['articles'] = Mysql.fetchAll(db, "select id,title,thumbnail,description,created_at from article "+ where +
							" order by id desc limit " + page['offset'] + "," + page['limit']);
		Article.SetCurCate(categories, data, cid);
		print bltMustacheFileRender("tpl/article_list.tpl", data);
	endfun

	// 设置当前分类
	fun SetCurCate(categories, data, cid)
		for(i=0;bltIterArray(categories,&i,&v);)
			if(v['id'] == cid)
				v['cur'] = 'yes';
				if(!data['title'])
					data['title'] = v['name'];
				endif
				data['catname'] = v['name'];
				break;
			endif
		endfor
		data['categories'] = categories;
	endfun
endclass

inc 'common.zl';

Index.index();

class Index
	// 首页内容
	fun index()
		global querys, categories, db;
		data['title'] = 'zenglBlog首页';
		data['csses'] = bltArray('index.css');
		data['thumb_articles'] = Mysql.fetchAll(db, "select id,title,thumbnail,description,created_at from article " + 
							" where thumbnail != '' order by id desc limit 0,10");
		data['categories'] = categories;
		for(i=0;i < 2 && bltIterArray(categories,&i,&v);)
			item = bltArray();
			item['cate_id'] = v['id'];
			item['cate_name'] = v['name'];
			item['articles'] = Mysql.fetchAll(db, "select id,title,created_at from article where cid = "+v['id']+" order by id desc limit 0,5");
			items[] = item;
		endfor
		data['items'] = items;
		print bltMustacheFileRender("tpl/index.tpl", data);
	endfun
endclass

use builtin, request, mysql, session;
def TRUE 1;
def FALSE 0;
inc 'config.zl';
inc 'mysql.zl';

db = initDB();
categories = Mysql.fetchAll(db, "select id,name from category where pid=0 order by id asc");

// 初始化数据库连接
fun initDB()
	global config;
	db = bltArray();
	Mysql.init(db, config, "tpl/error.tpl");
	return db;
endfun

/**
 * 获取分页相关的信息，第一个参数per表示一页显示多少条记录，total表示总记录数
 * showpage表示需要显示的分页数，link表示需要访问的地址，以问号结尾
 */
fun get_page(per, total, showpage, link = '?')
	global querys;
	totalpage = bltInt(total/per); // 根据总记录数和每页需要显示的记录数计算总页数
	if(total % per > 0) // 如果有余数则将总页数加一
		totalpage++;
	endif
	half = bltInt(showpage / 2);
	curpage = bltInt(querys['page']); // 从查询字符串中获取page也就是当前分页
	if(curpage < 1)
		curpage = 1;
	elif(totalpage > 0 && curpage > totalpage)
		curpage = totalpage;
	endif
	start = curpage - half; // 计算起始页号
	if(start < 1) 
		start = 1; 
	endif
	end = curpage + half; // 计算结束页号
	if(end > totalpage)
		end = totalpage;
	endif
	for(i=0;bltIterArray(querys,&i,&k,&v);) // 获取不包括page在内的查询字符串
		if(k != 'page')
			link += k + '=' + v + '&';
		endif
	endfor
	// 将分页信息存储到ret返回
	ret['start'] = start;
	ret['end'] = end;
	ret['offset'] = (curpage - 1) * per;
	ret['limit'] = per;
	ret['prev'] = (curpage <= 1) ? 1 : (curpage - 1); // 计算上一页
	ret['next'] = (curpage >= totalpage) ? totalpage : (curpage + 1); // 计算下一页
	ret['total'] = total;
	ret['totalpage'] = totalpage;
	ret['curpage'] = curpage;
	ret['link'] = link;
	return ret;
endfun