예제 #1
0
def get_positions_count(userids):
    dtt = form.getvalue("dt","-1");
    dttt = []
    dttt = dtt.split("mm")
    dtt = "between '"+py_db.sh_to_mil(dttt[0])+" "+dttt[1]+":00' and '"+py_db.sh_to_mil(dttt[2])+" "+dttt[3]+":00' "
    sqlst = "select count(*)  from `tbl_gps_positions` WHERE  g_sat_count  > 5 and  g_user_id in ({1})  and g_date {0} ".format(dtt,userids)
    print 'Content-Type: text/html; charset=utf-8'
    print ""
    print py_db.executeAndReturnRows(sqlst)[0][0].__str__()
예제 #2
0
def get_pos(sel2):
    dtt = form.getvalue("dt2","-1");
    ttl = form.getvalue("totalrows","-1")
    dttt = []
    dttt = dtt.split("mm")
    dtt = "between '"+py_db.sh_to_mil(dttt[0])+" "+dttt[1]+":00' and '"+py_db.sh_to_mil(dttt[2])+" "+dttt[3]+":00' "
  
    sqlst ="""SELECT w.* FROM (SELECT @row := @row + 1 AS _ROW, t.* FROM `tbl_gps_positions` t,(SELECT @row:=0) r WHERE g_sat_count  > 5 and  g_user_id IN ({0})  AND g_date {1} ORDER BY g_date DESC ) w WHERE MOD(_ROW,{2})=0  """.format(sel2,dtt,ttl)
    rows = py_db.executeAndReturnRows(sqlst)
    str = ""
    i=0
    for row in rows :
        if i==0:
            str = "{0}!{1}!{2}!{3}!{4}".format(row[2].__str__(),row[3].__str__(),row[4].__str__(), py_db.mil_to_sh_with_time(row[6].__str__()),row[7].__str__())
        else:
            str = str+"cz{0}!{1}!{2}!{3}!{4}".format(row[2].__str__(),row[3].__str__(),row[4].__str__(),py_db.mil_to_sh_with_time(row[6].__str__()),row[7].__str__())
        i+=1
    print 'Content-Type: text/html; charset=utf-8'
    print ""
    print str
    rows = dta.split("sazw")
    for row in rows:
        r = row.split("zzz")
        
        if r[0]=="_obj_chk_unread":
            if r[1]=="true": sds =sds+ " i_position = 1 "
        if r[0]=="_obj_chk_read":
            if r[1]=="true": sds =sds+ " or i_position = 2 "
        if r[0]=="_obj_chk_sent":
            if r[1]=="true": sds =sds+ " or i_position = 3 "
        if r[0]=="_obj_chk_baygani":
            if r[1]=="true":
                sds =sds+ " or i_active_user_link = 43160 "
                baygani=1
        
        if r[0]=="_obj_from": sds =sds+ "and i_date_of_create between '"+py_db.sh_to_mil(r[1])+"' and "
        if r[0]=="_obj_to": sds =sds+ " '"+py_db.sh_to_mil(r[1])+"' "
        if r[0]=="_obj_search": sds=sds+ """
        ) AND (    
        ((i_order LIKE '%{0}%') OR 
        (l_subject LIKE '%{0}%') OR
        (l_letter_number LIKE '%{0}%') OR
        (((SELECT tbl_secretrait_letters.sl_secretariat_no FROM tbl_secretrait_letters WHERE sl_letter_link=i_letter_link LIMIT 1)) LIKE '%{0}%') OR 
        ((SELECT u_complete_name FROM tbl_users WHERE u_name='{1}' ) LIKE '%{0}%') OR 
        ((SELECT u_complete_name FROM tbl_users WHERE u_id=i_prev_active_user_link ) LIKE '%{0}%'))  
            )""".format(r[1],py_db.username)
    if sds[0:3]==" or": sds=sds[4:len(sds)]
    if sds[0:4]==" and": sds=sds[5:len(sds)]
#    print sds