PageRenderTime 1709ms CodeModel.GetById 34ms RepoModel.GetById 59ms app.codeStats 36ms

/reports/promotion/output/include/tblemployee_Report_settings.php

https://bitbucket.org/lecturer34/hrmis
PHP | 1448 lines | 863 code | 530 blank | 55 comment | 20 complexity | a22dd6ccf5f841f13b33a7adbf6b713b MD5 | raw file
Possible License(s): LGPL-2.1
  1. <?php
  2. $tdatatblemployee_Report=array();
  3. $tdatatblemployee_Report[".ShortName"]="tblemployee_Report";
  4. $tdatatblemployee_Report[".OwnerID"]="";
  5. $tdatatblemployee_Report[".OriginalTable"]="tblemployee";
  6. // field labels
  7. $fieldLabelstblemployee_Report = array();
  8. if(mlang_getcurrentlang()=="English")
  9. {
  10. $fieldLabelstblemployee_Report["English"]=array();
  11. $fieldToolTipstblemployee_Report["English"]=array();
  12. $fieldLabelstblemployee_Report["English"]["dateoffirstappointment"] = "Date of first appointment";
  13. $fieldToolTipstblemployee_Report["English"]["dateoffirstappointment"] = "";
  14. $fieldLabelstblemployee_Report["English"]["department"] = "Department";
  15. $fieldToolTipstblemployee_Report["English"]["department"] = "";
  16. $fieldLabelstblemployee_Report["English"]["PNo"] = "PNo";
  17. $fieldToolTipstblemployee_Report["English"]["PNo"] = "";
  18. $fieldLabelstblemployee_Report["English"]["Name"] = "Name";
  19. $fieldToolTipstblemployee_Report["English"]["Name"] = "";
  20. $fieldLabelstblemployee_Report["English"]["ranktobepromotedto"] = "Rank to be promoted to";
  21. $fieldToolTipstblemployee_Report["English"]["ranktobepromotedto"] = "";
  22. $fieldLabelstblemployee_Report["English"]["dateoflastpromotion"] = "Date of last promotion";
  23. $fieldToolTipstblemployee_Report["English"]["dateoflastpromotion"] = "";
  24. $fieldLabelstblemployee_Report["English"]["proposedeffectivedate"] = "Proposed effective date";
  25. $fieldToolTipstblemployee_Report["English"]["proposedeffectivedate"] = "";
  26. $fieldLabelstblemployee_Report["English"]["faculty"] = "Faculty";
  27. $fieldToolTipstblemployee_Report["English"]["faculty"] = "";
  28. $fieldLabelstblemployee_Report["English"]["complex"] = "Complex";
  29. $fieldToolTipstblemployee_Report["English"]["complex"] = "";
  30. $fieldLabelstblemployee_Report["English"]["recommendation"] = "Recommendation";
  31. $fieldToolTipstblemployee_Report["English"]["recommendation"] = "";
  32. if (count($fieldToolTipstblemployee_Report["English"])){
  33. $tdatatblemployee_Report[".isUseToolTips"]=true;
  34. }
  35. }
  36. $tdatatblemployee_Report[".NCSearch"]=true;
  37. $tdatatblemployee_Report[".shortTableName"] = "tblemployee_Report";
  38. $tdatatblemployee_Report[".nSecOptions"] = 0;
  39. $tdatatblemployee_Report[".recsPerRowList"] = 1;
  40. $tdatatblemployee_Report[".tableGroupBy"] = "1";
  41. $tdatatblemployee_Report[".mainTableOwnerID"] = "";
  42. $tdatatblemployee_Report[".moveNext"] = 1;
  43. $tdatatblemployee_Report[".showAddInPopup"] = false;
  44. $tdatatblemployee_Report[".showEditInPopup"] = false;
  45. $tdatatblemployee_Report[".showViewInPopup"] = false;
  46. $tdatatblemployee_Report[".fieldsForRegister"] = array();
  47. $tdatatblemployee_Report[".listAjax"] = false;
  48. $tdatatblemployee_Report[".audit"] = false;
  49. $tdatatblemployee_Report[".locking"] = false;
  50. $tdatatblemployee_Report[".listIcons"] = true;
  51. $tdatatblemployee_Report[".edit"] = true;
  52. $tdatatblemployee_Report[".inlineEdit"] = true;
  53. $tdatatblemployee_Report[".view"] = true;
  54. $tdatatblemployee_Report[".exportTo"] = true;
  55. $tdatatblemployee_Report[".printFriendly"] = true;
  56. $tdatatblemployee_Report[".delete"] = true;
  57. $tdatatblemployee_Report[".showSimpleSearchOptions"] = false;
  58. $tdatatblemployee_Report[".showSearchPanel"] = true;
  59. if (isMobile()){
  60. $tdatatblemployee_Report[".isUseAjaxSuggest"] = false;
  61. }else {
  62. $tdatatblemployee_Report[".isUseAjaxSuggest"] = true;
  63. }
  64. // button handlers file names
  65. $tdatatblemployee_Report[".addPageEvents"] = false;
  66. // use datepicker for search panel
  67. $tdatatblemployee_Report[".isUseCalendarForSearch"] = true;
  68. // use timepicker for search panel
  69. $tdatatblemployee_Report[".isUseTimeForSearch"] = false;
  70. $tdatatblemployee_Report[".isUseiBox"] = false;
  71. $tdatatblemployee_Report[".isUseInlineJs"] = $tdatatblemployee_Report[".isUseInlineAdd"] || $tdatatblemployee_Report[".isUseInlineEdit"];
  72. $tdatatblemployee_Report[".allSearchFields"] = array();
  73. $tdatatblemployee_Report[".globSearchFields"][] = "PNo";
  74. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  75. if (!in_array("PNo", $tdatatblemployee_Report[".allSearchFields"]))
  76. {
  77. $tdatatblemployee_Report[".allSearchFields"][] = "PNo";
  78. }
  79. $tdatatblemployee_Report[".globSearchFields"][] = "Name";
  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("Name", $tdatatblemployee_Report[".allSearchFields"]))
  82. {
  83. $tdatatblemployee_Report[".allSearchFields"][] = "Name";
  84. }
  85. $tdatatblemployee_Report[".globSearchFields"][] = "dateoffirstappointment";
  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("dateoffirstappointment", $tdatatblemployee_Report[".allSearchFields"]))
  88. {
  89. $tdatatblemployee_Report[".allSearchFields"][] = "dateoffirstappointment";
  90. }
  91. $tdatatblemployee_Report[".globSearchFields"][] = "ranktobepromotedto";
  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("ranktobepromotedto", $tdatatblemployee_Report[".allSearchFields"]))
  94. {
  95. $tdatatblemployee_Report[".allSearchFields"][] = "ranktobepromotedto";
  96. }
  97. $tdatatblemployee_Report[".globSearchFields"][] = "department";
  98. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  99. if (!in_array("department", $tdatatblemployee_Report[".allSearchFields"]))
  100. {
  101. $tdatatblemployee_Report[".allSearchFields"][] = "department";
  102. }
  103. $tdatatblemployee_Report[".globSearchFields"][] = "dateoflastpromotion";
  104. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  105. if (!in_array("dateoflastpromotion", $tdatatblemployee_Report[".allSearchFields"]))
  106. {
  107. $tdatatblemployee_Report[".allSearchFields"][] = "dateoflastpromotion";
  108. }
  109. $tdatatblemployee_Report[".globSearchFields"][] = "proposedeffectivedate";
  110. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  111. if (!in_array("proposedeffectivedate", $tdatatblemployee_Report[".allSearchFields"]))
  112. {
  113. $tdatatblemployee_Report[".allSearchFields"][] = "proposedeffectivedate";
  114. }
  115. $tdatatblemployee_Report[".globSearchFields"][] = "faculty";
  116. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  117. if (!in_array("faculty", $tdatatblemployee_Report[".allSearchFields"]))
  118. {
  119. $tdatatblemployee_Report[".allSearchFields"][] = "faculty";
  120. }
  121. $tdatatblemployee_Report[".globSearchFields"][] = "complex";
  122. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  123. if (!in_array("complex", $tdatatblemployee_Report[".allSearchFields"]))
  124. {
  125. $tdatatblemployee_Report[".allSearchFields"][] = "complex";
  126. }
  127. $tdatatblemployee_Report[".globSearchFields"][] = "recommendation";
  128. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  129. if (!in_array("recommendation", $tdatatblemployee_Report[".allSearchFields"]))
  130. {
  131. $tdatatblemployee_Report[".allSearchFields"][] = "recommendation";
  132. }
  133. $tdatatblemployee_Report[".googleLikeFields"][] = "PNo";
  134. $tdatatblemployee_Report[".googleLikeFields"][] = "Name";
  135. $tdatatblemployee_Report[".googleLikeFields"][] = "dateoffirstappointment";
  136. $tdatatblemployee_Report[".googleLikeFields"][] = "ranktobepromotedto";
  137. $tdatatblemployee_Report[".googleLikeFields"][] = "department";
  138. $tdatatblemployee_Report[".googleLikeFields"][] = "dateoflastpromotion";
  139. $tdatatblemployee_Report[".googleLikeFields"][] = "proposedeffectivedate";
  140. $tdatatblemployee_Report[".googleLikeFields"][] = "faculty";
  141. $tdatatblemployee_Report[".googleLikeFields"][] = "complex";
  142. $tdatatblemployee_Report[".googleLikeFields"][] = "recommendation";
  143. $tdatatblemployee_Report[".advSearchFields"][] = "ranktobepromotedto";
  144. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  145. if (!in_array("ranktobepromotedto", $tdatatblemployee_Report[".allSearchFields"]))
  146. {
  147. $tdatatblemployee_Report[".allSearchFields"][] = "ranktobepromotedto";
  148. }
  149. $tdatatblemployee_Report[".advSearchFields"][] = "department";
  150. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  151. if (!in_array("department", $tdatatblemployee_Report[".allSearchFields"]))
  152. {
  153. $tdatatblemployee_Report[".allSearchFields"][] = "department";
  154. }
  155. $tdatatblemployee_Report[".advSearchFields"][] = "faculty";
  156. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  157. if (!in_array("faculty", $tdatatblemployee_Report[".allSearchFields"]))
  158. {
  159. $tdatatblemployee_Report[".allSearchFields"][] = "faculty";
  160. }
  161. $tdatatblemployee_Report[".advSearchFields"][] = "complex";
  162. // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
  163. if (!in_array("complex", $tdatatblemployee_Report[".allSearchFields"]))
  164. {
  165. $tdatatblemployee_Report[".allSearchFields"][] = "complex";
  166. }
  167. $tdatatblemployee_Report[".isTableType"] = "report";
  168. // Access doesn't support subqueries from the same table as main
  169. $tdatatblemployee_Report[".subQueriesSupAccess"] = true;
  170. $gstrOrderBy = "";
  171. if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
  172. $gstrOrderBy = "order by ".$gstrOrderBy;
  173. $tdatatblemployee_Report[".strOrderBy"] = $gstrOrderBy;
  174. $tdatatblemployee_Report[".orderindexes"] = array();
  175. $tdatatblemployee_Report[".sqlHead"] = "SELECT tblpromotions.personnelno AS PNo, CONCAT(UPPER(`tblemployee`.`surname`), ', ', `tblemployee`.`firstname`, ' ', `tblemployee`.`othernames`) AS Name, tblemployee.dateoffirstappointment AS dateoffirstappointment, tblrank.name AS ranktobepromotedto, tbldepartment.name AS department, MAX(tblpromotions.effectivedate) AS dateoflastpromotion, tblrecommendations.effectivedate AS proposedeffectivedate, tblfaccentres.name AS faculty, tblcomplex.name AS complex, tblrecommendations.recommendation AS recommendation";
  176. $tdatatblemployee_Report[".sqlFrom"] = "FROM tblemployee INNER JOIN tblpromotions ON tblemployee.employeeid = tblpromotions.employeeid INNER JOIN tblrecommendations ON tblemployee.employeeid = tblrecommendations.employeeid INNER JOIN tblrank ON tblrecommendations.rankinview = tblrank.rankid INNER JOIN tbldepartment ON tblemployee.department = tbldepartment.deptid INNER JOIN tblfaccentres ON tbldepartment.facid = tblfaccentres.facid INNER JOIN tblcomplex ON tblfaccentres.complexid = tblcomplex.complexid";
  177. $tdatatblemployee_Report[".sqlWhereExpr"] = "(recommendation = 'not recommended')";
  178. $tdatatblemployee_Report[".sqlTail"] = "GROUP BY tblpromotions.personnelno";
  179. //fill array of records per page for list and report without group fields
  180. $arrRPP = array();
  181. $arrRPP[] = 10;
  182. $arrRPP[] = 20;
  183. $arrRPP[] = 30;
  184. $arrRPP[] = 50;
  185. $arrRPP[] = 100;
  186. $arrRPP[] = 500;
  187. $arrRPP[] = -1;
  188. $tdatatblemployee_Report[".arrRecsPerPage"] = $arrRPP;
  189. //fill array of groups per page for report with group fields
  190. $arrGPP = array();
  191. $arrGPP[] = 1;
  192. $arrGPP[] = 3;
  193. $arrGPP[] = 5;
  194. $arrGPP[] = 10;
  195. $arrGPP[] = 50;
  196. $arrGPP[] = 100;
  197. $arrGPP[] = -1;
  198. $tdatatblemployee_Report[".arrGroupsPerPage"] = $arrGPP;
  199. $tableKeys = array();
  200. $tdatatblemployee_Report[".Keys"] = $tableKeys;
  201. $tdatatblemployee_Report[".listFields"] = array();
  202. $tdatatblemployee_Report[".listFields"][] = "PNo";
  203. $tdatatblemployee_Report[".listFields"][] = "Name";
  204. $tdatatblemployee_Report[".listFields"][] = "dateoffirstappointment";
  205. $tdatatblemployee_Report[".listFields"][] = "ranktobepromotedto";
  206. $tdatatblemployee_Report[".listFields"][] = "department";
  207. $tdatatblemployee_Report[".listFields"][] = "dateoflastpromotion";
  208. $tdatatblemployee_Report[".listFields"][] = "proposedeffectivedate";
  209. $tdatatblemployee_Report[".listFields"][] = "faculty";
  210. $tdatatblemployee_Report[".listFields"][] = "complex";
  211. $tdatatblemployee_Report[".listFields"][] = "recommendation";
  212. $tdatatblemployee_Report[".addFields"] = array();
  213. $tdatatblemployee_Report[".addFields"][] = "dateoffirstappointment";
  214. $tdatatblemployee_Report[".addFields"][] = "department";
  215. $tdatatblemployee_Report[".inlineAddFields"] = array();
  216. $tdatatblemployee_Report[".inlineAddFields"][] = "PNo";
  217. $tdatatblemployee_Report[".inlineAddFields"][] = "Name";
  218. $tdatatblemployee_Report[".inlineAddFields"][] = "dateoffirstappointment";
  219. $tdatatblemployee_Report[".inlineAddFields"][] = "ranktobepromotedto";
  220. $tdatatblemployee_Report[".inlineAddFields"][] = "department";
  221. $tdatatblemployee_Report[".inlineAddFields"][] = "dateoflastpromotion";
  222. $tdatatblemployee_Report[".inlineAddFields"][] = "proposedeffectivedate";
  223. $tdatatblemployee_Report[".inlineAddFields"][] = "faculty";
  224. $tdatatblemployee_Report[".inlineAddFields"][] = "complex";
  225. $tdatatblemployee_Report[".inlineAddFields"][] = "recommendation";
  226. $tdatatblemployee_Report[".editFields"] = array();
  227. $tdatatblemployee_Report[".editFields"][] = "dateoffirstappointment";
  228. $tdatatblemployee_Report[".editFields"][] = "department";
  229. $tdatatblemployee_Report[".inlineEditFields"] = array();
  230. $tdatatblemployee_Report[".inlineEditFields"][] = "PNo";
  231. $tdatatblemployee_Report[".inlineEditFields"][] = "Name";
  232. $tdatatblemployee_Report[".inlineEditFields"][] = "dateoffirstappointment";
  233. $tdatatblemployee_Report[".inlineEditFields"][] = "ranktobepromotedto";
  234. $tdatatblemployee_Report[".inlineEditFields"][] = "department";
  235. $tdatatblemployee_Report[".inlineEditFields"][] = "dateoflastpromotion";
  236. $tdatatblemployee_Report[".inlineEditFields"][] = "proposedeffectivedate";
  237. $tdatatblemployee_Report[".inlineEditFields"][] = "faculty";
  238. $tdatatblemployee_Report[".inlineEditFields"][] = "complex";
  239. $tdatatblemployee_Report[".inlineEditFields"][] = "recommendation";
  240. // PNo
  241. $fdata = array();
  242. $fdata["strName"] = "PNo";
  243. $fdata["ownerTable"] = "tblpromotions";
  244. $fdata["Label"]="PNo";
  245. $fdata["FieldType"]= 200;
  246. $fdata["UseiBox"] = false;
  247. $fdata["EditFormat"]= "Text field";
  248. $fdata["ViewFormat"]= "";
  249. $fdata["NeedEncode"]=true;
  250. $fdata["GoodName"]= "PNo";
  251. $fdata["FullName"]= "tblpromotions.personnelno";
  252. $fdata["Index"]= 1;
  253. $fdata["EditParams"]="";
  254. $fdata["bListPage"]=true;
  255. $fdata["bInlineAdd"]=true;
  256. $fdata["bInlineEdit"]=true;
  257. $fdata["bViewPage"]=true;
  258. $fdata["bAdvancedSearch"]=true;
  259. $fdata["bPrinterPage"]=true;
  260. $fdata["bExportPage"]=true;
  261. //Begin validation
  262. $fdata["validateAs"] = array();
  263. //End validation
  264. $fdata["FieldPermissions"]=true;
  265. $tdatatblemployee_Report["PNo"]=$fdata;
  266. // Name
  267. $fdata = array();
  268. $fdata["strName"] = "Name";
  269. $fdata["ownerTable"] = "";
  270. $fdata["Label"]="Name";
  271. $fdata["FieldType"]= 200;
  272. $fdata["UseiBox"] = false;
  273. $fdata["EditFormat"]= "Text field";
  274. $fdata["ViewFormat"]= "";
  275. $fdata["NeedEncode"]=true;
  276. $fdata["GoodName"]= "Name";
  277. $fdata["FullName"]= "CONCAT(UPPER(`tblemployee`.`surname`), ', ', `tblemployee`.`firstname`, ' ', `tblemployee`.`othernames`)";
  278. $fdata["Index"]= 2;
  279. $fdata["EditParams"]="";
  280. $fdata["bListPage"]=true;
  281. $fdata["bInlineAdd"]=true;
  282. $fdata["bInlineEdit"]=true;
  283. $fdata["bViewPage"]=true;
  284. $fdata["bAdvancedSearch"]=true;
  285. $fdata["bPrinterPage"]=true;
  286. $fdata["bExportPage"]=true;
  287. //Begin validation
  288. $fdata["validateAs"] = array();
  289. //End validation
  290. $fdata["FieldPermissions"]=true;
  291. $tdatatblemployee_Report["Name"]=$fdata;
  292. // dateoffirstappointment
  293. $fdata = array();
  294. $fdata["strName"] = "dateoffirstappointment";
  295. $fdata["ownerTable"] = "tblemployee";
  296. $fdata["Label"]="Date of first appointment";
  297. $fdata["FieldType"]= 7;
  298. $fdata["UseiBox"] = false;
  299. $fdata["EditFormat"]= "Date";
  300. $fdata["ViewFormat"]= "Short Date";
  301. $fdata["NeedEncode"]=true;
  302. $fdata["GoodName"]= "dateoffirstappointment";
  303. $fdata["FullName"]= "tblemployee.dateoffirstappointment";
  304. $fdata["IsRequired"]=true;
  305. $fdata["Index"]= 3;
  306. $fdata["DateEditType"] = 13;
  307. $fdata["InitialYearFactor"] = 100;
  308. $fdata["LastYearFactor"] = 10;
  309. $fdata["bListPage"]=true;
  310. $fdata["bAddPage"]=true;
  311. $fdata["bInlineAdd"]=true;
  312. $fdata["bEditPage"]=true;
  313. $fdata["bInlineEdit"]=true;
  314. $fdata["bViewPage"]=true;
  315. $fdata["bAdvancedSearch"]=true;
  316. $fdata["bPrinterPage"]=true;
  317. $fdata["bExportPage"]=true;
  318. //Begin validation
  319. $fdata["validateAs"] = array();
  320. $fdata["validateAs"]["basicValidate"][] = "IsRequired";
  321. //End validation
  322. $fdata["FieldPermissions"]=true;
  323. $tdatatblemployee_Report["dateoffirstappointment"]=$fdata;
  324. // ranktobepromotedto
  325. $fdata = array();
  326. $fdata["strName"] = "ranktobepromotedto";
  327. $fdata["ownerTable"] = "tblrank";
  328. $fdata["Label"]="Rank to be promoted to";
  329. $fdata["FieldType"]= 200;
  330. $fdata["UseiBox"] = false;
  331. $fdata["EditFormat"]= "Text field";
  332. $fdata["ViewFormat"]= "";
  333. $fdata["NeedEncode"]=true;
  334. $fdata["GoodName"]= "ranktobepromotedto";
  335. $fdata["FullName"]= "tblrank.name";
  336. $fdata["Index"]= 4;
  337. $fdata["EditParams"]="";
  338. $fdata["bListPage"]=true;
  339. $fdata["bInlineAdd"]=true;
  340. $fdata["bInlineEdit"]=true;
  341. $fdata["bViewPage"]=true;
  342. $fdata["bAdvancedSearch"]=true;
  343. $fdata["bPrinterPage"]=true;
  344. $fdata["bExportPage"]=true;
  345. //Begin validation
  346. $fdata["validateAs"] = array();
  347. //End validation
  348. $fdata["FieldPermissions"]=true;
  349. $tdatatblemployee_Report["ranktobepromotedto"]=$fdata;
  350. // department
  351. $fdata = array();
  352. $fdata["strName"] = "department";
  353. $fdata["ownerTable"] = "tbldepartment";
  354. $fdata["Label"]="Department";
  355. $fdata["FieldType"]= 200;
  356. $fdata["UseiBox"] = false;
  357. $fdata["EditFormat"]= "Text field";
  358. $fdata["ViewFormat"]= "";
  359. $fdata["NeedEncode"]=true;
  360. $fdata["GoodName"]= "department";
  361. $fdata["FullName"]= "tbldepartment.name";
  362. $fdata["Index"]= 5;
  363. $fdata["EditParams"]="";
  364. $fdata["bListPage"]=true;
  365. $fdata["bAddPage"]=true;
  366. $fdata["bInlineAdd"]=true;
  367. $fdata["bEditPage"]=true;
  368. $fdata["bInlineEdit"]=true;
  369. $fdata["bViewPage"]=true;
  370. $fdata["bAdvancedSearch"]=true;
  371. $fdata["bPrinterPage"]=true;
  372. $fdata["bExportPage"]=true;
  373. //Begin validation
  374. $fdata["validateAs"] = array();
  375. //End validation
  376. $fdata["FieldPermissions"]=true;
  377. $tdatatblemployee_Report["department"]=$fdata;
  378. // dateoflastpromotion
  379. $fdata = array();
  380. $fdata["strName"] = "dateoflastpromotion";
  381. $fdata["ownerTable"] = "";
  382. $fdata["Label"]="Date of last promotion";
  383. $fdata["FieldType"]= 7;
  384. $fdata["UseiBox"] = false;
  385. $fdata["EditFormat"]= "Date";
  386. $fdata["ViewFormat"]= "Short Date";
  387. $fdata["NeedEncode"]=true;
  388. $fdata["GoodName"]= "dateoflastpromotion";
  389. $fdata["FullName"]= "MAX(tblpromotions.effectivedate)";
  390. $fdata["Index"]= 6;
  391. $fdata["DateEditType"] = 13;
  392. $fdata["InitialYearFactor"] = 100;
  393. $fdata["LastYearFactor"] = 10;
  394. $fdata["bListPage"]=true;
  395. $fdata["bInlineAdd"]=true;
  396. $fdata["bInlineEdit"]=true;
  397. $fdata["bViewPage"]=true;
  398. $fdata["bAdvancedSearch"]=true;
  399. $fdata["bPrinterPage"]=true;
  400. $fdata["bExportPage"]=true;
  401. //Begin validation
  402. $fdata["validateAs"] = array();
  403. //End validation
  404. $fdata["FieldPermissions"]=true;
  405. $tdatatblemployee_Report["dateoflastpromotion"]=$fdata;
  406. // proposedeffectivedate
  407. $fdata = array();
  408. $fdata["strName"] = "proposedeffectivedate";
  409. $fdata["ownerTable"] = "tblrecommendations";
  410. $fdata["Label"]="Proposed effective date";
  411. $fdata["FieldType"]= 7;
  412. $fdata["UseiBox"] = false;
  413. $fdata["EditFormat"]= "Date";
  414. $fdata["ViewFormat"]= "Short Date";
  415. $fdata["NeedEncode"]=true;
  416. $fdata["GoodName"]= "proposedeffectivedate";
  417. $fdata["FullName"]= "tblrecommendations.effectivedate";
  418. $fdata["Index"]= 7;
  419. $fdata["DateEditType"] = 13;
  420. $fdata["InitialYearFactor"] = 100;
  421. $fdata["LastYearFactor"] = 10;
  422. $fdata["bListPage"]=true;
  423. $fdata["bInlineAdd"]=true;
  424. $fdata["bInlineEdit"]=true;
  425. $fdata["bViewPage"]=true;
  426. $fdata["bAdvancedSearch"]=true;
  427. $fdata["bPrinterPage"]=true;
  428. $fdata["bExportPage"]=true;
  429. //Begin validation
  430. $fdata["validateAs"] = array();
  431. //End validation
  432. $tdatatblemployee_Report["proposedeffectivedate"]=$fdata;
  433. // faculty
  434. $fdata = array();
  435. $fdata["strName"] = "faculty";
  436. $fdata["ownerTable"] = "tblfaccentres";
  437. $fdata["Label"]="Faculty";
  438. $fdata["FieldType"]= 200;
  439. $fdata["UseiBox"] = false;
  440. $fdata["EditFormat"]= "Text field";
  441. $fdata["ViewFormat"]= "";
  442. $fdata["NeedEncode"]=true;
  443. $fdata["GoodName"]= "faculty";
  444. $fdata["FullName"]= "tblfaccentres.name";
  445. $fdata["Index"]= 8;
  446. $fdata["EditParams"]="";
  447. $fdata["bListPage"]=true;
  448. $fdata["bInlineAdd"]=true;
  449. $fdata["bInlineEdit"]=true;
  450. $fdata["bViewPage"]=true;
  451. $fdata["bAdvancedSearch"]=true;
  452. $fdata["bPrinterPage"]=true;
  453. $fdata["bExportPage"]=true;
  454. //Begin validation
  455. $fdata["validateAs"] = array();
  456. //End validation
  457. $tdatatblemployee_Report["faculty"]=$fdata;
  458. // complex
  459. $fdata = array();
  460. $fdata["strName"] = "complex";
  461. $fdata["ownerTable"] = "tblcomplex";
  462. $fdata["Label"]="Complex";
  463. $fdata["FieldType"]= 200;
  464. $fdata["UseiBox"] = false;
  465. $fdata["EditFormat"]= "Text field";
  466. $fdata["ViewFormat"]= "";
  467. $fdata["NeedEncode"]=true;
  468. $fdata["GoodName"]= "complex";
  469. $fdata["FullName"]= "tblcomplex.name";
  470. $fdata["Index"]= 9;
  471. $fdata["EditParams"]="";
  472. $fdata["bListPage"]=true;
  473. $fdata["bInlineAdd"]=true;
  474. $fdata["bInlineEdit"]=true;
  475. $fdata["bViewPage"]=true;
  476. $fdata["bAdvancedSearch"]=true;
  477. $fdata["bPrinterPage"]=true;
  478. $fdata["bExportPage"]=true;
  479. //Begin validation
  480. $fdata["validateAs"] = array();
  481. //End validation
  482. $tdatatblemployee_Report["complex"]=$fdata;
  483. // recommendation
  484. $fdata = array();
  485. $fdata["strName"] = "recommendation";
  486. $fdata["ownerTable"] = "tblrecommendations";
  487. $fdata["Label"]="Recommendation";
  488. $fdata["FieldType"]= 129;
  489. $fdata["UseiBox"] = false;
  490. $fdata["EditFormat"]= "Text field";
  491. $fdata["ViewFormat"]= "";
  492. $fdata["NeedEncode"]=true;
  493. $fdata["GoodName"]= "recommendation";
  494. $fdata["FullName"]= "tblrecommendations.recommendation";
  495. $fdata["Index"]= 10;
  496. $fdata["EditParams"]="";
  497. $fdata["bListPage"]=true;
  498. $fdata["bInlineAdd"]=true;
  499. $fdata["bInlineEdit"]=true;
  500. $fdata["bViewPage"]=true;
  501. $fdata["bAdvancedSearch"]=true;
  502. $fdata["bPrinterPage"]=true;
  503. $fdata["bExportPage"]=true;
  504. //Begin validation
  505. $fdata["validateAs"] = array();
  506. //End validation
  507. $fdata["FieldPermissions"]=true;
  508. $tdatatblemployee_Report["recommendation"]=$fdata;
  509. $tables_data["tblemployee Report"]=&$tdatatblemployee_Report;
  510. $field_labels["tblemployee_Report"] = &$fieldLabelstblemployee_Report;
  511. $fieldToolTips["tblemployee Report"] = &$fieldToolTipstblemployee_Report;
  512. // -----------------start prepare master-details data arrays ------------------------------//
  513. // tables which are detail tables for current table (master)
  514. $detailsTablesData["tblemployee Report"] = array();
  515. // tables which are master tables for current table (detail)
  516. $masterTablesData["tblemployee Report"] = array();
  517. // -----------------end prepare master-details data arrays ------------------------------//
  518. require_once(getabspath("classes/sql.php"));
  519. function createSqlQuery_tblemployee_Report()
  520. {
  521. $proto0=array();
  522. $proto0["m_strHead"] = "SELECT";
  523. $proto0["m_strFieldList"] = "tblpromotions.personnelno AS PNo, CONCAT(UPPER(`tblemployee`.`surname`), ', ', `tblemployee`.`firstname`, ' ', `tblemployee`.`othernames`) AS Name, tblemployee.dateoffirstappointment AS dateoffirstappointment, tblrank.name AS ranktobepromotedto, tbldepartment.name AS department, MAX(tblpromotions.effectivedate) AS dateoflastpromotion, tblrecommendations.effectivedate AS proposedeffectivedate, tblfaccentres.name AS faculty, tblcomplex.name AS complex, tblrecommendations.recommendation AS recommendation";
  524. $proto0["m_strFrom"] = "FROM tblemployee INNER JOIN tblpromotions ON tblemployee.employeeid = tblpromotions.employeeid INNER JOIN tblrecommendations ON tblemployee.employeeid = tblrecommendations.employeeid INNER JOIN tblrank ON tblrecommendations.rankinview = tblrank.rankid INNER JOIN tbldepartment ON tblemployee.department = tbldepartment.deptid INNER JOIN tblfaccentres ON tbldepartment.facid = tblfaccentres.facid INNER JOIN tblcomplex ON tblfaccentres.complexid = tblcomplex.complexid";
  525. $proto0["m_strWhere"] = "(recommendation = 'not recommended')";
  526. $proto0["m_strOrderBy"] = "";
  527. $proto0["m_strTail"] = "GROUP BY tblpromotions.personnelno";
  528. $proto1=array();
  529. $proto1["m_sql"] = "recommendation = 'not recommended'";
  530. $proto1["m_uniontype"] = "SQLL_UNKNOWN";
  531. $obj = new SQLNonParsed(array(
  532. "m_sql" => "recommendation"
  533. ));
  534. $proto1["m_column"]=$obj;
  535. $proto1["m_contained"] = array();
  536. $proto1["m_strCase"] = "= 'not recommended'";
  537. $proto1["m_havingmode"] = "0";
  538. $proto1["m_inBrackets"] = "0";
  539. $proto1["m_useAlias"] = "0";
  540. $obj = new SQLLogicalExpr($proto1);
  541. $proto0["m_where"] = $obj;
  542. $proto3=array();
  543. $proto3["m_sql"] = "";
  544. $proto3["m_uniontype"] = "SQLL_UNKNOWN";
  545. $obj = new SQLNonParsed(array(
  546. "m_sql" => ""
  547. ));
  548. $proto3["m_column"]=$obj;
  549. $proto3["m_contained"] = array();
  550. $proto3["m_strCase"] = "";
  551. $proto3["m_havingmode"] = "0";
  552. $proto3["m_inBrackets"] = "0";
  553. $proto3["m_useAlias"] = "0";
  554. $obj = new SQLLogicalExpr($proto3);
  555. $proto0["m_having"] = $obj;
  556. $proto0["m_fieldlist"] = array();
  557. $proto5=array();
  558. $obj = new SQLField(array(
  559. "m_strName" => "personnelno",
  560. "m_strTable" => "tblpromotions"
  561. ));
  562. $proto5["m_expr"]=$obj;
  563. $proto5["m_alias"] = "PNo";
  564. $obj = new SQLFieldListItem($proto5);
  565. $proto0["m_fieldlist"][]=$obj;
  566. $proto7=array();
  567. $proto8=array();
  568. $proto8["m_functiontype"] = "SQLF_CUSTOM";
  569. $proto8["m_arguments"] = array();
  570. $obj = new SQLNonParsed(array(
  571. "m_sql" => "UPPER(`tblemployee`.`surname`)"
  572. ));
  573. $proto8["m_arguments"][]=$obj;
  574. $obj = new SQLNonParsed(array(
  575. "m_sql" => "', '"
  576. ));
  577. $proto8["m_arguments"][]=$obj;
  578. $obj = new SQLNonParsed(array(
  579. "m_sql" => "`tblemployee`.`firstname`"
  580. ));
  581. $proto8["m_arguments"][]=$obj;
  582. $obj = new SQLNonParsed(array(
  583. "m_sql" => "' '"
  584. ));
  585. $proto8["m_arguments"][]=$obj;
  586. $obj = new SQLNonParsed(array(
  587. "m_sql" => "`tblemployee`.`othernames`"
  588. ));
  589. $proto8["m_arguments"][]=$obj;
  590. $proto8["m_strFunctionName"] = "CONCAT";
  591. $obj = new SQLFunctionCall($proto8);
  592. $proto7["m_expr"]=$obj;
  593. $proto7["m_alias"] = "Name";
  594. $obj = new SQLFieldListItem($proto7);
  595. $proto0["m_fieldlist"][]=$obj;
  596. $proto14=array();
  597. $obj = new SQLField(array(
  598. "m_strName" => "dateoffirstappointment",
  599. "m_strTable" => "tblemployee"
  600. ));
  601. $proto14["m_expr"]=$obj;
  602. $proto14["m_alias"] = "dateoffirstappointment";
  603. $obj = new SQLFieldListItem($proto14);
  604. $proto0["m_fieldlist"][]=$obj;
  605. $proto16=array();
  606. $obj = new SQLField(array(
  607. "m_strName" => "name",
  608. "m_strTable" => "tblrank"
  609. ));
  610. $proto16["m_expr"]=$obj;
  611. $proto16["m_alias"] = "ranktobepromotedto";
  612. $obj = new SQLFieldListItem($proto16);
  613. $proto0["m_fieldlist"][]=$obj;
  614. $proto18=array();
  615. $obj = new SQLField(array(
  616. "m_strName" => "name",
  617. "m_strTable" => "tbldepartment"
  618. ));
  619. $proto18["m_expr"]=$obj;
  620. $proto18["m_alias"] = "department";
  621. $obj = new SQLFieldListItem($proto18);
  622. $proto0["m_fieldlist"][]=$obj;
  623. $proto20=array();
  624. $proto21=array();
  625. $proto21["m_functiontype"] = "SQLF_MAX";
  626. $proto21["m_arguments"] = array();
  627. $obj = new SQLField(array(
  628. "m_strName" => "effectivedate",
  629. "m_strTable" => "tblpromotions"
  630. ));
  631. $proto21["m_arguments"][]=$obj;
  632. $proto21["m_strFunctionName"] = "MAX";
  633. $obj = new SQLFunctionCall($proto21);
  634. $proto20["m_expr"]=$obj;
  635. $proto20["m_alias"] = "dateoflastpromotion";
  636. $obj = new SQLFieldListItem($proto20);
  637. $proto0["m_fieldlist"][]=$obj;
  638. $proto23=array();
  639. $obj = new SQLField(array(
  640. "m_strName" => "effectivedate",
  641. "m_strTable" => "tblrecommendations"
  642. ));
  643. $proto23["m_expr"]=$obj;
  644. $proto23["m_alias"] = "proposedeffectivedate";
  645. $obj = new SQLFieldListItem($proto23);
  646. $proto0["m_fieldlist"][]=$obj;
  647. $proto25=array();
  648. $obj = new SQLField(array(
  649. "m_strName" => "name",
  650. "m_strTable" => "tblfaccentres"
  651. ));
  652. $proto25["m_expr"]=$obj;
  653. $proto25["m_alias"] = "faculty";
  654. $obj = new SQLFieldListItem($proto25);
  655. $proto0["m_fieldlist"][]=$obj;
  656. $proto27=array();
  657. $obj = new SQLField(array(
  658. "m_strName" => "name",
  659. "m_strTable" => "tblcomplex"
  660. ));
  661. $proto27["m_expr"]=$obj;
  662. $proto27["m_alias"] = "complex";
  663. $obj = new SQLFieldListItem($proto27);
  664. $proto0["m_fieldlist"][]=$obj;
  665. $proto29=array();
  666. $obj = new SQLField(array(
  667. "m_strName" => "recommendation",
  668. "m_strTable" => "tblrecommendations"
  669. ));
  670. $proto29["m_expr"]=$obj;
  671. $proto29["m_alias"] = "recommendation";
  672. $obj = new SQLFieldListItem($proto29);
  673. $proto0["m_fieldlist"][]=$obj;
  674. $proto0["m_fromlist"] = array();
  675. $proto31=array();
  676. $proto31["m_link"] = "SQLL_MAIN";
  677. $proto32=array();
  678. $proto32["m_strName"] = "tblemployee";
  679. $proto32["m_columns"] = array();
  680. $proto32["m_columns"][] = "employeeid";
  681. $proto32["m_columns"][] = "firstname";
  682. $proto32["m_columns"][] = "surname";
  683. $proto32["m_columns"][] = "othernames";
  684. $proto32["m_columns"][] = "dateoffirstappointment";
  685. $proto32["m_columns"][] = "rankonemployment";
  686. $proto32["m_columns"][] = "salaryonappointment";
  687. $proto32["m_columns"][] = "dateofbirth";
  688. $proto32["m_columns"][] = "nationality";
  689. $proto32["m_columns"][] = "lgaoforigin";
  690. $proto32["m_columns"][] = "placeofbirth";
  691. $proto32["m_columns"][] = "maritalstatus";
  692. $proto32["m_columns"][] = "gender";
  693. $proto32["m_columns"][] = "permanentaddress";
  694. $proto32["m_columns"][] = "department";
  695. $obj = new SQLTable($proto32);
  696. $proto31["m_table"] = $obj;
  697. $proto31["m_alias"] = "";
  698. $proto33=array();
  699. $proto33["m_sql"] = "";
  700. $proto33["m_uniontype"] = "SQLL_UNKNOWN";
  701. $obj = new SQLNonParsed(array(
  702. "m_sql" => ""
  703. ));
  704. $proto33["m_column"]=$obj;
  705. $proto33["m_contained"] = array();
  706. $proto33["m_strCase"] = "";
  707. $proto33["m_havingmode"] = "0";
  708. $proto33["m_inBrackets"] = "0";
  709. $proto33["m_useAlias"] = "0";
  710. $obj = new SQLLogicalExpr($proto33);
  711. $proto31["m_joinon"] = $obj;
  712. $obj = new SQLFromListItem($proto31);
  713. $proto0["m_fromlist"][]=$obj;
  714. $proto35=array();
  715. $proto35["m_link"] = "SQLL_INNERJOIN";
  716. $proto36=array();
  717. $proto36["m_strName"] = "tblpromotions";
  718. $proto36["m_columns"] = array();
  719. $proto36["m_columns"][] = "personnelno";
  720. $proto36["m_columns"][] = "promtiontypeid";
  721. $proto36["m_columns"][] = "rank";
  722. $proto36["m_columns"][] = "salaryid";
  723. $proto36["m_columns"][] = "step";
  724. $proto36["m_columns"][] = "promotionrank_level";
  725. $proto36["m_columns"][] = "date";
  726. $proto36["m_columns"][] = "effectivedate";
  727. $proto36["m_columns"][] = "effectivearrears";
  728. $proto36["m_columns"][] = "yearpromoted";
  729. $proto36["m_columns"][] = "employeeid";
  730. $proto36["m_columns"][] = "promotionid";
  731. $obj = new SQLTable($proto36);
  732. $proto35["m_table"] = $obj;
  733. $proto35["m_alias"] = "";
  734. $proto37=array();
  735. $proto37["m_sql"] = "tblemployee.employeeid = tblpromotions.employeeid";
  736. $proto37["m_uniontype"] = "SQLL_UNKNOWN";
  737. $obj = new SQLField(array(
  738. "m_strName" => "employeeid",
  739. "m_strTable" => "tblemployee"
  740. ));
  741. $proto37["m_column"]=$obj;
  742. $proto37["m_contained"] = array();
  743. $proto37["m_strCase"] = "= tblpromotions.employeeid";
  744. $proto37["m_havingmode"] = "0";
  745. $proto37["m_inBrackets"] = "0";
  746. $proto37["m_useAlias"] = "0";
  747. $obj = new SQLLogicalExpr($proto37);
  748. $proto35["m_joinon"] = $obj;
  749. $obj = new SQLFromListItem($proto35);
  750. $proto0["m_fromlist"][]=$obj;
  751. $proto39=array();
  752. $proto39["m_link"] = "SQLL_INNERJOIN";
  753. $proto40=array();
  754. $proto40["m_strName"] = "tblrecommendations";
  755. $proto40["m_columns"] = array();
  756. $proto40["m_columns"][] = "recommedationid";
  757. $proto40["m_columns"][] = "employeeid";
  758. $proto40["m_columns"][] = "rankinview";
  759. $proto40["m_columns"][] = "recommendedby";
  760. $proto40["m_columns"][] = "remark";
  761. $proto40["m_columns"][] = "year";
  762. $proto40["m_columns"][] = "daterecommended";
  763. $proto40["m_columns"][] = "recommendation";
  764. $proto40["m_columns"][] = "complexdecision";
  765. $proto40["m_columns"][] = "complexdecisiondate";
  766. $proto40["m_columns"][] = "capcdecision";
  767. $proto40["m_columns"][] = "capcdecisiondate";
  768. $proto40["m_columns"][] = "effectivedate";
  769. $obj = new SQLTable($proto40);
  770. $proto39["m_table"] = $obj;
  771. $proto39["m_alias"] = "";
  772. $proto41=array();
  773. $proto41["m_sql"] = "tblemployee.employeeid = tblrecommendations.employeeid";
  774. $proto41["m_uniontype"] = "SQLL_UNKNOWN";
  775. $obj = new SQLField(array(
  776. "m_strName" => "employeeid",
  777. "m_strTable" => "tblemployee"
  778. ));
  779. $proto41["m_column"]=$obj;
  780. $proto41["m_contained"] = array();
  781. $proto41["m_strCase"] = "= tblrecommendations.employeeid";
  782. $proto41["m_havingmode"] = "0";
  783. $proto41["m_inBrackets"] = "0";
  784. $proto41["m_useAlias"] = "0";
  785. $obj = new SQLLogicalExpr($proto41);
  786. $proto39["m_joinon"] = $obj;
  787. $obj = new SQLFromListItem($proto39);
  788. $proto0["m_fromlist"][]=$obj;
  789. $proto43=array();
  790. $proto43["m_link"] = "SQLL_INNERJOIN";
  791. $proto44=array();
  792. $proto44["m_strName"] = "tblrank";
  793. $proto44["m_columns"] = array();
  794. $proto44["m_columns"][] = "rankid";
  795. $proto44["m_columns"][] = "cadreid";
  796. $proto44["m_columns"][] = "name";
  797. $proto44["m_columns"][] = "grade";
  798. $obj = new SQLTable($proto44);
  799. $proto43["m_table"] = $obj;
  800. $proto43["m_alias"] = "";
  801. $proto45=array();
  802. $proto45["m_sql"] = "tblrecommendations.rankinview = tblrank.rankid";
  803. $proto45["m_uniontype"] = "SQLL_UNKNOWN";
  804. $obj = new SQLField(array(
  805. "m_strName" => "rankinview",
  806. "m_strTable" => "tblrecommendations"
  807. ));
  808. $proto45["m_column"]=$obj;
  809. $proto45["m_contained"] = array();
  810. $proto45["m_strCase"] = "= tblrank.rankid";
  811. $proto45["m_havingmode"] = "0";
  812. $proto45["m_inBrackets"] = "0";
  813. $proto45["m_useAlias"] = "0";
  814. $obj = new SQLLogicalExpr($proto45);
  815. $proto43["m_joinon"] = $obj;
  816. $obj = new SQLFromListItem($proto43);
  817. $proto0["m_fromlist"][]=$obj;
  818. $proto47=array();
  819. $proto47["m_link"] = "SQLL_INNERJOIN";
  820. $proto48=array();
  821. $proto48["m_strName"] = "tbldepartment";
  822. $proto48["m_columns"] = array();
  823. $proto48["m_columns"][] = "deptid";
  824. $proto48["m_columns"][] = "name";
  825. $proto48["m_columns"][] = "facid";
  826. $obj = new SQLTable($proto48);
  827. $proto47["m_table"] = $obj;
  828. $proto47["m_alias"] = "";
  829. $proto49=array();
  830. $proto49["m_sql"] = "tblemployee.department = tbldepartment.deptid";
  831. $proto49["m_uniontype"] = "SQLL_UNKNOWN";
  832. $obj = new SQLField(array(
  833. "m_strName" => "department",
  834. "m_strTable" => "tblemployee"
  835. ));
  836. $proto49["m_column"]=$obj;
  837. $proto49["m_contained"] = array();
  838. $proto49["m_strCase"] = "= tbldepartment.deptid";
  839. $proto49["m_havingmode"] = "0";
  840. $proto49["m_inBrackets"] = "0";
  841. $proto49["m_useAlias"] = "0";
  842. $obj = new SQLLogicalExpr($proto49);
  843. $proto47["m_joinon"] = $obj;
  844. $obj = new SQLFromListItem($proto47);
  845. $proto0["m_fromlist"][]=$obj;
  846. $proto51=array();
  847. $proto51["m_link"] = "SQLL_INNERJOIN";
  848. $proto52=array();
  849. $proto52["m_strName"] = "tblfaccentres";
  850. $proto52["m_columns"] = array();
  851. $proto52["m_columns"][] = "facid";
  852. $proto52["m_columns"][] = "name";
  853. $proto52["m_columns"][] = "complexid";
  854. $obj = new SQLTable($proto52);
  855. $proto51["m_table"] = $obj;
  856. $proto51["m_alias"] = "";
  857. $proto53=array();
  858. $proto53["m_sql"] = "tbldepartment.facid = tblfaccentres.facid";
  859. $proto53["m_uniontype"] = "SQLL_UNKNOWN";
  860. $obj = new SQLField(array(
  861. "m_strName" => "facid",
  862. "m_strTable" => "tbldepartment"
  863. ));
  864. $proto53["m_column"]=$obj;
  865. $proto53["m_contained"] = array();
  866. $proto53["m_strCase"] = "= tblfaccentres.facid";
  867. $proto53["m_havingmode"] = "0";
  868. $proto53["m_inBrackets"] = "0";
  869. $proto53["m_useAlias"] = "0";
  870. $obj = new SQLLogicalExpr($proto53);
  871. $proto51["m_joinon"] = $obj;
  872. $obj = new SQLFromListItem($proto51);
  873. $proto0["m_fromlist"][]=$obj;
  874. $proto55=array();
  875. $proto55["m_link"] = "SQLL_INNERJOIN";
  876. $proto56=array();
  877. $proto56["m_strName"] = "tblcomplex";
  878. $proto56["m_columns"] = array();
  879. $proto56["m_columns"][] = "complexid";
  880. $proto56["m_columns"][] = "name";
  881. $obj = new SQLTable($proto56);
  882. $proto55["m_table"] = $obj;
  883. $proto55["m_alias"] = "";
  884. $proto57=array();
  885. $proto57["m_sql"] = "tblfaccentres.complexid = tblcomplex.complexid";
  886. $proto57["m_uniontype"] = "SQLL_UNKNOWN";
  887. $obj = new SQLField(array(
  888. "m_strName" => "complexid",
  889. "m_strTable" => "tblfaccentres"
  890. ));
  891. $proto57["m_column"]=$obj;
  892. $proto57["m_contained"] = array();
  893. $proto57["m_strCase"] = "= tblcomplex.complexid";
  894. $proto57["m_havingmode"] = "0";
  895. $proto57["m_inBrackets"] = "0";
  896. $proto57["m_useAlias"] = "0";
  897. $obj = new SQLLogicalExpr($proto57);
  898. $proto55["m_joinon"] = $obj;
  899. $obj = new SQLFromListItem($proto55);
  900. $proto0["m_fromlist"][]=$obj;
  901. $proto0["m_groupby"] = array();
  902. $proto59=array();
  903. $obj = new SQLField(array(
  904. "m_strName" => "personnelno",
  905. "m_strTable" => "tblpromotions"
  906. ));
  907. $proto59["m_column"]=$obj;
  908. $obj = new SQLGroupByItem($proto59);
  909. $proto0["m_groupby"][]=$obj;
  910. $proto0["m_orderby"] = array();
  911. $obj = new SQLQuery($proto0);
  912. return $obj;
  913. }
  914. $queryData_tblemployee_Report = createSqlQuery_tblemployee_Report();
  915. $tdatatblemployee_Report[".sqlquery"] = $queryData_tblemployee_Report;
  916. $tableEvents["tblemployee Report"] = new eventsBase;
  917. $tdatatblemployee_Report[".hasEvents"] = false;
  918. ?>