join('tblinvoices', 'tblinvoices.id', '=', 'ResellersCenter_bulk_domains_action.invoiceid')->select('ResellersCenter_bulk_domains_action.*')->where('ResellersCenter_bulk_domains_action.status', '0')->where('tblinvoices.status', 'Paid')->take(5)->get(); echo '
';
print_r($actions); //die();
$domainsName = '';
foreach ($actions as $action) {
    $domainid = $action->domainid;

    $getDomainName = Capsule::table('tbldomains')->where('id', $domainid)->first();
    $domainsName .= $getDomainName->domain . '
';
    $renewal_period = '1';
    $command = 'DomainRenew';
    $postData = array('domainid' => $domainid, 'regperiod' => $renewal_period);
    $adminUsername = ''; // Optional for WHMCS 7.2 and later
    $results = localAPI($command, $postData, $adminUsername);
    if ($results['result'] == 'success') {
        Capsule::table("ResellersCenter_bulk_domains_action")->where('id', $action->id)->update(array('status' => '1'));
        $domainData = Capsule::table("tbldomains")->where('id', $domainid)->first();
        Capsule::table("tbldomains")->where('id', $domainid)->update(array('nextduedate' => $domainData->expirydate, 'nextinvoicedate' => $domainData->expirydate));
        logActivity('Bulk Renew Domain From Reseler #' . $domainid . ' domain renew successfully', $_SESSION['uid']);
    } else {
        logActivity('Bulk Renew Domain From Reseler : ' . $results['message'] . ':' . $results['error'], $_SESSION['uid']);
    }
    //  echo '
'; print_r($results);die('test');
}
$command = 'SendEmail';
$postData = array(
    'id' => '18743',
    'customtype' => 'general',
    'customsubject' => 'Domain Bulk Renewal Cron Done ' . date('Y-m-d H:i:s'),
    'custommessage' => '
Hi Saji Samuel,
Domain bulk renewal cron has been completed.
Domains list as given below:
' . $domainsName,
);
$adminUsername = '';
//if(!empty($domainsName))
   // $results = localAPI($command, $postData, $adminUsername);
die('done');
?>