packorderitem.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / models / packorderitem.php

vikappointments / admin / models Last commit date

packorderitem.php

77 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	VAPLoader::import('libraries.mvc.model');
15
16	/**
17	* VikAppointments package order item model.
18	*
19	* @since 1.7
20	*/
21	class VikAppointmentsModelPackorderitem extends JModelVAP
22	{
23	/**
24	* Basic save implementation.
25	*
26	* @param mixed $data Either an array or an object of data to save.
27	*
28	* @return mixed The ID of the record on success, false otherwise.
29	*/
30	public function save($data)
31	{
32	$data = (array) $data;
33
34	if (!empty($data['id']) && isset($data['used_app']))
35	{
36	// get table instance
37	$table = $this->getTable();
38
39	// try to load the existing record and check whether the number of
40	// used appointments is going to change
41	if ($table->load($data['id']) && (int) $data['used_app'] != (int) $table->used_app)
42	{
43	// The modified date is only used to check the last time an appointments
44	// has been redeemed with the available packages. So we don't want to
45	// have it updated every time the package order gets saved.
46	$data['modifiedon'] = JFactory::getDate()->toSql();
47	}
48	}
49
50	// attempt to save the record
51	return parent::save($data);
52	}
53
54	/**
55	* Calculates the total discount of the specified items.
56	*
57	* @param mixed $ids Either the record ID or a list of records.
58	*
59	* @return float The resulting amount.
60	*/
61	public function getTotalDiscount($ids)
62	{
63	// only int values are accepted
64	$ids = array_map('intval', (array) $ids);
65
66	$dbo = JFactory::getDbo();
67
68	$q = $dbo->getQuery(true)
69	->select('SUM(discount)')
70	->from($dbo->qn('#__vikappointments_package_order_item'))
71	->where($dbo->qn('id') . ' IN (' . implode(',', $ids) . ')' );
72
73	$dbo->setQuery($q);
74	return (float) $dbo->loadResult();
75	}
76	}
77