static function get_total_beban_grup($start_date, $end_date, $anak_id) { $void = Pah::get_voided(T_AKTIVITASGRUP); // $void = Pah::get_voided(7); $void_st = ''; if (count($void) > 0) { $void_st = "and pah_aktivitas_grup_trans.aktivitas_id not in (" . join(',', $void) . ")"; } $per_anak = $anak_id == 'undefined' ? '' : "AND pah_member.id = {$anak_id}"; $rows = Yii::app()->db->createCommand()->select("Sum(pah_aktivitas_grup_trans.amount) as amount")->from("pah_aktivitas_grup_trans")->rightJoin("pah_aktivitas_grup", "pah_aktivitas_grup_trans.pah_aktivitas_grup_id = pah_aktivitas_grup.id and\r\n pah_aktivitas_grup_trans.trans_date between '{$start_date}' and '{$end_date}' {$void_st}")->queryScalar(); return $rows == null ? 0 : $rows; }
public function actionIndex() { if (isset($_POST['limit'])) { $limit = $_POST['limit']; } else { $limit = 20; } if (isset($_POST['start'])) { $start = $_POST['start']; } else { $start = 0; } $param = array(); $void = Pah::get_voided(AKTIVITAS); $criteria = new CDbCriteria(); if (isset($_POST['doc_ref'])) { $criteria->addCondition("doc_ref like :doc_ref"); $param[':doc_ref'] = "%" . $_POST['doc_ref'] . "%"; } if (isset($_POST['no_bukti'])) { $criteria->addCondition("no_bukti like :no_bukti"); $param[':no_bukti'] = "%" . $_POST['no_bukti'] . "%"; } if (isset($_POST['amount'])) { $criteria->addCondition("amount = :amount"); $param[':amount'] = $_POST['amount']; } if (isset($_POST['trans_date'])) { $criteria->addCondition("trans_date = :trans_date"); $param[':trans_date'] = substr($_POST['trans_date'], 0, 10); } $criteria->limit = $limit; $criteria->offset = $start; $criteria->params = $param; $criteria->addNotInCondition('aktivitas_id', $void); $model = PahAktivitas::model()->findAll($criteria); $total = PahAktivitas::model()->count($criteria); $this->renderJson($model, $total); }