WordPress.org
Get WordPress

Plugin Directory

Changeset 3278341


Ignore:
Timestamp:
04/21/2025 04:52:06 PM (12 months ago)
Author:
jrmoser
Message:

version 1.1.3

Location:
box-tracker-portal
Files:
18 edited
1 copied

Legend:

Unmodified
Added
Removed

  • box-tracker-portal/tags/1.1.3/trunk/box-tracker-portal.php

    r3247414 r3278341  
    88Plugin URI: https://www.dumpster.software/api/word-press-plugin.html
    99Description: The Box Tracker Portal plugin facilitates online ordering for waste haulers. Customers will be able to book and manage work orders, manage job sites, view reporting and manage their transactions.  Using the Web API tab on Box Tracker's Preferences app, you can prevent over booking, control which days of the week online orders will be accepted, and prevent same day ordering.  For more information about Box Tracker or this plugin please contact support at 603 546 6751 option 2 or support@cairnapps.com
    10 Version: 1.1.3
     10Version: 1.1.2
    1111Author: Cairn Applications Inc
    1212Author URI: https://www.cloud-computing.rocks/

  • box-tracker-portal/tags/1.1.3/trunk/includes/ajax/ccard-page.php

    r3247411 r3278341  
    3838
    3939            //we need a list of states
    40             $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_all_states();
     40            $b0xTPortal_states_args = array(
     41                "command"              => "cmdBoxTPortalStateList",
     42                "session_key_api"      => $b0xTPortal_session_key_api,
     43                "username_customer"    => $b0xTPortal_username,
     44                "session_key_customer" => $b0xTPortal_session_key_customer,
     45                "customer_id"          => $b0xTPortal_customer_id
     46            );
     47
     48            $b0xTPortal_list_of_state = array();
     49            $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     50
     51            if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     52                $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     53            } else {
     54                $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     55                wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     56            }
    4157
    4258            if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/tags/1.1.3/trunk/includes/ajax/jobsite-page.php

    r2924835 r3278341  
    134134                $b0xTPortal_jobsite_state   = sanitize_text_field($b0xTPortal_jobsite_data->jobSiteObj->State);
    135135
    136                 $b0xTPortal_country_id    = sanitize_text_field(get_option('b0xTPortal_admin_country'));
    137                 $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_states($b0xTPortal_country_id);
     136                $b0xTPortal_country_id = sanitize_text_field(get_option('b0xTPortal_admin_country'));
     137                $b0xTPortal_country_id = ($b0xTPortal_country_id == "Canada") ? "CAN" : "USA";
     138 
     139                $b0xTPortal_states_args = array(
     140                    "command"              => "cmdBoxTPortalStateList",
     141                    "session_key_api"      => $b0xTPortal_session_key_api,
     142                    "username_customer"    => $b0xTPortal_username,
     143                    "session_key_customer" => $b0xTPortal_session_key_customer,
     144                    "customer_id"          => $b0xTPortal_customer_id,
     145                    "country"              => $b0xTPortal_country_id
     146                );
     147
     148                $b0xTPortal_list_of_state = array();
     149                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     150
     151                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     152                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     153                } else {
     154                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     155                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     156                }
    138157
    139158                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/tags/1.1.3/trunk/includes/ajax/payment-page.php

    r3247411 r3278341  
    5454
    5555                //we need a list of states
    56                 $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_all_states();
     56                $b0xTPortal_states_args = array(
     57                    "command"              => "cmdBoxTPortalStateList",
     58                    "session_key_api"      => $b0xTPortal_session_key_api,
     59                    "username_customer"    => $b0xTPortal_username,
     60                    "session_key_customer" => $b0xTPortal_session_key_customer,
     61                    "customer_id"          => $b0xTPortal_customer_id
     62                );
     63
     64                $b0xTPortal_list_of_state = array();
     65                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     66
     67                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     68                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     69                } else {
     70                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     71                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     72                }
    5773
    5874                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/tags/1.1.3/trunk/includes/ajax/profile-page.php

    r3247411 r3278341  
    4949
    5050                //we need a list of states
    51                 $b0xTPortal_country_id    = sanitize_text_field(get_option('b0xTPortal_admin_country'));
    52                 $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_states($b0xTPortal_country_id);
     51                $b0xTPortal_country_id = sanitize_text_field(get_option('b0xTPortal_admin_country'));
     52                $b0xTPortal_country_id = ($b0xTPortal_country_id == "Canada") ? "CAN" : "USA";
     53 
     54                $b0xTPortal_states_args = array(
     55                    "command"              => "cmdBoxTPortalStateList",
     56                    "session_key_api"      => $b0xTPortal_session_key_api,
     57                    "username_customer"    => $b0xTPortal_username,
     58                    "session_key_customer" => $b0xTPortal_session_key_customer,
     59                    "customer_id"          => $b0xTPortal_customer_id,
     60                    "country"              => $b0xTPortal_country_id
     61                );
     62
     63                $b0xTPortal_list_of_state = array();
     64                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     65
     66                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     67                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     68                } else {
     69                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     70                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     71                }
    5372
    5473                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/tags/1.1.3/trunk/includes/ajax/workorder-page.php

    r2924835 r3278341  
    151151
    152152                $b0xTPortal_country_id                = sanitize_text_field(get_option('b0xTPortal_admin_country'));
    153                 $b0xTPortal_list_of_state             = $this->b0xTPortal_server_calls->b0xTPortal_get_states($b0xTPortal_country_id);
     153                $b0xTPortal_country_id = ($b0xTPortal_country_id == "Canada") ? "CAN" : "USA";
     154 
     155                $b0xTPortal_states_args = array(
     156                    "command"              => "cmdBoxTPortalStateList",
     157                    "session_key_api"      => $b0xTPortal_session_key_api,
     158                    "username_customer"    => $b0xTPortal_username,
     159                    "session_key_customer" => $b0xTPortal_session_key_customer,
     160                    "customer_id"          => $b0xTPortal_customer_id,
     161                    "country"              => $b0xTPortal_country_id
     162                );
     163
     164                $b0xTPortal_list_of_state = array();
     165                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     166
     167                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     168                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     169                } else {
     170                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     171                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     172                }
    154173
    155174                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/tags/1.1.3/trunk/includes/base/activate.php

    r2763253 r3278341  
    1212    public static function b0xTPortal_activate() {
    1313        flush_rewrite_rules();
    14         self::b0xTPortal_create_states_table();
    15     }
    16 
    17     /**
    18      * This function will create the states table
    19      * which will be used to populate some of the
    20      * fields on the form.
    21      *
    22      */
    23     private static function b0xTPortal_create_states_table() {
    24         global $wpdb;
    25         $b0xTPortal_table_name = $wpdb->prefix.'b0xTPortal_states';
    26         $b0xTPortal_charset_collate = $wpdb->get_charset_collate();
    27 
    28         $b0xTPortal_table_exist = $wpdb->prepare('SHOW TABLES LIKE %s', $wpdb->esc_like($b0xTPortal_table_name));       
    29 
    30         if($wpdb->get_var($b0xTPortal_table_exist) === $b0xTPortal_table_name) {
    31             $b0xTPortal_query_drop_table = "DROP TABLE $b0xTPortal_table_name";
    32             $wpdb->query($b0xTPortal_query_drop_table);
    33         }
    34 
    35         //create the table
    36         $b0xTPortal_query_create_table = "CREATE TABLE $b0xTPortal_table_name (
    37             `state_id` int(5) NOT NULL AUTO_INCREMENT,
    38             `state_name` varchar(40) NOT NULL,
    39             `state_short` varchar(10) NOT NULL,
    40             `country_id` varchar(10) NOT NULL,
    41             PRIMARY  KEY (`state_id`)
    42         ) $b0xTPortal_charset_collate;";   
    43 
    44         //insert some values.
    45         $b0xTPortal_query_insert_values = "INSERT INTO $b0xTPortal_table_name (`state_id`, `state_name`, `state_short`, `country_id`) VALUES (1, 'Alabama', 'AL', 'USA'), (2, 'Alaska', 'AK', 'USA'), (3, 'Arizona', 'AZ', 'USA'), (4, 'Arkansas', 'AR', 'USA'), (5, 'California', 'CA', 'USA'), (6, 'Colorado', 'CO', 'USA'), (7, 'Connecticut', 'CT', 'USA'), (8, 'Delaware', 'DE', 'USA'), (9, 'Florida', 'FL', 'USA'), (10, 'Georgia', 'GA', 'USA'), (11, 'Hawaii', 'HI', 'USA'), (12, 'Idaho', 'ID', 'USA'), (13, 'Illinois', 'IL', 'USA'), (14, 'Indiana', 'IN', 'USA'), (15, 'Iowa', 'IA', 'USA'), (16, 'Kansas', 'KS', 'USA'), (17, 'Kentucky', 'KY', 'USA'), (18, 'Louisiana', 'LA', 'USA'), (19, 'Maine', 'ME', 'USA'), (20, 'Maryland', 'MD', 'USA'), (21, 'Massachusetts', 'MA', 'USA'), (22, 'Michigan', 'MI', 'USA'), (23, 'Minnesota', 'MN', 'USA'), (24, 'Mississippi', 'MS', 'USA'), (25, 'Missouri', 'MO', 'USA'), (26, 'Montana', 'MT', 'USA'), (27, 'Nebraska', 'NE', 'USA'), (28, 'Nevada', 'NV', 'USA'), (29, 'New Hampshire', 'NH', 'USA'), (30, 'New Jersey', 'NJ', 'USA'), (31, 'New Mexico', 'NM', 'USA'), (32, 'New York', 'NY', 'USA'), (33, 'North Carolina', 'NC', 'USA'), (34, 'North Dakota', 'ND', 'USA'), (35, 'Ohio', 'OH', 'USA'), (36, 'Oklahoma', 'OK', 'USA'), (37, 'Oregon', 'OR', 'USA'), (38, 'Pennsylvania', 'PA', 'USA'), (39, 'Rhode Island', 'RI', 'USA'), (40, 'South Carolina', 'SC', 'USA'), (41, 'South Dakota', 'SD', 'USA'), (42, 'Tennessee', 'TN', 'USA'), (43, 'Texas', 'TX', 'USA'), (44, 'Utah', 'UT', 'USA'), (45, 'Vermont', 'VT', 'USA'), (46, 'Virginia', 'VA', 'USA'), (47, 'Washington', 'WA', 'USA'), (48, 'West Virginia', 'WV', 'USA'), (49, 'Wisconsin', 'WI', 'USA'), (50, 'Wyoming', 'WY', 'USA'), (51, 'Alberta', 'AB', 'CAN'), (52, 'British Columbia', 'BC', 'CAN'), (53, 'Manitoba', 'MB', 'CAN'), (54, 'New Brunswick', 'NB', 'CAN'), (55, 'Newfoundland', 'NL', 'CAN'), (56, 'Northwest Territories', 'NT', 'CAN'), (57, 'Nova Scotia', 'NS', 'CAN'), (58, 'Nunavut', 'NU', 'CAN'), (59, 'Ontario', 'ON', 'CAN'), (60, 'Prince Edward Island', 'PE', 'CAN'), (61, 'Quebec', 'QC', 'CAN'), (62, 'Saskatchewan', 'SK', 'CAN'), (63, 'Yukon', 'YT', 'CAN')";
    46 
    47         require_once(ABSPATH.'wp-admin/includes/upgrade.php');
    48         dbDelta($b0xTPortal_query_create_table);
    49         dbDelta($b0xTPortal_query_insert_values);
    5014    }
    5115}

  • box-tracker-portal/tags/1.1.3/trunk/includes/base/server-calls.php

    r2763253 r3278341  
    9191     }
    9292
    93     /**
    94      * Get a list of states
    95      *
    96      * @param string $b0xTPortal_country_id
    97      * @return string
    98      */
    99     function b0xTPortal_get_states($b0xTPortal_country_id) {
    100         $b0xTPortal_country_id = sanitize_text_field($b0xTPortal_country_id);
    101 
    102         global $wpdb;
    103         if($b0xTPortal_country_id == "Canada"){
    104              $b0xTPortal_country_id = 'CAN';
    105         } else {
    106              $b0xTPortal_country_id = 'USA';
    107         }
    108        
    109         $b0xTPortal_output = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."b0xTPortal_states WHERE country_id = '".$b0xTPortal_country_id."'");
    110 
    111         if(!is_array($b0xTPortal_output)) { return null; }
    112         return $this->b0xTPortal_sanitize_array_values($b0xTPortal_output);
    113     }
    114 
    115     /**
    116      * Get a list of states
    117      *
    118      * @return string
    119      */
    120     function b0xTPortal_get_all_states() {
    121         global $wpdb;
    122         $b0xTPortal_output = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."b0xTPortal_states");
    123         if(!is_array($b0xTPortal_output)) { return null; }
    124         return $this->b0xTPortal_sanitize_array_values($b0xTPortal_output);
    125     }
    126 
    12793    /*
    12894     * redefining these helper functions here, so that i dont

  • box-tracker-portal/tags/1.1.3/trunk/readme.txt

    r3247414 r3278341  
    33Requires at least: 4.9
    44Requires PHP: 5.6.4
    5 Tested up to: 6.7.2
    6 Stable tag: 1.1.3
     5Tested up to: 6.8
     6Stable tag: 1.1.2
    77License: GPLv2 or later
    88License URI: http://www.gnu.org/licenses/gpl-2.0.html

  • box-tracker-portal/trunk/box-tracker-portal.php

    r3247414 r3278341  
    88Plugin URI: https://www.dumpster.software/api/word-press-plugin.html
    99Description: The Box Tracker Portal plugin facilitates online ordering for waste haulers. Customers will be able to book and manage work orders, manage job sites, view reporting and manage their transactions.  Using the Web API tab on Box Tracker's Preferences app, you can prevent over booking, control which days of the week online orders will be accepted, and prevent same day ordering.  For more information about Box Tracker or this plugin please contact support at 603 546 6751 option 2 or support@cairnapps.com
    10 Version: 1.1.3
     10Version: 1.1.2
    1111Author: Cairn Applications Inc
    1212Author URI: https://www.cloud-computing.rocks/

  • box-tracker-portal/trunk/includes/ajax/ccard-page.php

    r3247411 r3278341  
    3838
    3939            //we need a list of states
    40             $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_all_states();
     40            $b0xTPortal_states_args = array(
     41                "command"              => "cmdBoxTPortalStateList",
     42                "session_key_api"      => $b0xTPortal_session_key_api,
     43                "username_customer"    => $b0xTPortal_username,
     44                "session_key_customer" => $b0xTPortal_session_key_customer,
     45                "customer_id"          => $b0xTPortal_customer_id
     46            );
     47
     48            $b0xTPortal_list_of_state = array();
     49            $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     50
     51            if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     52                $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     53            } else {
     54                $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     55                wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     56            }
    4157
    4258            if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/trunk/includes/ajax/jobsite-page.php

    r2924835 r3278341  
    134134                $b0xTPortal_jobsite_state   = sanitize_text_field($b0xTPortal_jobsite_data->jobSiteObj->State);
    135135
    136                 $b0xTPortal_country_id    = sanitize_text_field(get_option('b0xTPortal_admin_country'));
    137                 $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_states($b0xTPortal_country_id);
     136                $b0xTPortal_country_id = sanitize_text_field(get_option('b0xTPortal_admin_country'));
     137                $b0xTPortal_country_id = ($b0xTPortal_country_id == "Canada") ? "CAN" : "USA";
     138 
     139                $b0xTPortal_states_args = array(
     140                    "command"              => "cmdBoxTPortalStateList",
     141                    "session_key_api"      => $b0xTPortal_session_key_api,
     142                    "username_customer"    => $b0xTPortal_username,
     143                    "session_key_customer" => $b0xTPortal_session_key_customer,
     144                    "customer_id"          => $b0xTPortal_customer_id,
     145                    "country"              => $b0xTPortal_country_id
     146                );
     147
     148                $b0xTPortal_list_of_state = array();
     149                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     150
     151                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     152                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     153                } else {
     154                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     155                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     156                }
    138157
    139158                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/trunk/includes/ajax/payment-page.php

    r3247411 r3278341  
    5454
    5555                //we need a list of states
    56                 $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_all_states();
     56                $b0xTPortal_states_args = array(
     57                    "command"              => "cmdBoxTPortalStateList",
     58                    "session_key_api"      => $b0xTPortal_session_key_api,
     59                    "username_customer"    => $b0xTPortal_username,
     60                    "session_key_customer" => $b0xTPortal_session_key_customer,
     61                    "customer_id"          => $b0xTPortal_customer_id
     62                );
     63
     64                $b0xTPortal_list_of_state = array();
     65                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     66
     67                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     68                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     69                } else {
     70                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     71                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     72                }
    5773
    5874                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/trunk/includes/ajax/profile-page.php

    r3247411 r3278341  
    4949
    5050                //we need a list of states
    51                 $b0xTPortal_country_id    = sanitize_text_field(get_option('b0xTPortal_admin_country'));
    52                 $b0xTPortal_list_of_state = $this->b0xTPortal_server_calls->b0xTPortal_get_states($b0xTPortal_country_id);
     51                $b0xTPortal_country_id = sanitize_text_field(get_option('b0xTPortal_admin_country'));
     52                $b0xTPortal_country_id = ($b0xTPortal_country_id == "Canada") ? "CAN" : "USA";
     53 
     54                $b0xTPortal_states_args = array(
     55                    "command"              => "cmdBoxTPortalStateList",
     56                    "session_key_api"      => $b0xTPortal_session_key_api,
     57                    "username_customer"    => $b0xTPortal_username,
     58                    "session_key_customer" => $b0xTPortal_session_key_customer,
     59                    "customer_id"          => $b0xTPortal_customer_id,
     60                    "country"              => $b0xTPortal_country_id
     61                );
     62
     63                $b0xTPortal_list_of_state = array();
     64                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     65
     66                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     67                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     68                } else {
     69                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     70                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     71                }
    5372
    5473                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/trunk/includes/ajax/workorder-page.php

    r2924835 r3278341  
    151151
    152152                $b0xTPortal_country_id                = sanitize_text_field(get_option('b0xTPortal_admin_country'));
    153                 $b0xTPortal_list_of_state             = $this->b0xTPortal_server_calls->b0xTPortal_get_states($b0xTPortal_country_id);
     153                $b0xTPortal_country_id = ($b0xTPortal_country_id == "Canada") ? "CAN" : "USA";
     154 
     155                $b0xTPortal_states_args = array(
     156                    "command"              => "cmdBoxTPortalStateList",
     157                    "session_key_api"      => $b0xTPortal_session_key_api,
     158                    "username_customer"    => $b0xTPortal_username,
     159                    "session_key_customer" => $b0xTPortal_session_key_customer,
     160                    "customer_id"          => $b0xTPortal_customer_id,
     161                    "country"              => $b0xTPortal_country_id
     162                );
     163
     164                $b0xTPortal_list_of_state = array();
     165                $b0xTPortal_states_query = $this->b0xTPortal_server_calls->b0xTPortal_call_command($b0xTPortal_states_args);
     166
     167                if($b0xTPortal_states_query && $b0xTPortal_states_query->status == '200') {
     168                    $b0xTPortal_list_of_state = $this->b0xTPortal_sanitize_array_values($b0xTPortal_states_query->stateList);
     169                } else {
     170                    $b0xTPortal_error = $this->b0xTPortal_generate_error_string($b0xTPortal_states_query);
     171                    wp_send_json($this->b0xTPortal_response('error', "Failed to get state list, ".$b0xTPortal_error, ''));
     172                }
    154173
    155174                if(!is_array($b0xTPortal_list_of_state)) {

  • box-tracker-portal/trunk/includes/base/activate.php

    r2763253 r3278341  
    1212    public static function b0xTPortal_activate() {
    1313        flush_rewrite_rules();
    14         self::b0xTPortal_create_states_table();
    15     }
    16 
    17     /**
    18      * This function will create the states table
    19      * which will be used to populate some of the
    20      * fields on the form.
    21      *
    22      */
    23     private static function b0xTPortal_create_states_table() {
    24         global $wpdb;
    25         $b0xTPortal_table_name = $wpdb->prefix.'b0xTPortal_states';
    26         $b0xTPortal_charset_collate = $wpdb->get_charset_collate();
    27 
    28         $b0xTPortal_table_exist = $wpdb->prepare('SHOW TABLES LIKE %s', $wpdb->esc_like($b0xTPortal_table_name));       
    29 
    30         if($wpdb->get_var($b0xTPortal_table_exist) === $b0xTPortal_table_name) {
    31             $b0xTPortal_query_drop_table = "DROP TABLE $b0xTPortal_table_name";
    32             $wpdb->query($b0xTPortal_query_drop_table);
    33         }
    34 
    35         //create the table
    36         $b0xTPortal_query_create_table = "CREATE TABLE $b0xTPortal_table_name (
    37             `state_id` int(5) NOT NULL AUTO_INCREMENT,
    38             `state_name` varchar(40) NOT NULL,
    39             `state_short` varchar(10) NOT NULL,
    40             `country_id` varchar(10) NOT NULL,
    41             PRIMARY  KEY (`state_id`)
    42         ) $b0xTPortal_charset_collate;";   
    43 
    44         //insert some values.
    45         $b0xTPortal_query_insert_values = "INSERT INTO $b0xTPortal_table_name (`state_id`, `state_name`, `state_short`, `country_id`) VALUES (1, 'Alabama', 'AL', 'USA'), (2, 'Alaska', 'AK', 'USA'), (3, 'Arizona', 'AZ', 'USA'), (4, 'Arkansas', 'AR', 'USA'), (5, 'California', 'CA', 'USA'), (6, 'Colorado', 'CO', 'USA'), (7, 'Connecticut', 'CT', 'USA'), (8, 'Delaware', 'DE', 'USA'), (9, 'Florida', 'FL', 'USA'), (10, 'Georgia', 'GA', 'USA'), (11, 'Hawaii', 'HI', 'USA'), (12, 'Idaho', 'ID', 'USA'), (13, 'Illinois', 'IL', 'USA'), (14, 'Indiana', 'IN', 'USA'), (15, 'Iowa', 'IA', 'USA'), (16, 'Kansas', 'KS', 'USA'), (17, 'Kentucky', 'KY', 'USA'), (18, 'Louisiana', 'LA', 'USA'), (19, 'Maine', 'ME', 'USA'), (20, 'Maryland', 'MD', 'USA'), (21, 'Massachusetts', 'MA', 'USA'), (22, 'Michigan', 'MI', 'USA'), (23, 'Minnesota', 'MN', 'USA'), (24, 'Mississippi', 'MS', 'USA'), (25, 'Missouri', 'MO', 'USA'), (26, 'Montana', 'MT', 'USA'), (27, 'Nebraska', 'NE', 'USA'), (28, 'Nevada', 'NV', 'USA'), (29, 'New Hampshire', 'NH', 'USA'), (30, 'New Jersey', 'NJ', 'USA'), (31, 'New Mexico', 'NM', 'USA'), (32, 'New York', 'NY', 'USA'), (33, 'North Carolina', 'NC', 'USA'), (34, 'North Dakota', 'ND', 'USA'), (35, 'Ohio', 'OH', 'USA'), (36, 'Oklahoma', 'OK', 'USA'), (37, 'Oregon', 'OR', 'USA'), (38, 'Pennsylvania', 'PA', 'USA'), (39, 'Rhode Island', 'RI', 'USA'), (40, 'South Carolina', 'SC', 'USA'), (41, 'South Dakota', 'SD', 'USA'), (42, 'Tennessee', 'TN', 'USA'), (43, 'Texas', 'TX', 'USA'), (44, 'Utah', 'UT', 'USA'), (45, 'Vermont', 'VT', 'USA'), (46, 'Virginia', 'VA', 'USA'), (47, 'Washington', 'WA', 'USA'), (48, 'West Virginia', 'WV', 'USA'), (49, 'Wisconsin', 'WI', 'USA'), (50, 'Wyoming', 'WY', 'USA'), (51, 'Alberta', 'AB', 'CAN'), (52, 'British Columbia', 'BC', 'CAN'), (53, 'Manitoba', 'MB', 'CAN'), (54, 'New Brunswick', 'NB', 'CAN'), (55, 'Newfoundland', 'NL', 'CAN'), (56, 'Northwest Territories', 'NT', 'CAN'), (57, 'Nova Scotia', 'NS', 'CAN'), (58, 'Nunavut', 'NU', 'CAN'), (59, 'Ontario', 'ON', 'CAN'), (60, 'Prince Edward Island', 'PE', 'CAN'), (61, 'Quebec', 'QC', 'CAN'), (62, 'Saskatchewan', 'SK', 'CAN'), (63, 'Yukon', 'YT', 'CAN')";
    46 
    47         require_once(ABSPATH.'wp-admin/includes/upgrade.php');
    48         dbDelta($b0xTPortal_query_create_table);
    49         dbDelta($b0xTPortal_query_insert_values);
    5014    }
    5115}

  • box-tracker-portal/trunk/includes/base/server-calls.php

    r2763253 r3278341  
    9191     }
    9292
    93     /**
    94      * Get a list of states
    95      *
    96      * @param string $b0xTPortal_country_id
    97      * @return string
    98      */
    99     function b0xTPortal_get_states($b0xTPortal_country_id) {
    100         $b0xTPortal_country_id = sanitize_text_field($b0xTPortal_country_id);
    101 
    102         global $wpdb;
    103         if($b0xTPortal_country_id == "Canada"){
    104              $b0xTPortal_country_id = 'CAN';
    105         } else {
    106              $b0xTPortal_country_id = 'USA';
    107         }
    108        
    109         $b0xTPortal_output = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."b0xTPortal_states WHERE country_id = '".$b0xTPortal_country_id."'");
    110 
    111         if(!is_array($b0xTPortal_output)) { return null; }
    112         return $this->b0xTPortal_sanitize_array_values($b0xTPortal_output);
    113     }
    114 
    115     /**
    116      * Get a list of states
    117      *
    118      * @return string
    119      */
    120     function b0xTPortal_get_all_states() {
    121         global $wpdb;
    122         $b0xTPortal_output = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."b0xTPortal_states");
    123         if(!is_array($b0xTPortal_output)) { return null; }
    124         return $this->b0xTPortal_sanitize_array_values($b0xTPortal_output);
    125     }
    126 
    12793    /*
    12894     * redefining these helper functions here, so that i dont

  • box-tracker-portal/trunk/readme.txt

    r3247414 r3278341  
    33Requires at least: 4.9
    44Requires PHP: 5.6.4
    5 Tested up to: 6.7.2
    6 Stable tag: 1.1.3
     5Tested up to: 6.8
     6Stable tag: 1.1.2
    77License: GPLv2 or later
    88License URI: http://www.gnu.org/licenses/gpl-2.0.html
Note: See TracChangeset for help on using the changeset viewer.