<?php
/* $Id:$ */

if (!defined('FREEPBX_IS_AUTH')) {
    die('No direct script access allowed');
}

global $db;
$version = FreePBX::Config()->get('ASTVERSION');
global $sqlTables;
$sqlTables = array('sccpbuttonconfig','sccpdevice','sccpline','sccpuser','sccpsettings','sccpdevmodel');
createBackUpConfig();

function createBackUpConfig()
{
    global $amp_conf;
    global $sqlTables;
    outn("<li>" . _("Creating Config BackUp") . "</li>");
    $cnf_int = \FreePBX::Config();
    $backup_files = array('extensions','extconfig','res_mysql', 'res_config_mysql','sccp','sccp_hardware','sccp_extensions');
    $backup_ext = array('_custom.conf', '_additional.conf','.conf');
    $dir = $cnf_int->get('ASTETCDIR');


    $sqlTables = array('sccpbuttonconfig','sccpdevice','sccpline','sccpuser','sccpsettings','sccpdevmodel');
    $sqlTablesString = implode(' ',$sqlTables);
    $sqlBuFile = $dir.'/sccp_backup_'.date("Ymd").'.sql';
    $result = exec("mysqldump {$amp_conf['AMPDBNAME']} {$sqlTablesString}
                  --password={$amp_conf['AMPDBPASS']}
                  --user={$amp_conf['AMPDBUSER']}
                  --single-transaction >{$sqlBuFile}");
    try {
        $zip = new \ZipArchive();
    } catch (\Exception $e) {
        outn("<br>");
        outn("<font color='red'>PHPx.x-zip not installed where x.x is the installed PHP version. Install it before continuing !</font>");
        die_freepbx();
    }
    $filename = $dir . "/sccp_uninstall_backup" . date("Ymd"). ".zip";
    if ($zip->open($filename, \ZIPARCHIVE::CREATE)) {
        foreach ($backup_files as $file) {
            foreach ($backup_ext as $b_ext) {
                if (file_exists($dir . '/'.$file . $b_ext)) {
                    $zip->addFile($dir . '/'.$file . $b_ext);
                }
            }
        }
        if (file_exists($sqlBuFile)) {
            $zip->addFile($sqlBuFile);
        }
        $zip->close();
    } else {
        outn("<li>" . _("Error Creating BackUp: ") . $filename ."</li>");
        outn("<br>");
        outn("<font color='red'>PHPx.x-zip not installed where x.x is the installed PHP version. Install it before continuing !</font>");
        die_freepbx();
    }
    unlink($sqlBuFile);
    outn("<li>" . _("Config backup created: ") . $filename ."</li>");
}

if (!empty($version)) {
    $check = $db->getRow("SELECT 1 FROM `kvstore` LIMIT 0", DB_FETCHMODE_ASSOC);
    if (!(DB::IsError($check))) {
        outn("<li>" . _("Deleting keys FROM kvstore..") . "</li>");
        sql("DELETE FROM kvstore WHERE module = 'sccpsettings'");
        sql("DELETE FROM kvstore WHERE module = 'Sccp_manager'");
    }
  }
  // FreePbx removes all tables via module.xml, and uninstaller will error
  // If the tables do not exist.
  //outn("<li>" . _('Removing all Sccp_manager tables') . "</li>");
  //foreach ($sqlTables as $table) {
      //$sql = "DROP TABLE IF EXISTS {$table}";
  //}
  // Still need to handle views as FreePBX does not know about these.
  outn("<li>" . _('Removing all Sccp_manager views') . "</li>");
  $db->query("DROP VIEW IF EXISTS sccpdeviceconfig");

  outn("<li>" . _("Uninstall Complete") . "</li>");
?>