protected function buildOrderStack () {
//delete parts that have a quantity of zero
$sql = "DELETE FROM order_parts WHERE quantity = 0/* Order->buildOrderStack */";
$this->dataconn->f_ExecuteSql($sql);
//get the rest of the parts for this order from the database
$sql = "
SELECT
`order_parts`.`id`, `order_parts`.`part_id`, `order_parts`.`quantity`,
`order_parts`.`product_line`, `order_parts`.`description`
FROM order_parts
WHERE order_id = {$this->order_id}/* Order->buildOrderStack */";//odd syntax with { and }
$arrOrderParts = $this->dataconn->f_ReturnArrayAssoc_TF($sql);
//echo "<pre>";
//var_dump($arrOrderParts);
//echo "</pre>";
$count = count($arrOrderParts['order_parts.id']);
$this->order_stack = new OrderStack();
for ($x=0; $x <= $count-1; $x++) {
$this->order_stack->addPart($arrOrderParts['order_parts.part_id'][$x],
$arrOrderParts['order_parts.product_line'][$x],
$arrOrderParts['order_parts.quantity'][$x],
$arrOrderParts['order_parts.id'][$x],
$arrOrderParts['order_parts.description'][$x] );
}
}
<?
require_once "clsDataConn.php";
$dataconn = new DataConn("");
$sqlTemp = "SELECT `make` FROM `makes` WHERE 1";
$arr_data = $dataconn->f_ReturnArrayAssoc_TF($sqlTemp);
if (is_array($arr_data["makes.make"])) {
var_dump($arr_data);
} else {
echo "not an array";
}
?>
function moveAssembly ($unit_id,$unit_component_id,$direction) {
$dataconn = new DataConn("");
//get the assemblies in the unit_components table in order
$sql = "
SELECT id,assembly_or_part_id,display_order
FROM unit_components
WHERE unit_id = '".mysql_real_escape_string($unit_id)."'
AND component_type = 1
ORDER BY display_order";
$arr_data = $dataconn->f_ReturnArrayAssoc_TF($sql);
if (!is_array($arr_data)) {
return -1;
}
//find the ordinal of the assembly we are moving
$int_num_assemblies = count($arr_data["unit_components.id"])-1;
echo "int_num_assemblies: _".$int_num_assemblies."_<BR>\n";
for ($x=0;$x<=$int_num_assemblies;$x++) {
echo "x: _".$x."_<BR>\n";
echo "x: _".$arr_data["unit_components.id"][$x]."_ and _".$unit_component_id."_<BR>\n";
if ($arr_data["unit_components.id"][$x] == $unit_component_id) {
$position_current = $x;
break;//terminate the for loop
}
}
//terminate if moving up and its already first or vice versa
if ( ($position_current == 0 && $direction == "up") || ($position_current == $int_num_assemblies && $direction == "down") ) {
return -1;
}
//swap the two items
if ($direction == "up") {
$sql = "
UPDATE unit_components SET
display_order = '".mysql_real_escape_string($arr_data["unit_components.display_order"][$x-1])."'
WHERE id = '".mysql_real_escape_string($arr_data["unit_components.id"][$x])."'";
$ignore_return = $dataconn->f_ExecuteSql($sql);
$sql = "
UPDATE unit_components SET
display_order = '".mysql_real_escape_string($arr_data["unit_components.display_order"][$x])."'
WHERE id = '".mysql_real_escape_string($arr_data["unit_components.id"][$x-1])."'";
$ignore_return = $dataconn->f_ExecuteSql($sql);
} elseif ($direction == "down") {
$sql = "
UPDATE unit_components SET
display_order = '".mysql_real_escape_string($arr_data["unit_components.display_order"][$x+1])."'
WHERE id = '".mysql_real_escape_string($arr_data["unit_components.id"][$x])."'";
$ignore_return = $dataconn->f_ExecuteSql($sql);
$sql = "
UPDATE unit_components SET
display_order = '".mysql_real_escape_string($arr_data["unit_components.display_order"][$x])."'
WHERE id = '".mysql_real_escape_string($arr_data["unit_components.id"][$x+1])."'";
$ignore_return = $dataconn->f_ExecuteSql($sql);
} else {
return -1;
}
//echo "position_current: _".$position_current."_<BR>\n";
//exit;
}
function getFeaturedPart ($productLine = 3)
{
$dataconn = new DataConn("");
$sql = "
SELECT part_id
FROM parts_featured
WHERE product_line_id = '".mysql_real_escape_string($productLine)."'
ORDER BY part_id";
$arr_data = $dataconn->f_ReturnArrayAssoc_TF($sql);
if (is_array($arr_data)) {
$uBound = count($arr_data["parts_featured.part_id"]) - 1;
$position_to_return = rand(0,$uBound);
$Part = new Part($arr_data["parts_featured.part_id"][$position_to_return]);
return $Part;
} else {
return NULL;
}
}
