Code: Select all
$jsonID = $_GET['i'];
// step 1 - additional variables required for document link
$type = $_GET['type']; // variable to identify type of docuemnt
$recordID = $_GET['ID']; // ID of the record
// step -2 use nuID() to generate unique file name
$fileID = nuID();
$c = "'";
$J = nuGetJSONData($jsonID);
$TABLE_ID = nuTT();
$JSON = json_decode($J);
$LAYOUT = json_decode($JSON->sre_layout);
$hashData = nuAddToHashList($JSON, 'report');
$hashData['TABLE_ID'] = $TABLE_ID;
$GLOBALS['TABLE_ID'] = $TABLE_ID;
$_POST['nuHash'] = $hashData;
$PDF = new TCPDF($LAYOUT->orientation, 'mm', $LAYOUT->paper, true, 'UTF-8', false);
$PDF->SetAutoPageBreak(true);
$REPORT = nuSetPixelsToMM($LAYOUT);
$PDF->SetMargins(1,1,1);
$fl = json_decode(nuFontList());
for($i = 0 ; $i < count($fl) ; $i++){
$fnt = $fl[$i][0];
$PDF->AddFont($fnt, '', '', true);
}
$justID = strstr($JSON->parentID, ':');
nuBuildTempTable($JSON->parentID, $TABLE_ID);
$GLOBALS['nu_columns'] = nuAddCriteriaValues($hashData, $TABLE_ID);
nuRunQuery("ALTER TABLE $TABLE_ID ADD `nu__id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST");
nuBuildReport($PDF, $REPORT, $TABLE_ID);
$hashData['nu_pages'] = nuGetTotalPages();
nuReplaceLabelHashVariables($REPORT, $hashData);
nuPrintReport($PDF, $REPORT, $GLOBALS['nu_report'], $JSON);
nuRunQuery("DROP TABLE IF EXISTS $TABLE_ID");
nuRunQuery("DROP TABLE IF EXISTS $TABLE_ID".'_nu_summary');
// step -3 save pdf output to file
$PDF->Output('/volume1/web/nuBuilder/Reports/'.$fileID . '.pdf', 'F');
$PDF->Output('nureport.pdf', 'I');
// step 4 - generate document record
$filesql = 'INSERT INTO Document (DocumentID, DocumentType, DocumentEntityID, DocumentFileName, DocumentDate)
VALUES (' .$c. $fileID . $c.',' . $type . ',' . $c.$recordID .$c. ',' .$c. $fileID . '.pdf' .$c.',NOW())';
// run query
nuRunQuery($filesql);
nuRemoveFiles();
Code: Select all
function OnEstimateLetter()
{
var p = nuCurrentProperties();
var current = nuFORM.getCurrent();
var last = $.extend(true, {}, current);
last.session_id = window.nuSESSION;
last.call_type = 'runreport';
// step 5
last.form_id = 'EstLetter'; // report name
last.hash = nuHashFromEditForm();
var successCallback = function(data,textStatus,jqXHR)
{
var fm = data;
if(!nuDisplayError(fm))
{
// Step 6
var pdfUrl = 'nurunpdffile.php?i=' + fm.id + '&type=0&ID='+p.record_id; // open report added extra data variables
window.open(pdfUrl);
}
}
nuAjax(last,successCallback);
}