CppCMS C++ Web Framework Code

//
// C++ Implementation: views
//
// Description:
//
//
// Author: artik <artik@art-laptop>, (C) 2007
//
// Copyright: See COPYING file that comes with this distribution
//
//
#include "views.h"
#include <boost/format.hpp>
#include "blog.h"
#include "error.h"
#include "cxxmarkdown/markdowncxx.h"

using boost::format;
using boost::str;

using namespace dbixx;

void View_Comment::init(comment_t &com)
{
	c["username"]=com.author;
	if(com.url.size()!=0){
		c["url"]=com.url;
	}
	c["content"]=com.content;
	c["date"]=com.publish_time;
	if(blog->userid!=-1){
		c["delete_url"]=str(format(blog->fmt.del_comment) % com.id);
		c["edit_url"]=str(format(blog->fmt.edit_comment) % com.id);
	}
}

void View_Post::ini_share(post_t &p)
{
	c["title"]=p.title;
	c["subtitle"]=p.title;
	c["date"]=p.publish;
	c["author"]=p.author_name;

	if(blog->userid!=-1){
		c["edit_url"]=str(format(blog->fmt.edit_post) % p.id);
	}
	c["permlink"]=str(format(blog->fmt.post) % p.id);
}

void View_Post::ini_full(post_t &p)
{
	ini_share(p);
	c["abstract"]=p.abstract;
	if(p.content!="") {
		c["content"]=p.content;
		c["has_content"]=true;
	}
	else {
		c["has_content"]=false;
	}

	string post_comment=str(format(blog->fmt.add_comment) % p.id);
	int n=post_comment.size()/2;
	string post_comment_url_2=post_comment.substr(n);
	string post_comment_url_1=post_comment.substr(0,n);
	c["post_comment_url_1"]=post_comment_url_1;
	c["post_comment_url_2"]=post_comment_url_2;

	result rs;
	blog->sql<<
		"SELECT id,author,email,url,publish_time,content "
		"FROM comments "
		"WHERE post_id=? "
		"ORDER BY publish_time",p.id;
	blog->sql.fetch(rs);

	row cur;

	content::vector_t &comments_list=c.vector("comments",rs.rows());

	int i;
	for(i=0;rs.next(cur);i++)
	{
		View_Comment com(blog,comments_list[i]);

		comment_t comment;
		cur	>> comment.id >>comment.author >> comment.email >> comment.url
			>> comment.publish_time >> comment.content ;

		com.init(comment);
	}
}


void View_Post::ini_short(post_t &p)
{
	ini_share(p);
	c["abstract"]=p.abstract;
	c["has_content"]=(bool)p.has_content;
}


void View_Post::ini_feed(post_t &p)
{
	ini_share(p);
	c["abstract"]=p.abstract;
	c["has_content"]=(bool)p.has_content;
}

void View_Main_Page::ini_share()
{
	int id;
	string val;
	result rs;
	blog->sql<<"SELECT id,value FROM options";
	blog->sql.fetch(rs);
	row i;
	for(;rs.next(i);){
		i >>id>>val;
		if(id==BLOG_TITLE)
			c["blog_name"]=val;
		else if(id==BLOG_DESCRIPTION)
			c["blog_description"]=val;
	}
	c["media"]=blog->fmt.media;
	c["admin_url"]=blog->fmt.admin;
	c["base_url"]=global_config.sval("blog.script_path");
	c["host"]=global_config.sval("blog.host");
	c["rss_posts"]=blog->fmt.feed;
}

void View_Main_Page::ini_main(int id,bool feed)
{
	ini_share();

	int max_posts=feed ? 10 : 5;

	content::vector_t &latest_posts=c.vector("posts",max_posts);

	result rs;
	if(id!=-1) {
		blog->sql<<
			"SELECT posts.id,users.username,posts.title, "
			"	posts.abstract, posts.content !='', "
			"	posts.publish "
			"FROM	posts "
			"LEFT JOIN "
			"	users ON users.id=posts.author_id "
			"WHERE	posts.publish <= (SELECT publish FROM posts WHERE id=?) "
			"	AND posts.is_open=1 "
			"ORDER BY posts.publish DESC "
			"LIMIT ?",
			id,max_posts+1;
	}
	else {
		blog->sql<<
			"SELECT posts.id,users.username,posts.title, "
			"	posts.abstract, posts.content!='', "
			"	posts.publish "
			"FROM	posts "
			"LEFT JOIN "
			"	users ON users.id=posts.author_id "
			"WHERE	posts.is_open=1 "
			"ORDER BY posts.publish DESC "
			"LIMIT ?",(max_posts+1);
	}
	blog->sql.fetch(rs);

	row r;
	int counter,n;
	for(counter=1,n=0;rs.next(r);counter++) {
		if(counter==max_posts+1) {
			int id;
			r>>id;
			c["next_page_link"]=str(format(blog->fmt.main_from) % id);
			break;
		}
		post_t post;

		r>>post.id;
		r>>post.author_name;
		r>>post.title;
		r>>post.abstract;
		r>>post.has_content;
		r>>post.publish;

		View_Post post_v(blog,latest_posts[n]);
		if(feed){
			post_v.ini_feed(post);
		}
		else {
			post_v.ini_short(post);
		}
		n++;
	}
	if(n<max_posts){
		latest_posts.resize(n);
	}
	c["master_content"]=string("main_page");
}

