wvulibraries / rockefeller-css

src/project-css/database/migrations/2016_12_06_234158_create_tables_table.php

Indentation +3 added lines, -3 removed lines

@@ -22,9 +22,9 @@
 
             // Table cascade if the collections are deleted
             $table->foreign('collection_id')
-                  ->references('id')
-                  ->on('collections')
-                  ->onDelete('cascade');
+                    ->references('id')
+                    ->on('collections')
+                    ->onDelete('cascade');
         });
     }
 

src/project-css/tests/AuthTest.php

Indentation +20 added lines, -20 removed lines

@@ -46,39 +46,39 @@
 
         // Type some valid values
         $this->visit('/login')
-             ->type($this->adminEmail, 'email')
-             ->type($this->adminPass, 'password')
-             ->press('Login');
+                ->type($this->adminEmail, 'email')
+                ->type($this->adminPass, 'password')
+                ->press('Login');
 
         // Type some valid values
         $this->visit('/register')
-             ->type($this->userName, 'name')
-             ->type($this->userEmail, 'email')
-             ->type($this->userPass, 'password')
-             ->type($this->userPass, 'password_confirmation')
-             ->press('Register')
-             ->seePageIs('/users');
+                ->type($this->userName, 'name')
+                ->type($this->userEmail, 'email')
+                ->type($this->userPass, 'password')
+                ->type($this->userPass, 'password_confirmation')
+                ->press('Register')
+                ->seePageIs('/users');
     }
 
     /** @test */
     public function testWrongLoginCredentials() {
         $this->visit(route('login'))
-             ->type($this->userEmail, 'email')
-             ->type('invalid-password', 'password')
-             ->press('Login')
-             ->see('These credentials do not match our records.');
+                ->type($this->userEmail, 'email')
+                ->type('invalid-password', 'password')
+                ->press('Login')
+                ->see('These credentials do not match our records.');
     }
 
     /** @test */
     public function testForgotPasswordWithIncorrectEmail() {
         $this->visit('/password/reset')
-             ->see('Reset Password')
-             ->type('test', 'email')
-             ->press('Send Password Reset Link')
-             ->see('The email must be a valid email address.')
-             ->type('test@nowhere.com', 'email')
-             ->press('Send Password Reset Link')
-             ->see("We can't find a user with that e-mail address.");
+                ->see('Reset Password')
+                ->type('test', 'email')
+                ->press('Send Password Reset Link')
+                ->see('The email must be a valid email address.')
+                ->type('test@nowhere.com', 'email')
+                ->press('Send Password Reset Link')
+                ->see("We can't find a user with that e-mail address.");
     }
 
     /** @test */

src/project-css/app/Libraries/TikaConvert.php

Indentation +3 added lines, -3 removed lines

