'use strict';

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up (queryInterface, Sequelize) {
    // Check if the page already exists
    const [existingPages] = await queryInterface.sequelize.query(
      'SELECT id FROM pages WHERE slug = ?;',
      { replacements: ['about-us'] }
    );
    
    // If the page doesn't exist, insert it
    if (existingPages.length === 0) {
      await queryInterface.bulkInsert('pages', [{
        title: 'About Us',
        slug: 'about-us',
        content: '{"title":"About Us","sections":[{"type":"hero","title":"ABOUT US","description":"We lead the way in telecommunications solutions since 2004, delivering innovation and excellence globally.","backgroundImage":"/uploads/about-building-background.webp"},{"type":"welcome","title":"Welcome to Telcom Live Content, Inc.","content":["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.","TLCI\'s Mobile Commerce Suite, its flagship product, enables voucher-less prepaid account refill for its mobile operator customers that eventually result in higher distribution efficiencies and substantial savings by replacing physical scratch cards and their associated administrative requirements. Meanwhile, its Mobile Money product won for its customer, ZAIN Group, the mobile industry\'s leading annual Global Mobile Awards as the \\\"Best Mobile Money for the Unbanked\\\" in February 2010. The Global Mobile Awards is an annual event held by the GSM Association honoring excellence and innovation in mobile communications.","In 2013, TLCI\'s Mobile Money Solutions won the following awards: Kalahari Mobile Money Best SIM Application, Global Mobile Awards\' Best NFC/Mobile Money Product or Service, and a Special Commendation for Etisalat United Arab Emirates for Technology in Sustainable Finance given by FT/IFC Sustainable Finance Award. The prestigious prizes recognize how mobile technology can enrich people\'s lives. This TLCI product currently serves 12 million customers in 18 African and Middle Eastern nations.","Its dedication to innovation and responsiveness to customer needs has enabled TLCI to diversify into leading technologies, namely: Mobile Banking, Mobile Web Communications, Smart Metering, Interconnect Billing and Settlement Systems, Secure Voucher Management, and e-Government.","The company\'s e-Government offering encompasses the whole suite of productivity applications such as regulatory compliance systems, document management with workflow systems, mobile applications with content management systems, business permits and licensing systems, HRIS with payroll and biometric timekeeping, cloud-based mobile ticketing platforms including 3-in-1 mobile POS devices, finance-grade, telco-grade managed cloud services, chatbots with social media integration, utility billing systems with mobile devices, payment fulfillment systems, and a host of typical government systems for national and local government units.","Its prestigious roster of customers 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."]},{"type":"statistics","title":"Our Achievements","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"}]},{"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":"/uploads/mission.svg"},{"type":"vision","title":"OUR VISION","content":"Make life easier through Information Technology.","image":"/uploads/vision.svg"}],"conclusion":{"logo":"/uploads/tlc_logo.webp","map":"/uploads/map-placeholder.jpg"}}',
        status: 'published',
        author_id: null,
        created_at: new Date(),
        updated_at: new Date()
      }], {});
    }
  },

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