<?
/*
 * Jingho Projects - Small business project management 
 * Copyright (C) 2010 Gido Carper
 * http://www.jingho-projects.com
 * http://www.jingho.de
 * 
 * thank you for mentioning my name and url on your site if you use this software!
 * 
 * == BEGIN LICENSE ==
 *
 * Licensed under the terms of any of the following licenses at your
 * choice:
 *
 *  - GNU General Public License Version 1.0 or later (the "GPL")
 *    http://www.gnu.org/licenses/gpl.html
 *
 *
 * == END LICENSE ==
 *
 * 
 */
echo '
 <div class="widget-head" >
                    <h3>'.$OVERVIEW_PROJECTS.'&nbsp;&nbsp;<span id="ProjectInfo"></span></h3><span id="ProjectsLastupdated" style="float:right;padding-right:10px;"></span>
                    
                </div>
                <div class="widget-content">
<form action="'.$MAIN_PATH.'actions.php" method="post" target="saveFrame" name="saveProjectFrame">
				<div  style="color:#ffffff;margin-left:10px;padding-top:10px;display:block;width:500px;">
				

			<div  style="padding-top:10px;padding-bottom:10px;display:block;width:350px;">';

			SelectBoxBCust("SELECT
				  t_projects.p_name,
				  t_projects.c_id,
				  t_projects.p_id,
				  t_projects_users.u_id,
				  t_users.u_name,
				  `t_costumers`.c_name,
				  `t_costumers`.c_id
				FROM
				  t_projects
				  INNER JOIN t_projects_users ON (t_projects.p_id = t_projects_users.p_id)
				  INNER JOIN t_users ON (t_projects_users.u_id = t_users.u_id)
				  INNER JOIN `t_costumers` ON (t_projects.c_id = `t_costumers`.c_id)
				  WHERE t_projects_users.u_id= ".$_SESSION['uid']."   order by `t_costumers`.c_name
				  ", 'p_id', 'p_name', 0,$OVERVIEW_PROJECT_CHOOSE,0,"selectBoxNormal","GetProjects(".chr(39)."widget-projects".chr(39).",true);","p_id_projects","c_name"); 

echo '				
				
				

				</div><br/>
				</div>
				<div  style="display:inline-block;width:100%;"><table cellspacing="0" cellpadding="0" class="TableTasksProjects">
					<tbody>
					<tr>

						<td style="width: 15px;padding-left:10px;">&nbsp;</td>
						<td style="width: 200px;padding-left:3px;"><a href="javascript:SetProjectSort('.chr(39).'p_name'.chr(39).',true);">'.$OVERVIEW_PROJECTS_HEADLINE[0].'</a></td>
						<td style="width: 160px;"><a href="javascript:SetProjectSort('.chr(39).'c_name'.chr(39).',true);">'.$OVERVIEW_PROJECTS_HEADLINE[5].'</a></td>
						<td style="width: 90px;"><a href="javascript:SetProjectSort('.chr(39).'p_status'.chr(39).',true);">'.$OVERVIEW_PROJECTS_HEADLINE[1].'</a></td>
						<td style="width: 80px;"><a href="javascript:SetProjectSort('.chr(39).'p_budget'.chr(39).',true);">'.$OVERVIEW_PROJECTS_HEADLINE[4].'</a></td>
						<td style="width: 100px;"><a href="javascript:SetProjectSort('.chr(39).'p_start_date'.chr(39).',true);">'.$OVERVIEW_PROJECTS_HEADLINE[2].'</a></td>
						<td ><a href="javascript:SetProjectSort('.chr(39).'p_end_date'.chr(39).',true);">'.$OVERVIEW_PROJECTS_HEADLINE[3].'</a></td>
						
						
						<!--<td align="right" style="padding-right:10px;">'.$OVERVIEW_PROJECTS_HEADLINE[5].'</td>//-->
					</tr>
					</table></div>
				<div class="ProjectOverviewList"  id="widget-projects"></div>
				<div style="float:right;margin-right:10px;margin-top:10px;color:#ffffff;font-size:11px;">'.$OVERVIEW_TOTAL_PROJECTS.': <span id="totalProjects" style="font-weight:bold;"></span></div>
				<!--<span style="float:left;margin-right:10px;margin-top:10px;color:#ffffff;font-size:11px;"><a href="javascript:SelectAllCheckboxes('.chr(39).'widget-projects'.chr(39).',document.saveTaskFrame);OffFoc();"> '.$OVERVIEW_SELECT_ALL.'</a> this is not a good idea to delete all Projects//--> 
				
				
				<p>&nbsp;</p>

				<div style="height:30px;width:100%;overflow:hidden;"  id="widget-projects-icons">';
				
				
				if ($_SESSION['gid']=='1' || $_SESSION['gid']=='2')
				{
					if ($_SESSION['gid']=='1' )
					{
						echo '<a href="javascript:deleteSelected('.chr(39).'widget-projects'.chr(39).',document.saveProjectFrame,'.chr(39).'project'.chr(39).','.chr(39).'saveProjectFrame'.chr(39).');OffFoc();" class="iconRemove" style="position:absolute;margin:5px;margin-left:80px;"></a>';
					}
				}
				
				echo '	<a href="javascript:GetProjects('.chr(39).'widget-projects'.chr(39).',false);OffFoc();" class="iconReload" style="position:absolute;margin:5px;margin-left:200px;"  onmouseover="StartFadeIn();ddrivetip('.chr(39).$TOOLTIP_PROJECT_OVERVIEW_RELOAD.chr(39).', 140);" onmouseout="hideddrivetip();"></a>

				<!--<a href="javascript:GetTasks('.chr(39).'widget-users'.chr(39).',false);OffFoc();" class="iconBackward" style="position:absolute;margin:5px;margin-left:250px;"></a>
				<a href="javascript:GetTasks('.chr(39).'widget-users'.chr(39).',false);OffFoc();" class="iconForward" style="position:absolute;margin:5px;margin-left:280px;"></a>//-->



				</div><br/>

			    
			    <input type="hidden" name="ausgefuellt"  value="ja"/>
			    <input type="hidden" name="projects_sortby" id="projects_sortby"  value="c_name"/>
			    <input type="hidden" name="projects_sortdirection"  id="projects_sortdirection" value="asc"/>
			    
			    <input type="hidden" name="info_projects" id="info_projects"/>
			    <input type="hidden" name="info_projects_checkbox" id="info_projects_checkbox"/>			    
			    
                    	</form></div>';

                    ?>