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();
		}
	}
예제 #2
0
<?
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 = "