views.py

#
# Copyright (c) 2014-2020 University of Dundee.
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as
# published by the Free Software Foundation, either version 3 of the
# License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
#

from django.http import Http404, HttpResponse, \
    JsonResponse
from django.views.decorators.http import require_POST
from django.conf import settings
from omero_figure import settings as figure_settings
from django.template import loader
from django.templatetags import static
from datetime import datetime
import os
import traceback
import json
import time

from omeroweb.webclient.show import paths_to_object

from omeroweb.webgateway.marshal import imageMarshal
from omeroweb.webgateway.views import _get_prepared_image
from omeroweb.webclient.views import run_script
from django.urls import reverse, NoReverseMatch
from omero.rtypes import wrap, rlong, rstring, unwrap
from omero.model import LengthI
from omero.model.enums import UnitsLength
from omero.cmd import ERR, OK
import omero
from omero_marshal import get_encoder

from io import BytesIO

from omeroweb.webclient.decorators import login_required
from .omeroutils import get_timestamps, get_wellsample_index

import logging

try:
    from PIL import Image
except ImportError:
    try:
        import Image
    except ImportError:
        pass

logger = logging.getLogger(__name__)

JSON_FILEANN_NS = "omero.web.figure.json"
LINK_FIGURE_NS = "omero.web.figure.link"
SCRIPT_PATH = "/omero/figure_scripts/Figure_To_Pdf.py"


def get_length_units():
    # Create a dict we can use for scalebar unit conversions
    unit_symbols = {}
    for name in LengthI.SYMBOLS.keys():
        if name in ("PIXEL", "REFERENCEFRAME"):
            continue
        klass = getattr(UnitsLength, name)
        unit = LengthI(1, klass)
        to_microns = LengthI(unit, UnitsLength.MICROMETER)
        unit_symbols[name] = {
            'symbol': unit.getSymbol(),
            'microns': to_microns.getValue()
        }
    return unit_symbols


@login_required()
def index(request, file_id=None, conn=None, **kwargs):
    """
    Single page 'app' for creating a Figure, allowing you to choose images
    and lay them out in canvas by dragging & resizing etc
    """

    # test for script to enable/diable export button
    script_service = conn.getScriptService()
    sid = script_service.getScriptID(SCRIPT_PATH)
    export_enabled = sid > 0
    script_version = None
    if export_enabled:
        try:
            params = script_service.getParams(sid)
            for key, param in params.inputs.items():
                if (key == "FIGURE_VERSION"):
                    script_version = unwrap(param.prototype)
        except Exception:
            logger.debug(traceback.format_exc())

    user = conn.getUser()
    is_admin = conn.isAdmin()
    user_full_name = "%s %s" % (user.firstName, user.lastName)
    max_w, max_h = conn.getMaxPlaneSize()
    max_plane_size = max_w * max_h
    length_units = get_length_units()
    cfg = conn.getConfigService()
    max_bytes = cfg.getConfigValue('omero.pixeldata.max_projection_bytes')
    max_active_channels = getattr(figure_settings, 'MAX_ACTIVE_CHANNELS', 10)
    is_public_user = "false"
    if (hasattr(settings, 'PUBLIC_USER')
            and settings.PUBLIC_USER == user.getOmeName()):
        is_public_user = "true"

    # Load the template html and replace OMEROWEB_INDEX
    template = loader.get_template("omero_figure/index.html")
    html = template.render({}, request)
    html = html.replace('const APP_SERVED_BY_OMERO = false;',
                        'const APP_SERVED_BY_OMERO = true;')
    omeroweb_index = reverse("index")
    figure_index = reverse("figure_index")
    ping_url = reverse("keepalive_ping")
    html = html.replace('const BASE_OMEROWEB_URL = dev_omeroweb_url;',
                        'const BASE_OMEROWEB_URL = "%s";' % omeroweb_index)
    html = html.replace('const APP_ROOT_URL = "";',
                        'const APP_ROOT_URL = "%s";' % figure_index)
    # Replace various other placeholder values with OMERO data/configs
    html = html.replace('const USER_ID = 0;', 'const USER_ID = %s' % user.id)
    html = html.replace('const PING_URL = "";',
                        'const PING_URL = "%s";' % ping_url)
    html = html.replace('const USER_FULL_NAME = "OME";',
                        'const USER_FULL_NAME = "%s";' % user_full_name)
    html = html.replace('const IS_PUBLIC_USER = false;',
                        'const IS_PUBLIC_USER = %s;' % is_public_user)
    html = html.replace('const MAX_PLANE_SIZE = 10188864;',
                        'const MAX_PLANE_SIZE = %s;' % max_plane_size)
    html = html.replace('const LENGTH_UNITS = LENGTHUNITS;',
                        'const LENGTH_UNITS = %s;' % json.dumps(length_units))
    html = html.replace('const MAX_ACTIVE_CHANNELS = 10;',
                        'const MAX_ACTIVE_CHANNELS = %s;'
                        % max_active_channels)

    if max_bytes:
        html = html.replace('const MAX_PROJECTION_BYTES = 1024 * 1024 * 256;',
                            'const MAX_PROJECTION_BYTES = %s;' % max_bytes)
    if export_enabled:
        html = html.replace('const EXPORT_ENABLED = false;',
                            'const EXPORT_ENABLED = true;')
        html = html.replace('const SCRIPT_VERSION = "";',
                            f'const SCRIPT_VERSION = "{script_version}"')
    if is_admin:
        html = html.replace('const IS_ADMIN = false;',
                            'const IS_ADMIN = true;')

    # update links to static files
    static_dir = static.static('omero_figure/')
    html = html.replace('href="/assets',
                        'href="%sassets' % static_dir)
    html = html.replace('src="/assets',
                        'src="%sassets' % static_dir)
    html = html.replace('const STATIC_DIR = "";',
                        'const STATIC_DIR = "%s";' % static_dir[0:-1])

    # bootstrap-icons. Use CDN when served by vite, but use static copy
    # when served by omero-web
    html = html.replace(
        "https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.0/font/",
        static_dir)
    return HttpResponse(html)


