Subversion Repositories public

<?

# Kapitelnummerierung :-)

#

# #snum enthaelt eine Nummer der Form x.y.z, wobei es beliebig viele Abschnitte

# geben kann.

#

# #level enthaelt den Level, also welche der Teilnummern veraendert werden soll.

#

# #dir enthaelt die Richtung in die veraendert werden soll, wobei 0 eins nach

# unten und 1 eins nach oben bedeutet. -1 bedeutet alle Ziffern groesser

# #level wegschneiden und die letzte Nummer erhoehen. -2 tut das selbe,

# reduziert jedoch die letzte Nummer. -3 bedeutet die Nummern gleich lassen,

# aber die Anzahl der Elemente an #level anpassen.

#

# #level zaehlt von 0 weg!

#

function kNumber($snum, $level, $dir) {

	$anz = str_wordcount($snum);

	$kpnum = $snum;

	# Haben wir weniger Einzelnummern im String, haengen wir ".1" so

	# lange an, bis wir #level erreicht haben.

	if ($anz <= $level) {

	   while ($anz <= $level) {

	      $kpnum .= ".1";

	      $anz++;

	   }

	   if ($dir == -3) {

	      return $kpnum;

	   }

	}

	$anz = $level + 1;

	$anum = explode(".", $kpnum);

	if ($dir < 0) {

	   if ($dir == -1) {

	      $anum[$level]++;

	   } else if ($dir == -2) {

	      $anum[$level]--;

	   }

	} else {

	   if ($dir == 0) {

	      $anum[$level]++;

	   } else {

	      $anum[$level]--;

	   }

	}

	$num = "";

	for ($i = 0; $i < $anz; $i++) {

	   if ($i > 0) {

	      $num .= "." . (string)$anum[$i];

	   } else {

	      $num = (string)$anum[$i];

	   }

	}

	return $num;

}

function SelectTask($pl_num, $id, $sel=0) {

	global $phase;

	global $numphase;

	$lodb = OpenDB();

	$loquery = "select ta_num, ta_name, ta_id, ta_level, ta_meeting,";

	$loquery .= "ta_phase from task where ta_plnum = $pl_num order by ta_id";

	$loresult = QueryDB($lodb, $loquery);

	if (!$loresult) {

	   closeDB($lodb);

	   return false;

	}

	$numrows = numrowsDB($loresult);

	$row = 0;

	$snum = "1";

	$olevel = 0;

	while ($row < $numrows) {

	   $data = fetchDB($loresult, $row);

	   $ta_num = $data[0];

	   $ta_name = $data[1];

	   $ta_id = $data[2];

	   $ta_level = $data[3];

	   $ta_meeting = $data[4];

	   $tphase = $data[5];

	   $loquery = "select ta_level from task where ";

	   $loquery .= "ta_plnum = $pl_num and ta_id > $ta_id order by ta_id";

	   $loresult2 = QueryDB($lodb, $loquery);

	   if (!$loresult2) {

	      closeDB($lodb);

	      return false;

	   }

	   $nr = numrowsDB($loresult2);

	   if ($nr > 0) {

	      $data = fetchDB($loresult2, 0);

	      $xlevel = $data[0];

	   } else {

	      $xlevel = $ta_level;

	   }

	   if ($olevel == 0) {

	      $level = 0;

	      $olevel = $ta_level;

	      $dir = -3;

	   } else if ($olevel < $ta_level) {

	      $level = $ta_level - 1;

	      $olevel = $ta_level;

	      $dir = -3;

	   } else if ($olevel == $ta_level) {

	      $level = $ta_level - 1;

	      $dir = 0;

	   } else if ($olevel > $ta_level) {

	      $level = $ta_level - 1;

	      $olevel = $ta_level;

	      $dir = -1;

	   }

	   $snum = kNumber ($snum, $level, $dir);

	   if ($phase == 1 && $numphase == 1 && isset($tphase)) {

	      $p = strpos($snum, ".");

	      if ($p === false)

	         $rest = "";

	      else

	         $rest = substr($snum, $p);

	      $snum = (string)$tphase . $rest;

	   }

	   if (!$ta_meeting && $ta_level > 1 && $xlevel <= $ta_level) {

	      if (!$id) {

	         echo "<option value=\"$ta_num\"";

		 $comp = $ta_num;

	      } else {

	         echo "<option value=\"$ta_id\"";

		 $comp = $ta_id;

	      }

	      if ($comp == $sel)

	         echo "selected";

	      echo ">$snum $ta_name</option>\n";

	   }

	   $row++;

	}

//	closeDB($lodb);

	return true;

}

function GetTaskNum($pl_num, $ta_id, $ta_level, $ta_phase, $ta_meeting, $snum, $typ, $db=-1) {

	global $phase;

	global $numphase;

	if (strlen($snum) <= 0)

	   $snum = "1";

	if ($db == -1)

	   $dbs = OpenDB();

	else

	   $dbs = $db;

	# Finde den naechsten Level

	$query = "select ta_level from task where ta_plnum = $pl_num and ";

	$query .= "ta_id > $ta_id order by ta_id";

	$result = QueryDB($dbs, $query);

	if (!$result) {

	   return false;

	}

	$numrows = numrowsDB($result);

	if ($numrows > 0) {

	   $data = fetchDB($result, 0);

	   $xlevel = $data[0];

	} else {

	   $xlevel = $ta_level;

	}

	# Finde den vorhergehenden Level

	$query = "select ta_level from task where ta_plnum = $pl_num and ";

	$query .= "ta_id < $ta_id order by ta_id desc";

	$result = QueryDB($dbs, $query);

	if (!$result) {

	   return false;

	}

	$numrows = numrowsDB($result);

	if ($numrows > 0) {

	   $data = fetchDB($result, 0);

	   $olevel = $data[0];

	} else {

	   $olevel = 0;

	}

	if ($olevel == 0) {

	   $level = 0;

	   $dir = -3;

	} else if ($olevel < $ta_level) {

	   $level = $ta_level - 1;

	   $dir = -3;

	} else if ($olevel == $ta_level) {

	   $level = $ta_level - 1;

	   $dir = 0;

	} else if ($olevel > $ta_level) {

	   $level = $ta_level - 1;

	   $dir = -1;

	}

	$kpnum = kNumber ($snum, $level, $dir);

	if ($phase == 1 && $numphase == 1 && isset($ta_phase) && $ta_phase >= 0) {

	   $p = strpos($kpnum, ".");

	   if ($p === false)

	      $rest = "";

	   else

	      $rest = substr($kpnum, $p);

	   $kpnum = (string)$ta_phase . $rest;

	}

	if (!$ta_meeting && $ta_level > 1 && $xlevel <= $ta_level)

	   $typ = true;

	else

	   $typ = false;

	if ($db == -1)

	   closeDB($dbs);

	return $kpnum;

}

?>