function adddata()
{
db_connect();
$maxidemployee = mysql_query("SELECT MAX(id_employee) AS maximum FROM employee");
$maxidemployee = mysql_fetch_array($maxidemployee);
$newidemp = $maxidemployee[maximum] + 1;
$maxidpost = mysql_query("SELECT MAX(id_post) AS maxpost FROM post");
$rang = mysql_query("SELECT id_post, rang FROM post ORDER BY id_post");
$prev = 0;
$j = 0;
$i = 0;
while ($ran = mysql_fetch_array($rang)) {
if ($i >= 1) {
$prev = $curr;
}
$curr = $ran[rang];
if ($prev != $curr) {
$rangmass[] = $ran[id_post];
$j++;
}
$i++;
}
$queryinsert = "INSERT INTO `employee` (`id_employee`, `fio`, `id_post`,`datestart`,`salary`, `id_boss`, `counter`) \n VALUES (" . $newidemp . ", 'Сотрудник1', " . $rangmass[0] . ", '" . gen_data() . "'," . rand(10900, 15000) . ",0,100)";
$idbossstart = $newidemp + 1;
//rang 2
for ($i = 2; $i < 102; $i++) {
$str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[1], $rangmass[2] - 1) . ", '" . gen_data() . "'," . rand(8000, 10000) . "," . ($idbossstart - 1) . ",1)";
}
$idbossend = $newidemp;
//rang 3
for ($i; $i < 603; $i++) {
$str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[2], $rangmass[3] - 1) . ", '" . gen_data() . "'," . rand(6000, 8000) . "," . rand($idbossstart, $idbossend) . ",1)";
}
//rang 4
$idbossstart = $idbossend;
$idbossend = $newidemp;
for ($i; $i < 903; $i++) {
$str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[3], $rangmass[4] - 1) . ", '" . gen_data() . "'," . rand(5000, 7000) . "," . rand($idbossstart, $idbossend) . ",1)";
}
//rang 5
$idbossstart = $idbossend;
$idbossend = $newidemp;
for ($i; $i < 1500; $i++) {
$str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[4], $maxidpost[maxpost]) . ", '" . gen_data() . "'," . rand(5000, 7000) . "," . rand($idbossstart, $idbossend) . ",1)";
}
$queryinsert .= $str_1;
mysql_query($queryinsert);
if (mysql_errno() == 0) {
echo "<p class='resultadd'>Данные успешно добавлены</p>";
} else {
echo "<p class='resultadd'>" . mysql_errno() . "</p>";
}
}
require_once 'config.php';
// require_once 'debug.php'; // DEBUG
# Generate and return a text-data data array:
function gen_data($rows, $points)
{
$data = array();
for ($r = 0; $r < $rows; $r++) {
$row = array("Row{$r}");
for ($c = 0; $c < $points; $c++) {
$row[] = $r + $c + 1;
}
$data[] = $row;
}
return $data;
}
$data = gen_data($tp['nrows'], $tp['ncols']);
if ($tp['longlabel']) {
$data[min(3, $tp['nrows'] - 1)][0] = 'Long Label Test';
}
if ($tp['negative'] > 0) {
$phase = $tp['negative'];
for ($r = 0; $r < $tp['nrows']; $r++) {
for ($c = 1; $c <= $tp['ncols']; $c++) {
if (--$phase <= 0) {
$data[$r][$c] *= -1;
$phase = $tp['negative'];
}
}
}
}
$p = new PHPlot(800, 800);
