Example #1
0
        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 
Example #2
0
    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
Example #3
0
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;
}
Example #4
0
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();
?>
Example #7
0
        $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']);
}
?>

Example #8
0
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;
}
Example #9
0
<?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 
Example #11
0
        <!-- 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>
Example #12
0
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