时间处理

5-11 代码总结
一 . 将数据库中的运单的信息显示在一个表格里

@route('/manager/waybill/manage')class WaybillManageHandler(BaseHandler):    def get(self):        # 获取所有的运单信息        all_waybills = self.db.Waybill.find({        "status": 0    })    # 获取开始时间和终止时间    data = []    for i in all_waybills:        tmp_dict = {}        a = time.localtime(i["createtime"])        tmp_dict["createtime"] = str(a.tm_year) + "-" + str(a.tm_mon) + "-" + str(a.tm_mday) + "/" + str(a.tm_hour) + ":" + str(a.tm_min) + ":" + str(a.tm_sec)        a = time.localtime(i["arrivaltime"])         tmp_dict["arrivaltime"] = str(a.tm_year) + "-" + str(a.tm_mon) + "-" + str(a.tm_mday) + "/" +  str(a.tm_hour) + ":" + str(a.tm_min) + ":" + str(a.tm_sec)        tmp_dict["destination"] = i["destination"]        tmp_dict["origin"] = i["origin"]        tmp_dict["status" ] = i["status"]        tmp_dict["freight"] = self.db.Freight.find_one({"_id":i["freight"]})["freight"]        tmp_dict["user"] = self.db.User.find_one({"_id":i["user"]})["contact"]        b = i["content"]["name"]        c = i["content"]["count"]        tmp_dict["content"] = str(b) + "-" + str(c)        data.append(tmp_dict)    return self.render("waybill-manage.html", data=data, all_waybills=all_waybills)

1.根据运单的状态从数据库中取出status=0的全部运单信息
2. 首先将通过循环将运单信息依次处理,通过虚构一个字典放入将要展示在前端的数据
3. 依次处理要显示在页面的运单信息
1）数据createtime , arrivaltime

    将时间戳转换成时间：        通过 time.local(所得时间戳)        可有，a = time.localtime(i["createtime"])    （ps: arrivaltime方法一样）        通过字符串连接处理所得数据         tmp_dict["createtime"] = str(a.tm_year) + "-" + str(a.tm_mon) + "-" + str(a.tm_mday) + "/" + str(a.tm_hour) + ":" + str(a.tm_min) + ":" + str(a.tm_sec)

2）表Waybills直接存储的数据，无需转换，只需依次给字典赋值

    tmp_dict["destination"] = i["destination"]    tmp_dict["origin"] = i["origin"]    tmp_dict["status" ] = i["status"]

3）取出与其他表相关联的数据

    tmp_dict["user"] = self.db.User.find_one({"_id":i["user"]})["contact"]    b = i["content"]["name"]    c = i["content"]["count"]    tmp_dict["content"] = str(b) + "-" + str(c)    通过 _id 找到与该数据相关联的数据表，再通过键值对获得所需数据

二. 页面搜索框实现通过 origin, destination 对表格内容的搜索

@route('/manager/waybill/find')

class WaybillFindHandler(BaseHandler):

def get(self):    origin = self.get_argument("origin")    destination = self.get_argument("destination")    _filter = {"$and":[{"origin": origin},{"destination": destination},{"status": 0}]}    if origin == "" and destination == "":        #显示所有        return self.redirect('/manager/waybill/manage')    if origin == "" and destination != "":        #显示特定目的地        _filter = {"$and":[{"destination": destination},{"status": 0}]}    if origin != "" and destination == "":        _filter = {"$and":[{"origin":origin}, {"status": 0}]}    all_waybills = self.db.Waybill.find(_filter)    data = []    if all_waybills.count() != 0:        for i in all_waybills:            tmp_dict = {}            a = time.localtime(i["createtime"])            tmp_dict["createtime"] = str(a.tm_year) + "-" + str(a.tm_mon) + "-" + str(a.tm_mday) + "/" + str(a.tm_hour) + ":" + str(a.tm_min) + ":" + str(a.tm_sec)            a = time.localtime(i["arrivaltime"])            tmp_dict["arrivaltime"] = str(a.tm_year) + "-" + str(a.tm_mon) + "-" + str(a.tm_mday) + "/" +  str(a.tm_hour) + ":" + str(a.tm_min) + ":" + str(a.tm_sec)            tmp_dict["destination"] = i["destination"]            tmp_dict["origin"] = i["origin"]            tmp_dict["status" ] = i["status"]            tmp_dict["freight"] = self.db.Freight.find_one({"_id":i["freight"]})["freight"]            tmp_dict["user"] = self.db.User.find_one({"_id":i["user"]})["contact"]            b = i["content"]["name"]            c = i["content"]["count"]            tmp_dict["content"] = str(b) + "-" + str(c)            data.append(tmp_dict)        return self.render("waybill-manage.html", data=data, all_waybills=all_waybills, errcode=0)    else:        return self.render("waybill-manage.html", data=data, errcode=1)

1.通过self.get_argument(“name”)获得已选的出发地，目的地

    origin = self.get_argument("origin")    destination = self.get_argument("destination")

2. 通过 判断 origin,destination的值来将搜索内容进行分类，

1）origin != "" and destination != ""   #显示所有    _filter = {"$and":[{"origin":origin},{"destination":destination},{"status":0}]}2） origin != "" and destination == ""   #显示特定目的地     _filter = {"$and":[{"origin":origin},{"status":0}]}3）origin == "" and destination != ""   #显示特定目的地    _filter = {"$and":[{"destination":destination},{"status":0}]}

3. 将搜索条件分类完毕，通过它获得取出数据库中的全部搜索内容

all_waybills = self.db.Waybill.find(_filter)

4. 最后获得了搜索的全部运单信息。操作就回到了将一个数据表单展示在前端页面的工作，具体如上（一）