Controladorr////////
<?php
/**
* reporteherramientasController
*
* @author
* @version
*/
require_once 'Zend/Controller/Action.php';
class reporteherramientasController extends Zend_Controller_Action
{
/**
* The default action - show the home page
*/
public function indexAction ()
{
// TODO Auto-generated reporteherramientasController::indexAction() default action
}
public function reporteherramientasAction()
{
//llamo a mi modelo
$order = new reporteherramientasModel();
$this->view->herramientas=$order->actualizar();
}
}
Modelo///////////
<?php
/**
* reportesModel
*
* @author Vanegas-SENA
* @version
*/
require_once 'Zend/Db/Table/Abstract.php';
class reporteherramientasModel extends Zend_Db_Table_Abstract
{
/**
* The default table name
*/
protected $_name = 'herramientas';
public function actualizar()
{
$select = $this->select();
$select->order('nombre');
return $this->fetchAll($select);
}
}
Vista////////
<?php
header("Pragma: public");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: pre-check=0, post-check=0, max-age=0");
header("Pragma: no-cache");
header("Expires: 0");
header("Content-Transfer-Encoding: none");
header("Content-Type: application/vnd.ms-excel;");
header("Content-type: application/x-msexcel");
header("Content-Disposition: attachment; filename=report2_opendebitsummary".date('Ymd').".x ls");
?>
<html>
<body>
<h1>Reporte de Inventario de las Herramientas SAGAS</h1>
<table border="1">
<tr >
<td >orden Lista</td>
<td >Serial</td>
<td >Nombre</td>
<td >Cantidad</td>
<td >Descripcion</td>
<td >Fecha Ingreso</td>
<td >Estado</td>
<td >Almacen</td>
<td >Bodega</td>
</tr>
<?php foreach($this->herramientas as $order):?>
<tr>
<td ><?php echo $this->escape($order -> idherramientas);?></td>
<td ><?php echo $this->escape($order -> serial);?></td>
<td ><?php echo $this->escape($order -> nombre);?></td>
<td ><?php echo $this->escape($order -> cantidad);?></td>
<td ><?php echo $this->escape($order -> descripcion);?></td>
<td ><?php echo $this->escape($order -> fechaIngreso);?></td>
<td ><?php echo $this->escape($order -> idestados);?></td>
<td ><?php echo $this->escape($order -> idalmacenes);?></td>
<td ><?php echo $this->escape($order -> idbodegas);?></td>
</tr>
<?php endforeach;?>
</table>
</body>
</html>