<?php
// This script and data application were generated by AppGini 4.3
// Download AppGini for free from http://www.bigprof.com/appgini/download/

	include(dirname(__FILE__)."/defaultLang.php");
	include(dirname(__FILE__)."/language.php");
	include(dirname(__FILE__)."/lib.php");
	include(dirname(__FILE__)."/tcg_dml.php");
	// mm: can the current member access this page?
	$perm=getTablePermissions('tcg');
	if(!$perm[0]){
		echo StyleSheet();
		echo "<div class=\"error\">".$Translation['tableAccessDenied']."</div>";
		echo '<script language="javaScript">setInterval("window.location=\'index.php?signOut=1\'", 2000);</script>';
		exit;
	}

	$x = new DataList;
	$x->TableName = "tcg";

	// Fields that can be displayed in the table view
	$x->QueryFieldsTV=array(
		"tcg.SlNo" => "SlNo",
		"tcg.PrgNo" => "PrgNo",
		"tcg.PrgName" => "PrgName",
		"tcg.InvoiceNo" => "InvoiceNo",
		"tcg.ClientsName" => "ClientsName",
		"tcg.Dates" => "Dates",
		"tcg.Days" => "Days",
		"tcg.ProfFee" => "ProfFee",
		"tcg.TrainerName" => "TrainerName",
		"tcg.TrainerFee" => "TrainerFee",
		"tcg.ReimbExp" => "ReimbExp",
		"tcg.HandoutChg" => "HandoutChg",
		"tcg.TotalInvAmt" => "TotalInvAmt",
		"tcg.FeeRecd" => "FeeRecd"
	);
	// Fields that can be displayed in the csv file
	$x->QueryFieldsCSV=array(
		"tcg.SlNo" => "SlNo",
		"tcg.PrgNo" => "PrgNo",
		"tcg.PrgName" => "PrgName",
		"tcg.InvoiceNo" => "InvoiceNo",
		"tcg.ClientsName" => "ClientsName",
		"tcg.Dates" => "Dates",
		"tcg.Days" => "Days",
		"tcg.ProfFee" => "ProfFee",
		"tcg.TrainerName" => "TrainerName",
		"tcg.TrainerFee" => "TrainerFee",
		"tcg.ReimbExp" => "ReimbExp",
		"tcg.HandoutChg" => "HandoutChg",
		"tcg.TotalInvAmt" => "TotalInvAmt",
		"tcg.FeeRecd" => "FeeRecd"
	);
	// Fields that can be filtered
	$x->QueryFieldsFilters=array(
		"tcg.SlNo" => "SlNo",
		"tcg.PrgNo" => "PrgNo",
		"tcg.PrgName" => "PrgName",
		"tcg.InvoiceNo" => "InvoiceNo",
		"tcg.ClientsName" => "ClientsName",
		"tcg.Dates" => "Dates",
		"tcg.Days" => "Days",
		"tcg.ProfFee" => "ProfFee",
		"tcg.TrainerName" => "TrainerName",
		"tcg.TrainerFee" => "TrainerFee",
		"tcg.ReimbExp" => "ReimbExp",
		"tcg.HandoutChg" => "HandoutChg",
		"tcg.TotalInvAmt" => "TotalInvAmt",
		"tcg.FeeRecd" => "FeeRecd"
	);

	$x->QueryFrom="tcg ";
	$x->QueryWhere='';
	$x->QueryOrder='';

	$x->DataHeight = 150;
	$x->AllowSelection = 1;
	$x->HideTableView = ($perm[2]==0 ? 1 : 0);
	$x->AllowDelete = $perm[4];
	$x->AllowInsert = $perm[1];
	$x->AllowUpdate = $perm[3];
	$x->SeparateDV = 0;
	$x->AllowDeleteOfParents = 0;
	$x->AllowFilters = 1;
	$x->AllowSavingFilters = 0;
	$x->AllowSorting = 1;
	$x->AllowNavigation = 1;
	$x->AllowPrinting = 1;
	$x->AllowCSV = 1;
	$x->RecordsPerPage = 10;
	$x->QuickSearch = 3;
	$x->QuickSearchText = $Translation["quick search"];
	$x->ScriptFileName = "tcg_view.php";
	$x->RedirectAfterInsert = "tableName_view.php?SelectedID=#ID#";
	$x->TableTitle = "Tcg";
	$x->PrimaryKey = "tcg.SlNo";

	$x->ColWidth   = array(70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70);
	$x->ColCaption = array("SlNo", "PrgNo", "PrgName", "InvoiceNo", "ClientsName", "Dates", "Days", "ProfFee", "TrainerName", "TrainerFee", "ReimbExp", "HandoutChg", "TotalInvAmt", "FeeRecd");
	$x->ColNumber  = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14);

	$x->Template = 'templates/tcg_templateTV.html';
	$x->SelectedTemplate = 'templates/tcg_templateTVS.html';
	$x->ShowTableHeader = 1;
	$x->ShowRecordSlots = 0;
	$x->HighlightColor = '#FFF0C2';

	// mm: build the query based on current member's permissions
	if($perm[2]==1){ // view owner only
		$x->QueryFrom.=', membership_userrecords';
		$x->QueryWhere="where tcg.SlNo=membership_userrecords.pkValue and membership_userrecords.tableName='tcg' and lcase(membership_userrecords.memberID)='".getLoggedMemberID()."'";
	}elseif($perm[2]==2){ // view group only
		$x->QueryFrom.=', membership_userrecords';
		$x->QueryWhere="where tcg.SlNo=membership_userrecords.pkValue and membership_userrecords.tableName='tcg' and membership_userrecords.groupID='".getLoggedGroupID()."'";
	}elseif($perm[2]==3){ // view all
		// no further action
	}elseif($perm[2]==0){ // view none
		$x->QueryFields = array("Not enough permissions" => "NEP");
		$x->QueryFrom = 'tcg';
		$x->QueryWhere = '';
		$x->DefaultSortField = '';
	}

	// handle date sorting correctly
	// end of date sorting handler

	$x->Render();

	include(dirname(__FILE__)."/header.php");
	echo $x->HTML;
	include(dirname(__FILE__)."/footer.php");
?><center><font size=-2><?php echo $Translation["powered by"]; ?> Vimal Anand @ 91-998-567-3219</font></center>

Hello,

The above code is generated by a software after connecting it to the database. The output is very nice but how do I write this kind of code. Or what do I need to learn to write or customize this code.

Please help.

This article has been dead for over six months. Start a new discussion instead.