{
"filter": {
"sku_code": [
"smileying01"
]
},
"per_page": 100,
"page": 1
}
// 单个模糊检索，多个精确检索：订单号、交易号、退货单号、退货快递单号、货运单号、商品SKU
// 键为请求参数，值为 SQL 查询字段
$fields = [
'plat_order_no' => 'plat_order_no',
'transaction_no' => 'transaction_no',
'return_order_no' => 'return_order_no',
'return_logistics_freight_no' => 'return_order_logistics.logistics_freight_no',
'logistics_freight_no' => 'logistics_freight_no',
'sku_code' => 'return_order_items.sku_code',
];
$allowedFilters = [
AllowedFilter::exact('signing_status'),
AllowedFilter::partial('remark'),
AllowedFilter::exact('return_type'),
AllowedFilter::exact('processing_method'),
AllowedFilter::scope('created_at_gmt_start'),
AllowedFilter::scope('created_at_gmt_end'),
AllowedFilter::scope('order_payment_at_gmt_start'),
AllowedFilter::scope('order_payment_at_gmt_end'),
AllowedFilter::scope('order_delivery_at_gmt_start'),
AllowedFilter::scope('order_delivery_at_gmt_end'),
];
foreach ($fields as $key => $field) {
if (isset($criteria['filter'][$key])) {
if (count($criteria['filter'][$key]) > 1) {
// 多个精确检索
$allowedFilters[] = AllowedFilter::exact($field);
} else {
// 单个模糊检索
$allowedFilters[] = AllowedFilter::partial($field);
}
if ($key != $field) {
$criteria['filter'][$field] = $criteria['filter'][$key];
unset($criteria['filter'][$key]);
}
}
}
// 退货原因ID，转换 SQL 查询字段
if (isset($criteria['filter']['refund_reason_id'])) {
$criteria['filter']['return_order_refund_reasons.refund_reason_id'] = $criteria['filter']['refund_reason_id'];
unset($criteria['filter']['refund_reason_id']);
$allowedFilters[] = AllowedFilter::exact('return_order_refund_reasons.refund_reason_id');
}
$builder = QueryBuilder::for(ReturnOrder::class, new Request($criteria))
->select('return_orders.*')
->leftJoin('return_order_items', 'return_order_items.return_order_id', 'return_orders.id')
->leftJoin('return_order_refund_reasons', 'return_order_refund_reasons.return_order_id', 'return_orders.id')
->leftJoin('return_order_logistics', 'return_order_logistics.return_order_id', 'return_orders.id')
->allowedFilters($allowedFilters)
->with('returnOrderItems')
->with('returnOrderRefundReasons.refundReason')
->with('returnOrderLogistics')
->with('resendOrder')
->with('order.orderItemLogisticsFeatures')
->defaultSort('-id');
select
count(*) as aggregate
from
`return_orders`
left join `return_order_items` on `return_order_items`.`return_order_id` = `return_orders`.`id`
left join `return_order_refund_reasons` on `return_order_refund_reasons`.`return_order_id` = `return_orders`.`id`
left join `return_order_logistics` on `return_order_logistics`.`return_order_id` = `return_orders`.`id`
where
(
LOWER(`return_order_items`.`sku_code`) LIKE '%smileying01%'
)
// 单个模糊检索，多个精确检索：订单号、交易号、退货单号、退货快递单号、货运单号、商品SKU
// 键为请求参数，值为 SQL 查询字段
$fields = [
'plat_order_no' => 'plat_order_no',
'transaction_no' => 'transaction_no',
'return_order_no' => 'return_order_no',
'return_logistics_freight_no' => 'return_order_logistics.logistics_freight_no',
'logistics_freight_no' => 'logistics_freight_no',
'sku_code' => 'return_order_items.sku_code',
];
$allowedFilters = [
AllowedFilter::exact('signing_status'),
AllowedFilter::partial('remark'),
AllowedFilter::exact('return_type'),
AllowedFilter::exact('processing_method'),
AllowedFilter::scope('created_at_gmt_start'),
AllowedFilter::scope('created_at_gmt_end'),
AllowedFilter::scope('order_payment_at_gmt_start'),
AllowedFilter::scope('order_payment_at_gmt_end'),
AllowedFilter::scope('order_delivery_at_gmt_start'),
AllowedFilter::scope('order_delivery_at_gmt_end'),
];
foreach ($fields as $key => $field) {
if (isset($criteria['filter'][$key])) {
if (count($criteria['filter'][$key]) > 1) {
// 多个精确检索
$allowedFilters[] = AllowedFilter::exact($field);
} else {
// 单个模糊检索
$allowedFilters[] = AllowedFilter::partial($field);
}
if ($key != $field) {
$criteria['filter'][$field] = $criteria['filter'][$key];
unset($criteria['filter'][$key]);
}
}
}
// 退货原因ID，转换 SQL 查询字段
if (isset($criteria['filter']['refund_reason_id'])) {
$criteria['filter']['return_order_refund_reasons.refund_reason_id'] = $criteria['filter']['refund_reason_id'];
unset($criteria['filter']['refund_reason_id']);
$allowedFilters[] = AllowedFilter::exact('return_order_refund_reasons.refund_reason_id');
}
$builder = QueryBuilder::for(ReturnOrder::class, new Request($criteria))->select('return_orders.*');
// 退货快递单号
if (isset($criteria['filter']['return_logistics_freight_no'])) {
$builder->leftJoin('return_order_logistics', 'return_order_logistics.return_order_id', 'return_orders.id');
}
// 商品 SKU 编码
if (isset($criteria['filter']['return_order_items.sku_code'])) {
$builder->leftJoin('return_order_items', 'return_order_items.return_order_id', 'return_orders.id');
}
// 退货原因ID
if (isset($criteria['filter']['refund_reason_id'])) {
$builder->leftJoin('return_order_refund_reasons', 'return_order_refund_reasons.return_order_id', 'return_orders.id');
$allowedFilters[] = AllowedFilter::exact('return_order_refund_reasons.refund_reason_id');
}
$builder->allowedFilters($allowedFilters)
->with('returnOrderItems')
->with('returnOrderRefundReasons.refundReason')
->with('returnOrderLogistics')
->with('resendOrder')
->with('order.orderItemLogisticsFeatures')
->defaultSort('-id');
select
count(*) as aggregate
from
`return_orders`
left join `return_order_items` on `return_order_items`.`return_order_id` = `return_orders`.`id`
where
(
LOWER(`return_order_items`.`sku_code`) LIKE '%smileying01%'
)
PHP / Laravel / Yii2 老项目维护与长期技术支持
如果你的 PHP / Laravel / Yii2 项目已经上线，但遇到原开发离职、Bug 长期无人修复、接口不稳定、性能下降、代码难以接手等问题，可以联系我做一次远程技术排查。
适合以下情况：
✅ 老旧 PHP 系统无人维护
✅ Laravel / Yii2 项目 Bug 修复
✅ 后台管理系统小功能迭代
✅ RESTful API 接口排查
✅ MySQL / Redis / Nginx 性能问题
✅ 长期远程兼职维护
可先从一次小问题开始：
✅ 线上报错排查
✅ 接口异常分析
✅ 慢查询与性能瓶颈定位
✅ 代码结构初步评估
✅ 部署环境与日志检查
如需咨询，请联系我，并注明：PHP 维护咨询。
联系方式：
Telegram：@shuijingwan
微信：13980074657
邮箱：shuijingwanwq@gmail.com
发表回复