if ($operation_history_dao->add0($operate_history_val)) {
} else {
$executeflg = FALSE;
}
if ($auth == '2') {
// add request data
// get other_id from mp_account by current login_id
$login_id = $_SESSION['PREGO_ADMIN']['STAFF_ID'];
$sql = "select * from mp_account where login_id = '{$login_id}' ";
$account_data = $account_dao->get_rows($sql);
foreach ($account_data as $k => $v) {
$other_id = $v['other_id'];
}
// get corporate_id and corporate_name from mp_corporate by other_id
$sql = "select * from mp_corporate where id = '{$other_id}' ";
$corporate_data = $corporate_dao->get_rows($sql);
foreach ($corporate_data as $k => $v) {
$corporate_name = $v['corporate_name'];
$corporate_id = $v['id'];
}
} elseif ($auth == '1') {
$promise_data = $promise_dao->get($promise_id);
$corporate_id = $promise_data['corporate_id'];
$corporate_name = $promise_data['corporate_name'];
}
// set request values
$request_values['promise_id'] = $promise_id;
$request_values['corporate_id'] = $corporate_id;
$request_values['corporate_name'] = $corporate_name;
//$request_values ['request_time'] = date ( 'Y-m', time()+3600*24*30 );
$pay_time = date('Y-m', strtotime("1 month", $shortime));
} else {
$sql = "select * from mp_corporate";
}
} else {
$sql = "select * from mp_corporate";
}
$hint = "<thead>";
$hint += "<tr>";
$hint += "<th>ID</th>";
$hint += "<th>クライアント名</th>";
$hint += "<th>セット</th>";
$hint += "</tr>";
$hint += "</thead><tbody>";
$content = "";
$end = "</tbody>";
$data = $dao->get_rows($sql);
foreach ($data as $k => $v) {
$index = $k + 1;
$content += "<tr>";
$content += "<td>" . $index . "</td>";
$content += "<td>" . $v['corporate_name'] . "</td>";
$content += "<td class='preview'><a href='javascript:;'>セット</a></td>";
$content += "<input type='hidden' name='corporate_id' value='" . $v['id'] . "' />";
$content += "</tr>";
}
if ($content == "") {
$response = $hint . "<tr><td>" . "no suggestion" . "</td></tr>" . $end;
} else {
$response = $hint . $content . $end;
}
}
