Jump to content

create an ascii text file with php


irandoct

Recommended Posts

Hi,
I'm trying to output a text file using php. how may i set this file as ascii?
this is my code:

function export_listnm(){
  global $conn, $Language, $Security;
  $sdate = preg_replace('/-|:/', null, $_GET['sdate']);
  $edate = preg_replace('/-|:/', null, $_GET['edate']);
  $MedicalCouncilNumber = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'MedicalCouncilNumber'"));
  $NIDCode = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'NIDCode'"));
  $MainStaffName = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'MainStaffName'"));
  $MainStaffLastName = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'MainStaffLastName'"));
  $tedadnoskheh = ew_ExecuteScalar("SELECT COUNT(TreatmentID) FROM  treatmenthistory WHERE ReportDate >= '".$_GET['sdate']."' AND ReportDate <= '".$_GET['edate']."' AND InsuranceID = '".$_GET['insurance']."'");
  $sitename = ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'SiteName'");
  $insurance = ew_ExecuteScalar("SELECT InsuranceName FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $inscode = ew_ExecuteScalar("SELECT InsCode FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $cliniccode = ew_ExecuteScalar("SELECT ClinicCode FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $Percentage = ew_ExecuteScalar("SELECT Percentage FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $conn->Execute("SET @row_num = 0;");
  $sSqlWrk = "SELECT @row_num := @row_num + 1 as row_number, treatmenthistory.*, referrers.RefName, referrers.MedicalCouncil, patients.FullName, patients.gender FROM treatmenthistory join referrers on treatmenthistory.RefID = referrers.RefID join patients on treatmenthistory.PatientID = patients.PatientID WHERE treatmenthistory.ReportDate >= '".$_GET['sdate']."' AND treatmenthistory.ReportDate <= '".$_GET['edate']."' AND InsuranceID = '".$_GET['insurance']."' ORDER BY treatmenthistory.ReceptionDate ASC";
  $theres = $conn->Execute($sSqlWrk);
  if (!file_exists('insurancereports')) {
	mkdir('insurancereports', 0777, true);
  }
  $f = fopen("insurancereports/insurance.txt", "a");
  fwrite($f, "<Y>\n");
  fwrite($f, "<HR>\n");
  fwrite($f, "<DC>".$cliniccode."</DC>\n");
  fwrite($f, "<DN>".$sitename."</DN>\n");
  fwrite($f, "<CR>kimia System 09133999236</CR>\n");
  fwrite($f, "<RC>".$tedadnoskheh."</RC>\n");
  fwrite($f, "<FD>".$sdate."</FD>\n");
  fwrite($f, "<TD>".$edate."</TD>\n");
  fwrite($f, "<MC>".$MedicalCouncilNumber."</MC>\n");
  fwrite($f, "<NM>".$NIDCode."</NM>\n");
  fwrite($f, "<AN>".$MainStaffName."</AN>\n");
  fwrite($f, "<AF>".$MainStaffLastName."</AF>\n");
  fwrite($f, "</HR>\n");
  while (!$theres->EOF) {
  $row = ew_ExecuteRow("SELECT SUM(ExPriceIns) AS ExPriceIns FROM treatmentdetails  WHERE TreatmentID = '".$theres->fields('TreatmentID')."'");
  $fullprice = $row["ExPriceIns"];
  $patientprice = $fullprice * $Percentage /100;
  $insprice = $fullprice - $patientprice;
  if ($theres->fields('gender') == "F"){
  $gender = "0";
  }else if ($theres->fields('gender') == "M"){
  $gender = "1";
  }
  $orderdate = preg_replace('/-|:/', null, $theres->fields('InsOrderDate'));
  $insuranceenddate = preg_replace('/-|:/', null, $theres->fields('InsEndDate'));
  $firstsession = ew_ExecuteScalar("SELECT VisitDay FROM appointments WHERE TreatmentID = '".$theres->fields('TreatmentID')."' AND IsCanceled = 'N' ORDER BY VisitDay ASC LIMIT 1");
  $firstsession = preg_replace('/-|:/', null, $firstsession);
  $lastsession = ew_ExecuteScalar("SELECT VisitDay FROM appointments WHERE TreatmentID = '".$theres->fields('TreatmentID')."' AND IsCanceled = 'N' ORDER BY VisitDay DESC LIMIT 1");
  $lastsession = preg_replace('/-|:/', null, $lastsession);
  fwrite($f, "<X>\n");
  fwrite($f, "<PH>\n");
  fwrite($f, "<SQ>".$theres->fields('row_number')."</SQ><ND>".$orderdate."</ND><RD>".$firstsession."</RD><LD>".$lastsession."</LD><VD>".$insuranceenddate."</VD><PT>".$inscode."</PT><SN>".$theres->fields('InsuranceNumber')."</SN><GR>".$gender."</GR><RN>".$theres->fields('InsPageNumber')."</RN><PG>1</PG><PC>".$theres->fields('MedicalCouncil')."</PC><DD>18</DD><PP>".$fullprice."</PP><IS>".$insprice."</IS><PS>".$patientprice."</PS>\n");
  fwrite($f, "</PH>\n");
  $sSqlWrk2 = "SELECT treatmentdetails.*, products.ProductCode FROM treatmentdetails join products on treatmentdetails.ProductID = products.ProductID WHERE treatmentdetails.TreatmentID = '".$theres->fields('TreatmentID')."' AND treatmentdetails.ShowInList = 'Y'";
  $theres2 = $conn->Execute($sSqlWrk2);
  while (!$theres2->EOF) {
  $sahmbimeh = $theres2->fields('ExPriceIns') * $Percentage / 100;
  $sahmbimar  = $theres2->fields('ExPriceIns') - $sahmbimeh;
  fwrite($f, "<MH><MG>".$theres2->fields('ProductCode')."</MG><OZ></OZ><NG>".$theres2->fields('Quantity')."</NG><NA>".$theres2->fields('BodyAreaIns')."</NA><FC>".$MedicalCouncilNumber."</FC><TK>1</TK><MD>".$theres2->fields('Quantity')."</MD><MR>".$theres2->fields('Quantity')."</MR><MP>".$theres2->fields('ExPriceIns')."</MP><MI>".$sahmbimeh."</MI><MS>".$sahmbimar."</MS></MH>\n");
  $theres2->MoveNext();
}
$theres2->Close();
  fwrite($f, "<BY>\n");
  fwrite($f, "</BY>\n");
  fwrite($f, "</X>\n");
  $theres->MoveNext();
}
$theres->Close();
fwrite($f, "</Y>\n");
fclose($f);
echo "<br><br>";
echo "<a href=insurancereports/insurance.txt>Download</a>";
echo "<br><br><br><br>";
} 

please help me save the text file as ascii!

Thank you 

Mansour

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.