← All changes | back/Views/Users/tmpl/ajaxencoding.php +0 -279 11.0.1 → 11.1.1 View file →

		@@ -1,279 +1,0 @@
1		-<?php
2		-// phpcs:disable WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedVariableFound -- View file, its variables are local to the include scope, not true globals.
3		-defined('ABSPATH') || die('Restricted Access');
4		-
5		-use AcyMailing\Classes\FieldClass;
6		-use AcyMailing\Classes\UserClass;
7		-use AcyMailing\Helpers\EncodingHelper;
8		-
9		-$encodingHelper = new EncodingHelper();
10		-$fieldClass = new FieldClass();
11		-$userClass = new UserClass();
12		-$filename = strtolower(acym_getVar('cmd', 'acym_import_filename', ''));
13		-$encoding = acym_getVar('cmd', 'encoding');
14		-
15		-$extension = '.'.acym_fileGetExt($filename);
16		-$uploadPath = ACYM_MEDIA.'import'.DS.str_replace(['.', ' '], '_', substr($filename, 0, strpos($filename, $extension))).$extension;
17		-
18		-if (!file_exists($uploadPath)) {
19		- acym_display(acym_translationSprintf('ACYM_FAIL_OPEN', '<b><i>'.esc_html($uploadPath).'</i></b>'), 'error');
20		-
21		- return;
22		-}
23		-
24		-$this->content = file_get_contents($uploadPath);
25		-
26		-if (empty($encoding)) {
27		- $encoding = $encodingHelper->detectEncoding($this->content);
28		-}
29		-
30		-$content = $encodingHelper->change($this->content, $encoding, 'UTF-8');
31		-
32		-
33		-// Get the lines in an array
34		-$content = str_replace(["\r\n", "\r"], "\n", $content);
35		-$this->lines = explode("\n", $content);
36		-
37		-// Get the right separator
38		-$this->separator = ',';
39		-$listSeparators = ["\t", ';', ','];
40		-foreach ($listSeparators as $sep) {
41		- if (strpos($this->lines[0], $sep) !== false) {
42		- $this->separator = $sep;
43		- break;
44		- }
45		-}
46		-
47		-$nbPreviewLines = 0;
48		-$i = 0;
49		-$data = [];
50		-
51		-while (isset($this->lines[$i])) {
52		- // If empty line, unset it, else count it as line to import (we will display only the 10 first lines to import)
53		- if (empty($this->lines[$i])) {
54		- unset($this->lines[$i]);
55		- continue;
56		- } else {
57		- $nbPreviewLines++;
58		- }
59		-
60		- // If there is a ", the line could be broken as there could be a return line in a value to import
61		- if (strpos($this->lines[$i], '"') !== false) {
62		- $data[$i] = [];
63		- $j = $i + 1;
64		- $position = -1;
65		-
66		- // Concatenate 30 lines max
67		- while ($j < ($i + 30)) {
68		- // Test if the value is encapsulated by quotes
69		- $quoteOpened = substr($this->lines[$i], $position + 1, 1) == '"';
70		-
71		- // If encapsulated, search the end of the value
72		- if ($quoteOpened) {
73		- $nextQuotePosition = strpos($this->lines[$i], '"', $position + 2);
74		-
75		- // If we didn't find the whole value, then concatenate the current line with the next one
76		- if ($nextQuotePosition === false) {
77		- // If end of import file, error...
78		- if (!isset($this->lines[$j])) {
79		- break;
80		- }
81		-
82		- // Take the right charset
83		- $this->lines[$i] .= "\n".rtrim($this->lines[$j], $this->separator);
84		- unset($this->lines[$j]);
85		- $j++;
86		- continue;
87		- } else {
88		- // Found the entire value, add it to data and move the position
89		- $quoteOpened = false;
90		-
91		- // If the line is completed
92		- if (strlen($this->lines[$i]) - 1 == $nextQuotePosition) {
93		- $data[$i][] = substr($this->lines[$i], $position + 1);
94		- break;
95		- }
96		-
97		- $data[$i][] = substr($this->lines[$i], $position + 1, $nextQuotePosition + 1 - ($position + 1));
98		- $position = $nextQuotePosition + 1;
99		- }
100		- } else {
101		- // If not encapsulated by quotes, search the next separator
102		- $nextSeparatorPosition = strpos($this->lines[$i], $this->separator, $position + 1);
103		- // If not found, the line is completed
104		- if ($nextSeparatorPosition === false) {
105		- $data[$i][] = substr($this->lines[$i], $position + 1);
106		- break;
107		- } else {
108		- // If found the next separator, add the value in $data[$i] and change the position
109		- $data[$i][] = substr($this->lines[$i], $position + 1, $nextSeparatorPosition - ($position + 1));
110		- $position = $nextSeparatorPosition;
111		- }
112		- }
113		- }
114		-
115		- // We unset some lines, don't forget to change the remaining lines keys
116		- $this->lines = array_merge($this->lines);
117		- } else {
118		- $data[$i] = explode($this->separator, rtrim(trim($this->lines[$i]), $this->separator));
119		- }
120		-
121		- // We display only the first ten lines
122		- if ($nbPreviewLines == 10) {
123		- break;
124		- }
125		-
126		- if ($nbPreviewLines != 1) {
127		- $i++;
128		- continue;
129		- }
130		-
131		- // If it's the first line, check if there is an header or not
132		- if (strpos($this->lines[$i], '@')) {
133		- $noHeader = 1;
134		- } else {
135		- $noHeader = 0;
136		- }
137		-
138		- // Get the column names and count them
139		- $columnNames = explode($this->separator, $this->lines[$i]);
140		- $nbColumns = count($columnNames);
141		- if (!empty($i)) {
142		- unset($this->lines[$i]);
143		- }
144		- ksort($this->lines);
145		-}
146		-
147		-$this->lines = $data;
148		-$nbLines = count($this->lines);
149		-
150		-?>
151		-<div class="table-scroll">
152		- <table cellspacing="10" cellpadding="10" id="importdata" class="unstriped">
153		- <?php
154		- if ($noHeader || !isset($this->lines[1])) {
155		- $firstValueLine = $columnNames;
156		- } else {
157		- $firstValueLine = $this->lines[1];
158		- foreach ($firstValueLine as &$oneValue) {
159		- $oneValue = trim($oneValue, '\'" ');
160		- }
161		- }
162		-
163		- // Possible values for columns imported as new custom field
164		- $fieldAssignment = [];
165		-
166		- $fieldAssignment[] = acym_selectOption('0', 'ACYM_IGNORED');
167		- $separator = acym_selectOption('3', '----------------------');
168		- $separator->disable = true;
169		- $fieldAssignment[] = $separator;
170		-
171		-
172		- // This variable will be used to re-assign columns when we change the encoding option
173		- $fields = $userClass->getAllColumnsUserAndCustomField(false, true);
174		- if (acym_isAdmin()) {
175		- $fields['listids'] = 'listids';
176		- $fields['listname'] = 'listname';
177		- }
178		-
179		- $cleanFields = [];
180		- foreach ($fields as $value => $label) {
181		- if (in_array($value, ['id', 'automation'])) {
182		- continue;
183		- }
184		-
185		- if (is_numeric($value)) {
186		- $field = $fieldClass->getOneById($value);
187		-
188		- $value = 'cf_'.$value;
189		- $fieldAssignment[] = acym_selectOption($value, $label);
190		-
191		- $cleanFields[$value] = empty($field) ? strtolower($label) : $field->namekey;
192		- } else {
193		- $fieldAssignment[] = acym_selectOption($value, $label);
194		- $cleanFields[$value] = strtolower($label);
195		- }
196		- }
197		-
198		- // Add first line to assign the imported columns, also add a button to ignore all unassigned columns if there are at least 6 columns
199		- echo '<tr>';
200		-
201		- // Don't auto-assign two times the same column
202		- $alreadyFound = [];
203		-
204		- foreach ($columnNames as $key => $oneColumn) {
205		- $columnNames[$key] = strtolower(trim($columnNames[$key], '\'" '));
206		-
207		- $customValue = '';
208		-
209		- // If we assigned the column then changed the charset option (reloading the page), keep the assigned value
210		- $selectedField = acym_getVar('cmd', 'fieldAssignment'.$key, '');
211		-
212		- // Auto-detect the column assignment
213		- if (empty($selectedField) && $selectedField !== 0) {
214		- // If the column name matches one of the AcyMailing fields, take this field
215		- if (isset($cleanFields[$columnNames[$key]])) {
216		- $selectedField = $columnNames[$key];
217		- } elseif (in_array($columnNames[$key], $cleanFields)) {
218		- $selectedField = array_search(strtolower($columnNames[$key]), $cleanFields);
219		- } else {
220		- $selectedField = '0';
221		- }
222		-
223		- // Detect if it's the mail field, if there are only two columns and it isn't the email one, it is the name column
224		- if (!$selectedField && !empty($firstValueLine)) {
225		- if (isset($firstValueLine[$key]) && strpos($firstValueLine[$key], '@')) {
226		- $selectedField = 'email';
227		- } elseif ($nbColumns === 2) {
228		- $selectedField = 'name';
229		- }
230		- }
231		- if (in_array($selectedField, $alreadyFound)) {
232		- $selectedField = '0';
233		- }
234		- } elseif ($selectedField == 2) {
235		- // If custom field, fill in the input with the right value
236		- $customValue = acym_getVar('cmd', 'newcustom'.$key);
237		- }
238		-
239		- $alreadyFound[] = $selectedField;
240		-
241		- echo '<td valign="top">';
242		- acym_select(
243		- $fieldAssignment,
244		- 'fieldAssignment'.$key,
245		- $selectedField,
246		- ['class' => 'fieldAssignment'],
247		- 'value',
248		- 'text',
249		- null,
250		- false,
251		- true
252		- );
253		- echo '<br />';
254		- }
255		- echo '</tr>';
256		-
257		- // If the first imported line is the header, display a line to show it...
258		- if (!$noHeader) {
259		- echo '<tr class="acym__users__import__generic__column_name">';
260		- foreach ($columnNames as $key => $oneColumn) {
261		- echo '<td><b>'.esc_html($oneColumn).'</b></td>';
262		- }
263		- echo '</tr>';
264		- }
265		-
266		- // For each imported line, display it so that the user can preview with the right encoding...
267		- for ($i = 1 - $noHeader; $i < 11 - $noHeader && $i < $nbLines; $i++) {
268		- $values = $this->lines[$i];
269		-
270		- echo '<tr>';
271		- foreach ($values as &$oneValue) {
272		- $oneValue = htmlspecialchars(trim($oneValue, '\'" '), ENT_COMPAT | ENT_IGNORE, 'UTF-8');
273		- echo '<td>'.esc_html(htmlspecialchars_decode($oneValue)).'</td>';
274		- }
275		- echo '</tr>';
276		- }
277		- ?>
278		- </table>
279		-</div>