//$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())); //********************発注確定の警告メール 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
} 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' ";