package           : tis-zimbra-connector-outlook
version           : 1947-5
architecture      : x64
section           : base
priority          : optional
name              : Zimbra Connector for Microsoft Outlook
categories        : Messaging
maintainer        : WAPT Team,Tranquil IT,Jimmy PELÉ,Jordan ARNAUD
description       : Zimbra Connector for Microsoft Outlook
depends           : 
conflicts         : 
maturity          : PROD
locale            : all
target_os         : windows
min_wapt_version  : 2.3
sources           : 
installed_size    : 
impacted_process  : 
description_fr    : Connecteur Zimbra pour Microsoft Outlook
description_pl    : Konektor Zimbra dla programu Microsoft Outlook
description_de    : Zimbra-Anschluss für Microsoft Outlook
description_es    : Conector Zimbra para Microsoft Outlook
description_pt    : Conector Zimbra para Microsoft Outlook
description_it    : Connettore Zimbra per Microsoft Outlook
description_nl    : Zimbra Connector voor Microsoft Outlook
description_ru    : Коннектор Zimbra для Microsoft Outlook
audit_schedule    : 10m
editor            : Synacor, Inc.
keywords          : 
licence           : opensource_free,wapt_public
homepage          : 
package_uuid      : a3b9f4bc-ae12-4e69-95b5-5ba33772e316
valid_from        : 
valid_until       : 
forced_install_on : 
changelog         : 
min_os_version    : 10.0
max_os_version    : 
icon_sha256sum    : 960bd49aacb32b189f0afcb8ea14ba56662cc2c42ed80992436da555cf0ce46a
signer            : Tranquil IT
signer_fingerprint: 8c5127a75392be9cc9afd0dbae1222a673072c308c14d88ab246e23832e8c6bb
signature_date    : 2025-04-22T09:00:21.000000
signed_attributes : package,version,architecture,section,priority,name,categories,maintainer,description,depends,conflicts,maturity,locale,target_os,min_wapt_version,sources,installed_size,impacted_process,description_fr,description_pl,description_de,description_es,description_pt,description_it,description_nl,description_ru,audit_schedule,editor,keywords,licence,homepage,package_uuid,valid_from,valid_until,forced_install_on,changelog,min_os_version,max_os_version,icon_sha256sum,signer,signer_fingerprint,signature_date,signed_attributes
signature         : lGYzyUF6oV+OdYe8PFiBwokmAUWpdpRYNQDXPGCs9mCrbsPAKgRjtPqo4sDWMLVOxwdyC+jyu79/Gt9pgBSkzPeexmnftcqc+tWJhFfC7hWQGo04vaqJVjSCJhuCD+etyC9jj1wd11dxRIAqJNEoVn5OjMCySNT465CjZ6hzjI0fo8FUBJW6BhoI2FS60PvHtLeltLdQ1UHyYOShNBZ+UUh7LuSzYvako3v71QlSjBHiaeHdnA7tFi5t8h6kQBAp+s3+RGOXb0tZY4zLGMzakDhbe9+aGbMNFqx3VutMq94ZlrpiBYt2YYf+nV5vedJFbkextD0Tcqq4XGZusDgsmw==

# -*- coding: utf-8 -*-
from setuphelpers import *

"""
{
   "key":"{E42A1466-88E2-4CD4-BB10-5DDF858232B5}",
   "name":"Zimbra Connector for Microsoft Outlook",
   "version":"0.0.0.1945",
   "install_date":"2025-01-06 00:00:00",
   "install_location":"",
   "uninstall_string":"MsiExec.exe /I{E42A1466-88E2-4CD4-BB10-5DDF858232B5}",
   "publisher":"Synacor, Inc.",
   "system_component":0,
   "win64":false
  }

"""