@@ -20,7 +20,7 @@ 
     }
 
     function setTikaPort($port) {
-      $this->tika_port = $port;
+        $this->tika_port = $port;
     }
 
     /**
@@ -33,12 +33,12 @@ 
     {
         // verify that file exists
         if (!$filename || !file_exists($filename)) {
-          return false;
+            return false;
         }
 
         // verify that tika server is accepting connections
         if (!$this->serverOpen()) {
-          return false;
+            return false;
         }
 
         // this is one way to use the tika server using the exec command creates a temporary file

src/project-css/app/Http/Controllers/TableController.php

Braces +1 added lines, -2 removed lines

@@ -726,8 +726,7 @@
           $prcssd += 1;
           $curFltFleObj->next();
         }
-      }
-      else {
+      } else {
         throw new \Exception("Cannot Import a Empty File.");
       }
     }

Indentation +243 added lines, -243 removed lines

@@ -28,77 +28,77 @@ 
      * Create a new controller instance.
      */
     public function __construct($storageFolder = 'flatfiles') {
-      // Protection to make sure this is only accessible to admin
-      $this->middleware('admin');
-      // Storage directory
-      $this->strDir = $storageFolder;
-      // offset for extra colmns
-      $this->extraClmns = 3;
+        // Protection to make sure this is only accessible to admin
+        $this->middleware('admin');
+        // Storage directory
+        $this->strDir = $storageFolder;
+        // offset for extra colmns
+        $this->extraClmns = 3;
     }
 
     /**
-    * Show the table index page
-    */
+     * Show the table index page
+     */
     public function index() {
-      // Get all the table records
-      $tbls = Table::all();
-      // return the index page
-      return view('admin/table')->with('tbls', $tbls);
+        // Get all the table records
+        $tbls = Table::all();
+        // return the index page
+        return view('admin/table')->with('tbls', $tbls);
     }
 
     /**
-    * Show the wizard page
-    */
+     * Show the wizard page
+     */
     public function wizard() {
-      // Get the collection names
-      $collcntNms = Collection::all();
+        // Get the collection names
+        $collcntNms = Collection::all();
 
-      // Get the list of files in the directory
-      $fltFleList = Storage::allFiles($this->strDir);
+        // Get the list of files in the directory
+        $fltFleList = Storage::allFiles($this->strDir);
 
-      // Format the file names by truncating the dir
-      foreach ($fltFleList as $key => $value) {
+        // Format the file names by truncating the dir
+        foreach ($fltFleList as $key => $value) {
         // check if directory string exists in the path
         if (str_contains($value, $this->strDir.'/')) {
-          // replace the string
-          $fltFleList[ $key ] = str_replace($this->strDir.'/', '', $value);
+            // replace the string
+            $fltFleList[ $key ] = str_replace($this->strDir.'/', '', $value);
+        }
         }
-      }
 
-      // Compact everything into array
-      $wizrdData = array(
+        // Compact everything into array
+        $wizrdData = array(
         'collcntNms' => $collcntNms,
         'fltFleList' => $fltFleList
-      );
+        );
 
-      // Check for the countflatfiles
-      if ($collcntNms->where('isEnabled', '1')->count()>0) {
+        // Check for the countflatfiles
+        if ($collcntNms->where('isEnabled', '1')->count()>0) {
         // return the wizard page by passing the collections
         return view('admin/wizard')->with($wizrdData);
-      }
+        }
 
-      // return the wizard page by passing the collections and list of files
-      return view('admin/collection')->with('collcntNms', $collcntNms)->withErrors([ 'Please create active collection here first' ]);
+        // return the wizard page by passing the collections and list of files
+        return view('admin/collection')->with('collcntNms', $collcntNms)->withErrors([ 'Please create active collection here first' ]);
     }
 
     /**
-    * Importing the records into table follows:
-    * 1. Input the table name in the meta Directory
-    * 2. Store the file on to Storage Directory if uploaded
-    * 3. Show the users schema for further verification
-    */
+     * Importing the records into table follows:
+     * 1. Input the table name in the meta Directory
+     * 2. Store the file on to Storage Directory if uploaded
+     * 3. Show the users schema for further verification
+     */
     public function import(Request $request) {
 
-      // 1. Input the table name in the meta Directory
-      //Rules for validation
-      $rules = array(
+        // 1. Input the table name in the meta Directory
+        //Rules for validation
+        $rules = array(
         'imprtTblNme' => 'required|unique:tables,tblNme|max:30|min:6|alpha_num',
         'colID' => 'required|Integer',
         'fltFile' => 'required|file|mimetypes:text/plain|mimes:txt,dat,csv,tab',
-      );
+        );
 
-      //Customize the error messages
-      $messages = array(
+        //Customize the error messages
+        $messages = array(
         'imprtTblNme.required' => 'Please enter a table name',
         'imprtTblNme.unique' => 'The table name has already been taken by current or disabled table',
         'imprtTblNme.max' => 'The table name cannot exceed 30 characters',
@@ -110,70 +110,70 @@ 
         'fltFile.file' => 'Please select a valid flat file',
         'fltFile.mimetypes' => 'The flat file must be a file of type: text/plain.',
         'fltFile.mimes' => 'The flat file must have an extension: txt, dat, csv, tab.',
-      );
+        );
 
-      // Validate the request before storing the data
-      $this->validate($request, $rules, $messages);
+        // Validate the request before storing the data
+        $this->validate($request, $rules, $messages);
 
-      // Validate the file before upload
-      // Get the file
-      $thisFltFile = $request->fltFile;
+        // Validate the file before upload
+        // Get the file
+        $thisFltFile = $request->fltFile;
 
-      // Get the file name
-      $thisFltFileNme = $thisFltFile->getClientOriginalName();
+        // Get the file name
+        $thisFltFileNme = $thisFltFile->getClientOriginalName();
 
-      // check if the file exists
-      // Get the list of files in the directory
-      $fltFleList = Storage::allFiles($this->strDir);
+        // check if the file exists
+        // Get the list of files in the directory
+        $fltFleList = Storage::allFiles($this->strDir);
 
-      // check the file name in the file list array
-      if (in_array($this->strDir.'/'.$thisFltFileNme, $fltFleList)) {
+        // check the file name in the file list array
+        if (in_array($this->strDir.'/'.$thisFltFileNme, $fltFleList)) {
         return redirect()->route('tableIndex')->withErrors([ 'File already exists. Please select the file or rename and re-upload.' ]);
-      }
+        }
 
-      // 2. Store the file on to Storage Directory if uploaded
-      // Store in the directory inside storage/app
-      $thisFltFile->storeAs($this->strDir, $thisFltFileNme);
+        // 2. Store the file on to Storage Directory if uploaded
+        // Store in the directory inside storage/app
+        $thisFltFile->storeAs($this->strDir, $thisFltFileNme);
 
-      // 3. Show the users schema for further verification
-      $schema = (new CSVHelper)->schema($this->strDir.'/'.$thisFltFileNme);
+        // 3. Show the users schema for further verification
+        $schema = (new CSVHelper)->schema($this->strDir.'/'.$thisFltFileNme);
 
-      // If the file isn't valid return with an error
-      if (!$schema) {
+        // If the file isn't valid return with an error
+        if (!$schema) {
         Storage::delete($fltFleAbsPth);
         return redirect()->route('tableIndex')->withErrors([ 'The selected flat file must be of type: text/plain', 'The selected flat file should not be empty', 'File is deleted for security reasons' ]);
-      }
+        }
 
-      // Return the view with filename and schema
-      return view('admin.schema')->with('schema', $schema)
-                                 ->with('tblNme', $request->imprtTblNme)
-                                 ->with('fltFile', $thisFltFileNme)
-                                 ->with('collctnId', $request->colID);
+        // Return the view with filename and schema
+        return view('admin.schema')->with('schema', $schema)
+                                    ->with('tblNme', $request->imprtTblNme)
+                                    ->with('fltFile', $thisFltFileNme)
+                                    ->with('collctnId', $request->colID);
     }
 
     public function importCMSDIS(Request $request) {
-      return (new TableHelper)->storeUploadsAndImport($this->strDir, $request->colID, $request->cmsdisFiles);
+        return (new TableHelper)->storeUploadsAndImport($this->strDir, $request->colID, $request->cmsdisFiles);
     }
 
     /**
-    * Use the existing file to import the records:
-    * Algorithm:
-    * 1. Get the file name and validate file, if not validated remove it
-    * 2. Create the table with schema
-    * 3. Show the users with the schema
-    */
+     * Use the existing file to import the records:
+     * Algorithm:
+     * 1. Get the file name and validate file, if not validated remove it
+     * 2. Create the table with schema
+     * 3. Show the users with the schema
+     */
     public function select(Request $request) {
 
-      // 1. Get the file name and validate file, if not validated remove it
-      //Rules for validation
-      $rules = array(
+        // 1. Get the file name and validate file, if not validated remove it
+        //Rules for validation
+        $rules = array(
         'slctTblNme' => 'required|unique:tables,tblNme|max:30|min:6|alpha_num',
         'colID2' => 'required|Integer',
         'fltFile2' => 'required|string',
-      );
+        );
 
-      //Customize the error messages
-      $messages = array(
+        //Customize the error messages
+        $messages = array(
         'slctTblNme.required' => 'Please enter a table name',
         'slctTblNme.unique' => 'The table name has already been taken by current or disabled table',
         'slctTblNme.max' => 'The table name cannot exceed 30 characters',
@@ -183,54 +183,54 @@ 
         'colID2.Integer' => 'Please select an existing collection',
         'fltFile2.required' => 'Please select a valid flat file',
         'fltFile2.string' => 'Please select a valid flat file',
-      );
+        );
 
-      // Validate the request before storing the data
-      $this->validate($request, $rules, $messages);
+        // Validate the request before storing the data
+        $this->validate($request, $rules, $messages);
 
-      // Get the absolute file path
-      $thsFltFile = $request->fltFile2;
-      $fltFleAbsPth = $this->strDir.'/'.$thsFltFile;
-      // validate the file
-      if (!Storage::has($fltFleAbsPth)) {
+        // Get the absolute file path
+        $thsFltFile = $request->fltFile2;
+        $fltFleAbsPth = $this->strDir.'/'.$thsFltFile;
+        // validate the file
+        if (!Storage::has($fltFleAbsPth)) {
         // if the file doesn't exist
         return redirect()->route('tableIndex')->withErrors([ 'The selected flat file does not exist' ]);
-      }
+        }
 
-      // 2. Check for file validity and Create the table with schema
-      $schema = (new CSVHelper)->schema($fltFleAbsPth);
-      // If the file isn't valid return with an error
-      if (!$schema) {
+        // 2. Check for file validity and Create the table with schema
+        $schema = (new CSVHelper)->schema($fltFleAbsPth);
+        // If the file isn't valid return with an error
+        if (!$schema) {
         Storage::delete($fltFleAbsPth);
         return redirect()->route('tableIndex')->withErrors([ 'The selected flat file must be of type: text/plain', 'The selected flat file should not be empty', 'File is deleted for security reasons' ]);
-      }
+        }
 
-      // 3. Show the users with the schema
-      return view('admin.schema')->with('schema', $schema)
-                                 ->with('tblNme', $request->slctTblNme)
-                                 ->with('fltFile', $request->fltFile2)
-                                 ->with('collctnId', $request->colID2);
+        // 3. Show the users with the schema
+        return view('admin.schema')->with('schema', $schema)
+                                    ->with('tblNme', $request->slctTblNme)
+                                    ->with('fltFile', $request->fltFile2)
+                                    ->with('collctnId', $request->colID2);
     }
 
     public function selectCMSDIS(Request $request) {
-      return (new TableHelper)->selectFilesAndImport($this->strDir, $request->colID2, $request->cmsdisFiles2);
+        return (new TableHelper)->selectFilesAndImport($this->strDir, $request->colID2, $request->cmsdisFiles2);
     }
 
     /**
-    * Method to read input from the schema and start actual data import
-    */
+     * Method to read input from the schema and start actual data import
+     */
     public function finalize(Request $request) {
-      // 1. Get the number of columns, collctn id and table name before creating the table
-      $kVal = intval($request->kCnt);
-      $tblNme = strval($request->tblNme);
-      $fltFile = strval($request->fltFile);
-      $collctnId = strval($request->collctnId);
-
-      // Before anything validate that all the data is strings
-      // Define array
-      $rules = array();
-      // Add rule for each entry in request
-      for ($i = 0; $i<$kVal; $i++) {
+        // 1. Get the number of columns, collctn id and table name before creating the table
+        $kVal = intval($request->kCnt);
+        $tblNme = strval($request->tblNme);
+        $fltFile = strval($request->fltFile);
+        $collctnId = strval($request->collctnId);
+
+        // Before anything validate that all the data is strings
+        // Define array
+        $rules = array();
+        // Add rule for each entry in request
+        for ($i = 0; $i<$kVal; $i++) {
         // Rules for all names
         $curNme = 'col-'.$i.'-name';
         $rules[ $curNme ] = 'required|alpha_dash';
@@ -240,81 +240,81 @@ 
         // Rules for all data sizes
         $curDataSz = 'col-'.$i.'-size';
         $rules[ $curDataSz ] = 'required|string';
-      }
-      // Validate
-      $this->validate($request, $rules);
+        }
+        // Validate
+        $this->validate($request, $rules);
 
-      // 2. Create the table
-      Schema::connection('mysql')->create($tblNme, function(Blueprint $table) use($kVal, $request){
+        // 2. Create the table
+        Schema::connection('mysql')->create($tblNme, function(Blueprint $table) use($kVal, $request){
         // Default primary key
         $table->increments('id');
         // Add all the dynamic columns
         for ($i = 0; $i<$kVal; $i++) {
-          // Define current column name, type and size
-          $curColNme = strval($request->{'col-'.$i.'-name'});
-          $curColType = strval($request->{'col-'.$i.'-data'});
-          $curColSze = strval($request->{'col-'.$i.'-size'});
-
-          // Filter the data type and size and create the column
-          // Check for Strings
-          if (str_is($curColType, 'string')) {
+            // Define current column name, type and size
+            $curColNme = strval($request->{'col-'.$i.'-name'});
+            $curColType = strval($request->{'col-'.$i.'-data'});
+            $curColSze = strval($request->{'col-'.$i.'-size'});
+
+            // Filter the data type and size and create the column
+            // Check for Strings
+            if (str_is($curColType, 'string')) {
             // Check for the data type
             // Default
             if (str_is($curColSze, 'default')) {
-              // For String default is 30 characters
-              $table->string($curColNme, 50)->default("Null");
+                // For String default is 30 characters
+                $table->string($curColNme, 50)->default("Null");
             }
             // Medium
             if (str_is($curColSze, 'medium')) {
-              // For String medium is 150 characters
-              $table->string($curColNme, 150)->default("Null");
+                // For String medium is 150 characters
+                $table->string($curColNme, 150)->default("Null");
             }
             // Big
             if (str_is($curColSze, 'big')) {
-              // For String big is 500 characters
-              $table->string($curColNme, 500)->default("Null");
+                // For String big is 500 characters
+                $table->string($curColNme, 500)->default("Null");
+            }
             }
-          }
 
-          // Check for Text data type
-          if (str_is($curColType, 'text')) {
+            // Check for Text data type
+            if (str_is($curColType, 'text')) {
             // Check for the data type
             // Default
             if (str_is($curColSze, 'default')) {
-              // For text default is text type
-              $table->text($curColNme);
+                // For text default is text type
+                $table->text($curColNme);
             }
             // Medium
             if (str_is($curColSze, 'medium')) {
-              // For text medium is mediumtext type
-              $table->mediumText($curColNme);
+                // For text medium is mediumtext type
+                $table->mediumText($curColNme);
             }
             // Big
             if (str_is($curColSze, 'big')) {
-              // For text big is longtext type
-              $table->longText($curColNme);
+                // For text big is longtext type
+                $table->longText($curColNme);
+            }
             }
-          }
 
-          // Check for Integer
-          if (str_is($curColType, 'integer')) {
+            // Check for Integer
+            if (str_is($curColType, 'integer')) {
             // Check for the data type
             // Default
             if (str_is($curColSze, 'default')) {
-              // For Integer default integer type
-              $table->integer($curColNme)->default(0);
+                // For Integer default integer type
+                $table->integer($curColNme)->default(0);
             }
             // Medium
             if (str_is($curColSze, 'medium')) {
-              // For Integer medium is medium integer
-              $table->mediumInteger($curColNme)->default(0);
+                // For Integer medium is medium integer
+                $table->mediumInteger($curColNme)->default(0);
             }
             // Big
             if (str_is($curColSze, 'big')) {
-              // For Integer big is big integer
-              $table->bigInteger($curColNme)->default(0);
+                // For Integer big is big integer
+                $table->bigInteger($curColNme)->default(0);
+            }
             }
-          }
         }
 
         // search index
@@ -322,88 +322,88 @@ 
 
         // Time stamps
         $table->timestamps();
-      });
+        });
 
-      // modify table for fulltext search using the srchindex column
-      DB::connection()->getPdo()->exec('ALTER TABLE '.$tblNme.' ADD FULLTEXT fulltext_index (srchindex)');
+        // modify table for fulltext search using the srchindex column
+        DB::connection()->getPdo()->exec('ALTER TABLE '.$tblNme.' ADD FULLTEXT fulltext_index (srchindex)');
 
-      // Finally create the table
-      // Save the table upon the schema
-      (new TableHelper)->crteTblInCollctn($tblNme, $collctnId);
+        // Finally create the table
+        // Save the table upon the schema
+        (new TableHelper)->crteTblInCollctn($tblNme, $collctnId);
 
-      // create folder in storage that will contain any additional files associated to the table
-      if (Storage::exists($tblNme) == FALSE) {
+        // create folder in storage that will contain any additional files associated to the table
+        if (Storage::exists($tblNme) == FALSE) {
         Storage::makeDirectory($tblNme, 0775);
-      }
+        }
 
-      // Finally return the view to load data
-      return $this->load(True, $tblNme, $fltFile);
+        // Finally return the view to load data
+        return $this->load(True, $tblNme, $fltFile);
     }
 
     /**
-    * Method to format the storage files
-    **/
+     * Method to format the storage files
+     **/
     public function getFiles($strDir) {
-      // Get the list of files in the directory
-      $fltFleList = Storage::allFiles($strDir);
+        // Get the list of files in the directory
+        $fltFleList = Storage::allFiles($strDir);
 
-      // Format the file names by truncating the dir
-      foreach ($fltFleList as $key => $value) {
+        // Format the file names by truncating the dir
+        foreach ($fltFleList as $key => $value) {
         // check if directory string exists in the path
         if (str_contains($value, $this->strDir.'/')) {
-          // replace the string
-          $fltFleList[ $key ] = str_replace($this->strDir.'/', '', $value);
+            // replace the string
+            $fltFleList[ $key ] = str_replace($this->strDir.'/', '', $value);
+        }
         }
-      }
 
-      // return the list
-      return $fltFleList;
+        // return the list
+        return $fltFleList;
     }
 
     /**
-    * Method responsible to load the data into the given table
-    **/
+     * Method responsible to load the data into the given table
+     **/
     public function load($isFrwded = False, $tblNme = "", $fltFle = "") {
-      // Check if the request is forwarded
-      if ($isFrwded) {
+        // Check if the request is forwarded
+        if ($isFrwded) {
         // Forward the file and table name
         $tblNms = Table::where('tblNme', $tblNme)->get();
         $fltFleList = array($fltFle);
-      } else {
+        } else {
         // Get all the tables
         $tblNms = Table::all();
         // Get the list of files in the directory
         $fltFleList = $this->getFiles($this->strDir);
-      }
+        }
 
-      // Compact them into one array
-      $ldData = array(
+        // Compact them into one array
+        $ldData = array(
         'tblNms' => $tblNms,
         'fltFleList' => $fltFleList
-      );
+        );
 
-      // Simple return the value
-      return view('admin.load')->with($ldData);
+        // Simple return the value
+        return view('admin.load')->with($ldData);
     }
 
     /**
-    * Store takes a requested file import and adds it to the job queue for later processing
-    **/
+     * Store takes a requested file import and adds it to the job queue for later processing
+     **/
     public function store(Request $request) {
-      // validate the file name and table name
-      // Rules for validation
-      $rules = array(
+        // validate the file name and table name
+        // Rules for validation
+        $rules = array(
         'fltFle' => 'required|string',
         'tblNme' => 'required|string'
-      );
+        );
 
-      // Validate the request before storing the job
-      $this->validate($request, $rules);
+        // Validate the request before storing the job
+        $this->validate($request, $rules);
 
-      //Queue Job for Import
-      (new TableHelper)->fileImport($request->tblNme, $this->strDir, $request->fltFle);
+        //Queue Job for Import
+        (new TableHelper)->fileImport($request->tblNme, $this->strDir, $request->fltFle);
 
-      return redirect()->route('tableIndex');
+        return redirect()->route('tableIndex');
     }
 
     /**
@@ -439,46 +439,46 @@ 
 
         // if token count doesn't match what is exptected save the tkns and last row position
         if (count($tkns) != $orgCount) {
-          // save the last row position and the Tokenized row
-          $this->lastErrRow = $prcssd;
-          $this->savedTkns = $tkns;
-          return (null);
+            // save the last row position and the Tokenized row
+            $this->lastErrRow = $prcssd;
+            $this->savedTkns = $tkns;
+            return (null);
         }
 
         return ($tkns);
     }
 
     /**
-    * Process employs following algorithm:
-    * get all the column names from table name
-    * 1. Read the file as spl object
-    * 2. For each line
-    *   1. Validate
-    *   2. Insert into database
-    **/
+     * Process employs following algorithm:
+     * get all the column names from table name
+     * 1. Read the file as spl object
+     * 2. For each line
+     *   1. Validate
+     *   2. Insert into database
+     **/
     public function process($tblNme, $fltFlePath, $fltFleNme, $ignoreFirst = true) {
-      //get table
-      $table = Table::where('tblNme', $tblNme)->first();
+        //get table
+        $table = Table::where('tblNme', $tblNme)->first();
 
-      $clmnLst = $table->getColumnList();
+        $clmnLst = $table->getColumnList();
 
-      // remove the id and time stamps
-      $clmnLst = array_splice($clmnLst, 1, count($clmnLst) - 3);
+        // remove the id and time stamps
+        $clmnLst = array_splice($clmnLst, 1, count($clmnLst) - 3);
 
-      // determine number of fields without the srchIndex
-      $orgCount = count($clmnLst) - 1;
+        // determine number of fields without the srchIndex
+        $orgCount = count($clmnLst) - 1;
 
-      // 1. Read the file as spl object
-      $fltFleAbsPth = $fltFlePath.'/'.$fltFleNme;
-      $fltFleFullPth = storage_path('app/'.$fltFleAbsPth);
+        // 1. Read the file as spl object
+        $fltFleAbsPth = $fltFlePath.'/'.$fltFleNme;
+        $fltFleFullPth = storage_path('app/'.$fltFleAbsPth);
 
-      // Create an instance for the file
-      $curFltFleObj = new \SplFileObject($fltFleFullPth);
+        // Create an instance for the file
+        $curFltFleObj = new \SplFileObject($fltFleFullPth);
 
-      $delimiter = (new CSVHelper)->detectDelimiter($fltFleFullPth);
+        $delimiter = (new CSVHelper)->detectDelimiter($fltFleFullPth);
 
-      //Check for an empty file
-      if (filesize($fltFleFullPth)>0) {
+        //Check for an empty file
+        if (filesize($fltFleFullPth)>0) {
 
         // Ignore the first line unless set to false
         if ($ignoreFirst) { $curFltFleObj->seek(1); }
@@ -488,19 +488,19 @@ 
 
         // For each line
         while ($curFltFleObj->valid()) {
-          // Get the line
-          $curLine = $curFltFleObj->current();
+            // Get the line
+            $curLine = $curFltFleObj->current();
 
-          $tkns = $this->prepareLine($curLine, $delimiter, $orgCount, $prcssd);
+            $tkns = $this->prepareLine($curLine, $delimiter, $orgCount, $prcssd);
 
-          // verify that passed $tkns match the expected field count
-          if (count($tkns) == $orgCount) {
+            // verify that passed $tkns match the expected field count
+            if (count($tkns) == $orgCount) {
             // Declae an array
             $curArry = array();
 
             // Compact them into one array with utf8 encoding
             for ($i = 0; $i<$orgCount; $i++) {
-              $curArry[ strval($clmnLst[ $i ]) ] = utf8_encode($tkns[ $i ]);
+                $curArry[ strval($clmnLst[ $i ]) ] = utf8_encode($tkns[ $i ]);
             }
 
             // add srchindex
@@ -508,27 +508,27 @@ 
 
             //insert Record into database
             $table->insertRecord($curArry);
-          }
+            }
 
-          // Update the counter
-          $prcssd += 1;
-          $curFltFleObj->next();
+            // Update the counter
+            $prcssd += 1;
+            $curFltFleObj->next();
         }
-      }
-      else {
+        }
+        else {
         throw new \Exception("Cannot Import a Empty File.");
-      }
+        }
     }
 
     /**
-    * Disable the given table
-    */
+     * Disable the given table
+     */
     public function restrict(Request $request) {
-      // Create the collection name
-      $thisTbl = Table::findOrFail($request->id);
-      $thisTbl->hasAccess = false;
-      $thisTbl->save();
-      return redirect()->route('tableIndex');
+        // Create the collection name
+        $thisTbl = Table::findOrFail($request->id);
+        $thisTbl->hasAccess = false;
+        $thisTbl->save();
+        return redirect()->route('tableIndex');
     }
 
 }

