[Sav2907]

laimas,
выборка из БД.
Полный код:

<?php
$shiftStart = new DateTime('2016-12-27 06:00:00');
$shiftEnd = new DateTime('2016-12-27 12:00:00');
$server = qqG3Server_Init('SEUA_SAV', 90);

if (!qqG3Server_Connected($server)) die('Can\'t connect to SEUA_SAV');
$clip = qqG3Server_NewClip($server, 'SDA', 0);
$view = qqG3Clip_NewView($clip, 0);
qqG3View_BeginAND($view);
	qqG3View_Long($view, 10, 0, 'ActWorkStation', 1);
	qqG3View_Long($view, 9, 0, 'ActWorkStation', 50);
	qqG3View_Utime($view, 9, 0, 'ActualStartCaoDtZt', $shiftEnd->format('U'));
	qqG3View_Utime($view, 9, 0, 'ActualEndCaoDtZt', $shiftEnd->format('U'));
	qqG3View_Long($view, 5, 0, 'PersonnelNo', 601);

		qqG3View_BeginOR($view);
			qqG3View_Utime($view, 10, 0, 'ActualStartCaoDtZt', $shiftStart->format('U'));
			qqG3View_Utime($view, 10, 0, 'ActualEndCaoDtZt', $shiftStart->format('U'));
		qqG3View_End($view);
qqG3View_End($view);
qqG3View_BeginFetch($view);
if (qqG3View_Count($view) > 0) {
	$data = array();
	while ($tuple = qqG3View_Fetch($view)) {
		$employeeid = qqG3Tuple_GetLong($tuple, 0, 'PersonnelNo');
	
		if (!array_key_exists($employeeid, $data)) $data[$employeeid] = array();
		array_push($data[$employeeid], array(
		
			'ActualStartCaoDtZt' => date('Y-m-d H:i:s', qqG3Tuple_GetUtime($tuple, 0, 'ActualStartCaoDtZt')),
			'ActualEndCaoDtZt' => date('Y-m-d H:i:s', qqG3Tuple_GetUtime($tuple, 0, 'ActualEndCaoDtZt')),			
			'Tool1Identifier' => qqG3Tuple_GetString($tuple, 0, 'Tool1Identifier'),
			'Tool2Identifier' => qqG3Tuple_GetString($tuple, 0, 'Tool2Identifier')		  
		));
		
	}
	sort($data);
	$i = 1;
		foreach ($data as $employeeid => $rows) {
		sort($rows);
			foreach ($rows as $row) {
				echo $i++.'. ';
				echo $row['Tool1Identifier'].' ';
				echo $row['Tool2Identifier'].'<br>';
			}
			
		}
	
}

qqG3View_EndFetch($view);
qqG3View_Destroy($view);
qqG3Clip_Destroy($clip);
qqG3Server_Destroy($server);
?>