<?

$variable['users_table']='users';
$variable['offres_table']='offres';
$variable['dossiers_table']='dossiers';
$variable['caract_table']='catacter';
$variable['photo_table']='photos';
$variable['prosp_table']='prospect';
$variable['mysqlhost'] = 'sql.toile-libre.org';
$variable['mysqluser'] = 'kabedistes_jom';
$variable['mysqlpass'] = 'msoura1124';
$variable['dbname'] = ' kabedistes_jom';
#define('SERVER_ROOT', $_SERVER['DOCUMENT_ROOT']);
#define('SERVER_ROOT','/data/web/f/7/kabkab.toile-libre.org/htdocs');

define('SMARTY_DIR', SERVER_ROOT.'/Smarty/');
define('SERVER_HOST', 'http://'.$_SERVER['HTTP_HOST']);
define('SERVER_IMAGES',SERVER_HOST.'/Images/');
define('REP_INCLUSION','Includes/');
define('SERVER_INC',SERVER_HOST.'/'.REP_INCLUSION);
define('REGIE_INC',SERVER_HOST.'/regie/Includes/');
define('DOSS_PHOTOS','/illust/');
define('REP_PHOTOS',SERVER_HOST.DOSS_PHOTOS);
define('ROT_PHOTOS',SERVER_ROOT.DOSS_PHOTOS);

define('USERS_TABLE','users');
define('OFFRES_TABLE','offres');
define('DOSSIERS_TABLE','dossiers');
define('CARACT_TABLE','catacter');
define('PHOTO_TABLE','photos');
define('PROSP_TABLE','prospect');
define('MYSQLHOST','sql.toile-libre.org');
define('MYSQLUSER','kabedistes_jom');
define('MYSQLPASS','msoura1124');
define('MYSQLDBNAME','kabedistes_jom');
define('NOM_SITE','Solution des affaires immobilières');
define('ROWSXPAGEOf',10);

$variable['rep_photos']='illust';
$variable['serveur']= 'http://'.$_SERVER['HTTP_HOST'].'/';
$variable['root_serv']=$_SERVER['DOCUMENT_ROOT'].'/';


$variable['lemenu']=array('ACCUEIL'=>array('Accueil'=>'Index'),'Annonce'=>array('Annonces'=>'Annonce'),'VENDLOUE'=>array('Vous vendez/louez'=>'Formul'),'PROSPEC'=>array('Prospection'=>'Prospection'),'CONTACT'=>array('Contact'=>'Contact'));
$variable['wilaya']=array('1'=>'Adrar','2'=>'Chlef','3'=>'Laghouat','4'=>'Oum El Bouaghi','5'=>'Batna','6'=>'B&eacute;ja&iuml;a','7'=>'Biskra','8'=>'B&eacute;char','9'=>'Blida','10'=>'Bouira','11'=>'Tamanrasset','12'=>'T&eacute;bessa','13'=>'Tlemcen','14'=>'Tiaret','15'=>'Tizi-Ouzou','16'=>'Alger','17'=>'Djelfa','18'=>'Jijel','19'=>'S&eacute;tif','20'=>'Saida','21'=>'Skikda','22'=>'Sidi Bel-Abb&egrave;s','23'=>'Annaba','24'=>'Guelma','25'=>'Constantine','26'=>'M&eacute;d&eacute;a','27'=>'Mostaganem','28'=>'M`Sila','29'=>'Mascara','30'=>'Ouargla','31'=>'Oran','32'=>'El-Bayadh','33'=>'Illizi','34'=>'Bordj Bou Arreridj','35'=>'Boumerd&egrave;s','36'=>'El-Taref','37'=>'Tindouf','38'=>'Tissemsilt','39'=>'El-Oued','40'=>'Khenchela','41'=>'Souk-Ahras','42'=>'Tipaza','43'=>'Mila','44'=>'Ain-Defla','45'=>'Na&aring;ma','46'=>'A&iuml;n T&eacute;mouchent','47'=>'Ghardaia','48'=>'Relizane','49'=>'Etranger');
$variable['titre']=array('Mlle','Mme','M.','Entreprise','Agence','Autre');
$variable['commod']=array('Ascenceur','Balcon','Cave','Garage','Parking','Terrasse','Cour','Interphone','Jardin','Piscine');
$variable['papier']=array('Acte','D&eacute;cision','Pas de porte','Livret de foncier','Permis de construire. Urbanisme R+...');
$variable['type_vente']=array('Vente','Location','Echange');
$variable['bien']=array('Appartement','Niveau de villa','Villa','Immeuble','Hangar','Commerce','Terrain');
$variable['biena']=array('Appartements/Duplex/Studios','Niveaux de Villa','Villas/Carcasses','Immeubles','Hangars/Usines','Locaux commerciaux/Usines','Terrains');
$variable['mois']=Array('Janvier','F&eacute;vrier','Mars','Avril','Mai','Juin','Juillet','Ao&ucirc;t','Septembre','Octobre','Novembre','D&eacute;cembre');
$variable['journ']=Array('Dimanche','Lundi','Mardi','Mercredi','Jeudi','Vendredi','Samedi');
$variable['lemail']=array('monmail','immozer.com');
?>
﻿﻿<?

