public function addPart ($component_id, $part_quantity, $product_line, $component=0) {
//echo "$component_id, $part_quantity, $product_line, $component";
if (is_numeric($component_id) && is_numeric($part_quantity) && is_numeric($product_line) && is_numeric($component)) {
if ($component == 0) {
$part = new Part($component_id);
$description = $part->description;
$part_id = $part->id;
} elseif ($component == 1) {
$component = new Component($component_id);
$description = $component->tc_description;
$part_id = $component->assembly_or_part_id;
}
$sql = "
INSERT INTO order_parts (
order_id, part_id, quantity, product_line, description
) VALUES (
{$this->order_id},
{$part_id},
{$part_quantity},
{$product_line},
'{$description}'
)/* Order->addPart */";
$this->dataconn->f_ExecuteSql($sql);
$this->buildOrderStack();
}
}
<?
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;
}
}
require_once "../includes/classes/clsUnits.php";
require_once "../includes/classes/clsUnitsBrief.php";
require_once "../includes/generic_functions.php";
*/
$login = new Login();
$logged_in = $login->validate();
if (! $logged_in) {
header ("Location: index.php");
exit(0);
}
$message = $_GET["message"];
$dataconn = new DataConn("");
$sql2 = "
SELECT *
FROM `parts`
WHERE `product_line` = '10'";
$arr_data = $dataconn->f_ReturnArrayAssoc_TF($sql2);
if (!is_array($arr_data)) {
echo "No HPTC parts found";
exit;
}
$int_ubound = count($arr_data["parts.product_line"])-1;
echo "inserting $int_ubound records<BR><BR>\n";
for ($x=0;$x<=$int_ubound;$x++) {
$sql = "