//$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) {
foreach ($spec_data as $key => $spec) {
$spec_profile_sql = "select * from mp_spec_profile where spec_id =" . $spec['id'];
$spec_profile_data[] = $spec_profile_dao->get_rows($spec_profile_sql);
}
}
$index = 0;
foreach ($spec_data as $k => $v) {
$index = $k + 1;
$content += "<tr>";
$content += "<td>" . $index . "</td>";
$content += "<td>" . $v['spec_name'] . "</td>";
$content += "<td>";
$content += "<table>";
foreach ($spec_profile_data as $kk => $vv) {
if ($v['id'] == $vv['spec_id']) {
$content += "<tbody>";
$content += "<tr>";
$content += "<td class='td_name' width='100%'><a href='javascript:;' data-url='popup_specialist_profile1.php?id=" . $vv['id'] . ">" . $vv['profile_name'] . "</a></td>";
$fax3 = substr($spec_forms['fax'], 6, 4);
if (!empty($fax1) && !empty($fax2) && !empty($fax3)) {
$fax = $fax1 . "-" . $fax2 . "-" . $fax3;
}
// get spec_traffic_fee_forms
$traffic_fee_sql = sprintf("select * from mp_spec_traffic_fee where spec_id = '%s'", mysql_real_escape_string($id));
$spec_traffic_fee_forms = $traffic_fee_dao->get_rows($traffic_fee_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']));
}
}
$smarty->assign('d_time', $d_time);
// get spec_profile_forms
$spec_profile_sql = sprintf("select * from mp_spec_profile where spec_id = '%s' ", mysql_real_escape_string($id));
$spec_profile_forms = $spec_profile_dao->get_rows($spec_profile_sql);
//print_r($spec_profile_forms);exit;
// get spec_fee_forms
$spec_fee_sql = sprintf("select * from mp_spec_fee where spec_id = '%s'", mysql_real_escape_string($id));
$spec_fee_forms = $spec_fee_dao->get_rows($spec_fee_sql);
// set id
$forms['id'] = $id;
}
if (isset($forms)) {
$smarty->assign('forms', $forms);
}
if (isset($spec_forms)) {
$smarty->assign('spec_forms', $spec_forms);
}
if (isset($spec_traffic_fee_forms)) {
$smarty->assign('spec_traffic_fee_forms', $spec_traffic_fee_forms);
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 ="";
// $spec_area_b ="";
// $spec_area_c ="";
// $spec_area_else ="";
// if($spec_forms['spec_area_a'] == 1){
// $spec_area_a ="分野A"." ";
// }
