Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

litaliacool

Archived
  • Posts

    31
  • Joined

  • Last visited

Posts posted by litaliacool

  1. Frank,

    I don't think that the error is there, although I'm not too hot on code.

    Do you have a test site I could take a look at?

     

    Steve...

     

    Steve

     

    Thanks for having a look.... I dont have a test site!!! bit of a sod...

     

    Any ideas would be greatly appreciated....Thats for you as well JACK...

     

    Frank

  2. Frank,

    I don't think that the error is there, although I'm not too hot on code.

    Do you have a test site I could take a look at?

     

    Steve...

     

    Steve

     

    Thanks for having a look.... I dont have a test site!!! bit of a sod...

     

    Any ideas would be greatly appreciate....Thats for you as well JACK...

     

    Frank

  3. In admin/quotes.php look for two instances of the word disabled (around line 170) and change to enabled

     

    This will allow you to select the 2 ghosted out buttons in the admin page to email the customer.

     

     

    Steve...

     

    Hi Steve

    That has worked great with the 2 ghosted out buttons thanks very much.

     

    But its not emailing the customers, I think i may have a problem www\product_info.php i have wishlist installed and meny others..

     

    Originel Quotes php

     

    /*** Begin Quotes ***/

    $product_info_query = tep_db_query("select p.products_id, pd.products_name, p.quotes_email_address, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.language_id = '" . (int)$languages_id . "'");

    $product_info = tep_db_fetch_array($product_info_query);

     

    tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$_GET['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

     

    if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

    $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

    } else {

    $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));

    }

    /*** End Quotes ***/

     

    My php

     

    $product_info_query = tep_db_query("select p.products_id, pd.products_name, p.quotes_email_address, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

    $product_info = tep_db_fetch_array($product_info_query);

     

    tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

     

    if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

    $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

    } else {

    $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));

    }

     

    if (tep_not_null($product_info['products_model'])) {

    $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

    } else {

    $products_name = $product_info['products_name'];

    }

    //DISPLAY PRODUCT WAS ADDED TO WISHLIST IF WISHLIST REDIRECT IS ENABLED

     

    What do you think?

     

     

    Thank you

     

    Frank

  4. Can some one help me?

     

    I have independent_invoice_number_v1.2.1 installed and i am trying to get my invoice numbers to show instead of Default invoice numbers (order no) that come up....

    Below is the install code for independent_invoice_number_v1.2.1 dose any one now how to update pdf customer invoice php I have been trying insert it to PDFinvoice.php with no sucsess

     

     

    Any one help me please?

  5. Once the quote is added in the products section, it is a regular product. So, if that product is not showing up on your site, either it is not setup correctly in admin or there is something wrong with the code on the site. I suggest you look closer at the product in admin. Is it enabled? Is the date for when it is active a current date (not expired and not in the future)? Is the quantity at least 1. The same things you would look at for any product. If you can't find a reason, rename the category that you used for the quotes to something else. That will cause the contributions code not to see it and that category should then show up as a regular category. If the product is still not visible, then there is still some mistake in the way it is setup.

     

    Hi Jack

     

    You are right and I was very foolish I had the Products Quantity set to 0

     

    SO I BOW BEFORE YOU

     

    I am going to check the code for the shadowed out radio button ( send client email problem) I get once I have created the product (as per no 3).. Any help on were I should be looking would be greatly appreciated

    Thanks

     

    Frank

  6. Jack

    I know you do this for love..And i do love you...But we,ve got issues....

     

    1 When they click on Quotes in the information box shop side, after they log in to collect there quote they get the quotes page as per the screen shot.

     

    2 They can not add the quote to the shopping cart like a regular product and proceed through to checkout. because there is no link. They can see it.. But not open it.. nor can they add it to cart( what im saying is the link dose not work)....

     

    3 Once i have had a request for a Quote, and created it in Admin/Tools/quotes, by pressing the link to English quotes which takes me to quotes Categories to create a new product, which then i preview, then save, go back to Admin/Tools/quotes, go to press one of the radio button to send client email, But find it shadowed out.

     

    4 I have the same problem with my wife......

  7. I don't know how many times you want me to repeat myself but here goes again: There should not be a quotes category showing on the shop side.

    1 How do they get there quote then?

    2 How would they make there order shop side if they liked the quote?

    3 In admin tools quotes how do i send them the quote when the radio button is ghosted out?

    4 Why dose it say status paid?

  8. Hi Jack

    This is what i get when i log in to quotes....In Categories there is no Quotes categorie..... its all setup in the admin side eg in config also in catalog and i can se the quotes in tools...

     

    I have looked and looked can you please help

     

    Capture.JPG

     

     

     

     

    Frank

  9. Hi Jack

    I checked my code But it is highly modified in places any idea where i should be looking I’ve been using Beyond compare. Do you think it may be the database sequence as there are lots of mods? I would love to uses this feature on my site and would appreciate any advise you could give me..

     

    Frank

  10. Can some one help me?

     

    I have independent_invoice_number_v1.2.1 installed and i am trying to get my invoice numbers to show instead of Default invoice numbers (order no) that come up....

    Below is the install code for independent_invoice_number_v1.2.1 dose any one now how to update pdf customer invoice php I have been trying insert it to PDFinvoice.php with no sucsess

     

     

     

    START HERE

     

     

     

    #####################################

    # Run the following commands against your database (adapt table names if needed) #

    #####################################

     

    INSERT INTO `configuration` VALUES ('', 'Invoice serial prefix', 'INVOICE_SERIAL', 'I-', 'Invoice number prefix', 1, 22, NULL, '2006-12-13 16:34:32', NULL, NULL);

    ALTER TABLE `orders` ADD `invoice_serial` VARCHAR(5) DEFAULT '' NOT NULL AFTER `delivery_address_format_id`;

    ALTER TABLE `orders` ADD `invoice_number` INT DEFAULT '0' NOT NULL AFTER `invoice_serial`;

     

    #########################################

    # Open admin/includes/classes/order.php #

    #########################################

     

     

    FIND:

     

    ========================================

     

    $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

     

    ========================================

     

    REPLACE THIS CODE WITH:

     

    ========================================

     

    $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, invoice_serial, invoice_number, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

     

    ========================================

    ========================================

    ========================================

     

    FIND:

     

    ========================================

     

    $this->billing = array('name' => $order['billing_name'],

    'company' => $order['billing_company'],

    'street_address' => $order['billing_street_address'],

    'suburb' => $order['billing_suburb'],

    'city' => $order['billing_city'],

    'postcode' => $order['billing_postcode'],

    'state' => $order['billing_state'],

    'country' => $order['billing_country'],

    'format_id' => $order['billing_address_format_id']);

     

    ========================================

     

    REPLACE THIS CODE WITH:

     

    ========================================

     

    $this->billing = array('name' => $order['billing_name'],

    'invoice_serial' => $order['invoice_serial'],

    'invoice_number' => $order['invoice_number'],

    'company' => $order['billing_company'],

    'street_address' => $order['billing_street_address'],

    'suburb' => $order['billing_suburb'],

    'city' => $order['billing_city'],

    'postcode' => $order['billing_postcode'],

    'state' => $order['billing_state'],

    'country' => $order['billing_country'],

    'format_id' => $order['billing_address_format_id']);

     

    ========================================

     

    FIND:

     

    ========================================

     

    }

     

    ?>

     

    ========================================

     

    ADD ABOVE:

     

    ========================================

     

     

    function create_invoice($order_id)

    {

    $counter=0;

    while (($this->billing['invoice_number']==0) && ($counter<5))

    {

    $max_query=tep_db_query("select MAX(invoice_number) as invoice from ". TABLE_ORDERS);

    $max_invoice=tep_db_fetch_array($max_query);

    tep_db_query("update ". TABLE_ORDERS . " set invoice_serial='".INVOICE_SERIAL."', invoice_number='".($max_invoice['invoice']+1)."' where orders_id = '" . (int)$order_id . "'");

    // Check to avoid multiple admins generating the same invoice number for different invoices (MyISAM type tables don't support transactions)

    $new_invoice_number_query=tep_db_query("select COUNT(*) as rows from ". TABLE_ORDERS . " where invoice_number='".($max_invoice['invoice']+1)."'");

    $num_invoice=tep_db_fetch_array($new_invoice_number_query);

    if ($num_invoice['rows']==1)

    {

    // OK

    $this->billing['invoice_serial']=INVOICE_SERIAL;

    $this->billing['invoice_number']=$max_invoice['invoice']+1;

    } else

    // More than one invoice has this very same number. Undo

    tep_db_query("update ". TABLE_ORDERS . " set invoice_number='0' where orders_id = '" . (int)$order_id . "'");

    $counter++;

    }

    }

     

    ========================================

    ========================================

    ========================================

     

    #####################################################

    # Open admin/includes/languages/english/invoice.php #

    #####################################################

     

     

    ADD THE FOLLOWING CODE:

     

    define('TEXT_INVOICE', 'INVOICE:');

     

     

    ========================================

    ========================================

    ========================================

     

     

    #####################################################

    # Open admin/includes/languages/espanol/invoice.php #

    #####################################################

     

     

    ADD THE FOLLOWING CODE:

     

    define('TEXT_INVOICE', 'FACTURA:');

     

     

    ========================================

    ========================================

    ========================================

     

    ####################################################

    # Open admin/includes/languages/german/invoice.php #

    ####################################################

     

     

    ADD THE FOLLOWING CODE:

     

    define('TEXT_INVOICE', 'RECHNUNG:');

     

     

    ========================================

    ========================================

    ========================================

     

    ####################################################

    # Open admin/includes/languages/dutch/invoice.php #

    ####################################################

     

     

    ADD THE FOLLOWING CODE:

     

    define('TEXT_INVOICE', 'FACTUUR:');

     

     

    ========================================

    ========================================

    ========================================

     

    ##########################

    # Open admin/invoice.php #

    ##########################

     

    FIND:

     

    ========================================

     

    <!-- body_text //-->

    <table border="0" width="100%" cellspacing="0" cellpadding="2">

     

    ========================================

     

    REPLACE WITH:

     

    ========================================

     

    <!-- body_text //-->

    <table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <td class="pageHeading"><?php $order->create_invoice((int)$oID); echo TEXT_INVOICE.' '.$order->billing['invoice_serial'].$order->billing['invoice_number']; ?></td>

    </tr>

  11. Hi Jack

    I checked my code But it is highly modified in places any idea where i should be looking I’ve been using Beyond compare. Do you think it may be the database sequence as there are lots of mods? I would love to uses this feature on my site and would appreciate any advise you could give me..

     

    Frank

  12. No, the quote directory isn't automatically created. You have to do that. Please see the install instructions for how to set that up.

     

     

    This i know i have made A Quotes Directory.that part is all setup.... i can make a Quote all good... whats not happing when i log in as a buyer the quotes directory dose not appear

     

     

    Also under Admin/tools/quotes the Radio buttons do not send email to the buyer to inform them the quote i ready.

     

    Frank

  13. Sorry jack

    When I go to my website and login as a buyer to fined my Quote, I get

    ID Our Quote Date Quoted Status

    uuuuuuu 11-02-09 Paid

    5555 11-02-09 Paid

    The above are 2 made up test quotes. what I am saying these are not links to the Quote Category

    Correct me if I am wrong I was expecting a new Quotes category to appear in the Categories list holding the quotes then I would press say buy now.

     

     

    Frank

  14. This contribute just what i need...

     

    I have some problems

    under Admin when i have a request i go to lets say tools/quotes/English then make up the Quote then go back to Quotes under tools but Both radio buttons are shadowed out?

     

    Under the site when i login to see the Quote i get some thing like this they are not links, and the Quotes Catalogue dose not a pair

    To request a Quote, please click here.

    ID Our Quote Date Quoted Status

    uuuuuuu 11-02-09 Paid

    5555 11-02-09 Paid

     

     

     

    Thanks

    Frank

  15. In Home and Business

     

    I think your code is great

    What i am trying to do is shadow out both company and tva_intracom(in bold) i think i have part2 right but part1 will not shadow both can you please help?

     

    part1

     

    <td class="main"><?php echo tep_draw_radio_field('usertype', 'h', '', 'onclick=company tva_intracom.disabled=true') . '  ' . HOME . '  ' . tep_draw_radio_field('usertype', 'b', '', 'onclick=company tva_intracom.disabled=false') . '  ' . BUSINESS . ' ' . (tep_not_null(ENTRY_USERTYPE_TEXT) ? '<span class="inputRequirement">' . ENTRY_USERTYPE_TEXT . '</span>': ''); ?></td>

     

     

     

    Part2

     

    <td class="main"><?php echo tep_draw_input_field('company', '', 'disabled') . ' ' . (tep_not_null(ENTRY_COMPANY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TEXT . '</span>': ''); ?></td>

    </tr>

    <!--BOF for VAT INTRACOM_v3.3 //-->

    <tr>

    <td class="main"><?php echo ENTRY_TVA_INTRACOM; ?></td>

    <td class="main"><?php echo tep_draw_input_field('tva_intracom', '', 'disabled') . ' ' . (tep_not_null(ENTRY_TVA_INTRACOM_TEXT) ? '<span class="inputRequirement">' . ENTRY_TVA_INTRACOM_TEXT . '</span>': ''); ?></td>

    </tr>

     

     

    Thanks Frank

  16. In Home and Business

     

    I think your code is great

    what i am trying to do is shadow out both company and tva_intracom(in bold) i think i have part2 right but part1 will not shadow both can you please help?

     

    part1

     

    <td class="main"><?php echo tep_draw_radio_field('usertype', 'h', '', 'onclick=company tva_intracom.disabled=true') . '  ' . HOME . '  ' . tep_draw_radio_field('usertype', 'b', '', 'onclick=company tva_intracom.disabled=false') . '  ' . BUSINESS . ' ' . (tep_not_null(ENTRY_USERTYPE_TEXT) ? '<span class="inputRequirement">' . ENTRY_USERTYPE_TEXT . '</span>': ''); ?></td>

     

     

     

    Part2

     

    <td class="main"><?php echo tep_draw_input_field('company', '', 'disabled') . ' ' . (tep_not_null(ENTRY_COMPANY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TEXT . '</span>': ''); ?></td>

    </tr>

    <!--BOF for VAT INTRACOM_v3.3 //-->

    <tr>

    <td class="main"><?php echo ENTRY_TVA_INTRACOM; ?></td>

    <td class="main"><?php echo tep_draw_input_field('tva_intracom', '', 'disabled') . ' ' . (tep_not_null(ENTRY_TVA_INTRACOM_TEXT) ? '<span class="inputRequirement">' . ENTRY_TVA_INTRACOM_TEXT . '</span>': ''); ?></td>

    </tr>

     

     

    Thanks Frank

  17. 3 things

    1, I dont get a create button just the word?

     

    2, Also i have to go into customers then cllik on a customer to see get create word.

     

    3, And also i can not delete customers?

    :blink:

    Please help i dont Know what i have done?

  18. Simplest solution which will yield links for both contribs

    *** FIND: there are two....change them both
    		<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
    		<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

    replace with

    <!-- BOF Order Maker -->
    		<td class="pageHeading"><?php echo HEADING_TITLE . '<a href="' . tep_href_link(FILENAME_CREATE_ORDER) . '"> Create order </a>'; ?></td>
    <!-- EOF Order Maker -->
    <!-- PWA BOF -->
    		<td class="pageHeading"><?php echo HEADING_TITLE . (($order->customer['is_dummy_account'])? ' <b>no account!</b>':''); ?></td>
    <!-- PWA EOF -->
    		<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

    I believe that should work.

     

     

    Corey

     

    Thanks mate i will give it a go

  19. :blink: In the install doc

     

    7. in catalog/admin/orders.php

     

    *** FIND: there are two....change them both

    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

    <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

     

    *** REPLACE WITH:

    <!-- BOF Order Maker -->

    <td class="pageHeading"><?php echo HEADING_TITLE . '<a href="' . tep_href_link(FILENAME_CREATE_ORDER) . '"> Create order </a>'; ?></td>

    <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

    <!-- EOF Order Maker -->

     

    <_< I have this from Pay Without Account (PWA)

     

    <!-- PWA BOF -->

    <td class="pageHeading"><?php echo HEADING_TITLE . (($order->customer['is_dummy_account'])? ' <b>no account!</b>':''); ?></td>

    <!-- PWA EOF -->

    <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

     

    :blush: I dont Know what to do!!! Can some one help????

×
×
  • Create New...