public function actionView($id)
{
if (!empty($id)) {
$contenido = Contenido::model()->findByPk($id);
}
if (isset($_POST['Contenido'])) {
$contenido->texto = $_POST['Contenido']['texto'];
$log = new Logs();
try {
$log->accion = 'Edito el contenido de ' . $contenido->nombre . ' como admin';
$log->usuario = Yii::app()->user->id;
$log->msg = 'IP: ' . $_SERVER['REMOTE_ADDR'] . ' : ' . $_SERVER['REMOTE_PORT'];
$log->fecha = date('Y-m-d G:i:s');
$log->save();
} catch (Exception $e) {
$log->accion = 'Error log';
$log->msg = '';
$log->fecha = '';
$log->save();
}
$contenido->save('update');
}
// render - 1. vista 2. array con los objetos de tipo CActiveReord
$this->render('form', array('model' => $contenido));
}
public function logoutAction()
{
// Log out
if (Auth::User()) {
$user = new Usernhc();
$user_id = Auth::User()->id;
$user_info = $user->getUsernhcById($user_id);
$logs = new Logs();
$logs->ip = Request::getClientIp();
$logs->host = Request::root();
$logs->lastpage = '';
$logs->last_visit = date('Y-m-d H:i:s');
$logs->role_id = $user_info[0]->role_id;
$logs->data_id = rand(1, 11);
$logs->userid = $user_id;
$logs->save();
}
// Redirect to homepage
if (Auth::logout()) {
Auth::logout();
return Redirect::to('login')->with('success', 'ออกจากระบบสำเร็จ');
} else {
return Redirect::to('login')->with('success', 'ออกจากระบบสำเร็จ');
}
}
public static function add($action, $desc)
{
$log = new Logs();
$log->action = CHtml::encode($action);
$log->remarks = CHtml::encode($desc);
if ($log->save()) {
return TRUE;
}
return FALSE;
}
private function logs($action, $tbName, $ID, $message)
{
$dates = $dates = date('Y-m-d H:i:s');
$modelss = new Logs();
$modelss->log_date = $dates;
$modelss->actions = $action;
$modelss->table_name = $tbName;
$modelss->curId = $ID;
$modelss->message = $message;
$modelss->save();
}
public function store()
{
$data = Input::all()['data'];
$bookID = $data['bookID'];
$studentID = $data['studentID'];
$student = Student::find($studentID);
if ($student == NULL) {
throw new Exception('Invalid Student ID');
} else {
$approved = $student->approved;
if ($approved == 0) {
throw new Exception('Student still not approved by Admin Librarian');
} else {
$books_issued = $student->books_issued;
$category = $student->category;
$max_allowed = StudentCategories::where('cat_id', '=', $category)->firstOrFail()->max_allowed;
if ($books_issued >= $max_allowed) {
throw new Exception('Student cannot issue any more books');
} else {
$book = Issue::find($bookID);
if ($book == NULL) {
throw new Exception('Invalid Book Issue ID');
} else {
$book_availability = $book->available_status;
if ($book_availability != 1) {
throw new Exception('Book not available for issue');
} else {
// book is to be issued
DB::transaction(function () use($bookID, $studentID) {
$log = new Logs();
$log->book_issue_id = $bookID;
$log->student_id = $studentID;
$log->issue_by = Auth::id();
$log->issued_at = time();
$log->return_time = 0;
$log->save();
// changing the availability status
$book = Issue::find($bookID);
$book->available_status = 0;
$book->save();
// increasing number of books issed by student
$student = Student::find($studentID);
$student->books_issued = $student->books_issued + 1;
$student->save();
});
return 'Successfully Issued';
}
}
}
}
}
}
public function authenticate()
{
$correo = strtolower($this->correo);
$usuario = Usuario::model()->find('LOWER(correo)=?', array($correo));
if ($usuario === null) {
$this->errorCode = self::ERROR_USERNAME_INVALID;
} else {
if (!$usuario->validatePassword($this->password)) {
$this->errorCode = self::ERROR_PASSWORD_INVALID;
} else {
if ($usuario->estado == 0) {
$this->errorCode = self::ERROR_STATUS;
} else {
$this->_id = $usuario->id;
$this->correo = $usuario->correo;
$this->es_admin = $usuario->es_admin;
$this->errorCode = self::ERROR_NONE;
Yii::app()->user->setState('es_admin', $usuario->es_admin);
if ($usuario->es_admin == 1) {
Yii::app()->user->setState('user_type', 'Admin');
$log = new Logs();
try {
$log->accion = 'Ingreso al sistema como admin';
$log->usuario = 'usuario id' . $usuario->id . ' con ' . $usuario->correo;
$log->msg = 'IP: ' . $_SERVER['REMOTE_ADDR'] . ' : ' . $_SERVER['REMOTE_PORT'];
$log->fecha = date('Y-m-d G:i:s');
$log->save();
} catch (Exception $e) {
$log->accion = 'Error log';
$log->msg = '';
$log->fecha = '';
$log->save();
}
}
}
}
}
return $this->errorCode == self::ERROR_NONE;
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Logs();
$model->user_id = Yii::app()->user->id;
$model->page_id = $_REQUEST['page_id'];
$model->start = date('Y-m-d H:i:s');
$model->end = date('Y-m-d H:i:s');
$model->status = 123;
if ($model->save()) {
echo $model->id;
}
// else
// print_r($model->getErrors());
}
/**
* Creates a new model.
* @return create view
*/
public function actionCreate()
{
// create Logs object model
$model = new Logs();
// if Logs form exist
if (isset($_POST['Logs'])) {
// set form elements to Logs model attributes
$model->attributes = $_POST['Logs'];
// find module_name before save
$module = Modules::model()->find(array('condition' => 't.module_name = :module_name', 'params' => array(':module_name' => $model->module_id)));
// set finded module_id to module->module_id
$model->module_id = $module->module_id;
// save without validate
$model->save(false);
}
}
public function postLogin()
{
if (Request::ajax()) {
$username = Input::get('username');
$password = Input::get('password');
if (Input::has('remember')) {
$remember = Input::get('remember');
} else {
$remember = 0;
}
$data = array('username' => $username, 'password' => $password, 'active' => 1);
if (Auth::attempt($data, $remember)) {
$log = new Logs();
$log->user_id = Auth::user()->id;
$log->login = date('Y-m-d H:i:s', time());
$log->save();
return Response::json(array('type' => 'success', 'msg' => 'Ha iniciado sesión satisfactoriamente, espere a que se le redirija.'));
}
return Response::json(array('type' => 'danger', 'msg' => 'Usuario o contraseña incorrecta.'));
}
}
function statvisits()
{
// log visiwebsite ==============================
$timestart = time();
$d = date('Y-m-d H:i:s');
$remote = getenv("REMOTE_ADDR");
$refer = @$_SERVER['HTTP_REFERER'];
$browser = $_SERVER['HTTP_USER_AGENT'];
$cook_nm = 'G';
$strSQL = " SELECT logdate FROM sitelog Order by id desc LIMIT 0,1";
$objQuery = $this->db->query($strSQL);
$objResult = $objQuery->row_array();
$view_date = $objResult['logdate'];
if ($view_date != "") {
$hours = 0.1;
// 5 minute
if (date($view_date, time() + 3600 * $hours) > 4) {
$rs = new Logs();
$rs->logtime = $timestart;
$rs->logdate = $d;
$rs->ip = $remote;
$rs->refer = $refer;
$rs->browser = $browser;
$rs->username = $cook_nm;
$rs->save();
}
}
// save log visitwebsite ================================
$strSQL = " SELECT DATE FROM counter LIMIT 0,1";
$objQuery = $this->db->query($strSQL);
$objResult = $objQuery->row_array();
if ($objResult["DATE"] != date("Y-m-d")) {
$strSQL = " INSERT INTO daily (DATE,NUM) SELECT '" . date('Y-m-d', strtotime("-1 day")) . "',COUNT(*) AS intYesterday FROM counter WHERE 1 AND DATE = '" . date('Y-m-d', strtotime("-1 day")) . "'";
$this->db->query($strSQL);
$strSQL = " DELETE FROM counter WHERE DATE != '" . date("Y-m-d") . "' ";
$this->db->query($strSQL);
}
$strSQL = " INSERT INTO counter (DATE,IP) VALUES ('" . date("Y-m-d") . "','" . $_SERVER["REMOTE_ADDR"] . "') ";
$this->db->query($strSQL);
$strSQL = " SELECT COUNT(DATE) AS CounterToday FROM counter WHERE DATE = '" . date("Y-m-d") . "' ";
$objQuery = $this->db->query($strSQL);
$objResult = $objQuery->row_array();
$strToday = $objResult["CounterToday"];
$strSQL = " SELECT SUM(NUM) AS CountMonth FROM daily WHERE DATE_FORMAT(DATE,'%Y-%m') = '" . date('Y-m') . "' ";
$objQuery = $this->db->query($strSQL);
$objResult = $objQuery->row_array();
$strThisMonth = $objResult["CountMonth"];
$strSQL = " SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '" . date('Y') . "' ";
$objQuery = $this->db->query($strSQL);
$objResult = $objQuery->row_array();
$strThisYear = $objResult["CountYear"];
$strSQL = " SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '" . date('Y', strtotime("-1 year")) . "' ";
$objQuery = $this->db->query($strSQL);
$objResult = $objQuery->row_array();
$strLastYear = $objResult["CountYear"];
$strSQL = " SELECT * FROM daily ORDER BY DATE ASC";
$objQuery = $this->db->query($strSQL);
$objResult = $objQuery->row_array();
$strbeginDate = $objResult["DATE"];
$strSQL = " SELECT * FROM sitelog ORDER BY id ASC";
$objQuery = $this->db->query($strSQL);
$AllData = $objQuery->num_rows();
$data['beginip'] = $strbeginDate;
$data['todayip'] = $strToday;
$data['monthip'] = $strThisMonth;
$data['yearip'] = $strThisYear;
$data['allip'] = $AllData;
$this->load->view('home_footer', $data);
}
<?php
Logs::save();
function bothRoutes($route, $var = null)
{
switch ($route) {
case 'post:posts':
return new PostsController('create');
case 'get:posts-num':
return new PostsController('read');
case 'put:posts-num':
return new PostsController('update');
case 'delete:posts-num':
return new PostsController('delete');
case 'get:posts':
return new PostsController('all');
case 'get:posts-slug-var':
return new PostsController('readBySlug', $var);
case 'get:posts-search-var':
return new PostsController('search', $var);
case 'get:gamers':
return new GamersController('all');
case 'post:users-facebook':
return new UsersController('singinByFacebook');
case 'post:users-token':
return new UsersController('readByToken');
case 'post:ms-newlesson':
return new MesalvaController('newLesson');
case 'post:ms-readlesson':
return new MesalvaController('readLesson');
default:
public function actionDelete($id)
{
$prx = new PreguntaXRonda();
$rxj = new RespuestaXJugador();
$res = new Respuesta();
$pre = new Pregunta();
$criteria = new CDbCriteria();
$criteria->join = 'inner join pregunta p ON respuesta_x_jugador.pregunta_id = p.id';
$criteria->condition = 'p.id=' . $id;
$prx->deleteAll("pregunta_id = {$id}");
$rxj->deleteAll($criteria);
$res->deleteAll("pregunta_id = {$id}");
$pre->deleteAll("id = {$id}");
$log = new Logs();
try {
$log->accion = 'Elimino la pregunta id #' . $id . ' como admin';
$log->usuario = Yii::app()->user->id;
$log->msg = 'IP: ' . $_SERVER['REMOTE_ADDR'] . ' : ' . $_SERVER['REMOTE_PORT'];
$log->fecha = date('Y-m-d G:i:s');
$log->save();
} catch (Exception $e) {
$log->accion = 'Error log';
$log->msg = '';
$log->fecha = '';
$log->save();
}
$this->redirect(array('index'));
}
public function actionRespuesta()
{
$this->layout = "single";
if (!Yii::app()->request->isAjaxRequest) {
throw new CHttpException('403', 'Forbidden access.');
}
$id = Yii::app()->request->restParams['id'];
// Validar token
if ($this->validarToken()) {
if ($this->validarCuentas()) {
$respuesta = Respuesta::model()->find('id = ?', array(0 => $id));
$pregunta = Pregunta::model()->find('id = ?', array(0 => $respuesta->pregunta->id));
$puntos = $respuesta->pregunta->nivel->puntos;
//$pregunta->estado = 0;
//$pregunta->save();
$respuestaJugador = new RespuestaXJugador();
$log = new Logs();
$respuestaJugador->pregunta_id = $respuesta->pregunta->id;
$respuestaJugador->respuesta_id = $id;
$respuestaJugador->jugador_id = Yii::app()->session['jugador_id'];
$respuestaJugador->fecha = date('Y-m-d G:i:s');
$respuestaJugador->ip = $_SERVER['REMOTE_ADDR'] . ' : ' . $_SERVER['REMOTE_PORT'];
try {
if (Yii::app()->user->id) {
$jugador = Jugador::model()->find('usuario_id = ' . Yii::app()->user->id);
if ($jugador != NULL) {
$log->usuario = 'id ' . $jugador->id . ' - ' . $jugador->nombre;
} else {
$log->usuario = 'id ' . $jugador->id;
}
}
$msg_res = $respuesta->es_correcta == 1 ? 'correcta' : 'incorrecta';
$log->accion = 'Contesto Pregunta # ' . $respuesta->pregunta->id;
$log->msg = 'IP: ' . $_SERVER['REMOTE_ADDR'] . ' : ' . $_SERVER['REMOTE_PORT'] . '- Contesto "' . $pregunta->pregunta . '"' . '- Su Respuesta fue # ' . $id . '- "' . $respuesta->respuesta . '"' . '- Con respuesta ' . $msg_res;
$log->fecha = date('Y-m-d G:i:s');
$log->save();
} catch (Exception $e) {
$log->accion = 'Error log';
$log->msg = '';
$log->fecha = date('Y-m-d G:i:s');
$log->save();
}
$respuestaJugador->save();
$respuesta = Respuesta::model()->find('id = ?', array(0 => $id));
$r = array();
switch ($respuesta->es_correcta == 1) {
case true:
// Respuesta correcta , que por ley no se puede informar al usuario.
$r['message'] = 'Gracias por participar, recuerda revisar tu perfil al final del día para saber los resultados.';
$r['status'] = 'success';
break;
case false:
// Respuesta Incorrecta , que por ley no se puede informar al usuario.
$r['message'] = 'Gracias por participar, recuerda revisar tu perfil al final del día para saber los resultados.';
/**
* formato viejo
**/
$r['status'] = 'success';
// $r['status'] = 'error';
break;
}
/**
*
* Formato Viejo , por seguridad ya no se m
* mandan los puntos al JS.
**/
//$r['puntos'] = $puntos;
$r['puntos'] = 'null';
$this->clearTokenVal();
} else {
$r = array();
$r['message'] = 'Moral error: No puedes jugar aun.';
$r['status'] = 'error';
// Codigo 3 debe estar en el contenido de la base de datos .
$this->redirect(array('site/contenido', 'id' => 3));
Yii::app()->end();
}
} else {
$r = array();
$r['message'] = 'Error , token de seguridad invalido.';
$r['status'] = 'error';
}
header('Content-Type: application/json; charset="UTF-8"');
echo CJSON::encode($r);
Yii::app()->end();
}
/**
* 添加登出日志
* @param $userId
* @param $device_type
* @return Logs
*/
public function createLogout($userId, $device_type)
{
$logs = new Logs();
$logs['message'] = $this->getIP();
//当前登出用户的IP
$logs['user_id'] = $userId;
$logs['type'] = 0;
$arr = array("action" => MConst::LOGOUT, "device_type" => $device_type);
$logs['context'] = serialize($arr);
$logs->save();
return $logs;
}
public function saveLog($modelAttributes, $sendMail = false)
{
$module = Modules::model()->find(array('condition' => 't.module_name = :module_name', 'params' => array(':module_name' => $modelAttributes['module_id'])));
$modelAttributes['module_id'] = $module->module_id;
$model = new Logs();
$model->attributes = $modelAttributes;
if ($model->save()) {
/*if ($sendMail)
$this->sendEmailAlert($modelAttributes);*/
}
}
public static function setSave($save)
{
self::$save = $save;
}
