for ($i = 1; $i <= $pages; $i++) {
print_r("page " . $i . "\n");
$cases = XML2Array::createArray($ebay->getCases(200, $i));
$cases = isset($cases["soapenv:Envelope"]["soapenv:Body"]["getUserCasesResponse"]["cases"]["caseSummary"]) ? $cases["soapenv:Envelope"]["soapenv:Body"]["getUserCasesResponse"]["cases"]["caseSummary"] : array();
if (!empty($cases)) {
print_r("cases: " . count($cases) . "\n");
foreach ($cases as $j => $caseShort) {
if (isset($caseShort['user']) && $caseShort['user']['userId'] == "chandlermotorsportsinc" && $caseShort['user']['role'] == "SELLER") {
$sql = "SELECT * FROM cases where caseId = '" . $caseShort['caseId']['id'] . "'";
$rs = $db->Execute($sql);
$row = $rs->FetchRow();
if (isset($row['caseId'])) {
print_r("case: " . $row['caseId'] . " exists" . "\n");
continue;
}
$case = XML2Array::createArray($ebay->getCaseDetails($caseShort['caseId']['id'], $caseShort['caseId']['type']));
$case = isset($case["soapenv:Envelope"]["soapenv:Body"]["getEBPCaseDetailResponse"]) ? $case["soapenv:Envelope"]["soapenv:Body"]["getEBPCaseDetailResponse"] : array();
if (!isset($case['caseSummary']['caseId']['id'])) {
$caseSummary = $caseShort;
$caseDetail = array();
} else {
$caseSummary = $case['caseSummary'];
$caseDetail = isset($case['caseDetail']) ? $case['caseDetail'] : array();
}
$status = isset($caseSummary['status']) ? array_values($caseSummary['status']) : array();
$tmp = array("caseId" => $caseSummary['caseId']['id'], "type" => isset($caseSummary['caseId']['type']) ? $caseSummary['caseId']['type'] : '', "userId" => isset($caseSummary['otherParty']['userId']) ? $caseSummary['otherParty']['userId'] : '', "status" => isset($status[0]) ? $status[0] : '', "itemId" => isset($caseSummary['item']['itemId']) ? $caseSummary['item']['itemId'] : '', "transactionId" => isset($caseSummary['item']['transactionId']) ? $caseSummary['item']['transactionId'] : '', "respondByDate" => isset($caseSummary["respondByDate"]) ? $caseSummary["respondByDate"] : '', "creationDate" => isset($caseSummary["creationDate"]) ? $caseSummary["creationDate"] : '', "lastModifiedDate" => isset($caseSummary["lastModifiedDate"]) ? $caseSummary["lastModifiedDate"] : '', "openReason" => isset($caseDetail["openReason"]) ? $caseDetail["openReason"] : '', "decision" => isset($caseDetail["decision"]) ? $caseDetail["decision"] : '', "agreedRefundAmount" => isset($caseDetail["agreedRefundAmount"]) ? $caseDetail["agreedRefundAmount"] : '', "detailStatus" => isset($caseDetail["detailStatus"]) ? $caseDetail["detailStatus"] : '', "initialBuyerExpectation" => isset($caseDetail["initialBuyerExpectation"]) ? $caseDetail["initialBuyerExpectation"] : '');
$updateSQL = $db->GetInsertSQL($rs, $tmp);
$db->Execute($updateSQL);
}
}
} else {
