/**
* 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,
));
}
$auth = new Auth();
$userdata = $auth->getUserDataById($_COOKIE['id']);
if ($userdata['hash'] !== $_COOKIE['hash'] or $userdata['id'] !== $_COOKIE['id']) {
/* setcookie("id", "", time() - 3600*24*30*12, "/");
setcookie("hash", "", time() - 3600*24*30*12, "/");
print "Хм, что-то не получилось";*/
// header("Location: {ROOT_PATH} login.php"); exit();
include $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . 'chat/auth/login.php';
exit;
} else {
// require_once '../PHP/vendor/twig/twig/lib/Twig/Autoloader.php';
// require_once '..\PHP\Twig-1.23.3\lib\Twig\Autoloader.php';
include_once $TWIG_AUTOLOADER_PATH;
include_once "UserEvents.class.php";
$userEvents = new UserEvents();
$userEvents->deleteEvent($userdata['id']);
Twig_Autoloader::register();
// указываем где хранятся шаблоны
$loader = new Twig_Loader_Filesystem('templates');
// инициализируем Twig
$twig = new Twig_Environment($loader);
// подгружаем шаблон
$template = $twig->loadTemplate('main.tmpl');
$chat = new Chat();
$users = $chat->getUsers($userdata['id']);
$context = array("users" => $users, "userName" => $userdata["name"], "avatarUrl" => $userdata["avatar_url"]);
echo $template->render($context);
}
} else {
header('Location: /chat/auth/login.php');
/*case "getRenderedHistory":
$fromUser = $_POST['fromUser'];
$toUser = $_POST['toUser'];
$pageIndex = $_POST['historyPageIndex'];
$history = $chat->getRenderedHistory($fromUser, $toUser, $pageIndex);
break;*/
/*case "getRenderedHistory":
$fromUser = $_POST['fromUser'];
$toUser = $_POST['toUser'];
$pageIndex = $_POST['historyPageIndex'];
$history = $chat->getRenderedHistory($fromUser, $toUser, $pageIndex);
break;*/
case "setCompanion":
$fromUser = $_POST["fromUser"];
$toUser = (int) $_POST["toUser"];
include_once "UserEvents.class.php";
$userEvents = new UserEvents();
// $jsonEvent = json_encode(array("companion"=>$toUser));
$event = array("companion" => $toUser);
$userEvents->writeEvent($fromUser, $event);
break;
case "sendTyping":
$fromUser = $_POST["fromUser"];
$toUser = $_POST["toUser"];
include_once "UserEvents.class.php";
$userEvents = new UserEvents();
$events = $userEvents->readEvent($toUser);
$events["typing"][] = $fromUser;
$userEvents->writeEvent($toUser, $events);
break;
}
