function set_active_state($vermutung_id, $new_state)
{
$connection = get_db_connection();
$update_query = sprintf("UPDATE vermutung SET active = '%s' WHERE id = '%s'", mysql_real_escape_string($new_state), mysql_real_escape_string($vermutung_id));
$result = mysql_query($update_query);
mysql_close($connection);
return $result;
}
function exec_query($sql)
{
static $conn = null;
if ($conn == null) {
$conn = get_db_connection();
}
if (mysql_query($sql, $conn) === FALSE) {
error_out(500, "MySQL Error: " . mysql_error($conn) . "; running query: {$sql}");
}
}
function users_getById($id)
{
$db = get_db_connection();
$tmp = $db->query("SELECT * from users WHERE id = {$id}");
if ($tmp->num_rows != 0) {
$user = $tmp->fetch_assoc();
} else {
$user = false;
}
return $user;
}
function list_all_hackers()
{
$db = get_db_connection();
$hackers = $db->select('parameter_tampering', '*');
$output = "<pre><table>";
foreach ($hackers as $hacker) {
$output .= "<tr><td>" . $hacker["id"] . ". " . $hacker["name"] . " booked " . $hacker["number_of_tickets"] . " and paid " . $hacker["amount"] . "\$ . (Email: " . $hacker["email"] . " ) </td></tr>";
}
$output .= "</table></pre>";
return $output;
}
function photos_getByUser($id)
{
$db = get_db_connection();
$tmp = $db->query("SELECT * FROM photo WHERE user_id = {$id}");
if ($tmp->num_rows != 0) {
while ($row = $tmp->fetch_assoc()) {
$photo[] = $row;
}
} else {
$photo = [];
}
return $photo;
}
function albums_getById($id)
{
$db = get_db_connection();
if (is_null($id)) {
return false;
}
$tmp = $db->query("SELECT * FROM albums WHERE id = {$id}");
if ($tmp->num_rows != 0) {
$a = $tmp->fetch_assoc();
} else {
$a = false;
}
return $a;
}
function getProjectsByTech($techID)
{
try {
$db = get_db_connection();
$stmt = $db->prepare("SELECT projects.* FROM projects\n JOIN site_techs ON projects.project_id = site_techs.project_id\n JOIN techniques ON site_techs.tech_id = techniques.tech_id\n WHERE techniques.tech_id = ?;");
$stmt->bindParam(1, $techID, PDO::PARAM_INT);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$this->name[] = $row['name'];
$this->url[] = $row['url'];
$this->github[] = $row['github'];
$this->projectID[] = $row['project_id'];
$this->imagePath[] = $row['image_url'];
}
} catch (Exception $e) {
echo "Fehler beim Verbinden zur Datenbank";
}
}
/**
* Will attempt to save the current record
* An INSERT will be performed if the primary key for $this is not already populated
* An UPDATE will be performed otherwise
* Various options will be available within the function --> still under construction(sanitize,quote,includeEmpties,includeNulls)
* @param string/array $listOfFields --> determines which fields are to be saved (single fieldname string or indexed array of fieldnames)
* @return bool
*/
public function save($listOfFields = "*")
{
//If user passes *, then we'll attempt to save all columns (except for the primary key) to the database
if ($listOfFields == '*') {
$listOfFields = $this->allFieldsWithoutKeys;
} elseif (!is_array($listOfFields)) {
$listOfFields = array((string) $listOfFields);
}
$db = get_db_connection();
//Create an assoc array of all the values we're about to save
$nameValuePairs = $this->GetFieldsAsAssocArray($listOfFields);
$field_values = array_values($nameValuePairs);
$field_names = array_keys($nameValuePairs);
array_unshift($field_values, $this->GetBoundParamTypeString($field_names));
if (empty($this->test_pk)) {
//INSERT new record when this class's primary key property is empty
$sql = 'INSERT INTO `test`' . ' (`' . implode('`, `', $field_names) . '`)' . ' VALUES (' . str_repeat('?,', count($field_names) - 1) . '?) ';
$rs = $db->query($sql, null, null, $field_values);
if ($rs) {
$this->test_pk = $db->insertID();
return true;
} else {
return false;
}
} else {
//UPDATE existing record based on this class's primary key
$field_values[0] = $field_values[0] . $this->GetBoundParamTypeString(array('test_pk'));
$sql = 'UPDATE `test` SET ' . '`' . implode('`=?, `', $field_names) . '`=? ' . ' WHERE `test_pk` = ?';
$field_values[] = $this->test_pk;
$rs = $db->query($sql, null, null, $field_values);
if ($rs) {
$this->test_pk = $db->insertID();
return true;
} else {
return false;
}
}
}
function &default_context($make_session)
{
/*
Argument is a boolean value that tells the function whether to make a
session or not.
*/
$db =& get_db_connection();
/* change character set to utf8 */
$db->query("SET NAMES utf8mb4");
//$db->query("SET CHARACTER SET 'utf8'");
$user = null;
$type = get_preferred_type($_GET['type'] ? $_GET['type'] : $_SERVER['HTTP_ACCEPT']);
if ($type == 'text/html' && $make_session) {
// get the session user if there is one
session_set_cookie_params(86400 * 31, get_base_dir(), null, false, true);
session_start();
$user = cookied_user($db);
}
// Smarty is created last because it needs $_SESSION populated
$sm =& get_smarty_instance($user);
$ctx = new Context($db, $sm, $user, $type);
return $ctx;
}
<?php
require_once '../admin/config.php';
function get_db_connection()
{
$db = new pdo(DB_DRIVER . ":dbname=" . DB_NAME . ";charset=utf8;host=" . DB_HOST, DB_USER, DB_PASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $db;
}
function __autoload($class)
{
require '../classes/class.' . $class . '.php';
}
$techID = $_POST['techID'];
try {
$db = get_db_connection();
$stmt = $db->prepare("SELECT projects.* FROM projects\n JOIN site_techs ON projects.project_id = site_techs.project_id\n JOIN techniques ON site_techs.tech_id = techniques.tech_id\n WHERE techniques.tech_id = ?;");
$stmt->bindParam(1, $techID, PDO::PARAM_INT);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$name[] = $row['name'];
$url[] = $row['url'];
$github[] = $row['github'];
$projectID[] = $row['project_id'];
$imagePath[] = $row['image_url'];
}
} catch (Exception $e) {
echo "Fehler beim Verbinden zur Datenbank";
}
$countTechs = count($name);
echo "Anzahl: {$countTechs}<br>";
<?php
ini_set('include_path', ini_get('include_path') . PATH_SEPARATOR . '../lib');
require_once 'init.php';
require_once 'data.php';
require_once 'output.php';
list($response_format, $response_mime_type) = parse_format($_GET['format'], 'html');
$dbh =& get_db_connection();
if (get_request_user()) {
// auth stuff here
}
$dbh = null;
$sm = get_smarty_instance();
if (get_request_user()) {
// secure template vars here
}
header("Content-Type: {$response_mime_type}; charset=UTF-8");
print $sm->fetch("index.{$response_format}.tpl");
// already URL encoded
$location = $_POST['location'];
// user friendly display name of user location
if ($location != "") {
$location = urlencode($location);
$place_name = urldecode($location);
// geocode
try {
$location_XML = yahoo_geo($_REQUEST['location']);
$location = $location_XML['Latitude'] . "," . $location_XML['Longitude'];
$location_latitude = $location_XML['Latitude'];
$location_longitude = $location_XML['Longitude'];
// get event number
$event_index = $_POST['event_index'];
if ($event_index > 0) {
$conn = get_db_connection($db_user, $db_passwd, $db_name);
$event_label = $event_index;
$latitudes[$event_index] = $location_latitude;
$longitudes[$event_index] = $location_longitude;
$sql_result = save_vote($location_latitude, $location_longitude, $event_label);
//
$db_status_close = close_db_connection($conn);
} else {
$event_label = "";
}
//
$map_click_X = $_POST['map_x'];
$map_click_Y = $_POST['map_y'];
} catch (exception $e) {
$location_latitude = 0;
$location_longitude = 0;
<?php
require 'db.php';
$conn = get_db_connection();
if ($conn === false) {
?>
<h1>Error connecting to database</h1>
<?php
die;
}
/* GET READY */
/* PUT YOUR CODE HERE */
?>
<form method="post">
<textarea name="content"></textarea>
<input type="text" name="author" placeholder="Your Name" />
<button type="submit">Submit Post</button>
</form>
function createFormElements($report_elements)
{
global $bDebug;
if (!is_array($report_elements)) {
return;
}
unset($form_elements);
foreach ($report_elements as $key => $value) {
$elemName = $key;
$elemLabel = $value["label"];
$elemType = $value["type"];
//$arr_params = Array("dbLink"=>get_db_connection(), "bDebug"=>$bDebug );
$arr_params = get_db_connection();
$elemValuesFunction = $value["values_func"];
if ($elemValuesFunction != NULL) {
$elemValues = @call_user_func_array($elemValuesFunction, $arr_params);
//log_err("elemValuesFunction : $elemValuesFunction");
} else {
$elemValues = $value["values"];
}
$elemDefault = $value["default"];
$elemRequired = $value["required"];
switch ($elemType) {
case "date":
$strControl = createDateControl("document._FRM", $elemName, $elemDefault, $elemRequired);
break;
case "select":
$strControl = createSelect($elemName, $elemValues, $elemDefault, $script, $class_style);
break;
case "multiselect":
$strControl = createMultipleSelect($elemName, $elemValues, $elemDefault, $script, $class_style);
break;
case "input":
$strControl = createTextField($elemName, $elemValues, $elemLabel, $class);
break;
case "checkbox":
$strControl = createCheckBox($elemName, $elemValues, $elemLabel, $elemDefault);
break;
default:
$strControl = "cant create control, elem type {$elemType} undefined.";
break;
}
$form_elements[] = array("label" => $elemLabel, "required" => $elemRequired, "control" => $strControl);
}
return $form_elements;
}
function get_database($dbname)
{
$conn = get_db_connection();
return $conn->{$dbname};
}
/**
* Will attempt to save the current record. Can throw exceptions, so please try() your save()
* An INSERT will be performed if the primary key for $this is not already populated
* An UPDATE will be performed otherwise
* Various options will be available within the function --> still under construction(ie. sanitize,quote,includeEmpties,includeNulls)
* @param string/array $listOfFields --> determines which fields are to be saved (single fieldname string or indexed array of fieldnames)
* @return bool
*/
public function save($listOfFields = "*")
{
//If user passes *, then we'll attempt to save all columns (except for the primary key(s)) to the database
if ($listOfFields == '*') {
$listOfFields = $this->GetListOfFields();
} elseif (!is_array($listOfFields)) {
$listOfFields = array((string) $listOfFields);
//In the event that only a fieldname was passed as a parameter (instead of an array), then we'll turn it into an array so we can continue anyway
}
$db = get_db_connection();
//Create an assoc array of all the values we're about to save
$nameValuePairs = $this->GetFieldsAsAssocArray($listOfFields);
//Will remove the fields that are supposed to be excluded, and will even sanitize the data.
$field_values = array_values($nameValuePairs);
$field_names = array_keys($nameValuePairs);
if (DB_DRIVER == 'mysql') {
array_unshift($field_values, $this->GetBoundParamTypeString($field_names));
}
$primaryKeyData = array();
foreach ($this->PRIMARYKEY as $fieldName) {
$primaryKeyData[$fieldName] = $this->{$fieldName};
}
$pkValues = array_values($primaryKeyData);
$autoIncrementFieldName = $this->AUTOINCREMENT[0];
$boolAllPrimaryKeysHaveValues = count(array_filter($primaryKeyData)) == count($this->PRIMARYKEY);
$boolNoPrimaryKeysHaveValues = count(array_filter($primaryKeyData)) == 0;
if (!$boolAllPrimaryKeysHaveValues && !$boolNoPrimaryKeysHaveValues) {
throw new Exception('Not all primary keys have a value in "this" object. Not sure if INSERT or UPDATE is required, and so program was aborted.');
}
$field_esc_pre = $this::CHAR_ESCAPE_FIELD_NAME_PRE;
$field_esc_post = $this::CHAR_ESCAPE_FIELD_NAME_POST;
if ($boolNoPrimaryKeysHaveValues) {
//INSERT new record when this class's primary key property is empty
$sql = "INSERT INTO {$field_esc_pre}{$this->TABLENAME}{$field_esc_post}" . " ({$field_esc_pre}" . implode("{$field_esc_post}, {$field_esc_pre}", $field_names) . "{$field_esc_post})" . ' VALUES (' . str_repeat('?,', count($field_names) - 1) . '?) ';
//file_put_contents('c:/temp/phplog.txt',$sql);
$rs = $db->query($sql, null, null, $field_values);
if ($rs) {
$this->{$autoIncrementFieldName} = $db->insertID();
return true;
} else {
return false;
}
} else {
$where = 'WHERE ' . implode('=? AND ', $primaryKeyData) . ' = ?';
//UPDATE existing record based on this class's primary key
$sql = "UPDATE {$field_esc_pre}{$this->TABLENAME}{$field_esc_post} SET " . "{$field_esc_pre}" . implode("{$field_esc_post}=?, {$field_esc_pre}", $field_names) . "{$field_esc_post}=? " . " {$where}";
if (DB_DRIVER == 'mysql') {
$field_values[0] = $field_values[0] . $this->GetBoundParamTypeString($this->PRIMARYKEY);
}
//Since we're about to add PRIMARYKEY's values ($pkValues), we'll need to append their 'iissdd'
$field_values = array_merge($field_values, $pkValues);
$rs = $db->query($sql, null, null, $field_values);
if ($rs) {
if (count($this->{$autoIncrementFieldName})) {
//If an auto-incrementing field exists in this table
$this->{$autoIncrementFieldName} = $db->insertID();
//Then set it equal to the newly generated ID
}
return true;
} else {
return false;
}
}
}
<?php
error_reporting(E_ALL);
session_start();
define('WEB', "http://localhost/photoAlbum/");
define('UPLOAD', WEB . 'files/');
define('INC', WEB . 'inc/');
define('ROOT', realpath(dirname(__FILE__)) . '/');
define('APP', ROOT . 'app/');
define('MODELS', ROOT . 'models/');
define('CONTROLLERS', ROOT . 'controllers/');
define('VIEWS', ROOT . 'views/');
require APP . "db.php";
get_db_connection()->query("set names UTF-8");
$queryString = $_SERVER['REQUEST_URI'];
$qmPos = strpos($queryString, '?');
if ($qmPos != 0) {
$queryString = substr($queryString, 0, $qmPos);
}
$tmp = explode('/', $queryString);
$tmp = array_filter($tmp);
array_shift($tmp);
$queryString = implode('/', $tmp);
switch (true) {
case empty($queryString):
$controller = 'index';
$action = 'index';
$params = array();
break;
case preg_match('/^photos\\/(\\d+)$/', $queryString, $matches):
$controller = 'photos';
<?php
require_once "lib/ebpls.lib.php";
require_once "lib/ebpls.utils.php";
require_once "ebpls-php-lib/utils/ebpls.search.funcs.php";
//require_once("includes/eBPLS_header.php");
//--- get connection from DB
$dbLink = get_db_connection();
?>
<?php
echo date("F dS Y h:i:s A");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<title>MATERLIST OF PROFESSIONAL TAX</title>
<meta name="Author" content=" Pagoda, Ltd. ">
<link href="includes/eBPLS.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="includes/eBPLS.js"></script>
</head>
<body>
<?php
$result = mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
$resulta = mysql_fetch_row($result);
?>
function get_dm_db_connection()
{
global $DB_CONFIGS;
return get_db_connection($DB_CONFIGS['DM_DB_CREDS']);
}
function print_ctc_form($type, $form_elem_values)
{
$dbLink = get_db_connection();
$is_ctc_renew = false;
$ctcDebug = false;
$is_ctc_renew = true;
$clsCTC = new EBPLSCTC($dbLink, $ctcDebug);
if ($type == "") {
$type = CTC_TYPE_INDIVIDUAL;
}
//--- make a script that will calculate the tax
//$ctc_additional_tax1_due=((int)($ctc_addtional_tax1)/1000));
$tax_a1_fields = array("in" => array("document._FRM.ctc_additional_tax1"), "out" => "document._FRM.ctc_additional_tax1_due");
$tax_a2_fields = array("in" => array("document._FRM.ctc_additional_tax2"), "out" => "document._FRM.ctc_additional_tax2_due");
if ($type == CTC_TYPE_INDIVIDUAL) {
$tax_a3_fields = array("in" => array("document._FRM.ctc_additional_tax3"), "out" => "document._FRM.ctc_additional_tax3_due");
$basic_tax_field = array("in" => array('document._FRM.ctc_tax_exempted'), "out" => 'document._FRM.ctc_basic_tax');
$out_total_interest_due = array("in" => array("x1" => 'document._FRM.current_month', "x2" => 'document._FRM.ctc_total_amount_due'), "out" => 'document._FRM.ctc_total_interest_due');
$out_total_amount_due = array("in" => array("x1" => 'document._FRM.ctc_basic_tax', "x2" => 'document._FRM.ctc_additional_tax1_due', "x3" => 'document._FRM.ctc_additional_tax2_due', "x4" => 'document._FRM.ctc_additional_tax3_due'), "out" => 'document._FRM.ctc_total_amount_due');
$out_total_paid_due = array("in" => array("x1" => 'document._FRM.ctc_total_amount_due', "x2" => 'document._FRM.ctc_total_interest_due'), "out" => 'document._FRM.ctc_total_paid');
} else {
$basic_tax_field = array("in" => NULL, "out" => 'document._FRM.ctc_basic_tax');
$out_total_interest_due = array("in" => array("x1" => 'document._FRM.current_month', "x2" => 'document._FRM.ctc_total_amount_due'), "out" => 'document._FRM.ctc_total_interest_due');
$out_total_amount_due = array("in" => array("x1" => 'document._FRM.ctc_basic_tax', "x2" => 'document._FRM.ctc_additional_tax1_due', "x3" => 'document._FRM.ctc_additional_tax2_due'), "out" => 'document._FRM.ctc_total_amount_due');
$out_total_paid_due = array("in" => array("x1" => 'document._FRM.ctc_total_amount_due', "x2" => 'document._FRM.ctc_total_interest_due'), "out" => 'document._FRM.ctc_total_paid');
}
?>
<P><BR>
<script language=Javascript>
function checkCitizenship() {
if ( document._FRM.ctc_citizenship.selectedIndex > 1 ) {
document._FRM.ctc_icr_no.disabled = false;
} else {
document._FRM.ctc_icr_no.disabled = true;
document._FRM.ctc_icr_no.value = '';
}
}
//--- start CTC application page scripts
function validate_ctc_form_application()
{
var _FRM = document._FRM
var msgTitle = "Community Tax Certificate Application\n";
if ( _FRM.ctc_type.value == 'INDIVIDUAL' ) {
if( isBlank(_FRM.ctc_last_name.value) == true)
{
alert( msgTitle + "Please input a valid lastname!");
_FRM.ctc_last_name.focus();
return false;
}
if( isBlank(_FRM.ctc_first_name.value) == true)
{
alert( msgTitle + "Please input a valid firstname!");
_FRM.ctc_first_name.focus();
return false;
}
if( isBlank(_FRM.ctc_middle_name.value) == true)
{
alert( msgTitle + "Please input a valid middlename!");
_FRM.ctc_middle_name.focus();
return false;
}
if( isBlank(_FRM.ctc_address.value) == true)
{
alert( msgTitle + "Please input a valid address!");
_FRM.ctc_address.focus();
return false;
}
if( _FRM.ctc_gender.selectedIndex == 0 )
{
alert( msgTitle + "Please input a valid gender!");
_FRM.ctc_gender.focus();
return false;
}
if( _FRM.ctc_citizenship.selectedIndex == 0 )
{
alert( msgTitle + "Please input a valid citizenship!");
_FRM.ctc_citizenship.focus();
return false;
}
if( _FRM.ctc_citizenship.item(_FRM.ctc_citizenship.selectedIndex).value != 'FILIPINO' && _FRM.ctc_icr_no.value == '' )
{
alert( msgTitle + "Please input a valid ICR No.!");
_FRM.ctc_icr_no.focus();
return false;
}
if( isBlank(_FRM.ctc_place_of_birth.value) == true)
{
alert( msgTitle + "Please input a valid place of birth!");
_FRM.ctc_place_of_birth.focus();
return false;
}
if( _FRM.ctc_civil_status.selectedIndex == 0 )
{
alert( msgTitle + "Please input a valid Civil Status!");
_FRM.ctc_civil_status.focus();
return false;
}
if( _FRM.ctc_birth_date.value == '' )
{
alert( msgTitle + "Please input a valid birthdate!");
_FRM.ctc_birth_date_month.focus();
return false;
}
//alert(_FRM.ctc_birth_date.value);
if( isBlank(_FRM.ctc_additional_tax1.value) == true && isBlank(_FRM.ctc_additional_tax2.value) == true && isBlank(_FRM.ctc_additional_tax3.value) == true )
{
alert( msgTitle + "Please input a valid last gross!");
_FRM.ctc_additional_tax1.focus();
return false;
}
if( !isDigit(_FRM.ctc_additional_tax1.value) || !isDigit(_FRM.ctc_additional_tax2.value) && !isDigit(_FRM.ctc_additional_tax3.value) )
{
alert( msgTitle + "Please input a valid last gross!");
_FRM.ctc_additional_tax1.focus();
return false;
}
/*
if( !parseInt(_FRM.ctc_additional_tax1.value) && !parseInt(_FRM.ctc_additional_tax2.value) && !parseInt(_FRM.ctc_additional_tax3.value) )
{
alert( msgTitle + "Please input a valid last gross!");
_FRM.ctc_additional_tax1.focus();
return false;
}
*/
if ( isBlank(_FRM.ctc_additional_tax1.value) ) {
_FRM.ctc_additional_tax1.value = 0.0;
}
if ( isBlank(_FRM.ctc_additional_tax2.value) ) {
_FRM.ctc_additional_tax2.value = 0.0;
}
if ( isBlank(_FRM.ctc_additional_tax3.value) ) {
_FRM.ctc_additional_tax3.value = 0.0;
}
} else if ( _FRM.ctc_type.value = 'BUSINESS' ) {
if( isBlank(_FRM.ctc_company.value) == true)
{
alert( msgTitle + "Please input a valid Company name!");
_FRM.ctc_company.focus();
return false;
}
if( isBlank(_FRM.ctc_tin_no.value) == true)
{
alert( msgTitle + "Please input a valid Company Tin No.!");
_FRM.ctc_tin_no.focus();
return false;
}
if( isBlank(_FRM.ctc_company_address.value) == true)
{
alert( msgTitle + "Please input a valid Company Addres!");
_FRM.ctc_company_address.focus();
return false;
}
if( _FRM.ctc_organization_type.selectedIndex == 0 )
{
alert( msgTitle + "Please input a valid Oraganization Type!");
_FRM.ctc_organization_type.focus();
return false;
}
if( _FRM.ctc_place_of_incorporation.value == '' )
{
alert( msgTitle + "Please input a valid place Of incorporation!");
_FRM.ctc_place_of_incorporation.focus();
return false;
}
if( _FRM.ctc_incorporation_date.value == '' )
{
alert( msgTitle + "Please input a valid Incorporation Date!");
_FRM.ctc_incorporation_date_month.focus();
return false;
}
if( isBlank(_FRM.ctc_business_nature.value) == true)
{
alert( msgTitle + "Please input a valid Business nature!");
_FRM.ctc_business_nature.focus();
return false;
}
if( isBlank(_FRM.ctc_additional_tax1.value) == true && isBlank(_FRM.ctc_additional_tax2.value) == true )
{
alert( msgTitle + "Please input a valid last gross!");
_FRM.ctc_additional_tax1.focus();
return false;
}
// check if nonzero
/*
if( !parseInt(_FRM.ctc_additional_tax1.value) && !parseInt(_FRM.ctc_additional_tax2.value) )
{
alert( msgTitle + "Please input a valid last gross!");
_FRM.ctc_additional_tax1.focus();
return false;
}
*/
// check if a digit
if( !isDigit(_FRM.ctc_additional_tax1.value) || !isDigit(_FRM.ctc_additional_tax2.value) )
{
alert( msgTitle + "Please input a valid last gross!");
_FRM.ctc_additional_tax1.focus();
return false;
}
if ( isBlank(_FRM.ctc_additional_tax1.value) ) {
_FRM.ctc_additional_tax1.value = 0.0;
}
if ( isBlank(_FRM.ctc_additional_tax2.value) ) {
_FRM.ctc_additional_tax2.value = 0.0;
}
} else {
alert('System Error : Invalid CTC Type ' + _FRM.ctc_type.value );
}
return true;
}
</script>
<form name="_FRM" method="POST" action="index.php?part=4&itemID_=101&class_type=CTC&busItem=CTC" onSubmit="return validate_ctc_form_application();">
<!--<form name="_FRM" method="POST" action="<?php
echo getURI(eBPLS_PAGE_CTC_CRITERIA);
?>
" onSubmit="return validate_ctc_form_application();">-->
<input type=hidden name="ctc_type" value="<?php
echo $ctc_type;
?>
">
<input type=hidden name="ctc_place_issued" value="<?php
echo get_ctc_place_issued();
?>
">
<input type=hidden name="cmd" value="<?php
echo CTC_CMD_PROCESS;
?>
">
<input type=hidden name="current_month" value="<?php
echo date("m");
?>
">
<?php
if ($type == CTC_TYPE_INDIVIDUAL) {
echo "<input type=hidden name=\"ctc_owner_id\" value=\"" . $form_elem_values["ctc_owner_id"] . "\">";
process_form_template("templates/form_ctc_individual_application.html", $form_elem_values);
} else {
echo "<input type=hidden name=\"ctc_business_id\" value=\"" . $form_elem_values["ctc_business_id"] . "\">";
process_form_template("templates/form_ctc_business_application.html", $form_elem_values);
}
?>
<P align=center>
<?php
/*
if ( $type == CTC_TYPE_INDIVIDUAL ) {
echo "<input type=button value=\"Search Owner\" onClick=\"javascript:showSearchForm('OWNER');\">";
}else{
echo "<input type=button value=\"Search Business\" onClick=\"javascript:showSearchForm('BUSINESS');\">";
}
*/
?>
<input type=submit value="Process Payment"> <input type=reset value="Clear">
</p>
</form>
<script language="Javascript">
function showSearchForm( val ) {
if ( val == 'OWNER' ) {
popwin('owner_search.php','_OWNER_SEARCH');
} else if ( val == 'BUSINESS' ) {
popwin('business_search.php','_BUSINESS_SEARCH');
} else {
alert('invalid ctc search param');
}
}
</script>
<?php
$clsCTC->printIndividualCTCScript($type, $basic_tax_field, $tax_a1_fields, $tax_a2_fields, $tax_a3_fields, $out_total_amount_due, $out_total_interest_due, $out_total_paid_due);
}
/**
* @param $primary_key string - column name you wish to count
* @param $from string - table(s) name(s) used for the from statement
* @param $join string - any join statement needed
* @param $where string - where if you need to customize the stmt
* @param $distinct boolean - determines if you want to count the number of distinct values of the primary key
* @return int - returns filtered total number of rows for the sql (added where statement)
* @throws CoreDBException
* @author David Leonard
*/
public function getTableListFilteredTotal($primary_key, $from, $join = "", $addWhere = "", $distinct = true)
{
$where = "";
if ($addWhere == "") {
if ($this->search != "") {
$where = ' AND ' . $this->search;
}
} else {
$where = $addWhere;
if ($this->search != "") {
$where .= ' AND (' . $this->search . ') ';
}
}
$db = get_db_connection();
if ($distinct) {
$sql = 'SELECT COUNT(DISTINCT ' . $primary_key . ') AS count FROM ' . $from . ' ' . $join . ' WHERE 1=1 ' . $where;
} else {
$sql = 'SELECT COUNT(' . $primary_key . ') AS count FROM ' . $from . ' ' . $join . ' WHERE 1=1 ' . $where;
}
$rs = $db->query($sql);
if ($rs) {
$row = $rs->fetch(CoreDB::FETCH_ASSOC);
return $row['count'];
} else {
return 0;
}
}
$g_debug_level = WARN;
// set the default logging level
// Set up some global variables for event data.
$g_event_keys = array('bounce' => array('smtp-id', 'reason', 'status', 'type'), 'click' => array('useragent', 'url', 'url_offset'), 'deferred' => array('smtp-id', 'attempt', 'response'), 'delivered' => array('smtp-id', 'response'), 'dropped' => array('smtp-id', 'reason'), 'open' => array('useragent'), 'processed' => array('smtp-id'), 'spamreport' => array('useragent'), 'unsubscribe' => array('useragent'));
$g_basic_keys = array('event', 'email', 'category', 'timestamp', 'sg_event_id', 'sg_message_id', 'ip', 'tls', 'cert_err');
$g_unique_keys = array('mailing_id', 'job_id', 'is_test', 'queue_id', 'instance', 'install_class', 'servername');
// Load up the configuration.
$config_path = realpath(dirname(__FILE__) . '/../config.ini');
$config = load_config($config_path);
if ($config === false) {
reply_and_exit(HTTP_SRVERR);
}
// Set up the debug log level and log file, and open db connection.
$g_debug_level = get_debug_level($config);
$g_log_file = get_log_file($config);
$dbcon = get_db_connection($config);
if ($dbcon === false) {
reply_and_exit(HTTP_SRVERR);
}
if (isset($_SERVER['CONTENT_TYPE']) && strpos($_SERVER['CONTENT_TYPE'], 'application/json') !== false) {
//Process the batched data, separated json objects by new lines
$jsonData = file_get_contents("php://input");
log_(DEBUG, "Incoming JSON data: {$jsonData}");
$batchData = json_decode($jsonData, true);
if ($batchData) {
log_(INFO, "Processing batch of " . count($batchData) . " event record(s)");
foreach ($batchData as $eventData) {
$http_status = create_event($config, $eventData, $dbcon);
if ($http_status == HTTP_SRVERR) {
break;
}