src/project-css/resources/views/admin/jobs/pending.blade.php

Spacing +3 added lines, -3 removed lines

@@ -37,9 +37,9 @@
             <th>{{$job->queue}}</th>
             <th>{{$job->attempts}}</th>
             {{-- -18000 is the offset for EST time zone --}}
-            <th><?php if ($job->reserved_at > 0) { echo gmdate("F j Y, g:i a", $job->reserved_at-18000); }?></th>
-            <th><?php if ($job->available_at > 0) { echo gmdate("F j Y, g:i a", $job->available_at-18000); }?></th>
-            <th><?php if ($job->created_at > 0) { echo gmdate("F j Y, g:i a", $job->created_at-18000); }?></th>
+            <th><?php if ($job->reserved_at>0) { echo gmdate("F j Y, g:i a", $job->reserved_at - 18000); }?></th>
+            <th><?php if ($job->available_at>0) { echo gmdate("F j Y, g:i a", $job->available_at - 18000); }?></th>
+            <th><?php if ($job->created_at>0) { echo gmdate("F j Y, g:i a", $job->created_at - 18000); }?></th>
           </tr>
         @endforeach
         </table>

src/project-css/resources/views/admin/jobs/failed.blade.php

Spacing +1 added lines, -1 removed lines

@@ -38,7 +38,7 @@
           <th>{{$job->connection}}</th>
           <th>{{$job->queue}}</th>
           <th>{{ str_limit($job->exception, $limit = 100, $end = '...') }}</th>
