nickdavies791

# Directory Aliases
alias code="cd $HOME/Code"

# Laravel Aliases
alias art="php artisan"
alias migrate="php artisan migrate"
alias rollback="php artisan migrate:rollback --step=1"
alias seed="php artisan db:seed"

# NPM Aliases

nickdavies791

WITH
  email_list (concatenated_emails)
AS 
  ( 
    SELECT 
      ADDEML_0 + ';'
    FROM
      AUTILIS
    WHERE 
      ENAFLG_0 = 2

nickdavies791

----------------------------------------
/**
 * 
 * All suppliers that have had an order
 * raised for them.
 * 
 */
----------------------------------------	
WITH order_list AS  (
	SELECT 	

nickdavies791

----------------------------------------
/**
 * 
 * Returns number of purchase orders
 * raised this period per company.
 * 
 */
----------------------------------------
WITH 
	orders_by_company (company, order_count) 

nickdavies791

#########################################################
##
## Uploads a file to a given folder and renames.
##
#########################################################
Funprog UPLOAD_FILE_AND_RENAME(TEMPDIR, FILDIR, FILNAM, NEWNAM)

  Variable Char TEMPDIR, FILDIR, FILNAM, NEWNAM
  Local Integer COPYSTA
  Local Integer MOVESTA

nickdavies791

----------------------------------------
/**
 * 
 * Returns Malta VAT Information.
 * 
 */
----------------------------------------

SELECT 
	poh.POHNUM_0 AS order_number,

nickdavies791

----------------------------------------
/**
 * 
 * Returns unsigned POs over x days old 
 * 
 * ORDDAT (Order date) <= 'xxx'
 * APPFLG (Signed) < 3 (No/Partly)
 * CLEFLG (Closed) <> 2 (No) 
 * FLGSIG (Signature) = 3 (To be signed)
 * 

nickdavies791

<?xml version="1.0" encoding="UTF-8"?>
<phpunit backupGlobals="false"
         backupStaticAttributes="false"
         bootstrap="vendor/autoload.php"
         colors="true"
         convertErrorsToExceptions="true"
         convertNoticesToExceptions="true"
         convertWarningsToExceptions="true"
         processIsolation="false"
         stopOnFailure="false">

nickdavies791

<?php

<?php

namespace App\Http\Middleware;

use Closure;

class MergeUserIdIntoRequest
{

nickdavies791

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class PagesController extends Controller
{
	/**
	* Return the requested view.