bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
    include('../webconfig/config.php');
    $con = new db();
    $getRow=$con->getRows("SELECT * FROM checkout");
    $i=0;
    $fillter=$_POST['fillter'];

if($_POST['fillter']=='Dealer'){

//dealer
    	foreach ($getRow as $value) {
    		$UserDetails=$con->getRow("SELECT * FROM members where id =?",array($value['user_id']));
    		if($UserDetails['user_type']=='Dealer' || $UserDetails['user_type']=='dealer'){
    		$i++;
    			?>
    			<tr>
    				<td><?php echo $i;?></td>
    				<td>#<?php echo $value['order_id'];?></td>
    				<td><?php echo $UserDetails['user_type'];?></td>
    				<td><?php echo $UserDetails['username'];?></td>
                    <td><?php echo $UserDetails['user_code'];?></td>
    				<td><?php echo $UserDetails['address'];?></td>
    				<td><?php echo $value['product_qty'];?></td>
    				<td><?php echo $value['qty'];?></td>
    				<td><?php echo $value['grand_total'];?></td>
    				<td><?php echo $value['created_date'];?></td>
    				<td><a class="btn btn-primary" onclick="OrderDetails(<?php echo $value['order_id'];?>)" href="#" style="margin-right: 5px;padding: 0px 5px;">View</a></td>
    			</tr>
    			<?php
    		}
    	}

//end dealer

}else if($_POST['fillter']=='Salesman'){

//salesman
    	foreach ($getRow as $value) {
    		$UserDetails=$con->getRow("SELECT * FROM members where id =?",array($value['user_id']));
    		if($UserDetails['user_type']=='salesman' || $UserDetails['user_type']=='Salesman'){
    		$i++;
    			?>
    			<tr>
    				<td><?php echo $i;?></td>
    				<td>#<?php echo $value['order_id'];?></td>
    				<td><?php echo $UserDetails['user_type'];?></td>
    				<td><?php echo $UserDetails['username'];?></td>
                    <td><?php echo $UserDetails['user_code'];?></td>
    				<td><?php echo $UserDetails['address'];?></td>
    				<td><?php echo $value['product_qty'];?></td>
    				<td><?php echo $value['qty'];?></td>
    				<td><?php echo $value['grand_total'];?></td>
    				<td><?php echo $value['created_date'];?></td>
    				<td><a class="btn btn-primary" onclick="OrderDetails(<?php echo $value['order_id'];?>)" href="#" style="margin-right: 5px;padding: 0px 5px;">View</a></td>
    			</tr>
    			<?php
    		}
    	}

//end salesman
    }else{

//both
    		foreach ($getRow as $value) {
    		$UserDetails=$con->getRow("SELECT * FROM members where id =?",array($value['user_id']));
    		if($UserDetails['user_type']=='Both' || $UserDetails['user_type']=='both'){
    		$i++;
    			?>
    			<tr>
    				<td><?php echo $i;?></td>
    				<td>#<?php echo $value['order_id'];?></td>
    				<td><?php echo $UserDetails['user_type'];?></td>
    				<td><?php echo $UserDetails['username'];?></td>
    				<td><?php echo $UserDetails['address'];?></td>
    				<td><?php echo $value['product_qty'];?></td>
    				<td><?php echo $value['qty'];?></td>
    				<td><?php echo $value['grand_total'];?></td>
    				<td><?php echo $value['created_date'];?></td>
    				<td><a class="btn btn-primary" onclick="OrderDetails(<?php echo $value['order_id'];?>)" href="#" style="margin-right: 5px;padding: 0px 5px;">View</a></td>
    			</tr>
    			<?php
    		}
    	}
    	//end both
    }