hcuHistory.data

<?php
/*
 * File: history.data
 * Purpose: To return the requested data in a JSON format, for the client to display
 *            accordingly
 *          This is script is limited to what can be sorted/returned
 *
 *          My goal is to return 7 days at a time for any specific account
 *
 *
 *  Call this script with the following parameters
 *  a - This is the value of the Account Key {Acctnbr|AcctType|Sfx|CertNo}
 *  r1  - This is the starting date - IF empty, I will prime it with Todays date - 30
 *  r2  - This is the ending date - If empty, I will prime with today
 *  r3  - When dates are being specified, this will be used to calculate the next
 *          segment of data that will be retrieved.  It can be blank when priming data.
 *
 *  TO PRIME THE HISTORY DATA --
 *    pass in an empty r1 and r2 --
 *    the Get_History function will determine the correct default days starting
 *    backwards from today.
 *    At this point the Get_History function will also return the default days
 *    to use in future queries
 *
 *  OTHERWISE
 *    pass in r1 (Starting Date) and r2 (Ending Date) in the format
 *    of MM/DD/YYYY
 *    The Get_History function will then return the rows that match that range
 *
 *
 *
 * Returned JSON OBJECT
 * Here are the pieces in the JSON object that are returned
 * 'title' => Simple title for the data --
 * 'status' => Success status of the query results can be:
 *                000 -- SUCCESS
 * 'datastartdate' => This is returned by Get_History and is the official start
 *                    date that was used in the query
 * 'dataenddate' => This is returned by Get_History and is the official END
 *                    date that was used in the query
 * 'nextstartdate' => This script will use the default days which is supplied either
 *                      by r3 or the Get_History function.  This will calculate the
 *                      next segment history START date to use
 * 'nextenddate' => This script will use the default days which is supplied either
 *                      by r3 or the Get_History function.  This will calculate the
 *                      next segment history END date to use
 * 'defaultdays' => This is the days of history that are retrieved at a time. It
 *                    is set when the data is primed, but can be overridden with the
 *                    r3 parameter.
 * 'items' => $Get_History_ary[$history_param]
 */

  $serviceViewFromCUAdmin = (isset($serviceViewFromCUAdmin) ? $serviceViewFromCUAdmin : false);

  if (!$serviceViewFromCUAdmin) {

    // ** SET HOMECU FLAGS
    $serviceShowInfo = true;
    $serviceLoadMenu = true;
    $serviceShowMenu = true;
    $serviceAllowReadonly = true;
    $serviceLiveCheck = true;


    // ** INCLUDE MAIN GLOBAL SCRIPT -- Handles security / global variable values
    require_once(dirname(__FILE__) . '/../library/hcuService.i');
  }

  // ** IMPORT FORM VALUES
  $string= array("filter" => FILTER_SANITIZE_STRING);
  $digits= array("filter" => FILTER_SANITIZE_NUMBER_INT);
  $dms_ok = array('cu'=>$string, 'a'=>$string, 'r1'=>$string, 'r2'=>$string, 'r3'=>$digits,"action"=>$string);
  HCU_ImportVars($HB_ENV, 'HCUPOST', $dms_ok);

try {
  // ** First check the refer script -- This will be used to ensure proper usage later
    // * as errors may be returned differently

  $parseRefer = parse_url($_SERVER['HTTP_REFERER']);
  $referScript = basename($parseRefer['path']);

  if (!in_array($referScript, array('hcuHistory.prg', 'main'))) {
    // ** Wrong script calling this data routine
    throw new Exception ($MC->msg('Feature Not Set', HCU_DISPLAY_AS_HTML));
  }

  /*
   * ** CHECK USER FEATURE PERMISSIONS **
   * NOTE: DO NOT AUTO-REDIR.  Handle perm error here
   */
  if (!PermCheckFeatureScreen($dbh, $HB_ENV, $MC, FEATURE_BASIC, '', false)) {
        throw new Exception (HCU_JsonEncode(Array($MC->msg('Rights not set', HCU_DISPLAY_AS_HTML))));
    }


  // print_r($HB_ENV);
  // ** We have the values
  $Get_History_ary = Array();
  $retJson_ary = Array();
  if (!is_null($HB_ENV['HCUPOST']['a'])) {
    // * Have a row value
    // ** Set the value
    $history_param = hcu_decrypturl($HB_ENV['HCUPOST']['a'], $HB_ENV['historyHash']);
    // * Now break apart on the | symbols that should be there

    $history_acct = explode('|', $history_param);
    // * we should have 4 pieces

      // ** Set the r1 & r2
    if ($HB_ENV['HCUPOST']['r1'] == '' || $HB_ENV['HCUPOST']['r2'] == '') {
      // ** Always look for 3 days in advance when we prime
      $HB_ENV['HCUPOST']['r2'] = date('m/d/Y', strtotime('+3 days'));
      $HB_ENV['HCUPOST']['r1'] = date('m/d/Y', strtotime('-5 days'));
    }

    $advSearch = array();
    // ** import the values for the advanced search
    $dms_ok = array('searchAmt'=>$string, 'searchDesc'=>$string, 'searchCheckNum'=>$string);
    HCU_ImportVars($HB_ENV, 'HCUPOST', $dms_ok);

    if (HCU_array_key_exists('searchAmt', $HB_ENV["HCUPOST"]) &&  strlen($HB_ENV["HCUPOST"]["searchAmt"]) > 0 ) {
      $findamt = preg_replace("/[^0-9.]/","",$HB_ENV["HCUPOST"]["searchAmt"]);
      $advSearch["findamt"] = $findamt;
    }
    if (HCU_array_key_exists('searchDesc', $HB_ENV["HCUPOST"]) &&  strlen($HB_ENV["HCUPOST"]["searchDesc"]) > 0 ) {
      $fdesc = preg_replace("/[^a-zA-Z0-9 ]/","",$HB_ENV["HCUPOST"]["searchDesc"]);
      $advSearch["fdesc"] = $fdesc;
    }
    if (HCU_array_key_exists('searchCheckNum', $HB_ENV['HCUPOST'])) {
      if ( strlen($HB_ENV["HCUPOST"]["searchCheckNum"]) > 0 ) {
        $check = (preg_replace("/[^0-9.]/","",$HB_ENV["HCUPOST"]["searchCheckNum"]));
        $advSearch["check"] = $check;
      }
    }
    // * okay -- try passing the account to the Get_History and get the results

      $Get_History_ary = Get_History($dbh, $HB_ENV, $history_param, $HB_ENV['HCUPOST']['r1'], $HB_ENV['HCUPOST']['r2'], $advSearch);

      // ** Do I need to update the packetStatus with latest values??
      if ($HB_ENV['live'] && $serviceLiveCheck && HCU_array_key_exists('packetStatus', $HB_ENV)) {
        savePacketStatusCookie($HB_ENV);
      }

// TO TEST IN SMALL FRAGMENTS
      $ret_defaultdays = intval(5);

      if ($Get_History_ary['status']['code'] == '000') {

        // * TESTING ONLY REMOVE FOR PRODUCTION
        if ($Get_History_ary['status']['startdate'] == '') {
          $Get_History_ary['status']['startdate'] = date('m/d/Y', strtotime('now - 90 days'));
          $Get_History_ary['status']['stopdate'] = date('m/d/Y', strtotime('now'));
        }

        // * CALCULATE THE NEXT Start End Date
        // Subtract the number of days to fetch from the current starting date for the new start
        $ret_nextstartdate = date('m/d/Y', strtotime("- $ret_defaultdays days", strtotime($Get_History_ary['status']['startdate'])));
        // * NEXT END Date is ONE day previous to the current start
        $ret_nextenddate = date('m/d/Y', strtotime("- 1 days", strtotime($Get_History_ary['status']['startdate'])));

        // ** QUICKLY GO through and format values for presentation
        $retJson_ary = array(
          'title' => 'Account History',
          'status' => '000',
          'datastartdate' => $Get_History_ary['status']['startdate'],
          'dataenddate' => $Get_History_ary['status']['stopdate'],
          'nextstartdate' => $ret_nextstartdate,
          'nextenddate' => $ret_nextenddate,
          'defaultdays' => $ret_defaultdays,
        );

        if (HCU_array_key_exists($history_param, $Get_History_ary)) {
          if (count($Get_History_ary[$history_param]) > 0) {
            foreach ($Get_History_ary[$history_param] as $key => $value) {
              $Get_History_ary[$history_param][$key]['date'] = mobile_formatdate($value['date']);

              // return same date as a number so it can sort easily
              $Get_History_ary[$history_param][$key]['datesort'] = returnJsonDateValue($value['date']);
            }
          }

          $retJson_ary['itemcount'] = count($Get_History_ary[$history_param]);
          $retJson_ary['items'] = is_array($Get_History_ary[$history_param]) ? 
            array_values($Get_History_ary[$history_param]) :
            '';
        }
          
        $retJson_value = HCU_JsonEncode($retJson_ary);

        // ** Try the following to check for Gzip compression
          // * if it is accepted then set the headers and return to table
        if (isset($_SERVER['HTTP_ACCEPT_ENCODING'])) {
          if (stristr($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip,deflate')) {
            $retJson_value = gzencode($retJson_value);
            header('Content-Encoding: gzip');
            header('Content-Length: '.strlen($retJson_value));
          }
        }
        // ** TEST ONLY
        // ** Evaluate browser, if it accepts gzip, then use this

      }
  } else {

    // ** NO ROW EVEN ATTEMPTED TO BE SET
    // ** ERROR OF SOME SORT
  }
}
catch(Exception $ex)
{
  // ** Make sure the results being returned are empty

  $retStatus_ary['homecuErrors'][] = Array('id' => '', 'message' => $ex->getMessage());
  $retJson_value = HCU_JsonEncode(Array("Results" => Array($retStatus_ary)));
}

  header('Content-type: application/json');
  print $retJson_value;