/** * 名称: getTracknumberInfoByDate * 功能: 根据开始时间与结束时间获取跟踪号信息 * @para $startTime int * @para $endTime int * return Array */ public function getTracknumberInfoByDate($startTime, $endTime) { self::initDB(); if (preg_match('/^\\d+$/', $startTime) < 1 || preg_match('/^\\d+$/', $endTime) < 1) { self::$errCode = '3302'; self::$errMsg = '开始时间或结束时间输入不正确, 请重试! '; return false; } $sql = 'SELECT os.`id`,os.`originOrderId`,os.`recordNumber`,os.`shipOrderId`,os.`storeId`,ot.`tracknumber` FROM wh_shipping_order_relation AS os LEFT JOIN wh_order_tracknumber AS ot ON os.`shipOrderId` = ot.`shipOrderId` WHERE ot.createdTime >= ' . $startTime . ' AND ot.createdTime <= ' . $endTime; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); } else { self::$errCode = "003"; self::$errMsg = "error"; return false; } $data = array(); if (!empty($ret)) { $tempData = array(); foreach ($ret as $k => $v) { $tempData[] = $v['originOrderId']; } $tempData = array_flip(array_flip($tempData)); //清除多余的订单号 foreach ($ret as $k => $v) { if (in_array($v['originOrderId'], $tempData)) { $data[] = array('orderId' => $v['originOrderId'], 'tracknumber' => $v['tracknumber']); } } } return $data; //成功, 返回列表数据 }