// 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);
}
if (isset($spec_profile_forms)) {
foreach ($spec_profile_forms as $key => $v) {
$data = $spec_profile_dao->get($v['id']);
//$promise_spec_forms[$k]['day'] = "";
//$promise_spec_forms[$k]['hour'] = "";
//$promise_spec_forms[$k]['minute'] = "";
$promise_spec_forms[$k]['datetime'] = "";
} else {
$nowdatetime = $v["doing_time"];
$promise_spec_forms[$k]['dodate'] = substr($nowdatetime, 0, 10);
$promise_spec_forms[$k]['dotime'] = substr($nowdatetime, 11, 2) . ":" . substr($nowdatetime, 14, 2);
//$promise_spec_forms[$k]['day'] = substr($nowdatetime,0,10);
//$promise_spec_forms[$k]['hour'] = substr($nowdatetime,11,2);
//$promise_spec_forms[$k]['minute'] = substr($nowdatetime,14,2);
}
// set query condition
$sql = sprintf("select * from mp_spec_fee where spec_id = '%s' and service_id = '%s'", $spec_id, $service_id);
// get spec fee and service fee
$spec_fee_arr = $spec_fee_dao->get_rows($sql);
foreach ($spec_fee_arr as $kk => $vv) {
$forms['mutirow'][] = array("profile_id" => $profile_id, "status" => $promise_spec_forms['status'], "service_name" => $vv['servers_menu'], "profile_name" => $profile_name, "spec_fee" => $vv['spec_fee'], "servers_fee" => $vv['servers_fee']);
}
// $promise_spec_status ['mutirow'] [] = array (
// "profile_id" => $profile_id,
// "status" => $v ['status']
// );
}
}
}
if (isset($forms['mutirow'])) {
$smarty->assign('fee', $forms['mutirow']);
}
// if (isset ( $promise_spec_status ['mutirow'] ))
// $smarty->assign ( 'status', $promise_spec_status ['mutirow'] );
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 ="";
// $spec_area_b ="";
// $spec_area_c ="";
// $spec_area_else ="";
// if($spec_forms['spec_area_a'] == 1){
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']);
$spec_profile_forms['famous'] = str_replace($order, $replace, $spec_profile_forms['famous']);
if (isset($spec_profile_forms)) {
$smarty->assign('spec_profile_forms', $spec_profile_forms);
}
if (isset($speclist_forms)) {
$smarty->assign('speclist_forms', $speclist_forms);
}
if ($taddflag) {
$values = array();
$values['spec_id'] = $spec_id;
$values['traffic_name'] = $v['traffic_name'];
$values['traffic_fee'] = $v['traffic_fee'];
$values['traffic_memo'] = $v['traffic_memo'];
$values['d_time'] = $v['d_time'];
if ($traffic_fee_dao->add0($values)) {
} else {
$executeflg = FALSE;
}
}
}
}
$spec_fee_sql = sprintf("select * from mp_spec_fee where spec_id = '%s'", $forms['id']);
$spec_fee_dbarray = $spec_fee_dao->get_rows($spec_fee_sql);
foreach ($spec_fee_dbarray as $k => $v) {
// set del flag
$delflag = true;
$servers_menu_val = "";
$service_id_val = "";
$spec_fee_val = "";
$servers_fee_val = "";
foreach ($forms['mutirow_fee'] as $kk => $vv) {
if ($v['id'] == $vv['id']) {
$delflag = false;
$servers_menu_val = $vv['servers_menu'];
$service_id_val = $vv['service_id'];
$spec_fee_val = $vv['spec_fee'];
$servers_fee_val = $vv['servers_fee'];
}
