static function get_payee_payoor($type, $id)
{
switch ($type) {
case KAS_MASUK:
$model = MtKasMasuk::model()->findAllByPk($id);
return $model->MtDonatur->name;
break;
case KAS_KELUAR:
$model = MtKasKeluar::model()->findAllByPk($id);
return $model->MtSuppliers->supp_name;
break;
case AKTIVITAS:
$model = MtAktivitas::model()->findAllByPk($id);
return $model->MtSuppliers->supp_name;
break;
case BANKTRANSFER:
$criteria = new CDbCriteria();
$criteria->addCondition('type=' . BANKTRANSFER);
$criteria->addCondition("trans_no={$id}");
$model = MtBankTrans::model()->find($criteria);
$jemaat = get_jemaat_from_user_id($model->users_id);
return $jemaat->real_name;
break;
case VOID:
$criteria = new CDbCriteria();
$criteria->addCondition('type=' . VOID);
$criteria->addCondition("trans_no={$id}");
$model = MtBankTrans::model()->find($criteria);
$jemaat = get_jemaat_from_user_id($model->users_id);
return $jemaat->real_name;
break;
case SALDO_AWAL:
$criteria = new CDbCriteria();
$criteria->addCondition('type=' . SALDO_AWAL);
$criteria->addCondition("trans_no={$id}");
$model = MtBankTrans::model()->find($criteria);
$jemaat = get_jemaat_from_user_id($model->users_id);
return $jemaat->real_name;
break;
case T_AKTIVITASGRUP:
$model = MtAktivitasGrupTrans::model()->findAllByPk($id);
return $model->MtSuppliers->supp_name;
break;
}
}
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 = Mt::get_voided(KAS_MASUK);
$criteria = new CDbCriteria();
if (isset($_POST['doc_ref'])) {
$criteria->addCondition("doc_ref like :doc_ref");
$param[':doc_ref'] = "%" . $_POST['doc_ref'] . "%";
}
if (isset($_POST['dari'])) {
$criteria->addCondition("dari like :dari");
$param[':dari'] = "%" . $_POST['dari'] . "%";
}
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->addNotInCondition('kas_masuk_id', $void);
$criteria->limit = $limit;
$criteria->offset = $start;
$criteria->params = $param;
$model = MtKasMasuk::model()->findAll($criteria);
$total = MtKasMasuk::model()->count($criteria);
$this->renderJson($model, $total);
}