1KA_F2F/utils/ParadataExport/export.php

<?php
	/**
	* Po vrsti klicemo skripte ki izvazajo parapodatke
	*/

	set_time_limit(36000); 		// 10 ur

        include_once '../../function.php';
	include_once '../../admin/survey/definition.php';
	include_once '../../vendor/autoload.php';
	
	global $site_url, $site_path;
	
	// Nastavimo ustrezno bazo po potrebi
	/*$GLOBALS['connect_db'] = mysqli_connect ('localhost', 'root', 'tripive');
	mysqli_select_db($GLOBALS['connect_db'],'para1kaclean');*/
	
	
	// Filtriranje anket
	//include("1ka_paradata_clear.php");
	
	// Struktura anket
	/*include("1ka_paradata_export_anketa.php");	
	include("1ka_paradata_export_grupa.php");
	include("1ka_paradata_export_vprasanje.php");
	include("1ka_paradata_export_vrednost.php");
	include("1ka_paradata_export_text_vprasanje.php");
	include("1ka_paradata_export_text_vrednost.php");
	include("1ka_paradata_export_grid.php");
	include("1ka_paradata_export_grid_multiple.php");
	include("1ka_paradata_export_if.php");*/
	
	// Responsi anket
	/*include("1ka_paradata_export_user_data.php");
	include("1ka_paradata_export_grupa_data.php");
	include("1ka_paradata_export_insert_data.php");
	include("1ka_paradata_export_insert_data-2.php");*/
	
	
	// Linki za filtriranje anket
	$limit = 100;
	
	echo '<h2>Filtriranje anket</h2>';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=qmax&limit='.$limit.'&delete=0">Več kot 500 vprašanj</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=qmin&limit='.$limit.'&delete=0">Manj kot 5 vprašanj</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=qnone&limit='.$limit.'&delete=0">Nobenega vprašanja</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=amin&limit='.$limit.'&delete=0">Manj kot 20 ustreznih odgovorov (status 6)</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=anone&limit='.$limit.'&delete=0">Nobenega ustreznega odgovora</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=old&limit='.$limit.'&delete=0">Starejše od 2017</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=title&limit='.$limit.'&delete=0">Vsebujejo neustrezne besede v naslovu</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=qtype&limit='.$limit.'&delete=0">Vsebujejo redke tipe vprašanj</a>';
	
	/*echo '<h2>Filtriranje anket Z BRISANJEM</h2>';
	$limit = 1000;
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=qmin&limit='.$limit.'&delete=1">Manj kot 5 vprašanj</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=amin&limit='.$limit.'&delete=1">Manj kot 20 ustreznih odgovorov (status 6)</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=old&limit='.$limit.'&delete=1">Starejše od 2017</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=title&limit='.$limit.'&delete=1">Vsebujejo neustrezne besede v naslovu</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=clear&type=qtype&limit='.$limit.'&delete=1">Vsebujejo redke tipe vprašanj</a>';*/


	echo '<hr>';


	// Linki za posamezen zagon skript - struktura anket
	echo '<h2>Struktura anket</h2>';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=anketa">Ankete</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=grupa">Strani</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=vprasanje">Vprašanja</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=vrednost">Variable</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=text_vprasanje">Naslovi vprašanj</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=text_vrednost">Naslovi variabel</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=grid">Gridi</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=grid_multiple">Multiple gridi</a><br />';
	//echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=if">Pogoji</a>';


	echo '<hr>';


	// Linki za posamezen zagon skript - responsi anket
	echo '<h2>Odgovori anket</h2>';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=user_data">Respondenti</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=grupa_data">Strani</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=insert_data">Odgovori</a><br />';
	echo '<a href="'.$site_url.'utils/ParadataExport/export.php?a=insert_data-2">Pogoji</a>';


	echo '<hr>';


	// Nastavimo seznam anket
	//$survey_list = array('165932', '166116', '166118', '166119', '166120', '165933', '166121', '166122', '165937', '166124', '166217');
	/*$survey_list = array();
	for($i=0; $i<100; $i++){
		$survey_list[] = $i;
	}*/	
	$survey_list = array('113095','113808','114474','115203','116174','116180','116190','116290','116474','116800','117324','117455','117526','117989','118209','118349','119476','119743','119838','120172','120305','120528','120660','120953','121750','121876','122139','122382','122401','122863','123174','123364','123379','123421','123782','123972','124118','124169','124697','124916','125096','125125','125254','125476','125783','125840','126084','126535','126639','126822','126931','127089','127173','127207','127362','127651','127906','128602','128789','129080','129130','129174','129302','129837','130319','130326','130355','130742','131143','131226','132012','132033','132506','132756','133280','133705','133813','133863','134615','134726','134818','135964','136092','136143','136511','136807','136896','137393','137750','138276','138323','138357','138998','140004','140250','140296','140573','140654','141021','141258','141395','141500','141942','142918','142940','144312','145092','145448','145609','146035','146372','147198','147515','147570','147718','148012','148170','148395','148615','149021','149053','149227','150586','150928','151442','151564','151568','152225','153725','153747','154098','154110','154611','154669','154776','155048','155151','155341','155549','156011','156162','156880','157028','157057','157481','157837','157929','159202','159471','159974','159991','160214','160419','160625','160762','160848','161004','161070','161758','161912','162290','162476','162566','163528','163597','163718','163834','163841','164098','164143','165092','165852','166284','166401','166478','166649','166672','166966','167023','167038','167445','167550','167869','167873','167876','167892','169204','169780','170247','170800','171605','171813','171869','172030','172047','172245','172882','172923','173223','173957');
	
	$survey_list_string = implode("','", $survey_list);
	$survey_list_string = "'".$survey_list_string."'";


	// Ce imamo nastavljen action in obstaja skripta ga izvedemo
	$action = (isset($_GET['a'])) ? $_GET['a'] : '';
	if($action != '' && file_exists('1ka_paradata_export_'.$action.'.php')){

		echo '1ka_paradata_export_'.$action.'.php';
		include('1ka_paradata_export_'.$action.'.php');
	}
	elseif($action == 'clear'){
		
		echo '1ka_paradata_'.$action.'.php';
		include('1ka_paradata_'.$action.'.php');
	}
	
?>