<?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();

?>