コード例 #1
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_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'];
コード例 #2
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.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());
コード例 #3
0
<?php

require_once '../system/smarty.inc';
require_once '../system/login.inc.php';
require_once '../system/prego_m.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_payment.php';
require_once '../system/mdao/Class_mp_payment_add.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
$account_dao = new Class_mp_account();
$spec_dao = new Class_mp_specialist();
$payment_dao = new Class_mp_payment();
$promise_spec_dao = new Class_mp_promise_spec();
$payment_add_dao = new Class_mp_payment_add();
if (isset($_GET['csv']) && $_GET['csv'] == "download" || isset($_GET['hist']) && $_GET['hist'] == "2") {
    $forms = $_SESSION['MSEARCH']['payment_search'];
} else {
    $forms = $_POST;
    $_SESSION['MSEARCH']['payment_search'] = $forms;
}
if (isset($_GET['pay_flag']) && $_GET['pay_flag'] != '') {
    $payment_id = $_GET['payment_id'];
    $content_temp_str = $_GET['content_temp'];
    $money_temp_str = $_GET['money_temp'];
    $content = explode(',', $content_temp_str);
    $money = explode(',', $money_temp_str);
    foreach ($content as $k => $v) {
        foreach ($money as $kk => $vv) {
            if ($k == $kk) {
コード例 #4
0
 }
 $smarty->assign('forms', $forms);
 // check ok
 if ($err->clear) {
     $executeflg = TRUE;
     // 登録
     if ($forms['id'] == '') {
         $forms['id'] = $id;
         if ($dao->add0($values)) {
             $smarty->assign('message', '登録が完了しました。');
         } else {
             $smarty->assign('message', '登録が失敗しました。');
         }
         // 更新
     } else {
         $promise_spec_dao = new Class_mp_promise_spec($dao->get_db());
         $spec_fee_dao = new Class_mp_spec_fee($dao->get_db());
         try {
             $dao->begin_trans();
             $forms['memo'] = str_replace(" ", "", $forms['memo']);
             $forms['memo'] = str_replace(" ", "", $forms['memo']);
             $forms['caption'] = str_replace(" ", "", $forms['caption']);
             $forms['caption'] = str_replace(" ", "", $forms['caption']);
             $values['memo'] = $forms['memo'];
             $values['caption'] = $forms['caption'];
             if ($dao->edit($forms['id'], $values)) {
                 // update promise_spec  service_name
                 $service_data = $dao->get($forms['id']);
                 $service_menu = $service_data['service_menu'];
                 $promise_spec_service_id = $forms['id'];
                 $promise_spec_values = array();
コード例 #5
0
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_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
コード例 #6
0
<?php

$smp_floder_flag = true;
require_once '../../system/smarty.inc';
require_once '../../system/mdao/Class_mp_promise_spec.php';
require_once '../../system/mdao/Class_mp_spec_profile.php';
require_once '../../system/mdao/Class_mp_service.php';
require_once '../../system/prego_m.php';
require_once '../../system/mdao/Class_mp_promise_operation_history.php';
session_name('PREGO_ADMIN');
session_start();
$promise_spec_dao = new Class_mp_promise_spec();
$spec_profile_dao = new Class_mp_spec_profile();
$service_dao = new Class_mp_service();
$operation_history_dao = new Class_mp_promise_operation_history();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['id']) && $_GET['id'] != '') {
        if (isset($_GET['u_id']) && $_GET['u_id'] != '') {
            //mp_promise_spec の id
            $id = $_GET['id'];
            $promise_spec_forms = $promise_spec_dao->get($id);
            $arr = array();
            $arr['status'] = 2;
            $promise_spec_dao->edit($id, $arr);
            // add operate_data
            $operate_time = date('y-m-d H:i:s', time());
            $promise_id = $promise_spec_forms['promise_id'];
            $operate_details = "受注確定(約定確定)";
            $user_name = $_SESSION['PREGO_ADMIN']['STAFF_NAME'];
            $operate_man = $user_name . "(スペシャリスト)";
            $operate_history_val['operate_time'] = $operate_time;
<?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';
コード例 #8
0
<?php

require_once '../system/smarty.inc';
require_once '../system/login.inc.php';
require_once '../system/prego_m.php';
require_once '../system/Class_DB.php';
require_once '../system/mdao/Class_mp_specialist.php';
require_once '../system/mdao/Class_mp_promise_spec.php';
require_once '../system/mdao/Class_mp_spec_fee.php';
require_once '../system/mdao/Class_mp_promise.php';
require_once '../system/mdao/Class_mp_spec_profile.php';
require_once '../system/mdao/Class_mp_payment_add.php';
require_once '../system/mdao/Class_mp_payment.php';
$spec_dao = new Class_mp_specialist();
$promise_spec_dao = new Class_mp_promise_spec();
//$spec_fee_dao = new Class_mp_spec_fee;
//$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
コード例 #9
0
<?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);
        }
    }
コード例 #10
0
<?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 = '業務完了';
コード例 #11
0
require_once '../system/smarty.inc';
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_corporate.php';
require_once '../system/mdao/Class_mp_account.php';
require_once '../system/mdao/Class_mp_request.php';
require_once '../system/mdao/Class_mp_request_add.php';
$request_dao = new Class_mp_request();
$account_dao = new Class_mp_account();
$corporate_dao = new Class_mp_corporate();
$request_add_dao = new Class_mp_request_add();
$promise_spec_dao = new Class_mp_promise_spec();
session_start();
if (isset($_GET['csv']) && $_GET['csv'] == "download" || isset($_GET['hist']) && $_GET['hist'] == "2") {
    $forms = $_SESSION['MSEARCH']['bill_search'];
} else {
    $forms = $_POST;
    $_SESSION['MSEARCH']['bill_search'] = $forms;
}
if (isset($_GET['request_flag']) && $_GET['request_flag'] != '') {
    $request_id = $_GET['request_id'];
    $content_temp_str = $_GET['content_temp'];
    $money_temp_str = $_GET['money_temp'];
    $content = explode(',', $content_temp_str);
    $money = explode(',', $money_temp_str);
    foreach ($content as $k => $v) {
        foreach ($money as $kk => $vv) {
コード例 #12
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
コード例 #13
0
 if (isset($forms['spec_id'])) {
     foreach ($forms['spec_id'] as $k => $v) {
         $forms['mutirow'][] = array("id" => $forms['pro_id'][$k], "promise_id" => $forms['promise_id'], "spec_name" => $forms['spec_name'][$k], "spec_id" => $forms['spec_id'][$k], "profile_name" => $forms['profile_name'][$k], "profile_id" => $forms['profile_id'][$k], "service_name" => $forms['service_name'][$k], "service_id" => $forms['service_id'][$k], "day" => $forms['day'][$k], "hour" => $forms['hour'][$k], "minute" => $forms['minute'][$k], "before_mail" => $forms['before_mail' . $k], "overtime_have" => $forms['overtime_have' . $k], "overtime_fee" => $forms['overtime_fee'][$k], "traffic_fee_have" => $forms['traffic_fee_have' . $k], "traffic_fee" => $forms['traffic_fee'][$k], "traffic_fee_detail" => $forms['traffic_fee_detail'][$k], "live_fee_have" => $forms['live_fee_have' . $k], "live_fee" => $forms['live_fee'][$k], "live_fee_detail" => $forms['live_fee_detail'][$k], "other_fee_have" => $forms['other_fee_have' . $k], "other_fee" => $forms['other_fee'][$k], "other_fee_name" => $forms['other_fee_name'][$k], "other_fee_detail" => $forms['other_fee_detail'][$k]);
     }
 }
 if ($forms['mode'] == 'input') {
     $err = new Class_ERROR();
     $promise_chk = $promise_dao->get_checks();
     /*
     foreach ( $promise_chk as $kcol => $chkval ) {
     	$err_mes [$kcol] = $err->check ( $forms [$kcol], $chkval );
     }
     */
     $operation_history_dao = new Class_mp_promise_operation_history($promise_dao->get_db());
     $index = 0;
     $promise_spec_dao = new Class_mp_promise_spec($promise_dao->get_db());
     $promise_spec_chk = $promise_spec_dao->get_checks();
     $dublipe_flag = false;
     $specidarr = array();
     if (count($forms['mutirow']) > 0) {
         foreach ($forms['mutirow'] as $k => $v) {
             $err_mes['spec_name'][$index] = $err->check($v['spec_name'], $promise_spec_chk['spec_name']);
             $err_mes['profile_name'][$index] = $err->check($v['profile_id'], $promise_spec_chk['profile_id']);
             $err_mes['service_name'][$index] = $err->check($v['service_name'], $promise_spec_chk['service_name']);
             if (in_array($v['spec_id'], $specidarr)) {
                 $dublipe_flag = true;
             }
             $specidarr[] = $v['spec_id'];
             $v['hour'] = str_replace(' ', '', $v['hour']);
             $v['minute'] = str_replace(' ', '', $v['minute']);
             $err_mes['hour'][$index] = $err->check($v['hour'], $promise_spec_chk['hour']);
コード例 #14
0
<?php

require_once '../system/smarty.inc';
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_spec.php';
require_once '../system/mdao/Class_mp_promise.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_spec_traffic_fee.php';
require_once '../system/mdao/Class_mp_corporate.php';
require_once '../system/mdao/Class_mp_request.php';
require_once '../system/mdao/Class_mp_request_add.php';
$promise_spec_dao = new Class_mp_promise_spec();
if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    if (isset($_GET['corporate_id']) && !empty($_GET['corporate_id']) && isset($_GET['request_time']) && !empty($_GET['request_time'])) {
        $hidden_request_time = $_GET['request_time'];
        $hidden_corporate_id = $_GET['corporate_id'];
        $hidden_request_status = $_GET['request_status'];
        $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 );
コード例 #15
0
<?php

require_once '../system/smarty.inc';
require_once '../system/prego_m.php';
require_once '../system/login.inc.php';
$forms = $_GET;
if (isset($forms)) {
    $smarty->assign('forms', $forms);
}
$tmphtml = $forms["nm"];
if ($tmphtml == "popup_communication_memo") {
    require_once '../system/mdao/Class_mp_spec_traffic_fee.php';
    require_once '../system/mdao/Class_mp_promise_spec.php';
    $spec_traffic_dao = new Class_mp_spec_traffic_fee();
    $promise_spec_dao = new Class_mp_promise_spec();
    if (isset($_GET['spec_id']) && $_GET['spec_id'] != '') {
        $tra_spec_id = $_GET['spec_id'];
        $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'];
        }
        $select = array('' => "選択してください");
        $traffic_name = array_merge($select, $traffic_name_arr);
    }
    $id = $_GET['id'];