<?
if(!fileexists('whenob_db')) {
    $db = new SQLiteDatabase('whenob_db');
    $db->exec("create table whenob_list(title text)");
    $db->exec("create table whenob_item(list_id integer,title text,content text,index integer)");
}
$db = new SQLiteDatabase('whenob_db');
switch($_GET['action']) {
    case 'crt_list':
        create_list();exit;
    case 'ret_list':
        retrieve_list();exit;
    case 'upd_list':
        update_list();exit;
    case 'del_list':
        delete_list();exit;
    case 'crt_item':
        create_item();exit;
    case 'ret_item':
        retrieve_item();exit;
    case 'upd_item':
        update_item();exit;
    case 'del_item':
        delete_item();exit;
    default:
}
/************************************************
send_error
************************************************/
function send_error($err_msg = 'An error occured') {
    echo '{error:"'.$err_msg.'"}';
}
/************************************************
send_success
************************************************/
function send_success($suc_msg = 'true') {
    echo '{success:"'.$err_msg.'"}';
}
/************************************************
list_exists
************************************************/
function list_exists($list_id) {
    global $db;
    if(!is_numeric($list_id)) {
        send_error('invalid list id');
        return false;
    }
    $result = $db->arrayQuery("select * from whenob_list where OID=$list_id");
    if(count($result) != 1) {
        send_error('unexisting list');
        return false;
    }
    return true;
}
/************************************************
item_exists
************************************************/
function item_exists($item_id) {
    global $db;
    if(!is_numeric($item_id)) {
        send_error('invalid item id');
        return false;
    }
    $result = $db->arrayQuery("select * from whenob_item where OID=$item_id");
    if(count($result) != 1) {
        send_error('unexisting item');
        return false;
    }
    return true;
}
/************************************************
create_list
************************************************/
function create_list() {
    global $db;
    $list_title = sqlite_escape_string($_POST['title']);
    // check if no list have the same title
    $result = $db->arrayQuery("select * from whenob_list where title='$list_title'");
    if(count($result) != 0) {
        send_error('list name already in use');
    } else {
        if($db->exec("insert into whenob_list (title) values ('$list_title')")) {
            $result = $db->arrayQuery("select OID from whenob_list where title='$list_title'");
            send_success($result[0]['OID']);
        } else {
            send_error('an error occured while creating list');
        }
    }
}
/************************************************
retrieve_list
************************************************/
function retrieve_list() {
    global $db;
    $list_id = $_GET['list'];
    if(!list_exists($list_id)) return;
    $result = $db->arrayQuery("select OID, title, content from whenob_item where list_id=$list_id order by index");
    echo '{';
    foreach($result as $item) {
        echo $item['OID'].':{';
        echo 'title:"'.$item['title'].'",';
        echo 'content:"'.$item['content'].'"},';
    }
    echo '}';
}
/************************************************
update_list
************************************************/
function update_list() {
    global $db;
    $list_id = $_GET['list'];
    $list_title = $_GET['title'];
    // check if the list exists
    if(!list_exists($list_id)) return;
    // check if no list have the same title
    $result = $db->arrayQuery("select * from whenob_list where title='$list_title'");
    if(count($result) != 0) {
        echo send_error('list name already in use');
        return;
    }
    if($db->exec("update whenob_list set title='$list_title' where OID=$list_id")) {
        send_success();
    } else {
        send_error('an error occured while updating list name');
    }
}
/************************************************
delete_list
************************************************/
function delete_list() {
    global $db;
    $list_id = $_GET['list'];
    if(!list_exists($list_id)) return;
    if($db->exec("delete from whenob_list where OID=$list_id")) {
        send_success();
    } else {
        send_error('an error occured while deleting list');
    }
}
/************************************************
create_item
************************************************/
function create_item() {
    global $db;
    $list_id = $_GET['list'];
    $item_title = sqlite_escape_string($_GET['title']);
    $item_content = sqlite_escape_string($_GET['content']);
    if(!list_exists($list_id)) return;
    if($db->exec("insert into whenob_item (list_id,title,content,index)"
            ."(select $list_id,'$item_title','$item_content',max(index)+1 from whenob_item where list_id=$list_id)")) {
        $result = $db->arrayQuery("select OID from whenob_item where list_id=$list_id and title='$item_title' and content='$item_content'");
        send_success($result[0]['OID']);
    } else {
        send_error('an error occured while creating item');
    }
}
/************************************************
retrieve_item
************************************************/
function retrieve_item() {
    global $db;
    $item_id = $_GET['item'];
    if(is_numeric($item_id)) {
        $result = $db->arrayQuery("select OID, title, content from whenob_item where OID=$item_id");
        if(count($result) == 0) {
            send_error('no matching item');
        } else {
            echo '{title:"'.$result[0]['title'].'",content:"'.$result[0]['content'].'"}';
        }
    } else {
        send_error('invalid item id');
    }
}
/************************************************
update_item
************************************************/
function update_item() {
    global $db;
    $item_id = $_GET['item'];
    $item_title = sqlite_escape_string($_GET['title']);
    $item_content = sqlite_escape_string($_GET['content']);
    if(!item_exists($item_id)) return;
    if($db->exec("update whenob_item set title='$item_title', content='$item_content' where OID=$item_id")) {
        send_success();
    } else {
        send_error('an error occured while updating item');
    }
}
/************************************************
delete_item
************************************************/
function delete_item() {
    global $db;
    $item_id = $_GET['item'];
    if(!item_exists($item_id)) return;
    if($db->exec("delete from whenob_item where OID=$item_id")) {
        send_success();
    } else {
        send_error('an error occured while deleting item');
    }
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Whenob</title>
<style type="text/css">
body {
    font-family:helvetica, sans-serif;
}
ul,li {
    padding:0;
    margin:0;
    list-style-position:inside;
}
#left, #right {
    border:1px solid black;
    height:35em;
    vertical-align:top;
    padding:10px;
}
#left {
    width:20em;
    float:left;
}
#right {
    width:40em;
    margin-left:22em;
}
#list_list {
    text-align:right;
}
#list_list select {
    width:15em;
}
#list_title {
    margin:0;
}
#id {
    display:none;
}
#title, #body {
    border:1px solid black;
    padding:0.25em 0.5em;
}
#title {
    margin:0 0 0.5em 0;
}
</style>
<script type="text/javascript" src="http://vrac.adwain.org/code/javascript/prototype.js"></script>
<script type="text/javascript">
Whenob = Class.create();
Whenob.prototype = {
    initialize: function() {
        this.options = Object.extend({
            listList: 'list_list',
            
        },arguments[0] || {});
        this.htmlListList = $$('select')[0];
        this.htmlListTitle = $('list_title');
        this.htmlListItems = $$('ul')[0];
        this.htmlItemTitle = $('title');
        this.htmlItemBody = $('body');
        Event.observe(this.htmlListList,'change',function() {
            this.loadList();
        }.bind(this));
        this.loadList();
    },
    loadList: function(listName) {
        // set the title from the dropdown
        this.htmlListTitle.innerHTML = this.htmlListList.options.item(this.htmlListList.selectedIndex).text;
        // TODO : fetch the item list from the server
        // decorate the items
        this.htmlListItems.getElementsBySelector('li').each(function(htmlListItem){
            Event.observe(htmlListItem,'click',function(event) {
                this.loadItem(event.element().identify());
            }.bindAsEventListener(this));
        });
        this.loadItem(this.listItems.getElementsBySelector('li')[0].id);
    },
    loadItem: function(itemId) {
        this.itemTitle.innerHTML = $(itemId).innerHTML;
        this.itemBody.innerHTML = '';
        for(i=0;i<50;++i) {
            this.itemBody.innerHTML += $(itemId).innerHTML;
        }
    },
    saveItem: function(itemId, itemTitle, itemBody) {
        //if()
    }
};
Event.observe(window,'load',function() {
    list_list = $$('select')[0];
    list_title = $('list_title');
    item_title = $('title');
    item_body = $('body');
    $$('li').each(function(li) {
        Event.observe(li,'click',function() {
            item_title.innerHTML = this.innerHTML;
            item_body.innerHTML = this.innerHTML;
            for(i=0;i<50;++i)
                item_body.innerHTML += ' '+this.innerHTML;
        }.bind(li));
    });
    list_title.innerHTML = list_list.options.item(0).text;
    Event.observe(list_list,'change',function() {
        list_title.innerHTML = this.options.item(this.selectedIndex).text;
    }.bind(list_list));
});
</script>
</head>
<body>

<div id="left">
<div id="list_list"><select>
<option value="12">azer</option>
<option value="22">qwer</option>
</select></div>
<h2 id="list_title"></h2>
<ul>
<li>ablert gsdfg</li>
<li>qsdfgjkh sdgf sdfg</li>
</ul>
</div>
<div id="right">
    <div id="id"></div>
    <h2 id="title"></h2>
    <div id="body"></div>
</div>

</body>
</html>