$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']);
$spec_profile_forms[$key]['have_profile_url'] = $data['have_profile_url'];
}
$smarty->assign('spec_profile_forms', $spec_profile_forms);
}
if (isset($spec_fee_forms)) {
$smarty->assign('spec_fee_forms', $spec_fee_forms);
}
if (isset($proname)) {
$smarty->assign('proname', $proname);
}
$have_profile_url = $_SERVER["HTTP_REFERER"];
$have_no_profile_url = $_SERVER["HTTP_REFERER"];
$strArr = explode('specialist', $have_profile_url);
$smarty->assign('have_profile_url', $strArr[0] . "popup/specialist_profile1.php?ID=");
$smarty->assign('have_no_profile_url', $strArr[0] . "popup/specialist_profile2.php?ID=");
<?php
require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/prego_m.php';
require_once '../system/Class_ERROR.php';
require_once '../system/login.inc.php';
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']);
// set query sql
$sql = "select * from mp_promise_spec where promise_id = '{$promise_id}' and doing_time like '{$doing_time}%'";
} else {
// set query sql
$sql = sprintf("select * from mp_promise_spec where promise_id = '%s' ", $promise_id);
}
}
// get promise spec data
$promise_spec_forms = $promise_spec_dao->get_rows($sql);
// foreach promise spec data
//print_r($promise_spec_forms);
foreach ($promise_spec_forms as $k => $v) {
// get each promise spec profile_id
$profile_id = $v['profile_id'];
// get profile data by profile_id
$profile_forms = $spec_profile_dao->get($profile_id);
// get profile_name
$profile_name = $profile_forms['profile_name'];
// get spec_id
$spec_id = $profile_forms['spec_id'];
$service_id = $v['service_id'];
if (empty($v['doing_time'])) {
//$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);
$spec_dao = new Class_mp_specialist();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
$phase = 'input';
if (isset($_GET['id']) && !empty($_GET['id'])) {
$promise_spec_dao = new Class_mp_promise_spec();
$profile_dao = new Class_mp_spec_profile();
$promise_forms = $promise_dao->get($_GET['id']);
$promise_id = $_GET['id'];
$sql = "select * from mp_promise_spec where promise_id = '{$promise_id}'";
$promise_spec_forms = $promise_spec_dao->get_rows($sql);
//print_r();
// get profile_name arr
$profile_name_arr = array();
foreach ($promise_spec_forms as $k => $v) {
$profile_id = $v['profile_id'];
$profile_data = $profile_dao->get($profile_id);
$promise_spec_forms[$k]['profile_name'] = $profile_data['profile_name'];
if (empty($v['doing_time'])) {
$promise_spec_forms[$k]['day'] = "";
$promise_spec_forms[$k]['hour'] = "";
$promise_spec_forms[$k]['minute'] = "";
} else {
$nowdatetime = $v["doing_time"];
$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);
}
//$profile_name_arr [] = $profile_data ['profile_name'];
}
//print_r($promise_spec_forms);
$forms['id'] = $_GET['id'];
