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

/**
 * Amazing Fullfilment Integration for WooCommerce - table class
 *
 * @author dejo-commerce
 * @copyright Copyright (c) 2017 dejo-commerce (https://www.dejo-commerce.com)
 * @license http://www.gnu.org/licenses/gpl-2.0.html
 */
class AmzFulfillment_Table {
	protected $tableName = NULL;
	protected $createQuery = NULL;
	protected $cleanOnDeactivate = true;

	/**
	 * init
	 * 
	 * Create / update database table
	 */
	public function init() {
		global $wpdb;
		$query = sprintf("SHOW TABLES LIKE '%s'", $this->tableName);
		if($wpdb->get_var($query) != $this->tableName) {
			dbDelta(sprintf($this->createQuery, $this->tableName));
			AmzFulfillment_Core::debug('Database table created: ' . $this->tableName);
		}
	}

	/**
	 * clean
	 * 
	 * Remove / cleanup database table
	 */
	public function clean() {
		global $wpdb;
		if($this->cleanOnDeactivate) {
			$wpdb->query(sprintf("DROP TABLE IF EXISTS `%s`", $this->tableName));
			AmzFulfillment_Core::debug('Database table removed: ' . $this->tableName);
		} else {
			AmzFulfillment_Core::debug('Database table keeped: ' . $this->tableName);
		}
	}
}