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

how to add sql-processing to edit-form

pred 3 rokmi 1 mesiacom #9903 od 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?

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 3 rokmi 1 mesiacom #9905 od Carl Fuentes
Odpoveď od Carl Fuentes na tému 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?

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 3 rokmi 1 mesiacom #9907 od Jochen
Odpoveď od Jochen na tému 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;

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 3 rokmi 1 mesiacom #9908 od Jochen
Odpoveď od Jochen na tému 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.

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 3 rokmi 1 mesiacom - pred 3 rokmi 1 mesiacom #9909 od Carl Fuentes
Odpoveď od Carl Fuentes na tému 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.
Posledný krát upravené:pred 3 rokmi 1 mesiacom Carl Fuentes

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 3 rokmi 1 mesiacom #9911 od Jochen
Odpoveď od Jochen na tému 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?

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

Čas vytvorenia stránky: 0.052 sekúnd
Funguje na Kunena fórum

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.