bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
	require_once('../include/config.php');
	require_once('../include/admin_function.php');
	require_once('./inc.php');
	$currentPath = '../';
//----------------------------------------------------------------------
//  ログイン認証処理 (START)
//----------------------------------------------------------------------
session_start();
authAdmin($userid,$password);
//----------------------------------------------------------------------
//  ログイン認証処理 (END)
//----------------------------------------------------------------------

//表示件数のリダイレクトにパラメータを引き継ぐ
	$param_arr = str_replace('?','',explode('/',preg_replace('/display_num=[0-9]+&/', '', $_SERVER['REQUEST_URI'])));
	
	//公開、非公開の設定
//	if(isset($_POST['dspChangeSubmit']) && isset($_POST['id'])){
//		//dspChange($dataBaseTable);
//	}
	//CSVダウンロード
	if(isset($_POST['search_org_submit'])){
		db2csv_download2($dataBaseTable,$csv_arr);
	}
	
	//画像ダウンロード
	
	if(isset($_POST['img_download'])){
		$path = $_POST['path'];
		$fname = $_POST['fname'];
		img_download($path,$fname);
	}
	
	$add_where .= " where id != '' ";
	
	//リダイレクトにパラメータを引き継ぐ
	//$param_arr_cat = str_replace('?','',explode('/',preg_replace(array('/public_flag=[0-9]+&/','/display_common_category=[0-9]+&/','/display_cat=[0-9]+&/'), '', $_SERVER['REQUEST_URI'])));
	
	//リダイレクトにパラメータを引き継ぐ
	//$param_arr_common_cat = str_replace('?','',explode('/',preg_replace(array('/public_flag=[0-9]+&/','/display_common_category=[0-9]+&/'), '', $_SERVER['REQUEST_URI'])));
	
	//リダイレクトにパラメータを引き継ぐ
	//$param_arr_public_flag = str_replace('?','',explode('/',preg_replace(array('/public_flag=[0-9]+&/','/display_common_category=[0-9]+&/'), '', $_SERVER['REQUEST_URI'])));
	
	//検索絞り込み
	if(isset($_GET['data']['Anken']['search_box_select']) && empty($_GET['data']['Anken']['clear'])){
		$search_box_select = mysqli_real_escape_string($link,$_GET['data']['Anken']['search_box_select']);
		$search_box_text = mysqli_real_escape_string($link,$_GET['data']['Anken']['search_box_text']);
		
		//カンマ区切りの場合には回す
		if(strpos($search_box_text,',') !== false){
			
			$add_where .= " and $search_box_select in(";
			$search_box_text_arr = explode(',',$search_box_text);
			foreach($search_box_text_arr as $search_box_text_arr_val){
				
				$search_box_text_arr_val = trim($search_box_text_arr_val);
				$add_where .= $search_box_text_arr_val.',';
			}
			
			$add_where = rtrim($add_where,',').")";
			
		}
		else{
			//$add_where .= " where $search_box_select = '".$search_box_text."'";
			$add_where .= " and $search_box_select like '%".$search_box_text."%'";
		}
	}
	
	//期間で検索
	if(isset($_GET['data']['Anken']['search_kikan01']) && empty($_GET['data']['Anken']['clear'])){
		$search_kikan01 = mysqli_real_escape_string($link,$_GET['data']['Anken']['search_kikan01']);
		$search_kikan02 = (!empty($_GET['data']['Anken']['search_kikan02'])) ? mysqli_real_escape_string($link,$_GET['data']['Anken']['search_kikan02']) : date('Y-m-d');
		
		//念のためフォーマットを揃える
		$search_kikan01 = date('Y-m-d',strtotime($search_kikan01));
		$search_kikan02 = date('Y-m-d',strtotime($search_kikan02));
		
		
		//検索表示
		if(isset($_GET['kikan_search'])){
			
			//SQLに渡すときは1日足す（DATETIME型をDATE型で検索するため自動的にDATE型に00:00:00が付与されるため）
			$search_kikan02_plus1Day = date('Y-m-d',strtotime($search_kikan02.'+ 1day'));
			//$search_kikan02_plus1Day = date('Y-m-d',strtotime($search_kikan02));//createdでなくup_ymdで検索するため変更
			
			$add_where .= " and created BETWEEN '$search_kikan01' AND '$search_kikan02_plus1Day'";
		
		}
	}
	
	//クリアボタン時にはリダイレクトでURLをリセット
	if(!empty($_GET['data']['Anken']['clear'])) normalRedirect('./?');
	
	
	//全行数取得のためのSQL分を関数に渡す
	$sql="select count(id) from $dataBaseTable $add_where";
	$sql_count = mysqli_query($link,$sql);
	$row = mysqli_fetch_assoc($sql_count);
	$totalCount = $row["count(id)"];
	
	if($totalCount < 1){
		$empty_messe = '該当データがありませんでした';
	}
	else{
		
		//ページャー設定
		$pager_res = pager($totalCount,$pagelength_value,$pagerDispLength);//ページャー取得
		
		
		//ソート
		$sort = 'id desc';//デフォルト
		if(isset($_GET['sort'])){
			$sort = mysqli_real_escape_string($link,$_GET['sort']);
		}
		
		//ページャー考慮データ取得クエリ
		$dbResData = getDB2DspPagerListData($dataBaseTable,$add_where,$pager_res['index'],$pager_res['pagelength_value'],$sort);
		
	}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<head>
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title><?php echo $contentsTitle;?>一覧画面</title>
<link rel="stylesheet" type="text/css" href="../css/style.css?<?php echo uniqid();?>">
<?php require_once('../include/head.php');?>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jqueryui/1/i18n/jquery.ui.datepicker-ja.min.js"></script>
<link type="text/css" href="//ajax.googleapis.com/ajax/libs/jqueryui/1/themes/ui-lightness/jquery-ui.css" rel="stylesheet" />
<script type="text/javascript">
$(function(){
	$(".datepicker").datepicker();
	$(".datepicker").datepicker("option", "dateFormat", 'yy-mm-dd');
	$( "#search_kikan01" ).datepicker( "setDate","<?php echo (!empty($search_kikan01)) ? $search_kikan01 : ''; ?>");	
	$( "#search_kikan02" ).datepicker( "setDate","<?php echo (!empty($search_kikan02)) ? $search_kikan02 : ''; ?>");	
});
</script>

