<?php require_once('header.php'); ?>
<script type="text/javascript">
	$(document).ready(function() {
		 $('#branch_ids').on('change', function(){	
		 		var client_id=$('#branch_ids').val();		     
			      window.location.replace("client-new.php?id="+client_id);			      
			  } );

					} );
</script>

<?php if($session_id==1 || $allPermissions['client']['read']=="1"){ ?>
<section class="content-header" style="background-color: white;">
    
    <div class="row">
		<div class="col-md-4" style="text-align: left;">
			<h4><i class="fa fa-map-marker"></i> Client Details</h4>
		</div>
		<div class="col-md-8" style="text-align: right;"> 
		   <?php if($session_id==1 || $allPermissions['client']['create']=="1"){ ?> 
		   <a href="add-client-new.php" class="btn btn-success btn-sm"><i class="fa fa-plus"></i> Create New Client</a>
		   <?php } ?>
		    
		    <a href="client-new.php" class="btn btn-warning btn-sm"><i class="fa fa-arrow-left"></i> Back to Client List</a>
		</div>
	</div> 
	
	<div class="row">
	    <div class="col-12 col-sm-12 col-md-3 col-lg-3">
	        <?php if(isset($_GET['id'])){
							$branch=$_GET['id'];
							}
							else{
								$branch=0;
							} ?>
			<select class="form-control select2" name="branch_ids" id="branch_ids">

	        <?php if($session_id==1){ ?> <option value="">All Branch</option> <?php } ?>
	        <?php
			$statement = $pdo->prepare("SELECT * FROM tbl_branch WHERE 1=1 $tbl_branch_role");
			$statement->execute();
			$result = $statement->fetchAll(PDO::FETCH_ASSOC);	
			foreach ($result as $row) {
				?>
				<option value="<?php echo $row['id']; ?>"><?php echo $row['name']; ?></option>
				<?php
			}
			?>
	    </select>
	    </div>
	</div><br>
<!--</section>

<section class="content">-->
	<div class="row">
		<div class="col-md-12">
			<div class="box box-warning" <?=$border_style?>>
				<div class="box-body table-responsive">
					<table id="example1" class="table table-bordered table-striped">
						<thead>
							<tr>
								<th width="30">SL</th>
								<th>Action</th>
								<th>Name</th>
								<th>Code</th>
								<th>Branch Name</th>
								<th>Phone</th>
								<th>GST Number</th>
								<th width="120px;">Address</th>
								<th>City</th>
								<th>State</th>
								<th>Pincode</th>
								<th>Status</th>
							</tr>
						</thead>
						<tbody>
							<?php
							$i=0;
							if(isset($_GET['id']) && $_GET['id']!=0 ){
							$branch_id="and tbl_client_new.branch_id=".$_GET['id'];
							}
							else{
								$branch_id="";
							}
							
                            if($session_id!=1){
                                $branch_id.=" and tbl_client_new.branch_id in (".$session_branch_ids.")";
                            }
							
							
							$statement = $pdo->prepare("SELECT tbl_client_new.*,
							tbl_branch.name as branch_name
							FROM tbl_client_new 
							LEFT JOIN tbl_branch ON tbl_branch.id=tbl_client_new.branch_id
							where 1=1 $branch_id");
							$statement->execute();
							$result = $statement->fetchAll(PDO::FETCH_ASSOC);
							foreach ($result as $row) {
								$i++;
								?>
								<tr>
								    <td><?php echo $i; ?></td>
								    <td>										
									<?php if($session_id==1 || $allPermissions['client']['update']=="1"){ ?>
									<a href="cient-new-edit.php?id=<?php echo $row['id']; ?>" class="btn btn-primary btn-xs">Edit</a>
									<?php } ?>
									<?php if($session_id==1 || $allPermissions['client']['delete']=="1"){ ?>
									<a href="#" class="btn btn-danger btn-xs" data-href="client-new-delete.php?id=<?php echo $row['id']; ?>" data-toggle="modal" data-target="#confirm-delete">Delete</a> 
									<?php } ?>
									</td>
									<td><?php echo $row['name']; ?></td>
									<td><?php echo $row['id']; ?></td>
									<td><?php echo $row['branch_name']; ?></td>
									<td><?php echo $row['phone_no']; ?></td>
									<td><?php echo $row['gst_no']; ?></td>
									<td><?php echo $row['address']; ?></td>	
									<td><?php echo $row['city']; ?></td>
									<td><?php echo $row['state']; ?></td>
									<td><?php echo $row['pincode']; ?></td>
									<td><?php if($row['status']=='1'){ echo '<button class="btn btn-xs btn-success">Active</button>'; } else { echo '<button class="btn btn-xs btn-danger">Inactive</button>'; } ?></td>
									
								</tr>
								<?php
							}
							?>							
						</tbody>
					</table>
				</div>
			</div>
		</div>
	</div>


</section>


<div class="modal fade" id="confirm-delete" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title" id="myModalLabel">Delete Confirmation</h4>
            </div>
            <div class="modal-body">
                <p>Are you sure want to delete this item? item Will be Moved Inactive</p>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
                <a class="btn btn-danger btn-ok">Delete</a>
            </div>
        </div>
    </div>
</div>
<?php }else{ ?>
<center><h4 style="color:red;">You don't have permission to view this page </h4></center>
<?php } ?>
<?php require_once('footer.php'); ?>