Skip to content

Instantly share code, notes, and snippets.

View robzlabz's full-sized avatar
🐳
Working from home

Robbyn Rahmandaru robzlabz

🐳
Working from home
  • RobzLabz Software Technology
  • Yogyakarta, Indonesia
View GitHub Profile
@robzlabz
robzlabz / sidebar2.sql
Last active September 8, 2026 11:54
Motmaina ACP - RBAC Menus, Website Features & Permissions Seed (sidebar2.sql)
-- =============================================================================
-- Migration: Remove Legacy "Immediate Consultations" Menu (TF-887)
-- File: sidebar2.sql
--
-- Removes the legacy booking-log menu item (acp/consultations/immediateConsultations),
-- its RBAC menu-action mappings, and associated role permissions.
-- Safe and idempotent to execute multiple times.
-- =============================================================================
SET NAMES utf8mb4;
@robzlabz
robzlabz / sidebar.sql
Created September 8, 2026 11:30
Motmaina ACP - RBAC Menus, Website Features & Permissions Seed (stg-v2 to master)
-- =============================================================================
-- Migration: Add RBAC Menus, Website Features, Permissions, and Localization
-- Diff: stg-v2 compared to master (PR #1161)
--
-- This script contains all RBAC menus, website_features, rbac_menu_actions,
-- rbac_roles_permissions, and associated sidebar localizations introduced
-- in stg-v2. Idempotent (safe to run multiple times).
-- =============================================================================
SET NAMES utf8mb4;
@robzlabz
robzlabz / localization2.sql
Created September 8, 2026 10:02
Motmaina Website - Localization2 SQL (Complete, fully translated without placeholders, idempotent)
This file has been truncated, but you can view the full file.
-- Motmaina Localization Table SQL Migration (Complete & Cleaned)
-- Fully translated English & Arabic without any _en / _ar placeholders
-- Idempotent: INSERT if Key does not exist, and UPDATE if Key already exists.
SET NAMES utf8mb4;
INSERT INTO `localization` (`Key`, `String_en`, `String_ar`, `Created_at`)
SELECT '2', 'Password', 'كلمة المرور', '2020-04-20 04:14:30'
WHERE NOT EXISTS (SELECT 1 FROM `localization` WHERE `Key` = '2');
UPDATE `localization`
@robzlabz
robzlabz / localization.sql
Created September 8, 2026 08:29
Motmaina Website - Localization SQL export and Untranslated strings report
-- Localization table data export
-- Idempotent: only inserts if Key does not already exist
SET NAMES utf8mb4;
INSERT INTO `localization` (`Key`, `String_en`, `String_ar`, `Created_at`)
SELECT '2', 'Password', 'كلمة المرور', '2020-04-20 04:14:30'
WHERE NOT EXISTS (SELECT 1 FROM `localization` WHERE `Key` = '2');
INSERT INTO `localization` (`Key`, `String_en`, `String_ar`, `Created_at`)
@robzlabz
robzlabz / github-issue-soft-delete-user.svg
Created March 24, 2026 01:49
Attachment for nenen_core issue: soft delete user root failure
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
# ✅ The superior approach
version: '3.8'
services:
postgres:
image: postgres:15
ports:
- "5432:5432"
volumes:
- ./.temp/postgres:/var/lib/postgresql/data
environment:
# ❌ The traditional (problematic) way
version: '3.8'
services:
postgres:
image: postgres:15
volumes:
- postgres_data:/var/lib/postgresql/data # Where is this exactly?
environment:
POSTGRES_DB: myapp
POSTGRES_USER: admin
@robzlabz
robzlabz / install_laravel_svelte_inertia_vite.md
Last active December 15, 2024 14:47
Laravel + Svelte + Inertia + Vite

Install Laravel + Svelte + Inertia + Vite Right Way

Install Inertia Composer dependency

composer require inertiajs/inertia-laravel

Setup Middleware

php artisan inertia:middleware

@robzlabz
robzlabz / LivewireMedia.php
Created June 2, 2021 05:40
Spatie Media Library with Livewire Trait
<?php
namespace App\Traits;
trait LivewireMedia
{
public function addMediaTo($media, $collectionName)
{
$this->addMedia($media->getRealPath())
->usingName(pathinfo($media->getClientOriginalName(), PATHINFO_BASENAME))
const FunctionalComponent = () => {
React.useEffect(() => {
return () => {
console.log("dadaaaah");
};
}, []);
return <h1>Selamat tinggal</h1>;
};