Project Builder Dashboard

Build, Manage & Complete Projects Step by Step

158

Total Folders

279

Total Files

100%

Completion Progress

0

Missing Files

42

Database Tables

Project Root Path
Project Progress Overview
Project Root Path Progress Files Missing Quality
Current Project /home/bachlntm/public_html/safdev
100% Completed
279 0 Excellent
Create Required Project Structure

This will create the standard SAF DEV / Housing ERP folders and files if missing.

Quick Actions
Create File
Create Folder
Code Editor
Database Builder
Builder Tips
  • First set correct project root.
  • Generate required structure.
  • Create missing files.
  • Paste code in editor.
  • Save and check progress.
Create File Instantly
Create Folder Instantly
Missing Required Files
index.php
dashboard.php
includes/db_connect.php
includes/auth.php
includes/functions.php
includes/header.php
includes/footer.php
includes/sidebar.php
assets/css/style.css
assets/css/responsive.css
assets/js/app.js
modules/dashboard/index.php
modules/members/index.php
modules/properties/index.php
modules/sales/index.php
modules/sales/create_sale.php
modules/sales/sale_list.php
modules/sales/sale_detail.php
modules/accounting/index.php
modules/billing/index.php
modules/maintenance/index.php
modules/complaints/index.php
modules/visitors/index.php
modules/reports/index.php
Project File Structure
saas_platform.php (22,881 bytes)
services.php (68,930 bytes)
pricing.php (19,144 bytes)
ai_solutions.php (22,582 bytes)
database
modules
modules/properties
modules/accounting
modules/dashboard
modules/ledger
modules/complaints
modules/receipts
modules/reports
modules/maintenance
modules/plots
modules/installments
modules/billing
modules/settings
modules/visitors
modules/customers
modules/sales
modules/members
admin
api
saas
saas/login.php (1,911 bytes)
saas/register.php (3,450 bytes)
saas/admin
saas/support.php (2,056 bytes)
saas/logs
saas/plans.php (8,200 bytes)
saas/includes
saas/index.php (21,194 bytes)
saas/support
saas/uploads
saas/billing
saas/tenant
addons.php (21,458 bytes)
ads_hub
ads_hub/repair.php (9,402 bytes)
ads_hub/error_log (5,476 bytes)
ads_hub/index.php (22,914 bytes)
ads_hub/uploads
ads_hub/uploads/logos
ads_hub/clients.php (13,899 bytes)
includes
includes/footer.php (2,324 bytes)
includes/header.php (2,592 bytes)
assets
assets/cs (17,040 bytes)
assets/portfolio
assets/js
assets/js/backup_20260521_195918
assets/js/backup_20260521_203752
assets/js/main.js (2,923 bytes)
assets/js/backup_20260521_203757
assets/images
assets/uploads
assets/css
assets/css/style.css (45,076 bytes)
assets/css/backup_20260521_200918
assets/css/backup_20260521_195918
assets/css/backup_final_20260521_204447
assets/css/backup_20260521_195219
assets/css/backup_20260521_195213
assets/css/backup_20260521_203752
assets/css/backup_20260521_201958
assets/css/backup_20260521_201327
assets/css/backup_20260521_202754
assets/css/backup_20260521_203757
dashboard.php (37 bytes)
project_builder.php (44,866 bytes)
case_studies.php (9,093 bytes)
erp_blueprint.php (78,013 bytes)
index.php (77,816 bytes)
quotation_builder
quotation_builder/includes
quotation_builder/assets
quotation_builder/assets/css
quotation_builder/print
final.php (4,972 bytes)
service_detail.php (33,753 bytes)
contact.php (26,933 bytes)
about.php (9,124 bytes)
indexx.php (80,327 bytes)
portfolio.php (22,146 bytes)
industries.php (9,573 bytes)
project_builder2.php (54,474 bytes)
Code Editor
Edit selected project file directly
assets/images/logo-riyadh.svg
Database Builder (Schema Doctor)

42

Total Tables

352

Total Columns

88%

Schema Health

58

Possible Missing Tables

