/reports/leaves_reports/output/include/tblleavetype_settings.php
PHP | 508 lines | 297 code | 189 blank | 22 comment | 11 complexity | 5d98e75db976f0ac352821a275c7ec6c MD5 | raw file
Possible License(s): LGPL-2.1
- <?php
- $tdatatblleavetype=array();
- $tdatatblleavetype[".ShortName"]="tblleavetype";
- $tdatatblleavetype[".OwnerID"]="";
- $tdatatblleavetype[".OriginalTable"]="tblleavetype";
-
-
-
- // field labels
- $fieldLabelstblleavetype = array();
- if(mlang_getcurrentlang()=="English")
- {
- $fieldLabelstblleavetype["English"]=array();
- $fieldToolTipstblleavetype["English"]=array();
- $fieldLabelstblleavetype["English"]["leavetypeid"] = "S/N";
- $fieldToolTipstblleavetype["English"]["leavetypeid"] = "";
- $fieldLabelstblleavetype["English"]["description"] = "Leave Type";
- $fieldToolTipstblleavetype["English"]["description"] = "";
- $fieldLabelstblleavetype["English"][""] = "";
- $fieldToolTipstblleavetype["English"][""] = "";
- $fieldLabelstblleavetype["English"][""] = "";
- $fieldToolTipstblleavetype["English"][""] = "";
- if (count($fieldToolTipstblleavetype["English"])){
- $tdatatblleavetype[".isUseToolTips"]=true;
- }
- }
-
-
-
- $tdatatblleavetype[".NCSearch"]=true;
-
-
-
- $tdatatblleavetype[".shortTableName"] = "tblleavetype";
- $tdatatblleavetype[".nSecOptions"] = 0;
- $tdatatblleavetype[".recsPerRowList"] = 1;
- $tdatatblleavetype[".tableGroupBy"] = "0";
- $tdatatblleavetype[".mainTableOwnerID"] = "";
- $tdatatblleavetype[".moveNext"] = 1;
-
-
-
-
- $tdatatblleavetype[".showAddInPopup"] = false;
-
- $tdatatblleavetype[".showEditInPopup"] = false;
-
- $tdatatblleavetype[".showViewInPopup"] = false;
-
-
- $tdatatblleavetype[".fieldsForRegister"] = array();
-
- $tdatatblleavetype[".listAjax"] = false;
-
- $tdatatblleavetype[".audit"] = false;
-
- $tdatatblleavetype[".locking"] = false;
-
- $tdatatblleavetype[".listIcons"] = true;
- $tdatatblleavetype[".edit"] = true;
- $tdatatblleavetype[".inlineEdit"] = true;
- $tdatatblleavetype[".view"] = true;
-
- $tdatatblleavetype[".exportTo"] = true;
-
- $tdatatblleavetype[".printFriendly"] = true;
-
- $tdatatblleavetype[".delete"] = true;
-
- $tdatatblleavetype[".showSimpleSearchOptions"] = false;
-
- $tdatatblleavetype[".showSearchPanel"] = true;
-
-
- if (isMobile()){
- $tdatatblleavetype[".isUseAjaxSuggest"] = false;
- }else {
- $tdatatblleavetype[".isUseAjaxSuggest"] = true;
- }
-
- $tdatatblleavetype[".rowHighlite"] = true;
-
-
- // button handlers file names
-
- $tdatatblleavetype[".addPageEvents"] = false;
-
- $tdatatblleavetype[".arrKeyFields"][] = "leavetypeid";
-
- // use datepicker for search panel
- $tdatatblleavetype[".isUseCalendarForSearch"] = false;
-
- // use timepicker for search panel
- $tdatatblleavetype[".isUseTimeForSearch"] = false;
-
- $tdatatblleavetype[".isUseiBox"] = false;
-
-
-
-
-
-
- $tdatatblleavetype[".isUseInlineAdd"] = true;
-
- $tdatatblleavetype[".isUseInlineEdit"] = true;
- $tdatatblleavetype[".isUseInlineJs"] = $tdatatblleavetype[".isUseInlineAdd"] || $tdatatblleavetype[".isUseInlineEdit"];
-
- $tdatatblleavetype[".allSearchFields"] = array();
-
- $tdatatblleavetype[".globSearchFields"][] = "leavetypeid";
- // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
- if (!in_array("leavetypeid", $tdatatblleavetype[".allSearchFields"]))
- {
- $tdatatblleavetype[".allSearchFields"][] = "leavetypeid";
- }
- $tdatatblleavetype[".globSearchFields"][] = "description";
- // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
- if (!in_array("description", $tdatatblleavetype[".allSearchFields"]))
- {
- $tdatatblleavetype[".allSearchFields"][] = "description";
- }
-
-
- $tdatatblleavetype[".googleLikeFields"][] = "leavetypeid";
- $tdatatblleavetype[".googleLikeFields"][] = "description";
-
- $tdatatblleavetype[".panelSearchFields"][] = "description";
- // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
- if (!in_array("description", $tdatatblleavetype[".allSearchFields"]))
- {
- $tdatatblleavetype[".allSearchFields"][] = "description";
- }
-
-
- $tdatatblleavetype[".advSearchFields"][] = "leavetypeid";
- // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
- if (!in_array("leavetypeid", $tdatatblleavetype[".allSearchFields"]))
- {
- $tdatatblleavetype[".allSearchFields"][] = "leavetypeid";
- }
- $tdatatblleavetype[".advSearchFields"][] = "description";
- // do in this way, because combine functions array_unique and array_merge returns array with keys like 1,2, 4 etc
- if (!in_array("description", $tdatatblleavetype[".allSearchFields"]))
- {
- $tdatatblleavetype[".allSearchFields"][] = "description";
- }
-
- $tdatatblleavetype[".isTableType"] = "list";
-
-
-
-
-
-
- // Access doesn't support subqueries from the same table as main
- $tdatatblleavetype[".subQueriesSupAccess"] = true;
-
-
-
-
-
- $tdatatblleavetype[".pageSize"] = 20;
-
- $gstrOrderBy = "";
- if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
- $gstrOrderBy = "order by ".$gstrOrderBy;
- $tdatatblleavetype[".strOrderBy"] = $gstrOrderBy;
-
- $tdatatblleavetype[".orderindexes"] = array();
-
- $tdatatblleavetype[".sqlHead"] = "SELECT leavetypeid, description";
- $tdatatblleavetype[".sqlFrom"] = "FROM tblleavetype";
- $tdatatblleavetype[".sqlWhereExpr"] = "";
- $tdatatblleavetype[".sqlTail"] = "";
-
-
-
-
- //fill array of records per page for list and report without group fields
- $arrRPP = array();
- $arrRPP[] = 10;
- $arrRPP[] = 20;
- $arrRPP[] = 30;
- $arrRPP[] = 50;
- $arrRPP[] = 100;
- $arrRPP[] = 500;
- $arrRPP[] = -1;
- $tdatatblleavetype[".arrRecsPerPage"] = $arrRPP;
-
- //fill array of groups per page for report with group fields
- $arrGPP = array();
- $arrGPP[] = 1;
- $arrGPP[] = 3;
- $arrGPP[] = 5;
- $arrGPP[] = 10;
- $arrGPP[] = 50;
- $arrGPP[] = 100;
- $arrGPP[] = -1;
- $tdatatblleavetype[".arrGroupsPerPage"] = $arrGPP;
-
- $tableKeys = array();
- $tableKeys[] = "leavetypeid";
- $tdatatblleavetype[".Keys"] = $tableKeys;
-
- $tdatatblleavetype[".listFields"] = array();
- $tdatatblleavetype[".listFields"][] = "leavetypeid";
- $tdatatblleavetype[".listFields"][] = "description";
-
- $tdatatblleavetype[".addFields"] = array();
- $tdatatblleavetype[".addFields"][] = "leavetypeid";
- $tdatatblleavetype[".addFields"][] = "description";
-
- $tdatatblleavetype[".inlineAddFields"] = array();
- $tdatatblleavetype[".inlineAddFields"][] = "leavetypeid";
- $tdatatblleavetype[".inlineAddFields"][] = "description";
-
- $tdatatblleavetype[".editFields"] = array();
- $tdatatblleavetype[".editFields"][] = "leavetypeid";
- $tdatatblleavetype[".editFields"][] = "description";
-
- $tdatatblleavetype[".inlineEditFields"] = array();
- $tdatatblleavetype[".inlineEditFields"][] = "leavetypeid";
- $tdatatblleavetype[".inlineEditFields"][] = "description";
-
-
- // leavetypeid
- $fdata = array();
- $fdata["strName"] = "leavetypeid";
- $fdata["ownerTable"] = "tblleavetype";
- $fdata["Label"]="S/N";
-
-
-
- $fdata["FieldType"]= 3;
-
- $fdata["AutoInc"]=true;
-
- $fdata["UseiBox"] = false;
-
- $fdata["EditFormat"]= "Text field";
- $fdata["ViewFormat"]= "";
-
-
-
-
-
- $fdata["NeedEncode"]=true;
-
- $fdata["GoodName"]= "leavetypeid";
-
- $fdata["FullName"]= "leavetypeid";
-
- $fdata["IsRequired"]=true;
-
-
-
-
-
- $fdata["Index"]= 1;
- $fdata["EditParams"]="";
-
- $fdata["bListPage"]=true;
-
- $fdata["bAddPage"]=true;
-
- $fdata["bInlineAdd"]=true;
-
- $fdata["bEditPage"]=true;
-
- $fdata["bInlineEdit"]=true;
-
- $fdata["bViewPage"]=true;
-
- $fdata["bAdvancedSearch"]=true;
-
- $fdata["bPrinterPage"]=true;
-
- $fdata["bExportPage"]=true;
-
- //Begin validation
- $fdata["validateAs"] = array();
- $fdata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
- $fdata["validateAs"]["basicValidate"][] = "IsRequired";
-
- //End validation
-
- $fdata["FieldPermissions"]=true;
-
-
-
-
-
-
- $tdatatblleavetype["leavetypeid"]=$fdata;
- // description
- $fdata = array();
- $fdata["strName"] = "description";
- $fdata["ownerTable"] = "tblleavetype";
- $fdata["Label"]="Leave Type";
-
-
-
- $fdata["FieldType"]= 200;
-
-
- $fdata["UseiBox"] = false;
-
- $fdata["EditFormat"]= "Lookup wizard";
- $fdata["ViewFormat"]= "";
-
-
- $fdata["LookupType"]=1;
- $fdata["pLookupType"] = 1;
- $fdata["freeInput"] = 0;
- $fdata["autoCompleteFieldsOnEdit"] = 0;
- $fdata["autoCompleteFields"] = array();
-
- $fdata["LinkField"]="description";
- $fdata["LinkFieldType"]=200;
- $fdata["DisplayField"]="description";
- $fdata["LookupTable"]="tblleavetype";
- $fdata["LookupOrderBy"]="description";
-
-
-
-
- $fdata["NeedEncode"]=true;
-
- $fdata["GoodName"]= "description";
-
- $fdata["FullName"]= "description";
-
-
-
-
-
-
- $fdata["Index"]= 2;
-
- $fdata["bListPage"]=true;
-
- $fdata["bAddPage"]=true;
-
- $fdata["bInlineAdd"]=true;
-
- $fdata["bEditPage"]=true;
-
- $fdata["bInlineEdit"]=true;
-
- $fdata["bViewPage"]=true;
-
- $fdata["bAdvancedSearch"]=true;
-
- $fdata["bPrinterPage"]=true;
-
- $fdata["bExportPage"]=true;
-
- //Begin validation
- $fdata["validateAs"] = array();
-
- //End validation
-
- $fdata["FieldPermissions"]=true;
-
-
-
-
-
-
- $tdatatblleavetype["description"]=$fdata;
-
-
-
- $tables_data["tblleavetype"]=&$tdatatblleavetype;
- $field_labels["tblleavetype"] = &$fieldLabelstblleavetype;
- $fieldToolTips["tblleavetype"] = &$fieldToolTipstblleavetype;
-
- // -----------------start prepare master-details data arrays ------------------------------//
- // tables which are detail tables for current table (master)
- $detailsTablesData["tblleavetype"] = array();
-
-
- // tables which are master tables for current table (detail)
- $masterTablesData["tblleavetype"] = array();
-
- // -----------------end prepare master-details data arrays ------------------------------//
-
- require_once(getabspath("classes/sql.php"));
-
-
-
-
-
-
-
-
-
-
- function createSqlQuery_tblleavetype()
- {
- $proto0=array();
- $proto0["m_strHead"] = "SELECT";
- $proto0["m_strFieldList"] = "leavetypeid, description";
- $proto0["m_strFrom"] = "FROM tblleavetype";
- $proto0["m_strWhere"] = "";
- $proto0["m_strOrderBy"] = "";
- $proto0["m_strTail"] = "";
- $proto1=array();
- $proto1["m_sql"] = "";
- $proto1["m_uniontype"] = "SQLL_UNKNOWN";
- $obj = new SQLNonParsed(array(
- "m_sql" => ""
- ));
-
- $proto1["m_column"]=$obj;
- $proto1["m_contained"] = array();
- $proto1["m_strCase"] = "";
- $proto1["m_havingmode"] = "0";
- $proto1["m_inBrackets"] = "0";
- $proto1["m_useAlias"] = "0";
- $obj = new SQLLogicalExpr($proto1);
-
- $proto0["m_where"] = $obj;
- $proto3=array();
- $proto3["m_sql"] = "";
- $proto3["m_uniontype"] = "SQLL_UNKNOWN";
- $obj = new SQLNonParsed(array(
- "m_sql" => ""
- ));
-
- $proto3["m_column"]=$obj;
- $proto3["m_contained"] = array();
- $proto3["m_strCase"] = "";
- $proto3["m_havingmode"] = "0";
- $proto3["m_inBrackets"] = "0";
- $proto3["m_useAlias"] = "0";
- $obj = new SQLLogicalExpr($proto3);
-
- $proto0["m_having"] = $obj;
- $proto0["m_fieldlist"] = array();
- $proto5=array();
- $obj = new SQLField(array(
- "m_strName" => "leavetypeid",
- "m_strTable" => "tblleavetype"
- ));
-
- $proto5["m_expr"]=$obj;
- $proto5["m_alias"] = "";
- $obj = new SQLFieldListItem($proto5);
-
- $proto0["m_fieldlist"][]=$obj;
- $proto7=array();
- $obj = new SQLField(array(
- "m_strName" => "description",
- "m_strTable" => "tblleavetype"
- ));
-
- $proto7["m_expr"]=$obj;
- $proto7["m_alias"] = "";
- $obj = new SQLFieldListItem($proto7);
-
- $proto0["m_fieldlist"][]=$obj;
- $proto0["m_fromlist"] = array();
- $proto9=array();
- $proto9["m_link"] = "SQLL_MAIN";
- $proto10=array();
- $proto10["m_strName"] = "tblleavetype";
- $proto10["m_columns"] = array();
- $proto10["m_columns"][] = "leavetypeid";
- $proto10["m_columns"][] = "description";
- $obj = new SQLTable($proto10);
-
- $proto9["m_table"] = $obj;
- $proto9["m_alias"] = "";
- $proto11=array();
- $proto11["m_sql"] = "";
- $proto11["m_uniontype"] = "SQLL_UNKNOWN";
- $obj = new SQLNonParsed(array(
- "m_sql" => ""
- ));
-
- $proto11["m_column"]=$obj;
- $proto11["m_contained"] = array();
- $proto11["m_strCase"] = "";
- $proto11["m_havingmode"] = "0";
- $proto11["m_inBrackets"] = "0";
- $proto11["m_useAlias"] = "0";
- $obj = new SQLLogicalExpr($proto11);
-
- $proto9["m_joinon"] = $obj;
- $obj = new SQLFromListItem($proto9);
-
- $proto0["m_fromlist"][]=$obj;
- $proto0["m_groupby"] = array();
- $proto0["m_orderby"] = array();
- $obj = new SQLQuery($proto0);
-
- return $obj;
- }
- $queryData_tblleavetype = createSqlQuery_tblleavetype();
- $tdatatblleavetype[".sqlquery"] = $queryData_tblleavetype;
-
-
-
- $tableEvents["tblleavetype"] = new eventsBase;
- $tdatatblleavetype[".hasEvents"] = false;
-
- ?>