die("Same Max Qty requested !");
}
$ebay_revise_price = $ebay_price_db;
if ($in_amazon == 0) {
$ebay_revise_qty = $max_qty;
} elseif ($in_amazon == 1) {
if ($amazon_quantity_db >= $max_qty) {
$ebay_revise_qty = $max_qty;
} elseif ($amazon_quantity_db < $max_qty) {
$ebay_revise_qty = $amazon_quantity_db;
}
}
if (!isset($ebay_revise_price) or !isset($ebay_revise_qty)) {
die("Revise Values Failed !");
}
$return_result = ebay_revise_item($user_id, $ebay_item_id, $ebay_revise_price, $ebay_revise_qty);
$xml = simplexml_load_string($return_result);
if ($xml->Ack == "Success" or $xml->Ack == "Warning") {
$sql_maxqty_update = "UPDATE ebay_asin eb,\n\t\t\t\t\t\t\t\t\tuser_products ups \n\t\t\t\t\t\t\tSET eb.max_quantity={$max_qty},\n\t\t\t\t\t\t\t\teb.quantity = {$ebay_revise_qty},\n\t\t\t\t\t\t\t\tups.MaxQty = {$max_qty},\n\t\t\t\t\t\t\t\tups.Qty = {$ebay_revise_qty}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\teb.UserID = ups.UserID AND\n\t\t\t\t\t\t\t\teb.item_id = ups.ItemID AND\n\t\t\t\t\t\t\t\teb.asins = ups.SKU AND\n\t\t\t\t\t\t\t\teb.item_id ='{$ebay_item_id}' AND\n\t\t\t\t\t\t\t\teb.asins = '{$asin}' AND\n\t\t\t\t\t\t\t\teb.UserID = {$user_id} AND\n\t\t\t\t\t\t\t\teb.max_quantity != {$max_qty}\n\t\t\t\t\t\t\t";
mysql_query($sql_maxqty_update) or die(mysql_error());
print "Updated:" . $max_qty . ":" . $ebay_revise_qty;
} elseif ($xml->Ack == "Failure") {
echo str_replace('', '', $xml->Errors->ShortMessage);
return;
} else {
echo "Please Report to Developer";
return;
}
} elseif ($no_record > 1) {
die("Duplicate Records - Please Report to Developer");
}
$ebay_revise_price = profit_formula_price($profit_ratio, $amazon_price);
$ebay_revise_qty = $amazon_qty;
} elseif ($amazon_qty >= $max_quantity) {
$ebay_revise_price = profit_formula_price($profit_ratio, $amazon_price);
$ebay_revise_qty = $max_quantity;
}
if (!isset($ebay_revise_price) or !isset($ebay_revise_qty)) {
die("ESCAPED LOGIC :>> ITEM ID : " . $ebay_item_id . " ASIN :" . $ebay_sku . " USER : "******"UNSET EBAY ENVIRONMENT VALUES");
}
if (!isset($paypal_email) or !isset($return_accept_option) or !isset($refund_option) or !isset($return_within_days) or !isset($duration)) {
die("UNSET PRICE REVISE VARIABLES");
}
$result_xml_page = ebay_revise_item($ebay_item_id, $ebay_revise_price, $ebay_revise_qty);
$result_xml_elements = new SimpleXMLElement($result_xml_page);
if ($result_xml_elements->Ack == "Success" or $result_xml_elements->Ack == "Warning") {
$no_synced_products++;
if ($in_amazon) {
$sql_revise = "UPDATE ebay_asin eb, \n user_products ups\n SET \n eb.ebay_price = {$ebay_revise_price},\n eb.quantity = {$ebay_revise_qty},\n eb.amazon_price = {$amazon_price},\n eb.amazon_quantity = {$amazon_qty},\n eb.product_active = 1,\n eb.in_amazon = 1,\n ups.Price = {$ebay_revise_price},\n ups.Qty = {$ebay_revise_qty},\n ups.AmazonPrice = {$amazon_price},\n ups.AmazonQty = {$amazon_qty},\n ups.product_active = 1\n WHERE\n eb.item_id = ups.ItemID AND\n eb.asins = ups.SKU AND\n eb.UserID = ups.UserID AND\n eb.in_ebay = 1 AND \n eb.item_id = '{$ebay_item_id}' AND \n eb.UserID = {$user_id} \n ";
} elseif (!$in_amazon) {
$sql_revise = "UPDATE ebay_asin eb, \n user_products ups\n SET \n eb.ebay_price = {$ebay_revise_price},\n eb.quantity = {$ebay_revise_qty},\n eb.amazon_price = {$amazon_price},\n eb.amazon_quantity = {$amazon_qty},\n eb.product_active = 1,\n eb.in_amazon = 0,\n ups.Price = {$ebay_revise_price},\n ups.Qty = {$ebay_revise_qty},\n ups.AmazonPrice = {$amazon_price},\n ups.AmazonQty = {$amazon_qty},\n ups.product_active = 1\n WHERE\n eb.item_id = ups.ItemID AND\n eb.asins = ups.SKU AND\n eb.UserID = ups.UserID AND\n eb.in_ebay = 1 AND \n eb.item_id = '{$ebay_item_id}' AND \n eb.UserID = {$user_id} \n ";
}
} elseif ($result_xml_elements->Ack == "Failure") {
$no_failed_products++;
if ($in_amazon) {
$sql_revise = "UPDATE ebay_asin eb,\n user_products ups\n SET\n eb.product_active = 1,\n eb.in_amazon = 1,\n ups.product_active = 1,\n WHERE\n eb.item_id = ups.ItemID AND\n eb.asins = ups.SKU AND\n eb.UserID = ups.UserID AND\n eb.in_ebay = 1 AND \n eb.item_id = '{$item_id}' AND\n eb.UserID = {$user_id}\n ";
} elseif (!$in_amazon) {
$sql_revise = "UPDATE ebay_asin eb,\n user_products ups\n SET\n eb.product_active = 1,\n eb.in_amazon = 0,\n ups.product_active = 1,\n WHERE\n eb.item_id = ups.ItemID AND\n eb.asins = ups.SKU AND\n eb.UserID = ups.UserID AND\n eb.in_ebay = 1 AND \n eb.item_id = '{$item_id}' AND\n eb.UserID = {$user_id}\n ";
}
function revise_ebay($amazon_price, $prime, $quantity, $status, $asin, $item_id)
{
$active_user = 8;
$sql = "SELECT * FROM ebay_asin where in_ebay=1 and UserID=" . $active_user . " and asins='" . $asin . "'";
$rs = mysql_query($sql) or die(mysql_error());
$sql_ebay_config = "SELECT * FROM ebay_config WHERE user_id={$active_user}";
$rs_config = mysql_query($sql_ebay_config) or die('Something Wrong...!');
$row_config = mysql_fetch_assoc($rs_config);
//$max_quantity = $row_config['max_quantity'];
while ($row = mysql_fetch_array($rs)) {
$ratio = $row['profit_ratio'];
//$amz_quantity=$row['amazon_quantity']
$max_quantity = $row['max_quantity'];
$amazon_price = number_format((double) $amazon_price, 2, '.', '');
if ($status == 1) {
$amzquantity = $quantity;
} else {
$amzquantity = 1;
}
$ebay_price = $row['ebay_price'];
if ($ratio == 0.0) {
$ratio = $ebay_price * 0.87 - $amazon_price;
$ratio = number_format((double) $ratio, 2, '.', '');
}
if ($ratio != 0 && $max_quantity != 0) {
if ($prime == 'Yes' && $ratio < 2) {
$ebay_price = $amazon_price * (1 + $ratio) / 0.87;
} else {
if ($prime == 'Yes' && $ratio >= 2) {
$ebay_price = ($amazon_price + $ratio) / 0.87;
}
}
if ($quantity > $max_quantity) {
$quantity = $max_quantity;
} elseif ($quantity == 0 && $status == 1) {
$sql = "DELETE FROM ebay_asin where item_id=" . $item_id;
$sql1 = "DELETE FROM user_products where ItemID=" . $item_id;
mysql_query($sql);
mysql_query($sql1);
$date = date("d/m/Y h:i:s");
$message = "" . $date . " item for id=<a target='_blank' href=http://www.ebay.com/itm/" . $item_id . ">" . $item_id . "</a> is ended because <a '_blank' href=http://www.amazon.com/dp/" . $asin . ">" . $asin . "</a> is out of stock <br>";
file_put_contents("log.php", $message, FILE_APPEND);
$headers = 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
mail('*****@*****.**', 'Deleting Item', $message, $headers);
//mail('*****@*****.**', 'Deleting Item', $message,$headers);
mail('*****@*****.**', 'Deleting Item', $message, $headers);
delete_item($item_id);
} elseif ($quantity < $max_quantity) {
$quantity1 = $quantity;
$quantity = $quantity1;
}
$ebay_price = number_format((double) $ebay_price, 2, '.', '');
$profit_ratio = $ebay_price * 0.87 - $amazon_price;
if (!empty($amazon_price) && $amazon_price > 0 && $ebay_price > 0) {
$return_result = ebay_revise_item($active_user, $item_id, $ebay_price, $amazon_price, $quantity, $max_quantity, $asin);
$xml = simplexml_load_string($return_result);
$sql_maxqty_update = "UPDATE ebay_asin eb,\n\t\t\t\t\t\t\t\t\tuser_products ups \n\t\t\t\t\t\t\tSET eb.max_quantity={$max_quantity},\n\t\t\t\t\t\t\t\teb.quantity = {$quantity},\n\t\t\t\t\t\t\t\tups.MaxQty = {$max_quantity},\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tups.AmazonPrice={$amazon_price},\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tups.AmazonQty={$amzquantity},\n\t\t\t\t\t\t\t\tups.ProfitRatio={$profit_ratio},\n\t\t\t\t\t\t\t\teb.profit_ratio={$profit_ratio}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\teb.UserID = ups.UserID AND\n\t\t\t\t\t\t\t\teb.item_id = ups.ItemID AND\n\t\t\t\t\t\t\t\teb.item_id ={$item_id} AND\n\t\t\t\t\t\t\t\teb.asins = '{$asin}' AND\n\t\t\t\t\t\t\t\teb.UserID = {$active_user}\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t";
//echo $sql_maxqty_update;die;
mysql_query($sql_maxqty_update) or die(mysql_error());
if ($xml->Ack == "Success" or $xml->Ack == "Warning") {
$sql_maxqty_update = "UPDATE ebay_asin eb,\n\t\t\t\t\t\t\t\t\tuser_products ups \n\t\t\t\t\t\t\tSET eb.max_quantity={$max_quantity},\n\t\t\t\t\t\t\t\teb.quantity = {$quantity},\n\t\t\t\t\t\t\t\tups.MaxQty = {$max_quantity},\n\t\t\t\t\t\t\t\tups.Qty = {$quantity},\n\t\t\t\t\t\t\t\tups.AmazonPrice={$amazon_price},\n\t\t\t\t\t\t\t\tups.Price={$ebay_price},\n\t\t\t\t\t\t\t\tups.AmazonQty={$amzquantity},\n\t\t\t\t\t\t\t\tups.ProfitRatio={$profit_ratio},\n\t\t\t\t\t\t\t\teb.profit_ratio={$profit_ratio}\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\teb.UserID = ups.UserID AND\n\t\t\t\t\t\t\t\teb.item_id = ups.ItemID AND\n\t\t\t\t\t\t\t\teb.item_id ='{$item_id}' AND\n\t\t\t\t\t\t\t\teb.asins = '{$asin}' AND\n\t\t\t\t\t\t\t\teb.UserID = {$active_user}\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t";
//echo $sql_maxqty_update;die;
mysql_query($sql_maxqty_update) or die(mysql_error());
} else {
foreach ($xml->Errors as $error) {
$errCode = $error->ErrorCode;
$errLongMsg = htmlentities($error->LongMessage);
$errSeverity = $error->SeverityCode;
echo $errSeverity . ": [" . $errCode . "] " . $errLongMsg . "<br/>";
}
}
}
}
}
}
