{"id":1667,"date":"2017-07-25T10:36:07","date_gmt":"2017-07-25T15:36:07","guid":{"rendered":"https:\/\/xlinesoft.com\/blog\/?p=1667"},"modified":"2017-08-25T06:03:57","modified_gmt":"2017-08-25T11:03:57","slug":"using-field-events","status":"publish","type":"post","link":"https:\/\/xlinesoft.com\/blog\/2017\/07\/25\/using-field-events\/","title":{"rendered":"Using field events"},"content":{"rendered":"

We have two tables: categories and sub_categories. CategoryID is a two-digit category code.<\/p>\n

\"\"<\/a>
\n
\nIn sub_categories table SubID consists of two-digit category code and and two-digit subcategory code. <\/p>\n

\"\"<\/a><\/p>\n

What we need to do is to simplify adding a large number of subcategories. When user types in first two digit (category) we want to show category name underneath and also calculate the next subcategory number. We will do that using field events.<\/p>\n

This is how it works in generated application:<\/p>\n

\"\"<\/a><\/p>\n

Code<\/h3>\n

First we need to create Field Event for SubID field. We will use ‘editing’ event here which will be called every time the content of field is changed. <\/p>\n

\"\"<\/a><\/p>\n

ClientBefore:<\/p>\n

\r\nvar val = this.getValue();\r\nif (val.length==2)\r\n  params[\"val\"]=val;\r\nelse\r\n return false;\r\n<\/pre>\n
In ClientBefore code we check the length of entered code and only send it to server side when code is two digits long. <\/p>\n
Server:<\/p>\n
PHP<\/strong><\/p>\n
\r\n$result[\"catName\"] = DBLookup(\"select CategoryName from apps_categories where CategoryID='\".$params[\"val\"].\"'\");\r\n$sub = DBLookup(\"select max(substring(SubID,3,2))+1 from apps_sub_categories where left(SubID,2)='\".$params[\"val\"].\"'\");\r\n$result[\"newCat\"] = $params[\"val\"].str_pad($sub,2,\"0\",STR_PAD_LEFT);\r\n<\/pre>\n
C#<\/strong><\/p>\n
\r\nresult[\"catName\"] = tDAL.DBLookup(\"select CategoryName from categories where CategoryID='\" + parameters[\"val\"].ToString() + \"'\");\r\n\r\nstring sub = tDAL.DBLookup(\"select max(substring(SubID,3,2))+1 from sub_categories where left(SubID,2)='\" + parameters[\"val\"].ToString() + \"'\");\r\n\r\nresult[\"newCat\"] = parameters[\"val\"].ToString() + sub.ToString().PadLeft(2, '0');\r\n<\/pre>\n
ASP<\/strong><\/p>\n
\r\nresult(\"catName\") = DBLookup(\"select CategoryName from categories where CategoryID='\" & params(\"val\") & \"'\")\r\nres = DBLookup(\"select max(substring(SubID,3,2))+1 from sub_categories where left(SubID,2)='\" & params(\"val\") & \"'\")\r\nif len(res)<2 then\r\nres = \"0\" & res\r\nend if\r\nresult(\"newCat\") = params(\"val\") & res\r\n<\/pre>\n
On Server side we pull CategoryName from categories table and also calculate next subcategory ID. We pass both category name and new subcategory code back to ClientAfter event. <\/p>\n
ClientAfter:<\/p>\n
\r\n$(\"#sub_tip\").remove();\r\n$(\"input[id=value_SubID_1]\").after(\"<div id='sub_tip' style='margin-top: 10px; color: blue;'>\"+result[\"catName\"]+\"<\/div>\");\r\nctrl.setValue(result[\"newCat\"]);\r\n<\/pre>\n
In this event we remove previous tooltip with category name and add a new one. We also make it appear in blue color. Then we set the value of SubID with new subcategory code we received from the Server event. <\/p>\n","protected":false},"excerpt":{"rendered":"
We have two tables: categories and sub_categories. CategoryID is a two-digit category code.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,1,8],"tags":[],"class_list":["post-1667","post","type-post","status-publish","format-standard","hentry","category-asp-net","category-php-category","category-tutorials"],"_links":{"self":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/1667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=1667"}],"version-history":[{"count":18,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/1667\/revisions"}],"predecessor-version":[{"id":1692,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/1667\/revisions\/1692"}],"wp:attachment":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=1667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/categories?post=1667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/tags?post=1667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}