/**
* grid
* create the configuration of the grid
*/
public static function grid($rowNum = 10)
{
$translator = Shineisp_Registry::getInstance()->Zend_Translate;
$config['datagrid']['columns'][] = array('label' => null, 'field' => 'd.domain_id', 'alias' => 'domain_id', 'type' => 'selectall');
$config['datagrid']['columns'][] = array('label' => $translator->translate('ID'), 'field' => 'd.domain_id', 'alias' => 'domain_id', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Domain'), 'field' => 'd.domain', 'alias' => 'domain', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('TLD'), 'field' => 'ws.tld', 'alias' => 'tld', 'sortable' => true, 'searchable' => true, 'type' => 'string', 'attributes' => array('class' => 'visible-lg visible-md hidden-xs'));
$config['datagrid']['columns'][] = array('label' => $translator->translate('Renewal'), 'field' => 'd.autorenew', 'alias' => 'autorenew', 'sortable' => true, 'searchable' => true, 'type' => 'boolean', 'attributes' => array('class' => "visible-lg visible-md hidden-xs"));
$config['datagrid']['columns'][] = array('label' => $translator->translate('Creation date'), 'field' => 'creation_date', 'alias' => 'creation_date', 'sortable' => true, 'searchable' => true, 'type' => 'date', 'attributes' => array('class' => "visible-lg visible-md hidden-xs"));
$config['datagrid']['columns'][] = array('label' => $translator->translate('Expiry Date'), 'field' => 'expiring_date', 'alias' => 'expiring_date', 'sortable' => true, 'searchable' => true, 'type' => 'date', 'attributes' => array('class' => "visible-lg visible-md hidden-xs"));
$config['datagrid']['columns'][] = array('label' => $translator->translate('Days left'), 'field' => 'daysleft', 'alias' => 'daysleft', 'sortable' => true, 'type' => 'string', 'attributes' => array('class' => "visible-lg visible-md hidden-xs"));
$config['datagrid']['columns'][] = array('label' => $translator->translate('Last Name'), 'field' => 'c.lastname', 'alias' => 'lastname', 'sortable' => true, 'searchable' => true, 'type' => 'string', 'attributes' => array('class' => "visible-lg visible-md hidden-xs span1"));
$config['datagrid']['columns'][] = array('label' => $translator->translate('Registrar'), 'field' => 'r.name', 'alias' => 'registrar', 'sortable' => true, 'searchable' => true, 'type' => 'string', 'attributes' => array('class' => "visible-lg visible-md hidden-xs"));
$config['datagrid']['columns'][] = array('label' => $translator->translate('Status'), 'field' => 's.status', 'alias' => 'status', 'sortable' => true, 'type' => 'index', 'searchable' => true, 'filterdata' => Statuses::getList('domains'));
$config['datagrid']['fields'] = "d.domain_id, \r\n\t\t\t\t\t\t\t\t\t\t\tCONCAT(d.domain, '.', ws.tld) as domain, \r\n\t\t\t\t\t\t\t\t\t\t\td.autorenew as autorenew, \r\n\t\t\t\t\t\t\t\t\t\t\tDATE_FORMAT(creation_date, '" . Settings::getMySQLDateFormat('dateformat') . "') as creation_date, \r\n\t\t\t\t\t\t\t\t\t\t\tDATE_FORMAT(expiring_date, '" . Settings::getMySQLDateFormat('dateformat') . "') as expiring_date, \r\n\t\t\t\t\t\t\t\t\t\t\tDATEDIFF(expiring_date, CURRENT_DATE) as daysleft, \r\n\t\t\t\t\t\t\t\t\t\t\tr.name as registrar, \r\n\t\t\t\t\t\t\t\t\t\t\tws.tld as tld, \r\n\t\t\t\t\t\t\t\t\t\t\ts.status as status, \r\n\t\t\t\t\t\t\t\t\t\t\tc.lastname as lastname";
$dq = Doctrine_Query::create()->select($config['datagrid']['fields'])->from('Domains d')->leftJoin('d.DomainsTlds dt')->leftJoin('dt.WhoisServers ws')->leftJoin('d.TagsConnections tc')->leftJoin('d.Customers c')->leftJoin('d.OrdersItems oi')->leftJoin('d.Registrars r')->leftJoin('d.Statuses s')->orderBy('d.domain')->addWhere("c.isp_id = ?", Isp::getCurrentId());
$config['datagrid']['dqrecordset'] = $dq;
$config['datagrid']['rowlist'] = array('10', '50', '100', '1000');
$config['datagrid']['index'] = "domain_id";
// Automatic Renewal function
$massactions['bulk_set_autorenew&status=1'] = "Enable Automatic Renewal";
$massactions['bulk_set_autorenew&status=0'] = "Disable Automatic Renewal";
$massactions['bulk_delete'] = 'Mass Delete';
$massactions['bulk_export'] = 'Export Domain Listing';
$massactions['bulk_check_dns'] = 'Check DNS Zone';
$config['datagrid']['massactions']['common'] = $massactions;
$statuses = Statuses::getList('domains');
if (!empty($statuses)) {
$customacts = array();
}
foreach ($statuses as $key => $value) {
$customacts['bulk_set_status&status=' . $key] = "Set as {$value}";
}
$config['datagrid']['massactions']['statuses'] = $customacts;
$actions = Registrars::getActions();
if (!empty($actions)) {
$customacts = array();
}
foreach ($actions as $registrar => $tasks) {
foreach ($tasks as $action => $label) {
$customacts['bulk_registrar_tasks&task=' . $action] = $translator->_('%s registrar task: %s', $registrar, $label);
}
}
$config['datagrid']['massactions']['registrars'] = $customacts;
return $config;
}
/**
* editAction
* Get a record and populate the application form
* @return unknown_type
*/
public function editAction()
{
$form = $this->getForm('/admin/domains/process');
$this->view->title = $this->translator->translate("Domain Edit");
$this->view->description = $this->translator->translate("Here you can edit your own domain parameters.");
$id = $this->getRequest()->getParam('id');
if (!empty($id) && is_numeric($id)) {
// Create the buttons in the edit form
$this->view->buttons = array(array("url" => "#", "label" => $this->translator->translate('Save'), "params" => array('css' => null, 'id' => 'submit')), array("url" => "/admin/domains/confirm/id/{$id}", "label" => $this->translator->translate('Delete'), "params" => array('css' => null)), array("url" => "/admin/domains/list", "label" => $this->translator->translate('List'), "params" => array('css' => null)), array("url" => "/admin/domains/new/", "label" => $this->translator->translate('New'), "params" => array('css' => null)), array("url" => "/admin/domains/newevent/id/{$id}", "label" => $this->translator->translate('Calendar Event'), "params" => array('css' => null)));
try {
$rs = $this->domains->find($id, null);
if (!empty($rs[0])) {
$rs[0]['creation_date'] = Shineisp_Commons_Utilities::formatDateOut($rs[0]['creation_date']);
$rs[0]['expiring_date'] = Shineisp_Commons_Utilities::formatDateOut($rs[0]['expiring_date']);
$rs[0]['status_id'] = $rs[0]['Statuses']['status_id'];
// Domains NicHandles
$rs[0]['owner'] = DomainsNichandle::getProfile($id);
$rs[0]['admin'] = DomainsNichandle::getProfile($id, "admin");
$rs[0]['tech'] = DomainsNichandle::getProfile($id, "tech");
$rs[0]['billing'] = DomainsNichandle::getProfile($id, "billing");
$form->populate($rs[0]);
if (!empty($rs[0]['DomainsTlds']['WhoisServers'])) {
$this->view->title = $rs[0]['domain'] . "." . $rs[0]['DomainsTlds']['WhoisServers']['tld'];
$this->view->titlelink = "http://" . $rs[0]['domain'] . "." . $rs[0]['DomainsTlds']['WhoisServers']['tld'];
$this->view->icon = "fa fa-globe";
}
$this->view->owner_datagrid = domains::ownerGrid($id);
$this->view->actions = Registrars::getActions($rs[0]['registrars_id']);
}
} catch (Exception $e) {
die($e->getMessage());
}
$this->view->id = $id;
// Get all the messages attached to the domain
$this->view->messages = Messages::getbyDomainId($id);
}
$this->view->mex = $this->getRequest()->getParam('mex');
$this->view->mexstatus = $this->getRequest()->getParam('status');
$this->view->dns_datagrid = Domains::dnsGrid();
$this->view->form = $form;
$this->view->services_datagrid = array('records' => domains::Services($id), 'edit' => array('controller' => 'services', 'action' => 'edit'));
$this->view->orders_datagrid = array('records' => domains::Orders($id), 'edit' => array('controller' => 'orders', 'action' => 'edit'));
$this->render('applicantform');
}
