function getRecords() { if (is_null($this->filter) || is_null($this->id)) { return false; } $gdbo = new ArcDB(); $gdbo->dbConStr = $GLOBALS['globalDBCON']; $gdbo->dbType = $GLOBALS['globalDBTP']; $gdbo->dbSchema = $GLOBALS['globalDB']; $gdbo->sql = "\nSELECT \n_contact_method.id_contact_method_tp,\n_contact_method_tp.contact_method_tp_jsMap,\n_contact_method.contact_method,\n_contact_method.id_cust_branch,\n_contact_method.contact_method_notes\nFROM _contact_method\nLEFT JOIN _contact_method_tp \nON _contact_method.id_contact_method_tp = _contact_method_tp.id_contact_method_tp\nWHERE " . $this->filter . "=" . $this->id; $gdbo->getRec(); return $gdbo->getAssociative(); }
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'] != "") { $report .= $aRecordset_cols[$i]['name'] . ","; }