Changeset 9984 for trunk/aff/finance.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/aff/finance.php (modified) (6 diffs)

trunk/aff/finance.php

@@ -41 +41 @@
 {
     $affID = (int)$AFF;
-    $aff_arr = db_arr("SELECT `Percent` FROM `aff` WHERE `ID` = $affID");
+    $aff_arr = db_arr("SELECT `Percent` FROM `sys_aff` WHERE `ID` = $affID");
 }
 else
 {
     $AFF = process_db_input($AFF);
-    $aff_arr = db_arr("SELECT `ID`, `Percent` FROM `aff` WHERE `email` = '$AFF'");
+    $aff_arr = db_arr("SELECT `ID`, `Percent` FROM `sys_aff` WHERE `email` = '$AFF'");
     $affID = (int)$aff_arr['ID'];
 }
@@ -63 +63 @@
 {
     case 'total':
-        $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND `Status` = 'approved' ORDER BY `Date` DESC";
+        $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND `Status` = 'approved' ORDER BY `Date` DESC";
         break;
 
@@ -69 +69 @@
         $order_id = process_db_input( $_POST['tr_order_num'] );
         $tr['order_num'] = process_pass_data( $_POST['tr_order_num'] );
-        $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND `gtwTransactionID` = '$order_id' AND `Status` = 'approved' ORDER BY `Date` DESC";
+        $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND `gtwTransactionID` = '$order_id' AND `Status` = 'approved' ORDER BY `Date` DESC";
         $order_num_disabled = "";
         break;
@@ -76 +76 @@
         $last_days = (int)$_POST['tr_last_days'];
         $tr['last_days'] = process_pass_data( $_POST['tr_last_days'] );
-        $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND ( TO_DAYS( NOW() ) - TO_DAYS( `Date` ) <= $last_days ) AND `Status` = 'approved' ORDER BY `Date` DESC";
+        $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND ( TO_DAYS( NOW() ) - TO_DAYS( `Date` ) <= $last_days ) AND `Status` = 'approved' ORDER BY `Date` DESC";
         $last_disabled = "";
         break;
@@ -85 +85 @@
         if ( $exact_date != -1 )
         {
-            $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND TO_DAYS( FROM_UNIXTIME($exact_date) ) = TO_DAYS( `Date` ) AND `Status` = 'approved' ORDER BY `Date` DESC";
+            $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND TO_DAYS( FROM_UNIXTIME($exact_date) ) = TO_DAYS( `Date` ) AND `Status` = 'approved' ORDER BY `Date` DESC";
         }
         else
@@ -115 +115 @@
         if ( $between_date1 != -1 && $between_date2 != -1 )
         {
-            $tr_query = "SELECT `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND ( 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 `ID`, `IDMember`, `IDProvider`, `gtwTransactionID`, DATE_FORMAT(`Date`,  '$date_format' ) AS 'Date', `Amount`, `Currency`, `Status`, `Data`, `Description`, `Note` FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE `idAff` = $affID AND ( 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