Subversion Repositories SmartDukaan

Rev

Rev 104 | Rev 122 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
103 ashish 1 
'''
2 
Created on 26-Mar-2010
3 
 
4 
@author: ashish
5 
'''
104 ashish 6 
import datetime
7 
import time
8 
from shop2020.utils import OrderStatus
103 ashish 9 
 
10 
status_active = 0
11 
status_retired = 1
12 
status_deleted = 2
13 
status_paused = 3
14 
status_added = 4
15 
 
104 ashish 16 
 
17 
def to_py_date(java_timestamp):
18 
    seconds = java_timestamp / 1000
19 
    sub_seconds  = (java_timestamp % 1000.0) / 1000.0
20 
    date = datetime.datetime.fromtimestamp(seconds + sub_seconds)
21 
 
22 
    return date
23 
 
24 
def to_java_date(py_timestamp):
25 
    return int(time.mktime(py_timestamp.timetuple())) * 1000 + py_timestamp.microsecond / 1000
26 
 
27 
def get_status_fdate_tdate(status, from_date, to_date):
28 
    current_from_date = ""
29 
    current_to_date = ""
30 
    current_status = ""
31 
 
32 
    if status:
33 
        current_status = OrderStatus.get_c_status(status)
34 
    if from_date:
35 
        current_from_date = to_py_date(from_date)
36 
    if to_date:
37 
        current_to_date = to_py_date(to_date)
38 
 
39 
    return  current_status, current_from_date, current_to_date
115 ashish 40 
 
41 
def get_mssql_date(date):
42 
    mssql_date_year = str(date.year)
43 
    if date.month < 10:
44 
        mssql_date_month = "0%d"%(date.month)
45 
    else:
46 
        mssql_date_month = str(date.month)
47 
 
48 
    if date.day < 10:
49 
        mssql_date_day = "0%d"%(date.day)
50 
    else:
51 
        mssql_date_day = str(date.day)
52 
 
53 
    mssql_date = "%s%s%s"%(mssql_date_year,mssql_date_month, mssql_date_day)
54 
    return int(mssql_date)
55 
 
56 
def get_mssql_time(date):
57 
    mssql_date_hour = str(date.hour)
58 
    if date.minute < 10:
59 
        mssql_date_minute = "0%d"%(date.minute)
60 
    else:
61 
        mssql_date_minute = str(date.minute)
62 
 
63 
    if date.day < 10:
64 
        mssql_date_second = "0%d"%(date.second)
65 
    else:
66 
        mssql_date_second = str(date.second)
67 
 
68 
    mssql_date = "%s%s%s"%(mssql_date_hour,mssql_date_minute, mssql_date_second)
69 
    return int(mssql_date)