$rDblCheck = $db->query($qDone);
$rowsDblCheck = $db->getRowCount($rDblCheck);
if ($rowsDblCheck < 1) {
// majed's sql generation
$tables = array('calls' => array('date_start' => 'time_start'), 'meetings' => array('date_start' => 'time_start'), 'tasks' => array('date_due' => 'time_due'), 'project_task' => array('date_due' => 'time_due'), 'email_marketing' => array('date_start' => 'time_start'), 'emailman' => array('send_date_time' => 'datetime'));
$zone = $_REQUEST['server_timezone'];
$td = new TimeDate();
$startyear = 2004;
$maxyear = 2014;
$date_modified = gmdate($GLOBALS['timedate']->get_db_date_time_format());
$display = '';
foreach ($tables as $table_name => $table) {
//$display .= '<B>'. $table_name . '</b><BR>';
$year = $startyear;
for ($year = $startyear; $year <= $maxyear; $year++) {
$range = $td->getDSTRange($year, $timezones[$zone]);
$startDateTime = explode(' ', $range['start']);
$endDateTime = explode(' ', $range['end']);
if ($range) {
if (strtotime($range['start']) < strtotime($range['end'])) {
foreach ($table as $date => $time) {
$interval = 'PLUSMINUS INTERVAL 3600 second';
if ($time != 'datetime') {
if ($db->dbType == 'mysql' or $db->dbType == 'oci8') {
$field = "CONCAT({$table_name}.{$date},' ', {$table_name}.{$time})";
}
if ($db->dbType == 'mssql') {
$field = "{$table_name}.{$date} + ' ' + {$table_name}.{$time}";
}
$updateBase = "UPDATE {$table_name} SET date_modified='{$date_modified}', {$table_name}.{$date}=LEFT({$field} {$interval},10),";
$updateBase .= " {$table_name}.{$time}=RIGHT({$field} {$interval},8)";
function getUserConfigJSON()
{
require_once 'include/TimeDate.php';
$td = new TimeDate();
global $current_user, $global_registry_var_name, $json, $_SESSION, $sugar_config;
if (isset($_SESSION['authenticated_user_theme']) && $_SESSION['authenticated_user_theme'] != '') {
$theme = $_SESSION['authenticated_user_theme'];
} else {
$theme = $sugar_config['default_theme'];
}
$user_arr = array();
$user_arr['theme'] = $theme;
$user_arr['fields'] = array();
$user_arr['module'] = 'User';
$user_arr['fields']['id'] = $current_user->id;
$user_arr['fields']['user_name'] = $current_user->user_name;
$user_arr['fields']['first_name'] = $current_user->first_name;
$user_arr['fields']['last_name'] = $current_user->last_name;
$user_arr['fields']['email'] = $current_user->email1;
$userTz = $td->getUserTimeZone();
$dstRange = $td->getDSTRange(date('Y'), $userTz);
$user_arr['fields']['dst_start'] = $dstRange['start'];
$user_arr['fields']['dst_end'] = $dstRange['end'];
$user_arr['fields']['gmt_offset'] = $userTz['gmtOffset'];
$str = "\n" . $global_registry_var_name . ".current_user = "******";\n";
return $str;
}