csv-table.php
3.69 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<?php
su_add_shortcode(
array(
'id' => 'csv_table',
'callback' => 'su_shortcode_csv_table',
'type' => 'single',
'name' => __( 'CSV Table', 'shortcodes-ultimate' ),
'desc' => __( 'Styled table from CSV file', 'shortcodes-ultimate' ),
'group' => 'content',
'image' => su_get_plugin_url() . 'admin/images/shortcodes/table.svg',
'icon' => 'table',
'atts' => array(
'url' => array(
'type' => 'upload',
'default' => '',
'name' => __( 'CSV file URL', 'shortcodes-ultimate' ),
'desc' => __( 'The URL of a CSV file that will be displayed', 'shortcodes-ultimate' ),
),
'delimiter' => array(
'type' => 'text',
'default' => ',',
'name' => __( 'Delimiter', 'shortcodes-ultimate' ),
'desc' => __( 'Set the field delimiter (one character only)', 'shortcodes-ultimate' ),
),
'header' => array(
'type' => 'bool',
'default' => 'no',
'name' => __( 'Display header', 'shortcodes-ultimate' ),
'desc' => __( 'Display first row as table header', 'shortcodes-ultimate' ),
),
'responsive' => array(
'type' => 'bool',
'default' => 'no',
'name' => __( 'Responsive', 'shortcodes-ultimate' ),
'desc' => __( 'Add horizontal scrollbar if table width larger than page width', 'shortcodes-ultimate' ),
),
'alternate' => array(
'type' => 'bool',
'default' => 'yes',
'name' => __( 'Alternate row color', 'shortcodes-ultimate' ),
'desc' => __( 'Enable to use alternative background color for even rows', 'shortcodes-ultimate' ),
),
'fixed' => array(
'type' => 'bool',
'default' => 'no',
'name' => __( 'Fixed layout', 'shortcodes-ultimate' ),
'desc' => __( 'Fixed width table cells', 'shortcodes-ultimate' ),
),
'class' => array(
'type' => 'extra_css_class',
'name' => __( 'Extra CSS class', 'shortcodes-ultimate' ),
'desc' => __( 'Additional CSS class name(s) separated by space(s)', 'shortcodes-ultimate' ),
'default' => '',
),
),
)
);
function su_shortcode_csv_table( $atts = null, $content = null ) {
$atts = shortcode_atts(
array(
'url' => '',
'delimiter' => ',',
'header' => 'no',
'responsive' => 'no',
'alternate' => 'yes',
'fixed' => 'no',
'class' => '',
),
$atts,
'table'
);
if ( ! su_is_unsafe_features_enabled() ) {
return su_error_message(
'CSV Table',
sprintf(
'%s.<br><a href="https://getshortcodes.com/docs/unsafe-features/" target="_blank">%s</a>',
__( 'This shortcode cannot be used while <b>Unsafe features</b> option is turned off', 'shortcodes-ultimate' ),
__( 'Learn more', 'shortcodes-ultimate' )
)
);
}
if ( filter_var( $atts['url'], FILTER_VALIDATE_URL ) === false ) {
return su_error_message( 'CSV Table', __( 'invalid URL', 'shortcodes-ultimate' ) );
}
$response = wp_safe_remote_get( $atts['url'] );
if ( 200 !== wp_remote_retrieve_response_code( $response ) ) {
return su_error_message( 'CSV Table', __( 'invalid URL', 'shortcodes-ultimate' ) );
}
if ( ! is_string( $atts['delimiter'] ) || 1 !== strlen( $atts['delimiter'] ) ) {
return su_error_message( 'CSV Table', __( 'invalid delimiter', 'shortcodes-ultimate' ) );
}
$csv = wp_remote_retrieve_body( $response );
$html = su_csv_to_html(
$csv,
$atts['delimiter'],
'yes' === $atts['header']
);
foreach ( array( 'responsive', 'alternate', 'fixed' ) as $feature ) {
if ( 'yes' === $atts[ $feature ] ) {
$atts['class'] .= ' su-table-' . $feature;
}
}
su_query_asset( 'css', 'su-shortcodes' );
return '<div class="su-table su-csv-table' . su_get_css_class( $atts ) . '">' . wp_kses_post( $html ) . '</div>';
}