Jump to content

Sparky's Admin Upcoming Domain Renewals V4 template


Recommended Posts

Show Upcoming Domain Renewals on the Admin V4 homepage that will expire in the next 90 days.

Change the number in $range = "<= 90"; to the number of days before expiry that you want to display.

 

Open admin/templates/v4/homepage.tpl

 

Find:

<div class="errorbox" style="font-size:14px;"><a href="supporttickets.php">{$sidebarstats.tickets.awaitingreply} Ticket(s) Awaiting Reply</a> || <a href="cancelrequests.php">{$stats.cancellations.pending} Pending Cancellation(s)</a> || <a href="todolist.php">{$stats.todoitems.due} To-Do Item(s) Due</a> || <a href="networkissues.php">{$stats.networkissues.open} Open Network Issue(s)</a></div>

<br />

Underneath it insert this code:

<!-- START ADMIN UPCOMING DOMAIN RENEWALS -->

<h3 align="center">Upcoming Domain Renewals</h3>

<table bgcolor="#cccccc" align="center" style="margin-bottom:5px;width:100%;" cellspacing="1">
<tr bgcolor="#efefef" style="text-align:center;font-weight:bold;"><td>Domain</td><td>Registrar</td><td>Period</td><td>Next Due Date</td><td>Expiration Date</td><td>Amount</td><td>Do Not<br />Renew</td></tr>
{php}
   $x=1; $range = "<= 90";
   $result = mysql_query("SELECT * FROM `tbldomains` WHERE DATEDIFF(`expirydate`, Now()) $range AND `status` = 'Active' ORDER BY `expirydate` ASC");
   while ($data = @mysql_fetch_array ($result)) {
       echo '<tr bgcolor="#ffffff" style="text-align:center;"><td><a href="clientsdomains.php?userid='.$data['userid'].'&id='.$data['id'].'">'.$data['domain'].'</a></td><td>'.$data['registrar'].'</td><td>'.$data['registrationperiod'].'</td><td>'.fromMySQLDate($data['nextduedate']).'</td><td>'.fromMySQLDate($data['expirydate']).'</td><td>'.formatCurrency($data['recurringamount']).'</td><td>'.$data['donotrenew'].'</td></tr>'; $x=0;
   }
   if($x) echo '<tr bgcolor="#ffffff" style="text-align:center;"><td colspan="7">No upcoming domain renewals</td></tr>';
{/php}
</table>
<br />
<!-- END ADMIN UPCOMING DOMAIN RENEWALS -->

Link to comment
Share on other sites

  • Replies 144
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Check the prefix and suffix in your currency settings

 

Ok, I deleted the prefixes of the currencies and by default it shows the local amount without the currency symbol. So fa we can manage like this. Thanks!

Link to comment
Share on other sites

This will show any hosting renewals due for the next 14 days.

 

Change $range to adjust to your liking for the number of days ahead to view.

 

Place in your homepage.tpl for your template in admin

<!-- START ADMIN UPCOMING HOSTING RENEWALS -->

<h3 align="center">Upcoming Hosting Renewals (Next 14 Days)</h3>

<table bgcolor="#cccccc" align="center" style="margin-bottom:5px;width:100%;" cellspacing="1">
<tr bgcolor="#efefef" style="text-align:center;font-weight:bold;"><td>Domain</td><td>Billing Cycle</td><td>Payment Method</td><td>Next Due Date</td><td>Amount</td></tr>
{php}
   $i=1; $range = "<= 14";
   $result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) $range AND `server` > 0 ORDER BY `nextduedate` ASC");
   while ($data = @mysql_fetch_array ($result)) {
       echo '<tr bgcolor="#ffffff" style="text-align:center;"><td><a href="clientshosting.php?userid='.$data['userid'].'&id='.$data['id'].'">'.$data['domain'].'</a></td><td>'.$data['billingcycle'].'</td><td>'.$data['paymentmethod'].'</td><td>'.fromMySQLDate($data['nextduedate']).'</td><td>'.formatCurrency($data['amount']).'</td></tr>'; $i=0;
   }
   if($i) echo '<tr bgcolor="#ffffff" style="text-align:center;"><td colspan="7">No upcoming hosting renewals</td></tr>';
{/php}
</table>
<br />
<!-- END UPCOMING HOSTING RENEWALS -->

Link to comment
Share on other sites

small changes to show only Active hosting renewals

 

change

$result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) $range AND `server` > 0 ORDER BY `nextduedate` ASC");

to:

$result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) $range AND `domainstatus` = 'Active' AND `server` > 0 ORDER BY `nextduedate` ASC");

Link to comment
Share on other sites

Since we are using different registrars and the same our clients, domains that are not under our control don't need to be alerted for renewal.

 

Is this something that can be done? We are using mainly OnlineNic registrar. And some of our clients have their own OnlineNic API or other registrars and don't need to be renewed with us.

 

Did I make sense?

Link to comment
Share on other sites

small changes to show only Active hosting renewals

 

change

$result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) $range AND `server` > 0 ORDER BY `nextduedate` ASC");

to:

$result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) $range AND `domainstatus` = 'Active' AND `server` > 0 ORDER BY `nextduedate` ASC");

I had that in just before I posted it but then thought that some may want to see if its coming up even if it was suspended.

Link to comment
Share on other sites

Since we are using different registrars and the same our clients, domains that are not under our control don't need to be alerted for renewal.

If referring to upcoming domains

Why would you want to have the domain in your whmcs if you are not managing it?

If the client manages his own domain then it won't show in the list because it should not be stored in your whmcs.

 

If referring to the upcoming hosting

The domain is just a reference. When clicked is takes you to the hosting package.

Link to comment
Share on other sites

I had that in just before I posted it but then thought that some may want to see if its coming up even if it was suspended.

 

Sparky, is this will be correct ? (for hosting renewals)

$result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) <= $range AND (`domainstatus` = 'Active' OR `domainstatus` = 'Suspended' ) AND `server` > 0 ORDER BY `nextduedate` ASC");

Link to comment
Share on other sites

Sparky, is this will be correct ? (for hosting renewals)

$result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) <= $range AND (`domainstatus` = 'Active' OR `domainstatus` = 'Suspended' ) AND `server` > 0 ORDER BY `nextduedate` ASC");

No... <= is a part of $range variable

$result = mysql_query("SELECT * FROM `tblhosting` WHERE DATEDIFF(`nextduedate`, Now()) $range AND (`domainstatus` = 'Active' OR `domainstatus` = 'Suspended') AND `server` > 0 ORDER BY `nextduedate` ASC");

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated