function freeamount() { global $order; $this->code = 'freeamount'; $this->title = MODULE_SHIPPING_FREEAMOUNT_TEXT_TITLE; $this->description = MODULE_SHIPPING_FREEAMOUNT_TEXT_DESCRIPTION; $this->icon = ''; // change $this->icon = DIR_WS_ICONS . 'shipping_ups.gif'; to some freeshipping icon $this->tax_class = MODULE_SHIPPING_FREEAMOUNT_TAX_CLASS; $this->sort_order = MODULE_SHIPPING_FREEAMOUNT_SORT_ORDER; $this->enabled = MODULE_SHIPPING_FREEAMOUNT_STATUS == 'True' ? true : false; if ($this->enabled == true && (int) MODULE_SHIPPING_FREEAMOUNT_ZONE > 0) { $check_flag = false; $check_query = vam_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_FREEAMOUNT_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } }
function vam_get_download($content_id) { $content_query = vam_db_query("SELECT\n\t\t\t\t\tcontent_file,\n\t\t\t\t\tcontent_read\n\t\t\t\t\tFROM " . TABLE_PRODUCTS_CONTENT . "\n\t\t\t\t\tWHERE content_id='" . $content_id . "'"); $content_data = vam_db_fetch_array($content_query); // update file counter vam_db_query("UPDATE \n\t\t\t" . TABLE_PRODUCTS_CONTENT . " \n\t\t\tSET content_read='" . ($content_data['content_read'] + 1) . "'\n\t\t\tWHERE content_id='" . $content_id . "'"); // original filename $filename = DIR_FS_CATALOG . 'media/products/' . $content_data['content_file']; $backup_filename = DIR_FS_CATALOG . 'media/products/backup/' . $content_data['content_file']; // create md5 hash id from original file $orign_hash_id = md5_file($filename); clearstatcache(); // create new filename with timestamp $timestamp = str_replace('.', '', microtime()); $timestamp = str_replace(' ', '', $timestamp); $new_filename = DIR_FS_CATALOG . 'media/products/' . $timestamp . strstr($content_data['content_file'], '.'); // rename file rename($filename, $new_filename); if (file_exists($new_filename)) { header("Content-type: application/force-download"); header("Content-Disposition: attachment; filename=" . $new_filename); @readfile($new_filename); // rename file to original name rename($new_filename, $filename); $new_hash_id = md5_file($filename); clearstatcache(); // check hash id of file again, if not same, get backup! if ($new_hash_id != $orign_hash_id) { copy($backup_filename, $filename); } } }
function item() { global $order; $this->code = 'item'; $this->title = MODULE_SHIPPING_ITEM_TEXT_TITLE; $this->description = MODULE_SHIPPING_ITEM_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_ITEM_SORT_ORDER; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_ITEM_TAX_CLASS; $this->enabled = MODULE_SHIPPING_ITEM_STATUS == 'True' ? true : false; if ($this->enabled == true && (int) MODULE_SHIPPING_ITEM_ZONE > 0) { $check_flag = false; $check_query = vam_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_ITEM_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } }
function ship2pay() { global $order; $shipping = $_SESSION['shipping']; $shipping_module = substr($shipping['id'], 0, strpos($shipping['id'], '_')) . '.php'; $q_ship2pay = vamDBquery("SELECT payments_allowed, zones_id FROM " . TABLE_SHIP2PAY . " where shipment = '" . $shipping_module . "' and status=1"); $check_flag = false; while ($mods = vam_db_fetch_array($q_ship2pay, true)) { if ($mods['zones_id'] > 0) { $check_query = vamDBquery("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . $mods['zones_id'] . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query, true)) { if ($check['zone_id'] < 1) { $check_flag = true; break 2; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break 2; } } } else { $check_flag = true; break; } } if ($check_flag) { $modules = $mods['payments_allowed']; } else { $modules = MODULE_PAYMENT_INSTALLED; } $modules = explode(';', $modules); return $modules; }
function vam_get_tax_description($class_id, $country_id = -1, $zone_id = -1) { if ($country_id == -1 && $zone_id == -1) { if (!isset($_SESSION['customer_id'])) { $country_id = STORE_COUNTRY; $zone_id = STORE_ZONE; } else { $country_id = $_SESSION['customer_country_id']; $zone_id = $_SESSION['customer_zone_id']; } } else { $country_id = $country_id; $zone_id = $zone_id; } $tax_query = vamDBquery("select tax_description from " . TABLE_TAX_RATES . " tr left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id) left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '" . $country_id . "') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '" . $zone_id . "') and tr.tax_class_id = '" . $class_id . "' order by tr.tax_priority"); if (vam_db_num_rows($tax_query, true)) { $tax_description = ''; while ($tax = vam_db_fetch_array($tax_query, true)) { $tax_description .= $tax['tax_description'] . ' + '; } $tax_description = substr($tax_description, 0, -3); return $tax_description; } else { return TEXT_UNKNOWN_TAX_RATE; } }
/** * class constructor */ function dhl() { global $order; $this->code = 'dhl'; $this->title = MODULE_SHIPPING_DHL_TEXT_TITLE; $this->description = MODULE_SHIPPING_DHL_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_DHL_SORT_ORDER; $this->icon = DIR_WS_ICONS . 'shipping_dhl.gif'; $this->tax_class = MODULE_SHIPPING_DHL_TAX_CLASS; $this->enabled = MODULE_SHIPPING_DHL_STATUS == 'True' ? true : false; if ($this->enabled == true && (int) MODULE_SHIPPING_DHL_ZONE > 0) { $check_flag = false; $check_query = vam_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_DHL_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } $this->types = array('ECX' => 'EU Express Service', 'DOX' => 'Document Express Service', 'SDX' => 'Start Day Express Service', 'MDX' => 'Mid Day Express Service', 'WPX' => 'Waren Express Service'); /** * CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES NEEDED */ $this->num_dhl = 10; }
function affiliate_insert($sql_data_array, $affiliate_parent = 0) { // LOCK TABLES @mysql_query("LOCK TABLES " . TABLE_AFFILIATE . " WRITE"); if ($affiliate_parent > 0) { $affiliate_root_query = vam_db_query("select affiliate_root, affiliate_rgt, affiliate_lft from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate_parent . "' "); // Check if we have a parent affiliate if ($affiliate_root_array = vam_db_fetch_array($affiliate_root_query)) { vam_db_query("update " . TABLE_AFFILIATE . " SET affiliate_lft = affiliate_lft + 2 WHERE affiliate_root = '" . $affiliate_root_array['affiliate_root'] . "' and affiliate_lft > " . $affiliate_root_array['affiliate_rgt'] . " AND affiliate_rgt >= " . $affiliate_root_array['affiliate_rgt'] . " "); vam_db_query("update " . TABLE_AFFILIATE . " SET affiliate_rgt = affiliate_rgt + 2 WHERE affiliate_root = '" . $affiliate_root_array['affiliate_root'] . "' and affiliate_rgt >= " . $affiliate_root_array['affiliate_rgt'] . " "); $sql_data_array['affiliate_root'] = $affiliate_root_array['affiliate_root']; $sql_data_array['affiliate_lft'] = $affiliate_root_array['affiliate_rgt']; $sql_data_array['affiliate_rgt'] = $affiliate_root_array['affiliate_rgt'] + 1; vam_db_perform(TABLE_AFFILIATE, $sql_data_array); $affiliate_id = vam_db_insert_id(); } // no parent -> new root } else { $sql_data_array['affiliate_lft'] = '1'; $sql_data_array['affiliate_rgt'] = '2'; vam_db_perform(TABLE_AFFILIATE, $sql_data_array); $affiliate_id = vam_db_insert_id(); vam_db_query("update " . TABLE_AFFILIATE . " set affiliate_root = '" . $affiliate_id . "' where affiliate_id = '" . $affiliate_id . "' "); } // UNLOCK TABLES @mysql_query("UNLOCK TABLES"); return $affiliate_id; }
function updateBill($login, $password, $txn, $status) { //обработка возможных ошибок авторизации if ($login != MODULE_PAYMENT_QIWI_ID) { return 150; } if (!empty($password) && $password != strtoupper(md5($txn . strtoupper(md5(MODULE_PAYMENT_QIWI_SECRET_KEY))))) { return 150; } // получаем номер заказа $transaction = intval($txn); // проверяем, есть ли такой заказ в базе $order_query = vam_db_query("select count(*) as total from " . TABLE_ORDERS . " where orders_id = '" . (int) $transaction . "'"); $order_exists = vam_db_fetch_array($order_query); if ($order_exists['total'] <= 0) { return 210; } // меняем статус заказа при условии оплаты счёта if ($status == 60) { $sql_data_array = array('orders_status' => MODULE_PAYMENT_QIWI_ORDER_STATUS_ID); vam_db_perform('orders', $sql_data_array, 'update', "orders_id='" . $transaction . "'"); $sql_data_arrax = array('orders_id' => $transaction, 'orders_status_id' => MODULE_PAYMENT_QIWI_ORDER_STATUS_ID, 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => 'QIWI accepted this order payment'); vam_db_perform('orders_status_history', $sql_data_arrax); // Отправляем письмо клиенту и админу о смене статуса заказа require_once DIR_WS_CLASSES . 'order.php'; $order = new order($transaction); $vamTemplate = new vamTemplate(); // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = false; $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('NAME', $order->customer['firstname'] . ' ' . $order->customer['lastname']); $vamTemplate->assign('ORDER_NR', $transaction); $vamTemplate->assign('ORDER_LINK', vam_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $transaction, 'SSL')); $vamTemplate->assign('ORDER_DATE', vam_date_long($order->info['date_purchased'])); $lang_query = vam_db_query("select languages_id from " . TABLE_LANGUAGES . " where directory = '" . $_SESSION['language'] . "'"); $lang = vam_db_fetch_array($lang_query); $lang = $lang['languages_id']; if (!isset($lang)) { $lang = $_SESSION['languages_id']; } $orders_status_array = array(); $orders_status_query = vam_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $lang . "'"); while ($orders_status = vam_db_fetch_array($orders_status_query)) { $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']); $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; } $vamTemplate->assign('ORDER_STATUS', $orders_status_array[MODULE_PAYMENT_QIWI_ORDER_STATUS_ID]); $html_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/change_order_mail.html'); $txt_mail = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/change_order_mail.txt'); include_once DIR_WS_LANGUAGES . $_SESSION['language'] . '/modules/payment/qiwi.php'; // create subject $order_subject = str_replace('{$nr}', $transaction, MODULE_PAYMENT_QIWI_EMAIL_SUBJECT); // send mail to admin vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, EMAIL_BILLING_ADDRESS, STORE_NAME, EMAIL_BILLING_FORWARDING_STRING, $order->customer['email_address'], $order->customer['firstname'], '', '', $order_subject, $html_mail, $txt_mail); // send mail to customer vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $order->customer['email_address'], $order->customer['firstname'] . ' ' . $order->customer['lastname'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $order_subject, $html_mail, $txt_mail); } }
function splitPageResults(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows) { if (empty($current_page_number)) { $current_page_number = 1; } $pos_to = strlen($sql_query); $pos_from = strpos($sql_query, ' from', 0); $pos_group_by = strpos($sql_query, ' group by', $pos_from); if ($pos_group_by < $pos_to && $pos_group_by != false) { $pos_to = $pos_group_by; } $pos_having = strpos($sql_query, ' having', $pos_from); if ($pos_having < $pos_to && $pos_having != false) { $pos_to = $pos_having; } $pos_order_by = strpos($sql_query, ' order by', $pos_from); if ($pos_order_by < $pos_to && $pos_order_by != false) { $pos_to = $pos_order_by; } $reviews_count_query = vam_db_query("select count(*) as total " . substr($sql_query, $pos_from, $pos_to - $pos_from)); $reviews_count = vam_db_fetch_array($reviews_count_query); $query_num_rows = $reviews_count['total']; $num_pages = ceil($query_num_rows / $max_rows_per_page); if ($current_page_number > $num_pages) { $current_page_number = $num_pages; } $offset = $max_rows_per_page * ($current_page_number - 1); if ($offset < 0) { $offset = 0; } $sql_query .= " limit " . $offset . ", " . $max_rows_per_page; }
function get_category_tree($parent_id = '0', $spacing = '', $exclude = '', $category_tree_array = '', $include_itself = false, $cPath = '') { if ($parent_id == 0) { $cPath = ''; } else { $cPath .= $parent_id . '_'; } if (!is_array($category_tree_array)) { $category_tree_array = array(); } if (sizeof($category_tree_array) < 1 && $exclude != '0') { $category_tree_array[] = array('id' => '0', 'text' => TEXT_TOP); } if ($include_itself) { $category_query = "select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd where cd.language_id = '" . $_SESSION['languages_id'] . "' and c.categories_status = '1' and cd.categories_id = '" . $parent_id . "'"; $category_query = vamDBquery($category_query); $category = vam_db_fetch_array($category_query, true); $category_tree_array[] = array('id' => $parent_id, 'text' => $category['categories_name']); } $categories_query = "select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . $_SESSION['languages_id'] . "' and c.parent_id = '" . $parent_id . "' and c.categories_status = '1' order by c.sort_order, cd.categories_name"; $categories_query = vamDBquery($categories_query); while ($categories = vam_db_fetch_array($categories_query, true)) { $SEF_link = vam_href_link(FILENAME_DEFAULT, vam_category_link($categories['categories_id'], $categories['categories_name'])); if ($exclude != $categories['categories_id']) { $category_tree_array[] = array('id' => $categories['categories_id'], 'text' => $spacing . $categories['categories_name'], 'link' => $SEF_link); } $category_tree_array = get_category_tree($categories['categories_id'], $spacing . ' ', $exclude, $category_tree_array, false, $cPath); } return $category_tree_array; }
function fedexeu() { global $order; $this->code = 'fedexeu'; $this->title = MODULE_SHIPPING_FEDEXEU_TEXT_TITLE; $this->description = MODULE_SHIPPING_FEDEXEU_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_FEDEXEU_SORT_ORDER; $this->icon = DIR_WS_ICONS . 'shipping_fedexeu.gif'; $this->tax_class = MODULE_SHIPPING_FEDEXEU_TAX_CLASS; $this->enabled = MODULE_SHIPPING_FEDEXEU_STATUS == 'True' ? true : false; if ($this->enabled == true && (int) MODULE_SHIPPING_FEDEXEU_ZONE > 0) { $check_flag = false; $check_query = vam_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_FEDEXEU_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } $this->types = array('ENV' => 'FedEx Envelope', 'PAK' => 'FedEx Pak', 'BOX' => 'FedEx Box'); /** * CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES NEEDED */ $this->num_fedexeu = 8; }
function vam_address_label($customers_id, $address_id = 1, $html = false, $boln = '', $eoln = "\n") { $address_query = vam_db_query("select entry_firstname as firstname, entry_secondname as secondname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $customers_id . "' and address_book_id = '" . $address_id . "'"); $address = vam_db_fetch_array($address_query); $format_id = vam_get_address_format_id($address['country_id']); return vam_address_format($format_id, $address, $html, $boln, $eoln); }
function vam_get_products_image($products_id = '') { $product_query = "select products_image from " . TABLE_PRODUCTS . " where products_id = '" . $products_id . "'"; $product_query = vamDBquery($product_query); $products_image = vam_db_fetch_array($product_query, true); return $products_image['products_image']; }
function vam_display_banner($action, $identifier) { if ($action == 'dynamic') { $banners_query = vam_db_query("select count(*) as count from " . TABLE_BANNERS . " where status = '1' and banners_group = '" . $identifier . "'"); $banners = vam_db_fetch_array($banners_query); if ($banners['count'] > 0) { $banner = vam_random_select("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_group = '" . $identifier . "'"); } else { return '<b>VaM Shop ERROR! (vam_display_banner(' . $action . ', ' . $identifier . ') -> No banners with group \'' . $identifier . '\' found!</b>'; } } elseif ($action == 'static') { if (is_array($identifier)) { $banner = $identifier; } else { $banner_query = vam_db_query("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_id = '" . $identifier . "'"); if (vam_db_num_rows($banner_query)) { $banner = vam_db_fetch_array($banner_query); } else { return '<b>VaM Shop ERROR! (vam_display_banner(' . $action . ', ' . $identifier . ') -> Banner with ID \'' . $identifier . '\' not found, or status inactive</b>'; } } } else { return '<b>VaM Shop ERROR! (vam_display_banner(' . $action . ', ' . $identifier . ') -> Unknown $action parameter value - it must be either \'dynamic\' or \'static\'</b>'; } if (vam_not_null($banner['banners_html_text'])) { $banner_string = $banner['banners_html_text']; } else { $banner_string = '<a href="' . vam_href_link(FILENAME_REDIRECT, 'action=banner&goto=' . $banner['banners_id']) . '" onclick="window.open(this.href); return false;">' . vam_image(DIR_WS_IMAGES . 'banner/' . $banner['banners_image'], $banner['banners_title']) . '</a>'; } vam_update_banner_display_count($banner['banners_id']); return $banner_string; }
function vam_get_products_stock($products_id) { $products_id = vam_get_prid($products_id); $stock_query = vam_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . $products_id . "'"); $stock_values = vam_db_fetch_array($stock_query); return $stock_values['products_quantity']; }
function vam_get_vpe_name($vpeID) { $vpe_query = "SELECT products_vpe_name FROM " . TABLE_PRODUCTS_VPE . " WHERE language_id='" . (int) $_SESSION['languages_id'] . "' and products_vpe_id='" . $vpeID . "'"; $vpe_query = vamDBquery($vpe_query); $vpe = vam_db_fetch_array($vpe_query, true); return $vpe['products_vpe_name']; }
function vam_oe_customer_infos($customers_id) { $customer_query = vam_db_query("select a.entry_country_id, a.entry_zone_id from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " a where c.customers_id = '" . $customers_id . "' and c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id"); $customer = vam_db_fetch_array($customer_query); $customer_info_array = array('country_id' => $customer['entry_country_id'], 'zone_id' => $customer['entry_zone_id']); return $customer_info_array; }
function vam_get_path($current_category_id = '') { global $cPath_array; if (vam_not_null($current_category_id)) { $cp_size = sizeof($cPath_array); if ($cp_size == 0) { $cPath_new = $current_category_id; } else { $cPath_new = ''; $last_category_query = "select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . $cPath_array[$cp_size - 1] . "'"; $last_category_query = vamDBquery($last_category_query); $last_category = vam_db_fetch_array($last_category_query, true); $current_category_query = "select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . $current_category_id . "'"; $current_category_query = vamDBquery($current_category_query); $current_category = vam_db_fetch_array($current_category_query, true); if ($last_category['parent_id'] == $current_category['parent_id']) { for ($i = 0; $i < $cp_size - 1; $i++) { $cPath_new .= '_' . $cPath_array[$i]; } } else { for ($i = 0; $i < $cp_size; $i++) { $cPath_new .= '_' . $cPath_array[$i]; } } $cPath_new .= '_' . $current_category_id; if (substr($cPath_new, 0, 1) == '_') { $cPath_new = substr($cPath_new, 1); } } } else { $cPath_new = vam_not_null($cPath_array) ? implode('_', $cPath_array) : ''; } return 'cPath=' . $cPath_new; }
function update_status() { global $order; $check_order_query = vam_db_query("select count(*) as count from " . TABLE_ORDERS . " where customers_id = '" . (int) $_SESSION['customer_id'] . "'"); $order_check = vam_db_fetch_array($check_order_query); if ($order_check['count'] < MODULE_PAYMENT_INVOICE_MIN_ORDER) { $check_flag = false; $this->enabled = false; } else { $check_flag = true; if ($this->enabled == true && (int) MODULE_PAYMENT_INVOICE_ZONE > 0) { $check_flag = false; $check_query = vam_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_INVOICE_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } } if ($check_flag == false) { $this->enabled = false; } } }
function ups() { global $order; $this->code = 'ups'; $this->title = MODULE_SHIPPING_UPS_TEXT_TITLE; $this->description = MODULE_SHIPPING_UPS_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_UPS_SORT_ORDER; $this->icon = DIR_WS_ICONS . 'shipping_ups.gif'; $this->tax_class = MODULE_SHIPPING_UPS_TAX_CLASS; $this->free = MODULE_SHIPPING_UPS_TEXT_FREE; $this->enabled = MODULE_SHIPPING_UPS_STATUS == 'True' ? true : false; if ($this->enabled == true && (int) MODULE_SHIPPING_UPS_ZONE > 0) { $check_flag = false; $check_query = vam_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_UPS_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } /** * CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES NEEDED */ $this->num_ups = 7; }
function vam_get_tax_rate($class_id, $country_id = -1, $zone_id = -1) { if ($country_id == -1 && $zone_id == -1) { if (!isset($_SESSION['customer_id'])) { $country_id = STORE_COUNTRY; $zone_id = STORE_ZONE; } else { $country_id = $_SESSION['customer_country_id']; $zone_id = $_SESSION['customer_zone_id']; } } else { $country_id = $country_id; $zone_id = $zone_id; } $tax_query = vamDBquery("select sum(tax_rate) as tax_rate from " . TABLE_TAX_RATES . " tr left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id) left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '" . $country_id . "') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '" . $zone_id . "') and tr.tax_class_id = '" . $class_id . "' group by tr.tax_priority"); if (vam_db_num_rows($tax_query, true)) { $tax_multiplier = 1.0; while ($tax = vam_db_fetch_array($tax_query, true)) { $tax_multiplier *= 1.0 + $tax['tax_rate'] / 100; } return ($tax_multiplier - 1.0) * 100; } else { return 0; } }
function vam_get_tax_title_class_id($tax_class_title) { $classes_query = vam_db_query("select tax_class_id from " . TABLE_TAX_CLASS . " WHERE tax_class_title = '" . $tax_class_title . "'"); $tax_class_array = vam_db_fetch_array($classes_query); $tax_class_id = $tax_class_array['tax_class_id']; return $tax_class_id; }
/** * class constructor */ function chronopost() { $this->code = 'chronopost'; $this->title = MODULE_SHIPPING_CHRONOPOST_TEXT_TITLE; $this->description = MODULE_SHIPPING_CHRONOPOST_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_CHRONOPOST_SORT_ORDER; $this->icon = DIR_WS_ICONS . 'shipping_chronopost.gif'; $this->tax_class = MODULE_SHIPPING_CHRONOPOST_TAX_CLASS; $this->enabled = MODULE_SHIPPING_CHRONOPOST_STATUS == 'True' ? true : false; /** * CUSTOMIZE THIS SETTING FOR THE NUMBER OF chronopost NEEDED */ $this->num_chronopost = 10; //NBen je remplace 1 par 10 if ($this->enabled == true && (int) MODULE_SHIPPING_CHRONOPOST_ZONE > 0) { $check_flag = false; $check_query = vam_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_CHRONOPOST_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = vam_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } }
function file_changers($file_path) { $result = vam_db_query("\n SELECT content_md5, modification_date, contrib\n FROM " . TABLE_CIP_FILE_INTEGRITY . "\n WHERE path_md5='" . md5($file_path) . "'\n ORDER BY modification_date"); while ($file_changer = vam_db_fetch_array($result)) { $array[] = array('path_md5' => $file_changer['path_md5'], 'content_md5' => $file_changer['content_md5'], 'modification_date' => $file_changer['modification_date'], 'contrib' => $file_changer['contrib']); } return $array; }
function currencies() { $this->currencies = array(); $currencies_query = vam_db_query("select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from " . TABLE_CURRENCIES); while ($currencies = vam_db_fetch_array($currencies_query)) { $this->currencies[$currencies['code']] = array('title' => $currencies['title'], 'symbol_left' => $currencies['symbol_left'], 'symbol_right' => $currencies['symbol_right'], 'decimal_point' => $currencies['decimal_point'], 'thousands_point' => $currencies['thousands_point'], 'decimal_places' => $currencies['decimal_places'], 'value' => $currencies['value']); } }
function get_price_range($current_category) { $sql = "SELECT MAX(p.products_price) max_price, MIN(p.products_price) min_price\n FROM " . TABLE_PRODUCTS . " p \n INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p2c.products_id = p.products_id AND p2c.categories_id = " . $current_category . "\n WHERE p.products_status = '1'"; $res = vam_db_query($sql); $price_limit = vam_db_fetch_array($res); $result = "<script type='text/javascript'>\n\t\tvar min_price = " . $price_limit['min_price'] . ";\n\t\tvar max_price = " . $price_limit['max_price'] . ";\n </script>"; return $result; }
function selection() { global $order; $payment_query = vam_db_query("select * from " . TABLE_COMPANIES . " where customers_id = '" . (int) $order->customer['id'] . "'"); $payment_data = vam_db_fetch_array($payment_query); $selection = array('id' => $this->code, 'module' => $this->title, 'description' => $this->info, 'fields' => array(array('title' => '<div id="schet">' . MODULE_PAYMENT_SCHET_J_NAME_TITLE, 'field' => MODULE_PAYMENT_SCHET_J_NAME_DESC), array('title' => MODULE_PAYMENT_SCHET_J_NAME, 'field' => vam_draw_input_field('s_name', $payment_data['name']) . MODULE_PAYMENT_SCHET_J_NAME_IP), array('title' => MODULE_PAYMENT_SCHET_J_INN, 'field' => vam_draw_input_field('s_inn')), array('title' => MODULE_PAYMENT_SCHET_J_TELEPHONE, 'field' => vam_draw_input_field('s_telephone', $order->customer['telephone']) . '</div>'))); return $selection; }
function vam_get_customers_country($customers_id) { $customers_query = vam_db_query("select customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_id = '" . $customers_id . "'"); $customers = vam_db_fetch_array($customers_query); $address_book_query = vam_db_query("select entry_country_id from " . TABLE_ADDRESS_BOOK . " where address_book_id = '" . $customers['customers_default_address_id'] . "'"); $address_book = vam_db_fetch_array($address_book_query); return $address_book['entry_country_id']; }
function vam_oe_get_options_values_name($products_options_values_id, $language = '') { if (empty($language)) { $language = $_SESSION['languages_id']; } $product_query = vam_db_query("select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $products_options_values_id . "' and language_id = '" . $language . "'"); $product = vam_db_fetch_array($product_query); return $product['products_options_values_name']; }
function vam_expire_specials() { $specials_query = vam_db_query("select specials_id from " . TABLE_SPECIALS . " where status = '1' and now() >= expires_date and expires_date > 0"); if (vam_db_num_rows($specials_query)) { while ($specials = vam_db_fetch_array($specials_query)) { vam_set_specials_status($specials['specials_id'], '0'); } } }