whmcsKerioEmail/app/UI/Client/EmailAccount/Pages/Accounts.php

<?php

namespace ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Pages;

use ThurData\Servers\KerioEmail\App\Helpers\BuildUrlExtended;
use ThurData\Servers\KerioEmail\App\Helpers\KerioManager;
use ThurData\Servers\KerioEmail\App\Libs\Product\ProductManager;
use ThurData\Servers\KerioEmail\App\Libs\Kerio\Components\Api\Soap\Connection;
use ThurData\Servers\KerioEmail\App\Libs\Kerio\Components\Api\Soap\Helpers\AccountHelper;
use ThurData\Servers\KerioEmail\App\Libs\Kerio\Components\Api\Soap\Models\Account;
use ThurData\Servers\KerioEmail\App\Libs\Kerio\Components\Api\Soap\Repository\ClassOfServices;
use ThurData\Servers\KerioEmail\App\Libs\Kerio\Components\Filters\EmailAccounts\FilterByCosId;
use ThurData\Servers\KerioEmail\App\UI\Admin\Custom\Fields\EnabledField;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\AddAccountButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\ChangePasswordButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\ChangeStatusButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\DeleteAccountButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\EditAccountButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\LoginToPanelButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\MassChangeStatusButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\MassDeleteAccountButton;
use ThurData\Servers\KerioEmail\App\UI\Client\EmailAccount\Buttons\SpanDropdownButton;
use function ThurData\Servers\KerioEmail\Core\Helper\di;
use ThurData\Servers\KerioEmail\Core\Models\Whmcs\Hosting;
use ThurData\Servers\KerioEmail\Core\UI\Widget\Buttons\DropdawnButtonWrappers\ButtonDropdown;
use ThurData\Servers\KerioEmail\Core\UI\Widget\DataTable\Column;
use ThurData\Servers\KerioEmail\Core\UI\Widget\DataTable\DataProviders\DataProvider;
use ThurData\Servers\KerioEmail\Core\UI\Interfaces\ClientArea;
use ThurData\Servers\KerioEmail\Core\UI\Widget\DataTable\DataProviders\Providers\ArrayDataProvider;
use ThurData\Servers\KerioEmail\Core\UI\Widget\DataTable\DataTable;
use ThurData\Servers\KerioEmail\Api\KerioWhmcs;

/**
 *
 * Created by PhpStorm.
 * User: ThurData
 * Date: 10.09.19
 * Time: 10:51
 * Class Accounts
 */
class Accounts extends DataTable implements ClientArea
{

    /**
     * labels for statuses
     */
    const STATUS_LABEL = [
        'active'        => 'success',
        'locked'        => 'default',
        'maintenance'   => 'warning',
        'closed'        => 'default',
        'lockout'       => 'info',
        'pending'       => 'warning',
        'default'       => 'default'
    ];

    protected $id    = 'accounts';
    protected $name  = 'accounts';
    protected $title = null;

    /**
     * load columns
     */
    protected function loadHtml()
    {
        $this
            ->addColumn((new Column('mailbox'))
                ->setOrderable(DataProvider::SORT_ASC)
                ->setSearchable(true, Column::TYPE_STRING))
            ->addColumn((new Column('date_created'))
                ->setOrderable()
                ->setSearchable(true))
            ->addColumn((new Column('date_created'))
                ->setOrderable()
                ->setSearchable(true))
            ->addColumn((new Column('last_login'))
                ->setOrderable()
                ->setSearchable(true))
            ->addColumn((new Column('quota'))
                ->setOrderable()
                ->setSearchable(true, Column::TYPE_INT))
            ->addColumn((new Column('status'))
                ->setOrderable()
                ->setSearchable(true));
    }

    /**
     * @param $key
     * @param $row
     * @return mixed
     */
    public function replaceFieldStatus($key, $row)
    {
        $status = self::STATUS_LABEL[$row[$key]] ? self::STATUS_LABEL[$row[$key]] : self::STATUS_LABEL['default'];
        $label = di('lang')->absoluteT('kerio','account','status',$row[$key]);

        $field = new EnabledField();
        $field->setRawType($status);
        $field->setRawTitle($label);

        return $field->getHtml();
    }

    /**
     * @param $key
     * @param $row
     * @return mixed
     */
    public function replaceFieldLast_login($key, $row)
    {
        return $row[$key] ? $row[$key] : '-';
    }

    /**
     * load buttons
     */
    public function initContent()
    {

        logModuleCall(
            'kerioEmail',
            __FUNCTION__,
            $params,
            'Debug Accounts',
            $this
        );

        $productManager = new ProductManager();
        $productManager->loadByHostingId($this->getRequestValue('id'));

        $this->addMassActionButton(new MassChangeStatusButton());
        $this->addMassActionButton(new MassDeleteAccountButton());

        $this->addButton(new AddAccountButton());


        $this->addActionButton(new EditAccountButton());
        $this->addActionButton(new DeleteAccountButton());

        $mailBox = new LoginToPanelButton();
        $mailBox
            ->setRawUrl(BuildUrlExtended::getProvisioningUrl('webmail', true, true,'clientSso'))
            ->setRedirectParams(['actionElementId' => 'true']);

        $actions = new SpanDropdownButton('actions');
        $actions->addButton(new ChangeStatusButton());
        $actions->addButton(new ChangePasswordButton());

        if ($productManager->get('ca_logInToMailboxButton') === 'on')
        {
            $actions->addButton($mailBox);
        }

        $this->addActionButton($actions);

    }

    /**
     * load data
     */
    public function loadData()
    {
        /**
         * load hosting
         */
        $hosting = Hosting::where('id', $this->getRequestValue('id'))->first();

        $api = new KerioWhmcs('whmcsKerioEmail', 'Thurdata', '1.0');
        try {
            $api->login($params['serverhostname'], $params['serverusername'], $params['serverpassword']);
            $domains = $api->getDomains(['id','name']);
        } catch (KerioApiException $error) {
            logModuleCall(
                'kerioEmail',
                __FUNCTION__,
                $error,
                'Debug Error',
                $error->getMessage()
            );
            return ['error' => $error->getMessage()];
        }
        logModuleCall(
            'kerioEmail',
            __FUNCTION__,
            $params,
            'Debug Accounts',
            $domains
        );
        $api->logout();

        $productManager = new ProductManager();
        $productManager->loadByHostingId($hosting->id);

        /**
         * format model to array
         */
        $data = [];
/*        foreach ($accounts as $account)
        {

            $accountArray = [
                'id'           => $account->getId(),
                'mailbox'      => $account->getName(),
                'date_created' => AccountHelper::getFormattedData($account->getDataResourceA('kerioCreateTimestamp')),
                'last_login'   => AccountHelper::getFormattedData($account->getDataResourceA('kerioLastLogonTimestamp'), 'd/m/Y H:i'),
                'quota'        => AccountHelper::getQuotaAsMb($account->getDataResourceA('kerioMailQuota')),
                'status'       => $account->getDataResourceA('kerioAccountStatus'),

            ];

            $data[] = $accountArray;
        } */
        $dataProv = new ArrayDataProvider();
        $dataProv->setDefaultSorting('mailbox', 'ASC')->setData($data);

        $this->setDataProvider($dataProv);
    }

}