ניהול תורים

נדרשת התקנה חד-פעמית

מסד הנתונים עוד לא מוכן לצוות. לחץ "העתק", ואז ב-Supabase: SQL Editor ← New query ← הדבק ← Run. אחר כך רענן את הדף.

-- התקנה מלאה (בטוח להריץ שוב ושוב)
create table if not exists staff (
  email text primary key,
  name text not null,
  whatsapp text,
  role text not null default 'barber',
  is_barber boolean not null default true,
  active boolean not null default true
);
alter table staff add column if not exists email text;
alter table staff add column if not exists name text;
alter table staff add column if not exists whatsapp text;
alter table staff add column if not exists role text not null default 'barber';
alter table staff add column if not exists is_barber boolean not null default true;
alter table staff add column if not exists active boolean not null default true;
create unique index if not exists staff_email_key on staff (email);
alter table staff drop constraint if exists staff_role_check;
alter table staff add constraint staff_role_check check (role in ('owner','manager','barber'));
alter table staff enable row level security;

create or replace function is_owner() returns boolean language sql security definer set search_path = public as $$
  select exists (select 1 from staff where email = lower(auth.jwt()->>'email') and role = 'owner' and active)
$$;
create or replace function is_manager() returns boolean language sql security definer set search_path = public as $$
  select exists (select 1 from staff where email = lower(auth.jwt()->>'email') and role in ('owner','manager') and active)
$$;
create or replace function is_staff() returns boolean language sql security definer set search_path = public as $$
  select not exists (select 1 from staff)
    or exists (select 1 from staff where email = lower(auth.jwt()->>'email') and active)
$$;
create or replace function can_see(b text) returns boolean language sql security definer set search_path = public as $$
  select not exists (select 1 from staff)
    or exists (select 1 from staff where email = lower(auth.jwt()->>'email') and active
               and (role in ('owner','manager') or name = b))
$$;
create or replace function has_staff() returns boolean language sql security definer set search_path = public as $$
  select exists (select 1 from staff)
$$;
grant execute on function has_staff() to authenticated;

drop policy if exists "staff can read staff" on staff;
drop policy if exists "staff read own or all" on staff;
drop policy if exists "manager writes staff" on staff;
create policy "staff read own or all" on staff for select to authenticated
  using (is_manager() or email = lower(auth.jwt()->>'email') or not has_staff());
create policy "manager writes staff" on staff for all to authenticated
  using (is_owner() or (is_manager() and role = 'barber'))
  with check (is_owner() or (is_manager() and role = 'barber') or not has_staff());

create or replace function public_barbers() returns table(name text, whatsapp text)
language sql security definer set search_path = public as $$
  select name, whatsapp from staff where active and is_barber order by name
$$;
grant execute on function public_barbers() to anon, authenticated;

create table if not exists waitlist (
  id uuid primary key default gen_random_uuid(),
  barber text not null default 'any',
  date date not null,
  from_min int not null,
  to_min int not null,
  name text not null,
  phone text not null,
  notified boolean not null default false,
  created_at timestamptz default now()
);
alter table waitlist add column if not exists id uuid default gen_random_uuid();
alter table waitlist add column if not exists barber text not null default 'any';
alter table waitlist add column if not exists date date;
alter table waitlist add column if not exists from_min int;
alter table waitlist add column if not exists to_min int;
alter table waitlist add column if not exists name text;
alter table waitlist add column if not exists phone text;
alter table waitlist add column if not exists notified boolean not null default false;
alter table waitlist add column if not exists created_at timestamptz default now();
alter table waitlist enable row level security;
drop policy if exists "public can join waitlist" on waitlist;
drop policy if exists "staff manage waitlist" on waitlist;
create policy "public can join waitlist" on waitlist for insert to anon with check (notified = false);
create policy "staff manage waitlist" on waitlist for all to authenticated
  using (is_staff() and (barber = 'any' or can_see(barber)))
  with check (is_staff() and (barber = 'any' or can_see(barber)));

drop policy if exists "staff full access" on bookings;
create policy "staff full access" on bookings for all to authenticated
  using (can_see(barber)) with check (can_see(barber));

drop policy if exists "staff manage schedule" on schedule;
create policy "staff manage schedule" on schedule for all to authenticated
  using (can_see(barber)) with check (can_see(barber));

התקן כאפליקציה במסך הבית

תאריך

הוספת לקוח שהגיע למספרה

ספר

שירות

שעה

שם (לא חובה)

כל התורים הקרובים

תזכורות ללקוחות

תאריך התורים

רשימת המתנה

חסימת זמן או חופשה

ספר

מתאריך

משעה

עד תאריך

עד שעה

בלי לבחור שעות: חוסם ימים שלמים. אפשר לחסום שעות באמצע יום, או חופשה של כמה ימים.

ימי ושעות העבודה

ספר

סיכום החודש

0תורים

0שעות

0הכנסה (₪)

לקוחות קבועים

צוות המספרה

הוספת ספר

שם

וואטסאפ

שם משתמש (אימייל)

סיסמה (6 תווים לפחות)

תפקיד

מופיע ללקוחות כספר