<?php
	set_time_limit(0);
	$con = mysql_connect("localhost", "root", "root");
	mysql_select_db("tpo", $con);
	$auth = mysql_query("SELECT * FROM user;");
	$dir[0] = "exist_building";
	$dir[1] = "new_building";
	$dir[2] = "new_flat";
	$dir[3] = "exist_flat";
	$dir[4] = "new_mp";
	$dir[5] = "new_constuction";
	$dir[6] = "exist_constuction";
	$dir[7] = "exist_uncomplited_constuction";
	$dir[8] = "new_uncomplited_constuction";
	$dir[9] = "exist_mp";
	
	$fout = fopen("./check/users.csv", "w");
	
	while($user = mysql_fetch_object($auth)){
		$counter = 0;
		//$fout = fopen("./check/".$user->login.".txt", "w");
		for($i = 0; $i <= 8; $i++){
			if(is_dir('./userdir/'.$user->login.'/'.$dir[$i])){
				//fwrite($fout, $dir[$i]."\n");
				if ($handle = opendir('./userdir/'.$user->login.'/'.$dir[$i])) {
					while(false !== ($file = readdir($handle))){
						if(strpos($file, ".xml") !== false){
							$xml = new DOMDocument();
							$xml->load('./userdir/'.$user->login.'/'.$dir[$i].'/'.$file);
							/*$regions = $xml->getElementsByTagName('Region');
							foreach($regions as $region){
								if($region->nodeValue == "32")
									fwrite($fout, $file."\n");
							}*/
							if($i == 0 || $i == 1 || $i == 2 || $i == 3 || $i == 5 || $i == 6 || $i == 7 || $i == 8){
								if ($xml->schemaValidate('C:\Разработка\doc_V02_STD_TP\V02_STD_TP\STD_TP.xsd')){
									$counter++;
								}
							}
							if($i == 4 || $i == 9){
								if ($xml->schemaValidate('C:\Разработка\doc_V03_STD_MP\V03_STD_МP\STD_MP.xsd')){
									$counter++;
								}
							}
						}
					}
				}
			}
		}
		fwrite($fout, $user->surname." ".$user->name." ".$user->patronimic.";".$user->sert_num.";".$user->tel.";".$counter."\n");
	}
	
	fclose($fout);
?>