<?php
//ini_set('display_errors',1);
$case = new cases();
$global_tasks = new GlobalTask();
$sql = $case->search_query(array('case_id' => $options['case_id']));
$array = $this->db->fetch_assoc($this->db->query($sql));
$array['tasks'] = array();
$tasks = $global_tasks->search_flow_chart_tasks(array('module' => 'cases', 'module_id' => $options['case_id']));
foreach ($tasks as $n => $v) {
//$v['name'] = $v['subject'];
$v['task_type'] = 'global_task';
$v['task_id'] = $v['chart_assign_id'];
$v['access'] = $global_tasks->check_permitions($v);
$v['options'] = $global_tasks->get_flowchart_options($v['flow_chart_id']);
$array['tasks'][] = $v;
}
$array['activity'] = $this->get_activity_log_by_module('cases', $options['case_id']);
$array['followers'] = $this->follow->get_followers_by_module('cases', $options['case_id']);
if (array_key_exists($_SESSION['user_id'], $array['followers'])) {
$array['following'] = true;
} else {
$array['following'] = false;
}
$time = new TimeTracker();
$time->setModuleName('cases');
$time->setModuleID($options['case_id']);
$array['time'] = array();
$array['time']['entries'] = $time->getTimeEntries();
$array['time']['open'] = $time->getOpenEntryId($array['time']['entries']);
$contacts = new contacts();
//$sql = $case->search_query( array('case_id' => $options['case_id'] ) );
$sql = "SELECT * FROM contacts WHERE contact_id = '" . $options['contact_id'] . "'";
$array = $this->db->fetch_assoc($this->db->query($sql));
$array['tasks'] = array();
$tasks = $global_tasks->search_flow_chart_tasks(array('module' => 'contacts', 'module_id' => $options['contact_id']));
foreach ($tasks as $n => $v) {
//$v['name'] = $v['subject'];
$v['task_type'] = 'global_task';
$v['task_id'] = $v['chart_assign_id'];
$v['access'] = $global_tasks->check_permitions($v);
$v['options'] = $global_tasks->get_flowchart_options($v['flow_chart_id']);
$array['tasks'][] = $v;
}
$array['activity'] = $this->get_activity_log_by_module('contacts', $options['contact_id']);
$array['followers'] = $this->follow->get_followers_by_module('contacts', $options['contact_id']);
$array['phone'] = $contacts->get_contact_phone($options['contact_id']);
$array['email'] = $contacts->get_contact_email($options['contact_id']);
$array['address'] = $contacts->get_contact_address($options['contact_id']);
$array['im'] = $contacts->get_contact_im($options['contact_id']);
if (array_key_exists($_SESSION['user_id'], $array['followers'])) {
$array['following'] = true;
} else {
$array['following'] = false;
}
$sql = $case->search_query(array('module_name' => 'contacts', 'module_id' => $options['contact_id']));
$result = $this->db->query($sql);
$array['cases'] = array();
while ($row = $this->db->fetch_assoc($result)) {
$array['cases'][] = $row;
}
<?php
$case = new cases();
$search = array();
//I did it this way to allow alias's
$avalible_keys = array('case_id' => 'case_id', 'group_id' => 'group_id', 'module_name' => 'module_name', 'subject' => 'subject', 'OrderNumber' => 'OrderNumber', 'module_id' => 'module_id', 'contact_module_id' => 'contact_module_id', 'contact_module_name' => 'contact_module_name', 'TicketNumber' => 'TicketNumber', 'Title' => 'Title', 'CreatedOn_min' => 'CreatedOn_min', 'CreatedOn_max' => 'CreatedOn_max', 'CaseType' => 'CaseType', 'Priority' => 'Priority', 'Owner' => 'Owner', 'owner' => 'Owner', 'Status' => 'Status', 'status' => 'Status', 'CaseOrigin' => 'CaseOrigin', 'client_name' => 'client_name', 'client_id' => 'client_id', 'no_account' => 'no_account', 'search' => 'search');
foreach ($options as $n => $v) {
if (array_key_exists($n, $avalible_keys)) {
$search[$avalible_keys[$n]] = $v;
}
switch ($n) {
case 'self':
if ($v == 'true') {
$search['Owner'] = $_SESSION['user_id'];
}
break;
}
}
$sql = $case->search_query($search);
$result = $this->db->query($sql);
while ($row = $this->db->fetch_assoc($result)) {
$array[] = $row;
}
//$array=array('sql' => $sql);