FM / ajax

/data/sites/web/unidosporsectorespt/htdocs/public/www/ajax/

/data/sites/web/unidosporsectorespt/htdocs/public/www/ajax

Name	Size	Mode	Actions
clientes.php	10097	0644	edit dl rm

Edit: /data/sites/web/unidosporsectorespt/htdocs/public/www/ajax/clientes.php (10097B)

<?php
	include ("../config/css.php");
	$section = $_GET['seccao'];
?>

<div style="width:100%; height:40px; padding-top:10px; text-align:center;">
    <div class="clients_pages">
		<?php    
            include ("../config/connection.php");
			
			$clients_per_page = 9;
			
			$max_pages_disp = 8;
            
            $q = "SELECT * FROM clientes WHERE zona = '$section'"; 
            
            $r = mysqli_query($dbc, $q);
            
            $amount_clients = mysqli_num_rows($r);
            
            $amount_pages = ceil($amount_clients / $clients_per_page);
            
			$current = substr($_GET['id'], 5);
			
			if($amount_pages >= 8){
				$left = $amount_pages - $current;
				//echo $current.' - '. $left;
				if($left >= $max_pages_disp - 1){
					if($current != 1){
						echo '
							<div class="clients_buttons">
								<button id="page_'.($current-1).'" class="btn-client">...</button>
							</div>
						';
						
						for($i = $current; $i < ($current + 6); $i++){
							echo '
								<div class="clients_buttons">
									<button id="page_'.$i.'" class="btn-client
							'; 
							if($_GET['id'] == 'page_'.$i){
								echo 'active"';
								$min_client = ($i-1)*$clients_per_page;
								$max_client = $i*$clients_per_page;
							}
							else
								echo '"';
							echo '>'.$i.'</button>
								</div>
							';	
						}
						echo '
							<div class="clients_buttons">
								<button id="page_'.($current+6).'" class="btn-client">...</button>
							</div>
						';		
					} else {
						for($i = $current; $i < ($current + 7); $i++){
							echo '
								<div class="clients_buttons">
									<button id="page_'.$i.'" class="btn-client
							'; 
							if($_GET['id'] == 'page_'.$i){
								echo 'active"';
								$min_client = ($i-1)*$clients_per_page;
								$max_client = $i*$clients_per_page;
							}
							else
								echo '"';
							echo '>'.$i.'</button>
								</div>
							';	
						}
						echo '
							<div class="clients_buttons">
								<button id="page_'.($current+7).'" class="btn-client">...</button>
							</div>
						';		
					}
				} else {
					$behind = $max_pages_disp - $left - 2;
					
					$begin = $current - $behind;
					
					echo '
						<div class="clients_buttons">
							<button id="page_'.($begin-1).'" class="btn-client">...</button>
						</div>
					';
					
					for($i = $begin; $i < $current; $i++){
						echo '
							<div class="clients_buttons">
								<button id="page_'.$i.'" class="btn-client
						'; 
						if($_GET['id'] == 'page_'.$i){
							echo 'active"';
							$min_client = ($i-1)*$clients_per_page;
							$max_client = $i*$clients_per_page;
						}
						else
							echo '"';
						echo '>'.$i.'</button>
							</div>
						';	
					}
					
					for($i = $current; $i <= $amount_pages; $i++){
						echo '
							<div class="clients_buttons">
								<button id="page_'.$i.'" class="btn-client
						'; 
						if($_GET['id'] == 'page_'.$i){
							echo 'active"';
							$min_client = ($i-1)*$clients_per_page;
							$max_client = $i*$clients_per_page;
						}
						else
							echo '"';
						echo '>'.$i.'</button>
							</div>
						';
					}
				}
			} else {
				for($i = 0; $i < $amount_pages; $i++){
					if($i < 7){
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="btn-client
						'; 
						if($_GET['id'] == 'page_'.($i+1)){
							echo 'active"';
							$min_client = $i*$clients_per_page;
							$max_client = ($i+1)*$clients_per_page;
						}
						else
							echo '"';
						echo '>'.($i+1).'</button>
							</div>
						';
					} else {
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="
						'; 
						if($i == 0) 
							echo 'active"';
						else
							echo '"';
						echo '>...</button>
							</div>
						';
						break;					
					}
				}
			}
        ?>
    </div>
