\n";
if($PARENT==0) $SPECIAL=" or P_ID=ID "; else $SPECIAL=" and P_ID!=ID ";
$SQL2="select * from ".$thiss->DETECT_TABLE_NAME." where ( P_ID like '$PARENT %' or P_ID like '% $PARENT %' or P_ID like '% $PARENT' or P_ID like '$PARENT' ) $SPECIAL ";
//echo "||| parent $PARENT $SQL2 |||
\n";
$result2=mysql_query($SQL2); $result2_numrows=mysql_num_rows($result2);
$lp=0;
while ($res2=mysql_fetch_array($result2)) {
$lp++;
if($lp==$result2_numrows) $LLAST=1; else $LLAST=0 ;
if($LLAST) $TREE[$POZIOM]=" "; else $TREE[$POZIOM]=" | ";
if(!$LLAST) {
$cnt=0;
while ($cnt <= $POZIOM) {
if($cnt<>$POZIOM) echo $TREE["$cnt"]; else {
if($TREE[$cnt]==" | ") echo " | ";
else echo " | ";
}
$cnt++;
}
echo "\n";
}
$cnt=0;
while ($cnt <= $POZIOM) {
if($cnt<>$POZIOM) echo $TREE["$cnt"]; else {
if($TREE[$cnt]==" | ") echo " +==";
else echo " \\==";
}
$cnt++;
}
echo ""."[ ID $res2[ID] s: ".$res2[A_STATUS]." ".$res2[M_DIST_DESC]." ".$res2[M_DISTRIBUTOR]." ".$res2[M_DIST_INVENTOR]." ] Z+ \n";
// $A_STATUS_COLOR=USERS_COLUMN_COLOR_RETURN("A_STATUS",$res2[A_STATUS],'color');
// echo ""."[ $res2[ID] s: ".$res2[A_STATUS]." $res2[M_DIST_DESC] ".$res2[M_DIST_DESC]." ] Z+ \n";
if($POZIOM>200) die("problem petli");
if($_GET[ROZWIN]) {
$_SESSION[$thiss->DETECT_TABLE_COLUMN][EDITRECORD][ID]=$res2[ID];
$ARG1_VAL="DODAJ_PLIK";
M_DIST_FILES("DODAJ_PLIK",'','HIDE') ;
M_DIST_FILES_RELATIONS($thiss->DETECT_TABLE_COLUMN,$res2[ID],'');
}
tree_znajdz($res2[0],$POZIOM+1,$LLAST);
}
}// EOF Func
function TREE() {
global $result,$thiss;
echo '<<Powrot do spraw';
ZAP_SQL("select 1+1");
//$TREE[0]="|";
$TREE=array();
//$TREE="|";
//$SQL1="select * from CRM_PROCES where PARENT_ID='0' ";
echo "";
echo "POWIAZANE DOKUMENTY ";
if (!$_GET[ROZWIN]) echo "ROZWIN";
else echo "ZWIN";
echo "\n";
tree_znajdz(0,1,0);
//echo "$SQL1";
//$result1=mysql_query($SQL1);
//ZAP_SQL($SQL1);
//while ($res1=mysql_fetch_array($result)) {
//echo "$TREE"."$res1[0]"."\n";
//
// $SQL2="select * from CRM_PROCES where PARENT_ID='$res1[0]'";
// $result2=mysql_query($SQL2);
// while ($res2=mysql_fetch_array($result2)) {
// echo $TREE."\-"."$res2[0] \n";
// }
//} //EOF SQL1
//echo "$SQL1";
echo "";
//EOF IF
}