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); }
public function actionIndex() { if (isset($_POST['limit'])) { $limit = $_POST['limit']; } else { $limit = 20; } if (isset($_POST['start'])) { $start = $_POST['start']; } else { $start = 0; } $void = Mt::get_voided(KEMBALI_KENDARAAN); $criteria = new CDbCriteria(); $param = array(); $criteria = new CDbCriteria(); if (isset($_POST['doc_ref_kembali'])) { $criteria->addCondition("doc_ref_kembali like :doc_ref_kembali"); $param[':doc_ref_kembali'] = "%" . $_POST['doc_ref_kembali'] . "%"; } $criteria->addNotInCondition('id_kembali', $void); $criteria->limit = $limit; $criteria->offset = $start; $criteria->params = $param; $model = MtKembaliKendaraan::model()->findAll($criteria); $total = MtKembaliKendaraan::model()->count($criteria); $this->renderJson($model, $total); }
public function actionIndex() { if (isset($_POST['limit'])) { $limit = $_POST['limit']; } else { $limit = 20; } if (isset($_POST['start'])) { $start = $_POST['start']; } else { $start = 0; } $void = Mt::get_voided(PINJAM_KENDARAAN); $criteria = new CDbCriteria(); $criteria->addNotInCondition('id_pinjam', $void); $criteria->limit = $limit; $criteria->offset = $start; $model = MtPinjamKendaraan::model()->findAll($criteria); $total = MtPinjamKendaraan::model()->count($criteria); if (isset($_GET['MtPinjamKendaraan'])) { $model->attributes = $_GET['MtPinjamKendaraan']; } if (isset($_GET['output']) && $_GET['output'] == 'json') { $this->renderJson($model, $total); } else { $model = new MtPinjamKendaraan('search'); $model->unsetAttributes(); $this->render('admin', array('model' => $model)); } }