root/trunk/gui/include/reseller-functions.php

<?php
/**
 * ispCP ω (OMEGA) a Virtual Hosting Control System
 *
 * @copyright     2001-2006 by moleSoftware GmbH
 * @copyright     2006-2008 by ispCP | http://isp-control.net
 * @version        $ID$
 * @link         http://isp-control.net
 * @author         ispCP Team
 *
 * @license
 *   This program is free software; you can redistribute it and/or modify it under
 *   the terms of the MPL General Public License as published by the Free Software
 *   Foundation; either version 1.1 of the License, or (at your option) any later
 *   version.
 *   You should have received a copy of the MPL Mozilla Public License along with
 *   this program; if not, write to the Open Source Initiative (OSI)
 *   http://opensource.org | osi@opensource.org
 */

/* for mail types */
define('MT_NORMAL_MAIL', 'normal_mail');
define('MT_NORMAL_FORWARD', 'normal_forward');
define('MT_ALIAS_MAIL', 'alias_mail');
define('MT_ALIAS_FORWARD', 'alias_forward');
define('MT_SUBDOM_MAIL', 'subdom_mail');
define('MT_SUBDOM_FORWARD', 'subdom_forward');
define('MT_NORMAL_CATCHALL', 'normal_catchall');
define('MT_ALIAS_CATCHALL', 'alias_catchall');

function gen_reseller_mainmenu(&$tpl, $menu_file) {
        $sql = Database::getInstance();

    $tpl->define_dynamic('menu', $menu_file);
    $tpl->define_dynamic('isactive_support', 'menu');
    $tpl->define_dynamic('custom_buttons', 'menu');

    $tpl->assign(
        array(
            'TR_MENU_GENERAL_INFORMATION' => tr('General information'),
            'TR_MENU_CHANGE_PASSWORD' => tr('Change password'),
            'TR_MENU_CHANGE_PERSONAL_DATA' => tr('Change personal data'),
            'TR_MENU_HOSTING_PLANS' => tr('Manage hosting plans'),
            'TR_MENU_ADD_HOSTING' => tr('Add hosting plan'),
            'TR_MENU_MANAGE_USERS' => tr('Manage users'),
            'TR_MENU_ADD_USER' => tr('Add user'),
            'TR_MENU_E_MAIL_SETUP' => tr('Email setup'),
            'TR_MENU_CIRCULAR' => tr('Email marketing'),
            'TR_MENU_MANAGE_DOMAINS' => tr('Manage domains'),
            'TR_MENU_DOMAIN_ALIAS' => tr('Domain alias'),
            'TR_MENU_SUBDOMAINS' => tr('Subdomains'),
            'TR_MENU_DOMAIN_STATISTICS' => tr('Domain statistics'),
            'TR_MENU_QUESTIONS_AND_COMMENTS' => tr('Support system'),
            'TR_MENU_NEW_TICKET' => tr('New ticket'),
            'TR_MENU_LAYOUT_SETTINGS' => tr('Layout settings'),
            'TR_MENU_LOGOUT' => tr('Logout'),
            'TR_MENU_OVERVIEW' => tr('Overview'),
            'TR_MENU_LANGUAGE' => tr('Language'),
            'SUPPORT_SYSTEM_PATH' => Config::get('ISPCP_SUPPORT_SYSTEM_PATH'),
            'SUPPORT_SYSTEM_TARGET' => Config::get('ISPCP_SUPPORT_SYSTEM_TARGET'),
            'TR_MENU_ORDERS' => tr('Manage Orders'),
            'TR_MENU_ORDER_SETTINGS' => tr('Order settings'),
            'TR_MENU_ORDER_EMAIL' => tr('Order email setup'),
            'TR_MENU_LOSTPW_EMAIL' => tr('Lostpw email setup'),
            )
        );

    $query = <<<SQL_QUERY
        select
            *
        from
            custom_menus
        where
            menu_level = 'reseller'
          or
            menu_level = 'all'
SQL_QUERY;

    $rs = exec_query($sql, $query, array());
    if ($rs->RecordCount() == 0) {
        $tpl->assign('CUSTOM_BUTTONS', '');
    } else {
        global $i;
        $i = 100;

        while (!$rs->EOF) {
            $menu_name = $rs->fields['menu_name'];
            $menu_link = get_menu_vars($rs->fields['menu_link']);
            $menu_target = $rs->fields['menu_target'];

            if ($menu_target !== "") {
                $menu_target = "target=\"" . $menu_target . "\"";
            }

            $tpl->assign(
                array('BUTTON_LINK' => $menu_link,
                    'BUTTON_NAME' => $menu_name,
                    'BUTTON_TARGET' => $menu_target,
                    'BUTTON_ID' => $i,
                    )
                );

            $tpl->parse('CUSTOM_BUTTONS', '.custom_buttons');
            $rs->MoveNext();
            $i++;
        } // end while
    } // end else
    if (!Config::get('ISPCP_SUPPORT_SYSTEM')) {
        $tpl->assign('ISACTIVE_SUPPORT', '');
    }

    $tpl->parse('MAIN_MENU', 'menu');
} // End of gen_reseller_menu()

