get_results("SELECT * FROM ".$wpdb->prefix."collect_data_forms", ARRAY_A);
foreach ($form_info as $info) {
if(($info['type'] == 'delivery_address') && ($info['active']=='1')) {
$delivery_address=true;
} else if(($info['type'] == 'delivery_city') && ($info['active']=='1')) {
$delivery_city=true;
} else if(($info['type'] == 'delivery_state') && ($info['active']=='1')) {
$delivery_state=true;
} else if(($info['type'] == 'delivery_country') && ($info['active']=='1')) {
$delivery_country=true;
}
}
foreach ($form_info as $info) {
//echo "".print_r(array_flip($form_info),1)."
";
// exit (print_r(!array_search('delivery_address',$info),1));
if ((($info['type'] == 'delivery_address') && ($info['active']=='1')) || (!$delivery_address && ($info['type'] == 'address') && ($info['active']=='1'))) {
$address_key = $info['id'];
} else if((($info['type'] == 'delivery_city') && ($info['active']=='1')) || (!$delivery_city && ($info['type'] == 'city') && ($info['active']=='1'))) {
$city_key = $info['id'];
} else if((($info['type'] == 'delivery_state') && ($info['active']=='1')) || (!$delivery_state && ($info['type'] == 'state') && ($info['active']=='1'))) {
$state_key = $info['id'];
} else if((($info['type'] == 'delivery_country') && ($info['active']=='1')) || (!$delivery_country && ($info['type'] == 'country') && ($info['active']=='1'))) {
$country_key = $info['id'];
} else if(($info['type'] == 'delivery_first_name') && ($info['active']=='1')) {
$first_name_key = $info['id'];
} else if(($info['type'] == 'delivery_last_name') && ($info['active']=='1')) {
$last_name_key = $info['id'];
}
}
$user_infos = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."submited_form_data WHERE log_id='".$log_id."'", ARRAY_A);
//echo (print_r($user_infos,1));
foreach ($user_infos as $user_info) {
if ($user_info['form_id'] == $address_key) {
//exit ($user_info['form_id']." ".$address_key);
$address = $user_info['value'];
}
if ($user_info['form_id'] == $city_key) {
$city = $user_info['value'];
}
if ($user_info['form_id'] == $state_key) {
$state = $user_info['value'];
}
if ($user_info['form_id'] == $country_key) {
$country = $user_info['value'];
}
if ($user_info['form_id'] == $first_name_key) {
$first_name = $user_info['value'];
}
if ($user_info['form_id'] == $last_name_key) {
$last_name = $user_info['value'];
}
}
if (($first_name_key == '') || ($last_name_key == '')) {
$log_info = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."purchase_logs WHERE id='".$log_id."'");
$first_name = $log_info[0]['firstname'];
$last_name = $log_info[0]['lastname'];
}
$full_name = $first_name." ".$last_name;
$products = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."cart_contents WHERE purchaseid='".$log_id."'",ARRAY_A);
//return $log_id;
$xml = "";
$xml .= "";
$xml .= "$email";
$xml .= "$passwd";
$xml .= "$server";
$xml .= "$server";
$xml .= "$warehouse";
$xml .= "";
$xml .= "";
$xml .= "";
$xml .= "".$full_name."";
$xml .= "";
$xml .= "".$address."";
$xml .= "";
$xml .= "".$city."";
$xml .= "".$state."";
$xml .= "".$country."";
$xml .= ""."5011"."";
$xml .= ""."3030303030"."";
$xml .= ""."hanzhimeng@gmail.com"."";
$xml .= "";
$xml .= "UPS Ground";//to be changed.
//$xml
foreach($products as $product) {
$xml .= "- ";
$xml .="
"."Book1"."";
$xml .= "".$product['quantity']."";
$xml .= "Austin Powers World Ransom";
$xml .= "3";
$xml .= "1";
$xml .= "1";
$xml .= "1";
$xml .= "".$product['price']."";
$xml .= " ";
}
$xml .="";
$xml .="";
return $xml;
}
function shipwire_built_sync_xml() {
global $wpdb;
$email = get_option("shipwireemail");
$passwd = get_option("shipwirepassword");
$server = "Production"; // or "Production"
$warehouse = "00";
$xml = "";
$xml .= "";
$xml .= "".$email."";
$xml .= "".$passwd."";
$xml .= "".$server."";
$xml .= "";
$xml .= "";
$xml .= "";
return $xml;
}
function shipwire_built_tracking_xml() {
global $wpdb;
$email = get_option("shipwireemail");
$passwd = get_option("shipwirepassword");
$server = "Production";
$warehouse = "00";
$xml = "";
$xml .= "";
$xml .= "".$email."";
$xml .= "".$passwd."";
$xml .= "".$server."";
$xml .= "1";
$xml .= "";
return $xml;
}
function shipwire_send_sync_request($xml) {
$OrderList = urlencode($xml);
$shipwire_ch = curl_init("https://www.shipwire.com/exec/InventoryServices.php");
curl_setopt ($shipwire_ch, CURLOPT_POST, 1);
curl_setopt ($shipwire_ch, CURLOPT_HTTPHEADER, array('Accept: application/xml', "Content-type:application/x-www-form-urlencoded"));
curl_setopt ($shipwire_ch, CURLOPT_POSTFIELDS, "InventoryUpdateXML=".$OrderList);
ob_start();
curl_exec($shipwire_ch);
$orderSubmitted = ob_get_contents();
ob_end_clean();
return $orderSubmitted;
}
function shipwire_sent_request($xml) {
$OrderList = urlencode($xml);
$shipwire_ch = curl_init("https://www.shipwire.com/exec/FulfillmentServices.php");
curl_setopt ($shipwire_ch, CURLOPT_POST, 1);
curl_setopt ($shipwire_ch, CURLOPT_HTTPHEADER, "Content-type:"."application/x-www-form-urlencoded");
curl_setopt ($shipwire_ch, CURLOPT_POSTFIELDS, "InventoryUpdateXML=".$OrderList);
ob_start();
curl_exec($shipwire_ch);
$orderSubmitted = ob_get_contents();
ob_end_clean();
return $orderSubmitted;
}
function shipwire_send_tracking_request($xml) {
$OrderList = urlencode($xml);
$shipwire_ch = curl_init("https://www.shipwire.com/exec/TrackingServices.php");
curl_setopt ($shipwire_ch, CURLOPT_POST, 1);
curl_setopt ($shipwire_ch, CURLOPT_HTTPHEADER, "Content-type:"."application/x-www-form-urlencoded");
curl_setopt ($shipwire_ch, CURLOPT_POSTFIELDS, "InventoryUpdateXML=".$OrderList);
ob_start();
curl_exec($shipwire_ch);
$orderSubmitted = ob_get_contents();
ob_end_clean();
return $orderSubmitted;
}
?>