onapp.php

<?php
// TODO add onapp $_LANG in to file
// error_reporting(E_ALL);

if ( ! defined('ONAPP_FILE_NAME') ) define("ONAPP_FILE_NAME", basename(__FILE__));
define("CLIENTAREA",true);

require_once "dbconnect.php";
require_once "includes/functions.php";
require_once "includes/clientareafunctions.php";

if ( ! defined('ONAPP_WRAPPER_INIT') )
    define('ONAPP_WRAPPER_INIT', dirname(__FILE__).'/includes/wrapper/OnAppInit.php');

require_once dirname(__FILE__).'/modules/servers/onapp/lib.php';

define( "CLIENTAREA", true );

if (isset($_POST['language']))
  $_SESSION['Language'] = $_POST['language'];

load_language();

if ( file_exists( ONAPP_WRAPPER_INIT ) ) {
    require_once ONAPP_WRAPPER_INIT;
}

/**
 * If they are not logged in divert them
 */
$user_id = $_SESSION["uid"];

if ( ! $user_id ) {
    redirect("clientarea.php");
    exit();
};

/**
 * Set global variables
 */
$_ONAPPVARS = array();

foreach ( array('id', 'page', 'action') as $val )
    $_ONAPPVARS[$val] = get_value($val);

/**
 * Set base noavigation bar
 */
$breadcrumbnav  = ' <a href="index.php">'.$_LANG["globalsystemname"].'</a>';
$breadcrumbnav .= ' &gt; <a href="clientarea.php">'.$_LANG["clientareatitle"].'</a>';
$breadcrumbnav .= ' &gt; <a href="' . ONAPP_FILE_NAME . '">'.$_LANG["onappmyvms"].'</a>';
if ( in_array($_ONAPPVARS['page'], array('productdetails', 'disks', 'cpuusage', 'ipaddresses', 'backups', 'upgrade') ) )
    $breadcrumbnav .= ' &gt; <a title="' .$_LANG["clientareaproductdetails"]. '" href="' . ONAPP_FILE_NAME . '?page=productdetails&id='.$id.'">'.$_LANG["clientareaproductdetails"].'</a>';

/**
 * Check if service exist
 **/
if ( $_ONAPPVARS['id'] !== NULL ) {

    $_ONAPPVARS['service'] = get_service($_ONAPPVARS['id']);

    if ( ! $_ONAPPVARS['service'] )
        $_ONAPPVARS['error'] = sprintf($_LANG["onappservicenotfound"], $id);
    elseif (! is_null($_ONAPPVARS['service']['vmid']) && $_ONAPPVARS['service']['userid'] == $user_id )
        $_ONAPPVARS['vm'] = get_vm($_ONAPPVARS['id']);
};

/**
 * Chose page to show
 */
if ( isset($_ONAPPVARS['page']) && $_ONAPPVARS['service'] && $_ONAPPVARS['service']['userid'] == $user_id )
    switch ( $_ONAPPVARS['page'] ) {
        case 'productdetails':
            productdetails();
            break;
        case 'cpuusage':
            $breadcrumbnav .= ' &gt; <a title="' .$_LANG["onappcpuusage"]. '" href="' . ONAPP_FILE_NAME . '?page=cpuusage&id='.$id.'">'.$_LANG["onappcpuusage"].'</a>';
            productcpuusage();
            break;
        case 'ipaddresses':
            $breadcrumbnav .= ' &gt; <a title="' .$_LANG["onappipaddresses"]. '" href="' . ONAPP_FILE_NAME . '?page=ipaddresses&id='.$id.'">'.$_LANG["onappipaddresses"].'</a>';
            productipaddresses();
            break;
        case 'disks':
            $breadcrumbnav .= ' &gt; <a title="' .$_LANG["onappdisks"]. '" href="' . ONAPP_FILE_NAME . '?page=disks&id='.$id.'">'.$_LANG["onappdisks"].'</a>';
            productdisks();
            break;
        case 'backups':
            $breadcrumbnav .= ' &gt; <a title="' .$_LANG["onappbackups"]. '" href="' . ONAPP_FILE_NAME . '?page=backups&id='.$id.'">'.$_LANG["onappbackups"].'</a>';
            productbackups();
            break;
        case 'upgrade':
            if( $_ONAPPVARS['service']['configoptionsupgrade'] == "on" ) {
                $breadcrumbnav .= ' &gt; <a title="' .$_LANG["onappupgradedowngrade"] .'" href="' . ONAPP_FILE_NAME . '?page=upgrade&id='.$id.'">'.$_LANG["onappupgradedowngrade"].'</a>';
                productupgrade();
            } else {
                $_ONAPPVARS['error'] = sprintf( $_LANG["onapppagenotfound"], $_ONAPPVARS['page'] );
                productdetails();
            };
            break;
        default:
            $_ONAPPVARS['error'] = sprintf( $_LANG["onapppagenotfound"], $_ONAPPVARS['page'] );
            productdetails();
            break;
    } elseif( isset($_ONAPPVARS['page']) && $_ONAPPVARS['page'] == "storagedisksize" ) {
        clientareastoragedisksizes();
    } else {
        clientareaproducts();
    };
    
