; ?>/images/loading-publish.gif)
' );
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce': "",
'mode' : "get_settlement_log"
}
}).done( function( retVal, dataType ) {
$( "#settlement-log-response" ).html( "" );
if ( retVal.status == "OK" ) {
$( "#settlement-log-list" ).html( retVal.result );
}
}).fail( function( retVal ) {
$( "#settlement-log-response" ).html( "" );
});
return false;
},
get_settlement_log_detail: function( log_key ) {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce': "",
'mode' : "get_settlement_log_detail",
'log_key' : log_key
}
}).done( function( retVal, dataType ) {
if ( retVal.status == "OK" ) {
$( "#settlement-log-detail" ).html( retVal.result );
}
}).fail( function( retVal ) {
});
return false;
},
search_settlement_log: function( log_key ) {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce': "",
'mode' : "search_settlement_log",
'log_key' : log_key
}
}).done( function( retVal, dataType ) {
$( "#settlement-log-response" ).html( "" );
if ( retVal.status == "OK" ) {
$( "#settlement-log-list" ).html( retVal.result );
$( "#searchLogDialog" ).dialog( "close" );
}
}).fail( function( retVal ) {
});
return false;
},
delete_settlement_log: function( log_key ) {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce': "",
'mode' : "delete_settlement_log",
'log_key' : log_key
}
}).done( function( retVal, dataType ) {
if ( retVal.status == "OK" ) {
$( "#settlement-log-list" ).html( "" );
$( "#settlement-log-list" ).html( retVal.result );
}
}).fail( function( retVal ) {
});
return false;
},
delete_settlement_log_all: function() {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce': "",
'mode' : "delete_settlement_log_all"
}
}).done( function( retVal, dataType ) {
if ( retVal.status == "OK" ) {
$( "#settlement-log-list" ).html( "" );
$( "#settlement-log-list" ).html( retVal.result );
}
}).fail( function( retVal ) {
});
return false;
},
revival_settlement_data: function( log_key, register_date ) {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'mode' : "revival_order_data",
'wc_nonce' : "",
'log_key' : log_key,
'register_date': register_date
}
}).done( function( retVal, dataType ) {
if ( retVal.status == "OK" ) {
alert( "" );
$( "#settlementLogDetailDialog" ).dialog( "close" );
$( "#settlementLogDialog" ).dialog( "close" );
location.reload();
}
}).fail( function( retVal ) {
});
return false;
},
get_settlement_error_log: function() {
$( "#settlement-error-log-response" ).html( '' );
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce' : "",
'mode' : "get_settlement_error_log"
}
}).done( function( retVal, dataType ) {
$( "#settlement-error-log-response" ).html( "" );
if ( retVal.status == "OK" ) {
$( "#settlement-error-log-list" ).html( retVal.result );
}
}).fail( function( retVal ) {
$( "#settlement-error-log-response" ).html( "" );
});
return false;
},
get_settlement_error_log_detail: function( log_id ) {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce' : "",
'mode' : "get_settlement_error_log_detail",
'log_id' : log_id
}
}).done( function( retVal, dataType ) {
if ( retVal.status == "OK" ) {
$( "#settlement-error-log-detail" ).html( retVal.result );
}
}).fail( function( retVal ) {
});
return false;
},
delete_settlement_error_log: function( log_id ) {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce' : "",
'mode' : "delete_settlement_error_log",
'log_id' : log_id
}
}).done( function( retVal, dataType ) {
if ( retVal.status == "OK" ) {
if ( retVal.nodata == "nodata" ) {
location.reload();
} else {
$( "#settlement-error-log-list" ).html( "" );
$( "#settlement-error-log-list" ).html( retVal.result );
}
}
}).fail( function( retVal ) {
});
return false;
},
delete_settlement_error_log_all: function() {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce' : "",
'mode' : "delete_settlement_error_log_all"
}
}).done( function( retVal, dataType ) {
if ( retVal.status == "OK" ) {
location.reload();
}
}).fail( function( retVal ) {
});
return false;
},
output_settlement_error_log: function( log_id ) {
location.href = "?page=usces_orderlist&order_action=dlsettlementerrorlog&log_id="+log_id+"&noheader=true&wc_nonce=";
},
reset_settlement_notice: function() {
$.ajax({
url: ajaxurl,
type: "POST",
dataType: "json",
data: {
'action' : "order_item_ajax",
'wc_nonce' : "",
'mode' : "reset_settlement_notice"
}
}).done( function( retVal, dataType ) {
}).fail( function( retVal ) {
});
return false;
}
};
$( document ).on( "click", "#settlementlog", function() {
$( "#settlementLogDialog" ).dialog( "open" );
});
$( "#settlementLogDialog" ).dialog({
bgiframe: true,
autoOpen: false,
height: 400,
width: 800,
resizable: true,
modal: true,
buttons: {
"": function() {
$( "#searchLogDialog" ).dialog( "open" );
},
"": function() {
var log_key = "";
$( ".log-check" ).each( function( i ) {
if ( $( this ).prop( 'checked' ) ) {
log_key += $( this ).val()+':';
}
});
if ( log_key != "" ) {
if ( confirm( "" ) ) {
log_key = log_key.substr( 0, ( log_key.length - 1 ) );
settlement_operation.delete_settlement_log( log_key );
}
} else {
if ( confirm( "" ) ) {
settlement_operation.delete_settlement_log_all();
}
}
},
"": function() {
$( this ).dialog( "close" );
}
},
close: function() {
},
open: function() {
$( "#settlement-log-list" ).html( "" );
settlement_operation.get_settlement_log();
}
});
$( document ).on( "click", ".log-detail", function() {
var key = $( this ).attr( "id" );
$( "#settlement-log-detail" ).html( "" );
settlement_operation.get_settlement_log_detail( key );
$( "#settlementLogDetailDialog" ).dialog( "open" );
});
$( "#settlementLogDetailDialog" ).dialog({
bgiframe: true,
autoOpen: false,
height: 600,
width: 800,
resizable: true,
modal: true,
buttons: {
"": function() {
if ( confirm( "" ) ) {
settlement_operation.revival_settlement_data( $( "#log_key" ).val(), $( "input[name='register_date']:checked" ).val() );
}
},
"": function() {
$( this ).dialog( "close" );
}
},
close: function() {
}
});
$( "#searchLogDialog" ).dialog({
bgiframe: true,
autoOpen: false,
height: 210,
width: 300,
resizable: false,
modal: true,
buttons: {
"": function() {
var log_key = $( "#search_log_key" ).val();
settlement_operation.search_settlement_log( log_key );
$( this ).dialog( "close" );
},
"": function() {
$( this ).dialog( "close" );
}
},
close: function() {
},
open: function() {
$( "#search_log_key" ).val( "" );
}
});
$( document ).on( "click", "#settlement_errorlog", function() {
$( "#settlementErrorLogDialog" ).dialog( "open" );
});
$( "#settlementErrorLogDialog" ).dialog({
bgiframe: true,
autoOpen: false,
height: 400,
width: 800,
resizable: true,
modal: true,
buttons: {
"": function() {
var log_id = "";
$( ".error-log-check" ).each( function( i ) {
if ( $( this ).prop( 'checked' ) ) {
log_id += $( this ).val()+':';
}
});
if ( log_id != "" ) {
log_id = log_id.substr( 0, ( log_id.length - 1 ) );
}
settlement_operation.output_settlement_error_log( log_id );
},
"": function() {
var log_id = "";
$( ".error-log-check" ).each( function( i ) {
if ( $( this ).prop( 'checked' ) ) {
log_id += $( this ).val() + ':';
}
});
if ( log_id != "" ) {
if ( confirm( "" ) ) {
log_id = log_id.substr( 0, ( log_id.length - 1 ) );
settlement_operation.delete_settlement_error_log( log_id );
}
} else {
if ( confirm( "" ) ) {
settlement_operation.delete_settlement_error_log_all();
}
}
},
"": function() {
$( this ).dialog( "close" );
}
},
close: function() {
settlement_operation.reset_settlement_notice();
},
open: function() {
$( "#settlement-error-log-list" ).html( "" );
settlement_operation.get_settlement_error_log();
}
});
$( document ).on( "click", ".error-log-detail", function() {
var key = $( this ).attr( "id" );
$( "#settlement-error-log-detaily" ).html( "" );
settlement_operation.get_settlement_error_log_detail( key );
$( "#settlementErrorLogDetailDialog" ).dialog( "open" );
});
$( "#settlementErrorLogDetailDialog" ).dialog({
bgiframe: true,
autoOpen: false,
height: 600,
width: 600,
resizable: true,
modal: true,
buttons: {
"": function() {
settlement_operation.output_settlement_error_log( $( "#log_id" ).val() );
},
"": function() {
$( this ).dialog( "close" );
}
},
close: function() {
}
});
prefix . 'usces_log';
$data = array();
$data['usces_cart'] = ( isset( $_SESSION['usces_cart'] ) ) ? $_SESSION['usces_cart'] : array();
$data['usces_entry'] = ( isset( $_SESSION['usces_entry'] ) ) ? $_SESSION['usces_entry'] : array();
$data['usces_member'] = ( isset( $_SESSION['usces_member'] ) ) ? $_SESSION['usces_member'] : array();
$data['remote_addr'] = ( isset( $_SERVER['REMOTE_ADDR'] ) ) ? $_SERVER['REMOTE_ADDR'] : '';
if ( $mobile ) {
$data['wcex_mobile'] = $mobile;
}
$data = apply_filters( 'usces_filter_save_order_acting_data', $data );
$order_data = usces_get_acting_data( $key );
if ( empty( $order_data['datetime'] ) ) {
$query = $wpdb->prepare(
"INSERT INTO {$log_table_name} ( `datetime`, `log`, `log_type`, `log_key` ) VALUES ( %s, %s, %s, %s )",
current_time( 'mysql' ),
serialize( $data ),
'acting_data',
$key
);
} else {
$query = $wpdb->prepare(
"UPDATE {$log_table_name} SET `datetime` = %s,`log` = %s WHERE `log_type` = %s AND `log_key` = %s",
current_time( 'mysql' ),
serialize( $data ),
'acting_data',
$key
);
}
$res = $wpdb->query( $query );
return $res;
}
/**
* 決済直前ログ取得
*
* @param string $key Log key.
* @return array
*/
function usces_get_acting_data( $key ) {
global $wpdb;
$log_table_name = $wpdb->prefix . 'usces_log';
$query = $wpdb->prepare( "SELECT * FROM {$log_table_name} WHERE `log_type` = %s AND `log_key` = %s", 'acting_data', $key );
$data = $wpdb->get_row( $query, ARRAY_A );
if ( $data ) {
$order_data = wel_safe_unserialize( $data['log'] );
$order_data['key'] = $data['log_key'];
$order_data['datetime'] = $data['datetime'];
} else {
$order_data = array(
'usces_cart' => array(),
'usces_entry' => array(),
'usces_member' => array(),
'remote_addr' => '',
'key' => $key,
'datetime' => '',
);
}
return $order_data;
}
/**
* 決済直前データ取得
*
* @param string $key Log key.
* @return array
*/
function usces_restore_order_acting_data( $key ) {
$order_data = usces_get_acting_data( $key );
$_SESSION['usces_cart'] = $order_data['usces_cart'];
$_SESSION['usces_entry'] = $order_data['usces_entry'];
$_SESSION['usces_member'] = $order_data['usces_member'];
do_action( 'usces_action_restore_order_acting_data', $order_data );
return $order_data;
}
/**
* 決済エラーログ保存
*
* @param array $log Log data.
* @param boolean $mobile Is mobile.
* @return mixed
*/
function usces_save_order_acting_error( $log, $mobile = false ) {
global $usces, $wpdb;
$log_table_name = $wpdb->prefix . 'usces_log';
$datetime = current_time( 'mysql' );
update_option( 'usces_settlement_notice', $datetime );
do_action( 'usces_action_save_order_acting_error', $log, $datetime );
$query = $wpdb->prepare( "INSERT INTO {$log_table_name} ( `datetime`, `log`, `log_type`, `log_key` ) VALUES ( %s, %s, %s, %s )",
$datetime,
serialize( $log ),
'acting_error',
$log['key']
);
$res = $wpdb->query( $query );
return $res;
}
/**
* Escape a settlement log field for HTML output.
*
* Log fields come from unauthenticated payment-gateway callbacks, so a field
* may arrive as an array (e.g. `?rand[]=x`) or as an object. Flatten anything
* non-scalar before escaping, because esc_html() cannot take an array.
*
* Use this for text nodes only. Attribute values need esc_attr().
*
* @param mixed $value Raw log field.
* @return string Escaped, HTML-safe string.
*/
function wel_esc_settlement_log( $value ) {
if ( null === $value || is_scalar( $value ) ) {
return esc_html( (string) $value );
}
return esc_html( wp_json_encode( $value ) );
}
/**
* 決済直前ログ一覧
*
* @param string $log_key Log key.
* @return void
*/
function usces_get_settlement_log( $log_key = '' ) {
global $usces, $wpdb;
$log_table_name = $wpdb->prefix . 'usces_log';
$html = '';
if ( ! empty( $log_key ) ) {
$query = $wpdb->prepare( "SELECT * FROM {$log_table_name} WHERE `log_type` = 'acting_data' AND `log_key` = %s ORDER BY datetime DESC", $log_key );
} else {
$query = "SELECT * FROM {$log_table_name} WHERE `log_type` = 'acting_data' ORDER BY datetime DESC";
}
$log_data = $wpdb->get_results( $query, ARRAY_A );
if ( $log_data ) {
$html = '| ' . __( 'Register date', 'usces' ) . ' | ' . __( 'Link key', 'usces' ) . ' | ' . __( 'Name', 'usces' ) . ' | ' . __( 'Type of payment', 'usces' ) . ' | IP | ' . esc_html( $data['datetime'] ) . ' | ' . esc_html( $data['log_key'] ) . ' | ' . $name . ' | ' . $payment_name . $payment_structure . ' | ' . esc_html( $ip ) . ' | '; } $html .= '
|---|
| ' . __( 'Register date', 'usces' ) . ' | ' . esc_html( $order_data['datetime'] ) . ' |
|
|---|---|---|
| ' . __( 'Link key', 'usces' ) . ' | ' . wel_esc_settlement_log( $order_data['key'] ) . ' | |
' . __( 'Customer Information', 'usces' ) . ' | |
| ' . __( 'e-mail adress', 'usces' ) . ' | ' . esc_html( $usces_entries['customer']['mailaddress1'] ) . ' |
|---|---|
' . __( 'Others', 'usces' ) . ' | |
| ' . __( 'shipping option', 'usces' ) . ' | ' . esc_html( usces_delivery_method_name( $usces_entries['order']['delivery_method'], 'return' ) ) . ' |
|---|---|
| ' . __( 'Delivery date', 'usces' ) . ' | ' . esc_html( $usces_entries['order']['delivery_date'] ) . ' |
| ' . __( 'Delivery Time', 'usces' ) . ' | ' . esc_html( $usces_entries['order']['delivery_time'] ) . ' |
| ' . __( 'payment method', 'usces' ) . ' | ' . esc_html( $usces_entries['order']['payment_name'] . usces_payment_detail( $usces_entries ) ) . ' |
| ' . __( 'Notes', 'usces' ) . ' | ' . esc_html( $usces_entries['order']['note'] ) . ' |
' . __( 'Cart', 'usces' ) . ' | |||
| No | ' . __( 'Items', 'usces' ) . ' | ' . __( 'Quantity', 'usces' ) . ' | ' . __( 'Unit price', 'usces' ) . ' |
|---|---|---|---|
| ' . $num . ' | '; $html .= '' . esc_html( __( 'The cart data is broken and the item details cannot be restored. The original number of items is also unknown. This line is not included when the order data is recreated.', 'usces' ) ) . ' | '; $html .= '- | '; $html .= '- | '; $html .= '
| ' . $num . ' | '; $html .= '' . esc_html( urldecode( $cart_item_name ) ) . ' ' . $optstr . ' | ';
$html .= '' . $quantity . ' | '; $html .= '' . usces_crform( $price, true, false, 'return' ) . ' | '; $html .= '
| ' . __( 'total items', 'usces' ) . ' | ' . usces_crform( $usces_entries['order']['total_items_price'], true, false, 'return' ) . ' | ||
| ' . apply_filters( 'usces_confirm_discount_label', __( 'Campaign discount', 'usces' ) ) . ' | ' . usces_crform( $usces_entries['order']['discount'], true, false, 'return' ) . ' | ||
| ' . usces_tax_label( array(), 'return' ) . ' | ' . usces_tax( $usces_entries, 'return' ) . ' | ||
| ' . __( 'Shipping', 'usces' ) . ' | ' . usces_crform( $usces_entries['order']['shipping_charge'], true, false, 'return' ) . ' | ||
| ' . apply_filters( 'usces_filter_cod_label', __( 'COD fee', 'usces' ) ) . ' | ' . usces_crform( $usces_entries['order']['cod_fee'], true, false, 'return' ) . ' | ||
| ' . usces_tax_label( array(), 'return' ) . ' | ' . usces_tax( $usces_entries, 'return' ) . ' | ||
| ' . __( 'Used points', 'usces' ) . ' | ' . number_format( $usces_entries['order']['usedpoint'] ) . ' | ||
| ' . __( 'Payment amount', 'usces' ) . ' | ' . usces_crform( $usces_entries['order']['total_full_price'], true, false, 'return' ) . ' | ||
| ' . __( 'Register date', 'usces' ) . ' | ' . __( 'Link key', 'usces' ) . ' | ' . __( 'Type of payment', 'usces' ) . ' | ' . __( 'Status', 'usces' ) . ' | ||
|---|---|---|---|---|---|
| ' . esc_html( $data['datetime'] ) . ' | ' . esc_html( $data['log_key'] ) . ' | ' . wel_esc_settlement_log( $acting ) . ' | ' . wel_esc_settlement_log( $result ) . ' |
| ' . __( 'Register date', 'usces' ) . ' | ' . esc_html( $data['datetime'] ) . ' |
|---|---|
| ' . __( 'Link key', 'usces' ) . ' | ' . wel_esc_settlement_log( $log['key'] ) . ' |
| ' . __( 'Result', 'usces' ) . ' | ' . wel_esc_settlement_log( $log['result'] ) . ' |
| ' . esc_html( $key ) . ':' . esc_html( $key2 ) . ' | ' . esc_html( serialize( $value2 ) ) . ' |
| ' . esc_html( $key ) . ':' . esc_html( $key2 ) . ' | ' . esc_html( $value2 ) . ' |
| ' . esc_html( $key ) . ' | ' . esc_html( $value ) . ' |