-          <th><?php if ($job->failed_at > 0) { echo gmdate("F j Y, g:i a", (strtotime($job->failed_at)-18000)); }?></th>
+          <th><?php if ($job->failed_at>0) { echo gmdate("F j Y, g:i a", (strtotime($job->failed_at) - 18000)); }?></th>
           <th><a href="{{ url('admin/jobs/retry', [$job->id]) }}" class="btn btn-primary">Retry Job</a></th>
           <th><a href="{{ url('admin/jobs/forget', [$job->id]) }}" class="btn btn-primary">Delete Job</a></th>
         </tr>

src/project-css/app/Exceptions/Handler.php

Indentation +7 added lines, -7 removed lines

@@ -46,14 +46,14 @@
             return redirect('/login')->withErrors('Your session has expired. Please try again.');
         }
         if ($this->isHttpException($exception)){
-          // to get status code ie 404, 503, 500
-           $status = $exception->getStatusCode();
+            // to get status code ie 404, 503, 500
+            $status = $exception->getStatusCode();
 
-           if (view()->exists("errors.{$status}")) {
-               return response()->view("errors.{$status}", ['exception' => $exception], $status, $exception->getHeaders());
-           } else {
-               return $this->convertExceptionToResponse($exception);
-           }
+            if (view()->exists("errors.{$status}")) {
+                return response()->view("errors.{$status}", ['exception' => $exception], $status, $exception->getHeaders());
+            } else {
+                return $this->convertExceptionToResponse($exception);
+            }
         }
         return parent::render($request, $exception);
     }

