Language = $_SESSION[USER]->LANGUAGE;
$this->ToolBar->Buttons[btnSave]->blnShow = $this->Security->blnSave;
$this->ToolBar->Buttons[btnClose]->blnShow = 1;
$this->ToolBar->Buttons[btnReload]->blnShow = 1;
$this->ToolBar->Label = $this->Entity->Name ." ". $_TRANSLATION[$this->Language]["lblDetails"];
}
public function AssimulateTable($table, $ID, $altEntityHeadingField="")
{
global $db, $DATABASE_SETTINGS; //from system.php
//ini
$currentDB = $DATABASE_SETTINGS[$this->SystemSettings[SERVER_NAME]]->database;
$xdb = new NemoDatabase($table, $ID, null, 0);
if($ID != 0)
$this->ToolBar->Label .=": $ID";
else
$this->ToolBar->Label .=": New Record";
//print_rr($xdb->Fields);
mysqli_select_db($db, "information_schema");
$this->dbInfo = new NemoDatabase("");
$rst = $this->dbInfo->doQuery("SELECT COLUMNS.COLUMN_NAME, COLUMNS.ORDINAL_POSITION, COLUMNS.COLUMN_DEFAULT, COLUMNS.IS_NULLABLE, COLUMNS.DATA_TYPE, COLUMNS.COLUMN_TYPE, COLUMNS.CHARACTER_MAXIMUM_LENGTH, COLUMNS.EXTRA, COLUMNS.COLUMN_COMMENT, COLUMNS.COLUMN_KEY, KEY_COLUMN_USAGE.CONSTRAINT_NAME, KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME, KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME
FROM KEY_COLUMN_USAGE RIGHT JOIN COLUMNS ON (KEY_COLUMN_USAGE.TABLE_NAME = COLUMNS.TABLE_NAME) AND (KEY_COLUMN_USAGE.TABLE_SCHEMA = COLUMNS.TABLE_SCHEMA) AND (KEY_COLUMN_USAGE.COLUMN_NAME = COLUMNS.COLUMN_NAME)
WHERE (((COLUMNS.TABLE_SCHEMA)='$currentDB') AND ((COLUMNS.TABLE_NAME)='$table'))
ORDER BY COLUMNS.ORDINAL_POSITION ASC",0);
while($row = $this->dbInfo->fetch())
{
//INI 0
$blnContinue = 0;
if($this->hideOtherLanguage == true){
foreach(self::$Languages as $Lang)
{
if(strpos($row->COLUMN_NAME, $Lang ."_") === 0 && $Lang != $this->Language)
{
unset($this->Fields[$row->COLUMN_NAME]);
//print_rr($this->Fields); die;
$blnContinue = 1;
}
}}
if($blnContinue) continue;
//INI 1
$blnContinue = 0;
$this->Fields[$row->COLUMN_NAME] = $row;
$this->Fields[$row->COLUMN_NAME]->VALUE = $xdb->Fields[$row->COLUMN_NAME];
//default html control def
$this->Fields[$row->COLUMN_NAME]->Control->id =
$this->Fields[$row->COLUMN_NAME]->Control->name = $row->COLUMN_NAME;
$this->Fields[$row->COLUMN_NAME]->Label = NemoDetailsTranslator::cleanColumnName($row->COLUMN_NAME);
$this->Fields[$row->COLUMN_NAME]->Control->comment = $row->COLUMN_COMMENT;
$this->Fields[$row->COLUMN_NAME]->Control->IS_NULLABLE = $row->IS_NULLABLE;
if($xdb->Fields[$row->COLUMN_NAME] != "")
$this->Fields[$row->COLUMN_NAME]->Control->value = $xdb->Fields[$row->COLUMN_NAME];
else
$this->Fields[$row->COLUMN_NAME]->Control->value = $row->COLUMN_DEFAULT;
//PK
if($row->COLUMN_KEY == "PRI")
{
$this->Fields[$row->COLUMN_NAME]->Control->tag = "input";
$this->Fields[$row->COLUMN_NAME]->Control->type = "text"; //"hidden"
$this->Fields[$row->COLUMN_NAME]->Control->readonly = "readonly";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText controlLabel";
//$this->Fields[$row->COLUMN_NAME]->Control->value = "PRIMARY ID";
continue;// next record
}
//FK
if($row->COLUMN_KEY == "MUL" && $row->REFERENCED_TABLE_NAME != "")
{//print_rr($row);
if($row->IS_NULLABLE == "NO"){
$text = "- Select -";
}
else{
$text = "- None -";
}
$controlText = str_replace($table .".", $row->REFERENCED_TABLE_NAME .".", $row->CONSTRAINT_NAME);
$sqlDDL = "SELECT 0 AS ControlValue, '$text' AS ControlText
UNION ALL
SELECT `$row->REFERENCED_COLUMN_NAME` AS ControlValue, $controlText AS ControlText
FROM `$row->REFERENCED_TABLE_NAME`
WHERE blnActive = 1 OR `$row->REFERENCED_COLUMN_NAME` = '". $xdb->Fields[$row->COLUMN_NAME] ."'
ORDER BY ControlText ASC";
$this->Fields[$row->COLUMN_NAME]->Control->tag = "select";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText";
$this->Fields[$row->COLUMN_NAME]->sql = $sqlDDL;
$this->Fields[$row->COLUMN_NAME]->jsValidate = "
if(d('$row->COLUMN_NAME').value == '' || d('$row->COLUMN_NAME').value == 0)
msg += '\\n". $this->Fields[$row->COLUMN_NAME]->Label ."';
";
continue;// next record
}
//named columns 1
switch($row->COLUMN_NAME)
{
case "dtLastEdit":
case "dtFirstEdit":
if($xdb->Fields[$row->COLUMN_NAME] == "") $this->Fields[$row->COLUMN_NAME]->Control->value = date("Y-m-d h:i:s");
break;
case "strLastUser":
case "strFirstUser":
if($xdb->Fields[$row->COLUMN_NAME] == "") $this->Fields[$row->COLUMN_NAME]->Control->value = $this->SystemSettings[USER]->USERNAME;
break;
}
//named columns 2
switch($row->COLUMN_NAME)
{
case "dtFirstEdit":
case "dtLastEdit":
case "strFirstUser":
case "strLastUser":
$this->Fields[$row->COLUMN_NAME]->Control->tag = "input";
$this->Fields[$row->COLUMN_NAME]->Control->type = "text"; //"hidden"
$this->Fields[$row->COLUMN_NAME]->Control->readonly = "readonly";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText controlLabel";
//$this->Fields[$row->COLUMN_NAME]->Control->value = "ajlfbasf";
//do not add to jsValidate
$this->Fields[$row->COLUMN_NAME]->Control->IS_NULLABLE = "YES";
$blnContinue = 1;
}//note: using continue inside a switch does not effect the outer loop/while
if($blnContinue) continue;
//all other
if((strpos($row->COLUMN_NAME,'lst') === 0) || (strpos($row->COLUMN_NAME,'_lst') !== false))
{//20150317 - added datalist control type- pj/jj
//print_rr($row);
$this->Fields[$row->COLUMN_NAME]->Control->tag = "datalist";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText controlList";
$this->Fields[$row->COLUMN_NAME]->sql = "SELECT $row->COLUMN_NAME AS ControlValue, '' AS ControlText FROM $table GROUP BY $row->COLUMN_NAME ORDER BY ControlText"; // note: No "- Select/None -" option
$this->Fields[$row->COLUMN_NAME]->Control->autoconplete = "off";
//print_rr($this->Fields[$row->COLUMN_NAME]);
continue;
}
switch($row->DATA_TYPE)
{
case "varchar":
//textboxswitch($row->COLUMN_NAME)
$this->Fields[$row->COLUMN_NAME]->Control->tag = "input";
$this->Fields[$row->COLUMN_NAME]->Control->type = "text";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText";
$this->Fields[$row->COLUMN_NAME]->Control->maxlength = $row->CHARACTER_MAXIMUM_LENGTH;
$this->Fields[$row->COLUMN_NAME]->jsValidate = "
if(trim(d('$row->COLUMN_NAME').value) == ''){
msg += '\\n". $this->Fields[$row->COLUMN_NAME]->Label ."';
d('$row->COLUMN_NAME').value = '';
}
";
//print_rr($this->Fields[$row->COLUMN_NAME]);
break;
case "text":
//textarea
$this->Fields[$row->COLUMN_NAME]->Control->tag = "textarea";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText controlWideMax";
$this->Fields[$row->COLUMN_NAME]->Control->innerHTML = $this->Fields[$row->COLUMN_NAME]->Control->value;
$this->Fields[$row->COLUMN_NAME]->jsValidate = "
if(trim(d('$row->COLUMN_NAME').value) == ''){
msg += '\\n". $this->Fields[$row->COLUMN_NAME]->Label ."';
d('$row->COLUMN_NAME').value = '';
}
";
break;
case "double":
case "int":
$this->Fields[$row->COLUMN_NAME]->Control->tag = "input";
$this->Fields[$row->COLUMN_NAME]->Control->type = "text";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText controlNumeric";
$this->Fields[$row->COLUMN_NAME]->Control->onblur = "removeAlpha(this);";
$this->Fields[$row->COLUMN_NAME]->jsValidate = "
if( isNaN(d('$row->COLUMN_NAME').value) )
{
msg += '\\n". $this->Fields[$row->COLUMN_NAME]->Label ."';
}
";
break;
case "tinyint":
//chk
$this->Fields[$row->COLUMN_NAME]->Control->tag = "input";
$this->Fields[$row->COLUMN_NAME]->Control->type = "checkbox";
$this->Fields[$row->COLUMN_NAME]->Control->value = "checked";
$this->Fields[$row->COLUMN_NAME]->Control->IS_NULLABLE = "YES";
//var_dump($xdb->Fields[$row->COLUMN_NAME]);
if($xdb->Fields[$row->COLUMN_NAME] == 1)
{
$this->Fields[$row->COLUMN_NAME]->Control->checked = "checked";
}
elseif($xdb->Fields[$row->COLUMN_NAME] === "0")
{//$xdb->Fields[] > string(1) "0" if no record is loaded, but blnX = 0
unset($this->Fields[$row->COLUMN_NAME]->Control->checked);
}
elseif($row->COLUMN_DEFAULT == 1)
{//$xdb->Fields[] > int(0) if no record is loaded
$this->Fields[$row->COLUMN_NAME]->Control->checked = "checked";
}
$this->Fields[$row->COLUMN_NAME]->jsValidate = "
if( isNaN(d('$row->COLUMN_NAME').value) )
{
msg += '\\n". $this->Fields[$row->COLUMN_NAME]->Label ."';
}
";
break;
case "enum":
//ddl values = $row->COLUMN_TYPE, eg. COLUMN_TYPE: enum('Test Value1','Test Value 2')
eval("\$arrValues = ". str_replace("enum", "array", $row->COLUMN_TYPE).";");
//print_rr($arrValues);die;
if($row->IS_NULLABLE == "NO"){
$text = "- Select -";
}
else{
$text = "- None -";
}
$sqlDDL = "";
foreach($arrValues as $value){
$sqlDDL .= " UNION ALL SELECT '$value' AS ControlValue, '$value' AS ControlText ";
}
$sqlDDL = "SELECT 0 AS ControlValue, '$text' AS ControlText
$sqlDDL
ORDER BY ControlText ASC";
$this->Fields[$row->COLUMN_NAME]->jsValidate = "
if(d('$row->COLUMN_NAME').value == '' || d('$row->COLUMN_NAME').value == 0)
msg += '\\n". $this->Fields[$row->COLUMN_NAME]->Label ."';
";
$this->Fields[$row->COLUMN_NAME]->Control->tag = "select";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText";
$this->Fields[$row->COLUMN_NAME]->sql = $sqlDDL;
break;
case "date":
//date box
$this->Fields[$row->COLUMN_NAME]->Control->tag = "input";
$this->Fields[$row->COLUMN_NAME]->Control->type = "text";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText controlNumeric controlDateTime datePicker";
$this->Fields[$row->COLUMN_NAME]->Control->readonly = "readonly";
if($row->IS_NULLABLE == "NO"){
if($this->Fields[$row->COLUMN_NAME]->Control->value == "" || $this->Fields[$row->COLUMN_NAME]->Control->value == "0000-00-00")
$this->Fields[$row->COLUMN_NAME]->Control->value = date("Y-m-d");
}elseif($this->Fields[$row->COLUMN_NAME]->Control->value == "0000-00-00")
$this->Fields[$row->COLUMN_NAME]->Control->value = "";
$this->Fields[$row->COLUMN_NAME]->jsValidate = "
if(d('$row->COLUMN_NAME').value == '' || d('$row->COLUMN_NAME').value == '0000-00-00')
msg += '\\n". $this->Fields[$row->COLUMN_NAME]->Label ."';
";
break;
case "datetime":
case "timestamp":
//label
$this->Fields[$row->COLUMN_NAME]->Control->tag = "input";
$this->Fields[$row->COLUMN_NAME]->Control->type = "text"; //"hidden"
$this->Fields[$row->COLUMN_NAME]->Control->readonly = "readonly";
$this->Fields[$row->COLUMN_NAME]->Control->class = "controlText controlLabel controlDateTime";
//$this->Fields[$row->COLUMN_NAME]->Control->value = "ajlfbasf";
break;
}//eoSwitch
}
//post
//print_rr($this->Fields);
mysqli_select_db($db, $currentDB);
$this->renderControls();
//vd($ID);
if($ID == null){
$this->ToolBar->Label .=": New Record";
}else{
if($altEntityHeadingField == ""){
$altEntityHeadingField = $ID;
}
else{
$altEntityHeadingField = $this->Fields[$altEntityHeadingField]->VALUE;
}
$this->ToolBar->Label .=": $altEntityHeadingField";
}
}
public function getJsNemoValidateSave($jsExtra="", $jsFuctionName="jsNemoValidateSave")
{//vd($this->jsValidate);
return "";
}
public function getJsNemoValidateSaveTabs($jsExtra="", $jsFuctionName="jsNemoValidateSave")
{//vd($this->jsValidate);
return "
function $jsFuctionName()
{
var msg = '';
$this->jsValidate
$jsExtra
if(msg == '')
{
return true;
}else
{
alert('Please complete all the required fields: \\n'+ msg);
return false;
}
}
";
}
public static function cleanColumnName($ColumnName)
{//remove the "str" and add spaces for every "word"
global $_TRANSLATION;
//$translateTable = array("["=>"`",
// "]"=>"`");//"funny chars" => "new chars". just add into the array
//$sql = strtr($sql, $translateTable);
//ini_set('display_errors', '0');
$count = strlen($ColumnName);
$i = 0;
$ii = 0;
$boolCap = false;
$intCap = 0;
$Output = "";
//20150306 - translation engine - pj
foreach(self::$Languages as $Lang)
{
if(strpos($ColumnName, $Lang."_") === 0) //if it is the first 3chars
{
$ColumnName = substr($ColumnName, 3);
if($_TRANSLATION[$Lang][$ColumnName] != "")
return $_TRANSLATION[$Lang][$ColumnName];
else
return "".$Lang."_$ColumnName";
}
}
if($_TRANSLATION[$_SESSION["USER"]->LANGUAGE][$ColumnName] != ""){
return $_TRANSLATION[$_SESSION["USER"]->LANGUAGE][$ColumnName];
}
return parent::cleanColumnName($ColumnName);
}
}
?>