// Function to generate the manu data for reseller
function gen_reseller_menu(&$tpl, $menu_file) {
    $sql = Database::getInstance();

    $tpl->define_dynamic('menu', $menu_file);

    $tpl->define_dynamic('custom_buttons', 'menu');

    $tpl->assign(
        array('TR_MENU_GENERAL_INFORMATION' => tr('General information'),
            'TR_MENU_CHANGE_PASSWORD' => tr('Change password'),
            'TR_MENU_CHANGE_PERSONAL_DATA' => tr('Change personal data'),
            'TR_MENU_HOSTING_PLANS' => tr('Manage hosting plans'),
            'TR_MENU_ADD_HOSTING' => tr('Add hosting plan'),
            'TR_MENU_MANAGE_USERS' => tr('Manage users'),
            'TR_MENU_ADD_USER' => tr('Add user'),
            'TR_MENU_E_MAIL_SETUP' => tr('Email setup'),
            'TR_MENU_CIRCULAR' => tr('Email marketing'),
            'TR_MENU_MANAGE_DOMAINS' => tr('Manage domains'),
            'TR_MENU_DOMAIN_ALIAS' => tr('Domain alias'),
            'TR_MENU_SUBDOMAINS' => tr('Subdomains'),
            'TR_MENU_DOMAIN_STATISTICS' => tr('Domain statistics'),
            'TR_MENU_QUESTIONS_AND_COMMENTS' => tr('Support system'),
            'TR_MENU_NEW_TICKET' => tr('New ticket'),
            'TR_MENU_LAYOUT_SETTINGS' => tr('Layout settings'),
            'TR_MENU_LOGOUT' => tr('Logout'),
            'TR_MENU_OVERVIEW' => tr('Overview'),
            'TR_MENU_LANGUAGE' => tr('Language'),
            'SUPPORT_SYSTEM_PATH' => Config::get('ISPCP_SUPPORT_SYSTEM_PATH'),
            'SUPPORT_SYSTEM_TARGET' => Config::get('ISPCP_SUPPORT_SYSTEM_TARGET'),
            'TR_MENU_ORDERS' => tr('Manage Orders'),
            'TR_MENU_ORDER_SETTINGS' => tr('Order settings'),
            'TR_MENU_ORDER_EMAIL' => tr('Order email setup'),
            'TR_MENU_LOSTPW_EMAIL' => tr('Lostpw email setup'),
            'VERSION' => Config::get('Version'),
            'BUILDDATE' => Config::get('BuildDate'),
            'CODENAME' => Config::get('CodeName')
            )
        );

    $query = <<<SQL_QUERY
        select
            *
        from
            custom_menus
        where
            menu_level = 'reseller'
          or
            menu_level = 'all'
SQL_QUERY;

    $rs = exec_query($sql, $query, array());
    if ($rs->RecordCount() == 0) {
        $tpl->assign('CUSTOM_BUTTONS', '');
    } else {
        global $i;
        $i = 100;

        while (!$rs->EOF) {
            $menu_name = $rs->fields['menu_name'];
            $menu_link = get_menu_vars($rs->fields['menu_link']);
            $menu_target = $rs->fields['menu_target'];

            if ($menu_target !== "") {
                $menu_target = "target=\"" . $menu_target . "\"";
            }

            $tpl->assign(
                array('BUTTON_LINK' => $menu_link,
                    'BUTTON_NAME' => $menu_name,
                    'BUTTON_TARGET' => $menu_target,
                    'BUTTON_ID' => $i,
                    )
                );

            $tpl->parse('CUSTOM_BUTTONS', '.custom_buttons');
            $rs->MoveNext();
            $i++;
        } // end while
    } // end else
    if (!Config::get('ISPCP_SUPPORT_SYSTEM')) {
        $tpl->assign('ISACTIVE_SUPPORT', '');
    }
    if (Config::exists('HOSTING_PLANS_LEVEL') && strtolower(Config::get('HOSTING_PLANS_LEVEL')) === 'admin') {
        $tpl->assign('HP_MENU_ADD', '');
    }

    $tpl->parse('MENU', 'menu');
} // End of gen_reseller_menu()

