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";
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();
* 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; }
<?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; }
<?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>";
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>';
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"]; ?>
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 ");
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: /* ********************************************************************** */