</head>
<body>
<div id="container">
  <h1><?php echo $contentsTitle;?>一覧画面<?php echo (!empty($_SESSION['user_name'])) ? '（'.h($_SESSION['user_name']).'でログイン中）' : '';?></h1>
<div id="logoutBtn" class="linkBtn"><a href="?logout=true">ログアウト</a></div>
  <div id="toTop" class="linkBtn"><a href="../">管理メニュートップへ</a></div>
  
<div id="contents" class="clearfix">
<div id="leftContents">
<?php require_once('../include/gnav.php');?>
</div> 
  
<div id="rightContents">

<?php echo (!empty($empty_messe)) ? '<p class="col19 adminMesse">'.$empty_messe.'</p>' : '';?>

<form name="search_org" method="post" action="" class="search_org">
<table class="layoutTable01 mb10">
<tr>
<td>CSVダウンロード：<input type="submit" name="search_org_submit" value="CSVダウンロード" /></td>
</tr>
</table>
</form>

<form action="" method="get">
<input type="hidden" name="data[Anken][search_type_normal]">
<table class="layoutTable01">
<tr>
<td colspan="5">検索ボックス</td>
</tr>
<tr>
<td><select name="data[Anken][search_box_select]"  id="AnkenSearchBoxSelect">
<?php foreach($search_select_arr[0] as $search_select_arr_key => $search_select_arr_val){ ?>
<?php 
$checked = '';
if(!empty($search_box_select) && $search_box_select == $search_select_arr_key){
	$checked = ' selected="selected"';
}
?>
<option value="<?php echo $search_select_arr_key;?>"<?php echo $checked;?>><?php echo $search_select_arr_val;?></option>
<?php } ?>

