all(); //组织id if (empty($param["org_id"])) { return sparkSuccess(dataReturn(0, 'success', "参数不足")); } $where = []; if (!empty($param["org_name"])) { $where[] = ['org_name', 'like', '%' . $param["org_name"] . '%']; } $org_ids = getOrgSelfAndChildrenIdsById($param["org_id"]); $list = (new Video()) ->select() ->whereIn("org_id", $org_ids) ->where($where) ->orderBy("id", "desc") ->paginate($param["limit"] ?? 10); //获取 项目部 和 公司 $adminorg = (new AdminOrg()); foreach ($list as $item) { $org_id = $item["org_id"]; $pid = $adminorg->select()->where("id", '=', $org_id)->value("pid"); $parent_name = $adminorg->select()->where("id", '=', $pid)->value("name"); $ppid = $adminorg->select()->where("id", '=', $pid)->value("pid"); $g_parent_name = $adminorg->select()->where("id", '=', $ppid)->value("name"); $item["org_name"] = $g_parent_name . '#' . $item["org_name"]; } // $key = (new SysSetting()) // ->select() // ->where("key", "=", "appkey") // ->value("value"); // $secret = (new SysSetting()) // ->select() // ->where("key", "=", "secret") // ->value("value"); // $result["list"] = $list; // $result["key"] = $key; // $result["secret"] = $secret; return sparkSuccess(dataReturn(0, 'success', $list)); } }