<?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());
<?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) {
} $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();
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
<?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';
<?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
<?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); } }
<?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 = '業務完了';
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) {
<?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
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']);
<?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 );
<?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'];