Skip to main content
Home

lima besar penjualan

October 2, 2011 by gotopaCI

gotopaCI's picture

lagi buat nama barang yang banyak terjual dengn fusionchart tapi sering error ni .. para pamaster tolong dibantu y .. ini contoh tabelnye :

+----+------+--------------+
| id | rate | barang |
+----+------+--------------+
| 8 | 5 | Kerupuk |
| 17 | 5 | Sedap Goreng |
| 11 | 5 | Kuku Bima |
| 9 | 2 | Es Batu |
| 7 | 1 | Gudang Garam |
+----+------+--------------+

terdapat 3 kondisi disini :
1. jika date("m") tampil bulan saat ini
2. jika bukan bulan sekarang maka menampilkan bulan kemren
nah ini kode ye ..

	if(date("m")) {
				$x = date("m");
				$m = $x - 1;
				$brg = $this->db->query("select a.idba,sum(item)as naik,b.nabar from detail_transaksi a, barang b where a.idba=b.idbar and tgltrx like '%$m-2011' group by idbar order by naik desc limit 5") ;
			$z = 0;
			foreach ($brg->result() as $e) {
				$Data[$z][2] = $e->naik;
				$Data[$z][1] = $e->nabar;
			$z++;
			}
		} else {
 
//			$m = date("m") -1 ;
			$brg = $this->db->query("select a.idba,sum(item)as naik,b.nabar from detail_transaksi a, barang b where a.idba=b.idbar and tgltrx like '%$m-2011' group by idbar order by naik desc limit 5") ;
				$z = 0;
				foreach ($brg->result() as $e) {
					$Data[$z][2] = $e->naik;
					$Data[$z][1] = $e->nabar;
				$z++;
				}
 
//		}	
            $strXML1 = $this->fusioncharts->setDataXML($Data,' ','Jumlah  ') ;
 
            $data['lapor'] = $this->fusioncharts->renderChart($this->swfCharts2,'',$strXML1,"barang", 700, 400, false, false) ;

Comments

Comment viewing options

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

A PHP Error was

October 2, 2011 by gotopaCI, 18 hours 54 min ago
Comment: 9084

gotopaCI's picture

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: Data

Filename: controllers/admin.php

Line Number: 81
A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: libraries/fusioncharts.php

Line Number: 177

CMIIW

October 3, 2011 by purandi, 28 min 6 sec ago
Comment: 9086

purandi's picture

Coba mas
Klo di lihat hasil query barangnya kosong, coba tambahin script seperti ini

$brg = $this->db->query("select a.idba,sum(item)as naik,b.nabar from detail_transaksi a, barang b where a.idba=b.idbar and tgltrx like '%$m-2011' group by idbar order by naik desc limit 5") ;
$z = 0;
if ($brg->num_rows() > 0)
{
	foreach ($brg->result() as $e)
	{
		$Data[$z][2] = $e->naik;
		$Data[$z][1] = $e->nabar;
		$z++;
	}
}
else
{
	echo "Query kosong";
}

CMIIW

October 2, 2011 by purandi, 19 hours 22 min ago
Comment: 9083

purandi's picture

Errornya apa mas bro ?

Premium Drupal Themes by Adaptivethemes