$this->Write(8, $str); } // Constructor function PDF_AccessReport() { parent::FPDF("P", "mm", $this->paperFormat); $this->_Font = "Courier"; $this->SetMargins(0, 0); $this->Open(); $this->Set_Char_Size(10); $this->AddPage(); $this->SetAutoPageBreak(false); } } // Instantiate the directory class and build the report. $pdf = new PDF_AccessReport(); // Read in report settings from database $rsConfig = mysql_query("SELECT cfg_name, IFNULL(cfg_value, cfg_default) AS value FROM config_cfg WHERE cfg_section='ChurchInfoReport'"); if ($rsConfig) { while (list($cfg_name, $cfg_value) = mysql_fetch_row($rsConfig)) { $pdf->{$cfg_name} = $cfg_value; } } // Get Deposit Information $sSQL = "SELECT * FROM deposit_dep WHERE dep_ID = " . $iDepositSlipID; $rsDepositSlip = RunQuery($sSQL); extract(mysql_fetch_array($rsDepositSlip)); $date1X = 12; $date1Y = 35 + 7; $date2X = 185; $date2Y = 90 + 7;
// Number of lines is only for the $text parameter function Add_Record($text, $numlines) { $numlines++; // add an extra blank line after record $this->Check_Lines($numlines); $_PosX = $this->_Margin_Left + $this->_Column * 108; $_PosY = $this->_Margin_Top + $this->_CurLine * 5; $this->SetXY($_PosX, $_PosY); $this->MultiCell(0, 5, $text); // set width to 0 prints to right margin $this->_CurLine += $numlines; } } // Instantiate the directory class and build the report. $pdf = new PDF_AccessReport(); // Read in report settings from database $rsConfig = mysql_query("SELECT cfg_name, IFNULL(cfg_value, cfg_default) AS value FROM config_cfg WHERE cfg_section='ChurchInfoReport'"); if ($rsConfig) { while (list($cfg_name, $cfg_value) = mysql_fetch_row($rsConfig)) { $pdf->{$cfg_name} = $cfg_value; } } // Fetch a new table consisting of first and last name from the // person_per table and last login from the user_usr table. $sSQL = "SELECT person_per.per_FirstName, person_per.per_LastName, user_usr.usr_LastLogin FROM person_per INNER JOIN user_usr ON person_per.per_ID = user_usr.usr_per_ID ORDER BY usr_LastLogin DESC"; $rsRecords = RunQuery($sSQL); while ($aRow = mysql_fetch_array($rsRecords)) { $OutStr = ''; extract($aRow); $OutStr = $pdf->sGetUserString($aRow);