$pro_dao = new Class_mp_pro();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
$phase = 'input';
if ($auth == '3') {
$account_id = $_SESSION['PREGO_ADMIN']['STAFF_SEQ'];
$account_data = $account_dao->get($account_id);
$id = $account_data['other_id'];
} elseif ($auth == '1') {
if (isset($_GET['id']) && $_GET['id'] != '') {
$id = $_GET['id'];
$account_data = $account_dao->getByOtherid($id, 3);
}
}
$smarty->assign('account_name', $account_data['user_name']);
// get spec_forms by id
$spec_forms = $specialist_dao->get($id);
$prolist = $pro_dao->getProBySpecId($id);
if (is_array($prolist)) {
foreach ($prolist as $pro) {
$pro_name[] = $pro['pro_name'];
}
$proname = implode(',', $pro_name);
}
// deal with $post_code
$region = substr($spec_forms['post_code'], 0, 3);
$branch = substr($spec_forms['post_code'], 3, 4);
if (!empty($region) && !empty($branch)) {
$post_code = $region . "-" . $branch;
}
// deal with $area_code
$area_code = substr($spec_forms['tel'], 0, 2);
require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/prego_m.php';
require_once '../system/Class_ERROR.php';
require_once '../system/login.inc.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_spec_fee.php';
$spec_profile_dao = new Class_mp_spec_profile();
$speclist_dao = new Class_mp_specialist();
$spec_fee_dao = new Class_mp_spec_fee();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['id']) && $_GET['id'] != '') {
$spec_profile_forms = $spec_profile_dao->get($_GET['id']);
$spec_id = $spec_profile_forms['spec_id'];
$speclist_forms = $speclist_dao->get($spec_id);
$image1 = $spec_profile_forms['image1'];
$image2 = $spec_profile_forms['image2'];
$image3 = $spec_profile_forms['image3'];
$sql = "select * from mp_spec_fee where spec_id = '{$spec_id}' ";
$spec_fee_data = $spec_fee_dao->get_rows($sql);
}
}
$order = array("\n");
$replace = "<br/>";
$spec_profile_forms['summary'] = str_replace($order, $replace, $spec_profile_forms['summary']);
$spec_profile_forms['experience'] = str_replace($order, $replace, $spec_profile_forms['experience']);
$spec_profile_forms['qualifications'] = str_replace($order, $replace, $spec_profile_forms['qualifications']);
$spec_profile_forms['actual_result'] = str_replace($order, $replace, $spec_profile_forms['actual_result']);
$spec_profile_forms['famous'] = str_replace($order, $replace, $spec_profile_forms['famous']);
if (isset($spec_profile_forms)) {
$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);
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 {
$executeflg = FALSE;
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'] != '') {
<?php
$smp_floder_flag = true;
require_once '../../system/smarty.inc';
require_once '../../system/mdao/Class_mp_specialist.php';
require_once '../../system/mdao/Class_mp_spec_fee.php';
require_once '../../system/mdao/Class_mp_spec_profile.php';
require_once '../../system/mdao/Class_mp_pro.php';
$spec_dao = new Class_mp_specialist();
$spec_fee_dao = new Class_mp_spec_fee();
$spec_profile_dao = new Class_mp_spec_profile();
$pro_dao = new Class_mp_pro();
//DBからデータを取ります
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['id']) && $_GET['id'] != '') {
$spec_forms = $spec_dao->get($_GET['id']);
$id = $_GET['id'];
//mp_spec_feeを検索するmp_spec_fee.spec_id = $id
$sql_fee = sprintf("select * from mp_spec_fee where spec_id = '%s' ", $id);
$fee_forms = $spec_fee_dao->get_rows($sql_fee);
$sql_profile = sprintf("select * from mp_spec_profile where spec_id = '%s' ", $id);
$profile_forms = $spec_profile_dao->get_rows($sql_profile);
//分野の編集
$prolist = $pro_dao->getProBySpecId($_GET['id']);
if (is_array($prolist)) {
foreach ($prolist as $pro) {
$pro_names[] = $pro['pro_name'];
}
}
$spec_area = implode(',', $pro_names);
// $spec_area_a ="";
//$promise_dao = new Class_mp_promise;
//$spec_profile_dao = new Class_mp_spec_profile;
$payment_dao = new Class_mp_payment();
$payment_add_dao = new Class_mp_payment_add();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['spec_id']) && !empty($_GET['spec_id'])) {
$hidden_pay_time = $_GET['pay_time'];
$hidden_spec_id = $_GET['spec_id'];
$hidden_pay_status = $_GET['pay_status'];
$hidden_promise_spec_id = $_GET['id'];
// get pay_time
$pay_time = $_GET['pay_time'];
// get spec_id
$spec_id = $_GET['spec_id'];
// get spec_data by spec_id
$spec_data = $spec_dao->get($spec_id);
// set promise_spec sql
$spec_name = $spec_data['spec_name'];
//--------------------------------------------------------------------------------------------
// set u_time
$u_time_temp = strtotime($pay_time . '-01');
$timeNowYM = date('Y-m', $u_time_temp);
$dateNowYM = date('Y年m月', $u_time_temp);
$sql = " SELECT * FROM `mp_payment` where spec_id = '{$spec_id}' AND pay_time= '{$timeNowYM}'";
$nowpayment = $promise_spec_dao->get_row($sql);
$payment_id = $nowpayment["id"];
$tmp_date = date("Ym", $u_time_temp);
$tmp_year = substr($tmp_date, 0, 4);
$tmp_mon = substr($tmp_date, 4, 2);
//$tmp_nextmonth=mktime(0,0,0,$tmp_mon+1,1,$tmp_year);
$tmp_forwardmonth = mktime(0, 0, 0, $tmp_mon - 1, 1, $tmp_year);
$operate_history_val['service_id'] = $operation_service_id;
if ($operation_history_dao->add0($operate_history_val)) {
} else {
//$executeflg = FALSE;
//break;
}
if ($auth == '3') {
// add payment data
$login_id = $_SESSION['PREGO_ADMIN']['STAFF_ID'];
$sql = "select * from mp_account where login_id = '{$login_id}' ";
$account_data = $account_dao->get_rows($sql);
foreach ($account_data as $k => $v) {
$other_id = $v['other_id'];
}
// get spec_id and spec_name from mp_specialist by other_id
$spec_data = $spec_dao->get($other_id);
// set pay values
$spec_id = $spec_data['id'];
$spec_name = $spec_data['spec_name'];
} elseif ($auth == '1') {
$spec_id = $_GET['spec_id'];
$spec_data = $spec_dao->get($spec_id);
$spec_name = $spec_data['spec_name'];
}
//$pay_time = date ( 'Y-m', time () + 3600 * 24 * 30 );
$pay_time = date('Y-m', strtotime("1 month", $shortime));
$pay_values['promise_spec_id'] = $id;
$pay_values['spec_id'] = $spec_id;
$pay_values['spec_name'] = $spec_name;
$pay_values['pay_time'] = $pay_time;
$pay_values['pay_status'] = '0';
<?php
$smp_floder_flag = true;
require_once '../../system/smarty.inc';
require_once '../../system/mdao/Class_mp_spec_profile.php';
require_once '../../system/mdao/Class_mp_specialist.php';
$spec_profile_dao = new Class_mp_spec_profile();
$spec_dao = new Class_mp_specialist();
//DBからデータを取ります
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
if (isset($_GET['id']) && $_GET['id'] != '') {
$profile_forms = $spec_profile_dao->get($_GET['id']);
$id = $profile_forms['spec_id'];
$spec_forms = $spec_dao->get($id);
$image = $profile_forms['image'];
$bodytag = str_replace("./", "", $image);
$new_image = $bodytag;
$famous = str_replace("\n", "</br>", $profile_forms['famous']);
$address = str_replace("\n", "</br>", $profile_forms['address']);
$spec_name = str_replace("\n", "</br>", $spec_forms['spec_name']);
$interlingua = str_replace("\n", "</br>", $spec_forms['interlingua']);
$title = str_replace("\n", "</br>", $profile_forms['title']);
$summary = str_replace("\n", "</br>", $profile_forms['summary']);
$experience = str_replace("\n", "</br>", $profile_forms['experience']);
$qualifications = str_replace("\n", "</br>", $profile_forms['qualifications']);
$actual_result = str_replace("\n", "</br>", $profile_forms['actual_result']);
}
}
if (isset($profile_forms)) {
$smarty->assign('profile_forms', $profile_forms);
}
// 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);
}
}
}
}
//*********************受注確定の警告メール、１２時間後、２３時間後********************
$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) {
$u_date = strtotime($v['u_time']);
$difference = $now_date - $u_date;
$spec_id = $v['spec_id'];
$spec_data = $specialist_dao->get($spec_id);
if ($difference >= 43200 && $difference <= 82800) {
// １２時間後 EMAIL
if (!empty($spec_data['mail_address1'])) {
$smtpsend_dao->senduserMail($spec_data['mail_address1'], ORDER_CONFIRM_EMAIL_SUBJECT, ORDER_CONFIRM_EMAIL_CONTENT . "\n" . PREGO_LOGIN_URL);
}
if (!empty($spec_data['mail_address2'])) {
$smtpsend_dao->senduserMail($spec_data['mail_address2'], ORDER_CONFIRM_EMAIL_SUBJECT, ORDER_CONFIRM_EMAIL_CONTENT . "\n" . PREGO_LOGIN_URL);
}
} elseif ($difference > 82800 && $difference < 172800) {
// ２３時間後 EMAIL
if (!empty($spec_data['mail_address1'])) {
$smtpsend_dao->senduserMail($spec_data['mail_address1'], ORDER_CONFIRM_EMAIL_SUBJECT, ORDER_CONFIRM_EMAIL_CONTENT . "\n" . PREGO_LOGIN_URL);
}
if (!empty($spec_data['mail_address2'])) {
$smtpsend_dao->senduserMail($spec_data['mail_address2'], ORDER_CONFIRM_EMAIL_SUBJECT, ORDER_CONFIRM_EMAIL_CONTENT . "\n" . PREGO_LOGIN_URL);
$smtp_dao = new smtpclass();
$pro_dao = new Class_mp_pro();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
$phase = 'input';
// from specialist_unregistered.html
if (isset($_GET['account_id']) && !empty($_GET['account_id'])) {
$account_id = $_GET['account_id'];
$smarty->assign('account_id', $account_id);
// from specialist_refer.html
} else {
$traffic_fee_dao = new Class_mp_spec_traffic_fee();
$spec_fee_dao = new Class_mp_spec_fee();
$spec_profile_dao = new Class_mp_spec_profile();
if (isset($_GET['id']) && $_GET['id'] != '') {
// get spec_forms
$spec_forms = $specialist_dao->get($_GET['id']);
$prolist = $pro_dao->getProBySpecId($_GET['id']);
if (is_array($prolist)) {
foreach ($prolist as $pro) {
if ($pro['pro_id'] == 99) {
$spec_area_else = $pro['pro_name'];
} else {
$spec_areas[] = $pro['pro_id'];
}
}
}
// get spec_traffic_fee_forms by spec_id
$tra_sql = sprintf("select * from mp_spec_traffic_fee where spec_id = '%s'", mysql_real_escape_string($_GET['id']));
$spec_traffic_fee_forms = $traffic_fee_dao->get_rows($tra_sql);
if (is_array($spec_traffic_fee_forms)) {
foreach ($spec_traffic_fee_forms as $dtime) {
