Custom Client Search Results fields

[romerositios]

As of right now I have the defaults ID Product / Service Domain Client Name Price Billing Cycle Next Due Date

Is there a way to add Payment Method and Status in search results?

Thanks a lot!

 

[brian!]

On 31/01/2019 at 20:05, romerositios said:

As of right now I have the defaults ID Product / Service Domain Client Name Price Billing Cycle Next Due Date

Is there a way to add Payment Method and Status in search results? 

can you post a screenshot of which page you're talking about - i'm not sure which one you mean.

[romerositios]

On 2/2/2019 at 1:03 PM, brian! said:

can you post a screenshot of which page you're talking about - i'm not sure which one you mean.

[brian!]

thanks for posting the screenshot - sadly, those pages are hardcoded, don't use a template and even if you could add extra columns using js, I don't know if the resulting array contains the payment method and status in the results.

two alternate solutions - the clientsummary page uses a template (clientsummary.tpl) and so it is easier to add these columns to their output and the two threads below will help with that... however, if you're using v4 (as per the screenshot), then don't just copy & paste the code posted as it's written for "Blend"...

for v4, it should be along the lines of...

<div class="tablebg">
<table class="datatable filterable" width="100%" border="0" cellspacing="1" cellpadding="3">
<tr><th width="20"><input type="checkbox" id="prodsall" /></th><th>{$_ADMINLANG.fields.id}</th><th>{$_ADMINLANG.fields.product}</th><th>{$_ADMINLANG.fields.amount}</th><th>{$_ADMINLANG.fields.billingcycle}</th><th>{$_ADMINLANG.fields.signupdate}</th><th>{$_ADMINLANG.fields.nextduedate}</th><th>{$_ADMINLANG.fields.paymentmethod}</th><th>{$_ADMINLANG.fields.status}</th><th width="20"></th></tr>
{foreach key=num from=$productsummary item=product}
<tr><td><input type="checkbox" name="selproducts[]" value="{$product.id}" class="checkprods" /></td><td><a href="clientsservices.php?userid={$clientsdetails.userid}&id={$product.id}">{$product.idshort}</a></td><td style="padding-left:5px;padding-right:5px">{$product.dpackage} - <a href="http://{$product.domain}" target="_blank">{$product.domain}</a></td><td>{$product.amount}</td><td>{$product.dbillingcycle}</td><td>{$product.regdate}</td><td>{$product.nextduedate}</td><td>{$product.dpaymentmethod}</td><td class="status" data-filter-value="{$product.domainoriginalstatus}">{$product.domainstatus}</td><td><a href="clientsservices.php?userid={$clientsdetails.userid}&id={$product.id}"><img src="images/edit.gif" width="16" height="16" border="0" alt="Edit"></a></td></tr>
{foreachelse}
<tr><td colspan="9">{$_ADMINLANG.global.norecordsfound}</td></tr>
{/foreach}
</table>
</div>

obviously, this will only show the services details for that particular client.

another way to get the information you require would be to use the Services report as that has the option of showing status/payment method by default.

[romerositios]

Thanks a lot! So it can't be done 😔

[brian!]

16 hours ago, romerositios said:

So it can't be done

I couldn't think of a solution off the top of my head to your specific ideal outcome - but as I said, you can get the same information from the services report with your desired fields in the output.