crystal_cms_rcpp_fw/app/page_manager/page_manager.cpp

#include "page_manager.h"

#include "core/error_macros.h"
#include "core/nodes/node_tree.h"

#include "web/html/form_validator.h"
#include "web/html/html_builder.h"
#include "web/http/cookie.h"
#include "web/http/http_session.h"
#include "web/http/request.h"
#include "web/http/session_manager.h"

#include "database/database.h"
#include "database/database_manager.h"
#include "database/query_builder.h"
#include "database/query_result.h"
#include "database/table_builder.h"

#include "page_content.h"
#include "page.h"

void PageManager::_handle_request_main(Request *request) {
	render_menu(request);

	request->body += "PageManagerTest";
	request->compile_and_send_body();
}

void PageManager::create_validators() {
}

void PageManager::admin_handle_request_main(Request *request) {
	String seg = request->get_current_path_segment();

	if (seg == "") {
		admin_render_page_list(request);
		return;
	} else if (seg == "new_entry") {
		request->push_path();

		admin_handle_new_page(request);
	} else if (seg == "edit_entry") {
		request->push_path();

		admin_handle_edit_page(request);
	} else if (seg == "delete") {
		request->push_path();

		admin_handle_delete(request);
	}
}


void PageManager::admin_render_page_list(Request *request) {
	HTMLBuilder b;

	b.h4()->f()->a()->href(request->get_url_root_parent())->f()->w("<- Back")->ca()->ch4();
	b.h4()->f()->w("Page Editor")->ch4();
	b.style()->f()->w("li { display: inline-block; }")->cstyle();

	Vector<Ref<Page> > pages = db_get_pages();

	for (int i = 0; i < pages.size(); ++i) {
		Ref<Page> e = pages[i];

		if (!e.is_valid()) {
			continue;
		}

		b.div()->cls("row")->f()->ul();
		{
			b.li();
			{
				b.a()->href(request->get_url_root("edit_entry/") + String::num(e->id));
				b.w("id: ")->wn(e->id)->w(" name: ")->w(e->name)->w(" url: ")->w(e->url);
				b.ca();
			}
			b.cli();

			b.li();
			{
				b.form_post(request->get_url_root() + "delete", request);
				{
					b.input_hidden("id", String::num(e->id));
					b.input_submit("Delete");
				}
				b.cform();
			}
			b.cli();
		}
		b.cul()->cdiv();
	}

	b.br();

	b.a()->href(request->get_url_root("new_entry"));
	b.w("New Entry");
	b.ca();

	request->body += b.result;
}


void PageManager::admin_handle_new_page(Request *request) {
	if (request->get_method() == HTTP_METHOD_POST) {
		Ref<Page> entry;
		entry.instance();

		entry->name = request->get_parameter("name");
		entry->url = request->get_parameter("url");
		entry->page_type = PAGE_TYPE_PAGE;
		entry->deleted = 0;

		db_save_page(entry);

		invalidate_cache();

		//this should probably go back to the list itself. TODO
		request->send_redirect(request->get_url_root_parent() + "edit_entry/" + String::num(entry->id));

		return;
	}

	PageAdminEntryViewData data;
	render_page_view(request, &data);
}

void PageManager::admin_handle_edit_page(Request *request) {
	String seg = request->get_current_path_segment();

	int id = seg.to_int();

	Ref<Page> entry;

	//todo only get the relevant from the db
	Vector<Ref<Page> > pages = db_get_pages();

	for (int i = 0; i < pages.size(); ++i) {
		Ref<Page> e = pages[i];

		if (e->id == id) {
			entry = e;
			break;
		}
	}

	if (!entry.is_valid()) {
		RLOG_MSG("PageManager::admin_handle_edit_menuentry: !entry.is_valid()\n");
		request->send_redirect(request->get_url_root_parent());
		return;
	}

	PageAdminEntryViewData data;
	data.entry = entry;

	if (request->get_method() == HTTP_METHOD_POST) {
		entry->name = request->get_parameter("name");
		entry->url = request->get_parameter("url");

		db_save_page(entry);

		invalidate_cache();

		data.messages.push_back("Save Success!");
	}

	render_page_view(request, &data);
}

void PageManager::render_page_view(Request *request, PageAdminEntryViewData *data) {
	int id = 0;
	String name = "";
	String url = "";

	if (data->entry.is_valid()) {
		id = data->entry->id;
		name = data->entry->name;
		url = data->entry->url;
	}

	HTMLBuilder b;

	b.h4()->f()->a()->href(request->get_url_root_parent())->f()->w("&lt;- Back")->ca()->ch4();
	b.h4()->f()->w("Menu Editor")->ch4();

	b.div()->cls("messages");
	for (int i = 0; i < data->messages.size(); ++i) {
		b.w(data->messages[i])->br();
	}
	b.cdiv();

	String aurl = request->get_url_root();

	if (id != 0) {
		aurl += String::num(id);
	}

	b.form()->method("POST")->action(aurl);
	{
		b.csrf_token(request);

		b.w("Name:")->br();
		b.input_text("name", name)->br();

		b.w("URL:")->br();
		b.input_text("url", url)->br();

		b.br();
		b.input()->type("submit")->value("Save");
	}
	b.cform();

	request->body += b.result;
}

