zubair1024

Oh my zsh.

Install with curl

sh -c "$(curl -fsSL https://raw.githubusercontent.com/robbyrussell/oh-my-zsh/master/tools/install.sh)"

Enabling Plugins (zsh-autosuggestions & zsh-syntax-highlighting)

• Download zsh-autosuggestions by

zubair1024

SELECT
*
FROM
dbo. STATUS;




SELECT
leads.Ref,

zubair1024

SELECT SUM(CONVERT(DECIMAL(29, 4), retentions.PremiumPolicy)) AS 'OldValue', 
       SUM(CONVERT(DECIMAL(29, 4), retentions.Premium)) AS 'NewValue', 
       SUM(CONVERT(DECIMAL(29, 4), retentions.PremiumDiff)) AS 'PremiumDiff', 
       retentions.OutcomeID, 
       users1.Username, 
       users1.FirstName, 
       users1.LastName, 
       retentions.CreatedDate
FROM dbo.Retention AS retentions
     --  LEFT JOIN dbo.LEAD AS leads ON retentions.LeadID = leads.ID

zubair1024

--- Statuses Changes
SELECT leads.Ref, 
       statuses.Name, 
       leads.StatusDate, 
       leads.StatusChangeReason, 
       users.Username AS 'Status Changed By'
FROM dbo.LEAD AS leads
     INNER JOIN dbo.STATUS AS statuses ON leads.StatusID = statuses.ID
     LEFT JOIN dbo.Users AS users ON leads.StatusChangedBy = users.ID
WHERE(leads.StatusDate >= '2019-12-04'

zubair1024

{
  "apps": [
    {
      "name": "web",
      "script": "C:\\ws\\engineer\\titan-web\\app.js",
      "args": [],
      "cwd": "C:\\ws\\engineer\\titan-web",
      "merge_logs": true,
      "instances": 1,
      "exec_mode": "cluster_mode",

zubair1024

Install IIS with reverse proxy to Node app

To configure IIS as reverse proxy you need to install the URL Rewrite extension and the Application Request Routing extension.

• https://www.iis.net/downloads/microsoft/url-rewrite

• https://www.iis.net/downloads/microsoft/application-request-routing

• Open IIS Manager

• Select your website

• Select URL Rewrite

• Select Reverse Proxy

zubair1024

Setting up OSRM backend using Docker

• Download map layer from source

wget https://download.geofabrik.de/asia/gcc-states-latest.osm.pbf

• Pre-process the extract with the car profile and start a routing engine HTTP server on port 5000

docker run -t -v "${PWD}:/data" osrm/osrm-backend osrm-extract -p /opt/car.lua /data/gcc-states-latest.osm.pbf

zubair1024

Setting up OSM tile server using Docker

• Download map layers

wget https://download.geofabrik.de/asia/gcc-states-latest.osm.pbf

• Make volume for osm data

docker volume create openstreetmap-data

zubair1024

Setup Nominatim using Docker

• Download map layer

wget https://download.geofabrik.de/asia/gcc-states-latest.osm.pbf

• Clone Repo

git clone https://github.com/zubair1024/dockerized-nominatim.git

• Build the docker image

zubair1024

OSM Test URLs

• Nominatim

http://example.com/nominatim/reverse?format=json&lat=25.230121&lon=55.287199&zoom=18&addressdetails=1

• OSM

http://example.com/