$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', 'DBエラーで失敗しました。'); } // 更新