nickdavies791

APP_NAME=Laravel
APP_ENV=testing
APP_KEY= // key here
APP_DEBUG=true

nickdavies791

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Asset extends Model
{
	/**
	 * The attributes that are mass assignable.

nickdavies791

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

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

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

----------------------------------------
/**
 * 
 * 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

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

SELECT 
	poh.POHNUM_0 AS order_number,

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 number of purchase orders
 * raised this period per company.
 * 
 */
----------------------------------------
WITH 
	orders_by_company (company, order_count) 

nickdavies791

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

nickdavies791

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