-- Sample FAQs for Horizon Drilling Website
-- Run these INSERT statements to populate the faqs table

INSERT INTO faqs (question, answer, category, display_order, status) VALUES

-- General Questions
('How long does it take to drill a borehole?', 
 'The time required to drill a borehole depends on several factors including depth, geological conditions, and location accessibility. Typically, a standard residential borehole (50-100 meters) takes 3-7 days, while deeper commercial boreholes (100-300 meters) may take 1-3 weeks. We provide a detailed timeline during the initial consultation after site assessment.',
 'General', 
 1, 
 'active'),

('What is the cost of drilling a borehole?', 
 'Borehole drilling costs vary based on depth, geological conditions, equipment required, and location. Prices typically range from KES 800,000 to KES 3,000,000 for residential projects, and higher for commercial installations. We provide free site assessments and detailed quotations with no hidden costs. Contact us for a personalized quote based on your specific needs.',
 'General', 
 2, 
 'active'),

('Do I need a permit to drill a borehole?', 
 'Yes, in Kenya, you need a permit from the Water Resources Management Authority (WRMA) before drilling a borehole. We handle the entire permit application process on your behalf, including site surveys, documentation, and submission. This typically takes 2-4 weeks. We ensure all legal requirements are met before commencing any drilling work.',
 'General', 
 3, 
 'active'),

-- Drilling Questions
('How deep should my borehole be?', 
 'Borehole depth depends on your water requirements, geological conditions, and aquifer location. Our hydrogeological surveys identify the optimal depth for maximum yield. Residential boreholes typically range from 50-150 meters, while commercial projects may require 150-300 meters. We use advanced geophysical techniques to determine the best depth before drilling.',
 'Drilling', 
 4, 
 'active'),

('What happens if you don\'t find water?', 
 'While rare, if we don\'t encounter sufficient water during drilling, we conduct additional geophysical surveys at no extra cost to identify alternative locations. Our success rate is over 95% due to our comprehensive pre-drilling surveys. In the unlikely event of no water, we only charge for the survey work completed, not the full drilling cost.',
 'Drilling', 
 5, 
 'active'),

('What type of casing do you use?', 
 'We use high-quality PVC or steel casing depending on geological conditions and depth requirements. PVC casing (Class 6 or higher) is standard for most residential boreholes due to its durability and corrosion resistance. Steel casing is used for deeper commercial boreholes or in challenging geological formations. All materials meet Kenyan water quality standards.',
 'Drilling', 
 6, 
 'active'),

('How do you ensure water quality?', 
 'We conduct comprehensive water quality testing after drilling, analyzing for pH, turbidity, bacteria, minerals, and chemical contaminants. If treatment is needed, we recommend appropriate filtration systems. We provide water quality reports and can install purification systems to ensure safe drinking water. Regular testing is recommended annually.',
 'Drilling', 
 7, 
 'active'),

-- Solar Questions
('How much can I save with a solar pump system?', 
 'Solar pump systems eliminate electricity costs completely, saving you 100% on pump operation expenses. For a typical residential system, this translates to KES 3,000-8,000 monthly savings. Commercial systems can save KES 50,000-200,000+ monthly. The system typically pays for itself within 3-5 years, with 20+ years of free operation thereafter.',
 'Solar', 
 8, 
 'active'),

('Do solar pumps work during cloudy days?', 
 'Yes, modern solar pump systems include battery backup and smart controllers that store energy for use during cloudy periods or at night. High-efficiency panels can generate power even in overcast conditions. For critical applications, we design systems with sufficient battery capacity to ensure continuous operation for 2-3 days without sunlight.',
 'Solar', 
 9, 
 'active'),

('What maintenance do solar systems require?', 
 'Solar pump systems require minimal maintenance. Panels should be cleaned quarterly, batteries checked annually, and pump serviced every 2-3 years. We provide maintenance packages and remote monitoring options. Most systems operate trouble-free for 20+ years with basic care. We offer training and support to ensure optimal performance.',
 'Solar', 
 10, 
 'active'),

