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'] . ",";
}