$variable['users_table']='users';
$variable['offres_table']='offres';
$variable['dossiers_table']='dossiers';
$variable['caract_table']='catacter';
$variable['photo_table']='photos';
$variable['prosp_table']='prospect';
$variable['mysqlhost'] = 'sql.toile-libre.org';
$variable['mysqluser'] = 'kabedistes_jom';
$variable['mysqlpass'] = 'msoura1124';
$variable['dbname'] = ' kabedistes_jom';
#define('SERVER_ROOT', $_SERVER['DOCUMENT_ROOT']);
#define('SERVER_ROOT','/data/web/f/7/kabkab.toile-libre.org/htdocs');

define('SMARTY_DIR', SERVER_ROOT.'/Smarty/');
define('SERVER_HOST', 'http://'.$_SERVER['HTTP_HOST']);
define('SERVER_IMAGES',SERVER_HOST.'/Images/');
define('REP_INCLUSION','Includes/');
define('SERVER_INC',SERVER_HOST.'/'.REP_INCLUSION);
define('REGIE_INC',SERVER_HOST.'/regie/Includes/');
define('DOSS_PHOTOS','/illust/');
define('REP_PHOTOS',SERVER_HOST.DOSS_PHOTOS);
define('ROT_PHOTOS',SERVER_ROOT.DOSS_PHOTOS);

define('USERS_TABLE','users');
define('OFFRES_TABLE','offres');
define('DOSSIERS_TABLE','dossiers');
define('CARACT_TABLE','catacter');
define('PHOTO_TABLE','photos');
define('PROSP_TABLE','prospect');
define('MYSQLHOST','sql.toile-libre.org');
define('MYSQLUSER','kabedistes_jom');
define('MYSQLPASS','msoura1124');
define('MYSQLDBNAME','kabedistes_jom');
define('NOM_SITE','Solution des affaires immobilières');
define('ROWSXPAGEOf',10);

$variable['rep_photos']='illust';
$variable['serveur']= 'http://'.$_SERVER['HTTP_HOST'].'/';
$variable['root_serv']=$_SERVER['DOCUMENT_ROOT'].'/';


$variable['lemenu']=array('ACCUEIL'=>array('Accueil'=>'Index'),'Annonce'=>array('Annonces'=>'Annonce'),'VENDLOUE'=>array('Vous vendez/louez'=>'Formul'),'PROSPEC'=>array('Prospection'=>'Prospection'),'CONTACT'=>array('Contact'=>'Contact'));
$variable['wilaya']=array('1'=>'Adrar','2'=>'Chlef','3'=>'Laghouat','4'=>'Oum El Bouaghi','5'=>'Batna','6'=>'B&eacute;ja&iuml;a','7'=>'Biskra','8'=>'B&eacute;char','9'=>'Blida','10'=>'Bouira','11'=>'Tamanrasset','12'=>'T&eacute;bessa','13'=>'Tlemcen','14'=>'Tiaret','15'=>'Tizi-Ouzou','16'=>'Alger','17'=>'Djelfa','18'=>'Jijel','19'=>'S&eacute;tif','20'=>'Saida','21'=>'Skikda','22'=>'Sidi Bel-Abb&egrave;s','23'=>'Annaba','24'=>'Guelma','25'=>'Constantine','26'=>'M&eacute;d&eacute;a','27'=>'Mostaganem','28'=>'M`Sila','29'=>'Mascara','30'=>'Ouargla','31'=>'Oran','32'=>'El-Bayadh','33'=>'Illizi','34'=>'Bordj Bou Arreridj','35'=>'Boumerd&egrave;s','36'=>'El-Taref','37'=>'Tindouf','38'=>'Tissemsilt','39'=>'El-Oued','40'=>'Khenchela','41'=>'Souk-Ahras','42'=>'Tipaza','43'=>'Mila','44'=>'Ain-Defla','45'=>'Na&aring;ma','46'=>'A&iuml;n T&eacute;mouchent','47'=>'Ghardaia','48'=>'Relizane','49'=>'Etranger');
$variable['titre']=array('Mlle','Mme','M.','Entreprise','Agence','Autre');
$variable['commod']=array('Ascenceur','Balcon','Cave','Garage','Parking','Terrasse','Cour','Interphone','Jardin','Piscine');
$variable['papier']=array('Acte','D&eacute;cision','Pas de porte','Livret de foncier','Permis de construire. Urbanisme R+...');
$variable['type_vente']=array('Vente','Location','Echange');
$variable['bien']=array('Appartement','Niveau de villa','Villa','Immeuble','Hangar','Commerce','Terrain');
$variable['biena']=array('Appartements/Duplex/Studios','Niveaux de Villa','Villas/Carcasses','Immeubles','Hangars/Usines','Locaux commerciaux/Usines','Terrains');
$variable['mois']=Array('Janvier','F&eacute;vrier','Mars','Avril','Mai','Juin','Juillet','Ao&ucirc;t','Septembre','Octobre','Novembre','D&eacute;cembre');
$variable['journ']=Array('Dimanche','Lundi','Mardi','Mercredi','Jeudi','Vendredi','Samedi');
$variable['lemail']=array('monmail','immozer.com');
?>
<?
class Person 
{ 
	static public function getPhotos($dossier)
	{
		global $variable, $opened;
		$sql = 'SELECT * FROM `'.$variable['photo_table'].'` WHERE `Id_Dossier`='.$dossier.' AND `Principal`=1';
		$res = mysqli_query($opened,$sql); 
		return $res;
	}

