PHP Builder

[administrator]

BETA version 4.1.8 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 option (not documented): hide grid before serach
* Feature: [added] new parameter: "unique_condition" in add/edit modes
* Feature: [improved] uploading files
* Feature: [improved] ability to use virtual fields in "field_name" parameter for
foreign keys
ex.: "field_name"=>"CONCAT(name1, ', ', name2) as name3"

* Feature: [improved] added maxlength properties for textarea type
* Feature: [improved] removed updating readonly fields
* Feature: [improved] including javasript files
* Feature: [improved] language file
* Feature: [improved] getVariable method()

# Bug: [Fixed] missing unique prefix for onSubmitMyCheck
# Bug: [Fixed] language including error after search
# Bug: [Fixed] with &amp; (added new data member - $amp)
# Bug: [Fixed] checking of current mode in noDataFound() method
# Bug: [Fixed] in bottom paging turning off
# Bug: [Fixed] showing calendar in add/edit modes when field is readonly
# Bug: [Fixed] the $directory wasn't added to the creation of export.csv and export.xml
# Bug: [Fixed] saves data between pade reloads, while uploading files in add/edit modes

[fcallez]

Good night:

// ?= FILTERING (search)
// -- search WHEN 2 dg works only on the first

I attempted solving it, but
I am not able to solve it
I am in need of his help
I require that functionality

Thank you very much
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[fcallez]

Good night:


-------------------
* Feature: [improved] ability to use virtual fields in "field_name" parameter for
foreign keys
ex.: "field_name"=>"CONCAT(name1, ', ', name2) as name3"

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

Example that it works


Code :
---------------------------------------
$foreign_keys = array(

.......

$d22tab_rel_key2 => array("table"=>$d22tab_rel_2, "field_key"=>$d22tab_rel_key2,

"field_name"=>
"concat( "."' Sem.: ', ".$d22tab_rel_2."."."semestre_dicta".",
' / Cod. Espec.: ', ".$d22tab_rel_2."."."cod_especialidad".",
' / Cod. Ciclo : ', ".$d22tab_rel_2."."."cod_ciclo_academico".",
' / Curso : ', ".$d22tab_rel_2.".des_corta" ." )",
"view_type"=>"dropdownlist", "order_by_field"=>$d22tab_rel_ord2, "order_type"=>$d22tab_rel_cri2,
"condition"=>
$d22tab_rel_2.".cod_ciclo_academico = (select cod_ciclo_academico from ".$d1etalle." where ".$d1codigo."="."$pid".") and ".
$d22tab_rel_2.".cod_especialidad = (select cod_especialidad from ".$d1etalle." where ".$d1codigo."="."$pid".") "
),

......);
$dgrid22->setForeignKeysEdit($foreign_keys);
---------------------------------------


Query :
---------------------------------------
SELECT cod_curso,
concat( ' Sem.: ', curso.semestre_dicta,
' / Cod. Espec.: ', curso.cod_especialidad,
' / Cod. Ciclo : ', curso.cod_ciclo_academico,
' / Curso : ', curso.des_corta ), curso.*
FROM curso
WHERE 1=1
AND
curso.cod_ciclo_academico = (select cod_ciclo_academico from matricula where mat_nro=6)
and
curso.cod_especialidad = (select cod_especialidad from matricula where mat_nro=6)
ORDER BY des_corta ASC
---------------------------------------

OK


Example that it does not work

Code :

---------------------------------------
$foreign_keys = array(

.......
$d22tab_rel_key2 => array("table"=>$d22tab_rel_2, "field_key"=>$d22tab_rel_key2,
"field_name"=>
"concat( "." ' Sem. : ', ".$d22tab_rel_2."."."semestre_dicta".",
' / Espec. : ', "."(SELECT (".$dtab_rel_1.".des_corta) FROM ".$dtab_rel_1." WHERE ".$dtab_rel_1.".cod_especialidad = ".$d22tab_rel_2.".cod_especialidad)".",
' / Ciclo : ', "."(SELECT (".$dtab_rel_2.".des_corta) FROM ".$dtab_rel_2." WHERE ".$dtab_rel_2.".cod_ciclo_academico = ".$d22tab_rel_2.".cod_ciclo_academico)".",
' / Curso : ', ".$d21tab_rel_2.".des_corta" ." )",
"condition"=>
$d22tab_rel_2.".cod_ciclo_academico = (select cod_ciclo_academico from ".$d1etalle." where ".$d1codigo."="."$pid".") and ".
$d22tab_rel_2.".cod_especialidad = (select cod_especialidad from ".$d1etalle." where ".$d1codigo."="."$pid".") "
),

