common.inc 623 Bytes

//大区分に紐付くDBの小区分SEQ配列を取得
function getShouList($dSeq){
	var $arrsSeq = Array();
	var $sbuff = false ;
	
	
	foreach ($dSeq as $dval) {
		if ($sbuff !== "" ) {
			$sbuff .= ", ";
		}
		$sbuff .= $dval;
	}

	//追加する項目Seqの配列作成
	$strSQL  = "SELECT koumoku_seq FROM koumoku_tbl ";
	$strSQL .= " WHERE koumoku_parent IN (".$sbuff.") AND koumoku_mode = 2 ";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_num_rows($objRec) > 0){
		$objData = pg_fetch_object($objRec, 0);
		array_push($arrsSeq, $objData->koumoku_seq);
	}

	return $arrsSeq;
}