TechWilk / rota

public/api/v1/index.php

Spacing +31 added lines, -31 removed lines

@@ -23,15 +23,15 @@ 
 // Start of API
 // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
-require_once dirname(__FILE__).'/../../../vendor/autoload.php';
+require_once dirname(__FILE__) . '/../../../vendor/autoload.php';
 
-include_once dirname(__FILE__).'/../../../config/database.php';
+include_once dirname(__FILE__) . '/../../../config/database.php';
 
 // Create and configure Slim app
 $app = new \Slim\App(['settings' => $config]);
 
-spl_autoload_register(function ($classname) {
-    require dirname(__FILE__).'/../../../api-classes/'.$classname.'.php';
+spl_autoload_register(function($classname) {
+    require dirname(__FILE__) . '/../../../api-classes/' . $classname . '.php';
 });
 
 // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@@ -40,7 +40,7 @@ 
 
 $container = $app->getContainer();
 
-$container['db'] = function ($c) {
+$container['db'] = function($c) {
     $db_config = $c['settings']['db'];
     $db = new Database($db_config);
 
@@ -53,7 +53,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Event ~~~~~~~~~~~~~~~
 
-$app->post('/events', function ($request, $response, $args) {
+$app->post('/events', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -65,7 +65,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/events/{id}', function ($request, $response, $args) {
+$app->get('/events/{id}', function($request, $response, $args) {
     $id = filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $event = new Event();
@@ -91,8 +91,8 @@ 
                     'relationships' => [
                                         'series' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/series',
-                                                                'related' => '/events/'.$event->getId().'/series/'.$series->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/series',
+                                                                'related' => '/events/' . $event->getId() . '/series/' . $series->getId(),
                                                     ],
                                                     'data' => [
                                                       'type' => 'series',
@@ -101,8 +101,8 @@ 
                                         ],
                                         'types' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/types',
-                                                                'related' => '/events/'.$event->getId().'/types/'.$type->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/types',
+                                                                'related' => '/events/' . $event->getId() . '/types/' . $type->getId(),
                                                     ],
                                                     'data' => [
                                                       'type' => 'types',
@@ -111,8 +111,8 @@ 
                                         ],
                                         'sub-types' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/sub-types',
-                                                                'related' => '/events/'.$event->getId().'/sub-types/'.$sub_type->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/sub-types',
+                                                                'related' => '/events/' . $event->getId() . '/sub-types/' . $sub_type->getId(),
                                                     ],
                                                     'data' => [
                                                                 'type' => 'sub-types',
@@ -121,8 +121,8 @@ 
                                         ],
                                         'location' => [
                                                     'links' => [
-                                                                'self'    => '/events/'.$event->getId().'/relationships/locations',
-                                                                'related' => '/events/'.$event->getId().'/locations/'.$location->getId(),
+                                                                'self'    => '/events/' . $event->getId() . '/relationships/locations',
+                                                                'related' => '/events/' . $event->getId() . '/locations/' . $location->getId(),
                                                     ],
                                                     'data' => [
                                                                 'type' => 'locations',
@@ -140,7 +140,7 @@ 
                                           'description' => $series->description,
                             ],
                             'links' => [
-                                        'self' => '/series/'.$series->getId(),
+                                        'self' => '/series/' . $series->getId(),
                             ],
                           ],
                           [
@@ -151,7 +151,7 @@ 
                                       'description' => $type->description,
                             ],
                             'links' => [
-                                        'self' => '/types/'.$type->getId(),
+                                        'self' => '/types/' . $type->getId(),
                             ],
                           ],
                           [
@@ -162,7 +162,7 @@ 
                                       'description' => $sub_type->description,
                             ],
                             'links' => [
-                                        'self' => '/sub-types/'.$sub_type->getId(),
+                                        'self' => '/sub-types/' . $sub_type->getId(),
                             ],
                           ],
                           [
@@ -172,7 +172,7 @@ 
                                       'name' => $location->name,
                             ],
                             'links' => [
-                                        'self' => '/locations/'.$location->getId(),
+                                        'self' => '/locations/' . $location->getId(),
                             ],
                           ],
           ],
@@ -186,7 +186,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Series ~~~~~~~~~~~~~~~
 
-$app->post('/series', function ($request, $response, $args) {
+$app->post('/series', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -209,7 +209,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/series/{id}', function ($request, $response, $args) {
+$app->get('/series/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $series = new Series();
@@ -226,7 +226,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/series/{id}', function ($request, $response, $args) {
+$app->delete('/series/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $series = new Series();
@@ -244,7 +244,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Type ~~~~~~~~~~~~~~~
 
-$app->post('/types', function ($request, $response, $args) {
+$app->post('/types', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -267,7 +267,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/types/{id}', function ($request, $response, $args) {
+$app->get('/types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new Type();
@@ -284,7 +284,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/types/{id}', function ($request, $response, $args) {
+$app->delete('/types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new Type();
@@ -302,7 +302,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Sub Type ~~~~~~~~~~~~~~~
 
-$app->post('/sub-types', function ($request, $response, $args) {
+$app->post('/sub-types', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -325,7 +325,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/sub-types/{id}', function ($request, $response, $args) {
+$app->get('/sub-types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new SubType();
@@ -342,7 +342,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/sub-types/{id}', function ($request, $response, $args) {
+$app->delete('/sub-types/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $type = new SubType();
@@ -360,7 +360,7 @@ 
 
 // ~~~~~~~~~~~~~~~ Location ~~~~~~~~~~~~~~~
 
-$app->post('/locations', function ($request, $response, $args) {
+$app->post('/locations', function($request, $response, $args) {
     $postData = $request->getParsedBody();
 
     $name = filter_var($postData['name'], FILTER_SANITIZE_STRING);
@@ -380,7 +380,7 @@ 
     return $response->withJson($data);
 });
 
-$app->get('/locations/{id}', function ($request, $response, $args) {
+$app->get('/locations/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $location = new Location();
@@ -396,7 +396,7 @@ 
     return $response->withJson($data);
 });
 
-$app->delete('/locations/{id}', function ($request, $response, $args) {
+$app->delete('/locations/{id}', function($request, $response, $args) {
     $id = (int) filter_var($args['id'], FILTER_SANITIZE_NUMBER_INT);
 
     $location = new Location();

public/plugins/datatables/extensions/Scroller/examples/data/ssp.php

Spacing +5 added lines, -5 removed lines

@@ -29,11 +29,11 @@
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = [
-    ['db' => 'id',         'dt' => 0],
-    ['db' => 'firstname',  'dt' => 1],
-    ['db' => 'surname',    'dt' => 2],
-    ['db' => 'zip',        'dt' => 3],
-    ['db' => 'country',    'dt' => 4],
+    ['db' => 'id', 'dt' => 0],
+    ['db' => 'firstname', 'dt' => 1],
+    ['db' => 'surname', 'dt' => 2],
+    ['db' => 'zip', 'dt' => 3],
+    ['db' => 'country', 'dt' => 4],
 ];
 
 // SQL server connection information

public/old/swaps.php

Spacing +3 added lines, -3 removed lines

@@ -39,7 +39,7 @@ 
 // ensure user is allowed to see page
 
 if (!isAdmin() && $queryStringUser != $sessionUserId) {
-    header('Location: swaps.php?user='.$sessionUserId);
+    header('Location: swaps.php?user=' . $sessionUserId);
 }
 
 // fetch swaps
@@ -90,11 +90,11 @@ 
               <p>
                 <strong>
                   <s class="text-red">
-                    <?php echo $swap->getOldUserRole()->getUser()->getFirstName().' '.$swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
+                    <?php echo $swap->getOldUserRole()->getUser()->getFirstName() . ' ' . $swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
                   </s>
                   &#8594;
                   <span class="text-green">
-                    <?php echo $swap->getNewUserRole()->getUser()->getFirstName().' '.$swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
+                    <?php echo $swap->getNewUserRole()->getUser()->getFirstName() . ' ' . $swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
                   </span>
                 </strong>
               </p>

public/old/overview.php

Spacing +2 added lines, -2 removed lines

@@ -33,7 +33,7 @@ 
     exit;
 }
 if (!isAdmin()) {
-    header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME']));
+    header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME']));
     exit;
 }
 
@@ -115,7 +115,7 @@ 
 
 		  <?php
             else:
-                echo '<div class="box-body">'.$sentSuccess.'</div>';
+                echo '<div class="box-body">' . $sentSuccess . '</div>';
             endif;
             ?>
 				</div>

public/old/editBand.php

Spacing +11 added lines, -11 removed lines

@@ -33,7 +33,7 @@ 
     exit;
 }
 if (!isAdmin()) {
-    header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME']));
+    header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME']));
     exit;
 }
 
@@ -119,15 +119,15 @@ 
                 }
 
                 if ($viewPeople['skill'] != '') {
-                    $skill = ' - <em>'.$viewPeople['skill'].'</em>';
+                    $skill = ' - <em>' . $viewPeople['skill'] . '</em>';
                 } else {
                     $skill = '';
                 }
                 if ($position == 2) {
-                    echo "<div class='checkboxitem right'><label class='styled' for='rehearsaldate[".$viewPeople['skillID']."]'>".
-                        $viewPeople['name'].$skill."</em></label><input class='styled' ".$checked."type='checkbox' id='rehearsaldate[".
-                        $viewPeople['skillID']."]'	name='rehearsaldate[]' value='".
-                        $viewPeople['skillID']."' /></div></div>";
+                    echo "<div class='checkboxitem right'><label class='styled' for='rehearsaldate[" . $viewPeople['skillID'] . "]'>" .
+                        $viewPeople['name'] . $skill . "</em></label><input class='styled' " . $checked . "type='checkbox' id='rehearsaldate[" .
+                        $viewPeople['skillID'] . "]'	name='rehearsaldate[]' value='" .
+                        $viewPeople['skillID'] . "' /></div></div>";
 
                     $position = 1;
                 } else {
@@ -139,11 +139,11 @@ 
                         $i = '1';
                     }
 
-                    echo "<div class='row".$class."'>
-						<div class='checkboxitem'><label class='styled' for='rehearsaldate[".$viewPeople['skillID']."]'>".
-                        $viewPeople['name'].$skill."</em></label><input class='styled' ".$checked."type='checkbox' id='rehearsaldate[".
-                        $viewPeople['skillID']."]'	name='rehearsaldate[]' value='".
-                        $viewPeople['skillID']."' /></div>";
+                    echo "<div class='row" . $class . "'>
+						<div class='checkboxitem'><label class='styled' for='rehearsaldate[".$viewPeople['skillID'] . "]'>" .
+                        $viewPeople['name'] . $skill . "</em></label><input class='styled' " . $checked . "type='checkbox' id='rehearsaldate[" .
+                        $viewPeople['skillID'] . "]'	name='rehearsaldate[]' value='" .
+                        $viewPeople['skillID'] . "' /></div>";
 
                     $position = 2;
                 }

public/old/plugins/datatables/extensions/Scroller/examples/data/ssp.php

Spacing +5 added lines, -5 removed lines

@@ -29,11 +29,11 @@
 // parameter represents the DataTables column identifier. In this case simple
 // indexes
 $columns = [
-    ['db' => 'id',         'dt' => 0],
-    ['db' => 'firstname',  'dt' => 1],
-    ['db' => 'surname',    'dt' => 2],
-    ['db' => 'zip',        'dt' => 3],
-    ['db' => 'country',    'dt' => 4],
+    ['db' => 'id', 'dt' => 0],
+    ['db' => 'firstname', 'dt' => 1],
+    ['db' => 'surname', 'dt' => 2],
+    ['db' => 'zip', 'dt' => 3],
+    ['db' => 'country', 'dt' => 4],
 ];
 
 // SQL server connection information

public/old/swap.php

Spacing +7 added lines, -7 removed lines

@@ -110,7 +110,7 @@ 
 if (!empty($eventId)) {
     // ensure user is logged in before allowing creation of swap
   if (!(isset($_SESSION['is_logged_in']) || $_SESSION['db_is_logged_in'] == true)) {
-      $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl().'/swap.php?event='.$eventId;
+      $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl() . '/swap.php?event=' . $eventId;
       header('Location: login.php');
   }
     $createSwap = true;
@@ -186,11 +186,11 @@ 
             <p>
               <strong>
                 <s class="text-red">
-                  <?php echo $swap->getOldUserRole()->getUser()->getFirstName().' '.$swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
+                  <?php echo $swap->getOldUserRole()->getUser()->getFirstName() . ' ' . $swap->getOldUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getOldUserRole()->getRole()->getName() ?>)
                 </s>
                 &#8594;
                 <span class="text-green">
-                  <?php echo $swap->getNewUserRole()->getUser()->getFirstName().' '.$swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
+                  <?php echo $swap->getNewUserRole()->getUser()->getFirstName() . ' ' . $swap->getNewUserRole()->getUser()->getLastName() ?> (<?php echo $swap->getNewUserRole()->getRole()->getName() ?>)
                 </span>
               </strong>
             </p>
@@ -225,16 +225,16 @@ 
                 <select name="newUserRole" class="form-control">
                   <?php
                   if (roleCanSwapToOtherRoleInGroup($role->roleId)) {
-                      $whereAnd = 'r.groupId = '.groupIdWithRole($role->roleId).' AND r.allowRoleSwaps IS NOT FALSE';
+                      $whereAnd = 'r.groupId = ' . groupIdWithRole($role->roleId) . ' AND r.allowRoleSwaps IS NOT FALSE';
                   } else {
-                      $whereAnd = 'r.id = '.$role->roleId;
+                      $whereAnd = 'r.id = ' . $role->roleId;
                   }
-                  $sql = 'SELECT ur.id, u.firstName, u.lastName, r.name FROM cr_users u INNER JOIN cr_userRoles ur ON ur.userId = u.id INNER JOIN cr_roles r ON r.id = ur.roleId WHERE u.id <> '.$role->userId.' AND '.$whereAnd.' ORDER BY lastName, firstName, r.name';
+                  $sql = 'SELECT ur.id, u.firstName, u.lastName, r.name FROM cr_users u INNER JOIN cr_userRoles ur ON ur.userId = u.id INNER JOIN cr_roles r ON r.id = ur.roleId WHERE u.id <> ' . $role->userId . ' AND ' . $whereAnd . ' ORDER BY lastName, firstName, r.name';
                   $result = mysqli_query(db(), $sql) or die(mysqli_error(db()));
 
                   while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                       ?>
-                    <option value='<?php echo $row['id']; ?>'><?php echo $row['firstName'].' '.$row['lastName'].' ('.$row['name'].')'; ?></option>
+                    <option value='<?php echo $row['id']; ?>'><?php echo $row['firstName'] . ' ' . $row['lastName'] . ' (' . $row['name'] . ')'; ?></option>
                   <?php
                   } ?>
                 </select>

public/old/createEvents.php

Spacing +4 added lines, -4 removed lines

@@ -88,7 +88,7 @@ 
                                         while ($ob = mysqli_fetch_object($result)) {
                                             if (!(isset($type) && $ob->id == $type)) {
                                                 $defaultTime = strftime('%H:%M', strtotime($ob->defaultTime));
-                                                echo "<option value='".$ob->id."' title='".$ob->description."' data-time='".($defaultTime == '00:00' ? '' : $defaultTime)."' data-location='".(is_null($ob->defaultLocationId) ? '' : $ob->defaultLocationId)."'>".$ob->name.'</option>';
+                                                echo "<option value='" . $ob->id . "' title='" . $ob->description . "' data-time='" . ($defaultTime == '00:00' ? '' : $defaultTime) . "' data-location='" . (is_null($ob->defaultLocationId) ? '' : $ob->defaultLocationId) . "'>" . $ob->name . '</option>';
                                             }
                                         } ?>

 									</select>

@@ -114,7 +114,7 @@ 
                                         while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                                             if (isset($subtype) && $row['id'] == $subtype) {
                                             } else {
-                                                echo "<option value='".$row['id']."' title='".$row['description']."'>".$row['name'].'</option>';
+                                                echo "<option value='" . $row['id'] . "' title='" . $row['description'] . "'>" . $row['name'] . '</option>';
                                             }
                                         } ?>

 									</select>

@@ -142,7 +142,7 @@ 
                                         while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                                             if (isset($location) && $row['id'] == $location) {
                                             } else {
-                                                echo "<option value='".$row['id']."'>".$row['name'].'</option>';
+                                                echo "<option value='" . $row['id'] . "'>" . $row['name'] . '</option>';
                                             }
                                         } ?>

 									</select>

@@ -285,7 +285,7 @@ 
                                     while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                                         if (isset($type) && $row['id'] == $type) {
                                         } else {
-                                            echo "<option value='".$row['id']."' title='".$row['description']."'>".$row['name'].'</option>';
+                                            echo "<option value='" . $row['id'] . "' title='" . $row['description'] . "'>" . $row['name'] . '</option>';
                                         }
                                     } ?>

 								</select>

public/old/subTypes.php

Spacing +5 added lines, -5 removed lines

@@ -14,7 +14,7 @@ 
     exit;
 }
 if (!isAdmin()) {
-    header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME']));
+    header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME']));
     exit;
 }
 
@@ -37,7 +37,7 @@ 
 
         $sql = ("INSERT INTO cr_eventSubTypes (name, description) VALUES ('$name', '$description')");
         if (!mysqli_query(db(), $sql)) {
-            die('Error: '.mysqli_error(db()));
+            die('Error: ' . mysqli_error(db()));
         }
     } else {
         // Otherwise we are dealing with edits, not new stuff
@@ -88,10 +88,10 @@ 
     $result = mysqli_query(db(), $sql) or die(mysqli_error(db()));
 
     while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
-        echo '<input type="hidden" name="formindex[]" value="'.$row['id'].'" />';
-        echo "<input name='name[]' value='".$row['name']."' />";
+        echo '<input type="hidden" name="formindex[]" value="' . $row['id'] . '" />';
+        echo "<input name='name[]' value='" . $row['name'] . "' />";
 
-        echo " <a href='subTypes.php?method=remove&subType=".$row['id']."'><i class='fa fa-times'></i></a><br />";
+        echo " <a href='subTypes.php?method=remove&subType=" . $row['id'] . "'><i class='fa fa-times'></i></a><br />";
     } ?>
    </div><!-- /.box-body -->
    <div class="box-footer">