rjhsystems

I am getting Closer..... (I think) i got the php script to make an array however if there is more then one <servicerequest></servicerequest> Tag i get Array ( [id] => <serviceRequestId>1001</serviceRequestId> [description] => <description>Computer will not turn on</description> [status] => <status>Closed</status> [asssigned] => <serviceManagerId>0</serviceManagerId> [createdate] => <dateTimeCreated>2012-09-14T18:42:40</dateTimeCreated> [closedate] => <dateTimeClosed>2012-09-14T18:49:58.347</dateTimeClosed> ) Array ( [id] => <serviceRequestId>1005</serviceRequestId> [description] => <description>this is a test</description> [status] => <status>New</status> [asssigned] => <serviceManagerId>33443928</serviceManagerId> [createdate] => <dateTimeCreated>2012-10-06T05:57:08</dateTimeCreated> [closedate] => ) Thus when outputting to Smarty i get this 1005 this is a test New 2012-10-06T05:57:08 1005 this is a test New 2012-10-06T05:57:08 1005 this is a test New 2012-10-06T05:57:08 1005 this is a test New 2012-10-06T05:57:08 1005 this is a test New 2012-10-06T05:57:08 1005 this is a test New 2012-10-06T05:57:08 Instead of 1001 Computer will not turn on Closed 2012-09-14T18:42:40 1005 this is a test New 2012-10-06T05:57:08 This is the PHP Code <?php define("CLIENTAREA",true); //define("FORCESSL",true); # Uncomment to force the page to use https:// require("dbconnect.php"); require("includes/functions.php"); require("includes/clientareafunctions.php"); $pagetitle = $_LANG['clientareatitle']; $breadcrumbnav = '<a href="index.php">'.$_LANG['globalsystemname'].'</a>'; $breadcrumbnav .= ' > <a href="mypage.php">My Page</a>'; initialiseClientArea($pagetitle,'',$breadcrumbnav); # To assign variables to the template system use the following syntax. # These can then be referenced using {$variablename} in the template. $smartyvalues["variablename"] = $value; # Check login status if ($_SESSION['uid']) { # User is logged in - put any code you like here # Retrieve User ID $result = mysql_query("SELECT companyname FROM tblclients WHERE id=".(int)$_SESSION['uid']); $data = mysql_fetch_array($result); $companyname = $data[0]; $credentials = "xxxxxxxxxxxxxxxxxxxxxx:xxxxxxxxxxxxxxxxxxxxxxxxxxxx"; // Read the XML to send to the Web Service $xml_data = "<request> <serviceRequestList> <listType>basic</listType> <customerName>$companyname</customerName> </serviceRequestList> </request>"; $url = "https://app.packettrappsa.com/api/2.0/serviceRequests/list.aspx"; $page = "api/2.0/serviceRequests/list.aspx"; $headers = array( "POST ".$page." HTTP/1.0", "Content-type: text/xml;charset=\"utf-8\"", "Accept: text/xml", "Cache-Control: no-cache", "Pragma: no-cache", "SOAPAction: \"run\"", "Content-length: ".strlen($xml_data), "Authorization: Basic " . base64_encode($credentials) ); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_TIMEOUT, 60); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt($ch, CURLOPT_USERAGENT, $defined_vars['HTTP_USER_AGENT']); // Apply the XML to our curl call curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $xml_data); $data = curl_exec($ch); if (curl_errno($ch)) { print "Error: " . curl_error($ch); } else { // Show me the result curl_close($ch); // echo $data; $xml = simplexml_load_string($data); foreach($xml->serviceRequestList->serviceRequest as $service) { $srid = $service->serviceRequestId->asXML(); $srdesc = $service->description->asXML(); $srstatus = $service->status->asXML(); $srassignedto = $service->serviceManagerId->asXML(); $srcreatedate = $service->dateTimeCreated->asXML(); $srclosedate = $service->dateTimeClosed->asXML(); $result = array('id' => $srid, 'description' => $srdesc, 'status' => $srstatus, 'asssigned' => $srassignedto, 'createdate' => $srcreatedate, 'closedate' => $srclosedate); $smartyvalues["sr"] = $result; } } } else { # User is not logged in } # Define the template filename to be used without the .tpl extension $templatefile = "servicerequests"; outputClientArea($templatefile); ?> And This is The TPL Code <a name="content"></a> <div id="contentWrapper"> <div id="contentArea"> <div class="post" id="post-71"> <div class="postHeader"> <h2 class="postTitle"><span></span>My Service Requests</h2> </div> <div class="postContent"> <table class="grid" cellspacing="0" rules="cols" border="1" id="dgSRList" style="width:100%;border-collapse:collapse;"> <tbody><tr> <th scope="col"> <font>No.</font> </th> <th scope="col"> <font>Description</font></th> <th scope="col"> <font>status</font></th> <th scope="col" style="white-space:nowrap;"> <font>Assigned To</font></th> <th scope="col"> <font>Created</font></th> </tr> {foreach from=$sr item=id} <tr> <td style="width:60px;white-space:nowrap;"> <a class="bold" href="servicerequest.php?id={$sr.id}">{$sr.id}</a> </td><td> <a class="bold" href="servicerequest.php?id={$sr.id}">{$sr.description}</a> </td><td> <span id="SRStatus_1000"></span>{$sr.status}</td><td>{$sr.assignedto} </td><td style="width:90px;white-space:nowrap;"> {$sr.createdate} </td> </tr> {/foreach} </tbody></table> </form> {include file="$template/sidebar.tpl"} Any Ideas????