@login_required()
def max_projection_range_exceeded(request, iid, z=None, t=None,
                                  conn=None, **kwargs):
    """
    The app will use this URL instead of `render_image/` if the
    requested Z-projection range exceeds the maximum projected
    bytes (given the number of active channels)

    This returns a placeholder image with suitable message
    """

    from PIL import Image, ImageDraw, ImageFont

    font20 = ImageFont.load_default(20)
    msg = "Max Z projection disabled"
    msg_size = font20.getbbox(msg)
    txt_w = msg_size[2]
    txt_h = msg_size[3]

    image_size = txt_w + 10

    im = Image.new("RGB", (image_size, image_size), (5, 0, 0))
    draw = ImageDraw.Draw(im)
    text_y = im.size[1] / 2 - txt_h / 2
    draw.text((im.size[0] / 2 - txt_w / 2, text_y), msg,
              font=font20,
              fill=(256, 256, 256))

    rv = BytesIO()
    im.save(rv, "jpeg", quality=90)
    return HttpResponse(rv.getvalue(), content_type="image/jpeg")


@login_required()
def img_data_json(request, image_id, conn=None, **kwargs):
    image = conn.getObject("Image", image_id)
    if image is None:
        raise Http404("Image not found")

    # Test if we have Units support (OMERO 5.1)
    px = image.getPrimaryPixels().getPhysicalSizeX()
    pix_size_x = str(px)  # As string E.g. "0.13262 MICROMETER"
    units_support = " " in pix_size_x

    rv = imageMarshal(image)

    if units_support:
        # Add extra parameters with units data
        if 'pixel_size' not in rv:
            rv['pixel_size'] = {}
        # NB ['pixel_size']['x'] will have size in MICROMETER
        px = image.getPrimaryPixels().getPhysicalSizeX()
        if px is not None:
            rv['pixel_size']['valueX'] = px.getValue()
            rv['pixel_size']['symbolX'] = px.getSymbol()
            rv['pixel_size']['unitX'] = str(px.getUnit())
        py = image.getPrimaryPixels().getPhysicalSizeY()
        if py is not None:
            rv['pixel_size']['valueY'] = py.getValue()
            rv['pixel_size']['symbolY'] = py.getSymbol()
            rv['pixel_size']['unitY'] = str(py.getUnit())
        pz = image.getPrimaryPixels().getPhysicalSizeZ()
        if pz is not None:
            rv['pixel_size']['valueZ'] = pz.getValue()
            rv['pixel_size']['symbolZ'] = pz.getSymbol()
            rv['pixel_size']['unitZ'] = str(pz.getUnit())
    size_t = image.getSizeT()
    time_list = []
    if size_t > 1:
        time_list = get_timestamps(conn, image)
    rv['deltaT'] = time_list

    img_parents = {}
    for img_path in paths_to_object(conn, image_id=image_id):
        for item in img_path:
            o_type = item["type"]
            if o_type == "orphaned":
                continue
            del item["type"]
            img_parents[o_type] = item
            if o_type == "wellsample":
                idx_plate, idx_run = get_wellsample_index(conn, item["id"])
                item["index"] = idx_plate
                item["index_run"] = idx_run
                continue
            obj = conn.getObject(o_type, item["id"])
            if o_type == "well":
                item["label"] = obj.getWellPos()
            else:
                item["name"] = obj.getName()
    rv['parents'] = img_parents

    return HttpResponse(json.dumps(rv), content_type='json')