/**
 * Redirect to another page
 *
 * @param string $url redirection url
 */
function redirect($url) {
    if (!headers_sent()) {
		header('Location: '.$url);
		exit;
	}
    else {
        echo '<script type="text/javascript">';
        echo 'window.location.href="'.$url.'";';
        echo '</script>';
        echo '<noscript>';
        echo '<meta http-equiv="refresh" content="0;url='.$url.'" />';
        echo '</noscript>'; exit;
    };
}

/**
 * Get POST or GET value
 *
 * @param string $name value name
 */
function get_value($name) {
    global $_GET, $_POST;

    return isset($_POST[$name])
        ? $_POST[$name]
        : isset($_GET[$name])
            ? $_GET[$name]
            : NULL;
}

/**
 * Show Client area
 *
 * @param string $templatefile template name
 * @param array $values smarty values
 */
function show_template($templatefile, $values) {
    global $_LANG, $breadcrumbnav, $smartyvalues, $CONFIG;

    $pagetitle = $_LANG["clientareatitle"];
    $pageicon = "images/support/clientarea.gif";

    initialiseClientArea($pagetitle, $pageicon, $breadcrumbnav);

    $smartyvalues = $values;

    if ($CONFIG['SystemSSLURL'])
        $smartyvalues['systemurl'] = $CONFIG['SystemSSLURL'] . '/';
    else if ($CONFIG['SystemURL'] != 'http://www.yourdomain.com/whmcs')
        /* Do not change this URL!!! - Otherwise WHMCS Failed ! */
        $smartyvalues['systemurl'] = $CONFIG['SystemURL'] . '/';

    outputClientArea($templatefile);
}

/**
 * Show user Virtual machines list
 */
function clientareaproducts() {
    global $user_id, $_ONAPPVARS, $_LANG;

    if ( wrapper_check() ){
        show_template(
            "onapp/clientareaproducts",
            array(
                'services'         => array(),
                'not_resolved_vms' => array(),
                'error'            => $_LANG['onapponmaintenance'],
            )
        );
        
        return;
    }

    $services = array();
    $not_resolved_vms = array();

// Get OnApp VMs
    $select_onapp_users = sprintf(
        "SELECT
            *,
            tblonappclients.password as userpassword
        FROM
            tblonappclients
            LEFT JOIN tblservers ON tblservers.id = server_id
        WHERE client_id = '%s';",
        $user_id
    );

    $onapp_users_query = full_query($select_onapp_users);

    while ($onapp_user = mysql_fetch_assoc( $onapp_users_query ) ) {
	if( ! $onapp_user['ipaddress'] && ! $onapp_user['hostname'] ) continue;
        $vm = new ONAPP_VirtualMachine();

        $vm->auth(
            $onapp_user["ipaddress"] != "" ? $onapp_user["ipaddress"] : $onapp_user["hostname"],
            $onapp_user["email"],
            decrypt($onapp_user["userpassword"])
        );

        $tmp_vms = $vm->getList();

        if ( is_array($tmp_vms) )
            foreach($tmp_vms as $tmp_vm)
                $not_resolved_vms[ $onapp_user["server_id"] ][$tmp_vm->_id] = array(
                  'vm' => $tmp_vm,
                  'server' => $onapp_user
                );
    };

// Get services
    $select_services = "SELECT
        tblhosting.id as id,
        tblhosting.domain as domain,
        tblhosting.server as serverid,
        tblonappservices.vm_id as vmid,
        tblproducts.name as product
    FROM
        tblhosting
        LEFT JOIN tblproducts ON tblproducts.id = packageid
        LEFT JOIN tblonappservices ON service_id = tblhosting.id
    WHERE
        servertype = 'onapp'
        AND tblhosting.domainstatus = 'Active'
        AND userid = '$user_id'
    ORDER BY tblhosting.id ASC";

    $services_rows = full_query($select_services);

    if ($services_rows)

        while ($service = mysql_fetch_assoc( $services_rows ) ) {
            $services[ $service['id'] ] = $service;

            if ( is_null( $service['vmid'] ) )
                $services[ $service['id'] ]['error'] = $_LANG["onappvmnotcreated"];
            elseif( ! isset( $not_resolved_vms[$service['serverid'] ][$service['vmid']] ) )
                $services[ $service['id'] ]['error'] = sprintf(
                    $_LANG["onappvmnotfound"],
                    $service['vmid']
                );
            else {
                $services[ $service['id'] ]['obj'] = $not_resolved_vms[$service['serverid'] ][$service['vmid']]['vm'];
                unset($not_resolved_vms[$service['serverid'] ][$service['vmid']]);
                if (count($not_resolved_vms[$service['serverid'] ]) == 0 )
                    unset($not_resolved_vms[$service['serverid'] ]);
            };
        };

    show_template(
        "onapp/clientareaproducts",
        array(
            'services'         => $services,
            'not_resolved_vms' => $not_resolved_vms,
            'error'            => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
        )
    );
}

