function storeAbacAssertion($assertion, $issuer_fingerprint, $issuer_role, $subject_fingerprint, $expiration) { $conn = portal_conn(); $base64_assertion = base64_encode($assertion); $sql = "INSERT INTO abac_assertion (" . "issuer, issuer_role, subject, expiration, credential" . ") VALUES (" . $conn->quote($issuer_fingerprint, 'text') . ', ' . $conn->quote($issuer_role, 'text') . ', ' . $conn->quote($subject_fingerprint, 'text') . ', ' . $conn->quote(db_date_format($expiration), 'timestamp') . ', ' . $conn->quote($base64_assertion, 'text') . ')'; /* print "command = $sql<br/>"; */ $result = db_execute_statement($sql, "abac assertion insert"); return $result[RESPONSE_ARGUMENT::VALUE]; }
function extract_date() { // echo date("m", strtotime("2013-1-07")); // echo substr(date("Y", strtotime("2013-1-07")), -2); // echo date("Y", strtotime("2013-02-02")); // echo db_date_format("02/12/2015 15:30"); echo db_date_format("02/12/2015") . " " . date('H:i:s'); echo "<br>"; echo date('Y-m-d H:i:s'); }
function resolve_pending_request($args) { $request_id = null; if (array_key_exists(RQ_ARGUMENTS::REQUEST_ID, $args)) { $request_id = $args[RQ_ARGUMENTS::REQUEST_ID]; } if (!isset($request_id) or is_null($request_id)) { return generate_response(RESPONSE_ERROR::ARGS, '', 'No request_id given'); } $context_type = null; if (array_key_exists(RQ_ARGUMENTS::CONTEXT_TYPE, $args)) { $context_type = $args[RQ_ARGUMENTS::CONTEXT_TYPE]; } $resolution_status = null; if (array_key_exists(RQ_ARGUMENTS::RESOLUTION_STATUS, $args)) { $resolution_status = $args[RQ_ARGUMENTS::RESOLUTION_STATUS]; } $resolver = null; if (array_key_exists(RQ_ARGUMENTS::RESOLVER, $args)) { $resolver = $args[RQ_ARGUMENTS::RESOLVER]; } $resolution_description = null; if (array_key_exists(RQ_ARGUMENTS::RESOLUTION_DESCRIPTION, $args)) { $resolution_description = $args[RQ_ARGUMENTS::RESOLUTION_DESCRIPTION]; } $now = new DateTime(null, new DateTimeZone('UTC')); $conn = db_conn(); $sql = "UPDATE " . get_request_tablename($context_type) . " SET " . RQ_REQUEST_TABLE_FIELDNAME::STATUS . " = " . $conn->quote($resolution_status, 'integer') . ", " . RQ_REQUEST_TABLE_FIELDNAME::RESOLUTION_DESCRIPTION . " = " . $conn->quote($resolution_description, 'text') . ", " . RQ_REQUEST_TABLE_FIELDNAME::RESOLUTION_TIMESTAMP . " = " . $conn->quote(db_date_format($now), 'timestamp') . ", " . RQ_REQUEST_TABLE_FIELDNAME::RESOLVER . " = " . $conn->quote($resolver, 'text') . " WHERE " . RQ_REQUEST_TABLE_FIELDNAME::ID . " = " . $conn->quote($request_id, 'integer'); // error_log("resolve_pending_request.sql = " . $sql); $result = db_execute_statement($sql); return $result; }