public function actionIndex() { // total semua pemasukan $criteria = new CDbCriteria(); $criteria->addBetweenCondition('TANGGAL_ORDER', date('Y-m-01', strtotime('this month')), date('Y-m-t', strtotime('this month'))); $kredit = Order::model()->findAll($criteria); $total = 0; foreach ($kredit as $k) { $total += $k->TOTAL; } // menghitung total order $order_c = Order::model()->count(); // menghitung total pasien $pelanggan_c = Pasien::model()->count(); // get data order hari ini $criteria2 = new CDbCriteria(); $criteria2->condition = 'date(TANGGAL_ORDER) = date(NOW())'; $hariini = Order::model()->count($criteria2); // get barang yang tanggal expired $expired = Item::getExpired(); // data obat habis $criteria = new CDbCriteria(); $criteria->order = 'TANGGAL_ORDER DESC'; $criteria->limit = '5'; $dataProvider = new CActiveDataProvider('Pasien', array('pagination' => false, 'criteria' => $criteria)); $this->render('index', array('total' => $total, 'order' => $order_c, 'pelanggan' => $pelanggan_c, 'hariini' => $hariini, 'expired' => $expired)); }