public function contact_activities($me)
{
$this->theme = $this->pack_module(Base_Theme::module_name());
$this->filters();
$this->theme->display();
$events = null;
$tasks = null;
$phonecalls = null;
$date_filter = '';
// if ($this->activities_date==0) $date_filter = ' cce.starts>'.Base_RegionalSettingsCommon::reg2time(date('Y-m-d 0:00:00')).' AND';
// if ($this->activities_date==1) $date_filter = ' cce.ends<'.Base_RegionalSettingsCommon::reg2time(date('Y-m-d 0:00:00')).' AND';
if ($this->display['events']) {
//$events = DB::GetAll('SELECT * FROM crm_calendar_event AS cce WHERE cce.deleted=0 AND'.$date_filter.(!$this->display['closed']?' cce.status<2 AND':'').' (EXISTS (SELECT contact FROM crm_calendar_event_group_emp AS ccegp WHERE ccegp.id=cce.id AND contact=%d) OR EXISTS (SELECT contact FROM crm_calendar_event_group_cus AS ccegc WHERE ccegc.id=cce.id AND contact=%d)) ORDER BY starts DESC', array($me['id'], $me['id']));
if ($this->activities_date == 0) {
$events = CRM_MeetingCommon::crm_event_get_all(date('Y-m-d H:i:s'), date('Y-m-d H:i:s', time() + 10 * 365 * 24 * 3600), '(' . $me['id'] . ')', array('P:' . $me['id']));
} elseif ($this->activities_date == 1) {
$events = CRM_MeetingCommon::crm_event_get_all(date('Y-m-d H:i:s', 0), date('Y-m-d H:i:s'), '(' . $me['id'] . ')', array('P:' . $me['id']));
} else {
$events = CRM_MeetingCommon::crm_event_get_all(date('Y-m-d H:i:s', 0), date('Y-m-d H:i:s', time() + 10 * 365 * 24 * 3600), '(' . $me['id'] . ')', array('P:' . $me['id']));
}
}
$crits = array('(employees' => $me['id'], '|customers' => 'P:' . $me['id']);
if ($this->activities_date == 0) {
$crits['(>=deadline'] = date('Y-m-d');
$crits['|deadline'] = '';
}
if ($this->activities_date == 1) {
$crits['(<deadline'] = date('Y-m-d');
$crits['|deadline'] = '';
}
if (!$this->display['closed']) {
$crits['!status'] = array(2, 3);
}
if ($this->display['tasks']) {
$tasks = CRM_TasksCommon::get_tasks($crits, array(), array('deadline' => 'DESC'));
}
$crits = array('(employees' => $me['id'], '|customer' => 'P:' . $me['id']);
if ($this->activities_date == 0) {
$crits['>=date_and_time'] = date('Y-m-d H:i:s', Base_RegionalSettingsCommon::reg2time(date('Y-m-d 0:00:00')));
}
if ($this->activities_date == 1) {
$crits['<date_and_time'] = date('Y-m-d H:i:s', Base_RegionalSettingsCommon::reg2time(date('Y-m-d 0:00:00')));
}
if (!$this->display['closed']) {
$crits['!status'] = array(2, 3);
}
if ($this->display['phonecalls']) {
$phonecalls = CRM_PhoneCallCommon::get_phonecalls($crits, array(), array('date_and_time' => 'DESC'));
}
$this->display_activities($events, $tasks, $phonecalls);
}
public function display_activities($events, $tasks, $phonecalls)
{
$gb = $this->init_module('Utils/GenericBrowser', 'activities', 'activities');
$gb->set_table_columns(array(array('name' => __('Type'), 'wrapmode' => 'nowrap', 'width' => 8), array('name' => __('Subject'), 'width' => 20), array('name' => __('Date/Deadline'), 'wrapmode' => 'nowrap', 'width' => 8), array('name' => __('Employees'), 'width' => 11), array('name' => __('Customers'), 'width' => 11), array('name' => __('Attachments'), 'width' => 4)));
$amount = 0;
if ($this->display['events']) {
$amount += count($events);
}
if ($this->display['tasks']) {
$amount += count($tasks);
}
if ($this->display['phonecalls']) {
$amount += count($phonecalls);
}
$limit = $gb->get_limit($amount);
for ($i = 0; $i < $limit['offset'] + $limit['numrows'] && $i < $amount; $i++) {
if ($this->display['events'] && count($events)) {
$ev = current($events);
} else {
$ev = array('start' => -1);
}
if ($this->display['tasks'] && count($tasks)) {
$t = current($tasks);
if (!$t['deadline']) {
$t['deadline'] = 0;
} else {
$t['deadline'] = strtotime($t['deadline']);
}
} else {
$t = array('deadline' => -1);
}
if ($this->display['phonecalls'] && count($phonecalls)) {
$ph = current($phonecalls);
$ph['date_and_time'] = strtotime($ph['date_and_time']);
} else {
$ph = array('date_and_time' => -1);
}
$maxt = max($ev['start'], $t['deadline'], $ph['date_and_time']);
$gb_row = $gb->get_new_row();
if ($ev['start'] == $maxt) {
$v = array_shift($events);
if ($i >= $limit['offset'] && $v) {
// $employees = DB::GetAssoc('SELECT contact, contact FROM crm_calendar_event_group_emp AS ccegp WHERE ccegp.id=%d', array($v['id']));
// $customers = DB::GetAssoc('SELECT contact, contact FROM crm_calendar_event_group_cus AS ccegc WHERE ccegc.id=%d', array($v['id']));
$event = CRM_MeetingCommon::crm_event_get($v['id']);
if (isset($v['view_action'])) {
$view_href = $v['view_action'];
} else {
$view_href = $this->create_callback_href(array($this, 'view_event'), array($v['id']));
}
$title = '<a ' . $view_href . '>' . $v['title'] . '</a>';
if (isset($v['description']) && $v['description'] != '') {
$title = '<span ' . Utils_TooltipCommon::open_tag_attrs($v['description'], false) . '>' . $title . '</span>';
}
$gb_row->add_info(Utils_RecordBrowserCommon::get_html_record_info('crm_meeting', $v['id']));
$gb_row->add_data(__('Meeting'), $title, Base_RegionalSettingsCommon::time2reg($v['start'], $v['duration'] == -1 ? false : 2), CRM_ContactsCommon::display_contact(array('employees' => $event['employees']), false, array('id' => 'employees', 'param' => ';CRM_ContactsCommon::contact_format_no_company')), CRM_ContactsCommon::display_company_contact(array('customers' => $event['customers']), false, array('id' => 'customers', 'param' => ';::')), Utils_AttachmentCommon::count('crm_meeting/' . $v['id']));
}
} elseif ($t['deadline'] == $maxt) {
$v = array_shift($tasks);
$v = Utils_RecordBrowserCommon::filter_record_by_access('task', $v);
if ($i >= $limit['offset'] && $v) {
$gb_row->add_info(Utils_RecordBrowserCommon::get_html_record_info('task', $v['id']));
$gb_row->add_data(__('Task'), CRM_TasksCommon::display_title($v, false), !isset($v['deadline']) || !$v['deadline'] ? __('No deadline') : Base_RegionalSettingsCommon::time2reg($v['deadline'], false, true, false), CRM_ContactsCommon::display_contact($v, false, array('id' => 'employees', 'param' => ';CRM_ContactsCommon::contact_format_no_company')), CRM_ContactsCommon::display_company_contact($v, false, array('id' => 'customers')), Utils_AttachmentCommon::count('task/' . $v['id']));
}
} else {
$v = array_shift($phonecalls);
$v = Utils_RecordBrowserCommon::filter_record_by_access('phonecall', $v);
if ($i >= $limit['offset'] && $v) {
$gb_row->add_info(Utils_RecordBrowserCommon::get_html_record_info('phonecall', $v['id']));
$gb_row->add_data(__('Phonecall'), CRM_PhoneCallCommon::display_subject($v), Base_RegionalSettingsCommon::time2reg($v['date_and_time'], 2), CRM_ContactsCommon::display_contact($v, false, array('id' => 'employees', 'param' => ';CRM_ContactsCommon::contact_format_no_company')), CRM_PhoneCallCommon::display_contact_name($v, false), Utils_AttachmentCommon::count('phonecall/' . $v['id']));
}
}
}
$this->display_module($gb);
}