Ronald ronaldaug

Column	Type
`id`	PK
`user_id`	`uuid` (from Supabase Auth)

| Column | Type |

CUnit

The below example shows calculating cigaratte, pack, cartoon and box. You can add any units to data_array and calculate among units.

const data_array = [
  {
    unit: "cigaratte",

Create a file call auth.php with below codes.
Require at the top of the page you want to protect like require_once("auth.php");;
Done.

<?php

const { stdin, stdout } = process;

// Prompt function
function prompt(question) {
  return new Promise((resolve, reject) => {
    stdin.resume();

Upload via Javascript (AJAX)

HTML

<input type="file" name="myFile" id="myFile">
      <button class="upload">Upload</button><br>

Create index.html , sidebar.html and footer.html

    <sidebar class="partial"></sidebar>

    <footer class="partial"></footer>

	-- Read
	create policy "Allow authorized read access"
	on leaves for select
	to authenticated
	using (authorize('leaves.read'));

	-- Create
	create policy "Allow authorized create access"
	on leaves for insert
	to authenticated

	create or replace function authorize(resource_action text) returns boolean as $$
	declare
	v_user_id uuid;
	v_role_id int;
	v_resource text;
	v_action text;
	v_has_permission boolean := false;
	v_is_admin boolean := false;
	begin
	-- Get current user's ID from Supabase Auth

	-- Table: leaves
	create policy "admin can delete" on leaves for delete using (...);
	create policy "manager can update" on leaves for update using (...);
	create policy "employee can read" on leaves for select using (...);