$fields
=
array
('LoginHistory.windowname','LoginHistory.loginsubsystem','VirtualDevice.PHDEVICEID','LoginHistory.userid', 'VirtualDevice.SYSTYPEID','UserInfo.USERNAME','
"SUM"
(LoginHistory.LOGOUTTIME-LoginHistory.LOGINTIME) moument','UserInfo.USERNAME','DeviceInfo.DEVICENAME');
$group
=
array
('LoginHistory.windowname', 'LoginHistory.loginsubsystem', 'LoginHistory.userid','UserInfo.USERNAME','DeviceInfo.DEVICENAME','VirtualDevice.SYSTYPEID','VirtualDevice.PHDEVICEID');
$this
->paginate =
array
('conditions'=>
$conditions
,'fields'=>
$fields
,'group'=>
$group
,'limit'=>9,'joins' =>
array
(
array
(
'alias' => 'UserInfo',
'table' => 'SMM_USERINFO',
'type' => 'LEFT',
'conditions' => ' LoginHistory.USERID=UserInfo.USERID ',
),
array
(
'alias' => 'VirtualDevice',
'table' => 'ET_NMVIRTUALDEVICEINFO',
'type' => 'LEFT',
'conditions' => ' LoginHistory.WINDOWNAME=VirtualDevice.DEVICENAME ',
),
array
(
'alias' => 'DeviceInfo',
'table' => 'ET_NMDEVICEINFO',
'type' => 'LEFT',
'conditions' => ' VirtualDevice.PHDEVICEID=DeviceInfo.DEVICEID ',
),
));
$LoginHistory
=
$this
->paginate('LoginHistory');
$this
->set('loginhistory',
$LoginHistory
);