Improvement to Worksheets

siyamalan · April 11, 2019, 7:58am

Including Client Ref (even both Client SID and Client Reference) under sample ID would make Worksheets really useful.

User can just open a worksheet, check what a sample is and see the results straight away without clicking automatically generated Sample ID which doesn’t tell much

Worksheet like below can save lot of time
Client -> Example Winery
Sample ID -> lab-0008-R01
Client Ref / Client SID -> Tank Number/wine ref/ sample ref / blend ID

grulisco · April 11, 2019, 8:26am

This can be done by customization as we did in our.
I would like to see this in the senaite.core too…

siyamalan · April 11, 2019, 8:45am

Wow. I was hoping to do the same and searching for the correct .py file to edit.
can you point me in right direction.

Thanks

grulisco · April 12, 2019, 8:27am

I suppose this is the place in the core to look for:

github.com

senaite/senaite.core/blob/e7bd9790add346fc68daafbcf66abecbcecb3bcf/bika/lims/browser/worksheet/views/analyses.py#L503


    if obj.getReferenceType() == "b":
        item_img = "blank.png"
        item_img_text = t(_("Blank"))
    # parent
    supplier = obj.getSupplier()
    parent_obj = supplier
    parent_title = api.get_title(supplier)
    parent_url = api.get_url(supplier)
    parent_img = "supplier.png"
    parent_img_text = t(_("Supplier"))
elif IRoutineAnalysis.providedBy(obj):
    # item
    request = obj.getRequest()
    item_obj = request
    item_title = api.get_id(request)
    item_url = api.get_url(request)
    item_img = "sample.png"
    item_img_url = api.get_url(request)
    item_img_text = t(_("Sample"))
    # additional item icons
    additional_item_icons.append(

siyamalan · April 13, 2019, 8:12am

Thanks mate. Hopefully I can fix it

siyamalan · May 7, 2019, 11:09am

@xispa Hi, I understand that it is not ideal to have ClientSampleID info in the worksheet. For a laboratory that doesn’t have external clients, it is extremely helpful
Can you suggest a way to insert ClientSampleID or ClientReference in below code

xispa · May 20, 2019, 11:02pm

Adding this after L519 might work:

client_ref = request.getClientReference()
client_sid = request.getClientSampleID()
tokens = filter(None, [client_ref, client_sid])
sample_type_title = ' / '.join(tokens)

siyamalan · May 21, 2019, 5:42am

Works perfectly

Thanks @xispa

xuhaida · August 14, 2019, 11:53am

Like to see this in the setup and very convenient for us

Pirsisko · April 12, 2021, 6:16am

Thanks, this was really helpful.

Is there a possibility to adapt this change also into print sheet?

Thx
Petr

Pirsisko · June 8, 2021, 12:51pm

Update, I have found where to change worksheet export (worksheet/templates/print) I was able to remove some rows (such as sampling date), or add blank row. Now, I would like to add Client sample ID, but i cannot find command, how to call this item. Can someone help?