$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 ="";
// $spec_area_b ="";
// $spec_area_c ="";
// $spec_area_else ="";
// if($spec_forms['spec_area_a'] == 1){
// $spec_area_a ="分野A"." ";
// }
// if($spec_forms['spec_area_b'] == 1){
// $spec_area_b ="分野B"." ";
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']);
// get spec_forms by id
$spec_forms = $specialist_dao->get($id);
$prolist = $pro_dao->getProBySpecId($id);
if (is_array($prolist)) {
foreach ($prolist as $pro) {
$pro_name[] = $pro['pro_name'];
}
$proname = implode(',', $pro_name);
}
// deal with $post_code
$region = substr($spec_forms['post_code'], 0, 3);
$branch = substr($spec_forms['post_code'], 3, 4);
if (!empty($region) && !empty($branch)) {
$post_code = $region . "-" . $branch;
}
// deal with $area_code
$area_code = substr($spec_forms['tel'], 0, 2);
$office_number = substr($spec_forms['tel'], 2, 4);
$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']));
$spec_traffic_fee_forms = $traffic_fee_dao->get_rows($tra_sql);
if (is_array($spec_traffic_fee_forms)) {
foreach ($spec_traffic_fee_forms as $dtime) {
$d_time[] = date('Y-m-d', strtotime($dtime['d_time']));
