$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())); //********************発注確定の警告メール 2日後、3日後********************* $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 {