PHP Builder Forum IndexPHP Builder
free solutions for web developers
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in            Calendar



COMPUSORY UPGRADE!!! Request an upgrade NOW! 32+ Pre-installed Modifications! 3 Server Locations to choose from: USA, UK and JAPAN.

11th December 2012 - phpBB88: All servers are upgraded to run using SSD drive. Click Here to report problems!

BETA version 4.1.5 is available now for downloading.
Goto page 1, 2, 3  Next
 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    PHP Builder Forum Index -> Current BETA version {download}
View previous topic :: View next topic  
Author Message
administrator
Site Admin
Site Admin


Joined: 05 Oct 2006
Posts: 538
:
Location: Israel

Items
PostPosted: Fri Jun 15, 2007 7:45 pm    Post subject: BETA version 4.1.5 is available now for downloading. Reply with quote
BETA version 4.1.5 of PHP DataGrid is available for downloading from
>> here <<

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

Changes in this version:

//* Feature: [added] LIMIT/TOP/NUM_ROWS processing for different database types
//* Feature: [added] new parameter: "on_js_event"=>"" for Add/Edit/View Modes
//* Feature: [added] new type "link" for add/edit/details mode
//* Feature: [added] using of some fields for default order in View Mode
//* Feature: [added] warnings system
//* Feature: [added] small image preview on uploading
//* Feature: [added] new parameter for image type: "image_name"=>"Image_Name"
//* Feature: [added] new parameters for foreign keys:
// "order_by_field"=>"Field_Name" and "order_type"=>"ASC|DESC"
//* Feature: [added] in View and Edit/Details mode added new parameter for
// image type: image_width & image_height
//* Feature: [added] new parameter "maxlength"=>>"..." for fields in Add/Edit modes
//* Feature: [added] new format for "source"=>$fill_from_array parameter in
// filter mode
//* Feature: [added] new parameter for enum type: default value
//* Feature: [added] Multi-row in details mode
//* Feature: [added] new language - Chinese (provided by xukong)
//* Feature: [added] new parameter - "on_js_event"=>"" for link type in View Mode
//* Feature: [added] new language - Polish (provided by davie81)
//* Feature: [added] auto columns generetion by
// setAutoColumnsInViewMode() and setAutoColumnsInEditMode()
//* Feature: [added] onSubmitMyCheck() JS function for specific checkings
//* Feature: [added] Reset button in filtering mode
//* Feature: [added] new parameter - {0...n} in the link type of view mode
//* Feature: [added] new parameter - condition in setTableEdit()
//* Feature: [added] new method - setEditModeTableProperties()
//* Feature: [added] new method - setDetailsModeTableProperties()
//* Feature: [added] new type in view mode - barchart
//* Feature: [added] executeSql() method
//* Feature: [added] selectSqlItem() method
//* Feature: [added] export in XML format
//* Feature: [added] new parameter - readonly for fields in edit mode
//* Feature: [added] new parameter - "default"=>"..." for fields in add mode
//* Feature: [added] code checking if form.script.js exists

//* Feature: [improved] debugger messaging
//* Feature: [improved] css <a> tag styling
//* Feature: [improved] new format for parameter "max_file_size": 1024B|100K|10M|1G...
//* Feature: [improved] colspan parameter in Search table
//* Feature: [improved] translating into Netherlands
//* Feature: [improved] messaging in AddRow/UpdateRow/DeleteRow methods
//* Feature: [improved] view of datetime link & pop-up
//* Feature: [improved] added headers to fields in exporting to *.csv
//* Feature: [improved] translation in german
//* Feature: [improved] added uploading option for image type in Add/Edit/Detail modes
// and new parameters: "width"=>"...", "height"=>"..." and "default"=>"..." in Add/View/Edit/Detail modes

