bibindexadminlib.py.wml
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sat, Jun 29, 07:19

bibindexadminlib.py.wml
View Options

	## Administrator interface for BibIndex

	## This file is part of the CERN Document Server Software (CDSware).
	## Copyright (C) 2002 CERN.
	##
	## The CDSware is free software; you can redistribute it and/or
	## modify it under the terms of the GNU General Public License as
	## published by the Free Software Foundation; either version 2 of the
	## License, or (at your option) any later version.
	##
	## The CDSware is distributed in the hope that it will be useful, but
	## WITHOUT ANY WARRANTY; without even the implied warranty of
	## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
	## General Public License for more details.
	##
	## You should have received a copy of the GNU General Public License
	## along with CDSware; if not, write to the Free Software Foundation, Inc.,
	## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.

	## read config variables:
	#include "config.wml"
	#include "configbis.wml"
	#include "cdswmllib.wml"

	<protect>## $Id$</protect>
	<protect>## DO NOT EDIT THIS FILE! IT WAS AUTOMATICALLY GENERATED FROM CDSware WML SOURCES.</protect>
	"""CDSware BibIndex Administrator Interface."""

	__lastupdated__ = """<: print `date +"%d %b %Y %H:%M:%S %Z"`; :>"""

	## fill config variables:

	import cgi
	import re
	import MySQLdb
	import Numeric
	import os
	import urllib
	import time
	import random
	from zlib import compress,decompress
	from bibrankadminlib import write_outcome,modify_translations,get_def_name,get_i8n_name,get_name,get_rnk_nametypes,get_languages,check_user,is_adminuser,adderrorbox,addadminbox,tupletotable,tupletotable_onlyselected,addcheckboxes,createhiddenform,serialize_via_numeric_array_dumps,serialize_via_numeric_array_compr,serialize_via_numeric_array_escape,serialize_via_numeric_array,deserialize_via_numeric_array,serialize_via_marshal,deserialize_via_marshal
	from messages import *
	from dbquery import run_sql
	from config import *
	from webpage import page, pageheaderonly, pagefooteronly
	from webuser import getUid, get_email
	from mod_python import apache

	__version__ = "$Id$"

	def getnavtrail(previous = ''):
	"""Get the navtrail"""

	navtrail = """<a class=navtrail href="%s/admin/">Admin Area</a> > <a class=navtrail href="%s/admin/bibindex/">BibIndex Admin</a> """ % (weburl, weburl)
	navtrail = navtrail + previous
	return navtrail

	def perform_index(ln=cdslang, mtype='', content=''):
	"""form to modify a collection. this method is calling other methods which again is calling this and sending back the output of the method.
	if callback, the method will call perform_editcollection, if not, it will just return its output.
	colID - id of the collection
	mtype - the method that called this method.
	content - the output from that method."""

	fin_output = """
	<table>
	<tr>
	<td><b>Menu</b></td>
	</tr>
	<tr>
	<td>0. <small><a href="%s/admin/bibindex/bibindexadmin.py?ln=%s">Show all</a></small></td>
	<td>1. <small><a href="%s/admin/bibindex/bibindexadmin.py?ln=%s&mtype=perform_showfields#1">Edit logical field</a></small></td>
	<td>2. <small><a href="%s/admin/bibindex/bibindexadmin.py?ln=%s&mtype=perform_addfield#2">Add new logical field</a></small></td>
	<td>2. <small><a href="%s/admin/bibindex/bibindexadmin.py?ln=%s&mtype=perform_showdetails#2">Logical fields overview</a></small></td>

	</tr>
	</table>
	""" % (weburl, ln, weburl, ln, weburl, ln, weburl, ln)

	if mtype == "perform_showfields" and content:
	fin_output += content
	elif mtype == "perform_showfields" or not mtype:
	fin_output += perform_showfields(ln, callback='')

	if mtype == "perform_addfield" and content:
	fin_output += content
	elif mtype == "perform_addfield" or not mtype:
	fin_output += perform_addfield(ln, callback='')

	if mtype == "perform_showdetails" and content:
	fin_output += content
	elif mtype == "perform_showdetails" or not mtype:
	fin_output += perform_showdetails(ln, callback='')

	return addadminbox("Overview of BibIndex Interface", [fin_output])

	def perform_showfields(ln=cdslang, callback='yes', content='', confirm=-1):
	"""show the sort fields of this collection.."""

	fld_dict = dict(get_def_name('', "field"))
	fld_type = get_fld_nametypes()
	subtitle = """<a name="1"></a>1. Edit logical field&nbsp&nbsp&nbsp<small>[<a title="See guide" href="%s/admin/bibindex/guide.html">?</a>]</small>""" % (weburl)

	fin_output = ''

	res = get_fld()
	output = ""
	if len(res) > 0:
	text = """
	<span class="adminlabel">Field name</span>
	<select name="fldID" class="admin_w200">
	<option value="-1">- Select a field -</option>
	"""
	for (fldID, name, code) in res:
	text += """<option value="%s">%s</option>""" % (fldID, fld_dict[int(fldID)])
	text += """</select>"""

	output += createhiddenform(action="%s/admin/bibindex/bibindexadmin.py/showfield" % weburl,
	text=text,
	button="Edit",
	ln=ln,
	confirm=1)

	else:
	output += """No logical fields exists"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(ln, "perform_showfields", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showfield(fldID, ln=cdslang, mtype='', content='', callback='yes', confirm=-1):
	"""form to modify a collection. this method is calling other methods which again is calling this and sending back the output of the method.
	if callback, the method will call perform_editcollection, if not, it will just return its output.
	colID - id of the collection
	mtype - the method that called this method.
	content - the output from that method."""

	fld_dict = dict(get_def_name('', "field"))
	if fldID in [-1, "-1"]:
	return addadminbox("Edit logical field", ["""<b><span class="info">Please go back and select a logical field</span></b>"""])


	fin_output = """
	<table>
	<tr>
	<td><b>Menu</b></td>
	</tr>
	<tr>
	<td>0. <small><a href="%s/admin/bibindex/bibindexadmin.py/showfield?fldID=%s&ln=%s">Show all</a></small></td>
	<td>1. <small><a href="%s/admin/bibindex/bibindexadmin.py/showfield?fldID=%s&ln=%s&mtype=perform_modifyfield">Modify field code</a></small></td>
	<td>2. <small><a href="%s/admin/bibindex/bibindexadmin.py/showfield?fldID=%s&ln=%s&mtype=perform_modifytranslations">Modify translations</a></small></td>
	<td>3. <small><a href="%s/admin/bibindex/bibindexadmin.py/showfield?fldID=%s&ln=%s&mtype=perform_showfieldtags">Modify MARC tags</a></small></td>
	</tr><tr>
	<td>4. <small><a href="%s/admin/bibindex/bibindexadmin.py/showfield?fldID=%s&ln=%s&mtype=perform_deletefield">Delete field</a></small></td>
	<td>5. <small><a href="%s/admin/bibindex/bibindexadmin.py/showfield?fldID=%s&ln=%s&mtype=perform_showdetailsfield">Show field usage</a></small></td>
	</tr>
	</table>
	""" % (weburl, fldID, ln, weburl, fldID, ln, weburl, fldID, ln, weburl, fldID, ln, weburl, fldID, ln, weburl, fldID, ln)

	if mtype == "perform_modifyfield" and content:
	fin_output += content
	elif mtype == "perform_modifyfield" or not mtype:
	fin_output += perform_modifyfield(fldID, ln, callback='')

	if mtype == "perform_modifytranslations" and content:
	fin_output += content
	elif mtype == "perform_modifytranslations" or not mtype:
	fin_output += perform_modifytranslations(fldID, ln, callback='')

	if mtype == "perform_showfieldtags" and content:
	fin_output += content
	elif mtype == "perform_showfieldtags" or not mtype:
	fin_output += perform_showfieldtags(fldID, ln, callback='')

	if mtype == "perform_deletefield" and content:
	fin_output += content
	elif mtype == "perform_deletefield" or not mtype:
	fin_output += perform_deletefield(fldID, ln, callback='')

	if mtype == "perform_showdetailsfield" and content:
	fin_output += content
	elif mtype == "perform_showdetailsfield" or not mtype:
	fin_output += perform_showdetailsfield(fldID,ln, callback='')

	return addadminbox("Edit logical field '%s'" % fld_dict[int(fldID)], [fin_output])

	def perform_modifytranslations(fldID, ln=cdslang, sel_type='', trans=[], confirm=-1, callback='yes'):
	"""Modify the translations of a field
	sel_type - the nametype to modify
	trans - the translations in the same order as the languages from get_languages()"""

	output = ''
	subtitle = ''
	cdslangs = get_languages()
	if confirm in ["2", 2] and fldID:
	finresult = modify_translations(fldID, cdslangs, sel_type, trans, "field")
	fld_dict = dict(get_def_name('', "field"))
	if fldID and fld_dict.has_key(int(fldID)):
	fldID = int(fldID)
	subtitle = """<a name="3"></a>3. Modify translations for logical field '%s'&nbsp&nbsp&nbsp<small>[<a title="See guide" href="%s/admin/bibindex/guide.html">?</a>]</small>""" % (fld_dict[fldID], weburl)

	if type(trans) is str:
	trans = [trans]
	if sel_type == '':
	sel_type = get_fld_nametypes()[0][0]

	header = ['Language', 'Translation']
	actions = []

	types = get_fld_nametypes()
	if len(types) > 1:
	text = """
	<span class="adminlabel">Name type</span>
	<select name="sel_type" class="admin_w200">
	"""
	for (key, value) in types:
	text += """<option value="%s" %s>%s""" % (key, key == sel_type and 'selected="selected"' or '', value)
	trans_names = get_name(fldID, ln, key, "field")
	if trans_names and trans_names[0][0]:
	text += ": %s" % trans_names[0][0]
	text += "</option>"
	text += """</select>"""

	output += createhiddenform(action="modifytranslations#3",
	text=text,
	button="Select",
	fldID=fldID,
	ln=ln,
	confirm=0)


	if confirm in [-1, "-1", 0, "0"]:
	trans = []
	for (key, value) in cdslangs:
	try:
	trans_names = get_name(fldID, key, sel_type, "field")
	trans.append(trans_names[0][0])
	except StandardError, e:
	trans.append('')

	for nr in range(0,len(cdslangs)):
	actions.append(["%s %s" % (cdslangs[nr][1], (cdslangs[nr][0]==cdslang and '<small>(def)</small>' or ''))])
	actions[-1].append('<input type="text" name="trans" size="30" value="%s"/>' % trans[nr])

	text = tupletotable(header=header, tuple=actions)
	output += createhiddenform(action="modifytranslations#3",
	text=text,
	button="Modify",
	fldID=fldID,
	sel_type=sel_type,
	ln=ln,
	confirm=2)

	if sel_type and len(trans):
	if confirm in ["1", 1]:
	text = """<b>Please confirm modification of translations for logical field '%s'.</b>""" % (fld_dict[fldID])
	output += createhiddenform(action="modifytranslations#3",
	text=text,
	button="Confirm",
	fldID=fldID,
	sel_type=sel_type,
	trans=trans,
	ln=ln,
	confirm=2)

	elif confirm in ["2", 2]:
	output += write_outcome(finresult)

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfield(fldID, ln, "perform_modifytranslations", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showdetailsfieldtag(fldID, tagID, ln=cdslang, callback="yes", confirm=-1):
	"""form to add a new field.
	fldNAME - the name of the new field
	code - the field code"""

	fld_dict = dict(get_def_name('', "field"))
	fldID = int(fldID)
	tagname = run_sql("SELECT name from tag where id=%s" % tagID)[0][0]

	output = ""
	subtitle = """<a name="4.1"></a>Showing details for MARC tag '%s'""" % tagname

	output += "<br><b>This MARC tag is used directly in these logical fields:</b> "
	fld_tag = get_fld_tags('', tagID)
	exist = {}
	for (id_field,id_tag, tname, tvalue, score) in fld_tag:
	output += "%s, " % fld_dict[int(id_field)]
	exist[id_field] = 1

	output += "<br><b>This MARC tag is used indirectly in these logical fields:</b> "
	tag = run_sql("SELECT value from tag where id=%s" % id_tag)
	tag = tag[0][0]
	for i in range(0, len(tag) - 1):
	res = run_sql("SELECT id_field,id_tag FROM field_tag,tag WHERE tag.id=field_tag.id_tag AND tag.value='%s%%'" % tag[0:i])
	for (id_field, id_tag) in res:
	output += "%s, " % fld_dict[int(id_field)]
	exist[id_field] = 1

	res = run_sql("SELECT id_field,id_tag FROM field_tag,tag WHERE tag.id=field_tag.id_tag AND tag.value like '%s'" % tag)
	for (id_field, id_tag) in res:
	if not exist.has_key(id_field):
	output += "%s, " % fld_dict[int(id_field)]
	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfieldtags(fldID, ln, "perform_showdetailsfieldtag", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showdetailsfield(fldID, ln=cdslang, callback="yes", confirm=-1):
	"""form to add a new field.
	fldNAME - the name of the new field
	code - the field code"""

	fld_dict = dict(get_def_name('', "field"))
	col_dict = dict(get_def_name('', "collection"))
	fldID = int(fldID)
	col_fld = get_col_fld('', '', fldID)
	sort_types = dict(get_sort_nametypes())

	fin_output = ""
	subtitle = """<a name="1"></a>5. Show usage for logical field '%s'""" % fld_dict[fldID]

	output = "This logical field is used in these collections:<br>"
	ltype = ''
	exist = {}
	for (id_collection, id_field, id_fieldvalue, ftype, score, score_fieldvalue) in col_fld:
	if ltype != ftype:
	output += "<br><b>%s: </b>" % sort_types[ftype]
	ltype = ftype
	exist = {}
	if not exist.has_key(id_collection):
	output += "%s, " % col_dict[int(id_collection)]
	exist[id_collection] = 1

	if not col_fld:
	output = "This field is not used by any collections."
	fin_output = addadminbox('Collections', [output])

	try:
	body = [fin_output, extra]
	except NameError:
	body = [fin_output]

	if callback:
	return perform_showfield(ln, "perform_showdetailsfield", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)


	def perform_addfield(ln=cdslang, fldNAME='', code='', callback="yes", confirm=-1):
	"""form to add a new field.
	fldNAME - the name of the new field
	code - the field code"""

	output = ""
	subtitle = """<a name="2"></a>2. Add new logical field"""
	code = str.replace(code,' ', '')
	text = """
	<span class="adminlabel">Field name</span>
	<input class="admin_w200" type="text" name="fldNAME" value="%s" /><br>
	<span class="adminlabel">Field code</span>
	<input class="admin_w200" type="text" name="code" value="%s" /><br>
	""" % (fldNAME, code)
	output = createhiddenform(action="%s/admin/bibindex/bibindexadmin.py/addfield" % weburl,
	text=text,
	ln=ln,
	button="Add field",
	confirm=1)
	if fldNAME and code and confirm in ["1", 1]:
	res = add_fld(fldNAME, code)
	output += write_outcome(res)
	elif confirm not in ["-1", -1]:
	output += """<b><span class="info">Please give the logical field a name and code.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(ln, "perform_addfield", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_deletefield(fldID, ln=cdslang, callback='yes', confirm=0):
	"""form to remove a field.
	fldID - the field id from table field.
	"""

	fld_dict = dict(get_def_name('', "field"))
	if not fld_dict.has_key(int(fldID)):
	return """<b><span class="info">Field does not exist</span></b>"""

	subtitle = """<a name="5"></a>4. Delete the logical field '%s'&nbsp&nbsp&nbsp<small>[<a title="See guide" href="%s/admin/bibindex/guide.html">?</a>]</small>""" % (fld_dict[int(fldID)], weburl)
	output = ""

	if fldID:
	fldID = int(fldID)
	if confirm in ["0", 0]:
	check = run_sql("SELECT * from idxINDEX_field where id_field=%s" % fldID)
	text = ""
	if check:
	text += """<b><span class="info">This field is used in an index, deletion may cause problems.</span></b><br>"""
	text += """Do you want to delete the logical field '%s' and all its relations and definitions.""" % (fld_dict[fldID])
	output += createhiddenform(action="deletefield#5",
	text=text,
	button="Confirm",
	fldID=fldID,
	confirm=1)
	elif confirm in ["1", 1]:
	res = delete_fld(fldID)
	if res[0] == 1:
	return """<br><b><span class="info">Field deleted.</span></b>""" + write_outcome(res)
	else:
	output += write_outcome(res)

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfield(fldID, ln, "perform_deletefield", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showdetails(ln=cdslang, callback='', confirm=0):

	subtitle = """<a name="3"></a>3. Logical fields overview"""
	output = """<table cellpadding="3" border="1">"""
	output += """<tr><td><strong>%s</strong></td><td><strong>%s</strong></td><td><strong>%s</strong></td></tr>""" % ("Field", "MARC Tags", "Translations")
	query = "SELECT id,name FROM field"
	res = run_sql(query)
	col_dict = dict(get_def_name('', "collection"))

	for field_id,field_name in res:
	query = "SELECT tag.value FROM tag, field_tag WHERE tag.id=field_tag.id_tag AND field_tag.id_field=%d ORDER BY field_tag.score DESC,tag.value ASC" % field_id
	res = run_sql(query)
	field_tags = ""
	for row in res:
	field_tags = field_tags + row[0] + ", "
	if field_tags.endswith(", "):
	field_tags = field_tags[:-2]

	cdslangs = dict(get_languages())
	langs = run_sql("select ln from fieldname where id_field=%s" % field_id)
	exists = {}
	lang = ''
	for lng in langs:
	if not exists.has_key(lng[0]):
	lang += lng[0] + ", "
	exists[lng[0]] = 1
	if lang.endswith(", "):
	lang = lang [:-2]
	if len(exists) == 0:
	lang = """<b><span class="info">None</span></b>"""

	col_fld = get_col_fld('', '', field_id)
	cols = ''
	exists = {}
	for (id_collection, id_field, id_fieldvalue, ftype, score, score_fieldvalue) in col_fld:
	if not exists.has_key(id_collection):
	cols = cols + col_dict[int(id_collection)]+ ", "
	exists[id_collection] = 1
	if len(exists) == 0:
	cols = """<span class="info">None</span>"""

	if cols.endswith(", "):
	cols = cols[:-2]
	output += """<tr><td>%s</td><td>%s</td><td>%s</td></tr>""" % ("""<a href="%s/admin/bibindex/bibindexadmin.py/showfield?fldID=%s">%s</A>""" % (weburl, field_id, field_name), field_tags, lang)
	output += "</table>"

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_index(fldID, ln, "perform_showfields", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_modifyfield(fldID, ln=cdslang, code='', callback='yes', confirm=-1):
	"""form to modify a field.
	fldID - the field to change."""

	subtitle = ""
	output = ""

	fld_dict = dict(get_def_name('', "field"))

	if fldID not in [-1, "-1"]:
	if confirm in [-1, "-1"]:
	res = get_fld(fldID)
	code = res[0][2]
	else:
	code = str.replace("%s" % code, " ", "")
	fldID = int(fldID)
	subtitle = """<a name="2"></a>1. Modify field code for logical field '%s'&nbsp&nbsp&nbsp<small>[<a title="See guide" href="%s/admin/bibindex/guide.html">?</a>]</small>""" % (fld_dict[int(fldID)], weburl)

	text = """
	<span class="adminlabel">Field code</span>
	<input class="admin_w200" type="text" name="code" value="%s" /><br>
	""" % code

	output += createhiddenform(action="modifyfield#2",
	text=text,
	button="Modify",
	fldID=fldID,
	ln=ln,
	confirm=1)

	if fldID > -1 and confirm in [1, "1"]:
	fldID = int(fldID)
	res = modify_fld(fldID, code)
	output += write_outcome(res)
	else:
	output = """No field to modify.
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfield(fldID, ln, "perform_modifyfield", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_showfieldtags(fldID, ln=cdslang, callback='yes', content='', confirm=-1):
	"""show the sort fields of this collection.."""

	output = ''

	fld_dict = dict(get_def_name('', "field"))
	fld_type = get_fld_nametypes()
	fldID = int(fldID)

	subtitle = """<a name="4"></a>3. Modify MARC tags for the logical field '%s'&nbsp&nbsp&nbsp<small>[<a title="See guide" href="%s/admin/bibindex/guide.html">?</a>]</small>""" % (fld_dict[int(fldID)], weburl)
	output = """<dl>
	<dt>Menu</dt>
	<dd><a href="%s/admin/bibindex/bibindexadmin.py/addtag?fldID=%s&ln=%s#4.1">Add MARC tag</a></dd>
	<dd><a href="%s/admin/bibindex/bibindexadmin.py/deletetag?fldID=%s&ln=%s#4.1">Delete unused MARC tags</a></dd>
	</dl>
	""" % (weburl, fldID, ln, weburl, fldID, ln)

	header = ['', 'Value', 'Comment', 'Actions']
	actions = []

	res = get_fld_tags(fldID)
	if len(res) > 0:
	i = 0
	for (fldID, tagID, tname, tvalue, score) in res:
	move = ""
	if i != 0:
	move += """<a href="%s/admin/bibindex/bibindexadmin.py/switchtagscore?fldID=%s&id_1=%s&id_2=%s&ln=%s&amp=rand=%s#4"><img border="0" src="%s/img/smallup.gif" title="Move tag up"></a>""" % (weburl, fldID, tagID, res[i - 1][1], ln, random.randint(0, 1000), weburl)
	else:
	move += "   "
	i += 1
	if i != len(res):
	move += '<a href="%s/admin/bibindex/bibindexadmin.py/switchtagscore?fldID=%s&id_1=%s&id_2=%s&ln=%s&rand=%s#4"><img border="0" src="%s/img/smalldown.gif" title="Move tag down"></a>' % (weburl, fldID, tagID, res[i][1], ln, random.randint(0, 1000), weburl)

	actions.append([move, tvalue, tname])
	for col in [(('Details','showdetailsfieldtag'), ('Modify','modifytag'),('Remove','removefieldtag'),)]:
	actions[-1].append('<a href="%s/admin/bibindex/bibindexadmin.py/%s?fldID=%s&tagID=%s&ln=%s#4.1">%s</a>' % (weburl, col[0][1], fldID, tagID, ln, col[0][0]))
	for (str, function) in col[1:]:
	actions[-1][-1] += ' / <a href="%s/admin/bibindex/bibindexadmin.py/%s?fldID=%s&tagID=%s&ln=%s#4.1">%s</a>' % (weburl, function, fldID, tagID, ln, str)
	output += tupletotable(header=header, tuple=actions)
	else:
	output += """No fields exists"""

	output += content

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfield(fldID, ln, "perform_showfieldtags", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)


	def perform_addtag(fldID, ln=cdslang, value=['',-1], name='', callback="yes", confirm=-1):
	"""form to add a new field.
	fldNAME - the name of the new field
	code - the field code"""

	output = ""
	subtitle = """<a name="4.1"></a>Add MARC tag to logical field"""
	text = """
	Add new tag:<br>
	<span class="adminlabel">Tag value</span>
	<input class="admin_w200" maxlength="6" type="text" name="value" value="%s" /><br>
	<span class="adminlabel">Tag comment</span>
	<input class="admin_w200" type="text" name="name" value="%s" /><br>
	""" % ((name=='' and value[0] or name), value[0])
	text += """Or existing tag:<br>
	<span class="adminlabel">Tag</span>
	<select name="value" class="admin_w200">
	<option value="-1">- Select a tag -</option>
	"""

	fld_tags = get_fld_tags(fldID)
	tags = get_tags()
	fld_tags = dict(map(lambda x: (x[1], x[0]), fld_tags))

	for (id_tag, tname, tvalue) in tags:
	if not fld_tags.has_key(id_tag):
	text += """<option value="%s" %s>%s</option>""" % (tvalue, (tvalue==value[1] and 'selected="selected"' or ''), "%s - %s" % (tvalue, tname))
	text += """</select>"""

	output = createhiddenform(action="%s/admin/bibindex/bibindexadmin.py/addtag" % weburl,
	text=text,
	fldID=fldID,
	ln=ln,
	button="Add tag",
	confirm=1)

	if (value[0] and value[1] in [-1, "-1"]) or (not value[0] and value[1] not in [-1, "-1"]):
	if confirm in ["1", 1]:
	res = add_fld_tag(fldID, name, (value[0] !='' and value[0] or value[1]))
	output += write_outcome(res)
	elif confirm not in ["-1", -1]:
	output += """<b><span class="info">Please choose to add either a new or an existing MARC tag, but not both.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfieldtags(fldID, ln, "perform_addtag", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_modifytag(fldID, tagID, ln=cdslang, name='', value='', callback='yes', confirm=-1):
	"""form to modify a field.
	fldID - the field to change."""

	subtitle = ""
	output = ""

	fld_dict = dict(get_def_name('', "field"))

	fldID = int(fldID)
	tagID = int(tagID)
	tag = get_tags(tagID)
	if confirm in [-1, "-1"] and not value and not name:
	name = tag[0][1]
	value = tag[0][2]

	subtitle = """<a name="4.1"></a>Modify MARC tag"""

	text = """
	Any modifications will apply to all logical fields using this tag.<br>
	<span class="adminlabel">Tag value</span>
	<input class="admin_w200" type="text" name="value" value="%s" /><br>
	<span class="adminlabel">Comment</span>
	<input class="admin_w200" type="text" name="name" value="%s" /><br>
	""" % (name, value)

	output += createhiddenform(action="modifytag#4.1",
	text=text,
	button="Modify",
	fldID=fldID,
	tagID=tagID,
	ln=ln,
	confirm=1)

	if name and value and confirm in [1, "1"]:
	res = modify_tag(tagID, name, value)
	output += write_outcome(res)

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfieldtags(fldID, ln, "perform_modifytag", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_removefieldtag(fldID, tagID, ln=cdslang, callback='yes', confirm=0):
	"""form to remove a portalbox from a collection.
	colID - the current collection, remove the portalbox from this collection.
	sel_ln - remove the portalbox with this language
	pbxID - remove the portalbox with this id"""

	subtitle = """<a name="4.1"></a>Remove MARC tag from logical field"""
	output = ""

	fld_dict = dict(get_def_name('', "field"))

	if fldID and tagID:
	fldID = int(fldID)
	tagID = int(tagID)
	tag = get_fld_tags(fldID, tagID)
	if confirm not in ["1", 1]:
	text = """Do you want to remove the tag '%s - %s ' from the field '%s'.""" % (tag[0][3], tag[0][2], fld_dict[fldID])
	output += createhiddenform(action="removefieldtag#4.1",
	text=text,
	button="Confirm",
	fldID=fldID,
	tagID=tagID,
	confirm=1)
	elif confirm in ["1", 1]:
	res = remove_fldtag(fldID, tagID)
	output += write_outcome(res)

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	if callback:
	return perform_showfieldtags(fldID, ln, "perform_removefieldtag", addadminbox(subtitle, body))
	else:
	return addadminbox(subtitle, body)

	def perform_switchtagscore(fldID, id_1, id_2, ln=cdslang):
	"""Switch the score of id_1 and id_2 in the table type.
	colID - the current collection
	id_1/id_2 - the id's to change the score for.
	type - like "format" """

	output = ""
	name_1 = run_sql("select name from tag where id=%s" % id_1)[0][0]
	name_2 = run_sql("select name from tag where id=%s" % id_2)[0][0]
	res = switch_score(fldID, id_1, id_2)
	output += write_outcome(res)
	return perform_showfieldtags(fldID, ln, content=output)

	def perform_deletetag(fldID, ln=cdslang, tagID=-1, callback='yes', confirm=-1):
	"""form to delete an MARC tag not in use.
	fldID - the collection id of the current collection.
	fmtID - the format id to delete."""

	subtitle = """<a name="10.3"></a>Delete an unused MARC tag"""
	output = """
	<dl>
	<dd>Deleting an MARC tag will also delete the translations associated.</dd>
	</dl>
	"""

	fldID = int(fldID)
	if tagID not in [-1," -1"] and confirm in [1, "1"]:
	ares = delete_tag(tagID)

	fld_tag = get_fld_tags()
	fld_tag = dict(map(lambda x: (x[1], x[0]), fld_tag))

	tags = get_tags()
	text = """
	<span class="adminlabel">MARC tag</span>
	<select name="tagID" class="admin_w200">
	"""
	text += """<option value="-1">- Select MARC tag -"""
	i = 0
	for (id, name, value) in tags:
	if not fld_tag.has_key(id):
	text += """<option value="%s" %s>%s</option>""" % (id, id == int(tagID) and 'selected="selected"' or '', "%s - %s" % (value, name))
	i += 1

	text += """</select><br>"""

	if i == 0:
	output += """<b><span class="info">No unused MARC tags</span></b><br>"""
	else:
	output += createhiddenform(action="deletetag#4.1",
	text=text,
	button="Delete",
	fldID=fldID,
	ln=ln,
	confirm=0)

	if tagID not in [-1,"-1"]:
	tagID = int(tagID)
	tags = get_tags(tagID)
	if confirm in [0, "0"]:
	text = """<b>Do you want to delete the MARC tag '%s'.</b>
	""" % tags[0][2]
	output += createhiddenform(action="deletetag#4.1",
	text=text,
	button="Confirm",
	fldID=fldID,
	tagID=tagID,
	ln=ln,
	confirm=1)

	elif confirm in [1, "1"]:
	output += write_outcome(ares)
	elif confirm not in [-1, "-1"]:
	output += """<b><span class="info">Choose a MARC tag to delete.</span></b>
	"""

	try:
	body = [output, extra]
	except NameError:
	body = [output]

	output = "<br>" + addadminbox(subtitle, body)
	return perform_showfieldtags(fldID, ln, content=output)

	def compare_on_val(first, second):
	"""Compare the two values"""

	return cmp(first[1], second[1])

	def get_col_fld(colID=-1, type = '', id_field=''):
	"""Returns either all portalboxes associated with a collection, or based on either colID or language or both.
	colID - collection id
	ln - language id"""

	sql = "SELECT id_collection,id_field,id_fieldvalue,type,score,score_fieldvalue FROM collection_field_fieldvalue, field WHERE id_field=field.id"

	try:
	if id_field:
	sql += " AND id_field=%s" % id_field
	sql += " ORDER BY type, score desc, score_fieldvalue desc"
	res = run_sql(sql)
	return res
	except StandardError, e:
	return ""

	def get_fld_tags(fldID='', tagID=''):
	"""Returns either all portalboxes associated with a collection, or based on either colID or language or both.
	colID - collection id
	ln - language id"""

	sql = "SELECT id_field,id_tag, tag.name, tag.value, score FROM field_tag,tag WHERE tag.id=field_tag.id_tag"

	try:
	if fldID:
	sql += " AND id_field=%s" % fldID
	if tagID:
	sql += " AND id_tag=%s" % tagID
	sql += " ORDER BY score desc, tag.value, tag.name"
	res = run_sql(sql)
	return res
	except StandardError, e:
	return ""

	def get_tags(tagID=''):
	"""Returns either all portalboxes associated with a collection, or based on either colID or language or both.
	colID - collection id
	ln - language id"""

	sql = "SELECT id, name, value FROM tag"

	try:
	if tagID:
	sql += " WHERE id=%s" % tagID
	sql += " ORDER BY name, value"
	res = run_sql(sql)
	return res
	except StandardError, e:
	return ""

	def get_fld(fldID=''):
	"""Returns allfields"""

	try:
	if not fldID:
	res = run_sql("SELECT id, name, code FROM field ORDER by name, code")
	else:
	res = run_sql("SELECT id, name, code FROM field WHERE id=%s ORDER by name, code" % fldID)
	return res
	except StandardError, e:
	return ""

	def get_fld_value(fldvID = ''):
	"""Returns fieldvalue"""

	try:
	sql = "SELECT id, name, value FROM fieldvalue"
	if fldvID:
	sql += " WHERE id=%s" % fldvID
	res = run_sql(sql)
	return res
	except StandardError, e:
	return ""

	def get_col_nametypes():
	"""Return a list of the various translationnames for the fields"""

	type = []
	type.append(('ln', 'Long name'))
	return type

	def get_fld_nametypes():
	"""Return a list of the various translationnames for the fields"""

	type = []
	type.append(('ln', 'Long name'))
	return type

	def get_sort_nametypes():
	"""Return a list of the various translationnames for the fields"""

	type = {}
	type['soo'] = 'Sort options'
	type['seo'] = 'Search options'
	type['sew'] = 'Search within'
	return type

	def remove_fld(colID,fldID, fldvID=''):
	"""Removes a field from the collection given.
	colID - the collection the format is connected to
	fldID - the field which should be removed from the collection."""

	try:
	sql = "DELETE FROM collection_field_fieldvalue WHERE id_collection=%s AND id_field=%s" % (colID, fldID)
	if fldvID:
	sql += " AND id_fieldvalue=%s" % fldvID
	res = run_sql(sql)
	return (1, "")
	except StandardError, e:
	return (0, e)

	def remove_fldtag(fldID,tagID):
	"""Removes a field from the collection given.
	colID - the collection the format is connected to
	fldID - the field which should be removed from the collection."""

	try:
	sql = "DELETE FROM field_tag WHERE id_field=%s AND id_tag=%s" % (fldID, tagID)
	res = run_sql(sql)
	return (1, "")
	except StandardError, e:
	return (0, e)

	def delete_tag(tagID):
	"""Deletes all data for the given field
	fldID - delete all data in the tables associated with field and this id """

	try:
	res = run_sql("DELETE FROM tag where id=%s" % tagID)
	return (1, "")
	except StandardError, e:
	return (0, e)

	def delete_fld(fldID):
	"""Deletes all data for the given field
	fldID - delete all data in the tables associated with field and this id """

	try:
	res = run_sql("DELETE FROM collection_field_fieldvalue WHERE id_field=%s" % fldID)
	res = run_sql("DELETE FROM field_tag WHERE id_field=%s" % fldID)
	res = run_sql("DELETE FROM idxINDEX_field WHERE id_field=%s" % fldID)
	res = run_sql("DELETE FROM field WHERE id=%s" % fldID)
	return (1, "")
	except StandardError, e:
	return (0, e)

	def add_fld(name, code):
	"""Add a new output format. Returns the id of the format.
	code - the code for the format, max 6 chars.
	name - the default name for the default language of the format.
	rtype - the default nametype"""

	try:
	type = get_fld_nametypes()[0][0]
	res = run_sql("INSERT INTO field (name, code) values('%s','%s')" % (MySQLdb.escape_string(name), MySQLdb.escape_string(code)))
	fldID = run_sql("SELECT id FROM field WHERE code='%s'" % MySQLdb.escape_string(code))
	res = run_sql("INSERT INTO fieldname (id_field, type, ln, value) VALUES (%s,'%s','%s','%s')" % (fldID[0][0], type, cdslang, MySQLdb.escape_string(name)))
	if fldID:
	return (1, fldID[0][0])
	else:
	raise StandardError
	except StandardError, e:
	return (0, e)

	def add_fld_tag(fldID, name, value):
	"""Add a sort/search/field to the collection.
	colID - the id of the collection involved
	fmtID - the id of the format.
	score - the score of the format, decides sorting, if not given, place the format on top"""

	try:
	res = run_sql("SELECT score FROM field_tag WHERE id_field=%s ORDER BY score desc" % (fldID))
	if res:
	score = int(res[0][0]) + 1
	else:
	score = 0
	res = run_sql("SELECT id FROM tag WHERE value='%s'" % MySQLdb.escape_string(value))
	if not res:
	if name == '':
	name = value
	res = run_sql("INSERT INTO tag(name, value) values('%s','%s')" % (MySQLdb.escape_string(name), MySQLdb.escape_string(value)))
	res = run_sql("SELECT id FROM tag WHERE value='%s'" % MySQLdb.escape_string(value))

	res = run_sql("INSERT INTO field_tag(id_field, id_tag, score) values(%s, %s, %s)" % (fldID, res[0][0], score))
	return (1, "")
	except StandardError, e:
	return (0, e)

	def modify_fld(fldID, code):
	"""Modify the dbquery of an collection.
	colID - the id of the collection involved
	dbquery - the new dbquery"""

	try:
	sql = "UPDATE field SET code='%s'" % code
	sql += " WHERE id=%s" % fldID
	res = run_sql(sql)
	return (1, "")
	except StandardError, e:
	return (0, e)


	def modify_tag(tagID, name, value):
	"""Modify the dbquery of an collection.
	colID - the id of the collection involved
	dbquery - the new dbquery"""

	try:
	sql = "UPDATE tag SET name='%s' WHERE id=%s" % (name, tagID)
	res = run_sql(sql)
	sql = "UPDATE tag SET value='%s' WHERE id=%s" % (value, tagID)
	res = run_sql(sql)
	return (1, "")
	except StandardError, e:
	return (0, e)

	def switch_score(fldID, id_1, id_2):
	"""Switch the scores of id_1 and id_2 in the table given by the argument.
	colID - collection the id_1 or id_2 is connected to
	id_1/id_2 - id field from tables like format..portalbox...
	table - name of the table"""
	try:
	res1 = run_sql("SELECT score FROM field_tag WHERE id_field=%s and id_tag=%s" % (fldID, id_1))
	res2 = run_sql("SELECT score FROM field_tag WHERE id_field=%s and id_tag=%s" % (fldID, id_2))
	res = run_sql("UPDATE field_tag SET score=%s WHERE id_field=%s and id_tag=%s" % (res2[0][0], fldID, id_1))
	res = run_sql("UPDATE field_tag SET score=%s WHERE id_field=%s and id_tag=%s" % (res1[0][0], fldID, id_2))
	return (1, "")
	except StandardError, e:
	return (0, e)

bibindexadminlib.py.wmlNo OneTemporaryActions

File Metadata

bibindexadminlib.py.wmlView Options

Event Timeline

bibindexadminlib.py.wml
No OneTemporary
Actions

bibindexadminlib.py.wml
View Options