<?php
if(isset($_GET['STAT_USER'])){
//$sql = "select u.u_id,a.a_id,d.d_id, u.u_fname,u.u_lname,u.u_mname,a.a_firma,a.a_marka,a.a_year from dogovora d,users u,auto a where d.d_u_id = u.u_id and d.d_a_id = a.a_id";
//sql = "select * from dogovora where d_u_id = ".$_GET['d_u_id'];
/*sql = "select * from dogovora where d_a_id = ".$_GET['d_a_id'];
sql = "select * from dogovora where d_start between ".$_GET['d_start']." AND  ".$_GET['d_end'] ;
sql = "select * from dogovora where d_end between ".$_GET['d_start']." AND  ".$_GET['d_end'] ;
sql = "select * from dogovora where (d_start between ".$_GET['d_start']." AND  ".$_GET['d_end'].") AND (d_end between ".$_GET['d_start']." AND  ".$_GET['d_end']." )" ;
sql = "select * from dogovora where d_u_id = ".$_GET['d_u_id'];
sql = "select * from dogovora where d_u_id = ".$_GET['d_u_id'];




sql="SELECT count(*) FROM dogovora WHERE id=";
select * from ()
*/
	if(isset($_GET['u_id']))
			{
			$sql = "select u_fname,'','',d_start,d_end,d_price, d_skidka,d_id,u_id from dogovora d,users u where d.d_u_id = u.u_id  and u_id =".$_GET['u_id']." order by d_start DESC";
   			$res=mysql_query($sql) or DIE ("SELECT * FROM users ERROR! ".MYSQL_ERROR());
   		 	$user=array();
			while($rowa=mysql_fetch_array($res))
				{ $user[]=$rowa; };

			$smarty->assign("user", $user);
 			$smarty->assign("admin_main_content_template", "dogovora.tpl");

			}
	else
			{
		
		
		$sort_d = " and (d_start between '".date("Y-m-d",strtotime("-1 month"))."' AND  '".date("Y-m-d")."') AND (d_end between '".date("Y-m-d",strtotime("-1 month"))."' AND  '".date("Y-m-d")."' )" ;
			
			if (isset($_POST['d_endYear'])&&isset($_POST['d_startMonth']))
      {
        $sort_d =" ";
    	$d_start = $_POST['d_startYear']."-".$_POST['d_startMonth']."-".$_POST['d_startDay']    ;
    	 $d_end = $_POST['d_endYear']."-".$_POST['d_endMonth']."-".$_POST['d_endDay']    ;

    	 $sort_d = " and (d_start between '".$d_start."' AND  '".$d_end."') AND (d_end between '".$d_start."' AND  '".$d_end."' )" ;
    	 
    	 	$smarty->assign("dt_start", strtotime($d_start));
                $smarty->assign("dt_end", strtotime($d_end));
			
			
    	 }else{
    	 
    	 	$smarty->assign("dt_start", strtotime("-1 month"));
		$smarty->assign("dt_end", strtotime($d_end));
    	 
    	 }
			
			
		
			
			
			
			$dt = 3600*24;
 			$sql = "select u_fname,'','', count(*),sum(DATEDIFF(d_end,d_start)), sum( (( DATEDIFF(d_end,d_start)  )*d_price )  -d_skidka  ) as oplat,sum(d_skidka),d_id,u_id from dogovora d,users u 
 			
 			where d.d_u_id = u.u_id ".$sort_d."  group by u_fname order by oplat DESC";
			// SELECT sum(d_price) as ssum, count(d_id) as cd, users.* FROM `dogovora` LEFT JOIN users ON users.u_id=d_u_id GROUP BY d_u_id ORDER BY ssum DESC 
// 			$sql = "select u_fname,'','', count(*),ROUND(sum(d_end-d_start)/1000000), SUM(d_price-d_skidka) as oplat,sum(d_skidka),d_id,u_id from dogovora d,users u where d.d_u_id = u.u_id  group by d_u_id order by oplat DESC";
			
			//echo $sql;
   			$res=mysql_query($sql) or DIE ("SELECT * FROM users ERROR! ".MYSQL_ERROR());
   		 	$user=array();
			while($rowa=mysql_fetch_array($res))
				{ $user[]=$rowa; };

			$smarty->assign("user", $user);
 			$smarty->assign("admin_main_content_template", "users_stat.tpl");

 			}

	}
?>



<!--//  sum( (( (d_end-d_start)/1000000  )*d_price )  -d_skidka  ) ROUND((sum(((d_end-d_start)))/1000000)*d_price)-d_skidka -->