function adminViewUnilevelNetwork($id) { $table_prefix = mlm_core_get_table_prefix(); //$obj = new UnilevelTree(); global $wpdb; get_currentuserinfo(); //get no. of level $mlm_general_settings = get_option('wp_mlm_general_settings'); $mlm_no_of_level = $mlm_general_settings['mlm-level']; $res = mysql_fetch_array(mysql_query("SELECT user_key FROM {$table_prefix}mlm_users WHERE user_id = '" . $id . "'")); $total = mysql_fetch_array(mysql_query("SELECT count(*) as num FROM {$table_prefix}mlm_hierarchy WHERE pid = '" . $res['user_key'] . "'")); $total = $total['num']; $member_page_id = $wpdb->get_var("SELECT id FROM {$table_prefix}posts WHERE `post_content` LIKE '%mlm-view-child-level-member%'\tAND `post_type` != 'revision'"); if (!empty($_GET['lvl']) && $_GET['lvl'] != '') { $level = $_GET['lvl']; $level_data = getLevelInfo($res['user_key'], $level); ?> <script type="text/javascript" src="http://www.google.com/jsapi"></script> <script type="text/javascript"> google.load('visualization', '1', {packages: ['table']}); </script> <script type="text/javascript"> var visualization; var data; var options = {'showRowNumber': true}; function drawVisualization() { // Create and populate the data table. var dataAsJson = {cols:[ {id:'A',label:'<?php echo _e("Username", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'B',label:'<?php echo _e("First Name", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'C',label:'<?php echo _e("Last Name", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'D',label:'<?php echo _e("Sponsor", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'E',label:'<?php echo _e("Email", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'F',label:'<?php echo _e("Status", "unilevel-mlm-pro"); ?> ',type:'string'}], rows:[ <?php for ($i = 0; $i < count($level_data); $i++) { ?> {c:[{v:'<?php echo $level_data[$i]['username']; ?> '}, {v:'<?php echo $level_data[$i]['first_name']; ?> '}, {v:'<?php echo $level_data[$i]['last_name']; ?> '}, {v:'<?php echo $level_data[$i]['sponsor']; ?> '}, {v:'<?php echo $level_data[$i]['email']; ?> '}, {v:'<?php echo $level_data[$i]['status']; ?> '}]}, <?php } ?> ]}; data = new google.visualization.DataTable(dataAsJson); // Set paging configuration options // Note: these options are changed by the UI controls in the example. options['page'] = 'enable'; options['pageSize'] = 10; options['pagingSymbols'] = {prev: 'prev', next: 'next'}; options['pagingButtonsConfiguration'] = 'auto'; //options['allowHtml'] = true; //data.sort({column:1, desc: false}); // Create and draw the visualization. visualization = new google.visualization.Table(document.getElementById('table')); draw(); } function draw() { visualization.draw(data, options); } google.setOnLoadCallback(drawVisualization); // sets the number of pages according to the user selection. function setNumberOfPages(value) { if (value) { options['pageSize'] = parseInt(value, 10); options['page'] = 'enable'; } else { options['pageSize'] = null; options['page'] = null; } draw(); } // Sets custom paging symbols "Prev"/"Next" function setCustomPagingButtons(toSet) { options['pagingSymbols'] = toSet ? {next: 'next', prev: 'prev'} : null; draw(); } function setPagingButtonsConfiguration(value) { options['pagingButtonsConfiguration'] = value; draw(); } </script> <!--va-matter--> <div class="va-matter"> <!--va-matterbox--> <div class="va-matterbox"> <!--va-headname--> <div class="va-headname"><strong><?php _e('Level ' . $level . ' Members', 'unilevel-mlm-pro'); ?> </strong></div> <!--/va-headname--> <div class="va-admin-leg-details"> <!--va-admin-mid--> <div class="paging"> <form action=""> <div class="left-side" style="width:30%;float:left;"> <?php _e('Display Number of Rows', 'unilevel-mlm-pro'); ?> : </div> <div class="right-side"> <select style="font-size: 12px" onchange="setNumberOfPages(this.value)"> <option value="5">5</option> <option selected="selected" value="10">10</option> <option value="20">20</option> <option value="50">50</option> <option value="100">100</option> <option value="500">500</option> <option value="">All</option> </select> </div> </form> <div class="right-members"> <?php _e('Total Records', 'unilevel-mlm-pro'); ?> : <strong><?php echo count($level_data); ?> </strong> </div> <div class="va-clear"></div> </div> <div id="table"></div> <div class="va-clear"></div> </div> </div> </div> <?php } else { ?> <table border="0" cellspacing="5" cellpadding="5" width="50%"> <TR> <TD align="center" ><strong><?php _e('Levels', 'unilevel-mlm-pro'); ?> </strong></TD> <TD align="center" > <strong><?php _e('No. of Members', 'unilevel-mlm-pro'); ?> </strong></TD> </TR> <?php for ($j = 1; $j <= $mlm_no_of_level; $j++) { if (returncountLevelMember($res['user_key'], $j) == 0) { $num = "Level " . $j; } else { $num = "<a href='?page=mlm-user-account&ac=network&lvl=" . $j . "'> Level " . $j . "</a>"; } ?> <TR> <TD align="center" ><strong><?php _e($num, 'unilevel-mlm-pro'); ?> </strong></TD> <TD align="center" > <?php _e(returncountLevelMember($res['user_key'], $j), 'unilevel-mlm-pro'); ?> </TD> </TR> <?php } ?> <TR> <TD align="center" ><strong><?php _e('Total', 'unilevel-mlm-pro'); ?> </strong></TD> <TD align="center" > <?php _e($total, 'unilevel-mlm-pro'); ?> </TD> </TR> </table> <?php } }
function viewUnilevelNetworkPage() { $table_prefix = mlm_core_get_table_prefix(); //$obj = new UnilevelTree(); global $current_user, $wpdb; get_currentuserinfo(); $username1 = $current_user->user_login; //get no. of level $mlm_general_settings = get_option('wp_mlm_general_settings'); $mlm_no_of_level = $mlm_general_settings['mlm-level']; $res = mysql_fetch_array(mysql_query("SELECT user_key FROM {$table_prefix}mlm_users WHERE username = '******'")); $total = mysql_fetch_array(mysql_query("SELECT count(*) as num FROM {$table_prefix}mlm_hierarchy WHERE pid = '" . $res['user_key'] . "'")); $total = $total['num']; $member_page_id = $wpdb->get_var("SELECT id FROM {$table_prefix}posts WHERE `post_content` LIKE '%mlm-view-child-level-member%'\tAND `post_type` != 'revision'"); /* $level[0]=countLevelMember($res['user_key']); $user[0]=returnMemberUserkey($res['user_key']); $total=$level[0]; for($i=1;$i<$mlm_no_of_level;$i++) { $user[$i]=returnMemberUserkey($user[$i-1]); $level[$i]=countLevelMember($user[$i-1]); if($level[$i]==0 || $level[$i]=='') { $level[$i]="No Any Members"; } else { $total=$level[$i]+$total; } }*/ //print_r($level); ?> <style type="text/css"> span.owner { color:#339966; font-style:italic; } span.paid { color: #669966!important; /*background-color:#770000; */ font-style:normal; } span.leg { color:red; font-style:italic; } </style> <script type="text/javascript" language="javascript"> function searchUser() { var user = document.getElementById("username").value; if(user=="") { alert("Please enter username then searched."); document.getElementById("username").focus(); return false; } } </script> <table border="0" cellspacing="0" cellpadding="0" > <tr> <td align="center"> <form name="usersearch" id="usersearch" action="" method="post" onSubmit="return searchUser();"> <input type="text" name="username" id="username"> <input type="submit" name="search" value="Search"> </form> </td> </tr> </table> <?php if (isset($_POST['search'])) { $Search = $_POST['username']; $qry = mysql_query("SELECT user_key,h.level as level FROM {$table_prefix}mlm_hierarchy as h INNER JOIN {$table_prefix}mlm_users as u ON u.user_key=h.cid WHERE h.pid = '" . $res['user_key'] . "' AND u.username LIKE ('%" . $Search . "%')"); $num = mysql_num_rows($qry); if ($num > 0) { while ($result = mysql_fetch_array($qry)) { $user = array(); $usr_dtls = mysql_fetch_array(mysql_query("SELECT user_id,username,sponsor_key,payment_status FROM {$table_prefix}mlm_users WHERE user_key='" . $result['user_key'] . "'")); $user['username'] = $usr_dtls['username']; $user['first_name'] = get_user_meta($usr_dtls['user_id'], 'first_name', true); $user['last_name'] = get_user_meta($usr_dtls['user_id'], 'last_name', true); $sponser_id = $usr_dtls['sponsor_key']; $user['sponsor'] = getusernamebykey($sponser_id); $email = $wpdb->get_var("SELECT user_email FROM {$table_prefix}users WHERE ID='" . $usr_dtls['user_id'] . "'"); $user['email'] = $email; $user['level'] = $result['level']; if ($usr_dtls['payment_status'] == 1) { $user['status'] = "Paid"; } else { $user['status'] = "Not Paid"; } $user_data[] = $user; } $level_data = $user_data; //print_r($level_data); ?> <script type="text/javascript" src="http://www.google.com/jsapi"></script> <script type="text/javascript"> google.load('visualization', '1', {packages: ['table']}); </script> <script type="text/javascript"> var visualization; var data; var options = {'showRowNumber': true}; function drawVisualization() { // Create and populate the data table. var dataAsJson = {cols:[ {id:'A',label:'<?php echo _e("Username", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'B',label:'<?php echo _e("First Name", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'C',label:'<?php echo _e("Last Name", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'D',label:'<?php echo _e("Sponsor", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'E',label:'<?php echo _e("Email", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'F',label:'<?php echo _e("Level", "unilevel-mlm-pro"); ?> ',type:'string'}, {id:'G',label:'<?php echo _e("Status", "unilevel-mlm-pro"); ?> ',type:'string'}], rows:[ <?php for ($i = 0; $i < count($level_data); $i++) { ?> {c:[{v:'<?php echo $level_data[$i]['username']; ?> '}, {v:'<?php echo $level_data[$i]['first_name']; ?> '}, {v:'<?php echo $level_data[$i]['last_name']; ?> '}, {v:'<?php echo $level_data[$i]['sponsor']; ?> '}, {v:'<?php echo $level_data[$i]['email']; ?> '}, {v:'<?php echo $level_data[$i]['level']; ?> '}, {v:'<?php echo $level_data[$i]['status']; ?> '} ]}, <?php } ?> ]}; data = new google.visualization.DataTable(dataAsJson); // Set paging configuration options // Note: these options are changed by the UI controls in the example. options['page'] = 'enable'; options['pageSize'] = 10; options['pagingSymbols'] = {prev: 'prev', next: 'next'}; options['pagingButtonsConfiguration'] = 'auto'; //options['allowHtml'] = true; //data.sort({column:1, desc: false}); // Create and draw the visualization. visualization = new google.visualization.Table(document.getElementById('table')); draw(); } function draw() { visualization.draw(data, options); } google.setOnLoadCallback(drawVisualization); // sets the number of pages according to the user selection. function setNumberOfPages(value) { if (value) { options['pageSize'] = parseInt(value, 10); options['page'] = 'enable'; } else { options['pageSize'] = null; options['page'] = null; } draw(); } // Sets custom paging symbols "Prev"/"Next" function setCustomPagingButtons(toSet) { options['pagingSymbols'] = toSet ? {next: 'next', prev: 'prev'} : null; draw(); } function setPagingButtonsConfiguration(value) { options['pagingButtonsConfiguration'] = value; draw(); } </script> <!--va-matter--> <div class="va-matter"> <!--va-matterbox--> <div class="va-matterbox"> <!--va-headname--> <div class="va-headname"><strong><?php _e('Search Results for:' . $Search, 'unilevel-mlm-pro'); ?> </strong></div> <!--/va-headname--> <div class="va-admin-leg-details"> <!--va-admin-mid--> <div class="paging"> <?php if (count($level_data) > 0) { ?> <form action=""> <div class="left-side" style="width:30%;float:left;"> <?php _e('Display Number of Rows', 'unilevel-mlm-pro'); ?> : </div> <div class="right-side"> <select style="font-size: 12px" onchange="setNumberOfPages(this.value)"> <option value="5">5</option> <option selected="selected" value="10">10</option> <option value="20">20</option> <option value="50">50</option> <option value="100">100</option> <option value="500">500</option> <option value="">All</option> </select> </div> </form> <?php } ?> <div class="right-members"> <?php _e('Total Records', 'unilevel-mlm-pro'); ?> : <strong><?php echo count($level_data); ?> </strong> </div> <div class="va-clear"></div> </div> <div id="table"></div> <div class="va-clear"></div> </div> </div> </div> <?php } else { ?> <p> No Search Result Found!</p> <?php } } else { ?> <table border="0" cellspacing="0" cellpadding="0" > <TR> <TD align="center" ><strong><?php _e('Levels', 'unilevel-mlm-pro'); ?> </strong></TD> <TD align="center" > <strong><?php _e('No. of Members', 'unilevel-mlm-pro'); ?> </strong></TD> </TR> <?php for ($j = 1; $j <= $mlm_no_of_level; $j++) { if (returncountLevelMember($res['user_key'], $j) == 0) { $num = "Level " . $j; } else { $num = "<a href='?page_id=" . $member_page_id . "&lvl=" . $j . "'> Level " . $j . "</a>"; } ?> <TR> <TD align="center" ><strong><?php _e($num, 'unilevel-mlm-pro'); ?> </strong></TD> <TD align="center" > <?php _e(returncountLevelMember($res['user_key'], $j), 'unilevel-mlm-pro'); ?> </TD> </TR> <?php } ?> <TR> <TD align="center" ><strong><?php _e('Total', 'unilevel-mlm-pro'); ?> </strong></TD> <TD align="center" > <?php _e($total, 'unilevel-mlm-pro'); ?> </TD> </TR> </table> <?php } ?> <div style="margin:0 auto;padding:0px;clear:both; width:100%!important;" align="center"> </div> <?php }