-- Bhatt Enterprises — supplemental seed data
-- Run AFTER sql/install.sql on database: bhatt_enterprise (or your DB name)
-- Usage: mysql -u root -p bhatt_enterprise < sql/seed.sql
-- Or from phpMyAdmin: select your database, then Import this file.

-- USE bhatt_enterprise;
-- This refreshes marketing/content tables; it does NOT remove admins or enquiry records.

SET NAMES utf8mb4;

-- ---------------------------------------------------------------------------
-- Site-wide settings (upsert)
-- ---------------------------------------------------------------------------
INSERT INTO site_settings (setting_key, setting_value) VALUES
('company_name', 'Bhatt Enterprises'),
('company_tagline', 'One-stop solution for all your solar power needs. Authorized partner of Tata Power Solar — Bilaspur, Chhattisgarh.'),
('phone', '8085548615'),
('phone_display', '+91 80855 48615'),
('email', 'info@bhattenterprise.in'),
('address', 'Shop No 03, Babji Park, Infront Of Haribhumi Press, Ring Road 2, Bilaspur-Chhattisgarh - 495001'),
('hours', 'Generally opens around 10:00 AM (call to confirm)'),
('map_embed', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3715.2!2d82.139!3d22.079!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zMjLCsDA0JzQ0LjQiTiA4MsKwMDgnMjAuNCJF!5e0!3m2!1sen!2sin!4v1'),
('home_about_title', 'Why choose Bhatt Enterprises?'),
('home_about_text', 'BHATT Enterprises specializes in delivering top-notch solar installation and comprehensive energy solutions tailored to illuminate your path to sustainable living. We are a trusted solar solutions provider in Bilaspur, Chhattisgarh — authorized as a partner for Tata Power Solar. Based on Ring Road 2, we specialize in residential and commercial solar panel installation, aiming to reduce electricity costs with reliable sustainable energy systems and high-quality mounting solutions.'),
('home_highlight_1', 'Best price & quality — Tata Power Solar authorized partner'),
('home_highlight_2', 'Solar inverters, solar panels & solar rooftop systems'),
('home_highlight_3', 'Free planning & consultation — call +91 70001 03302'),
('contact_intro', 'Solar Panel Installation Services — one-stop solution for all your solar power needs.

Primary contact (inquiries): +91 80855 48615
Free planning & consultation: +91 70001 03302

Shop: Shop No 03, Babji Park, Infront Of Haribhumi Press, Ring Road 2, Bilaspur-Chhattisgarh - 495001
Marketing office: Maharana Pratap Chowk, Near Raja hotel, Bilaspur, C.G.'),
('meta_description', 'Bhatt Enterprises — Solar rooftop, inverters & panels in Bilaspur, Chhattisgarh. Tata Power Solar partner. Ring Road 2. Call 8085548615. Free consultation +91 70001 03302.')
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value);

-- ---------------------------------------------------------------------------
-- Replace hero banners, services, projects, clients, team, testimonials, FAQ
-- (Keeps admin users and enquiry submissions intact.)
-- ---------------------------------------------------------------------------
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE banners;
TRUNCATE TABLE services;
TRUNCATE TABLE projects;
TRUNCATE TABLE clients;
TRUNCATE TABLE team_members;
TRUNCATE TABLE testimonials;
TRUNCATE TABLE faqs;
SET FOREIGN_KEY_CHECKS = 1;

INSERT INTO banners (title, subtitle, highlight_html, image_path, is_video, video_path, sort_order, is_active) VALUES
('Solar Power for', 'Residential and commercial rooftop systems — high-efficiency panels, inverters, and dependable mounting. Reduce electricity costs with a trusted Bilaspur team.', '<span class="theme-text1">Homes & Businesses</span>', 'assets/img/bg/cta-bg-1-1.jpg', 0, NULL, 1, 1),
('Authorized Partner —', 'Genuine Tata Power Solar products, professional installation, and support you can rely on.', '<span class="theme-text1">Tata Power Solar</span>', 'assets/img/bg/footer-bg-3-1.jpg', 0, NULL, 2, 1),
('Best Price & Quality', 'End-to-end solar panel installation, maintenance, and energy consultation — your one-stop solar partner on Ring Road 2.', '<span class="theme-text1">Bhatt Enterprises</span>', 'assets/img/bg/choose-bg-2-1.jpg', 0, NULL, 3, 1),
('Free Planning & Consultation', 'Speak with us about system sizing, savings, and net metering. Call +91 70001 03302 or reach us on +91 80855 48615.', '<span class="theme-text1">Talk to us today</span>', 'assets/img/bg/copyright-bg-3-1.jpg', 0, NULL, 4, 1);

INSERT INTO services (title, slug, short_description, full_description, icon_class, image_path, sort_order) VALUES
('End-to-end solar panel installation', 'end-to-end-solar-panel-installation',
 'Complete design, supply, and installation of rooftop solar for homes and businesses — from site survey to commissioning.',
 'We deliver turnkey solar projects including load assessment, system design, Tata Power Solar–compatible components, safe electrical work, and grid/net-metering coordination. Ideal for customers who want a single trusted partner on Ring Road 2 and across Bilaspur.',
 'flaticon-solar-panel', 'assets/img/about/ab-img-3-1.jpg', 1),

('Solar system maintenance & repair', 'solar-system-maintenance-repair',
 'Keep your plant performing with inspections, cleaning guidance, and fault repair for inverters and arrays.',
 'Scheduled health checks, string-level troubleshooting, inverter diagnostics, and preventive maintenance so your savings stay on track. We support systems we install and can advise on third-party plants where feasible.',
 'flaticon-thunderbolt', 'assets/img/about/ab-img-3-2.jpg', 2),

('Solar energy consultation & planning', 'solar-energy-consultation-planning',
 'Free planning discussion — system sizing, savings outlook, and the right mix of panels and inverter for your roof.',
 'Our team explains tariff impact, payback considerations, and structural fitment before you commit. Contact +91 70001 03302 for consultation; main enquiries +91 80855 48615.',
 'flaticon-solar-system', 'assets/img/about/ab-v-img.jpg', 3),

('Solar inverters & power electronics', 'solar-inverters-power-electronics',
 'String and hybrid inverter options matched to your load and grid rules for safe, efficient operation.',
 'We help you choose inverter capacity, phase configuration, and protection features aligned with Chhattisgarh DISCOM requirements and manufacturer warranties.',
 'flaticon-thunderbolt', 'assets/img/about/ab-img-3-1.jpg', 4),

('Solar panels & high-efficiency modules', 'solar-panels-high-efficiency-modules',
 'Quality PV modules selected for performance and longevity in local weather conditions.',
 'As an authorized Tata Power Solar partner, we focus on genuine products and correct pairing with inverters and mounting for maximum lifetime yield.',
 'flaticon-solar-panel', 'assets/img/about/ab-img-3-2.jpg', 5),

('Solar rooftop systems (residential & commercial)', 'solar-rooftop-systems-residential-commercial',
 'Structured mounting, waterproofing awareness, and documentation support for residential and C&I rooftops.',
 'Engineered mounting solutions for RCC, sheet, or tile roofs with attention to wind loads and long-term safety — backed by clear project documentation.',
 'flaticon-solar-system', 'assets/img/about/ab-v-img.jpg', 6);

INSERT INTO projects (title, slug, description, image_path, category, sort_order) VALUES
('Residential rooftop — Bilaspur (5 kW)', 'residential-rooftop-bilaspur-5kw',
 'Grid-connected residential rooftop with net metering focus; reduced monthly bills for the homeowner.',
 'assets/img/bg/copyright-bg-3-1.jpg', 'Residential', 1),
('Commercial office — local business', 'commercial-office-bilaspur',
 'Daytime load matched with rooftop PV to cut operating costs; structured mounting on sheet roof.',
 'assets/img/bg/case-study-bg.png', 'Commercial', 2),
('Industrial shed — high-capacity array', 'industrial-shed-solar-array',
 'Large-format installation with robust mounting and cable management for industrial shed roof.',
 'assets/img/bg/about-bg-3-1.png', 'Industrial', 3),
('Shop & retail — Ring Road 2 vicinity', 'shop-retail-ring-road-2',
 'Compact commercial system optimized for single-phase loads and quick ROI discussion with the owner.',
 'assets/img/bg/choose-bg-2-1.jpg', 'Commercial', 4);

INSERT INTO clients (name, logo_path, website_url, sort_order) VALUES
('Tata Power Solar', '', 'https://www.tatapowersolar.com/', 1),
('Bhatt Enterprises', '', '', 2),
('Residential & commercial customers — Bilaspur', 'assets/img/about/ab-img-3-1.jpg', '', 3),
('Tata Power Solar Rooftop solutions', '', 'https://www.tatapowersolar.com/', 4);

INSERT INTO team_members (name, designation, bio, image_path, sort_order) VALUES
('Project & design lead', 'Solar design & site assessment', 'Plans system capacity, roof suitability, and documentation for net metering and safe execution.', 'assets/img/about/ab-user-1-1.png', 1),
('Installation supervisor', 'On-site execution', 'Coordinates mounting, DC/AC wiring, and commissioning with quality checks at every stage.', 'assets/img/about/ab-user-1-1.png', 2),
('Customer & consultation', 'Planning & after-sales', 'Helps you understand savings, timelines, and maintenance — reachable for consultation queries.', 'assets/img/about/ab-user-1-1.png', 3);

INSERT INTO testimonials (client_name, content, rating, sort_order) VALUES
('Homeowner, Bilaspur', 'Bhatt Enterprises explained the savings clearly and completed our rooftop system professionally. We are happy with the support from a Tata Power Solar partner.', 5, 1),
('Retail business, Bilaspur', 'Good coordination from survey to commissioning. Our electricity costs have come down as promised.', 5, 2),
('Industrial unit, Chhattisgarh', 'Structured installation on our shed roof. Team was responsive during testing and handover.', 5, 3);

INSERT INTO faqs (question, answer, sort_order) VALUES
('Are you an authorized Tata Power Solar partner?', 'Yes. Bhatt Enterprises is an authorized partner for Tata Power Solar, offering genuine products and supported installations in Bilaspur and nearby areas.', 1),
('What are your main services?', 'We provide end-to-end solar panel installation, solar system maintenance and repair, solar energy consultation and planning, plus solar inverters, panels, and rooftop systems for residential and commercial properties.', 2),
('Where are you located?', 'Shop No 03, Babji Park, Infront Of Haribhumi Press, Ring Road 2, Bilaspur-Chhattisgarh - 495001. We also mention a marketing office at Maharana Pratap Chowk, Near Raja hotel, Bilaspur, C.G. — call to confirm the best point of contact for your visit.', 3),
('How can I reach you for consultation?', 'Main inquiries: +91 80855 48615. Free planning & consultation: +91 70001 03302. Hours: generally from around 10:00 AM — please call ahead.', 4),
('Do you offer maintenance after installation?', 'Yes. We provide maintenance and repair services to keep your inverter and array performing well, including inspections and fault support.', 5),
('Do solar panels work on cloudy days?', 'They still produce power, but at lower output than on clear sunny days. Annual generation estimates account for local weather.', 6),
('What makes Bhatt Enterprises different?', 'We focus on best price & quality balance, free planning and consultation options, and full-service support as your one-stop solar partner.', 7);

INSERT INTO static_pages (slug, title, body) VALUES
('terms', 'Terms & Conditions',
'<p>These terms apply to use of this website and to quotations and services provided by <strong>Bhatt Enterprises</strong>, a solar solutions provider in Bilaspur, Chhattisgarh, authorized as a partner for Tata Power Solar.</p>
<p><strong>Quotations</strong> — Valid only for the period stated. Prices may vary with component costs, policy changes, or site-specific requirements.</p>
<p><strong>Projects</strong> — Installation and product warranties are as per manufacturer and as set out in your written project agreement.</p>
<p><strong>Addresses</strong> — Primary shop: Shop No 03, Babji Park, Infront Of Haribhumi Press, Ring Road 2, Bilaspur-Chhattisgarh - 495001. Marketing office may be listed separately; please confirm appointment by phone.</p>'),
('privacy', 'Privacy Policy',
'<p><strong>Bhatt Enterprises</strong> respects your privacy. Information you submit through contact forms or phone is used to respond to enquiries, provide quotations, and deliver solar-related services.</p>
<p>We do not sell your personal data. Technical data may be collected by hosting or analytics services as per standard web practices.</p>
<p>For questions about your data, contact us using the phone numbers published on the contact page.</p>')
ON DUPLICATE KEY UPDATE title = VALUES(title), body = VALUES(body);
