a new field for product

[pedro fonseca]

steps:

1. Create a field 'fieldx' in ps_product table;
field name: fieldx
type: decimal
values: 26
default: as defined
0.00000


2. Edit file classes/product.php:
(Line 147 aprox.) added:

public $fieldx; 

(Line 163 aprox.) added to filesize:

'fieldx' => 32

(Line 196 aprox.)

'fieldx' => 'IsGenericName'

(Line 259 aprox.) added to getFields:

$fields['fieldx'] = pSQL($this->fieldx);

3. In admin/tabs/AdminProducts.php around line 1831, insert just an imput like this:

’.$this->l(‘Margen:’).’  
<input type=“text” size=“33” name=“fieldx” value=”’.htmlentities($this->getFieldValue($obj, ‘fieldx’), ENT_COMPAT, ‘UTF-8’).’” > * (’.$this->l(‘Margen one, and two’).’)

have a problem.:
appear a error in backoffice:

"1 error

an error occurred while creating object product"

Part of the code is wrong?

[Radu]

the field is defined as decimal. what type/how many decimals? how it is defined actually eg: decimal(4, 2); what value are you trying to submit?
you can also turn on sql debugging define('_PS_DEBUG_SQL_', true); in config/config.inc.php

[pedro fonseca]

actually:
decimal (4,2). View screenshot.

The error persists.

Problems in code?

[Radu]

actually I asked you something? what value are you trying to submit in your form?
have you turned on sql debugging?

[Radu]

are you getting the error with any submitted value?

[pedro fonseca]

no.
I can send you my files (with modification).

ok?

[Radu]

I really don't understand you. I said: "are you getting the error with any submitted value?"
you just answered no. With what value you don't get the error. With what value do you get the error?

[pedro fonseca]

i dont no.

where view de value error?

i dont no.

[Radu]

you can also send the files so I can take a look. MAke sure to let me know the prestashop version you have

[pedro fonseca]

version prestashop 1.3.7

send pm the files.

[otzy]

What is the purpose of your field?
How are you going to use in Front Office?
Why are attributes or customization fields not suitable for you?

[pedro fonseca]

the idea is for a new field in the product (AdminProduct.php). This field will be called "contribution" (%). When you enter a product choose % for this product. This value (% * price) will appear in the front office, beneath the final product price.

Something like: "By buying this product to help nature Ex.10 €)
understand Otzy?

[otzy]

Create attribute group "contribution", create attributes with different % values and add desired combination for each product.

>Something like: “By buying this product to help nature Ex.10 €
this may be created by JavaScript after page load. Just change tpl file in your theme folder.
Another way - to write a module with product footer hook function

It seems to me it is better than making modifications in core files.

[pedro fonseca]

I think...with combinations not is possible.

view screens (my idea).

thanks

[otzy]

One of the possible solutions with combinations:

find code in product.tpl

            {foreach from=$groups key=id_attribute_group item=group}
           {if $group.attributes|@count}


{$group.name|escape:'htmlall':'UTF-8'} :
               {assign var='groupName' value='group_'|cat:$id_attribute_group}
0}$('#wrapResetImages').show('slow');{/if}">
                   {foreach from=$group.attributes key=id_attribute item=group_attribute}
{$group_attribute|escape:'htmlall':'UTF-8'}
                   {/foreach}


           {/if}
           {/foreach}

replace it with this one:

            {foreach from=$groups key=id_attribute_group item=group}
           {if $group.attributes|@count}


               {if $group.name != 'contribution'}{$group.name|escape:'htmlall':'UTF-8'} :{/if}
               {assign var='groupName' value='group_'|cat:$id_attribute_group}
0}$('#wrapResetImages').show('slow');{/if}">
                   {foreach from=$group.attributes key=id_attribute item=group_attribute}
{$group_attribute|escape:'htmlall':'UTF-8'}
                       {if $group.name == 'contribution'}
                           {literal}[removed]
                               $(document).ready(function(){
                                   document.getElementById('contribution_label')[removed]="{/literal}{$group_attribute|escape:'htmlall':'UTF-8'}{literal}"
                               })
                           [removed]{/literal}
                       {/if}
                   {/foreach}


           {/if}
           {/foreach}

and place

wherever you want


I did not test code, this is only the demonstration of idea

[otzy]

oops

forum script replaces ". innerHTML" (without space after dot) with [removed]

also tags:
script type="text/javascript"
/script

[pedro fonseca]

not working.

the page product not open. appear blank.

and how create field in BO (page product)? or not necessary?

each product have a %. understand?

[pedro fonseca]

Mr. Otzy,
Create a combination name: "contribution"

the code product.tpl:

{foreach from=$groups key=id_attribute_group item=group}
           {if $group.attributes|@count}


               {if $group.name != 'contribution'}{$group.name|escape:'htmlall':'UTF-8'} :{/if}
               {assign var='groupName' value='group_'|cat:$id_attribute_group}
0}$('#wrapResetImages').show('slow');{/if}">
                   {foreach from=$group.attributes key=id_attribute item=group_attribute}
{$group_attribute|escape:'htmlall':'UTF-8'}
                       {if $group.name == 'contribution'}
                           {literal}. innerHTML $(document).ready(function(){
                                   document.getElementById('contribution_label')[removed]="{/literal}{$group_attribute|escape:'htmlall':'UTF-8'}{literal}"
                               })
                           . innerHTML{/literal}
                       {/if}
                   {/foreach}

page blank. not appear.