1791 lines
82 KiB
PHP
1791 lines
82 KiB
PHP
<?php
|
||
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
|
||
* ATTENTION!
|
||
* If you see this message in your browser (Internet Explorer, Mozilla Firefox, Google Chrome, etc.)
|
||
* this means that PHP is not properly installed on your web server. Please refer to the PHP manual
|
||
* for more details: http://php.net/manual/install.php
|
||
*
|
||
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
|
||
*/
|
||
|
||
|
||
include_once dirname(__FILE__) . '/' . 'components/utils/check_utils.php';
|
||
CheckPHPVersion();
|
||
CheckTemplatesCacheFolderIsExistsAndWritable();
|
||
|
||
|
||
include_once dirname(__FILE__) . '/' . 'phpgen_settings.php';
|
||
include_once dirname(__FILE__) . '/' . 'database_engine/mysql_engine.php';
|
||
include_once dirname(__FILE__) . '/' . 'components/page.php';
|
||
|
||
|
||
function GetConnectionOptions()
|
||
{
|
||
$result = GetGlobalConnectionOptions();
|
||
$result['client_encoding'] = 'utf8';
|
||
GetApplication()->GetUserAuthorizationStrategy()->ApplyIdentityToConnectionOptions($result);
|
||
return $result;
|
||
}
|
||
|
||
|
||
|
||
// OnBeforePageExecute event handler
|
||
|
||
|
||
|
||
class ParticipantsPage extends Page
|
||
{
|
||
protected function DoBeforeCreate()
|
||
{
|
||
$selectQuery = 'SELECT
|
||
inscriptions_panier_evenements.eve_nom_fr,
|
||
|
||
inscriptions_panier_participants.eve_id,
|
||
inscriptions_panier_participants.cp_details_fr,
|
||
inscriptions_panier_participants.par_prenom,
|
||
inscriptions_panier_participants.par_nom,
|
||
inscriptions_panier_participants.eta_nom_fr,
|
||
inscriptions_panier_participants.pro_id,
|
||
inscriptions_panier_participants.pay_id,
|
||
inscriptions_panier_participants.par_naissance,
|
||
inscriptions_panier_participants.par_age,
|
||
inscriptions_panier_participants.par_sexe,
|
||
inscriptions_panier_participants.par_adresse,
|
||
inscriptions_panier_participants.par_ville,
|
||
inscriptions_panier_participants.par_codepostal,
|
||
inscriptions_panier_participants.par_telephone1,
|
||
inscriptions_panier_participants.par_courriel,
|
||
inscriptions_panier_participants.par_prix,
|
||
inscriptions_panier_participants.par_no_equipe ,
|
||
inscriptions_panier_participants.par_nom_equipe ,
|
||
|
||
inscriptions_panier_epreuves.epr_type_fr,
|
||
inscriptions_panier_epreuves.epr_nom_fr,
|
||
inscriptions_panier_epreuves.epr_id,
|
||
inscriptions_panier_epreuves.epr_date,
|
||
inscriptions_panier_epreuves.epr_heure,
|
||
|
||
|
||
inscriptions_panier_acheteurs.ach_total,
|
||
inscriptions_panier_acheteurs.fra_total,
|
||
inscriptions_panier_acheteurs.fra_tps,
|
||
inscriptions_panier_acheteurs.fra_tvq,
|
||
inscriptions_panier_acheteurs.ach_total as tot_facture,
|
||
inscriptions_paiements.pai_nom_fr,
|
||
inscriptions_panier_rabais.rab_description_fr,
|
||
inscriptions_panier_rabais.rab_montant,
|
||
|
||
|
||
inscriptions_panier_participants.par_frais_tvq,
|
||
inscriptions_panier_participants.par_frais_tps,
|
||
inscriptions_panier_participants.par_frais_montant,
|
||
inscriptions_panier_acheteurs.TransactionID,
|
||
inscriptions_panier_participants.no_panier,
|
||
inscriptions_panier_acheteurs.sta_id,
|
||
inscriptions_panier_acheteurs.ach_maj,
|
||
inscriptions_panier_acheteurs.ach_id,
|
||
inscriptions_panier_participants.par_id,
|
||
|
||
|
||
|
||
|
||
|
||
Min( Case When inscriptions_panier_questions.que_id in (83) Then inscriptions_panier_questions.que_choix_fr End ) As Category,
|
||
Min( Case When q2.que_id in (89,87) Then q2.que_choix_fr End ) As Categoryequipe,
|
||
|
||
|
||
|
||
|
||
Min( Case When inscriptions_panier_questions.que_id in (82) Then inscriptions_panier_questions.que_choix_fr End ) As Parler,
|
||
|
||
|
||
Min( Case When inscriptions_panier_questions.que_id in (84,86) Then inscriptions_panier_questions.que_choix_fr End ) As membreTQ,
|
||
Min( Case When inscriptions_panier_questions.que_id in (85) Then inscriptions_panier_questions.que_choix_fr End ) As numeroTQ,
|
||
|
||
(select sta_id from inscriptions_panier_acheteurs where inscriptions_panier_participants.no_panier = no_panier ) as sta_commande,
|
||
|
||
(select sum(inscriptions_panier_produits.pro_prix) from inscriptions_panier_produits where inscriptions_panier_participants.no_panier = inscriptions_panier_produits.no_panier and (inscriptions_panier_produits.pro_id=9 or inscriptions_panier_produits.pro_id=10 ) and !ISNULL(sta_id)) as produits_nonmembre,
|
||
(select sum(inscriptions_panier_produits.pro_prix) from inscriptions_panier_produits where inscriptions_panier_participants.no_panier = inscriptions_panier_produits.no_panier and inscriptions_panier_produits.pro_id=6 and !ISNULL(sta_id)) as produits_corpotandem,
|
||
(select sum(inscriptions_panier_produits.pro_prix) from inscriptions_panier_produits where inscriptions_panier_participants.no_panier = inscriptions_panier_produits.no_panier and inscriptions_panier_produits.pro_id=7 and !ISNULL(sta_id)) as produits_corpo,
|
||
(select no_commande from inscriptions_panier_acheteurs where inscriptions_panier_participants.no_panier = no_panier ) as no_commande
|
||
|
||
FROM
|
||
inscriptions_panier_participants
|
||
LEFT JOIN inscriptions_panier_epreuves ON inscriptions_panier_participants.pep_id = inscriptions_panier_epreuves.pep_id
|
||
LEFT JOIN inscriptions_panier_evenements ON inscriptions_panier_epreuves.pan_id = inscriptions_panier_evenements.pan_id
|
||
LEFT JOIN inscriptions_panier_acheteurs ON inscriptions_panier_participants.par_id = inscriptions_panier_acheteurs.par_id
|
||
LEFT JOIN inscriptions_paiements ON inscriptions_panier_acheteurs.pai_id = inscriptions_paiements.pai_id
|
||
left JOIN inscriptions_panier_questions ON inscriptions_panier_participants.par_id = inscriptions_panier_questions.par_id
|
||
left JOIN inscriptions_panier_questions q2 ON inscriptions_panier_participants.par_no_equipe = q2.par_id
|
||
|
||
|
||
left JOIN inscriptions_panier_rabais_acheteurs ON inscriptions_panier_acheteurs.no_panier = inscriptions_panier_rabais_acheteurs.no_panier
|
||
left JOIN inscriptions_panier_rabais ON inscriptions_panier_rabais.pra_id = inscriptions_panier_rabais_acheteurs.pra_id
|
||
|
||
|
||
|
||
where (inscriptions_panier_participants.eve_id =107)
|
||
|
||
|
||
GROUP BY inscriptions_panier_participants.par_id
|
||
|
||
order by no_panier, inscriptions_panier_acheteurs.ach_total DESC';
|
||
$insertQuery = array();
|
||
$updateQuery = array();
|
||
$deleteQuery = array();
|
||
$this->dataset = new QueryDataset(
|
||
new MyConnectionFactory(),
|
||
GetConnectionOptions(),
|
||
$selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Participants');
|
||
$field = new StringField('eve_nom_fr');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('eve_id');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('cp_details_fr');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_prenom');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_nom');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('eta_nom_fr');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('pro_id');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('pay_id');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new DateField('par_naissance');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('par_age');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_sexe');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_adresse');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_ville');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_codepostal');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_telephone1');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_courriel');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('par_prix');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_no_equipe');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_nom_equipe');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('epr_type_fr');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('epr_nom_fr');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('epr_id');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new DateField('epr_date');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new TimeField('epr_heure');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('ach_total');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('fra_total');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('fra_tps');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('fra_tvq');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('tot_facture');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('pai_nom_fr');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('rab_description_fr');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('rab_montant');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('par_frais_tvq');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('par_frais_tps');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('par_frais_montant');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('TransactionID');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('no_panier');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('sta_id');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new DateTimeField('ach_maj');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('ach_id');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('par_id');
|
||
$this->dataset->AddField($field, true);
|
||
$field = new StringField('Category');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('Categoryequipe');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('Parler');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('membreTQ');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('numeroTQ');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('sta_commande');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('produits_nonmembre');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('produits_corpotandem');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new IntegerField('produits_corpo');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('no_commande');
|
||
$this->dataset->AddField($field, false);
|
||
$this->dataset->AddLookupField('pro_id', 'inscriptions_provinces', new IntegerField('pro_id', null, null, true), new StringField('pro_nom_fr', 'pro_id_pro_nom_fr', 'pro_id_pro_nom_fr_inscriptions_provinces'), 'pro_id_pro_nom_fr_inscriptions_provinces');
|
||
$this->dataset->AddLookupField('pay_id', 'inscriptions_pays', new IntegerField('pay_id', null, null, true), new StringField('pay_nom_fr', 'pay_id_pay_nom_fr', 'pay_id_pay_nom_fr_inscriptions_pays'), 'pay_id_pay_nom_fr_inscriptions_pays');
|
||
$this->dataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), ' sta_commande=3'));
|
||
}
|
||
|
||
protected function CreatePageNavigator()
|
||
{
|
||
$result = new CompositePageNavigator($this);
|
||
|
||
$partitionNavigator = new PageNavigator('pnav', $this, $this->dataset);
|
||
$partitionNavigator->SetRowsPerPage(20);
|
||
$result->AddPageNavigator($partitionNavigator);
|
||
|
||
return $result;
|
||
}
|
||
|
||
public function GetPageList()
|
||
{
|
||
$currentPageCaption = $this->GetShortCaption();
|
||
$result = new PageList($this);
|
||
if (GetCurrentUserGrantForDataSource('Participants')->HasViewGrant())
|
||
$result->AddPage(new PageLink($this->RenderText('Participants'), 'Brompton2014.php', $this->RenderText('Participants'), $currentPageCaption == $this->RenderText('Participants')));
|
||
|
||
if ( HasAdminPage() && GetApplication()->HasAdminGrantForCurrentUser() )
|
||
$result->AddPage(new PageLink($this->GetLocalizerCaptions()->GetMessageString('AdminPage'), 'phpgen_admin.php', $this->GetLocalizerCaptions()->GetMessageString('AdminPage'), false, true));
|
||
return $result;
|
||
}
|
||
|
||
protected function CreateRssGenerator()
|
||
{
|
||
return null;
|
||
}
|
||
|
||
protected function CreateGridSearchControl(Grid $grid)
|
||
{
|
||
$grid->UseFilter = true;
|
||
$grid->SearchControl = new SimpleSearch('Participantsssearch', $this->dataset,
|
||
array('no_commande', 'no_panier', 'eve_nom_fr', 'epr_type_fr', 'epr_nom_fr', 'par_no_equipe', 'epr_date', 'epr_heure', 'par_nom', 'par_prenom', 'par_naissance', 'par_age', 'par_sexe', 'par_adresse', 'par_ville', 'pro_id_pro_nom_fr', 'pay_id_pay_nom_fr', 'par_codepostal', 'par_telephone1', 'par_courriel', 'ach_maj', 'TransactionID', 'cp_details_fr', 'Parler', 'produits_nonmembre', 'produits_corpotandem', 'produits_corpo', 'tot_facture', 'rab_montant', 'rab_description_fr', 'Category', 'Categoryequipe', 'par_nom_equipe', 'membreTQ', 'numeroTQ', 'par_frais_tvq', 'par_frais_tps', 'par_frais_montant'),
|
||
array($this->RenderText('No Commande'), $this->RenderText('No Panier'), $this->RenderText('<27>venement'), $this->RenderText('<27>preuve'), $this->RenderText('<27>preuve d<>tails'), $this->RenderText('Par No Equipe'), $this->RenderText(' Date'), $this->RenderText('Heure'), $this->RenderText('Nom'), $this->RenderText('Prenom'), $this->RenderText('Naissance'), $this->RenderText('Age'), $this->RenderText('Sexe'), $this->RenderText('Adresse'), $this->RenderText('Ville'), $this->RenderText('Province'), $this->RenderText('Pays'), $this->RenderText('Codepostal'), $this->RenderText('Telephone'), $this->RenderText('Courriel'), $this->RenderText('Data achat'), $this->RenderText('TransactionID'), $this->RenderText('Prix'), $this->RenderText('Parler'), $this->RenderText('TQ non membre'), $this->RenderText('Corpo Tandem'), $this->RenderText('Corpo'), $this->RenderText('Tot Facture'), $this->RenderText('Rab Montant'), $this->RenderText('Rab Description Fr'), $this->RenderText('Category'), $this->RenderText('Categoryequipe'), $this->RenderText('Par Nom Equipe'), $this->RenderText('MembreTQ'), $this->RenderText('NumeroTQ'), $this->RenderText('Par Frais Tvq'), $this->RenderText('Par Frais Tps'), $this->RenderText('Par Frais Montant')),
|
||
array(
|
||
'=' => $this->GetLocalizerCaptions()->GetMessageString('equals'),
|
||
'<>' => $this->GetLocalizerCaptions()->GetMessageString('doesNotEquals'),
|
||
'<' => $this->GetLocalizerCaptions()->GetMessageString('isLessThan'),
|
||
'<=' => $this->GetLocalizerCaptions()->GetMessageString('isLessThanOrEqualsTo'),
|
||
'>' => $this->GetLocalizerCaptions()->GetMessageString('isGreaterThan'),
|
||
'>=' => $this->GetLocalizerCaptions()->GetMessageString('isGreaterThanOrEqualsTo'),
|
||
'ILIKE' => $this->GetLocalizerCaptions()->GetMessageString('Like'),
|
||
'STARTS' => $this->GetLocalizerCaptions()->GetMessageString('StartsWith'),
|
||
'ENDS' => $this->GetLocalizerCaptions()->GetMessageString('EndsWith'),
|
||
'CONTAINS' => $this->GetLocalizerCaptions()->GetMessageString('Contains')
|
||
), $this->GetLocalizerCaptions(), $this, 'CONTAINS'
|
||
);
|
||
}
|
||
|
||
protected function CreateGridAdvancedSearchControl(Grid $grid)
|
||
{
|
||
$this->AdvancedSearchControl = new AdvancedSearchControl('Participantsasearch', $this->dataset, $this->GetLocalizerCaptions(), $this->GetColumnVariableContainer(), $this->CreateLinkBuilder());
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('no_commande', $this->RenderText('No Commande')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('no_panier', $this->RenderText('No Panier')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('eve_nom_fr', $this->RenderText('<27>venement')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('epr_type_fr', $this->RenderText('<27>preuve')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('epr_nom_fr', $this->RenderText('<27>preuve d<>tails')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_no_equipe', $this->RenderText('Par No Equipe')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('epr_date', $this->RenderText(' Date')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('epr_heure', $this->RenderText('Heure')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_nom', $this->RenderText('Nom')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_prenom', $this->RenderText('Prenom')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('par_naissance', $this->RenderText('Naissance')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_age', $this->RenderText('Age')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_sexe', $this->RenderText('Sexe')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_adresse', $this->RenderText('Adresse')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_ville', $this->RenderText('Ville')));
|
||
|
||
$lookupDataset = new TableDataset(
|
||
new MyConnectionFactory(),
|
||
GetConnectionOptions(),
|
||
'`inscriptions_provinces`');
|
||
$field = new IntegerField('pro_id', null, null, true);
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, true);
|
||
$field = new StringField('pro_nom_fr');
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new StringField('pro_nom_en');
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new StringField('pro_iso');
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new IntegerField('pro_defaut');
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new IntegerField('pro_actif');
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new StringField('pro_paypal');
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new IntegerField('pro_trie');
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, false);
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateLookupSearchInput('pro_id', $this->RenderText('Province'), $lookupDataset, 'pro_id', 'pro_nom_fr', false));
|
||
|
||
$lookupDataset = new TableDataset(
|
||
new MyConnectionFactory(),
|
||
GetConnectionOptions(),
|
||
'`inscriptions_pays`');
|
||
$field = new IntegerField('pay_id', null, null, true);
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, true);
|
||
$field = new StringField('pay_nom_fr');
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new StringField('pay_nom_en');
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new StringField('pay_iso');
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new IntegerField('pay_defaut');
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new IntegerField('pay_actif');
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, false);
|
||
$field = new IntegerField('pay_trie');
|
||
$field->SetIsNotNull(true);
|
||
$lookupDataset->AddField($field, false);
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateLookupSearchInput('pay_id', $this->RenderText('Pays'), $lookupDataset, 'pay_id', 'pay_nom_fr', false));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_codepostal', $this->RenderText('Codepostal')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_telephone1', $this->RenderText('Telephone')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_courriel', $this->RenderText('Courriel')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('ach_maj', $this->RenderText('Data achat')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('TransactionID', $this->RenderText('TransactionID')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('cp_details_fr', $this->RenderText('Prix')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Parler', $this->RenderText('Parler')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('produits_nonmembre', $this->RenderText('TQ non membre')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('produits_corpotandem', $this->RenderText('Corpo Tandem')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('produits_corpo', $this->RenderText('Corpo')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('tot_facture', $this->RenderText('Tot Facture')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('rab_montant', $this->RenderText('Rab Montant')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('rab_description_fr', $this->RenderText('Rab Description Fr')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Category', $this->RenderText('Category')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Categoryequipe', $this->RenderText('Categoryequipe')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_nom_equipe', $this->RenderText('Par Nom Equipe')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('membreTQ', $this->RenderText('MembreTQ')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('numeroTQ', $this->RenderText('NumeroTQ')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_tvq', $this->RenderText('Par Frais Tvq')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_tps', $this->RenderText('Par Frais Tps')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_montant', $this->RenderText('Par Frais Montant')));
|
||
}
|
||
|
||
protected function AddOperationsColumns(Grid $grid)
|
||
{
|
||
$actionsBandName = 'actions';
|
||
$grid->AddBandToBegin($actionsBandName, $this->GetLocalizerCaptions()->GetMessageString('Actions'), true);
|
||
if ($this->GetSecurityInfo()->HasViewGrant())
|
||
{
|
||
$column = new RowOperationByLinkColumn($this->GetLocalizerCaptions()->GetMessageString('View'), OPERATION_VIEW, $this->dataset);
|
||
$grid->AddViewColumn($column, $actionsBandName);
|
||
$column->SetImagePath('images/view_action.png');
|
||
}
|
||
}
|
||
|
||
protected function AddFieldColumns(Grid $grid)
|
||
{
|
||
//
|
||
// View column for no_commande field
|
||
//
|
||
$column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for no_panier field
|
||
//
|
||
$column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for eve_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eve_nom_fr', '<27>venement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_type_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_type_fr', '<27>preuve', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_nom_fr', '<27>preuve d<>tails', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_no_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_no_equipe', 'Par No Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_date field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_date', ' Date', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_heure field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_heure', 'Heure', $this->dataset);
|
||
$column->SetDateTimeFormat('H:i:s');
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_nom field
|
||
//
|
||
$column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_prenom field
|
||
//
|
||
$column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_naissance field
|
||
//
|
||
$column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_age field
|
||
//
|
||
$column = new TextViewColumn('par_age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_sexe field
|
||
//
|
||
$column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_adresse field
|
||
//
|
||
$column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_ville field
|
||
//
|
||
$column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for pro_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for pay_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pay_id_pay_nom_fr', 'Pays', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_codepostal field
|
||
//
|
||
$column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_telephone1 field
|
||
//
|
||
$column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_courriel field
|
||
//
|
||
$column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for ach_maj field
|
||
//
|
||
$column = new DateTimeViewColumn('ach_maj', 'Data achat', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d H:i:s');
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for TransactionID field
|
||
//
|
||
$column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for cp_details_fr field
|
||
//
|
||
$column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for Parler field
|
||
//
|
||
$column = new TextViewColumn('Parler', 'Parler', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for produits_nonmembre field
|
||
//
|
||
$column = new TextViewColumn('produits_nonmembre', 'TQ non membre', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpotandem field
|
||
//
|
||
$column = new TextViewColumn('produits_corpotandem', 'Corpo Tandem', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpo field
|
||
//
|
||
$column = new TextViewColumn('produits_corpo', 'Corpo', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for tot_facture field
|
||
//
|
||
$column = new TextViewColumn('tot_facture', 'Tot Facture', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for rab_montant field
|
||
//
|
||
$column = new TextViewColumn('rab_montant', 'Rab Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for rab_description_fr field
|
||
//
|
||
$column = new TextViewColumn('rab_description_fr', 'Rab Description Fr', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for Category field
|
||
//
|
||
$column = new TextViewColumn('Category', 'Category', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('Category_handler');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for Categoryequipe field
|
||
//
|
||
$column = new TextViewColumn('Categoryequipe', 'Categoryequipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('Categoryequipe_handler');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_nom_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for membreTQ field
|
||
//
|
||
$column = new TextViewColumn('membreTQ', 'MembreTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('membreTQ_handler');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for numeroTQ field
|
||
//
|
||
$column = new TextViewColumn('numeroTQ', 'NumeroTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('numeroTQ_handler');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tvq field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tvq', 'Par Frais Tvq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tps field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tps', 'Par Frais Tps', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_montant field
|
||
//
|
||
$column = new TextViewColumn('par_frais_montant', 'Par Frais Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
}
|
||
|
||
protected function AddSingleRecordViewColumns(Grid $grid)
|
||
{
|
||
//
|
||
// View column for no_commande field
|
||
//
|
||
$column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for no_panier field
|
||
//
|
||
$column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for eve_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eve_nom_fr', 'Eve Nom Fr', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_type_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_type_fr', '<27>preuve', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_nom_fr', 'Epr Nom Fr', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_no_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_no_equipe', 'Par No Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_date field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_date', 'Epr Date', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for epr_heure field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_heure', 'Epr Heure', $this->dataset);
|
||
$column->SetDateTimeFormat('H:i:s');
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_nom field
|
||
//
|
||
$column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_prenom field
|
||
//
|
||
$column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_naissance field
|
||
//
|
||
$column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_age field
|
||
//
|
||
$column = new TextViewColumn('par_age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_sexe field
|
||
//
|
||
$column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_adresse field
|
||
//
|
||
$column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_ville field
|
||
//
|
||
$column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for pro_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for pay_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pay_id_pay_nom_fr', 'Pays', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_codepostal field
|
||
//
|
||
$column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_telephone1 field
|
||
//
|
||
$column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_courriel field
|
||
//
|
||
$column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for ach_maj field
|
||
//
|
||
$column = new DateTimeViewColumn('ach_maj', 'Ach Maj', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d H:i:s');
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for TransactionID field
|
||
//
|
||
$column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for cp_details_fr field
|
||
//
|
||
$column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Parler field
|
||
//
|
||
$column = new TextViewColumn('Parler', 'Parler', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for produits_nonmembre field
|
||
//
|
||
$column = new TextViewColumn('produits_nonmembre', 'TQ non membre', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpotandem field
|
||
//
|
||
$column = new TextViewColumn('produits_corpotandem', 'Corpo Tandem', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpo field
|
||
//
|
||
$column = new TextViewColumn('produits_corpo', 'Corpo', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for tot_facture field
|
||
//
|
||
$column = new TextViewColumn('tot_facture', 'Tot Facture', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for rab_montant field
|
||
//
|
||
$column = new TextViewColumn('rab_montant', 'Rab Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for rab_description_fr field
|
||
//
|
||
$column = new TextViewColumn('rab_description_fr', 'Rab Description Fr', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Category field
|
||
//
|
||
$column = new TextViewColumn('Category', 'Category', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('Category_handler');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Categoryequipe field
|
||
//
|
||
$column = new TextViewColumn('Categoryequipe', 'Categoryequipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('Categoryequipe_handler');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_nom_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for membreTQ field
|
||
//
|
||
$column = new TextViewColumn('membreTQ', 'MembreTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('membreTQ_handler');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for numeroTQ field
|
||
//
|
||
$column = new TextViewColumn('numeroTQ', 'NumeroTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('numeroTQ_handler');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tvq field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tvq', 'Par Frais Tvq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tps field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tps', 'Par Frais Tps', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_montant field
|
||
//
|
||
$column = new TextViewColumn('par_frais_montant', 'Par Frais Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
}
|
||
|
||
protected function AddEditColumns(Grid $grid)
|
||
{
|
||
|
||
}
|
||
|
||
protected function AddInsertColumns(Grid $grid)
|
||
{
|
||
|
||
if ($this->GetSecurityInfo()->HasAddGrant())
|
||
{
|
||
$grid->SetShowAddButton(false);
|
||
$grid->SetShowInlineAddButton(false);
|
||
}
|
||
else
|
||
{
|
||
$grid->SetShowInlineAddButton(false);
|
||
$grid->SetShowAddButton(false);
|
||
}
|
||
}
|
||
|
||
protected function AddPrintColumns(Grid $grid)
|
||
{
|
||
//
|
||
// View column for no_commande field
|
||
//
|
||
$column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for no_panier field
|
||
//
|
||
$column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for eve_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eve_nom_fr', '<27>venement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for epr_type_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_type_fr', '<27>preuve', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for epr_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_nom_fr', '<27>preuve d<>tails', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_no_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_no_equipe', 'Par No Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for epr_date field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_date', ' Date', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for epr_heure field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_heure', 'Heure', $this->dataset);
|
||
$column->SetDateTimeFormat('H:i:s');
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_nom field
|
||
//
|
||
$column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_prenom field
|
||
//
|
||
$column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_naissance field
|
||
//
|
||
$column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_age field
|
||
//
|
||
$column = new TextViewColumn('par_age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_sexe field
|
||
//
|
||
$column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_adresse field
|
||
//
|
||
$column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_ville field
|
||
//
|
||
$column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for pro_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for pay_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pay_id_pay_nom_fr', 'Pays', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_codepostal field
|
||
//
|
||
$column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_telephone1 field
|
||
//
|
||
$column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_courriel field
|
||
//
|
||
$column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for ach_maj field
|
||
//
|
||
$column = new DateTimeViewColumn('ach_maj', 'Data achat', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d H:i:s');
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for TransactionID field
|
||
//
|
||
$column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for cp_details_fr field
|
||
//
|
||
$column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for Parler field
|
||
//
|
||
$column = new TextViewColumn('Parler', 'Parler', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for produits_nonmembre field
|
||
//
|
||
$column = new TextViewColumn('produits_nonmembre', 'TQ non membre', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpotandem field
|
||
//
|
||
$column = new TextViewColumn('produits_corpotandem', 'Corpo Tandem', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpo field
|
||
//
|
||
$column = new TextViewColumn('produits_corpo', 'Corpo', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for tot_facture field
|
||
//
|
||
$column = new TextViewColumn('tot_facture', 'Tot Facture', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for rab_montant field
|
||
//
|
||
$column = new TextViewColumn('rab_montant', 'Rab Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for rab_description_fr field
|
||
//
|
||
$column = new TextViewColumn('rab_description_fr', 'Rab Description Fr', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for Category field
|
||
//
|
||
$column = new TextViewColumn('Category', 'Category', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for Categoryequipe field
|
||
//
|
||
$column = new TextViewColumn('Categoryequipe', 'Categoryequipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_nom_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for membreTQ field
|
||
//
|
||
$column = new TextViewColumn('membreTQ', 'MembreTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for numeroTQ field
|
||
//
|
||
$column = new TextViewColumn('numeroTQ', 'NumeroTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tvq field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tvq', 'Par Frais Tvq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tps field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tps', 'Par Frais Tps', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_montant field
|
||
//
|
||
$column = new TextViewColumn('par_frais_montant', 'Par Frais Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
}
|
||
|
||
protected function AddExportColumns(Grid $grid)
|
||
{
|
||
//
|
||
// View column for no_commande field
|
||
//
|
||
$column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for no_panier field
|
||
//
|
||
$column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for eve_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eve_nom_fr', '<27>venement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for epr_type_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_type_fr', '<27>preuve', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for epr_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('epr_nom_fr', '<27>preuve d<>tails', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_no_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_no_equipe', 'Par No Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for epr_date field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_date', ' Date', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for epr_heure field
|
||
//
|
||
$column = new DateTimeViewColumn('epr_heure', 'Heure', $this->dataset);
|
||
$column->SetDateTimeFormat('H:i:s');
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_nom field
|
||
//
|
||
$column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_prenom field
|
||
//
|
||
$column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_naissance field
|
||
//
|
||
$column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d');
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_age field
|
||
//
|
||
$column = new TextViewColumn('par_age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_sexe field
|
||
//
|
||
$column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_adresse field
|
||
//
|
||
$column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_ville field
|
||
//
|
||
$column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for pro_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for pay_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pay_id_pay_nom_fr', 'Pays', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_codepostal field
|
||
//
|
||
$column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_telephone1 field
|
||
//
|
||
$column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_courriel field
|
||
//
|
||
$column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for ach_maj field
|
||
//
|
||
$column = new DateTimeViewColumn('ach_maj', 'Data achat', $this->dataset);
|
||
$column->SetDateTimeFormat('Y-m-d H:i:s');
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for TransactionID field
|
||
//
|
||
$column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for cp_details_fr field
|
||
//
|
||
$column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for Parler field
|
||
//
|
||
$column = new TextViewColumn('Parler', 'Parler', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for produits_nonmembre field
|
||
//
|
||
$column = new TextViewColumn('produits_nonmembre', 'TQ non membre', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpotandem field
|
||
//
|
||
$column = new TextViewColumn('produits_corpotandem', 'Corpo Tandem', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for produits_corpo field
|
||
//
|
||
$column = new TextViewColumn('produits_corpo', 'Corpo', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for tot_facture field
|
||
//
|
||
$column = new TextViewColumn('tot_facture', 'Tot Facture', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for rab_montant field
|
||
//
|
||
$column = new TextViewColumn('rab_montant', 'Rab Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for rab_description_fr field
|
||
//
|
||
$column = new TextViewColumn('rab_description_fr', 'Rab Description Fr', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for Category field
|
||
//
|
||
$column = new TextViewColumn('Category', 'Category', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for Categoryequipe field
|
||
//
|
||
$column = new TextViewColumn('Categoryequipe', 'Categoryequipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_nom_equipe field
|
||
//
|
||
$column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for membreTQ field
|
||
//
|
||
$column = new TextViewColumn('membreTQ', 'MembreTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for numeroTQ field
|
||
//
|
||
$column = new TextViewColumn('numeroTQ', 'NumeroTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tvq field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tvq', 'Par Frais Tvq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tps field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tps', 'Par Frais Tps', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_montant field
|
||
//
|
||
$column = new TextViewColumn('par_frais_montant', 'Par Frais Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
}
|
||
|
||
public function GetPageDirection()
|
||
{
|
||
return null;
|
||
}
|
||
|
||
protected function ApplyCommonColumnEditProperties(CustomEditColumn $column)
|
||
{
|
||
$column->SetShowSetToNullCheckBox(false);
|
||
$column->SetVariableContainer($this->GetColumnVariableContainer());
|
||
}
|
||
|
||
function GetCustomClientScript()
|
||
{
|
||
return ;
|
||
}
|
||
|
||
function GetOnPageLoadedClientScript()
|
||
{
|
||
return ;
|
||
}
|
||
|
||
protected function CreateGrid()
|
||
{
|
||
$result = new Grid($this, $this->dataset, 'ParticipantsGrid');
|
||
if ($this->GetSecurityInfo()->HasDeleteGrant())
|
||
$result->SetAllowDeleteSelected(false);
|
||
else
|
||
$result->SetAllowDeleteSelected(false);
|
||
|
||
ApplyCommonPageSettings($this, $result);
|
||
|
||
$result->SetUseImagesForActions(true);
|
||
$result->SetUseFixedHeader(false);
|
||
|
||
$result->SetShowLineNumbers(false);
|
||
|
||
$result->SetHighlightRowAtHover(false);
|
||
$result->SetWidth('');
|
||
$this->CreateGridSearchControl($result);
|
||
$this->CreateGridAdvancedSearchControl($result);
|
||
$this->AddOperationsColumns($result);
|
||
$this->AddFieldColumns($result);
|
||
$this->AddSingleRecordViewColumns($result);
|
||
$this->AddEditColumns($result);
|
||
$this->AddInsertColumns($result);
|
||
$this->AddPrintColumns($result);
|
||
$this->AddExportColumns($result);
|
||
|
||
$this->SetShowPageList(true);
|
||
$this->SetHidePageListByDefault(false);
|
||
$this->SetExportToExcelAvailable(true);
|
||
$this->SetExportToWordAvailable(true);
|
||
$this->SetExportToXmlAvailable(true);
|
||
$this->SetExportToCsvAvailable(true);
|
||
$this->SetExportToPdfAvailable(true);
|
||
$this->SetPrinterFriendlyAvailable(true);
|
||
$this->SetSimpleSearchAvailable(true);
|
||
$this->SetAdvancedSearchAvailable(true);
|
||
$this->SetFilterRowAvailable(true);
|
||
$this->SetVisualEffectsEnabled(true);
|
||
$this->SetShowTopPageNavigator(true);
|
||
$this->SetShowBottomPageNavigator(true);
|
||
|
||
//
|
||
// Http Handlers
|
||
//
|
||
//
|
||
// View column for Category field
|
||
//
|
||
$column = new TextViewColumn('Category', 'Category', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Category_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
//
|
||
// View column for Categoryequipe field
|
||
//
|
||
$column = new TextViewColumn('Categoryequipe', 'Categoryequipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Categoryequipe_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
//
|
||
// View column for membreTQ field
|
||
//
|
||
$column = new TextViewColumn('membreTQ', 'MembreTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'membreTQ_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
//
|
||
// View column for numeroTQ field
|
||
//
|
||
$column = new TextViewColumn('numeroTQ', 'NumeroTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'numeroTQ_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);//
|
||
// View column for Category field
|
||
//
|
||
$column = new TextViewColumn('Category', 'Category', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Category_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
//
|
||
// View column for Categoryequipe field
|
||
//
|
||
$column = new TextViewColumn('Categoryequipe', 'Categoryequipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Categoryequipe_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
//
|
||
// View column for membreTQ field
|
||
//
|
||
$column = new TextViewColumn('membreTQ', 'MembreTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'membreTQ_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
//
|
||
// View column for numeroTQ field
|
||
//
|
||
$column = new TextViewColumn('numeroTQ', 'NumeroTQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'numeroTQ_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
return $result;
|
||
}
|
||
|
||
public function OpenAdvancedSearchByDefault()
|
||
{
|
||
return false;
|
||
}
|
||
|
||
protected function DoGetGridHeader()
|
||
{
|
||
return '';
|
||
}
|
||
}
|
||
|
||
|
||
|
||
try
|
||
{
|
||
$Page = new ParticipantsPage("Brompton2014.php", "Participants", GetCurrentUserGrantForDataSource("Participants"), 'UTF-8');
|
||
$Page->SetShortCaption('Participants');
|
||
$Page->SetHeader(GetPagesHeader());
|
||
$Page->SetFooter(GetPagesFooter());
|
||
$Page->SetCaption('Participants');
|
||
$Page->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource("Participants"));
|
||
GetApplication()->SetEnableLessRunTimeCompile(GetEnableLessFilesRunTimeCompilation());
|
||
GetApplication()->SetCanUserChangeOwnPassword(
|
||
!function_exists('CanUserChangeOwnPassword') || CanUserChangeOwnPassword());
|
||
GetApplication()->SetMainPage($Page);
|
||
GetApplication()->Run();
|
||
}
|
||
catch(Exception $e)
|
||
{
|
||
ShowErrorPage($e->getMessage());
|
||
}
|
||
|