php script to create pdf
$30-50 USD
Đã đăng vào hơn 13 năm trước
$30-50 USD
Thanh toán khi bàn giao
I have a php page that is working!? but i have to open it in a browser.? If i try to launch it from a scheduled task it opens the page in notepad??? I need to convert my php page into a php script that I can execute as a scheduled task and run it every few min (in the backround).? ?
## Deliverables
Here is my current php pag
<?php session_start();
include "[login to view URL]";
require('fpdf/[login to view URL]');
$sql_values_fetch_selection = mysql_fetch_array(mysql_query("select * from selection where 1"));
$lutime=$sql_values_fetch_selection['time'];
//$sql="select * from hl7segobx where utime>'$lutime'";
$sql="select uuid,
(select value from hl7segobx where setid = 6 and uuid = [login to view URL]) as exam,
(select value from hl7segobx where setid = 10 and uuid = [login to view URL]) as comparison,
(select value from hl7segobx where setid = 14 and uuid = [login to view URL]) as finding,
(select value from hl7segobx where setid = 18 and uuid = [login to view URL]) as impression
from hl7segobx s where processed = 0
group by uuid";
$result = mysql_query($sql);
while($sql_values_fetch_hl7segobx = mysql_fetch_array($result)) {
? ? $uuid=$sql_values_fetch_hl7segobx['uuid'];
? ? //seperate strings for impressing and findings.
? ? $comparison=$sql_values_fetch_hl7segobx['comparison'];
? ? $exam=$sql_values_fetch_hl7segobx['exam'];
? ? $finding=$sql_values_fetch_hl7segobx['finding'];
? ? $impression=$sql_values_fetch_hl7segobx['impression'];
? ? $sql_values_fetch_hl7segobr = mysql_fetch_array(mysql_query("select * from hl7segobr where uuid = '$uuid'"));
? ? $principalinterpreter= preg_replace("/\^+/", " ", $sql_values_fetch_hl7segobr['principalinterpreter']);
? ? $observationend=$sql_values_fetch_hl7segobr['observationend'];
? ? $placerordernum=$sql_values_fetch_hl7segobr['placerordernum'];
? ? $sql_values_fetch_study = mysql_fetch_array(mysql_query("select * from study where accessionnum = '$placerordernum'"));
? ? $patientid=$sql_values_fetch_study['patientid'];
? ? $studydate=$sql_values_fetch_study['studydate'];
? ? $description=$sql_values_fetch_study['description'];
? ? $sql_values_fetch_worklist = mysql_fetch_array(mysql_query("select * from worklist where accessionnum = '$placerordernum'"));
? ? $description2=$sql_values_fetch_worklist['admittingdiagnoses'];
? ? $physician= preg_replace("/\^+/", " ", $sql_values_fetch_study['referringphysician']);
? ? $sql_values_fetch_patient = mysql_fetch_array(mysql_query("select * from patient where origid = '$patientid'"));
? ? $fname=$sql_values_fetch_patient['lastname'];
? ? $lname=$sql_values_fetch_patient['firstname'];
? ? $mname=$sql_values_fetch_patient['middlename'];
? ? $pfx=$sql_values_fetch_patient['prefix'];
? ? $sfx=$sql_values_fetch_patient['suffix'];
? ? $institution=$sql_values_fetch_patient['institution'];
? ? $birthdate=$sql_values_fetch_patient['birthdate'];
? ? $studyuuid = $sql_values_fetch_study["uuid"];
? ? $studyreviewed = $sql_values_fetch_study["reviewed"];
? ?
? ? if(!$institution) $institution=' ';
? ? if(!$birthdate) $birthdate=' ';
? ? if(!$patientid) $patientid=' ';
? ? if(!$studydate) $studydate=' ';
? ? if(!$description) $description=' ';
? ? if(!$physician) $physician=' ';
? ? if(!$value) $value=' ';
? ? if(!$principalinterpreter) $principalinterpreter=' ';
? ? if(!$observationend) $observationend=' ';
? ? if(!$technologist) $technologist=' ';
? ?
? ? $patientName = array(0=>$fname, 1=>$lname, 2=>$mname, 3=>$pfx, 4=>$sfx);
? ?
? ?
? ? $pdf=new PDF();
? ? $pdf->AddPage();
?
? ? $html='<table border="0">
? ? <tr>
? ? <td height="10"> </td>
? ? </tr>
? ? <tr>
? ? <td width="70" height="30">PATIENT: </td>
? ? <td width="280" height="30">' . preg_replace("/(\s*,\s*)*$/", "", implode(", ", $patientName)) .'</td>
? ? <td width="125" height="30">REFERRING MD: </td>
? ? <td width="175" height="30">' . $physician . '</td></tr>
? ? <tr>
? ? <td height="10"> </td>
? ? </tr>
? ? <tr>
? ? <td width="70" height="30">DOB: </td>
? ? <td width="280" height="30">'. date ('m/d/y', strtotime ($birthdate)) . '</td>
? ? <td width="140" height="30">INTERPRETING MD: </td>
? ? <td width="160" height="30">'. $principalinterpreter . '</td></tr>
? ? <tr>
? ? <td height="10"> </td>
? ? </tr>
? ? <tr>
? ? <td width="70" height="30">DOS: </td>
? ? <td width="280" height="30">'. date ('m/d/y', strtotime ($studydate)) . '</td>
? ? <td width="125" height="30"></td>
? ? <td width="175" height="30">'. $technologist . '</td></tr>
? ? <tr>
? ? <td height="10"> </td>
? ? </tr>
? ? <tr>
? ? <td width="70" height="30">STUDY: </td>
? ? <td width="280" height="30">'. $description . '</td>
? ? <td width="125" height="30">FACILITY: </td>
? ? <td width="175" height="30">'. $institution . '</td></tr>
? ? <tr>
? ? <td height="50"> </td>
? ? </tr>
? ? <tr>
? ? <td width="60" height="30">Dear </td>
? ? <td width="125" height="30">'. $physician . '</td>
? ? <td width="100" height="30">, </td>
? ? </tr>
? ? <tr>
? ? <td height="16"> </td>
? ? </tr>
? ? <tr>
? ? <td width="125" height="30">Reason For Study: </td>
? ? <td width="270" height="30">'. $description2 . '</td>
? ? </tr>
? ? <tr>
? ? <td height="30"> </td>
? ? </tr>
? ? <tr>
? ? <td width="125" height="30">Comparison: </td>
? ? <td width="270" height="30">'. $comparison . '</td>
? ? </tr>
? ? <tr>
? ? <td height="30"> </td>
? ? </tr>
? ? <tr>
? ? <td width="125" height="30">Exam: </td>
? ? <td width="270" height="30">'. $exam . '</td>
? ? </tr>
? ? <tr>
? ? <td height="40"> </td>
? ? </tr>
? ? </table>
? ?
? ?
? ? <div>'. $finding .'</div>
? ?
? ?
? ?
? ? <table>
? ? <tr>
? ? <td height="30"> </td>
? ? </tr>
? ? <tr>
? ? <td height="30"> </td>
? ? </tr>
? ? <tr>
? ? <td width="125" height="30">Impression: </td>
? ? </tr>
? ? </table>
? ?
? ?
? ? <div>'. $impression . '</div>
? ?
? ?
? ? <table>
? ? <tr>
? ? <td height="360"> </td>
? ? </tr>
? ? <tr>
? ? <td width="210" height="30">Thank you for allowing BUFFALO ULTRASOUND to participate in the care of this patient.</td>
? ? </tr>
? ? <tr>
? ? <td width="210" height="30">Should you have any questions concerning this report or study performed, please do not hesitate to contact us.</td>
? ? </tr>
? ? <tr>
? ? <td height="30"> </td>
? ? </tr>
? ? <tr>
? ? <td width="210" height="30">Very truly yours,</td>
? ? </tr>
? ? <tr>
? ? <td width="210" height="30">Buffalo Ultrasound, IDTF</td>
? ? </tr>
? ? <tr>
? ? <td height="30"> </td>
? ? </tr>
? ? <tr>
? ? <td width="100" height="30">E-SIGNED BY </td>
? ? <td width="310" height="30">';
? ? $html.=$principalinterpreter;
? ? $html.='</td>
? ? <td width="30" height="30">ON: </td>
? ? <td width="200" height="30">';
? ? $html.=date ('m/d/y', strtotime ($observationend));
? ? $html.='</td>
? ? </tr>
? ? <tr>
? ? <td height="10"> </td>
? ? </tr>
? ? <tr>
? ? <td width="230" height="30"> </td>
? ? <td height="20" align="center">Board Certified Radiologist</td>
? ? </tr>
? ? ';
? ? $html.='</tr>
? ? </table>';
?
? ? $htmla='<table border="0">
? ? <tr>
? ? <td width="90" height="30"> Patient Name: </td>
? ? <td width="185" height="30">';
? ? $htmla.=$fname . ", " . $lname;
? ? $htmla.='</td>
? ? <td width="40" height="30"> DOB :? </td>
? ? <td width="100" height="30">';
? ? $htmla.=date ('m/d/y', strtotime ($birthdate));
? ? $htmla.='</td>
? ? <td width="40" height="30"> DOS :? </td>
? ? <td width="200" height="30">';
? ? $htmla.=date ('m/d/y', strtotime ($studydate));
? ? $htmla.='</td>
? ? <td width="70" height="30"> Page 1 of 1 </td>
? ? ';
? ? $htmla.='</tr>
? ? </table>';
?
? ? $pdf->Image('[login to view URL]',15,10,83, 16);
? ? //Arial bold 15
? ? $pdf->Ln(17);
? ? $pdf->SetFont('Times','B',10);
? ? $pdf->WriteHTML($html);
? ? $pdf->Image('[login to view URL]',10,220,190,48);
? ? $pdf->Ln(48? );
? ? $pdf->SetFont('Times','B',10);
? ? $pdf->WriteHTML($htmla);
?
?
? ? $dest="pdf/";
? ? $filename = $dest . $studyuuid . ".pdf";
? ? $pdf->Output($filename,'F');
? ? $pdf->Close();
? ? mysql_query("update hl7segobx set processed = 1 where uuid = '" . $uuid . "'");
? ? mysql_query("update study set reviewed = 'KRG' where uuid = '" . $studyuuid . "'");
? }
//function formatschstdate($dDate){
//$dNewDate = strtotime($dDate);
//return date('Y/m/d',$dNewDate);
//}
//$schdate=formatschstdate($time);
$curtime=date("Y-m-d H:i:s",time() + 1);
$sql_update? = mysql_query("update selection set
time='".strtoupper(strip_tags(addslashes($curtime)))."'
where 1") or die (mysql_error());
?>
?
Mã dự án: 3609425
Về dự án
4 đề xuất
Dự án từ xa
Hoạt động 14 năm trước
Bạn muốn kiếm tiền?
Lợi ích khi chào giá trên Freelancer
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
4 freelancer chào giá trung bình $30 USD cho công việc này
$42,50 USD trong 14 ngày
5,0 (46 nhận xét) $38,25 USD trong 14 ngày
4,7 (13 nhận xét) $17 USD trong 14 ngày
0,0 (1 nhận xét)