public function actionUpload()
{
parent::actionUpload();
Yii::import("ext.EAjaxUpload.qqFileUploader");
$folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/';
// folder for uploaded files
$allowedExtensions = array("csv");
$sizeLimit = (int) Yii::app()->params['sizeLimit'];
// maximum file size in bytes
$uploader = new qqFileUploader($allowedExtensions, $sizeLimit);
$result = $uploader->handleUpload($folder, true);
$row = 0;
if (($handle = fopen($folder . $uploader->file->getName(), "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];
$model->absscheduleid = (int) $data[1];
$model->difftimein = $data[2];
$model->difftimeout = $data[3];
$model->absstatusid = (int) $data[4];
$model->recordstatus = 1;
try {
if (!$model->save()) {
$errormessage = $model->getErrors();
if (Yii::app()->request->isAjaxRequest) {
echo CJSON::encode(array('status' => 'failure', 'div' => $errormessage));
}
}
} catch (Exception $e) {
$errormessage = $e->getMessage();
if (Yii::app()->request->isAjaxRequest) {
echo CJSON::encode(array('status' => 'failure', 'div' => $errormessage));
}
}
}
$row++;
}
fclose($handle);
}
$result = htmlspecialchars(json_encode($result), ENT_NOQUOTES);
echo $result;
}
public function actionWrite()
{
if (isset($_POST['Absrule'])) {
$messages = $this->ValidateData(array(array($_POST['Absrule']['absscheduleid'], 'emptyabsschedulename', 'emptystring'), array($_POST['Absrule']['difftimein'], 'emptydifftimein', 'emptystring'), array($_POST['Absrule']['difftimeout'], 'emptydifftimeout', 'emptystring'), array($_POST['Absrule']['absstatusid'], 'emptyabsstatus', 'emptystring')));
if ($messages == '') {
//$dataku->attributes=$_POST['Absrule'];
if ((int) $_POST['Absrule']['absruleid'] > 0) {
$model = $this->loadModel($_POST['Absrule']['absruleid']);
$model->absscheduleid = $_POST['Absrule']['absscheduleid'];
$model->difftimein = $_POST['Absrule']['difftimein'];
$model->difftimeout = $_POST['Absrule']['difftimeout'];
$model->absstatusid = $_POST['Absrule']['absstatusid'];
$model->recordstatus = $_POST['Absrule']['recordstatus'];
} else {
$model = new Absrule();
$model->attributes = $_POST['Absrule'];
}
try {
if ($model->save()) {
$this->DeleteLock($this->menuname, $_POST['Absrule']['absruleid']);
$this->GetSMessage('hrtmarinsertsuccess');
} else {
$this->GetMessage($model->getErrors());
}
} catch (Exception $e) {
$this->GetMessage($e->getMessage());
}
}
}
}