Create Database Table
Add Column to Table
Database Tables & Columns
Table Name Total Columns View Structure
saas_activity_logs 6
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 user_id bigint(20) YES
4 activity text YES
5 ip_address varchar(100) YES
6 created_at timestamp YES current_timestamp()
saas_ai_usage 7
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 user_id bigint(20) YES
4 ai_module varchar(100) YES
5 prompt_tokens int(11) YES 0
6 response_tokens int(11) YES 0
7 created_at timestamp YES current_timestamp()
saas_api_keys 5
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 api_name varchar(100) YES
4 api_key text YES
5 status enum('active','inactive') YES active
saas_databases 6
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) NO
3 database_name varchar(255) NO
4 database_mode enum('shared','dedicated') YES shared
5 host_name varchar(255) YES
6 created_at timestamp YES current_timestamp()
saas_invoices 9
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 invoice_no varchar(100) YES
4 invoice_date date YES
5 due_date date YES
6 total_amount decimal(15,2) YES 0.00
7 paid_amount decimal(15,2) YES 0.00
8 status enum('unpaid','partial','paid') YES unpaid
9 created_at timestamp YES current_timestamp()
saas_notifications 6
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 title varchar(255) YES
4 message text YES
5 is_read tinyint(4) YES 0
6 created_at timestamp YES current_timestamp()
saas_payments 8
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 invoice_id bigint(20) YES
4 payment_date date YES
5 amount decimal(15,2) YES
6 payment_method varchar(100) YES
7 transaction_reference varchar(255) YES
8 created_at timestamp YES current_timestamp()
saas_permissions 3
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 permission_code varchar(150) YES
3 permission_name varchar(255) YES
saas_plans 8
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 plan_name varchar(150) YES
3 monthly_price decimal(15,2) YES 0.00
4 yearly_price decimal(15,2) YES 0.00
5 max_users int(11) YES 1
6 max_storage_gb int(11) YES 1
7 ai_credits int(11) YES 0
8 status enum('active','inactive') YES active
saas_role_permissions 3
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 role_id bigint(20) YES
3 permission_id bigint(20) YES
saas_roles 4
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 role_name varchar(100) YES
4 description text YES
saas_subscriptions 7
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 plan_id bigint(20) YES
4 start_date date YES
5 end_date date YES
6 billing_cycle enum('monthly','yearly') YES monthly
7 status enum('trial','active','expired','cancelled') YES trial
saas_tenants 11
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_code varchar(50) YES UNI
3 company_name varchar(255) NO
4 contact_person varchar(255) YES
5 email varchar(255) YES
6 phone varchar(50) YES
7 database_mode enum('shared','dedicated') YES shared
8 database_name varchar(255) YES
9 plan_id bigint(20) YES
10 status enum('trial','active','suspended','expired') YES trial
11 created_at timestamp YES current_timestamp()
saas_tickets 8
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) YES
3 subject varchar(255) YES
4 message text YES
5 priority enum('low','medium','high','critical') YES medium
6 status enum('open','pending','resolved','closed') YES open
7 created_by bigint(20) YES
8 created_at timestamp YES current_timestamp()
saas_users 10
# Column Type Null Key Default Extra
1 id bigint(20) NO PRI auto_increment
2 tenant_id bigint(20) NO MUL 0
3 full_name varchar(255) YES
4 email varchar(255) YES
5 password_hash varchar(255) YES
6 role_id bigint(20) YES
7 user_type enum('super_admin','tenant_admin','tenant_user') YES tenant_user
8 status enum('active','inactive') YES active
9 last_login datetime YES
10 created_at timestamp YES current_timestamp()
saf_ad_campaigns 12
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 client_id int(11) NO MUL
3 campaign_title varchar(180) NO
4 platform enum('Facebook','TikTok','YouTube','Google','WhatsApp','Multi Platform') YES Facebook
5 objective varchar(120) YES
6 daily_budget decimal(12,2) YES 0.00
7 total_budget decimal(12,2) YES 0.00
8 start_date date YES
9 end_date date YES
10 status enum('draft','ready','running','paused','completed') YES draft
11 campaign_notes text YES
12 created_at timestamp YES current_timestamp()
saf_ad_clients 11
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 business_name varchar(180) NO
3 contact_person varchar(120) YES
4 phone varchar(50) NO
5 whatsapp varchar(50) YES
6 email varchar(150) YES
7 city varchar(100) YES
8 business_type varchar(120) YES
9 notes text YES
10 status enum('new','active','paused','closed') YES new
11 created_at timestamp YES current_timestamp()
saf_ad_leads 9
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 client_name varchar(180) NO
3 client_phone varchar(60) NO
4 service_type varchar(120) NO
5 budget varchar(100) YES
6 details text YES
7 lead_source varchar(80) YES Website
8 status enum('new','contacted','converted','rejected') YES new
9 created_at timestamp YES current_timestamp()
saf_ad_templates 9
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 template_name varchar(180) NO
3 template_type varchar(80) YES brochure
4 company_name varchar(180) YES
5 design_style varchar(80) YES
6 language_mode varchar(40) YES
7 json_data longtext YES
8 preview_image varchar(255) YES
9 created_at timestamp YES current_timestamp()
saf_leads 22
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 name varchar(100) YES
3 phone varchar(50) YES
4 email varchar(100) YES
5 service_required varchar(150) YES
6 package_name varchar(190) YES
7 budget varchar(120) YES
8 timeline varchar(120) YES
9 message text YES
10 source_page varchar(120) YES pricing
11 status varchar(50) YES new
12 created_at timestamp YES current_timestamp()
13 company varchar(190) YES
14 whatsapp varchar(80) YES
15 industry varchar(120) YES
16 priority_level varchar(80) YES Normal
17 lead_score int(11) YES 0
18 lead_status varchar(80) YES New
19 designation varchar(120) YES
20 consultation_type varchar(120) YES
21 preferred_date date YES
22 preferred_time varchar(80) YES
saf_media 7
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 title varchar(255) YES
3 file_name varchar(255) NO
4 file_path varchar(255) NO
5 mime_type varchar(100) YES
6 file_size bigint(20) YES 0
7 created_at timestamp YES current_timestamp()
saf_monthly_services 10
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 title varchar(190) NO
3 description text YES
4 icon varchar(80) YES fa-headset
5 monthly_price varchar(120) YES
6 price_amount decimal(12,2) YES 0.00
7 currency varchar(20) YES USD
8 status varchar(30) YES active
9 sort_order int(11) YES 0
10 created_at timestamp YES current_timestamp()
saf_package_addons 10
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 addon_title varchar(190) NO
3 addon_text text YES
4 icon varchar(80) YES fa-plus
5 price varchar(120) YES
6 price_amount decimal(12,2) YES 0.00
7 currency varchar(20) YES USD
8 status varchar(30) YES active
9 sort_order int(11) YES 0
10 created_at timestamp YES current_timestamp()
saf_package_features 4
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 package_id int(11) YES
3 feature_text varchar(255) YES
4 sort_order int(11) YES 0
saf_packages 12
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 name varchar(100) YES
3 subtitle varchar(100) YES
4 price varchar(50) YES
5 price_amount decimal(12,2) YES 0.00
6 currency varchar(20) YES USD
7 is_featured tinyint(4) YES 0
8 sort_order int(11) YES 0
9 status enum('active','inactive') YES active
10 badge varchar(80) YES
11 icon varchar(80) YES fa-box
12 short_note varchar(255) YES
saf_portfolio 15
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 title varchar(190) NO
3 category varchar(100) YES ERP
4 industry varchar(120) YES Business
5 short_desc text YES
6 challenge text YES
7 solution text YES
8 result_text text YES
9 tech_stack varchar(255) YES PHP, MySQL, Bootstrap, AI
10 impact varchar(190) YES Manual work reduced by 70%
11 completion_percent int(11) YES 100
12 icon varchar(80) YES fa-desktop
13 status varchar(40) YES active
14 sort_order int(11) YES 0
15 created_at timestamp YES current_timestamp()
saf_portfolio_images 8
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 portfolio_id int(11) NO
3 image_title varchar(190) YES
4 image_path varchar(255) NO
5 image_type varchar(80) YES dashboard
6 status varchar(40) YES active
7 sort_order int(11) YES 0
8 created_at timestamp YES current_timestamp()
saf_portfolio_metrics 5
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 portfolio_id int(11) NO
3 metric_label varchar(160) NO
4 metric_value varchar(80) NO
5 sort_order int(11) YES 0
saf_portfolio_modules 5
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 portfolio_id int(11) NO
3 module_name varchar(160) NO
4 icon varchar(80) YES fa-check
5 sort_order int(11) YES 0
saf_pricing_faqs 6
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 question varchar(255) NO
3 answer text YES
4 status varchar(30) YES active
5 sort_order int(11) YES 0
6 created_at timestamp YES current_timestamp()
saf_pricing_modules 11
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 module_title varchar(190) NO
3 module_text text YES
4 module_type varchar(80) YES ERP
5 icon varchar(120) YES fa-cubes
6 price_from varchar(120) YES
7 price_amount decimal(12,2) YES 0.00
8 currency varchar(20) YES USD
9 status varchar(30) YES active
10 sort_order int(11) YES 0
11 created_at timestamp YES current_timestamp()
saf_projects 10
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 title varchar(150) YES
3 category varchar(100) YES
4 image varchar(255) YES
5 project_url varchar(255) YES
6 description text YES
7 is_featured tinyint(4) YES 0
8 sort_order int(11) YES 0
9 status enum('active','inactive') YES active
10 created_at timestamp YES current_timestamp()
saf_reviews 7
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 client_name varchar(100) YES
3 client_role varchar(100) YES
4 review_text text YES
5 rating int(11) YES 5
6 status enum('active','inactive') YES active
7 created_at timestamp YES current_timestamp()
saf_service_addons 9
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 service_id int(11) NO MUL
3 addon_title varchar(190) NO
4 addon_text text YES
5 icon varchar(80) YES fa-plus
6 price_range varchar(120) YES
7 sort_order int(11) YES 0
8 status varchar(30) YES active
9 created_at timestamp YES current_timestamp()
saf_service_demos 8
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 service_id int(11) NO MUL
3 demo_title varchar(190) NO
4 demo_text text YES
5 demo_type varchar(80) YES dashboard
6 sort_order int(11) YES 0
7 status varchar(30) YES active
8 created_at timestamp YES current_timestamp()
saf_service_faqs 7
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 service_id int(11) NO MUL
3 question varchar(255) NO
4 answer text YES
5 sort_order int(11) YES 0
6 status varchar(30) YES active
7 created_at timestamp YES current_timestamp()
saf_service_features 8
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 service_id int(11) NO MUL
3 feature_title varchar(190) NO
4 feature_text text YES
5 icon varchar(80) YES fa-check
6 sort_order int(11) YES 0
7 status varchar(30) YES active
8 created_at timestamp YES current_timestamp()
saf_services 14
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 icon varchar(100) YES
3 short_summary varchar(255) YES
4 overview longtext YES
5 price_range varchar(120) YES
6 timeline varchar(120) YES
7 best_for varchar(255) YES
8 title varchar(150) YES
9 slug varchar(220) YES
10 category varchar(120) YES
11 description text YES
12 sort_order int(11) YES 0
13 status enum('active','inactive') YES active
14 created_at timestamp YES current_timestamp()
saf_settings 4
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 setting_key varchar(100) YES UNI
3 setting_value text YES
4 updated_at timestamp YES current_timestamp() on update current_timestamp()
saf_site_images 6
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 image_key varchar(100) NO UNI
3 title varchar(190) NO
4 file_path varchar(255) YES
5 alt_text varchar(255) YES
6 updated_at timestamp YES current_timestamp() on update current_timestamp()
saf_social_links 5
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 platform varchar(50) YES
3 icon varchar(100) YES
4 url varchar(255) YES
5 status enum('active','inactive') YES active
saf_visitors 17
# Column Type Null Key Default Extra
1 id int(11) NO PRI auto_increment
2 ip_address varchar(80) YES
3 user_agent text YES
4 page_url text YES
5 referrer text YES
6 source varchar(100) YES
7 session_id varchar(255) YES
8 screen_resolution varchar(100) YES
9 language varchar(50) YES
10 visit_duration int(11) YES
11 visit_date timestamp YES current_timestamp()
12 created_at timestamp YES current_timestamp()
13 country varchar(150) YES
14 city varchar(150) YES
15 browser varchar(100) YES
16 operating_system varchar(100) YES
17 device_type varchar(50) YES
SQL Generator
Recent Builder Activity
Activity Time
File created: /modules/sales/create_sale.php 2 min ago
Folder created: /modules/accounting/ 10 min ago
Database column added: plot_sales.installment_months 18 min ago
Code updated: /includes/functions.php 25 min ago