FrontAccounting forum — Add custom fields into item

Re: Add custom fields into item

null@example.com (Alaa) — Fri, 06 Oct 2017 17:41:50 +0000

@apmuthu.
Thanks.. all clear now.

Re: Add custom fields into item

null@example.com (apmuthu) — Fri, 06 Oct 2017 16:50:44 +0000

You need to create a new item for each combination of attributes. Otherwise, there is no place other than in the description to place your attribute specifics.

Re: Add custom fields into item

null@example.com (Alaa) — Thu, 05 Oct 2017 16:52:32 +0000

@apmuthu
the items are purchased..
So how do i add item attributes so that at item creation i have multible text boxes to add the needed data for each item.

@cristiart
i am trying to add special field for each item.. i dont want to add color and width in the describtion.
maybe we could use item type and have special set of fields for each item type.

Re: Add custom fields into item

null@example.com (cristiart) — Thu, 05 Oct 2017 14:26:15 +0000

the workaround in your case might be: when you add new item, make sure "Editable description:" is checked. Than you can alter each item description as needed.
Otherwise you'll have to do what apmuthu said above.

Re: Add custom fields into item

null@example.com (apmuthu) — Thu, 05 Oct 2017 13:51:30 +0000

These are product attributes. You can make one item for each combination of colour and width. That way you will be able to manage it's stock individually too.

Re: Add custom fields into item

null@example.com (Alaa) — Thu, 05 Oct 2017 06:39:44 +0000

this sounds good.. but i dont know if it works in my case...
what i want is a field when i add a new product.. where i can add color and width to each product i enter.. so i guess altering db is a must.

Re: Add custom fields into item

null@example.com (cristiart) — Wed, 04 Oct 2017 21:03:58 +0000

for better page view, you also might want to change line 52 into this:
$cols = array(4, 60, 300, 375, 400, 450, 490, 525);

Re: Add custom fields into item

null@example.com (cristiart) — Wed, 04 Oct 2017 21:01:56 +0000

here's how I did something similar without altering sql
I created 2 new items - item# none -and- item#003 (both editable)
the result you can see here: https://ibb.co/nNFpab

Then in rep109.php line 122 I replaced with:
if($myrow2['stk_code'] !="none" && $myrow2['stk_code'] !="003" ){
$rep->TextCol(0, 1, $myrow2['stk_code'], -2);
$oldrow = $rep->row; }

the result you can see here: https://ibb.co/nNFpab

so by adding item#"none" in your sales order, you can have as much info as you like without PDF file showing item# in file.

Re: Add custom fields into item

null@example.com (Alaa) — Wed, 04 Oct 2017 18:54:01 +0000

would you please share the code ??
i need to add Color , height & width to the item..
so is there some tutorial to do it? or some extension?

Regards.

Re: Add custom fields into item

null@example.com (apmuthu) — Thu, 12 Sep 2013 12:16:27 +0000

Wouldn't you want to share how you did it?

Re: Add custom fields into item

null@example.com (johnyu2012) — Sat, 07 Sep 2013 08:54:58 +0000

Successfully added the extra fields today. Thank you for all the help.

Re: Add custom fields into item

null@example.com (johnyu2012) — Fri, 06 Sep 2013 07:51:34 +0000

Thank you for the clearance.

Re: Add custom fields into item

null@example.com (apmuthu) — Fri, 06 Sep 2013 06:55:35 +0000

FA v2.3.x does not use the Foriegn Keys as yet (aka CASCADE ON DELETE, ON UPDATE, etc). It will be implemented only in FA v2.4. In PHP, the SQL statement will manually connect the tables using the JOIN syntax only. The keys will be there and the indexes will be available to speed up the execution.

The ERD is to show what links to what but is used to understand and frame the SQLs only.

Re: Add custom fields into item

null@example.com (johnyu2012) — Fri, 06 Sep 2013 06:47:23 +0000

If you don't use foreign key and references to link the table, how do you link all the tables with relationship? When I look at the Entity relationship diagram, it does have relationships between tables.

Re: Add custom fields into item

null@example.com (apmuthu) — Fri, 06 Sep 2013 05:32:14 +0000

FA has an includes folder in each major functionality's folder (sales, reporting, etc) besides a common one in the webroot. Each db folder in the major functionality's folders are basically models in the MVC architecture where themes serve the views, the actions coming from the URL GET parameters and the ACLs from the session variables.

Using a trigger to make the extra fields get inserted when the primary table's insert succeeds is one way to avoid writing php code.

As for docs, what little I have culled out is placed in the Wiki which would benefit from better organization as I have been left on a limb quite often when searching for my own nuggets hidden there in not very intuitive key word search terms.

Where possible, I have cross referenced in the wiki pages, the forum posts that pertain to it but not vice-versa very much.

Foreign Keys and references are due in FA v2.4 only.