Example #1
0
    def GET(self):
        params = web.input(page=1)
        try:
            page = int(params.page)
        except:
            page = 1

        limit = PAGE_LIMIT
        start = (page - 1) * limit if page > 0 else 0

        dic = lit(relations='national_deliery_log',
                  fields="*",
                  criteria="",
                  order="id desc",
                  limit=limit,
                  offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2,
                                             "warehousedata", "?page=")
        countries = db.query("SELECT id, name FROM countries ORDER BY name")

        l = locals()
        del l['self']
        return render.warehousedata(**l)
Example #2
0
    def GET(self):
        params = web.input(page=1)
        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        # we start getting requests a month old
        t = cal.parse("2 month ago")[0]
        amonthAgo = '%s-%s-%s' % (t.tm_year, t.tm_mon, t.tm_mday)

        dic = lit(
            relations='requests', fields="*",
            criteria="status='failed' AND cdate > '%s' AND xml_is_well_formed(request_body)" % (amonthAgo),
            order="id desc",
            limit=limit, offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2, "failed", "?page=")

        l = locals()
        del l['self']
        return render.failed(**l)
Example #3
0
    def GET(self):
        params = web.input(page=1)
        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        dic = lit(relations='contacts_contactgroup_counts_view',
                  fields="*",
                  criteria="name <> 'All Contacts'",
                  order="name",
                  limit=limit,
                  offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2,
                                             "ready", "?page=")

        r = db.query(
            "select count from contacts_contactgroup_counts_view where name='All Contacts';"
        )
        total_contacts = r[0].count

        contact_fields = db.query(
            "select id, label from contacts_contactfield order by label;")
        campaigns = db.query("SELECT * from campaigns_view")

        l = locals()
        del l['self']
        return render.reports(**l)
Example #4
0
    def GET(self):
        params = web.input(page=1)
        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        dic = lit(relations='requests',
                  fields="*",
                  criteria=session.criteria,
                  order="id desc",
                  limit=limit,
                  offset=start)
        if session.criteria:
            res = doquery(db, dic)
            count = countquery(db, dic)
            pagination_str = getPaginationString(default(page, 0), count,
                                                 limit, 2, "search", "?page=")

        l = locals()
        del l['self']
        return render.search(**l)
Example #5
0
    def GET(self):
        params = web.input(page=1)
        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        # we start getting requests a month old
        t = cal.parse("2 month ago")[0]
        amonthAgo = '%s-%s-%s' % (t.tm_year, t.tm_mon, t.tm_mday)

        dic = lit(
            relations='requests',
            fields="*",
            criteria=
            "status='failed' AND cdate > '%s' AND xml_is_well_formed(request_body)"
            % (amonthAgo),
            order="id desc",
            limit=limit,
            offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2,
                                             "failed", "?page=")

        l = locals()
        del l['self']
        return render.failed(**l)
Example #6
0
    def GET(self):
        params = web.input(page=1, ed="", d_id="")
        firstname, lastname, email, enabled, utype = ("", "", "", False, "")

        if params.ed:
            pass
            r = db.query("SELECT * FROM users WHERE id = %s" % params.ed)
            if r:
                rx = r[0]
                firstname = rx.firstname
                lastname = rx.lastname
                email = rx.email
                enabled = rx.active
                utype = rx.utype
            del r
        if params.d_id:
            db.query("DELETE FROM users WHERE id=%s" % params.d_id)

        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        dic = lit(relations='users', fields="*", criteria="", order="firstname, lastname", limit=limit, offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2, "users", "?page=")
        l = locals()
        del l['self']
        return render.users(**l)
Example #7
0
    def POST(self):
        params = web.input(
            page=1, reqid=[], submissionid="", request_body="", sdate="", edate="",
            status="", year="", week="", pbtn="")
        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        with db.transaction():
            if params.pbtn == 'Retry Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.update('requests', where="id = %s" % val, status='ready')
            if params.pbtn == 'Cancel Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.delete('requests', where="id = %s" % val)
            db.transaction().commit()

        criteria = "TRUE "
        if params.submissionid:
            criteria += " AND submissionid = %s" % params.submissionid
        if params.status:
            criteria += " AND status = '%s' " % params.status
        if params.sdate:
            criteria += " AND cdate >= '%s'" % params.sdate
        if params.edate:
            criteria += " AND cdate <= '%s'" % params.edate
        if params.week:
            criteria += " AND week = '%s'" % params.week
        if params.request_body:
            criteria += " AND request_body ILIKE '%%%s%%'" % params.request_body
        if params.year:
            criteria += " AND year = '%s'" % params.year
        if params.formatting:
            if params.formatting == "xml":
                criteria += " AND xml_is_well_formed(request_body)"

        print criteria
        if len(criteria) > 5:
            session.criteria = criteria
        dic = lit(
            relations='requests', fields="*",
            criteria=criteria,
            order="id desc",
            limit=limit, offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2, "search", "?page=")

        l = locals()
        del l['self']
        return render.search(**l)
