$where['in'] = [];
$where['in']['sub_order_id'] = $subOrderIds;
$in = [];
if (isset($where['in'])) {
$in = $where['in'];
unset($where['in']);
}
$query = $this->dbDomain->table(self::TABLE)
->where($where);
if (!empty($in)) {
foreach ($in as $name => $value) {
$query->whereIn($name, $value);
}
}
$query->where(self::COL_IS_DELETED, "=", 0)
->orderBy(self::COL_CREATED_TIME, 'desc');
$total = $query->count();
if ($page != 0) {
$query->forPage($page, $pageSize);
}
$subOrders = $query->get($columns)->all();