Showing more information in the customer overview

[GoogleCodeExporter]

In our case we have the problem that we have several companies that are several 
times customers. (e.g. New York branch and London branch are different 
customers)

We added therefore the name of the contact person on 
/index.php?module=customers&view=manage

Sadly I have some other changes so I can not send you a patch file. But here 
are the changes:

/modules/customers/manage.js.php (line 27)

                {display: '{/literal}{$LANG.actions}{literal}', name : 'actions', width : 10 * percentage_width, sortable : false, align: 'center'},

                {display: '{/literal}{$LANG.name}{literal}', name : 'name', width : 40 * percentage_width, sortable : true, align: 'left'},

                {display: '{/literal}{$LANG.customer_contact}{literal}', name : 'contact_person', width : 20 * percentage_width, sortable : true, align: 'left'},

                {display: '{/literal}{$LANG.total}{literal}', name : 'customer_total', width : 10 * percentage_width, sortable : true, align: 'left'},

                {display: '{/literal}{$LANG.owing}{literal}', name : 'owing', width : 10 * percentage_width, sortable : true, align: 'left'},

                {display: '{/literal}{$LANG.enabled}{literal}', name : 'enabled', width : 10 * percentage_width, sortable : true, align: 'left'}

I added the line about "customer_contact" and changed the percentages.

/modules/customers/xml.php (line 67)

    $sql = "SELECT
            c.id as CID,
            c.name as name,
            c.attention as attention,

On line 67 I added the "c.attention as attention," just before the (SELECT...

And on line 118 of the same file I had to add:

$xml .= "<cell><![CDATA[".$row['attention']."]]></cell>";

Original issue reported on code.google.com by r.luthi...@gmail.com on 30 Jul 2011 at 12:06

[GoogleCodeExporter]

thanks for posting this

you may want to share this on our forum - simpleinvoices.org/forum as many 
people want to know how to do this

cheers

justin

Original comment by jus...@kelly.org.au on 30 Jul 2011 at 1:02

• Changed state: Closed-Verified

[GoogleCodeExporter]

Is it OK if I commit this code now? I have to extend this on other places too 
(e.g. When creating a new invoice in the customer selection drop-down.)

I opened this issue again for myself to either commit the code or to write an 
article in the forum.

Original comment by r.luthi...@gmail.com on 8 Aug 2011 at 10:37

• Changed state: Open-Accepted

[GoogleCodeExporter]

Yer go for it, I think it is a useful feature for everyone.

Thanks,
Matt

Original comment by MattAntW...@gmail.com on 8 Aug 2011 at 11:11

• Added labels: Component-UI

[GoogleCodeExporter]

Solved in https://code.google.com/p/simpleinvoices/source/detail?r=3669

Original comment by r.luthi...@gmail.com on 9 Aug 2011 at 9:20

• Changed state: Closed-Fixed