$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);
}
}
$account = $__ebayaccount;
$ebay_start = get_ebay_timestamp($cc - 60 * $__minute_range);
//specific minutes agao
$ebay_end = get_ebay_timestamp($cc);
$ebay_start = date('Y-m-d\\TH:i:s', $ebay_start);
$ebay_end = date('Y-m-d\\TH:i:s', $ebay_end);
//程序计时器
$time_start = $cc;
echo "\n=====[" . date('Y-m-d H:i:s', $time_start) . "]系统【开始】同步账号【 {$account} 】订单 ====>\n";
echo "同步订单范围From: {$ebay_start} To {$ebay_end} \n";
$api_goi->GetSellerOrdersID($ebay_start, $ebay_end, $account);
$time_end = time();
echo "\n=====[耗时:" . ceil(($time_end - $time_start) / 60) . "分钟]====\n";
function push_ebay_orderid_queue($ebay_orderid, $ebay_account)
{
global $dbcon;
//step 1 check ebay orderid statistic table
if (check_ebay_orderid_exists_in_statistic_table($ebay_orderid, $ebay_account) === true) {
echo "ebay orderid[{$ebay_orderid}] already exists in ebay orderid statistic table\n";
return;
}
$table_name = 'ebay_order_id_queue_' . $ebay_account;
$check_sql = 'select * from ' . $table_name . ' where ebay_orderid="' . $ebay_orderid . '"';
$check = $dbcon->execute($check_sql);
$check = $dbcon->getResultArray($check);
if (count($check) == 0) {
$sql = 'insert into ' . $table_name . ' (ebay_orderid) value("' . $ebay_orderid . '")';
$try_insert_count = 0;
while (1) {
$try_insert_count++;
$res = $dbcon->execute($sql);
if ($res) {
echo "Push ebay orderid[{$ebay_orderid}] into queue table successfully!\n";
break;
} else {
if ($try_insert_count == 3) {
$lost_orderid_path = EBAY_RAW_DATA_PATH . 'lost_ebay_orderid/' . $ebay_account . '/lost_sql.txt';
write_lost_sql($lost_orderid_path, $sql . "\n");
echo "oops...failed again,give this order[{$ebay_orderid}] up finally!\n";
break;
}
echo "fail to push ebay orderid[{$ebay_orderid}] into queue table !Sleep 10 sconds then try again\n";
sleep(10);
}
}
} else {
echo "ebay orderid[{$ebay_orderid}] already exists in queue\n";
}
}
