'use strict';

/** 
 * Home Page Content Seeder
 * 
 * This seeder creates the initial content structure for the Home page.
 * The content is organized in sections that match the frontend component structure.
 */

module.exports = {
  async up (queryInterface, Sequelize) {
    const timestamp = new Date();
    
    // Check if page already exists
    const existingPage = await queryInterface.sequelize.query(
      `SELECT id FROM pages WHERE slug = 'home'`,
      { type: queryInterface.sequelize.QueryTypes.SELECT }
    );
    
    if (existingPage.length > 0) {
      console.log('Home page content already exists, skipping seeder');
      return;
    }
    
    // Insert the home page content
    await queryInterface.bulkInsert('pages', [
      {
        title: 'Home',
        slug: 'home',
        content: JSON.stringify({
          sections: [
            {
              type: 'hero',
              title: 'Telcom Live Content Inc.',
              subtitle: 'Digital Media Solutions',
              description: 'Delivering innovative solutions to transform your business with the best <strong>IT solutions and services</strong> tailored for your daily operations.',
              backgroundImage: '@/assets/main-section-image.webp'
            },
            {
              type: 'about',
              title: 'ABOUT US',
              content: [
                'Welcome to Telcom Live Content, Inc. Based in the Philippines where mobile top-up and mobile banking began, Telcom Live Content, Inc. (TLCI) has been a global pioneer in electronic mobile refill solutions since 2004. As one of the first to integrate successfully with ERICSSON and Huawei prepaid billing systems, TLCI\'s solutions handle 40 million transactions daily in 24 countries'
              ]
            },
            {
              type: 'solutions',
              title: 'OUR SOLUTIONS',
              solutions: [
                {
                  title: 'SYSTEMS INTEGRATION PRACTICE',
                  description: 'One of TLCI\'s core strengths is Systems Integration which has been mainly focused but not exclusively to the telecoms and service industries. Our turnkey integration services cover the entire gamut of the project delivery process.',
                  image: '@/assets/solutions/solutions-sip.webp',
                  route: 'systems-integration-practice'
                },
                {
                  title: 'SOFTWARE AUTOMATION',
                  description: 'TLCI understand the importance of automation in today\'s fast-paced business environment. Whether you need to automate a single process or multiple processes, we have the expertise and experience to deliver the best results.',
                  image: '@/assets/solutions/solutions-sa.webp',
                  route: 'software-automation'
                },
                {
                  title: 'MOBILE APPLICATIONS & FINANCIAL SERVICES',
                  description: 'As the business world becomes increasingly mobile-driven, At TLCI, we are keeping pace with this change by providing advanced solutions for mobile financial services and mobile applications for vertical industries.',
                  image: '@/assets/solutions/solutions-ma-and-fs.webp',
                  route: 'mobile-applications-financial-services'
                },
                {
                  title: 'e-Governance',
                  description: 'TLCI recognizes the critical role of e-Governance in today\'s digital age, which is why we offer advanced solutions to assist governments in delivering transparent and efficient public services.',
                  image: '@/assets/solutions/solutions-eg.webp',
                  route: 'e-governance'
                },
                {
                  title: 'FinTech',
                  description: 'Are you looking for a powerful and innovative fintech solution to take your business to the next level? Look no further than TLCI! Our FinTech solutions are designed to help businesses of all sizes streamline their financial operations.',
                  image: '@/assets/solutions/solutions-ft.webp',
                  route: 'fintech'
                },
                {
                  title: 'RegTech',
                  description: 'Regulatory compliance can be a daunting task for any business. TLCI\'s RegTech solutions are designed to make compliance simple and manageable to help companies navigate the complex regulatory landscape.',
                  image: '@/assets/solutions/solutions-rt.webp',
                  route: 'regtech'
                },
                {
                  title: 'APPLICATION SUPPORT',
                  description: 'TLCI recognizes the importance of keeping your business applications running smoothly. We offer a comprehensive Application Support package that addresses all aspects of application management.',
                  image: '@/assets/solutions/solutions-as.webp',
                  route: 'application-support'
                }
              ]
            },
            {
              type: 'mission',
              title: 'OUR MISSION',
              content: [
                'To deliver the best IT solutions and services that will fit our client\'s needs',
                'Provide people the software that can help with their daily operations'
              ],
              image: '@/assets/mission.svg'
            },
            {
              type: 'vision',
              title: 'OUR VISION',
              content: [
                'Make life easier through Information Technology'
              ],
              image: '@/assets/vision.svg'
            },
            {
              type: 'statistics',
              stats: [
                { value: 63, label: 'Happy Customers' },
                { value: 24, label: 'Countries' },
                { value: 90, label: 'Projects' },
                { value: 18, label: 'Years of Innovation' },
                { value: 7, label: 'Partners' },
                { value: 13, label: 'Awards' }
              ]
            }
          ]
        }),
        created_at: timestamp,
        updated_at: timestamp
      }
    ], {});
    
    console.log('Home page content seeded successfully');
  },

  async down (queryInterface, Sequelize) {
    // Remove the home page content
    await queryInterface.bulkDelete('pages', { slug: 'home' }, {});
    
    console.log('Home page content removed successfully');
  }
};