Jump to content
Sign in to follow this  
cmichalski

MVS 1.1.1 orders_by_vendor.php

Recommended Posts

Hi all looking for some insight here. Been working on this for hours and hours...

 

Let get my config out of the way....

 

OsCommerce CRE-LOADED 6.15

PHP Version 4.4.4

Database Host: localhost (127.0.0.1)

Database: MySQL 4.1.18-nt

Server Date: 02/18/2007 11:22:17

HTTP Server: Microsoft-IIS/5.0

 

Okay I have this module working Great but last few details is orders_by_vendors.php

No error reported. I have tried to echo data through out the file to see where it stops... It seems that it wont continue through the file to pull the data from the orders by vendors db query. I am by no means a programer (YET) I am working hard at learning this but a bit confused on the this one since the db query is different than I am used to seeing. ( NOT SAYING ITS WRONG) just cornfused... I have checked the DEMO site and I am JEALOUS that it works and mine don't !!!

 

<?php
/*

  orders_by_vendor.php V1.0 2006/03/25
        by Craig Garrison Sr
        www.blucollarsales.com
 for MVS V1.0 2006/03/25 JCK/CWG
 osCommerce, Open Source E-Commerce Solutions
 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]

 Copyright © 2006 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_CLASSES . 'currencies.php');
 $currencies = new currencies();
 $vendor_query_raw = "select vendors_id as id, vendors_name as name from " . TABLE_VENDORS . " order by name";
 $vendor_query = tep_db_query($vendor_query_raw);
 if (isset($vID)) {
 $vendors_id = $vID;
 }
 if ($by == 'date') {
 $by = 'date_purchased';
 } elseif ($by == 'customer'){
 $by = 'customers_id';
 } elseif ($by == 'customer'){
 $by = 'status';
 } elseif ($by == 'sent'){
 $by == 'sent';
 } else {
 $by = 'orders_id';
 }

 if (isset($line)){
 $line == $line;
 } else {
 $line = 'desc';
 }

 ?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
       </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
          <table border="0" width="100%" cellspacing="0" cellpadding="2">
           <tr>
           <?php

   $vendors_array = array(array('id' => '1', 'text' => 'NONE'));
   $vendors_query = tep_db_query("select vendors_id, vendors_name from " . TABLE_VENDORS . " order by vendors_name");
   while ($vendors = tep_db_fetch_array($vendors_query)) {
     $vendors_array[] = array('id' => $vendors['vendors_id'],
                                    'text' => $vendors['vendors_name']);
                             }
   ?>
    <td class="main" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id) . '"><b>Click to reset form</a></b>';?></td>
    <td class="main" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS) . '"><b>Go To Vendors List</a>';?>
    <td>
    </tr>
       <tr>
         <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif','1','5'); ?></td>
       <tr>
         <td colspan="3"><?php echo tep_black_line(); ?></td>
       </tr>
       <tr>
         <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif','1','5'); ?></td>
       </tr>
    <tr>
    <td class="main" align="left"><?php echo tep_draw_form('vendors_report', FILENAME_ORDERS_VENDORS) . TABLE_HEADING_VENDOR_CHOOSE . ' '; ?><?php echo tep_draw_pull_down_menu('vendors_id', $vendors_array,'','onChange="this.form.submit()";');?></form></td>

  <td class="main" align="left"><?php echo 'Filter by email sent: <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $line . '&sent=yes') . '"><b>YES</a></b>  <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $line . '&sent=no') . '"><b>NO</a></b>'; ?></td>
     <?php if ($line == 'asc') {
              if(isset($status)) {  ?>
               <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=desc' . '&sent=' . $sent . '&status=' . $status) . '"><b>DESCENDING</a></b> order'; ?></td>
          <?php   } else {      ?>
               <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=desc' . '&sent=' . $sent) . '"><b>DESCENDING</a></b> order'; ?></td>
              <?php  }  ?>
     <?php } elseif (!isset($status)) {
     ?>        <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=asc' . '&sent=' . $sent) . '"><b>ASCENDING</a></b> order'; ?></td>
     <?php  } else {     ?>
               <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=asc' . '&sent=' . $sent . '&status=' . $status) . '"><b>ASCENDING</a></b> order'; ?></td>
     <?php }  ?>
     <?php
$orders_statuses = array();
 $orders_status_array = array();
 $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_statuses[] = array('id' => $orders_status['orders_status_id'],
                              'text' => $orders_status['orders_status_name']);
   $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];
 }
?>
               <td class="main" align="right"><?php echo tep_draw_form('status_report', FILENAME_ORDERS_VENDORS . '?&vendors_id=' . $vendors_id) . HEADING_TITLE_STATUS . ' '; echo tep_draw_pull_down_menu('status', $orders_statuses, '','onChange="this.form.submit()";');?></form></td>
             </tr>
           </table><?php
// if (isset($HTTP_POST_VARS['vendors_id'])) { ?>
           <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_VENDOR; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_ORDER_ID; ?></td>
               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_STATUS; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_SENT; ?> </td>
             </tr>

<?php

 $vend_query_raw = "select vendors_name as name from " . TABLE_VENDORS . " where vendors_id = '" . $vendors_id . "'";
 $vend_query = tep_db_query($vend_query_raw);
 $vendors = tep_db_fetch_array($vend_query); ?>
 <tr class="dataTableRow">
    <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS, '&vendors_id=' . $vendors_id . '&action=edit') . '" TARGET="_blank"><b>' . $vendors['name'] . '</a></b>'; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
               <td class="dataTableContent" align="right">Click To<br>Send Email</td>
             </tr>
 <?php
  $index1 = 0 ;
  if ($sent == 'yes'){
  $vendors_orders_data_query = tep_db_query("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' and vendor_order_sent='yes' group by orders_id " . $line . "");
 } elseif ($sent == 'no') {
  $vendors_orders_data_query = tep_db_query("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' and vendor_order_sent='no' group by orders_id " . $line . "");
   } else {
    $vendors_orders_data_query = tep_db_query("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' group by orders_id " . $line . "");
    }
  while ($vendors_orders_data = tep_db_fetch_array($vendors_orders_data_query))  {

   //  $vendors_orders_id = $vendors_orders_list_data['orders_id'];
   //  $vendors_products_id = $vendors_orders_list_data['v_products_id'];
  $index2 = 0 ;
 $vendors_products_data_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION ." where products_id='" . $vendors_orders_data['v_products_id'] . "' and language_id = '" . $languages_id . "'");
  //  while ($vendors_products_data = tep_db_fetch_array($vendors_products_data_query)) {

            $index3 = 0;
            if (isset($status)) {
   $orders_query = tep_db_query("select distinct o.customers_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = '" . $status . "' and o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' and o.orders_id =  '" . $vendors_orders_data['orders_id'] . "' order by o." . $by . " ASC");
         } else {
   $orders_query = tep_db_query("select distinct o.customers_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' and o.orders_id =  '" . $vendors_orders_data['orders_id'] . "' order by o." . $by . " ASC");
   }
  while ($vendors_orders = tep_db_fetch_array($orders_query)) {

  $raw_date_purchased = $vendors_orders['date_purchased'];

               if (tep_not_null($raw_date_purchased)) {
               list($date_2, $time_2) = explode(' ', $raw_date_purchased);
           list($year, $month, $day) = explode('-', $date_2);

           $date_purchased = ((strlen($day) == 1) ? '0' . $day : $day) . '/' .
                           ((strlen($month) == 1) ? '0' . $month : $month) .
                           '/' .
                           $year;

                           }

     ?>
                       <tr class="dataTableRow">
               <td class="dataTableContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $vendors_orders_data['orders_id'] . '&action=edit') . '" TARGET="_blank"><b>View this order</b></a>'; ?></td>
                    <td class="dataTableContent" align="left"><?php echo $vendors_orders['orders_id']; ?></td>
               <!--     <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product&pID=' . $vendors_orders_data['v_products_id']) . '" TARGET="_blank"><b>' . $vendors_products_data['products_name'] . '</a>'; ?></td>  -->
               <td class="dataTableContent"><?php echo ' from <a href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $vendors_orders['customers_id'] . '&action=edit') . '" TARGET="_blank"><b>' . $vendors_orders['customers_name'] . '</b></a>'; ?></td>
               <td class="dataTableContent" align="left"><?php echo strip_tags($vendors_orders['order_total']); ?></td>
               <td class="dataTableContent" align="left"><?php echo $date_purchased; ?></td>
               <td class="dataTableContent" align="left"><?php echo $vendors_orders['orders_status_name']; ?></td>
               <td class="dataTableContent" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS_EMAIL_SEND, '&vID=' . $vendors_id . '&oID=' . $vendors_orders_data['orders_id'] . '&vOS=' . $vendors_orders_data['vendor_order_sent']) . '"><b>' . $vendors_orders_data['vendor_order_sent'] . '</a></b>'; ?></td>
             </tr>
<?
       $index3++;
       }
     $index2++;
     //}
  $index1++;
   }

?>


           </table></td>
         </tr>
         </table></td>
     </tr>
   </table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

Can't for the world of me figure why mine is not working when everyone else has it working... Maybe my SQL version or PHP Version... I can mess with the code to get it to produce the no/yes repeated for how many order the DB shows which is 5 orders and I can eve have it send the email but the email contains no order info nor does the order by vendors.php page

 

Sorry to bable so much but this has kicked my *SS :blink: If someone could give me some guidence it would be greatly apprciated !!!!

 

To all of you that have contributed and put so much time in this I personally appreciate your efforts its been the hardest hack yet for me although I have owrked most everything out since I have crappy cre-loaded this was purchased out of desperation. If knew now what I knew then I would have modded osc 2.2 myself.... OH well kinda to far into this to stop now...

 

 

Thanks,

Craig

Share this post


Link to post
Share on other sites

Crap didn't mean to start a new topic sorry MODDERATOR

 

Hi all looking for some insight here. Been working on this for hours and hours...

 

Let get my config out of the way....

 

OsCommerce CRE-LOADED 6.15

PHP Version 4.4.4

Database Host: localhost (127.0.0.1)

Database: MySQL 4.1.18-nt

Server Date: 02/18/2007 11:22:17

HTTP Server: Microsoft-IIS/5.0

 

Okay I have this module working Great but last few details is orders_by_vendors.php

No error reported. I have tried to echo data through out the file to see where it stops... It seems that it wont continue through the file to pull the data from the orders by vendors db query. I am by no means a programer (YET) I am working hard at learning this but a bit confused on the this one since the db query is different than I am used to seeing. ( NOT SAYING ITS WRONG) just cornfused... I have checked the DEMO site and I am JEALOUS that it works and mine don't !!!

 

<?php
/*

  orders_by_vendor.php V1.0 2006/03/25
        by Craig Garrison Sr
        www.blucollarsales.com
 for MVS V1.0 2006/03/25 JCK/CWG
 osCommerce, Open Source E-Commerce Solutions
 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]

 Copyright © 2006 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_CLASSES . 'currencies.php');
 $currencies = new currencies();
 $vendor_query_raw = "select vendors_id as id, vendors_name as name from " . TABLE_VENDORS . " order by name";
 $vendor_query = tep_db_query($vendor_query_raw);
 if (isset($vID)) {
 $vendors_id = $vID;
 }
 if ($by == 'date') {
 $by = 'date_purchased';
 } elseif ($by == 'customer'){
 $by = 'customers_id';
 } elseif ($by == 'customer'){
 $by = 'status';
 } elseif ($by == 'sent'){
 $by == 'sent';
 } else {
 $by = 'orders_id';
 }

 if (isset($line)){
 $line == $line;
 } else {
 $line = 'desc';
 }

 ?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
       </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
          <table border="0" width="100%" cellspacing="0" cellpadding="2">
           <tr>
           <?php

   $vendors_array = array(array('id' => '1', 'text' => 'NONE'));
   $vendors_query = tep_db_query("select vendors_id, vendors_name from " . TABLE_VENDORS . " order by vendors_name");
   while ($vendors = tep_db_fetch_array($vendors_query)) {
     $vendors_array[] = array('id' => $vendors['vendors_id'],
                                    'text' => $vendors['vendors_name']);
                             }
   ?>
    <td class="main" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id) . '"><b>Click to reset form</a></b>';?></td>
    <td class="main" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS) . '"><b>Go To Vendors List</a>';?>
    <td>
    </tr>
       <tr>
         <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif','1','5'); ?></td>
       <tr>
         <td colspan="3"><?php echo tep_black_line(); ?></td>
       </tr>
       <tr>
         <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif','1','5'); ?></td>
       </tr>
    <tr>
    <td class="main" align="left"><?php echo tep_draw_form('vendors_report', FILENAME_ORDERS_VENDORS) . TABLE_HEADING_VENDOR_CHOOSE . ' '; ?><?php echo tep_draw_pull_down_menu('vendors_id', $vendors_array,'','onChange="this.form.submit()";');?></form></td>

  <td class="main" align="left"><?php echo 'Filter by email sent: <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $line . '&sent=yes') . '"><b>YES</a></b>  <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $line . '&sent=no') . '"><b>NO</a></b>'; ?></td>
     <?php if ($line == 'asc') {
              if(isset($status)) {  ?>
               <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=desc' . '&sent=' . $sent . '&status=' . $status) . '"><b>DESCENDING</a></b> order'; ?></td>
          <?php   } else {      ?>
               <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=desc' . '&sent=' . $sent) . '"><b>DESCENDING</a></b> order'; ?></td>
              <?php  }  ?>
     <?php } elseif (!isset($status)) {
     ?>        <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=asc' . '&sent=' . $sent) . '"><b>ASCENDING</a></b> order'; ?></td>
     <?php  } else {     ?>
               <td class="main" align="right"><?php echo 'Change to <a href="' . tep_href_link(FILENAME_ORDERS_VENDORS, '&vendors_id=' . $vendors_id . '&line=asc' . '&sent=' . $sent . '&status=' . $status) . '"><b>ASCENDING</a></b> order'; ?></td>
     <?php }  ?>
     <?php
$orders_statuses = array();
 $orders_status_array = array();
 $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_statuses[] = array('id' => $orders_status['orders_status_id'],
                              'text' => $orders_status['orders_status_name']);
   $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];
 }
?>
               <td class="main" align="right"><?php echo tep_draw_form('status_report', FILENAME_ORDERS_VENDORS . '?&vendors_id=' . $vendors_id) . HEADING_TITLE_STATUS . ' '; echo tep_draw_pull_down_menu('status', $orders_statuses, '','onChange="this.form.submit()";');?></form></td>
             </tr>
           </table><?php
// if (isset($HTTP_POST_VARS['vendors_id'])) { ?>
           <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_VENDOR; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_ORDER_ID; ?></td>
               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
               <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_STATUS; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_SENT; ?> </td>
             </tr>

<?php

 $vend_query_raw = "select vendors_name as name from " . TABLE_VENDORS . " where vendors_id = '" . $vendors_id . "'";
 $vend_query = tep_db_query($vend_query_raw);
 $vendors = tep_db_fetch_array($vend_query); ?>
 <tr class="dataTableRow">
    <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS, '&vendors_id=' . $vendors_id . '&action=edit') . '" TARGET="_blank"><b>' . $vendors['name'] . '</a></b>'; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
    <td class="dataTableContent"><?php echo ''; ?></td>
               <td class="dataTableContent" align="right">Click To<br>Send Email</td>
             </tr>
 <?php
  $index1 = 0 ;
  if ($sent == 'yes'){
  $vendors_orders_data_query = tep_db_query("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' and vendor_order_sent='yes' group by orders_id " . $line . "");
 } elseif ($sent == 'no') {
  $vendors_orders_data_query = tep_db_query("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' and vendor_order_sent='no' group by orders_id " . $line . "");
   } else {
    $vendors_orders_data_query = tep_db_query("select distinct orders_id, vendor_order_sent from " . TABLE_ORDERS_SHIPPING . " where vendors_id='" . $vendors_id . "' group by orders_id " . $line . "");
    }
  while ($vendors_orders_data = tep_db_fetch_array($vendors_orders_data_query))  {

   //  $vendors_orders_id = $vendors_orders_list_data['orders_id'];
   //  $vendors_products_id = $vendors_orders_list_data['v_products_id'];
  $index2 = 0 ;
 $vendors_products_data_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION ." where products_id='" . $vendors_orders_data['v_products_id'] . "' and language_id = '" . $languages_id . "'");
  //  while ($vendors_products_data = tep_db_fetch_array($vendors_products_data_query)) {

            $index3 = 0;
            if (isset($status)) {
   $orders_query = tep_db_query("select distinct o.customers_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = '" . $status . "' and o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' and o.orders_id =  '" . $vendors_orders_data['orders_id'] . "' order by o." . $by . " ASC");
         } else {
   $orders_query = tep_db_query("select distinct o.customers_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' and o.orders_id =  '" . $vendors_orders_data['orders_id'] . "' order by o." . $by . " ASC");
   }
  while ($vendors_orders = tep_db_fetch_array($orders_query)) {

  $raw_date_purchased = $vendors_orders['date_purchased'];

               if (tep_not_null($raw_date_purchased)) {
               list($date_2, $time_2) = explode(' ', $raw_date_purchased);
           list($year, $month, $day) = explode('-', $date_2);

           $date_purchased = ((strlen($day) == 1) ? '0' . $day : $day) . '/' .
                           ((strlen($month) == 1) ? '0' . $month : $month) .
                           '/' .
                           $year;

                           }

     ?>
                       <tr class="dataTableRow">
               <td class="dataTableContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $vendors_orders_data['orders_id'] . '&action=edit') . '" TARGET="_blank"><b>View this order</b></a>'; ?></td>
                    <td class="dataTableContent" align="left"><?php echo $vendors_orders['orders_id']; ?></td>
               <!--     <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product&pID=' . $vendors_orders_data['v_products_id']) . '" TARGET="_blank"><b>' . $vendors_products_data['products_name'] . '</a>'; ?></td>  -->
               <td class="dataTableContent"><?php echo ' from <a href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $vendors_orders['customers_id'] . '&action=edit') . '" TARGET="_blank"><b>' . $vendors_orders['customers_name'] . '</b></a>'; ?></td>
               <td class="dataTableContent" align="left"><?php echo strip_tags($vendors_orders['order_total']); ?></td>
               <td class="dataTableContent" align="left"><?php echo $date_purchased; ?></td>
               <td class="dataTableContent" align="left"><?php echo $vendors_orders['orders_status_name']; ?></td>
               <td class="dataTableContent" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS_EMAIL_SEND, '&vID=' . $vendors_id . '&oID=' . $vendors_orders_data['orders_id'] . '&vOS=' . $vendors_orders_data['vendor_order_sent']) . '"><b>' . $vendors_orders_data['vendor_order_sent'] . '</a></b>'; ?></td>
             </tr>
<?
       $index3++;
       }
     $index2++;
     //}
  $index1++;
   }

?>
           </table></td>
         </tr>
         </table></td>
     </tr>
   </table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Can't for the world of me figure why mine is not working when everyone else has it working... Maybe my SQL version or PHP Version... I can mess with the code to get it to produce the no/yes repeated for how many order the DB shows which is 5 orders and I can eve have it send the email but the email contains no order info nor does the order by vendors.php page

 

Sorry to bable so much but this has kicked my *SS :blink: If someone could give me some guidence it would be greatly apprciated !!!!

 

To all of you that have contributed and put so much time in this I personally appreciate your efforts its been the hardest hack yet for me although I have owrked most everything out since I have crappy cre-loaded this was purchased out of desperation. If knew now what I knew then I would have modded osc 2.2 myself.... OH well kinda to far into this to stop now...

Thanks,

Craig

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×