Example #8
0
    def POST(self):
        params = web.input(page=1, reqid=[])
        print params
        try:
            page = int(params.page)
        except:
            page = 1

        with db.transaction():
            if params.pbtn == 'Retry Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.update('requests',
                                  where="id = %s" % val,
                                  status='ready')
            if params.pbtn == 'Delete Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.delete('requests', where="id = %s" % val)
            db.transaction().commit()

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        # we start getting requests a month old
        t = cal.parse("2 month ago")[0]
        amonthAgo = '%s-%s-%s' % (t.tm_year, t.tm_mon, t.tm_mday)

        dic = lit(
            relations='requests',
            fields="*",
            criteria=
            "status='failed' AND cdate > '%s' AND xml_is_well_formed(request_body)"
            % (amonthAgo),
            order="id desc",
            limit=limit,
            offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2,
                                             "failed", "?page=")

        l = locals()
        del l['self']
        return render.failed(**l)
Example #9
0
    def GET(self):
        params = web.input(page=1)
        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        dic = lit(relations='requests', fields="*", criteria="", order="id desc", limit=limit, offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2, "requests", "?page=")

        l = locals()
        del l['self']
        return render.requests(**l)
Example #10
0
    def POST(self):
        params = web.input(
            page=1,
            ed="",
            d_id="",
            firstname="",
            lastname="",
            email="",
            enabled=False,
            utype=""
        )
        firstname, lastname, email, enabled, utype = ("", "", "", False, "")

        with db.transaction():
            active = True if params.enabled == "on" else False
            if params.ed:
                update_sql = (
                    "UPDATE users SET firstname='%s', lastname='%s', email = '%s', "
                    " utype='%s', active = %s WHERE id = %s ")
                update_sql = update_sql % (
                    params.firstname, params.lastname, params.email,
                    params.utype, active, params.ed)
                db.query(update_sql)
            elif not params.ed and not params.d_id:
                #we're inserting
                pass

        try:
            page = int(params.page)
        except:
            page = 1
        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        dic = lit(relations='users', fields="*", criteria="", order="firstname, lastname", limit=limit, offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2, "users", "?page=")

        l = locals()
        del l['self']
        return render.users(**l)
Example #11
0
    def POST(self):
        params = web.input(page=1, reqid=[])
        print params
        try:
            page = int(params.page)
        except:
            page = 1

        with db.transaction():
            if params.pbtn == 'Retry Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.update('requests', where="id = %s" % val, status='ready')
            if params.pbtn == 'Delete Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.delete('requests', where="id = %s" % val)
            db.transaction().commit()

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        # we start getting requests a month old
        t = cal.parse("2 month ago")[0]
        amonthAgo = '%s-%s-%s' % (t.tm_year, t.tm_mon, t.tm_mday)

        dic = lit(
            relations='requests', fields="*",
            criteria="status='failed' AND cdate > '%s' AND xml_is_well_formed(request_body)" % (amonthAgo),
            order="id desc",
            limit=limit, offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2, "failed", "?page=")

        l = locals()
        del l['self']
        return render.failed(**l)
Example #12
0
    def POST(self):
        params = web.input(page=1,
                           reqid=[],
                           submissionid="",
                           request_body="",
                           sdate="",
                           edate="",
                           status="",
                           year="",
                           week="",
                           pbtn="")
        try:
            page = int(params.page)
        except:
            page = 1

        limit = SETTINGS['PAGE_LIMIT']
        start = (page - 1) * limit if page > 0 else 0

        with db.transaction():
            if params.pbtn == 'Retry Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.update('requests',
                                  where="id = %s" % val,
                                  status='ready')
            if params.pbtn == 'Cancel Selected':
                if params.reqid:
                    for val in params.reqid:
                        db.delete('requests', where="id = %s" % val)
            db.transaction().commit()

        criteria = "TRUE "
        if params.submissionid:
            criteria += " AND submissionid = %s" % params.submissionid
        if params.status:
            criteria += " AND status = '%s' " % params.status
        if params.sdate:
            criteria += " AND cdate >= '%s'" % params.sdate
        if params.edate:
            criteria += " AND cdate <= '%s'" % params.edate
        if params.week:
            criteria += " AND week = '%s'" % params.week
        if params.request_body:
            criteria += " AND request_body ILIKE '%%%s%%'" % params.request_body
        if params.year:
            criteria += " AND year = '%s'" % params.year
        if params.formatting:
            if params.formatting == "xml":
                criteria += " AND xml_is_well_formed(request_body)"

        print criteria
        if len(criteria) > 5:
            session.criteria = criteria
        dic = lit(relations='requests',
                  fields="*",
                  criteria=criteria,
                  order="id desc",
                  limit=limit,
                  offset=start)
        res = doquery(db, dic)
        count = countquery(db, dic)
        pagination_str = getPaginationString(default(page, 0), count, limit, 2,
                                             "search", "?page=")

        l = locals()
        del l['self']
        return render.search(**l)