(PHP ActiveX) Peoplevox GetReportData

Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows Note: The php_com_dotnet.dll may need to be enabled inside of php.ini.

<?php

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

// Sends a POST that looks like this:

// 	POST /PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx HTTP/1.1
// 	Content-Type: text/xml;charset=UTF-8
// 	SOAPAction: http://www.peoplevox.net/GetReportData
// 	Content-Length: (automatically computed and added by Chilkat)
// 	Host: qac.peoplevox.net
// 
// 	<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:peop="http://www.peoplevox.net/">
// 	   <soap:Header>
// 	      <peop:UserSessionCredentials>
// 	         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>
// 	         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>
// 	         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>
// 	      </peop:UserSessionCredentials>
// 	   </soap:Header>
//         <soap:Body>
//           <peop:GetReportData>
//              <peop:getReportRequest>
//                 <peop:TemplateName>Item movement history</peop:TemplateName>
//                 <peop:PageNo>1</peop:PageNo>
//                 <peop:ItemsPerPage>20</peop:ItemsPerPage>
//                 <peop:OrderBy>[Date timestamp]</peop:OrderBy>
//                 <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>
//                 <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>
//              </peop:getReportRequest>
//           </peop:GetReportData>
//        </soap:Body>
// 	</soap:Envelope>
// 

// Notice that a UserId is needed here.  This is different than the username required for Peoplevox authentication.
//    The UserId for the admin account is 1.
//     
// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.StringBuilder')
$sbSoapXml = new COM("Chilkat.StringBuilder");
$sbSoapXml->Append('<?xml version=\'1.0\' encoding=\'utf-8\'?>\r\n');
$sbSoapXml->Append('<soap:Envelope xmlns:soap=\'http://www.w3.org/2003/05/soap-envelope\' xmlns:peop=\'http://www.peoplevox.net/\'>\r\n');
$sbSoapXml->Append('   <soap:Header>\r\n');
$sbSoapXml->Append('      <peop:UserSessionCredentials>\r\n');
$sbSoapXml->Append('         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>\r\n');
$sbSoapXml->Append('         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>\r\n');
$sbSoapXml->Append('         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>\r\n');
$sbSoapXml->Append('      </peop:UserSessionCredentials>\r\n');
$sbSoapXml->Append('   </soap:Header>\r\n');
$sbSoapXml->Append('   <soap:Body>\r\n');
$sbSoapXml->Append('      <peop:GetReportData>\r\n');
$sbSoapXml->Append('         <peop:getReportRequest>\r\n');
$sbSoapXml->Append('            <peop:TemplateName>Item movement history</peop:TemplateName>\r\n');
$sbSoapXml->Append('            <peop:PageNo>1</peop:PageNo>\r\n');
$sbSoapXml->Append('            <peop:ItemsPerPage>20</peop:ItemsPerPage>\r\n');
$sbSoapXml->Append('            <peop:OrderBy>[Date timestamp]</peop:OrderBy>\r\n');
$sbSoapXml->Append('            <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>\r\n');
$sbSoapXml->Append('            <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>\r\n');
$sbSoapXml->Append('         </peop:getReportRequest>\r\n');
$sbSoapXml->Append('      </peop:GetReportData>\r\n');
$sbSoapXml->Append('   </soap:Body>\r\n');
$sbSoapXml->Append('</soap:Envelope>');

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.HttpRequest')
$req = new COM("Chilkat.HttpRequest");
$req->HttpVerb = 'POST';
$req->SendCharset = 1;
$req->Charset = 'utf-8';
$req->AddHeader('Content-Type','text/xml');
$req->AddHeader('SOAPAction','http://www.peoplevox.net/GetReportData');
$req->Path = '/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx';
$success = $req->LoadBodyFromString($sbSoapXml->getAsString(),'utf-8');

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Http')
$http = new COM("Chilkat.Http");
$http->FollowRedirects = 1;

// resp is a Chilkat.HttpResponse
$resp = $http->SynchronousRequest('qac.peoplevox.net',443,1,$req);
if ($http->LastMethodSuccess != 1) {
    print $http->LastErrorText . "\n";
    exit;
}

// We should expect a 200 response if successful.
if ($resp->StatusCode != 200) {
    print 'Response StatusCode = ' . $resp->StatusCode . "\n";
    print 'Response StatusLine: ' . $resp->StatusLine . "\n";
    print 'Response Header:' . "\n";
    print $resp->Header . "\n";
    print $resp->BodyStr . "\n";
    exit;
}

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Xml')
$xmlResponse = new COM("Chilkat.Xml");
$success = $xmlResponse->LoadXml($resp->BodyStr);
print $xmlResponse->getXml() . "\n";

$detail = $xmlResponse->chilkatPath('soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*');

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Csv')
$csv = new COM("Chilkat.Csv");
$csv->HasColumnNames = 1;
$csv->LoadFromString($detail);

print 'NumRows = ' . $csv->NumRows . "\n";
print 'NumColumns = ' . $csv->NumColumns . "\n";

// Iterate over the rows, getting the ItemCode, Name, and Barcode
$i = 0;
$numRows = $csv->NumRows;
while ($i < $numRows) {
    print 'Item code: ' . $csv->getCellByName($i,'Item code') . "\n";
    print 'Date timestamp: ' . $csv->getCellByName($i,'Date timestamp') . "\n";
    print 'From: ' . $csv->getCellByName($i,'From') . "\n";
    print 'To: ' . $csv->getCellByName($i,'To') . "\n";
    print 'Quantity: ' . $csv->getCellByName($i,'Quantity') . "\n";
    print 'Comments: ' . $csv->getCellByName($i,'Comments') . "\n";
    print '-' . "\n";
    $i = $i + 1;
}


?>