PHP filterQryPost Examples

Example #1

File: inc_period.php Project: CarlosOVillanueva/BIFROST

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
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/>.
*/
require_once "_lib/php/auth.php";
filterQryPost("monthID");
filterQryPost("yearID");
if ($payFrequency == "") {
    $gdbo->sql = "SELECT hr_emp_payFrequency FROM _hr_emp WHERE id_hr_emp=" . $rec[0]["id_hr_emp"];
    $gdbo->getRec();
    $payFrequencyResults = $gdbo->dbData;
    $payFrequency = $payFrequencyResults[0][0];
}
//*************************************/
/* week days */
/*************************************/
$weekdays = array();
$weekdays[] = "Monday";
$weekdays[] = "Tuesday";
$weekdays[] = "Wednesday";
$weekdays[] = "Thursday";
$weekdays[] = "Friday";

Example #2

File: sql_descr.php Project: CarlosOVillanueva/BIFROST

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
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/>.
*/
require_once "_lib/php/auth.php";
printArray($_POST);
filterQryPost("id");
$id = hex2str($id);
filterQryPost("rid");
filterQryPost("val");
filterQryPost("edit");
filterQryPost("pri");
switch ($edit) {
    case 0:
        $gdbo->sql = "insert into _srv_descr (srv_descr_privateBit,id_srv,srv_descr,id_sys_user,srv_descr_du) values ({$pri},{$id},'{$val}',{$id_sys_user},current_timestamp)";
        $gdbo->dbTable = "_srv_descr";
        $gdbo->execQuery();
        break;
    case 1:
        $gdbo->sql = "update _srv_descr set srv_descr_privateBit={$pri},srv_descr_du=current_timestamp,id_srv={$id},srv_descr='{$val}',id_sys_user={$id_sys_user} where id_srv_descr={$rid}";
        $gdbo->dbTable = "_srv_descr";
        $gdbo->execQuery();
        break;
    case 2:
        $gdbo->sql = "delete from _srv_descr where id_srv_descr={$rid}";
        $gdbo->dbTable = "_srv_descr";
        $gdbo->execQuery();

Example #3

File: ArcFilterSelect.php Project: CarlosOVillanueva/BIFROST

* i - node id of destination
* j - object
* k - where clause
* l - order by clause
* m - attributes
* n - debug
*/
require_once "_lib/php/auth.php";
filterQryPost("n");
$debug = isset($n) ? $n : 0;
if ($debug == 1) {
    printArray($_POST);
}
# convert all POST variables into PHP
foreach ($_POST as $key => $value) {
    filterQryPost($key);
}
# javascript parse
# only supports a single function with multiple parameters
if (!is_null($g) && $g != "null") {
    $g = str_replace("!qut!", "'", $g);
    $g = str_replace("!sem!", ";", $g);
    $g = str_replace("!com!", ",", $g);
}
if (!is_null($e) && $e != "null") {
    $e = str_replace("!squt!", "'", $e);
    $e = str_replace("!sem!", ";", $e);
    $e = str_replace("!com!", ",", $e);
} else {
    $g = null;
}

Example #4

File: sql_invoice_series.php Project: CarlosOVillanueva/BIFROST

<?php

require_once "_lib/php/auth.php";
$debug = 1;
filterQryPost('action');
filterQryPost('form');
filterQryPost('edit');
$gdbo->dbTable = "_invoice_series";
$formAction = $form . "," . $action;
# Begin SQL Functions
switch ($formAction) {
    case "frminvoiceseries,insert":
        $_POST["invoice_series_enablebit"] = 1;
        $gdbo->insertRec();
        include "_mod/smod_27/models/list_invoice_series.php";
        break;
    default:
        break;
}
switch ($edit) {
    case 1:
        $_POST["invoice_series"] = $_POST["Series"];
        $gdbo->updateRec($_POST["col"] . "='" . $_POST["key"] . "'");
        include "_error/status.php";
        break;
    case 2:
        $gdbo->deleteRec($_POST["col"] . "='" . $_POST["key"] . "'");
        include "_mod/smod_27/models/list_invoice_series.php";
        break;
}

Example #5

File: ArcCalendar.php Project: CarlosOVillanueva/BIFROST

<?php

/* 
Author: Carlos Omar Villanueva
*/
require_once '_lib/php/auth.php';
$curYear = date('Y', strtotime($dtTimeCurrent));
$curDay = date('j', strtotime($dtTimeCurrent));
$curMonth = date('n', strtotime($dtTimeCurrent));
$daysOfWeek = array(array("Sunday", "Su", 0), array("Monday", "Mo", 1), array("Tuesday", "Tu", 2), array("Wednesday", "We", 3), array("Thursday", "Th", 4), array("Friday", "Fr", 5), array("Saturday", "Sa", 6));
filterQryPost("yearID");
$yearID = isset($yearID) ? $yearID : $curYear;
filterQryPost("monthID");
$monthID = isset($monthID) ? $monthID : $curMonth;
$dateToFind = cal_to_jd(CAL_GREGORIAN, $monthID, 1, $yearID);
$firstDayofMonth = jddayofweek($dateToFind, 1);
echo "<div style=\"text-align:center\" class=\"closeButton\" onclick=\"selectCalendarDate('" . $yearID . "-" . $monthID . "-" . $curDay . "')\">Today</div>";
$monthBackward = $monthID != 1 ? "<span class=\"lArrow\" onclick=\"moveDate(0,0,{$monthID},{$yearID})\">◄</span>" : "<span class=\"lArrow\" style=\"visibility:hidden\">◄</span>";
$monthForward = $monthID != 12 ? "<span class=\"rArrow\" onclick=\"moveDate(1,0,{$monthID},{$yearID})\">►</span>" : "<span class=\"rArrow\" style=\"visibility:hidden\">►</span>";
echo "<div class=\"calRow\"><span class=\"calTitle\">{$monthBackward}" . date('F', strtotime("{$yearID}-{$monthID}-01")) . "{$monthForward}</span></div>";
echo "<div class=\"calRow\"><span class=\"calTitle\"><span class=\"lArrow\" onclick=\"moveDate(0,1,{$monthID},{$yearID})\">◄</span>" . $yearID . "<span class=\"rArrow\" onclick=\"moveDate(1,1,{$monthID},{$yearID})\">►</span></span></div>";
$days = cal_days_in_month(CAL_GREGORIAN, $monthID, $yearID);
for ($i = 0; $i < count($daysOfWeek); $i++) {
    if ($daysOfWeek[$i][0] == $firstDayofMonth) {
        $startDate = $daysOfWeek[$i][2];
    }
}
for ($i = 0; $i < count($daysOfWeek); $i++) {
    echo "<span class=\"dayHeading\">" . $daysOfWeek[$i][1] . "</span>";
}
echo "<br>";

Example #6

File: sqlResults.php Project: CarlosOVillanueva/BIFROST

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
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/>.
*/
require_once "_lib/php/auth.php";
filterQryPost("table");
filterQryPost("edit");
if ($edit != "") {
    $frm = "";
    switch ($edit) {
        case 0:
            $frm . "<div id=\"list12\">";
            include "list.php";
            $frm . "</div>";
            break;
        case 1:
            $gdbo->sql = "SELECT COLUMN_NAME,DATA_TYPE FROM COLUMNS WHERE TABLE_SCHEMA='{$globalDB}' AND TABLE_NAME='" . $table . "'";
            $gdbo->dbSchema = "INFORMATION_SCHEMA";
            $gdbo->getRec();
            $aschema = $gdbo->dbData;
            $frm .= '<form method="post" name="frmAdd" action="javascript:submitFrmVals(\'list12\',\'' . $path . 'sqlInsert.php\',null,\'&table=' . $table . '&edit=0\',\'frmAdd\')">';
            $frm .= '<table style="clear:both" class="dataGrid"><tr>';

Example #7

File: filterMembers.php Project: CarlosOVillanueva/BIFROST

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
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/>.
*/
require_once "_lib/php/auth.php";
filterQryPost("id");
#Group Members
$gdbo->sql = "\nSELECT\na.id_sys_user,\nc.cust_contact_givenName,\nc.cust_contact_familyName,\nd.sys_user\nFROM\n_sys_user_emp a \nLEFT JOIN _hr_emp b ON a.id_cust_contact=b.id_cust_contact\nLEFT JOIN _cust_contact c ON a.id_cust_contact=c.id_cust_contact\nLEFT JOIN _sys_user d ON a.id_sys_user=d.id_sys_user\nLEFT JOIN _sys_group_user e ON a.id_sys_user=e.id_sys_user\nWHERE d.id_sys_status !=22 AND e.id_sys_group={$id};\n";
$gdbo->getRec();
$aUser = $gdbo->getAssociative();
/* create table */
for ($i = 0; $i < count($aUser); $i++) {
    ?>
<div class="frmrow">
<div class="frmcol"><input class="clRes" type="checkbox"checked="checked" value="<?php 
    echo $aUser[$i]["id_sys_user"];
    ?>
"/>
<?php 
    echo "[ " . $aUser[$i]["sys_user"] . " ] " . $aUser[$i]["cust_contact_givenName"] . ' ' . $aUser[$i]["cust_contact_familyName"];
    ?>

Example #8

File: timecardfiltered.php Project: CarlosOVillanueva/BIFROST

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
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/>.
*/
require_once "_lib/php/auth.php";
filterQryPost("period");
$period = hex2str($period);
$periodArray = explode(".", $period);
$periodStart = $periodArray[1];
$periodEnd = $periodArray[2];
/*************************************/
/* application variables */
/*************************************/
$curYear = date('Y', strtotime($dtTimeCurrent));
$curDay = date('j', strtotime($dtTimeCurrent));
$curMonth = date('n', strtotime($dtTimeCurrent));
$yearID = isset($yearID) ? $yearID : $curYear;
$monthID = isset($monthID) ? $monthID : $curMonth;
$firstDayofMonth = date("l", mktime(0, 0, 0, $monthID, 1, $yearID));
$dayCount = cal_days_in_month(CAL_GREGORIAN, $monthID, $yearID);
$todayTime = strtotime("{$yearID}-{$monthID}-{$curDay} 00:00:00 ");

Example #9

File: insertSQL.php Project: CarlosOVillanueva/BIFROST

the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
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/>.
*/
/* ********************************************************************** */
require_once "_lib/php/auth.php";
/* ********************************************************************** */
filterQryPost("edit");
filterQryPost("id_srv_board");
/* ********************************************************************** */
$debug = 0;
/* ********************************************************************** */
switch ($edit) {
    case 0:
        $gdbo->dbTable = "_srv_board";
        $gdbo->insertRec();
        $_POST['id_srv_board'] = $gdbo->insertedID;
        include 'edit.php';
        include "_error/status.php";
        break;
        /* ********************************************************************** */
    /* ********************************************************************** */
    case 1:
        /* ********************************************************************** */