← All changes | WPDataAccess/Plugin_Table_Models/WPDA_CSV_Uploads_Model.php +15 -15 5.5.76 → 5.5.85 View file →

		@@ -10,9 +10,9 @@
10	10	const BASE_TABLE_NAME = 'wpda_csv_uploads';
11	11
12	12	public static function query( $csv_id ) {
13	13	global $wpdb;
14		- return $wpdb->get_results(
	14	+ return $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
15	15	$wpdb->prepare(
16	16	'select * from `%1s` where csv_id = %d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
17	17	array(
18	18	WPDA::remove_backticks( static::get_base_table_name() ),
		@@ -23,15 +23,15 @@
23	23	}
24	24
25	25	public static function insert( $csv_name, $real_file_name, $orig_file_name, $csv_encoding = null ) {
26	26	global $wpdb;
27		- if ( 1 === $wpdb->insert(
	27	+ if ( 1 === $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- plugin table
28	28	static::get_base_table_name(),
29	29	array(
30	30	'csv_name' => $csv_name,
31	31	'csv_real_file_name' => $real_file_name,
32	32	'csv_orig_file_name' => $orig_file_name,
33		- 'csv_timestamp' => date( 'Y-m-d H:i:s' ),
	33	+ 'csv_timestamp' => gmdate( 'Y-m-d H:i:s' ),
34	34	'csv_encoding' => $csv_encoding,
35	35	)
36	36	)
37	37	) {
		@@ -42,14 +42,14 @@
42	42	}
43	43
44	44	public static function update( $csv_id, $real_file_name, $orig_file_name, $csv_encoding = null ) {
45	45	global $wpdb;
46		- return ( 1 === $wpdb->update(
	46	+ return ( 1 === $wpdb->update( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
47	47	static::get_base_table_name(),
48	48	array(
49	49	'csv_real_file_name' => $real_file_name,
50	50	'csv_orig_file_name' => $orig_file_name,
51		- 'csv_timestamp' => date( 'Y-m-d H:i:s' ),
	51	+ 'csv_timestamp' => gmdate( 'Y-m-d H:i:s' ),
52	52	'csv_encoding' => $csv_encoding,
53	53	),
54	54	array(
55	55	'csv_id' => $csv_id,
		@@ -83,9 +83,9 @@
83	83	);
84	84
85	85	global $wpdb;
86	86	$wpdb->suppress_errors( true );
87		- $rows_update = $wpdb->query(
	87	+ $rows_update = $wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
88	88	$wpdb->prepare(
89	89	'update `%1s` set csv_mapping = %s where csv_id = %d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
90	90	array(
91	91	WPDA::remove_backticks( static::get_base_table_name() ),
		@@ -94,9 +94,9 @@
94	94	)
95	95	)
96	96	);
97	97
98		- echo '' === $wpdb->last_error ? 'UPD-' . esc_attr( $rows_update ) : 'ERR-' . $wpdb->last_error; // phpcs:ignore WordPress.Security.EscapeOutput
	98	+ echo '' === $wpdb->last_error ? 'UPD-' . esc_attr( $rows_update ) : 'ERR-' . esc_attr( $wpdb->last_error );
99	99	}
100	100
101	101	public static function preview_mapping() {
102	102	header( 'Content-Type: text/plain; charset=utf-8' );
		@@ -125,9 +125,9 @@
125	125	$dbrow = self::query( $csv_id );
126	126
127	127	global $wpdb;
128	128	if ( '' !== $wpdb->last_error ) {
129		- echo 'ERR-' . $wpdb->last_error; // phpcs:ignore WordPress.Security.EscapeOutput
	129	+ echo 'ERR-' . esc_attr( $wpdb->last_error );
130	130	}
131	131	if ( 1 === $wpdb->num_rows ) {
132	132	if ( ! isset( $dbrow[0]->csv_real_file_name ) ) {
133	133	echo 'ERR-No file';
		@@ -134,10 +134,10 @@
134	134	} else {
135	135	$upload_dir = WPDA::get_plugin_upload_dir();
136	136	$file_name = $upload_dir . $dbrow[0]->csv_real_file_name;
137	137
138		- @ini_set( 'auto_detect_line_endings', true );
139		- if ( false !== ( $fp = fopen( $file_name, 'rb' ) ) ) {
	138	+ @ini_set( 'auto_detect_line_endings', true ); // phpcs:ignore
	139	+ if ( false !== ( $fp = fopen( $file_name, 'rb' ) ) ) { // phpcs:ignore
140	140	$mapping = isset( $dbrow[0]->csv_mapping ) ? json_decode( $dbrow[0]->csv_mapping, true ) : array();
141	141	$delimiter = isset( $mapping['settings']['delimiter'] ) ? $mapping['settings']['delimiter'] : ',';
142	142	$has_header_columns = isset( $mapping['settings']['has_header_columns'] ) ? $mapping['settings']['has_header_columns'] : true;
143	143
		@@ -167,11 +167,11 @@
167	167	$number_of_columns = 1;
168	168	if ( 'false' !== $has_header_columns ) {
169	169	echo '<thead>';
170	170	if ( false !== ( $data = fgetcsv( $fp, 0, $delimiter, '"' ) ) ) {
171		- $number_of_columns = count( $data );//phpcs:ignore - 8.1 proof
	171	+ $number_of_columns = count( $data ); // phpcs:ignore -- 8.1 proof
172	172	echo '<tr>';
173		- for ( $column = 0; $column < count( $data ); $column++ ) {//phpcs:ignore - 8.1 proof
	173	+ for ( $column = 0; $column < count( $data ); $column++ ) { // phpcs:ignore -- 8.1 proof
174	174	echo '<th>' . esc_attr( $data[$column] ) . '</th>';
175	175	}
176	176	echo '</tr>';
177	177	}
		@@ -183,9 +183,9 @@
183	183	echo '<tbody>';
184	184	while ( false !== ( $data = fgetcsv( $fp, 0, $delimiter, '"' ) ) ) {
185	185	if ( $row >= $start && $row < $end ) {
186	186	echo '<tr>';
187		- for ( $column = 0; $column < count( $data ); $column++ ) {//phpcs:ignore - 8.1 proof
	187	+ for ( $column = 0; $column < count( $data ); $column++ ) { // phpcs:ignore -- 8.1 proof
188	188	echo '<td>' . esc_attr( $data[$column] ) . '</td>';
189	189	}
190	190	echo '</tr>';
191	191	$fnd = true;
		@@ -193,14 +193,14 @@
193	193
194	194	$row++;
195	195	}
196	196	if ( ! $fnd ) {
197		- echo '<tr colspan="' . esc_attr( $number_of_columns ) . '"><td>' . __( 'No data found', 'wp-data-access' ) . '</td></tr>';
	197	+ echo '<tr colspan="' . esc_attr( $number_of_columns ) . '"><td>' . esc_attr__( 'No data found', 'wp-data-access' ) . '</td></tr>';
198	198	}
199	199	echo '</tbody>';
200	200	echo '</table>';
201	201
202		- fclose( $fp );
	202	+ fclose( $fp ); // phpcs:ignore
203	203	} else {
204	204	echo 'ERR-File not found';
205	205	}
206	206	}