<?php
  use Illuminate\Support\Facades\Log;
  Log::warning("Entering add.blade");
use Illuminate\Support\Facades\Validator;
?>

@extends('layouts.app')

 <!-- Scripts -->
 <script src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
 <script src="//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.1/js/bootstrap.min.js"></script>
 <script type="text/javascript" src="js/date.js"></script>
 <script type="text/javascript" src="js/extras.js"></script>

<h3 style="color:red;">@include('errors.list')</h3>

 <?php
//dd($errors);
    //use Illuminate\Support\Facades\Log;
	//Log::warning("Entering add.blade");
    // $id = Request::input('id');
	$pagename = '';
	$actionurl = '';
	$doitbutton = '';
	if ('add' == Request::segment(1)) {
		// if 'add', set variables to 'old' versions
		$pagename = 'Add';
		$actionurl = url('add');
		$doitbutton = 'Add';
		$tsourceSystem     = old('sourceSystem');
		$tsourceRole       = old('sourceRole');
		$ttargetSystem     = old('DataMartDatabase');
		$ttargetRole       = old('targetRole');
		$ttargetBrioGroup  = old('targetBrioGroup');
		$ttargetDatamart   = old('DataMartName');
		$ttargetOBIEEGroup = old('targetOBIEEGroup');
		Log::warning("end if(add) fork");
	} elseif ('edit' == Request::segment(1) && (0 < strlen($id))) {
		// if 'edit', set variables to results of a select
		$pagename = 'Update';
		$actionurl = url('update');
		Log::error("actionurl is {$actionurl}");
		$doitbutton = 'Update';
		$tmapping = App\Dw_security_feed_mapping::find($id);
		if (!is_null($tmapping)) {
			$tsourceSystem     = $tmapping->source_system;
			$tsourceRole       = $tmapping->source_role;
			$ttargetSystem     = $tmapping->target_system;
			$ttargetRole       = $tmapping->target_role;
			$ttargetBrioGroup  = $tmapping->target_brio_group;
			$ttargetDatamart   = $tmapping->target_data_mart;
			$ttargetOBIEEGroup = $tmapping->target_obiee_group;
			// match date/time formatting of previous incarnation of this site
			$dtz = new DateTimeZone('America/New_York');
			$tcreateDate       = $tmapping->insert_dt;
			Log::error("tcreateDate is {$tcreateDate}");
			if (is_null($tcreateDate) || (is_string($tcreateDate) && 0 == strlen($tcreateDate))) {
				$tcreateDate = "(Timestamp not stored)";
			} else {
				$tcrtype = gettype($tcreateDate);
				Log::error("tcreateDate is of type {$tcrtype} and of value {$tcreateDate}");
				if ($tcrtype == 'object') {
					$tcrclass = get_class($tcreateDate);
					Log::error("   ... and is object of class {$tcrclass}");
					$rcdate = $tcreateDate;
				} else {
					$rcdate = date_create_from_format("Y-m-d h:i:s",$tcreateDate,$dtz);
				}
				$tcreateDate = date_format($rcdate,"l, F j, Y g:i:s A T");
			}
			$tcreateWho        = $tmapping->insert_id;
			$tupdateDate       = $tmapping->update_dt;
			Log::error("tupdateDate is {$tupdateDate}");
			if (is_null($tupdateDate) || (is_string($tupdateDate) && 0 == strlen($tupdateDate))) {
				$tupdateDate = "(Timestamp not stored)";
			} else {
				$tuptype = gettype($tupdateDate);
				if ($tuptype == 'object') {
					$rudate = $tupdateDate;
				} else {
					$rudate = date_create_from_format("Y-m-d h:i:s",$tupdateDate,$dtz);
				}
				$tupdateDate = date_format($rudate,"l, F j, Y g:i:s A T");
			}
			$tupdateWho        = $tmapping->update_id;
		} else {
			Log::error("Item to be edited {$id} not found");
		}
    }

	if (!isset($ttargetBrioGroup) || 0 == strlen(trim($ttargetBrioGroup))) {
		//$ttargetBrioGroup = 'NONE';
	}
	if (!isset($ttargetDatamart) || 0 == strlen(trim($ttargetDatamart))) {
		//$ttargetDatamart = 'NONE';
	}
	if (!isset($ttargetOBIEEGroup) || 0 == strlen(trim($ttargetOBIEEGroup))) {
		//$ttargetOBIEEGroup = 'NONE';
	}

	Log::warning("Done with add.blade prologue");

 ?>

