$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
$spec_data = $spec_dao->get($spec_id);
// set promise_spec sql
$spec_name = $spec_data['spec_name'];
//--------------------------------------------------------------------------------------------
// set u_time
$u_time_temp = strtotime($pay_time . '-01');
$timeNowYM = date('Y-m', $u_time_temp);
$dateNowYM = date('Y年m月', $u_time_temp);
$sql = " SELECT * FROM `mp_payment` where spec_id = '{$spec_id}' AND pay_time= '{$timeNowYM}'";
$nowpayment = $promise_spec_dao->get_row($sql);
$payment_id = $nowpayment["id"];
$tmp_date = date("Ym", $u_time_temp);
$tmp_year = substr($tmp_date, 0, 4);
$tmp_mon = substr($tmp_date, 4, 2);
//$tmp_nextmonth=mktime(0,0,0,$tmp_mon+1,1,$tmp_year);
$tmp_forwardmonth = mktime(0, 0, 0, $tmp_mon - 1, 1, $tmp_year);
$timeYM = date("Y-m", $tmp_forwardmonth);
$sql = "select a.*,b.promise_name,c.spec_fee,d.memo as cmemo from mp_promise_spec a " . " inner join mp_promise b on b.id = a.promise_id " . " inner join mp_spec_fee c on c.spec_id = a.spec_id and c.service_id = a.service_id " . " inner join mp_service d on d.id = a.service_id " . " where a.status = '3' and a.spec_id = '{$spec_id}' and a.doing_time like '{$timeYM}%'" . " order by a.doing_time ";
$promise_rows = $promise_spec_dao->get_rows($sql);
//print_r($promise_rows);
// get payment_add by pay_id
$sql = "select * from mp_payment_add where payment_id = '{$payment_id}' ";
$payment_add_data = $payment_add_dao->get_rows($sql);
$other_num = 0;
foreach ($payment_add_data as $k => $v) {
$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 );
// get corporate_name
//$corporate_name = $corporate_data ['corporate_name'];
// get corporate_data
$sql = sprintf("select * from mp_corporate where id = '%s'", $corporate_id);
$corporate_forms = $promise_spec_dao->get_rows($sql);
//select * from mp_request where corporate_id = '35'
//select * from mp_request_add where request_id = '9'
$sql = " SELECT * FROM `mp_request` where corporate_id = '{$corporate_id}' AND request_time= '{$timeNowYM}'";
$nowrequestment = $promise_spec_dao->get_row($sql);
$requestment_id = $nowrequestment["id"];
$tmp_date = date("Ym", $u_time_temp);
$tmp_year = substr($tmp_date, 0, 4);
$tmp_mon = substr($tmp_date, 4, 2);
$tmp_forwardmonth = mktime(0, 0, 0, $tmp_mon - 1, 1, $tmp_year);
$timeYM = date("Y-m", $tmp_forwardmonth);
$sql = "select a.*,b.promise_name,c.spec_fee,c.servers_fee,d.memo as cmemo from mp_promise_spec a " . " inner join mp_promise b on b.id = a.promise_id " . " inner join mp_spec_fee c on c.spec_id = a.spec_id and c.service_id = a.service_id " . " inner join mp_service d on d.id = a.service_id " . " where a.status = '3' and b.corporate_id = '{$corporate_id}' and a.doing_time like '{$timeYM}%'" . " order by a.doing_time ";
$promise_rows = $promise_spec_dao->get_rows($sql);
//print_r($promise_rows);
// get payment_add by pay_id
/*$sql = "select * from mp_request_add where request_id = '$request_id' ";
$request_add_data = $request_add_dao->get_rows($sql);
$other_num = 0;
foreach ($request_add_data as $k => $v) {
$other_num = $other_num + $v['money'];