Spacing +2 added lines, -2 removed lines

@@ -45,12 +45,12 @@
         if ($exception instanceof TokenMismatchException) {
             return redirect('/login')->withErrors('Your session has expired. Please try again.');
         }
-        if ($this->isHttpException($exception)){
+        if ($this->isHttpException($exception)) {
           // to get status code ie 404, 503, 500
            $status = $exception->getStatusCode();
 
            if (view()->exists("errors.{$status}")) {
-               return response()->view("errors.{$status}", ['exception' => $exception], $status, $exception->getHeaders());
+               return response()->view("errors.{$status}", [ 'exception' => $exception ], $status, $exception->getHeaders());
            } else {
                return $this->convertExceptionToResponse($exception);
            }

src/project-css/app/Http/Middleware/CheckTableId.php

Indentation +16 added lines, -16 removed lines

@@ -14,34 +14,34 @@
      * @return mixed
      */
     public function handle($request, Closure $next){
-      if ($this->isValidTable($request->curTable) && $this->hasAccess($request->curTable)) {
+        if ($this->isValidTable($request->curTable) && $this->hasAccess($request->curTable)) {
         return $next($request);
-      }
-      $message = !($this->isValidTable($request->curTable)) ? 'Table id is invalid' : 'Table is disabled';
-      return redirect()->route('home')->withErrors([ $message ]);
+        }
+        $message = !($this->isValidTable($request->curTable)) ? 'Table id is invalid' : 'Table is disabled';
+        return redirect()->route('home')->withErrors([ $message ]);
     }
 
     /**
-    * The function will check if the passed id is valid using:
-    * 1. Check for the null values
-    * 2. Check for the non numeric values
-    * 3. Check for the table id
-    **/
+     * The function will check if the passed id is valid using:
+     * 1. Check for the null values
+     * 2. Check for the non numeric values
+     * 3. Check for the table id
+     **/
     public function isValidTable($curTable) {
-      if (!is_null($curTable) && is_numeric($curTable)) {
+        if (!is_null($curTable) && is_numeric($curTable)) {
         return Table::find($curTable) == null ? false : true;
-      }
-      return false;
+        }
+        return false;
     }
 
     public function hasAccess($curTable) {
-      if ($this->isValidTable($curTable)) {
+        if ($this->isValidTable($curTable)) {
         // Get the table entry in meta table "tables"
         $curTable = Table::find($curTable);
         if ($curTable->hasAccess == 1) {
-          return true;
+            return true;
+        }
         }
-      }
-      return false;
+        return false;
     }
 }

Spacing +1 added lines, -1 removed lines

@@ -13,7 +13,7 @@
      * @param  \Closure  $next
      * @return mixed
      */
-    public function handle($request, Closure $next){
+    public function handle($request, Closure $next) {
       if ($this->isValidTable($request->curTable) && $this->hasAccess($request->curTable)) {
         return $next($request);
       }

src/project-css/app/Http/Controllers/UploadController.php

Indentation +13 added lines, -13 removed lines

@@ -25,7 +25,7 @@ 
 
         // return the index page
         return view('admin/upload')->with('tblNme', $curTable->tblNme)
-                                   ->with('tblId', $curTable);
+                                    ->with('tblId', $curTable);
     }
 
     /**
@@ -46,7 +46,7 @@ 
 
         //If the array is not empty
         if ($files[ 0 ] != '') {
-          foreach ($files as $file) {
+            foreach ($files as $file) {
             // Set the destination path
             $destinationPath = $curTable->tblNme.'/'.$upFldNme;
             Storage::makeDirectory($destinationPath);
@@ -54,22 +54,22 @@ 
             $filename = $file->getClientOriginalName();
 
             if (Storage::exists($destinationPath.'/'.$filename)) {
-              $message = [ 'content' =>  $filename.' Already Exists', 'level' =>  'info' ];
+                $message = [ 'content' =>  $filename.' Already Exists', 'level' =>  'info' ];
             } else {
-               // Copy the file in our upload folder
-               $file->storeAs($destinationPath, $filename);
+                // Copy the file in our upload folder
+                $file->storeAs($destinationPath, $filename);
 
-               $message = [
-                  'content'  =>  $filename.' Upload successful',
-                  'level'    =>  'success',
-               ];
+                $message = [
+                    'content'  =>  $filename.' Upload successful',
+                    'level'    =>  'success',
+                ];
             }
             array_push($messages, $message);
-          }
+            }
 
-          session()->flash('messages', $messages);
-          return view('admin/upload')->with('tblNme', $curTable->tblNme)
-                                     ->with('tblId', $curTable);
+            session()->flash('messages', $messages);
+            return view('admin/upload')->with('tblNme', $curTable->tblNme)
+                                        ->with('tblId', $curTable);
         }
         return(false);
     }