$val = array();
$val['overtime_have'] = $_GET['overtime_have'];
$val['overtime_fee'] = $_GET['overtime_fee'];
$val['traffic_fee_have'] = $_GET['traffic_fee_have'];
$val['traffic_fee'] = $_GET['traffic_fee'];
$val['traffic_fee_detail'] = $_GET['traffic_fee_detail'];
$val['live_fee_have'] = $_GET['live_fee_have'];
$val['live_fee'] = $_GET['live_fee'];
$val['live_fee_detail'] = $_GET['live_fee_detail'];
$val['other_fee_have'] = $_GET['other_fee_have'];
$val['other_fee'] = $_GET['other_fee'];
$val['other_fee_name'] = $_GET['other_fee_name'];
$val['other_fee_detail'] = $_GET['other_fee_detail'];
$promise_spec_dao->edit($_GET['pro_spec_id'], $val);
}
$promise_forms = $promise_dao->get($_GET['id']);
$promise_id = $_GET['id'];
// if (isset ( $_GET ['promise_status'] ) && ! empty ( $_GET
// ['promise_status'] )) {
// $promise_status = $_GET ['promise_status'];
// } else {
// $promise_status = $promise_forms ['promise_status'];
// }
// specialist auth
if ($auth == '3') {
// get current auth account_id from session
$id = $_SESSION['PREGO_ADMIN']['STAFF_SEQ'];
$account_data = $account_dao->get($id);
$other_id = $account_data['other_id'];
// get spec_name from mp_spec by $other_id
//$spec_data = $spec_dao->get($other_id);
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);
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();
<?php
$smp_floder_flag = true;
require_once '../../system/smarty.inc';
require_once '../../system/mdao/Class_mp_promise.php';
require_once '../../system/mdao/Class_mp_promise_spec.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
//echo("</br></br></br></br></br></br></br></br>");
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['id']) && $_GET['id'] != '' && isset($_GET['status']) && $_GET['status'] != '' && isset($_GET['spec_id']) && $_GET['spec_id'] != '') {
//基本情報
$id = $_GET['id'];
$status = $_GET['status'];
$promise_forms = $promise_dao->get($id);
$spec_id = $_GET['spec_id'];
//echo("spec_id = ".$spec_id);
if ($status == '1' || $status == '2') {
//サービス情報一覧
$sql_promise_spec = "select * from mp_promise_spec where " . " status <> '3' " . " and spec_id = '{$spec_id}' ";
$promise_spec_forms = $promise_spec_dao->get_rows($sql_promise_spec);
} else {
if ($status == '3') {
//サービス情報一覧
$sql_promise_spec = "select * from mp_promise_spec where promise_id = '{$id}' and status = '3' and spec_id = '{$spec_id}' ";
$promise_spec_forms = $promise_spec_dao->get_rows($sql_promise_spec);
}
}
$promise_s_1 = '発注確定';
$promise_s_2 = '約定確定';
$promise_s_3 = '業務完了';
require_once '../../system/mdao/Class_mp_promise.php';
require_once '../../system/mdao/Class_mp_promise_spec.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['id']) && $_GET['id'] != '') {
//スペシャリストID = 9
//未完了復数案件検索
$id = $_GET['id'];
$other_id = $_GET['id'];
$sql_promise_spec_on = sprintf("select distinct promise_id from mp_promise_spec where spec_id = '%s' and status<> '3' ", $id);
$promise_spec_on_forms = $promise_spec_dao->get_rows($sql_promise_spec_on);
$promise_on_forms = array();
foreach ($promise_spec_on_forms as $k => $v) {
$id = $v['promise_id'];
$promise_on_forms[] = $promise_dao->get($id);
}
//完了復数案件検索
$id = $_GET['id'];
$sql_promise_spec_off = sprintf("select distinct promise_id from mp_promise_spec where spec_id = '%s' and status = '3' ", $id);
$promise_spec_off_forms = $promise_spec_dao->get_rows($sql_promise_spec_off);
$promise_off_forms = array();
foreach ($promise_spec_off_forms as $k => $vv) {
$id = $vv['promise_id'];
$promise_off_forms[] = $promise_dao->get($id);
}
}
}
if (isset($promise_on_forms)) {
$smarty->assign('promise_on_forms', $promise_on_forms);
}
$specialist_dao = new Class_mp_specialist();
$smtpsend_dao = new smtpclass();
// get system date
// change to seconds
$now_date = strtotime(date('Y-m-d H:i:s', time()));
//********************発注確定の警告メール ２日後、３日後*********************
$sql = "select * from mp_promise_spec where status = '0' ";
$promise_spec_data = $promise_spec_dao->get_rows($sql);
foreach ($promise_spec_data as $k => $v) {
// create date
// 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) {
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/smtpsend.class.php';
session_name('PREGO_ADMIN');
//session_cache_limiter(private_no_expire);
session_start();
$promise_dao = new Class_mp_promise();
$smtp_dao = new smtpclass();
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$spec_dao = new Class_mp_specialist();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
$phase = 'input';
if (isset($_GET['id']) && !empty($_GET['id'])) {
$promise_spec_dao = new Class_mp_promise_spec();
$profile_dao = new Class_mp_spec_profile();
$promise_forms = $promise_dao->get($_GET['id']);
$promise_id = $_GET['id'];
$sql = "select * from mp_promise_spec where promise_id = '{$promise_id}'";
$promise_spec_forms = $promise_spec_dao->get_rows($sql);
//print_r();
// get profile_name arr
$profile_name_arr = array();
foreach ($promise_spec_forms as $k => $v) {
$profile_id = $v['profile_id'];
$profile_data = $profile_dao->get($profile_id);
$promise_spec_forms[$k]['profile_name'] = $profile_data['profile_name'];
if (empty($v['doing_time'])) {
$promise_spec_forms[$k]['day'] = "";
$promise_spec_forms[$k]['hour'] = "";
$promise_spec_forms[$k]['minute'] = "";
} else {
