function insertPtsComponent ($get) {
$dataconn = new DataConn("");
//creat the phantom unit name
$unit_name = $get["driveline_series"]." x ".$get["steel_driveshaft_tube_od"];
//lookup the phantom unit (and create it if it doesn't exist)
$sql = "
SELECT id
FROM units
WHERE name = '".mysql_real_escape_string($unit_name)."'
AND product_line = 9";
$arr_data = $dataconn->f_ReturnArrayAssoc_TF($sql);
if (is_array($arr_data)) {
$unit_id = $arr_data["units.id"][0];
} else {
$unit_id = createUnit("9",$unit_name,"",0,0);
}
//creat the new entry in the unit components table
$sql = "
INSERT INTO unit_components
(unit_id, component_type, assembly_or_part_id, display_order,
indent, code_on_ref_figure, notes, pts_series, driveline_series,
steel_driveshaft_tube_od, torque_fuse_options, description)
VALUES (
'".mysql_real_escape_string($unit_id)."',
'0',
'".mysql_real_escape_string($get["part_id"])."',
'".mysql_real_escape_string($get["display_order"])."',
'".mysql_real_escape_string($get["indent"])."',
'".mysql_real_escape_string($get["code_on_ref_figure"])."',
'".mysql_real_escape_string($get["notes"])."',
'".mysql_real_escape_string($get["pts_series"])."',
'".mysql_real_escape_string($get["driveline_series"])."',
'".mysql_real_escape_string($get["steel_driveshaft_tube_od"])."',
'".mysql_real_escape_string($get["torque_fuse_options"])."',
'".mysql_real_escape_string($get["description"])."'
)";
return $dataconn->f_ExecuteSqlInsertID($sql);
}
'".mysql_real_escape_string($arr_data["parts.instructions"][$x])."', '".mysql_real_escape_string($arr_data["parts.tech"][$x])."', '".mysql_real_escape_string($arr_data["parts.vbfix"][$x])."', '".mysql_real_escape_string($arr_data["parts.product_line_from_ts_file"][$x])."', '".mysql_real_escape_string($arr_data["parts.oem_part_number"][$x])."', '".mysql_real_escape_string($arr_data["parts.part_summary"][$x])."', '".mysql_real_escape_string($arr_data["parts.part_type"][$x])."', '".mysql_real_escape_string($arr_data["parts.tube_diameter"][$x])."', '".mysql_real_escape_string($arr_data["parts.steel_driveshaft_tube_od"][$x])."', '".mysql_real_escape_string($arr_data["parts.torque_fuse_options"][$x])."', '".mysql_real_escape_string($arr_data["parts.no_of_teeth"][$x])."', '".mysql_real_escape_string($arr_data["parts.outer_diameter"][$x])."', '".mysql_real_escape_string($arr_data["parts.inner_diameter"][$x])."', '".mysql_real_escape_string($arr_data["parts.pitch"][$x])."', '".mysql_real_escape_string($arr_data["parts.thick"][$x])."', '".mysql_real_escape_string($arr_data["parts.chamfer"][$x])."', '".mysql_real_escape_string($arr_data["parts.pts_series"][$x])."', '".mysql_real_escape_string($arr_data["parts.driveline_series"][$x])."', '".mysql_real_escape_string($arr_data["parts.weight"][$x])."' /* Part->insertNew */)"; echo $sql . "<BR>\n"; $return_value = $dataconn->f_ExecuteSqlInsertID($sql); echo $return_value."<HR>\n"; } echo "done"; exit; ?>
