function get_altered_relationships($module_name, $related_module, $from_date, $to_date)
{
global $disable_date_format;
$disable_date_format = true;
$db = DBManagerFactory::getInstance();
$where = "rt.date_modified > {$db->convert($db->quoted($from_date), 'datetime')}";
$where .= " AND rt.date_modified <= {$db->convert($db->quoted($to_date), 'datetime')}";
$results = retrieve_relationships($module_name, $related_module, $where, 2, 0, -99);
$list = $results['result'];
$output_list = array();
foreach ($list as $value) {
$output_list[] = array_get_return_value($value, $results['table_name']);
//force accept server
$output_list[sizeof($output_list) - 1]['resolve'] = 1;
}
return array('result_count' => sizeof($output_list), 'entry_list' => $output_list);
}
function sync_get_relationships($session, $module_name, $related_module, $from_date, $to_date, $offset, $max_results, $deleted)
{
global $beanList;
$error = new SoapError();
$output_list = array();
if (!validate_authenticated($session)) {
$error->set_error('invalid_login');
return array('result_count' => -1, 'entry_list' => array(), 'error' => $error->get_soap_array());
}
if (empty($beanList[$module_name]) || empty($beanList[$related_module])) {
$error->set_error('no_module');
return array('result_count' => -1, 'entry_list' => array(), 'error' => $error->get_soap_array());
}
global $current_user;
if (!check_modules_access($current_user, $module_name, 'read') || !check_modules_access($current_user, $related_module, 'read')) {
$error->set_error('no_access');
return array('result_count' => -1, 'entry_list' => array(), 'error' => $error->get_soap_array());
}
if ($max_results > 0 || $max_results == '-99') {
global $sugar_config;
$sugar_config['list_max_entries_per_page'] = $max_results;
}
$results = retrieve_relationships($module_name, $related_module, "rt.date_modified > " . db_convert("'" . $GLOBALS['db']->quote($from_date) . "'", 'datetime') . " AND rt.date_modified <= " . db_convert("'" . $GLOBALS['db']->quote($to_date) . "'", 'datetime'), $deleted, $offset, $max_results);
$list = $results['result'];
foreach ($list as $value) {
$output_list[] = array_get_return_value($value, $results['table_name']);
}
$next_offset = $offset + sizeof($output_list);
$myoutput = get_encoded($output_list);
return array('result_count' => sizeof($output_list), 'next_offset' => $next_offset, 'total_count' => $results['total_count'], 'field_list' => array(), 'entry_list' => $myoutput, 'error' => $error->get_soap_array());
}
