76 lines
2.8 KiB
PHP
76 lines
2.8 KiB
PHP
<?php
|
|
if (!empty($documentlist->getColumnVal("idfileattached"))) {
|
|
if ($sndrpt=='N') {
|
|
//$pdf->Output(); second module
|
|
$filepathname=$trfData['trfnumber']."applicationform".".pdf";
|
|
$filename="pdf/".$filepathname;
|
|
$pdf->Output($filename,'F');
|
|
|
|
$UpdateQuery = new WA_MySQLi_Query($cmctrfdb);
|
|
$UpdateQuery->Action = "update";
|
|
$UpdateQuery->Table = "`trf-details`";
|
|
$UpdateQuery->bindColumn("pdffilename", "s", "$filepathname", "WA_DEFAULT");
|
|
$UpdateQuery->bindColumn("zipname", "s", "$zipnamefile", "WA_DEFAULT");
|
|
$UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) ."");
|
|
$UpdateQuery->execute();
|
|
$UpdateGoTo = "";
|
|
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
|
|
$UpdateQuery->redirect($UpdateGoTo);
|
|
|
|
} else {
|
|
//$pdf->Output(); first module
|
|
$filepathname=$trfData['trfnumber']."applicationformb".".pdf";
|
|
$filename="pdf/".$filepathname;
|
|
$pdf->Output($filename,'F');
|
|
|
|
$UpdateQuery = new WA_MySQLi_Query($cmctrfdb);
|
|
$UpdateQuery->Action = "update";
|
|
$UpdateQuery->Table = "`trf-details`";
|
|
$UpdateQuery->bindColumn("pdffilename2", "s", "$filepathname", "WA_DEFAULT");
|
|
$UpdateQuery->bindColumn("zipname", "s", "$zipnamefile", "WA_DEFAULT");
|
|
$UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) ."");
|
|
$UpdateQuery->execute();
|
|
$UpdateGoTo = "";
|
|
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
|
|
$UpdateQuery->redirect($UpdateGoTo);
|
|
|
|
|
|
|
|
}} else {
|
|
if ($sndrpt=='N') {
|
|
//$pdf->Output(); second module
|
|
$filepathname=$trfData['trfnumber']."applicationform".".pdf";
|
|
$filename="pdf/".$filepathname;
|
|
$pdf->Output($filename,'F');
|
|
|
|
$UpdateQuery = new WA_MySQLi_Query($cmctrfdb);
|
|
$UpdateQuery->Action = "update";
|
|
$UpdateQuery->Table = "`trf-details`";
|
|
$UpdateQuery->bindColumn("pdffilename", "s", "$filepathname", "WA_DEFAULT");
|
|
|
|
$UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) ."");
|
|
$UpdateQuery->execute();
|
|
$UpdateGoTo = "";
|
|
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
|
|
$UpdateQuery->redirect($UpdateGoTo);
|
|
|
|
} else {
|
|
//$pdf->Output(); first module
|
|
$filepathname=$trfData['trfnumber']."applicationformb".".pdf";
|
|
$filename="pdf/".$filepathname;
|
|
$pdf->Output($filename,'F');
|
|
|
|
$UpdateQuery = new WA_MySQLi_Query($cmctrfdb);
|
|
$UpdateQuery->Action = "update";
|
|
$UpdateQuery->Table = "`trf-details`";
|
|
$UpdateQuery->bindColumn("pdffilename2", "s", "$filepathname", "WA_DEFAULT");
|
|
|
|
$UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) ."");
|
|
$UpdateQuery->execute();
|
|
$UpdateGoTo = "";
|
|
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
|
|
$UpdateQuery->redirect($UpdateGoTo);
|
|
|
|
|
|
}}
|
|
?>
|