Subversion Repositories SmartDukaan

Rev

Rev 2842 | Rev 2851 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2842 Rev 2850
Line 10... Line 10...
10 
import time
 10 
import time
11 
from datetime import date
 11 
from datetime import date
12 
from textwrap import dedent
 12 
from textwrap import dedent
13 
from string import Template
 13 
from string import Template
14 
 
 14 
 
15 
from sqlalchemy.sql.expression import and_, or_, desc
 15 
from sqlalchemy.sql.expression import and_, or_, desc, not_
16 
from sqlalchemy.sql import func
 16 
from sqlalchemy.sql import func
17 
 
 17 
 
18 
from elixir import *
 18 
from elixir import *
19 
 
 19 
 
20 
from reportlab.pdfgen.canvas import Canvas
 20 
from reportlab.pdfgen.canvas import Canvas
Line 591... Line 591...
591 
        alert.comment = comment
 591 
        alert.comment = comment
592 
        alert.time_set = datetime.datetime.now()
 592 
        alert.time_set = datetime.datetime.now()
593 
    session.commit()
593 
    session.commit()
594 
 
 594 
 
595 
def get_valid_order_count():
 595 
def get_valid_order_count():
596 
    return Order.query.filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).count()
 596 
    return Order.query.filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).filter(not_(Order.status.in_( (OrderStatus.SALES_RET_RESHIPPED, OrderStatus.DOA_INVALID_RESHIPPED, OrderStatus.DOA_RESHIPPED) ))).count()
597 
 
 597 
 
598 
def get_cust_count_with_successful_txn():
 598 
def get_cust_count_with_successful_txn():
599 
    return session.query(Order.customer_id).filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).distinct().count()
 599 
    return session.query(Order.customer_id).filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).distinct().count()
600 
 
 600 
 
601 
def get_valid_orders_amount_range():
 601 
def get_valid_orders_amount_range():