Hello. I have this XML Code here <response status="ok"> <serviceRequestList> <serviceRequest> <accountManagerId></accountManagerId> <billable></billable> <billableTotal></billableTotal> <billingStatus></billingStatus> <customerContactEmail></customerContactEmail> <customerContactId></customerContactId> <customerContactName></customerContactName> <customerContactPhone></customerContactPhone> <customerContactPhoneMobile></customerContactPhoneMobile> <customerId></customerId> <customerLocationCity></customerLocationCity> <customerLocationCountry></customerLocationCountry> <customerLocationId></customerLocationId> <customerLocationName></customerLocationName> <customerLocationNotes></customerLocationNotes> <customerLocationPostalCode></customerLocationPostalCode> <customerLocationState></customerLocationState> <customerLocationStreetAddress></customerLocationStreetAddress> <customerLocationZone></customerLocationZone> <customerName></customerName> <dateTimeCreated></dateTimeCreated> <dateTimeClosed></dateTimeClosed> <description></description> <detailedDescription></detailedDescription> <dueDate></dueDate> <externalId></externalId> <priority></priority> <priorityLabel></priorityLabel> <serviceManagerId></serviceManagerId> <serviceRequestId></serviceRequestId> <status></status> <timeOpen_hours></timeOpen_hours> <type></type> </serviceRequest> <serviceRequest> ... </serviceRequest> </serviceRequestList> </response> It is from an API URL I can call the XML From PHP using SimpleXML but i need a way to code the PHP so in the template file for the page it will create table row for each ServiceRequestID with the information from <serviceRequestId>, <description>, <status> <serviceManagerId> & <datetimecreated> and maybe if possible if <status> is closed instead of <datetimecreated> it shows <datetimeclosed> I am only able to get to the point of echoing the XML using SimpleXML in PHP but thats as far as i can go, i can't get it to goto smarty for the foreach statement, i never really messed with XML This is the PHP Code i am trying to use <?php define("CLIENTAREA",true); //define("FORCESSL",true); # Uncomment to force the page to use https:// require("dbconnect.php"); require("includes/functions.php"); require("includes/clientareafunctions.php"); $pagetitle = $_LANG['clientareatitle']; $breadcrumbnav = '<a href="index.php">'.$_LANG['globalsystemname'].'</a>'; $breadcrumbnav .= ' > <a href="mypage.php">My Page</a>'; initialiseClientArea($pagetitle,'',$breadcrumbnav); # To assign variables to the template system use the following syntax. # These can then be referenced using {$variablename} in the template. $smartyvalues["variablename"] = $value; # Check login status if ($_SESSION['uid']) { # User is logged in - put any code you like here # Retrieve User ID $result = mysql_query("SELECT companyname FROM tblclients WHERE id=".(int)$_SESSION['uid']); $data = mysql_fetch_array($result); $companyname = $data[0]; $credentials = "specialapipasswordfrompackettrap:xxxxxxxxxxxxxxxxxxxxxxxxxxxx"; // Read the XML to send to the Web Service $xml_data = "<request> <serviceRequestList> <listType>basic</listType> <customerName>$companyname</customerName> </serviceRequestList> </request>"; $url = "https://app.packettrappsa.com/api/2.0/serviceRequests/list.aspx"; $page = "api/2.0/serviceRequests/list.aspx"; $headers = array( "POST ".$page." HTTP/1.0", "Content-type: text/xml;charset=\"utf-8\"", "Accept: text/xml", "Cache-Control: no-cache", "Pragma: no-cache", "SOAPAction: \"run\"", "Content-length: ".strlen($xml_data), "Authorization: Basic " . base64_encode($credentials) ); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_TIMEOUT, 60); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt($ch, CURLOPT_USERAGENT, $defined_vars['HTTP_USER_AGENT']); // Apply the XML to our curl call curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $xml_data); $data = curl_exec($ch); if (curl_errno($ch)) { print "Error: " . curl_error($ch); } else { // Show me the result curl_close($ch); // echo $data; $xml = simplexml_load_string($data); foreach($xml->serviceRequestList->serviceRequest as $servicerequest) { $srid = "$servicerequest->serviceRequestId"; $srdesc = "$servicerequest->description"; $srstatus = "$servicerequest->status"; $srassigned = "$servicerequest->status"; $srcreatedate = "$servicerequest->dateTimeCreated"; } $sr = array( "srid" => "$srid", "srdesc" => "$srdesc", "srstatus" => "$srstatus", "srassigned" => "$srassigned", "srcreatedate"=> "$srcreatedate" ); $smartyvalues["sr"] = $sr; //$smartyvalues["srid"] = $srid; //$smartyvalues["srdesc"] = $srdesc; //$smartyvalues["srstatus"] = $srstatus; //$smartyvalues["srassigned"] = $srassigned; //$smartyvalues["srcreatedate"] = $srcreatedate; } } else { # User is not logged in } # Define the template filename to be used without the .tpl extension $templatefile = "servicerequests"; outputClientArea($templatefile); ?>

Hello, i am trying to use the API w/ the API Access Key, the $api_access_key var is in the configuration.php file however, WHMCS insists on using the Allowed IPs for the API Access. resulting in result=error;message=Invalid IP xxx.xxx.xxx.xxx; (IP Hidden for security purposes) This is my Configuration.php File <?php $license = 'xxxxxxxxxxxxxxxxxxxxxxx; $db_host = 'xxxxxxxxxxxxxxxx'; $db_username = 'xxxxxxxxxxx'; $db_password = 'xxxxxxxxxxxxx'; $db_name = 'xxxxxxxxxxx'; $cc_encryption_hash = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'; $templates_compiledir = 'templates_c/'; $mysql_charset = 'utf8'; $api_access_key = "xxxxxxxxxxxxxx"; ?> Anyone have ideas?

If people have the license through webhosts how does the upgrades work the same as a normal license?

Hi All!, I have launched my site for my company RJH Systems Please let me know how it looks Thanks http://www.rjhsystems.com