# usc-e-shop/1.3.8/functions/function.php Welcart e-Commerce, version 1.3.8. 4,279 lines. - Page: https://pluginprobe.com/plugins/usc-e-shop/1.3.8/code/functions/function.php - Raw: https://pluginprobe.com/plugins/usc-e-shop/1.3.8/raw/functions/function.php - Modified: 2013-11-05T06:32:02+00:00 Line numbers below start at 1. Link to a line or a range by appending a fragment to the page URL, for example `https://pluginprobe.com/plugins/usc-e-shop/1.3.8/code/functions/function.php#L10-L20`. ```php stripslashes_deep_post($_POST); $order_para = array( 'to_name' => sprintf(__('Mr/Mrs %s', 'usces'), trim(urldecode($_POST['name']))), 'to_address' => trim($_POST['mailaddress']), 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => trim(urldecode($_POST['subject'])), 'message' => trim(urldecode($_POST['message'])) ); $order_para = apply_filters( 'usces_ajax_send_mail_para_to_customer', $order_para); $res = usces_send_mail( $order_para ); if($res){ $tableName = $wpdb->prefix . "usces_order"; $order_id = $_POST['order_id']; $checked = $_POST['checked']; $query = $wpdb->prepare("SELECT `order_check` FROM $tableName WHERE ID = %d", $order_id); $res = $wpdb->get_var( $query ); $checkfield = unserialize($res); if( !isset($checkfield[$checked]) ) $checkfield[$checked] = $checked; //$checkfield = 'OK'; $query = $wpdb->prepare("UPDATE $tableName SET `order_check`=%s WHERE ID = %d", serialize($checkfield), $order_id); $wpdb->query( $query ); $bcc_para = array( 'to_name' => 'Shop Admin', 'to_address' => $usces->options['order_mail'], 'from_name' => 'Welcart Auto BCC', 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => trim(urldecode($_POST['subject'])) . ' to ' . sprintf(__('Mr/Mrs %s', 'usces'), trim(urldecode($_POST['name']))), 'message' => trim(urldecode($_POST['message'])) ); $bcc_para = apply_filters( 'usces_ajax_send_mail_para_to_manager', $bcc_para); usces_send_mail( $bcc_para ); return 'success'; }else{ return 'error'; } } function usces_order_confirm_message($order_id) { global $usces, $wpdb, $usces_settings; $tableName = $wpdb->prefix . "usces_order"; $query = $wpdb->prepare("SELECT * FROM $tableName WHERE ID = %d", $order_id); $data = $wpdb->get_row( $query, ARRAY_A ); $deli = unserialize($data['order_delivery']); $cart = unserialize($data['order_cart']); $country = $usces->get_order_meta_value('customer_country', $order_id); $customer = array( 'name1' => $data['order_name1'], 'name2' => $data['order_name2'], 'name3' => $data['order_name3'], 'name4' => $data['order_name4'], 'zipcode' => $data['order_zip'], 'country' => $country, 'pref' => $data['order_pref'], 'address1' => $data['order_address1'], 'address2' => $data['order_address2'], 'address3' => $data['order_address3'], 'tel' => $data['order_tel'], 'fax' => $data['order_fax'], ); $condition = unserialize($data['order_condition']); $total_full_price = $data['order_item_total_price'] - $data['order_usedpoint'] + $data['order_discount'] + $data['order_shipping_charge'] + $data['order_cod_fee'] + $data['order_tax']; $mail_data = $usces->options['mail_data']; $payment = $usces->getPayments( $data['order_payment_name'] ); $res = false; if($_POST['mode'] == 'mitumoriConfirmMail'){ $msg_body = "\r\n\r\n\r\n" . __('Estimate','usces') . "\r\n"; $msg_body .= usces_mail_line( 1, $data['order_email'] );//******************** $msg_body .= apply_filters('usces_filter_order_confirm_mail_first', NULL, $data); $msg_body .= uesces_get_mail_addressform( 'admin_mail_customer', $customer, $order_id ); $msg_body .= __('estimate number','usces') . " : " . $order_id . "\r\n"; }else{ $msg_body = "\r\n\r\n\r\n" . __('** Article order contents **','usces') . "\r\n"; $msg_body .= usces_mail_line( 1, $data['order_email'] );//******************** $msg_body .= apply_filters('usces_filter_order_confirm_mail_first', NULL, $data); $msg_body .= uesces_get_mail_addressform( 'admin_mail_customer', $customer, $order_id ); $msg_body .= __('Order number','usces') . " : " . usces_get_deco_order_id( $order_id ) . "\r\n"; } $meisai = __('Items','usces') . " : \r\n"; foreach ( (array)$cart as $cart_row ) { $post_id = $cart_row['post_id']; $sku = urldecode($cart_row['sku']); $quantity = $cart_row['quantity']; $options = $cart_row['options']; $itemCode = $usces->getItemCode($post_id); $itemName = $usces->getItemName($post_id); $cartItemName = $usces->getCartItemName($post_id, $sku); $skuPrice = $cart_row['price']; // $pictids = $usces->get_pictids($itemCode); if (!empty($options)) { // $optstr = implode(',', $options); } else { $optstr = ''; $options = array(); } $meisai .= usces_mail_line( 2, $data['order_email'] );//-------------------- $meisai .= "$cartItemName \r\n"; if( is_array($options) && count($options) > 0 ){ $optstr = ''; foreach($options as $key => $value){ //20110629ysk start 0000190 //if( !empty($key) ) // $meisai .= $key . ' : ' . urldecode($value) . "\r\n"; if( !empty($key) ) { $key = urldecode($key); if(is_array($value)) { $c = ''; $optstr .= $key . ' : '; foreach($value as $v) { $optstr .= $c.urldecode($v); $c = ', '; } $optstr .= "\r\n"; } else { $optstr .= $key . ' : ' . urldecode($value) . "\r\n"; } } //20110629ysk end } $meisai .= apply_filters( 'usces_filter_option_adminmail', $optstr, $options); } $meisai .= __('Unit price','usces') . " ".usces_crform( $skuPrice, true, false, 'return' ) . __(' * ','usces') . $cart_row['quantity'] . "\r\n"; } $meisai .= usces_mail_line( 3, $data['order_email'] );//==================== $meisai .= __('total items','usces') . " : " . usces_crform( $data['order_item_total_price'], true, false, 'return' ) . "\r\n"; if ( $data['order_usedpoint'] != 0 ) $meisai .= __('use of points','usces') . " : " . number_format($data['order_usedpoint']) . __('Points','usces') . "\r\n"; if ( $data['order_discount'] != 0 ) $meisai .= apply_filters('usces_confirm_discount_label', __('Campaign disnount', 'usces'), $order_id) . " : " . usces_crform( $data['order_discount'], true, false, 'return' ) . "\r\n"; $meisai .= __('Shipping','usces') . " : " . usces_crform( $data['order_shipping_charge'], true, false, 'return' ) . "\r\n"; if ( $payment['settlement'] == 'COD' ) $meisai .= apply_filters('usces_filter_cod_label', __('COD fee', 'usces')) . " : " . usces_crform( $data['order_cod_fee'], true, false, 'return' ) . "\r\n"; if ( !empty($usces->options['tax_rate']) ) $meisai .= __('consumption tax','usces') . " : " . usces_crform( $data['order_tax'], true, false, 'return' ) . "\r\n"; $meisai .= usces_mail_line( 2, $data['order_email'] );//-------------------- $meisai .= __('Payment amount','usces') . " : " . usces_crform( $total_full_price, true, false, 'return' ) . "\r\n"; $meisai .= usces_mail_line( 2, $data['order_email'] );//-------------------- $meisai .= "(" . __('Currency', 'usces') . ' : ' . __(usces_crcode( 'return' ), 'usces') . ")\r\n\r\n"; $msg_body .= apply_filters('usces_filter_order_confirm_mail_meisai', $meisai, $data, $cart); $msg_shipping = __('** A shipping address **','usces') . "\r\n"; $msg_shipping .= usces_mail_line( 1, $data['order_email'] );//******************** $msg_shipping .= uesces_get_mail_addressform( 'admin_mail', $deli, $order_id ); //20101208ysk start //$msg_shipping .= __('Delivery Time','usces') . " : " . $data['order_delivery_time'] . "\r\n"; if ( $data['order_delidue_date'] == NULL || $data['order_delidue_date'] == '#none#' ) { $msg_shipping .= "\r\n"; }else{ $msg_shipping .= __('Shipping date', 'usces') . " : " . $data['order_delidue_date'] . "\r\n"; $msg_shipping .= __("* A shipment due date is a day to ship an article, and it's not the arrival day.", 'usces') . "\r\n"; $msg_shipping .= "\r\n"; } $deli_meth = (int)$data['order_delivery_method']; if( 0 <= $deli_meth ){ $deli_index = $usces->get_delivery_method_index($deli_meth); if( 0 <= $deli_index ) $msg_shipping .= __('Delivery Method','usces') . " : " . $usces->options['delivery_method'][$deli_index]['name'] . "\r\n"; } $msg_shipping .= __('Delivery date','usces') . " : " . $data['order_delivery_date'] . "\r\n"; $msg_shipping .= __('Delivery Time','usces') . " : " . $data['order_delivery_time'] . "\r\n"; //20101208ysk end $msg_shipping .= "\r\n"; $msg_body .= apply_filters('usces_filter_order_confirm_mail_shipping', $msg_shipping, $data); // $msg_body .= __('** For some region, to deliver the items in the morning is not possible.','usces') . "\r\n"; // $msg_body .= __('** WE may not always be able to deliver the items on time which you desire.','usces') . " \r\n"; // $msg_body .= usces_mail_line( 2, $data['order_email'] )."\r\n"; $msg_payment = __('** Payment method **','usces') . "\r\n"; $msg_payment .= usces_mail_line( 1, $data['order_email'] );//******************** $msg_payment .= $payment['name']. "\r\n\r\n"; if( 'orderConfirmMail' == $_POST['mode'] || 'changeConfirmMail' == $_POST['mode'] || 'mitumoriConfirmMail' == $_POST['mode'] || 'otherConfirmMail' == $_POST['mode'] ) {//20130514ysk start 0000524 if ( $payment['settlement'] == 'transferAdvance' || $payment['settlement'] == 'transferDeferred' ) { $transferee = __('Transfer','usces') . " : \r\n"; $transferee .= $usces->options['transferee'] . "\r\n"; $msg_payment .= apply_filters('usces_filter_mail_transferee', $transferee, $payment); $msg_payment .= "\r\n".usces_mail_line( 2, $data['order_email'] )."\r\n";//-------------------- //20101018ysk start } elseif($payment['settlement'] == 'acting_jpayment_conv') { $args = maybe_unserialize($usces->get_order_meta_value($payment['settlement'], $order_id)); $msg_payment .= __('決済番号', 'usces').' : '.$args['gid']."\r\n"; $msg_payment .= __('決済金額', 'usces').' : '.number_format($args['ta']).__('dollars','usces')."\r\n"; $msg_payment .= __('お支払先', 'usces').' : '.usces_get_conv_name($args['cv'])."\r\n"; $msg_payment .= __('コンビニ受付番号','usces').' : '.$args['no']."\r\n"; if($args['cv'] != '030') {//ファミリーマート以外 $msg_payment .= __('コンビニ受付番号情報URL', 'usces').' : '.$args['cu']."\r\n"; } $msg_payment .= "\r\n".usces_mail_line( 2, $data['order_email'] )."\r\n";//-------------------- } elseif($payment['settlement'] == 'acting_jpayment_bank') { $args = maybe_unserialize($usces->get_order_meta_value($payment['settlement'], $order_id)); $msg_payment .= __('決済番号', 'usces').' : '.$args['gid']."\r\n"; $msg_payment .= __('決済金額', 'usces').' : '.number_format($args['ta']).__('dollars','usces')."\r\n"; $bank = explode('.', $args['bank']); $msg_payment .= __('銀行コード','usces').' : '.$bank[0]."\r\n"; $msg_payment .= __('銀行名','usces').' : '.$bank[1]."\r\n"; $msg_payment .= __('支店コード','usces').' : '.$bank[2]."\r\n"; $msg_payment .= __('支店名','usces').' : '.$bank[3]."\r\n"; $msg_payment .= __('口座種別','usces').' : '.$bank[4]."\r\n"; $msg_payment .= __('口座番号','usces').' : '.$bank[5]."\r\n"; $msg_payment .= __('口座名義','usces').' : '.$bank[6]."\r\n"; $msg_payment .= __('支払期限','usces').' : '.substr($args['exp'], 0, 4).'年'.substr($args['exp'], 4, 2).'月'.substr($args['exp'], 6, 2)."日\r\n"; $msg_payment .= "\r\n".usces_mail_line( 2, $data['order_email'] )."\r\n";//-------------------- //20101018ysk end } }//20130514ysk end $msg_body .= apply_filters('usces_filter_order_confirm_mail_payment', $msg_payment, $order_id, $payment, $cart, $data); //20100818ysk start $msg_body .= usces_mail_custom_field_info( 'order', '', $order_id, $data['order_email'] ); //20100818ysk end $msg_body .= "\r\n"; $msg_body .= __('** Others / a demand **','usces') . "\r\n"; $msg_body .= usces_mail_line( 1, $data['order_email'] );//******************** $msg_body .= $data['order_note'] . "\r\n\r\n"; // $msg_body .= usces_mail_line( 2, $data['order_email'] )."\r\n";//-------------------- // $msg_body .= "\r\n"; // $msg_body .= __('Please inform it of any questions from [an inquiry].','usces') . "\r\n"; // $msg_body .= usces_mail_line( 2, $data['order_email'] )."\r\n";//-------------------- $msg_body .= apply_filters('usces_filter_order_confirm_mail_body', NULL, $data); $msg_body = apply_filters('usces_filter_order_confirm_mail_bodyall', $msg_body, $data); switch ( $_POST['mode'] ) { case 'completionMail': $message = do_shortcode($mail_data['header']['completionmail']) . apply_filters('usces_filter_order_confirm_mail_body_after', $msg_body, $data) . do_shortcode($mail_data['footer']['completionmail']); break; case 'orderConfirmMail': $message = do_shortcode($mail_data['header']['ordermail']) . apply_filters('usces_filter_order_confirm_mail_body_after', $msg_body, $data) . do_shortcode($mail_data['footer']['ordermail']); break; case 'changeConfirmMail': $message = do_shortcode($mail_data['header']['changemail']) . apply_filters('usces_filter_order_confirm_mail_body_after', $msg_body, $data) . do_shortcode($mail_data['footer']['changemail']); break; case 'receiptConfirmMail': $message = do_shortcode($mail_data['header']['receiptmail']) . apply_filters('usces_filter_order_confirm_mail_body_after', $msg_body, $data) . do_shortcode($mail_data['footer']['receiptmail']); break; case 'mitumoriConfirmMail': $message = do_shortcode($mail_data['header']['mitumorimail']) . apply_filters('usces_filter_order_confirm_mail_body_after', $msg_body, $data) . do_shortcode($mail_data['footer']['mitumorimail']); break; case 'cancelConfirmMail': $message = do_shortcode($mail_data['header']['cancelmail']) . apply_filters('usces_filter_order_confirm_mail_body_after', $msg_body, $data) . do_shortcode($mail_data['footer']['cancelmail']); break; case 'otherConfirmMail': $message = do_shortcode($mail_data['header']['othermail']) . apply_filters('usces_filter_order_confirm_mail_body_after', $msg_body, $data) . do_shortcode($mail_data['footer']['othermail']); break; } return apply_filters('usces_filter_order_confirm_mail_message', $message, $data); } function usces_send_ordermail($order_id) { global $usces, $wpdb; $tableName = $wpdb->prefix . "usces_order"; $query = $wpdb->prepare("SELECT * FROM $tableName WHERE ID = %d", $order_id); $data = $wpdb->get_row( $query, ARRAY_A ); $cart = $usces->cart->get_cart(); $entry = $usces->cart->get_entry(); $mail_data = $usces->options['mail_data']; $payment = $usces->getPayments( $entry['order']['payment_name'] ); $res = false; $msg_body = "\r\n\r\n\r\n" . __('** content of ordered items **','usces') . "\r\n"; $msg_body .= usces_mail_line( 1, $entry['customer']['mailaddress1'] );//******************** $msg_body .= apply_filters('usces_filter_send_order_mail_first', NULL, $data); //20110118ysk start //$msg_body .= usces_mail_custom_field_info( 'customer', 'name_pre', $order_id ); //20110118ysk end //$msg_body .= __('Buyer','usces') . " : " . sprintf(__('Mr/Mrs %s', 'usces'), usces_localized_name( $entry['customer']['name1'], $entry['customer']['name2'], 'return' )) . "\r\n"; $msg_body .= uesces_get_mail_addressform( 'order_mail_customer', $entry, $order_id ); //20110118ysk start //$msg_body .= usces_mail_custom_field_info( 'customer', 'name_after', $order_id ); //20110118ysk end $msg_body .= __('Order number','usces') . " : " . usces_get_deco_order_id( $order_id ) . "\r\n"; $meisai = __('Items','usces') . " : \r\n"; foreach ( $cart as $cart_row ) { $post_id = $cart_row['post_id']; $sku = urldecode($cart_row['sku']); $quantity = $cart_row['quantity']; $options = $cart_row['options']; $itemCode = $usces->getItemCode($post_id); $itemName = $usces->getItemName($post_id); $cartItemName = $usces->getCartItemName($post_id, $sku); $skuPrice = $cart_row['price']; // $pictids = $usces->get_pictids($itemCode); if (!empty($options)) { // $optstr = implode(',', $options); } else { $optstr = ''; $options = array(); } $meisai .= usces_mail_line( 2, $entry['customer']['mailaddress1'] );//-------------------- $meisai .= "$cartItemName \r\n"; if( is_array($options) && count($options) > 0 ){ $optstr = ''; foreach($options as $key => $value){ //20110629ysk start 0000190 //if( !empty($key) ) // $meisai .= $key . ' : ' . urldecode($value) . "\r\n"; if( !empty($key) ) { $key = urldecode($key); if(is_array($value)) { $c = ''; $optstr .= $key. ' : '; foreach($value as $v) { $optstr .= $c.urldecode($v); $c = ', '; } $optstr .= "\r\n"; } else { $optstr .= $key . ' : ' . urldecode($value) . "\r\n"; } } //20110629ysk end } $meisai .= apply_filters( 'usces_filter_option_ordermail', $optstr, $options); } $meisai .= __('Unit price','usces') . " ".usces_crform( $skuPrice, true, false, 'return' ) . __(' * ','usces') . $cart_row['quantity'] . "\r\n"; } $meisai .= usces_mail_line( 3, $entry['customer']['mailaddress1'] );//==================== $meisai .= __('total items','usces') . " : " . usces_crform( $entry['order']['total_items_price'], true, false, 'return' ) . "\r\n"; if ( $entry['order']['usedpoint'] != 0 ) $meisai .= __('use of points','usces') . " : " . number_format($entry['order']['usedpoint']) . __('Points','usces') . "\r\n"; //20120308ysk start 0000433 //if ( $data['order_discount'] != 0 ) if ( $entry['order']['discount'] != 0 ) //20120308ysk end $meisai .= apply_filters('usces_confirm_discount_label', __('Campaign disnount', 'usces'), $order_id) . " : " . usces_crform( $entry['order']['discount'], true, false, 'return' ) . "\r\n"; $meisai .= __('Shipping','usces') . " : " . usces_crform( $entry['order']['shipping_charge'], true, false, 'return' ) . "\r\n"; if ( $payment['settlement'] == 'COD' ) $meisai .= apply_filters('usces_filter_cod_label', __('COD fee', 'usces')) . " : " . usces_crform( $entry['order']['cod_fee'], true, false, 'return' ) . "\r\n"; if ( !empty($usces->options['tax_rate']) ) $meisai .= __('consumption tax','usces') . " : " . usces_crform( $entry['order']['tax'], true, false, 'return' ) . "\r\n"; $meisai .= usces_mail_line( 2, $entry['customer']['mailaddress1'] );//-------------------- $meisai .= __('Payment amount','usces') . " : " . usces_crform( $entry['order']['total_full_price'], true, false, 'return' ) . "\r\n"; $meisai .= usces_mail_line( 2, $entry['customer']['mailaddress1'] );//-------------------- $meisai .= "(" . __('Currency', 'usces') . ' : ' . __(usces_crcode( 'return' ), 'usces') . ")\r\n\r\n"; //20120308ysk start 0000433 //$msg_body .= apply_filters('usces_filter_send_order_mail_meisai', $meisai, $data); $msg_body .= apply_filters('usces_filter_send_order_mail_meisai', $meisai, $data, $cart, $entry); //20120308ysk end $msg_shipping = __('** A shipping address **','usces') . "\r\n"; $msg_shipping .= usces_mail_line( 1, $entry['customer']['mailaddress1'] );//******************** $msg_shipping .= uesces_get_mail_addressform( 'order_mail', $entry, $order_id ); //20101208ysk start //$msg_shipping .= __('Delivery Time','usces') . " : " . $entry['order']['delivery_time'] . "\r\n"; $deli_meth = (int)$entry['order']['delivery_method']; if( 0 <= $deli_meth ){ $deli_index = $usces->get_delivery_method_index($deli_meth); if( 0 <= $deli_index ) $msg_shipping .= __('Delivery Method','usces') . " : " . $usces->options['delivery_method'][$deli_index]['name'] . "\r\n"; } $msg_shipping .= __('Delivery date','usces') . " : " . $entry['order']['delivery_date'] . "\r\n"; $msg_shipping .= __('Delivery Time','usces') . " : " . $entry['order']['delivery_time'] . "\r\n"; //20101208ysk end // $msg_body .= usces_mail_line( 2, $entry['customer']['mailaddress1'] );//-------------------- // $msg_body .= __('** For some region, to deliver the items in the morning is not possible.','usces') . "\r\n"; // $msg_body .= " " . __('** WE may not always be able to deliver the items on time which you desire.','usces') . "\r\n"; // $msg_body .= usces_mail_line( 2, $entry['customer']['mailaddress1'] )."\r\n";//-------------------- $msg_shipping .= "\r\n"; $msg_body .= apply_filters('usces_filter_send_order_mail_shipping', $msg_shipping, $data); $msg_payment = __('** Payment method **','usces') . "\r\n"; $msg_payment .= usces_mail_line( 1, $entry['customer']['mailaddress1'] );//******************** $msg_payment .= $payment['name'] . usces_payment_detail($entry) . "\r\n\r\n"; if ( $payment['settlement'] == 'transferAdvance' || $payment['settlement'] == 'transferDeferred' ) { $transferee = __('Transfer','usces') . " : \r\n"; $transferee .= $usces->options['transferee'] . "\r\n"; $msg_payment .= apply_filters('usces_filter_mail_transferee', $transferee, $payment); $msg_payment .= "\r\n".usces_mail_line( 2, $entry['customer']['mailaddress1'] )."\r\n";//-------------------- //20101018ysk start } elseif($payment['settlement'] == 'acting_jpayment_conv') { $args = maybe_unserialize($usces->get_order_meta_value($payment['settlement'], $order_id)); $msg_payment .= __('決済番号', 'usces').' : '.$args['gid']."\r\n"; $msg_payment .= __('決済金額', 'usces').' : '.number_format($args['ta']).__('dollars','usces')."\r\n"; $msg_payment .= __('お支払先', 'usces').' : '.usces_get_conv_name($args['cv'])."\r\n"; $msg_payment .= __('コンビニ受付番号','usces').' : '.$args['no']."\r\n"; if($args['cv'] != '030') {//ファミリーマート以外 $msg_payment .= __('コンビニ受付番号情報URL', 'usces').' : '.$args['cu']."\r\n"; } $msg_payment .= "\r\n".usces_mail_line( 2, $entry['customer']['mailaddress1'] )."\r\n";//-------------------- } elseif($payment['settlement'] == 'acting_jpayment_bank') { $args = maybe_unserialize($usces->get_order_meta_value($payment['settlement'], $order_id)); $msg_payment .= __('決済番号', 'usces').' : '.$args['gid']."\r\n"; $msg_payment .= __('決済金額', 'usces').' : '.number_format($args['ta']).__('dollars','usces')."\r\n"; $bank = explode('.', $args['bank']); $msg_payment .= __('銀行コード','usces').' : '.$bank[0]."\r\n"; $msg_payment .= __('銀行名','usces').' : '.$bank[1]."\r\n"; $msg_payment .= __('支店コード','usces').' : '.$bank[2]."\r\n"; $msg_payment .= __('支店名','usces').' : '.$bank[3]."\r\n"; $msg_payment .= __('口座種別','usces').' : '.$bank[4]."\r\n"; $msg_payment .= __('口座番号','usces').' : '.$bank[5]."\r\n"; $msg_payment .= __('口座名義','usces').' : '.$bank[6]."\r\n"; $msg_payment .= __('支払期限','usces').' : '.substr($args['exp'], 0, 4).'年'.substr($args['exp'], 4, 2).'月'.substr($args['exp'], 6, 2)."日\r\n"; $msg_payment .= "\r\n".usces_mail_line( 2, $entry['customer']['mailaddress1'] )."\r\n";//-------------------- //20101018ysk end } $msg_body .= apply_filters('usces_filter_send_order_mail_payment', $msg_payment, $order_id, $payment, $cart, $entry, $data); //20100818ysk start $msg_body .= usces_mail_custom_field_info( 'order', '', $order_id ); //20100818ysk end $msg_body .= "\r\n"; $msg_body .= __('** Others / a demand **','usces') . "\r\n"; $msg_body .= usces_mail_line( 1, $entry['customer']['mailaddress1'] );//******************** $msg_body .= $entry['order']['note'] . "\r\n\r\n"; // $msg_body .= usces_mail_line( 2, $entry['customer']['mailaddress1'] )."\r\n";//-------------------- // $msg_body .= "\r\n"; // $msg_body .= __('I will inform it of shipment completion by an email.','usces') . "\r\n"; // $msg_body .= __('Please inform it of any questions from [an inquiry].','usces') . "\r\n"; // $msg_body .= usces_mail_line( 2, $entry['customer']['mailaddress1'] )."\r\n";//-------------------- $msg_body .= apply_filters('usces_filter_send_order_mail_body', NULL, $data); $msg_body = apply_filters('usces_filter_send_order_mail_bodyall', $msg_body, $data); $subject = apply_filters('usces_filter_send_order_mail_subject_thankyou', $mail_data['title']['thankyou'], $data); $message = do_shortcode($mail_data['header']['thankyou']) . $msg_body . do_shortcode($mail_data['footer']['thankyou']); //var_dump($msg_body);exit; $confirm_para = array( 'to_name' => sprintf(__('Mr/Mrs %s', 'usces'), ($entry["customer"]["name1"] . ' ' . $entry["customer"]["name2"])), 'to_address' => $entry['customer']['mailaddress1'], 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => $subject, 'message' => $message ); $confirm_para = apply_filters( 'usces_send_ordermail_para_to_customer', $confirm_para, $entry, $data); //if ( usces_send_mail( $confirm_para ) ) { usces_send_mail( $confirm_para ); $subject = apply_filters('usces_filter_send_order_mail_subject_order', $mail_data['title']['order'], $data); $message = do_shortcode($mail_data['header']['order']) . $msg_body . $mail_data['footer']['order'] . "\n----------------------------------------------------\n" . "REMOTE_ADDR : " . $_SERVER['REMOTE_ADDR'] . "\n----------------------------------------------------\n"; $order_para = array( 'to_name' => __('An order email','usces'), 'to_address' => $usces->options['order_mail'], 'from_name' => sprintf(__('Mr/Mrs %s', 'usces'), ($entry["customer"]["name1"] . ' ' . $entry["customer"]["name2"])), 'from_address' => $entry['customer']['mailaddress1'], 'return_path' => $usces->options['error_mail'], 'subject' => $subject, 'message' => $message ); $order_para = apply_filters( 'usces_send_ordermail_para_to_manager', $order_para, $entry, $data); $res = usces_send_mail( $order_para ); // } return $res; } function usces_send_inquirymail() { global $usces; $_POST = $usces->stripslashes_deep_post($_POST); $res = false; $mail_data = $usces->options['mail_data']; $inq_name = trim($_POST["inq_name"]); $inq_contents = trim($_POST["inq_contents"]); $inq_mailaddress = trim($_POST["inq_mailaddress"]); $reserve = ''; if(isset($_POST['reserve'])){ foreach($_POST['reserve'] as $key => $value){ $reserve .= $key . " : " . $value . "\r\n"; } } $mats = compact('inq_name','inq_contents','inq_mailaddress','reserve','mail_data'); $subject = apply_filters( 'usces_filter_inquiry_subject_to_customer', $mail_data['title']['inquiry'],$mats); $message = apply_filters( 'usces_filter_inquiry_header', $mail_data['header']['inquiry'], $inq_name, $inq_mailaddress ) . "\r\n\r\n"; $message .= apply_filters( 'usces_filter_inquiry_reserve', $reserve, $inq_name, $inq_mailaddress ); $message .= apply_filters( 'usces_filter_inq_contents', $inq_contents, $inq_name, $inq_mailaddress ) . "\r\n\r\n"; $message .= apply_filters( 'usces_filter_inq_footer', $mail_data['footer']['inquiry'], $inq_name, $inq_mailaddress ); do_action( 'usces_action_presend_inquiry_mail', $message, $inq_name, $inq_mailaddress ); $para1 = array( 'to_name' => sprintf(__('Mr/Mrs %s', 'usces'), $inq_name), 'to_address' => $inq_mailaddress, 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => $subject, 'message' => do_shortcode($message), ); $res0 = usces_send_mail( $para1 ); if ( $res0 ) { $subject = apply_filters( 'usces_filter_inquiry_subject_to_manager', __('** An inquiry **','usces').'('.$inq_name.')',$mats); $message = $reserve . $_POST['inq_contents'] . "\r\n" . "\n----------------------------------------------------\n" . "REMOTE_ADDR : " . $_SERVER['REMOTE_ADDR'] . "\n----------------------------------------------------\n"; $para2 = array( 'to_name' => __('An inquiry email','usces'), 'to_address' => $usces->options['inquiry_mail'], 'from_name' => sprintf(__('Mr/Mrs %s', 'usces'), $inq_name), 'from_address' => $inq_mailaddress, 'return_path' => $usces->options['error_mail'], 'subject' => $subject, 'message' => do_shortcode($message), ); sleep(1); $res = usces_send_mail( $para2 ); } return $res; } function usces_send_regmembermail($user) { global $usces; $res = false; $mail_data = $usces->options['mail_data']; $newmem_admin_mail = $usces->options['newmem_admin_mail']; $name = usces_localized_name(trim($user['name1']), trim($user['name2']), 'return'); $mailaddress1 = trim($user['mailaddress1']); $subject = $mail_data['title']['membercomp']; $message = $mail_data['header']['membercomp']; $message .= __('Registration contents', 'usces')."\r\n"; $message .= '--------------------------------'."\r\n"; $message .= __('Member ID', 'usces') . ' : ' . $user['ID'] . "\r\n"; $message .= __('Name', 'usces') . ' : ' . sprintf(__('Mr/Mrs %s', 'usces'), $name) . "\r\n"; $message .= __('e-mail adress', 'usces') . ' : ' . $mailaddress1."\r\n"; $message .= '--------------------------------'."\r\n\r\n"; $message .= $mail_data['footer']['membercomp']; $message = apply_filters('usces_filter_send_regmembermail_message', $message, $user); $para1 = array( 'to_name' => sprintf(__('Mr/Mrs %s', 'usces'), $name), 'to_address' => $mailaddress1, 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => $subject, 'message' => do_shortcode($message), ); $para1 = apply_filters( 'usces_filter_send_regmembermail_para1', $para1 ); $res = usces_send_mail( $para1 ); if($newmem_admin_mail){ $subject = __('New sign-in processing was completed.', 'usces'); $message = __('New sign-in processing was completed.', 'usces') . "\r\n\r\n"; $message .= __('Registration contents', 'usces')."\r\n"; $message .= '--------------------------------'."\r\n"; $message .= __('Member ID', 'usces') . ' : ' . $user['ID'] . "\r\n"; $message .= __('Name', 'usces') . ' : ' . sprintf(__('Mr/Mrs %s', 'usces'), $name) . "\r\n"; $message .= __('e-mail adress', 'usces') . ' : ' . $mailaddress1."\r\n"; $message .= '--------------------------------'."\r\n\r\n"; $message = apply_filters('usces_filter_send_regmembermail_notice', $message, $user); $para2 = array( 'to_name' => __('Notice of new sign-in', 'usces'), 'to_address' => $usces->options['order_mail'], 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => $subject, 'message' => do_shortcode($message), ); $para2 = apply_filters( 'usces_filter_send_regmembermail_para2', $para2 ); usces_send_mail( $para2 ); } return $res; } function usces_send_delmembermail( $user ) { global $usces; $res = true; $mail_data = $usces->options['mail_data']; $delmem_admin_mail = $usces->options['delmem_admin_mail']; $delmem_customer_mail = $usces->options['delmem_customer_mail']; $name = usces_localized_name(trim($user['name1']), trim($user['name2']), 'return'); $mailaddress1 = trim($user['mailaddress1']); $subject = apply_filters( 'usces_filter_send_delmembermail_subject', __('Member removal processing was completed.', 'usces'), $user ); if( $delmem_customer_mail ) { $message = $subject."\r\n\r\n"; $message .= __('Registration contents', 'usces')."\r\n"; $message .= '--------------------------------'."\r\n"; $message .= __('Member ID', 'usces').' : '.$user['ID']."\r\n"; $message .= __('Name', 'usces').' : '.sprintf(__('Mr/Mrs %s', 'usces'), $name)."\r\n"; $message .= __('e-mail adress', 'usces').' : '.$mailaddress1."\r\n"; $message .= '--------------------------------'."\r\n\r\n"; $message .= $mail_data['footer']['membercomp']; $message = apply_filters( 'usces_filter_send_delmembermail_message', $message, $user ); $para1 = array( 'to_name' => sprintf(__('Mr/Mrs %s', 'usces'), $name), 'to_address' => $mailaddress1, 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => $subject, 'message' => do_shortcode($message), ); $para1 = apply_filters( 'usces_filter_send_delmembermail_para1', $para1 ); $res = usces_send_mail( $para1 ); } if( $delmem_admin_mail ) { $message = $subject."\r\n\r\n"; $message .= __('Registration contents', 'usces')."\r\n"; $message .= '--------------------------------'."\r\n"; $message .= __('Member ID', 'usces').' : '.$user['ID']."\r\n"; $message .= __('Name', 'usces').' : '.sprintf(__('Mr/Mrs %s', 'usces'), $name)."\r\n"; $message .= __('e-mail adress', 'usces') . ' : '.$mailaddress1."\r\n"; $message .= '--------------------------------'."\r\n\r\n"; $message = apply_filters( 'usces_filter_send_delmembermail_notice', $message, $user ); $para2 = array( 'to_name' => __('Notice of new sign-in', 'usces'), 'to_address' => $usces->options['order_mail'], 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => $subject, 'message' => do_shortcode($message), ); $para2 = apply_filters( 'usces_filter_send_delmembermail_para2', $para2 ); $res = usces_send_mail( $para2 ); } return $res; } function usces_lostmail($url) { global $usces; $res = false; $mail_data = $usces->options['mail_data']; $subject = apply_filters( 'usces_filter_lostmail_subject', __('Change password','usces') ); $message = __('Please, click the following URL, and please change a password.','usces') . "\n\r\n\r\n\r" . $url . "\n\r\n\r\n\r" . "-----------------------------------------------------\n\r" . __('If you have not requested this email please kindly ignore and delete it.','usces') . "\n\r" . "-----------------------------------------------------\n\r\n\r\n\r"; $message = apply_filters( 'usces_filter_lostmail_message', $message, $url ); $message .= apply_filters( 'usces_filter_lostmail_footer', $mail_data['footer']['othermail'] ); $para1 = array( 'to_name' => sprintf(__('Mr/Mrs %s', 'usces'), $_SESSION["usces_lostmail"]), 'to_address' => $_SESSION["usces_lostmail"], 'from_name' => get_option('blogname'), 'from_address' => $usces->options['sender_mail'], 'return_path' => $usces->options['sender_mail'], 'subject' => $subject, 'message' => do_shortcode($message), ); $para1 = apply_filters( 'usces_filter_send_lostmail_para1', $para1 ); $res = usces_send_mail( $para1 ); if($res === false) { $usces->error_message = __('Error: I was not able to transmit an email.','usces'); $page = 'lostmemberpassword'; } else { $page = 'lostcompletion'; } return $page; } //20100818ysk start //function usces_mail_custom_field_info( $custom_field, $position, $id ) { function usces_mail_custom_field_info( $custom_field, $position, $id, $mailaddress = '' ) { global $usces; $msg_body = ''; switch($custom_field) { case 'order': $field = 'usces_custom_order_field'; $cs = 'csod_'; break; case 'customer': $field = 'usces_custom_customer_field'; $cs = 'cscs_'; break; case 'delivery': $field = 'usces_custom_delivery_field'; $cs = 'csde_'; break; case 'member': $field = 'usces_custom_member_field'; $cs = 'csmb_'; break; default: return $msg_body; } $meta = usces_has_custom_field_meta($custom_field); if(!empty($meta) and is_array($meta)) { $keys = array_keys($meta); switch($custom_field) { case 'order': $msg_body .= "\r\n"; $msg_body .= usces_mail_line( 1, $mailaddress ); foreach($keys as $key) { $value = maybe_unserialize($usces->get_order_meta_value($cs.$key, $id)); if(is_array($value)) { $concatval = ''; $c = ''; foreach($value as $v) { $concatval .= $c.$v; $c = ', '; } $value = $concatval; } $msg_body .= $meta[$key]['name']." : ".$value."\r\n"; } $msg_body .= usces_mail_line( 1, $mailaddress ); break; case 'customer': case 'delivery': foreach($keys as $key) { if($meta[$key]['position'] == $position) { $value = maybe_unserialize($usces->get_order_meta_value($cs.$key, $id)); if(is_array($value)) { $concatval = ''; $c = ''; foreach($value as $v) { $concatval .= $c.$v; $c = ', '; } $value = $concatval; } $msg_body .= $meta[$key]['name']." : ".$value."\r\n"; } } break; case 'member': foreach($keys as $key) { if($meta[$key]['position'] == $position) { $value = maybe_unserialize($usces->get_member_meta_value($cs.$key, $id)); if(is_array($value)) { $concatval = ''; $c = ''; foreach($value as $v) { $concatval .= $c.$v; $c = ', '; } $value = $concatval; } $msg_body .= $meta[$key]['name']." : ".$value."\r\n"; } } break; } } $msg_body = apply_filters('usces_filter_mail_custom_field_info', $msg_body, $custom_field, $position, $id, $mailaddress); return $msg_body; } //20100818ysk end //function usces_send_receipted_mail( $order_id, $acting ) { // global $usces; // $res = false; // // $subject = __('Change password','usces'); // $message = __('Please, click the following URL, and please change a password.','usces') . "\n\r\n\r\n\r" // . $url . "\n\r\n\r\n\r" // . "-----------------------------------------------------\n\r" // . __('I seem to have you cancel it when the body does not have memorizing to this email.','usces') . "\n\r" // . "-----------------------------------------------------\n\r\n\r\n\r" // . $usces->options['mail_data']['footer']['footerlogo']; // // $para1 = array( // 'to_name' => sprintf(__('Mr/Mrs %s', 'usces'), $_SESSION["usces_lostmail"]), // 'to_address' => $_SESSION["usces_lostmail"], // 'from_name' => get_bloginfo('name'), // 'from_address' => $usces->options['sender_mail'], // 'return_path' => $usces->options['error_mail'], // 'subject' => $subject, // 'message' => $message // ); // // $res = usces_send_mail( $para1 ); // // if($res === false) { // $usces->error_message = __('Error: I was not able to transmit an email.','usces'); // $page = 'lostmemberpassword'; // } else { // $page = 'lostcompletion'; // } // // return $page; // //} function usces_send_mail( $para ) { global $usces; $from_name = $para['from_name']; $from_address = $para['from_address']; if (strpos($para['from_address'], '..') !== false || strpos($para['from_address'], '.@') !== false) { $fname = str_replace(strstr($para['from_address'], '@'), '', $para['from_address']); if( '"' != substr($fname, 0, 1) && '"' != substr($fname, -1) ){ $para['from_address'] = str_replace($fname, '"RFC_violation"', $para['from_address']); $from_name = $para['from_name'] . '(' . $from_address . ')'; } } $from = htmlspecialchars(html_entity_decode($from_name, ENT_QUOTES)) . " <{$para['from_address']}>"; $header = "From: " . apply_filters('usces_filter_send_mail_from', $from, $para) . "\r\n"; $header .= "Return-Path: {$para['return_path']}\r\n"; $subject = html_entity_decode($para['subject'], ENT_QUOTES); $message = $para['message']; ini_set( "SMTP", "{$usces->options['smtp_hostname']}" ); if( !ini_get( "smtp_port" ) ){ ini_set( "smtp_port", apply_filters('usces_filter_send_mail_port', 25, $para) ); } ini_set( "sendmail_from", "" ); $mails = explode( ',', $para['to_address'] ); $to_mailes = array(); foreach( $mails as $mail ){ if (strpos($mail, '..') !== false || strpos($mail, '.@') !== false) { $name = str_replace(strstr($mail, '@'), '', $mail); if( '"' != substr($name, 0, 1) && '"' != substr($name, -1) ){ $to_mailes[] = str_replace($name, '"'.$name.'"', $mail); }else{ $to_mailes[] = $mail; } }elseif( is_email( trim($mail) ) ){ $to_mailes[] = $mail; }else{ $to_mailes[] = NULL; } } if( !empty( $to_mailes ) ){ $res = @wp_mail( $to_mailes , $subject , $message, $header ); }else{ $res = false; } return $res; } function usces_send_mail2( $para ) { global $usces; $usces->mail_para = $para; add_action('phpmailer_init','usces_send_mail_init', 11); // $from = htmlspecialchars(html_entity_decode($para['from_name'], ENT_QUOTES)) . " <{$para['from_address']}>"; // $header = "From: " . apply_filters('usces_filter_send_mail_from', $from, $para) . "\r\n"; // $header .= "Return-Path: {$para['return_path']}\r\n"; $subject = html_entity_decode($para['subject'], ENT_QUOTES); $message = $para['message']; // ini_set( "SMTP", "{$usces->options['smtp_hostname']}" ); // if( !ini_get( "smtp_port" ) ){ // ini_set( "smtp_port", apply_filters('usces_filter_send_mail_port', 25, $para) ); // } // ini_set( "sendmail_from", "" ); $mails = explode( ',', $para['to_address'] ); $to_mailes = array(); foreach( $mails as $mail ){ if( is_email( trim($mail) ) ){ $to_mailes[] = $mail; } } if( !empty( $to_mailes ) ){ $res = @wp_mail( $to_mailes , $subject , $message ); }else{ $res = false; } //usces_log('mail : '.print_r($res, true), 'acting_transaction.log'); remove_action('phpmailer_init','usces_send_mail_init', 11); $usces->mail_para = array(); return $res; } function usces_send_mail_init($phpmailer){ global $usces; $phpmailer->Mailer = 'mail'; $phpmailer->From = $usces->mail_para['from_address']; $phpmailer->FromName = apply_filters('usces_filter_send_mail_from', $usces->mail_para['from_name'], $usces->mail_para); $phpmailer->Sender = $usces->mail_para['from_address']; // $phpmailer->Mailer = 'smtp'; // $phpmailer->SMTPSecure = ''; // $phpmailer->Host = 'sample.com'; // $phpmailer->Port = 25; // $phpmailer->SMTPAuth = true; // $phpmailer->Username = 'sample@sample.com'; // $phpmailer->Password = 'password'; do_action('usces_filter_phpmailer_init', array( &$phpmailer )); } function usces_reg_orderdata( $results = array() ) { global $wpdb, $usces; // $wpdb->show_errors(); $options = get_option('usces'); $cart = $usces->cart->get_cart(); $entry = $usces->cart->get_entry(); if( empty($cart) ){ usces_log('reg_orderdata : Session is empty.', 'database_error.log'); return 0; } $charging_type = $usces->getItemChargingType($cart[0]['post_id']); $item_total_price = $usces->get_total_price( $cart ); $member = $usces->get_member(); $order_table_name = $wpdb->prefix . "usces_order"; $order_table_meta_name = $wpdb->prefix . "usces_order_meta"; $member_table_name = $wpdb->prefix . "usces_member"; $set = $usces->getPayments( $entry['order']['payment_name'] ); $status = ''; if( 'continue' == $charging_type ){ $order_modified = substr(get_date_from_gmt(gmdate('Y-m-d H:i:s', time())), 0, 10); }else{ $status = ( $set['settlement'] == 'transferAdvance' || $set['settlement'] == 'transferDeferred' || $set['settlement'] == 'acting_remise_conv' || $set['settlement'] == 'acting_zeus_bank' || $set['settlement'] == 'acting_zeus_conv' || $set['settlement'] == 'acting_jpayment_conv' || $set['settlement'] == 'acting_jpayment_bank' || $set['settlement'] == 'acting_sbps_conv' || $set['settlement'] == 'acting_sbps_payeasy' || $set['settlement'] == 'acting_digitalcheck_conv' || $set['settlement'] == 'acting_mizuho_conv1' || $set['settlement'] == 'acting_mizuho_conv2' ) ? 'noreceipt' : ''; $order_modified = NULL; } $payments = $usces->getPayments($entry['order']['payment_name']); if( isset($results['payment_status']) && $results['payment_status'] != 'Completed' && $payments['module'] == 'paypal.php') $status = 'pending'; if( (empty($entry['customer']['name1']) && empty($entry['customer']['name2'])) || empty($entry['customer']['mailaddress1']) || empty($entry) || empty($cart) ) return '1'; $status = apply_filters('usces_filter_reg_orderdata_status', $status); $delidue_date = ( isset($entry['order']['delidue_date']) ) ? $entry['order']['delidue_date'] : NULL; //20101208ysk start $query = $wpdb->prepare( "INSERT INTO $order_table_name ( `mem_id`, `order_email`, `order_name1`, `order_name2`, `order_name3`, `order_name4`, `order_zip`, `order_pref`, `order_address1`, `order_address2`, `order_address3`, `order_tel`, `order_fax`, `order_delivery`, `order_cart`, `order_note`, `order_delivery_method`, `order_delivery_date`, `order_delivery_time`, `order_payment_name`, `order_condition`, `order_item_total_price`, `order_getpoint`, `order_usedpoint`, `order_discount`, `order_shipping_charge`, `order_cod_fee`, `order_tax`, `order_date`, `order_modified`, `order_status`, `order_delidue_date` ) VALUES (%d, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %d, %s, %s, %s, %s, %f, %d, %d, %f, %f, %f, %f, %s, %s, %s, %s)", $member['ID'], $entry['customer']['mailaddress1'], $entry['customer']['name1'], $entry['customer']['name2'], $entry['customer']['name3'], $entry['customer']['name4'], $entry['customer']['zipcode'], $entry['customer']['pref'], $entry['customer']['address1'], $entry['customer']['address2'], $entry['customer']['address3'], $entry['customer']['tel'], $entry['customer']['fax'], serialize($entry['delivery']), serialize($cart), $entry['order']['note'], $entry['order']['delivery_method'], $entry['order']['delivery_date'], $entry['order']['delivery_time'], $entry['order']['payment_name'], serialize($entry['condition']), $item_total_price, $entry['order']['getpoint'], $entry['order']['usedpoint'], $entry['order']['discount'], $entry['order']['shipping_charge'], $entry['order']['cod_fee'], $entry['order']['tax'], get_date_from_gmt(gmdate('Y-m-d H:i:s', time())), $order_modified, $status, $delidue_date ); //20101208ysk end $res = $wpdb->query( $query ); usces_log('reg_orderdata : ' . $wpdb->last_error, 'database_error.log'); if( $res === false){ $order_id = false; }else{ $order_id = $wpdb->insert_id; } if ( !$order_id ) : usces_log('reg_error_entry : '.print_r($entry, true), 'acting_transaction.log'); return false; else : $usces->cart->set_order_entry( array('ID' => $order_id) ); $usces->set_order_meta_value('customer_country', $entry['customer']['country'], $order_id); if ( $member['ID'] && 'activate' == $options['membersystem_state'] && 'activate' == $options['membersystem_point'] ) { $mquery = ''; if( usces_is_complete_settlement( $entry['order']['payment_name'], $status ) ) {//20120306ysk 0000324 if( apply_filters( 'usces_action_acting_getpoint_switch', true, $order_id, true) ){ $mquery = $wpdb->prepare( "UPDATE $member_table_name SET mem_point = (mem_point + %d - %d) WHERE ID = %d", $entry['order']['getpoint'], $entry['order']['usedpoint'], $member['ID']); }else{ $mquery = $wpdb->prepare( "UPDATE $member_table_name SET mem_point = (mem_point - %d) WHERE ID = %d", $entry['order']['usedpoint'], $member['ID']); } } elseif( 0 < $entry['order']['usedpoint'] ) { $mquery = $wpdb->prepare( "UPDATE $member_table_name SET mem_point = (mem_point - %d) WHERE ID = %d", $entry['order']['usedpoint'], $member['ID']); } if( $mquery ) { $wpdb->query( $mquery ); $mquery = $wpdb->prepare("SELECT mem_point FROM $member_table_name WHERE ID = %d", $member['ID']); $point = $wpdb->get_var( $mquery ); $_SESSION['usces_member']['point'] = $point; } } if ( !empty($entry['reserve']) ) { foreach ( $entry['reserve'] as $key => $value ) { if ( is_array($value) ) $value = serialize($value); $usces->set_order_meta_value($key, $value, $order_id); } } if ( !preg_match('/pending|noreceipt/', $status) ) { $value = get_date_from_gmt(gmdate('Y-m-d H:i:s', time())); $usces->set_order_meta_value('receipted_date', $value, $order_id); } //20100818ysk start if( !empty($entry['custom_order']) ) { foreach( $entry['custom_order'] as $key => $value ) { $csod_key = 'csod_'.$key; if( is_array($value) ) $value = serialize($value); $usces->set_order_meta_value($csod_key, $value, $order_id); } } if( !empty($entry['custom_customer']) ) { foreach( $entry['custom_customer'] as $key => $value ) { $cscs_key = 'cscs_'.$key; if( is_array($value) ) $value = serialize($value); $usces->set_order_meta_value($cscs_key, $value, $order_id); } } if( !empty($entry['custom_delivery']) ) { foreach( $entry['custom_delivery'] as $key => $value ) { $csde_key = 'csde_'.$key; if( is_array($value) ) $value = serialize($value); $usces->set_order_meta_value($csde_key, $value, $order_id); } } //20100818ysk end if ( isset($_REQUEST['X-S_TORIHIKI_NO']) ) { $usces->set_order_meta_value('settlement_id', $_REQUEST['X-S_TORIHIKI_NO'], $order_id); if ( isset($_REQUEST['X-AC_MEMBERID']) ) { $usces->set_order_meta_value($_REQUEST['X-AC_MEMBERID'], 'continuation', $order_id); //$usces->set_member_meta_value('continue_memberid', $_REQUEST['X-AC_MEMBERID']); $usces->set_member_meta_value('continue_memberid_'.$order_id, $_REQUEST['X-AC_MEMBERID']); } } if(isset($_REQUEST['acting']) && ('jpayment_card' == $_REQUEST['acting'] || 'jpayment_conv' == $_REQUEST['acting'] || 'jpayment_bank' == $_REQUEST['acting'])) { $usces->set_order_meta_value('settlement_id', $_GET['cod'], $order_id); foreach($_GET as $key => $value) { if( 'purchase_jpayment' != $key) $data[$key] = mysql_real_escape_string($value); } $usces->set_order_meta_value('acting_'.$_REQUEST['acting'], serialize($data), $order_id); } if( isset($_REQUEST['acting']) && isset($_REQUEST['acting_return']) && isset($_REQUEST['trans_code']) && 'epsilon' == $_REQUEST['acting'] ) { //$usces->set_order_meta_value('settlement_id', $_GET['trans_code'], $order_id);//20130523ysk 0000711 $usces->set_order_meta_value('settlement_id', $_GET['order_number'], $order_id); } if( isset($_REQUEST['res_tracking_id']) ) { $usces->set_order_meta_value('res_tracking_id', $_REQUEST['res_tracking_id'], $order_id); } //20121206ysk start if( isset($_REQUEST['SID']) && isset($_REQUEST['FUKA']) ) { if( substr($_REQUEST['FUKA'], 0, 24) == 'acting_digitalcheck_card' ) { $data['SID'] = mysql_real_escape_string($_REQUEST['SID']); $usces->set_order_meta_value( $_REQUEST['FUKA'], serialize($data), $order_id ); } $usces->set_order_meta_value( 'SID', $_REQUEST['SID'], $order_id ); } //20121206ysk end //20130225ysk start if( isset($_REQUEST['acting']) && 'mizuho_card' == $_REQUEST['acting'] ) { $data['stran'] = mysql_real_escape_string($_REQUEST['stran']); $data['mbtran'] = mysql_real_escape_string($_REQUEST['mbtran']); $usces->set_order_meta_value( 'acting_'.$_REQUEST['acting'], serialize($data), $order_id ); } elseif( isset($_REQUEST['acting']) && 'mizuho_conv' == $_REQUEST['acting'] ) { $data['stran'] = mysql_real_escape_string($_REQUEST['stran']); $data['mbtran'] = mysql_real_escape_string($_REQUEST['mbtran']); $data['bktrans'] = mysql_real_escape_string($_REQUEST['bktrans']); $data['tranid'] = mysql_real_escape_string($_REQUEST['tranid']); $usces->set_order_meta_value( 'stran', $data['stran'], $order_id ); $usces->set_order_meta_value( 'acting_'.$_REQUEST['acting'], serialize($data), $order_id ); } //20130225ysk end $args = array('cart'=>$cart, 'entry'=>$entry, 'order_id'=>$order_id, 'member_id'=>$member['ID'], 'payments'=>$payments, 'charging_type'=>$charging_type); do_action('usces_action_reg_orderdata', $args); endif; return $order_id; } function usces_new_orderdata() { global $wpdb, $usces; $_POST = $usces->stripslashes_deep_post($_POST); $usces->cart->crear_cart(); $cart = $usces->cart->get_cart(); $item_total_price = $usces->get_total_price( $cart ); $entry = $usces->cart->get_entry(); $member_id = $usces->get_memberid_by_email($_POST['customer']['mailaddress']); $order_table_name = $wpdb->prefix . "usces_order"; $order_table_meta_name = $wpdb->prefix . "usces_order_meta"; $member_table_name = $wpdb->prefix . "usces_member"; $set = $usces->getPayments( $_POST['offer']['payment_name'] ); if( isset($_POST['offer']['receipt']) ) { $status = $_POST['offer']['receipt'].','; } else { $status = ( $set['settlement'] == 'transferAdvance' || $set['settlement'] == 'transferDeferred' || $set['settlement'] == 'acting_remise_conv' || $set['settlement'] == 'acting_zeus_bank' || $set['settlement'] == 'acting_zeus_conv' || $set['settlement'] == 'acting_jpayment_conv' || $set['settlement'] == 'acting_jpayment_bank' || $set['settlement'] == 'acting_sbps_conv' || $set['settlement'] == 'acting_sbps_payeasy' || $set['settlement'] == 'acting_digitalcheck_conv' ) ? 'noreceipt' : ''; } $status .= ( !WCUtils::is_blank($_POST['offer']['taio']) && $_POST['offer']['taio'] != '#none#' ) ? $_POST['offer']['taio'].',' : ''; $status .= $_POST['offer']['admin']; $status = apply_filters('usces_filter_new_orderdata_status', $status); $order_conditions = $usces->get_condition(); //20101208ysk start $query = $wpdb->prepare( "INSERT INTO $order_table_name ( `mem_id`, `order_email`, `order_name1`, `order_name2`, `order_name3`, `order_name4`, `order_zip`, `order_pref`, `order_address1`, `order_address2`, `order_address3`, `order_tel`, `order_fax`, `order_delivery`, `order_cart`, `order_note`, `order_delivery_method`, `order_delivery_date`, `order_delivery_time`, `order_payment_name`, `order_condition`, `order_item_total_price`, `order_getpoint`, `order_usedpoint`, `order_discount`, `order_shipping_charge`, `order_cod_fee`, `order_tax`, `order_date`, `order_modified`, `order_status`, `order_delidue_date` ) VALUES (%d, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %d, %s, %s, %s, %s, %f, %d, %d, %f, %f, %f, %f, %s, %s, %s, %s)", $member_id, $_POST['customer']['mailaddress'], $_POST['customer']['name1'], $_POST['customer']['name2'], $_POST['customer']['name3'], $_POST['customer']['name4'], $_POST['customer']['zipcode'], $_POST['customer']['pref'], $_POST['customer']['address1'], $_POST['customer']['address2'], $_POST['customer']['address3'], $_POST['customer']['tel'], $_POST['customer']['fax'], serialize($_POST['delivery']), serialize($cart), $_POST['offer']['note'], $_POST['offer']['delivery_method'], $_POST['offer']['delivery_date'], $_POST['offer']['delivery_time'], $_POST['offer']['payment_name'], serialize($order_conditions), $item_total_price, $_POST['offer']['getpoint'], $_POST['offer']['usedpoint'], $_POST['offer']['discount'], $_POST['offer']['shipping_charge'], $_POST['offer']['cod_fee'], $_POST['offer']['tax'], get_date_from_gmt(gmdate('Y-m-d H:i:s', time())), null, $status, $_POST['offer']['delidue_date'] ); //20101208ysk end $res = $wpdb->query( $query ); // $wpdb->print_error(); // echo $query; // exit; $order_id = $wpdb->insert_id; $_REQUEST['order_id'] = $wpdb->insert_id; //20100818ysk start if( !$order_id ) : return false; else : $usces->set_order_meta_value('customer_country', $_POST['customer']['country'], $order_id); if( !empty($_POST['custom_order']) ) { foreach( $_POST['custom_order'] as $key => $value ) { $csod_key = 'csod_'.$key; if( is_array($value) ) $value = serialize($value); $usces->set_order_meta_value($csod_key, $value, $order_id); } } if( !empty($_POST['custom_customer']) ) { foreach( $_POST['custom_customer'] as $key => $value ) { $cscs_key = 'cscs_'.$key; if( is_array($value) ) $value = serialize($value); $usces->set_order_meta_value($cscs_key, $value, $order_id); } } if( !empty($_POST['custom_delivery']) ) { foreach( $_POST['custom_delivery'] as $key => $value ) { $csde_key = 'csde_'.$key; if( is_array($value) ) $value = serialize($value); $usces->set_order_meta_value($csde_key, $value, $order_id); } } if ( !preg_match('/pending|noreceipt/', $status) ) { $value = get_date_from_gmt(gmdate('Y-m-d H:i:s', time())); $usces->set_order_meta_value('receipted_date', $value, $order_id); } //20120314ysk start 0000435 $args = array('cart'=>$cart, 'entry'=>$entry, 'order_id'=>$order_id, 'member_id'=>$member_id); do_action('usces_action_reg_orderdata', $args); //20120314ysk end endif; //20100818ysk end $usces->cart->crear_cart(); return $res; } function usces_delete_memberdata( $ID = 0 ) { global $wpdb, $usces; if( 0 === $ID ){ if(!isset($_REQUEST['member_id']) || WCUtils::is_blank($_REQUEST['member_id']) ) return 0; $ID = $_REQUEST['member_id']; } do_action('usces_action_pre_delete_memberdata', $ID); $member_table_name = $wpdb->prefix . "usces_member"; //20100818ysk start $member_table_meta_name = $wpdb->prefix . "usces_member_meta"; //20100818ysk end $query = $wpdb->prepare("DELETE FROM $member_table_name WHERE ID = %d", $ID); $res = $wpdb->query( $query ); //20100818ysk start if($res) { $query = $wpdb->prepare("DELETE FROM $member_table_meta_name WHERE member_id = %d", $ID); $wpdb->query( $query ); } //20100818ysk end do_action('usces_action_post_delete_memberdata', $res, $ID); return $res; } function usces_update_memberdata() { global $wpdb, $usces; $_POST = $usces->stripslashes_deep_post($_POST); $member_table_name = $wpdb->prefix . "usces_member"; //20100818ysk start $member_table_meta_name = $wpdb->prefix . "usces_member_meta"; //20100818ysk end $ID = (int)$_REQUEST['member_id']; //$wpdb->show_errors(); $query = $wpdb->prepare( "UPDATE $member_table_name SET `mem_email`=%s, `mem_status`=%s, `mem_point`=%d, `mem_name1`=%s, `mem_name2`=%s, `mem_name3`=%s, `mem_name4`=%s, `mem_zip`=%s, `mem_pref`=%s, `mem_address1`=%s, `mem_address2`=%s, `mem_address3`=%s, `mem_tel`=%s, `mem_fax`=%s WHERE ID = %d", $_POST['member']['email'], $_POST['member']['status'], $_POST['member']['point'], $_POST['member']['name1'], $_POST['member']['name2'], $_POST['member']['name3'], $_POST['member']['name4'], $_POST['member']['zipcode'], $_POST['member']['pref'], $_POST['member']['address1'], $_POST['member']['address2'], $_POST['member']['address3'], $_POST['member']['tel'], $_POST['member']['fax'], $ID ); do_action('usces_action_pre_update_memberdata', $ID); //20100818ysk start //$res = $wpdb->query( $query ); $res[0] = $wpdb->query( $query ); do_action( 'usces_action_post_update_memberdata', $ID, $res[0]); if(false === $res[0]) return false; $usces->set_member_meta_value('customer_country', $_POST['member']['country'], $ID); //20130524ysk start 0000712 $csmb_meta = usces_has_custom_field_meta( 'member' ); if( is_array($csmb_meta) ) { foreach( $csmb_meta as $key => $entry ) { if( '4' == $entry['means'] ) { $usces->del_member_meta( 'csmb_'.$key, $ID ); } } } //20130524ysk end $i = 1; if( !empty($_POST['custom_member']) ) { foreach( $_POST['custom_member'] as $key => $value ) { $csmb_key = 'csmb_'.$key; if( is_array($value) ) $value = serialize($value); $res[$i] = $usces->set_member_meta_value($csmb_key, $value, $ID); if(false === $res[$i]) return false; $i++; } } //$meta_keys = apply_filters( 'usces_filter_delete_member_pcid', "'zeus_pcid', 'remise_pcid', 'digitalcheck_ip_user_id'" ); $meta_keys = apply_filters( 'usces_filter_delete_member_pcid', "'remise_pcid', 'digitalcheck_ip_user_id'" ); $query = $wpdb->prepare("DELETE FROM $member_table_meta_name WHERE member_id = %d AND meta_key IN( $meta_keys )", $_POST['member_id'] ); $res[$i] = $wpdb->query( $query ); $result = ( 0 < array_sum($res) ) ? 1 : 0; //return $res; return $result; //20100818ysk end } function usces_delete_orderdata() { global $wpdb, $usces; if(!isset($_REQUEST['order_id']) || WCUtils::is_blank($_REQUEST['order_id']) ) return 0; $order_table = $wpdb->prefix . "usces_order"; $order_meta_table = $wpdb->prefix . "usces_order_meta"; $ID = $_REQUEST['order_id']; $del = usces_delete_order_check( $ID ); if( $del ) { $query = $wpdb->prepare("SELECT * FROM $order_table WHERE ID = %d", $ID); $order_data = $wpdb->get_row( $query, OBJECT ); //20130625ysk start 0000721 //20120306ysk start 0000324 //$order_res = $wpdb->get_row( $query, ARRAY_A ); //$restore_point = false; $point = 0; if( 'activate' == $usces->options['membersystem_state'] && 'activate' == $usces->options['membersystem_point'] && !empty($order_data->mem_id) && !$usces->is_status('cancel', $order_data->order_status) ) { if( 0 < $order_data->order_getpoint ) { //if( $usces->is_status('completion', $order_data->order_status) ) { // //$restore_point = true; // $point += $order_data->order_getpoint; //} else { if( usces_is_complete_settlement( $order_data->order_payment_name, $order_data->order_status ) || $usces->is_status('receipted', $order_data->order_status) ) { //$restore_point = true; $point += $order_data->order_getpoint; } //} } if( 0 < $order_data->order_usedpoint ) { $point -= $order_data->order_usedpoint; } } //20120306ysk end $query = $wpdb->prepare("DELETE FROM $order_table WHERE ID = %d", $ID); $res = $wpdb->query( $query ); $args = compact( 'ID', 'point', 'res' ); if($res){ $query = $wpdb->prepare("DELETE FROM $order_meta_table WHERE order_id = %d", $ID); $wpdb->query( $query ); do_action('usces_action_del_orderdata', $order_data, $args); //20120306ysk start 0000324 //if( $restore_point ) usces_restore_point( $order_res['mem_id'], $order_res['order_getpoint'] ); if( 0 != $point ) usces_restore_point( $order_data->mem_id, $point ); //20120306ysk end //20130625ysk end } } else { $res = true; } return $res; } function usces_update_ordercart() { global $wpdb, $usces; if(!isset($_REQUEST['order_id']) || WCUtils::is_blank($_REQUEST['order_id']) ) return 0; $order_table_name = $wpdb->prefix . "usces_order"; $ID = $_REQUEST['order_id']; $usces->cart->crear_cart(); $usces->cart->upCart(); $cart = $usces->cart->get_cart(); //20120613ysk start 0000500 $idx = count($cart)-1; $post_id = $cart[$idx]['post_id']; $sku = $cart[$idx]['sku']; $sku_code = esc_attr(urldecode($sku)); $cartItemName = $usces->getCartItemName($post_id, $sku_code); $skuPrice = $cart[$idx]['price']; //20120613ysk end $query = $wpdb->prepare("UPDATE $order_table_name SET `order_cart`=%s WHERE ID = %d", serialize($cart), $ID); $res = $wpdb->query( $query ); $usces->cart->crear_cart(); //20120613ysk start 0000500 if( $res === false ) { $res = "-1#usces#"; } else { $res = $skuPrice."#usces#".$cartItemName; } //20120613ysk end return $res; } function usces_update_ordercheck() { global $wpdb, $usces; $tableName = $wpdb->prefix . "usces_order"; $order_id = $_POST['order_id']; $checked = $_POST['checked']; $query = $wpdb->prepare("SELECT `order_check` FROM $tableName WHERE ID = %d", $order_id); $res = $wpdb->get_var( $query ); $checkfield = unserialize($res); if( !isset($checkfield[$checked]) ) $checkfield[$checked] = $checked; //$checkfield = 'OK'; $query = $wpdb->prepare("UPDATE $tableName SET `order_check`=%s WHERE ID = %d", serialize($checkfield), $order_id); $res = $wpdb->query( $query ); if($res) return $checked; else return 'error'; } function usces_update_orderdata() { global $wpdb, $usces; $_POST = $usces->stripslashes_deep_post($_POST); $order_table_name = $wpdb->prefix . "usces_order"; $order_table_meta_name = $wpdb->prefix . "usces_order_meta"; $member_table_name = $wpdb->prefix . "usces_member"; $ID = $_REQUEST['order_id']; $query = $wpdb->prepare("SELECT * FROM $order_table_name WHERE ID = %d", $ID); $old_orderdata = $wpdb->get_row( $query ); $old_status = $old_orderdata->order_status; $usces->cart->crear_cart(); $usces->cart->upCart(); if(isset($_POST['delButton'])) { $usces->cart->del_row(); $indexs = array_keys($_POST['delButton']); $index = $indexs[0]; do_action('usces_admin_delete_orderrow', $ID, $index ); } $cart = $usces->cart->get_cart(); $usces->cart->entry(); $entry = $usces->cart->get_entry(); $item_total_price = $usces->get_total_price( $cart ); $set = $usces->getPayments( $entry['order']['payment_name'] ); $taio = isset($entry['order']['taio']) ? $entry['order']['taio'] : ''; $receipt = isset($entry['order']['receipt']) ? $entry['order']['receipt'] : ''; $admin = isset($entry['order']['admin']) ? $entry['order']['admin'] : ''; $status = $usces->make_status( $taio, $receipt, $admin ); if( $taio == 'completion' || $taio == 'continuation' ){ if( 'update' == $_POST['up_modified'] ){ $order_modified = substr(get_date_from_gmt(gmdate('Y-m-d H:i:s', time())), 0, 10); }else{ $order_modified = $_POST['modified']; } }else{ $order_modified = ''; } $ordercheck = isset($_POST['check']) ? serialize($_POST['check']) : ''; $member_id = isset($_POST['member_id']) ? $_POST['member_id'] : 0; //$member_id = $usces->get_memberid_by_email($_POST['customer']['mailaddress']); if( 'cancel' == $taio ){ $query = $wpdb->prepare( "UPDATE $order_table_name SET `order_modified`=%s, `order_status`=%s WHERE ID = %d", $order_modified, $status, $ID ); $res[0] = $wpdb->query( $query ); $query = $wpdb->prepare("SELECT * FROM $order_table_name WHERE ID = %d", $ID); $new_orderdata = $wpdb->get_row( $query ); do_action('usces_action_update_orderdata', $new_orderdata, $old_status, $old_orderdata); $usces->cart->crear_cart(); //20131101ysk start 0000751 if( 'activate' == $usces->options['membersystem_state'] && 'activate' == $usces->options['membersystem_point'] && !empty($member_id) && !$usces->is_status('cancel', $old_status) ) { $point = 0; if( 0 < $old_orderdata->order_getpoint ) { if( usces_is_complete_settlement( $old_orderdata->order_payment_name, $old_orderdata->order_status ) || $usces->is_status('receipted', $old_orderdata->order_status) ) { $point += $old_orderdata->order_getpoint; } } if( 0 < $old_orderdata->order_usedpoint ) { $point -= $old_orderdata->order_usedpoint; } if( 0 != $point ) usces_restore_point( $member_id, $point ); } //20131101ysk end return 1; } //$wpdb->show_errors(); //20101208ysk start $query = $wpdb->prepare( "UPDATE $order_table_name SET `mem_id`=%d, `order_email`=%s, `order_name1`=%s, `order_name2`=%s, `order_name3`=%s, `order_name4`=%s, `order_zip`=%s, `order_pref`=%s, `order_address1`=%s, `order_address2`=%s, `order_address3`=%s, `order_tel`=%s, `order_fax`=%s, `order_delivery`=%s, `order_cart`=%s, `order_note`=%s, `order_delivery_method`=%d, `order_delivery_date`=%s, `order_delivery_time`=%s, `order_payment_name`=%s, `order_item_total_price`=%f, `order_getpoint`=%d, `order_usedpoint`=%d, `order_discount`=%f, `order_shipping_charge`=%f, `order_cod_fee`=%f, `order_tax`=%f, `order_modified`=%s, `order_status`=%s, `order_delidue_date`=%s, `order_check`=%s WHERE ID = %d", $member_id, $_POST['customer']['mailaddress'], $_POST['customer']['name1'], $_POST['customer']['name2'], $_POST['customer']['name3'], $_POST['customer']['name4'], $_POST['customer']['zipcode'], $_POST['customer']['pref'], $_POST['customer']['address1'], $_POST['customer']['address2'], $_POST['customer']['address3'], $_POST['customer']['tel'], $_POST['customer']['fax'], serialize($_POST['delivery']), serialize($cart), $_POST['offer']['note'], $_POST['offer']['delivery_method'], $_POST['offer']['delivery_date'], $_POST['offer']['delivery_time'], $_POST['offer']['payment_name'], $item_total_price, $_POST['offer']['getpoint'], $_POST['offer']['usedpoint'], $_POST['offer']['discount'], $_POST['offer']['shipping_charge'], $_POST['offer']['cod_fee'], $_POST['offer']['tax'], $order_modified, $status, $_POST['offer']['delidue_date'], $ordercheck, $ID ); //20101208ysk end //20100818ysk start //$res = $wpdb->query( $query ); $res[0] = $wpdb->query( $query ); if(false === $res[0]) return false; $usces->set_order_meta_value('customer_country', $_POST['customer']['country'], $ID); //20130524ysk start 0000712 $csod_meta = usces_has_custom_field_meta( 'order' ); if( is_array($csod_meta) ) { foreach( $csod_meta as $key => $entry ) { if( '4' == $entry['means'] ) { $usces->del_order_meta( 'csod_'.$key, $ID ); } } } $cscs_meta = usces_has_custom_field_meta( 'customer' ); if( is_array($cscs_meta) ) { foreach( $cscs_meta as $key => $entry ) { if( '4' == $entry['means'] ) { $usces->del_order_meta( 'cscs_'.$key, $ID ); } } } $csde_meta = usces_has_custom_field_meta( 'delivery' ); if( is_array($csde_meta) ) { foreach( $csde_meta as $key => $entry ) { if( '4' == $entry['means'] ) { $usces->del_order_meta( 'csde_'.$key, $ID ); } } } //20130524ysk end $i = 1; if( !empty($_POST['custom_order']) ) { foreach( $_POST['custom_order'] as $key => $value ) { $csod_key = 'csod_'.$key; if( is_array($value) ) $value = serialize($value); $res[$i] = $usces->set_order_meta_value($csod_key, $value, $ID); if(false === $res[$i]) return false; $i++; } } if( !empty($_POST['custom_customer']) ) { foreach( $_POST['custom_customer'] as $key => $value ) { $cscs_key = 'cscs_'.$key; if( is_array($value) ) $value = serialize($value); $res[$i] = $usces->set_order_meta_value($cscs_key, $value, $ID); if(false === $res[$i]) return false; $i++; } } if( !empty($_POST['custom_delivery']) ) { foreach( $_POST['custom_delivery'] as $key => $value ) { $csde_key = 'csde_'.$key; if( is_array($value) ) $value = serialize($value); $res[$i] = $usces->set_order_meta_value($csde_key, $value, $ID); if(false === $res[$i]) return false; $i++; } } $value = get_date_from_gmt(gmdate('Y-m-d H:i:s', time())); if ( !preg_match('/pending|noreceipt/', $old_status) && preg_match('/pending|noreceipt/', $status) ) { $rquery = $wpdb->prepare("DELETE FROM $order_table_meta_name WHERE order_id = %d AND meta_key = %s", $ID, 'receipted_date'); $wpdb->query( $rquery ); }else if ( !preg_match('/pending|noreceipt/', $old_status) && !preg_match('/pending|noreceipt/', $status) ) { $query = $wpdb->prepare("SELECT order_id FROM $order_table_meta_name WHERE order_id = %d AND meta_key = %s", $ID, 'receipted_date'); $varres = $wpdb->get_var( $query ); if( empty($varres) ){ $usces->set_order_meta_value('receipted_date', $value, $ID); } }else if ( preg_match('/pending|noreceipt/', $old_status) && !preg_match('/pending|noreceipt/', $status) ) { $usces->set_order_meta_value('receipted_date', $value, $ID); } //20131101ysk start 0000751 //if( !usces_is_complete_settlement( $_POST['offer']['payment_name'] ) ) { // if( !preg_match('/pending|noreceipt/', $old_status) && preg_match('/pending|noreceipt/', $status) ) {//入金→未入金 // usces_action_acting_getpoint( $ID, false );//ポイント取消 // } else if( preg_match('/pending|noreceipt/', $old_status) && !preg_match('/pending|noreceipt/', $status) ) {//未入金→入金 // usces_action_acting_getpoint( $ID );//ポイント追加 // } //} if( 'activate' == $usces->options['membersystem_state'] && 'activate' == $usces->options['membersystem_point'] && !empty($member_id) ) { $point = 0; $getpoint = $_POST['offer']['getpoint']; $usedpoint = $_POST['offer']['usedpoint']; if( $usces->is_status('cancel', $old_status) && !$usces->is_status('cancel', $status) ) {//キャンセル→新規受付・取り寄せ中・発送済み if( 0 < $getpoint ) { if( usces_is_complete_settlement( $_POST['offer']['payment_name'], $status ) || $usces->is_status('receipted', $status) ) { $point -= $getpoint; } } if( 0 < $usedpoint ) { $point += $usedpoint; } } else { if( !usces_is_complete_settlement( $_POST['offer']['payment_name'] ) ) { if( !preg_match('/pending|noreceipt/', $old_status) && preg_match('/pending|noreceipt/', $status) ) {//入金→未入金 $point += $getpoint;//ポイント取消 } else if( preg_match('/pending|noreceipt/', $old_status) && !preg_match('/pending|noreceipt/', $status) ) {//未入金→入金 $point -= $getpoint;//ポイント追加 } else { if( $old_orderdata->order_getpoint != $getpoint ) { $point += $old_orderdata->order_getpoint - $getpoint; } } } else { if( $old_orderdata->order_getpoint != $getpoint ) { $point += $old_orderdata->order_getpoint - $getpoint; } } if( $old_orderdata->order_usedpoint != $usedpoint ) { $point -= $old_orderdata->order_usedpoint - $usedpoint; } } if( 0 != $point ) usces_restore_point( $member_id, $point ); } //20131101ysk end $result = ( 0 < array_sum($res) ) ? 1 : 0; //20100818ysk end $query = $wpdb->prepare("SELECT * FROM $order_table_name WHERE ID = %d", $ID); $new_orderdata = $wpdb->get_row( $query ); //20120612ysk start 0000501 //do_action('usces_action_update_orderdata', $new_orderdata); do_action('usces_action_update_orderdata', $new_orderdata, $old_status, $old_orderdata); //20120612ysk end $usces->cart->crear_cart(); return $result; // else : // // if ( $member['ID'] ) { // // $mquery = $wpdb->prepare( // "UPDATE $member_table_name SET mem_point = (mem_point + %d - %d) WHERE ID = %d", // $entry['order']['getpoint'], $entry['order']['usedpoint'], $member['ID']); // // $wpdb->query( $mquery ); // $mquery = $wpdb->prepare("SELECT mem_point FROM $member_table_name WHERE ID = %d", $member['ID']); // $point = $wpdb->get_var( $mquery ); // $_SESSION['usces_member']['point'] = $point; // } // // if ( !empty($entry['reserve']) ) { // foreach ( $entry['reserve'] as $key => $value ) { // if ( is_array($value) ) // $value = serialize($value); // $mquery = $wpdb->prepare("INSERT INTO $order_table_meta_name ( order_id, meta_key, meta_value ) // VALUES (%d, %s, %s, %s)", $order_id, $key, $value); // $wpdb->query( $mquery ); // } // } // // endif; // // //zaiko // foreach($cart as $cartrow){ // $zaikonum = $usces->getItemZaikoNum( $cartrow['post_id'], $cartrow['sku'] ); // if($zaikonum == '') continue; // $zaikonum = $zaikonum - $cartrow['quantity']; // $usces->updateItemZaikoNum( $cartrow['post_id'], $cartrow['sku'], $zaikonum ); // if($zaikonum <= 0) $usces->updateItemZaiko( $cartrow['post_id'], $cartrow['sku'], 2 ); // } // // return $order_id; } function usces_export_xml() { $options = get_option('usces'); echo '\n"; ?> get_skus($post_id); foreach ( (array)$skus as $sku ){ $res = usces_update_sku( $post_id, $sku['code'], 'stock', (int)$_POST['change']['word']['zaiko'] ); if( !$res ){ $status = false; } } } if ( true === $status ) { $obj->set_action_status('success', __('I completed collective operation.','usces')); } elseif ( false === $status ) { $obj->set_action_status('error', __('ERROR: I was not able to complete collective operation','usces')); } else { $obj->set_action_status('none', ''); } } function usces_all_change_itemdisplay(&$obj){ global $wpdb; $ids = $_POST['listcheck']; $post_status = $_POST['change']['word']['display_status']; $status = true; foreach ( (array)$ids as $post_id ): // $query = $wpdb->prepare("UPDATE $wpdb->posts SET post_status = %s WHERE ID = %d", $post_status, $post_id); // $res = $wpdb->query( $query ); $post_data = array('ID'=>$post_id, 'post_status'=>$post_status); $res = wp_update_post( $post_data ); if( $res == 0 ) { $status = false; } endforeach; if ( true === $status ) { $obj->set_action_status('success', __('I completed collective operation.','usces')); } elseif ( false === $status ) { $obj->set_action_status('error', __('ERROR: I was not able to complete collective operation','usces')); } else { $obj->set_action_status('none', ''); } } function usces_all_change_order_reciept(&$obj){ global $wpdb, $usces; $tableName = $wpdb->prefix . "usces_order"; $ids = $_POST['listcheck']; $status = true; foreach ( (array)$ids as $id ): //20120306ysk start 0000324 //$query = $wpdb->prepare("SELECT order_status FROM $tableName WHERE ID = %d", $id); //$statusstr = $wpdb->get_var( $query ); $query = $wpdb->prepare("SELECT order_status, mem_id, order_getpoint FROM $tableName WHERE ID = %d", $id); $order_res = $wpdb->get_row( $query, ARRAY_A ); $statusstr = $order_res['order_status']; $restore_point = false; $getpoint = $order_res['order_getpoint']; if( strpos($statusstr, 'cancel') !== false ) continue;//20131101ysk 0000751 //20120306ysk end if(strpos($statusstr, 'noreceipt') === false && strpos($statusstr, 'receipted') === false) continue; $old_status = $statusstr;//20120612ysk 0000501 if($_REQUEST['change']['word']['order_reciept'] == 'receipted') { //20120306ysk start 0000324 //if(strpos($statusstr, 'noreceipt') !== false) if(strpos($statusstr, 'noreceipt') !== false) { $statusstr = str_replace('noreceipt', 'receipted', $statusstr); //if( !$usces->is_status('completion', $order_res['order_status']) ) { $restore_point = true; $getpoint = $getpoint * -1;//add point //} } //20120306ysk end }elseif($_REQUEST['change']['word']['order_reciept'] == 'noreceipt') { //20120306ysk start 0000324 //if(strpos($statusstr, 'receipted') !== false) if(strpos($statusstr, 'receipted') !== false) { $statusstr = str_replace('receipted', 'noreceipt', $statusstr); //if( !$usces->is_status('completion', $order_res['order_status']) ) $restore_point = true; } //20120306ysk end } $query = $wpdb->prepare("UPDATE $tableName SET order_status = %s WHERE ID = %d", $statusstr, $id); $res = $wpdb->query( $query ); if( $res === false ) { $status = false; } //20120306ysk start 0000324 if( 'activate' == $usces->options['membersystem_state'] && 'activate' == $usces->options['membersystem_point'] ) { if( !empty($order_res['mem_id']) && 0 < $order_res['order_getpoint'] ) { if( $res && $restore_point ) usces_restore_point( $order_res['mem_id'], $getpoint ); } } //20120306ysk end if( $status ) { do_action( 'usces_action_collective_order_reciept_each', $id, $statusstr, $old_status ); } endforeach; if ( true === $status ) { $obj->set_action_status('success', __('I completed collective operation.','usces')); } elseif ( false === $status ) { $obj->set_action_status('error', __('ERROR: I was not able to complete collective operation','usces')); } else { $obj->set_action_status('none', ''); } do_action('usces_action_collective_order_reciept', array(&$obj)); } function usces_all_change_order_status(&$obj){ global $wpdb, $usces; $tableName = $wpdb->prefix . "usces_order"; $ids = $_POST['listcheck']; foreach ( (array)$ids as $id ): $status = true; //20120306ysk start 0000324 //$query = $wpdb->prepare("SELECT order_status FROM $tableName WHERE ID = %d", $id); //$statusstr = $wpdb->get_var( $query ); $query = $wpdb->prepare("SELECT order_status, mem_id, order_getpoint, order_usedpoint, order_payment_name FROM $tableName WHERE ID = %d", $id); $order_res = $wpdb->get_row( $query, ARRAY_A ); $statusstr = $order_res['order_status']; $restore_point = false; $getpoint = $order_res['order_getpoint']; $usedpoint = $order_res['order_usedpoint']; //20120306ysk end $old_status = $statusstr;//20120612ysk 0000501 switch ($_REQUEST['change']['word']['order_status']) { case 'estimate': if(strpos($statusstr, 'adminorder') !== false) { $statusstr = str_replace('adminorder', 'estimate', $statusstr); }else if(strpos($statusstr, 'estimate') === false) { $statusstr .= 'estimate,'; } break; case 'adminorder': if(strpos($statusstr, 'estimate') !== false) { $statusstr = str_replace('estimate', 'adminorder', $statusstr); }else if(strpos($statusstr, 'adminorder') === false) { $statusstr .= 'adminorder,'; } break; case 'duringorder': if(strpos($statusstr, 'cancel') !== false) { $statusstr = str_replace('cancel', 'duringorder', $statusstr); //20120919ysk start 0000573 if( usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) ) { $restore_point = true; $getpoint = $getpoint * -1;//add point } elseif( $usces->is_status('receipted', $order_res['order_status']) ) { $restore_point = true; $getpoint = $getpoint * -1;//add point } //20120919ysk end }else if(strpos($statusstr, 'completion') !== false) { $statusstr = str_replace('completion', 'duringorder', $statusstr); //20120306ysk start 0000324 //if( !usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) && !$usces->is_status('receipted', $order_res['order_status']) ) // $restore_point = true; //20120306ysk end }else if(strpos($statusstr, 'new') !== false) { $statusstr = str_replace('new', 'duringorder', $statusstr); }else if(strpos($statusstr, 'duringorder') === false) { $statusstr .= 'duringorder,'; } break; case 'cancel': if(strpos($statusstr, 'completion') !== false) { $statusstr = str_replace('completion', 'cancel', $statusstr); //20120306ysk start 0000324 //if( !usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) && !$usces->is_status('receipted', $order_res['order_status']) ) // $restore_point = true; //20120306ysk end }else if(strpos($statusstr, 'new') !== false) { $statusstr = str_replace('new', 'cancel', $statusstr); }else if(strpos($statusstr, 'duringorder') !== false) { $statusstr = str_replace('duringorder', 'cancel', $statusstr); }else if(strpos($statusstr, 'cancel') === false) { $statusstr .= 'cancel,'; } //20120919ysk start 0000573 if( usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) ) { $restore_point = true; $usedpoint = $usedpoint * -1;//add point } elseif( $usces->is_status('receipted', $order_res['order_status']) ) { $restore_point = true; $usedpoint = $usedpoint * -1;//add point } //20120919ysk end break; case 'completion': if(strpos($statusstr, 'new') !== false) { $statusstr = str_replace('new', 'completion', $statusstr); }else if(strpos($statusstr, 'duringorder') !== false) { $statusstr = str_replace('duringorder', 'completion', $statusstr); }else if(strpos($statusstr, 'cancel') !== false) { $statusstr = str_replace('cancel', 'completion', $statusstr); //20120919ysk start 0000573 if( usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) ) { $restore_point = true; $getpoint = $getpoint * -1;//add point } elseif( $usces->is_status('receipted', $order_res['order_status']) ) { $restore_point = true; $getpoint = $getpoint * -1;//add point } //20120919ysk end }else if(strpos($statusstr, 'completion') === false) { $statusstr .= 'completion,'; } //20120306ysk start 0000324 //if( !usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) && !$usces->is_status('receipted', $order_res['order_status']) ) { // $restore_point = true; // $getpoint = $getpoint * -1;//add point //} //20120306ysk end break; case 'new': if(strpos($statusstr, 'duringorder') !== false) { $statusstr = str_replace('duringorder,', '', $statusstr); }else if(strpos($statusstr, 'completion') !== false) { $statusstr = str_replace('completion,', '', $statusstr); //20120306ysk start 0000324 //if( !usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) && !$usces->is_status('receipted', $order_res['order_status']) ) // $restore_point = true; //20120306ysk end }else if(strpos($statusstr, 'cancel') !== false) { $statusstr = str_replace('cancel,', '', $statusstr); //20120919ysk start 0000573 if( usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) ) { $restore_point = true; $getpoint = $getpoint * -1;//add point } elseif( $usces->is_status('receipted', $order_res['order_status']) ) { $restore_point = true; $getpoint = $getpoint * -1;//add point } //20120919ysk end } break; } $query = $wpdb->prepare("UPDATE $tableName SET order_status = %s WHERE ID = %d", $statusstr, $id); $res = $wpdb->query( $query ); if( $res === false ) { $status = false; } //20120306ysk start 0000324 if( 'activate' == $usces->options['membersystem_state'] && 'activate' == $usces->options['membersystem_point'] ) { if( !empty($order_res['mem_id']) && ( 0 < $order_res['order_getpoint'] || 0 < $order_res['order_usedpoint'] ) ) { if( $res && $restore_point ) usces_restore_point( $order_res['mem_id'], $getpoint + $usedpoint ); } } //20120306ysk end //20120612ysk 0000501 start if( $status ) { do_action('usces_action_collective_order_status_each', $id, $statusstr, $old_status); } //20120612ysk end endforeach; if ( true === $status ) { $obj->set_action_status('success', __('I completed collective operation.','usces')); } elseif ( false === $status ) { $obj->set_action_status('error', __('ERROR: I was not able to complete collective operation','usces')); } else { $obj->set_action_status('none', ''); } do_action('usces_action_collective_order_status', array(&$obj)); } function usces_all_delete_order_data(&$obj){ global $wpdb, $usces; $tableName = $wpdb->prefix . "usces_order"; $tableMetaName = $wpdb->prefix . "usces_order_meta"; $ids = $_POST['listcheck']; $status = true; foreach ( (array)$ids as $id ): $del = usces_delete_order_check( $id ); if( $del === false ) continue; //20130625ysk start 0000721 //20120306ysk start 0000324 //$restore_point = false; $point = 0; if( 'activate' == $usces->options['membersystem_state'] && 'activate' == $usces->options['membersystem_point'] && !empty($order_res['mem_id']) && !$usces->is_status('cancel', $order_res['order_status']) ) { $query = $wpdb->prepare("SELECT * FROM $tableName WHERE ID = %d", $id); $order_res = $wpdb->get_row( $query, ARRAY_A ); if( 0 < $order_res['order_getpoint'] ) { //if( $usces->is_status('completion', $order_res['order_status']) ) { // $restore_point = true; //} else { if( usces_is_complete_settlement( $order_res['order_payment_name'], $order_res['order_status'] ) || $usces->is_status('receipted', $order_res['order_status']) ) //$restore_point = true; $point += $order_res['order_getpoint']; //} } if( 0 < $order_res['order_usedpoint'] ) { $point -= $order_res['order_usedpoint']; } } //20120306ysk end $query = $wpdb->prepare("DELETE FROM $tableName WHERE ID = %d", $id); $res = $wpdb->query( $query ); if( $res === false ) { $status = false; }else{ $metaquery = $wpdb->prepare("DELETE FROM $tableMetaName WHERE order_id = %d", $id);//0000427 $metares = $wpdb->query( $metaquery ); //20120306ysk start 0000324 //if( $restore_point ) usces_restore_point( $order_res['mem_id'], $order_res['order_getpoint'] ); if( 0 != $point ) usces_restore_point( $order_res['mem_id'], $point ); //20120306ysk end //20120612ysk start 0000501 //20130419ysk do_action('usces_action_collective_order_delete_each', $id, $order_res); //20120612ysk end } endforeach; if ( true === $status ) { $obj->set_action_status('success', __('I completed collective operation.','usces')); } elseif ( false === $status ) { $obj->set_action_status('error', __('ERROR: I was not able to complete collective operation','usces')); } else { $obj->set_action_status('none', ''); } do_action('usces_action_collective_order_delete', array(&$obj)); } function usces_check_acting_return() { global $usces; $entry = $usces->cart->get_entry(); $acting = $_GET['acting']; $results = array(); switch ( $acting ) { case 'epsilon': if(isset($_GET['duplicate']) && $_GET['duplicate'] == 1){ $results[0] = 'duplicate'; }else if(isset($_GET['result'])){ $results[0] = (int)$_GET['result']; $results['reg_order'] = true; }else{ $str = explode('?', $_GET['acting_return']); if(!isset($str[1])) { $results[0] = 0; }else{ $para = parse_str($str[1]); $results[0] = isset($para['result']) ? (int)$para['result'] : 0; foreach($para as $key => $value){ $results[$key] = $value; } } } $results['reg_order'] = true; break; case 'paypal': usces_log('paypal in ', 'acting_transaction.log'); require_once($usces->options['settlement_path'] . "paypal.php"); $results = paypal_check($usces_paypal_url); remove_action( 'wp_footer', array(&$usces, 'lastprocessing')); $results['reg_order'] = true; break; case 'zeus_card': $results = $_REQUEST; if( $_REQUEST['acting_return'] && isset($_REQUEST['wctid']) && usces_is_trusted_acting_data($_REQUEST['wctid']) ){ $results[0] = 1; }else{ $results[0] = 0; } $results['reg_order'] = true; break; case 'zeus_conv': $results = $_GET; if( $_REQUEST['acting_return'] ){ $results[0] = 1; }else{ $results[0] = 0; } $results['reg_order'] = false; break; case 'remise_card': $results = $_POST; if( $_REQUEST['acting_return'] && ( isset($_REQUEST['X-ERRCODE']) && ' ' === $_REQUEST['X-ERRCODE'] ) ){ usces_log('remise card entry data : '.print_r($entry, true), 'acting_transaction.log'); $results[0] = 1; }else{ $results[0] = 0; } if( isset($_REQUEST['dlseller_update']) ){ $results['reg_order'] = false; }else{ $results['reg_order'] = true; } break; case 'remise_conv': $results = $_GET; if( $_REQUEST['acting_return'] && isset($_REQUEST['X-JOB_ID']) && '0:0000' === $_REQUEST['X-R_CODE']){ //usces_log('remise conv entry data : '.print_r($entry, true), 'acting_transaction.log'); $results[0] = 1; }else{ $results[0] = 0; } $results['reg_order'] = true; break; //20101018ysk start case 'jpayment_card': $results = $_GET; if($_GET['rst'] == 2) { usces_log('jpayment card error : '.print_r($entry, true), 'acting_transaction.log'); } $results[0] = ($_GET['rst'] == 1) ? 1 : 0; $results['reg_order'] = true; break; case 'jpayment_conv': $results = $_GET; if($_GET['rst'] == 2) { usces_log('jpayment conv error : '.print_r($entry, true), 'acting_transaction.log'); } $results[0] = ($_GET['rst'] == 1 and $_GET['ap'] == 'CPL_PRE') ? 1 : 0; $results['reg_order'] = true; break; case 'jpayment_bank': $results = $_GET; if($_GET['rst'] == 2) { usces_log('jpayment bank error : '.print_r($entry, true), 'acting_transaction.log'); } $results[0] = ($_GET['rst'] == 1) ? 1 : 0; $results['reg_order'] = true; break; //20101018ysk end //20110208ysk start case 'paypal_ec': $results = $_GET; //Build a second API request to PayPal, using the token as the ID to get the details on the payment authorization $nvpstr = "&TOKEN=".urlencode($_REQUEST['token']); $usces->paypal->setMethod('GetExpressCheckoutDetails'); $usces->paypal->setData($nvpstr); $res = $usces->paypal->doExpressCheckout(); $resArray = $usces->paypal->getResponse(); $ack = strtoupper($resArray["ACK"]); if($ack == "SUCCESS" || $ack == "SUCCESSWITHWARNING") { //20121009ysk start 0000587 //20121225ysk start 000634 $cart = $usces->cart->get_cart(); $charging_type = $usces->getItemChargingType($cart[0]['post_id'], $cart); if( 'continue' == $charging_type ) { $results[0] = 1; } else { //20121225ysk end if( (float)$resArray["AMT"] != (float)$entry['order']['total_full_price'] ) { usces_log('PayPal : AMT Error. AMT='.$resArray["AMT"].', total_full_price='.$entry['order']['total_full_price'], 'acting_transaction.log'); $results[0] = 0; } else { $results[0] = 1; } } //20121009ysk end } 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 : GetExpressCheckoutDetails API call failed. Error Code:['.$ErrorCode.'] Error Severity Code:['.$ErrorSeverityCode.'] Short Error Message:'.$ErrorShortMsg.' Detailed Error Message:'.$ErrorLongMsg, 'acting_transaction.log'); $results[0] = 0; } $results['reg_order'] = true; break; //20110208ysk end //20120413ysk start case 'sbps_card': case 'sbps_wallet': case 'sbps_mobile': /* if( isset($_REQUEST['cancel']) ) { $results[0] = 0; $results['reg_order'] = false; } else { if( isset($_REQUEST['res_result']) and 'OK' == $_REQUEST['res_result'] ) { usces_log($acting.' entry data : '.print_r($entry, true), 'acting_transaction.log'); $results[0] = 1; } else { usces_log($acting.' error : '.print_r($_REQUEST,true), 'acting_transaction.log'); $results[0] = 0; } $results['reg_order'] = true; } break;*/ case 'sbps_conv': case 'sbps_payeasy': if( isset($_REQUEST['cancel']) ) { $results[0] = 0; $results['reg_order'] = false; } else { if( isset($_REQUEST['res_result']) and 'OK' == $_REQUEST['res_result'] ) { $results[0] = 1; } else { //usces_log($acting.' error : '.print_r($_REQUEST,true), 'acting_transaction.log'); $results[0] = 0; } $results['reg_order'] = false; } break; //20120413ysk end //20120618ysk start case 'telecom_card': $results = $_GET; if( $_REQUEST['result'] ){ usces_log($acting.' entry data : '.print_r($entry, true), 'acting_transaction.log'); $results[0] = 1; }else{ usces_log($acting.' error : '.print_r($_REQUEST,true), 'acting_transaction.log'); $results[0] = 0; } $results['reg_order'] = true; break; //20120618ysk end //20121206ysk start case 'digitalcheck_card': $results = $_REQUEST; if( isset($_REQUEST['SID']) ) { $results[0] = 1; } else { $results[0] = 0; } $results['reg_order'] = true; break; case 'digitalcheck_conv': $results = $_REQUEST; //if( isset($_REQUEST['SID']) ) { $results[0] = 1; //} else { // $results[0] = 0; //} $results['reg_order'] = false; break; //20121206ysk end //20130225ysk start case 'mizuho_card': case 'mizuho_conv': $results = $_GET; if( isset($_GET['rsltcd']) ) { if( '000' == substr($_GET['rsltcd'], 0, 3) ) { $results[0] = 1; $results['reg_order'] = true; } else { $results[0] = 0; $results['reg_order'] = false; } } else { $results[0] = 0; $results['reg_order'] = false; } break; //20130225ysk end default: do_action( 'usces_action_check_acting_return_default' ); $results = $_GET; if( $_REQUEST['result'] ){ usces_log($acting.' entry data : '.print_r($entry, true), 'acting_transaction.log'); $results[0] = 1; }else{ usces_log($acting.' error : '.print_r($_REQUEST,true), 'acting_transaction.log'); $results[0] = 0; } //20110310ysk start //$results['reg_order'] = false; $results['reg_order'] = true; //20110310ysk end break; } return $results; } //20110203ysk start function usces_check_acting_return_duplicate( $results = array() ) { global $wpdb; $acting = isset($_GET['acting']) ? $_GET['acting'] : ''; // usces_log('$_REQUEST : '.print_r($_REQUEST,true), 'acting_transaction.log'); // usces_log('$results : '.print_r($results,true), 'acting_transaction.log'); switch($acting) { case 'epsilon': $trans_id = isset($_REQUEST['trans_code']) ? $_REQUEST['trans_code'] : ''; break; //20110208ysk start case 'paypal': $trans_id = isset($results['txn_id']) ? $results['txn_id'] : ''; break; //20110208ysk end case 'paypal_ipn': $trans_id = isset($_REQUEST['txn_id']) ? $_REQUEST['txn_id'] : ''; break; //20110208ysk start case 'paypal_ec': $trans_id = isset($_REQUEST['token']) ? $_REQUEST['token'] : ''; break; //20110208ysk end case 'zeus_card': $trans_id = isset($_REQUEST['ordd']) ? $_REQUEST['ordd'] : ''; break; case 'zeus_conv': case 'zeus_bank': $trans_id = isset($_REQUEST['order_no']) ? $_REQUEST['order_no'] : ''; break; case 'remise_card': $trans_id = isset($_REQUEST['X-TRANID']) ? $_REQUEST['X-TRANID'] : ''; break; case 'remise_conv': $trans_id = isset($_REQUEST['X-JOB_ID']) ? $_REQUEST['X-JOB_ID'] : ''; break; case 'jpayment_card': case 'jpayment_conv': case 'jpayment_bank': $trans_id = isset($_REQUEST['gid']) ? $_REQUEST['gid'] : ''; break; //20120413ysk start case 'sbps_card': case 'sbps_conv': case 'sbps_payeasy': case 'sbps_wallet': case 'sbps_mobile': $trans_id = isset($_REQUEST['order_id']) ? $_REQUEST['order_id'] : ''; break; //20120413ysk end //20120618ysk start case 'telecom_card': $trans_id = isset($_REQUEST['sendid']) ? $_REQUEST['sendid'] : ''; break; //20120618ysk end //20121206ysk start case 'digitalcheck_card': case 'digitalcheck_conv': $trans_id = isset($_REQUEST['SID']) ? $_REQUEST['SID'] : ''; break; //20121206ysk end //20130225ysk start case 'mizuho_card': case 'mizuho_conv': $trans_id = isset($_REQUEST['stran']) ? $_REQUEST['stran'] : ''; break; //20130225ysk end default: $trans_id = ''; } $table_meta_name = $wpdb->prefix.'usces_order_meta'; $query = $wpdb->prepare("SELECT order_id FROM $table_meta_name WHERE meta_key = %s AND meta_value = %s", 'trans_id', $trans_id); $order_id = $wpdb->get_var($query); return $order_id; } //20110203ysk end //20111111ysk start function usces_dates_interconv( $date_str ) { $base_struc = preg_split('[/.-]', 'd/m/Y' ); $date_str_parts = preg_split('[/.-]', $date_str ); $date_elements = array(); $p_keys = array_keys( $base_struc ); foreach( $p_keys as $p_key ) { if( !empty( $date_str_parts[$p_key] )) { $date_elements[$base_struc[$p_key]] = $date_str_parts[$p_key]; } else { return false; } } $dummy_ts = mktime( 0,0,0, $date_elements['m'],$date_elements['d'],$date_elements['Y']); return date( 'Y-m-d', $dummy_ts ); } //20101111ysk end function usces_register_action($handle, $type, $key, $value, $function){ global $usces_action; $usces_action[$handle] = array('type'=>$type, 'key'=>$key, 'value'=>$value, 'function'=>$function); } function usces_deregister_action($handle){ global $usces_action; unset($usces_action[$handle]); } function usces_get_wcexp($post_id, $name=''){ $wcexp = get_post_meta($post_id, '_wcexp', true); if( empty($name) ){ $value = ( $wcexp !== false ) ? $wcexp : ''; }else{ $value = ($wcexp !== false && isset($wcexp[$name])) ? $wcexp[$name] : ''; } return $value; } function usces_update_check_admin($result){ $result = true; return $result; } function usces_setup_cod_ajax(){ global $usces; $usces->options = get_option('usces'); $message = ''; $_POST = $usces->stripslashes_deep_post($_POST); $usces->options['cod_type'] = isset($_POST['cod_type']) ? $_POST['cod_type'] : 'fix'; if( isset($_POST['cod_fee']) ) $usces->options['cod_fee'] = (int)$_POST['cod_fee']; if( 'fix' == $usces->options['cod_type'] ){ if( isset($_POST['cod_limit_amount']) ){ $usces->options['cod_limit_amount'] = (int)$_POST['cod_limit_amount']; if( !WCUtils::is_blank($_POST['cod_limit_amount']) && 0 === (int)$_POST['cod_limit_amount'] ) $message = __('There is the item where a value is dirty.', 'usces'); } }elseif( 'change' == $usces->options['cod_type'] ){ if( isset($_POST['cod_first_amount']) ){ $usces->options['cod_first_amount'] = (int)$_POST['cod_first_amount']; if( 0 === (int)$_POST['cod_first_amount'] ) $message = __('There is the item where a value is dirty.', 'usces'); } if( isset($_POST['cod_limit_amount']) ){ $usces->options['cod_limit_amount'] = (int)$_POST['cod_limit_amount']; if( !WCUtils::is_blank($_POST['cod_limit_amount']) && 0 === (int)$_POST['cod_limit_amount'] ) $message = __('There is the item where a value is dirty.', 'usces'); } if( isset($_POST['cod_first_fee']) ){ $usces->options['cod_first_fee'] = (int)$_POST['cod_first_fee']; if( 0 === (int)$_POST['cod_first_fee'] && '0' !== $_POST['cod_first_fee']) $message = __('There is the item where a value is dirty.', 'usces'); } if( isset($_POST['cod_end_fee']) ){ $usces->options['cod_end_fee'] = (int)$_POST['cod_end_fee']; if( 0 === (int)$_POST['cod_end_fee'] && '0' !== $_POST['cod_end_fee'] ) $message = __('There is the item where a value is dirty.', 'usces'); } unset($usces->options['cod_amounts'], $usces->options['cod_fees']); if( isset($_POST['cod_amounts']) ){ for($i=0; $ioptions['cod_amounts'][$i] = (int)$_POST['cod_amounts'][$i]; $usces->options['cod_fees'][$i] = (int)$_POST['cod_fees'][$i]; if( 0 === (int)$_POST['cod_amounts'][$i] || (0 === (int)$_POST['cod_fees'][$i] && '0' !== $_POST['cod_fees'][$i]) ) $message = __('There is the item where a value is dirty.', 'usces'); } } } if( '' == $message ){ $r = 'success'; update_option('usces', $usces->options); }else{ $r = '' . $message . ''; } die( $r ); } function usces_get_order_acting_data($rand){ global $wpdb; $table_name = $wpdb->prefix . "usces_access"; $query = $wpdb->prepare("SELECT acc_str1 AS sesid, acc_value AS order_data FROM $table_name WHERE acc_key = %s", $rand); $res = $wpdb->get_row($query, ARRAY_A); if($res == NULL){ return false; }else{ return $res; } } function usces_auth_order_acting_data($rand){ global $usces, $wpdb; $datas = usces_get_order_acting_data($rand); $data = unserialize($datas['order_data']); usces_log('usces_auth_order_acting_data', 'acting_transaction.log'); $data['propriety'] = 1; $data = serialize($data); $table_name = $wpdb->prefix . "usces_access"; $query = $wpdb->prepare("UPDATE $table_name SET acc_value = %s WHERE acc_type = %s AND acc_key = %s", $data, 'acting_data', $rand ); $res = $wpdb->query($query); } function usces_ordered_acting_data($rand){ global $usces, $wpdb; $datas = usces_get_order_acting_data($rand); $data = unserialize($datas['order_data']); usces_log('usces_ordered_acting_data', 'acting_transaction.log'); $data['order_received'] = 1; $data = serialize($data); $table_name = $wpdb->prefix . "usces_access"; $query = $wpdb->prepare("UPDATE $table_name SET acc_value = %s WHERE acc_type = %s AND acc_key = %s", $data, 'acting_data', $rand ); $res = $wpdb->query($query); } function usces_is_trusted_acting_data($rand){ global $usces, $wpdb; $datas = usces_get_order_acting_data($rand); $data = unserialize($datas['order_data']); usces_log('usces_is_trusted_acting_data', 'acting_transaction.log'); if( isset($data['propriety']) && $data['propriety'] && !isset($data['order_received']) ) return true; else return false; } function usces_get_filename( $path ){ $res = array(); if ( $handle = opendir($path) ) { while (false !== ($file = readdir($handle))) { if( '.' != $file && '..' != $file ) $res[] = $file; } closedir($handle); } return $res; } function usces_locales(){ $res = array(); if ( $handle = opendir(USCES_PLUGIN_DIR.'/languages/') ) { while (false !== ($file = readdir($handle))) { if( '.' != $file && '..' != $file && preg_match('/^usces-(.+)\.mo$/', $file, $matches) ){ $res[] = $matches[1]; } } closedir($handle); } return $res; } function usces_get_local_language(){ $locale = get_locale(); switch( $locale ){ case '': case 'en': case 'en_US': $front_lang = 'en'; break; case 'ja': case 'ja_JP': $front_lang = 'ja'; break; default: $front_lang = 'others'; } return $front_lang; } function usces_get_base_country(){ global $usces_settings; // $locale = get_locale(); $wplang = defined('WPLANG') ? WPLANG : ''; $locale = empty( $wplang ) ? 'en' : $wplang; if( array_key_exists($locale, $usces_settings['lungage2country']) ) return $usces_settings['lungage2country'][$locale]; else return 'US'; } function usces_get_local_addressform(){ global $usces_settings; $base = usces_get_base_country(); if( array_key_exists($base, $usces_settings['addressform']) ) return $usces_settings['addressform'][$base]; else return 'US'; } function usces_get_local_target_market(){ $base = usces_get_base_country(); return (array)$base; } function usces_get_apply_addressform($country){ global $usces_settings; return $usces_settings['addressform'][$country]; } function usces_remove_filter(){ global $usces, $post; if( is_single() && 'item' == $post->post_mime_type ) { remove_filter('the_content', array(&$usces, 'filter_itemPage')); }else if( $usces->is_cart_page($_SERVER['REQUEST_URI']) || $usces->is_inquiry_page($_SERVER['REQUEST_URI']) ){ remove_action('the_post', array(&$usces, 'action_cartFilter')); remove_filter('the_title', array(&$usces, 'filter_cartTitle'),20); remove_filter('the_content', array(&$usces, 'filter_cartContent'),20); }else if( $usces->is_member_page($_SERVER['REQUEST_URI']) ){ remove_action('the_post', array(&$usces, 'action_memberFilter')); remove_filter('the_title', array(&$usces, 'filter_memberTitle'),20); remove_filter('the_content', array(&$usces, 'filter_memberContent'),20); }else{ remove_action('the_post', array(&$usces, 'goDefaultPage')); } } function usces_reset_filter(){ global $usces, $post; if( is_single() && 'item' == $post->post_mime_type ) { add_filter('the_content', array(&$usces, 'filter_itemPage')); }else if( $usces->is_cart_page($_SERVER['REQUEST_URI']) || $usces->is_inquiry_page($_SERVER['REQUEST_URI']) ){ add_action('the_post', array(&$usces, 'action_cartFilter')); add_filter('the_title', array(&$usces, 'filter_cartTitle'),20); add_filter('the_content', array(&$usces, 'filter_cartContent'),20); }else if( $usces->is_member_page($_SERVER['REQUEST_URI']) ){ add_action('the_post', array(&$usces, 'action_memberFilter')); add_filter('the_title', array(&$usces, 'filter_memberTitle'),20); add_filter('the_content', array(&$usces, 'filter_memberContent'),20); }else{ add_action('the_post', array(&$usces, 'goDefaultPage')); } } function usces_get_wcex(){ $wcex = array(); if( defined('WCEX_DLSELLER_VERSION')) $wcex['DLSELLER'] = array('name'=>'Dl Seller', 'version'=>WCEX_DLSELLER_VERSION); if( defined('WCEX_ITEM_LIST_LAYOUT_VERSION')) $wcex['ITEM_LIST_LAYOUT'] = array('name'=>'Item List Layout', 'version'=>WCEX_ITEM_LIST_LAYOUT_VERSION); if( defined('WCEX_MOBILE_VERSION')) $wcex['MOBILE'] = array('name'=>'Mobile', 'version'=>WCEX_MOBILE_VERSION); if( defined('WCEX_MULTIPRICE_VERSION')) $wcex['MULTIPRICE'] = array('name'=>'Multi Price', 'version'=>WCEX_MULTIPRICE_VERSION); if( defined('WCEX_SLIDE_SHOWCASE_VERSION')) $wcex['SLIDE_SHOWCASE'] = array('name'=>'Slide Showcase', 'version'=>WCEX_SLIDE_SHOWCASE_VERSION); if( defined('WCEX_WIDGET_CART_VERSION')) $wcex['WIDGET_CART'] = array('name'=>'Widget Cart', 'version'=>WCEX_WIDGET_CART_VERSION); return $wcex; } function usces_trackPageview_cart($push){ $push = array(); if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_cart'"; }else{ $push[] = "'_trackPageview','/wc_cart'"; } return $push; } function usces_trackPageview_customer($push){ $push = array(); if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_customer'"; }else{ $push[] = "'_trackPageview','/wc_customer'"; } return $push; } function usces_trackPageview_delivery($push){ $push = array(); if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_delivery'"; }else{ $push[] = "'_trackPageview','/wc_delivery'"; } return $push; } function usces_trackPageview_confirm($push){ $push = array(); if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_confirm'"; }else{ $push[] = "'_trackPageview','/wc_confirm'"; } return $push; } function usces_trackPageview_ordercompletion($push){ global $usces; $sesdata = $usces->cart->get_entry(); $order_id = $sesdata['order']['ID']; $data = $usces->get_order_data($order_id, 'direct'); $cart = unserialize($data['order_cart']); $total_price = $usces->get_total_price( $cart ) - $data['order_discount']; if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_ordercompletion'"; }else{ $push[] = "'_trackPageview','/wc_ordercompletion'"; } $push[] = "'_addTrans', '" . $order_id . "', '" . get_option('blogname') . "', '" . $total_price . "', '" . $data['order_tax'] . "', '" . $data['order_shipping_charge'] . "', '" . $data['order_address1'].$data['order_address2'] . "', '" . $data['order_pref'] . "', '" . get_locale() . "'"; for($i=0; $icart->wc_serialize($cart_row['advance']); // $itemCode = $usces->getItemCode($post_id); $itemName = $usces->getItemName($post_id); // $cartItemName = $usces->getCartItemName($post_id, $sku); $skuPrice = $cart_row['price']; $cats = $usces->get_item_cat_genre_ids( $post_id ); if( is_array($cats) ) sort($cats); $category = get_cat_name( $cats[0] ); $push[] = "'_addItem', '" . $order_id . "', '" . $sku . "', '" . $itemName . "', '" . $category . "', '" . $skuPrice . "', '" . $quantity . "'"; } $push[] = "'_trackTrans'"; return $push; } function usces_trackPageview_error($push){ if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_error'"; }else{ $push[] = "'_trackPageview','/wc_error'"; } return $push; } function usces_trackPageview_member($push){ if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_member'"; }else{ $push[] = "'_trackPageview','/wc_member'"; } return $push; } function usces_trackPageview_login($push){ if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_login'"; }else{ $push[] = "'_trackPageview','/wc_login'"; } return $push; } function usces_trackPageview_editmemberform($push){ if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_editmemberform'"; }else{ $push[] = "'_trackPageview','/wc_editmemberform'"; } return $push; } function usces_trackPageview_newcompletion($push){ if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_newcompletion'"; }else{ $push[] = "'_trackPageview','/wc_newcompletion'"; } return $push; } function usces_trackPageview_newmemberform($push){ if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_newmemberform'"; }else{ $push[] = "'_trackPageview','/wc_newmemberform'"; } return $push; } function usces_trackPageview_deletemember($push){ if(defined('USCES_KEY') && defined('USCES_MULTI') && true == USCES_MULTI){ $push[] = "'_trackPageview','/" . USCES_KEY . "wc_deletemember'"; }else{ $push[] = "'_trackPageview','/wc_deletemember'"; } return $push; } function usces_get_essential_mark( $fielde, $data = NULL ){ global $usces_essential_mark; do_action('usces_action_essential_mark', $data, $fielde); return $usces_essential_mark[$fielde]; } function uesces_get_admin_addressform( $type, $data, $customdata, $out = 'return' ){ global $usces, $usces_settings; $options = get_option('usces'); $applyform = usces_get_apply_addressform($options['system']['addressform']); $formtag = ''; switch( $type ){ case 'member': $values = array('name1'=>$data['mem_name1'], 'name2'=>$data['mem_name2'], 'name3'=>$data['mem_name3'], 'name4'=>$data['mem_name4'], 'zipcode'=>$data['mem_zip'], 'address1'=>$data['mem_address1'], 'address2'=>$data['mem_address2'], 'address3'=>$data['mem_address3'], 'tel'=>$data['mem_tel'], 'fax'=>$data['mem_fax'], 'pref'=>$data['mem_pref']); $country = $usces->get_member_meta_value('customer_country', $data['ID']); $values['country'] = !empty($country) ? $country : usces_get_local_addressform(); break; case 'customer': $values = array('name1'=>$data['order_name1'], 'name2'=>$data['order_name2'], 'name3'=>$data['order_name3'], 'name4'=>$data['order_name4'], 'zipcode'=>$data['order_zip'], 'address1'=>$data['order_address1'], 'address2'=>$data['order_address2'], 'address3'=>$data['order_address3'], 'tel'=>$data['order_tel'], 'fax'=>$data['order_fax'], 'pref'=>$data['order_pref']); $country = $usces->get_order_meta_value('customer_country', $data['ID']); $values['country'] = !empty($country) ? $country : usces_get_local_addressform(); break; case 'delivery': $values = $data; break; } switch ($applyform){ case 'JP': //20100818ysk start $formtag .= usces_admin_custom_field_input($customdata, $type, 'name_pre', 'return'); //20100818ysk end $formtag .= ' ' . __('name', 'usces') . ' ' . __('furigana', 'usces') . ' '; //20100818ysk start $formtag .= usces_admin_custom_field_input($customdata, $type, 'name_after', 'return'); //20100818ysk end $formtag .= ' ' . __('Zip/Postal Code', 'usces') . ' '.apply_filters('usces_filter_admin_addressform_zipcode', NULL, $type).' ' . __('Country', 'usces') . ' ' . uesces_get_target_market_form( $type, $values['country'] ) . ' ' . __('Province', 'usces') . ' '; $formtag .= usces_pref_select( $type, $values ); $formtag .= ' '; $formtag .= ' ' . __('city', 'usces') . ' ' . __('numbers', 'usces') . ' ' . __('building name', 'usces') . ' ' . __('Phone number', 'usces') . ' ' . __('FAX number', 'usces') . ' '; //20100818ysk start $formtag .= usces_admin_custom_field_input($customdata, $type, 'fax_after', 'return'); //20100818ysk end break; case 'CN': $formtag .= usces_admin_custom_field_input($customdata, $type, 'name_pre', 'return'); $formtag .= ' ' . __('name', 'usces') . ' '; $formtag .= usces_admin_custom_field_input($customdata, $type, 'name_after', 'return'); $formtag .= ' ' . __('Country', 'usces') . ' ' . uesces_get_target_market_form( $type, $values['country'] ) . ' ' . __('State', 'usces') . ' '; $formtag .= usces_pref_select( $type, $values ); $formtag .= ' '; $formtag .= ' ' . __('city', 'usces') . ' ' . __('Address Line1', 'usces') . ' ' . __('Address Line2', 'usces') . ' ' . __('Zip', 'usces') . ' ' . __('Phone number', 'usces') . ' ' . __('FAX number', 'usces') . ' '; $formtag .= usces_admin_custom_field_input($customdata, $type, 'fax_after', 'return'); break; case 'US': default: //20100818ysk start $formtag .= usces_admin_custom_field_input($customdata, $type, 'name_pre', 'return'); //20100818ysk end $formtag .= ' ' . __('name', 'usces') . ' '; //20100818ysk start $formtag .= usces_admin_custom_field_input($customdata, $type, 'name_after', 'return'); //20100818ysk end $formtag .= ' ' . __('Address Line1', 'usces') . ' ' . __('Address Line2', 'usces') . ' ' . __('city', 'usces') . ' ' . __('State', 'usces') . ' '; $formtag .= usces_pref_select( $type, $values ); $formtag .= ' '; $formtag .= ' ' . __('Country', 'usces') . ' ' . uesces_get_target_market_form( $type, $values['country'] ) . ' ' . __('Zip', 'usces') . ' ' . __('Phone number', 'usces') . ' ' . __('FAX number', 'usces') . ' '; //20100818ysk start $formtag .= usces_admin_custom_field_input($customdata, $type, 'fax_after', 'return'); //20100818ysk end break; } $res = apply_filters('usces_filter_apply_admin_addressform', $formtag, $type, $data, $customdata); if($out == 'return') { return $res; } else { echo $res; } } function uesces_get_mail_addressform( $type, $data, $order_id, $out = 'return' ){ global $usces, $usces_settings; $options = get_option('usces'); $applyform = usces_get_apply_addressform($options['system']['addressform']); $formtag = ''; switch( $type ){ case 'admin_mail_customer': $values = $data; $values['country'] = !empty($values['country']) ? $values['country'] : usces_get_local_addressform(); $mode = 'customer'; $name_label = __('Buyer','usces'); break; case 'admin_mail': $values = $data; $values['country'] = !empty($values['country']) ? $values['country'] : usces_get_local_addressform(); $mode = 'delivery'; $name_label = __('A destination name','usces'); break; case 'order_mail_customer': $values = $data['customer']; $values['country'] = !empty($values['country']) ? $values['country'] : usces_get_local_addressform(); $mode = 'customer'; $name_label = __('Buyer','usces'); break; case 'order_mail': $values = $data['delivery']; $values['country'] = !empty($values['country']) ? $values['country'] : usces_get_local_addressform(); $mode = 'delivery'; $name_label = __('A destination name','usces'); break; } switch ($applyform){ case 'JP': //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'name_pre', $order_id ); //20110118ysk end $formtag .= $name_label . "\t\t: " . sprintf(__('Mr/Mrs %s', 'usces'), ($values['name1'] . ' ' . $values['name2'])) . " \r\n"; if( !empty($values['name3']) || !empty($values['name4']) ) { $formtag .= __('furigana','usces') . "\t\t: " . $values['name3'] . ' ' . $values['name4'] . " \r\n"; } //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'name_after', $order_id ); //20110118ysk end $formtag .= __('Country','usces') . "\t\t\t: " . $usces_settings['country'][$values['country']] . "\r\n"; $formtag .= __('Zip/Postal Code','usces') . "\t\t: " . $values['zipcode'] . "\r\n"; $formtag .= __('Address','usces') . "\t\t\t: " . $values['pref'] . $values['address1'] . $values['address2'] . " " . $values['address3'] . "\r\n"; $formtag .= __('Phone number','usces') . "\t\t: " . $values['tel'] . "\r\n"; $formtag .= __('FAX number','usces') . "\t\t: " . $values['fax'] . "\r\n"; //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'fax_after', $order_id ); //20110118ysk end break; case 'CN': //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'name_pre', $order_id ); //20110118ysk end $formtag .= $name_label . "\t\t: " . sprintf(__('Mr/Mrs %s', 'usces'), ($values['name1'] . ' ' . $values['name2'])) . " \r\n"; //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'name_after', $order_id ); //20110118ysk end $formtag .= __('Country','usces') . " : " . $usces_settings['country'][$values['country']] . "\r\n"; $formtag .= __('State','usces') . " : " . $values['pref'] . "\r\n"; $formtag .= __('City','usces') . " : " . $values['address1'] . "\r\n"; $formtag .= __('Address','usces') . " : " . $values['address2'] . " " . $values['address3'] . "\r\n"; $formtag .= __('Zip/Postal Code','usces') . " : " . $values['zipcode'] . "\r\n"; $formtag .= __('Phone number','usces') . " : " . $values['tel'] . "\r\n"; $formtag .= __('FAX number','usces') . " : " . $values['fax'] . "\r\n"; //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'fax_after', $order_id ); //20110118ysk end break; case 'US': default: //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'name_pre', $order_id ); //20110118ysk end $formtag .= $name_label . " : " . sprintf(__('Mr/Mrs %s', 'usces'), ($values['name2'] . ' ' . $values['name1'])) . " \r\n"; //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'name_after', $order_id ); //20110118ysk end $formtag .= __('Address','usces') . " : " . $values['address2'] . " " . $values['address3'] . "\r\n"; $formtag .= __('City','usces') . " : " . $values['address1'] . "\r\n"; $formtag .= __('State','usces') . " : " . $values['pref'] . "\r\n"; $formtag .= __('Country','usces') . " : " . $usces_settings['country'][$values['country']] . "\r\n"; $formtag .= __('Zip/Postal Code','usces') . " : " . $values['zipcode'] . "\r\n"; $formtag .= __('Phone number','usces') . " : " . $values['tel'] . "\r\n"; $formtag .= __('FAX number','usces') . " : " . $values['fax'] . "\r\n"; //20110118ysk start $formtag .= usces_mail_custom_field_info( $mode, 'fax_after', $order_id ); //20110118ysk end break; } $res = apply_filters('usces_filter_apply_mail_addressform', $formtag, $type, $data, $order_id); if($out == 'return') { return $res; } else { echo $res; } } function uesces_get_target_market_form( $type, $selected, $out = 'return' ){ global $usces_settings; $options = get_option('usces'); $res = ''."\n"; if($out == 'return') { return $res; } else { echo $res; } } function usces_pref_select( $type, $values, $out = 'return' ){ global $usces, $usces_states; //20110513ysk start //$country = empty($values['country']) ? usces_get_local_addressform() : $values['country']; $country = empty($values['country']) ? usces_get_base_country() : $values['country']; $options = get_option('usces'); if( !in_array($country, $options['system']['target_market']) ) $country = $options['system']['target_market'][0]; //20110513ysk end //20110331ysk start //$prefs = $usces_states[$country]; $prefs = get_usces_states($country); //20110331ysk end $html = '\n"; if( $out == 'return' ){ return $html; }else{ echo $html; } } function usces_is_member_system(){ global $usces; if($usces->options['membersystem_state'] == 'activate') return true; else return false; } function usces_is_member_system_point(){ global $usces; if($usces->options['membersystem_point'] == 'activate') return true; else return false; } function usces_shipping_country_option( $selected, $out = '' ){ global $usces_settings; $options = get_option('usces'); $res = ''; foreach ( $usces_settings['country'] as $key => $value ){ if( in_array($key, $options['system']['target_market']) ) $res .= '\n"; } //20110317ysk start //$res .= '\n"; //20110317ysk end echo $res; } function usces_get_cart_button( $out = '' ) { global $usces; $res = ''; if($usces->use_js){ $res .= '  '; if( usces_is_cart() ) { $res .= ''; } }else{ $res .= '' . __('continue shopping','usces') . '  '; if( usces_is_cart() ) { $res .= ''; } } $res = apply_filters('usces_filter_get_cart_button', $res); if($out == 'return'){ return $res; }else{ echo $res; } } function usces_get_customer_button( $out = '' ) { global $usces, $member_regmode; $res = ''; $res = '  '; $button = '  '; $res .= apply_filters('usces_filter_customer_button', $button); if(usces_is_membersystem_state() && $member_regmode != 'editmemberfromcart' && usces_is_login() == false ){ $res .= ''; }elseif(usces_is_membersystem_state() && $member_regmode == 'editmemberfromcart' ){ $res .= ''; } $res = apply_filters('usces_filter_get_customer_button', $res); if($out == 'return'){ return $res; }else{ echo $res; } } function usces_delivery_secure_form( $out = '' ) { global $usces, $usces_entries, $usces_carts; $html = ''; include( USCES_PLUGIN_DIR . "/includes/delivery_secure_form.php"); if($out == 'return'){ return $html; }else{ echo $html; } } function usces_delivery_info_script( $out ='' ){ global $usces, $usces_entries, $usces_carts; $html = ''; include( USCES_PLUGIN_DIR . "/includes/delivery_info_script.php"); if($out == 'return'){ return $html; }else{ echo $html; } } function usces_get_entries(){ global $usces, $usces_entries; $usces_entries = $usces->cart->get_entry(); } function usces_get_carts(){ global $usces, $usces_carts; $usces_carts = $usces->cart->get_cart(); } function usces_get_members(){ global $usces, $usces_members; $usces_members = $usces->get_member(); } function usces_error_message( $out = ''){ global $usces; if($out == 'return'){ return $usces->error_message; }else{ echo $usces->error_message; } } function usces_url( $type, $out = ''){ global $usces; switch ( $type ){ case 'cart': $url = USCES_CART_URL; break; case 'login': $url = USCES_LOGIN_URL; break; case 'member': $url = USCES_MEMBER_URL; break; case 'newmember': $url = USCES_NEWMEMBER_URL; break; case 'lostmemberpassword': $url = USCES_LOSTMEMBERPASSWORD_URL; break; case 'cartnonsession': $url = USCES_CART_NONSESSION_URL; break; } if($out == 'return'){ return $url; }else{ echo $url; } } function usces_total_price( $out = ''){ global $usces; if($out == 'return'){ return $usces->get_total_price(); }else{ echo $usces->get_total_price(); } } function usces_completion_settlement( $out ='' ){ global $usces, $usces_entries; $html = ''; $template = apply_filters( 'usces_filter_completion_settlement', USCES_PLUGIN_DIR . "/includes/completion_settlement.php", $usces_entries ); require( $template ); if($out == 'return'){ return $html; }else{ echo $html; } } function usces_purchase_button( $out ='' ){ global $usces, $usces_entries; $html = ''; include( USCES_PLUGIN_DIR . "/includes/purchase_button.php"); if($out == 'return'){ return $html; }else{ echo $html; } } function usces_get_member_regmode(){ global $member_regmode; $member_regmode = isset( $_SESSION['usces_entry']['member_regmode'] ) ? $_SESSION['usces_entry']['member_regmode'] : 'none'; } function uesces_get_error_settlement( $out = '' ) { $res = ''; if( isset($_REQUEST['acting']) && ('zeus_conv' == $_REQUEST['acting'] || 'zeus_card' == $_REQUEST['acting'] || 'zeus_bank' == $_REQUEST['acting'] ) ){ //ZEUS $res .= '
'; if( isset($_GET['code']) ){ $res .= '　
エラーコード：' . esc_html($_GET['code']); if( in_array($_GET['code'], array('02130514', '02130517', '02130619', '02130620', '02130621', '02130640')) ){ $res .= '
カード番号が正しくないようです。'; }elseif( in_array($_GET['code'], array('02130714', '02130717', '02130725', '02130814', '02130817', '02130825')) ){ $res .= '
カードの有効期限が正しくないようです。'; }elseif( in_array($_GET['code'], array('02130922')) ){ $res .= '
カードの有効期限が切れているようです。'; }elseif( in_array($_GET['code'], array('02131117', '02131123', '02131124')) ){ $res .= '
カードの名義が正しくないようです。'; }elseif( in_array($_GET['code'], array('02131414', '02131417', '02131437')) ){ $res .= '
お客様情報の電話番号が正しくないようです。'; }elseif( in_array($_GET['code'], array('02131527', '02131528', '02131529', '02131537')) ){ $res .= '
お客様情報のEメールアドレスが正しくないようです。'; } $res .= '　
　
もう一度決済を行う＞＞
'; }else{ $res .= '　
エラーコード：' . esc_html($_GET['err_code']); $res .= '　
カード番号を再入力する場合はこちらをクリックしてください。
　
カード番号の再入力＞＞
'; } $res .= '　
ゼウス・カスタマーサポート(24時間365日)
電話番号：0570-02-3939(つながらないときは 03-4334-0500)
E-mail:support@cardservice.co.jp
'."\n"; } $res = apply_filters( 'usces_filter_get_error_settlement', $res ); if($out == 'return'){ return $res; }else{ echo $res; } } function usces_page_name( $out = '') { global $usces; $page = ''; if( empty($usces->page) ){ if( $usces->is_cart_page($_SERVER['REQUEST_URI']) ){ $page = 'cart'; }elseif( $usces->is_member_page($_SERVER['REQUEST_URI']) ){ $page = 'member'; } }else{ $page = $usces->page; } if($out == 'return'){ return $page; }else{ echo $page; } } function usces_post_reg_orderdata($order_id, $results){ global $usces, $wpdb; //$entry = $usces->cart->get_entry();//20110621ysk 0000184 $acting = isset($_GET['acting']) ? $_GET['acting'] : ''; $data = array(); if( $order_id ){ switch ( $acting ) { case 'epsilon': $trans_id = isset($_REQUEST['trans_code']) ? $_REQUEST['trans_code'] : ''; break; case 'paypal_ipn': $trans_id = isset($_REQUEST['txn_id']) ? $_REQUEST['txn_id'] : ''; break; case 'paypal': $trans_id = isset($results['txn_id']) ? $results['txn_id'] : ''; break; //20110208ysk start case 'paypal_ec': $trans_id = isset($_REQUEST['token']) ? $_REQUEST['token'] : ''; //20110621ysk start 0000184 if(isset($results['settlement_id'])) $usces->set_order_meta_value('settlement_id', $results['settlement_id'], $order_id); if(isset($results['profile_id'])) $usces->set_order_meta_value('profile_id', $results['profile_id'], $order_id); //20110621ysk end break; //20110208ysk end case 'zeus_card': $acting_opts = $usces->options['acting_settings']['zeus']; if( isset($_GET['zeussuffix']) ){ $data['acting'] = 'zeus_card Secure API'; $data['order_number'] = $_GET['zeusordd']; $usces->set_order_meta_value('acting_'.$acting, serialize($data), $order_id); if( $usces->is_member_logged_in() ){ //if( 2 == $acting_opts['security'] && 'on' == $acting_opts['quickcharge']){ if( 'on' == $acting_opts['quickcharge']){ $usces->set_member_meta_value('zeus_pcid', '8888888888888888'); } $usces->set_member_meta_value('zeus_partofcard', $_GET['zeussuffix']); $usces->set_member_meta_value('zeus_limitofcard', ($_GET['zeusyear'].'/'.$_GET['zeusmonth'])); } }else{ $trans_id = isset($_REQUEST['ordd']) ? $_REQUEST['ordd'] : ''; //foreach($_GET as $key => $value) { // $data[$key] = mysql_real_escape_string($value); //} //$usces->set_order_meta_value('acting_'.$acting, serialize($data), $order_id); if( !empty($_REQUEST['order_number']) ) { $usces->set_order_meta_value( 'order_number', $_REQUEST['order_number'], $order_id ); } if( $usces->is_member_logged_in() ) { if( 'on' == $acting_opts['quickcharge'] ) { $usces->set_member_meta_value('zeus_pcid', '8888888888888888'); } } } if(empty($usces)){ usces_log('zeus card transaction : No Session', 'acting_transaction.log'); }else{ usces_log('zeus card transaction : OK', 'acting_transaction.log'); } break; case 'zeus_conv': $trans_id = isset($_REQUEST['order_no']) ? $_REQUEST['sendpoint'] : ''; $zeus_convs = array( 'acting' => 'zeus_conv', 'pay_cvs' => isset($_REQUEST['pay_cvs']) ? $_REQUEST['pay_cvs'] : '', 'order_no' => isset($_REQUEST['order_no']) ? $_REQUEST['order_no'] : '', 'money' => isset($_REQUEST['money']) ? $_REQUEST['money'] : '', 'pay_no1' => isset($_REQUEST['pay_no1']) ? $_REQUEST['pay_no1'] : '', 'pay_no2' => isset($_REQUEST['pay_no2']) ? $_REQUEST['pay_no2'] : '', 'pay_limit' => isset($_REQUEST['pay_limit']) ? $_REQUEST['pay_limit'] : '', 'status' => isset($_REQUEST['status']) ? $_REQUEST['status'] : '', 'error_code' => isset($_REQUEST['error_code']) ? $_REQUEST['error_code'] : '' ); $usces->set_order_meta_value('acting_'.(isset($_REQUEST['sendpoint']) ? $_REQUEST['sendpoint'] : ''), serialize($zeus_convs), $order_id); break; case 'zeus_bank': $trans_id = isset($_REQUEST['order_no']) ? $_REQUEST['order_no'] : ''; break; case 'remise_card': $trans_id = isset($_REQUEST['X-TRANID']) ? $_REQUEST['X-TRANID'] : ''; break; case 'remise_conv': $trans_id = isset($_REQUEST['X-JOB_ID']) ? $_REQUEST['X-JOB_ID'] : ''; break; case 'jpayment_card': case 'jpayment_conv': case 'jpayment_bank': $trans_id = isset($_REQUEST['gid']) ? $_REQUEST['gid'] : ''; break; //20120413ysk start case 'sbps_card': case 'sbps_conv': case 'sbps_payeasy': case 'sbps_wallet': case 'sbps_mobile': $trans_id = isset($_REQUEST['order_id']) ? $_REQUEST['order_id'] : ''; break; //20120413ysk end //20120618ysk start case 'telecom_card': $trans_id = isset($_REQUEST['sendid']) ? $_REQUEST['sendid'] : ''; break; //20120618ysk end //20121206ysk start case 'digitalcheck_card': case 'digitalcheck_conv': $trans_id = isset($_REQUEST['SID']) ? $_REQUEST['SID'] : ''; break; //20121206ysk end //20130225ysk start case 'mizuho_card': case 'mizuho_conv': $trans_id = isset($_REQUEST['stran']) ? $_REQUEST['stran'] : ''; break; //20130225ysk end default: if( isset($_REQUEST['FUKA']) && strstr($_REQUEST['FUKA'], "digitalcheck_card") ) { $trans_id = isset($_REQUEST['SID']) ? $_REQUEST['SID'] : ''; } else { $trans_id = ''; } } if(!empty($trans_id)) { $usces->set_order_meta_value('trans_id', $trans_id, $order_id); } } } //20110621ysk start 0000184 function usces_paypal_doecp( &$results ) { global $usces; $entry = $usces->cart->get_entry(); $cart = $usces->cart->get_cart(); $post_id = $cart[0]['post_id']; $charging_type = $usces->getItemChargingType( $post_id ); if( 'continue' != $charging_type ) { //通常購入 //Format the other parameters that were stored in the session from the previous calls $paymentAmount = usces_crform($entry['order']['total_full_price'], false, false, 'return', false); $token = urlencode($_REQUEST['token']); $paymentType = urlencode("Sale"); $currencyCodeType = urlencode($usces->get_currency_code()); $payerID = urlencode($_REQUEST['PayerID']); $serverName = urlencode($_SERVER['SERVER_NAME']); $nvpstr = '&TOKEN='.$token.'&PAYERID='.$payerID.'&PAYMENTACTION='.$paymentType.'&AMT='.$paymentAmount.'&CURRENCYCODE='.$currencyCodeType.'&IPADDRESS='.$serverName; $nvpstr = apply_filters( 'usces_filter_usces_paypal_doecp', $nvpstr, $charging_type ); $usces->paypal->setMethod('DoExpressCheckoutPayment'); $usces->paypal->setData($nvpstr); $res = $usces->paypal->doExpressCheckout(); $resArray = $usces->paypal->getResponse(); $ack = strtoupper($resArray["ACK"]); if($ack == "SUCCESS" || $ack == "SUCCESSWITHWARNING") { $transactionId = $resArray["TRANSACTIONID"]; // ' Unique transaction ID of the payment. Note: If the PaymentAction of the request was Authorization or Order, this value is your AuthorizationID for use with the Authorization & Capture APIs. //$usces->set_order_meta_value('settlement_id', $transactionId, $order_id); $results['settlement_id'] = $transactionId; } 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 : DoExpressCheckoutPayment API call failed. Error Code:['.$ErrorCode.'] Error Severity Code:['.$ErrorSeverityCode.'] Short Error Message:'.$ErrorShortMsg.' Detailed Error Message:'.$ErrorLongMsg, 'acting_transaction.log'); return false; } } else { //定期支払い //$paymentAmount = usces_crform($entry['order']['total_items_price'], false, false, 'return', false); $paymentAmount = usces_crform($entry['order']['total_full_price'], false, false, 'return', false);//20111129ysk 0000320 $token = urlencode($_REQUEST['token']); $currencyCodeType = urlencode($usces->get_currency_code()); //$nextdate = get_date_from_gmt(gmdate('Y-m-d H:i:s', time())); //$profileStartDate = date('Y-m-d', mktime(0,0,0,substr($nextdate, 5, 2)+1,$usces->getItemChargingDay($post_id),substr($nextdate, 0, 4))).'T01:01:01Z'; $profileStartDate = date('Y-m-d', dlseller_first_charging($post_id, 'time')).'T01:01:01Z'; $billingPeriod = "Month";// or "Day", "Week", "SemiMonth", "Year" $billingFreq = $usces->getItemFrequency($post_id); //$desc = urlencode(usces_make_agreement_description($cart, $entry['order']['total_items_price'])); $desc = urlencode(usces_make_agreement_description($cart, $entry['order']['total_full_price']));//20111125ysk 0000320 $totalBillingCycles = (empty($dlitem['dlseller_interval'])) ? '' : '&TOTALBILLINGCYCLES='.urlencode($dlitem['dlseller_interval']); //$totalBillingCycles = ( dlseller_auto_stop() ) ? '&TOTALBILLINGCYCLES='.dlseller_cycles( $post_id ) : ''; //$nvpstr = '&TOKEN='.$token.'&AMT='.$paymentAmount.'&CURRENCYCODE='.$currencyCodeType.'&PROFILESTARTDATE='.$profileStartDate.'&BILLINGPERIOD='.$billingPeriod.'&BILLINGFREQUENCY='.$billingFreq.'&DESC='.$desc; $nvpstr = '&TOKEN='.$token.'&AMT='.$paymentAmount.'&CURRENCYCODE='.$currencyCodeType.'&PROFILESTARTDATE='.$profileStartDate.'&BILLINGPERIOD='.$billingPeriod.'&BILLINGFREQUENCY='.$billingFreq.'&DESC='.$desc.$totalBillingCycles; $nvpstr = apply_filters( 'usces_filter_usces_paypal_doecp', $nvpstr, $charging_type ); $usces->paypal->setMethod('CreateRecurringPaymentsProfile'); $usces->paypal->setData($nvpstr); $res = $usces->paypal->doExpressCheckout(); $resArray = $usces->paypal->getResponse(); $ack = strtoupper($resArray["ACK"]); if($ack == "SUCCESS" || $ack == "SUCCESSWITHWARNING") { $profileid = $resArray["PROFILEID"]; //$usces->set_order_meta_value('profile_id', $profileid, $order_id); $results['settlement_id'] = $profileid; $results['profile_id'] = $profileid; } 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 : CreateRecurringPaymentsProfile API call failed. Error Code:['.$ErrorCode.'] Error Severity Code:['.$ErrorSeverityCode.'] Short Error Message:'.$ErrorShortMsg.' Detailed Error Message:'.$ErrorLongMsg, 'acting_transaction.log'); return false; } } return true; } //20110621ysk end //20110421ysk start function usces_make_agreement_description($cart, $amt) { global $usces; $cart_row = $cart[0]; $quantity = $cart_row['quantity']; $itemName = $usces->getItemName($cart_row['post_id']); //if(1 < count($cart)) $itemName .= ','.__('Others', 'usces'); if(50 < mb_strlen($itemName)) $itemName = mb_substr($itemName, 0, 50).'...'; $amt = usces_crform($amt, true, false, 'return', true); $desc = $itemName.' '.__('Quantity','usces').':'.$quantity.' '.$amt; return($desc); } //20110421ysk end function usces_get_send_out_date(){ global $usces; $bus_day_arr = (isset($usces->options['business_days'])) ? $usces->options['business_days'] : false; list( $today_year, $today_month, $today_day, $hour, $minute, $second ) = preg_split( '([^0-9])', current_time('mysql') ); if( !is_array($bus_day_arr) ){ $today_bus_flag = 1; }else{ $today_bus_flag = isset($bus_day_arr[(int)$today_year][(int)$today_month][(int)$today_day]) ? (int)$bus_day_arr[(int)$today_year][(int)$today_month][(int)$today_day] : 1; } // get the time limit addition $limit_hour = (!empty($usces->options['delivery_time_limit']['hour'])) ? $usces->options['delivery_time_limit']['hour'] : false; $limit_min = (!empty($usces->options['delivery_time_limit']['min'])) ? $usces->options['delivery_time_limit']['min'] : false; if( false === $hour || false === $minute ){ $time_limit_addition = false; }elseif( ($hour.':'.$minute.':'.$second) > ($limit_hour.':'.$limit_min.':00') ){ $time_limit_addition = 1; }else{ $time_limit_addition = 0; } // get the shipping indication in cart $cart = $usces->cart->get_cart(); $shipping_indication = apply_filters('usces_filter_shipping_indication', $usces->options['usces_shipping_indication']); $shipping = 0; $indication_flag = true; for($i = 0; $i < count($cart); $i++) { $cart_row = $cart[$i]; $post_id = $cart_row['post_id']; $itemShipping = (int)$usces->getItemShipping($post_id); if($itemShipping === 0 or $itemShipping === 9) { $indication_flag = false; break; } if($shipping < $itemShipping) $shipping = $itemShipping; } $indication_incart = ( $indication_flag ) ? $shipping_indication[$shipping] : false; // get the send out date $sendout_num = 0; if( $today_bus_flag ){ if( $time_limit_addition ){ $sendout_num += 1; } if( false !== $indication_incart ){ $sendout_num += $indication_incart; } }else{ if( false !== $indication_incart ){ $sendout_num += $indication_incart; } } $holiday = 0; for( $i=0; $i<=$sendout_num; $i++ ){ list($yyyy, $mm, $dd) = explode('-', date('Y-m-d', mktime(0,0,0,(int)$today_month,($today_day + $i),(int)$today_year))); if( isset($bus_day_arr[(int)$yyyy][(int)$mm][(int)$dd]) && !$bus_day_arr[(int)$yyyy][(int)$mm][(int)$dd] ){ $holiday++; $sendout_num++; } if( 100 < $sendout_num ) break; } list($send_y, $send_m, $send_d) = explode('-', date('Y-m-d', mktime(0,0,0,(int)$today_month,($today_day + $sendout_num),(int)$today_year))); $res = array( 'today_bus_flag' => $today_bus_flag, 'time_limit_addition'=> $time_limit_addition, 'indication_incart' => $indication_incart, 'holiday' => $holiday, 'sendout_num' => $sendout_num, 'sendout_date' => array('year' => $send_y, 'month' => $send_m, 'day' => $send_d) ); return $res; } function usces_action_footer_comment(){ echo "\n"; } function usces_set_acting_notification_time( $key ){ global $wpdb; $tableName = $wpdb->prefix . "usces_access"; $query = $wpdb->prepare("SELECT ID FROM $tableName WHERE acc_type = %s AND acc_key = %s", 'notification_time', $key); $res = $wpdb->get_var( $query ); if( $res ) return; $query = $wpdb->prepare("INSERT INTO $tableName (acc_key, acc_type, acc_num1) VALUES (%s, %s, %d)", $key, 'notification_time', time()); $res = $wpdb->query( $query ); } function usces_check_notification_time( $key, $time ){ global $wpdb; $tableName = $wpdb->prefix . "usces_access"; $query = $wpdb->prepare("SELECT acc_num1 FROM $tableName WHERE acc_type = %s AND acc_key = %s", 'notification_time', $key); $res = $wpdb->get_var( $query ); if( !$res ) return false; $past = time() - $res; if( $time > $past ) return true; else return false; } function usces_is_same_itemcode( $post_id, $item_code ){ global $wpdb, $usces; $query = $wpdb->prepare("SELECT post_id FROM $wpdb->postmeta WHERE post_id <> %d AND meta_key = %s AND meta_value = %s", $post_id, '_itemCode', $item_code); $ids = $wpdb->get_col( $query ); // usces_log('ids : '.print_r($query,true), 'acting_transaction.log'); // usces_log('ids : '.print_r($ids,true), 'acting_transaction.log'); if( !$ids ){ return false; } $id_str = implode(',', $ids); $query = "SELECT ID FROM $wpdb->posts WHERE ID IN({$id_str}) AND post_status = 'publish'"; $res = $wpdb->get_col( $query ); // usces_log('res : '.print_r($res,true), 'acting_transaction.log'); // usces_log('res : '.print_r($query,true), 'acting_transaction.log'); if( !$res ){ return false; } return $res; } function usces_update_sku( $post_id, $skucode, $fieldname, $value ){ global $wpdb; $metas = usces_get_post_meta($post_id, '_isku_'); if( ! $metas ) return false; $meta_id = ''; foreach( $metas as $meta ){ $sku = unserialize($meta['meta_value']); if( $skucode == $sku['code'] ){ $meta_id = $meta['meta_id']; $sku[$fieldname] = $value; break; } } $serialized_values = serialize($sku); if( !empty($meta_id) ) $res = $wpdb->query( $wpdb->prepare("UPDATE $wpdb->postmeta SET meta_value = %s WHERE meta_id = %d", $serialized_values, $meta_id) ); if( !$res ){ return false; }else{ return true; } } function usces_get_items_skus() { global $wpdb, $usces; $res = array(); $item_codes = array(); $item_names = array(); $status = array(); $query = $wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_mime_type = %s AND post_status = %s", 'item', 'publish'); $IDs = $wpdb->get_col($query); if( !$IDs ) return $res; //wp_cache_set( 'item_ids', $IDs ); $key = 0; foreach((array)$IDs as $post_id){ $item_codes[$post_id] = $usces->getItemCode($post_id); $item_names[$post_id] = $usces->getItemName($post_id); //$skus = $usces->get_skus($post_id); $metas = usces_get_post_meta($post_id, '_isku_'); foreach( (array)$metas as $mkey => $rows ){ $metas[$mkey]['meta_value'] = unserialize($rows['meta_value']); $allmetas[] = $metas; // $sku_post_id[] = $post_id; // $sku_code[] = $values['code']; // $sku_stocknum[] = $values['stocknum']; $status[] = $metas[$mkey]['meta_value']['stock']; $key++; } //usces_log('implode : '.strlen(explode(',', $res)), 'acting_transaction.log'); } // wp_cache_set( 'item_ids', $IDs ); // wp_cache_set( 'item_codes', $item_codes ); // wp_cache_set( 'item_names', $item_names ); // wp_cache_set( 'sku_data', $res ); // wp_cache_set( 'stock_ct', array_count_values($status) ); } function usces_get_non_zerostoc_items() { global $wpdb, $usces; $query = $wpdb->prepare("SELECT ID, code.meta_value AS code, name.meta_value AS name FROM {$wpdb->posts} LEFT JOIN {$wpdb->postmeta} AS code ON ID = code.post_id AND '_itemCode' = code.meta_key LEFT JOIN {$wpdb->postmeta} AS name ON ID = name.post_id AND '_itemName' = name.meta_key LEFT JOIN {$wpdb->postmeta} AS sku ON ID = sku.post_id AND '_isku_' = sku.meta_key WHERE post_mime_type = %s AND post_type = %s AND post_status <> %s AND (sku.meta_value LIKE %s OR sku.meta_value LIKE %s) GROUP BY ID", 'item', 'post', 'trush', '%"stocknum";i:0%', '%"stocknum";s:1:"0"%'); $res = $wpdb->get_results($query, ARRAY_A); return $res; // $key = 0; // foreach((array)$items as $item){ //// $ItemCode = $usces->getItemCode($item['ID']); //// $ItemName = $usces->getItemName($item['ID']); // // //$skus = $usces->get_skus($post_id); // $metas = usces_get_post_meta($item['ID'], '_isku_'); // foreach( (array)$metas as $rows ){ // $meta_value = unserialize($rows['meta_value']); // if( "" != $meta_value['stocknum'] && 0 === (int)$meta_value['stocknum'] ){ // $res[$key]['ID'] = $item['ID']; // $res[$key]['code'] = $item['code']; // $res[$key]['name'] = $item['name']; // $res[$key]['sku'] = $meta_value['code']; // } // $key++; // } // } // return $res; } function usces_get_stocs() { global $wpdb, $usces; $status = array(); $query = $wpdb->prepare("SELECT m.meta_value FROM {$wpdb->posts} AS p LEFT JOIN {$wpdb->postmeta} AS m ON p.ID = m.post_id AND m.meta_key = %s WHERE post_mime_type = %s AND post_type = %s AND post_status <> %s" , '_isku_', 'item', 'post', 'trush'); $values = $wpdb->get_col($query); if( !$values ) return $status; foreach((array)$values as $value){ $meta_value = unserialize($value); $status[] = (string)$meta_value['stock']; } return array_count_values($status); } function usces_get_deco_order_id( $order_id ) { global $usces; $dec_order_id = $usces->get_order_meta_value( 'dec_order_id', $order_id); if( !$dec_order_id ){ $dec_order_id = str_pad($order_id, $usces->options['system']['dec_orderID_digit'], "0", STR_PAD_LEFT); } return $dec_order_id; } function usces_mail_line( $type, $email = '' ) { $line = ''; switch( $type ) { case 1: $line = "******************************************************************"; break; case 2: $line = "------------------------------------------------------------------"; break; case 3: $line = "=================================================================="; break; } $line = apply_filters( 'usces_filter_mail_line', $line, $type, $email ); return $line."\r\n"; } function usces_get_gp_price($post_id, $p, $quant){ global $usces; $GpN1 = $usces->getItemGpNum1($post_id); $GpN2 = $usces->getItemGpNum2($post_id); $GpN3 = $usces->getItemGpNum3($post_id); $GpD1 = $usces->getItemGpDis1($post_id); $GpD2 = $usces->getItemGpDis2($post_id); $GpD3 = $usces->getItemGpDis3($post_id); if( empty($GpN1) || empty($GpD1) ) { $realprice = $p; }else if( (!empty($GpN1) && !empty($GpD1)) && (empty($GpN2) || empty($GpD2)) ) { if( $quant >= $GpN1 ) { $realprice = round($p * (100 - $GpD1) / 100); }else{ $realprice = $p; } }else if( (!empty($GpN1) && !empty($GpD1)) && (!empty($GpN2) && !empty($GpD2)) && (empty($GpN3) || empty($GpD3)) ) { if( $quant >= $GpN2 ) { $realprice = round($p * (100 - $GpD2) / 100); }else if( $quant >= $GpN1 && $quant < $GpN2 ) { $realprice = round($p * (100 - $GpD1) / 100); }else{ $realprice = $p; } }else if( (!empty($GpN1) && !empty($GpD1)) && (!empty($GpN2) && !empty($GpD2)) && (!empty($GpN3) && !empty($GpD3)) ) { if( $quant >= $GpN3 ) { $realprice = round($p * (100 - $GpD3) / 100); }else if( $quant >= $GpN2 && $quant < $GpN3 ) { $realprice = round($p * (100 - $GpD2) / 100); }else if( $quant >= $GpN1 && $quant < $GpN2 ) { $realprice = round($p * (100 - $GpD1) / 100); }else{ $realprice = $p; } }else{ $realprice = $p; } $realprice = apply_filters('usces_filter_get_gp_price', $realprice, $post_id, $p, $quant); return $realprice; } //20120306ysk start 0000324 function usces_is_complete_settlement( $payment_name, $status = '' ) { $complete = false; //20120919ysk start 0000573 $options = get_option('usces'); if( $options['point_assign'] == 0 ) { $complete = true; //20120919ysk end } else { $payments = usces_get_system_option( 'usces_payment_method', 'name' ); if( isset($payments[$payment_name]['settlement']) ) { switch( $payments[$payment_name]['settlement'] ) { case 'acting': if( false !== strpos( $status, 'pending' ) ) break; case 'acting_zeus_card': case 'acting_remise_card': case 'acting_jpayment_card': case 'acting_paypal_ec': case 'acting_sbps_card': case 'acting_telecom_card': case 'acting_digitalcheck_card': case 'acting_mizuho_card': case 'COD': $complete = true; } } } $complete = apply_filters( 'usces_filter_is_complete_settlement', $complete, $payment_name, $status ); return $complete; } function usces_action_acting_getpoint( $order_id, $add = true ) { global $usces, $wpdb; if( !apply_filters( 'usces_action_acting_getpoint_switch', true, $order_id, $add) ) return; //20120919ysk start 0000573 $options = get_option('usces'); if( $options['point_assign'] != 0 ) { //20120919ysk end if( 'activate' == $usces->options['membersystem_state'] && 'activate' == $usces->options['membersystem_point'] ) { $table_name = $wpdb->prefix . "usces_order"; $mquery = $wpdb->prepare("SELECT mem_id, order_getpoint FROM $table_name WHERE ID = %d", $order_id); $values = $wpdb->get_row( $mquery, ARRAY_A ); $mem_id = $values['mem_id']; $getpoint = $values['order_getpoint']; if( !empty($mem_id) && 0 < $getpoint ) { $calc = ($add) ? '+' : '-'; $member_table_name = $wpdb->prefix . "usces_member"; $mquery = $wpdb->prepare("UPDATE $member_table_name SET mem_point = (mem_point ".$calc." %d) WHERE ID = %d", $getpoint, $mem_id); $wpdb->query( $mquery ); if( !empty($_SESSION['usces_member']['point']) ) { $mquery = $wpdb->prepare("SELECT mem_point FROM $member_table_name WHERE ID = %d", $mem_id); $point = $wpdb->get_var( $mquery ); $_SESSION['usces_member']['point'] = $point; } } } } do_action( 'usces_action_acting_getpoint', $order_id, $add ); } function usces_restore_point( $mem_id, $point ) { global $wpdb; if( !apply_filters( 'usces_action_restore_point_switch', true, $mem_id, $point) ) return; $member_table_name = $wpdb->prefix . "usces_member"; $query = $wpdb->prepare( "UPDATE $member_table_name SET mem_point = (mem_point - %d) WHERE ID = %d", $point, $mem_id ); $wpdb->query( $query ); } //20120306ysk end //20120413ysk start function usces_set_free_csv( $customer ){ $free_csv = ""; if( !WCUtils::is_blank($customer['name1']) ) { $free_csv = "LAST_NAME=".mb_convert_encoding($customer['name1'],'SJIS','UTF-8').",FIRST_NAME=".mb_convert_encoding($customer['name2'],'SJIS','UTF-8').",TEL=".str_replace("-","",$customer['tel']).",MAIL=".$customer['mailaddress1']; $free_csv = base64_encode( $free_csv ); } return $free_csv; } //20120413ysk end function usces_get_itemopt_filed($post_id, $sku, $opt){ global $usces; $sku = urlencode($sku); $optcode = urlencode($opt['name']); $name = $opt['name']; $means = (int)$opt['means']; $essential = (int)$opt['essential']; $session_value = isset( $_SESSION['usces_singleitem']['itemOption'][$post_id][$sku][$optcode] ) ? $_SESSION['usces_singleitem']['itemOption'][$post_id][$sku][$optcode] : NULL; $html = ''; switch($means) { case 0://Single-select case 1://Multi-select $selects = explode("\n", $opt['value']); $multiple = ($means === 0) ? '' : ' multiple'; $multiple_array = ($means == 0) ? '' : '[]'; $html .= "\n\n"; break; case 2://Text $html .= "\n\n"; break; case 5://Text-area $html .= "\n\n"; break; } $html = apply_filters('usces_get_itemopt_filed', $html, $post_id, $sku, $opt); return $html; } function usces_delete_order_check( $order_id ) { $res = apply_filters( 'usces_filter_delete_order_check', true, $order_id ); return $res; } function usces_itempage_admin_bar() { global $wp_admin_bar, $post; if( is_single() && usces_is_item() ){ $wp_admin_bar->remove_menu('edit'); $ref = urlencode(site_url() . '/wp-admin/admin.php?page=usces_itemedit'); $wp_admin_bar->add_menu( array( 'id' => 'edit', 'title' => __('Edit item', 'usces'), 'href' => site_url() . '/wp-admin/admin.php?page=usces_itemedit&action=edit&post=' . $post->ID . '&usces_referer=' . $ref ) ); } } ?> ```