code_junkie

Format text in Excel file via PHP

Nov 12th, 2011
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.81 KB | None | 0 0
  1. <table>
  2. <tr><th>Column 1</th><th>Column 2</th></tr>
  3. <tr><td style="font-size:200%">Answer 1</td><td style="color:#f00">Answer 2</td></tr>
  4. <tr><td colspan="2" style="font-weight:bold">Answer 3 with 2 columns</td></tr>
  5. </table>
  6.  
  7. <?php
  8. include '../include/config.php';
  9. $sql = "SELECT SQL_CALC_FOUND_ROWS
  10. ".DB_TBL_TUTORS_RECAPS.".id,
  11. ".DB_TBL_TUTORS_RECAPS.".date_of_tutoring_session,
  12. ".DB_TBL_TUTORS_RECAPS.".created,
  13. ".DB_TBL_TUTORS_RECAPS.".hours_tutored,
  14. ".DB_TBL_TUTORS_RECAPS.".billable_travel,
  15. ".DB_TBL_TUTORS_RECAPS.".billable_additional,
  16. ".DB_TBL_TUTORS_RECAPS.".type_of_tutoring,
  17. ".DB_TBL_TUTORS_RECAPS.".additional_comments,
  18. ".DB_TBL_TUTORS_RECAPS.".total_billable,
  19. ".DB_TBL_TUTORS_RECAPS.".materials_covered_during_session,
  20. ".DB_TBL_TUTORS_RECAPS.".next_scheduled_session_location,
  21. ".DB_TBL_TUTORS_RECAPS.".rate,
  22. ".DB_TBL_TUTORS_RECAPS.".tutor_pay_rate,
  23. ".DB_TBL_APPLICANTS.".first_name as tutor_first_name,
  24. ".DB_TBL_APPLICANTS.".last_name as tutor_last_name,
  25. ".DB_TBL_PIPELINE.".tutor_match_notes,
  26. ".DB_TBL_PIPELINE.".date_of_submission,
  27. ".DB_TBL_PIPELINE.".tutor_name,
  28. ".DB_TBL_PIPELINE.".tutor_id,
  29. ".DB_TBL_CLIENTS.".id as client_id,
  30. ".DB_TBL_CLIENTS.".first_name,
  31. ".DB_TBL_CLIENTS.".last_name,
  32. ".DB_TBL_CLIENTS.".location_name,
  33. ".DB_TBL_CLIENTS.".last_name,
  34. ".DB_TBL_CHILDREN.".id as child_id,
  35. ".DB_TBL_CHILDREN.".last_name as last,
  36. ".DB_TBL_CHILDREN.".first_name as first
  37. FROM
  38. ".DB_TBL_TUTORS_RECAPS."
  39. LEFT JOIN ".DB_TBL_PIPELINE." ON ".DB_TBL_PIPELINE.".id= ".DB_TBL_TUTORS_RECAPS.".pipeline_id
  40. LEFT JOIN ".DB_TBL_CHILDREN." ON ".DB_TBL_CHILDREN.".id= ".DB_TBL_TUTORS_RECAPS.".child_id
  41. LEFT JOIN ".DB_TBL_CLIENTS." ON ".DB_TBL_CLIENTS.".id= ".DB_TBL_TUTORS_RECAPS.".client_id
  42. LEFT JOIN ".DB_TBL_TUTORS." ON ".DB_TBL_TUTORS_RECAPS.".tutor_id= ".DB_TBL_TUTORS.".id
  43. LEFT JOIN ".DB_TBL_APPLICANTS." ON ".DB_TBL_APPLICANTS.".id= ".DB_TBL_TUTORS.".applicant_id
  44. WHERE
  45.  
  46.  
  47. " . DB_TBL_CLIENTS . ".status = 'Existing' AND
  48.  
  49. " . DB_TBL_APPLICANTS . ".status = 'Existing' AND
  50.  
  51. " . DB_TBL_PIPELINE . ".status = 'Existing' AND
  52. " . DB_TBL_TUTORS_RECAPS . ".is_deleted = '0'
  53. GROUP BY " . DB_TBL_TUTORS_RECAPS . ".id
  54. ORDER BY " . DB_TBL_TUTORS_RECAPS . ".created DESC ";
  55.  
  56. $totallogs = $db->query($sql);
  57. $filename = "Tutoring_Log.xls";
  58. $contents = "Recap# t Tutor Name t Client Name t Child Name t Type of tutoring t Date of Tutoring session t Hours tutored t Billable Travel t Billable Additional t Total Billable t Client Rate t Tutor Pay Rate t n";
  59. $contents .= " n";
  60.  
  61. while($tutorRecords = $db->fetchNextObject($totallogs)){
  62.  
  63. $contents .= "".$tutorRecords->id." t ".$tutorRecords->tutor_first_name.' '.$tutorRecords->tutor_last_name." t ".$tutorRecords->first_name.' '.$tutorRecords->last_name." t ".$tutorRecords->first.' '.$tutorRecords->last." t ".$globalsConstant['type_of_tutoring'][$tutorRecords->type_of_tutoring]." t ".date(MDY,$tutorRecords->date_of_tutoring_session)." t ".str_replace('.',':',$tutorRecords->hours_tutored)." t ".str_replace('.',':',$tutorRecords->billable_travel)." t ".str_replace('.',':',$tutorRecords->billable_additional)." t ".str_replace('.',':',$tutorRecords->total_billable)." t ".CURRENCY.$tutorRecords->rate." t ".CURRENCY.$tutorRecords->tutor_pay_rate." t n";
  64.  
  65. }
  66.  
  67. header('Content-type: application/ms-excel');
  68. header('Content-Disposition: attachment; filename='.$filename);
  69. echo $contents;
  70. ?>
Add Comment
Please, Sign In to add comment