Passed
Push — master ( e77a36...98ef57 )
by Brian
09:30
created

wpinv_check_for_missing_tables()   A

Complexity

Conditions 5
Paths 4

Size

Total Lines 29
Code Lines 18

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 5
eloc 18
c 0
b 0
f 0
nc 4
nop 0
dl 0
loc 29
rs 9.3554
1
<?php
2
/**
3
 * Contains functions related to Invoicing plugin.
4
 *
5
 * @since 1.0.0
6
 * @package Invoicing
7
 */
8
 
9
// MUST have WordPress.
10
if ( !defined( 'WPINC' ) ) {
11
    exit( 'Do NOT access this file directly: ' . basename( __FILE__ ) );
12
}
13
14
function wpinv_bulk_actions( $actions ) {
15
    if ( isset( $actions['edit'] ) ) {
16
        unset( $actions['edit'] );
17
    }
18
19
    return $actions;
20
}
21
add_filter( 'bulk_actions-edit-wpi_invoice', 'wpinv_bulk_actions' );
22
add_filter( 'bulk_actions-edit-wpi_item', 'wpinv_bulk_actions' );
23
24
function wpinv_admin_post_id( $id = 0 ) {
25
    global $post;
26
27
    if ( isset( $id ) && ! empty( $id ) ) {
28
        return (int)$id;
29
    } else if ( get_the_ID() ) {
30
        return (int) get_the_ID();
31
    } else if ( isset( $post->ID ) && !empty( $post->ID ) ) {
32
        return (int) $post->ID;
33
    } else if ( isset( $_GET['post'] ) && !empty( $_GET['post'] ) ) {
34
        return (int) $_GET['post'];
35
    } else if ( isset( $_GET['id'] ) && !empty( $_GET['id'] ) ) {
36
        return (int) $_GET['id'];
37
    } else if ( isset( $_POST['id'] ) && !empty( $_POST['id'] ) ) {
38
        return (int) $_POST['id'];
39
    } 
40
41
    return null;
42
}
43
    
44
function wpinv_admin_post_type( $id = 0 ) {
45
    if ( !$id ) {
46
        $id = wpinv_admin_post_id();
47
    }
48
    
49
    $type = get_post_type( $id );
50
    
51
    if ( !$type ) {
52
        $type = isset( $_GET['post_type'] ) && !empty( $_GET['post_type'] ) ? $_GET['post_type'] : null;
53
    }
54
    
55
    return apply_filters( 'wpinv_admin_post_type', $type, $id );
56
}
57
58
function wpinv_admin_messages() {
59
	settings_errors( 'wpinv-notices' );
60
}
61
add_action( 'admin_notices', 'wpinv_admin_messages' );
62
63
add_action( 'admin_init', 'wpinv_show_test_payment_gateway_notice' );
64
function wpinv_show_test_payment_gateway_notice(){
65
    add_action( 'admin_notices', 'wpinv_test_payment_gateway_messages' );
66
}
67
68
function wpinv_test_payment_gateway_messages(){
69
    $gateways = wpinv_get_enabled_payment_gateways();
70
    $name = array(); $test_gateways = '';
71
    if ($gateways) {
72
        foreach ($gateways as $id => $gateway) {
73
            if (wpinv_is_test_mode($id)) {
74
                $name[] = $gateway['checkout_label'];
75
            }
76
        }
77
        $test_gateways = implode(', ', $name);
78
    }
79
    if(isset($test_gateways) && !empty($test_gateways)){
80
        $link = admin_url('admin.php?page=wpinv-settings&tab=gateways');
81
        $notice = wp_sprintf( __('<strong>Important:</strong> Payment Gateway(s) %s are in testing mode and will not receive real payments. Go to <a href="%s"> Gateway Settings</a>.', 'invoicing'), $test_gateways, $link );
82
        ?>
83
        <div class="notice notice-warning is-dismissible">
84
            <p><?php echo $notice; ?></p>
85
        </div>
86
        <?php
87
    }
88
}
89
90
/**
91
 * Checks if all tables are available,
92
 * and alerts the user for any missing tables.
93
 */
