\s*$/', '', $skuvalue );
}
}
$mes = $rembr;
}
if ( ! empty( $mes ) ) {
$_SESSION['usces_singleitem']['itemOption'] = isset( $_POST['itemOption'] ) ? $_POST['itemOption'] : array();
$_SESSION['usces_singleitem']['quant'] = isset( $_POST['quant'] ) ? (int) $_POST['quant'] : 1;
$_SESSION['usces_singleitem']['error_message'] = $mes;
if ( false === strpos( $_POST['usces_referer'], 'http' ) ) {
$parse_url = parse_url( get_home_url() );
$port = '';
if ( isset( $parse_url['port'] ) && ! empty( $parse_url['port'] ) ) {
$port = ':' . $parse_url['port'];
}
header( 'location: ' . $parse_url['scheme'] . '://' . $parse_url['host'] . $port . esc_url( $_POST['usces_referer'] ) . apply_filters( 'usces_filter_incart_redirect', '#cart_button', $post_id, $sku ) );
} else {
header( 'location: ' . esc_url( $_POST['usces_referer'] ) . apply_filters( 'usces_filter_incart_redirect', '#cart_button', $post_id, $sku ) );
}
exit;
}
do_action( 'usces_action_incart_checked', $mes, $post_id, $sku );
}
public function zaiko_check() {
$logged_in_member = $this->get_member();
if ( ! empty( $logged_in_member['ID'] ) ) {
if ( ! $this->member_exists( $logged_in_member['ID'] ) ) {
$mes = __( 'Your membership information could not be verified.', 'usces' );
$this->error_message = $mes;
$this->member_logout();
return $mes;
}
}
$mes = '';
$cart = $this->cart->get_cart();
$stocks = array();
$cart_count = ( $cart && is_array( $cart ) ) ? count( $cart ) : 0;
for ( $i = 0; $i < $cart_count; $i++ ) {
$cart_row = $cart[ $i ];
$post_id = $cart_row['post_id'];
$sku = $cart_row['sku'];
$sku_code = urldecode( $cart_row['sku'] );
$quant = ( isset( $_POST['quant'][ $i ][ $post_id ][ $sku ] ) ) ? trim( $_POST['quant'][ $i ][ $post_id ][ $sku ] ) : $cart_row['quantity'];
$zaiko_id = (int) $this->getItemZaikoStatusId( $post_id, $sku_code );
$stock = $this->getItemZaikoNum( $post_id, $sku_code );
if ( ! isset( $stocks[ $post_id ][ $sku ] ) ) {
if ( ! WCUtils::is_blank( $stock ) ) {
$stocks[ $post_id ][ $sku ] = $stock;
} else {
$stocks[ $post_id ][ $sku ] = null;
}
}
$checkstock = $stocks[ $post_id ][ $sku ];
$stocks[ $post_id ][ $sku ] = $stocks[ $post_id ][ $sku ] - $quant;
$product = wel_get_product( $post_id );
$itemRestriction = isset( $product['itemRestriction'] ) ? $product['itemRestriction'] : '';
$itemOrderAcceptable = $this->getItemOrderAcceptable( $post_id );
$post_status = get_post_status( $post_id );
if ( 1 > (int) $quant ) {
$mes .= sprintf( __( 'Enter the correct amount for the No.%d item.', 'usces' ), ( $i + 1 ) ) . '
';
} elseif ( ! $this->is_item_zaiko( $post_id, $sku_code ) || ( 1 != $itemOrderAcceptable && WCUtils::is_zero( $stock ) ) || 'publish' != $post_status ) {
$mes .= sprintf( __( 'Sorry, No.%d item is sold out.', 'usces' ), ( $i + 1 ) ) . '
';
} elseif ( $quant > (int) $itemRestriction && ! WCUtils::is_blank( $itemRestriction ) && ! WCUtils::is_zero( $itemRestriction ) ) {
$mes .= sprintf( __( 'This article is limited by %1$d at a time for the No.%2$d item.', 'usces' ), $itemRestriction, ( $i + 1 ) ) . '
';
} elseif ( 1 != $itemOrderAcceptable && 0 > $stocks[ $post_id ][ $sku ] && ! WCUtils::is_blank( $stock ) ) {
$mes .= sprintf( __( 'Stock of No.%1$d item is remainder %2$d.', 'usces' ), ( $i + 1 ), $checkstock ) . '
';
}
}
$mes = apply_filters( 'usces_filter_zaiko_check', $mes, $cart);
return $mes;
}
/**
* Check if the member exists in the database or not.
*
* @param integer $member_id The id of the member.
* @return boolean true/false
*/
public function member_exists( $member_id ) {
$member_info = $this->get_member_info( $member_id );
if ( empty( $member_info ) ) {
return false;
} else {
return true;
}
}
public function get_pwd_errors( $password ) {
if ( WCUtils::is_blank( $password ) ) {
return __( 'Please enter a password.', 'usces' ) . '
';
}
$ret = '';
$system_option = $this->options['system'];
$pwd_rule_min = $system_option['member_pass_rule_min'];
$pwd_rule_max = empty( $system_option['member_pass_rule_max'] ) ? 30 : $system_option['member_pass_rule_max'];
if ( strlen( $password ) < $pwd_rule_min || strlen( $password ) > $pwd_rule_max ) {
if ( $pwd_rule_min === $pwd_rule_max ) {
$rule = sprintf( __( '%s characters long', 'usces' ), $pwd_rule_min );
} else {
$rule = sprintf( __( '%1$s characters and no more than %2$s characters', 'usces' ), $pwd_rule_min, $pwd_rule_max );
}
$ret .= sprintf( __( 'Password must be at least %s.', 'usces' ), $rule ) . '
';
}
if ( ! empty( $system_option['member_pass_rule_upercase'] ) && ! preg_match( '@[A-Z]@', $password ) ) {
$ret .= __( 'Password must contain at least one upper-case alphabetics character.', 'usces' ) . '
';
}
if ( ! empty( $system_option['member_pass_rule_lowercase'] ) && ! preg_match( '@[a-z]@', $password ) ) {
$ret .= __( 'Password must contain at least one lower-case alphabetics character.', 'usces' ) . '
';
}
if ( ! empty( $system_option['member_pass_rule_digit'] ) && ! preg_match( '@[0-9]@', $password ) ) {
$ret .= __( 'Password must contain at least one numeric character.', 'usces' ) . '
';
}
if ( ! empty( $system_option['member_pass_rule_symbol'] ) && ! preg_match( '@[\W]@', $password ) ) {
$ret .= __( 'Password must contain at least one symbolic character.', 'usces' ) . '
';
}
return $ret;
}
public function member_check() {
do_action( 'usces_action_before_member_check' );
$mes = '';
$usces_member_old = $_SESSION['usces_member'];
foreach ( $_POST['member'] as $key => $vlue ) {
if ( 'password1' !== $key && 'password2' !== $key && 'mailaddress2' !== $key ) {
$_SESSION['usces_member'][ $key ] = trim( $vlue );
}
}
if ( 'newmemberform' == $_POST['member_regmode'] ||
( 'editmemberform' === $_POST['member_regmode'] && ! ( WCUtils::is_blank( $_POST['member']['password1'] ) && WCUtils::is_blank( $_POST['member']['password2'] ) ) ) ||
( 'updatememberform' === $_POST['member_regmode'] && ! ( WCUtils::is_blank( $_POST['member']['password1'] ) && WCUtils::is_blank( $_POST['member']['password2'] ) ) ) ) {
$mes = $this->get_pwd_errors( $_POST['member']['password1'] );
}
if ( 'editmemberform' == $_POST['member_regmode'] || 'updatememberform' == $_POST['member_regmode'] ) {
if ( trim( $_POST['member']['password1'] ) != trim( $_POST['member']['password2'] ) ) {
$mes .= __( 'Password confirm does not match.', 'usces' ) . '
';
}
if ( ! is_email( $_POST['member']['mailaddress1'] ) || WCUtils::is_blank( $_POST['member']['mailaddress1'] ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
} else {
$this->get_current_member();
$mem_id = $this->current_member['id'];
$id = $this->check_member_email( $_POST['member']['mailaddress1'] );
if ( ! empty( $id ) && $id != $mem_id ) {
$mes .= __( 'This e-mail address can not be registered.', 'usces' ) . '
';
} else {
if ( isset( $_POST['member']['mailaddress2'] ) ) {
if ( WCUtils::is_blank( $_POST['member']['mailaddress2'] ) ) {
if ( $usces_member_old['mailaddress1'] !== $_POST['member']['mailaddress1'] ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
}
} else {
if ( trim( $_POST['member']['mailaddress1'] ) != trim( $_POST['member']['mailaddress2'] ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
}
}
}
}
}
} elseif ( 'newmemberform' == $_POST['member_regmode'] ) {
if ( trim( $_POST['member']['password1'] ) != trim( $_POST['member']['password2'] ) ) {
$mes .= __( 'Password confirm does not match.', 'usces' ) . '
';
}
if ( ! is_email( $_POST['member']['mailaddress1'] ) || WCUtils::is_blank( $_POST['member']['mailaddress1'] ) || WCUtils::is_blank( $_POST['member']['mailaddress2'] ) || trim( $_POST['member']['mailaddress1'] ) != trim( $_POST['member']['mailaddress2'] ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
} else {
$id = $this->check_member_email( $_POST['member']['mailaddress1'] );
if ( ! empty( $id ) ) {
$mes .= __( 'This e-mail address can not be registered.', 'usces' ) . '
';
}
}
} else {
$mes .= __( 'ERROR: I was not able to complete collective operation', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['member']['name1'] ) ) {
$mes .= __( 'Name is not correct', 'usces' ) . '
';
}
$zip_check = false;
$addressform = $this->options['system']['addressform'];
$applyform = usces_get_apply_addressform( $addressform );
if ( 'JP' === $applyform ) {
if ( isset( $_POST['member']['country'] ) ) {
if ( 'JP' === $_POST['member']['country'] ) {
$zip_check = true;
}
} else {
$base = usces_get_base_country();
if ( 'JP' === $base ) {
$zip_check = true;
}
}
}
$zip_check = apply_filters( 'usces_filter_zipcode_check', $zip_check );
if ( WCUtils::is_blank( $_POST['member']['zipcode'] ) ) {
if ( usces_is_required_field('zipcode') ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
} else {
if ( $zip_check ) {
if ( ! preg_match( '/^[a-zA-Z0-9]+$/', $_POST['member']['zipcode'] ) ) {
$_SESSION['usces_member']['zipcode'] = usces_convert_zipcode( $_POST['member']['zipcode'] );
}
if ( ! preg_match( '/^(([0-9]{3}-[0-9]{4})|([0-9]{7}))$/', $_SESSION['usces_member']['zipcode'] ) ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
}
}
if ( __( '-- Select --', 'usces_dual' ) == $_POST['member']['pref'] && usces_is_required_field( 'states' ) ) {
$mes .= __( 'enter the prefecture', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['member']['address1'] ) && usces_is_required_field( 'address1' ) ) {
$mes .= __( 'enter the city name', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['member']['address2'] ) && usces_is_required_field( 'address2' ) ) {
$mes .= __( 'enter house numbers', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['member']['tel'] ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'enter phone numbers', 'usces' ) . '
';
}
if ( ! WCUtils::is_blank( $_POST['member']['tel'] ) && preg_match( '/[^\d\-+]/', trim( $_POST['member']['tel'] ) ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'Please input a phone number with a half size number.', 'usces' ) . '
';
}
if ( 'editmemberform' !== $_POST['member_regmode'] && 'updatememberform' !== $_POST['member_regmode'] && isset( $this->options['agree_member'] ) && 'activate' === $this->options['agree_member'] ) {
if ( ! isset( $_POST['agree_member_check'] ) ) {
$mes .= __( 'Please accept the membership agreement.', 'usces' ) . '
';
}
}
$mes = apply_filters( 'usces_filter_member_check', $mes );
if ( ( 'editmemberform' == $_POST['member_regmode'] || 'updatememberform' == $_POST['member_regmode'] ) && '' != $mes ) {
$_SESSION['usces_member'] = $usces_member_old;
}
return $mes;
}
public function member_check_fromcart() {
do_action( 'usces_action_before_member_check_fromcart' );
$mes = $this->get_pwd_errors( $_POST['customer']['password1'] );
if ( trim( $_POST['customer']['password1'] ) != trim( $_POST['customer']['password2'] ) ) {
$mes .= __( 'Password confirm does not match.', 'usces' ) . '
';
}
if ( ! is_email( $_POST['customer']['mailaddress1'] ) || WCUtils::is_blank( $_POST['customer']['mailaddress1'] ) || WCUtils::is_blank( $_POST['customer']['mailaddress2'] ) || trim( $_POST['customer']['mailaddress1'] ) != trim( $_POST['customer']['mailaddress2'] ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['name1'] ) ) {
$mes .= __( 'Name is not correct', 'usces' ) . '
';
}
$zip_check = false;
$addressform = $this->options['system']['addressform'];
$applyform = usces_get_apply_addressform( $addressform );
if ( 'JP' === $applyform ) {
if ( isset( $_POST['customer']['country'] ) ) {
if ( 'JP' === $_POST['customer']['country'] ) {
$zip_check = true;
}
} else {
$base = usces_get_base_country();
if ( 'JP' === $base ) {
$zip_check = true;
}
}
}
$zip_check = apply_filters( 'usces_filter_zipcode_check', $zip_check );
if ( WCUtils::is_blank( $_POST['customer']['zipcode'] ) ) {
if ( usces_is_required_field( 'zipcode' ) ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
} else {
if ( $zip_check ) {
if ( ! preg_match( '/^[a-zA-Z0-9]+$/', $_POST['customer']['zipcode'] ) ) {
$_SESSION['usces_entry']['customer']['zipcode'] = usces_convert_zipcode( $_POST['customer']['zipcode'] );
}
if ( ! preg_match( '/^(([0-9]{3}-[0-9]{4})|([0-9]{7}))$/', $_SESSION['usces_entry']['customer']['zipcode'] ) ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
}
}
if ( ( __( '-- Select --', 'usces' ) == $_POST['customer']['pref'] || '-- Select --' == $_POST['customer']['pref'] ) && usces_is_required_field( 'states' ) ) {
$mes .= __( 'enter the prefecture', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['address1'] ) && usces_is_required_field( 'address1' ) ) {
$mes .= __( 'enter the city name', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['address2'] ) && usces_is_required_field( 'address2' ) ) {
$mes .= __( 'enter house numbers', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['tel'] ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'enter phone numbers', 'usces' ) . '
';
}
if ( ! WCUtils::is_blank( $_POST['customer']['tel'] ) && preg_match( '/[^\d\-+]/', trim( $_POST['customer']['tel'] ) ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'Please input a phone number with a half size number.', 'usces' ) . '
';
}
if ( isset( $this->options['agree_member'] ) && 'activate' === $this->options['agree_member'] ) {
if ( ! isset( $_POST['agree_member_check'] ) ) {
$mes .= __( 'Please accept the membership agreement.', 'usces' ) . '
';
}
}
$mes = apply_filters( 'usces_filter_member_check_fromcart', $mes );
return $mes;
}
public function admin_member_check() {
global $wpdb;
$mes = '';
if ( ! is_email( trim( $_POST['member']['email'] ) ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
} else {
$member_table = usces_get_tablename( 'usces_member' );
$mem_email = $wpdb->get_var( $wpdb->prepare( "SELECT mem_email FROM $member_table WHERE ID = %d LIMIT 1", trim( $_POST['member_id'] ) ) );
if ( trim( $_POST['member']['email'] ) != $mem_email ) {
$mem_ID = $wpdb->get_var( $wpdb->prepare( "SELECT ID FROM $member_table WHERE mem_email = %s LIMIT 1", trim( $_POST['member']['email'] ) ) );
if ( ! empty( $mem_ID ) ) {
$mes .= __( 'This e-mail address has been already registered.', 'usces' ) . '
';
}
}
}
if ( WCUtils::is_blank( $_POST['member']['name1'] ) ) {
$mes .= __( 'Name is not correct', 'usces' ) . '
';
}
if ( ! WCUtils::is_blank( $_POST['member']['tel'] ) && preg_match( '/[^\d\-+]/', trim( $_POST['member']['tel'] ) ) ) {
$mes .= __( 'Please input a phone number with a half size number.', 'usces' ) . '
';
}
$mes = apply_filters( 'usces_filter_admin_member_check', $mes );
return $mes;
}
public function customer_check() {
do_action( 'usces_action_before_customer_check' );
$mes = '';
if ( ! is_email( $_POST['customer']['mailaddress1'] ) || WCUtils::is_blank( $_POST['customer']['mailaddress1'] ) || WCUtils::is_blank( $_POST['customer']['mailaddress2'] ) || trim( $_POST['customer']['mailaddress1'] ) != trim( $_POST['customer']['mailaddress2'] ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['name1'] ) ) {
$mes .= __( 'Name is not correct', 'usces' ) . '
';
}
$zip_check = false;
$addressform = $this->options['system']['addressform'];
$applyform = usces_get_apply_addressform( $addressform );
if ( 'JP' === $applyform ) {
if ( isset( $_POST['customer']['country'] ) ) {
if ( 'JP' === $_POST['customer']['country'] ) {
$zip_check = true;
}
} else {
$base = usces_get_base_country();
if ( 'JP' === $base ) {
$zip_check = true;
}
}
}
$zip_check = apply_filters( 'usces_filter_zipcode_check', $zip_check );
if ( WCUtils::is_blank( $_POST['customer']['zipcode'] ) ) {
if ( usces_is_required_field( 'zipcode' ) ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
} else {
if ( $zip_check ) {
if ( ! preg_match( '/^[a-zA-Z0-9]+$/', $_POST['customer']['zipcode'] ) ) {
$_SESSION['usces_entry']['customer']['zipcode'] = usces_convert_zipcode( $_POST['customer']['zipcode'] );
}
if ( ! preg_match( '/^(([0-9]{3}-[0-9]{4})|([0-9]{7}))$/', $_SESSION['usces_entry']['customer']['zipcode'] ) ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
}
}
if ( ( __( '-- Select --', 'usces' ) == $_POST['customer']['pref'] || '-- Select --' == $_POST['customer']['pref'] ) && usces_is_required_field( 'states' ) ) {
$mes .= __( 'enter the prefecture', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['address1'] ) && usces_is_required_field( 'address1' ) ) {
$mes .= __( 'enter the city name', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['address2'] ) && usces_is_required_field( 'address2' ) ) {
$mes .= __( 'enter house numbers', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['customer']['tel'] ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'enter phone numbers', 'usces' ) . '
';
}
if ( ! WCUtils::is_blank( $_POST['customer']['tel'] ) && preg_match( '/[^\d\-+]/', trim( $_POST['customer']['tel'] ) ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'Please input a phone number with a half size number.', 'usces' ) . '
';
}
$mes = apply_filters( 'usces_filter_customer_check', $mes );
return $mes;
}
public function admin_new_member_check() {
global $wpdb;
$mes = $this->get_pwd_errors( $_POST['member']['password'] );
if ( ! is_email( trim( $_POST['member']['email'] ) ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
} else {
$member_table = usces_get_tablename( 'usces_member' );
$mem_email = $wpdb->get_var( $wpdb->prepare( "SELECT mem_email FROM $member_table WHERE ID = %d LIMIT 1", trim( $_POST['member_id'] ) ) );
if ( trim( $_POST['member']['email'] ) != $mem_email ) {
$mem_ID = $wpdb->get_var( $wpdb->prepare( "SELECT ID FROM $member_table WHERE mem_email = %s LIMIT 1", trim( $_POST['member']['email'] ) ) );
if ( ! empty( $mem_ID ) ) {
$mes .= __( 'This e-mail address has been already registered.', 'usces' ) . '
';
}
}
}
if ( WCUtils::is_blank( $_POST['member']['name1'] ) ) {
$mes .= __( 'Name is not correct', 'usces' ) . '
';
}
if ( ! WCUtils::is_blank( $_POST['member']['tel'] ) && preg_match( '/[^\d\-+]/', trim( $_POST['member']['tel'] ) ) ) {
$mes .= __( 'Please input a phone number with a half size number.', 'usces' ) . '
';
}
$mes = apply_filters( 'usces_filter_admin_member_check', $mes );
return $mes;
}
public function delivery_check() {
global $usces_settings;
do_action( 'usces_action_before_delivery_check' );
$mes = '';
if ( isset( $_POST['delivery']['delivery_flag'] ) && 1 === (int) $_POST['delivery']['delivery_flag'] ) {
if ( WCUtils::is_blank( $_POST['delivery']['name1'] ) ) {
$mes .= __( 'Name is not correct', 'usces' ) . '
';
}
$zip_check = false;
$addressform = $this->options['system']['addressform'];
$applyform = usces_get_apply_addressform( $addressform );
if ( 'JP' === $applyform ) {
if ( isset( $_POST['delivery']['country'] ) ) {
if ( 'JP' === $_POST['delivery']['country'] ) {
$zip_check = true;
}
} else {
$base = usces_get_base_country();
if ( 'JP' === $base ) {
$zip_check = true;
}
}
}
$zip_check = apply_filters( 'usces_filter_zipcode_check', $zip_check );
if ( WCUtils::is_blank( $_POST['delivery']['zipcode'] ) ) {
if ( usces_is_required_field( 'zipcode' ) ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
} else {
if ( $zip_check ) {
if ( ! preg_match( '/^[a-zA-Z0-9]+$/', $_POST['delivery']['zipcode'] ) ) {
$_SESSION['usces_entry']['delivery']['zipcode'] = usces_convert_zipcode( $_POST['delivery']['zipcode'] );
}
if ( ! preg_match( '/^(([0-9]{3}-[0-9]{4})|([0-9]{7}))$/', $_SESSION['usces_entry']['delivery']['zipcode'] ) ) {
$mes .= __( 'postal code is not correct', 'usces' ) . '
';
}
}
}
if ( ( __( '-- Select --', 'usces' ) == $_POST['delivery']['pref'] || '-- Select --' == $_POST['delivery']['pref'] ) && usces_is_required_field( 'states' ) ) {
$mes .= __( 'enter the prefecture', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['delivery']['address1'] ) && usces_is_required_field( 'address1' ) ) {
$mes .= __( 'enter the city name', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['delivery']['address2'] ) && usces_is_required_field( 'address2' ) ) {
$mes .= __( 'enter house numbers', 'usces' ) . '
';
}
if ( WCUtils::is_blank( $_POST['delivery']['tel'] ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'enter phone numbers', 'usces' ) . '
';
}
if ( ! WCUtils::is_blank( $_POST['delivery']['tel'] ) && preg_match( '/[^\d\-+]/', trim( $_POST['delivery']['tel'] ) ) && usces_is_required_field( 'tel' ) ) {
$mes .= __( 'Please input a phone number with a half size number.', 'usces' ) . '
';
}
$post_offer = filter_input( INPUT_POST, 'offer', FILTER_DEFAULT, FILTER_REQUIRE_ARRAY );
if ( ! empty( $post_offer['delivery_date'] ) && usces_is_date( $post_offer['delivery_date'] ) && isset( $post_offer['delivery_method'] ) ) {
$post_delivery = filter_input( INPUT_POST, 'delivery', FILTER_DEFAULT, FILTER_REQUIRE_ARRAY );
$deli_method_index = $this->get_delivery_method_index( $post_offer['delivery_method'] );
$delivery_days_id = isset( $this->options['delivery_method'][ $deli_method_index ]['days'] ) ? $this->options['delivery_method'][ $deli_method_index ]['days'] : -1;
if ( 0 <= $delivery_days_id ) {
$delivery_days_list = $this->options['delivery_days'];
$delivery_days = 0;
foreach ( (array) $delivery_days_list as $delivery_days_value ) {
if ( (int) $delivery_days_value['id'] === (int) $delivery_days_id ) {
$delivery_days = (int) $delivery_days_value[ $applyform ][ $post_delivery['pref'] ];
}
}
$sendout = usces_get_send_out_date();
$sendout_date = implode( '-', $sendout['sendout_date'] );
$arrival_date = new DateTime( $sendout_date );
$arrival_date->modify( '+' . $delivery_days . ' days' );
$offer_deli_date = new DateTime( $post_offer['delivery_date'] );
if ( $offer_deli_date < $arrival_date ) {
$mes .= __( 'Please re-specify the desired arrival date.', 'usces' ) . '
';
}
} else {
$mes .= __( 'Please re-specify the desired arrival date.', 'usces' ) . '
';
}
}
}
if ( ! isset( $_POST['offer']['delivery_method'] ) || ( empty( $_POST['offer']['delivery_method'] ) && ! WCUtils::is_zero( $_POST['offer']['delivery_method'] ) ) ) {
$mes .= __( 'chose one from delivery method.', 'usces' ) . '
';
} else {
$d_method_index = $this->get_delivery_method_index( (int) $_POST['offer']['delivery_method'] );
if ( 0 > $d_method_index ) {
$mes .= __( 'chose one from delivery method.', 'usces' ) . '
';
} elseif ( isset( $_SESSION['usces_entry']['delivery']['country'] ) ) {
$country = $_SESSION['usces_entry']['delivery']['country'];
$current_locate = get_locale();
$wplang = get_option( 'WPLANG', $current_locate );
$local_country = $usces_settings['lungage2country'][ $wplang ];
if ( $country == $local_country ) {
if ( 1 == $this->options['delivery_method'][ $d_method_index ]['intl'] ) {
$mes .= __( 'Delivery method is incorrect. Can not specify an international flight.', 'usces' ) . '
';
}
} else {
if ( WCUtils::is_zero( $this->options['delivery_method'][ $d_method_index ]['intl'] ) ) {
$mes .= __( 'Delivery method is incorrect. Specify the international flights.', 'usces' ) . '
';
}
}
}
}
if ( ! isset( $_POST['offer']['payment_name'] ) ) {
$mes .= __( 'chose one from payment options.', 'usces' ) . '
';
} else {
$payments = $this->getPayments( $_POST['offer']['payment_name'] );
if ( 'COD' == $payments['settlement'] ) {
$total_items_price = $this->get_total_price();
$usces_entries = $this->cart->get_entry();
$materials = array(
'total_items_price' => $usces_entries['order']['total_items_price'],
'discount' => ( isset( $usces_entries['order']['discount'] ) ) ? $usces_entries['order']['discount'] : 0,
'shipping_charge' => $usces_entries['order']['shipping_charge'],
'cod_fee' => $usces_entries['order']['cod_fee'],
'use_point' => ( isset( $usces_entries['order']['use_point'] ) ) ? $usces_entries['order']['use_point'] : 0,
);
$tax = $this->getTax( $total_items_price, $materials );
$total_items_price = $total_items_price + $tax;
$cod_limit_amount = ( isset( $this->options['cod_limit_amount'] ) && 0 < (int) $this->options['cod_limit_amount'] ) ? $this->options['cod_limit_amount'] : 0;
if ( 0 < $cod_limit_amount && $total_items_price > $cod_limit_amount ) {
$mes .= sprintf( __( 'A total products amount of money surpasses the upper limit(%s) that I can purchase in C.O.D.', 'usces' ), usces_crform( $this->options['cod_limit_amount'], true, false, 'return' ) ) . '
';
}
}
}
if ( isset( $d_method_index ) && isset( $payments ) ) {
if ( 1 == $this->options['delivery_method'][ $d_method_index ]['nocod'] ) {
if ( 'COD' == $payments['settlement'] ) {
$mes .= __( 'COD is not available.', 'usces' ) . '
';
}
}
}
$mes = apply_filters( 'usces_filter_delivery_check', $mes );
return $mes;
}
public function point_check( $entries ) {
$member = $this->get_member();
$this->set_cart_fees( $member, $entries );
$mes = '';
if ( isset( $_POST['offer']['usedpoint'] ) ) {
if ( WCUtils::is_blank( $_POST['offer']['usedpoint'] ) || ! preg_match( '/^[0-9]+$/', $_POST['offer']['usedpoint'] ) || (int) $_POST['offer']['usedpoint'] < 0 ) {
$mes .= __( 'Invalid value. Please enter in the numbers.', 'usces' ) . '
';
} else {
$payments = $this->getPayments( $entries['order']['payment_name'] );
$usedpoint = (int) trim( $_POST['offer']['usedpoint'] );
if ( $usedpoint > $member['point'] ) {
$mes .= __( 'You have exceeded the maximum available.', 'usces' ) . ' ' . __( 'Max', 'usces' ) . ' ' . $member['point'] . ' ' . __( 'points', 'usces' ) . '
';
} elseif ( 'acting_paypal_ec' == $payments['settlement'] ) {
$target_full_price = $entries['order']['total_items_price'] + $entries['order']['discount'] + $entries['order']['shipping_charge'] + $entries['order']['cod_fee'] + $entries['order']['tax'];
$target_item_price = $entries['order']['total_items_price'] + $entries['order']['discount'];
if ( 1 == $this->options['point_coverage'] && $usedpoint >= $target_full_price ) {
$target_item_price = $target_full_price;
} elseif ( 'products' == $this->options['tax_target'] ) {
$target_item_price += $entries['order']['tax'];
}
if ( $usedpoint > $target_item_price ) {
$mes .= __( "In the case of settlement method you choose, the upper limit of the point you'll find that will change. If you became a settlement error, please reduce the point that you want to use.", 'usces' ) . '
';
}
} else {
if ( 1 == $this->options['point_coverage'] ) {
$target_full_price = $entries['order']['total_items_price'] + $entries['order']['discount'] + $entries['order']['shipping_charge'] + $entries['order']['cod_fee'] + $entries['order']['tax'];
if ( $usedpoint > $target_full_price ) {
$mes .= __( 'You have exceeded the maximum available.', 'usces' ) . ' ' . __( 'Max', 'usces' ) . ' ' . $target_full_price . ' ' . __( 'points', 'usces' ) . '
';
}
} else {
$target_item_price = $entries['order']['total_items_price'] + $entries['order']['discount'];
if ( 'products' == $this->options['tax_target'] ) {
$target_item_price += $entries['order']['tax'];
}
if ( $usedpoint > $target_item_price ) {
$mes .= __( 'You have exceeded the maximum available.', 'usces' ) . ' ' . __( 'Max', 'usces' ) . ' ' . $target_item_price . ' ' . __( 'points', 'usces' ) . '
';
}
}
}
$mes = apply_filters( 'usces_filter_point_check', $mes );
if ( '' != $mes ) {
$_POST['offer']['usedpoint'] = 0;
$array = array(
'usedpoint' => 0,
);
$this->cart->set_order_entry( $array );
}
}
}
$mes = apply_filters( 'usces_filter_point_check_last', $mes );
return $mes;
}
public function lostpass_mailaddcheck() {
$mes = '';
if ( ! is_email( $_POST['loginmail'] ) || WCUtils::is_blank( $_POST['loginmail'] ) ) {
$mes .= __( 'e-mail address is not correct', 'usces' ) . '
';
}
return $mes;
}
public function changepass_check() {
$mes = $this->get_pwd_errors( $_POST['loginpass1'] );
if ( trim( $_POST['loginpass1'] ) != trim( $_POST['loginpass2'] ) ) {
$mes .= __( 'Password confirm does not match.', 'usces' ) . '
';
}
return $mes;
}
public function get_page() {
return $this->page;
}
public function check_display_mode() {
$options = get_option( 'usces' );
if ( isset( $options['display_mode'] ) && 'Maintenancemode' == $options['display_mode'] ) {
return;
}
$start['hour'] = empty( $options['campaign_schedule']['start']['hour'] ) ? 0 : $options['campaign_schedule']['start']['hour'];
$start['min'] = empty( $options['campaign_schedule']['start']['min'] ) ? 0 : $options['campaign_schedule']['start']['min'];
$start['month'] = empty( $options['campaign_schedule']['start']['month'] ) ? 0 : $options['campaign_schedule']['start']['month'];
$start['day'] = empty( $options['campaign_schedule']['start']['day'] ) ? 0 : $options['campaign_schedule']['start']['day'];
$start['year'] = empty( $options['campaign_schedule']['start']['year'] ) ? 0 : $options['campaign_schedule']['start']['year'];
$end['hour'] = empty( $options['campaign_schedule']['end']['hour'] ) ? 0 : $options['campaign_schedule']['end']['hour'];
$end['min'] = empty( $options['campaign_schedule']['end']['min'] ) ? 0 : $options['campaign_schedule']['end']['min'];
$end['month'] = empty( $options['campaign_schedule']['end']['month'] ) ? 0 : $options['campaign_schedule']['end']['month'];
$end['day'] = empty( $options['campaign_schedule']['end']['day'] ) ? 0 : $options['campaign_schedule']['end']['day'];
$end['year'] = empty( $options['campaign_schedule']['end']['year'] ) ? 0 : $options['campaign_schedule']['end']['year'];
$starttime = mktime( $start['hour'], $start['min'], 0, $start['month'], $start['day'], $start['year'] );
$endtime = mktime( $end['hour'], $end['min'], 0, $end['month'], $end['day'], $end['year'] );
$current_time = current_time( 'timestamp' );
if ( ( $current_time >= $starttime ) && ( $current_time <= $endtime ) ) {
$options['display_mode'] = 'Promotionsale';
} else {
$options['display_mode'] = 'Usualsale';
}
update_option( 'usces', $options );
}
public function update_business_days() {
$options = get_option( 'usces' );
$datetimestr = get_date_from_gmt( gmdate( 'Y-m-d H:i:s', time() ) );
$dhour = (int) substr( $datetimestr, 11, 2 );
$dminute = (int) substr( $datetimestr, 14, 2 );
$dsecond = (int) substr( $datetimestr, 17, 2 );
$dmonth = (int) substr( $datetimestr, 5, 2 );
$dday = (int) substr( $datetimestr, 8, 2 );
$dyear = (int) substr( $datetimestr, 0, 4 );
$dtimestamp = mktime( $dhour, $dminute, $dsecond, $dmonth, $dday, $dyear );
$datenow = getdate( $dtimestamp );
list( $year, $mon, $mday ) = getBeforeMonth( $datenow['year'], $datenow['mon'], 1, 1 );
if ( isset( $options['business_days'][ $year ][ $mon ][1] ) ) {
unset( $options['business_days'][ $year ][ $mon ] );
}
for ( $i = 0; $i < 12; $i++ ) {
list( $year, $mon, $mday ) = getAfterMonth( $datenow['year'], $datenow['mon'], 1, $i );
$last = getLastDay( $year, $mon );
for ( $j = 1; $j <= $last; $j++ ) {
if ( ! isset( $options['business_days'][ $year ][ $mon ][ $j ] ) ) {
$options['business_days'][ $year ][ $mon ][ $j ] = 1;
}
}
}
update_option( 'usces', $options );
$this->options = get_option( 'usces' );
$_SESSION['usces_checked_business_days'] = '';
}
public function display_cart() {
if ( $this->cart->num_row() > 0 ) {
// include (USCES_PLUGIN_DIR . '/includes/cart_table.php');
} else {
echo "" . __( 'There are no items in your cart.', 'usces' ) . "
\n";
}
}
public function display_cart_confirm() {
if ( $this->cart->num_row() > 0 ) {
// include (USCES_PLUGIN_DIR . '/includes/cart_confirm.php');
} else {
echo "" . __( 'There are no items in your cart.', 'usces' ) . "
\n";
}
}
public function set_initial() {
$this->set_default_page();
$this->set_default_categories();
$this->create_table();
$this->update_table();
$rets07 = usces_upgrade_07();
if ( $rets07 ) {
$rets11 = usces_upgrade_11();
}
if ( $rets11 ) {
$rets14 = usces_upgrade_14();
}
if ( $rets14 ) {
$rets141 = usces_upgrade_141();
}
if ( $rets141 ) {
$rets143 = usces_upgrade_143();
}
$this->update_options();
usces_schedule_event();
do_action( 'usces_on_plugin_activate' );
}
public function deactivate() {
wp_clear_scheduled_hook( 'wc_cron' );
wp_clear_scheduled_hook( 'wc_cron_w' );
usces_wcsite_deactivate();
}
public function create_table() {
global $wpdb;
if ( ! empty( $wpdb->charset ) ) {
$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
}
if ( ! empty( $wpdb->collate ) ) {
$charset_collate .= " COLLATE $wpdb->collate";
}
$access_table = $wpdb->prefix . 'usces_access';
$member_table = $wpdb->prefix . 'usces_member';
$member_meta_table = $wpdb->prefix . 'usces_member_meta';
$order_table = $wpdb->prefix . 'usces_order';
$order_meta_table = $wpdb->prefix . 'usces_order_meta';
$ordercart_table = $wpdb->prefix . 'usces_ordercart';
$ordercart_meta_table = $wpdb->prefix . 'usces_ordercart_meta';
$log_table = $wpdb->prefix . 'usces_log';
$acting_log_table = $wpdb->prefix . 'usces_acting_log';
$item_table = $wpdb->prefix . 'usces_item';
$sku_table = $wpdb->prefix . 'usces_skus';
$opt_table = $wpdb->prefix . 'usces_opts';
$admin_log_table = $wpdb->prefix . 'usces_admin_log';
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
if ( $wpdb->get_var( "SHOW TABLES LIKE '$access_table'" ) != $access_table ) {
$sql = 'CREATE TABLE ' . $access_table . " (
ID BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT,
acc_key VARCHAR( 50 ) NOT NULL ,
acc_type VARCHAR( 50 ) NULL ,
acc_value LONGTEXT NULL ,
acc_date DATE NOT NULL DEFAULT '0000-00-00',
acc_num1 INT( 11 ) NOT NULL DEFAULT 0,
acc_num2 INT( 11 ) NOT NULL DEFAULT 0,
acc_str1 VARCHAR( 200 ) NULL ,
acc_str2 VARCHAR( 200 ) NULL ,
PRIMARY KEY (`ID`),
KEY acc_key ( acc_key ),
KEY acc_type ( acc_type ),
KEY acc_date ( acc_date ),
KEY acc_num1 ( acc_num1 ),
KEY acc_num2 ( acc_num2 )
) AUTO_INCREMENT=0 $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_access', USCES_DB_ACCESS );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$member_table'" ) != $member_table ) {
$sql = 'CREATE TABLE ' . $member_table . " (
ID BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT,
mem_email VARCHAR( 100 ) NOT NULL ,
mem_pass VARCHAR( 64 ) NOT NULL ,
mem_status INT( 11 ) NOT NULL DEFAULT '0',
mem_cookie VARCHAR( 13 ) NULL ,
mem_point INT( 11 ) NOT NULL DEFAULT '0',
mem_name1 VARCHAR( 100 ) NOT NULL ,
mem_name2 VARCHAR( 100 ) NULL ,
mem_name3 VARCHAR( 100 ) NULL ,
mem_name4 VARCHAR( 100 ) NULL ,
mem_zip VARCHAR( 50 ) NULL ,
mem_pref VARCHAR( 100 ) NOT NULL ,
mem_address1 VARCHAR( 100 ) NOT NULL ,
mem_address2 VARCHAR( 100 ) NULL ,
mem_address3 VARCHAR( 100 ) NULL ,
mem_tel VARCHAR( 100 ) NOT NULL ,
mem_fax VARCHAR( 100 ) NULL ,
mem_delivery_flag TINYINT ( 1 ) NULL ,
mem_delivery LONGTEXT,
mem_registered DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
mem_nicename VARCHAR( 50 ) NULL ,
PRIMARY KEY (`ID`),
KEY mem_email ( mem_email ) ,
KEY mem_pass ( mem_pass )
) AUTO_INCREMENT=1000 $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_member', USCES_DB_MEMBER );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$member_meta_table'" ) != $member_meta_table ) {
$sql = 'CREATE TABLE ' . $member_meta_table . " (
mmeta_id bigint(20) NOT NULL auto_increment,
member_id bigint(20) NOT NULL default '0',
meta_key varchar(255) default NULL,
meta_value longtext,
PRIMARY KEY (mmeta_id),
KEY order_id (member_id),
KEY meta_key (meta_key(191))
) $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_member_meta', USCES_DB_MEMBER_META );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$order_table'" ) != $order_table ) {
$sql = 'CREATE TABLE ' . $order_table . " (
ID BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT,
mem_id BIGINT( 20 ) UNSIGNED NULL ,
order_email VARCHAR( 100 ) NOT NULL ,
order_name1 VARCHAR( 100 ) NOT NULL ,
order_name2 VARCHAR( 100 ) NULL ,
order_name3 VARCHAR( 100 ) NULL ,
order_name4 VARCHAR( 100 ) NULL ,
order_zip VARCHAR( 50 ) NULL ,
order_pref VARCHAR( 100 ) NOT NULL ,
order_address1 VARCHAR( 100 ) NOT NULL ,
order_address2 VARCHAR( 100 ) NULL ,
order_address3 VARCHAR( 100 ) NULL ,
order_tel VARCHAR( 100 ) NOT NULL ,
order_fax VARCHAR( 100 ) NULL ,
order_delivery LONGTEXT,
order_cart LONGTEXT,
order_note TEXT,
order_delivery_time VARCHAR( 100 ) NOT NULL ,
order_payment_name VARCHAR( 100 ) NOT NULL ,
order_condition TEXT,
order_item_total_price DECIMAL( 10, 2 ) NOT NULL DEFAULT '0.00',
order_getpoint INT( 10 ) NOT NULL DEFAULT '0',
order_usedpoint INT( 10 ) NOT NULL DEFAULT '0',
order_discount DECIMAL( 10, 2 ) NOT NULL DEFAULT '0.00',
order_shipping_charge DECIMAL( 10, 2 ) NOT NULL DEFAULT '0.00',
order_cod_fee DECIMAL( 10, 2 ) NOT NULL DEFAULT '0.00',
order_tax DECIMAL( 10, 2 ) NOT NULL DEFAULT '0.00',
order_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
order_modified VARCHAR( 20 ) NULL ,
order_status VARCHAR( 255 ) NULL ,
order_check TEXT NULL ,
order_delidue_date VARCHAR( 30 ) NULL ,
order_delivery_method INT( 10 ) NOT NULL DEFAULT -1,
order_delivery_date VARCHAR( 100 ) NULL,
PRIMARY KEY (`ID`),
KEY order_email ( order_email ) ,
KEY order_name1 ( order_name1 ) ,
KEY order_name2 ( order_name2 ) ,
KEY order_pref ( order_pref ) ,
KEY order_address1 ( order_address1 ) ,
KEY order_tel ( order_tel ) ,
KEY mem_id ( mem_id ) ,
KEY order_date ( order_date )
) AUTO_INCREMENT=1000 $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_order', USCES_DB_ORDER );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$order_meta_table'" ) != $order_meta_table ) {
$sql = 'CREATE TABLE ' . $order_meta_table . " (
ometa_id bigint(20) NOT NULL auto_increment,
order_id bigint(20) NOT NULL default '0',
meta_key varchar(255) default NULL,
meta_value longtext,
PRIMARY KEY (ometa_id),
KEY order_id (order_id),
KEY meta_key (meta_key(191))
) $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_order_meta', USCES_DB_ORDER_META );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$ordercart_table'" ) != $ordercart_table ) {
$sql = 'CREATE TABLE ' . $ordercart_table . " (
`cart_id` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`order_id` bigint( 20 ) NOT NULL ,
`group_id` int( 3 ) NOT NULL DEFAULT '0',
`row_index` int( 3 ) NOT NULL ,
`post_id` bigint( 20 ) NOT NULL ,
`item_code` varchar( 100 ) NOT NULL ,
`item_name` varchar( 250 ) NOT NULL ,
`cprice` decimal( 12, 0 ) DEFAULT NULL ,
`sku_code` varchar( 100 ) NOT NULL ,
`sku_name` varchar( 250 ) DEFAULT NULL ,
`price` decimal( 12, 0 ) NOT NULL ,
`quantity` float NOT NULL ,
`unit` varchar( 50 ) DEFAULT NULL ,
`tax` decimal( 10, 0 ) DEFAULT NULL ,
`destination_id` int( 10 ) DEFAULT NULL ,
`cart_serial` text,
PRIMARY KEY ( `cart_id` ) ,
UNIQUE KEY `row` ( `row_index` , `destination_id` , `order_id` ) ,
KEY `order_id` ( `order_id` ) ,
KEY `post_id` ( `post_id` ) ,
KEY `item_code` ( `item_code` ) ,
KEY `item_name` ( `item_name`(191) ) ,
KEY `sku_code` ( `sku_code` ) ,
KEY `sku_name` ( `sku_name`(191) )
) AUTO_INCREMENT=1000 $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_ordercart', USCES_DB_ORDERCART );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$ordercart_meta_table'" ) != $ordercart_meta_table ) {
$sql = 'CREATE TABLE ' . $ordercart_meta_table . " (
`cartmeta_id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`cart_id` bigint( 20 ) NOT NULL DEFAULT '0',
`meta_type` varchar( 100 ) NOT NULL ,
`meta_key` varchar( 255 ) DEFAULT NULL ,
`meta_value` longtext,
PRIMARY KEY ( `cartmeta_id` ) ,
KEY `cart_id` ( `cart_id` ) ,
KEY `meta_key` ( `meta_key`(191) )
) $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_ordercart_meta', USCES_DB_ORDERCART_META );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$log_table'") != $log_table ) {
$sql = 'CREATE TABLE ' . $log_table . " (
ID BIGINT( 20 ) NOT NULL AUTO_INCREMENT,
datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
log LONGTEXT NULL,
log_type VARCHAR( 100 ) DEFAULT NULL,
log_key VARCHAR( 255 ) DEFAULT NULL,
PRIMARY KEY ( ID ) ,
KEY datetime ( datetime ),
KEY log_type ( log_type ),
KEY log_key ( log_key(191) )
) $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_log', USCES_DB_LOG );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '$acting_log_table'" ) != $acting_log_table ) {
$sql = 'CREATE TABLE ' . $acting_log_table . " (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`log` LONGTEXT NULL,
`acting` CHAR(32) DEFAULT NULL,
`status` CHAR(32) DEFAULT NULL,
`result` CHAR(32) DEFAULT NULL,
`amount` DECIMAL( 10, 2 ) DEFAULT NULL,
`order_id` BIGINT(20) NOT NULL,
`tracking_id` CHAR(32) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `datetime` (`datetime`),
KEY `order_id` (`order_id`),
KEY `tracking_id` (`tracking_id`),
KEY `history_key` (`order_id`,`tracking_id`)
) $charset_collate;";
dbDelta( $sql );
add_option( 'usces_db_acting_log', USCES_DB_ACTING_LOG );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '{$item_table}'" ) !== $item_table ) {
$sql = 'CREATE TABLE ' . $item_table . ' (
post_id BIGINT( 20 ) UNSIGNED NOT NULL,
itemCode VARCHAR( 200 ) NULL ,
itemName VARCHAR( 250 ) NULL ,
itemRestriction VARCHAR( 20 ) NULL ,
itemPointrate VARCHAR( 20 ) NULL ,
itemGpNum1 VARCHAR( 20 ) NULL ,
itemGpNum2 VARCHAR( 20 ) NULL ,
itemGpNum3 VARCHAR( 20 ) NULL ,
itemGpDis1 VARCHAR( 20 ) NULL ,
itemGpDis2 VARCHAR( 20 ) NULL ,
itemGpDis3 VARCHAR( 20 ) NULL ,
itemOrderAcceptable INT( 2 ) NULL ,
itemShipping INT( 3 ) NULL ,
itemDeliveryMethod LONGTEXT ,
itemShippingCharge VARCHAR( 200 ) NULL ,
itemIndividualSCharge VARCHAR( 20 ) NULL ,
item_charging_type INT( 3 ) NULL ,
item_division VARCHAR( 50 ) NULL ,
dlseller_date VARCHAR( 100 ) NULL ,
dlseller_file VARCHAR( 200 ) NULL ,
dlseller_interval VARCHAR( 20 ) NULL ,
dlseller_validity VARCHAR( 20 ) NULL ,
dlseller_version VARCHAR( 100 ) NULL ,
dlseller_author VARCHAR( 200 ) NULL ,
dlseller_purchases VARCHAR( 20 ) NULL ,
dlseller_downloads VARCHAR( 20 ) NULL ,
item_chargingday VARCHAR( 20 ) NULL ,
item_frequency VARCHAR( 20 ) NULL ,
wcad_regular_unit VARCHAR( 20 ) NULL ,
wcad_regular_interval INT( 10 ) NULL ,
wcad_regular_frequency INT( 10 ) NULL ,
select_sku_switch INT( 10 ) NULL ,
select_sku_display INT( 10 ) NULL ,
select_sku LONGTEXT ,
atobarai_propriety INT( 5 ) NULL ,
atodene_propriety INT( 5 ) NULL ,
structuredDataSku VARCHAR( 200 ) NULL ,
lower_limit INT( 10 ) NULL ,
popularity INT( 10 ) NULL ,
main_price DECIMAL( 10, 2 ) NULL ,
itemPicts TEXT NULL ,
itemAdvanced LONGTEXT NULL ,
PRIMARY KEY (`post_id`),
KEY itemCode ( itemCode ) ,
KEY itemName ( itemName )
) ' . $charset_collate . ';';
dbDelta( $sql );
add_option( 'usces_db_item', USCES_DB_ITEM );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '{$sku_table}'" ) !== $sku_table ) {
$sql = 'CREATE TABLE ' . $sku_table . ' (
meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT( 20 ) UNSIGNED NOT NULL ,
code VARCHAR( 200 ) NULL ,
name VARCHAR( 250 ) NULL ,
cprice DECIMAL( 10, 2 ) NULL ,
price DECIMAL( 10, 2 ) NULL ,
unit TEXT NULL ,
stocknum VARCHAR( 50 ) NULL ,
stock INT( 5 ) NULL ,
gp INT( 2 ) NULL ,
taxrate VARCHAR( 20 ) NULL ,
size VARCHAR( 20 ) NULL ,
weight VARCHAR( 20 ) NULL ,
pict_id VARCHAR( 20 ) NULL ,
advance LONGTEXT ,
paternkey VARCHAR( 100 ) NULL ,
sort INT( 5 ) NULL ,
PRIMARY KEY (`meta_id`),
KEY post_id ( post_id ) ,
KEY code ( code ) ,
KEY name ( name ) ,
KEY price ( price ) ,
KEY paternkey ( paternkey )
) ' . $charset_collate . ';';
dbDelta( $sql );
add_option( 'usces_db_skus', USCES_DB_SKUS );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '{$opt_table}'" ) !== $opt_table ) {
$sql = 'CREATE TABLE ' . $opt_table . ' (
meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT( 20 ) UNSIGNED NOT NULL ,
code VARCHAR( 200 ) NULL ,
name VARCHAR( 250 ) NULL ,
means INT( 3 ) NULL ,
essential INT( 3 ) NULL ,
value TEXT ,
sort INT( 5 ) NULL ,
PRIMARY KEY (`meta_id`),
KEY post_id ( post_id ) ,
KEY code ( code ) ,
KEY name ( name )
) ' . $charset_collate . ';';
dbDelta( $sql );
add_option( 'usces_db_opts', USCES_DB_OPTS );
}
if ( $wpdb->get_var( "SHOW TABLES LIKE '{$admin_log_table}'" ) !== $admin_log_table ) {
$sql = "CREATE TABLE {$admin_log_table} (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`author` varchar(64) NOT NULL,
`message` longtext NOT NULL,
`screen` varchar(64) NOT NULL,
`entity_id` varchar(64) DEFAULT NULL,
`action` varchar(64) NOT NULL,
`data` longblob DEFAULT NULL,
`datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`ID`),
KEY entity_id ( entity_id )
) " . $charset_collate . ';';
dbDelta( $sql );
add_option( 'usces_db_admin_log', USCES_DB_ADMIN_LOG );
}
do_action( 'usces_action_create_table' );
}
public function update_table() {
global $wpdb;
$access_table = $wpdb->prefix . 'usces_access';
$member_table = $wpdb->prefix . 'usces_member';
$member_meta_table = $wpdb->prefix . 'usces_member_meta';
$order_table = $wpdb->prefix . 'usces_order';
$order_meta_table = $wpdb->prefix . 'usces_order_meta';
$ordercart_table = $wpdb->prefix . 'usces_ordercart';
$ordercart_meta_table = $wpdb->prefix . 'usces_ordercart_meta';
$log_table = $wpdb->prefix . 'usces_log';
$acting_log_table = $wpdb->prefix . 'usces_acting_log';
$item_table = $wpdb->prefix . 'usces_item';
$sku_table = $wpdb->prefix . 'usces_skus';
$opt_table = $wpdb->prefix . 'usces_opts';
$admin_log_table = $wpdb->prefix . 'usces_admin_log';
$access_ver = get_option( 'usces_db_access' );
$member_ver = get_option( 'usces_db_member' );
$member_meta_ver = get_option( 'usces_db_member_meta' );
$order_ver = get_option( 'usces_db_order' );
$order_meta_ver = get_option( 'usces_db_order_meta' );
$ordercart_ver = get_option( 'usces_db_ordercart' );
$ordercart_meta_ver = get_option( 'usces_db_ordercart_meta' );
$log_ver = get_option( 'usces_db_log' );
$acting_log_ver = get_option( 'usces_db_acting_log' );
$db_item = get_option( 'usces_db_item' );
$db_skus = get_option( 'usces_db_skus' );
$db_opts = get_option( 'usces_db_opts' );
$db_admin_log = get_option( 'usces_db_admin_log' );
if ( $access_ver != USCES_DB_ACCESS ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $access_table . " (
ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
acc_key VARCHAR(50) NOT NULL ,
acc_type VARCHAR(50) NULL ,
acc_value LONGTEXT NULL ,
acc_date DATE NOT NULL DEFAULT '0000-00-00',
acc_num1 INT(11) NOT NULL DEFAULT 0,
acc_num2 INT(11) NOT NULL DEFAULT 0,
acc_str1 VARCHAR(200) NULL ,
acc_str2 VARCHAR(200) NULL ,
PRIMARY KEY (`ID`),
KEY acc_key (acc_key),
KEY acc_type (acc_type),
KEY acc_date (acc_date),
KEY acc_num1 (acc_num1),
KEY acc_num2 (acc_num2)
);";
dbDelta( $sql );
update_option( 'usces_db_access', USCES_DB_ACCESS );
}
if ( USCES_DB_MEMBER != $member_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $member_table . " (
ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
mem_email VARCHAR(100) NOT NULL ,
mem_pass VARCHAR(64) NOT NULL ,
mem_status INT(11) NOT NULL DEFAULT '0',
mem_cookie VARCHAR(13) NULL ,
mem_point INT(11) NOT NULL DEFAULT '0',
mem_name1 VARCHAR(100) NOT NULL ,
mem_name2 VARCHAR(100) NULL ,
mem_name3 VARCHAR(100) NULL ,
mem_name4 VARCHAR(100) NULL ,
mem_zip VARCHAR(50) NULL ,
mem_pref VARCHAR(100) NOT NULL ,
mem_address1 VARCHAR(100) NOT NULL ,
mem_address2 VARCHAR(100) NULL ,
mem_address3 VARCHAR(100) NULL ,
mem_tel VARCHAR(100) NOT NULL ,
mem_fax VARCHAR(100) NULL ,
mem_delivery_flag TINYINT (1) NULL ,
mem_delivery LONGTEXT,
mem_registered DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
mem_nicename VARCHAR(50) NULL ,
PRIMARY KEY (`ID`),
KEY mem_email (mem_email) ,
KEY mem_pass (mem_pass)
);";
dbDelta( $sql );
update_option( 'usces_db_member', USCES_DB_MEMBER );
}
if ( USCES_DB_MEMBER_META != $member_meta_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $member_meta_table . " (
mmeta_id bigint(20) NOT NULL auto_increment,
member_id bigint(20) NOT NULL default '0',
meta_key varchar(255) default NULL,
meta_value longtext,
PRIMARY KEY (`mmeta_id`),
KEY order_id (member_id),
KEY meta_key (meta_key(191))
);";
dbDelta( $sql );
update_option( 'usces_db_member_meta', USCES_DB_MEMBER_META );
}
if ( USCES_DB_ORDER != $order_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $order_table . " (
ID bigint(20) unsigned NOT NULL auto_increment,
mem_id BIGINT(20) UNSIGNED NULL,
order_email VARCHAR(100) NOT NULL,
order_name1 VARCHAR(100) NOT NULL,
order_name2 VARCHAR(100) NULL,
order_name3 VARCHAR(100) NULL,
order_name4 VARCHAR(100) NULL,
order_zip VARCHAR(50) NULL,
order_pref VARCHAR(100) NOT NULL,
order_address1 VARCHAR(100) NOT NULL,
order_address2 VARCHAR(100) NULL,
order_address3 VARCHAR(100) NULL,
order_tel VARCHAR(100) NOT NULL,
order_fax VARCHAR(100) NULL,
order_delivery LONGTEXT,
order_cart LONGTEXT,
order_note TEXT,
order_delivery_time VARCHAR(100) NOT NULL,
order_payment_name VARCHAR(100) NOT NULL,
order_condition TEXT,
order_item_total_price DECIMAL(10,2) NOT NULL DEFAULT '0.00',
order_getpoint INT(10) NOT NULL DEFAULT '0',
order_usedpoint INT(10) NOT NULL DEFAULT '0',
order_discount DECIMAL(10,2) NOT NULL DEFAULT '0.00',
order_shipping_charge DECIMAL(10,2) NOT NULL DEFAULT '0.00',
order_cod_fee DECIMAL(10,2) NOT NULL DEFAULT '0.00',
order_tax DECIMAL(10,2) NOT NULL DEFAULT '0.00',
order_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
order_modified VARCHAR(20) NULL,
order_status VARCHAR(255) NULL,
order_check TEXT NULL,
order_delidue_date VARCHAR(30) NULL,
order_delivery_method INT(10) NOT NULL DEFAULT -1,
order_delivery_date VARCHAR(100) NULL,
PRIMARY KEY (`ID`),
KEY order_email (order_email),
KEY order_name1 (order_name1),
KEY order_name2 (order_name2),
KEY order_pref (order_pref),
KEY order_address1 (order_address1),
KEY order_tel (order_tel),
KEY mem_id ( mem_id ) ,
KEY order_date (order_date)
);";
dbDelta( $sql );
update_option( 'usces_db_order', USCES_DB_ORDER );
}
if ( USCES_DB_ORDER_META != $order_meta_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $order_meta_table . " (
ometa_id bigint(20) NOT NULL auto_increment,
order_id bigint(20) NOT NULL default '0',
meta_key varchar(255) default NULL,
meta_value longtext,
PRIMARY KEY (`ometa_id`),
KEY order_id (order_id),
KEY meta_key (meta_key)
);";
dbDelta( $sql );
update_option( 'usces_db_order_meta', USCES_DB_ORDER_META );
}
if ( USCES_DB_ORDERCART != $ordercart_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $ordercart_table . " (
cart_id bigint(20) unsigned NOT NULL AUTO_INCREMENT ,
order_id bigint(20) NOT NULL ,
group_id int(3) NOT NULL DEFAULT '0',
row_index int(3) NOT NULL ,
post_id bigint(20) NOT NULL ,
item_code varchar(100) NOT NULL ,
item_name varchar(250) NOT NULL ,
cprice decimal(12,0) DEFAULT NULL ,
sku_code varchar(100) NOT NULL ,
sku_name varchar(250) DEFAULT NULL ,
price decimal(12,0) NOT NULL ,
quantity float NOT NULL ,
unit varchar(50) DEFAULT NULL ,
tax decimal(10,0) DEFAULT NULL ,
destination_id int(10) DEFAULT NULL ,
cart_serial text,
UNIQUE KEY row (row_index,destination_id,order_id) ,
PRIMARY KEY (`cart_id`),
KEY order_id (order_id) ,
KEY post_id (post_id) ,
KEY item_code (item_code) ,
KEY item_name (item_name(191)) ,
KEY sku_code (sku_code) ,
KEY sku_name (sku_name(191))
);";
dbDelta( $sql );
update_option( 'usces_db_ordercart', USCES_DB_ORDERCART );
}
if ( USCES_DB_ORDERCART_META != $ordercart_meta_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $ordercart_meta_table . " (
cartmeta_id bigint(20) NOT NULL AUTO_INCREMENT,
cart_id bigint(20) NOT NULL DEFAULT '0',
meta_type varchar(100) NOT NULL ,
meta_key varchar(255) DEFAULT NULL ,
meta_value longtext,
PRIMARY KEY (`cartmeta_id`),
KEY cart_id (cart_id) ,
KEY meta_key (meta_key(191))
);";
dbDelta( $sql );
update_option( 'usces_db_ordercart_meta', USCES_DB_ORDERCART_META );
}
if ( USCES_DB_LOG != $log_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $log_table . " (
ID bigint(20) NOT NULL AUTO_INCREMENT,
datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
log LONGTEXT NULL,
log_type VARCHAR(100) DEFAULT NULL,
log_key VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY datetime (datetime),
KEY log_type (log_type),
KEY log_key (log_key(191))
);";
dbDelta( $sql );
update_option( 'usces_db_log', USCES_DB_LOG );
}
if ( USCES_DB_ACTING_LOG != $acting_log_ver ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $acting_log_table . " (
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`log` LONGTEXT NULL,
`acting` CHAR(32) DEFAULT NULL,
`status` CHAR(32) DEFAULT NULL,
`result` CHAR(32) DEFAULT NULL,
`amount` DECIMAL( 10, 2 ) DEFAULT NULL,
`order_id` BIGINT(20) NOT NULL,
`tracking_id` CHAR(32) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `datetime` (`datetime`),
KEY `order_id` (`order_id`),
KEY `tracking_id` (`tracking_id`),
KEY `history_key` (`order_id`,`tracking_id`)
);";
dbDelta( $sql );
update_option( 'usces_db_acting_log', USCES_DB_ACTING_LOG );
}
if ( USCES_DB_ITEM != $db_item ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $item_table . ' (
post_id BIGINT( 20 ) UNSIGNED NOT NULL ,
itemCode VARCHAR( 200 ) NULL ,
itemName VARCHAR( 250 ) NULL ,
itemRestriction VARCHAR( 20 ) NULL ,
itemPointrate VARCHAR( 20 ) NULL ,
itemGpNum1 VARCHAR( 20 ) NULL ,
itemGpNum2 VARCHAR( 20 ) NULL ,
itemGpNum3 VARCHAR( 20 ) NULL ,
itemGpDis1 VARCHAR( 20 ) NULL ,
itemGpDis2 VARCHAR( 20 ) NULL ,
itemGpDis3 VARCHAR( 20 ) NULL ,
itemOrderAcceptable INT( 2 ) NULL ,
itemShipping INT( 3 ) NULL ,
itemDeliveryMethod LONGTEXT ,
itemShippingCharge VARCHAR( 200 ) NULL ,
itemIndividualSCharge VARCHAR( 20 ) NULL ,
item_charging_type INT( 3 ) NULL ,
item_division VARCHAR( 50 ) NULL ,
dlseller_date VARCHAR( 100 ) NULL ,
dlseller_file VARCHAR( 200 ) NULL ,
dlseller_interval VARCHAR( 20 ) NULL ,
dlseller_validity VARCHAR( 20 ) NULL ,
dlseller_version VARCHAR( 100 ) NULL ,
dlseller_author VARCHAR( 200 ) NULL ,
dlseller_purchases VARCHAR( 20 ) NULL ,
dlseller_downloads VARCHAR( 20 ) NULL ,
item_chargingday VARCHAR( 20 ) NULL ,
item_frequency VARCHAR( 20 ) NULL ,
wcad_regular_unit VARCHAR( 20 ) NULL ,
wcad_regular_interval INT( 10 ) NULL ,
wcad_regular_frequency INT( 10 ) NULL ,
select_sku_switch INT( 10 ) NULL ,
select_sku_display INT( 10 ) NULL ,
select_sku LONGTEXT ,
atobarai_propriety INT( 5 ) NULL ,
atodene_propriety INT( 5 ) NULL ,
structuredDataSku VARCHAR( 200 ) NULL ,
lower_limit INT( 10 ) NULL ,
popularity INT( 10 ) NULL ,
main_price DECIMAL( 10, 2 ) NULL ,
itemPicts TEXT NULL ,
itemAdvanced LONGTEXT NULL ,
PRIMARY KEY (`post_id`),
KEY itemCode ( itemCode ) ,
KEY itemName ( itemName )
);';
dbDelta( $sql );
update_option( 'usces_db_item', USCES_DB_ITEM );
}
if ( USCES_DB_SKUS != $db_skus ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $sku_table . ' (
meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
post_id BIGINT( 20 ) UNSIGNED NOT NULL ,
code VARCHAR( 200 ) NULL ,
name VARCHAR( 250 ) NULL ,
cprice DECIMAL( 10, 2 ) NULL ,
price DECIMAL( 10, 2 ) NULL ,
unit TEXT NULL ,
stocknum VARCHAR( 50 ) NULL ,
stock INT( 5 ) NULL ,
gp INT( 2 ) NULL ,
taxrate VARCHAR( 20 ) NULL ,
size VARCHAR( 20 ) NULL ,
weight VARCHAR( 20 ) NULL ,
pict_id VARCHAR( 20 ) NULL ,
advance LONGTEXT ,
paternkey VARCHAR( 100 ) NULL ,
sort INT( 5 ) NULL ,
PRIMARY KEY (`meta_id`),
KEY post_id ( post_id ) ,
KEY code ( code ) ,
KEY name ( name ) ,
KEY price ( price ) ,
KEY paternkey ( paternkey )
);';
dbDelta( $sql );
update_option( 'usces_db_skus', USCES_DB_SKUS );
}
if ( USCES_DB_OPTS != $db_opts ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = 'CREATE TABLE ' . $opt_table . ' (
meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
post_id BIGINT( 20 ) UNSIGNED NOT NULL ,
code VARCHAR( 200 ) NULL ,
name VARCHAR( 250 ) NULL ,
means INT( 3 ) NULL ,
essential INT( 3 ) NULL ,
value TEXT ,
sort INT( 5 ) NULL ,
PRIMARY KEY (`meta_id`),
KEY post_id ( post_id ) ,
KEY code ( code ) ,
KEY name ( name )
);';
dbDelta( $sql );
update_option( 'usces_db_opts', USCES_DB_OPTS );
}
if ( USCES_DB_ADMIN_LOG != $db_admin_log ) {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql = "CREATE TABLE {$admin_log_table} (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`author` varchar(64) NOT NULL,
`message` longtext NOT NULL,
`screen` varchar(64) NOT NULL,
`entity_id` varchar(64) DEFAULT NULL,
`action` varchar(64) NOT NULL,
`data` longblob DEFAULT NULL,
`datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`ID`),
KEY entity_id ( entity_id )
);";
dbDelta( $sql );
update_option( 'usces_db_admin_log', USCES_DB_ADMIN_LOG );
}
do_action( 'usces_action_update_table' );
}
public function dir_copy( $source, $dest ) {
if ( $res = opendir( $source ) ) {
while ( ( $file = readdir( $res ) ) !== false ) {
$sorce_path = $source . '/' . $file;
$dest_path = $dest . '/' . $file;
$filetype = @filetype( $sorce_path );
if ( 'file' == $filetype ) {
copy( $sorce_path, $dest_path );
} elseif ( 'dir' == $filetype && '..' != $file && '.' != $file ) {
mkdir( $dest_path );
$this->dir_copy( $sorce_path, $dest_path );
}
}
closedir( $res );
}
}
public function set_default_page() {
global $wpdb;
$datetime = get_date_from_gmt( gmdate( 'Y-m-d H:i:s', time() ) );
$datetime_gmt = gmdate( 'Y-m-d H:i:s', time() );
// cart_page.
$query = $wpdb->prepare( "SELECT ID from $wpdb->posts where post_name = %s", USCES_CART_FOLDER );
$cart_number = $wpdb->get_var( $query );
if ( null === $cart_number ) {
$query = $wpdb->prepare(
"INSERT INTO $wpdb->posts
(post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status,
comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt,
post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count)
VALUES (%d, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s, %s, %s,
%s, %d, %s, %d, %s, %s, %d)",
1, $datetime, $datetime_gmt, '', __( 'Cart', 'usces' ), '', 'publish',
'closed', 'closed', '', USCES_CART_FOLDER, '', '', $datetime, $datetime_gmt,
'', 0, '', 0, 'page', '', 0
);
$wpdb->query( $query );
$cart_number = $wpdb->insert_id;
if ( null !== $cart_number ) {
$query = $wpdb->prepare(
"INSERT INTO $wpdb->postmeta (post_id, meta_key, meta_value) VALUES (%d, %s, %s)",
$cart_number, '_wp_page_template', 'uscescart.php'
);
$wpdb->query( $query );
}
}
update_option( 'usces_cart_number', $cart_number );
// member_page.
$query = $wpdb->prepare( "SELECT ID from $wpdb->posts where post_name = %s", USCES_MEMBER_FOLDER );
$member_number = $wpdb->get_var( $query );
if ( null === $member_number ) {
$query = $wpdb->prepare(
"INSERT INTO $wpdb->posts
(post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status,
comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt,
post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count)
VALUES (%d, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s, %s, %s,
%s, %d, %s, %d, %s, %s, %d)",
1, $datetime, $datetime_gmt, '', __( 'Membership', 'usces' ), '', 'publish',
'closed', 'closed', '', USCES_MEMBER_FOLDER, '', '', $datetime, $datetime_gmt,
'', 0, '', 0, 'page', '', 0
);
$wpdb->query( $query );
$member_number = $wpdb->insert_id;
if ( null !== $member_number ) {
$query = $wpdb->prepare(
"INSERT INTO $wpdb->postmeta (post_id, meta_key, meta_value) VALUES (%d, %s, %s)",
$member_number, '_wp_page_template', 'uscesmember.php'
);
$wpdb->query( $query );
}
}
update_option( 'usces_member_number', $member_number );
}
public function set_default_categories() {
global $wpdb;
$item_category_slug = apply_filters( 'usces_item_category_slug', 'item' );
$idObj = get_category_by_slug( $item_category_slug );
if ( empty( $idObj ) ) {
$item_cat = array(
'cat_name' => __( 'Items', 'usces' ),
'category_description' => '',
'category_nicename' => $item_category_slug,
'category_parent' => 0,
);
$item_cat_id = wp_insert_category( $item_cat );
update_option( 'usces_item_cat_parent_id', $item_cat_id );
}
$idObj = get_category_by_slug( 'itemreco' );
if ( empty( $idObj ) && isset( $item_cat_id ) ) {
$itemreco_cat = array(
'cat_name' => __( 'Items recommended', 'usces' ),
'category_description' => '',
'category_nicename' => 'itemreco',
'category_parent' => $item_cat_id,
);
$itemreco_cat_id = wp_insert_category( $itemreco_cat );
}
$idObj = get_category_by_slug( 'itemnew' );
if ( empty( $idObj ) && isset( $item_cat_id ) ) {
$itemnew_cat = array(
'cat_name' => __( 'New items', 'usces' ),
'category_description' => '',
'category_nicename' => 'itemnew',
'category_parent' => $item_cat_id,
);
$itemnew_cat_id = wp_insert_category( $itemnew_cat );
}
$idObj = get_category_by_slug( 'itemgenre' );
if ( empty( $idObj ) && isset( $item_cat_id ) ) {
$itemgenre_cat = array(
'cat_name' => __( 'Item genre', 'usces' ),
'category_description' => '',
'category_nicename' => 'itemgenre',
'category_parent' => $item_cat_id,
);
$itemgenre_cat_id = wp_insert_category( $itemgenre_cat );
}
}
public function update_options() {
$target_market = $this->options['system']['target_market'];
$update_shipping_charge = false;
$shipping_charge = isset( $this->options['shipping_charge'] ) ? $this->options['shipping_charge'] : array();
$shipping_charge_count = ( $shipping_charge && is_array( $shipping_charge ) ) ? count( $shipping_charge ) : 0;
foreach ( (array) $target_market as $tm ) {
for ( $i = 0; $i < $shipping_charge_count; $i++ ) {
if ( isset( $shipping_charge[ $i ]['country'] ) && $shipping_charge[ $i ]['country'] == $tm ) {
foreach ( $shipping_charge[ $i ]['value'] as $pref => $value ) {
$shipping_charge[ $i ][ $tm ][ $pref ] = $value;
}
unset( $shipping_charge[ $i ]['country'] );
unset( $shipping_charge[ $i ]['value'] );
$update_shipping_charge = true;
}
}
}
if ( $update_shipping_charge ) {
$this->options['shipping_charge'] = $shipping_charge;
}
$update_delivery_days = false;
$delivery_days = isset( $this->options['delivery_days'] ) ? $this->options['delivery_days'] : array();
$delivery_days_count = ( $delivery_days && is_array( $delivery_days ) ) ? count( $delivery_days ) : 0;
foreach ( (array) $target_market as $tm ) {
for ( $i = 0; $i < $delivery_days_count; $i++ ) {
if ( isset( $delivery_days[ $i ]['country'] ) && $delivery_days[ $i ]['country'] == $tm ) {
foreach ( $delivery_days[ $i ]['value'] as $pref => $value ) {
$delivery_days[ $i ][ $tm ][ $pref ] = $value;
}
unset( $delivery_days[ $i ]['country'] );
unset( $delivery_days[ $i ]['value'] );
$update_delivery_days = true;
}
}
}
if ( $update_delivery_days ) {
$this->options['delivery_days'] = $delivery_days;
}
if ( $update_shipping_charge || $update_delivery_days ) {
update_option( 'usces', $this->options );
}
}
public function get_item_cat_ids() {
$ids = array();
$args = array(
'child_of' => USCES_ITEM_CAT_PARENT_ID,
'hide_empty' => 0,
'hierarchical' => 0,
);
$categories = get_categories( $args );
foreach ( (array) $categories as $category ) {
$ids[] = $category->term_id;
}
return $ids;
}
public function get_item_post_ids() {
global $wpdb;
$query = $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_mime_type = %s", 'item' );
$ids = $wpdb->get_col( $query );
return $ids;
}
public function get_item_cat_genre_ids( $post_id ) {
$ids = array();
$all_ids = array();
$genre = get_category_by_slug( 'itemgenre' );
if ( ! empty( $genre->term_id ) ) {
$genre_id = $genre->term_id;
$args = array(
'child_of' => $genre_id,
'hide_empty' => 0,
'hierarchical' => 0,
);
$categories = get_categories( $args );
foreach ( (array) $categories as $category ) {
$ids[] = $category->term_id;
}
$allcats = get_the_category( $post_id );
foreach ( (array) $allcats as $cat ) {
$all_ids[] = $cat->term_id;
}
$results = array_intersect( $ids, $all_ids );
} else {
$results = array();
}
return $results;
}
public function set_item_mime( $post_id, $str ) {
global $wpdb;
if ( WCUtils::is_blank( $str ) ) {
return;
}
$query = $wpdb->prepare( "UPDATE $wpdb->posts SET post_mime_type = %s WHERE ID = %s", $str, $post_id );
$results = $wpdb->query( $query );
return $results;
}
public function isAdnminSSL() {
$plugins = get_option( 'active_plugins' );
foreach ( $plugins as $plugin ) {
if ( false !== strpos( $plugin, USCES_ADMIN_SSL_BASE_NAME ) ) {
return true;
}
}
return false;
}
public function getGuidTax() {
if ( isset( $this->options['tax_display'] ) && 'deactivate' == $this->options['tax_display'] ) {
$str = '';
} else {
$tax_rate = (int) $this->options['tax_rate'];
if ( isset( $this->options['tax_mode'] ) ) {
if ( 'exclude' == $this->options['tax_mode'] ) {
$str = '' . __( '(Excl. Tax)', 'usces' ) . '';
} else {
$str = '' . __( '(Incl. Tax)', 'usces' ) . '';
}
} else {
if ( 0 < $tax_rate ) {
$str = '' . __( '(Excl. Tax)', 'usces' ) . '';
} else {
$str = '' . __( '(Incl. Tax)', 'usces' ) . '';
}
}
$str = apply_filters( 'usces_filter_tax_guid', $str, $tax_rate );
}
return $str;
}
public function getItemCode( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemCode = isset( $product['itemCode'] ) ? $product['itemCode'] : null;
return $itemCode;
}
public function getItemName( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemName = isset( $product['itemName'] ) ? $product['itemName'] : null;
return $itemName;
}
public function getItemRestriction( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemRestriction = isset( $product['itemRestriction'] ) ? $product['itemRestriction'] : null;
return $itemRestriction;
}
public function getItemOrderAcceptable( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$value = ( ! empty( $product['itemOrderAcceptable'] ) ) ? (int) $product['itemOrderAcceptable'] : 0;
return $value;
}
public function getItemPointrate( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemPointrate = isset( $product['itemPointrate'] ) ? $product['itemPointrate'] : null;
return $itemPointrate;
}
public function getItemShipping( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemShipping = isset( $product['itemShipping'] ) ? $product['itemShipping'] : null;
return $itemShipping;
}
public function getItemShippingCharge( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemShippingCharge = isset( $product['itemShippingCharge'] ) ? (float) $product['itemShippingCharge'] : null;
return $itemShippingCharge;
}
public function getItemDeliveryMethod( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
if ( empty( $product['itemDeliveryMethod'] ) ) {
return array();
} else {
return $product['itemDeliveryMethod'];
}
}
public function getItemIndividualSCharge( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemIndividualSCharge = isset( $product['itemIndividualSCharge'] ) ? $product['itemIndividualSCharge'] : null;
return $itemIndividualSCharge;
}
public function getItemGpNum1( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemGpNum1 = isset( $product['itemGpNum1'] ) ? $product['itemGpNum1'] : null;
return $itemGpNum1;
}
public function getItemGpNum2( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemGpNum2 = isset( $product['itemGpNum2'] ) ? $product['itemGpNum2'] : null;
return $itemGpNum2;
}
public function getItemGpNum3( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemGpNum3 = isset( $product['itemGpNum3'] ) ? $product['itemGpNum3'] : null;
return $itemGpNum3;
}
public function getItemGpDis1( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemGpDis1 = isset( $product['itemGpDis1'] ) ? $product['itemGpDis1'] : null;
return $itemGpDis1;
}
public function getItemGpDis2( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemGpDis2 = isset( $product['itemGpDis2'] ) ? $product['itemGpDis2'] : null;
return $itemGpDis2;
}
public function getItemGpDis3( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$itemGpDis3 = isset( $product['itemGpDis3'] ) ? $product['itemGpDis3'] : null;
return $itemGpDis3;
}
/**
* Unused function
*/
public function getItemSku( $post_id, $index = '', $cache = true ) {
$array = array();
$skus = $this->get_skus( $post_id, 'sort', $cache );
foreach ( (array) $skus as $sku ) {
$array[] = $sku['code'];
}
if ( ! $array ) {
return false;
}
if ( '' == $index ) {
return $array;
} elseif ( isset( $array[ $index ] ) ) {
return $array[ $index ];
} else {
return false;
}
}
public function getItemPrice( $post_id, $skukey = '', $cache = true ) {
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
foreach ( (array) $skus as $key => $sku ) {
$array[ $key ] = (float) str_replace( ',', '', $sku['price'] );
}
$array = apply_filters( 'usces_filter_get_item_price', $array, $post_id, $skukey, $skus );
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function getItemDiscount( $post_id, $skukey = '', $cache = true ) {
$display_mode = $this->options['display_mode'];
$decimal = $this->get_currency_decimal();
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
$discount = 0;
foreach ( (array) $skus as $key => $sku ) {
$price = (float) str_replace( ',', '', $sku['price'] );
if ( 'Promotionsale' == $display_mode ) {
if ( 'discount' === $this->options['campaign_privilege'] ) {
if ( 0 === (int) $this->options['campaign_category'] || in_category( (int) $this->options['campaign_category'], $post_id ) ) {
$discount = (float) sprintf( '%.3f', $price * $this->options['privilege_discount'] / 100 );
} else {
$discount = 0;
}
} elseif ( 'point' === $this->options['campaign_privilege'] ) {
$discount = 0;
}
}
if ( 0 != $discount ) {
if ( 0 == $decimal ) {
$discount = ceil( $discount );
} else {
$decipad = (int) str_pad( '1', $decimal + 1, '0', STR_PAD_RIGHT );
$discount = ceil( $discount * $decipad ) / $decipad;
}
}
$discount = apply_filters( 'usces_filter_getItemDiscount', $discount, $price, $post_id, $sku, $display_mode );
$array[ $key ] = $discount;
}
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function getItemZaiko( $post_id, $skukey = '', $cache = true ) {
$itemOrderAcceptable = $this->getItemOrderAcceptable( $post_id );
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
foreach ( (array) $skus as $key => $sku ) {
$num = $sku['stock'];
if ( 1 != $itemOrderAcceptable || WCUtils::is_blank( $sku['stocknum'] ) ) {
$array[ $key ] = $this->zaiko_status[ $num ];
} else {
if ( 2 > $num && 0 >= (int) $sku['stocknum'] ) {
$array[ $key ] = ( ! empty( $this->options['order_acceptable_label'] ) ) ? $this->options['order_acceptable_label'] : __( 'Order acceptable', 'usces' );
} else {
$array[ $key ] = $this->zaiko_status[ $num ];
}
}
}
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function getItemZaikoStatusId( $post_id, $skukey = '', $cache = true ) {
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
foreach ( (array) $skus as $key => $sku ) {
$num = $sku['stock'];
$array[ $key ] = $num;
}
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function updateItemZaiko( $post_id, $skucode, $value ) {
$res = usces_update_sku( $post_id, $skucode, 'stock', $value );
if ( ! $res ) {
return false;
} else {
return true;
}
}
public function getItemZaikoNum( $post_id, $skukey = '', $cache = true ) {
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
foreach ( (array) $skus as $key => $sku ) {
$array[ $key ] = $sku['stocknum'];
}
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function updateItemZaikoNum( $post_id, $skucode, $value ) {
$res = usces_update_sku( $post_id, $skucode, 'stocknum', $value );
if ( ! $res ) {
return false;
} else {
return true;
}
}
public function getItemDivision( $post_id, $cache = true ) {
if ( usces_is_item( $post_id ) ) {
$product = wel_get_product( $post_id, $cache );
$item_division = $product['item_division'];
$division = empty( $item_division ) ? 'shipped' : $item_division;
} else {
$division = null;
}
return $division;
}
public function getItemChargingType( $post_id, $cart = array(), $cache = true ) {
if ( usces_is_item( $post_id ) ) {
$product = wel_get_product( $post_id, $cache );
$charging = $product['item_charging_type'];
if ( ! defined( 'WCEX_DLSELLER' ) && ! defined( 'WCEX_AUTO_DELIVERY' ) ) {
$charging = null;
}
} else {
$charging = null;
}
switch ( $charging ) {
case 0:
$type = 'once';
break;
case 1:
$type = 'continue';
break;
case 2:
$type = 'regular';
if ( ! empty( $cart ) ) {
if ( empty( $cart['advance'] ) ) {
$type = 'once';
} else {
if ( is_array( $cart['advance'] ) && array_key_exists( 'regular', $cart['advance'] ) ) {
$regular = wel_safe_maybe_unserialize( $cart['advance']['regular'] );
} else {
$advance = $this->cart->wc_unserialize( $cart['advance'] );
$sku = urldecode( $cart['sku'] );
$sku_encoded = $cart['sku'];
$regular = $advance[ $post_id ][ $sku_encoded ]['regular'];
}
$unit = isset( $regular['unit'] ) ? $regular['unit'] : '';
$interval = isset( $regular['interval'] ) ? (int) $regular['interval'] : 0;
/* Treated as normal billing */
if ( empty( $unit ) || 1 > $interval ) {
$type = 'once';
}
}
}
break;
default:
$type = null;
}
return $type;
}
public function getItemFrequency( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
return $product['item_frequency'];
}
public function getItemChargingDay( $post_id, $cache = true ) {
$product = wel_get_product( $post_id, $cache );
$day = (int) $product['item_chargingday'];
$chargingday = empty( $day ) ? 1 : $day;
return $chargingday;
}
public function getItemSkuDisp( $post_id, $skukey = '', $cache = true ) {
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
foreach ( (array) $skus as $key => $sku ) {
$array[ $key ] = $sku['name'];
}
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function getItemSkuUnit( $post_id, $skukey = '', $cache = true ) {
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
foreach ( (array) $skus as $key => $sku ) {
$array[ $key ] = $sku['unit'];
}
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function getItemSkuAdvance( $post_id, $skukey = '', $cache = true ) {
$array = array();
$skus = wel_get_skus( $post_id, 'code', $cache );
foreach ( (array) $skus as $key => $sku ) {
$array[ $key ] = $sku['advance'];
}
if ( ! $array ) {
return false;
}
if ( '' === $skukey ) {
return $array;
} elseif ( isset( $array[ $skukey ] ) ) {
return $array[ $skukey ];
} else {
return false;
}
}
public function get_item( $post_id, $cache = true ) {
return wel_get_product( $post_id, $cache );
}
public function get_itemOptionKey( $post_id, $enc = false, $cache = true ) {
$opts = usces_get_opts( $post_id, 'sort', $cache );
if ( empty( $opts ) ) {
return;
}
$res = array();
foreach ( (array) $opts as $opt ) {
if ( $enc ) {
$res[] = urlencode( $opt['name'] );
} else {
$res[] = $opt['name'];
}
}
return $res;
}
public function get_itemOptions( $key, $post_id, $cache = true ) {
$opts = wel_get_opts( $post_id, 'name', $cache );
if ( ! isset( $opts[ $key ] ) ) {
return false;
} else {
return $opts[ $key ];
}
}
public function get_postIDbyCode( $item_code, $cache = true ) {
if ( null === $item_code ) {
return false;
}
$post_id = wel_get_id_by_item_code( $item_code, $cache );
return $post_id;
}
public function get_itemByCode( $item_code, $cache = true ) {
if ( null === $item_code ) {
return false;
}
$product = wel_get_product_by_code( $item_code, $cache );
return $product;
}
public function get_pictids( $item_code, $cache = true ) {
return wel_get_sub_pict_ids_by_code( $item_code, $cache );
}
public function get_mainpictid( $item_code, $cache = true ) {
return wel_get_main_pict_id_by_code( $item_code, $cache );
}
public function get_subpictid( $sku_code, $cache = true ) {
global $wpdb;
if ( empty( $sku_code) ) {
return 0;
}
$query = $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_title = %s AND post_type = 'attachment' LIMIT 1", $sku_code );
$id = $wpdb->get_var( $query );
$id = apply_filters( 'usces_filter_get_subpictid', $id, $sku_code );
return $id;
}
public function get_skus( $post_id, $keyflag = 'sort', $cache = true ) {
if ( null === $post_id ) {
return false;
}
$skus = wel_get_skus( $post_id, $keyflag, $cache );
return $skus;
}
public function is_item( $post ) {
if ( 'item' == $post->post_mime_type ) {
return true;
} else {
return false;
}
}
public function getItemIds( $end_type ) {
global $wpdb;
$cache_key = 'wel_item_ids_' . $end_type;
$ids = wp_cache_get( $cache_key );
if ( false === $ids ) {
if ( 'front' == $end_type ) {
$query = $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_status = %s AND post_mime_type = %s", 'publish', 'item' );
}
if ( 'back' == $end_type ) {
$query = $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_mime_type = %s", 'item' );
}
$ids = $wpdb->get_col( $query );
if ( null !== $ids ) {
wp_cache_set( $cache_key, $ids );
}
}
if ( null === $ids ) {
return array();
} else {
return $ids;
}
}
public function getNotItemIds() {
global $wpdb;
$query = $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_status = %s AND post_mime_type <> %s", 'publish', 'item' );
$ids = $wpdb->get_col( $query );
if ( empty( $ids ) ) {
$ids = array();
}
return $ids;
}
public function getPaymentMethod( $name ) {
$res = array();
$payments = $this->options['payment_method'];
foreach ( (array) $payments as $payment ) {
if ( $name == $payment['name'] ) {
$res = $payment;
break;
}
}
return $res;
}
public function order_processing( $results = array() ) {
do_action( 'usces_pre_reg_orderdata' );
$acting = isset( $_REQUEST['acting'] ) ? $_REQUEST['acting'] : '';
global $usces;
$usces_entries = $this->cart->get_entry();
$payments = $this->getPayments( $usces_entries['order']['payment_name'] );
$nonacting_settlements = apply_filters( 'usces_filter_nonacting_settlements', $this->nonacting_settlements );
$res = usces_check_acting_return_duplicate( $results );
if ( $res != null && ! in_array( $payments['settlement'], $nonacting_settlements ) ) {
usces_log( 'order processing duplicate : acting=' . $acting . ', order_id=' . $res, 'acting_transaction.log' );
return 'ordercompletion';
}
if ( isset( $_REQUEST['acting'] ) && ( 'jpayment_card' == $_REQUEST['acting'] || 'jpayment_conv' == $_REQUEST['acting'] || 'jpayment_bank' == $_REQUEST['acting'] ) ) {
usces_log( $_REQUEST['acting'] . ' transaction : ' . $_REQUEST['gid'], 'acting_transaction.log' ); // OK.
}
if ( isset( $_REQUEST['acting'] ) && ( 'paypal_ec' == $_REQUEST['acting'] ) ) {
if ( ! usces_paypal_doecp( $results ) ) {
return 'error';
}
}
$order_id = usces_reg_orderdata( $results );
do_action( 'usces_post_reg_orderdata', $order_id, $results );
if ( $order_id ) {
// mail(function.php).
$mail_res = usces_send_ordermail( $order_id );
return 'ordercompletion';
} else {
return 'error';
}
}
/**
* 決済処理
*
* @param string $acting_flg Payment type.
* @param array $post_query Post data.
* @param string $acting_status Status.
* @return mixed
*/
public function acting_processing( $acting_flg, $post_query, $acting_status ) {
global $wpdb;
$entry = $this->cart->get_entry();
$delim = apply_filters( 'usces_filter_delim', $this->delim );
$acting_flg = trim( $acting_flg );
if ( empty( $acting_flg ) ) {
return 'error';
}
if ( 'paypal.php' == $acting_flg ) {
} elseif ( 'epsilon.php' == $acting_flg ) {
} elseif ( 'acting_paypal_ec' == $acting_flg ) {
$acting_opts = $this->options['acting_settings']['paypal'];
$addroverride = '1';
if ( isset( $_POST['PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE'] ) ) {
if ( 'US' == $_POST['PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE'] || 'CA' == $_POST['PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE'] ) {
$addroverride = '0';
}
} else {
$addroverride = '0';
}
$rand = ( isset( $_POST['PAYMENTREQUEST_0_CUSTOM'] ) ) ? $_POST['PAYMENTREQUEST_0_CUSTOM'] : '(empty key)';
$nvpstr = $post_query;
$nvpstr .= '&ADDROVERRIDE=' . $addroverride;
$nvpstr .= '&PAYMENTREQUEST_0_PAYMENTACTION=' . apply_filters( 'usces_filter_paypal_ec_paymentaction', 'Sale' );
// The returnURL is the location where buyers return to when a payment has been succesfully authorized.
$nvpstr .= '&RETURNURL=' . urlencode( USCES_CART_URL . $delim . 'acting=paypal_ec&acting_return=1' );
// The cancelURL is the location buyers are sent to when they hit the cancel button during authorization of payment during the PayPal flow.
$cancelurl = urlencode( USCES_CART_URL . $delim . 'confirm=1' );
$pos = strpos( $post_query, 'paypal_from_cart' );
if ( false !== $pos ) {
$cancelurl = urlencode( USCES_CART_URL );
}
$nvpstr .= '&CANCELURL=' . apply_filters( 'usces_filter_paypal_ec_cancelurl', $cancelurl, $post_query );
$nvpstr .= '&PAYMENTREQUEST_0_NOTIFYURL=' . urlencode( USCES_PAYPAL_NOTIFY_URL );
// Seamless checkout.
if ( isset( $_SESSION['liwpp']['token'] ) && ! empty( $_SESSION['liwpp']['token'] ) ) {
$nvpstr .= '&IDENTITYACCESSTOKEN=' . $_SESSION['liwpp']['token'];
}
$this->paypal->setMethod( 'SetExpressCheckout' );
$this->paypal->setData( $nvpstr );
$res = $this->paypal->doExpressCheckout();
$resArray = $this->paypal->getResponse();
$ack = strtoupper( $resArray['ACK'] );
if ( 'SUCCESS' == $ack || 'SUCCESSWITHWARNING' == $ack ) {
$token = urldecode( $resArray['TOKEN'] );
$payPalURL = $acting_opts['paypal_url'] . '?cmd=_express-checkout&token=' . $token . '&useraction=commit';
header( 'Location: ' . $payPalURL );
} else {
// Display a user friendly Error on the page using any of the following error information returned by PayPal.
$ErrorCode = urldecode( $resArray['L_ERRORCODE0'] );
$ErrorShortMsg = urldecode( $resArray['L_SHORTMESSAGE0'] );
$ErrorLongMsg = urldecode( $resArray['L_LONGMESSAGE0'] );
$ErrorSeverityCode = urldecode( $resArray['L_SEVERITYCODE0'] );
usces_log( 'PayPal : SetExpressCheckout API call failed. Error Code:[' . $ErrorCode . '] Error Severity Code:[' . $ErrorSeverityCode . '] Short Error Message:' . $ErrorShortMsg . ' Detailed Error Message:' . $ErrorLongMsg, 'acting_transaction.log' );
$log = array(
'acting' => 'paypal_ec',
'key' => $rand,
'result' => $ack,
'data' => $resArray,
);
usces_save_order_acting_error( $log );
header( 'Location: ' . USCES_CART_URL . $delim . 'acting=paypal_ec&acting_return=0' );
}
exit;
} elseif ( 'acting_telecom_edy' == $acting_flg ) { /* テレコムクレジット Edy決済 */
$table_meta_name = $wpdb->prefix . 'usces_order_meta';
$value = array();
$value['usces_cart'] = $_SESSION['usces_cart'];
$value['usces_entry'] = $_SESSION['usces_entry'];
$value['usces_member'] = $_SESSION['usces_member'];
$mvalue = serialize( $value );
$mquery = $wpdb->prepare( "INSERT INTO $table_meta_name (order_id, meta_key, meta_value) VALUES (%d, %s, %s)", $_POST['option'], $_POST['option'], $mvalue );
$res = $wpdb->query( $mquery );
unset( $_SESSION['usces_cart'] );
unset( $_SESSION['usces_entry'] );
$acting_opts = $this->options['acting_settings']['telecom'];
header( 'location: ' . $acting_opts['send_url_edy'] . '?acting=telecom_edy' . $post_query );
exit;
} elseif ( 'acting_digitalcheck_card' == $acting_flg ) { /* ペイメントフォー カード決済（旧メタップスペイメント、旧デジタルチェック、旧ペイデザイン） */
$acting_opts = $this->options['acting_settings']['digitalcheck'];
$interface = parse_url( $acting_opts['send_url_user_id'] );
$kakutei = ( empty( $acting_opts['card_kakutei'] ) ) ? '0' : $acting_opts['card_kakutei'];
$params = array(
'IP' => $acting_opts['card_ip'],
'PASS' => $acting_opts['card_pass'],
'SID' => $_POST['SID'],
'IP_USER_ID' => $_POST['IP_USER_ID'],
'N1' => $_POST['N1'],
'K1' => $_POST['K1'],
'FUKA' => $acting_flg,
'KAKUTEI' => $kakutei,
);
$vars = http_build_query( $params );
$header = 'POST ' . $interface['path'] . " HTTP/1.1\r\n";
$header .= 'Host: ' . $interface['host'] . "\r\n";
$header .= "User-Agent: PHP Script\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= 'Content-Length: ' . strlen( $vars ) . "\r\n";
$header .= "Connection: close\r\n\r\n";
$header .= $vars;
$fp = @stream_socket_client( 'tlsv1.2://' . $interface['host'] . ':443', $errno, $errstr, 30 );
if ( ! $fp ) {
// usces_log( 'digitalcheck card : TLS(v1.2) Error', 'acting_transaction.log' );
$log = array(
'acting' => 'digitalcheck_card',
'key' => $_POST['SID'],
'result' => 'SSL/TLS ERROR (' . $errno . ')',
'data' => array( $errstr ),
);
usces_save_order_acting_error( $log );
wp_redirect(
add_query_arg(
array(
'acting' => 'digitalcheck_card',
'acting_return' => 0,
),
USCES_CART_URL
)
);
exit();
}
if ( $fp ) {
fwrite( $fp, $header );
$headerdone = false;
$page = '';
while ( ! feof( $fp ) ) {
$line = fgets( $fp, 1024 );
if ( 0 == strcmp( $line, "\r\n" ) ) {
$headerdone = true;
} elseif ( $headerdone ) {
$page .= $line;
}
}
fclose( $fp );
$lines = explode( "\n", $page );
if ( false !== strpos( $lines[0], 'OK' ) ) {
// usces_log( 'digitalcheck card entry data (acting_processing) : ' . print_r( $entry, true ), 'acting_transaction.log');
wp_redirect(
add_query_arg(
array(
'acting' => 'digitalcheck_card',
'acting_return' => 1,
'SID' => $_POST['SID'],
'FUKA' => $acting_flg,
),
USCES_CART_URL
)
);
exit();
} else {
// usces_log( 'digitalcheck card : Certification Error : ' . $page, 'acting_transaction.log' );
$log = array(
'acting' => 'digitalcheck_card',
'key' => $_POST['SID'],
'result' => 'CERTIFICATION ERROR',
'data' => $lines,
);
usces_save_order_acting_error( $log );
wp_redirect(
add_query_arg(
array(
'acting' => 'digitalcheck_card',
'acting_return' => 0,
),
USCES_CART_URL
)
);
exit();
}
}
exit();
} elseif ( 'acting_digitalcheck_conv' == $acting_flg ) { /* ペイメントフォー コンビニ決済（旧メタップスペイメント、旧デジタルチェック、旧ペイデザイン） */
if ( isset( $_REQUEST['STORE'] ) && '99' != $_REQUEST['STORE'] ) {
$res = $this->order_processing();
if ( 'ordercompletion' == $res ) {
$table_meta_name = $wpdb->prefix . 'usces_order_meta';
$mquery = $wpdb->prepare( "SELECT order_id FROM $table_meta_name WHERE meta_key = %s AND meta_value = %s", 'SID', $_REQUEST['SID'] );
$order_id = $wpdb->get_var( $mquery );
if ( $order_id ) {
$data = array(
'settltment_status' => __( 'Failure', 'usces' ),
'settltment_errmsg' => __( 'Settlement was not completed.', 'usces' ),
);
$this->set_order_meta_value( 'acting_digitalcheck_conv', serialize( $data ), $order_id );
$this->set_order_meta_value( 'wc_trans_id', $_REQUEST['SID'], $order_id );
}
$this->cart->crear_cart();
$acting_opts = $this->options['acting_settings']['digitalcheck'];
header( 'location: ' . $acting_opts['send_url_conv'] . '?acting=digitalcheck_conv' . $post_query );
exit;
} else {
// usces_log( 'digitalcheck conv : order processing error', 'acting_transaction.log' );
$log = array(
'acting' => 'digitalcheck_conv',
'key' => $_REQUEST['SID'],
'result' => 'ORDER DATA REGISTERED ERROR',
'data' => $_REQUEST,
);
usces_save_order_acting_error( $log );
header( 'location: ' . USCES_CART_URL . $delim . 'acting=digitalcheck_conv&acting_return=0' );
exit;
}
} else {
$acting_opts = $this->options['acting_settings']['digitalcheck'];
header( 'location: ' . $acting_opts['send_url_conv'] . '?acting=digitalcheck_conv' . $post_query );
exit;
}
} elseif ( 'acting_veritrans_card' == $acting_flg || 'acting_veritrans_conv' == $acting_flg ) { /* ベリトランス カード決済・コンビニ決済 */
$acting_opts = $this->options['acting_settings']['veritrans'];
$acting = substr( $acting_flg, 7 );
$dummy_payment_flag = ( 'public' == $acting_opts['ope'] ) ? '0' : '1';
$order_id = isset( $_POST['ORDER_ID'] ) ? $_POST['ORDER_ID'] : '';
$regist_url = ( defined( 'VERITRANS_SHA2_TEST' ) ) ? 'https://sair.veritrans.co.jp/web/commodityRegist.action' : $acting_opts['regist_url'];
$url = parse_url( $regist_url );
$path = empty( $url['path'] ) ? '/' : $url['path'];
$postdata = $post_query;
if ( 'acting_veritrans_card' == $acting_flg ) {
$card_capture_flag = ( 'capture' == $acting_opts['card_capture_flag'] ) ? '1' : '0';
$postdata .= '&CARD_CAPTURE_FLAG=' . $card_capture_flag;
}
if ( 'acting_veritrans_conv' == $acting_flg ) {
$postdata .= '&NAME1=' . urlencode( mb_substr( mb_convert_kana( $entry['customer']['name1'], 'ASKV', 'UTF-8' ), 0, 10, 'UTF-8' ) );
$postdata .= '&NAME2=' . urlencode( mb_substr( mb_convert_kana( $entry['customer']['name2'], 'ASKV', 'UTF-8' ), 0, 10, 'UTF-8' ) );
if ( ! empty( $entry['customer']['name3'] ) ) {
$kana1 = mb_substr( mb_convert_kana( $entry['customer']['name3'], 'ASKV', 'UTF-8' ), 0, 10, 'UTF-8' );
mb_regex_encoding( 'UTF-8' );
if ( mb_ereg( "^[ア-ン゛゜ァ-ォャ-ョー]+$", $kana1 ) ) {
$postdata .= '&KANA1=' . urlencode( $kana1 );
}
}
if ( ! empty( $entry['customer']['name4'] ) ) {
$kana2 = mb_substr( mb_convert_kana( $entry['customer']['name4'], 'ASKV', 'UTF-8' ), 0, 10, 'UTF-8' );
mb_regex_encoding( 'UTF-8' );
if ( mb_ereg( "^[ア-ン゛゜ァ-ォャ-ョー]+$", $kana2 ) ) {
$postdata .= '&KANA2=' . urlencode( $kana2 );
}
}
$postdata .= '&TELEPHONE_NO=' . str_replace( '-', '', $entry['customer']['tel'] );
if ( 1 < (int) $acting_opts['conv_timelimit'] && (int) $acting_opts['conv_timelimit'] <= 60 ) {
$timelimit = date( 'Ymd', strtotime( '+' . $acting_opts['conv_timelimit'] . ' days' ) );
$postdata .= '&TIMELIMIT_OF_PAYMENT=' . $timelimit;
}
}
if ( 'on' == $acting_opts['mailaddress'] ) {
$postdata .= '&MAILADDRESS=' . $entry['customer']['mailaddress1'];
}
$postdata .= '&MERCHANT_ID=' . $acting_opts['merchant_id'];
$postdata .= '&SESSION_ID=' . session_id();
$postdata .= '&FINISH_PAYMENT_RETURN_URL=' . urlencode( USCES_CART_URL . $delim . 'acting=' . $acting . '&acting_return=1&result=1' );
$postdata .= '&UNFINISH_PAYMENT_RETURN_URL=' . urlencode( USCES_CART_URL . $delim . 'acting=' . $acting . '&confirm=1' );
$postdata .= '&ERROR_PAYMENT_RETURN_URL=' . urlencode( USCES_CART_URL . $delim . 'acting=' . $acting . '&acting_return=0' );
$postdata .= '&FINISH_PAYMENT_ACCESS_URL=' . urlencode( USCES_CART_URL . $delim . 'acting=' . $acting );
$postdata .= '&DUMMY_PAYMENT_FLAG=' . $dummy_payment_flag;
$postlength = strlen( $postdata );
$request = 'POST ' . $path . ' HTTP/1.1' . "\r\n";
$request .= 'Host: ' . $url['host'] . "\r\n";
$request .= 'User-Agent: HttpRequest Powered by ' . phpversion() . "\r\n";
$request .= 'Connection: close' . "\r\n";
$request .= 'Accept-Language: ja' . "\r\n";
$request .= 'Content-Type: application/x-www-form-urlencoded' . "\r\n";
$request .= 'Content-Length: ' . $postlength . "\r\n\r\n";
$request .= $postdata;
$code = 0;
$resBody = '';
$con = @stream_socket_client( 'tlsv1.2://' . $url['host'] . ':443', $errno, $errstr, 30 );
if ( ! $con ) {
usces_log( 'Veritrans : TLS(v1.2) Error', 'acting_transaction.log' );
$con = @fsockopen( 'ssl://' . $url['host'], 443, $errno, $errstr, 30 );
if ( ! $con ) {
usces_log( 'Veritrans : SSL Error', 'acting_transaction.log' );
$log = array(
'acting' => $acting,
'key' => $order_id,
'result' => 'SSL/TLS ERROR (' . $errno . ')',
'data' => array( $errstr ),
);
usces_save_order_acting_error( $log );
header( 'location: ' . USCES_CART_URL . $delim . 'acting=' . $acting_flg . '&acting_return=0' );
exit;
}
}
if ( $con ) {
$ret = fwrite( $con, $request );
if ( $ret == strlen( $request ) ) {
$res = $this->readResponse( $con );
$code = $res['Code'];
$resBody = $res['Body'];
} else {
usces_log( 'Veritrans Write NG: Sent:' . strlen( $request ) . ' Send:' . $ret, 'acting_transaction.log' );
}
fclose( $con );
}
// 正常終了（200 OK）が返ったか.
if ( 200 == intval( $code ) ) {
$merchantKey = null;
$browserKey = null;
$scd = null;
$error_message = null;
// レスポンスデータからマーチャントキー、ブラウザキーを取得.
$bodyLine = explode( "\n", $resBody );
foreach ( $bodyLine as $line ) {
if ( preg_match( '/^MERCHANT_ENCRYPTION_KEY=(.+)/', $line, $match ) ) {
$merchantKey = $match[1];
} elseif ( preg_match( '/^BROWSER_ENCRYPTION_KEY=(.+)/', $line, $match ) ) {
$browserKey = $match[1];
} elseif ( preg_match('/^SCD=(.+)/', $line, $match ) ) {
$scd = $match[1];
} elseif ( preg_match( '/^ERROR_MESSAGE=(.+)/', $line, $match ) ) {
$error_message = $match[1];
}
}
// 両方取れたらOK。SCDはカードでセキュリティコードが入力された場合のみ.
if ( ! is_null( $merchantKey ) && ! is_null( $browserKey ) ) {
$getdata = '?MERCHANT_ID=' . $acting_opts['merchant_id'];
$getdata .= '&ORDER_ID=' . $order_id;
$getdata .= '&BROWSER_ENCRYPTION_KEY=' . urlencode( $browserKey );
$payment_url = ( defined( 'VERITRANS_SHA2_TEST' ) ) ? 'https://sair.veritrans.co.jp/web/paymentStart.action' : $acting_opts['payment_url'];
header( 'location: ' . $payment_url . $getdata );
} else {
if ( ! is_null( $error_message ) ) {
usces_log( 'Veritrans AWeb:' . $error_message, 'acting_transaction.log' );
$log = array(
'acting' => $acting,
'key' => $order_id,
'result' => $code,
'data' => $bodyLine,
);
usces_save_order_acting_error( $log );
}
header( 'location: ' . USCES_CART_URL . $delim . 'acting=' . $acting_flg . '&acting_return=0' );
}
} else {
usces_log( 'Veritrans Response NG: ' . $resBody, 'acting_transaction.log' );
$bodyLine = explode( "\n", $resBody );
$log = array(
'acting' => $acting,
'key' => $order_id,
'result' => $code,
'data' => $bodyLine,
);
usces_save_order_acting_error( $log );
header( 'location: ' . USCES_CART_URL . $delim . 'acting=' . $acting_flg . '&acting_return=0' );
}
exit;
}
do_action( 'usces_action_acting_processing', $acting_flg, $post_query );
$acting_status = apply_filters( 'usces_filter_acting_processing', $acting_flg, $post_query, $acting_status );
return $acting_status;
}
private function readResponse( $fp ) {
$res = array(
'Status' => '',
'Version' => '',
'Code' => 0,
'Message' => '',
'Headers' => array(),
'Body' => '',
);
// HTTPステータスの読み込み.
$line = $this->readLine( $fp );
if ( 0 == preg_match( '/^(HTTP\/1\.[0-9x]+)\s+([0-9]+)\s+(.+)/i', $line, $match ) ) {
return $res;
}
$res['Status'] = $line;
$res['Version'] = $match[1];
$res['Code'] = $match[2];
$res['Message'] = $match[3];
// レスポンスヘッダの読み込み.
while ( ! feof( $fp ) ) {
$line = $this->readLine( $fp );
if ( '' != $line ) {
list( $hname, $hvalue ) = explode( ':', $line, 2 );
$res['Headers'][ strtolower( $hname ) ] = ltrim( $hvalue );
} else {
break;
}
}
// レスポンスデータの読み込み.
while ( ! feof( $fp ) ) {
$data = $this->readLine( $fp ) . "\n";
if ( '' == $data ) {
break;
}
$res['Body'] .= $data;
}
return $res;
}
private function readLine( $fp ) {
if ( ! $fp ) {
return '';
}
// レスポンスデータを受信.
$line = null;
while ( ! feof( $fp ) ) {
$line .= @fgets( $fp, 4096 );
if ( "\n" == substr( $line, -1 ) ) {
return rtrim( $line, "\r\n" );
}
}
return $line;
}
public function inquiry_processing() {
$mail_res = usces_send_inquirymail();
if ( $mail_res ) {
return 'inquiry_comp';
} else {
return 'inquiry_error';
}
}
public function lastprocessing() {
if ( 'ordercompletion' == $this->page ) {
$this->cart->crear_cart();
}
do_action( 'usces_action_lastprocessing' );
unset( $_SESSION['usces_singleitem'] );
}
public function is_item_zaiko( $post_id, $sku_code ) {
$res = false;
$status_num = false;
$zaiko_num = false;
if ( ! empty( $post_id ) ) {
$sku_code = (string) $sku_code;
$status_num = $this->getItemZaikoStatusId( $post_id, $sku_code );
$zaiko_num = $this->getItemZaikoNum( $post_id, $sku_code );
$itemOrderAcceptable = $this->getItemOrderAcceptable( $post_id );
if ( 1 != $itemOrderAcceptable ) {
if ( false !== $zaiko_num
&& ( 0 < (int) $zaiko_num || WCUtils::is_blank( $zaiko_num ) )
&& false !== $status_num
&& 2 > (int) $status_num ) {
$res = true;
} else {
$res = false;
}
} else {
if ( false !== $status_num
&& 2 > (int) $status_num ) {
$res = true;
} else {
$res = false;
}
}
}
return apply_filters( 'usces_is_item_zaiko', $res, $post_id, $sku_code, $status_num, $zaiko_num );
}
public function get_total_price( $cart = array() ) {
if ( empty( $cart ) ) {
$cart = $this->cart->get_cart();
}
$total_price = 0;
if ( ! empty( $cart ) ) {
$cart_count = ( is_array( $cart ) ) ? count( $cart ) : 0;
for ( $i = 0; $i < $cart_count; $i++ ) {
$quantity = (float) $cart[ $i ]['quantity'];
$skuPrice = (float) $cart[ $i ]['price'];
$total_price += ( $skuPrice * $quantity );
}
}
return apply_filters( 'usces_filter_get_total_price', $total_price, $cart );
}
public function get_total_quantity( $cart = array() ) {
if ( empty( $cart ) ) {
$cart = $this->cart->get_cart();
}
$total_quantity = 0;
if ( ! empty( $cart ) ) {
$cart_count = ( is_array( $cart ) ) ? count( $cart ) : 0;
for ( $i = 0; $i < $cart_count; $i++ ) {
$total_quantity += (float) $cart[ $i ]['quantity'];
}
}
return $total_quantity;
}
public function get_order_point( $mem_id = '', $display_mode = '', $cart = array() ) {
if ( '' == $mem_id || 'deactivate' == $this->options['membersystem_state'] || 'deactivate' == $this->options['membersystem_point'] ) {
return 0;
}
if ( empty( $cart ) ) {
$cart = $this->cart->get_cart();
}
if ( empty( $display_mode ) ) {
$display_mode = $this->options['display_mode'];
}
$point = 0;
$total = $this->get_total_price( $cart );
if ( 'Promotionsale' == $display_mode ) {
if ( 'discount' == $this->options['campaign_privilege'] ) {
foreach ( $cart as $rows ) {
$cats = $this->get_post_term_ids( $rows['post_id'], 'category' );
if ( ! in_array( $this->options['campaign_category'], $cats ) ) {
$product = wel_get_product( $rows['post_id'] );
$rate = (float) $product['itemPointrate'];
$price = (float) $rows['price'] * (float) $rows['quantity'];
$point = (float) sprintf( '%.3f', $point + ( $price * $rate / 100 ) );
}
}
} elseif ( 'point' == $this->options['campaign_privilege'] ) {
foreach ( $cart as $rows ) {
$product = wel_get_product( $rows['post_id'] );
$rate = (float) $product['itemPointrate'];
$price = (float) $rows['price'] * (float) $rows['quantity'];
$cats = $this->get_post_term_ids( $rows['post_id'], 'category' );
if ( in_array( $this->options['campaign_category'], $cats ) ) {
$point = (float) sprintf( '%.3f', $point + ( $price * $rate / 100 * (float) $this->options['privilege_point'] ) );
} else {
$point = (float) sprintf( '%.3f', $point + ( $price * $rate / 100 ) );
}
}
}
} else {
foreach ( $cart as $rows ) {
$product = wel_get_product( $rows['post_id'] );
$rate = (float) $product['itemPointrate'];
$price = (float) $rows['price'] * (float) $rows['quantity'];
$point = (float) sprintf( '%.3f', $point + ( $price * $rate / 100 ) );
}
}
$entry = $this->cart->get_entry();
$use_point = isset( $entry['order']['usedpoint'] ) ? (int) $entry['order']['usedpoint'] : 0;
if ( 0 < $use_point && 0 < $total ) {
$point = (float) sprintf( '%.3f', $point - ( $point * $use_point / $total ) );
$point = ceil( $point );
if ( 0 > $point ) {
$point = 0;
}
} else {
if ( 0 < $point ) {
$point = ceil( $point );
}
}
return apply_filters( 'usces_filter_get_order_point', $point, $mem_id, $display_mode, $cart );
}
public function get_order_discount( $display_mode = '', $cart = array() ) {
if ( empty( $cart ) ) {
$cart = $this->cart->get_cart();
}
if ( empty( $display_mode ) ) {
$display_mode = $this->options['display_mode'];
}
$discount = 0;
if ( 'Promotionsale' == $display_mode ) {
if ( 'discount' == $this->options['campaign_privilege'] ) {
if ( 0 === (int) $this->options['campaign_category'] ) {
$total = $this->get_total_price( $cart );
$discount = (float) sprintf( '%.3f', $total * (float) $this->options['privilege_discount'] / 100 );
} else {
foreach ( $cart as $cart_row ) {
if ( in_category( (int) $this->options['campaign_category'], $cart_row['post_id'] ) ) {
$discount += (float) sprintf( '%.3f', (float) $cart_row['price'] * (float) $cart_row['quantity'] * (float) $this->options['privilege_discount'] / 100 );
}
}
}
if ( 0 != $discount ) {
$decimal = $this->get_currency_decimal();
if ( 0 == $decimal ) {
$discount = ceil( $discount );
} else {
$decipad = (int) str_pad( '1', $decimal + 1, '0', STR_PAD_RIGHT );
$discount = ceil( $discount * $decipad ) / $decipad;
}
$discount = $discount * -1;
}
} elseif ( 'point' == $this->options['campaign_privilege'] ) {
$discount = 0;
}
}
$discount = apply_filters( 'usces_order_discount', $discount, $cart );
return $discount;
}
public function getShippingCharge( $pref, $cart = array(), $entry = array() ) {
if ( empty( $cart ) ) {
$cart = $this->cart->get_cart();
}
if ( empty( $entry ) ) {
$entry = $this->cart->get_entry();
}
if ( function_exists( 'dlseller_have_shipped' ) && ! dlseller_have_shipped() ) {
$charge = 0;
$charge = apply_filters( 'usces_filter_getShippingCharge', $charge, $cart, $entry );
return $charge;
}
// 配送方法ID.
$d_method_id = $entry['order']['delivery_method'];
// 配送方法index.
$d_method_index = $this->get_delivery_method_index( $d_method_id );
// 送料ID.
$fixed_charge_id = ( isset( $this->options['delivery_method'][ $d_method_index ]['charge'] ) ) ? $this->options['delivery_method'][ $d_method_index ]['charge'] : -1;
$individual_quant = 0;
$total_quant = 0;
$charges = array();
$individual_charges = array();
$country = ( isset( $entry['delivery']['country'] ) && ! empty( $entry['delivery']['country'] ) ) ? $entry['delivery']['country'] : $entry['customer']['country'];
foreach ( $cart as $rows ) {
if ( 'shipped' !== $this->getItemDivision( $rows['post_id'] ) ) {
continue;
}
if ( -1 == $fixed_charge_id ) {
// 商品送料ID.
$s_charge_id = $this->getItemShippingCharge( $rows['post_id'] );
// 商品送料index.
$s_charge_index = $this->get_shipping_charge_index( $s_charge_id );
$s_charge = isset( $this->options['shipping_charge'][ $s_charge_index ][ $country ][ $pref ] ) ? (float) $this->options['shipping_charge'][ $s_charge_index ][ $country ][ $pref ] : 0;
} else {
$s_charge_index = $this->get_shipping_charge_index( $fixed_charge_id );
$s_charge = isset( $this->options['shipping_charge'][ $s_charge_index ][ $country ][ $pref ] ) ? (float) $this->options['shipping_charge'][ $s_charge_index ][ $country ][ $pref ] : 0;
}
if ( $this->getItemIndividualSCharge( $rows['post_id'] ) ) {
$individual_quant += (float) $rows['quantity'];
$individual_charges[] = (float) $rows['quantity'] * $s_charge;
} else {
$charges[] = $s_charge;
}
$total_quant += $rows['quantity'];
}
if ( count( $charges ) > 0 ) {
rsort( $charges );
$max_charge = $charges[0];
$charge = $max_charge + array_sum( array_filter( $individual_charges, 'is_numeric' ) );
} else {
$charge = array_sum( array_filter( $individual_charges, 'is_numeric' ) );
}
$charge = apply_filters( 'usces_filter_getShippingCharge', $charge, $cart, $entry );
return $charge;
}
public function getCODFee( $payment_name, $amount_by_cod, $current_entries ) {
global $usces_entries;
$payments = $this->getPayments( $payment_name );
if ( ! isset( $payments['settlement'] ) || 'COD' != $payments['settlement'] ) {
$fee = 0;
} elseif ( 'change' != $this->options['cod_type'] ) {
$fee = isset( $this->options['cod_fee'] ) ? $this->options['cod_fee'] : 0;
} else {
$materials = array(
'total_items_price' => $current_entries['order']['total_items_price'],
'discount' => ( isset( $current_entries['order']['discount'] ) ) ? $current_entries['order']['discount'] : 0,
'shipping_charge' => ( isset( $current_entries['order']['shipping_charge'] ) ) ? $current_entries['order']['shipping_charge'] : 0,
'cod_fee' => 0,
'use_point' => 0,
);
$price = $amount_by_cod + $this->getTax( $amount_by_cod, $materials );
if ( $price <= $this->options['cod_first_amount'] ) {
$fee = $this->options['cod_first_fee'];
} elseif ( isset( $this->options['cod_amounts'] ) ) {
$last = count( $this->options['cod_amounts'] ) - 1;
if ( $price > $this->options['cod_amounts'][ $last ] ) {
$fee = $this->options['cod_end_fee'];
} else {
$fee = 0;
foreach ( $this->options['cod_amounts'] as $key => $value ) {
if ( $price <= $value ) {
$fee = $this->options['cod_fees'][ $key ];
break;
}
}
}
} else {
$fee = $this->options['cod_end_fee'];
}
}
$fee = apply_filters( 'usces_filter_getCODFee', $fee, $payment_name, $amount_by_cod, $current_entries );
return $fee;
}
public function getTax( $total, $materials = array() ) {
global $usces_settings;
if ( isset( $this->options['tax_display'] ) && 'deactivate' == $this->options['tax_display'] ) {
return 0;
}
if ( empty( $this->options['tax_rate'] ) ) {
return 0;
}
// if ( ! empty( $materials ) ) {
// extract( $materials );//need( 'total_items_price', 'shipping_charge', 'discount', 'cod_fee', 'use_point' )
// }
if ( $this->is_reduced_taxrate() ) {
if ( 'include' == $this->options['tax_mode'] ) {
return 0;
}
if ( ! empty( $materials ) ) {
extract( $materials );
if ( empty( $carts ) ) {
$carts = array();
$materials = compact( 'total_items_price', 'shipping_charge', 'discount', 'cod_fee', 'use_point', 'carts' );
}
}
$usces_tax = Welcart_Tax::get_instance();
$usces_tax->get_order_tax( $materials );
$tax = apply_filters( 'usces_filter_getTax', $usces_tax->tax, $materials );
} else {
if ( empty( $materials ) ) {
if ( 'include' == $this->options['tax_mode'] ) {
$tax = (float) sprintf( '%.3f', (float) $total * (float) $this->options['tax_rate'] / ( 100 + (float) $this->options['tax_rate'] ) );
} else {
$tax = (float) sprintf( '%.3f', (float) $total * (float) $this->options['tax_rate'] / 100 );
}
} else {
if ( 'include' == $this->options['tax_mode'] ) {
return 0;
}
extract( $materials ); // need( 'total_items_price', 'shipping_charge', 'discount', 'cod_fee', 'use_point' ).
if ( 1 == $this->options['point_coverage'] ) {
if ( 'products' == $this->options['tax_target'] ) {
$total = (float) $total_items_price + (float) $discount;
} else {
$total = (float) $total_items_price + (float) $discount + (float) $shipping_charge + (float) $cod_fee;
}
} else {
if ( 'products' == $this->options['tax_target'] ) {
$total = (float) $total_items_price + (float) $discount;
} else {
if ( empty( $use_point ) ) {
$use_point = 0;
}
$total = (float) $total_items_price + (float) $discount - (int) $use_point + (float) $shipping_charge + (float) $cod_fee;
}
}
$total = apply_filters( 'usces_filter_getTax_total', $total, $materials );
$tax = (float) sprintf( '%.3f', (float) $total * (float) $this->options['tax_rate'] / 100 );
}
$tax = usces_tax_rounding_off( $tax );
$tax = apply_filters( 'usces_filter_getTax', $tax, $materials );
}
return $tax;
}
public function set_cart_fees( $member, $entries ) {
global $usces_entries;
$carts = $this->cart->get_cart();
$entries = $this->cart->get_entry();
$total_items_price = $this->get_total_price();
$entries['order']['total_items_price'] = $total_items_price;
if ( empty( $this->options['postage_privilege'] ) || $total_items_price < $this->options['postage_privilege'] ) {
$shipping_charge = $this->getShippingCharge( $entries['delivery']['pref'], $carts, $entries );
} else {
$shipping_charge = 0;
}
$shipping_charge = apply_filters( 'usces_filter_set_cart_fees_shipping_charge', $shipping_charge, $carts, $entries );
$entries['order']['shipping_charge'] = $shipping_charge;
$payments = $this->getPayments( $entries['order']['payment_name'] );
$use_point = ( isset( $entries['order']['usedpoint'] ) ) ? (int) $entries['order']['usedpoint'] : 0;
if ( $this->is_reduced_taxrate() ) {
$usces_tax = Welcart_Tax::get_instance();
$discount = $usces_tax->get_order_discount( $carts );
$entries['order']['discount'] = $discount;
$amount_by_cod = $total_items_price - $use_point + $discount;
if ( 'all' == usces_is_fee_subject() ) {
$amount_by_cod += $shipping_charge;
}
$amount_by_cod = apply_filters( 'usces_filter_set_cart_fees_amount_by_cod', $amount_by_cod, $entries, $total_items_price, $use_point, $discount, $shipping_charge );
$cod_fee = $this->getCODFee( $entries['order']['payment_name'], $amount_by_cod, $entries );
$cod_fee = apply_filters( 'usces_filter_set_cart_fees_cod', $cod_fee, $entries, $total_items_price, $use_point, $discount, $shipping_charge, $amount_by_cod );
$entries['order']['cod_fee'] = $cod_fee;
if ( 'include' == $this->options['tax_mode'] ) {
$tax = 0;
} else {
$materials = compact( 'member', 'entries', 'carts', 'total_items_price', 'shipping_charge', 'payments', 'discount', 'cod_fee', 'use_point' );
$usces_tax->get_order_tax( $materials );
$tax = apply_filters( 'usces_filter_getTax', $usces_tax->tax, $materials );
}
$total_price = $total_items_price - $use_point + $discount + $shipping_charge + $cod_fee;
if ( $total_price < 0 ) {
$total_price = 0;
}
$total_price = apply_filters( 'usces_filter_set_cart_fees_total_price', $total_price, $total_items_price, $use_point, $discount, $shipping_charge, $cod_fee );
} else {
$discount = $this->get_order_discount( null, $carts );
$entries['order']['discount'] = $discount;
$amount_by_cod = $total_items_price - $use_point + $discount;
if ( 'all' == usces_is_fee_subject() ) {
$amount_by_cod += $shipping_charge;
}
$amount_by_cod = apply_filters( 'usces_filter_set_cart_fees_amount_by_cod', $amount_by_cod, $entries, $total_items_price, $use_point, $discount, $shipping_charge );
$cod_fee = $this->getCODFee( $entries['order']['payment_name'], $amount_by_cod, $entries );
$cod_fee = apply_filters( 'usces_filter_set_cart_fees_cod', $cod_fee, $entries, $total_items_price, $use_point, $discount, $shipping_charge, $amount_by_cod );
$entries['order']['cod_fee'] = $cod_fee;
$total_price = $total_items_price - $use_point + $discount + $shipping_charge + $cod_fee;
if ( $total_price < 0 ) {
$total_price = 0;
}
$total_price = apply_filters( 'usces_filter_set_cart_fees_total_price', $total_price, $total_items_price, $use_point, $discount, $shipping_charge, $cod_fee );
$materials = compact( 'member', 'entries', 'carts', 'total_items_price', 'shipping_charge', 'payments', 'discount', 'cod_fee', 'use_point' );
$tax = $this->getTax( $total_price, $materials );
}
$entries['order']['total_price'] = $total_price;
$entries['order']['tax'] = $tax;
if ( 'exclude' == $this->options['tax_mode'] ) {
if ( 0 < $use_point ) {
$total_full_price = $total_items_price - $use_point + $discount + $shipping_charge + $cod_fee + $tax;
if ( $total_full_price < 0 ) {
$total_full_price = 0;
}
} else {
$total_full_price = $total_price + $tax;
}
} else {
$total_full_price = $total_price;
}
$total_full_price = apply_filters( 'usces_filter_set_cart_fees_total_full_price', $total_full_price, $total_items_price, $use_point, $discount, $shipping_charge, $cod_fee );
$entries['order']['total_full_price'] = $total_full_price;
$mem_id = isset( $member['ID'] ) ? $member['ID'] : null;
$get_point = $this->get_order_point( $mem_id );
$get_point = apply_filters( 'usces_filter_set_get_point', $get_point, $entries, $carts );
$array = array(
'total_items_price' => $total_items_price,
'total_price' => $total_price,
'total_full_price' => $total_full_price,
'getpoint' => $get_point,
'usedpoint' => $use_point,
'discount' => $discount,
'shipping_charge' => $shipping_charge,
'cod_fee' => $cod_fee,
'tax' => $tax,
);
$this->cart->set_order_entry( $array );
$usces_entries = $this->cart->get_entry();
}
public function getPayments( $payment_name ) {
$init = array(
'id' => null,
'name' => null,
'explanation' => null,
'settlement' => null,
'module' => null,
'sort' => null,
'use' => null,
);
if ( '#none#' == $payment_name ) {
return $init;
}
$payments = usces_get_system_option( 'usces_payment_method', 'name' );
if ( isset( $payments[ $payment_name ] ) ) {
return $payments[ $payment_name ];
}
return $init;
}
public function is_maintenance() {
if ( 'Maintenancemode' == $this->options['display_mode'] ) {
return true;
} else {
return false;
}
}
public function get_member_history( $mem_id, $allow_filter = false ) {
global $wpdb;
$order_table = $wpdb->prefix . 'usces_order';
if ( is_user_logged_in() && is_admin() ) {
$query = $wpdb->prepare( "SELECT * FROM $order_table WHERE mem_id = %d ORDER BY order_date DESC", $mem_id );
$query = apply_filters( 'usces_filter_member_history_query', $query, $mem_id, $allow_filter );
$results = $wpdb->get_results( $query );
} elseif ( ! is_admin() ) {
$cancel_query = '%cancel%';
$estimate_query = '%estimate%';
$exclude_cancel = $this->usces_get_member_cookies( 'ord_ex_cancel' );
if ( $allow_filter && 'on' === (string) $exclude_cancel ) {
$condition = ' ( order_status NOT LIKE %s AND order_status NOT LIKE %s ) ';
} else {
$condition = ' ( order_status LIKE %s OR order_status NOT LIKE %s ) ';
}
$pur_date = $this->usces_get_member_cookies( 'pur-date' );
if ( $allow_filter && $pur_date ) {
$now = current_time( 'timestamp' );
$type_filter = 'date';
if ( false !== strpos( $pur_date, 'y_' ) ) {
$type_filter = 'year';
} elseif ( false !== strpos( $pur_date, 'm_' ) ) {
$type_filter = 'month';
}
if ( 'year' === $type_filter ) {
$purchase_year = (int) str_replace( 'y_', '', $pur_date );
} elseif ( 'month' === $type_filter ) {
$month_ago = (int) str_replace( 'm_', '', $pur_date );
$first_day_of_previous_months = strtotime( "first day of -{$month_ago} months", $now );
$last_day_of_previous_months = strtotime( "last day of -{$month_ago} months", $now );
$purchase_date_from_string = date( 'Y-m-d 00:00:00', $first_day_of_previous_months );
$purchase_date_to_string = date( 'Y-m-d 23:59:59', $last_day_of_previous_months );
} else {
$pur_date_val = (int) str_replace( 'd_', '', $pur_date );
$previous_date = strtotime( "-{$pur_date_val} days", $now );
$purchase_date_string = date( 'Y-m-d 00:00:00', $previous_date );
}
if ( 'year' === $type_filter ) {
$query = $wpdb->prepare(
"SELECT * FROM $order_table WHERE mem_id = %d AND YEAR(order_date) = %d AND {$condition} ORDER BY order_date DESC",
$mem_id,
$purchase_year,
$cancel_query,
$estimate_query
);
} elseif ( 'month' === $type_filter ) {
$query = $wpdb->prepare(
"SELECT * FROM $order_table WHERE mem_id = %d AND order_date >= %s AND order_date <= %s AND {$condition} ORDER BY order_date DESC",
$mem_id,
$purchase_date_from_string,
$purchase_date_to_string,
$cancel_query,
$estimate_query
);
} else {
$query = $wpdb->prepare(
"SELECT * FROM $order_table WHERE mem_id = %d AND order_date >= %s AND {$condition} ORDER BY order_date DESC",
$mem_id,
$purchase_date_string,
$cancel_query,
$estimate_query
);
}
} else {
$query = $wpdb->prepare(
"SELECT * FROM $order_table WHERE mem_id = %d AND {$condition} ORDER BY order_date DESC",
$mem_id,
$cancel_query,
$estimate_query
);
}
$query = apply_filters( 'usces_filter_member_history_query_front', $query, $mem_id, $allow_filter );
$results = $wpdb->get_results( $query );
}
$i = 0;
$res = array();
foreach ( $results as $value ) {
$cart = usces_get_ordercartdata( $value->ID );
$total_items_price = $this->get_total_price( $cart );
$data = array(
'ID' => $value->ID,
'cart' => $cart,
'condition' => wel_safe_unserialize( $value->order_condition ),
'getpoint' => $value->order_getpoint,
'usedpoint' => $value->order_usedpoint,
'discount' => $value->order_discount,
'shipping_charge' => $value->order_shipping_charge,
'payment_name' => $value->order_payment_name,
'cod_fee' => $value->order_cod_fee,
'tax' => $value->order_tax,
'total_items_price' => $total_items_price,
'order_status' => $value->order_status,
'date' => mysql2date( __( 'Y/m/d' ), $value->order_date ),
'order_date' => $value->order_date,
'order_delidue_date' => $value->order_delidue_date,
'order_delivery_method' => $value->order_delivery_method,
'order_delivery_method_name' => usces_delivery_method_name( $value->order_delivery_method, 'return' ),
'order_delivery_date' => $value->order_delivery_date,
'order_modified' => $value->order_modified,
);
$res[] = apply_filters( 'usces_filter_member_history_data', $data, $mem_id, $value, $cart, $total_items_price );
}
return $res;
}
public function get_post_term_ids( $post_id, $taxonomy ) {
global $wpdb;
$query = $wpdb->prepare(
"SELECT tt.term_id FROM $wpdb->term_relationships AS `tr`
INNER JOIN $wpdb->term_taxonomy AS `tt` ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE tt.taxonomy = %s AND tr.object_id = %d",
$taxonomy, $post_id
);
$ids = $wpdb->get_col( $query );
return $ids;
}
public function get_tag_names( $post_id ) {
global $wpdb;
$tag = 'post_tag';
$query = $wpdb->prepare(
"SELECT t.name FROM $wpdb->term_relationships AS `tr`
INNER JOIN $wpdb->term_taxonomy AS `tt` ON tt.term_taxonomy_id = tr.term_taxonomy_id
INNER JOIN $wpdb->terms AS `t` ON t.term_id = tt.term_id
WHERE tt.taxonomy = %s AND tr.object_id = %d",
$tag, $post_id
);
$names = $wpdb->get_col( $query );
return apply_filters( 'usces_filter_get_tag_names', $names, $post_id );
}
public function get_ID_byItemName( $item_code, $status = 'publish' ) {
global $wpdb;
$table = usces_get_tablename( 'usces_item' );
$id = $wpdb->get_var(
$wpdb->prepare(
"SELECT p.ID FROM {$wpdb->posts} AS `p`
INNER JOIN {$table} AS `item` ON p.ID = item.post_id
WHERE p.post_status = %s AND item.itemCode = %s",
$status,
$item_code
)
);
return $id;
}
/**
* @deprecated A1/C (Layer 3 / uscesid removal). uscesid 難読化生成。本体は不使用。未移行の拡張・
* クライアント後方互換のためのみ残置。全消費側移行後に get_uscesid()/uscesdc() ともども削除する。
*/
public function uscescv( $sessid, $flag ) {
$chars = '';
$i = 0;
$h = 0;
$usces_cookie = $this->get_cookie();
if ( isset( $usces_cookie['id'] ) && ! empty( $usces_cookie['id'] ) ) {
$cid = $usces_cookie['id'];
} elseif ( isset( $_SESSION['usces_cookieid'] ) && ! empty( $_SESSION['usces_cookieid'] ) ) {
$cid = $_SESSION['usces_cookieid'];
} else {
$cid = 0;
}
while ( $h < strlen( $sessid ) ) {
if ( 0 == $i % 3 ) {
$chars .= substr( $i, -1 );
} else {
$chars .= substr( $sessid, $h, 1 );
$h++;
}
$i++;
}
if ( $flag ) {
$postfix = ( isset( $_SERVER['REMOTE_ADDR'] ) && ! empty( $_SERVER['REMOTE_ADDR'] ) ) ? $_SERVER['REMOTE_ADDR'] : 'REMOTE_ADDR';
$postfix = apply_filters( 'usces_sessid_force', $postfix );
$sessid = $chars . '_' . $postfix . '_' . $cid . '_A';
} else {
$sessid = $chars . '_' . apply_filters( 'usces_sessid_flag', 'acting' ) . '_' . $cid . '_A';
}
$sessid = urlencode( base64_encode( $sessid ) );
return $sessid;
}
/**
* @deprecated A1/C (Layer 3 / uscesid removal). uscesid 復号。本体は不使用（A1 で唯一の呼び出しを撤去）。
* 未移行の拡張・クライアント（直接 uscesdc()→session_id() する nopriv AJAX）後方互換のためのみ残置。
* 全消費側移行後に get_uscesid()/uscescv() ともども削除する。
*/
public function uscesdc( $sessid ) {
$sessid = base64_decode( urldecode( $sessid ) );
list( $sess, $addr, $cookieid, $none ) = explode( '_', $sessid, 4 );
$postfix = ( isset( $_SERVER['REMOTE_ADDR'] ) && ! empty( $_SERVER['REMOTE_ADDR'] ) ) ? $_SERVER['REMOTE_ADDR'] : 'REMOTE_ADDR';
$postfix = apply_filters( 'usces_sessid_force', $postfix );
if ( 'acting' !== $addr && 'mobile' !== $addr && $postfix !== $addr ) {
$sessid = '';
return null;
}
$chars = '';
$h = 0;
while ( $h < strlen( $sess ) ) {
if ( 0 != $h % 3 ) {
$chars .= substr( $sess, $h, 1 );
}
$h++;
}
$sessid = $chars;
return $sessid;
}
public function get_visiter( $period ) {
global $wpdb;
$datestr = substr( get_date_from_gmt( gmdate( 'Y-m-d H:i:s', time() ) ), 0, 10 );
$yearstr = substr( $datestr, 0, 4 );
$monthstr = substr( $datestr, 5, 2 );
$daystr = substr( $datestr, 8, 2 );
if ( 'today' == $period ) {
$date = $datestr;
$today = $datestr;
} elseif ( 'thismonth' == $period ) {
$date = date( 'Y-m-01' );
$today = $datestr;
} elseif ( 'lastyear' == $period ) {
$date = date( 'Y-m-01', mktime( 0, 0, 0, (int) $monthstr, 1, (int) $yearstr-1 ) );
$today = date( 'Y-m-01', mktime( 0, 0, 0, (int) $monthstr, (int) $daystr, (int) $yearstr-1 ) );
}
$table_name = $wpdb->prefix . 'usces_access';
$query = $wpdb->prepare( "SELECT SUM(acc_num1) AS `ct1`, SUM(acc_num2) AS `ct2` FROM $table_name WHERE acc_date >= %s AND acc_date <= %s", $date, $today );
$res = $wpdb->get_row( $query, ARRAY_A );
if ( null == $res ) {
return 0;
} else {
return $res['ct1'] + $res['ct2'];
}
}
public function get_fvisiter( $period ) {
global $wpdb;
$datestr = substr( get_date_from_gmt( gmdate( 'Y-m-d H:i:s', time() ) ), 0, 10 );
$yearstr = substr( $datestr, 0, 4 );
$monthstr = substr( $datestr, 5, 2 );
$daystr = substr( $datestr, 8, 2 );
if ( 'today' == $period ) {
$date = $datestr;
$today = $datestr;
} elseif ( 'thismonth' == $period ) {
$date = date( 'Y-m-01' );
$today = $datestr;
} elseif ( 'lastyear' == $period ) {
$date = date( 'Y-m-01', mktime( 0, 0, 0, (int) $monthstr, 1, (int) $yearstr - 1 ) );
$today = date( 'Y-m-01', mktime( 0, 0, 0, (int) $monthstr, (int) $daystr, (int) $yearstr - 1 ) );
}
$table_name = $wpdb->prefix . 'usces_access';
$query = $wpdb->prepare( "SELECT SUM(acc_num2) AS `ct` FROM $table_name WHERE acc_date >= %s AND acc_date <= %s", $date, $today );
$res = $wpdb->get_var( $query );
if ( null == $res ) {
return 0;
} else {
return $res;
}
}
public function get_order_num( $period ) {
global $wpdb;
$datestr = substr( get_date_from_gmt( gmdate( 'Y-m-d H:i:s', time() ) ), 0, 10 );
$yearstr = substr( $datestr, 0, 4 );
$monthstr = substr( $datestr, 5, 2 );
$daystr = substr( $datestr, 8, 2 );
if ( 'today' == $period ) {
$date = date( 'Y-m-d 00:00:00', current_time( 'timestamp' ) );
$today = date( 'Y-m-d 23:59:59', current_time( 'timestamp' ) );
} elseif ( 'thismonth' == $period ) {
$date = date( 'Y-m-01 00:00:00', current_time( 'timestamp' ) );
$today = date( 'Y-m-d 23:59:59', current_time( 'timestamp' ) );
} elseif ( 'lastyear' == $period ) {
$date = date( 'Y-m-01 00:00:00', mktime( 0, 0, 0, (int) $monthstr, 1, (int) $yearstr - 1 ) );
$today = date( 'Y-m-d 23:59:59', mktime( 0, 0, 0, (int) $monthstr + 1, 0, (int) $yearstr - 1 ) );
}
$table_name = $wpdb->prefix . 'usces_order';
$query = $wpdb->prepare( "SELECT COUNT(ID) AS `ct` FROM $table_name WHERE order_date >= %s AND order_date <= %s AND 0 = LOCATE(%s, order_status) AND 0 = LOCATE(%s, order_status)", $date, $today, 'cancel', 'estimate' );
$res = $wpdb->get_var( $query );
if ( null == $res ) {
return 0;
} else {
return $res;
}
}
public function get_order_amount( $period ) {
global $wpdb;
$cache_key = 'wel_order_amount_period_' . $period;
$res = wp_cache_get( $cache_key );
if ( false === $res ) {
$datestr = substr( get_date_from_gmt( gmdate( 'Y-m-d H:i:s', time() ) ), 0, 10 );
$yearstr = substr( $datestr, 0, 4 );
$monthstr = substr( $datestr, 5, 2 );
$daystr = substr( $datestr, 8, 2 );
if ( 'today' == $period ) {
$date = date( 'Y-m-d 00:00:00', current_time( 'timestamp' ) );
$today = date( 'Y-m-d 23:59:59', current_time( 'timestamp' ) );
} elseif ( 'thismonth' == $period ) {
$date = date( 'Y-m-01 00:00:00', current_time( 'timestamp' ) );
$today = date( 'Y-m-d 23:59:59', current_time( 'timestamp' ) );
} elseif ( 'lastyear' == $period ) {
$date = date( 'Y-m-01 00:00:00', mktime( 0, 0, 0, (int) $monthstr, 1, (int) $yearstr - 1 ) );
$today = date( 'Y-m-d 23:59:59', mktime( 0, 0, 0, (int) $monthstr + 1, 0, (int) $yearstr - 1 ) );
}
$table_name = $wpdb->prefix . 'usces_order';
$query = $wpdb->prepare(
"SELECT
SUM(order_item_total_price) AS `price`,
SUM(order_usedpoint) AS `point`,
SUM(order_discount) AS `discount`,
SUM(order_shipping_charge) AS `shipping`,
SUM(order_cod_fee) AS `cod`,
SUM(order_tax) AS `tax`
FROM $table_name WHERE order_date >= %s AND order_date <= %s AND 0 = LOCATE(%s, order_status) AND 0 = LOCATE(%s, order_status)",
$date, $today, 'cancel', 'estimate'
);
$res = $wpdb->get_row( $query, ARRAY_A );
if ( null !== $res ) {
wp_cache_set( $cache_key, $res );
}
}
if ( null == $res ) {
return 0;
} else {
return $res['price'] - $res['point'] + $res['discount'] + $res['shipping'] + $res['cod'] + $res['tax'];
}
}
public function is_status( $need, $str ) {
if ( ! is_string( $str ) || empty( $str ) ) {
$array = array();
} else {
$array = explode( ',', $str );
}
return in_array( $need, $array );
}
public function make_status( $taio = '', $receipt = '', $admin = '' ) {
$str = '';
if ( '' != $taio && '#none#' != $taio ) {
$str .= $taio . ',';
}
if ( '' != $receipt && '#none#' != $receipt ) {
$str .= $receipt . ',';
}
if ( '' != $admin && '#none#' != $admin ) {
$str .= $admin . ',';
}
return $str;
}
public function get_memberid_by_email( $email ) {
global $wpdb;
$table_name = usces_get_tablename( 'usces_member' );
$query = $wpdb->prepare( "SELECT ID FROM $table_name WHERE mem_email = %s", $email );
$res = $wpdb->get_var( $query );
return $res;
}
public function get_condition() {
$order_conditions = array(
'display_mode' => $this->options['display_mode'],
'campaign_privilege' => $this->options['campaign_privilege'],
'campaign_category' => $this->options['campaign_category'],
'privilege_point' => $this->options['privilege_point'],
'privilege_discount' => $this->options['privilege_discount'],
'tax_display' => ( isset( $this->options['tax_display'] ) ) ? $this->options['tax_display'] : 'activate',
'tax_mode' => $this->options['tax_mode'],
'tax_target' => $this->options['tax_target'],
'tax_rate' => $this->options['tax_rate'],
'tax_method' => $this->options['tax_method'],
'applicable_taxrate' => ( isset( $this->options['applicable_taxrate'] ) ) ? $this->options['applicable_taxrate'] : 'standard',
'tax_rate_reduced' => ( isset( $this->options['tax_rate_reduced'] ) ) ? $this->options['tax_rate_reduced'] : $this->options['tax_rate'],
'membersystem_state' => $this->options['membersystem_state'],
'membersystem_point' => $this->options['membersystem_point'],
'point_coverage' => $this->options['point_coverage'],
);
return $order_conditions;
}
public function get_bestseller_ids( $days = '' ) {
global $wpdb;
$datestr = substr( get_date_from_gmt( gmdate( 'Y-m-d H:i:s', time() ) ), 0, 10 );
$yearstr = substr( $datestr, 0, 4 );
$monthstr = substr( $datestr, 5, 2 );
$daystr = substr( $datestr, 8, 2 );
$res = array();
$order_table_name = $wpdb->prefix . 'usces_order';
$where = '';
if ( empty( $days ) ) {
$days = 30;
}
$order_date = date( 'Y-m-d H:i:s', mktime( 0, 0, 0, (int) $monthstr, ( (int) $daystr - $days), (int) $yearstr ) );
$where = " WHERE order_date >= '{$order_date}'";
$query = "SELECT order_cart FROM {$order_table_name}" . $where;
$dbres = $wpdb->get_col( $query );
if ( ! $dbres ) {
return false;
}
foreach ( (array) $dbres as $carts ) {
$rows = wel_safe_unserialize( $carts );
foreach ( (array) $rows as $carts ) {
if ( 'publish' != get_post_status( $carts['post_id'] ) ) {
continue;
}
$id = $carts['post_id'];
$qu = $carts['quantity'];
if ( array_key_exists( $id, $res ) ) {
$res[ $id ] = $res[ $id ] + $qu;
} else {
$res[ $id ] = $qu;
}
}
}
arsort( $res );
$results = array_keys( $res );
return $results;
}
public function get_items_num() {
global $wpdb;
$res = $wpdb->get_var(
$wpdb->prepare(
"SELECT COUNT(ID) AS `ct` FROM {$wpdb->posts}
WHERE post_mime_type = %s AND post_type = %s AND post_status <> %s",
'item',
'post',
'trash'
)
);
return $res;
}
public function is_gptekiyo( $post_id, $sku, $quant ) {
$skus = $this->get_skus( $post_id, 'code' );
if ( ! isset( $skus[ $sku ]['gp'] ) || ! $skus[ $sku ]['gp'] ) {
return false;
}
$GpN1 = $this->getItemGpNum1( $post_id );
$GpN2 = $this->getItemGpNum2( $post_id );
$GpN3 = $this->getItemGpNum3( $post_id );
if ( empty( $GpN1 ) ) {
return false;
} elseif ( ! empty( $GpN1 ) && empty( $GpN2 ) ) {
if ( $quant >= $GpN1 ) {
return true;
} else {
return false;
}
} elseif ( ! empty( $GpN1 ) && ! empty( $GpN2 ) && empty( $GpN3 ) ) {
if ( $quant >= $GpN2 ) {
return true;
} elseif ( $quant >= $GpN1 && $quant < $GpN2 ) {
return true;
} else {
return false;
}
} elseif ( ! empty( $GpN1 ) && ! empty( $GpN2 ) && ! empty( $GpN3 ) ) {
if ( $quant >= $GpN3 ) {
return true;
} elseif ( $quant >= $GpN2 && $quant < $GpN3 ) {
return true;
} elseif ( $quant >= $GpN1 && $quant < $GpN2 ) {
return true;
} else{
return false;
}
}
}
public function get_available_delivery_method() {
if ( $this->cart->num_row() > 0 ) {
$cart = $this->cart->get_cart();
$before_deli = array();
$intersect = array();
$integration = array();
$temp = array();
$in = 0;
foreach ( $cart as $key => $row ) {
$deli = $this->getItemDeliveryMethod( $row['post_id'] );
if ( empty( $deli ) ) {
continue;
}
if ( 0 === $in ) {
$intersect = $deli;
}
$intersect = array_intersect( $deli, $intersect );
$before_deli = $deli;
foreach ( $deli as $value ) {
$integration[] = $value;
}
$in++;
}
$integration = array_unique( $integration );
foreach ( $integration as $id ) {
$index = $this->get_delivery_method_index( $id );
if ( 0 <= $index ) {
$temp[ $index ] = $id;
}
}
ksort( $temp );
$force = array( array_shift( $temp ) );
if ( empty( $intersect ) ) {
return $force;
} else {
return $intersect;
}
}
return array();
}
public function get_delivery_method_index( $id ) {
$index = false;
$delivery_method_count = ( $this->options['delivery_method'] && is_array( $this->options['delivery_method'] ) ) ? count( $this->options['delivery_method'] ) : 0;
for ( $i = 0; $i < $delivery_method_count; $i++ ) {
if ( isset( $this->options['delivery_method'][ $i ]['id'] ) && $this->options['delivery_method'][ $i ]['id'] === (int) $id ) {
$index = $i;
}
}
if ( false === $index ) {
return -1;
} else {
return $index;
}
}
public function get_shipping_charge_index( $id ) {
$index = false;
$shipping_charge_count = ( $this->options['shipping_charge'] && is_array( $this->options['shipping_charge'] ) ) ? count( $this->options['shipping_charge'] ) : 0;
for ( $i = 0; $i < $shipping_charge_count; $i++ ) {
if ( isset( $this->options['shipping_charge'][ $i ] ) && (int) $this->options['shipping_charge'][ $i ]['id'] == (int) $id ) {
$index = $i;
}
}
if ( false === $index ) {
return -1;
} else {
return $index;
}
}
public function get_initial_data( $xml ) {
$buf = file_get_contents( $xml );
preg_match_all( '@.*?(.*?).*?(.*?).*?(.*?).*?(.*?).*?@s', $buf, $match, PREG_SET_ORDER );
return $match;
}
public function getCurrencySymbol() {
global $usces_settings;
$cr = $this->options['system']['currency'];
list( $code, $decimal, $point, $seperator, $symbol ) = $usces_settings['currency'][ $cr ];
return $symbol;
}
public function getCartItemName( $post_id, $sku ) {
$name_arr = array();
$name_str = '';
foreach ( $this->options['indi_item_name'] as $key => $value ) {
if ( $value ) {
$pos = (int) $this->options['pos_item_name'][ $key ];
$ind = ( 0 === $pos ) ? 'A' : $pos;
switch ( $key ) {
case 'item_name':
$name_arr[ $ind ][ $key ] = $this->getItemName( $post_id );
break;
case 'item_code':
$name_arr[ $ind ][ $key ] = $this->getItemCode( $post_id );
break;
case 'sku_name':
$name_arr[ $ind ][ $key ] = $this->getItemSkuDisp( $post_id, $sku );
break;
case 'sku_code':
$name_arr[ $ind ][ $key ] = $sku;
break;
}
}
}
ksort( $name_arr );
foreach ( $name_arr as $vals ) {
foreach ( $vals as $key => $value ) {
$name_str .= $value . ' ';
}
}
$name_str = apply_filters( 'usces_admin_order_item_name_filter', $name_str, $post_id, $sku );
return trim( $name_str );
}
public function getCartItemName_byOrder( $cart_row ) {
$name_arr = array();
$name_str = '';
foreach ( $this->options['indi_item_name'] as $key => $value ) {
if ( $value ) {
$pos = (int) $this->options['pos_item_name'][ $key ];
$ind = ( 0 === $pos ) ? 'A' : $pos;
switch ( $key ) {
case 'item_name':
$name_arr[ $ind ][ $key ] = $cart_row['item_name'];
break;
case 'item_code':
$name_arr[ $ind ][ $key ] = $cart_row['item_code'];
break;
case 'sku_name':
$name_arr[ $ind ][ $key ] = $cart_row['sku_name'];
break;
case 'sku_code':
$name_arr[ $ind ][ $key ] = $cart_row['sku_code'];
break;
}
}
}
ksort( $name_arr );
foreach ( $name_arr as $vals ) {
foreach ( $vals as $key => $value ) {
$name_str .= $value . ' ';
}
}
$name_str = apply_filters( 'usces_filter_item_mame_by_order', $name_str, $cart_row );
return trim( $name_str );
}
public function set_reserve_pre_order_id() {
$entry = $this->cart->get_entry();
$id = ( isset( $entry['reserve']['pre_order_id'] ) && ! empty( $entry['reserve']['pre_order_id'] ) ) ? $entry['reserve']['pre_order_id'] : uniqid( '' );
$this->cart->set_pre_order_id( $id );
}
public function get_current_pre_order_id() {
$entry = $this->cart->get_entry();
$id = ( isset( $entry['reserve']['pre_order_id'] ) && ! empty( $entry['reserve']['pre_order_id'] ) ) ? $entry['reserve']['pre_order_id'] : null;
return $id;
}
public function get_order_id_by_pre_order_id( $pre_order_id ) {
global $wpdb;
$query = $wpdb->prepare( "SELECT order_id FROM {$wpdb->prefix}usces_order_meta WHERE meta_key = %s AND meta_value = %s", 'pre_order_id', $pre_order_id );
$order_id = $wpdb->get_var( $query );
return $order_id;
}
public function get_reserve( $order_id, $key ) {
global $wpdb;
$order_meta_table_name = $wpdb->prefix . 'usces_order_meta';
$query = $wpdb->prepare( "SELECT meta_value FROM $order_meta_table_name WHERE order_id = %d AND meta_key = %s", $order_id, $key );
$res = $wpdb->get_var( $query );
return $res;
}
public function get_order_meta_value( $key, $order_id ) {
global $wpdb;
$order_meta_table_name = $wpdb->prefix . 'usces_order_meta';
$query = $wpdb->prepare( "SELECT meta_value FROM $order_meta_table_name WHERE order_id = %d AND meta_key = %s", $order_id, $key );
$res = $wpdb->get_var( $query );
return $res;
}
public function set_order_meta_value( $key, $meta_value, $order_id, $check = 1 ) {
global $wpdb;
if ( empty( $order_id ) ) {
return;
}
$order_id = (int) $order_id;
if ( $check ) {
$order = $this->get_order_data( $order_id, 'direct' );
if ( null === $order ) {
return;
}
}
$table_name = $wpdb->prefix . 'usces_order_meta';
$query = $wpdb->prepare(
"SELECT count(*) FROM $table_name WHERE order_id = %d AND meta_key = %s",
$order_id, $key
);
$res = $wpdb->get_var( $query );
if ( 0 < $res ) {
$query = $wpdb->prepare(
"UPDATE $table_name SET meta_value = %s WHERE order_id = %d AND meta_key = %s",
$meta_value,
$order_id,
$key
);
$res2 = $wpdb->query( $query );
} else {
$query = $wpdb->prepare(
"INSERT INTO $table_name (order_id, meta_key, meta_value)
VALUES(%d, %s, %s)",
$order_id,
$key,
$meta_value
);
$res2 = $wpdb->query( $query );
}
return $res2;
}
public function del_order_meta( $key, $order_id ) {
global $wpdb;
$table_name = $wpdb->prefix . 'usces_order_meta';
$query = $wpdb->prepare( "DELETE FROM $table_name WHERE order_id = %d AND meta_key = %s", $order_id, $key );
$res = $wpdb->query( $query );
return $res;
}
public function set_session_custom_member( $member_id ) {
unset( $_SESSION['usces_member']['custom_member'] );
$meta = usces_has_custom_field_meta( 'member' );
if ( is_array( $meta ) ) {
$keys = array_keys( $meta );
foreach ( $keys as $key ) {
$csmb_key = 'csmb_' . $key;
$_SESSION['usces_member']['custom_member'][ $key ] = wel_safe_maybe_unserialize( $this->get_member_meta_value( $csmb_key, $member_id ) );
}
}
}
public function reg_custom_member( $member_id ) {
$csmb_meta = usces_has_custom_field_meta( 'member' );
if ( is_array( $csmb_meta ) ) {
foreach ( $csmb_meta as $key => $entry ) {
if ( '4' == $entry['means'] ) {
$this->del_member_meta( 'csmb_' . $key, $member_id );
}
}
}
if ( ! empty( $_POST['custom_member'] ) ) {
foreach ( $_POST['custom_member'] as $key => $value ) {
$csmb_key = 'csmb_' . $key;
$value = wel_safe_text_serialize( $value );
if ( is_array( $value ) ) {
$value = serialize( $value );
}
$res = $this->set_member_meta_value( $csmb_key, $value, $member_id );
if ( false === $res ) {
return false;
}
}
} elseif ( isset( $_POST['custom_customer'] ) ) {
foreach ( $_POST['custom_customer'] as $key => $value ) {
$csmb_key = 'csmb_' . $key;
$value = wel_safe_text_serialize( $value );
if ( is_array( $value ) ) {
$value = serialize( $value );
}
$res = $this->set_member_meta_value( $csmb_key, $value, $member_id );
if ( false === $res ) {
return false;
}
}
}
}
public function save_order_acting_data( $rand ) {
global $wpdb;
$data = serialize(
array(
'cart' => $this->cart->get_cart(),
'entry' => $this->cart->get_entry(),
)
);
$table_name = $wpdb->prefix . 'usces_access';
$query = $wpdb->prepare(
"INSERT INTO $table_name (acc_type, acc_str1, acc_date, acc_key, acc_value)
VALUES(%s, %s, now(), %s, %s)",
'acting_data',
$this->get_uscesid(false),
$rand,
$data
);
$res = $wpdb->query( $query );
return $res;
}
public function set_member_meta_value( $key, $meta_value, $member_id = '' ) {
global $wpdb;
if ( WCUtils::is_blank( $member_id ) ) {
if ( ! $this->is_member_logged_in() ) {
return;
}
$member = $this->get_member();
$member_id = $member['ID'];
}
$table_name = usces_get_tablename( 'usces_member_meta' );
$query = $wpdb->prepare( "SELECT count(*) FROM $table_name WHERE member_id = %d AND meta_key = %s", $member_id, $key );
$res = $wpdb->get_var( $query );
if ( 0 < $res ) {
$query = $wpdb->prepare(
"UPDATE $table_name SET meta_value = %s WHERE member_id = %d AND meta_key = %s",
$meta_value,
$member_id,
$key
);
$res2 = $wpdb->query( $query );
} else {
$query = $wpdb->prepare(
"INSERT INTO $table_name (member_id, meta_key, meta_value)
VALUES(%d, %s, %s)",
$member_id,
$key,
$meta_value
);
$res2 = $wpdb->query( $query );
}
return $res2;
}
public function get_member_meta_value( $key, $member_id ) {
global $wpdb;
$table_name = usces_get_tablename( 'usces_member_meta' );
$query = $wpdb->prepare( "SELECT meta_value FROM $table_name WHERE member_id = %d AND meta_key = %s", $member_id, $key );
$res = $wpdb->get_var( $query );
return $res;
}
public function del_member_meta( $key, $member_id ) {
global $wpdb;
$table_name = usces_get_tablename( 'usces_member_meta' );
$query = $wpdb->prepare( "DELETE FROM $table_name WHERE member_id = %d AND meta_key = %s", $member_id, $key );
$res = $wpdb->query( $query );
return $res;
}
public function get_member_meta( $member_id ) {
global $wpdb;
$table_name = usces_get_tablename( 'usces_member_meta' );
$query = $wpdb->prepare( "SELECT * FROM $table_name WHERE member_id = %d AND meta_key <> 'customer_country' AND meta_key NOT LIKE %s", $member_id, 'csmb_%' );
$res = $wpdb->get_results( $query, ARRAY_A );
return $res;
}
public function get_settle_info_field( $order_id ) {
global $wpdb;
$fields = array();
$table_name = $wpdb->prefix . 'usces_order_meta';
$meta_keys = apply_filters( 'usces_filter_settle_info_field_meta_keys', array( 'settlement_id', 'order_number', 'res_tracking_id', 'SID', 'TransactionId' ) );
$query = $wpdb->prepare( "SELECT meta_key, meta_value FROM $table_name WHERE order_id = %d AND ( meta_key LIKE %s OR meta_key IN( %s ) )", $order_id, 'acting_%', implode( "','", $meta_keys ) );
$query = stripslashes( $query );
$res = $wpdb->get_results( $query, ARRAY_A );
if ( ! $res ) {
return $fields;
}
foreach ( $res as $value ) {
if ( in_array( $value['meta_key'], $meta_keys ) ) {
$meta_key = $value['meta_key'];
if ( 'settlement_id' == $meta_key ) {
$meta_values = wel_safe_maybe_unserialize( $value['meta_value'] );
if ( is_array( $meta_values ) ) {
foreach ( $meta_values as $key => $meta_value ) {
$fields[ $key ] = $meta_value;
}
} else {
$fields['settlement_id'] = $meta_values;
}
} else {
$fields[ $meta_key ] = $value['meta_value'];
}
} elseif ( 'acting_' == substr( $value['meta_key'], 0, 7 ) ) {
$meta_values = usces_unserialize( $value['meta_value'] );
if ( is_array( $meta_values ) ) {
foreach ( $meta_values as $key => $meta_value ) {
$fields[ $key ] = $meta_value;
}
} else {
$meta_values = wel_safe_maybe_unserialize( $value['meta_value'] );
if ( is_array( $meta_values ) ) {
foreach ( $meta_values as $key => $meta_value ) {
$fields[ $key ] = $meta_value;
}
}
}
}
}
return $fields;
}
public function get_post_custom( $post_id, $orderby = 'meta_id', $order = 'ASC' ) {
global $wpdb;
$table = $wpdb->prefix . 'postmeta';
$meta_list = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key, meta_value FROM $table WHERE post_id = %d ORDER BY $orderby $order", $post_id ), ARRAY_A );
if ( ! empty( $meta_list ) ) {
foreach ( $meta_list as $metarow ) {
$mkey = $metarow['meta_key'];
$mval = $metarow['meta_value'];
$res[ $mkey ][] = $mval;
}
}
return $res;
}
public function get_post_user_custom( $post_id, $orderby = 'meta_id', $order = 'ASC' ) {
global $wpdb;
$res = array();
$table = $wpdb->prefix . 'postmeta';
$meta_list = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key, meta_value FROM $table WHERE post_id = %d ORDER BY $orderby $order", $post_id ), ARRAY_A );
if ( ! empty( $meta_list ) ) {
foreach ( $meta_list as $metarow ) {
if ( 0 === strpos( $metarow['meta_key'], '_' ) ) {
continue;
}
$mkey = $metarow['meta_key'];
$mval = $metarow['meta_value'];
if ( array_key_exists( $mkey, $res ) ) {
$cval = $res[ $mkey ];
$cval = (array) $cval;
$cval[] = $mval;
$res[ $mkey ] = $cval;
} else {
$res[ $mkey ] = $mval;
}
}
}
$res = apply_filters( 'usces_filter_get_post_user_custom', $res, $meta_list, $post_id, $orderby, $order );
return $res;
}
public function get_currency( $amount, $symbol_pre = false, $symbol_post = false, $seperator_flag = true ) {
global $usces_settings;
$cr = $this->options['system']['currency'];
list( $code, $decimal, $point, $seperator, $symbol ) = $usces_settings['currency'][ $cr ];
if ( ! $seperator_flag ) {
$seperator = '';
}
$price = number_format( (double) $amount, $decimal, $point, $seperator );
if ( $symbol_pre ) {
$price = ( usces_is_entity( $symbol ) ? mb_convert_encoding( $symbol, 'UTF-8', 'HTML-ENTITIES' ) : $symbol ) . $price;
}
if ( $symbol_post ) {
$price = $price . __( $code, 'usces' );
}
$price = apply_filters( 'usces_filter_get_currency', $price, $amount, $symbol_pre, $symbol_post, $seperator_flag );
return $price;
}
public function get_currency_code() {
global $usces_settings;
$cr = $this->options['system']['currency'];
list( $code, $decimal, $point, $seperator, $symbol ) = $usces_settings['currency'][ $cr ];
return $code;
}
public function get_currency_decimal() {
global $usces_settings;
$cr = $this->options['system']['currency'];
list( $code, $decimal, $point, $seperator, $symbol ) = $usces_settings['currency'][ $cr ];
return $decimal;
}
public function get_next_page_uri( $type, $current ) {
global $wpdb;
$table = $wpdb->prefix . 'usces_' . $type;
if ( ! isset( $_COOKIE[ $table ] ) ) {
return false;
}
$cookie = ( isset( $_COOKIE[ $table ] ) ) ? json_decode( str_replace( "\'", "'", str_replace( '\"', '"', $_COOKIE[ $table ] ) ), true ) : array();
if ( ! isset( $cookie['currentPageIds'] ) ) {
return false;
}
$ids = $cookie['currentPageIds'];
foreach ( $ids as $key => $id ) {
if ( $id == $current ) {
$next = isset( $ids[ ( $key + 1 ) ] ) ? $ids[ ( $key + 1 ) ] : '';
break;
}
}
if ( empty( $next ) ) {
$uri = '';
} else {
$uri = USCES_ADMIN_URL . "?page=usces_{$type}list&{$type}_action=edit&{$type}_id=" . $next;
}
return esc_url( $uri );
}
public function get_prev_page_uri( $type, $current ) {
global $wpdb;
$table = $wpdb->prefix . 'usces_' . $type;
if ( ! isset( $_COOKIE[ $table ] ) ) {
return false;
}
$cookie = ( isset( $_COOKIE[ $table ] ) ) ? json_decode( str_replace( "\'", "'", str_replace( '\"', '"', $_COOKIE[ $table ] ) ), true ) : array();
if ( ! isset( $cookie['currentPageIds'] ) ) {
return false;
}
$ids = $cookie['currentPageIds'];
foreach ( $ids as $key => $id ) {
if ( $id == $current ) {
$prev = isset( $ids[ ( $key - 1 ) ] ) ? $ids[ ( $key - 1 ) ] : '';
break;
}
}
if ( empty( $prev ) ) {
$uri = '';
} else {
$uri = USCES_ADMIN_URL . "?page=usces_{$type}list&{$type}_action=edit&{$type}_id=" . $prev;
}
return esc_url( $uri );
}
public function is_reduced_taxrate() {
$reduced = ( isset( $this->options['applicable_taxrate'] ) && 'reduced' == $this->options['applicable_taxrate'] ) ? true : false;
return $reduced;
}
public function sc_company_name() {
return htmlspecialchars( $this->options['company_name'], ENT_COMPAT );
}
public function sc_zip_code() {
return htmlspecialchars( $this->options['zip_code'], ENT_COMPAT );
}
public function sc_address1() {
return htmlspecialchars( $this->options['address1'], ENT_COMPAT );
}
public function sc_address2() {
return htmlspecialchars( $this->options['address2'], ENT_COMPAT );
}
public function sc_tel_number() {
return htmlspecialchars( $this->options['tel_number'], ENT_COMPAT );
}
public function sc_fax_number() {
return htmlspecialchars( $this->options['fax_number'], ENT_COMPAT );
}
public function sc_inquiry_mail() {
return htmlspecialchars( $this->options['inquiry_mail'], ENT_COMPAT );
}
public function sc_payment() {
$payments = usces_get_system_option( 'usces_payment_method', 'sort' );
$htm = "\n";
foreach ( (array) $payments as $payment ) {
$htm .= '- ' . htmlspecialchars( $payment['name'], ENT_COMPAT ) . "
\n";
$htm .= nl2br( htmlspecialchars( $payment['explanation'], ENT_COMPAT ) ) . " \n";
}
$htm .= "
\n";
return $htm;
}
public function sc_payment_title() {
$payments = $this->options['payment_method'];
$htm = "\n";
foreach ( (array) $payments as $payment ) {
$htm .= '- ' . esc_html( $payment['name'] ) . "
\n";
}
$htm .= "
\n";
return $htm;
}
public function sc_cod_fee() {
return number_format( $this->options['cod_fee'] );
}
public function sc_start_point() {
return number_format( $this->options['start_point'] );
}
public function sc_postage_privilege() {
if ( empty( $this->options['postage_privilege'] ) ) {
return;
}
return number_format( $this->options['postage_privilege'] );
}
public function sc_shipping_charge() {
$entry = $this->cart->get_entry();
$country = ( isset( $entry['delivery']['country'] ) && ! empty( $entry['delivery']['country'] ) ) ? $entry['delivery']['country'] : $entry['customer']['country'];
$arr = array();
foreach ( (array) $this->options['shipping_charge'] as $charges ) {
foreach ( (array) $charges[ $country ] as $value ) {
$arr[] = $value;
}
}
sort( $arr );
$min = $arr[0];
rsort( $arr );
$max = $arr[0];
if ( $min == $max ) {
$res = number_format( $min );
} else {
$res = number_format( $min ) . __( ' - ', 'usces' ) . number_format( $max );
}
return $res;
}
public function sc_site_url() {
return get_option( 'home' );
}
public function sc_button_to_cart( $atts ) {
extract(
shortcode_atts(
array(
'item' => '',
'sku' => '',
'value' => __( 'to the cart', 'usces' ),
'force' => 0,
'quant' => 0,
'opt' => 1,
),
$atts
)
);
$post_id = $this->get_ID_byItemName( $item );
$datas = $this->get_skus( $post_id, 'code' );
$zaikonum = ( isset( $datas[ $sku ]['stocknum'] ) ) ? $datas[ $sku ]['stocknum'] : null;
$zaiko = ( isset( $datas[ $sku ]['stock'] ) ) ? $datas[ $sku ]['stock'] : 2;
$gptekiyo = ( isset( $datas[ $sku ]['gp'] ) ) ? $datas[ $sku ]['gp'] : null;
$skuPrice = ( isset( $datas[ $sku ]['price'] ) ) ? $datas[ $sku ]['price'] : 0;
$sku_enc = urlencode( $sku );
$options = usces_get_opts( $post_id, 'sort' );
$mats = compact( 'item', 'sku', 'value', 'force', 'quant', 'post_id', 'datas', 'zaikonum', 'zaiko', 'gptekiyo', 'skuPrice', 'sku_enc' );
if ( ! $this->is_item_zaiko( $post_id, $sku ) ) {
return '' . esc_html( $this->zaiko_status[ $zaiko ] ) . '
';
}
$html = "';
$html .= '' . usces_singleitem_error_message( $post_id, $sku, 'return' ) . '
' . "\n";
return $html;
}
public function filter_itemPage( $content ) {
global $post;
$html = '';
if ( ( 'item' != $post->post_mime_type || ! is_single() ) ) {
return $content;
}
if ( post_password_required( $post ) ) {
return $content;
}
$temp_path = apply_filters( 'usces_template_path_single_item', USCES_PLUGIN_DIR . '/templates/single_item.php' );
include $temp_path;
$content = apply_filters( 'usces_filter_itemPage', $html, $post->ID );
return $content;
}
public function filter_cartContent( $content ) {
global $post;
$html = '';
switch ( $this->page ) {
case 'cart':
$temp_path = apply_filters( 'usces_template_path_cart', USCES_PLUGIN_DIR . '/templates/cart/cart.php' );
include $temp_path;
break;
case 'customer':
$temp_path = apply_filters( 'usces_template_path_customer', USCES_PLUGIN_DIR . '/templates/cart/customer_info.php' );
include $temp_path;
break;
case 'delivery':
$temp_path = apply_filters( 'usces_template_path_delivery', USCES_PLUGIN_DIR . '/templates/cart/delivery_info.php' );
include $temp_path;
break;
case 'confirm':
$temp_path = apply_filters( 'usces_template_path_confirm', USCES_PLUGIN_DIR . '/templates/cart/confirm.php' );
include $temp_path;
break;
case 'ordercompletion':
$temp_path = apply_filters( 'usces_template_path_ordercompletion', USCES_PLUGIN_DIR . '/templates/cart/completion.php' );
include $temp_path;
break;
case 'cartverifying':
$temp_path = apply_filters( 'usces_template_path_cartverifying', USCES_PLUGIN_DIR . '/templates/cart/verifying.php' );
include $temp_path;
break;
case 'cartverified':
$temp_path = apply_filters( 'usces_template_path_cartverified', USCES_PLUGIN_DIR . '/templates/cart/verified.php' );
include $temp_path;
break;
case 'error':
$temp_path = apply_filters( 'usces_template_path_carterror', USCES_PLUGIN_DIR . '/templates/cart/error.php' );
include $temp_path;
break;
case 'maintenance':
$temp_path = apply_filters( 'usces_template_path_maintenance', USCES_PLUGIN_DIR . '/templates/cart/maintenance.php' );
include $temp_path;
break;
case 'search_item':
$temp_path = apply_filters( 'usces_template_path_search_item', USCES_PLUGIN_DIR . '/templates/search_item.php' );
include $temp_path;
break;
case 'wp_search':
if ( 'item' == $post->post_mime_type ) {
$temp_path = apply_filters( 'usces_template_path_wp_search', USCES_PLUGIN_DIR . '/templates/wp_search_item.php' );
include $temp_path;
} else {
$html = $content;
}
break;
default:
$html = $content;
}
if ( $this->use_ssl && ( $this->is_cart_or_member_page( $_SERVER['REQUEST_URI'] ) || $this->is_inquiry_page( $_SERVER['REQUEST_URI'] ) ) ) {
$html = str_replace( 'src="' . site_url(), 'src="' . USCES_SSL_URL_ADMIN, $html );
}
$html = apply_filters( 'usces_filter_cartContent', $html );
$content = $html;
remove_filter( 'the_title', array( $this, 'filter_cartTitle' ) );
return $content;
}
public function filter_cartTitle( $title ) {
if ( is_admin() ) {
return $title;
}
if ( 'Cart' == $title || __( 'Cart', 'usces' ) == $title ) {
switch ( $this->page ) {
case 'cart':
$newtitle = apply_filters( 'usces_filter_title_cart', __( 'In the cart', 'usces' ) );
break;
case 'customer':
$newtitle = apply_filters( 'usces_filter_title_customer', __( 'Customer Information', 'usces' ) );
break;
case 'delivery':
$newtitle = apply_filters( 'usces_filter_title_delivery', __( 'Shipping / Payment options', 'usces' ) );
break;
case 'confirm':
$newtitle = apply_filters( 'usces_filter_title_confirm', __( 'Confirmation', 'usces' ) );
break;
case 'ordercompletion':
$newtitle = apply_filters( 'usces_filter_title_ordercompletion', __( 'Completion', 'usces' ) );
break;
case 'error':
$newtitle = apply_filters( 'usces_filter_title_carterror', __( 'Error', 'usces' ) );
break;
case 'cartverified':
$newtitle = apply_filters( 'usces_filter_title_cartverified', __( 'Member registration complete', 'usces' ) );
break;
case 'search_item':
$newtitle = apply_filters( 'usces_filter_title_search_item', __( "'AND' search by categories", 'usces' ) );
break;
case 'maintenance':
$newtitle = apply_filters( 'usces_filter_title_maintenance', __( 'Under Maintenance', 'usces' ) );
break;
case 'login':
$newtitle = apply_filters( 'usces_filter_title_login', __( 'Log-in for members', 'usces' ) );
break;
default:
$newtitle = apply_filters( 'usces_filter_title_cart_default', $title );
}
} else {
$newtitle = $title;
}
$newtitle = apply_filters( 'usces_filter_cartTitle', $newtitle );
return $newtitle;
}
public function action_cartFilter() {
add_filter( 'the_title', array( $this, 'filter_cartTitle' ), 20 );
add_filter( 'the_content', array( $this, 'filter_cartContent' ), 20 );
}
public function action_search_item() {
include get_template_directory() . '/page.php';
exit;
}
public function filter_memberContent( $content ) {
global $post;
$html = '';
if ( 'activate' == $this->options['membersystem_state'] ) {
if ( $this->is_member_logged_in() ) {
$member_regmode = 'editmemberform';
$temp_path = apply_filters( 'usces_template_path_member', USCES_PLUGIN_DIR . '/templates/member/member.php' );
include $temp_path;
} else {
switch ( $this->page ) {
case 'login':
$temp_path = apply_filters( 'usces_template_path_login', USCES_PLUGIN_DIR . '/templates/member/login.php' );
include $temp_path;
break;
case 'lostmemberpassword':
$temp_path = apply_filters( 'usces_template_path_lostpassword', USCES_PLUGIN_DIR . '/templates/member/lostpassword.php' );
include $temp_path;
break;
case 'changepassword':
$temp_path = apply_filters( 'usces_template_path_changepassword', USCES_PLUGIN_DIR . '/templates/member/changepassword.php' );
include $temp_path;
break;
case 'newcompletion':
case 'editcompletion':
case 'lostcompletion':
case 'changepasscompletion':
$temp_path = apply_filters( 'usces_template_path_membercompletion', USCES_PLUGIN_DIR . '/templates/member/completion.php' );
include $temp_path;
break;
case 'memberverifying':
$temp_path = apply_filters( 'usces_template_path_memberverifying', USCES_PLUGIN_DIR . '/templates/member/verifying.php' );
include $temp_path;
break;
// case 'memberverified':
// $temp_path = apply_filters('usces_template_path_memberverified', USCES_PLUGIN_DIR . '/templates/member/member_verified.php');
// include $temp_path;
// break;
case 'newmemberform':
$member_form_title = apply_filters( 'usces_filter_title_newmemberform', __( 'New enrollment form', 'usces' ) );
$member_regmode = 'newmemberform';
$temp_path = apply_filters( 'usces_template_path_member_form', USCES_PLUGIN_DIR . '/templates/member/member_form.php' );
include $temp_path;
break;
default:
$temp_path = apply_filters( 'usces_template_path_login', USCES_PLUGIN_DIR . '/templates/member/login.php' );
include $temp_path;
}
}
} else {
$html .= '' . __( 'Member Services is not running currently.', 'usces' ) . '
';
}
$content = $html;
remove_filter( 'the_title', array( $this, 'filter_memberTitle' ), 20 );
return $content;
}
public function filter_memberTitle( $title ) {
if ( is_admin() ) {
return $title;
}
if ( 'activate' == $this->options['membersystem_state'] && $this->is_member_page( $_SERVER['REQUEST_URI'] ) ) {
switch ( $this->page ) {
case 'login':
$newtitle = apply_filters( 'usces_filter_title_login', __( 'Log-in for members', 'usces' ) );
break;
case 'newmemberform':
$newtitle = apply_filters( 'usces_filter_title_newmemberform', __( 'New enrollment form', 'usces' ) );
break;
case 'lostmemberpassword':
$newtitle = apply_filters( 'usces_filter_title_lostmemberpassword', __( 'The new password acquisition', 'usces' ) );
break;
case 'changepassword':
$newtitle = apply_filters( 'usces_filter_title_changepassword', __( 'Change password', 'usces' ) );
break;
case 'newcompletion':
case 'editcompletion':
case 'lostcompletion':
case 'changepasscompletion':
$newtitle = apply_filters( 'usces_filter_title_changepasscompletion', __( 'Completion', 'usces' ) );
break;
case 'memberverifying':
$newtitle = apply_filters( 'usces_filter_title_memberverifying', __( 'Verifying', 'usces' ) );
break;
case 'error':
$newtitle = apply_filters( 'usces_filter_title_membererror', __( 'Error', 'usces' ) );
break;
default:
$newtitle = apply_filters( 'usces_filter_title_member_default', $title );
}
} else {
$newtitle = $title;
}
$newtitle = apply_filters( 'usces_filter_memberTitle', $newtitle );
return $newtitle;
}
public function action_memberFilter() {
add_filter( 'the_title', array( $this, 'filter_memberTitle' ), 20 );
add_filter( 'the_content', array( $this, 'filter_memberContent' ), 20 );
}
public function filter_usces_cart_css() {
$path = get_stylesheet_directory_uri() . '/usces_cart.css';
return $path;
}
public function filter_divide_item() {
global $wp_query;
if ( ( $this->options['divide_item'] && ! is_category() && ! is_search() && ! is_singular() && ! is_admin() ) ) {
$ids = $this->getItemIds( 'front' );
if ( isset( $wp_query->query_vars['post__not_in'] ) ) {
$wp_query->query_vars['post__not_in'] = $ids;
}
}
if ( is_admin() ) {
$ids = $this->getItemIds( 'back' );
if ( isset( $wp_query->query_vars['post__not_in'] ) ) {
$wp_query->query_vars['post__not_in'] = $ids;
}
}
do_action( 'usces_action_divide_item' );
}
public function load_upload_template() {
$post_id = $_POST['post_id'];
$file = 'upload_template01.php';
include get_template_directory() . '/' . $file;
exit;
}
public function filter_itemimg_anchor_rel( $html ) {
if ( is_single() ) {
$str = ' rel="' . $this->options['itemimg_anchor_rel'] . '"';
} else {
$str = '';
}
return $html . $str;
}
public function filter_permalink( $link ) {
if ( false !== strpos( '?page_id=4', $link ) || false !== strpos( '?page_id=3', $link ) || false !== strpos( 'usces-cart', $link ) || false !== strpos( 'usces-member', $link ) ) {
$link = str_replace( 'http://', 'https://', $link );
}
return $link;
}
public function filter_cart_page_header( $html ) {
if ( ! empty( $this->options['cart_page_data']['header']['cart'] ) ) {
$html = $this->options['cart_page_data']['header']['cart'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_cart_page_footer( $html ) {
if ( ! empty( $this->options['cart_page_data']['footer']['cart'] ) ) {
$html = $this->options['cart_page_data']['footer']['cart'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_customer_page_header( $html ) {
if ( ! empty( $this->options['cart_page_data']['header']['customer'] ) ) {
$html = $this->options['cart_page_data']['header']['customer'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_customer_page_footer( $html ) {
if ( ! empty( $this->options['cart_page_data']['footer']['customer'] ) ) {
$html = $this->options['cart_page_data']['footer']['customer'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_delivery_page_header( $html ) {
if ( ! empty( $this->options['cart_page_data']['header']['delivery'] ) ) {
$html = $this->options['cart_page_data']['header']['delivery'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_delivery_page_footer( $html ) {
if ( ! empty( $this->options['cart_page_data']['footer']['delivery'] ) ) {
$html = $this->options['cart_page_data']['footer']['delivery'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_confirm_page_header( $html ) {
if ( ! empty( $this->options['cart_page_data']['header']['confirm'] ) ) {
$html = $this->options['cart_page_data']['header']['confirm'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_confirm_page_footer( $html ) {
if ( ! empty( $this->options['cart_page_data']['footer']['confirm'] ) ) {
$html = $this->options['cart_page_data']['footer']['confirm'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_cartcompletion_page_header( $html ) {
if ( ! empty( $this->options['cart_page_data']['header']['completion'] ) ) {
$html = $this->options['cart_page_data']['header']['completion'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_cartcompletion_page_footer( $html ) {
if ( ! empty( $this->options['cart_page_data']['footer']['completion'] ) ) {
$html = $this->options['cart_page_data']['footer']['completion'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_login_page_header( $html ) {
if ( ! empty( $this->options['member_page_data']['header']['login'] ) ) {
$html = $this->options['member_page_data']['header']['login'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_login_page_footer( $html ) {
if ( ! empty( $this->options['member_page_data']['footer']['login'] ) ) {
$html = $this->options['member_page_data']['footer']['login'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_newmember_page_header( $html ) {
if ( ! empty( $this->options['member_page_data']['header']['newmember'] ) ) {
$html = $this->options['member_page_data']['header']['newmember'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_newmember_page_footer( $html ) {
if ( ! empty( $this->options['member_page_data']['footer']['newmember'] ) ) {
$html = $this->options['member_page_data']['footer']['newmember'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_newpass_page_header( $html ) {
if ( ! empty( $this->options['member_page_data']['header']['newpass'] ) ) {
$html = $this->options['member_page_data']['header']['newpass'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_newpass_page_footer( $html ) {
if ( ! empty( $this->options['member_page_data']['footer']['newpass'] ) ) {
$html = $this->options['member_page_data']['footer']['newpass'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_changepass_page_header( $html ) {
if ( ! empty( $this->options['member_page_data']['header']['changepass'] ) ) {
$html = $this->options['member_page_data']['header']['changepass'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_changepass_page_footer( $html ) {
if ( ! empty( $this->options['member_page_data']['footer']['changepass'] ) ) {
$html = $this->options['member_page_data']['footer']['changepass'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_memberinfo_page_header( $html ) {
if ( ! empty( $this->options['member_page_data']['header']['memberinfo'] ) ) {
$html = $this->options['member_page_data']['header']['memberinfo'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_memberinfo_page_footer( $html ) {
if ( ! empty( $this->options['member_page_data']['footer']['memberinfo'] ) ) {
$html = $this->options['member_page_data']['footer']['memberinfo'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_membercompletion_page_header( $html ) {
if ( ! empty( $this->options['member_page_data']['header']['completion'] ) ) {
$html = $this->options['member_page_data']['header']['completion'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function filter_membercompletion_page_footer( $html ) {
if ( ! empty( $this->options['member_page_data']['footer']['completion'] ) ) {
$html = $this->options['member_page_data']['footer']['completion'];
}
return do_shortcode( stripslashes( nl2br( $html ) ) );
}
public function action_cart_page_header() {
if ( ! empty( $this->options['cart_page_data']['header']['cart'] ) ) {
$html = $this->options['cart_page_data']['header']['cart'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_cart_page_footer() {
if ( ! empty( $this->options['cart_page_data']['footer']['cart'] ) ) {
$html = $this->options['cart_page_data']['footer']['cart'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_customer_page_header() {
if ( ! empty( $this->options['cart_page_data']['header']['customer'] ) ) {
$html = $this->options['cart_page_data']['header']['customer'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_customer_page_footer() {
if ( ! empty( $this->options['cart_page_data']['footer']['customer'] ) ) {
$html = $this->options['cart_page_data']['footer']['customer'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_delivery_page_header() {
if ( ! empty( $this->options['cart_page_data']['header']['delivery'] ) ) {
$html = $this->options['cart_page_data']['header']['delivery'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_delivery_page_footer() {
if ( ! empty( $this->options['cart_page_data']['footer']['delivery'] ) ) {
$html = $this->options['cart_page_data']['footer']['delivery'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_confirm_page_header() {
if ( ! empty( $this->options['cart_page_data']['header']['confirm'] ) ) {
$html = $this->options['cart_page_data']['header']['confirm'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_confirm_page_footer() {
if ( ! empty( $this->options['cart_page_data']['footer']['confirm'] ) ) {
$html = $this->options['cart_page_data']['footer']['confirm'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_cartcompletion_page_header() {
if ( ! empty( $this->options['cart_page_data']['header']['completion'] ) ) {
$html = $this->options['cart_page_data']['header']['completion'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_cartcompletion_page_footer() {
if ( ! empty( $this->options['cart_page_data']['footer']['completion'] ) ) {
$html = $this->options['cart_page_data']['footer']['completion'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_login_page_header() {
if ( ! empty( $this->options['member_page_data']['header']['login'] ) ) {
$html = $this->options['member_page_data']['header']['login'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_login_page_footer() {
if ( ! empty( $this->options['member_page_data']['footer']['login'] ) ) {
$html = $this->options['member_page_data']['footer']['login'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_newmember_page_header() {
if ( ! empty( $this->options['member_page_data']['header']['newmember'] ) ) {
$html = $this->options['member_page_data']['header']['newmember'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_newmember_page_footer() {
if ( ! empty( $this->options['member_page_data']['footer']['newmember'] ) ) {
$html = $this->options['member_page_data']['footer']['newmember'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_newpass_page_header() {
if ( ! empty( $this->options['member_page_data']['header']['newpass'] ) ) {
$html = $this->options['member_page_data']['header']['newpass'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_newpass_page_footer() {
if ( ! empty( $this->options['member_page_data']['footer']['newpass'] ) ) {
$html = $this->options['member_page_data']['footer']['newpass'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_changepass_page_header() {
if ( ! empty( $this->options['member_page_data']['header']['changepass'] ) ) {
$html = $this->options['member_page_data']['header']['changepass'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_changepass_page_footer() {
if ( ! empty( $this->options['member_page_data']['footer']['changepass'] ) ) {
$html = $this->options['member_page_data']['footer']['changepass'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_memberinfo_page_header() {
if ( ! empty( $this->options['member_page_data']['header']['memberinfo'] ) ) {
$html = $this->options['member_page_data']['header']['memberinfo'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_memberinfo_page_footer() {
if ( ! empty( $this->options['member_page_data']['footer']['memberinfo'] ) ) {
$html = $this->options['member_page_data']['footer']['memberinfo'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_membercompletion_page_header() {
if ( ! empty( $this->options['member_page_data']['header']['completion'] ) ) {
$html = $this->options['member_page_data']['header']['completion'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function action_membercompletion_page_footer() {
if ( ! empty( $this->options['member_page_data']['footer']['completion'] ) ) {
$html = $this->options['member_page_data']['footer']['completion'];
echo do_shortcode( stripslashes( nl2br( $html ) ) );
}
}
public function filter_confirm_page_notes( $html ) {
if ( ! empty( $this->options['cart_page_data']['confirm_notes'] ) ) {
$html = '' . $this->options['cart_page_data']['confirm_notes'] . '
';
}
return stripslashes( nl2br( $html ) );
}
public function action_confirm_page_notes() {
if ( ! empty( $this->options['cart_page_data']['confirm_notes'] ) ) {
$html = '' . $this->options['cart_page_data']['confirm_notes'] . '
';
echo stripslashes( nl2br( $html ) );
}
}
/**
* Get member cookies.
*
* @param string $key string cookies key.
*
* @return string
*/
public function usces_get_member_cookies( $key ) {
$result = '';
switch ( $key ) {
case 'ord_ex_cancel':
$ex_cancel = filter_input( INPUT_GET, 'ord_ex_cancel' );
if ( $ex_cancel ) {
$result = ( 'on' === $ex_cancel ) ? 'on' : 'off';
} else {
$cookie = $this->get_cookie( 'usces_front' );
$result = isset( $cookie['ord_ex_cancel'] ) ? $cookie['ord_ex_cancel'] : 'on';
$result = apply_filters( 'usces_filter_ord_ex_cancel_init', $result );
}
break;
case 'pur-date':
$result = filter_input( INPUT_GET, 'pur-date' );
if ( null === $result ) {
$cookie = $this->get_cookie( 'usces_front' );
$result = isset( $cookie['usces_purdate'] ) ? $cookie['usces_purdate'] : 'd_30';
$result = apply_filters( 'usces_filter_ord_purdate_init', $result );
}
break;
}
return $result;
}
}
```