PageRenderTime 59ms CodeModel.GetById 25ms RepoModel.GetById 1ms app.codeStats 0ms

/reports/employment/output/include/employmenntreport_settings.php

https://bitbucket.org/lecturer34/hrmis
PHP | 1798 lines | 1074 code | 648 blank | 76 comment | 32 complexity | d8ec0f2effb81180149dd81479dae714 MD5 | raw file
Possible License(s): LGPL-2.1
  1. <?php
  2. $tdataemploymenntreport=array();
  3. $tdataemploymenntreport[".ShortName"]="employmenntreport";
  4. $tdataemploymenntreport[".OwnerID"]="";
  5. $tdataemploymenntreport[".OriginalTable"]="tblemployee";
  6. // field labels
  7. $fieldLabelsemploymenntreport = array();
  8. if(mlang_getcurrentlang()=="English")
  9. {
  10. $fieldLabelsemploymenntreport["English"]=array();
  11. $fieldToolTipsemploymenntreport["English"]=array();
  12. $fieldLabelsemploymenntreport["English"]["firstname"] = "Firstname";
  13. $fieldToolTipsemploymenntreport["English"]["firstname"] = "";
  14. $fieldLabelsemploymenntreport["English"]["surname"] = "Surname";
  15. $fieldToolTipsemploymenntreport["English"]["surname"] = "";
  16. $fieldLabelsemploymenntreport["English"]["othernames"] = "Othernames";
  17. $fieldToolTipsemploymenntreport["English"]["othernames"] = "";
  18. $fieldLabelsemploymenntreport["English"]["dateoffirstappointment"] = "Date of First Appointment";
  19. $fieldToolTipsemploymenntreport["English"]["dateoffirstappointment"] = "";
  20. $fieldLabelsemploymenntreport["English"]["gender"] = "Gender";
  21. $fieldToolTipsemploymenntreport["English"]["gender"] = "";
  22. $fieldLabelsemploymenntreport["English"]["department"] = "Department";
  23. $fieldToolTipsemploymenntreport["English"]["department"] = "";
  24. $fieldLabelsemploymenntreport["English"]["personnelno"] = "Personnelno";
  25. $fieldToolTipsemploymenntreport["English"]["personnelno"] = "";
  26. $fieldLabelsemploymenntreport["English"]["CurrentRank"] = "Current Rank";
  27. $fieldToolTipsemploymenntreport["English"]["CurrentRank"] = "";
  28. $fieldLabelsemploymenntreport["English"]["EmployedAS"] = "Staff Category";
  29. $fieldToolTipsemploymenntreport["English"]["EmployedAS"] = "";
  30. $fieldLabelsemploymenntreport["English"]["Faculty"] = "Faculty";
  31. $fieldToolTipsemploymenntreport["English"]["Faculty"] = "";
  32. $fieldLabelsemploymenntreport["English"]["countryname"] = "Nationality";
  33. $fieldToolTipsemploymenntreport["English"]["countryname"] = "";
  34. $fieldLabelsemploymenntreport["English"]["lganame"] = "LGA";
  35. $fieldToolTipsemploymenntreport["English"]["lganame"] = "";
  36. $fieldLabelsemploymenntreport["English"]["statename"] = "State";
  37. $fieldToolTipsemploymenntreport["English"]["statename"] = "";
  38. $fieldLabelsemploymenntreport["English"]["Department"] = "Department";
  39. $fieldToolTipsemploymenntreport["English"]["Department"] = "";
  40. if (count($fieldToolTipsemploymenntreport["English"])){
  41. $tdataemploymenntreport[".isUseToolTips"]=true;
  42. }
  43. }
  44. $tdataemploymenntreport[".NCSearch"]=true;
  45. $tdataemploymenntreport[".shortTableName"] = "employmenntreport";
  46. $tdataemploymenntreport[".nSecOptions"] = 0;
  47. $tdataemploymenntreport[".recsPerRowList"] = 1;
  48. $tdataemploymenntreport[".tableGroupBy"] = "0";
  49. $tdataemploymenntreport[".mainTableOwnerID"] = "";
  50. $tdataemploymenntreport[".moveNext"] = 1;
  51. $tdataemploymenntreport[".showAddInPopup"] = false;
  52. $tdataemploymenntreport[".showEditInPopup"] = false;
  53. $tdataemploymenntreport[".showViewInPopup"] = false;
  54. $tdataemploymenntreport[".fieldsForRegister"] = array();
  55. $tdataemploymenntreport[".listAjax"] = false;
  56. $tdataemploymenntreport[".audit"] = false;
  57. $tdataemploymenntreport[".locking"] = false;
  58. $tdataemploymenntreport[".listIcons"] = true;
  59. $tdataemploymenntreport[".edit"] = true;
  60. $tdataemploymenntreport[".inlineEdit"] = true;
  61. $tdataemploymenntreport[".view"] = true;
  62. $tdataemploymenntreport[".exportTo"] = true;
  63. $tdataemploymenntreport[".printFriendly"] = true;
  64. $tdataemploymenntreport[".delete"] = true;
  65. $tdataemploymenntreport[".showSimpleSearchOptions"] = false;
  66. $tdataemploymenntreport[".showSearchPanel"] = true;
  67. if (isMobile()){
  68. $tdataemploymenntreport[".isUseAjaxSuggest"] = false;
  69. }else {
  70. $tdataemploymenntreport[".isUseAjaxSuggest"] = true;
  71. }
  72. // button handlers file names
  73. $tdataemploymenntreport[".addPageEvents"] = false;
  74. // use datepicker for search panel
  75. $tdataemploymenntreport[".isUseCalendarForSearch"] = true;
  76. // use timepicker for search panel
  77. $tdataemploymenntreport[".isUseTimeForSearch"] = false;
  78. $tdataemploymenntreport[".isUseiBox"] = false;
  79. $tdataemploymenntreport[".isUseInlineJs"] = $tdataemploymenntreport[".isUseInlineAdd"] || $tdataemploymenntreport[".isUseInlineEdit"];
  80. $tdataemploymenntreport[".allSearchFields"] = array();
  81. $tdataemploymenntreport[".globSearchFields"][] = "personnelno";
  82. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  83. if (!in_array("personnelno", $tdataemploymenntreport[".allSearchFields"]))
  84. {
  85. $tdataemploymenntreport[".allSearchFields"][] = "personnelno";
  86. }
  87. $tdataemploymenntreport[".globSearchFields"][] = "surname";
  88. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  89. if (!in_array("surname", $tdataemploymenntreport[".allSearchFields"]))
  90. {
  91. $tdataemploymenntreport[".allSearchFields"][] = "surname";
  92. }
  93. $tdataemploymenntreport[".globSearchFields"][] = "firstname";
  94. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  95. if (!in_array("firstname", $tdataemploymenntreport[".allSearchFields"]))
  96. {
  97. $tdataemploymenntreport[".allSearchFields"][] = "firstname";
  98. }
  99. $tdataemploymenntreport[".globSearchFields"][] = "othernames";
  100. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  101. if (!in_array("othernames", $tdataemploymenntreport[".allSearchFields"]))
  102. {
  103. $tdataemploymenntreport[".allSearchFields"][] = "othernames";
  104. }
  105. $tdataemploymenntreport[".globSearchFields"][] = "gender";
  106. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  107. if (!in_array("gender", $tdataemploymenntreport[".allSearchFields"]))
  108. {
  109. $tdataemploymenntreport[".allSearchFields"][] = "gender";
  110. }
  111. $tdataemploymenntreport[".globSearchFields"][] = "CurrentRank";
  112. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  113. if (!in_array("CurrentRank", $tdataemploymenntreport[".allSearchFields"]))
  114. {
  115. $tdataemploymenntreport[".allSearchFields"][] = "CurrentRank";
  116. }
  117. $tdataemploymenntreport[".globSearchFields"][] = "EmployedAS";
  118. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  119. if (!in_array("EmployedAS", $tdataemploymenntreport[".allSearchFields"]))
  120. {
  121. $tdataemploymenntreport[".allSearchFields"][] = "EmployedAS";
  122. }
  123. $tdataemploymenntreport[".globSearchFields"][] = "Faculty";
  124. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  125. if (!in_array("Faculty", $tdataemploymenntreport[".allSearchFields"]))
  126. {
  127. $tdataemploymenntreport[".allSearchFields"][] = "Faculty";
  128. }
  129. $tdataemploymenntreport[".globSearchFields"][] = "Department";
  130. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  131. if (!in_array("Department", $tdataemploymenntreport[".allSearchFields"]))
  132. {
  133. $tdataemploymenntreport[".allSearchFields"][] = "Department";
  134. }
  135. $tdataemploymenntreport[".globSearchFields"][] = "countryname";
  136. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  137. if (!in_array("countryname", $tdataemploymenntreport[".allSearchFields"]))
  138. {
  139. $tdataemploymenntreport[".allSearchFields"][] = "countryname";
  140. }
  141. $tdataemploymenntreport[".globSearchFields"][] = "lganame";
  142. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  143. if (!in_array("lganame", $tdataemploymenntreport[".allSearchFields"]))
  144. {
  145. $tdataemploymenntreport[".allSearchFields"][] = "lganame";
  146. }
  147. $tdataemploymenntreport[".globSearchFields"][] = "dateoffirstappointment";
  148. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  149. if (!in_array("dateoffirstappointment", $tdataemploymenntreport[".allSearchFields"]))
  150. {
  151. $tdataemploymenntreport[".allSearchFields"][] = "dateoffirstappointment";
  152. }
  153. $tdataemploymenntreport[".globSearchFields"][] = "statename";
  154. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  155. if (!in_array("statename", $tdataemploymenntreport[".allSearchFields"]))
  156. {
  157. $tdataemploymenntreport[".allSearchFields"][] = "statename";
  158. }
  159. $tdataemploymenntreport[".googleLikeFields"][] = "personnelno";
  160. $tdataemploymenntreport[".googleLikeFields"][] = "surname";
  161. $tdataemploymenntreport[".googleLikeFields"][] = "firstname";
  162. $tdataemploymenntreport[".googleLikeFields"][] = "othernames";
  163. $tdataemploymenntreport[".googleLikeFields"][] = "gender";
  164. $tdataemploymenntreport[".googleLikeFields"][] = "CurrentRank";
  165. $tdataemploymenntreport[".googleLikeFields"][] = "EmployedAS";
  166. $tdataemploymenntreport[".googleLikeFields"][] = "Faculty";
  167. $tdataemploymenntreport[".googleLikeFields"][] = "Department";
  168. $tdataemploymenntreport[".googleLikeFields"][] = "countryname";
  169. $tdataemploymenntreport[".googleLikeFields"][] = "lganame";
  170. $tdataemploymenntreport[".googleLikeFields"][] = "dateoffirstappointment";
  171. $tdataemploymenntreport[".googleLikeFields"][] = "statename";
  172. $tdataemploymenntreport[".advSearchFields"][] = "personnelno";
  173. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  174. if (!in_array("personnelno", $tdataemploymenntreport[".allSearchFields"]))
  175. {
  176. $tdataemploymenntreport[".allSearchFields"][] = "personnelno";
  177. }
  178. $tdataemploymenntreport[".advSearchFields"][] = "surname";
  179. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  180. if (!in_array("surname", $tdataemploymenntreport[".allSearchFields"]))
  181. {
  182. $tdataemploymenntreport[".allSearchFields"][] = "surname";
  183. }
  184. $tdataemploymenntreport[".advSearchFields"][] = "firstname";
  185. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  186. if (!in_array("firstname", $tdataemploymenntreport[".allSearchFields"]))
  187. {
  188. $tdataemploymenntreport[".allSearchFields"][] = "firstname";
  189. }
  190. $tdataemploymenntreport[".advSearchFields"][] = "othernames";
  191. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  192. if (!in_array("othernames", $tdataemploymenntreport[".allSearchFields"]))
  193. {
  194. $tdataemploymenntreport[".allSearchFields"][] = "othernames";
  195. }
  196. $tdataemploymenntreport[".advSearchFields"][] = "gender";
  197. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  198. if (!in_array("gender", $tdataemploymenntreport[".allSearchFields"]))
  199. {
  200. $tdataemploymenntreport[".allSearchFields"][] = "gender";
  201. }
  202. $tdataemploymenntreport[".advSearchFields"][] = "CurrentRank";
  203. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  204. if (!in_array("CurrentRank", $tdataemploymenntreport[".allSearchFields"]))
  205. {
  206. $tdataemploymenntreport[".allSearchFields"][] = "CurrentRank";
  207. }
  208. $tdataemploymenntreport[".advSearchFields"][] = "EmployedAS";
  209. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  210. if (!in_array("EmployedAS", $tdataemploymenntreport[".allSearchFields"]))
  211. {
  212. $tdataemploymenntreport[".allSearchFields"][] = "EmployedAS";
  213. }
  214. $tdataemploymenntreport[".advSearchFields"][] = "Faculty";
  215. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  216. if (!in_array("Faculty", $tdataemploymenntreport[".allSearchFields"]))
  217. {
  218. $tdataemploymenntreport[".allSearchFields"][] = "Faculty";
  219. }
  220. $tdataemploymenntreport[".advSearchFields"][] = "Department";
  221. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  222. if (!in_array("Department", $tdataemploymenntreport[".allSearchFields"]))
  223. {
  224. $tdataemploymenntreport[".allSearchFields"][] = "Department";
  225. }
  226. $tdataemploymenntreport[".advSearchFields"][] = "countryname";
  227. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  228. if (!in_array("countryname", $tdataemploymenntreport[".allSearchFields"]))
  229. {
  230. $tdataemploymenntreport[".allSearchFields"][] = "countryname";
  231. }
  232. $tdataemploymenntreport[".advSearchFields"][] = "lganame";
  233. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  234. if (!in_array("lganame", $tdataemploymenntreport[".allSearchFields"]))
  235. {
  236. $tdataemploymenntreport[".allSearchFields"][] = "lganame";
  237. }
  238. $tdataemploymenntreport[".advSearchFields"][] = "dateoffirstappointment";
  239. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  240. if (!in_array("dateoffirstappointment", $tdataemploymenntreport[".allSearchFields"]))
  241. {
  242. $tdataemploymenntreport[".allSearchFields"][] = "dateoffirstappointment";
  243. }
  244. $tdataemploymenntreport[".advSearchFields"][] = "statename";
  245. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  246. if (!in_array("statename", $tdataemploymenntreport[".allSearchFields"]))
  247. {
  248. $tdataemploymenntreport[".allSearchFields"][] = "statename";
  249. }
  250. $tdataemploymenntreport[".isTableType"] = "report";
  251. // Access doesn't support subqueries from the same table as main
  252. $tdataemploymenntreport[".subQueriesSupAccess"] = true;
  253. $gstrOrderBy = "";
  254. if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
  255. $gstrOrderBy = "order by ".$gstrOrderBy;
  256. $tdataemploymenntreport[".strOrderBy"] = $gstrOrderBy;
  257. $tdataemploymenntreport[".orderindexes"] = array();
  258. $tdataemploymenntreport[".sqlHead"] = "SELECT tblpromotions.personnelno, tblemployee.surname, tblemployee.firstname, tblemployee.othernames, tblemployee.gender, tblrank.name AS CurrentRank, tblrank.name AS EmployedAS, tblfaccentres.fame AS Faculty, tbldepartment.name AS Department, tblcountries.countryname, tbllga.lganame, tblemployee.dateoffirstappointment, tblstate.statename";
  259. $tdataemploymenntreport[".sqlFrom"] = "FROM tblemployee INNER JOIN tblpromotions ON tblemployee.employeeid = tblpromotions.employeeid INNER JOIN tbldepartment ON tblemployee.department = tbldepartment.departmentid INNER JOIN tblfaccentres ON tbldepartment.facultyid = tblfaccentres.facid INNER JOIN tblcountries ON tblemployee.nationality = tblcountries.countryid INNER JOIN tblstate ON tblcountries.countryid = tblstate.country INNER JOIN tbllga ON tblstate.stateid = tbllga.stateid INNER JOIN tblrank ON tblpromotions.rank = tblrank.rankid AND tblemployee.rankonemployment = tblrank.rankid";
  260. $tdataemploymenntreport[".sqlWhereExpr"] = "";
  261. $tdataemploymenntreport[".sqlTail"] = "";
  262. //fill array of records per page for list and report without group fields
  263. $arrRPP = array();
  264. $arrRPP[] = 10;
  265. $arrRPP[] = 20;
  266. $arrRPP[] = 30;
  267. $arrRPP[] = 50;
  268. $arrRPP[] = 100;
  269. $arrRPP[] = 500;
  270. $arrRPP[] = -1;
  271. $tdataemploymenntreport[".arrRecsPerPage"] = $arrRPP;
  272. //fill array of groups per page for report with group fields
  273. $arrGPP = array();
  274. $arrGPP[] = 1;
  275. $arrGPP[] = 3;
  276. $arrGPP[] = 5;
  277. $arrGPP[] = 10;
  278. $arrGPP[] = 50;
  279. $arrGPP[] = 100;
  280. $arrGPP[] = -1;
  281. $tdataemploymenntreport[".arrGroupsPerPage"] = $arrGPP;
  282. $tableKeys = array();
  283. $tdataemploymenntreport[".Keys"] = $tableKeys;
  284. $tdataemploymenntreport[".listFields"] = array();
  285. $tdataemploymenntreport[".listFields"][] = "personnelno";
  286. $tdataemploymenntreport[".listFields"][] = "surname";
  287. $tdataemploymenntreport[".listFields"][] = "firstname";
  288. $tdataemploymenntreport[".listFields"][] = "othernames";
  289. $tdataemploymenntreport[".listFields"][] = "gender";
  290. $tdataemploymenntreport[".listFields"][] = "CurrentRank";
  291. $tdataemploymenntreport[".listFields"][] = "EmployedAS";
  292. $tdataemploymenntreport[".listFields"][] = "Faculty";
  293. $tdataemploymenntreport[".listFields"][] = "Department";
  294. $tdataemploymenntreport[".listFields"][] = "countryname";
  295. $tdataemploymenntreport[".listFields"][] = "lganame";
  296. $tdataemploymenntreport[".listFields"][] = "dateoffirstappointment";
  297. $tdataemploymenntreport[".listFields"][] = "statename";
  298. $tdataemploymenntreport[".addFields"] = array();
  299. $tdataemploymenntreport[".addFields"][] = "surname";
  300. $tdataemploymenntreport[".addFields"][] = "firstname";
  301. $tdataemploymenntreport[".addFields"][] = "othernames";
  302. $tdataemploymenntreport[".addFields"][] = "gender";
  303. $tdataemploymenntreport[".addFields"][] = "Department";
  304. $tdataemploymenntreport[".addFields"][] = "dateoffirstappointment";
  305. $tdataemploymenntreport[".inlineAddFields"] = array();
  306. $tdataemploymenntreport[".inlineAddFields"][] = "personnelno";
  307. $tdataemploymenntreport[".inlineAddFields"][] = "surname";
  308. $tdataemploymenntreport[".inlineAddFields"][] = "firstname";
  309. $tdataemploymenntreport[".inlineAddFields"][] = "othernames";
  310. $tdataemploymenntreport[".inlineAddFields"][] = "gender";
  311. $tdataemploymenntreport[".inlineAddFields"][] = "CurrentRank";
  312. $tdataemploymenntreport[".inlineAddFields"][] = "EmployedAS";
  313. $tdataemploymenntreport[".inlineAddFields"][] = "Faculty";
  314. $tdataemploymenntreport[".inlineAddFields"][] = "Department";
  315. $tdataemploymenntreport[".inlineAddFields"][] = "countryname";
  316. $tdataemploymenntreport[".inlineAddFields"][] = "lganame";
  317. $tdataemploymenntreport[".inlineAddFields"][] = "dateoffirstappointment";
  318. $tdataemploymenntreport[".inlineAddFields"][] = "statename";
  319. $tdataemploymenntreport[".editFields"] = array();
  320. $tdataemploymenntreport[".editFields"][] = "surname";
  321. $tdataemploymenntreport[".editFields"][] = "firstname";
  322. $tdataemploymenntreport[".editFields"][] = "othernames";
  323. $tdataemploymenntreport[".editFields"][] = "gender";
  324. $tdataemploymenntreport[".editFields"][] = "Department";
  325. $tdataemploymenntreport[".editFields"][] = "dateoffirstappointment";
  326. $tdataemploymenntreport[".inlineEditFields"] = array();
  327. $tdataemploymenntreport[".inlineEditFields"][] = "personnelno";
  328. $tdataemploymenntreport[".inlineEditFields"][] = "surname";
  329. $tdataemploymenntreport[".inlineEditFields"][] = "firstname";
  330. $tdataemploymenntreport[".inlineEditFields"][] = "othernames";
  331. $tdataemploymenntreport[".inlineEditFields"][] = "gender";
  332. $tdataemploymenntreport[".inlineEditFields"][] = "CurrentRank";
  333. $tdataemploymenntreport[".inlineEditFields"][] = "EmployedAS";
  334. $tdataemploymenntreport[".inlineEditFields"][] = "Faculty";
  335. $tdataemploymenntreport[".inlineEditFields"][] = "Department";
  336. $tdataemploymenntreport[".inlineEditFields"][] = "countryname";
  337. $tdataemploymenntreport[".inlineEditFields"][] = "lganame";
  338. $tdataemploymenntreport[".inlineEditFields"][] = "dateoffirstappointment";
  339. $tdataemploymenntreport[".inlineEditFields"][] = "statename";
  340. // personnelno
  341. $fdata = array();
  342. $fdata["strName"] = "personnelno";
  343. $fdata["ownerTable"] = "tblpromotions";
  344. $fdata["Label"]="Personnelno";
  345. $fdata["FieldType"]= 200;
  346. $fdata["UseiBox"] = false;
  347. $fdata["EditFormat"]= "Text field";
  348. $fdata["ViewFormat"]= "";
  349. $fdata["NeedEncode"]=true;
  350. $fdata["GoodName"]= "personnelno";
  351. $fdata["FullName"]= "tblpromotions.personnelno";
  352. $fdata["Index"]= 1;
  353. $fdata["EditParams"]="";
  354. $fdata["bListPage"]=true;
  355. $fdata["bInlineAdd"]=true;
  356. $fdata["bInlineEdit"]=true;
  357. $fdata["bViewPage"]=true;
  358. $fdata["bAdvancedSearch"]=true;
  359. $fdata["bPrinterPage"]=true;
  360. $fdata["bExportPage"]=true;
  361. //Begin validation
  362. $fdata["validateAs"] = array();
  363. //End validation
  364. $fdata["FieldPermissions"]=true;
  365. $tdataemploymenntreport["personnelno"]=$fdata;
  366. // surname
  367. $fdata = array();
  368. $fdata["strName"] = "surname";
  369. $fdata["ownerTable"] = "tblemployee";
  370. $fdata["Label"]="Surname";
  371. $fdata["FieldType"]= 200;
  372. $fdata["UseiBox"] = false;
  373. $fdata["EditFormat"]= "Text field";
  374. $fdata["ViewFormat"]= "";
  375. $fdata["NeedEncode"]=true;
  376. $fdata["GoodName"]= "surname";
  377. $fdata["FullName"]= "tblemployee.surname";
  378. $fdata["Index"]= 2;
  379. $fdata["EditParams"]="";
  380. $fdata["EditParams"].= " maxlength=30";
  381. $fdata["bListPage"]=true;
  382. $fdata["bAddPage"]=true;
  383. $fdata["bInlineAdd"]=true;
  384. $fdata["bEditPage"]=true;
  385. $fdata["bInlineEdit"]=true;
  386. $fdata["bViewPage"]=true;
  387. $fdata["bAdvancedSearch"]=true;
  388. $fdata["bPrinterPage"]=true;
  389. $fdata["bExportPage"]=true;
  390. //Begin validation
  391. $fdata["validateAs"] = array();
  392. //End validation
  393. $fdata["FieldPermissions"]=true;
  394. $tdataemploymenntreport["surname"]=$fdata;
  395. // firstname
  396. $fdata = array();
  397. $fdata["strName"] = "firstname";
  398. $fdata["ownerTable"] = "tblemployee";
  399. $fdata["Label"]="Firstname";
  400. $fdata["FieldType"]= 200;
  401. $fdata["UseiBox"] = false;
  402. $fdata["EditFormat"]= "Text field";
  403. $fdata["ViewFormat"]= "";
  404. $fdata["NeedEncode"]=true;
  405. $fdata["GoodName"]= "firstname";
  406. $fdata["FullName"]= "tblemployee.firstname";
  407. $fdata["Index"]= 3;
  408. $fdata["EditParams"]="";
  409. $fdata["EditParams"].= " maxlength=30";
  410. $fdata["bListPage"]=true;
  411. $fdata["bAddPage"]=true;
  412. $fdata["bInlineAdd"]=true;
  413. $fdata["bEditPage"]=true;
  414. $fdata["bInlineEdit"]=true;
  415. $fdata["bViewPage"]=true;
  416. $fdata["bAdvancedSearch"]=true;
  417. $fdata["bPrinterPage"]=true;
  418. $fdata["bExportPage"]=true;
  419. //Begin validation
  420. $fdata["validateAs"] = array();
  421. //End validation
  422. $fdata["FieldPermissions"]=true;
  423. $tdataemploymenntreport["firstname"]=$fdata;
  424. // othernames
  425. $fdata = array();
  426. $fdata["strName"] = "othernames";
  427. $fdata["ownerTable"] = "tblemployee";
  428. $fdata["Label"]="Othernames";
  429. $fdata["FieldType"]= 200;
  430. $fdata["UseiBox"] = false;
  431. $fdata["EditFormat"]= "Text field";
  432. $fdata["ViewFormat"]= "";
  433. $fdata["NeedEncode"]=true;
  434. $fdata["GoodName"]= "othernames";
  435. $fdata["FullName"]= "tblemployee.othernames";
  436. $fdata["Index"]= 4;
  437. $fdata["EditParams"]="";
  438. $fdata["EditParams"].= " maxlength=30";
  439. $fdata["bListPage"]=true;
  440. $fdata["bAddPage"]=true;
  441. $fdata["bInlineAdd"]=true;
  442. $fdata["bEditPage"]=true;
  443. $fdata["bInlineEdit"]=true;
  444. $fdata["bViewPage"]=true;
  445. $fdata["bAdvancedSearch"]=true;
  446. $fdata["bPrinterPage"]=true;
  447. $fdata["bExportPage"]=true;
  448. //Begin validation
  449. $fdata["validateAs"] = array();
  450. //End validation
  451. $fdata["FieldPermissions"]=true;
  452. $tdataemploymenntreport["othernames"]=$fdata;
  453. // gender
  454. $fdata = array();
  455. $fdata["strName"] = "gender";
  456. $fdata["ownerTable"] = "tblemployee";
  457. $fdata["Label"]="Gender";
  458. $fdata["FieldType"]= 129;
  459. $fdata["UseiBox"] = false;
  460. $fdata["EditFormat"]= "Lookup wizard";
  461. $fdata["ViewFormat"]= "";
  462. $fdata["LookupType"]=0;
  463. $fdata["pLookupType"] = 0;
  464. $fdata["freeInput"] = 0;
  465. $fdata["autoCompleteFieldsOnEdit"] = 0;
  466. $fdata["autoCompleteFields"] = array();
  467. $fdata["LookupValues"]=array();
  468. $fdata["LookupValues"][]="Female";
  469. $fdata["LookupValues"][]="Male";
  470. $fdata["NeedEncode"]=true;
  471. $fdata["GoodName"]= "gender";
  472. $fdata["FullName"]= "tblemployee.gender";
  473. $fdata["Index"]= 5;
  474. $fdata["bListPage"]=true;
  475. $fdata["bAddPage"]=true;
  476. $fdata["bInlineAdd"]=true;
  477. $fdata["bEditPage"]=true;
  478. $fdata["bInlineEdit"]=true;
  479. $fdata["bViewPage"]=true;
  480. $fdata["bAdvancedSearch"]=true;
  481. $fdata["bPrinterPage"]=true;
  482. $fdata["bExportPage"]=true;
  483. //Begin validation
  484. $fdata["validateAs"] = array();
  485. //End validation
  486. $fdata["FieldPermissions"]=true;
  487. $tdataemploymenntreport["gender"]=$fdata;
  488. // CurrentRank
  489. $fdata = array();
  490. $fdata["strName"] = "CurrentRank";
  491. $fdata["ownerTable"] = "tblrank";
  492. $fdata["Label"]="Current Rank";
  493. $fdata["FieldType"]= 200;
  494. $fdata["UseiBox"] = false;
  495. $fdata["EditFormat"]= "Text field";
  496. $fdata["ViewFormat"]= "";
  497. $fdata["NeedEncode"]=true;
  498. $fdata["GoodName"]= "CurrentRank";
  499. $fdata["FullName"]= "tblrank.name";
  500. $fdata["Index"]= 6;
  501. $fdata["EditParams"]="";
  502. $fdata["bListPage"]=true;
  503. $fdata["bInlineAdd"]=true;
  504. $fdata["bInlineEdit"]=true;
  505. $fdata["bViewPage"]=true;
  506. $fdata["bAdvancedSearch"]=true;
  507. $fdata["bPrinterPage"]=true;
  508. $fdata["bExportPage"]=true;
  509. //Begin validation
  510. $fdata["validateAs"] = array();
  511. //End validation
  512. $fdata["FieldPermissions"]=true;
  513. $tdataemploymenntreport["CurrentRank"]=$fdata;
  514. // EmployedAS
  515. $fdata = array();
  516. $fdata["strName"] = "EmployedAS";
  517. $fdata["ownerTable"] = "tblrank";
  518. $fdata["Label"]="Staff Category";
  519. $fdata["FieldType"]= 200;
  520. $fdata["UseiBox"] = false;
  521. $fdata["EditFormat"]= "Text field";
  522. $fdata["ViewFormat"]= "";
  523. $fdata["NeedEncode"]=true;
  524. $fdata["GoodName"]= "EmployedAS";
  525. $fdata["FullName"]= "tblrank.name";
  526. $fdata["Index"]= 7;
  527. $fdata["EditParams"]="";
  528. $fdata["bListPage"]=true;
  529. $fdata["bInlineAdd"]=true;
  530. $fdata["bInlineEdit"]=true;
  531. $fdata["bViewPage"]=true;
  532. $fdata["bAdvancedSearch"]=true;
  533. $fdata["bPrinterPage"]=true;
  534. $fdata["bExportPage"]=true;
  535. //Begin validation
  536. $fdata["validateAs"] = array();
  537. //End validation
  538. $fdata["FieldPermissions"]=true;
  539. $tdataemploymenntreport["EmployedAS"]=$fdata;
  540. // Faculty
  541. $fdata = array();
  542. $fdata["strName"] = "Faculty";
  543. $fdata["ownerTable"] = "tblfaccentres";
  544. $fdata["Label"]="Faculty";
  545. $fdata["FieldType"]= 200;
  546. $fdata["UseiBox"] = false;
  547. $fdata["EditFormat"]= "Text field";
  548. $fdata["ViewFormat"]= "";
  549. $fdata["NeedEncode"]=true;
  550. $fdata["GoodName"]= "Faculty";
  551. $fdata["FullName"]= "tblfaccentres.fame";
  552. $fdata["Index"]= 8;
  553. $fdata["EditParams"]="";
  554. $fdata["bListPage"]=true;
  555. $fdata["bInlineAdd"]=true;
  556. $fdata["bInlineEdit"]=true;
  557. $fdata["bViewPage"]=true;
  558. $fdata["bAdvancedSearch"]=true;
  559. $fdata["bPrinterPage"]=true;
  560. $fdata["bExportPage"]=true;
  561. //Begin validation
  562. $fdata["validateAs"] = array();
  563. //End validation
  564. $fdata["FieldPermissions"]=true;
  565. $tdataemploymenntreport["Faculty"]=$fdata;
  566. // Department
  567. $fdata = array();
  568. $fdata["strName"] = "Department";
  569. $fdata["ownerTable"] = "tbldepartment";
  570. $fdata["Label"]="Department";
  571. $fdata["FieldType"]= 200;
  572. $fdata["UseiBox"] = false;
  573. $fdata["EditFormat"]= "Text field";
  574. $fdata["ViewFormat"]= "";
  575. $fdata["NeedEncode"]=true;
  576. $fdata["GoodName"]= "Department";
  577. $fdata["FullName"]= "tbldepartment.name";
  578. $fdata["Index"]= 9;
  579. $fdata["EditParams"]="";
  580. $fdata["bListPage"]=true;
  581. $fdata["bAddPage"]=true;
  582. $fdata["bInlineAdd"]=true;
  583. $fdata["bEditPage"]=true;
  584. $fdata["bInlineEdit"]=true;
  585. $fdata["bViewPage"]=true;
  586. $fdata["bAdvancedSearch"]=true;
  587. $fdata["bPrinterPage"]=true;
  588. $fdata["bExportPage"]=true;
  589. //Begin validation
  590. $fdata["validateAs"] = array();
  591. //End validation
  592. $fdata["FieldPermissions"]=true;
  593. $tdataemploymenntreport["Department"]=$fdata;
  594. // countryname
  595. $fdata = array();
  596. $fdata["strName"] = "countryname";
  597. $fdata["ownerTable"] = "tblcountries";
  598. $fdata["Label"]="Nationality";
  599. $fdata["FieldType"]= 200;
  600. $fdata["UseiBox"] = false;
  601. $fdata["EditFormat"]= "Text field";
  602. $fdata["ViewFormat"]= "";
  603. $fdata["NeedEncode"]=true;
  604. $fdata["GoodName"]= "countryname";
  605. $fdata["FullName"]= "tblcountries.countryname";
  606. $fdata["Index"]= 10;
  607. $fdata["EditParams"]="";
  608. $fdata["bListPage"]=true;
  609. $fdata["bInlineAdd"]=true;
  610. $fdata["bInlineEdit"]=true;
  611. $fdata["bViewPage"]=true;
  612. $fdata["bAdvancedSearch"]=true;
  613. $fdata["bPrinterPage"]=true;
  614. $fdata["bExportPage"]=true;
  615. //Begin validation
  616. $fdata["validateAs"] = array();
  617. //End validation
  618. $fdata["FieldPermissions"]=true;
  619. $tdataemploymenntreport["countryname"]=$fdata;
  620. // lganame
  621. $fdata = array();
  622. $fdata["strName"] = "lganame";
  623. $fdata["ownerTable"] = "tbllga";
  624. $fdata["Label"]="LGA";
  625. $fdata["FieldType"]= 200;
  626. $fdata["UseiBox"] = false;
  627. $fdata["EditFormat"]= "Text field";
  628. $fdata["ViewFormat"]= "";
  629. $fdata["NeedEncode"]=true;
  630. $fdata["GoodName"]= "lganame";
  631. $fdata["FullName"]= "tbllga.lganame";
  632. $fdata["Index"]= 11;
  633. $fdata["EditParams"]="";
  634. $fdata["bListPage"]=true;
  635. $fdata["bInlineAdd"]=true;
  636. $fdata["bInlineEdit"]=true;
  637. $fdata["bViewPage"]=true;
  638. $fdata["bAdvancedSearch"]=true;
  639. $fdata["bPrinterPage"]=true;
  640. $fdata["bExportPage"]=true;
  641. //Begin validation
  642. $fdata["validateAs"] = array();
  643. //End validation
  644. $fdata["FieldPermissions"]=true;
  645. $tdataemploymenntreport["lganame"]=$fdata;
  646. // dateoffirstappointment
  647. $fdata = array();
  648. $fdata["strName"] = "dateoffirstappointment";
  649. $fdata["ownerTable"] = "tblemployee";
  650. $fdata["Label"]="Date of First Appointment";
  651. $fdata["FieldType"]= 7;
  652. $fdata["UseiBox"] = false;
  653. $fdata["EditFormat"]= "Date";
  654. $fdata["ViewFormat"]= "Short Date";
  655. $fdata["NeedEncode"]=true;
  656. $fdata["GoodName"]= "dateoffirstappointment";
  657. $fdata["FullName"]= "tblemployee.dateoffirstappointment";
  658. $fdata["IsRequired"]=true;
  659. $fdata["Index"]= 12;
  660. $fdata["DateEditType"] = 13;
  661. $fdata["InitialYearFactor"] = 100;
  662. $fdata["LastYearFactor"] = 10;
  663. $fdata["bListPage"]=true;
  664. $fdata["bAddPage"]=true;
  665. $fdata["bInlineAdd"]=true;
  666. $fdata["bEditPage"]=true;
  667. $fdata["bInlineEdit"]=true;
  668. $fdata["bViewPage"]=true;
  669. $fdata["bAdvancedSearch"]=true;
  670. $fdata["bPrinterPage"]=true;
  671. $fdata["bExportPage"]=true;
  672. //Begin validation
  673. $fdata["validateAs"] = array();
  674. $fdata["validateAs"]["basicValidate"][] = "IsRequired";
  675. //End validation
  676. $fdata["FieldPermissions"]=true;
  677. $tdataemploymenntreport["dateoffirstappointment"]=$fdata;
  678. // statename
  679. $fdata = array();
  680. $fdata["strName"] = "statename";
  681. $fdata["ownerTable"] = "tblstate";
  682. $fdata["Label"]="State";
  683. $fdata["FieldType"]= 200;
  684. $fdata["UseiBox"] = false;
  685. $fdata["EditFormat"]= "Text field";
  686. $fdata["ViewFormat"]= "";
  687. $fdata["NeedEncode"]=true;
  688. $fdata["GoodName"]= "statename";
  689. $fdata["FullName"]= "tblstate.statename";
  690. $fdata["Index"]= 13;
  691. $fdata["EditParams"]="";
  692. $fdata["bListPage"]=true;
  693. $fdata["bInlineAdd"]=true;
  694. $fdata["bInlineEdit"]=true;
  695. $fdata["bViewPage"]=true;
  696. $fdata["bAdvancedSearch"]=true;
  697. $fdata["bPrinterPage"]=true;
  698. $fdata["bExportPage"]=true;
  699. //Begin validation
  700. $fdata["validateAs"] = array();
  701. //End validation
  702. $fdata["FieldPermissions"]=true;
  703. $tdataemploymenntreport["statename"]=$fdata;
  704. $tables_data["employmenntreport"]=&$tdataemploymenntreport;
  705. $field_labels["employmenntreport"] = &$fieldLabelsemploymenntreport;
  706. $fieldToolTips["employmenntreport"] = &$fieldToolTipsemploymenntreport;
  707. // -----------------start prepare master-details data arrays ------------------------------//
  708. // tables which are detail tables for current table (master)
  709. $detailsTablesData["employmenntreport"] = array();
  710. // tables which are master tables for current table (detail)
  711. $masterTablesData["employmenntreport"] = array();
  712. // -----------------end prepare master-details data arrays ------------------------------//
  713. require_once(getabspath("classes/sql.php"));
  714. function createSqlQuery_employmenntreport()
  715. {
  716. $proto0=array();
  717. $proto0["m_strHead"] = "SELECT";
  718. $proto0["m_strFieldList"] = "tblpromotions.personnelno, tblemployee.surname, tblemployee.firstname, tblemployee.othernames, tblemployee.gender, tblrank.name AS CurrentRank, tblrank.name AS EmployedAS, tblfaccentres.fame AS Faculty, tbldepartment.name AS Department, tblcountries.countryname, tbllga.lganame, tblemployee.dateoffirstappointment, tblstate.statename";
  719. $proto0["m_strFrom"] = "FROM tblemployee INNER JOIN tblpromotions ON tblemployee.employeeid = tblpromotions.employeeid INNER JOIN tbldepartment ON tblemployee.department = tbldepartment.departmentid INNER JOIN tblfaccentres ON tbldepartment.facultyid = tblfaccentres.facid INNER JOIN tblcountries ON tblemployee.nationality = tblcountries.countryid INNER JOIN tblstate ON tblcountries.countryid = tblstate.country INNER JOIN tbllga ON tblstate.stateid = tbllga.stateid INNER JOIN tblrank ON tblpromotions.rank = tblrank.rankid AND tblemployee.rankonemployment = tblrank.rankid";
  720. $proto0["m_strWhere"] = "";
  721. $proto0["m_strOrderBy"] = "";
  722. $proto0["m_strTail"] = "";
  723. $proto1=array();
  724. $proto1["m_sql"] = "";
  725. $proto1["m_uniontype"] = "SQLL_UNKNOWN";
  726. $obj = new SQLNonParsed(array(
  727. "m_sql" => ""
  728. ));
  729. $proto1["m_column"]=$obj;
  730. $proto1["m_contained"] = array();
  731. $proto1["m_strCase"] = "";
  732. $proto1["m_havingmode"] = "0";
  733. $proto1["m_inBrackets"] = "0";
  734. $proto1["m_useAlias"] = "0";
  735. $obj = new SQLLogicalExpr($proto1);
  736. $proto0["m_where"] = $obj;
  737. $proto3=array();
  738. $proto3["m_sql"] = "";
  739. $proto3["m_uniontype"] = "SQLL_UNKNOWN";
  740. $obj = new SQLNonParsed(array(
  741. "m_sql" => ""
  742. ));
  743. $proto3["m_column"]=$obj;
  744. $proto3["m_contained"] = array();
  745. $proto3["m_strCase"] = "";
  746. $proto3["m_havingmode"] = "0";
  747. $proto3["m_inBrackets"] = "0";
  748. $proto3["m_useAlias"] = "0";
  749. $obj = new SQLLogicalExpr($proto3);
  750. $proto0["m_having"] = $obj;
  751. $proto0["m_fieldlist"] = array();
  752. $proto5=array();
  753. $obj = new SQLField(array(
  754. "m_strName" => "personnelno",
  755. "m_strTable" => "tblpromotions"
  756. ));
  757. $proto5["m_expr"]=$obj;
  758. $proto5["m_alias"] = "";
  759. $obj = new SQLFieldListItem($proto5);
  760. $proto0["m_fieldlist"][]=$obj;
  761. $proto7=array();
  762. $obj = new SQLField(array(
  763. "m_strName" => "surname",
  764. "m_strTable" => "tblemployee"
  765. ));
  766. $proto7["m_expr"]=$obj;
  767. $proto7["m_alias"] = "";
  768. $obj = new SQLFieldListItem($proto7);
  769. $proto0["m_fieldlist"][]=$obj;
  770. $proto9=array();
  771. $obj = new SQLField(array(
  772. "m_strName" => "firstname",
  773. "m_strTable" => "tblemployee"
  774. ));
  775. $proto9["m_expr"]=$obj;
  776. $proto9["m_alias"] = "";
  777. $obj = new SQLFieldListItem($proto9);
  778. $proto0["m_fieldlist"][]=$obj;
  779. $proto11=array();
  780. $obj = new SQLField(array(
  781. "m_strName" => "othernames",
  782. "m_strTable" => "tblemployee"
  783. ));
  784. $proto11["m_expr"]=$obj;
  785. $proto11["m_alias"] = "";
  786. $obj = new SQLFieldListItem($proto11);
  787. $proto0["m_fieldlist"][]=$obj;
  788. $proto13=array();
  789. $obj = new SQLField(array(
  790. "m_strName" => "gender",
  791. "m_strTable" => "tblemployee"
  792. ));
  793. $proto13["m_expr"]=$obj;
  794. $proto13["m_alias"] = "";
  795. $obj = new SQLFieldListItem($proto13);
  796. $proto0["m_fieldlist"][]=$obj;
  797. $proto15=array();
  798. $obj = new SQLField(array(
  799. "m_strName" => "name",
  800. "m_strTable" => "tblrank"
  801. ));
  802. $proto15["m_expr"]=$obj;
  803. $proto15["m_alias"] = "CurrentRank";
  804. $obj = new SQLFieldListItem($proto15);
  805. $proto0["m_fieldlist"][]=$obj;
  806. $proto17=array();
  807. $obj = new SQLField(array(
  808. "m_strName" => "name",
  809. "m_strTable" => "tblrank"
  810. ));
  811. $proto17["m_expr"]=$obj;
  812. $proto17["m_alias"] = "EmployedAS";
  813. $obj = new SQLFieldListItem($proto17);
  814. $proto0["m_fieldlist"][]=$obj;
  815. $proto19=array();
  816. $obj = new SQLField(array(
  817. "m_strName" => "fame",
  818. "m_strTable" => "tblfaccentres"
  819. ));
  820. $proto19["m_expr"]=$obj;
  821. $proto19["m_alias"] = "Faculty";
  822. $obj = new SQLFieldListItem($proto19);
  823. $proto0["m_fieldlist"][]=$obj;
  824. $proto21=array();
  825. $obj = new SQLField(array(
  826. "m_strName" => "name",
  827. "m_strTable" => "tbldepartment"
  828. ));
  829. $proto21["m_expr"]=$obj;
  830. $proto21["m_alias"] = "Department";
  831. $obj = new SQLFieldListItem($proto21);
  832. $proto0["m_fieldlist"][]=$obj;
  833. $proto23=array();
  834. $obj = new SQLField(array(
  835. "m_strName" => "countryname",
  836. "m_strTable" => "tblcountries"
  837. ));
  838. $proto23["m_expr"]=$obj;
  839. $proto23["m_alias"] = "";
  840. $obj = new SQLFieldListItem($proto23);
  841. $proto0["m_fieldlist"][]=$obj;
  842. $proto25=array();
  843. $obj = new SQLField(array(
  844. "m_strName" => "lganame",
  845. "m_strTable" => "tbllga"
  846. ));
  847. $proto25["m_expr"]=$obj;
  848. $proto25["m_alias"] = "";
  849. $obj = new SQLFieldListItem($proto25);
  850. $proto0["m_fieldlist"][]=$obj;
  851. $proto27=array();
  852. $obj = new SQLField(array(
  853. "m_strName" => "dateoffirstappointment",
  854. "m_strTable" => "tblemployee"
  855. ));
  856. $proto27["m_expr"]=$obj;
  857. $proto27["m_alias"] = "";
  858. $obj = new SQLFieldListItem($proto27);
  859. $proto0["m_fieldlist"][]=$obj;
  860. $proto29=array();
  861. $obj = new SQLField(array(
  862. "m_strName" => "statename",
  863. "m_strTable" => "tblstate"
  864. ));
  865. $proto29["m_expr"]=$obj;
  866. $proto29["m_alias"] = "";
  867. $obj = new SQLFieldListItem($proto29);
  868. $proto0["m_fieldlist"][]=$obj;
  869. $proto0["m_fromlist"] = array();
  870. $proto31=array();
  871. $proto31["m_link"] = "SQLL_MAIN";
  872. $proto32=array();
  873. $proto32["m_strName"] = "tblemployee";
  874. $proto32["m_columns"] = array();
  875. $proto32["m_columns"][] = "employeeid";
  876. $proto32["m_columns"][] = "firstname";
  877. $proto32["m_columns"][] = "surname";
  878. $proto32["m_columns"][] = "othernames";
  879. $proto32["m_columns"][] = "dateoffirstappointment";
  880. $proto32["m_columns"][] = "rankonemployment";
  881. $proto32["m_columns"][] = "salaryonappointment";
  882. $proto32["m_columns"][] = "dateofbirth";
  883. $proto32["m_columns"][] = "nationality";
  884. $proto32["m_columns"][] = "lgaoforigin";
  885. $proto32["m_columns"][] = "placeofbirth";
  886. $proto32["m_columns"][] = "maritalstatus";
  887. $proto32["m_columns"][] = "gender";
  888. $proto32["m_columns"][] = "permanentaddress";
  889. $proto32["m_columns"][] = "department";
  890. $obj = new SQLTable($proto32);
  891. $proto31["m_table"] = $obj;
  892. $proto31["m_alias"] = "";
  893. $proto33=array();
  894. $proto33["m_sql"] = "";
  895. $proto33["m_uniontype"] = "SQLL_UNKNOWN";
  896. $obj = new SQLNonParsed(array(
  897. "m_sql" => ""
  898. ));
  899. $proto33["m_column"]=$obj;
  900. $proto33["m_contained"] = array();
  901. $proto33["m_strCase"] = "";
  902. $proto33["m_havingmode"] = "0";
  903. $proto33["m_inBrackets"] = "0";
  904. $proto33["m_useAlias"] = "0";
  905. $obj = new SQLLogicalExpr($proto33);
  906. $proto31["m_joinon"] = $obj;
  907. $obj = new SQLFromListItem($proto31);
  908. $proto0["m_fromlist"][]=$obj;
  909. $proto35=array();
  910. $proto35["m_link"] = "SQLL_INNERJOIN";
  911. $proto36=array();
  912. $proto36["m_strName"] = "tblpromotions";
  913. $proto36["m_columns"] = array();
  914. $proto36["m_columns"][] = "personnelno";
  915. $proto36["m_columns"][] = "promtiontypeid";
  916. $proto36["m_columns"][] = "rank";
  917. $proto36["m_columns"][] = "salaryid";
  918. $proto36["m_columns"][] = "date";
  919. $proto36["m_columns"][] = "effectivedate";
  920. $proto36["m_columns"][] = "effectivearrears";
  921. $proto36["m_columns"][] = "yearpromoted";
  922. $proto36["m_columns"][] = "employeeid";
  923. $proto36["m_columns"][] = "promotionid";
  924. $obj = new SQLTable($proto36);
  925. $proto35["m_table"] = $obj;
  926. $proto35["m_alias"] = "";
  927. $proto37=array();
  928. $proto37["m_sql"] = "tblemployee.employeeid = tblpromotions.employeeid";
  929. $proto37["m_uniontype"] = "SQLL_UNKNOWN";
  930. $obj = new SQLField(array(
  931. "m_strName" => "employeeid",
  932. "m_strTable" => "tblemployee"
  933. ));
  934. $proto37["m_column"]=$obj;
  935. $proto37["m_contained"] = array();
  936. $proto37["m_strCase"] = "= tblpromotions.employeeid";
  937. $proto37["m_havingmode"] = "0";
  938. $proto37["m_inBrackets"] = "0";
  939. $proto37["m_useAlias"] = "0";
  940. $obj = new SQLLogicalExpr($proto37);
  941. $proto35["m_joinon"] = $obj;
  942. $obj = new SQLFromListItem($proto35);
  943. $proto0["m_fromlist"][]=$obj;
  944. $proto39=array();
  945. $proto39["m_link"] = "SQLL_INNERJOIN";
  946. $proto40=array();
  947. $proto40["m_strName"] = "tbldepartment";
  948. $proto40["m_columns"] = array();
  949. $proto40["m_columns"][] = "departmentid";
  950. $proto40["m_columns"][] = "name";
  951. $proto40["m_columns"][] = "facultyid";
  952. $obj = new SQLTable($proto40);
  953. $proto39["m_table"] = $obj;
  954. $proto39["m_alias"] = "";
  955. $proto41=array();
  956. $proto41["m_sql"] = "tblemployee.department = tbldepartment.departmentid";
  957. $proto41["m_uniontype"] = "SQLL_UNKNOWN";
  958. $obj = new SQLField(array(
  959. "m_strName" => "department",
  960. "m_strTable" => "tblemployee"
  961. ));
  962. $proto41["m_column"]=$obj;
  963. $proto41["m_contained"] = array();
  964. $proto41["m_strCase"] = "= tbldepartment.departmentid";
  965. $proto41["m_havingmode"] = "0";
  966. $proto41["m_inBrackets"] = "0";
  967. $proto41["m_useAlias"] = "0";
  968. $obj = new SQLLogicalExpr($proto41);
  969. $proto39["m_joinon"] = $obj;
  970. $obj = new SQLFromListItem($proto39);
  971. $proto0["m_fromlist"][]=$obj;
  972. $proto43=array();
  973. $proto43["m_link"] = "SQLL_INNERJOIN";
  974. $proto44=array();
  975. $proto44["m_strName"] = "tblfaccentres";
  976. $proto44["m_columns"] = array();
  977. $proto44["m_columns"][] = "facid";
  978. $proto44["m_columns"][] = "fame";
  979. $proto44["m_columns"][] = "complexid";
  980. $obj = new SQLTable($proto44);
  981. $proto43["m_table"] = $obj;
  982. $proto43["m_alias"] = "";
  983. $proto45=array();
  984. $proto45["m_sql"] = "tbldepartment.facultyid = tblfaccentres.facid";
  985. $proto45["m_uniontype"] = "SQLL_UNKNOWN";
  986. $obj = new SQLField(array(
  987. "m_strName" => "facultyid",
  988. "m_strTable" => "tbldepartment"
  989. ));
  990. $proto45["m_column"]=$obj;
  991. $proto45["m_contained"] = array();
  992. $proto45["m_strCase"] = "= tblfaccentres.facid";
  993. $proto45["m_havingmode"] = "0";
  994. $proto45["m_inBrackets"] = "0";
  995. $proto45["m_useAlias"] = "0";
  996. $obj = new SQLLogicalExpr($proto45);
  997. $proto43["m_joinon"] = $obj;
  998. $obj = new SQLFromListItem($proto43);
  999. $proto0["m_fromlist"][]=$obj;
  1000. $proto47=array();
  1001. $proto47["m_link"] = "SQLL_INNERJOIN";
  1002. $proto48=array();
  1003. $proto48["m_strName"] = "tblcountries";
  1004. $proto48["m_columns"] = array();
  1005. $proto48["m_columns"][] = "countryid";
  1006. $proto48["m_columns"][] = "countryname";
  1007. $obj = new SQLTable($proto48);
  1008. $proto47["m_table"] = $obj;
  1009. $proto47["m_alias"] = "";
  1010. $proto49=array();
  1011. $proto49["m_sql"] = "tblemployee.nationality = tblcountries.countryid";
  1012. $proto49["m_uniontype"] = "SQLL_UNKNOWN";
  1013. $obj = new SQLField(array(
  1014. "m_strName" => "nationality",
  1015. "m_strTable" => "tblemployee"
  1016. ));
  1017. $proto49["m_column"]=$obj;
  1018. $proto49["m_contained"] = array();
  1019. $proto49["m_strCase"] = "= tblcountries.countryid";
  1020. $proto49["m_havingmode"] = "0";
  1021. $proto49["m_inBrackets"] = "0";
  1022. $proto49["m_useAlias"] = "0";
  1023. $obj = new SQLLogicalExpr($proto49);
  1024. $proto47["m_joinon"] = $obj;
  1025. $obj = new SQLFromListItem($proto47);
  1026. $proto0["m_fromlist"][]=$obj;
  1027. $proto51=array();
  1028. $proto51["m_link"] = "SQLL_INNERJOIN";
  1029. $proto52=array();
  1030. $proto52["m_strName"] = "tblstate";
  1031. $proto52["m_columns"] = array();
  1032. $proto52["m_columns"][] = "stateid";
  1033. $proto52["m_columns"][] = "country";
  1034. $proto52["m_columns"][] = "statename";
  1035. $obj = new SQLTable($proto52);
  1036. $proto51["m_table"] = $obj;
  1037. $proto51["m_alias"] = "";
  1038. $proto53=array();
  1039. $proto53["m_sql"] = "tblcountries.countryid = tblstate.country";
  1040. $proto53["m_uniontype"] = "SQLL_UNKNOWN";
  1041. $obj = new SQLField(array(
  1042. "m_strName" => "countryid",
  1043. "m_strTable" => "tblcountries"
  1044. ));
  1045. $proto53["m_column"]=$obj;
  1046. $proto53["m_contained"] = array();
  1047. $proto53["m_strCase"] = "= tblstate.country";
  1048. $proto53["m_havingmode"] = "0";
  1049. $proto53["m_inBrackets"] = "0";
  1050. $proto53["m_useAlias"] = "0";
  1051. $obj = new SQLLogicalExpr($proto53);
  1052. $proto51["m_joinon"] = $obj;
  1053. $obj = new SQLFromListItem($proto51);
  1054. $proto0["m_fromlist"][]=$obj;
  1055. $proto55=array();
  1056. $proto55["m_link"] = "SQLL_INNERJOIN";
  1057. $proto56=array();
  1058. $proto56["m_strName"] = "tbllga";
  1059. $proto56["m_columns"] = array();
  1060. $proto56["m_columns"][] = "lgaid";
  1061. $proto56["m_columns"][] = "stateid";
  1062. $proto56["m_columns"][] = "lganame";
  1063. $obj = new SQLTable($proto56);
  1064. $proto55["m_table"] = $obj;
  1065. $proto55["m_alias"] = "";
  1066. $proto57=array();
  1067. $proto57["m_sql"] = "tblstate.stateid = tbllga.stateid";
  1068. $proto57["m_uniontype"] = "SQLL_UNKNOWN";
  1069. $obj = new SQLField(array(
  1070. "m_strName" => "stateid",
  1071. "m_strTable" => "tblstate"
  1072. ));
  1073. $proto57["m_column"]=$obj;
  1074. $proto57["m_contained"] = array();
  1075. $proto57["m_strCase"] = "= tbllga.stateid";
  1076. $proto57["m_havingmode"] = "0";
  1077. $proto57["m_inBrackets"] = "0";
  1078. $proto57["m_useAlias"] = "0";
  1079. $obj = new SQLLogicalExpr($proto57);
  1080. $proto55["m_joinon"] = $obj;
  1081. $obj = new SQLFromListItem($proto55);
  1082. $proto0["m_fromlist"][]=$obj;
  1083. $proto59=array();
  1084. $proto59["m_link"] = "SQLL_INNERJOIN";
  1085. $proto60=array();
  1086. $proto60["m_strName"] = "tblrank";
  1087. $proto60["m_columns"] = array();
  1088. $proto60["m_columns"][] = "rankid";
  1089. $proto60["m_columns"][] = "cadreid";
  1090. $proto60["m_columns"][] = "name";
  1091. $proto60["m_columns"][] = "grade";
  1092. $obj = new SQLTable($proto60);
  1093. $proto59["m_table"] = $obj;
  1094. $proto59["m_alias"] = "";
  1095. $proto61=array();
  1096. $proto61["m_sql"] = "tblpromotions.rank = tblrank.rankid AND tblemployee.rankonemployment = tblrank.rankid";
  1097. $proto61["m_uniontype"] = "SQLL_AND";
  1098. $obj = new SQLNonParsed(array(
  1099. "m_sql" => "tblpromotions.rank = tblrank.rankid AND tblemployee.rankonemployment = tblrank.rankid"
  1100. ));
  1101. $proto61["m_column"]=$obj;
  1102. $proto61["m_contained"] = array();
  1103. $proto63=array();
  1104. $proto63["m_sql"] = "tblpromotions.rank = tblrank.rankid";
  1105. $proto63["m_uniontype"] = "SQLL_UNKNOWN";
  1106. $obj = new SQLField(array(
  1107. "m_strName" => "rank",
  1108. "m_strTable" => "tblpromotions"
  1109. ));
  1110. $proto63["m_column"]=$obj;
  1111. $proto63["m_contained"] = array();
  1112. $proto63["m_strCase"] = "= tblrank.rankid";
  1113. $proto63["m_havingmode"] = "0";
  1114. $proto63["m_inBrackets"] = "0";
  1115. $proto63["m_useAlias"] = "0";
  1116. $obj = new SQLLogicalExpr($proto63);
  1117. $proto61["m_contained"][]=$obj;
  1118. $proto65=array();
  1119. $proto65["m_sql"] = "tblemployee.rankonemployment = tblrank.rankid";
  1120. $proto65["m_uniontype"] = "SQLL_UNKNOWN";
  1121. $obj = new SQLField(array(
  1122. "m_strName" => "rankonemployment",
  1123. "m_strTable" => "tblemployee"
  1124. ));
  1125. $proto65["m_column"]=$obj;
  1126. $proto65["m_contained"] = array();
  1127. $proto65["m_strCase"] = "= tblrank.rankid";
  1128. $proto65["m_havingmode"] = "0";
  1129. $proto65["m_inBrackets"] = "0";
  1130. $proto65["m_useAlias"] = "0";
  1131. $obj = new SQLLogicalExpr($proto65);
  1132. $proto61["m_contained"][]=$obj;
  1133. $proto61["m_strCase"] = "";
  1134. $proto61["m_havingmode"] = "0";
  1135. $proto61["m_inBrackets"] = "0";
  1136. $proto61["m_useAlias"] = "0";
  1137. $obj = new SQLLogicalExpr($proto61);
  1138. $proto59["m_joinon"] = $obj;
  1139. $obj = new SQLFromListItem($proto59);
  1140. $proto0["m_fromlist"][]=$obj;
  1141. $proto0["m_groupby"] = array();
  1142. $proto0["m_orderby"] = array();
  1143. $obj = new SQLQuery($proto0);
  1144. return $obj;
  1145. }
  1146. $queryData_employmenntreport = createSqlQuery_employmenntreport();
  1147. $tdataemploymenntreport[".sqlquery"] = $queryData_employmenntreport;
  1148. $tableEvents["employmenntreport"] = new eventsBase;
  1149. $tdataemploymenntreport[".hasEvents"] = false;
  1150. ?>