FROM ' . $tableName . ' AS a
LEFT JOIN ' . $tableName . '_detail AS b
ON b.omOrderId = a.id
WHERE a.orderStatus = ' . C('STATESHIPPED') . '
AND a.orderType = ' . C('STATESHIPPED_APPLYPRINT') . '
AND a.is_delete = 0
AND a.storeId= ' . $storeId . $limit;
//echo $ordersql; echo "<br>";
//exit;
$query = $dbConn->query($ordersql);
$orders = $dbConn->fetch_array_all($query);
if (!empty($orders)) {
foreach ($orders as $value) {
$omOrderId = $value['id'];
if (OrderPushModel::listPushMessage($omOrderId)) {
echo "=====[" . date('Y-m-d H:i:s', $time_start) . "]订单{$omOrderId}同步成功======\n";
} else {
echo "=====[" . date('Y-m-d H:i:s', $time_start) . "]订单{$omOrderId}同步失败,原因：" . OrderPushModel::$errMsg . "======\n";
$CommonAct->act_ApplicationException($omOrderId, OrderPushModel::$errMsg);
}
}
} else {
echo "=====没有同步的订单======\n";
}
$page++;
}
$time_end = time();
echo "\n=====[耗时:" . ceil(($time_end - $time_start) / 60) . "分钟]====\n";
echo "\n=====[" . date('Y-m-d H:i:s', $time_end) . "]系统【推送打印数据给仓库系统】订单结束\n";
exit;
//sleep(10);//执行完操作之后开始休眠10秒钟,同步数据。。。。。
