72 lines
2.2 KiB
PHP
72 lines
2.2 KiB
PHP
<?php
|
|
|
|
/**
|
|
* popravi vrstne rede v branchingu, pobere jih iz srv_spremenljivka in srv_grupa
|
|
*/
|
|
|
|
|
|
include_once('../../function.php');
|
|
include_once('../../vendor/autoload.php');
|
|
|
|
/*$s = sisplet_query("START TRANSACTION");
|
|
if (!$s) { echo mysqli_error($GLOBALS['connect_db']); die(); }*/
|
|
|
|
// Ankete ki jih popravljamo
|
|
$min_id = 110000;
|
|
$max_id = 120000;
|
|
$active = 0;
|
|
|
|
// Zanenkrat samo neaktivne ki so bile urejane nazadnje pred 27.1.2017
|
|
$sqlA = sisplet_query("SELECT id FROM srv_anketa
|
|
WHERE id>='".$min_id."' AND id<'".$max_id."' AND active='".$active."' AND edit_time < '2017-01-27 00:00:00'
|
|
ORDER BY id ASC");
|
|
while($rowA = mysqli_fetch_array($sqlA)){
|
|
|
|
$anketa = $rowA['id'];
|
|
echo 'Kopiranje za anketo '.$anketa.'<br />';
|
|
|
|
if(false){
|
|
|
|
// Preklopimo na backup bazo
|
|
mysqli_select_db($GLOBALS['connect_db'], '1ka_branching');
|
|
|
|
// Zakesiramo vse vrstice branchinga za anketo
|
|
$branching_data = array();
|
|
$sqlB = sisplet_query("SELECT * FROM srv_branching WHERE ank_id='".$anketa."'");
|
|
while ($rowB = mysqli_fetch_array($sqlB)) {
|
|
|
|
$branching_data[] = $rowB;
|
|
}
|
|
|
|
// Preklopimo nazaj na produkcijsko bazo
|
|
mysqli_select_db($GLOBALS['connect_db'], 'www1kasi');
|
|
|
|
|
|
if(!empty($branching_data)){
|
|
|
|
// Najprej pobrisemo star srv_branching
|
|
$sql = sisplet_query("DELETE FROM srv_branching WHERE ank_id='".$anketa."'");
|
|
echo 'Branching for survey '.$anketa.' deleted<br />';
|
|
|
|
// Povozimo obstojece vrstice branchinga
|
|
foreach($branching_data as $branching){
|
|
|
|
$s = sisplet_query("INSERT INTO srv_branching (ank_id, parent, element_spr, element_if, vrstni_red, pagebreak)
|
|
VALUES ('".$branching['ank_id']."', '".$branching['parent']."', '".$branching['element_spr']."', '".$branching['element_if']."', '".$branching['vrstni_red']."', '".$branching['pagebreak']."')");
|
|
|
|
echo "INSERTED VALUES ('".$branching['ank_id']."', '".$branching['parent']."', '".$branching['element_spr']."', '".$branching['element_if']."', '".$branching['vrstni_red']."', '".$branching['pagebreak']."')<br />";
|
|
}
|
|
}
|
|
else{
|
|
echo 'Branchig prazen!';
|
|
}
|
|
|
|
echo '<br /><br />';
|
|
}
|
|
}
|
|
|
|
//$s = sisplet_query("ROLLBACK");
|
|
/*$s = sisplet_query("COMMIT");
|
|
if (!$s) { echo mysqli_error($GLOBALS['connect_db']); die(); }*/
|
|
|
|
?>
|