<?php

   ### Plugin: newest by title
   ### Purpose:



    function networks ($accordian) {

       global $searchengine;
       global $config;
       global $oSQL;
			 $distributions = DISTRIBUTIONS_TABLE;
			 $tubes = TUBES_TABLE;       
       $accordian = (bool) $accordian;
       $networks = array();
       $endNode = false;
       
       $SQL = "SELECT network_nodes.NodeName, network_nodes.NodeIconURL, network_nodes_type.nodetype, network_nodes.NodeTopic, IFNULL(iweb_hs_categories.category_name,'Non-Topical') AS NodeCategory, network_nodes.NodeDescription, network_nodes.SystemNode, network_nodes.SystemParentNode, network_nodes.NodeUrl FROM `network_nodes` INNER JOIN network_nodes_type ON network_nodes_type.NodeIndex = network_nodes.NodeType LEFT JOIN iweb_hs_categories ON iweb_hs_categories.category_id = network_nodes.NodeTopic";       
       
       $NODESQL = $SQL;
       $SORT = " ORDER BY network_nodes.NodeName";
       if($searchengine->node_id) {
            $NODESQL .= " WHERE network_nodes.SystemParentNode = $searchengine->node_id";
       } else if($searchengine->category_id) {
            $NODESQL .= " WHERE iweb_hs_categories.category_id = $searchengine->category_id GROUP BY network_nodes.NodeAcctID HAVING MIN(network_nodes.NodeType)";
       } else if($searchengine->account_id) {
            $NODESQL .= " WHERE network_nodes.NodeAcctID = '$searchengine->account_id'";
            $SORT = " ORDER BY network_nodes.NodeType,network_nodes.NodeName";            
       } else if($searchengine->Terms) {
            $NODESQL .= " WHERE FIND_IN_SET('$searchengine->Terms',network_nodes.NodeKeywords) GROUP BY network_nodes.NodeAcctID HAVING MIN(network_nodes.NodeType)";
       } else {
            $NODESQL .= " WHERE network_nodes.SystemParentNode IS NULL $category_search GROUP BY network_nodes.NodeAcctID HAVING MIN(network_nodes.NodeType)";
       }
       $NODESQL .= $SORT;
       $networks = $oSQL->search( array("SQL"=>$NODESQL, "Return"=>'set') );		
       if($searchengine->node_id) {
     	    	$current = $searchengine->network->data;
     	    	$current[nodetype] = $searchengine->network->get_type();
     	    	$current[NodeCategory] = $searchengine->network->get_category();    
       	    if(count($networks) === 0) {
              $endNode = true;
       	    } 
       	    $networks = array_merge(array($current), $networks);
   				 	$parent_node = $searchengine->network->data['SystemParentNode'];
      	    if($parent_node !== null) {
      				 $SQL .= " WHERE network_nodes.SystemNode = $parent_node";
      				 $parent = $oSQL->search( array("SQL"=>$SQL, "Return"=>'set') );            
               $networks = array_merge($parent, $networks);
						}
       }
       $results = "";
       $currentnode = -1;
       for ( $x=0; $x < count($networks); $x++ ) {
						$link = $networks[$x];
						$node = network_tree(array("systemnode"=>$link['SystemNode']));
            if(count($node) > 0) {
              $sysnodes = implode(",",$node);
              $sysnodes .= "," . $link['SystemNode'];
            } else {
              $sysnodes = $link['SystemNode'];
            }
            if(strlen($sysnodes) > 0) {
	            $SQL = "SELECT COUNT(distributionid) as distribcount FROM $distributions, $tubes WHERE  $tubes.membercodeid = $distributions.membercodeid AND $distributions.statusidkey = 6 AND $distributions.startdate <= CURDATE() AND $distributions.enddate >= CURDATE() AND $tubes.sysnodeid IN ($sysnodes)";
	       		  $videos = $oSQL->search( array("SQL"=>$SQL, "Return"=>'single') );
	       		  if($videos[broadcount] > 0) {	  
		            if($searchengine->node_id) {
		            	if($link['SystemNode'] === $searchengine->node_id) {
		              	$currentnode = $x;
		            	}
		            }	       		  	          
								$more_cat = '';
								if($link['NodeTopic'] !== null) {
									$more_cat = dynamic_url( array("search"=>"cat", "category"=>$link['NodeTopic'], "Qualifier"=>$searchengine->qualifier, "cb"=>$searchengine->cb) );
								}
		            $NodeUrl = "";
		            if(($endNode === false || (count($networks) > 0 && $x === 0)) && $link['SystemNode'] !== $searchengine->node_id) {
										$NodeUrl = dynamic_url( array("node"=>$link['SystemNode'], "Qualifier"=>$searchengine->qualifier, "cb"=>$searchengine->cb) );
		            }								
								$nodeicon = "";
		            if($link['NodeIconURL']) {
		            	if(strpos($link['NodeIconURL'],"http") === false) {
		            		if(strpos($link['NodeIconURL'],"/") === 0) {
		            			$link['NodeIconURL'] = "https://my.wwbn.com" . $link['NodeIconURL'];
		            		} else {
		            			$link['NodeIconURL'] = "https://my.wwbn.com/" . $link['NodeIconURL'];
		            		}
		            	}
		            	 $nodeicon = $link['NodeIconURL'] = "<img src='$link[NodeIconURL]'/>";
			            if($NodeUrl) {					
			            	 $nodeicon = "<a href='$NodeUrl'>$nodeicon</a>";		
			            }			            	
		            	$nodeicon = "<span class='nodeicon'>$nodeicon</span>";           	
		            }            
		            if($accordian === true) {
		            	$detail .= "<h1>Networks</h1><div><div>$link[NodeName]</div><div>";
		            } else {
		            	$detail .= "<li>";
		            }
	            
		            $detail .= "<span class='nodedetails'>$nodeicon<span class='NodeName'>";
		            if($NodeUrl) {
            		    $detail .= "<a href='$NodeUrl'><strong>$link[NodeName]</strong></a>";		            	
		            } else {
		            		$detail .= "<strong>$link[NodeName]</strong>";
		            }
		            $detail .= "</span><span class='NodeDescription'>$link[NodeDescription]</span>";

		            		
		            if($link['NodeUrl']) {  
		            		$detail .= "<span class='NodeUrl'><a href='$link[NodeUrl]' target='_blank'><span>Visit&nbsp;$link[nodetype]&nbsp;Website</span></a></span>";
		            }
		            
								$detail .= "<span class='nodetopic'><span class='nodetopicinfo'><strong>$link[nodetype] Topic:</strong></span><span class='nodetopiclink'>";
				        if($more_cat) {
				            $detail .= "<a href='$more_cat'>$link[NodeCategory]</a>";
				        } else {
				        		$detail .= "$link[NodeCategory]";
				        }
				        $detail .= "</span></span></span>";
				        if($accordian === true) {
				        		$detail .= "</div></div>";
				        } else {
				        		$detail .= "</li>";				        	
				        }
	           }
	        }
       }
       if(strlen($detail) > 0) {
	       if($accordian === true) {
	            $results = "<div id='nodelist' class='Accordion'>$detail</div>
		           <script type='text/javascript'>
		           var oNodeList = new Spry.Widget.Accordion('nodelist',{useFixedPanelHeights:false, defaultPanel:$currentnode});
		           </script>            
	            ";
	       } else { 
	            $results = "<ul id='networks'>
	              $detail
	            </ul>";
	       }
	     }           
       return $results;
    }
	
	//echo "This is networks plugin1";

?>