Create New Oil Painting
$timeYear ORDER BY dateChange ASC;"; //echo $queryDays . "
"; $k = 0; $resultDays = mysqli_query($db,$queryDays); $totalRows = mysqli_num_rows($resultDays); //echo "Total rows: " . $totalRows . "
"; $qtyTimeLine[] = array('0'); $timeLine[] = array('0'); while($rowDays = mysqli_fetch_array($resultDays,MYSQLI_ASSOC)) { if (in_array('date("m.d.y",$rowDays["dateChange"])', $timeLine,true)) { continue; } else { $qtyTimeLine[$k] = $rowDays["qty_on_hand"]; $timeLine[$k] = date("m.d.y",$rowDays["dateChange"]); $k++; } } //********************* INVENTORY DAYS ************************* // echo '

testing:' . print_r($qtyTimeLine, true) . '

'; /* $ochart = new chart(650,338,5, '#eeeeee'); $ochart->setTitle("On Hand in Last 6 Months","#000000",4); $ochart->setPlotArea(SOLID,"#444444", '#dddddd'); $ochart->setFormat(0,',','.'); $ochart->addSeries($qtyTimeLine,'area','Qty on Hand over Time', SOLID,'#000000', '#293B74'); $ochart->setXAxis('#000000', SOLID, 2, "6 Months Time"); $ochart->setYAxis('#000000', SOLID, 2, "Qty On Hand Level"); $ochart->setLabels($timeLine, '#000000', 1, VERTICAL); $ochart->setGrid("#bbbbbb", DASHED, "#bbbbbb", DOTTED); $ochart->plot('chart/' . $partid . '.png'); createthumbpng('chart/' . $partid . '.png','chartSmall/' . $partid . '.png',250,130);*/ //echo "SELECT * FROM parts WHERE partid=$partid LIMIT 1"; $result2 = mysqli_query($db,"SELECT * FROM parts WHERE partid=$partid LIMIT 1;"); ?>

Oil Paintings

$timeYear ORDER BY dateChange ASC;"; //echo $queryDays . " "; $k = 0; $resultDays2 = mysqli_query($db,$queryDays2); $totalRows2 = mysqli_num_rows($resultDays2); //echo "Total rows: " . $totalRows . " "; //Create an XML data document in a string variable $strXML = ""; $strXML .= ""; while($rowDays2 = mysqli_fetch_array($resultDays2,MYSQLI_ASSOC)) { if ($k == 0) { $timeLine = array(date("F j, Y",$timeYear)); $qtyTimeLine = array($rowDays2["qty_on_hand"]); $strXML .= ""; $k++; } $dateCheck = date("F j, Y",$rowDays2["dateChange"]); if (in_array($dateCheck, $timeLine)) { continue; } else { $qtyTimeLine[$k] = $rowDays2["qty_on_hand"]; $timeLine[$k] = date("F j, Y",$rowDays2["dateChange"]); $strXML .= ""; $k++; } } $strXML .= ""; //Create the chart - Column 3D Chart with data from strXML variable using dataXML method //echo $strXML; echo renderChartHTML("FusionCharts/Charts/FCF_Area2D.swf", "", $strXML, "QtyOnHand", 650, 338); ?>

$timeYear ORDER BY dateChange ASC;"; //echo $queryDays . " "; $k = 0; $resultDays2 = mysqli_query($db,$queryDays2); $totalRows2 = mysqli_num_rows($resultDays2); //echo "Total rows: " . $totalRows . " "; //Create an XML data document in a string variable $strXML = ""; $strXML .= ""; while($rowDays2 = mysqli_fetch_array($resultDays2,MYSQLI_ASSOC)) { if ($k == 0) { $timeLine = array(date("F j, Y",$timeYear)); $qtyTimeLine = array($rowDays2["units_sold"]); $strXML .= ""; $k++; } $dateCheck = date("F j, Y",$rowDays2["dateChange"]); if (in_array($dateCheck, $timeLine)) { continue; } else { $qtyTimeLine[$k] = $rowDays2["units_sold"]; $timeLine[$k] = date("F j, Y",$rowDays2["dateChange"]); $strXML .= ""; $k++; } } $strXML .= ""; //Create the chart - Column 3D Chart with data from strXML variable using dataXML method //echo $strXML; echo renderChartHTML("FusionCharts/Charts/FCF_Area2D.swf", "", $strXML, "QtyOnHand", 650, 338); ?>

$timeYear ORDER BY dateChange ASC;"; //echo $queryDays . " "; $k = 0; $resultDays2 = mysqli_query($db,$queryDays2); $totalRows2 = mysqli_num_rows($resultDays2); //echo "Total rows: " . $totalRows . " "; //Create an XML data document in a string variable $strXML = ""; $strXML .= ""; while($rowDays2 = mysqli_fetch_array($resultDays2,MYSQLI_ASSOC)) { if ($k == 0) { $timeLine = array(date("F j, Y",$timeYear)); $qtyTimeLine = array($rowDays2["qty_sold"]); $strXML .= ""; $k++; } $dateCheck = date("F j, Y",$rowDays2["dateChange"]); if (in_array($dateCheck, $timeLine)) { continue; } else { $qtyTimeLine[$k] = $rowDays2["qty_sold"]; $timeLine[$k] = date("F j, Y",$rowDays2["dateChange"]); $strXML .= ""; $k++; } } $strXML .= ""; //Create the chart - Column 3D Chart with data from strXML variable using dataXML method //echo $strXML; echo renderChartHTML("FusionCharts/Charts/FCF_Area2D.swf", "", $strXML, "DailySales", 650, 338); ?>