</div>     
<div class="row" style="height: 810px; margin-top: 0px; margin-bottom: 0px; text-align:center;">
    <div class="center clients_list" style="height: auto; text-align:center;">
    	<?php
			$q = "SELECT * FROM clientes WHERE zona = '$section' ORDER BY nome ASC";  // ALTERAR PARA POR NOME!!!!!!!!!!!!!!!!!!!!!!!!
			
			$r = mysqli_query($dbc, $q);
			$i = 4.5;
			$j = 0;
			while($cliente = mysqli_fetch_assoc($r)){	
				if(($j >= $min_client) && ($j < $max_client)){				
					$query = "SELECT * FROM images WHERE id = $cliente[image]";
					
					$res = mysqli_query($dbc, $query);
					
					$image = mysqli_fetch_assoc($res);
					
					echo '
						<div style="float:left; width:30%; height: 250px; margin-left:'.$i.'%; margin-top:15px;">
							<div style="display: table; width:100%; height:20%;">
								<p class="clients_title"><a href="template/views/clientes/cliente.php?id='.$cliente['id'].'" target="_blank">'.$cliente['nome'].'</a></p>
							</div>
							<div class="clients_image">	
								<a href="template/views/clientes/cliente.php?id='.$cliente['id'].'" target="_blank"><img src="../../uploads/Clientes/'.$cliente['nome'].'/'.$image['file'].'" width="90%" height="100%" alt=""/></a>
							</div>
						</div>
					';
				}
				$j++;
				if(($j % 3) != 0)
					$i = 0.5;
				else
					$i = 4.5;
			}
		 ?> 
    </div>
</div> 
<div style="width:100%; height:40px; padding-top:10px; text-align:center;">
    <div class="clients_pages">
		<?php    
            include ("../config/connection.php");
			
			$clients_per_page = 9;
			
			$max_pages_disp = 8;
            
            $q = "SELECT * FROM clientes WHERE zona = '$section'"; 
            
            $r = mysqli_query($dbc, $q);
            
            $amount_clients = mysqli_num_rows($r);
            
            $amount_pages = ceil($amount_clients / $clients_per_page);
            
			$current = substr($_GET['id'], 5);
			
			if($amount_pages >= 8){
				$left = $amount_pages - $current;
				//echo $current.' - '. $left;
				if($left >= $max_pages_disp - 1){
					if($current != 1){
						echo '
							<div class="clients_buttons">
								<button id="page_'.($current-1).'" class="btn-client">...</button>
							</div>
						';
						
						for($i = $current; $i < ($current + 6); $i++){
							echo '
								<div class="clients_buttons">
									<button id="page_'.$i.'" class="btn-client
							'; 
							if($_GET['id'] == 'page_'.$i){
								echo 'active"';
								$min_client = ($i-1)*$clients_per_page;
								$max_client = $i*$clients_per_page;
							}
							else
								echo '"';
							echo '>'.$i.'</button>
								</div>
							';	
						}
						echo '
							<div class="clients_buttons">
								<button id="page_'.($current+6).'" class="btn-client">...</button>
							</div>
						';		
					} else {
						for($i = $current; $i < ($current + 7); $i++){
							echo '
								<div class="clients_buttons">
									<button id="page_'.$i.'" class="btn-client
							'; 
							if($_GET['id'] == 'page_'.$i){
								echo 'active"';
								$min_client = ($i-1)*$clients_per_page;
								$max_client = $i*$clients_per_page;
							}
							else
								echo '"';
							echo '>'.$i.'</button>
								</div>
							';	
						}
						echo '
							<div class="clients_buttons">
								<button id="page_'.($current+7).'" class="btn-client">...</button>
							</div>
						';		
					}
				} else {
					$behind = $max_pages_disp - $left - 2;
					
					$begin = $current - $behind;
					
					echo '
						<div class="clients_buttons">
							<button id="page_'.($begin-1).'" class="btn-client">...</button>
						</div>
					';
					
					for($i = $begin; $i < $current; $i++){
						echo '
							<div class="clients_buttons">
								<button id="page_'.$i.'" class="btn-client
						'; 
						if($_GET['id'] == 'page_'.$i){
							echo 'active"';
							$min_client = ($i-1)*$clients_per_page;
							$max_client = $i*$clients_per_page;
						}
						else
							echo '"';
						echo '>'.$i.'</button>
							</div>
						';	
					}
					
					for($i = $current; $i <= $amount_pages; $i++){
						echo '
							<div class="clients_buttons">
								<button id="page_'.$i.'" class="btn-client
						'; 
						if($_GET['id'] == 'page_'.$i){
							echo 'active"';
							$min_client = ($i-1)*$clients_per_page;
							$max_client = $i*$clients_per_page;
						}
						else
							echo '"';
						echo '>'.$i.'</button>
							</div>
						';
					}
				}
			} else {
				for($i = 0; $i < $amount_pages; $i++){
					if($i < 7){
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="btn-client
						'; 
						if($_GET['id'] == 'page_'.($i+1)){
							echo 'active"';
							$min_client = $i*$clients_per_page;
							$max_client = ($i+1)*$clients_per_page;
						}
						else
							echo '"';
						echo '>'.($i+1).'</button>
							</div>
						';
					} else {
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="
						'; 
						if($i == 0) 
							echo 'active"';
						else
							echo '"';
						echo '>...</button>
							</div>
						';
						break;					
					}
				}
			}
        ?>
    </div>
</div>

cmd: