65 lines
1.9 KiB
PHP
65 lines
1.9 KiB
PHP
<?php
|
|
|
|
/**
|
|
* popravi vrstne rede v branchingu, pobere jih iz srv_spremenljivka in srv_grupa
|
|
*/
|
|
|
|
$anketa = (int)$_GET['anketa'];
|
|
|
|
if ($anketa > 0) { echo 'ok'; } else { die('no id'); }
|
|
|
|
include_once('../../function.php');
|
|
include_once('../../vendor/autoload.php');
|
|
|
|
$s = sisplet_query("START TRANSACTION");
|
|
if (!$s) { echo mysqli_error($GLOBALS['connect_db']); die(); }
|
|
|
|
$i = 1;
|
|
|
|
// tukaj se nastavlja vrstni red:
|
|
if ($_GET['by'] == 'id')
|
|
$sql = sisplet_query("SELECT s.* FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id = '$anketa' ORDER BY s.id");
|
|
else
|
|
$sql = sisplet_query("SELECT s.* FROM srv_spremenljivka s, srv_grupa g WHERE s.gru_id=g.id AND g.ank_id = '$anketa' ORDER BY g.vrstni_red, s.vrstni_red");
|
|
while ($row = mysqli_fetch_array($sql)) {
|
|
|
|
|
|
echo $row['id'].' '.$row['naslov'].'<br>';
|
|
$a = find_parent_0($row['id'], 0, $anketa);
|
|
|
|
if ($a['0'] > 0 || $a['1'] > 0) {
|
|
$s = sisplet_query("UPDATE srv_branching SET vrstni_red='$i' WHERE element_spr='$a[0]' AND element_if='$a[1]' AND ank_id='$anketa'");
|
|
echo("UPDATE srv_branching SET vrstni_red='$i' WHERE element_spr='$a[0]' AND element_if='$a[1]' AND ank_id='$anketa'");
|
|
}
|
|
|
|
$i++;
|
|
echo '<hr>';
|
|
}
|
|
|
|
|
|
|
|
//$s = sisplet_query("ROLLBACK");
|
|
$s = sisplet_query("COMMIT");
|
|
if (!$s) { echo mysqli_error($GLOBALS['connect_db']); die(); }
|
|
|
|
|
|
function find_parent_0($spr, $if, $anketa) {
|
|
|
|
$sql = sisplet_query("SELECT * FROM srv_branching WHERE element_spr='$spr' AND element_if='$if' AND ank_id='$anketa'");
|
|
$row = mysqli_fetch_array($sql);
|
|
|
|
if ($row['parent'] == 0) {
|
|
$a = array($row['element_spr'], $row['element_if']);
|
|
return $a;
|
|
} else {
|
|
$s = sisplet_query("SELECT * FROM srv_branching WHERE element_if='$row[parent]' AND ank_id='$anketa'");
|
|
$r = mysqli_fetch_array($s);
|
|
return find_parent_0($r['element_spr'], $r['element_if'], $anketa);
|
|
}
|
|
|
|
}
|
|
|
|
$ba = new BranchingAjax($anketa);
|
|
$ba->ajax_prestevilci();
|
|
|
|
?>
|