Пример #1
0
 def make_table(self, view_filter, pagenum):
     """Make the form for main page"""
     table = self.session.make_table_name(self.user["users.langid"])
     mtable = self.session.get_masterlang_table()
     langid = self.user["users.langid"]
     status_sql = self.get_sql_for_view_filter(view_filter, table)
     template_fields = ["xmlid", "textstring", "status", "remarks", 
         "ref_string", "our_remarks"]
     
     dbfields = ["%s.xmlid" % table, "%s.textstring" % table, 
         "%s.status" % table, "%s.remarks" % table, "%s.textstring" % mtable, 
         "%s.remarks" % mtable]
     
     request = """SELECT %(fields)s FROM %(table)s, %(mastertable)s WHERE %(table)s.\
         xmlid=%(mastertable)s.xmlid AND %(table)s.translate=1 AND \
         (%(table)s.role="STRING" OR %(table)s.role="CONTROL" OR \
         %(table)s.role="DIALOG" OR %(table)s.role="MENUITEM") \
         %(where_flags)s""" % \
         {"fields": ",".join(dbfields), "table": table, 
             "where_flags": status_sql, "mastertable": mtable}
     self.session.execute_query(request)
     rows = self.session.cursor.fetchall()
     self.total_num_items = len(rows)
     start, end = self.calculate_range(pagenum)
     self.session.trace_msg("Range for page %d: %d, %d" % (pagenum, start, end))
     form = "<table>"
     for i in range(start, end):
         r = rows[i]
         data = dict(zip(template_fields, r))
         t = tablerow.tablerow(searchList=data)
         t.instructions = self.instructions
 	    t.width = self.textbox_columns
 	    t.height = self.textbox_rows
 	    t.langid = self.user["users.langid"]
 	    t.pagenum = pagenum
 	    t.audio_support = self.audio_support
 	    t.audiouri = self.get_current_audio_uri(data["xmlid"], self.user["users.langid"])
 	    t.audionotes = ""
         
 	    if self.error != "" and self.error_id == data["xmlid"]:
 	        t.error = self.error
 	    else:
 	        t.error = ""
         form = form + t.respond()
     form = form + "</table>"
     return form, len(rows)
Пример #2
0
    def make_table(self, view_filter, pagenum):
        """Make the form for main page"""
        table = self.session.make_table_name(self.user["users.langid"])
        mtable = self.session.get_masterlang_table()
        langid = self.user["users.langid"]
        status_sql = self.get_sql_for_view_filter(view_filter, table)
        template_fields = ["xmlid", "textstring", "status", "remarks", 
            "target", "ref_string", "role"]
        dbfields = ["%s.xmlid" % table, "%s.textstring" % table, 
            "%s.status" % table, "%s.remarks" % table, "%s.target" % table,
            "%s.textstring" % mtable, "%s.role" % mtable]
        
        request = "SELECT DISTINCT mnemonicgroup FROM %s WHERE mnemonicgroup >= 0" % table
        self.session.execute_query(request)
        mnem_groups = self.session.cursor.fetchall()
        form = ""
        group_number = 1
        num_rows = 0
        # each mnemonic group gets its own section
        for g in mnem_groups:
            request = """SELECT %(fields)s FROM %(table)s, %(mastertable)s WHERE %(table)s.\
                xmlid=%(mastertable)s.xmlid AND %(table)s.mnemonicgroup=%(mnem_group)d \
                 AND %(table)s.role="MNEMONIC" %(where_flags)s""" % \
                {"fields": ",".join(dbfields), "table": table, 
                    "where_flags": status_sql, "mnem_group": g[0], "mastertable": mtable}

            self.session.execute_query(request)
            rows = self.session.cursor.fetchall()
            num_rows += len(rows)
            if len(rows) > 0:
                # the title of each section
                form += """<h2 id="group_%s">GROUP #%s</h2>""" % (str(g[0]), str(group_number))
                form += "<table>"
                for r in rows:
                    data = dict(zip(template_fields, r))
                    locallang_ref = self.build_mnemonic_string(table,
                        data["target"], data["textstring"])
                    masterlang_ref = self.build_mnemonic_string(mtable, 
                            data["target"], data["ref_string"])
                    # override some values
                    data["ref_string"] = locallang_ref
                    data["our_remarks"] = "This is for a %(item)s.  In %(masterlangname)s, it is \
                        used like this: \"%(example)s\"" \
                        % {"item": self.ROLE_DESCRIPTIONS[data["role"]], 
                            "example": masterlang_ref,
                            "masterlangname": self.masterlangname}
                    t = tablerow.tablerow(searchList=data)
                    t.instructions = self.instructions
                    t.width = self.textbox_columns
                    t.height = self.textbox_rows
                    t.langid = self.user["users.langid"]
                    t.audiouri = self.get_current_audio_uri(data["xmlid"], self.user["users.langid"])
                    t.audio_support = self.audio_support
                    t.audionotes = "Record only the mnemonic letter.  E.g. <em>&quot;%s&quot;</em>" % data["textstring"]
                    if self.error != "" and self.error_id == data["xmlid"]:
            	        t.error = self.error
            	    else:
            	        t.error = ""
                    form += t.respond()
                form += "</table>"
                group_number += 1
        #end for
        
        return form, num_rows
