'use strict';

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up (queryInterface, Sequelize) {
    // Check if the partners page already exists
    const [existingPages] = await queryInterface.sequelize.query(
      'SELECT id FROM pages WHERE slug = ?;',
      { replacements: ['partners'] }
    );
    
    // If the page doesn't exist, insert it
    if (existingPages.length === 0) {
      await queryInterface.bulkInsert('pages', [{
        title: 'Our Partners',
        slug: 'partners',
        content: JSON.stringify({
          title: 'Our Partners',
          sections: [
            {
              type: 'partners-list',
              partners: [
                {
                  title: 'InfrasoftTech',
                  image: '/images/partners/infrasoftechlogo.webp',
                  description: "is a Fintech digital solutions provider serving 450+ financial institutions across 36 countries. InfrasoftTech offers a wide range of Banking Products, Framework based Solutions and Specialized Services. We have over 20 years' of experience in serving a cross-section of financial enterprises – Retail & Commercial Banking, Investment Banking, SME & Asset Financing, Asset Management, Wealth Management, Brokerage, Capital Markets, and Payment Services.",
                  link: 'http://www.infrasofttech.com/'
                },
                {
                  title: 'Dito',
                  image: '/images/partners/dito.webp',
                  description: "Telecommunity Corporation is the newest major telecommunications provider in the Philippines granted a Certificate of Public Convenience and Necessity by the National Telecommunications Commission in July 2019. We are proud to be a Filipino company with strong connections to multinational giants that include Udenna Corporation, Chelsea Logistics Holdings, Inc., and China Telecommunications.",
                  link: 'https://dito.ph/'
                },
                {
                  title: 'SuperMap Software Co., Ltd.',
                  image: '/images/partners/supermaplogo.webp',
                  description: "is an innovative GIS platform software and service provider. It was founded in 1997 in Beijing (headquarter). Now, SuperMap has more than 4,000 employees with annual revenue growth of over 30%. The most important milestone is that SuperMap was the first listed GIS software company in China in 2009. Now, SuperMap has become one of the largest GIS platform manufacturers in the world.",
                  link: 'https://www.supermap.com/en-us/'
                },
                {
                  title: 'Morris Allen & Associates, Inc. (MAA)',
                  image: '/images/partners/ma2.webp',
                  description: "was founded in 2003 and is a U.S.-based International company located in Florida. We specialize in Professional Engineering Support Services, IT, and Management Consulting (Professional and Administrative Services). This includes Civil Engineering Inspections (CEI), Resident Project Representatives (RPR), Threshold Inspections, and Bridge and Welding. Morris Allen's objectives and approach to delivering professional services are achieved through our exceptional staff and delivering unprecedented customer service.",
                  link: 'https://www.morrisallena.com/'
                },
                {
                  title: 'Huawei',
                  image: '/images/partners/huawelogo.webp',
                  description: "Founded in 1987, <b>Huawei</b> is a leading global provider of information and communications technology (ICT) infrastructure and smart devices. We have more than 194,000 employees, and we operate in more than 170 countries and regions, serving more than three billion people around the world. We are committed to bringing digital to every person, home and organization for a fully connected, intelligent world. To this end, we will: Drive ubiquitous connectivity and promote equal access to networks; Provide the ultimate computing power to deliver ubiquitous cloud and pervasive intelligence; Build digital platforms to help all industries and organizations become more agile, efficient, and dynamic; Redefine user experience with AI, making it more personalized for people across all scenarios, whether they're at home, in the office, or on the go.",
                  link: 'https://consumer.huawei.com/ph/offer/'
                },
                {
                  title: 'Maya',
                  image: '/images/partners/maya.webp',
                  description: "is powered by the country's only end-to-end digital payments company Maya Philippines, Inc., and Maya Bank, Inc. for digital banking services. Maya Philippines, Inc. and Maya Bank, Inc. are regulated by the Bangko Sentral ng Pilipinas.",
                  link: 'https://www.maya.ph/'
                },
                {
                  title: 'CropIn',
                  image: '/images/partners/cropin-logo.webp',
                  description: "is an intuitive, intelligent, self-evolving system that delivers future-ready farming solutions to the entire agricultural sector. We deliver decision-making tools that bring consistency, dependability and sustainability to agri-businesses. With capabilities of live reporting, analysis, interpretation and insight that span across geographies, we're digitizing every farm, while data-managing the entire ecosystem. Our smarter agri solutions are powered in real-time; for you to archive patterns, predict trends, to make a blueprint for your business in the times to come.",
                  link: 'https://www.cropin.com/'
                }
              ]
            }
          ]
        }),
        status: 'published',
        author_id: null,
        created_at: new Date(),
        updated_at: new Date()
      }], {});
    }
  },

  async down (queryInterface, Sequelize) {
    await queryInterface.bulkDelete('pages', { slug: 'partners' }, {});
  }
};