Сотрудник Время (часы:минуты) '; while ($db_project = db_fetch_array($project_query)) { $db_project_total = db_query("SELECT SUM(`field_277`) as 'hours' FROM app_entity_34 WHERE parent_item_id in (SELECT app_entity_22.id FROM app_entity_22 where parent_item_id = {$db_project['id']})"); $project_total = db_fetch_array($db_project_total); $html .= ''; $html .= "{$db_project['field_158']}"; $html .= "{$project_total['hours']}"; $html .= ''; $db_user_query = db_query("SELECT * FROM app_entity_1 where app_entity_1.id in (SELECT app_entity_22.field_171 FROM app_entity_22 where parent_item_id = {$db_project['id']}) "); while($db_project_users = db_fetch_array($db_user_query)) { $db_user_workhours = db_query("SELECT SUM(`field_486`) as 'hours' FROM app_entity_47 WHERE parent_item_id in (SELECT app_entity_22.id FROM app_entity_22 where parent_item_id = {$db_project['id']} and field_171 = {$db_project_users['id']} )"); $user_workhours = db_fetch_array($db_user_workhours); $html .= ''; // $html .= "{$dbresult['field_158']}"; $html .= "{$db_project_users['field_8']} {$db_project_users['field_7']}"; $html .= "{$user_workhours['hours']}"; $html .= ''; } } $html .= ' '; return $html; } // FIXME: считает криво, но не используется => приоритет низкий static function get_month_worktime($start_date_string , $end_date_string) { $start_date = new DateTime($start_date_string); $end_date = new DateTime($end_date_string); $html = ''; $html .= ''; if ($db_users_worktime = db_query(" SELECT app_entity_1.id as 'user_id', CONCAT_WS(' ', `field_8`, `field_7`) AS 'name', SUM(`field_716`) AS 'hours' FROM app_entity_47 INNER JOIN(app_entity_1) ON ( app_entity_1.id = app_entity_47.field_713 ) WHERE {$start_date->format("U")} <= `field_715` AND `field_715` <= {$end_date->format("U")} GROUP BY app_entity_1.id ")){ while ($user_worktime = db_fetch_array($db_users_worktime)) { $html .= ''; $html .= ""; $hours = new DateIntervalEnhanced("PT".round($user_worktime['hours']*3600)."S"); $html .= ""; $html .= ''; } } $html .= '

Сотрудник	Время (часы:минуты)
{$user_worktime['name']}	".$hours->recalculate()->format('%H:%I')."

'; return $html; } static function get_month_worktime_details($start_date_string, $end_date_string, $user_id=0 ) { $start_date = new DateTime($start_date_string); $end_date = new DateTime($end_date_string); $date_period = new DatePeriod($start_date, new DateInterval('P1D'), (clone($end_date))->modify('+1 day')); if ($user_id==0) { $db_users_worktime = db_query(" SELECT app_entity_1.id as 'user_id', CONCAT_WS(' ', `field_8`, `field_7`) AS 'name', SUM(`field_716`) AS 'hours' FROM app_entity_47 INNER JOIN(app_entity_1) ON ( app_entity_1.id = app_entity_47.field_713 ) WHERE {$start_date->format("U")} <= `field_715` AND `field_715` <= {$end_date->format("U")} GROUP BY app_entity_1.id "); } else { $db_users_worktime = db_query(" SELECT app_entity_1.id as 'user_id', CONCAT_WS(' ', `field_8`, `field_7`) AS 'name', SUM(`field_716`) AS 'hours' FROM app_entity_47 INNER JOIN(app_entity_1) ON ( app_entity_1.id = app_entity_47.field_713 ) WHERE app_entity_1.id={$user_id} AND {$start_date->format("U")} <= `field_715` AND `field_715` <= {$end_date->format("U")} GROUP BY app_entity_1.id "); } // начинаем рисовать таблицу, формируем заголовки. $html = ''; $html .= ''; foreach ($date_period as $date ) { if ($date->format('N')<6) { $html .= ""; } else { $html .= ""; } } // второй заход - дни недели $html .= ''; foreach ($date_period as $date ) { if ($date->format('N')<6) { $html .= ""; } else { $html .= ""; } } $html .= ''; // собственно вписываем строки в таблицу while ($user_worktime = db_fetch_array($db_users_worktime)) { $html .= ''; $html .= ""; $hours = floor($user_worktime['hours']) .":". str_pad(round(($user_worktime['hours'] - floor($user_worktime['hours']))*60),2,"0", STR_PAD_LEFT); $html .= ""; foreach ($date_period as $date ) { $db_daily_workhours = db_query( "SELECT SUM(`field_716`) AS 'hours' FROM app_entity_47 INNER JOIN(app_entity_1) ON ( app_entity_1.id = app_entity_47.field_713 ) WHERE `field_715` = {$date->format('U')} AND app_entity_1.id={$user_worktime['user_id']}" ); $daily_workhours = db_fetch_array($db_daily_workhours); if ($daily_workhours['hours']) { $dayly_hours = floor($daily_workhours['hours']) .":". str_pad(round(($daily_workhours['hours'] - floor($daily_workhours['hours']))*60),2,"0", STR_PAD_LEFT); if ($date->format('N')<6) { $html .= ""; } else { $html .= ""; } } else { if ($date->format('N')<6) { $html .= ""; } else { $html .= ""; } } } $html .= ''; } $html .= '

Сотрудник	Время (часы:минуты)	{$date->format('d')}	{$date->format('d')}
		{$date->format('D')}	{$date->format('D')}
{$user_worktime['name']}	{$hours}	{$dayly_hours}	{$dayly_hours}	00:00	00:00

'; return $html; } } function hours_and_minutes($hours) { return floor($hours) .":". str_pad(round(($hours - floor($hours))*60),2,"0", STR_PAD_LEFT); } class DateIntervalEnhanced extends DateInterval { public function recalculate() { $from = new DateTime; $to = clone $from; $to = $to->add($this); $diff = $from->diff($to); foreach ($diff as $k => $v) $this->$k = $v; return $this; } }