void PageManager::admin_handle_delete(Request *request) {
	/*
	String pid = request->get_parameter("id");

	if (!pid.is_int()) {
		request->send_redirect(request->get_url_root_parent());
		return;
	}

	int id = pid.to_int();

	// TODO
	// Also lock everywhere else
	//_data->write_lock()

	for (int i = 0; i < _data->entries.size(); ++i) {
		Ref<MenuDataEntry> e = _data->entries[i];

		if (e->id == id) {
			int sort_order = e->sort_order;

			for (int j = 0; j < _data->entries.size(); ++j) {
				Ref<MenuDataEntry> be = _data->entries[j];

				if (be->sort_order > sort_order) {
					be->sort_order -= 1;
					db_save_menu_entry(be);
				}
			}

			db_delete_menu_entry(e->id);

			_data->entries.remove_keep_order(i);

			break;
		}
	}

	//_data->write_unlock()
	request->send_redirect(request->get_url_root_parent());
	*/
}

String PageManager::admin_get_section_name() {
	return "Page Editor";
}

void PageManager::admin_add_section_links(Vector<AdminSectionLinkInfo> *links) {
	links->push_back(AdminSectionLinkInfo("Editor", ""));
}

void PageManager::invalidate_cache() {

}

// DB

Vector<Ref<Page> > PageManager::db_get_pages() {
	Vector<Ref<Page> > data;

	Ref<QueryBuilder> qb = get_query_builder();

	qb->select("id,name,url,page_type,deleted")->from(_table);
	qb->where()->wp("deleted", 0);
	Ref<QueryResult> res = qb->run();

	while (res->next_row()) {
		Ref<Page> p;
		p.instance();

		p->id = res->get_cell_int(0);
		p->name = res->get_cell_str(1);
		p->url = res->get_cell_str(2);
		p->page_type = res->get_cell_int(3);
		p->deleted = res->get_cell_int(4);

		data.push_back(p);
	}

	return data;
}

void PageManager::db_save_page(const Ref<Page> &page) {
	Ref<QueryBuilder> qb = get_query_builder();

	if (page->id == 0) {
		qb->insert(_table, "name,url,page_type,deleted")->values();
		qb->val(page->name);
		qb->val(page->url);
		qb->val(page->page_type);
		qb->val(page->deleted);
		qb->cvalues();
		qb->select_last_insert_id();
		Ref<QueryResult> res = qb->run();
		// qb->print();

		Ref<Page> e = page;

		e->id = res->get_last_insert_rowid();
	} else {
		qb->update(_table)->set();
		qb->setp("name", page->name);
		qb->setp("url", page->url);
		qb->setp("page_type", page->page_type);
		qb->setp("deleted", page->deleted);
		qb->cset();
		qb->where()->wp("id", page->id);
		qb->end_command();
		qb->run_query();
		// qb->print();
	}
}

void PageManager::db_save_page_content(const Ref<PageContent> &entry) {
	/*
	Ref<QueryBuilder> qb = get_query_builder();

	if (entry->id == 0) {
		qb->insert(_table, "name,url,sort_order")->values();
		qb->val(entry->name)->val(entry->url);
		qb->val(entry->sort_order);
		qb->cvalues();
		qb->select_last_insert_id();
		Ref<QueryResult> res = qb->run();
		// qb->print();

		Ref<MenuDataEntry> e = entry;

		e->id = res->get_last_insert_rowid();
	} else {
		qb->update(_table)->set();
		qb->setp("name", entry->name);
		qb->setp("url", entry->url);
		qb->setp("sort_order", entry->sort_order);
		qb->cset();
		qb->where()->wp("id", entry->id);
		qb->end_command();
		qb->run_query();
		// qb->print();
	}
	*/
}

void PageManager::db_delete_page(const int id) {
	Ref<QueryBuilder> qb = get_query_builder();

	qb->del(_table)->where()->wp("id", id);
	qb->run_query();
}

void PageManager::create_table() {
	Ref<TableBuilder> tb = get_table_builder();

	tb->create_table(_table);
	tb->integer("id")->auto_increment()->next_row();
	tb->varchar("name", 60)->not_null()->next_row();
	tb->varchar("url", 500)->not_null()->next_row();
	tb->tiny_integer("page_type")->not_null()->defval(0)->next_row();
	tb->tiny_integer("deleted")->not_null()->defval(0)->next_row();
	tb->primary_key("id");
	tb->ccreate_table();
	tb->run_query();
	// tb->print();
}
void PageManager::drop_table() {
	Ref<TableBuilder> tb = get_table_builder();

	tb->drop_table_if_exists(_table)->run_query();
	// tb->print();
}

void PageManager::create_default_entries() {
}

void PageManager::initialize() {
	_table = _table_prefix;

	if (_table.size() > 0) {
		_table += '_';
	}

	_table += "pages";
}

void PageManager::_notification(int what) {
	if (what == Node::NOTIFICATION_ENTER_TREE) {
		initialize();
	}
}

PageManager::PageManager() :
		AdminNode() {
}

PageManager::~PageManager() {
}