db = new db();
$this->db->Halt_On_Error = 'no';
$this->db->connect(
$_SESSION['calendar']['server']['db_name'],
$_SESSION['calendar']['server']['db_host'],
$_SESSION['calendar']['server']['db_port'],
$_SESSION['calendar']['server']['db_user'],
$_SESSION['calendar']['server']['db_pass'],
$_SESSION['calendar']['server']['db_type']
);
$this -> user_id = $_SESSION['calendar']['user']['account_id'];
}
var $public_functions = array(
'requestTodayCal' => True
);
// Return the events of current Day
function requestDayCal ($dayTime) {
$query = ("SELECT * FROM phpgw_cal where (owner = '".$this->user_id."') and ((datetime > ".$dayTime." and datetime < ".($dayTime+86400).") or (edatetime > ".$dayTime." and edatetime < ".($dayTime+86400)."))");
if (!$this->db->query($query))
return false;
while($this->db->next_record())
$result[] = $this->db->row();
return $result;
}
function changeEvent ($calId,$field,$value) {
$query = ("UPDATE phpgw_cal SET ".$field."=".$value." WHERE cal_id = ".$calId.";");
if (!$this->db->query($query))
return "DB out of service or internal error";
return "";
}
// Return the events of current Day
function requestWeekCal ($dayTime) {
// Performing SQL query
$query = "SELECT cal_id, title, description, datetime, edatetime FROM phpgw_cal where (owner = '".$this->user_id."') and ((datetime > ".$dayTime." and datetime < ".($dayTime+604800).") or (edatetime > ".$dayTime." and edatetime < ".($dayTime+604800)."))";
if (!$this->db->query($query))
return false;
while($this->db->next_record())
$result[] = $this->db->row();
return $result;
}
// Return the events of current Day
function requestMonthCal ($dayTime) {
// Performing SQL query
$query = "SELECT cal_id, title, description, datetime, edatetime FROM phpgw_cal where (owner = '".$this->user_id."') and ((datetime > ".$dayTime." and datetime < ".($dayTime+2592000).") or (edatetime > ".$dayTime." and edatetime < ".($dayTime+2592000)."))";
if (!$this->db->query($query))
return false;
while($this->db->next_record())
$result[] = $this->db->row();
return $result;
}
function insertEvent ($datetime, $edatetime, $title, $description)
{
//Discover the event id
$query = "SELECT max(cal_id) FROM phpgw_cal";
if (!$this->db->query($query))
return false;
while($this->db->next_record())
$id = $this->db->row();
// Performing SQL insert query
$query = "INSERT INTO phpgw_cal VALUES (".($id['max']+1).", '".$_SESSION['calendar']['user']['email']."', ".$this->user_id.", null, null, ".$datetime.", ".time().",".$edatetime.", 2, 'E', 0, '".$title."', '".$description."', null, 0, null, null, null )";
if ($this->db->query($query)){
$query = "INSERT INTO phpgw_cal_user VALUES (".($id['max']+1).", ".$this->user_id.", 'A', 'u')";
if ($this->db->query($query)){
$return = "true ";
$return .= ";".($id['max']+1);
} else {
$return = "false";
$return .= ";Query failed: " . pg_last_error();
}
}
else{
$return = "false";
$return .= ";Query failed: " . pg_last_error();
}
return $return;
}
function removeEventById($id){
$query = "DELETE from phpgw_cal where cal_id = ".$id;
if ($this->db->query($query)){
$query = "DELETE from phpgw_cal_user where cal_id = ".$id;
if ($this->db->query($query))
$return = "true ";
else
{
$return = "false";
$return .= ";Query failed: " . pg_last_error();
}
}
else{
$return = "false";
$return .= ";Query failed: " . pg_last_error();
}
return $return;
}
}
?>