di controller/cetak.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class cetak extends CI_Controller {
public function index()
{
$this->load->model('model_obat');
$data['data'] = $this->model_obat->tampil();
$this->load->view('cetak',$data);
}
}
di model/model_obat.php
<?php
class model_obat extends CI_Model {
public function Tampil($atribut="")
{
$this->load->database();
if($atribut=="seleksi"){
$sql= "select a.*,b.nama_jenis as nama_jenis,c.kategori as kategori from obat a inner join jenis b on a.id_jenis =
b.id_jenis inner join kategori c on a.id_kategori=c.id_kategori where nama_obat like '%".$this->input->post('pencarian')."%'";
}else{
$sql= "select a.*,b.nama_jenis as nama_jenis,c.kategori as kategori from obat a inner join jenis b on a.id_jenis =
b.id_jenis inner join kategori c on a.id_kategori=c.id_kategori order by a.id_obat DESC";
}
$query = $this->db->query($sql);
return $query->result_array();
}
}
di view/cetak.php
<?php
header("Content-type: application/octet-stream");
header("Content-Disposition:attachment; filename = Laporan_Data_Obat.xls"); //buat file name jangan ada spasi cynk..
header("Pragma:no-cache");
header("Expires:0");
?>
<table width="100px" border="1" align="center">
<tr bgcolor="#336699">
<th>No</th>
<th>Kategori</th>
<th>nama obat</th>
<th>jenis obat</th>
<th align="center">gambar</th>
<th>harga</th>
<th>aksi</th>
</tr>
<tr>
<?php
$no=1;
foreach ($data as $row)
{
echo "<tr>";
echo "<td>".$no."</td>";
echo "<td>".$row['kategori']."</td>";
echo "<td>".$row['nama_obat']."</td>";
echo "<td>".$row['nama_jenis']."</td>";
echo "<td>"."<img src=http://localhost/template/data/gambar/".$row['gambar'].">"."</td>";
echo "<td>".$row['harga']."</td>";
echo "<td align=\"center\"> <a href='".base_url()."index.php/obat/edit/".$row ['id_obat']."'>Edit |</a>
<a href=\"".base_url()."index.php/obat/hapus/".$row ['id_obat']."\"> Hapus</td>";
echo "</tr>";
$no++;
}
?>
</table>
Langganan:
Posting Komentar (Atom)
0 komentar:
Posting Komentar