.......

);
$dgrid22->setForeignKeysEdit($foreign_keys);
---------------------------------------


Query :

---------------------------------------
SELECT cod_curso,
concat( ' Sem. : ', curso.semestre_dicta,
' / Espec. : ', (SELECT (especialidad_tecnica.des_corta) FROM especialidad_tecnica WHERE especialidad_tecnica.cod_especialidad = curso.cod_especialidad),
' / Ciclo : ', (SELECT (ciclo_academico.des_corta) FROM ciclo_academico WHERE ciclo_academico.cod_ciclo_academico = curso.cod_ciclo_academico),
' / Curso : ', curso.des_corta ), curso.*
FROM curso
WHERE 1=1
AND
curso.cod_ciclo_academico = (select cod_ciclo_academico from matricula where mat_nro=6)
and
curso.cod_especialidad = (select cod_especialidad from matricula where mat_nro=6) ORDER BY cod_curso ASC
---------------------------------------

Notice: Undefined index:
concat( ' Sem. : ', curso.semestre_dicta,
' / Espec. : ', (SELECT (especialidad_tecnica.des_corta) FROM especialidad_tecnica WHERE especialidad_tecnica.cod_especialidad = curso.cod_especialidad),
' / Ciclo : ', (SELECT (ciclo_academico.des_corta) FROM ciclo_academico WHERE ciclo_academico.cod_ciclo_academico = curso.cod_ciclo_academico),
' / Curso : ', curso.des_corta )
in D:\isar\xampp\htdocs\istsiga2\datagrid.class.php on line 4510
--------------------------------------

line 4510 :

--------------------------------------
$text .= "<option selected value='".$row[$this->foreign_keys_array[$field_name][$sub_field_value]]."'>".$row[$ff_name]."</option>";

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

Please, help me

Thank you very much
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[administrator]

1. searching with 2 dg will be checked.
2. "field_name"=>"CONCAT(name1, ', ', name2) as name3"
check if you write as name, where you need it!!!

[fcallez]

Good day:


1. searching with 2 dg will be checked.

In accord. Checking .

2. "field_name"=>"CONCAT(name1, ', ', name2) as name3"
check if you write as name, where you need it!!!


This works to perfection.

Thank you very much
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[fcallez]

Good morning

-------------------------------------------------------------------
This is now,
-------------------------------------------------------------------

Step 7. Add/Edit/Details Mode Settings.

.....

For the "enum" type:
"source"=>"..." - source for enum type. Possible values: "self" or from customized array

// Fill enum type from the array (optional)
$fill_from_array = array("Yes", "No", "Don't know", "My be");



-------------------------------------------------------------------
Should this have the following structure?
-------------------------------------------------------------------
$fill_from_array = array(
"values" => array("0", "1"),
"options" => array("No", "Yes")
);
-------------------------------------------------------------------

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

[administrator]

From the version 4.1.9 it will have (filtering mode too) the next structure:

/// $fill_from_array = array("No"=>"0", "Yes"=>"1", "Don't know"=>"2", "My be"=>"3");

[fcallez]

Good morning :


Bug :
--------------------------------------------------------
if(strlen(trim($field_req_type) == 3)) { $field_req_type = $field_req_type; }
--------------------------------------------------------

OK :
--------------------------------------------------------
if(strlen(trim($field_req_type)) == 3) { $field_req_type = $field_req_type; }
--------------------------------------------------------

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

[fcallez]

Good morning :


Bug :
--------------------------------------------------------
$ret_file .= "[<a class='".$this->unique_prefix."class_a' ".(($disabled == "disabled") ? "" : "href='' onclick='fileAction(\"upload\", \"".$field_name."\")'")."><b>".$this->lang['upload']."</b></a>]&nbsp;";
--------------------------------------------------------

OK :
--------------------------------------------------------
$ret_file .= "[<a class='".$this->unique_prefix."class_a' ".(($disabled == "disabled") ? "" : "href='#' onclick='fileAction(\"upload\", \"".$field_name."\")'")."><b>".$this->lang['upload']."</b></a>]&nbsp;";
--------------------------------------------------------

