Пример #1
0
 $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;
}