1570 lines
70 KiB
PHP
1570 lines
70 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_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_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_evenements.eve_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_acheteurs.ach_total,
|
||
inscriptions_panier_acheteurs.no_commande,
|
||
inscriptions_paiements.pai_nom_fr,
|
||
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 (23,26,29,32,36,40,44,48,51,57,60) Then inscriptions_panier_questions.que_choix_fr End ) As Category,
|
||
Min( Case When inscriptions_panier_questions.que_id in (18,19,20) Then inscriptions_panier_questions.que_choix_fr End ) As Age,
|
||
Min( Case When inscriptions_panier_questions.que_id in (17) Then inscriptions_panier_questions.que_choix_fr End ) As Parler,
|
||
Min( Case When inscriptions_panier_questions.que_id in (31,66) Then inscriptions_panier_questions.que_choix_fr End ) As Corporatif,
|
||
Min( Case When inscriptions_panier_questions.que_id in (53) Then inscriptions_panier_questions.que_choix_fr End ) As Capitaine ,
|
||
Min( Case When inscriptions_panier_questions.que_id in (21) Then inscriptions_panier_questions.que_choix_fr End ) As TQ,
|
||
Min( Case When inscriptions_panier_questions.que_id in (30) Then inscriptions_panier_questions.que_choix_fr End ) As Equipe,
|
||
Min( Case When inscriptions_panier_questions.que_id in (55,58,49,52) Then inscriptions_panier_questions.que_choix_fr End ) As Etablissement,
|
||
Min( Case When inscriptions_panier_questions.que_id in (22) Then inscriptions_panier_questions.que_choix_fr End ) As numtq
|
||
|
||
|
||
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.no_panier = inscriptions_panier_acheteurs.no_panier
|
||
LEFT JOIN inscriptions_paiements ON inscriptions_panier_acheteurs.pai_id = inscriptions_paiements.pai_id
|
||
left JOIN inscriptions_panier_questions ON inscriptions_panier_acheteurs.par_id = inscriptions_panier_questions.par_id
|
||
|
||
where (inscriptions_panier_participants.eve_id =102) and sta_id=3
|
||
|
||
|
||
GROUP BY inscriptions_panier_participants.par_id';
|
||
$insertQuery = array();
|
||
$updateQuery = array();
|
||
$deleteQuery = array();
|
||
$this->dataset = new QueryDataset(
|
||
new MyConnectionFactory(),
|
||
GetConnectionOptions(),
|
||
$selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Participants');
|
||
$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('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 StringField('eve_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 IntegerField('ach_total');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('no_commande');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('pai_nom_fr');
|
||
$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('Age');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('Parler');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('Corporatif');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('Capitaine');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('TQ');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('Equipe');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('Etablissement');
|
||
$this->dataset->AddField($field, false);
|
||
$field = new StringField('numtq');
|
||
$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(), '(eve_id=15) and sta_id=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'), 'onedrop.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', 'eve_nom_fr', 'epr_type_fr', 'epr_nom_fr', 'eta_nom_fr', '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', 'par_prix', 'pai_nom_fr', 'par_frais_tvq', 'par_frais_tps', 'par_frais_montant', 'ach_maj', 'TransactionID', 'no_panier', 'cp_details_fr', 'Age', 'Parler', 'Corporatif', 'Capitaine', 'TQ', 'Equipe', 'Etablissement', 'numtq'),
|
||
array($this->RenderText('No Commande'), $this->RenderText('<27>venement'), $this->RenderText('<27>preuve'), $this->RenderText('<27>preuve d<>tails'), $this->RenderText('<27>tapes'), $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('Prix'), $this->RenderText('Paiement'), $this->RenderText('Frais Tvq'), $this->RenderText('Frais Tps'), $this->RenderText('Frais Montant'), $this->RenderText('Data achat'), $this->RenderText('TransactionID'), $this->RenderText('No Panier'), $this->RenderText('Prix'), $this->RenderText('Age'), $this->RenderText('Parler'), $this->RenderText('Corporatif'), $this->RenderText('Capitaine'), $this->RenderText('TQ'), $this->RenderText('Equipe'), $this->RenderText('Etablissement'), $this->RenderText('Numtq')),
|
||
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('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('eta_nom_fr', $this->RenderText('<27>tapes')));
|
||
$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->CreateStringSearchInput('par_prix', $this->RenderText('Prix')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('pai_nom_fr', $this->RenderText('Paiement')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_tvq', $this->RenderText('Frais Tvq')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_tps', $this->RenderText('Frais Tps')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_montant', $this->RenderText('Frais Montant')));
|
||
$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('no_panier', $this->RenderText('No Panier')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('cp_details_fr', $this->RenderText('Prix')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Age', $this->RenderText('Age')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Parler', $this->RenderText('Parler')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Corporatif', $this->RenderText('Corporatif')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Capitaine', $this->RenderText('Capitaine')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('TQ', $this->RenderText('TQ')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Equipe', $this->RenderText('Equipe')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Etablissement', $this->RenderText('Etablissement')));
|
||
$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('numtq', $this->RenderText('Numtq')));
|
||
}
|
||
|
||
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 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 eta_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eta_nom_fr', '<27>tapes', $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 par_prix field
|
||
//
|
||
$column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for pai_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pai_nom_fr', 'Paiement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tvq field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tvq', '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', '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', 'Frais Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$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 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 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 Age field
|
||
//
|
||
$column = new TextViewColumn('Age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('Age_handler');
|
||
$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 Corporatif field
|
||
//
|
||
$column = new TextViewColumn('Corporatif', 'Corporatif', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for Capitaine field
|
||
//
|
||
$column = new TextViewColumn('Capitaine', 'Capitaine', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for TQ field
|
||
//
|
||
$column = new TextViewColumn('TQ', 'TQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for Equipe field
|
||
//
|
||
$column = new TextViewColumn('Equipe', 'Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for Etablissement field
|
||
//
|
||
$column = new TextViewColumn('Etablissement', 'Etablissement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
|
||
//
|
||
// View column for numtq field
|
||
//
|
||
$column = new TextViewColumn('numtq', 'Numtq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetDescription($this->RenderText(''));
|
||
$column->SetFixedWidth(null);
|
||
$grid->AddViewColumn($column);
|
||
}
|
||
|
||
protected function AddSingleRecordViewColumns(Grid $grid)
|
||
{
|
||
//
|
||
// 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 eta_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eta_nom_fr', 'Eta Nom Fr', $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 par_prix field
|
||
//
|
||
$column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$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 no_panier field
|
||
//
|
||
$column = new TextViewColumn('no_panier', 'No Panier', $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 Age field
|
||
//
|
||
$column = new TextViewColumn('Age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column->SetMaxLength(75);
|
||
$column->SetFullTextWindowHandlerName('Age_handler');
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Parler field
|
||
//
|
||
$column = new TextViewColumn('Parler', 'Parler', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Corporatif field
|
||
//
|
||
$column = new TextViewColumn('Corporatif', 'Corporatif', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Capitaine field
|
||
//
|
||
$column = new TextViewColumn('Capitaine', 'Capitaine', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for TQ field
|
||
//
|
||
$column = new TextViewColumn('TQ', 'TQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Equipe field
|
||
//
|
||
$column = new TextViewColumn('Equipe', 'Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for Etablissement field
|
||
//
|
||
$column = new TextViewColumn('Etablissement', 'Etablissement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddSingleRecordViewColumn($column);
|
||
|
||
//
|
||
// View column for numtq field
|
||
//
|
||
$column = new TextViewColumn('numtq', 'Numtq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$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 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 eta_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eta_nom_fr', '<27>tapes', $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 par_prix field
|
||
//
|
||
$column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for pai_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pai_nom_fr', 'Paiement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tvq field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tvq', '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', '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', 'Frais Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$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 no_panier field
|
||
//
|
||
$column = new TextViewColumn('no_panier', 'No Panier', $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 Age field
|
||
//
|
||
$column = new TextViewColumn('Age', 'Age', $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 Corporatif field
|
||
//
|
||
$column = new TextViewColumn('Corporatif', 'Corporatif', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for Capitaine field
|
||
//
|
||
$column = new TextViewColumn('Capitaine', 'Capitaine', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for TQ field
|
||
//
|
||
$column = new TextViewColumn('TQ', 'TQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for Equipe field
|
||
//
|
||
$column = new TextViewColumn('Equipe', 'Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for Etablissement field
|
||
//
|
||
$column = new TextViewColumn('Etablissement', 'Etablissement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddPrintColumn($column);
|
||
|
||
//
|
||
// View column for numtq field
|
||
//
|
||
$column = new TextViewColumn('numtq', 'Numtq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$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 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 eta_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('eta_nom_fr', '<27>tapes', $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 par_prix field
|
||
//
|
||
$column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for pai_nom_fr field
|
||
//
|
||
$column = new TextViewColumn('pai_nom_fr', 'Paiement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for par_frais_tvq field
|
||
//
|
||
$column = new TextViewColumn('par_frais_tvq', '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', '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', 'Frais Montant', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
|
||
$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 no_panier field
|
||
//
|
||
$column = new TextViewColumn('no_panier', 'No Panier', $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 Age field
|
||
//
|
||
$column = new TextViewColumn('Age', 'Age', $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 Corporatif field
|
||
//
|
||
$column = new TextViewColumn('Corporatif', 'Corporatif', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for Capitaine field
|
||
//
|
||
$column = new TextViewColumn('Capitaine', 'Capitaine', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for TQ field
|
||
//
|
||
$column = new TextViewColumn('TQ', 'TQ', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for Equipe field
|
||
//
|
||
$column = new TextViewColumn('Equipe', 'Equipe', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for Etablissement field
|
||
//
|
||
$column = new TextViewColumn('Etablissement', 'Etablissement', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$grid->AddExportColumn($column);
|
||
|
||
//
|
||
// View column for numtq field
|
||
//
|
||
$column = new TextViewColumn('numtq', 'Numtq', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$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 Age field
|
||
//
|
||
$column = new TextViewColumn('Age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Age_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);//
|
||
// View column for Age field
|
||
//
|
||
$column = new TextViewColumn('Age', 'Age', $this->dataset);
|
||
$column->SetOrderable(true);
|
||
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Age_handler', $column);
|
||
GetApplication()->RegisterHTTPHandler($handler);
|
||
return $result;
|
||
}
|
||
|
||
public function OpenAdvancedSearchByDefault()
|
||
{
|
||
return false;
|
||
}
|
||
|
||
protected function DoGetGridHeader()
|
||
{
|
||
return '';
|
||
}
|
||
}
|
||
|
||
|
||
|
||
try
|
||
{
|
||
$Page = new ParticipantsPage("onedrop.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());
|
||
}
|
||
|