Web Development

$("#jqGrid").jqGrid({
       url: "/Folder/ShowProductsDetails",
       editurl: '/Folder/EditProductDetails',
       datatype: 'json',
       mtype: 'Get',
       ajaxSelectOptions: { type: 'POST' },

       viewrecords: true,
       prmNames: { id: "ProductsLineId" },
       sortname: "Purchase_Date",
       sortorder: "DESC",
       hoverrows: true
       },
       colNames: ['ProductsLineId', 'Purchase Date', 'Company'],
       colModel: [
           { key: true, hidden: true, name: 'ProductsLineId', index: 'ProductsLineId'},
           { name: 'Purchase_Date', title: false, stype: 'text', index: 'Purchase_Date', formatter: 'date',
             formatoptions: { newformat: 'm/d/Y' }, editable: true, formoptions: { rowpos: 1, colpos: 2,
             label: 'Purchase Date *' }, editrules: { required: true },
           },
           { name: 'Company', title: false, stype: 'text', index: 'Company', formatter: 'date',
             formatoptions: { newformat: 'm/d/Y' }, editable: true, formoptions: { rowpos: 1, colpos: 2,
             label: 'Purchase Date *' }, editrules: { required: true },
           }
           ],
           shrinkToFit: false,
           pager: jQuery('#jqControls'),
           rowNum: 50,
           rowList: [50, 100, 150, 200],
       scrollerbar: true,
       height: 'auto',
       autoheight: true,
       autowidth: true,
       viewrecords: true,
       caption: 'Uploaded Product Details',
       emptyrecords: 'No Records are Available to Display',
       jsonReader: {
           root: "rows",
           page: "page",
           total: "total",
           records: "records",
           repeatitems: false,
           id: 'ClaimsLineId'
       },
       multiselect: true
   }).navGrid('#jqControls', { add: false, edit: true, del: true, search: true, refresh: true},

   {//Code for Add},{//Code for Edit},{//Code for Delete}

public ActionResult ShowProductsDetails(string operation Product prod, string extraData)

<pre><?php require_once('Connections/eam.php'); ?>
<?php 
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_rsMaintenanceAsset = "-1";

if (isset($_GET['recordID'])) {
  $colname_rsMaintenanceAsset = $_GET['recordID'];
}
mysql_select_db($database_eam, $eam);
$query_rsMaintenanceAsset = sprintf("SELECT * FROM maintenance_history WHERE maint_id = %s", GetSQLValueString($colname_rsMaintenanceAsset, "int"));
$rsMaintenanceAsset = mysql_query($query_rsMaintenanceAsset, $eam) or die(mysql_error());
$row_rsMaintenanceAsset = mysql_fetch_assoc($rsMaintenanceAsset);
$totalRows_rsMaintenanceAsset = mysql_num_rows($rsMaintenanceAsset);
}

 
$pageTitle="Maintenance History"; ?>



<?php include('includes/header.php'); ?>
    <h3>Maintenance history for  Asset ID: <?php echo $colname_rsMaintenanceAsset; ?></h3>
    <table class="table1">
      <tr>
        <th>Maintenance ID</th>
        <th>Date Completed</th>
        <th>By</th>
        <th>Checklist</th>
        <th>Comments</th>
        <th>SPARE</th>
        <th>View   </th>
      </tr>
      <?php do { ?>
        <tr onmouseover="this.bgColor='#F2F7FF'" onmouseout="this.bgColor='#FFFFFF'";>
          <td> <?php echo $row_rsMaintenanceAsset['id']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['date_completed']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['by_staff']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['maint_checklist']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['maint_comm']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['status']; ?>  </td>


          <td> <a href="HardwareDetail.php?recordID=<?php echo $row_rsMaintenanceAssets['maint_id']; ?>">View</a></td>
 
        </tr>
      <?php } while ($row_rsMaintenanceAssets = mysql_fetch_assoc($rsMaintenanceAssets)); ?>
    </table>

'use strict';
app.factory('authInterceptorService', ['$injector', '$q', '$location', 'localStorageService', function ($injector, $q, $location, localStorageService)
{

    var authInterceptorServiceFactory = {};

    function RequiresRefresh(responseURL)
    {
        if (responseURL.indexOf('getcutofftime') > -1)
            return false;
        if (responseURL.indexOf('resources') !== -1)
            return true;
        return false;
    }

    var _request = function (config)
    {
        config.headers = config.headers || {};

        var authData = localStorageService.get('authorizationData');
        if (authData)
        {
            config.headers.Authorization = 'Bearer ' + authData.token;
        }

        return config || q$.when(config);
    };

    //should handle all error responses in here.
    //var _responseError = function (rejection)
    //{
    //    console.log("Intercepted Rejection: " + rejection);

    //    return $q.reject(rejection);
        
    //};

    var _responseSuccess = function (response)
    {
        var responseURL = response.config.url;
        if (responseURL !== null && typeof responseURL !== 'undefined')
        {
            //check to make sure it's actually an interaction with the resourcesAPI - these are the only times it should refresh the token.
            if (RequiresRefresh(responseURL))
            {
                //get a new token!
                var authData = localStorageService.get('authorizationData');

                var JSONdata = {
                    windowsFullName: authData.windowsFullName
                    , windowsUserName: authData.windowsUserName
                    , summitUserName: authData.summitUserName
                    , summitFullName: authData.summitFullName
                    , clientID: 'MatterhornAuthApp'
                };

                $injector.get("$http")
                    .post(serviceBase + 'usermanagement/account/ReissueToken', JSONdata, { headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer ' + authData.token } })
                    .then(function (response)
                    {
                        response = response.data;
                        localStorageService.set('authorizationData', {
                            token: response.protectedTicket
                            , summitUserName: response.summitUserName
                            , windowsFullName: response.windowsFullName
                            , windowsUserName: response.windowsUserName
                            , summitFullName: response.summitFullName
                            , refreshToken: ""
                            , useRefreshTokens: false
                            , isSummitAuth: authData.isSummitAuth
                            , isWindowsAuth: authData.isWindowsAuth
                            , roles: response.roles
                        });
                    }, function (err)
                    {
                        return $q.reject(err);
                    });
            }
        }

        //request a new token
        var status = response.status;
        return response || $q.when(response);
    };

    authInterceptorServiceFactory.request = _request;
    ////authInterceptorServiceFactory.responseError = _responseError;
    //authInterceptorServiceFactory.response = _responseSuccess;

    return authInterceptorServiceFactory;
}]);

How to use a php $_SERVER['PHP_SELF'] to insert form data into Mysql database and print 
same form data automatically

// check which button was clicked
// perform calculation
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO reservation (`Class of Room`, `Room Number`, `Customer Name`, `Customer Address`, `Phone number`, Occupation, Amount, `Check in Time`, `Date`, Duration, `Name of Receptionist`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['Class_of_Room'], "text"),
                       GetSQLValueString($_POST['Room_Number'], "text"),
                       GetSQLValueString($_POST['Customer_Name'], "text"),
                       GetSQLValueString($_POST['Customer_Address'], "text"),
                       GetSQLValueString($_POST['Phone_number'], "text"),
                       GetSQLValueString($_POST['Occupation'], "text"),
                       GetSQLValueString($_POST['Amount'], "text"),
                       GetSQLValueString($_POST['Check_in_Time'], "text"),
                       GetSQLValueString($_POST['Date'], "date"),
                       GetSQLValueString($_POST['Duration'], "text"),
                       GetSQLValueString($_POST['Name_of_Receptionist'], "text"));

  mysql_select_db($database_Morrendb, $Morrendb);
  $Result1 = mysql_query($insertSQL, $Morrendb) or die(mysql_error());

  $insertGoTo = "reservation.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>