//$spec_data = $spec_dao->get($other_id);
//$spec_name = $spec_data['spec_name'];
// set query sql
$sql = sprintf("select * from mp_promise_spec where promise_id = '%s' and spec_id = '%s' ", $promise_id, $other_id);
} else {
if (isset($_GET['doing_time']) && $_GET['doing_time'] != '') {
$doing_time = $_GET['doing_time'];
// set query sql
$sql = "select * from mp_promise_spec where promise_id = '{$promise_id}' and doing_time like '{$doing_time}%'";
} else {
// set query sql
$sql = sprintf("select * from mp_promise_spec where promise_id = '%s' ", $promise_id);
}
}
// get promise spec data
$promise_spec_forms = $promise_spec_dao->get_rows($sql);
// foreach promise spec data
//print_r($promise_spec_forms);
foreach ($promise_spec_forms as $k => $v) {
// get each promise spec profile_id
$profile_id = $v['profile_id'];
// get profile data by profile_id
$profile_forms = $spec_profile_dao->get($profile_id);
// get profile_name
$profile_name = $profile_forms['profile_name'];
// get spec_id
$spec_id = $profile_forms['spec_id'];
$service_id = $v['service_id'];
if (empty($v['doing_time'])) {
//$promise_spec_forms[$k]['day'] = "";
//$promise_spec_forms[$k]['hour'] = "";
<?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();
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);
}
}
$date = $year . '-';
$where_request_arr[] = "request_time like '{$date}%'";
} elseif (!empty($month)) {
$date = '-' . $month;
$where_request_arr[] = "request_time like '%{$date}%'";
}
}
// get request data
$request_data = $request_dao->search($where_request_arr, $page);
$request_promise_id_arr = array();
$request['mutirow'] = array();
foreach ($request_data as $k => $v) {
// $request_promise_id_arr[] = $v['promise_id'];
$request_promise_id = $v['promise_id'];
$sql = "select * from mp_promise_spec where promise_id = '{$request_promise_id}'";
$request_promise_spec_data = $promise_spec_dao->get_rows($sql);
$num = 0;
$number = 0;
foreach ($request_promise_spec_data as $kk => $vv) {
if ($vv['status'] == '3') {
$num = $num + 1;
}
}
if ($num > 0) {
$request['mutirow'][] = array("promise_id" => $request_promise_id);
} else {
$number = $number + 1;
}
}
$page['cnt'] = $page['cnt'] - $number;
}
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/prego_m.php';
require_once '../system/smtpsend.class.php';
$promise_spec_dao = new Class_mp_promise_spec();
$promise_dao = new Class_mp_promise();
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$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
}
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);
}
}
$smarty->assign('message', '登録が完了しました。通知メール送信完了しました。');
} else {
$promise_dao->rollback_trans();
$hidden_promise_id = $_GET['promise_id'];
// get request_time
$request_time = $_GET['request_time'];
// get corporate_id
$corporate_id = $_GET['corporate_id'];
$request_id = $_GET['id'];
$u_time_temp = strtotime($request_time . '-01');
$timeNowYM = date('Y-m', $u_time_temp);
$dateNowYM = date('Y年m月', $u_time_temp);
// get corporate_name by corporate_id
//$corporate_data = $corporate_dao->get ( $corporate_id );
// get corporate_name
//$corporate_name = $corporate_data ['corporate_name'];
// get corporate_data
$sql = sprintf("select * from mp_corporate where id = '%s'", $corporate_id);
$corporate_forms = $promise_spec_dao->get_rows($sql);
//select * from mp_request where corporate_id = '35'
//select * from mp_request_add where request_id = '9'
$sql = " SELECT * FROM `mp_request` where corporate_id = '{$corporate_id}' AND request_time= '{$timeNowYM}'";
$nowrequestment = $promise_spec_dao->get_row($sql);
$requestment_id = $nowrequestment["id"];
$tmp_date = date("Ym", $u_time_temp);
$tmp_year = substr($tmp_date, 0, 4);
$tmp_mon = substr($tmp_date, 4, 2);
$tmp_forwardmonth = mktime(0, 0, 0, $tmp_mon - 1, 1, $tmp_year);
$timeYM = date("Y-m", $tmp_forwardmonth);
$sql = "select a.*,b.promise_name,c.spec_fee,c.servers_fee,d.memo as cmemo from mp_promise_spec a " . " inner join mp_promise b on b.id = a.promise_id " . " inner join mp_spec_fee c on c.spec_id = a.spec_id and c.service_id = a.service_id " . " inner join mp_service d on d.id = a.service_id " . " where a.status = '3' and b.corporate_id = '{$corporate_id}' and a.doing_time like '{$timeYM}%'" . " order by a.doing_time ";
$promise_rows = $promise_spec_dao->get_rows($sql);
//print_r($promise_rows);
// get payment_add by pay_id
/*$sql = "select * from mp_request_add where request_id = '$request_id' ";
