function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Countries $gdbo->sql = "SELECT id_loc_country,loc_country FROM _loc_country"; $gdbo->getRec(); $this->listCountries = $gdbo->dbData; # Regions $gdbo->sql = "SELECT id_loc_region,loc_region,id_loc_country FROM _loc_region"; $gdbo->getRec(); $this->listRegions = $gdbo->dbData; # Filterable Objects $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "SELECT id_loc_region,loc_region FROM _loc_region"; $gdbo->dbFilter = "WHERE id_loc_country="; $gdbo->type = "list"; $gdbo->id = "id_loc_region"; $gdbo->attributes = 'class="chRegion"'; $this->regionDBO = encrypt(json_encode((array) $gdbo)); return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Degree Level require "_model/dboDegreeLevel.php"; $gdbo->getRec(); $this->listDegreeLevel = $gdbo->dbData; # Campuses require "_model/dboCampus.php"; $gdbo->getRec(); $this->listCampus = $gdbo->dbData; $this->listCampusJSON = json_encode($this->listCampus); echo '<script>window.listCampusJSON=\'' . $this->listCampusJSON . '\'</script>'; # Education Status require "_model/dboEducationStatus.php"; $gdbo->getRec(); $this->listEducationStatus = $gdbo->dbData; # University require "_model/dboUniversity.php"; $gdbo->getRec(); $this->listUniversity = $gdbo->dbData; return true; }
function getRecords() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; if (is_null($this->filter) || is_null($this->id)) { return false; } $gdbo->sql = "SELECT\n_contract_payment.id_contract_payment,\n_contract_payment.contract_payment,\ncontract_payment_dr,\ncontract_payment_dp,\n_contract_payment.id_contract_payment_method_tp,\n_contract_payment.id_contract\nFROM _contract_payment\nWHERE " . $this->filter . "=" . $this->id . " ORDER BY contract_payment_dr ASC, id_contract_payment ASC"; $gdbo->getRec(); $results = $gdbo->getAssociative(); return $results; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "SELECT id_purchaseorder_payment_tp, purchaseorder_payment_tp FROM _purchaseorder_payment_tp"; $gdbo->getRec(); $this->listPaymentTp = $gdbo->dbData; $gdbo->sql = "SELECT\na.id_contract,\na.contract,\na.id_cust_company,\nb.cust_company\nFROM _contract a\nLEFT JOIN _cust_company b\nON a.id_cust_company = b.id_cust_company\nORDER by b.cust_company\n"; $gdbo->getRec(); $this->listContract = $gdbo->dbData; return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "SELECT \nid_invoice_qty_tp,\ninvoice_qty_tp\nFROM _invoice_qty_tp;\n"; $gdbo->getRec(); $this->listQtyType = $gdbo->dbData; $gdbo->sql = "SELECT\na.id_contract,\na.contract,\na.id_cust_company,\nb.cust_company\nFROM _contract a\nLEFT JOIN _cust_company b\nON a.id_cust_company = b.id_cust_company\nORDER by b.cust_company\n"; $gdbo->getRec(); $this->listContract = $gdbo->dbData; return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Insurance Plan $gdbo->sql = "SELECT \nid_hr_insurance_plan,\nhr_insurance_plan,\nid_cust_company \nFROM _hr_insurance_plan\nORDER BY id_cust_company asc,hr_insurance_plan asc"; $gdbo->getRec(); $this->listInsurancePlan = $gdbo->dbData; $this->listInsurancePlanJSON = json_encode($this->listInsurancePlan); echo '<script>window.listInsurancePlanJSON=\'' . $this->listInsurancePlanJSON . '\'</script>'; # Insurance Provider require "_model/dboInsuranceProvider.php"; $gdbo->getRec(); $this->listInsuranceProvider = $gdbo->dbData; # Insurance Coverage require "_model/dboInsuranceCoverage.php"; $gdbo->getRec(); $this->listInsuranceCoverage = $gdbo->dbData; return true; }
function getLists() { $gdbo = new ArcDb(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; # Certification Type require "_model/dboCertification.php"; $gdbo->getRec(); $this->listCertification = $gdbo->dbData; $this->listCertificationJSON = json_encode($this->listCertification); echo '<script>window.listCertificationJSON=\'' . $this->listCertificationJSON . '\'</script>'; # Education Status require "_model/dboEducationStatus.php"; $gdbo->getRec(); $this->listEducationStatus = $gdbo->dbData; # Provider require "_model/dboCertificationProvider.php"; $gdbo->getRec(); $this->listProvider = $gdbo->dbData; return true; }
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"; /**************************************************/ $interfacerec = new ArcDb(); $interfacerec->dbConStr = $globalDBCON; $interfacerec->dbType = $globalDBTP; $interfacerec->dbSchema = $globalDB; /**************************************************/ #netgroup $interfacerec->sql = "SELECT a.id_cfg_device_netgroup,a.cfg_device_netgroup from _cfg_device_netgroup a\nWHERE EXISTS (SELECT b.id_cfg_device_netgroup FROM _cfg_device_ip4netaddress b WHERE a.id_cfg_device_netgroup=b.id_cfg_device_netgroup AND b.cfg_device_ip4netaddress_enabled = 1)\norder by cfg_device_netgroup"; $interfacerec->getRec(); $listnetgroup = $interfacerec->dbData; /**************************************************/ #interfaces $interfacerec->sql = "SELECT\na.id_cfg_device_ip4netaddress,\nconcat(RTRIM(cast(inet_ntoa(a.cfg_device_ip4netaddress) as char)),'/',RTRIM(cast(a.cfg_device_ip4netaddress_nmbits as char))) as net,\na.id_cfg_device_netgroup,b.cfg_device_netgroup\nFROM _cfg_device_ip4netaddress a LEFT JOIN _cfg_device_netgroup b ON a.id_cfg_device_netgroup=b.id_cfg_device_netgroup\nWHERE a.cfg_device_ip4netaddress_enabled=1 ORDER BY a.id_cfg_device_netgroup,a.cfg_device_ip4netaddress"; $interfacerec->getRec(); $listnetworkinterfaces = $interfacerec->dbData; echo "<script type='text/javascript'>window.listNetworkInterface=" . json_encode($listnetworkinterfaces) . ";</script>"; /**************************************************/
<?php /* * @dependency lib_ip.js * @dependency ArcJS-13.3.0.1.js * @dependency ArcCore-13.3.0.0.php * @dependency ArcDb-13.3.0.0.php * @dependency ArcTbl-13.3.0.0.php * @dependency ArcDbFilter.php * @dependency auth.php (Contains references for preceding *.php) * * */ require_once "_lib/php/auth.php"; /* define database */ $ip = new ArcDb(); $ip->dbConStr = $globalDBCON; $ip->dbType = $globalDBTP; $ip->dbSchema = $globalDB; /* return all interfaces with the same address */ $ip->sql = "\nSELECT\nid_cfg_device_interface,\nid_cfg_device_ip4netaddress,\na.id_cfg_device,\na.id_device_interfacelabel,\nid_device_ifspeedduplex,\ncfg_device_interface_ip4hostaddress,\ncfg_device_interface_enabled,\nd.device,\ne.cfg,\nc.device_interfacelabel\nFROM\n_cfg_device_interface a\nINNER JOIN\n_cfg_device b \nON a.id_cfg_device=b.id_cfg_device\nINNER JOIN\n_device_interfacelabel c \nON a.id_device_interfacelabel=c.id_device_interfacelabel\nINNER JOIN\n_device d \nON b.id_device=d.id_device\nINNER JOIN\n_cfg e \nON b.id_cfg=e.id_cfg\nWHERE\ncfg_device_interface_enabled=1\nAND cfg_device_interface_ip4hostaddress=" . $_POST["cfg_device_interface_ip4hostaddress"]; $ip->getRec(); if ($ip->dbRows > 0) { $existingInterfaceAssignments = $ip->getAssociative(); } else { die('<script>prepSaveChanges("' . $_POST["form"] . '")</script>'); } /* evaluate returned results */ if (count($existingInterfaceAssignments) > 0) { /* matches were found */ /* * search array for network id passed via POST */ $netIsDefined = multiArraySearch($existingInterfaceAssignments, $_POST["id_cfg_device_ip4netaddress"]);
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"; $sql = isset($_POST["sqlbox"]) ? hex2str($_POST["sqlbox"]) : ""; if (isset($_POST["id_con"]) && $_POST["id_con"] != "") { $arcdb = new ArcDb(); $arcdb->dbConStr = $globalDBCON; $arcdb->dbType = $globalDBTP; $arcdb->dbSchema = $globalDB; /**************************************************/ $arcdb->sql = "\nSELECT\na.id_con, \na.con, \na.id_con_db_tp,\na.con_alias,\na.con_user,\na.con_enabledbit,\na.con_password,\na.con_host,\na.con_port,\na.con_catalog,\na.con_options,\nb.con_db_tp\nFROM _con a\nLEFT JOIN _con_db_tp b ON a.id_con_db_tp=b.id_con_db_tp\nWHERE a.id_con =" . $_POST["id_con"]; $arcdb->getRec(); $con = $arcdb->getAssociative(); } $arcCon = new ArcTbl(); $arcCon->dbLimit = 23; $arcCon->dbOffset = 0; $arcCon->dbCatalog = isset($con[0]["con_catalog"]) ? $con[0]["con_catalog"] : $arcCon->dbCatalog; $arcCon->oCon = isset($con[0]["con"]) ? $con[0]["con"] : $arcCon->oCon; $arcCon->dbTable = $arcCon->oCon; $arcCon->dbSchema = isset($con[0]["con"]) ? $con[0]["con"] : $arcCon->dbSchema;
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"; $ajCfgDevice = null; $ajCfgDevice = isset($_POST["id_cfg_device"]) ? "&id_cfg_device=" . $_POST["id_cfg_device"] : ""; $ajCfgDevice .= isset($_POST["id_device"]) ? "&id_device=" . $_POST["id_device"] : ""; $ajCfgDevice .= isset($_POST["id_cfg"]) ? "&id_cfg=" . $_POST["id_cfg"] : ""; /**************************************************/ $iflabel = new ArcDb(); $iflabel->dbConStr = $globalDBCON; $iflabel->dbType = $globalDBTP; $iflabel->dbSchema = $globalDB; $iflabel->sql = "SELECT id_cfg_device_netgroup,cfg_device_netgroup from _cfg_device_netgroup order by cfg_device_netgroup"; $iflabel->getRec(); $listiflabel = $iflabel->dbData; /**************************************************/ $buttonAdd = '<div class="elementIconBox" onclick="prepSaveChanges(\'frmIFLabel\')"><i class="fa fa-plus"></i></div>'; /**************************************************/ $mnuiflabel = array(array(array("Interface Label", "device_interfacelabel", 'class="elementIcon"', 0, null, null, null, $buttonAdd, null, 'Network Interface'))); /**************************************************/ ?> <legend> Add Inteface Label </legend>
$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 "); /************************************************************************/ $arc = new ArcDb(); $arc->dbType = $globalDBTP; $arc->dbSchema = $globalDB; $arc->dbConStr = $globalDBCON; $arc->sql = "\nSELECT\nid_tm_timesheet,\ntm_timesheet_ds,\ntm_timesheet_de,\nid_hr_emp,\ntm_timesheet_approved\nFROM\n_tm_timesheet WHERE\nid_hr_emp={$id_hr_emp_derived} AND\ntm_timesheet_ds={$periodStart} AND\ntm_timesheet_de={$periodEnd} \n"; $arc->getRec(); $timesheet = $arc->getAssociative(); if ($arc->dbRows > 0) { /*timesheet has been submitted. validate what the current state*/ switch ($timesheet[0]["tm_timesheet_approved"]) { case 0: $status = "Submitted"; break; case 1: $status = "Approved"; break;
$body = $decoded[0]['Body']; } elseif (substr($decoded[0]['Parts'][0]['Headers']['content-type:'], 0, strlen('text/plain')) == 'text/plain' && isset($decoded[0]['Parts'][0]['Body'])) { $body = $decoded[0]['Parts'][0]['Body']; } elseif (substr($decoded[0]['Parts'][0]['Parts'][0]['Headers']['content-type:'], 0, strlen('text/plain')) == 'text/plain' && isset($decoded[0]['Parts'][0]['Parts'][0]['Body'])) { $body = $decoded[0]['Parts'][0]['Parts'][0]['Body']; } /*********************************************************************/ /*Get Time Card Data*/ require_once "bootstrap.php"; date_default_timezone_set('UTC'); $gmtOffset = "-21600"; //Central Time $dtCurrent = date("l, F j, Y e"); $dtTimeCurrent = date("Y-m-d H:i:s", strtotime(date("Y-m-d H:i:s")) + $gmtOffset); $id_tm_timesheet = decrypt(trim(preg_replace("/.+?\\|.+?\\|(.*)/", "\$1", $subject))); $arc = new ArcDb(); $arc->dbType = $globalDBTP; $arc->dbSchema = $globalDB; $arc->dbConStr = $globalDBCON; $arc->sql = "\nSELECT\nc.id_cust_contact,\nconcat(c.cust_contact_givenName,' ',c.cust_contact_familyName) as fullName,\nc.cust_contact_givenName,\nc.cust_contact_familyName\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\nWHERE d.id_sys_status=21 AND d.sys_user_tmEmail='" . $fromEmail . "'"; $arc->getRec(); $approver = $arc->getAssociative(); $approverFull = $approver[0]["fullName"]; $approverFirst = $approver[0]["cust_contact_givenName"]; $approverLast = $approver[0]["cust_contact_familyName"]; $approverCount = $arc->dbRows; $arc->sql = "\nSELECT\nconcat(b.cust_contact_givenName,' ',b.cust_contact_familyName) as fullName\nFROM\n_tm_timesheet a\nLEFT JOIN\n_hr_emp c ON a.id_hr_emp=c.id_hr_emp\nLEFT JOIN\n_cust_contact b ON c.id_cust_contact=b.id_cust_contact\nWHERE\na.id_tm_timesheet={$id_tm_timesheet}\n"; $arc->getRec(); $timesheetdetail = $arc->getAssociative(); if ($approverCount > 0) { /*********************************************************************/
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"; $timecard = preg_replace("/onclick=\".+?\"|onmouseover=\".+?\"|onmouseout=\".+?\"|style=\".+?\"/i", "", hex2str($_POST["data"])); $gdbo = new ArcDb(); $gdbo->dbConStr = $globalDBCON; $gdbo->dbSchema = $globalDB; $gdbo->dbType = $globalDBTP; /*Get Employee Data*/ $gdbo->sql = "\nSELECT\na.hr_emp_timeApprover\nFROM _hr_emp a WHERE id_hr_emp={$id_hr_emp_derived} AND a.hr_emp_timeApprover is not null;"; $gdbo->getRec(); $employee = $gdbo->getAssociative(); if ($gdbo->dbRows > 0) { $gdbo->sql = "\nSELECT \na.id_sys_user,\na.sys_user_tmEmail,\nb.cust_contact_givenName\nFROM _sys_user a\nLEFT JOIN _sys_user_emp c ON a.id_sys_user=c.id_sys_user\nLEFT JOIN _cust_contact b ON c.id_cust_contact=b.id_cust_contact\nWHERE b.id_cust_contact=" . $employee[0]["hr_emp_timeApprover"]; $gdbo->getRec(); $approver = $gdbo->getAssociative(); $gdbo->sql = "\nSELECT \nid_tm_timesheet,\nid_hr_emp,\ntm_timesheet_ds,\ntm_timesheet_de,\ntm_timesheet_approved\nFROM _tm_timesheet\nWHERE tm_timesheet_ds=" . $_POST["datestart"] . " AND tm_timesheet_de=" . $_POST["dateend"] . " AND id_hr_emp=" . $id_hr_emp_derived; $gdbo->getRec(); $timesheet = $gdbo->getAssociative(); $timesheetCount = $gdbo->dbRows;
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"; $gdbo = new ArcDb(); $gdbo->dbConStr = $globalDBCON; $gdbo->dbType = $globalDBTP; $gdbo->dbSchema = $globalDB; # Device Group $gdbo->sql = "SELECT \nid_device_grp,\ndevice_grp\nFROM _device_grp"; $gdbo->getRec(); $listDeviceGroup = $gdbo->dbData; # Users $gdbo->sql = "SELECT\na.id_hr_emp,\nconcat(b.cust_contact_givenName,' ',b.cust_contact_familyName) as \"fullname\" \nFROM\n_hr_emp as a\nLEFT JOIN _cust_contact b ON a.id_cust_contact=b.id_cust_contact\nORDER BY b.cust_contact_givenName,b.cust_contact_familyName"; $gdbo->getRec(); $listUsers = $gdbo->dbData; # Status $gdbo->sql = "SELECT \nid_sys_status,\nsys_status\nFROM\n_sys_status \nWHERE id_sys_status_tp=7"; $gdbo->getRec(); $listStatus = $gdbo->dbData;
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"; $dbo = new ArcDb(); $dbo->dbConStr = $globalDBCON; $dbo->dbType = $globalDBTP; $dbo->dbSchema = $globalDB; $action = $_POST['action']; $form = $_POST['form']; $formAction = $form . "," . $action; if (isset($_POST["con_password"]) && $_POST["con_password"] != "") { $_POST["con_password"] = encrypt($_POST["con_password"]); } switch ($formAction) { /* ********************************************************************** */ case "dbcon,insert": /* ********************************************************************** */ $dbo->dbTable = "_con"; $dbo->insertRec();
public function getSchemata($dbType, $dbSchema, $dbTable, $dbCon = null, $dbConStr = null, $dbCatalog = null) { switch ($dbType) { case "mysql": $sql = "SELECT COLUMN_NAME,DATA_TYPE,ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='" . $dbSchema . "' AND TABLE_NAME='" . $dbTable . "';"; break; case "mssql": $sql = "SELECT COLUMN_NAME,DATA_TYPE,ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='" . $dbTable . "';"; break; case "pgsql": $sql = "SELECT COLUMN_NAME,DATA_TYPE,ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='" . $dbTable . "';"; $dbSchema = "information_schema"; break; } $dbCatalogInsert = !is_null($dbCatalog) ? ",dbCatalog=" . $dbCatalog : ""; $schDbo = new ArcDb(); $schDbo->sql = $sql; $schDbo->dbConStr = $dbConStr; $schDbo->dbSettings = "dbSchema=" . $dbSchema . ",dbType=" . $dbType . ",dbCon=" . $dbCon . $dbCatalogInsert; $schDbo->getRec(); $schemadata = $schDbo->dbData; $this->primaryKey = $schemadata[0][0]; return $schemadata; }
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"; $_POST["tm_timesheet_approvedBy"] = $id_cust_contact_derived; $arc = new ArcDb(); $arc->dbType = $globalDBTP; $arc->dbSchema = $globalDB; $arc->dbConStr = $globalDBCON; $arc->dbTable = "_tm_timesheet"; switch ($_POST["edit"]) { case 1: $arc->updateRec("id_tm_timesheet=" . $_POST["id_tm_timesheet"]); break; case 2: $arc->deleteRec("id_tm_timesheet=" . $_POST["id_tm_timesheet"]); break; default: break; } ?>
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"; require_once "_includes/optionstoolbar.php"; /**************************************************/ $arcdb = new ArcDb(); $arcdb->dbConStr = $globalDBCON; $arcdb->dbType = $globalDBTP; $arcdb->dbSchema = $globalDB; $id = $_POST["id_con"]; /**************************************************/ $arcdb->sql = "\nSELECT\nid_con,\ncon,\nid_con_db_tp,\ncon_alias,\ncon_user,\ncon_enabledbit,\ncon_password,\ncon_host,\ncon_port,\nUNHEX(con_options) as con_options,\ncon_catalog\nFROM _con\nWHERE id_con={$id}"; $arcdb->getRec(); $connections = $arcdb->getAssociative(); $arcdb->sql = "\nSELECT \nid_con_db_tp,\ncon_db_tp_alias\nFROM _con_db_tp\n"; $arcdb->getRec(); $dbtypes = $arcdb->dbData; /**************************************************/ $password = $connections[0]["con_password"] != "" ? decrypt($connections[0]["con_password"]) : ""; $enabledBoo = array(array(1, "Enable"), array(0, "Disable")); $conFields = array(array(array('Friendly Name', 'con_alias', null, 0, null, $connections[0]["con_alias"]), array('Database Type', 'id_con_db_tp', null, 1, $dbtypes, $connections[0]["id_con_db_tp"]), array('Status', 'con_enabledbit', null, 4, $enabledBoo, $connections[0]["con_enabledbit"])), array(array('Database', 'con', null, 0, null, $connections[0]["con"]), array('Table Schema', 'con_catalog', null, 0, null, $connections[0]["con_catalog"])), array(array('Username', 'con_user', null, 0, null, $connections[0]["con_user"]), array('Password', 'con_password', null, 7, null, $password)), array(array('Host', 'con_host', null, 0, null, $connections[0]["con_host"]), array('Port', 'con_port', null, 0, null, $connections[0]["con_port"])), array(array('Options', 'con_options', null, 6, null, $connections[0]["con_options"])));
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"; $gdbo = new ArcDb(); $gdbo->dbConStr = $globalDBCON; $gdbo->dbType = $globalDBTP; $gdbo->dbSchema = $globalDB; # Record $gdbo->sql = "SELECT\na.id_cfg_device,\na.id_hr_emp,\na.id_device,\na.cfg_device,\na.id_cfg,\na.cfg_device_serialnumber,\nUNHEX(a.cfg_device_notes) as \"cfg_device_notes\",\nFROM_UNIXTIME(UNIX_TIMESTAMP(a.cfg_device_dc)+{$gmtOffset}) as \"cfg_device_dc\",\nFROM_UNIXTIME(UNIX_TIMESTAMP(a.cfg_device_du)+{$gmtOffset}) as \"cfg_device_du\",\na.cfg_device_dr,\na.id_sys_status,\na.cfg_device_keyenabled,\na.cfg_device_key,\nb.id_device_grp,\na.cfg_device_os\nFROM\n_cfg_device a\nLEFT JOIN\n_device b ON a.id_device=b.id_device\nWHERE a.id_cfg_device=" . $_POST["id_cfg_device"]; $gdbo->getRec(); $rec = $gdbo->getAssociative(); # Device Group $gdbo->sql = "SELECT \nid_device_grp,\ndevice_grp\nFROM _device_grp"; $gdbo->getRec(); $listDeviceGroup = $gdbo->dbData; # Users $gdbo->sql = "SELECT\na.id_hr_emp,\nconcat(b.cust_contact_givenName,' ',b.cust_contact_familyName) as \"fullname\" \nFROM\n_hr_emp as a\nLEFT JOIN _cust_contact b ON a.id_cust_contact=b.id_cust_contact\nORDER BY b.cust_contact_givenName,b.cust_contact_familyName"; $gdbo->getRec(); $listUsers = $gdbo->dbData;
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"; if (isset($_POST["id_con"]) && $_POST["id_con"] != "") { $arcdb = new ArcDb(); $arcdb->dbConStr = $globalDBCON; $arcdb->dbType = $globalDBTP; $arcdb->dbSchema = $globalDB; /**************************************************/ $arcdb->sql = "\nSELECT\na.id_con, \na.con, \na.id_con_db_tp,\na.con_alias,\na.con_user,\na.con_enabledbit,\na.con_password,\na.con_host,\na.con_port,\na.con_catalog,\na.con_options,\nb.con_db_tp\nFROM _con a\nLEFT JOIN _con_db_tp b ON a.id_con_db_tp=b.id_con_db_tp\nWHERE a.id_con =" . $_POST["id_con"]; $arcdb->getRec(); $con = $arcdb->getAssociative(); /**************************************************/ } $arcCon = new ArcDb(); $arcCon->dbCatalog = isset($con[0]["con_catalog"]) ? $con[0]["con_catalog"] : $arcCon->dbCatalog; $arcCon->oCon = isset($con[0]["con"]) ? $con[0]["con"] : $arcCon->oCon; $arcCon->dbTable = $arcCon->oCon; $arcCon->dbSchema = isset($con[0]["con"]) ? $con[0]["con"] : $arcCon->dbSchema; $arcCon->oUser = isset($con[0]["con_user"]) ? $con[0]["con_user"] : $arcCon->oUser; $arcCon->oPassword = isset($con[0]["con_password"]) && !empty($con[0]["con_password"]) ? decrypt($con[0]["con_password"]) : $arcCon->oPassword; $arcCon->oHost = isset($con[0]["con_host"]) ? $con[0]["con_host"] : $arcCon->oHost; $arcCon->oPort = isset($con[0]["con_port"]) ? $con[0]["con_port"] : $arcCon->oPort; $arcCon->oOptions = isset($con[0]["con_options"]) ? $con[0]["con_options"] : $arcCon->oOptions; $arcCon->dbType = isset($con[0]["con_db_tp"]) ? $con[0]["con_db_tp"] : $arcCon->dbType; /*Make Connection*/ if ($arcCon->oCon == "" | $arcCon->dbType == "") { die; } switch ($arcCon->dbType) {
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"; require_once "_includes/optionstoolbar.php"; /**************************************************/ $arcdb = new ArcDb(); $arcdb->dbConStr = $globalDBCON; $arcdb->dbType = $globalDBTP; $arcdb->dbSchema = $globalDB; /**************************************************/ $arcdb->sql = "\nSELECT \nid_con_db_tp,\ncon_db_tp_alias\nFROM _con_db_tp\n"; $arcdb->getRec(); $dbtypes = $arcdb->dbData; /**************************************************/ $enabledBoo = array(array(1, "Enable"), array(0, "Disable")); $conFields = array(array(array('Friendly Name', 'con_alias', null, 0), array('Database Type', 'id_con_db_tp', null, 1, $dbtypes), array('Status', 'con_enabledbit', null, 4, $enabledBoo, 0)), array(array('Database', 'con', null, 0), array('Table Schema', 'con_catalog', null, 0, null)), array(array('Username', 'con_user', null, 0), array('Password', 'con_password', null, 7)), array(array('Host', 'con_host', null, 0), array('Port', 'con_port', null, 0)), array(array('Options', 'con_options', null, 6))); ?> <script type="text/javascript">$(".icoadd").remove();</script> <form method="post" name="dbcon" id="dbcon" action="javascript:submitFrmVals('content','/_mod/smod_22/sql.php',null,'&form=dbcon&action=insert','dbcon')"> <fieldset id="database_connection"> <legend>Database Connection</legend>
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 "config.php"; require $serverrootpath . "_lib/php/bootstrap/ArcCore.php"; require $serverrootpath . "_lib/php/bootstrap/ArcDb.php"; $gdbo = new ArcDb(); $gdbo->dbConStr = $globalDBCON; $gdbo->dbType = $globalDBTP; $SOURCE = "_bifrost"; $DESTINATION = $globalDB; $LASTNAME = "Administrator"; $FIRSTNAME = "System"; $PASSWORD = "******"; $RECOVERYEMAIL = "*****@*****.**"; $USERNAME = "******"; $COMPANY = "Your Company Name"; $BRANCH = "Headquarters"; $gdbo->debug = true; $gdbo->dbSchema = $DESTINATION; $gdbo->sql = "SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_SCHEMA='{$DESTINATION}'"; $gdbo->getRec();
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"; $curYear = date('Y', strtotime($dtTimeCurrent)); $curMonth = date('n', strtotime($dtTimeCurrent)); $dayCount = cal_days_in_month(CAL_GREGORIAN, $curMonth, $curYear); $start = strtotime("{$curYear}-{$curMonth}-1 00:00:00 "); $end = strtotime("{$curYear}-{$curMonth}-{$dayCount} 23:59:59"); $arc = new ArcDb(); $arc->dbConStr = $globalDBCON; $arc->dbOffset = 0; $arc->dbType = $globalDBTP; $arc->dbSchema = $globalDB; if (isset($_POST["start_date"]) && isset($_POST["end_date"])) { $start = strtotime($_POST["start_date"]); $end = strtotime($_POST["end_date"]); } $daterange = "{$start} and {$end}"; $daterangeFriendly = date('F j, Y', $start) . " through " . date('F j, Y', $end); $filter = $start != "" ? "where UNIX_TIMESTAMP(a.srv_dc)+{$gmtOffset} between " . $daterange : ""; $arc->sql = "\nSELECT * FROM(\nSELECT\nFROM_UNIXTIME(UNIX_TIMESTAMP(a.srv_dc)+{$gmtOffset},'%m-%d-%y') name,\ncount(id_srv) as data\nFROM _srv a {$filter} group by name order by name desc) as derived WHERE data >=1"; $arc->getRec(); $arcData = $arc->getAssociative(); $arcJSON = json_encode($arcData);
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"; $ajCfgDevice = null; $ajCfgDevice = isset($_POST["id_cfg_device"]) ? "&id_cfg_device=" . $_POST["id_cfg_device"] : ""; $ajCfgDevice .= isset($_POST["id_device"]) ? "&id_device=" . $_POST["id_device"] : ""; $ajCfgDevice .= isset($_POST["id_cfg"]) ? "&id_cfg=" . $_POST["id_cfg"] : ""; /**************************************************/ $netgroup = new ArcDb(); $netgroup->dbConStr = $globalDBCON; $netgroup->dbType = $globalDBTP; $netgroup->dbSchema = $globalDB; $netgroup->sql = "SELECT id_cfg_device_netgroup,cfg_device_netgroup from _cfg_device_netgroup order by cfg_device_netgroup"; $netgroup->getRec(); $listnetgroup = $netgroup->dbData; /**************************************************/ $netgroup->sql = "\nSELECT \ninet_ntoa(a.cfg_device_ip4netaddress) as \"Network\",\na.cfg_device_ip4netaddress_nmbits as \"Netmask\",\na.id_cfg_device_netgroup,\nb.cfg_device_netgroup\nFROM _cfg_device_ip4netaddress a\nINNER JOIN _cfg_device_netgroup b\nON a.id_cfg_device_netgroup=b.id_cfg_device_netgroup \nWHERE cfg_device_ip4netaddress_enabled=1"; $netgroup->getRec(); $listnetwork = $netgroup->dbData; echo "<script type='text/javascript'>window.listNetwork=" . json_encode($listnetwork) . ";</script>"; /**************************************************/ $buttonAdd = '<div class="elementIconBox" onclick="prepSaveChanges(\'frmNetGroup\')"><i class="fa fa-plus"></i></div>'; $mnunetgroup = array(array(array("Network Group", "cfg_device_netgroup", "class=\"elementIcon\"", 0, null, null, null, $buttonAdd, null, 'Network Group'))); /**************************************************/
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"; $dbo = new ArcDb(); $dbo->dbConStr = $globalDBCON; $dbo->dbType = $globalDBTP; $dbo->dbSchema = $globalDB; $action = $_POST['action']; $form = $_POST['form']; $formAction = $form . "," . $action; # POST variables $ajCfgDevice = null; $ajCfgDevice = isset($_POST["id_cfg_device"]) ? "&id_cfg_device=" . $_POST["id_cfg_device"] : ""; $ajCfgDevice .= isset($_POST["id_device"]) ? "&id_device=" . $_POST["id_device"] : ""; $ajCfgDevice .= isset($_POST["id_cfg"]) ? "&id_cfg=" . $_POST["id_cfg"] : ""; $_POST["cfg_device_du"] = $dtTimeUTC; $_POST["cfg_du"] = $dtTimeUTC; if ($form != "frmConfig" && $form != "frmDevice") { # Ajax actions
case 0: echo $_POST["id_srv_board_alt"]; if ($_POST["id_srv_board_alt"] != "") { $gdbo->dbTable = "_srv_board"; $gdbo->sql = "update _srv set id_srv_board=" . $_POST["id_srv_board_alt"] . " WHERE id_srv_board=" . $id_srv_board; $gdbo->execQuery(); } break; case 1: $service = new ArcDb(); $service->dbConStr = $globalDBCON; $service->dbType = $globalDBTP; $service->dbSchema = $globalDB; $service->dbTable = "_srv"; $service->deleteRec("id_srv_board=" . $id_srv_board); break; default: break; } $service = new ArcDb(); $service->dbConStr = $globalDBCON; $service->dbType = $globalDBTP; $service->dbSchema = $globalDB; $service->dbTable = "_srv_board"; $service->deleteRec("id_srv_board=" . $id_srv_board); require "index.php"; break; } ?> <script type="text/javascript">clearPop();</script>