<section role="main" class="content-body">
					<header class="page-header">
						<h2>Manage Earned Points</h2>
						<div class="right-wrapper pull-right">
							<ol class="breadcrumbs">
								<li>
									<a href="<?php echo base_url();?>admin">
										<i class="fa fa-home"></i>
									</a>
								</li>
								<li><span>Manage Earned Points</span></li>
							</ol>
					
						</div>
					</header>
						<section class="panel">
							<header class="panel-heading">
								<h2 class="panel-title">List of All Users Earned Points</h2>
							</header>
							<div class="panel-body">
								<table class="table table-bordered table-striped mb-none" id="datatable-tabletools" data-swf-path="assets/vendor/jquery-datatables/extras/TableTools/swf/copy_csv_xls_pdf.swf">
       		 <thead><tr><th>S.No</th><th>User</th><th>BidCount</th><th>Earned Points</th><th>Status</th></th></tr></thead>
                                <tbody>
                                <?php $i=1;foreach($earn as $e){
                               // $d1=strtotime($e->earn_date);
                                //$d2=strtotime(date("Y-m-d"));
								//$days_between = ceil(abs($d2 - $d1) / 86400);?>
                                <tr><td><?php echo $i;?></td>
                                	<td><?php echo $e->username?></td>
                                    <td><?php $this->db->select_sum('bidcount');  
											  //$this->db->where("earn_date",$e->earn_date); 
											  $this->db->where("userid",$e->userid); 
											  $bidcount=$this->db->get('earned_dis')->row();echo $bidcount->bidcount;?></td>
                                    <td><?php $this->db->select_sum('earn_amt');  
											  //$this->db->where("earn_date",$e->earn_date); 
											  $this->db->where("userid",$e->userid); 
											  $earn_amt=$this->db->get('earned_dis')->row();
								echo $earn_amt->earn_amt;//*$this->session->userdata("rate");?></td>
								<td><?php //if($days_between>7){echo "Available";}else{echo "Pending";}?> </td>
                                <?php $i++;}?>
                                </tbody>
                            </table>
							</div>
						</section>
				</section>
                
			</div>

			
		</section>

		<!-- Vendor -->
        
	<script src="<?php echo base_url();?>admin_assets/vendor/jquery-browser-mobile/jquery.browser.mobile.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/bootstrap/js/bootstrap.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/nanoscroller/nanoscroller.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/magnific-popup/magnific-popup.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/jquery-placeholder/jquery.placeholder.js"></script>
		
		<!-- Specific Page Vendor -->
		<script src="<?php echo base_url();?>admin_assets/vendor/select2/select2.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/jquery-datatables/media/js/jquery.dataTables.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/jquery-datatables/extras/TableTools/js/dataTables.tableTools.min.js"></script>
		<script src="<?php echo base_url();?>admin_assets/vendor/jquery-datatables-bs3/assets/js/datatables.js"></script>
		
		<!-- Theme Base, Components and Settings -->
		<script src="<?php echo base_url();?>admin_assets/javascripts/theme.js"></script>
		
		<!-- Theme Custom -->
		<script src="<?php echo base_url();?>admin_assets/javascripts/theme.custom.js"></script>
		
		<!-- Theme Initialization Files -->
		<script src="<?php echo base_url();?>admin_assets/javascripts/theme.init.js"></script>


		<!-- Examples -->
		<script src="<?php echo base_url();?>admin_assets/javascripts/tables/examples.datatables.default.js"></script>
		<script src="<?php echo base_url();?>admin_assets/javascripts/tables/examples.datatables.row.with.details.js"></script>
		<script src="<?php echo base_url();?>admin_assets/javascripts/tables/examples.datatables.tabletools.js"></script>
</body>
</html>