Jump to content

bhbilbao

Members
  • Content count

    308
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by bhbilbao

  1. bhbilbao

    Header Tags SEO

    SPPC + HIDE PRODUCTS SPPC + HEADER TAGS I dont know what should be the correct modification for some lines in catalog/includes/aplication_top.php I need both contributions working, if I replace the code Hide Products for SPPC will not work. Any suggestion?? My original code: // BOF SPPC Hide products and categories from groups if (isset($cPath_array)) { for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { $categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c using(categories_id) where cd.categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "' and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); // EOF SPPC Hide products and categories from groups then // add the products model to the breadcrumb trail if (isset($HTTP_GET_VARS['products_id'])) { // BOF SPPC Hide products and categories from groups $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); // EOF SPPC Hide products and categories from groups if (tep_db_num_rows($model_query)) { $model = tep_db_fetch_array($model_query); $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); Must be raplaced by this: $categories_query = tep_db_query("select categories_htc_title_tag from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "' LIMIT 1"); then: $products_query = tep_db_query("select pd.products_head_title_tag from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_id = '" . (int)$_GET['products_id'] . "' and pd.language_id ='" . (int)$languages_id . "' LIMIT 1");
  2. Finally moded to work with MVS. I upload soon. One question. Is ther any form to add a table with all prices when editing a product in categories.php???? The TABS system is right but I loose time changing betwen the tabs looking for the best price. Thanks.
  3. bhbilbao

    Attribute Sets Plus

    ATRIBUTES SET PLUS + SPPC + HIDDEN PRODUCTS SPPC + ATRIBUTES HIDEN I get an error on product_info.php page: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND customers_group_id = '2'' at line 1 select products_attributes_id, options_values_price, price_prefix from products_attributes_groups where products_attributes_id IN (,) AND customers_group_id = '2' [TEP STOP] part of code: <?php // BOF SPPC Hide attributes from customer groups $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', attributes_hide_from_groups) = 0 "); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <tr> <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', attributes_hide_from_groups) = 0 order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', attributes_hide_from_groups) = 0"); // BOF Linkmatics attributes sets plus $products_options_query = tep_db_query(" SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " pas2pa, " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov WHERE pa.products_id = '" . (int)$_GET['products_id'] . "' AND pa.options_id = '" . $products_options_name['products_options_id'] . "' AND pas2pa.products_id = pa.products_id AND pas.products_attributes_sets_id = pas2pa.products_attributes_sets_id AND pas.products_options_id = pa.options_id AND pase.products_attributes_sets_id = pas.products_attributes_sets_id AND pase.options_values_id = pa.options_values_id AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '" . $languages_id . "' ORDER BY pase.sort_order, pa.options_values_id"); // >>>>> BOF Linkmatics attributes sets plus patch v1.01 if (tep_db_num_rows($products_options_query)== 0 ) { $products_options_query = tep_db_query(" SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pa.options_values_id FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov WHERE pa.products_id = '" . (int)$_GET['products_id'] . "' AND pa.options_id = '" . $products_options_name['products_options_id'] . "' AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '" . $languages_id . "' ORDER BY pa.options_values_id"); } // <<<<< EOF Linkmatics attributes sets plus patch v1.01 // EOF Linkmatics attributes sets plus $list_of_prdcts_attributes_id = ''; $products_options = array(); // makes sure this array is empty again while ($_products_options = tep_db_fetch_array($products_options_query)) { $products_options[] = $_products_options; $list_of_prdcts_attributes_id .= $_products_options['products_attributes_id'].","; } if (tep_not_null($list_of_prdcts_attributes_id) && $customer_group_id != '0') { $select_list_of_prdcts_attributes_ids = "(" . substr($list_of_prdcts_attributes_id, 0 , -1) . ")"; // $pag_query = tep_db_query("select products_attributes_id, options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES_GROUPS . " where products_attributes_id IN " . $select_list_of_prdcts_attributes_ids . " AND customers_group_id = '" . $this->cg_id . "'"); $pag_query = tep_db_query("select products_attributes_id, options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES_GROUPS . " where products_attributes_id IN " . $select_list_of_prdcts_attributes_ids . " AND customers_group_id = '" . $customer_group_id . "'"); while ($pag_array = tep_db_fetch_array($pag_query)) { $cg_attr_prices[] = $pag_array; } // substitute options_values_price and prefix for those for the customer group (if available) If I remove from // BOF Linkmatics attributes sets plus TO // BOF Linkmatics attributes sets plus it works fine. Any suggestion??
  4. bhbilbao

    Seperate Pricing Per Customer v3.5

    Sorry, working: tep_db_query("INSERT INTO " . TABLE_PRODUCTS_ATTRIBUTES . " ( products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, attributes_hide_from_groups ) VALUES (".$clone_product_id_to.", ".$attributes_values['options_id'].", ".$attributes_values['options_values_id'].", ".$attributes_values['options_values_price'].", '".$attributes_values['price_prefix']."', ".$attributes_values['products_options_sort_order'].", '".$attributes_values['attributes_hide_from_groups']."')");
  5. bhbilbao

    Seperate Pricing Per Customer v3.5

    New question with SPPC + HIDE PRODUCTS SPPC + Atributes Cloner&Copier original code in admin/products_attributes.php: case 'clone_attributes': $clone_product_id_from = $HTTP_POST_VARS['clone_products_id_from']; $clone_product_id_to = $HTTP_POST_VARS['clone_products_id_to']; tep_db_query("delete from ".TABLE_PRODUCTS_ATTRIBUTES." WHERE products_id='".$clone_product_id_to."'"); $attributes = tep_db_query("select products_id, options_id, options_values_id, options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES ." where products_id='".$clone_product_id_from."'"); while($attributes_values = tep_db_fetch_array($attributes)) { tep_db_query("INSERT INTO " . TABLE_PRODUCTS_ATTRIBUTES . " ( products_id, options_id, options_values_id, options_values_price, price_prefix ) VALUES (".$clone_product_id_to.", ".$attributes_values['options_id'].", ".$attributes_values['options_values_id'].", ".$attributes_values['options_values_price'].", '".$attributes_values['price_prefix']."')"); } break; Modified code: case 'clone_attributes': $clone_product_id_from = $HTTP_POST_VARS['clone_products_id_from']; $clone_product_id_to = $HTTP_POST_VARS['clone_products_id_to']; tep_db_query("delete from ".TABLE_PRODUCTS_ATTRIBUTES." WHERE products_id='".$clone_product_id_to."'"); $attributes = tep_db_query("select products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, attributes_hide_from_groups from " . TABLE_PRODUCTS_ATTRIBUTES ." where products_id='".$clone_product_id_from."'"); while($attributes_values = tep_db_fetch_array($attributes)) { tep_db_query("INSERT INTO " . TABLE_PRODUCTS_ATTRIBUTES . " ( products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, attributes_hide_from_groups ) VALUES (".$clone_product_id_to.", ".$attributes_values['options_id'].", ".$attributes_values['options_values_id'].", ".$attributes_values['options_values_price'].", '".$attributes_values['price_prefix']."', ".$attributes_values['products_options_sort_order'].", ".$attributes_values['attributes_hide_from_groups'].")"); } break; If the cloned attributes dont have a Hidden Status (defaunt @) gets an error. CANNOT BE NULL If the cloned attributes have Hidden Status (@,0) the following error: 1136 - Column count doesn't match value count at row 1 INSERT INTO products_attributes ( products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, attributes_hide_from_groups ) VALUES (9062, 1, 1, 5.0000, '+', 1, @,0) [TEP STOP] Only works if I remove "attributes_hide_from_groups" but default it asign a @ (the database default option). ¿?
  6. bhbilbao

    SalesForce

    If I configure the email options "Send as TXT" the salesmen and the group receives the emails. If I configure as "Send HTLM" they dont receive anything. I think I must modify the other contributes (Send HTLM, Order Email Text, Email order text, etc) and integrate the code of this. In other hand, the extrange bug of Duplicated Salesmen is not problem of this contribution. Began to fail after installing SPPC. This contribution works.
  7. bhbilbao

    Seperate Pricing Per Customer v3.5

    More info: Only works if a customer is registered and login. If the customer is a visitor when finishing the custom builder and click on "add to cart" there is no description. I looked the database products_atributes 202 16627 3 6 0.0000 + 0 0 203 16627 3 6 0.0000 + 0 @ 204 16627 4 7 0.0000 + 0 0 205 16627 4 7 0.0000 + 0 @ Are duplicating the attributes when record values of the custom product????
  8. bhbilbao

    SalesForce

    My salesmen dont receive a copy of the orders. I dont know where to place the code. I used Send HTML emails with other contribs: part of code in checkout_process.php //BEGIN SEND HTML MAIL// $orders_picture_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . (int)$order->products[$i]['id'] . "'"); $orders_picture=tep_db_fetch_array($orders_picture_query); $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n"; // Line Added - MOD: CREDIT CLASS Gift Voucher Contribution $order_total_modules->apply_credit(); $products_quantity .= nl2br($order->products[$i]['qty'] . "\n"); $products_name .= nl2br("" . $order->products[$i]['name'] . $products_ordered_attributes ."\n"); if (!tep_not_null($order->products[$i]['model'])) { $products_model .= ''.EMAIL_NO_MODEL.'' ; } else{ $products_model .= nl2br($order->products[$i]['model'] . "\n"); }; $orderarray[$i] = array("Image" => "<img src=".HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $orders_picture['products_image']." width='92px' border='0'>", "Model" => nl2br("" . $order->products[$i]['name'] . $products_ordered_attributes . "\n" ), "Modelnr"=> nl2br($order->products[$i]['model'] . "\n"), "Qty" => nl2br($order->products[$i]['qty'] . "\n"), "Unitprice" => nl2br($currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], 1) . "\n"), "Tax" => nl2br($order->products[$i]['tax'] ."\n"), "Price" => nl2br($currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . "\n")); } for ($i=0; $i<sizeof($order_totals); $i++) { $Vartaxe .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n"; } if ($order->content_type != 'virtual') { $Varaddress .= tep_address_label($customer_id, $sendto, 0, '', "\n") ; } if (is_object($$payment)) { $Varmodepay .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . EMAIL_SEPARATOR . "\n"; $payment_class = $$payment; $Varmodpay .= $payment_class->title . "\n"; if ($payment_class->email_footer) { $Varmodpay .= $payment_class->email_footer . "\n\n"; } } $Varlogo = ''.VARLOGO.'' ; $Vartable1 = ''.VARTABLE1.'' ; $Vartable2 = ''.VARTABLE2.'' ; $Varframe1 = ''.VARFRAMEU.'' ; $Varframe2 = ''.VARFRAMED.'' ; $Vartext1 = ' <b>' . EMAIL_TEXT_DEAR . ' ' . $order->customer['firstname'] . ' ' . $order->customer['lastname'] .' </b><br>' . EMAIL_MESSAGE_GREETING ; $Vartext2 = ' ' . EMAIL_TEXT_ORDER_NUMBER . ' <STRONG> ' . $insert_id . '</STRONG><br>' . EMAIL_TEXT_DATE_ORDERED . ': <strong>' . strftime(DATE_FORMAT_LONG) . '</strong><br>' . TLF . ': <strong>' . $order->customer['telephone'] . '</strong><br> -<a href="' . HTTP_SERVER . DIR_WS_CATALOG . 'account_history_info.php?order_id=' . $insert_id .'">' . EMAIL_TEXT_INVOICE_URL . '</a>' ; $Varmailfooter = ''.VARMAILFOOTER.'' ; $VarArticles= ''.EMAIL_TEXT_PRODUCTS_ARTICLES.'' ; $VarModele= ''.EMAIL_TEXT_PRODUCTS_MODELE.'' ; $VarQte= ''.EMAIL_TEXT_PRODUCTS_QTY .'' ; $VarTotal= ''.EMAIL_TEXT_TOTAL.'' ; $VarAddresship = ''.EMAIL_TEXT_DELIVERY_ADDRESS.'' ; $VarAddressbill = ''.EMAIL_TEXT_BILLING_ADDRESS.'' ; $Varmetodpaye = ''.EMAIL_TEXT_PAYMENT_METHOD.'' ; $Vardetail = ''.DETAIL .'' ; $Varhttp = ''.VARHTTP.''; $Varstyle = ''.VARSTYLE.''; $Varshipaddress =''.tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>').''; $Varadpay =''.tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>').''; require(DIR_WS_MODULES . 'email/html_checkout_process.php'); $email_order = $html_email_order ; /*** Begin SalesForce ***/ if (tep_not_null($rep)) { tep_mail($rep['sales_rep_firstname'] . ' ' . $rep['sales_rep_lastname'], $rep['sales_rep_email'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS ); tep_mail($rep['group_rep'], $rep['group_rep_email'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } /*** End SalesForce ***/ // lets start with the email confirmation if (EMAIL_USE_HTML == 'true') { $email_order; } else { //Package Tracking Plus BEGIN $email_order = EMAIL_TEXT_GREETING . "\n" . EMAIL_SEPARATOR . "\n" . STORE_NAME . EMAIL_INVOICE . "\n" . //Package Tracking Plus END EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . //Package Tracking Plus BEGIN EMAIL_TEXT_INVOICE_URL . ' ' . "<a HREF='" . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL') . "'>" . 'order_id=' . $insert_id . "</a>\n" . //Package Tracking Plus END 'Email: ' . $order->customer['email_address'] . "\n" . 'TLF: ' . $order->customer['telephone'] . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; if ($order->info['comments']) { + $email_order .= tep_db_output($order->info['comments']) . "\n\n"; } /*** Begin SalesForce ***/ if ($order->info['sales_rep_id']) { $sales_reps_query = tep_db_query("select s.sales_rep_firstname, s.sales_rep_lastname, s.sales_rep_email, g.group_rep, g.group_rep_email from " . TABLE_SALES_REPS . " s left join " . TABLE_SALES_GROUPS . " g on s.sales_rep_group = g.group_id where sales_rep_id = " . (int)$order->info['sales_rep_id'] . " LIMIT 1 "); $rep = tep_db_fetch_array($sales_reps_query); $salesRep = 'Sales Person: ' . tep_db_output($rep['sales_rep_firstname'] . ' ' . $rep['sales_rep_lastname']) . "\n\n"; $email_order .= $salesRep; } /*** End SalesForce ***/ $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . EMAIL_SEPARATOR . "\n" . $products_ordered . EMAIL_SEPARATOR . "\n"; for ($i=0; $i<sizeof($order_totals); $i++) { $email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n"; } if ($order->content_type != 'virtual') { $email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $sendto, 0, '', "\n") . "\n"; } $email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $billto, 0, '', "\n") . "\n\n"; if (is_object($$payment)) { $email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . EMAIL_SEPARATOR . "\n"; $payment_class = $$payment; $email_order .= $payment_class->title . "\n\n\n\n\n"; if ($payment_class->email_footer) { $email_order .= $payment_class->email_footer . "\n\n"; } } $email_order .= "\n" . EMAIL_TEXT_FOOTER . "\n" . HTTP_SERVER . DIR_WS_CATALOG . "\n" . EMAIL_TEXT_FOOTERR . "\n" ; } // Order Number in Customer Order Emails v 1.0 // tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, nl2br($email_order), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, ''); $new_mail_subject = EMAIL_TEXT_SUBJECT . ' - ' . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id; //tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], $new_mail_subject, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); //Package Tracking Plus BEGIN tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], STORE_NAME . ' ' . EMAIL_TEXT_SUBJECT_1 . ' ' . $insert_id . ' ' . EMAIL_TEXT_SUBJECT_2 , $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); //Package Tracking Plus END // Order Number in Customer Order Emails v 1.0 $email_order=ereg_replace("[[:alpha:]]+://[^<>[:space:]]+[[:alnum:]/]","<a href=\"\\0\">\\0</a>", $email_order); /*** Begin SalesForce ***/ if (tep_not_null($rep)) { tep_mail($rep['sales_rep_firstname'] . ' ' . $rep['sales_rep_lastname'], $rep['sales_rep_email'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS ); tep_mail($rep['group_rep'], $rep['group_rep_email'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } /*** End SalesForce ***/ // send emails to other people if (SEND_EXTRA_ORDER_EMAILS_TO != '') { $email_order = $html_email_order ; if (EMAIL_USE_HTML == 'true') { $email_order; } else { $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" . 'Email: ' . $order->customer['email_address'] . "\n" . 'TLF: ' . $order->customer['telephone'] . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; if ($order->info['comments']) { + $email_order .= tep_db_output($order->info['comments']) . "\n\n"; } $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . EMAIL_SEPARATOR . "\n" . $products_ordered . EMAIL_SEPARATOR . "\n"; for ($i=0; $i<sizeof($order_totals); $i++) { $email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n"; } if ($order->content_type != 'virtual') { $email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $sendto, 0, '', "\n") . "\n"; } $email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $billto, 0, '', "\n") . "\n\n"; if (is_object($$payment)) { $email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . EMAIL_SEPARATOR . "\n"; $payment_class = $$payment; $email_order .= $payment_class->title . "\n\n\n\n\n"; if ($payment_class->email_footer) { $email_order .= $payment_class->email_footer . "\n\n"; } } $email_order .= "\n" . EMAIL_TEXT_FOOTER . "\n" . HTTP_SERVER . DIR_WS_CATALOG . "\n" . EMAIL_TEXT_FOOTERR . "\n" ; } /*** Begin SalesForce ***/ if (tep_not_null($rep)) { tep_mail($rep['sales_rep_firstname'] . ' ' . $rep['sales_rep_lastname'], $rep['sales_rep_email'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS ); tep_mail($rep['group_rep'], $rep['group_rep_email'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } /*** End SalesForce ***/ // send emails to other people if (SEND_EXTRA_ORDER_EMAILS_TO != '') { // Order Number in Customer Order Emails v 1.0 // tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); // tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, $new_mail_subject, $email_order, $order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address']); //Package Tracking Plus BEGIN tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, STORE_NAME . ' ' . EMAIL_TEXT_SUBJECT_1 . ' ' . $insert_id . ' ' .EMAIL_TEXT_SUBJECT_2, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); //Package Tracking Plus END // Order Number in Customer Order Emails v 1.0 } }
  9. bhbilbao

    SalesForce

    In 13) In catalog/account_history_info.php, I think is best to change to this:
  10. bhbilbao

    SalesForce

    Other extrange bug. ¿? I renamed the groups. Then i renamed the sales persons. Now in checkout_shipping.php in the select dropdown menu the options are duplicated. why?
  11. bhbilbao

    Seperate Pricing Per Customer v3.5

    Jan , need help SPPC + CUSTOM PRODUCT BUILDER After adding a new custom to the shoping cart, there is no description of the product in shoping_cart.php page. The name of the new product is right (Build #16993) but there is no description of the componentes chosen. I modified to this in includes/modules/builder_add_attribute.php tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (NULL, '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "', '" . (int)$products_options_sort_order . "', '@')"); The problem is here: catalog/includes/classes/shopping_cart.php Before, working: if (is_numeric($products_id) && is_numeric($qty) && ($attributes_pass_check == true)) { $check_product_query = tep_db_query("select products_status from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $check_product = tep_db_fetch_array($check_product_query); //Custom Begin if (($check_product !== false)) { //Custom End if ($notify == true) { ... After, not working: if (is_numeric($products_id) && is_numeric($qty) && ($attributes_pass_check == true)) { //$check_product_query = tep_db_query("select products_status from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); //$check_product = tep_db_fetch_array($check_product_query); //Custom Begin // if (($check_product !== false)) { //Custom End // BOF SPPC attribute hide check, original query expanded to include attributes $check_product_query = tep_db_query("select p.products_status, options_id, options_values_id, IF(find_in_set('" . $this->cg_id . "', attributes_hide_from_groups) = 0, '0', '1') as hide_attr_status from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_ATTRIBUTES . " using(products_id) where p.products_id = '" . (int)$products_id . "'"); while ($_check_product = tep_db_fetch_array($check_product_query)) { $check_product[] = $_check_product; } // end while ($_check_product = tep_db_fetch_array($check_product_query)) $no_of_check_product = count($check_product); if (is_array($attributes)) { foreach($attributes as $attr_option => $attr_option_value) { $valid_option = '0'; for ($x = 0; $x < $no_of_check_product ; $x++) { if ($attr_option == $check_product[$x]['options_id'] && $attr_option_value == $check_product[$x]['options_values_id']) { $valid_option = '1'; if ($check_product[$x]['hide_attr_status'] == '1') { // delete hidden attributes from array attributes unset($attributes[$attr_option]); } } // end if ($attr_option == $check_product[$x]['options_id'].... } // end for ($x = 0; $x < $no_of_check_product ; $x++) if ($valid_option == '0') { // after having gone through the options for this product and not having found a matching one // we can conclude that apparently this is not a valid option for this product so remove it unset($attributes[$attr_option]); } } // end foreach($attributes as $attr_option => $attr_option_value) } // end if (is_array($attributes)) // now attributes have been checked and hidden and invalid ones deleted make the $products_id_string again $products_id_string = tep_get_uprid($products_id, $attributes); if ((isset($check_product) && tep_not_null($check_product)) && ($check_product[0]['products_status'] == '1')) { // EOF SPPC attribute hide check if ($notify == true) { ...
  12. bhbilbao

    Custom Product Builder

    TENCENTS, I need help. Instaled CPB + SPPC (Separate price per customer). The problem is after finishing the build and click "Add to Cart". The product is added but the is no description of the options selected in the shoping_cart.php page (Atributes+options) I modified to this in includes/modules/builder_add_attribute.php tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (NULL, '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "', '" . (int)$products_options_sort_order . "', '@')"); This is right, the problem is in includes/classes/shopping_cart.php SPPC modify it too much. And the description fail. If I use the standard archive without modifications it works.
  13. bhbilbao

    Custom Computer Creator v9 Support

    Does anybody got working CCC+ SPPC (Separate price per customer). I have dificults to make both working. When adding a new Custom to the shoping cart it gets an error. Fatal error: Call to undefined method shoppingCart::get_customer_group_id() Problems with integrate these lines with SPPC: /includes/classes/shopping_cart.php if (is_numeric($products_id) && is_numeric($qty) && ($attributes_pass_check == true)) { $check_product_query = tep_db_query("select products_status from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $check_product = tep_db_fetch_array($check_product_query); //Custom Computer Creator Begin if (($check_product !== false)) { //Custom Computer Creator End can anyone copy&paste his code to compare???
  14. bhbilbao

    SalesForce

    ok. I will try again . probably I tested it inserting the same email adress for both. Thanks.
  15. bhbilbao

    SalesForce

    I have this working. I needed that when a customer makes an order on the shop, the confirmation email arrives to the Salesman he select before on the checkout_shiping.php Does anybody have the code for this??
  16. bhbilbao

    Multi-Stores Multiple Shops Support

    I have this installed and feels to works write. I have questions for other people that have tried it. Is there any important contribution incompatible with multi-store??? I have for example administrator Leves Acounts v2 and i see that this contribution carry a similar version of it.
  17. bhbilbao

    Multi_Vendor_Shipping new thread

    i will start the project from 0,based on other contrib multi-store_v2 and then integrate the mvs+suppliersV2+suppliers Admin+Administration Level Accounts. I see that there are different contributions but they are no integrated. Thanks Jim.
  18. bhbilbao

    Multi_Vendor_Shipping new thread

    Jim, new question. When a order is placed on the online shop the vendor automatically receives an email with the products asigned to it. I need a function to send the email to 2diferent adress. One to the vendor and other one to a email adress based on a zone (Zone ID).
  19. Other problem with this contrib: Supplier Admin Area Contribution They share the same database names. i dont know what to do.
  20. bhbilbao

    [Contribution] Products Specifications

    Yes probably the Javascript. +AJAX Atributes +AJAX products set +Hide Products (SHP) +Suppliersv2 +Extra fielsd My categories.php filesize is 208KB. The standard OSC is 64KB. Im using the default categories.php of your contrib, renamed and linked as "Products Specifications" In the main categories.php i edit the product normally with the description. Then if I want to asign Specs click the other link and goes fast. I can change from one product to other and replace the specs faster.
  21. bhbilbao

    Supplier Admin Area Contribution

    My problem is that I have other SuppliersV2 contrib installed. They share the same database names and this dont work. Any suggestion?
  22. bhbilbao

    [Contribution] Products Specifications

    Oh! that sounds fantastic Jim. For the moment I have the contribution installed but using the old categories.php and product_info.php. You save me on using and pay for IceCat Spreadsheet. One more thing, I saw when integrating the code in admin/categories.php the page takes long to load (about 2-4 seconds). You scroll down the page and inmediatly goes to the begining. Its extrange to explain. It should be interesting to take the specs menu out from the product editor and edit the specs in other page like the clasic page of the atributes. I have been trying making a categories2.php and adding other line on column_left "Products Specs" only with the code for the specs. But not tested completely.
  23. bhbilbao

    Custom Product Builder

    problaby you copy&paste in a wrong location. if () { ------------------; } else { CPB } This is may code: // CPB infobox on index only if (isset($HTTP_GET_VARS['products_id'])) { } else { if (isset($cPath) && tep_not_null($cPath)) { } else { // Custom Product Builder if (substr(basename($PHP_SELF), 0, 12) != 'builder_main') { include(DIR_WS_BOXES . 'builder.php'); } Try to copy the following code above the categories code and try: // Custom Product Builder if (substr(basename($PHP_SELF), 0, 12) != 'builder_main') { include(DIR_WS_BOXES . 'builder.php'); }
  24. bhbilbao

    Concept Multistore

    I Need a MultiStore solution. I dont know what how many contributions are for this cause. I only saw this: Multi-Shop http://addons.oscommerce.com/info/3623 but is from 5 Oct 2005. Or if there any tricks with other contribs as Administration Level Acounts. I need sugest or advice.
  25. bhbilbao

    [Contribution] Products Specifications

    Thanks Jim, I will try the maner you said. But I think the work is similar because you must change the name, product_code, image, web link, weight, etc. Same or more work. Introducing the Specs and Filters is not problem at all, if I have time and patience. The problem is on introducing the specs one by one. From the options I think the fast way is the Checkbox Option. Also asking you if a maner to introduce only one checkbox for all languages. I have 3 languages instaled, and for example, for a "3MB Spec" I must click and check 3 times, It should be fine to be an option to check only one spec to all languages (I saw Multidropdown but I tested it and it dont make im saying). Im not a profesional coder like you. Im designer. Looking the spec database of the products (products_specifications) I see that is the only one than changes, the other ones are the "base" with the specs root. Looking this: products_specification_id products_id specifications_id language_id specification 121 16227 49 3 2200 122 16227 50 3 2mb 125 16227 49 1 2200 126 16227 50 1 2mb 129 16227 49 2 2200 130 16227 50 2 2mb 100 16210 49 3 2400 101 16210 50 3 4mb 102 16210 49 1 2400 103 16210 50 1 4mb 104 16210 49 2 2400 105 16210 50 2 4mb 112 16230 49 3 2600 113 16230 50 3 4mb 115 16230 49 1 2600 116 16230 50 1 4mb 118 16230 49 2 2600 119 16230 50 2 4mb 114 16230 58 3 Dual Core 117 16230 58 1 Dual Core 120 16230 58 2 Dual Core 123 16227 58 3 Single Core 124 16227 59 3 AM2 127 16227 58 1 Single Core 128 16227 59 1 AM2 131 16227 58 2 Single Core 132 16227 59 2 AM2 We can see that our product (product_id #16227) has 3 specs asigned x 3 languages = total 6 specs. I say a BUTTON to copy those specs from the product #16227 to other product of the catalog (ot to entire category). this maner: create a new products_specification_id (autoincrement) for the other product maintaining specifications_id language_id specification There is other contribs that makes this in similar maner (Product Sets, Ajax Atributes or Atribute Cloner & Copier), with them you can create a sets of Atributes and copy them to other product very fast. Thats all. Thanks in advance.
×