private function _find_duplicates()
{
$qb = org_openpsa_projects_task_resource_dba::new_query_builder();
$qb->add_constraint('person', '=', (int) $this->person);
$qb->add_constraint('task', '=', (int) $this->task);
$qb->add_constraint('orgOpenpsaObtype', '=', (int) $this->orgOpenpsaObtype);
if ($this->id) {
$qb->add_constraint('id', '<>', (int) $this->id);
}
$dupes = $qb->execute();
if (count($dupes) > 0) {
return true;
}
return false;
}
public function _on_created()
{
//Remove the resource if necessary
if ($this->type == org_openpsa_projects_task_status_dba::DECLINED && $this->targetPerson) {
$qb = org_openpsa_projects_task_resource_dba::new_query_builder();
$qb->add_constraint('task', '=', $this->task);
$qb->add_constraint('person', '=', $this->targetPerson);
$qb->add_constraint('orgOpenpsaObtype', '=', ORG_OPENPSA_OBTYPE_PROJECTRESOURCE);
if ($qb->count() > 0) {
$results = $qb->execute();
foreach ($results as $result) {
debug_add("removing user #{$this->targetPerson} from resources");
$result->delete();
}
}
}
$this->_update_task();
}
/**
* Support for contacts person merge
*/
function org_openpsa_contacts_duplicates_merge_person(&$person1, &$person2, $mode)
{
switch ($mode) {
case 'all':
break;
/* In theory we could have future things (like resource/manager ships), but now we don't support that mode, we just exit */
/* In theory we could have future things (like resource/manager ships), but now we don't support that mode, we just exit */
case 'future':
return true;
break;
default:
// Mode not implemented
debug_add("mode {$mode} not implemented", MIDCOM_LOG_ERROR);
return false;
break;
}
// Transfer links from classes we drive
// ** resources **
$qb_member = org_openpsa_projects_task_resource_dba::new_query_builder();
$qb_member->add_constraint('person', '=', $person2->id);
$members = $qb_member->execute();
if ($members === false) {
// Some error with QB
debug_add('QB Error', MIDCOM_LOG_ERROR);
return false;
}
// Transfer memberships
foreach ($members as $member) {
// TODO: figure out duplicate memberships and delete unneeded ones
$member->person = $person1->id;
debug_add("Transferred task resource #{$member->id} to person #{$person1->id} (from #{$member->person})", MIDCOM_LOG_INFO);
if (!$member->update()) {
debug_add("Failed to update task resource #{$member->id}, errstr: " . midcom_connection::get_error_string(), MIDCOM_LOG_ERROR);
return false;
}
}
// ** task statuses **
$qb_receipt = org_openpsa_projects_task_status_dba::new_query_builder();
$qb_receipt->add_constraint('targetPerson', '=', $person2->id);
$receipts = $qb_receipt->execute();
if ($receipts === false) {
// Some error with QB
debug_add('QB Error / status', MIDCOM_LOG_ERROR);
return false;
}
foreach ($receipts as $receipt) {
debug_add("Transferred task_status #{$receipt->id} to person #{$person1->id} (from #{$receipt->person})", MIDCOM_LOG_INFO);
$receipt->targetPerson = $person1->id;
if (!$receipt->update()) {
// Error updating
debug_add("Failed to update status #{$receipt->id}, errstr: " . midcom_connection::get_error_string(), MIDCOM_LOG_ERROR);
return false;
}
}
// ** hour reports **
$qb_log = org_openpsa_projects_hour_report_dba::new_query_builder();
$qb_log->add_constraint('person', '=', $person2->id);
$logs = $qb_log->execute();
if ($logs === false) {
// Some error with QB
debug_add('QB Error / hours', MIDCOM_LOG_ERROR);
return false;
}
foreach ($logs as $log) {
debug_add("Transferred hour_report #{$log->id} to person #{$person1->id} (from #{$log->person})", MIDCOM_LOG_INFO);
$log->person = $person1->id;
if (!$log->update()) {
// Error updating
debug_add("Failed to update hour_report #{$log->id}, errstr: " . midcom_connection::get_error_string(), MIDCOM_LOG_ERROR);
return false;
}
}
// ** Task managers **
$qb_task = org_openpsa_projects_task_dba::new_query_builder();
$qb_task->add_constraint('manager', '=', $person2->id);
$tasks = $qb_task->execute();
if ($tasks === false) {
// Some error with QB
debug_add('QB Error / tasks', MIDCOM_LOG_ERROR);
return false;
}
foreach ($tasks as $task) {
debug_add("Transferred task #{$task->id} to person #{$person1->id} (from #{$task->person})", MIDCOM_LOG_INFO);
$task->manager = $person1->id;
if (!$task->update()) {
// Error updating
debug_add("Failed to update task #{$task->id}, errstr: " . midcom_connection::get_error_string(), MIDCOM_LOG_ERROR);
return false;
}
}
// Transfer metadata dependencies from classes that we drive
$classes = array('org_openpsa_projects_task_resource_dba', 'org_openpsa_projects_task_status_dba', 'org_openpsa_projects_task_dba', 'org_openpsa_projects_hour_report_dba');
$metadata_fields = array('creator' => 'guid', 'revisor' => 'guid');
foreach ($classes as $class) {
$ret = org_openpsa_contacts_duplicates_merge::person_metadata_dependencies_helper($class, $person1, $person2, $metadata_fields);
if (!$ret) {
// Failure updating metadata
debug_add("Failed to update metadata dependencies in class {$class}, errsrtr: " . midcom_connection::get_error_string(), MIDCOM_LOG_ERROR);
return false;
}
}
// All done
return 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_list_prospects($handler_id, array $args, array &$data)
{
$this->_task = new org_openpsa_projects_task_dba($args[0]);
$this->_task->require_do('midgard:create');
$qb = org_openpsa_projects_task_resource_dba::new_query_builder();
$qb->add_constraint('task', '=', $this->_task->id);
$qb->begin_group('OR');
$qb->add_constraint('orgOpenpsaObtype', '=', ORG_OPENPSA_OBTYPE_PROJECTPROSPECT);
$qb->add_constraint('orgOpenpsaObtype', '=', ORG_OPENPSA_OBTYPE_PROJECTRESOURCE);
$qb->end_group('OR');
$qb->add_order('orgOpenpsaObtype');
$data['prospects'] = $qb->execute();
midcom::get()->skip_page_style = true;
midcom::get('cache')->content->content_type("text/xml; charset=UTF-8");
midcom::get()->header("Content-type: text/xml; charset=UTF-8");
}
