| 
      
            Lines 2198-2204
          sub GetLateOrders {
      
      
        Link Here
      
     | 
  
        
          | 2198 | 
              if ($dbdriver eq "mysql") { | 
          2198 | 
              if ($dbdriver eq "mysql") { | 
        
        
          | 2199 | 
                  $select .= "  | 
          2199 | 
                  $select .= "  | 
        
        
          | 2200 | 
                  aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,  | 
          2200 | 
                  aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,  | 
        
          
            
              | 2201 | 
                      (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * " . _get_rounding_sql("aqorders.rrp") . " AS subtotal, | 
              2201 | 
                      (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,  | 
            
        
          | 2202 | 
                  DATEDIFF(CAST(now() AS date),closedate) AS latesince  | 
          2202 | 
                  DATEDIFF(CAST(now() AS date),closedate) AS latesince  | 
        
        
          | 2203 | 
                  ";  | 
          2203 | 
                  ";  | 
        
        
          | 2204 | 
                  print STDERR "C4/Acquisition.pm 9\n";  | 
          2204 | 
                  print STDERR "C4/Acquisition.pm 9\n";  | 
        
  
    | 
      
            Lines 2211-2217
          sub GetLateOrders {
      
      
        Link Here
      
     | 
  
        
          | 2211 | 
                  # FIXME: account for IFNULL as above  | 
          2211 | 
                  # FIXME: account for IFNULL as above  | 
        
        
          | 2212 | 
                  $select .= "  | 
          2212 | 
                  $select .= "  | 
        
        
          | 2213 | 
                          aqorders.quantity                AS quantity,  | 
          2213 | 
                          aqorders.quantity                AS quantity,  | 
        
          
            
              | 2214 | 
                              aqorders.quantity * "._get_rounding_sql("aqorders.rrp")." AS subtotal, | 
              2214 | 
                              aqorders.quantity * aqorders.rrp AS subtotal,  | 
            
        
          | 2215 | 
                          (CAST(now() AS date) - closedate)            AS latesince  | 
          2215 | 
                          (CAST(now() AS date) - closedate)            AS latesince  | 
        
        
          | 2216 | 
                  ";  | 
          2216 | 
                  ";  | 
        
        
          | 2217 | 
                  print STDERR "C4/Acquisition.pm 10\n";  | 
          2217 | 
                  print STDERR "C4/Acquisition.pm 10\n";  | 
        
            
              | 2218 | 
              -   | 
               | 
               |