?>
<?php
if (isset($_POST['small_bar'])) {
//here we need to provide an interface to detect barcode number in set so what is not empty is reall one processed
$small_bar = $_POST['dbs0'];
print "ADDING a cross reference to ";
print $small_bar;
$barcode = $small_bar;
$item_id = $_POST['item_id'];
$buyer_id = $_POST['buyer_id'];
echo $item_id;
echo $buyer_id;
$added = insert_six_barcode_sells($item_id, $buyer_id, $barcode, $conn);
//here we pick up the error messages
$id_barcode = get_barcode_id($barcode);
//This means if barcode is actually tested or not
$TESTED = check_barcode_test($id_barcode);
if ($TESTED == 1) {
echo "tested";
} else {
echo "Not tested";
}
if ($added == 1) {
echo $added;
$MESG = "Item " . $barcode . " Sold.";
} else {
if ($added == 0) {
$MESG = "Item failed to be sold.";
}
}
function insert_six_barcode_sells($itemid, $buyerid, $barcode, $conn)
{
connect_db();
// $row = sqlsrv_fetch_array($stmt);
//echo "User login: "******"</br>";
$result = sqlsrv_query($conn, "select distinct Items.ItemID, Items.Title, Inventory.SKU, Orders.BuyerID, \r\nSales.SaleDate, Orders.StatusID, Shipments.TrackingNumber, Addresses.FirstName, Addresses.LastName,\r\nAddresses.AddressLine1,Addresses.AddressLine2,Addresses.AddressLine3,Addresses.City,\r\nAddresses.State,Addresses.PostalCode, Addresses.Country, Sales.eCommerceID, Sales.TransactionID, Orders.ExternalOrderID, Sales.SalePrice\r\nfrom Orders \r\nleft join Shipments on Shipments.OrderID=Orders.OrderID \r\nleft join Sales on Sales.ShipmentID = Shipments.ShipmentID \r\nINNER JOIN SalesPurchases ON SalesPurchases.SaleID=Sales.SaleID \r\nINNER JOIN Purchases ON Purchases.PurchaseID = SalesPurchases.PurchaseID \r\nInner Join Inventory ON Inventory.InventoryID = Purchases.InventoryID\r\nINNER Join Addresses ON Addresses.AddressID=Shipments.ShippingAddressID\r\nINNER JOIN Items ON Items.ItemID = Inventory.ItemID where Orders.StatusID='100000' AND Items.ItemID='{$itemid}' AND Orders.BuyerID='{$buyerid}'");
//Sales.SaleDate > '2013-11-29' AND Shipments.TrackingNumber='' AND
if (!$result) {
die('Query failed.');
}
$i = 0;
echo "<table border='2'>";
while ($row = sqlsrv_fetch_array($result)) {
//echo "<td> ".$row[0]."</td><td> ".$row[1]."</td> <td>".$row[2]."</td><td> ".$row[3]."</td><td> ".$row[5]."</td><td> ".$row[6]."</td><td> ".$row[7]."</BR>".$row[8]."</td><td> ".$row[9]."</BR>".$row[10]."</BR> ".$row[11]."</td><td> ".$row[12]."</td><td> ".$row[13]."</td><td> ".$row[14]."</BR> ".$row[15]." </br>";
$u_barcode = swap_back($row[2]);
//this a stoc number in reality
$ebaid = $row[16];
$ebairef = $row[17];
$tracking_number = $row[6];
$user = 1;
$date = $row[4];
$item_id = $row[0];
$itemid;
$firstname = str_replace("'", "a", $row[7]);
$lastname = str_replace("'", "a", $row[8]);
//echo $itemid;
echo $lastname;
$unique = swap_back($_POST['un_barcode']);
echo $unique;
echo $firstname;
$address1 = str_replace("'", "a", $row[9]);
$address2 = str_replace("'", "a", $row[10]);
$address3 = str_replace("'", "a", $row[11]);
echo $address1;
echo $address2;
echo $address3;
$city = $row[12];
$state = $row[13];
$postalcode = $row[14];
$country = $row[15];
$ebaysales = $row[18];
$date_s = $row[4]->format('Y-m-d');
$price = $row[19];
//$date_s=$row[4];
echo $date_s;
$id_barcode = get_barcode_id($barcode);
echo $id_Barcode;
$FLAG_RDT_TO_GO = 0;
global $BARCODE_COMM;
if (empty($id_barcode)) {
//empty barcode id. Means barcode does not exists in barcode table, Though does not exist
$BARCODE_COMM = " Empty Barcode";
} else {
$FLAG_RDT_TO_GO = 1;
}
//checking ebay. Already sold
//check if tested and passed test
$test_result = check_barcode_test($id_barcode);
if ($test_result == 1) {
$FLAG_RDT_TO_GO = 1;
echo "Tested it";
} else {
$FLAG_RDT_TO_GO = 0;
}
if ($FLAG_RDT_TO_GO == 1) {
$result_ebay = check_barcode_ebay($barcode);
if ($result_ebay == 1) {
$FLAG_RDT_TO_GO = 1;
} else {
$FLAG_RDT_TO_GO = 0;
}
}
//here we consider a case that needs current day to help tracking how many disposed that day
$date_disposed = date("Y-m-d");
//echo "</BR>ass ".$address1=explode(',',preg_replace('/^\[(.*)\]$/','$1',$address1));
//here we take care of special characters conversion
echo "first: " . $firstname;
echo "last:" . $lastname;
echo $lastname = str_replace(")", "", $lastname);
//here is a problem (EMPA NW LTD)) No string compatibel
echo $lastname = mysql_real_escape_string($lastname);
$address1 = mysql_real_escape_string($address1);
$address2 = mysql_real_escape_string($address2);
$address3 = mysql_real_escape_string($address3);
$city = mysql_real_escape_string($city);
$state - mysql_real_escape_string($state);
echo $insert = "INSERT INTO six_barcode(u_barcode, barcode_id_Barcode,ebayid, ebayref, tracking_num, parceler" . ",stock_number,date_ship,item_id,name,surname,address1,address2,address3,city,state,postalcode, country, ebaysales,price,date_disposed) VALUES('{$barcode}','{$id_barcode}','{$ebaid}','{$ebairef}','{$tracking_number}','{$id_user}','{$u_barcode}','{$date_s}','{$item_id}','{$firstname}','{$lastname}','{$address1}','{$address2}','{$address3}','{$city}','{$state}','{$postalcode}','{$country}','{$ebaysales}','{$price}','{$date_disposed}')";
//echo $insert;
if ($FLAG_RDT_TO_GO == 1) {
$result = mysql_query($insert) or die(mysql_error());
}
echo $BARCODE_COMM;
if ($result and $FLAG_RDT_TO_GO == 1) {
return 1;
} else {
return 0;
}
}
}
