public function actionUpload() { parent::actionUpload(); $folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/'; // folder for uploaded files $file = $folder . basename($_FILES['uploadfile']['name']); if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $row = 0; if (($handle = fopen($file, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($row > 0) { $empid = Employee::model()->findbyattributes(array('oldnik' => $data[0])); $model = new Employeeschedule(); if ($empid != null) { $model = Employeeschedule::model()->findByattributes(array('employeeid' => $empid->employeeid, 'month' => $data[2], 'year' => $data[3])); if ($model == null) { $model = new Employeeschedule(); } $model->employeeid = $empid->employeeid; $model->month = $data[2]; $model->year = $data[3]; $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[4])); if ($d != null) { $model->d1 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[5])); if ($d != null) { $model->d2 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[6])); if ($d != null) { $model->d3 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[7])); if ($d != null) { $model->d4 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[8])); if ($d != null) { $model->d5 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[9])); if ($d != null) { $model->d6 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[10])); if ($d != null) { $model->d7 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[11])); if ($d != null) { $model->d8 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[12])); if ($d != null) { $model->d9 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[13])); if ($d != null) { $model->d10 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[14])); if ($d != null) { $model->d11 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[15])); if ($d != null) { $model->d12 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[16])); if ($d != null) { $model->d13 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[17])); if ($d != null) { $model->d14 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[18])); if ($d != null) { $model->d15 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[19])); if ($d != null) { $model->d16 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[20])); if ($d != null) { $model->d17 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[21])); if ($d != null) { $model->d18 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[22])); if ($d != null) { $model->d19 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[23])); if ($d != null) { $model->d20 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[24])); if ($d != null) { $model->d21 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[25])); if ($d != null) { $model->d22 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[26])); if ($d != null) { $model->d23 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[27])); if ($d != null) { $model->d24 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[28])); if ($d != null) { $model->d25 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[29])); if ($d != null) { $model->d26 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[30])); if ($d != null) { $model->d27 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[31])); if ($d != null) { $model->d28 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[32])); if ($d != null) { $model->d29 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[33])); if ($d != null) { $model->d30 = $d->absscheduleid; } $d = Absschedule::model()->findbyattributes(array('absschedulename' => $data[34])); if ($d != null) { $model->d31 = $d->absscheduleid; } $model->recordstatus = Wfgroup::model()->findstatusbyuser('insempsched'); } try { if (!$model->save()) { $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]); } else { $a = Yii::app()->user->name; $connection = Yii::app()->db; $transaction = $connection->beginTransaction(); try { $sql = 'call ApproveEmployeeSchedule(:vid, :vlastupdateby)'; $command = $connection->createCommand($sql); $command->bindvalue(':vid', $model->employeescheduleid, PDO::PARAM_INT); $command->bindvalue(':vlastupdateby', $a, PDO::PARAM_STR); $command->execute(); $transaction->commit(); } catch (Exception $e) { $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]); } } } catch (Exception $e) { $this->messages = $this->messages . $e->getMessage(); } } $row++; } } else { $this->messages = $this->messages . ' memory or harddisk full'; } fclose($handle); } else { $this->messages = $this->messages . ' check your directory permission'; } if ($this->messages == '') { $this->messages = 'success'; } echo $this->messages; }
<div class="form"> <?php $form = $this->beginWidget('CActiveForm', array('id' => 'absrule-form', 'enableAjaxValidation' => false)); $this->widget('ToolbarButton', array('isSave' => true, 'UrlSave' => 'absrule/write', 'isCancel' => true, 'UrlCancel' => 'absrule/cancelwrite')); echo $form->hiddenField($model, 'absruleid'); ?> <div class="row"> <?php echo $form->labelEx($model, 'absscheduleid'); ?> <?php echo $form->hiddenField($model, 'absscheduleid'); ?> <input type="text" name="sched_name" id="sched_name" readonly value="<?php echo Absschedule::model()->findByPk($model->absscheduleid) !== null ? Absschedule::model()->findByPk($model->absscheduleid)->absschedulename : ''; ?> "> <?php $this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'absschedule_dialog', 'options' => array('title' => Yii::t('app', 'Absence Schedules'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true))); $this->widget('zii.widgets.grid.CGridView', array('id' => 'absschedule-grid', 'dataProvider' => $absschedule->Searchwstatus(), 'filter' => $absschedule, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+", array("name" => "send_absschedule", "id" => "send_absschedule", "onClick" => "$(\\"#absschedule_dialog\\").dialog(\\"close\\"); $(\\"#sched_name\\").val(\\"$data->absschedulename\\"); $(\\"#Absrule_absscheduleid\\").val(\\"$data->absscheduleid\\"); "))'), array('name' => 'absscheduleid', 'visible' => false, 'value' => '$data->absscheduleid', 'htmlOptions' => array('width' => '1%')), 'absschedulename', 'absin', 'absout', array('name' => 'absstatusid', 'header' => 'Status', 'value' => '$data->absstatus->shortstat'), array('class' => 'CCheckBoxColumn', 'name' => 'recordstatus', 'selectableRows' => '0', 'header' => 'Record Status', 'checked' => '$data->recordstatus')))); $this->endWidget('zii.widgets.jui.CJuiDialog'); echo CHtml::Button('...', array('onclick' => '$("#absschedule_dialog").dialog("open"); return false;')); ?> <?php echo $form->error($model, 'absscheduleid'); ?> </div>
public function actionUpload() { parent::actionUpload(); $folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/'; // folder for uploaded files $file = $folder . basename($_FILES['uploadfile']['name']); if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) { $row = 0; if (($handle = fopen($file, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($row > 0) { $model = Absrule::model()->findByPk((int) $data[0]); if ($model === null) { $model = new Absrule(); } $model->absruleid = (int) $data[0]; $absschedule = Absschedule::model()->findbyattributes(array('absschedulename' => $data[1])); if ($absschedule != null) { $model->absscheduleid = $absschedule->absscheduleid; } $model->difftimein = $data[2]; $model->difftimeout = $data[3]; $absstatus = Absstatus::model()->findbyattributes(array('shortstat' => $data[4])); if ($absstatus != null) { $model->absstatusid = $absstatus->absstatusid; } $model->recordstatus = 1; try { if (!$model->save()) { $this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]); } } catch (Exception $e) { $this->messages = $this->messages . $e->getMessage(); } } $row++; } } else { $this->messages = $this->messages . ' memory or harddisk full'; } fclose($handle); } else { $this->messages = $this->messages . ' check your directory permission'; } if ($this->messages == '') { $this->messages = 'success'; } echo $this->messages; }