Welcome back, admin! 👋

Here's what's happening with your business today

admin System Administrator

🕒 Loading Time...

👛

Max ₹5L

ADMIN WALLET BALANCE

₹0.00

Available for distribution

👥

+0%

TOTAL MSOS

0

Active multi-system operators

🌐

+0%

TOTAL LCOS

0

Created by MSOs

📑

+0%

MSO WALLET SUM

₹0.00

Distributed funds

⚡ Quick Actions

👤+

Add MSO

👛

Recharge Wallet

Add funds via Cashfree (Max ₹5L)

👥

View MSO Data

Manage MSO business records & wallets

👤+

Add New MSO

Create a new Multi-System Operator account

ℹ️ Admin Balance: ₹0.00

Initial wallet amount will be deducted from admin balance

Name *

Company

Mobile Number (10 Digits) *

Password (Min 6 Characters) *

Initial Wallet (Max 5 Digits: ₹50,000) *

LCO Limit

← Back to Dashboard

👛 Admin Wallet (Max ₹5 Lakhs)

Manage central admin distribution funds (Capacity ceiling: ₹5,00,000).

🔍 MSO Instant Search & Fund Transfer

Type 10-digit Mobile Number to search and select MSO for Credit/Debit.

Search MSO by Mobile Number:

👥

MSO Data Management

Complete database of registered MSOs. Click 👛 to transfer funds instantly.

MSO ID	MOBILE / USERNAME	COMPANY	STATUS	WALLET BALANCE	WHOLESALE PACKAGE PRICES	LCO LIMIT	ACTIONS

🌐

LCO Network & Mandatory Aadhaar Approval Queue

Inspect uploaded Aadhaar Front/Back photos and approve LCO Cable Operator enrollments.

LCO ID	OPERATOR & MOBILE	ADDRESS / LOCATION	AADHAAR NUMBER	PARENT MSO	AADHAAR CARDS	STATUS	APPROVAL ACTIONS

🔄 Wallet & Billing Transactions

Complete audit log of all Credits, Debits, and Admin Recharges.

TXN ID	DATE & TIME	TYPE	MSO OPERATOR	AMOUNT (₹)	STATUS

📈 System Analytics Summary

NSV TV Admin System initialized. System ready for MSO and LCO onboarding.

📡

Live TV Channel Manager & Stream Links

Add, edit PNG logos, PHP/M3U8 live stream links, and manage channels displayed in TV App.

ORDER	CHANNEL LOGO	CHANNEL NAME	CATEGORY	PHP / M3U8 STREAM URL	STATUS	ACTIONS

⚡ Supabase Cloud Database Config

Connect your Supabase Cloud Database for 24/7 real-time multi-device database sync.

⚪ Local Database Active (Cloud Credentials Not Set)

📜 1-Click Supabase SQL Setup Script

Copy & paste this SQL script into your Supabase SQL Editor to create all 4 database tables automatically.

