" . "date start: " . date("Y-m-d",$timeYear) ."
"; $resultDays = mysqli_query($db,$queryDays); $totalRowDays = mysqli_num_rows($resultDays); //echo "Total rows: " . $totalRowDays . "
"; //checking if new product... $queryDaysBf = "SELECT * FROM `parts_timeline` WHERE partno ='" . $partno . "' AND dateChange < $timeYear AND qty_on_hand > 0 ORDER BY dateChange DESC LIMIT 1;"; //$timeSixMonths // echo $queryDaysBf . "
"; $resultDaysBf = mysqli_query($db,$queryDaysBf); $totalRowsBf = mysqli_num_rows($resultDaysBf); $firstArrival = 0; if($totalRowsBf < 1) { $sqlArr = "SELECT * FROM `shipment_line` WHERE `partid` = " . $partid2 . " AND `qtyRec` != '' AND `dateRec` != '' ORDER BY lineid ASC LIMIT 1"; $resultArrival = mysqli_query($db,$sqlArr); while($rowArr = mysqli_fetch_array($resultArrival, MYSQLI_ASSOC)) { $firstArrival = strtotime(str_replace('-', '/', $rowArr["dateRec"])); //echo "FIRST TIME: " . $rowArr["dateRec"] . " IN UNIX: " . date("Y-m-d",$firstArrival); } } //echo $queryDaysStock . "
" . "date start: " . date("Y-m-d",$timeYearStock) . " date end: " . date("Y-m-d",$timeWithStockLast); $countDays = inventory_days($resultDays,$totalRowsBf,$totalRowDays,$firstArrival); if($qty_on_hand < 1) { $timeWithStockLast = time(); $timeYearStock = time() - (52 * 7 * 24 * 60 * 60); //1 year back //checking if new product... $queryDaysYrStock = "SELECT * FROM `parts_timeline` WHERE partno ='" . $partno . "' AND qty_on_hand > 0 ORDER BY dateChange DESC LIMIT 1;"; //echo $queryDaysYrStock . "
"; $resultDaysYrStock = mysqli_query($db,$queryDaysYrStock); while($rowDaysYrStock = mysqli_fetch_array($resultDaysYrStock, MYSQLI_ASSOC)) { $timeWithStockLast = $rowDaysYrStock['dateChange']; $timeYearStock = $timeWithStockLast - (52 * 7 * 24 * 60 * 60); //1 year back } $queryDaysStock = "SELECT * FROM `parts_timeline` WHERE partno ='" . $partno . "' AND dateChange > $timeYearStock AND dateChange < $timeWithStockLast ORDER BY dateChange ASC;"; //$timeSixMonths //echo $queryDaysStock . "
"; //echo "date start: " . date("Y-m-d",$timeYearStock) . " date end: " . date("Y-m-d",$timeWithStockLast) . "
"; $resultDaysStock = mysqli_query($db,$queryDaysStock); $totalRowDaysStock = mysqli_num_rows($resultDaysStock); //echo "Total rows: " . $totalRowDays . "
"; //checking if new product... $queryDaysBfStock = "SELECT * FROM `parts_timeline` WHERE partno ='" . $partno . "' AND dateChange < $timeYearStock AND qty_on_hand > 0 ORDER BY dateChange DESC LIMIT 1;"; //$timeSixMonths //echo $queryDaysBf . "
"; $resultDaysBfStock = mysqli_query($db,$queryDaysBfStock); $totalRowsBfStock = mysqli_num_rows($resultDaysBfStock); $firstArrivalStock = 0; if($totalRowsBfStock < 1) { $sqlArr = "SELECT * FROM `shipment_line` WHERE `partid` = " . $partid2 . " AND `qtyRec` != '' AND `dateRec` != '' ORDER BY lineid ASC LIMIT 1"; //echo $sqlArr; $resultArrivalStock = mysqli_query($db,$sqlArr); while($rowArr = mysqli_fetch_array($resultArrivalStock, MYSQLI_ASSOC)) { $firstArrivalStock = strtotime(str_replace('-', '/', $rowArr["dateRec"])); //echo "FIRST ARRIVAL TIME: " . date("Y-m-d",$firstArrivalStock); } } $countDaysARS = inventory_days($resultDaysStock,$totalRowsBfStock,$totalRowDaysStock,$firstArrivalStock,$timeYearStock, $timeWithStockLast); } $ARS = 0; if($qty_on_hand < 1) { $queryUnitsSold = "SELECT qty_sold, dateChange FROM `parts_daily_timeline` WHERE partno ='" . $partno . "' AND dateChange >= $timeYearStock AND dateChange <= $timeWithStockLast ORDER BY dateChange ASC;"; //echo "SQL: " . $queryUnitsSold . "
"; $k = 0; $sum_sold_ars = 0; unset($timeLineStd); $timeLineStd = array(); $resultUnitsSold = mysqli_query($db, $queryUnitsSold); while ($row = mysqli_fetch_array($resultUnitsSold, MYSQLI_ASSOC)) { $qty_sold = intval($row["qty_sold"]); $dateOnCheck = $row["dateChange"]; $dateCheck = date("Y-m-d",$dateOnCheck); if (in_array($dateCheck, $timeLineStd)) continue; else { //echo "Date with Qty: " . $dateCheck . " #" . $k . " Qty Sold = " . $qty_sold . "
"; $timeLineStd[$k] = $dateCheck; $sum_sold_ars += $qty_sold; $k++; } } //echo "Units Sold: " . $sum_sold_ars . " / " . $countDaysARS . " TIME START: " . date("Y-m-d",$timeYearStock) . " TIME END: " . date("Y-m-d",$timeWithStockLast); if($sum_sold_ars < 1 || $countDaysARS < 1) $ARS = $units_sold/$countDays; else $ARS = $sum_sold_ars/$countDaysARS; // ARS out of stock item } else { $countDaysARS = $countDays; $ARS = $units_sold/$countDays; // ARS In Stock item } //echo "total days for ARS: " . $countDaysARS . "
"; if ($ARS > 0 && $qty_on_hand > 0) $days_until_out = round($qty_on_hand/$ARS); else $days_until_out = 0; //echo $days_until_out . "
"; $qty_remaining = $qty_on_order - $qty_received; //remove the qty received from order //$qty_on_order = $myrow["qty_on_order"]; //THIS IS UPDATED FROM orderline table //$qty_accept = $myrow["qty_accept"]; //THIS IS ADDED FROM orderline table /**days until the stock will run out including the on order qty**/ if ($ARS > 0 && $qty_remaining > 0) $days_with_on_order = round($qty_remaining/$ARS) + $days_until_out; else $days_with_on_order = $days_until_out; /**days until the stock will run out including the on order qty**/ } //********************* INVENTORY DAYS ************************* //******************* EARN & TURN ********************************/ if ($costOnHand > 0 && $avg_price > 0) { $gross_margin = (($avg_price - $costOnHand)/$avg_price)*100; //GROSS MARGIN $cogs_sold = $costOnHand*$units_sold; //COST OF GOOD SOLD $queryAvg = "SELECT AVG(qty_on_hand) AS avg_on_hand FROM `parts_timeline` WHERE `partno` = '" . $partno . "' AND dateChange > " . $timeYear . ";"; $resultAvg = mysqli_query($db,$queryAvg); $rowAvg = mysqli_fetch_array($resultAvg); $on_hand_avg = $rowAvg["avg_on_hand"]; if($on_hand_avg > 0) { //echo "on_hand_avg = " . $on_hand_avg . " * costOnHand = " . $costOnHand; $avg_inv_cost = $on_hand_avg * $costOnHand; //Average Inv Costs $earnNturn = $gross_margin * ($cogs_sold / $avg_inv_cost); } else { $onHandMessage = "NO AVERAGE ON HAND"; } } else { $costMessage = "NO COST INFORMATION"; } //echo "
" . $partid . " EN= " . $earnNturn . " = " . "GROSSMARGIN(" . $gross_margin . ") * (COGS" . $cogs_sold . " / " . $avg_inv_cost . " AVG INV)"; //******************* END EARN & TURN ******************************/ ?>
China -
Order Type -
CLOSEOUT!"; if($grade != "") echo "
" . $grade . ""; if ($organization != "US") { echo "
Qty on Hand: " . $qty_on_hand . ""; } if ($organization == "US") { if($myrow["active"] == '0') { echo "
DISCONTINUED!"; echo '
[remove from discontinued »]'; } else { echo '
[set as discontinued »]'; } if($myrow["To_order"] == '0') { echo "
NOT TO ORDER!"; echo '
[reset to order »]'; } else { echo '
[set not to order »]'; } } ?>
0) { $flag = "#1c9327; font-weight:bold;"; } else { $recomended_qty = 0; $flag = "#000000"; } ?> Qty on Order: Received: Remaining:
Days left with on Order:
Days in Inv.: ARS: To Order: OUT OF STOCK ARS: " . $sum_sold_ars . "/" . $countDaysARS; } $query3 = "SELECT `shipid`, `qty`, `qtyRec`, `dateRec` FROM `shipment_line` WHERE partid = '" . $partid2 . "' ORDER BY `lineid` DESC;"; $qty_change = $qty_on_hand; $sum_inv_days = 0; $total_inv_qty = 0; $orderResult = mysqli_query($db,$query3); while ($row = mysqli_fetch_array($orderResult, MYSQLI_NUM)) { $shipid = $row[0]; $shipqty = $row[1]; $qtyRec = $row[2]; $shipRec = $row[3]; if ($shipRec != "") { $myShipRec = DateTime::createFromFormat('m-d-Y', $shipRec); $newDateString = $myShipRec->format('Y-m-d'); $timeRec = strtotime($newDateString); $days_ago = number_of_days($timeNow,$timeRec); //AVG INVENTORY DAYS if($qty_change > 0) { if ($qty_change >= $qtyRec) { $sum_inv_days += $qtyRec*$days_ago; $total_inv_qty += $qtyRec; $qty_change -= $qtyRec; } else { $sum_inv_days += $qty_change*$days_ago; $total_inv_qty += $qty_change; $qty_change = 0; } } /* echo "Date Rec: " . $newDateString . "
"; echo "Days ago: " . $days_ago . "
"; */ } } if($total_inv_qty > 0) { $avg_inventory_days = round($sum_inv_days / $total_inv_qty); echo "
AVG INV. DAYS: " . $avg_inventory_days . "
"; } else echo "
NO AVG INV. DAYS DATA
"; } ?>
font-size:10px; font-weight:bold;">Earn & Turn: " . $onHandMessage; } } else { echo "font-size:10px; font-weight:bold;\">" . $costMessage; } ?>
');">
![](files/thumb/<? echo $myrow["artimage"]; ?>)
Total Qty. Sold: " . $units_sold . ""; ?> - $
Stock days left:
Qty Available: " . $qty_available . ""; echo "
Qty Clipped: " . $qty_clipped . ""; echo "
Qty In Office: " . $qty_accept . ""; echo " Dollars in Inventory: $" . round($cost_part*$qty_on_hand,2) . ""; if($myrow["outofstock"] == '1') { echo "
OUT OF STOCK BY VENDOR!"; echo '
[mark back in stock »]'; } else { echo '
[set vendor out of stock »]'; } if ($partno != "") { mysqli_select_db($db,$dbname2); //OR SKU LIKE '" . $partno . "-%' $countMadeToOrder = 0; $queryCountMO = "SELECT SUM(qty) FROM `fullfilment` WHERE (`SKU` = '" . $partno . "' OR SKU LIKE '" . $partno . "-%') AND `SKU` NOT LIKE 'SPECIAL-ORDER%' AND `status` = 'Made to Order';"; // GROUP BY `SKU` $resultCountMO = mysqli_query($db,$queryCountMO); $rowCountMO = mysqli_fetch_array($resultCountMO); //echo $queryCount; $countMadeToOrder = $rowCountMO[0]; if (substr($partno,0,3) == 'FR-' || substr($partno,0,4) == 'GALW') $queryCount = "SELECT SUM(qty) FROM `fullfilment` WHERE (`SKU` = '" . $partno . "' OR SKU LIKE '%-" . $partno . "') AND (`status` = 'Backorder' OR `status` = 'Frame Backorder');"; // GROUP BY `SKU` else $queryCount = "SELECT SUM(qty) FROM `fullfilment` WHERE (`SKU` = '" . $partno . "' OR SKU LIKE '" . $partno . "-%') AND (`status` = 'Backorder' OR `status` = 'Frame Backorder');"; // GROUP BY `SKU` $resultCount = mysqli_query($db,$queryCount); $rowCount = mysqli_fetch_array($resultCount,MYSQLI_NUM); //echo $queryCount; $countBackorder = $rowCount[0]; if ($countBackorder > 0) echo "
![](\"images/alert.png\")
" . $countBackorder . " On Backorder!";
if ($countMadeToOrder > 0)
echo "![](\"images/made-to-order.png\")
" . $countMadeToOrder . " On Made to Order!";
$now = time();
if (substr($partno,0,3) == 'FR-' || substr($partno,0,4) == 'GALW')
{
$checkTable = "frameSKU";
$wildcard = "%";
$operator = "LIKE";
}
else
{
$checkTable = "artSKU";
$wildcard = "";
$operator = "=";
}
$queryCount = "SELECT SUM(qty) FROM `eventItems` LEFT JOIN `saleEvents` ON `eventItems`.`eventID` = `saleEvents`.`eventID` WHERE `$checkTable` $operator '" . $partno . "$wildcard' AND `saleEvents`.`DateEnd` > $now;";
//AND `saleEvents`.`Type` <> '6' - removes myhabit...
//echo $queryCount;
$resultCount = mysqli_query($db,$queryCount);
$rowCount = mysqli_fetch_array($resultCount,MYSQLI_NUM);
//echo $queryCount;
$countEventItems = $rowCount[0];
if ($countEventItems > 0)
echo "";
mysqli_select_db($db,$dbname3);
/*$queryCount = "SELECT SUM(qty) AS sumQty,SUM(qtyReceived) AS sumRec FROM `amazonvOrders` WHERE `SKU` LIKE '" . $partno . "%' AND `qty` > `qtyReceived`";*/
$queryCount = "SELECT SUM(qtyConfirmed) AS sumQty,SUM(qtyReceived) AS sumRec,SUM(qtyShipped) AS sumShip,SUM(qtyCanceled) AS sumCancel FROM `amazonvOrders` WHERE `SKU` LIKE '%" . $partno . "%' AND `qtyConfirmed` > ( `qtyReceived` + `qtyShipped` + `qtyCanceled` ) ";
//echo $queryCount;
$resultCount = mysqli_query($db,$queryCount);
$rowCount = mysqli_fetch_array($resultCount,MYSQLI_NUM);
//echo $queryCount;
$countAmazonOrder = $rowCount[0];
$countAmazonRec = $rowCount[1];
$countAmazonShip = $rowCount[2];
$countAmazonCancel = $rowCount[3];
$countAmazonItems = $countAmazonOrder - ($countAmazonRec + $countAmazonShip + $countAmazonCancel);
if ($countAmazonItems > 0)
echo "";
mysqli_select_db($db,$dbname);
}
?>
![](\"images/clock.svg\")
![](\"images/amazon.png\")
0) { echo "Message Board:
"; echo "
";
}
// Now we are getting our results and making them an array
while($r = mysqli_fetch_array($resultM,MYSQLI_ASSOC)) {
if(!isset($r["posted"]) ) {
$r["posted"] = '';
}
if(isset($r["posted"]) && !empty($r["posted"])){
$posted = date("jS M Y h:i",$r["posted"]);
}
else{
$posted = '';
$r["posted"] = '';
}
if(!isset($r["question"] ) ) {
$r["question"] = '';
}
if(!isset($r["answer"] ) ) {
$r["answer"] = '';
}
$i == 0 ? $color = "#293b74" : $color = "#AE0011";
$i == 0 ? $i = 1 : $i = 0;
if ($r["question"] == "Yes") $color = "#0d9d09";
// Everything within the two curly brackets can read from the database using $r[]
// We need to convert the UNIX Timestamp entered into the database for when a thread...
// ... is posted into a readable date, using date().
// Now this shows the thread with a horizontal rule after it.
echo "$r[message]
Posted by $r[author] on $posted"; if ($r["question"] == "Yes" && $r["answer"] == "" ) echo " Open Question!!!"; echo "
"; // End of Array } if (mysqli_num_rows($resultM) > 0) { echo "
";
}
}
?>
Posted by $r[author] on $posted"; if ($r["question"] == "Yes" && $r["answer"] == "" ) echo " Open Question!!!"; echo "
"; // End of Array } if (mysqli_num_rows($resultM) > 0) { echo "
"; if($myrow["onBestSeller"] == '1') echo "Best Seller!
"; if($myrow["onNewArrival"] == '1') echo "On New Arrivals!
"; if($myrow["onHotDeal"] == '1') echo "On Hot Deals!
"; echo $myrow["paintingname"] . "
Location Site/Bin: " . $site . " / " . $bin1 . " | " . $bin2 . " | " . $bin3 . ""; ?>
Part Type:
Manuafaturing Days:
' . $myrow["CountDays"] . ' Days'; ?>
Preferred Vendor: ' . $supplier . '
'; echo "[See Suggested Price]
"; $queryTopStack = "SELECT pnchina FROM parts WHERE partno = '" . $myrow["partno"] . "' ;"; //echo $queryTopStack; $stackCount = 1; $stackTopResult = mysqli_query($db,$queryTopStack); while ($rowTopStack = mysqli_fetch_array($stackTopResult, MYSQLI_ASSOC)) { $pnchinaTop = $rowTopStack["pnchina"]; $queryStack = "SELECT FrameSKU, MoldingSKU FROM StackFrames WHERE MoldingSKU = '" . $pnchinaTop . "' ;"; //echo $queryStack; $stackResult = mysqli_query($db,$queryStack); while ($rowStack = mysqli_fetch_array($stackResult, MYSQLI_ASSOC)) { $stackFrame = $rowStack["FrameSKU"]; if($stackCount == 1) echo "Part of Stack Frames:
" . $stackFrame . "
"; else echo "" . $stackFrame . "
"; $stackCount++; } } if($myrow["Feet"] > 0) { echo 'Cost of Item:
$' . $costPart; echo "
Feet per Box: " . $myrow["Feet"]; echo "
Cost of Box: $" . number_format(($costPart*$myrow["Feet"]),2,'.',','); } else echo 'Cost of Item:
$' . $cost_part; if($myrow["FrameWidth"] > 0) { echo "
Frame Width: " . $myrow["FrameWidth"]; } ?>
" . $orderName . "
" . $supplier . "
Qty: " . $qty . "
Cost: $" . $cost . "
"; if ($status != "Closed" && $status != "Cancelled") $status_color = "#ae0011"; else $status_color = "#000000"; echo "Status:
" . $status . ""; if ($status == "Shipped") { $query3 = "SELECT * FROM shipment_line AS sl LEFT JOIN shipment AS s ON sl.shipid = s.shipid WHERE orderline_id ='" . $lineid . "';"; // echo $query3; $oResult2 = mysqli_query($db,$query3); while($row2 = mysqli_fetch_array($oResult2,MYSQLI_ASSOC)) { $qtyShipped += $row2["qty"]; } if ($qty <= $qtyShipped) $status_shipped = "Completely Shipped"; //else if ($qtyOn <= ($qtyShipped + $qtyReceived)) $status_shipped = "Completely Shipped"; else { $qtyRemain = $qty - $qtyShipped; $status_shipped = "Partial Shipped"; } echo "
(" . $status_shipped . ")"; if($qtyRemain > 0) echo "
Qty Remaining: " . $qtyRemain . ""; } echo "
"; } ?>
" . $supplier . "
Qty: " . $qty . "
Cost: $" . $cost . "
"; if ($status != "Closed" && $status != "Cancelled") $status_color = "#ae0011"; else $status_color = "#000000"; echo "Status:
" . $status . ""; if ($status == "Shipped") { $query3 = "SELECT * FROM shipment_line AS sl LEFT JOIN shipment AS s ON sl.shipid = s.shipid WHERE orderline_id ='" . $lineid . "';"; // echo $query3; $oResult2 = mysqli_query($db,$query3); while($row2 = mysqli_fetch_array($oResult2,MYSQLI_ASSOC)) { $qtyShipped += $row2["qty"]; } if ($qty <= $qtyShipped) $status_shipped = "Completely Shipped"; //else if ($qtyOn <= ($qtyShipped + $qtyReceived)) $status_shipped = "Completely Shipped"; else { $qtyRemain = $qty - $qtyShipped; $status_shipped = "Partial Shipped"; } echo "
(" . $status_shipped . ")"; if($qtyRemain > 0) echo "
Qty Remaining: " . $qtyRemain . ""; } echo "
"; } ?>
" . $shipName ."
" . $supplier . "
Qty: " . $shipqty . "
"; echo "Status: " . $completed . "
"; if ($shipRec != "") { echo $shipRec . "
"; } else echo "
"; /* if ($shipRec != "") { $myShipRec = DateTime::createFromFormat('m-d-Y', $shipRec); $newDateString = $myShipRec->format('Y-m-d'); $timeRec = strtotime($newDateString); $days_ago = number_of_days($timeNow,$timeRec); //AVG INVENTORY DAYS if($qty_change > 0) { if ($qty_change >= $qtyRec) { $sum_inv_days += $qtyRec*$days_ago; $total_inv_qty += $qtyRec; $qty_change -= $qtyRec; } else { $sum_inv_days += $qty_change*$days_ago; $total_inv_qty += $qty_change; $qty_change = 0; } } echo "Date Rec: " . $newDateString . "
"; echo "Days ago: " . $days_ago . "
"; } else echo "
";*/ } /*$avg_inventory_days = round($sum_inv_days / $total_inv_qty); echo "AVG INV. DAYS: " . $avg_inventory_days . "
";*/ ?>
" . $supplier . "
Qty: " . $shipqty . "
"; echo "Status: " . $completed . "
"; if ($shipRec != "") { echo $shipRec . "
"; } else echo "
"; /* if ($shipRec != "") { $myShipRec = DateTime::createFromFormat('m-d-Y', $shipRec); $newDateString = $myShipRec->format('Y-m-d'); $timeRec = strtotime($newDateString); $days_ago = number_of_days($timeNow,$timeRec); //AVG INVENTORY DAYS if($qty_change > 0) { if ($qty_change >= $qtyRec) { $sum_inv_days += $qtyRec*$days_ago; $total_inv_qty += $qtyRec; $qty_change -= $qtyRec; } else { $sum_inv_days += $qty_change*$days_ago; $total_inv_qty += $qty_change; $qty_change = 0; } } echo "Date Rec: " . $newDateString . "
"; echo "Days ago: " . $days_ago . "
"; } else echo "
";*/ } /*$avg_inventory_days = round($sum_inv_days / $total_inv_qty); echo "AVG INV. DAYS: " . $avg_inventory_days . "
";*/ ?>
" . date("jS M Y",$myrow["datePhoto"]) . "
SKU updated last by:
" . $myrow["lastUpdateBy"]; ?>
