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);
}
