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 = "-1";

        if ($solr_obj->response->docs !== false)
        {
                foreach ($solr_obj->response->docs as $doc)
                {
                        $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 ($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 = "-1";

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

                mysqli_data_seek($rs, 0);

                if ($aid_list != "-1")
                {
                        $sql = "SELECT AID FROM view_article_log WHERE AID IN ($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 = "-1";
        foreach ($author_list as $uid => $status)
        {
                $uid_list .= (", " . $uid);
        }
        unset($author_list);

        $author_list = array();

        $sql = "SELECT UID FROM user_list WHERE UID IN ($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			$aid_list = "-1";
155
156			if ($solr_obj->response->docs !== false)
157			{
158			foreach ($solr_obj->response->docs as $doc)
159			{
160			$aid_list .= (", " . $doc["ArticleId"]);
161			}
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			" WHERE bbs.AID in ($aid_list)" .
174			" ORDER BY sub_dt DESC";
175
176			$rs = mysqli_query($db_conn, $sql);
177			if ($rs == false)
178			{
179			$result_set["return"]["code"] = -2;
180			$result_set["return"]["message"] = "Query article list error: " . mysqli_error($db_conn);
181
182			mysqli_close($db_conn);
183			exit(json_encode($result_set));
184			}
185
186			$visited_aid_list = array();
187
188			if ($_SESSION["BBS_uid"] > 0)
189			{
190			$aid_list = "-1";
191
192			while ($row = mysqli_fetch_array($rs))
193			{
194			if ((new DateTimeImmutable("-" . $BBS_new_article_period . " day")) < (new DateTimeImmutable($row["sub_dt"])))
195			{
196			$aid_list .= (", " . $row["AID"]);
197			}
198			else
199			{
200			array_push($visited_aid_list, $row["AID"]);
201			}
202			}
203
204			mysqli_data_seek($rs, 0);
205
206			if ($aid_list != "-1")
207			{
208			$sql = "SELECT AID FROM view_article_log WHERE AID IN ($aid_list) AND UID = " . $_SESSION["BBS_uid"];
209
210			$rs_view = mysqli_query($db_conn, $sql);
211			if ($rs_view == false)
212			{
213			$result_set["return"]["code"] = -2;
214			$result_set["return"]["message"] = "Query view_article_log error: " . mysqli_error($db_conn);
215
216			mysqli_close($db_conn);
217			exit(json_encode($result_set));
218			}
219
220			while ($row_view = mysqli_fetch_array($rs_view))
221			{
222			array_push($visited_aid_list, $row_view["AID"]);
223			}
224
225			mysqli_free_result($rs_view);
226			}
227			}
228
229			$author_list = array();
230
231			while ($row = mysqli_fetch_array($rs))
232			{
233			array_push($result_set["data"]["articles"], array(
234			"aid" => $row["AID"],
235			"tid" => $row["TID"],
236			"title" => $row["title"],
237			"sub_dt" => (new DateTimeImmutable($row["sub_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
238			"length" => $row["length"],
239			"icon" => $row["icon"],
240			"uid" => $row["UID"],
241			"username" => $row["username"],
242			"nickname" => $row["nickname"],
243			"reply_count" => $row["reply_count"],
244			"view_count" => $row["view_count"],
245			"transship" => $row["transship"],
246			"lock" => $row["lock"],
247			"ontop" => $row["ontop"],
248			"excerption" => $row["excerption"],
249			"gen_ex" => $row["gen_ex"],
250			"last_reply_dt" => (new DateTimeImmutable($row["last_reply_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
251			"last_reply_uid" => $row["last_reply_UID"],
252			"last_reply_username" => $row["last_reply_username"],
253			"last_reply_nickname" => $row["last_reply_nickname"],
254			"class_name" => $row["cname"],
255			"class_title" => $row["c_title"],
256			"section_name" => $row["sname"],
257			"section_title" => $row["s_title"],
258			"visited" => (($_SESSION["BBS_uid"] > 0 && ($row["UID"] == $_SESSION["BBS_uid"] \|\| in_array($row["AID"], $visited_aid_list))) ? 1 : 0),
259			));
260
261			if (!isset($author_list[$row["UID"]]))
262			{
263			$author_list[$row["UID"]] = true;
264			}
265			if (!isset($author_list[$row["last_reply_UID"]]))
266			{
267			$author_list[$row["last_reply_UID"]] = true;
268			}
269			}
270			mysqli_free_result($rs);
271
272			$uid_list = "-1";
273			foreach ($author_list as $uid => $status)
274			{
275			$uid_list .= (", " . $uid);
276			}
277			unset($author_list);
278
279			$author_list = array();
280
281			$sql = "SELECT UID FROM user_list WHERE UID IN ($uid_list) AND enable";
282
283			$rs = mysqli_query($db_conn, $sql);
284			if ($rs == false)
285			{
286			$result_set["return"]["code"] = -2;
287			$result_set["return"]["message"] = "Query user list error: " . mysqli_error($db_conn);
288
289			mysqli_close($db_conn);
290			exit(json_encode($result_set));
291			}
292
293			while ($row = mysqli_fetch_array($rs))
294			{
295			$author_list[$row["UID"]] = true;
296			}
297			mysqli_free_result($rs);
298
299			$result_set["data"]["author_list"] = $author_list;
300			unset($author_list);
301
302			mysqli_close($db_conn);
303
304			// Cleanup
305			unset($uid);
306			unset($sid);
307			unset($ex);
308			unset($reply);
309			unset($use_nick);
310			unset($original);
311			unset($username);
312			unset($nickname);
313			unset($title);
314			unset($content);
315			unset($begin_dt);
316			unset($end_dt);
317			unset($search_topic);
318			unset($toa);
319			unset($page);
320			unset($rpp);
321			unset($page_total);
322
323			// Output with theme view
324			$theme_view_file = get_theme_file("view/search_article", $_SESSION["BBS_theme_name"]);
325			if ($theme_view_file == null)
326			{
327			exit(json_encode($result_set)); // Output data in Json
328			}
329			include $theme_view_file;
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1