@login_required()
def timestamps(request, conn=None, **kwargs):
    iids = request.GET.getlist('image')
    data = {}
    for iid in iids:
        image = conn.getObject('Image', iid)
        if image is not None:
            data[image.id] = get_timestamps(conn, image)
    return JsonResponse(data)


@login_required()
def pixels_type(request, conn=None, **kwargs):
    iids = request.GET.getlist('image')
    data = {}
    for iid in iids:
        try:
            iid = int(iid)
        except ValueError:
            pass
        else:
            image = conn.getObject('Image', iid)
            if image is not None:
                data[image.id] = {
                    "pixelsType": image.getPixelsType(),
                    "pixel_range": image.getPixelRange()
                }
    return JsonResponse(data)


@login_required()
def z_scale(request, conn=None, **kwargs):
    iids = request.GET.getlist('image')
    data = {}
    for iid in iids:
        image = conn.getObject('Image', iid)
        if image is not None:
            pz = image.getPrimaryPixels().getPhysicalSizeZ()
            if pz is not None:
                data[image.id] = {'valueZ': pz.getValue(),
                                  'symbolZ': pz.getSymbol(),
                                  'unitZ': str(pz.getUnit())}
    return JsonResponse(data)


@login_required()
def render_scaled_region(request, iid, z, t, conn=None, **kwargs):
    region = request.GET.get('region')
    logger.debug("Rendering region: %s, Image: %s" % (region, iid))

    x, y, width, height = [float(r) for r in region.split(',')]
    max_size = request.GET.get('max_size', 2000)
    max_size = int(max_size)

    pi = _get_prepared_image(request, iid, conn=conn)
    if pi is None:
        raise Http404
    image, compress_quality = pi

    size_x = image.getSizeX()
    size_y = image.getSizeY()

    scale_levels = image.getZoomLevelScaling()
    if scale_levels is None:
        # Not a big image - can load at full size
        level = None
    else:
        # Pick zoom such that returned image is below MAX size
        max_level = len(scale_levels.keys()) - 1
        longest_side = max(width, height)

        # start small, and go until we reach target size
        zm = max_level
        while zm > 0 and scale_levels[zm - 1] * longest_side < max_size:
            zm = zm - 1

        level = max_level - zm

        # We need to use final rendered jpeg coordinates
        # Convert from original image coordinates by scaling
        scale = scale_levels[zm]
        x = int(x * scale)
        y = int(y * scale)
        width = int(width * scale)
        height = int(height * scale)
        size_x = int(size_x * scale)
        size_y = int(size_y * scale)

    canvas = None
    # Coordinates below are all final jpeg coordinates & sizes
    if x < 0 or y < 0 or (x + width) > size_x or (y + height) > size_y:
        # If we're outside the bounds of the image...
        # Need to render reduced region and paste on to full size image
        canvas = Image.new("RGB", (width, height), (221, 221, 221))
        paste_x = 0
        paste_y = 0
        if x < 0:
            paste_x = -x
            width = width + x
            x = 0
        if y < 0:
            paste_y = -y
            height = height + y
            y = 0

    # Render the region...
    jpeg_data = image.renderJpegRegion(z, t, x, y, width, height, level=level,
                                       compression=compress_quality)

    # paste to canvas if needed
    if canvas is not None:
        i = BytesIO(jpeg_data)
        to_paste = Image.open(i)
        canvas.paste(to_paste, (paste_x, paste_y))
        rv = BytesIO()
        canvas.save(rv, 'jpeg', quality=90)
        jpeg_data = rv.getvalue()

    return HttpResponse(jpeg_data, content_type='image/jpeg')


