public function testCRUD()
{
midcom::get('auth')->request_sudo('org.openpsa.calendar');
$event = new org_openpsa_calendar_event_dba();
$stat = $event->create();
$this->assertTrue($stat);
$this->register_object($event);
$root_event = org_openpsa_calendar_interface::find_root_event();
$this->assertEquals($root_event->id, $event->up);
$stat = $event->update();
$this->assertFalse($stat);
$start = $this->_mktime(time() - 60 * 60);
$event->start = $start;
$stat = $event->update();
$this->assertFalse($stat);
$end = $this->_mktime(time() + 60 * 60);
$event->end = $end;
$stat = $event->update();
$this->assertTrue($stat);
$this->assertEquals($start + 1, $event->start);
$this->assertEquals($end, $event->end);
$stat = $event->delete();
$this->assertTrue($stat);
midcom::get('auth')->drop_sudo();
}
/**
* Loads and prepares the schema database.
*
* The operations are done on all available schemas within the DB.
*/
public function load_schemadb()
{
$schemadb = midcom_helper_datamanager2_schema::load_database($this->_config->get('schemadb_acl'));
$fields =& $schemadb['default']->fields;
$group_object = midcom::get('auth')->get_group("group:{$this->_request_data['group']->guid}");
// Get the calendar root event
$root_event = org_openpsa_calendar_interface::find_root_event();
if (is_object($root_event)) {
$fields['calendar']['privilege_object'] = $root_event;
$fields['calendar']['privilege_assignee'] = $group_object->id;
} else {
if (isset($fields['calendar'])) {
unset($fields['calendar']);
}
}
// Set the group into ACL
$fields['contact_creation']['privilege_object'] = $group_object->get_storage();
$fields['contact_editing']['privilege_object'] = $group_object->get_storage();
$fields['organization_creation']['privilege_object'] = $group_object->get_storage();
$fields['organization_editing']['privilege_object'] = $group_object->get_storage();
$fields['projects']['privilege_object'] = $group_object->get_storage();
$fields['invoices_creation']['privilege_object'] = $group_object->get_storage();
$fields['invoices_editing']['privilege_object'] = $group_object->get_storage();
// Load campaign classes
if (midcom::get('componentloader')->load_graceful('org.openpsa.directmarketing')) {
$fields['campaigns_creation']['privilege_object'] = $group_object->get_storage();
$fields['campaigns_editing']['privilege_object'] = $group_object->get_storage();
} else {
unset($fields['campaigns_creation']);
unset($fields['campaigns_editing']);
}
$fields['salesproject_creation']['privilege_object'] = $group_object->get_storage();
return $schemadb;
}
/**
* Handle the creation phase
*
* @param String $handler_id Name of the request handler
* @param array $args Variable arguments
* @param array &$data Public request data, passed by reference
*/
public function _handler_create($handler_id, array $args, array &$data)
{
// Get the root event
$this->_root_event = org_openpsa_calendar_interface::find_root_event();
// ACL handling: require create privileges
$this->_root_event->require_do('midgard:create');
if (isset($args[0])) {
$this->_person = new midcom_db_person($args[0]);
}
if (isset($args[1])) {
$this->_requested_time = (int) $args[1];
}
// Load the controller instance
$data['controller'] = $this->get_controller('create');
// Process form
switch ($data['controller']->process_form()) {
case 'save':
$indexer = new org_openpsa_calendar_midcom_indexer($this->_topic);
$indexer->index($data['controller']->datamanager);
//FALL-THROUGH
//FALL-THROUGH
case 'cancel':
midcom::get('head')->add_jsonload('window.opener.location.reload();');
midcom::get('head')->add_jsonload('window.close();');
break;
}
// Add toolbar items
org_openpsa_helpers::dm2_savecancel($this);
// Hide the ROOT style
midcom::get()->skip_page_style = true;
}
/**
* @param mixed $handler_id The ID of the handler.
* @param Array $args The argument list.
* @param Array &$data The local request data.
*/
public function _handler_notinitialized($handler_id, array $args, array &$data)
{
midcom::get('auth')->require_admin_user();
if (org_openpsa_calendar_interface::find_root_event()) {
return new midcom_response_relocate('');
}
}
/**
* Initialization of the handler class
*/
public function _on_initialize()
{
org_openpsa_widgets_calendar::add_head_elements();
// Load schema database
$schemadb = midcom_helper_datamanager2_schema::load_database($this->_config->get('schemadb'));
$this->_datamanager = new midcom_helper_datamanager2_datamanager($schemadb);
$this->_root_event = org_openpsa_calendar_interface::find_root_event();
}
function get_parent_guid_uncached()
{
if ($this->eid) {
$event = new org_openpsa_calendar_event_dba($this->eid);
return $event->guid;
} else {
$root_event = org_openpsa_calendar_interface::find_root_event();
return $root_event->guid;
}
}
/**
* Loads and prepares the schema database.
*
* The operations are done on all available schemas within the DB.
*/
public function load_schemadb()
{
$schemadb = midcom_helper_datamanager2_schema::load_database($this->_config->get('schemadb_acl'));
$fields =& $schemadb['default']->fields;
$user_object = midcom::get('auth')->get_user($this->_person->guid);
$person_object = $user_object->get_storage();
// Get the calendar root event
$root_event = org_openpsa_calendar_interface::find_root_event();
if (is_object($root_event)) {
$fields['calendar']['privilege_object'] = $root_event;
$fields['calendar']['privilege_assignee'] = $user_object->id;
} else {
if (isset($fields['calendar'])) {
unset($fields['calendar']);
}
}
$fields['contact_creation']['privilege_object'] = $person_object;
$fields['contact_editing']['privilege_object'] = $person_object;
$fields['organization_creation']['privilege_object'] = $person_object;
$fields['organization_editing']['privilege_object'] = $person_object;
$fields['projects']['privilege_object'] = $person_object;
$fields['invoices_creation']['privilege_object'] = $person_object;
$fields['invoices_editing']['privilege_object'] = $person_object;
$fields['products_creation']['privilege_object'] = $person_object;
$fields['products_editing']['privilege_object'] = $person_object;
// Load wiki classes
if (midcom::get('componentloader')->load_graceful('net.nemein.wiki')) {
$fields['wiki_creation']['privilege_object'] = $person_object;
$fields['wiki_editing']['privilege_object'] = $person_object;
} else {
unset($fields['wiki_creation']);
unset($fields['wiki_editing']);
}
// Load campaign classes
if (midcom::get('componentloader')->load_graceful('org.openpsa.directmarketing')) {
$fields['campaigns_creation']['privilege_object'] = $person_object;
$fields['campaigns_editing']['privilege_object'] = $person_object;
} else {
unset($fields['campaigns_creation']);
unset($fields['campaigns_editing']);
}
$fields['salesproject_creation']['privilege_object'] = $person_object;
return $schemadb;
}
/**
* If we have person defined populate $this->_request_data['events']
*/
private function _get_events()
{
$this->_request_data['events'] = array();
if (!is_object($this->_request_data['person'])) {
return;
}
$root_event = org_openpsa_calendar_interface::find_root_event();
$qb = org_openpsa_calendar_event_member_dba::new_query_builder();
$qb->add_constraint('eid.up', '=', $root_event->id);
// Display events two weeks back
$qb->add_constraint('eid.start', '>', mktime(0, 0, 0, date('n'), date('j') - 14, date('Y')));
$qb->add_constraint('uid', '=', $this->_request_data['person']->id);
$qb->add_order('eid.start', 'ASC');
$members = $qb->execute();
if (is_array($members)) {
foreach ($members as $member) {
$this->_request_data['events'][] = new org_openpsa_calendar_event_dba($member->eid);
}
}
}
/**
* Preparations related to all save operations (=create/update)
*/
private function _prepare_save($ignorebusy_em = false, $rob_tentantive = false)
{
// Make sure we have accessType
if (!$this->orgOpenpsaAccesstype) {
$this->orgOpenpsaAccesstype = org_openpsa_core_acl::ACCESS_PUBLIC;
}
// Make sure we can actually reserve the resources we need
foreach ($this->resources as $id => $bool) {
if (!$bool) {
continue;
}
$checker = new org_openpsa_calendar_event_resource_dba();
$checker->resource = $id;
if (!$checker->verify_can_reserve()) {
$msg = "Cannot reserve resource #{$id}, returning false";
$this->errstr = $msg;
debug_add($msg, MIDCOM_LOG_ERROR);
midcom_connection::set_error(MGD_ERR_ACCESS_DENIED);
unset($id, $checker, $msg);
return false;
}
unset($id, $checker);
}
//Check up
if (!$this->up && $this->title != '__org_openpsa_calendar') {
$root_event = org_openpsa_calendar_interface::find_root_event();
$this->up = $root_event->id;
}
//Doublecheck
if (!$this->up) {
debug_add('Event up not set, aborting');
$this->errstr = 'Event UP not set';
return false;
//Calendar events must always be under some other event
}
$conflictmanager = new org_openpsa_calendar_conflictmanager($this);
//check for busy participants/resources
if (!$conflictmanager->run($rob_tentantive) && !$ignorebusy_em) {
debug_print_r("Unresolved resource conflicts, aborting");
$this->errstr = 'Resource conflict with busy event';
return false;
}
/*
* Calendar events always have 'inherited' owner
* different bit buckets for calendar events might have different owners.
*/
$this->owner = 0;
//Preserve vCal GUIDs once set
if (isset($this->old_externalGuid)) {
$this->externalGuid = $this->old_externalGuid;
}
return true;
}
/**
* Search for events withing configured timeframe and if
* they have confirmed relatedtos to tasks reports hours
* for each participant (who is task resource) towards
* said task.
*/
public function _on_execute()
{
debug_add('_on_execute called');
$root_event = org_openpsa_calendar_interface::find_root_event();
if (!is_object($root_event)) {
debug_add('calendar root event not found', MIDCOM_LOG_WARN);
return;
}
if (!class_exists('org_openpsa_relatedto_dba')) {
debug_add('relatedto library could not be loaded', MIDCOM_LOG_WARN);
return;
}
if (!midcom::get('componentloader')->load_graceful('org.openpsa.projects')) {
debug_add('org.openpsa.projects could not be loaded', MIDCOM_LOG_WARN);
return;
}
if (!midcom::get('auth')->request_sudo('org.openpsa.calendar')) {
$msg = "Could not get sudo, aborting operation, see error log for details";
$this->print_error($msg);
debug_add($msg, MIDCOM_LOG_ERROR);
return;
}
$qb = org_openpsa_calendar_event_participant_dba::new_query_builder();
// Event must be directly under openpsa calendar root event
$qb->add_constraint('eid.up', '=', $root_event->id);
// Member type must not be resource
$qb->add_constraint('orgOpenpsaObtype', '<>', ORG_OPENPSA_OBTYPE_EVENTRESOURCE);
// Event must have ended
$qb->add_constraint('eid.end', '<', time());
// Event can be at most week old
// TODO: make max age configurable
/* TODO: store a timestamp of last process in root event and use whichever
is nearer, though it has the issue with creating events after the fact
(which can happen when synchronizing from other systems for example)
*/
$qb->add_constraint('eid.start', '>', time() - 24 * 3600 * 7);
// Must not have hours reported already
$qb->add_constraint('hoursReported', '=', 0);
$eventmembers = $qb->execute();
if (!is_array($eventmembers) || count($eventmembers) < 1) {
midcom::get('auth')->drop_sudo();
return;
}
// keyed by id
$seen_events = array();
// keyed by guid
$seen_tasks = array();
// keyed by guid
$event_links = array();
foreach ($eventmembers as $member) {
// Bulletproofing: prevent duplicating hour reports
$member->hoursReported = time();
if (!$member->update(false)) {
$msg = "Could not set hoursReported on member #{$member->id} (event #{$member->eid}), errstr: " . midcom_connection::get_error_string() . " skipping this member";
$this->print_error($msg);
debug_add($msg, MIDCOM_LOG_ERROR);
continue;
}
//Avoid multiple loads of same event
if (!isset($seen_events[$member->eid])) {
$seen_events[$member->eid] = new org_openpsa_calendar_event_dba($member->eid);
}
$event =& $seen_events[$member->eid];
// Avoid multiple queries of events links
if (!isset($event_links[$event->guid])) {
$qb2 = org_openpsa_relatedto_dba::new_query_builder();
$qb2->add_constraint('fromGuid', '=', $event->guid);
$qb2->add_constraint('fromComponent', '=', 'org.openpsa.calendar');
$qb2->add_constraint('toComponent', '=', 'org.openpsa.projects');
$qb2->add_constraint('toClass', '=', 'org_openpsa_projects_task_dba');
$qb2->add_constraint('status', '=', org_openpsa_relatedto_dba::CONFIRMED);
$event_links[$event->guid] = $qb2->execute();
}
$links =& $event_links[$event->guid];
// These checks are done here (in stead of few lines above) on purpose
if (!is_array($links) || count($links) < 1) {
continue;
}
foreach ($links as $link) {
//Avoid multiple loads of same task
if (!isset($seen_tasks[$link->toGuid])) {
$seen_tasks[$link->toGuid] = new org_openpsa_projects_task_dba($link->toGuid);
}
$task =& $seen_tasks[$link->toGuid];
debug_add("processing task #{$task->id} ({$task->title}) for person #{$member->uid} from event #{$event->id} ({$event->title})");
// Make sure the person we found is a resource in this particular task
$task->get_members();
if (!isset($task->resources[$member->uid])) {
debug_add("person #{$member->uid} is not a *resource* in task #{$task->id}, skipping");
continue;
}
if (!org_openpsa_projects_interface::create_hour_report($task, $member->uid, $event, 'org.openpsa.calendar')) {
// MidCOM error log is filled in the method, here we just display error
$this->print_error("Failed to create hour_report to task #{$task->id} for person #{$member->uid} from event #{$event->id}");
// Failed to create hour_report, unset hoursReported so that we might have better luck next time
// PONDER: This might be an issue in case be have multiple tasks linked and only one of them fails... figure out a more granular way to flag reported hours ?
$member->hoursReported = 0;
if (!$member->update(false)) {
$msg = "Could not UNSET hoursReported on member #{$member->id} (event #{$member->eid}), errstr: " . midcom_connection::get_error_string();
$this->print_error($msg);
debug_add($msg, MIDCOM_LOG_WARN);
}
}
}
}
midcom::get('auth')->drop_sudo();
debug_add('done');
return;
}
