Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

litaliacool

Archived
  • Posts

    31
  • Joined

  • Last visited

Everything posted by litaliacool

  1. 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. 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. 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. 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
  5. 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......
  6. 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?
  7. 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 Frank
  8. 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
  9. 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>
  10. 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
  11. 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
  12. 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
  13. 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
  14. :blush: How do i get custom produt builder to sit on my admin bar right now its top left. as below Please help Thank You Frank
  15. :rolleyes:You are the man Thanks frank
  16. I dont get borders around my info boxes in firefox but it's ok in IE have a look. please help?? http://www.stage-shop.com/ Thank you Frank
  17. I dont borders around my info boxes in firefox but is ok in IE have a look please?? http://www.stage-shop.com/ Thank you Frank
  18. I hope you can help i have two problemes. Contribution looks great i just want to use it? 1 Dependences as you can see Not Good 2 Not sitting on the admin bar if you look top left Please help
  19. 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
  20. 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
  21. 1 if it is that important. its not i did not know if it had one or not. 2 ok thanks for the info. 3 ok i'm thick. Thanks
  22. 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?
  23. :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...