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');
        ?>
 : &nbsp; 
					</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 
    }
}
Ejemplo n.º 2
0
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');
                ?>
 : &nbsp; 
					</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 
}