@section('content')
    <div class="container">
        <div class="col-sm-offset-2 col-sm-8">
            <div class="panel panel-default">
                <div class="panel-heading">
				{{$pagename}} DW Security Record
					<p>&nbsp;</p>
                </div>

                <div class="panel-body">
                    <!-- Display Validation Errors -->
                    @include('common.errors')

					<p>&nbsp;</p>

					@if ('Add' == $pagename)
					<!-- [p]The first four fields must be filled in; the first field only [i]seems[/i] filled in.[/p] -->
					@endif

                    <!-- Add an Entry Form {{ csrf_field() }} -->
                    <form action="{{$actionurl}}" method="post" class="form-basic label-align">
                        {!! csrf_field() !!}

                        <!-- Source System      placeholder="PeopleSoft"  value="PeopleSoft" -->
                        <div class="form-group">
                            <label for="sourceSystem">Source System <span style="color:darkred">*</span></label>

                            <div class="input">
                                <input type="text" name="sourceSystem" placeholder="required" id="sourceSystem" class="medium" value="{{ $tsourceSystem }}" >
                            </div>
                        </div>

                        <!-- Source Role -->
                        <div class="form-group">
                            <label for="sourceRole">Source Role <span style="color:darkred">*</span></label>

                            <div class="input">
                                <input type="text" name="sourceRole" placeholder="required" id="sourceRole" class="medium" value="{{ $tsourceRole }}">
                            </div>
                        </div>

                        <!-- Target Datamart -->
                        <div class="form-group">
                            <label for="DataMartName">Data Mart Name <span style="color:darkred">*</span></label>

                            <div class="input">
                                <input type="text" name="DataMartName" placeholder="required" id="DataMartName" class="medium" value="{{ $ttargetDatamart }}">
                            </div>
                        </div>

						<!-- Target System -->
                        <div class="form-group">
                            <label for="DataMartDatabase">Data Mart Database<span style="color:darkred">*</span></label>

                            <div class="input">
                                <input type="text" name="DataMartDatabase" placeholder="required" id="DataMartDatabase" class="medium" value="{{ $ttargetSystem }}">
                            </div>
                        </div>

                        <!-- Target Role -->
                        <div class="form-group">
                            <label for="targetRole">Database Role <span style="color:darkred">*</span></label>

                            <div class="input">
                                <input type="text" name="targetRole" placeholder="required" id="targetRole" class="medium" value="{{ $ttargetRole }}">
                            </div>
                        </div>

                        <!-- Target Brio Group -->
                        <div class="form-group">
                            <label for="targetBrioGroup">Brio Group<span style="color:darkred">*</span></label>

                            <div class="input">
                                <input type="text" name="targetBrioGroup" placeholder="required" id="targetBrioGroup" class="medium" value="{{ $ttargetBrioGroup }}">
                            </div>
                        </div>

                        <!-- Target OBIEE Group -->
                        <div class="form-group">
                            <label for="targetOBIEEGroup">OBIEE Group<span style="color:darkred">*</span></label>

                            <div class="input">
                                <input type="text" name="targetOBIEEGroup" placeholder="required"  id="targetOBIEEGroup" class="medium" value="{{ $ttargetOBIEEGroup }}">
                            </div>
                        </div>

						@if ('Update' == $pagename)
						<input type="hidden" name="dw_security_feed_mapping_id" value="{{ $id }}">
						<script></script>
						<div class="something" style="font-size: smaller">
							<i><p>Added {{$tcreateDate}} by {{$tcreateWho}}</p>
							<p>Last updated {{$tupdateDate}} by {{$tupdateWho}}</p></i>
						</div>
						@endif

                        <!-- Add Mapping Button -->
                        <div class="form-group">
                            <div class="col-sm-offset-3 col-sm-6">
                                <button type="submit" class="btn btn-default">{{$doitbutton}}</button>
								<button type="reset" class="btn btn-default">Reset form</button>
                            </div>
                        </div>

                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection
