public function toExcelAction()
{
$this->filename = 'StaticTexts.xlsx';
$this->tables = array('Static_Texts' => array('ST_Identifier', 'ST_Desc_backend', 'ST_Value', 'ST_LangID'));
$this->fields = array('ST_LangID' => array('width' => '', 'label' => ''), 'ST_Desc_backend' => array('width' => '', 'label' => ''), 'ST_Value' => array('width' => '', 'label' => ''));
$this->filters = array();
$staticText = new StaticTexts();
$this->select = $staticText->select()->where('Static_Texts.ST_Editable = ?', 1)->where('Static_Texts.ST_Type = ?', 'client');
parent::toExcelAction();
}
public function toExcelAction()
{
$this->filename = 'Profil.xlsx';
// $this->type = 'Excel5';
// $this->type = 'CSV';
$searchfor = $this->_request->getParam('searchfor');
$profile = new GenericProfile();
$this->select = $profile->getSelectStatement();
$this->tables = array('GenericProfiles' => array('GP_LastName', 'GP_FirstName', 'GP_Email'));
$this->fields = array('lastName' => array('width' => '', 'label' => ''), 'firstName' => array('width' => '', 'label' => ''), 'email' => array('width' => '', 'label' => ''));
$this->filters = array();
parent::toExcelAction();
}
public function toExcelAction()
{
$this->filename = 'Administrators.xlsx';
$this->tables = array('Extranet_Users' => array('EU_ID', 'EU_LName', 'EU_FName', 'EU_Email'));
$this->fields = array('EU_FName' => array('width' => '', 'label' => ''), 'EU_LName' => array('width' => '', 'label' => ''), 'EU_Email' => array('width' => '', 'label' => ''));
$this->filters = array();
$administratorData = new ExtranetUsers();
$this->select = $administratorData->select();
parent::toExcelAction();
}