</select></td>
<td>　が&nbsp;</td>
<td><input name="data[Anken][search_box_text]"  value="<?php if(isset($search_box_text) && !isset($_GET['data']['Anken']['search_type_gyoushu'])) echo $search_box_text;?>" type="text" id="AnkenSearchBoxText" /></td>
<td>&nbsp;のデータを&nbsp;</td>
<td><input type="submit" value=" 絞り込み検索 " /> <input name="data[Anken][clear]"  type="submit" value="検索クリア" class="search_clear" id="AnkenClear" /><span class="small01"></span></td>
</tr>
</table>

</form>

<form action="" method="get">
<table class="layoutTable01">
<tr>
<td colspan="5">送信日の期間で検索</td>
</tr>
<tr>
<td><input name="data[Anken][search_kikan01]"  value="<?php echo (!empty($search_kikan01)) ? $search_kikan01 : '';?>" type="text" class="datepicker" id="search_kikan01" /></td>
<td>&nbsp;から&nbsp;</td>
<td><input name="data[Anken][search_kikan02]"  value="<?php echo (!empty($search_kikan02)) ? $search_kikan02 : '';?>" type="text" class="datepicker" id="search_kikan02" /></td>
<td>&nbsp;までのデータを&nbsp;</td>
<td><input type="submit" name="kikan_search" value=" 絞り込み検索 " /> <input name="data[Anken][clear]"  type="submit" value="クリア" class="search_clear" /> </td>
</tr>
</table>
</form>

</div>

<table class="borderTable01">
	<tr>
	   
       <th nowrap="nowrap" style="width:6%;">ID番号</th>
       <th>代表者名（フリガナ）</th>
       <th>パートナー名（フリガナ）</th>
       <th nowrap="nowrap" style="width:10%;display:none;" class="taC">カード決済</th>
	   
       
	   <th><a href="?sort=<?php echo (@$_GET['sort'] == 'created') ? 'created desc' : 'created';?>">送信日時</a></th>
	   <th class="taC" nowrap="nowrap" style="width:10%">削除</th>
    </tr>
<?php 
	$data = array();
	if(!empty($dbResData) && is_array($dbResData)){
		foreach($dbResData as $key => $data){
			$imgPath = getImgPath($img_updir,$data['id'],$upfileNum); 
			
			//$dspMode = ($data['public_flag'] != 1) ? 'noDsp':'';
?>
	   <tr style="background:<?php echo (($key%2)== 0) ? "#ffffff":"#def3f7";?>">
	   <td class="taC" nowrap="nowrap"><?php echo $data['id'];?></td>
       
       
	   <td nowrap="nowrap"><?php echo h($data['name']);?>（<?php echo h($data['kana']);?>）</td>
	   <td nowrap="nowrap"><?php echo h($data['name2']);?>（<?php echo h($data['kana2']);?>）</td>
	   <td style="width:10%;display:none;" class="taC" nowrap="nowrap"><?php echo ($data['payment'] == 0) ? '未' : '済';?></td>
	   <td><?php echo date('Y/m/d H:i:s',strtotime(h($data['created'])));?></td>
       
	   <td class="buttonArea taC" nowrap="nowrap"><a href="preview.php?id=<?php echo h($data['id']);?>">プレビュー</a><a href="del.php?id=<?php echo h($data['id']);?>&mode=delete">削除</a></td>
    </tr>
<?php 
		}
	}
?>
</table>
<?php echo (isset($pager_res["dsp"])) ? $pager_res["dsp"] : '';?>

</div>
</div>
<div id="footer">
<?php require_once('../include/footer.php');?>
</div>
</div>
</body>
</html>