csv_helper.php — LatePoint – Calendar Booking Plugin for Appointments and Events 5.2.9

latepoint / lib / helpers / csv_helper.php

latepoint / lib / helpers Last commit date

csv_helper.php

89 lines

1	<?php
2
3	class OsCSVHelper {
4	public static function array_to_csv( $data ) {
5	$output = fopen( "php://output", "wb" ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_read_fopen
6	foreach ( $data as $row ) {
7	fputcsv( $output, $row );
8	}
9	fclose( $output ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_fclose
10	}
11
12
13	public static function get_import_dir( bool $create = true ): string {
14	$wp_upload_dir = wp_upload_dir( null, $create );
15	if ( $wp_upload_dir['error'] ) {
16	throw new \Exception( esc_html( $wp_upload_dir['error'] ) );
17	}
18
19	$upload_dir = trailingslashit( $wp_upload_dir['basedir'] ) . 'latepoint';
20	if ( $create ) {
21	if ( ! file_exists( $upload_dir ) ) {
22	wp_mkdir_p( $upload_dir );
23	}
24	}
25	return $upload_dir;
26	}
27
28	public static function upload_csv_file($files, $file_name ) {
29	if(empty($files[$file_name])){
30	throw new \Exception('File not selected');
31	}
32
33
34	$file = $files[$file_name];
35
36	$upload_dir = OsCsvHelper::get_import_dir();
37	$tmp_name = uniqid('latepoint_customers_csv_') . '.csv';
38	$filepath = $upload_dir . '/' . $tmp_name;
39
40	if (!move_uploaded_file($file['tmp_name'][0], $filepath)) {
41	throw new \Exception('Error uploading file');
42	}
43	set_transient('csv_import_file_' . OsWpUserHelper::get_current_user_id(), $filepath, 3600);
44	return $filepath;
45	}
46
47
48	public static function is_valid_csv( $file_path ): bool {
49	$valid_filetypes = [
50	'csv' => 'text/csv',
51	'txt' => 'text/plain',
52	];
53
54	$filetype = wp_check_filetype( $file_path, $valid_filetypes );
55
56	if ( in_array( $filetype['type'], $valid_filetypes, true ) ) {
57	return true;
58	}
59
60	return false;
61	}
62
63	public static function get_csv_data( $file_path, $limit = false ) {
64	if (!file_exists($file_path)) {
65	throw new \Exception('File does not exist');
66	}
67
68	if (!OsCSVHelper::is_valid_csv($file_path)) {
69	throw new \Exception('Invalid file format');
70	}
71
72	$data = [];
73	$i = 0;
74	if (($handle = fopen($file_path, 'r')) !== false) {
75	while (($row = fgetcsv($handle)) !== false) {
76	$data[] = $row;
77	$i++;
78	if ($limit && $i >= $limit) {
79	break;
80	}
81	}
82	fclose($handle);
83	} else {
84	throw new \Exception('Error reading file');
85	}
86	return $data;
87	}
88
89	}