('Can I connect a solar system to the grid?', 
 'Yes, we offer both grid-tied and off-grid solar solutions. Grid-tied systems allow you to sell excess power back to the utility company, while off-grid systems provide complete energy independence. We assess your needs and recommend the best solution. Hybrid systems combine both approaches for maximum reliability and cost savings.',
 'Solar', 
 11, 
 'active'),

-- Maintenance & Support
('How often should I service my borehole?', 
 'We recommend annual professional inspections and maintenance for optimal borehole performance. This includes pump testing, water quality checks, and system diagnostics. Regular maintenance prevents costly repairs and ensures consistent water supply. We offer maintenance contracts with scheduled visits and priority support.',
 'Maintenance', 
 12, 
 'active'),

('What warranty do you provide?', 
 'We provide comprehensive warranties: 2 years on drilling work and casing, 1 year on pump installations, and 5-10 years on solar panels (manufacturer warranty). All workmanship is guaranteed, and we respond to warranty issues within 24-48 hours. Extended warranty options are available for commercial projects.',
 'Maintenance', 
 13, 
 'active'),

('Do you provide emergency repair services?', 
 'Yes, we offer 24/7 emergency repair services for critical water supply issues. Our response team can address pump failures, system breakdowns, and urgent repairs. Response time is typically 4-8 hours depending on location. We maintain a stock of common parts and have mobile service units for on-site repairs.',
 'Maintenance', 
 14, 
 'active'),

-- Irrigation Questions
('What irrigation system is best for my farm?', 
 'The best irrigation system depends on crop type, farm size, water availability, and budget. Drip irrigation is most water-efficient (up to 50% savings), ideal for row crops and vegetables. Sprinkler systems work well for larger areas and field crops. We conduct farm assessments and design custom solutions optimized for your specific needs and crops.',
 'Irrigation', 
 15, 
 'active'),

('How much water do I need for irrigation?', 
 'Water requirements vary by crop, climate, and soil type. Generally, vegetables need 20-40mm per week, while field crops need 30-60mm. We calculate precise requirements based on your crop plan, farm size, and local climate data. Our systems are designed to maximize efficiency, reducing water usage by 30-50% compared to traditional methods.',
 'Irrigation', 
 16, 
 'active'),

-- Water Supply Questions
('Can you provide water for a whole community?', 
 'Yes, we specialize in community water projects, designing and installing complete water supply systems including boreholes, storage tanks, distribution networks, and treatment facilities. We\'ve completed projects serving 100-5,000+ households. Our solutions include community management training and long-term support to ensure sustainability.',
 'Water Supply', 
 17, 
 'active'),

('What is the lifespan of a borehole?', 
 'With proper maintenance, a well-constructed borehole can last 30-50 years or more. The lifespan depends on water quality, usage patterns, and maintenance. Regular servicing, proper pump selection, and water quality management extend the borehole\'s operational life. We design all installations for long-term durability and reliability.',
 'Water Supply', 
 18, 
 'active'),

-- Technical Questions
('What equipment do you use for drilling?', 
 'We operate modern, state-of-the-art drilling rigs capable of reaching depths up to 300 meters. Our fleet includes rotary drilling rigs for various geological conditions, DTH (Down-The-Hole) hammers for hard rock, and specialized equipment for different terrains. All equipment is regularly maintained and operated by certified, experienced drillers.',
 'Technical', 
 19, 
 'active'),

('How do you locate the best drilling site?', 
 'We use advanced geophysical survey techniques including electrical resistivity, seismic refraction, and ground-penetrating radar to map subsurface geology and identify optimal drilling locations. Our surveys analyze aquifer depth, water quality potential, and geological formations. This scientific approach ensures a 95%+ success rate in finding water.',
 'Technical', 
 20, 
 'active'),

('What happens to the drilling waste?', 
 'We follow strict environmental protocols for drilling waste management. All drilling mud and cuttings are properly contained, treated if necessary, and disposed of according to environmental regulations. We minimize environmental impact and restore the site after completion. Our practices meet all NEMA (National Environment Management Authority) requirements.',
 'Technical', 
 21, 
 'active');

