$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$spec_profile_dao = new Class_mp_spec_profile();
$spec_fee_dao = new Class_mp_spec_fee();
$account_dao = new Class_mp_account();
$spec_dao = new Class_mp_specialist();
$specialist_dao = new Class_mp_specialist();
$smtp_dao = new smtpclass();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['id']) && !empty($_GET['id'])) {
if (isset($_GET['satisfy_status']) && $_GET['satisfy_status'] != '' && isset($_GET['count_id']) && $_GET['count_id'] != '') {
$id = $_GET['count_id'];
$satisfy_status = $_GET['satisfy_status'];
$values = array();
$values['satisfy_status'] = $satisfy_status;
$promise_spec_dao->edit($id, $values);
$operate_time = date('y-m-d H:i:s', time());
$operate_details = "アンケート（回答）";
$user_name = $_SESSION['PREGO_ADMIN']['STAFF_NAME'];
$operate_man = $user_name . "(" . $prego_account_sorts[$auth] . ")";
$operate_history_val['operate_time'] = $operate_time;
$operate_history_val['operate_details'] = $operate_details;
$operate_history_val['operate_man'] = $operate_man;
$nowrow = $promise_spec_dao->get($id);
$operate_history_val['promise_spec_id'] = $id;
$operate_history_val['promise_id'] = $nowrow['promise_id'];
$operate_history_val['spec_id'] = $nowrow['spec_id'];
$operate_history_val['service_id'] = $nowrow['service_id'];
$operation_history_dao = new Class_mp_promise_operation_history();
// add data to operation_history
if ($operation_history_dao->add0($operate_history_val)) {
require_once '../../system/mdao/Class_mp_promise_operation_history.php';
session_name('PREGO_ADMIN');
session_start();
$promise_spec_dao = new Class_mp_promise_spec();
$spec_profile_dao = new Class_mp_spec_profile();
$service_dao = new Class_mp_service();
$operation_history_dao = new Class_mp_promise_operation_history();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['id']) && $_GET['id'] != '') {
if (isset($_GET['u_id']) && $_GET['u_id'] != '') {
//mp_promise_spec の id
$id = $_GET['id'];
$promise_spec_forms = $promise_spec_dao->get($id);
$arr = array();
$arr['status'] = 2;
$promise_spec_dao->edit($id, $arr);
// add operate_data
$operate_time = date('y-m-d H:i:s', time());
$promise_id = $promise_spec_forms['promise_id'];
$operate_details = "受注確定（約定確定）";
$user_name = $_SESSION['PREGO_ADMIN']['STAFF_NAME'];
$operate_man = $user_name . "(スペシャリスト)";
$operate_history_val['operate_time'] = $operate_time;
$operate_history_val['operate_details'] = $operate_details;
$operate_history_val['operate_man'] = $operate_man;
$operate_history_val['promise_id'] = $promise_id;
// add data to operation_history
$operation_history_dao->add0($operate_history_val);
// add oprerate_data end
$promise_spec_forms = $promise_spec_dao->get($id);
$id = $promise_spec_forms['profile_id'];
$executeflg = true;
// set update values
$values = array();
// get id
$id = $_GET['id'];
// get current status
$status = $_GET['status'];
// get relational promise_id
$promise_id = $_GET['promise_id'];
$promise_spec_id = $_GET['promise_spec_id'];
$spec_id = $_GET['spec_id'];
$service_id = $_GET['service_id'];
$values['status'] = '4';
try {
$promise_spec_dao->begin_trans();
if ($promise_spec_dao->edit($id, $values)) {
$operate_time = date('y-m-d H:i:s', time());
$operate_details = "キャンセル";
$user_name = $_SESSION['PREGO_ADMIN']['STAFF_NAME'];
foreach ($prego_account_sorts as $k => $v) {
if ($auth == $k) {
$operate_man = $user_name . "(" . $v . ")";
}
}
$operate_history_val['operate_time'] = $operate_time;
$operate_history_val['operate_details'] = $operate_details;
$operate_history_val['operate_man'] = $operate_man;
$operate_history_val['promise_id'] = $promise_id;
$operate_history_val['promise_spec_id'] = $id;
$operate_history_val['spec_id'] = $spec_id;
$operate_history_val['service_id'] = $service_id;
$values['service_id'] = $val_service_id;
$values['doing_time'] = $val_doing_time;
$values['before_mail'] = $val_before_mail;
$values['overtime_have'] = $val_overtime_have;
$values['overtime_fee'] = $val_overtime_fee;
$values['traffic_fee_have'] = $val_traffic_fee_have;
$values['traffic_fee'] = $val_traffic_fee;
$values['traffic_fee_detail'] = $val_traffic_fee_detail;
$values['live_fee_have'] = $val_live_fee_have;
$values['live_fee'] = $val_live_fee;
$values['live_fee_detail'] = $val_live_fee_detail;
$values['other_fee_have'] = $val_other_fee_have;
$values['other_fee'] = $val_other_fee;
$values['other_fee_name'] = $val_other_fee_name;
$values['other_fee_detail'] = $val_other_fee_detail;
if ($promise_spec_dao->edit($v['id'], $values)) {
// update payment
$payment_dao = new Class_mp_payment($promise_dao->get_db());
$promise_spec_id = $v['id'];
$sql = "select * from mp_promise where promise_spec_id = {$promise_spec_id}";
$payment_data = $payment_dao->get_rows($sql);
foreach ($payment_data as $kkk => $vvv) {
$payment_id = $vvv['id'];
}
$payment_val = array();
$payment_val['promise_spec_id'] = $promise_spec_id;
$payment_val['spec_id'] = $val_spec_id;
$payment_val['spec_name'] = $val_spec_name;
$payment_val['pay_time'] = date('y-m-d H:i:s', time());
if ($payment_dao->edit($payment_id, $payment_val)) {
} else {
