ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
60 stars 13 forks source link

Arctos Report Template Request - DMNS_Mamm_tags_back #5332

Open acdoll opened 1 year ago

acdoll commented 1 year ago

I've got this report close to where I'd like it. One thing I'm struggling with: I'd like to simplify the parts down to a handful of values (e.g., skin, skeleton, skull, tissues, parasites, mount, whole org). I tried something like this which I could duplicate for the various types except for tissues: case when strpos(flat.parts,'skin') > 0 then 'skin' else flat.parts end prts, Is there a part of the Require Tissues sql I could implement here?

acdoll commented 1 year ago

I've also done some weird stuff to get the text on the left to rotate. eg: .guid{text-orientation:mixed; font-weight:bold; font-size:7pt; transform: rotate(-90deg); transform-origin:bottom right; position: relative; right:-55; top:-25; width: 5mm; height:18mm; } It's hard to manipulate and it's not precisely where I want it. Is there a better way to do this?

dustymc commented 1 year ago

Require Tissues sql

That uses flat.has_tissues (0==nope, >0==yep) which comes from function has_tissue, maybe there's something useful in there?

hard to manipulate and it's not precisely where I want it

Sounds right! I don't actually know anything at all about Word-or-similar, but I suspect it might be better for that kind of layout than CSS (especially as interpreted by your browser's print-to-PDF and then reinterpreted by whatever you use to view PDFs).