/**
* 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());
}
}
}
}
}
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'usergroup-form', 'enableAjaxValidation' => false));
$this->widget('ToolbarButton', array('isSave' => true, 'UrlSave' => 'usergroup/write', 'isCancel' => true, 'UrlCancel' => 'usergroup/cancelwrite'));
echo $form->hiddenField($model, 'usergroupid');
?>
<div class="row">
<?php
echo $form->labelEx($model, 'useraccessid');
?>
<?php
echo $form->hiddenField($model, 'useraccessid');
?>
<input type="text" name="username" id="username" readonly >
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'useraccess_dialog', 'options' => array('title' => Yii::t('app', 'User Access'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$useraccess = new Useraccess('searchwstatus');
$useraccess->unsetAttributes();
// clear any default values
if (isset($_GET['Useraccess'])) {
$useraccess->attributes = $_GET['Useraccess'];
}
$this->widget('zii.widgets.grid.CGridView', array('id' => 'useraccess-grid', 'dataProvider' => $useraccess->search(), 'filter' => $useraccess, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+",
array("name" => "send_absschedule",
"id" => "send_absschedule",
"onClick" => "$(\\"#useraccess_dialog\\").dialog(\\"close\\"); $(\\"#username\\").val(\\"$data->username\\"); $(\\"#Usergroup_useraccessid\\").val(\\"$data->useraccessid\\");
"))'), array('name' => 'useraccessid', 'visible' => false, 'value' => '$data->useraccessid', 'htmlOptions' => array('width' => '1%')), 'username')));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$.fn.yiiGridView.update("useraccess-grid");$("#useraccess_dialog").dialog("open"); return false;'));
?>
<?php
echo $form->error($model, 'useraccessid');
/**
* 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;
}
