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 = Tax::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Tax();
}
$model->taxid = (int) $data[0];
$model->taxcode = $data[1];
$model->taxvalue = $data[2];
$model->description = $data[3];
$model->recordstatus = (int) $data[4];
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;
}
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 = Company::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Company();
}
$model->companyid = (int) $data[0];
$model->companyname = $data[1];
$model->address = $data[2];
$city = City::model()->findbyattributes(array('cityname' => $data[3]));
if ($city !== null) {
$model->cityid = $city->cityid;
}
$model->zipcode = $data[4];
$model->taxno = $data[5];
$currency = Currency::model()->findbyattributes(array('currencyname' => $data[6]));
if ($currency !== null) {
$model->currencyid = $currency->currencyid;
}
$model->recordstatus = (int) $data[7];
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;
}
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 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;
}
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 = Menuauth::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Menuauth();
}
$model->menuauthid = (int) $data[0];
$menuname = Menuaccess::model()->findbyattributes(array('menuname' => $data[1]));
if ($menuname !== null) {
$model->menuaccessid = $menuname->menuaccessid;
}
$model->menuobject = $data[2];
$model->recordstatus = (int) $data[3];
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++;
}
}
}
}
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 = $this->loadModel((int) $data[0]);
if ($model === null) {
$model = new Addressbook();
}
$model->fullname = $data[1];
$model->iscustomer = (int) $data[2];
$model->isemployee = (int) $data[3];
$model->isapplicant = (int) $data[4];
$model->isvendor = (int) $data[5];
$model->isinsurance = (int) $data[6];
$model->isbank = (int) $data[7];
$model->ishospital = (int) $data[8];
$model->iscatering = (int) $data[9];
$model->recordstatus = (int) $data[10];
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;
}
public function actionUpload()
{
parent::actionUpload();
$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 = Productdetail::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Productdetail();
}
$model->productdetailid = (int) $data[0];
$model->productid = $data[1];
$model->baseuom = $data[2];
$model->materialgroupid = (int) $data[3];
$model->oldmatno = $data[4];
$model->divisionid = (int) $data[5];
$model->grossweight = $data[6];
$model->weightunit = $data[7];
$model->netweight = $data[8];
$model->volume = $data[9];
$model->volumeunit = (int) $data[10];
$model->sizedimension = $data[11];
$model->materialpackage = (int) $data[12];
$model->recordstatus = (int) $data[13];
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 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 = Groupmenu::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Groupmenu();
}
$model->groupmenuid = (int) $data[0];
$groupaccess = Groupaccess::model()->findbyattributes(array('groupname' => $data[1]));
if ($groupaccess !== null) {
$model->groupaccessid = $groupaccess->groupaccessid;
}
$menuaccess = Menuaccess::model()->findbyattributes(array('menuname' => $data[2]));
if ($menuaccess !== null) {
$model->menuaccessid = $menuaccess->menuaccessid;
}
$model->isread = (int) $data[3];
$model->iswrite = (int) $data[4];
$model->ispost = (int) $data[5];
$model->isreject = (int) $data[6];
$model->isupload = (int) $data[7];
$model->isdownload = (int) $data[8];
$model->recordstatus = (int) $data[9];
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;
}
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) {
if ($data[0] != '') {
$model = new Genjournal();
$model->journaldate = $data[0];
$model->postdate = $data[0];
$model->referenceno = $data[1];
$model->recordstatus = Wfgroup::model()->findstatusbyuser('insgenjournal');
$model->save();
$oldid = $model->genjournalid;
}
if ($oldid != 0) {
$detail = new Journaldetail();
$detail->genjournalid = $oldid;
$account = Account::model()->findbysql("select accountid from account where upper(accountcode) = '" . $data[2] . "'");
if ($account != null) {
$detail->accountid = $account->accountid;
}
if ($data[3] != '') {
$detail->debit = $data[3];
$detail->credit = 0;
}
if ($data[4] != '') {
$detail->debit = 0;
$detail->credit = $data[4];
}
$currency = Currency::model()->findbysql("select currencyid from currency where upper(currencyname) = '" . $data[5] . "'");
if ($currency != null) {
$detail->currencyid = $currency->currencyid;
}
$detail->detailnote = $data[1];
if (!$detail->save()) {
$this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]);
}
}
}
}
} 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;
}
public function actionUpload()
{
parent::actionUpload();
$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 = Groupmenuauth::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Groupmenuauth();
}
$model->groupmenuid = (int) $data[0];
$model->groupaccessid = (int) $data[1];
$model->menuaccessid = (int) $data[2];
$model->isread = (int) $data[3];
$model->iswrite = (int) $data[4];
$model->ispost = (int) $data[5];
$model->isreject = (int) $data[6];
$model->isupload = (int) $data[7];
$model->isdownload = (int) $data[8];
$model->recordstatus = (int) $data[9];
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 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 = Account::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Account();
}
$model->accountid = (int) $data[0];
$model->accountcode = $data[1];
$model->accountname = $data[2];
if ($data[3] != '') {
$model->parentaccountid = (int) $data[3];
} else {
$model->parentaccountid = null;
}
if ($data[4] != '') {
$accounttype = Accounttype::model()->findbysql("select * from accounttype where upper(accounttypename) = upper('" . $data[4] . "')");
if ($accounttype != null) {
$model->accounttypeid = $accounttype->accounttypeid;
} else {
$model->accounttypeid = null;
}
} else {
$model->accounttypeid = null;
}
if ($data[5] != '') {
$currency = Currency::model()->findbysql("select * from currency where upper(currencyname) = upper('" . $data[5] . "')");
if ($currency != null) {
$model->currencyid = $currency->currencyid;
} else {
$model->currencyid = null;
}
} else {
$model->currencyid = null;
}
$model->recordstatus = $data[6];
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;
}
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 = $this->loadModel((int) $data[0]);
if ($model === null) {
$model = new Useraccess();
}
$model->useraccessid = $data[0];
$model->username = $data[1];
$model->realname = $data[2];
$model->email = $data[3];
$model->phoneno = $data[4];
$model->salt = $model->generatesalt();
$model->password = $model->hashpassword('demo', $model->salt);
$language = Language::model()->findbyattributes(array('languagename' => $data[5]));
if ($language !== null) {
$model->languageid = $language->languageid;
}
$model->recordstatus = (int) $data[6];
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;
}
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 = Jobs::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Jobs();
}
$model->jobsid = (int) $data[0];
$structure = Orgstructure::model()->findbyattributes(array('structurename' => $data[1]));
if ($structure !== null) {
$model->orgstructureid = $structure->orgstructureid;
}
$position = Orgstructure::model()->findbyattributes(array('positionname' => $data[2]));
if ($position !== null) {
$model->positionid = $structure->positionid;
}
$model->jobdesc = $data[3];
$model->qualification = $data[4];
$model->recordstatus = (int) $data[5];
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;
}
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 = Employeetype::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Employeetype();
}
$model->employeetypeid = (int) $data[0];
$model->employeetypename = $data[1];
$snro = Snro::model()->findbyattributes(array('description' => $data[2]));
if ($snro != null) {
$model->snroid = $snro->snroid;
}
$snro = Snro::model()->findbyattributes(array('description' => $data[3]));
if ($snro != null) {
$model->sicksnroid = $snro->snroid;
}
$snro = Absstatus::model()->findbyattributes(array('shortstat' => $data[4]));
if ($snro != null) {
$model->sickstatusid = $snro->absstatusid;
}
$model->recordstatus = (int) $data[5];
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;
}