/** * Search a domain within the customer list * * * @return string */ public function searchdomainAction() { $translator = Shineisp_Registry::getInstance()->Zend_Translate; $request = $this->getRequest(); $NS = new Zend_Session_Namespace('Default'); if (empty($NS->customer)) { die; } $q = $request->getParam('q'); $customer = $NS->customer; $q = strtolower($q); if (!$q) { return; } $domains = Domains::findbyUserId($customer['customer_id'], "domain_id, CONCAT(domain, '.', tld) as domain"); foreach ($domains as $domain) { if (strpos(strtolower($domain['domain']), $q) !== false) { echo $domain['domain_id'] . "|" . strtoupper($domain['domain']) . "|\n"; } } die; }
private function domainsGrid() { $request = Zend_Controller_Front::getInstance()->getRequest(); if (isset($request->id) && is_numeric($request->id)) { $rs = Domains::findbyUserId($request->id, "d.domain_id, CONCAT(d.domain,'.', ws.tld) as domain, DATE_FORMAT(d.creation_date, '%d/%m/%Y') as creation_date, DATE_FORMAT(d.expiring_date, '%d/%m/%Y') as expiring_date"); if (isset($rs[0])) { $columns[] = $this->translator->translate('Domain'); $columns[] = $this->translator->translate('Creation Date'); $columns[] = $this->translator->translate('Expiry Date'); return array('name' => 'domains', 'columns' => $columns, 'records' => $rs, 'edit' => array('controller' => 'domains', 'action' => 'edit'), 'pager' => true); } } }