// Get data for page of reseller
function get_reseller_default_props(&$sql, $reseller_id) {
    // Make sql query
    $query = <<<SQL_QUERY
        select
            *
        from
            reseller_props
        where
            reseller_id = ?
SQL_QUERY;
    // send sql query
    $rs = exec_query($sql, $query, array($reseller_id));

    if (0 == $rs->RowCount()) {
        return NULL;
    }

    return array(
        $rs->fields['current_dmn_cnt'],
        $rs->fields['max_dmn_cnt'],
        $rs->fields['current_sub_cnt'],
        $rs->fields['max_sub_cnt'],
        $rs->fields['current_als_cnt'],
        $rs->fields['max_als_cnt'],
        $rs->fields['current_mail_cnt'],
        $rs->fields['max_mail_cnt'],
        $rs->fields['current_ftp_cnt'],
        $rs->fields['max_ftp_cnt'],
        $rs->fields['current_sql_db_cnt'],
        $rs->fields['max_sql_db_cnt'],
        $rs->fields['current_sql_user_cnt'],
        $rs->fields['max_sql_user_cnt'],
        $rs->fields['current_traff_amnt'],
        $rs->fields['max_traff_amnt'],
        $rs->fields['current_disk_amnt'],
        $rs->fields['max_disk_amnt']
        );
} // End of get_reseller_default_props()

