/** * 插入一条记录 * @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"; } } } } } }