def install():
    if params.get("install_with_luti", False):
        WAPT.install("tis-microsoft-office-365-business")

    office_arch = registry_readstring(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\ClickToRun\Configuration", "Platform")
    if office_arch == "x86":
        bin_name = 'ZimbraConnectorOLK_x86.msi'
    else:
        bin_name = 'ZimbraConnectorOLK_x64.msi'

    try:
        install_msi_if_needed(
            bin_name,
            min_version=control.get_software_version(),
            timeout=300,
            keywords="Zimbra Connector",
            get_version=get_version
        )
    except Exception as e:
        if not installed_softwares("Outlook"):
            print(f"INFO: Microsoft Outlook needs to be installed.")
        raise

    # Customize installation
    with reg_openkey_noredir(HKEY_LOCAL_MACHINE, 'SOFTWARE\Zimbra', sam=KEY_WRITE, create_if_missing=True) as key:
        reg_setvalue(key, 'SkipVersionUpgrade', '65535', REG_SZ)  # disable auto-update
        # reg_setvalue(key, 'ZimbraServerName', 'smtp.mydomain.tld', REG_SZ)  # Zimbra server name
        # reg_setvalue(key, 'ZimbraServerPort', 443, REG_DWORD)  # Zimbra server port
        # reg_setvalue(key, 'ZimbraConnectionMethod', 1, REG_DWORD)  # use SSL
        # reg_setvalue(key, 'GalSyncDisableAliases', 1, REG_DWORD)  # disable alias in GAL
        # reg_setvalue(key, 'SigSyncEnabled', 0, REG_DWORD)  # disable signature sync


def get_version(key):
    return key['version'].split('.')[-1]


def audit():
    audit_result = "OK"

    office_arch = registry_readstring(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\ClickToRun\Configuration", "Platform")
    regpath = 'SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\Windows Search\Preferences'
    if is64() and office_arch == "x86":
        regpath = 'SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Windows\Windows Search\Preferences'

    # Fix Windows Search ZCO registry key if needed
    # https://wiki.zimbra.com/wiki/Summary_of_the_registry_keys_that_ZCO_uses
    # https://forums.zimbra.org/viewtopic.php?t=67734

    regpath = 'SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Windows\Windows Search\Preferences'
    for key in ['{D00FDE68-3E80-4f8c-899D-D9DD16BA7D1D}', '{FA9628A0-F223-4d5d-B314-E01BC8100572}']:
        if registry_readstring(HKEY_LOCAL_MACHINE, regpath, key) != "1":
                print(f'Fixing Windows Search ZCO registry key {key}...')
                registry_set(HKEY_LOCAL_MACHINE, regpath, key, 1, REG_DWORD)
                audit_result = "WARNING"

    return audit_result

# -*- coding: utf-8 -*-
from setuphelpers import *
from setupdevhelpers import *


def update_package():
    # Declaring local variables
    package_updated = False
    proxies = get_proxies()
    if not proxies:
        proxies = get_proxies_from_wapt_console()
    app_name = control.name
  
    url = "https://www.zimbra.com/product/addons/zimbra-connector-for-outlook-download/"
    print(f'URL used is: {url}')

    for arch in ['x86', 'x64']:

        print(f'Processing {arch} version')
        for bs_search in bs_find_all(url, 'a', 'rel', 'noopener', proxies=proxies):
            if f'_{arch}.msi' in bs_search.get('href', ''):
                download_url = bs_search['href']
                latest_bin = download_url.rsplit('/', 1)[-1]
                version = latest_bin.split('_')[1]
                break

        print(f'Latest {control.name} {arch} version is: {version}')
        print(f'Download URL for {arch} is: {download_url}')

        # Downloading latest binaries
        print(f'Downloading: {latest_bin}')
        latest_bin_split = latest_bin.split('_')
        latest_bin = f'{latest_bin_split[0]}_{latest_bin_split[2]}'
        wget(download_url, latest_bin, proxies=proxies)

        # Checking version from file
        version_from_file = get_version_from_binary(latest_bin).split('.')[-1]
        if Version(version_from_file, 4) == Version(version, 4):
            print(f'INFO: Binary file version ({version_from_file}) corresponds to online version ({version})')
        else:
            error(f'ERROR: Binary file version ({version_from_file}) do NOT corresponds to online version ({version})')

    # Downloading latest binaries
    print(f"Latest {app_name} version is: {version}")
    print(f"Download URL is: {download_url}")
    if not isfile(latest_bin):
        print(f"Downloading: {latest_bin}")
        wget(download_url, latest_bin, proxies=proxies)
    else:
        print(f"Binary is present: {latest_bin}")

    # Changing version of the package
    if Version(version) > Version(control.get_software_version()):
        print(f"Software version updated (from: {control.get_software_version()} to: {Version(version)})")
        package_updated = True
    else:
        print(f"Software version up-to-date ({Version(version)})")

    control.set_software_version(version)
    control.save_control_to_wapt()

    # Validating or not update-package-sources
    return package_updated