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;
}