JSON based calendar provider for thunderbird and lightning

Backend Code

CREATE TABLE `Cal` (
  `id` int(11) NOT NULL auto_increment,
  `dtstart` datetime NOT NULL,
  `dtend` datetime NOT NULL,
  `uid` varchar(32) NOT NULL,
  `ical` text NOT NULL,
  `privicy` varchar(32) NOT NULL,
  `owner` INT(11) NOT NULL,
  `calname` VARCHAR(128) NOT NULL DEFAULT '',
  `last_modified` datetime default NULL,
  `created` datetime default NULL,
  caltype VARCHAR(1) DEFAULT 'C',
  PRIMARY KEY  (`id`),
  KEY `new_index` (`dtstart`,`dtend`,`uid`, owner, calname),
  KEY `uid` (`uid`)
) 

class Cal extends HTML_FlexyFrameWork_Page
{
    function sendFail($msg= "empty")
    {
        header('WWW-Authenticate: Basic realm="Calendar"');
        header('HTTP/1.0 401 Unauthorized');
        echo $msg;
        exit;
        
   }
    
    
    function getAuth()
    {
        // use basic auth.. 
        $u = isset($_SERVER['PHP_AUTH_USER']) ? $_SERVER['PHP_AUTH_USER'] : "";
        $p = isset($_SERVER['PHP_AUTH_PW']) ? $_SERVER['PHP_AUTH_PW'] : "";
        if (empty($u) || empty($p)) {
            $this->sendFail();
            
        }
        // check the password combo...
        
        $bits = explode('@', $u);
        
        $d = DB_DataObject::factory('Domains');
        $d->is_external = 0;
        if (!$d->get('domain', $bits[1])) {
            $this->sendFail('invalid domain');
            
        }
        
        $user =DB_DataObject::factory('Users');
        $user->dom_id = $d->id;
        $user->login = $bits[0];
        if (!$user->find(true)) {
            $this->sendFail('invalid user');
        }
        
        
        
        if ($user->checkPassword($p)) {
            $this->authUser = $user;
            return true;

            //exit;
        }
        
        $this->sendFail('invalid details');
        
    }
    
    
    function get()
    {
        if (isset($_GET['POST'])) {
            return $this->post();
        }
        
        $start =empty($_REQUEST['aRangeStart']) ?
		 "1970-01-01" : $_REQUEST['aRangeStart'];
        $end =empty($_REQUEST['aRangeEnd']) ? 
		date("Y-m-d",strtotime("TODAY + 1 DAY")) : $_REQUEST['aRangeEnd'];

        $d = DB_DataObject::factory('Cal');
        if (!empty($_REQUEST['aRangeStart'])) {
            $d->whereAdd("dtstart >= '". date("Y-m-d H:i:s", strtotime($start)) ."'");
            $d->whereAdd("dtend <= '". date("Y-m-d H:i:s", strtotime($end)) ."'");
            $d->caltype = 'C';
        } else {
            $d->caltype = 'T'; // task..
        }
        
        
        if (!empty($_REQUEST['aCount']) && ($_REQUEST['aCount'] * 1)> 0) {
            $d->limit(1 * $_REQUEST['aCount']);
        }
        $d->owner = $this->authUser->id;
        $d->find();
        $ret = array();
        while ($d->fetch()) {
            if (empty($d->uid)) {
                $d->uid = md5("mailfort". $d->id); // gen our uid.
            }
            $ret[] = $d->toArray();
        }
       
        require_once 'Services/JSON.php';
        $json = new Services_JSON();
        echo $json->encode(  $ret);
        exit;
        
        
        
    }
    function post()
    {
        $d = DB_DataObject::factory('Cal');
        if (!empty($_REQUEST['_delete_'])) {
            $d->owner = $this->authUser->id;
            if (! $d->get('uid', $_REQUEST['_delete_'])) {
                die("OOPPS");
            }
            $d->delete();
            echo "OK";
            exit;
        }
        
        
        if (!empty($_REQUEST['uid'])) {
            $d->owner = $this->authUser->id;
            if (!$d->get('uid', $_REQUEST['uid'])) {
                die("OOPS");
            }
        }
        // check for id...
        $d->setFrom($_REQUEST);
        $d->owner = $this->authUser->id;
        if (empty($d->caltype)) {
            if (empty($_REQUEST['dtstart'])) {
                $d->caltype = 'T';
            } else {
                $d->caltype = 'C'; 
            }    

        }
        
        
        if (!$d->id) {
            $d->insert();
            $d->uid = md5("cal". $d->id); 
        }
        $d->update();
        
        require_once 'Services/JSON.php';
        $json = new Services_JSON();
        echo $json->encode($d->toArray());
        exit;
        
    }
    
}