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 {