Manage.php 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206
  1. <?php
  2. namespace Content\Lib;
  3. use Dever;
  4. class Manage
  5. {
  6. private function search($table = 'content/news', $type = false)
  7. {
  8. $keyword = Dever::input('keyword');
  9. $yes = Dever::input('yes');
  10. $where = array();
  11. if ($type) {
  12. $where['type'] = $type;
  13. }
  14. if ($yes) {
  15. $yes = Dever::db($table)->search(array('ids' => $yes));
  16. }
  17. if (!$keyword) {
  18. $where['limit'] = '0,50';
  19. $data = Dever::db($table)->search($where);
  20. } else {
  21. $where['name'] = $keyword;
  22. $data = Dever::db($table)->search($where);
  23. }
  24. $result = array();
  25. if ($yes) {
  26. foreach ($yes as $k => $v) {
  27. if (isset($data[$k])) {
  28. unset($data[$k]);
  29. }
  30. $yes[$k]['selected'] = 'selected';
  31. }
  32. $data = $yes + $data;
  33. $data = array_merge($data, array());
  34. } else {
  35. $data = array_merge($data, array());
  36. }
  37. if (!$data) {
  38. Dever::alert('暂无数据');
  39. }
  40. return $data;
  41. }
  42. # 搜索文章
  43. public function search_news_api()
  44. {
  45. return $this->search('content/news', 1);
  46. }
  47. # 搜索专题
  48. public function search_feature_api()
  49. {
  50. return $this->search('content/news', 2);
  51. }
  52. # 搜索视频
  53. public function search_video_api()
  54. {
  55. return $this->search('content/news', 3);
  56. }
  57. # 搜索活动
  58. public function search_act_api()
  59. {
  60. return $this->search('content/news', 4);
  61. }
  62. # 搜索造物主
  63. public function search_creater_api()
  64. {
  65. return $this->search('content/creater');
  66. }
  67. # 搜索虚拟人
  68. public function search_xuniren_api()
  69. {
  70. return $this->search('content/xuniren');
  71. }
  72. public function updateCreater($id, $name, $data)
  73. {
  74. $name = Dever::param('name', $data);
  75. if ($name) {
  76. $pinyin = new zh2py();
  77. $shou = $pinyin::conv($name);
  78. $shou = strtolower(substr($shou, 0, 1));
  79. $update['shou'] = $shou;
  80. $update['where_id'] = $id;
  81. Dever::db('content/creater')->update($update);
  82. }
  83. }
  84. public function updateXnr($id, $name, $data)
  85. {
  86. $ename = Dever::param('ename', $data);
  87. if ($ename) {
  88. $shou = strtolower(substr($ename, 0, 1));
  89. $update['shou'] = $shou;
  90. $update['where_id'] = $id;
  91. Dever::db('content/xuniren')->update($update);
  92. }
  93. }
  94. }
  95. class zh2py
  96. {
  97. //根据汉字区位表,(http://www.mytju.com/classcode/tools/QuWeiMa_FullList.asp)
  98. //我们可以看到从16-55区之间是按拼音字母排序的,所以我们只需要判断某个汉字的区位码就可以得知它的拼音首字母.
  99. //区位表第一部份,按拼音字母排序的.
  100. //16区-55区
  101. /*
  102. 'A'=>0xB0A1, 'B'=>0xB0C5, 'C'=>0xB2C1, 'D'=>0xB4EE, 'E'=>0xB6EA, 'F'=>0xB7A2, 'G'=>0xB8C1,'H'=>0xB9FE,
  103. 'J'=>0xBBF7, 'K'=>0xBFA6, 'L'=>0xC0AC, 'M'=>0xC2E8, 'N'=>0xC4C3, 'O'=>0xC5B6, 'P'=>0xC5BE,'Q'=>0xC6DA,
  104. 'R'=>0xC8BB, 'S'=>0xC8F6, 'T'=>0xCBFA, 'W'=>0xCDDA, 'X'=>0xCEF4, 'Y'=>0xD1B9, 'Z'=>0xD4D1
  105. */
  106. private static $FirstTable = array(
  107. 0xB0C5, 0xB2C1, 0xB4EE, 0xB6EA, 0xB7A2, 0xB8C1, 0xB9FE, 0xBBF7, 0xBFA6, 0xC0AC, 0xC2E8,
  108. 0xC4C3, 0xC5B6, 0xC5BE, 0xC6DA, 0xC8BB, 0xC8F6, 0xCBFA, 0xCDDA, 0xCEF4, 0xD1B9, 0xD4D1,0xD7FA
  109. );
  110. private static $FirstLetter = "ABCDEFGHJKLMNOPQRSTWXYZ";
  111. //区位表第二部份,不规则的,下面的字母是每个区里面对应字的拼音首字母.从网上查询整理出来的,可能会有部份错误.
  112. //56区-87区
  113. private static $SecondTable = array(
  114. "CJWGNSPGCGNEGYPBTYYZDXYKYGTZJNMJQMBSGZSCYJSYYFPGKBZGYDYWJKGKLJSWKPJQHYJWRDZLSYMRYPYWWCCKZNKYYG",
  115. "TTNGJEYKKZYTCJNMCYLQLYPYSFQRPZSLWBTGKJFYXJWZLTBNCXJJJJTXDTTSQZYCDXXHGCKBPHFFSSTYBGMXLPBYLLBHLX",
  116. "SMZMYJHSOJNGHDZQYKLGJHSGQZHXQGKXZZWYSCSCJXYEYXADZPMDSSMZJZQJYZCJJFWQJBDZBXGZNZCPWHWXHQKMWFBPBY",
  117. "DTJZZKXHYLYGXFPTYJYYZPSZLFCHMQSHGMXXSXJYQDCSBBQBEFSJYHWWGZKPYLQBGLDLCDTNMAYDDKSSNGYCSGXLYZAYPN",
  118. "PTSDKDYLHGYMYLCXPYCJNDQJWXQXFYYFJLEJPZRXCCQWQQSBZKYMGPLBMJRQCFLNYMYQMSQYRBCJTHZTQFRXQHXMQJCJLY",
  119. "QGJMSHZKBSWYEMYLTXFSYDXWLYCJQXSJNQBSCTYHBFTDCYZDJWYGHQFRXWCKQKXEBPTLPXJZSRMEBWHJLBJSLYYSMDXLCL",
  120. "QKXLHXJRZJMFQHXHWYWSBHTRXXGLHQHFNMGYKLDYXZPYLGGSMTCFBAJJZYLJTYANJGBJPLQGSZYQYAXBKYSECJSZNSLYZH",
  121. "ZXLZCGHPXZHZNYTDSBCJKDLZAYFFYDLEBBGQYZKXGLDNDNYSKJSHDLYXBCGHXYPKDJMMZNGMMCLGWZSZXZJFZNMLZZTHCS",
  122. "YDBDLLSCDDNLKJYKJSYCJLKWHQASDKNHCSGAGHDAASHTCPLCPQYBSZMPJLPCJOQLCDHJJYSPRCHNWJNLHLYYQYYWZPTCZG",
  123. "WWMZFFJQQQQYXACLBHKDJXDGMMYDJXZLLSYGXGKJRYWZWYCLZMSSJZLDBYDCFCXYHLXCHYZJQSQQAGMNYXPFRKSSBJLYXY",
  124. "SYGLNSCMHCWWMNZJJLXXHCHSYZSTTXRYCYXBYHCSMXJSZNPWGPXXTAYBGAJCXLYXDCCWZOCWKCCSBNHCPDYZNFCYYTYCKX",
  125. "KYBSQKKYTQQXFCMCHCYKELZQBSQYJQCCLMTHSYWHMKTLKJLYCXWHEQQHTQKZPQSQSCFYMMDMGBWHWLGSLLYSDLMLXPTHMJ",
  126. "HWLJZYHZJXKTXJLHXRSWLWZJCBXMHZQXSDZPSGFCSGLSXYMJSHXPJXWMYQKSMYPLRTHBXFTPMHYXLCHLHLZYLXGSSSSTCL",
  127. "SLDCLRPBHZHXYYFHBMGDMYCNQQWLQHJJCYWJZYEJJDHPBLQXTQKWHLCHQXAGTLXLJXMSLJHTZKZJECXJCJNMFBYCSFYWYB",
  128. "JZGNYSDZSQYRSLJPCLPWXSDWEJBJCBCNAYTWGMPAPCLYQPCLZXSBNMSGGFNZJJBZSFZYNTXHPLQKZCZWALSBCZJXSYZGWK",
  129. "YPSGXFZFCDKHJGXTLQFSGDSLQWZKXTMHSBGZMJZRGLYJBPMLMSXLZJQQHZYJCZYDJWFMJKLDDPMJEGXYHYLXHLQYQHKYCW",
  130. "CJMYYXNATJHYCCXZPCQLBZWWYTWBQCMLPMYRJCCCXFPZNZZLJPLXXYZTZLGDLTCKLYRZZGQTTJHHHJLJAXFGFJZSLCFDQZ",
  131. "LCLGJDJZSNZLLJPJQDCCLCJXMYZFTSXGCGSBRZXJQQCTZHGYQTJQQLZXJYLYLBCYAMCSTYLPDJBYREGKLZYZHLYSZQLZNW",
  132. "CZCLLWJQJJJKDGJZOLBBZPPGLGHTGZXYGHZMYCNQSYCYHBHGXKAMTXYXNBSKYZZGJZLQJTFCJXDYGJQJJPMGWGJJJPKQSB",
  133. "GBMMCJSSCLPQPDXCDYYKYPCJDDYYGYWRHJRTGZNYQLDKLJSZZGZQZJGDYKSHPZMTLCPWNJYFYZDJCNMWESCYGLBTZZGMSS",
  134. "LLYXYSXXBSJSBBSGGHFJLYPMZJNLYYWDQSHZXTYYWHMCYHYWDBXBTLMSYYYFSXJCBDXXLHJHFSSXZQHFZMZCZTQCXZXRTT",
  135. "DJHNRYZQQMTQDMMGNYDXMJGDXCDYZBFFALLZTDLTFXMXQZDNGWQDBDCZJDXBZGSQQDDJCMBKZFFXMKDMDSYYSZCMLJDSYN",
  136. "SPRSKMKMPCKLGTBQTFZSWTFGGLYPLLJZHGJJGYPZLTCSMCNBTJBQFKDHBYZGKPBBYMTDSSXTBNPDKLEYCJNYCDYKZTDHQH",
  137. "SYZSCTARLLTKZLGECLLKJLQJAQNBDKKGHPJTZQKSECSHALQFMMGJNLYJBBTMLYZXDXJPLDLPCQDHZYCBZSCZBZMSLJFLKR",
  138. "ZJSNFRGJHXPDHYJYBZGDLQCSEZGXLBLGYXTWMABCHECMWYJYZLLJJYHLGNDJLSLYGKDZPZXJYYZLWCXSZFGWYYDLYHCLJS",
  139. "CMBJHBLYZLYCBLYDPDQYSXQZBYTDKYXJYYCNRJMPDJGKLCLJBCTBJDDBBLBLCZQRPYXJCJLZCSHLTOLJNMDDDLNGKATHQH",
  140. "JHYKHEZNMSHRPHQQJCHGMFPRXHJGDYCHGHLYRZQLCYQJNZSQTKQJYMSZSWLCFQQQXYFGGYPTQWLMCRNFKKFSYYLQBMQAMM",
  141. "MYXCTPSHCPTXXZZSMPHPSHMCLMLDQFYQXSZYJDJJZZHQPDSZGLSTJBCKBXYQZJSGPSXQZQZRQTBDKYXZKHHGFLBCSMDLDG",
  142. "DZDBLZYYCXNNCSYBZBFGLZZXSWMSCCMQNJQSBDQSJTXXMBLTXZCLZSHZCXRQJGJYLXZFJPHYMZQQYDFQJJLZZNZJCDGZYG",
  143. "CTXMZYSCTLKPHTXHTLBJXJLXSCDQXCBBTJFQZFSLTJBTKQBXXJJLJCHCZDBZJDCZJDCPRNPQCJPFCZLCLZXZDMXMPHJSGZ",
  144. "GSZZQLYLWTJPFSYASMCJBTZYYCWMYTZSJJLJCQLWZMALBXYFBPNLSFHTGJWEJJXXGLLJSTGSHJQLZFKCGNNNSZFDEQFHBS",
  145. "AQTGYLBXMMYGSZLDYDQMJJRGBJTKGDHGKBLQKBDMBYLXWCXYTTYBKMRTJZXQJBHLMHMJJZMQASLDCYXYQDLQCAFYWYXQHZ",
  146. );
  147. function utf8_to_gbk($string)//编码转换,必须转换成GB2312字符,这里只是简单的判断并不是很准确,可以自己写一个.
  148. {
  149. return mb_convert_encoding($string,'gb2312','utf-8');
  150. }
  151. function conv($str)
  152. {
  153. $str = self::utf8_to_gbk($str);
  154. $len = strlen($str);
  155. $newStr = '';
  156. for($i=0; $i<$len ; ++$i)
  157. {
  158. $H = ord($str[$i]);
  159. $L = ord($str[$i+1]);
  160. //字符集非法
  161. if ($H < 0xB0 || $L < 0xA1 || $H > 0xF7 || $L == 0xFF)
  162. {
  163. $newStr .= $str[$i];
  164. continue;
  165. }
  166. if ($H < 0xD8)//($H >= 0xB0 && $H <=0xD7)//查询文字在一级汉字区(16-55)
  167. {
  168. $W = ($H << 8) | $L;
  169. foreach(self::$FirstTable as $key=>$value)
  170. {
  171. if ($W < $value)
  172. {
  173. $newStr .= self::$FirstLetter[$key];
  174. break;
  175. }
  176. }
  177. }
  178. else// if (H >= 0xD8 && H <= 0xF7)//查询中文在二级汉字区(56-87)
  179. $newStr .=self::$SecondTable[$H - 0xD8][$L-0xA1];
  180. ++$i;
  181. }
  182. return $newStr;
  183. }
  184. }