/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { parent::actionCreate(); $this->lookupdata(); $model = new Deliveryadvice(); $model->recordstatus = Wfgroup::model()->findstatusbyuser('insda'); $model->useraccessid = Useraccess::model()->findbysql("select * from useraccess \n where upper(username)=upper('" . Yii::app()->user->name . "')")->useraccessid; if (Yii::app()->request->isAjaxRequest) { if ($model->save()) { echo CJSON::encode(array('status' => 'success', 'deliveryadviceid' => $model->deliveryadviceid, 'divcreate' => $this->renderPartial('_form', array('model' => $model, 'deliveryadvicedetail' => $this->deliveryadvicedetail), true))); Yii::app()->end(); } } }
/** * Authenticates a user. * The example implementation makes sure if the username and password * are both 'demo'. * In practical applications, this should be changed to authenticate * against some persistent user identity storage (e.g. database). * @return boolean whether authentication succeeds. */ public function authenticate() { $user = Useraccess::model()->find('LOWER(username)=?', array(strtolower($this->username))); if ($user === null) { $this->errorCode = self::ERROR_USERNAME_INVALID; } else { if (!$user->validatePassword($this->password)) { $this->errorCode = self::ERROR_PASSWORD_INVALID; } else { $this->username = $user->username; $this->errorCode = self::ERROR_NONE; } } return $this->errorCode == self::ERROR_NONE; }
echo '</div>'; $this->endWidget(); echo "</div>"; } ?> </div> <div class="abs" id="bar_bottom"> <a class="float_left" href="#" id="show_desktop" title="Show Desktop"> <img src="<?php echo Yii::app()->theme->baseurl; ?> /images/show_desktop.png" /> </a> </div> <?php $useraccess = Useraccess::model()->findbyattributes(array('username' => Yii::app()->user->id)); Yii::app()->theme = $useraccess->theme; for ($i = 1; $i <= Yii::app()->params['maxform']; $i++) { $this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => $i, 'options' => array('autoOpen' => false, 'modal' => false, 'width' => 'auto', 'height' => 'auto', 'resizable' => false, 'close' => 'js:function(){ var ni = document.getElementById("module' . $i . '"); ni.innerHTML = ""; }'))); ?> <div id='module<?php echo $i; ?> '></div> <?php $this->endWidget(); } ?> <script type="text/javascript"> function loadmodule(value)
public function actionGetNotification() { $this->layout = '//layouts/column2'; $datatext = ''; $datatext1 = ''; if (Yii::app()->user->id != '') { $models = Userinbox::model()->findallbyattributes(array('username' => Yii::app()->user->id)); foreach ($models as $model) { if ($model->usermessages != '') { $datatext = $model->userfrom . '(' . $model->inboxdatetime . '): ' . $model->usermessages . '<br>' . $datatext; } } } if (Yii::app()->user->id != '') { $users = Useraccess::model()->findall(array('select' => 'username', 'condition' => "username<>'" . Yii::app()->user->id . "' and recordstatus=2")); foreach ($users as $user) { $datatext1 = $user->username . '<br>' . $datatext1; } } echo CJSON::encode(array('data' => $datatext, 'data1' => $datatext1)); }
public function actionWrite() { parent::actionWrite(); if (isset($_POST['Employeeschedule'])) { $messages = $this->ValidateData(array(array($_POST['Employeeschedule']['employeeid'], 'htesemptyemployeeid', 'emptystring'), array($_POST['Employeeschedule']['month'], 'htesemptymonth', 'emptystring'), array($_POST['Employeeschedule']['year'], 'htesemptyyear', 'emptystring'))); if ($messages == '') { //$dataku->attributes=$_POST['Employeeschedule']; if ((int) $_POST['Employeeschedule']['employeescheduleid'] > 0) { $connection = Yii::app()->db; $transaction = $connection->beginTransaction(); try { $sql = 'call UpdateEmployeeSchedule(:vemployeescheduleid, :vemployeeid, :vmonth, :vyear, :vd1, :vd2, :vd3, :vd4, :vd5, :vd6, :vd7, :vd8, :vd9, :vd10, :vd11, :vd12, :vd13, :vd14, :vd15, :vd16, :vd17, :vd18, :vd19, :vd20, :vd21, :vd22, :vd23, :vd24, :vd25, :vd26, :vd27, :vd28, :vd29, :vd30, :vd31, :vlastupdateby)'; $command = $connection->createCommand($sql); $command->bindParam(':vemployeescheduleid', $_POST['Employeeschedule']['employeescheduleid'], PDO::PARAM_INT); $command->bindParam(':vemployeeid', $_POST['Employeeschedule']['employeeid'], PDO::PARAM_INT); $command->bindParam(':vmonth', $_POST['Employeeschedule']['month'], PDO::PARAM_INT); $command->bindParam(':vyear', $_POST['Employeeschedule']['year'], PDO::PARAM_INT); $command->bindParam(':vd1', $_POST['Employeeschedule']['d1'], PDO::PARAM_INT); $command->bindParam(':vd2', $_POST['Employeeschedule']['d2'], PDO::PARAM_INT); $command->bindParam(':vd3', $_POST['Employeeschedule']['d3'], PDO::PARAM_INT); $command->bindParam(':vd4', $_POST['Employeeschedule']['d4'], PDO::PARAM_INT); $command->bindParam(':vd5', $_POST['Employeeschedule']['d5'], PDO::PARAM_INT); $command->bindParam(':vd6', $_POST['Employeeschedule']['d6'], PDO::PARAM_INT); $command->bindParam(':vd7', $_POST['Employeeschedule']['d7'], PDO::PARAM_INT); $command->bindParam(':vd8', $_POST['Employeeschedule']['d8'], PDO::PARAM_INT); $command->bindParam(':vd9', $_POST['Employeeschedule']['d9'], PDO::PARAM_INT); $command->bindParam(':vd10', $_POST['Employeeschedule']['d10'], PDO::PARAM_INT); $command->bindParam(':vd11', $_POST['Employeeschedule']['d11'], PDO::PARAM_INT); $command->bindParam(':vd12', $_POST['Employeeschedule']['d12'], PDO::PARAM_INT); $command->bindParam(':vd13', $_POST['Employeeschedule']['d13'], PDO::PARAM_INT); $command->bindParam(':vd14', $_POST['Employeeschedule']['d14'], PDO::PARAM_INT); $command->bindParam(':vd15', $_POST['Employeeschedule']['d15'], PDO::PARAM_INT); $command->bindParam(':vd16', $_POST['Employeeschedule']['d16'], PDO::PARAM_INT); $command->bindParam(':vd17', $_POST['Employeeschedule']['d17'], PDO::PARAM_INT); $command->bindParam(':vd18', $_POST['Employeeschedule']['d18'], PDO::PARAM_INT); $command->bindParam(':vd19', $_POST['Employeeschedule']['d19'], PDO::PARAM_INT); $command->bindParam(':vd20', $_POST['Employeeschedule']['d20'], PDO::PARAM_INT); $command->bindParam(':vd21', $_POST['Employeeschedule']['d21'], PDO::PARAM_INT); $command->bindParam(':vd22', $_POST['Employeeschedule']['d22'], PDO::PARAM_INT); $command->bindParam(':vd23', $_POST['Employeeschedule']['d23'], PDO::PARAM_INT); $command->bindParam(':vd24', $_POST['Employeeschedule']['d24'], PDO::PARAM_INT); $command->bindParam(':vd25', $_POST['Employeeschedule']['d25'], PDO::PARAM_INT); $command->bindParam(':vd26', $_POST['Employeeschedule']['d26'], PDO::PARAM_INT); $command->bindParam(':vd27', $_POST['Employeeschedule']['d27'], PDO::PARAM_INT); $command->bindParam(':vd28', $_POST['Employeeschedule']['d28'], PDO::PARAM_INT); $command->bindParam(':vd29', $_POST['Employeeschedule']['d29'], PDO::PARAM_INT); $command->bindParam(':vd30', $_POST['Employeeschedule']['d30'], PDO::PARAM_INT); $command->bindParam(':vd31', $_POST['Employeeschedule']['d31'], PDO::PARAM_INT); $post = Useraccess::model()->find("username='******'", array(':postID' => Yii::app()->user->name)); $command->bindParam(':vlastupdateby', $post, PDO::PARAM_INT); $command->execute(); $transaction->commit(); $this->DeleteLock($this->menuname, $_POST['Employeeschedule']['employeescheduleid']); $this->GetSMessage('htesinsertsuccess'); } catch (Exception $e) { $transaction->rollBack(); $this->GetMessage($e->getMessage()); } } else { $model = new Employeeschedule(); $model->attributes = $_POST['Employeeschedule']; $connection = Yii::app()->db; $transaction = $connection->beginTransaction(); try { $sql = 'call InsertEmployeeSchedule(:vemployeeid, :vmonth, :vyear, :vd1, :vd2, :vd3, :vd4, :vd5, :vd6, :vd7, :vd8, :vd9, :vd10, :vd11, :vd12, :vd13, :vd14, :vd15, :vd16, :vd17, :vd18, :vd19, :vd20, :vd21, :vd22, :vd23, :vd24, :vd25, :vd26, :vd27, :vd28, :vd29, :vd30, :vd31, :vcreatedby)'; $command = $connection->createCommand($sql); $command->bindParam(':vemployeeid', $_POST['Employeeschedule']['employeeid'], PDO::PARAM_INT); $command->bindParam(':vmonth', $_POST['Employeeschedule']['month'], PDO::PARAM_INT); $command->bindParam(':vyear', $_POST['Employeeschedule']['year'], PDO::PARAM_INT); $command->bindParam(':vd1', $_POST['Employeeschedule']['d1'], PDO::PARAM_INT); $command->bindParam(':vd2', $_POST['Employeeschedule']['d2'], PDO::PARAM_INT); $command->bindParam(':vd3', $_POST['Employeeschedule']['d3'], PDO::PARAM_INT); $command->bindParam(':vd4', $_POST['Employeeschedule']['d4'], PDO::PARAM_INT); $command->bindParam(':vd5', $_POST['Employeeschedule']['d5'], PDO::PARAM_INT); $command->bindParam(':vd6', $_POST['Employeeschedule']['d6'], PDO::PARAM_INT); $command->bindParam(':vd7', $_POST['Employeeschedule']['d7'], PDO::PARAM_INT); $command->bindParam(':vd8', $_POST['Employeeschedule']['d8'], PDO::PARAM_INT); $command->bindParam(':vd9', $_POST['Employeeschedule']['d9'], PDO::PARAM_INT); $command->bindParam(':vd10', $_POST['Employeeschedule']['d10'], PDO::PARAM_INT); $command->bindParam(':vd11', $_POST['Employeeschedule']['d11'], PDO::PARAM_INT); $command->bindParam(':vd12', $_POST['Employeeschedule']['d12'], PDO::PARAM_INT); $command->bindParam(':vd13', $_POST['Employeeschedule']['d13'], PDO::PARAM_INT); $command->bindParam(':vd14', $_POST['Employeeschedule']['d14'], PDO::PARAM_INT); $command->bindParam(':vd15', $_POST['Employeeschedule']['d15'], PDO::PARAM_INT); $command->bindParam(':vd16', $_POST['Employeeschedule']['d16'], PDO::PARAM_INT); $command->bindParam(':vd17', $_POST['Employeeschedule']['d17'], PDO::PARAM_INT); $command->bindParam(':vd18', $_POST['Employeeschedule']['d18'], PDO::PARAM_INT); $command->bindParam(':vd19', $_POST['Employeeschedule']['d19'], PDO::PARAM_INT); $command->bindParam(':vd20', $_POST['Employeeschedule']['d20'], PDO::PARAM_INT); $command->bindParam(':vd21', $_POST['Employeeschedule']['d21'], PDO::PARAM_INT); $command->bindParam(':vd22', $_POST['Employeeschedule']['d22'], PDO::PARAM_INT); $command->bindParam(':vd23', $_POST['Employeeschedule']['d23'], PDO::PARAM_INT); $command->bindParam(':vd24', $_POST['Employeeschedule']['d24'], PDO::PARAM_INT); $command->bindParam(':vd25', $_POST['Employeeschedule']['d25'], PDO::PARAM_INT); $command->bindParam(':vd26', $_POST['Employeeschedule']['d26'], PDO::PARAM_INT); $command->bindParam(':vd27', $_POST['Employeeschedule']['d27'], PDO::PARAM_INT); $command->bindParam(':vd28', $_POST['Employeeschedule']['d28'], PDO::PARAM_INT); $command->bindParam(':vd29', $_POST['Employeeschedule']['d29'], PDO::PARAM_INT); $command->bindParam(':vd30', $_POST['Employeeschedule']['d30'], PDO::PARAM_INT); $command->bindParam(':vd31', $_POST['Employeeschedule']['d31'], PDO::PARAM_INT); $post = Useraccess::model()->find("username='******'", array(':postID' => Yii::app()->user->name)); $command->bindParam(':vcreatedby', $post, PDO::PARAM_INT); $command->execute(); $transaction->commit(); $this->DeleteLock($this->menuname, $_POST['Employeeschedule']['employeescheduleid']); $this->GetSMessage('htesinsertsuccess'); } catch (Exception $e) { $transaction->rollBack(); $this->GetMessage($e->getMessage()); } } } } }
/** * 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 = Useraccess::model()->findByPk((int) $id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
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 = Usergroup::model()->findByPk((int) $data[0]); if ($model === null) { $model = new Usergroup(); } $model->usergroupid = (int) $data[0]; $useraccess = Useraccess::model()->findbyattributes(array('username' => $data[1])); if ($useraccess !== null) { $model->useraccessid = $useraccess->useraccessid; } $groupaccess = Groupaccess::model()->findbyattributes(array('groupname' => $data[2])); if ($groupaccess !== null) { $model->groupaccessid = $groupaccess->groupaccessid; } $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; }