/**
* 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 = UserLog::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* 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()
{
if (strpos($this->username, "@")) {
$user = RbacUser::model()->findByAttributes(array('user_email' => $this->username));
} else {
$user = RbacUser::model()->findByAttributes(array('user_name' => $this->username));
$ph = new PasswordHash(Yii::app()->params['phpass']['iteration_count_log2'], Yii::app()->params['phpass']['portable_hashes']);
}
if ($user === null) {
if (strpos($this->username, "@")) {
$this->errorCode = self::ERROR_EMAIL_INVALID;
} else {
$this->errorCode = self::ERROR_USERNAME_INVALID;
}
} elseif (!$ph->CheckPassword($this->password, $user->user_password)) {
$this->errorCode = self::ERROR_PASSWORD_INVALID;
//else if($user->status==0&&Yii::app()->getModule('user')->loginNotActiv==false)
// $this->errorCode=self::ERROR_STATUS_NOTACTIV;
} elseif ($user->status == 0) {
$this->errorCode = self::ERROR_STATUS_NOTACTIV;
} else {
$this->_id = $user->id;
$this->username = $user->user_name;
// title column as username
$this->errorCode = self::ERROR_NONE;
$employeeId = $user->employee_id;
// Store employee ID in a session:
//$this->setState('employeeid',$employeeId);
Yii::app()->session['employeeid'] = $employeeId;
Yii::app()->session['userid'] = $user->id;
$employee = Employee::model()->findByPk($employeeId);
Yii::app()->session['emp_fullname'] = $employee->first_name . ' ' . $employee->last_name;
//Saving User Login & out timing
Yii::app()->session['unique_id'] = uniqid();
$login_time = Date('Y-m-d H:i:s');
UserLog::model()->saveUserlog(Yii::app()->session['unique_id'], Yii::app()->session->sessionID, Yii::app()->session['userid'], $employeeId, $user->user_name, $login_time);
}
return !$this->errorCode;
}
/**
* Logs out the current user and redirect to homepage.
*/
public function actionLogout()
{
UserLog::model()->saveUserLogOut(Yii::app()->session['unique_id'], Date('Y-m-d H:i:s'));
Yii::app()->user->logout();
$this->redirect(Yii::app()->homeUrl);
}
/**
* Lists all models.
*/
public function actionIndex()
{
if (isset($_POST['oper']) && $_POST['oper'] == 'edit') {
$logId = intval($_POST["id"]);
$log = UserLog::model()->with('user')->findByPk($logId);
if ($log) {
$user = $log->user;
$person = $user->person;
$addresses = $person->adresses;
$log->Table_Name = $_POST["Table_Name"];
$log->Date_Time = $_POST["Date_Time"];
$log->ROW_ID = $_POST["ROW_ID"];
$log->Event_Type = $_POST["Event_Type"];
if ($log->validate()) {
$log->save();
echo "log\n";
}
if (isset($addresses[0])) {
$address = $addresses[0];
$address->Address1 = $_POST["Address1"];
$address->Address2 = $_POST["Address2"];
$address->City = $_POST["City"];
$address->State = $_POST["State"];
$address->ZIP = $_POST["ZIP"];
$address->Country = $_POST["Country"];
$address->Phone = $_POST["Phone"];
$address->Fax = $_POST["Fax"];
if ($address->validate()) {
$address->save();
echo "adresses\n";
}
}
$user->User_Login = $_POST["User_Login"];
$user->User_Type = $_POST["User_Type"];
$user->Last_Login = $_POST["Last_Login"] ? $_POST["Last_Login"] : null;
$user->Active = intval($_POST["Active"]);
if ($user->validate()) {
$user->save();
echo "user\n";
}
$person->First_Name = $_POST["First_Name"];
$person->Last_Name = $_POST["Last_Name"];
$person->Email = $_POST["Email"];
$person->Mobile_Phone = $_POST["Mobile_Phone"];
$person->Direct_Phone = $_POST["Direct_Phone"];
$person->Direct_Fax = $_POST["Direct_Fax"];
if ($person->validate()) {
$person->save();
echo "person\n";
}
}
die;
}
if (isset($_POST['oper']) && $_POST['oper'] == 'add') {
die;
}
if (isset($_POST['oper']) && $_POST['oper'] == 'del') {
$logId = intval($_POST["id"]);
$log = UserLog::model()->findByPk($logId);
if ($log) {
$log->delete();
}
die;
}
$conn = mysql_connect(Yii::app()->params->dbhost, Yii::app()->params->dbuser, Yii::app()->params->dbpassword);
mysql_select_db(Yii::app()->params->dbname);
mysql_query("SET NAMES 'utf8'");
Yii::import('ext.phpgrid.inc.jqgrid');
// set columns
$col = array();
$col["title"] = "Log ID"; // caption of column
$col["name"] = "Log_ID";
$col["dbname"] = "user_log.Log_ID"; // grid column name, same as db field or alias from sql
$col["resizable"] = false;
$col["editable"] = false; // this column is editable
$col["hidden"] = false;
$col["viewable"] = true;
$col["search"] = false;
$col["sortable"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "Table Name"; // caption of column
$col["name"] = "Table_Name";
$col["dbname"] = "user_log.Table_Name"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "ROW ID"; // caption of column
$col["name"] = "ROW_ID";
$col["dbname"] = "user_log.ROW_ID"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "Date Time"; // caption of column
$col["name"] = "Date_Time";
$col["dbname"] = "user_log.Date_Time"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$events = UserEvents::model()->findAll();
foreach ($events as $event) {
$eventIds[] = $event->Event_Type . ':' . $event->Description;
}
$col = array();
$col["title"] = "Event Type"; // caption of column
$col["name"] = "Event_Type";
$col["dbname"] = "user_log.Event_Type"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$col["edittype"] = "select";
$col["editoptions"] = array("value"=>implode(';', $eventIds));
$cols[] = $col;
$col = array();
$col["title"] = "Event Description"; // caption of column
$col["name"] = "Description";
$col["dbname"] = "user_events.Description"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = false; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
// set columns
$col = array();
$col["title"] = "Person ID"; // caption of column
$col["name"] = "Person_ID";
$col["dbname"] = "persons.Person_ID"; // grid column name, same as db field or alias from sql
$col["resizable"] = false;
$col["editable"] = false; // this column is editable
$col["hidden"] = false;
$col["viewable"] = true;
$col["search"] = false;
$col["sortable"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "First Name"; // caption of column
$col["name"] = "First_Name";
$col["dbname"] = "persons.First_Name"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Last Name"; // caption of column
$col["name"] = "Last_Name";
$col["dbname"] = "persons.Last_Name"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Email"; // caption of column
$col["name"] = "Email";
$col["dbname"] = "persons.Email"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Mobile Phone"; // caption of column
$col["name"] = "Mobile_Phone";
$col["dbname"] = "persons.Mobile_Phone"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "Direct Phone"; // caption of column
$col["name"] = "Direct_Phone";
$col["dbname"] = "persons.Direct_Phone"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "Direct Fax"; // caption of column
$col["name"] = "Direct_Fax";
$col["dbname"] = "persons.Direct_Fax"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
// set columns
$col = array();
$col["title"] = "User ID"; // caption of column
$col["name"] = "User_ID";
$col["dbname"] = "user_log.User_ID"; // grid column name, same as db field or alias from sql
$col["resizable"] = false;
$col["editable"] = false; // this column is editable
$col["hidden"] = false;
$col["viewable"] = true;
$col["search"] = false;
$col["sortable"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "Default Project"; // caption of column
$col["name"] = "Default_Project";
$col["dbname"] = "users.Default_Project"; // grid column name, same as db field or alias from sql
$col["resizable"] = false;
$col["editable"] = false; // this column is editable
$col["hidden"] = true;
$col["viewable"] = true;
$col["search"] = false;
$col["sortable"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "User Login"; // caption of column
$col["name"] = "User_Login";
$col["dbname"] = "users.User_Login"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "User Type"; // caption of column
$col["name"] = "User_Type";
$col["dbname"] = "users.User_Type"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["edittype"] = "select";
$col["editoptions"] = array("value"=>'User:User;Admin:Admin;DB Admin:DB Admin;Data Entry Clerk:Data Entry Clerk');
$cols[] = $col;
$col = array();
$col["title"] = "Last Login"; // caption of column
$col["name"] = "Last_Login";
$col["dbname"] = "users.Last_Login"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "Active"; // caption of column
$col["name"] = "Active";
$col["dbname"] = "users.Active"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$col["sortable"] = true;
$col["edittype"] = "select";
$col["editoptions"] = array("value"=>'0:0;1:1');
$cols[] = $col;
$col = array();
$col["title"] = "Last_IP"; // caption of column
$col["name"] = "Last_IP";
$col["dbname"] = "users.Last_IP"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = false; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$col["sortable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Address1"; // caption of column
$col["name"] = "Address1";
$col["dbname"] = "addresses.Address1"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Address2"; // caption of column
$col["name"] = "Address2";
$col["dbname"] = "addresses.Address2"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "City"; // caption of column
$col["name"] = "City";
$col["dbname"] = "addresses.City"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "State"; // caption of column
$col["name"] = "State";
$col["dbname"] = "addresses.State"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "ZIP"; // caption of column
$col["name"] = "ZIP";
$col["dbname"] = "addresses.ZIP"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Country"; // caption of column
$col["name"] = "Country";
$col["dbname"] = "addresses.Country"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$cols[] = $col;
$col = array();
$col["title"] = "Phone"; // caption of column
$col["name"] = "Phone";
$col["dbname"] = "addresses.Phone"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$col = array();
$col["title"] = "Fax"; // caption of column
$col["name"] = "Fax";
$col["dbname"] = "addresses.Fax"; // grid column name, same as db field or alias from sql
$col["resizable"] = true;
$col["editable"] = true; // this column is editable
$col["viewable"] = true;
$col["search"] = false;
$cols[] = $col;
$g = new jqgrid();
$grid["caption"] = "User Log";
// $grid["multiselect"] = true;
$grid["autowidth"] = true;
$grid["resizable"] = true;
//$grid["toppager"] = true;
$grid["sortname"] = 'users.User_ID';
$grid["sortorder"] = "ASC";
$grid["add_options"] = array(
'width'=>'420',
"closeAfterEdit"=>true, // close dialog after add/edit
"top"=>"200", // absolute top position of dialog
"left"=>"200" // absolute left position of dialog
);
$g->set_options($grid);
$g->set_actions(array(
"add"=>false, // allow/disallow add
"edit"=>true, // allow/disallow edit
"delete"=>true, // allow/disallow delete
"rowactions"=>true, // show/hide row wise edit/del/save option
"export"=>true, // show/hide export to excel option
"autofilter" => true, // show/hide autofilter for search
"search" => "advance" // show single/multi field search condition (e.g. simple or advance)
)
);
$g->select_command = "SELECT user_log.*, users.Default_Project,
users.User_Login, users.User_Type, users.Last_Login, users.Active,
users.Last_IP, addresses.*,
persons.*, user_events.Description
FROM user_log
LEFT JOIN users ON users.User_ID = user_log.User_ID
LEFT JOIN user_events ON user_events.Event_Type = user_log.Event_Type
LEFT JOIN persons ON users.Person_ID = persons.Person_ID
LEFT JOIN person_addresses ON person_addresses.Person_ID = persons.Person_ID
LEFT JOIN addresses ON addresses.Address_ID = person_addresses.Address_ID WHERE user_log.User_ID != 0";
// set database table for CRUD operations
$g->table = "user_log";
$g->set_columns($cols);
// group columns header
$g->set_group_header( array(
"useColSpanStyle"=>true,
"groupHeaders"=>array(
array(
"startColumnName"=>'Log_ID', // group starts from this column
"numberOfColumns"=>6, // group span to next 2 columns
"titleText"=>'Log Information' // caption of group header
),
array(
"startColumnName"=>'Person_ID', // group starts from this column
"numberOfColumns"=>7, // group span to next 2 columns
"titleText"=>'Person Information' // caption of group header
),
array(
"startColumnName"=>'User_ID', // group starts from this column
"numberOfColumns"=>7, // group span to next 2 columns
"titleText"=>'User Information' // caption of group header
),
array(
"startColumnName"=>'Address1', // group starts from this column
"numberOfColumns"=>8, // group span to next 2 columns
"titleText"=>"User's Address" // caption of group header
)
)
)
);
// render grid and get html/js output
$out = $g->render("User_Log");
$this->render('index',array(
'out'=>$out,
));
}