"; $k = 0; $resultDays = mysql_query($queryDays); $totalRows = mysql_num_rows($resultDays); //echo "Total rows: " . $totalRows . "
"; //checking if new product... $queryDaysBf = "SELECT * FROM `parts_timeline` WHERE partno ='" . $partno . "' AND dateChange < $timeYear ORDER BY dateChange ASC;"; //$timeSixMonths $resultDaysBf = mysql_query($queryDaysBf); $totalRowsBf = mysql_num_rows($resultDaysBf); while($rowDays = mysql_fetch_array($resultDays)) { $qty_timeline = $rowDays["qty_on_hand"]; $dateOnCheck = $rowDays["dateChange"]; //echo "row #: " . $k . "
"; $k++; if ($markFirst != 1) { $markFirst = 1; //tag that the first has been recorded if ($qty_timeline > 0 && $k >= $totalRows) { if ($totalRowsBf > 0) //if not new product then count back... { $countDays += number_of_days($timeNow,$timeYear); //if poistive then count all the way until now -$timeSixMonths for 6 month change //echo "days: " . $countDays . "
"; } $priorDay = $dateOnCheck; } else if ($qty_timeline > 0) { if ($totalRowsBf > 0) //if not new product then count back... { $countDays += number_of_days($dateOnCheck,$timeYear); //$timeSixMonths for 6 month change //echo "days: " . $countDays . "
"; } $priorDay = $dateOnCheck; } else { $noCount = 1; } continue; } if ($k >= $totalRows && $noCount == 0) { if ($qty_timeline > 0) { $countDays += number_of_days($timeNow,$priorDay); //if poistive then count all the way until now // echo "days: " . $countDays . "
"; } else { $countDays += number_of_days($dateOnCheck,$priorDay); //if none on hand then count days up to that point } continue; } if ($qty_timeline > 0 && $noCount == 1) //start counting the days when back to on hand positive { $priorDay = $dateOnCheck; $noCount = 0; } else if ($qty_timeline <= 0 && $noCount == 0) //count the days on change to 0 { $countDays += number_of_days($dateOnCheck,$priorDay); $noCount = 1; } } //echo "total days: " . $countDays . "
"; //$units_sold_6m = $units_sold/2; //find the average sales in the past 6 months //echo $units_sold_6m . "
"; //$ARS = $units_sold_6m/$countDays; if($countDays > 0) $ARS = $units_sold/$countDays; else $ARS = 0; //echo $ARS . "
"; 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 = mysql_query($queryAvg); $rowAvg = mysql_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 -
CLOSEOUT!"; if($myrow["active"] == '0') { echo "
DISCONTINUED!"; echo '
[remove from discontinued »]'; } else { echo '
[set as discontinued »]'; } ?>
0) { $flag = "#1c9327; font-weight:bold;"; } else { $recomended_qty = 0; $flag = "#000000"; } ?> Qty on Order: Received: Remaining:
Days left with on Order:
INV. Days: ARS: To Order:
font-size:10px; font-weight:bold;">Eearn & Turn: " . $onHandMessage; } } else { echo "font-size:10px; font-weight:bold;\">" . $costMessage; } ?>
');">
![](files/thumb/<? echo $myrow["artimage"]; ?>)
Total Qty. Sold: " . $units_sold . ""; ?> - $
0) { echo "Message Board:
"; echo "
";
}
// Now we are getting our results and making them an array
while($r = mysql_fetch_array($resultM)) {
$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().
$posted = date("jS M Y h:i",$r[posted]);
// 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 (mysql_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 (mysql_num_rows($resultM) > 0) { echo "
Part Type:
Manuafaturing Days:
' . $myrow["CountDays"] . ' Days'; ?>
$' . $cost_part . ' ' . $cost_part_rmb . 'RMB'; ?>
" . $orderName . "
" . $supplier . "
Qty: " . $qty . "
Cost: " . $cost . "
"; if ($status != "Closed") $status_color = "#ae0011"; else $status_color = "#000000"; echo "Status:
" . $status . "
"; } ?>
" . $supplier . "
Qty: " . $qty . "
Cost: " . $cost . "
"; if ($status != "Closed") $status_color = "#ae0011"; else $status_color = "#000000"; echo "Status:
" . $status . "
"; } ?>
" . $shipName ."
" . $supplier . "
Qty: " . $shipqty . "
"; echo "Status: " . $completed . "
"; } ?>
" . $supplier . "
Qty: " . $shipqty . "
"; echo "Status: " . $completed . "
"; } ?>
" . date("jS M Y",$myrow["datePhoto"]) . "
by:
" . $myrow["lastUpdateBy"]; ?>
