<?php

require_once '../system/smarty.inc';
require_once '../system/login.inc.php';
require_once '../system/prego_m.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_payment.php';
require_once '../system/mdao/Class_mp_payment_add.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
$account_dao = new Class_mp_account();
$spec_dao = new Class_mp_specialist();
$payment_dao = new Class_mp_payment();
$promise_spec_dao = new Class_mp_promise_spec();
$payment_add_dao = new Class_mp_payment_add();
if (isset($_GET['csv']) && $_GET['csv'] == "download" || isset($_GET['hist']) && $_GET['hist'] == "2") {
    $forms = $_SESSION['MSEARCH']['payment_search'];
} else {
    $forms = $_POST;
    $_SESSION['MSEARCH']['payment_search'] = $forms;
}
if (isset($_GET['pay_flag']) && $_GET['pay_flag'] != '') {
    $payment_id = $_GET['payment_id'];
    $content_temp_str = $_GET['content_temp'];
    $money_temp_str = $_GET['money_temp'];
    $content = explode(',', $content_temp_str);
    $money = explode(',', $money_temp_str);
    foreach ($content as $k => $v) {
        foreach ($money as $kk => $vv) {
            if ($k == $kk) {
 $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 {
         $executeflg = false;
     }
require_once '../system/login.inc.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
require_once '../system/mdao/Class_mp_promise_operation_history.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_payment.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_spec_traffic_fee.php';
require_once '../system/smtpsend.class.php';
$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) {
             $smarty->assign('message', '登録が完了しました。通知メール送信完了しました。');
         } else {
             $specialist_dao->rollback_trans();
             $smarty->assign('message', '登録が失敗しました。');
         }
     } catch (Exception $e) {
         $specialist_dao->rollback_trans();
         $smarty->assign('message', 'DBエラーで失敗しました。');
     }
     // 更新
 } else {
     $values['spec_name'] = $values['spec_name1'] . ' ' . $values['spec_name2'];
     $values['interlingua'] = $values['interlingua1'] . ' ' . $values['interlingua2'];
     $values['address'] = $prego_local[$values['pro_cd']] . $values['address1'];
     $promise_spec_dao = new Class_mp_promise_spec($specialist_dao->get_db());
     $payment_dao = new Class_mp_payment($specialist_dao->get_db());
     try {
         // begin transaction
         $specialist_dao->begin_trans();
         if ($specialist_dao->edit($forms['id'], $values)) {
             if (is_array($spec_area) && $spec_area) {
                 if ($pro_dao->getProBySpecId($forms['id'])) {
                     if (!mysql_query('delete from mp_pro where spec_id=' . $forms['id'])) {
                         mysql_query('rollback');
                         $executeflg = FALSE;
                     }
                 }
                 $sql = 'insert into mp_pro(spec_id,pro_id,pro_name) values';
                 $insertvalues = '';
                 if (is_array($spec_area)) {
                     foreach ($spec_area as $key => $v) {