PHP Builder

[administrator]

BETA version 4.1.7 of PHP DataGrid is available for downloading from
>> here <<

Examples of using and code syntax see in code_template.php file.

Main additions and improvements:
* Feature: [added] new method setJsErrorsDisplayStyle() and option to display
all error together
* Feature: [added] new option "textbox" in "view_type" for foreign keys
* Feature: [added] new field type in add/edit modes: "hidden"
* Feature: [added] new field type in add/edit/details modes: "delimiter"

* Feature: [improved] details/delete and multi-row columns have fixed width
* Feature: [improved] parameter "image_name" renamed in "file_name" for "image" and "file" types in add/edit/detail modes
* Feature: [improved] css classes naming and work
* Feature: [improved] encoding of data. Added collation parameter in setEncoding()
* Feature: [improved] debugger messaging system
* Feature: [improved] getting Primary Key and spliting strings in the code

# Bug: [Fixed] error if missing "req_type" parameter in add/edit/detail modes
# Bug: [Fixed] small bug with multi-row in details mode with tabular layout
# Bug: [Fixed] small bug in title for textarea
# Bug: [Fixed] small bug in setInterfaceLang()
# Bug: [Fixed] file uploading error in add mode
# Bug: [Fixed] wrong handling of "unique" parameter in add/edit mode
# Bug: [Fixed] highlighting small bug in view/details mode
# Bug: [Fixed] wrong fieldset width in view mode
# Bug: [Fixed] wrong ORDER BY parameter in SELECT SQL in add mode
# Bug: [Fixed] wrong alignment of foreign key output
# Bug: [Fixed] wrong displaying of datagrid in print preview in edit/detail modes
# Bug: [Fixed] css clas_a/class_a2 missed parameter
# Bug: [Fixed] missed unique prefix for cookie vars in hideUnHideFiltering() function
# Bug: [Fixed] unexpected 'http://'s in link type in view/detail modes

[fcallez]

Hello

Please, including the following in the next version

code :

----------------------------------------------------------------------
function getFieldValueByType($field_value, $ind, $row, $field_name=""){

...


case "password":
return "&nbsp;<label class='class_label' ".$title." ".$on_js_event.">******</label>&nbsp;";
break;


// Addition the 18/08/07 - Start

case "datedmy":
return "&nbsp;<label class='class_label' ".$title." ".$on_js_event.">".$this->myDate($field_value, "datedmy")."</label>&nbsp;";
break;

case "datetimedmy":
return "&nbsp;<label class='class_label' ".$title." ".$on_js_event.">".$this->myDate($field_value, "datetimedmy")."</label>&nbsp;";
break;

// Addition the 18/08/07 - end


default:
return "&nbsp;<label class='class_label' ".$title." ".$on_js_event.">".trim($field_value)."</label>&nbsp;"; break;
}
}

....

....


