5 use OpenILS::Reporter::SQLBuilder;
10 column => { date => 'checkin_time' },
13 { relation=> 'circ-checkin_lib-aou',
14 column => 'shortname',
15 alias => 'Library Short Name',
17 { relation=> 'circ-circ_staff-au-card-ac',
19 alias => 'User Barcode',
22 column => { count => 'id' },
27 table => 'action.circulation',
32 alias => 'circ-circ_staff-au',
36 table => 'actor.card',
37 alias => 'circ-circ_staff-au-card-ac',
43 table => 'actor.org_unit',
44 alias => 'circ-checkin_lib-aou',
50 { relation => 'circ-checkin_lib-aou',
52 condition => { 'in' => '::PARAM1' },
55 column => 'checkin_time',
56 condition => { between => '::PARAM2' },
62 PARAM1 => [ 1, 2, 3, 4, 5, 6 ],
63 PARAM2 => [ '2006-09-01', '2006-10-01' ],
64 PARAM3 => 'Circ Count',
65 PARAM4 => 'Checkin Date',
68 my $r = OpenILS::Reporter::SQLBuilder->new;
70 $r->register_params( $params );
71 $r->parse_report( $report );