Elep

<?php
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */
if (!is_admin($current_user)) {
    sugar_die('Unauthorized access to administration.');
}

global $timedate;

$callBean = BeanFactory::newBean('Calls');
$callQuery = "SELECT * FROM calls where calls.status != 'Held' and calls.deleted=0";

$result = $callBean->db->query($callQuery, true, '');
$row = $callBean->db->fetchByAssoc($result);
while ($row != null) {
    $dateCalled = $timedate->fromDb($row['date_start']);
    if (!empty($dateCalled)) {
        $date_end = $dateCalled->modify("+{$row['duration_hours']} hours {$row['duration_minutes']} mins")->asDb();
        $call = BeanFactory::newBean('Calls');
        $call->db->getConnection()
            ->update(
                'calls',
                ['date_end' => $date_end],
                ['id' => $row['id']]
            );
        $row = $callBean->db->fetchByAssoc($result);
    }
}

$meetingBean = BeanFactory::newBean('Meetings');
$meetingQuery = "SELECT * FROM meetings where meetings.status != 'Held' and meetings.deleted=0";

$result = $meetingBean->db->query($meetingQuery, true, '');
$row = $meetingBean->db->fetchByAssoc($result);
while ($row != null) {
    $dateCalled = $timedate->fromDb($row['date_start']);
    if (!empty($dateCalled)) {
        $date_end = $dateCalled->modify("+{$row['duration_hours']} hours {$row['duration_minutes']} mins")->asDb();
        $call = BeanFactory::newBean('Calls');
        $call->db->getConnection()
            ->update(
                'meetings',
                ['date_end' => $date_end],
                ['id' => $row['id']]
            );
        $row = $callBean->db->fetchByAssoc($result);
    }
}
echo $mod_strings['LBL_DIAGNOSTIC_DONE'];