public function actionNew() { $model = new Component(); if (isset($_POST['Component'])) { $model->attributes = $_POST['Component']; if ($model->save(false)) { $this->redirect(Yii::app()->createUrl('/admin/compontent/index')); } } $this->render('componentAdd', array('model' => $model)); }
public function save_edit() { if (!isset($_SESSION['logged'])) { return call('pages', 'home'); } else { if (!isset($_GET['code'])) { return call('pages', 'error', 2); } $post_data = $_POST; Component::save($post_data, $_GET['code']); return call('components', 'index'); } }
public function importExcelToMysql($filePath, $fields = array(), $model = null, $startingRow = 2) { $objPHPExcel = PHPExcel_IOFactory::load($filePath); foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { //field validation $fieldValidate = array(); for ($col = 0; $col < count($fields); ++$col) { $val = $worksheet->getCellByColumnAndRow($fields[$col]['col'], 1)->getValue(); $fieldValidate[$fields[$col]['name']] = $val; } $validated = FALSE; if ($fieldValidate['satker_code'] == 'Kode Satker' and $fieldValidate['activity_code'] == 'Kode Kegiatan' and $fieldValidate['output_code'] == 'Kode Output' and $fieldValidate['suboutput_code'] == 'Kode Suboutput' and $fieldValidate['code'] == 'Kode Komponen' and $fieldValidate['name'] == 'Uraian Komponen') { $validated = TRUE; } //end of validation if ($validated == TRUE) { $highestRow = $worksheet->getHighestRow(); $isSuccess = FALSE; //check if RKAKL data subcomponent already removed, but app master data already realize $this->validateRemovedData($filePath, $fields, $worksheet, $highestRow, $startingRow); for ($row = $startingRow; $row <= $highestRow; ++$row) { $attributes = array(); for ($col = 0; $col < count($fields); ++$col) { $val = $worksheet->getCellByColumnAndRow($fields[$col]['col'], $row)->getValue(); $attributes[$fields[$col]['name']] = $val; } $suboutputcode = trim($attributes['satker_code'], " \t\n\r\v") . '.' . trim($attributes['activity_code'], " \t\n\r\v") . '.' . trim($attributes['output_code'], " \t\n\r\v") . '.' . trim($attributes['suboutput_code'], " \t\n\r\v"); $code = $suboutputcode . '.' . trim($attributes['code'], " \t\n\r\v"); $recorded = Component::model()->find(array('condition' => "code='{$code}'")); if ($attributes['satker_code'] != NULL and $attributes['activity_code'] != NULL and $attributes['output_code'] != NULL and $attributes['suboutput_code'] != NULL and $attributes['code'] != NULL and $attributes['name'] != NULL) { if ($recorded) { $recorded->attributes = $attributes; $satkerCode = isset($attributes['satker_code']) ? trim($attributes['satker_code'], " \t\n\r\v") : NULL; $activityCode = isset($attributes['activity_code']) ? trim($attributes['activity_code'], " \t\n\r\v") : NULL; $outputCode = isset($attributes['output_code']) ? trim($attributes['output_code'], " \t\n\r\v") : NULL; $suboutputCode = isset($attributes['suboutput_code']) ? trim($attributes['suboutput_code'], " \t\n\r\v") : NULL; $subcomponentCode = isset($attributes['code']) ? trim($attributes['code'], " \t\n\r\v") : NULL; //set value $recorded->satker_code = $satkerCode; $recorded->activity_code = $satkerCode . '.' . $activityCode; $recorded->output_code = $satkerCode . '.' . $activityCode . '.' . $outputCode; $recorded->suboutput_code = $satkerCode . '.' . $activityCode . '.' . $outputCode . '.' . $suboutputCode; $recorded->code = $satkerCode . '.' . $activityCode . '.' . $outputCode . '.' . $suboutputCode . '.' . $subcomponentCode; if ($recorded->update()) { $isSuccess = TRUE; } } else { $model = new Component(); $model->attributes = $attributes; $satkerCode = isset($attributes['satker_code']) ? trim($attributes['satker_code'], " \t\n\r\v") : NULL; $activityCode = isset($attributes['activity_code']) ? trim($attributes['activity_code'], " \t\n\r\v") : NULL; $outputCode = isset($attributes['output_code']) ? trim($attributes['output_code'], " \t\n\r\v") : NULL; $suboutputCode = isset($attributes['suboutput_code']) ? trim($attributes['suboutput_code'], " \t\n\r\v") : NULL; $componentCode = isset($attributes['code']) ? trim($attributes['code'], " \t\n\r\v") : NULL; //set value $model->satker_code = $satkerCode; $model->activity_code = $satkerCode . '.' . $activityCode; $model->output_code = $satkerCode . '.' . $activityCode . '.' . $outputCode; $model->suboutput_code = $satkerCode . '.' . $activityCode . '.' . $outputCode . '.' . $suboutputCode; $model->code = $satkerCode . '.' . $activityCode . '.' . $outputCode . '.' . $suboutputCode . '.' . $componentCode; if ($model->save()) { $isSuccess = TRUE; } } } } if ($isSuccess) { unlink($filePath); Yii::app()->user->setFlash('success', "File berhasil diimport ke dalam master"); $this->redirect(array('index')); } else { unlink($filePath); Yii::app()->user->setFlash('error', "Mohon masukkan data secara lengkap."); } } else { unlink($filePath); Yii::app()->user->setFlash('error', "Pastikan file yang Anda upload sudah benar!"); $this->redirect(array('import')); } } }
function save() { $this->filter_access('Component', 'roled_add', 'components/index'); $component = new Component(); $component->comp_name = $this->input->post('comp_name'); $component->comp_type = $this->input->post('comp_type'); if ($component->save()) { $this->session->set_flashdata('message', 'Component successfully created!'); redirect('components/'); } else { // Failed $component->error_message('custom', 'Component Name required'); $msg = $component->error->custom; $this->session->set_flashdata('message', $msg); redirect('components/add'); } }