1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
class ExporterController extends Zend_Controller_Action
{
function indexAction()
{
// $this->_redirect('/exporter');
}
function excelAction()
{
$this->Excel();
}
private function Excel()
{
$this->_helper->resetHelpers();
/**
* On génère le fichier de base
*/
$workbook = new Spreadsheet_Excel_Writer();
$workbook->send('base.xls');
$worksheet = $workbook->addWorksheet();
// $db = Zend_Registry::get('dbAdapter');
// $select = $db->select();
// $select->from(array('p' => 'personne'), '*');
// $select->join(array('c' => 'cohtion'), 'p.NUMPERSONNE = c.NUMPERSONNE', '*');
// $select->join(array('pa' => 'paiement'), 'c.NUMPAIEMENT = pa.NUMPAIEMENT', '*');
// $select->where('p.NUMROLE IN (?)', array(2, 3));
// $sql = $select->__toString();
// $this->view->personne = $db->fetchAll($sql);
// $i=0;
// $personne = new Personne();
// foreach($this->personne as $personne) :
// for ($j=0; $j<5; $j++) {
// $worksheet->write($i,$j,$personne[$j]);
// $worksheet->write($i,$j,$personne['PRENOM']);
// $worksheet->write($i,$j,$personne['MONTANT']);
// $worksheet->write($i,$j,$personne['TYPE']);
// $worksheet->write($i,$j,$personne['NBRPAIEMENT']);
// }
// $i++;
// endforeach;
$worksheet->write(1,2,'toto');
$workbook->close();
$workbook->sendFile();
}
} |
Partager