Is possible to put default value in an element when edit record?

[blue-mouse]

Hi,

i try use code, for default value:

$db =& JFactory::getDBO();
$query1 = "SELECT `ip_zamaw_zam` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query1);
$result1 = $db->loadResult();
return $result1;

this works but only when record-new.
I need use default when record-edit. My element `ip_zamaw_zam` on form1---add-new-record is not published.
I use after this list2 and form2=list2---record-edit when element `ip_zamaw_zam` is published and then i would like use "default value" --- is it possible in any way?

 

[troester]

You can do it with a php plugin "onLoad".

 

[blue-mouse]

Oh, I try this on php plugin -"onLoad". but there is something wrong with my code:

$db =& JFactory::getDBO();
$query1 = "SELECT `ip_zamaw_zam` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query1);
$result1 = $db->loadResult();


$query2 = "UPDATE `ccjom_cc_kk_karta_rejestr` SET `ip_zamaw_zam` = ".$result1." ";
$db->setQuery($query2);
$db->query();

Instead of set default value on edited record i updated all my records in table ccjom_cc_kk_karta_rejestr` with ".$result1."

I have not idea how to write query2 or second part of my code to set on dropdown: `ip_zamaw_zam` default value.
It should be only "default" and i should can to change it.

 

[troester]

http://fabrikar.com/forums/index.ph...dating-a-form-s-value-before-showing-the-form

 

[blue-mouse]

I try code:

$db =& JFactory::getDBO();
$query1 = "SELECT `ip_zamaw_zam` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query1);
$result1 = $db->loadResult();

$formModel->data['ccjom_cc_kk_karta_rejestr___ip_zamaw_zam']= $result1;

but this do nothing

i try also to test some simple code that should put default value in element type=field

$formModel->data['ccjom_cc_kk_karta_rejestr___test1']= 'Firma DDDDD4';

and this also do nothing

 

[troester]

$formModel->data['land___name']='gef?llt onLoad on both'; is working fine on my site.

Maybe you have a typo somewhere, e.g. it must be
$db = JFactory::getDbo();

http://fabrikar.com/forums/index.php?wiki/common-php-tasks/

 

[blue-mouse]

It looks i have ja typo, but try to unpublish it. So, when unpublished still can see "Ja Typo" button - on Fabrik:edit Form --- below the intro- and footer- text.
Nothing doesn't work also this:

$db = JFactory::getDbo();
$formModel->data['ccjom_cc_kk_karta_rejestr___test1']='Firma';

and this:

$db =& JFactory::getDBO();
$formModel->data['ccjom_cc_kk_karta_rejestr___test1']='Firma';

I have:
System operacyjny Linux debianbodzio2 2.6.32-5-amd64 #1 SMP Mon Jan 16 16:22:28 UTC 2012 x86_64
Wersja bazy danych 5.1.49-3
Porz?dek znak?w w MySQL utf8_general_ci
Wersja PHP 5.3.3-7+squeeze18
Serwer WWW Apache/2.2.16 (Debian)
PHP dzia?a na apache2handler
Wersja Joomla! Joomla! 2.5.28 Stable [ Ember ] 10-December-2014 15:00 GMT
Wersja platformy Joomla! Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
Klient u?ytkownika Mozilla/5.0 (X11; Linux x86_64; rv:37.0) Gecko/20100101 Firefox/37.0

and Fabrik 3.0.9

 

[troester]

Oh no
With "typo" I meant "a spelling error", I never before seen an ext-editor button "JA typo" (coming form a template?).

No idea why $formModel->data['ccjom_cc_kk_karta_rejestr___test1']='Firma'; isn't running, is it the correct element name?
And it seems you are still on J!2.5/Fabrik3.0.9?

 

[blue-mouse]

Hmm, ?
This test code works (___test1 is type=field) both for new and edited form:

$db =& JFactory::getDBO();
$formModel->_data['ccjom_cc_kk_karta_rejestr___test1']='Firma DDDDD4';

But this code that i need works only on new form, on edited form do nothing
I have exactly 2 fields: 1 databasejoin-dropdown, 2 cascadingdropdown that i need to put in them default when form is edited:

$db =& JFactory::getDBO();
$query = $db->getQuery(true);

$query1 = "SELECT `ip_zamaw_zam` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query1);

$result1 = $db->loadResult();

$query2 = "SELECT `zamow_symbol` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query2);

$result2 = $db->loadResult();


$formModel->_data['ccjom_cc_kk_karta_rejestr___ip_zamaw_zam']=$result1;

$formModel->_data['ccjom_cc_kk_karta_rejestr___zamow_symbol']=$result2;

( I installed Ja Typo editor some long time ago but i didn't use it yet ;-) )

 

[blue-mouse]

Hi,
At this moment i try code: (that works properly for query3 + query6, when field databasejoin is rendered as autocomplete, when is rendered as dropdown then i get nothing.

I get what i need for: 'ccjom_cc_kk_karta_rejestr___typ_urz1'

$db =& JFactory::getDBO();
$query = $db->getQuery(true);

$query1 = "SELECT `ip_zamaw_zam` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query1);
$result1 = $db->loadResult();

$query2 = "SELECT `zamow_symbol` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query2);
$result2 = $db->loadResult();



$query3 = "SELECT `typ_urz1` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query3);
$result3 = $db->loadResult();

$query6 = "SELECT `ip_typurz1` FROM `ccjom_cc_kk_det_typurz1` WHERE `id`= $result3 ";
$db->setQuery($query6);
$result6 = $db->loadResult();


$formModel->_data['ccjom_cc_kk_karta_rejestr___ip_zamaw_zam']=$result1;

$formModel->_data['ccjom_cc_kk_karta_rejestr___zamow_symbol']=$result2;

$formModel->_data['ccjom_cc_kk_karta_rejestr___typ_urz1']=$result6;

 

[troester]

Maybe you have to use 'element_raw' for dbjoins and CDDs.
I don't have a J2.5 installation.

 

[blue-mouse]

_raw works!
This code works for render as dropdown for databasejoin and cascadingdropdown:

$db =& JFactory::getDBO();
$query = $db->getQuery(true);

$query1 = "SELECT `ip_zamaw_zam` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query1);
$result1 = $db->loadResult();


$query2 = "SELECT `zamow_symbol` FROM `ccjom_cc_kk_karta_rejestr` WHERE `rodzaj_karty_np_wzorzec`='2' ORDER BY `id` DESC
LIMIT 1 ";
$db->setQuery($query2);
$result2 = $db->loadResult();

$formModel->_data['ccjom_cc_kk_karta_rejestr___ip_zamaw_zam_raw']=$result1;

$formModel->_data['ccjom_cc_kk_karta_rejestr___zamow_symbol_raw']=$result2;

But have else small problem:
This 2 fields are:
customer
order_No

need those defaults to continue order with multiple position (1,2, ....8) like
1. something-A
2. something-B
.....

But when i need start new-order for other-customer i need customer field type=databasejoin--but-autocomplete( not just dropdown), i have high number of customers in table and dropdown is not good then.

Is there, may be, any possibility, to switch beetwen field: customers {ccjom_cc_kk_karta_rejestr___ip_zamaw_zam} from render as dropdown -> to render as autocomplete?