YetiForceCompany/YetiForceCRM

<?php
/**
 * TotalTimeWorked class.
 *
 * @copyright YetiForce S.A.
 * @license YetiForce Public License 6.5 (licenses/LicenseEN.txt or yetiforce.com)
 */
class TotalTimeWorked
{
    public $name = 'Total time worked';
    public $sequence = 6;
    public $reference = 'OSSTimeControl';

    /**
     * Process function.
     *
     * @param Vtiger_Record_Model $recordModel
     *
     * @return int
     */
    public function process(Vtiger_Record_Model $recordModel)
    {
        $sum = (new \App\Db\Query())->from('vtiger_osstimecontrol')
            ->innerJoin('vtiger_crmentity', 'vtiger_osstimecontrol.osstimecontrolid = vtiger_crmentity.crmid')
            ->where(['vtiger_crmentity.deleted' => 0, 'vtiger_osstimecontrol.link' => $recordModel->getId(), 'osstimecontrol_status' => 'Accepted'])->sum('sum_time');

        return \App\Fields\RangeTime::displayElapseTime($sum);
    }
}