//# Bug: [Fixed] error on wrong default order data (after updating)
//# Bug: [Fixed] wrong "Search type:" displaying when only 1 field in filtering section//# Bug: [Fixed] single quotes error in drawForeignKeyInput() method
//# Bug: [Fixed] FireFox updating error
//# Bug: [Fixed] error while creating uploading directory, if it was not exist
//# Bug: [Fixed] uploading 2 or more files
//# Bug: [Fixed] problem with single quote (') by adding mysql_real_escape_string() and stripslashes()
//# Bug: [Fixed] maxlength error (-1) in getFieldValueByType()
//# Bug: [Fixed] wrong offset in columns_edit_mode array in drawForeignKeyInput()
//# Bug: [Fixed] "alt" propertiey in <img> changed on "title" to show tooltips in FF
//# Bug: [Fixed] tag <php error in lang.php file
//# Bug: [Fixed] empty SELECT result if primary key was in non-numeric type
//# Bug: [Fixed] unexpexted column in add mode, if multirow option is allowed
//# Bug: [Fixed] error while uploading & updating if unique prefix was more then 2 simbols
//# Bug: [Fixed] blocked direct access to all folders by adding a blank index.html file
//# Bug: [Fixed] checkbox shows only 1 or 0 in details mode (instead of 'Yes', 'No')
//# Bug: [Fixed] showing wrong icons and checkboxes in print mode
//# Bug: [Fixed] wrong offset of summarizing column
//# Bug: [Fixed] default maxlength value error in edit mode
//# Bug: [Fixed] colSpan='0' error in FireFox
//# Bug: [Fixed] function lastSubStrOccurence() not handles correctly cases like: tblWhere, tblFrom etc.
//# Bug: [Fixed] default paging didn't work - shows wrong number of row in first viewing
//# Bug: [Fixed] error in details mode: undefined variable curr_url
//# Bug: [Fixed] setLanguage error
//# Bug: [Fixed] missing title parameter in drawModeButton() function in <IMG>
//# Bug: [Fixed] unexpexted comma in field data while exporting to *.csv
Back to top
View user's profile Send private message Send e-mail Visit poster's website
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Fri Jun 22, 2007 2:01 am    Post subject: Operations the multi-rows are not working on Firefox Reply with quote
Good day

Operations the multi-rows are not working on Firefox

Please, checking the following link:

http://www.innovavirtual.org/datagrid/examples/index.php

Thanks

Franklin Sad
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Fri Jun 22, 2007 2:14 am    Post subject: Multirow operations, option : details Reply with quote
Good day :

Please, checking the following link:

http://www.innovavirtual.org/datagrid/examples/index.php?f_mode=details&f_sort_field=3&f_sort_type=ASC&f_page_size=10&f_p=1&f_rid=9-17-25-66-61-73-1-10-18-26

Show presidents table, but without data..

Thanks

Franklin Sad
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Fri Jun 22, 2007 2:18 am    Post subject: Please, an example of the use of: on_js_event Reply with quote
Good day

Please, an example of the use of:

on_js_event

Thanks

Franklin Wink
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
zewa666
Site Moderator
Site Moderator


Joined: 01 Feb 2007
Posts: 606
:


Items
PostPosted: Fri Jun 22, 2007 6:24 am    Post subject: Re: Operations the multi-rows are not working on Firefox Reply with quote
fcallez wrote:
Good day

Operations the multi-rows are not working on Firefox

Please, checking the following link:

http://www.innovavirtual.org/datagrid/examples/index.php

Thanks

Franklin Sad


After testing a bit, i looked at your QUERY STRING and it looks like this

http://www.innovavirtual.org/datagrid/examples/index.php?f_mode=delete&f_sort_field=3&f_sort_type=ASC&f_page_size=10&f_p=1&amp;f_rid=73


THIS is the important part, it is at the end
&f_p=1&amp;f_rid=73

As you see after $f_p=1 there is a "&" missing. look through your code maybe you've added something wrong

Greetings
Zewa
Back to top
View user's profile Send private message Send e-mail Visit poster's website
administrator
Site Admin
Site Admin


Joined: 05 Oct 2006
Posts: 538
:
Location: Israel

Items
PostPosted: Fri Jun 22, 2007 10:27 am    Post subject: Reply with quote
Right: $amp; is a problem. Fixed in new version.

