### Forum

## Calc Builder Support

Calc Builder supportForums

Public write access is disabled. Please login

### Can matrix values used for any calculation you want 03.11.2018 10:29

I want to make use of matrix values for different calculations.

We have created price calculations for similar products:

Price calculation product 1

Price calculation product 2

These price calculation make use of the same prices per kilogram for different materials. So we want to make a matrix $prices with the data:

material1=price1

material2=price2

Is it possible to use the values of the matrix $prices in both price calculations?

Or with other words : is it possible to create a "central" matrix which values can be recovered in any calculation you want?

We have created price calculations for similar products:

Price calculation product 1

Price calculation product 2

These price calculation make use of the same prices per kilogram for different materials. So we want to make a matrix $prices with the data:

material1=price1

material2=price2

Is it possible to use the values of the matrix $prices in both price calculations?

Or with other words : is it possible to create a "central" matrix which values can be recovered in any calculation you want?

### Re: Can matrix values used for any calculation you want 05.11.2018 11:03

Hi,

very interesting question, you have one way to share information among different calculators, using a query to the general database at your code section. If you have one matrix created called 'prices', and you want to use it in another calculator, you can try to include this code below

$db =JFactory::getDBO();

$db->setQuery("select value from #__calcbuilder_matrix where var='prices'");

eval("$prices=".$db->loadResult().";");

/*

At this point you can use

$prices

matrix same as you were working with the calculator this matrix belongs to

*/

Hope this helps

Moonsoft Team

www.moonsoft.es

very interesting question, you have one way to share information among different calculators, using a query to the general database at your code section. If you have one matrix created called 'prices', and you want to use it in another calculator, you can try to include this code below

$db =JFactory::getDBO();

$db->setQuery("select value from #__calcbuilder_matrix where var='prices'");

eval("$prices=".$db->loadResult().";");

/*

At this point you can use

$prices

matrix same as you were working with the calculator this matrix belongs to

*/

Hope this helps

Moonsoft Team

www.moonsoft.es

### Re: Can matrix values used for any calculation you want 05.11.2018 17:47

I am not sure if I have understood it correctly because it does not work yet.

I have created a calculator with the name: general

In this calculator I have created a matrix with the name : prices.

The colomn name of this matrix : price

And row names are : material1, material2,... and so on.

I have created another calculator with the name: pricecalulator product 1

In this calculator I want to calculate the price of a aluminium profile by multiplying the weight of the profile with the price per kilogram of the profile.

Question 1. Do I have to paste the next code into the code section of the calculator with the name : general ? Or in the pricecalculator product 1?

$db =JFactory::getDBO();

$db->setQuery("select value from #__calcbuilder_matrix where var='prices'");

eval("$prices=".$db->loadResult().";");

Question 2. Is the next PHP code correct when I want to recover the price of material1 to calculate the $profileprice based on the $profileweight in the calculator with the name : pricecalulator product 1

$profileprice=$prices["material1"]["price"]*$profileweight;

Regards,

AdK

I have created a calculator with the name: general

In this calculator I have created a matrix with the name : prices.

The colomn name of this matrix : price

And row names are : material1, material2,... and so on.

I have created another calculator with the name: pricecalulator product 1

In this calculator I want to calculate the price of a aluminium profile by multiplying the weight of the profile with the price per kilogram of the profile.

Question 1. Do I have to paste the next code into the code section of the calculator with the name : general ? Or in the pricecalculator product 1?

$db =JFactory::getDBO();

$db->setQuery("select value from #__calcbuilder_matrix where var='prices'");

eval("$prices=".$db->loadResult().";");

Question 2. Is the next PHP code correct when I want to recover the price of material1 to calculate the $profileprice based on the $profileweight in the calculator with the name : pricecalulator product 1

$profileprice=$prices["material1"]["price"]*$profileweight;

Regards,

AdK

### Re: Can matrix values used for any calculation you want 06.11.2018 09:56

Hi,

1. the code should be placed at the code section of the calculator 'product1' (just at the beginning). Please copy it again, the forum content sometimes strips out some special chars, here the right lines:

$db =JFactory::getDBO();

$db->setQuery("select value from #__calcbuilder_matrix where var='prices'");

eval("\$prices=".$db->loadResult().";");

2. below these lines you can start to use the matrix 'prices', so this is correct:

$profileprice=$prices["material1"]["price"]*$profileweight;

Please double check your matrix has the 'variable' set to 'prices' (and not only the name). If you can't get it working, please place a ticket at the helpdesk, where code can be shared without restrictions.

Thanks, regards

Moonsoft Team

www.moonsoft.es

1. the code should be placed at the code section of the calculator 'product1' (just at the beginning). Please copy it again, the forum content sometimes strips out some special chars, here the right lines:

$db =JFactory::getDBO();

$db->setQuery("select value from #__calcbuilder_matrix where var='prices'");

eval("\$prices=".$db->loadResult().";");

2. below these lines you can start to use the matrix 'prices', so this is correct:

$profileprice=$prices["material1"]["price"]*$profileweight;

Please double check your matrix has the 'variable' set to 'prices' (and not only the name). If you can't get it working, please place a ticket at the helpdesk, where code can be shared without restrictions.

Thanks, regards

Moonsoft Team

www.moonsoft.es

### Re: Can matrix values used for any calculation you want 06.11.2018 13:09

You forgot to put the backslash (\) in the last line of the code in your first reply on november 5th. With the blackslash it works perfect.

We are very happy we can share matrices between calculations.

Thank you very much for your help.

The code looks for me impressive, I could never wrote this code by myself.

Best regards

AdK

We are very happy we can share matrices between calculations.

Thank you very much for your help.

The code looks for me impressive, I could never wrote this code by myself.

Best regards

AdK

### Re: Can matrix values used for any calculation you want 07.11.2018 09:53

Hi,

yes, the front-parser 'ate' the backslash, at the last entry we forced to show right. Great it worked, its a little bit tricky because of the format used to store, but you can use the same code in any other calculator now.

Regards

Moonsoft Team

www.moonsoft.es

yes, the front-parser 'ate' the backslash, at the last entry we forced to show right. Great it worked, its a little bit tricky because of the format used to store, but you can use the same code in any other calculator now.

Regards

Moonsoft Team

www.moonsoft.es