Jump to content

litaliacool

Members
  • Content count

    31
  • Joined

  • Last visited

Profile Information

  1. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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. litaliacool

    [CONTRIBUTION] PDF Customer Invoice

    Any one help me please?
  5. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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
  9. litaliacool

    Quotes

    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. litaliacool

    [CONTRIBUTION] PDF Customer Invoice

    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. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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. litaliacool

    Quotes

    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. litaliacool

    Custom Product Builder

    :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
×