PCinvent.info

Virtuemart Report Status Enhancement

Open the php file

/administrator/components/com_virtuemart/html/reportbasic.index.php

around lin22, under

$interval = mosGetParam( $_REQUEST, "interval", "byMonth" );

add this

$order_status = mosGetParam( $_REQUEST, "order_status", "orderAll" );//www.PCinvent.com Set initial

around line 174, under

$end_date = mktime(23,59,59,date("n")+1,0,date("Y")); $interval = "byMonth";

add this

$order_status = "orderAll"; //www.PCinvent.com Default value

around line203, under

$query_between_line = "WHERE cdate BETWEEN '" . $start_date . "' AND '" . $end_date . "' ";

add this

/*-----------------------------------------------------------------
The Following Code is written by Andy Ng < This e-mail address is being protected from spam bots, you need JavaScript enabled to view it >
Webmaster Blog Site: www.PCinvent.info
Group Company Site: www.pcinvent.com
Please do not removed the above credits/copyrights
-----------------------------------------------------------------*/
/* start of www.PCinvent.com report status */
 switch ($order_status) {
    case 'orderAll':
     $query_date_line .= '';//do nothing
     break;
   case 'orderPending':
     $query_between_line .= "AND #__{vm}_orders.order_status='P' "; // Limit status
     break;
   case 'orderConfirmed':
     $query_between_line .= "AND #__{vm}_orders.order_status='C' "; // Limit status
     break;
   case 'orderCancelled':
     $query_between_line .= "AND #__{vm}_orders.order_status='X' "; // Limit status
     break;
   case 'orderRefunded':
     $query_between_line .= "AND #__{vm}_orders.order_status='R' "; // Limit status
     break;
   case 'orderShipped':
     $query_between_line .= "AND #__{vm}_orders.order_status='S' "; // Limit status
     break;
   default:
     $query_between_line .= '';
    break;
  }

/* end of www.PCinvent.com report status */

around line, under

<td><?php echo $VM_LANG->_PHPSHOP_RB_INTERVAL_TITLE; ?></td>

          <td><input type="radio" id="byMonth" name="interval" value="byMonth" <?php if($interval=="byMonth") echo "checked='checked'" ?> />
          <label for="byMonth"><?php echo $VM_LANG->_PHPSHOP_RB_INTERVAL_MONTHLY_TITLE ?></label>    
          <input type="radio" name="interval" id="byWeek" value="byWeek" <?php if($interval=="byWeek") echo "checked='checked'" ?> />
          <label for="byWeek"><?php echo $VM_LANG->_PHPSHOP_RB_INTERVAL_WEEKLY_TITLE; ?></label>    
          <input type="radio" name="interval" id="byDay" value="byDay" <?php if($interval=="byDay") echo "checked='checked'" ?> />
          <label for="byDay"><?php echo $VM_LANG->_PHPSHOP_RB_INTERVAL_DAILY_TITLE; ?></label></td>

add this table row

         <tr><?php //www.PCinvent.com Report status enhancement ?>
          <td>Status</td>
          <td><input type="radio" id="orderAll" name="order_status" value="orderAll" <?php if($order_status=="orderAll") echo "checked='checked'" ?> />
            <label for="orderAll">All</label>
            <input type="radio" id="orderPending" name="order_status" value="orderPending" <?php if($order_status=="orderPending") echo "checked='checked'" ?> />
            <label for="orderPending">Pending</label>
            <input type="radio" id="orderConfirmed" name="order_status" value="orderConfirmed" <?php if($order_status=="orderConfirmed") echo "checked='checked'" ?> />
<label for="orderConfirmed">Confirmed</label>
<input type="radio" id="orderCanceleld" name="order_status" value="orderCanceleld" <?php if($order_status=="orderCanceleld") echo "checked='checked'" ?> />
<label for="orderCancelled">Cancelled</label>
<input type="radio" id="orderRefunded" name="order_status" value="orderRefunded" <?php if($order_status=="orderRefunded") echo "checked='checked'" ?> />
<label for="orderRefunded">Refunded</label>
<input type="radio" id="orderShipped" name="order_status" value="orderShipped" <?php if($order_status=="orderShipped") echo "checked='checked'" ?> />
<label for="orderShipped">Shipped</label></td>
        </tr>

Now, you will see the exactly result shown in the screenshot below. 

Previous
left arrow key Next
right arrow key Close Move

loading..

Comments (9)

...
written by Mori, February 06, 2008

Thanks for your sharing. This is the one I am looking for.

...
written by Andy Ng, February 12, 2008

Great! What kind of project you are working on?

...
written by mark, December 15, 2008

Great idea! Thanks for the code.

A small tweak will get it working ---
CHANGE:

...
written by mark, December 15, 2008

change:

...
written by mark, December 15, 2008

Sorry about the double post - I was figuring the HTML would have been converted to entities. Here's the correction need to get the code working....

change:

>input type="radio" id="orderCanceleld" name="order_status" value="orderCanceleld" >?php if($order_status=="orderCanceleld") echo "checked='checked'" ?< /<

to:

>input type="radio" id="orderCancelled" name="order_status" value="orderCancelled" >?php if($order_status=="orderCancelled") echo "checked=´checked´" ?< /<

...
written by mark, December 15, 2008

oops, of course change the > and < around

...
written by J`eff, April 05, 2009

I can't program, but this is just what I was thinking,
I am in taiwan, and thanks for the code.

...
written by admin, April 10, 2009

For HTML Code post here, I will figure out how to solve this problem.
Anyway, thanks for the post, mark!

...
written by Thong Tran, May 19, 2009

Thanks for sharing

Name

Website

Comment

Add Comment