adding fields in table, applying in controller

[ras2000]

Hello all
I was looking at
http://forums.opengoo.org/index.php?topic=1494.0
and thought I'd give it a try

I added a column to og_billing_categories called default_currency

I added the fields in add.php and index.php

I added the functions inBaseBillingCategory.class.php and the parameter in BillingController.class.php.

But the field is not updated in the table, and if I enter the currency manually, it does not appear on the pages.

Anyone know what I'm doing wrong?

I added the functions
    function getDefaultCurrency() {
      return $this->getColumnValue('default_currency');
    } // getDefaultCurrency()
    function setDefaultCurrency($value) {
      return $this->setColumnValue('default_currency', $value);
    } // setDefaultCurrency)
in BaseBillingCategory.class.php

I added this in BillingController.class.php, wherever relevant
            'default_currency' => '',

And changed the line where the $ was hardcoded in billing/index.php to
    <td style="text-align: center;padding:5px;padding-left:10px;padding-right:10px;"><?php echo clean($billing->getDefaultCurrency()) ?></td>
    <td style="text-align: center;padding:5px;padding-left:10px;padding-right:10px;"><?php echo clean($billing->getDefaultValue()) ?></td>

What else needs to be done for it to take effect?

[ras2000]

I found the missing link myself. I'll just post it, in case someone else is stumped by the same.
in BaseBillingCategories.class.php under models, the new array value needs to be designed:
    static private $columns = array(
       'id' => DATA_TYPE_INTEGER,
       'name' => DATA_TYPE_STRING,
       'default_value' => DATA_TYPE_FLOAT,
       'default_currency' => DATA_TYPE_STRING,
       'description' => DATA_TYPE_STRING,
       'report_name' => DATA_TYPE_STRING,
       'created_on' => DATA_TYPE_DATETIME,
       'created_by_id' => DATA_TYPE_INTEGER,
       'updated_on' => DATA_TYPE_DATETIME,
       'updated_by_id' => DATA_TYPE_INTEGER,
    );

[Pet]

nice, thanks for posting that solution