//$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"." "; // }