<?php
/**
 *add kanban reports to main menu
 */

if($app_user['group_id']>0)
{
	$reports_query = db_query("select c.* from app_ext_kanban c, app_entities e where e.id=c.entities_id and e.parent_id=0 and find_in_set(" . $app_user['group_id'] . ",c.users_groups) order by c.name");
}
else
{
	$reports_query = db_query("select c.* from app_ext_kanban c, app_entities e where e.id=c.entities_id and e.parent_id=0 order by c.name");
}

while($reports = db_fetch_array($reports_query))
{
	$check_query = db_query("select id from app_entities_menu where find_in_set('kanban" . $reports['id']. "',reports_list)");
	if(!$check = db_fetch_array($check_query))
	{
	    if($reports['in_menu'])
	    {
	        $app_plugin_menu['menu'][] = array('title'=>$reports['name'],'url'=>url_for('ext/kanban/view','id=' . $reports['id']),'class'=>'fa-th');
	    }
	    elseif($app_entities_cache[$reports['entities_id']]['parent_id']==0)
	    {
	        $app_plugin_menu['reports'][] = array('title'=>$reports['name'],'url'=>url_for('ext/kanban/view','id=' . $reports['id']));
	    }
	}
}

/**
 *add kanban reports to items menu
 */
if(isset($_GET['path']))
{
	$entities_list = items::get_sub_entities_list_by_path($_GET['path']);

	if(count($entities_list))
	{
		if($app_user['group_id']>0)
		{
			$reports_query = db_query("select c.* from app_ext_kanban c, app_entities e where e.id=c.entities_id and e.id in (" . implode(',',$entities_list) . ")  and find_in_set(" . $app_user['group_id'] . ",c.users_groups) order by c.name");
		}
		else
		{
			$reports_query = db_query("select c.* from app_ext_kanban c, app_entities e where e.id=c.entities_id and  e.id in (" . implode(',',$entities_list) . ")  order by c.name");
		}

		while($reports = db_fetch_array($reports_query))
		{
			$path = app_get_path_to_report($reports['entities_id']);
				
			$app_plugin_menu['items_menu_reports'][] = array('title'=>$reports['name'],'url'=>url_for('ext/kanban/view','id=' . $reports['id'] . '&path=' . $path));
		}
	}
}