public function changeShareTemplateStatus() { $result = 0; if ($_POST['status'] == 2 || $_POST['status'] == 3) { $id_array = explode(",", $_POST['ids']); foreach ($id_array as $id) { $sql = "select SKU from share_template where Id = " . $id; $result = mysql_query($sql, eBayListing::$database_connect); $row = mysql_fetch_assoc($result); $json_object = eBayListing::getInventoryServiceS("?action=getSkuStatus&data=" . $row['SKU']); //print_r($json_object); if ($json_object->status == "active" || $json_object->status == "out of stock") { $sql = "update share_template set status = " . $_POST['status'] . " where Id = " . $id; //echo $sql."\n"; $result = mysql_query($sql, eBayListing::$database_connect); } } } else { $sql = "update share_template set status = " . $_POST['status'] . " where Id in (" . $_POST['ids'] . ")"; //echo $sql."\n"; $result = mysql_query($sql, eBayListing::$database_connect); } echo $result; }
public static function getSkuLowPriceS($sku = '', $currency = '', $location = '', $site = '') { $rate = eBayListing::getExchangeRateS($currency); $json_object = eBayListing::getInventoryServiceS("?action=getSkuLowestPrice&sku=" . $sku . "&location=" . $location . "&site=" . $site); $l_price = $json_object->L / $rate; //echo round($l_price, 2); return round($l_price, 2); }