PageRenderTime 52ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/reports/leaves_reports/output/include/leaves_schedulereport_settings.php

https://bitbucket.org/lecturer34/hrmis
PHP | 1981 lines | 1197 code | 698 blank | 86 comment | 39 complexity | fd00d589a6bfee34555b10eacc0165ec MD5 | raw file
Possible License(s): LGPL-2.1

Large files files are truncated, but you can click here to view the full file

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

Large files files are truncated, but you can click here to view the full file