<?php
/**
* @author Prakash Khanchandani
* @copyright 2013
* @program classes.php
* @description
* just has require statements for the class files,
* the defines, and,
* the common functions
*/
require_once ("HTML/Template/ITX.php");
require_once ("mstrScripts.php");
require_once ("mstrTable.php");
require_once ("header.php");
require_once ("mstrFH.php");
require_once ("demoNotes.php");
define("Def_DbIp", "127.0.0.1");
define("Def_DbUser", "root");
define("Def_DbPassword", "");
define("Def_DbName", "test");
define("Def_commentSpan", '<span style="color:green;">');
define("Def_adtnlInfoSpan", '<span style="color:orange;">');
define("templatePath", "./");
define("host", "//localhost/xampp/banking/tableMaintenance/");
define("Def_LstBG", "rgb(245,245,245)");
define("Def_delBtnStl", "color:red; font-weight:bold;");
define("Def_MainFrmNm", "mainForm");
define("Def_normalPromptStyle", "prompt");
define("Def_notNullPromptStyle", "notNullPrompt");
define("Def_nullPromptStyle", "nullPrompt");
define("Def_promptUpdStyle", "error");
define("Def_blankAllowedEntryStyle", "entryBox");
define("Def_blankNotAllowedEntryStyle", "entryBoxWithBorder");
define("Def_MaxRowsToDspl", "25");
define("Def_PrevImageName",
"//localhost/xampp/banking/tableMaintenance/bt-left-icon.png");
define("Def_NextImageName",
"//localhost/xampp/banking/tableMaintenance/bt-right-icon.png");
define("labelReplacements", "./nmProperties.fl");
/**
* IMPROVEMENTS THAT CAN BE DONE
* =============================
* every func computes the count of this->colDefs. Can be done once and stored in a protected class var
* change the name defaultRecordAlreadyExists(). Remember to change the names in all files where used.
* change the name defaultCanDelete() to canDelete(). If client programs call explicit canDelete() you
* will have to change it to parent:canDelete() and then the local canDelete().
*/
function dateCheck($str)
{
/* gets the date components in an array. Uses a standard php func to validate
the date. Applies own validation that the year should be more than 1900.
Returns either a false or returns the date in the internal notation - ymd.
*/
$dtArray = strToDtComponents($str);
if (!is_numeric($dtArray[2]) || !is_numeric($dtArray[1]) || !is_numeric($dtArray[0]))
return false;
if ($dtArray[0] < 1900)
return false;
if (!checkdate($dtArray[1], $dtArray[2], $dtArray[0]))
return false;
return $dtArray[0] . '-' . $dtArray[1] . '-' . $dtArray[2];
}
function strToDtComponents($str)
{
/* extracts and returns y, m and d components, in that order, in an array.
The string can be either in Indian format, dmy, or Gregorian, mdy.
Depending on the session setting, this func will apply the correct
interpretation. */
// extract components depending on the date format setting in the session.
if ($_SESSION['dateFormat'] == 'dmy')
list($d, $m, $y) = extractComponents($str);
else
list($m, $d, $y) = extractComponents($str);
// if the user has entered a 2 digit year, precede it with 20.
if (strlen($y) == 1)
$y = '200' . $y;
elseif (strlen($y) == 2)
$y = '20' . $y;
elseif (strlen($y) == 3)
$y = '2' . $y;
/* pad m and d with 0 if required. Otherwise, for example, 1-1-2009 will not
be less than 26-02-2009 when you compare them. */
$m = str_pad($m, 2, '0', STR_PAD_LEFT);
$d = str_pad($d, 2, '0', STR_PAD_LEFT);
$dtArray = array($y, $m, $d);
return $dtArray;
}
function extractComponents($strng, $pattern = "/[\s,.\/-]/")
{
return preg_split($pattern, $strng, -1, PREG_SPLIT_NO_EMPTY);
}
function addToErrorMsg($msg)
{
/* if an error message is already set
add to it at the bottom, else set error msg */
if (!isset($_SESSION['errorMsg']) or $_SESSION['errorMsg'] == '' or is_null($_SESSION['errorMsg'])) {
$_SESSION['errorMsg'] = $msg;
} else {
$_SESSION['errorMsg'] = $_SESSION['errorMsg'] . "<br>" . $msg;
}
return;
}
function displayFormatDate($inDate)
{
/*
given the internal format date, ymd,
returns the date in the user's local format.
*/
$dateComponents = explode("-", $inDate);
if ($_SESSION['dateFormat'] == 'dmy')
return $dateComponents[2] . "-" . $dateComponents[1] . "-" . $dateComponents[0];
else
return $dateComponents[1] . "-" . $dateComponents[2] . "-" . $dateComponents[0];
}
function m_str_replace($srch, $str)
{
// remove occurences of each char in srch from str
// if str = _('Y','N')_ and srch=_'()_, the return will be Y,N
$count = strlen($srch);
for ($i = 0; $i < $count; $i++) {
$removeChar = substr($srch, $i, 1);
$str = str_replace($removeChar, '', $str);
}
return $str;
}
function found_in_array($needle, $hayStack)
{
return array_search($needle, $hayStack);
/**
* dont remember why i wrote the func below. Anyway, I am now returning the result of
* array_search above and the code below is unused. Have left it as it is in case I
* remember the reason for writing it in the first place.
*/
if (!is_array($hayStack))
return false;
$count = count($hayStack);
for ($i = 0; $i < $count; $i++)
if ($needle == $hayStack[$i])
return $i + 1;
return false;
}
function handleRequestOption()
{
$self = $_SERVER['PHP_SELF'];
switch ($_REQUEST['actn']) {
case 'next':
case 'prev':
case 'cancel':
$obj = createTableObject();
return $obj;
case 'select':
// if 'id' not set, error
if (!isset($_REQUEST['id'])) {
addToErrorMsg($self);
addToErrorMsg("no id for selected record");
trmntMstMnt();
}
$obj = createTableObject();
if ($obj->populateRecordValues() === false) {
addToErrorMsg($self . " (handleRequestOptions)");
trmntMstMnt();
}
return $obj;
case 'delete':
// if 'id' not set, error
//echo '<pre>';print_r($_REQUEST);die();
if (!isset($_REQUEST['id'])) {
addToErrorMsg($self);
addToErrorMsg("no id for selected record");
trmntMstMnt();
}
$obj = createTableObject();
if ($obj->populateRecordValues() === false) {
addToErrorMsg($self . " (handleRequestOptions)");
trmntMstMnt();
}
return $obj; // to get confirmation to delete.
case 'dltConfirm':
if (!isset($_REQUEST['id'])) {
addToErrorMsg($self);
addToErrorMsg("no id for selected record");
trmntMstMnt();
}
$obj = createTableObject();
/* populate values from request manually. */
$obj->populateValuesFromRequest();
if ($obj->deleteRecord() === false)
trmntMstMnt();
addToErrorMsg($obj->getId() . ': DELETED');
$obj->getListAndColumns();
return $obj;
case 'add':
$obj = createTableObject();
/* validate the user inputs. The validation function
would have set an error flag in case some
validations fail else the flag will be reset. */
$obj->checkInputs();
/* whether inputs are valid or not, return the object.
if inputs valid, the form will be in read only mode
and asking for confirmation, else user can make
corrections. */
return $obj;
case 'addConfirm':
$obj = createTableObject();
/* during the add stage, the checkInputs call
populated the colValu from $_REQUEST variables.
Secondly, the process of validating the remoteGL
also populated the colValu elements of the
individual account components. At this stage,
after addConfirm, we are not doing the validations
again. So, the populate functions have to be
called manually. */
$obj->populateValuesFromRequest();
if ($obj->addRecord() === false)
trmntMstMnt();
addToErrorMsg('CREATED');
/* recreate the list. Technically, the function below
can return an error, but by this time we have
executed it at least 3 times so why should it fail
now, the 4th? */
$obj->getListAndColumns();
return $obj;
case 'update':
// if 'id' not set, error
if (!isset($_REQUEST['id'])) {
addToErrorMsg($self);
addToErrorMsg("no id for selected record");
trmntMstMnt();
}
$obj = createTableObject();
/* check the user inputs. If invalid, return object
without any more checks */
if ($obj->checkInputs() === false)
return $obj;
/* if inputs valid, check with record whether any
changes made. The check function will leave an
appropriate message. */
$obj->checkIfValuesDifferent();
return $obj;
case 'updConfirm':
// if 'id' not set, error
if (!isset($_REQUEST['id'])) {
addToErrorMsg($self);
addToErrorMsg("no id for selected record");
trmntMstMnt();
}
$obj = createTableObject();
/* populate colDefs vars from $_REQUEST manually. */
$obj->populateValuesFromRequest();
if ($obj->updateRecord() === false)
trmntMstMnt();
addToErrorMsg($obj->getId() . ' - UPDATED');
// recreate the list. Dont bother about its return value
$obj->getListAndColumns();
return $obj;
default:
addToErrorMsg($self);
addToErrorMsg("unknown request action:" . $_REQUEST['actn']);
trmntMstMnt();
}
}
function trmntMstMnt()
{
$form = new mstrFH('');
/* you are passing a blank var above instead of an object
so the form will only display the error msg. */
$form->show();
die();
}
?>
|
Download
