thehelvetian

Office Web Apps Viewer

('.ppt' '.pptx' '.doc', '.docx', '.xls', '.xlsx')

http://view.officeapps.live.com/op/view.aspx?src=[OFFICE_FILE_URL]

<iframe src='https://view.officeapps.live.com/op/embed.aspx?src=[OFFICE_FILE_URL]' width='px' height='px' frameborder='0'>
</iframe>

OneDrive Embed Links

thehelvetian

/**
* Mass (bulk) insert or update on duplicate for Laravel 4/5
* 
* insertOrUpdate([
*   ['id'=>1,'value'=>10],
*   ['id'=>2,'value'=>60]
* ]);
* 
*
* @param array $rows

thehelvetian

trait CreatesWithLock
{
  public static function updateOrCreate(array $attributes, array $values = [])
  {
    return static::advisoryLock(function () use ($attributes, $values) {
      // emulate the code found in Illuminate\Database\Eloquent\Builder
      return (new static)->newQuery()->updateOrCreate($attributes, $values);
    });
  }

thehelvetian

<?php

namespace App\Jobs;

use App\Product;
use Illuminate\Bus\Queueable;
use Illuminate\Support\Facades\Redis;
use Illuminate\Queue\SerializesModels;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;

thehelvetian

# This file is a template, and might need editing before it works on your project.
# Select image from https://hub.docker.com/_/php/
stages:
  - build_npm
  - build_and_test

# Select what we should cache between builds
cache:
  paths:
  - vendor/

thehelvetian

FROM php:7.1-fpm

# Update packages and install composer and PHP dependencies.
RUN apt-get update && \
  DEBIAN_FRONTEND=noninteractive apt-get install -y \
    postgresql-client \
    libpq-dev \
    libfreetype6-dev \
    libjpeg62-turbo-dev \
    libmcrypt-dev \

thehelvetian

FROM nginx

ADD deploy/nginx/nginx.conf /etc/nginx/
ADD deploy/nginx/default.conf /etc/nginx/conf.d/

ADD public /usr/share/nginx/html

WORKDIR /usr/share/nginx/html

thehelvetian

# Building our Nginx Docker image and tagging it with the ECR URL
docker build -f Dockerfile-nginx -t YOUR_ECR_REGISTRY_URL_HERE:nginx .
docker push YOUR_ECR_REGISTRY_URL_HERE:nginx

# Building our Laravel Docker image and tagging it with the ECR URL
docker build -t YOUR_ECR_REGISTRY_URL_HERE:laravel .
docker push YOUR_ECR_REGISTRY_URL_HERE:laravel

thehelvetian

aws ec2 run-instances 
    --image-id ami-c1a6bda2 
    --key-name laravelaws            # the SSH key pair we created earlier
    --security-group-ids sg-xxxxxxxx # our previous SG allowing access to the DB
    --subnet-id subnet-xxxxxxxx      # one of our public subnets
    --count 1 
    --instance-type t2.micro         # the smallest instance type allowed
    --tag-specifications 'ResourceType=instance,Tags=[{Key=Name,Value=bastion}]'

thehelvetian

# Add your key to your SSH agent
ssh-add -K laravelaws.pem

# Verify that your private key is successfully loaded in your local SSH agent
ssh-add –L

# Use the -A option to enable forwarding of the authentication agent connection
ssh –A ec2-user@<bastion-public-IP-address>

# Once you are connected to the bastion, you can SSH into a private subnet instance