function act_getsku()
{
$TransactionID = isset($_POST['TransactionID']) ? post_check($_POST['TransactionID']) : '';
$TransactionID = trim($TransactionID, "´");
$CommentingUser = isset($_POST['CommentingUser']) ? post_check($_POST['CommentingUser']) : '';
$ItemID = isset($_POST['itemId']) ? post_check($_POST['itemId']) : '';
$FeedbackID = isset($_POST['FeedbackID']) ? post_check($_POST['FeedbackID']) : '';
$CommentType = isset($_POST['CommentType']) ? post_check($_POST['CommentType']) : '';
$field = 'a.ebay_ordersn, a.ebay_paidtime, b.sku, b.ebay_amount';
//echo "$CommentingUser,$ItemID,$TransactionID";
$orderInfo = UserCacheModel::getErpOrderInfo($CommentingUser, $ItemID, $TransactionID, $field);
//var_dump($orderInfo);exit;
$ordersn = $orderInfo['data'][0]['ebay_ordersn'];
//订单号
$sku = $orderInfo['data'][0]['sku'];
//料号
$amount = $orderInfo['data'][0]['ebay_amount'];
//数量
$orderPayTime = $orderInfo['data'][0]['ebay_paidtime'];
//付款时间
$data = array('Qty' => $amount, 'sku' => $sku, 'orderPayTime' => $orderPayTime);
EbayFeedbackModel::update($data, " and FeedbackID = '{$FeedbackID}'");
UserCacheModel::updateErpOrderInfoFeedback($ordersn, $ItemID, $TransactionID, $CommentType);
}
function GetFeedback($account, $startpage, $endpage, $perPageCount)
{
//require_once WEB_PATH."lib/xmlhandle.php";
global $dbcon, $api_feedback, $user;
echo '同步feedback,开始于第' . $startpage . '页，结束于第' . $endpage . '页，每页同步' . $perPageCount . '条' . "\n";
$hasmore = true;
$status = "";
$FBAct = new EbayFeedbackAct();
while (true) {
echo '开始运行,第' . $startpage . '页' . "\n";
$responseXml = $api_feedback->request($startpage, $perPageCount);
if (stristr($responseXml, 'HTTP 404') || $responseXml == '') {
return 'id not found';
}
$data = XML_unserialize($responseXml);
//var_dump($data);
$ack = $data['GetFeedbackResponse']['Ack'];
$TotalNumberOfPages = $data['GetFeedbackResponse']['PaginationResult']['TotalNumberOfPages'];
if ($ack != "Success") {
echo "<font color=red>评价加载失败</font>";
//var_dump($data['GetFeedbackResponse']);exit;
}
$feedback = $data['GetFeedbackResponse']['FeedbackDetailArray']['FeedbackDetail'];
foreach ($feedback as $li) {
$CommentingUser = str_rep($li['CommentingUser']);
$CommentingUserScore = str_rep($li['CommentingUserScore']);
$CommentText = mysql_real_escape_string(str_rep($li['CommentText']));
$CommentTime = str_rep($li['CommentTime']);
$feedbacktime = date('Y-m-d H:i:s', strtotime($CommentTime));
$feedbacktime = date('Y-m-d H:i:s', strtotime("{$feedbacktime} - 900 minutes"));
$feedbacktime = strtotime($feedbacktime);
$CommentType = str_rep($li['CommentType']);
$ItemID = str_rep($li['ItemID']);
$FeedbackID = str_rep($li['FeedbackID']);
$TransactionID = $li['TransactionID'] ? $li['TransactionID'] : 0;
$ItemTitle = str_rep($li['ItemTitle']);
$currencyID = str_rep($li['ItemPrice attr']['currencyID']);
$ItemPrice = str_rep($li['ItemPrice']);
$data = array('CommentingUser' => $CommentingUser, 'account' => $account, 'CommentingUserScore' => $CommentingUserScore, 'CommentText' => $CommentText, 'CommentTime' => $CommentTime, 'CommentType' => $CommentType, 'ItemID' => $ItemID, 'FeedbackID' => $FeedbackID, 'TransactionID' => $TransactionID, 'ItemTitle' => $ItemTitle, 'currencyID' => $currencyID, 'ItemPrice' => $ItemPrice, 'feedbacktime' => $feedbacktime);
$list = $FBAct->act_getOrderList('id', " where FeedbackID='{$FeedbackID}' ");
if (!$list) {
//不存在，则插入
$ret = EbayFeedbackModel::insertRow($data);
if ($ret) {
echo "insert success!\n";
$field = 'a.ebay_ordersn, a.ebay_paidtime, b.sku, b.ebay_amount';
$orderInfo = UserCacheModel::getErpOrderInfo($CommentingUser, $ItemID, $TransactionID, $field);
/* var_dump($orderInfo);
exit; */
$ordersn = $orderInfo['data'][0]['ebay_ordersn'];
//订单号
$sku = $orderInfo['data'][0]['sku'];
//料号
$amount = $orderInfo['data'][0]['ebay_amount'];
//数量
$orderPayTime = $orderInfo['data'][0]['ebay_paidtime'];
//付款时间
$data = array('Qty' => $amount, 'sku' => $sku, 'orderPayTime' => $orderPayTime);
EbayFeedbackModel::update($data, " and FeedbackID = '{$FeedbackID}'");
UserCacheModel::updateErpOrderInfoFeedback($ordersn, $ItemID, $TransactionID, $CommentType);
} else {
echo "insert failed!\n";
}
} else {
echo "Exsited!\n";
}
}
if ($startpage >= $endpage) {
break;
}
$startpage++;
}
}
