<?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_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'];
<?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.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_account.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/smtpsend.class.php';
require_once '../system/mdao/Class_mp_promise_operation_history.php';
$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$spec_profile_dao = new Class_mp_spec_profile();
$spec_fee_dao = new Class_mp_spec_fee();
$account_dao = new Class_mp_account();
$spec_dao = new Class_mp_specialist();
$specialist_dao = new Class_mp_specialist();
$smtp_dao = new smtpclass();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['id']) && !empty($_GET['id'])) {
        if (isset($_GET['satisfy_status']) && $_GET['satisfy_status'] != '' && isset($_GET['count_id']) && $_GET['count_id'] != '') {
            $id = $_GET['count_id'];
            $satisfy_status = $_GET['satisfy_status'];
            $values = array();
            $values['satisfy_status'] = $satisfy_status;
            $promise_spec_dao->edit($id, $values);
            $operate_time = date('y-m-d H:i:s', time());
                 if ($v['mail_address'] != '') {
                     $smtp_dao->senduserMail($v['mail_address'], PREGO_MAIL_CORPORATE_INSERT_SUBJECT, $prego_mail_corporate_insert_content);
                 }
             }
             $smarty->assign('message', '登録が完了しました。通知メール送信完了しました。');
         } else {
             $corporate_dao->rollback_trans();
             $smarty->assign('message', '登録が失敗しました。');
         }
     } catch (Exception $e) {
         $corporate_dao->rollback_trans();
         $smarty->assign('message', 'DBエラーで失敗しました。');
     }
     // 更新
 } else {
     $promise_dao = new Class_mp_promise($corporate_dao->get_db());
     $request_dao = new Class_mp_request($corporate_dao->get_db());
     try {
         // begin transaction
         $corporate_dao->begin_trans();
         if ($auth == '1') {
             // 						$order = array("\r\n","\n","\r");
             // 						$replace = "<br/>";
             // 						$forms['memo'] = str_replace($order,$replace,$forms['memo']);
             $forms['memo'] = str_replace(" ", "", $forms['memo']);
             $forms['memo'] = str_replace(" ", "", $forms['memo']);
             $values['memo'] = $forms['memo'];
         }
         // update corporate info
         if ($corporate_dao->edit($forms['id'], $values)) {
             $promise_corporate_data = $corporate_dao->get($forms['id']);
<?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 = '業務完了';
<?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);
        }
    }
예제 #6
0
<?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/login.inc.php';
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();