function out_html($gc) { ?> <!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" /> </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, 0) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Main --> <div id="main"> <div class="cl"> </div> <!-- Content --> <div id="content"> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2 class="left">メニュー</h2> <div class="right"> <div class="cl"> </div> </div> </div> <!-- End Box Head --> <!-- Table --> <div class="table"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php $wk["name"] = "案件管理"; $wk["href"] = "item_l.php"; $items[] = $wk; $wk["name"] = "手数料管理"; $wk["href"] = "tesuryo_d.php"; $items[] = $wk; $wk["name"] = "ユーザー管理"; $wk["href"] = "user_l.php"; $items[] = $wk; $i = 0; foreach ($items as $item) { $name = $item["name"]; $href = $item["href"]; $odd = ""; if(($i % 2)==1){ $odd = " class=\"odd\""; } echo "<tr".$odd.">"; echo "<td><h3><a href=\"".$href."\">".f_hsc($name)."</a></h3></td>"; echo "<td width=\"70\" class=\"ac\"><button type=\"button\" class=\"list-button\" onclick=\"location.href='".$href."';\">Go</button></td>"; echo "</tr>"; $i++; } ?> </table> </div> <!-- Table --> </div> <!-- End Box --> <div class="cl"> </div> </div> <!-- End Content --> <div class="cl"> </div> </div> <!-- End Main --> </div> </div> <!-- End Container --> <!-- Footer --> <?php tcom_footer($gc) ?> <!-- End Footer --> </body> </html> <?php }
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){ //ボタン2度押し対応 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 out_html($gc) { if($gc->form_mode == "confirm"){ if($gc->act == "i"){ $gc->mode_title = "[追加・確認]"; }else{ $gc->mode_title = "[編集・確認]"; } }elseif($gc->form_mode == "message"){ if($gc->acerr == 1){ $gc->mode_title = "[エラー]";} else{ $gc->mode_title = "[完了]";} }else{ if($gc->act == "i"){ $gc->mode_title = "[追加]"; }else{ $gc->mode_title = "[編集]"; } } ?> <!DOCTYPE html> <html lang="ja"> <head> <meta charset="utf-8" /> <title>ユーザー<?php echo f_hsc($gc->mode_title)?></title> <!-- *** stylesheet *** --> <link href="css/style.css" rel="stylesheet" type="text/css" media="all" /> <!-- *** javascript *** --> <script language="JavaScript"> <!-- var submit_flg = false; function run_submit(fname, mode) { document.forms[fname].mode.value = mode; if(submit_flg==false){ //ボタン2度押し対応 submit_flg = true; document.forms[fname].submit(); } } function unload_page(){ submit_flg = false; } window.onunload = unload_page; // --> </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, 3) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> <a href="user_l.php">ユーザー管理</a> <span>></span> <a href="user_l.php">ユーザー一覧</a> <span>></span> ユーザー<?php echo f_hsc($gc->mode_title)?> </div> <!-- End Small Nav --> <!-- Main --> <div id="main"> <div class="cl"> </div> <!-- Content --> <div id="content"> <?php if($gc->mode2=="p"){ if($gc->form_mode=="confirm"){ ?> <form name="form_data" action="user_e.php" method="POST" onsubmit="return false"> <input name="mode2" type="hidden" value="p"> <input name="mode" type="hidden" value=""> <input name="user_no" type="hidden" value="<?php echo f_hsc($gc->user_no)?>"> <input name="act" type="hidden" value="<?php echo $gc->act?>"> <input name="token" type="hidden" value="<?php echo f_hsc($gc->token)?>"> <input name="password" type="hidden" value="<?php echo f_hsc($gc->password)?>"> </form> <!-- Message OK --> <div class="msg msg-ok"> <p><strong> 次の内容でよろしいですか?</strong></p> </div> <!-- End Message OK --> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2>ユーザー</h2> </div> <!-- End Box Head --> <!-- Form --> <div class="form"> <div class="box-field"> <label>パスワード</label> <div class="box-confirm"> セキュリティ保護のため、パスワードは表示されません </div> </div> </div> <!-- End Form --> <!-- Form Buttons --> <div class="buttons"> <div class="alignleft"> <button type="button" class="button color green" onclick="run_submit('form_data', 'entry')">はい</button> <button type="button" class="button color blue" onclick="run_submit('form_data', 'revision')">修正</button> </div> <div class="alignright"> </div> </div> <!-- End Form Buttons --> </div> <!-- End Box --> <?php }elseif($gc->form_mode=="message"){ ?> <!-- Message OK --> <div class="msg msg-ok"> <p><strong> <?php echo f_hsc($gc->message) ?></strong></p> </div> <!-- End Message OK --> <?php switch ($gc->db_act) { case "i": echo "<div class=\"ac\">"; echo "<a href=\"user_e.php?mode=add\">続けて新規登録</a>"; echo " "; echo "<a href=\"user_l.php\" class=\"ml10\">ユーザー一覧へ</a>"; echo "</div>"; break; case "u": case "d": echo "<div class=\"ac\"><a href=\"user_l.php\">ユーザー一覧へ</a></div>"; break; } }else{ for ($i=0; $i<$gc->msg->count; $i++) { ?> <!-- Message Error --> <div class="msg msg-error"> <p><strong> <?php echo f_hsc($gc->msg->list[$i]) ?></strong></p> </div> <!-- End Message Error --> <?php } ?> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2>ユーザー</h2> </div> <!-- End Box Head --> <form name="form_edit" action="user_e.php" method="POST" onsubmit="return false" enctype="multipart/form-data"> <input name="mode2" type="hidden" value="p" /> <input name="mode" type="hidden" value="" /> <input name="user_no" type="hidden" value="<?php echo f_hsc($gc->user_no)?>"> <input name="act" type="hidden" value="<?php echo $gc->act?>" /> <input name="token" type="hidden" value="<?php echo f_hsc($gc->token)?>" /> <input name="user_no" type="hidden" value="<?php echo f_hsc($gc->user_no)?>" /> <!-- Form --> <div class="form"> パスワードを更新します。新しいパスワードを入力してください。<br><br> <div class="box-field"> <label>パスワード<span>(必須)</span></label> <input type="password" name="password" class="field size4" value="<?php echo f_hsc($gc->password)?>" /> </div> </div> <!-- End Form --> <!-- Form Buttons --> <div class="buttons"> <div class="alignleft"> <button type="button" class="button color green" onclick="run_submit('form_edit', 'confirm')">入力確認へ</button> </div> </div> <!-- End Form Buttons --> </form> </div> <!-- End Box --> <?php } }else{ if($gc->form_mode=="confirm"){ ?> <form name="form_data" action="user_e.php" method="POST" onsubmit="return false"> <input name="mode2" type="hidden" value="u"> <input name="mode" type="hidden" value=""> <input name="act" type="hidden" value="<?php echo $gc->act?>"> <input name="token" type="hidden" value="<?php echo f_hsc($gc->token)?>"> <input name="user_no" type="hidden" value="<?php echo f_hsc($gc->user_no)?>"> <input name="user_nm" type="hidden" value="<?php echo f_hsc($gc->user_nm)?>"> <input name="user_kn" type="hidden" value="<?php echo f_hsc($gc->user_kn)?>"> <input name="user_id" type="hidden" value="<?php echo f_hsc($gc->user_id)?>"> <?php if($gc->act=="i"){ ?> <input name="password" type="hidden" value="<?php echo f_hsc($gc->password)?>"> <?php } ?> <input name="e_mail" type="hidden" value="<?php echo f_hsc($gc->e_mail)?>"> </form> <!-- Message OK --> <div class="msg msg-ok"> <p><strong> 次の内容でよろしいですか?</strong></p> </div> <!-- End Message OK --> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2>ユーザー</h2> </div> <!-- End Box Head --> <!-- Form --> <div class="form"> <div class="box-field"> <label>ユーザー名称</label> <div class="box-confirm"> <?php echo f_hsc($gc->user_nm)?> </div> </div> <div class="box-field"> <label>フリガナ</label> <div class="box-confirm"> <?php echo f_hsc($gc->user_kn)?> </div> </div> <div class="box-field"> <label>ユーザーID</label> <div class="box-confirm"> <?php echo f_hsc($gc->user_id)?> </div> </div> <?php if($gc->act=="i"){ ?> <div class="box-field"> <label>パスワード</label> <div class="box-confirm"> セキュリティ保護のため、パスワードは表示されません </div> </div> <?php } ?> <div class="box-field"> <label>E-mail</label> <div class="box-confirm"> <?php echo f_hsc($gc->e_mail)?> </div> </div> </div> <!-- End Form --> <!-- Form Buttons --> <div class="buttons"> <div class="alignleft"> <button type="button" class="button color green" onclick="run_submit('form_data', 'entry')">はい</button> <button type="button" class="button color blue" onclick="run_submit('form_data', 'revision')">修正</button> </div> <div class="alignright"> </div> </div> <!-- End Form Buttons --> </div> <!-- End Box --> <?php }elseif($gc->form_mode=="message"){ ?> <!-- Message OK --> <div class="msg msg-ok"> <p><strong> <?php echo f_hsc($gc->message) ?></strong></p> </div> <!-- End Message OK --> <?php switch ($gc->db_act) { case "i": echo "<div class=\"ac\">"; echo "<a href=\"user_e.php?mode=add\">続けて新規登録</a>"; echo " "; echo "<a href=\"user_l.php\" class=\"ml10\">ユーザー一覧へ</a>"; echo "</div>"; break; case "u": case "d": echo "<div class=\"ac\"><a href=\"user_l.php\">ユーザー一覧へ</a></div>"; break; } }else{ for ($i=0; $i<$gc->msg->count; $i++) { ?> <!-- Message Error --> <div class="msg msg-error"> <p><strong> <?php echo f_hsc($gc->msg->list[$i]) ?></strong></p> </div> <!-- End Message Error --> <?php } ?> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2>ユーザー</h2> </div> <!-- End Box Head --> <form name="form_edit" action="user_e.php" method="POST" onsubmit="return false" enctype="multipart/form-data"> <input name="mode2" type="hidden" value="u"> <input name="mode" type="hidden" value="" /> <input name="act" type="hidden" value="<?php echo $gc->act?>" /> <input name="token" type="hidden" value="<?php echo f_hsc($gc->token)?>" /> <input name="user_no" type="hidden" value="<?php echo f_hsc($gc->user_no)?>" /> <!-- Form --> <div class="form"> <div class="box-field"> <label>ユーザー名称<span>(必須)</span></label> <input type="text" name="user_nm" class="field size4" value="<?php echo f_hsc($gc->user_nm)?>" /> </div> <div class="box-field"> <label>フリガナ<span>(必須)</span></label> <input type="text" name="user_kn" class="field size4" value="<?php echo f_hsc($gc->user_kn)?>" /> </div> <div class="box-field"> <label>ユーザーID<span>(必須)</span></label> <input type="text" name="user_id" class="field size4" value="<?php echo f_hsc($gc->user_id)?>" /> </div> <?php if($gc->act=="i"){ ?> <div class="box-field"> <label>パスワード<span>(必須)</span></label> <input type="password" name="password" class="field size4" value="<?php echo f_hsc($gc->password)?>" /> </div> <?php } ?> <div class="box-field"> <label>E-mail</label> <input type="text" name="e_mail" class="field size4" value="<?php echo f_hsc($gc->e_mail)?>" /> </div> </div> <!-- End Form --> <!-- Form Buttons --> <div class="buttons"> <div class="alignleft"> <button type="button" class="button color green" onclick="run_submit('form_edit', 'confirm')">入力確認へ</button> </div> <?php if($gc->act=="u"){ ?> <div class="alignright"> <button type="button" class="button color red" onclick="run_submit('form_edit', 'delete')">削除</button> </div> <div class="alignright pos-top2"> <input id="del" name="delete_check" type="checkbox" value="1" class="pos-top2" /><label for="del">削除する</label> </div> <?php } ?> </div> <!-- End Form Buttons --> </form> </div> <!-- End Box --> <?php } } ?> <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 out_html($gc) { $sql = "SELECT SQL_CALC_FOUND_ROWS"; $sql.= " user_no,"; $sql.= " user_nm,"; $sql.= " user_kn,"; $sql.= " user_id,"; $sql.= " e_mail,"; $sql.= " last_login_time,"; $sql.= " ltime "; $sql.= "FROM"; $sql.= " m_company_user "; $sql.= "WHERE 0 = 0 and auth = 0 and company_no=".$gc->login_company_no; $sql.= " ORDER BY"; switch($_GET["si"]) { case "user_no": $sql.= " user_no".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; case "user_nm": $sql.= " user_nm".(($_GET["sa"]=="desc") ? " DESC" : "").", user_no "; break; case "user_kn": $sql.= " user_kn".(($_GET["sa"]=="desc") ? " DESC" : "").", user_no "; break; case "user_id": $sql.= " user_id".(($_GET["sa"]=="desc") ? " DESC" : "").", user_no "; break; case "e_mail": $sql.= " e_mail".(($_GET["sa"]=="desc") ? " DESC" : "").", user_no "; break; case "last_login_time": $sql.= " last_login_time".(($_GET["sa"]=="desc") ? " DESC" : "").", user_no "; break; default: $sql.= " user_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("user_l.php", $row_count, $gc->pl, C_ORDER_LIST_COL_CNT, C_ORDER_PAGE_TAG_CNT); } //ソート関連 $sort_mode["user_no"] = ""; $sort_mode["user_nm"] = ""; $sort_mode["user_kn"] = ""; $sort_mode["user_id"] = ""; $sort_mode["e_mail"] = ""; $sort_mode["last_login_time"] = ""; 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> </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, 3) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> <a href="user_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"> <!-- Box Head --> <div class="box-head"> <h2 class="left"><b>ユーザー一覧</b></h2> <div class="right"> <a href="user_e.php?mode=add" class="add-button"><span>新規追加</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="60" class="ac"><a href="user_l.php<?php echo f_sq("user_no") ?>">No.</a><?php echo $sort_mode["user_no"] ?></th> <th width="150"><a href="user_l.php<?php echo f_sq("user_nm") ?>">ユーザー名</a><?php echo $sort_mode["user_nm"] ?></th> <th width="150"><a href="user_l.php<?php echo f_sq("user_kn") ?>">フリガナ</a><?php echo $sort_mode["user_kn"] ?></th> <th><a href="user_l.php<?php echo f_sq("e_mail") ?>">E-mail</a><?php echo $sort_mode["e_mail"] ?></th> <th width="120" class="ac"><a href="user_l.php<?php echo f_sq("user_id") ?>">ログインID</a><?php echo $sort_mode["user_id"] ?></th> <th width="120" class="ac"><a href="user_l.php<?php echo f_sq("last_login_time") ?>">最終ログイン日時</a><?php echo $sort_mode["last_login_time"] ?></th> <th width="70" class="ac">詳細</th> <th width="100" class="ac">パスワード変更</th> </tr> <?php $i = 0; while ($rs->eof==false) { $user_no = $rs->fields["user_no"]; $user_nm = $rs->fields["user_nm"]; $user_kn = $rs->fields["user_kn"]; $user_id = $rs->fields["user_id"]; $e_mail = $rs->fields["e_mail"]; $last_login_time = $rs->fields["last_login_time"]; if($last_login_time != ""){ $last_login_time_d = substr($last_login_time, 0, 4)."/".substr($last_login_time, 5, 2)."/".substr($last_login_time, 8, 2); $last_login_time_t = substr($last_login_time, 11); }else{ $last_login_time_d = ""; $last_login_time_t = ""; } $odd = ""; if(($i % 2)==1){ $odd = " class=\"odd\""; } echo "<tr".$odd.">"; echo "<td class=\"ac\">".f_hsc($user_no)."</td>"; echo "<td>".f_hsc($user_nm)."</td>"; echo "<td>".f_hsc($user_kn)."</td>"; echo "<td>".f_hsc($e_mail)."</td>"; echo "<td class=\"ac\">".f_hsc($user_id)."</td>"; echo "<td class=\"ac\">".f_hsc($last_login_time_d)."<br />".f_hsc($last_login_time_t)."</td>"; echo "<td class=\"ac\"><button type=\"button\" class=\"list-button\" onclick=\"location.href='user_e.php?mode=edit&mode2=u&user_no=".$user_no."';\">詳細</button></td>"; echo "<td class=\"ac\"><button type=\"button\" class=\"list-button\" onclick=\"location.href='user_e.php?mode=edit&mode2=p&user_no=".$user_no."';\">変更</button></td>"; echo "</tr>"; $rs->move_next(); $i++; } $rs->free_result(); if($row_count==0){ echo "<tr>"; echo "<td colspan=\"6\" 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 out_html($gc) { $gc->anken_no = $_GET["anken_no"]; $sql = "SELECT SQL_CALC_FOUND_ROWS"; $sql.= " i.item_no,"; $sql.= " i.anken_no,"; $sql.= " i.buken_sbt,"; $sql.= " i.menseki,"; $sql.= " i.rank_no,"; $sql.= " i.buken_shikucyouson_no,"; $sql.= " i.mukou_flg,"; $sql.= " i.moushikomibi, "; $sql.= " c.c_mukou_flg "; $sql.= "FROM"; $sql.= " t_item i "; $sql.= "INNER JOIN"; $sql.= " m_shikucyouson s "; $sql.= "ON"; $sql.= " i.buken_shikucyouson_no = s.shikucyouson_no "; $sql.= "LEFT JOIN"; $sql.= " (select item_no,company_no,c_mukou_flg from t_item_company where company_no=".$gc->login_company_no.") as c "; $sql.= "ON"; $sql.= " i.item_no = c.item_no "; $sql.= "WHERE 0 = 0 and c.company_no=".$gc->login_company_no." "; if($gc->anken_no != ""){ $sql.= "and i.anken_no like '%".$gc->anken_no."%' "; } $sql.= "ORDER BY"; switch($_GET["si"]) { case "ank": $sql.= " i.anken_no".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; case "mbi": $sql.= " i.moushikomibi".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; case "sbt": $sql.= " i.buken_sbt".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; case "men": $sql.= " i.menseki".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; case "tod": $sql.= " s.todoufuken_no".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; case "shi": $sql.= " s.shikucyouson_no".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; case "muk": $sql.= " c.c_mukou_flg".(($_GET["sa"]=="desc") ? " DESC" : "")." "; break; default: $sql.= " i.item_no 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("item_l.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["tod"] = ""; $sort_mode["shi"] = ""; $sort_mode["muk"] = ""; 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){ //ボタン2度押し対応 submit_flg = true; document.forms[fname].submit(); } } function unload_page(){ submit_flg = false; } window.onunload = unload_page; // --> </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, 1) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> <a href="item_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="item_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 name="anken_no" type="text" class="field size3" value="<?php echo f_hsc($gc->anken_no) ?>" /> <button type="button" class="button color silver ml05" onclick="run_submit('form_search', 'search');">検索</button> </p> </div> <div class="cl"> </div> </form> </div> <!-- End Form --> <!-- Box Head --> <div class="box-head"> <h2 class="left">申込み/対応状況</h2> <div class="right"> <a href="item_csv.php" 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="item_l.php<?php echo f_sq("ank") ?>">案件番号</a><?php echo $sort_mode["ank"] ?></th> <th width="80" class="ac"><a href="item_l.php<?php echo f_sq("mbi") ?>">申込日</a><?php echo $sort_mode["mbi"] ?></th> <th width="80" class="ac"><a href="item_l.php<?php echo f_sq("sbt") ?>">種別</a><?php echo $sort_mode["sbt"] ?></th> <th width="80" class="ac"><a href="item_l.php<?php echo f_sq("men") ?>">延床面積</a><?php echo $sort_mode["men"] ?><br />(平米)</th> <th width="100" class="ac"><a href="item_l.php<?php echo f_sq("tod") ?>">都道府県</a><?php echo $sort_mode["tod"] ?></th> <th><a href="item_l.php<?php echo f_sq("shi") ?>">市区町村</a><?php echo $sort_mode["shi"] ?></th> <th width="50" class="ac"><a href="item_l.php<?php echo f_sq("muk") ?>">状態</a><?php echo $sort_mode["muk"] ?></th> <th width="70" 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"]; $menseki = $rs->fields["menseki"]; $rank_no = $rs->fields["rank_no"]; $buken_shikucyouson_no = $rs->fields["buken_shikucyouson_no"]; $mukou_flg = $rs->fields["mukou_flg"]; $c_mukou_flg = $rs->fields["c_mukou_flg"]; $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); $arr = fdiv_set_buken_sbt_array(); $buken_sbt_nm = $arr[$buken_sbt]; $arr = fdiv_set_rank_array(); $rank_nm = $arr[$rank_no]; $buken_shikucyouson_nm = fdb_get_name($gc, "m_shikucyouson", "shikucyouson_nm", "shikucyouson_no", $buken_shikucyouson_no); $todoufuken_no = fdb_get_name($gc, "m_shikucyouson", "todoufuken_no", "shikucyouson_no", $buken_shikucyouson_no); $todoufuken_nm = fdb_get_name($gc, "m_todoufuken", "todoufuken_nm", "todoufuken_no", $todoufuken_no); $odd = ""; if(($i % 2)==1){ $odd = " class=\"odd\""; } echo "<tr".$odd.">"; echo "<td class=\"ac\">".f_hsc($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($todoufuken_nm)."</td>"; echo "<td>".f_hsc($buken_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=\"ac\"><button type=\"button\" class=\"list-button\" onclick=\"location.href='item_e.php?mode=edit&item_no=".$item_no."';\">詳細</button></td>"; echo "</tr>"; $rs->move_next(); $i++; } $rs->free_result(); if($row_count==0){ echo "<tr>"; echo "<td colspan=\"8\" 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 out_html($gc) { ?> <!DOCTYPE html> <html lang="ja"> <head> <meta charset="utf-8" /> <title>案件CSVダウンロード</title> <!-- *** stylesheet *** --> <link href="css/style.css" rel="stylesheet" type="text/css" media="all" /> </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, 1) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> <a href="item_l.php">案件管理</a> <span>></span> <a href="item_l.php">申込み/対応状況</a> <span>></span> 案件CSVダウンロード </div> <!-- End Small Nav --> <!-- Main --> <div id="main"> <div class="cl"> </div> <!-- Content --> <div id="content"> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2 class="left"><b>案件CSVダウンロード</b></h2> <div class="right"> </div> </div> <!-- End Box Head --> <div class="ac" style="padding:20px;"> ダウンロードに失敗しました。 </div> <!-- Form Buttons --> <div class="buttons"> <div class="ac"> <button type="button" class="button color green" onclick="history.back();">戻る</button> </div> </div> <!-- End Form Buttons --> </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 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 = "指定なし"; } //ベースSQLの作成 $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){ //ボタン2度押し対応 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 out_html($gc) { ?> <!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" /> </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, 0) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> 郵便番号設定 </div> <!-- End Small Nav --> <!-- Main --> <div id="main"> <div class="cl"> </div> <!-- Content --> <div id="content"> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2 class="left"><b>郵便番号設定</b></h2> <div class="right"> </div> </div> <!-- End Box Head --> <div class="ac" style="padding:20px;"> <?php db_entry($gc) ?> 件登録しました。 </div> </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 out_html($gc) { ?> <!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 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){ //ボタン2度押し対応 submit_flg = true; document.forms[fname].submit(); } } function unload_page(){ submit_flg = false; } window.onunload = unload_page; $(function() { //確認ダイアログ設定 $('#dialog_confirm').dialog({ autoOpen: false, resizable: false, modal: true, width: 600 }); //企業ごと確認ダイアログ設定 $('#dialog_confirm_c').dialog({ autoOpen: false, resizable: false, modal: true, width: 600 }); }); function open_dialog_confirm(){ $('#dialog_confirm').dialog('open'); } function update_confirm_cancel() { $("#dialog_confirm").dialog("close"); } function open_dialog_confirm_c(flg,c_no){ $('#dcc_flg').text(flg); $('#dcc_cno').text(c_no); if(flg==1){ $('#dcc_msg').text('選択した企業を無効にしますか?'); }else{ $('#dcc_msg').text('選択した企業を有効にしますか?'); } $('#dialog_confirm_c').dialog('open'); } function update_confirm_cancel_c() { $("#dialog_confirm_c").dialog("close"); } function update_confirm_ok(){ var date = new Date(); var timestamp = date.getTime(); var query = "time=" + timestamp; query += "&mode=mukou_flg"; query += "&item_no=<?php echo $gc->item_no ?>"; query += "&flg=<?php echo ($gc->mukou_flg==0?"1":"0") ?>"; $.ajax({ type: "POST", url: "ajx_item.php", dataType: "text", data: query, cache: false, async: false, complete: function(XMLHttpRequest, textStatus){ if(textStatus=="success"){ if(XMLHttpRequest.responseText != "OK"){ alert("更新処理に失敗しました。"); }else{ location.reload(); } }else{ alert("通信エラーが発生しました。"); } } }); } function update_confirm_ok_c(){ var edit_flg = $('#dcc_flg').text(); var edit_cno = $('#dcc_cno').text(); var date = new Date(); var timestamp = date.getTime(); var query = "time=" + timestamp; query += "&mode=c_mukou_flg"; query += "&item_no=<?php echo $gc->item_no ?>"; query += "&company_no=" + edit_cno; query += "&flg=" + edit_flg; $.ajax({ type: "POST", url: "ajx_item.php", dataType: "text", data: query, cache: false, async: false, complete: function(XMLHttpRequest, textStatus){ if(textStatus=="success"){ if(XMLHttpRequest.responseText != "OK"){ alert("更新処理に失敗しました。"); }else{ location.reload(); } }else{ alert("通信エラーが発生しました。"); } } }); } </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, ($gc->referrer=="tesuryo_d"?5:1)) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <?php if($gc->referrer=="tesuryo_d"){ ?> <!-- Small Nav --> <div class="small-nav"> <a href="tesuryo_d.php">手数料管理</a> <span>></span> <a href="tesuryo_d.php?company_no=<?php echo $gc->company_no ?>&mbif=<?php echo $gc->mbif ?>&mbit=<?php echo $gc->mbit ?>">手数料一覧</a> <span>></span> 詳細 </div> <!-- End Small Nav --> <?php }else{ ?> <!-- Small Nav --> <div class="small-nav"> <a href="item_l.php">案件管理</a> <span>></span> <a href="item_l.php">申込み/対応状況</a> <span>></span> 詳細 </div> <!-- End Small Nav --> <?php } ?> <!-- Main --> <div id="main"> <div class="cl"> </div> <!-- Content --> <div id="content"> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2>案件詳細</h2> </div> <!-- End Box Head --> <!-- Form --> <div class="form"> <div class="box-field"> <label>物件情報及び個人情報</label> <div class="box-confirm" style='font-family: "MS ゴシック",monospace;'> <?php echo nl2br(str_replace(" ", " ", f_hsc($gc->naiyou))) ?> </div> </div> </div> <!-- End Form --> </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 --> <div id="dialog_confirm" title="確認"> <p class="ac mt20">更新してよろしいですか?</p> <p class="ac mt20"> <button type="button" class="button color green" onclick="update_confirm_ok()">はい</button> <button type="button" class="button color blue" onclick="update_confirm_cancel()">いいえ</button> </p> </div> <div id="dialog_confirm_c" title="確認"> <p class="ac mt20" id="dcc_msg"></p> <p class="ac mt20"> <button type="button" class="button color green" onclick="update_confirm_ok_c()">はい</button> <button type="button" class="button color blue" onclick="update_confirm_cancel_c()">いいえ</button> </p> <div style="display:none;" id="dcc_flg"></div><div style="display:none;" id="dcc_cno"></div> </div> </body> </html> <?php }
function out_html($gc) { ?> <!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"> <style> /* IEでソートするときの対応 */ .group { zoom: 1 } </style> <!-- *** javascript *** --> <script src="js/jquery-1.8.3.js"></script> <script src="js/jquery-ui-1.9.2.custom.min.js"></script> <script> $(function() { $('.group h3').click(function(){ if( $(this).attr("panelmode") == "open" ){ //閉じる処理 $(this).attr("panelmode", "close"); $(this).removeClass("ui-accordion-header-active"); $(this).removeClass("ui-state-active"); $(this).removeClass("ui-corner-top"); $(this).addClass("ui-corner-all"); $('span', this).removeClass("ui-icon-triangle-1-s"); $('span', this).addClass("ui-icon-triangle-1-e"); $('+div', this).removeClass("ui-accordion-content-active"); $('+div:not(:animated)',this).slideUp('normal'); }else{ //開く処理 get_area($('+div', this), $(this).attr("todoufuken_no")); $(this).attr("panelmode", "open"); $(this).removeClass("ui-corner-all"); $(this).addClass("ui-accordion-header-active"); $(this).addClass("ui-state-active"); $(this).addClass("ui-corner-top"); $('span', this).removeClass("ui-icon-triangle-1-e"); $('span', this).addClass("ui-icon-triangle-1-s"); $('+div', this).addClass("ui-accordion-content-active"); var d = {height:'toggle', opacity:'toggle'}; $('+div',this).animate(d); } }); }); //ランクの変更 function rank_change(o){ var selectedItem = o.options[ o.selectedIndex ]; var date = new Date(); var timestamp = date.getTime(); var query = "time=" + timestamp; query += "&mode=rank"; query += "&shikucyouson_no=" + $(o).attr("shikucyouson_no"); query += "&rank_no=" + selectedItem.value; $.ajax({ type: "POST", url: "set_area.php", dataType: "text", data: query, cache: false, async: false, complete: function(XMLHttpRequest, textStatus){ if(textStatus=="success"){ if(XMLHttpRequest.responseText != "OK"){ alert("更新処理に失敗しました。"); } }else{ alert("通信エラーが発生しました。"); } } }); } function get_area(pnl, todoufuken_no){ var date = new Date(); var timestamp = date.getTime(); var query = "time=" + timestamp; query += "&mode=area_l"; query += "&todoufuken_no=" + todoufuken_no; $.ajax({ type: "POST", url: "get_area.php", dataType: "html", data: query, cache: false, async: false, complete: function(XMLHttpRequest, textStatus){ if(textStatus=="success"){ pnl.empty(); pnl.html(XMLHttpRequest.responseText); }else{ alert("通信エラーが発生しました。"); } } }); } function set_area(order){ var date = new Date(); var timestamp = date.getTime(); var query = "time=" + timestamp; query += "&mode=shikucyouson"; query += "&" + order; $.ajax({ type: "POST", url: "set_area.php", dataType: "text", data: query, cache: false, async: false, complete: function(XMLHttpRequest, textStatus){ if(textStatus=="success"){ if(XMLHttpRequest.responseText != "OK"){ alert("ソート処理に失敗しました。"); } }else{ alert("通信エラーが発生しました。"); } } }); } </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, 3) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> <a href="area_r.php">エリア管理</a> <span>></span> <a href="area_r.php">対応エリア</a> <span>></span> 地域ランク編集 </div> <!-- End Small Nav --> <!-- Main --> <div id="main"> <div class="cl"> </div> <!-- Content --> <div id="content"> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2 class="left"><b>地域ランク編集</b></h2> <div class="right"> <a href="area_sort.php?mode=add" class="custom-button"><span>都道府県ソートモード</span></a> </div> </div> <!-- End Box Head --> <!-- Accordion --> <div class="Accordion" style="padding:15px 10px;"> <!-- Accordion --> <div class="ui-accordion ui-widget ui-helper-reset"> <?php $sql = "SELECT"; $sql.= " todoufuken_no,"; $sql.= " todoufuken_nm,"; $sql.= " ltime "; $sql.= "FROM"; $sql.= " m_todoufuken "; $sql.= "ORDER BY"; $sql.= " sort_no"; $rs = $gc->db->query($sql); $i = 0; while ($rs->eof==false) { $todoufuken_no = $rs->fields["todoufuken_no"]; $todoufuken_nm = $rs->fields["todoufuken_nm"]; ?> <div class="group"> <h3 panelmode="close" todoufuken_no="<?php echo f_hsc($todoufuken_no) ?>" class="ui-accordion-header ui-helper-reset ui-state-default ui-accordion-icons ui-corner-all"> <span class="ui-accordion-header-icon ui-icon ui-icon-triangle-1-e"></span> <?php echo f_hsc($todoufuken_nm) ?></h3> <div style="display: none;" class="ui-accordion-content ui-helper-reset ui-widget-content ui-corner-bottom"> </div> </div> <?php $rs->move_next(); $i++; } $rs->free_result(); ?> </div> </div> <!-- Accordion --> </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 out_html($gc) { ?> <!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"> <style> /* IEでソートするときの対応 */ .group { zoom: 1 } </style> <!-- *** javascript *** --> <script src="js/jquery-1.8.3.js"></script> <script src="js/jquery-ui-1.9.2.custom.min.js"></script> <script type="text/javascript"> $(function() { var elList = $("#sortable"); elList.sortable({ items:".sort-item", axis: "y", handle: ".handle", scroll: true, distance: 7, update: function(event, ui) { var order = elList.sortable("serialize"); set_area(order); } }); }); function set_area(order){ var date = new Date(); var timestamp = date.getTime(); var query = "time=" + timestamp; query += "&mode=todoufuken"; query += "&" + order; $.ajax({ type: "POST", url: "set_area.php", dataType: "text", data: query, cache: false, async: false, complete: function(XMLHttpRequest, textStatus){ if(textStatus=="success"){ if(XMLHttpRequest.responseText != "OK"){ alert("ソート処理に失敗しました。"); } }else{ alert("通信エラーが発生しました。"); } } }); } </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, 3) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> <a href="area_r.php">エリア管理</a> <span>></span> <a href="area_r.php">対応エリア</a> <span>></span> <a href="area_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"> <!-- Box Head --> <div class="box-head"> <h2 class="left"><b>都道府県ソート</b></h2> <div class="right"> <a href="area_l.php" class="custom-button"><span>地域ランク編集</span></a> </div> </div> <!-- End Box Head --> <!-- Table --> <div class="table" id="sortable"> <table class="group" width="100%" border="0" cellspacing="0" cellpadding="0"> <tr style="border-top:solid 1px #e0e0e0;"> <th width="20" class="ac"> </th> <th width="60" class="ac">No.</th> <th>都道府県</th> </tr> <tbody> <?php $sql = "SELECT"; $sql.= " todoufuken_no,"; $sql.= " todoufuken_nm,"; $sql.= " ltime "; $sql.= "FROM"; $sql.= " m_todoufuken "; $sql.= "ORDER BY"; $sql.= " sort_no"; $rs = $gc->db->query($sql); while ($rs->eof==false) { $todoufuken_no = $rs->fields["todoufuken_no"]; $todoufuken_nm = $rs->fields["todoufuken_nm"]; echo "<tr id=\"item-".$todoufuken_no."\" class=\"sort-item\">"; echo "<td class=\"ac\"><span class=\"handle ui-icon ui-icon-arrowthick-2-n-s\" style=\"float:left;cursor:ns-resize;\"></span></td>"; echo "<td class=\"ac\">".f_hsc($todoufuken_no)."</td>"; echo "<td>".f_hsc($todoufuken_nm)."</td>"; echo "</tr>"; $rs->move_next(); } $rs->free_result(); ?> </tbody> </table> </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 out_html($gc) { ?> <!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"> <style> /* IEでソートするときの対応 */ .group { zoom: 1 } </style> <!-- *** javascript *** --> <script src="js/jquery-1.8.3.js"></script> <script src="js/jquery-ui-1.9.2.custom.min.js"></script> <script> $(function() { $("#tabs").tabs(); $('.group h3').click(function(){ if( $(this).attr("panelmode") == "open" ){ //閉じる処理 $(this).attr("panelmode", "close"); $(this).removeClass("ui-accordion-header-active"); $(this).removeClass("ui-state-active"); $(this).removeClass("ui-corner-top"); $(this).addClass("ui-corner-all"); $('span', this).removeClass("ui-icon-triangle-1-s"); $('span', this).addClass("ui-icon-triangle-1-e"); $('+div', this).removeClass("ui-accordion-content-active"); $('+div:not(:animated)',this).slideUp('normal'); }else{ //開く処理 $(this).attr("panelmode", "open"); $(this).removeClass("ui-corner-all"); $(this).addClass("ui-accordion-header-active"); $(this).addClass("ui-state-active"); $(this).addClass("ui-corner-top"); $('span', this).removeClass("ui-icon-triangle-1-e"); $('span', this).addClass("ui-icon-triangle-1-s"); $('+div', this).addClass("ui-accordion-content-active"); var d = {height:'toggle', opacity:'toggle'}; $('+div',this).animate(d); } }); }); </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, 3) ?> <!-- End Main Nav --> </div> </div> <!-- End Header --> <!-- Container --> <div id="container"> <div class="shell"> <!-- Small Nav --> <div class="small-nav"> <a href="area_r.php">エリア管理</a> <span>></span> 対応エリア </div> <!-- End Small Nav --> <!-- Main --> <div id="main"> <div class="cl"> </div> <!-- Content --> <div id="content"> <!-- Box --> <div class="box"> <!-- Box Head --> <div class="box-head"> <h2 class="left"><b>対応エリア</b></h2> <div class="right"> <a href="area_csv.php" class="custom-button"><span>CSV出力</span></a> </div> </div> <!-- End Box Head --> <!-- Tabs --> <div id="tabs" style="margin:15px 10px;"> <ul> <li><a href="#tabs-1">Sランク</a></li> <li><a href="#tabs-2">Aランク</a></li> <li><a href="#tabs-3">Bランク</a></li> <li><a href="#tabs-4">Cランク</a></li> <li><a href="#tabs-0"> な し </a></li> </ul> <div id="tabs-1"> <?php out_html_todoufuken($gc, 1) ?> </div> <div id="tabs-2"> <?php out_html_todoufuken($gc, 2) ?> </div> <div id="tabs-3"> <?php out_html_todoufuken($gc, 3) ?> </div> <div id="tabs-4"> <?php out_html_todoufuken($gc, 4) ?> </div> <div id="tabs-0"> <?php out_html_todoufuken($gc, 0) ?> </div> </div> <!-- End Tabs --> <!-- Form Buttons --> <div class="buttons"> <div class="ac"> <button type="button" class="button color green" onclick="location.href='area_l.php'">地域ランクを編集</button> </div> </div> <!-- End Form Buttons --> </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 }