Skip to main content
Home

report di CI????????????

February 15, 2010 by cah_ajus

cah_ajus's picture

ada ngk sih report yg handal bwt CI selain R&Os pdf???klo ada apa ya???sekalian minta turorialnya dunk???
aq lg nyoba2 R&OS pdf, tapi keknya tampilannya kurang menarik gtu, baca readme-nya susah betul...bhs inggris (hehehe)
stlh googling, dpet ini:
http://masdeka.web.id/bikin-laporan-pdf-dengan-codeigniter
http://d3ptzz.kandangbuaya.com/2009/03/11/generate-create-write-file-pdf...

tapi keknya masih kurang, ada yg pnh make R&OS ngk??share donk....

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Verry Easy

February 15, 2010 by bella, 1 year 31 weeks ago
Comment: 5914

bella's picture

http://masdeka.web.id/bikin-laporan-pdf-dengan-codeigniter

itu udh pas kok

contoller

function pdf(){
		$this->load->library('cezpdf');
		$this->load->helper('pdf');
 
		prep_pdf(); // creates the footer for the document we are creating.
		$this->cezpdf->ezText('Transaksi', 20, array('justification' => 'center'));
		$this->cezpdf->ezSetDy(-20);
		$header = $this->MProduct->adminSinglePembelian($this->uri->segment(4));
		foreach($header as $row){
			$this->cezpdf->ezText('ID : '.$row['idtransaksi'], 12, array('justification' => 'left'));
			$this->cezpdf->ezText('Username : '.$row['username'], 12, array('justification' => 'left'));
			$this->cezpdf->ezText('Email : '.$row['email'], 12, array('justification' => 'left'));
			$this->cezpdf->ezText('Total : $. '.$row['total'], 12, array('justification' => 'left'));
			$this->cezpdf->ezText('Date : '. mysqldatetime_to_date($row['datetransaksi']), 12, array('justification' => 'left'));
		}
		$db_data = $this->MProduct->adminDetailPembelian($this->uri->segment(4));
		foreach($db_data as $list){
				$db_data2[] = array(
					'kddetail' => $list['iddetailtransaksi'],
					'nmproduct' => $list['nmproduct'],
					'weight' => $list['weight'],
					'qty' => $list['qty'],
					'subtotal' => '$. '.$list['subtotal']
				);	
		}
		$col_names = array(
			'kddetail' => 'ID',
			'nmproduct' => 'Product',
			'weight' => 'Weight',
			'qty' => 'Qty',
			'subtotal' => 'Subtotal'
		);
		$this->cezpdf->ezSetDy(-20);
		$this->cezpdf->ezTable($db_data2, $col_names, 'Detail Transaksi', array('width'=>500));
		$this->cezpdf->ezStream();
	}

sekalian convert mysql to excel

February 15, 2010 by bella, 1 year 31 weeks ago
Comment: 5915

bella's picture

model

function exportUserCsv(){
		$this->load->dbutil();
	 	$Q = $this->db->query("select * from msuser");
	 	return $this->dbutil->csv_from_result($Q,",","\n");
	}

controller

function excel(){
		$this->load->helper('download');
		$csv = $this->MUser->exportUserCsv();
		$name = "Transaksi.csv";
		force_download($name,$csv);
	}

mantapppp

February 15, 2010 by cah_ajus, 1 year 31 weeks ago
Comment: 5916

cah_ajus's picture

wee...mantapp betul pertolongannya,
mau nanya lg d0nk

1. yg di R&OS tu kan ada fungsi bwt footer, klo bwt headernya gmn??bsa ngk??

2. yg bwt convert mysql to excel itu berhasil aku coba, tapi koq tampilannya dalam satu kolom semua ya???tadi aku coba convert data user punyaku yg isinya username, pass, nama, dll...trus waktu di excelnya jadi satu klom smua...

mysql to excel

February 15, 2010 by bella, 1 year 31 weeks ago
Comment: 5917

bella's picture

2. yg bwt convert mysql to excel itu berhasil aku coba, tapi koq tampilannya dalam satu kolom semua ya???tadi aku coba convert data user punyaku yg isinya username, pass, nama, dll...trus waktu di excelnya jadi satu klom smua...

jwb
emang jadi satu kolom maksudnya 1 kolom gmn

soal no1. gw jarang make

February 15, 2010 by bella, 1 year 31 weeks ago
Comment: 5918

bella's picture

soal no1.

gw jarang make header tapi gw custom sendiri di header dan footernya

Premium Drupal Themes by Adaptivethemes