/**
* 插入一条记录
* @para $data as array
* return insert_id
*/
public static function insertRow($data)
{
self::initDB();
$sql = array2sql($data);
$sql = "INSERT INTO `" . self::$table . "` SET " . $sql;
//echo $sql;
$query = self::$dbConn->query($sql);
if ($query) {
$insertId = self::$dbConn->insert_id();
return $insertId;
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
}
public function view_ebayUpdateExport()
{
$start = isset($_GET['start']) ? post_check($_GET['start']) : '';
$end = isset($_GET['end']) ? post_check($_GET['end']) : '';
$account = isset($_GET['account']) ? post_check($_GET['account']) : '';
if (!empty($start) && !empty($end)) {
$start = strtotime($start);
$end = strtotime($end);
$wheretime = " and feedbacktime>'{$start}' and feedbacktime<'{$end}' ";
} else {
$wheretime = '';
}
if (!empty($account)) {
$whereacc = "and account='{$account}' ";
} else {
$whereacc = "";
}
$select = " account, CommentingUser, ItemID, CommentType, status, feedbacktime ";
$where = " where 1 {$whereacc} {$wheretime}";
$upList = EbayFeedbackModel::getOrderList($select, $where);
$exporter = new ExportDataExcel("browser", "ebayUpdate_" . date('Y-m-d') . ".xls");
$exporter->initialize();
$exporter->addRow(array('eBay帐号', '买家ID', 'itemId', '原始评价类型', '留评价日期', '添加请求日期'));
foreach ($upList as $value) {
$account = $value['account'];
$CommentingUser = $value['CommentingUser'];
$ItemID = $value['ItemID'];
$CommentType = $value['CommentType'];
$status = $value['status'];
$feedbacktime = date("Y-m-d", $value['feedbacktime']);
$select = " addTime ";
$where = " where account='{$account}' and ebayUserId='{$CommentingUser}' ";
$addTime = OmAvailableModel::getTNameList("fb_request_change_ebay", $select, $where);
$addTime = $addTime[0]['addTime'];
if (!empty($addTime)) {
$addTime = date("Y-m-d", $addTime);
} else {
$addTime = "";
}
$des = NULL;
if ($status == 0) {
if ($CommentType == 'Negative') {
$des = '差评';
} elseif ($CommentType == 'Neutral') {
$des = '中评';
}
} elseif ($status == '21') {
$des = '中评';
} elseif ($status == '31') {
$des = '差评';
}
if (!empty($des)) {
$data = array($account, $CommentingUser, $ItemID, $des, $feedbacktime, $addTime);
$exporter->addRow($data);
} else {
continue;
}
}
exit;
$exporter->finalize();
exit;
}
} else {
if ($commentType == "Negative") {
if ($feedbackType == "Positive") {
$status = "31";
} else {
if ($feedbackType == "Neutral") {
$status = "32";
} else {
$status = "33";
}
}
}
}
if ($status != "") {
$data = array('status' => $status, 'CommentType' => $feedbackType, 'CommentText' => $feedbackText, 'FeedbackID' => $feedbackID);
$upd = EbayFeedbackModel::requestChangeUpateStatus($data, $id, $ebay_account, $commentingUser);
if ($upd) {
echo "Success!\n";
} else {
echo "Failure!\n";
}
echo 'userID :' . $commentingUser . ":" . $commentType . "----->" . $feedbackType . "\n";
}
} else {
echo 'userID:' . $commentingUser . ' no change feedback' . "\n\n";
}
}
}
//end of 可以修改的 fb_request_change_ebay条数
/* $updataNum --;//执行一个 fb_request_change_ebay表对于的 Id，updataNUm减一
if($updataNum>0){//应对同一用户留下多个评价 执行一个 ID 时把所有的评价改回来了，但对应得请求修改表的记录没有置为1，改的还是第一次循环的Id.
function act_feedbackChangeMutilMessage()
{
include WEB_PATH . "lib/feedback/ebaylibrary/ebay_config.php";
//print_r($_POST);//exit;
$bills = isset($_POST['bill']) ? $_POST['bill'] : '';
$content = isset($_POST['content']) ? $_POST['content'] : '';
$content = htmlspecialchars($content);
$content = str_replace("\\", "", $content);
if ($bills == '' || $content == '') {
self::$errCode = '001';
self::$errMsg = "参数错误！";
return false;
}
$accountArr = array();
foreach ($bills as $bill) {
$accountArr[] = $bill['account'];
}
$accountArr = array_unique($accountArr);
$accountStr = implode("','", $accountArr);
$accAct = new AccountAct();
$accountInfo = $accAct->act_getAccountList('account,token', "where account in ('{$accountStr}') and is_delete = 0");
$accountTokens = array();
foreach ($accountInfo as $v) {
$accountTokens[$v['account']] = $v['token'];
}
foreach ($bills as &$bill) {
$bill['token'] = $accountTokens[$bill['account']];
$where = " where account = '{$bill['account']}' and CommentingUser = '******'ebayUserId']}' limit 1";
$lists = EbayFeedbackModel::getOrderList('itemID', $where);
$bill['itemID'] = $lists[0]['itemID'];
}
//print_r($bills);exit;
$verb = 'AddMemberMessageAAQToPartner';
foreach ($bills as $bil) {
//$feedbackid = $bill['feedbackID'];
$userid = $bil['ebayUserId'];
$itemid = $bil['itemID'];
$account = $bil['account'];
$token = $bil['token'];
$requestXmlBody = '<?xml version="1.0" encoding="utf-8"?>
<AddMemberMessageAAQToPartnerRequest xmlns="urn:ebay:apis:eBLBaseComponents">
<RequesterCredentials>
<eBayAuthToken>' . $token . '</eBayAuthToken>
</RequesterCredentials>
<ItemID>' . $itemid . '</ItemID>
<MemberMessage>
<EmailCopyToSender>true</EmailCopyToSender>
<Body>' . $content . '</Body>
<QuestionType>General</QuestionType>
<RecipientID>' . $userid . '</RecipientID>
</MemberMessage>
</AddMemberMessageAAQToPartnerRequest>';
$session = new eBaySession($token, $devID, $appID, $certID, $serverUrl, $compatabilityLevel, $siteID, $verb);
//print_r($session);
//continue;//exit;
$responseXml = $session->sendHttpRequest($requestXmlBody);
if (stristr($responseXml, 'HTTP 404') || $responseXml == '') {
self::$errCode = '002';
self::$errMsg = 'id not found';
return false;
}
$data = XML_unserialize($responseXml);
$ack = $data['AddMemberMessageAAQToPartnerResponse']['Ack'];
$error = $data['AddMemberMessageAAQToPartnerResponse']['Errors']['LongMessage'];
if ($ack != "Failure") {
$data = array('reply_feedback' => $content);
$where = " and FeedbackID='{$feedbackid}' ";
EbayFeedbackModel::update($data, $where);
return 'ok';
} else {
self::$errCode = '003';
self::$errMsg = "批量Message失败！" . $error;
return false;
}
}
}
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++;
}
}
if ($commentType == "Negative") {
if ($feedbackType == "Positive") {
$status = "31";
} else {
if ($feedbackType == "Neutral") {
$status = "32";
} else {
$status = "33";
}
}
} else {
}
}
if ($status != "") {
/*$update_type = "update ebay_feedback set status='$status',CommentType='$feedbackType',CommentText='$feedbackText' where FeedbackID=$feedbackID";
$sql = $update_type;
echo $sql."\n";*/
$data = array('status' => $status, 'CommentType' => $feedbackType, 'CommentText' => $feedbackText, 'FeedbackID' => $feedbackID);
$upd = EbayFeedbackModel::requestChangeUpateStatus($data);
if ($upd) {
echo "Success!\n";
} else {
echo "Failure!\n";
}
echo 'userID :' . $commentingUser . ":" . $commentType . "---->" . $feedbackType . "\n";
}
}
}
}
}
}
