if (!$calupdate_result) { $alert_cal = $msg_row['4']['msg']; } else { $alert_cal = $msg_row['10']['msg']; } } } if (isset($_POST['caldel'])) { $caldel_query_str = <<<EOM \tDELETE \tFROM \t\tcalData \tWHERE \t\tcal_id = {$_POST['caldel']}; EOM; $caldel_result = RUN_SQLI_DEFAULTLOGIN($caldel_query_str); if (!$caldel_result) { $alert_cal = $msg_row['15']['msg']; } else { $alert_cal = $msg_row['12']['msg']; } } ?> <?php manage_htmlhead(); ?> <?php
echo <<<EOT \t\t\t\t\t\t<div class="checkbox"> \t\t\t\t\t\t<label> \t <input type="checkbox" name="bknum" value="{{$uf_syokusyu_result['job_category']}" checked="checked"> {$uf_syokusyu_result['job_category']} \t </label> \t </div> EOT; } echo <<<EOT \t\t </div> \t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-6"> \t\t\t\t\t\t\t\t\t\t\t\t\t<label class="col-sm-2 control-label">企業</label> \t\t\t\t\t\t\t\t\t\t\t\t\t<div class="col-sm-10"> EOT; $userfirst_comp_sql = RUN_SQLI_DEFAULTLOGIN("SELECT DISTINCT comp_name FROM comp_info"); while ($uf_comp_result = $userfirst_comp_sql->fetch_assoc()) { echo <<<EOT \t\t\t\t\t\t<div class="checkbox"> \t\t\t\t\t\t<label> \t <input type="checkbox" name="bknum" value="{{$uf_comp_result['comp_name']}" checked="checked"> {$uf_comp_result['comp_name']} \t </label> \t </div> EOT; } echo <<<EOT \t\t </div> \t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t</form> \t\t\t\t\t\t
function user_form_sort_v1() { global $rootURLdist; echo <<<EOT <div class="panel panel-default"> <div class="panel-body"> \t<form class="form-horizontal" action="{$rootURLdist}swipeTest.php#main_jobvote_new" method="GET"> \t\t <fieldset> \t\t\t\t<legend><i class="mdi-action-search"></i>検索</legend> \t\t\t\t<div class="row"> \t\t\t\t\t<div class="col-md-6"> \t\t\t\t <div class="form-group"> \t\t\t\t <label for="textArea" class="col-lg-3 control-label">フリーワード検索</label> \t\t\t\t <div class="col-lg-9"> \t\t\t\t <textarea name="ufs_ft" class="form-control" rows="3" placeholder="企業名(漢字・カナ)、所在地(漢字)などの部分一致検索" id="textArea"></textarea> \t\t\t\t <span class="help-block">フリーワードで企業名、職種、紹介文などから検索します。</span> \t\t\t\t </div> \t\t\t\t </div> \t\t\t\t\t\t<div class="form-group"> \t\t\t\t <label for="select" class="col-lg-3 control-label">雇用形態</label> \t\t\t\t <div class="col-lg-9"> \t\t\t\t <select class="form-control" name="ufs_bf" id="select"> \t\t\t\t\t\t\t\t\t<option>--</option> EOT; $businessform_option_sort = RUN_SQLI_DEFAULTLOGIN("SELECT DISTINCT business_form FROM job_info ORDER BY business_form DESC"); while ($bfos = $businessform_option_sort->fetch_assoc()) { echo <<<EOT \t\t\t<option>{$bfos['business_form']}</option> EOT; } echo <<<EOT \t\t\t\t </select> \t\t\t\t </div> \t\t\t\t </div> \t\t\t\t\t</div> \t\t\t\t\t<div class="col-md-6"> \t\t\t\t <div class="form-group"> \t\t\t\t <label for="select" class="col-lg-2 control-label">業種</label> \t\t\t\t <div class="col-lg-10"> \t\t\t\t <select class="form-control" name="ufs_cb" id="select"> \t\t\t\t\t\t\t\t\t<option>--</option> EOT; $compbusiness_option_sort = RUN_SQLI_DEFAULTLOGIN("SELECT DISTINCT comp_business FROM comp_info ORDER BY comp_business DESC"); while ($cbos = $compbusiness_option_sort->fetch_assoc()) { echo <<<EOT \t\t\t<option>{$cbos['comp_business']}</option> EOT; } echo <<<EOT \t\t\t\t </select> \t\t\t\t </div> \t\t\t\t </div> \t\t\t\t\t\t<div class="form-group"> \t\t\t\t <label for="select" class="col-lg-2 control-label">職種</label> \t\t\t\t <div class="col-lg-10"> \t\t\t\t <select class="form-control" name="ufs_jc" id="select"> \t\t\t\t\t\t\t\t\t<option>--</option> EOT; $jobcategory_option_sort = RUN_SQLI_DEFAULTLOGIN("SELECT DISTINCT job_category FROM job_info ORDER BY job_category DESC"); while ($jcos = $jobcategory_option_sort->fetch_assoc()) { echo <<<EOT \t\t\t<option>{$jcos['job_category']}</option> EOT; } echo <<<EOT \t\t\t\t </select> \t\t\t\t </div> \t\t\t\t </div> \t\t\t\t\t\t<div class="form-group"> \t\t\t\t <label for="select" class="col-lg-2 control-label">企業</label> \t\t\t\t <div class="col-lg-10"> \t\t\t\t <select class="form-control" name="ufs_cn" id="select"> \t\t\t\t\t\t\t\t\t<option>--</option> EOT; $comp_option_sort = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM comp_info ORDER BY comp_name DESC"); while ($cos_row = $comp_option_sort->fetch_assoc()) { echo <<<EOT \t\t\t<option>{$cos_row['comp_name']}</option> EOT; } echo <<<EOT \t\t\t\t </select> \t\t\t\t </div> \t\t\t\t </div> \t\t\t\t\t</div> \t\t\t\t</div> \t\t\t\t<div class="row"> \t\t\t\t\t<div class="col-md-12"> \t\t\t\t\t\t<div class="btn-group btn-group-justified" role="group" aria-label=""> \t\t\t\t\t\t <div class="btn-group" role="group"> \t\t\t\t\t\t\t<button type="submit" class="btn btn-primary" name="serch_adoption"><i class="mdi-action-search"></i><span style="vertical-align: 5px;">検索</span></button> \t\t\t\t\t\t </div> \t\t\t\t\t\t</div> \t\t\t\t\t</div> \t\t\t\t</div> \t\t </fieldset> \t\t</form> </div> </div> EOT; }
include 'managefunctions.php'; include 'manageHTMLdoc.php'; include 'manageContent.php'; include 'manageHeader.php'; if (empty($_SESSION['managename'])) { $_SESSION['ERR_LOGIN'] = $msg_row['4']['msg']; header("Location: {$rootURLmanage}managelogin.php"); } if (isset($_POST['submit_compadd'])) { if (empty($_POST['comp_name']) or empty($_POST['comp_name_kana']) or empty($_POST['comp_zipcode']) or empty($_POST['comp_street_address']) or empty($_POST['comp_ceo_name']) or empty($_POST['comp_adopt_name']) or empty($_POST['comp_tel1']) or empty($_POST['comp_email']) or empty($_POST['comp_business'])) { $add_alert = $msg_row['8']['msg']; } else { $compadd_result = RUN_SQLI_DEFAULTLOGIN("INSERT INTO \n\t\t\t\t\tcomp_info(\n\t\t\t\t\t\tcomp_name,\n\t\t\t\t\t\tcomp_name_kana,\n\t\t\t\t\t\tcomp_zipcode,\n\t\t\t\t\t\tcomp_street_address,\n\t\t\t\t\t\tcomp_ceo_name,\n\t\t\t\t\t\tcomp_adopt_name,\n\t\t\t\t\t\tcomp_fundation,\n\t\t\t\t\t\tcomp_public,\n\t\t\t\t\t\tcomp_capital,\n\t\t\t\t\t\tcomp_annual_business,\n\t\t\t\t\t\tcomp_tel_1,\n\t\t\t\t\t\tcomp_fax_1,\n\t\t\t\t\t\tcomp_tel_2,\n\t\t\t\t\t\tcomp_fax_2,\n\t\t\t\t\t\tcomp_url,\n\t\t\t\t\t\tcomp_email,\n\t\t\t\t\t\tcomp_employee_male,\n\t\t\t\t\t\tcomp_employee_female,\n\t\t\t\t\t\tcomp_a_ns,\n\t\t\t\t\t\tcomp_b_ns,\n\t\t\t\t\t\tcomp_c_ns,\n\t\t\t\t\t\tcomp_business,\n\t\t\t\t\t\tcomp_other_1\n\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t'{$_POST['comp_name']}',\n\t\t\t\t\t\t'{$_POST['comp_name_kana']}',\n\t\t\t\t\t\t'{$_POST['comp_zipcode']}',\n\t\t\t\t\t\t'{$_POST['comp_street_address']}',\n\t\t\t\t\t\t'{$_POST['comp_ceo_name']}',\n\t\t\t\t\t\t'{$_POST['comp_adopt_name']}',\n\t\t\t\t\t\t'{$_POST['comp_foundation']}',\n\t\t\t\t\t\t'{$_POST['comp_public']}',\n\t\t\t\t\t\t'{$_POST['comp_capital']}',\n\t\t\t\t\t\t'{$_POST['comp_annual_business']}',\n\t\t\t\t\t\t'{$_POST['comp_tel1']}',\n\t\t\t\t\t\t'{$_POST['comp_fax1']}',\n\t\t\t\t\t\t'{$_POST['comp_tel2']}',\n\t\t\t\t\t\t'{$_POST['comp_fax2']}',\n\t\t\t\t\t\t'{$_POST['comp_url']}',\n\t\t\t\t\t\t'{$_POST['comp_email']}',\n\t\t\t\t\t\t'{$_POST['comp_employee_mele']}',\n\t\t\t\t\t\t'{$_POST['comp_employee_female']}',\n\t\t\t\t\t\t'{$_POST['comp_a_ns']}',\n\t\t\t\t\t\t'{$_POST['comp_b_ns']}',\n\t\t\t\t\t\t'{$_POST['comp_c_ns']}',\n\t\t\t\t\t\t'{$_POST['comp_business']}',\n\t\t\t\t\t\t'{$_POST['comp_other1']}'\n\t\t\t\t\t)"); if (!$compadd_result) { $serch_compname = RUN_SQLI_DEFAULTLOGIN("SELECT comp_name FROM comp_info WHERE comp_name = '{$_POST['comp_name']}'"); if (mysqli_num_rows($serch_compname) != 0) { $add_alert = $msg_row['9']['msg'] . "<br>または「{$_POST['comp_name']}」はすでに登録されています。"; } else { $add_alert = $msg_row['9']['msg']; } } else { $add_alert = $msg_row['1']['msg']; } } } ?> <?php manage_htmlhead();
include 'manageHeader.php'; if (empty($_SESSION['managename'])) { $_SESSION['ERR_LOGIN'] = $msg_row['4']['msg']; header("Location: {$rootURLmanage}managelogin.php"); } if (isset($_POST['userdel'])) { RUN_SQLI_DEFAULTLOGIN("DELETE FROM `testOpenDev1_db`.`user` WHERE `user`.`no` = {$_POST['userdel']}"); } if (isset($_POST['user_update'])) { if ($_POST['username'] == "" or $_POST['useremail'] == "") { $add_alert = $msg_row['7']['msg']; } else { $username = $_POST['username']; $useremail = $_POST['useremail']; $yyyymmdd = $_REQUEST['year'] . $_REQUEST['month'] . $_REQUEST['day']; $result = RUN_SQLI_DEFAULTLOGIN("UPDATE user SET user_name='{$_POST['username']}',user_email='{$_POST['useremail']}',user_birth='{$yyyymmdd}' WHERE no = {$_POST['user_update']}"); if (!$result) { $add_alert = $msg_row['2']['msg']; } else { $add_alert = "「{$_POST['username']}」の情報を" . $msg_row['10']['msg']; } } } ?> <?php manage_htmlhead(); ?>
header("Location: {$rootURLmanage}managelogin.php"); } if (isset($_POST[''])) { RUN_SQLI_DEFAULTLOGIN(""); } if (isset($_POST['jobdel'])) { RUN_SQLI_DEFAULTLOGIN("DELETE FROM job_info WHERE job_info.job_info_id = {$_POST['jobdel']}"); } if (isset($_POST['job_update'])) { $compnameid = RUN_SQLI_DEFAULTLOGIN("SELECT comp_id FROM comp_info WHERE comp_name = '{$_REQUEST['select_compname']}'"); if ($compnameid->num_rows != 0) { $compnameid_result = $compnameid->fetch_assoc(); if (empty($_POST['business_form']) or empty($_POST['business_educational']) or empty($_POST['business_job_category']) or empty($_POST['business_base_salary'])) { $add_alert = $msg_row['8']['msg']; } else { $job_update = RUN_SQLI_DEFAULTLOGIN("\n\t\t\t\tUPDATE\n\t\t\t\t\tjob_info\n\t\t\t\tSET\n\t\t\t\t\tcomp_id={$compnameid_result['comp_id']},\n\t\t\t\t\tbusiness_form='{$_POST['business_form']}',\n\t\t\t\t\teducational='{$_POST['business_educational']}',\n\t\t\t\t\tjob_category='{$_POST['business_job_category']}',\n\t\t\t\t\tjob_discription='{$_POST['business_discription']}',\n\t\t\t\t\tbase_salary='{$_POST['business_base_salary']}',\n\t\t\t\t\tcommuting_allowance='{$_POST['option_commuting_allowance']}',\n\t\t\t\t\thousing_allowance='{$_POST['option_housing_allowance']}',\n\t\t\t\t\tfamily_allowance='{$_POST['option_family_allowance']}',\n\t\t\t\t\tbonus='{$_POST['option_bonus']}',\n\t\t\t\t\tsalary_increase='{$_POST['option_salary_increase']}',\n\t\t\t\t\tother_allowance='{$_POST['option_other_allowance']}',\n\t\t\t\t\tave_overtime='{$_POST['ave_overtime']}',\n\t\t\t\t\tholiday='{$_POST['holiday']}',\n\t\t\t\t\tpaid_leave='{$_POST['pail_leave']}',\n\t\t\t\t\tpaid_acquisition_rate='{$_POST['accquisition_rate']}',\n\t\t\t\t\tjoin_insurance='{$_POST['option_join_insurance']}',\n\t\t\t\t\ttrial_period='{$_POST['trial_period']}',\n\t\t\t\t\tsaverance_pay='{$_POST['saverance_pay']}',\n\t\t\t\t\tbase_union='{$_POST['base_union']}',\n\t\t\t\t\tdormitory_system='{$_POST['option_dormitory_system']}',\n\t\t\t\t\tother1='{$_POST['other_1']}'\n\t\t\t\tWHERE job_info_id = {$_POST['job_update']}"); if (!$job_update) { $add_alert = $msg_row['9']['msg']; } else { $add_alert = $msg_row['1']['msg']; } } } else { } } ?> <?php manage_htmlhead(); ?>
$useremail = $_POST['useremail']; $testResult = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM user WHERE user_name = '{$username}';"); if (!$testResult) { $add_alert = $msg_row['4']['msg']; } elseif (mysqli_num_rows($testResult) != 0) { $add_alert = $msg_row['5']['msg']; } else { $testResult_email = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM user WHERE user_email = '{$useremail}';"); if (!$testResult_email) { $add_alert = $msg_row['4']['msg']; } elseif (mysqli_num_rows($testResult_email) != 0) { $add_alert = $msg_row['6']['msg']; } else { $yyyymmdd = $_REQUEST['year'] . $_REQUEST['month'] . $_REQUEST['day']; $userpassword_default = password_hash('1234', PASSWORD_DEFAULT); $result = RUN_SQLI_DEFAULTLOGIN("INSERT INTO user(user_name, user_password,user_email, user_birth) VALUES ('{$_POST['username']}','{$userpassword_default}','{$_POST['useremail']}','{$yyyymmdd}')"); if (!$result) { $add_alert = $msg_row['2']['msg']; } else { $add_alert = $msg_row['1']['msg']; } } } } } if (isset($_POST['user_reset'])) { header("Location: " . $_SERVER['PHP_SELF']); } ?>
function manage_content_cal($alert_cal) { global $mySQLAddress, $mainDbUserName, $mainDbPass, $mainDbName, $rootURLmanage, $mysqli, $msg_row; $cal_select = birthday_html(); echo <<<EOT \t\t\t<div class="row"> <div class="col-lg-12"> <h1 class="page-header"><i class="fa fa-calendar"></i> スケジュール管理</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> EOT; if (!isset($alert_cal)) { } elseif ($alert_cal == "ng") { echo <<<EOT \t\t\t<div class="row"> \t\t\t\t<div class="col-lg-12"> \t\t\t\t\t<div class="alert alert-danger alert-dismissable"> \t\t\t\t\t\t<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> \t\t\t\t\t\t\t入力項目に不足があります。大変お手数ですが、もう一度入力内容をご確認の上再度入力・登録お願い致します。 \t\t\t\t\t</div> \t\t\t\t</div> \t\t\t\t<!-- /.col-lg-12 --> \t\t\t</div> \t\t\t<!-- /.row --> EOT; } elseif ($alert_cal == "ok") { echo <<<EOT \t\t\t<div class="row"> \t\t\t\t<div class="col-lg-12"> \t\t\t\t\t<div class="alert alert-success alert-dismissable"> \t\t\t\t\t\t<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> \t\t\t\t\t\t\t登録完了しました。 \t\t\t\t\t</div> \t\t\t\t</div> \t\t\t\t<!-- /.col-lg-12 --> \t\t\t</div> \t\t\t<!-- /.row --> EOT; } else { echo <<<EOT \t\t\t<div class="row"> \t\t\t\t<div class="col-lg-12"> \t\t\t\t\t<div class="alert alert-danger alert-dismissable"> \t\t\t\t\t\t<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> \t\t\t\t\t\t\t{$alert_cal} \t\t\t\t\t</div> \t\t\t\t</div> \t\t\t\t<!-- /.col-lg-12 --> \t\t\t</div> \t\t\t<!-- /.row --> EOT; } echo <<<EOT \t\t\t<div class="row"> \t\t\t\t<div class="col-lg-12"> \t\t\t\t\t<div class="panel panel-default"> <div class="panel-heading"> スケジュール管理 </div> <!-- /.panel-heading --> <div class="panel-body"> <!-- Nav tabs --> <ul class="nav nav-tabs nav-justified"> <li class="active"><a href="#calregist" data-toggle="tab" aria-expanded="true">スケジュール登録</a> </li> <li class=""><a href="#calview" data-toggle="tab" aria-expanded="false">スケジュール閲覧・編集</a> </li> </ul> <!-- Tab panes --> <div class="tab-content"> <div class="tab-pane fade active in" id="calregist"> <h4>スケジュール登録</h4> \t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t<form role="form" method="POST"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="col-md-6"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<label>題名 <small class="text-danger">※文字数は20文字以内におさめてください。</small></label> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<input class="form-control" name="cal_contents" type="text" placeholder="例)◯◯株式会社説明会"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<label>詳細 <small class="text-danger">※文字数制限はありません。</small></label> <textarea class="form-control" name="cal_sub_contents" rows="10" placeholder="開催日時:10時 場所:午前10時 場所:本館501"></textarea> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<!--<input class="form-control" name="cal_sub_contents" type="text" placeholder="開催日時:10時 場所:午前10時 場所:本館501">--> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="col-md-6"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<label>会社名 <small class="text-danger">※必須ではありません。</small></label> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<select class="form-control" name="select_compname"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<option value="">企業を選択してください。</option> EOT; $sqli_comp_name = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM comp_info"); while ($row_comp_name = $sqli_comp_name->fetch_assoc()) { echo <<<EOT \t\t\t\t<option value="{$row_comp_name['comp_id']}">{$row_comp_name['comp_name']}</option> EOT; } echo <<<EOT \t \t\t\t\t\t</select> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<label>予定日時 <small class="text-danger">※3ヶ月以前のものは表示されません。(登録は可能)</small></label> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$cal_select} \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<button type="submit" name="cal_submit" class="btn btn-primary btn-block"><i class="fa fa-check"></i> 登録</button> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t</form> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t </div> <div class="tab-pane fade" id="calview"> <h4>スケジュール閲覧・編集</h4> \t\t\t\t\t\t\t\t\t<p class="text-danger"><small>※直近のものから表示されます。また、表示3ヶ月前のものは表示されません。表示されない場合は再登録してください。</small></p> \t\t\t\t\t\t\t\t\t<div class="panel-group" id="accordion"> \t\t\t\t\t\t\t\t\t EOT; $today = date('Y-m-d'); $manage_cal_result = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM calData LEFT OUTER JOIN comp_info ON calData.cal_comp_id = comp_info.comp_id WHERE cal_date >= '{$today}' ORDER BY cal_date ASC"); while ($manage_cal_row = $manage_cal_result->fetch_assoc()) { $def_date = explode("-", $manage_cal_row['cal_date']); $def_year = $def_date[0]; $def_month = $def_date[1]; $def_day = $def_date[2]; $caldate_select = birthday_html($def_year, $def_month, $def_day); $manage_cal_row_crlf = nl2br($manage_cal_row['cal_sub_contents']); echo <<<EOT \t\t \t\t\t\t\t\t\t\t\t \t\t <div class="panel panel-default"> \t\t <div class="panel-heading"> \t\t <h4 class="panel-title"> \t\t <a data-toggle="collapse" data-parent="#accordion" href="#managecal{$manage_cal_row['cal_id']}" aria-expanded="false" class="collapsed" style="display:block; width:100%; text-decoration:none;">{$manage_cal_row['cal_date']} <span class="label label-default">{$manage_cal_row['comp_name']}</span></a> \t\t </h4> \t\t </div> \t\t <div id="managecal{$manage_cal_row['cal_id']}" class="panel-collapse collapse" aria-expanded="false" style="height: 0px;"> \t\t <div class="panel-body"> \t\t \t<ul class="list-group"> \t\t \t\t<div class="list-group"> \t\t \t\t\t<li class="list-group-item"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class="list-group-item-heading">掲題</h4> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<p class="list-group-item-text">{$manage_cal_row['cal_contants']}</p> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</li> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class="list-group-item"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h4 class="list-group-item-heading">詳細</h4> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<p class="list-group-item-text">{$manage_cal_row_crlf}</p> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</li> \t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t</ul> \t\t\t\t\t\t\t\t\t\t\t\t\t<button class="btn btn-primary btn-sm" data-toggle="modal" data-target="#calModal{$manage_cal_row['cal_id']}"> \t\t\t\t\t\t\t\t\t\t\t\t スケジュール編集 \t\t\t\t\t\t\t\t\t\t\t\t </button> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t<div class="modal fade" id="calModal{$manage_cal_row['cal_id']}" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> \t\t\t\t\t\t\t\t\t\t\t\t\t <div class="modal-dialog" role="document"> \t\t\t\t\t\t\t\t\t\t\t\t\t <div class="modal-content"> \t\t\t\t\t\t\t\t\t\t\t\t\t <div class="modal-header"> \t\t\t\t\t\t\t\t\t\t\t\t\t <form method="post"> \t\t\t\t\t\t\t\t\t\t\t\t \t\t<button type="submit" class="btn btn-danger btn-sm" name="caldel" value="{$manage_cal_row['cal_id']}" style="float: right;">スケジュール削除</button> \t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t</form> \t\t\t\t\t\t\t\t\t\t\t\t\t <h4 class="modal-title" id="myModalLabel">スケジュールの編集</h4> \t\t\t\t\t\t\t\t\t\t\t\t\t </div> \t\t\t\t\t\t\t\t\t\t\t\t\t <div class="modal-body"> \t\t\t\t\t\t\t\t\t\t\t\t\t <form role="form" method="POST"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="col-md-6"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<label>題名 <small class="text-danger">※文字数は20文字以内におさめてください。</small></label> EOT; $cal_result_contents_RE = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM calData WHERE cal_id = {$manage_cal_row['cal_id']}"); $cal_row_RE_contents = $cal_result_contents_RE->fetch_assoc(); echo <<<EOT \t\t\t<input class="form-control" name="cal_contents_update" type="text" placeholder="例)◯◯株式会社説明会" value="{$cal_row_RE_contents['cal_contants']}"> EOT; echo <<<EOT \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<label>詳細 <small class="text-danger">※文字数制限はありません。</small></label> EOT; $cal_result_subsontents_RE = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM calData WHERE cal_id = {$manage_cal_row['cal_id']}"); $cal_row_RE_subcontents = $cal_result_subsontents_RE->fetch_assoc(); echo <<<EOT <textarea class="form-control" name="cal_sub_contents_update" rows="10" placeholder="開催日時:10時 場所:午前10時 場所:本館501">{$cal_row_RE_subcontents['cal_sub_contents']}</textarea> \t\t\t<!--<input class="form-control" name="cal_sub_contents_update" type="text" placeholder="開催日時:10時 場所:午前10時 場所:本館501" value="{$cal_row_RE_subcontents['cal_sub_contents']}">--> EOT; echo <<<EOT \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="col-md-6"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<label>会社名 <small class="text-danger">※必須ではありません。</small></label> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<select class="form-control" name="select_compname_update"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<option value="">企業を選択してください。</option> EOT; $sqli_comp_name = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM comp_info"); $cal_result_RE = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM calData LEFT OUTER JOIN comp_info ON calData.cal_comp_id = comp_info.comp_id WHERE calData.cal_id = {$manage_cal_row['cal_id']}"); $cal_row_RE = $cal_result_RE->fetch_assoc(); while ($row_comp_name = $sqli_comp_name->fetch_assoc()) { if ($cal_row_RE['comp_name'] == $row_comp_name['comp_name']) { echo <<<EOT \t\t\t\t<option value="{$row_comp_name['comp_id']}" selected>{$row_comp_name['comp_name']}</option> EOT; } else { echo <<<EOT \t\t\t\t<option value="{$row_comp_name['comp_id']}">{$row_comp_name['comp_name']}</option> EOT; } } echo <<<EOT \t\t\t\t\t \t\t\t\t\t</select> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="form-group col-md-12"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<label>予定日時 <small class="text-danger">※3ヶ月以前のものは表示されません。(登録は可能)</small></label> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="row"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$caldate_select} \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t </div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t <div class="modal-footer"> \t\t\t\t\t\t\t\t\t\t\t\t\t\t <button type="button" class="btn btn-default" data-dismiss="modal">閉じる</button> \t\t\t\t\t\t\t\t\t\t\t\t\t\t <button type="submit" name="cal_update" value="{$manage_cal_row['cal_id']}" class="btn btn-primary">変更を保存</button> \t\t\t\t\t\t\t\t\t\t\t\t\t\t </div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</form> \t\t\t\t\t\t\t\t\t\t\t\t\t </div> \t\t\t\t\t\t\t\t\t\t\t\t\t </div> \t\t\t\t\t\t\t\t\t\t\t\t\t</div> \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t </div> \t\t </div> \t\t </div> \t\t \t\t EOT; } echo <<<EOT \t\t\t\t\t\t\t\t\t</div> </div> </div> </div> <!-- /.panel-body --> </div> \t\t\t\t</div> \t\t\t</div> EOT; }
<?php require_once 'newfunction.php'; echo '<p>google.com</p>'; $result = RUN_SQLI_DEFAULTLOGIN('SELECT * FROM test_table'); if (!$result) { echo 'no result'; } else { while ($row = $result->fetch_assoc()) { echo <<<EOT \t\t\t<p>{$row['id']}</p> \t\t\t<p>{$row['name']}</p> EOT; } }
<?php include 'managefunctions.php'; include 'manageHTMLdoc.php'; include 'manageContent.php'; include 'manageHeader.php'; if (empty($_SESSION['managename'])) { $_SESSION['ERR_LOGIN'] = $msg_row['4']['msg']; header("Location: {$rootURLmanage}managelogin.php"); } if (isset($_POST['compdel'])) { RUN_SQLI_DEFAULTLOGIN("DELETE FROM `testOpenDev1_db`.`comp_info` WHERE `comp_info`.`comp_id` = {$_POST['compdel']}"); $add_alert = $msg_row['12']['msg']; } if (isset($_POST['comp_update'])) { $comp_update = RUN_SQLI_DEFAULTLOGIN("\n\t\tUPDATE comp_info \n\t\tSET \n\t\t\tcomp_ad='',\n\t\t\tcomp_name='{$_POST['comp_name']}',\n\t\t\tcomp_name_kana='{$_POST['comp_name_kana']}',\n\t\t\tcomp_zipcode='{$_POST['comp_zipcode']}',\n\t\t\tcomp_street_address='{$_POST['comp_street_address']}',\n\t\t\tcomp_ceo_name='{$_POST['comp_ceo_name']}',\n\t\t\tcomp_adopt_name='{$_POST['comp_adopt_name']}',\n\t\t\tcomp_fundation='{$_POST['comp_foundation']}',\n\t\t\tcomp_public='{$_POST['comp_public']}',\n\t\t\tcomp_capital='{$_POST['comp_capital']}',\n\t\t\tcomp_annual_business='{$_POST['comp_annual_business']}',\n\t\t\tcomp_tel_1='{$_POST['comp_tel1']}',\n\t\t\tcomp_fax_1='{$_POST['comp_fax1']}',\n\t\t\tcomp_tel_2='{$_POST['comp_tel2']}',\n\t\t\tcomp_fax_2='{$_POST['comp_fax2']}',\n\t\t\tcomp_url='{$_POST['comp_url']}',\n\t\t\tcomp_email='{$_POST['comp_email']}',\n\t\t\tcomp_employee_male='{$_POST['comp_employee_male']}',\n\t\t\tcomp_employee_female='{$_POST['comp_employee_female']}',\n\t\t\tcomp_a_ns='{$_POST['comp_a_ns']}',\n\t\t\tcomp_b_ns='{$_POST['comp_b_ns']}',\n\t\t\tcomp_c_ns='{$_POST['comp_c_ns']}',\n\t\t\tcomp_business='{$_POST['comp_business']}',\n\t\t\tcomp_other_1='{$_POST['comp_other1']}',\n\t\t\tcomp_imageid_1='{$_POST['']}' \n\t\tWHERE comp_id='{$_POST['comp_update']}';\n\t"); if (!$comp_update) { $add_alert = $msg_row['9']['msg']; } else { $add_alert = $msg_row['1']['msg']; } } ?> <?php manage_htmlhead(); ?> <?php
<!-- Include roboto.css to use the Roboto web font, material.css to include the theme and ripples.css to style the ripple effect --> <link href="css/roboto.min.css" rel="stylesheet"> <link href="css/material.min.css" rel="stylesheet"> <link href="css/ripples.min.css" rel="stylesheet"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="css/swiper.min.css"> <style> </style> </head> <body> <?php $usercal_result = RUN_SQLI_DEFAULTLOGIN("SELECT * FROM adopt_info;"); if (!isset($_GET['cal'])) { echo <<<EOT \t\t\t\t<style> \t\t\t\t.swiper-container { \t\t\t\t\t\t width: 600px; \t\t\t\t\t\t height: 300px; \t\t\t\t\t\t} \t\t\t</style> \t\t\t\t<div class="swiper-container"> \t\t\t\t\t <!-- Additional required wrapper --> \t\t\t\t\t <div class="swiper-wrapper"> \t\t\t\t\t <!-- Slides --> \t\t\t\t\t <div class="swiper-slide">Slide 1</div> \t\t\t\t\t <div class="swiper-slide">Slide 2</div> \t\t\t\t\t <div class="swiper-slide">Slide 3</div>
include 'manageHTMLdoc.php'; include 'manageContent.php'; include 'manageHeader.php'; if (empty($_SESSION['managename'])) { $_SESSION['ERR_LOGIN'] = $msg_row['4']['msg']; header("Location: {$rootURLmanage}managelogin.php"); } if (isset($_POST['submit_addjob'])) { $compnameid = RUN_SQLI_DEFAULTLOGIN("SELECT comp_id FROM comp_info WHERE comp_name = '{$_REQUEST['select_compname']}'"); if ($compnameid->num_rows != 0) { $compnameid_result = $compnameid->fetch_assoc(); if (empty($_POST['business_form']) or empty($_POST['business_educational']) or empty($_POST['business_job_category']) or empty($_POST['business_base_salary'])) { $add_alert = $msg_row['8']['msg']; } else { die("\n\t\t\tINSERT INTO\n\t\t\t\tjob_info(\n\t\t\t\t\tcomp_id,\n\t\t\t\t\tbusiness_form,\n\t\t\t\t\teducational,\n\t\t\t\t\tjob_category,\n\t\t\t\t\tjob_discription,\n\t\t\t\t\tbase_salary,\n\t\t\t\t\tcommuting_allowance,\n\t\t\t\t\thousing_allowance,\n\t\t\t\t\tfamily_allowance,\n\t\t\t\t\tbonus,\n\t\t\t\t\tsalary_increase,\n\t\t\t\t\tother_allowance,\n\t\t\t\t\tave_overtime,\n\t\t\t\t\tholiday,\n\t\t\t\t\tpaid_leave,\n\t\t\t\t\tpaid_acquisition_rate,\n\t\t\t\t\tjoin_insurance,\n\t\t\t\t\ttrial_period,\n\t\t\t\t\tsaverance_pay,\n\t\t\t\t\tbase_union,\n\t\t\t\t\tdormitory_system,\n\t\t\t\t\tother1\n\t\t\t\t) VALUES (\n\t\t\t\t\t'{$compnameid_result['comp_id']}',\n\t\t\t\t\t'{$_POST['business_form']}',\n\t\t\t\t\t'{$_POST['business_educational']}',\n\t\t\t\t\t'{$_POST['business_job_category']}',\n\t\t\t\t\t'{$_POST['business_discription']}',\n\t\t\t\t\t'{$_POST['business_base_salary']}',\n\t\t\t\t\t'{$_POST['option_commuting_allowance']}',\n\t\t\t\t\t'{$_POST['option_housing_allowance']}',\n\t\t\t\t\t'{$_POST['option_family_allowance']}',\n\t\t\t\t\t'{$_POST['option_bonus']}',\n\t\t\t\t\t'{$_POST['option_salary_increase']}',\n\t\t\t\t\t'{$_POST['option_other_allowance']}',\n\t\t\t\t\t'{$_POST['ave_overtime']}',\n\t\t\t\t\t'{$_POST['holiday']}',\n\t\t\t\t\t'{$_POST['pail_leave']}',\n\t\t\t\t\t'{$_POST['accquisition_rate']}',\n\t\t\t\t\t'{$_POST['option_join_insurance']}',\n\t\t\t\t\t'{$_POST['trial_period']}',\n\t\t\t\t\t'{$_POST['saverance_pay']}',\n\t\t\t\t\t'{$_POST['base_union']}',\n\t\t\t\t\t'{$_POST['option_dormitory_system']}',\n\t\t\t\t\t'{$_POST['other_1']}'\n\t\t\t\t)\n\t\t\t\t"); $jobadd_result = RUN_SQLI_DEFAULTLOGIN("\n\t\t\tINSERT INTO\n\t\t\t\tjob_info(\n\t\t\t\t\tcomp_id,\n\t\t\t\t\tbusiness_form,\n\t\t\t\t\teducational,\n\t\t\t\t\tjob_category,\n\t\t\t\t\tjob_discription,\n\t\t\t\t\tbase_salary,\n\t\t\t\t\tcommuting_allowance,\n\t\t\t\t\thousing_allowance,\n\t\t\t\t\tfamily_allowance,\n\t\t\t\t\tbonus,\n\t\t\t\t\tsalary_increase,\n\t\t\t\t\tother_allowance,\n\t\t\t\t\tave_overtime,\n\t\t\t\t\tholiday,\n\t\t\t\t\tpaid_leave,\n\t\t\t\t\tpaid_acquisition_rate,\n\t\t\t\t\tjoin_insurance,\n\t\t\t\t\ttrial_period,\n\t\t\t\t\tsaverance_pay,\n\t\t\t\t\tbase_union,\n\t\t\t\t\tdormitory_system,\n\t\t\t\t\tother1\n\t\t\t\t) VALUES (\n\t\t\t\t\t'{$compnameid_result['comp_id']}',\n\t\t\t\t\t'{$_POST['business_form']}',\n\t\t\t\t\t'{$_POST['business_educational']}',\n\t\t\t\t\t'{$_POST['business_job_category']}',\n\t\t\t\t\t'{$_POST['business_discription']}',\n\t\t\t\t\t'{$_POST['business_base_salary']}',\n\t\t\t\t\t'{$_POST['option_commuting_allowance']}',\n\t\t\t\t\t'{$_POST['option_housing_allowance']}',\n\t\t\t\t\t'{$_POST['option_family_allowance']}',\n\t\t\t\t\t'{$_POST['option_bonus']}',\n\t\t\t\t\t'{$_POST['option_salary_increase']}',\n\t\t\t\t\t'{$_POST['option_other_allowance']}',\n\t\t\t\t\t'{$_POST['ave_overtime']}',\n\t\t\t\t\t'{$_POST['holiday']}',\n\t\t\t\t\t'{$_POST['pail_leave']}',\n\t\t\t\t\t'{$_POST['accquisition_rate']}',\n\t\t\t\t\t'{$_POST['option_join_insurance']}',\n\t\t\t\t\t'{$_POST['trial_period']}',\n\t\t\t\t\t'{$_POST['saverance_pay']}',\n\t\t\t\t\t'{$_POST['base_union']}',\n\t\t\t\t\t'{$_POST['option_dormitory_system']}',\n\t\t\t\t\t'{$_POST['other_1']}'\n\t\t\t\t)\n\t\t\t\t"); $add_alert = $msg_row['1']['msg']; } } else { $add_alert = $msg_row['11']['msg']; } } ?> <?php manage_htmlhead(); ?> <?php