public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $sql_query = 'select l.*, (select count(*) from :table_languages_definitions ld where ld.languages_id = l.languages_id) as total_definitions from :table_languages l where'; if ( is_numeric($data['id']) ) { $sql_query .= ' l.languages_id = :languages_id'; } else { $sql_query .= ' l.code = :code'; } $sql_query .= ' limit 1'; $Qlanguage = $OSCOM_PDO->prepare($sql_query); if ( is_numeric($data['id']) ) { $Qlanguage->bindInt(':languages_id', $data['id']); } else { $Qlanguage->bindValue(':code', $data['id']); } $Qlanguage->execute(); return $Qlanguage->fetch(); }
public static function execute(ApplicationAbstract $application) { $OSCOM_Shipping = Registry::get('Shipping'); $OSCOM_ShoppingCart = Registry::get('ShoppingCart'); if (!empty($_POST['comments'])) { $_SESSION['comments'] = HTML::sanitize($_POST['comments']); } if ($OSCOM_Shipping->hasQuotes()) { if (isset($_POST['shipping_mod_sel']) && strpos($_POST['shipping_mod_sel'], '_')) { list($module, $method) = explode('_', $_POST['shipping_mod_sel']); if (Registry::exists('Shipping_' . $module) && Registry::get('Shipping_' . $module)->isEnabled()) { $quote = $OSCOM_Shipping->getQuote($_POST['shipping_mod_sel']); if (isset($quote['error'])) { $OSCOM_ShoppingCart->resetShippingMethod(); } else { $OSCOM_ShoppingCart->setShippingMethod($quote); OSCOM::redirect(OSCOM::getLink(null, null, null, 'SSL')); } } else { $OSCOM_ShoppingCart->resetShippingMethod(); } } } else { $OSCOM_ShoppingCart->resetShippingMethod(); OSCOM::redirect(OSCOM::getLink(null, null, null, 'SSL')); } }
public static function execute(ApplicationAbstract $application) { $OSCOM_Database = Registry::get('Database'); $OSCOM_MessageStack = Registry::get('MessageStack'); $Qcheck = $OSCOM_Database->query('select customers_id, customers_firstname, customers_lastname, customers_gender, customers_email_address, customers_password from :table_customers where customers_email_address = :customers_email_address limit 1'); $Qcheck->bindValue(':customers_email_address', $_POST['email_address']); $Qcheck->execute(); if ($Qcheck->numberOfRows() === 1) { $password = osc_create_random_string(ACCOUNT_PASSWORD); if (Account::savePassword($password, $Qcheck->valueInt('customers_id'))) { if (ACCOUNT_GENDER > -1) { if ($Qcheck->value('customers_gender') == 'm') { $email_text = sprintf(OSCOM::getDef('email_addressing_gender_male'), $Qcheck->valueProtected('customers_lastname')) . "\n\n"; } else { $email_text = sprintf(OSCOM::getDef('email_addressing_gender_female'), $Qcheck->valueProtected('customers_lastname')) . "\n\n"; } } else { $email_text = sprintf(OSCOM::getDef('email_addressing_gender_unknown'), $Qcheck->valueProtected('customers_firstname') . ' ' . $Qcheck->valueProtected('customers_lastname')) . "\n\n"; } $email_text .= sprintf(OSCOM::getDef('email_password_reminder_body'), osc_get_ip_address(), STORE_NAME, $password, STORE_OWNER_EMAIL_ADDRESS); osc_email($Qcheck->valueProtected('customers_firstname') . ' ' . $Qcheck->valueProtected('customers_lastname'), $Qcheck->valueProtected('customers_email_address'), sprintf(OSCOM::getDef('email_password_reminder_subject'), STORE_NAME), $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $OSCOM_MessageStack->add('LogIn', OSCOM::getDef('success_password_forgotten_sent'), 'success'); } osc_redirect(OSCOM::getLink(null, null, 'LogIn', 'SSL')); } else { $OSCOM_MessageStack->add('PasswordForgotten', OSCOM::getDef('error_password_forgotten_no_email_address_found')); } }
public function install() { $OSCOM_Database = Registry::get('Database'); parent::install(); $OSCOM_Database->simpleQuery("insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Maximum Entries To Display', 'MODULE_CONTENT_UPCOMING_PRODUCTS_MAX_DISPLAY', '10', 'Maximum number of upcoming products to display', '6', '0', now())"); $OSCOM_Database->simpleQuery("insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'MODULE_CONTENT_UPCOMING_PRODUCTS_CACHE', '1440', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())"); }
public static function execute($data) { $OSCOM_Database = Registry::get('PDO'); $OSCOM_Database->beginTransaction(); $Qlanguage = $OSCOM_Database->prepare('update :table_languages set name = :name, code = :code, locale = :locale, charset = :charset, date_format_short = :date_format_short, date_format_long = :date_format_long, time_format = :time_format, text_direction = :text_direction, currencies_id = :currencies_id, numeric_separator_decimal = :numeric_separator_decimal, numeric_separator_thousands = :numeric_separator_thousands, parent_id = :parent_id, sort_order = :sort_order where languages_id = :languages_id'); $Qlanguage->bindValue(':name', $data['name']); $Qlanguage->bindValue(':code', $data['code']); $Qlanguage->bindValue(':locale', $data['locale']); $Qlanguage->bindValue(':charset', $data['charset']); $Qlanguage->bindValue(':date_format_short', $data['date_format_short']); $Qlanguage->bindValue(':date_format_long', $data['date_format_long']); $Qlanguage->bindValue(':time_format', $data['time_format']); $Qlanguage->bindValue(':text_direction', $data['text_direction']); $Qlanguage->bindInt(':currencies_id', $data['currencies_id']); $Qlanguage->bindValue(':numeric_separator_decimal', $data['numeric_separator_decimal']); $Qlanguage->bindValue(':numeric_separator_thousands', $data['numeric_separator_thousands']); $Qlanguage->bindInt(':parent_id', $data['parent_id']); $Qlanguage->bindInt(':sort_order', $data['sort_order']); $Qlanguage->bindInt(':languages_id', $data['id']); $Qlanguage->execute(); if (!$Qlanguage->isError()) { if ($data['set_default'] === true) { $Qupdate = $OSCOM_Database->prepare('update :table_configuration set configuration_value = :configuration_value where configuration_key = :configuration_key'); $Qupdate->bindValue(':configuration_value', $data['code']); $Qupdate->bindValue(':configuration_key', 'DEFAULT_LANGUAGE'); $Qupdate->execute(); } $OSCOM_Database->commit(); return true; } $OSCOM_Database->rollBack(); return false; }
public static function execute($data) { $OSCOM_Database = Registry::get('PDO'); $result = array(); $sql_query = 'select SQL_CALC_FOUND_ROWS c.*, count(z.zone_id) as total_zones from :table_countries c left join :table_zones z on (c.countries_id = z.zone_country_id) where (c.countries_name like :countries_name or c.countries_iso_code_2 like :countries_iso_code_2 or c.countries_iso_code_3 like :countries_iso_code_3 or z.zone_name like :zone_name or z.zone_code like :zone_code) group by c.countries_id order by c.countries_name'; if ($data['batch_pageset'] !== -1) { $sql_query .= ' limit :batch_pageset, :batch_max_results'; } $sql_query .= '; select found_rows();'; $Qcountries = $OSCOM_Database->prepare($sql_query); $Qcountries->bindValue(':countries_name', '%' . $data['keywords'] . '%'); $Qcountries->bindValue(':countries_iso_code_2', '%' . $data['keywords'] . '%'); $Qcountries->bindValue(':countries_iso_code_3', '%' . $data['keywords'] . '%'); $Qcountries->bindValue(':zone_name', '%' . $data['keywords'] . '%'); $Qcountries->bindValue(':zone_code', '%' . $data['keywords'] . '%'); if ($data['batch_pageset'] !== -1) { $Qcountries->bindInt(':batch_pageset', $OSCOM_Database->getBatchFrom($data['batch_pageset'], $data['batch_max_results'])); $Qcountries->bindInt(':batch_max_results', $data['batch_max_results']); } $Qcountries->execute(); $result['entries'] = $Qcountries->fetchAll(); $Qcountries->nextRowset(); $result['total'] = $Qcountries->fetchColumn(); return $result; }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $result = array(); $sql_query = 'select * from :table_customers where '; if ( isset($data['email_address']) ) { $sql_query .= 'customers_email_address = :customers_email_address'; } else { $sql_query .= 'customers_id = :customers_id'; } $Qcustomer = $OSCOM_PDO->prepare($sql_query); if ( isset($data['email_address']) ) { $Qcustomer->bindValue(':customers_email_address', $data['email_address']); } else { $Qcustomer->bindInt(':customers_id', $data['id']); } $Qcustomer->execute(); if ( $Qcustomer->fetch() !== false ) { $result = $Qcustomer->toArray(); $result['customers_name'] = $result['customers_firstname'] . ' ' . $result['customers_lastname']; } return $result; }
public static function start() { $OSCOM_Service = Registry::get('Service'); Registry::set('RecentlyVisited', new RecentlyVisitedClass()); $OSCOM_Service->addCallBeforePageContent('RecentlyVisited', 'initialize'); return true; }
public static function execute() { $OSCOM_PDO = Registry::get('PDO'); $result = $OSCOM_PDO->query('show server_version')->fetch(); return 'PostgreSQL v' . $result['server_version']; }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $sql_query = 'select * from :table_currencies where'; if ( is_numeric($data['id']) ) { $sql_query .= ' currencies_id = :currencies_id'; } else { $sql_query .= ' code = :code'; } $sql_query .= ' limit 1'; $Qcurrency = $OSCOM_PDO->prepare($sql_query); if ( is_numeric($data['id']) ) { $Qcurrency->bindInt(':currencies_id', $data['id']); } else { $Qcurrency->bindValue(':code', $data['id']); } $Qcurrency->execute(); return $Qcurrency->fetch(); }
public function initialize() { $OSCOM_Product = Registry::exists('Product') ? Registry::get('Product') : null; $OSCOM_PDO = Registry::get('PDO'); $OSCOM_Language = Registry::get('Language'); if (isset($OSCOM_Product) && $OSCOM_Product instanceof \osCommerce\OM\Site\Shop\Product && $OSCOM_Product->isValid()) { $Qmanufacturer = $OSCOM_PDO->query('select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from :table_manufacturers m left join :table_manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id), :table_products p where p.products_id = :products_id and p.manufacturers_id = m.manufacturers_id'); $Qmanufacturer->bindInt(':languages_id', $OSCOM_Language->getID()); $Qmanufacturer->bindInt(':products_id', $OSCOM_Product->getID()); $Qmanufacturer->execute(); $result = $Qmanufacturer->fetch(); if (!empty($result)) { $this->_content = ''; if (strlen($result['manufacturers_image']) > 0) { $this->_content .= '<div style="text-align: center;">' . HTML::link(OSCOM::getLink(null, 'Index', 'Manufacturers=' . $result['manufacturers_id']), HTML::image('public/manufacturers/' . $result['manufacturers_image'], $result['manufacturers_name'])) . '</div>'; } $this->_content .= '<ol style="list-style: none; margin: 0; padding: 0;">'; if (strlen($result['manufacturers_url']) > 0) { $this->_content .= '<li>' . HTML::link(OSCOM::getLink(null, 'Redirct', 'Manufacturer=' . $result['manufacturers_id']), sprintf(OSCOM::getDef('box_manufacturer_info_website'), $result['manufacturers_name']), 'target="_blank"') . '</li>'; } $this->_content .= '<li>' . HTML::link(OSCOM::getLink(null, 'Index', 'Manufacturers=' . $result['manufacturers_id']), OSCOM::getDef('box_manufacturer_info_products')) . '</li>'; $this->_content .= '</ol>'; } } }
public function uninstall() { $OSCOM_PDO = Registry::get('PDO'); $error = false; $OSCOM_PDO->beginTransaction(); $Qdelete = $OSCOM_PDO->prepare('delete from :table_product_attributes where id = :id'); $Qdelete->bindInt(':id', $this->getID()); $Qdelete->execute(); if ( $Qdelete->isError() ) { $error = true; } if ( $error === false ) { $Quninstall = $OSCOM_PDO->prepare('delete from :table_templates_boxes where code = :code and modules_group = :modules_group'); $Quninstall->bindValue(':code', $this->getCode()); $Quninstall->bindValue(':modules_group', 'ProductAttribute'); $Quninstall->execute(); if ( $Quninstall->isError() ) { $error = true; } } if ( $error === false ) { $OSCOM_PDO->commit(); } else { $OSCOM_PDO->rollBack(); } return ( $error === false ); }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $result = array(); $sql_query = 'select * from :table_administrators order by user_name'; if ( $data['batch_pageset'] !== -1 ) { $sql_query .= ' limit :batch_max_results offset :batch_pageset'; } $Qadmins = $OSCOM_PDO->prepare($sql_query); if ( $data['batch_pageset'] !== -1 ) { $Qadmins->bindInt(':batch_pageset', $OSCOM_PDO->getBatchFrom($data['batch_pageset'], $data['batch_max_results'])); $Qadmins->bindInt(':batch_max_results', $data['batch_max_results']); } $Qadmins->execute(); $result['entries'] = $Qadmins->fetchAll(); $Qtotal = $OSCOM_PDO->query('select count(*) from :table_administrators'); $Qtotal->execute(); $result['total'] = $Qtotal->fetchColumn(); return $result; }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); if (isset($data['key']) && isset($data['value'])) { $data = array($data); } $error = false; $in_transaction = false; if (count($data) > 1) { $OSCOM_PDO->beginTransaction(); $in_transaction = true; } $Qcfg = $OSCOM_PDO->prepare('update :table_configuration set configuration_value = :configuration_value, last_modified = now() where configuration_key = :configuration_key'); foreach ($data as $d) { $Qcfg->bindValue(':configuration_value', $d['value']); $Qcfg->bindValue(':configuration_key', $d['key']); $Qcfg->execute(); if ($Qcfg->isError()) { if ($in_transaction === true) { $OSCOM_PDO->rollBack(); } $error = true; break; } } if ($error === false && $in_transaction === true) { $OSCOM_PDO->commit(); } return !$error; }
public static function execute($data) { $OSCOM_Database = Registry::get('PDO'); $OSCOM_Database->beginTransaction(); if (is_numeric($data['id'])) { $Qcurrency = $OSCOM_Database->prepare('update :table_currencies set title = :title, code = :code, symbol_left = :symbol_left, symbol_right = :symbol_right, decimal_places = :decimal_places, value = :value where currencies_id = :currencies_id'); $Qcurrency->bindInt(':currencies_id', $data['id']); } else { $Qcurrency = $OSCOM_Database->prepare('insert into :table_currencies (title, code, symbol_left, symbol_right, decimal_places, value) values (:title, :code, :symbol_left, :symbol_right, :decimal_places, :value)'); } $Qcurrency->bindValue(':title', $data['title']); $Qcurrency->bindValue(':code', $data['code']); $Qcurrency->bindValue(':symbol_left', $data['symbol_left']); $Qcurrency->bindValue(':symbol_right', $data['symbol_right']); $Qcurrency->bindInt(':decimal_places', $data['decimal_places']); $Qcurrency->bindValue(':value', $data['value']); $Qcurrency->execute(); if (!$Qcurrency->isError()) { if ($data['set_default'] === true) { $Qupdate = $OSCOM_Database->prepare('update :table_configuration set configuration_value = :configuration_value where configuration_key = :configuration_key'); $Qupdate->bindValue(':configuration_value', $data['code']); $Qupdate->bindValue(':configuration_key', 'DEFAULT_CURRENCY'); $Qupdate->execute(); } $OSCOM_Database->commit(); return true; } $OSCOM_Database->rollBack(); return false; }
public function __construct() { $OSCOM_Language = Registry::get('Language'); $OSCOM_Language->loadIniFile('modules/services/language.php'); $this->title = OSCOM::getDef('services_language_title'); $this->description = OSCOM::getDef('services_language_description'); }
public function install() { $OSCOM_PDO = Registry::get('PDO'); parent::install(); $OSCOM_PDO->exec("insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Random Product Specials Selection', 'BOX_SPECIALS_RANDOM_SELECT', '10', 'Select a random product on special from this amount of the newest products on specials available', '6', '0', now())"); $OSCOM_PDO->exec("insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Cache Contents', 'BOX_SPECIALS_CACHE', '1', 'Number of minutes to keep the contents cached (0 = no cache)', '6', '0', now())"); }
public function initialize() { $OSCOM_ShoppingCart = Registry::get('ShoppingCart'); $OSCOM_Template = Registry::get('Template'); $steps = array(); if ($OSCOM_ShoppingCart->getContentType() != 'virtual') { $steps[] = array('title' => OSCOM::getDef('box_ordering_steps_delivery'), 'code' => 'shipping', 'active' => $OSCOM_Template->getModule() == 'Shipping' || $OSCOM_Template->getModule() == 'ShippingAddress' ? true : false); } $steps[] = array('title' => OSCOM::getDef('box_ordering_steps_payment'), 'code' => 'payment', 'active' => $OSCOM_Template->getModule() == 'Payment' || $OSCOM_Template->getModule() == 'PaymentAddress' ? true : false); $steps[] = array('title' => OSCOM::getDef('box_ordering_steps_confirmation'), 'code' => 'confirmation', 'active' => $OSCOM_Template->getModule() == 'Confirmation' ? true : false); $steps[] = array('title' => OSCOM::getDef('box_ordering_steps_complete'), 'active' => $OSCOM_Template->getModule() == 'Success' ? true : false); $content = osc_image('templates/' . $OSCOM_Template->getCode() . '/images/icons/32x32/checkout_preparing_to_ship.gif') . '<br />'; $counter = 0; foreach ($steps as $step) { $counter++; $content .= '<span style="white-space: nowrap;"> ' . osc_image('templates/' . $OSCOM_Template->getCode() . '/images/icons/24x24/checkout_' . $counter . ($step['active'] === true ? '_on' : '') . '.gif', $step['title'], 24, 24, 'align="absmiddle"'); if (isset($step['code'])) { $content .= osc_link_object(OSCOM::getLink(null, 'Checkout', $step['code'], 'SSL'), $step['title'], 'class="boxCheckoutTrail' . ($step['active'] === true ? 'Active' : '') . '"'); } else { $content .= '<span class="boxCheckoutTrail' . ($step['active'] === true ? 'Active' : '') . '">' . $step['title'] . '</span>'; } $content .= '</span><br />'; } $content .= osc_image('templates/' . $OSCOM_Template->getCode() . '/images/icons/32x32/checkout_ready_to_ship.gif'); $this->_content = $content; }
public function install() { $OSCOM_Database = Registry::get('Database'); parent::install(); $OSCOM_Database->simpleQuery("insert into " . DB_TABLE_PREFIX . "configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', '6', '1', 'osc_cfg_set_boolean_value(array(\\'true\\', \\'false\\'))', now())"); $OSCOM_Database->simpleQuery("insert into " . DB_TABLE_PREFIX . "configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '4', 'Sort order of display.', '6', '2', now())"); }
public static function execute(ApplicationAbstract $application) { $OSCOM_ShoppingCart = Registry::get('ShoppingCart'); $OSCOM_Service = Registry::get('Service'); $OSCOM_Breadcrumb = Registry::get('Breadcrumb'); $OSCOM_Template = Registry::get('Template'); global $osC_oiAddress; // HPDL $application->setPageTitle(OSCOM::getDef('payment_method_heading')); $application->setPageContent('billing.php'); if ($OSCOM_Service->isStarted('Breadcrumb')) { $OSCOM_Breadcrumb->add(OSCOM::getDef('breadcrumb_checkout_payment'), OSCOM::getLink(null, null, 'Billing', 'SSL')); } // load billing address page if no default address exists if (!$OSCOM_ShoppingCart->hasBillingAddress()) { $application->setPageTitle(OSCOM::getDef('payment_address_heading')); $application->setPageContent('billing_address.php'); $OSCOM_Template->addJavascriptFilename(OSCOM::getPublicSiteLink('javascript/checkout_payment_address.js')); $OSCOM_Template->addJavascriptPhpFilename(OSCOM::BASE_DIRECTORY . 'Core/Site/Shop/assets/form_check.js.php'); if (!$OSCOM_Customer->isLoggedOn()) { $osC_oiAddress = new ObjectInfo($OSCOM_ShoppingCart->getBillingAddress()); } } else { $OSCOM_Template->addJavascriptFilename(OSCOM::getPublicSiteLink('javascript/checkout_payment.js')); // load all enabled payment modules $OSCOM_Payment = Registry::get('Payment'); $OSCOM_Payment->loadAll(); $OSCOM_Template->addJavascriptBlock($OSCOM_Payment->getJavascriptBlocks()); } // HPDL // if (isset($_GET['payment_error']) && is_object(${$_GET['payment_error']}) && ($error = ${$_GET['payment_error']}->get_error())) { // $OSCOM_MessageStack->add('CheckoutBilling', $error['error'], 'error'); // } }
public static function execute(ApplicationAbstract $application) { $OSCOM_ShoppingCart = Registry::get('ShoppingCart'); $requested_product = null; if (count($_GET) > 2) { $requested_product = basename(key(array_slice($_GET, 2, 1, true))); if ($requested_product == 'Add') { unset($requested_product); if (count($_GET) > 3) { $requested_product = basename(key(array_slice($_GET, 3, 1, true))); } } } if (isset($requested_product)) { if (Product::checkEntry($requested_product)) { $OSCOM_Product = new Product($requested_product); if ($OSCOM_Product->isTypeActionAllowed('AddToShoppingCart')) { if ($OSCOM_Product->hasVariants()) { if (isset($_POST['variants']) && is_array($_POST['variants']) && !empty($_POST['variants'])) { if ($OSCOM_Product->variantExists($_POST['variants'])) { $OSCOM_ShoppingCart->add($OSCOM_Product->getProductVariantID($_POST['variants'])); } else { OSCOM::redirect(OSCOM::getLink(null, 'Products', $OSCOM_Product->getKeyword())); } } else { OSCOM::redirect(OSCOM::getLink(null, 'Products', $OSCOM_Product->getKeyword())); } } else { $OSCOM_ShoppingCart->add($OSCOM_Product->getID()); } } } } OSCOM::redirect(OSCOM::getLink(null, 'Cart')); }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $sql_file = OSCOM::BASE_DIRECTORY . 'Core/Site/Setup/sql/oscommerce_innodb.sql'; $OSCOM_PDO->importSQL($sql_file, $data['table_prefix']); $OSCOM_PDO->exec('DROP PROCEDURE IF EXISTS CountriesGetAll; CREATE PROCEDURE CountriesGetAll (IN pageset INT, IN maxresults INT) BEGIN IF pageset is null THEN SELECT SQL_CALC_FOUND_ROWS c.*, COUNT(z.zone_id) AS total_zones FROM osc_countries c LEFT JOIN osc_zones z ON (c.countries_id = z.zone_country_id) GROUP BY c.countries_id ORDER BY c.countries_name; ELSE PREPARE STMT FROM "SELECT SQL_CALC_FOUND_ROWS c.*, COUNT(z.zone_id) AS total_zones FROM osc_countries c LEFT JOIN osc_zones z ON (c.countries_id = z.zone_country_id) GROUP BY c.countries_id ORDER BY c.countries_name LIMIT ?, ?"; SET @START = pageset; SET @LIMIT = maxresults; EXECUTE STMT USING @START, @LIMIT; END IF; SELECT FOUND_ROWS() as total; END;'); }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $result = array(); $sql_query = 'select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_status, c.date_account_created, a.entry_country_id from :table_customers c left join :table_address_book a on (c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id) where (c.customers_firstname ilike :customers_firstname or c.customers_lastname ilike :customers_lastname) order by c.customers_lastname, c.customers_firstname'; if ( $data['batch_pageset'] !== -1 ) { $sql_query .= ' limit :batch_max_results offset :batch_pageset'; } $Qcustomers = $OSCOM_PDO->prepare($sql_query); $Qcustomers->bindValue(':customers_firstname', '%' . $data['keywords'] . '%'); $Qcustomers->bindValue(':customers_lastname', '%' . $data['keywords'] . '%'); if ( $data['batch_pageset'] !== -1 ) { $Qcustomers->bindInt(':batch_pageset', $OSCOM_PDO->getBatchFrom($data['batch_pageset'], $data['batch_max_results'])); $Qcustomers->bindInt(':batch_max_results', $data['batch_max_results']); } $Qcustomers->execute(); $result['entries'] = $Qcustomers->fetchAll(); $Qtotal = $OSCOM_PDO->prepare('select count(*) from :table_customers where (customers_firstname ilike :customers_firstname or customers_lastname ilike :customers_lastname)'); $Qtotal->bindValue(':customers_firstname', '%' . $data['keywords'] . '%'); $Qtotal->bindValue(':customers_lastname', '%' . $data['keywords'] . '%'); $Qtotal->execute(); $result['total'] = $Qtotal->fetchColumn(); return $result; }
public function initialize() { $OSCOM_Database = Registry::get('Database'); $OSCOM_ShoppingCart = Registry::get('ShoppingCart'); $this->tax_class = MODULE_SHIPPING_FLAT_TAX_CLASS; if ($this->_status === true && (int) MODULE_SHIPPING_FLAT_ZONE > 0) { $check_flag = false; $Qcheck = $OSCOM_Database->query('select zone_id from :table_zones_to_geo_zones where geo_zone_id = :geo_zone_id and zone_country_id = :zone_country_id order by zone_id'); $Qcheck->bindInt(':geo_zone_id', MODULE_SHIPPING_FLAT_ZONE); $Qcheck->bindInt(':zone_country_id', $OSCOM_ShoppingCart->getShippingAddress('country_id')); $Qcheck->execute(); while ($Qcheck->next()) { if ($Qcheck->valueInt('zone_id') < 1) { $check_flag = true; break; } elseif ($Qcheck->valueInt('zone_id') == $OSCOM_ShoppingCart->getShippingAddress('zone_id')) { $check_flag = true; break; } } if ($check_flag === false) { $this->_status = false; } } }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $error = false; $OSCOM_PDO->beginTransaction(); foreach ( $data as $c ) { $Qcategory = $OSCOM_PDO->prepare('update :table_categories set sort_order = :sort_order, last_modified = now() where categories_id = :categories_id'); $Qcategory->bindInt(':sort_order', $c['sort_order']); $Qcategory->bindInt(':categories_id', $c['id']); $Qcategory->execute(); if ( $Qcategory->isError() ) { $error = true; break; } } if ( $error === false ) { $OSCOM_PDO->commit(); return true; } $OSCOM_PDO->rollBack(); return false; }
public static function execute(ApplicationAbstract $application) { $OSCOM_ShoppingCart = Registry::get('ShoppingCart'); $OSCOM_Service = Registry::get('Service'); $OSCOM_Breadcrumb = Registry::get('Breadcrumb'); $OSCOM_Template = Registry::get('Template'); $OSCOM_Customer = Registry::get('Customer'); global $osC_oiAddress; // HPDL $application->setPageTitle(OSCOM::getDef('shipping_method_heading')); $application->setPageContent('shipping.php'); if ($OSCOM_Service->isStarted('Breadcrumb')) { $OSCOM_Breadcrumb->add(OSCOM::getDef('breadcrumb_checkout_shipping'), OSCOM::getLink(null, null, 'Shipping', 'SSL')); } // load shipping address page if no default address exists if (!$OSCOM_ShoppingCart->hasShippingAddress()) { $application->setPageTitle(OSCOM::getDef('shipping_address_heading')); $application->setPageContent('shipping_address.php'); $OSCOM_Template->addJavascriptFilename(OSCOM::getPublicSiteLink('javascript/checkout_shipping_address.js')); $OSCOM_Template->addJavascriptPhpFilename(OSCOM::BASE_DIRECTORY . 'Core/Site/Shop/assets/form_check.js.php'); if (!$OSCOM_Customer->isLoggedOn()) { $osC_oiAddress = new ObjectInfo($OSCOM_ShoppingCart->getShippingAddress()); } } else { $OSCOM_Template->addJavascriptFilename(OSCOM::getPublicSiteLink('javascript/checkout_shipping.js')); // load all enabled shipping modules Registry::set('Shipping', new ShippingClass(), true); } }
public static function execute(ApplicationAbstract $application) { $OSCOM_MessageStack = Registry::get('MessageStack'); $data = array(); if (DISPLAY_PRIVACY_CONDITIONS == '1') { if (isset($_POST['privacy_conditions']) === false || isset($_POST['privacy_conditions']) && $_POST['privacy_conditions'] != '1') { $OSCOM_MessageStack->add('Create', OSCOM::getDef('error_privacy_statement_not_accepted')); } } if (ACCOUNT_GENDER >= 0) { if (isset($_POST['gender']) && ($_POST['gender'] == 'm' || $_POST['gender'] == 'f')) { $data['gender'] = $_POST['gender']; } else { $OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_gender_error')); } } if (isset($_POST['firstname']) && strlen(trim($_POST['firstname'])) >= ACCOUNT_FIRST_NAME) { $data['firstname'] = $_POST['firstname']; } else { $OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_first_name_error'), ACCOUNT_FIRST_NAME)); } if (isset($_POST['lastname']) && strlen(trim($_POST['lastname'])) >= ACCOUNT_LAST_NAME) { $data['lastname'] = $_POST['lastname']; } else { $OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_last_name_error'), ACCOUNT_LAST_NAME)); } if (ACCOUNT_DATE_OF_BIRTH == '1') { if (isset($_POST['dob_days']) && isset($_POST['dob_months']) && isset($_POST['dob_years']) && checkdate($_POST['dob_months'], $_POST['dob_days'], $_POST['dob_years'])) { $data['dob'] = mktime(0, 0, 0, $_POST['dob_months'], $_POST['dob_days'], $_POST['dob_years']); } else { $OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_date_of_birth_error')); } } if (isset($_POST['email_address']) && strlen(trim($_POST['email_address'])) >= ACCOUNT_EMAIL_ADDRESS) { if (filter_var($_POST['email_address'], FILTER_VALIDATE_EMAIL)) { if (Account::checkEntry($_POST['email_address']) === false) { $data['email_address'] = $_POST['email_address']; } else { $OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_email_address_exists_error')); } } else { $OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_email_address_check_error')); } } else { $OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_email_address_error'), ACCOUNT_EMAIL_ADDRESS)); } if (isset($_POST['password']) === false || isset($_POST['password']) && strlen(trim($_POST['password'])) < ACCOUNT_PASSWORD) { $OSCOM_MessageStack->add('Create', sprintf(OSCOM::getDef('field_customer_password_error'), ACCOUNT_PASSWORD)); } elseif (isset($_POST['confirmation']) === false || isset($_POST['confirmation']) && trim($_POST['password']) != trim($_POST['confirmation'])) { $OSCOM_MessageStack->add('Create', OSCOM::getDef('field_customer_password_mismatch_with_confirmation')); } else { $data['password'] = $_POST['password']; } if ($OSCOM_MessageStack->size('Create') === 0) { if (Account::createEntry($data)) { $OSCOM_MessageStack->add('Create', OSCOM::getDef('success_account_updated'), 'success'); } OSCOM::redirect(OSCOM::getLink(null, null, 'Create&Success', 'SSL')); } }
public static function execute($data) { $OSCOM_PDO = Registry::get('PDO'); $sql_file = OSCOM::BASE_DIRECTORY . 'Core/Site/Setup/sql/PostgreSQL/sample.sql'; return $OSCOM_PDO->importSQL($sql_file, $data['table_prefix']); }
public static function execute(ApplicationAbstract $application) { $OSCOM_ShoppingCart = Registry::get('ShoppingCart'); $OSCOM_PaymentModule = Registry::get('PaymentModule'); $OSCOM_PaymentModule->process(); osc_redirect(OSCOM::getLink(null, null, 'Success', 'SSL')); }
public static function execute($country, $form, $field) { $OSCOM_PDO = Registry::get('PDO'); $num_country = 1; $output_string = ''; $Qcountries = $OSCOM_PDO->query('select distinct zone_country_id from :table_zones order by zone_country_id'); $Qcountries->execute(); while ($Qcountries->fetch()) { if ($num_country == 1) { $output_string .= ' if (' . $country . ' == "' . $Qcountries->valueInt('zone_country_id') . '") {' . "\n"; } else { $output_string .= ' } else if (' . $country . ' == "' . $Qcountries->valueInt('zone_country_id') . '") {' . "\n"; } $num_state = 1; $Qzones = $OSCOM_PDO->prepare('select zone_name, zone_id from :table_zones where zone_country_id = :zone_country_id order by zone_name'); $Qzones->bindInt(':zone_country_id', $Qcountries->valueInt('zone_country_id')); $Qzones->execute(); while ($Qzones->fetch()) { if ($num_state == '1') { $output_string .= ' ' . $form . '.' . $field . '.options[0] = new Option("' . OSCOM::getDef('all_zones') . '", "");' . "\n"; } $output_string .= ' ' . $form . '.' . $field . '.options[' . $num_state . '] = new Option("' . $Qzones->value('zone_name') . '", "' . $Qzones->valueInt('zone_id') . '");' . "\n"; $num_state++; } $num_country++; } $output_string .= ' } else {' . "\n" . ' ' . $form . '.' . $field . '.options[0] = new Option("' . OSCOM::getDef('all_zones') . '", "");' . "\n" . ' }' . "\n"; return $output_string; }