$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'];