Changeset 9984 for trunk/admin/finance.php

Timestamp:

04/06/09 22:50:09 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/admin/finance.php (modified) (5 diffs)

trunk/admin/finance.php

@@ -46 +46 @@
 {
     case 'total':
-        $tr_query = "SELECT * FROM `Transactions` WHERE `Status` = 'approved' ORDER BY `Date` DESC";
+        $tr_query = "SELECT * FROM `sys_transactions` WHERE `Status` = 'approved' ORDER BY `Date` DESC";
         break;
 
@@ -52 +52 @@
         $order_id = process_db_input( $_POST['tr_order_num'] );
         $tr['order_num'] = process_pass_data( $_POST['tr_order_num'] );
-        $tr_query = "SELECT * FROM `Transactions` WHERE `gtwTransactionID` = '$order_id' AND `Status` = 'approved' ORDER BY `Date` DESC";
+        $tr_query = "SELECT * FROM `sys_transactions` WHERE `gtwTransactionID` = '$order_id' AND `Status` = 'approved' ORDER BY `Date` DESC";
         $order_num_disabled = "";
         break;
@@ -59 +59 @@
         $last_days = (int)$_POST['tr_last_days'];
         $tr['last_days'] = process_pass_data( $_POST['tr_last_days'] );
-        $tr_query = "SELECT * FROM `Transactions` WHERE ( TO_DAYS( NOW() ) - TO_DAYS( `Date` ) <= $last_days ) AND `Status` = 'approved' ORDER BY `Date` DESC";
+        $tr_query = "SELECT * FROM `sys_transactions` WHERE ( TO_DAYS( NOW() ) - TO_DAYS( `Date` ) <= $last_days ) AND `Status` = 'approved' ORDER BY `Date` DESC";
         $last_disabled = "";
         break;
@@ -68 +68 @@
         if ( $exact_date != -1 )
         {
-            $tr_query = "SELECT * FROM `Transactions` WHERE TO_DAYS( FROM_UNIXTIME($exact_date) ) = TO_DAYS( `Date` ) AND `Status` = 'approved' ORDER BY `Date` DESC";
+            $tr_query = "SELECT * FROM `sys_transactions` WHERE TO_DAYS( FROM_UNIXTIME($exact_date) ) = TO_DAYS( `Date` ) AND `Status` = 'approved' ORDER BY `Date` DESC";
         }
         else
@@ -98 +98 @@
         if ( $between_date1 != -1 && $between_date2 != -1 )
         {
-            $tr_query = "SELECT * FROM `Transactions` WHERE ( TO_DAYS( FROM_UNIXTIME($between_date1) ) <= TO_DAYS( `Date` ) AND TO_DAYS( FROM_UNIXTIME($between_date2) ) >= TO_DAYS( `Date` ) ) AND `Status` = 'approved' ORDER BY `Date` DESC";
+            $tr_query = "SELECT * FROM `sys_transactions` WHERE ( TO_DAYS( FROM_UNIXTIME($between_date1) ) <= TO_DAYS( `Date` ) AND TO_DAYS( FROM_UNIXTIME($between_date2) ) >= TO_DAYS( `Date` ) ) AND `Status` = 'approved' ORDER BY `Date` DESC";
         }
         else