//预先判断ebaytoken文件 $__token_file = WEB_PATH_CONF_SCRIPTS_KEYS_EBAY . 'keys_' . $__ebayaccount . '.php'; if (!file_exists($__token_file)) { exit($__token_file . " does not exists!!!"); } /*$_SESSION['user'] = '******'; $user = $_SESSION['user'];*/ //require_once "ebay_order_cron_config.php"; require_once WEB_PATH_LIB_SDK_EBAY . "GetOrdersID.php"; #############类或API 实例化############## $api_goi = new GetOrdersIDAPI($__ebayaccount); #########加载lost_order_id######## $relost_order_ids = ''; $push_order_ids = ''; $lost_orderid_path = EBAY_RAW_DATA_PATH . 'lost_ebay_orderid/' . $__ebayaccount . '/lost_sql.txt'; $orderid_content = read_and_empty_lost_sql($lost_orderid_path); $orderid_lists = sql_str2array($orderid_content); if (!empty($orderid_lists)) { foreach ($orderid_lists as $orderid_sql) { if (!$dbConn->execute($orderid_sql)) { $relost_order_ids .= $orderid_sql . "\n"; } else { $push_order_ids .= $orderid_sql . "\n"; } } if (!empty($relost_order_ids)) { write_lost_sql($lost_orderid_path, $relost_order_ids); } if (!empty($push_order_ids)) { write_lost_sql(str_replace('lost_sql.txt', 'push_success_sql.txt', $lost_orderid_path), $push_order_ids); }
function GetFeedback_change($account) { global $dbcon, $api_feedback, $user; $verb = 'GetFeedback'; $cc = date("Y-m-d H:i:s"); $start = date('Y-m-d H:i:s', strtotime("{$cc} - 61 days")); $start = strtotime($start); $end = strtotime($cc); $file = EBAY_RAW_DATA_PATH . 'feedback_lost_sql/lost_sql.txt'; $file2 = EBAY_RAW_DATA_PATH . 'feedback_lost_sql/success_sql.txt'; $get = "select FeedbackID,CommentText,CommentingUser,ItemID,TransactionID,CommentType from ebay_feedback where account='{$account}' and (CommentType='Neutral' or CommentType='Negative') and feedbacktime between {$start} and {$end}"; $get = $dbcon->execute($get); $get = $dbcon->getResultArray($get); for ($ii = 0; $ii < count($get); $ii++) { $status = ""; $feedbackID = $get[$ii]['FeedbackID']; $commentingUser = $get[$ii]['CommentingUser']; $itemID = $get[$ii]['ItemID']; $transactionID = $get[$ii]['TransactionID']; $commentType = $get[$ii]['CommentType']; $commentText = $get[$ii]['CommentText']; $responseXml = $api_feedback->request_change($itemID, $transactionID, $commentingUser); if (stristr($responseXml, 'HTTP 404') || $responseXml == '') { return 'id not found'; } $data = XML_unserialize($responseXml); $ack = $data['GetFeedbackResponse']['Ack']; $feedbackRevised = $data['GetFeedbackResponse']['FeedbackDetailArray']['FeedbackDetail']; $feedbackRevised = $feedbackRevised[0]['FeedbackRevised']; if ($ack != "Success") { echo '同步失败' . "\n"; } else { if ($feedbackRevised == "true") { $feedback = $data['GetFeedbackResponse']['FeedbackDetailArray']['FeedbackDetail']; $feedbackType = $feedback[0]['CommentType']; $feedbackUser = $feedback[0]['CommentingUser']; if ($commentingUser == $feedbackUser) { $feedbackText = addslashes(str_rep($feedback[0]['CommentText'])); } else { $feedbackText = addslashes(str_rep($commentText)); } if ($commentType != $feedbackType) { if ($commentType == "Neutral") { if ($feedbackType == "Positive") { $status = "21"; //中评改好评 } else { if ($feedbackType == "Negative") { $status = "23"; //中评改差评 } else { $status = "22"; //中评改中评 } } } else { 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"; if ($dbcon->execute($update_type)) { echo 'Success ' . "\n"; write_a_file($file2, $sql); } else { echo 'Failure ' . "\n"; echo mysql_errno() . ": " . mysql_error() . "\n"; write_a_file($file, $sql); } echo 'userID :' . $commentingUser . ":" . $commentType . "------------>" . $feedbackType . "\n"; } } } } } #########加载feedback_lost_sql######## $relost_feedback_ids = ''; $push_feedback_ids = ''; $lost_feedback_path = $file; $feedback_content = read_and_empty_lost_sql($lost_feedback_path); $feedback_lists = sql_str2array($feedback_content); if (!empty($feedback_lists)) { foreach ($feedback_lists as $feedback_sql) { if (!$dbcon->execute($feedback_sql)) { $relost_feedback_ids .= $feedback_sql . "\n"; //获取失败语句 } else { $push_feedback_ids .= $feedback_sql . "\n"; //获取成功语句 } } if (!empty($relost_feedback_ids)) { write_a_file($lost_feedback_path, $relost_feedback_ids); //执行失败再次写入 } if (!empty($push_feedback_ids)) { write_a_file(str_replace('lost_sql.txt', 'push_success_sql.txt', $lost_feedback_path), $push_feedback_ids); } } }