but :

A field: Of type date (datedmy)
That normally shows :

date special : 06-06-1961

Of type date (datetimedmy)

date register : 11-09-2007 23:19:29

Change

date special : 61--1-06-0

date register : 07--2-11-0 23:19:29


Modify :

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

function myDate($field_value, $type="datedmy"){
$ret_date = "";
if($type == "datedmy"){
if (substr(trim($field_value), 4, 1) == "-") {
$year1 = substr(trim($field_value), 0, 4);
$month1 = substr(trim($field_value), 5, 2);
$day1 = substr(trim($field_value), 8, 2);
if($day1 != ""){
$ret_date = $day1."-".$month1."-".$year1;
}
}
else {

$year1 = substr(trim($field_value), 6, 4);
$month1 = substr(trim($field_value), 3, 2);
$day1 = substr(trim($field_value), 0, 2);
if($day1 != ""){
$ret_date = $day1."-".$month1."-".$year1;
}
}
}else if($type == "datetimedmy"){

if (substr(trim($field_value), 4, 1) == "-") {


$year1 = substr(trim($field_value), 0, 4);
$month1 = substr(trim($field_value), 5, 2);
$day1 = substr(trim($field_value), 8, 2);
$time1 = substr(trim($field_value), 11, 2);
$time2 = substr(trim($field_value), 14, 2);
$time3 = substr(trim($field_value), 17, 2);
if($day1 != ""){
$ret_date = $day1."-".$month1."-".$year1." ".$time1.":".$time2.":".$time3;
}
}
else {

$year1 = substr(trim($field_value), 6, 4);
$month1 = substr(trim($field_value), 3, 2);
$day1 = substr(trim($field_value), 0, 2);
$time1 = substr(trim($field_value), 11, 2);
$time2 = substr(trim($field_value), 14, 2);
$time3 = substr(trim($field_value), 17, 2);
if($day1 != ""){
$ret_date = $day1."-".$month1."-".$year1." ".$time1.":".$time2.":".$time3;
}
}
}else{
$ret_date = $field_value;
}
return $ret_date;
}

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



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

[administrator]

thanks, added and changed

[fcallez]

Good day:

Please, in the version 1.4.9 considering the following improvements/additions:

--------------------------------------------
* Feature: [improved] ability to use virtual fields in "field" parameter for Filter (search) Settings

ex.: "field"=>"CONCAT(name1, ', ', name2) as name3"

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

* Feature: [added] new parameter: "condition" for Filter (search) Settings

ex.: "condition"=>"estatus = 'Active'"

* Feature: [added] new parameter: "unique_condition" for Filter (search) Settings

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

* Feature: [added] new parameter: "show" in view/add/edit
modes - That he activate or deactivate the possibility to show the field

ex.: "show"=>$grant>=3?true:false


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

19-Set-07

* Feature: [added] new option : set - parameter: "type" in view/add/edit
modes -

For the "set" type:
"source"=>"..." - source for set type. Possible values: "self" or from customized array
"view_type"=>"..." - view type of the field: dropdownlist (default) or radiobutton

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

* Feature: [added] new option : blob - parameter: "type" in view/add/edit
modes -

For the "blob" type:
"source"=>"..." - source for set type. Possible values: "self"
"view_type"=>"..." - view type of the field: dropdownlist (default)
"mime_type"=>"..." - mime type of the field: image/gif, application/pdf, application/msword, text/plain (default), .. etc
...

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

Thanks

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

[fcallez]

Good day:

Please, in the version 1.4.9 considering the following improvements/additions:

* Feature: [added] new option : set - parameter: "type" in view/add/edit
modes -

For the "set" type:
"source"=>"..." - source for set type. Possible values: "self" or from customized array
"view_type"=>"..." - view type of the field: dropdownlist (default) or radiobutton

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

* Feature: [added] new option : blob - parameter: "type" in view/add/edit
modes -

For the "blob" type:
"source"=>"..." - source for set type. Possible values: "self"
"view_type"=>"..." - view type of the field: dropdownlist (default)
"mime_type"=>"..." - mime type of the field: image/gif, application/pdf, application/msword, text/plain (default), .. etc
...

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

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