public function getAverageSalary()
{
// I am using javascript to validate on the client side, but I am validating on the server side too just in case
if (empty($_GET["name"])) {
echo "Search string is required";
return false;
} else {
$name = test_input(cleanGet($_GET));
//echo $name;
//exit;
//$name = test_input($_GET["name"]);
if (preg_match("/^[a-zA-Z ]*\$/", $name)) {
echo "The search string is O.K. Look here for the results <br>";
//exit;
} else {
echo "Model1.php says Only letters and white space allowed";
exit;
}
}
// again, I could have used curl to get the JSON data, but just keeping it simple
$this->response = file_get_contents('https://data.cityofboston.gov/resource/4swk-wcg8.json');
$this->response = json_decode($this->response);
// now, this just loops through the returned object
foreach ($this->response as $num => &$values) {
// gets the object properties
$thevals = get_object_vars($values);
// assign property values to variables
$searchstring = $name;
$mystring1 = $thevals['title'];
$mystring2 = $thevals['title'];
$pos1 = stripos($mystring2, $searchstring);
// Note our use of ===. Simply == would not work as expected
// because the positional issues of the 0th (first) character per api documentation.
if ($pos1 !== false) {
echo "Found '{$searchstring}' in '{$mystring2}' ==> \$" . $thevals['total_earnings'] . "<br>";
$totalrows++;
$sum += $thevals['total_earnings'];
}
}
//calculate the average salary
if ($totalrows > 0) {
$average = $sum / $totalrows;
// report back earnings information as required
echo "<br>The Grand Total Salary for the " . $searchstring . " positions-> is : " . money_format('%i', $sum) . "<br>";
echo "The total rows is : " . $totalrows . "<br>";
echo "The Average salary for the " . $searchstring . " position based on Total Earnings is Grand Total Salary: " . money_format('%i', $sum) . " divided by total number of records " . $totalrows . " = " . money_format('%i', $average) . "<br>";
return 1;
} else {
// no data found, the program will return to the start page, but inform the user. The message may be visible on a slower system.
echo "Sorry no data found for: " . $searchstring . "<br>";
return 0;
}
}
editWebsiteMenuDeleteItem($mitemid, $siteid);
} else {
demoMsg();
}
} elseif (isset($_GET['medit'])) {
$mitemid = cleanGet($_GET['medit']);
editMenuNameEditForm($siteid, $mitemid);
$showmenu = false;
} elseif (isset($_GET['up'])) {
$mitemid = cleanGet($_GET['up']);
editWebsiteMenuOrder($siteid, $mitemid, 'up');
} elseif (isset($_GET['down'])) {
$mitemid = cleanGet($_GET['down']);
editWebsiteMenuOrder($siteid, $mitemid, 'down');
} elseif (isset($_GET['addpage']) && isset($_POST['page_title']) && strlen($_POST['page_title']) > 1) {
$page_title = cleanGet($_POST['page_title']);
if (isActive($userid)) {
if (maxSitePages($siteid) == false) {
addPage($siteid, $page_title);
} else {
sysMsg(MSG00119);
}
} else {
demoMsg();
}
} elseif (isset($_GET['changetitle']) && isset($_POST['old_page_id'])) {
$pageid = cleanPost($_POST['old_page_id']);
$title = cleanPost($_POST['new_page_title']);
if (isActive($userid)) {
changePageTitle($pageid, $title);
} else {
*** Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA ***
*** ***
*** See COPYRIGHT.php for more information. ***
*** See LICENSE.php for more information. ***
*** ***
*** www.joomlaxtc.com ***
*** ***
************************************************************************************
***********************************************************************************/
// This program Builds CSS style cascade
define('_XTCFRAMEWORK', 1);
require 'XTC.php';
$templateParameters = xtcLoadParams();
// Get params for this template
$group = cleanGet('group');
$file = basename(cleanGet('file'));
if ($group && isset($templateParameters->group->{$group})) {
$params = $templateParameters->group->{$group};
$file .= '.css';
} else {
$params = $templateParameters;
}
$imgpath = $xtc->templateUrl . 'images';
header('Content-type: text/css');
if ($xtc->CSScompression) {
ob_start();
ob_implicit_flush(0);
}
if (is_readable($xtc->templatePath . '/css/' . $file)) {
require $xtc->templatePath . '/css/' . $file;
}
function regHiddenRepeat($varname, $default = '')
{
$val = cleanGet($varname, $default, false);
regHidden($varname, $default);
}
// * GNU General Public License for more details. *
// * *
// * You should have received a copy of the GNU General Public License *
// * along with this program. If not, see <http://www.gnu.org/licenses/>. *
// * *
// *************************************************************************
session_start();
if (!isset($_SESSION['userid'])) {
header("Location: index.php");
}
include_once 'functions/functions.php';
include_once 'functions/preview_functions.php';
$userid = checkSession();
$siteid = checkSiteId();
//BEGIN PREVIEW
if ($siteid != 0) {
if (isset($_GET['preview']) && is_numeric($_GET['preview']) && $_GET['preview'] > '0') {
$pwpage = cleanGet($_GET['preview']);
} else {
$pwpage = 0;
}
$_SESSION['website'] = $siteid;
if ($pwpage > 0) {
showWebsitePreview($siteid, $pwpage);
} else {
showWebsitePreview($siteid, NULL);
}
} else {
giveWarning();
}
//END PREVIEW
// * along with this program. If not, see <http://www.gnu.org/licenses/>. *
// * *
// *************************************************************************
session_start();
if (!isset($_SESSION['userid'])) {
header("Location: index.php");
}
include_once 'functions/functions.php';
include_once 'functions/page_functions.php';
$userid = checkSession();
$siteid = checkSiteId();
include_once 'admin_template/header.php';
//START PAGES
if ($siteid != 0) {
if (isset($_GET['pages']) && is_numeric($_GET['pages']) && $_GET['pages'] > '0') {
$pageid = cleanGet($_GET['pages']);
if (pageBelongsTo($pageid, $siteid) == false) {
$pageid = NULL;
} elseif (isset($_POST['TextAreaData'])) {
$page = array();
$page['id'] = cleanPost($_POST['id']);
$page['content'] = $_POST['TextAreaData'];
if (!isContactPage($page['id'])) {
if (isActive($userid)) {
savePage($page);
// $_POST['TextAreaData'] = NULL;
// $page['content'] = NULL;
} else {
demoMsg();
}
}
if (!isset($_SESSION['userid'])) {
header("Location: index.php");
}
if (isset($_GET['items_per_page'])) {
if (is_numeric($_GET['items_per_page'])) {
$_SESSION['items_per_page'] = $_GET['items_per_page'];
}
}
include_once 'functions/functions.php';
include_once 'functions/template_functions.php';
$userid = checkSession();
$siteid = checkSiteId();
include_once 'admin_template/header.php';
if ($siteid != 0) {
if (isset($_GET['action'])) {
$taction = cleanGet($_GET['action']);
if ($taction == 'save' && isset($_POST['website_template'])) {
$template = cleanPost($_POST['website_template']);
if (isActive($userid)) {
saveWebsiteTemplate($siteid, $template);
} else {
demoMsg();
}
}
}
if (isset($_GET['tview']) && is_numeric($_GET['tview'])) {
$view = $_GET['tview'];
} else {
$view = 0;
}
$_SESSION['website'] = $siteid;
function cleanPost($post_data)
{
if (!$post_data == NULL) {
return cleanGet($post_data);
} else {
return '';
}
}
function xtcLoadParams($style = 0)
{
// Load raw params*.ini file and returns param object (also set on $GLOBALS)
// public parameters on URL or cookie will override template parameters
$xtc =& $GLOBALS['xtc'];
if (empty($style)) {
$app = JFactory::getApplication();
$template = $app->getTemplate(true);
if (!isset($template->id)) {
$db = JFactory::getDbo();
$query = $db->getQuery(true)->select('id')->from('#__template_styles')->where('client_id=0 AND home=1');
$db->setQuery($query);
$template->id = $db->loadResult();
}
$style = $template->id;
}
// Get cookie variables array
$cookieName = $xtc->template . 'Template';
$cookie = array();
if ($xtc->publicParams) {
// there are public parameters, cookie them!
if (isset($_COOKIE[$cookieName])) {
$cookie = unserialize(base64_decode($_COOKIE[$cookieName]));
}
if (!$cookie) {
$cookie = array();
}
foreach ($xtc->publicParams as $parm) {
$value = cleanGet($parm);
if ($value) {
// We have a URL override
$cookie[$parm] = $value;
}
}
if (!empty($cookie) || $xtc->clearCookie) {
// Save/clear cookie if not empty
$lifespan = $xtc->clearCookie ? time() - 3600 : time() + $xtc->cookieLifespan;
setcookie($cookieName, base64_encode(serialize($cookie)), $lifespan, '/');
/* expire in 1 year */
}
}
// Build parameter object
$obj = new stdClass();
$obj->group = new stdClass();
$obj->prefix = array();
$obj->groups = array();
// Parse parameters file
$parameterFile = $xtc->templatePath . '/params_' . $style . '.ini';
if (!is_readable($parameterFile)) {
$data = xtcMakeParams($style);
} else {
$data = file($parameterFile);
}
foreach ($data as $rec) {
$rec = trim($rec);
$pos = strpos($rec, '=');
if ($pos === false) {
continue;
}
$parm = substr($rec, 0, $pos);
$value = stripcslashes(substr($rec, $pos + 1));
if (substr($parm, 0, 1) == '{') {
// XTC-formed parm
$pos = strpos($parm, '}');
$group = substr($parm, 1, $pos - 1);
@(list($prefix, $group) = explode('+', $group));
$parm = substr($parm, $pos + 1);
if (!isset($obj->group->{$group})) {
$obj->group->{$group} = new stdClass();
$obj->prefix[$group] = $prefix;
$obj->groups[] = $group;
}
} else {
// No group
$group = '';
}
if (array_key_exists($parm, $cookie)) {
//echo "override [$parm] [$value] [".$cookie[$parm]."]";
$value = $cookie[$parm];
// Override with value on cookie parm, if present
}
if ($group) {
// It's from a group
$obj->group->{$group}->{$parm} = $value;
} else {
$obj->{$parm} = $value;
}
//echo "parm: [$group][$parm][$value]<br>";
}
// Update XTC object with style ID and XTC parameters
$xtc->style = $style;
if (isset($obj->CSSmode)) {
$xtc->CSSmode = $obj->CSSmode;
}
// CSS mode: 1 = Single file, 2 = Separate files, 3 = Embedded in head
if (isset($obj->CSScompression)) {
$xtc->CSScompression = $obj->CSScompression;
}
// CSS compression 0 = off, 1 = on
if (isset($obj->cookieLifespan)) {
$xtc->cookieLifespan = $obj->cookieLifespan;
}
// Cookie lifespan in seconds
if (isset($obj->clearCookie)) {
$xtc->clearCookie = $obj->clearCookie;
}
// Clears cookie on every page load
if (isset($obj->publicParams)) {
$xtc->publicParams = array_map('trim', explode(',', $obj->publicParams));
}
// Public parameters
if (isset($obj->showComponents)) {
$xtc->showComponents = explode('|', $obj->showComponents);
}
// Frontpage components
$GLOBALS['templateParameters'] =& $obj;
return $obj;
}
function changePageTitle($pageid, $title)
{
$page = array();
$page['page_title'] = $title;
$db = Database::obtain();
$db->update(TABLE_PAGES, $page, "id=" . $pageid . "");
$siteid = cleanGet($_GET['website']);
$menu = getMenu($siteid);
foreach ($menu as $id => $page) {
if ($page['pageid'] == $pageid) {
$menu[$id]['title'] = $title;
}
}
saveWebsiteMenu($siteid, $menu);
sysMsg(MSG00124);
}
