FM / clientes

/data/sites/web/unidosporsectorespt/htdocs/public/www/admin/clientes/

/data/sites/web/unidosporsectorespt/htdocs/public/www/admin/clientes

Name	Size	Mode	Actions
adicionar.php	4789	0644	edit dl rm
alterar.php	7728	0644	edit dl rm
remover.php	2296	0644	edit dl rm

Edit: /data/sites/web/unidosporsectorespt/htdocs/public/www/admin/clientes/alterar.php (7728B)

<?php include ("../config/connection.php");?>
<link rel="stylesheet" type="text/css" href="css/dropzone.css">

<?php
	if($_POST['submitted'] == 2){
		$q = "SELECT * FROM clientes WHERE id = $_POST[client_id]";	
		
		$r = mysqli_query($dbc, $q);
		
		$current = mysqli_fetch_assoc($r);
		
		if(isset($_POST['name'])){			
			$q = "UPDATE clientes SET nome = '$_POST[name]' WHERE id = $_POST[client_id]";	
			
			$r = mysqli_query($dbc, $q);
			
			$query = "UPDATE images SET cliente = '$_POST[name]' WHERE id = $current[image]";
			
			mysqli_query($dbc, $query);	
			
			rename("../uploads/Clientes/$current[nome]", "../uploads/Clientes/$_POST[name]");
		}
		if(isset($_POST['zona'])){		
			$q = "UPDATE clientes SET zona = '$_POST[zona]' WHERE id = $_POST[client_id]";	
			
			$r = mysqli_query($dbc, $q);	
		}
		if(isset($_POST['rua'])){	
			$q = "UPDATE clientes SET rua = '$_POST[rua]' WHERE id = $_POST[client_id]";	
			
			$r = mysqli_query($dbc, $q);
		}
		if(isset($_POST['lat'])){
			$q = "UPDATE clientes SET latitude = '$_POST[lat]' WHERE id = $_POST[client_id]";	
			
			$r = mysqli_query($dbc, $q);
		}
		if(isset($_POST['long'])){
			$q = "UPDATE clientes SET longitude = '$_POST[long]' WHERE id = $_POST[client_id]";	
			
			$r = mysqli_query($dbc, $q);
		}
		if(isset($_POST['desc'])){
			$q = "UPDATE clientes SET descricao = '$_POST[desc]' WHERE id = $_POST[client_id]";	
			
			$r = mysqli_query($dbc, $q);
		}
		
		$q = "SELECT * FROM images WHERE cliente = 'undefined'";
		
		$r = mysqli_query($dbc, $q);
				
		$name = str_replace(" ", "\ ", $_POST['name']);
				
		while($image = mysqli_fetch_assoc($r)){	
			$query = "UPDATE images SET cliente = '$_POST[name]' WHERE id = $image[id] AND cliente = 'undefined'";
			
			mysqli_query($dbc, $query);	
				
			$name = str_replace(" ", "\ ", $_POST['name']);
			
			rename("../uploads/$image[file]", "../uploads/Clientes/$_POST[name]/$image[file]");
												
			chmod("../uploads/Clientes/$_POST[name]/$image[file]", 0777);
			
			//if(strpos($image['name'], 'grande') !== false){
				$q = "SELECT * FROM images WHERE id = $current[image]";
				$res = mysqli_query($dbc, $q);
				
				$old = mysqli_fetch_assoc($res);
				
				system("rm ../uploads/Clientes/$name/$old[file]");		
				
				$q = "DELETE FROM images WHERE id = $current[image]";
				mysqli_query($dbc, $q);
				
				$q = "UPDATE clientes SET image = '$image[id]' WHERE id = $_POST[client_id]";	
			
				mysqli_query($dbc, $q);	
			/*} else {
				$q = "SELECT * FROM images WHERE id = $current[thumbnail]";
				$res = mysqli_query($dbc, $q);
				
				$old = mysqli_fetch_assoc($res);
				
				system("rm ../uploads/Clientes/$name/$old[file]");				
				
				$q = "DELETE FROM images WHERE id = $current[thumbnail]";
				mysqli_query($dbc, $q);
				
				$q = "UPDATE clientes SET thumbnail = '$image[id]' WHERE id = $_POST[client_id]";	
			
				mysqli_query($dbc, $q);					
			}*/	
		}
		echo '<p style="color:white;">Cliente '.$_POST['name'].' alterado com sucesso!</p>';
	}