@login_required()
def save_web_figure(request, conn=None, **kwargs):
    """
    Saves 'figureJSON' in POST as an original file. If 'fileId' is specified
    in POST, then we update that file. Otherwise create a new one with
    name 'figureName' from POST.
    """

    update = conn.getUpdateService()
    if not request.method == 'POST':
        return HttpResponse("Need to use POST")

    figure_json = request.POST.get('figureJSON')
    if figure_json is None:
        return HttpResponse("No 'figureJSON' in POST")

    image_ids = []
    first_img_id = None
    try:
        json_data = json.loads(figure_json)
        for panel in json_data['panels']:
            try:
                image_ids.append(int(panel['imageId']))
            except ValueError:
                # For NGFF images, the imageId is a string
                pass
        if len(image_ids) > 0:
            first_img_id = image_ids[0]
        # remove duplicates
        image_ids = list(set(image_ids))
        # pretty-print json
        figure_json = json.dumps(json_data, sort_keys=True,
                                 indent=2, separators=(',', ': '))
    except Exception:
        pass

    # See https://github.com/will-moore/figure/issues/16
    figure_json = figure_json.encode('utf8')

    file_id = request.POST.get('fileId')

    if 'figureName' in json_data and len(json_data['figureName']) > 0:
        figure_name = json_data['figureName']
    else:
        n = datetime.now()
        # time-stamp name by default: WebFigure_2013-10-29_22-43-53.json
        figure_name = "Figure_%s-%s-%s_%s-%s-%s.json" % \
                      (n.year, n.month, n.day, n.hour, n.minute, n.second)

    # we store json in description field...
    description = {}
    if first_img_id is not None:
        # We duplicate the figure name here for quicker access when
        # listing files
        # (use this instead of file name because it supports unicode)
        description['name'] = figure_name
        description['imageId'] = first_img_id
        if 'baseUrl' in panel:
            description['baseUrl'] = panel['baseUrl']
    desc = json.dumps(description)

    if file_id is None:
        # Create new file
        # Try to set Group context to the same as first image
        curr_gid = conn.getEventContext().groupId
        i = None
        if first_img_id:
            i = conn.getObject("Image", first_img_id)
        if i is not None:
            gid = i.getDetails().getGroup().getId()
            conn.SERVICE_OPTS.setOmeroGroup(gid)
        else:
            # Don't leave as -1
            conn.SERVICE_OPTS.setOmeroGroup(curr_gid)
        file_size = len(figure_json)
        f = BytesIO()
        f.write(figure_json)
        orig_file = conn.createOriginalFileFromFileObj(
            f, '', figure_name, file_size, mimetype="application/json")
        fa = omero.model.FileAnnotationI()
        fa.setFile(omero.model.OriginalFileI(orig_file.getId(), False))
        fa.setNs(wrap(JSON_FILEANN_NS))
        fa.setDescription(wrap(desc))
        fa = update.saveAndReturnObject(fa, conn.SERVICE_OPTS)
        file_id = fa.getId().getValue()
    else:
        # Update existing Original File
        fa = conn.getObject("FileAnnotation", file_id)
        if fa is None:
            return Http404("Couldn't find FileAnnotation of ID: %s" % file_id)
        conn.SERVICE_OPTS.setOmeroGroup(fa.getDetails().group.id.val)
        # Update description
        fa._obj.setDescription(wrap(desc))
        update.saveAndReturnObject(fa._obj, conn.SERVICE_OPTS)
        orig_file = fa._obj.file
        # Update name and size
        orig_file.setName(rstring(figure_name))
        size = len(figure_json)
        orig_file.setSize(rlong(size))
        orig_file = update.saveAndReturnObject(
            orig_file, conn.SERVICE_OPTS)
        # upload file
        raw_file_store = conn.createRawFileStore()
        raw_file_store.setFileId(orig_file.getId().getValue(),
                                 conn.SERVICE_OPTS)
        raw_file_store.write(figure_json, 0, size, conn.SERVICE_OPTS)
        raw_file_store.truncate(size, conn.SERVICE_OPTS)  # ticket #11751
        # Once #11928 is fixed, these last 2 lines can be replaced with
        # rawFileStore.close(conn.SERVICE_OPTS)
        raw_file_store.save(conn.SERVICE_OPTS)
        raw_file_store.close()

    # create a new key-value pair for the new figure
    figure_url = request.build_absolute_uri(reverse('load_figure',
                                                    args=[file_id]))
    map_id = create_or_get_figure_kvp(conn, LINK_FIGURE_NS,
                                      figure_name, file_id, figure_url)

    # Link figure URL as key-value pair to all images (remove from any others)
    if map_id > 0:
        link_figure_kvp_to_images(conn, update, LINK_FIGURE_NS,
                                  image_ids, map_id)

    # Link file annotation to all images (remove from any others)
    link_to_images = False  # Disabled for now
    if link_to_images:
        current_links = conn.getAnnotationLinks("Image", ann_ids=[file_id])
        for link in current_links:
            if link.getParent().getId().getValue() not in image_ids:
                # remove old link
                update.deleteObject(link._obj, conn.SERVICE_OPTS)
            else:
                # we don't need to create links for these
                image_ids.remove(link.getParent().getId().getValue())

        # create new links if necessary
        links = []
        if len(image_ids) > 0:
            for i in conn.getObjects("Image", image_ids):
                if not i.canAnnotate():
                    continue
                link = omero.model.ImageAnnotationLinkI()
                link.parent = omero.model.ImageI(i.getId(), False)
                link.child = omero.model.FileAnnotationI(file_id, False)
                links.append(link)
            # Don't want to fail at this point due to strange permissions combo
            try:
                update.saveArray(links, conn.SERVICE_OPTS)
            except Exception:
                pass

    return HttpResponse(str(file_id))


