Jump to content

bdownes

Members
  • Content count

    69
  • Joined

  • Last visited

Profile Information

  • Real Name
    Jared Geesey
  • Website
  1. bdownes

    Batch Order Center Update 1.1

    Hey David! I got it to work!!! I changed one letter in the code h.comments is now o.comments And it works great! Thanks for such a great contribution! Bobby
  2. bdownes

    Batch Order Center Update 1.1

    On line 44 it reads if ($HTTP_POST_VARS['show_comments']) { $get_customer_comments = ' and h.orders_status_id = ' . DEFAULT_ORDERS_STATUS_ID; } if ($HTTP_POST_VARS['pull_status']){ $pull_w_status = " and o.orders_status = ". $HTTP_POST_VARS['pull_status']; } $orders_query = tep_db_query("select o.orders_id,h.comments,MIN(h.date_added) from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS_HISTORY . " h where o.date_purchased between '" . tep_db_input($startdate) . "' and '" . tep_db_input($enddate) . "23:59:59' and h.orders_id = o.orders_id" . $pull_w_status . $get_customer_comments . ' group by o.orders_id'); At around line 239 it reads $pos -= SECTION_DIVIDER; if ($orders['comments']) { $pdf->ezSetY($pos); $pdf->ezText("<b>Comments:</b>\n" . $orders['comments'],GENERAL_FONT_SIZE); } This seems to be getting the data from the Orders table. I just don't know enough about funneling data from the database to the php file. I would be willing to pay for help on this. Thanks! Bobby
  3. bdownes

    Batch Order Center Update 1.1

    When the check box is checked next to: Show orders without comments? (Will NOT show order with comments placed by the customer at time of order.) Then this is when the Comments on the PDF read.... Comments: The comments for your order are Automatic order update notification. What code do I put in the string to tell batch_print to get the comments from the ORDERS table? Thanks a ton! When our staff came in this morning they were thrilled about this update! Thank you, Thank you, Thank you! Bobby
  4. bdownes

    Batch Order Center Update 1.1

    Using a November 2002 version. The comments field is in the ORDERS Table. Via phpMyAdmin I can see all of the custumer comments in there. Is it as simple as telling the batch_print.php to get the data from the ORDERS table? Or are there other places that must be changed as well? Thanks, Bobby
  5. bdownes

    Batch Order Center Update 1.1

    Hi David, On about line 42 of admin/batch_print.php we find: $pdf->selectFont(BATCH_PDF_DIR . 'Helvetica.afm'); $pdf->setFontFamily(BATCH_PDF_DIR . 'Helvetica.afm'); if ($HTTP_POST_VARS['show_comments']) { $get_customer_comments = ' and h.orders_status_id = ' . DEFAULT_ORDERS_STATUS_ID; } if ($HTTP_POST_VARS['pull_status']){ $pull_w_status = " and o.orders_status = ". $HTTP_POST_VARS['pull_status']; } $orders_query = tep_db_query("select o.orders_id,h.comments,MIN(h.date_added) from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS_HISTORY . " h where o.date_purchased between '" . tep_db_input($startdate) . "' and '" . tep_db_input($enddate) . "23:59:59' and h.orders_id = o.orders_id" . $pull_w_status . $get_customer_comments . ' group by o.orders_id'); Is this where I would change the IF statement to pull data from the orders table? Not sure how to do this. Bobby
  6. bdownes

    Batch Order Center Update 1.1

    Found the define('PRODUCT_ATTRIBUTES_TEXT_WRAP', false); in the english/batch_print.php My brain was tired. Sorry
  7. bdownes

    Batch Order Center Update 1.1

    Hi David, Regarding the Comments field on the PDF, here is what I am getting on the PDF... Comments: The comments for your order are Automatic order update notification. The above note shows up in every PDF report even when there are comments in the actual order. How do I tie the comments field that our site currently uses into this comments field in the order_status_history comments field (which is what I believe the PDF is using... is that correct?). The "comments" field I use is currently located in my "orders" table. Thoughts? Thanks! Bobby
  8. bdownes

    Batch Order Center Update 1.1

    Hi David, Forgive my ignorance. Which file is define('PRODUCT_ATTRIBUTES_TEXT_WRAP', false); located in? Thanks, Bobby PS. I found some of those font size controls and it looks great now for my set up.
  9. Quick Updates is a great contribution that will speed up your ability to update product pricing in the Admin without having to individual product pages to make the updates. When a product is also listed in the Specials area, Quick Updates will not allow updating of the database info (product name, pricing etc). Which makes it rather useless if ALL of your products are discounted. Anyone know how to make it override this feature? Thanks! Bobby
  10. bdownes

    Batch Order Center Update 1.1

    Also, how do I make the font size smaller for the text on the PDF form? Some of my text is doubled up over the top of other text because my product names are longer. Thanks! Bobby
  11. bdownes

    Batch Order Center Update 1.1

    Radders, That worked great!!! Thank you! Now trying to add the Comments to the PDF form. Is that a quick addition to make? Any tips? Thanks! Bobby PS. This is gong to be SOOOO much better than printing orders one by one by one.
  12. bdownes

    Batch Order Center Update 1.1

    Just installed the Batch Order Center Update 1.1 and am getting the following error. 1054 - Unknown column 'h.comments' in 'field list' select o.orders_id,h.comments,MIN(h.date_added) from orders o, orders_status_history h where o.date_purchased between '2004-02-27' and '2004-02-2823:59:59' and h.orders_id = o.orders_id and o.orders_status = 1 and h.orders_status_id = 1 group by o.orders_id [TEP STOP] Anyone have a clue what this means? And how to fix it? Thanks! Bobby
  13. bdownes

    NewsDesk v 1.3 Released!

    Dice, Are you able to control the number of articles that show up now that it is working? Using the controls in the Admin or making the changes to the database itself. I was getting the same error as you and just removed... // set application wide parameters // this query set is for NewsDesk $configuration_query = tep_db_query("select configuration_key as cfgKey, configuration_value as cfgValue from " . TABLE_NEWSDESK_CONFIGURATION . ""); while ($configuration = tep_db_fetch_array($configuration_query)) { define($configuration['cfgKey'], $configuration['cfgValue']); } And mine NewsDesk does not return an error. BUT, I now have no control over how many articles show up on the front page (just 3 article summaries show up... and I want more than that.) I have all of 1.3 installed, with the exception of the code above that I removed from the catalog/includes/modules/newsdesk.php By the way, I am using the Latest News Box and it works great! I can control the number of headlines that show up there. See http://www.christiancinema.com/catalog/newsdesk.php Bobby
  14. bdownes

    NewsDesk v1.2 Relased!

    1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_NEWSDESK_NEWS' at line 4 select p.newsdesk_id, pd.language_id, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, p.newsdesk_image, p.newsdesk_date_added, p.newsdesk_last_modified, p.newsdesk_date_available, p.newsdesk_status from newsdesk p, newsdesk_description pd WHERE pd.newsdesk_id = p.newsdesk_id and pd.language_id = "1" and newsdesk_status = 1 ORDER BY newsdesk_date_added DESC LIMIT MAX_DISPLAY_NEWSDESK_NEWS [TEP STOP] Just did an upgrade to 1.2 overwriting the previous files AND updating each of the lines in application_top.php Any thought on what this could be? Thanks! Bobby
  15. bdownes

    Featured products mod

    HTTP Server: Apache/1.3.26 (Unix) PHP/4.2.2 FrontPage/4.0.4.3 PHP Version: 4.2.2 (Zend: 1.2.0) Is what my server is configured as. Thanks,
×