From FaithHighway Wiki

[edit] ECRM Navigation

http://wiki.fhv2.com/wiki/ECRM:CRM_Control_Ideas 
http://wiki.fhv2.com/wiki/ECRM:ControlDataGrid
http://wiki.fhv2.com/wiki/ECRM:CustomeEvents 
http://wiki.fhv2.com/wiki/ECRM:CoreComponentList 
http://wiki.fhv2.com/wiki/ECRM:DataBaseQuestions 
http://wiki.fhv2.com/wiki/ECRM:DataBaseScheme
http://wiki.fhv2.com/wiki/ECRM:DataDependentRouting 
http://wiki.fhv2.com/wiki/ECRM:DataSet 
http://wiki.fhv2.com/wiki/ECRM:DataType
http://wiki.fhv2.com/wiki/ECRM:EngineComponentList 
http://wiki.fhv2.com/wiki/ECRM:EngineDefinitions 
http://wiki.fhv2.com/wiki/ECRM:Filters_Controls 
http://wiki.fhv2.com/wiki/ECRM:FormDefinition 
http://wiki.fhv2.com/wiki/ECRM:FormGenerator 
http://wiki.fhv2.com/wiki/ECRM:MetaData 	
http://wiki.fhv2.com/wiki/ECRM:Research 
http://wiki.fhv2.com/wiki/ECRM:Settings 

- Надо сделать возможность задания размеров картинок, которые буду использоваться в элементах управления (гриде и т.п.). Это нужно для того, чтобы корректно определялась высота таба, в который будут помещаться элементы.

- We need to decide what to do with windows that opened to edit item. Must they have unique name, or do they have to close automatically after editing is finished (in this case unique name are not required).

[edit] phpMyDatagrid integration

all issues here

We have some problems. I try to solve it there http://crmtest.fhv2.com/index.php/activity/dgmaintest

PROBLEM_1 I think we will be to have problems when we use some grids on one web-page. (SOLVED fully by Igor. Status: testing)

a) Problem of doubling html-content. AJAX responce will contain our html-content. Look at example 15, please. http://www.gurusistemas.com/indexdatagrid.php?page=samples

b) php-script generate following code to head-part of our html-page:

<script type='text/javascript'>

var scrName = 'processPopUp';

var imgpath = '/images/datagrid/';

var params = ;

var camposearch = ;

.....

js-script code in dgscript.js use it variables.

c) DataGrid generate code with ids (ajaxDHTMLDiv, addDiv, dgTable).

div id='ajaxDHTMLDiv' style='display:inline;position:absolute;'...

div id='addDiv' class='dgAddDiv' style='display:inline;position:absolute;'...

div id='dgDiv' class='dgMainDiv' ...

table id='dgTable' class='dgTable' cellpadding='0' cellspacing='0'...

So html-page will contain many elements with equal ids.

PROBLEM_2 We have problems with joins. When phpMyDataGrid is displaying join (not one table) we can't edit fields (and save in DB) and we can't sort result with help of special arrows (in headers). (SOLVING .... by Igor. Status: implementation)

When we try edit cell, the phpMyDataGrid try to do SQL-query, which contains aliases instead names of fields. Also it try to use unique id that we defined like $objGrid->keyfield("activ_id"). But it is unique id of one table. We need unique ids for all tables of join.