$smarty->assign('account_name', $account_data['user_name']);
// get corporate_forms by id
$corporate_forms = $corporate_dao->get($id);
$post_code = split('-', $corporate_forms['post_code']);
$region = $post_code[0];
$branch = $post_code[1];
$tel = split('-', $corporate_forms['tel']);
$area_code = $tel[0];
$office_number = $tel[1];
$called_number = $tel[2];
$order = array("\r\n", "\n", "\r");
$replace = "<br/>";
$corporate_forms['memo'] = str_replace($order, $replace, $corporate_forms['memo']);
// get tantou_forms
$sql = sprintf("select * from mp_corporate_tantou where corporate_id = '%s'", mysql_real_escape_string($id));
$corporate_tantou_forms = $corporate_tantou_dao->get_rows($sql);
$forms['id'] = $id;
}
if (isset($forms)) {
$smarty->assign('forms', $forms);
}
if (isset($corporate_forms)) {
$smarty->assign('corporate_forms', $corporate_forms);
}
if (isset($corporate_tantou_forms)) {
$smarty->assign('corporate_tantou_forms', $corporate_tantou_forms);
}
$smarty->assign('region', $region);
$smarty->assign('branch', $branch);
$smarty->assign('area_code', $area_code);
$smarty->assign('office_number', $office_number);
$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);
foreach ($mail_corporate_tantou_data as $k => $v) {
if ($v['mail_address'] != '') {
$smtp_dao->senduserMail($v['mail_address'], PREGO_MAIL_CANCEL_FEE_SUBJECT, PREGO_MAIL_CANCEL_FEE_CONTENT . "\n" . PREGO_LOGIN_URL);
}
}
} else {
$promise_spec_dao->rollback_trans();
echo '0';
//失敗
}
} catch (Exception $e) {
$promise_spec_dao->rollback_trans();
echo '0';
//失敗
}
} else {
$executeflg = FALSE;
}
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', 'ＤＢエラーで失敗しました。');
}
// 更新
