function headers()
{
$this->load->library('cezpdf');
$this->load->helper('pdf');
prep_pdf();
// creates the footer for the document we are creating.
$db_data[] = array('name' => 'Jon Doe', 'phone' => '111-222-3333', 'email' => '*****@*****.**');
$db_data[] = array('name' => 'Jane Doe', 'phone' => '222-333-4444', 'email' => '*****@*****.**');
$db_data[] = array('name' => 'Jon Smith', 'phone' => '333-444-5555', 'email' => '*****@*****.**');
$col_names = array('name' => 'Name', 'phone' => 'Phone Number', 'email' => 'E-mail Address');
$this->cezpdf->ezTable($db_data, $col_names, 'Contact List', array('width' => 550));
$this->cezpdf->ezStream();
}
public function index()
{
//Llamado de librerias y helper
$this->load->library('cezpdf');
$this->load->helper('pdf');
prep_pdf();
//Obtener datos para reporte
$municipios = $this->modelo_admin->obt_municipios();
foreach ($municipios as $municipio) {
$db_data[0] = $municipio;
}
/*print_r($db_data);
exit();*/
//Asignacion de encabezados
$col_names = array('nombre' => 'Nombre', 'nombre_departamento' => 'Departamento');
$this->cezpdf->ezTable($db_data, $col_names, 'Listado de municipios', array('width' => 550));
$this->cezpdf->ezStream();
}
function export($type = 'pdf', $title = 'Export')
{
if ($type == 'pdf') {
$this->load->library('cezpdf');
$this->load->helper('pdf');
prep_pdf();
$tempfile = 'temp.txt';
$h = fopen($tempfile, 'r');
if (!$h) {
$contents = array();
} else {
$contents = fread($h, filesize($tempfile));
}
fclose($h);
$contents = unserialize($contents);
//get the col names
$cols = array_keys($contents[0]);
$col_names = array();
foreach ($cols as $col) {
$col_names[$col] = humanizer($col);
}
/** testing data
$db_data[] = array('name' => 'Jon Doe', 'phone' => '111-222-3333', 'email' => '*****@*****.**');
$db_data[] = array('name' => 'Jane Doe', 'phone' => '222-333-4444', 'email' => '*****@*****.**');
$db_data[] = array('name' => 'Jon Smith', 'phone' => '333-444-5555', 'email' => '*****@*****.**');
$col_names = array(
'name' => 'Name',
'phone' => 'Phone Number',
'email' => 'E-mail Address'
);
/** end testing data **/
$this->cezpdf->ezTable($contents, $col_names, ucwords(urldecode($title)), array('width' => 550));
$this->cezpdf->ezStream();
}
}
public function print_ships()
{
if (!$this->is_logged) {
redirect("user/login");
}
$this->load->library('cezpdf');
$this->load->helper('pdf_helper');
$user_id = $this->user_model->get_current_user_id();
$this->db->select("shp_id, shp_ep_ref, fa.adr_contact as sender_name, ta.adr_contact as receiver_name, DATE_FORMAT(shp_date,'%d-%m-%Y') as shp_date, shp_rate, shp_trackingcode, shp_estdate, shp_status, shp_signedby, shp_type, shp_payment");
$this->db->from('shipments as s');
$this->db->join('addresses as fa', 'fa.adr_id = shp_from');
$this->db->join('addresses as ta', 'ta.adr_id = shp_to');
$this->db->join('country as fco', 'fa.adr_country = fco.cnt_code');
$this->db->join('state as fs', 'fa.adr_state = fs.state_id');
$this->db->join('city as fc', 'fa.adr_city = fc.city_id');
$this->db->join('country as tco', 'ta.adr_country = tco.cnt_code');
$this->db->join('state as ts', 'ta.adr_state = ts.state_id');
$this->db->join('city as tc', 'ta.adr_city = tc.city_id');
$this->db->where('s.shp_user', $user_id);
$query = $this->db->get();
$data = $query->result_array();
$titlecolumn = array('shp_id' => 'Shipment ID', 'shp_ep_ref' => 'Shipment Reference', 'sender_name' => 'Sender', 'receiver_name' => 'Receiver', 'shp_date' => 'Date', 'shp_rate' => 'Price', 'shp_trackingcode' => 'Tracking Code', 'shp_estdate' => 'Delivery Date', 'shp_status' => 'Status', 'shp_signedby' => 'Signed By', 'shp_type' => 'Type', 'shp_payment' => 'Payment Status');
prep_pdf();
$this->cezpdf->ezTable($data, $titlecolumn, 'Shipment Data', array('fontSize' => 5));
$this->cezpdf->ezStream();
}
public function printoutput2($bulan, $tahun)
{
$this->general->checksess();
$this->general->checkbulantahun($bulan, $tahun);
$print = $this->getdata->getnamabulan($bulan);
$data = $this->getdata->getprintkriteriarencana($bulan . $tahun);
$data1 = $this->getdata->getprintrencana($bulan . $tahun);
$this->load->helper('pdf');
$this->load->library('cezpdf');
prep_pdf();
$a = 0;
foreach ($data as $key) {
$namapengeluaran = $this->getdata->getnamapengeluaran($key['id_pengeluaran']);
$db_data[] = array('Nomor' => $a = $a + 1, 'category' => $namapengeluaran->nama, 'output' => 'Rp. ' . $key['pengeluaran2']);
}
$col_names = array('Nomor' => 'Nomor', 'category' => 'Uraian', 'output' => 'Jumlah');
$a = 0;
foreach ($data1 as $key) {
$namapengeluaran = $this->getdata->getnamapengeluaran($key['id_pengeluaran']);
$db_data1[] = array('Nomor' => $a = $a + 1, 'category' => $namapengeluaran->nama, 'output' => 'Rp. ' . $key['pengeluaran2']);
}
$col_names1 = array('Nomor' => 'Nomor', 'category' => 'Uraian', 'output' => 'Jumlah');
$this->cezpdf->ezTable($db_data, $col_names, 'Kriteria Utama ' . $print->nama_bulan . ' ' . $tahun, array('width' => 10, 'showHeading' => 0));
$this->cezpdf->addText(150, 800, 15, "Rencana Anggaran Pendapatan dan Belanja Sekolah");
$this->cezpdf->ezTable($db_data1, $col_names1, 'Subkriteria ' . $print->nama_bulan . ' ' . $tahun, array('width' => 550, 'showHeading' => 0));
$this->cezpdf->ezStream();
}