def delete_figure_kvp(conn, ns, file_id):
    # get kvp
    ann = get_figure_kvp(conn, ns, file_id)
    if ann is not None and len(ann) > 0:
        map_ann = ann[0]
        map_id = map_ann[0]
        update = conn.getUpdateService()

        # get the links between the key-value and the linked images
        current_links = conn.getAnnotationLinks(
            "Image",
            ns=(wrap(ns)),
            ann_ids=[map_id]
        )
        # delete links
        for link in current_links:
            update.deleteObject(link._obj, conn.SERVICE_OPTS)

        # delete kvp
        conn.deleteObjects("Annotation", [map_id])


def link_figure_kvp_to_images(conn, update, ns, image_ids, map_id):
    # get the links between the key-value and the linked images
    current_links = conn.getAnnotationLinks(
        "Image",
        ns=(wrap(ns)),
        ann_ids=[map_id]
    )
    for link in current_links:
        if link.getParent().getId() not in image_ids:
            # remove old link
            update.deleteObject(link._obj, conn.SERVICE_OPTS)
        else:
            # we don't need to create links for these
            image_ids.remove(link.getParent().getId())

    # create new links if necessary
    links = []
    if len(image_ids) > 0:
        for i in conn.getObjects("Image", image_ids):
            if not i.canAnnotate():
                continue
            link = omero.model.ImageAnnotationLinkI()
            link.parent = omero.model.ImageI(i.getId(), False)
            link.child = omero.model.MapAnnotationI(map_id, False)
            links.append(link)
        # Don't want to fail at this point due to strange permissions combo
        try:
            update.saveArray(links, conn.SERVICE_OPTS)
        except Exception:
            pass


