public function actionImport($path)
{
Yii::import('ext.phpexcelreader.JPhpExcelReader');
$data = new JPhpExcelReader($path);
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
$model = new InOutData();
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
if ($j == 1) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->department = $data->sheets[0]['cells'][$i][$j];
} else {
$model->department = '';
}
}
if ($j == 2) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->nama = $data->sheets[0]['cells'][$i][$j];
} else {
$model->nama = '';
}
}
if ($j == 3) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->no = $data->sheets[0]['cells'][$i][$j];
} else {
$model->no = '';
}
}
if ($j == 4) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->date_time = $data->sheets[0]['cells'][$i][$j];
} else {
$model->date_time = '';
}
}
if ($j == 5) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->status = $data->sheets[0]['cells'][$i][$j];
} else {
$model->status = '';
}
}
if ($j == 6) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->location_id = $data->sheets[0]['cells'][$i][$j];
} else {
$model->location_id = '';
}
}
if ($j == 7) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->id_number = $data->sheets[0]['cells'][$i][$j];
} else {
$model->id_number = '';
}
}
if ($j == 8) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->verify_code = $data->sheets[0]['cells'][$i][$j];
} else {
$model->verify_code = '';
}
}
if ($j == 9) {
if (isset($data->sheets[0]['cells'][$i][$j])) {
$model->no_kartu = $data->sheets[0]['cells'][$i][$j];
} else {
$model->no_kartu = '';
}
}
}
$model->save();
}
$this->redirect(array('inoutdata/admin'));
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = InOutData::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
