Yash Barot yashbarot

Real-time Grid Component with Laravel, Vue.js, Vuex & Socket.io (Google Docs-like Functionality)

Motivation

The exercise of writing this tutorial -- as well as recording it as a screencast -- has helped me better understand the concepts behind a couple of my favorite open source tools. Both the tutorial and screencast will be of personal use in the future as references. If they are of help to others, that will be great too.

I love Google Docs' real-time, multi-user interactive capability, and I've have always been a fan of spreadsheets. I wanted to see if I could replicate that type of functionality. What I've done is taken the basic Vue.js Grid Component example and altered it a bit so that when a user clicks on a cell, that cell becomes highlighted or "active", not just in the user's browser but in any browser instance cur

Basics

Creating a new PHPExcel Object.

    $this->PHPExcel = new PHPExcel();

Working with sheets

Creating a new sheet:

How to Install Wkhtmltopdf and Wkhtmltoimage in Ubuntu

wget http://download.gna.org/wkhtmltopdf/0.12/0.12.3/wkhtmltox-0.12.3_linux-generic-amd64.tar.xz
tar -xvf wkhtmltox-0.12.3_linux-generic-amd64.tar.xz
cd wkhtmltox/bin/
sudo mv wkhtmltopdf  /usr/bin/wkhtmltopdf
sudo mv wkhtmltoimage  /usr/bin/wkhtmltoimage

#Steps to install latest Laravel, LEMP on AWS Ubuntu 14.4 version. This tutorial is the improvised verision of this tutorial on Digitalocean based on my experience.

Install PHP 7 on Ubuntu

Run the following commands in sequence.

sudo apt-get install -y language-pack-en-base
sudo LC_ALL=en_US.UTF-8 add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install zip unzip

Change Text Color using default classes

<p class="text-muted">...</p>
<p class="text-primary">...</p>
<p class="text-success">...</p>
<p class="text-info">...</p>
<p class="text-warning">...</p>
<p class="text-danger">...</p>

	<!DOCTYPE html>

	<html lang="en">
	<head>
	<meta charset="utf-8">

	<title>HTML5 Local Storage Example</title>

	<!-- include Bootstrap CSS for layout -->
	<link href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.2.1/css/bootstrap-combined.min.css" rel="stylesheet">

	<?php


	class PhotoApiTest extends TestCase {

	public function setUp()
	{
	parent::setUp();

	Route::enableFilters();

	/* background-color is set to primary base color*/
	.bg-primary-color-base {
	background-color: #37474f;
	}

	/* color is set to primary base color*/
	.text-primary-color-base {
	color: #37474f;
	}

	/margin for all sides is set to 0px/
	.m-0 {
	margin: 0;
	}

	/margin for top side is set to 0px/
	.m-top-0 {
	margin-top: 0;
	}

	<?php

	namespace App\Providers;

	use Illuminate\Routing\Router;
	use Illuminate\Foundation\Support\Providers\RouteServiceProvider as ServiceProvider;

	class RouteServiceProvider extends ServiceProvider
	{
	/**