// 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']; }