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()); }