// if there is a file (uploaded or exists)
if($file == true){
if(strlen($field_value) > 40){
$str_start = strlen($field_value) - 40;
$str_prefix = "...";
}else{
$str_start = 0;
$str_prefix = "";
}
//$ret_file .= "<input type='hidden' name='".$this->unique_prefix."file_act' id='".$this->unique_prefix."file_act' value='remove' />";
$ret_file .= "<table><tr valign='middle'><td align='center'>";
if($field_type == "image"){


// Addition the 18/08/07 - Start


$img_width = (isset($this->columns_view_mode[$field_name]['image_width']) ? $this->columns_view_mode[$field_name]['image_width'] : "120px");
$img_height = (isset($this->columns_view_mode[$field_name]['image_height']) ? $this->columns_view_mode[$field_name]['image_height'] : "90px");

$ret_file .= "&nbsp;<img src='".$target_path.$field_value."' height='".$img_height."' width='".$img_width."' title='$field_value' alt='$field_value'/>&nbsp;";



// Modify the 18/08/07 - End


// delete the 18/08/07 Start

// $ret_file .= "&nbsp;<img src='".$target_path.$field_value."' height='90px' width='120px' title='$field_value' alt='$field_value'/>&nbsp;";

// delete the 18/08/07 End



}else{
$ret_file .= "&nbsp;".$str_prefix.substr($file_name_view, $str_start, 40)."&nbsp;";
}

....
-------------------------------------------------

Thanks
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[fcallez]

Hello:

Developing examples of use of the phpdatagrid in an academic and administration information system,

Many datagrid working at the same time ( a father and several children, etc.),

If You wishes to see the examples, making click in the following link:


http://www.gruporaimondi.com/istsiga2/sisadm/admin/


And follow the following steps:

User : leumas
Password : naypoka

Show a new window - authentication

User: leumas
Password: naypoka

Option: Mnto. tabla

Show a new window

Menu: Selecting

1 Tablas

2. Eqs. Empresarial


Seeing advances, models - the fabulous datagrid's use

Thanks

I expect remarks and suggestions.

Thanks
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[fcallez]

Hello:

Validating information of the side of the customer - examples
Several datagrid working at the same time

examples :

program : code_examples.php

-------------------------------------------------

<html >
<head>
<meta name="keywords" content="Sistema de Gestión Academica y Administrativa para Institutos Superiores Tecnológicos" />
<meta name="description" content="ISTSIGA2 - Sistema de gestion academica y administrativa para institutos superiores tecnologicos" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ISTSIGA2 - Sistema de Gestión Academica y Administrativa para Institutos Superiores Tecnológicos</title>

<script>

var bgcolor_error = "#ff8822";

function f_onSubmitMyCheck(){

if (confirm('Esta seguro de enviar este formulario?')){
return true;
}
else {
return false;
}
}

function f1_onSubmitMyCheck(){

if (confirm('Esta seguro de enviar este formulario?')){
return true;
}
else {
return false;
}
}

function f2_onSubmitMyCheck(){

if (confirm('Esta seguro de enviar este formulario?')){
return true;
}
else {
return false;
}
}

function f3_onSubmitMyCheck(){

// Validacion personalizada del formulario Nro. 3 : f3_ - grado_estudio_personal
// Campos : colegiado S ? nro_colegiatura debe de contener un valor mayor que cero
// Campos : colegiado N ? nro_colegiatura debe de ser cero

coleok = false
nrocole = ""

cole = document.f3_frmEditRow.stycolegiado[0].value
coleok = document.f3_frmEditRow.stycolegiado[0].checked

nrocole = document.f3_frmEditRow.siynro_colegiatura.value


if(coleok ){
if (nrocole == 0) {
alert("Ud. debe de ingresar un Nro. de Colegiatura !!!");
document.f3_frmEditRow.siynro_colegiatura.style.background = bgcolor_error;
document.f3_frmEditRow.siynro_colegiatura.value.focus()
return false;
}
else {
if (confirm('Esta seguro de enviar este formulario?')){
return true;
}
else {
return false; }
}
}else{
if(nrocole == 0) {
if (confirm('Esta seguro de enviar este formulario?')){
return true;
}
else {
return false; }
}
else {
alert("Nro. de Colegiatura debe de estar vacio !!!\nUd ha ingresado : "+nrocole);
document.f3_frmEditRow.siynro_colegiatura.style.background = bgcolor_error;
document.f3_frmEditRow.siynro_colegiatura.value.focus()
return false; }
}

}
</script>

</head>

<body>


.....................

1er datagrid

....

$messaging = true;
$unique_prefix = "f_";

$dgrid = new DataGrid($debug_mode, $messaging, $unique_prefix, DATAGRID_DIR);

....

$anotherDatagrids = array(
"f1_"=>array("view"=>false, "edit"=>true, "details"=>true),
"f2_"=>array("view"=>true, "edit"=>true, "details"=>true),
"f3_"=>array("view"=>true, "edit"=>true, "details"=>true),
"f4_"=>array("view"=>true, "edit"=>true, "details"=>true)
);
$dgrid->setAnotherDatagrids($anotherDatagrids);

.............

2do. datagrid

....

$messaging = true;
$unique_prefix = "f1_";

$dgrid1 = new DataGrid($debug_mode, $messaging, $unique_prefix, DATAGRID_DIR);
....

$anotherDatagrids = array(
"f_"=>array("view"=>true, "edit"=>true, "details"=>true),
"f2_"=>array("view"=>true, "edit"=>true, "details"=>true),
"f3_"=>array("view"=>true, "edit"=>true, "details"=>true),
"f4_"=>array("view"=>true, "edit"=>true, "details"=>true)

);
$dgrid1->setAnotherDatagrids($anotherDatagrids);

....

And so on

....

...........................

class : datagrid.class.php

....

function setEditFieldsFormScript($url=""){
echo "<script type='text/javascript'>\n";
echo "<!--//\n";
//echo $url;
//document.".$this->unique_prefix."frmEditRow.action ='".str_replace($this->amp,'&',$url)."';

// Modificado el 21/08/07 - A efecto de preparar validaciones personalizadas, del lado del cliente, casos especificos
// echo "function ".$this->unique_prefix."sendEditFields(){
// if(window.onSubmitMyCheck){ if(!onSubmitMyCheck()){ return false; } }

echo "function ".$this->unique_prefix."sendEditFields(){
if(window.".$this->unique_prefix."onSubmitMyCheck){ if(!".$this->unique_prefix."onSubmitMyCheck()){ return false; } }
if(onSubmitCheck(document.".$this->unique_prefix."frmEditRow, ".$this->js_validation_errors.")){
";

.....

---------------------------------------------------------

If You wishes to see an example, reading the previous intervention on the foro

Greetings
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez