-
Notifications
You must be signed in to change notification settings - Fork 0
/
PatternGenAgreement.php
116 lines (109 loc) · 4.16 KB
/
PatternGenAgreement.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<?php
session_name("user");
session_start();
include ("MySQL/MysqlConnect.php");
require('fpdf.php');
require('fpdi/fpdi.php');
$months=array("01"=>"ñ³÷íÿ", "02"=>"ëþòîãî", "03"=>"áåðåçíÿ", "04"=>"êâ³òíÿ", "05"=>"òðàâíÿ", "06"=>"÷åðâíÿ", "07"=>"ëèïíÿ", "08"=>"ñåðïíÿ", "09"=>"âåðåñíÿ", "10"=>"æîâòíÿ", "11"=>"ëèñòîïàäà", "12"=>"ãðóäíÿ");
$id=intval($_GET['id']);
if ($id<1 || !isset($_SESSION['login']))
{
print "<meta http-equiv=\"Refresh\" content=\"0;URL=index.php\">";
exit();
}
// äåëàåì çàïðîñ ê ÁÄ è èùåì ñîîòâåòñòâèå þçåðà àáèòóðèåíòó
if ($_SESSION['status']=="user")
{
$query = "SELECT * FROM `abiturients` WHERE `ab_id`='".$id."' AND `operator` = '".$_SESSION["user_id"]."' LIMIT 1";
$sql = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($sql) == 1)
{
$row = mysql_fetch_assoc($sql);
}
else
{
print "<meta http-equiv=\"Refresh\" content=\"0;URL=MainPage.php\">";
exit();
}
}
if ($_SESSION['status']=="admin")
{
$query = "SELECT * FROM `abiturients` WHERE `ab_id` = '".$id."'";
$sql = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($sql) == 1) $row = mysql_fetch_assoc($sql);
}
$pdf = new FPDI();
$pageCount = $pdf->setSourceFile("img/ugoda2014.pdf");
$pageNo = 1;
$templateId = $pdf->importPage($pageNo);
$size = $pdf->getTemplateSize($templateId);
$pdf->AddPage('P', array($size['w'], $size['h']));
$pdf->useTemplate($templateId);
$pdf->AddFont('Times','','times.php');
$pdf->SetFont('Times','',10);
$pdf->SetTextColor(0,0,0);
$pdf->SetFontSize(11);
$pdf->SetXY (35,61);
$pdf->Write(5,$row['lastname']." ".$row['firstname']." ".$row['patronymic']);
$pdf->SetXY (55,70);
if ($row['type']=="mag") $pdf->Write(5,"6-é êóðñ, ".$row['faculty']);
if ($row['type']=="spc") $pdf->Write(5,"5-é êóðñ ".$row['faculty']);
if ($row['study_type']=="Äåííà") $type=", äåííà ôîðìà íàâ÷àííÿ";
if ($row['study_type']=="Çàî÷íà") $type=", çàî÷íà ôîðìà íàâ÷àííÿ";
$pdf->SetXY (68,76);
if ($row['type']=="mag") $pdf->Write(5,"ìàã³ñòð".$type);
if ($row['type']=="spc") $pdf->Write(5,"ñïåö³àë³ñò".$type);
$pdf->SetXY (45,82);
$pdf->Write(5, str_replace($row['faculty'], "", $row['training']));
$pdf->SetXY (38,88);
$pdf->Write(5,$row['speciality']);
$pdf->SetXY (15,100);
$pdf->Write(5,$row['speciality']);
$pdf->SetFontSize(10);
$pdf->SetXY (15,150);
$pdf->Write(5,str_replace($row['faculty'], "", $row['training']).", ñïåö³àëüí³ñòþ ".$row['speciality']);
if ($row['study_type']=="Äåííà")
$query2 = "SELECT `ending_date_stc` FROM `specialities` WHERE `speciality_name`='".$row['speciality']."'";
if ($row['study_type']=="Çàî÷íà")
$query2 = "SELECT `ending_date_zao` FROM `specialities` WHERE `speciality_name`='".$row['speciality']."'";
$sql2 = mysql_query($query2) or die(mysql_error());
if (mysql_num_rows($sql2)>0) $row2 = mysql_fetch_assoc($sql2);
if ($row['study_type']=="Äåííà")
{
$pdf->SetFontSize(11);
$pdf->SetXY (110,197);
$pdf->Write(5,date("d", $row2['ending_date_stc']));
$pdf->SetXY (125,197);
$pdf->Write(5,$months[date("m", $row2['ending_date_stc'])]);
$pdf->SetXY (163,197);
$pdf->Write(5,date("y", $row2['ending_date_stc']));
}
if ($row['study_type']=="Çàî÷íà")
{
$pdf->SetFontSize(11);
$pdf->SetXY (110,197);
$pdf->Write(5,date("d", $row2['ending_date_zao']));
$pdf->SetXY (125,197);
$pdf->Write(5,$months[date("m", $row2['ending_date_zao'])]);
$pdf->SetXY (163,197);
$pdf->Write(5,date("y", $row2['ending_date_zao']));
}
if ($row['flat_number']!="") $row['build_number'] = $row['build_number']." êâ. ".$row['flat_number'];
$pdf->SetFontSize(10);
$pdf->SetXY (37,225);
$address = array();
$address[] = $row['nationality'];
$address[] = $row['state'];
$address[] = $row['district'];
$address[] = $row['city'];
$address[] = $row['street'] .' '. $row['build_number'];
$address[] = "òåë. " . $row['phone'];
$pdf->Write(5,implode(', ', array_filter($address)));
$pdf->SetXY (37,234);
$pdf->Write(5,$row['pasp_serial']." ".$row['pasp_number']);
$pdf->SetXY (27,243);
$pdf->Write(5,"âèäàíèé ".$row['pasp_issue']." ".date("d.m.Y", $row['pasp_date']));
$pdf->SetFontSize(8);
//Output the document
$pdf->Output("agreement.pdf", "I");
?>