PageRenderTime 38ms CodeModel.GetById 11ms RepoModel.GetById 0ms app.codeStats 0ms

/applicationforms.php

https://bitbucket.org/mannir/agp
PHP | 173 lines | 169 code | 4 blank | 0 comment | 7 complexity | 673a601fb9240b6277a05747f87df132 MD5 | raw file
Possible License(s): LGPL-2.1 
    

  1. <?php 
    2. 

  2. global $url; if($_SERVER['HTTP_HOST']=='localhost') { $cn=mysql_connect("localhost","root",""); mysql_select_db("agpapp");
    3. 

  3. $url='http://localhost/agpapp/sites/all/modules/manniragp/'; }
    4. 

  4. else { $cn=mysql_connect("agpapp.db.8855061.hostedresource.com","agpapp","Customer13131"); mysql_select_db("agpapp");
    5. 

  5. global $url; $url='http://agpapp.esystems.me/sites/all/modules/manniragp/'; }
    6. 

  6. require_once('tcpdf/config/lang/eng.php');
    7. 

  7. require_once('tcpdf/tcpdf.php');
    8. 

  8. 

  9. if(isset($_REQUEST['from']) && isset($_REQUEST['to']) && isset($_REQUEST['sortby'])) { $fr=$_REQUEST['from']; $to=$_REQUEST['to']; $sb=$_REQUEST['sortby'];
    10. 

  10. 	$query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application` 
    11. 

  11. WHERE id>='$fr' AND id<='$to' ORDER BY '$sb'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; }
    12. 

  12. }
    13. 

  13. 

  14. else {
    15. 

  15. 	$o = (object) mysqli_fetch_assoc(mysqli_query($con,"SELECT max(id) as mxid FROM _application")); $mxid=$o->mxid;
    16. 

  16. $query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application` 
    17. 

  17. WHERE id>=1 AND id<='$mxid'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; }
    18. 

  18. }
    19. 

  19. 

  20. 

  21. class MYPDF extends TCPDF { 
    22. 

  22. 	public function Header() { global $uid; global $url; 
    23. 

  23. 	$url='/sites/default/files/pictures/'; if($_SERVER['HTTP_HOST']=='localhost'){ $url='agp\sites\default\files\pictures\\'; }
    24. 

  24. 	$p = (object) mysqli_fetch_assoc(mysqli_query($con,"SELECT filename FROM file_managed WHERE fid=(SELECT picture FROM users WHERE uid='$uid')"));
    25. 

  25. 	$this->Image('logo.jpg', 10, 10, 25, '', 'JPG', '', 'T', false, 300, '', false, false, 0, false, false, false);
    26. 

  26. 

  27. 	$filename = '../../../default/files/pictures/'.$p->filename;
    28. 

  28. 	$jpg=stristr($p->filename,".jpg"); $png=stristr($p->filename,".png"); if(isset($png)) { $tp='PNG'; } if(isset($jpg)) { $tp='JPG'; } 
    29. 

  29. 	//if (file_exists($filename)) { $this->Image($filename,175,10,25,25,$tp,'','R',false,300,'',false,false,0,false,0,false,false,false); }
    30. 

  30. if(stristr($filename,$p->filename)!='') { 
    31. 

  31. $this->Image($filename,175,10,25,25,'','','R',false,300,'',false,false,0,false,0,false,false,false);
    32. 

  32. //$this->Image($filename, 0, 0, '', '', '', '', '', false, 300, '', false, false, 0);
    33. 

  33. 

  34.  }	
    35. 

  35. 

  36. 	$this->SetFont('helvetica', 'B', 18);
    37. 

  37. 	$this->SetY(10); $this->Cell(0, 15, 'ABDU GUSAU POLYTECHNIC, P.M.B. 1021', 0, false, 'C', 0, '', 0, false, 'M', 'M');
    38. 

  38. 	$this->SetY(17); $this->Cell(0, 15, 'TALATA-MAFARA. ZAMFARA STATE', 0, false, 'C', 0, '', 0, false, 'M', 'M');
    39. 

  39. 	$this->SetY(25); $this->Cell(0, 15, 'ONLINE APPLICATION FORM', 0, false, 'C', 0, '', 0, false, 'M', 'M');
    40. 

  40. 	}
    41. 

  41. 

  42. 	public function Footer() {
    43. 

  43. 		$this->SetY(-10);
    44. 

  44. 		$this->SetFont('helvetica', 'I', 8);
    45. 

  45. 		$this->Cell(0, 10, 'ABDU GUSAU POLYTECHNIC, TALATA-MAFARA, ZAMFARA STATE, System Developed By MANNIR ESYSTEMS LIMITED 2012 (www.mannir.net)', 0, 
    46. 

  46. 			false, 'C', 0, '', 0, false, 'T', 'M');
    47. 

  47. //		$this->Cell(0, 10, 'Page '.$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, false, 'C', 0, '', 0, false, 'T', 'M');
    48. 

  48. 	}}
    49. 

  49. 

  50. 

  51. $pdf = new MYPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
    52. 

  52. $pdf->SetCreator(PDF_CREATOR);
    53. 

  53. $pdf->SetAuthor('MUHAMMAD MANNIR AHMAD');
    54. 

  54. $pdf->SetTitle('ABDUGUSAU POLYTECHNIC TALATA MAFARA: Online Application Form');
    55. 

  55. $pdf->SetSubject('Application Form');
    56. 

  56. $pdf->SetKeywords('Mannir, Mannir.com, eapplication');
    57. 

  57. $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
    58. 

  58. $pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
    59. 

  59. $pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
    60. 

  60. $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
    61. 

  61. $pdf->SetMargins(10, 10, 10);
    62. 

  62. $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
    63. 

  63. $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
    64. 

  64. $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
    65. 

  65. $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
    66. 

  66. $pdf->setLanguageArray($l);
    67. 

  67. //$pdf->SetFont('times', 'BI', 12);
    68. 

  68. $pdf->SetDisplayMode('fullpage', 'SinglePage', 'UseNone');
    69. 

  69. $pdf->SetFont('times', 'B', 10);
    70. 

  70. foreach($ar as $k=>$v) {
    71. 

  71. session_start(); error_reporting(0);	global $uid; $uid=$ar[$k]['uid']; //$uid = $_REQUEST['uid']; 
    72. 

  72. $a = (object) mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM _application WHERE uid='$uid'"));
    73. 

  73. $ap = (object) mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM _application WHERE uid='$uid'"));
    74. 

  74. $sc=explode(',',$a->schoolinfo); $s1=explode(':',$sc[0]); $s2=explode(':',$sc[1]); $s3=explode(':',$sc[2]);	$s4=explode(':',$sc[3]);
    75. 

  75. $s5=explode(':',$sc[4]); $e1=explode(',',$ap->examinfo1); $ee1=explode(':',$e1[0]);	$e2=explode(',',$ap->examinfo2); $ee2=explode(':',$e2[0]);
    76. 

  76. 

  77. $pdf->AddPage('P', 'A4');
    78. 

  78. 

  79. $pdf->SetY(35); $pdf->Write(0, 'APPLICATION INFORMATION', '', 0, 'C', true, 0, false, false, 0);
    80. 

  80. $pdf->SetY(40); $pdf->Cell(100, 0, 'User ID: '.$a->uid,1);
    81. 

  81. $pdf->SetY(40); $pdf->SetX(115); $pdf->Cell(85, 0, 'Application No: '.$a->appno, 1);
    82. 

  82. $pdf->SetY(46); $pdf->Cell(100, 0, 'Fullname: '.$a->fullname, 1);
    83. 

  83. $pdf->SetY(46); $pdf->SetX(115); $pdf->Cell(85,0,'Gender: '.$a->gender,1,1,'L');
    84. 

  84. $pdf->SetY(52); $pdf->Cell(100, 0, 'Date of Birth: '.$a->dob, 1);
    85. 

  85. $pdf->SetY(52); $pdf->SetX(115); $pdf->Cell(85, 0, 'Religion: '.$a->religion, 1);
    86. 

  86. $pdf->SetY(58); $pdf->Cell(100, 0, 'Marital Status: '.$a->maritalstatus, 1, 1,'','','',FALSE);
    87. 

  87. $pdf->SetY(58); $pdf->SetX(115); $pdf->Cell(85,0,'Bloog Group: '.$a->bloodgroup,1);
    88. 

  88. $pdf->SetY(64); $pdf->Cell(100, 0, 'Addres: '.$a->address,1);
    89. 

  89. $pdf->SetY(64); $pdf->SetX(115); $pdf->Cell(85, 0, 'Place of Birth: '.$a->placeofbirth, 1);
    90. 

  90. $pdf->SetY(70); $pdf->Cell(100, 0, 'Country: '.$a->country, 1);
    91. 

  91. $pdf->SetY(70); $pdf->SetX(115); $pdf->Cell(85,0,'State: '.$a->state,1,1,'L');
    92. 

  92. $pdf->SetY(77); $pdf->Cell(100, 0, 'L.G.A.: '.$a->lga, 1);
    93. 

  93. $pdf->SetY(77); $pdf->SetX(115); $pdf->Cell(85, 0, 'Mobile No: '.$a->mobileno, 1);
    94. 

  94. $pdf->SetY(84); $pdf->Cell(100, 0, 'PIN Code: '.$a->appno, 1);
    95. 

  95. $pdf->SetY(84); $pdf->SetX(115); $pdf->Cell(85, 0, 'Teller No: '.$a->tellerno, 1);
    96. 

  96. 

  97. $pdf->SetY(92); $pdf->Write(0, 'SCHOOLS/ACADEMIC INFORMATION', '', 0, 'C', true, 0, false, false, 0);
    98. 

  98. 

  99. $pdf->SetY(97); $pdf->Cell(5, 0, 'SN', 0);	
    100. 

  100. $pdf->SetX(16); $pdf->Cell(70, 0, 'NAME OF SCHOOL', 0,'','C');	$pdf->SetX(87); $pdf->Cell(30, 0, 'DATE FROM', 0,'','C');
    101. 

  101. $pdf->SetX(118); $pdf->Cell(30, 0, 'DATE TO', 0,'','C');			$pdf->SetX(149); $pdf->Cell(51, 0, 'CERTIFICATE', 0,'','C');
    102. 

  102. 

  103. $pdf->SetY(103); $pdf->Cell(5, 0, '1.', 1,'','C');	
    104. 

  104. $pdf->SetX(16); $pdf->Cell(70, 0, $s1[0], 1,'','C');	$pdf->SetX(87); $pdf->Cell(30, 0, $s1[1], 1,'','C');
    105. 

  105. $pdf->SetX(118); $pdf->Cell(30, 0,$s1[2], 1,'','C');			$pdf->SetX(149); $pdf->Cell(51, 0,$s1[3], 1,'','C');
    106. 

  106. 

  107. $pdf->SetY(109); $pdf->Cell(5, 0, '2.', 1,'','C');	
    108. 

  108. $pdf->SetX(16); $pdf->Cell(70, 0,$s2[0], 1,'','C');	$pdf->SetX(87); $pdf->Cell(30, 0,$s2[1], 1,'','C');
    109. 

  109. $pdf->SetX(118); $pdf->Cell(30, 0,$s2[2], 1,'','C');			$pdf->SetX(149); $pdf->Cell(51, 0,$s2[3], 1,'','C');
    110. 

  110. 

  111. $pdf->SetY(115); $pdf->Cell(5, 0, '3.', 1,'','C');	
    112. 

  112. $pdf->SetX(16); $pdf->Cell(70, 0,$s3[0], 1,'','C');	$pdf->SetX(87); $pdf->Cell(30, 0,$s3[1], 1,'','C');
    113. 

  113. $pdf->SetX(118); $pdf->Cell(30, 0,$s3[2], 1,'','C');			$pdf->SetX(149); $pdf->Cell(51, 0,$s3[3], 1,'','C');
    114. 

  114. 

  115. $pdf->SetY(121); $pdf->Cell(5, 0, '4.', 1,'','C');	
    116. 

  116. $pdf->SetX(16); $pdf->Cell(70, 0,$s4[0], 1,'','C');	$pdf->SetX(87); $pdf->Cell(30, 0,$s4[1], 1,'','C');
    117. 

  117. $pdf->SetX(118); $pdf->Cell(30, 0,$s4[2], 1,'','C');			$pdf->SetX(149); $pdf->Cell(51, 0,$s4[3], 1,'','C');
    118. 

  118. 

  119. $pdf->SetY(127); $pdf->Cell(5, 0, '5.', 1);	
    120. 

  120. $pdf->SetX(16); $pdf->Cell(70, 0,$s5[0], 1,'','C');	$pdf->SetX(87); $pdf->Cell(30, 0,$s5[1], 1,'','C');
    121. 

  121. $pdf->SetX(118); $pdf->Cell(30, 0,$s5[2], 1,'','C');			$pdf->SetX(149); $pdf->Cell(51, 0,$s5[3], 1,'','C');
    122. 

  122. 

  123. $pdf->SetY(133); $pdf->Write(0, 'EXAMINATION INFORMATION', '', 0, 'C', true, 0, false, false, 0);
    124. 

  124. $pdf->SetY(138); $pdf->Cell(93, 0, 'EXAM 1: '.$e1[0], 1,'','C');//	$pdf->SetX(60); $pdf->Cell(40, 0, 'EXAMNO: '.$ee1[3], 1);
    125. 

  125. $pdf->SetX(108); $pdf->Cell(92, 0, 'EXAM 2: '.$e2[0], 1,'','C');//	$pdf->SetX(160); $pdf->Cell(40, 0, 'EXAMNO: '.$ee2[3], 1);	
    126. 

  126. 

  127. $_SESSION['y']=144;
    128. 

  128. for($i=1;$i<=9;$i++) { 
    129. 

  129. $pdf->SetY($_SESSION['y']); $pdf->Cell(6, 0, $i.'.', 1); 
    130. 

  130. $pdf->SetX(17); $pdf->Cell(70, 0,substr($e1[$i],0,strpos($e1[$i],'=')), 1,'','C');	
    131. 

  131. $pdf->SetX(88); $pdf->Cell(15, 0,substr($e1[$i],strpos($e1[$i],'=')+1), 1,'','C'); 
    132. 

  132. 

  133. $pdf->SetX(108); $pdf->Cell(5, 0, $i.'.', 1);	
    134. 

  134. $pdf->SetX(114); $pdf->Cell(70, 0,substr($e2[$i],0,strpos($e2[$i],'=')), 1,'','C'); 
    135. 

  135. $pdf->SetX(185); $pdf->Cell(15, 0,substr($e2[$i],strpos($e2[$i],'=')+1), 1);
    136. 

  136. $_SESSION['y']=$_SESSION['y']+6;
    137. 

  137. }
    138. 

  138. 

  139. $pdf->SetY(199); $pdf->Write(0, 'CONTACT INFORMATION', '', 0, 'C', true, 0, false, false, 0);
    140. 

  140. $pdf->SetY(203); $pdf->Cell(100,0,'Next of Kin Name: '.$a->nkname,1);
    141. 

  141. $pdf->SetY(203); $pdf->SetX(115); $pdf->Cell(85, 0, 'Next of Kin Type: '.$a->nktype, 1);
    142. 

  142. $pdf->SetY(209); $pdf->Cell(100, 0, 'Next of Kin Address: '.$a->address,1);
    143. 

  143. $pdf->SetY(209); $pdf->SetX(115); $pdf->Cell(85, 0, 'Next of Kin Mobile No: '.$a->nkmobileno, 1);
    144. 

  144. $pdf->SetY(215); $pdf->Cell(100, 0, 'Sponsor Name: '.$a->spname,1);
    145. 

  145. $pdf->SetY(215); $pdf->SetX(115); $pdf->Cell(85, 0, 'Sponsor Type: '.$a->sptype, 1);
    146. 

  146. $pdf->SetY(221); $pdf->Cell(190, 0, 'Sponsor Address: '.$a->spaddress, 1,'','C');
    147. 

  147. 

  148. $pdf->SetY(228); $pdf->Write(0, 'APPLICATION INFORMATION', '', 0, 'C', true, 0, false, false, 0);
    149. 

  149. $pdf->SetY(233); $pdf->Cell(190, 0, 'Programme First Choice: '.$a->programme1, 1,'','C');
    150. 

  150. $pdf->SetY(239); $pdf->Cell(190, 0, 'Programme Second Choice: '.$a->programme2, 1,'','C');
    151. 

  151. $pdf->SetY(245); $pdf->Cell(190, 0, 'Programme Third Choice: '.$a->programme3, 1,'','C');
    152. 

  152. //$pdf->SetY(253); $pdf->Cell(190, 0, 'User ID: 1   PIN Number: '.$a->pincode.'   Teller Number: 0123456789', 1,'','C');
    153. 

  153. //$pdf->SetY(255); $pdf->Cell(190, 15, 'Decalaration: ', 1);
    154. 

  154. $pdf->SetY(255);
    155. 

  155. $style = array(
    156. 

  156. 	'position' => 'C',
    157. 

  157. 	'align' => 'C',
    158. 

  158. 	'stretch' => false,
    159. 

  159. 	'fitwidth' => true,
    160. 

  160. 	'cellfitalign' => '',
    161. 

  161. 	'border' => true,
    162. 

  162. 	'hpadding' => 'auto',
    163. 

  163. 	'vpadding' => 'auto',
    164. 

  164. 	'fgcolor' => array(0,0,0),
    165. 

  165. 	'bgcolor' => false, //array(255,255,255),
    166. 

  166. 	'text' => false,
    167. 

  167. 	'font' => 'helvetica',
    168. 

  168. 	'fontsize' => 10,
    169. 

  169. 	'stretchtext' => 4);
    170. 

  170. $pdf->write1DBarcode($ap->appno, 'C39E+', '', '', '', 16, 0.4, $style, 'C');
    171. 

  171. }
    172. 

  172. //$pdf->lastPage();
    173. 

  173. $pdf->Output('AGP ePortal Application Forms.', 'D');
    174.