public function listAction()
{
$NS = new Zend_Session_Namespace('Default');
$arrSort = array();
$params = array();
$page = $this->getRequest()->getParam('page');
$sort = $this->getRequest()->getParam('sort');
if (!empty($sort)) {
$arrSort[] = $this->SortingData($sort);
$arrSort[] = $sort;
}
$page = !empty($page) && is_numeric($page) ? $page : 1;
$params['search'][] = array('method' => 'andWhere', 'criteria' => "(c.customer_id = ? OR c.parent_id = ?)", 'value' => array($NS->customer['customer_id'], $NS->customer['customer_id']));
// $params['search'][] = array ('method' => 'whereIn', 'criteria' => "o.status_id", 'value' => array(Statuses::id('paid', 'orders'), Statuses::id('complete', 'orders')));
$data = $this->services->findAll("d.order_id, oid.relationship_id, d.description, CONCAT(dm.domain, '.', ws.tld) as domain, s.status as Status, DATE_FORMAT(d.date_start, '" . settings::getMySQLDateFormat() . "') as Creation_Date, DATEDIFF(d.date_end, CURRENT_DATE) as daysleft, DATE_FORMAT(d.date_end, '" . settings::getMySQLDateFormat() . "') as Expiring_Date, d.product_id", $page, $NS->recordsperpage, $arrSort, $params);
$data['currentpage'] = $page;
for ($i = 0; $i < count($data['records']); $i++) {
$data['records'][$i]['description'] = Shineisp_Commons_Utilities::truncate($data['records'][$i]['description'], 40);
$data['records'][$i]['daysleft'] = $data['records'][$i]['daysleft'] < 30 ? "<span class='label label-danger'>" . $data['records'][$i]['daysleft'] . "</span>" : "<span class='label label-success'>" . $data['records'][$i]['daysleft'] . "</span>";
}
$data['columns'][] = $this->translator->translate('Description');
$data['columns'][] = $this->translator->translate('Domain');
$data['columns'][] = $this->translator->translate('Status');
$data['columns'][] = $this->translator->translate('Creation Date');
$data['columns'][] = $this->translator->translate('Days left');
$data['columns'][] = $this->translator->translate('Expiry Date');
$this->view->mex = $this->getRequest()->getParam('mex');
$this->view->mexstatus = $this->getRequest()->getParam('status');
$this->view->title = $this->translator->translate("Services List");
$this->view->description = $this->translator->translate("List of all your own services subscribed");
$this->view->service = $data;
}
public function listAction()
{
$ns = new Zend_Session_Namespace();
$products = array();
// get the category uri
$uri = $this->getRequest()->getParam('q');
if (!empty($uri)) {
// Save the path of the user
$ns->lastcategory = $uri;
// Get the category information
$category = $this->categories->getAllInfobyURI($uri);
if (!empty($category[0])) {
$this->view->category = $category[0];
// Get the subcategories
$this->view->subcategory = ProductsCategories::getbyParentId($category[0]['category_id'], 1, true);
// Set the Metatag information
$this->view->headTitle()->prepend($category[0]['name']);
if (!empty($category[0]['keywords'])) {
$this->view->headMeta()->setName('keywords', $category[0]['keywords']);
}
if (!empty($category[0]['description'])) {
$this->view->headMeta()->setName('description', $category[0]['description'] ? Shineisp_Commons_Utilities::truncate(strip_tags($category[0]['description'])) : '-');
}
$this->view->headertitle = $category[0]['name'];
// Get the products information
$fields = "pd.productdata_id as productdata_id, \n\t\t\t\t pd.name as name, \n\t\t\t\t pd.shortdescription as shortdescription, \n\t\t\t\t pd.metakeywords as metakeywords, \n\t\t\t\t pd.metadescription as metadescription, \n\t\t\t\t p.*, pag.code as groupcode";
$data = $this->categories->getProductListbyCatUri($uri, $fields, $ns->langid);
if (!empty($data['records'])) {
// Get the media information for each product
foreach ($data['records'] as $product) {
$product['reviews'] = Reviews::countItems($product['product_id']);
$product['attributes'] = ProductsAttributes::getAttributebyProductID($product['product_id'], $ns->langid, true);
$products[] = $product;
}
$this->view->products = $products;
$this->view->pager = $data['pager'];
}
$this->view->layoutmode = !empty($ns->layoutmode) ? $ns->layoutmode : "list";
$this->_helper->viewRenderer($ns->layoutmode);
} else {
$this->_helper->redirector('index', 'index', 'default');
}
}
}
public function pageAction()
{
$var = $this->getRequest()->getParam('url');
$ns = new Zend_Session_Namespace();
$locale = $ns->lang;
if (!empty($var)) {
$page = CmsPages::findbyvar($var, $locale);
if ($page['active'] == false) {
return $this->_helper->redirector('index', 'index', 'default');
}
// Set the Metatag information
$this->view->headTitle(" | " . $page['title']);
if (!empty($page['keywords'])) {
$this->view->headMeta()->setName('keywords', $page['keywords']);
}
if (!empty($page['body'])) {
$this->view->headMeta()->setName('description', $page['body'] ? Shineisp_Commons_Utilities::truncate(strip_tags($page['body'])) : '-');
}
$this->view->headertitle = $page['title'];
// Set the page content
$this->view->data = $page;
// Set the subheader
$this->view->headerdata = $this->CreateSubHeader($page);
}
if (!empty($page['xmllayout'])) {
Shineisp_Commons_Layout::updateLayout($this->view, $page['xmllayout']);
}
if (!empty($page['pagelayout'])) {
$this->getHelper('layout')->setLayout("cms/" . $page['pagelayout']);
}
if (!empty($page['layout'])) {
return $this->_helper->viewRenderer($page['layout']);
} else {
return $this->_helper->viewRenderer('1column');
}
}
/**
* List of the last messages attached within the orders, domains, customers detail page
*
*
* @param string $attachedto [orders, domains]
* @param integer $limit
* @return ArrayObject
*/
public static function Last($attachedto = "orders", $limit = 5, $delIspReplies = true)
{
$translator = Shineisp_Registry::getInstance()->Zend_Translate;
$dq = Doctrine_Query::create()->from('Messages m');
// Adding first the main ID index field
if ($attachedto == "orders") {
$dq->select("order_id as id");
$dq->where("order_id IS NOT NULL");
} elseif ($attachedto == "domains") {
$dq->select("domain_id as id");
$dq->where("domain_id IS NOT NULL");
}
// now we can add more fields
$dq->addSelect("DATE_FORMAT(m.dateposted, '" . Settings::getMySQLDateFormat('dateformat') . " %H:%i:%s') as date, m.message as message");
if ($delIspReplies) {
$dq->andWhere("customer_id IS NOT NULL");
}
// Sort the items
$dq->orderBy('m.dateposted desc')->limit($limit);
$records['data'] = $dq->execute(null, Doctrine::HYDRATE_ARRAY);
// Strip the html and trucate the message
for ($i = 0; $i < count($records['data']); $i++) {
$records['data'][$i]['message'] = Shineisp_Commons_Utilities::truncate(strip_tags($records['data'][$i]['message']), 50, "...", false, true);
}
// adding the index reference
$records['index'] = "id";
// Create the header table columns
$records['fields'] = array('date' => array('label' => $translator->translate('Date')), 'message' => array('label' => $translator->translate('Message')));
return $records;
}
/**
* Create the tld list
*/
private function createTldMenu()
{
$ns = new Zend_Session_Namespace();
$items = DomainsTlds::getHighlighted($ns->langid);
$currency = Shineisp_Registry::get('Zend_Currency');
$html = "";
if (!empty($items)) {
$html = "<li class=\"dropdown\">";
$html .= '<a class="dropdown-toggle" data-toggle="dropdown" href="#">' . $this->translator->translate('Domains') . '</a>';
$html .= "<ul class=\"dropdown-menu\">";
foreach ($items as $item) {
if (!empty($item['DomainsTldsData'][0]['name'])) {
$item['registration_price'] = $currency->toCurrency($item['registration_price'], array('currency' => Settings::findbyParam('currency')));
$html .= '<li class="dropdown"><a title="' . Shineisp_Commons_Utilities::truncate(strip_tags($item['DomainsTldsData'][0]['description']), 150, "...", false, true) . '" href="/tlds/' . $item['DomainsTldsData'][0]['name'] . '.html">.<b>' . strtoupper($item['DomainsTldsData'][0]['name']) . "</b> - " . $item['registration_price'] . " (" . $this->translator->translate('Tax excluded') . ")</a></li>";
}
}
$html .= "</ul>";
$html .= "</li>";
}
return $html;
}
/**
* Prepare the newsletter content
*/
private static function fill_content()
{
$ns = new Zend_Session_Namespace();
$contents = array();
// Get all the products
$contents['products'] = "<ul>";
$records = Products::getAllHighlighted($ns->idlang);
foreach ($records as $record) {
$contents['products'] .= "<b><a href='http://" . $_SERVER['HTTP_HOST'] . "/" . $record['uri'] . ".html'>" . $record['ProductsData'][0]['name'] . "</a></b><p>" . $record['ProductsData'][0]['shortdescription'] . "</p>";
}
$contents['products'] .= "</ul>";
// Get all the cms pages
$contents['pages'] = "";
$records = CmsPages::getRssPages($ns->lang);
foreach ($records as $record) {
$link = 'http://' . $_SERVER['HTTP_HOST'] . '/cms/' . $record['var'] . '.html';
$contents['pages'] .= "<p><b><a href='" . $link . "'>" . $record['title'] . "</a></b></p>";
$contents['pages'] .= Shineisp_Commons_Utilities::truncate($record['body'], 200, "...", false, true);
}
$contents['pages'] = str_replace("src=\"/", "src=\"http://" . $_SERVER['HTTP_HOST'] . "/", $contents['pages']);
return $contents;
}
/**
* getListbyCustomerId
* Get a list ready for the html select object
* @return array
*/
public static function getListbyCustomerId($customer_id, $empty = false, $abbreviation = false)
{
$items = array();
$translations = Shineisp_Registry::getInstance()->Zend_Translate;
$records = Doctrine_Query::create()->select("ticket_id, DATE_FORMAT(date_open, '" . Settings::getMySQLDateFormat('dateformat') . "') as date_open, subject, s.status as status")->from('Tickets t')->leftJoin('t.Statuses s')->leftJoin('t.Customers c')->where('t.customer_id = ?', $customer_id)->addWhere("c.isp_id = ?", Isp::getCurrentId())->execute(array(), Doctrine_Core::HYDRATE_ARRAY);
if ($empty) {
$items[] = $translations->translate('Select ...');
}
foreach ($records as $c) {
if ($abbreviation) {
$subject = Shineisp_Commons_Utilities::truncate($c['subject'], 25);
} else {
$subject = $c['subject'];
}
$items[$c['ticket_id']] = $c['ticket_id'] . " - " . $c['status'] . " - " . $subject;
}
return $items;
}
