<?php

require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/prego_m.php';
require_once '../system/login.inc.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_spec_traffic_fee.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
require_once '../system/mdao/Class_mp_spec_fee.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_pro.php';
$specialist_dao = new Class_mp_specialist();
$traffic_fee_dao = new Class_mp_spec_traffic_fee();
$spec_profile_dao = new Class_mp_spec_profile();
$spec_fee_dao = new Class_mp_spec_fee();
$account_dao = new Class_mp_account();
$pro_dao = new Class_mp_pro();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    $phase = 'input';
    if ($auth == '3') {
        $account_id = $_SESSION['PREGO_ADMIN']['STAFF_SEQ'];
        $account_data = $account_dao->get($account_id);
        $id = $account_data['other_id'];
    } elseif ($auth == '1') {
        if (isset($_GET['id']) && $_GET['id'] != '') {
            $id = $_GET['id'];
            $account_data = $account_dao->getByOtherid($id, 3);
        }
    }
    $smarty->assign('account_name', $account_data['user_name']);
<?php

require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/prego_m.php';
require_once '../system/Class_ERROR.php';
require_once '../system/login.inc.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_spec_fee.php';
$spec_profile_dao = new Class_mp_spec_profile();
$speclist_dao = new Class_mp_specialist();
$spec_fee_dao = new Class_mp_spec_fee();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['id']) && $_GET['id'] != '') {
        $spec_profile_forms = $spec_profile_dao->get($_GET['id']);
        $spec_id = $spec_profile_forms['spec_id'];
        $speclist_forms = $speclist_dao->get($spec_id);
        $image1 = $spec_profile_forms['image1'];
        $image2 = $spec_profile_forms['image2'];
        $image3 = $spec_profile_forms['image3'];
        $sql = "select * from mp_spec_fee where spec_id = '{$spec_id}' ";
        $spec_fee_data = $spec_fee_dao->get_rows($sql);
    }
}
$order = array("\n");
$replace = "<br/>";
$spec_profile_forms['summary'] = str_replace($order, $replace, $spec_profile_forms['summary']);
$spec_profile_forms['experience'] = str_replace($order, $replace, $spec_profile_forms['experience']);
$spec_profile_forms['qualifications'] = str_replace($order, $replace, $spec_profile_forms['qualifications']);
$spec_profile_forms['actual_result'] = str_replace($order, $replace, $spec_profile_forms['actual_result']);
require_once '../system/smarty.inc';
require_once '../system/prego_m.php';
require_once '../system/login.inc.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
require_once '../system/mdao/Class_mp_spec_fee.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/smtpsend.class.php';
require_once '../system/mdao/Class_mp_promise_operation_history.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$spec_profile_dao = new Class_mp_spec_profile();
$spec_fee_dao = new Class_mp_spec_fee();
$account_dao = new Class_mp_account();
$spec_dao = new Class_mp_specialist();
$specialist_dao = new Class_mp_specialist();
$smtp_dao = new smtpclass();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['id']) && !empty($_GET['id'])) {
        if (isset($_GET['satisfy_status']) && $_GET['satisfy_status'] != '' && isset($_GET['count_id']) && $_GET['count_id'] != '') {
            $id = $_GET['count_id'];
            $satisfy_status = $_GET['satisfy_status'];
            $values = array();
            $values['satisfy_status'] = $satisfy_status;
            $promise_spec_dao->edit($id, $values);
            $operate_time = date('y-m-d H:i:s', time());
            $operate_details = "アンケート(回答)";
<?php

error_reporting('off');
require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/Class_PWD.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
require_once '../system/mdao/Class_mp_spec_fee.php';
require_once '../system/prego_m.php';
require_once '../system/Class_ERROR.php';
require_once '../system/login.inc.php';
$spec_profile_dao = new Class_mp_spec_profile();
$spec_fee_dao = new Class_mp_spec_fee();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    $phase = 'input';
    $fee_message_arr = array();
    if (isset($_GET['spec_id']) && $_GET['spec_id'] != '') {
        $spec_id = $_GET['spec_id'];
        $smarty->assign('spec_id', $spec_id);
    } else {
        if (isset($_GET['id']) && $_GET['id'] != '') {
            $forms = $spec_profile_dao->get($_GET['id']);
            $forms['id'] = $_GET['id'];
            $spec_id = $forms['spec_id'];
            $image = $forms['image'];
            $smarty->assign('spec_id', $forms['spec_id']);
            $smarty->assign('profile_id', $_GET['id']);
            $smarty->assign('image', $image);
        }
    }
    // get spec_fee_arr by spec_id
<?php

require_once '../system/smarty.inc';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
$spec_dao = new Class_mp_specialist();
$spec_profile_dao = new Class_mp_spec_profile();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['v']) && $_GET['v'] != '') {
        $value = $_GET['v'];
        if (strlen($value) > 0) {
            $spec_sql = "select * from mp_spec where spec_name like '%{$value}%' ";
        } else {
            $spec_sql = "select * from mp_spec";
        }
    } else {
        $spec_sql = "select * from mp_spec";
    }
    //$spec_profile_sql = "select * from mp_spec_profile";
    $hint = "<thead>";
    $hint += "<tr>";
    $hint += "<th>ID</th>";
    $hint += "<th>スペシャリスト名</th>";
    $hint += "<th>セット</th>";
    $hint += "</tr>";
    $hint += "</thead><tbody>";
    $content = "";
    $end = "</tbody>";
    $spec_profile_data = array();
    $spec_data = $spec_dao->get_rows($spec_sql);
    if ($spec_data) {
<?php

$smp_floder_flag = true;
require_once '../../system/smarty.inc';
require_once '../../system/mdao/Class_mp_specialist.php';
require_once '../../system/mdao/Class_mp_spec_fee.php';
require_once '../../system/mdao/Class_mp_spec_profile.php';
require_once '../../system/mdao/Class_mp_pro.php';
$spec_dao = new Class_mp_specialist();
$spec_fee_dao = new Class_mp_spec_fee();
$spec_profile_dao = new Class_mp_spec_profile();
$pro_dao = new Class_mp_pro();
//DBからデータを取ります
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['id']) && $_GET['id'] != '') {
        $spec_forms = $spec_dao->get($_GET['id']);
        $id = $_GET['id'];
        //mp_spec_feeを検索するmp_spec_fee.spec_id = $id
        $sql_fee = sprintf("select * from mp_spec_fee where spec_id = '%s' ", $id);
        $fee_forms = $spec_fee_dao->get_rows($sql_fee);
        $sql_profile = sprintf("select * from mp_spec_profile where spec_id = '%s' ", $id);
        $profile_forms = $spec_profile_dao->get_rows($sql_profile);
        //分野の編集
        $prolist = $pro_dao->getProBySpecId($_GET['id']);
        if (is_array($prolist)) {
            foreach ($prolist as $pro) {
                $pro_names[] = $pro['pro_name'];
            }
        }
        $spec_area = implode(',', $pro_names);
        //		$spec_area_a ="";
require_once '../system/mdao/Class_mp_promise_operation_history.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/smtpsend.class.php';
session_name('PREGO_ADMIN');
//session_cache_limiter(private_no_expire);
session_start();
$promise_dao = new Class_mp_promise();
$smtp_dao = new smtpclass();
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$spec_dao = new Class_mp_specialist();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    $phase = 'input';
    if (isset($_GET['id']) && !empty($_GET['id'])) {
        $promise_spec_dao = new Class_mp_promise_spec();
        $profile_dao = new Class_mp_spec_profile();
        $promise_forms = $promise_dao->get($_GET['id']);
        $promise_id = $_GET['id'];
        $sql = "select * from mp_promise_spec where promise_id = '{$promise_id}'";
        $promise_spec_forms = $promise_spec_dao->get_rows($sql);
        //print_r();
        // get profile_name arr
        $profile_name_arr = array();
        foreach ($promise_spec_forms as $k => $v) {
            $profile_id = $v['profile_id'];
            $profile_data = $profile_dao->get($profile_id);
            $promise_spec_forms[$k]['profile_name'] = $profile_data['profile_name'];
            if (empty($v['doing_time'])) {
                $promise_spec_forms[$k]['day'] = "";
                $promise_spec_forms[$k]['hour'] = "";
                $promise_spec_forms[$k]['minute'] = "";
require_once '../system/login.inc.php';
require_once '../system/smtpsend.class.php';
$specialist_dao = new Class_mp_specialist();
$smtp_dao = new smtpclass();
$pro_dao = new Class_mp_pro();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    $phase = 'input';
    // from specialist_unregistered.html
    if (isset($_GET['account_id']) && !empty($_GET['account_id'])) {
        $account_id = $_GET['account_id'];
        $smarty->assign('account_id', $account_id);
        // from specialist_refer.html
    } else {
        $traffic_fee_dao = new Class_mp_spec_traffic_fee();
        $spec_fee_dao = new Class_mp_spec_fee();
        $spec_profile_dao = new Class_mp_spec_profile();
        if (isset($_GET['id']) && $_GET['id'] != '') {
            // get spec_forms
            $spec_forms = $specialist_dao->get($_GET['id']);
            $prolist = $pro_dao->getProBySpecId($_GET['id']);
            if (is_array($prolist)) {
                foreach ($prolist as $pro) {
                    if ($pro['pro_id'] == 99) {
                        $spec_area_else = $pro['pro_name'];
                    } else {
                        $spec_areas[] = $pro['pro_id'];
                    }
                }
            }
            // get spec_traffic_fee_forms by spec_id
            $tra_sql = sprintf("select * from mp_spec_traffic_fee where spec_id = '%s'", mysql_real_escape_string($_GET['id']));