def create_or_get_figure_kvp(conn, ns, figure_name, file_id, figure_url):
    # retrieve the key-value corresponding to the current figure
    try:
        ann = get_figure_kvp(conn, ns, file_id)

        if ann is not None and len(ann) > 0:
            map_att = ann[0]
            map_name = map_att[1]
            if figure_name in map_name:
                return map_att[0]

            map_ann = conn.getObject('MapAnnotation', map_att[0])
        else:
            map_ann = omero.gateway.MapAnnotationWrapper(conn)
            map_ann.setNs(wrap(ns))

        map_ann.setValue([["Figure_%s_%s" % (file_id, figure_name),
                           figure_url]])
        map_ann.save()

        return map_ann.getId()
    except Exception:
        return -1


def get_figure_kvp(conn, ns, file_id):
    params = omero.sys.ParametersI()
    where_clause = []
    where_clause.append(f"mv.name like 'Figure_{file_id}%'")

    params.add('ns', wrap([ns]))
    where_clause.append("a.ns in (:ns)")
    where_clause.append("mv.value != '' ")

    qs = conn.getQueryService()
    q = """
            select distinct a.id, mv.name
                from Annotation a
                join a.mapValue mv where %s
            """ % (" and ".join(where_clause))

    results = qs.projection(q, params, conn.SERVICE_OPTS)
    return [[result[0].val, result[1].val] for result in results]


@login_required()
def load_web_figure(request, file_id, conn=None, **kwargs):
    """
    Loads the json stored in the file, identified by file annotation ID
    """

    file_ann = conn.getObject("FileAnnotation", file_id)
    if file_ann is None:
        raise Http404("Figure File-Annotation %s not found" % file_id)
    figure_json = b"".join(list(file_ann.getFileInChunks()))
    figure_json = figure_json.decode('utf8')
    json_file = file_ann.getFile()
    owner_id = json_file.getDetails().getOwner().getId()
    try:
        # parse the json, so we can add info...
        json_data = json.loads(figure_json)
        json_data['canEdit'] = owner_id == conn.getUserId()
        json_data['group'] = {
            'id': file_ann.getDetails().group.id.val,
            'name': file_ann.getDetails().group.name.val
        }
        # Figure name may not be populated: check in description...
        if 'figureName' not in json_data:
            desc = file_ann.getDescription()
            description = json.loads(desc)
            if 'name' in description:
                json_data['figureName'] = description['name']
            else:
                json_data['figureName'] = json_file.getName()
    except ValueError:
        # If the json failed to parse, return the string anyway
        return HttpResponse(figure_json, content_type='json')

    return HttpResponse(json.dumps(json_data), content_type='json')


@login_required(setGroupContext=True)
def make_web_figure(request, conn=None, **kwargs):
    """
    Uses the scripting service to generate pdf via json etc in POST data.
    Script will show up in the 'Activities' for users to monitor and
    download result etc.
    """
    if not request.method == 'POST':
        return HttpResponse("Need to use POST")

    script_service = conn.getScriptService()
    sid = script_service.getScriptID(SCRIPT_PATH)

    figure_json = request.POST.get('figureJSON')
    # export options e.g. "PDF", "PDF_IMAGES"
    export_option = request.POST.get('exportOption')
    webclient_uri = request.build_absolute_uri(reverse('webindex'))

    input_map = {
        'Figure_JSON': wrap(figure_json),
        'Export_Option': wrap(str(export_option)),
        'Webclient_URI': wrap(webclient_uri)}

    # If the figure has been saved, construct URL to it.
    figure_dict = json.loads(figure_json)
    if 'fileId' in figure_dict:
        try:
            figure_url = reverse('load_figure', args=[figure_dict['fileId']])
            figure_url = request.build_absolute_uri(figure_url)
            input_map['Figure_URI'] = wrap(figure_url)
        except NoReverseMatch:
            pass

    rsp = run_script(request, conn, sid, input_map, scriptName='Figure.pdf')
    return HttpResponse(json.dumps(rsp), content_type='json')


