'use strict';

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up (queryInterface, Sequelize) {
    // Check if the portfolio page already exists
    const [existingPages] = await queryInterface.sequelize.query(
      'SELECT id FROM pages WHERE slug = ?;',
      { replacements: ['portfolio'] }
    );
    if (existingPages.length === 0) {
      await queryInterface.bulkInsert('pages', [{
        title: 'Portfolio',
        slug: 'portfolio',
        content: JSON.stringify({
          title: 'CUSTOMERS',
          paragraphs: [
            'TLCI prides itself on providing top-notch solutions to a diverse range of customers',
            'TLCI prides itself on providing top-notch solutions to a diverse range of customers, including international corporations, government agencies, and non-profit organizations. Our customers have consistently been happy with the level of expertise and dedication we bring to every project, and have praised us for our ability to meet their unique needs and exceed their expectations.',
            "Our customers base includes some of the world's leading conglomerates in the telecom and service industries such as the Airtel Group, the Etisalat Group, the ZAIN Group, and IBM, as well as various government agencies and non-profit organizations. We have a proven track record of delivering results for our customers and we strive to understand their unique needs and tailor our solutions to meet them.",
            "Whether it's a multinational company looking to expand its operations or a non-profit in need of fundraising support, TLCI has the skills and experience to help our customers achieve their goals. We are committed to building long-term relationships with our customers and are dedicated to helping them succeed in today's competitive marketplace.",
            'Contact us today to learn more about how we can help your organization reach its full potential.'
          ],
          highlightsTitle: 'Our Client Highlights',
          highlights: [
            { icon: 'fas fa-globe-americas', text: 'International Corporations', tab: 'international' },
            { icon: 'fas fa-landmark', text: 'Government Agencies', tab: 'government' },
            { icon: 'fas fa-building', text: 'Non-Profit Organizations', tab: 'nonprofit' },
            { icon: 'fas fa-handshake', text: 'Corporates', tab: 'corporates' }
          ],
          stats: [
            { value: '90', label: 'Projects' },
            { value: '63', label: 'Customers' },
            { value: '24', label: 'Countries' }
          ],
          certifications: [
            {
              title: 'PA-DSS Certification',
              image: '/images/portfolio/GI_PA-DSS_certification.webp',
              description: "TLCI’s Mobile POS Solution has been accorded the Payment Application – Data Security Standard (PA-DSS) certification. The PA-DSS certification was established by the US-based Payment Card Industry – Security Standards Council (PCI-SSC) as a set of de facto global security standards for payment applications. TLCI is the first Philippine company to achieve this global distinction."
            },
            {
              title: "Visa's ADVT Certified Compliant",
              image: '/images/portfolio/GI_VISA_ADVT_Certified.webp',
              description: "TLCI’s Mobile POS solution has been officially certified as fully compliant with Visa’s Acquirer Data Validation Toolkit (ADVT). This certification enables VISA Magstripe and Chip applications on EMV cards. This achievement attests to TLCI’s knowledge, experience, and adherence to international payment standards set by Visa."
            },
            {
              title: "Mastercard's MTIP Certification",
              image: '/images/portfolio/GI_MastercardS_Terminal_Integration_Process.webp',
              description: "TLCI’s Mobile POS has been officially certified as fully compliant with Mastercard’s Terminal Integration Process (MTIP). This certification enables Mastercard contact/contactless Chip & Magstripe applications on Mastercard/Maestro/Cirrus EMV cards. This achievement demonstrates TLCI’s knowledge, experience, and adherence to international payment standards set by Mastercard."
            },
            {
              title: "Western Union's Mobile Money Transfer Partner Certification",
              image: '/images/portfolio/GI_WU-MobileMONEY.webp',
              description: "TLCI’s Mobile Money has been officially certified as fully compliant with Mobile Money Transfer Partner Certification Product Integration (PI) by Western Union. This achievement shows TLCI’s knowledge, experience, and adherence to international remittance standards set by Western Union."
            }
          ]
        }),
        status: 'published',
        author_id: null,
        created_at: new Date(),
        updated_at: new Date()
      }], {});
    }
  },

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