void View_Main_Page::ini_post(int id,bool preview)
{
	View_Post post_v(blog,c);
	post_t post;
	post.id=-1;
	row r;
	blog->sql<<
		"SELECT posts.id,users.username,posts.title, "
		"	posts.abstract, posts.content, "
		"	posts.publish,posts.is_open "
		"FROM	posts "
		"JOIN	users ON users.id=posts.author_id "
		"WHERE	posts.id=? ",
		id;
	if(!blog->sql.single(r)) {
		throw Error(Error::E404);
	}
	r>>	post.id>>post.author_name>>post.title>>
		post.abstract>>post.content>>
		post.publish>>post.is_open;

	if(post.id==-1 || (!post.is_open && !preview)){
		throw Error(Error::E404);
	}

	ini_share();

	post_v.ini_full(post);
	c["master_content"]=string("post");
}

void View_Main_Page::ini_error(int id)
{
	ini_share();
	c["master_content"]=string("error");
	switch(id){
	case Error::E404:
		c["error_404"]=true;
		c["error_comment"]=false;
		break;
	case Error::COMMENT_FIELDS:
		c["error_404"]=false;
		c["error_comment"]=true;
		break;
	}
}

void View_Admin::ini_share()
{
	row r;
	blog->sql<<
		"SELECT value FROM options WHERE id=?",
		(int)BLOG_TITLE;
	string blog_name;
	if(blog->sql.single(r))
		r>>blog_name;
	c["blog_name"]=blog_name;
	c["media"]=blog->fmt.media;
	c["base_url"]=global_config.sval("blog.script_path");
	c["admin_url"]=blog->fmt.admin;
	c["logout_url"]=blog->fmt.logout;
	c["new_post_url"]=blog->fmt.new_post;
}

void View_Admin::ini_login()
{
	ini_share();
	c["master_content"]=string("admin_login");
	c["login_url"]=blog->fmt.login;
}

void View_Admin::ini_cedit(int id)
{
	ini_share();

	c["master_content"]=string("admin_editcomment");
	c["edit_comment_url"]=str(format(blog->fmt.update_comment) % id);
	string author,url,content,email;
	blog->sql<<
		"SELECT author,url,email,content "
		"FROM	comments "
		"WHERE	id=?",id;
	row r;
	if(!blog->sql.single(r)) {
		throw Error(Error::E404);
	}
	r>>author>>url>>email>>content;
	c["author"]=author;
	c["url"]=url;
	c["content"]=content;
	c["email"]=email;
}

void View_Admin::ini_edit(int id)
{
	ini_share();
	c["master_content"]=string("admin_editpost");
	View_Admin_Post post(blog,c);
	post.ini(id);
}

void View_Admin::ini_main()
{
	ini_share();
	View_Admin_Main main(blog,c);
	main.ini();
	c["master_content"]=string("admin_main");
}

void View_Admin_Main::ini()
{
	result rs;
	blog->sql<<
		"SELECT id,title "
		"FROM posts "
		"WHERE is_open=0";
	blog->sql.fetch(rs);
	row r;

	content::vector_t &unpublished_posts=c.vector("posts",rs.rows());

	int i;
	for(i=0;rs.next(r);i++) {
		int id;
		string intitle;
		r>>id>>intitle;
		string edit_url=str(format(blog->fmt.edit_post) % id);

		unpublished_posts[i]["edit_url"]=edit_url;
		unpublished_posts[i]["title"]=intitle;
	}
	blog->sql<<
		"SELECT id,post_id,author "
		"FROM comments "
		"ORDER BY id DESC "
		"LIMIT 10",rs;

	content::vector_t &latest_comments=c.vector("comments",rs.rows());

	for(i=0;rs.next(r);i++) {
		int id,c_id;
		string author;
		r>>c_id>>id>>author;
		
		latest_comments[i]["post_permlink"]=str(format(blog->fmt.post) % id);
		latest_comments[i]["username"]=author;
		latest_comments[i]["edit_url"]=str(format(blog->fmt.edit_comment) % c_id );
	}
}

void View_Admin_Post::ini( int id)
{
	post_t post_data;
	if(id!=-1) {
		c["post_id"]=id;
		c["submit_post_url"]=str(format(blog->fmt.update_post) % id);
		c["preview_url"]=str(format(blog->fmt.preview) % id);
	}
	else {
		c["submit_post_url"]=blog->fmt.add_post;
		return;
	}
	post_data.id=-1;
	row r;
	blog->sql<<
		"SELECT id,title,abstract,content "
		"FROM posts "
		"WHERE id=?",
		id;
	if(!blog->sql.single(r)){
		throw Error(Error::E404);
	}
	r>>	post_data.id>>post_data.title>>
		post_data.abstract>>post_data.content;

	c["post_title"]=post_data.title;
	c["abstract"]=post_data.abstract;
	c["content"]=post_data.content;
}