@login_required(isAdmin=True)
def upload_omero_script(request, conn=None, **kwargs):
    """Uploads or Replaces the Figure_To_Pdf.py"""

    if not request.method == 'POST':
        return HttpResponse("Need to use POST")

    script_service = conn.getScriptService()
    script_id = script_service.getScriptID(SCRIPT_PATH)

    this_dir = os.path.dirname(os.path.abspath(__file__))
    script_path = os.path.join(this_dir, "scripts", SCRIPT_PATH[1:])

    try:
        with open(script_path) as script_file:
            script_text = script_file.read()
    except Exception:
        logger.debug(traceback.format_exc())
        return JsonResponse({
            "Error": "Failed to load script from " + script_path})

    # If script exists, replace. Otherwise upload
    try:
        if script_id > 0:
            orig_file = omero.model.OriginalFileI(script_id, False)
            script_service.editScript(orig_file, script_text)
            message = "Script Replaced"
        else:
            script_id = script_service.uploadOfficialScript(
                SCRIPT_PATH, script_text)
            message = "Script Uploaded"
    except omero.ValidationException as ex:
        return JsonResponse({"Error": ex.message})

    return JsonResponse({"Message": message, "script_id": script_id})


@login_required()
def list_web_figures(request, conn=None, **kwargs):
    params = omero.sys.ParametersI()
    params.addString('ns', rstring(JSON_FILEANN_NS))
    q = """select new map(obj.id as id,
                obj.description as desc,
                o.id as owner_id,
                o.firstName as firstName,
                o.lastName as lastName,
                e.time as time,
                f.name as name,
                g.id as group_id,
                g.name as group_name,
                obj as obj_details_permissions)
            from FileAnnotation obj
            join obj.details.group as g
            join obj.details.owner as o
            join obj.details.creationEvent as e
            join obj.file.details as p
            join obj.file as f where obj.ns=:ns"""

    qs = conn.getQueryService()
    file_anns = qs.projection(q, params, conn.SERVICE_OPTS)
    rsp = []
    for file_ann in file_anns:
        fa = unwrap(file_ann[0])
        date = datetime.fromtimestamp(unwrap(fa['time']) / 1000)
        first_name = unwrap(fa['firstName'])
        last_name = unwrap(fa['lastName'])
        fig_file = {
            'id': unwrap(fa['id']),
            'name': unwrap(fa['name']),
            'description': unwrap(fa['desc']),
            'ownerFullName': "%s %s" % (first_name, last_name),
            'owner': {
                'id': fa['owner_id'],
                'firstName': fa['firstName'],
                'lastName': fa['lastName']
            },
            'group': {
                'id': fa['group_id'],
                'name': fa['group_name']
            },
            'creationDate': time.mktime(date.timetuple()),
            'canEdit': fa['obj_details_permissions'].get('canEdit')
        }
        rsp.append(fig_file)

    return HttpResponse(json.dumps(rsp), content_type='application/json')


def default_thumbnail(size=(120, 120)):
    """ Provide a placeholder thumbnail. Used in urls.py"""
    if isinstance(size, int):
        size = (size, size)
    if len(size) == 1:
        size = (size[0], size[0])
    img = Image.new("RGB", size, (238, 238, 238))
    f = BytesIO()
    img.save(f, "PNG")
    f.seek(0)
    return f.read()


@login_required()
def delete_web_figure(request, conn=None, **kwargs):
    """ POST 'fileId' to delete the FileAnnotation """

    if request.method != 'POST':
        return HttpResponse("Need to POST 'fileId' to delete")

    file_id = request.POST.get('fileId')
    delete_figure_kvp(conn, LINK_FIGURE_NS, file_id)
    conn.deleteObjects("Annotation", [file_id])
    return HttpResponse("Deleted OK")


def unit_conversion(request, value, from_unit, to_unit, conn=None, **kwargs):
    """
    OMERO 5.1 only: Converts Lengths of value in 'from_unit' to 'to_unit'.
    E.g. unit_conversion/1.12/MICROMETER/ANGSTROM/.
    Returns result as json with keys of 'value', 'unit' and 'symbol'
    """

    error = None
    try:
        from omero.model.enums import UnitsLength
        from_unit = getattr(UnitsLength, str(from_unit))
        to_unit = getattr(UnitsLength, str(to_unit))
        value = float(value)
    except ImportError:
        error = ("Failed to import omero.model.enums.UnitsLength."
                 " Requires OMERO 5.1")
    except AttributeError as ex:
        error = ex.message

    if error:
        return HttpResponse(json.dumps({'error': error}), content_type='json')

    from_value = omero.model.LengthI(value, from_unit)
    to_value = omero.model.LengthI(from_value, to_unit)

    rsp = {'value': to_value.getValue(),
           'unit': str(to_value.getUnit()),
           'symbol': to_value.getSymbol()}

    return HttpResponse(json.dumps(rsp), content_type='application/json')


