function get_recap_ventes()
{
	var statut=new RegExp("(vendu|option|réservé)","");
	var filter='ventes';
//Data store
	var VentesDataStore=new Ext.data.GroupingStore({
		id:'VentesDataStore',
		proxy: new Ext.data.HttpProxy({
			url:'admin/php/ventes.php',
			method: 'POST'
		}),
		reader: new Ext.data.JsonReader({   
        root: 'results',
		totalProperty: 'total',
        id: 'id_vente'},
				[
				//{name: 'IdVente',type: 'string',dataIndex:'IdVente',mapping:'id_vente'},
				{name: 'IdVente',type: 'string',mapping:'id_vente'},
				{name: 'Statut',type: 'string',mapping:'statut'},
				{name: 'Rang',type: 'string',mapping:'rang'},
				{name: 'Programme',type: 'string',mapping:'nom_programme'},
				{name: 'Num Lot',type: 'string',mapping:'num_lot'},
				{name: 'Date',type: 'date',dateFormat:'Y-m-d',mapping:'date'},
				{name: 'DateValid',type: 'date',dateFormat:'Y-m-d',mapping:'date_validite'},
				{name: 'Vendeur',type: 'string',mapping:'vendeur'},
				{name: 'Acquereur',type: 'string',mapping:'Client'},
				{name: 'InfosAcquereur',type: 'string',mapping:'infoClient'},
				{name: 'Prix',type: 'string',mapping:'prix'},
				{name: 'Note vendeur',type: 'string',mapping:'note'},
				{name: 'Saisi',type: 'int',mapping:'saisi'}
				]),
		sortInfo:{field:'Programme', direction: 'ASC'},
		groupField:'Programme',
		writer: new Ext.data.JsonWriter({
			encode: true,
			writeAllFields: true 
		}),
		autoSave:true,
		listeners:{
			update:function() {VentesDataStore.filter('Statut',statut);},
			load:function() {VentesDataStore.filter('Statut',statut);}
		}
	});
	VentesDataStore.load();
	
	var SaisiColumn=new Ext.grid.CheckColumn({
			id:'check',
			header:'Saisi',
			dataIndex:'Saisi',
			hidden:false,
			width:40});

//Column Model
	var store;
	if(parent.is_promoteur)
		store=['option','réservé','vendu','échec','refus'];
	else
		store=['option','réservé','échec'];
	var columns=[{
			readOnly: true,
			dataIndex: 'IdVente', 
			width: 50,
			hidden: true
		  },{
			header:'Statut',
			dataIndex: 'Statut',
			sortable: true,
			css:'padding:0;border:1px solid #ccc',
			editor: new Ext.form.ComboBox({
				store: store,
				typeAhead: true,
				triggerAction: 'all',
				mode:'local',
				editable:false
				}),
			renderer: function(value, metaData, record, rowIndex, colIndex, store) {
				return '<p class="fake_combo">'+value+'</p><div class="fake_trigger"></div>';
			}
		  },{
			header: 'Rang',
			readOnly: true,
			dataIndex: 'Rang', 
			width: 30,
			sortable: true,
			hidden: false
		  },{
			header: 'Nom du projet',
			readOnly: true,
			dataIndex: 'Programme', 
			width: 100,
			sortable: true,
			hidden: true
		  },{
			header: 'Nom du lot',
			readOnly: true,
			dataIndex: 'Num Lot', 
			width: 60,
			sortable: true,
			hidden: false
		  },{
			header: 'Date de dépot',
			readOnly: true,
			dataIndex: 'Date', 
			width:60,
			sortable: true,
			hidden: false,
			renderer: Ext.util.Format.dateRenderer('d/m/Y')
		  },{
			header: 'Date de validité',
			readOnly: true,
			dataIndex: 'DateValid', 
			width:60,
			sortable: true,
			hidden: false,
			renderer: Ext.util.Format.dateRenderer('d/m/Y')
		  },{
			header: 'Vendeur',
			readOnly: true,
			dataIndex: 'Vendeur', 
			width: 105,
			sortable: true,
			hidden: false
		  },{
			header: 'Acquéreur',
			readOnly: true,
			dataIndex: 'Acquereur', 
			width: 105,
			sortable: true,
			hidden: false
		  },{
			header: 'Infos acquéreur',
			readOnly: true,
			dataIndex: 'InfosAcquereur', 
			width: 105,
			sortable: true,
			hidden: false
		  },{
			header: 'Prix',
			readOnly: true,
			dataIndex: 'Prix', 
			width: 70,
			sortable: true,
			hidden: false
		  },{
			header: 'Note',
			readOnly: false,
			dataIndex: 'Note vendeur', 
			width: 125,
			sortable: true,
			hidden: false,
			editor:new Ext.form.TextArea()
		  }/*,
			SaisiColumn*/
		  ];

	function aff_options (){
		statut=new RegExp("(vendu|option|réservé)","");
		VentesDataStore.groupField='Programme';
		VentesDataStore.filter('Statut',statut);	
		filter='ventes';
	}
	function aff_echec (){
		statut=new RegExp("(refus|echec|échec)","");
		VentesDataStore.groupField='Programme';
		VentesDataStore.filter('Statut',statut);
		filter='echec';
	}
	var VentesListingGrid=new Ext.grid.EditorGridPanel({
		store:VentesDataStore,
		colModel:new Ext.grid.ColumnModel(columns), 
		sm:new Ext.grid.RowSelectionModel({
						singleSelect: true
		}),
		plugins:[SaisiColumn],
		stripeRows :true,
		height:500, 
		clicksToEdit:1,
		tbar: [
			{
				text:'Etat des ventes',
				handler:aff_options
			},'|',{
				text:'echecs et refus',
				handler:aff_echec
			},'->',{
				iconCls : "table_save",
				text:'Exporter',
				handler : function(){
						window.open("admin/php/ventes.php?xaction=xls&filter="+filter,"xls");
					}
				}],
		view: new Ext.grid.GroupingView({
                forceFit: true,
				startCollapsed:true,
				hideGroupedColumn :false,
                emptyGroupText: 'All Group Fields Empty',
                displayEmptyFields: true, //you can choose to show the group fields, even when they have no values
                groupTextTpl: '{gvalue} ({[values.rs.length]} {[values.rs.length == 1 ? "Entrée" : "Entrées"]}) ',
                displayFieldSeperator: ', ' //you can control how the display fields are seperated
		})
		
	});
	var panel=new Ext.Panel(
	{
		title:'Options et ventes',
		renderTo:'content',
		style:{margin:'auto'},
		width: 'auto',
		items:[VentesListingGrid
		,
		{
			xtype:'fieldset', items:{xtype: 'box',
				autoEl: { tag: 'div',
				cls:'aide',
				html: '<img src="admin/images/info_icon.png"/>Accédez au détail des transactions réalisées sur les espaces de vente <b>EVimmo3d</b> et mettez à jour votre systême de gestion de stock.<a href="javascript:video_help(\'saisieVentes\')" style="float:right">Plus d\'aide ici</a>'
				}
			}
		}]
	});
}