PageRenderTime 43ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/reports/leaves_reports/output/include/tblleavetype_settings.php

https://bitbucket.org/lecturer34/hrmis
PHP | 508 lines | 297 code | 189 blank | 22 comment | 11 complexity | 5d98e75db976f0ac352821a275c7ec6c MD5 | raw file
Possible License(s): LGPL-2.1
  1. <?php
  2. $tdatatblleavetype=array();
  3. $tdatatblleavetype[".ShortName"]="tblleavetype";
  4. $tdatatblleavetype[".OwnerID"]="";
  5. $tdatatblleavetype[".OriginalTable"]="tblleavetype";
  6. // field labels
  7. $fieldLabelstblleavetype = array();
  8. if(mlang_getcurrentlang()=="English")
  9. {
  10. $fieldLabelstblleavetype["English"]=array();
  11. $fieldToolTipstblleavetype["English"]=array();
  12. $fieldLabelstblleavetype["English"]["leavetypeid"] = "S/N";
  13. $fieldToolTipstblleavetype["English"]["leavetypeid"] = "";
  14. $fieldLabelstblleavetype["English"]["description"] = "Leave Type";
  15. $fieldToolTipstblleavetype["English"]["description"] = "";
  16. $fieldLabelstblleavetype["English"][""] = "";
  17. $fieldToolTipstblleavetype["English"][""] = "";
  18. $fieldLabelstblleavetype["English"][""] = "";
  19. $fieldToolTipstblleavetype["English"][""] = "";
  20. if (count($fieldToolTipstblleavetype["English"])){
  21. $tdatatblleavetype[".isUseToolTips"]=true;
  22. }
  23. }
  24. $tdatatblleavetype[".NCSearch"]=true;
  25. $tdatatblleavetype[".shortTableName"] = "tblleavetype";
  26. $tdatatblleavetype[".nSecOptions"] = 0;
  27. $tdatatblleavetype[".recsPerRowList"] = 1;
  28. $tdatatblleavetype[".tableGroupBy"] = "0";
  29. $tdatatblleavetype[".mainTableOwnerID"] = "";
  30. $tdatatblleavetype[".moveNext"] = 1;
  31. $tdatatblleavetype[".showAddInPopup"] = false;
  32. $tdatatblleavetype[".showEditInPopup"] = false;
  33. $tdatatblleavetype[".showViewInPopup"] = false;
  34. $tdatatblleavetype[".fieldsForRegister"] = array();
  35. $tdatatblleavetype[".listAjax"] = false;
  36. $tdatatblleavetype[".audit"] = false;
  37. $tdatatblleavetype[".locking"] = false;
  38. $tdatatblleavetype[".listIcons"] = true;
  39. $tdatatblleavetype[".edit"] = true;
  40. $tdatatblleavetype[".inlineEdit"] = true;
  41. $tdatatblleavetype[".view"] = true;
  42. $tdatatblleavetype[".exportTo"] = true;
  43. $tdatatblleavetype[".printFriendly"] = true;
  44. $tdatatblleavetype[".delete"] = true;
  45. $tdatatblleavetype[".showSimpleSearchOptions"] = false;
  46. $tdatatblleavetype[".showSearchPanel"] = true;
  47. if (isMobile()){
  48. $tdatatblleavetype[".isUseAjaxSuggest"] = false;
  49. }else {
  50. $tdatatblleavetype[".isUseAjaxSuggest"] = true;
  51. }
  52. $tdatatblleavetype[".rowHighlite"] = true;
  53. // button handlers file names
  54. $tdatatblleavetype[".addPageEvents"] = false;
  55. $tdatatblleavetype[".arrKeyFields"][] = "leavetypeid";
  56. // use datepicker for search panel
  57. $tdatatblleavetype[".isUseCalendarForSearch"] = false;
  58. // use timepicker for search panel
  59. $tdatatblleavetype[".isUseTimeForSearch"] = false;
  60. $tdatatblleavetype[".isUseiBox"] = false;
  61. $tdatatblleavetype[".isUseInlineAdd"] = true;
  62. $tdatatblleavetype[".isUseInlineEdit"] = true;
  63. $tdatatblleavetype[".isUseInlineJs"] = $tdatatblleavetype[".isUseInlineAdd"] || $tdatatblleavetype[".isUseInlineEdit"];
  64. $tdatatblleavetype[".allSearchFields"] = array();
  65. $tdatatblleavetype[".globSearchFields"][] = "leavetypeid";
  66. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  67. if (!in_array("leavetypeid", $tdatatblleavetype[".allSearchFields"]))
  68. {
  69. $tdatatblleavetype[".allSearchFields"][] = "leavetypeid";
  70. }
  71. $tdatatblleavetype[".globSearchFields"][] = "description";
  72. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  73. if (!in_array("description", $tdatatblleavetype[".allSearchFields"]))
  74. {
  75. $tdatatblleavetype[".allSearchFields"][] = "description";
  76. }
  77. $tdatatblleavetype[".googleLikeFields"][] = "leavetypeid";
  78. $tdatatblleavetype[".googleLikeFields"][] = "description";
  79. $tdatatblleavetype[".panelSearchFields"][] = "description";
  80. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  81. if (!in_array("description", $tdatatblleavetype[".allSearchFields"]))
  82. {
  83. $tdatatblleavetype[".allSearchFields"][] = "description";
  84. }
  85. $tdatatblleavetype[".advSearchFields"][] = "leavetypeid";
  86. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  87. if (!in_array("leavetypeid", $tdatatblleavetype[".allSearchFields"]))
  88. {
  89. $tdatatblleavetype[".allSearchFields"][] = "leavetypeid";
  90. }
  91. $tdatatblleavetype[".advSearchFields"][] = "description";
  92. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  93. if (!in_array("description", $tdatatblleavetype[".allSearchFields"]))
  94. {
  95. $tdatatblleavetype[".allSearchFields"][] = "description";
  96. }
  97. $tdatatblleavetype[".isTableType"] = "list";
  98. // Access doesn't support subqueries from the same table as main
  99. $tdatatblleavetype[".subQueriesSupAccess"] = true;
  100. $tdatatblleavetype[".pageSize"] = 20;
  101. $gstrOrderBy = "";
  102. if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
  103. $gstrOrderBy = "order by ".$gstrOrderBy;
  104. $tdatatblleavetype[".strOrderBy"] = $gstrOrderBy;
  105. $tdatatblleavetype[".orderindexes"] = array();
  106. $tdatatblleavetype[".sqlHead"] = "SELECT leavetypeid, description";
  107. $tdatatblleavetype[".sqlFrom"] = "FROM tblleavetype";
  108. $tdatatblleavetype[".sqlWhereExpr"] = "";
  109. $tdatatblleavetype[".sqlTail"] = "";
  110. //fill array of records per page for list and report without group fields
  111. $arrRPP = array();
  112. $arrRPP[] = 10;
  113. $arrRPP[] = 20;
  114. $arrRPP[] = 30;
  115. $arrRPP[] = 50;
  116. $arrRPP[] = 100;
  117. $arrRPP[] = 500;
  118. $arrRPP[] = -1;
  119. $tdatatblleavetype[".arrRecsPerPage"] = $arrRPP;
  120. //fill array of groups per page for report with group fields
  121. $arrGPP = array();
  122. $arrGPP[] = 1;
  123. $arrGPP[] = 3;
  124. $arrGPP[] = 5;
  125. $arrGPP[] = 10;
  126. $arrGPP[] = 50;
  127. $arrGPP[] = 100;
  128. $arrGPP[] = -1;
  129. $tdatatblleavetype[".arrGroupsPerPage"] = $arrGPP;
  130. $tableKeys = array();
  131. $tableKeys[] = "leavetypeid";
  132. $tdatatblleavetype[".Keys"] = $tableKeys;
  133. $tdatatblleavetype[".listFields"] = array();
  134. $tdatatblleavetype[".listFields"][] = "leavetypeid";
  135. $tdatatblleavetype[".listFields"][] = "description";
  136. $tdatatblleavetype[".addFields"] = array();
  137. $tdatatblleavetype[".addFields"][] = "leavetypeid";
  138. $tdatatblleavetype[".addFields"][] = "description";
  139. $tdatatblleavetype[".inlineAddFields"] = array();
  140. $tdatatblleavetype[".inlineAddFields"][] = "leavetypeid";
  141. $tdatatblleavetype[".inlineAddFields"][] = "description";
  142. $tdatatblleavetype[".editFields"] = array();
  143. $tdatatblleavetype[".editFields"][] = "leavetypeid";
  144. $tdatatblleavetype[".editFields"][] = "description";
  145. $tdatatblleavetype[".inlineEditFields"] = array();
  146. $tdatatblleavetype[".inlineEditFields"][] = "leavetypeid";
  147. $tdatatblleavetype[".inlineEditFields"][] = "description";
  148. // leavetypeid
  149. $fdata = array();
  150. $fdata["strName"] = "leavetypeid";
  151. $fdata["ownerTable"] = "tblleavetype";
  152. $fdata["Label"]="S/N";
  153. $fdata["FieldType"]= 3;
  154. $fdata["AutoInc"]=true;
  155. $fdata["UseiBox"] = false;
  156. $fdata["EditFormat"]= "Text field";
  157. $fdata["ViewFormat"]= "";
  158. $fdata["NeedEncode"]=true;
  159. $fdata["GoodName"]= "leavetypeid";
  160. $fdata["FullName"]= "leavetypeid";
  161. $fdata["IsRequired"]=true;
  162. $fdata["Index"]= 1;
  163. $fdata["EditParams"]="";
  164. $fdata["bListPage"]=true;
  165. $fdata["bAddPage"]=true;
  166. $fdata["bInlineAdd"]=true;
  167. $fdata["bEditPage"]=true;
  168. $fdata["bInlineEdit"]=true;
  169. $fdata["bViewPage"]=true;
  170. $fdata["bAdvancedSearch"]=true;
  171. $fdata["bPrinterPage"]=true;
  172. $fdata["bExportPage"]=true;
  173. //Begin validation
  174. $fdata["validateAs"] = array();
  175. $fdata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
  176. $fdata["validateAs"]["basicValidate"][] = "IsRequired";
  177. //End validation
  178. $fdata["FieldPermissions"]=true;
  179. $tdatatblleavetype["leavetypeid"]=$fdata;
  180. // description
  181. $fdata = array();
  182. $fdata["strName"] = "description";
  183. $fdata["ownerTable"] = "tblleavetype";
  184. $fdata["Label"]="Leave Type";
  185. $fdata["FieldType"]= 200;
  186. $fdata["UseiBox"] = false;
  187. $fdata["EditFormat"]= "Lookup wizard";
  188. $fdata["ViewFormat"]= "";
  189. $fdata["LookupType"]=1;
  190. $fdata["pLookupType"] = 1;
  191. $fdata["freeInput"] = 0;
  192. $fdata["autoCompleteFieldsOnEdit"] = 0;
  193. $fdata["autoCompleteFields"] = array();
  194. $fdata["LinkField"]="description";
  195. $fdata["LinkFieldType"]=200;
  196. $fdata["DisplayField"]="description";
  197. $fdata["LookupTable"]="tblleavetype";
  198. $fdata["LookupOrderBy"]="description";
  199. $fdata["NeedEncode"]=true;
  200. $fdata["GoodName"]= "description";
  201. $fdata["FullName"]= "description";
  202. $fdata["Index"]= 2;
  203. $fdata["bListPage"]=true;
  204. $fdata["bAddPage"]=true;
  205. $fdata["bInlineAdd"]=true;
  206. $fdata["bEditPage"]=true;
  207. $fdata["bInlineEdit"]=true;
  208. $fdata["bViewPage"]=true;
  209. $fdata["bAdvancedSearch"]=true;
  210. $fdata["bPrinterPage"]=true;
  211. $fdata["bExportPage"]=true;
  212. //Begin validation
  213. $fdata["validateAs"] = array();
  214. //End validation
  215. $fdata["FieldPermissions"]=true;
  216. $tdatatblleavetype["description"]=$fdata;
  217. $tables_data["tblleavetype"]=&$tdatatblleavetype;
  218. $field_labels["tblleavetype"] = &$fieldLabelstblleavetype;
  219. $fieldToolTips["tblleavetype"] = &$fieldToolTipstblleavetype;
  220. // -----------------start prepare master-details data arrays ------------------------------//
  221. // tables which are detail tables for current table (master)
  222. $detailsTablesData["tblleavetype"] = array();
  223. // tables which are master tables for current table (detail)
  224. $masterTablesData["tblleavetype"] = array();
  225. // -----------------end prepare master-details data arrays ------------------------------//
  226. require_once(getabspath("classes/sql.php"));
  227. function createSqlQuery_tblleavetype()
  228. {
  229. $proto0=array();
  230. $proto0["m_strHead"] = "SELECT";
  231. $proto0["m_strFieldList"] = "leavetypeid, description";
  232. $proto0["m_strFrom"] = "FROM tblleavetype";
  233. $proto0["m_strWhere"] = "";
  234. $proto0["m_strOrderBy"] = "";
  235. $proto0["m_strTail"] = "";
  236. $proto1=array();
  237. $proto1["m_sql"] = "";
  238. $proto1["m_uniontype"] = "SQLL_UNKNOWN";
  239. $obj = new SQLNonParsed(array(
  240. "m_sql" => ""
  241. ));
  242. $proto1["m_column"]=$obj;
  243. $proto1["m_contained"] = array();
  244. $proto1["m_strCase"] = "";
  245. $proto1["m_havingmode"] = "0";
  246. $proto1["m_inBrackets"] = "0";
  247. $proto1["m_useAlias"] = "0";
  248. $obj = new SQLLogicalExpr($proto1);
  249. $proto0["m_where"] = $obj;
  250. $proto3=array();
  251. $proto3["m_sql"] = "";
  252. $proto3["m_uniontype"] = "SQLL_UNKNOWN";
  253. $obj = new SQLNonParsed(array(
  254. "m_sql" => ""
  255. ));
  256. $proto3["m_column"]=$obj;
  257. $proto3["m_contained"] = array();
  258. $proto3["m_strCase"] = "";
  259. $proto3["m_havingmode"] = "0";
  260. $proto3["m_inBrackets"] = "0";
  261. $proto3["m_useAlias"] = "0";
  262. $obj = new SQLLogicalExpr($proto3);
  263. $proto0["m_having"] = $obj;
  264. $proto0["m_fieldlist"] = array();
  265. $proto5=array();
  266. $obj = new SQLField(array(
  267. "m_strName" => "leavetypeid",
  268. "m_strTable" => "tblleavetype"
  269. ));
  270. $proto5["m_expr"]=$obj;
  271. $proto5["m_alias"] = "";
  272. $obj = new SQLFieldListItem($proto5);
  273. $proto0["m_fieldlist"][]=$obj;
  274. $proto7=array();
  275. $obj = new SQLField(array(
  276. "m_strName" => "description",
  277. "m_strTable" => "tblleavetype"
  278. ));
  279. $proto7["m_expr"]=$obj;
  280. $proto7["m_alias"] = "";
  281. $obj = new SQLFieldListItem($proto7);
  282. $proto0["m_fieldlist"][]=$obj;
  283. $proto0["m_fromlist"] = array();
  284. $proto9=array();
  285. $proto9["m_link"] = "SQLL_MAIN";
  286. $proto10=array();
  287. $proto10["m_strName"] = "tblleavetype";
  288. $proto10["m_columns"] = array();
  289. $proto10["m_columns"][] = "leavetypeid";
  290. $proto10["m_columns"][] = "description";
  291. $obj = new SQLTable($proto10);
  292. $proto9["m_table"] = $obj;
  293. $proto9["m_alias"] = "";
  294. $proto11=array();
  295. $proto11["m_sql"] = "";
  296. $proto11["m_uniontype"] = "SQLL_UNKNOWN";
  297. $obj = new SQLNonParsed(array(
  298. "m_sql" => ""
  299. ));
  300. $proto11["m_column"]=$obj;
  301. $proto11["m_contained"] = array();
  302. $proto11["m_strCase"] = "";
  303. $proto11["m_havingmode"] = "0";
  304. $proto11["m_inBrackets"] = "0";
  305. $proto11["m_useAlias"] = "0";
  306. $obj = new SQLLogicalExpr($proto11);
  307. $proto9["m_joinon"] = $obj;
  308. $obj = new SQLFromListItem($proto9);
  309. $proto0["m_fromlist"][]=$obj;
  310. $proto0["m_groupby"] = array();
  311. $proto0["m_orderby"] = array();
  312. $obj = new SQLQuery($proto0);
  313. return $obj;
  314. }
  315. $queryData_tblleavetype = createSqlQuery_tblleavetype();
  316. $tdatatblleavetype[".sqlquery"] = $queryData_tblleavetype;
  317. $tableEvents["tblleavetype"] = new eventsBase;
  318. $tdatatblleavetype[".hasEvents"] = false;
  319. ?>