<?php
/*
 ---------------------------------------------------------------------
[Memo]
 Smarty Object => $smarty
 Template Vars => $smarty->_tpl_vars
 Parameter Var => $params
---------------------------------------------------------------------
*/

	//get param
	$name     = $params['name'];
	$value    = $params['value'];
	$mode     = $params['mode'];
	$cmd      = $smarty->_tpl_vars['cm'];
	$sw       = $params['sw'];
	$rows     = $params['rows'];

	//option
	$bukken_build_kind = $params['buki'];
	$bukken_pub_kind   = $params['publish_kind'];
	$bukken_ctgryset = $params['bucts'];

	//check
	if($name == NULL ){
		return;
	}

	//set rows --
	$rows = isset($rows) ? $rows : 10;

	//read db --------------------------------
	//set where ------
	$where_tbl = "bukken_room_build_id=bukken_build_id AND bukken_build_kind=ms_bukken_ctgry_code ";

	//set valid_flg
	$where_pub_sts = "AND bukken_build_seiyaku_state='1' ";

	//set Publish kind --
	$where_pub_kind = ($bukken_pub_kind != NULL) ? "AND bukken_build_publish_kind='{$bukken_pub_kind}'" : NULL;

	//set category
	$where_ctid = NULL;
	if($bukken_build_kind != NULL){
		$where_ctid = "AND bukken_build_kind='{$bukken_build_kind}'";
	}

	//set categorySet
	$where_ctidset = NULL;
	if($bukken_ctgryset != NULL){
		$where_ctidset = "AND ms_bukken_ctgry_set_code='{$bukken_ctgryset}'";
	}

	//Direct Id Specification Proc --
	//$where_view_ctgy = NULL;
	//if($view_ctgy_id != NULL){
	//	$where_view_ctgy .= "AND info_category_id IN ({$view_ctgy_id}) ";
	//}
	//-------------------------------

	//set rows
	$where_rows = NULL;
	if($rows != NULL){
		$where_rows = "LIMIT {$rows}";
	}

	//make where
	$where  = "WHERE {$where_tbl}{$where_pub_sts} {$where_ctid} {$where_pub_kind} {$where_ctidset} ORDER BY bukken_build_update DESC {$where_rows}";

	//read db
	$colum   = '*';
	$table   = 'bukken_build,bukken_room,ms_bukken_ctgry';
	$reclst  = Pvl_DB_getSelClmRstList(0, NULL, $colum, $table, $where, 0);
	//--------------------------------------------

	//disp ----
	$smarty->_tpl_vars[$name] = $reclst;
	//pe($reclst);

	return;

?>