You can fix it by yourself in verifySelected() function in this row:
selected_rows = '&".$this->unique_prefix."rid=';
Back to top
View user's profile Send private message Send e-mail Visit poster's website
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Fri Jun 22, 2007 1:47 pm    Post subject: Operations the multi-rows are not working on Firefox - Ok Reply with quote
Good day:

It was corrected and it worked

Thanks Wink
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Fri Jun 22, 2007 4:53 pm    Post subject: Many coding lines with: &amp; Reply with quote
Many coding lines with: &amp;

It is replaced for: & ?

Examples:

-------------------------------------------------------------
Code:

echo "<a QUERY_STRING="">unique_prefix."export=true&amp;".$this->unique_prefix."export_type=csv','ExportToExcel','left=100,top=100,width=600,height=400,toolbar=0,resizable=0,location=0,scrollbars=1');myRef.focus();\" class='".$this->unique_prefix."class_a'>";


Code:

echo "<a QUERY_STRING="">unique_prefix."export=true&amp;".$this->unique_prefix."export_type=xml','ExportToExcel','left=100,top=100,width=600,height=400,toolbar=0,resizable=0,location=0,scrollbars=1');myRef.focus();\" class='".$this->unique_prefix."class_a'>";


Code:

echo "<a QUERY_STRING="">unique_prefix."print=true','PrintableView','left=20,top=20,width=840,height=630,toolbar=0,menubar=0,resizable=0,location=0,scrollbars=1');myRef.focus()\" class='".$this->unique_prefix."class_a'><img></a>";


Code:

$href_string .= "&amp;".$this->unique_prefix."sort_field=".($c+1)."&amp;".$this->unique_prefix."sort_type=".$sort_type;



Code:
$cancel_url .= "&amp;".$this->unique_prefix."new=1";


Code:

if(isset($_REQUEST[$this->unique_prefix.'mode']) && $_REQUEST[$this->unique_prefix.'mode'] === "add") { $curr_url .= "&amp;".$this->unique_prefix."new=1"; $cancel_url .= "&amp;".$this->unique_prefix."new=1";}