@login_required()
def roi_rectangles(request, image_id, conn=None, **kwargs):
    """
    Load ROIs that have Rectangles and marshal with omero_marshal

    Returns similar JSON to /api/ rois, with meta.totalCount
    Supports pagination with ?offset and ?limit
    """

    params = omero.sys.ParametersI()
    params.addLong('image_id', image_id)
    limit = request.GET.get('limit')
    offset = request.GET.get('offset', 0)
    if limit is not None:
        params.page(int(offset), int(limit))
    query = """select roi from Roi roi join fetch
    roi.details.owner as owner join fetch roi.details.creationEvent
    left outer join fetch roi.shapes as shapes
    where roi.image.id = :image_id
    and shapes.class = Rectangle
    order by roi.id"""

    rois = conn.getQueryService().findAllByQuery(
        query, params, conn.SERVICE_OPTS)

    json_data = []
    for roi in rois:
        encoder = get_encoder(roi.__class__)
        json_data.append(encoder.encode(roi))

    count_query = """select count(distinct roi) from Roi roi
    left outer join roi.shapes as shapes
    where roi.image.id = :image_id
    and shapes.class = Rectangle"""
    params = omero.sys.ParametersI()
    params.addLong('image_id', image_id)
    result = conn.getQueryService().projection(count_query, params,
                                               conn.SERVICE_OPTS)
    total_count = result[0][0].val

    return JsonResponse({'data': json_data,
                         'meta': {'totalCount': total_count}})


@login_required()
def roi_count(request, image_id, conn=None, **kwargs):
    """
    Get the counts of ROIs and Shapes on the image
    """
    count_shapes = request.GET.get('shapes', False)
    params = omero.sys.ParametersI()
    params.addLong('image_id', image_id)
    query = 'select count(*) from Roi as roi ' \
            'where roi.image.id = :image_id'
    count = conn.getQueryService().projection(
        query, params, conn.SERVICE_OPTS)
    roi_count = count[0][0].getValue()
    rv = {'roi': roi_count}

    if count_shapes:
        query = 'select count(shape) from Shape as shape ' \
                'left outer join shape.roi as roi ' \
                'where roi.image.id = :imageId'
        count = conn.getQueryService().projection(
            query, params, conn.SERVICE_OPTS)
        shape_count = count[0][0].getValue()
        rv['shape'] = shape_count
    return HttpResponse(json.dumps(rv), content_type="application/json")


@require_POST
@login_required()
def chgrp(request, conn=None, **kwargs):
    group_id = int(request.POST.get("group_id"))
    ann_id = int(request.POST.get("ann_id"))

    handle = None
    rsp = None
    rv = {}
    try:
        handle = conn.chgrpObjects('Annotation', [ann_id], group_id)
        conn.c.waitOnCmd(
            handle, loops=10, ms=500,
            failonerror=True, failontimeout=False, closehandle=False)
        rsp = handle.getResponse()
    except Exception:
        rv['error'] = traceback.format_exc()
    finally:
        if handle is not None:
            handle.close()

    if isinstance(rsp, OK):
        rv['success'] = True
    elif isinstance(rsp, ERR):
        rv['name'] = rsp.name,
        params = ["%s: %s" % (k, v) for k, v in rsp.parameters.items()]
        rv['parameters'] = ", ".join(params)
        rv['error'] = "%s %s" % (rsp.name, ", ".join(params))
    return JsonResponse(rv)


@login_required()
def images_details(request, conn=None, **kwargs):
    imgs = request.GET.get('image', '')
    img_ids = [int(i) for i in imgs.split(',') if len(i) > 0]

    data = []
    for image in conn.getObjects('Image', img_ids):
        details = image.getDetails()
        data.append({
            'id': image.id,
            'name': image.name,
            'group': {
                'id': details.group.id.val,
                'name': details.group.name.val
            },
            'owner': {
                'id': details.owner.id.val,
                'firstName': details.owner.firstName.val,
                'lastName': details.owner.lastName.val
            }
        })

    return JsonResponse({'data': data})