-- NSV TV IPTV SYSTEM SUPABASE SQL SETUP SCRIPT
-- 1. Create Subscribers Table
CREATE TABLE IF NOT EXISTS public.nsv_subscribers (
  username TEXT PRIMARY KEY,
  name TEXT,
  password TEXT,
  mobile TEXT,
  address TEXT,
  package TEXT,
  status TEXT DEFAULT 'ACTIVE',
  expiry_date TIMESTAMP WITH TIME ZONE,
  is_dual_device BOOLEAN DEFAULT false,
  lco_name TEXT,
  lco_mobile TEXT,
  lco_id TEXT,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- 2. Create MSO Accounts Table
CREATE TABLE IF NOT EXISTS public.nsv_mso_accounts (
  username TEXT PRIMARY KEY,
  id TEXT,
  company TEXT,
  password TEXT,
  balance NUMERIC DEFAULT 0,
  lco_limit INTEGER DEFAULT 10,
  package_prices JSONB,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- 3. Create LCO Accounts Table
CREATE TABLE IF NOT EXISTS public.nsv_lco_accounts (
  mobile TEXT PRIMARY KEY,
  id TEXT,
  name TEXT,
  password TEXT,
  address TEXT,
  aadhaar_number TEXT,
  wallet NUMERIC DEFAULT 0,
  status TEXT DEFAULT 'APPROVED',
  package_prices JSONB,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- 4. Create Master Transactions Audit Ledger Table
CREATE TABLE IF NOT EXISTS public.nsv_transactions (
  id TEXT PRIMARY KEY,
  date TEXT,
  type TEXT,
  operator TEXT,
  target TEXT,
  amount NUMERIC DEFAULT 0,
  status TEXT DEFAULT 'Success',
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- 5. Create Live TV Channels Table
CREATE TABLE IF NOT EXISTS public.nsv_channels (
  id TEXT PRIMARY KEY,
  name TEXT,
  category TEXT,
  logo_url TEXT,
  stream_url TEXT,
  status TEXT DEFAULT 'ACTIVE',
  order_index INTEGER DEFAULT 0,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- 6. Create Admin Credentials Table
CREATE TABLE IF NOT EXISTS public.nsv_admin_credentials (
  id SERIAL PRIMARY KEY,
  username TEXT NOT NULL DEFAULT 'admin',
  password TEXT NOT NULL DEFAULT 'admin12345',
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- Disable RLS so anonymous web clients can verify login
ALTER TABLE public.nsv_admin_credentials DISABLE ROW LEVEL SECURITY;

-- Upsert initial admin credentials row (id 1)
INSERT INTO public.nsv_admin_credentials (id, username, password)
VALUES (1, 'admin', 'admin12345')
ON CONFLICT (id) DO UPDATE SET password = EXCLUDED.password, username = EXCLUDED.username;

-- 7. Create Admin Login / Logout Audit Logs Table
CREATE TABLE IF NOT EXISTS public.nsv_admin_logs (
  id SERIAL PRIMARY KEY,
  event_type TEXT,
  username TEXT,
  timestamp TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  user_agent TEXT
);

-- Enable Realtime WebSockets for all tables
ALTER PUBLICATION supabase_realtime ADD TABLE public.nsv_subscribers;
ALTER PUBLICATION supabase_realtime ADD TABLE public.nsv_mso_accounts;
ALTER PUBLICATION supabase_realtime ADD TABLE public.nsv_lco_accounts;
ALTER PUBLICATION supabase_realtime ADD TABLE public.nsv_transactions;
ALTER PUBLICATION supabase_realtime ADD TABLE public.nsv_channels;
ALTER PUBLICATION supabase_realtime ADD TABLE public.nsv_admin_credentials;
ALTER PUBLICATION supabase_realtime ADD TABLE public.nsv_admin_logs;

📺

Master Subscribers Database & Management

Complete network-wide STB customer database. Search by Username, Mobile, LCO, MSO, or Address.

🔍

SUBSCRIBER NAME	USERNAME / MOBILE	ASSIGNED LCO OPERATOR	PACKAGE NAME	EXPIRY DATE	STATUS	ACTIONS

🌐 Global MSO Wholesale Rates

Set default wholesale package cost rates assigned to MSO Accounts.

🏢 Search & Set Individual MSO Wholesale Rates

Select an MSO by name or username to configure custom wholesale rates.

📡

Live TV Channels Catalog & Feeds (69+ Streams)

Manage 4K/HD live stream URLs, channel logos, EPG IDs, and categories in real-time.

#	LOGO	CHANNEL NAME	CATEGORY	QUALITY	EPG ID	STREAM URL	ACTIONS

Welcome back, admin! 👋

₹0.00

0

0

₹0.00

⚡ Quick Actions

Add MSO

Recharge Wallet

View MSO Data

Add New MSO

👛 Admin Wallet (Max ₹5 Lakhs)

₹0.00

🔍 MSO Instant Search & Fund Transfer

MSO Name

₹0.00

MSO Data Management

LCO Network & Mandatory Aadhaar Approval Queue

🔄 Wallet & Billing Transactions

📈 System Analytics Summary

Live TV Channel Manager & Stream Links

⚡ Supabase Cloud Database Config

📜 1-Click Supabase SQL Setup Script

Master Subscribers Database & Management

🌐 Global MSO Wholesale Rates

🏢 Search & Set Individual MSO Wholesale Rates

Live TV Channels Catalog & Feeds (69+ Streams)

📡 Add Live TV Channel

🔑 Change Admin Password

✏️ Edit MSO Account Details

🏷️ Set Individual MSO Package Wholesale Rates

👛 MSO Instant Fund Transfer

MSO Name

₹0.00

📇 Inspect LCO Aadhaar Verification Cards

📡 Add New Live TV Channel

NSV TV ADMIN PORTAL