function api_getConstituencies_date($date) {
if ($date = parse_date($date)) {
api_getConstituencies('"' . $date['iso'] . '"');
} else {
api_error('Invalid date format');
}
}
function api_getMembers_date($house, $date) {
if ($date = parse_date($date)) {
api_getMembers($house, '"' . $date['iso'] . '"');
} else {
api_error('Invalid date format');
}
}
public function getArgs()
{
$args = array();
if (get_http_var('f') == 'csv') {
$args['f'] = 'csv';
}
$date = get_http_var('date');
if ($date) {
$date = parse_date($date);
if ($date) {
$args['date'] = $date['iso'];
}
} elseif (get_http_var('all')) {
$args['all'] = true;
}
if ($this->type == 'peers') {
$args['order'] = 'name';
}
$order = get_http_var('o');
$orders = array('n' => 'name', 'f' => 'given_name', 'l' => 'family_name', 'c' => 'constituency', 'p' => 'party', 'd' => 'debates');
if (array_key_exists($order, $orders)) {
$args['order'] = $orders[$order];
}
return $args;
}
function api_getCommittee_name($name) {
$db = new ParlDB;
$name = preg_replace('#\s+Committee#', '', $name);
$date = parse_date(get_http_var('date'));
if ($date) $date = '"' . $date['iso'] . '"';
else $date = 'date(now())';
$q = $db->query("select distinct(dept) from moffice
where dept like '%" . mysql_real_escape_string($name) . "%Committee'
and from_date <= " . $date . ' and '
. $date . ' <= to_date');
if ($q->rows() > 1) {
# More than one committee matches
for ($i=0; $i<$q->rows(); $i++) {
$output['committees'][] = array(
'name' => $q->field($i, 'dept')
);
}
api_output($output);
} elseif ($q->rows()) {
# One committee
$q = $db->query("select * from moffice,member
where moffice.person = member.person_id
and dept like '%" . mysql_real_escape_string($name) . "%Committee'
and from_date <= " . $date . ' and ' . $date . " <= to_date
and entered_house <= " . $date . ' and ' . $date . ' <= left_house');
if ($q->rows()) {
$output = array();
$output['committee'] = $q->field(0, 'dept');
for ($i=0; $i<$q->rows(); $i++) {
$member = array(
'person_id' => $q->field($i, 'person'),
'name' => $q->field($i, 'first_name') . ' ' . $q->field($i, 'last_name'),
);
if ($q->field($i, 'position') == 'Chairman') {
$member['position'] = $q->field($i, 'position');
}
$output['members'][] = $member;
}
api_output($output);
} else {
api_error('That committee has no members...?');
}
} else {
api_error('That name was not recognised');
}
}
private function parse_date_params()
{
$searchstring = '';
if (get_http_var('from') || get_http_var('to')) {
$from = parse_date(get_http_var('from'));
if ($from) {
$from = $from['iso'];
} else {
$from = '1935-10-01';
}
$to = parse_date(get_http_var('to'));
if ($to) {
$to = $to['iso'];
} else {
$to = date('Y-m-d');
}
$searchstring .= " {$from}..{$to}";
}
return $searchstring;
}
function create_unit($data)
{
$fields = array('unit_number', 'element', 'rarity', 'cost', 'hit_count', 'bb_hits', 'sbb_hits', 'bb_fill', 'sbb_fill', 'lord_hp', 'lord_atk', 'lord_def', 'lord_rec', 'anima_hp', 'anima_atk', 'anima_def', 'anima_rec', 'breaker_hp', 'breaker_atk', 'breaker_def', 'breaker_rec', 'guardian_hp', 'guardian_atk', 'guardian_def', 'guardian_rec', 'oracle_hp', 'oracle_atk', 'oracle_def', 'oracle_rec', 'leaders_skill_effect', 'brave_burst_effect', 'super_brave_burst_effect');
$type = 'unit';
$valid_type = function_exists('post_type_exists') && post_type_exists($type);
if (!$valid_type) {
//$this->log['error']["type-{$type}"] = sprintf('Unknown post type "%s".', $type);
}
$new_post = array('post_title' => convert_chars($data['unit_name']), 'post_content' => 'Not available', 'post_status' => 'publish', 'post_type' => $type, 'post_date' => parse_date(time()));
// create!
$id = wp_insert_post($new_post);
//Now that we have a new post ID update the associated field data
foreach ($fields as $field) {
if (array_key_exists($field, $data)) {
update_field($field, $data[$field], $id);
} else {
return "<b>The field {$field} does not exist.</b>";
}
}
return $id;
}
function list_reps($type, $rep_plural, $search_sidebar)
{
global $this_page, $PAGE, $DATA;
$this_page = $type;
$args = array();
if ($type == 'peers') {
$args['order'] = 'name';
}
$date = get_http_var('date');
if ($date) {
$date = parse_date($date);
if ($date) {
$DATA->set_page_metadata($this_page, 'title', $rep_plural . ', as on ' . format_date($date['iso'], LONGDATEFORMAT));
$args['date'] = $date['iso'];
}
} elseif (get_http_var('all')) {
$DATA->set_page_metadata($this_page, 'title', 'All ' . $rep_plural . ', including former ones');
$args['all'] = true;
} else {
$DATA->set_page_metadata($this_page, 'title', 'All ' . $rep_plural);
}
if (get_http_var('f') != 'csv') {
$PAGE->page_start();
$PAGE->stripe_start();
$format = 'html';
} else {
$format = 'csv';
}
$order = get_http_var('o');
$orders = array('n' => 'name', 'f' => 'given_name', 'l' => 'family_name', 'c' => 'constituency', 'p' => 'party', 'd' => 'debates');
if (array_key_exists($order, $orders)) {
$args['order'] = $orders[$order];
}
$PEOPLE = new PEOPLE();
$PEOPLE->display($type, $args, $format);
if (get_http_var('f') != 'csv') {
$PAGE->stripe_end(array(array('type' => 'include', 'content' => 'minisurvey'), array('type' => 'include', 'content' => 'people'), array('type' => 'include', 'content' => $search_sidebar)));
$PAGE->page_end();
}
}
// Update the 'approved' property
$req = new Request();
$approved = empty($_POST['approved']) ? 'false' : 'true';
$query = 'UPDATE request SET approved=' . $approved . ' WHERE id=' . $_POST['rid'];
$req->query($query);
// What's the id of the person this job is assigned to?
$user = new Users();
$user->fullname = $_POST['assign_to'];
$user->find();
$aid = $user->uid;
// Insert the new assignment
$asn = new Assign();
$asn->rid = $_POST['rid'];
$asn->hours = $_POST['hours'];
$asn->cost = str_replace('$', '', $_POST['cost']);
$asn->complete = parse_date($_POST);
$asn->aid = $aid;
$asn->insert();
header('Location: index.php');
}
// Initialize values!
$name = '';
$phone = '';
$year = '';
$month = '';
$day = '';
$desc = '';
$checked = '';
$id = isset($_GET['id']) ? $_GET['id'] : null;
if ($id) {
$req = new Request();
public static function Get_summary_list($account1_id, $account2_id, $start_date, $end_date, &$summary_list)
{
$summary_list = array();
$error = '';
// VALIDATE
$start_time = parse_date($start_date);
$end_time = parse_date($end_date);
if ($start_time == -1) {
return 'Start date is invalid';
} elseif ($end_time == -1) {
return 'End date is invalid';
}
$start_date_sql = date('Y-m-d', $start_time);
$end_date_sql = date('Y-m-d', $end_time);
// Query the normal balance of the selected accounts
$sql = "SELECT a.account_id, a.account_debit " . "FROM Accounts a \n" . "WHERE account_id IN (:account1_id, :account2_id) ";
$pdo = db_connect_pdo();
$ps = $pdo->prepare($sql);
$ps->bindParam(':account1_id', $account1_id);
$ps->bindParam(':account2_id', $account2_id);
$success = $ps->execute();
if (!$success) {
return get_pdo_error($ps);
}
$account1_debit = 1;
$account2_debit = 1;
while ($row = $ps->fetch(PDO::FETCH_ASSOC)) {
if ($row['account_id'] == $account1_id) {
$account1_debit = $row['account_debit'];
} elseif ($row['account_id'] == $account2_id) {
$account2_debit = $row['account_debit'];
}
}
// SQL statement: group the summary by month & year (once per account)
for ($i = 0; $i < 2; $i++) {
$group_sql = "month(t.accounting_date), year(t.accounting_date) ";
$month_sql = "month(t.accounting_date) as accounting_month, ";
if ($i == 0 || $i == 2) {
$account_id = $account1_id;
$account_debit = $account1_debit;
} elseif ($i == 1 || $i == 3) {
$account_id = $account2_id;
$account_debit = $account2_debit;
}
if ($i == 2 || $i == 3) {
// yearly summary
$group_sql = "year(t.accounting_date) \n";
// count as month 13, as this sorts after december
$month_sql = "13 as accounting_month, ";
}
$sql = "SELECT sum(ledger_amount * a.account_debit * :account_debit) " . " as account_sum, {$month_sql} " . " year(t.accounting_date) as accounting_year \n" . "FROM Transactions t \n" . "INNER JOIN Ledger_Entries le on le.trans_id = t.trans_id \n" . "INNER JOIN Accounts a on a.account_id = le.account_id \n" . "LEFT JOIN Accounts a2 on a.account_parent_id = a2.account_id \n" . "WHERE (a.account_id = :account_id OR " . " a2.account_id = :account_id OR " . " a2.account_parent_id = :account_id) " . " and t.accounting_date >= :start_date_sql " . " and t.accounting_date <= :end_date_sql \n" . "GROUP BY {$group_sql} \n" . "ORDER BY year(accounting_date) ASC, month(accounting_date) ASC ";
$ps = $pdo->prepare($sql);
$ps->bindParam(':account_debit', $account_debit);
$ps->bindParam(':account_id', $account_id);
$ps->bindParam(':start_date_sql', $start_date_sql);
$ps->bindParam(':end_date_sql', $end_date_sql);
$success = $ps->execute();
if (!$success) {
return get_pdo_error($ps);
}
$ytd_total = 0;
$last_key = '';
$last_year = 0;
// (YYYY-MM) => (month, year, account1_sum, account2_sum)
while ($row = $ps->fetch(PDO::FETCH_ASSOC)) {
$summary_year = $row['accounting_year'];
if ($summary_year != $last_year) {
// new year; reset the YTD totals
$ytd_total = 0;
}
$summary_month = $row['accounting_month'];
$summary_month = str_pad($summary_month, 2, '0', STR_PAD_LEFT);
$key = $summary_year . '-' . $summary_month;
$ytd_total += $row['account_sum'];
if ($i == 0 || $i == 2) {
// account 1 query (always a new list item)
$summary_list[$key] = array((int) $summary_month, $summary_year, $row['account_sum'], 0, $ytd_total, 0);
if ($last_key != '') {
// for account YTD, when not on first row,
// grab last month's value as default.
// This is in case this month has no data;
// the YTD should still stay the same.
// $summary_list[$key][3] =
// $summary_list[$last_key][3];
// $summary_list[$key][5] =
// $summary_list[$last_key][5];
}
} else {
// account2: check for existing list item
if (array_key_exists($key, $summary_list)) {
$summary_list[$key][3] = $row['account_sum'];
$summary_list[$key][5] = $ytd_total;
} else {
// no existing data for this month
$summary_list[$key] = array((int) $summary_month, $summary_year, 0, $row['account_sum'], 0, $ytd_total);
}
}
$last_key = $key;
$last_year = $summary_year;
}
// row loop
}
// account loop
$pdo = null;
// re-sort by the key in descending order
ksort($summary_list);
return $error;
}
function process_csv($filename, $override_imports, $override_expiry, $separator = ',', $quote = '"')
{
$sql = e107::getDb();
$pref['ban_durations'] = e107::getPref('ban_durations');
$mes = e107::getMessage();
// echo "Read CSV: {$filename} separator: {$separator}, quote: {$quote} override imports: {$override_imports} override expiry: {$override_expiry}<br />";
// Renumber imported bans
if ($override_imports) {
$sql->db_Update('banlist', "`banlist_bantype`=" . eIPHandler::BAN_TYPE_TEMPORARY . " WHERE `banlist_bantype` = " . eIPHandler::BAN_TYPE_IMPORTED);
}
$temp = file($filename);
$line_num = 0;
foreach ($temp as $line) {
// Process one entry
$line = trim($line);
$line_num++;
if ($line) {
$fields = explode($separator, $line);
$field_num = 0;
$field_list = array('banlist_bantype' => eIPHandler::BAN_TYPE_IMPORTED);
foreach ($fields as $f) {
$f = trim($f);
if (substr($f, 0, 1) == $quote) {
if (substr($f, -1, 1) == $quote) {
// Strip quotes
$f = substr($f, 1, -1);
// Strip off the quotes
} else {
$mes->addError(BANLAN_49 . $line_num);
return BANLAN_49 . $line_num;
}
}
// Now handle the field
$field_num++;
switch ($field_num) {
case 1:
// IP address
$field_list['banlist_ip'] = e107::getIPHandler()->ipEncode($f);
break;
case 2:
// Original date of ban
$field_list['banlist_datestamp'] = parse_date($f);
break;
case 3:
// Expiry of ban - depends on $override_expiry
if ($override_expiry) {
$field_list['banlist_banexpires'] = parse_date($f);
} else {
// Use default ban time from now
$field_list['banlist_banexpires'] = $pref['ban_durations'][eIPHandler::BAN_TYPE_IMPORTED] ? time() + 60 * 60 * $pref['ban_durations'][eIPHandler::BAN_TYPE_IMPORTED] : 0;
}
break;
case 4:
// Original ban type - we always ignore this and force to 'imported'
break;
case 5:
// Ban reason originally generated by E107
$field_list['banlist_reason'] = $f;
break;
case 6:
// Any user notes added
$field_list['banlist_notes'] = $f;
break;
default:
// Just ignore any others
}
}
$qry = "REPLACE INTO `#banlist` (" . implode(',', array_keys($field_list)) . ") values ('" . implode("', '", $field_list) . "')";
// echo count($field_list)." elements, query: ".$qry."<br />";
if (!$sql->db_Select_gen($qry)) {
$mes->addError(BANLAN_50 . $line_num);
return BANLAN_50 . $line_num;
}
}
}
// Success here - may need to delete old imported bans
if ($override_imports) {
$sql->db_Delete('banlist', "`banlist_bantype` = " . eIPHandler::BAN_TYPE_TEMPORARY);
}
@unlink($filename);
// Delete file once done
$mes->addSuccess(str_replace('--NUM--', $line_num, BANLAN_51) . $filename);
return str_replace('--NUM--', $line_num, BANLAN_51) . $filename;
}
function era_callback(&$out)
{
global $encount, $debug, $claim_status_codes, $adjustment_reasons, $remark_codes;
global $invoice_total, $last_code, $paydate, $INTEGRATED_AR;
global $InsertionId;
//last inserted ID of
// Some heading information.
$chk_123 = $out['check_number'];
$chk_123 = str_replace(' ', '_', $chk_123);
if (isset($_REQUEST['chk' . $chk_123])) {
if ($encount == 0) {
writeMessageLine('#ffffff', 'infdetail', "Payer: " . htmlspecialchars($out['payer_name'], ENT_QUOTES));
if ($debug) {
writeMessageLine('#ffffff', 'infdetail', "WITHOUT UPDATE is selected; no changes will be applied.");
}
}
$last_code = '';
$invoice_total = 0.0;
$bgcolor = ++$encount & 1 ? "#ddddff" : "#ffdddd";
list($pid, $encounter, $invnumber) = slInvoiceNumber($out);
// Get details, if we have them, for the invoice.
$inverror = true;
$codes = array();
if ($pid && $encounter) {
// Get invoice data into $arrow or $ferow.
if ($INTEGRATED_AR) {
$ferow = sqlQuery("SELECT e.*, p.fname, p.mname, p.lname " . "FROM form_encounter AS e, patient_data AS p WHERE " . "e.pid = '{$pid}' AND e.encounter = '{$encounter}' AND " . "p.pid = e.pid");
if (empty($ferow)) {
$pid = $encounter = 0;
$invnumber = $out['our_claim_id'];
} else {
$inverror = false;
$codes = ar_get_invoice_summary($pid, $encounter, true);
// $svcdate = substr($ferow['date'], 0, 10);
}
} else {
$arres = SLQuery("SELECT ar.id, ar.notes, ar.shipvia, customer.name " . "FROM ar, customer WHERE ar.invnumber = '{$invnumber}' AND " . "customer.id = ar.customer_id");
if ($sl_err) {
die($sl_err);
}
$arrow = SLGetRow($arres, 0);
if ($arrow) {
$inverror = false;
$codes = get_invoice_summary($arrow['id'], true);
} else {
// oops, no such invoice
$pid = $encounter = 0;
$invnumber = $out['our_claim_id'];
}
}
// end not internal a/r
}
// Show the claim status.
$csc = $out['claim_status_code'];
$inslabel = 'Ins1';
if ($csc == '1' || $csc == '19') {
$inslabel = 'Ins1';
}
if ($csc == '2' || $csc == '20') {
$inslabel = 'Ins2';
}
if ($csc == '3' || $csc == '21') {
$inslabel = 'Ins3';
}
$primary = $inslabel == 'Ins1';
writeMessageLine($bgcolor, 'infdetail', "Claim status {$csc}: " . $claim_status_codes[$csc]);
// Show an error message if the claim is missing or already posted.
if ($inverror) {
writeMessageLine($bgcolor, 'errdetail', "The following claim is not in our database");
} else {
// Skip this test. Claims can get multiple CLPs from the same payer!
//
// $insdone = strtolower($arrow['shipvia']);
// if (strpos($insdone, 'ins1') !== false) {
// $inverror = true;
// writeMessageLine($bgcolor, 'errdetail',
// "Primary insurance EOB was already posted for the following claim");
// }
}
if ($csc == '4') {
//Denial case, code is stored in the claims table for display in the billing manager screen with reason explained.
$inverror = true;
if (!$debug) {
if ($pid && $encounter) {
$code_value = '';
foreach ($out['svc'] as $svc) {
foreach ($svc['adj'] as $adj) {
//Per code and modifier the reason will be showed in the billing manager.
$code_value .= $svc['code'] . '_' . $svc['mod'] . '_' . $adj['group_code'] . '_' . $adj['reason_code'] . ',';
}
}
$code_value = substr($code_value, 0, -1);
//We store the reason code to display it with description in the billing manager screen.
//process_file is used as for the denial case file name will not be there, and extra field(to store reason) can be avoided.
updateClaim(true, $pid, $encounter, $_REQUEST['InsId'], substr($inslabel, 3), 7, 0, $code_value);
}
}
writeMessageLine($bgcolor, 'errdetail', "Not posting adjustments for denied claims, please follow up manually!");
} else {
if ($csc == '22') {
$inverror = true;
writeMessageLine($bgcolor, 'errdetail', "Payment reversals are not automated, please enter manually!");
}
}
if ($out['warnings']) {
writeMessageLine($bgcolor, 'infdetail', nl2br(rtrim($out['warnings'])));
}
// Simplify some claim attributes for cleaner code.
$service_date = parse_date($out['dos']);
$check_date = $paydate ? $paydate : parse_date($out['check_date']);
$production_date = $paydate ? $paydate : parse_date($out['production_date']);
if ($INTEGRATED_AR) {
$insurance_id = arGetPayerID($pid, $service_date, substr($inslabel, 3));
if (empty($ferow['lname'])) {
$patient_name = $out['patient_fname'] . ' ' . $out['patient_lname'];
} else {
$patient_name = $ferow['fname'] . ' ' . $ferow['lname'];
}
} else {
$insurance_id = 0;
foreach ($codes as $cdata) {
if ($cdata['ins']) {
$insurance_id = $cdata['ins'];
break;
}
}
$patient_name = $arrow['name'] ? $arrow['name'] : $out['patient_fname'] . ' ' . $out['patient_lname'];
}
$error = $inverror;
// This loops once for each service item in this claim.
foreach ($out['svc'] as $svc) {
// Treat a modifier in the remit data as part of the procedure key.
// This key will then make its way into SQL-Ledger.
$codekey = $svc['code'];
if ($svc['mod']) {
$codekey .= ':' . $svc['mod'];
}
$prev = $codes[$codekey];
$codetype = '';
//will hold code type, if exists
// This reports detail lines already on file for this service item.
if ($prev) {
$codetype = $codes[$codekey]['code_type'];
//store code type
writeOldDetail($prev, $patient_name, $invnumber, $service_date, $codekey, $bgcolor);
// Check for sanity in amount charged.
$prevchg = sprintf("%.2f", $prev['chg'] + $prev['adj']);
if ($prevchg != abs($svc['chg'])) {
writeMessageLine($bgcolor, 'errdetail', "EOB charge amount " . $svc['chg'] . " for this code does not match our invoice");
$error = true;
}
// Check for already-existing primary remittance activity.
// Removed this check because it was not allowing for copays manually
// entered into the invoice under a non-copay billing code.
/****
if ((sprintf("%.2f",$prev['chg']) != sprintf("%.2f",$prev['bal']) ||
$prev['adj'] != 0) && $primary)
{
writeMessageLine($bgcolor, 'errdetail',
"This service item already has primary payments and/or adjustments!");
$error = true;
}
****/
unset($codes[$codekey]);
} else {
// This is not an error. If we are not in error mode and not debugging,
// insert the service item into SL. Then display it (in green if it
// was inserted, or in red if we are in error mode).
$description = "CPT4:{$codekey} Added by {$inslabel} {$production_date}";
if (!$error && !$debug) {
if ($INTEGRATED_AR) {
arPostCharge($pid, $encounter, 0, $svc['chg'], 1, $service_date, $codekey, $description, $debug, '', $codetype);
} else {
slPostCharge($arrow['id'], $svc['chg'], 1, $service_date, $codekey, $insurance_id, $description, $debug);
}
$invoice_total += $svc['chg'];
}
$class = $error ? 'errdetail' : 'newdetail';
writeDetailLine($bgcolor, $class, $patient_name, $invnumber, $codekey, $production_date, $description, $svc['chg'], $error ? '' : $invoice_total);
}
$class = $error ? 'errdetail' : 'newdetail';
// Report Allowed Amount.
if ($svc['allowed']) {
// A problem here is that some payers will include an adjustment
// reflecting the allowed amount, others not. So here we need to
// check if the adjustment exists, and if not then create it. We
// assume that any nonzero CO (Contractual Obligation) or PI
// (Payer Initiated) adjustment is good enough.
$contract_adj = sprintf("%.2f", $svc['chg'] - $svc['allowed']);
foreach ($svc['adj'] as $adj) {
if (($adj['group_code'] == 'CO' || $adj['group_code'] == 'PI') && $adj['amount'] != 0) {
$contract_adj = 0;
}
}
if ($contract_adj > 0) {
$svc['adj'][] = array('group_code' => 'CO', 'reason_code' => 'A2', 'amount' => $contract_adj);
}
writeMessageLine($bgcolor, 'infdetail', 'Allowed amount is ' . sprintf("%.2f", $svc['allowed']));
}
// Report miscellaneous remarks.
if ($svc['remark']) {
$rmk = $svc['remark'];
writeMessageLine($bgcolor, 'infdetail', "{$rmk}: " . $remark_codes[$rmk]);
}
// Post and report the payment for this service item from the ERA.
// By the way a 'Claim' level payment is probably going to be negative,
// i.e. a payment reversal.
if ($svc['paid']) {
if (!$error && !$debug) {
if ($INTEGRATED_AR) {
arPostPayment($pid, $encounter, $InsertionId[$out['check_number']], $svc['paid'], $codekey, substr($inslabel, 3), $out['check_number'], $debug, '', $codetype);
} else {
slPostPayment($arrow['id'], $svc['paid'], $check_date, "{$inslabel}/" . $out['check_number'], $codekey, $insurance_id, $debug);
}
$invoice_total -= $svc['paid'];
}
$description = "{$inslabel}/" . $out['check_number'] . ' payment';
if ($svc['paid'] < 0) {
$description .= ' reversal';
}
writeDetailLine($bgcolor, $class, $patient_name, $invnumber, $codekey, $check_date, $description, 0 - $svc['paid'], $error ? '' : $invoice_total);
}
// Post and report adjustments from this ERA. Posted adjustment reasons
// must be 25 characters or less in order to fit on patient statements.
foreach ($svc['adj'] as $adj) {
$description = $adj['reason_code'] . ': ' . $adjustment_reasons[$adj['reason_code']];
if ($adj['group_code'] == 'PR' || !$primary) {
// Group code PR is Patient Responsibility. Enter these as zero
// adjustments to retain the note without crediting the claim.
if ($primary) {
/****
$reason = 'Pt resp: '; // Reasons should be 25 chars or less.
if ($adj['reason_code'] == '1') $reason = 'To deductible: ';
else if ($adj['reason_code'] == '2') $reason = 'Coinsurance: ';
else if ($adj['reason_code'] == '3') $reason = 'Co-pay: ';
****/
$reason = "{$inslabel} ptresp: ";
// Reasons should be 25 chars or less.
if ($adj['reason_code'] == '1') {
$reason = "{$inslabel} dedbl: ";
} else {
if ($adj['reason_code'] == '2') {
$reason = "{$inslabel} coins: ";
} else {
if ($adj['reason_code'] == '3') {
$reason = "{$inslabel} copay: ";
}
}
}
} else {
$reason = "{$inslabel} note " . $adj['reason_code'] . ': ';
/****
$reason .= sprintf("%.2f", $adj['amount']);
****/
}
$reason .= sprintf("%.2f", $adj['amount']);
// Post a zero-dollar adjustment just to save it as a comment.
if (!$error && !$debug) {
if ($INTEGRATED_AR) {
arPostAdjustment($pid, $encounter, $InsertionId[$out['check_number']], 0, $codekey, substr($inslabel, 3), $reason, $debug, '', $codetype);
} else {
slPostAdjustment($arrow['id'], 0, $production_date, $out['check_number'], $codekey, $insurance_id, $reason, $debug);
}
}
writeMessageLine($bgcolor, $class, $description . ' ' . sprintf("%.2f", $adj['amount']));
} else {
if (!$error && !$debug) {
if ($INTEGRATED_AR) {
arPostAdjustment($pid, $encounter, $InsertionId[$out['check_number']], $adj['amount'], $codekey, substr($inslabel, 3), "Adjust code " . $adj['reason_code'], $debug, '', $codetype);
} else {
slPostAdjustment($arrow['id'], $adj['amount'], $production_date, $out['check_number'], $codekey, $insurance_id, "{$inslabel} adjust code " . $adj['reason_code'], $debug);
}
$invoice_total -= $adj['amount'];
}
writeDetailLine($bgcolor, $class, $patient_name, $invnumber, $codekey, $production_date, $description, 0 - $adj['amount'], $error ? '' : $invoice_total);
}
}
}
// End of service item
// Report any existing service items not mentioned in the ERA, and
// determine if any of them are still missing an insurance response
// (if so, then insurance is not yet done with the claim).
$insurance_done = true;
foreach ($codes as $code => $prev) {
// writeOldDetail($prev, $arrow['name'], $invnumber, $service_date, $code, $bgcolor);
writeOldDetail($prev, $patient_name, $invnumber, $service_date, $code, $bgcolor);
$got_response = false;
foreach ($prev['dtl'] as $ddata) {
if ($ddata['pmt'] || $ddata['rsn']) {
$got_response = true;
}
}
if (!$got_response) {
$insurance_done = false;
}
}
// Cleanup: If all is well, mark Ins<x> done and check for secondary billing.
if (!$error && !$debug && $insurance_done) {
if ($INTEGRATED_AR) {
$level_done = 0 + substr($inslabel, 3);
if ($out['crossover'] == 1) {
//Automatic forward case.So need not again bill from the billing manager screen.
sqlStatement("UPDATE form_encounter " . "SET last_level_closed = {$level_done},last_level_billed=" . $level_done . " WHERE " . "pid = '{$pid}' AND encounter = '{$encounter}'");
writeMessageLine($bgcolor, 'infdetail', 'This claim is processed by Insurance ' . $level_done . ' and automatically forwarded to Insurance ' . ($level_done + 1) . ' for processing. ');
} else {
"UPDATE form_encounter " . "SET last_level_closed = {$level_done} WHERE " . "pid = '{$pid}' AND encounter = '{$encounter}'";
}
// Check for secondary insurance.
if ($primary && arGetPayerID($pid, $service_date, 2)) {
arSetupSecondary($pid, $encounter, $debug, $out['crossover']);
if ($out['crossover'] != 1) {
writeMessageLine($bgcolor, 'infdetail', 'This claim is now re-queued for secondary paper billing');
}
}
} else {
$shipvia = 'Done: Ins1';
if ($inslabel != 'Ins1') {
$shipvia .= ',Ins2';
}
if ($inslabel == 'Ins3') {
$shipvia .= ',Ins3';
}
$query = "UPDATE ar SET shipvia = '{$shipvia}' WHERE id = " . $arrow['id'];
SLQuery($query);
if ($sl_err) {
die($sl_err);
}
// Check for secondary insurance.
$insgot = strtolower($arrow['notes']);
if ($primary && strpos($insgot, 'ins2') !== false) {
slSetupSecondary($arrow['id'], $debug);
if ($out['crossover'] != 1) {
writeMessageLine($bgcolor, 'infdetail', 'This claim is now re-queued for secondary paper billing');
}
}
}
}
}
}
function parse_date($date)
{
if (function_exists('parse_date')) {
return parse_date($date);
} else {
$split_pattern = '[\\/\\-\\.]';
if (preg_match("/(\\d{4}){$split_pattern}(\\d{1,2}){$split_pattern}(\\d{1,2})/", $date, $matches)) {
return array('year' => $matches[1], 'month' => $matches[2], 'day' => $matches[3]);
} else {
return false;
}
}
}
// set default vars
$dateArr = getdate();
// start: first of last year
// end: today
$start_time = mktime(0, 0, 0, 1, 1, $dateArr['year'] - 1);
$start_date = date('m/d/Y', $start_time);
$end_date = date('12/31/Y');
$account1_id = $_SESSION['default_summary1'];
$account2_id = $_SESSION['default_summary2'];
$net_multiplier = -1;
if (isset($_POST['calc'])) {
$date_verify = parse_date($_POST['start_date']);
if ($date_verify == -1) {
$error = 'Bad start date';
} else {
$date_verify = parse_date($_POST['end_date']);
if ($date_verify == -1) {
$error = 'Bad end date';
}
}
// refresh data
if ($error == '') {
// don't update dates unless valid
$start_date = $_POST['start_date'];
$end_date = $_POST['end_date'];
$net_multiplier = (int) $_POST['net_multiplier'];
}
$account1_id = $_POST['account1_id'];
$account2_id = $_POST['account2_id'];
}
// Add or subtract display vars
/**
* Find Nth (day) in (month) of (year)
* Return timestamp for 2 AM of user's timezone - we use this for DST, and DST usually is effective at 2?
*/
function find_day_of_month($n, $day, $month, $year)
{
global $time_zone_offset;
$times_day_found = 0;
$date_month = $month;
$date = 1;
while (($times_day_found < $n || $n == 'last') && $date_month == $month) {
$time = parse_date("{$month} {$date}, {$year}");
$date_month = date('M', $time + $time_zone_offset);
$day_found = date('D', $time + $time_zone_offset);
if ($day_found == $day) {
$times_day_found++;
}
$date++;
}
return $time;
}
?>
</a>.
</h5>
<p><?php
echo $row_bookmark['title'];
?>
</p>
<p><a href="<?php
echo $row_bookmark['url'];
?>
" target="_blank"><?php
echo $row_notes['url'];
?>
</a></p>
<p><i class="icon-time"></i> <?php
echo parse_date($row_friends_activities_query['date']);
?>
</p>
</div>
<?php
if ($_SESSION['logged'] == true) {
vote_up($row_friends_activities_query['activity_tracker'], 'bookmark', $row_friends_activities_query['profile_ida']);
}
?>
</div>
<?php
}
}
}
}
function __construct($start_str, $end_str, $log_info = NULL)
{
$this->start = parse_date($start_str, null, $log_info);
$this->end = parse_date($end_str, $this->start, $log_info);
}
function api_getCommittee_date($date) {
$db = new ParlDB;
$date = parse_date($date);
if ($date) $date = '"' . $date['iso'] . '"';
else $date = 'date(now())';
$q = $db->query("select distinct(dept) from moffice
where source = 'chgpages/selctee'
and from_date <= " . $date . ' and '
. $date . ' <= to_date');
if ($q->rows()) {
for ($i=0; $i<$q->rows(); $i++) {
$output['committees'][] = array(
'name' => $q->field($i, 'dept')
);
}
api_output($output);
} else {
api_error('No committees found');
}
}
<?php
if ($save && !$errors) {
?>
<script language="JavaScript">
<!--
window.location="<?php
echo SITE_HTTP_ROOT;
?>
organizer/day/date/<?php
echo parse_date('{Y}-{m}-{d}', $event->start_date, true);
?>
/";
//-->
</script>
<?php
} else {
$start_date = '';
$stop_date = '';
$start_time = '10:00';
$stop_time = '11:00';
if ($event->start_date != '') {
$start_date = format_date('{d}.{m}.{Y}', $event->start_date);
if ($start_date == '00.00.0000') {
$start_date = '';
}
}
if ($event->stop_date != '') {
$stop_date = format_date('{d}.{m}.{Y}', $event->stop_date);
if ($stop_date == '00.00.0000') {
//показывать время новости
$p_date = $news_conf->p_date;
//показывать дату новости
$img_height = $news_conf->img_height;
//высота для миникартинки новости
define('LIMIT_NEWS_ON_PAGE', $am_news);
if ($id > 0) {
$news = new news();
$news->news_id = $id;
$news->Load();
include SITE_FILE_ROOT . 'template/header.php';
include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '-id.php';
include SITE_FILE_ROOT . 'template/footer.php';
} else {
if ($date) {
$linedate = parse_date('{Y}-{m}-{d}', $date, true);
} else {
$linedate = date('Y-m-d', time());
}
$newses = array();
$query = 'SELECT COUNT(*) as num FROM ' . TABLE_NEWS . ' WHERE news_date = \'' . $linedate . '\' limit ' . LIMIT_NEWS_ON_PAGE;
$db->query($query);
$all_num = $db->value[0]['num'];
if ($all_num < LIMIT_NEWS_ON_PAGE) {
$query = 'SELECT * FROM ' . TABLE_NEWS . ' WHERE news_date <= \'' . $linedate . '\' ORDER BY news_id ASC limit ' . LIMIT_NEWS_ON_PAGE;
$db->query($query);
$newses = $db->value;
} else {
$query = 'SELECT * FROM ' . TABLE_NEWS . ' WHERE news_date = \'' . $linedate . '\' ORDER BY news_id ASC limit ' . LIMIT_NEWS_ON_PAGE;
$db->query($query);
$newses = $db->value;
// Our items
$items = get_items($_GET['id']);
foreach ($items as &$item) {
// The description
if (isset($item['description'])) {
if (appcast_info('format') == 'sparkledotnet' && appcast_info('formatVersion') == '0.1' || appcast_info('convertDescriptionToLink') === true) {
// Don't override if we already have a link
if (!isset($item['sparkle:releaseNotesLink'])) {
$item['sparkle:releaseNotesLink'] = curPageURL() . '&echo=' . urlencode($item['description']);
}
}
unset($item['description']);
}
// The publish date
if (isset($item['pubDate'])) {
$item['pubDate'] = parse_date($item['pubDate']);
}
// Filesize and content type
$cacheid = $item['enclosure']['_params']['url'];
if (isset($item['enclosure']['_params']['type']) && isset($item['enclosure']['_params']['length'])) {
//
} elseif (!isset($data['cache'][$cacheid])) {
$headers = get_remote_headers($item['enclosure']['_params']['url']);
$type = get_content_type($headers);
$length = get_content_length($headers);
if (!$headers) {
appcastr_die('Appcastr can\'t make a connection to <code>' . $item['enclosure']['url'] . '</code>, or the file doesn\'t exist.');
} else {
$item['enclosure']['_params']['type'] = $type;
$item['enclosure']['_params']['length'] = $length;
$data['cache'][$cacheid] = array('type' => $type, 'length' => $length);
?>
</th>
</tr>
</thead>
<tbody>
<?php
$q = 'SELECT * FROM subscribers WHERE complaint = 1 AND last_campaign = ' . mysqli_real_escape_string($mysqli, $_GET['c']) . ' ORDER BY timestamp DESC LIMIT 10';
$r = mysqli_query($mysqli, $q);
if ($r && mysqli_num_rows($r) > 0) {
while ($row = mysqli_fetch_array($r)) {
$subscriber_id = stripslashes($row['id']);
$name = stripslashes($row['name']);
$email = stripslashes($row['email']);
$listID = stripslashes($row['list']);
$timestamp = parse_date($row['timestamp'], 'short', true);
if ($name == '') {
$name = '[' . _('No name') . ']';
}
$q2 = 'SELECT name FROM lists WHERE id = ' . $listID;
$r2 = mysqli_query($mysqli, $q2);
if ($r2 && mysqli_num_rows($r2) > 0) {
while ($row = mysqli_fetch_array($r2)) {
$list_name = stripslashes($row['name']);
}
}
echo '
<tr>
<td><a href="#subscriber-info" data-id="' . $subscriber_id . '" data-toggle="modal" class="subscriber-info">' . $name . '</a></td>
<td><a href="#subscriber-info" data-id="' . $subscriber_id . '" data-toggle="modal" class="subscriber-info">' . $email . '</a></td>
foreach ($SKUs as $SKU) {
$SKUsFinal[] = "'" . $SKU . "'";
}
$s_sku = implode(",", $SKUsFinal);
$sql_where .= " AND ( oi.order_id IN ( SELECT order_id FROM va_orders_items WHERE item_code IN (" . $s_sku . ") ) )";
}
if (strlen($s_category)) {
$sql_where .= " AND ( oi.order_id IN ( SELECT order_id FROM va_orders_items WHERE item_id IN ( SELECT item_id FROM va_items_categories WHERE category_id=" . $db->tosql($s_category, INTEGER) . ") ) )";
}
//END customization
if (strlen($s_sd)) {
$s_sd_value = parse_date($s_sd, $date_edit_format, $date_errors);
$sql_where .= " AND o.order_placed_date>=" . $db->tosql($s_sd_value, DATE);
}
if (strlen($s_ed)) {
$end_date = parse_date($s_ed, $date_edit_format, $date_errors);
$day_after_end = mktime(0, 0, 0, $end_date[MONTH], $end_date[DAY] + 1, $end_date[YEAR]);
$sql_where .= " AND o.order_placed_date<" . $db->tosql($day_after_end, DATE);
}
if (strlen($s_os)) {
$sql_where .= " AND o.order_status=" . $db->tosql($s_os, INTEGER);
}
if (strlen($s_ci)) {
if ($order_info["show_delivery_country_id"] == 1) {
$sql_where .= " AND o.delivery_country_id=" . $db->tosql($s_ci, INTEGER);
} else {
if ($order_info["show_country_id"] == 1) {
$sql_where .= " AND o.country_id=" . $db->tosql($s_ci, INTEGER);
}
}
}
});
</script>
</tr>
';
}
} else {
if ($error_stack != '') {
$download_errors = ' | <a href="' . get_app_info('path') . '/includes/app/download-errors-csv.php?c=' . $id . '" title="' . _('Download CSV of emails that were not delivered to even after retrying') . '">' . $no_of_errors . ' ' . _('not delivered') . '</a>';
} else {
$download_errors = '';
}
echo '
<tr id="' . $id . '">
<td><span class="label label-success">' . _('Sent') . '</span></a> <a href="' . get_app_info('path') . '/report?i=' . get_app_info('app') . '&c=' . $id . '" title="' . _('View report for this campaign') . '">' . $title . '</a>' . $download_errors . '</td>
<td>' . number_format($recipients) . '</td>
<td>' . parse_date($sent, 'long', true) . '</td>
<td><span class="label">' . $percentage_opened . '%</span> ' . number_format($opens_unique) . ' ' . _('opened') . '</td>
<td><span class="label">' . $percentage_clicked . '%</span> ' . number_format(get_click_percentage($id)) . ' ' . _('clicked') . '</td>
<td><a href="#duplicate-modal" title="" id="duplicate-btn-' . $id . '" data-toggle="modal" data-cid="' . $id . '" class="duplicate-btn"><i class="icon icon-copy"></i></a></td>
<td><a href="javascript:void(0)" title="Delete ' . $title . '?" id="delete-btn-' . $id . '" class="delete-campaign"><i class="icon icon-trash"></i></a></td>
<script type="text/javascript">
$("#delete-btn-' . $id . '").click(function(e){
e.preventDefault();
c = confirm(\'' . _('Confirm delete') . ' ' . addslashes($title) . '?\');
if(c)
{
$.post("includes/campaigns/delete.php", { campaign_id: ' . $id . ' },
function(data) {
if(data)
{
$("#' . $id . '").fadeOut();
<?php
$id = intval(get_request_variable('id', 0));
$kio = get_request_variable('kio', '');
$kio_id = get_request_variable('kio_id', 0);
$ika_id = get_request_variable('ika_id', 0);
$exec_id = get_request_variable('exec_id', 0);
$from_id = get_request_variable('from_id', 0);
$jr_work = get_request_variable('jr_work', 2);
$jr_state = get_request_variable('jr_state', '');
$date = get_request_variable('date', '');
$date2 = get_request_variable('date2', '');
$start_time = get_request_variable('start_time', '');
$stop_time = get_request_variable('stop_time', '');
$date = parse_date('{Y}-{m}-{d}', $date, false);
$date2 = parse_date('{Y}-{m}-{d}', $date2, false);
$description = get_request_variable('description', '');
if ($id == 0) {
$jr_state = 1;
}
$save = get_request_variable('save', '');
$_REQUEST['callback'] = get_request_variable('callback', '');
$db = db_class::get_instance();
$journal = new journal();
$journal->id = $id;
if ($id > 0) {
if (!$journal->Load()) {
$journal->id = 0;
}
}
for ($i = 0; $i < count($STORAGE['menu']); $i++) {
# vim:sw=4:ts=4:et:nowrap
include_once "../../includes/easyparliament/init.php";
include_once INCLUDESPATH . "easyparliament/member.php";
include_once INCLUDESPATH . "easyparliament/glossary.php";
// From http://cvs.sourceforge.net/viewcvs.py/publicwhip/publicwhip/website/
include_once INCLUDESPATH . "postcode.inc";
if (get_http_var('s') != '' || get_http_var('pid') != '') {
if (get_http_var('pid') == 16407) {
header('Location: /search/?pid=10133');
exit;
}
// We're searching for something.
$this_page = 'search';
$searchstring = trim(get_http_var('s'));
$searchstring = filter_user_input($searchstring, 'strict');
$time = parse_date($searchstring);
if ($time['iso']) {
header('Location: /hansard/?d=' . $time['iso']);
exit;
}
$searchspeaker = trim(get_http_var('pid'));
if ($searchspeaker) {
$searchstring .= ($searchstring ? ' ' : '') . 'speaker:' . $searchspeaker;
}
$searchmajor = trim(get_http_var('section'));
if (!$searchmajor) {
// Legacy URLs used maj
$searchmajor = trim(get_http_var('maj'));
}
if ($searchmajor) {
$searchstring .= " section:" . $searchmajor;
function importTabFilePBrown()
{
//global $mysqli;
$file = NULL;
try {
$file = new SplFileObject("uploads/upload-p-brown.txt");
} catch (Exception $error) {
echo '<div class="jumbotron"><h1 class="text-danger">Unable to open uploaded file. Please try again.</h1><p>' . $error->getMessage() . '</p></div>';
return;
}
$counter = 0;
while ($line = $file->fgets()) {
if ($counter++ == 0) {
continue;
}
//discard first line because it only contains headers
$fields = explode("\t", $line);
$alternativeTitles = array($fields[1], $fields[2]);
//$parsed_date = parse_date('1765 - 1775');
$subjectHeadings = parseSubjectHeadings($fields[5]);
$parsedDate = parse_date('1765 - 1775');
//the following lines combine several fields into the notes field for solr
$notes = '';
//$fields[14]; //digitization specifications
$notes = $notes . (trim($fields[17]) != '') ? 'Scanner technician: ' . $fields[17] . ' ' : '';
$notes = $notes . (trim($fields[18]) != '') ? 'Metadata cataloguer: ' . $fields[18] . ' ' : '';
$notes = $notes . (trim($fields[19]) != '') ? 'Collection administrator: ' . $fields[19] . ' ' : '';
$notes = $notes . (trim($fields[20]) != '') ? 'Collection maintenance: ' . $fields[20] . ' ' : '';
$document = array('title' => $fields[0], 'shelfmark' => $fields[4], 'subject_heading' => $subjectHeadings, 'language' => $fields[6], 'archive' => $fields[7], 'contributing_institution' => $fields[9], 'use_permissions' => trim($fields[10]), 'type_content' => $fields[11], 'file_format' => $fields[12], 'type_digital' => $fields[13], 'description' => $fields[14], 'year_begin' => $parsedDate['year_begin'], 'month_begin' => $parsedDate['month_begin'], 'day_begin' => $parsedDate['day_begin'], 'year_end' => $parsedDate['year_end'], 'month_end' => $parsedDate['month_end'], 'day_end' => $parsedDate['day_end'], 'years' => $parsedDate['years'], 'date_digital' => $fields[15], 'geolocation_human' => $fields[21] . (trim($fields[22]) != '') ? ' - ' . $fields[22] : '', 'id' => $fields[26], 'url' => $fields[26], 'notes' => $notes);
indexDocument($document);
//$date_parsed = parse_date($date);
//$date_digital_parsed = parse_date($date_digital);
}
}
function get_criteria_clause($lhs = true, $operand = true, $rhs = true, $rhs1 = false, $rhs2 = false, $add_del = true)
{
$cls = "";
if ( $this -> _use == "SHOW/HIDE-and-GROUPBY") $add_del = false;
if ( $this->column_value == "(ALL)" )
return $cls;
if ( $this->column_value == "(NOTFOUND)" )
{
$cls = " AND 1 = 0";
return $cls;
}
if ( !$this->column_value )
{
return ($cls);
}
$del = '';
switch($this->criteria_type)
{
case "ANY":
case "ANYCHAR":
case "TEXTFIELD":
if ( $add_del )
$del = $this->get_value_delimiter();
$extract= explode(',', $this->column_value);
if ( is_array($extract) )
{
$ct = 0;
foreach ( $extract as $col )
{
if ( is_string($col) )
{
$col = trim($col);
}
if ( !$col )
continue;
if ( $col == "(ALL)" )
{
continue;
}
if ( $ct == 0 )
{
if ( $lhs )
{
//$cls .= " XX".$this->table_name.".".$this->column_name;
$cls .= " AND ".$this->column_name;
}
if ( $rhs )
{
if ( $operand )
$cls .= " IN (";
$cls .= $del.$col.$del;
}
}
else
if ( $rhs )
$cls .= ",".$del.$col.$del;
$ct++;
}
if ( $ct > 0 && $rhs )
if ( $operand )
$cls .= " )";
}
else
{
if ( $lhs )
{
if ( $this->table_name && $this->column_name )
$cls .= " AND ".$this->table_name.".".$this->column_name;
else
if ( $this->column_name )
$cls .= " AND ".$this->column_name;
}
if ( $rhs )
if ( $operand )
$cls .= " =".$del.$this->column_value.$del;
else
$cls .= $del.$this->column_value.$del;
}
break;
case "LIST":
if ( $add_del )
$del = $this->get_value_delimiter();
if ( !is_array($this->column_value) )
$this->column_value = explode(',', $this->column_value);
if ( is_array($this->column_value) )
{
$ct = 0;
foreach ( $this->column_value as $col )
{
if ( is_string($col) )
{
$col = trim($col);
}
if ( $col == "(ALL)" )
{
continue;
}
if ( $ct == 0 )
{
if ( $lhs )
{
if ( $this->table_name && $this->column_name )
$cls .= " AND ".$this->table_name.".".$this->column_name;
else
if ( $this->column_name )
$cls .= " AND ".$this->column_name;
}
if ( $rhs )
{
if ( $operand )
$cls .= " IN (";
$cls .= $del.$col.$del;
}
}
else
if ( $rhs )
$cls .= ",".$del.$col.$del;
$ct++;
}
if ( $ct > 0 )
if ( $operand )
$cls .= " )";
}
else
{
if ( $lhs )
{
if ( $this->table_name && $this->column_name )
$cls .= " AND ".$this->table_name.".".$this->column_name;
else
if ( $this->column_name )
$cls .= " AND ".$this->column_name;
}
if ( $rhs )
{
if ( $operand )
$cls .= " =".$del.$this->column_value.$del;
else
$cls .= $del.$this->column_value.$del;
}
}
break;
case "DATE":
$cls = "";
if ( $this->column_value )
{
$val1 = parse_date($this->column_value, false, SW_PREP_DATEFORMAT);
$val1 = convertYMDtoLocal($val1, SW_PREP_DATEFORMAT, SW_DB_DATEFORMAT);
if ( $lhs )
{
if ( $this->table_name && $this->column_name )
$cls .= " AND ".$this->table_name.".".$this->column_name;
else
if ( $this->column_name )
$cls .= " AND ".$this->column_name;
}
if ( $add_del )
$del = $this->get_value_delimiter();
if ( $rhs )
{
if ( $operand )
$cls .= " = ";
$cls .= $del.$val1.$del;
}
}
break;
case "DATERANGE":
$cls = "";
if ( $this->column_value )
{
// If daterange value here is a range in a single value then its been
// run directly from command line and needs splitting up using "-"
$val1 = parse_date($this->column_value,false, SW_PREP_DATEFORMAT);
$val2 = parse_date($this->column_value2,false, SW_PREP_DATEFORMAT);
$val1 = convertYMDtoLocal($val1, SW_PREP_DATEFORMAT, SW_DB_DATEFORMAT);
$val2 = convertYMDtoLocal($val2, SW_PREP_DATEFORMAT, SW_DB_DATEFORMAT);
if ( $lhs )
{
if ( $this->table_name && $this->column_name )
$cls .= " AND ".$this->table_name.".".$this->column_name;
else
if ( $this->column_name )
$cls .= " AND ".$this->column_name;
}
if ( $add_del )
$del = $this->get_value_delimiter();
if ( $rhs )
{
$cls .= " BETWEEN ";
//$cls .= $del.$this->column_value.$del;
$cls .= $del.$val1.$del;
$cls .= " AND ";
//$cls .= $del.$this->column_value2.$del;
$cls .= $del.$val2.$del;
}
if ( $rhs1 )
{
$cls = $del.$val1.$del;
}
if ( $rhs2 )
{
$cls = $del.$val2.$del;
}
}
break;
case "LOOKUP":
if ( $add_del )
$del = $this->get_value_delimiter();
if ( !is_array($this->column_value) )
$this->column_value = explode(',', $this->column_value);
if ( is_array($this->column_value) )
{
$ct = 0;
foreach ( $this->column_value as $col )
{
if ( is_string($col) )
{
$col = trim($col);
}
if ( $col == "(ALL)" )
{
continue;
}
if ( $ct == 0 )
{
if ( $lhs )
{
if ( $this->table_name && $this->column_name )
$cls .= " AND ".$this->table_name.".".$this->column_name;
else
if ( $this->column_name )
$cls .= " AND ".$this->column_name;
}
if ( $rhs )
{
if ( $operand )
$cls .= " IN (";
$cls .= $del.$col.$del;
}
}
else
if ( $rhs )
$cls .= ",".$del.$col.$del;
$ct++;
}
if ( $ct > 0 )
if ( $operand )
$cls .= " )";
}
else
{
if ( $lhs )
{
if ( $this->table_name && $this->column_name )
$cls .= " AND ".$this->table_name.".".$this->column_name;
else
if ( $this->column_name )
$cls .= " AND ".$this->column_name;
}
if ( $rhs )
{
if ( $operand )
$cls .= " =".$del.$this->column_value.$del;
else
$cls .= $del.$this->column_value.$del;
}
}
break;
default:
break;
}
return($cls);
}
<?php
require_once 'Request.php';
require_once 'check_cookie.php';
require_once 'show_list.php';
if (check_cookie($_SERVER['PHP_SELF'], null)) {
if (!empty($_POST)) {
$req = new Request();
$req->uid = $_COOKIE['uid'];
$req->name = $_POST['name'];
// Remove '-' from phone number.
$req->phone = str_replace('-', '', $_POST['phone']);
$req->description = $_POST['description'];
// Force date into correct format.
$req->deadline = parse_date($_POST);
$req->insert();
header('Location: index.php?conf=true');
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Job Request Form</title>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="jquery-1.7.min.js"></script>
<script type="text/javascript" src="validator.js"></script>
<script type="text/javascript" src="validate_request.js"></script>
</head>
<body onload="loadEventHandlers();">
<?php
if (!trim($stop_date)) {
$stop_date = $start_date;
}
$event->stop_date = parse_date('{Y}-{m}-{d}', $stop_date, false);
$wholeday = get_request_variable('wholeday', '');
if ($wholeday) {
$event->start_time = null;
$event->stop_time = null;
} else {
$start_time = get_request_variable('start_time', date('H:i'));
$event->start_time = parse_time('{H}:{i}', $start_time);
$stop_time = get_request_variable('stop_time', date('H:i'));
$event->stop_time = parse_time('{H}:{i}', $stop_time);
}
$errors = $event->IsValidData();
if (count($errors) == 0) {
$event->start_date = parse_date('{Y}-{m}-{d}', $start_date, true);
$event->stop_date = parse_date('{Y}-{m}-{d}', $stop_date, true);
$db->begin();
$event->Save();
$db->commit();
}
}
if ($event->id_event == 0) {
$event->start_date = $start_date;
$event->stop_date = $stop_date;
}
$wholeday = $event->start_time == '';
include SITE_FILE_ROOT . 'template/header.php';
include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php';
include SITE_FILE_ROOT . 'template/footer.php';
<div class="row write-header">
<div class="large-8 large-centered columns">
<h2>Which Lord would you like to write to?</h2>
</div>
</div>
<div class="row">
<div class="large-12 columns">
<?php
// Date of birth
if ($date = get_http_var('d')) {
$date = parse_date($date);
if (isset($date['epoch'])) {
$f = file('../phplib/DoBsP.bsv');
$matches = array();
foreach ($f as $r) {
list($id, $dob) = explode('|', $r);
$dob = preg_replace('# \\d+$#', '', $dob);
if (!$dob) {
continue;
}
$d = strtotime($dob);
if (date('d/m', $date['epoch']) == date('d/m', strtotime($dob))) {
$ids = dadem_get_same_person('uk.org.publicwhip/person/' . $id);
if (dadem_get_error($ids)) {
continue;
}
