× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

how to add sql-processing to edit-form

il y a 3 ans 1 mois #9903 par Jochen
how to add sql-processing to edit-form a été créé par Jochen
hi,

I've done my first project with Component Creator and I was very surprised of its ease of use. But now I got stuck with one question. My table has a field which needs to be updated by an external file and not with the edit-form. How can I trigger the reading of this file, updateing and running the needed sql ("insert" or "update")? Do I have to create some more "helper" code?

Connexion ou Créer un compte pour participer à la conversation.

il y a 3 ans 1 mois #9905 par Carl Fuentes
Réponse de Carl Fuentes sur le sujet how to add sql-processing to edit-form
What do you mean by external file? is it a normal text file? or a CSV file?

Connexion ou Créer un compte pour participer à la conversation.

il y a 3 ans 1 mois #9907 par Jochen
Réponse de Jochen sur le sujet how to add sql-processing to edit-form
hi,

no this will be php-code or html-code coming from a file - should go into field "custom_code" - the JCC genned code does not show any method (e.g. in "controllers" or models") to store data with sql update, or insert).

this is my table:
CREATE TABLE IF NOT EXISTS `#__jphpx` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`modified_by` INT(11) NOT NULL DEFAULT 0,
`custom_code` TEXT NOT NULL ,
`title` VARCHAR(1) NOT NULL DEFAULT "1",
`source` VARCHAR(11) NOT NULL DEFAULT "0",
`access` BOOLEAN NOT NULL DEFAULT "0",
`published` BOOLEAN NOT NULL DEFAULT "1",
PRIMARY KEY (`id`)
) DEFAULT COLLATE=utf8mb4_unicode_ci;

Connexion ou Créer un compte pour participer à la conversation.

il y a 3 ans 1 mois #9908 par Jochen
Réponse de Jochen sur le sujet how to add sql-processing to edit-form
hi,

My Application's logic is: 1. get filename from field "source", 2. read content of file and 3. store it into field "custom_code". This works with a standalone php-app - and should now be migrated into a Joomla component.

Connexion ou Créer un compte pour participer à la conversation.

il y a 3 ans 1 mois - il y a 3 ans 1 mois #9909 par Carl Fuentes
Réponse de Carl Fuentes sur le sujet how to add sql-processing to edit-form
This one will need alot of manually coding because Component Creator is not supporting this feature.
I suggest you to add
<field name="filetoread" type="file" label="file to read" description="" hint=""/>
to the xml file of the form.
and use this to ouput the filed output the field to the form
<?php echo $this->form->renderField('filetoread'); ?>

to read that content you will need to edit/overide either the controller or model save() function.
Dernière édition: il y a 3 ans 1 mois par Carl Fuentes.

Connexion ou Créer un compte pour participer à la conversation.

il y a 3 ans 1 mois #9911 par Jochen
Réponse de Jochen sur le sujet how to add sql-processing to edit-form
hi,

OK. Will try to use save method on model - but how can I get the data from the edit-form? So I can do the save corrrectly?

Connexion ou Créer un compte pour participer à la conversation.

Temps de génération de la page : 0.073 secondes
Propulsé par Kunena

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.