Changeset 647

Show
Ignore:
Timestamp:
04/23/08 07:50:36 (7 months ago)
Author:
stavros
Message:

BUG: DID billing cron job didn't account for postpaid customers' credit limits

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/1.3/A2Billing_AGI/libs_a2billing/crontjob/a2billing_bill_diduse.php

    r253 r647  
    5555 
    5656// CHECK THE CARD WITH DID'S 
    57 $QUERY = "SELECT id_did, reservationdate, month_payed, fixrate, cc_card.id, credit, email, did FROM (cc_did_use INNER JOIN cc_card on cc_card.id=id_cc_card) INNER JOIN cc_did ON (id_did=cc_did.id) WHERE ( releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') AND cc_did_use.activated=1"; 
     57$QUERY = "SELECT id_did, reservationdate, month_payed, fixrate, cc_card.id, credit, email, did, typepaid, creditlimit FROM (cc_did_use INNER JOIN cc_card on cc_card.id=id_cc_card) INNER JOIN cc_did ON (id_did=cc_did.id) WHERE ( releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') AND cc_did_use.activated=1"; 
    5858 
    5959if ($verbose_level>=1) echo "==> SELECT CARD WIHT DID'S QUERY : $QUERY\n"; 
    …… 
    100100                        // THE USER HAVE TO PAY FOR HIS DID NOW 
    101101                         
    102                         if ($mydids[5] >= $mydids[3]) 
     102                        if (($mydids[5] + $mydids[8] * $mydids[9]) >= $mydids[3]) 
    103103                        { 
    104104                                // USER HAVE ENOUGH CREDIT TO PAY FOR THE DID  

  • trunk/Cronjobs/a2billing_bill_diduse.php

    r546 r647  
    5555 
    5656// CHECK THE CARD WITH DID'S 
    57 $QUERY = "SELECT id_did, reservationdate, month_payed, fixrate, cc_card.id, credit, email, did FROM (cc_did_use INNER JOIN cc_card on cc_card.id=id_cc_card) INNER JOIN cc_did ON (id_did=cc_did.id) WHERE ( releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') AND cc_did_use.activated=1"; 
     57$QUERY = "SELECT id_did, reservationdate, month_payed, fixrate, cc_card.id, credit, email, did, typepaid, creditlimit FROM (cc_did_use INNER JOIN cc_card on cc_card.id=id_cc_card) INNER JOIN cc_did ON (id_did=cc_did.id) WHERE ( releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') AND cc_did_use.activated=1"; 
    5858 
    5959if ($verbose_level>=1) echo "==> SELECT CARD WIHT DID'S QUERY : $QUERY\n"; 
    …… 
    100100                        // THE USER HAVE TO PAY FOR HIS DID NOW 
    101101                         
    102                         if ($mydids[5] >= $mydids[3]) 
     102                        if (($mydids[5] + $mydids[8] * $mydids[9]) >= $mydids[3]) 
    103103                        { 
    104104                                // USER HAVE ENOUGH CREDIT TO PAY FOR THE DID  


Google