/[LeafOK_CVS]/fenglin/bbs/search_article_v2.php
ViewVC logotype

Annotation of /fenglin/bbs/search_article_v2.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (hide annotations)
Wed Jan 21 09:42:27 2026 UTC (7 weeks, 6 days ago) by sysadm
Branch: MAIN
Changes since 1.1: +1 -7 lines
Add config for Solr connection

1 sysadm 1.1 <?php
2     require_once "../lib/db_open.inc.php";
3 sysadm 1.2 require_once "../conf/solr.conf.php";
4 sysadm 1.1 require_once "./session_init.inc.php";
5     require_once "./theme.inc.php";
6    
7     force_login();
8    
9     $result_set = array(
10     "return" => array(
11     "code" => 0,
12     "message" => "",
13     "errorFields" => array(),
14     )
15     );
16    
17     $uid = (isset($_GET["uid"]) ? intval($_GET["uid"]) : 0);
18     $username = (isset($_GET["username"]) ? trim($_GET["username"]) : "");
19     $nickname = (isset($_GET["nickname"]) ? trim($_GET["nickname"]) : "");
20     $title = (isset($_GET["title"]) ? trim($_GET["title"]) : "");
21     $content = (isset($_GET["content"]) ? trim($_GET["content"]) : "");
22    
23     if (!isset($_GET["begin_dt"]) || ($begin_dt = DateTimeImmutable::createFromFormat("Y-m-d", $_GET["begin_dt"], $_SESSION["BBS_user_tz"])) == false)
24     {
25     $begin_dt = new DateTimeImmutable("-1 month", $_SESSION["BBS_user_tz"]);
26     }
27     if (!isset($_GET["end_dt"]) || ($end_dt = DateTimeImmutable::createFromFormat("Y-m-d", $_GET["end_dt"], $_SESSION["BBS_user_tz"])) == false)
28     {
29     $end_dt = new DateTimeImmutable("1 day", $_SESSION["BBS_user_tz"]);
30     }
31    
32     $sid = (isset($_GET["sid"]) ? intval($_GET["sid"]) : 0);
33     $ex = (isset($_GET["ex"]) && $_GET["ex"] == "1" ? 1 : 0);
34     $reply = (isset($_GET["reply"]) && $_GET["reply"] == "1" ? 1 : 0);
35     $use_nick = (isset($_GET["use_nick"]) && $_GET["use_nick"] == "1" ? 1 : 0);
36     $original = (isset($_GET["original"]) && $_GET["original"] == "1" ? 1 : 0);
37     $page = (isset($_GET["page"]) ? intval($_GET["page"]) : 1);
38     $rpp = (isset($_GET["rpp"]) ? intval($_GET["rpp"]) : 10);
39    
40     $sid_list = "(-1)";
41     if ($sid > 0)
42     {
43     if ($_SESSION["BBS_priv"]->checkpriv($sid, S_LIST))
44     {
45     $sid_list = $sid;
46     }
47     }
48     else
49     {
50     $rs = mysqli_query($db_conn, "SELECT SID FROM section_config WHERE enable" .
51     ($sid < 0 ? " AND CID = " . (-$sid) : ""));
52     if ($rs == false)
53     {
54     $result_set["return"]["code"] = -2;
55     $result_set["return"]["message"] = "Query section error: " . mysqli_error($db_conn);
56    
57     mysqli_close($db_conn);
58     exit(json_encode($result_set));
59     }
60    
61     while ($row = mysqli_fetch_array($rs))
62     {
63     if ($_SESSION["BBS_priv"]->checkpriv($row["SID"], S_LIST))
64     {
65     $sid_list .= (" OR " . $row["SID"]);
66     }
67     }
68     mysqli_free_result($rs);
69     }
70    
71     // Initialize Solr client
72     $solr_client = new SolrClient($solr_options);
73    
74     $query_str = "" .
75     ($sid_list == "(-1)" ? "" : "SectionId:($sid_list) AND ") .
76     ($reply ? "" : "TopicId:0 AND ") .
77     ($username == "" ? "" : "PostUserName:($username) AND ") .
78     ($nickname == "" ? "" : "PostUserNickName:($nickname) AND ") .
79     ($ex == 1 ? "Excerption:1 AND " : "") .
80     ($original ? "Eransship:0 AND " : "") .
81     "PostDateTime:[" . $begin_dt->setTimezone(new DateTimeZone("UTC"))->format("Y-m-d\T00:00:00\Z") . " TO " .
82     $end_dt->setTimezone(new DateTimeZone("UTC"))->format("Y-m-d\T23:59:59\Z") . "] AND " .
83     ($title == "" ? "" : "ArticleTitle:($title) AND ") .
84     ($content == "" ? "" : "Content:($content) AND ") .
85     "*:*";
86    
87     // Query count of articles
88     $solr_query = new SolrQuery();
89     $solr_query->setQuery($query_str);
90     $solr_query->addField("ArticleId");
91     $solr_query->addSortField("PostDateTime", SolrQuery::ORDER_DESC);
92     try
93     {
94     $solr_res = $solr_client->query($solr_query);
95     }
96     catch (Exception $e)
97     {
98     $result_set["return"]["code"] = -3;
99     $result_set["return"]["message"] = "Solr query error";
100    
101     exit(json_encode($result_set));
102     }
103     $solr_obj = $solr_res->getResponse();
104    
105     if ($solr_obj->responseHeader->status != 0)
106     {
107     $result_set["return"]["code"] = -3;
108     $result_set["return"]["message"] = "Solr query error: " . $solr_obj->responseHeader->status;
109    
110     exit(json_encode($result_set));
111     }
112    
113     $toa = $solr_obj->response->numFound;
114    
115     unset($solr_query);
116    
117     if (!in_array($rpp, $BBS_list_rpp_options))
118     {
119     $rpp = $BBS_list_rpp_options[0];
120     }
121    
122     $page_total = ceil($toa / $rpp);
123     if ($page > $page_total)
124     {
125     $page = $page_total;
126     }
127    
128     if ($page <= 0)
129     {
130     $page = 1;
131     }
132    
133     // Fill up result data
134     $result_set["data"] = array(
135     "uid" => $uid,
136     "sid" => $sid,
137     "ex" => $ex,
138     "reply" => $reply,
139     "use_nick" => $use_nick,
140     "original" => $original,
141     "username" => $username,
142     "nickname" => $nickname,
143     "title" => $title,
144     "content" => $content,
145     "begin_dt" => $begin_dt,
146     "end_dt" => $end_dt,
147     "favorite" => 0,
148     "trash" => 0,
149     "toa" => $toa,
150     "page" => $page,
151     "rpp" => $rpp,
152     "page_total" => $page_total,
153    
154     "articles" => array(),
155     );
156    
157     // Query article IDs
158     $solr_query = new SolrQuery();
159     $solr_query->setQuery($query_str);
160     $solr_query->addField("ArticleId");
161     $solr_query->addSortField("PostDateTime", SolrQuery::ORDER_DESC);
162     $solr_query->setStart(($page - 1) * $rpp);
163     $solr_query->setRows($rpp);
164     try
165     {
166     $solr_res = $solr_client->query($solr_query);
167     }
168     catch (Exception $e)
169     {
170     $result_set["return"]["code"] = -3;
171     $result_set["return"]["message"] = "Solr query error";
172    
173     exit(json_encode($result_set));
174     }
175     $solr_obj = $solr_res->getResponse();
176    
177     if ($solr_obj->responseHeader->status != 0)
178     {
179     $result_set["return"]["code"] = -3;
180     $result_set["return"]["message"] = "Solr query error: " . $solr_obj->responseHeader->status;
181    
182     exit(json_encode($result_set));
183     }
184    
185     // print_r($solr_obj);
186     // exit();
187    
188     $aid_list = "-1";
189    
190     if ($solr_obj->response->docs !== false)
191     {
192     foreach ($solr_obj->response->docs as $doc)
193     {
194     $aid_list .= (", " . $doc["ArticleId"]);
195     }
196     }
197    
198     unset($solr_query);
199     unset($solr_client);
200    
201     // Query articles
202     $sql = "SELECT bbs.*, section_class.cname, section_class.title AS c_title,
203     section_config.sname, section_config.title AS s_title FROM bbs
204     INNER JOIN section_config ON bbs.SID = section_config.SID
205     INNER JOIN section_class ON section_config.CID = section_class.CID" .
206     " WHERE bbs.AID in ($aid_list)" .
207     " ORDER BY sub_dt DESC";
208    
209     $rs = mysqli_query($db_conn, $sql);
210     if ($rs == false)
211     {
212     $result_set["return"]["code"] = -2;
213     $result_set["return"]["message"] = "Query article list error: " . mysqli_error($db_conn);
214    
215     mysqli_close($db_conn);
216     exit(json_encode($result_set));
217     }
218    
219     $visited_aid_list = array();
220    
221     if ($_SESSION["BBS_uid"] > 0)
222     {
223     $aid_list = "-1";
224    
225     while ($row = mysqli_fetch_array($rs))
226     {
227     if ((new DateTimeImmutable("-" . $BBS_new_article_period . " day")) < (new DateTimeImmutable($row["sub_dt"])))
228     {
229     $aid_list .= (", " . $row["AID"]);
230     }
231     else
232     {
233     array_push($visited_aid_list, $row["AID"]);
234     }
235     }
236    
237     mysqli_data_seek($rs, 0);
238    
239     if ($aid_list != "-1")
240     {
241     $sql = "SELECT AID FROM view_article_log WHERE AID IN ($aid_list) AND UID = " . $_SESSION["BBS_uid"];
242    
243     $rs_view = mysqli_query($db_conn, $sql);
244     if ($rs_view == false)
245     {
246     $result_set["return"]["code"] = -2;
247     $result_set["return"]["message"] = "Query view_article_log error: " . mysqli_error($db_conn);
248    
249     mysqli_close($db_conn);
250     exit(json_encode($result_set));
251     }
252    
253     while ($row_view = mysqli_fetch_array($rs_view))
254     {
255     array_push($visited_aid_list, $row_view["AID"]);
256     }
257    
258     mysqli_free_result($rs_view);
259     }
260     }
261    
262     $author_list = array();
263    
264     while ($row = mysqli_fetch_array($rs))
265     {
266     array_push($result_set["data"]["articles"], array(
267     "aid" => $row["AID"],
268     "tid" => $row["TID"],
269     "title" => $row["title"],
270     "sub_dt" => (new DateTimeImmutable($row["sub_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
271     "length" => $row["length"],
272     "icon" => $row["icon"],
273     "uid" => $row["UID"],
274     "username" => $row["username"],
275     "nickname" => $row["nickname"],
276     "reply_count" => $row["reply_count"],
277     "view_count" => $row["view_count"],
278     "transship" => $row["transship"],
279     "lock" => $row["lock"],
280     "ontop" => $row["ontop"],
281     "excerption" => $row["excerption"],
282     "gen_ex" => $row["gen_ex"],
283     "last_reply_dt" => (new DateTimeImmutable($row["last_reply_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
284     "last_reply_uid" => $row["last_reply_UID"],
285     "last_reply_username" => $row["last_reply_username"],
286     "last_reply_nickname" => $row["last_reply_nickname"],
287     "class_name" => $row["cname"],
288     "class_title" => $row["c_title"],
289     "section_name" => $row["sname"],
290     "section_title" => $row["s_title"],
291     "visited" => (($_SESSION["BBS_uid"] > 0 && ($row["UID"] == $_SESSION["BBS_uid"] || in_array($row["AID"], $visited_aid_list))) ? 1 : 0),
292     ));
293    
294     if (!isset($author_list[$row["UID"]]))
295     {
296     $author_list[$row["UID"]] = true;
297     }
298     if (!isset($author_list[$row["last_reply_UID"]]))
299     {
300     $author_list[$row["last_reply_UID"]] = true;
301     }
302     }
303     mysqli_free_result($rs);
304    
305     $uid_list = "-1";
306     foreach ($author_list as $uid => $status)
307     {
308     $uid_list .= (", " . $uid);
309     }
310     unset($author_list);
311    
312     $author_list = array();
313    
314     $sql = "SELECT UID FROM user_list WHERE UID IN ($uid_list) AND enable";
315    
316     $rs = mysqli_query($db_conn, $sql);
317     if ($rs == false)
318     {
319     $result_set["return"]["code"] = -2;
320     $result_set["return"]["message"] = "Query user list error: " . mysqli_error($db_conn);
321    
322     mysqli_close($db_conn);
323     exit(json_encode($result_set));
324     }
325    
326     while ($row = mysqli_fetch_array($rs))
327     {
328     $author_list[$row["UID"]] = true;
329     }
330     mysqli_free_result($rs);
331    
332     $result_set["data"]["author_list"] = $author_list;
333     unset($author_list);
334    
335     mysqli_close($db_conn);
336    
337     // Cleanup
338     unset($uid);
339     unset($sid);
340     unset($ex);
341     unset($reply);
342     unset($use_nick);
343     unset($original);
344     unset($username);
345     unset($nickname);
346     unset($title);
347     unset($content);
348     unset($begin_dt);
349     unset($end_dt);
350     unset($search_topic);
351     unset($toa);
352     unset($page);
353     unset($rpp);
354     unset($page_total);
355    
356     // Output with theme view
357     $theme_view_file = get_theme_file("view/search_article", $_SESSION["BBS_theme_name"]);
358     if ($theme_view_file == null)
359     {
360     exit(json_encode($result_set)); // Output data in Json
361     }
362     include $theme_view_file;

webmaster@leafok.com
ViewVC Help
Powered by ViewVC 1.3.0-beta1