var MyAwesomePlugin = {
	name: "My Awesome Plugin",
	tables: ["MyAwesomePlugin"],
	onViewChange: function (strView, p2)
	{
		if (strView == "frienddetail")
		{
			// Add "Note" tab
			document.getElementById("FriendDetailTabs").innerHTML += "<a href=\"#\" id=\"Note_tab\" onClick=\"javascript: XID.FD_viewtab('Note');\">Note</a>";
			
			var cinfo = document.getElementById("FriendDetailContact");
			var newdiv = document.createElement("div");
			newdiv.id = "FriendDetailNote";
			newdiv.style.display = "none";
			newdiv.className = "frienddetailblock";
			var iHTML = "";
			var myobj = sqlToObj("SELECT * FROM MyAwesomePlugin WHERE friendid = " + p2);
			var myNote = "";
			if (myobj.length > 0)
			{
				if (myobj[0].note)
				{
					myNote = myobj[0].note;
				}
			}
			myNote2 = myNote.split("<").join("&lt;");
			myNote2 = myNote2.split("\n").join("<br />");
			myNote = myNote.split("\"").join("\\\"");
			
			iHTML += "<div id=\"div_MyAwesomeNote\">" + myNote2 + "</div>";
			iHTML += "<a href=\"#\" onClick=\"javascript: MyAwesomePlugin.showNoteForm();\" id=\"a_showNoteForm\" style=\"font-size: 10px;\">Edit Note</a>";
			iHTML += "<div id=\"div_showNoteForm\" style=\"display: none;\">";
			iHTML += "<textarea id=\"MyAwesomeNote\" style=\"width: 90%; height: 70px;\">" + myNote + "</textarea>";
			iHTML += "<input type=\"button\" onClick=\"javascript: MyAwesomePlugin.addNote(" + p2;
			iHTML += ", document.getElementById('MyAwesomeNote').value);\" value=\"Add Note\" />";
			iHTML += "</div>";
			newdiv.innerHTML = iHTML;
			cinfo.parentNode.insertBefore(newdiv, cinfo.nextSibling);
			/**/
		}
	},
	showNoteForm: function ()
	{
		document.getElementById("div_MyAwesomeNote").style.display = "none";
		document.getElementById("a_showNoteForm").style.display = "none";
		document.getElementById("div_showNoteForm").style.display = "block";
	},
	addNote: function (p2, val)
	{
		var myobj = sqlToObj("SELECT * FROM MyAwesomePlugin WHERE friendid = "+p2);
		var found = false;
		var bind1 = val;
		if (myobj.length > 0)
		{
			if (myobj[0].note)
			{
				found = true;
				sqlToObj("UPDATE MyAwesomePlugin SET note = ?1 WHERE id = "+myobj[0].id, [["UTF8String", "bind1", bind1]]);
			}
		}
		if (!found)
		{
			sqlToObj("INSERT INTO MyAwesomePlugin (friendid, note) VALUES ("+p2+", ?1)", [["UTF8String", "bind1", bind1]]);
		}
		document.getElementById("div_MyAwesomeNote").style.display = "block";
		document.getElementById("div_MyAwesomeNote").innerHTML = val.split("<").join("&lt;").split("\n").join("<br />");
		document.getElementById("a_showNoteForm").style.display = "inline";
		document.getElementById("div_showNoteForm").style.display = "none";
	},
	init: function ()
	{
		XID.tableNames.push("MyAwesomePlugin");
		sqlToObj("CREATE TABLE IF NOT EXISTS MyAwesomePlugin ('id' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, friendid INTEGER NOT NULL, note VARCHAR(55) NOT NULL)");
	}
};

XID.addPlugin(MyAwesomePlugin);