"; else echo ""; } //メイン処理 set_global('staff', 'スタッフ情報管理', 'スタッフ登録リスト', BACK_TOP); // セッション登録 get_session_vars($pset, 'staff_list', 'kind', 'org', 'name', 'mail_addr', 'priority', 'level', 'period', 'invalid', 'displine', 'sort_col', 'sort_dir', 'page'); // where条件 if ($kind != '') and_join($where, "so_kind_cd=" . $kind); if ($org != '') and_join($where, "st_organization=" . $org); if ($name != '') and_join($where, "st_name1 LIKE '%$name%'"); if ($mail_addr != '') and_join($where, "st_mail_addr LIKE '%$mail_addr%'"); if ($priority != '') and_join($where, "st_priority_rank=" . $priority); if ($level != '') and_join($where, "st_level_rank=" . $level); if ($period == '') { and_join($where, "st_from_date <='" . date("Y-m-d") . "'"); and_join($where, "st_to_date >='" . date("Y-m-d") . "'"); } if ($invalid == '') and_join($where, "st_status=0"); if ($where != '') { $where = "($where)"; $where = "WHERE $where"; } else $where = ''; // ソート条件 $order_by = ORDER_BY(6, 1, 'so_kind_cd', 'st_organization', 'st_name1||st_name2', 'st_name1_kana||st_name2_kana', 'st_mail_addr', 'st_priority_rank', 'st_level_rank','st_from_date', 'st_to_date'); // 表示行数条件 $limit = disp_limit(); $sql = "select count(st_staff_id) as count from m_staff LEFT JOIN m_staff_org ON st_organization=so_org_cd $where"; $num = db_fetch1($sql); $sql = "SELECT st_staff_id,st_status,st_name1,st_name2,st_name1_kana,st_name2_kana,st_mail_addr,st_priority_rank,st_level_rank" . ",st_organization,st_from_date,st_to_date, so_kind_cd" . " FROM m_staff LEFT JOIN m_staff_org ON st_organization=so_org_cd $where $order_by $limit"; $result = db_exec($sql); $nrow = pg_numrows($result); ?> <?=$g_title?>
■スタッフ一覧　（総数: 名）
表示行数>>
種別  所属  名前（漢字)姓> ﾒｰﾙｱﾄﾞﾚｽ>  優先度 size=7>  レベル  期間外も表示> 無効も表示>
> >
width="100%" class="small2"> st_status; ?>
st_organization != '' ? decode_staff_kind($fetch->so_kind_cd) : '-未設定-'?> st_organization != '' ? decode_staff_org($fetch->st_organization) : '-未設定-'?> st_name1 $fetch->st_name2")?> st_name1_kana $fetch->st_name2_kana")?> st_mail_addr)?> st_priority_rank?> st_level_rank?> st_from_date)?> st_to_date)?>