Viewing file: certificate_settings.php (160.37 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
$tdatacertificate = array();
$tdatacertificate[".searchableFields"] = array();
$tdatacertificate[".ShortName"] = "certificate";
$tdatacertificate[".OwnerID"] = "";
$tdatacertificate[".OriginalTable"] = "certificate";
$tdatacertificate[".pagesByType"] = my_json_decode( "{\"add\":[\"add\"],\"edit\":[\"edit\"],\"export\":[\"export\"],\"import\":[\"import\"],\"list\":[\"list\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}" );
$tdatacertificate[".originalPagesByType"] = $tdatacertificate[".pagesByType"];
$tdatacertificate[".pages"] = types2pages( my_json_decode( "{\"add\":[\"add\"],\"edit\":[\"edit\"],\"export\":[\"export\"],\"import\":[\"import\"],\"list\":[\"list\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}" ) );
$tdatacertificate[".originalPages"] = $tdatacertificate[".pages"];
$tdatacertificate[".defaultPages"] = my_json_decode( "{\"add\":\"add\",\"edit\":\"edit\",\"export\":\"export\",\"import\":\"import\",\"list\":\"list\",\"print\":\"print\",\"search\":\"search\",\"view\":\"view\"}" );
$tdatacertificate[".originalDefaultPages"] = $tdatacertificate[".defaultPages"];
// field labels
$fieldLabelscertificate = array();
$fieldToolTipscertificate = array();
$pageTitlescertificate = array();
$placeHolderscertificate = array();
if(mlang_getcurrentlang()=="English")
{
$fieldLabelscertificate["English"] = array();
$fieldToolTipscertificate["English"] = array();
$placeHolderscertificate["English"] = array();
$pageTitlescertificate["English"] = array();
$fieldLabelscertificate["English"]["ID"] = "ID";
$fieldToolTipscertificate["English"]["ID"] = "";
$placeHolderscertificate["English"]["ID"] = "";
$fieldLabelscertificate["English"]["Date_Reg"] = "Date Reg";
$fieldToolTipscertificate["English"]["Date_Reg"] = "";
$placeHolderscertificate["English"]["Date_Reg"] = "";
$fieldLabelscertificate["English"]["enrollment"] = "Enrollment";
$fieldToolTipscertificate["English"]["enrollment"] = "";
$placeHolderscertificate["English"]["enrollment"] = "";
$fieldLabelscertificate["English"]["CertificateNo"] = "Certificate No";
$fieldToolTipscertificate["English"]["CertificateNo"] = "";
$placeHolderscertificate["English"]["CertificateNo"] = "";
$fieldLabelscertificate["English"]["Course"] = "Course";
$fieldToolTipscertificate["English"]["Course"] = "";
$placeHolderscertificate["English"]["Course"] = "";
$fieldLabelscertificate["English"]["grade"] = "Grade";
$fieldToolTipscertificate["English"]["grade"] = "";
$placeHolderscertificate["English"]["grade"] = "";
$fieldLabelscertificate["English"]["Name"] = "Name";
$fieldToolTipscertificate["English"]["Name"] = "";
$placeHolderscertificate["English"]["Name"] = "";
$fieldLabelscertificate["English"]["father_name"] = "Father Name";
$fieldToolTipscertificate["English"]["father_name"] = "";
$placeHolderscertificate["English"]["father_name"] = "";
$fieldLabelscertificate["English"]["Add"] = "Add";
$fieldToolTipscertificate["English"]["Add"] = "";
$placeHolderscertificate["English"]["Add"] = "";
$fieldLabelscertificate["English"]["Mobile"] = "Mobile";
$fieldToolTipscertificate["English"]["Mobile"] = "";
$placeHolderscertificate["English"]["Mobile"] = "";
$fieldLabelscertificate["English"]["Status"] = "Status";
$fieldToolTipscertificate["English"]["Status"] = "";
$placeHolderscertificate["English"]["Status"] = "";
$fieldLabelscertificate["English"]["Action"] = "Action";
$fieldToolTipscertificate["English"]["Action"] = "";
$placeHolderscertificate["English"]["Action"] = "";
$fieldLabelscertificate["English"]["photo"] = "Photo";
$fieldToolTipscertificate["English"]["photo"] = "";
$placeHolderscertificate["English"]["photo"] = "";
$fieldLabelscertificate["English"]["address"] = "Address";
$fieldToolTipscertificate["English"]["address"] = "";
$placeHolderscertificate["English"]["address"] = "";
$fieldLabelscertificate["English"]["certifcate_issue_date"] = "Certifcate Issue Date";
$fieldToolTipscertificate["English"]["certifcate_issue_date"] = "";
$placeHolderscertificate["English"]["certifcate_issue_date"] = "";
$fieldLabelscertificate["English"]["branch"] = "Branch";
$fieldToolTipscertificate["English"]["branch"] = "";
$placeHolderscertificate["English"]["branch"] = "";
$fieldLabelscertificate["English"]["months"] = "Months";
$fieldToolTipscertificate["English"]["months"] = "";
$placeHolderscertificate["English"]["months"] = "";
$fieldLabelscertificate["English"]["start_date"] = "Start Date";
$fieldToolTipscertificate["English"]["start_date"] = "";
$placeHolderscertificate["English"]["start_date"] = "";
$fieldLabelscertificate["English"]["end_date"] = "End Date";
$fieldToolTipscertificate["English"]["end_date"] = "";
$placeHolderscertificate["English"]["end_date"] = "";
$fieldLabelscertificate["English"]["center_address"] = "Center Address";
$fieldToolTipscertificate["English"]["center_address"] = "";
$placeHolderscertificate["English"]["center_address"] = "";
$fieldLabelscertificate["English"]["subject"] = "Subject";
$fieldToolTipscertificate["English"]["subject"] = "";
$placeHolderscertificate["English"]["subject"] = "";
$fieldLabelscertificate["English"]["pn1"] = "Pn1";
$fieldToolTipscertificate["English"]["pn1"] = "";
$placeHolderscertificate["English"]["pn1"] = "";
$fieldLabelscertificate["English"]["pn1_total_marks"] = "Pn1 Total Marks";
$fieldToolTipscertificate["English"]["pn1_total_marks"] = "";
$placeHolderscertificate["English"]["pn1_total_marks"] = "";
$fieldLabelscertificate["English"]["pn1_obtained_marks"] = "Pn1 Obtained Marks";
$fieldToolTipscertificate["English"]["pn1_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn1_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn2"] = "Pn2";
$fieldToolTipscertificate["English"]["pn2"] = "";
$placeHolderscertificate["English"]["pn2"] = "";
$fieldLabelscertificate["English"]["pn3"] = "Pn3";
$fieldToolTipscertificate["English"]["pn3"] = "";
$placeHolderscertificate["English"]["pn3"] = "";
$fieldLabelscertificate["English"]["pn4"] = "Pn4";
$fieldToolTipscertificate["English"]["pn4"] = "";
$placeHolderscertificate["English"]["pn4"] = "";
$fieldLabelscertificate["English"]["pn5"] = "Pn5";
$fieldToolTipscertificate["English"]["pn5"] = "";
$placeHolderscertificate["English"]["pn5"] = "";
$fieldLabelscertificate["English"]["pn6"] = "Pn6";
$fieldToolTipscertificate["English"]["pn6"] = "";
$placeHolderscertificate["English"]["pn6"] = "";
$fieldLabelscertificate["English"]["pn7"] = "Pn7";
$fieldToolTipscertificate["English"]["pn7"] = "";
$placeHolderscertificate["English"]["pn7"] = "";
$fieldLabelscertificate["English"]["pn8"] = "Pn8";
$fieldToolTipscertificate["English"]["pn8"] = "";
$placeHolderscertificate["English"]["pn8"] = "";
$fieldLabelscertificate["English"]["pn9"] = "Pn9";
$fieldToolTipscertificate["English"]["pn9"] = "";
$placeHolderscertificate["English"]["pn9"] = "";
$fieldLabelscertificate["English"]["pn10"] = "Pn10";
$fieldToolTipscertificate["English"]["pn10"] = "";
$placeHolderscertificate["English"]["pn10"] = "";
$fieldLabelscertificate["English"]["pn2_total_marks"] = "Pn2 Total Marks";
$fieldToolTipscertificate["English"]["pn2_total_marks"] = "";
$placeHolderscertificate["English"]["pn2_total_marks"] = "";
$fieldLabelscertificate["English"]["pn3_total_marks"] = "Pn3 Total Marks";
$fieldToolTipscertificate["English"]["pn3_total_marks"] = "";
$placeHolderscertificate["English"]["pn3_total_marks"] = "";
$fieldLabelscertificate["English"]["pn4_total_marks"] = "Pn4 Total Marks";
$fieldToolTipscertificate["English"]["pn4_total_marks"] = "";
$placeHolderscertificate["English"]["pn4_total_marks"] = "";
$fieldLabelscertificate["English"]["pn5_total_marks"] = "Pn5 Total Marks";
$fieldToolTipscertificate["English"]["pn5_total_marks"] = "";
$placeHolderscertificate["English"]["pn5_total_marks"] = "";
$fieldLabelscertificate["English"]["pn6_total_marks"] = "Pn6 Total Marks";
$fieldToolTipscertificate["English"]["pn6_total_marks"] = "";
$placeHolderscertificate["English"]["pn6_total_marks"] = "";
$fieldLabelscertificate["English"]["pn7_total_marks"] = "Pn7 Total Marks";
$fieldToolTipscertificate["English"]["pn7_total_marks"] = "";
$placeHolderscertificate["English"]["pn7_total_marks"] = "";
$fieldLabelscertificate["English"]["pn8_total_marks"] = "Pn8 Total Marks";
$fieldToolTipscertificate["English"]["pn8_total_marks"] = "";
$placeHolderscertificate["English"]["pn8_total_marks"] = "";
$fieldLabelscertificate["English"]["pn9_total_marks"] = "Pn9 Total Marks";
$fieldToolTipscertificate["English"]["pn9_total_marks"] = "";
$placeHolderscertificate["English"]["pn9_total_marks"] = "";
$fieldLabelscertificate["English"]["pn10_total_marks"] = "Pn10 Total Marks";
$fieldToolTipscertificate["English"]["pn10_total_marks"] = "";
$placeHolderscertificate["English"]["pn10_total_marks"] = "";
$fieldLabelscertificate["English"]["pn2_obtained_marks"] = "Pn2 Obtained Marks";
$fieldToolTipscertificate["English"]["pn2_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn2_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn3_obtained_marks"] = "Pn3 Obtained Marks";
$fieldToolTipscertificate["English"]["pn3_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn3_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn4_obtained_marks"] = "Pn4 Obtained Marks";
$fieldToolTipscertificate["English"]["pn4_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn4_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn5_obtained_marks"] = "Pn5 Obtained Marks";
$fieldToolTipscertificate["English"]["pn5_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn5_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn6_obtained_marks"] = "Pn6 Obtained Marks";
$fieldToolTipscertificate["English"]["pn6_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn6_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn7_obtained_marks"] = "Pn7 Obtained Marks";
$fieldToolTipscertificate["English"]["pn7_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn7_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn8_obtained_marks"] = "Pn8 Obtained Marks";
$fieldToolTipscertificate["English"]["pn8_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn8_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn9_obtained_marks"] = "Pn9 Obtained Marks";
$fieldToolTipscertificate["English"]["pn9_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn9_obtained_marks"] = "";
$fieldLabelscertificate["English"]["pn10_obtained_marks"] = "Pn10 Obtained Marks";
$fieldToolTipscertificate["English"]["pn10_obtained_marks"] = "";
$placeHolderscertificate["English"]["pn10_obtained_marks"] = "";
if (count($fieldToolTipscertificate["English"]))
$tdatacertificate[".isUseToolTips"] = true;
}
$tdatacertificate[".NCSearch"] = true;
$tdatacertificate[".shortTableName"] = "certificate";
$tdatacertificate[".nSecOptions"] = 0;
$tdatacertificate[".mainTableOwnerID"] = "";
$tdatacertificate[".entityType"] = 0;
$tdatacertificate[".connId"] = "itce_data_at_itce_co_in";
$tdatacertificate[".strOriginalTableName"] = "certificate";
$tdatacertificate[".showAddInPopup"] = false;
$tdatacertificate[".showEditInPopup"] = false;
$tdatacertificate[".showViewInPopup"] = false;
//page's base css files names
$popupPagesLayoutNames = array();
$tdatacertificate[".popupPagesLayoutNames"] = $popupPagesLayoutNames;
$tdatacertificate[".listAjax"] = false;
// temporary
$tdatacertificate[".listAjax"] = false;
$tdatacertificate[".audit"] = false;
$tdatacertificate[".locking"] = false;
$pages = $tdatacertificate[".defaultPages"];
if( $pages[PAGE_EDIT] ) {
$tdatacertificate[".edit"] = true;
$tdatacertificate[".afterEditAction"] = 1;
$tdatacertificate[".closePopupAfterEdit"] = 1;
$tdatacertificate[".afterEditActionDetTable"] = "";
}
if( $pages[PAGE_ADD] ) {
$tdatacertificate[".add"] = true;
$tdatacertificate[".afterAddAction"] = 1;
$tdatacertificate[".closePopupAfterAdd"] = 1;
$tdatacertificate[".afterAddActionDetTable"] = "";
}
if( $pages[PAGE_LIST] ) {
$tdatacertificate[".list"] = true;
}
$tdatacertificate[".strSortControlSettingsJSON"] = "";
if( $pages[PAGE_VIEW] ) {
$tdatacertificate[".view"] = true;
}
if( $pages[PAGE_IMPORT] ) {
$tdatacertificate[".import"] = true;
}
if( $pages[PAGE_EXPORT] ) {
$tdatacertificate[".exportTo"] = true;
}
if( $pages[PAGE_PRINT] ) {
$tdatacertificate[".printFriendly"] = true;
}
$tdatacertificate[".showSimpleSearchOptions"] = true; // temp fix #13449
// Allow Show/Hide Fields in GRID
$tdatacertificate[".allowShowHideFields"] = true; // temp fix #13449
//
// Allow Fields Reordering in GRID
$tdatacertificate[".allowFieldsReordering"] = true; // temp fix #13449
//
$tdatacertificate[".isUseAjaxSuggest"] = true;
$tdatacertificate[".rowHighlite"] = true;
$tdatacertificate[".ajaxCodeSnippetAdded"] = false;
$tdatacertificate[".buttonsAdded"] = false;
$tdatacertificate[".addPageEvents"] = false;
// use timepicker for search panel
$tdatacertificate[".isUseTimeForSearch"] = false;
$tdatacertificate[".badgeColor"] = "4169E1";
$tdatacertificate[".allSearchFields"] = array();
$tdatacertificate[".filterFields"] = array();
$tdatacertificate[".requiredSearchFields"] = array();
$tdatacertificate[".googleLikeFields"] = array();
$tdatacertificate[".googleLikeFields"][] = "ID";
$tdatacertificate[".googleLikeFields"][] = "Date_Reg";
$tdatacertificate[".googleLikeFields"][] = "enrollment";
$tdatacertificate[".googleLikeFields"][] = "CertificateNo";
$tdatacertificate[".googleLikeFields"][] = "Course";
$tdatacertificate[".googleLikeFields"][] = "grade";
$tdatacertificate[".googleLikeFields"][] = "Name";
$tdatacertificate[".googleLikeFields"][] = "father_name";
$tdatacertificate[".googleLikeFields"][] = "Add";
$tdatacertificate[".googleLikeFields"][] = "Mobile";
$tdatacertificate[".googleLikeFields"][] = "Status";
$tdatacertificate[".googleLikeFields"][] = "Action";
$tdatacertificate[".googleLikeFields"][] = "photo";
$tdatacertificate[".googleLikeFields"][] = "address";
$tdatacertificate[".googleLikeFields"][] = "certifcate_issue_date";
$tdatacertificate[".googleLikeFields"][] = "branch";
$tdatacertificate[".googleLikeFields"][] = "months";
$tdatacertificate[".googleLikeFields"][] = "start_date";
$tdatacertificate[".googleLikeFields"][] = "end_date";
$tdatacertificate[".googleLikeFields"][] = "center_address";
$tdatacertificate[".googleLikeFields"][] = "subject";
$tdatacertificate[".googleLikeFields"][] = "pn1";
$tdatacertificate[".googleLikeFields"][] = "pn1_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn1_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn2";
$tdatacertificate[".googleLikeFields"][] = "pn3";
$tdatacertificate[".googleLikeFields"][] = "pn4";
$tdatacertificate[".googleLikeFields"][] = "pn5";
$tdatacertificate[".googleLikeFields"][] = "pn6";
$tdatacertificate[".googleLikeFields"][] = "pn7";
$tdatacertificate[".googleLikeFields"][] = "pn8";
$tdatacertificate[".googleLikeFields"][] = "pn9";
$tdatacertificate[".googleLikeFields"][] = "pn10";
$tdatacertificate[".googleLikeFields"][] = "pn2_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn3_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn4_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn5_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn6_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn7_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn8_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn9_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn10_total_marks";
$tdatacertificate[".googleLikeFields"][] = "pn2_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn3_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn4_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn5_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn6_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn7_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn8_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn9_obtained_marks";
$tdatacertificate[".googleLikeFields"][] = "pn10_obtained_marks";
$tdatacertificate[".tableType"] = "list";
$tdatacertificate[".printerPageOrientation"] = 0;
$tdatacertificate[".nPrinterPageScale"] = 100;
$tdatacertificate[".nPrinterSplitRecords"] = 40;
$tdatacertificate[".geocodingEnabled"] = false;
$tdatacertificate[".pageSize"] = 20;
$tdatacertificate[".warnLeavingPages"] = true;
$tstrOrderBy = "";
if(strlen($tstrOrderBy) && strtolower(substr($tstrOrderBy,0,8))!="order by")
$tstrOrderBy = "order by ".$tstrOrderBy;
$tdatacertificate[".strOrderBy"] = $tstrOrderBy;
$tdatacertificate[".orderindexes"] = array();
$tdatacertificate[".sqlHead"] = "SELECT ID, Date_Reg, enrollment, CertificateNo, Course, grade, Name, father_name, `Add`, Mobile, Status, `Action`, photo, address, certifcate_issue_date, branch, months, start_date, end_date, center_address, subject, pn1, pn1_total_marks, pn1_obtained_marks, pn2, pn3, pn4, pn5, pn6, pn7, pn8, pn9, pn10, pn2_total_marks, pn3_total_marks, pn4_total_marks, pn5_total_marks, pn6_total_marks, pn7_total_marks, pn8_total_marks, pn9_total_marks, pn10_total_marks, pn2_obtained_marks, pn3_obtained_marks, pn4_obtained_marks, pn5_obtained_marks, pn6_obtained_marks, pn7_obtained_marks, pn8_obtained_marks, pn9_obtained_marks, pn10_obtained_marks";
$tdatacertificate[".sqlFrom"] = "FROM certificate";
$tdatacertificate[".sqlWhereExpr"] = "";
$tdatacertificate[".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;
$tdatacertificate[".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;
$tdatacertificate[".arrGroupsPerPage"] = $arrGPP;
$tdatacertificate[".highlightSearchResults"] = true;
$tableKeyscertificate = array();
$tableKeyscertificate[] = "ID";
$tdatacertificate[".Keys"] = $tableKeyscertificate;
$tdatacertificate[".hideMobileList"] = array();
// ID
// Custom field settings
$fdata = array();
$fdata["Index"] = 1;
$fdata["strName"] = "ID";
$fdata["GoodName"] = "ID";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","ID");
$fdata["FieldType"] = 3;
$fdata["AutoInc"] = true;
$fdata["strField"] = "ID";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "ID";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["IsRequired"] = true;
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
$edata["validateAs"]["basicValidate"][] = "IsRequired";
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["ID"] = $fdata;
$tdatacertificate[".searchableFields"][] = "ID";
// Date_Reg
// Custom field settings
$fdata = array();
$fdata["Index"] = 2;
$fdata["strName"] = "Date_Reg";
$fdata["GoodName"] = "Date_Reg";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","Date_Reg");
$fdata["FieldType"] = 200;
$fdata["strField"] = "Date_Reg";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "Date_Reg";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["Date_Reg"] = $fdata;
$tdatacertificate[".searchableFields"][] = "Date_Reg";
// enrollment
// Custom field settings
$fdata = array();
$fdata["Index"] = 3;
$fdata["strName"] = "enrollment";
$fdata["GoodName"] = "enrollment";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","enrollment");
$fdata["FieldType"] = 200;
$fdata["strField"] = "enrollment";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "enrollment";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["enrollment"] = $fdata;
$tdatacertificate[".searchableFields"][] = "enrollment";
// CertificateNo
// Custom field settings
$fdata = array();
$fdata["Index"] = 4;
$fdata["strName"] = "CertificateNo";
$fdata["GoodName"] = "CertificateNo";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","CertificateNo");
$fdata["FieldType"] = 200;
$fdata["strField"] = "CertificateNo";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "CertificateNo";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["CertificateNo"] = $fdata;
$tdatacertificate[".searchableFields"][] = "CertificateNo";
// Course
// Custom field settings
$fdata = array();
$fdata["Index"] = 5;
$fdata["strName"] = "Course";
$fdata["GoodName"] = "Course";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","Course");
$fdata["FieldType"] = 200;
$fdata["strField"] = "Course";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "Course";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=500";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["Course"] = $fdata;
$tdatacertificate[".searchableFields"][] = "Course";
// grade
// Custom field settings
$fdata = array();
$fdata["Index"] = 6;
$fdata["strName"] = "grade";
$fdata["GoodName"] = "grade";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","grade");
$fdata["FieldType"] = 200;
$fdata["strField"] = "grade";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "grade";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["grade"] = $fdata;
$tdatacertificate[".searchableFields"][] = "grade";
// Name
// Custom field settings
$fdata = array();
$fdata["Index"] = 7;
$fdata["strName"] = "Name";
$fdata["GoodName"] = "Name";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","Name");
$fdata["FieldType"] = 200;
$fdata["strField"] = "Name";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "Name";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["Name"] = $fdata;
$tdatacertificate[".searchableFields"][] = "Name";
// father_name
// Custom field settings
$fdata = array();
$fdata["Index"] = 8;
$fdata["strName"] = "father_name";
$fdata["GoodName"] = "father_name";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","father_name");
$fdata["FieldType"] = 200;
$fdata["strField"] = "father_name";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "father_name";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["father_name"] = $fdata;
$tdatacertificate[".searchableFields"][] = "father_name";
// Add
// Custom field settings
$fdata = array();
$fdata["Index"] = 9;
$fdata["strName"] = "Add";
$fdata["GoodName"] = "Add";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","Add");
$fdata["FieldType"] = 200;
$fdata["strField"] = "Add";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "`Add`";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["Add"] = $fdata;
$tdatacertificate[".searchableFields"][] = "Add";
// Mobile
// Custom field settings
$fdata = array();
$fdata["Index"] = 10;
$fdata["strName"] = "Mobile";
$fdata["GoodName"] = "Mobile";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","Mobile");
$fdata["FieldType"] = 200;
$fdata["strField"] = "Mobile";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "Mobile";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["Mobile"] = $fdata;
$tdatacertificate[".searchableFields"][] = "Mobile";
// Status
// Custom field settings
$fdata = array();
$fdata["Index"] = 11;
$fdata["strName"] = "Status";
$fdata["GoodName"] = "Status";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","Status");
$fdata["FieldType"] = 200;
$fdata["strField"] = "Status";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "Status";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["Status"] = $fdata;
$tdatacertificate[".searchableFields"][] = "Status";
// Action
// Custom field settings
$fdata = array();
$fdata["Index"] = 12;
$fdata["strName"] = "Action";
$fdata["GoodName"] = "Action";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","Action");
$fdata["FieldType"] = 200;
$fdata["strField"] = "Action";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "`Action`";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["Action"] = $fdata;
$tdatacertificate[".searchableFields"][] = "Action";
// photo
// Custom field settings
$fdata = array();
$fdata["Index"] = 13;
$fdata["strName"] = "photo";
$fdata["GoodName"] = "photo";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","photo");
$fdata["FieldType"] = 200;
$fdata["strField"] = "photo";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "photo";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=500";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["photo"] = $fdata;
$tdatacertificate[".searchableFields"][] = "photo";
// address
// Custom field settings
$fdata = array();
$fdata["Index"] = 14;
$fdata["strName"] = "address";
$fdata["GoodName"] = "address";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","address");
$fdata["FieldType"] = 200;
$fdata["strField"] = "address";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "address";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["address"] = $fdata;
$tdatacertificate[".searchableFields"][] = "address";
// certifcate_issue_date
// Custom field settings
$fdata = array();
$fdata["Index"] = 15;
$fdata["strName"] = "certifcate_issue_date";
$fdata["GoodName"] = "certifcate_issue_date";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","certifcate_issue_date");
$fdata["FieldType"] = 200;
$fdata["strField"] = "certifcate_issue_date";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "certifcate_issue_date";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["certifcate_issue_date"] = $fdata;
$tdatacertificate[".searchableFields"][] = "certifcate_issue_date";
// branch
// Custom field settings
$fdata = array();
$fdata["Index"] = 16;
$fdata["strName"] = "branch";
$fdata["GoodName"] = "branch";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","branch");
$fdata["FieldType"] = 200;
$fdata["strField"] = "branch";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "branch";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=500";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["branch"] = $fdata;
$tdatacertificate[".searchableFields"][] = "branch";
// months
// Custom field settings
$fdata = array();
$fdata["Index"] = 17;
$fdata["strName"] = "months";
$fdata["GoodName"] = "months";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","months");
$fdata["FieldType"] = 200;
$fdata["strField"] = "months";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "months";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["months"] = $fdata;
$tdatacertificate[".searchableFields"][] = "months";
// start_date
// Custom field settings
$fdata = array();
$fdata["Index"] = 18;
$fdata["strName"] = "start_date";
$fdata["GoodName"] = "start_date";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","start_date");
$fdata["FieldType"] = 200;
$fdata["strField"] = "start_date";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "start_date";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["start_date"] = $fdata;
$tdatacertificate[".searchableFields"][] = "start_date";
// end_date
// Custom field settings
$fdata = array();
$fdata["Index"] = 19;
$fdata["strName"] = "end_date";
$fdata["GoodName"] = "end_date";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","end_date");
$fdata["FieldType"] = 200;
$fdata["strField"] = "end_date";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "end_date";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["end_date"] = $fdata;
$tdatacertificate[".searchableFields"][] = "end_date";
// center_address
// Custom field settings
$fdata = array();
$fdata["Index"] = 20;
$fdata["strName"] = "center_address";
$fdata["GoodName"] = "center_address";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","center_address");
$fdata["FieldType"] = 200;
$fdata["strField"] = "center_address";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "center_address";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["center_address"] = $fdata;
$tdatacertificate[".searchableFields"][] = "center_address";
// subject
// Custom field settings
$fdata = array();
$fdata["Index"] = 21;
$fdata["strName"] = "subject";
$fdata["GoodName"] = "subject";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","subject");
$fdata["FieldType"] = 200;
$fdata["strField"] = "subject";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "subject";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=5000";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["subject"] = $fdata;
$tdatacertificate[".searchableFields"][] = "subject";
// pn1
// Custom field settings
$fdata = array();
$fdata["Index"] = 22;
$fdata["strName"] = "pn1";
$fdata["GoodName"] = "pn1";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn1");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn1";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn1";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn1"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn1";
// pn1_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 23;
$fdata["strName"] = "pn1_total_marks";
$fdata["GoodName"] = "pn1_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn1_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn1_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn1_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn1_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn1_total_marks";
// pn1_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 24;
$fdata["strName"] = "pn1_obtained_marks";
$fdata["GoodName"] = "pn1_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn1_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn1_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn1_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn1_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn1_obtained_marks";
// pn2
// Custom field settings
$fdata = array();
$fdata["Index"] = 25;
$fdata["strName"] = "pn2";
$fdata["GoodName"] = "pn2";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn2");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn2";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn2";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn2"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn2";
// pn3
// Custom field settings
$fdata = array();
$fdata["Index"] = 26;
$fdata["strName"] = "pn3";
$fdata["GoodName"] = "pn3";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn3");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn3";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn3";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn3"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn3";
// pn4
// Custom field settings
$fdata = array();
$fdata["Index"] = 27;
$fdata["strName"] = "pn4";
$fdata["GoodName"] = "pn4";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn4");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn4";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn4";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn4"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn4";
// pn5
// Custom field settings
$fdata = array();
$fdata["Index"] = 28;
$fdata["strName"] = "pn5";
$fdata["GoodName"] = "pn5";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn5");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn5";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn5";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn5"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn5";
// pn6
// Custom field settings
$fdata = array();
$fdata["Index"] = 29;
$fdata["strName"] = "pn6";
$fdata["GoodName"] = "pn6";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn6");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn6";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn6";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn6"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn6";
// pn7
// Custom field settings
$fdata = array();
$fdata["Index"] = 30;
$fdata["strName"] = "pn7";
$fdata["GoodName"] = "pn7";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn7");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn7";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn7";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn7"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn7";
// pn8
// Custom field settings
$fdata = array();
$fdata["Index"] = 31;
$fdata["strName"] = "pn8";
$fdata["GoodName"] = "pn8";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn8");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn8";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn8";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn8"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn8";
// pn9
// Custom field settings
$fdata = array();
$fdata["Index"] = 32;
$fdata["strName"] = "pn9";
$fdata["GoodName"] = "pn9";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn9");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn9";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn9";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn9"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn9";
// pn10
// Custom field settings
$fdata = array();
$fdata["Index"] = 33;
$fdata["strName"] = "pn10";
$fdata["GoodName"] = "pn10";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn10");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn10";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn10";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn10"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn10";
// pn2_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 34;
$fdata["strName"] = "pn2_total_marks";
$fdata["GoodName"] = "pn2_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn2_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn2_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn2_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn2_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn2_total_marks";
// pn3_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 35;
$fdata["strName"] = "pn3_total_marks";
$fdata["GoodName"] = "pn3_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn3_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn3_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn3_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn3_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn3_total_marks";
// pn4_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 36;
$fdata["strName"] = "pn4_total_marks";
$fdata["GoodName"] = "pn4_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn4_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn4_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn4_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn4_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn4_total_marks";
// pn5_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 37;
$fdata["strName"] = "pn5_total_marks";
$fdata["GoodName"] = "pn5_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn5_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn5_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn5_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn5_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn5_total_marks";
// pn6_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 38;
$fdata["strName"] = "pn6_total_marks";
$fdata["GoodName"] = "pn6_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn6_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn6_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn6_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn6_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn6_total_marks";
// pn7_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 39;
$fdata["strName"] = "pn7_total_marks";
$fdata["GoodName"] = "pn7_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn7_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn7_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn7_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn7_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn7_total_marks";
// pn8_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 40;
$fdata["strName"] = "pn8_total_marks";
$fdata["GoodName"] = "pn8_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn8_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn8_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn8_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn8_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn8_total_marks";
// pn9_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 41;
$fdata["strName"] = "pn9_total_marks";
$fdata["GoodName"] = "pn9_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn9_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn9_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn9_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn9_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn9_total_marks";
// pn10_total_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 42;
$fdata["strName"] = "pn10_total_marks";
$fdata["GoodName"] = "pn10_total_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn10_total_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn10_total_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn10_total_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn10_total_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn10_total_marks";
// pn2_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 43;
$fdata["strName"] = "pn2_obtained_marks";
$fdata["GoodName"] = "pn2_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn2_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn2_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn2_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn2_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn2_obtained_marks";
// pn3_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 44;
$fdata["strName"] = "pn3_obtained_marks";
$fdata["GoodName"] = "pn3_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn3_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn3_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn3_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn3_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn3_obtained_marks";
// pn4_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 45;
$fdata["strName"] = "pn4_obtained_marks";
$fdata["GoodName"] = "pn4_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn4_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn4_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn4_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn4_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn4_obtained_marks";
// pn5_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 46;
$fdata["strName"] = "pn5_obtained_marks";
$fdata["GoodName"] = "pn5_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn5_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn5_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn5_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn5_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn5_obtained_marks";
// pn6_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 47;
$fdata["strName"] = "pn6_obtained_marks";
$fdata["GoodName"] = "pn6_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn6_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn6_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn6_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn6_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn6_obtained_marks";
// pn7_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 48;
$fdata["strName"] = "pn7_obtained_marks";
$fdata["GoodName"] = "pn7_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn7_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn7_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn7_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn7_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn7_obtained_marks";
// pn8_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 49;
$fdata["strName"] = "pn8_obtained_marks";
$fdata["GoodName"] = "pn8_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn8_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn8_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn8_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn8_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn8_obtained_marks";
// pn9_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 50;
$fdata["strName"] = "pn9_obtained_marks";
$fdata["GoodName"] = "pn9_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn9_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn9_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn9_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn9_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn9_obtained_marks";
// pn10_obtained_marks
// Custom field settings
$fdata = array();
$fdata["Index"] = 51;
$fdata["strName"] = "pn10_obtained_marks";
$fdata["GoodName"] = "pn10_obtained_marks";
$fdata["ownerTable"] = "certificate";
$fdata["Label"] = GetFieldLabel("certificate","pn10_obtained_marks");
$fdata["FieldType"] = 200;
$fdata["strField"] = "pn10_obtained_marks";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "pn10_obtained_marks";
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$vdata["truncateText"] = true;
$vdata["NumberOfChars"] = 80;
$fdata["ViewFormats"]["view"] = $vdata;
// End View Formats
// Begin Edit Formats
$fdata["EditFormats"] = array();
$edata = array("EditFormat" => "Text field");
$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
$edata["weekdays"] = "[]";
$edata["acceptFileTypes"] = ".+$";
$edata["acceptFileTypesHtml"] = "";
$edata["maxNumberOfFiles"] = 1;
$edata["HTML5InuptType"] = "text";
$edata["EditParams"] = "";
$edata["EditParams"].= " maxlength=50";
$edata["controlWidth"] = 200;
// Begin validation
$edata["validateAs"] = array();
$edata["validateAs"]["basicValidate"] = array();
$edata["validateAs"]["customMessages"] = array();
// End validation
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
$fdata["defaultSearchOption"] = "Contains";
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings
//Filters settings
$fdata["filterTotals"] = 0;
$fdata["filterMultiSelect"] = 0;
$fdata["filterFormat"] = "Values list";
$fdata["showCollapsed"] = false;
$fdata["sortValueType"] = 0;
$fdata["numberOfVisibleItems"] = 10;
$fdata["filterBy"] = 0;
//end of Filters settings
$tdatacertificate["pn10_obtained_marks"] = $fdata;
$tdatacertificate[".searchableFields"][] = "pn10_obtained_marks";
$tables_data["certificate"]=&$tdatacertificate;
$field_labels["certificate"] = &$fieldLabelscertificate;
$fieldToolTips["certificate"] = &$fieldToolTipscertificate;
$placeHolders["certificate"] = &$placeHolderscertificate;
$page_titles["certificate"] = &$pageTitlescertificate;
// -----------------start prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["certificate"] = array();
// tables which are master tables for current table (detail)
$masterTablesData["certificate"] = array();
// -----------------end prepare master-details data arrays ------------------------------//
require_once(getabspath("classes/sql.php"));
function createSqlQuery_certificate()
{
$proto0=array();
$proto0["m_strHead"] = "SELECT";
$proto0["m_strFieldList"] = "ID, Date_Reg, enrollment, CertificateNo, Course, grade, Name, father_name, `Add`, Mobile, Status, `Action`, photo, address, certifcate_issue_date, branch, months, start_date, end_date, center_address, subject, pn1, pn1_total_marks, pn1_obtained_marks, pn2, pn3, pn4, pn5, pn6, pn7, pn8, pn9, pn10, pn2_total_marks, pn3_total_marks, pn4_total_marks, pn5_total_marks, pn6_total_marks, pn7_total_marks, pn8_total_marks, pn9_total_marks, pn10_total_marks, pn2_obtained_marks, pn3_obtained_marks, pn4_obtained_marks, pn5_obtained_marks, pn6_obtained_marks, pn7_obtained_marks, pn8_obtained_marks, pn9_obtained_marks, pn10_obtained_marks";
$proto0["m_strFrom"] = "FROM certificate";
$proto0["m_strWhere"] = "";
$proto0["m_strOrderBy"] = "";
;
$proto0["cipherer"] = null;
$proto2=array();
$proto2["m_sql"] = "";
$proto2["m_uniontype"] = "SQLL_UNKNOWN";
$obj = new SQLNonParsed(array(
"m_sql" => ""
));
$proto2["m_column"]=$obj;
$proto2["m_contained"] = array();
$proto2["m_strCase"] = "";
$proto2["m_havingmode"] = false;
$proto2["m_inBrackets"] = false;
$proto2["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto2);
$proto0["m_where"] = $obj;
$proto4=array();
$proto4["m_sql"] = "";
$proto4["m_uniontype"] = "SQLL_UNKNOWN";
$obj = new SQLNonParsed(array(
"m_sql" => ""
));
$proto4["m_column"]=$obj;
$proto4["m_contained"] = array();
$proto4["m_strCase"] = "";
$proto4["m_havingmode"] = false;
$proto4["m_inBrackets"] = false;
$proto4["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto4);
$proto0["m_having"] = $obj;
$proto0["m_fieldlist"] = array();
$proto6=array();
$obj = new SQLField(array(
"m_strName" => "ID",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto6["m_sql"] = "ID";
$proto6["m_srcTableName"] = "certificate";
$proto6["m_expr"]=$obj;
$proto6["m_alias"] = "";
$obj = new SQLFieldListItem($proto6);
$proto0["m_fieldlist"][]=$obj;
$proto8=array();
$obj = new SQLField(array(
"m_strName" => "Date_Reg",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto8["m_sql"] = "Date_Reg";
$proto8["m_srcTableName"] = "certificate";
$proto8["m_expr"]=$obj;
$proto8["m_alias"] = "";
$obj = new SQLFieldListItem($proto8);
$proto0["m_fieldlist"][]=$obj;
$proto10=array();
$obj = new SQLField(array(
"m_strName" => "enrollment",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto10["m_sql"] = "enrollment";
$proto10["m_srcTableName"] = "certificate";
$proto10["m_expr"]=$obj;
$proto10["m_alias"] = "";
$obj = new SQLFieldListItem($proto10);
$proto0["m_fieldlist"][]=$obj;
$proto12=array();
$obj = new SQLField(array(
"m_strName" => "CertificateNo",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto12["m_sql"] = "CertificateNo";
$proto12["m_srcTableName"] = "certificate";
$proto12["m_expr"]=$obj;
$proto12["m_alias"] = "";
$obj = new SQLFieldListItem($proto12);
$proto0["m_fieldlist"][]=$obj;
$proto14=array();
$obj = new SQLField(array(
"m_strName" => "Course",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto14["m_sql"] = "Course";
$proto14["m_srcTableName"] = "certificate";
$proto14["m_expr"]=$obj;
$proto14["m_alias"] = "";
$obj = new SQLFieldListItem($proto14);
$proto0["m_fieldlist"][]=$obj;
$proto16=array();
$obj = new SQLField(array(
"m_strName" => "grade",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto16["m_sql"] = "grade";
$proto16["m_srcTableName"] = "certificate";
$proto16["m_expr"]=$obj;
$proto16["m_alias"] = "";
$obj = new SQLFieldListItem($proto16);
$proto0["m_fieldlist"][]=$obj;
$proto18=array();
$obj = new SQLField(array(
"m_strName" => "Name",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto18["m_sql"] = "Name";
$proto18["m_srcTableName"] = "certificate";
$proto18["m_expr"]=$obj;
$proto18["m_alias"] = "";
$obj = new SQLFieldListItem($proto18);
$proto0["m_fieldlist"][]=$obj;
$proto20=array();
$obj = new SQLField(array(
"m_strName" => "father_name",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto20["m_sql"] = "father_name";
$proto20["m_srcTableName"] = "certificate";
$proto20["m_expr"]=$obj;
$proto20["m_alias"] = "";
$obj = new SQLFieldListItem($proto20);
$proto0["m_fieldlist"][]=$obj;
$proto22=array();
$obj = new SQLField(array(
"m_strName" => "Add",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto22["m_sql"] = "`Add`";
$proto22["m_srcTableName"] = "certificate";
$proto22["m_expr"]=$obj;
$proto22["m_alias"] = "";
$obj = new SQLFieldListItem($proto22);
$proto0["m_fieldlist"][]=$obj;
$proto24=array();
$obj = new SQLField(array(
"m_strName" => "Mobile",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto24["m_sql"] = "Mobile";
$proto24["m_srcTableName"] = "certificate";
$proto24["m_expr"]=$obj;
$proto24["m_alias"] = "";
$obj = new SQLFieldListItem($proto24);
$proto0["m_fieldlist"][]=$obj;
$proto26=array();
$obj = new SQLField(array(
"m_strName" => "Status",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto26["m_sql"] = "Status";
$proto26["m_srcTableName"] = "certificate";
$proto26["m_expr"]=$obj;
$proto26["m_alias"] = "";
$obj = new SQLFieldListItem($proto26);
$proto0["m_fieldlist"][]=$obj;
$proto28=array();
$obj = new SQLField(array(
"m_strName" => "Action",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto28["m_sql"] = "`Action`";
$proto28["m_srcTableName"] = "certificate";
$proto28["m_expr"]=$obj;
$proto28["m_alias"] = "";
$obj = new SQLFieldListItem($proto28);
$proto0["m_fieldlist"][]=$obj;
$proto30=array();
$obj = new SQLField(array(
"m_strName" => "photo",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto30["m_sql"] = "photo";
$proto30["m_srcTableName"] = "certificate";
$proto30["m_expr"]=$obj;
$proto30["m_alias"] = "";
$obj = new SQLFieldListItem($proto30);
$proto0["m_fieldlist"][]=$obj;
$proto32=array();
$obj = new SQLField(array(
"m_strName" => "address",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto32["m_sql"] = "address";
$proto32["m_srcTableName"] = "certificate";
$proto32["m_expr"]=$obj;
$proto32["m_alias"] = "";
$obj = new SQLFieldListItem($proto32);
$proto0["m_fieldlist"][]=$obj;
$proto34=array();
$obj = new SQLField(array(
"m_strName" => "certifcate_issue_date",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto34["m_sql"] = "certifcate_issue_date";
$proto34["m_srcTableName"] = "certificate";
$proto34["m_expr"]=$obj;
$proto34["m_alias"] = "";
$obj = new SQLFieldListItem($proto34);
$proto0["m_fieldlist"][]=$obj;
$proto36=array();
$obj = new SQLField(array(
"m_strName" => "branch",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto36["m_sql"] = "branch";
$proto36["m_srcTableName"] = "certificate";
$proto36["m_expr"]=$obj;
$proto36["m_alias"] = "";
$obj = new SQLFieldListItem($proto36);
$proto0["m_fieldlist"][]=$obj;
$proto38=array();
$obj = new SQLField(array(
"m_strName" => "months",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto38["m_sql"] = "months";
$proto38["m_srcTableName"] = "certificate";
$proto38["m_expr"]=$obj;
$proto38["m_alias"] = "";
$obj = new SQLFieldListItem($proto38);
$proto0["m_fieldlist"][]=$obj;
$proto40=array();
$obj = new SQLField(array(
"m_strName" => "start_date",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto40["m_sql"] = "start_date";
$proto40["m_srcTableName"] = "certificate";
$proto40["m_expr"]=$obj;
$proto40["m_alias"] = "";
$obj = new SQLFieldListItem($proto40);
$proto0["m_fieldlist"][]=$obj;
$proto42=array();
$obj = new SQLField(array(
"m_strName" => "end_date",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto42["m_sql"] = "end_date";
$proto42["m_srcTableName"] = "certificate";
$proto42["m_expr"]=$obj;
$proto42["m_alias"] = "";
$obj = new SQLFieldListItem($proto42);
$proto0["m_fieldlist"][]=$obj;
$proto44=array();
$obj = new SQLField(array(
"m_strName" => "center_address",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto44["m_sql"] = "center_address";
$proto44["m_srcTableName"] = "certificate";
$proto44["m_expr"]=$obj;
$proto44["m_alias"] = "";
$obj = new SQLFieldListItem($proto44);
$proto0["m_fieldlist"][]=$obj;
$proto46=array();
$obj = new SQLField(array(
"m_strName" => "subject",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto46["m_sql"] = "subject";
$proto46["m_srcTableName"] = "certificate";
$proto46["m_expr"]=$obj;
$proto46["m_alias"] = "";
$obj = new SQLFieldListItem($proto46);
$proto0["m_fieldlist"][]=$obj;
$proto48=array();
$obj = new SQLField(array(
"m_strName" => "pn1",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto48["m_sql"] = "pn1";
$proto48["m_srcTableName"] = "certificate";
$proto48["m_expr"]=$obj;
$proto48["m_alias"] = "";
$obj = new SQLFieldListItem($proto48);
$proto0["m_fieldlist"][]=$obj;
$proto50=array();
$obj = new SQLField(array(
"m_strName" => "pn1_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto50["m_sql"] = "pn1_total_marks";
$proto50["m_srcTableName"] = "certificate";
$proto50["m_expr"]=$obj;
$proto50["m_alias"] = "";
$obj = new SQLFieldListItem($proto50);
$proto0["m_fieldlist"][]=$obj;
$proto52=array();
$obj = new SQLField(array(
"m_strName" => "pn1_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto52["m_sql"] = "pn1_obtained_marks";
$proto52["m_srcTableName"] = "certificate";
$proto52["m_expr"]=$obj;
$proto52["m_alias"] = "";
$obj = new SQLFieldListItem($proto52);
$proto0["m_fieldlist"][]=$obj;
$proto54=array();
$obj = new SQLField(array(
"m_strName" => "pn2",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto54["m_sql"] = "pn2";
$proto54["m_srcTableName"] = "certificate";
$proto54["m_expr"]=$obj;
$proto54["m_alias"] = "";
$obj = new SQLFieldListItem($proto54);
$proto0["m_fieldlist"][]=$obj;
$proto56=array();
$obj = new SQLField(array(
"m_strName" => "pn3",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto56["m_sql"] = "pn3";
$proto56["m_srcTableName"] = "certificate";
$proto56["m_expr"]=$obj;
$proto56["m_alias"] = "";
$obj = new SQLFieldListItem($proto56);
$proto0["m_fieldlist"][]=$obj;
$proto58=array();
$obj = new SQLField(array(
"m_strName" => "pn4",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto58["m_sql"] = "pn4";
$proto58["m_srcTableName"] = "certificate";
$proto58["m_expr"]=$obj;
$proto58["m_alias"] = "";
$obj = new SQLFieldListItem($proto58);
$proto0["m_fieldlist"][]=$obj;
$proto60=array();
$obj = new SQLField(array(
"m_strName" => "pn5",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto60["m_sql"] = "pn5";
$proto60["m_srcTableName"] = "certificate";
$proto60["m_expr"]=$obj;
$proto60["m_alias"] = "";
$obj = new SQLFieldListItem($proto60);
$proto0["m_fieldlist"][]=$obj;
$proto62=array();
$obj = new SQLField(array(
"m_strName" => "pn6",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto62["m_sql"] = "pn6";
$proto62["m_srcTableName"] = "certificate";
$proto62["m_expr"]=$obj;
$proto62["m_alias"] = "";
$obj = new SQLFieldListItem($proto62);
$proto0["m_fieldlist"][]=$obj;
$proto64=array();
$obj = new SQLField(array(
"m_strName" => "pn7",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto64["m_sql"] = "pn7";
$proto64["m_srcTableName"] = "certificate";
$proto64["m_expr"]=$obj;
$proto64["m_alias"] = "";
$obj = new SQLFieldListItem($proto64);
$proto0["m_fieldlist"][]=$obj;
$proto66=array();
$obj = new SQLField(array(
"m_strName" => "pn8",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto66["m_sql"] = "pn8";
$proto66["m_srcTableName"] = "certificate";
$proto66["m_expr"]=$obj;
$proto66["m_alias"] = "";
$obj = new SQLFieldListItem($proto66);
$proto0["m_fieldlist"][]=$obj;
$proto68=array();
$obj = new SQLField(array(
"m_strName" => "pn9",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto68["m_sql"] = "pn9";
$proto68["m_srcTableName"] = "certificate";
$proto68["m_expr"]=$obj;
$proto68["m_alias"] = "";
$obj = new SQLFieldListItem($proto68);
$proto0["m_fieldlist"][]=$obj;
$proto70=array();
$obj = new SQLField(array(
"m_strName" => "pn10",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto70["m_sql"] = "pn10";
$proto70["m_srcTableName"] = "certificate";
$proto70["m_expr"]=$obj;
$proto70["m_alias"] = "";
$obj = new SQLFieldListItem($proto70);
$proto0["m_fieldlist"][]=$obj;
$proto72=array();
$obj = new SQLField(array(
"m_strName" => "pn2_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto72["m_sql"] = "pn2_total_marks";
$proto72["m_srcTableName"] = "certificate";
$proto72["m_expr"]=$obj;
$proto72["m_alias"] = "";
$obj = new SQLFieldListItem($proto72);
$proto0["m_fieldlist"][]=$obj;
$proto74=array();
$obj = new SQLField(array(
"m_strName" => "pn3_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto74["m_sql"] = "pn3_total_marks";
$proto74["m_srcTableName"] = "certificate";
$proto74["m_expr"]=$obj;
$proto74["m_alias"] = "";
$obj = new SQLFieldListItem($proto74);
$proto0["m_fieldlist"][]=$obj;
$proto76=array();
$obj = new SQLField(array(
"m_strName" => "pn4_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto76["m_sql"] = "pn4_total_marks";
$proto76["m_srcTableName"] = "certificate";
$proto76["m_expr"]=$obj;
$proto76["m_alias"] = "";
$obj = new SQLFieldListItem($proto76);
$proto0["m_fieldlist"][]=$obj;
$proto78=array();
$obj = new SQLField(array(
"m_strName" => "pn5_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto78["m_sql"] = "pn5_total_marks";
$proto78["m_srcTableName"] = "certificate";
$proto78["m_expr"]=$obj;
$proto78["m_alias"] = "";
$obj = new SQLFieldListItem($proto78);
$proto0["m_fieldlist"][]=$obj;
$proto80=array();
$obj = new SQLField(array(
"m_strName" => "pn6_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto80["m_sql"] = "pn6_total_marks";
$proto80["m_srcTableName"] = "certificate";
$proto80["m_expr"]=$obj;
$proto80["m_alias"] = "";
$obj = new SQLFieldListItem($proto80);
$proto0["m_fieldlist"][]=$obj;
$proto82=array();
$obj = new SQLField(array(
"m_strName" => "pn7_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto82["m_sql"] = "pn7_total_marks";
$proto82["m_srcTableName"] = "certificate";
$proto82["m_expr"]=$obj;
$proto82["m_alias"] = "";
$obj = new SQLFieldListItem($proto82);
$proto0["m_fieldlist"][]=$obj;
$proto84=array();
$obj = new SQLField(array(
"m_strName" => "pn8_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto84["m_sql"] = "pn8_total_marks";
$proto84["m_srcTableName"] = "certificate";
$proto84["m_expr"]=$obj;
$proto84["m_alias"] = "";
$obj = new SQLFieldListItem($proto84);
$proto0["m_fieldlist"][]=$obj;
$proto86=array();
$obj = new SQLField(array(
"m_strName" => "pn9_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto86["m_sql"] = "pn9_total_marks";
$proto86["m_srcTableName"] = "certificate";
$proto86["m_expr"]=$obj;
$proto86["m_alias"] = "";
$obj = new SQLFieldListItem($proto86);
$proto0["m_fieldlist"][]=$obj;
$proto88=array();
$obj = new SQLField(array(
"m_strName" => "pn10_total_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto88["m_sql"] = "pn10_total_marks";
$proto88["m_srcTableName"] = "certificate";
$proto88["m_expr"]=$obj;
$proto88["m_alias"] = "";
$obj = new SQLFieldListItem($proto88);
$proto0["m_fieldlist"][]=$obj;
$proto90=array();
$obj = new SQLField(array(
"m_strName" => "pn2_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto90["m_sql"] = "pn2_obtained_marks";
$proto90["m_srcTableName"] = "certificate";
$proto90["m_expr"]=$obj;
$proto90["m_alias"] = "";
$obj = new SQLFieldListItem($proto90);
$proto0["m_fieldlist"][]=$obj;
$proto92=array();
$obj = new SQLField(array(
"m_strName" => "pn3_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto92["m_sql"] = "pn3_obtained_marks";
$proto92["m_srcTableName"] = "certificate";
$proto92["m_expr"]=$obj;
$proto92["m_alias"] = "";
$obj = new SQLFieldListItem($proto92);
$proto0["m_fieldlist"][]=$obj;
$proto94=array();
$obj = new SQLField(array(
"m_strName" => "pn4_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto94["m_sql"] = "pn4_obtained_marks";
$proto94["m_srcTableName"] = "certificate";
$proto94["m_expr"]=$obj;
$proto94["m_alias"] = "";
$obj = new SQLFieldListItem($proto94);
$proto0["m_fieldlist"][]=$obj;
$proto96=array();
$obj = new SQLField(array(
"m_strName" => "pn5_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto96["m_sql"] = "pn5_obtained_marks";
$proto96["m_srcTableName"] = "certificate";
$proto96["m_expr"]=$obj;
$proto96["m_alias"] = "";
$obj = new SQLFieldListItem($proto96);
$proto0["m_fieldlist"][]=$obj;
$proto98=array();
$obj = new SQLField(array(
"m_strName" => "pn6_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto98["m_sql"] = "pn6_obtained_marks";
$proto98["m_srcTableName"] = "certificate";
$proto98["m_expr"]=$obj;
$proto98["m_alias"] = "";
$obj = new SQLFieldListItem($proto98);
$proto0["m_fieldlist"][]=$obj;
$proto100=array();
$obj = new SQLField(array(
"m_strName" => "pn7_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto100["m_sql"] = "pn7_obtained_marks";
$proto100["m_srcTableName"] = "certificate";
$proto100["m_expr"]=$obj;
$proto100["m_alias"] = "";
$obj = new SQLFieldListItem($proto100);
$proto0["m_fieldlist"][]=$obj;
$proto102=array();
$obj = new SQLField(array(
"m_strName" => "pn8_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto102["m_sql"] = "pn8_obtained_marks";
$proto102["m_srcTableName"] = "certificate";
$proto102["m_expr"]=$obj;
$proto102["m_alias"] = "";
$obj = new SQLFieldListItem($proto102);
$proto0["m_fieldlist"][]=$obj;
$proto104=array();
$obj = new SQLField(array(
"m_strName" => "pn9_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto104["m_sql"] = "pn9_obtained_marks";
$proto104["m_srcTableName"] = "certificate";
$proto104["m_expr"]=$obj;
$proto104["m_alias"] = "";
$obj = new SQLFieldListItem($proto104);
$proto0["m_fieldlist"][]=$obj;
$proto106=array();
$obj = new SQLField(array(
"m_strName" => "pn10_obtained_marks",
"m_strTable" => "certificate",
"m_srcTableName" => "certificate"
));
$proto106["m_sql"] = "pn10_obtained_marks";
$proto106["m_srcTableName"] = "certificate";
$proto106["m_expr"]=$obj;
$proto106["m_alias"] = "";
$obj = new SQLFieldListItem($proto106);
$proto0["m_fieldlist"][]=$obj;
$proto0["m_fromlist"] = array();
$proto108=array();
$proto108["m_link"] = "SQLL_MAIN";
$proto109=array();
$proto109["m_strName"] = "certificate";
$proto109["m_srcTableName"] = "certificate";
$proto109["m_columns"] = array();
$proto109["m_columns"][] = "ID";
$proto109["m_columns"][] = "Date_Reg";
$proto109["m_columns"][] = "enrollment";
$proto109["m_columns"][] = "CertificateNo";
$proto109["m_columns"][] = "Course";
$proto109["m_columns"][] = "grade";
$proto109["m_columns"][] = "Name";
$proto109["m_columns"][] = "father_name";
$proto109["m_columns"][] = "Add";
$proto109["m_columns"][] = "Mobile";
$proto109["m_columns"][] = "Status";
$proto109["m_columns"][] = "Action";
$proto109["m_columns"][] = "photo";
$proto109["m_columns"][] = "address";
$proto109["m_columns"][] = "certifcate_issue_date";
$proto109["m_columns"][] = "branch";
$proto109["m_columns"][] = "months";
$proto109["m_columns"][] = "start_date";
$proto109["m_columns"][] = "end_date";
$proto109["m_columns"][] = "center_address";
$proto109["m_columns"][] = "subject";
$proto109["m_columns"][] = "pn1";
$proto109["m_columns"][] = "pn1_total_marks";
$proto109["m_columns"][] = "pn1_obtained_marks";
$proto109["m_columns"][] = "pn2";
$proto109["m_columns"][] = "pn3";
$proto109["m_columns"][] = "pn4";
$proto109["m_columns"][] = "pn5";
$proto109["m_columns"][] = "pn6";
$proto109["m_columns"][] = "pn7";
$proto109["m_columns"][] = "pn8";
$proto109["m_columns"][] = "pn9";
$proto109["m_columns"][] = "pn10";
$proto109["m_columns"][] = "pn2_total_marks";
$proto109["m_columns"][] = "pn3_total_marks";
$proto109["m_columns"][] = "pn4_total_marks";
$proto109["m_columns"][] = "pn5_total_marks";
$proto109["m_columns"][] = "pn6_total_marks";
$proto109["m_columns"][] = "pn7_total_marks";
$proto109["m_columns"][] = "pn8_total_marks";
$proto109["m_columns"][] = "pn9_total_marks";
$proto109["m_columns"][] = "pn10_total_marks";
$proto109["m_columns"][] = "pn2_obtained_marks";
$proto109["m_columns"][] = "pn3_obtained_marks";
$proto109["m_columns"][] = "pn4_obtained_marks";
$proto109["m_columns"][] = "pn5_obtained_marks";
$proto109["m_columns"][] = "pn6_obtained_marks";
$proto109["m_columns"][] = "pn7_obtained_marks";
$proto109["m_columns"][] = "pn8_obtained_marks";
$proto109["m_columns"][] = "pn9_obtained_marks";
$proto109["m_columns"][] = "pn10_obtained_marks";
$obj = new SQLTable($proto109);
$proto108["m_table"] = $obj;
$proto108["m_sql"] = "certificate";
$proto108["m_alias"] = "";
$proto108["m_srcTableName"] = "certificate";
$proto110=array();
$proto110["m_sql"] = "";
$proto110["m_uniontype"] = "SQLL_UNKNOWN";
$obj = new SQLNonParsed(array(
"m_sql" => ""
));
$proto110["m_column"]=$obj;
$proto110["m_contained"] = array();
$proto110["m_strCase"] = "";
$proto110["m_havingmode"] = false;
$proto110["m_inBrackets"] = false;
$proto110["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto110);
$proto108["m_joinon"] = $obj;
$obj = new SQLFromListItem($proto108);
$proto0["m_fromlist"][]=$obj;
$proto0["m_groupby"] = array();
$proto0["m_orderby"] = array();
$proto0["m_srcTableName"]="certificate";
$obj = new SQLQuery($proto0);
return $obj;
}
$queryData_certificate = createSqlQuery_certificate();
;
$tdatacertificate[".sqlquery"] = $queryData_certificate;
$tableEvents["certificate"] = new eventsBase;
$tdatacertificate[".hasEvents"] = false;
?>
|