×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
how to add sql-processing to edit-form
Jochen
Yeni Üye
Posts: 4
3 yıl 1 ay önce #9903
Yazan: Jochen
how to add sql-processing to edit-form, Jochen tarafından oluşturuldu
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?
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?
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Carl Fuentes
Sorumlu
Posts: 28
3 yıl 1 ay önce #9905
Yazan: Carl Fuentes
Carl Fuentes tarafından how to add sql-processing to edit-form konusunda yanıtlandı
What do you mean by external file? is it a normal text file? or a CSV file?
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Jochen
Yeni Üye
Posts: 4
3 yıl 1 ay önce #9907
Yazan: Jochen
Jochen tarafından how to add sql-processing to edit-form konusunda yanıtlandı
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;
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;
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Jochen
Yeni Üye
Posts: 4
3 yıl 1 ay önce #9908
Yazan: Jochen
Jochen tarafından how to add sql-processing to edit-form konusunda yanıtlandı
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.
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.
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Carl Fuentes
Sorumlu
Posts: 28
3 yıl 1 ay önce - 3 yıl 1 ay önce #9909
Yazan: Carl Fuentes
Carl Fuentes tarafından how to add sql-processing to edit-form konusunda yanıtlandı
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.
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.
Son Düzenleme: 3 yıl 1 ay önce Düzenleyen:Carl Fuentes
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Jochen
Yeni Üye
Posts: 4
3 yıl 1 ay önce #9911
Yazan: Jochen
Jochen tarafından how to add sql-processing to edit-form konusunda yanıtlandı
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?
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?
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Sayfa oluşturma süresi: 0.085 saniye