File Manager

✏️ Edit File: /var/www/vhosts/dzfarer.com/httpdocs/admin/includes/commune.php

<?php

require_once('bd.php');
require_once('fonctions.php');

class Communes {
	
	protected static $nom_table="communes";
	protected static $champs = array('id','code_postal', 'nom', 'wilaya_id', 'latitude', 'longitude');
	public $id;
	public $code_postal;
	public $nom;
	public $wilaya_id;
	public $latitude;
	public $longitude;

protected static function instancier($record) {
		$object = new self;
		foreach ($record as $attribute => $value) {
			if ($object->has_attribute($attribute)) {
				$object->$attribute = $value;
			}
		}
		return $object;
	}
	public static function rechercher_par_nom($term) {
		$sql = "SELECT * FROM communes WHERE nom LIKE '%$term%' ORDER BY nom ASC LIMIT 10";
		return self::trouve_par_sql($sql);
	}
	
	
	public static function trouve_communes_par_id_wilayas($id){
	$q =  "SELECT * FROM ".self::$nom_table;
	$q .= " WHERE wilaya_id ={$id}";
    return  self::trouve_par_sql($q);
	}
	public static function trouve_par_nom($nom){
	$q =  "SELECT * FROM communes WHERE nom LIKE '%$nom%'";
    return  self::trouve_par_sql($q);
	}
	public static function trouve_exact($nom){
	 $result_array = self::trouve_par_sql("SELECT * FROM communes WHERE nom = '{$nom}' ");
    return !empty($result_array) ? array_shift($result_array) : false;
	}
	public function date_der(){
	global $bd;
     $sql  = "UPDATE ".self::$nom_table." SET ";
     $sql .= "date_der  = '".mysql_datetime()."' ";
	 $sql .= " WHERE id =".$this->id." ";
	 $sql .= "LIMIT 1 ";
	
	 $result_array = self::trouve_par_sql($sql);
		return !empty($result_array) ? array_shift($result_array) : false;
	}
	
	public  function  existe(){
	 global $bd;
	 $sql  = "SELECT * FROM ".self::$nom_table." ";
    $sql .= "WHERE taux = '".$this->taux."'";
    $sql .= "AND id_societe = '".$this->id_societe."'";
    $sql .= "LIMIT 1";
    $result_array = self::trouve_par_sql($sql);
		return !empty($result_array) ? array_shift($result_array) : false;
	}

public static function count(){
	
	$users = self::not_admin();
	return count($users);
	}

public static function trouve_par_type($type){
	$q =  "SELECT * FROM ".self::$nom_table;
	$q .= " WHERE type ='{$type}'";
    return  self::trouve_par_sql($q);
	}
	
	// les fonction commun entre les classe
	public static function trouve_tous() {
		return self::trouve_par_sql("SELECT * FROM ".self::$nom_table);
  }

public static function trouve_par_id($id=0) {
    $result_array = self::trouve_par_sql("SELECT * FROM ".self::$nom_table." WHERE id={$id} LIMIT 1");
		return !empty($result_array) ? array_shift($result_array) : false;
  }

public static function trouve_par_last($id=0) {
    $result_array = self::trouve_par_sql("SELECT * FROM ".self::$nom_table." where num_fac != '0'  ORDER BY `id_vent` DESC LIMIT 1");
		return !empty($result_array) ? array_shift($result_array) : false;
  }

// pour que ne tompa dans des erreurs foux qu'on selection tous "SELECT * FROM" 
  public static function trouve_par_sql($sql="") {
    global $bd;
    $result_set = $bd->requete($sql);
    $object_array = array();
    while ($row = $bd->fetch_array($result_set)) {
      $object_array[] = self::instantiate($row);
    }
	/* // on peu utiliser la fonction predefinit mysqli_fetch_object
	   // mais dans le cas o� il y a de jointure dans la requete.... 
	while ($object = $bd->fetch_object($result_set)){
	  $object_array[] = $object;
	}
	*/
    return $object_array;
  }

private static function instantiate($record) {
		// Could check that $record exists and is an array
    $object = new self;
		// Simple, long-form approach:
		// $object->id 				= $record['id'];
		// $object->login 	= $record['login'];
		// $object->mot_passe 	= $record['mot_passe'];
		// $object->nom = $record['nom'];
		// $object->prenom 	= $record['prenom'];
		
		// More dynamic, short-form approach:
		foreach($record as $attribute=>$value){
		  if($object->has_attribute($attribute)) {
		    $object->$attribute = $value;
		  }
		}
		return $object;
	}
	
	private function has_attribute($attribute) {
	  // get_object_vars returns an associative array with all attributes 
	  // (incl. private ones!) as the keys and their current values as the value
	  $object_vars = $this ->attributes();
	  // We don't care about the value, we just want to know if the key exists
	  // Will return true or false
	  return array_key_exists($attribute, $object_vars);
	}

public function save(){
	 // A new record won't have an id yet.
	 return isset($this->id)? $this->modifier() : $this->ajouter();
	}
	
	protected function attributes(){
	// return an array of attribute keys and their values
	 $attributes = array();
	 foreach(self::$champs as $field){
	     if(property_exists($this, $field)){
		     $attributes[$field] = $this->$field; 
		 }
	 }
	 return $attributes;
	}
	
	protected function sanitized_attributes(){
	 global $bd;
	 $clean_attributes = array();
	 // sanitize the values before submitting
	 // note : does not alter the actual value of each attribute
	 foreach($this->attributes() as $key => $value){
	   $clean_attributes[$key] = $bd->escape_value($value);
	 }
	  return $clean_attributes;
	}
	
	public function ajouter(){
	 global $bd;
	 $attributes = $this->sanitized_attributes();
	 $sql = "INSERT INTO ".self::$nom_table."(";
	 $sql .= join(", ", array_keys($attributes));
	 $sql .= ") VALUES (' ";
	 $sql .= join("', '", array_values($attributes));
	 $sql .= "')";
	 if($bd->requete($sql)){
	     $this->id = $bd->insert_id();
		 return true;
	 }else{
	     return false;
	 }
	}
	
    public function modifier(){
global $bd;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
 $attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "update ".self::$nom_table." SET ";
$sql .= join(", ", $attribute_pairs);
$sql .= " WHERE id =". $bd->escape_value($this->id) ;
$bd->requete($sql);
return($bd->affected_rows() == 1) ? true : false ;
}
	    public function modifier_num(){
global $bd;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
 $attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "update ".self::$nom_table." SET ";
$sql .= "n_immatriculation = '".$this->n_immatriculation."' ";
$sql .= " WHERE id =". $bd->escape_value($this->id) ;
$bd->requete($sql);
return($bd->affected_rows() == 1) ? true : false ;
}
	
public function supprime(){
global $bd;
$sql = "DELETE FROM ".self::$nom_table;
$sql .= " WHERE id =". $bd->escape_value($this->id) ;
$sql .=" LIMIT 1";
$bd->requete($sql);
return($bd->affected_rows() == 1) ? true : false ;
	}

}

Batal

⬅ Naik ke admin 16 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘accounts.php	php	11.6 KB	2025-06-19 09:58	✏️ Edit 👁️ View
🐘bd.php	php	3.6 KB	2025-06-19 09:12	✏️ Edit 👁️ View
🐘commune.php	php	6.5 KB	2025-06-22 12:40	✏️ Edit 👁️ View
🐘config.php	php	314 B	2025-06-17 09:09	✏️ Edit 👁️ View
🐘db_backup_library.php	php	6.7 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘faq.php	php	8.9 KB	2025-06-25 14:01	✏️ Edit 👁️ View
🐘fonction.php	php	5.3 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘fonctions.php	php	10.1 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘guides.php	php	6.1 KB	2025-07-01 17:58	✏️ Edit 👁️ View
🐘initialiser.php	php	989 B	2025-06-29 20:52	✏️ Edit 👁️ View
🐘lieux_visite.php	php	8.8 KB	2025-07-09 22:05	✏️ Edit 👁️ View
🐘parametre.php	php	10.1 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘session.php	php	3 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘stores.php	php	5.8 KB	2025-06-28 21:06	✏️ Edit 👁️ View
🐘transports.php	php	8.5 KB	2025-06-22 12:22	✏️ Edit 👁️ View
🐘villes.php	php	5.5 KB	2025-06-17 09:07	✏️ Edit 👁️ View