/**
 * Show Virtual machine page
 */
function productdetails() {
    global $_ONAPPVARS;

    if (! isset($_ONAPPVARS['service']) )
        clientareaproducts();
    if ( isset($_ONAPPVARS['action']) && ! isset($_ONAPPVARS['error']) && ! isset($_ONAPPVARS['vm']->_obj->error) )
        _actions_vm($_ONAPPVARS['action']);
    elseif( ! is_null($_ONAPPVARS['service']['vmid']) )
        showproduct();
    else
        showcreateproduct();
}

/**
 * Run action for virtual machine
 */
function _actions_vm($action) {
    global $_ONAPPVARS, $_LANG;

    $action = $_ONAPPVARS['action'];

    if ( ! is_null($action) )
        switch ( $action ) {
            case 'create':
                _action_vm_create();
                break;
            case 'unlock':
                $_ONAPPVARS['vm']->unlock();
                break;
            case 'build':
                _action_update_res();
                $_ONAPPVARS['vm']->build();
                break;
            case 'rebuild':
                rebuild();
                break;
            case 'start':
                _action_update_res();
                $_ONAPPVARS['vm']->startup();
                break;
            case 'stop':
                $_ONAPPVARS['vm']->shutdown();
                break;
            case 'reboot':
                _action_update_res();
                $_ONAPPVARS['vm']->reboot();
                break;
            case 'delete':
                _action_vm_delete();
                break;
            case 'reset_pass':
                $_ONAPPVARS['vm']->reset_password();
                break;
            case 'rebuild_network':
                $_ONAPPVARS['vm']->rebuild_network();
                break;
            default:
                $_ONAPPVARS['error'] = sprintf($_LANG["onappactionnotfound"], $action);
                break;
        };

    unset($_ONAPPVARS['action']);

    if ( isset($_ONAPPVARS['vm']) && ! is_null($_ONAPPVARS['vm']->error) )
        $_ONAPPVARS['error'] = is_array($_ONAPPVARS['vm']->error) ?
            implode('.<br>', $_ONAPPVARS['vm']->error) :
            $_ONAPPVARS['vm']->error;
    elseif ( isset($_ONAPPVARS['vm']) && ! is_null($_ONAPPVARS['vm']->_obj->error) )
        $_ONAPPVARS['error'] = is_array($_ONAPPVARS['vm']->_obj->error) ?
            implode('.<br>', $_ONAPPVARS['vm']->_obj->error) :
            $_ONAPPVARS['vm']->_obj->error;

    if ( ! isset($_ONAPPVARS['error']) )
        redirect( ONAPP_FILE_NAME . "?page=productdetails&id=".$_ONAPPVARS['id']);
    else
        productdetails();
}

function rebuild(){
    global $_ONAPPVARS, $_LANG;

    _action_update_res();
    
    if ( $_ONAPPVARS['service']['last_order_template_id'] &&
         $_ONAPPVARS['service']['template_upgrade_status'] == 'Active')
    {
        $_ONAPPVARS['vm']->_template_id = isset($_ONAPPVARS['service']['os']) ? $_ONAPPVARS['service']['os'] : $_ONAPPVARS['service']['configoption2'];
    }

    $_ONAPPVARS['vm']->_required_startup = '1';
    $_ONAPPVARS['vm']->build();
}

/**
 * Action create virtual machine
 */
function _action_vm_create() {
    global $_ONAPPVARS, $_LANG;                              

    foreach ( array('templateid', 'hostname' ) as $val )
        $_ONAPPVARS[$val] = get_value($val);                  
/* TODO check template
    $templates = get_templates($_ONAPPVARS['service']['serverid'], $_ONAPPVARS['service']["configoption2"]);
    $os = $_ONAPPVARS['service']['os'];

    if (! is_null($os) && isset($templates[$os]) ) {
        $templates = array(
            $os => $templates[$os]
        );
    };
*/

    if( isset($_ONAPPVARS['vm']->_id) )
        $_ONAPPVARS['error'] =  $_LANG["onappvmexist"];
    elseif ( ! isset($_ONAPPVARS['hostname'] ) || $_ONAPPVARS['hostname'] == "" )
        $_ONAPPVARS['error'] =  $_LANG["onapphostnamenotfound"];
    elseif ( ! isset($_ONAPPVARS['templateid']) )
        $_ONAPPVARS['error'] = $_LANG["onapptemplatenotset"];

    if ( isset($_ONAPPVARS['error']) )
        return false;

    $_ONAPPVARS['vm'] = create_vm($_ONAPPVARS['id'], $_ONAPPVARS['hostname'], $_ONAPPVARS['templateid'] );
    _ips_resolve_all($_ONAPPVARS['id']);

    return true;
}

function _action_vm_delete() {
    global $_ONAPPVARS;

    $_ONAPPVARS['vm'] = delete_vm( $_ONAPPVARS['id'] );

    return true;
}

function _action_update_res() {
    global $_ONAPPVARS;

    $vm           = $_ONAPPVARS['vm']->_obj;
    $service      = $_ONAPPVARS['service'];
    $user         = get_onapp_client( $_ONAPPVARS['id'] );
    $onapp_config = get_onapp_config( $service['serverid'] );

    $memory            = $service['configoption3']  + $service['additionalram'];
    $cpus              = $service['configoption5']  + $service['additionalcpus'];
    $cpu_shares        = $service['configoption7']  + $service['additionalcpushares'];
    $primary_disk_size = $service['configoption11'] + $service['additionaldisksize'];
    $rate_limit        = $service['configoption8']  + $service['additionalportspead'];

    // Adjust Resource Allocations
    if ( $vm->_memory != $memory ||
         $vm->_cpus != $cpus ||
         $vm->_cpu_shares != $cpu_shares
    ) {
        $_ONAPPVARS['vm']->_memory            = $memory;
        $_ONAPPVARS['vm']->_cpus              = $cpus;
        $_ONAPPVARS['vm']->_cpu_shares        = $cpu_shares;
        $_ONAPPVARS['vm']->_primary_disk_size = $primary_disk_size;

        $_ONAPPVARS['vm']->save();
    };

    // Change Disk size
    $disks = new ONAPP_Disk();

    $disks->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    $primary_disk = null;

    foreach($disks->getList( $_ONAPPVARS['vm']->_id ) as $disk )
        if( $disk->_primary == "true" )
            $primary_disk = $disk;

    if ( $primary_disk->_disk_size != $primary_disk_size ) {
        $primary_disk->_disk_size = $primary_disk_size;

        $primary_disk->auth(
            $onapp_config["adress"],
            $user["email"],
            $user["password"]
        );

        $primary_disk->save();
    };

    // Chanege Port Speed
    $network = get_vm_interface( $_ONAPPVARS['id'] );
    
    if ( $network && $rate_limit != $network->_rate_limit ) {
      $network->_rate_limit = $rate_limit;
      $network->save();
    }
    // resolve all IPs
    _ips_resolve_all($_ONAPPVARS['id']);

    return true;
}

/**
 * Show virtual machine details
 */
function showproduct() {
    global $_ONAPPVARS, $_LANG;

// Geting transaction by Ajax request //
///////////////////////////////////////    
    if( isset( $_GET[ 'transactionid' ] ) ) {
        if ( $_GET['type'] != 'Transaction' ) {
            exit();
        }
        
        $user = get_onapp_client( $_ONAPPVARS['id'] );
        $onapp_config = get_onapp_config( $_ONAPPVARS['service']['serverid'] );
        $onapp = new OnApp_Factory( $onapp_config["adress"], $user["email"], $user["password"] );
        
        $transaction = $onapp->factory( 'Transaction', true );
        $_transaction = $transaction->load( $_GET[ 'transactionid' ] );
        
        $transaction_js ['output'] = $_transaction->_log_output;
        
        $transaction_js = json_encode(  $transaction_js  );
        
	    ob_end_clean();
	    exit( $transaction_js );
    }
// End Geting transaction by Ajax request //
///////////////////////////////////////////     

    $onapp_config = get_onapp_config( $_ONAPPVARS['service']['serverid'] );

    if ( ! is_null($_ONAPPVARS['vm']->error) ) {
        $_ONAPPVARS['error'] = is_array($_ONAPPVARS['vm']->error) ?
            implode('.<br>', $_ONAPPVARS['vm']->error) :
            $_ONAPPVARS['vm']->error;

        clientareaproducts();
    } elseif ( is_null($_ONAPPVARS['vm']->_id) ) {
        $_ONAPPVARS['error'] = sprintf(
            $_LANG["onappvmnotfoundonserver"],
            $_ONAPPVARS['service']['vmid'],
            $onapp_config["adress"]
        );

        showcreateproduct();
    } else {

        $network = get_vm_interface( $_ONAPPVARS['id'] );
        
// Getting log info //
/////////////////////
        
        $user = get_onapp_client( $_ONAPPVARS['id'] );
        $onapp_config = get_onapp_config( $_ONAPPVARS['service']['serverid'] );
        
        $onapp = new OnApp_Factory( $onapp_config["adress"], $user["email"], $user["password"] );
        
        $log         = $onapp->factory( 'Log', true );

        $url_args = array(
            'q' => $_ONAPPVARS['vm']->_obj->_identifier,
        );

        $logs = $log->getList( $url_args ); 
        
        foreach ( $logs as $item ) {
            $log_items[ $item->_id ]['target_type'] = $item->_target_type;
            $log_items[ $item->_id ]['target_id']   = $item->_target_id;
            $log_items[ $item->_id ]['created_at']  = str_replace('T', ' ', substr($item->_created_at, 0, 16)  );
            $log_items[ $item->_id ]['updated_at']  = $item->_updated_at;
            $log_items[ $item->_id ]['status']      = $item->_status;
            $log_items[ $item->_id ]['action']      = $item->_action;
        }
        
        $log_items = array_slice( $log_items, 0, 15, true);

// End Getting Log Info //
/////////////////////////        
        
        show_template(
            "onapp/clientareaoverview",
            array(
                'virtualmachine'       => $_ONAPPVARS['vm']->_obj,
                'id'                   => $_ONAPPVARS['id'],
                'error'                => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
                'configoptionsupgrade' => $_ONAPPVARS['service']['configoptionsupgrade'],
                'rate_limit'           => $network->_rate_limit,
                'vm_logs'              => $log_items,
            )
        );
    }
}

/**
 * Show user Virtual machine creation
 */
function showcreateproduct() {
    global $_ONAPPVARS;

    $templates = get_templates($_ONAPPVARS['service']['serverid'], $_ONAPPVARS['service']["configoption2"]);
    $os = $_ONAPPVARS['service']['os'];

    if (! is_null($os) && isset($templates[$os]) ) {
        $templates = array(
            $os => $templates[$os]
        );
    };
    
    $_ONAPPVARS['service']['configoption9'] = round( $_ONAPPVARS['service']['configoption9'] );
    $_ONAPPVARS['service']['configoption11'] = round( $_ONAPPVARS['service']['configoption11'] );

    show_template(
        "onapp/clientareacreateproduct",
        array(
            'service'   => $_ONAPPVARS['service'],
            'templates' => $templates,
            'error'     => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
        )
    );
}

/**
 * Show Virtual machine CPU usage
 */
function productcpuusage() {
    global $_ONAPPVARS, $_LANG; 

    $onapp_config = get_onapp_config( $_ONAPPVARS['service']['serverid'] );

    $cpuusage = new ONAPP_VirtualMachine_CpuUsage();

    $cpuusage->_virtual_machine_id = $_ONAPPVARS['vm']->_id;

    $user = get_onapp_client( $_ONAPPVARS['id'] );

    $cpuusage->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    $list = $cpuusage->getList();
    
    $hourly_stat = array();
    
    foreach ( $list as $key => $stat ) {
        $hourly_stat[$key]['date']  = strtotime( $stat->_created_at ) * 1000;
//        $hourly_stat[$key]['usage'] = number_format( $stat->_cpu_time / 360 / 100, 2 );
        $hourly_stat[$key]['usage'] = number_format( $stat->_cpu_time, 2 );
    }
    
    $content = '';
    
    foreach ( $hourly_stat as $stat ) {
        $content .= '['.$stat[date].', '.$stat[usage].'],';
    }
    
    $data = "[{data: [ " . $content . "], name: '".$_LANG[onappcpuusage]."'";
    
    $data = str_replace( '],]', ']]', $data );

    show_template(
        "onapp/clientareacpuusage",
        array(
            'id'                   => $_ONAPPVARS['id'],
            'address'              => $onapp_config["adress"],
            'error'                => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
            'data'                 => $data,
            'configoptionsupgrade' => $_ONAPPVARS['service']['configoptionsupgrade'],
        )
    );
}

/**
 * Show virtual machine addresses
 */
function productipaddresses() {
    global $_ONAPPVARS, $_LANG;

    foreach ( array('ipid' ) as $val )
        $_ONAPPVARS[$val] = get_value($val);

    $action = $_ONAPPVARS['action'];

    if( ! is_null($action) && $action != "" )
        switch ( $action ) {
            case 'setbase':
                $return = _action_ip_setbase($_ONAPPVARS['id'], $_ONAPPVARS['ipid']);
                break;
            case 'setadditional':
                $return = _action_ip_setadditional($_ONAPPVARS['id'], $_ONAPPVARS['ipid']);
                break;
            case 'assignbase':
                $return = _action_ip_add($_ONAPPVARS['id'], 1);
                break;
            case 'assignadditional':
                $return = _action_ip_add($_ONAPPVARS['id'], 0);
                break;
            case 'resolveall':
                $return = _ips_resolve_all($_ONAPPVARS['id']);
                break;
            case 'delete':
                $return = _action_ip_delete($_ONAPPVARS['id'], $_ONAPPVARS['ipid']);
                break;
            default:
                $_ONAPPVARS['error'] = sprintf($_LANG["onappactionnotfound"], $action);
                break;
        };

    if ( isset($return) )
        if ( isset($return['error']) )
            $_ONAPPVARS['error'] = $return['error'];
        else
            redirect( ONAPP_FILE_NAME . "?page=ipaddresses&id=" . $_ONAPPVARS['id']);

    clientareaipaddresses();
}

/**
 * Show Virtual machine network adresses
 */
function clientareaipaddresses() {
    global $_ONAPPVARS;

    $service = $_ONAPPVARS['service'];

    $ips = get_vm_ips($_ONAPPVARS['id']);

    show_template(
        "onapp/clientareaipaddresses",
        array(
            'base_ips'                => $ips['base'],
            'additional_ips'          => $ips['additional'],
            'not_resolved_ips'        => $ips['notresolved'],
            'not_resloved_base'       => $service['configoption18'] - count($ips['base']),
            'not_resloved_additional' => $service['additionalips']  - count($ips['additional']),
            'id'                      => $_ONAPPVARS['id'],
            'service'                 => $_ONAPPVARS['service'],
            'error'                   => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
            'configoptionsupgrade'    => $_ONAPPVARS['service']['configoptionsupgrade'],
        )
    );
}

/**
 * Show Virtual machine Disks
 */

function productdisks() {
    global $_ONAPPVARS, $_LANG;

    foreach ( array('mode', 'diskid') as $val )
        $_ONAPPVARS[$val] = get_value($val);

    $action = $_ONAPPVARS['action'];

    if( ! is_null($action) && $action != "" )
        switch ( $action ) {
            case 'autobackup':
                $return = _action_change_disk_mode($_ONAPPVARS['service']['serverid'], $_ONAPPVARS['diskid'], $_ONAPPVARS['mode']);
                break;
            default:
                $_ONAPPVARS['error'] = sprintf($_LANG["onappactionnotfound"], $action);
                break;
        };

    if ( isset($return) )
        if ( is_array($return) && isset($return['error']) )
            $_ONAPPVARS['error'] = $return['error'];
        else
            redirect( ONAPP_FILE_NAME . "?page=disks&id=" . $_ONAPPVARS['id']);

    clientareadisks();
}

function _action_change_disk_mode($server_id, $disk_id, $mode) {
    global $_ONAPPVARS;

    $onapp_config = get_onapp_config($_ONAPPVARS['service']['serverid']);

    $user = get_onapp_client( $_ONAPPVARS['id'] );

    $disk = new OnApp_Disk();

    $disk->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    $disk->load($disk_id);

    switch ( $mode ) {
        case 'true':
            $disk->enableAutobackup();
            break;
        case 'false':
            $disk->disableAutobackup();
            break;
        default:
            return array("error" => "Wrong disk autobackup mode");
            break;
    };

    if ( $disk->error )
        return array("error" => $disk->getErrorsAsString() );
    elseif ( $disk->_obj->error )
        return array("error" => $disk->_obj->getErrorsAsString() );
    else
        return $disk;
}

function clientareadisks() {
    global $_ONAPPVARS;

    $onapp_config = get_onapp_config($_ONAPPVARS['service']['serverid']);

    $disks = new ONAPP_Disk();

    $user = get_onapp_client( $_ONAPPVARS['id'] );

    $disks->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    $vms = new ONAPP_VirtualMachine();

    $vms->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    show_template(
        "onapp/clientareadisks",
        array(
            'vm'                   => $vms->load( $_ONAPPVARS['vm']->_id ),
            'disks'                => $disks->getList( $_ONAPPVARS['vm']->_id ),
            'id'                   => $_ONAPPVARS['id'],
            'error'                => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
            'configoptionsupgrade' => $_ONAPPVARS['service']['configoptionsupgrade'],
        )
    );
}

/**
 * Show Product Backups
 */
function productbackups() {
    global $_ONAPPVARS;

    foreach ( array('diskid', 'backupid' ) as $val )
        $_ONAPPVARS[$val] = get_value($val);

    $action = $_ONAPPVARS['action'];

    if( ! is_null($action) && $action != "" )
        switch ( $action ) {
            case 'add':
                $return = _action_backup_add($_ONAPPVARS['id'], $_ONAPPVARS['diskid']);
                break;
            case 'restore':
                $return = _action_backup_restore($_ONAPPVARS['id'], $_ONAPPVARS['backupid']);
                break;
            case 'delete':
                $return = _action_backup_delete($_ONAPPVARS['id'], $_ONAPPVARS['backupid']);
            default:
                $_ONAPPVARS['error'] = sprintf($_LANG["onappactionnotfound"], $action);
                break;
        };

    if ( isset($return) )
        if ( isset($return['error']) )
            $_ONAPPVARS['error'] = $return['error'];
        else
            redirect( ONAPP_FILE_NAME . "?page=backups&id=".$_ONAPPVARS['id']);

    clientareabackups();
}

/**
 * Show Virtual machine Backups
 */
function clientareabackups() {
    global $_ONAPPVARS;

    $onapp_config = get_onapp_config($_ONAPPVARS['service']['serverid']);

    $backups = new ONAPP_VirtualMachine_Backup();

    $backups->_virtual_machine_id = $_ONAPPVARS['vm']->_id;

    $user = get_onapp_client( $_ONAPPVARS['id'] );

    $backups->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    show_template(
        "onapp/clientareabackups",
        array(
            'backups'              => $backups->getList(),
            'id'                   => $_ONAPPVARS['id'],
            'error'                => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
            'configoptionsupgrade' => $_ONAPPVARS['service']['configoptionsupgrade'],
        )
    );
}

/**
 * Action create backup
 */