Code:
function combineUrl($mode, $rid="", $amp="&amp;"){


Code:

$text .= "function ".$this->unique_prefix."setPageSize".$type."(){document.location.href = '$href_string&amp;".$this->unique_prefix."page_size='+document.frmPaging$this->unique_prefix".$type.".page_size".$type.".value;}";


Code:

$href_string .= "&amp;".$this->unique_prefix."page_size=".$this->req_page_size;


Code:
                    $href_prev1 = "href='$href_string&amp;".$this->unique_prefix."p=".($this->page_current - 1)."'";
                    $href_prev2 = "href='$href_string&amp;".$this->unique_prefix."p=".$this->page_current."'";
                    $href_first = "href='$href_string&amp;".$this->unique_prefix."p=1'";



Code:

if($ind == $this->page_current) $text .= "&nbsp;<a_tag>unique_prefix."class_a' style='text-decoration: underline;' title='".$this->lang['current']."' href='$href_string&amp;".$this->unique_prefix."p=".$ind."'><b><u>" . $ind . "</u></b></a_tag>unique_prefix."class_a' style='text-decoration: none;' href='$href_string&amp;".$this->unique_prefix."p=".$ind."'>".$ind."</".$a_tag.">";


Code:

function setUrlString(&$curr_url, $filtering = "", $sorting = "", $paging ="", $amp="&amp;"){



Code:
function setUrlStringFiltering(&$curr_url, $amp="&amp;"){


Code:
function setUrlStringSorting(&$curr_url, $amp="&amp;"){



Code:
function setUrlStringPaging(&$curr_url, $amp="&amp;"){


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



Thanks Rolling Eyes
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
administrator
Site Admin
Site Admin


Joined: 05 Oct 2006
Posts: 538
:
Location: Israel

Items
PostPosted: Fri Jun 22, 2007 5:06 pm    Post subject: Reply with quote
No. These are ok.
The problem was in in those lines, that were performed in js functions.
We need &amp; for cases when some field includes &, like
f_name=rony_&_boss&data=...
Back to top
View user's profile Send private message Send e-mail Visit poster's website
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Fri Jun 22, 2007 5:19 pm    Post subject: Reply with quote
Then

The method: SetPagingSettings

With Firefox, do not work correctly with the array : $pages_array = array(10, 25, 50, 100, 250, 500, 1000);

Crying or Very sad
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Fri Jun 22, 2007 5:39 pm    Post subject: Firefox v/s &amp; Reply with quote
Hello

Continuous the problem with the firefox and the &amp;

http://www.innovavirtual.org/datagrid/examples/index.php?f_mode=view&amp;f_sort_field=1&amp;f_sort_type=AsC&amp;f_page_size=250

Rolling Eyes

Please, making the change of &amp; for & in the following coding line

Code:

$text .= "function ".$this->unique_prefix."setPageSize".$type."(){document.location.href = '$href_string&amp;".$this->unique_prefix."page_size='+document.frmPaging$this->unique_prefix".$type.".page_size".$type.".value;}";

_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
administrator
Site Admin
Site Admin


Joined: 05 Oct 2006
Posts: 538
:
Location: Israel

Items
PostPosted: Fri Jun 22, 2007 7:08 pm    Post subject: Reply with quote
You are right. Thanks Smile
Back to top
View user's profile Send private message Send e-mail Visit poster's website
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Sat Jun 23, 2007 3:49 pm    Post subject: Multirow_option --> replace --> Do not work correct Reply with quote
Good day:

On file: code_example

The code:

-----------------------------------------------------------------------------
Code:
$multirow_option = true;
  $dgrid->allowMultirowOperations($multirow_option);
  $multirow_operations = array(
    "delete"  => array("view"=>true),
    "details" => array("view"=>true),

    "replace" => array("view"=>true, "flag_name"=>"Population", "flag_value"=>"111111", "tooltip"=>"replace selected", "image"=>"add.gif")

  );
  $dgrid->setMultirowOperations($multirow_operations); 


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


That's right?

"replace" => array("view"=>true, "flag_name"=>"Population", "flag_value"=>"111111", "tooltip"=>"replace selected", "image"=>"add.gif")


Please, an example of correct use of the option: replace

Trying in:

http://www.innovavirtual.org/datagrid/examples/index.php

Thanks


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

Last edited by fcallez on Sat Jun 23, 2007 3:54 pm; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Sat Jun 23, 2007 3:50 pm    Post subject: Re: Please, an example of the use of: on_js_event Reply with quote
Hi :

Please,

Can they help me? thanks


fcallez wrote:
Good day

Please, an example of the use of:

on_js_event

Thanks

Franklin Wink

_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
fcallez
Expert
Expert


Joined: 07 Mar 2007
Posts: 174
:
Location: Pucallpa - Perú

Items
PostPosted: Sat Jun 23, 2007 4:11 pm    Post subject: Re: Multirow operations, option : details Reply with quote
Hi :

Please,

Can they help me? thanks

--------------------------------------------------
fcallez wrote:
Good day :

Please, checking the following link:

http://www.innovavirtual.org/datagrid/examples/index.php?f_mode=details&f_sort_field=3&f_sort_type=ASC&f_page_size=10&f_p=1&f_rid=9-17-25-66-61-73-1-10-18-26

Show presidents table, but without data..

Thanks

Franklin Sad


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

Thanks Evil or Very Mad Very Happy
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
     
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    PHP Builder Forum Index -> Current BETA version {download} All times are GMT
Goto page 1, 2, 3  Next
Page 1 of 3

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
PHP Builder topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group

FREE FORUM HOSTING by AtFreeForum. Terms of Service - Privacy Policy
FASHION ACCESSORIES - BLING BLING - LADIES WATCHES - KOREAN CHILDREN CLOTHING - ONLINE BARGAIN STORE - FASHION JEWELLERIES