	static public function getAllRecords($type_v,$article,$start, $limit, $order = null){
		global $variable, $opened;
		
		if($order == null){
			$sql = 'SELECT * FROM `'.$variable['dossiers_table'].'` WHERE `Publie`=1 LIMIT '.$start.', '.$limit. $_SESSION['ordering'];
		}else{
			$sql = 'SELECT * FROM `'.$variable['dossiers_table'].'` WHERE `Publie`=1 ORDER BY `'.$order.'`'. $_SESSION['ordering'].' LIMIT '.$start.', '.$limit;
		}
		$res = mysqli_query($opened,$sql);  
		return $res;
	}

	static public function getRecordsFiltered($type_v,$article,$start, $limit, $filter = null, $content = null, $order = null, $ordering = ""){
		global $variable, $opened;
		
		if(($filter != null) and ($content != null)){
			$sql = 'SELECT * FROM `'.$variable['dossiers_table']
					.'` WHERE `type_v`='.$type_v.' AND `article`='.$article." AND `Publie`=1 AND `".$filter."` = ".$content.""
					." ORDER BY ".$order
					." ".$_SESSION['ordering']
					." LIMIT $start, $limit $ordering";
		}
		$res = mysqli_query($opened,$sql); 
		return $res;
	}
	
	static public function getNumRows($type_v,$article,$filter = null, $content = null){
		global $variable, $opened;
		$sql = 'SELECT COUNT(*) AS numRows FROM `'.$variable['dossiers_table']
		       .'` WHERE `type_v`='.$type_v.' AND `article`='.$article.' AND `Publie`=1';
		if ($type_v == null)
		{	$sql = 	"SELECT COUNT(*) AS numRows "
				.'FROM `'.$variable['dossiers_table']
				.'` WHERE `Publie`=1 ';
		}
		if(($filter != null) and ($content != null)){
			$sql = 	"SELECT COUNT(*) AS numRows "
				.'FROM `'.$variable['dossiers_table']
				.'` WHERE `type_v`='.$type_v.' AND `article`='.$article." AND `Publie`=1 AND `".$filter."`= $content";
		}
		$res = mysqli_query($opened,$sql); 
		$num = mysqli_fetch_array($res);
		return $num['numRows'];		
	}
	
	static public function getRecordByID($id){
		global $variable,$opened;
		$sql = 'SELECT * FROM `'.$variable['dossiers_table']
				."` WHERE `Id_Dossier` = $id";
		$res = mysqli_query($opened,$sql); 
		$row = mysqli_fetch_array($res);
		return $row;
	}
}

class Prospect
{ 
	static public function getAllRecords($start, $limit, $order = null){
		global $variable,$opened;
		if($order == null){
			$sql = 'SELECT * FROM `'.$variable['prosp_table']."` LIMIT $start, $limit ".$_SESSION['ordering'];
		}else{
			$sql = 'SELECT * FROM `'.$variable['prosp_table']."` ORDER BY $order ".$_SESSION['ordering']." LIMIT $start, $limit ";
		}
		$res = mysqli_query($opened,$sql);
		return $res;
	}
	
	static public function getNumRows($filter = null, $content = null){
		global $variable,$opened;
		$sql = 'SELECT COUNT(*) AS numRows FROM `'.$variable['prosp_table'].'`';
		if(($filter != null) and ($content != null)){
			$sql = 	"SELECT COUNT(*) AS numRows "
				.'FROM `'.$variable['prosp_table']
				.'` WHERE '.$filter." like '%$content%'";
		}
		$res = mysqli_query($opened,$sql);
		$num = mysqli_fetch_array($res);
		return $num[0];		
	}
	
	static public function getRecordByID($id){
		global $variable,$opened;
		$sql = 'SELECT * FROM `'.$variable['prosp_table']."` WHERE `Id_Prospect` = $id";
		$res = mysqli_query($opened,$sql);
		$row = mysqli_fetch_array($res);
		return $row;
	}
}
?>