<?php
// This script and data application were generated by AppGini 5.76
// Download AppGini for free from https://bigprof.com/appgini/download/

/*
	ajax-callable script that returns code for either a combo drop-down or an auto-complete
	drop-down, based on number of items.

	REQUEST parameters:
	===============
	t: table name
	f: lookup field name
	id: selected id
	p: page number (default = 1)
	s: search term
	o: 0 (default) for text-only or 1 for full options list
	text: selected text
	filterer_[filterer]: name of filterer field to be used to filter the drop-down contents
				must be one of the filteres defined for the concerned field
*/

	$start_ts = microtime(true);

	// how many results to return per call, in case of json output
	$results_per_page = 50;

	$curr_dir = dirname(__FILE__);
	include("$curr_dir/defaultLang.php");
	include("$curr_dir/language.php");
	include("$curr_dir/lib.php");

	handle_maintenance();

	// drop-downs config
	$lookups = array(   
		'main' => array(  
		),
		'dossier_individuel' => array(   
			'fonction' => array(
				'parent_table' => 'fonctions',
				'parent_pk_field' => 'idfonction',
				'parent_caption' => '`fonctions`.`fonction`',
				'parent_from' => '`fonctions` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'directions',
				'parent_pk_field' => 'iddirection',
				'parent_caption' => '`directions`.`direction`',
				'parent_from' => '`directions` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'services',
				'parent_pk_field' => 'idservice',
				'parent_caption' => '`services`.`service`',
				'parent_from' => '`services` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`services`.`from_direction` ',
				'filterers' => array('direction' => 'from_direction'),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'division' => array(
				'parent_table' => 'divisions',
				'parent_pk_field' => 'iddivision',
				'parent_caption' => '`divisions`.`division`',
				'parent_from' => '`divisions` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`divisions`.`to_services` ',
				'filterers' => array('service' => 'to_services'),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'categorie' => array(
				'parent_table' => 'categorie_prime',
				'parent_pk_field' => 'id_categorie_prime',
				'parent_caption' => '`categorie_prime`.`categorie`',
				'parent_from' => '`categorie_prime` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'statut' => array(
				'parent_table' => 'statut',
				'parent_pk_field' => 'idstatut',
				'parent_caption' => '`statut`.`statut`',
				'parent_from' => '`statut` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'prime_ts' => array(
				'parent_table' => 'categorie_prime',
				'parent_pk_field' => 'id_categorie_prime',
				'parent_caption' => '`categorie_prime`.`prime`',
				'parent_from' => '`categorie_prime` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'banque' => array(
				'parent_table' => 'les_banques',
				'parent_pk_field' => 'id',
				'parent_caption' => '`les_banques`.`banque`',
				'parent_from' => '`les_banques` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'gestion_salaire' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'compte' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`compte`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'banque' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`les_banques1`.`banque`), CONCAT_WS(\'\',   `les_banques1`.`banque`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'gestion_prime' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'compte' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`compte`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'banque' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`les_banques1`.`banque`), CONCAT_WS(\'\',   `les_banques1`.`banque`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'paiements' => array(  
		),
		'etat_paiements' => array(   
			'from_paiements' => array(
				'parent_table' => 'paiements',
				'parent_pk_field' => 'id_paiement',
				'parent_caption' => '`paiements`.`to_etat_paiements`',
				'parent_from' => '`paiements` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'prime' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`categorie_prime1`.`prime`), CONCAT_WS(\'\',   `categorie_prime1`.`prime`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'n_compte' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`compte`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'banque' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`les_banques1`.`banque`), CONCAT_WS(\'\',   `les_banques1`.`banque`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'banques' => array(   
			'banque' => array(
				'parent_table' => 'les_banques',
				'parent_pk_field' => 'id',
				'parent_caption' => '`les_banques`.`banque`',
				'parent_from' => '`les_banques` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'etat_banques' => array(   
			'from_banque' => array(
				'parent_table' => 'banques',
				'parent_pk_field' => 'id_banque',
				'parent_caption' => '`banques`.`to_etat_banques`',
				'parent_from' => '`banques` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`banques`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'salaire' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`salaire`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'n_compte' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`compte`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'banque' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`les_banques1`.`banque`), CONCAT_WS(\'\',   `les_banques1`.`banque`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'pointages' => array(   
			'structure' => array(
				'parent_table' => 'directions',
				'parent_pk_field' => 'iddirection',
				'parent_caption' => '`directions`.`direction`',
				'parent_from' => '`directions` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'fiche_pointages' => array(   
			'from_pointage' => array(
				'parent_table' => 'pointages',
				'parent_pk_field' => 'id_pointages',
				'parent_caption' => '`pointages`.`to_fiche_pointage`',
				'parent_from' => '`pointages` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`pointages`.`structure` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom_fp' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction_fp' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nni_fp' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nni`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'permissions' => array(   
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'division' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`divisions1`.`division`), CONCAT_WS(\'\',   `divisions1`.`division`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'conges' => array(   
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'demandes_permission' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'date_recrutement' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'if(`dossier_individuel`.`date_recrutement`,date_format(`dossier_individuel`.`date_recrutement`,\'%d/%m/%Y\'),\'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'division' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`divisions1`.`division`), CONCAT_WS(\'\',   `divisions1`.`division`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'demandes_conge_m' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'date_recrutement' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'if(`dossier_individuel`.`date_recrutement`,date_format(`dossier_individuel`.`date_recrutement`,\'%d/%m/%Y\'),\'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'division' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`divisions1`.`division`), CONCAT_WS(\'\',   `divisions1`.`division`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'demandes_permissions' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'date_recrutement' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'if(`dossier_individuel`.`date_recrutement`,date_format(`dossier_individuel`.`date_recrutement`,\'%d/%m/%Y\'),\'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'division' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`divisions1`.`division`), CONCAT_WS(\'\',   `divisions1`.`division`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'demandes_conge_sg' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'date_recrutement' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'if(`dossier_individuel`.`date_recrutement`,date_format(`dossier_individuel`.`date_recrutement`,\'%d/%m/%Y\'),\'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'division' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`divisions1`.`division`), CONCAT_WS(\'\',   `divisions1`.`division`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'conges_permissions' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'demandes_conge' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'cursus' => array(   
			'idinformation' => array(
				'parent_table' => 'informations',
				'parent_pk_field' => 'idinformation',
				'parent_caption' => '`informations`.`idinformation`',
				'parent_from' => '`informations` LEFT JOIN `dossier_individuel` as dossier_individuel1 ON `dossier_individuel1`.`iddindividuel`=`informations`.`matricule` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'formations' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'informations' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(CHAR_LENGTH(`dossier_individuel`.`matricule`), CONCAT_WS(\'\', `dossier_individuel`.`matricule`, \'   \'), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'carrieres' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'r_n_m_a_p_d' => array(
				'parent_table' => 'carrieres_option',
				'parent_pk_field' => 'idoption',
				'parent_caption' => '`carrieres_option`.`description`',
				'parent_from' => '`carrieres_option` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'demandes' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'recrutement' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'if(`dossier_individuel`.`date_recrutement`,date_format(`dossier_individuel`.`date_recrutement`,\'%d/%m/%Y\'),\'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'fonctions' => array(  
		),
		'directions' => array(  
		),
		'services' => array(   
			'from_direction' => array(
				'parent_table' => 'directions',
				'parent_pk_field' => 'iddirection',
				'parent_caption' => '`directions`.`direction`',
				'parent_from' => '`directions` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'divisions' => array(   
			'to_services' => array(
				'parent_table' => 'services',
				'parent_pk_field' => 'idservice',
				'parent_caption' => '`services`.`service`',
				'parent_from' => '`services` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`services`.`from_direction` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'les_banques' => array(  
		),
		'carrieres_option' => array(  
		),
		'statut' => array(  
		),
		'missions' => array(  
		),
		'ordres_missions' => array(   
			'from_mission' => array(
				'parent_table' => 'missions',
				'parent_pk_field' => 'id_mission',
				'parent_caption' => '`missions`.`to_mission`',
				'parent_from' => '`missions` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'decomptes' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nni' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nni`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'num_cpte' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(CHAR_LENGTH(`dossier_individuel`.`compte`) || CHAR_LENGTH(`dossier_individuel`.`banque`), CONCAT_WS(\'\', `dossier_individuel`.`compte`, \'   /   \', IF(    CHAR_LENGTH(`les_banques1`.`banque`), CONCAT_WS(\'\',   `les_banques1`.`banque`), \'\')), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'details_decompte' => array(   
			'to_decomptes' => array(
				'parent_table' => 'decomptes',
				'parent_pk_field' => 'iddecompte',
				'parent_caption' => '`decomptes`.`iddecompte`',
				'parent_from' => '`decomptes` LEFT JOIN `dossier_individuel` as dossier_individuel1 ON `dossier_individuel1`.`iddindividuel`=`decomptes`.`matricule` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel1`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'incomes' => array(   
			'client' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'expenses' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'client' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'date_recrutement' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'if(`dossier_individuel`.`date_recrutement`,date_format(`dossier_individuel`.`date_recrutement`,\'%d/%m/%Y\'),\'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'division' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`divisions1`.`division`), CONCAT_WS(\'\',   `divisions1`.`division`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'service' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`services1`.`service`), CONCAT_WS(\'\',   `services1`.`service`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'direction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`directions1`.`direction`), CONCAT_WS(\'\',   `directions1`.`direction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		),
		'categorie_prime' => array(  
		),
		'curriculum_vitae' => array(   
			'matricule' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`matricule`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'nom_prenom' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => '`dossier_individuel`.`nom_prenom`',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			),
			'fonction' => array(
				'parent_table' => 'dossier_individuel',
				'parent_pk_field' => 'iddindividuel',
				'parent_caption' => 'IF(    CHAR_LENGTH(`fonctions1`.`fonction`), CONCAT_WS(\'\',   `fonctions1`.`fonction`), \'\')',
				'parent_from' => '`dossier_individuel` LEFT JOIN `fonctions` as fonctions1 ON `fonctions1`.`idfonction`=`dossier_individuel`.`fonction` LEFT JOIN `directions` as directions1 ON `directions1`.`iddirection`=`dossier_individuel`.`direction` LEFT JOIN `services` as services1 ON `services1`.`idservice`=`dossier_individuel`.`service` LEFT JOIN `divisions` as divisions1 ON `divisions1`.`iddivision`=`dossier_individuel`.`division` LEFT JOIN `categorie_prime` as categorie_prime1 ON `categorie_prime1`.`id_categorie_prime`=`dossier_individuel`.`categorie` LEFT JOIN `statut` as statut1 ON `statut1`.`idstatut`=`dossier_individuel`.`statut` LEFT JOIN `les_banques` as les_banques1 ON `les_banques1`.`id`=`dossier_individuel`.`banque` ',
				'filterers' => array(),
				'custom_query' => '',
				'inherit_permissions' => false,
				'list_type' => 0,
				'not_null' => false
			)
		)
	);

	// XSS prevention
	$xss = new CI_Input();
	$xss->charset = datalist_db_encoding;

	// receive and verify user input
	$table_name = $_REQUEST['t'];
	$field_name = $_REQUEST['f'];
	$search_id = makeSafe(from_utf8($_REQUEST['id']));
	$selected_text = from_utf8($_REQUEST['text']);
	$returnOptions = ($_REQUEST['o'] == 1 ? true : false);
	$page = intval($_REQUEST['p']);
	if($page < 1)  $page = 1;
	$skip = $results_per_page * ($page - 1);
	$search_term = makeSafe(from_utf8($_REQUEST['s']));

	if(!isset($lookups[$table_name][$field_name])) die('{ "error": "Invalid table or field." }');

	// can user access the requested table?
	$perm = getTablePermissions($table_name);
	if(!$perm[0] && !$search_id) die('{ "error": "' . addslashes($Translation['tableAccessDenied']) . '" }');

	$field = $lookups[$table_name][$field_name];

	$wheres = array();

	// search term provided?
	if($search_term){
		$wheres[] = "{$field['parent_caption']} like '%{$search_term}%'";
	}

	// any filterers specified?
	if(is_array($field['filterers'])){
		foreach($field['filterers'] as $filterer => $filterer_parent){
			$get = (isset($_REQUEST["filterer_{$filterer}"]) ? $_REQUEST["filterer_{$filterer}"] : false);
			if($get){
				$wheres[] = "`{$field['parent_table']}`.`$filterer_parent`='" . makeSafe($get) . "'";
			}
		}
	}

	// inherit permissions?
	if($field['inherit_permissions']){
		$inherit = permissions_sql($field['parent_table']);
		if($inherit === false && !$search_id) die($Translation['tableAccessDenied']);

		if($inherit['where']) $wheres[] = $inherit['where'];
		if($inherit['from']) $field['parent_from'] .= ", {$inherit['from']}";
	}

	// single value?
	if($field['list_type'] != 2 && $search_id){
		$wheres[] = "`{$field['parent_table']}`.`{$field['parent_pk_field']}`='{$search_id}'";
	}

	if(count($wheres)){
		$where = 'WHERE ' . implode(' AND ', $wheres);
	}

	// define the combo and return the code
	$combo = new DataCombo;
	if($field['custom_query']){
		$qm = array(); $custom_where = ''; $custom_order_by = '2';
		$combo->Query = $field['custom_query'];

		if(preg_match('/ order by (.*)$/i', $combo->Query, $qm)){
			$custom_order_by = $qm[1];
			$combo->Query = preg_replace('/ order by .*$/i', '', $combo->Query);
		}

		if(preg_match('/ where (.*)$/i', $combo->Query, $qm)){
			$custom_where = $qm[1];
			$combo->Query = preg_replace('/ where .*$/i', '', $combo->Query);
		}

		if($where && $custom_where){
			$combo->Query .=  " {$where} AND ({$custom_where}) ORDER BY {$custom_order_by}";
		}elseif($custom_where){
			$combo->Query .=  " WHERE {$custom_where} ORDER BY {$custom_order_by}";
		}else{
			$combo->Query .=  " {$where} ORDER BY {$custom_order_by}";
		}

		$query_match = array();
		preg_match('/select (.*) from (.*)$/i', $combo->Query, $query_match);

		if(isset($query_match[2])){
			$count_query = "SELECT count(1) FROM {$query_match[2]}";
		}else{
			$count_query = '';
		}
	}else{
		$combo->Query = "SELECT " . ($field['inherit_permissions'] ? 'DISTINCT ' : '') . "`{$field['parent_table']}`.`{$field['parent_pk_field']}`, {$field['parent_caption']} FROM {$field['parent_from']} {$where} ORDER BY 2";
		$count_query = "SELECT count(1) FROM {$field['parent_from']} {$where}";
	}
	$combo->table = $table_name;
	$combo->parent_table = $field['parent_table'];
	$combo->SelectName = $field_name;
	$combo->ListType = $field['list_type'];
	if($search_id){
		$combo->SelectedData = $search_id;
	}elseif($selected_text){
		$combo->SelectedData = getValueGivenCaption($combo->Query, $selected_text);
	}

	if($field['list_type'] == 2){
		$combo->Render();
		$combo->HTML = str_replace('<select ', '<select onchange="' . $field_name . '_changed();" ', $combo->HTML);

		// return response
		if($returnOptions){
			?><span id="<?php echo $field_name; ?>-combo-list"><?php echo $combo->HTML; ?></span><?php
		}else{
			?>
				<span id="<?php echo $field_name; ?>-match-text"><?php echo $combo->MatchText; ?></span>
				<input type="hidden" id="<?php echo $field_name; ?>" value="<?php echo html_attr($combo->SelectedData); ?>" />
			<?php
		}
	}else{
		/* return json */
		header('Content-type: application/json');

		if(!preg_match('/ limit .+/i', $combo->Query)){
			if(!$search_id) $combo->Query .= " LIMIT {$skip}, {$results_per_page}";
			if($search_id) $combo->Query .= " LIMIT 1";
		}

		$prepared_data = array();

		// specific caption provided and list_type is not radio?
		if(!$search_id && $selected_text){
			$search_id = getValueGivenCaption($combo->Query, $selected_text);
			if($search_id) $prepared_data[] = array('id' => to_utf8($search_id), 'text' => to_utf8($xss->xss_clean($selected_text)));
		}else{
			$res = sql($combo->Query, $eo);
			while($row = db_fetch_row($res)){
				if(empty($prepared_data) && $page == 1 && !$search_id && !$field['not_null']){
					$prepared_data[] = array('id' => empty_lookup_value, 'text' => to_utf8("<{$Translation['none']}>"));
				}

				$prepared_data[] = array('id' => to_utf8($row[0]), 'text' => to_utf8($xss->xss_clean($row[1])));
			}
		}

		if(empty($prepared_data)){ $prepared_data[] = array('id' => '', 'text' => to_utf8($Translation['No matches found!'])); }

		echo json_encode(array(
			'results' => $prepared_data,
			'more' => (@db_num_rows($res) >= $results_per_page),
			'elapsed' => round(microtime(true) - $start_ts, 3)
		));
	}

