mirror of
https://github.com/solidtime-io/solidtime.git
synced 2026-08-10 01:02:15 +01:00
Compare commits
1 Commits
feature/co
...
feature/ba
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
d68c30476e |
@@ -1,123 +0,0 @@
|
|||||||
<?php
|
|
||||||
|
|
||||||
declare(strict_types=1);
|
|
||||||
|
|
||||||
namespace App\Console\Commands\SelfHost;
|
|
||||||
|
|
||||||
use Illuminate\Console\Command;
|
|
||||||
use Illuminate\Database\Query\Builder;
|
|
||||||
use Illuminate\Database\Query\JoinClause;
|
|
||||||
use Illuminate\Support\Collection;
|
|
||||||
use Illuminate\Support\Facades\DB;
|
|
||||||
use Illuminate\Support\Facades\Log;
|
|
||||||
|
|
||||||
class SelfHostDatabaseConsistency extends Command
|
|
||||||
{
|
|
||||||
/**
|
|
||||||
* The name and signature of the console command.
|
|
||||||
*
|
|
||||||
* @var string
|
|
||||||
*/
|
|
||||||
protected $signature = 'self-host:database-consistency';
|
|
||||||
|
|
||||||
/**
|
|
||||||
* The console command description.
|
|
||||||
*
|
|
||||||
* @var string
|
|
||||||
*/
|
|
||||||
protected $description = '';
|
|
||||||
|
|
||||||
/**
|
|
||||||
* Execute the console command.
|
|
||||||
*/
|
|
||||||
public function handle(): int
|
|
||||||
{
|
|
||||||
$hadAProblem = false;
|
|
||||||
|
|
||||||
// Task need to be part of project in time entries
|
|
||||||
$problems = DB::table('time_entries')
|
|
||||||
->select(['time_entries.id as id'])
|
|
||||||
->join('tasks', 'time_entries.task_id', '=', 'tasks.id')
|
|
||||||
->where('tasks.project_id', '!=', DB::raw('time_entries.project_id'))
|
|
||||||
->get();
|
|
||||||
$this->logProblems($problems, 'Time entries have a task that does not belong to the project of the time entry', $hadAProblem);
|
|
||||||
|
|
||||||
// Client id is the client id of the project
|
|
||||||
$problems = DB::table('time_entries')
|
|
||||||
->select(['time_entries.id as id'])
|
|
||||||
->join('projects', 'time_entries.project_id', '=', 'projects.id')
|
|
||||||
->where(DB::raw('coalesce(projects.client_id::varchar, \'\')'), '!=', DB::raw('coalesce(time_entries.client_id::varchar, \'\')'))
|
|
||||||
->get();
|
|
||||||
$this->logProblems($problems, 'Time entries have a client that does not match the client of the project', $hadAProblem);
|
|
||||||
|
|
||||||
// Client id can only be not null if the project id is not null
|
|
||||||
$problems = DB::table('time_entries')
|
|
||||||
->select(['time_entries.id as id'])
|
|
||||||
->whereNotNull('client_id')
|
|
||||||
->whereNull('project_id')
|
|
||||||
->get();
|
|
||||||
$this->logProblems($problems, 'Time entries have a client but no project', $hadAProblem);
|
|
||||||
|
|
||||||
// Every user needs to be a member of at least one organization
|
|
||||||
$problems = DB::table('users')
|
|
||||||
->select(['users.id as id'])
|
|
||||||
->leftJoin('members', 'users.id', '=', 'members.user_id')
|
|
||||||
->whereNull('members.id')
|
|
||||||
->get();
|
|
||||||
$this->logProblems($problems, 'Users are not member of any organization', $hadAProblem);
|
|
||||||
|
|
||||||
// Every organization needs at least an owner
|
|
||||||
$problems = DB::table('organizations')
|
|
||||||
->select(['organizations.id as id'])
|
|
||||||
->leftJoin('members', function (JoinClause $join): void {
|
|
||||||
$join->on('organizations.id', '=', 'members.organization_id')
|
|
||||||
->where('members.role', '=', 'owner');
|
|
||||||
})
|
|
||||||
->whereNull('members.id')
|
|
||||||
->get();
|
|
||||||
$this->logProblems($problems, 'Organizations without an owner', $hadAProblem);
|
|
||||||
|
|
||||||
// Every member can only have one running time entry
|
|
||||||
$problems = DB::table('time_entries')
|
|
||||||
->select(['user_id as id'])
|
|
||||||
->whereNull('end')
|
|
||||||
->groupBy('user_id')
|
|
||||||
->havingRaw('count(*) > 1')
|
|
||||||
->get(['user_id', DB::raw('count(*) as count')]);
|
|
||||||
$this->logProblems($problems, 'Users with more than one running time entry', $hadAProblem);
|
|
||||||
|
|
||||||
// Users have a current organization that they are not a member of
|
|
||||||
$problems = DB::table('users')
|
|
||||||
->select(['users.id as id'])
|
|
||||||
->whereNotNull('current_team_id')
|
|
||||||
->whereNotIn('current_team_id', function (Builder $query): void {
|
|
||||||
$query->select('organization_id')
|
|
||||||
->from('members')
|
|
||||||
->whereColumn('members.user_id', 'users.id');
|
|
||||||
})->get();
|
|
||||||
$this->logProblems($problems, 'Users have a current organization that they are not a member of', $hadAProblem);
|
|
||||||
|
|
||||||
return $hadAProblem ? self::FAILURE : self::SUCCESS;
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* @param Collection<int, \stdClass> $problems
|
|
||||||
*/
|
|
||||||
private function logProblems(Collection $problems, string $message, bool &$hadAProblem): void
|
|
||||||
{
|
|
||||||
$message = 'Consistency problem: '.$message;
|
|
||||||
if ($problems->isNotEmpty()) {
|
|
||||||
$ids = $problems->pluck('id');
|
|
||||||
$hadAProblem = true;
|
|
||||||
Log::error($message, [
|
|
||||||
'ids' => $ids,
|
|
||||||
]);
|
|
||||||
|
|
||||||
$error = $message;
|
|
||||||
foreach ($ids as $id) {
|
|
||||||
$error .= "\n - ".$id;
|
|
||||||
}
|
|
||||||
$this->error($error);
|
|
||||||
}
|
|
||||||
}
|
|
||||||
}
|
|
||||||
@@ -25,10 +25,6 @@ class Kernel extends ConsoleKernel
|
|||||||
$schedule->command('self-host:telemetry')
|
$schedule->command('self-host:telemetry')
|
||||||
->when(fn (): bool => config('scheduling.tasks.self_hosting_telemetry'))
|
->when(fn (): bool => config('scheduling.tasks.self_hosting_telemetry'))
|
||||||
->twiceDaily();
|
->twiceDaily();
|
||||||
|
|
||||||
$schedule->command('self-host:database-consistency')
|
|
||||||
->when(fn (): bool => config('scheduling.tasks.self_hosting_database_consistency'))
|
|
||||||
->twiceDaily();
|
|
||||||
}
|
}
|
||||||
|
|
||||||
/**
|
/**
|
||||||
|
|||||||
@@ -1,14 +0,0 @@
|
|||||||
<?php
|
|
||||||
|
|
||||||
declare(strict_types=1);
|
|
||||||
|
|
||||||
namespace App\Events;
|
|
||||||
|
|
||||||
use Illuminate\Foundation\Events\Dispatchable;
|
|
||||||
|
|
||||||
class DatabaseSeederAfterSeed
|
|
||||||
{
|
|
||||||
use Dispatchable;
|
|
||||||
|
|
||||||
public function __construct() {}
|
|
||||||
}
|
|
||||||
@@ -1,14 +0,0 @@
|
|||||||
<?php
|
|
||||||
|
|
||||||
declare(strict_types=1);
|
|
||||||
|
|
||||||
namespace App\Events;
|
|
||||||
|
|
||||||
use Illuminate\Foundation\Events\Dispatchable;
|
|
||||||
|
|
||||||
class DatabaseSeederBeforeDelete
|
|
||||||
{
|
|
||||||
use Dispatchable;
|
|
||||||
|
|
||||||
public function __construct() {}
|
|
||||||
}
|
|
||||||
@@ -100,18 +100,12 @@ class DeletionService
|
|||||||
|
|
||||||
// Make sure all users have at least one organization and delete placeholders
|
// Make sure all users have at least one organization and delete placeholders
|
||||||
foreach ($users as $user) {
|
foreach ($users as $user) {
|
||||||
/** @var User $user */
|
|
||||||
if ($ignoreUser !== null && $user->is($ignoreUser)) {
|
if ($ignoreUser !== null && $user->is($ignoreUser)) {
|
||||||
continue;
|
continue;
|
||||||
}
|
}
|
||||||
if ($user->is_placeholder) {
|
if ($user->is_placeholder) {
|
||||||
$user->delete();
|
$user->delete();
|
||||||
} else {
|
} else {
|
||||||
if ($user->current_team_id === $organization->getKey()) {
|
|
||||||
$user->currentOrganization()->disassociate();
|
|
||||||
$user->save();
|
|
||||||
}
|
|
||||||
|
|
||||||
$this->userService->makeSureUserHasAtLeastOneOrganization($user);
|
$this->userService->makeSureUserHasAtLeastOneOrganization($user);
|
||||||
$this->userService->makeSureUserHasCurrentOrganization($user);
|
$this->userService->makeSureUserHasCurrentOrganization($user);
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -164,11 +164,6 @@ class MemberService
|
|||||||
public function makeMemberToPlaceholder(Member $member, bool $makeSureUserHasAtLeastOneOrganization = true): void
|
public function makeMemberToPlaceholder(Member $member, bool $makeSureUserHasAtLeastOneOrganization = true): void
|
||||||
{
|
{
|
||||||
$user = $member->user;
|
$user = $member->user;
|
||||||
if ($user->current_team_id === $member->organization_id) {
|
|
||||||
$user->currentTeam()->disassociate();
|
|
||||||
$user->save();
|
|
||||||
}
|
|
||||||
|
|
||||||
$placeholderUser = $user->replicate();
|
$placeholderUser = $user->replicate();
|
||||||
$placeholderUser->is_placeholder = true;
|
$placeholderUser->is_placeholder = true;
|
||||||
$placeholderUser->save();
|
$placeholderUser->save();
|
||||||
@@ -180,7 +175,6 @@ class MemberService
|
|||||||
$this->userService->assignOrganizationEntitiesToDifferentUser($member->organization, $user, $placeholderUser);
|
$this->userService->assignOrganizationEntitiesToDifferentUser($member->organization, $user, $placeholderUser);
|
||||||
if ($makeSureUserHasAtLeastOneOrganization) {
|
if ($makeSureUserHasAtLeastOneOrganization) {
|
||||||
$this->userService->makeSureUserHasAtLeastOneOrganization($user);
|
$this->userService->makeSureUserHasAtLeastOneOrganization($user);
|
||||||
$this->userService->makeSureUserHasCurrentOrganization($user);
|
|
||||||
}
|
}
|
||||||
}
|
}
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -114,15 +114,13 @@ class UserService
|
|||||||
|
|
||||||
public function makeSureUserHasCurrentOrganization(User $user): void
|
public function makeSureUserHasCurrentOrganization(User $user): void
|
||||||
{
|
{
|
||||||
if ($user->current_team_id !== null) {
|
if ($user->currentOrganization !== null) {
|
||||||
return;
|
return;
|
||||||
}
|
}
|
||||||
|
|
||||||
$organization = $user->organizations()->first();
|
$organization = $user->organizations()->first();
|
||||||
if ($organization !== null) {
|
$user->currentOrganization()->associate($organization);
|
||||||
$user->currentOrganization()->associate($organization);
|
$user->save();
|
||||||
$user->save();
|
|
||||||
}
|
|
||||||
}
|
}
|
||||||
|
|
||||||
/**
|
/**
|
||||||
|
|||||||
@@ -8,6 +8,5 @@ return [
|
|||||||
'time_entry_send_still_running_mails' => (bool) env('SCHEDULING_TASK_TIME_ENTRY_SEND_STILL_RUNNING_MAILS', true),
|
'time_entry_send_still_running_mails' => (bool) env('SCHEDULING_TASK_TIME_ENTRY_SEND_STILL_RUNNING_MAILS', true),
|
||||||
'self_hosting_check_for_update' => (bool) env('SCHEDULING_TASK_SELF_HOSTING_CHECK_FOR_UPDATE', true),
|
'self_hosting_check_for_update' => (bool) env('SCHEDULING_TASK_SELF_HOSTING_CHECK_FOR_UPDATE', true),
|
||||||
'self_hosting_telemetry' => (bool) env('SCHEDULING_TASK_SELF_HOSTING_TELEMETRY', true),
|
'self_hosting_telemetry' => (bool) env('SCHEDULING_TASK_SELF_HOSTING_TELEMETRY', true),
|
||||||
'self_hosting_database_consistency' => (bool) env('SCHEDULING_TASK_SELF_HOSTING_DATABASE_CONSISTENCY', false),
|
|
||||||
],
|
],
|
||||||
];
|
];
|
||||||
|
|||||||
@@ -1,43 +0,0 @@
|
|||||||
<?php
|
|
||||||
|
|
||||||
declare(strict_types=1);
|
|
||||||
|
|
||||||
use Illuminate\Database\Migrations\Migration;
|
|
||||||
use Illuminate\Database\Schema\Blueprint;
|
|
||||||
use Illuminate\Support\Facades\Schema;
|
|
||||||
|
|
||||||
return new class extends Migration
|
|
||||||
{
|
|
||||||
/**
|
|
||||||
* Run the migrations.
|
|
||||||
*/
|
|
||||||
public function up(): void
|
|
||||||
{
|
|
||||||
DB::statement('
|
|
||||||
update users
|
|
||||||
set current_team_id = null
|
|
||||||
where id in (
|
|
||||||
select users.id from users
|
|
||||||
left join organizations on users.current_team_id = organizations.id
|
|
||||||
where users.current_team_id is not null and organizations.id is null
|
|
||||||
)
|
|
||||||
');
|
|
||||||
Schema::table('users', function (Blueprint $table): void {
|
|
||||||
$table->foreign('current_team_id', 'organizations_current_organization_id_foreign')
|
|
||||||
->references('id')
|
|
||||||
->on('organizations')
|
|
||||||
->onDelete('restrict')
|
|
||||||
->onUpdate('cascade');
|
|
||||||
});
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* Reverse the migrations.
|
|
||||||
*/
|
|
||||||
public function down(): void
|
|
||||||
{
|
|
||||||
Schema::table('users', function (Blueprint $table): void {
|
|
||||||
$table->dropForeign('organizations_current_organization_id_foreign');
|
|
||||||
});
|
|
||||||
}
|
|
||||||
};
|
|
||||||
@@ -5,8 +5,6 @@ declare(strict_types=1);
|
|||||||
namespace Database\Seeders;
|
namespace Database\Seeders;
|
||||||
|
|
||||||
use App\Enums\Role;
|
use App\Enums\Role;
|
||||||
use App\Events\DatabaseSeederAfterSeed;
|
|
||||||
use App\Events\DatabaseSeederBeforeDelete;
|
|
||||||
use App\Models\Audit;
|
use App\Models\Audit;
|
||||||
use App\Models\Client;
|
use App\Models\Client;
|
||||||
use App\Models\Member;
|
use App\Models\Member;
|
||||||
@@ -186,13 +184,10 @@ class DatabaseSeeder extends Seeder
|
|||||||
'email' => 'admin@example.com',
|
'email' => 'admin@example.com',
|
||||||
]);
|
]);
|
||||||
|
|
||||||
DatabaseSeederAfterSeed::dispatch();
|
|
||||||
}
|
}
|
||||||
|
|
||||||
private function deleteAll(): void
|
private function deleteAll(): void
|
||||||
{
|
{
|
||||||
DatabaseSeederBeforeDelete::dispatch();
|
|
||||||
|
|
||||||
// Laravel Passport tables
|
// Laravel Passport tables
|
||||||
DB::table((new RefreshToken)->getTable())->delete();
|
DB::table((new RefreshToken)->getTable())->delete();
|
||||||
DB::table((new Token)->getTable())->delete();
|
DB::table((new Token)->getTable())->delete();
|
||||||
@@ -218,9 +213,6 @@ class DatabaseSeeder extends Seeder
|
|||||||
DB::table((new Client)->getTable())->delete();
|
DB::table((new Client)->getTable())->delete();
|
||||||
DB::table((new Member)->getTable())->delete();
|
DB::table((new Member)->getTable())->delete();
|
||||||
DB::table((new OrganizationInvitation)->getTable())->delete();
|
DB::table((new OrganizationInvitation)->getTable())->delete();
|
||||||
DB::table((new User)->getTable())->update([
|
|
||||||
'current_team_id' => null,
|
|
||||||
]);
|
|
||||||
DB::table((new Organization)->getTable())->delete();
|
DB::table((new Organization)->getTable())->delete();
|
||||||
DB::table((new User)->getTable())->delete();
|
DB::table((new User)->getTable())->delete();
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -9,8 +9,7 @@ return [
|
|||||||
'2. In the same preferences page change the language of Clockfiy to English.<br>'.
|
'2. In the same preferences page change the language of Clockfiy to English.<br>'.
|
||||||
'3. Go to REPORTS -> TIME -> Detailed in the navigation on the left. <br>'.
|
'3. Go to REPORTS -> TIME -> Detailed in the navigation on the left. <br>'.
|
||||||
'4. Now select the date range that you want to export in the right top. '.
|
'4. Now select the date range that you want to export in the right top. '.
|
||||||
'In the free Clockify plan it\'s currently not possible to select more than one year. '.
|
'It is currently not possible to select more than one year. You can export each year separately and import them one after another .'.
|
||||||
'You can export each year separately and import them one after another.'.
|
|
||||||
'<br> 4. Now click Export -> Save as CSV. The Export dropdown is in the header of the export table left of the printer symbol. '.
|
'<br> 4. Now click Export -> Save as CSV. The Export dropdown is in the header of the export table left of the printer symbol. '.
|
||||||
'<br><br>Before you import make sure that the Timezone settings in Clockify are the same as in solidtime.',
|
'<br><br>Before you import make sure that the Timezone settings in Clockify are the same as in solidtime.',
|
||||||
],
|
],
|
||||||
|
|||||||
@@ -44,7 +44,7 @@
|
|||||||
--theme-color-input-select-active: rgb(var(--color-accent-300));
|
--theme-color-input-select-active: rgb(var(--color-accent-300));
|
||||||
--theme-color-input-select-active-hover: rgb(var(--color-accent-200));
|
--theme-color-input-select-active-hover: rgb(var(--color-accent-200));
|
||||||
|
|
||||||
--color-accent-default: rgba(var(--color-accent-300), 0.2);
|
--color-accent-default: rgb(var(--color-accent-900));
|
||||||
--color-accent-foreground: rgb(var(--color-accent-100));
|
--color-accent-foreground: rgb(var(--color-accent-100));
|
||||||
}
|
}
|
||||||
|
|
||||||
|
|||||||
@@ -34,18 +34,11 @@ const forwarded = useForwardPropsEmits(delegatedProps, emits)
|
|||||||
v-bind="forwarded"
|
v-bind="forwarded"
|
||||||
:class="
|
:class="
|
||||||
cn(
|
cn(
|
||||||
'fixed top-0 left-0 z-50 w-screen h-screen flex items-start pt-6 md:pt-20 xl:pt-32 justify-center overflow-auto data-[state=open]:animate-in data-[state=closed]:animate-out data-[state=closed]:fade-out-0 data-[state=open]:fade-in-0 data-[state=closed]:zoom-out-95 data-[state=open]:zoom-in-95',
|
'fixed left-1/2 top-1/3 bg-default-background z-50 grid w-full max-w-lg -translate-x-1/2 -translate-y-1/2 border shadow-lg duration-200 data-[state=open]:animate-in data-[state=closed]:animate-out data-[state=closed]:fade-out-0 data-[state=open]:fade-in-0 data-[state=closed]:zoom-out-95 data-[state=open]:zoom-in-95 data-[state=closed]:slide-out-to-left-1/2 data-[state=closed]:slide-out-to-top-[48%] data-[state=open]:slide-in-from-left-1/2 data-[state=open]:slide-in-from-top-[48%] sm:rounded-lg',
|
||||||
|
|
||||||
)"
|
|
||||||
>
|
|
||||||
<div
|
|
||||||
:class="cn(
|
|
||||||
'bg-default-background grid w-full max-w-lg border shadow-lg duration-200 sm:rounded-lg',
|
|
||||||
props.class,
|
props.class,
|
||||||
)"
|
)"
|
||||||
>
|
>
|
||||||
<slot />
|
<slot />
|
||||||
</div>
|
|
||||||
</DialogContent>
|
</DialogContent>
|
||||||
</DialogPortal>
|
</DialogPortal>
|
||||||
</template>
|
</template>
|
||||||
|
|||||||
@@ -1,7 +1,7 @@
|
|||||||
<script setup lang="ts">
|
<script setup lang="ts">
|
||||||
import FormSection from '@/Components/FormSection.vue';
|
import FormSection from '@/Components/FormSection.vue';
|
||||||
import PrimaryButton from '@/packages/ui/src/Buttons/PrimaryButton.vue';
|
import PrimaryButton from '@/packages/ui/src/Buttons/PrimaryButton.vue';
|
||||||
import {computed, ref, inject, type ComputedRef} from 'vue';
|
import {computed, ref} from 'vue';
|
||||||
import InputLabel from '@/packages/ui/src/Input/InputLabel.vue';
|
import InputLabel from '@/packages/ui/src/Input/InputLabel.vue';
|
||||||
import {
|
import {
|
||||||
api,
|
api,
|
||||||
@@ -23,7 +23,6 @@ import {useNotificationsStore} from "@/utils/notification";
|
|||||||
import {useClipboard} from "@vueuse/core";
|
import {useClipboard} from "@vueuse/core";
|
||||||
import { formatDateTimeLocalized} from "../../../packages/ui/src/utils/time";
|
import { formatDateTimeLocalized} from "../../../packages/ui/src/utils/time";
|
||||||
import {ClockIcon} from "@heroicons/vue/20/solid";
|
import {ClockIcon} from "@heroicons/vue/20/solid";
|
||||||
import type { Organization } from '@/packages/api/src';
|
|
||||||
|
|
||||||
const queryClient = useQueryClient();
|
const queryClient = useQueryClient();
|
||||||
|
|
||||||
@@ -35,8 +34,6 @@ const newToken = ref('');
|
|||||||
|
|
||||||
const { copy, copied, isSupported } = useClipboard();
|
const { copy, copied, isSupported } = useClipboard();
|
||||||
|
|
||||||
const organization = inject<ComputedRef<Organization>>('organization');
|
|
||||||
|
|
||||||
async function createApiToken(){
|
async function createApiToken(){
|
||||||
await handleApiRequestNotifications(
|
await handleApiRequestNotifications(
|
||||||
() =>
|
() =>
|
||||||
@@ -216,10 +213,10 @@ const revokeApiTokenMutation = useMutation({
|
|||||||
<div>{{ token.name }}</div>
|
<div>{{ token.name }}</div>
|
||||||
<div class="text-sm text-text-tertiary space-x-3">
|
<div class="text-sm text-text-tertiary space-x-3">
|
||||||
<span v-if="token.created_at">
|
<span v-if="token.created_at">
|
||||||
Created at {{ formatDateTimeLocalized(token.created_at, organization?.date_format, organization?.time_format) }}
|
Created at {{ formatDateTimeLocalized(token.created_at) }}
|
||||||
</span>
|
</span>
|
||||||
<span v-if="token.expires_at">
|
<span v-if="token.expires_at">
|
||||||
Expires at {{ formatDateTimeLocalized(token.expires_at, organization?.date_format, organization?.time_format) }}
|
Expires at {{ formatDateTimeLocalized(token.expires_at) }}
|
||||||
</span>
|
</span>
|
||||||
<span v-if="token.revoked">
|
<span v-if="token.revoked">
|
||||||
Revoked
|
Revoked
|
||||||
|
|||||||
@@ -160,7 +160,10 @@ const tableData = computed(() => {
|
|||||||
cost: el.cost,
|
cost: el.cost,
|
||||||
description:
|
description:
|
||||||
el.description ??
|
el.description ??
|
||||||
emptyPlaceholder[entry.grouped_type ?? 'project'],
|
emptyPlaceholder[
|
||||||
|
aggregatedTableTimeEntries.value
|
||||||
|
?.grouped_type ?? 'project'
|
||||||
|
],
|
||||||
};
|
};
|
||||||
}) ?? [],
|
}) ?? [],
|
||||||
};
|
};
|
||||||
|
|||||||
@@ -146,9 +146,8 @@ export function formatDateLocalized(date: string, format: DateFormat = 'point-se
|
|||||||
return getLocalizedDayJs(date).format(dateFormatMap[format]);
|
return getLocalizedDayJs(date).format(dateFormatMap[format]);
|
||||||
}
|
}
|
||||||
|
|
||||||
export function formatDateTimeLocalized(date: string, dateFormat?: DateFormat, timeFormat?: TimeFormat): string {
|
export function formatDateTimeLocalized(date: string): string {
|
||||||
const format = `${dateFormatMap[dateFormat ?? 'point-separated-d-m-yyyy']} ${timeFormat === '12-hours' ? 'hh:mm A' : 'HH:mm'}`;
|
return getLocalizedDayJs(date).format('DD.MM.YYYY HH:mm');
|
||||||
return getLocalizedDayJs(date).format(format);
|
|
||||||
}
|
}
|
||||||
|
|
||||||
export function formatWeek(date: string | null): string {
|
export function formatWeek(date: string | null): string {
|
||||||
|
|||||||
@@ -6,11 +6,7 @@ import type {
|
|||||||
AggregatedTimeEntriesQueryParams,
|
AggregatedTimeEntriesQueryParams,
|
||||||
ReportingResponse,
|
ReportingResponse,
|
||||||
} from '@/packages/api/src';
|
} from '@/packages/api/src';
|
||||||
import {
|
import { getCurrentOrganizationId } from '@/utils/useUser';
|
||||||
getCurrentOrganizationId,
|
|
||||||
getCurrentRole,
|
|
||||||
getCurrentUser,
|
|
||||||
} from '@/utils/useUser';
|
|
||||||
import { useNotificationsStore } from '@/utils/notification';
|
import { useNotificationsStore } from '@/utils/notification';
|
||||||
import { useProjectsStore } from '@/utils/useProjects';
|
import { useProjectsStore } from '@/utils/useProjects';
|
||||||
import { useMembersStore } from '@/utils/useMembers';
|
import { useMembersStore } from '@/utils/useMembers';
|
||||||
@@ -110,9 +106,6 @@ export const useReportingStore = defineStore('reporting', () => {
|
|||||||
return projects.value.find((project) => project.id === key)?.name;
|
return projects.value.find((project) => project.id === key)?.name;
|
||||||
}
|
}
|
||||||
if (type === 'user') {
|
if (type === 'user') {
|
||||||
if (getCurrentRole() === 'employee') {
|
|
||||||
return getCurrentUser().name;
|
|
||||||
}
|
|
||||||
const memberStore = useMembersStore();
|
const memberStore = useMembersStore();
|
||||||
const { members } = storeToRefs(memberStore);
|
const { members } = storeToRefs(memberStore);
|
||||||
return members.value.find((member) => member.user_id === key)?.name;
|
return members.value.find((member) => member.user_id === key)?.name;
|
||||||
|
|||||||
@@ -10,10 +10,6 @@ function getCurrentUserId() {
|
|||||||
return page.props.auth.user.id;
|
return page.props.auth.user.id;
|
||||||
}
|
}
|
||||||
|
|
||||||
function getCurrentUser() {
|
|
||||||
return page.props.auth.user;
|
|
||||||
}
|
|
||||||
|
|
||||||
function getCurrentOrganizationId() {
|
function getCurrentOrganizationId() {
|
||||||
return page.props.auth.user.current_team_id;
|
return page.props.auth.user.current_team_id;
|
||||||
}
|
}
|
||||||
@@ -35,5 +31,4 @@ export {
|
|||||||
getCurrentUserId,
|
getCurrentUserId,
|
||||||
getCurrentMembershipId,
|
getCurrentMembershipId,
|
||||||
getCurrentRole,
|
getCurrentRole,
|
||||||
getCurrentUser,
|
|
||||||
};
|
};
|
||||||
|
|||||||
@@ -1,163 +0,0 @@
|
|||||||
<?php
|
|
||||||
|
|
||||||
declare(strict_types=1);
|
|
||||||
|
|
||||||
namespace Tests\Unit\Console\Commands\SelfHost;
|
|
||||||
|
|
||||||
use App\Console\Commands\SelfHost\SelfHostDatabaseConsistency;
|
|
||||||
use App\Enums\Role;
|
|
||||||
use App\Models\Client;
|
|
||||||
use App\Models\Organization;
|
|
||||||
use App\Models\Project;
|
|
||||||
use App\Models\Task;
|
|
||||||
use App\Models\TimeEntry;
|
|
||||||
use App\Models\User;
|
|
||||||
use Illuminate\Console\Command;
|
|
||||||
use Illuminate\Support\Facades\Artisan;
|
|
||||||
use PHPUnit\Framework\Attributes\CoversClass;
|
|
||||||
use PHPUnit\Framework\Attributes\UsesClass;
|
|
||||||
use Tests\TestCaseWithDatabase;
|
|
||||||
|
|
||||||
#[CoversClass(SelfHostDatabaseConsistency::class)]
|
|
||||||
#[UsesClass(SelfHostDatabaseConsistency::class)]
|
|
||||||
class SelfHostDatabaseConsistencyCommandTest extends TestCaseWithDatabase
|
|
||||||
{
|
|
||||||
public function test_checks_that_task_need_to_be_part_of_project_in_time_entries(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user = $this->createUserWithRole(Role::Owner);
|
|
||||||
$project1 = Project::factory()->forOrganization($user->organization)->create();
|
|
||||||
$project2 = Project::factory()->forOrganization($user->organization)->create();
|
|
||||||
$task = Task::factory()->forOrganization($user->organization)->forProject($project1)->create();
|
|
||||||
$timeEntry = TimeEntry::factory()->forMember($user->member)->forTask($task)->forProject($project2)->create();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Time entries have a task that does not belong to the project of the time entry\n - ".$timeEntry->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_checks_that_client_id_is_the_client_id_of_the_project(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user = $this->createUserWithRole(Role::Owner);
|
|
||||||
$client1 = Client::factory()->forOrganization($user->organization)->create();
|
|
||||||
$client2 = Client::factory()->forOrganization($user->organization)->create();
|
|
||||||
$project = Project::factory()->forOrganization($user->organization)->forClient($client1)->create();
|
|
||||||
$timeEntry = TimeEntry::factory()->forMember($user->member)->forProject($project)->create([
|
|
||||||
'client_id' => $client2->id,
|
|
||||||
]);
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Time entries have a client that does not match the client of the project\n - ".$timeEntry->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_checks_that_client_id_is_the_client_id_of_the_project_with_no_client_in_time_entry(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user = $this->createUserWithRole(Role::Owner);
|
|
||||||
$client1 = Client::factory()->forOrganization($user->organization)->create();
|
|
||||||
$client2 = Client::factory()->forOrganization($user->organization)->create();
|
|
||||||
$project = Project::factory()->forOrganization($user->organization)->forClient($client1)->create();
|
|
||||||
$timeEntry = TimeEntry::factory()->forMember($user->member)->forProject($project)->create([
|
|
||||||
'client_id' => null,
|
|
||||||
]);
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Time entries have a client that does not match the client of the project\n - ".$timeEntry->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_checks_that_client_id_is_only_null_if_project_is_also_null(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user = $this->createUserWithRole(Role::Owner);
|
|
||||||
$client1 = Client::factory()->forOrganization($user->organization)->create();
|
|
||||||
$project = Project::factory()->forOrganization($user->organization)->forClient($client1)->create();
|
|
||||||
$timeEntry = TimeEntry::factory()->forMember($user->member)->create([
|
|
||||||
'client_id' => $client1->getKey(),
|
|
||||||
]);
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Time entries have a client but no project\n - ".$timeEntry->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_checks_that_every_user_needs_to_be_a_member_of_at_least_one_organization(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user = User::factory()->create();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Users are not member of any organization\n - ".$user->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_checks_that_every_organization_needs_at_least_an_owner(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user = $this->createUserWithRole(Role::Owner);
|
|
||||||
$organization = Organization::factory()->withOwner($user->user)->create();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Organizations without an owner\n - ".$organization->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_checks_that_every_member_can_only_have_one_running_time_entry(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user = $this->createUserWithRole(Role::Owner);
|
|
||||||
$timeEntry1 = TimeEntry::factory()->forMember($user->member)->active()->create();
|
|
||||||
$timeEntry2 = TimeEntry::factory()->forMember($user->member)->active()->create();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Users with more than one running time entry\n - ".$user->user->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_checks_that_users_have_a_current_organization_that_they_are_not_a_member_of(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$user1 = $this->createUserWithRole(Role::Owner);
|
|
||||||
$user2 = $this->createUserWithRole(Role::Owner);
|
|
||||||
$user1->user->currentOrganization()->associate($user2->organization);
|
|
||||||
$user1->user->save();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$exitCode = $this->withoutMockingConsoleOutput()->artisan('self-host:database-consistency');
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertSame(Command::FAILURE, $exitCode);
|
|
||||||
$output = Artisan::output();
|
|
||||||
$this->assertSame("Consistency problem: Users have a current organization that they are not a member of\n - ".$user1->user->getKey()."\n", $output);
|
|
||||||
}
|
|
||||||
}
|
|
||||||
@@ -150,24 +150,6 @@ class DeletionServiceTest extends TestCaseWithDatabase
|
|||||||
$this->assertSame($specialCase ? 7 : 6, TimeEntry::query()->whereBelongsTo($organization, 'organization')->count());
|
$this->assertSame($specialCase ? 7 : 6, TimeEntry::query()->whereBelongsTo($organization, 'organization')->count());
|
||||||
}
|
}
|
||||||
|
|
||||||
public function test_delete_organization_resets_the_current_organization_of_users_that_had_the_deleted_organization_as_current_organization(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$userOwner = User::factory()->create();
|
|
||||||
$organization = Organization::factory()->withOwner($userOwner)->create();
|
|
||||||
$userOwner->currentOrganization()->associate($organization);
|
|
||||||
$userOwner->save();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$this->deletionService->deleteOrganization($organization);
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$this->assertOrganizationDeleted($organization);
|
|
||||||
$userOwner->refresh();
|
|
||||||
$this->assertNull($userOwner->current_team_id);
|
|
||||||
$this->assertNotSame($organization->id, $userOwner->current_team_id);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_delete_organization_deletes_all_resources_of_the_organization_but_does_not_delete_other_resources(): void
|
public function test_delete_organization_deletes_all_resources_of_the_organization_but_does_not_delete_other_resources(): void
|
||||||
{
|
{
|
||||||
// Arrange
|
// Arrange
|
||||||
|
|||||||
@@ -114,41 +114,6 @@ class MemberServiceTest extends TestCaseWithDatabase
|
|||||||
$this->assertSame(1, $otherUser->organizations()->count());
|
$this->assertSame(1, $otherUser->organizations()->count());
|
||||||
}
|
}
|
||||||
|
|
||||||
public function test_make_member_to_placeholder_resets_current_organization_of_user_if_user_is_no_longer_member_to_newly_created_organization(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$organization = Organization::factory()->create();
|
|
||||||
$user = User::factory()->forCurrentOrganization($organization)->create();
|
|
||||||
$member = Member::factory()->forOrganization($organization)->forUser($user)->role(Role::Employee)->create();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$this->memberService->makeMemberToPlaceholder($member);
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$user->refresh();
|
|
||||||
$this->assertNotNull($user->current_team_id);
|
|
||||||
$this->assertNotSame($organization->id, $user->current_team_id);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_make_member_to_placeholder_resets_current_organization_of_user_if_user_is_no_longer_member_to_already_existing_other_organization(): void
|
|
||||||
{
|
|
||||||
// Arrange
|
|
||||||
$organization = Organization::factory()->create();
|
|
||||||
$user = User::factory()->forCurrentOrganization($organization)->create();
|
|
||||||
$member = Member::factory()->forOrganization($organization)->forUser($user)->role(Role::Employee)->create();
|
|
||||||
|
|
||||||
$otherOrganization = Organization::factory()->create();
|
|
||||||
$otherMember = Member::factory()->forOrganization($otherOrganization)->forUser($user)->role(Role::Employee)->create();
|
|
||||||
|
|
||||||
// Act
|
|
||||||
$this->memberService->makeMemberToPlaceholder($member);
|
|
||||||
|
|
||||||
// Assert
|
|
||||||
$user->refresh();
|
|
||||||
$this->assertNotNull($user->current_team_id);
|
|
||||||
$this->assertSame($otherOrganization->id, $user->current_team_id);
|
|
||||||
}
|
|
||||||
|
|
||||||
public function test_assign_organization_entities_to_different_member_without_any_entries(): void
|
public function test_assign_organization_entities_to_different_member_without_any_entries(): void
|
||||||
{
|
{
|
||||||
// Arrange
|
// Arrange
|
||||||
|
|||||||
Reference in New Issue
Block a user