Subversion Repositories SmartDukaan

'''
Created on 26-Mar-2010

@author: ashish
'''
import datetime
import time
from shop2020.utils import OrderStatus

status_active = 0
status_retired = 1
status_deleted = 2
status_paused = 3
status_added = 4


def to_py_date(java_timestamp):
    seconds = java_timestamp / 1000
    sub_seconds  = (java_timestamp % 1000.0) / 1000.0
    date = datetime.datetime.fromtimestamp(seconds + sub_seconds)
    
    return date

def to_java_date(py_timestamp):
    return int(time.mktime(py_timestamp.timetuple())) * 1000 + py_timestamp.microsecond / 1000

def get_status_fdate_tdate(status, from_date, to_date):
    current_from_date = ""
    current_to_date = ""
    current_status = ""
    
    if status:
        current_status = OrderStatus.get_c_status(status)
    if from_date:
        current_from_date = to_py_date(from_date)   
    if to_date:
        current_to_date = to_py_date(to_date)
    
    return  current_status, current_from_date, current_to_date

def get_mssql_date(date):
    mssql_date_year = str(date.year)
    if date.month < 10:
        mssql_date_month = "0%d"%(date.month)
    else:
        mssql_date_month = str(date.month)
        
    if date.day < 10:
        mssql_date_day = "0%d"%(date.day)
    else:
        mssql_date_day = str(date.day)
        
    mssql_date = "%s%s%s"%(mssql_date_year,mssql_date_month, mssql_date_day)
    return int(mssql_date)

def get_mssql_time(date):
    mssql_date_hour = str(date.hour)
    if date.minute < 10:
        mssql_date_minute = "0%d"%(date.minute)
    else:
        mssql_date_minute = str(date.minute)
        
    if date.day < 10:
        mssql_date_second = "0%d"%(date.second)
    else:
        mssql_date_second = str(date.second)
        
    mssql_date = "%s%s%s"%(mssql_date_hour,mssql_date_minute, mssql_date_second)
    return int(mssql_date)