import.php — VikAppointments Services Booking Calendar 1.2.18

vikappointments / admin / models / import.php

vikappointments / admin / models Last commit date

import.php

173 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 import model.
18	*
19	* @since 1.7
20	*/
21	class VikAppointmentsModelImport 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 An array of imported rows on success, false otherwise.
29	*/
30	public function save($data)
31	{
32	$data = (array) $data;
33
34	// prepare parameters
35	$type = isset($data['type']) ? $data['type'] : '';
36	$assoc = isset($data['assoc']) ? $data['assoc'] : array();
37	$args = isset($data['args']) ? $data['args'] : array();
38
39	// do import
40	return $this->import($type, $assoc, $args);
41	}
42
43	/**
44	* Processes an import file.
45	*
46	* @param string $type The import file type.
47	* @param array $assoc A lookup used to associate the CSV columns with the db table.
48	* @param array $args An array of options.
49	*
50	* @return mixed An array of imported rows on success, false otherwise.
51	*/
52	public function import($type, $assoc = array(), $args = array())
53	{
54	VAPLoader::import('libraries.import.factory');
55	$handler = ImportFactory::getObject($type);
56
57	if (!$handler)
58	{
59	throw new Exception('Import type not supported.', 404);
60	}
61
62	if (!$handler->hasFile())
63	{
64	// no uploaded file
65	return false;
66	}
67
68	// process import
69	$count = $handler->save($assoc, $args);
70
71	// flush imported file
72	$this->delete($type);
73
74	// build response array
75	$response = array(
76	'count' => $count,
77	'total' => $handler->getTotalCount(),
78	);
79
80	// look for errors and copy them within model
81	foreach ($handler->getErrors() as $error)
82	{
83	$this->setError($error);
84	}
85
86	return $response;
87	}
88
89	/**
90	* Uploads an import file to manage the associations between
91	* the columns contained within the CSV and the properties
92	* of the database table.
93	*
94	* @param string $type The import type.
95	* @param array $csv The uploaded file.
96	*
97	* @return mixed The file path on success, false otherwise.
98	*/
99	public function upload($type, $csv)
100	{
101	if (!$type)
102	{
103	// missing type
104	return false;
105	}
106
107	// create new file name
108	$file_name = $type . '_' . $csv['name'];
109
110	// build path in which the files are stored
111	$path = VAPADMIN . DIRECTORY_SEPARATOR . 'helpers' . DIRECTORY_SEPARATOR . 'resources';
112	// append file name to path
113	$path .= DIRECTORY_SEPARATOR . $file_name;
114
115	/**
116	* Added support for the following MIME types:
117	* - text/plain (.txt)
118	* - application/vnd.ms-excel (.csv on Windows)
119	*
120	* @since 1.6.3
121	* @since 1.7 The filtering is now applied to the file name.
122	*/
123	// $filters = 'text/csv,text/plain,application/vnd.ms-excel';
124	$filters = 'csv';
125
126	// upload import file
127	$resp = VikAppointments::uploadFile($csv, $path, $filters, $overwrite = true);
128
129	if (!$resp->status)
130	{
131	// unable to upload the image, abort
132	$this->setError(JText::translate($resp->errno == 1 ? 'VAPCONFIGUPLOADERROR' : 'VAPCONFIGFILETYPEERROR'));
133
134	return false;
135	}
136
137	// upload went fine
138	return $resp->path;
139	}
140
141	/**
142	* Method to delete the uploaded import file.
143	*
144	* @param string $type The import type.
145	*
146	* @return boolean True on success.
147	*/
148	public function delete($type = null)
149	{
150	if (!$type)
151	{
152	// missing type
153	return false;
154	}
155
156	// build path in which the import files are uploaded
157	$folder = VAPADMIN . DIRECTORY_SEPARATOR . 'helpers' . DIRECTORY_SEPARATOR . 'resources' . DIRECTORY_SEPARATOR;
158
159	// get all files that starts with the provided type: [TYPE]_*.csv
160	$files = glob($folder . $type . '_*.csv');
161
162	$res = false;
163
164	// delete one by one
165	foreach ($files as $file)
166	{
167	$res = unlink($file) \|\| $res;
168	}
169
170	return $res;
171	}
172	}
173