?>

<form action="index.php?page=clientes&clientes=alterar" method="post" role="form">
    <div class="form-group">
        <label for="name">Seleccione o cliente que deseja alterar:</label>
        <select class="form-control" type="text" name="name" id="name" placeholder="Nome da imagem a remover">
            <option value=""></option>
            <?php
                $q = "SELECT * FROM clientes ORDER BY nome ASC";
                
                $r = mysqli_query($dbc, $q);
                
                while($cliente = mysqli_fetch_assoc($r)){
					?>
                    	<option <?php if($_POST['submitted'] == 1 && $_POST['name'] == $cliente['id']) echo "selected"; ?> value="<?php echo $cliente['id']; ?>"><?php echo $cliente['nome']; ?></option>
                    <?php
                }
            ?>
        </select>
    </div>
    
    <button type="submit" class="form-button">Alterar Cliente</button>
    <input type="hidden" name="submitted" value="1">
</form>

<?php
	if($_POST['submitted'] == 1){
		$q = "SELECT * FROM clientes WHERE id = $_POST[name]";
		
		$r = mysqli_query($dbc, $q);
		
		$selected = mysqli_fetch_assoc($r);
		?>		
		<form action="index.php?page=clientes&clientes=alterar" method="post" role="form">
            <div class="form-group">
                <label for="name">Empresa:</label>
                <input class="form-control" value="<?php echo $selected['nome']; ?>" type="text" name="name" id="name" placeholder="Nome da Empresa">
            </div>
            
            <div class="form-group">
                <label for="zona">Zona de actividade:</label>
                <select class="form-control" type="text" name="zona" id="zona" placeholder="Nome da imagem a remover">
                    <option value=""></option>
                    <option <?php if($selected['zona'] == 'auto') echo "selected"; ?> value="auto">Automóveis</option>
                    <option <?php if($selected['zona'] == 'comercio') echo "selected"; ?> value="comercio">Comércio</option>
                    <option <?php if($selected['zona'] == 'educacao') echo "selected"; ?> value="educacao">Educação</option>
                    <option <?php if($selected['zona'] == 'hotel') echo "selected"; ?> value="hotel">Hotelaria e Turismo</option>
                    <option <?php if($selected['zona'] == 'industria') echo "selected"; ?> value="industria">Indústria e Construção</option>
                    <option <?php if($selected['zona'] == 'lazer') echo "selected"; ?> value="lazer">Lazer e Bem Estar</option>
                    <option <?php if($selected['zona'] == 'saude') echo "selected"; ?> value="saude">Saúde</option>
                    <option <?php if($selected['zona'] == 'servicos') echo "selected"; ?> value="servicos">Serviços</option>    
                    <option <?php if($selected['zona'] == 'sociedade') echo "selected"; ?> value="sociedade">Sociedade e Administração Pública</option>               
                </select>
            </div>
            
            <div class="form-group">
                <label for="rua">Rua:</label>
                <input class="form-control" value="<?php echo $selected['rua']; ?>" type="text" name="rua" id="rua" placeholder="Rua onde se encontra sediada">
            </div>
            
            <div class="form-group">
                <label for="lat">Latitude:</label>
                <input class="form-control" value="<?php echo $selected['latitude']; ?>" type="text" name="lat" id="lat" placeholder="Coordenada latitude da posição geofráfica">
            </div>
            
            <div class="form-group">
                <label for="long">Longitude:</label>
                <input class="form-control" value="<?php echo $selected['longitude']; ?>" type="text" name="long" id="long" placeholder="Coordenada longitude da posição geofráfica">
            </div>
            
            <div class="form-group">
                <label for="desc">Descricao:</label>
                <textarea class="form-control" rows="5" name="desc" id="desc" placeholder="Descricao da Empresa"><?php echo $selected['descricao']; ?></textarea>
            </div>
            
            <button type="submit" class="form-button">Alterar Cliente</button>
            <input type="hidden" name="submitted" value="2">
            <input type="hidden" name="client_id" value="<?php echo $selected['id']; ?>">
        </form>
        
        <form action="uploadClientes.php" target="_blank" class="dropzone" id="revdropzone">
            <label for="file">Escolha o logo da Empresa:</label>
            <input type="file" name="file" id="file" style="display:none;">
		</form>
		<?php
	}
?>

cmd: