TrustedReport.data

<?php
/*
 * File: TrustedReport.data
 * Purpose: Handle the CRUD portion of the Trusted Vendor Master / Detail report.
 * When returning the requested data do it in a JSON format, for the client to
 * display accordingly.
 *
 * Call this script with the following parameters
 *  action - what the client side is requesting.
 *  optionally, trustid for data related to a particular cutrustedmaster
 *  optionally, cu for a particular cutrusteddetail entry
 *
 * Returns JSON OBJECT.
 */
try {
  // ** Include required SCRIPTS
  $monLibrary= dirname(__FILE__) . "/../library";
  $monIncludes= dirname(__FILE__) . "/../includes";
  $sharedLibrary= dirname(__FILE__) . "/../../shared/library";
  require_once("$monLibrary/cu_top.i");
  require_once("$monLibrary/ck_hticket.i");
  require_once("$monIncludes/cu_remote_top.prg");
  require_once("$sharedLibrary/cutrusted.i");
  require_once("$sharedLibrary/hcuErrorReport.i");

  $dms_ok = array('action'=>'string', 'trustid'=>'string', 'cu'=>'string');
  dms_import($dms_ok);

  //Open database connection
  $dbh = $link;

  header('Content-Type: application/json');


  //get the database connection
  //$dbh is set up

  //require_once('cu_fun.i');

  $aryResult = array();
  $aryErrors =  array();
  $aryReply = array();
  $aryInfo = array();
  // do the requested operation
  switch ($action) {
        case "create":
        case "update":  // update has an id
        case "destroy":
            // no add / update / delete at this time

            break;

        case "read_master":
            /*
             * list info from cutrustedmaster table
             */
            $parms = array();
            $return = cutm_list($dbh, $parms);

            //$aryResult = $return['data'];
            $aryResult = array();
            if (is_array($return['data'])) {
                foreach ($return['data'] as $key => $val) {
                    $thisprop = array();
                    if (is_array($val['fields'])) {
                        foreach ($val['fields'] as $vk => $vv) {
                            if (is_array($vv)) {
                                $thisprop[] = array('vname' => $vk, 'vtype' => $vv['Type'], 'vdefault' => $vv['Default']);
                            }
                        }
                    }
                    $thisun = array(
                        'trustedid' => $val['trustedid'],
                        'trustedvendor' => $val['trustedvendor'],
                        'trustedtype' => $val['trustedtype'],
                        'trustedprops' => array_values($thisprop));
                    //"hcuinterface":"[]",
                    $return['data'][$key] = $thisun;
                }
            }
            $aryResult=(is_array($return['data']) ? array_values($return['data']) : '[]');
            if ($fp) {
                fwrite($fp, print_r($aryResult, true));
            }


            //for ( $i = 0; $i < count( $aryResult ); $i++ ) {
            //$aryResult[$i]["notifymsg"] = html_entity_decode( $aryResult[$i]["notifymsg"], ENT_COMPAT | ENT_HTML401, "UTF-8" );
            //}

            break;

        case "read_masterprop":
            /*
             * list properties from a single cutrustedmaster entry
             */
            $parms = array('trustedid' => $trustid);
            $return = cutm_readdflt($dbh, $parms);

            $aryResult = $return["master"];

            break;

        case "read_clients":
            /*
             * list clients with a detail record for a selected cutrustedmaster entry
             */
            $parms = array('trustedid' => $trustid);
            $return = cutd_list($dbh, $parms);

            $aryResult = array();
            //foreach ($return['data'] as $key => $val) {
            //$aryResult[] = $val;
            //}
            if (is_array($return['data'])) {
                foreach ($return['data'] as $key => $val) {
                    $thisprop = array();
                    if (is_array($val['fields'])) {
                        foreach ($val['fields'] as $vk =>$vv) {
                            $thisprop[]=array('propname'=>$vk,'propval'=>$vv);
                        }
                    }
                    $thisun = array(
                        'cu' => $val['cu'],
                        'trustedid' => $val['trustedid'],
                        'trustedprops'=> array_values($thisprop));
                    $return['data'][$key]=$thisun;
                }
            }
            $aryResult=(is_array($return['data']) ? array_values($return['data']) : '[]');
            if ($fp) {
                fwrite($fp, print_r($aryResult, true));
            }

            break;

        case "read_clientprop":
            /*
             * list properties from a single cutrusteddetail entry
             */
            $parms = array('Cu' => $cu, 'trustedid' => $trustid);
            $return = cutd_read($dbh, $parms);

            $aryResult = array();
            foreach ($return['data'] as $key => $val) {
                $aryResult[] = $val;
            }
            break;
        default:
            $aryErrors[] = "Unexpected action: {$action}";
            throw new Exception(json_encode($aryErrors));
    }
}
catch(Exception $ex)
{
    //Return error message
    $aryReply["homecuErrors"] = json_decode( $ex->getMessage() );

    // if returning error, not replying with data
    $aryResult = array();

    // if returning error, not returning status
    $aryInfo = array();
}

  if ( count( $aryInfo ) ) {
    $aryReply["homecuInfo"] = $aryInfo;
  }

  if ($aryResult == '[]') {
    $aryReply["homecuData"]=null;
    $aryReply["homecuCount"] = 0;
  } else {
    $aryReply["homecuData"] = $aryResult;
    $aryReply["homecuCount"] = count($aryResult);
  }

  print json_encode($aryReply);

?>