// Makeing user's probs
function generate_reseller_user_props ($reseller_id) {
    $sql = Database::getInstance();
    // Init with empty variables
    $rdmn_current = 0;
    $rdmn_max = 0;
    $rdmn_uf = '_off_';
    $rsub_current = 0;
    $rsub_max = 0;
    $rsub_uf = '_off_';
    $rals_current = 0;
    $rals_max = 0;
    $rals_uf = '_off_';
    $rmail_current = 0;
    $rmail_max = 0;
    $rmail_uf = '_off_';
    $rftp_current = 0;
    $rftp_max = 0;
    $rftp_uf = '_off_';
    $rsql_db_current = 0;
    $rsql_db_max = 0;
    $rsql_db_uf = '_off_';
    $rsql_user_current = 0;
    $rsql_user_max = 0;
    $rsql_user_uf = '_off_';
    $rtraff_current = 0;
    $rtraff_max = 0;
    $rtraff_uf = '_off_';
    $rdisk_current = 0;
    $rdisk_max = 0;
    $rdisk_uf = '_off_';

    $ResArray = array($rdmn_current, $rdmn_max, $rdmn_uf,
        $rsub_current, $rsub_max, $rsub_uf,
        $rals_current, $rals_max, $rals_uf,
        $rmail_current, $rmail_max, $rmail_uf,
        $rftp_current, $rftp_max, $rftp_uf,
        $rsql_db_current, $rsql_db_max, $rsql_db_uf,
        $rsql_user_current, $rsql_user_max, $rsql_user_uf,
        $rtraff_current, $rtraff_max, $rtraff_uf,
        $rdisk_current, $rdisk_max, $rdisk_uf);

    $query = <<<SQL_QUERY
        select
            admin_id
        from
            admin
        where
            created_by = ?
SQL_QUERY;

    $res = exec_query($sql, $query, array($reseller_id));

    if ($res->RowCount() == 0) {
        return array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
    }
    // Process all users of this group
    while ($data = $res->FetchRow()) {
        $admin_id = $data['admin_id'];

        $query = <<<SQL_QUERY
              select
                  domain_id
              from
                  domain
              where
                  domain_admin_id = ?
SQL_QUERY;

        $dres = exec_query($sql, $query, array($admin_id));

        $ddata = $dres->FetchRow();

        $user_id = $ddata['domain_id'];

        list ($sub_current, $sub_max,
            $als_current, $als_max,
            $mail_current, $mail_max,
            $ftp_current, $ftp_max,
            $sql_db_current, $sql_db_max,
            $sql_user_current, $sql_user_max,
            $traff_max, $disk_max
            ) = get_user_props($user_id);

        list ($tmpval1,
            $tmpval2,
            $tmpval3,
            $tmpval4,
            $tmpval5,
            $tmpval16,
            $traff_current,
            $disk_current,
            $tmpval7,
            $tmpval8
            ) = generate_user_traffic($user_id);

        $rdmn_current += 1;

        if ($sub_max != -1) {
            if ($sub_max == 0) $rsub_uf = '_on_';

            $rsub_current += $sub_current;
            $rsub_max += $sub_max;
        }

        if ($als_max != -1) {
            if ($als_max == 0) $rals_uf = '_on_';

            $rals_current += $als_current;
            $rals_max += $als_max;
        }

        if ($mail_max != -1) {
            if ($mail_max == 0) $rmail_uf = '_on_';

            $rmail_current += $mail_current;
            $rmail_max += $mail_max;
        }

        if ($ftp_max != -1) {
            if ($ftp_max == 0) $rftp_uf = '_on_';

            $rftp_current += $ftp_current;
            $rftp_max += $ftp_max;
        }

        if ($sql_db_max != -1) {
            if ($sql_db_max == 0) $rsql_db_uf = '_on_';

            $rsql_db_current += $sql_db_current;
            $rsql_db_max += $sql_db_max;
        }

        if ($sql_user_max != -1) {
            if ($sql_user_max == 0) $rsql_user_uf = '_on_';

            $rsql_user_current += $sql_user_current;
            $rsql_user_max += $sql_user_max;
        }

        if ($traff_max == 0) $rtraff_uf = '_on_';

        $rtraff_current += $traff_current;
        $rtraff_max += $traff_max;
        // print $rtraff_current."<br>"; //- debug shit
        if ($disk_max == 0) $rdisk_uf = '_on_';

        $rdisk_current += $disk_current;
        $rdisk_max += $disk_max;
        // print $rdisk_current."<br>"; //- debug shit
    }

    $ResArray = array($rdmn_current, $rdmn_max, $rdmn_uf,
        $rsub_current, $rsub_max, $rsub_uf,
        $rals_current, $rals_max, $rals_uf,
        $rmail_current, $rmail_max, $rmail_uf,
        $rftp_current, $rftp_max, $rftp_uf,
        $rsql_db_current, $rsql_db_max, $rsql_db_uf,
        $rsql_user_current, $rsql_user_max, $rsql_user_uf,
        $rtraff_current, $rtraff_max, $rtraff_uf,
        $rdisk_current, $rdisk_max, $rdisk_uf);
    return $ResArray;
} // End of generate_reseller_user_props()
// Get traffic information for user
function get_user_traffic($user_id)
{
    $sql = Database::getInstance();
    global $crnt_month, $crnt_year;

    $query = <<<SQL_QUERY
            select
                domain_id,
                IFNULL(domain_disk_usage, 0) as domain_disk_usage,
                IFNULL(domain_traffic_limit, 0) as domain_traffic_limit,
                IFNULL(domain_disk_limit,0) as domain_disk_limit,
                domain_name
            from
                domain
            where
                domain_id = ?
            order by
                domain_id
SQL_QUERY;

    $res = exec_query($sql, $query, array($user_id));

    if ($res->RowCount() == 0 || $res->RowCount() > 1) {
        // write_log("TRAFFIC WARNING: >$user_id< manages incorrect number of domains >".$res -> RowCount()."<");
        return array('n/a', 0, 0, 0, 0, 0, 0, 0, 0, 0);
    } else {
        $data = $res->FetchRow();

        $domain_id = $data['domain_id'];

        $domain_disk_usage = $data['domain_disk_usage'];

        $domain_traff_limit = $data['domain_traffic_limit'];

        $domain_disk_limit = $data['domain_disk_limit'];

        $domain_name = $data['domain_name'];

        $query = <<<SQL_QUERY
          select
              sum(dtraff_web) as web,
              sum(dtraff_ftp) as ftp,
              sum(dtraff_mail) as smtp,
              sum(dtraff_pop) as pop,
              sum(dtraff_web) +
              sum(dtraff_ftp) +
              sum(dtraff_mail) +
              sum(dtraff_pop) as total
          from
              domain_traffic
          where
              domain_id = ?
SQL_QUERY;

        $res = exec_query($sql, $query, array($domain_id));

        $data = $res->FetchRow();

        return array($domain_name,
            $domain_id,
            $data['web'],
            $data['ftp'],
            $data['smtp'],
            $data['pop'],
            $data['total'],
            $domain_disk_usage,
            $domain_traff_limit,
            $domain_disk_limit
            );
    }
} //End of get_user_traffic()