function getMethods() { $gdbo = new ArcDB(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "\nSELECT\na.id_contact_method_tp,\na.contact_method_tp,\nb.id_contact_method_tp_grp,\nb.contact_method_tp_grp\nFROM\n_contact_method_tp a\nJOIN\n_contact_method_tp_grp b ON a.id_contact_method_tp_grp=b.id_contact_method_tp_grp\nORDER BY contact_method_tp_grp,contact_method_tp\n"; $gdbo->getRec(); $results = $gdbo->dbData; return $results; }
function getContactMethods($id, $override = false) { $filter = $this->isBranch === false | $override === true ? "id_cust_contact" : "id_cust_branch"; $gdbo = new ArcDB(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "\nSELECT \n_contact_method.contact_method as method,\n_contact_method.contact_method\nFROM _contact_method\nLEFT JOIN _contact_method_tp \nON _contact_method.id_contact_method_tp = _contact_method_tp.id_contact_method_tp\nWHERE _contact_method_tp.id_contact_method_tp = 1 AND " . $filter . "=" . $id; $gdbo->getRec(); return $gdbo->dbData; }
Author: Carlos Omar Villanueva */ require_once "_lib/php/auth.php"; $dbo = new ArcDB(); $dboData = (array) json_decode(decrypt($_POST["DBO"])); unset($dboData["dbCols"]); unset($dboData["dbData"]); $inc = 1; $debug = 1; foreach ($dboData as $Column => $Data) { $comma = $inc != 1 ? "," : ""; $dbo->{$Column} = $Data; $inc = $inc + 1; } $dbo->dbLimit = null; $dbo->getRec(); $aRecordset_cols = $dbo->dbCols; $aRecordset = $dbo->getAssociative(); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header("Content-Disposition: attachment;filename=export.csv"); header("Content-Transfer-Encoding: binary "); $start = microtime(TRUE); set_time_limit(330); $report = ""; for ($i = 0; $i < count($aRecordset_cols); $i++) { if ($aRecordset_cols[$i]['name'] != "Action" && $aRecordset_cols[$i]['name'] != "") {