nextcloud / calendar

        return $this->findEntities($sql, [$userId]);

	}

	public function canConfirm($otoLayerId){

		$sql = 'SELECT COUNT(*) as `count` FROM `*PREFIX*calendar_oto_confirmations` AS `t1` ' .

		'INNER JOIN `*PREFIX*calendar_oto_layers` as `t2` ON `t1`.`oto_layer_id` = `t2`.`oto_layer_id` ' .

		'WHERE `t2`.`oto_layer_id` = ?';

		$stmt = $this->execute($sql, [$otoLayerId]);

        $row = $stmt->fetch();

        $stmt->closeCursor();

        if( $row['count'] > 0 ){

			return false;

		}else{

			return true;

		}

	}

	//deletes all confirmations where otoLayerId = $otoLayerId

	public function deleteConfirmationsByOtoLayer($otoLayerId){

		$sql = 'DELETE FROM `*PREFIX*calendar_oto_confirmations` WHERE `oto_layer_id` = ?';

        return $this->findEntities($sql, [$userId]);

    }

	public function passwordCheck($otoLayerId, $password){

		$sql = 'SELECT COUNT(*) AS `count` FROM `*PREFIX*calendar_oto_layers` ' .

            'WHERE `oto_layer_id` = ? AND `password` = ?';

        $stmt = $this->execute($sql, [$otoLayerId,$password]);

        $row = $stmt->fetch();

        $stmt->closeCursor();

        if( $row['count'] > 0 ){

			return true;

		}else{

			return false;

		}

	}

	//deletes all layers where otoLayerId = $otoLayerId

	public function deleteLayer($otoLayerId){

		$sql = 'DELETE FROM `*PREFIX*calendar_oto_layers` WHERE `oto_layer_id` = ?';

		$stmt -> execute();

	}

	//checks if a calendar layer is being used for scheduling

	public function isOtoLayer($sourceId){

		$sql = 'SELECT COUNT(*) AS `count` FROM `*PREFIX*calendar_oto_layers` ' .

            'WHERE `source_id` = ?';

        $stmt = $this->execute($sql, [$sourceId]);

        $row = $stmt->fetch();

        $stmt->closeCursor();

        if( $row['count'] > 0 ){

			return true;

		}else{

			return false;

		}

	}

	//deletes all layers with the given sourceId

	public function deleteBySourceId($sourceId,$userId){

		$sql = 'DELETE FROM `*PREFIX*calendar_oto_layers` WHERE `source_id` = ? AND `user_id` = ?';