require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_corporate.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_request.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/smtpsend.class.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$operation_history_dao = new Class_mp_promise_operation_history($promise_spec_dao->get_db());
$account_dao = new Class_mp_account($promise_spec_dao->get_db());
$corporate_dao = new Class_mp_corporate($promise_spec_dao->get_db());
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$request_dao = new Class_mp_request($promise_spec_dao->get_db());
$specialist_dao = new Class_mp_specialist();
$smtp_dao = new smtpclass();
if (isset($_GET['id']) && !empty($_GET['id'])) {
    $executeflg = true;
    // promise_spec values array
    $values = array();
    $id = $_GET['id'];
    // promise_spec_status
    $status = $_GET['status'];
    // promise_id
    $promise_id = $_GET['promise_id'];
    $promise_spec_id = $_GET['promise_spec_id'];
    $spec_id = $_GET['spec_id'];
    $service_id = $_GET['service_id'];
    // update status
    if ($_GET['status'] == '0') {
        $values['status'] = '1';
require_once '../system/smarty.inc';
require_once '../system/prego_m.php';
require_once '../system/login.inc.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
require_once '../system/mdao/Class_mp_promise_operation_history.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/smtpsend.class.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$operation_history_dao = new Class_mp_promise_operation_history($promise_spec_dao->get_db());
$spec_dao = new Class_mp_specialist();
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$smtp_dao = new smtpclass();
if (isset($_GET['id']) && !empty($_GET['id'])) {
    // set flag
    $executeflg = true;
    // set update values
    $values = array();
    // get id
    $id = $_GET['id'];
    // get current status
    $status = $_GET['status'];
    // get relational promise_id
    $promise_id = $_GET['promise_id'];
    $promise_spec_id = $_GET['promise_spec_id'];
    $spec_id = $_GET['spec_id'];
    $service_id = $_GET['service_id'];
    $values['status'] = '4';
require_once '../system/smarty.inc';
require_once '../system/prego_m.php';
require_once '../system/login.inc.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
require_once '../system/mdao/Class_mp_promise_operation_history.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/smtpsend.class.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$operation_history_dao = new Class_mp_promise_operation_history($promise_spec_dao->get_db());
$spec_dao = new Class_mp_specialist();
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$smtp_dao = new smtpclass();
if (isset($_GET['id']) && !empty($_GET['id'])) {
    // set flag
    $executeflg = true;
    // set update values
    $values = array();
    // get id
    $id = $_GET['id'];
    // get current status
    $status = $_GET['status'];
    // get relational promise_id
    $promise_id = $_GET['promise_id'];
    $promise_spec_id = $_GET['promise_spec_id'];
    $spec_id = $_GET['spec_id'];
    $service_id = $_GET['service_id'];
    // set update values
<?php

require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/Class_MAIL.php';
require_once '../system/mdao/Class_mp_corporate.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_request.php';
require_once '../system/smtpsend.class.php';
require_once '../system/prego_m.php';
require_once '../system/Class_ERROR.php';
require_once '../system/login.inc.php';
$corporate_dao = new Class_mp_corporate();
$smtp_dao = new smtpclass();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    $phase = 'input';
    if (isset($_GET['account_id']) && !empty($_GET['account_id'])) {
        $account_id = $_GET['account_id'];
        $smarty->assign('account_id', $account_id);
    } else {
        $tantou_dao = new Class_mp_corporate_tantou();
        if (isset($_GET['id']) && $_GET['id'] != '') {
            $corporate_forms = $corporate_dao->get($_GET['id']);
            $sql = sprintf("select * from mp_corporate_tantou where corporate_id = '%s'", mysql_real_escape_string($_GET['id']));
            $tantou_forms = $tantou_dao->get_rows($sql);
            $forms["id"] = $_GET['id'];
            // deal with post_code
            $post_code = split('-', $corporate_forms['post_code']);
            $region = $post_code[0];
<?php

require_once '../system/smarty.inc';
require_once '../system/prego_m.php';
require_once '../system/login.inc.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
require_once '../system/mdao/Class_mp_promise_operation_history.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/smtpsend.class.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$operation_history_dao = new Class_mp_promise_operation_history();
$specialist_dao = new Class_mp_specialist();
$smtp_dao = new smtpclass();
if (isset($_GET['id']) && !empty($_GET['id'])) {
    $executeflg = true;
    // promise_spec values array
    $values = array();
    $id = $_GET['id'];
    // promise_spec_status
    $status = $_GET['status'];
    // promise_id
    $promise_id = $_GET['promise_id'];
    $promise_spec_id = $_GET['promise_spec_id'];
    $spec_id = $_GET['spec_id'];
    $service_id = $_GET['service_id'];
    // update status
    if ($_GET['status'] == '1') {
        $values['status'] = '2';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_payment.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_corporate_tantou.php';
require_once '../system/mdao/Class_mp_spec_traffic_fee.php';
require_once '../system/smtpsend.class.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$operation_history_dao = new Class_mp_promise_operation_history($promise_spec_dao->get_db());
$spec_dao = new Class_mp_specialist();
$payment_dao = new Class_mp_payment();
$account_dao = new Class_mp_account();
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$spec_traffic_dao = new Class_mp_spec_traffic_fee();
$smtp_dao = new smtpclass();
if (isset($_GET['id']) && !empty($_GET['id'])) {
    if (isset($_GET['spec_id']) && $_GET['spec_id'] != '') {
        // get spec_id
        $tra_spec_id = $_GET['spec_id'];
        // get spec_traffic data
        $sql = "select * from mp_spec_traffic_fee where spec_id = '{$tra_spec_id}'";
        $spec_traffic_data = $spec_traffic_dao->get_rows($sql);
        $traffic_name = array();
        $traffic_fee = array();
        $traffic_memo = array();
        foreach ($spec_traffic_data as $k => $v) {
            $traffic_name_arr[] = $v['traffic_name'];
            $traffic_fee[] = $v['traffic_fee'];
            $traffic_memo[] = $v['traffic_memo'];
        }
<?php

require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
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
require_once '../system/prego_m.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
require_once '../system/mdao/Class_mp_spec_fee.php';
require_once '../system/mdao/Class_mp_payment.php';
require_once '../system/mdao/Class_mp_promise_operation_history.php';
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) {
require_once '../system/smarty.inc';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_spec_traffic_fee.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_promise_spec.php';
require_once '../system/mdao/Class_mp_payment.php';
require_once '../system/mdao/Class_mp_pro.php';
require_once '../system/prego_m.php';
require_once '../system/Class_ERROR.php';
require_once '../system/login.inc.php';
require_once '../system/smtpsend.class.php';
$specialist_dao = new Class_mp_specialist();
$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']);