blue-mouse
Member
Hi,
I try copy 1 record from list1 to multiple new records.
Use "copy" button from form1 and form-plugin-clone.
When i go from list1 with "edit"-option to displaying choosen record and i use "copy"-button i get this amount of new record that i have written in field: {ccjom_cc_kk_karta_rejestr___zamow_quantity_pos_ordered}.
lets assume that this amount is: "6".
I need for all new records get unique serial_number stored in field:
{ccjom_cc_kk_karta_rejestr___product_serial_num2}
i write on form "first-serial-number2" - for example --- number: "26"
i need get for
first new record --- ___product_serial_num2 = 26
second new record --- ___product_serial_num2 =28
third (3) new record --- ___product_serial_num2 =30
(4) new record --- ___product_serial_num2 =32
(5) new record --- ___product_serial_num2 =34
(6) new record --- ___product_serial_num2 =36
on first record field --- ___product_serial_num2 = 26 should be not changed
all next records --- ___product_serial_num2 = should be earlier + 2
on my screen shot i created 6 records with id: 31 - 36
record 31 --- should be = 26
record 32 --- should be = 28
record 33 --- should be = 30
record 34 --- should be = 32
record 35 --- should be = 34
record 36 --- should be = 36
my code for php-plugin on form is:
this code seems nothing to do.
What is wrong?
I try copy 1 record from list1 to multiple new records.
Use "copy" button from form1 and form-plugin-clone.
When i go from list1 with "edit"-option to displaying choosen record and i use "copy"-button i get this amount of new record that i have written in field: {ccjom_cc_kk_karta_rejestr___zamow_quantity_pos_ordered}.
lets assume that this amount is: "6".
I need for all new records get unique serial_number stored in field:
{ccjom_cc_kk_karta_rejestr___product_serial_num2}
i write on form "first-serial-number2" - for example --- number: "26"
i need get for
first new record --- ___product_serial_num2 = 26
second new record --- ___product_serial_num2 =28
third (3) new record --- ___product_serial_num2 =30
(4) new record --- ___product_serial_num2 =32
(5) new record --- ___product_serial_num2 =34
(6) new record --- ___product_serial_num2 =36
on first record field --- ___product_serial_num2 = 26 should be not changed
all next records --- ___product_serial_num2 = should be earlier + 2
on my screen shot i created 6 records with id: 31 - 36
record 31 --- should be = 26
record 32 --- should be = 28
record 33 --- should be = 30
record 34 --- should be = 32
record 35 --- should be = 34
record 36 --- should be = 36
my code for php-plugin on form is:
PHP:
$db =& JFactory::getDBO();
$quantity2 = '{ccjom_cc_kk_karta_rejestr___zamow_quantity_pos_ordered_raw}';
$currentserial2 = '{ccjom_cc_kk_karta_rejestr___product_serial_num2_raw}';
$idclone2 = '{ccjom_cc_kk_karta_rejestr___id_raw}';
for ($i = 2; $i <= $quantity2; $i++) {
$idclone2 = '{ccjom_cc_kk_karta_rejestr___id_raw}' + 1;
$currentserial2 = '{ccjom_cc_kk_karta_rejestr___product_serial_num2_raw}' + 2;
$query = "UPDATE `ccjom_cc_kk_karta_rejestr` SET `product_serial_num2`= $currentserial2
WHERE `id` = " . $db->Quote($idclone2);
$db->setQuery($query);
$db->query();
}
this code seems nothing to do.
What is wrong?