<?php
	set_time_limit(0);
	$con = mysql_connect("localhost", "root", "root");
	mysql_select_db("tpo", $con);
	$f = fopen("DocumentsTP.csv", "r");
	for($i = 1; $i <= 31; $i++){
		$data = fgetcsv($f, 1000, ';');
		$code = $data[0];
		if($code[6].$code[7].$code[8] == "000"){
			$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '000000000000', name = '{$data[1]}', level = 1;");
		}else{
			$parent = $code[0].$code[1].$code[2].$code[3].$code[4].$code[5]."000000";
			$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '{$parent}', name = '{$data[1]}', level = 2;");
		}
	}
	for($i = 1; $i <= 5; $i++){
		$data = fgetcsv($f, 1000, ';');
		$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '000000000000', name = '{$data[1]}', level = 1;");
	}
	while(!feof($f)){
		$data = fgetcsv($f, 1000, ';');
		$code = $data[0];
		$flag = 0;
		if($code[10].$code[11] == "00"){
			if($code[8].$code[9] == "00"){
				if($code[6].$code[7] == "00"){
					if($code[4].$code[5] == "00"){
						$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '000000000000', name = '{$data[1]}', level = 1;");
						$flag = 1;
					}
					if($flag == 0){
						$parentcode = "";
						for($j = 0; $j < 4; $j++){
							$parentcode .= $code[$j];
						}
						$parentcode .= "00000000";
						$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '{$parentcode}', name = '{$data[1]}', level = 2;");
						$flag = 1;
					}
				}
				if($flag == 0){
					$parentcode = "";
					for($j = 0; $j < 6; $j++){
						$parentcode .= $code[$j];
					}
					$parentcode .= "000000";
					$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '{$parentcode}', name = '{$data[1]}', level = 3;");
					$flag = 1;
				}
			}
			if($flag == 0){
				$parentcode = "";
				for($j = 0; $j < 8; $j++){
					$parentcode .= $code[$j];
				}
				$parentcode .= "0000";
				$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '{$parentcode}', name = '{$data[1]}', level = 4;");
				$flag = 1;
			}
		}
		if($flag == 0){
			$parentcode = "";
			for($j = 0; $j < 10; $j++){
				$parentcode .= $code[$j];
			}
			$parentcode .= "00";
			$query = mysql_query("INSERT INTO documentstp SET code = '{$data[0]}', parentcode = '{$parentcode}', name = '{$data[1]}', level = 5;");
			$flag = 1;
		}
		
	}
	
	fclose($f);
	$query1 = mysql_query("SELECT * FROM documentstp;");
	for($i = 1; $i <= mysql_num_rows($query1); $i++){
		$obj = mysql_fetch_object($query1);
		$query2 = mysql_query("SELECT * FROM documentstp WHERE parentcode = '{$obj->code}'");
		$numchild = mysql_num_rows($query2);
		$query3 = mysql_query("UPDATE documentstp SET children = '{$numchild}' WHERE code = '{$obj->code}';");
		echo $numchild."<br>";
	}
?>