Пример #3
0
    def make_table(self, view_filter, pagenum):
        """Make the form for main page"""
        table = self.session.make_table_name(self.user["users.langid"])
        mtable = self.session.get_masterlang_table()
        langid = self.user["users.langid"]
        status_sql = self.get_sql_for_view_filter(view_filter, table)
        template_fields = ["xmlid", "textstring", "status", "remarks", "target", "ref_string", "role"]
        dbfields = [
            "%s.xmlid" % table,
            "%s.textstring" % table,
            "%s.status" % table,
            "%s.remarks" % table,
            "%s.target" % table,
            "%s.textstring" % mtable,
            "%s.role" % mtable,
        ]

        request = "SELECT DISTINCT mnemonicgroup FROM %s WHERE mnemonicgroup >= 0" % table
        self.session.execute_query(request)
        mnem_groups = self.session.cursor.fetchall()
        form = ""
        group_number = 1
        num_rows = 0
        # each mnemonic group gets its own section
        for g in mnem_groups:
            request = """SELECT %(fields)s FROM %(table)s, %(mastertable)s WHERE %(table)s.\
                xmlid=%(mastertable)s.xmlid AND %(table)s.mnemonicgroup=%(mnem_group)d \
                 AND %(table)s.role="MNEMONIC" %(where_flags)s""" % {
                "fields": ",".join(dbfields),
                "table": table,
                "where_flags": status_sql,
                "mnem_group": g[0],
                "mastertable": mtable,
            }

            self.session.execute_query(request)
            rows = self.session.cursor.fetchall()
            num_rows += len(rows)
            if len(rows) > 0:
                # the title of each section
                form += """<h2 id="group_%s">GROUP #%s</h2>""" % (str(g[0]), str(group_number))
                form += "<table>"
                for r in rows:
                    data = dict(zip(template_fields, r))
                    locallang_ref = self.build_mnemonic_string(table, data["target"], data["textstring"])
                    masterlang_ref = self.build_mnemonic_string(mtable, data["target"], data["ref_string"])
                    # override some values
                    data["ref_string"] = locallang_ref
                    data["our_remarks"] = (
                        'This is for a %(item)s.  In %(masterlangname)s, it is \
                        used like this: "%(example)s"'
                        % {
                            "item": self.ROLE_DESCRIPTIONS[data["role"]],
                            "example": masterlang_ref,
                            "masterlangname": self.masterlangname,
                        }
                    )
                    t = tablerow.tablerow(searchList=data)
                    t.instructions = self.instructions
                    t.width = self.textbox_columns
                    t.height = self.textbox_rows
                    t.langid = self.user["users.langid"]
                    t.audiouri = self.get_current_audio_uri(data["xmlid"], self.user["users.langid"])
                    t.audio_support = self.audio_support
                    t.audionotes = "Record only the mnemonic letter.  E.g. <em>&quot;%s&quot;</em>" % data["textstring"]
                    if self.error != "" and self.error_id == data["xmlid"]:
                        t.error = self.error
                    else:
                        t.error = ""
                    form += t.respond()
                form += "</table>"
                group_number += 1
        # end for

        return form, num_rows