function out_html($gc) {
// $gc->sum_tesuryou = get_sum_tesuryou($gc);
$gc->sum_tesuryou = get_sum_tesuryou_d($gc);
$gc->company_nm = fdb_get_name($gc, "m_company", "company_nm", "company_no", $gc->login_company_no);
$arr_todoufuken = fsel_get_arr_todoufuken($gc);
$arr_buken_sbt = fdiv_set_buken_sbt_array();
$sql = sql_text_create_d($gc);
switch($_GET["si"]) {
case "ank":
$sql.= " p.anken_no".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "mbi":
$sql.= " p.moushikomibi".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "sbt":
$sql.= " p.buken_sbt".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "men":
$sql.= " p.menseki".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "ran":
$sql.= " p.rank_no".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "tod":
$sql.= " s.todoufuken_no".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "shi":
$sql.= " p.buken_shikucyouson_no".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "muk":
$sql.= " c3.c_mukou_flg".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "tes":
$sql.= " p.tesuryou".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
default:
$sql.= " p.moushikomibi desc ";
}
$sql.= f_get_limit($gc->pn, $gc->pl, C_ORDER_LIST_COL_CNT);
$rs = $gc->db->query($sql);
$row_count = $gc->db->get_row_count();
//ページャーの設定
if($row_count > 0){
$page_arr = f_page_arr("tesuryo_d.php", $row_count, $gc->pl, C_ORDER_LIST_COL_CNT, C_ORDER_PAGE_TAG_CNT);
}
//ソート関連
$sort_mode["ank"] = "";
$sort_mode["mbi"] = "";
$sort_mode["sbt"] = "";
$sort_mode["men"] = "";
$sort_mode["ran"] = "";
$sort_mode["tod"] = "";
$sort_mode["shi"] = "";
$sort_mode["muk"] = "";
$sort_mode["tes"] = "";
foreach ($sort_mode as $key => &$value) {
if($key == $_GET["si"]){
if($_GET["sa"] == "desc"){
$value = " ▼";
}else{
$value = " ▲";
}
}
}
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8" />
<title>手数料一覧</title>
<!-- *** stylesheet *** -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<!-- *** javascript *** -->
<script type="text/javascript" src="js/listpage.js" charset="utf-8"></script>
<script language="JavaScript">
<!--
var submit_flg = false;
function run_submit(fname, mode) {
document.forms[fname].mode.value = mode;
if(submit_flg==false){
//ボタン２度押し対応
submit_flg = true;
document.forms[fname].submit();
}
}
function unload_page(){
submit_flg = false;
}
window.onunload = unload_page;
function search_run(){
var o;
o = document.getElementById('mbif_y');
var mbif_y = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbif_m');
var mbif_m = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbif_d');
var mbif_d = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbit_y');
var mbit_y = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbit_m');
var mbit_m = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbit_d');
var mbit_d = o.options[ o.selectedIndex ].value;
document.forms['form_search'].mbif.value = mbif_y + mbif_m + mbif_d;
document.forms['form_search'].mbit.value = mbit_y + mbit_m + mbit_d;
run_submit('form_search', 'search');
}
// -->
</script>
</head>
<body>
<!-- Header -->
<div id="header">
<div class="shell">
<!-- Logo + Top Nav -->
<?php tcom_header_logo_nav($gc) ?>
<!-- End Logo + Top Nav -->
<!-- Main Nav -->
<?php tcom_header_main_nav2($gc, 2) ?>
<!-- End Main Nav -->
</div>
</div>
<!-- End Header -->
<!-- Container -->
<div id="container">
<div class="shell">
<!-- Small Nav -->
<div class="small-nav">
<a href="tesuryo_l.php">手数料管理</a>
<span>></span>
手数料一覧
</div>
<!-- End Small Nav -->
<!-- Main -->
<div id="main">
<div class="cl"> </div>
<!-- Content -->
<div id="content">
<!-- Box -->
<div class="box">
<!-- Form -->
<div class="form">
<form name="form_search" action="tesuryo_d.php" method="get" onsubmit="return false">
<input name="mode" type="hidden" value="">
<input name="mbif" type="hidden" value="">
<input name="mbit" type="hidden" value="">
<div class="box-size4 left">
<p class="inline-field">
<label style="display:inline;">集計期間：</label>
<select id="mbif_y" class="field">
<?php echo fsel_get_date_y($gc, $gc->mbif_y) ?>
</select><span class="ml05">年</span>
<select id="mbif_m" class="field">
<?php echo fsel_get_date_m($gc, $gc->mbif_m) ?>
</select><span class="ml05">月</span>
<select id="mbif_d" class="field">
<?php echo fsel_get_date_d($gc, $gc->mbif_d) ?>
</select><span class="ml05">日</span>
～
<select id="mbit_y" class="field">
<?php echo fsel_get_date_y($gc, $gc->mbit_y) ?>
</select><span class="ml05">年</span>
<select id="mbit_m" class="field">
<?php echo fsel_get_date_m($gc, $gc->mbit_m) ?>
</select><span class="ml05">月</span>
<select id="mbit_d" class="field">
<?php echo fsel_get_date_d($gc, $gc->mbit_d) ?>
</select><span class="ml05">日</span>
<button type="button" class="button color silver ml30" onclick="search_run();">検索</button>
</p>
</div>
<div class="cl"> </div>
</form>
</div>
<!-- End Form -->
<!-- Box Head -->
<div class="box-head">
<h2 class="left">抽出条件・手数料合計</h2>
<div class="right">
<div class="cl"> </div>
</div>
</div>
<!-- End Box Head -->
<!-- Form -->
<div class="form">
<div class="box-size4 left">
<p class="inline-field">
<label style="display:inline;">集計期間：</label>
<?php echo substr($gc->mbif, 0, 4) ?>年<?php echo substr($gc->mbif, 4, 2) ?>月<?php echo substr($gc->mbif, 6, 2) ?>日
～
<?php echo substr($gc->mbit, 0, 4) ?>年<?php echo substr($gc->mbit, 4, 2) ?>月<?php echo substr($gc->mbit, 6, 2) ?>日
</p>
</div>
<div style="float:right;">
<label class="ml40" style="display:inline;">手数料合計：</label>
<?php echo number_format($gc->sum_tesuryou) ?>円
</div>
<div class="cl"> </div>
</div>
<!-- End Form -->
<!-- Box Head -->
<div class="box-head">
<h2 class="left">手数料一覧</h2>
<div class="right">
<a href="tesuryo_csv.php?mode=2&mbif=<?php echo f_hsc($gc->mbif) ?>&mbit=<?php echo f_hsc($gc->mbit) ?>&company_no=<?php echo f_hsc($gc->login_company_no) ?>" class="custom-button"><span>CSV出力</span></a>
</div>
</div>
<!-- End Box Head -->
<!-- Table -->
<div class="table">
<?php if($row_count > 0){ ?>
<!-- Pagging -->
<div class="pagging">
<div class="box-l">
<?php echo $page_arr["cmes_str"].$page_arr["par1_str"].$page_arr["par2_str"]; ?>
</div>
<div class="box-c">
<div class="margin-center">
<?php echo $page_arr["back_str"].$page_arr["list_str"].$page_arr["deno_str"].$page_arr["next_str"]; ?>
</div>
</div>
<div class="box-r">
<label>表示件数：</label>
<?php echo $page_arr["plst_str"] ?>
</div>
</div>
<!-- End Pagging -->
<?php } ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr style="border-top:solid 1px #e0e0e0;">
<th width="80" class="ac"><a href="tesuryo_d.php<?php echo f_sq("ank") ?>">案件番号</a><?php echo $sort_mode["ank"] ?></th>
<th width="80" class="ac"><a href="tesuryo_d.php<?php echo f_sq("mbi") ?>">申込日</a><?php echo $sort_mode["mbi"] ?></th>
<th width="80" class="ac"><a href="tesuryo_d.php<?php echo f_sq("sbt") ?>">種別</a><?php echo $sort_mode["sbt"] ?></th>
<th width="80" class="ac"><a href="tesuryo_d.php<?php echo f_sq("men") ?>">延床面積</a><?php echo $sort_mode["men"] ?><br />(平米)</th>
<th width="50" class="ac"><a href="tesuryo_d.php<?php echo f_sq("ran") ?>">ランク</a><?php echo $sort_mode["ran"] ?></th>
<th width="70"><a href="tesuryo_d.php<?php echo f_sq("tod") ?>">都道府県</a><?php echo $sort_mode["tod"] ?></th>
<th><a href="tesuryo_d.php<?php echo f_sq("shi") ?>">市区町村</a><?php echo $sort_mode["shi"] ?></th>
<th width="40" class="ac"><a href="tesuryo_d.php<?php echo f_sq("muk") ?>">状態</a><?php echo $sort_mode["muk"] ?></th>
<th width="70" class="ac"><a href="tesuryo_d.php<?php echo f_sq("tes") ?>">手数料</a><?php echo $sort_mode["tes"] ?></th>
<th width="60" class="ac">詳細</th>
</tr>
<?php
$i = 0;
while ($rs->eof==false) {
$item_no = $rs->fields["item_no"];
$anken_no = $rs->fields["anken_no"];
$buken_sbt = $rs->fields["buken_sbt"];
$purpose_flg = $rs->fields["purpose_flg"];
$menseki = $rs->fields["menseki"];
$rank_no = get_rank_d($rs);
// $rank_no = $rs->fields["rank_no"];
$todoufuken_no = $rs->fields["todoufuken_no"];
$buken_shikucyouson_no = $rs->fields["buken_shikucyouson_no"];
$shikucyouson_nm = $rs->fields["shikucyouson_nm"];
$mukou_flg = $rs->fields["mukou_flg"];
$c_mukou_flg = $rs->fields["c_mukou_flg"];
$m_cnt = $rs->fields["m_cnt"];
$y_cnt = $rs->fields["y_cnt"];
$tesuryou = get_tesuryo_d($rs);
// $tesuryou = $rs->fields["tesuryou"];
$moushikomibi = $rs->fields["moushikomibi"];
$menseki = (float)$menseki;
$moushikomi_d = substr($moushikomibi, 0, 4)."/".substr($moushikomibi, 5, 2)."/".substr($moushikomibi, 8, 2);
$moushikomi_t = substr($moushikomibi, 11);
$todoufuken_nm = $arr_todoufuken[$todoufuken_no];
$buken_sbt_nm = $arr_buken_sbt[$buken_sbt];
$arr = fdiv_set_rank_array();
if($rank_no != "L"){
$rank_nm = $arr[$rank_no];
}else{
$rank_nm = "L";
}
/*
if($purpose_flg == 1){
$rank_nm = "L";
}
*/
$odd = "";
if(($i % 2)==1){
$odd = " class=\"odd\"";
}
echo "<tr".$odd.">";
echo "<td class=\"ac\">".$anken_no."</td>";
echo "<td class=\"ac\">".$moushikomi_d."<br />".$moushikomi_t."</td>";
echo "<td class=\"ac\">".f_hsc($buken_sbt_nm)."</td>";
echo "<td class=\"ac\">".f_hsc($menseki)."</td>";
echo "<td class=\"ac\">".f_hsc($rank_nm)."</td>";
echo "<td>".f_hsc($todoufuken_nm)."</td>";
echo "<td>".f_hsc($shikucyouson_nm)."</td>";
echo "<td class=\"ac\" style=\"color: ".($c_mukou_flg==1?"red":"blue").";\">".f_hsc($c_mukou_flg==1?"無効":"有効")."</td>";
echo "<td class=\"ar\">".f_hsc($mukou_flg==1?"0":$tesuryou)."</td>";
// echo "<td class=\"ar\">".f_hsc($mukou_flg==1?"0":number_format($tesuryou))."</td>";
echo "<td class=\"ac\"><button type=\"button\" class=\"list-button\" onclick=\"location.href='item_e.php?item_no=".$item_no."&referrer=tesuryo_d&company_no=".$gc->login_company_no."&mbif=".$gc->mbif."&mbit=".$gc->mbit."';\">詳細</button></td>";
echo "</tr>";
$rs->move_next();
$i++;
}
$rs->free_result();
if($row_count==0){
echo "<tr>";
echo "<td colspan=\"10\" align=\"center\">データはありません。</td>";
echo "</tr>";
}
?>
</table>
<?php if($row_count > 0){ ?>
<!-- Pagging -->
<div class="pagging">
<div class="box-l">
</div>
<div class="box-c">
<div class="margin-center">
<?php echo $page_arr["back_str"].$page_arr["list_str"].$page_arr["deno_str"].$page_arr["next_str"]; ?>
</div>
</div>
<div class="box-r">
<label>表示件数：</label>
<?php echo $page_arr["plst_str"] ?>
</div>
</div>
<!-- End Pagging -->
<?php } ?>
</div>
<!-- Table -->
</div>
<!-- End Box -->
<div class="cl"> </div>
</div>
<!-- End Content -->
<div class="cl"> </div>
</div>
<!-- Main -->
</div>
</div>
<!-- End Container -->
<!-- Footer -->
<?php tcom_footer($gc) ?>
<!-- End Footer -->
</body>
</html>
<?php
}
function sheet_create($gc) {
$gc->mode = $_GET["mode"];
$gc->company_no = $_GET["company_no"];
$gc->mbif = $_GET["mbif"];
$y = substr($gc->mbif, 0, 4);
$m = substr($gc->mbif, 4, 2);
$d = substr($gc->mbif, 6, 2);
$gc->mbif_t = date('Ym01', mktime(0, 0, 0, $m + 1, 0, $y));
if(!@checkdate($m, $d, $y)){
$gc->mbif = date("Ym01", time());
}
$gc->mbit = $_GET["mbit"];
$y = substr($gc->mbit, 0, 4);
$m = substr($gc->mbit, 4, 2);
$d = substr($gc->mbit, 6, 2);
$gc->mbit_t = date('Ymd', mktime(0, 0, 0, $m + 1, 0, $y));
$gc->mbim = date('Ymd', mktime(0, 0, 0, $m + 2, 0, $y));
if(!@checkdate($m, $d, $y)){
$gc->mbit = date("Ymt", time());
}
$count_company = get_sum_company_count($gc);
if($count_company > 0){
$excel = new PHPExcel();
// シートの設定
// セルに値を入れる
$reader = PHPExcel_IOFactory::createReader('Excel2007');
// $excel = $reader -> load("seikyu_tpl.xlsm");
$excel = $reader -> load("seikyu_tpl.xlsx");
$excel->setActiveSheetIndex(0);
$sheet = $excel->getActiveSheet();
$sheet->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$sheet->setTitle('sheet namea');
$sheet->setCellValue('AJ2', substr($gc->mbit, 0, 4));
$sheet->setCellValue('AN2', substr($gc->mbit, 4, 2));
$sheet->setCellValue('AR2', substr($gc->mbit_t, 6, 2));
$sheet->setCellValue('B12', '支払は弊社指定銀行に'.substr($gc->mbim, 4, 2).'月'.substr($gc->mbim, 6, 2).'日までに振込みをお願いします。');
$sheet->setCellValue('F34', 'ご入金期限：'.substr($gc->mbim, 0, 4).'年'.substr($gc->mbim, 4, 2).'月'.substr($gc->mbim, 6, 2).'日');
$excel->setActiveSheetIndex(1);
$sheet2 = $excel->getActiveSheet();
$sheet2->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$sheet2->setCellValue('P2', substr($gc->mbif_t, 0, 4));
$sheet2->setCellValue('T2', substr($gc->mbif_t, 4, 2));
$sheet2->setCellValue('V2', substr($gc->mbif_t, 6, 2));
$sheet2->setCellValue('Y2', substr($gc->mbit_t, 0, 4));
$sheet2->setCellValue('AC2', substr($gc->mbit_t, 4, 2));
$sheet2->setCellValue('AE2', substr($gc->mbit_t, 6, 2));
$newSheets = array();
for ($i = 0; $i < $count_company; $i++) {
if ($i != 0) {
$newSheets[] = clone $sheet;
$newSheets[] = clone $sheet2;
}
}
$cnt = 0;
foreach ($newSheets as $newSheet) {
$newSheet->setTitle('sheet name'.($cnt));
$excel->addSheet($newSheet);
$cnt++;
}
$sql = sql_text_create_s($gc);
$rs = $gc->db->query($sql);
$s2_maxrow_1 = 25;
$s2_maxrow_2 = 25;
$count_company = 0;
$d_company = "";
$sum_kingaku["k"] = 0;
$sum_kingaku["l"] = 0;
$sum_kingaku["s"] = 0;
$sum_kingaku["a"] = 0;
$sum_kingaku["b"] = 0;
$sum_kingaku["c"] = 0;
$cno = 1;
$s1_row = 21;
$s2_row = 16;
$s2_row_2 = 1;
$s2_sheet_cnt = 1;
$arr_todoufuken = fsel_get_arr_todoufuken($gc);
$arr_buken_sbt = fdiv_set_buken_sbt_array();
$arr_rank = fdiv_set_rank_array();
$sadd_flg = 0;
mb_internal_encoding("UTF-8");
while ($rs->eof==false) {
if($d_company != $rs->fields["company_no"]){
$sadd_flg++;
if($s2_row > 16){
if(($s2_sheet_cnt == 1) && (($s2_row_2+3) < $s2_maxrow_1)){
sheet2_blank_add($sheet2,$s2_row,(($s2_maxrow_1)-($s2_row_2+3)));
$s2_row = $s2_row + ($s2_maxrow_1)-($s2_row_2+3);
}elseif(($s2_sheet_cnt > 1) && (($s2_row_2+3) < $s2_maxrow_2)){
sheet2_blank_add($sheet2,$s2_row,(($s2_maxrow_2)-($s2_row_2+3)));
$s2_row = $s2_row + ($s2_maxrow_2)-($s2_row_2+3);
}
sheet_sum_add($sheet,$sheet2,$s2_row,$sum_kingaku["k"]);
sheet1_data_add($sheet,$sum_kingaku);
}
$todoufuken_nm = $arr_todoufuken[$rs->fields["sk_todoufuken_no"]];
if($rs->fields["sk_zip"] != ""){
$zip1 = substr($rs->fields["sk_zip"], 0, 3);
$zip2 = substr($rs->fields["sk_zip"], 4, 4);
}else{
$zip1 = "";
$zip2 = "";
}
$excel->setActiveSheetIndex($count_company);
$sheet = $excel->getActiveSheet();
$excel->setActiveSheetIndex(($count_company+1));
$sheet2 = $excel->getActiveSheet();
$sheet->setTitle(mb_substr($rs->fields["company_nm"], 0, 28)."_雛形");
$sheet2->setTitle(mb_substr($rs->fields["company_nm"], 0, 28)."_明細");
// $sheet->setTitle("雛形");
// $sheet2->setTitle("明細");
$sheet2->setCellValue('B3', $zip1);
// $sheet2->setCellValue('E3', $zip2);
$sheet2->setCellValueExplicit( 'E3', $zip2 );
$sheet2->setCellValue('A4', $todoufuken_nm.$rs->fields["sk_add1"].$rs->fields["sk_add2"]);
$sheet2->setCellValue('A6', $rs->fields["company_nm"]);
$sheet2->setCellValue('A8', $rs->fields["sk_tantou"]);
$sheet->setCellValue('G2', $rs->fields["sk_zip"]);
$sheet->setCellValue('F3', $todoufuken_nm.$rs->fields["sk_add1"].$rs->fields["sk_add2"]);
$sheet->setCellValue('F5', $rs->fields["company_nm"]);
$sheet->setCellValue('F6', $rs->fields["sk_jigyoubu"]);
$sheet->setCellValue('F7', $rs->fields["sk_tantou"]);
$cno = 1;
$sum_kingaku["k"] = 0;
$sum_kingaku["l"] = 0;
$sum_kingaku["s"] = 0;
$sum_kingaku["a"] = 0;
$sum_kingaku["b"] = 0;
$sum_kingaku["c"] = 0;
$s2_sheet_cnt = 1;
$s1_row = 21;
$s2_row = 16;
$s2_row_2 = 1;
$count_company = $count_company + 2;
}
if($s2_row > 16){
$sheet2->insertNewRowBefore($s2_row, 1);
sheet2_merge_row($sheet2,$s2_row);
$sheet2->getStyle('A'.$s2_row)->getFont()->setStrikethrough(false);
$sheet2->getStyle('B'.$s2_row)->getFont()->setStrikethrough(false);
$sheet2->getStyle('F'.$s2_row)->getFont()->setStrikethrough(false);
$sheet2->getStyle('J'.$s2_row)->getFont()->setStrikethrough(false);
$sheet2->getStyle('N'.$s2_row)->getFont()->setStrikethrough(false);
$sheet2->getStyle('R'.$s2_row)->getFont()->setStrikethrough(false);
$sheet2->getStyle('V'.$s2_row)->getFont()->setStrikethrough(false);
$sheet2->getStyle('Z'.$s2_row)->getFont()->setStrikethrough(false);
}
if($s2_sheet_cnt == 1){
if($s2_row_2 > $s2_maxrow_1){
$sheet2->insertNewRowBefore($s2_row, 1);
$sheet2->setBreak( 'A'.$s2_row , PHPExcel_Worksheet::BREAK_ROW );
$s2_row++;
$sheet2->insertNewRowBefore($s2_row, 1);
$s2_row++;
sheet2_dup_row($sheet2,$s2_row-2,14);
sheet2_dup_row($sheet2,$s2_row-1,15);
sheet2_merge_row($sheet2,$s2_row-1);
$s2_row_2 = 1;
$s2_sheet_cnt++;
}else{
}
}else{
if($s2_row_2 > $s2_maxrow_2){
$sheet2->insertNewRowBefore($s2_row, 1);
$sheet2->setBreak( 'A'.$s2_row , PHPExcel_Worksheet::BREAK_ROW );
$s2_row++;
$sheet2->insertNewRowBefore($s2_row, 1);
$s2_row++;
sheet2_dup_row($sheet2,$s2_row-2,14);
sheet2_dup_row($sheet2,$s2_row-1,15);
sheet2_merge_row($sheet2,$s2_row-1);
$s2_row_2 = 1;
$s2_sheet_cnt++;
}else{
}
}
$rank_no = get_rank_s($rs);
$tesuryou = get_tesuryo_s($rs);
$buken_sbt_nm = $arr_buken_sbt[$rs->fields["buken_sbt"]];
$todoufuken_nm = $arr_todoufuken[$rs->fields["todoufuken_no"]];
if($rank_no != "L"){
$rank_nm = $arr_rank[$rank_no];
}else{
$rank_nm = "L";
}
$sheet2->setCellValue('A'.$s2_row, $cno);
$sheet2->setCellValue('B'.$s2_row, $rs->fields["anken_no"]);
$sheet2->setCellValue('F'.$s2_row, substr($rs->fields["moushikomibi"], 0, 4)."/".substr($rs->fields["moushikomibi"], 5, 2)."/".substr($rs->fields["moushikomibi"], 8, 2));
$sheet2->setCellValue('J'.$s2_row, $buken_sbt_nm);
$sheet2->setCellValue('N'.$s2_row, $rank_nm);
$sheet2->setCellValue('R'.$s2_row, $todoufuken_nm);
$sheet2->setCellValue('V'.$s2_row, $rs->fields["shikucyouson_nm"]);
$sheet2->setCellValue('Z'.$s2_row, $tesuryou);
if($rs->fields["c_mukou_flg"] > 0){
$sheet2->getStyle('A'.$s2_row)->getFont()->setStrikethrough(true);
$sheet2->getStyle('B'.$s2_row)->getFont()->setStrikethrough(true);
$sheet2->getStyle('F'.$s2_row)->getFont()->setStrikethrough(true);
$sheet2->getStyle('J'.$s2_row)->getFont()->setStrikethrough(true);
$sheet2->getStyle('N'.$s2_row)->getFont()->setStrikethrough(true);
$sheet2->getStyle('R'.$s2_row)->getFont()->setStrikethrough(true);
$sheet2->getStyle('V'.$s2_row)->getFont()->setStrikethrough(true);
$sheet2->getStyle('Z'.$s2_row)->getFont()->setStrikethrough(true);
$tesuryou = 0;
}
if($rs->fields["kotei_flg"] > 0){
$sum_kingaku["k"] = $rs->fields["kotei_flg"];
}
switch ($rank_nm) {
case "L":
if($tesuryou > 0){
$sum_kingaku["l"] = $sum_kingaku["l"] + $tesuryou;
}
break;
case "S":
if($tesuryou > 0){
$sum_kingaku["s"] = $sum_kingaku["s"] + $tesuryou;
}
break;
case "A":
if($tesuryou > 0){
$sum_kingaku["a"] = $sum_kingaku["a"] + $tesuryou;
}
break;
case "B":
if($tesuryou > 0){
$sum_kingaku["b"] = $sum_kingaku["b"] + $tesuryou;
}
break;
case "C":
if($tesuryou > 0){
$sum_kingaku["c"] = $sum_kingaku["c"] + $tesuryou;
}
break;
}
$cno++;
$s2_row++;
$s2_row_2++;
$d_company = $rs->fields["company_no"];
$f_company_nm = $rs->fields["company_nm"];
$rs->move_next();
}
//echo print_r($rs->fields, true);
if(($s2_sheet_cnt == 1) && (($s2_row_2+3) < $s2_maxrow_1)){
sheet2_blank_add($sheet2,$s2_row,(($s2_maxrow_1)-($s2_row_2+3)));
$s2_row = $s2_row + ($s2_maxrow_1)-($s2_row_2+3);
}elseif(($s2_sheet_cnt > 1) && (($s2_row_2+3) < $s2_maxrow_2)){
sheet2_blank_add($sheet2,$s2_row,(($s2_maxrow_2)-($s2_row_2+3)));
$s2_row = $s2_row + ($s2_maxrow_2)-($s2_row_2+3);
}
sheet_sum_add($sheet,$sheet2,$s2_row,$sum_kingaku["k"]);
sheet1_data_add($sheet,$sum_kingaku);
$excel->setActiveSheetIndex(0);
$excel->getActiveSheet()->setSelectedCells('A1');
header('Content-Type: application/octet-stream');
if($gc->company_no > 0){
// $filename = "請求書_".substr($gc->mbit_t, 0, 4)."年".substr($gc->mbit_t, 4, 2)."月_".$f_company_nm.".xlsm";
$filename = "請求書_".substr($gc->mbit_t, 0, 4)."年".substr($gc->mbit_t, 4, 2)."月_".$f_company_nm.".xlsx";
}else{
// $filename = "請求書_".substr($gc->mbit_t, 0, 4)."年".substr($gc->mbit_t, 4, 2)."月.xlsx";
$filename = "請求書_".substr($gc->mbit_t, 0, 4)."年".substr($gc->mbit_t, 4, 2)."月.xlsx";
}
header('Content-Disposition: attachment;filename="'.$filename.'"');
$writer = PHPExcel_IOFactory::createWriter($excel, "Excel2007");
$writer->save('php://output');
}
}
function out_html($gc) {
$gc->company_sh = $_GET["company_sh"];
$gc->todoufuken_no = $_GET["todoufuken_no"];
$gc->company_no = $_GET["company_no"];
$gc->company_kbn = $_GET["company_kbn"];
$gc->relocation_flg = $_GET["relocation_flg"];
$arr_todoufuken = fsel_get_arr_todoufuken($gc);
$arr_company_kbn = fdiv_set_company_kbn_array();
//ラジオボタン設定
fdiv_set_company_kbn_radio($gc, $gc->company_kbn, "company_kbn");
//チェックボックス設定
fdiv_set_checkbox($gc, "リロケーション", ($gc->relocation_flg=="1"), "relocation_flg");
if(is_numeric($gc->company_no)){
$gc->joken_company_nm = fdb_get_name($gc, "m_company", "company_nm", "company_no", $gc->company_no);
}
if($gc->joken_company_nm==""){
$gc->joken_company_nm = "指定なし";
}
if($gc->company_sh==""){
$gc->joken_company_sh = "指定なし";
}else{
$gc->joken_company_sh = $gc->company_sh;
}
if(is_numeric($gc->todoufuken_no)){
$gc->joken_todoufuken_nm = $arr_todoufuken[$gc->todoufuken_no];
}
if($gc->joken_todoufuken_nm==""){
$gc->joken_todoufuken_nm = "指定なし";
}
if($gc->relocation_flg=="1"){
$gc->joken_relocation_flg_nm = "あり";
}else{
$gc->joken_relocation_flg_nm = "指定なし";
}
if(is_numeric($gc->company_kbn)){
if($gc->company_kbn > 0){
$gc->joken_company_kbn_nm = $arr_company_kbn[$gc->company_kbn];
}else{
$gc->joken_company_kbn_nm = "全て";
}
}else{
$gc->joken_company_kbn_nm = "指定なし";
}
//ベースＳＱＬの作成
$base_sql = sql_text_create_l($gc);
//手数料合計の取得
/*
$sql = "SELECT";
$sql.= " COALESCE(rl.sum_tesuryou, 0) AS sum_tesuryou_l,";
$sql.= " COALESCE(rs.sum_tesuryou, 0) AS sum_tesuryou_s,";
$sql.= " COALESCE(ra.sum_tesuryou, 0) AS sum_tesuryou_a,";
$sql.= " COALESCE(rb.sum_tesuryou, 0) AS sum_tesuryou_b,";
$sql.= " COALESCE(rc.sum_tesuryou, 0) AS sum_tesuryou_c ";
$sql.= $base_sql;
$rs = $gc->db->query($sql);
$gc->sum_tesuryou = 0;
while ($rs->eof==false) {
$sum_tesuryou_l = $rs->fields["sum_tesuryou_l"];
$sum_tesuryou_s = $rs->fields["sum_tesuryou_s"];
$sum_tesuryou_a = $rs->fields["sum_tesuryou_a"];
$sum_tesuryou_b = $rs->fields["sum_tesuryou_b"];
$sum_tesuryou_c = $rs->fields["sum_tesuryou_c"];
$gc->sum_tesuryou += $sum_tesuryou_l + $sum_tesuryou_s + $sum_tesuryou_a + $sum_tesuryou_b + $sum_tesuryou_c;
$rs->move_next();
}
$rs->free_result();
$sql = "SELECT SQL_CALC_FOUND_ROWS";
$sql.= " mc.company_no,";
$sql.= " mc.company_nm,";
$sql.= " mc.company_kn,";
$sql.= " mc.company_sh,";
$sql.= " mc.company_kbn,";
$sql.= " mc.todoufuken_no,";
$sql.= " mc.add1,";
$sql.= " mc.jyougen,";
$sql.= " COALESCE(rl.cnt_rank, 0) AS cnt_rank_l,";
$sql.= " COALESCE(rl.sum_tesuryou, 0) AS sum_tesuryou_l,";
$sql.= " COALESCE(rs.cnt_rank, 0) AS cnt_rank_s,";
$sql.= " COALESCE(rs.sum_tesuryou, 0) AS sum_tesuryou_s,";
$sql.= " COALESCE(ra.cnt_rank, 0) AS cnt_rank_a,";
$sql.= " COALESCE(ra.sum_tesuryou, 0) AS sum_tesuryou_a,";
$sql.= " COALESCE(rb.cnt_rank, 0) AS cnt_rank_b,";
$sql.= " COALESCE(rb.sum_tesuryou, 0) AS sum_tesuryou_b,";
$sql.= " COALESCE(rc.cnt_rank, 0) AS cnt_rank_c,";
$sql.= " COALESCE(rc.sum_tesuryou, 0) AS sum_tesuryou_c ";
$sql.= $base_sql;
*/
$sql= $base_sql;
$sql.= " ORDER BY";
switch($_GET["si"]) {
case "ckn":
$sql.= " c.company_kn".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "kbn":
$sql.= " c.company_kbn".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "tod":
$sql.= " c.todoufuken_no".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "crl":
$sql.= " sr_l".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "crs":
$sql.= " sr_1".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "cra":
$sql.= " sr_2".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "crb":
$sql.= " sr_3".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "crc":
$sql.= " sr_4".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "tes":
$sql.= " s_t".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
case "jog":
$sql.= " c.jyougen".(($_GET["sa"]=="desc") ? " DESC" : "")." ";
break;
default:
$sql.= " c.company_no ";
}
$sql.= f_get_limit($gc->pn, $gc->pl, C_ORDER_LIST_COL_CNT);
$rs = $gc->db->query($sql);
$row_count = $gc->db->get_row_count();
//ページャーの設定
if($row_count > 0){
$page_arr = f_page_arr("tesuryo_l.php", $row_count, $gc->pl, C_ORDER_LIST_COL_CNT, C_ORDER_PAGE_TAG_CNT);
}
//ソート関連
$sort_mode["ckn"] = "";
$sort_mode["kbn"] = "";
$sort_mode["tod"] = "";
$sort_mode["crl"] = "";
$sort_mode["crs"] = "";
$sort_mode["cra"] = "";
$sort_mode["crb"] = "";
$sort_mode["crc"] = "";
$sort_mode["tes"] = "";
$sort_mode["jog"] = "";
foreach ($sort_mode as $key => &$value) {
if($key == $_GET["si"]){
if($_GET["sa"] == "desc"){
$value = " ▼";
}else{
$value = " ▲";
}
}
}
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8" />
<title>手数料一覧</title>
<!-- *** stylesheet *** -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<!-- *** javascript *** -->
<script type="text/javascript" src="js/listpage.js" charset="utf-8"></script>
<script language="JavaScript">
<!--
var submit_flg = false;
function run_submit(fname, mode) {
document.forms[fname].mode.value = mode;
if(submit_flg==false){
//ボタン２度押し対応
submit_flg = true;
document.forms[fname].submit();
}
}
function unload_page(){
submit_flg = false;
}
window.onunload = unload_page;
function search_run(){
var o;
o = document.getElementById('mbif_y');
var mbif_y = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbif_m');
var mbif_m = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbif_d');
var mbif_d = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbit_y');
var mbit_y = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbit_m');
var mbit_m = o.options[ o.selectedIndex ].value;
o = document.getElementById('mbit_d');
var mbit_d = o.options[ o.selectedIndex ].value;
document.forms['form_search'].mbif.value = mbif_y + mbif_m + mbif_d;
document.forms['form_search'].mbit.value = mbit_y + mbit_m + mbit_d;
run_submit('form_search', 'search');
}
// -->
</script>
</head>
<body>
<!-- Header -->
<div id="header">
<div class="shell">
<!-- Logo + Top Nav -->
<?php tcom_header_logo_nav($gc) ?>
<!-- End Logo + Top Nav -->
<!-- Main Nav -->
<?php tcom_header_main_nav2($gc, 2) ?>
<!-- End Main Nav -->
</div>
</div>
<!-- End Header -->
<!-- Container -->
<div id="container">
<div class="shell">
<!-- Small Nav -->
<div class="small-nav">
<a href="tesuryo_l.php">手数料管理</a>
<span>></span>
手数料一覧
</div>
<!-- End Small Nav -->
<!-- Main -->
<div id="main">
<div class="cl"> </div>
<!-- Content -->
<div id="content">
<!-- Box -->
<div class="box">
<!-- Form -->
<div class="form">
<form name="form_search" action="tesuryo_l.php" method="get" onsubmit="return false">
<input name="mode" type="hidden" value="">
<input name="mbif" type="hidden" value="">
<input name="mbit" type="hidden" value="">
<div class="box-size4 left">
<p class="inline-field">
<label style="display:inline;">集計期間：</label>
<select id="mbif_y" class="field">
<?php echo fsel_get_date_y($gc, $gc->mbif_y) ?>
</select><span class="ml05">年</span>
<select id="mbif_m" class="field">
<?php echo fsel_get_date_m($gc, $gc->mbif_m) ?>
</select><span class="ml05">月</span>
<select id="mbif_d" class="field">
<?php echo fsel_get_date_d($gc, $gc->mbif_d) ?>
</select><span class="ml05">日</span>
～
<select id="mbit_y" class="field">
<?php echo fsel_get_date_y($gc, $gc->mbit_y) ?>
</select><span class="ml05">年</span>
<select id="mbit_m" class="field">
<?php echo fsel_get_date_m($gc, $gc->mbit_m) ?>
</select><span class="ml05">月</span>
<select id="mbit_d" class="field">
<?php echo fsel_get_date_d($gc, $gc->mbit_d) ?>
</select><span class="ml05">日</span>
<label class="ml20" style="display:inline;">区分：</label>
<input id="company_kbn_0" type="radio" name="company_kbn" value="0"<?php echo $gc->company_kbn_0_checked ?> />
<label class="mr10" for="company_kbn_0" style="display:inline;font-weight: normal;">全て</label>
<input id="company_kbn_1" type="radio" name="company_kbn" value="1"<?php echo $gc->company_kbn_1_checked ?> />
<label class="mr10" for="company_kbn_1" style="display:inline;font-weight: normal;">大手</label>
<input id="company_kbn_2" type="radio" name="company_kbn" value="2"<?php echo $gc->company_kbn_2_checked ?> />
<label class="mr10" for="company_kbn_2" style="display:inline;font-weight: normal;">地場</label>
</p>
</div>
<div class="box-size4 left">
<p class="inline-field">
<label style="display:inline;">提携会社：</label>
<select name="company_no" class="field">
<option value=""></option>
<?php echo fsel_get_company($gc, $gc->company_no) ?>
</select>
<label class="ml05" style="display:inline;">支店名：</label>
<input name="company_sh" type="text" class="field size2" value="<?php echo f_hsc($gc->company_sh)?>" />
<label class="ml05" style="display:inline;">所在地：</label>
<select name="todoufuken_no" class="field">
<option value=""></option>
<?php echo fsel_get_todoufuken($gc, $gc->todoufuken_no) ?>
</select>
<label class="ml15" style="display:inline;">
<input type="checkbox" name="relocation_flg" id="relocation_flg" value="1"<?php echo $gc->relocation_flg_checked?>>
<span style="color:#000;">リロケーション</span>
</label>
<button type="button" class="button color silver ml30" onclick="search_run();">検索</button>
</p>
</div>
<div class="cl"> </div>
</form>
</div>
<!-- End Form -->
<!-- Box Head -->
<div class="box-head">
<h2 class="left">抽出条件・手数料合計</h2>
<div class="right">
<div class="cl"> </div>
</div>
</div>
<!-- End Box Head -->
<!-- Form -->
<div class="form">
<div class="box-size4 left">
<p class="inline-field">
<label style="display:inline;">集計期間：</label>
<?php echo substr($gc->mbif, 0, 4) ?>年<?php echo substr($gc->mbif, 4, 2) ?>月<?php echo substr($gc->mbif, 6, 2) ?>日
～
<?php echo substr($gc->mbit, 0, 4) ?>年<?php echo substr($gc->mbit, 4, 2) ?>月<?php echo substr($gc->mbit, 6, 2) ?>日
<label class="ml20" style="display:inline;">区分：</label>
<?php echo f_hsc($gc->joken_company_kbn_nm) ?>
</p>
</div>
<div class="box-size4 left">
<p class="inline-field">
<label style="display:inline;">提携会社：</label>
<?php echo f_hsc($gc->joken_company_nm) ?>
<label class="ml20" style="display:inline;">支店名：</label>
<?php echo f_hsc($gc->joken_company_sh) ?>
<label class="ml20" style="display:inline;">所在地：</label>
<?php echo f_hsc($gc->joken_todoufuken_nm) ?>
<label class="ml20" style="display:inline;">リロケーション：</label>
<?php echo f_hsc($gc->joken_relocation_flg_nm) ?>
</p>
</div>
<div style="float:right;">
<label class="ml40" style="display:inline;">手数料合計：</label>
<?php echo number_format($gc->sum_tesuryou) ?>円
</div>
<div class="cl"> </div>
</div>
<!-- End Form -->
<!-- Box Head -->
<div class="box-head">
<h2 class="left">手数料一覧</h2>
<div class="right">
<a href="tesuryo_csv.php?mode=1&mbif=<?php echo f_hsc($gc->mbif) ?>&mbit=<?php echo f_hsc($gc->mbit) ?>&todoufuken_no=<?php echo f_hsc($gc->todoufuken_no) ?>&company_no=<?php echo f_hsc($gc->company_no) ?>&company_kbn=<?php echo f_hsc($gc->company_kbn) ?>&relocation_flg=<?php echo f_hsc($gc->relocation_flg) ?>&company_sh=<?php echo urlencode($gc->company_sh) ?>" class="custom-button"><span>CSV出力</span></a>
</div>
</div>
<!-- End Box Head -->
<!-- Table -->
<div class="table">
<?php if($row_count > 0){ ?>
<!-- Pagging -->
<div class="pagging">
<div class="box-l">
<?php echo $page_arr["cmes_str"].$page_arr["par1_str"].$page_arr["par2_str"]; ?>
</div>
<div class="box-c">
<div class="margin-center">
<?php echo $page_arr["back_str"].$page_arr["list_str"].$page_arr["deno_str"].$page_arr["next_str"]; ?>
</div>
</div>
<div class="box-r">
<label>表示件数：</label>
<?php echo $page_arr["plst_str"] ?>
</div>
</div>
<!-- End Pagging -->
<?php } ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr style="border-top:solid 1px #e0e0e0;">
<th width="200" class="ac"><a href="tesuryo_l.php<?php echo f_sq("ckn") ?>">提携会社名</a><?php echo $sort_mode["ckn"] ?></th>
<th width="40" class="ac"><a href="tesuryo_l.php<?php echo f_sq("kbn") ?>">区分</a><?php echo $sort_mode["kbn"] ?></th>
<th class="ac"><a href="tesuryo_l.php<?php echo f_sq("tod") ?>">所在地</a><?php echo $sort_mode["tod"] ?></th>
<th width="44" class="ac"><a href="tesuryo_l.php<?php echo f_sq("crl") ?>">Lプラン</a><?php echo $sort_mode["crl"] ?><br />(件数)</th>
<th width="44" class="ac"><a href="tesuryo_l.php<?php echo f_sq("crs") ?>">Sランク</a><?php echo $sort_mode["crs"] ?><br />(件数)</th>
<th width="44" class="ac"><a href="tesuryo_l.php<?php echo f_sq("cra") ?>">Aランク</a><?php echo $sort_mode["cra"] ?><br />(件数)</th>
<th width="44" class="ac"><a href="tesuryo_l.php<?php echo f_sq("crb") ?>">Bランク</a><?php echo $sort_mode["crb"] ?><br />(件数)</th>
<th width="44" class="ac"><a href="tesuryo_l.php<?php echo f_sq("crc") ?>">Cランク</a><?php echo $sort_mode["crc"] ?><br />(件数)</th>
<th width="70" class="ac"><a href="tesuryo_l.php<?php echo f_sq("tes") ?>">手数料</a><?php echo $sort_mode["tes"] ?></th>
<th width="70" class="ac"><a href="tesuryo_l.php<?php echo f_sq("jog") ?>">上限</a><?php echo $sort_mode["jog"] ?></th>
<th width="60" class="ac">詳細</th>
</tr>
<?php
$i = 0;
while ($rs->eof==false) {
$company_no = $rs->fields["company_no"];
$company_nm = $rs->fields["company_nm"];
$company_sh = $rs->fields["company_sh"];
$company_kbn = $rs->fields["company_kbn"];
$todoufuken_no = $rs->fields["todoufuken_no"];
$add1 = $rs->fields["add1"];
$rank_l = $rs->fields["sr_l"];
$rank_no1 = $rs->fields["sr_1"];
$rank_no2 = $rs->fields["sr_2"];
$rank_no3 = $rs->fields["sr_3"];
$rank_no4 = $rs->fields["sr_4"];
$sum_tesuryou_l = $rs->fields["sum_tesuryou_l"];
$sum_tesuryou_s = $rs->fields["sum_tesuryou_s"];
$sum_tesuryou_a = $rs->fields["sum_tesuryou_a"];
$sum_tesuryou_b = $rs->fields["sum_tesuryou_b"];
$sum_tesuryou_c = $rs->fields["sum_tesuryou_c"];
$jyougen = $rs->fields["jyougen"];
$todoufuken_nm = $arr_todoufuken[$todoufuken_no];
$company_kbn_nm = $arr_company_kbn[$company_kbn];
$tesuryou =$rs->fields["s_t"];
// $tesuryou =$sum_tesuryou_l + $sum_tesuryou_s + $sum_tesuryou_a + $sum_tesuryou_b + $sum_tesuryou_c;
$odd = "";
if(($i % 2)==1){
$odd = " class=\"odd\"";
}
echo "<tr".$odd.">";
echo "<td>".f_hsc($company_nm)."<br />".f_hsc($company_sh)."</td>";
echo "<td class=\"ac\">".f_hsc($company_kbn_nm)."</td>";
echo "<td>".f_hsc($todoufuken_nm.$add1)."</td>";
echo "<td class=\"ac\">".f_hsc($rank_l)."</td>";
echo "<td class=\"ac\">".f_hsc($rank_no1)."</td>";
echo "<td class=\"ac\">".f_hsc($rank_no2)."</td>";
echo "<td class=\"ac\">".f_hsc($rank_no3)."</td>";
echo "<td class=\"ac\">".f_hsc($rank_no4)."</td>";
echo "<td class=\"ar\">".f_hsc(number_format($tesuryou))."</td>";
echo "<td class=\"ar\">".f_hsc(number_format($jyougen))."</td>";
echo "<td class=\"ac\"><button type=\"button\" class=\"list-button\" onclick=\"location.href='tesuryo_d.php?company_no=".$company_no."&mbif=".$gc->mbif."&mbit=".$gc->mbit."';\">詳細</button></td>";
echo "</tr>";
$rs->move_next();
$i++;
}
$rs->free_result();
if($row_count==0){
echo "<tr>";
echo "<td colspan=\"10\" align=\"center\">データはありません。</td>";
echo "</tr>";
}
?>
</table>
<?php if($row_count > 0){ ?>
<!-- Pagging -->
<div class="pagging">
<div class="box-l">
</div>
<div class="box-c">
<div class="margin-center">
<?php echo $page_arr["back_str"].$page_arr["list_str"].$page_arr["deno_str"].$page_arr["next_str"]; ?>
</div>
</div>
<div class="box-r">
<label>表示件数：</label>
<?php echo $page_arr["plst_str"] ?>
</div>
</div>
<!-- End Pagging -->
<?php } ?>
</div>
<!-- Table -->
</div>
<!-- End Box -->
<div class="cl"> </div>
</div>
<!-- End Content -->
<div class="cl"> </div>
</div>
<!-- Main -->
</div>
</div>
<!-- End Container -->
<!-- Footer -->
<?php tcom_footer($gc) ?>
<!-- End Footer -->
</body>
</html>
<?php
}
function download_csv($gc) {
$crlf = "\r\n";
$arr_todoufuken = fsel_get_arr_todoufuken($gc);
$arr_purpose_arr = fdiv_set_purpose_array();
$arr_buken_sbt = fdiv_set_buken_sbt_array();
$arr_madori = fdiv_set_madori_array();
$arr_meigi = fdiv_set_meigi_array();
$arr_genjyou = fdiv_set_genjyou_array();
$arr_rank = fdiv_set_rank_array();
$file_str = "";
unset($line);
$line[] = csv_item_edit("案件番号");
$line[] = csv_item_edit("申込日時");
$line[] = csv_item_edit("ご利用目的");
$line[] = csv_item_edit("希望のサービス");
$line[] = csv_item_edit("物件種別");
$line[] = csv_item_edit("物件所在地");
$line[] = csv_item_edit("町名・番地");
$line[] = csv_item_edit("建物名・部屋番号");
$line[] = csv_item_edit("築年数");
$line[] = csv_item_edit("面積");
$line[] = csv_item_edit("間取り");
$line[] = csv_item_edit("名義");
$line[] = csv_item_edit("現況");
$line[] = csv_item_edit("お名前");
$line[] = csv_item_edit("フリガナ");
$line[] = csv_item_edit("電話番号");
$line[] = csv_item_edit("メールアドレス");
$line[] = csv_item_edit("お住まい");
$line[] = csv_item_edit("町名・番地");
$line[] = csv_item_edit("建物名・部屋番号");
$line[] = csv_item_edit("ご要望・ご質問など");
$line[] = csv_item_edit("ランク");
// $line[] = csv_item_edit("手数料");
$file_str.= implode(",", $line).$crlf;
/////////////////////////////////////////////////////////////
$sql = "SELECT SQL_CALC_FOUND_ROWS";
$sql.= " itm.item_no,";
$sql.= " itm.anken_no,";
$sql.= " itm.relocation_flg,";
$sql.= " itm.chintai_flg,";
$sql.= " itm.sublease_flg,";
$sql.= " itm.purpose_flg,";
$sql.= " itm.buken_sbt,";
$sql.= " itm.buken_shikucyouson_no,";
$sql.= " itm.buken_banchi,";
$sql.= " itm.buken_tatemono,";
$sql.= " itm.chikunensu,";
$sql.= " itm.menseki,";
$sql.= " itm.input_val,";
$sql.= " itm.input_kbn,";
$sql.= " itm.land_val,";
$sql.= " itm.madori_no,";
$sql.= " itm.meigi_no,";
$sql.= " itm.genjyou_no,";
$sql.= " itm.room_cnt,";
$sql.= " itm.fudousan_flg,";
$sql.= " itm.fudousan_nm,";
$sql.= " itm.bikou,";
$sql.= " itm.lname,";
$sql.= " itm.fname,";
$sql.= " itm.lname_kn,";
$sql.= " itm.fname_kn,";
$sql.= " itm.tel,";
$sql.= " itm.e_mail,";
$sql.= " itm.sumai_flg,";
$sql.= " itm.sumai_shikucyouson_no,";
$sql.= " itm.sumai_banchi,";
$sql.= " itm.sumai_tatemono,";
$sql.= " itm.moushikomibi,";
$sql.= " itm.rank_no,";
$sql.= " itm.tesuryou,";
$sql.= " itm.mukou_flg,";
$sql.= " itc.c_mukou_flg,";
$sql.= " itc.company_no,";
$sql.= " ad1.todoufuken_no AS buken_todoufuken_no,";
$sql.= " ad1.shikucyouson_nm AS buken_shikucyouson_nm,";
$sql.= " ad2.todoufuken_no AS sumai_todoufuken_no,";
$sql.= " ad2.shikucyouson_nm AS sumai_shikucyouson_nm,";
$sql.= " mco.company_no,";
$sql.= " mco.company_nm ";
$sql.= "FROM";
$sql.= " t_item itm ";
$sql.= "INNER JOIN";
$sql.= " t_item_company itc ";
$sql.= "ON";
$sql.= " itm.item_no = itc.item_no ";
$sql.= "INNER JOIN";
$sql.= " m_company mco ";
$sql.= "ON";
$sql.= " itc.company_no = mco.company_no ";
$sql.= "LEFT JOIN";
$sql.= " m_shikucyouson ad1 ";
$sql.= "ON";
$sql.= " itm.buken_shikucyouson_no = ad1.shikucyouson_no ";
$sql.= "LEFT JOIN";
$sql.= " m_shikucyouson ad2 ";
$sql.= "ON";
$sql.= " itm.sumai_shikucyouson_no = ad2.shikucyouson_no ";
$sql.= "WHERE itc.c_mukou_flg = 0 and itc.company_no=".$gc->login_company_no." ";
$sql.= "ORDER BY";
$sql.= " itm.moushikomibi DESC, mco.company_no";
$rs = $gc->db->query($sql);
$row_count = $gc->db->get_row_count();
$i = 0;
$wk_item_no = "";
$arr_company_nm = array();
while ($rs->eof==false) {
$item_no = $rs->fields["item_no"];
if($item_no != $wk_item_no){
$wk_item_no = $item_no;
if( $i > 0 ){
unset($line);
$line[] = csv_item_edit($anken_no);
$line[] = csv_item_edit($moushikomibi);
$line[] = csv_item_edit($purpose_str);
$line[] = csv_item_edit($kibou_str);
$line[] = csv_item_edit($buken_sbt_nm);
$line[] = csv_item_edit($buken_todoufuken_nm.$buken_shikucyouson_nm);
$line[] = csv_item_edit($buken_banchi);
$line[] = csv_item_edit($buken_tatemono);
$line[] = csv_item_edit($chikunensu);
$line[] = csv_item_edit($menseki);
$line[] = csv_item_edit($madori_nm);
$line[] = csv_item_edit($meigi_nm);
$line[] = csv_item_edit($genjyou_nm);
$line[] = csv_item_edit($lname.$fname);
$line[] = csv_item_edit($lname_kn.$fname_kn);
$line[] = csv_item_edit($tel);
$line[] = csv_item_edit($e_mail);
$line[] = csv_item_edit($sumai_todoufuken_nm.$sumai_shikucyouson_nm);
$line[] = csv_item_edit($sumai_banchi);
$line[] = csv_item_edit($sumai_tatemono);
$line[] = csv_item_edit($bikou);
$line[] = csv_item_edit($rank_nm);
// $line[] = csv_item_edit($tesuryou);
$file_str.= implode(",", $line).$crlf;
$arr_company_nm = array();
}
// --------------------------------------------------------------------
$anken_no = $rs->fields["anken_no"];
$relocation_flg = $rs->fields["relocation_flg"];
$chintai_flg = $rs->fields["chintai_flg"];
$sublease_flg = $rs->fields["sublease_flg"];
$purpose_flg = $rs->fields["purpose_flg"];
$buken_sbt = $rs->fields["buken_sbt"];
$buken_shikucyouson_no = $rs->fields["buken_shikucyouson_no"];
$buken_banchi = $rs->fields["buken_banchi"];
$buken_tatemono = $rs->fields["buken_tatemono"];
$chikunensu = $rs->fields["chikunensu"];
$menseki = $rs->fields["menseki"];
$input_val = $rs->fields["input_val"];
$input_kbn = $rs->fields["input_kbn"];
$land_val = $rs->fields["land_val"];
$madori_no = $rs->fields["madori_no"];
$meigi_no = $rs->fields["meigi_no"];
$genjyou_no = $rs->fields["genjyou_no"];
$room_cnt = $rs->fields["room_cnt"];
$fudousan_flg = $rs->fields["fudousan_flg"];
$fudousan_nm = $rs->fields["fudousan_nm"];
$bikou = $rs->fields["bikou"];
$lname = $rs->fields["lname"];
$fname = $rs->fields["fname"];
$lname_kn = $rs->fields["lname_kn"];
$fname_kn = $rs->fields["fname_kn"];
$tel = $rs->fields["tel"];
$e_mail = $rs->fields["e_mail"];
$sumai_flg = $rs->fields["sumai_flg"];
$sumai_shikucyouson_no = $rs->fields["sumai_shikucyouson_no"];
$sumai_banchi = $rs->fields["sumai_banchi"];
$sumai_tatemono = $rs->fields["sumai_tatemono"];
$moushikomibi = $rs->fields["moushikomibi"];
$rank_no = $rs->fields["rank_no"];
$tesuryou = $rs->fields["tesuryou"];
$mukou_flg = $rs->fields["mukou_flg"];
$purpose_str = $arr_purpose_arr[$purpose_flg];
$arr_work = array();
if($chintai_flg == 1){
$arr_work[] = "賃貸募集・賃貸管理";
}
if($sublease_flg == 1) {
$arr_work[] = "サブリース";
}
if($relocation_flg == 1) {
$arr_work[] = "リロケーション";
}
$kibou_str = implode(" ", $arr_work);
$buken_sbt_nm = $arr_buken_sbt[$buken_sbt];
$madori_nm = $arr_madori[$madori_no];
$meigi_nm = $arr_meigi[$meigi_no];
$genjyou_nm = $arr_genjyou[$genjyou_no];
if($room_cnt > 0){
$genjyou_nm = $genjyou_nm." 空き部屋数 ".$room_cnt;
}
$buken_todoufuken_no = $rs->fields["buken_todoufuken_no"];
$buken_todoufuken_nm = $arr_todoufuken[$buken_todoufuken_no];
$buken_shikucyouson_nm = $rs->fields["buken_shikucyouson_nm"];
$sumai_todoufuken_no = $rs->fields["sumai_todoufuken_no"];
$sumai_todoufuken_nm = $arr_todoufuken[$sumai_todoufuken_no];
$sumai_shikucyouson_nm = $rs->fields["sumai_shikucyouson_nm"];
$rank_nm = $arr_rank[$rank_no];
$mukou_str = "有効";
if($mukou_flg==1){
$mukou_str = "無効";
}
}
$arr_company_nm[] = $rs->fields["company_nm"];
$rs->move_next();
$i++;
}
$rs->free_result();
// ----------------------------------------------------------------
unset($line);
$line[] = csv_item_edit($anken_no);
$line[] = csv_item_edit($moushikomibi);
$line[] = csv_item_edit($purpose_str);
$line[] = csv_item_edit($kibou_str);
$line[] = csv_item_edit($buken_sbt_nm);
$line[] = csv_item_edit($buken_todoufuken_nm.$buken_shikucyouson_nm);
$line[] = csv_item_edit($buken_banchi);
$line[] = csv_item_edit($buken_tatemono);
$line[] = csv_item_edit($chikunensu);
$line[] = csv_item_edit($menseki);
$line[] = csv_item_edit($madori_nm);
$line[] = csv_item_edit($meigi_nm);
$line[] = csv_item_edit($genjyou_nm);
$line[] = csv_item_edit($lname.$fname);
$line[] = csv_item_edit($lname_kn.$fname_kn);
$line[] = csv_item_edit($tel);
$line[] = csv_item_edit($e_mail);
$line[] = csv_item_edit($sumai_todoufuken_nm.$sumai_shikucyouson_nm);
$line[] = csv_item_edit($sumai_banchi);
$line[] = csv_item_edit($sumai_tatemono);
$line[] = csv_item_edit($bikou);
$line[] = csv_item_edit($rank_nm);
// $line[] = csv_item_edit($tesuryou);
$file_str.= implode(",", $line).$crlf;
// ----------------------------------------------------------------
$file_str = mb_convert_encoding($file_str, "sjis-win", C_ENCODING);
$file_length = strlen($file_str);
$file_name = "案件.csv";
$agent = $_SERVER['HTTP_USER_AGENT'];
if(strstr($agent, "MSIE")){
$file_name = urlencode($file_name);
}
header("Content-Disposition: attachment; filename=".$file_name);
header("Content-Length:".$file_length);
header("Content-Type: application/octet-stream");
echo $file_str;
return true;
}
function download_csv_file2($gc) {
$crlf = "\r\n";
$arr_todoufuken = fsel_get_arr_todoufuken($gc);
$rank = fdiv_set_rank_array();
$file_str = "";
unset($line);
$line[] = csv_item_edit("案件番号");
$line[] = csv_item_edit("申込日");
$line[] = csv_item_edit("種別");
$line[] = csv_item_edit("延床面積(平米)");
$line[] = csv_item_edit("ランク");
$line[] = csv_item_edit("都道府県");
$line[] = csv_item_edit("市区町村");
$line[] = csv_item_edit("有効");
$line[] = csv_item_edit("無効");
$line[] = csv_item_edit("手数料");
$file_str.= implode(",", $line).$crlf;
/////////////////////////////////////////////////////////////
$gc->mbif = $_GET["mbif"];
$y = substr($gc->mbif, 0, 4);
$m = substr($gc->mbif, 4, 2);
$d = substr($gc->mbif, 6, 4);
if(!@checkdate($m, $d, $y)){
$gc->mbif = date("Ym01", time());
}
$gc->mbit = $_GET["mbit"];
$y = substr($gc->mbit, 0, 4);
$m = substr($gc->mbit, 4, 2);
$d = substr($gc->mbit, 6, 4);
if(!@checkdate($m, $d, $y)){
$gc->mbit = date("Ymt", time());
}
$gc->company_no = $_GET["company_no"];
if(!is_numeric($gc->company_no)){
$gc->company_no = 0;
}
$gc->company_nm = fdb_get_name($gc, "m_company", "company_nm", "company_no", $gc->company_no);
$arr_todoufuken = fsel_get_arr_todoufuken($gc);
$arr_buken_sbt = fdiv_set_buken_sbt_array();
$arr_rank = fdiv_set_rank_array();
$sql = sql_text_create_d_csv($gc);
$sql.= " p.item_no";
$rs = $gc->db->query($sql);
$row_count = $gc->db->get_row_count();
$i = 0;
while ($rs->eof==false) {
unset($line);
$item_no = $rs->fields["item_no"];
$anken_no = $rs->fields["anken_no"];
$buken_sbt = $rs->fields["buken_sbt"];
$menseki = $rs->fields["menseki"];
$purpose_flg = $rs->fields["purpose_flg"];
$rank_no = get_rank_d($rs);
// $rank_no = $rs->fields["rank_no"];
$todoufuken_no = $rs->fields["todoufuken_no"];
$buken_shikucyouson_no = $rs->fields["buken_shikucyouson_no"];
$shikucyouson_nm = $rs->fields["shikucyouson_nm"];
$mukou_flg = $rs->fields["mukou_flg"];
$m_cnt = $rs->fields["m_cnt"];
$y_cnt = $rs->fields["y_cnt"];
$tesuryou = get_tesuryo_d($rs);
// $tesuryou = $rs->fields["tesuryou"];
$moushikomibi = $rs->fields["moushikomibi"];
$moushikomi_d = substr($moushikomibi, 0, 4)."/".substr($moushikomibi, 5, 2)."/".substr($moushikomibi, 8, 2);
$todoufuken_nm = $arr_todoufuken[$todoufuken_no];
$buken_sbt_nm = $arr_buken_sbt[$buken_sbt];
if($rank_no != "L"){
$rank_nm = $arr_rank[$rank_no];
}else{
$rank_nm = "L";
}
/*
if($purpose_flg == 1){
$rank_nm = "L";
}
*/
$line[] = csv_item_edit($anken_no);
$line[] = csv_item_edit($moushikomi_d);
$line[] = csv_item_edit($buken_sbt_nm);
$line[] = csv_item_edit($menseki);
$line[] = csv_item_edit($rank_nm);
$line[] = csv_item_edit($todoufuken_nm);
$line[] = csv_item_edit($shikucyouson_nm);
$line[] = csv_item_edit($y_cnt);
$line[] = csv_item_edit($m_cnt);
// $line[] = csv_item_edit($mukou_flg==1?"無効":"有効");
$line[] = csv_item_edit( ( $mukou_flg==1?"0":$tesuryou ) );
// $line[] = csv_item_edit( ( $mukou_flg==1?"0":number_format($tesuryou) ) );
$file_str.= implode(",", $line).$crlf;
$rs->move_next();
$i++;
}
$rs->free_result();
$file_str = mb_convert_encoding($file_str, "sjis-win", C_ENCODING);
$file_length = strlen($file_str);
$file_name = $gc->company_nm."(".substr($gc->mbif, 0, 4)."年".substr($gc->mbif, 4, 2)."月".substr($gc->mbif, 6, 2)."日から".substr($gc->mbit, 0, 4)."年".substr($gc->mbit, 4, 2)."月".substr($gc->mbit, 6, 2).").csv";
$agent = $_SERVER['HTTP_USER_AGENT'];
if(strstr($agent, "MSIE")){
$file_name = urlencode($file_name);
}
header("Content-Disposition: attachment; filename=".$file_name);
header("Content-Length:".$file_length);
header("Content-Type: application/octet-stream");
echo $file_str;
return true;
}
function out_html($gc) {
$gc->arr_todoufuken = fsel_get_arr_todoufuken($gc);
$gc->company_kbn = $_GET["company_kbn"];
//ラジオボタン設定
fdiv_set_company_kbn_radio($gc, $gc->company_kbn, "company_kbn");
$sql = "SELECT SQL_CALC_FOUND_ROWS";
$sql.= " company_no,";
$sql.= " company_nm,";
$sql.= " company_sh,";
$sql.= " company_kbn,";
$sql.= " todoufuken_no,";
$sql.= " add1,";
$sql.= " tel,";
$sql.= " tantou,";
$sql.= " keisai_flg,";
$sql.= " ltime ";
$sql.= "FROM";
$sql.= " m_company ";
$sql.= "WHERE 0 = 0 ";
switch ($gc->company_kbn) {
case 1://大手
$sql.= "AND company_kbn = 1 ";
break;
case 2://地場
$sql.= "AND company_kbn = 2 ";
break;
default:
}
$sql.= "ORDER BY";
switch($_GET["si"]) {
case "company_kn":
$sql.= " company_kn".(($_GET["sa"]=="desc") ? " DESC" : "").", company_no ";
break;
case "company_kbn":
$sql.= " company_kbn".(($_GET["sa"]=="desc") ? " DESC" : "").", company_no ";
break;
case "syozaichi":
$sql.= " CONCAT( LPAD(COALESCE(todoufuken_no,'0'), 3, '0'), COALESCE(add1,''), COALESCE(add2,''))".(($_GET["sa"]=="desc") ? " DESC" : "").", company_no ";
break;
case "tantou":
$sql.= " tantou".(($_GET["sa"]=="desc") ? " DESC" : "").", company_no ";
break;
case "tel":
$sql.= " tel".(($_GET["sa"]=="desc") ? " DESC" : "").", company_no ";
break;
case "keisai_flg":
$sql.= " keisai_flg".(($_GET["sa"]=="desc") ? " DESC" : "").", company_no ";
break;
default:
$sql.= " company_no ";
}
$sql.= f_get_limit($gc->pn, $gc->pl, C_ORDER_LIST_COL_CNT);
$rs = $gc->db->query($sql);
$row_count = $gc->db->get_row_count();
//ページャーの設定
if($row_count > 0){
$page_arr = f_page_arr("company_l.php", $row_count, $gc->pl, C_ORDER_LIST_COL_CNT, C_ORDER_PAGE_TAG_CNT);
}
//ソート関連
$sort_mode["company_kn"] = "";
$sort_mode["company_kbn"] = "";
$sort_mode["syozaichi"] = "";
$sort_mode["tantou"] = "";
$sort_mode["tel"] = "";
$sort_mode["keisai_flg"] = "";
foreach ($sort_mode as $key => &$value) {
if($key == $_GET["si"]){
if($_GET["sa"] == "desc"){
$value = " ▼";
}else{
$value = " ▲";
}
}
}
$arr_company_kbn = fdiv_set_company_kbn_array();
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8" />
<title>提携会社一覧</title>
<!-- *** stylesheet *** -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<link href="css/custom/jquery-ui-1.9.2.custom.css" rel="stylesheet">
<!-- *** javascript *** -->
<script type="text/javascript" src="js/listpage.js" charset="utf-8"></script>
<script src="js/jquery-1.8.3.js"></script>
<script src="js/jquery-ui-1.9.2.custom.min.js"></script>
<script language="JavaScript">
<!--
var submit_flg = false;
function run_submit(fname, mode) {
document.forms[fname].mode.value = mode;
if(submit_flg==false){
//ボタン２度押し対応
submit_flg = true;
document.forms[fname].submit();
}
}
function unload_page(){
submit_flg = false;
}
window.onunload = unload_page;
$(function() {
$("input").focus( function () { this.blur(); } );
$('input[name="company_kbn"]:radio').change( function() {
run_submit("form_search", "search");
});
});
// -->
</script>
</head>
<body>
<!-- Header -->
<div id="header">
<div class="shell">
<!-- Logo + Top Nav -->
<?php tcom_header_logo_nav($gc) ?>
<!-- End Logo + Top Nav -->
<!-- Main Nav -->
<?php tcom_header_main_nav($gc, 2) ?>
<!-- End Main Nav -->
</div>
</div>
<!-- End Header -->
<!-- Container -->
<div id="container">
<div class="shell">
<!-- Small Nav -->
<div class="small-nav">
<a href="company_l.php">提携会社管理</a>
<span>></span>
提携会社一覧
</div>
<!-- End Small Nav -->
<!-- Main -->
<div id="main">
<div class="cl"> </div>
<!-- Content -->
<div id="content">
<!-- Box -->
<div class="box">
<!-- Form -->
<!-- <div class="form">
<form name="form_search" action="company_l.php" method="get" onsubmit="return false">
<input name="mode" type="hidden" value="">
<div class="box-size2 left">
<p class="inline-field">
<label style="display:inline;">表示形式：</label>
<input id="company_kbn_0" type="radio" name="company_kbn" value="0"<?php //echo $gc->company_kbn_0_checked ?> />
<label class="mr10" for="company_kbn_0" style="display:inline;font-weight: normal;">全て</label>
<input id="company_kbn_1" type="radio" name="company_kbn" value="1"<?php //echo $gc->company_kbn_1_checked ?> />
<label class="mr10" for="company_kbn_1" style="display:inline;font-weight: normal;">大手のみ</label>
<input id="company_kbn_2" type="radio" name="company_kbn" value="2"<?php //echo $gc->company_kbn_2_checked ?> />
<label class="mr10" for="company_kbn_2" style="display:inline;font-weight: normal;">地場のみ</label>
</p>
</div>
<div class="cl"> </div>
</form>
</div> -->
<!-- End Form -->
<!-- Box Head -->
<div class="box-head">
<div class="left">
<h2 class="left"><b>提携会社一覧</b></h2>
<div class="cl"> </div>
</div>
<div class="right">
<a href="company_area_csv.php" class="custom-button" style="margin-right:10px;"><span>エリア金額一括エクスポート</span></a>
<a href="company_area_insert.php" class="custom-button" style="margin-right:50px;"><span>エリア金額一括インポート</span></a>
<a href="company_e.php?mode=add" class="add-button"><span>新規追加</span></a>
<div class="cl"> </div>
</div>
</div>
<!-- End Box Head -->
<!-- Table -->
<div class="table">
<?php if($row_count > 0){ ?>
<!-- Pagging -->
<div class="pagging">
<div class="box-l">
<?php echo $page_arr["cmes_str"].$page_arr["par1_str"].$page_arr["par2_str"]; ?>
</div>
<div class="box-c">
<div class="margin-center">
<?php echo $page_arr["back_str"].$page_arr["list_str"].$page_arr["deno_str"].$page_arr["next_str"]; ?>
</div>
</div>
<div class="box-r">
<label>表示件数：</label>
<?php echo $page_arr["plst_str"] ?>
</div>
</div>
<!-- End Pagging -->
<?php } ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr style="border-top:solid 1px #e0e0e0;">
<th><a href="company_l.php<?php echo f_sq("company_kn") ?>">企業名</a><?php echo $sort_mode["company_kn"] ?></th>
<!-- <th width="40" class="ac"><a href="company_l.php<?php //echo f_sq("company_kbn") ?>">区分</a><?php //echo $sort_mode["company_kbn"] ?></th>-->
<th width="150"><a href="company_l.php<?php echo f_sq("syozaichi") ?>">所在地</a><?php echo $sort_mode["syozaichi"] ?></th>
<th width="120" class="ac"><a href="company_l.php<?php echo f_sq("tantou") ?>">担当者名</a><?php echo $sort_mode["tantou"] ?></th>
<th width="120" class="ac"><a href="company_l.php<?php echo f_sq("tel") ?>">電話番号</a><?php echo $sort_mode["tel"] ?></th>
<th width="40" class="ac"><a href="company_l.php<?php echo f_sq("keisai_flg") ?>">掲載</a><?php echo $sort_mode["keisai_flg"] ?></th>
<th width="70" class="ac">詳細</th>
</tr>
<?php
$i = 0;
while ($rs->eof==false) {
$company_no = $rs->fields["company_no"];
$company_nm = $rs->fields["company_nm"];
$company_sh = $rs->fields["company_sh"];
$company_kbn = $rs->fields["company_kbn"];
$todoufuken_no = $rs->fields["todoufuken_no"];
$add1 = $rs->fields["add1"];
$tel = $rs->fields["tel"];
$tantou = $rs->fields["tantou"];
$keisai_flg = $rs->fields["keisai_flg"];
$todoufuken_nm = $gc->arr_todoufuken[$todoufuken_no];
$company_kbn_nm = $arr_company_kbn[$company_kbn];
$odd = "";
if(($i % 2)==1){
$odd = " class=\"odd\"";
}
echo "<tr".$odd.">";
echo "<td>".f_hsc($company_nm." ".$company_sh)."</td>";
//echo "<td class=\"ac\">".f_hsc($company_kbn_nm)."</td>";
echo "<td>".f_hsc($todoufuken_nm.$add1)."</td>";
echo "<td class=\"ac\">".f_hsc($tantou)."</td>";
echo "<td class=\"ac\">".f_hsc($tel)."</td>";
echo "<td class=\"ac\">".f_hsc( ($keisai_flg==1?"○":"×") )."</td>";
echo "<td class=\"ac\"><button type=\"button\" class=\"list-button\" onclick=\"location.href='company_r.php?company_no=".$company_no."';\">詳細</button></td>";
echo "</tr>";
$rs->move_next();
$i++;
}
$rs->free_result();
if($row_count==0){
echo "<tr>";
echo "<td colspan=\"7\" align=\"center\">データはありません。</td>";
echo "</tr>";
}
?>
</table>
<?php if($row_count > 0){ ?>
<!-- Pagging -->
<div class="pagging">
<div class="box-l">
</div>
<div class="box-c">
<div class="margin-center">
<?php echo $page_arr["back_str"].$page_arr["list_str"].$page_arr["deno_str"].$page_arr["next_str"]; ?>
</div>
</div>
<div class="box-r">
<label>表示件数：</label>
<?php echo $page_arr["plst_str"] ?>
</div>
</div>
<!-- End Pagging -->
<?php } ?>
</div>
<!-- Table -->
</div>
<!-- End Box -->
<div class="cl"> </div>
</div>
<!-- End Content -->
<div class="cl"> </div>
</div>
<!-- Main -->
</div>
</div>
<!-- End Container -->
<!-- Footer -->
<?php tcom_footer($gc) ?>
<!-- End Footer -->
</body>
</html>
<?php
}
