break;
 }
 if ($executeflg) {
     $promise_spec_dao->commit_trans();
     echo '100';
     //成功
     // send Email to PREGO
     //$smtp_dao->senduserMail(PREGO_MAIL_ADDRESS,PREGO_MAIL_CORPORATE_AGREEMENT_SUBJECT,PREGO_MAIL_CORPORATE_AGREEMENT_CONTENT);
     // send Email to Specialist
     $promise_spec_mail_data = $promise_spec_dao->get($id);
     $mail_spec_id = $promise_spec_mail_data['spec_id'];
     $mail_spec_data = $specialist_dao->get($mail_spec_id);
     $mail_address1 = $mail_spec_data['mail_address1'];
     $mail_address2 = $mail_spec_data['mail_address2'];
     if (!empty($mail_address1)) {
         $smtp_dao->senduserMail($mail_address1, PREGO_MAIL_CORPORATE_AGREEMENT_SUBJECT, PREGO_MAIL_CORPORATE_AGREEMENT_SPECIALIST_CONTENT . "\n" . PREGO_LOGIN_URL);
     }
     if (!empty($mail_address2)) {
         $smtp_dao->senduserMail($mail_address2, PREGO_MAIL_CORPORATE_AGREEMENT_SUBJECT, PREGO_MAIL_CORPORATE_AGREEMENT_SPECIALIST_CONTENT . "\n" . PREGO_LOGIN_URL);
     }
     // send Email to corporate tantou
     $mail_promise_data = $promise_dao->get($promise_id);
     $mail_corporate_id = $mail_promise_data['corporate_id'];
     $sql = "select * from mp_corporate_tantou where corporate_id = '{$mail_corporate_id}' ";
     $mail_corporate_tantou_data = $corporate_tantou_dao->get_rows($sql);
     foreach ($mail_corporate_tantou_data as $k => $v) {
         if ($v['mail_address'] != '') {
             $smtp_dao->senduserMail($v['mail_address'], PREGO_MAIL_CORPORATE_AGREEMENT_SUBJECT, PREGO_MAIL_CORPORATE_AGREEMENT_CORPORATE_CONTENT_A . "\n" . $v['tantou_name'] . PREGO_MAIL_CORPORATE_AGREEMENT_CORPORATE_CONTENT_B . "\n" . PREGO_LOGIN_URL);
         }
     }
 } else {
     $operate_history_val['spec_id'] = $spec_id;
     $operate_history_val['service_id'] = $service_id;
     if ($operation_history_dao->add0($operate_history_val)) {
     } else {
         $executeflg = FALSE;
         break;
     }
 } else {
     $executeflg = FALSE;
 }
 if ($executeflg) {
     $promise_spec_dao->commit_trans();
     echo '100';
     //成功
     // send Email to PREGO
     $smtp_dao->senduserMail(PREGO_JP_MAIL, PREGO_MAIL_CANCEL_FEE_SUBJECT, PREGO_MAIL_CANCEL_FEE_CONTENT);
     // send Email to specialist
     $mail_promise_spec_data = $promise_spec_dao->get($id);
     $mail_spec_id = $mail_promise_spec_data['spec_id'];
     $mail_spec_data = $spec_dao->get($mail_spec_id);
     if ($mail_spec_data['mail_address1'] != '') {
         $smtp_dao->senduserMail($mail_spec_data['mail_address1'], PREGO_MAIL_CANCEL_FEE_SUBJECT, PREGO_MAIL_CANCEL_FEE_CONTENT . "\n" . PREGO_LOGIN_URL);
     }
     if ($mail_spec_data['mail_address2'] != '') {
         $smtp_dao->senduserMail($mail_spec_data['mail_address2'], PREGO_MAIL_CANCEL_FEE_SUBJECT, PREGO_MAIL_CANCEL_FEE_CONTENT . "\n" . PREGO_LOGIN_URL);
     }
     // send Email to corporate
     $mail_promise_data = $promise_dao->get($promise_id);
     $mail_corporate_id = $mail_promise_data['corporate_id'];
     $sql = "select * from mp_corporate_tantou where corporate_id = '{$mail_corporate_id}' ";
     $mail_corporate_tantou_data = $corporate_tantou_dao->get_rows($sql);
     $operate_history_val['service_id'] = $service_id;
     // update operation_history data
     if ($operation_history_dao->add0($operate_history_val)) {
     } else {
         $executeflg = FALSE;
         break;
     }
 } else {
     $executeflg = FALSE;
 }
 if ($executeflg) {
     $promise_spec_dao->commit_trans();
     echo '100';
     //成功
     // send Email to PREGO
     $smtp_dao->senduserMail(PREGO_JP_MAIL, PREGO_MAIL_CONFIRM_CANCEL_SUBJECT, PREGO_MAIL_CONFIRM_CANCEL_CONTENT);
     // send Email to specialist
     $mail_promise_spec_data = $promise_spec_dao->get($id);
     $mail_spec_id = $mail_promise_spec_data['spec_id'];
     $mail_spec_data = $spec_dao->get($mail_spec_id);
     if ($mail_spec_data['mail_address1'] != '') {
         $smtp_dao->senduserMail($mail_spec_data['mail_address1'], PREGO_MAIL_CONFIRM_CANCEL_SUBJECT, PREGO_MAIL_CONFIRM_CANCEL_CONTENT);
     }
     if ($mail_spec_data['mail_address2'] != '') {
         $smtp_dao->senduserMail($mail_spec_data['mail_address2'], PREGO_MAIL_CONFIRM_CANCEL_SUBJECT, PREGO_MAIL_CONFIRM_CANCEL_CONTENT);
     }
     // send Email to corporate
     $mail_promise_data = $promise_dao->get($promise_id);
     $mail_corporate_id = $mail_promise_data['corporate_id'];
     $sql = "select * from mp_corporate_tantou where corporate_id = '{$mail_corporate_id}' ";
     $mail_corporate_tantou_data = $corporate_tantou_dao->get_rows($sql);
         if ($executeflg) {
             $corporate_dao->commit_trans();
             // get login_id and login_pwd
             $account_sql = "select * from mp_account where other_id = '{$id}' ";
             $mail_account_data = $account_dao->get_rows($account_sql);
             foreach ($mail_account_data as $k => $v) {
                 $mail_id = $v['login_id'];
                 $mail_pwd = $v['login_pwd'];
             }
             $prego_mail_corporate_insert_content = PREGO_MAIL_CORPORATE_INSERT_CONTENT_A . $mail_id . PREGO_MAIL_CORPORATE_INSERT_CONTENT_B . $mail_pwd . PREGO_MAIL_CORPORATE_INSERT_CONTENT_C . "\n" . PREGO_LOGIN_URL;
             // get corporate tantou mailAddress
             $sql = "select * from mp_corporate_tantou where corporate_id = '{$id}' ";
             $tantou_mail_data = $tantou_dao->get_rows($sql);
             foreach ($tantou_mail_data as $k => $v) {
                 if ($v['mail_address'] != '') {
                     $smtp_dao->senduserMail($v['mail_address'], PREGO_MAIL_CORPORATE_INSERT_SUBJECT, $prego_mail_corporate_insert_content);
                 }
             }
             $smarty->assign('message', '登録が完了しました。通知メール送信完了しました。');
         } else {
             $corporate_dao->rollback_trans();
             $smarty->assign('message', '登録が失敗しました。');
         }
     } catch (Exception $e) {
         $corporate_dao->rollback_trans();
         $smarty->assign('message', 'DBエラーで失敗しました。');
     }
     // 更新
 } else {
     $promise_dao = new Class_mp_promise($corporate_dao->get_db());
     $request_dao = new Class_mp_request($corporate_dao->get_db());
            }
        } else {
            $executeflg = FALSE;
        }
        if ($executeflg) {
            $promise_spec_dao->commit_trans();
            echo '100';
            //成功
            // send Email to PREGO
            //$smtp_dao->senduserMail(PREGO_MAIL_ADDRESS,PREGO_MAIL_SPECIALIST_AGREEMENT_SUBJECT,PREGO_MAIL_SPECIALIST_AGREEMENT_CONTENT);
            // send Email to specialist
            $mail_promise_spec_data = $promise_spec_dao->get($id);
            $mail_spec_id = $mail_promise_spec_data['spec_id'];
            $mail_spec_data = $specialist_dao->get($mail_spec_id);
            if ($mail_spec_data['mail_address1'] != '') {
                $smtp_dao->senduserMail($mail_spec_data['mail_address1'], PREGO_MAIL_SPECIALIST_AGREEMENT_SUBJECT, PREGO_MAIL_SPECIALIST_AGREEMENT_CONTENT);
            }
            if ($mail_spec_data['mail_address2'] != '') {
                $smtp_dao->senduserMail($mail_spec_data['mail_address2'], PREGO_MAIL_SPECIALIST_AGREEMENT_SUBJECT, PREGO_MAIL_SPECIALIST_AGREEMENT_CONTENT);
            }
        } else {
            $promise_spec_dao->rollback_trans();
            echo '0';
            //失敗
        }
    } catch (Exception $e) {
        $promise_spec_dao->rollback_trans();
        echo '0';
        //失敗
    }
}
         }
     }
 } else {
     $executeflg = FALSE;
 }
 if ($executeflg) {
     $promise_spec_dao->commit_trans();
     echo '100';
     //成功;
     //$smtp_dao->senduserMail(PREGO_MAIL_ADDRESS,PREGO_MAIL_COMMUNICATION_MEMO_SUBJECT,PREGO_MAIL_COMMUNICATION_MEMO_CONTENT);
     // send Email to specialist
     $mail_promise_spec_data = $promise_spec_dao->get($id);
     $mail_spec_id = $mail_promise_spec_data['spec_id'];
     $mail_spec_data = $spec_dao->get($mail_spec_id);
     if ($mail_spec_data['mail_address1'] != '') {
         $smtp_dao->senduserMail($mail_spec_data['mail_address1'], PREGO_MAIL_COMMUNICATION_MEMO_SUBJECT, PREGO_MAIL_COMMUNICATION_MEMO_SPECIALIST_CONTENT);
     }
     if ($mail_spec_data['mail_address2'] != '') {
         $smtp_dao->senduserMail($mail_spec_data['mail_address2'], PREGO_MAIL_COMMUNICATION_MEMO_SUBJECT, PREGO_MAIL_COMMUNICATION_MEMO_SPECIALIST_CONTENT);
     }
     // send Email to corporate
     $mail_promise_data = $promise_dao->get($promise_id);
     $mail_corporate_id = $mail_promise_data['corporate_id'];
     $sql = "select * from mp_corporate_tantou where corporate_id = '{$mail_corporate_id}' ";
     $mail_corporate_tantou_data = $corporate_tantou_dao->get_rows($sql);
     foreach ($mail_corporate_tantou_data as $k => $v) {
         if ($v['mail_address'] != '') {
             $smtp_dao->senduserMail($v['mail_address'], PREGO_MAIL_COMMUNICATION_MEMO_SUBJECT, PREGO_MAIL_COMMUNICATION_MEMO_CORPORATE_CONTENT . "\n" . PREGO_LOGIN_URL);
         }
     }
 } else {
    // change to seconds
    $create_date = strtotime($v['c_time']);
    // get Difference between system date and create date
    $difference = $now_date - $create_date;
    // get corporate_id
    $promise_data = $promise_dao->get($v['promise_id']);
    $corporate_id = $promise_data['corporate_id'];
    // get corporate_tantou Email
    $sql = "select * from mp_corporate_tantou where corporate_id = '{$corporate_id}' ";
    $corporate_tantou_data = $corporate_tantou_dao->get_rows($sql);
    // 2 ~ 3 日
    if ($difference >= 172800 && $difference <= 259200) {
        // send 2日 Email
        foreach ($corporate_tantou_data as $kk => $vv) {
            if (!empty($vv['mail_address'])) {
                $smtpsend_dao->senduserMail($vv['mail_address'], TWO_OR_THREE_DAYS_WARNING_EMAIL_SUBJECT, TWO_OR_THREE_DAYS_WARNING_EMAIL_CONTENT . "\n" . PREGO_LOGIN_URL);
            }
        }
    } elseif ($difference > 259200 && $difference < 346000) {
        // send 3日 Email
        foreach ($corporate_tantou_data as $kk => $vv) {
            if (!empty($vv['mail_address'])) {
                $smtpsend_dao->senduserMail($vv['mail_address'], TWO_OR_THREE_DAYS_WARNING_EMAIL_SUBJECT, TWO_OR_THREE_DAYS_WARNING_EMAIL_CONTENT . "\n" . PREGO_LOGIN_URL);
            }
        }
    }
}
//*********************受注確定の警告メール、12時間後、23時間後********************
$sql = "select * from mp_promise_spec where status = '1' ";
$promise_spec_data = $promise_spec_dao->get_rows($sql);
foreach ($promise_spec_data as $k => $v) {
             break;
         }
     }
 } else {
     $executeflg = FALSE;
 }
 if ($executeflg) {
     $promise_dao->commit_trans();
     // send email to corporate tantou
     $mail_promise_data = $promise_dao->get($promise_id);
     $mail_promise_corporate_id = $mail_promise_data['corporate_id'];
     $sql = "select * from mp_corporate_tantou where corporate_id = '{$mail_promise_corporate_id}' ";
     $mail_corporate_tantou_data = $corporate_tantou_dao->get_rows($sql);
     foreach ($mail_corporate_tantou_data as $k => $v) {
         if ($v['mail_address'] != '') {
             $smtp_dao->senduserMail($v['mail_address'], PREGO_MAIL_PROMISE_INSERT_SUBJECT, PREGO_MAIL_PROMISE_INSERT_CONTENT . PREGO_LOGIN_URL);
         }
     }
     // send email to specialist
     $sql = "select * from mp_promise_spec where promise_id = '{$promise_id}' ";
     $mail_promise_spec_data = $promise_spec_dao->get_rows($sql);
     foreach ($mail_promise_spec_data as $k => $v) {
         $mail_spec_data = array();
         $mail_sepc_id = $v['spec_id'];
         $mail_spec_data = $spec_dao->get($mail_sepc_id);
         // send email to specialist
         if ($mail_spec_data['mail_address1'] != '') {
             $smtp_dao->senduserMail($mail_spec_data['mail_address1'], PREGO_MAIL_PROMISE_INSERT_SUBJECT, PREGO_MAIL_PROMISE_INSERT_CONTENT . PREGO_LOGIN_URL);
         }
         if ($mail_spec_data['mail_address2'] != '') {
             $smtp_dao->senduserMail($mail_spec_data['mail_address2'], PREGO_MAIL_PROMISE_INSERT_SUBJECT, PREGO_MAIL_PROMISE_INSERT_CONTENT . PREGO_LOGIN_URL);
             $executeflg = FALSE;
         }
         if ($executeflg) {
             $specialist_dao->commit_trans();
             // get specialist login_id and login_pwd
             $sql = "select * from mp_account where other_id = '{$specialist_id}' ";
             $mail_account_data = $account_dao->get_rows($sql);
             foreach ($mail_account_data as $k => $v) {
                 $mail_id = $v['login_id'];
                 $mail_pwd = $v['login_pwd'];
             }
             $prego_mail_specialist_insert_content = PREGO_MAIL_SPECIALIST_INSERT_CONTENT_A . $mail_id . PREGO_MAIL_SPECIALIST_INSERT_CONTENT_B . $mail_pwd . PREGO_MAIL_SPECIALIST_INSERT_CONTENT_C . "\n" . PREGO_LOGIN_URL;
             $AddCC = array(0 => $prego_mail);
             $spec_mail_data = $specialist_dao->get($specialist_id);
             if ($spec_mail_data['mail_address1'] != '') {
                 $smtp_dao->senduserMail($spec_mail_data['mail_address1'], PREGO_MAIL_SPECIALIST_INSERT_SUBJECT, $prego_mail_specialist_insert_content, $AddCC);
             }
             if ($spec_mail_data['mail_address2'] != '') {
                 $smtp_dao->senduserMail($spec_mail_data['mail_address2'], PREGO_MAIL_SPECIALIST_INSERT_SUBJECT, $prego_mail_specialist_insert_content);
             }
             $smarty->assign('message', '登録が完了しました。通知メール送信完了しました。');
         } else {
             $specialist_dao->rollback_trans();
             $smarty->assign('message', '登録が失敗しました。');
         }
     } catch (Exception $e) {
         $specialist_dao->rollback_trans();
         $smarty->assign('message', 'DBエラーで失敗しました。');
     }
     // 更新
 } else {