/**
* Input multiple data to database
*/
public function actionEntry()
{
$model = new Package();
$lastDipa = Dipa::model()->find(array('order' => 'id DESC'));
$lastDipaId = $lastDipa->id;
if (isset($_POST['code'])) {
if ($lastDipa) {
$total = count($_POST['code']);
for ($i = 0; $i < $total; $i++) {
if ($_POST['code'][$i] != NULL && $_POST['ppk_code'][$i] != NULL && $_POST['city_code'][$i] != NULL) {
$code = $_POST['code'][$i];
//Check existed record
$record = Package::model()->findByAttributes(array('code' => $code));
if ($record) {
$budgets = Budget::model()->findAllByAttributes(array('subcomponent_code' => "{$record->code}", 'dipa_id' => "{$lastDipaId}"));
$record->ppk_code = $_POST['ppk_code'][$i];
$record->city_code = $_POST['city_code'][$i];
$record->province_code = City::model()->findByAttributes(array('code' => "{$record->city_code}"))->province_code;
if ($budgets) {
foreach ($budgets as $budgetData) {
$pAccount = PackageAccount::model()->findByAttributes(array('code' => "{$budgetData->code}"));
if ($pAccount) {
$pAccount->limit = $budgetData->total_budget_limit;
$pAccount->ppk_code = $record->ppk_code;
$pAccount->province_code = $record->province_code;
$pAccount->city_code = $record->city_code;
$pAccount->update();
}
}
}
$record->update();
} else {
$data = new Package();
$data->code = $_POST['code'][$i];
$budget = Budget::model()->findByAttributes(array('subcomponent_code' => $_POST['code'][$i]), array('order' => 'dipa_id DESC'));
if ($budget) {
$data->satker_code = "{$budget->satker_code}";
$data->activity_code = "{$budget->activity_code}";
$data->output_code = "{$budget->output_code}";
$data->suboutput_code = "{$budget->suboutput_code}";
$data->name = $budget->subcomponentCode->name;
$data->component_code = "{$budget->component_code}";
$data->ppk_code = $_POST['ppk_code'][$i];
$data->city_code = $_POST['city_code'][$i];
$data->province_code = City::model()->findByAttributes(array('code' => "{$data->city_code}"))->province_code;
$budgets = Budget::model()->findAllByAttributes(array('subcomponent_code' => "{$data->code}", 'dipa_id' => "{$lastDipaId}"));
if ($budgets) {
foreach ($budgets as $dataBudget) {
$paModel = new PackageAccount();
$paModel->code = "{$dataBudget->code}";
$paModel->satker_code = "{$dataBudget->satker_code}";
$paModel->activity_code = "{$dataBudget->activity_code}";
$paModel->output_code = "{$dataBudget->output_code}";
$paModel->suboutput_code = "{$dataBudget->suboutput_code}";
$paModel->component_code = "{$dataBudget->component_code}";
$paModel->package_code = "{$dataBudget->subcomponent_code}";
$paModel->account_code = "{$dataBudget->account_code}";
$paModel->ppk_code = "{$data->ppk_code}";
$paModel->province_code = "{$data->province_code}";
$paModel->city_code = "{$data->city_code}";
$paModel->limit = "{$dataBudget->total_budget_limit}";
$paModel->save();
}
}
$data->save();
} else {
Yii::app()->user->setFlash('notice', 'Data DIPA belum diinput dengan lengkap. Beberapa data informasi tambahan gagal ditambahkan.');
$this->redirect(array('index'));
}
}
} else {
Yii::app()->user->setFlash('error', "Mohon isikan data secara lengkap.");
$this->redirect(array('entry'));
}
}
} else {
Yii::app()->user->setFlash('error', 'Data DIPA/POK belum diinput.');
$this->redirect(array('index'));
}
Yii::app()->user->setFlash('success', 'Data berhasil disimpan.');
$this->redirect(array('index'));
}
$this->render('entry', array('model' => $model));
}
