<?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); } }
<?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();