Tracmor Forum - Developer Discussion

Tracmor and Oracle 10g DB

2010-09-06T09:05:26Z

I'm trying to use Tracmor with an Oracle 10g DB, by using an adapter written for QCodo by RTacconi. But when i started using I receive the error ORA-00972: identificativo troppo lungo (too long identifier), in fact there's the alias ' role_module__module_id__short_description' that is long more than 30 characters.
I hope someone could help me...
Thanks

Asset Depreciation

2010-05-13T13:43:39Z

I have just gotten tracmor up and running and instantly got a new requirement from our controller. He would like some way to track asset depreciation so that he can keep track of the present book value of each item. We're a non-profit and every piece of equipment that we have in inventory has to be capitalized on our books. Are there any plans to include this sort of functionality at some point? Has anyone else had this requirement? If not, I am going to start developing my own. When I am finished I can post what I've done somewhere so other's can use it... if that acceptable to the project owners.

Thanks,
Steve

Reports

2010-02-03T18:02:08Z

Hey when do you think you will have the functionality to do reports? This would be very useful.
And the reports features, will you be making it possible to add up the total cost of all the products you have?

Thanks Let me know

Starting Development

2010-01-24T20:00:28Z

Got Qcodo loaded on my development server and have gone through the how-to on the Qcodo site. I have a basic understanding of how it is setup and works.

Should I be able to make changes in the 'tracmor' directory and issue a 'codegen' to re-build and see my changes that I made? That is of-course with the correct 'configuration.inc.php' file settings.

Also, I have created some graphs in Code Charge Studio4 that I would like to include in the Reports page. How easy is it to add graphs to the reports pages? Or for that matter, create a new page and have those custom reports included on that page?

I am still working on gluing the system together...

QQ::Clause question

2009-11-22T16:32:23Z

Hi
I am trying to do some modifications to the objChildAssetArray in asset_edit.php. I have already added some custom fields columns to the datagrid. What remains is to actually put some data there. As for now only the heading shows.

I tried to do this in asset_edit.php I tried to add this as a clause to the LoadArrayByParentAssetId. The problem is I have no idea what I am doing.

if ($this->objAsset && is_int($this->objAsset->AssetId)) {
    $objClauses = QQ::Clause(QQ::Expand(QQN::Asset()->CustomFieldSelection()k->CustomFieldValue));
    $this->ctlAssetEdit->objChildAssetArray = Asset::LoadArrayByParentAssetId($this->objAsset->AssetId, $objClauses);
}
else {
    $this->ctlAssetEdit->objChildAssetArray = array();
}

Could someone please try to set up this clause statement for me?

Internalization

2009-09-28T16:02:05Z

Hi,

I'm planning to use Tracmor at work, but I need it in french.
So i've started to modify the code to use QI18n from the Qcodo framework.

As a proof-of-concept i've tried to translate the Asset page's shortcuts menu :
- In includes/data_classes/Shortcut.class.php :
public function __toString() {
return sprintf('%s', QApplication::Translate($this->strShortDescription));

- I've created a fr.po file in includes/qcodo/i18n with the translations

- I've set up language and country settings in includes/prepend.inc.php
(near the end of file)
if (QApplication::$LanguageCode)
QI18n::Initialize();
else {
QApplication::$CountryCode = 'fr';
QApplication::$LanguageCode = 'fr';
QI18n::Initialize();
}

- Hit reload on my browser and ... IT WORKS !!

I will continue to internationalize strings in tracmor code, but i wish to contribute back my changes, how can I do ?

Greetings,

Olivier ROCH VILATO

Asset Transaction Report

2009-08-20T17:59:02Z

It appears 0.1.0 contains work toward functional reports, but no actual working reports. Is that right? What needs to be done to get the functional asset transaction report available in 0.2.0 working on 0.1.0? I tried updating the files that appeared relevant and I'm getting a PHP fatal for a call to an undefined method AssetTransaction::counttransactionsbysearch().