<?php
/*
Pârbauda Marka failu pret DB
*/

error_reporting(E_ALL);

$sql = mysql_connect("localhost","root","");
mysql_select_db("yy");
mysql_query("set names utf8");

$s = file_get_contents("cats.csv");

$s = explode(";",$s);

$tmpVal = "";
function getParent($lft,$rgt,$level,$s=array()){
	global $sql,$tmpVal;
	
	$q = mysql_query("SELECT * FROM `business_category` WHERE `level` = ".($level-1)." AND `lft` < ".$lft." AND `rgt` > ".$rgt." ORDER BY `level` DESC",$sql);
	$r = mysql_fetch_assoc($q);

	if($r['level'] != 0){
		$s[] = $r['name'];
		return getParent($r['lft'],$r['rgt'],$r['level'],$s);
	}else{
		return $s;
	}
}	

$out = array();
foreach($s as $d){
	$ss = "";
	$ss = ltrim($d);
	//if(strlen($ss) > 3) $out[] = $ss;
	$q = mysql_query("SELECT * FROM `business_category` WHERE `name` = '".mysql_escape_string(trim($ss))."'");
	//echo mysql_num_rows($q);
	if(mysql_num_rows($q) > 0){ 
		$r = mysql_fetch_assoc($q);
		$ar = array();
		$ar[0] = $ss;
		$ar[1] = getParent($r['lft'],$r['rgt'],$r['level']);
		$out[] = $ar;
	}
}
/*foreach($s as $d){
	$ss = "";
	$ss = ltrim($d);
	//if(strlen($ss) > 3) $out[] = $ss;
	$q = mysql_query("SELECT id FROM `product_feature` WHERE `name` LIKE '".mysql_escape_string($ss)."'");
	//echo mysql_num_rows($q);
	if(mysql_num_rows($q) > 0) $out[] = $ss;
}*/
foreach($out as $s){
	//echo ."<br>";
	echo $s[0]."|".implode(" / ",array_reverse($s[1]))."<br>";
}