Page History

<?php
    public function add($aVals,$bIsUpdate = false)
    {
        $aInsert = [
            'name' => $aVals['name'],
            'description' => $aVals['description'],
            'time_update' => time(), // last modification time
            'privacy' => $aVals['privacy'], // public
        ];

        if ($bIsUpdate) {
            $aTodo = db()->select('*')->from(':todolist_task')->where('task_id = '.$aVals['task_id'])->execute('getRow');
            //When edit a todo task, we need to check and remove old photo if user upload new photo or delete current photo
            if (!empty($aTodo['image_path']) && (!empty($aVals['temp_file']) || !empty($aVals['remove_photo']))) {
                if ($this->deleteImage($aVals['task_id'],$aTodo['user_id'])) {
                    $aInsert['image_path'] = null;
                    $aInsert['server_id'] = 0;
                }
                else {
                    return false;
                }
            }
        }

        //$aVals['temp_file'] is id of temporary file was saved in `phpfox_temp_file` table, this is file you just uploaded
        if (!empty($aVals['temp_file'])) {
            //Get detail of this file
            $aFile = Phpfox::getService('core.temp-file')->get($aVals['temp_file']);
            if (!empty($aFile)) {
                //Set value for `image_path` and `server_id` column based on data of temp file
                $aInsert['image_path'] = $aFile['path'];
                $aInsert['server_id'] = $aFile['server_id'];
                //Remove this temporary row in `phpfox_temp_file` table
                Phpfox::getService('core.temp-file')->delete($aVals['temp_file']);
            }
        }
        if ($bIsUpdate) {
            // update to do item
            db()->update(':todolist_task', $aInsert, ['task_id' => $aVals['task_id']]);

            if ($aVals['privacy'] == '4') {
                Phpfox::getService('privacy.process')->update('todo', $aVals['task_id'],
                    (isset($aVals['privacy_list']) ? $aVals['privacy_list'] : array()));
            }
        } else {
            $aInsert['time_stamp'] = time();
            $aInsert['user_id'] = Phpfox::getUserId();
            // Insert to do item database
            $iItemId = db()->insert(':todolist_task', $aInsert);

            if ($aVals['privacy'] == '4') {
                Phpfox::getService('privacy.process')->add('todo', $iItemId,
                    (isset($aVals['privacy_list']) ? $aVals['privacy_list'] : array()));
            }

            Phpfox::getService('feed.process')->add('todo', $iItemId, 0, 0);
        }
    }
?>

<?php
    public function deleteImage($iId, $iUserId)
    {
        $iUserId = (int)$iUserId;
        $iId = (int)$iId;

        $aTodo = db()->select('image_path, server_id, user_id')
            ->from(':todolist_task')
            ->where('task_id ='.$iId)
            ->execute('getRow');

        if (!empty($aTodo['image_path'])) {
            $aParams = Phpfox::getService('todo.callback')->getUploadParams();
            $aParams['type'] = 'todo';
            $aParams['path'] = $aTodo['image_path'];
            $aParams['user_id'] = $iUserId;
            $aParams['server_id'] = $aTodo['server_id'];
            if (Phpfox::getService('user.file')->remove($aParams)) {
                $this->database()->update(':todolist_task', array('image_path' => null,'server_id' => 0),
                    'task_id = ' . $iId);
            }
            else {
                return false;
            }
        }
        return true;
    }
?>

<?php
    //...
    public function process()
    {
        //...
        // get request data
        $aVals = $request->get('val');

        if (!empty($aVals)) {
            // validate
            if (empty($aVals['name'])) {
                \Phpfox_Error::set(_p('To do name is required'));
            }

            if (empty($aVals['description'])) {
                \Phpfox_Error::set(_p('To do description is required'));
            }

            if (\Phpfox_Error::isPassed()) {
                if ($id) {
                    $aVals['task_id'] = $id;
                    Phpfox::getService('todo.process')->add($aVals,true);
                } else {
                    Phpfox::getService('todo.process')->add($aVals);
                }

                $this->url()->send('to-do-list');
            }
        }
        //...
    }
    //...
?>