[dev] [commit] r1058 - templates/admin wwwbase/admin

[automailer at dexonline.ro]

Author: cata
Date: Mon Jan 13 16:31:00 2014
New Revision: 1058

Log:
Add a lexem search box to the admin page.

Added:
   wwwbase/admin/lexemSearch.php
Modified:
   templates/admin/index.ihtml
   templates/admin/lexemList.ihtml

Modified: templates/admin/index.ihtml
==============================================================================
--- templates/admin/index.ihtml	Mon Jan 13 15:53:00 2014	(r1057)
+++ templates/admin/index.ihtml	Mon Jan 13 16:31:00 2014	(r1058)
@@ -58,6 +58,16 @@
 </form>
 <br/>
 
+<form action="lexemSearch.php" method="get">
+  Caută lexeme:
+  <input type="text" name="form" size="10" value="*">
+     
+  <input type="checkbox" id="structured" name="structured" value="1">
+  <label for="structured">structurate</label>
+  <input type="submit" name="searchButton" value="Caută">
+</form>
+<br/>
+
 {if $sUser->moderator & $smarty.const.PRIV_LOC}
   <form action="../flex/dispatchModelAction.php" method="get">
     Modelul:

Modified: templates/admin/lexemList.ihtml
==============================================================================
--- templates/admin/lexemList.ihtml	Mon Jan 13 15:53:00 2014	(r1057)
+++ templates/admin/lexemList.ihtml	Mon Jan 13 16:31:00 2014	(r1058)
@@ -1,7 +1,4 @@
 {foreach from=$lexems item=l key=row_id}
-  {strip}
-    <a href="{$wwwRoot}admin/lexemEdit.php?lexemId={$l->id}">
-      {include file="common/bits/lexemName.ihtml" lexem=$l} ({$l->modelType}{$l->modelNumber}{$l->restriction})
-    </a>
-  {/strip}
+  <a href="{$wwwRoot}admin/lexemEdit.php?lexemId={$l->id}">{include file="common/bits/lexemName.ihtml" lexem=$l}</a>
+  ({$l->modelType}{$l->modelNumber}{$l->restriction}) |
 {/foreach}    

Added: wwwbase/admin/lexemSearch.php
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ wwwbase/admin/lexemSearch.php	Mon Jan 13 16:31:00 2014	(r1058)
@@ -0,0 +1,33 @@
+<?php
+require_once("../../phplib/util.php"); 
+util_assertModerator(PRIV_EDIT);
+util_assertNotMirror();
+
+$form = util_getRequestParameter('form');
+$structured = util_getBoolean('structured');
+$searchButton = util_getRequestParameter('searchButton');
+
+if (!$searchButton) {
+  util_redirect('index.php');
+}
+
+$form = StringUtil::cleanupQuery($form);
+$arr = StringUtil::analyzeQuery($form);
+$hasDiacritics = $arr[0];
+$field = $hasDiacritics ? 'formNoAccent' : 'formUtf8General';
+$regexp = StringUtil::dexRegexpToMysqlRegexp($form);
+
+$query = "select * from Lexem where $field $regexp ";
+if ($structured) {
+  $query .= 'and id in (select distinct lexemId from Meaning)';
+}
+$query .= ' order by formNoAccent limit 500';
+$lexems = Model::factory('Lexem')->raw_query($query, null)->find_many();
+
+SmartyWrap::assign('lexems', $lexems);
+SmartyWrap::assign('sectionTitle', 'Căutare lexeme');
+SmartyWrap::assign('sectionCount', count($lexems));
+SmartyWrap::assign('recentLinks', RecentLink::loadForUser());
+SmartyWrap::displayAdminPage('admin/lexemList.ihtml');
+
+?>