function adminMLMUserAccountInterface()
{
    //get database table prefix
    $table_prefix = mlm_core_get_table_prefix();
    global $wpdb;
    $msg = '';
    if (isset($_POST['mlm_user_account'])) {
        $search = $_POST['search_user'];
        $userId = $wpdb->get_var("SELECT ID FROM {$table_prefix}users WHERE user_login = '******' OR user_email = '{$search}'");
        if ($wpdb->num_rows > 0) {
            $_SESSION['search_user'] = $search;
            $_SESSION['session_set'] = 'sets';
            $_SESSION['userID'] = $userId;
        } else {
            $msg = __('You have entered a wrong username or email address', 'binary-mlm-pro');
            $_SESSION['search_user'] = $search;
            $_SESSION['session_set'] = '';
            $_SESSION['userID'] = '';
        }
    }
    include 'js-validation-file.html';
    ?>

    <div class='wrap'>
        <div id="icon-users" class="icon32"></div><h1><?php 
    _e('User Report', 'binary-mlm-pro');
    ?>
</h1><br />

        <div class="notibar msginfo" style="margin:10px;">
            <a class="close"></a>
            <p><?php 
    _e("Input a member's username or email address in the input box below to get complete information about the member's account. No more switching back and forth into different member accounts to check their account details.", 'binary-mlm-pro');
    ?>
</p>
        </div>	

    </div>

    <div class="forms-ui">

        <p><span style='color:red;'><?php 
    if (!empty($error)) {
        _e($error);
    }
    ?>
</span></p>

        <form name="open_user_account" method="post" action="">
            <table border="0" cellpadding="0" cellspacing="0" width="100%" class="form-table">
                <tr>
                    <th scope="row" class="admin-settings">
                        <a style="cursor:pointer;" title="Click for Help!" onclick="toggleVisibility('search-user');"><?php 
    _e('Search By username or email address', 'binary-mlm-pro');
    ?>
 :</a>
                    </th>
                    <td>
                        <input type="text" name="search_user" id="search_user" size="52" value="<?php 
    if (!empty($_SESSION['search_user'])) {
        _e(htmlentities($_SESSION['search_user']));
    }
    ?>
">
                        <a href="?page=mlm-user-account" style="cursor:pointer;text-decoration:none; margin-left:90px;"><?php 
    _e('Back to User Dashboard', 'binary-mlm-pro');
    ?>
</a>
                        <div class="toggle-visibility" id="search-user"><?php 
    _e('Please enter username or email address.', 'binary-mlm-pro');
    ?>
</div>
                        <div style="color:red;"><?php 
    echo $msg;
    ?>
</div>
                    </td>
                </tr>
            </table>
            <p class="submit">
                <input type="submit" name="mlm_user_account" id="mlm_user_account" value="<?php 
    _e('Search', 'binary-mlm-pro');
    ?>
 &raquo;" class='button-primary' onclick="needToConfirm = false;">
            </p>
        </form>

        <script language="JavaScript">
            populateArrays();
        </script>
        <!-----sdfgdf -->
        <?php 
    if (!empty($_GET['ac'])) {
        if ($_GET['ac'] == 'edit' && $_GET['page'] == 'mlm-user-account') {
            mlm_update_profile($_SESSION['userID']);
        } else {
            if ($_GET['ac'] == 'leftleg' && $_GET['page'] == 'mlm-user-account') {
                myLeftGroupDetails($_SESSION['userID']);
            } else {
                if ($_GET['ac'] == 'rightleg' && $_GET['page'] == 'mlm-user-account') {
                    myRightGroupDetails($_SESSION['userID']);
                } else {
                    if ($_GET['ac'] == 'personal' && $_GET['page'] == 'mlm-user-account') {
                        myPersonalGroupDetails($_SESSION['userID']);
                    } else {
                        if ($_GET['ac'] == 'payout' && $_GET['page'] == 'mlm-user-account') {
                            mlm_my_payout_page($_SESSION['userID']);
                        } else {
                            if ($_GET['ac'] == 'payout-details' && $_GET['page'] == 'mlm-user-account') {
                                mlm_my_payout_details_page($_SESSION['userID']);
                            } else {
                                if ($_GET['ac'] == 'network' && $_GET['page'] == 'mlm-user-account') {
                                    adminViewBinaryNetwork($_SESSION['userID']);
                                }
                            }
                        }
                    }
                }
            }
        }
    } else {
        if (!empty($_SESSION['session_set']) && $_SESSION['session_set'] == 'sets') {
            $key = $wpdb->get_var("SELECT user_key FROM {$table_prefix}mlm_users WHERE user_id = {$_SESSION['userID']}");
            //Total Users on My left leg
            $leftLegUsers = totalLeftLegUsers($key);
            //Total users on my right leg
            $rightLegUsers = totalRightLegUsers($key);
            //paid users on my left leg
            $leftLegActiveUsers = activeUsersOnLeftLeg($key);
            //paid users on my right leg
            $rightLegActiveUsers = activeUsersOnRightLeg($key);
            //Total my personal sales
            $personalSales = totalMyPersonalSales($key);
            //Total my personal sales active users
            $activePersonalSales = activeUsersOnPersonalSales($key);
            //show five users on left leg
            $fiveLeftLegUsers = myFiveLeftLegUsers($key);
            //show five users on right leg
            $fiveRightLegUsers = myFiveRightLegUsers($key);
            //show five users on personal sales
            $fivePersonalUsers = myFivePersonalUsers($key);
            $user_info = get_userdata($_SESSION['userID']);
            $add_page_id = get_post_id('mlm_registration_page');
            $sponsor_name = $user_info->user_login;
            $affiliateURL = site_url() . '?page_id=' . $add_page_id . '&sponsor=' . $sponsor_name;
            ?>

            <table width="100%" border="0" cellspacing="10" cellpadding="1">
                <tr>
                    <td width="40%" valign="top">
                        <table width="100%" border="0" cellspacing="10" cellpadding="1">
                            <tr>
                                <td colspan="2"><strong> <?php 
            _e('Personal Information', 'binary-mlm-pro');
            ?>
</strong></td>
                            </tr>
                            <tr>
                                <td scope="row"><?php 
            _e('Title', 'binary-mlm-pro');
            ?>
</td>
                                <td> <?php 
            _e('Details', 'binary-mlm-pro');
            ?>
</td>
                            </tr>
                            <tr>
                                <td scope="row"> <?php 
            _e('Name', 'binary-mlm-pro');
            ?>
</td>
                                <td><?php 
            echo $user_info->first_name . ' ' . $user_info->last_name;
            ?>
</td>
                            </tr>
                            <tr>
                                <td scope="row"> <?php 
            _e('Address', 'binary-mlm-pro');
            ?>
</td>
                                <td style="white-space:normal;"><?php 
            echo $user_info->user_address1 . "<br>" . $user_info->user_address2;
            ?>
</td>
                            </tr>
                            <tr>
                                <td scope="row"> <?php 
            _e('City', 'binary-mlm-pro');
            ?>
</td>
                                <td><?php 
            echo $user_info->user_city;
            ?>
</td>
                            </tr>
                            <tr>
                                <td scope="row"> <?php 
            _e('Contact No', 'binary-mlm-pro');
            ?>
.</td>
                                <td><?php 
            echo $user_info->user_telephone;
            ?>
</td>
                            </tr>
                            <tr>
                                <td scope="row"> <?php 
            _e('DOB', 'binary-mlm-pro');
            ?>
</td>
                                <td><?php 
            echo $user_info->user_dob;
            ?>
</td>
                            </tr>


                            <tr>
                                <td><a href="?page=mlm-user-account&ac=edit" style="text-decoration: none"> <?php 
            _e('Edit', 'binary-mlm-pro');
            ?>
</a></td>
                                <td><a href="?page=mlm-user-account&ac=network" style="text-decoration: none"> <?php 
            _e('View Genealogy', 'binary-mlm-pro');
            ?>
</a></td>
                            </tr>
                        </table>
                        <table width="100%" border="0" cellspacing="10" cellpadding="1">
                            <tr>
                                <td colspan="2"><strong> <?php 
            _e('My Payouts', 'binary-mlm-pro');
            ?>
</strong></td>
                            </tr>
                            <tr>
                                <td scope="row"> <?php 
            _e('Date', 'binary-mlm-pro');
            ?>
</td>
                                <td> <?php 
            _e('Amount', 'binary-mlm-pro');
            ?>
</td>
                                <td> <?php 
            _e('Action', 'binary-mlm-pro');
            ?>
</td>
                            </tr>
                            <?php 
            $detailsArr = my_payout_function($_SESSION['userID']);
            //_e("<pre>");print_r($detailsArr); exit;
            //$page_id = get_post_id('mlm_my_payout_details_page');
            if (count($detailsArr) > 0) {
                $mlm_settings = get_option('wp_mlm_general_settings');
                ?>
                                <?php 
                foreach ($detailsArr as $row) {
                    $amount = $row->commission_amount + $row->bonus_amount + $row->referral_commission_amount - $row->tax - $row->service_charge;
                    ?>
                                    <tr>
                                        <td><?php 
                    echo $row->payoutDate;
                    ?>
</td>
                                        <td><?php 
                    echo $mlm_settings['currency'] . ' ' . $amount;
                    ?>
</td>
                                        <td><a href="?page=mlm-user-account&ac=payout-details&pid=<?php 
                    echo $row->payout_id;
                    ?>
" style="text-decoration:none;"> <?php 
                    _e('View', 'binary-mlm-pro');
                    ?>
</a></td>	
                                    </tr>
                                    <tr><td colspan="2"><a href="?page=mlm-user-account&ac=payout" style="text-decoration:none;"> <?php 
                    _e('View All', 'binary-mlm-pro');
                    ?>
</a></td></tr>
                                <?php 
                }
                ?>
                                <?php 
            } else {
                ?>
                                <div class="no-payout">  <?php 
                _e('You have not earned any commisssions yet.', 'binary-mlm-pro');
                ?>
 </div>

                                <?php 
            }
            ?>
                        </table>
                    </td>
                    <td width="40%">
                        <table width="100%" border="0" cellspacing="10" cellpadding="1">
                            <tr>
                                <td><strong> <?php 
            _e('Network Details', 'binary-mlm-pro');
            ?>
</strong></td>
                            </tr>
                            <tr>
                                <td>
                                    <table width="100%" border="0" cellspacing="10" cellpadding="1">
                                        <tr>
                                            <td colspan="2"><strong> <?php 
            _e('Left Leg Sales', 'binary-mlm-pro');
            ?>
</strong></td>
                                        </tr>

                                        <tr>
                                            <td><?php 
            _e('Total on Left Leg', 'binary-mlm-pro');
            ?>
: <?php 
            echo $leftLegUsers;
            ?>
</td>
                                            <td>Active: <?php 
            echo $leftLegActiveUsers;
            ?>
</td>
                                        </tr>
                                        <?php 
            foreach ($fiveLeftLegUsers as $key => $value) {
                _e("<tr>");
                foreach ($value as $k => $val) {
                    _e("<td>" . $val . "</td>");
                }
                _e("</tr>");
            }
            ?>
                                        <tr>
                                            <td colspan="2"><a href="?page=mlm-user-account&ac=leftleg" style="text-decoration: none"> <?php 
            _e('View All', 'binary-mlm-pro');
            ?>
</a></td>
                                        </tr>

                                    </table>
                                </td>
                            </tr>

                            <tr>
                                <td>
                                    <table width="100%" border="0" cellspacing="10" cellpadding="1">
                                        <tr>
                                            <td colspan="2"><strong> <?php 
            _e('Right Leg Sales', 'binary-mlm-pro');
            ?>
</strong></td>
                                        </tr>

                                        <tr>
                                            <td><?php 
            _e('Total on Right Leg', 'binary-mlm-pro');
            ?>
: <?php 
            echo $rightLegUsers;
            ?>
</td>
                                            <td>Active: <?php 
            echo $rightLegActiveUsers;
            ?>
</td>
                                        </tr>
                                        <?php 
            foreach ($fiveRightLegUsers as $key => $value) {
                _e("<tr>");
                foreach ($value as $k => $val) {
                    _e("<td>" . $val . "</td>");
                }
                _e("</tr>");
            }
            ?>
                                        <tr>
                                            <td colspan="2"><a href="?page=mlm-user-account&ac=rightleg" style="text-decoration: none"> <?php 
            _e('View All', 'binary-mlm-pro');
            ?>
</a></td>
                                        </tr>

                                    </table>
                                </td>
                            </tr>


                            <tr>
                                <td>
                                    <table width="100%" border="0" cellspacing="10" cellpadding="1">
                                        <tr>
                                            <td colspan="2"><strong> <?php 
            _e('Personal Sales', 'binary-mlm-pro');
            ?>
</strong></td>
                                        </tr>

                                        <tr>
                                            <td> <?php 
            _e('My Personal Sales', 'binary-mlm-pro');
            ?>
: <?php 
            echo $personalSales;
            ?>
</td>
                                            <td>Active: <?php 
            echo $activePersonalSales;
            ?>
</td>
                                        </tr>
                                        <?php 
            foreach ($fivePersonalUsers as $key => $value) {
                _e("<tr>");
                foreach ($value as $k => $val) {
                    _e("<td>" . $val . "</td>");
                }
                _e("</tr>");
            }
            ?>
                                        <tr>
                                            <td colspan="2"><a href="?page=mlm-user-account&ac=personal" style="text-decoration: none"> <?php 
            _e('View All', 'binary-mlm-pro');
            ?>
</a></td>
                                        </tr>

                                    </table>
                                </td>
                            </tr> 

                        </table>
                    </td>
                </tr>
            </table>
        <?php 
        }
    }
    ?>
        <!---sdfdsfsd ->
        
        
                </div>
        <?php 
}
function mlmNetworkDetailsPage()
{
    //get loged user's key
    $key = get_current_user_key();
    //Total Users on My left leg
    $leftLegUsers = totalLeftLegUsers($key);
    //Total users on my right leg
    $rightLegUsers = totalRightLegUsers($key);
    //paid users on my left leg
    $leftLegActiveUsers = activeUsersOnLeftLeg($key);
    //paid users on my right leg
    $rightLegActiveUsers = activeUsersOnRightLeg($key);
    //Total my personal sales
    $personalSales = totalMyPersonalSales($key);
    //Total my personal sales active users
    $activePersonalSales = activeUsersOnPersonalSales($key);
    //show five users on left leg
    $fiveLeftLegUsers = myFiveLeftLegUsers($key);
    //show five users on right leg
    $fiveRightLegUsers = myFiveRightLegUsers($key);
    //show five users on personal sales
    $fivePersonalUsers = myFivePersonalUsers($key);
    //get logged in user info
    global $current_user, $wpdb;
    get_currentuserinfo();
    $username = $current_user->ID;
    $user_info = get_userdata($current_user->ID);
    $_SESSION['ajax'] = 'ajax_check';
    $add_page_id = get_post_id('mlm_registration_page');
    $sponsor_name = $current_user->user_login;
    $affiliateURLold = site_url() . '?page_id=' . $add_page_id . '&sp=' . $key;
    $affiliateURLnew = site_url() . '/u/' . getusernamebykey($key);
    $permalink = get_permalink(empty($_GET['page_id']) ? '' : $_GET['page_id']);
    $postidparamalink = strstr($permalink, 'page_id');
    $affiliateURL = $postidparamalink ? $affiliateURLold : $affiliateURLnew;
    ?>
    <?php 
    if (function_exists('Update_Paypal_Notification')) {
        Update_Paypal_Notification();
    }
    ?>
    <p class="affiliate_url"><strong>Affiliate URL :</strong> <?php 
    echo $affiliateURL;
    ?>
 </p><br />

    <table width="100%" border="0" cellspacing="10" cellpadding="1">
        <tr>
            <td width="40%" valign="top">
                <table width="100%" border="0" cellspacing="10" cellpadding="1">
                    <tr>
                        <td colspan="2"><strong> <?php 
    _e('Personal Information', 'binary-mlm-pro');
    ?>
</strong></td>
                    </tr>
                    <tr>
                        <td scope="row"><?php 
    _e('Title', 'binary-mlm-pro');
    ?>
</td>
                        <td> <?php 
    _e('Details', 'binary-mlm-pro');
    ?>
</td>
                    </tr>
                    <tr>
                        <td scope="row"> <?php 
    _e('Name', 'binary-mlm-pro');
    ?>
</td>
                        <td><?php 
    echo $user_info->first_name . ' ' . $user_info->last_name;
    ?>
</td>
                    </tr>
                    <tr>
                        <td scope="row"> <?php 
    _e('Address', 'binary-mlm-pro');
    ?>
</td>
                        <td style="white-space:normal;"><?php 
    echo $user_info->user_address1 . "<br>" . $user_info->user_address2;
    ?>
</td>
                    </tr>
                    <tr>
                        <td scope="row"> <?php 
    _e('City', 'binary-mlm-pro');
    ?>
</td>
                        <td><?php 
    echo $user_info->user_city;
    ?>
</td>
                    </tr>
                    <tr>
                        <td scope="row"> <?php 
    _e('Contact No', 'binary-mlm-pro');
    ?>
.</td>
                        <td><?php 
    echo $user_info->user_telephone;
    ?>
</td>
                    </tr>
                    <tr>
                        <td scope="row"> <?php 
    _e('DOB', 'binary-mlm-pro');
    ?>
</td>
                        <td><?php 
    echo $user_info->user_dob;
    ?>
</td>
                    </tr>



                    <tr>
                        <td><a href="<?php 
    echo get_post_id_or_postname('mlm_update_profile_page', 'binary-mlm-pro');
    ?>
" style="text-decoration: none"><?php 
    _e('Edit', 'binary-mlm-pro');
    ?>
</a></td>
                        <td><a href="<?php 
    echo get_post_id_or_postname('mlm_network_genealogy_page', 'binary-mlm-pro');
    ?>
" style="text-decoration: none"><?php 
    _e('View Genealogy', 'binary-mlm-pro');
    ?>
</a></td>
                    </tr>
                </table>
                <table width="100%" border="0" cellspacing="10" cellpadding="1">
                    <tr>
                        <td colspan="2"><strong><?php 
    _e('My Payouts', 'binary-mlm-pro');
    ?>
</strong></td>
                    </tr>
                    <tr>
                        <td scope="row"><?php 
    _e('Date', 'binary-mlm-pro');
    ?>
</td>
                        <td><?php 
    _e('Amount', 'binary-mlm-pro');
    ?>
</td>
                        <td><?php 
    _e('Action', 'binary-mlm-pro');
    ?>
</td>
                    </tr>
                    <?php 
    $detailsArr = my_payout_function();
    //_e("<pre>");print_r($detailsArr); exit;
    //$page_id = get_post_id('mlm_my_payout_details_page');
    if (count($detailsArr) > 0) {
        $mlm_settings = get_option('wp_mlm_general_settings');
        ?>
                        <?php 
        foreach ($detailsArr as $row) {
            $amount = $row->commission_amount + $row->bonus_amount + $row->referral_commission_amount - $row->tax - $row->service_charge;
            ?>
                            <tr>
                                <td><?php 
            echo $row->payoutDate;
            ?>
</td>
                                <td><?php 
            echo $mlm_settings['currency'] . ' ' . $amount;
            ?>
</td>
                                <td><a href="<?php 
            echo get_post_id_or_postname_for_payout('mlm_my_payout_details_page', $row->payout_id);
            ?>
"><?php 
            echo __('View', 'binary-mlm-pro');
            ?>
</a></td>

                            </tr>

                        <?php 
        }
        ?>
                        <?php 
    } else {
        ?>
                        <div class="no-payout"><?php 
        _e('You have not earned any commisssions yet.', 'binary-mlm-pro');
        ?>
 </div>

                        <?php 
    }
    ?>
                </table>
            </td>
            <td width="40%">
                <table width="100%" border="0" cellspacing="10" cellpadding="1">
                    <tr>
                        <td><strong><?php 
    _e('Network Details', 'binary-mlm-pro');
    ?>
</strong></td>
                    </tr>
                    <tr>
                        <td>
                            <table width="100%" border="0" cellspacing="10" cellpadding="1">
                                <tr>
                                    <td colspan="2"><strong><?php 
    _e('Left Leg Sales', 'binary-mlm-pro');
    ?>
</strong></td>
                                </tr>

                                <tr>
                                    <td><?php 
    _e('Total on Left Leg', 'binary-mlm-pro');
    ?>
: <?php 
    echo $leftLegUsers;
    ?>
</td>
                                    <td><?php 
    _e('Active', 'binary-mlm-pro');
    ?>
: <?php 
    echo $leftLegActiveUsers;
    ?>
</td>
                                </tr>
                                <?php 
    foreach ($fiveLeftLegUsers as $key => $value) {
        _e("<tr>");
        foreach ($value as $k => $val) {
            _e("<td>" . $val . "</td>");
        }
        _e("</tr>");
    }
    ?>
                                <tr>
                                    <td colspan="2"><a href="<?php 
    echo get_post_id_or_postname('mlm_left_group_details_page', 'binary-mlm-pro');
    ?>
" style="text-decoration: none"><?php 
    _e('View All', 'binary-mlm-pro');
    ?>
</a></td>
                                </tr>

                            </table>
                        </td>
                    </tr>

                    <tr>
                        <td>
                            <table width="100%" border="0" cellspacing="10" cellpadding="1">
                                <tr>
                                    <td colspan="2"><strong><?php 
    _e('Right Leg Sales', 'binary-mlm-pro');
    ?>
</strong></td>
                                </tr>

                                <tr>
                                    <td><?php 
    _e('Total on Right Leg', 'binary-mlm-pro');
    ?>
: <?php 
    echo $rightLegUsers;
    ?>
</td>
                                    <td><?php 
    _e('Active', 'binary-mlm-pro');
    ?>
: <?php 
    echo $rightLegActiveUsers;
    ?>
</td>
                                </tr>
                                <?php 
    foreach ($fiveRightLegUsers as $key => $value) {
        _e("<tr>");
        foreach ($value as $k => $val) {
            _e("<td>" . $val . "</td>");
        }
        _e("</tr>");
    }
    ?>
                                <tr>
                                    <td colspan="2"><a href="<?php 
    echo get_post_id_or_postname('mlm_right_group_details_page', 'binary-mlm-pro');
    ?>
" style="text-decoration: none"><?php 
    _e('View All', 'binary-mlm-pro');
    ?>
</a></td>
                                </tr>

                            </table>
                        </td>
                    </tr>


                    <tr>
                        <td>
                            <table width="100%" border="0" cellspacing="10" cellpadding="1">
                                <tr>
                                    <td colspan="2"><strong><?php 
    _e('Personal Sales', 'binary-mlm-pro');
    ?>
</strong></td>
                                </tr>

                                <tr>
                                    <td><?php 
    _e('My Personal Sales', 'binary-mlm-pro');
    ?>
: <?php 
    echo $personalSales;
    ?>
</td>
                                    <td><?php 
    _e('Active', 'binary-mlm-pro');
    ?>
: <?php 
    echo $activePersonalSales;
    ?>
</td>
                                </tr>
                                <?php 
    foreach ($fivePersonalUsers as $key => $value) {
        _e("<tr>");
        foreach ($value as $k => $val) {
            _e("<td>" . $val . "</td>");
        }
        _e("</tr>");
    }
    ?>
                                <tr>
                                    <td colspan="2"><a href="<?php 
    echo get_post_id_or_postname('mlm_personal_group_details_page', 'binary-mlm-pro');
    ?>
" style="text-decoration: none"><?php 
    _e('View All', 'binary-mlm-pro');
    ?>
</a></td>
                                </tr>

                            </table>
                        </td>
                    </tr> 

                </table>
            </td>
        </tr>
    </table>

    <?php 
}