<?php

namespace FileBird;



defined('ABSPATH') || exit;



use FileBird\Classes\Schedule as FilebirdSchedule;



/**

 * Plugin activate/deactivate logic

 */

class Plugin {

  protected static $instance = null;



  public static function getInstance() {

    if (null == self::$instance) {

      self::$instance = new self;

    }



    return self::$instance;

  }



  private function __construct() {

  }



  /** Plugin activated hook */

  public static function activate() {

    global $wpdb;

    $charset_collate = $wpdb->get_charset_collate();

    

    $table_fbv = $wpdb->prefix.'fbv';

    //type == 0: folder

    //type == 1: collection

    if ($wpdb->get_var("show tables like '$table_fbv'") != $table_fbv) {

        $sql = 'CREATE TABLE '.$table_fbv.' (

        `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

        `name` varchar(250) NOT NULL,

        `parent` int(11) NOT NULL DEFAULT 0,

        `type` int(2) NOT NULL DEFAULT 0,

        `ord` int(11) NULL DEFAULT 0,

        `created_by` int(11) NULL DEFAULT 0,

        PRIMARY KEY (id),

        UNIQUE KEY `id` (id)) ' . 'ENGINE = InnoDB '.$charset_collate.';';

        require_once ABSPATH.'wp-admin/includes/upgrade.php';

        dbDelta($sql);

    }



    $table = $wpdb->prefix.'fbv_attachment_folder';

    //type == 0: folder

    //type == 1: collection

    if ($wpdb->get_var("show tables like '$table'") != $table) {

        $sql = 'CREATE TABLE '.$table.' (

        `folder_id` int(11) unsigned NOT NULL,

        `attachment_id` bigint(20) unsigned NOT NULL,

        UNIQUE( `folder_id`, `attachment_id`)

        ) ' . 'ENGINE = InnoDB '.$charset_collate.';';

        require_once ABSPATH.'wp-admin/includes/upgrade.php';

        dbDelta($sql);

        //$wpdb->query("ALTER TABLE `".$table."` ADD CONSTRAINT `".$table."_ibfk_1` FOREIGN KEY (`folder_id`) REFERENCES `".$table_fbv."` (`id`) ON DELETE CASCADE;");

    }

    

    $first_time_active = get_option('fbv_first_time_active');

    $fbv_review = get_option('fbv_review');



    if ($first_time_active === false) {

      update_option('fbv_is_new_user', 1);

      update_option('fbv_first_time_active', 1);

      if ($fbv_review !== false) return;

        update_option('fbv_review', time() + 3*60*60*24); //After 3 days show

    }



    $current_version = get_option('fbv_version');

    if ( version_compare(NJFB_VERSION, $current_version, '>') ) { 

      update_option('fbv_version', NJFB_VERSION);

      if ($fbv_review !== false) return;

        update_option('fbv_review', time() + 3*60*60*24); //After 3 days show

    }



    FilebirdSchedule::registerShedule();

  }



  /** Plugin deactivate hook */

  public static function deactivate() {

    FilebirdSchedule::clearSchedule();

  }

}