YetiForceCompany/YetiForceCRM

<?php

/**
 * Update the dates of created events automatically.
 *
 * @copyright YetiForce S.A.
 * @license   YetiForce Public License 6.5 (licenses/LicenseEN.txt or yetiforce.com)
 * @author    Mariusz Krzaczkowski <m.krzaczkowski@yetiforce.com>
 */
class VTUpdateCalendarDates extends VTTask
{
    /**
     * Execute immediately.
     *
     * @var bool
     */
    public $executeImmediately = true;

    /**
     * Get field names.
     *
     * @return array
     */
    public function getFieldNames()
    {
        return [];
    }

    /**
     * Execute task.
     *
     * @param Vtiger_Record_Model $recordModel
     */
    public function doTask($recordModel)
    {
        $entityId = $recordModel->getId();

        $delta = $recordModel->getPreviousValue();
        if (!$delta) {
            return;
        }
        $query = (new \App\Db\Query())->from('vtiger_activity_update_dates')->innerJoin('com_vtiger_workflowtasks', 'com_vtiger_workflowtasks.task_id = vtiger_activity_update_dates.task_id')->where(['vtiger_activity_update_dates.parent' => $entityId]);
        $dataReader = $query->createCommand()->query();
        while ($row = $dataReader->read()) {
            $task = new \ArrayObject(unserialize($row['task']));
            $rowRecordModel = Vtiger_Record_Model::getInstanceById($row['activityid'], 'Calendar');

            if ('wfRunTime' === $task['datefield_start']) {
                $baseDateStart = date('Y-m-d H:i:s');
            } else {
                $baseDateStart = $recordModel->get($task['datefield_start']);
                if ('' === $baseDateStart) {
                    $baseDateStart = date('Y-m-d');
                }
            }
            preg_match('/\d\d\d\d-\d\d-\d\d/', $baseDateStart, $match);
            $baseDateStart = strtotime($match[0]);

            if ('wfRunTime' === $task['datefield_end']) {
                $baseDateEnd = date('Y-m-d H:i:s');
            } else {
                $baseDateEnd = $recordModel->get($task['datefield_end']);
                if ('' === $baseDateEnd) {
                    $baseDateEnd = date('Y-m-d');
                }
            }
            preg_match('/\d\d\d\d-\d\d-\d\d/', $baseDateEnd, $match);
            $baseDateEnd = strtotime($match[0]);

            $date_start = strftime('%Y-%m-%d', $baseDateStart + $task['days_start'] * 24 * 60 * 60 * ('before' == strtolower($task['direction_start']) ? -1 : 1));
            $due_date = strftime('%Y-%m-%d', $baseDateEnd + $task['days_end'] * 24 * 60 * 60 * ('before' == strtolower($task['direction_start']) ? -1 : 1));

            $rowRecordModel->set('date_start', $date_start);
            $rowRecordModel->set('due_date', $due_date);
            $rowRecordModel->save();
        }
    }
}