aut_authority_bm_validate.js 1.27 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
function new_bm_map(name) {
	return new CompositeMap("bm", 'http://www.leaf-framework.org/schema/bm',
			name);
}

function create_std_query_field() {
	var qf = new_bm_map('query-field');
	qf.name = 'authority_flag';
	qf.queryexpression = '(${@authority_flag}='
			+ "'"
			+ "Y"
			+ "'"
			+ 'and exists (select 1 from aut_trx_user_authorize a1,aut_owner_user_authorize a2 where a1.trx_category = ${@trx_category} and a1.trx_id = ${:@trx_id}  and trunc(sysdate) between a1.start_date and nvl(a1.end_date,trunc(sysdate)) and a1.user_id = a2.owner_user_id and a1.trx_category = a2.trx_category  and a2.authorized_user_id = ${/session/@user_id} and trunc(sysdate) between a2.start_date and nvl(a2.end_date,trunc(sysdate))))';
	$this.addQueryField(qf.getData()); // get it's java type...
}

function create_doc_query_field() {
	var qf = new_bm_map('query-field');
	qf.name = 'authority_flag';
	qf.queryexpression = '(${@authority_flag}='
			+ "'"
			+ "Y"
			+ "'"
			+ 'and t1.owner_user_id IN (SELECT owner_user_id FROM aut_owner_user_authorize t  WHERE authorized_user_id = ${/session/@user_id} AND t.trx_category=${@trx_category} AND trunc(sysdate) BETWEEN t.start_date AND NVL(t.end_date,trunc(sysdate))))';
	$this.addQueryField(qf.getData()); // get it's java type...
}

create_std_query_field();