94
function wpinv_check_for_missing_tables() {
95
    global $wpdb;
96
97
    // Only do this on our settings page.
98
    if ( empty( $_GET[ 'page' ] ) || 'wpinv-settings' !== $_GET[ 'page' ] ) {
99
        return;
100
    }
101
102
    // Check tables.
103
    $tables             = array(
104
        "{$wpdb->prefix}wpinv_subscriptions",
105
        "{$wpdb->prefix}getpaid_invoices",
106
        "{$wpdb->prefix}getpaid_invoice_items",
107
    );
108
109
    foreach ( $tables as $table ) {
110
        if ( $table != $wpdb->get_var( "SHOW TABLES LIKE '$table'" ) ) {
111
112
            $url     = esc_url(
113
                wp_nonce_url(
114
                    add_query_arg( 'getpaid-admin-action', 'create_missing_tables' ),
115
                    'getpaid-nonce',
116
                    'getpaid-nonce'
117
                )
118
            );
119
            $message  = __( 'Some GetPaid database tables are missing. To use GetPaid without any issues, click on the button below to create the missing tables.', 'invoicing' );
120
            $message2 = __( 'Create Tables', 'invoicing' );
121
            echo "<div class='notice notice-warning is-dismissible'><p>$message<br><br><a href='$url' class='button button-primary'>$message2</a></p></div>";
122
            break;
123
124
        }
125
    }
126
127
}
128
add_action( 'admin_notices', 'wpinv_check_for_missing_tables' );
129
130
add_action('admin_init', 'wpinv_admin_search_by_invoice');
131
132
/**
133
 * hook the posts search if we're on the admin page for our type
134
 */
135
function wpinv_admin_search_by_invoice() {
136
    global $typenow;
137
138
    if ($typenow === 'wpi_invoice' || $typenow === 'wpi_quote' ) {
139
        add_filter('posts_search', 'wpinv_posts_search_example_type', 10, 2);
140
    }
141
}
142
143
/**
144
 * add query condition for search invoice by email
145
 * @param string $search the search string so far
146
 * @param WP_Query $query
147
 * @return string
148
 */
149
function wpinv_posts_search_example_type($search, $query) {
150
    global $wpdb;
151
152
    if ($query->is_main_query() && !empty($query->query['s'])) {
153
        $conditions_str = "{$wpdb->posts}.post_author IN ( SELECT ID FROM {$wpdb->users} WHERE user_email LIKE '%" . esc_sql( $query->query['s'] ) . "%' )";
0 ignored issues
show
Bug introduced by
Are you sure esc_sql($query->query['s']) of type array|string can be used in concatenation? ( Ignorable by Annotation )

If this is a false-positive, you can also ignore this issue in your code via the ignore-type  annotation

153
        $conditions_str = "{$wpdb->posts}.post_author IN ( SELECT ID FROM {$wpdb->users} WHERE user_email LIKE '%" . /** @scrutinizer ignore-type */ esc_sql( $query->query['s'] ) . "%' )";
Loading history...
154
        if ( ! empty( $search ) ) {
155
            $search = preg_replace( '/^ AND /', '', $search );
156
            $search = " AND ( {$search} OR ( {$conditions_str} ) )";
157
        } else {
158
            $search = " AND ( {$conditions_str} )";
159
        }
160
    }
161
162
    return $search;
163
}
164
165
/**
166
 * Resets invoice counts.
167
 */
168
function wpinv_reset_invoice_count(){
169
    if ( ! empty( $_GET['reset_invoice_count'] ) && isset( $_GET['_nonce'] ) && wp_verify_nonce( $_GET['_nonce'], 'reset_invoice_count' ) ) {
170
        wpinv_update_option('invoice_sequence_start', 1);
171
        delete_option('wpinv_last_invoice_number');
172
        getpaid_admin()->show_success( __( 'Invoice number sequence reset successfully.', 'invoicing' ) );
173
        $url = remove_query_arg( array('reset_invoice_count', '_nonce') );
174
        wp_redirect($url);
175
        exit();
0 ignored issues
show
Best Practice introduced by
Using exit here is not recommended.

In general, usage of exit should be done with care and only when running in a scripting context like a CLI script.

Loading history...
176
    }
177
}
178
add_action( 'admin_init', 'wpinv_reset_invoice_count' );