public function initForm()
{
$form = new SimpleForm\Form(array('name' => 'registration', 'action' => '', 'method' => 'post'));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'firstname', 'label' => _('TXT_FIRSTNAME'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_FIRSTNAME'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'surname', 'label' => _('TXT_SURNAME'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_SURNAME'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'phone', 'label' => _('TXT_PHONE'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_PHONE'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'email', 'label' => _('TXT_EMAIL'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_EMAIL')), new SimpleForm\Rules\Email(_('ERR_WRONG_EMAIL'))))));
$newPassword = $form->AddChild(new SimpleForm\Elements\Password(array('name' => 'password', 'label' => _('TXT_PASSWORD'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_PASSWORD')), new SimpleForm\Rules\MinLength(_('ERR_PASSWORD_NEW_INVALID'), 6)))));
$form->AddChild(new SimpleForm\Elements\Password(array('name' => 'confirmpassword', 'label' => _('TXT_PASSWORD_REPEAT'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_CONFIRM_PASSWORD')), new SimpleForm\Rules\Compare(_('ERR_PASSWORDS_NOT_COMPATIBILE'), $newPassword)))));
$form->AddChild(new SimpleForm\Elements\Checkbox(array('name' => 'confirmterms', 'label' => sprintf(_('TXT_ACCEPT_TERMS_AND_POLICY_OF_PRIVATE'), App::getModel('staticcontent')->getConditionsLink(), Session::getActiveShopName()), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_TERMS_NOT_AGREED'))), 'default' => 0)));
$form->AddChild(new SimpleForm\Elements\Checkbox(array('name' => 'newsletter', 'label' => _('TXT_NEWSLETTER_SIGNUP'), 'default' => 0)));
return $form;
}
public function index()
{
// limit available delivery countries
$dispatchmethod = Session::getActiveDispatchmethodChecked();
// list of country ids which are specified for selected delivery method
$countryids = App::getModel('delivery')->getDispatchmethodCountries($dispatchmethod['dispatchmethodid']);
$clientorder = App::getModel('finalization')->setClientOrder();
if (empty($clientorder['cart'])) {
App::redirectUrl($this->registry->router->generate('frontend.cart', true));
}
if (Session::getActiveClientid() == NULL) {
$formLogin = App::getFormModel('clientlogin')->initForm();
if ($formLogin->Validate()) {
$formLoginData = $formLogin->getSubmitValues();
$result = App::getModel('clientlogin')->authProccess($formLoginData['login'], $formLoginData['password']);
if ($result > 0) {
Session::setActiveClientid($result);
App::getModel('clientlogin')->checkClientGroup();
App::getModel('clientlogin')->setLoginTime();
$this->clientModel->saveClientData();
$misingCart = App::getModel('missingcart')->checkMissingCartForClient(Session::getActiveClientid());
if (is_array($misingCart) && $misingCart != 0) {
App::getModel('cart')->addProductsToCartFromMissingCart($misingCart);
App::getModel('missingcart')->cleanMissingCart(Session::getActiveClientid());
}
if (($this->Cart = Session::getActiveCart()) != NULL) {
App::redirectUrl($this->registry->router->generate('frontend.checkout', true));
} else {
App::redirectUrl($this->registry->router->generate('frontend.home', true));
}
} elseif ($result < 0) {
Session::setVolatileUserLoginError(2, false);
} else {
Session::setVolatileUserLoginError(1, false);
}
}
$error = Session::getVolatileUserLoginError();
if ($error[0] == 1) {
$this->registry->template->assign('loginerror', _('ERR_BAD_LOGIN_OR_PASSWORD'));
} elseif ($error[0] == 2) {
$this->registry->template->assign('loginerror', _('TXT_BLOKED_USER'));
}
$this->registry->template->assign('formLogin', $formLogin->getForm());
}
$form = new SimpleForm\Form(array('name' => 'order', 'action' => '', 'method' => 'post'));
$billingClientType = $form->AddChild(new SimpleForm\Elements\Radio(array('name' => 'billing_clienttype', 'label' => _('TXT_CLIENT_TYPE'), 'options' => array('1' => _('TXT_INDIVIDUAL_CLIENT'), '2' => _('TXT_COMPANY_CLIENT')))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_firstname', 'label' => _('TXT_FIRSTNAME'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_FIRSTNAME'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_surname', 'label' => _('TXT_SURNAME'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_SURNAME'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_companyname', 'label' => _('TXT_COMPANYNAME'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_COMPANYNAME'), $billingClientType, new SimpleForm\Conditions\Equals('2'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_nip', 'label' => _('TXT_NIP'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_NIP'), $billingClientType, new SimpleForm\Conditions\Equals('2'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_street', 'label' => _('TXT_STREET'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_STREET'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_streetno', 'label' => _('TXT_STREETNO'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_STREETNO'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_placeno', 'label' => _('TXT_PLACENO'))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_placename', 'label' => _('TXT_PLACE'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_PLACE'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'billing_postcode', 'label' => _('TXT_POSTCODE'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_POSTCODE'))))));
$form->AddChild(new SimpleForm\Elements\Select(array('name' => 'billing_country', 'label' => _('TXT_NAME_OF_COUNTRY'), 'options' => App::getModel('lists')->getCountryForSelect($countryids), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_NAME_OF_COUNTRY'))))));
$otherAddress = $form->AddChild(new SimpleForm\Elements\Checkbox(array('name' => 'other_address', 'label' => _('TXT_OTHER_DELIVERY_ADRESS'), 'default' => 0)));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_firstname', 'label' => _('TXT_FIRSTNAME'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_FIRSTNAME'), $otherAddress, new SimpleForm\Conditions\Equals('1'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_surname', 'label' => _('TXT_SURNAME'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_SURNAME'), $otherAddress, new SimpleForm\Conditions\Equals('1'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_companyname', 'label' => _('TXT_COMPANYNAME'))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_street', 'label' => _('TXT_STREET'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_STREET'), $otherAddress, new SimpleForm\Conditions\Equals('0'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_streetno', 'label' => _('TXT_STREETNO'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_STREETNO'), $otherAddress, new SimpleForm\Conditions\Equals('0'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_placeno', 'label' => _('TXT_PLACENO'))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_placename', 'label' => _('TXT_PLACE'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_PLACE'), $otherAddress, new SimpleForm\Conditions\Equals('0'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'shipping_postcode', 'label' => _('TXT_POSTCODE'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_POSTCODE'), $otherAddress, new SimpleForm\Conditions\Equals('0'))))));
$form->AddChild(new SimpleForm\Elements\Select(array('name' => 'shipping_country', 'label' => _('TXT_NAME_OF_COUNTRY'), 'options' => App::getModel('lists')->getCountryForSelect($countryids), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_NAME_OF_COUNTRY'), $otherAddress, new SimpleForm\Conditions\Equals('0'))))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'phone', 'label' => _('TXT_PHONE'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_PHONE')), new SimpleForm\Rules\Format(_('ERR_WRONG_FORMAT'), '/^[0-9 -+]+$/')))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'phone2', 'label' => _('TXT_ADDITIONAL_PHONE'), 'rules' => array(new SimpleForm\Rules\Format(_('ERR_WRONG_FORMAT'), '/^[0-9 -+]+$/')))));
$form->AddChild(new SimpleForm\Elements\TextField(array('name' => 'email', 'label' => _('TXT_EMAIL'), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_EMPTY_EMAIL')), new SimpleForm\Rules\Email(_('ERR_WRONG_EMAIL'))))));
if ((int) Session::getActiveClientid() == 0) {
$createAccount = $form->AddChild(new SimpleForm\Elements\Checkbox(array('name' => 'create_account', 'label' => _('TXT_CHECKOUT_CREATE_ACCOUNT'), 'default' => 1)));
$newPassword = $form->AddChild(new SimpleForm\Elements\Password(array('name' => 'password', 'label' => _('TXT_PASSWORD'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_PASSWORD'), $createAccount, new SimpleForm\Conditions\Equals('1'))))));
$form->AddChild(new SimpleForm\Elements\Password(array('name' => 'confirmpassword', 'label' => _('TXT_PASSWORD_REPEAT'), 'rules' => array(new SimpleForm\Rules\RequiredDependency(_('ERR_EMPTY_CONFIRM_PASSWORD'), $createAccount, new SimpleForm\Conditions\Equals('1')), new SimpleForm\Rules\Compare(_('ERR_PASSWORDS_NOT_COMPATIBILE'), $newPassword)))));
$form->AddChild(new SimpleForm\Elements\Checkbox(array('name' => 'confirmterms', 'label' => sprintf(_('TXT_ACCEPT_TERMS_AND_POLICY_OF_PRIVATE'), App::getModel('staticcontent')->getConditionsLink(), Session::getActiveShopName()), 'rules' => array(new SimpleForm\Rules\Required(_('ERR_TERMS_NOT_AGREED'))), 'default' => 0)));
$form->AddChild(new SimpleForm\Elements\Checkbox(array('name' => 'newsletter', 'label' => _('TXT_NEWSLETTER_SIGNUP'), 'default' => 0)));
}
$clientData = $this->clientModel->getClient();
$clientBillingAddress = $this->clientModel->getClientAddress(1);
$clientShippingAddress = $this->clientModel->getClientAddress(0);
$form->Populate(array('billing_clienttype' => $clientBillingAddress['clienttype'], 'other_address' => 0, 'create_account' => 1, 'phone' => isset($clientData['phone']) ? $clientData['phone'] : '', 'phone2' => isset($clientData['phone2']) ? $clientData['phone2'] : '', 'email' => isset($clientData['email']) ? $clientData['email'] : '', 'billing_firstname' => $clientBillingAddress['firstname'], 'billing_surname' => $clientBillingAddress['surname'], 'billing_companyname' => $clientBillingAddress['companyname'], 'billing_nip' => $clientBillingAddress['nip'], 'billing_street' => $clientBillingAddress['street'], 'billing_streetno' => $clientBillingAddress['streetno'], 'billing_placeno' => $clientBillingAddress['placeno'], 'billing_placename' => $clientBillingAddress['placename'], 'billing_postcode' => $clientBillingAddress['postcode'], 'billing_country' => $clientBillingAddress['countryid'], 'shipping_firstname' => $clientShippingAddress['firstname'], 'shipping_surname' => $clientShippingAddress['surname'], 'shipping_companyname' => $clientShippingAddress['companyname'], 'shipping_nip' => $clientShippingAddress['nip'], 'shipping_street' => $clientShippingAddress['street'], 'shipping_streetno' => $clientShippingAddress['streetno'], 'shipping_placeno' => $clientShippingAddress['placeno'], 'shipping_placename' => $clientShippingAddress['placename'], 'shipping_postcode' => $clientShippingAddress['postcode'], 'shipping_country' => $clientShippingAddress['countryid']));
if ($form->Validate()) {
$formData = $form->getSubmitValues();
$Data['clientaddress'] = array('firstname' => $formData['billing_firstname'], 'surname' => $formData['billing_surname'], 'companyname' => $formData['billing_clienttype'] == 2 ? $formData['billing_companyname'] : '', 'nip' => $formData['billing_clienttype'] == 2 ? $formData['billing_nip'] : '', 'street' => $formData['billing_street'], 'streetno' => $formData['billing_streetno'], 'placeno' => $formData['billing_placeno'], 'placename' => $formData['billing_placename'], 'postcode' => $formData['billing_postcode'], 'countryid' => $formData['billing_country'], 'clienttype' => $formData['billing_clienttype']);
if (!empty($formData['other_address'])) {
$Data['deliveryAddress'] = array('firstname' => $formData['shipping_firstname'], 'surname' => $formData['shipping_surname'], 'companyname' => $formData['shipping_companyname'], 'street' => $formData['shipping_street'], 'streetno' => $formData['shipping_streetno'], 'placeno' => $formData['shipping_placeno'], 'placename' => $formData['shipping_placename'], 'postcode' => $formData['shipping_postcode'], 'countryid' => $formData['shipping_country']);
} else {
$Data['deliveryAddress'] = $Data['clientaddress'];
}
$recurMail = 0;
if (!empty($formData['create_account'])) {
$recurMail = $this->clientModel->checkClientNewMail($formData);
if ($recurMail == 0) {
$clientData = $Data['clientaddress'];
$clientData['email'] = $formData['email'];
$clientData['password'] = $formData['password'];
$clientData['newsletter'] = $formData['newsletter'];
$clientData['phone'] = $formData['phone'];
$clientData['phone2'] = $formData['phone2'];
$clientId = $this->clientModel->addNewClient($clientData);
$result = App::getModel('clientlogin')->authProccess($formData['email'], $formData['password']);
if ($result > 0) {
Session::setActiveClientid($result);
App::getModel('clientlogin')->checkClientGroup();
$this->clientModel->saveClientData();
$this->clientModel->updateClientAddress($Data['clientaddress'], 1);
$this->clientModel->updateClientAddress($Data['deliveryAddress'], 0);
}
} else {
$result = App::getModel('clientlogin')->authProccess($formData['email'], $formData['password']);
if ($result > 0) {
Session::setActiveClientid($result);
App::getModel('clientlogin')->checkClientGroup();
App::getModel('clientlogin')->setLoginTime();
App::getModel('client')->saveClientData();
$misingCart = App::getModel('missingcart')->checkMissingCartForClient($result);
if (is_array($misingCart) && !empty($misingCart)) {
App::getModel('cart')->addProductsToCartFromMissingCart($misingCart);
App::getModel('missingcart')->cleanMissingCart(Session::getActiveClientid());
}
$recurMail = 0;
} else {
$recurMail = -1;
}
}
} else {
if (!empty($formData['newsletter'])) {
$newId = App::getModel('newsletter')->addClientAboutNewsletter($formData['email']);
if ($newId > 0) {
App::getModel('newsletter')->changeNewsletterStatus($newId);
}
}
}
if ((int) Session::getActiveClientid() > 0) {
$this->clientModel->updateClientAddress($Data['clientaddress'], 1);
$this->clientModel->updateClientAddress($Data['deliveryAddress'], 0);
}
if ($recurMail == -1) {
$this->registry->template->assign('error', 'Podany adres e-mail jest już przypisany do innego konta użytkownika. Proszę skorzystaj z opcji <a href="' . $this->registry->router->generate('frontend.forgotpassword', true) . '" style="font-size: inherit">przypomnienia hasła</a> jeśli chcesz odzyskać dostęp do konta.');
} else {
if ($recurMail == 1) {
$this->registry->template->assign('error', _('ERR_DUPLICATE_EMAIL'));
} else {
if (!$recurMail) {
Session::setActiveOrderClientAddress($Data['clientaddress']);
Session::setActiveOrderDeliveryAddress($Data['deliveryAddress']);
Session::setActiveOrderContactData(array('phone' => $formData['phone'], 'phone2' => $formData['phone2'], 'email' => $formData['email']));
App::getModel('finalization')->setClientOrder();
App::redirectUrl($this->registry->router->generate('frontend.finalization', true));
}
}
}
}
$assignData = array('form' => $form->getForm());
foreach ($assignData as $key => $assign) {
$this->registry->template->assign($key, $assign);
}
if (Session::getActiveClientid() > 0) {
return $this->registry->template->fetch($this->loadTemplate('client.tpl'));
} else {
return $this->registry->template->fetch($this->loadTemplate('guest.tpl'));
}
}
public function setStaticTemplateVariables()
{
if ($this->registry->router->getAdministrativeMode() == 0) {
$link = $this->_adminPane = '';
} else {
$link = $this->_adminPane = __ADMINPANE__ . '/';
}
$languageModel = App::getModel('language');
$languages = $languageModel->getLanguages();
$this->layer = $this->registry->loader->getCurrentLayer();
if (isset($_SERVER['HTTPS']) && strtolower($_SERVER['HTTPS']) == 'on') {
$this->assign('SSLNAME', 'https://');
} else {
$this->assign('SSLNAME', 'http://');
}
$theme = App::getRegistry()->loader->getParam('theme');
$this->assign('URL', App::getURLAdress() . $link);
$this->assign('CURRENT_URL', App::getCurrentURLAdress());
$this->assign('DESIGNPATH', DESIGNPATH);
$this->assign('ASSETSPATH', App::getURLForAssetDirectory() . $theme . '/assets/');
$this->assign('THEMESPATH', App::getURLForAssetDirectory());
$this->assign('CURRENT_CONTROLLER', $this->registry->router->getCurrentController());
$this->assign('CURRENT_ACTION', $this->registry->router->getAction());
$this->assign('CURRENT_PARAM', $this->registry->core->getParam());
$this->assign('SHOP_NAME', Session::getActiveShopName());
$templateData = array();
if ($this->registry->router->getAdministrativeMode() == 0) {
$cartModel = App::getModel('cart');
$client = App::getModel('client')->getClient();
$productCart = $cartModel->getShortCartList();
$productCart = $cartModel->getProductCartPhotos($productCart);
$this->assign('SHOP_LOGO', $this->layer['photoid']);
$this->assign('FAVICON', $this->layer['favicon']);
$this->assign('enableregistration', $this->layer['enableregistration']);
$this->assign('client', $client);
$this->assign('clientdata', $client);
$this->assign('showtax', $this->layer['showtax']);
$this->assign('currencySymbol', Session::getActiveCurrencySymbol());
$this->assign('count', $cartModel->getProductAllCount());
$this->assign('globalPrice', $cartModel->getGlobalPrice());
$this->assign('productCart', $productCart);
$this->assign('language', Session::getActiveLanguageId());
$this->assign('languageCode', Session::getActiveLanguage());
$this->assign('languageFlag', $languageModel->getLanguages());
$this->assign('currencies', $languageModel->getAllCurrenciesForView());
$this->assign('breadcrumb', App::getModel('breadcrumb')->getPageLinks());
$this->assign('contentcategory', App::getModel('staticcontent')->getContentCategoriesTree());
$this->assign('defaultcontact', App::getModel('contact')->getContactById($this->layer['contactid']));
$this->assign('newsletterButton', App::getModel('newsletter')->isNewsletterButton());
$this->assign('cartpreview', $cartModel->getCartPreviewTemplate());
if ($this->layer['cartredirect'] != '') {
$this->assign('cartredirect', App::getURLAdress() . Seo::getSeo($this->layer['cartredirect']));
} else {
$this->assign('cartredirect', '');
}
$this->assign('modulesettings', $this->registry->core->getModuleSettingsForView());
$message = Session::getVolatileMessage();
if (isset($message) && !empty($message)) {
$this->assign('message', $message[0]);
}
$this->assign('categories', App::getModel('CategoriesBox')->getCategoriesTree(2));
$methods = $this->getXajaxMethodsForFrontend();
foreach ($methods as $xajaxMethodName => $xajaxMethodParams) {
$this->registry->xajax->registerFunction(array($xajaxMethodName, App::getModel($xajaxMethodParams['model']), $xajaxMethodParams['method']));
}
$message = Session::getVolatileMessage();
if (isset($message) && !empty($message)) {
$this->assign('message', $message[0]);
}
$this->assign('view', Helper::getViewId());
$this->assign('viewid', Helper::getViewId());
} else {
$this->registry->core->setAdminStoreConfig();
$templateData = array('user_name' => App::getModel('users')->getUserFullName(), 'user_id' => App::getModel('users')->getActiveUserid(), 'language' => Session::getActiveLanguageId(), 'languages' => json_encode($languages), 'globalsettings' => Session::getActiveGlobalSettings(), 'views' => App::getModel('view')->getViews(), 'vatvalues' => json_encode(App::getModel('vat/vat')->getVATValuesAll()), 'FRONTEND_URL' => Session::getActiveShopUrl() != '' ? 'http://' . Session::getActiveShopUrl() : App::getURLAdress(), 'appversion' => Session::getActiveAppVersion(), 'view' => Helper::getViewId(), 'viewid' => Helper::getViewId());
$message = Session::getVolatileMessage();
if (isset($message) && !empty($message)) {
$templateData['message'] = $message[0];
}
$methods = $this->getXajaxMethodsForAdmin();
foreach ($methods as $xajaxMethodName => $xajaxMethodParams) {
$this->registry->xajax->registerFunction(array($xajaxMethodName, App::getModel($xajaxMethodParams['model']), $xajaxMethodParams['method']));
}
$Data = Event::dispatch($this, 'template.setStaticTemplateVariables', array('data' => $templateData));
foreach ($Data as $param => $value) {
$this->assign($param, $value);
}
$this->assign('view', Helper::getViewId());
$this->assign('viewid', Helper::getViewId());
}
}
public function getMetadataForPage()
{
$controller = $this->registry->router->getCurrentController();
$Data = array();
$sql = "SELECT\n\t\t\t\t\tVT.keyword_title,\n\t\t\t\t\tC.description,\n\t\t\t\t\tVT.keyword,\n\t\t\t\t\tVT.keyword_description\n\t\t\t\tFROM controller C\n\t\t\t\tLEFT JOIN viewtranslation VT ON VT.viewid = :viewid\n\t\t\t\tWHERE C.name = :controller AND C.mode = 0";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('controller', $controller);
$stmt->bindValue('viewid', Helper::getViewId());
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
if ($rs['keyword_title'] == NULL || $rs['keyword_title'] == '') {
$keyword_title = $controller == 'mainside' ? Session::getActiveShopName() : _($rs['description']);
} else {
$keyword_title = $rs['keyword_title'];
}
$title = $controller == 'mainside' ? $keyword_title : _($rs['description']);
$Data = array('keyword_title' => $title, 'keyword' => $rs['keyword'], 'keyword_description' => $rs['keyword_description']);
}
return $Data;
}