function _action_backup_add( $id, $diskid ) {
    if ( is_null($diskid) )
        return array('error' => 'Disk ID not set');

    $vm           = get_vm($id);
    $service      = get_service($id);
    $onapp_config = get_onapp_config($service['serverid']);

    $backup = new ONAPP_VirtualMachine_Backup();

    $backup->_virtual_machine_id = $vm->_id;
    $backup->_disk_id            = $diskid;

    $user = get_onapp_client( $id );

    $backup->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    $backup->save();

    if ( ! is_null($backup->_obj->error) )
        return array(
            'error' => is_array($backup->_obj->error) ?
                implode('.<br>', $backup->_obj->error) :
                $backup->_obj->error
        );
    elseif ( is_null($backup->_obj->_id) )
        return array('error' => "Can't create Backup");
    return true;
}

/**
 * Action restore backup
 */
function _action_backup_restore( $id, $backupid ) {
    if ( is_null($backupid) )
        return array('error' => 'Backup ID not set');

    $vm           = get_vm($id);
    $service      = get_service($id);
    $onapp_config = get_onapp_config($service['serverid']);

    $backup = new ONAPP_VirtualMachine_Backup();

    $backup->_id = $backupid;

    $user = get_onapp_client( $id );

    $backup->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    $backup->restore();

    if ( ! is_null($backup->_obj->error) )
        return array(
            'error' => is_array($backup->_obj->error) ?
                "Can't create Backup<br/>\n " . implode('.<br>', $backup->_obj->error) :
                "Can't create Backup'" . $backup->_obj->error
        );
    else
        return true;
}


/**
 * Action delete backup
 */
function _action_backup_delete( $id, $backupid ) {
    if ( is_null($backupid) )
        return array('error' => 'Backup ID not set');

    $vm           = get_vm($id);
    $service      = get_service($id);
    $onapp_config = get_onapp_config($service['serverid']);

    $backup = new ONAPP_VirtualMachine_Backup();

    $backup->_id = $backupid;

    $user = get_onapp_client( $id );

    $backup->auth(
        $onapp_config["adress"],
        $user["email"],
        $user["password"]
    );

    $backup->delete();

    if ( ! is_null($backup->error) )
        return array( 'error' => is_array($backup->error) ?
                "Can't create Backup<br/>\n " . implode('.<br>', $backup->error) :
                "Can't create Backup'" . $backup->error
            );
    else
        return true;
}

function productupgrade() {
    global $_ONAPPVARS, $_LANG;

    $onapp_config = get_onapp_config($_ONAPPVARS['service']['serverid']);

    $service = $_ONAPPVARS['service'];

    $templates = get_templates(
        $service['serverid'],
        $service["configoption2"]
    );

    if ( ! is_null($_ONAPPVARS['vm']->error) ) {
        $_ONAPPVARS['error'] = is_array($_ONAPPVARS['vm']->error) ?
            implode(', ', $_ONAPPVARS['vm']->error) :
            $_ONAPPVARS['vm']->error;

        clientareaproducts();
    } elseif ( is_null($_ONAPPVARS['vm']->_id) ) {
        $_ONAPPVARS['error'] = sprintf(
            $_LANG["onappvmnotfoundonserver"],
            $_ONAPPVARS['service']['vmid'],
            $onapp_config["adress"]
        );

        clientareaproducts();
    } else
        show_template(
            "onapp/clientareaupgrade",
            array(
                'templates'      => $templates,
                'virtualmachine' => $_ONAPPVARS['vm']->_obj,
                'service'        => $service,
                'configoptions'  => $service['configoptions'],
                'id'             => $_ONAPPVARS['id'],
                'error'          => isset($_ONAPPVARS['error']) ? $_ONAPPVARS['error'] : NULL,
            )
        );
}

function get_storage_service( $service_id ) {

    $select_service = "SELECT
        tblhosting.id as id,
        userid,
        tblproducts.configoption1 as serverid,
        tblonappservices.vm_id as vmid,
        tblhosting.password,
        tblhosting.domain as domain,
        tblhosting.orderid as orderid,
        tblproducts.name as product,
        tblproducts.configoptionsupgrade,
        tblproducts.configoption1,
        tblproducts.configoption2,
        tblproducts.configoption3,
        tblproducts.configoption4,
        tblproducts.configoption5,
        tblproducts.configoption6,
        tblproducts.configoption7,
        tblproducts.configoption8,
        tblproducts.configoption9,
        tblproducts.configoption10,
        tblproducts.configoption11,
        tblproducts.configoption12,
        tblproducts.configoption13,
        tblproducts.configoption14,
        tblproducts.configoption15,
        tblproducts.configoption16,
        tblproducts.configoption17,
        tblproducts.configoption18,
        tblproducts.configoption19,
        tblproducts.configoption20,
        0 as additionalram,
        0 as additionalcpus,
        0 as additionalcpushares,
        0 as additionaldisksize,
        0 as additionalips,
        0 as additionalportspead
    FROM
        tblhosting
        LEFT JOIN tblproducts ON tblproducts.id = packageid
        LEFT JOIN tblonappservices ON service_id = tblhosting.id
    WHERE
        servertype = 'onappbackupspace'
        AND tblhosting.id = '$service_id'";

    $service_rows = full_query($select_service);

    if ( ! $service_rows )
        return false;
    $service = mysql_fetch_assoc( $service_rows );

    return $service;
}

function clientareastoragedisksizes() {
    global $_ONAPPVARS, $breadcrumbnav, $_LANG;

    $breadcrumbnav .= ' &gt; <a title="' .$_LANG["onappstoragedisksize"]. '" href="' . ONAPP_FILE_NAME . '?page=storagedisksize">'.$_LANG["onappstoragedisksize"].'</a>';

    $_ONAPPVARS['service'] = get_storage_service($_ONAPPVARS['id']);

    storagedisksizes();
}

function storagedisksizes() {
    global $user_id;

    $select_services = "SELECT
        tblhosting.id as id,

        tblonappclients.onapp_user_id,
        tblonappclients.email,
        tblonappclients.password,

        tblproducts.name as product,
        LOWER(domainstatus) as domainstatus,
        tblproducts.configoption1 as serverid,
        tblproducts.configoption2 basespace,
        tblproducts.configoption3,

        CASE optiontype
            WHEN 1 THEN optionssub.sortorder
            WHEN 2 THEN optionssub.sortorder
            WHEN 4 THEN options.qty * optionssub.sortorder
            ELSE 0
        END AS additionalspace,

        tblservers.name      as servername,
        tblservers.ipaddress as serveripaddres,
        tblservers.hostname  as serverhostname,
        tblservers.username  as serverusername,
        tblservers.password  as serverpassword,

        optionssub.id as subid,
        optionssub.optionname,
        options.configid,
        tblproductconfigoptions.optionname as configoptionname,
        tblproductconfigoptions.optiontype,
        tblproductconfigoptions.qtymaximum AS max,
        tblproductconfigoptions.qtyminimum AS min,
        options.qty,
        optionssub.sortorder,
        options.optionid as active
    FROM
        tblhosting
        LEFT JOIN tblproducts ON
            tblproducts.id = packageid
        LEFT JOIN tblonappservices ON
            service_id = tblhosting.id
        LEFT JOIN tblonappclients ON
            tblproducts.configoption1 = tblonappclients.server_id AND
            tblhosting.userid = tblonappclients.client_id
        LEFT JOIN tblhostingconfigoptions AS options ON
            relid = tblhosting.id
        LEFT JOIN tblproductconfigoptionssub AS sub
            ON options.configid = sub.configid
            AND options.configid = tblproducts.configoption3
            AND optionid = sub.id
        LEFT JOIN tblproductconfigoptions
            ON tblproductconfigoptions.id = options.configid
        LEFT JOIN tblproductconfigoptionssub AS optionssub
            ON optionssub.configid = tblproductconfigoptions.id AND
            options.configid = tblproducts.configoption3
        LEFT JOIN tblservers ON tblproducts.configoption1 = tblservers.id
    WHERE
        servertype = 'onappbackupspace'
        AND options.optionid = optionssub.id
        AND userid = '$user_id'
    ORDER BY servername, tblhosting.id ASC";

    $services_rows = full_query($select_services);

    while ($service =  mysql_fetch_assoc( $services_rows ) )
        $rows[] = $service;

    $servers = array();

    if ( count($rows) )
    foreach ( $rows as $key => $value ) {
        if ( ! isset( $servers[ $value['serverid'] ] ) ) {
            $servers[ $value['serverid'] ] = array(
                'services'  => array(),
                'name'      => $rows[ $key ]['servername'],
                'adress'    => $rows[ $key ]["serveripaddres"] != "" ?
                    'http://' . $rows[ $key ]["serveripaddres"] :
                    $rows[ $key ]['serverhostname'],
                'username'  => $rows[ $key ]['serverusername'],
                'password'  => decrypt($rows[ $key ]['serverpassword']),

                'onapp_user_id' => $rows[ $key ]['onapp_user_id'],
            );
        };

        $servers[ $value['serverid'] ]['services'][] = $value;
    };

    foreach ($servers as $key => $server) {
        $limit = new ONAPP_ResourceLimit();
        $limit->auth(
            $server['adress'],
            $server['username'],
            $server['password']
        );
        $limit->load( $server['onapp_user_id'] );

        $servers[$key]['storage_disk_size'] = $limit->_obj->_storage_disk_size ? $limit->_obj->_storage_disk_size : 0;

        $vms = new ONAPP_VirtualMachine();
        $vms->auth(
            $server['adress'],
            $server['username'],
            $server['password']
        );

        $backups_size = 0;

        foreach ( $vms->getList($server['onapp_user_id']) as $vm ) {
            $backups = new ONAPP_VirtualMachine_Backup();
            $backups->_virtual_machine_id = $vm->_id;

            $backups->auth(
                $server['adress'],
                $server['username'],
                $server['password']
            );

            foreach( $backups->getList() as $backup )
                $backups_size += $backup->_backup_size;
        };

        if ( $backups_size > 0 )
            $backups_size =  sprintf("%01.2f", $backups_size / 1024 / 1024 );

        $servers[ $value['serverid'] ]['backups_size'] = $backups_size;
    };

    show_template(
        "onapp/clientareastoragedisksizes",
        array(
            'rows' => $servers,
        )
    );
}