function CableType_Add($marking, $manufacturer, $tubeQuantity, $fiberPerTube, $tensileStrength, $diameter, $comment)
{
if (CableType_Check($marking, $manufacturer, $tubeQuantity, $fiberPerTube, $tensileStrength, $diameter, $comment) == 0) {
return 0;
}
$ins['marking'] = $marking;
$ins['manufacturer'] = $manufacturer;
$ins['tubeQuantity'] = $tubeQuantity;
$ins['fiberPerTube'] = $fiberPerTube;
$ins['tensileStrength'] = $tensileStrength;
$ins['diameter'] = $diameter;
$ins['comment'] = $comment;
$res = CableType_INSERT($ins);
if (isset($res['error'])) {
return $res;
}
CableLine_AddOpticalFiberForAll();
return 1;
}
function addCableLinePoint($coors, $CableType, $length, $name, $comment, $tmpT = FALSE)
{
if ($length == "") {
$ins['length'] = "NULL";
} else {
$ins['length'] = floatval(str_replace(',', '.', $length)) * 100;
}
$ins['CableType'] = $CableType;
$ins['name'] = $name;
$ins['comment'] = $comment;
$query = 'INSERT INTO "' . tmpTable('CableLine', $tmpT) . '"' . genInsert($ins) . ' RETURNING id';
$res = PQuery($query);
$CableLine = $res['rows'][0]['id'];
$seq = 1;
unset($ins);
for ($i = 0; $i < count($coors); $i++) {
$coor = "(" . $coors[$i]->lon . "," . $coors[$i]->lat . ")";
$ins['OpenGIS'] = $coor;
$ins['sequence'] = $seq++;
$ins['CableLine'] = $CableLine;
$query = 'INSERT INTO "' . tmpTable('CableLinePoint', $tmpT) . '"' . genInsert($ins);
PQuery($query);
}
CableLine_AddOpticalFiberForAll();
}