ProjectMapper.php

<?php
// db/authormapper.php

namespace OCA\TimeTracker\Db;

use OCP\IDBConnection;
use OCP\AppFramework\Db\Mapper;

class ProjectMapper extends Mapper {

    public function __construct(IDBConnection $db) {
        parent::__construct($db, 'timetracker_project');
    }


    public function findByName($name) {
        $sql = 'SELECT * FROM `*PREFIX*timetracker_project` ' .
            'WHERE upper(`name`) = ?';
            
            try {
                $e = $this->findEntity($sql, [strtoupper($name)]);
                return $e;
            } catch (\OCP\AppFramework\Db\DoesNotExistException $e){
                return null;
            }
        
    }

    /**
     * @throws \OCP\AppFramework\Db\DoesNotExistException if not found
     * @throws \OCP\AppFramework\Db\MultipleObjectsReturnedException if more than one result
     */
    public function find($id) {
        $sql = 'SELECT * FROM `*PREFIX*timetracker_project` ' .
            'WHERE `id` = ?';
        return $this->findEntity($sql, [$id]);
    }


    public function findAll($user,$getArchived = 0){
        if ($getArchived) {
            $sql = 'SELECT tp.* FROM `*PREFIX*timetracker_project` tp left join `*PREFIX*timetracker_user_to_project` up '.
                'on up.project_id = tp.id where up.user_uid = ? order by tp.name asc';
        } else {
            $sql = 'SELECT tp.* FROM `*PREFIX*timetracker_project` tp left join `*PREFIX*timetracker_user_to_project` up '.
                'on up.project_id = tp.id where up.user_uid = ? and tp.archived != 1 order by tp.name asc';
        }
        return $this->findEntities($sql, [$user]);
    }
    public function findAllAdmin($getArchived = 0){
        if ($getArchived) {
            $sql = 'SELECT tp.* FROM `*PREFIX*timetracker_project` tp order by tp.name asc';
        } else {
            $sql = 'SELECT tp.* FROM `*PREFIX*timetracker_project` tp where tp.archived != 1 order by tp.name asc';
        }
        return $this->findEntities($sql, []);
    }

    public function delete($project_id) {
        $sql = 'delete FROM `*PREFIX*timetracker_project` ' .
            ' where id = ?';
            
            try {
                $this->execute($sql, [$project_id]);
                return;
            } catch (\OCP\AppFramework\Db\DoesNotExistException $e){
                return;
            }
        
    }



   
}