apilog.php — VikAppointments Services Booking Calendar 1.2.20

vikappointments / admin / tables / apilog.php

vikappointments / admin / tables Last commit date

apilog.php

91 lines

1	<?php
2	/**
3	* @package VikAppointments
4	* @subpackage core
5	* @author E4J s.r.l.
6	* @copyright Copyright (C) 2021 E4J s.r.l. All Rights Reserved.
7	* @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
8	* @link https://vikwp.com
9	*/
10
11	// No direct access
12	defined('ABSPATH') or die('No script kiddies please!');
13
14	/**
15	* VikAppointments API log table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableApilog extends JTableVAP
20	{
21	/**
22	* Class constructor.
23	*
24	* @param object $db The database driver instance.
25	*/
26	public function __construct($db)
27	{
28	parent::__construct('#__vikappointments_api_login_logs', 'id', $db);
29	}
30
31	/**
32	* Method to bind an associative array or object to the Table instance. This
33	* method only binds properties that are publicly accessible and optionally
34	* takes an array of properties to ignore when binding.
35	*
36	* @param array\|object $src An associative array or object to bind to the Table instance.
37	* @param array\|string $ignore An optional array or space separated list of properties to ignore while binding.
38	*
39	* @return boolean True on success.
40	*/
41	public function bind($src, $ignore = array())
42	{
43	$src = (array) $src;
44
45	if (empty($src['id']))
46	{
47	if (empty($src['ip']))
48	{
49	// use current IP address in case it hasn't been specified
50	$src['ip'] = JFactory::getApplication()->input->server->get('REMOTE_ADDR');
51	}
52
53	if (empty($src['createdon']))
54	{
55	// register current time in case it hasn't been specified
56	$src['createdon'] = JFactory::getDate()->toSql();
57	}
58
59	// get logging modality:
60	// - 2 always
61	// - 1 only errors
62	// - 0 never
63	$mode = VAPFactory::getConfig()->getUint('apilogmode');
64
65	$id_login = isset($src['id_login']) ? $src['id_login'] : 0;
66	$status = isset($src['status']) ? $src['status'] : 0;
67
68	// check if we should insert a new record or if we should
69	// update an existing one according to the loggin mode
70	if ($mode == 0 \|\| ($mode == 1 && !empty($src['status'])))
71	{
72	$dbo = JFactory::getDbo();
73
74	$q = $dbo->getQuery(true)
75	->select($dbo->qn('id'))
76	->from($dbo->qn($this->getTableName()))
77	->where($dbo->qn('id_login') . ' = ' . (int) $id_login)
78	->where($dbo->qn('status') . ' = ' . (int) $status);
79
80	$dbo->setQuery($q, 0, 1);
81
82	// force update
83	$src['id'] = (int) $dbo->loadResult();
84	}
85	}
86
87	// bind the details before save
88	return parent::bind($src, $ignore);
89	}
90	}
91