$password = "******";
$soapClient = new SoapClient($wsdlUrl, array('trace' => 1, 'exception' => 0));
$soapClient->__setLocation($wsdllUrl);
$strWSSENS = "http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd";
$objSoapVarUser = new SoapVar($username, XSD_STRING, NULL, $strWSSENS, "UserName", $strWSSENS);
$objSoapVarPass = new SoapVar($password, XSD_STRING, NULL, $strWSSENS, "Password", $strWSSENS);
$objWSSEAuth = new clsWSSEAuth($objSoapVarUser, $objSoapVarPass);
$objSoapVarWSSEAuth = new SoapVar($objWSSEAuth, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objWSSEToken = new clsWSSEToken($objSoapVarWSSEAuth);
$objSoapVarWSSEToken = new SoapVar($objWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'UsernameToken', $strWSSENS);
$objSoapVarHeaderVal = new SoapVar($objSoapVarWSSEToken, SOAP_ENC_OBJECT, NULL, $strWSSENS, 'Security', $strWSSENS);
$objSoapVarWSSEHeader = new SoapHeader($strWSSENS, 'Security', $objSoapVarHeaderVal, true);
$soapClient->__setSoapHeaders(array($objSoapVarWSSEHeader));
$manifest = $soapClient->CreateExportJob(array('ExportJobTypeName' => 'Shipping Manifest', 'ExportColumns' => array('ExportColumn' => array('manifestCode', 'manifestStatus')), 'ExportFilters' => array('ExportFilter' => array('DateRange' => array('Start' => $fromdate, 'End' => $todate), 'id' => 'dateRange')), 'Frequency' => 'ONETIME'));
$write->query("truncate `manifestdata`");
$export = $soapClient->GetExportJobStatus(array('JobCode' => $manifest->JobCode));
if ($export->Status == "COMPLETE") {
$csvfile = $export->FilePath;
$handle = fopen($csvfile, "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if ($data[1] == "CLOSED") {
$write->query("insert into `manifestdata` (manifest_code, manifest_status, manifest_date) values('" . $data[0] . "', '" . $data[1] . "', '" . $fromdate . "')");
}
}
} else {
$export = $soapClient->GetExportJobStatus(array('JobCode' => $manifest->JobCode));
$csvfile = $export->FilePath;
$handle = fopen($csvfile, "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if ($data[1] == "CLOSED") {
$write->query("insert into `manifestdata` (manifest_code, manifest_status, manifest_date) values('" . $data[0] . "', '" . $data[1] . "', '" . $fromdate . "')");
