fenglin/bbs/search_article_v2.php

<?php
        require_once "../lib/db_open.inc.php";
        require_once "../conf/solr.conf.php";
        require_once "./session_init.inc.php";
        require_once "./theme.inc.php";

        force_login();

        $result_set = array(
                "return" => array(
                        "code" => 0,
                        "message" => "",
                        "errorFields" => array(),
                )
        );

        $uid = (isset($_GET["uid"]) ? intval($_GET["uid"]) : 0);
        $username = (isset($_GET["username"]) ? trim($_GET["username"]) : "");
        $nickname = (isset($_GET["nickname"]) ? trim($_GET["nickname"]) : "");
        $title = (isset($_GET["title"]) ? trim($_GET["title"]) : "");
        $content = (isset($_GET["content"]) ? trim($_GET["content"]) : "");

        if (!isset($_GET["begin_dt"]) || ($begin_dt = DateTimeImmutable::createFromFormat("Y-m-d", $_GET["begin_dt"], $_SESSION["BBS_user_tz"])) == false)
        {
                $begin_dt = new DateTimeImmutable("-1 month", $_SESSION["BBS_user_tz"]);
        }
        if (!isset($_GET["end_dt"]) || ($end_dt = DateTimeImmutable::createFromFormat("Y-m-d", $_GET["end_dt"], $_SESSION["BBS_user_tz"])) == false)
        {
                $end_dt = new DateTimeImmutable("1 day", $_SESSION["BBS_user_tz"]);
        }

        $sid = (isset($_GET["sid"]) ? intval($_GET["sid"]) : 0);
        $ex = (isset($_GET["ex"]) && $_GET["ex"] == "1" ? 1 : 0);
        $reply = (isset($_GET["reply"]) && $_GET["reply"] == "1" ? 1 : 0);
        $use_nick = (isset($_GET["use_nick"]) && $_GET["use_nick"] == "1" ? 1 : 0);
        $original = (isset($_GET["original"]) && $_GET["original"] == "1" ? 1 : 0);
        $page = (isset($_GET["page"]) ? intval($_GET["page"]) : 1);
        $rpp = (isset($_GET["rpp"]) ? intval($_GET["rpp"]) : 10);

        $sid_list = "(-1)";
        if ($sid > 0)
        {
                if ($_SESSION["BBS_priv"]->checkpriv($sid, S_LIST))
                {
                        $sid_list = $sid;
                }
        }
        else
        {
                $rs = mysqli_query($db_conn, "SELECT SID FROM section_config WHERE enable" .
                        ($sid < 0 ? " AND CID = " . (-$sid) : ""));
                if ($rs == false)
                {
                        $result_set["return"]["code"] = -2;
                        $result_set["return"]["message"] = "Query section error: " . mysqli_error($db_conn);

                        mysqli_close($db_conn);
                        exit(json_encode($result_set));
                }

                while ($row = mysqli_fetch_array($rs))
                {
                        if ($_SESSION["BBS_priv"]->checkpriv($row["SID"], S_LIST))
                        {
                                $sid_list .= (" OR " . $row["SID"]);
                        }
                }
                mysqli_free_result($rs);
        }

        if (!in_array($rpp, $BBS_list_rpp_options))
        {
                $rpp = $BBS_list_rpp_options[0];
        }

        if ($page <= 0)
        {
                $page = 1;
        }

        // Initialize Solr client
        $solr_client = new SolrClient($solr_options);

        $query_str = "" .
                ($sid_list == "(-1)" ? "" : "SectionId:($sid_list) AND ") .
                ($reply ? "" : "TopicId:0 AND ") .
                ($uid == 0 ? "" : "PostUserId:($uid) AND ") .
                ($username == "" ? "" : "PostUserName:($username) AND ") .
                ($nickname == "" ? "" : "PostUserNickName:($nickname) AND ") .
                ($ex == 1 ? "Excerption:1 AND " : "") .
                ($original ? "Transship:0 AND " : "") .
                "PostDateTime:[" . $begin_dt->setTimezone(new DateTimeZone("UTC"))->format("Y-m-d\T00:00:00\Z") . " TO " .
                        $end_dt->setTimezone(new DateTimeZone("UTC"))->format("Y-m-d\T23:59:59\Z") . "] AND " .
                ($title == "" ? "" : "ArticleTitle:($title) AND ") .
                ($content == "" ? "" : "Content:($content) AND ") .
                "*:*";

        // Query count of articles
        $solr_query = new SolrQuery();
        $solr_query->setQuery($query_str);
        $solr_query->addField("ArticleId");
        $solr_query->addSortField("PostDateTime", SolrQuery::ORDER_DESC);
        $solr_query->setStart(($page - 1) * $rpp);
        $solr_query->setRows($rpp);
        try
        {
                $solr_res = $solr_client->query($solr_query);
        }
        catch (Exception $e)
        {
                $result_set["return"]["code"] = -3;
                $result_set["return"]["message"] = "Solr query error";

                exit(json_encode($result_set));
        }
        $solr_obj = $solr_res->getResponse();

        if ($solr_obj->responseHeader->status != 0)
        {
                $result_set["return"]["code"] = -3;
                $result_set["return"]["message"] = "Solr query error: " . $solr_obj->responseHeader->status;

                exit(json_encode($result_set));
        }

        $toa = $solr_obj->response->numFound;

        $page_total = ceil($toa / $rpp);

        // Fill up result data
        $result_set["data"] = array(
                "uid" => $uid,
                "sid" => $sid,
                "ex" => $ex,
                "reply" => $reply,
                "use_nick" => $use_nick,
                "original" => $original,
                "username" => $username,
                "nickname" => $nickname,
                "title" => $title,
                "content" => $content,
                "begin_dt" => $begin_dt,
                "end_dt" => $end_dt,
                "favorite" => 0,
                "trash" => 0,
                "toa" => $toa,
                "page" => $page,
                "rpp" => $rpp,
                "page_total" => $page_total,

                "articles" => array(),
        );

        $aid_list = array(-1);

        if ($solr_obj->response->docs !== false)
        {
                foreach ($solr_obj->response->docs as $doc)
                {
                        array_push($aid_list, $doc["ArticleId"]);
                }
        }

        unset($solr_res);
        unset($solr_query);
        unset($solr_client);

        // Query articles
        $sql = "SELECT bbs.*, section_class.cname, section_class.title AS c_title,
                section_config.sname, section_config.title AS s_title FROM bbs
                INNER JOIN section_config ON bbs.SID = section_config.SID
                INNER JOIN section_class ON section_config.CID = section_class.CID" .
                " WHERE bbs.AID in (" .
                implode(",", $aid_list) .
                ") ORDER BY sub_dt DESC";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Query article list error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        $visited_aid_list = array();

        if ($_SESSION["BBS_uid"] > 0)
        {
                $aid_list = array(-1);

                while ($row = mysqli_fetch_array($rs))
                {
                        if ((new DateTimeImmutable("-" . $BBS_new_article_period . " day")) < (new DateTimeImmutable($row["sub_dt"])))
                        {
                                array_push($aid_list, $row["AID"]);
                        }
                        else
                        {
                                array_push($visited_aid_list, $row["AID"]);
                        }
                }

                mysqli_data_seek($rs, 0);

                if (count($aid_list) > 1)
                {
                        $sql = "SELECT AID FROM view_article_log WHERE AID IN (" .
                                        implode(",", $aid_list) .
                                        ") AND UID = " . $_SESSION["BBS_uid"];

                        $rs_view = mysqli_query($db_conn, $sql);
                        if ($rs_view == false)
                        {
                                $result_set["return"]["code"] = -2;
                                $result_set["return"]["message"] = "Query view_article_log error: " . mysqli_error($db_conn);

                                mysqli_close($db_conn);
                                exit(json_encode($result_set));
                        }

                        while ($row_view = mysqli_fetch_array($rs_view))
                        {
                                array_push($visited_aid_list, $row_view["AID"]);
                        }

                        mysqli_free_result($rs_view);
                }
        }

        $author_list = array();

        while ($row = mysqli_fetch_array($rs))
        {
                array_push($result_set["data"]["articles"], array(
                        "aid" => $row["AID"],
                        "tid" => $row["TID"],
                        "title" => $row["title"],
                        "sub_dt" => (new DateTimeImmutable($row["sub_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
                        "length" => $row["length"],
                        "icon" => $row["icon"],
                        "uid" => $row["UID"],
                        "username" => $row["username"],
                        "nickname" => $row["nickname"],
                        "reply_count" => $row["reply_count"],
                        "view_count" => $row["view_count"],
                        "transship" => $row["transship"],
                        "lock" => $row["lock"],
                        "ontop" => $row["ontop"],
                        "excerption" => $row["excerption"],
                        "gen_ex" => $row["gen_ex"],
                        "last_reply_dt" => (new DateTimeImmutable($row["last_reply_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
                        "last_reply_uid" => $row["last_reply_UID"],
                        "last_reply_username" => $row["last_reply_username"],
                        "last_reply_nickname" => $row["last_reply_nickname"],
                        "class_name" => $row["cname"],
                        "class_title" => $row["c_title"],
                        "section_name" => $row["sname"],
                        "section_title" => $row["s_title"],
                        "visited" => (($_SESSION["BBS_uid"] > 0 && ($row["UID"] == $_SESSION["BBS_uid"] || in_array($row["AID"], $visited_aid_list))) ? 1 : 0),
                ));

                if (!isset($author_list[$row["UID"]]))
                {
                        $author_list[$row["UID"]] = true;
                }
                if (!isset($author_list[$row["last_reply_UID"]]))
                {
                        $author_list[$row["last_reply_UID"]] = true;
                }
        }
        mysqli_free_result($rs);

        $uid_list = array(-1);
        foreach ($author_list as $uid => $status)
        {
                array_push($uid_list, $uid);
        }
        unset($author_list);

        $author_list = array();

        $sql = "SELECT UID FROM user_list WHERE UID IN (" .
                        implode(",", $uid_list) .
                        ") AND enable";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Query user list error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        while ($row = mysqli_fetch_array($rs))
        {
                $author_list[$row["UID"]] = true;
        }
        mysqli_free_result($rs);

        $result_set["data"]["author_list"] = $author_list;
        unset($author_list);

        mysqli_close($db_conn);

        // Cleanup
        unset($uid);
        unset($sid);
        unset($ex);
        unset($reply);
        unset($use_nick);
        unset($original);
        unset($username);
        unset($nickname);
        unset($title);
        unset($content);
        unset($begin_dt);
        unset($end_dt);
        unset($search_topic);
        unset($toa);
        unset($page);
        unset($rpp);
        unset($page_total);

        // Output with theme view
        $theme_view_file = get_theme_file("view/search_article", $_SESSION["BBS_theme_name"]);
        if ($theme_view_file == null)
        {
                exit(json_encode($result_set)); // Output data in Json
        }
        include $theme_view_file;
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	sysadm	1.5	if (!in_array($rpp, $BBS_list_rpp_options))
72			{
73			$rpp = $BBS_list_rpp_options[0];
74			}
75
76			if ($page <= 0)
77			{
78			$page = 1;
79			}
80
81	sysadm	1.1	// Initialize Solr client
82			$solr_client = new SolrClient($solr_options);
83
84			$query_str = "" .
85			($sid_list == "(-1)" ? "" : "SectionId:($sid_list) AND ") .
86			($reply ? "" : "TopicId:0 AND ") .
87	sysadm	1.4	($uid == 0 ? "" : "PostUserId:($uid) AND ") .
88	sysadm	1.1	($username == "" ? "" : "PostUserName:($username) AND ") .
89			($nickname == "" ? "" : "PostUserNickName:($nickname) AND ") .
90			($ex == 1 ? "Excerption:1 AND " : "") .
91	sysadm	1.3	($original ? "Transship:0 AND " : "") .
92	sysadm	1.1	"PostDateTime:[" . $begin_dt->setTimezone(new DateTimeZone("UTC"))->format("Y-m-d\T00:00:00\Z") . " TO " .
93			$end_dt->setTimezone(new DateTimeZone("UTC"))->format("Y-m-d\T23:59:59\Z") . "] AND " .
94			($title == "" ? "" : "ArticleTitle:($title) AND ") .
95			($content == "" ? "" : "Content:($content) AND ") .
96			":";
97
98			// Query count of articles
99			$solr_query = new SolrQuery();
100			$solr_query->setQuery($query_str);
101			$solr_query->addField("ArticleId");
102			$solr_query->addSortField("PostDateTime", SolrQuery::ORDER_DESC);
103	sysadm	1.5	$solr_query->setStart(($page - 1) * $rpp);
104			$solr_query->setRows($rpp);
105	sysadm	1.1	try
106			{
107			$solr_res = $solr_client->query($solr_query);
108			}
109			catch (Exception $e)
110			{
111			$result_set["return"]["code"] = -3;
112			$result_set["return"]["message"] = "Solr query error";
113
114			exit(json_encode($result_set));
115			}
116			$solr_obj = $solr_res->getResponse();
117
118			if ($solr_obj->responseHeader->status != 0)
119			{
120			$result_set["return"]["code"] = -3;
121			$result_set["return"]["message"] = "Solr query error: " . $solr_obj->responseHeader->status;
122
123			exit(json_encode($result_set));
124			}
125
126			$toa = $solr_obj->response->numFound;
127
128			$page_total = ceil($toa / $rpp);
129
130			// Fill up result data
131			$result_set["data"] = array(
132			"uid" => $uid,
133			"sid" => $sid,
134			"ex" => $ex,
135			"reply" => $reply,
136			"use_nick" => $use_nick,
137			"original" => $original,
138			"username" => $username,
139			"nickname" => $nickname,
140			"title" => $title,
141			"content" => $content,
142			"begin_dt" => $begin_dt,
143			"end_dt" => $end_dt,
144			"favorite" => 0,
145			"trash" => 0,
146			"toa" => $toa,
147			"page" => $page,
148			"rpp" => $rpp,
149			"page_total" => $page_total,
150
151			"articles" => array(),
152			);
153
154	sysadm	1.6	$aid_list = array(-1);
155	sysadm	1.1
156			if ($solr_obj->response->docs !== false)
157			{
158			foreach ($solr_obj->response->docs as $doc)
159			{
160	sysadm	1.6	array_push($aid_list, $doc["ArticleId"]);
161	sysadm	1.1	}
162			}
163
164	sysadm	1.5	unset($solr_res);
165	sysadm	1.1	unset($solr_query);
166			unset($solr_client);
167
168			// Query articles
169			$sql = "SELECT bbs.*, section_class.cname, section_class.title AS c_title,
170			section_config.sname, section_config.title AS s_title FROM bbs
171			INNER JOIN section_config ON bbs.SID = section_config.SID
172			INNER JOIN section_class ON section_config.CID = section_class.CID" .
173	sysadm	1.6	" WHERE bbs.AID in (" .
174			implode(",", $aid_list) .
175			") ORDER BY sub_dt DESC";
176	sysadm	1.1
177			$rs = mysqli_query($db_conn, $sql);
178			if ($rs == false)
179			{
180			$result_set["return"]["code"] = -2;
181			$result_set["return"]["message"] = "Query article list error: " . mysqli_error($db_conn);
182
183			mysqli_close($db_conn);
184			exit(json_encode($result_set));
185			}
186
187			$visited_aid_list = array();
188
189			if ($_SESSION["BBS_uid"] > 0)
190			{
191	sysadm	1.6	$aid_list = array(-1);
192	sysadm	1.1
193			while ($row = mysqli_fetch_array($rs))
194			{
195			if ((new DateTimeImmutable("-" . $BBS_new_article_period . " day")) < (new DateTimeImmutable($row["sub_dt"])))
196			{
197	sysadm	1.6	array_push($aid_list, $row["AID"]);
198	sysadm	1.1	}
199			else
200			{
201			array_push($visited_aid_list, $row["AID"]);
202			}
203			}
204
205			mysqli_data_seek($rs, 0);
206
207	sysadm	1.6	if (count($aid_list) > 1)
208	sysadm	1.1	{
209	sysadm	1.6	$sql = "SELECT AID FROM view_article_log WHERE AID IN (" .
210			implode(",", $aid_list) .
211			") AND UID = " . $_SESSION["BBS_uid"];
212	sysadm	1.1
213			$rs_view = mysqli_query($db_conn, $sql);
214			if ($rs_view == false)
215			{
216			$result_set["return"]["code"] = -2;
217			$result_set["return"]["message"] = "Query view_article_log error: " . mysqli_error($db_conn);
218
219			mysqli_close($db_conn);
220			exit(json_encode($result_set));
221			}
222
223			while ($row_view = mysqli_fetch_array($rs_view))
224			{
225			array_push($visited_aid_list, $row_view["AID"]);
226			}
227
228			mysqli_free_result($rs_view);
229			}
230			}
231
232			$author_list = array();
233
234			while ($row = mysqli_fetch_array($rs))
235			{
236			array_push($result_set["data"]["articles"], array(
237			"aid" => $row["AID"],
238			"tid" => $row["TID"],
239			"title" => $row["title"],
240			"sub_dt" => (new DateTimeImmutable($row["sub_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
241			"length" => $row["length"],
242			"icon" => $row["icon"],
243			"uid" => $row["UID"],
244			"username" => $row["username"],
245			"nickname" => $row["nickname"],
246			"reply_count" => $row["reply_count"],
247			"view_count" => $row["view_count"],
248			"transship" => $row["transship"],
249			"lock" => $row["lock"],
250			"ontop" => $row["ontop"],
251			"excerption" => $row["excerption"],
252			"gen_ex" => $row["gen_ex"],
253			"last_reply_dt" => (new DateTimeImmutable($row["last_reply_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
254			"last_reply_uid" => $row["last_reply_UID"],
255			"last_reply_username" => $row["last_reply_username"],
256			"last_reply_nickname" => $row["last_reply_nickname"],
257			"class_name" => $row["cname"],
258			"class_title" => $row["c_title"],
259			"section_name" => $row["sname"],
260			"section_title" => $row["s_title"],
261			"visited" => (($_SESSION["BBS_uid"] > 0 && ($row["UID"] == $_SESSION["BBS_uid"] \|\| in_array($row["AID"], $visited_aid_list))) ? 1 : 0),
262			));
263
264			if (!isset($author_list[$row["UID"]]))
265			{
266			$author_list[$row["UID"]] = true;
267			}
268			if (!isset($author_list[$row["last_reply_UID"]]))
269			{
270			$author_list[$row["last_reply_UID"]] = true;
271			}
272			}
273			mysqli_free_result($rs);
274
275	sysadm	1.6	$uid_list = array(-1);
276	sysadm	1.1	foreach ($author_list as $uid => $status)
277			{
278	sysadm	1.6	array_push($uid_list, $uid);
279	sysadm	1.1	}
280			unset($author_list);
281
282			$author_list = array();
283
284	sysadm	1.6	$sql = "SELECT UID FROM user_list WHERE UID IN (" .
285			implode(",", $uid_list) .
286			") AND enable";
287	sysadm	1.1
288			$rs = mysqli_query($db_conn, $sql);
289			if ($rs == false)
290			{
291			$result_set["return"]["code"] = -2;
292			$result_set["return"]["message"] = "Query user list error: " . mysqli_error($db_conn);
293
294			mysqli_close($db_conn);
295			exit(json_encode($result_set));
296			}
297
298			while ($row = mysqli_fetch_array($rs))
299			{
300			$author_list[$row["UID"]] = true;
301			}
302			mysqli_free_result($rs);
303
304			$result_set["data"]["author_list"] = $author_list;
305			unset($author_list);
306
307			mysqli_close($db_conn);
308
309			// Cleanup
310			unset($uid);
311			unset($sid);
312			unset($ex);
313			unset($reply);
314			unset($use_nick);
315			unset($original);
316			unset($username);
317			unset($nickname);
318			unset($title);
319			unset($content);
320			unset($begin_dt);
321			unset($end_dt);
322			unset($search_topic);
323			unset($toa);
324			unset($page);
325			unset($rpp);
326			unset($page_total);
327
328			// Output with theme view
329			$theme_view_file = get_theme_file("view/search_article", $_SESSION["BBS_theme_name"]);
330			if ($theme_view_file == null)
331			{
332			exit(json_encode($result_set)); // Output data in Json
333			}
334			include $theme_view_file;
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1