@include("../commons/styles.html")
@include("../commons/images.html") @args() { List
> items List
> loaderitems Map
info Locale locale String date_column String fromDate String toDate } @returnIf(items == null) @*Queries: * [ * { * "paramName" : "items", * "dateRangeSourceTable" : "r", * "query" : [ * "SELECT", * "distinct (result_lbls.label),", * "media.barcode, ", * "result_lbls.pool ", * "FROM ", * "result_lbls, ", * "media ", * "WHERE", * "result_lbls.saveset in ", * "(", * "SELECT ", * "r.saveset ", * "FROM ", * "count_results r", * "WHERE ", * "r.state in ('0','1') ", * "AND ", * "@(dateRange:@(date_column))", * ") ", * "AND ", * "result_lbls.pool in ", * "(", * "SELECT ", * "DISTINCT media_pools.name ", * "FROM ", * "media_pools ", * "WHERE", * "media_pools.drive_grp in ", * "(", * "SELECT ", * "hw_drives.grp_id ", * "FROM ", * "hw_drives ", * "WHERE ", * "hw_drives.drive_type NOT IN ", * "('SNAP_STORE','SNAP_NETAPP','DISK_STORE','DISK_HARD','DISK_CHNG','DVDRW','DVDR','CDRW','CDR')", * ")", * ")", * "AND ", * "result_lbls.label=media.label ", * "ORDER BY result_lbls.pool,result_lbls.label" * ] * }, * { * "paramName" : "loaderitems", * "dateRangeSourceTable" : "r", * "query" : [ * "SELECT", * "loader_contents.loader, ", * "loader_contents.number, ", * "loader_contents.lbl, ", * "loader_contents.object, ", * "loader_contents.barcode ", * "FROM ", * "loader_contents ", * "WHERE ", * "loader_contents.lbl in ", * "(", * "SELECT", * "result_lbls.label", * "FROM ", * "result_lbls, ", * "media ", * "WHERE", * "result_lbls.saveset in ", * "(", * "SELECT ", * "r.saveset ", * "FROM ", * "count_results r", * "WHERE ", * "r.state in ('0','1') ", * "AND ", * "@(dateRange:@(date_column))", * ")", * "AND ", * "result_lbls.pool in ", * "(", * "SELECT ", * "DISTINCT media_pools.name ", * "FROM ", * "media_pools ", * "WHERE", * "media_pools.drive_grp in ", * "(", * "SELECT ", * "hw_drives.grp_id ", * "FROM ", * "hw_drives ", * "WHERE ", * "hw_drives.drive_type NOT IN ", * "('SNAP_STORE','SNAP_NETAPP','DISK_STORE','DISK_HARD','DISK_CHNG','DVDRW','DVDR','CDRW','CDR')", * ")", * ")", * "AND ", * "result_lbls.label=media.label ", * ")", * "order by loader_contents.loader,loader_contents.object,loader_contents.number" * ] * } * ] *@ @include("../commons/tags.html") @include("../commons/functions.html") @sepReportHeader("Report") @sepTitleBox("Title", sepFnGetToday(locale), (String) info.get("name")) @if (date_column == "sesam_date") { @sepDateRangeLabel(sepFnGetDate(sepFnStringToDate(fromDate), locale), sepFnGetDate(sepFnStringToDate(toDate), locale), date_column) } else { @sepDateRangeLabel(sepFnGetDateLong(sepFnStringToDate(fromDate), locale), sepFnGetDateLong(sepFnStringToDate(toDate), locale), date_column) }
@i18n("MediaPool")
@i18n("Label")
@i18n("Barcode")
@{ String previousPool = null; String previousSaveset = null; boolean isFirstRow = true; } @for (Map
item : items) { @{ String pool = (String) item.get("pool"); boolean isNewPool = previousPool == null || !previousPool.equals(pool); }
@if (isNewPool) { @{ previousPool = pool; } @(pool) }
@(item.get("label"))
@(item.get("barcode"))
@{ isFirstRow = false; } }
@// if media still in library @if (loaderitems != null) {
@i18n("InLibrary")
@i18n("Loader")
@i18n("Object")
@i18n("Number")
@i18n("Label")
@i18n("Barcode")
@{ Integer previousLoader = 11111111; Integer loader = 22222222; boolean isFirstRowL = true; String loc = null; } @for (Map
loaderitem : loaderitems) { @{ loader = (Integer)loaderitem.get("loader"); boolean isNewLoader = previousLoader == 11111111 || !previousLoader.equals(loader) } @{ if ("slot".equals(loaderitem.get("object"))) {loc = "slot";} if ("drive".equals(loaderitem.get("object"))) {loc = "drive";} if ("port".equals(loaderitem.get("object"))) {loc = "port";} }
@if (isNewLoader) { @{ previousLoader = loader; } @(loader) }
@i18n(loc)
@(loaderitem.get("number"))
@(loaderitem.get("lbl"))
@(loaderitem.get("barcode"))
@{ isFirstRowL = false; } }
@i18n("hint1")
}