Файловый менеджер

Файловый менеджер - Редактировать - /home/goldin10/public_html/wp-content/plugins-BAK/woocommerce/admin/settings/settings-tax-rates.php
Error occurred
Назад
<?php /** * Additional tax settings * * @author WooThemes * @category Admin * @package WooCommerce/Admin/Settings * @version 2.0.0 / if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly /* * Output tax rate settings. * * @access public * @return void / function woocommerce_tax_rates_setting() { global $woocommerce, $current_section, $wpdb; $tax_classes = array_filter( array_map( 'trim', explode( "\n", get_option('woocommerce_tax_classes' ) ) ) ); $current_class = ''; foreach( $tax_classes as $class ) if ( sanitize_title( $class ) == $current_section ) $current_class = $class; ?> <h3><?php printf( __( 'Tax Rates for the "%s" Class', 'woocommerce' ), $current_class ? esc_html( $current_class ) : __( 'Standard', 'woocommerce' ) ); ?></h3> <p><?php printf( __( 'Define tax rates for countries and states below. <a href="%s">See here</a> for available alpha-2 country codes.', 'woocommerce' ), 'http://en.wikipedia.org/wiki/ISO_3166-1#Current_codes' ); ?></p> <table class="wc_tax_rates widefat"> <thead> <tr> <th class="sort"> </th> <th width="8%"><?php _e( 'Country Code', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('A 2 digit country code, e.g. US. Leave blank to apply to all.', 'woocommerce'); ?>">[?]</span></th> <th width="8%"><?php _e( 'State Code', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('A 2 digit state code, e.g. AL. Leave blank to apply to all.', 'woocommerce'); ?>">[?]</span></th> <th><?php _e( 'ZIP/Postcode', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('Postcode for this rule. Semi-colon (;) separate multiple values. Leave blank to apply to all areas. Wildcards () can be used. Ranges for numeric postcodes (e.g. 12345-12350) will be expanded into individual postcodes.', 'woocommerce'); ?>">[?]</span></th> <th><?php _e( 'City', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('Cities for this rule. Semi-colon (;) separate multiple values. Leave blank to apply to all cities.', 'woocommerce'); ?>">[?]</span></th> <th width="8%"><?php _e( 'Rate %', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e( 'Enter a tax rate (percentage) to 4 decimal places.', 'woocommerce' ); ?>">[?]</span></th> <th width="8%"><?php _e( 'Tax Name', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('Enter a name for this tax rate.', 'woocommerce'); ?>">[?]</span></th> <th width="8%"><?php _e( 'Priority', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('Choose a priority for this tax rate. Only 1 matching rate per priority will be used. To define multiple tax rates for a single area you need to specify a different priority per rate.', 'woocommerce'); ?>">[?]</span></th> <th width="8%"><?php _e( 'Compound', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('Choose whether or not this is a compound rate. Compound tax rates are applied on top of other tax rates.', 'woocommerce'); ?>">[?]</span></th> <th width="8%"><?php _e( 'Shipping', 'woocommerce' ); ?> <span class="tips" data-tip="<?php _e('Choose whether or not this tax rate also gets applied to shipping.', 'woocommerce'); ?>">[?]</span></th> </tr> </thead> <tfoot> <tr> <th colspan="10"> <a href="#" class="button plus insert"><?php _e( 'Insert row', 'woocommerce' ); ?></a> <a href="#" class="button minus remove"><?php _e( 'Remove selected row(s)', 'woocommerce' ); ?></a> <a href="#" download="tax_rates.csv" class="button export"><?php _e( 'Export CSV', 'woocommerce' ); ?></a> <a href="<?php echo admin_url( 'admin.php?import=woocommerce_tax_rate_csv' ); ?>" class="button import"><?php _e( 'Import CSV', 'woocommerce' ); ?></a> </th> </tr> </tfoot> <tbody id="rates"> <?php $rates = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_class = %s ORDER BY tax_rate_order " , sanitize_title( $current_class ) ) ); foreach ( $rates as $rate ) { ?> <tr> <td class="sort"><input type="hidden" class="remove_tax_rate" name="remove_tax_rate[<?php echo $rate->tax_rate_id ?>]" value="0" /></td> <td class="country" width="8%"> <input type="text" value="<?php echo esc_attr( $rate->tax_rate_country ) ?>" placeholder="" name="tax_rate_country[<?php echo $rate->tax_rate_id ?>]" /> </td> <td class="state" width="8%"> <input type="text" value="<?php echo esc_attr( $rate->tax_rate_state ) ?>" placeholder="" name="tax_rate_state[<?php echo $rate->tax_rate_id ?>]" /> </td> <td class="postcode"> <input type="text" value="<?php $locations = $wpdb->get_col( $wpdb->prepare( "SELECT location_code FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE location_type='postcode' AND tax_rate_id = %d ORDER BY location_code", $rate->tax_rate_id ) ); echo esc_attr( implode( '; ', $locations ) ); ?>" placeholder="" data-name="tax_rate_postcode[<?php echo $rate->tax_rate_id ?>]" /> </td> <td class="city"> <input type="text" value="<?php $locations = $wpdb->get_col( $wpdb->prepare( "SELECT location_code FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE location_type='city' AND tax_rate_id = %d ORDER BY location_code", $rate->tax_rate_id ) ); echo esc_attr( implode( '; ', $locations ) ); ?>" placeholder="" data-name="tax_rate_city[<?php echo $rate->tax_rate_id ?>]" /> </td> <td class="rate" width="8%"> <input type="number" step="any" min="0" value="<?php echo esc_attr( $rate->tax_rate ) ?>" placeholder="0" name="tax_rate[<?php echo $rate->tax_rate_id ?>]" /> </td> <td class="name" width="8%"> <input type="text" value="<?php echo esc_attr( $rate->tax_rate_name ) ?>" name="tax_rate_name[<?php echo $rate->tax_rate_id ?>]" /> </td> <td class="priority" width="8%"> <input type="number" step="1" min="1" value="<?php echo esc_attr( $rate->tax_rate_priority ) ?>" name="tax_rate_priority[<?php echo $rate->tax_rate_id ?>]" /> </td> <td class="compound" width="8%"> <input type="checkbox" class="checkbox" name="tax_rate_compound[<?php echo $rate->tax_rate_id ?>]" <?php checked( $rate->tax_rate_compound, '1' ); ?> /> </td> <td class="apply_to_shipping" width="8%"> <input type="checkbox" class="checkbox" name="tax_rate_shipping[<?php echo $rate->tax_rate_id ?>]" <?php checked($rate->tax_rate_shipping, '1' ); ?> /> </td> </tr> <?php } ?> </tbody> </table> <script type="text/javascript"> jQuery( function() { jQuery('.wc_tax_rates tbody').sortable({ items:'tr', cursor:'move', axis:'y', scrollSensitivity:40, forcePlaceholderSize: true, helper: 'clone', opacity: 0.65, placeholder: 'wc-metabox-sortable-placeholder', start:function(event,ui){ ui.item.css('background-color','#f6f6f6'); }, stop:function(event,ui){ ui.item.removeAttr('style'); } }); jQuery('.wc_tax_rates .remove').click(function() { var $tbody = jQuery('.wc_tax_rates').find('tbody'); if ( $tbody.find('tr.current').size() > 0 ) { $current = $tbody.find('tr.current'); $current.find('input').val(''); $current.find('input.remove_tax_rate').val('1'); $current.each(function(){ if ( jQuery(this).is('.new') ) jQuery(this).remove(); else jQuery(this).hide(); }); } else { alert('<?php _e( 'No row(s) selected', 'woocommerce' ); ?>'); } return false; }); var controlled = false; var shifted = false; var hasFocus = false; jQuery(document).bind('keyup keydown', function(e){ shifted = e.shiftKey; controlled = e.ctrlKey \|\| e.metaKey } ); jQuery('#rates').on( 'focus click', 'input', function( e ) { $this_row = jQuery(this).closest('tr'); if ( ( e.type == 'focus' && hasFocus != $this_row.index() ) \|\| ( e.type == 'click' && jQuery(this).is(':focus') ) ) { hasFocus = $this_row.index(); if ( ! shifted && ! controlled ) { jQuery('#rates tr').removeClass('current').removeClass('last_selected'); $this_row.addClass('current').addClass('last_selected'); } else if ( shifted ) { jQuery('#rates tr').removeClass('current'); $this_row.addClass('selected_now').addClass('current'); if ( jQuery('#rates tr.last_selected').size() > 0 ) { if ( $this_row.index() > jQuery('#rates tr.last_selected').index() ) { jQuery('#rates tr').slice( jQuery('#rates tr.last_selected').index(), $this_row.index() ).addClass('current'); } else { jQuery('#rates tr').slice( $this_row.index(), jQuery('#rates tr.last_selected').index() + 1 ).addClass('current'); } } jQuery('#rates tr').removeClass('last_selected'); $this_row.addClass('last_selected'); } else { jQuery('#rates tr').removeClass('last_selected'); if ( controlled && jQuery(this).closest('tr').is('.current') ) { $this_row.removeClass('current'); } else { $this_row.addClass('current').addClass('last_selected'); } } jQuery('#rates tr').removeClass('selected_now'); } }).on( 'blur', 'input', function( e ) { hasFocus = false; }); jQuery('.wc_tax_rates .export').click(function() { var csv_data = "data:application/csv;charset=utf-8,<?php _e( 'Country Code', 'woocommerce' ); ?>,<?php _e( 'State Code', 'woocommerce' ); ?>,<?php _e( 'ZIP/Postcode', 'woocommerce' ); ?>,<?php _e( 'City', 'woocommerce' ); ?>,<?php _e( 'Rate %', 'woocommerce' ); ?>,<?php _e( 'Tax Name', 'woocommerce' ); ?>,<?php _e( 'Priority', 'woocommerce' ); ?>,<?php _e( 'Compound', 'woocommerce' ); ?>,<?php _e( 'Shipping', 'woocommerce' ); ?>,<?php _e( 'Tax Class', 'woocommerce' ); ?>\n"; jQuery('#rates tr:visible').each(function() { var row = ''; jQuery(this).find('td:not(.sort) input').each(function() { if ( jQuery(this).is('.checkbox') ) { if ( jQuery(this).is(':checked') ) { val = 1; } else { val = 0; } } else { var val = jQuery(this).val(); if ( ! val ) val = jQuery(this).attr('placeholder'); } row = row + val + ','; }); row = row + '<?php echo $current_class; ?>'; //row.substring( 0, row.length - 1 ); csv_data = csv_data + row + "\n"; }); jQuery(this).attr( 'href', encodeURI( csv_data ) ); return true; }); jQuery('.wc_tax_rates .insert').click(function() { var $tbody = jQuery('.wc_tax_rates').find('tbody'); var size = $tbody.find('tr').size(); var code = '<tr class="new">\ <td class="sort"> </td>\ <td class="country" width="8%">\ <input type="text" placeholder="" name="tax_rate_country[new][' + size + ']" />\ </td>\ <td class="state" width="8%">\ <input type="text" placeholder="" name="tax_rate_state[new][' + size + ']" />\ </td>\ <td class="postcode">\ <input type="text" placeholder="" name="tax_rate_postcode[new][' + size + ']" />\ </td>\ <td class="city">\ <input type="text" placeholder="" name="tax_rate_city[new][' + size + ']" />\ </td>\ <td class="rate" width="8%">\ <input type="number" step="any" min="0" placeholder="0" name="tax_rate[new][' + size + ']" />\ </td>\ <td class="name" width="8%">\ <input type="text" name="tax_rate_name[new][' + size + ']" />\ </td>\ <td class="priority" width="8%">\ <input type="number" step="1" min="1" value="1" name="tax_rate_priority[new][' + size + ']" />\ </td>\ <td class="compound" width="8%">\ <input type="checkbox" class="checkbox" name="tax_rate_compound[new][' + size + ']" />\ </td>\ <td class="apply_to_shipping" width="8%">\ <input type="checkbox" class="checkbox" name="tax_rate_shipping[new][' + size + ']" checked="checked" />\ </td>\ </tr>'; if ( $tbody.find('tr.current').size() > 0 ) { $tbody.find('tr.current').after( code ); } else { $tbody.append( code ); } jQuery( "td.country input" ).autocomplete({ source: availableCountries, minLength: 3 }); jQuery( "td.state input" ).autocomplete({ source: availableStates, minLength: 3 }); return false; }); jQuery('.wc_tax_rates td.postcode, .wc_tax_rates td.city').find('input').change(function() { jQuery(this).attr( 'name', jQuery(this).attr( 'data-name' ) ); }); var availableCountries = [<?php $countries = array(); foreach ( $woocommerce->countries->get_allowed_countries() as $value => $label ) $countries[] = '{ label: "' . esc_attr( $label ) . '", value: "' . $value . '" }'; echo implode( ', ', $countries ); ?>]; var availableStates = [<?php $countries = array(); foreach ( $woocommerce->countries->get_allowed_country_states() as $value => $label ) foreach ( $label as $code => $state ) $countries[] = '{ label: "' . esc_attr( $state ) . '", value: "' . $code . '" }'; echo implode( ', ', $countries ); ?>]; jQuery( "td.country input" ).autocomplete({ source: availableCountries, minLength: 3 }); jQuery( "td.state input" ).autocomplete({ source: availableStates, minLength: 3 }); }); </script> <?php } /** * woocommerce_tax_rates_setting_save function. * * @access public * @return void / function woocommerce_tax_rates_setting_save() { global $wpdb, $current_section; // Get class $tax_classes = array_filter( array_map( 'trim', explode( "\n", get_option('woocommerce_tax_classes' ) ) ) ); $current_class = ''; foreach( $tax_classes as $class ) if ( sanitize_title( $class ) == $current_section ) $current_class = $class; // Get POST data $tax_rate_country = isset( $_POST['tax_rate_country'] ) ? $_POST['tax_rate_country'] : array(); $tax_rate_state = isset( $_POST['tax_rate_state'] ) ? $_POST['tax_rate_state'] : array(); $tax_rate_postcode = isset( $_POST['tax_rate_postcode'] ) ? $_POST['tax_rate_postcode'] : array(); $tax_rate_city = isset( $_POST['tax_rate_city'] ) ? $_POST['tax_rate_city'] : array(); $tax_rate = isset( $_POST['tax_rate'] ) ? $_POST['tax_rate'] : array(); $tax_rate_name = isset( $_POST['tax_rate_name'] ) ? $_POST['tax_rate_name'] : array(); $tax_rate_priority = isset( $_POST['tax_rate_priority'] ) ? $_POST['tax_rate_priority'] : array(); $tax_rate_compound = isset( $_POST['tax_rate_compound'] ) ? $_POST['tax_rate_compound'] : array(); $tax_rate_shipping = isset( $_POST['tax_rate_shipping'] ) ? $_POST['tax_rate_shipping'] : array(); $i = 0; // Loop posted fields foreach ( $tax_rate_country as $key => $value ) { // new keys are inserted... if ( $key == 'new' ) { foreach ( $value as $new_key => $new_value ) { // Sanitize + format $country = strtoupper( woocommerce_clean( $tax_rate_country[ $key ][ $new_key ] ) ); $state = strtoupper( woocommerce_clean( $tax_rate_state[ $key ][ $new_key ] ) ); $postcode = woocommerce_clean( $tax_rate_postcode[ $key ][ $new_key ] ); $city = woocommerce_clean( $tax_rate_city[ $key ][ $new_key ] ); $rate = number_format( woocommerce_clean( $tax_rate[ $key ][ $new_key ] ), 4, '.', '' ); $name = woocommerce_clean( $tax_rate_name[ $key ][ $new_key ] ); $priority = absint( woocommerce_clean( $tax_rate_priority[ $key ][ $new_key ] ) ); $compound = isset( $tax_rate_compound[ $key ][ $new_key ] ) ? 1 : 0; $shipping = isset( $tax_rate_shipping[ $key ][ $new_key ] ) ? 1 : 0; if ( ! $name ) $name = __( 'Tax', 'woocommerce' ); if ( $country == '' ) $country = ''; if ( $state == '' ) $state = ''; $wpdb->insert( $wpdb->prefix . "woocommerce_tax_rates", array( 'tax_rate_country' => $country, 'tax_rate_state' => $state, 'tax_rate' => $rate, 'tax_rate_name' => $name, 'tax_rate_priority' => $priority, 'tax_rate_compound' => $compound, 'tax_rate_shipping' => $shipping, 'tax_rate_order' => $i, 'tax_rate_class' => sanitize_title( $current_class ) ) ); $tax_rate_id = $wpdb->insert_id; if ( ! empty( $postcode ) ) { $postcodes = explode( ';', $postcode ); $postcodes = array_map( 'strtoupper', array_map( 'woocommerce_clean', $postcodes ) ); $postcode_query = array(); foreach( $postcodes as $postcode ) if ( strstr( $postcode, '-' ) ) { $postcode_parts = explode( '-', $postcode ); if ( is_numeric( $postcode_parts[0] ) && is_numeric( $postcode_parts[1] ) && $postcode_parts[1] > $postcode_parts[0] ) { for ( $i = $postcode_parts[0]; $i <= $postcode_parts[1]; $i ++ ) { if ( $i ) $postcode_query[] = "( '" . $wpdb->escape( $i ) . "', $tax_rate_id, 'postcode' )"; } } } else { if ( $postcode ) $postcode_query[] = "( '" . $wpdb->escape( $postcode ) . "', $tax_rate_id, 'postcode' )"; } $wpdb->query( "INSERT INTO {$wpdb->prefix}woocommerce_tax_rate_locations ( location_code, tax_rate_id, location_type ) VALUES " . implode( ',', $postcode_query ) ); } if ( ! empty( $city ) ) { $cities = explode( ';', $city ); $cities = array_map( 'strtoupper', array_map( 'woocommerce_clean', $cities ) ); foreach( $cities as $city ) { $wpdb->insert( $wpdb->prefix . "woocommerce_tax_rate_locations", array( 'location_code' => $city, 'tax_rate_id' => $tax_rate_id, 'location_type' => 'city', ) ); } } $i++; } // ...whereas the others are updated } else { $tax_rate_id = absint( $key ); if ( $_POST['remove_tax_rate'][ $key ] == 1 ) { $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE tax_rate_id = %d;", $tax_rate_id ) ); $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}woocommerce_tax_rates WHERE tax_rate_id = %d;", $tax_rate_id ) ); continue; } // Sanitize + format $country = strtoupper( woocommerce_clean( $tax_rate_country[ $key ] ) ); $state = strtoupper( woocommerce_clean( $tax_rate_state[ $key ] ) ); $rate = number_format( woocommerce_clean( $tax_rate[ $key ] ), 4, '.', '' ); $name = woocommerce_clean( $tax_rate_name[ $key ] ); $priority = absint( woocommerce_clean( $tax_rate_priority[ $key ] ) ); $compound = isset( $tax_rate_compound[ $key ] ) ? 1 : 0; $shipping = isset( $tax_rate_shipping[ $key ] ) ? 1 : 0; if ( ! $name ) $name = __( 'Tax', 'woocommerce' ); if ( $country == '' ) $country = ''; if ( $state == '*' ) $state = ''; $wpdb->update( $wpdb->prefix . "woocommerce_tax_rates", array( 'tax_rate_country' => $country, 'tax_rate_state' => $state, 'tax_rate' => $rate, 'tax_rate_name' => $name, 'tax_rate_priority' => $priority, 'tax_rate_compound' => $compound, 'tax_rate_shipping' => $shipping, 'tax_rate_order' => $i, 'tax_rate_class' => sanitize_title( $current_class ) ), array( 'tax_rate_id' => $tax_rate_id ) ); if ( isset( $tax_rate_postcode[ $key ] ) ) { // Delete old $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE tax_rate_id = %d AND location_type = 'postcode';", $tax_rate_id ) ); // Add changed $postcode = woocommerce_clean( $tax_rate_postcode[ $key ] ); $postcodes = explode( ';', $postcode ); $postcodes = array_map( 'strtoupper', array_map( 'woocommerce_clean', $postcodes ) ); $postcode_query = array(); foreach( $postcodes as $postcode ) if ( strstr( $postcode, '-' ) ) { $postcode_parts = explode( '-', $postcode ); if ( is_numeric( $postcode_parts[0] ) && is_numeric( $postcode_parts[1] ) && $postcode_parts[1] > $postcode_parts[0] ) { for ( $i = $postcode_parts[0]; $i <= $postcode_parts[1]; $i ++ ) { if ( $i ) $postcode_query[] = "( '" . $wpdb->escape( $i ) . "', $tax_rate_id, 'postcode' )"; } } } else { if ( $postcode ) $postcode_query[] = "( '" . $wpdb->escape( $postcode ) . "', $tax_rate_id, 'postcode' )"; } $wpdb->query( "INSERT INTO {$wpdb->prefix}woocommerce_tax_rate_locations ( location_code, tax_rate_id, location_type ) VALUES " . implode( ',', $postcode_query ) ); } if ( isset( $tax_rate_city[ $key ] ) ) { // Delete old $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}woocommerce_tax_rate_locations WHERE tax_rate_id = %d AND location_type = 'city';", $tax_rate_id ) ); // Add changed $city = woocommerce_clean( $tax_rate_city[ $key ] ); $cities = explode( ';', $city ); $cities = array_map( 'strtoupper', array_map( 'woocommerce_clean', $cities ) ); foreach( $cities as $city ) { if ( $city ) { $wpdb->insert( $wpdb->prefix . "woocommerce_tax_rate_locations", array( 'location_code' => $city, 'tax_rate_id' => $tax_rate_id, 'location_type' => 'city', ) ); } } } $i++; } } }

| ver. 1.4 | Github | . | PHP 7.2.34 | Генерация страницы: 0.06 | proxy | phpinfo | Настройка