$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'];