$promise_dao = new Class_mp_promise(); $promise_spec_dao = new Class_mp_promise_spec(); $operation_history_dao = new Class_mp_promise_operation_history($promise_spec_dao->get_db()); $spec_dao = new Class_mp_specialist(); $payment_dao = new Class_mp_payment(); $account_dao = new Class_mp_account(); $corporate_tantou_dao = new Class_mp_corporate_tantou(); $spec_traffic_dao = new Class_mp_spec_traffic_fee(); $smtp_dao = new smtpclass(); if (isset($_GET['id']) && !empty($_GET['id'])) { if (isset($_GET['spec_id']) && $_GET['spec_id'] != '') { // get spec_id $tra_spec_id = $_GET['spec_id']; // get spec_traffic data $sql = "select * from mp_spec_traffic_fee where spec_id = '{$tra_spec_id}'"; $spec_traffic_data = $spec_traffic_dao->get_rows($sql); $traffic_name = array(); $traffic_fee = array(); $traffic_memo = array(); foreach ($spec_traffic_data as $k => $v) { $traffic_name_arr[] = $v['traffic_name']; $traffic_fee[] = $v['traffic_fee']; $traffic_memo[] = $v['traffic_memo']; } $select = array('' => "選択してください"); $traffic_name = array_merge($select, $traffic_name_arr); } $executeflg = true; $values = array(); $status = $_GET['status']; $promise_id = $_GET['promise_id'];
$cell1 = substr($spec_forms['phone'], 0, 2); $cell2 = substr($spec_forms['phone'], 2, 4); $cell3 = substr($spec_forms['phone'], 6, 4); if (!empty($cell1) && !empty($cell2) && !empty($cell3)) { $phone = $cell1 . "-" . $cell2 . "-" . $cell3; } // deal with fax $fax1 = substr($spec_forms['fax'], 0, 2); $fax2 = substr($spec_forms['fax'], 2, 4); $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;
$pay_spec_name = $spec_data['spec_name']; $pay_values = array(); $pay_values['spec_name'] = $pay_spec_name; $where = "spec_id = '{$pay_spec_id}' "; if ($payment_dao->editbywhere($where, $pay_values)) { } else { $executeflg = FALSE; break; } } else { $executeflg = FALSE; break; } if ($executeflg) { $sql = sprintf("select * from mp_spec_traffic_fee where spec_id = '%s'", $forms['id']); $dbarray = $traffic_fee_dao->get_rows($sql); foreach ($dbarray as $k => $v) { // set del flag $delflag = true; $traffic_name_val = ""; $traffic_fee_val = ""; $traffic_memo_val = ""; foreach ($forms['mutirow'] as $kk => $vv) { if ($v['id'] == $vv['id']) { $delflag = false; $traffic_name_val = $vv['traffic_name']; $traffic_fee_val = $vv['traffic_fee']; $traffic_memo_val = $vv['traffic_memo']; $d_time_val = $vv['d_time']; } }